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 506: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

502: --
503: EXCEPTION
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
507: p_data => x_msg_data,
508: p_encoded => fnd_api.g_false);
509:
510: WHEN OTHERS THEN

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

508: p_encoded => fnd_api.g_false);
509:
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
513: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
514: p_procedure_name => 'CREATE_ROUTE',
515: p_error_text => SQLERRM);
516: END IF;

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

509:
510: WHEN OTHERS THEN
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
513: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
514: p_procedure_name => 'CREATE_ROUTE',
515: p_error_text => SQLERRM);
516: END IF;
517: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

513: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
514: p_procedure_name => 'CREATE_ROUTE',
515: p_error_text => SQLERRM);
516: END IF;
517: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
518: p_data => x_msg_data,
519: p_encoded => fnd_api.g_false);
520:
521: END Create_Route;

Line 575: FND_MSG_PUB.initialize;

571: END IF;
572:
573: -- Initialize message list if p_init_msg_list is set to TRUE.
574: IF FND_API.to_boolean( p_init_msg_list ) THEN
575: FND_MSG_PUB.initialize;
576: END IF;
577:
578:
579: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 655: x_msg_count := FND_MSG_PUB.count_msg;

651: x_msg_data => x_msg_data,
652: p_x_route_rec => l_route_rec
653: );
654: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
655: x_msg_count := FND_MSG_PUB.count_msg;
656:
657: IF x_msg_count > 0 THEN
658: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: RAISE FND_API.G_EXC_ERROR;

Line 665: FND_MSG_PUB.ADD;

661:
662: ElSIF p_route_rec.DML_OPERATION IS NOT NULL THEN
663: -- If the DML operation is not 'U' and is also not NULL, then throw an error
664: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
665: FND_MSG_PUB.ADD;
666: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
667: fnd_log.string
668: (
669: fnd_log.level_error,

Line 721: x_msg_count := FND_MSG_PUB.count_msg;

717: p_x_association_tbl => p_x_route_doc_tbl
718: );
719:
720: -- to raise errors from AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION
721: x_msg_count := FND_MSG_PUB.count_msg;
722:
723:
724: IF x_msg_count > 0 THEN
725: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 751: x_msg_count := FND_MSG_PUB.count_msg;

747: p_object_id => l_route_id
748: );
749:
750: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
751: x_msg_count := FND_MSG_PUB.count_msg;
752:
753: IF x_msg_count > 0 THEN
754: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: RAISE FND_API.G_EXC_ERROR;

Line 792: x_msg_count := FND_MSG_PUB.count_msg;

788: x_msg_data => x_msg_data,
789: p_x_rt_oper_cost_rec => l_x_rt_oper_cost_rec
790: );
791:
792: x_msg_count := FND_MSG_PUB.count_msg;
793:
794: IF x_msg_count > 0 THEN
795: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: RAISE FND_API.G_EXC_ERROR;

Line 824: x_msg_count := FND_MSG_PUB.count_msg;

820: p_object_id => l_route_id,
821: p_association_type => 'ROUTE'
822: );
823: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
824: x_msg_count := FND_MSG_PUB.count_msg;
825:
826: IF x_msg_count > 0 THEN
827: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: RAISE FND_API.G_EXC_ERROR;

Line 854: x_msg_count := FND_MSG_PUB.count_msg;

850: p_association_type_code => 'ROUTE',
851: p_object_id => l_route_id
852: );
853: -- to raise errors from AHL_RM_RT_OPER_PANEL_PVT.process_rt_oper_panel
854: x_msg_count := FND_MSG_PUB.count_msg;
855:
856: IF x_msg_count > 0 THEN
857: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: RAISE FND_API.G_EXC_ERROR;

Line 882: x_msg_count := FND_MSG_PUB.count_msg;

878: p_route_id => l_route_id
879: );
880:
881: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
882: x_msg_count := FND_MSG_PUB.count_msg;
883:
884: IF x_msg_count > 0 THEN
885: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
886: RAISE FND_API.G_EXC_ERROR;

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

929: EXCEPTION
930: WHEN FND_API.G_EXC_ERROR THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: Rollback to modify_route_pub;
933: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
934: p_data => x_msg_data,
935: p_encoded => fnd_api.g_false);
936:
937:

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

937:
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
940: Rollback to modify_route_pub;
941: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
942: p_data => x_msg_data,
943: p_encoded => fnd_api.g_false);
944:
945: WHEN OTHERS THEN

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

944:
945: WHEN OTHERS THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: Rollback to modify_route_pub;
948: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
949: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
950: p_procedure_name => 'MODIFY_ROUTE',
951: p_error_text => SQLERRM);
952: END IF;

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

945: WHEN OTHERS THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: Rollback to modify_route_pub;
948: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
949: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
950: p_procedure_name => 'MODIFY_ROUTE',
951: p_error_text => SQLERRM);
952: END IF;
953: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

949: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
950: p_procedure_name => 'MODIFY_ROUTE',
951: p_error_text => SQLERRM);
952: END IF;
953: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
954: p_data => x_msg_data,
955: p_encoded => fnd_api.g_false);
956:
957: END Modify_Route;

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

1023: --
1024: EXCEPTION
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1028: p_data => x_msg_data,
1029: p_encoded => fnd_api.g_false);
1030:
1031: WHEN OTHERS THEN

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

1029: p_encoded => fnd_api.g_false);
1030:
1031: WHEN OTHERS THEN
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1034: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1035: p_procedure_name => 'CREATE_ROUTE',
1036: p_error_text => SQLERRM);
1037: END IF;

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

1030:
1031: WHEN OTHERS THEN
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1034: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1035: p_procedure_name => 'CREATE_ROUTE',
1036: p_error_text => SQLERRM);
1037: END IF;
1038: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1034: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1035: p_procedure_name => 'CREATE_ROUTE',
1036: p_error_text => SQLERRM);
1037: END IF;
1038: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1039: p_data => x_msg_data,
1040: p_encoded => fnd_api.g_false);
1041:
1042: END Modify_Route;

Line 1094: FND_MSG_PUB.initialize;

1090: END IF;
1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.
1093: IF FND_API.to_boolean( p_init_msg_list ) THEN
1094: FND_MSG_PUB.initialize;
1095: END IF;
1096:
1097: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1098: fnd_log.string

Line 1169: x_msg_count := FND_MSG_PUB.count_msg;

1165: p_route_id => l_route_id,
1166: p_object_version_number => p_route_object_version
1167: );
1168: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
1169: x_msg_count := FND_MSG_PUB.count_msg;
1170:
1171: IF x_msg_count > 0 THEN
1172: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1173: RAISE FND_API.G_EXC_ERROR;

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

1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: Rollback to delete_route_pub;
1219: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1220: p_data => x_msg_data,
1221: p_encoded => fnd_api.g_false);
1222:
1223:

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

1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226: Rollback to delete_route_pub;
1227: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1228: p_data => x_msg_data,
1229: p_encoded => fnd_api.g_false);
1230:
1231: WHEN OTHERS THEN

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

1230:
1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: Rollback to delete_route_pub;
1234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1235: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1236: p_procedure_name => 'DELETE_ROUTE',
1237: p_error_text => SQLERRM);
1238: END IF;

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

1231: WHEN OTHERS THEN
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: Rollback to delete_route_pub;
1234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1235: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1236: p_procedure_name => 'DELETE_ROUTE',
1237: p_error_text => SQLERRM);
1238: END IF;
1239: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1235: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1236: p_procedure_name => 'DELETE_ROUTE',
1237: p_error_text => SQLERRM);
1238: END IF;
1239: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1240: p_data => x_msg_data,
1241: p_encoded => fnd_api.g_false);
1242:
1243: END Delete_Route;

Line 1296: FND_MSG_PUB.initialize;

1292: END IF;
1293:
1294: -- Initialize message list if p_init_msg_list is set to TRUE.
1295: IF FND_API.to_boolean( p_init_msg_list ) THEN
1296: FND_MSG_PUB.initialize;
1297: END IF;
1298:
1299:
1300: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 1369: FND_MSG_PUB.add;

1365:
1366: IF l_x_route_efct_tbl(1).ROUTE_EFFECTIVITY_ID IS NULL
1367: THEN
1368: FND_MESSAGE.set_Name('AHL','AHL_RM_PUB_EFFEC_ID_NULL');
1369: FND_MSG_PUB.add;
1370: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1371: fnd_log.string
1372: (
1373: fnd_log.level_error,

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

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

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

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

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

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

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

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

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

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

Line 1531: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

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

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

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

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

Line 1714: FND_MSG_PUB.initialize;

1710: END IF;
1711:
1712: -- Initialize message list if p_init_msg_list is set to TRUE.
1713: IF FND_API.to_boolean( p_init_msg_list ) THEN
1714: FND_MSG_PUB.initialize;
1715: END IF;
1716:
1717: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1718: fnd_log.string

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

1817: EXCEPTION
1818: WHEN FND_API.G_EXC_ERROR THEN
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: Rollback to initiate_route_approval_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:

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

1825:
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: Rollback to initiate_route_approval_pub;
1829: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1830: p_data => x_msg_data,
1831: p_encoded => fnd_api.g_false);
1832:
1833: WHEN OTHERS THEN

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

1832:
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: Rollback to initiate_route_approval_pub;
1836: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1837: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1838: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1839: p_error_text => SQLERRM);
1840: END IF;

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

1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: Rollback to initiate_route_approval_pub;
1836: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1837: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1838: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1839: p_error_text => SQLERRM);
1840: END IF;
1841: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1837: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1838: p_procedure_name => 'INITIATE_ROUTE_APPROVAL',
1839: p_error_text => SQLERRM);
1840: END IF;
1841: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1842: p_data => x_msg_data,
1843: p_encoded => fnd_api.g_false);
1844:
1845: END Initiate_Route_Approval;

Line 1891: FND_MSG_PUB.initialize;

1887: END IF;
1888:
1889: -- Initialize message list if p_init_msg_list is set to TRUE.
1890: IF FND_API.to_boolean( p_init_msg_list ) THEN
1891: FND_MSG_PUB.initialize;
1892: END IF;
1893:
1894: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1895: fnd_log.string

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

1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: x_return_status := FND_API.G_RET_STS_ERROR;
1997: Rollback to process_route_operation_as_pub;
1998: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1999: p_data => x_msg_data,
2000: p_encoded => fnd_api.g_false);
2001:
2002:

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

2002:
2003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2005: Rollback to process_route_operation_as_pub;
2006: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2007: p_data => x_msg_data,
2008: p_encoded => fnd_api.g_false);
2009:
2010: WHEN OTHERS THEN

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

2009:
2010: WHEN OTHERS THEN
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2012: Rollback to process_route_operation_as_pub;
2013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2014: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2015: p_procedure_name => 'Process_Route_Oper_Assoc',
2016: p_error_text => SQLERRM);
2017: END IF;

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

2010: WHEN OTHERS THEN
2011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2012: Rollback to process_route_operation_as_pub;
2013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2014: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2015: p_procedure_name => 'Process_Route_Oper_Assoc',
2016: p_error_text => SQLERRM);
2017: END IF;
2018: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

2014: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2015: p_procedure_name => 'Process_Route_Oper_Assoc',
2016: p_error_text => SQLERRM);
2017: END IF;
2018: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2019: p_data => x_msg_data,
2020: p_encoded => fnd_api.g_false);
2021:
2022: END Process_Route_Oper_Assoc;

Line 2100: FND_MSG_PUB.initialize;

2096: END IF;
2097:
2098: -- Initialize message list if p_init_msg_list is set to TRUE.
2099: IF FND_API.to_boolean( p_init_msg_list ) THEN
2100: FND_MSG_PUB.initialize;
2101: END IF;
2102:
2103: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2104: fnd_log.string

Line 2159: FND_MSG_PUB.add;

2155: IF get_res_id%NOTFOUND THEN
2156: -- PRITHWI : please run this message and check what it displays.
2157: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ASO_RES_ID' );
2158: FND_MESSAGE.set_token( 'RECORD', p_resource_name );
2159: FND_MSG_PUB.add;
2160: RAISE FND_API.G_EXC_ERROR;
2161: END IF;
2162:
2163: CLOSE get_res_id;

Line 2173: FND_MSG_PUB.add;

2169: FETCH get_rt_oper_resource INTO l_rt_oper_resource_id;
2170: IF get_rt_oper_resource%NOTFOUND THEN
2171: -- PRITHWI : please run this message and check what it displays.
2172: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );
2173: FND_MSG_PUB.add;
2174: RAISE FND_API.G_EXC_ERROR;
2175: END IF;
2176:
2177: CLOSE get_rt_oper_resource;

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

2256: EXCEPTION
2257: WHEN FND_API.G_EXC_ERROR THEN
2258: x_return_status := FND_API.G_RET_STS_ERROR;
2259: Rollback to Process_Alt_Resources;
2260: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2261: p_data => x_msg_data,
2262: p_encoded => fnd_api.g_false);
2263:
2264:

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

2264:
2265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2267: Rollback to Process_Alt_Resources;
2268: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2269: p_data => x_msg_data,
2270: p_encoded => fnd_api.g_false);
2271:
2272: WHEN OTHERS THEN

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

2271:
2272: WHEN OTHERS THEN
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2274: Rollback to Process_Alt_Resources;
2275: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2276: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2277: p_procedure_name => 'Process_Route_Alt_Resources',
2278: p_error_text => SQLERRM);
2279: END IF;

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

2272: WHEN OTHERS THEN
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2274: Rollback to Process_Alt_Resources;
2275: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2276: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2277: p_procedure_name => 'Process_Route_Alt_Resources',
2278: p_error_text => SQLERRM);
2279: END IF;
2280: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

2276: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2277: p_procedure_name => 'Process_Route_Alt_Resources',
2278: p_error_text => SQLERRM);
2279: END IF;
2280: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
2281: p_data => x_msg_data,
2282: p_encoded => fnd_api.g_false);
2283:
2284: END Process_Route_Alt_Resources;