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 INV_ROI_INTEGRATION_GRP

Line 1: PACKAGE BODY INV_ROI_INTEGRATION_GRP AS

1: PACKAGE BODY INV_ROI_INTEGRATION_GRP AS
2: /* $Header: INVPROIB.pls 120.4 2006/08/07 23:18:15 pbamb noship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') ;

Line 7: g_pkg_name CONSTANT VARCHAR2(30) :='INV_ROI_INTEGRATION_GRP' ;

3:
4: -- Read the profile option that enables/disables the debug log
5: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') ;
6:
7: g_pkg_name CONSTANT VARCHAR2(30) :='INV_ROI_INTEGRATION_GRP' ;
8: g_module_prefix CONSTANT VARCHAR2(40) := 'inv.plsql.' || g_pkg_name || '.' ;
9: l_progress VARCHAR2(3) := '000' ;
10:
11:

Line 37: p_module => 'INV_ROI_INTEGRATION_GRP' ,

33: BEGIN
34: IF (g_debug = 1) THEN
35: inv_mobile_helper_functions.tracelog(
36: p_err_msg => p_err_msg ,
37: p_module => 'INV_ROI_INTEGRATION_GRP' ,
38: p_level => p_level
39: );
40: DBMS_OUTPUT.PUT_LINE(p_err_msg);
41: END IF;

Line 213: 'INV_ROI_INTEGRATION_GRP'

209: IF NOT fnd_api.compatible_api_call(
210: l_api_version,
211: p_api_version,
212: l_api_name,
213: 'INV_ROI_INTEGRATION_GRP'
214: ) THEN
215: IF (g_debug = 1) THEN
216: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);
217: END IF;

Line 216: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);

212: l_api_name,
213: 'INV_ROI_INTEGRATION_GRP'
214: ) THEN
215: IF (g_debug = 1) THEN
216: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_VALIDATE_LOT: '||l_progress, 1);
217: END IF;
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:

Line 332: print_debug('Before calling INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists:' || l_progress, 1);

328:
329: /*check whether lot is specified in the RMA for that Receipt Line.. */
330:
331: IF g_debug = 1 THEN
332: print_debug('Before calling INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists:' || l_progress, 1);
333: print_debug('p_oe_order_header_id:' || p_oe_order_header_id, 1);
334: print_debug('p_oe_order_line_id:' || p_oe_order_line_id, 1);
335: END IF;
336:

Line 338: IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(

334: print_debug('p_oe_order_line_id:' || p_oe_order_line_id, 1);
335: END IF;
336:
337:
338: IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(
339: x_msg_data =>l_msg_data
340: ,x_msg_count =>l_msg_count
341: ,x_count_rma_lots =>l_count_rma_lots
342: ,p_oe_order_header_id =>p_oe_order_header_id

Line 350: print_debug(' INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists returns TRUE : ' || l_progress, 1);

346: /* Function returns TRUE => lot is entered on RMA so it has to be validated against user entered lot */
347: v_lot_no :=p_lot_number;
348:
349: IF g_debug = 1 THEN
350: print_debug(' INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists returns TRUE : ' || l_progress, 1);
351: print_debug('l_msg_data:' || l_msg_data, 1);
352: print_debug('l_msg_count:' || l_msg_count, 1);
353: print_debug('l_count_rma_lots:' || l_count_rma_lots, 1);
354: print_debug('p_lot_number:' || p_lot_number, 1);

Line 379: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_lot');

375: IF g_debug = 1 THEN
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

Line 395: print_debug('Before calling INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity : ' || l_progress, 1);

391:
392: l_progress := '006' ;
393:
394: IF g_debug = 1 THEN
395: print_debug('Before calling INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity : ' || l_progress, 1);
396: print_debug('p_item_id: ' || p_item_id, 1);
397: print_debug('p_lot_number: ' || p_lot_number, 1);
398: print_debug('p_oe_order_header_id: ' || p_oe_order_header_id, 1);
399: print_debug('p_oe_order_line_id: ' || p_oe_order_line_id, 1);

Line 407: INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity(

403: print_debug('p_to_organization_id: ' || p_to_organization_id, 1);
404: END IF;
405:
406:
407: INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity(
408: x_allowed =>l_allowed ,
409: x_allowed_quantity =>l_allowed_quantity ,
410: x_return_status =>l_return_status ,
411: x_msg_data =>l_msg_data ,

Line 427: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity return ' || l_return_status ||'and ' || l_progress, 1);

423: p_trx_quantity =>NULL
424: );
425:
426: IF g_debug = 1 THEN
427: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity return ' || l_return_status ||'and ' || l_progress, 1);
428: print_debug('l_allowed: ' || l_allowed, 1);
429: print_debug('l_allowed_quantity: ' || l_allowed_quantity, 1);
430: print_debug('l_return_status: ' || l_return_status, 1);
431: print_debug('l_msg_data: ' || l_msg_data, 1);

Line 437: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed

433: END IF;
434:
435: IF l_allowed = 'N' THEN
436: IF g_debug = 1 THEN
437: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed
438: as user quantity is greater than the available RMA quantity ' || l_progress, 1);
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 );

Line 451: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a user defined exception '|| l_progress, 1);

447: l_progress := '007' ;
448:
449: IF l_return_status = fnd_api.g_ret_sts_error THEN
450: IF g_debug = 1 THEN
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;

Line 454: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity');

450: IF g_debug = 1 THEN
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' ;

Line 462: print_debug('Program INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity has failed with a Unexpected exception ' || l_progress , 1);

458: l_progress := '008' ;
459:
460: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
461: IF g_debug = 1 THEN
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;

Line 465: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity');

461: IF g_debug = 1 THEN
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:

Line 472: ELSE --------IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(

468: END IF;
469:
470: l_progress :='009';
471:
472: ELSE --------IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(
473: /* lot is not present on RMA so user can receive into any valid
474: lot or create new lot and no quantity validation required.
475: Take RMA validation as Success*/
476: IF g_debug = 1 THEN

Line 477: print_debug(' INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists returns FALSE : ' || l_progress, 1);

473: /* lot is not present on RMA so user can receive into any valid
474: lot or create new lot and no quantity validation required.
475: Take RMA validation as Success*/
476: IF g_debug = 1 THEN
477: print_debug(' INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists returns FALSE : ' || l_progress, 1);
478: print_debug('l_msg_data: ' || l_msg_data, 1);
479: print_debug('l_msg_count: ' || l_msg_count, 1);
480: print_debug('l_count_rma_lots: ' || l_count_rma_lots, 1);
481: print_debug('lot is not present on RMA so user can receive into any valid

Line 487: END IF;--------IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(

483: Take RMA validation as Success: ' || l_progress, 1);
484: END IF;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: END IF;--------IF (INV_ROI_INTEGRATION_GRP.Inv_Rma_lot_info_exists(
488:
489: END IF;--------IF l_enforce_rma_lot_value = 'R' THEN
490:
491: IF g_debug = 1 THEN

Line 511: INV_ROI_INTEGRATION_GRP.Check_Item_Attributes(

507: l_lot_cont := FALSE ;
508: l_child_lot_cont := FALSE ;
509:
510:
511: INV_ROI_INTEGRATION_GRP.Check_Item_Attributes(
512: x_return_status => l_return_status
513: , x_msg_count => l_msg_count
514: , x_msg_data => l_msg_data
515: , x_lot_cont => l_lot_cont

Line 1295: print_debug('End of the program inv_roi_integration_grp.inv_validate_lot. Program has completed successfully '|| l_progress, 1);

1291: END;
1292:
1293: END IF; ------ IF p_line_secondary_quantity IS NOT NULL THEN
1294:
1295: print_debug('End of the program inv_roi_integration_grp.inv_validate_lot. Program has completed successfully '|| l_progress, 1);
1296:
1297: END IF; ------ IF p_new_lot= 'N' THEN
1298: -------end of validation for a new lot. Start Exception section --------------------------------------
1299:

Line 1497: 'INV_ROI_INTEGRATION_GRP'

1493: IF NOT fnd_api.compatible_api_call(
1494: l_api_version ,
1495: p_api_version ,
1496: l_api_name ,
1497: 'INV_ROI_INTEGRATION_GRP'
1498: ) THEN
1499: IF (g_debug = 1) THEN
1500: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);
1501: END IF;

Line 1500: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);

1496: l_api_name ,
1497: 'INV_ROI_INTEGRATION_GRP'
1498: ) THEN
1499: IF (g_debug = 1) THEN
1500: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_New_lot'|| l_progress, 1);
1501: END IF;
1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504:

Line 1615: failed with a Unexpected exception in INV_ROI_INTEGRATION_GRP.INV_NEW_LOT'|| l_progress, 1);

1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: IF g_debug = 1 THEN
1614: print_debug('Populating p_lot_rec with mtl_lot_number (shipping org values) has
1615: failed with a Unexpected exception in INV_ROI_INTEGRATION_GRP.INV_NEW_LOT'|| l_progress, 1);
1616: END IF;
1617: RAISE g_exc_unexpected_error;
1618: END;
1619:

Line 1870: print_debug('Updating MTLT with x_lot_rec(inv_lot_api_pub.Create_Inv_lot) has failed with a Unexpected exception in INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'|| l_progress, 1);

1866:
1867: EXCEPTION
1868: WHEN OTHERS THEN
1869: IF g_debug = 1 THEN
1870: print_debug('Updating MTLT with x_lot_rec(inv_lot_api_pub.Create_Inv_lot) has failed with a Unexpected exception in INV_ROI_INTEGRATION_GRP.INV_NEW_LOT :'|| l_progress, 1);
1871: END IF;
1872: RAISE g_exc_unexpected_error;
1873: END;
1874:

Line 2117: print_debug('End of the program inv_roi_integration_grp.inv_new_lot. Program has completed successfully: '|| l_progress, 9);

2113: END IF;------------IF l_permision_value = 'Y' THEN
2114: END IF;-----IF P_PRIMARY_UNIT_OF_MEASURE IS NOT NULL AND
2115: END IF;-------------- If p_line_secondary_quantity IS NOT NULL THEN
2116:
2117: print_debug('End of the program inv_roi_integration_grp.inv_new_lot. Program has completed successfully: '|| l_progress, 9);
2118:
2119: EXCEPTION
2120:
2121: WHEN NO_DATA_FOUND THEN

Line 2298: 'INV_ROI_INTEGRATION_GRP'

2294: IF NOT fnd_api.compatible_api_call(
2295: l_api_version,
2296: p_api_version,
2297: l_api_name,
2298: 'INV_ROI_INTEGRATION_GRP'
2299: ) THEN
2300: IF (g_debug = 1) THEN
2301: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);
2302: END IF;

Line 2301: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);

2297: l_api_name,
2298: 'INV_ROI_INTEGRATION_GRP'
2299: ) THEN
2300: IF (g_debug = 1) THEN
2301: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.INV_Synch_Quantities:' || l_progress, 1);
2302: END IF;
2303: RAISE fnd_api.g_exc_unexpected_error;
2304: END IF;
2305:

Line 2527: print_debug('Fetching RMA lot inside inv_roi_integration_grp.inv_rma_lot_info_exists failed:' || l_progress, 1);

2523:
2524: EXCEPTION
2525: WHEN OTHERS THEN
2526: IF g_debug = 1 THEN
2527: print_debug('Fetching RMA lot inside inv_roi_integration_grp.inv_rma_lot_info_exists failed:' || l_progress, 1);
2528: END IF;
2529: RAISE fnd_api.g_exc_error;
2530: END;
2531: l_progress :='062';

Line 2705: 'INV_ROI_INTEGRATION_GRP'

2701: IF NOT fnd_api.compatible_api_call(
2702: l_api_version,
2703: p_api_version,
2704: l_api_name,
2705: 'INV_ROI_INTEGRATION_GRP'
2706: ) THEN
2707: IF (g_debug = 1) THEN
2708: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);
2709: END IF;

Line 2708: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);

2704: l_api_name,
2705: 'INV_ROI_INTEGRATION_GRP'
2706: ) THEN
2707: IF (g_debug = 1) THEN
2708: print_debug('FND_API not compatible INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity:'|| l_progress, 1);
2709: END IF;
2710: RAISE fnd_api.g_exc_unexpected_error;
2711: END IF;
2712:

Line 3010: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');

3006: IF g_debug = 1 THEN
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:

Line 3032: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_ROI_INTEGRATION_GRP.INV_VALIDATE_RMA_QUANTITY');

3028: IF g_debug = 1 THEN
3029: print_debug(' RMA Quantity validation has failed ' || l_progress, 1);
3030: END IF;
3031: FND_MESSAGE.SET_NAME('PO','PO_RMA_QUANTITY_VAL_FAILED');
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;

Line 3049: print_debug('End of the program inv_roi_integration_grp.inv_new_lot. Program has completed successfully :'|| l_progress, 1);

3045: print_debug('quantity validation has passed:' || l_progress, 1);
3046: END IF;
3047: END IF;
3048:
3049: print_debug('End of the program inv_roi_integration_grp.inv_new_lot. Program has completed successfully :'|| l_progress, 1);
3050:
3051: EXCEPTION
3052:
3053: WHEN NO_DATA_FOUND THEN

Line 3270: END INV_ROI_INTEGRATION_GRP ;

3266:
3267: END Check_Item_Attributes;
3268:
3269:
3270: END INV_ROI_INTEGRATION_GRP ;
3271: