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_RCV_DIR_RCPT_APIS dependencies on INV_RCV_STD_RCPT_APIS

Line 16: p_rcv_transaction_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp

12: END IF;
13: END print_debug;
14:
15: PROCEDURE populate_default_values(
16: p_rcv_transaction_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp
17: , p_rcv_rcpt_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp
18: , p_group_id IN NUMBER
19: , p_organization_id IN NUMBER
20: , p_item_id IN NUMBER

Line 17: , p_rcv_rcpt_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp

13: END print_debug;
14:
15: PROCEDURE populate_default_values(
16: p_rcv_transaction_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp
17: , p_rcv_rcpt_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp
18: , p_group_id IN NUMBER
19: , p_organization_id IN NUMBER
20: , p_item_id IN NUMBER
21: , p_revision IN VARCHAR2

Line 102: 'populate_default_values: 3 - before inv_rcv_std_rcpt_apis.insert_txn_interface '

98: p_rcv_rcpt_rec.item_revision := p_revision;
99:
100: IF (l_debug = 1) THEN
101: print_debug(
102: 'populate_default_values: 3 - before inv_rcv_std_rcpt_apis.insert_txn_interface '
103: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
104: , 4
105: );
106: END IF;

Line 109: inv_rcv_std_rcpt_apis.insert_txn_interface(

105: );
106: END IF;
107:
108: l_interface_transaction_id :=
109: inv_rcv_std_rcpt_apis.insert_txn_interface(
110: p_rcv_transaction_rec
111: , p_rcv_rcpt_rec
112: , p_group_id
113: , l_transaction_type

Line 127: 'populate_default_values: 4 - after inv_rcv_std_rcpt_apis.insert_txn_interface ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

123: g_interface_transaction_id := l_interface_transaction_id;
124:
125: IF (l_debug = 1) THEN
126: print_debug(
127: 'populate_default_values: 4 - after inv_rcv_std_rcpt_apis.insert_txn_interface ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
128: , 4
129: );
130: print_debug('populate_default_values: 4.1 - l_interface_transaction_id = ' || l_interface_transaction_id, 4);
131: END IF;

Line 178: p_rcv_rcpt_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp

174: * and attributes 1-15 columns of the enter receipts record type
175: * with the values passed from the Mobile Receipt UI
176: */
177: PROCEDURE set_attribute_vals (
178: p_rcv_rcpt_rec IN OUT NOCOPY inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp
179: , p_attribute_category IN VARCHAR2 DEFAULT NULL
180: , p_attribute1 IN VARCHAR2 DEFAULT NULL
181: , p_attribute2 IN VARCHAR2 DEFAULT NULL
182: , p_attribute3 IN VARCHAR2 DEFAULT NULL

Line 249: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

245: , p_attribute14 IN VARCHAR2 DEFAULT NULL
246: , p_attribute15 IN VARCHAR2 DEFAULT NULL
247: ) IS
248: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
249: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
250: l_transaction_type VARCHAR2(20) := 'DELIVER';
251: l_total_primary_qty NUMBER := 0;
252: l_msg_count NUMBER;
253: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 255: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

251: l_total_primary_qty NUMBER := 0;
252: l_msg_count NUMBER;
253: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
254: l_group_id NUMBER;
255: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
256: l_err_message VARCHAR2(100);
257: l_temp_message VARCHAR2(100);
258: l_msg_prod VARCHAR2(5);
259: l_progress VARCHAR2(10);

Line 472: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

468: -- bug 2743146
469: -- Make sure that the po_distribution passed does satisfy the tolerance
470: -- limits by calling the matching algorithm for that.
471: -- initialize input record for matching algorithm
472: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
473: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

Line 473: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

469: -- Make sure that the po_distribution passed does satisfy the tolerance
470: -- limits by calling the matching algorithm for that.
471: -- initialize input record for matching algorithm
472: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
473: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;

Line 474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;

470: -- limits by calling the matching algorithm for that.
471: -- initialize input record for matching algorithm
472: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
473: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;
478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;

Line 475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

471: -- initialize input record for matching algorithm
472: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
473: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;
478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;

Line 476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

472: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
473: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;
478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
480: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;

Line 478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;

474: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;
478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
480: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
481: -- line id, line location id and distribution id will be passed only from the putaway api.
482: -- line id however, can also be passed through the UI if the line number

Line 479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;

475: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;
478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
480: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
481: -- line id, line location id and distribution id will be passed only from the putaway api.
482: -- line id however, can also be passed through the UI if the line number
483: -- field is enabled on the UI.

Line 480: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;

476: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
477: p_organization_id;
478: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
480: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
481: -- line id, line location id and distribution id will be passed only from the putaway api.
482: -- line id however, can also be passed through the UI if the line number
483: -- field is enabled on the UI.
484: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id :=

Line 484: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id :=

480: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
481: -- line id, line location id and distribution id will be passed only from the putaway api.
482: -- line id however, can also be passed through the UI if the line number
483: -- field is enabled on the UI.
484: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id :=
485: l_rcv_rcpt_rec.po_line_id;
486: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=
487: l_rcv_rcpt_rec.po_line_location_id;
488: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=

Line 486: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=

482: -- line id however, can also be passed through the UI if the line number
483: -- field is enabled on the UI.
484: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id :=
485: l_rcv_rcpt_rec.po_line_id;
486: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=
487: l_rcv_rcpt_rec.po_line_location_id;
488: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=
489: p_po_distribution_id;
490:

Line 488: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=

484: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id :=
485: l_rcv_rcpt_rec.po_line_id;
486: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=
487: l_rcv_rcpt_rec.po_line_location_id;
488: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=
489: p_po_distribution_id;
490:
491: IF p_item_id IS NOT NULL THEN
492: BEGIN

Line 494: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

490:
491: IF p_item_id IS NOT NULL THEN
492: BEGIN
493: SELECT primary_unit_of_measure
494: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
495: FROM mtl_system_items
496: WHERE mtl_system_items.inventory_item_id = p_item_id
497: AND mtl_system_items.organization_id = p_organization_id;
498: EXCEPTION

Line 507: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;

503: print_debug('create_osp_drct_dlvr_rti_rec: 3 - get primary_unit_of_measure exception', 4);
504: END IF;
505: END;
506: ELSE
507: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
508: END IF;
509:
510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

Line 510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;

506: ELSE
507: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
508: END IF;
509:
510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

Line 511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

507: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
508: END IF;
509:
510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
515: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

Line 512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;

508: END IF;
509:
510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
515: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
516:

Line 513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?

509:
510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
515: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
516:
517: IF (l_debug = 1) THEN

Line 514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

510: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
515: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
516:
517: IF (l_debug = 1) THEN
518: print_debug(

Line 515: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

511: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
512: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
513: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
514: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
515: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
516:
517: IF (l_debug = 1) THEN
518: print_debug(
519: 'create_osp_drct_dlvr_rti_rec: 4 - before inv_rcv_txn_interface.matching_logic' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 529: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross

525: inv_rcv_txn_interface.matching_logic(
526: x_return_status => x_status
527: , x_msg_count => l_msg_count
528: , x_msg_data => x_message
529: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
530: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
531: , temp_cascaded_table => l_rcpt_match_table_detail
532: , p_receipt_num => NULL
533: , p_shipment_header_id => NULL

Line 530: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index

526: x_return_status => x_status
527: , x_msg_count => l_msg_count
528: , x_msg_data => x_message
529: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
530: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
531: , temp_cascaded_table => l_rcpt_match_table_detail
532: , p_receipt_num => NULL
533: , p_shipment_header_id => NULL
534: , p_lpn_id => NULL

Line 569: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

565: END IF;
566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF;
568:
569: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
570: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
571: fnd_message.set_name('INV', l_err_message);
572: fnd_msg_pub.ADD;
573:

Line 570: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

566: RAISE fnd_api.g_exc_unexpected_error;
567: END IF;
568:
569: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
570: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
571: fnd_message.set_name('INV', l_err_message);
572: fnd_msg_pub.ADD;
573:
574: IF (l_debug = 1) THEN

Line 583: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(

579: END IF;
580:
581: l_err_message := '@@@';
582:
583: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
584: inv_rcv_std_rcpt_apis.g_receipt_detail_index
585: + l_rcpt_match_table_detail.COUNT
586: - 1
587: ) LOOP

Line 584: inv_rcv_std_rcpt_apis.g_receipt_detail_index

580:
581: l_err_message := '@@@';
582:
583: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
584: inv_rcv_std_rcpt_apis.g_receipt_detail_index
585: + l_rcpt_match_table_detail.COUNT
586: - 1
587: ) LOOP
588: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN

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

584: inv_rcv_std_rcpt_apis.g_receipt_detail_index
585: + l_rcpt_match_table_detail.COUNT
586: - 1
587: ) LOOP
588: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
589: x_status := 'W';
590: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
591:
592: IF l_temp_message IS NULL THEN

Line 590: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;

586: - 1
587: ) LOOP
588: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
589: x_status := 'W';
590: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
591:
592: IF l_temp_message IS NULL THEN
593: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
594: l_msg_prod := 'INV';

Line 760: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

756: END IF;
757:
758: l_progress := '70';
759: -- Clear the Lot Rec
760: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
761:
762: IF (l_debug = 1) THEN
763: print_debug('Exiting create_osp_drct_dlvr_rti_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
764: END IF;

Line 863: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

859: , p_attribute14 IN VARCHAR2 DEFAULT NULL
860: , p_attribute15 IN VARCHAR2 DEFAULT NULL
861: ) IS
862: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
863: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
864: l_transaction_type VARCHAR2(20) := 'DELIVER';
865: l_total_primary_qty NUMBER := 0;
866: l_msg_count NUMBER;
867: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 869: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

865: l_total_primary_qty NUMBER := 0;
866: l_msg_count NUMBER;
867: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
868: l_group_id NUMBER;
869: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
870: --l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
871:
872: l_err_message VARCHAR2(100);
873: l_temp_message VARCHAR2(100);

Line 1087: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

1083: END IF;
1084:
1085: l_progress := '30';
1086: -- initialize input record for matching algorithm
1087: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1088: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1089: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1090:
1091: IF (l_debug = 1) THEN

Line 1088: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

1084:
1085: l_progress := '30';
1086: -- initialize input record for matching algorithm
1087: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1088: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1089: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1090:
1091: IF (l_debug = 1) THEN
1092: print_debug(

Line 1089: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;

1085: l_progress := '30';
1086: -- initialize input record for matching algorithm
1087: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1088: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1089: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1090:
1091: IF (l_debug = 1) THEN
1092: print_debug(
1093: 'create_po_rcpt_intf_rec: 40-S - p_inv_item_id' || TO_CHAR(p_inv_item_id) || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 1099: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;

1095: );
1096: END IF;
1097:
1098: IF p_inv_item_id IS NOT NULL THEN -- p_item_id has substitute item id
1099: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;
1100: ELSE
1101: IF p_item_id IS NOT NULL THEN
1102: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1103: ELSE

Line 1102: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

1098: IF p_inv_item_id IS NOT NULL THEN -- p_item_id has substitute item id
1099: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_inv_item_id;
1100: ELSE
1101: IF p_item_id IS NOT NULL THEN
1102: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1103: ELSE
1104: IF (l_debug = 1) THEN
1105: print_debug('create_po_rcpt_intf_rec: Item id is null - One time item', 4);
1106: END IF;

Line 1108: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;

1104: IF (l_debug = 1) THEN
1105: print_debug('create_po_rcpt_intf_rec: Item id is null - One time item', 4);
1106: END IF;
1107:
1108: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
1109: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
1110: END IF;
1111: END IF;
1112:

Line 1109: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;

1105: print_debug('create_po_rcpt_intf_rec: Item id is null - One time item', 4);
1106: END IF;
1107:
1108: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
1109: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
1110: END IF;
1111: END IF;
1112:
1113: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

Line 1113: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

1109: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
1110: END IF;
1111: END IF;
1112:
1113: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1114: p_organization_id;
1115: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1116: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
1117: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;

Line 1115: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;

1111: END IF;
1112:
1113: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1114: p_organization_id;
1115: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1116: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
1117: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
1118: -- line id, line location id and distribution id will be passed only from the putaway api.
1119: -- line id however, can also be passed through the UI if the line number

Line 1116: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;

1112:
1113: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1114: p_organization_id;
1115: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1116: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
1117: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
1118: -- line id, line location id and distribution id will be passed only from the putaway api.
1119: -- line id however, can also be passed through the UI if the line number
1120: -- field is enabled on the UI.

Line 1117: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;

1113: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1114: p_organization_id;
1115: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1116: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
1117: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
1118: -- line id, line location id and distribution id will be passed only from the putaway api.
1119: -- line id however, can also be passed through the UI if the line number
1120: -- field is enabled on the UI.
1121: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;

Line 1121: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;

1117: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_release_id := p_po_release_id;
1118: -- line id, line location id and distribution id will be passed only from the putaway api.
1119: -- line id however, can also be passed through the UI if the line number
1120: -- field is enabled on the UI.
1121: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;
1122: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=
1123: p_po_line_location_id;
1124: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=
1125: p_po_distribution_id;

Line 1122: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=

1118: -- line id, line location id and distribution id will be passed only from the putaway api.
1119: -- line id however, can also be passed through the UI if the line number
1120: -- field is enabled on the UI.
1121: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;
1122: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=
1123: p_po_line_location_id;
1124: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=
1125: p_po_distribution_id;
1126:

Line 1124: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=

1120: -- field is enabled on the UI.
1121: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := p_po_line_id;
1122: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id :=
1123: p_po_line_location_id;
1124: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id :=
1125: p_po_distribution_id;
1126:
1127: IF p_item_id IS NOT NULL THEN
1128: BEGIN

Line 1130: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

1126:
1127: IF p_item_id IS NOT NULL THEN
1128: BEGIN
1129: SELECT primary_unit_of_measure
1130: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1131: FROM mtl_system_items
1132: WHERE mtl_system_items.inventory_item_id = p_item_id
1133: AND mtl_system_items.organization_id = p_organization_id;
1134: EXCEPTION

Line 1143: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;

1139: print_debug('create_po_drct_dlvr_rti_rec: 3 - get primary_unit_of_measure exception', 4);
1140: END IF;
1141: END;
1142: ELSE
1143: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
1144: END IF;
1145:
1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

Line 1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;

1142: ELSE
1143: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
1144: END IF;
1145:
1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

Line 1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

1143: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
1144: END IF;
1145:
1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1151: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

Line 1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;

1144: END IF;
1145:
1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1151: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1152:

Line 1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?

1145:
1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1151: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1152:
1153: IF (l_debug = 1) THEN

Line 1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

1146: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1151: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1152:
1153: IF (l_debug = 1) THEN
1154: print_debug(

Line 1151: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

1147: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1148: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1149: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1150: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1151: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1152:
1153: IF (l_debug = 1) THEN
1154: print_debug(
1155: 'create_po_drct_dlvr_rti_rec: 4 - before inv_rcv_txn_interface.matching_logic' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')

Line 1165: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross

1161: inv_rcv_txn_interface.matching_logic(
1162: x_return_status => x_status
1163: , x_msg_count => l_msg_count
1164: , x_msg_data => x_message
1165: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
1166: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
1167: , temp_cascaded_table => l_rcpt_match_table_detail
1168: , p_receipt_num => NULL
1169: , p_shipment_header_id => NULL

Line 1166: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index

1162: x_return_status => x_status
1163: , x_msg_count => l_msg_count
1164: , x_msg_data => x_message
1165: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
1166: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
1167: , temp_cascaded_table => l_rcpt_match_table_detail
1168: , p_receipt_num => NULL
1169: , p_shipment_header_id => NULL
1170: , p_lpn_id => NULL

Line 1204: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

1200:
1201: RAISE fnd_api.g_exc_unexpected_error;
1202: END IF;
1203:
1204: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1205: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1206: fnd_message.set_name('INV', l_err_message);
1207: fnd_msg_pub.ADD;
1208:

Line 1205: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

1201: RAISE fnd_api.g_exc_unexpected_error;
1202: END IF;
1203:
1204: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1205: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1206: fnd_message.set_name('INV', l_err_message);
1207: fnd_msg_pub.ADD;
1208:
1209: IF (l_debug = 1) THEN

Line 1218: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(

1214: END IF;
1215:
1216: l_err_message := '@@@';
1217:
1218: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
1219: inv_rcv_std_rcpt_apis.g_receipt_detail_index
1220: + l_rcpt_match_table_detail.COUNT
1221: - 1
1222: ) LOOP

Line 1219: inv_rcv_std_rcpt_apis.g_receipt_detail_index

1215:
1216: l_err_message := '@@@';
1217:
1218: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
1219: inv_rcv_std_rcpt_apis.g_receipt_detail_index
1220: + l_rcpt_match_table_detail.COUNT
1221: - 1
1222: ) LOOP
1223: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN

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

1219: inv_rcv_std_rcpt_apis.g_receipt_detail_index
1220: + l_rcpt_match_table_detail.COUNT
1221: - 1
1222: ) LOOP
1223: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
1224: x_status := 'W';
1225: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
1226:
1227: IF l_temp_message IS NULL THEN

Line 1225: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;

1221: - 1
1222: ) LOOP
1223: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
1224: x_status := 'W';
1225: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
1226:
1227: IF l_temp_message IS NULL THEN
1228: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
1229: l_msg_prod := 'INV';

Line 1488: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;

1484: END IF;
1485: END IF; --END IF check INV J and PO J installed
1486:
1487: -- append index in input table where the line to be detailed needs to be inserted
1488: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1489:
1490: l_progress := '90';
1491: inv_rcv_common_apis.do_check(
1492: p_organization_id => p_organization_id

Line 1507: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

1503: END IF;
1504:
1505: l_progress := '100';
1506: -- Clear the Lot Rec
1507: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1508:
1509: IF (l_debug = 1) THEN
1510: print_debug('Exiting create_po_drct_dlvr_rti_rec:' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1511: END IF;

Line 1603: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

1599: , p_attribute14 IN VARCHAR2 DEFAULT NULL
1600: , p_attribute15 IN VARCHAR2 DEFAULT NULL
1601: ) IS
1602: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
1603: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
1604: l_transaction_type VARCHAR2(20) := 'DELIVER';
1605: l_total_primary_qty NUMBER := 0;
1606: l_msg_count NUMBER;
1607: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1609: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

1605: l_total_primary_qty NUMBER := 0;
1606: l_msg_count NUMBER;
1607: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1608: l_group_id NUMBER;
1609: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
1610: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
1611: l_err_message VARCHAR2(100);
1612: l_temp_message VARCHAR2(100);
1613: l_msg_prod VARCHAR2(5);

Line 1875: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

1871: END IF;
1872:
1873: l_progress := '30';
1874: -- initialize input record for matching algorithm
1875: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

Line 1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

1872:
1873: l_progress := '30';
1874: -- initialize input record for matching algorithm
1875: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

Line 1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;

1873: l_progress := '30';
1874: -- initialize input record for matching algorithm
1875: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1881: p_organization_id;

Line 1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;

1874: -- initialize input record for matching algorithm
1875: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1881: p_organization_id;
1882: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id :=

Line 1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

1875: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1881: p_organization_id;
1882: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id :=
1883: p_shipment_header_id;

Line 1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

1876: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1877: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1881: p_organization_id;
1882: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id :=
1883: p_shipment_header_id;
1884: -- line id will be passed only from the putaway api.

Line 1882: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id :=

1878: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
1879: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1880: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
1881: p_organization_id;
1882: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id :=
1883: p_shipment_header_id;
1884: -- line id will be passed only from the putaway api.
1885: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id :=
1886: p_shipment_line_id;

Line 1885: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id :=

1881: p_organization_id;
1882: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id :=
1883: p_shipment_header_id;
1884: -- line id will be passed only from the putaway api.
1885: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id :=
1886: p_shipment_line_id;
1887: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1888: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1889:

Line 1887: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;

1883: p_shipment_header_id;
1884: -- line id will be passed only from the putaway api.
1885: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id :=
1886: p_shipment_line_id;
1887: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1888: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1889:
1890: BEGIN
1891: SELECT primary_unit_of_measure

Line 1888: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;

1884: -- line id will be passed only from the putaway api.
1885: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id :=
1886: p_shipment_line_id;
1887: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1888: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1889:
1890: BEGIN
1891: SELECT primary_unit_of_measure
1892: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

Line 1892: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

1888: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1889:
1890: BEGIN
1891: SELECT primary_unit_of_measure
1892: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1893: FROM mtl_system_items
1894: WHERE mtl_system_items.inventory_item_id = p_item_id
1895: AND mtl_system_items.organization_id = p_organization_id;
1896: EXCEPTION

Line 1903: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?

1899: print_debug('create_int_shp_dr_del_rti_rec: 3 - get primary_unit_of_measure exception', 4);
1900: END IF;
1901: END;
1902:
1903: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1904: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1905: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1906: l_progress := '40';
1907:

Line 1904: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

1900: END IF;
1901: END;
1902:
1903: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1904: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1905: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1906: l_progress := '40';
1907:
1908: IF (l_debug = 1) THEN

Line 1905: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

1901: END;
1902:
1903: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
1904: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1905: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1906: l_progress := '40';
1907:
1908: IF (l_debug = 1) THEN
1909: print_debug(

Line 1922: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross

1918: x_return_status => x_status
1919: , --?
1920: x_msg_count => l_msg_count
1921: , x_msg_data => x_message
1922: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
1923: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
1924: , temp_cascaded_table => l_rcpt_match_table_detail
1925: , p_receipt_num => NULL
1926: , p_match_type => 'INTRANSIT SHIPMENT'

Line 1923: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index

1919: , --?
1920: x_msg_count => l_msg_count
1921: , x_msg_data => x_message
1922: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
1923: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
1924: , temp_cascaded_table => l_rcpt_match_table_detail
1925: , p_receipt_num => NULL
1926: , p_match_type => 'INTRANSIT SHIPMENT'
1927: , p_lpn_id => p_from_lpn_id --BUG 4613635 : pass

Line 1968: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

1964:
1965: RAISE fnd_api.g_exc_unexpected_error;
1966: END IF;
1967:
1968: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1969: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1970: fnd_message.set_name('INV', l_err_message);
1971: fnd_msg_pub.ADD;
1972:

Line 1969: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

1965: RAISE fnd_api.g_exc_unexpected_error;
1966: END IF;
1967:
1968: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1969: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1970: fnd_message.set_name('INV', l_err_message);
1971: fnd_msg_pub.ADD;
1972:
1973: IF (l_debug = 1) THEN

Line 1982: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(

1978: END IF;
1979:
1980: l_err_message := '@@@';
1981:
1982: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
1983: inv_rcv_std_rcpt_apis.g_receipt_detail_index
1984: + l_rcpt_match_table_detail.COUNT
1985: - 1
1986: ) LOOP

Line 1983: inv_rcv_std_rcpt_apis.g_receipt_detail_index

1979:
1980: l_err_message := '@@@';
1981:
1982: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
1983: inv_rcv_std_rcpt_apis.g_receipt_detail_index
1984: + l_rcpt_match_table_detail.COUNT
1985: - 1
1986: ) LOOP
1987: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN

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

1983: inv_rcv_std_rcpt_apis.g_receipt_detail_index
1984: + l_rcpt_match_table_detail.COUNT
1985: - 1
1986: ) LOOP
1987: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
1988: x_status := 'W';
1989: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
1990:
1991: IF l_temp_message IS NULL THEN

Line 1989: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;

1985: - 1
1986: ) LOOP
1987: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
1988: x_status := 'W';
1989: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
1990:
1991: IF l_temp_message IS NULL THEN
1992: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
1993: l_msg_prod := 'INV';

Line 2270: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;

2266: END IF;
2267: END IF; --END IF check INV J and PO J installed
2268:
2269: -- append index in input table where the line to be detailed needs to be inserted
2270: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
2271: l_progress := '90';
2272: inv_rcv_common_apis.do_check(
2273: p_organization_id => p_organization_id
2274: , p_inventory_item_id => p_item_id

Line 2288: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

2284: END IF;
2285:
2286: l_progress := '100';
2287: -- Clear the Lot Rec
2288: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
2289:
2290: IF (l_debug = 1) THEN
2291: print_debug('About exit create_int_shp_dr_del_rti_rec: 130 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2292: END IF;

Line 2378: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

2374: , p_attribute14 IN VARCHAR2 DEFAULT NULL
2375: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2376: ) IS
2377: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2378: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2379: l_transaction_type VARCHAR2(20) := 'DELIVER';
2380: l_total_primary_qty NUMBER := 0;
2381: l_msg_count NUMBER;
2382: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 2384: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

2380: l_total_primary_qty NUMBER := 0;
2381: l_msg_count NUMBER;
2382: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2383: l_group_id NUMBER;
2384: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
2385: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
2386: l_err_message VARCHAR2(100);
2387: l_temp_message VARCHAR2(100);
2388: l_msg_prod VARCHAR2(5);

Line 2588: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

2584: END IF;
2585: END IF;
2586:
2587: -- initialize input record for matching algorithm
2588: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

Line 2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

2585: END IF;
2586:
2587: -- initialize input record for matching algorithm
2588: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

Line 2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;

2586:
2587: -- initialize input record for matching algorithm
2588: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
2594: p_organization_id;

Line 2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;

2587: -- initialize input record for matching algorithm
2588: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
2594: p_organization_id;
2595: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id :=

Line 2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

2588: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
2594: p_organization_id;
2595: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id :=
2596: p_oe_order_header_id;

Line 2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=

2589: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2590: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
2594: p_organization_id;
2595: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id :=
2596: p_oe_order_header_id;
2597: -- line id will be passed only from the putaway api.

Line 2595: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id :=

2591: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
2592: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2593: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id :=
2594: p_organization_id;
2595: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id :=
2596: p_oe_order_header_id;
2597: -- line id will be passed only from the putaway api.
2598: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id :=
2599: p_oe_order_line_id;

Line 2598: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id :=

2594: p_organization_id;
2595: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id :=
2596: p_oe_order_header_id;
2597: -- line id will be passed only from the putaway api.
2598: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id :=
2599: p_oe_order_line_id;
2600: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --bug# 2794612
2601: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --bug# 2794612
2602:

Line 2600: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --bug# 2794612

2596: p_oe_order_header_id;
2597: -- line id will be passed only from the putaway api.
2598: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id :=
2599: p_oe_order_line_id;
2600: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --bug# 2794612
2601: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --bug# 2794612
2602:
2603: BEGIN
2604: SELECT primary_unit_of_measure

Line 2601: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --bug# 2794612

2597: -- line id will be passed only from the putaway api.
2598: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id :=
2599: p_oe_order_line_id;
2600: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --bug# 2794612
2601: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --bug# 2794612
2602:
2603: BEGIN
2604: SELECT primary_unit_of_measure
2605: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

Line 2605: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

2601: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --bug# 2794612
2602:
2603: BEGIN
2604: SELECT primary_unit_of_measure
2605: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2606: FROM mtl_system_items
2607: WHERE mtl_system_items.inventory_item_id = p_item_id
2608: AND mtl_system_items.organization_id = p_organization_id;
2609: EXCEPTION

Line 2616: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?

2612: print_debug('create_rma_drct_dlvr_rti_rec: 3 - get primary_unit_of_measure exception', 4);
2613: END IF;
2614: END;
2615:
2616: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
2617: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2618: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2619: l_progress := '40';
2620:

Line 2617: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

2613: END IF;
2614: END;
2615:
2616: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
2617: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2618: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2619: l_progress := '40';
2620:
2621: IF (l_debug = 1) THEN

Line 2618: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

2614: END;
2615:
2616: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
2617: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2618: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2619: l_progress := '40';
2620:
2621: IF (l_debug = 1) THEN
2622: print_debug(

Line 2633: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross

2629: x_return_status => x_status
2630: , --?
2631: x_msg_count => l_msg_count
2632: , x_msg_data => x_message
2633: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
2634: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
2635: , temp_cascaded_table => l_rcpt_match_table_detail
2636: , p_receipt_num => NULL
2637: , p_match_type => 'RMA'

Line 2634: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index

2630: , --?
2631: x_msg_count => l_msg_count
2632: , x_msg_data => x_message
2633: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
2634: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
2635: , temp_cascaded_table => l_rcpt_match_table_detail
2636: , p_receipt_num => NULL
2637: , p_match_type => 'RMA'
2638: , p_lpn_id => NULL

Line 2675: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

2671:
2672: RAISE fnd_api.g_exc_unexpected_error;
2673: END IF;
2674:
2675: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2676: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
2677: fnd_message.set_name('INV', l_err_message);
2678: fnd_msg_pub.ADD;
2679:

Line 2676: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

2672: RAISE fnd_api.g_exc_unexpected_error;
2673: END IF;
2674:
2675: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2676: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
2677: fnd_message.set_name('INV', l_err_message);
2678: fnd_msg_pub.ADD;
2679:
2680: IF (l_debug = 1) THEN

Line 2689: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(

2685: END IF;
2686:
2687: l_err_message := '@@@';
2688:
2689: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
2690: inv_rcv_std_rcpt_apis.g_receipt_detail_index
2691: + l_rcpt_match_table_detail.COUNT
2692: - 1
2693: ) LOOP

Line 2690: inv_rcv_std_rcpt_apis.g_receipt_detail_index

2686:
2687: l_err_message := '@@@';
2688:
2689: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
2690: inv_rcv_std_rcpt_apis.g_receipt_detail_index
2691: + l_rcpt_match_table_detail.COUNT
2692: - 1
2693: ) LOOP
2694: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN

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

2690: inv_rcv_std_rcpt_apis.g_receipt_detail_index
2691: + l_rcpt_match_table_detail.COUNT
2692: - 1
2693: ) LOOP
2694: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
2695: x_status := 'W';
2696: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
2697:
2698: IF l_temp_message IS NULL THEN

Line 2696: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;

2692: - 1
2693: ) LOOP
2694: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
2695: x_status := 'W';
2696: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
2697:
2698: IF l_temp_message IS NULL THEN
2699: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
2700: l_msg_prod := 'INV';

Line 2883: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;

2879: END IF;
2880: END IF; --END IF check INV J and PO J installed
2881:
2882: -- append index in input table where the line to be detailed needs to be inserted
2883: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
2884:
2885: l_progress := '90';
2886: inv_rcv_common_apis.do_check(
2887: p_organization_id => p_organization_id

Line 2902: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

2898: END IF;
2899:
2900: l_progress := '100';
2901: -- Clear the Lot Rec
2902: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
2903:
2904: IF (l_debug = 1) THEN
2905: print_debug('About exit create_rma_drct_dlvr_rti_rec: 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
2906: END IF;

Line 2995: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block

2991: , p_attribute15 IN VARCHAR2 DEFAULT NULL
2992: , p_express_transaction IN VARCHAR2 DEFAULT NULL--Bug 5550783
2993: ) IS
2994: l_rcpt_match_table_detail inv_rcv_common_apis.cascaded_trans_tab_type; -- output for matching algorithm
2995: l_rcv_transaction_rec inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp; -- rcv_transaction block
2996: l_transaction_type VARCHAR2(20) := 'DELIVER';
2997: l_total_primary_qty NUMBER := 0;
2998: l_match_type VARCHAR2(20);
2999: l_msg_count NUMBER;

Line 3003: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;

2999: l_msg_count NUMBER;
3000: l_msg_data VARCHAR2(400);
3001: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3002: l_group_id NUMBER;
3003: l_rcv_rcpt_rec inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp;
3004: l_mmtt_rec mtl_material_transactions_temp%ROWTYPE;
3005: l_err_message VARCHAR2(100);
3006: l_temp_message VARCHAR2(100);
3007: l_msg_prod VARCHAR2(5);

Line 3443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;

3439: l_progress := '30';
3440: -- call matching algorithm ?
3441:
3442: -- initialize input record for matching algorithm
3443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
3444: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
3445: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
3446: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
3447:

Line 3444: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';

3440: -- call matching algorithm ?
3441:
3442: -- initialize input record for matching algorithm
3443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
3444: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
3445: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
3446: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
3447:
3448: IF p_item_id IS NOT NULL THEN

Line 3445: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

3441:
3442: -- initialize input record for matching algorithm
3443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
3444: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
3445: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
3446: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
3447:
3448: IF p_item_id IS NOT NULL THEN
3449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

Line 3446: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;

3442: -- initialize input record for matching algorithm
3443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).GROUP_ID := l_group_id;
3444: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
3445: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
3446: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
3447:
3448: IF p_item_id IS NOT NULL THEN
3449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3450: ELSE

Line 3449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

3445: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
3446: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).unit_of_measure := p_rcv_uom;
3447:
3448: IF p_item_id IS NOT NULL THEN
3449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3450: ELSE
3451: IF (l_debug = 1) THEN
3452: print_debug('create_asn_con_dd_intf_rec: Item id is null - One time item', 4);
3453: END IF;

Line 3455: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;

3451: IF (l_debug = 1) THEN
3452: print_debug('create_asn_con_dd_intf_rec: Item id is null - One time item', 4);
3453: END IF;
3454:
3455: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
3456: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
3457: END IF;
3458:
3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

Line 3456: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;

3452: print_debug('create_asn_con_dd_intf_rec: Item id is null - One time item', 4);
3453: END IF;
3454:
3455: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
3456: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
3457: END IF;
3458:
3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;

Line 3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

3455: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
3456: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
3457: END IF;
3458:
3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?

Line 3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;

3456: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
3457: END IF;
3458:
3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

Line 3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;

3457: END IF;
3458:
3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

Line 3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;

3458:
3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612

Line 3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?

3459: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612
3467: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --BUG# 2794612

Line 3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

3460: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).to_organization_id := p_organization_id;
3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612
3467: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --BUG# 2794612
3468: l_progress := '60';

