DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on FND_MSG_PUB

Line 136: FND_MSG_PUB.Initialize;

132:
133: -- Initialize message list if p_init_msg_list is set to TRUE
134: IF FND_API.To_Boolean(p_init_msg_list)
135: THEN
136: FND_MSG_PUB.Initialize;
137: END IF;
138:
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:

Line 153: x_msg_count := FND_MSG_PUB.count_msg;

149:
150: VALIDATE_PC_HEADER(p_x_pc_header_rec);
151:
152: -- Check Error Message stack.
153: x_msg_count := FND_MSG_PUB.count_msg;
154: IF x_msg_count > 0
155: THEN
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;

Line 212: x_msg_count := FND_MSG_PUB.count_msg;

208: AHL_DEBUG_PUB.debug('PCH -- PVT -- Created Header for ID='||p_x_pc_header_rec.PC_HEADER_ID);
209: END IF;
210:
211: -- Check Error Message stack.
212: x_msg_count := FND_MSG_PUB.count_msg;
213: IF x_msg_count > 0
214: THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;

Line 225: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

221: COMMIT WORK;
222: END IF;
223:
224: -- Standard call to get message count and if count is 1, get message info
225: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
226: p_data => x_msg_data,
227: p_encoded => fnd_api.g_false );
228:
229: EXCEPTION

Line 233: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: Rollback to CREATE_PC_HEADER_PVT;
233: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
234: p_data => x_msg_data,
235: p_encoded => fnd_api.g_false);
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 240: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: Rollback to CREATE_PC_HEADER_PVT;
240: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
241: p_data => x_msg_data,
242: p_encoded => fnd_api.g_false);
243:
244: WHEN OTHERS THEN

Line 247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

243:
244: WHEN OTHERS THEN
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: Rollback to CREATE_PC_HEADER_PVT;
247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
250: p_procedure_name => 'CREATE_PC_HEADER',
251: p_error_text => SUBSTR(SQLERRM,1,240));

Line 249: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: Rollback to CREATE_PC_HEADER_PVT;
247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
250: p_procedure_name => 'CREATE_PC_HEADER',
251: p_error_text => SUBSTR(SQLERRM,1,240));
252: END IF;
253: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 253: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

249: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
250: p_procedure_name => 'CREATE_PC_HEADER',
251: p_error_text => SUBSTR(SQLERRM,1,240));
252: END IF;
253: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
254: p_data => x_msg_data,
255: p_encoded => fnd_api.g_false);
256:
257: END CREATE_PC_HEADER;

Line 306: FND_MSG_PUB.Initialize;

302:
303: -- Initialize message list if p_init_msg_list is set to TRUE
304: IF FND_API.To_Boolean(p_init_msg_list)
305: THEN
306: FND_MSG_PUB.Initialize;
307: END IF;
308:
309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310:

Line 330: FND_MSG_PUB.ADD;

326: l_is_dup_assos := GET_DUP_UNIT_ITEM_ASSOS (p_x_pc_header_rec.pc_header_id);
327: IF (l_is_dup_assos)
328: THEN
329: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');
330: FND_MSG_PUB.ADD;
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
333: END IF;
334: END IF;

Line 368: x_msg_count := FND_MSG_PUB.count_msg;

364:
365: IF p_x_pc_header_rec.OPERATION_FLAG = AHL_PC_HEADER_PVT.G_DML_LINK
366: THEN
367: -- Check Error Message stack.
368: x_msg_count := FND_MSG_PUB.count_msg;
369: IF x_msg_count > 0
370: THEN
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;

Line 381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

377: COMMIT WORK;
378: END IF;
379:
380: -- Standard call to get message count and if count is 1, get message info
381: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false );
384:
385: RETURN;

Line 392: x_msg_count := FND_MSG_PUB.count_msg;

