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.INVKBCGN dependencies on FND_PROFILE

Line 31: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

27: v_st_position number(3);
28: v_end_position number(3);
29: v_w_position number(3);
30:
31: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
32: Begin
33: select INSTR(value,',',1,2),INSTR(value,',',1,3)
34: into v_st_position,v_end_position
35: from v$parameter

Line 58: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

54: Internally it uses INV_LOG_UTIL.TRACE for writting
55: log messages to the log file.
56: */
57: PROCEDURE put_line(msg VARCHAR2) IS
58: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
59: BEGIN
60: IF (l_debug = 1) THEN
61: INV_LOG_UTIL.TRACE(msg,g_pkg_name);
62: END IF;

Line 91: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

87: X_PRINT_KANBAN_CARD IN NUMBER,
88: X_REPORT_ID IN NUMBER ) IS
89: v_Retcode Number;
90: CONC_STATUS BOOLEAN;
91: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
92: BEGIN
93:
94: -- This statement will help running this program in standalone mode
95: -- For bug 2464024 : Commenting out set_log_file and fnd_file.put_line

Line 257: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

253: v_success Number := 1;
254: v_report_id Number := NULL;
255: v_org_code VARCHAR2(3);
256:
257: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
258: Begin
259: For KBCC in MKPSC LOOP
260: REC := TRUE;
261: card_check_and_create( KBCC.PULL_SEQUENCE_ID,

Line 342: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

338: Rec BOOLEAN := FALSE;
339: v_success Number := 1;
340: v_report_id Number := NULL;
341:
342: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
343: Begin
344: v_report_id := x_report_id;
345: For KBCC in MKPSC
346: LOOP

Line 436: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

432: v_org_code VARCHAR2(3);
433: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
434: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
435:
436: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
437: Begin
438:
439: if ( (X_ITEM_LO IS NULL) AND (X_ITEM_HI IS NULL) ) then
440:

Line 819: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

815: v_org_code VARCHAR2(3);
816: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
817: v_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
818:
819: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
820: Begin
821: if ( (X_ITEM_LO IS NULL) AND (X_ITEM_HI IS NULL) ) then
822: Begin
823: For KBCC in MKPSC LOOP

Line 1036: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1032: l_org_code VARCHAR2(3) := Null;
1033: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1034: l_loc_name MTL_ITEM_LOCATIONS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;
1035:
1036: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1037: BEGIN
1038: l_pull_seq_rec.pull_sequence_id := X_pull_sequence_id;
1039: l_pull_seq_rec.organization_id := X_org_id ;
1040: l_pull_seq_rec.inventory_item_id := X_item_id ;

Line 1159: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1155:
1156:
1157: --CUR2 CUR1%ROWTYPE;
1158:
1159: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1160: BEGIN
1161:
1162: Select id_flex_num into v_flex_num
1163: from fnd_id_flex_structures

Line 1179: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);

1175:
1176: -- bug 4662395 set the profile mfg_organization_id so
1177: -- the call to MTL_PROJECT_V will return data.
1178:
1179: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1180:
1181: -- Building the where clause
1182:
1183: for CUR2 in CUR1(v_flex_num) Loop

Line 1285: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1281: order by a.segment_num;
1282:
1283: -- CUR2 CUR1%ROWTYPE;
1284:
1285: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1286: BEGIN
1287:
1288: Select id_flex_num into v_flex_num
1289: from fnd_id_flex_structures

Line 1351: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1347: v_req_id NUMBER;
1348: v_sort_by NUMBER := 3;
1349: v_call_from NUMBER := 2;
1350:
1351: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1352: BEGIN
1353: v_req_id := fnd_request.submit_request( 'INV',
1354: 'INVKBCPR',
1355: NULL,

Line 1393: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1389:
1390: Procedure Print_Error IS
1391: l_count number;
1392: l_msg varchar2(2000);
1393: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1394: begin
1395: Fnd_msg_pub.Count_And_get(p_count => l_count,
1396: p_data => l_msg,
1397: p_encoded => 'F');

Line 1453: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1449: a.display_flag = 'Y'
1450: order by a.segment_num;
1451:
1452:
1453: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1454: BEGIN
1455:
1456: Select id_flex_num into v_flex_num
1457: from fnd_id_flex_structures

Line 1467: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);

1463:
1464: -- bug 4662395 set the profile mfg_organization_id so
1465: -- the call to MTL_PROJECT_V will return data.
1466:
1467: FND_PROFILE.put('MFG_ORGANIZATION_ID',X_org_id);
1468:
1469: v_delim := fnd_flex_ext.get_delimiter('INV',v_flex_code, v_flex_num);
1470:
1471: str1 := '||'''||v_delim||'''||';