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_UA_FLIGHT_SCHEDULES_PVT dependencies on FND_MSG_PUB

Line 136: FND_MSG_PUB.add;

132: THEN
133: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
134: FND_MESSAGE.set_token( 'FIELD', p_flight_schedule_rec.DML_OPERATION);
135: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
136: FND_MSG_PUB.add;
137: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
138: fnd_log.string
139: (
140: fnd_log.level_error,

Line 163: FND_MSG_PUB.add;

159: p_flight_schedule_rec.UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM
160: THEN
161: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
162: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
163: FND_MSG_PUB.add;
164: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
165: fnd_log.string
166: (
167: fnd_log.level_error,

Line 183: FND_MSG_PUB.add;

179: p_flight_schedule_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM )
180: THEN
181: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
182: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
183: FND_MSG_PUB.add;
184: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
185: fnd_log.string
186: (
187: fnd_log.level_error,

Line 204: FND_MSG_PUB.add;

200: IF get_cur_us_csr%NOTFOUND
201: THEN
202: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );
203: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
204: FND_MSG_PUB.add;
205: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
206: fnd_log.string
207: (
208: fnd_log.level_error,

Line 310: FND_MSG_PUB.ADD;

306: FETCH uc_name_to_id_csr INTO p_x_flight_schedule_rec.unit_config_header_id;
307: IF uc_name_to_id_csr%NOTFOUND THEN
308: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');
309: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
310: FND_MSG_PUB.ADD;
311: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
312: fnd_log.string
313: (
314: fnd_log.level_error,

Line 342: FND_MSG_PUB.ADD;

338: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_org_id;
339: IF org_name_to_id_csr%NOTFOUND THEN
340: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');
341: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
342: FND_MSG_PUB.ADD;
343: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
344: fnd_log.string
345: (
346: fnd_log.level_error,

Line 379: FND_MSG_PUB.ADD;

375: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_dept_id;
376: IF dept_name_to_id_csr%NOTFOUND THEN
377: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');
378: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
379: FND_MSG_PUB.ADD;
380: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
381: fnd_log.string
382: (
383: fnd_log.level_error,

Line 411: FND_MSG_PUB.ADD;

407: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.departure_org_id;
408: IF org_name_to_id_csr%NOTFOUND THEN
409: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');
410: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
411: FND_MSG_PUB.ADD;
412: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
413: fnd_log.string
414: (
415: fnd_log.level_error,

Line 448: FND_MSG_PUB.ADD;

444: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.departure_dept_id;
445: IF dept_name_to_id_csr%NOTFOUND THEN
446: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');
447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
448: FND_MSG_PUB.ADD;
449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
450: fnd_log.string
451: (
452: fnd_log.level_error,

Line 487: FND_MSG_PUB.ADD;

483: -- If any severe error occurs, then, abort API.
484: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
485: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');
486: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
487: FND_MSG_PUB.ADD;
488: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
489: fnd_log.string
490: (
491: fnd_log.level_error,

Line 700: FND_MSG_PUB.add;

696: )
697: THEN
698: FND_MESSAGE.set_name( 'AHL','AHL_UA_INV_UC_NAME' );
699: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
700: FND_MSG_PUB.add;
701: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
702: fnd_log.string
703: (
704: fnd_log.level_error,

Line 721: FND_MSG_PUB.add;

717: )
718: THEN
719: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_FLG_NUMBER_NULL' );
720: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
721: FND_MSG_PUB.add;
722: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
723: fnd_log.string
724: (
725: fnd_log.level_error,

Line 743: FND_MSG_PUB.add;

739: )
740: THEN
741: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_SEGMENT_NULL' );
742: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
743: FND_MSG_PUB.add;
744: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
745: fnd_log.string
746: (
747: fnd_log.level_error,

Line 765: FND_MSG_PUB.add;

761: )
762: THEN
763: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
764: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
765: FND_MSG_PUB.add;
766: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
767: fnd_log.string
768: (
769: fnd_log.level_error,

Line 786: FND_MSG_PUB.add;

782: )
783: THEN
784: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
785: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
786: FND_MSG_PUB.add;
787: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
788: fnd_log.string
789: (
790: fnd_log.level_error,

Line 807: FND_MSG_PUB.add;

803: )
804: THEN
805: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
806: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
807: FND_MSG_PUB.add;
808: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
809: fnd_log.string
810: (
811: fnd_log.level_error,

Line 828: FND_MSG_PUB.add;

824: )
825: THEN
826: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
827: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
828: FND_MSG_PUB.add;
829: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
830: fnd_log.string
831: (
832: fnd_log.level_error,

Line 849: FND_MSG_PUB.add;

845: )
846: THEN
847: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
848: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
849: FND_MSG_PUB.add;
850: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
851: fnd_log.string
852: (
853: fnd_log.level_error,

Line 870: FND_MSG_PUB.add;

866: )
867: THEN
868: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
869: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
870: FND_MSG_PUB.add;
871: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
872: fnd_log.string
873: (
874: fnd_log.level_error,

Line 891: FND_MSG_PUB.add;

887: )
888: THEN
889: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
890: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
891: FND_MSG_PUB.add;
892: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
893: fnd_log.string
894: (
895: fnd_log.level_error,

Line 969: FND_MSG_PUB.add;

965: IF get_current_us_csr%NOTFOUND
966: THEN
967: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_US_NOT_FOUND' );
968: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
969: FND_MSG_PUB.add;
970: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
971: fnd_log.string
972: (
973: fnd_log.level_error,

Line 991: FND_MSG_PUB.add;

987: IF p_x_flight_schedule_rec.unit_config_header_id <> l_current_us_rec.unit_config_header_id
988: THEN
989: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );
990: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
991: FND_MSG_PUB.add;
992: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
993: fnd_log.string
994: (
995: fnd_log.level_error,

Line 1012: FND_MSG_PUB.add;

1008: IF p_x_flight_schedule_rec.flight_number <> l_current_us_rec.flight_number
1009: THEN
1010: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );
1011: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1012: FND_MSG_PUB.add;
1013: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1014: fnd_log.string
1015: (
1016: fnd_log.level_error,

Line 1031: FND_MSG_PUB.add;

1027: IF p_x_flight_schedule_rec.segment <> l_current_us_rec.segment
1028: THEN
1029: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );
1030: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);
1031: FND_MSG_PUB.add;
1032: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1033: fnd_log.string
1034: (
1035: fnd_log.level_error,

Line 1053: FND_MSG_PUB.add;

1049: l_update_allowed = FND_API.G_FALSE
1050: THEN
1051: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );
1052: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1053: FND_MSG_PUB.add;
1054: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1055: fnd_log.string
1056: (
1057: fnd_log.level_error,

Line 1073: FND_MSG_PUB.add;

1069: l_update_allowed = FND_API.G_FALSE
1070: THEN
1071: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );
1072: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1073: FND_MSG_PUB.add;
1074: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1075: fnd_log.string
1076: (
1077: fnd_log.level_error,

Line 1093: FND_MSG_PUB.add;

1089: l_update_allowed = FND_API.G_FALSE
1090: THEN
1091: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );
1092: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1093: FND_MSG_PUB.add;
1094: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1095: fnd_log.string
1096: (
1097: fnd_log.level_error,

Line 1113: FND_MSG_PUB.add;

1109: l_update_allowed = FND_API.G_FALSE
1110: THEN
1111: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );
1112: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1113: FND_MSG_PUB.add;
1114: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1115: fnd_log.string
1116: (
1117: fnd_log.level_error,

Line 1133: FND_MSG_PUB.add;

1129: l_update_allowed = FND_API.G_FALSE
1130: THEN
1131: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );
1132: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1133: FND_MSG_PUB.add;
1134: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string
1136: (
1137: fnd_log.level_error,

Line 1153: FND_MSG_PUB.add;

1149: l_update_allowed = FND_API.G_FALSE
1150: THEN
1151: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );
1152: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1153: FND_MSG_PUB.add;
1154: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1155: fnd_log.string
1156: (
1157: fnd_log.level_error,

Line 1283: FND_MSG_PUB.add;

1279: ) = FND_API.G_FALSE
1280: THEN
1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );
1282: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1283: FND_MSG_PUB.add;
1284: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1285: fnd_log.string
1286: (
1287: fnd_log.level_error,

Line 1311: FND_MSG_PUB.add;

1307: IF l_us_dup_count > 0 THEN
1308: -- Duplicate found, so throw error.
1309: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );
1310: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1311: FND_MSG_PUB.add;
1312: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1313: fnd_log.string
1314: (
1315: fnd_log.level_error,

Line 1338: FND_MSG_PUB.add;

1334: )
1335: THEN
1336: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );
1337: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1338: FND_MSG_PUB.add;
1339: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1340: fnd_log.string
1341: (
1342: fnd_log.level_error,

Line 1365: FND_MSG_PUB.add;

1361: )
1362: THEN
1363: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );
1364: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1365: FND_MSG_PUB.add;
1366: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1367: fnd_log.string
1368: (
1369: fnd_log.level_error,

Line 1387: FND_MSG_PUB.add;

1383: p_x_flight_schedule_rec.EST_DEPARTURE_TIME >= p_x_flight_schedule_rec.EST_ARRIVAL_TIME
1384: THEN
1385: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1386: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1387: FND_MSG_PUB.add;
1388: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1389: fnd_log.string
1390: (
1391: fnd_log.level_error,

Line 1410: FND_MSG_PUB.add;

1406: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME >= p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME
1407: THEN
1408: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1409: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1410: FND_MSG_PUB.add;
1411: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1412: fnd_log.string
1413: (
1414: fnd_log.level_error,

Line 1465: FND_MSG_PUB.add;

1461: l_preceeding_us_rec.actual_arrival_time IS NULL )
1462: THEN
1463: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );
1464: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1465: FND_MSG_PUB.add;
1466: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1467: fnd_log.string
1468: (
1469: fnd_log.level_error,

Line 1492: FND_MSG_PUB.add;

1488:
1489: IF l_est_violation_count > 0 THEN
1490: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );
1491: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1492: FND_MSG_PUB.add;
1493: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1494: fnd_log.string
1495: (
1496: fnd_log.level_error,

Line 1764: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1760: END IF;
1761: EXCEPTION
1762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1765: p_count => l_msg_count,
1766: p_data => l_msg_data);
1767:
1768: WHEN FND_API.G_EXC_ERROR THEN

Line 1770: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1766: p_data => l_msg_data);
1767:
1768: WHEN FND_API.G_EXC_ERROR THEN
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1771: p_count => l_msg_count,
1772: p_data => l_msg_data);
1773:
1774: WHEN OTHERS THEN

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

1772: p_data => l_msg_data);
1773:
1774: WHEN OTHERS THEN
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1777: THEN
1778: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1779: p_procedure_name => l_api_name,
1780: p_error_text => SUBSTR(SQLERRM,1,240));

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

1774: WHEN OTHERS THEN
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1777: THEN
1778: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1779: p_procedure_name => l_api_name,
1780: p_error_text => SUBSTR(SQLERRM,1,240));
1781:
1782: END IF;

