APPS.GML_RCV_DIR_RCPT_APIS dependencies on INV_RCV_STD_RCPT_APIS

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

325: -- bug 2743146
326: -- Make sure that the po_distribution passed does satisfy the tolerance
327: -- limits by calling the matching algorithm for that.
328: -- initialize input record for matching algorithm
329: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
330: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
331: 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;
332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
333:

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

326: -- Make sure that the po_distribution passed does satisfy the tolerance
327: -- limits by calling the matching algorithm for that.
328: -- initialize input record for matching algorithm
329: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
330: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
331: 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;
332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
333:
334:

Line 331: 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;

327: -- limits by calling the matching algorithm for that.
328: -- initialize input record for matching algorithm
329: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
330: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
331: 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;
332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
333:
334:
335: 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 332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;

328: -- initialize input record for matching algorithm
329: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
330: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
331: 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;
332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
333:
334:
335: 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;
336: 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 335: 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;

331: 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;
332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
333:
334:
335: 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;
336: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
337: 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;
338: 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;
339:

Line 336: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;

332: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
333:
334:
335: 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;
336: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
337: 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;
338: 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;
339:
340: -- line id, line location id and distribution id will be passed only from the putaway api.

Line 337: 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;

333:
334:
335: 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;
336: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
337: 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;
338: 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;
339:
340: -- line id, line location id and distribution id will be passed only from the putaway api.
341: -- line id however, can also be passed through the UI if the line number

Line 338: 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;

334:
335: 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;
336: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
337: 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;
338: 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;
339:
340: -- line id, line location id and distribution id will be passed only from the putaway api.
341: -- line id however, can also be passed through the UI if the line number
342: -- field is enabled on the UI.

Line 343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := l_rcv_rcpt_rec.po_line_id;

339:
340: -- line id, line location id and distribution id will be passed only from the putaway api.
341: -- line id however, can also be passed through the UI if the line number
342: -- field is enabled on the UI.
343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := l_rcv_rcpt_rec.po_line_id;
344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := l_rcv_rcpt_rec.po_line_location_id;
345: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;
346:
347: IF p_item_id IS NOT NULL THEN

Line 344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := l_rcv_rcpt_rec.po_line_location_id;

340: -- line id, line location id and distribution id will be passed only from the putaway api.
341: -- line id however, can also be passed through the UI if the line number
342: -- field is enabled on the UI.
343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := l_rcv_rcpt_rec.po_line_id;
344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := l_rcv_rcpt_rec.po_line_location_id;
345: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;
346:
347: IF p_item_id IS NOT NULL THEN
348: BEGIN

Line 345: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;

341: -- line id however, can also be passed through the UI if the line number
342: -- field is enabled on the UI.
343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_id := l_rcv_rcpt_rec.po_line_id;
344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_line_location_id := l_rcv_rcpt_rec.po_line_location_id;
345: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).po_distribution_id := p_po_distribution_id;
346:
347: IF p_item_id IS NOT NULL THEN
348: BEGIN
349: select primary_unit_of_measure

Line 350: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

346:
347: IF p_item_id IS NOT NULL THEN
348: BEGIN
349: select primary_unit_of_measure
350: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
351: from mtl_system_items
352: where mtl_system_items.inventory_item_id = p_item_id
353: and mtl_system_items.organization_id = p_organization_id;
354: EXCEPTION

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

356: NULL;
357:
358: END;
359: ELSE
360: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
361: END IF;
362:
363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
364: --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 363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;

359: ELSE
360: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
361: END IF;
362:
363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
364: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
365: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
367: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

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

360: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
361: END IF;
362:
363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
364: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
365: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
367: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
368: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

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

361: END IF;
362:
363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
364: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
365: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
367: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
368: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
369:

Line 366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?

362:
363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
364: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
365: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
367: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
368: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
369:
370:

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

363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).revision := p_revision;
364: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
365: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
367: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
368: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
369:
370:
371: l_progress := '40';

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

364: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
365: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
366: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
367: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
368: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
369:
370:
371: l_progress := '40';
372: gml_rcv_txn_interface.matching_logic

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

392: FND_MSG_PUB.ADD;
393: RAISE fnd_api.g_exc_unexpected_error;
394: END IF;
395:
396: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
397: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
398: FND_MESSAGE.SET_NAME('INV', l_err_message);
399: FND_MSG_PUB.ADD;
400: RAISE fnd_api.g_exc_error;

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

393: RAISE fnd_api.g_exc_unexpected_error;
394: END IF;
395:
396: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
397: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
398: FND_MESSAGE.SET_NAME('INV', l_err_message);
399: FND_MSG_PUB.ADD;
400: RAISE fnd_api.g_exc_error;
401: END IF;

Line 404: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

400: RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: l_err_message := '@@@';
404: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
405: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
406: x_status := 'W';
407:
408: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;

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

401: END IF;
402:
403: l_err_message := '@@@';
404: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
405: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
406: x_status := 'W';
407:
408: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
409: IF l_temp_message IS NULL THEN

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

404: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
405: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
406: x_status := 'W';
407:
408: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
409: IF l_temp_message IS NULL THEN
410: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
411: l_msg_prod := 'INV';
412: EXIT;

Line 492: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

488:
489: l_progress := '70';
490:
491: -- Clear the Lot Rec
492: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
493:
494:
495: EXCEPTION
496: WHEN fnd_api.g_exc_error THEN

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

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

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

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

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

995:
996:
997: END LOOP;
998: -- append index in input table where the line to be detailed needs to be inserted
999: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1000:
1001: l_split_lot_serial_ok := inv_rcv_integration_apis.split_lot_serial(
1002: p_api_version => 1.0
1003: , p_init_msg_lst => FND_API.G_FALSE

Line 1034: ---inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

1030: */
1031: l_progress := '100';
1032:
1033: -- Clear the Lot Rec
1034: ---inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1035: gml_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1036:
1037:
1038: EXCEPTION

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

1336: END IF;
1337:
1338: l_progress := '30';
1339: -- initialize input record for matching algorithm
1340: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: 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 1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

1337:
1338: l_progress := '30';
1339: -- initialize input record for matching algorithm
1340: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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 1342: 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;

1338: l_progress := '30';
1339: -- initialize input record for matching algorithm
1340: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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;
1346: 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;

Line 1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;

1339: -- initialize input record for matching algorithm
1340: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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;
1346: 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;
1347: -- line id will be passed only from the putaway api.

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

1340: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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;
1346: 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;
1347: -- line id will be passed only from the putaway api.
1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;

Line 1345: 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;

1341: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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;
1346: 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;
1347: -- line id will be passed only from the putaway api.
1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;
1349: 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 1346: 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;

1342: 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;
1343: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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;
1346: 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;
1347: -- line id will be passed only from the putaway api.
1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;
1349: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1350: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;

Line 1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;

1344: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1345: 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;
1346: 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;
1347: -- line id will be passed only from the putaway api.
1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;
1349: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1350: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1351:
1352: BEGIN

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

1345: 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;
1346: 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;
1347: -- line id will be passed only from the putaway api.
1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;
1349: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1350: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1351:
1352: BEGIN
1353: select primary_unit_of_measure

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

1346: 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;
1347: -- line id will be passed only from the putaway api.
1348: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).shipment_line_id := p_shipment_line_id;
1349: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).project_id := p_project_id;
1350: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1351:
1352: BEGIN
1353: select primary_unit_of_measure
1354: 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 1354: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

1350: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).task_id := p_task_id;
1351:
1352: BEGIN
1353: select primary_unit_of_measure
1354: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1355: from mtl_system_items
1356: where mtl_system_items.inventory_item_id = p_item_id
1357: and mtl_system_items.organization_id = p_organization_id;
1358: EXCEPTION

Line 1363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?

1359: when no_data_found then
1360: NULL;
1361: END;
1362:
1363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
1364: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1365: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1366:
1367: /** EOU Commented out as this procedure is not needed by OPM

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

1360: NULL;
1361: END;
1362:
1363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
1364: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1365: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1366:
1367: /** EOU Commented out as this procedure is not needed by OPM
1368: l_progress := '40';

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

1361: END;
1362:
1363: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
1364: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1365: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1366:
1367: /** EOU Commented out as this procedure is not needed by OPM
1368: l_progress := '40';
1369: inv_rcv_txn_match.matching_logic

Line 1373: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,

1369: inv_rcv_txn_match.matching_logic
1370: (x_return_status => x_status, --?
1371: x_msg_count => l_msg_count,
1372: x_msg_data => x_message,
1373: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
1374: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,
1375: temp_cascaded_table => l_rcpt_match_table_detail,
1376: p_receipt_num => NULL,
1377: p_match_type => 'INTRANSIT SHIPMENT',

Line 1374: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,

1370: (x_return_status => x_status, --?
1371: x_msg_count => l_msg_count,
1372: x_msg_data => x_message,
1373: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
1374: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,
1375: temp_cascaded_table => l_rcpt_match_table_detail,
1376: p_receipt_num => NULL,
1377: p_match_type => 'INTRANSIT SHIPMENT',
1378: p_lpn_id => NULL

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

1391: FND_MSG_PUB.ADD;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;
1394:
1395: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1396: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1397: FND_MESSAGE.SET_NAME('INV', l_err_message);
1398: FND_MSG_PUB.ADD;
1399: RAISE fnd_api.g_exc_error;

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

1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;
1394:
1395: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1396: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1397: FND_MESSAGE.SET_NAME('INV', l_err_message);
1398: FND_MSG_PUB.ADD;
1399: RAISE fnd_api.g_exc_error;
1400: END IF;

Line 1403: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

1399: RAISE fnd_api.g_exc_error;
1400: END IF;
1401:
1402: l_err_message := '@@@';
1403: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
1404: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
1405: x_status := 'W';
1406:
1407: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;

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

1400: END IF;
1401:
1402: l_err_message := '@@@';
1403: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
1404: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
1405: x_status := 'W';
1406:
1407: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
1408: IF l_temp_message IS NULL THEN

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

1403: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
1404: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
1405: x_status := 'W';
1406:
1407: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
1408: IF l_temp_message IS NULL THEN
1409: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
1410: l_msg_prod := 'INV';
1411: EXIT;

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

1505:
1506:
1507: END LOOP;
1508: -- append index in input table where the line to be detailed needs to be inserted
1509: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1510:
1511: l_progress := '90';
1512: inv_rcv_common_apis.do_check
1513: (p_organization_id => p_organization_id,

Line 1528: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

1524:
1525: l_progress := '100';
1526:
1527: -- Clear the Lot Rec
1528: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1529:
1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN

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

1794: l_group_id := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
1795: END IF;
1796:
1797: -- initialize input record for matching algorithm
1798: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: 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 1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

1795: END IF;
1796:
1797: -- initialize input record for matching algorithm
1798: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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 1800: 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;

1796:
1797: -- initialize input record for matching algorithm
1798: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;

Line 1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;

1797: -- initialize input record for matching algorithm
1798: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.

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

1798: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.
1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;

Line 1803: 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;

1799: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.
1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;
1807: 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 1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;

1800: 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;
1801: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.
1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;
1807: 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
1808: 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 1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;

1802: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.
1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;
1807: 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
1808: 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
1809:
1810: BEGIN

Line 1807: 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

1803: 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;
1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.
1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;
1807: 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
1808: 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
1809:
1810: BEGIN
1811: select primary_unit_of_measure

Line 1808: 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

1804: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_header_id := p_oe_order_header_id;
1805: -- line id will be passed only from the putaway api.
1806: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).oe_order_line_id := p_oe_order_line_id;
1807: 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
1808: 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
1809:
1810: BEGIN
1811: select primary_unit_of_measure
1812: 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 1812: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure

1808: 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
1809:
1810: BEGIN
1811: select primary_unit_of_measure
1812: into inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
1813: from mtl_system_items
1814: where mtl_system_items.inventory_item_id = p_item_id
1815: and mtl_system_items.organization_id = p_organization_id;
1816: EXCEPTION

Line 1821: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?

1817: when no_data_found then
1818: NULL;
1819: END;
1820:
1821: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
1822: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1823: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1824:
1825: l_progress := '40';

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

1818: NULL;
1819: END;
1820:
1821: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
1822: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1823: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1824:
1825: l_progress := '40';
1826: inv_rcv_txn_match.matching_logic

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

1819: END;
1820:
1821: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
1822: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
1823: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
1824:
1825: l_progress := '40';
1826: inv_rcv_txn_match.matching_logic
1827: (x_return_status => x_status, --?

Line 1830: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,

1826: inv_rcv_txn_match.matching_logic
1827: (x_return_status => x_status, --?
1828: x_msg_count => l_msg_count,
1829: x_msg_data => x_message,
1830: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
1831: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,
1832: temp_cascaded_table => l_rcpt_match_table_detail,
1833: p_receipt_num => NULL,
1834: p_match_type => 'RMA',

Line 1831: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,

1827: (x_return_status => x_status, --?
1828: x_msg_count => l_msg_count,
1829: x_msg_data => x_message,
1830: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
1831: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,
1832: temp_cascaded_table => l_rcpt_match_table_detail,
1833: p_receipt_num => NULL,
1834: p_match_type => 'RMA',
1835: p_lpn_id => NULL

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

1847: FND_MSG_PUB.ADD;
1848: RAISE fnd_api.g_exc_unexpected_error;
1849: END IF;
1850:
1851: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1852: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1853: FND_MESSAGE.SET_NAME('INV', l_err_message);
1854: FND_MSG_PUB.ADD;
1855: RAISE fnd_api.g_exc_error;

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

1848: RAISE fnd_api.g_exc_unexpected_error;
1849: END IF;
1850:
1851: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
1852: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
1853: FND_MESSAGE.SET_NAME('INV', l_err_message);
1854: FND_MSG_PUB.ADD;
1855: RAISE fnd_api.g_exc_error;
1856: END IF;

Line 1859: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

1855: RAISE fnd_api.g_exc_error;
1856: END IF;
1857:
1858: l_err_message := '@@@';
1859: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
1860: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
1861: x_status := 'W';
1862:
1863: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;

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

1856: END IF;
1857:
1858: l_err_message := '@@@';
1859: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
1860: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
1861: x_status := 'W';
1862:
1863: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
1864: IF l_temp_message IS NULL THEN

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

1859: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
1860: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
1861: x_status := 'W';
1862:
1863: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
1864: IF l_temp_message IS NULL THEN
1865: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
1866: l_msg_prod := 'INV';
1867: EXIT;

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

1934: l_progress := '80';
1935:
1936: END LOOP;
1937: -- append index in input table where the line to be detailed needs to be inserted
1938: --inv_rcv_std_rcpt_apis.g_receipt_detail_index := l_rcpt_match_table_detail.COUNT + inv_rcv_std_rcpt_apis.g_receipt_detail_index;
1939:
1940: l_progress := '90';
1941: inv_rcv_common_apis.do_check
1942: (p_organization_id => p_organization_id,

Line 1957: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

1953:
1954: l_progress := '100';
1955:
1956: -- Clear the Lot Rec
1957: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
1958:
1959:
1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN

Line 2435: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;

2431:
2432: -- call matching algorithm ?
2433:
2434: -- initialize input record for matching algorithm
2435: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
2436: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2437: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2438: 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;
2439: IF p_item_id IS NOT NULL THEN

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

2432: -- call matching algorithm ?
2433:
2434: -- initialize input record for matching algorithm
2435: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
2436: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2437: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2438: 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;
2439: IF p_item_id IS NOT NULL THEN
2440: 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 2437: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;

2433:
2434: -- initialize input record for matching algorithm
2435: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
2436: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2437: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2438: 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;
2439: IF p_item_id IS NOT NULL THEN
2440: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2441: ELSE

Line 2438: 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;

2434: -- initialize input record for matching algorithm
2435: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).group_id := l_group_id;
2436: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2437: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2438: 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;
2439: IF p_item_id IS NOT NULL THEN
2440: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2441: ELSE
2442: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;

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

2436: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).transaction_type := 'DELIVER';
2437: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).quantity := p_rcv_qty;
2438: 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;
2439: IF p_item_id IS NOT NULL THEN
2440: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2441: ELSE
2442: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
2444: end if;

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

2438: 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;
2439: IF p_item_id IS NOT NULL THEN
2440: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2441: ELSE
2442: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
2444: end if;
2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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 2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;

2439: IF p_item_id IS NOT NULL THEN
2440: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2441: ELSE
2442: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
2444: end if;
2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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;
2447: 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;

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

2441: ELSE
2442: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
2444: end if;
2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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;
2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?

Line 2446: 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;

2442: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := NULL;
2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
2444: end if;
2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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;
2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

Line 2447: 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;

2443: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_desc := p_item_desc;
2444: end if;
2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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;
2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?

Line 2448: 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;

2444: end if;
2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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;
2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2452: 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 2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?

2445: --inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).item_id := p_item_id;
2446: 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;
2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2452: 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
2453: 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 2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?

2446: 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;
2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2452: 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
2453: 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
2454:

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

2447: 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;
2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2452: 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
2453: 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
2454:
2455:

Line 2452: 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

2448: 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;
2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2452: 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
2453: 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
2454:
2455:
2456: l_progress := '60';

Line 2453: 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

2449: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).expected_receipt_date := Sysdate; --?
2450: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).tax_amount := 0; -- ?
2451: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status := 'S'; -- ?
2452: 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
2453: 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
2454:
2455:
2456: l_progress := '60';
2457:

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

2456: l_progress := '60';
2457:
2458: IF p_item_id IS NOT NULL THEN
2459: SELECT primary_unit_of_measure
2460: INTO inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure
2461: FROM mtl_system_items
2462: WHERE mtl_system_items.inventory_item_id = p_item_id
2463: AND mtl_system_items.organization_id = p_organization_id;
2464: l_progress := '70';

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

2462: WHERE mtl_system_items.inventory_item_id = p_item_id
2463: AND mtl_system_items.organization_id = p_organization_id;
2464: l_progress := '70';
2465: ELSE
2466: inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).primary_unit_of_measure := NULL;
2467: l_progress := '71';
2468: END IF;
2469:
2470:

Line 2510: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,

2506: INV_rcv_txn_match.matching_logic
2507: (x_return_status => l_return_status, --?
2508: x_msg_count => l_msg_count,
2509: x_msg_data => l_msg_data,
2510: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
2511: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,
2512: temp_cascaded_table => l_rcpt_match_table_detail,
2513: p_receipt_num => NULL,
2514: p_match_type => l_match_type,

Line 2511: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,

2507: (x_return_status => l_return_status, --?
2508: x_msg_count => l_msg_count,
2509: x_msg_data => l_msg_data,
2510: x_cascaded_table => inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross,
2511: n => inv_rcv_std_rcpt_apis.g_receipt_detail_index,
2512: temp_cascaded_table => l_rcpt_match_table_detail,
2513: p_receipt_num => NULL,
2514: p_match_type => l_match_type,
2515: p_lpn_id => p_lpn_id

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

2528: FND_MSG_PUB.ADD;
2529: RAISE fnd_api.g_exc_unexpected_error;
2530: END IF;
2531:
2532: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2533: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
2534: FND_MESSAGE.SET_NAME('INV', l_err_message);
2535: FND_MSG_PUB.ADD;
2536: RAISE fnd_api.g_exc_error;

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

2529: RAISE fnd_api.g_exc_unexpected_error;
2530: END IF;
2531:
2532: IF inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_status = 'E' THEN
2533: l_err_message := inv_rcv_std_rcpt_apis.g_rcpt_match_table_gross(inv_rcv_std_rcpt_apis.g_receipt_detail_index).error_message;
2534: FND_MESSAGE.SET_NAME('INV', l_err_message);
2535: FND_MSG_PUB.ADD;
2536: RAISE fnd_api.g_exc_error;
2537: END IF;

Line 2540: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP

2536: RAISE fnd_api.g_exc_error;
2537: END IF;
2538:
2539: l_err_message := '@@@';
2540: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
2541: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
2542: x_status := 'W';
2543:
2544: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;

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

2537: END IF;
2538:
2539: l_err_message := '@@@';
2540: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
2541: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
2542: x_status := 'W';
2543:
2544: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
2545: IF l_temp_message IS NULL THEN

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

2540: FOR i IN inv_rcv_std_rcpt_apis.g_receipt_detail_index..(inv_rcv_std_rcpt_apis.g_receipt_detail_index + l_rcpt_match_table_detail.COUNT - 1) LOOP
2541: IF l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_status = 'W' THEN
2542: x_status := 'W';
2543:
2544: l_temp_message := l_rcpt_match_table_detail(i-inv_rcv_std_rcpt_apis.g_receipt_detail_index+1).error_message;
2545: IF l_temp_message IS NULL THEN
2546: l_err_message := 'INV_RCV_GEN_TOLERANCE_EXCEED';
2547: l_msg_prod := 'INV';
2548: EXIT;

Line 2690: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb,

2686: p_organization_id,
2687: l_group_id,
2688: l_rcv_rcpt_rec,
2689: l_rcv_transaction_rec,
2690: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb,
2691: to_number(null),
2692: l_return_status,
2693: l_msg_data );
2694: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 2703: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;

2699:
2700: l_progress := '140';
2701:
2702: -- Clear the Lot Rec
2703: inv_rcv_std_rcpt_apis.g_rcpt_lot_qty_rec_tb.DELETE;
2704:
2705:
2706: EXCEPTION
2707:

Line 2909: inv_rcv_std_rcpt_apis.update_lpn_org(p_organization_id => p_organization_id,

2905: EXIT WHEN l_curs_asn_lpn_content%notfound;
2906:
2907: l_progress := '30';
2908:
2909: inv_rcv_std_rcpt_apis.update_lpn_org(p_organization_id => p_organization_id,
2910: p_lpn_id => l_lpn_id,
2911: x_return_status => l_return_status,
2912: x_msg_count => l_msg_count,
2913: x_msg_data => l_msg_data);