Line 3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

3461: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_header_id := p_shipment_header_id;
3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612
3467: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --BUG# 2794612
3468: l_progress := '60';
3469:

Line 3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612

3462: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_header_id := p_po_header_id;
3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612
3467: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --BUG# 2794612
3468: l_progress := '60';
3469:
3470: IF p_item_id IS NOT NULL THEN

Line 3467: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --BUG# 2794612

3463: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := SYSDATE; --?
3464: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
3465: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
3466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id; --BUG# 2794612
3467: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id; --BUG# 2794612
3468: l_progress := '60';
3469:
3470: IF p_item_id IS NOT NULL THEN
3471: SELECT primary_unit_of_measure

Line 3472: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

3468: l_progress := '60';
3469:
3470: IF p_item_id IS NOT NULL THEN
3471: SELECT primary_unit_of_measure
3472: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
3473: FROM mtl_system_items
3474: WHERE mtl_system_items.inventory_item_id = p_item_id
3475: AND mtl_system_items.organization_id = p_organization_id;
3476:

Line 3479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;

3475: AND mtl_system_items.organization_id = p_organization_id;
3476:
3477: l_progress := '70';
3478: ELSE
3479: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
3480: l_progress := '71';
3481: END IF;
3482:
3483: IF (l_debug = 1) THEN

Line 3544: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross

3540: x_return_status => l_return_status
3541: , --?
3542: x_msg_count => l_msg_count
3543: , x_msg_data => l_msg_data
3544: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
3545: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
3546: , temp_cascaded_table => l_rcpt_match_table_detail
3547: , p_receipt_num => NULL
3548: , p_match_type => l_match_type

Line 3545: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index

3541: , --?
3542: x_msg_count => l_msg_count
3543: , x_msg_data => l_msg_data
3544: , x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross
3545: , n => inv_rcv_std_rcpt_apis.g_receipt_detail_index
3546: , temp_cascaded_table => l_rcpt_match_table_detail
3547: , p_receipt_num => NULL
3548: , p_match_type => l_match_type
3549: , p_lpn_id => l_lpn_id

Line 3582: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN

3578:
3579: RAISE fnd_api.g_exc_unexpected_error;
3580: END IF;
3581:
3582: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
3583: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
3584: fnd_message.set_name('INV', l_err_message);
3585: fnd_msg_pub.ADD;
3586:

Line 3583: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;

3579: RAISE fnd_api.g_exc_unexpected_error;
3580: END IF;
3581:
3582: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
3583: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
3584: fnd_message.set_name('INV', l_err_message);
3585: fnd_msg_pub.ADD;
3586:
3587: IF (l_debug = 1) THEN

Line 3596: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(

3592: END IF;
3593:
3594: l_err_message := '@@@';
3595:
3596: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
3597: inv_rcv_std_rcpt_apis.g_receipt_detail_index
3598: + l_rcpt_match_table_detail.COUNT
3599: - 1
3600: ) LOOP

Line 3597: inv_rcv_std_rcpt_apis.g_receipt_detail_index

3593:
3594: l_err_message := '@@@';
3595:
3596: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index ..(
3597: inv_rcv_std_rcpt_apis.g_receipt_detail_index
3598: + l_rcpt_match_table_detail.COUNT
3599: - 1
3600: ) LOOP
3601: IF (l_debug = 1) THEN

Line 3603: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_status

3599: - 1
3600: ) LOOP
3601: IF (l_debug = 1) THEN
3602: print_debug('Error Status:'||
3603: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_status
3604: , 4);
3605: print_debug('Error Message:'||
3606: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_message
3607: , 4);

Line 3606: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_message

3602: print_debug('Error Status:'||
3603: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_status
3604: , 4);
3605: print_debug('Error Message:'||
3606: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_message
3607: , 4);
3608: END IF;
3609:
3610: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN

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

3606: l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index +1).error_message
3607: , 4);
3608: END IF;
3609:
3610: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
3611: x_status := 'W';
3612: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
3613:
3614: IF l_temp_message IS NULL THEN