388: END IF;
389: END IF;
390:
391: -- Check Error Message stack.
392: x_msg_count := FND_MSG_PUB.count_msg;
393: IF x_msg_count > 0
394: THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;

Line 437: x_msg_count := FND_MSG_PUB.count_msg;

433: AHL_DEBUG_PUB.debug('PCH -- PVT -- UPDATE_PC_HEADER -- After DB Update');
434: END IF;
435:
436: -- Check Error Message stack.
437: x_msg_count := FND_MSG_PUB.count_msg;
438: IF x_msg_count > 0
439: THEN
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;

Line 450: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

446: COMMIT WORK;
447: END IF;
448:
449: -- Standard call to get message count and if count is 1, get message info
450: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
451: p_data => x_msg_data,
452: p_encoded => fnd_api.g_false );
453:
454: EXCEPTION

Line 458: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: Rollback to UPDATE_PC_HEADER_PVT;
458: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
459: p_data => x_msg_data,
460: p_encoded => fnd_api.g_false );
461:
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 465: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

461:
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: Rollback to UPDATE_PC_HEADER_PVT;
465: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
466: p_data => x_msg_data,
467: p_encoded => fnd_api.g_false );
468:
469: WHEN OTHERS THEN

Line 472: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

468:
469: WHEN OTHERS THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: Rollback to UPDATE_PC_HEADER_PVT;
472: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
473: THEN
474: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
475: p_procedure_name => 'UPDATE_PC_HEADER',
476: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 474: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: Rollback to UPDATE_PC_HEADER_PVT;
472: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
473: THEN
474: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
475: p_procedure_name => 'UPDATE_PC_HEADER',
476: p_error_text => SUBSTR(SQLERRM,1,240) );
477: END IF;
478: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 478: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

474: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
475: p_procedure_name => 'UPDATE_PC_HEADER',
476: p_error_text => SUBSTR(SQLERRM,1,240) );
477: END IF;
478: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
479: p_data => x_msg_data,
480: p_encoded => fnd_api.g_false );
481:
482: END UPDATE_PC_HEADER;

Line 546: FND_MSG_PUB.Initialize;

542:
543: -- Initialize message list if p_init_msg_list is set to TRUE
544: IF FND_API.To_Boolean(p_init_msg_list)
545: THEN
546: FND_MSG_PUB.Initialize;
547: END IF;
548:
549: x_return_status := FND_API.G_RET_STS_SUCCESS;
550:

Line 560: FND_MSG_PUB.ADD;

556: FETCH check_header_status INTO l_status;
557: IF(check_header_status%NOTFOUND)
558: THEN
559: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
560: FND_MSG_PUB.ADD;
561: CLOSE check_header_status;
562: RAISE FND_API.G_EXC_ERROR;
563: ELSE
564: CLOSE check_header_status;

Line 568: FND_MSG_PUB.ADD;

564: CLOSE check_header_status;
565: IF (l_status <> 'DRAFT' AND l_status <> 'APPROVAL_REJECTED')
566: THEN
567: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DRAFT_DELETE');
568: FND_MSG_PUB.ADD;
569: RAISE FND_API.G_EXC_ERROR;
570: ELSE
571:
572: l_link_to_header_id := 0;

Line 607: x_msg_count := FND_MSG_PUB.count_msg;

603: -- Added error handling after the Delete_Nodes API is called.
604: -- Check Error Message stack.
605: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
606: THEN
607: x_msg_count := FND_MSG_PUB.count_msg;
608: IF x_msg_count > 0 THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: END IF;

Line 692: x_msg_count := FND_MSG_PUB.count_msg;

688: AHL_DEBUG_PUB.debug('PCH -- PVT -- DELETE_PC_HEADER -- After DB Delete');
689: END IF;
690:
691: -- Check Error Message stack.
692: x_msg_count := FND_MSG_PUB.count_msg;
693: IF x_msg_count > 0
694: THEN
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;

Line 705: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

