DBA Data[Home] [Help]

APPS.PO_CONTROL_ACTION_VALIDATIONS dependencies on FND_MSG_PUB

Line 226: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

222: END IF ;
223:
224: EXCEPTION
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 230: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

226: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228:
229: WHEN FND_API.G_EXC_ERROR THEN
230: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: WHEN OTHERS THEN
234: IF (G_DEBUG_UNEXP) THEN

Line 240: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

236: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
237: || l_progress || ' SQL CODE IS '||sqlcode);
238: END IF;
239:
240: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242:
243: END qty_rec_grt_ord_chk;
244:

Line 389: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

385: END IF;
386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 393: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

389: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391:
392: WHEN FND_API.G_EXC_ERROR THEN
393: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
394: x_return_status := FND_API.G_RET_STS_ERROR;
395:
396: WHEN OTHERS THEN
397: IF (G_DEBUG_UNEXP) THEN

Line 403: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

399: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
400: || l_progress || ' SQL CODE IS '||sqlcode);
401: END IF;
402:
403: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: END line_price_chk;
407:

Line 590: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

586: END IF;
587:
588: EXCEPTION
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 594: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

590: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592:
593: WHEN FND_API.G_EXC_ERROR THEN
594: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
595: x_return_status := FND_API.G_RET_STS_ERROR;
596:
597: WHEN OTHERS THEN
598: IF (G_DEBUG_UNEXP) THEN

Line 604: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

600: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
601: || l_progress || ' SQL CODE IS '||sqlcode);
602: END IF;
603:
604: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606:
607: END line_ship_qty_chk;
608:

Line 751: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

747:
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 755: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

751: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: WHEN OTHERS THEN
759: IF (G_DEBUG_UNEXP) THEN

Line 765: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

761: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
762: || l_progress || ' SQL CODE IS '||sqlcode);
763: END IF;
764:
765: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767:
768:
769: END line_ship_price_chk;

Line 939: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

935:
936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941:
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 943: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

939: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
941:
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
944: x_return_status := FND_API.G_RET_STS_ERROR;
945:
946: WHEN OTHERS THEN
947: IF (G_DEBUG_UNEXP) THEN

Line 953: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

949: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
950: || l_progress || ' SQL CODE IS '||sqlcode);
951: END IF;
952:
953: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: END ship_dist_qty_chk;
957:

Line 1107: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1103:
1104:
1105: EXCEPTION
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 1111: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1107: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1112: x_return_status := FND_API.G_RET_STS_ERROR;
1113:
1114: WHEN OTHERS THEN
1115: IF (G_DEBUG_UNEXP) THEN

Line 1121: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1117: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
1118: || l_progress || ' SQL CODE IS '||sqlcode);
1119: END IF;
1120:
1121: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1123:
1124:
1125: END lcm_match_option_chk;

Line 1277: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1273:
1274:
1275: EXCEPTION
1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1277: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: WHEN FND_API.G_EXC_ERROR THEN
1281: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 1281: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1277: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279:
1280: WHEN FND_API.G_EXC_ERROR THEN
1281: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1282: x_return_status := FND_API.G_RET_STS_ERROR;
1283:
1284: WHEN OTHERS THEN
1285: IF (G_DEBUG_UNEXP) THEN

Line 1291: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1287: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
1288: || l_progress || ' SQL CODE IS '||sqlcode);
1289: END IF;
1290:
1291: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293:
1294: END lcm_dest_type_chk;
1295:

Line 1457: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1453: END IF;
1454:
1455: EXCEPTION
1456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1457: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1459:
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 1461: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1457: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1459:
1460: WHEN FND_API.G_EXC_ERROR THEN
1461: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1462: x_return_status := FND_API.G_RET_STS_ERROR;
1463:
1464: WHEN OTHERS THEN
1465: IF (G_DEBUG_UNEXP) THEN

Line 1471: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1467: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
1468: || l_progress || ' SQL CODE IS '||sqlcode);
1469: END IF;
1470:
1471: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473:
1474: END qty_del_grt_ord_chk;
1475:

Line 1665: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1661: END IF;
1662:
1663: EXCEPTION
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667:
1668: WHEN FND_API.G_EXC_ERROR THEN
1669: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 1669: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1665: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667:
1668: WHEN FND_API.G_EXC_ERROR THEN
1669: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671:
1672: WHEN OTHERS THEN
1673: IF (G_DEBUG_UNEXP) THEN

Line 1679: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1675: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
1676: || l_progress || ' SQL CODE IS '||sqlcode);
1677: END IF;
1678:
1679: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681:
1682: END qty_bill_grt_ord_chk;
1683:

Line 1860: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1856: END IF;
1857:
1858: EXCEPTION
1859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1860: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862:
1863: WHEN FND_API.G_EXC_ERROR THEN
1864: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 1864: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1860: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862:
1863: WHEN FND_API.G_EXC_ERROR THEN
1864: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1865: x_return_status := FND_API.G_RET_STS_ERROR;
1866:
1867: WHEN OTHERS THEN
1868: IF (G_DEBUG_UNEXP) THEN

Line 1874: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

1870: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
1871: || l_progress || ' SQL CODE IS '||sqlcode);
1872: END IF;
1873:
1874: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1876:
1877: END qty_bill_grt_rec_chk;
1878:

Line 2055: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2051: END IF;
2052:
2053: EXCEPTION
2054: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2055: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2057:
2058: WHEN FND_API.G_EXC_ERROR THEN
2059: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 2059: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2055: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2057:
2058: WHEN FND_API.G_EXC_ERROR THEN
2059: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2060: x_return_status := FND_API.G_RET_STS_ERROR;
2061:
2062: WHEN OTHERS THEN
2063: IF (G_DEBUG_UNEXP) THEN

Line 2069: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2065: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
2066: || l_progress || ' SQL CODE IS '||sqlcode);
2067: END IF;
2068:
2069: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2071:
2072:
2073: END qty_bill_grt_del_chk;

Line 2237: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2233: END IF;
2234:
2235: EXCEPTION
2236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2237: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239:
2240: WHEN FND_API.G_EXC_ERROR THEN
2241: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 2241: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2237: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239:
2240: WHEN FND_API.G_EXC_ERROR THEN
2241: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2242: x_return_status := FND_API.G_RET_STS_ERROR;
2243:
2244: WHEN OTHERS THEN
2245: IF (G_DEBUG_UNEXP) THEN

Line 2251: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2247: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
2248: || l_progress || ' SQL CODE IS '||sqlcode);
2249: END IF;
2250:
2251: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2253:
2254:
2255: END qty_rec_not_del_chk;

Line 2395: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2391: END IF;
2392:
2393: EXCEPTION
2394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2395: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397:
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 2399: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2395: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397:
2398: WHEN FND_API.G_EXC_ERROR THEN
2399: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: WHEN OTHERS THEN
2403: IF (G_DEBUG_UNEXP) THEN

Line 2409: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2405: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
2406: || l_progress || ' SQL CODE IS '||sqlcode);
2407: END IF;
2408:
2409: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411:
2412: END pending_rcv_trx_chk;
2413:

Line 2554: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2550: END IF;
2551:
2552: EXCEPTION
2553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2554: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556:
2557: WHEN FND_API.G_EXC_ERROR THEN
2558: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 2558: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2554: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2556:
2557: WHEN FND_API.G_EXC_ERROR THEN
2558: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2559: x_return_status := FND_API.G_RET_STS_ERROR;
2560:
2561: WHEN OTHERS THEN
2562: IF (G_DEBUG_UNEXP) THEN

Line 2568: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2564: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
2565: || l_progress || ' SQL CODE IS '||sqlcode);
2566: END IF;
2567:
2568: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2570:
2571: END pending_asn_chk;
2572:

Line 2723: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2719:
2720:
2721: EXCEPTION
2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2723: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: WHEN FND_API.G_EXC_ERROR THEN
2727: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 2727: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2723: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: WHEN FND_API.G_EXC_ERROR THEN
2727: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2728: x_return_status := FND_API.G_RET_STS_ERROR;
2729:
2730: WHEN OTHERS THEN
2731: IF (G_DEBUG_UNEXP) THEN

