eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_ROUTE_PUB dependencies on FND_MSG_PUB

Line 56: FND_MSG_PUB.initialize;

52: END IF;
53:
54: -- Initialize message list if p_init_msg_list is set to TRUE.
55: IF FND_API.to_boolean( p_init_msg_list ) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
60: fnd_log.string

Line 98: x_msg_count := FND_MSG_PUB.count_msg;

94: p_x_route_rec => p_x_route_rec
95: );
96:
97: -- to raise errors from AHL_RM_ROUTE_PVT.process_ROUTE
98: x_msg_count := FND_MSG_PUB.count_msg;
99:
100: IF x_msg_count > 0 THEN
101: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: RAISE FND_API.G_EXC_ERROR;

Line 116: FND_MSG_PUB.ADD;

112:
113: ElSE
114: -- If the DML operation is not Cretae then its invalid
115: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
116: FND_MSG_PUB.ADD;
117: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
118: fnd_log.string
119: (
120: fnd_log.level_error,

Line 181: x_msg_count := FND_MSG_PUB.count_msg;

177: p_x_association_tbl => p_x_route_doc_tbl
178: );
179:
180: -- to raise errors from AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION
181: x_msg_count := FND_MSG_PUB.count_msg;
182:
183: IF x_msg_count > 0 THEN
184: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: RAISE FND_API.G_EXC_ERROR;

Line 217: x_msg_count := FND_MSG_PUB.count_msg;

213: p_object_id => p_x_route_rec.ROUTE_ID
214: );
215:
216: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
217: x_msg_count := FND_MSG_PUB.count_msg;
218:
219: IF x_msg_count > 0 THEN
220: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: RAISE FND_API.G_EXC_ERROR;

Line 254: x_msg_count := FND_MSG_PUB.count_msg;

250: x_msg_data => x_msg_data,
251: p_x_rt_oper_cost_rec => l_x_rt_oper_cost_rec
252: );
253:
254: x_msg_count := FND_MSG_PUB.count_msg;
255:
256: IF x_msg_count > 0 THEN
257: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: RAISE FND_API.G_EXC_ERROR;

Line 292: x_msg_count := FND_MSG_PUB.count_msg;

288: p_object_id => p_x_route_rec.ROUTE_ID,
289: p_association_type => 'ROUTE'
290: );
291: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
292: x_msg_count := FND_MSG_PUB.count_msg;
293:
294: IF x_msg_count > 0 THEN
295: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296: RAISE FND_API.G_EXC_ERROR;

Line 327: x_msg_count := FND_MSG_PUB.count_msg;

323: p_association_type_code => 'ROUTE',
324: p_object_id => p_x_route_rec.ROUTE_ID
325: );
326: -- to raise errors from AHL_RM_RT_OPER_PANEL_PVT.process_rt_oper_panel
327: x_msg_count := FND_MSG_PUB.count_msg;
328:
329: IF x_msg_count > 0 THEN
330: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
331: RAISE FND_API.G_EXC_ERROR;

Line 362: x_msg_count := FND_MSG_PUB.count_msg;

358: p_route_id => p_x_route_rec.ROUTE_ID
359: );
360:
361: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
362: x_msg_count := FND_MSG_PUB.count_msg;
363:
364: IF x_msg_count > 0 THEN
365: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: RAISE FND_API.G_EXC_ERROR;

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

409: EXCEPTION
410: WHEN FND_API.G_EXC_ERROR THEN
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: Rollback to create_route_pub;
413: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
414: p_data => x_msg_data,
415: p_encoded => fnd_api.g_false);
416:
417:

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

417:
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: Rollback to create_route_pub;
421: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
422: p_data => x_msg_data,
423: p_encoded => fnd_api.g_false);
424:
425: WHEN OTHERS THEN

Line 428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

