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_LABEL dependencies on FND_GLOBAL

Line 5: LABELS_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

1: PACKAGE BODY INV_LABEL AS
2: /* $Header: INVLABPB.pls 120.17.12010000.3 2008/12/15 14:03:00 satishku ship $ */
3:
4: LABELS_B CONSTANT VARCHAR2(50) := ' 5: LABELS_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
6: LABEL_B CONSTANT VARCHAR2(50) := ' 7: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
8: VARIABLE_B CONSTANT VARCHAR2(50) := ' 9: VARIABLE_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
10: TAG_E CONSTANT VARCHAR2(50) := '>'||fnd_global.local_chr(10);
11: BPA_HEADER_B CONSTANT VARCHAR2(10) := '';

Line 9: VARIABLE_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);

5: LABELS_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
6: LABEL_B CONSTANT VARCHAR2(50) := ' 7: LABEL_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
8: VARIABLE_B CONSTANT VARCHAR2(50) := ' 9: VARIABLE_E CONSTANT VARCHAR2(50) := ''||fnd_global.local_chr(10);
10: TAG_E CONSTANT VARCHAR2(50) := '>'||fnd_global.local_chr(10);
11: BPA_HEADER_B CONSTANT VARCHAR2(10) := '';
12: BPA_HEADER_E CONSTANT VARCHAR2(10) := '';
13:
14: TRACE_LEVEL CONSTANT NUMBER := 12;

Line 18: XML_HEADER1_2 CONSTANT VARCHAR2(100) := '" standalone="no"?>'||fnd_global.local_chr(10);

14: TRACE_LEVEL CONSTANT NUMBER := 12;
15: TRACE_PROMPT CONSTANT VARCHAR2(10) := 'LABEL_MAIN';
16:
17: XML_HEADER1 VARCHAR2(100) := ' 18: XML_HEADER1_2 CONSTANT VARCHAR2(100) := '" standalone="no"?>'||fnd_global.local_chr(10);
19: XML_HEADER2 CONSTANT VARCHAR2(100) := ''||fnd_global.local_chr(10);
20:
21: /*-----------------------------------------
22: * PRIVATE API

Line 19: XML_HEADER2 CONSTANT VARCHAR2(100) := ''||fnd_global.local_chr(10);

15: TRACE_PROMPT CONSTANT VARCHAR2(10) := 'LABEL_MAIN';
16:
17: XML_HEADER1 VARCHAR2(100) := ' 18: XML_HEADER1_2 CONSTANT VARCHAR2(100) := '" standalone="no"?>'||fnd_global.local_chr(10);
19: XML_HEADER2 CONSTANT VARCHAR2(100) := ''||fnd_global.local_chr(10);
20:
21: /*-----------------------------------------
22: * PRIVATE API
23: *---------------------------------------*/

Line 109: decode(wblt.level_type_code, 10001,0,10002,FND_GLOBAL.RESP_APPL_ID

105: -- , decode(wblt.level_type_code,10001,'Site',10002,'Application',10003,'Responsibility',10004,'User') level_type_name
106: FROM wms_bflow_label_type wblt, mfg_lookups ml
107: WHERE wblt.business_flow_code = p_business_flow
108: AND wblt.level_value_id =
109: decode(wblt.level_type_code, 10001,0,10002,FND_GLOBAL.RESP_APPL_ID
110: ,10003,FND_GLOBAL.RESP_ID,10004, FND_GLOBAL.USER_ID)
111: AND nvl(wblt.enabled_flag, 'N') = 'Y'
112: AND ml.lookup_type = 'WMS_LABEL_TYPE'
113: AND ml.lookup_code = wblt.document_id

Line 110: ,10003,FND_GLOBAL.RESP_ID,10004, FND_GLOBAL.USER_ID)

106: FROM wms_bflow_label_type wblt, mfg_lookups ml
107: WHERE wblt.business_flow_code = p_business_flow
108: AND wblt.level_value_id =
109: decode(wblt.level_type_code, 10001,0,10002,FND_GLOBAL.RESP_APPL_ID
110: ,10003,FND_GLOBAL.RESP_ID,10004, FND_GLOBAL.USER_ID)
111: AND nvl(wblt.enabled_flag, 'N') = 'Y'
112: AND ml.lookup_type = 'WMS_LABEL_TYPE'
113: AND ml.lookup_code = wblt.document_id
114: order by wblt.level_type_code desc;

Line 162: trace(' FND_GLOBAL.USER_ID : '|| FND_GLOBAL.USER_ID, TRACE_PROMPT, TRACE_LEVEL);

158: l_org_id NUMBER ;
159:
160: BEGIN
161: IF (l_debug = 1) THEN
162: trace(' FND_GLOBAL.USER_ID : '|| FND_GLOBAL.USER_ID, TRACE_PROMPT, TRACE_LEVEL);
163: END IF;
164:
165: IF (l_debug = 1) THEN
166: trace(' In Get_type_to_print,busFlow,lableTypeID,Manualformat,ManualPrinter= '

Line 259: p_user_id =>fnd_global.user_id,

255:
256: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
257: p_concurrent_program_id=>p_label_type_id,
258: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
259: p_user_id =>fnd_global.user_id,
260: p_responsibility_id =>fnd_global.resp_id,
261: p_application_id =>fnd_global.resp_appl_id,
262: x_printer =>l_default_printer,
263: x_api_status =>l_api_status,

Line 260: p_responsibility_id =>fnd_global.resp_id,

256: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
257: p_concurrent_program_id=>p_label_type_id,
258: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
259: p_user_id =>fnd_global.user_id,
260: p_responsibility_id =>fnd_global.resp_id,
261: p_application_id =>fnd_global.resp_appl_id,
262: x_printer =>l_default_printer,
263: x_api_status =>l_api_status,
264: x_error_message =>l_error_message

Line 261: p_application_id =>fnd_global.resp_appl_id,

257: p_concurrent_program_id=>p_label_type_id,
258: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
259: p_user_id =>fnd_global.user_id,
260: p_responsibility_id =>fnd_global.resp_id,
261: p_application_id =>fnd_global.resp_appl_id,
262: x_printer =>l_default_printer,
263: x_api_status =>l_api_status,
264: x_error_message =>l_error_message
265: );

Line 338: p_user_id =>fnd_global.user_id,

334:
335: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
336: p_concurrent_program_id=> l_type.label_type_id,
337: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
338: p_user_id =>fnd_global.user_id,
339: p_responsibility_id =>fnd_global.resp_id,
340: p_application_id =>fnd_global.resp_appl_id,
341: x_printer =>l_default_printer,
342: x_api_status =>l_api_status,

Line 339: p_responsibility_id =>fnd_global.resp_id,

335: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
336: p_concurrent_program_id=> l_type.label_type_id,
337: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
338: p_user_id =>fnd_global.user_id,
339: p_responsibility_id =>fnd_global.resp_id,
340: p_application_id =>fnd_global.resp_appl_id,
341: x_printer =>l_default_printer,
342: x_api_status =>l_api_status,
343: x_error_message =>l_error_message

Line 340: p_application_id =>fnd_global.resp_appl_id,

336: p_concurrent_program_id=> l_type.label_type_id,
337: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
338: p_user_id =>fnd_global.user_id,
339: p_responsibility_id =>fnd_global.resp_id,
340: p_application_id =>fnd_global.resp_appl_id,
341: x_printer =>l_default_printer,
342: x_api_status =>l_api_status,
343: x_error_message =>l_error_message
344: );

Line 413: p_user_id =>fnd_global.user_id,

409:
410: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
411: p_concurrent_program_id=> v_type.label_type_id,
412: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
413: p_user_id =>fnd_global.user_id,
414: p_responsibility_id =>fnd_global.resp_id,
415: p_application_id =>fnd_global.resp_appl_id,
416: x_printer =>l_default_printer,
417: x_api_status =>l_api_status,

Line 414: p_responsibility_id =>fnd_global.resp_id,

410: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
411: p_concurrent_program_id=> v_type.label_type_id,
412: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
413: p_user_id =>fnd_global.user_id,
414: p_responsibility_id =>fnd_global.resp_id,
415: p_application_id =>fnd_global.resp_appl_id,
416: x_printer =>l_default_printer,
417: x_api_status =>l_api_status,
418: x_error_message =>l_error_message

Line 415: p_application_id =>fnd_global.resp_appl_id,

411: p_concurrent_program_id=> v_type.label_type_id,
412: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
413: p_user_id =>fnd_global.user_id,
414: p_responsibility_id =>fnd_global.resp_id,
415: p_application_id =>fnd_global.resp_appl_id,
416: x_printer =>l_default_printer,
417: x_api_status =>l_api_status,
418: x_error_message =>l_error_message
419: );

Line 839: FROM FND_USER WHERE user_id = fnd_global.user_id;

835: G_DATE := l_date;
836: G_TIME := l_time;
837:
838: SELECT user_name INTO G_USER
839: FROM FND_USER WHERE user_id = fnd_global.user_id;
840:
841: EXCEPTION
842: WHEN others THEN
843: IF (l_debug = 1) THEN

Line 1331: -- input('INV_DEBUG_TRACE') based on the current fnd_global.user_id.

1327:
1328: BEGIN
1329: -- Bug 2449358 : LABELING: LABEL_XML.LOG SHOULD ONLY BE CREATED IF DEBUG IS ON
1330: -- The fnd_profile.get, gets the value for the
1331: -- input('INV_DEBUG_TRACE') based on the current fnd_global.user_id.
1332: -- According to the new design, the LABEL_XML.log will only be generated if the profile option
1333: -- INV: Debug Trace is set to 'Yes'. Hence the IF clause around the existing code.
1334:
1335: -- Get INV_DEBUG_TRACE profile for the current user.

Line 1338: --l_debug_trace := fnd_profile.value_specific('INV_DEBUG_TRACE',fnd_global.user_id);

1334:
1335: -- Get INV_DEBUG_TRACE profile for the current user.
1336: fnd_profile.get('INV_DEBUG_TRACE',l_debug_trace);
1337:
1338: --l_debug_trace := fnd_profile.value_specific('INV_DEBUG_TRACE',fnd_global.user_id);
1339: IF (l_debug = 1) THEN
1340: trace('INV_DEBUG_TRACE = ' || l_debug_trace, TRACE_PROMPT, TRACE_LEVEL);
1341: END IF;
1342:

Line 1348: --l_dir := fnd_profile.value_specific('INV_DEBUG_FILE',fnd_global.user_id);

1344: -- l_debug_trace = 1 means 'Yes' and 2 means 'No'
1345:
1346: --Get directory from INV_DEBUG_FILE profile
1347: fnd_profile.get('INV_DEBUG_FILE',l_dir);
1348: --l_dir := fnd_profile.value_specific('INV_DEBUG_FILE',fnd_global.user_id);
1349: IF (l_debug = 1) THEN
1350: trace('INV_DEBUG_FILE = ' || l_dir, TRACE_PROMPT, TRACE_LEVEL);
1351: END IF;
1352:

Line 1692: l_hist_rec.REQUEST_USER_ID :=fnd_global.user_id;

1688: l_hist_rec.LABEL_CONTENT :=p_label_content;
1689: l_hist_rec.JOB_NAME :=l_job_name;
1690: l_hist_rec.REQUEST_MODE_CODE :=G_PROFILE_PRINT_MODE;
1691: l_hist_rec.REQUEST_DATE :=sysdate;
1692: l_hist_rec.REQUEST_USER_ID :=fnd_global.user_id;
1693: l_hist_rec.OUTFILE_NAME :=null;
1694: l_hist_rec.OUTFILE_DIRECTORY :=null;
1695: l_hist_rec.NO_OF_COPY :=p_label_type_info.default_no_of_copies;
1696: l_hist_rec.ENCODING :=G_XML_ENCODING;

Line 1935: FND_GLOBAL.user_id,

1931: P_CUSTOMER_ITEM_ID ,
1932: P_CUSTOMER_CONTACT_ID ,
1933: P_FREIGHT_CODE ,
1934: sysdate,
1935: FND_GLOBAL.user_id,
1936: sysdate,
1937: FND_GLOBAL.user_id,
1938: P_LAST_UPDATE_LOGIN ,
1939: P_REQUEST_ID ,

Line 1937: FND_GLOBAL.user_id,

1933: P_FREIGHT_CODE ,
1934: sysdate,
1935: FND_GLOBAL.user_id,
1936: sysdate,
1937: FND_GLOBAL.user_id,
1938: P_LAST_UPDATE_LOGIN ,
1939: P_REQUEST_ID ,
1940: P_PROGRAM_APPLICATION_ID,
1941: P_PROGRAM_ID ,

Line 3496: l_history_rec.request_user_id := fnd_global.user_id;

3492: l_history_rec.request_date := l_sysdate;
3493: l_history_rec.creation_date := l_sysdate;
3494: l_history_rec.last_update_date := l_sysdate;
3495:
3496: l_history_rec.request_user_id := fnd_global.user_id;
3497: l_history_rec.created_by := fnd_global.user_id;
3498: l_history_rec.last_updated_by := fnd_global.user_id;
3499:
3500: IF (l_debug = 1) THEN

Line 3497: l_history_rec.created_by := fnd_global.user_id;

3493: l_history_rec.creation_date := l_sysdate;
3494: l_history_rec.last_update_date := l_sysdate;
3495:
3496: l_history_rec.request_user_id := fnd_global.user_id;
3497: l_history_rec.created_by := fnd_global.user_id;
3498: l_history_rec.last_updated_by := fnd_global.user_id;
3499:
3500: IF (l_debug = 1) THEN
3501: trace('Set original request ID='||l_history_rec.original_request_id,TRACE_PROMPT, TRACE_LEVEL);

Line 3498: l_history_rec.last_updated_by := fnd_global.user_id;

3494: l_history_rec.last_update_date := l_sysdate;
3495:
3496: l_history_rec.request_user_id := fnd_global.user_id;
3497: l_history_rec.created_by := fnd_global.user_id;
3498: l_history_rec.last_updated_by := fnd_global.user_id;
3499:
3500: IF (l_debug = 1) THEN
3501: trace('Set original request ID='||l_history_rec.original_request_id,TRACE_PROMPT, TRACE_LEVEL);
3502: trace('Set new label_request_id='||l_history_rec.label_request_id, TRACE_PROMPT, TRACE_LEVEL);