Line 2737: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2733: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
2734: || l_progress || ' SQL CODE IS '||sqlcode);
2735: END IF;
2736:
2737: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2739:
2740:
2741: END invalid_budget_acct_chk;

Line 2890: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2886:
2887:
2888: EXCEPTION
2889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2890: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892:
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 2894: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2890: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2892:
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2895: x_return_status := FND_API.G_RET_STS_ERROR;
2896:
2897: WHEN OTHERS THEN
2898: IF (G_DEBUG_UNEXP) THEN

Line 2904: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

2900: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
2901: || l_progress || ' SQL CODE IS '||sqlcode);
2902: END IF;
2903:
2904: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
2905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2906:
2907: END invalid_charge_acct_chk;
2908:

Line 3046: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3042:
3043:
3044: EXCEPTION
3045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3046: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048:
3049: WHEN FND_API.G_EXC_ERROR THEN
3050: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 3050: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3046: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3048:
3049: WHEN FND_API.G_EXC_ERROR THEN
3050: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3051: x_return_status := FND_API.G_RET_STS_ERROR;
3052:
3053: WHEN OTHERS THEN
3054: IF (G_DEBUG_UNEXP) THEN

Line 3060: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3056: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
3057: || l_progress || ' SQL CODE IS '||sqlcode);
3058: END IF;
3059:
3060: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3062:
3063:
3064: END ga_with_open_std_ref_chk;

Line 3268: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3264: END IF;
3265:
3266: EXCEPTION
3267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3268: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3270:
3271: WHEN FND_API.G_EXC_ERROR THEN
3272: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 3272: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3268: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3270:
3271: WHEN FND_API.G_EXC_ERROR THEN
3272: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3273: x_return_status := FND_API.G_RET_STS_ERROR;
3274:
3275: WHEN OTHERS THEN
3276: IF (G_DEBUG_UNEXP) THEN

Line 3282: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3278: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
3279: || l_progress || ' SQL CODE IS '||sqlcode);
3280: END IF;
3281:
3282: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3284:
3285:
3286: END po_pa_WITH_OPEN_REL_chk;

Line 3414: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3410: END IF;
3411:
3412: EXCEPTION
3413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3414: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3416:
3417: WHEN FND_API.G_EXC_ERROR THEN
3418: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 3418: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3414: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3416:
3417: WHEN FND_API.G_EXC_ERROR THEN
3418: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3419: x_return_status := FND_API.G_RET_STS_ERROR;
3420:
3421: WHEN OTHERS THEN
3422: IF (G_DEBUG_UNEXP) THEN

Line 3428: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3424: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
3425: || l_progress || ' SQL CODE IS '||sqlcode);
3426: END IF;
3427:
3428: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3430:
3431: END cga_with_open_std_ref_chk;
3432:

Line 3499: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3495: END IF;
3496:
3497: EXCEPTION
3498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3499: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3501:
3502: WHEN FND_API.G_EXC_ERROR THEN
3503: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 3503: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3499: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3501:
3502: WHEN FND_API.G_EXC_ERROR THEN
3503: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3504: x_return_status := FND_API.G_RET_STS_ERROR;
3505:
3506: WHEN OTHERS THEN
3507: IF (G_DEBUG_UNEXP) THEN

Line 3513: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

3509: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
3510: || l_progress || ' SQL CODE IS '||sqlcode);
3511: END IF;
3512:
3513: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
3514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3515: END cancel_custom_validation;
3516:
3517:

Line 4107: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4103: END CASE;
4104:
4105: EXCEPTION
4106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4107: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4109:
4110: WHEN FND_API.G_EXC_ERROR THEN
4111: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 4111: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4107: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4109:
4110: WHEN FND_API.G_EXC_ERROR THEN
4111: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4112: x_return_status := FND_API.G_RET_STS_ERROR;
4113:
4114: WHEN OTHERS THEN
4115: IF (G_DEBUG_UNEXP) THEN

