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.GML_RCV_DIR_RCPT_APIS dependencies on GML_RCV_STD_RCPT_APIS

Line 7: (p_rcv_transaction_rec IN OUT NOCOPY gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp,

3:
4: g_interface_transaction_id NUMBER;
5:
6: PROCEDURE populate_default_values
7: (p_rcv_transaction_rec IN OUT NOCOPY gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp,
8: p_rcv_rcpt_rec IN OUT NOCOPY gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp,
9: p_group_id IN NUMBER,
10: p_organization_id IN NUMBER,
11: p_item_id IN NUMBER,

Line 8: p_rcv_rcpt_rec IN OUT NOCOPY gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp,

4: g_interface_transaction_id NUMBER;
5:
6: PROCEDURE populate_default_values
7: (p_rcv_transaction_rec IN OUT NOCOPY gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp,
8: p_rcv_rcpt_rec IN OUT NOCOPY gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp,
9: p_group_id IN NUMBER,
10: p_organization_id IN NUMBER,
11: p_item_id IN NUMBER,
12: p_revision IN VARCHAR2,

Line 79: l_interface_transaction_id := gml_rcv_std_rcpt_apis.insert_txn_interface

75:
76: p_rcv_transaction_rec.item_revision := p_revision;
77: p_rcv_rcpt_rec.item_revision := p_revision;
78:
79: l_interface_transaction_id := gml_rcv_std_rcpt_apis.insert_txn_interface
80: (p_rcv_transaction_rec,
81: p_rcv_rcpt_rec,
82: p_group_id,
83: l_transaction_type,

Line 123: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

119: x_status OUT NOCOPY VARCHAR2,
120: x_message OUT NOCOPY VARCHAR2)
121: IS
122: l_rcpt_match_table_detail GML_RCV_TXN_INTERFACE.cascaded_trans_tab_type; -- output for matching algorithm
123: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
124:
125: l_transaction_type VARCHAR2(20) := 'DELIVER';
126: l_total_primary_qty NUMBER := 0;
127:

Line 132: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

128: l_msg_count NUMBER;
129: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
130:
131: l_group_id NUMBER;
132: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
133:
134: l_err_message VARCHAR2(100);
135: l_temp_message VARCHAR2(100);
136: l_msg_prod VARCHAR2(5);

Line 376: x_cascaded_table => gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross,

372: gml_rcv_txn_interface.matching_logic
373: (x_return_status => x_status,
374: x_msg_count => l_msg_count,
375: x_msg_data => x_message,
376: x_cascaded_table => gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
377: n => gml_rcv_std_rcpt_apis.g_receipt_detail_index,
378: temp_cascaded_table => l_rcpt_match_table_detail,
379: p_receipt_num => NULL,
380: p_shipment_header_id => NULL,

Line 377: n => gml_rcv_std_rcpt_apis.g_receipt_detail_index,

373: (x_return_status => x_status,
374: x_msg_count => l_msg_count,
375: x_msg_data => x_message,
376: x_cascaded_table => gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
377: n => gml_rcv_std_rcpt_apis.g_receipt_detail_index,
378: temp_cascaded_table => l_rcpt_match_table_detail,
379: p_receipt_num => NULL,
380: p_shipment_header_id => NULL,
381: p_lpn_id => NULL

Line 575: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

571: IS
572:
573: l_rcpt_match_table_detail GML_RCV_TXN_INTERFACE.cascaded_trans_tab_type; -- output for matching algorithm
574:
575: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
576:
577: l_transaction_type VARCHAR2(20) := 'DELIVER';
578: l_total_primary_qty NUMBER := 0;
579:

Line 584: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

580: l_msg_count NUMBER;
581: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
582:
583: l_group_id NUMBER;
584: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
585: --l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
586:
587: l_err_message VARCHAR2(100);
588: l_temp_message VARCHAR2(100);

Line 779: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

775: END IF;
776:
777: l_progress := '30';
778: -- initialize input record for matching algorithm
779: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
780: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
781: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
782:
783: -- OPM changes

Line 780: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

776:
777: l_progress := '30';
778: -- initialize input record for matching algorithm
779: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
780: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
781: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
782:
783: -- OPM changes
784: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_quantity := p_rcv_sec_qty;

Line 781: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;

777: l_progress := '30';
778: -- initialize input record for matching algorithm
779: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
780: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
781: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
782:
783: -- OPM changes
784: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_quantity := p_rcv_sec_qty;
785: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_unit_of_measure := p_rcv_sec_uom;

Line 784: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_quantity := p_rcv_sec_qty;

780: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
781: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
782:
783: -- OPM changes
784: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_quantity := p_rcv_sec_qty;
785: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_unit_of_measure := p_rcv_sec_uom;
786:
787: if p_inv_item_id is not null then -- p_item_id has substitute item id
788: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;

Line 785: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_unit_of_measure := p_rcv_sec_uom;

781: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
782:
783: -- OPM changes
784: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_quantity := p_rcv_sec_qty;
785: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_unit_of_measure := p_rcv_sec_uom;
786:
787: if p_inv_item_id is not null then -- p_item_id has substitute item id
788: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;
789: else

Line 788: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;

784: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_quantity := p_rcv_sec_qty;
785: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).secondary_unit_of_measure := p_rcv_sec_uom;
786:
787: if p_inv_item_id is not null then -- p_item_id has substitute item id
788: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;
789: else
790: IF p_item_id IS NOT NULL THEN
791: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
792: ELSE

Line 791: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

787: if p_inv_item_id is not null then -- p_item_id has substitute item id
788: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;
789: else
790: IF p_item_id IS NOT NULL THEN
791: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
792: ELSE
793: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
794: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
795: end if;

Line 793: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;

789: else
790: IF p_item_id IS NOT NULL THEN
791: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
792: ELSE
793: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
794: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
795: end if;
796: end if;
797:

Line 794: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;

790: IF p_item_id IS NOT NULL THEN
791: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
792: ELSE
793: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
794: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
795: end if;
796: end if;
797:
798: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;

Line 798: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;

794: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
795: end if;
796: end if;
797:
798: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
799: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
800: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
801: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
802:

Line 799: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;

795: end if;
796: end if;
797:
798: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
799: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
800: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
801: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
802:
803: -- line id, line location id and distribution id will be passed only from the putaway api.

Line 800: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;

796: end if;
797:
798: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
799: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
800: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
801: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
802:
803: -- line id, line location id and distribution id will be passed only from the putaway api.
804: -- line id however, can also be passed through the UI if the line number

Line 801: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;

797:
798: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
799: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
800: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
801: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
802:
803: -- line id, line location id and distribution id will be passed only from the putaway api.
804: -- line id however, can also be passed through the UI if the line number
805: -- field is enabled on the UI.

Line 806: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;

802:
803: -- line id, line location id and distribution id will be passed only from the putaway api.
804: -- line id however, can also be passed through the UI if the line number
805: -- field is enabled on the UI.
806: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;
807: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := p_po_line_location_id;
808: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;
809:
810: IF p_item_id IS NOT NULL THEN

Line 807: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := p_po_line_location_id;

803: -- line id, line location id and distribution id will be passed only from the putaway api.
804: -- line id however, can also be passed through the UI if the line number
805: -- field is enabled on the UI.
806: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;
807: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := p_po_line_location_id;
808: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;
809:
810: IF p_item_id IS NOT NULL THEN
811: BEGIN

Line 808: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;

804: -- line id however, can also be passed through the UI if the line number
805: -- field is enabled on the UI.
806: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;
807: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := p_po_line_location_id;
808: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;
809:
810: IF p_item_id IS NOT NULL THEN
811: BEGIN
812: select primary_unit_of_measure

Line 813: into gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

809:
810: IF p_item_id IS NOT NULL THEN
811: BEGIN
812: select primary_unit_of_measure
813: into gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
814: from mtl_system_items
815: where mtl_system_items.inventory_item_id = p_item_id
816: and mtl_system_items.organization_id = p_organization_id;
817: EXCEPTION

Line 823: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;

819: NULL;
820:
821: END;
822: ELSE
823: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
824: END IF;
825:
826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

Line 826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;

822: ELSE
823: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
824: END IF;
825:
826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

Line 827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

823: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
824: END IF;
825:
826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
831: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

Line 828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;

824: END IF;
825:
826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
831: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
832:

Line 829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?

825:
826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
831: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
832:
833:

Line 830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

826: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
831: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
832:
833:
834: l_progress := '40';

Line 831: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

827: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
828: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
829: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
830: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
831: gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
832:
833:
834: l_progress := '40';
835: --- OPM Specific version

Line 841: x_cascaded_table => gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross,

837: gml_rcv_txn_interface.matching_logic
838: (x_return_status => x_status,
839: x_msg_count => l_msg_count,
840: x_msg_data => x_message,
841: x_cascaded_table => gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
842: n => gml_rcv_std_rcpt_apis.g_receipt_detail_index,
843: temp_cascaded_table => l_rcpt_match_table_detail,
844: p_receipt_num => NULL,
845: p_shipment_header_id => NULL,

Line 842: n => gml_rcv_std_rcpt_apis.g_receipt_detail_index,

838: (x_return_status => x_status,
839: x_msg_count => l_msg_count,
840: x_msg_data => x_message,
841: x_cascaded_table => gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
842: n => gml_rcv_std_rcpt_apis.g_receipt_detail_index,
843: temp_cascaded_table => l_rcpt_match_table_detail,
844: p_receipt_num => NULL,
845: p_shipment_header_id => NULL,
846: p_lpn_id => NULL

Line 862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

858: FND_MSG_PUB.ADD;
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:
862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
863: l_err_message := gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
864: FND_MESSAGE.SET_NAME('INV', l_err_message);
865: FND_MSG_PUB.ADD;
866: RAISE fnd_api.g_exc_error;

Line 863: l_err_message := gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:
862: IF gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
863: l_err_message := gml_rcv_std_rcpt_apis.g_rcpt_match_table_gross(gml_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
864: FND_MESSAGE.SET_NAME('INV', l_err_message);
865: FND_MSG_PUB.ADD;
866: RAISE fnd_api.g_exc_error;
867: END IF;

Line 871: FOR i IN gml_rcv_std_rcpt_apis.g_receipt_detail_index..(gml_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

867: END IF;
868:
869:
870: l_err_message := '@@@';
871: FOR i IN gml_rcv_std_rcpt_apis.g_receipt_detail_index..(gml_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
872: IF l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
873: x_status := 'W';
874:
875: l_temp_message := l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;

Line 872: IF l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN

868:
869:
870: l_err_message := '@@@';
871: FOR i IN gml_rcv_std_rcpt_apis.g_receipt_detail_index..(gml_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
872: IF l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
873: x_status := 'W';
874:
875: l_temp_message := l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
876: IF l_temp_message IS NULL THEN

Line 875: l_temp_message := l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;

871: FOR i IN gml_rcv_std_rcpt_apis.g_receipt_detail_index..(gml_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
872: IF l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
873: x_status := 'W';
874:
875: l_temp_message := l_rcpt_match_table_detail(i-gml_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
876: IF l_temp_message IS NULL THEN
877: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
878: l_msg_prod := 'INV';
879: EXIT;

Line 1035: gml_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

1031: l_progress := '100';
1032:
1033: -- Clear the Lot Rec
1034: ---inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1035: gml_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1036:
1037:
1038: EXCEPTION
1039: WHEN fnd_api.g_exc_error THEN

Line 1112: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

1108: IS
1109:
1110: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
1111:
1112: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1113:
1114: l_transaction_type VARCHAR2(20) := 'DELIVER';
1115: l_total_primary_qty NUMBER := 0;
1116:

Line 1122: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

1118: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1119:
1120: l_group_id NUMBER;
1121:
1122: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
1123: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
1124:
1125: l_err_message VARCHAR2(100);
1126: l_temp_message VARCHAR2(100);

Line 1602: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

1598: IS
1599:
1600: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
1601:
1602: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1603:
1604: l_transaction_type VARCHAR2(20) := 'DELIVER';
1605: l_total_primary_qty NUMBER := 0;
1606:

Line 1612: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

1608: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1609:
1610: l_group_id NUMBER;
1611:
1612: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
1613: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
1614:
1615: l_err_message VARCHAR2(100);
1616: l_temp_message VARCHAR2(100);

Line 2030: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

2026: )
2027: IS
2028: l_rcpt_match_table_detail INV_RCV_COMMON_APIS.cascaded_trans_tab_type; -- output for matching algorithm
2029:
2030: l_rcv_transaction_rec gml_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2031:
2032: l_transaction_type VARCHAR2(20) := 'DELIVER';
2033: l_total_primary_qty NUMBER := 0;
2034: l_match_type VARCHAR2(20);

Line 2042: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

2038: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2039:
2040: l_group_id NUMBER;
2041:
2042: l_rcv_rcpt_rec gml_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
2043: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
2044:
2045: l_err_message VARCHAR2(100);
2046: l_temp_message VARCHAR2(100);