701: COMMIT WORK;
702: END IF;
703:
704: -- Standard call to get message count and if count is 1, get message info
705: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false );
708:
709: EXCEPTION

Line 713: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: Rollback to DELETE_PC_HEADER_PVT;
713: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
714: p_data => x_msg_data,
715: p_encoded => fnd_api.g_false );
716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 720: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

716:
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
719: Rollback to DELETE_PC_HEADER_PVT;
720: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
721: p_data => x_msg_data,
722: p_encoded => fnd_api.g_false );
723:
724: WHEN OTHERS THEN

Line 727: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

723:
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: Rollback to DELETE_PC_HEADER_PVT;
727: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
728: THEN
729: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
730: p_procedure_name => 'DELETE_PC_HEADER',
731: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 729: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: Rollback to DELETE_PC_HEADER_PVT;
727: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
728: THEN
729: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
730: p_procedure_name => 'DELETE_PC_HEADER',
731: p_error_text => SUBSTR(SQLERRM,1,240) );
732: END IF;
733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

729: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
730: p_procedure_name => 'DELETE_PC_HEADER',
731: p_error_text => SUBSTR(SQLERRM,1,240) );
732: END IF;
733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
734: p_data => x_msg_data,
735: p_encoded => fnd_api.g_false );
736: END DELETE_PC_HEADER;
737:

Line 934: FND_MSG_PUB.Initialize;

930:
931: -- Initialize message list if p_init_msg_list is set to TRUE
932: IF FND_API.To_Boolean(p_init_msg_list)
933: THEN
934: FND_MSG_PUB.Initialize;
935: END IF;
936:
937: x_return_status := FND_API.G_RET_STS_SUCCESS;
938:

Line 952: FND_MSG_PUB.ADD;

948: FETCH check_name_unique INTO l_dummy_2;
949: IF (check_name_unique%FOUND)
950: THEN
951: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');
952: FND_MSG_PUB.ADD;
953: CLOSE check_name_unique;
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956: CLOSE check_name_unique;

Line 972: FND_MSG_PUB.ADD;

968: l_is_dup_assos := GET_DUP_UNIT_ITEM_ASSOS (l_old_header_id);
969: IF (l_is_dup_assos)
970: THEN
971: FND_MESSAGE.Set_Name('AHL','AHL_PC_DUP_UNIT_PART_ASSOS');
972: FND_MSG_PUB.ADD;
973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975: END IF;
976: END IF;

Line 983: FND_MSG_PUB.ADD;

979:
980: IF (l_dummy = FALSE AND p_x_pc_header_rec.COPY_ASSOS_FLAG = 'Y')
981: THEN
982: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');
983: FND_MSG_PUB.ADD;
984: RAISE FND_API.G_EXC_ERROR;
985: END IF;
986:
987: CREATE_PC_HEADER

Line 1002: x_msg_count := FND_MSG_PUB.count_msg;

998: IF G_DEBUG='Y' THEN
999: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- Copied into new PC with ID='||p_x_pc_header_rec.PC_HEADER_ID);
1000: END IF;
1001:
1002: x_msg_count := FND_MSG_PUB.count_msg;
1003: IF x_msg_count > 0
1004: THEN
1005: RAISE FND_API.G_EXC_ERROR;
1006: END IF;

Line 1256: x_msg_count := FND_MSG_PUB.count_msg;

1252: AHL_DEBUG_PUB.debug('PCH -- PVT -- COPY_PC_HEADER -- After Copy PC');
1253: END IF;
1254:
1255: -- Check Error Message stack.
1256: x_msg_count := FND_MSG_PUB.count_msg;
1257: IF x_msg_count > 0
1258: THEN
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;

Line 1269: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1265: COMMIT WORK;
1266: END IF;
1267:
1268: -- Standard call to get message count and if count is 1, get message info
1269: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1270: p_data => x_msg_data,
1271: p_encoded => fnd_api.g_false );
1272:
1273: EXCEPTION

Line 1277: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1273: EXCEPTION
1274: WHEN FND_API.G_EXC_ERROR THEN
1275: x_return_status := FND_API.G_RET_STS_ERROR;
1276: Rollback to COPY_PC_HEADER_PVT;
1277: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1278: p_data => x_msg_data,
1279: p_encoded => fnd_api.g_false );
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1284: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: Rollback to COPY_PC_HEADER_PVT;
1284: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1285: p_data => x_msg_data,
1286: p_encoded => fnd_api.g_false );
1287:
1288: WHEN OTHERS THEN

Line 1291: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1287:
1288: WHEN OTHERS THEN
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: Rollback to COPY_PC_HEADER_PVT;
1291: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1292: THEN
1293: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1294: p_procedure_name => 'COPY_PC_HEADER',
1295: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 1293: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1290: Rollback to COPY_PC_HEADER_PVT;
1291: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1292: THEN
1293: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1294: p_procedure_name => 'COPY_PC_HEADER',
1295: p_error_text => SUBSTR(SQLERRM,1,240) );
1296: END IF;
1297: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1297: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1293: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
1294: p_procedure_name => 'COPY_PC_HEADER',
1295: p_error_text => SUBSTR(SQLERRM,1,240) );
1296: END IF;
1297: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1298: p_data => x_msg_data,
1299: p_encoded => fnd_api.g_false );
1300:
1301: END COPY_PC_HEADER;

Line 1348: FND_MSG_PUB.Initialize;

1344:
1345: -- Initialize message list if p_init_msg_list is set to TRUE
1346: IF FND_API.To_Boolean(p_init_msg_list)
1347: THEN
1348: FND_MSG_PUB.Initialize;
1349: END IF;
1350:
1351: x_return_status := FND_API.G_RET_STS_SUCCESS;
1352:

Line 1401: FND_MSG_PUB.ADD;

1397: -- If no updation happened, record must have already been modified by another user...
1398: IF (sql%rowcount) = 0
1399: THEN
1400: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1401: FND_MSG_PUB.ADD;
1402: RAISE FND_API.G_EXC_ERROR;
1403: -- Else start PCWF workflow process for this PC
1404: ELSE
1405: IF G_DEBUG='Y' THEN

Line 1554: FND_MSG_PUB.ADD;

1550: FETCH check_name into l_dummy;
1551: IF (check_name%FOUND)
1552: THEN
1553: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_EXISTS');
1554: FND_MSG_PUB.ADD;
1555: CLOSE check_name;
1556: RAISE FND_API.G_EXC_ERROR;
1557: END IF;
1558: CLOSE check_name;

Line 1570: FND_MSG_PUB.ADD;

1566: FETCH check_prod_type into l_dummy;
1567: IF (check_prod_type%FOUND)
1568: THEN
1569: FND_MESSAGE.Set_Name('AHL','AHL_PC_PROD_PRIM_EXISTS');
1570: FND_MSG_PUB.ADD;
1571: CLOSE check_prod_type;
1572: RAISE FND_API.G_EXC_ERROR;
1573: END IF;
1574: CLOSE check_prod_type;

Line 1841: FND_MSG_PUB.Initialize;

1837:
1838: -- Initialize message list if p_init_msg_list is set to TRUE
1839: IF FND_API.To_Boolean(p_init_msg_list)
1840: THEN
1841: FND_MSG_PUB.Initialize;
1842: END IF;
1843:
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845:

Line 1880: x_msg_count := FND_MSG_PUB.count_msg;

1876: IF G_DEBUG='Y' THEN
1877: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- New Header ID='||p_x_pc_header_rec.PC_HEADER_ID);
1878: END IF;
1879:
1880: x_msg_count := FND_MSG_PUB.count_msg;
1881: IF x_msg_count > 0
1882: THEN
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;

