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 225: fnd_msg_pub.initialize;

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

Line 380: fnd_msg_pub.ADD;

376: print_debug('RMA lot does not match with user lot so error out' || l_progress, 4);
377: END IF;
378: FND_MESSAGE.SET_NAME('PO','PO_RMA_LOT_MISMATCH');
379: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_lot');
380: fnd_msg_pub.ADD;
381: RAISE g_exc_error;
382: END IF;--------IF l_rma_quantity = 0 THEN
383: ELSE ------ IF p_oe_order_line_id IS NOT NULL THEN
384: IF g_debug = 1 THEN

Line 443: fnd_msg_pub.ADD;

439: END IF;
440: FND_MESSAGE.SET_NAME('INV','INV_RMA_QUANTITY_VAL_FAILED');
441: FND_MESSAGE.SET_TOKEN('x_allowed_quantity',l_allowed_quantity );
442: FND_MESSAGE.SET_TOKEN('p_lot_number',p_lot_number );
443: fnd_msg_pub.ADD;
444: RAISE g_exc_error;
445: END IF;
446:
447: l_progress := '007' ;

Line 455: fnd_msg_pub.ADD;

451: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a user defined exception '|| l_progress, 1);
452: END IF;
453: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
454: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity');
455: fnd_msg_pub.ADD;
456: RAISE g_exc_error;
457:
458: l_progress := '008' ;
459:

Line 466: fnd_msg_pub.ADD;

462: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a Unexpected exception ' || l_progress , 1);
463: END IF;
464: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
465: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity');
466: fnd_msg_pub.ADD;
467: RAISE g_exc_unexpected_error;
468: END IF;
469:
470: l_progress :='009';

Line 531: FND_MSG_PUB.ADD;

527: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with error', 9);
528: END IF;
529: FND_MESSAGE.SET_NAME('INV', 'INV_PROGRAM_ERROR') ;
530: FND_MESSAGE.SET_TOKEN('PGM_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
531: FND_MSG_PUB.ADD;
532: RAISE g_exc_error;
533: END IF;
534:
535: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 541: fnd_msg_pub.ADD;

537: print_debug('Program Inv_lot_api_pkg.Check_Item_Attributes has failed with a Unexpected exception', 9);
538: END IF;
539: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
540: FND_MESSAGE.SET_TOKEN('PGM_NAME','Inv_lot_api_pkg.Check_Item_Attributes');
541: fnd_msg_pub.ADD;
542: RAISE g_exc_unexpected_error;
543: END IF;
544:
545: IF (l_lot_cont = FALSE) THEN

Line 550: fnd_msg_pub.ADD;

546: IF g_debug = 1 THEN
547: print_debug(' Item is not lot controlled ', 9);
548: END IF;
549: fnd_message.set_name('INV', 'INV_NO_LOT_CONTROL');
550: fnd_msg_pub.ADD;
551: x_return_status := fnd_api.g_ret_sts_error;
552: RAISE g_exc_error;
553: END IF ;
554:

Line 560: fnd_msg_pub.ADD;

556: IF g_debug = 1 THEN
557: print_debug(' Item is not Child lot controlled ', 9);
558: END IF;
559: fnd_message.set_name('INV', 'INV_ITEM_CLOT_DISABLE_EXP');
560: fnd_msg_pub.ADD;
561: x_return_status := fnd_api.g_ret_sts_error;
562: RAISE g_exc_error;
563: END IF ;
564:

Line 824: fnd_msg_pub.ADD;

820: END IF;
821:
822: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
823: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
824: fnd_msg_pub.ADD;
825:
826: RAISE g_exc_unexpected_error;
827: END IF;
828:

Line 861: fnd_msg_pub.ADD;

857: END IF;
858:
859: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
860: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
861: fnd_msg_pub.ADD;
862: RAISE g_exc_error;
863:
864: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
865: l_progress := '012' ;

Line 872: fnd_msg_pub.ADD;

868: END IF;
869:
870: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
871: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.validate_lot_indivisible');
872: fnd_msg_pub.ADD;
873: RAISE g_exc_unexpected_error;
874: END IF;------------IF l_return_status = fnd_api.g_ret_sts_error THEN
875:
876: END IF; ----IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(

Line 985: fnd_msg_pub.ADD;

981: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 1);
982: END IF;
983: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
984: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
985: fnd_msg_pub.ADD;
986: RAISE g_exc_unexpected_error;
987: END IF;
988:
989: ELSE -----if l_lot_secondary_quantity is NULL THEN default it

Line 1028: fnd_msg_pub.ADD;

1024: print_debug('INV_CONVERT.inv_um_convert has failed '|| l_progress, 1);
1025: END IF;
1026: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1027: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1028: fnd_msg_pub.ADD;
1029:
1030: RAISE g_exc_unexpected_error;
1031: END IF;
1032:

Line 1188: fnd_msg_pub.ADD;

1184: print_debug('Program INV_CONVERT.Within_deviation has failed ' || l_progress, 9);
1185: END IF;
1186: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1187: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.Within_deviation return');
1188: fnd_msg_pub.ADD;
1189: RAISE g_exc_error;
1190: END IF;
1191:
1192: END IF;

Line 1229: fnd_msg_pub.ADD;

1225: print_debug('INV_CONVERT.inv_um_convert has failed'|| l_progress, 9);
1226: END IF;
1227: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1228: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
1229: fnd_msg_pub.ADD;
1230: RAISE g_exc_unexpected_error;
1231: END IF;
1232:
1233: l_progress :='022';

Line 1304: fnd_msg_pub.count_and_get(

1300: EXCEPTION
1301:
1302: WHEN NO_DATA_FOUND THEN
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: fnd_msg_pub.count_and_get(
1305: p_encoded => fnd_api.g_false ,
1306: p_count => x_msg_count ,
1307: p_data => x_msg_data
1308: );

Line 1310: x_msg_data := fnd_msg_pub.get(

1306: p_count => x_msg_count ,
1307: p_data => x_msg_data
1308: );
1309: IF( x_msg_count > 1 ) THEN
1310: x_msg_data := fnd_msg_pub.get(
1311: x_msg_count ,
1312: FND_API.G_FALSE
1313: );
1314: END IF ;

Line 1322: FND_MSG_PUB.ADD;

1318: END IF;
1319:
1320: WHEN INVALID_ITEM THEN
1321: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1322: FND_MSG_PUB.ADD;
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: fnd_msg_pub.count_and_get(
1325: p_encoded => fnd_api.g_false ,
1326: p_count => x_msg_count ,

Line 1324: fnd_msg_pub.count_and_get(

1320: WHEN INVALID_ITEM THEN
1321: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ITEM');
1322: FND_MSG_PUB.ADD;
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: fnd_msg_pub.count_and_get(
1325: p_encoded => fnd_api.g_false ,
1326: p_count => x_msg_count ,
1327: p_data => x_msg_data
1328: );

Line 1330: x_msg_data := fnd_msg_pub.get(

1326: p_count => x_msg_count ,
1327: p_data => x_msg_data
1328: );
1329: IF( x_msg_count > 1 ) THEN
1330: x_msg_data := fnd_msg_pub.get(
1331: x_msg_count ,
1332: FND_API.G_FALSE
1333: );
1334: END IF ;

Line 1344: fnd_msg_pub.count_and_get(

1340:
1341:
1342: WHEN g_exc_error THEN
1343: x_return_status := fnd_api.g_ret_sts_error;
1344: fnd_msg_pub.count_and_get(
1345: p_encoded => fnd_api.g_false ,
1346: p_count => x_msg_count ,
1347: p_data => x_msg_data
1348: );

Line 1350: x_msg_data := fnd_msg_pub.get(

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

Line 1364: fnd_msg_pub.count_and_get(

1360:
1361:
1362: WHEN g_exc_unexpected_error THEN
1363: x_return_status := fnd_api.g_ret_sts_unexp_error;
1364: fnd_msg_pub.count_and_get(
1365: p_encoded => fnd_api.g_false ,
1366: p_count => x_msg_count ,
1367: p_data => x_msg_data
1368: );

Line 1370: x_msg_data := fnd_msg_pub.get(

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

Line 1383: fnd_msg_pub.count_and_get(

1379: END IF;
1380:
1381: WHEN OTHERS THEN
1382: x_return_status := fnd_api.g_ret_sts_unexp_error;
1383: fnd_msg_pub.count_and_get(
1384: p_encoded => fnd_api.g_false ,
1385: p_count => x_msg_count ,
1386: p_data => x_msg_data
1387: );

Line 1389: x_msg_data := fnd_msg_pub.get(

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

Line 1507: fnd_msg_pub.initialize;

1503: END IF;
1504:
1505: /* Initialize message list if p_init_msg_list is set to TRUE. */
1506: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1507: fnd_msg_pub.initialize;
1508: END IF;
1509:
1510: /*Initialize the return status */
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1775: fnd_msg_pub.ADD;

1771: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a user defined exception : ' || l_progress, 9);
1772: END IF;
1773: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1774: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1775: fnd_msg_pub.ADD;
1776: RAISE g_exc_error;
1777:
1778: l_progress := '028' ;
1779: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1785: fnd_msg_pub.ADD;

1781: print_debug('Program inv_lot_api_pub.Create_Inv_lot has failed with a Unexpected exception :'|| l_progress, 9);
1782: END IF;
1783: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1784: FND_MESSAGE.SET_TOKEN('PGM_NAME','inv_lot_api_pub.Create_Inv_lot');
1785: fnd_msg_pub.ADD;
1786: RAISE g_exc_unexpected_error;
1787: END IF;
1788:
1789: l_progress := '029';

Line 2096: fnd_msg_pub.ADD;

2092: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a user defined exception:'||l_progress, 1);
2093: END IF;
2094: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2095: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2096: fnd_msg_pub.ADD;
2097: RAISE g_exc_error;
2098:
2099: l_progress := '036';
2100:

Line 2107: fnd_msg_pub.ADD;

2103: print_debug('Program MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion has failed with a Unexpected exception :'|| l_progress, 9);
2104: END IF;
2105: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
2106: FND_MESSAGE.SET_TOKEN('PGM_NAME','MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion');
2107: fnd_msg_pub.ADD;
2108: RAISE g_exc_unexpected_error;
2109: END IF;
2110:
2111:

Line 2130: fnd_msg_pub.count_and_get(

2126: ELSIF l_progress = '006' THEN
2127: ROLLBACK TO inv_new_lot_save6;
2128: END IF;
2129: */
2130: fnd_msg_pub.count_and_get(
2131: p_encoded => fnd_api.g_false ,
2132: p_count => x_msg_count ,
2133: p_data => x_msg_data
2134: );

Line 2137: x_msg_data := fnd_msg_pub.get(

2133: p_data => x_msg_data
2134: );
2135:
2136: IF( x_msg_count > 1 ) THEN
2137: x_msg_data := fnd_msg_pub.get(
2138: x_msg_count ,
2139: FND_API.G_FALSE
2140: );
2141: END IF ;

Line 2156: fnd_msg_pub.count_and_get(

2152: ELSIF l_progress = '006' THEN
2153: ROLLBACK TO inv_new_lot_save6;
2154: END IF;
2155: */
2156: fnd_msg_pub.count_and_get(
2157: p_encoded => fnd_api.g_false ,
2158: p_count => x_msg_count ,
2159: p_data => x_msg_data
2160: );

Line 2163: x_msg_data := fnd_msg_pub.get(

2159: p_data => x_msg_data
2160: );
2161:
2162: IF( x_msg_count > 1 ) THEN
2163: x_msg_data := fnd_msg_pub.get(
2164: x_msg_count ,
2165: FND_API.G_FALSE
2166: );
2167: END IF;

Line 2183: fnd_msg_pub.count_and_get(

2179: ELSIF l_progress = '006' THEN
2180: ROLLBACK TO inv_new_lot_save6;
2181: END IF;
2182: */
2183: fnd_msg_pub.count_and_get(
2184: p_encoded => fnd_api.g_false ,
2185: p_count => x_msg_count ,
2186: p_data => x_msg_data
2187: );

Line 2190: x_msg_data := fnd_msg_pub.get(

2186: p_data => x_msg_data
2187: );
2188:
2189: IF( x_msg_count > 1 ) THEN
2190: x_msg_data := fnd_msg_pub.get(
2191: x_msg_count ,
2192: FND_API.G_FALSE);
2193: END IF ;
2194:

Line 2209: fnd_msg_pub.count_and_get(

2205: ELSIF l_progress = '006' THEN
2206: ROLLBACK TO inv_new_lot_save6;
2207: END IF;
2208: */
2209: fnd_msg_pub.count_and_get(
2210: p_encoded => fnd_api.g_false ,
2211: p_count => x_msg_count ,
2212: p_data => x_msg_data
2213: );

Line 2216: x_msg_data := fnd_msg_pub.get(

2212: p_data => x_msg_data
2213: );
2214:
2215: IF( x_msg_count > 1 ) THEN
2216: x_msg_data := fnd_msg_pub.get(
2217: x_msg_count ,
2218: FND_API.G_FALSE);
2219: END IF;
2220:

Line 2308: fnd_msg_pub.initialize;

2304: END IF;
2305:
2306: -- Initialize message list if p_init_msg_list is set to TRUE.
2307: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2308: fnd_msg_pub.initialize;
2309: END IF;
2310:
2311: --Initialize the return status
2312: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2381: fnd_msg_pub.ADD;

2377: print_debug('INV_CONVERT.inv_um_convert has failed in inv_synch_quantities:'|| l_progress, 1);
2378: END IF;
2379: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2380: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
2381: fnd_msg_pub.ADD;
2382: RAISE g_exc_unexpected_error;
2383: END IF;
2384:
2385: l_progress :='041';

Line 2433: fnd_msg_pub.count_and_get(

2429: EXCEPTION
2430:
2431: WHEN g_exc_unexpected_error THEN
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433: fnd_msg_pub.count_and_get(
2434: p_encoded => fnd_api.g_false ,
2435: p_count => x_msg_count ,
2436: p_data => x_msg_data
2437: );

Line 2439: x_msg_data := fnd_msg_pub.get(

2435: p_count => x_msg_count ,
2436: p_data => x_msg_data
2437: );
2438: IF( x_msg_count > 1 ) THEN
2439: x_msg_data := fnd_msg_pub.get(
2440: x_msg_count ,
2441: FND_API.G_FALSE
2442: );
2443: END IF ;

Line 2452: fnd_msg_pub.count_and_get(

2448: END IF;
2449:
2450: WHEN OTHERS THEN
2451: x_return_status := fnd_api.g_ret_sts_unexp_error;
2452: fnd_msg_pub.count_and_get(
2453: p_encoded => fnd_api.g_false ,
2454: p_count => x_msg_count ,
2455: p_data => x_msg_data
2456: );

Line 2458: x_msg_data := fnd_msg_pub.get(

2454: p_count => x_msg_count ,
2455: p_data => x_msg_data
2456: );
2457: IF( x_msg_count > 1 ) THEN
2458: x_msg_data := fnd_msg_pub.get(
2459: x_msg_count ,
2460: FND_API.G_FALSE);
2461: END IF;
2462:

Line 2549: fnd_msg_pub.count_and_get(

2545:
2546: EXCEPTION
2547:
2548: WHEN g_exc_error THEN
2549: fnd_msg_pub.count_and_get(
2550: p_encoded => fnd_api.g_false,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data);
2553: IF( x_msg_count > 1 ) THEN

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

2550: p_encoded => fnd_api.g_false,
2551: p_count => x_msg_count,
2552: p_data => x_msg_data);
2553: IF( x_msg_count > 1 ) THEN
2554: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2555: END IF ;
2556:
2557: IF g_debug = 1 THEN
2558: print_debug('Exitting inv_rma_lot_info_exists - g_exc_error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2565: fnd_msg_pub.count_and_get(

2561:
2562: RETURN FALSE;
2563:
2564: WHEN OTHERS THEN
2565: fnd_msg_pub.count_and_get(
2566: p_encoded => fnd_api.g_false,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: IF( x_msg_count > 1 ) THEN

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

2566: p_encoded => fnd_api.g_false,
2567: p_count => x_msg_count,
2568: p_data => x_msg_data);
2569: IF( x_msg_count > 1 ) THEN
2570: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
2571: END IF ;
2572:
2573: IF g_debug = 1 THEN
2574: print_debug('Exitting inv_rma_lot_info_exists - OTHERS error:'||TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')||':'||l_progress, 1);

Line 2715: fnd_msg_pub.initialize;

2711: END IF;
2712:
2713: -- Initialize message list if p_init_msg_list is set to TRUE.
2714: IF fnd_api.to_boolean(p_init_msg_list) THEN
2715: fnd_msg_pub.initialize;
2716: END IF;
2717:
2718: --Initialize the return status
2719: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2914: fnd_msg_pub.ADD;

2910: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 1);
2911: END IF;
2912: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2913: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
2914: fnd_msg_pub.ADD;
2915: RAISE g_exc_unexpected_error;
2916: END IF;
2917:
2918: END IF;

Line 2960: fnd_msg_pub.ADD;

2956: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'||l_progress, 9);
2957: END IF;
2958: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
2959: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_CONVERT.inv_um_convert');
2960: fnd_msg_pub.ADD;
2961: RAISE g_exc_unexpected_error;
2962: END IF;
2963:
2964: END IF;

Line 3011: fnd_msg_pub.ADD;

3007: print_debug('Inv_Validate_rma_quantity::INV_CONVERT.inv_um_convert has failed:'|| l_progress, 1);
3008: END IF;
3009: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
3010: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');
3011: fnd_msg_pub.ADD;
3012: RAISE g_exc_unexpected_error;
3013: END IF;
3014:
3015: ELSE

Line 3036: fnd_msg_pub.ADD;

3032: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');
3033: FND_MESSAGE.SET_TOKEN('TRX_QUANTITY',l_trx_quantity);
3034: FND_MESSAGE.SET_TOKEN('allowed_quantity',x_allowed_quantity );
3035: FND_MESSAGE.SET_TOKEN('lot_number',p_lot_number );
3036: fnd_msg_pub.ADD;
3037: RAISE g_exc_error;
3038:
3039: ELSE ---------IF l_trx_quantity > (l_rma_quantity - nvl(l_lot_recv_qty,0)) THEN
3040: l_progress :='078';

Line 3055: fnd_msg_pub.count_and_get(

3051: EXCEPTION
3052:
3053: WHEN NO_DATA_FOUND THEN
3054: x_return_status := fnd_api.g_ret_sts_error;
3055: fnd_msg_pub.count_and_get(
3056: p_encoded => fnd_api.g_false ,
3057: p_count => x_msg_count ,
3058: p_data => x_msg_data
3059: );

Line 3062: x_msg_data := fnd_msg_pub.get(

3058: p_data => x_msg_data
3059: );
3060:
3061: IF( x_msg_count > 1 ) THEN
3062: x_msg_data := fnd_msg_pub.get(
3063: x_msg_count ,
3064: FND_API.G_FALSE
3065: );
3066: END IF ;

Line 3076: fnd_msg_pub.count_and_get(

3072:
3073: WHEN g_exc_error THEN
3074: x_return_status := fnd_api.g_ret_sts_error;
3075:
3076: fnd_msg_pub.count_and_get(
3077: p_encoded => fnd_api.g_false ,
3078: p_count => x_msg_count ,
3079: p_data => x_msg_data
3080: );

Line 3083: x_msg_data := fnd_msg_pub.get(

3079: p_data => x_msg_data
3080: );
3081:
3082: IF( x_msg_count > 1 ) THEN
3083: x_msg_data := fnd_msg_pub.get(
3084: x_msg_count ,
3085: FND_API.G_FALSE
3086: );
3087: END IF;

Line 3096: fnd_msg_pub.count_and_get(

3092:
3093: WHEN g_exc_unexpected_error THEN
3094: x_return_status := fnd_api.g_ret_sts_unexp_error;
3095:
3096: fnd_msg_pub.count_and_get(
3097: p_encoded => fnd_api.g_false ,
3098: p_count => x_msg_count ,
3099: p_data => x_msg_data
3100: );

Line 3103: x_msg_data := fnd_msg_pub.get(

3099: p_data => x_msg_data
3100: );
3101:
3102: IF( x_msg_count > 1 ) THEN
3103: x_msg_data := fnd_msg_pub.get(
3104: x_msg_count ,
3105: FND_API.G_FALSE);
3106: END IF ;
3107: IF g_debug = 1 THEN

Line 3115: fnd_msg_pub.count_and_get(

3111:
3112: WHEN OTHERS THEN
3113: x_return_status := fnd_api.g_ret_sts_unexp_error;
3114:
3115: fnd_msg_pub.count_and_get(
3116: p_encoded => fnd_api.g_false ,
3117: p_count => x_msg_count ,
3118: p_data => x_msg_data
3119: );

Line 3122: x_msg_data := fnd_msg_pub.get(

3118: p_data => x_msg_data
3119: );
3120:
3121: IF( x_msg_count > 1 ) THEN
3122: x_msg_data := fnd_msg_pub.get(
3123: x_msg_count ,
3124: FND_API.G_FALSE);
3125: END IF;
3126: IF g_debug = 1 THEN

Line 3197: fnd_msg_pub.ADD;

3193: x_lot_cont := FALSE ;
3194: x_child_lot_cont := FALSE ;
3195: x_return_status := fnd_api.g_ret_sts_error;
3196: fnd_message.set_name('INV', 'INV_INVALID_ITEM');
3197: fnd_msg_pub.ADD;
3198: RAISE fnd_api.g_exc_error;
3199:
3200: ELSE
3201:

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

3233: EXCEPTION
3234:
3235: WHEN NO_DATA_FOUND THEN
3236: x_return_status := fnd_api.g_ret_sts_error;
3237: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3238: IF( x_msg_count > 1 ) THEN
3239: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3240: END IF;
3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);

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

3235: WHEN NO_DATA_FOUND THEN
3236: x_return_status := fnd_api.g_ret_sts_error;
3237: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3238: IF( x_msg_count > 1 ) THEN
3239: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3240: END IF;
3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3242:
3243: WHEN fnd_api.g_exc_error THEN

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

3241: print_debug('In Check_Item_Attributes, No data found ' || SQLERRM, 9);
3242:
3243: WHEN fnd_api.g_exc_error THEN
3244: x_return_status := fnd_api.g_ret_sts_error;
3245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3246: IF( x_msg_count > 1 ) THEN
3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3248: END IF;
3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);

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

3243: WHEN fnd_api.g_exc_error THEN
3244: x_return_status := fnd_api.g_ret_sts_error;
3245: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3246: IF( x_msg_count > 1 ) THEN
3247: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3248: END IF;
3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3250:
3251: WHEN fnd_api.g_exc_unexpected_error THEN

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

3249: print_debug('In Check_Item_Attributes, g_exc_error ' || SQLERRM, 9);
3250:
3251: WHEN fnd_api.g_exc_unexpected_error THEN
3252: x_return_status := fnd_api.g_ret_sts_unexp_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3254: IF( x_msg_count > 1 ) THEN
3255: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3256: END IF ;
3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);

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

3251: WHEN fnd_api.g_exc_unexpected_error THEN
3252: x_return_status := fnd_api.g_ret_sts_unexp_error;
3253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3254: IF( x_msg_count > 1 ) THEN
3255: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3256: END IF ;
3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3258:
3259: WHEN OTHERS THEN

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

3257: print_debug('In Check_Item_Attributes, g_exc_unexpected_error ' || SQLERRM, 9);
3258:
3259: WHEN OTHERS THEN
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3262: IF( x_msg_count > 1 ) THEN
3263: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3264: END IF;
3265: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);

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

3259: WHEN OTHERS THEN
3260: x_return_status := fnd_api.g_ret_sts_unexp_error;
3261: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3262: IF( x_msg_count > 1 ) THEN
3263: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
3264: END IF;
3265: print_debug('In Check_Item_Attributes, Others ' || SQLERRM, 9);
3266:
3267: END Check_Item_Attributes;