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.GML_OPM_ROI_GRP dependencies on ASN_DEBUG

Line 4: g_asn_debug VARCHAR2(1):= NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');

1: PACKAGE BODY GML_OPM_ROI_GRP AS
2: /* $Header: GMLGROIB.pls 115.9 2004/06/03 20:23:28 mchandak ship $*/
3:
4: g_asn_debug VARCHAR2(1):= NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');
5: g_opm_restrict_rma_lots VARCHAR2(100) ;
6: g_opm_rma_lot_info_exists BOOLEAN ;
7:
8: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS

Line 123: IF (g_asn_debug = 'Y') THEN

119: COMMIT;
120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('Unhandled exception in gml_opm_roi_grp.insert_errors=>'||substr(sqlerrm,1,200));
125: END IF;
126: END insert_errors;
127:

Line 124: asn_debug.put_line('Unhandled exception in gml_opm_roi_grp.insert_errors=>'||substr(sqlerrm,1,200));

120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('Unhandled exception in gml_opm_roi_grp.insert_errors=>'||substr(sqlerrm,1,200));
125: END IF;
126: END insert_errors;
127:
128:

Line 183: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN

179: BEGIN
180:
181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('lotid=>'||p_lot_id||'item id=>'||p_opm_item_id||'orgid=>'||p_organization_id||'locatorid=>'||p_locator_id||'qty=>'||p_primary_quantity);
185: END IF;
186:
187:

Line 184: asn_debug.put_line('lotid=>'||p_lot_id||'item id=>'||p_opm_item_id||'orgid=>'||p_organization_id||'locatorid=>'||p_locator_id||'qty=>'||p_primary_quantity);

180:
181: x_return_status := fnd_api.g_ret_sts_success;
182:
183: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
184: asn_debug.put_line('lotid=>'||p_lot_id||'item id=>'||p_opm_item_id||'orgid=>'||p_organization_id||'locatorid=>'||p_locator_id||'qty=>'||p_primary_quantity);
185: END IF;
186:
187:
188: IF p_opm_item_id IS NULL THEN

Line 196: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN

192: --Fetch the GMI Allow negative inv profile option
193: --Bug# 3664014
194: V_allow_neg_inv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
195:
196: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
197: asn_debug.put_line('-veinv profile=>'||v_allow_neg_inv);
198: END IF;
199:
200:

Line 197: asn_debug.put_line('-veinv profile=>'||v_allow_neg_inv);

193: --Bug# 3664014
194: V_allow_neg_inv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
195:
196: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
197: asn_debug.put_line('-veinv profile=>'||v_allow_neg_inv);
198: END IF;
199:
200:
201: --Negative inv is allowed so return.

Line 225: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN

221: IF p_locator_id is not null THEN
222: Open Cr_qoh_loct_not_null;
223: Fetch Cr_qoh_loct_not_null into l_loct_onhand;
224:
225: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
226: asn_debug.put_line('inventory onhand for locator=>'||l_loct_onhand);
227: END IF;
228:
229: IF (Cr_qoh_loct_not_null%NOTFOUND) OR (abs(p_primary_quantity) > nvl(l_loct_onhand,0))

Line 226: asn_debug.put_line('inventory onhand for locator=>'||l_loct_onhand);

222: Open Cr_qoh_loct_not_null;
223: Fetch Cr_qoh_loct_not_null into l_loct_onhand;
224:
225: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
226: asn_debug.put_line('inventory onhand for locator=>'||l_loct_onhand);
227: END IF;
228:
229: IF (Cr_qoh_loct_not_null%NOTFOUND) OR (abs(p_primary_quantity) > nvl(l_loct_onhand,0))
230: THEN

Line 254: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN

250:
251: Open Cr_qoh_loct_null;
252: Fetch Cr_qoh_loct_null into l_loct_onhand;
253:
254: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
255: asn_debug.put_line('inventory onhand for default locator=>'||l_loct_onhand);
256: END IF;
257:
258: IF (Cr_qoh_loct_null%NOTFOUND) OR (abs(p_primary_quantity) > nvl(l_loct_onhand,0))

Line 255: asn_debug.put_line('inventory onhand for default locator=>'||l_loct_onhand);

