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_ENIGMA_ROUTE_OP_PUB dependencies on AHL_RM_ROUTE_PVT

Line 570: x_process_route_input_rec OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,

566:
567: PROCEDURE Map_Enigma_To_CMRO_Route_Rec
568: (
569: p_enigma_route_rec IN enigma_route_rec_type,
570: x_process_route_input_rec OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,
571: p_route_id IN NUMBER,
572: p_object_version_number IN NUMBER,
573: p_context IN VARCHAR2,
574: p_pub_date IN DATE

Line 952: p_process_route_input_rec AHL_RM_ROUTE_PVT.route_rec_type;

948: x_file_id NUMBER;
949: isrecoverable VARCHAR2(1);
950:
951: l_get_latest_route_rev get_latest_route_rev%ROWTYPE;
952: p_process_route_input_rec AHL_RM_ROUTE_PVT.route_rec_type;
953:
954:
955: BEGIN
956: -- Standard start of API savepoint

Line 1029: --The Pvt API,AHL_RM_ROUTE_PVT.process_route expects DML_OPERATION To be VARCHAR2(1),

1025: END IF;
1026: --New DML_OPERATION Value Added for Enigma Phase II
1027: --New Value: 'NC'
1028: --Functionality:IF DML_OPERATION = 'NC' Then Only pdf will be updated for the route.
1029: --The Pvt API,AHL_RM_ROUTE_PVT.process_route expects DML_OPERATION To be VARCHAR2(1),
1030: --So from this public wrapper,DML_OPERATION will be passed as 'N' to that api
1031: IF (p_enigma_route_rec.DML_OPERATION = 'NC') THEN
1032: -- IF the route is in Approval Pending status , then insert the Enigma Record into the staging table with status as pending.
1033: IF ( upper(l_get_latest_route_rev.revision_status) = 'APPROVAL_PENDING' ) THEN

Line 1073: AHL_RM_ROUTE_PVT.process_route

1069: p_process_route_input_rec.file_id := x_file_id ;
1070: END IF;
1071: p_process_route_input_rec.DML_OPERATION :='N';
1072: -- Call the API for update
1073: AHL_RM_ROUTE_PVT.process_route
1074: (
1075: '1.0',
1076: FND_API.G_TRUE,
1077: FND_API.G_FALSE,

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

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

Line 1133: AHL_RM_ROUTE_PVT.delete_route

1129: 'Route is in approval pending status'
1130: );*/
1131: ELSE
1132: -- Call delete_route procedure to delete the route from CMRO End.
1133: AHL_RM_ROUTE_PVT.delete_route
1134: (
1135: '1.0',
1136: FND_API.G_TRUE,
1137: FND_API.G_FALSE,

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

1151:
1152: -- Check the return status , and if the status is not success , then raise an error
1153: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1154: IF (l_log_statement >= l_log_current_level) THEN
1155: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.delete_route Error');
1156: END IF;
1157: /*Update_Route_Interface_table
1158: (
1159: p_enigma_route_rec,

Line 1222: AHL_RM_ROUTE_PVT.create_route_revision

1218: END LOOP;
1219: END IF;*/
1220: ELSIF (upper(l_get_latest_route_rev.revision_status) = 'COMPLETE') THEN
1221:
1222: AHL_RM_ROUTE_PVT.create_route_revision
1223: (
1224: '1.0',
1225: FND_API.G_TRUE,
1226: FND_API.G_FALSE,

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

1240: END IF;
1241:
1242: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1243: IF (l_log_statement >= l_log_current_level) THEN
1244: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.create_route_revision Error');
1245: END IF;
1246: /*Update_Route_Interface_table
1247: (
1248: p_enigma_route_rec,

Line 1277: AHL_RM_ROUTE_PVT.process_route

1273: fnd_log.string(fnd_log.level_statement,l_debug_module,'Before calling process_route in update mode');
1274: END IF;
1275:
1276: -- Call the API for update
1277: AHL_RM_ROUTE_PVT.process_route
1278: (
1279: '1.0',
1280: FND_API.G_TRUE,
1281: FND_API.G_FALSE,

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

1293: END IF;
1294:
1295: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1296: IF (l_log_statement >= l_log_current_level) THEN
1297: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1298: END IF;
1299: /*Update_Route_Interface_table
1300: (
1301: p_enigma_route_rec,

Line 1359: AHL_RM_ROUTE_PVT.process_route

1355: p_pub_date
1356: );
1357:
1358: -- Call the API for update.
1359: AHL_RM_ROUTE_PVT.process_route
1360: (
1361: '1.0',
1362: FND_API.G_TRUE,
1363: FND_API.G_FALSE,

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

1375: END IF;
1376:
1377: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1378: IF (l_log_statement >= l_log_current_level) THEN
1379: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1380: END IF;
1381: /*Update_Route_Interface_table
1382: (
1383: p_enigma_route_rec,

Line 1482: AHL_RM_ROUTE_PVT.process_route

1478: p_pub_date
1479: );
1480:
1481: -- Call the API for Create.
1482: AHL_RM_ROUTE_PVT.process_route
1483: (
1484: '1.0',
1485: FND_API.G_TRUE,
1486: FND_API.G_FALSE,

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

1498: END IF;
1499:
1500: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
1501: IF (l_log_statement >= l_log_current_level) THEN
1502: fnd_log.string(fnd_log.level_statement,l_debug_module,'AHL_RM_ROUTE_PVT.process_route Error');
1503: END IF;
1504: /*Update_Route_Interface_table
1505: (
1506: p_enigma_route_rec,