424:
425: WHEN OTHERS THEN
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: Rollback to create_route_pub;
428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
429: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
430: p_procedure_name => 'CREATE_ROUTE',
431: p_error_text => SQLERRM);
432: END IF;

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

425: WHEN OTHERS THEN
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: Rollback to create_route_pub;
428: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
429: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
430: p_procedure_name => 'CREATE_ROUTE',
431: p_error_text => SQLERRM);
432: END IF;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

429: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
430: p_procedure_name => 'CREATE_ROUTE',
431: p_error_text => SQLERRM);
432: END IF;
433: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => fnd_api.g_false);
436:
437: END Create_Route;

Line 493: FND_MSG_PUB.initialize;

489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_boolean( p_init_msg_list ) THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495:
496:
497: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 573: x_msg_count := FND_MSG_PUB.count_msg;

569: x_msg_data => x_msg_data,
570: p_x_route_rec => l_route_rec
571: );
572: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
573: x_msg_count := FND_MSG_PUB.count_msg;
574:
575: IF x_msg_count > 0 THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: RAISE FND_API.G_EXC_ERROR;

Line 583: FND_MSG_PUB.ADD;

579:
580: ElSIF p_route_rec.DML_OPERATION IS NOT NULL THEN
581: -- If the DML operation is not 'U' and is also not NULL, then throw an error
582: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
583: FND_MSG_PUB.ADD;
584: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
585: fnd_log.string
586: (
587: fnd_log.level_error,

Line 639: x_msg_count := FND_MSG_PUB.count_msg;

635: p_x_association_tbl => p_x_route_doc_tbl
636: );
637:
638: -- to raise errors from AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION
639: x_msg_count := FND_MSG_PUB.count_msg;
640:
641:
642: IF x_msg_count > 0 THEN
643: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 669: x_msg_count := FND_MSG_PUB.count_msg;

665: p_object_id => l_route_id
666: );
667:
668: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
669: x_msg_count := FND_MSG_PUB.count_msg;
670:
671: IF x_msg_count > 0 THEN
672: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: RAISE FND_API.G_EXC_ERROR;

Line 707: x_msg_count := FND_MSG_PUB.count_msg;

703: x_msg_data => x_msg_data,
704: p_x_rt_oper_cost_rec => l_x_rt_oper_cost_rec
705: );
706:
707: x_msg_count := FND_MSG_PUB.count_msg;
708:
709: IF x_msg_count > 0 THEN
710: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: RAISE FND_API.G_EXC_ERROR;

Line 738: x_msg_count := FND_MSG_PUB.count_msg;

734: p_object_id => l_route_id,
735: p_association_type => 'ROUTE'
736: );
737: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
738: x_msg_count := FND_MSG_PUB.count_msg;
739:
740: IF x_msg_count > 0 THEN
741: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: RAISE FND_API.G_EXC_ERROR;

Line 768: x_msg_count := FND_MSG_PUB.count_msg;

764: p_association_type_code => 'ROUTE',
765: p_object_id => l_route_id
766: );
767: -- to raise errors from AHL_RM_RT_OPER_PANEL_PVT.process_rt_oper_panel
768: x_msg_count := FND_MSG_PUB.count_msg;
769:
770: IF x_msg_count > 0 THEN
771: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: RAISE FND_API.G_EXC_ERROR;

Line 796: x_msg_count := FND_MSG_PUB.count_msg;

792: p_route_id => l_route_id
793: );
794:
795: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
796: x_msg_count := FND_MSG_PUB.count_msg;
797:
798: IF x_msg_count > 0 THEN
799: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: RAISE FND_API.G_EXC_ERROR;

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

843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: Rollback to modify_route_pub;
847: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
848: p_data => x_msg_data,
849: p_encoded => fnd_api.g_false);
850:
851:

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

851:
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: Rollback to modify_route_pub;
855: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
856: p_data => x_msg_data,
857: p_encoded => fnd_api.g_false);
858:
859: WHEN OTHERS THEN