Line 3612: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;

3608: END IF;
3609:
3610: IF l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_status = 'W' THEN
3611: x_status := 'W';
3612: l_temp_message := l_rcpt_match_table_detail(i - inv_rcv_std_rcpt_apis.g_receipt_detail_index + 1).error_message;
3613:
3614: IF l_temp_message IS NULL THEN
3615: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
3616: l_msg_prod := 'INV';

Line 3891: , inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb

3887: p_organization_id
3888: , l_group_id
3889: , l_rcv_rcpt_rec
3890: , l_rcv_transaction_rec
3891: , inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb
3892: , TO_NUMBER(NULL)
3893: , l_return_status
3894: , l_msg_data
3895: );

Line 3903: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

3899: END IF;
3900:
3901: l_progress := '140';
3902: -- Clear the Lot Rec
3903: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
3904:
3905: IF (l_debug = 1) THEN
3906: print_debug('About exit create_asn_con_dd_intf_rec: 140' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
3907: END IF;

Line 3944: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_dd_intf_rec', l_progress, SQLCODE);

3940: CLOSE l_curs_rcpt_detail;
3941: END IF;
3942:
3943: IF SQLCODE IS NOT NULL THEN
3944: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_con_dd_intf_rec', l_progress, SQLCODE);
3945: END IF;
3946:
3947: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
3948:

Line 4169: inv_rcv_std_rcpt_apis.update_lpn_org(

4165:
4166: IF inv_rcv_common_apis.g_po_patch_level < inv_rcv_common_apis.g_patchset_j_po
4167: OR inv_rcv_common_apis.g_inv_patch_level < inv_rcv_common_apis.g_patchset_j
4168: OR inv_rcv_common_apis.g_wms_patch_level < inv_rcv_common_apis.g_patchset_j THEN
4169: inv_rcv_std_rcpt_apis.update_lpn_org(
4170: p_organization_id => p_organization_id
4171: , p_lpn_id => l_lpn_id
4172: , x_return_status => l_return_status
4173: , x_msg_count => l_msg_count

Line 4782: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_dd_intf_rec', l_progress, SQLCODE);

4778: CLOSE l_curs_asn_lpn_content;
4779: END IF;
4780:
4781: IF SQLCODE IS NOT NULL THEN
4782: inv_mobile_helper_functions.sql_error('INV_RCV_STD_RCPT_APIS.create_asn_exp_dd_intf_rec', l_progress, SQLCODE);
4783: END IF;
4784:
4785: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => l_msg_count, p_data => x_message);
4786: