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 FND_PROFILE

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 194: V_allow_neg_inv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);

190: END IF;
191:
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;

Line 249: l_default_location := fnd_profile.value('IC$DEFAULT_LOCT');

245: END IF;
246: END IF;
247: Close Cr_qoh_loct_not_null;
248: ELSE
249: l_default_location := fnd_profile.value('IC$DEFAULT_LOCT');
250:
251: Open Cr_qoh_loct_null;
252: Fetch Cr_qoh_loct_null into l_loct_onhand;
253:

Line 302: IF NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0) = 1 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);
304: END IF;
305: END IF;
306: END validate_quantity_onhand;

Line 527: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

523: p_rti_id IN NUMBER,
524: x_return_status IN OUT NOCOPY VARCHAR2 ) IS
525:
526: l_temp VARCHAR2(1);
527: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
528: l_progress VARCHAR2(4) := '010' ;
529:
530: CURSOR Cur_lot_ctrl_lot IS
531: SELECT lot_id,inactive_ind,delete_mark

Line 556: g_default_lot := nvl(FND_PROFILE.VALUE('IC$DEFAULT_LOT'),'0') ;

552: BEGIN
553:
554: x_return_status := fnd_api.g_ret_sts_success;
555:
556: g_default_lot := nvl(FND_PROFILE.VALUE('IC$DEFAULT_LOT'),'0') ;
557:
558: IF l_inv_debug = 1 THEN
559: print_debug('Default Lot=>'||g_default_lot, 1);
560: END IF;

Line 740: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

736: l_reason_code_security VARCHAR2(1) := 'N';
737:
738: l_message_data VARCHAR2(2000);
739:
740: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
741: l_progress VARCHAR2(4) := '010' ;
742:
743: Cursor Get_Reason_Code IS
744: select reason_code

Line 794: l_location := fnd_profile.value('IC$DEFAULT_LOCT');

790: WHEN OTHERS THEN
791: l_location := NULL;
792: END;
793: ELSE
794: l_location := fnd_profile.value('IC$DEFAULT_LOCT');
795: END IF;
796:
797:
798: BEGIN

Line 851: l_reason_code_security := nvl(fnd_profile.value('GMA_REASON_CODE_SECURITY'), 'N');

847:
848: If p_lot_attribute_rec.reason_code IS NOT NULL THEN
849: l_trans_rec.reason_code := p_lot_attribute_rec.reason_code ;
850: Else
851: l_reason_code_security := nvl(fnd_profile.value('GMA_REASON_CODE_SECURITY'), 'N');
852: Open Get_Reason_Code;
853: Fetch Get_Reason_Code into l_trans_rec.reason_code;
854: If Get_Reason_Code%NOTFOUND Then
855: Close Get_Reason_Code;

Line 965: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

961: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
962: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
963: l_msg_count NUMBER(3);
964: l_msg_data VARCHAR2(2000);
965: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
966: l_progress VARCHAR2(4) := '010' ;
967: l_to_um_type VARCHAR2(10);
968: l_to_um_code VARCHAR2(4);
969: l_from_um_type VARCHAR2(10);

Line 1038: IF fnd_profile.value('GML_ENABLE_DYN_LOT_SPEC_CONV') = 'Y' THEN

1034: IF p_from_unit_of_measure IS NOT NULL AND p_to_unit_of_measure IS NOT NULL THEN
1035: -- check class of from and to uom. call conversion API only if they
1036: -- belong to different class.Also don't create for fixed UOM type(dualum_ind = 1)
1037: -- API requires OPM um_code so fetch OPM um code
1038: IF fnd_profile.value('GML_ENABLE_DYN_LOT_SPEC_CONV') = 'Y' THEN
1039:
1040: SELECT um_type , um_code INTO l_from_um_type , l_from_um_code
1041: FROM SY_UOMS_MST
1042: WHERE unit_of_measure = p_from_unit_of_measure ;

Line 1076: END IF ; -- IF fnd_profile.value('GML_ENABLE_DYN_LOT_SPEC_CONV') = 'Y' THEN

1072: RETURN;
1073: END IF;
1074:
1075: END IF ;
1076: END IF ; -- IF fnd_profile.value('GML_ENABLE_DYN_LOT_SPEC_CONV') = 'Y' THEN
1077: END IF;
1078:
1079:
1080: EXCEPTION

Line 1143: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1139: x_line_set_id OUT NOCOPY NUMBER,
1140: x_oe_lot_quantity OUT NOCOPY NUMBER,
1141: x_return_status OUT NOCOPY VARCHAR2 ) IS
1142:
1143: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1144:
1145: Cursor Cr_rma_lots Is
1146: Select o.quantity
1147: from oe_lot_serial_numbers o

Line 1221: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1217: x_allowed OUT NOCOPY VARCHAR2,
1218: x_allowed_quantity OUT NOCOPY NUMBER,
1219: x_return_status OUT NOCOPY VARCHAR2 ) IS
1220:
1221: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1222:
1223: BEGIN
1224: IF g_opm_restrict_rma_lots IN ('RESTRICTED_WITH_WARNING','RESTRICTED') AND
1225: g_opm_rma_lot_info_exists AND p_rma_lot_qty IS NOT NULL THEN

Line 1345: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1341: l_cr_avaliable_qty NUMBER;
1342: l_temp VARCHAR2(1);
1343: l_rti_primary_qty NUMBER;
1344:
1345: l_inv_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1346: l_progress VARCHAR2(4) := '010' ;
1347: l_update_lot_qty BOOLEAN := FALSE;
1348:
1349: l_oe_order_header_id NUMBER;

Line 1564: g_opm_restrict_rma_lots := fnd_profile.value('GMI_RMA_LOT_RESTRICT') ;

1560:
1561: l_progress := '050' ;
1562:
1563: IF l_source_document_code = 'RMA' THEN
1564: g_opm_restrict_rma_lots := fnd_profile.value('GMI_RMA_LOT_RESTRICT') ;
1565: IF l_inv_debug = 1 THEN
1566: print_debug('GMI_RMA_LOT_RESTRICT =>'||g_opm_restrict_rma_lots, 1);
1567: END IF;
1568: IF g_opm_restrict_rma_lots IN ('RESTRICTED_WITH_WARNING','RESTRICTED') THEN

Line 1694: g_moved_diff_stat := fnd_profile.value('IC$MOVEDIFFSTAT');

1690: IF p_new_lot = 'N' THEN
1691: l_progress := '070' ;
1692: IF l_transaction_type = 'DELIVER' THEN
1693: -- validate lot status depending upon the profile option.
1694: g_moved_diff_stat := fnd_profile.value('IC$MOVEDIFFSTAT');
1695: IF g_moved_diff_stat in (0,2) THEN
1696: l_locator_id := l_to_locator_id ;
1697: check_lot_status(p_lot_attribute_rec => l_lot_attribute_rec,
1698: p_organization_id => l_org_id,