Line 1783: FND_MSG_PUB.count_and_get

1779: p_procedure_name => l_api_name,
1780: p_error_text => SUBSTR(SQLERRM,1,240));
1781:
1782: END IF;
1783: FND_MSG_PUB.count_and_get
1784: (
1785: p_count => l_msg_count,
1786: p_data => l_msg_data,
1787: p_encoded => FND_API.G_FALSE

Line 2406: FND_MSG_PUB.add;

2402: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2403: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2404: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2405: ) );
2406: FND_MSG_PUB.add;
2407: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2408: fnd_log.string
2409: (
2410: fnd_log.level_error,

Line 2738: FND_MSG_PUB.add;

2734: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2735: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2736: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2737: ) );
2738: FND_MSG_PUB.add;
2739: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2740: fnd_log.string
2741: (
2742: fnd_log.level_error,

Line 2796: FND_MSG_PUB.initialize;

2792: END IF;
2793:
2794: -- Initialize message list if p_init_msg_list is set to TRUE.
2795: IF FND_API.to_boolean(p_init_msg_list) THEN
2796: FND_MSG_PUB.initialize;
2797: END IF;
2798:
2799: --Local procedure for Deleting Flight Schedules
2800: Delete_Flight_Schedules(

Line 2853: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2849: EXCEPTION
2850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2851: ROLLBACK TO process_flight_schedules_pvt;
2852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2853: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2854: p_count => x_msg_count,
2855: p_data => x_msg_data);
2856:
2857: WHEN FND_API.G_EXC_ERROR THEN

Line 2860: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2856:
2857: WHEN FND_API.G_EXC_ERROR THEN
2858: ROLLBACK TO process_flight_schedules_pvt;
2859: x_return_status := FND_API.G_RET_STS_ERROR;
2860: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2861: p_count => x_msg_count,
2862: p_data => X_msg_data);
2863:
2864: WHEN OTHERS THEN

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

2863:
2864: WHEN OTHERS THEN
2865: ROLLBACK TO process_flight_schedules_pvt;
2866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2868: THEN
2869: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2870: p_procedure_name => l_api_name,
2871: p_error_text => SUBSTR(SQLERRM,1,240));

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

2865: ROLLBACK TO process_flight_schedules_pvt;
2866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2867: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2868: THEN
2869: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2870: p_procedure_name => l_api_name,
2871: p_error_text => SUBSTR(SQLERRM,1,240));
2872:
2873: END IF;

Line 2874: FND_MSG_PUB.count_and_get

2870: p_procedure_name => l_api_name,
2871: p_error_text => SUBSTR(SQLERRM,1,240));
2872:
2873: END IF;
2874: FND_MSG_PUB.count_and_get
2875: (
2876: p_count => x_msg_count,
2877: p_data => x_msg_data,
2878: p_encoded => FND_API.G_FALSE

Line 2944: FND_MSG_PUB.add;

2940: -- Throw error if p_unit_schedule_id is null
2941:
2942: IF p_unit_schedule_id IS NULL THEN
2943: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
2944: FND_MSG_PUB.add;
2945: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2946: fnd_log.string
2947: (
2948: fnd_log.level_error,

Line 2960: FND_MSG_PUB.add;

2956: OPEN check_flight_exists_csr(p_unit_schedule_id, p_unit_config_id);
2957: FETCH check_flight_exists_csr INTO l_dummy;
2958: IF check_flight_exists_csr%NOTFOUND THEN
2959: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
2960: FND_MSG_PUB.add;
2961: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2962: fnd_log.string
2963: (
2964: fnd_log.level_error,

Line 2987: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2983: END IF;
2984: EXCEPTION
2985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2987: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2988: p_count => x_msg_count,
2989: p_data => x_msg_data);
2990:
2991: WHEN FND_API.G_EXC_ERROR THEN

Line 2993: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2989: p_data => x_msg_data);
2990:
2991: WHEN FND_API.G_EXC_ERROR THEN
2992: x_return_status := FND_API.G_RET_STS_ERROR;
2993: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2994: p_count => x_msg_count,
2995: p_data => X_msg_data);
2996:
2997: WHEN OTHERS THEN

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

2995: p_data => X_msg_data);
2996:
2997: WHEN OTHERS THEN
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3000: THEN
3001: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3002: p_procedure_name => l_api_name,
3003: p_error_text => SUBSTR(SQLERRM,1,240));

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

2997: WHEN OTHERS THEN
2998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2999: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3000: THEN
3001: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3002: p_procedure_name => l_api_name,
3003: p_error_text => SUBSTR(SQLERRM,1,240));
3004:
3005: END IF;

Line 3006: FND_MSG_PUB.count_and_get

3002: p_procedure_name => l_api_name,
3003: p_error_text => SUBSTR(SQLERRM,1,240));
3004:
3005: END IF;
3006: FND_MSG_PUB.count_and_get
3007: (
3008: p_count => x_msg_count,
3009: p_data => x_msg_data,
3010: p_encoded => FND_API.G_FALSE