[Home] [Help]
243:
244: -- Deleted the IF condition around the call to the
245: -- WSH_REPORT_PRINTERS_PVT.GET_PRINTER() as part of cleanup since irrespective of
246: -- the fact that a default format is defined or not the printer has to be derived.
247: -- The format can also be derived in the individual label API's(INVLAP*B.pls) via
248: -- the rules engine anyways. Moreover the default printer is defined based on the
249: -- document (label type in this case and not on the format)
250:
251: --Get default printer
396:
397: -- Deleted the IF condition around the call to the
398: -- WSH_REPORT_PRINTERS_PVT.GET_PRINTER() as part of cleanup since irrespective of
399: -- the fact that a default format is defined or not the printer has to be derived.
400: -- The format can also be derived in the individual label API's(INVLAP*B.pls) via
401: -- the rules engine anyways. Moreover the default printer is defined based on the
402: -- document (label type in this case and not on the format)
403:
404: -- Get default printer
828: l_time VARCHAR2(20);
829: BEGIN
830: -- Get Sysdate in Date/Time
831: SELECT to_char(sysdate, G_DATE_FORMAT_MASK), to_char(sysdate, 'HH24:MI:SS')
832: INTO l_date, l_time FROM dual;
833:
834: -- Set the global variables
835: G_DATE := l_date;
836: G_TIME := l_time;
1186:
1187:
1188: /*****************************************************
1189: * API to get the label fields defined for a specific
1190: * format. This get called from the individual label
1191: * API's often.
1192: *****************************************************/
1193: PROCEDURE GET_VARIABLES_FOR_FORMAT(
1194: x_variables OUT NOCOPY label_field_variable_tbl_type
1846: trace(' **Supplier ID : ' || P_SUPPLIER_ID, TRACE_PROMPT, TRACE_LEVEL);
1847: trace(' **Supplier Site ID : ' || P_SUPPLIER_SITE_ID, TRACE_PROMPT, TRACE_LEVEL);
1848: END IF;
1849:
1850: SELECT wms_label_print_history_s.nextval into l_label_request_id from dual;
1851: x_label_request_id := l_label_request_id;
1852:
1853: trace(' **Label Request ID : ' || l_label_request_id, TRACE_PROMPT, TRACE_LEVEL);
1854:
2006:
2007: -- Added this as part of the fix for Bug 2810264. The Rules Engine is called only for WMS enabled Orgs.
2008: -- Earlier, in case of MSCA Orgs, the GET_FORMAT_WITH_RULE would return a null label_format_id.
2009: -- In this fix, for MSCA Orgs, the default format ID and default foamrat name is derived and passed back.
2010: -- This change only needs to be done in the main package while the individual label API's remain
2011: -- untouched.
2012: -- Get default format
2013: get_default_format
2014: ( p_label_type_id => P_DOCUMENT_ID,
2745:
2746: -- Added for R12 RFID Compliance project
2747: -- Set value for global variable EPC_GROUP_ID
2748: -- The value will be set to null at the end of label printing code
2749: SELECT WMS_EPC_S2.nextval INTO EPC_GROUP_ID FROM DUAL;
2750: IF (l_debug = 1) THEN
2751: trace(' Set EPC_GROUP_ID = '||EPC_GROUP_ID, TRACE_PROMPT, TRACE_LEVEL);
2752: END IF;
2753:
3486: END IF;
3487: -- populate original request id and get new label_request_id;
3488: l_history_rec.original_request_id := p_hist_label_request_id;
3489: select wms_label_print_history_s.nextval into l_history_rec.label_request_id
3490: from dual;
3491: select sysdate into l_sysdate from dual;
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;
3487: -- populate original request id and get new label_request_id;
3488: l_history_rec.original_request_id := p_hist_label_request_id;
3489: select wms_label_print_history_s.nextval into l_history_rec.label_request_id
3490: from dual;
3491: select sysdate into l_sysdate from dual;
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: