DBA Data[Home] [Help]

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

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 476: INV_LABEL_PVT1.get_variable_data(

472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: IF p_label_type_info.label_type_id = 1 THEN
475: BEGIN
476: INV_LABEL_PVT1.get_variable_data(
477: x_variable_content => x_variable_content
478: ,x_msg_count => x_msg_count
479: ,x_msg_data => x_msg_data
480: ,x_return_status => x_return_status

Line 500: INV_LABEL_PVT2.get_variable_data(

496: END;
497:
498: ELSIF p_label_type_info.label_type_id = 2 THEN
499: BEGIN
500: INV_LABEL_PVT2.get_variable_data(
501: x_variable_content => x_variable_content
502: ,x_msg_count => x_msg_count
503: ,x_msg_data => x_msg_data
504: ,x_return_status => x_return_status

Line 524: INV_LABEL_PVT3.get_variable_data(

520: END;
521:
522: ELSIF p_label_type_info.label_type_id = 3 THEN
523: BEGIN
524: INV_LABEL_PVT3.get_variable_data(
525: x_variable_content => x_variable_content
526: ,x_msg_count => x_msg_count
527: ,x_msg_data => x_msg_data
528: ,x_return_status => x_return_status

Line 548: INV_LABEL_PVT4.get_variable_data(

544: END;
545:
546: ELSIF p_label_type_info.label_type_id = 4 THEN
547: BEGIN
548: INV_LABEL_PVT4.get_variable_data(
549: x_variable_content => x_variable_content
550: ,x_msg_count => x_msg_count
551: ,x_msg_data => x_msg_data
552: ,x_return_status => x_return_status

Line 572: INV_LABEL_PVT5.get_variable_data(

568: END;
569:
570: ELSIF p_label_type_info.label_type_id = 5 THEN
571: BEGIN
572: INV_LABEL_PVT5.get_variable_data(
573: x_variable_content => x_variable_content
574: ,x_msg_count => x_msg_count
575: ,x_msg_data => x_msg_data
576: ,x_return_status => x_return_status

Line 596: INV_LABEL_PVT6.get_variable_data(

592: END;
593:
594: ELSIF p_label_type_info.label_type_id = 6 THEN
595: BEGIN
596: INV_LABEL_PVT6.get_variable_data(
597: x_variable_content => x_variable_content
598: ,x_msg_count => x_msg_count
599: ,x_msg_data => x_msg_data
600: ,x_return_status => x_return_status

Line 620: INV_LABEL_PVT7.get_variable_data(

616: END;
617:
618: ELSIF p_label_type_info.label_type_id = 7 THEN
619: BEGIN
620: INV_LABEL_PVT7.get_variable_data(
621: x_variable_content => x_variable_content
622: ,x_msg_count => x_msg_count
623: ,x_msg_data => x_msg_data
624: ,x_return_status => x_return_status

Line 644: INV_LABEL_PVT8.get_variable_data(

640: END;
641:
642: ELSIF p_label_type_info.label_type_id = 8 THEN
643: BEGIN
644: INV_LABEL_PVT8.get_variable_data(
645: x_variable_content => x_variable_content
646: ,x_msg_count => x_msg_count
647: ,x_msg_data => x_msg_data
648: ,x_return_status => x_return_status

Line 668: INV_LABEL_PVT9.get_variable_data(

664: END;
665:
666: ELSIF p_label_type_info.label_type_id = 9 THEN
667: BEGIN
668: INV_LABEL_PVT9.get_variable_data(
669: x_variable_content => x_variable_content
670: ,x_msg_count => x_msg_count
671: ,x_msg_data => x_msg_data
672: ,x_return_status => x_return_status

Line 692: INV_LABEL_PVT10.get_variable_data(

688: END;
689:
690: ELSIF p_label_type_info.label_type_id = 10 THEN
691: BEGIN
692: INV_LABEL_PVT10.get_variable_data(
693: x_variable_content => x_variable_content
694: ,x_msg_count => x_msg_count
695: ,x_msg_data => x_msg_data
696: ,x_return_status => x_return_status

Line 717: INV_LABEL_PVT11.get_variable_data(

713:
714: -- fabdi GMO changes start
715: ELSIF p_label_type_info.label_type_id in (11,12) THEN
716: BEGIN
717: INV_LABEL_PVT11.get_variable_data(
718: x_variable_content => x_variable_content
719: ,x_msg_count => x_msg_count
720: ,x_msg_data => x_msg_data
721: ,x_return_status => x_return_status

Line 741: INV_LABEL_PVT13.get_variable_data(

737: END;
738:
739: ELSIF p_label_type_info.label_type_id IN (13,14) THEN
740: BEGIN
741: INV_LABEL_PVT13.get_variable_data(
742: x_variable_content => x_variable_content
743: ,x_msg_count => x_msg_count
744: ,x_msg_data => x_msg_data
745: ,x_return_status => x_return_status

Line 765: INV_LABEL_PVT15.get_variable_data(

761: END;
762:
763: ELSIF p_label_type_info.label_type_id = 15 THEN
764: BEGIN
765: INV_LABEL_PVT15.get_variable_data(
766: x_variable_content => x_variable_content
767: ,x_msg_count => x_msg_count
768: ,x_msg_data => x_msg_data
769: ,x_return_status => x_return_status

Line 791: INV_LABEL_PVT16.get_variable_data(

787:
788: -- hjogleka, Bug #6417575, Label Printing Support for WIP Move Transactions (12.1)
789: ELSIF p_label_type_info.label_type_id = 16 THEN
790: BEGIN
791: INV_LABEL_PVT16.get_variable_data(
792: x_variable_content => x_variable_content
793: ,x_msg_count => x_msg_count
794: ,x_msg_data => x_msg_data
795: ,x_return_status => x_return_status

Line 2128: l_transaction_id INV_LABEL.transaction_id_rec_type;

2124: l_msg_count NUMBER;
2125: l_msg_data VARCHAR2(240);
2126: l_no_of_copies NUMBER :=1;
2127: l_label_status varchar2(300);
2128: l_transaction_id INV_LABEL.transaction_id_rec_type;
2129: l_transaction_identifier NUMBER ;
2130:
2131: BEGIN
2132: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2157: inv_label.print_label(

2153: trace('Business Code 35. Set transaction_identifier to 1 ' , TRACE_PROMPT, TRACE_LEVEL);
2154: END IF;
2155: END IF;
2156:
2157: inv_label.print_label(
2158: x_return_status => x_return_status
2159: , x_msg_count => x_msg_count
2160: , x_msg_data => x_msg_data
2161: , x_label_status => x_label_status

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

2255: l_input_param(i).transaction_uom := p_uom;
2256:
2257: --hjogleka, Bug #6417575,Label Printing Support for WIP Move Transactions (12.1)
2258: -- populate transaction_source_id with wip_entity_id.
2259: -- It will be read in get_variable_data of INV_LABEL_PVT2 and INV_LABEL_PVT9
2260: l_input_param(i).transaction_source_id := p_wip_entity_id;
2261:
2262: IF (l_debug = 1) THEN
2263: trace('**Values to parameters passed to the PRINT_LABEL_MANUAL_WRAP',TRACE_PROMPT, TRACE_LEVEL);

Line 2436: inv_label.print_label(

2432: l_input_param(i).transaction_temp_id := l_wip_entity_id;
2433: l_schedule_number := l_schedule_number + i;
2434: END LOOP;
2435: END IF ;
2436: inv_label.print_label(
2437: x_return_status => x_return_status
2438: ,x_msg_count => x_msg_count
2439: ,x_msg_data => x_msg_data
2440: ,x_label_status => x_label_status

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

2731:
2732: /*Fix for bug 3858504. For cartonization we will store
2733: the table of LPN IDs for shipping content label */
2734: IF p_business_flow_code = 22 THEN
2735: --INV_LABEL_PVT8.g_carton_table := p_transaction_id;
2736: -- 4645826, call set_carton_count to count the total number of cartons for delivery
2737: -- Pick release can be run for multiple deliveries
2738: -- The count of p_transaction_id can be for multiple deliveries
2739: -- Need to count the total for each delivery

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

2737: -- Pick release can be run for multiple deliveries
2738: -- The count of p_transaction_id can be for multiple deliveries
2739: -- Need to count the total for each delivery
2740: FOR i IN 1..p_transaction_id.count LOOP
2741: INV_LABEL_PVT8.set_carton_count(p_transaction_id(i));
2742: END LOOP;
2743: END IF; --End of Fix for bug 3858504.
2744:
2745:

Line 3678: PROCEDURE INV_LABEL_REQUESTS_REPRINT (

3674:
3675: /*************************************
3676: * Obtain Label Request Print Hist
3677: *************************************/
3678: PROCEDURE INV_LABEL_REQUESTS_REPRINT (
3679: x_label_rep_hist_inqs OUT NOCOPY t_genref,
3680: p_printer_Name IN VARCHAR2,
3681: p_bus_flow_Code IN NUMBER,
3682: p_label_type_Id IN NUMBER,

Line 3746: END INV_LABEL_REQUESTS_REPRINT;

3742: WHEN others THEN
3743: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3744: x_Message := 'Selection Criteria Returned No Records';
3745:
3746: END INV_LABEL_REQUESTS_REPRINT;
3747:
3748:
3749: -- Bug #3067059
3750: /**************************************

Line 4103: END INV_LABEL;

4099: RETURN l_return_status_code;
4100: END get_txn_lpn_status ;
4101:
4102:
4103: END INV_LABEL;