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 INV_LABEL

Line 1: PACKAGE BODY INV_LABEL AS

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);

Line 29: INV_LABEL_PVT3.g_lpn_id := -1;

25: * Clear global variables
26: *************************/
27: PROCEDURE CLEAR_GLOBALS IS
28: BEGIN
29: INV_LABEL_PVT3.g_lpn_id := -1;
30: INV_LABEL_PVT8.clear_carton_count;
31: END CLEAR_GLOBALS;
32:
33: /************************************

Line 30: INV_LABEL_PVT8.clear_carton_count;

26: *************************/
27: PROCEDURE CLEAR_GLOBALS IS
28: BEGIN
29: INV_LABEL_PVT3.g_lpn_id := -1;
30: INV_LABEL_PVT8.clear_carton_count;
31: END CLEAR_GLOBALS;
32:
33: /************************************
34: * Get numbers between a range

Line 183: IF ((p_business_flow = inv_label.WMS_BF_RECEIPT) OR (p_business_flow = inv_label.WMS_BF_INSPECTION) OR

179: IF ((l_org_id IS NULL) OR (TRIM(l_org_id) = '' )) THEN
180:
181: trace('Org id from the profile MFG_ORGANIZATION_ID is null', TRACE_PROMPT,TRACE_LEVEL);
182:
183: IF ((p_business_flow = inv_label.WMS_BF_RECEIPT) OR (p_business_flow = inv_label.WMS_BF_INSPECTION) OR
184: (p_business_flow = inv_label.WMS_BF_DELIVERY) OR (p_business_flow = inv_label.WMS_BF_PUTAWAY_DROP)) THEN
185:
186: trace('Business Flow in RECEIPT/INSPECTION/DELIVERY/PUTAWAY_DROP', TRACE_PROMPT,TRACE_LEVEL);
187:

Line 184: (p_business_flow = inv_label.WMS_BF_DELIVERY) OR (p_business_flow = inv_label.WMS_BF_PUTAWAY_DROP)) THEN

180:
181: trace('Org id from the profile MFG_ORGANIZATION_ID is null', TRACE_PROMPT,TRACE_LEVEL);
182:
183: IF ((p_business_flow = inv_label.WMS_BF_RECEIPT) OR (p_business_flow = inv_label.WMS_BF_INSPECTION) OR
184: (p_business_flow = inv_label.WMS_BF_DELIVERY) OR (p_business_flow = inv_label.WMS_BF_PUTAWAY_DROP)) THEN
185:
186: trace('Business Flow in RECEIPT/INSPECTION/DELIVERY/PUTAWAY_DROP', TRACE_PROMPT,TRACE_LEVEL);
187:
188: SELECT ORGANIZATION_ID

Line 194: ELSIF (p_business_flow = inv_label.WMS_BF_IMPORT_ASN) THEN

190: FROM RCV_TRANSACTIONS
191: WHERE GROUP_ID = p_transaction_id(1)
192: AND ROWNUM=1;
193:
194: ELSIF (p_business_flow = inv_label.WMS_BF_IMPORT_ASN) THEN
195:
196: trace('Business Flow in IMPORT_ASN', TRACE_PROMPT,TRACE_LEVEL);
197:
198: SELECT ORGANIZATION_ID

Line 512: INV_LABEL_PVT1.get_variable_data(

508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: IF p_label_type_info.label_type_id = 1 THEN
511: BEGIN
512: INV_LABEL_PVT1.get_variable_data(
513: x_variable_content => x_variable_content
514: ,x_msg_count => x_msg_count
515: ,x_msg_data => x_msg_data
516: ,x_return_status => x_return_status

Line 536: INV_LABEL_PVT2.get_variable_data(

532: END;
533:
534: ELSIF p_label_type_info.label_type_id = 2 THEN
535: BEGIN
536: INV_LABEL_PVT2.get_variable_data(
537: x_variable_content => x_variable_content
538: ,x_msg_count => x_msg_count
539: ,x_msg_data => x_msg_data
540: ,x_return_status => x_return_status

Line 560: INV_LABEL_PVT3.get_variable_data(

556: END;
557:
558: ELSIF p_label_type_info.label_type_id = 3 THEN
559: BEGIN
560: INV_LABEL_PVT3.get_variable_data(
561: x_variable_content => x_variable_content
562: ,x_msg_count => x_msg_count
563: ,x_msg_data => x_msg_data
564: ,x_return_status => x_return_status

Line 584: INV_LABEL_PVT4.get_variable_data(

580: END;
581:
582: ELSIF p_label_type_info.label_type_id = 4 THEN
583: BEGIN
584: INV_LABEL_PVT4.get_variable_data(
585: x_variable_content => x_variable_content
586: ,x_msg_count => x_msg_count
587: ,x_msg_data => x_msg_data
588: ,x_return_status => x_return_status

Line 608: INV_LABEL_PVT5.get_variable_data(

604: END;
605:
606: ELSIF p_label_type_info.label_type_id = 5 THEN
607: BEGIN
608: INV_LABEL_PVT5.get_variable_data(
609: x_variable_content => x_variable_content
610: ,x_msg_count => x_msg_count
611: ,x_msg_data => x_msg_data
612: ,x_return_status => x_return_status

Line 632: INV_LABEL_PVT6.get_variable_data(

628: END;
629:
630: ELSIF p_label_type_info.label_type_id = 6 THEN
631: BEGIN
632: INV_LABEL_PVT6.get_variable_data(
633: x_variable_content => x_variable_content
634: ,x_msg_count => x_msg_count
635: ,x_msg_data => x_msg_data
636: ,x_return_status => x_return_status

Line 656: INV_LABEL_PVT7.get_variable_data(

652: END;
653:
654: ELSIF p_label_type_info.label_type_id = 7 THEN
655: BEGIN
656: INV_LABEL_PVT7.get_variable_data(
657: x_variable_content => x_variable_content
658: ,x_msg_count => x_msg_count
659: ,x_msg_data => x_msg_data
660: ,x_return_status => x_return_status

Line 680: INV_LABEL_PVT8.get_variable_data(

676: END;
677:
678: ELSIF p_label_type_info.label_type_id = 8 THEN
679: BEGIN
680: INV_LABEL_PVT8.get_variable_data(
681: x_variable_content => x_variable_content
682: ,x_msg_count => x_msg_count
683: ,x_msg_data => x_msg_data
684: ,x_return_status => x_return_status

Line 704: INV_LABEL_PVT9.get_variable_data(

700: END;
701:
702: ELSIF p_label_type_info.label_type_id = 9 THEN
703: BEGIN
704: INV_LABEL_PVT9.get_variable_data(
705: x_variable_content => x_variable_content
706: ,x_msg_count => x_msg_count
707: ,x_msg_data => x_msg_data
708: ,x_return_status => x_return_status

Line 728: INV_LABEL_PVT10.get_variable_data(

724: END;
725:
726: ELSIF p_label_type_info.label_type_id = 10 THEN
727: BEGIN
728: INV_LABEL_PVT10.get_variable_data(
729: x_variable_content => x_variable_content
730: ,x_msg_count => x_msg_count
731: ,x_msg_data => x_msg_data
732: ,x_return_status => x_return_status

Line 753: INV_LABEL_PVT11.get_variable_data(

749:
750: -- fabdi GMO changes start
751: ELSIF p_label_type_info.label_type_id in (11,12) THEN
752: BEGIN
753: INV_LABEL_PVT11.get_variable_data(
754: x_variable_content => x_variable_content
755: ,x_msg_count => x_msg_count
756: ,x_msg_data => x_msg_data
757: ,x_return_status => x_return_status

Line 777: INV_LABEL_PVT13.get_variable_data(

773: END;
774:
775: ELSIF p_label_type_info.label_type_id IN (13,14) THEN
776: BEGIN
777: INV_LABEL_PVT13.get_variable_data(
778: x_variable_content => x_variable_content
779: ,x_msg_count => x_msg_count
780: ,x_msg_data => x_msg_data
781: ,x_return_status => x_return_status

Line 801: INV_LABEL_PVT15.get_variable_data(

797: END;
798:
799: ELSIF p_label_type_info.label_type_id = 15 THEN
800: BEGIN
801: INV_LABEL_PVT15.get_variable_data(
802: x_variable_content => x_variable_content
803: ,x_msg_count => x_msg_count
804: ,x_msg_data => x_msg_data
805: ,x_return_status => x_return_status

Line 827: INV_LABEL_PVT16.get_variable_data(

823:
824: -- hjogleka, Bug #6417575, Label Printing Support for WIP Move Transactions (12.1)
825: ELSIF p_label_type_info.label_type_id = 16 THEN
826: BEGIN
827: INV_LABEL_PVT16.get_variable_data(
828: x_variable_content => x_variable_content
829: ,x_msg_count => x_msg_count
830: ,x_msg_data => x_msg_data
831: ,x_return_status => x_return_status

Line 2189: l_transaction_id INV_LABEL.transaction_id_rec_type;

2185: l_msg_count NUMBER;
2186: l_msg_data VARCHAR2(240);
2187: l_no_of_copies NUMBER :=1;
2188: l_label_status varchar2(300);
2189: l_transaction_id INV_LABEL.transaction_id_rec_type;
2190: l_transaction_identifier NUMBER ;
2191:
2192: BEGIN
2193: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2218: inv_label.print_label(

2214: trace('Business Code 35. Set transaction_identifier to 1 ' , TRACE_PROMPT, TRACE_LEVEL);
2215: END IF;
2216: END IF;
2217:
2218: inv_label.print_label(
2219: x_return_status => x_return_status
2220: , x_msg_count => x_msg_count
2221: , x_msg_data => x_msg_data
2222: , x_label_status => x_label_status

Line 2321: -- It will be read in get_variable_data of INV_LABEL_PVT2 and INV_LABEL_PVT9

2317: l_input_param(i).transaction_uom := p_uom;
2318:
2319: --hjogleka, Bug #6417575,Label Printing Support for WIP Move Transactions (12.1)
2320: -- populate transaction_source_id with wip_entity_id.
2321: -- It will be read in get_variable_data of INV_LABEL_PVT2 and INV_LABEL_PVT9
2322: l_input_param(i).transaction_source_id := p_wip_entity_id;
2323:
2324: IF (l_debug = 1) THEN
2325: trace('**Values to parameters passed to the PRINT_LABEL_MANUAL_WRAP',TRACE_PROMPT, TRACE_LEVEL);

Line 2505: inv_label.print_label(

2501: l_input_param(i).transaction_temp_id := l_wip_entity_id;
2502: l_schedule_number := l_schedule_number + i;
2503: END LOOP;
2504: END IF ;
2505: inv_label.print_label(
2506: x_return_status => x_return_status
2507: ,x_msg_count => x_msg_count
2508: ,x_msg_data => x_msg_data
2509: ,x_label_status => x_label_status

Line 2805: --INV_LABEL_PVT8.g_carton_table := p_transaction_id;

2801:
2802: /*Fix for bug 3858504. For cartonization we will store
2803: the table of LPN IDs for shipping content label */
2804: IF p_business_flow_code = 22 THEN
2805: --INV_LABEL_PVT8.g_carton_table := p_transaction_id;
2806: -- 4645826, call set_carton_count to count the total number of cartons for delivery
2807: -- Pick release can be run for multiple deliveries
2808: -- The count of p_transaction_id can be for multiple deliveries
2809: -- Need to count the total for each delivery

Line 2811: INV_LABEL_PVT8.set_carton_count(p_transaction_id(i));

2807: -- Pick release can be run for multiple deliveries
2808: -- The count of p_transaction_id can be for multiple deliveries
2809: -- Need to count the total for each delivery
2810: FOR i IN 1..p_transaction_id.count LOOP
2811: INV_LABEL_PVT8.set_carton_count(p_transaction_id(i));
2812: END LOOP;
2813: END IF; --End of Fix for bug 3858504.
2814:
2815:

Line 3751: PROCEDURE INV_LABEL_REQUESTS_REPRINT (

3747:
3748: /*************************************
3749: * Obtain Label Request Print Hist
3750: *************************************/
3751: PROCEDURE INV_LABEL_REQUESTS_REPRINT (
3752: x_label_rep_hist_inqs OUT NOCOPY t_genref,
3753: p_printer_Name IN VARCHAR2,
3754: p_bus_flow_Code IN NUMBER,
3755: p_label_type_Id IN NUMBER,

Line 3819: END INV_LABEL_REQUESTS_REPRINT;

3815: WHEN others THEN
3816: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3817: x_Message := 'Selection Criteria Returned No Records';
3818:
3819: END INV_LABEL_REQUESTS_REPRINT;
3820:
3821:
3822: -- Bug #3067059
3823: /**************************************

Line 4202: END INV_LABEL;

4198: RETURN l_return_status_code;
4199: END get_txn_lpn_status ;
4200:
4201:
4202: END INV_LABEL;