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 222: FND_MSG_PUB.ADD;

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

Line 233: FND_MSG_PUB.ADD;

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

Line 325: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 332: FND_MSG_PUB.count_and_get

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

Line 342: FND_MSG_PUB.count_and_get

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

Line 351: FND_MSG_PUB.count_and_get

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

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

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

Line 362: FND_MSG_PUB.add_exc_msg

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

Line 369: FND_MSG_PUB.count_and_get

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

Line 466: FND_MSG_PUB.ADD;

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

Line 477: FND_MSG_PUB.ADD;

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

Line 658: x_msg_count := FND_MSG_PUB.count_msg;

654: );
655: END IF;
656:
657: -- Check Error Message stack.
658: x_msg_count := FND_MSG_PUB.count_msg;
659: IF x_msg_count > 0
660: THEN
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;

Line 665: FND_MSG_PUB.count_and_get

661: RAISE FND_API.G_EXC_ERROR;
662: END IF;
663:
664: -- Standard call to get message count and if count is 1, get message info
665: FND_MSG_PUB.count_and_get
666: (
667: p_count => x_msg_count,
668: p_data => x_msg_data,
669: p_encoded => FND_API.G_FALSE

Line 675: FND_MSG_PUB.count_and_get

671:
672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_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: FND_MSG_PUB.count_and_get

680: );
681:
682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: FND_MSG_PUB.count_and_get
685: (
686: p_count => x_msg_count,
687: p_data => x_msg_data,
688: p_encoded => FND_API.G_FALSE

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

689: );
690:
691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.add_exc_msg
696: (
697: p_pkg_name => G_PKG_NAME,

Line 695: FND_MSG_PUB.add_exc_msg

691: WHEN OTHERS THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
694: THEN
695: FND_MSG_PUB.add_exc_msg
696: (
697: p_pkg_name => G_PKG_NAME,
698: p_procedure_name => 'Get_Prec_Flight_Info',
699: p_error_text => SUBSTR(SQLERRM,1,240)

Line 702: FND_MSG_PUB.count_and_get

698: p_procedure_name => 'Get_Prec_Flight_Info',
699: p_error_text => SUBSTR(SQLERRM,1,240)
700: );
701: END IF;
702: FND_MSG_PUB.count_and_get
703: (
704: p_count => x_msg_count,
705: p_data => x_msg_data,
706: p_encoded => FND_API.G_FALSE

Line 918: FND_MSG_PUB.ADD;

914: )
915: THEN
916: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
917: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
918: FND_MSG_PUB.ADD;
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921:
922: /*

Line 929: FND_MSG_PUB.ADD;

925: FETCH check_unit_exists INTO l_dummy_varchar;
926: IF (check_unit_exists%NOTFOUND)
927: THEN
928: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
929: FND_MSG_PUB.ADD;
930: CLOSE check_unit_exists;
931: RAISE FND_API.G_EXC_ERROR;
932: END IF;
933: CLOSE check_unit_exists;

Line 1030: x_msg_count := FND_MSG_PUB.count_msg;

1026: );
1027: END IF;
1028:
1029: -- Check Error Message stack.
1030: x_msg_count := FND_MSG_PUB.count_msg;
1031: IF x_msg_count > 0
1032: THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;

Line 1037: FND_MSG_PUB.count_and_get

1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: -- Standard call to get message count and if count is 1, get message info
1037: FND_MSG_PUB.count_and_get
1038: (
1039: p_count => x_msg_count,
1040: p_data => x_msg_data,
1041: p_encoded => FND_API.G_FALSE

Line 1047: FND_MSG_PUB.count_and_get

1043:
1044: EXCEPTION
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: FND_MSG_PUB.count_and_get
1048: (
1049: p_count => x_msg_count,
1050: p_data => x_msg_data,
1051: p_encoded => FND_API.G_FALSE

Line 1056: FND_MSG_PUB.count_and_get

1052: );
1053:
1054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: FND_MSG_PUB.count_and_get
1057: (
1058: p_count => x_msg_count,
1059: p_data => x_msg_data,
1060: p_encoded => FND_API.G_FALSE

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

1061: );
1062:
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.add_exc_msg
1068: (
1069: p_pkg_name => G_PKG_NAME,

Line 1067: FND_MSG_PUB.add_exc_msg

1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.add_exc_msg
1068: (
1069: p_pkg_name => G_PKG_NAME,
1070: p_procedure_name => 'Get_Prec_Visit_Info',
1071: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1074: FND_MSG_PUB.count_and_get

1070: p_procedure_name => 'Get_Prec_Visit_Info',
1071: p_error_text => SUBSTR(SQLERRM,1,240)
1072: );
1073: END IF;
1074: FND_MSG_PUB.count_and_get
1075: (
1076: p_count => x_msg_count,
1077: p_data => x_msg_data,
1078: p_encoded => FND_API.G_FALSE

Line 1286: FND_MSG_PUB.ADD;

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

Line 1297: FND_MSG_PUB.ADD;

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

Line 1395: x_msg_count := FND_MSG_PUB.count_msg;

1391: );
1392: END IF;
1393:
1394: -- Check Error Message stack.
1395: x_msg_count := FND_MSG_PUB.count_msg;
1396: IF x_msg_count > 0
1397: THEN
1398: RAISE FND_API.G_EXC_ERROR;
1399: END IF;

Line 1402: FND_MSG_PUB.count_and_get

1398: RAISE FND_API.G_EXC_ERROR;
1399: END IF;
1400:
1401: -- Standard call to get message count and if count is 1, get message info
1402: FND_MSG_PUB.count_and_get
1403: (
1404: p_count => x_msg_count,
1405: p_data => x_msg_data,
1406: p_encoded => FND_API.G_FALSE

Line 1412: FND_MSG_PUB.count_and_get

1408:
1409: EXCEPTION
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: FND_MSG_PUB.count_and_get
1413: (
1414: p_count => x_msg_count,
1415: p_data => x_msg_data,
1416: p_encoded => FND_API.G_FALSE

Line 1421: FND_MSG_PUB.count_and_get

1417: );
1418:
1419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1421: FND_MSG_PUB.count_and_get
1422: (
1423: p_count => x_msg_count,
1424: p_data => x_msg_data,
1425: p_encoded => FND_API.G_FALSE

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

1426: );
1427:
1428: WHEN OTHERS THEN
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: FND_MSG_PUB.add_exc_msg
1433: (
1434: p_pkg_name => G_PKG_NAME,

Line 1432: FND_MSG_PUB.add_exc_msg

1428: WHEN OTHERS THEN
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: FND_MSG_PUB.add_exc_msg
1433: (
1434: p_pkg_name => G_PKG_NAME,
1435: p_procedure_name => 'Get_Succ_Visit_Info',
1436: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1439: FND_MSG_PUB.count_and_get

1435: p_procedure_name => 'Get_Succ_Visit_Info',
1436: p_error_text => SUBSTR(SQLERRM,1,240)
1437: );
1438: END IF;
1439: FND_MSG_PUB.count_and_get
1440: (
1441: p_count => x_msg_count,
1442: p_data => x_msg_data,
1443: p_encoded => FND_API.G_FALSE

Line 1509: FND_MSG_PUB.ADD;

1505: )
1506: THEN
1507: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1508: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
1509: FND_MSG_PUB.ADD;
1510: RAISE FND_API.G_EXC_ERROR;
1511: END IF;
1512:
1513: /*

Line 1520: FND_MSG_PUB.ADD;

1516: FETCH check_unit_exists INTO l_dummy_varchar;
1517: IF (check_unit_exists%NOTFOUND)
1518: THEN
1519: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
1520: FND_MSG_PUB.ADD;
1521: CLOSE check_unit_exists;
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524: CLOSE check_unit_exists;

Line 1555: x_msg_count := FND_MSG_PUB.count_msg;

1551: l_prec_flight_schedule ,
1552: l_is_flight_conflict
1553: );
1554: -- Check Error Message stack.
1555: x_msg_count := FND_MSG_PUB.count_msg;
1556: IF x_msg_count > 0
1557: THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;

Line 1575: x_msg_count := FND_MSG_PUB.count_msg;

1571: l_prec_visit ,
1572: l_is_visit_conflict
1573: );
1574: -- Check Error Message stack.
1575: x_msg_count := FND_MSG_PUB.count_msg;
1576: IF x_msg_count > 0
1577: THEN
1578: RAISE FND_API.G_EXC_ERROR;
1579: END IF;

Line 1659: x_msg_count := FND_MSG_PUB.count_msg;

1655: l_prec_visit.org_name,
1656: l_return_status,
1657: l_msg_data
1658: );
1659: x_msg_count := FND_MSG_PUB.count_msg;
1660: IF x_msg_count > 0
1661: THEN
1662: RAISE FND_API.G_EXC_ERROR;
1663: END IF;

Line 1680: x_msg_count := FND_MSG_PUB.count_msg;

1676: );
1677: END IF;
1678:
1679: -- Check Error Message stack.
1680: x_msg_count := FND_MSG_PUB.count_msg;
1681: IF x_msg_count > 0
1682: THEN
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;

Line 1687: FND_MSG_PUB.count_and_get

1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685:
1686: -- Standard call to get message count and if count is 1, get message info
1687: FND_MSG_PUB.count_and_get
1688: (
1689: p_count => x_msg_count,
1690: p_data => x_msg_data,
1691: p_encoded => FND_API.G_FALSE

Line 1697: FND_MSG_PUB.count_and_get

1693:
1694: EXCEPTION
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: FND_MSG_PUB.count_and_get
1698: (
1699: p_count => x_msg_count,
1700: p_data => x_msg_data,
1701: p_encoded => FND_API.G_FALSE

Line 1706: FND_MSG_PUB.count_and_get

1702: );
1703:
1704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706: FND_MSG_PUB.count_and_get
1707: (
1708: p_count => x_msg_count,
1709: p_data => x_msg_data,
1710: p_encoded => FND_API.G_FALSE

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

1711: );
1712:
1713: WHEN OTHERS THEN
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1716: THEN
1717: FND_MSG_PUB.add_exc_msg
1718: (
1719: p_pkg_name => G_PKG_NAME,

Line 1717: FND_MSG_PUB.add_exc_msg

1713: WHEN OTHERS THEN
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1716: THEN
1717: FND_MSG_PUB.add_exc_msg
1718: (
1719: p_pkg_name => G_PKG_NAME,
1720: p_procedure_name => 'Get_Prec_Event_Info',
1721: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1724: FND_MSG_PUB.count_and_get

1720: p_procedure_name => 'Get_Prec_Event_Info',
1721: p_error_text => SUBSTR(SQLERRM,1,240)
1722: );
1723: END IF;
1724: FND_MSG_PUB.count_and_get
1725: (
1726: p_count => x_msg_count,
1727: p_data => x_msg_data,
1728: p_encoded => FND_API.G_FALSE

Line 1795: FND_MSG_PUB.ADD;

1791: )
1792: THEN
1793: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
1794: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
1795: FND_MSG_PUB.ADD;
1796: RAISE FND_API.G_EXC_ERROR;
1797: END IF;
1798:
1799: /*

Line 1806: FND_MSG_PUB.ADD;

1802: FETCH check_unit_exists INTO l_dummy_varchar;
1803: IF (check_unit_exists%NOTFOUND)
1804: THEN
1805: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
1806: FND_MSG_PUB.ADD;
1807: CLOSE check_unit_exists;
1808: RAISE FND_API.G_EXC_ERROR;
1809: END IF;
1810: CLOSE check_unit_exists;

Line 1841: x_msg_count := FND_MSG_PUB.count_msg;

1837: l_succ_flight_schedule ,
1838: l_is_flight_conflict
1839: );
1840: -- Check Error Message stack.
1841: x_msg_count := FND_MSG_PUB.count_msg;
1842: IF x_msg_count > 0
1843: THEN
1844: RAISE FND_API.G_EXC_ERROR;
1845: END IF;

Line 1861: x_msg_count := FND_MSG_PUB.count_msg;

1857: l_succ_visit ,
1858: l_is_visit_conflict
1859: );
1860: -- Check Error Message stack.
1861: x_msg_count := FND_MSG_PUB.count_msg;
1862: IF x_msg_count > 0
1863: THEN
1864: RAISE FND_API.G_EXC_ERROR;
1865: END IF;

Line 1922: x_msg_count := FND_MSG_PUB.count_msg;

1918: l_return_status,
1919: l_msg_data
1920: );
1921:
1922: x_msg_count := FND_MSG_PUB.count_msg;
1923: IF x_msg_count > 0
1924: THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;

Line 1943: x_msg_count := FND_MSG_PUB.count_msg;

1939: );
1940: END IF;
1941:
1942: -- Check Error Message stack.
1943: x_msg_count := FND_MSG_PUB.count_msg;
1944: IF x_msg_count > 0
1945: THEN
1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;

Line 1950: FND_MSG_PUB.count_and_get

1946: RAISE FND_API.G_EXC_ERROR;
1947: END IF;
1948:
1949: -- Standard call to get message count and if count is 1, get message info
1950: FND_MSG_PUB.count_and_get
1951: (
1952: p_count => x_msg_count,
1953: p_data => x_msg_data,
1954: p_encoded => FND_API.G_FALSE

Line 1960: FND_MSG_PUB.count_and_get

1956:
1957: EXCEPTION
1958: WHEN FND_API.G_EXC_ERROR THEN
1959: x_return_status := FND_API.G_RET_STS_ERROR;
1960: FND_MSG_PUB.count_and_get
1961: (
1962: p_count => x_msg_count,
1963: p_data => x_msg_data,
1964: p_encoded => FND_API.G_FALSE

Line 1969: FND_MSG_PUB.count_and_get

1965: );
1966:
1967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1969: FND_MSG_PUB.count_and_get
1970: (
1971: p_count => x_msg_count,
1972: p_data => x_msg_data,
1973: p_encoded => FND_API.G_FALSE

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

1974: );
1975:
1976: WHEN OTHERS THEN
1977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1979: THEN
1980: FND_MSG_PUB.add_exc_msg
1981: (
1982: p_pkg_name => G_PKG_NAME,

Line 1980: FND_MSG_PUB.add_exc_msg

1976: WHEN OTHERS THEN
1977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1979: THEN
1980: FND_MSG_PUB.add_exc_msg
1981: (
1982: p_pkg_name => G_PKG_NAME,
1983: p_procedure_name => 'Get_Succ_Event_Info',
1984: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1987: FND_MSG_PUB.count_and_get

1983: p_procedure_name => 'Get_Succ_Event_Info',
1984: p_error_text => SUBSTR(SQLERRM,1,240)
1985: );
1986: END IF;
1987: FND_MSG_PUB.count_and_get
1988: (
1989: p_count => x_msg_count,
1990: p_data => x_msg_data,
1991: p_encoded => FND_API.G_FALSE

Line 2079: FND_MSG_PUB.ADD;

2075: )
2076: THEN
2077: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
2078: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
2079: FND_MSG_PUB.ADD;
2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;
2082:
2083: /*

Line 2090: FND_MSG_PUB.ADD;

2086: FETCH check_unit_exists INTO l_dummy_varchar;
2087: IF (check_unit_exists%NOTFOUND)
2088: THEN
2089: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UNIT_ID_NOT_FOUND');
2090: FND_MSG_PUB.ADD;
2091: CLOSE check_unit_exists;
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094: CLOSE check_unit_exists;

Line 2265: x_msg_count := FND_MSG_PUB.count_msg;

2261: );
2262: END IF;
2263:
2264: -- Check Error Message stack.
2265: x_msg_count := FND_MSG_PUB.count_msg;
2266: IF x_msg_count > 0
2267: THEN
2268: RAISE FND_API.G_EXC_ERROR;
2269: END IF;

Line 2272: FND_MSG_PUB.count_and_get

2268: RAISE FND_API.G_EXC_ERROR;
2269: END IF;
2270:
2271: -- Standard call to get message count and if count is 1, get message info
2272: FND_MSG_PUB.count_and_get
2273: (
2274: p_count => x_msg_count,
2275: p_data => x_msg_data,
2276: p_encoded => FND_API.G_FALSE

Line 2282: FND_MSG_PUB.count_and_get

2278:
2279: EXCEPTION
2280: WHEN FND_API.G_EXC_ERROR THEN
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282: FND_MSG_PUB.count_and_get
2283: (
2284: p_count => x_msg_count,
2285: p_data => x_msg_data,
2286: p_encoded => FND_API.G_FALSE

Line 2291: FND_MSG_PUB.count_and_get

2287: );
2288:
2289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: FND_MSG_PUB.count_and_get
2292: (
2293: p_count => x_msg_count,
2294: p_data => x_msg_data,
2295: p_encoded => FND_API.G_FALSE

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

2296: );
2297:
2298: WHEN OTHERS THEN
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2301: THEN
2302: FND_MSG_PUB.add_exc_msg
2303: (
2304: p_pkg_name => G_PKG_NAME,

Line 2302: FND_MSG_PUB.add_exc_msg

2298: WHEN OTHERS THEN
2299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2300: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2301: THEN
2302: FND_MSG_PUB.add_exc_msg
2303: (
2304: p_pkg_name => G_PKG_NAME,
2305: p_procedure_name => 'Get_Succ_Flight_Info',
2306: p_error_text => SUBSTR(SQLERRM,1,240)

Line 2309: FND_MSG_PUB.count_and_get

2305: p_procedure_name => 'Get_Succ_Flight_Info',
2306: p_error_text => SUBSTR(SQLERRM,1,240)
2307: );
2308: END IF;
2309: FND_MSG_PUB.count_and_get
2310: (
2311: p_count => x_msg_count,
2312: p_data => x_msg_data,
2313: p_encoded => FND_API.G_FALSE