DBA Data[Home] [Help]

APPS.GML_RCV_DIR_RCPT_APIS dependencies on FND_MSG_PUB

Line 299: FND_MSG_PUB.ADD;

295: inv_rcv_common_apis.init_startup_values(p_organization_id);
296: Exception
297: when NO_DATA_FOUND then
298: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
299: FND_MSG_PUB.ADD;
300: RAISE ;
301: End;
302:
303: l_progress := '20';

Line 386: FND_MSG_PUB.ADD;

382: );
383: -- x_status is not successful if there is any execution error in matching.
384: IF x_status = fnd_api.g_ret_sts_error THEN
385: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
386: FND_MSG_PUB.ADD;
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:
390: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

Line 392: FND_MSG_PUB.ADD;

388: END IF;
389:
390: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
391: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
392: FND_MSG_PUB.ADD;
393: RAISE fnd_api.g_exc_unexpected_error;
394: END IF;
395:
396: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

Line 399: FND_MSG_PUB.ADD;

395:
396: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
397: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
398: FND_MESSAGE.SET_NAME('INV', l_err_message);
399: FND_MSG_PUB.ADD;
400: RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: l_err_message := '@@@';

Line 427: FND_MSG_PUB.ADD;

423: END LOOP;
424:
425: IF l_err_message <> '@@@' THEN
426: FND_MESSAGE.SET_NAME(l_msg_prod, l_err_message);
427: FND_MSG_PUB.ADD;
428: END IF;
429: -- End bug fix 2743146
430:
431:

Line 504: fnd_msg_pub.count_and_get

500: IF l_curs_rcpt_detail%isopen THEN
501: CLOSE l_curs_rcpt_detail;
502: END IF;
503:
504: fnd_msg_pub.count_and_get
505: (p_encoded => FND_API.g_false,
506: p_count => l_msg_count,
507: p_data => x_message
508: );

Line 517: fnd_msg_pub.count_and_get

513: IF l_curs_rcpt_detail%isopen THEN
514: CLOSE l_curs_rcpt_detail;
515: END IF;
516:
517: fnd_msg_pub.count_and_get
518: (p_encoded => FND_API.g_false,
519: p_count => l_msg_count,
520: p_data => x_message
521: );

Line 530: fnd_msg_pub.count_and_get

526: x_status := fnd_api.g_ret_sts_unexp_error ;
527: IF l_curs_rcpt_detail%isopen THEN
528: CLOSE l_curs_rcpt_detail;
529: END IF;
530: fnd_msg_pub.count_and_get
531: (p_encoded => FND_API.g_false,
532: p_count => l_msg_count,
533: p_data => x_message
534: );

Line 762: FND_MSG_PUB.ADD;

758: inv_rcv_common_apis.init_startup_values(p_organization_id);
759: Exception
760: when NO_DATA_FOUND then
761: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
762: FND_MSG_PUB.ADD;
763: RAISE ;
764: End;
765:
766: l_progress := '20';

Line 852: FND_MSG_PUB.ADD;

848:
849: -- x_status is not successful if there is any execution error in matching.
850: IF x_status = fnd_api.g_ret_sts_error THEN
851: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
852: FND_MSG_PUB.ADD;
853: RAISE fnd_api.g_exc_error;
854: END IF;
855:
856: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

Line 858: FND_MSG_PUB.ADD;

854: END IF;
855:
856: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
857: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
858: FND_MSG_PUB.ADD;
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:
862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

Line 865: FND_MSG_PUB.ADD;

861:
862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
863: l_err_message := gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
864: FND_MESSAGE.SET_NAME('INV', l_err_message);
865: FND_MSG_PUB.ADD;
866: RAISE fnd_api.g_exc_error;
867: END IF;
868:
869:

Line 894: FND_MSG_PUB.ADD;

