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.INV_ROI_INTEGRATION_GRP dependencies on FND_MSG_PUB

Line 229: fnd_msg_pub.initialize;

225: l_progress := '002';
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF fnd_api.to_boolean(p_init_msg_lst) THEN
229: fnd_msg_pub.initialize;
230: END IF;
231:
232: --Initialize the return status
233: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 416: fnd_msg_pub.ADD;

412: print_debug('RMA lot does not match with user lot so error out' || l_progress, 4);
413: END IF;
414: FND_MESSAGE.SET_NAME('PO','PO_RMA_LOT_MISMATCH');
415: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_lot');
416: fnd_msg_pub.ADD;
417: RAISE g_exc_error;
418: END IF;--------IF l_rma_quantity = 0 THEN
419: ELSE ------ IF p_oe_order_line_id IS NOT NULL THEN
420: IF g_debug = 1 THEN

Line 479: fnd_msg_pub.ADD;

475: END IF;
476: FND_MESSAGE.SET_NAME('INV','INV_RMA_QUANTITY_VAL_FAILED');
477: FND_MESSAGE.SET_TOKEN('x_allowed_quantity',l_allowed_quantity );
478: FND_MESSAGE.SET_TOKEN('p_lot_number',p_lot_number );
479: fnd_msg_pub.ADD;
480: RAISE g_exc_error;
481: END IF;
482:
483: l_progress := '007' ;

Line 491: fnd_msg_pub.ADD;

487: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a user defined exception '|| l_progress, 1);
488: END IF;
489: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
490: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity');
491: fnd_msg_pub.ADD;
492: RAISE g_exc_error;
493:
494: l_progress := '008' ;
495:

Line 502: fnd_msg_pub.ADD;

498: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a Unexpected exception ' || l_progress , 1);
499: END IF;
500: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
501: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity');
502: fnd_msg_pub.ADD;
503: RAISE g_exc_unexpected_error;
504: END IF;
505:
506: l_progress :='009';

Line 567: FND_MSG_PUB.ADD;

563: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
564: END IF;
565: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
566: FND_MESSAGE.SET_TOKEN('PGM_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
567: FND_MSG_PUB.ADD;
568: RAISE g_exc_error;
569: END IF;
570:
571: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 577: fnd_msg_pub.ADD;

573: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
574: END IF;
575: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
576: FND_MESSAGE.SET_TOKEN('PGM_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
577: fnd_msg_pub.ADD;
578: RAISE g_exc_unexpected_error;
579: END IF;
580:
581: IF (l_lot_cont = FALSE) THEN

Line 586: fnd_msg_pub.ADD;

582: IF g_debug = 1 THEN
583: print_debug(' Item is not lot controlled ', 9);
584: END IF;
585: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
586: fnd_msg_pub.ADD;
587: x_return_status := fnd_api.g_ret_sts_error;
588: RAISE g_exc_error;
589: END IF ;
590:

Line 596: fnd_msg_pub.ADD;

592: IF g_debug = 1 THEN
593: print_debug(' Item is not Child lot controlled ', 9);
594: END IF;
595: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
596: fnd_msg_pub.ADD;
597: x_return_status := fnd_api.g_ret_sts_error;
598: RAISE g_exc_error;
599: END IF ;
600:

Line 860: fnd_msg_pub.ADD;

856: END IF;
857:
858: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
859: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
860: fnd_msg_pub.ADD;
861:
862: RAISE g_exc_unexpected_error;
863: END IF;
864:

Line 897: fnd_msg_pub.ADD;

893: END IF;
894:
895: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
896: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
897: fnd_msg_pub.ADD;
898: RAISE g_exc_error;
899:
900: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
901: l_progress := '012' ;

Line 908: fnd_msg_pub.ADD;

904: END IF;
905:
906: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
907: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
908: fnd_msg_pub.ADD;
909: RAISE g_exc_unexpected_error;
910: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
911:
912: END IF; ----IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

Line 1023: fnd_msg_pub.ADD;

1019: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 1);
1020: END IF;
1021: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1023: fnd_msg_pub.ADD;
1024: RAISE g_exc_unexpected_error;
1025: END IF;
1026:
1027: ELSE -----if l_lot_secondary_quantity is NULL THEN default it

Line 1066: fnd_msg_pub.ADD;

1062: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
1063: END IF;
1064: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1065: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1066: fnd_msg_pub.ADD;
1067:
1068: RAISE g_exc_unexpected_error;
1069: END IF;
1070:

Line 1225: fnd_msg_pub.ADD;

1221: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 9);
1222: END IF;
1223: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1224: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1225: fnd_msg_pub.ADD;
1226: RAISE g_exc_error;
1227: END IF;
1228:
1229: END IF;

Line 1266: fnd_msg_pub.ADD;

1262: print_debug('INV_CONVERT.inv_um_convert has failed'|| l_progress, 9);
1263: END IF;
1264: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1265: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1266: fnd_msg_pub.ADD;
1267: RAISE g_exc_unexpected_error;
1268: END IF;
1269:
1270: l_progress :='022';

Line 1341: fnd_msg_pub.count_and_get(

1337: EXCEPTION
1338:
1339: WHEN NO_DATA_FOUND THEN
1340: x_return_status := fnd_api.g_ret_sts_error;
1341: fnd_msg_pub.count_and_get(
1342: p_encoded => fnd_api.g_false ,
1343: p_count => x_msg_count ,
1344: p_data => x_msg_data
1345: );

Line 1347: x_msg_data := fnd_msg_pub.get(

1343: p_count => x_msg_count ,
1344: p_data => x_msg_data
1345: );
1346: IF( x_msg_count > 1 ) THEN
1347: x_msg_data := fnd_msg_pub.get(
1348: x_msg_count ,
1349: FND_API.G_FALSE
1350: );
1351: END IF ;

Line 1359: FND_MSG_PUB.ADD;

1355: END IF;
1356:
1357: WHEN INVALID_ITEM THEN
1358: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1359: FND_MSG_PUB.ADD;
1360: x_return_status := fnd_api.g_ret_sts_error;
1361: fnd_msg_pub.count_and_get(
1362: p_encoded => fnd_api.g_false ,
1363: p_count => x_msg_count ,

Line 1361: fnd_msg_pub.count_and_get(

1357: WHEN INVALID_ITEM THEN
1358: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1359: FND_MSG_PUB.ADD;
1360: x_return_status := fnd_api.g_ret_sts_error;
1361: fnd_msg_pub.count_and_get(
1362: p_encoded => fnd_api.g_false ,
1363: p_count => x_msg_count ,
1364: p_data => x_msg_data
1365: );

Line 1367: x_msg_data := fnd_msg_pub.get(

1363: p_count => x_msg_count ,
1364: p_data => x_msg_data
1365: );
1366: IF( x_msg_count > 1 ) THEN
1367: x_msg_data := fnd_msg_pub.get(
1368: x_msg_count ,
1369: FND_API.G_FALSE
1370: );
1371: END IF ;

Line 1381: fnd_msg_pub.count_and_get(

1377:
1378:
1379: WHEN g_exc_error THEN
1380: x_return_status := fnd_api.g_ret_sts_error;
1381: fnd_msg_pub.count_and_get(
1382: p_encoded => fnd_api.g_false ,
1383: p_count => x_msg_count ,
1384: p_data => x_msg_data
1385: );

Line 1387: x_msg_data := fnd_msg_pub.get(

1383: p_count => x_msg_count ,
1384: p_data => x_msg_data
1385: );
1386: IF( x_msg_count > 1 ) THEN
1387: x_msg_data := fnd_msg_pub.get(
1388: x_msg_count ,
1389: FND_API.G_FALSE
1390: );
1391: END IF;

Line 1401: fnd_msg_pub.count_and_get(

1397:
1398:
1399: WHEN g_exc_unexpected_error THEN
1400: x_return_status := fnd_api.g_ret_sts_unexp_error;
1401: fnd_msg_pub.count_and_get(
1402: p_encoded => fnd_api.g_false ,
1403: p_count => x_msg_count ,
1404: p_data => x_msg_data
1405: );

Line 1407: x_msg_data := fnd_msg_pub.get(

1403: p_count => x_msg_count ,
1404: p_data => x_msg_data
1405: );
1406: IF( x_msg_count > 1 ) THEN
1407: x_msg_data := fnd_msg_pub.get(
1408: x_msg_count ,
1409: FND_API.G_FALSE
1410: );
1411: END IF ;

Line 1420: fnd_msg_pub.count_and_get(

1416: END IF;
1417:
1418: WHEN OTHERS THEN
1419: x_return_status := fnd_api.g_ret_sts_unexp_error;
1420: fnd_msg_pub.count_and_get(
1421: p_encoded => fnd_api.g_false ,
1422: p_count => x_msg_count ,
1423: p_data => x_msg_data
1424: );

Line 1426: x_msg_data := fnd_msg_pub.get(

1422: p_count => x_msg_count ,
1423: p_data => x_msg_data
1424: );
1425: IF( x_msg_count > 1 ) THEN
1426: x_msg_data := fnd_msg_pub.get(
1427: x_msg_count ,
1428: FND_API.G_FALSE);
1429: END IF;
1430:

Line 1545: fnd_msg_pub.initialize;

1541: END IF;
1542:
1543: /* Initialize message list if p_init_msg_list is set to TRUE. */
1544: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1545: fnd_msg_pub.initialize;
1546: END IF;
1547:
1548: /*Initialize the return status */
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1877: fnd_msg_pub.ADD;

1873: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a user defined exception : ' || l_progress, 9);
1874: END IF;
1875: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1876: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1877: fnd_msg_pub.ADD;
1878: RAISE g_exc_error;
1879:
1880: l_progress := '028' ;
1881: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1887: fnd_msg_pub.ADD;

1883: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a Unexpected exception :'|| l_progress, 9);
1884: END IF;
1885: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1886: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1887: fnd_msg_pub.ADD;
1888: RAISE g_exc_unexpected_error;
1889: END IF;
1890:
1891: l_progress := '029';

Line 2201: fnd_msg_pub.ADD;

2197: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2198: END IF;
2199: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2200: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2201: fnd_msg_pub.ADD;
2202: RAISE g_exc_error;
2203:
2204: l_progress := '036';
2205:

Line 2212: fnd_msg_pub.ADD;

2208: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2209: END IF;
2210: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2211: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2212: fnd_msg_pub.ADD;
2213: RAISE g_exc_unexpected_error;
2214: END IF;
2215:
2216:

Line 2235: fnd_msg_pub.count_and_get(

2231: ELSIF l_progress = '006' THEN
2232: ROLLBACK TO inv_new_lot_save6;
2233: END IF;
2234: */
2235: fnd_msg_pub.count_and_get(
2236: p_encoded => fnd_api.g_false ,
2237: p_count => x_msg_count ,
2238: p_data => x_msg_data
2239: );

Line 2242: x_msg_data := fnd_msg_pub.get(

2238: p_data => x_msg_data
2239: );
2240:
2241: IF( x_msg_count > 1 ) THEN
2242: x_msg_data := fnd_msg_pub.get(
2243: x_msg_count ,
2244: FND_API.G_FALSE
2245: );
2246: END IF ;

Line 2261: fnd_msg_pub.count_and_get(

2257: ELSIF l_progress = '006' THEN
2258: ROLLBACK TO inv_new_lot_save6;
2259: END IF;
2260: */
2261: fnd_msg_pub.count_and_get(
2262: p_encoded => fnd_api.g_false ,
2263: p_count => x_msg_count ,
2264: p_data => x_msg_data
2265: );

Line 2268: x_msg_data := fnd_msg_pub.get(

2264: p_data => x_msg_data
2265: );
2266:
2267: IF( x_msg_count > 1 ) THEN
2268: x_msg_data := fnd_msg_pub.get(
2269: x_msg_count ,
2270: FND_API.G_FALSE
2271: );
2272: END IF;

Line 2288: fnd_msg_pub.count_and_get(

2284: ELSIF l_progress = '006' THEN
2285: ROLLBACK TO inv_new_lot_save6;
2286: END IF;
2287: */
2288: fnd_msg_pub.count_and_get(
2289: p_encoded => fnd_api.g_false ,
2290: p_count => x_msg_count ,
2291: p_data => x_msg_data
2292: );

Line 2295: x_msg_data := fnd_msg_pub.get(

2291: p_data => x_msg_data
2292: );
2293:
2294: IF( x_msg_count > 1 ) THEN
2295: x_msg_data := fnd_msg_pub.get(
2296: x_msg_count ,
2297: FND_API.G_FALSE);
2298: END IF ;
2299:

Line 2314: fnd_msg_pub.count_and_get(

2310: ELSIF l_progress = '006' THEN
2311: ROLLBACK TO inv_new_lot_save6;
2312: END IF;
2313: */
2314: fnd_msg_pub.count_and_get(
2315: p_encoded => fnd_api.g_false ,
2316: p_count => x_msg_count ,
2317: p_data => x_msg_data
2318: );

Line 2321: x_msg_data := fnd_msg_pub.get(

2317: p_data => x_msg_data
2318: );
2319:
2320: IF( x_msg_count > 1 ) THEN
2321: x_msg_data := fnd_msg_pub.get(
2322: x_msg_count ,
2323: FND_API.G_FALSE);
2324: END IF;
2325:

Line 2413: fnd_msg_pub.initialize;

2409: END IF;
2410:
2411: -- Initialize message list if p_init_msg_list is set to TRUE.
2412: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2413: fnd_msg_pub.initialize;
2414: END IF;
2415:
2416: --Initialize the return status
2417: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2486: fnd_msg_pub.ADD;

2482: print_debug('INV_CONVERT.inv_um_convert has failed in inv_synch_quantities:'|| l_progress, 1);
2483: END IF;
2484: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2485: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
2486: fnd_msg_pub.ADD;
2487: RAISE g_exc_unexpected_error;
2488: END IF;
2489:
2490: l_progress :='041';

Line 2540: fnd_msg_pub.count_and_get(

2536: EXCEPTION
2537:
2538: WHEN g_exc_unexpected_error THEN
2539: x_return_status := fnd_api.g_ret_sts_unexp_error;
2540: fnd_msg_pub.count_and_get(
2541: p_encoded => fnd_api.g_false ,
2542: p_count => x_msg_count ,
2543: p_data => x_msg_data
2544: );

Line 2546: x_msg_data := fnd_msg_pub.get(

2542: p_count => x_msg_count ,
2543: p_data => x_msg_data
2544: );
2545: IF( x_msg_count > 1 ) THEN
2546: x_msg_data := fnd_msg_pub.get(
2547: x_msg_count ,
2548: FND_API.G_FALSE
2549: );
2550: END IF ;

Line 2559: fnd_msg_pub.count_and_get(

2555: END IF;
2556:
2557: WHEN OTHERS THEN
2558: x_return_status := fnd_api.g_ret_sts_unexp_error;
2559: fnd_msg_pub.count_and_get(
2560: p_encoded => fnd_api.g_false ,
2561: p_count => x_msg_count ,
2562: p_data => x_msg_data
2563: );

Line 2565: x_msg_data := fnd_msg_pub.get(

2561: p_count => x_msg_count ,
2562: p_data => x_msg_data
2563: );
2564: IF( x_msg_count > 1 ) THEN
2565: x_msg_data := fnd_msg_pub.get(
2566: x_msg_count ,
2567: FND_API.G_FALSE);
2568: END IF;
2569:

Line 2656: fnd_msg_pub.count_and_get(

2652:
2653: EXCEPTION
2654:
2655: WHEN g_exc_error THEN
2656: fnd_msg_pub.count_and_get(
2657: p_encoded => fnd_api.g_false,
2658: p_count => x_msg_count,
2659: p_data => x_msg_data);
2660: IF( x_msg_count > 1 ) THEN

Line 2661: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2657: p_encoded => fnd_api.g_false,
2658: p_count => x_msg_count,
2659: p_data => x_msg_data);
2660: IF( x_msg_count > 1 ) THEN
2661: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2662: END IF ;
2663:
2664: IF g_debug = 1 THEN
2665: print_debug('Exitting inv_rma_lot_info_exists - g_exc_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2672: fnd_msg_pub.count_and_get(

2668:
2669: RETURN FALSE;
2670:
2671: WHEN OTHERS THEN
2672: fnd_msg_pub.count_and_get(
2673: p_encoded => fnd_api.g_false,
2674: p_count => x_msg_count,
2675: p_data => x_msg_data);
2676: IF( x_msg_count > 1 ) THEN

Line 2677: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

2673: p_encoded => fnd_api.g_false,
2674: p_count => x_msg_count,
2675: p_data => x_msg_data);
2676: IF( x_msg_count > 1 ) THEN
2677: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2678: END IF ;
2679:
2680: IF g_debug = 1 THEN
2681: print_debug('Exitting inv_rma_lot_info_exists - OTHERS error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2824: fnd_msg_pub.initialize;

2820: END IF;
2821:
2822: -- Initialize message list if p_init_msg_list is set to TRUE.
2823: IF fnd_api.to_boolean(p_init_msg_list) THEN
2824: fnd_msg_pub.initialize;
2825: END IF;
2826:
2827: --Initialize the return status
2828: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3023: fnd_msg_pub.ADD;

3019: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 1);
3020: END IF;
3021: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3022: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
3023: fnd_msg_pub.ADD;
3024: RAISE g_exc_unexpected_error;
3025: END IF;
3026:
3027: END IF;

Line 3069: fnd_msg_pub.ADD;

3065: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 9);
3066: END IF;
3067: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3068: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
3069: fnd_msg_pub.ADD;
3070: RAISE g_exc_unexpected_error;
3071: END IF;
3072:
3073: END IF;

Line 3120: fnd_msg_pub.ADD;

3116: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'|| l_progress, 1);
3117: END IF;
3118: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3119: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');
3120: fnd_msg_pub.ADD;
3121: RAISE g_exc_unexpected_error;
3122: END IF;
3123:
3124: ELSE

Line 3145: fnd_msg_pub.ADD;

3141: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');
3142: FND_MESSAGE.SET_TOKEN('TRX_QUANTITY',l_trx_quantity);
3143: FND_MESSAGE.SET_TOKEN('allowed_quantity',x_allowed_quantity );
3144: FND_MESSAGE.SET_TOKEN('lot_number',p_lot_number );
3145: fnd_msg_pub.ADD;
3146: RAISE g_exc_error;
3147:
3148: ELSE ---------IF l_trx_quantity > (l_rma_quantity - nvl(l_lot_recv_qty,0)) THEN
3149: l_progress :='078';

Line 3164: fnd_msg_pub.count_and_get(

3160: EXCEPTION
3161:
3162: WHEN NO_DATA_FOUND THEN
3163: x_return_status := fnd_api.g_ret_sts_error;
3164: fnd_msg_pub.count_and_get(
3165: p_encoded => fnd_api.g_false ,
3166: p_count => x_msg_count ,
3167: p_data => x_msg_data
3168: );

Line 3171: x_msg_data := fnd_msg_pub.get(

3167: p_data => x_msg_data
3168: );
3169:
3170: IF( x_msg_count > 1 ) THEN
3171: x_msg_data := fnd_msg_pub.get(
3172: x_msg_count ,
3173: FND_API.G_FALSE
3174: );
3175: END IF ;

Line 3185: fnd_msg_pub.count_and_get(

3181:
3182: WHEN g_exc_error THEN
3183: x_return_status := fnd_api.g_ret_sts_error;
3184:
3185: fnd_msg_pub.count_and_get(
3186: p_encoded => fnd_api.g_false ,
3187: p_count => x_msg_count ,
3188: p_data => x_msg_data
3189: );

Line 3192: x_msg_data := fnd_msg_pub.get(

3188: p_data => x_msg_data
3189: );
3190:
3191: IF( x_msg_count > 1 ) THEN
3192: x_msg_data := fnd_msg_pub.get(
3193: x_msg_count ,
3194: FND_API.G_FALSE
3195: );
3196: END IF;

Line 3205: fnd_msg_pub.count_and_get(

3201:
3202: WHEN g_exc_unexpected_error THEN
3203: x_return_status := fnd_api.g_ret_sts_unexp_error;
3204:
3205: fnd_msg_pub.count_and_get(
3206: p_encoded => fnd_api.g_false ,
3207: p_count => x_msg_count ,
3208: p_data => x_msg_data
3209: );

Line 3212: x_msg_data := fnd_msg_pub.get(

3208: p_data => x_msg_data
3209: );
3210:
3211: IF( x_msg_count > 1 ) THEN
3212: x_msg_data := fnd_msg_pub.get(
3213: x_msg_count ,
3214: FND_API.G_FALSE);
3215: END IF ;
3216: IF g_debug = 1 THEN

Line 3224: fnd_msg_pub.count_and_get(

3220:
3221: WHEN OTHERS THEN
3222: x_return_status := fnd_api.g_ret_sts_unexp_error;
3223:
3224: fnd_msg_pub.count_and_get(
3225: p_encoded => fnd_api.g_false ,
3226: p_count => x_msg_count ,
3227: p_data => x_msg_data
3228: );

Line 3231: x_msg_data := fnd_msg_pub.get(

3227: p_data => x_msg_data
3228: );
3229:
3230: IF( x_msg_count > 1 ) THEN
3231: x_msg_data := fnd_msg_pub.get(
3232: x_msg_count ,
3233: FND_API.G_FALSE);
3234: END IF;
3235: IF g_debug = 1 THEN

Line 3306: fnd_msg_pub.ADD;

3302: x_lot_cont := FALSE ;
3303: x_child_lot_cont := FALSE ;
3304: x_return_status := fnd_api.g_ret_sts_error;
3305: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
3306: fnd_msg_pub.ADD;
3307: RAISE fnd_api.g_exc_error;
3308:
3309: ELSE
3310:

Line 3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3342: EXCEPTION
3343:
3344: WHEN NO_DATA_FOUND THEN
3345: x_return_status := fnd_api.g_ret_sts_error;
3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3347: IF( x_msg_count > 1 ) THEN
3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3349: END IF;
3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);

Line 3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3344: WHEN NO_DATA_FOUND THEN
3345: x_return_status := fnd_api.g_ret_sts_error;
3346: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3347: IF( x_msg_count > 1 ) THEN
3348: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3349: END IF;
3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3351:
3352: WHEN fnd_api.g_exc_error THEN

Line 3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3350: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3351:
3352: WHEN fnd_api.g_exc_error THEN
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3355: IF( x_msg_count > 1 ) THEN
3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3357: END IF;
3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);

Line 3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3352: WHEN fnd_api.g_exc_error THEN
3353: x_return_status := fnd_api.g_ret_sts_error;
3354: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3355: IF( x_msg_count > 1 ) THEN
3356: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3357: END IF;
3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3359:
3360: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3358: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3359:
3360: WHEN fnd_api.g_exc_unexpected_error THEN
3361: x_return_status := fnd_api.g_ret_sts_unexp_error;
3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3363: IF( x_msg_count > 1 ) THEN
3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3365: END IF ;
3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);

Line 3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3360: WHEN fnd_api.g_exc_unexpected_error THEN
3361: x_return_status := fnd_api.g_ret_sts_unexp_error;
3362: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3363: IF( x_msg_count > 1 ) THEN
3364: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3365: END IF ;
3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3367:
3368: WHEN OTHERS THEN

Line 3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

3366: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3367:
3368: WHEN OTHERS THEN
3369: x_return_status := fnd_api.g_ret_sts_unexp_error;
3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3371: IF( x_msg_count > 1 ) THEN
3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3373: END IF;
3374: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);

Line 3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

3368: WHEN OTHERS THEN
3369: x_return_status := fnd_api.g_ret_sts_unexp_error;
3370: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3371: IF( x_msg_count > 1 ) THEN
3372: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3373: END IF;
3374: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);
3375:
3376: END Check_Item_Attributes;