Line 862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

858:
859: WHEN OTHERS THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: Rollback to modify_route_pub;
862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
863: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
864: p_procedure_name => 'MODIFY_ROUTE',
865: p_error_text => SQLERRM);
866: END IF;

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

859: WHEN OTHERS THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: Rollback to modify_route_pub;
862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
863: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
864: p_procedure_name => 'MODIFY_ROUTE',
865: p_error_text => SQLERRM);
866: END IF;
867: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

863: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
864: p_procedure_name => 'MODIFY_ROUTE',
865: p_error_text => SQLERRM);
866: END IF;
867: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
868: p_data => x_msg_data,
869: p_encoded => fnd_api.g_false);
870:
871: END Modify_Route;

Line 921: FND_MSG_PUB.initialize;

917: END IF;
918:
919: -- Initialize message list if p_init_msg_list is set to TRUE.
920: IF FND_API.to_boolean( p_init_msg_list ) THEN
921: FND_MSG_PUB.initialize;
922: END IF;
923:
924: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
925: fnd_log.string

Line 996: x_msg_count := FND_MSG_PUB.count_msg;

992: p_route_id => l_route_id,
993: p_object_version_number => p_route_object_version
994: );
995: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
996: x_msg_count := FND_MSG_PUB.count_msg;
997:
998: IF x_msg_count > 0 THEN
999: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: RAISE FND_API.G_EXC_ERROR;

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

1042: EXCEPTION
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: Rollback to delete_route_pub;
1046: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1047: p_data => x_msg_data,
1048: p_encoded => fnd_api.g_false);
1049:
1050:

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

1050:
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: Rollback to delete_route_pub;
1054: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1055: p_data => x_msg_data,
1056: p_encoded => fnd_api.g_false);
1057:
1058: WHEN OTHERS THEN

Line 1061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1057:
1058: WHEN OTHERS THEN
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: Rollback to delete_route_pub;
1061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1062: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1063: p_procedure_name => 'DELETE_ROUTE',
1064: p_error_text => SQLERRM);
1065: END IF;

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

1058: WHEN OTHERS THEN
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: Rollback to delete_route_pub;
1061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1062: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1063: p_procedure_name => 'DELETE_ROUTE',
1064: p_error_text => SQLERRM);
1065: END IF;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1062: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1063: p_procedure_name => 'DELETE_ROUTE',
1064: p_error_text => SQLERRM);
1065: END IF;
1066: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1067: p_data => x_msg_data,
1068: p_encoded => fnd_api.g_false);
1069:
1070: END Delete_Route;

Line 1123: FND_MSG_PUB.initialize;

1119: END IF;
1120:
1121: -- Initialize message list if p_init_msg_list is set to TRUE.
1122: IF FND_API.to_boolean( p_init_msg_list ) THEN
1123: FND_MSG_PUB.initialize;
1124: END IF;
1125:
1126:
1127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1197: FND_MSG_PUB.add;

1193:
1194: IF l_x_route_efct_tbl(1).ROUTE_EFFECTIVITY_ID IS NULL
1195: THEN
1196: FND_MESSAGE.set_Name('AHL','AHL_RM_PUB_EFFEC_ID_NULL');
1197: FND_MSG_PUB.add;
1198: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1199: fnd_log.string
1200: (
1201: fnd_log.level_error,

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

1265: EXCEPTION
1266: WHEN FND_API.G_EXC_ERROR THEN
1267: x_return_status := FND_API.G_RET_STS_ERROR;
1268: Rollback to route_disp_pub;
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:

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

1273:
1274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1276: Rollback to route_disp_pub;
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 OTHERS THEN

Line 1284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1280:
1281: WHEN OTHERS THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: Rollback to route_disp_pub;
1284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1285: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1286: p_procedure_name => 'PROCESS_ROUTE_DISPOSITION',
1287: p_error_text => SQLERRM);
1288: END IF;

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

1281: WHEN OTHERS THEN
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1283: Rollback to route_disp_pub;
1284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1285: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1286: p_procedure_name => 'PROCESS_ROUTE_DISPOSITION',
1287: p_error_text => SQLERRM);
1288: END IF;
1289: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1285: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1286: p_procedure_name => 'PROCESS_ROUTE_DISPOSITION',
1287: p_error_text => SQLERRM);
1288: END IF;
1289: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1290: p_data => x_msg_data,
1291: p_encoded => fnd_api.g_false);
1292:
1293: END Process_Route_Dispositions;

Line 1346: FND_MSG_PUB.initialize;

1342:
1343:
1344: -- Initialize message list if p_init_msg_list is set to TRUE.
1345: IF FND_API.to_boolean( p_init_msg_list ) THEN
1346: FND_MSG_PUB.initialize;
1347: END IF;
1348:
1349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1350: fnd_log.string

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

1449: EXCEPTION
1450: WHEN FND_API.G_EXC_ERROR THEN
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452: Rollback to create_route_revision_pub;
1453: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1454: p_data => x_msg_data,
1455: p_encoded => fnd_api.g_false);
1456:
1457:

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

1457:
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: Rollback to create_route_revision_pub;
1461: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1462: p_data => x_msg_data,
1463: p_encoded => fnd_api.g_false);
1464:
1465: WHEN OTHERS THEN

Line 1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1464:
1465: WHEN OTHERS THEN
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1467: Rollback to create_route_revision_pub;
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1469: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1470: p_procedure_name => 'create_route_revision',
1471: p_error_text => SQLERRM);
1472: END IF;

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

1465: WHEN OTHERS THEN
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1467: Rollback to create_route_revision_pub;
1468: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1469: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1470: p_procedure_name => 'create_route_revision',
1471: p_error_text => SQLERRM);
1472: END IF;
1473: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1469: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1470: p_procedure_name => 'create_route_revision',
1471: p_error_text => SQLERRM);
1472: END IF;
1473: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1474: p_data => x_msg_data,
1475: p_encoded => fnd_api.g_false);
1476:
1477:

Line 1529: FND_MSG_PUB.initialize;

1525: END IF;
1526:
1527: -- Initialize message list if p_init_msg_list is set to TRUE.
1528: IF FND_API.to_boolean( p_init_msg_list ) THEN
1529: FND_MSG_PUB.initialize;
1530: END IF;
1531:
1532: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1533: fnd_log.string

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

1632: EXCEPTION
1633: WHEN FND_API.G_EXC_ERROR THEN
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: Rollback to initiate_route_approval_pub;
1636: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1637: p_data => x_msg_data,
1638: p_encoded => fnd_api.g_false);
1639:
1640:

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

1640:
1641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: Rollback to initiate_route_approval_pub;
1644: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1645: p_data => x_msg_data,
1646: p_encoded => fnd_api.g_false);
1647:
1648: WHEN OTHERS THEN

Line 1651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1647:
1648: WHEN OTHERS THEN
1649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1650: Rollback to initiate_route_approval_pub;
1651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1652: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1653: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1654: p_error_text => SQLERRM);
1655: END IF;

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

1648: WHEN OTHERS THEN
1649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1650: Rollback to initiate_route_approval_pub;
1651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1652: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1653: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1654: p_error_text => SQLERRM);
1655: END IF;
1656: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1652: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1653: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1654: p_error_text => SQLERRM);
1655: END IF;
1656: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1657: p_data => x_msg_data,
1658: p_encoded => fnd_api.g_false);
1659:
1660: END Initiate_Route_Approval;

Line 1706: FND_MSG_PUB.initialize;

1702: END IF;
1703:
1704: -- Initialize message list if p_init_msg_list is set to TRUE.
1705: IF FND_API.to_boolean( p_init_msg_list ) THEN
1706: FND_MSG_PUB.initialize;
1707: END IF;
1708:
1709: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1710: fnd_log.string

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

1809: EXCEPTION
1810: WHEN FND_API.G_EXC_ERROR THEN
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812: Rollback to process_route_operation_as_pub;
1813: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1814: p_data => x_msg_data,
1815: p_encoded => fnd_api.g_false);
1816:
1817:

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

1817:
1818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820: Rollback to process_route_operation_as_pub;
1821: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1822: p_data => x_msg_data,
1823: p_encoded => fnd_api.g_false);
1824:
1825: WHEN OTHERS THEN

Line 1828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1824:
1825: WHEN OTHERS THEN
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: Rollback to process_route_operation_as_pub;
1828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1829: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1830: p_procedure_name => 'Process_Route_Oper_Assoc',
1831: p_error_text => SQLERRM);
1832: END IF;

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

1825: WHEN OTHERS THEN
1826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1827: Rollback to process_route_operation_as_pub;
1828: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1829: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1830: p_procedure_name => 'Process_Route_Oper_Assoc',
1831: p_error_text => SQLERRM);
1832: END IF;
1833: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1829: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1830: p_procedure_name => 'Process_Route_Oper_Assoc',
1831: p_error_text => SQLERRM);
1832: END IF;
1833: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1834: p_data => x_msg_data,
1835: p_encoded => fnd_api.g_false);
1836:
1837: END Process_Route_Oper_Assoc;

Line 1915: FND_MSG_PUB.initialize;

1911: END IF;
1912:
1913: -- Initialize message list if p_init_msg_list is set to TRUE.
1914: IF FND_API.to_boolean( p_init_msg_list ) THEN
1915: FND_MSG_PUB.initialize;
1916: END IF;
1917:
1918: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1919: fnd_log.string

Line 1974: FND_MSG_PUB.add;

1970: IF get_res_id%NOTFOUND THEN
1971: -- PRITHWI : please run this message and check what it displays.
1972: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ASO_RES_ID' );
1973: FND_MESSAGE.set_token( 'RECORD', p_resource_name );
1974: FND_MSG_PUB.add;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978: CLOSE get_res_id;

Line 1988: FND_MSG_PUB.add;

1984: FETCH get_rt_oper_resource INTO l_rt_oper_resource_id;
1985: IF get_rt_oper_resource%NOTFOUND THEN
1986: -- PRITHWI : please run this message and check what it displays.
1987: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );
1988: FND_MSG_PUB.add;
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: CLOSE get_rt_oper_resource;

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

2071: EXCEPTION
2072: WHEN FND_API.G_EXC_ERROR THEN
2073: x_return_status := FND_API.G_RET_STS_ERROR;
2074: Rollback to Process_Alt_Resources;
2075: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2076: p_data => x_msg_data,
2077: p_encoded => fnd_api.g_false);
2078:
2079:

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

2079:
2080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2082: Rollback to Process_Alt_Resources;
2083: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2084: p_data => x_msg_data,
2085: p_encoded => fnd_api.g_false);
2086:
2087: WHEN OTHERS THEN

Line 2090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2086:
2087: WHEN OTHERS THEN
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2089: Rollback to Process_Alt_Resources;
2090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2091: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2092: p_procedure_name => 'Process_Route_Alt_Resources',
2093: p_error_text => SQLERRM);
2094: END IF;

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

2087: WHEN OTHERS THEN
2088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2089: Rollback to Process_Alt_Resources;
2090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2091: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2092: p_procedure_name => 'Process_Route_Alt_Resources',
2093: p_error_text => SQLERRM);
2094: END IF;
2095: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

2091: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2092: p_procedure_name => 'Process_Route_Alt_Resources',
2093: p_error_text => SQLERRM);
2094: END IF;
2095: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2096: p_data => x_msg_data,
2097: p_encoded => fnd_api.g_false);
2098:
2099: END Process_Route_Alt_Resources;