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.25.12020000.9 2013/03/25 08:17:38 jiahyang 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 110: decode(wblt.level_type_code, 10001,0,10002,FND_GLOBAL.RESP_APPL_ID

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

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

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

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

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

Line 295: p_user_id =>fnd_global.user_id,

291:
292: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
293: p_concurrent_program_id=>p_label_type_id,
294: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
295: p_user_id =>fnd_global.user_id,
296: p_responsibility_id =>fnd_global.resp_id,
297: p_application_id =>fnd_global.resp_appl_id,
298: x_printer =>l_default_printer,
299: x_api_status =>l_api_status,

Line 296: p_responsibility_id =>fnd_global.resp_id,

292: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
293: p_concurrent_program_id=>p_label_type_id,
294: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
295: p_user_id =>fnd_global.user_id,
296: p_responsibility_id =>fnd_global.resp_id,
297: p_application_id =>fnd_global.resp_appl_id,
298: x_printer =>l_default_printer,
299: x_api_status =>l_api_status,
300: x_error_message =>l_error_message

Line 297: p_application_id =>fnd_global.resp_appl_id,

293: p_concurrent_program_id=>p_label_type_id,
294: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
295: p_user_id =>fnd_global.user_id,
296: p_responsibility_id =>fnd_global.resp_id,
297: p_application_id =>fnd_global.resp_appl_id,
298: x_printer =>l_default_printer,
299: x_api_status =>l_api_status,
300: x_error_message =>l_error_message
301: );

Line 374: p_user_id =>fnd_global.user_id,

370:
371: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
372: p_concurrent_program_id=> l_type.label_type_id,
373: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
374: p_user_id =>fnd_global.user_id,
375: p_responsibility_id =>fnd_global.resp_id,
376: p_application_id =>fnd_global.resp_appl_id,
377: x_printer =>l_default_printer,
378: x_api_status =>l_api_status,

Line 375: p_responsibility_id =>fnd_global.resp_id,

371: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
372: p_concurrent_program_id=> l_type.label_type_id,
373: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
374: p_user_id =>fnd_global.user_id,
375: p_responsibility_id =>fnd_global.resp_id,
376: p_application_id =>fnd_global.resp_appl_id,
377: x_printer =>l_default_printer,
378: x_api_status =>l_api_status,
379: x_error_message =>l_error_message

Line 376: p_application_id =>fnd_global.resp_appl_id,

372: p_concurrent_program_id=> l_type.label_type_id,
373: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
374: p_user_id =>fnd_global.user_id,
375: p_responsibility_id =>fnd_global.resp_id,
376: p_application_id =>fnd_global.resp_appl_id,
377: x_printer =>l_default_printer,
378: x_api_status =>l_api_status,
379: x_error_message =>l_error_message
380: );

Line 449: p_user_id =>fnd_global.user_id,

445:
446: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
447: p_concurrent_program_id=> v_type.label_type_id,
448: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
449: p_user_id =>fnd_global.user_id,
450: p_responsibility_id =>fnd_global.resp_id,
451: p_application_id =>fnd_global.resp_appl_id,
452: x_printer =>l_default_printer,
453: x_api_status =>l_api_status,

Line 450: p_responsibility_id =>fnd_global.resp_id,

446: WSH_REPORT_PRINTERS_PVT.GET_PRINTER(
447: p_concurrent_program_id=> v_type.label_type_id,
448: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
449: p_user_id =>fnd_global.user_id,
450: p_responsibility_id =>fnd_global.resp_id,
451: p_application_id =>fnd_global.resp_appl_id,
452: x_printer =>l_default_printer,
453: x_api_status =>l_api_status,
454: x_error_message =>l_error_message

Line 451: p_application_id =>fnd_global.resp_appl_id,

447: p_concurrent_program_id=> v_type.label_type_id,
448: p_organization_id =>l_org_id,--Bug 4553439. Added the parameter for organization_id
449: p_user_id =>fnd_global.user_id,
450: p_responsibility_id =>fnd_global.resp_id,
451: p_application_id =>fnd_global.resp_appl_id,
452: x_printer =>l_default_printer,
453: x_api_status =>l_api_status,
454: x_error_message =>l_error_message
455: );

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

896: G_DATE := l_date;
897: G_TIME := l_time;
898:
899: SELECT user_name INTO G_USER
900: FROM FND_USER WHERE user_id = fnd_global.user_id;
901:
902: EXCEPTION
903: WHEN others THEN
904: IF (l_debug = 1) THEN

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

1388:
1389: BEGIN
1390: -- Bug 2449358 : LABELING: LABEL_XML.LOG SHOULD ONLY BE CREATED IF DEBUG IS ON
1391: -- The fnd_profile.get, gets the value for the
1392: -- input('INV_DEBUG_TRACE') based on the current fnd_global.user_id.
1393: -- According to the new design, the LABEL_XML.log will only be generated if the profile option
1394: -- INV: Debug Trace is set to 'Yes'. Hence the IF clause around the existing code.
1395:
1396: -- Get INV_DEBUG_TRACE profile for the current user.

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

1395:
1396: -- Get INV_DEBUG_TRACE profile for the current user.
1397: fnd_profile.get('INV_DEBUG_TRACE',l_debug_trace);
1398:
1399: --l_debug_trace := fnd_profile.value_specific('INV_DEBUG_TRACE',fnd_global.user_id);
1400: IF (l_debug = 1) THEN
1401: trace('INV_DEBUG_TRACE = ' || l_debug_trace, TRACE_PROMPT, TRACE_LEVEL);
1402: END IF;
1403:

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

1405: -- l_debug_trace = 1 means 'Yes' and 2 means 'No'
1406:
1407: --Get directory from INV_DEBUG_FILE profile
1408: fnd_profile.get('INV_DEBUG_FILE',l_dir);
1409: --l_dir := fnd_profile.value_specific('INV_DEBUG_FILE',fnd_global.user_id);
1410: IF (l_debug = 1) THEN
1411: trace('INV_DEBUG_FILE = ' || l_dir, TRACE_PROMPT, TRACE_LEVEL);
1412: END IF;
1413:

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

1749: l_hist_rec.LABEL_CONTENT :=p_label_content;
1750: l_hist_rec.JOB_NAME :=l_job_name;
1751: l_hist_rec.REQUEST_MODE_CODE :=G_PROFILE_PRINT_MODE;
1752: l_hist_rec.REQUEST_DATE :=sysdate;
1753: l_hist_rec.REQUEST_USER_ID :=fnd_global.user_id;
1754: l_hist_rec.OUTFILE_NAME :=null;
1755: l_hist_rec.OUTFILE_DIRECTORY :=null;
1756: l_hist_rec.NO_OF_COPY :=p_label_type_info.default_no_of_copies;
1757: l_hist_rec.ENCODING :=G_XML_ENCODING;

Line 1996: FND_GLOBAL.user_id,

1992: P_CUSTOMER_ITEM_ID ,
1993: P_CUSTOMER_CONTACT_ID ,
1994: P_FREIGHT_CODE ,
1995: sysdate,
1996: FND_GLOBAL.user_id,
1997: sysdate,
1998: FND_GLOBAL.user_id,
1999: P_LAST_UPDATE_LOGIN ,
2000: P_REQUEST_ID ,

Line 1998: FND_GLOBAL.user_id,

1994: P_FREIGHT_CODE ,
1995: sysdate,
1996: FND_GLOBAL.user_id,
1997: sysdate,
1998: FND_GLOBAL.user_id,
1999: P_LAST_UPDATE_LOGIN ,
2000: P_REQUEST_ID ,
2001: P_PROGRAM_APPLICATION_ID,
2002: P_PROGRAM_ID ,

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

3564: l_history_rec.request_date := l_sysdate;
3565: l_history_rec.creation_date := l_sysdate;
3566: l_history_rec.last_update_date := l_sysdate;
3567:
3568: l_history_rec.request_user_id := fnd_global.user_id;
3569: l_history_rec.created_by := fnd_global.user_id;
3570: l_history_rec.last_updated_by := fnd_global.user_id;
3571:
3572: IF (l_debug = 1) THEN

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

3565: l_history_rec.creation_date := l_sysdate;
3566: l_history_rec.last_update_date := l_sysdate;
3567:
3568: l_history_rec.request_user_id := fnd_global.user_id;
3569: l_history_rec.created_by := fnd_global.user_id;
3570: l_history_rec.last_updated_by := fnd_global.user_id;
3571:
3572: IF (l_debug = 1) THEN
3573: trace('Set original request ID='||l_history_rec.original_request_id,TRACE_PROMPT, TRACE_LEVEL);

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

3566: l_history_rec.last_update_date := l_sysdate;
3567:
3568: l_history_rec.request_user_id := fnd_global.user_id;
3569: l_history_rec.created_by := fnd_global.user_id;
3570: l_history_rec.last_updated_by := fnd_global.user_id;
3571:
3572: IF (l_debug = 1) THEN
3573: trace('Set original request ID='||l_history_rec.original_request_id,TRACE_PROMPT, TRACE_LEVEL);
3574: trace('Set new label_request_id='||l_history_rec.label_request_id, TRACE_PROMPT, TRACE_LEVEL);