251: Open Cr_qoh_loct_null;
252: Fetch Cr_qoh_loct_null into l_loct_onhand;
253:
254: IF (p_lot_id IS NULL) AND (g_asn_debug = 'Y') THEN
255: asn_debug.put_line('inventory onhand for default locator=>'||l_loct_onhand);
256: END IF;
257:
258: IF (Cr_qoh_loct_null%NOTFOUND) OR (abs(p_primary_quantity) > nvl(l_loct_onhand,0))
259: THEN

Line 298: IF (g_asn_debug = 'Y') THEN

294: p_mesg_owner => NULL,
295: p_Error_Message_name => NULL);
296:
297: IF p_lot_id IS NULL THEN
298: IF (g_asn_debug = 'Y') THEN
299: asn_debug.put_line('Unhandled exception in validate_quantity_onhand=>'||l_progress||'-'||substr(sqlerrm,1,200));
300: END IF;
301: ELSE
302: IF NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0) = 1 THEN

Line 299: asn_debug.put_line('Unhandled exception in validate_quantity_onhand=>'||l_progress||'-'||substr(sqlerrm,1,200));

295: p_Error_Message_name => NULL);
296:
297: IF p_lot_id IS NULL THEN
298: IF (g_asn_debug = 'Y') THEN
299: asn_debug.put_line('Unhandled exception in validate_quantity_onhand=>'||l_progress||'-'||substr(sqlerrm,1,200));
300: END IF;
301: ELSE
302: IF NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0) = 1 THEN
303: print_debug('VALIDATE_QUANTITY_ONHAND:UNHANDLED EXCEPTION'||l_progress||'-'||substr(sqlerrm,1,100), 1);

Line 320: IF (g_asn_debug = 'Y') THEN

316: l_opm_item_id NUMBER ;
317:
318: BEGIN
319:
320: IF (g_asn_debug = 'Y') THEN
321: asn_debug.put_line('Validating Process Item'||l_progress);
322: END IF;
323:
324: -- bug# 3664014

Line 321: asn_debug.put_line('Validating Process Item'||l_progress);

317:
318: BEGIN
319:
320: IF (g_asn_debug = 'Y') THEN
321: asn_debug.put_line('Validating Process Item'||l_progress);
322: END IF;
323:
324: -- bug# 3664014
325: -- added some more parameters in x_opm_record type.

Line 381: IF (g_asn_debug = 'Y') THEN

377: OR (x_opm_record.transaction_type IN ('RETURN TO RECEIVING','RETURN TO VENDOR','RETURN TO CUSTOMER'))
378: )
379: AND ( x_opm_record.destination_type_code = 'INVENTORY') THEN
380:
381: IF (g_asn_debug = 'Y') THEN
382: asn_debug.put_line('validation primary qty against onhand'||l_progress);
383: END IF;
384:
385: l_locator_id := x_opm_record.from_locator_id ;

Line 382: asn_debug.put_line('validation primary qty against onhand'||l_progress);

378: )
379: AND ( x_opm_record.destination_type_code = 'INVENTORY') THEN
380:
381: IF (g_asn_debug = 'Y') THEN
382: asn_debug.put_line('validation primary qty against onhand'||l_progress);
383: END IF;
384:
385: l_locator_id := x_opm_record.from_locator_id ;
386:

Line 395: IF (g_asn_debug = 'Y') THEN

391: p_primary_quantity => x_opm_record.primary_quantity,
392: p_rti_id => x_opm_record.rti_id,
393: x_return_status => l_return_status );
394:
395: IF (g_asn_debug = 'Y') THEN
396: asn_debug.put_line('validate_quantity_onhand done'||l_return_status);
397: END IF;
398:
399: IF l_return_status <> 'S' THEN

Line 396: asn_debug.put_line('validate_quantity_onhand done'||l_return_status);

392: p_rti_id => x_opm_record.rti_id,
393: x_return_status => l_return_status );
394:
395: IF (g_asn_debug = 'Y') THEN
396: asn_debug.put_line('validate_quantity_onhand done'||l_return_status);
397: END IF;
398:
399: IF l_return_status <> 'S' THEN
400: -- bug 3664014 insert into po_interface_error even if its warning.

Line 441: IF (g_asn_debug = 'Y') THEN

437: RETURN;
438: END ;
439: END IF;
440:
441: IF (g_asn_debug = 'Y') THEN
442: asn_debug.put_line('Validating Secondary Qty' || l_progress);
443: END IF;
444:
445: -- if secondary quantity is present, validate it else calculate it.

Line 442: asn_debug.put_line('Validating Secondary Qty' || l_progress);

438: END ;
439: END IF;
440:
441: IF (g_asn_debug = 'Y') THEN
442: asn_debug.put_line('Validating Secondary Qty' || l_progress);
443: END IF;
444:
445: -- if secondary quantity is present, validate it else calculate it.
446: -- if secondary_unit_of_measure is not null,validate it else derive it.

Line 463: IF (g_asn_debug = 'Y') THEN

459: , x_return_status => l_return_status
460: , x_msg_count => l_msg_count
461: , x_msg_data => l_msg_data ) ;
462:
463: IF (g_asn_debug = 'Y') THEN
464: asn_debug.put_line('Status of Validating Secondary Qty' || l_return_status);
465: asn_debug.put_line('secondary unit' || x_opm_record.secondary_unit_of_measure);
466: asn_debug.put_line('secondary qty' || x_opm_record.secondary_quantity);
467: END IF;

Line 464: asn_debug.put_line('Status of Validating Secondary Qty' || l_return_status);

460: , x_msg_count => l_msg_count
461: , x_msg_data => l_msg_data ) ;
462:
463: IF (g_asn_debug = 'Y') THEN
464: asn_debug.put_line('Status of Validating Secondary Qty' || l_return_status);
465: asn_debug.put_line('secondary unit' || x_opm_record.secondary_unit_of_measure);
466: asn_debug.put_line('secondary qty' || x_opm_record.secondary_quantity);
467: END IF;
468:

Line 465: asn_debug.put_line('secondary unit' || x_opm_record.secondary_unit_of_measure);

461: , x_msg_data => l_msg_data ) ;
462:
463: IF (g_asn_debug = 'Y') THEN
464: asn_debug.put_line('Status of Validating Secondary Qty' || l_return_status);
465: asn_debug.put_line('secondary unit' || x_opm_record.secondary_unit_of_measure);
466: asn_debug.put_line('secondary qty' || x_opm_record.secondary_quantity);
467: END IF;
468:
469: IF l_return_status <> 'S' THEN

Line 466: asn_debug.put_line('secondary qty' || x_opm_record.secondary_quantity);

462:
463: IF (g_asn_debug = 'Y') THEN
464: asn_debug.put_line('Status of Validating Secondary Qty' || l_return_status);
465: asn_debug.put_line('secondary unit' || x_opm_record.secondary_unit_of_measure);
466: asn_debug.put_line('secondary qty' || x_opm_record.secondary_quantity);
467: END IF;
468:
469: IF l_return_status <> 'S' THEN
470: x_opm_record.error_record.error_status := 'F';

Line 513: IF (g_asn_debug = 'Y') THEN

509: p_error_message => 'UNHANDLED EXCEPTION IN VALIDATE_OPM_PARAMETERS :' || l_progress||'-' ||
510: substr(sqlerrm,1,1000),
511: p_mesg_owner => NULL,
512: p_Error_Message_name => NULL);
513: IF (g_asn_debug = 'Y') THEN
514: asn_debug.put_line('Unhandled exception in validate_opm_parameters=>'|| l_progress||'-'||substr(sqlerrm,1,200));
515: END IF;
516:
517: END validate_opm_parameters;

Line 514: asn_debug.put_line('Unhandled exception in validate_opm_parameters=>'|| l_progress||'-'||substr(sqlerrm,1,200));

510: substr(sqlerrm,1,1000),
511: p_mesg_owner => NULL,
512: p_Error_Message_name => NULL);
513: IF (g_asn_debug = 'Y') THEN
514: asn_debug.put_line('Unhandled exception in validate_opm_parameters=>'|| l_progress||'-'||substr(sqlerrm,1,200));
515: END IF;
516:
517: END validate_opm_parameters;
518: