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

Line 223: FND_MSG_PUB.ADD;

219: )
220: THEN
221: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
222: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
223: FND_MSG_PUB.ADD;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: /*

Line 234: FND_MSG_PUB.ADD;

230: FETCH check_unit_exists INTO l_dummy_varchar;
231: IF (check_unit_exists%NOTFOUND)
232: THEN
233: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
234: FND_MSG_PUB.ADD;
235: CLOSE check_unit_exists;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: CLOSE check_unit_exists;

Line 326: x_msg_count := FND_MSG_PUB.count_msg;

322: );
323: END IF;
324:
325: -- Check Error Message stack.
326: x_msg_count := FND_MSG_PUB.count_msg;
327: IF x_msg_count > 0
328: THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;

Line 333: FND_MSG_PUB.count_and_get

329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:
332: -- Standard call to get message count and if count is 1, get message info
333: FND_MSG_PUB.count_and_get
334: (
335: p_count => x_msg_count,
336: p_data => x_msg_data,
337: p_encoded => FND_API.G_FALSE

Line 343: FND_MSG_PUB.count_and_get

339:
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: FND_MSG_PUB.count_and_get
344: (
345: p_count => x_msg_count,
346: p_data => x_msg_data,
347: p_encoded => FND_API.G_FALSE

Line 352: FND_MSG_PUB.count_and_get

348: );
349:
350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: FND_MSG_PUB.count_and_get
353: (
354: p_count => x_msg_count,
355: p_data => x_msg_data,
356: p_encoded => FND_API.G_FALSE

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

357: );
358:
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.add_exc_msg
364: (
365: p_pkg_name => G_PKG_NAME,

Line 363: FND_MSG_PUB.add_exc_msg

359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.add_exc_msg
364: (
365: p_pkg_name => G_PKG_NAME,
366: p_procedure_name => 'Get_All_Events',
367: p_error_text => SUBSTR(SQLERRM,1,240)

Line 370: FND_MSG_PUB.count_and_get

366: p_procedure_name => 'Get_All_Events',
367: p_error_text => SUBSTR(SQLERRM,1,240)
368: );
369: END IF;
370: FND_MSG_PUB.count_and_get
371: (
372: p_count => x_msg_count,
373: p_data => x_msg_data,
374: p_encoded => FND_API.G_FALSE

Line 467: FND_MSG_PUB.ADD;

463: )
464: THEN
465: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
466: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
467: FND_MSG_PUB.ADD;
468: RAISE FND_API.G_EXC_ERROR;
469: END IF;
470:
471: /*

Line 478: FND_MSG_PUB.ADD;

474: FETCH check_unit_exists INTO l_dummy_varchar;
475: IF (check_unit_exists%NOTFOUND)
476: THEN
477: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
478: FND_MSG_PUB.ADD;
479: CLOSE check_unit_exists;
480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482: CLOSE check_unit_exists;

Line 649: x_msg_count := FND_MSG_PUB.count_msg;

645: );
646: END IF;
647:
648: -- Check Error Message stack.
649: x_msg_count := FND_MSG_PUB.count_msg;
650: IF x_msg_count > 0
651: THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;

Line 656: FND_MSG_PUB.count_and_get

652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: -- Standard call to get message count and if count is 1, get message info
656: FND_MSG_PUB.count_and_get
657: (
658: p_count => x_msg_count,
659: p_data => x_msg_data,
660: p_encoded => FND_API.G_FALSE

Line 666: FND_MSG_PUB.count_and_get

662:
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: FND_MSG_PUB.count_and_get
667: (
668: p_count => x_msg_count,
669: p_data => x_msg_data,
670: p_encoded => FND_API.G_FALSE

Line 675: FND_MSG_PUB.count_and_get

671: );
672:
673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MSG_PUB.count_and_get
676: (
677: p_count => x_msg_count,
678: p_data => x_msg_data,
679: p_encoded => FND_API.G_FALSE

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

680: );
681:
682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
685: THEN
686: FND_MSG_PUB.add_exc_msg
687: (
688: p_pkg_name => G_PKG_NAME,

Line 686: FND_MSG_PUB.add_exc_msg

682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
685: THEN
686: FND_MSG_PUB.add_exc_msg
687: (
688: p_pkg_name => G_PKG_NAME,
689: p_procedure_name => 'Get_Prec_Flight_Info',
690: p_error_text => SUBSTR(SQLERRM,1,240)

Line 693: FND_MSG_PUB.count_and_get

689: p_procedure_name => 'Get_Prec_Flight_Info',
690: p_error_text => SUBSTR(SQLERRM,1,240)
691: );
692: END IF;
693: FND_MSG_PUB.count_and_get
694: (
695: p_count => x_msg_count,
696: p_data => x_msg_data,
697: p_encoded => FND_API.G_FALSE

Line 812: FND_MSG_PUB.ADD;

808: )
809: THEN
810: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
811: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
812: FND_MSG_PUB.ADD;
813: RAISE FND_API.G_EXC_ERROR;
814: END IF;
815:
816: /*

Line 823: FND_MSG_PUB.ADD;

819: FETCH check_unit_exists INTO l_dummy_varchar;
820: IF (check_unit_exists%NOTFOUND)
821: THEN
822: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
823: FND_MSG_PUB.ADD;
824: CLOSE check_unit_exists;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827: CLOSE check_unit_exists;

Line 911: x_msg_count := FND_MSG_PUB.count_msg;

907: );
908: END IF;
909:
910: -- Check Error Message stack.
911: x_msg_count := FND_MSG_PUB.count_msg;
912: IF x_msg_count > 0
913: THEN
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;

Line 918: FND_MSG_PUB.count_and_get

914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- Standard call to get message count and if count is 1, get message info
918: FND_MSG_PUB.count_and_get
919: (
920: p_count => x_msg_count,
921: p_data => x_msg_data,
922: p_encoded => FND_API.G_FALSE

Line 928: FND_MSG_PUB.count_and_get

924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: x_return_status := FND_API.G_RET_STS_ERROR;
928: FND_MSG_PUB.count_and_get
929: (
930: p_count => x_msg_count,
931: p_data => x_msg_data,
932: p_encoded => FND_API.G_FALSE

Line 937: FND_MSG_PUB.count_and_get

933: );
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
937: FND_MSG_PUB.count_and_get
938: (
939: p_count => x_msg_count,
940: p_data => x_msg_data,
941: p_encoded => FND_API.G_FALSE

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

942: );
943:
944: WHEN OTHERS THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.add_exc_msg
949: (
950: p_pkg_name => G_PKG_NAME,

Line 948: FND_MSG_PUB.add_exc_msg

944: WHEN OTHERS THEN
945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.add_exc_msg
949: (
950: p_pkg_name => G_PKG_NAME,
951: p_procedure_name => 'Get_Prec_Visit_Info',
952: p_error_text => SUBSTR(SQLERRM,1,240)

Line 955: FND_MSG_PUB.count_and_get

951: p_procedure_name => 'Get_Prec_Visit_Info',
952: p_error_text => SUBSTR(SQLERRM,1,240)
953: );
954: END IF;
955: FND_MSG_PUB.count_and_get
956: (
957: p_count => x_msg_count,
958: p_data => x_msg_data,
959: p_encoded => FND_API.G_FALSE

Line 1073: FND_MSG_PUB.ADD;

1069: )
1070: THEN
1071: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1072: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
1073: FND_MSG_PUB.ADD;
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076:
1077: /*

Line 1084: FND_MSG_PUB.ADD;

1080: FETCH check_unit_exists INTO l_dummy_varchar;
1081: IF (check_unit_exists%NOTFOUND)
1082: THEN
1083: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
1084: FND_MSG_PUB.ADD;
1085: CLOSE check_unit_exists;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;
1088: CLOSE check_unit_exists;

Line 1170: x_msg_count := FND_MSG_PUB.count_msg;

1166: );
1167: END IF;
1168:
1169: -- Check Error Message stack.
1170: x_msg_count := FND_MSG_PUB.count_msg;
1171: IF x_msg_count > 0
1172: THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;

Line 1177: FND_MSG_PUB.count_and_get

1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176: -- Standard call to get message count and if count is 1, get message info
1177: FND_MSG_PUB.count_and_get
1178: (
1179: p_count => x_msg_count,
1180: p_data => x_msg_data,
1181: p_encoded => FND_API.G_FALSE

Line 1187: FND_MSG_PUB.count_and_get

1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: x_return_status := FND_API.G_RET_STS_ERROR;
1187: FND_MSG_PUB.count_and_get
1188: (
1189: p_count => x_msg_count,
1190: p_data => x_msg_data,
1191: p_encoded => FND_API.G_FALSE

Line 1196: FND_MSG_PUB.count_and_get

1192: );
1193:
1194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: FND_MSG_PUB.count_and_get
1197: (
1198: p_count => x_msg_count,
1199: p_data => x_msg_data,
1200: p_encoded => FND_API.G_FALSE

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

1201: );
1202:
1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg
1208: (
1209: p_pkg_name => G_PKG_NAME,

Line 1207: FND_MSG_PUB.add_exc_msg

1203: WHEN OTHERS THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1206: THEN
1207: FND_MSG_PUB.add_exc_msg
1208: (
1209: p_pkg_name => G_PKG_NAME,
1210: p_procedure_name => 'Get_Succ_Visit_Info',
1211: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1214: FND_MSG_PUB.count_and_get

1210: p_procedure_name => 'Get_Succ_Visit_Info',
1211: p_error_text => SUBSTR(SQLERRM,1,240)
1212: );
1213: END IF;
1214: FND_MSG_PUB.count_and_get
1215: (
1216: p_count => x_msg_count,
1217: p_data => x_msg_data,
1218: p_encoded => FND_API.G_FALSE

Line 1284: FND_MSG_PUB.ADD;

1280: )
1281: THEN
1282: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1283: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
1284: FND_MSG_PUB.ADD;
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288: /*

Line 1295: FND_MSG_PUB.ADD;

1291: FETCH check_unit_exists INTO l_dummy_varchar;
1292: IF (check_unit_exists%NOTFOUND)
1293: THEN
1294: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
1295: FND_MSG_PUB.ADD;
1296: CLOSE check_unit_exists;
1297: RAISE FND_API.G_EXC_ERROR;
1298: END IF;
1299: CLOSE check_unit_exists;

Line 1330: x_msg_count := FND_MSG_PUB.count_msg;

1326: l_prec_flight_schedule ,
1327: l_is_flight_conflict
1328: );
1329: -- Check Error Message stack.
1330: x_msg_count := FND_MSG_PUB.count_msg;
1331: IF x_msg_count > 0
1332: THEN
1333: RAISE FND_API.G_EXC_ERROR;
1334: END IF;

Line 1350: x_msg_count := FND_MSG_PUB.count_msg;

1346: l_prec_visit ,
1347: l_is_visit_conflict
1348: );
1349: -- Check Error Message stack.
1350: x_msg_count := FND_MSG_PUB.count_msg;
1351: IF x_msg_count > 0
1352: THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;

Line 1434: x_msg_count := FND_MSG_PUB.count_msg;

1430: l_prec_visit.org_name,
1431: l_return_status,
1432: l_msg_data
1433: );
1434: x_msg_count := FND_MSG_PUB.count_msg;
1435: IF x_msg_count > 0
1436: THEN
1437: RAISE FND_API.G_EXC_ERROR;
1438: END IF;

Line 1455: x_msg_count := FND_MSG_PUB.count_msg;

1451: );
1452: END IF;
1453:
1454: -- Check Error Message stack.
1455: x_msg_count := FND_MSG_PUB.count_msg;
1456: IF x_msg_count > 0
1457: THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;

Line 1462: FND_MSG_PUB.count_and_get

1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;
1460:
1461: -- Standard call to get message count and if count is 1, get message info
1462: FND_MSG_PUB.count_and_get
1463: (
1464: p_count => x_msg_count,
1465: p_data => x_msg_data,
1466: p_encoded => FND_API.G_FALSE

Line 1472: FND_MSG_PUB.count_and_get

1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MSG_PUB.count_and_get
1473: (
1474: p_count => x_msg_count,
1475: p_data => x_msg_data,
1476: p_encoded => FND_API.G_FALSE

Line 1481: FND_MSG_PUB.count_and_get

1477: );
1478:
1479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481: FND_MSG_PUB.count_and_get
1482: (
1483: p_count => x_msg_count,
1484: p_data => x_msg_data,
1485: p_encoded => FND_API.G_FALSE

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

1486: );
1487:
1488: WHEN OTHERS THEN
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1491: THEN
1492: FND_MSG_PUB.add_exc_msg
1493: (
1494: p_pkg_name => G_PKG_NAME,

Line 1492: FND_MSG_PUB.add_exc_msg

1488: WHEN OTHERS THEN
1489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1490: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1491: THEN
1492: FND_MSG_PUB.add_exc_msg
1493: (
1494: p_pkg_name => G_PKG_NAME,
1495: p_procedure_name => 'Get_Prec_Event_Info',
1496: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1499: FND_MSG_PUB.count_and_get

1495: p_procedure_name => 'Get_Prec_Event_Info',
1496: p_error_text => SUBSTR(SQLERRM,1,240)
1497: );
1498: END IF;
1499: FND_MSG_PUB.count_and_get
1500: (
1501: p_count => x_msg_count,
1502: p_data => x_msg_data,
1503: p_encoded => FND_API.G_FALSE

Line 1570: FND_MSG_PUB.ADD;

1566: )
1567: THEN
1568: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1569: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: /*

Line 1581: FND_MSG_PUB.ADD;

1577: FETCH check_unit_exists INTO l_dummy_varchar;
1578: IF (check_unit_exists%NOTFOUND)
1579: THEN
1580: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
1581: FND_MSG_PUB.ADD;
1582: CLOSE check_unit_exists;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;
1585: CLOSE check_unit_exists;

Line 1616: x_msg_count := FND_MSG_PUB.count_msg;

1612: l_succ_flight_schedule ,
1613: l_is_flight_conflict
1614: );
1615: -- Check Error Message stack.
1616: x_msg_count := FND_MSG_PUB.count_msg;
1617: IF x_msg_count > 0
1618: THEN
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;

Line 1636: x_msg_count := FND_MSG_PUB.count_msg;

1632: l_succ_visit ,
1633: l_is_visit_conflict
1634: );
1635: -- Check Error Message stack.
1636: x_msg_count := FND_MSG_PUB.count_msg;
1637: IF x_msg_count > 0
1638: THEN
1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;

Line 1697: x_msg_count := FND_MSG_PUB.count_msg;

1693: l_return_status,
1694: l_msg_data
1695: );
1696:
1697: x_msg_count := FND_MSG_PUB.count_msg;
1698: IF x_msg_count > 0
1699: THEN
1700: RAISE FND_API.G_EXC_ERROR;
1701: END IF;

Line 1718: x_msg_count := FND_MSG_PUB.count_msg;

1714: );
1715: END IF;
1716:
1717: -- Check Error Message stack.
1718: x_msg_count := FND_MSG_PUB.count_msg;
1719: IF x_msg_count > 0
1720: THEN
1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;

Line 1725: FND_MSG_PUB.count_and_get

1721: RAISE FND_API.G_EXC_ERROR;
1722: END IF;
1723:
1724: -- Standard call to get message count and if count is 1, get message info
1725: FND_MSG_PUB.count_and_get
1726: (
1727: p_count => x_msg_count,
1728: p_data => x_msg_data,
1729: p_encoded => FND_API.G_FALSE

Line 1735: FND_MSG_PUB.count_and_get

1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: FND_MSG_PUB.count_and_get
1736: (
1737: p_count => x_msg_count,
1738: p_data => x_msg_data,
1739: p_encoded => FND_API.G_FALSE

Line 1744: FND_MSG_PUB.count_and_get

1740: );
1741:
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1744: FND_MSG_PUB.count_and_get
1745: (
1746: p_count => x_msg_count,
1747: p_data => x_msg_data,
1748: p_encoded => FND_API.G_FALSE

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

1749: );
1750:
1751: WHEN OTHERS THEN
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1754: THEN
1755: FND_MSG_PUB.add_exc_msg
1756: (
1757: p_pkg_name => G_PKG_NAME,

Line 1755: FND_MSG_PUB.add_exc_msg

1751: WHEN OTHERS THEN
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1754: THEN
1755: FND_MSG_PUB.add_exc_msg
1756: (
1757: p_pkg_name => G_PKG_NAME,
1758: p_procedure_name => 'Get_Succ_Event_Info',
1759: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1762: FND_MSG_PUB.count_and_get

1758: p_procedure_name => 'Get_Succ_Event_Info',
1759: p_error_text => SUBSTR(SQLERRM,1,240)
1760: );
1761: END IF;
1762: FND_MSG_PUB.count_and_get
1763: (
1764: p_count => x_msg_count,
1765: p_data => x_msg_data,
1766: p_encoded => FND_API.G_FALSE

Line 1854: FND_MSG_PUB.ADD;

1850: )
1851: THEN
1852: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1853: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
1854: FND_MSG_PUB.ADD;
1855: RAISE FND_API.G_EXC_ERROR;
1856: END IF;
1857:
1858: /*

Line 1865: FND_MSG_PUB.ADD;

1861: FETCH check_unit_exists INTO l_dummy_varchar;
1862: IF (check_unit_exists%NOTFOUND)
1863: THEN
1864: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
1865: FND_MSG_PUB.ADD;
1866: CLOSE check_unit_exists;
1867: RAISE FND_API.G_EXC_ERROR;
1868: END IF;
1869: CLOSE check_unit_exists;

Line 2030: x_msg_count := FND_MSG_PUB.count_msg;

2026: );
2027: END IF;
2028:
2029: -- Check Error Message stack.
2030: x_msg_count := FND_MSG_PUB.count_msg;
2031: IF x_msg_count > 0
2032: THEN
2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;

Line 2037: FND_MSG_PUB.count_and_get

2033: RAISE FND_API.G_EXC_ERROR;
2034: END IF;
2035:
2036: -- Standard call to get message count and if count is 1, get message info
2037: FND_MSG_PUB.count_and_get
2038: (
2039: p_count => x_msg_count,
2040: p_data => x_msg_data,
2041: p_encoded => FND_API.G_FALSE

Line 2047: FND_MSG_PUB.count_and_get

2043:
2044: EXCEPTION
2045: WHEN FND_API.G_EXC_ERROR THEN
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: FND_MSG_PUB.count_and_get
2048: (
2049: p_count => x_msg_count,
2050: p_data => x_msg_data,
2051: p_encoded => FND_API.G_FALSE

Line 2056: FND_MSG_PUB.count_and_get

2052: );
2053:
2054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2056: FND_MSG_PUB.count_and_get
2057: (
2058: p_count => x_msg_count,
2059: p_data => x_msg_data,
2060: p_encoded => FND_API.G_FALSE

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

2061: );
2062:
2063: WHEN OTHERS THEN
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN
2067: FND_MSG_PUB.add_exc_msg
2068: (
2069: p_pkg_name => G_PKG_NAME,

Line 2067: FND_MSG_PUB.add_exc_msg

2063: WHEN OTHERS THEN
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN
2067: FND_MSG_PUB.add_exc_msg
2068: (
2069: p_pkg_name => G_PKG_NAME,
2070: p_procedure_name => 'Get_Succ_Flight_Info',
2071: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2074: FND_MSG_PUB.count_and_get

2070: p_procedure_name => 'Get_Succ_Flight_Info',
2071: p_error_text => SUBSTR(SQLERRM,1,240)
2072: );
2073: END IF;
2074: FND_MSG_PUB.count_and_get
2075: (
2076: p_count => x_msg_count,
2077: p_data => x_msg_data,
2078: p_encoded => FND_API.G_FALSE