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 154: FND_MSG_PUB.add;

150: THEN
151: FND_MESSAGE.set_name( 'AHL','AHL_COM_INVALID_DML' );
152: FND_MESSAGE.set_token( 'FIELD', p_x_flight_schedule_rec.DML_OPERATION);
153: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
154: FND_MSG_PUB.add;
155: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
156: fnd_log.string
157: (
158: fnd_log.level_error,

Line 181: FND_MSG_PUB.add;

177: p_x_flight_schedule_rec.UNIT_SCHEDULE_ID = FND_API.G_MISS_NUM
178: THEN
179: FND_MESSAGE.set_name( 'AHL','AHL_UA_US_NOT_FOUND' );
180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
181: FND_MSG_PUB.add;
182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
183: fnd_log.string
184: (
185: fnd_log.level_error,

Line 201: FND_MSG_PUB.add;

197: p_x_flight_schedule_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM )
198: THEN
199: FND_MESSAGE.set_name( 'AHL','AHL_UA_OBJ_VERNO_NULL' );
200: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
201: FND_MSG_PUB.add;
202: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
203: fnd_log.string
204: (
205: fnd_log.level_error,

Line 222: FND_MSG_PUB.add;

218: IF get_cur_us_csr%NOTFOUND
219: THEN
220: FND_MESSAGE.set_name( 'AHL','AHL_UA_REC_CHANGED' );
221: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
222: FND_MSG_PUB.add;
223: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
224: fnd_log.string
225: (
226: fnd_log.level_error,

Line 272: FND_MSG_PUB.add;

268: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_code);
269: ELSE
270: FND_MESSAGE.set_token('FIELD', p_x_flight_schedule_rec.flight_category_meaning);
271: END IF;
272: FND_MSG_PUB.add;
273:
274: IF (l_log_statement >= l_log_current_level) THEN
275: FND_LOG.string(l_log_statement, l_full_name,
276: 'Flight Category Code ' || p_x_flight_schedule_rec.flight_category_code || ' is not valid.');

Line 392: FND_MSG_PUB.ADD;

388: FETCH uc_name_to_id_csr INTO p_x_flight_schedule_rec.unit_config_header_id;
389: IF uc_name_to_id_csr%NOTFOUND THEN
390: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_UC_NAME');
391: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
392: FND_MSG_PUB.ADD;
393: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
394: fnd_log.string
395: (
396: fnd_log.level_error,

Line 424: FND_MSG_PUB.ADD;

420: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_org_id;
421: IF org_name_to_id_csr%NOTFOUND THEN
422: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_ORG');
423: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
424: FND_MSG_PUB.ADD;
425: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
426: fnd_log.string
427: (
428: fnd_log.level_error,

Line 461: FND_MSG_PUB.ADD;

457: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.arrival_dept_id;
458: IF dept_name_to_id_csr%NOTFOUND THEN
459: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_ARR_DEPT');
460: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
461: FND_MSG_PUB.ADD;
462: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
463: fnd_log.string
464: (
465: fnd_log.level_error,

Line 493: FND_MSG_PUB.ADD;

489: FETCH org_name_to_id_csr INTO p_x_flight_schedule_rec.departure_org_id;
490: IF org_name_to_id_csr%NOTFOUND THEN
491: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_ORG');
492: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
493: FND_MSG_PUB.ADD;
494: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
495: fnd_log.string
496: (
497: fnd_log.level_error,

Line 530: FND_MSG_PUB.ADD;

526: FETCH dept_name_to_id_csr INTO p_x_flight_schedule_rec.departure_dept_id;
527: IF dept_name_to_id_csr%NOTFOUND THEN
528: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_DEP_DEPT');
529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
530: FND_MSG_PUB.ADD;
531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
532: fnd_log.string
533: (
534: fnd_log.level_error,

Line 569: FND_MSG_PUB.ADD;

565: -- If any severe error occurs, then, abort API.
566: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
567: FND_MESSAGE.SET_NAME('AHL','AHL_UA_INV_RESCH_MODE');
568: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
569: FND_MSG_PUB.ADD;
570: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
571: fnd_log.string
572: (
573: fnd_log.level_error,

Line 597: FND_MSG_PUB.add;

593: x_return_status := FND_API.G_RET_STS_ERROR;
594:
595: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');
596: FND_MESSAGE.set_token('RECORD', l_record_identifier);
597: FND_MSG_PUB.add;
598:
599: IF (l_log_statement >= l_log_current_level) THEN
600: FND_LOG.string(l_log_statement, l_full_name,
601: 'Departure Space name ' || p_x_flight_schedule_rec.departure_space_name || ' is not valid.');

Line 621: FND_MSG_PUB.add;

617: x_return_status := FND_API.G_RET_STS_ERROR;
618:
619: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');
620: FND_MESSAGE.set_token('RECORD', l_record_identifier);
621: FND_MSG_PUB.add;
622:
623: IF (l_log_statement >= l_log_current_level) THEN
624: FND_LOG.string(l_log_statement, l_full_name,
625: 'Arrival Space name ' || p_x_flight_schedule_rec.arrival_space_name || ' is not valid.');

Line 850: FND_MSG_PUB.add;

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

Line 871: FND_MSG_PUB.add;

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

Line 893: FND_MSG_PUB.add;

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

Line 915: FND_MSG_PUB.add;

911: )
912: THEN
913: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_DEPT_NULL' );
914: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
915: FND_MSG_PUB.add;
916: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
917: fnd_log.string
918: (
919: fnd_log.level_error,

Line 936: FND_MSG_PUB.add;

932: )
933: THEN
934: FND_MESSAGE.set_name( 'AHL','AHL_UA_DEP_ORG_NULL' );
935: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
936: FND_MSG_PUB.add;
937: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
938: fnd_log.string
939: (
940: fnd_log.level_error,

Line 957: FND_MSG_PUB.add;

953: )
954: THEN
955: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_DEPT_NULL' );
956: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
957: FND_MSG_PUB.add;
958: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
959: fnd_log.string
960: (
961: fnd_log.level_error,

Line 978: FND_MSG_PUB.add;

974: )
975: THEN
976: FND_MESSAGE.set_name( 'AHL','AHL_UA_ARR_ORG_NULL' );
977: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
978: FND_MSG_PUB.add;
979: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
980: fnd_log.string
981: (
982: fnd_log.level_error,

Line 999: FND_MSG_PUB.add;

995: )
996: THEN
997: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_DEP_TIME_NULL' );
998: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
999: FND_MSG_PUB.add;
1000: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1001: fnd_log.string
1002: (
1003: fnd_log.level_error,

Line 1020: FND_MSG_PUB.add;

1016: )
1017: THEN
1018: FND_MESSAGE.set_name( 'AHL','AHL_UA_EST_ARR_TIME_NULL' );
1019: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1020: FND_MSG_PUB.add;
1021: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1022: fnd_log.string
1023: (
1024: fnd_log.level_error,

Line 1041: FND_MSG_PUB.add;

1037: )
1038: THEN
1039: FND_MESSAGE.set_name( 'AHL','AHL_UA_VST_RES_MODE_NULL' );
1040: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1041: FND_MSG_PUB.add;
1042: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1043: fnd_log.string
1044: (
1045: fnd_log.level_error,

Line 1119: FND_MSG_PUB.add;

1115: IF get_current_us_csr%NOTFOUND
1116: THEN
1117: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_US_NOT_FOUND' );
1118: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1119: FND_MSG_PUB.add;
1120: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1121: fnd_log.string
1122: (
1123: fnd_log.level_error,

Line 1141: FND_MSG_PUB.add;

1137: IF p_x_flight_schedule_rec.unit_config_header_id <> l_current_us_rec.unit_config_header_id
1138: THEN
1139: FND_MESSAGE.set_name( 'AHL','AHL_UA_UNIT_NO_UPDATE' );
1140: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1141: FND_MSG_PUB.add;
1142: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1143: fnd_log.string
1144: (
1145: fnd_log.level_error,

Line 1162: FND_MSG_PUB.add;

1158: IF p_x_flight_schedule_rec.flight_number <> l_current_us_rec.flight_number
1159: THEN
1160: FND_MESSAGE.set_name( 'AHL','AHL_UA_FLIGHT_NO_UPDATE' );
1161: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1162: FND_MSG_PUB.add;
1163: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1164: fnd_log.string
1165: (
1166: fnd_log.level_error,

Line 1181: FND_MSG_PUB.add;

1177: IF p_x_flight_schedule_rec.segment <> l_current_us_rec.segment
1178: THEN
1179: FND_MESSAGE.set_name( 'AHL','AHL_UA_SEGMENT_NO_UPDATE' );
1180: FND_MESSAGE.set_token( 'RECORD', l_record_identifier);
1181: FND_MSG_PUB.add;
1182: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1183: fnd_log.string
1184: (
1185: fnd_log.level_error,

Line 1203: FND_MSG_PUB.add;

1199: l_update_allowed = FND_API.G_FALSE
1200: THEN
1201: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_DEPT_NO_UPDATE' );
1202: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1203: FND_MSG_PUB.add;
1204: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1205: fnd_log.string
1206: (
1207: fnd_log.level_error,

Line 1223: FND_MSG_PUB.add;

1219: l_update_allowed = FND_API.G_FALSE
1220: THEN
1221: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DEP_ORG_NO_UPDATE' );
1222: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1223: FND_MSG_PUB.add;
1224: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1225: fnd_log.string
1226: (
1227: fnd_log.level_error,

Line 1243: FND_MSG_PUB.add;

1239: l_update_allowed = FND_API.G_FALSE
1240: THEN
1241: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_DEP_NO_UPDATE' );
1242: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1243: FND_MSG_PUB.add;
1244: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1245: fnd_log.string
1246: (
1247: fnd_log.level_error,

Line 1263: FND_MSG_PUB.add;

1259: l_update_allowed = FND_API.G_FALSE
1260: THEN
1261: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_ORG_NO_UPDATE' );
1262: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1263: FND_MSG_PUB.add;
1264: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1265: fnd_log.string
1266: (
1267: fnd_log.level_error,

Line 1283: FND_MSG_PUB.add;

1279: l_update_allowed = FND_API.G_FALSE
1280: THEN
1281: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_DEP_NO_UPDATE' );
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 1303: FND_MSG_PUB.add;

1299: l_update_allowed = FND_API.G_FALSE
1300: THEN
1301: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_NO_UPDATE' );
1302: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1303: FND_MSG_PUB.add;
1304: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1305: fnd_log.string
1306: (
1307: fnd_log.level_error,

Line 1448: FND_MSG_PUB.add;

1444: ) = FND_API.G_FALSE
1445: THEN
1446: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_NO_DEL' );
1447: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1448: FND_MSG_PUB.add;
1449: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1450: fnd_log.string
1451: (
1452: fnd_log.level_error,

Line 1476: FND_MSG_PUB.add;

1472: IF l_us_dup_count > 0 THEN
1473: -- Duplicate found, so throw error.
1474: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_DUP_FLG_SCH' );
1475: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1476: FND_MSG_PUB.add;
1477: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1478: fnd_log.string
1479: (
1480: fnd_log.level_error,

Line 1503: FND_MSG_PUB.add;

1499: )
1500: THEN
1501: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_WO_DEP' );
1502: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1503: FND_MSG_PUB.add;
1504: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1505: fnd_log.string
1506: (
1507: fnd_log.level_error,

Line 1530: FND_MSG_PUB.add;

1526: )
1527: THEN
1528: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ACT_GT_SYSDATE' );
1529: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1530: FND_MSG_PUB.add;
1531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1532: fnd_log.string
1533: (
1534: fnd_log.level_error,

Line 1552: FND_MSG_PUB.add;

1548: p_x_flight_schedule_rec.EST_DEPARTURE_TIME >= p_x_flight_schedule_rec.EST_ARRIVAL_TIME
1549: THEN
1550: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1551: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1552: FND_MSG_PUB.add;
1553: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1554: fnd_log.string
1555: (
1556: fnd_log.level_error,

Line 1575: FND_MSG_PUB.add;

1571: p_x_flight_schedule_rec.ACTUAL_DEPARTURE_TIME >= p_x_flight_schedule_rec.ACTUAL_ARRIVAL_TIME
1572: THEN
1573: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_ARR_LT_DEP' );
1574: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1575: FND_MSG_PUB.add;
1576: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1577: fnd_log.string
1578: (
1579: fnd_log.level_error,

Line 1630: FND_MSG_PUB.add;

1626: l_preceeding_us_rec.actual_arrival_time IS NULL )
1627: THEN
1628: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_PRE_ACT_NOT_REC' );
1629: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1630: FND_MSG_PUB.add;
1631: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1632: fnd_log.string
1633: (
1634: fnd_log.level_error,

Line 1657: FND_MSG_PUB.add;

1653:
1654: IF l_est_violation_count > 0 THEN
1655: FND_MESSAGE.set_name( 'AHL', 'AHL_UA_EST_ARR_VIO' );
1656: FND_MESSAGE.set_token( 'RECORD', l_record_identifier );
1657: FND_MSG_PUB.add;
1658: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
1659: fnd_log.string
1660: (
1661: fnd_log.level_error,

Line 1684: FND_MSG_PUB.ADD;

1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681:
1682: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_DEP_SPACE');
1683: FND_MESSAGE.set_token('RECORD', l_record_identifier);
1684: FND_MSG_PUB.ADD;
1685:
1686: IF (l_log_statement >= l_log_current_level) THEN
1687: FND_LOG.string(l_log_statement, l_full_name,
1688: 'Departure Space id ' || p_x_flight_schedule_rec.departure_space_id || ' is not valid.');

Line 1708: FND_MSG_PUB.ADD;

1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_UA_INV_ARR_SPACE');
1707: FND_MESSAGE.set_token('RECORD', l_record_identifier);
1708: FND_MSG_PUB.ADD;
1709:
1710: IF (l_log_statement >= l_log_current_level) THEN
1711: FND_LOG.string(l_log_statement, l_full_name,
1712: 'Arrival Space id ' || p_x_flight_schedule_rec.arrival_space_id || ' is not valid.');

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

2190: END IF;
2191: EXCEPTION
2192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2194: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2195: p_count => l_msg_count,
2196: p_data => l_msg_data);
2197:
2198: WHEN FND_API.G_EXC_ERROR THEN

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

2196: p_data => l_msg_data);
2197:
2198: WHEN FND_API.G_EXC_ERROR THEN
2199: x_return_status := FND_API.G_RET_STS_ERROR;
2200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2201: p_count => l_msg_count,
2202: p_data => l_msg_data);
2203:
2204: WHEN OTHERS THEN

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

2202: p_data => l_msg_data);
2203:
2204: WHEN OTHERS THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2207: THEN
2208: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2209: p_procedure_name => l_api_name,
2210: p_error_text => SUBSTR(SQLERRM,1,240));

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

2204: WHEN OTHERS THEN
2205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2207: THEN
2208: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2209: p_procedure_name => l_api_name,
2210: p_error_text => SUBSTR(SQLERRM,1,240));
2211:
2212: END IF;

Line 2213: FND_MSG_PUB.count_and_get

2209: p_procedure_name => l_api_name,
2210: p_error_text => SUBSTR(SQLERRM,1,240));
2211:
2212: END IF;
2213: FND_MSG_PUB.count_and_get
2214: (
2215: p_count => l_msg_count,
2216: p_data => l_msg_data,
2217: p_encoded => FND_API.G_FALSE

Line 2917: FND_MSG_PUB.add;

2913: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
2914: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
2915: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
2916: ) );
2917: FND_MSG_PUB.add;
2918: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2919: fnd_log.string
2920: (
2921: fnd_log.level_error,

Line 3302: FND_MSG_PUB.add;

3298: FND_MESSAGE.set_name('AHL','AHL_COM_RECORD_CHANGED');
3299: FND_MESSAGE.set_token( 'RECORD', get_record_identifier(
3300: p_flight_schedule_rec => p_x_flight_schedules_tbl(i)
3301: ) );
3302: FND_MSG_PUB.add;
3303: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3304: fnd_log.string
3305: (
3306: fnd_log.level_error,

Line 3362: FND_MSG_PUB.initialize;

3358: END IF;
3359:
3360: -- Initialize message list if p_init_msg_list is set to TRUE.
3361: IF FND_API.to_boolean(p_init_msg_list) THEN
3362: FND_MSG_PUB.initialize;
3363: END IF;
3364:
3365: --Local procedure for Deleting Flight Schedules
3366: Delete_Flight_Schedules(

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

3421: -- Bug # 9075539 - start
3422: IF l_return_status = 'V'
3423: THEN
3424: x_return_status := 'V';
3425: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3426: p_count => x_msg_count,
3427: p_data => X_msg_data);
3428: END IF;
3429: -- Bug # 9075539 - end

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

3439: EXCEPTION
3440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3441: ROLLBACK TO process_flight_schedules_pvt;
3442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3443: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3444: p_count => x_msg_count,
3445: p_data => x_msg_data);
3446:
3447: WHEN FND_API.G_EXC_ERROR THEN

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

3446:
3447: WHEN FND_API.G_EXC_ERROR THEN
3448: ROLLBACK TO process_flight_schedules_pvt;
3449: x_return_status := FND_API.G_RET_STS_ERROR;
3450: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3451: p_count => x_msg_count,
3452: p_data => X_msg_data);
3453:
3454: WHEN OTHERS THEN

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

3453:
3454: WHEN OTHERS THEN
3455: ROLLBACK TO process_flight_schedules_pvt;
3456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3458: THEN
3459: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3460: p_procedure_name => l_api_name,
3461: p_error_text => SUBSTR(SQLERRM,1,240));

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

3455: ROLLBACK TO process_flight_schedules_pvt;
3456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3458: THEN
3459: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3460: p_procedure_name => l_api_name,
3461: p_error_text => SUBSTR(SQLERRM,1,240));
3462:
3463: END IF;

Line 3464: FND_MSG_PUB.count_and_get

3460: p_procedure_name => l_api_name,
3461: p_error_text => SUBSTR(SQLERRM,1,240));
3462:
3463: END IF;
3464: FND_MSG_PUB.count_and_get
3465: (
3466: p_count => x_msg_count,
3467: p_data => x_msg_data,
3468: p_encoded => FND_API.G_FALSE

Line 3534: FND_MSG_PUB.add;

3530: -- Throw error if p_unit_schedule_id is null
3531:
3532: IF p_unit_schedule_id IS NULL THEN
3533: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
3534: FND_MSG_PUB.add;
3535: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3536: fnd_log.string
3537: (
3538: fnd_log.level_error,

Line 3550: FND_MSG_PUB.add;

3546: OPEN check_flight_exists_csr(p_unit_schedule_id, p_unit_config_id);
3547: FETCH check_flight_exists_csr INTO l_dummy;
3548: IF check_flight_exists_csr%NOTFOUND THEN
3549: FND_MESSAGE.set_name('AHL','AHL_UA_US_NOT_FOUND');
3550: FND_MSG_PUB.add;
3551: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3552: fnd_log.string
3553: (
3554: fnd_log.level_error,

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

3573: END IF;
3574: EXCEPTION
3575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3578: p_count => x_msg_count,
3579: p_data => x_msg_data);
3580:
3581: WHEN FND_API.G_EXC_ERROR THEN

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

3579: p_data => x_msg_data);
3580:
3581: WHEN FND_API.G_EXC_ERROR THEN
3582: x_return_status := FND_API.G_RET_STS_ERROR;
3583: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3584: p_count => x_msg_count,
3585: p_data => X_msg_data);
3586:
3587: WHEN OTHERS THEN

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

3585: p_data => X_msg_data);
3586:
3587: WHEN OTHERS THEN
3588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3590: THEN
3591: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3592: p_procedure_name => l_api_name,
3593: p_error_text => SUBSTR(SQLERRM,1,240));

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

3587: WHEN OTHERS THEN
3588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3590: THEN
3591: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3592: p_procedure_name => l_api_name,
3593: p_error_text => SUBSTR(SQLERRM,1,240));
3594:
3595: END IF;

Line 3596: FND_MSG_PUB.count_and_get

3592: p_procedure_name => l_api_name,
3593: p_error_text => SUBSTR(SQLERRM,1,240));
3594:
3595: END IF;
3596: FND_MSG_PUB.count_and_get
3597: (
3598: p_count => x_msg_count,
3599: p_data => x_msg_data,
3600: p_encoded => FND_API.G_FALSE