DBA Data[Home] [Help]

APPS.AHL_ENIGMA_ROUTE_OP_PUB dependencies on AHL_RM_ROUTE_PVT

Line 452: p_process_route_input_rec AHL_RM_ROUTE_PVT.route_rec_type;

448: l_ovn NUMBER;
449: x_file_id NUMBER;
450:
451: l_get_latest_route_rev get_latest_route_rev%ROWTYPE;
452: p_process_route_input_rec AHL_RM_ROUTE_PVT.route_rec_type;
453:
454: BEGIN
455: -- Standard start of API savepoint
456: SAVEPOINT Process_Route_Details_SP;

Line 656: AHL_RM_ROUTE_PVT.delete_route

652: );
653: END IF;
654:
655: -- Call delete_route procedure to delete the route from CMRO End.
656: AHL_RM_ROUTE_PVT.delete_route
657: (
658: '1.0',
659: FND_API.G_TRUE,
660: FND_API.G_FALSE,

Line 688: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');

684: );
685: END IF;
686:
687: IF (l_log_statement >= l_log_current_level) THEN
688: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');
689: END IF;
690:
691: -- Check the return status , and if the status is not success , then raise an error
692: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 694: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route Error');

690:
691: -- Check the return status , and if the status is not success , then raise an error
692: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
693: IF (l_log_statement >= l_log_current_level) THEN
694: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route Error');
695: END IF;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:

Line 700: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route -> Deleted');

696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: IF (l_log_statement >= l_log_current_level) THEN
700: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route -> Deleted');
701: END IF;
702:
703: END IF;
704: ELSE

Line 885: AHL_RM_ROUTE_PVT.create_route_revision

881: );
882: END IF;
883:
884: -- Call the API to create a new revision of the route
885: AHL_RM_ROUTE_PVT.create_route_revision
886: (
887: '1.0',
888: FND_API.G_TRUE,
889: FND_API.G_FALSE,

Line 919: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');

915: );
916: END IF;
917:
918: IF (l_log_statement >= l_log_current_level) THEN
919: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.create_route_revision');
920: END IF;
921:
922: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
923: IF (l_log_statement >= l_log_current_level) THEN

Line 924: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision Error');

920: END IF;
921:
922: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
923: IF (l_log_statement >= l_log_current_level) THEN
924: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision Error');
925: END IF;
926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:

Line 930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');

926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:
929: IF (l_log_statement >= l_log_current_level) THEN
930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');
931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);
932: END IF;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);

927: END IF;
928:
929: IF (l_log_statement >= l_log_current_level) THEN
930: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> revision Created');
931: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision -> x_route_id = ' || x_route_id);
932: END IF;
933:
934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
935: THEN

Line 1056: AHL_RM_ROUTE_PVT.process_route

1052: );
1053: END IF;
1054:
1055: -- Call the API for update
1056: AHL_RM_ROUTE_PVT.process_route
1057: (
1058: '1.0',
1059: FND_API.G_TRUE,
1060: FND_API.G_FALSE,

Line 1088: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');

1084: );
1085: END IF;
1086:
1087: IF (l_log_statement >= l_log_current_level) THEN
1088: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');
1089: END IF;
1090:
1091: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1092: IF (l_log_statement >= l_log_current_level) THEN

Line 1093: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');

1089: END IF;
1090:
1091: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1092: IF (l_log_statement >= l_log_current_level) THEN
1093: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1094: END IF;
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:

Line 1099: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> updation Successful');

1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:
1098: IF (l_log_statement >= l_log_current_level) THEN
1099: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> updation Successful');
1100: END IF;
1101:
1102: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1103: THEN

Line 1370: AHL_RM_ROUTE_PVT.process_route

1366: );
1367: END IF;
1368:
1369: -- Call the API for update.
1370: AHL_RM_ROUTE_PVT.process_route
1371: (
1372: '1.0',
1373: FND_API.G_TRUE,
1374: FND_API.G_FALSE,

Line 1396: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');

1392: );
1393: END IF;
1394:
1395: IF (l_log_statement >= l_log_current_level) THEN
1396: fnd_log.string(fnd_log.level_statement,l_debug_module,'After AHL_RM_ROUTE_PVT.process_route');
1397: END IF;
1398:
1399: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1400: IF (l_log_statement >= l_log_current_level) THEN

Line 1401: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');

1397: END IF;
1398:
1399: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1400: IF (l_log_statement >= l_log_current_level) THEN
1401: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1402: END IF;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405:

Line 1754: AHL_RM_ROUTE_PVT.process_route

1750: );
1751: END IF;
1752:
1753: -- Call the API for update.
1754: AHL_RM_ROUTE_PVT.process_route
1755: (
1756: '1.0',
1757: FND_API.G_TRUE,
1758: FND_API.G_FALSE,

Line 1781: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');

1777: END IF;
1778:
1779: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1780: IF (l_log_statement >= l_log_current_level) THEN
1781: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1782: END IF;
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:

Line 1787: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> creation Successful');

1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:
1786: IF (l_log_statement >= l_log_current_level) THEN
1787: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route -> creation Successful');
1788: END IF;
1789:
1790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1791: THEN