Line 4121: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4117: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
4118: || l_progress || ' SQL CODE IS '||sqlcode);
4119: END IF;
4120:
4121: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4123:
4124: END;
4125:

Line 4259: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4255:
4256:
4257: EXCEPTION
4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4259: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4261:
4262: WHEN FND_API.G_EXC_ERROR THEN
4263: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 4263: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4259: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4261:
4262: WHEN FND_API.G_EXC_ERROR THEN
4263: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4264: x_return_status := FND_API.G_RET_STS_ERROR;
4265:
4266: WHEN OTHERS THEN
4267: IF (G_DEBUG_UNEXP) THEN

Line 4273: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4269: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
4270: || l_progress || ' SQL CODE IS '||sqlcode);
4271: END IF;
4272:
4273: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4275:
4276: END po_cancel_action_checks;
4277:

Line 4562: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4558:
4559:
4560: EXCEPTION
4561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4562: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4564:
4565: WHEN FND_API.G_EXC_ERROR THEN
4566: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 4566: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4562: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4564:
4565: WHEN FND_API.G_EXC_ERROR THEN
4566: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4567: x_return_status := FND_API.G_RET_STS_ERROR;
4568:
4569: WHEN OTHERS THEN
4570: IF (G_DEBUG_UNEXP) THEN

Line 4576: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4572: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
4573: || l_progress || ' SQL CODE IS '||sqlcode);
4574: END IF;
4575:
4576: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4578:
4579: END val_security_check;
4580:

Line 4871: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4867: END IF ;
4868:
4869: EXCEPTION
4870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4871: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4873:
4874: WHEN FND_API.G_EXC_ERROR THEN
4875: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 4875: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4871: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4873:
4874: WHEN FND_API.G_EXC_ERROR THEN
4875: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4876: x_return_status := FND_API.G_RET_STS_ERROR;
4877:
4878: WHEN OTHERS THEN
4879: IF (G_DEBUG_UNEXP) THEN

Line 4885: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

4881: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
4882: || l_progress || ' SQL CODE IS '||sqlcode);
4883: END IF;
4884:
4885: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
4886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4887:
4888: END val_doc_state_check;
4889:

Line 4956: FND_MSG_PUB.initialize;

4952: BEGIN
4953:
4954: -- Start standard API initialization
4955: IF FND_API.to_boolean(p_init_msg_list) THEN
4956: FND_MSG_PUB.initialize;
4957: END IF;
4958:
4959: IF NOT FND_API.compatible_api_call(d_api_version, p_api_version,
4960: d_api_name, g_pkg_name) THEN

Line 5223: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5219: END IF;
5220:
5221: EXCEPTION
5222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5223: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5225: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5226: WHEN FND_API.G_EXC_ERROR THEN
5227: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 5225: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5221: EXCEPTION
5222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5223: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5225: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5226: WHEN FND_API.G_EXC_ERROR THEN
5227: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5228: x_return_status := FND_API.G_RET_STS_ERROR;
5229: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

Line 5227: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5223: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5225: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5226: WHEN FND_API.G_EXC_ERROR THEN
5227: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5228: x_return_status := FND_API.G_RET_STS_ERROR;
5229: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5230: WHEN OTHERS THEN
5231: IF (G_DEBUG_UNEXP) THEN

Line 5229: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5225: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5226: WHEN FND_API.G_EXC_ERROR THEN
5227: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5228: x_return_status := FND_API.G_RET_STS_ERROR;
5229: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5230: WHEN OTHERS THEN
5231: IF (G_DEBUG_UNEXP) THEN
5232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
5233: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '

Line 5237: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5233: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
5234: || l_progress || ' SQL CODE IS '||sqlcode);
5235: END IF;
5236:
5237: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5240:
5241: END revert_pending_changes;

Line 5239: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);

5235: END IF;
5236:
5237: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239: FND_MSG_PUB.add_exc_msg(g_pkg_name, d_api_name||':'||l_progress||':'||SQLCODE||':'||SQLERRM);
5240:
5241: END revert_pending_changes;
5242:
5243:

Line 5522: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5518:
5519:
5520: EXCEPTION
5521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5522: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5524:
5525: WHEN FND_API.G_EXC_ERROR THEN
5526: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 5526: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5522: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5524:
5525: WHEN FND_API.G_EXC_ERROR THEN
5526: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5527: x_return_status := FND_API.G_RET_STS_ERROR;
5528:
5529: WHEN OTHERS THEN
5530: IF (G_DEBUG_UNEXP) THEN

Line 5536: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5532: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
5533: || l_progress || ' SQL CODE IS '||sqlcode);
5534: END IF;
5535:
5536: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5538:
5539: END check_revert_pending_changes;
5540:

Line 5732: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

5728: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
5729: || l_progress || ' SQL CODE IS '||sqlcode);
5730: END IF;
5731:
5732: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
5733:
5734:
5735: END check_cancel_reqs_flag;
5736:

Line 6175: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

6171: END IF ;
6172:
6173: EXCEPTION
6174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6175: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
6176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6177:
6178: WHEN FND_API.G_EXC_ERROR THEN
6179: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

Line 6179: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

6175: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
6176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6177:
6178: WHEN FND_API.G_EXC_ERROR THEN
6179: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
6180: x_return_status := FND_API.G_RET_STS_ERROR;
6181:
6182: WHEN OTHERS THEN
6183: IF (G_DEBUG_UNEXP) THEN

Line 6189: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');

6185: d_module || '.OTHERS_EXCEPTION', 'EXCEPTION: LOCATION IS '
6186: || l_progress || ' SQL CODE IS '||sqlcode);
6187: END IF;
6188:
6189: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,P_ENCODED => 'F');
6190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6191:
6192: END validate_doc_params;
6193:

Line 6472: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6468: END IF ;
6469:
6470: EXCEPTION
6471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6472: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6473: P_ENCODED => 'F');
6474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6475:
6476: WHEN FND_API.G_EXC_ERROR THEN

Line 6477: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6473: P_ENCODED => 'F');
6474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6475:
6476: WHEN FND_API.G_EXC_ERROR THEN
6477: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6478: P_ENCODED => 'F');
6479: x_return_status := FND_API.G_RET_STS_ERROR;
6480:
6481: WHEN OTHERS THEN

Line 6489: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6485: || l_progress || ' SQL CODE IS '||sqlcode);
6486: END IF;
6487:
6488:
6489: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6490: P_ENCODED => 'F');
6491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6492:
6493:

Line 6630: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6626: END IF ;
6627:
6628: EXCEPTION
6629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6630: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6631: P_ENCODED => 'F');
6632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6633:
6634: WHEN FND_API.G_EXC_ERROR THEN

Line 6635: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6631: P_ENCODED => 'F');
6632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6633:
6634: WHEN FND_API.G_EXC_ERROR THEN
6635: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6636: P_ENCODED => 'F');
6637: x_return_status := FND_API.G_RET_STS_ERROR;
6638:
6639: WHEN OTHERS THEN

Line 6647: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6643: || l_progress || ' SQL CODE IS '||sqlcode);
6644: END IF;
6645:
6646:
6647: x_return_msg := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6648: P_ENCODED => 'F');
6649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6650:
6651:

Line 6969: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6965:
6966:
6967: EXCEPTION
6968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6969: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6970: P_ENCODED => 'F');
6971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6972: IF (G_DEBUG_UNEXP) THEN
6973: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

Line 6980: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6976: END IF;
6977:
6978:
6979: WHEN FND_API.G_EXC_ERROR THEN
6980: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6981: P_ENCODED => 'F');
6982: x_return_status := FND_API.G_RET_STS_ERROR;
6983:
6984: IF (G_DEBUG_UNEXP) THEN

Line 6998: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,

6994: || l_progress || ' SQL CODE IS '||sqlcode);
6995: END IF;
6996:
6997:
6998: x_msg_data := FND_MSG_PUB.GET(P_MSG_INDEX => FND_MSG_PUB.G_LAST,
6999: P_ENCODED => 'F');
7000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7001:
7002: END validate_cancel_action;