Line 1986: x_msg_count := FND_MSG_PUB.count_msg;

1982: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_nodeCtr'||l_nodeCtr);
1983: AHL_DEBUG_PUB.debug('PCH -- PVT -- CREATE_LINK -- After call to AHL_PC_NODE_PVT.CREATE_NODE : l_node_data_rec.PC_NODE_ID'|| l_node_rec.PC_NODE_ID);
1984: END IF;
1985:
1986: x_msg_count := FND_MSG_PUB.count_msg;
1987: IF x_msg_count > 0
1988: THEN
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;

Line 2763: FND_MSG_PUB.Initialize;

2759:
2760: -- Initialize message list if p_init_msg_list is set to TRUE
2761: IF FND_API.To_Boolean(p_init_msg_list)
2762: THEN
2763: FND_MSG_PUB.Initialize;
2764: END IF;
2765:
2766: x_return_status := FND_API.G_RET_STS_SUCCESS;
2767:

Line 3489: --FND_MSG_PUB.Add;

3485:
3486: indx := l_diff_mr_item_inst_tbl.NEXT(indx);
3487: END LOOP;
3488:
3489: --FND_MSG_PUB.Add;
3490: -- make a call to the concurrent program AHLPCUEFF to calculate unit
3491: -- effectivities for the new PC
3492: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3493: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_full_name,

Line 3642: FND_MSG_PUB.Initialize;

3638: BEGIN
3639: -- Initialize message list if p_init_msg_list is set to TRUE
3640: IF FND_API.To_Boolean(p_init_msg_list)
3641: THEN
3642: FND_MSG_PUB.Initialize;
3643: END IF;
3644:
3645: x_return_status := FND_API.G_RET_STS_SUCCESS;
3646:

Line 3661: FND_MSG_PUB.ADD;

3657: l_old_assos_type,p_x_pc_header_rec.link_to_pc_id;
3658: IF (check_header_data%NOTFOUND)
3659: THEN
3660: FND_MESSAGE.Set_Name('AHL','AHL_PC_NOT_FOUND');
3661: FND_MSG_PUB.ADD;
3662: CLOSE check_header_data;
3663: RAISE FND_API.G_EXC_ERROR;
3664: END IF;
3665: CLOSE check_header_data;

Line 3670: FND_MSG_PUB.ADD;

3666:
3667: IF l_old_obj_ver_no <> p_x_pc_header_rec.OBJECT_VERSION_NUMBER
3668: THEN
3669: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3670: FND_MSG_PUB.ADD;
3671: RAISE FND_API.G_EXC_ERROR;
3672: END IF;
3673:
3674: l_dummy := VALIDATE_UNIT_PART_ATTACHED (p_x_pc_header_rec.PC_HEADER_ID, p_x_pc_header_rec.PRODUCT_TYPE_CODE, p_x_pc_header_rec.ASSOCIATION_TYPE_FLAG);

Line 3679: FND_MSG_PUB.ADD;

3675:
3676: IF (l_dummy = FALSE)
3677: THEN
3678: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_ATTACHED');
3679: FND_MSG_PUB.ADD;
3680: RAISE FND_API.G_EXC_ERROR;
3681: END IF;
3682:
3683: IF G_DEBUG='Y' THEN

Line 3691: FND_MSG_PUB.ADD;

3687: -- PC is COMPLETE -- User submits without changing to DRAFT -- ERROR
3688: IF p_x_pc_header_rec.STATUS = 'COMPLETE' AND l_old_status = 'COMPLETE'
3689: THEN
3690: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
3691: FND_MSG_PUB.ADD;
3692: RAISE FND_API.G_EXC_ERROR;
3693:
3694: -- PC is APPROVAL_REJECTED -- User submits after making any change -- Change status to DRAFT
3695: ELSIF p_x_pc_header_rec.STATUS = 'APPROVAL_REJECTED' AND l_old_status = 'APPROVAL_REJECTED'