890: END LOOP;
891:
892: IF l_err_message <> '@@@' THEN
893: FND_MESSAGE.SET_NAME(l_msg_prod, l_err_message);
894: FND_MSG_PUB.ADD;
895: END IF;
896:
897: -- based on return from matching algorithm,
898: -- determine which line in rcv_transaction block to be inserted into RTI

Line 1047: fnd_msg_pub.count_and_get

1043: IF l_curs_rcpt_detail%isopen THEN
1044: CLOSE l_curs_rcpt_detail;
1045: END IF;
1046:
1047: fnd_msg_pub.count_and_get
1048: (p_encoded => FND_API.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_message
1051: );

Line 1060: fnd_msg_pub.count_and_get

1056: IF l_curs_rcpt_detail%isopen THEN
1057: CLOSE l_curs_rcpt_detail;
1058: END IF;
1059:
1060: fnd_msg_pub.count_and_get
1061: (p_encoded => FND_API.g_false,
1062: p_count => l_msg_count,
1063: p_data => x_message
1064: );

Line 1074: fnd_msg_pub.count_and_get

1070: x_status := fnd_api.g_ret_sts_unexp_error ;
1071: IF l_curs_rcpt_detail%isopen THEN
1072: CLOSE l_curs_rcpt_detail;
1073: END IF;
1074: fnd_msg_pub.count_and_get
1075: (p_encoded => FND_API.g_false,
1076: p_count => l_msg_count,
1077: p_data => x_message
1078: );

Line 1323: FND_MSG_PUB.ADD;

1319: inv_rcv_common_apis.init_startup_values(p_organization_id);
1320: Exception
1321: when NO_DATA_FOUND then
1322: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
1323: FND_MSG_PUB.ADD;
1324: RAISE ;
1325: End;
1326:
1327: l_progress := '20';

Line 1385: FND_MSG_PUB.ADD;

1381:
1382: -- x_status is not successful if there is any execution error in matching.
1383: IF x_status = fnd_api.g_ret_sts_error THEN
1384: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1385: FND_MSG_PUB.ADD;
1386: RAISE fnd_api.g_exc_error;
1387: END IF;
1388:
1389: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1391: FND_MSG_PUB.ADD;

1387: END IF;
1388:
1389: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1390: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1391: FND_MSG_PUB.ADD;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;
1394:
1395: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

Line 1398: FND_MSG_PUB.ADD;

1394:
1395: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1396: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1397: FND_MESSAGE.SET_NAME('INV', l_err_message);
1398: FND_MSG_PUB.ADD;
1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: l_err_message := '@@@';

Line 1426: FND_MSG_PUB.ADD;

1422: END LOOP;
1423:
1424: IF l_err_message <> '@@@' THEN
1425: FND_MESSAGE.SET_NAME(l_msg_prod, l_err_message);
1426: FND_MSG_PUB.ADD;
1427: END IF;
1428:
1429: l_progress := '50';
1430:

Line 1540: fnd_msg_pub.count_and_get

1536: IF l_curs_rcpt_detail%isopen THEN
1537: CLOSE l_curs_rcpt_detail;
1538: END IF;
1539:
1540: fnd_msg_pub.count_and_get
1541: (p_encoded => FND_API.g_false,
1542: p_count => l_msg_count,
1543: p_data => x_message
1544: );

Line 1553: fnd_msg_pub.count_and_get

1549: IF l_curs_rcpt_detail%isopen THEN
1550: CLOSE l_curs_rcpt_detail;
1551: END IF;
1552:
1553: fnd_msg_pub.count_and_get
1554: (p_encoded => FND_API.g_false,
1555: p_count => l_msg_count,
1556: p_data => x_message
1557: );

Line 1566: fnd_msg_pub.count_and_get

1562: x_status := fnd_api.g_ret_sts_unexp_error ;
1563: IF l_curs_rcpt_detail%isopen THEN
1564: CLOSE l_curs_rcpt_detail;
1565: END IF;
1566: fnd_msg_pub.count_and_get
1567: (p_encoded => FND_API.g_false,
1568: p_count => l_msg_count,
1569: p_data => x_message
1570: );

Line 1782: FND_MSG_PUB.ADD;

1778: inv_rcv_common_apis.init_startup_values(p_organization_id);
1779: Exception
1780: when NO_DATA_FOUND then
1781: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
1782: FND_MSG_PUB.ADD;
1783: RAISE ;
1784: End;
1785:
1786: l_progress := '20';

Line 1841: FND_MSG_PUB.ADD;

1837:
1838: -- x_status is not successful if there is any execution error in matching.
1839: IF x_status = fnd_api.g_ret_sts_error THEN
1840: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1841: FND_MSG_PUB.ADD;
1842: RAISE fnd_api.g_exc_error;
1843: END IF;
1844:
1845: IF x_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1847: FND_MSG_PUB.ADD;

1843: END IF;
1844:
1845: IF x_status = fnd_api.g_ret_sts_unexp_error THEN
1846: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
1847: FND_MSG_PUB.ADD;
1848: RAISE fnd_api.g_exc_unexpected_error;
1849: END IF;
1850:
1851: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

Line 1854: FND_MSG_PUB.ADD;

1850:
1851: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1852: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1853: FND_MESSAGE.SET_NAME('INV', l_err_message);
1854: FND_MSG_PUB.ADD;
1855: RAISE fnd_api.g_exc_error;
1856: END IF;
1857:
1858: l_err_message := '@@@';

Line 1882: FND_MSG_PUB.ADD;

1878: END LOOP;
1879:
1880: IF l_err_message <> '@@@' THEN
1881: FND_MESSAGE.SET_NAME(l_msg_prod, l_err_message);
1882: FND_MSG_PUB.ADD;
1883: END IF;
1884:
1885: -- based on return from matching algorithm,
1886: -- determine which line in rcv_transaction block to be inserted into RTI

Line 1969: fnd_msg_pub.count_and_get

1965: IF l_curs_rcpt_detail%isopen THEN
1966: CLOSE l_curs_rcpt_detail;
1967: END IF;
1968:
1969: fnd_msg_pub.count_and_get
1970: (p_encoded => FND_API.g_false,
1971: p_count => l_msg_count,
1972: p_data => x_message
1973: );

Line 1982: fnd_msg_pub.count_and_get

1978: IF l_curs_rcpt_detail%isopen THEN
1979: CLOSE l_curs_rcpt_detail;
1980: END IF;
1981:
1982: fnd_msg_pub.count_and_get
1983: (p_encoded => FND_API.g_false,
1984: p_count => l_msg_count,
1985: p_data => x_message
1986: );

Line 1994: fnd_msg_pub.count_and_get

1990: x_status := fnd_api.g_ret_sts_unexp_error ;
1991: IF l_curs_rcpt_detail%isopen THEN
1992: CLOSE l_curs_rcpt_detail;
1993: END IF;
1994: fnd_msg_pub.count_and_get
1995: (p_encoded => FND_API.g_false,
1996: p_count => l_msg_count,
1997: p_data => x_message
1998: );

Line 2409: FND_MSG_PUB.ADD;

2405: INV_rcv_common_apis.init_startup_values(p_organization_id);
2406: Exception
2407: when NO_DATA_FOUND then
2408: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_PARAM');
2409: FND_MSG_PUB.ADD;
2410: RAISE fnd_api.g_exc_error ;
2411: End;
2412:
2413: -- default header level non-DB items in rcv_transaction block

Line 2522: FND_MSG_PUB.ADD;

2518: */
2519:
2520: IF l_return_status = fnd_api.g_ret_sts_error THEN
2521: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
2522: FND_MSG_PUB.ADD;
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:
2526: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2528: FND_MSG_PUB.ADD;

2524: END IF;
2525:
2526: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2527: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_MATCH_ERROR');
2528: FND_MSG_PUB.ADD;
2529: RAISE fnd_api.g_exc_unexpected_error;
2530: END IF;
2531:
2532: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

Line 2535: FND_MSG_PUB.ADD;

2531:
2532: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2533: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
2534: FND_MESSAGE.SET_NAME('INV', l_err_message);
2535: FND_MSG_PUB.ADD;
2536: RAISE fnd_api.g_exc_error;
2537: END IF;
2538:
2539: l_err_message := '@@@';

Line 2563: FND_MSG_PUB.ADD;

2559: END LOOP;
2560:
2561: IF l_err_message <> '@@@' THEN
2562: FND_MESSAGE.SET_NAME(l_msg_prod, l_err_message);
2563: FND_MSG_PUB.ADD;
2564: END IF;
2565:
2566:
2567: -- load the matching algorithm result into input data structure

Line 2715: fnd_msg_pub.count_and_get

2711: IF l_curs_rcpt_detail%isopen THEN
2712: CLOSE l_curs_rcpt_detail;
2713: END IF;
2714:
2715: fnd_msg_pub.count_and_get
2716: (p_encoded => FND_API.g_false,
2717: p_count => l_msg_count,
2718: p_data => x_message
2719: );

Line 2728: fnd_msg_pub.count_and_get

2724: IF l_curs_rcpt_detail%isopen THEN
2725: CLOSE l_curs_rcpt_detail;
2726: END IF;
2727:
2728: fnd_msg_pub.count_and_get
2729: (p_encoded => FND_API.g_false,
2730: p_count => l_msg_count,
2731: p_data => x_message
2732: );

Line 2743: fnd_msg_pub.count_and_get

2739: CLOSE l_curs_rcpt_detail;
2740: END IF;
2741:
2742:
2743: fnd_msg_pub.count_and_get
2744: (p_encoded => FND_API.g_false,
2745: p_count => l_msg_count,
2746: p_data => x_message
2747: );

Line 2940: FND_MSG_PUB.ADD;

2936: uom_rate => l_uom_conv_ratio);
2937:
2938: IF l_uom_conv_ratio = -99999 THEN -- uom conversion failure
2939: FND_MESSAGE.SET_NAME('INV', 'INV_INT_UOMCONVCODE');
2940: FND_MSG_PUB.ADD;
2941: RAISE fnd_api.g_exc_error;
2942: END IF;
2943:
2944: l_primary_qty := l_quantity * l_uom_conv_ratio;

Line 2960: FND_MSG_PUB.ADD;

2956: x_msg_data => l_msg_data);
2957:
2958: IF l_return_status = FND_API.g_ret_sts_error THEN
2959: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
2960: FND_MSG_PUB.ADD;
2961: RAISE FND_API.G_EXC_ERROR;
2962: END IF;
2963:
2964: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2966: FND_MSG_PUB.ADD;

2962: END IF;
2963:
2964: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2965: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
2966: FND_MSG_PUB.ADD;
2967: RAISE FND_API.g_exc_unexpected_error;
2968: END IF;
2969:
2970: END IF;

Line 3079: FND_MSG_PUB.ADD;

3075: );
3076:
3077: IF l_return_status = FND_API.g_ret_sts_error THEN
3078: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
3079: FND_MSG_PUB.ADD;
3080: RAISE FND_API.G_EXC_ERROR;
3081: END IF;
3082:
3083: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3085: FND_MSG_PUB.ADD;

3081: END IF;
3082:
3083: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3084: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL');
3085: FND_MSG_PUB.ADD;
3086: RAISE FND_API.g_exc_unexpected_error;
3087: END IF;
3088:
3089:

Line 3136: fnd_msg_pub.count_and_get

3132: IF l_curs_asn_lpn_content%isopen THEN
3133: CLOSE l_curs_asn_lpn_content;
3134: END IF;
3135:
3136: fnd_msg_pub.count_and_get
3137: (p_encoded => FND_API.g_false,
3138: p_count => l_msg_count,
3139: p_data => x_message
3140: );

Line 3148: fnd_msg_pub.count_and_get

3144: IF l_curs_asn_lpn_content%isopen THEN
3145: CLOSE l_curs_asn_lpn_content;
3146: END IF;
3147:
3148: fnd_msg_pub.count_and_get
3149: (p_encoded => FND_API.g_false,
3150: p_count => l_msg_count,
3151: p_data => x_message
3152: );

Line 3162: fnd_msg_pub.count_and_get

3158: CLOSE l_curs_asn_lpn_content;
3159: END IF;
3160:
3161:
3162: fnd_msg_pub.count_and_get
3163: (p_encoded => FND_API.g_false,
3164: p_count => l_msg_count,
3165: p_data => x_message
3166: );

Line 3257: FND_MSG_PUB.ADD;

3253: x_message => x_message);
3254:
3255: IF l_return_status = FND_API.g_ret_sts_error THEN
3256: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3257: FND_MSG_PUB.ADD;
3258: RAISE FND_API.G_EXC_ERROR;
3259: END IF;
3260: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3261: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 3262: FND_MSG_PUB.ADD;

3258: RAISE FND_API.G_EXC_ERROR;
3259: END IF;
3260: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3261: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3262: FND_MSG_PUB.ADD;
3263: RAISE FND_API.g_exc_unexpected_error;
3264: END IF;
3265:
3266: l_progress := '40';

Line 3296: FND_MSG_PUB.ADD;

3292: );
3293:
3294: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3295: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
3296: FND_MSG_PUB.ADD;
3297: x_status := 'W';
3298: END IF;
3299:
3300: END IF;

Line 3305: fnd_msg_pub.count_and_get

3301:
3302: EXCEPTION
3303: WHEN fnd_api.g_exc_error THEN
3304: x_status := fnd_api.g_ret_sts_error;
3305: fnd_msg_pub.count_and_get
3306: (p_encoded => FND_API.g_false,
3307: p_count => l_msg_count,
3308: p_data => x_message
3309: );

Line 3313: fnd_msg_pub.count_and_get

3309: );
3310:
3311: WHEN fnd_api.g_exc_unexpected_error THEN
3312: x_status := fnd_api.g_ret_sts_unexp_error ;
3313: fnd_msg_pub.count_and_get
3314: (p_encoded => FND_API.g_false,
3315: p_count => l_msg_count,
3316: p_data => x_message
3317: );

Line 3321: fnd_msg_pub.count_and_get

3317: );
3318:
3319: WHEN OTHERS THEN
3320: x_status := fnd_api.g_ret_sts_unexp_error ;
3321: fnd_msg_pub.count_and_get
3322: (p_encoded => FND_API.g_false,
3323: p_count => l_msg_count,
3324: p_data => x_message
3325: );

Line 3465: FND_MSG_PUB.ADD;

3461: p_country_code => p_country_code);
3462:
3463: IF l_return_status = FND_API.g_ret_sts_error THEN
3464: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3465: FND_MSG_PUB.ADD;
3466: RAISE FND_API.G_EXC_ERROR;
3467: END IF;
3468: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD

Line 3470: FND_MSG_PUB.ADD;

3466: RAISE FND_API.G_EXC_ERROR;
3467: END IF;
3468: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_PO_RTI_FAIL'); -- MSGTBD
3470: FND_MSG_PUB.ADD;
3471: RAISE FND_API.g_exc_unexpected_error;
3472: END IF;
3473:
3474: ELSIF p_shipment_header_id IS NOT NULL THEN

Line 3503: FND_MSG_PUB.ADD;

3499: );
3500:
3501: IF l_return_status = FND_API.g_ret_sts_error THEN
3502: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
3503: FND_MSG_PUB.ADD;
3504: RAISE FND_API.G_EXC_ERROR;
3505: END IF;
3506:
3507:

Line 3510: FND_MSG_PUB.ADD;

3506:
3507:
3508: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3509: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_ASNEXP_RTI_FAIL'); -- MSGTBD
3510: FND_MSG_PUB.ADD;
3511: RAISE FND_API.g_exc_unexpected_error;
3512: END IF;
3513: ELSE
3514: l_progress := '50';

Line 3535: FND_MSG_PUB.ADD;

3531: );
3532:
3533: IF l_return_status = FND_API.g_ret_sts_error THEN
3534: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3535: FND_MSG_PUB.ADD;
3536: RAISE FND_API.G_EXC_ERROR;
3537: END IF;
3538:
3539:

Line 3542: FND_MSG_PUB.ADD;

3538:
3539:
3540: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3541: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3542: FND_MSG_PUB.ADD;
3543: RAISE FND_API.g_exc_unexpected_error;
3544: END IF;
3545:
3546: END IF;

Line 3578: FND_MSG_PUB.ADD;

3574: );
3575:
3576: IF l_return_status = FND_API.g_ret_sts_error THEN
3577: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_ASNCON_RTI_FAIL'); -- MSGTBD
3578: FND_MSG_PUB.ADD;
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581:
3582:

Line 3585: FND_MSG_PUB.ADD;

3581:
3582:
3583: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3584: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_INTSHIPEXP_RTI_FAIL'); -- MSGTBD
3585: FND_MSG_PUB.ADD;
3586: RAISE FND_API.g_exc_unexpected_error;
3587: END IF;
3588:
3589:

Line 3614: FND_MSG_PUB.ADD;

3610: x_message => x_message,
3611: p_country_code => p_country_code);
3612: IF l_return_status = FND_API.g_ret_sts_error THEN
3613: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;
3617: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3618: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD

Line 3619: FND_MSG_PUB.ADD;

3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;
3617: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3618: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_INSHP_RTI_FAIL'); -- MSGTBD
3619: FND_MSG_PUB.ADD;
3620: RAISE FND_API.g_exc_unexpected_error;
3621: END IF;
3622:
3623: END IF;

Line 3651: FND_MSG_PUB.ADD;

3647: p_task_id => p_task_id,
3648: p_country_code => p_country_code );
3649: IF l_return_status = FND_API.g_ret_sts_error THEN
3650: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3651: FND_MSG_PUB.ADD;
3652: RAISE FND_API.G_EXC_ERROR;
3653: END IF;
3654: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3655: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD

Line 3656: FND_MSG_PUB.ADD;

3652: RAISE FND_API.G_EXC_ERROR;
3653: END IF;
3654: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3655: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CREATE_RMA_RTI_FAIL'); -- MSGTBD
3656: FND_MSG_PUB.ADD;
3657: RAISE FND_API.g_exc_unexpected_error;
3658: END IF;
3659: END IF;
3660:

Line 3692: FND_MSG_PUB.ADD;

3688: );
3689:
3690: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3691: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
3692: FND_MSG_PUB.ADD;
3693: x_status := 'W';
3694: END IF;
3695:
3696: END IF;

Line 3702: fnd_msg_pub.count_and_get

3698:
3699: EXCEPTION
3700: WHEN fnd_api.g_exc_error THEN
3701: x_status := fnd_api.g_ret_sts_error;
3702: fnd_msg_pub.count_and_get
3703: (p_encoded => FND_API.g_false,
3704: p_count => l_msg_count,
3705: p_data => x_message
3706: );

Line 3710: fnd_msg_pub.count_and_get

3706: );
3707:
3708: WHEN fnd_api.g_exc_unexpected_error THEN
3709: x_status := fnd_api.g_ret_sts_unexp_error ;
3710: fnd_msg_pub.count_and_get
3711: (p_encoded => FND_API.g_false,
3712: p_count => l_msg_count,
3713: p_data => x_message
3714: );

Line 3718: fnd_msg_pub.count_and_get

3714: );
3715:
3716: WHEN OTHERS THEN
3717: x_status := fnd_api.g_ret_sts_unexp_error ;
3718: fnd_msg_pub.count_and_get
3719: (p_encoded => FND_API.g_false,
3720: p_count => l_msg_count,
3721: p_data => x_message
3722: );