DBA Data[Home] [Help]

APPS.RCV_ROI_RETURN dependencies on RCV_ERROR_PKG

Line 575: rcv_error_pkg.set_error_message('RCV_INVALID_TRANSACTION_TYPE');

571: END IF;
572:
573: IF (l_complex_flag = 'Y') THEN
574: asn_debug.put_line('We do not support transaction type ' || x_cascaded_table(n).transaction_type || ' for complex work POs');
575: rcv_error_pkg.set_error_message('RCV_INVALID_TRANSACTION_TYPE');
576: rcv_error_pkg.log_interface_error('TRANSACTION_TYPE');
577: End if;
578:
579: l_parent_transaction_type := x_derive_returnrec.transaction_type;

Line 576: rcv_error_pkg.log_interface_error('TRANSACTION_TYPE');

572:
573: IF (l_complex_flag = 'Y') THEN
574: asn_debug.put_line('We do not support transaction type ' || x_cascaded_table(n).transaction_type || ' for complex work POs');
575: rcv_error_pkg.set_error_message('RCV_INVALID_TRANSACTION_TYPE');
576: rcv_error_pkg.log_interface_error('TRANSACTION_TYPE');
577: End if;
578:
579: l_parent_transaction_type := x_derive_returnrec.transaction_type;
580: l_grand_parent_trx_id := x_derive_returnrec.parent_transaction_id;

Line 916: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);

912: x_cascaded_table(n).error_status := 'F';
913: /* Bug 3250532 : Changed the error message from 'TBD' to 'RCV_ENTER_QTY_GT_ZERO'.
914: */
915: x_cascaded_table(n).error_message := 'RCV_ENTER_QTY_GT_ZERO';
916: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
917: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
918: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
919: WHEN no_parent_line_exception THEN
920: x_cascaded_table(n).error_status := 'E';

Line 917: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);

913: /* Bug 3250532 : Changed the error message from 'TBD' to 'RCV_ENTER_QTY_GT_ZERO'.
914: */
915: x_cascaded_table(n).error_message := 'RCV_ENTER_QTY_GT_ZERO';
916: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
917: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
918: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
919: WHEN no_parent_line_exception THEN
920: x_cascaded_table(n).error_status := 'E';
921:

Line 918: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);

914: */
915: x_cascaded_table(n).error_message := 'RCV_ENTER_QTY_GT_ZERO';
916: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
917: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
918: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
919: WHEN no_parent_line_exception THEN
920: x_cascaded_table(n).error_status := 'E';
921:
922: IF (x_cascaded_table(n).error_message IS NULL) THEN

Line 928: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);

924: */
925: x_cascaded_table(n).error_message := 'RCV_NO_PARENT_TRANSACTION';
926: END IF;
927:
928: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
929: rcv_error_pkg.set_token('DOCUMENT_NUM', x_cascaded_table(n).document_num);
930: rcv_error_pkg.log_interface_error('NUMBER', FALSE);
931: WHEN reject_exception THEN
932: x_cascaded_table(n).error_status := 'E';

Line 929: rcv_error_pkg.set_token('DOCUMENT_NUM', x_cascaded_table(n).document_num);

925: x_cascaded_table(n).error_message := 'RCV_NO_PARENT_TRANSACTION';
926: END IF;
927:
928: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
929: rcv_error_pkg.set_token('DOCUMENT_NUM', x_cascaded_table(n).document_num);
930: rcv_error_pkg.log_interface_error('NUMBER', FALSE);
931: WHEN reject_exception THEN
932: x_cascaded_table(n).error_status := 'E';
933: /* Bug 3250532 : Changed the error message from 'TBD' to 'RCV_TRX_QTY_EXCEEDS_AVAILABLE'.

Line 930: rcv_error_pkg.log_interface_error('NUMBER', FALSE);

926: END IF;
927:
928: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
929: rcv_error_pkg.set_token('DOCUMENT_NUM', x_cascaded_table(n).document_num);
930: rcv_error_pkg.log_interface_error('NUMBER', FALSE);
931: WHEN reject_exception THEN
932: x_cascaded_table(n).error_status := 'E';
933: /* Bug 3250532 : Changed the error message from 'TBD' to 'RCV_TRX_QTY_EXCEEDS_AVAILABLE'.
934: */

Line 936: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);

932: x_cascaded_table(n).error_status := 'E';
933: /* Bug 3250532 : Changed the error message from 'TBD' to 'RCV_TRX_QTY_EXCEEDS_AVAILABLE'.
934: */
935: x_cascaded_table(n).error_message := 'RCV_TRX_QTY_EXCEEDS_AVAILABLE';
936: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
937: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
938: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
939: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
940: temp_cascaded_table.DELETE;

Line 937: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);

933: /* Bug 3250532 : Changed the error message from 'TBD' to 'RCV_TRX_QTY_EXCEEDS_AVAILABLE'.
934: */
935: x_cascaded_table(n).error_message := 'RCV_TRX_QTY_EXCEEDS_AVAILABLE';
936: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
937: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
938: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
939: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
940: temp_cascaded_table.DELETE;
941:

Line 938: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);

934: */
935: x_cascaded_table(n).error_message := 'RCV_TRX_QTY_EXCEEDS_AVAILABLE';
936: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
937: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
938: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
939: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
940: temp_cascaded_table.DELETE;
941:
942: -- bug 8640033

Line 939: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);

935: x_cascaded_table(n).error_message := 'RCV_TRX_QTY_EXCEEDS_AVAILABLE';
936: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
937: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
938: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
939: rcv_error_pkg.log_interface_error('QUANTITY', FALSE);
940: temp_cascaded_table.DELETE;
941:
942: -- bug 8640033
943: WHEN po_shipment_cancel_exception THEN

Line 947: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);

943: WHEN po_shipment_cancel_exception THEN
944: x_cascaded_table(n).error_status := 'E';
945:
946: x_cascaded_table(n).error_message := 'RCV_PO_SHIPMENT_CANCELLED';
947: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
948: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID', FALSE);
949: -- end bug 8640033
950:
951: WHEN OTHERS THEN

Line 948: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID', FALSE);

944: x_cascaded_table(n).error_status := 'E';
945:
946: x_cascaded_table(n).error_message := 'RCV_PO_SHIPMENT_CANCELLED';
947: rcv_error_pkg.set_error_message(x_cascaded_table(n).error_message);
948: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID', FALSE);
949: -- end bug 8640033
950:
951: WHEN OTHERS THEN
952: IF derive_return%ISOPEN THEN

Line 1488: rcv_error_pkg.set_error_message(x_error_message);

1484:
1485: IF (l_primary_qty > NVL(l_att, 0)) THEN --{
1486: x_error_status := 'E';
1487: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1488: rcv_error_pkg.set_error_message(x_error_message);
1489: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1490: rcv_error_pkg.set_token('SUB', l_att);
1491: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1492: EXIT;

Line 1489: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);

1485: IF (l_primary_qty > NVL(l_att, 0)) THEN --{
1486: x_error_status := 'E';
1487: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1488: rcv_error_pkg.set_error_message(x_error_message);
1489: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1490: rcv_error_pkg.set_token('SUB', l_att);
1491: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1492: EXIT;
1493: ELSE -- }{

Line 1490: rcv_error_pkg.set_token('SUB', l_att);

1486: x_error_status := 'E';
1487: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1488: rcv_error_pkg.set_error_message(x_error_message);
1489: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1490: rcv_error_pkg.set_token('SUB', l_att);
1491: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1492: EXIT;
1493: ELSE -- }{
1494: x_error_status := 'S';

Line 1491: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);

1487: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1488: rcv_error_pkg.set_error_message(x_error_message);
1489: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1490: rcv_error_pkg.set_token('SUB', l_att);
1491: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1492: EXIT;
1493: ELSE -- }{
1494: x_error_status := 'S';
1495: END IF; --}

Line 1499: rcv_error_pkg.set_error_message(x_error_message);

1495: END IF; --}
1496: ELSE --}{
1497: x_error_status := 'E';
1498: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1499: rcv_error_pkg.set_error_message(x_error_message);
1500: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1501: rcv_error_pkg.set_token('SUB', l_att);
1502: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1503: EXIT;

Line 1500: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);

1496: ELSE --}{
1497: x_error_status := 'E';
1498: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1499: rcv_error_pkg.set_error_message(x_error_message);
1500: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1501: rcv_error_pkg.set_token('SUB', l_att);
1502: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1503: EXIT;
1504: END IF; --}

Line 1501: rcv_error_pkg.set_token('SUB', l_att);

1497: x_error_status := 'E';
1498: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1499: rcv_error_pkg.set_error_message(x_error_message);
1500: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1501: rcv_error_pkg.set_token('SUB', l_att);
1502: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1503: EXIT;
1504: END IF; --}
1505:

Line 1502: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);

1498: x_error_message := 'RCV_TRX_QTY_EXCEEDS_INV_AVAIL';
1499: rcv_error_pkg.set_error_message(x_error_message);
1500: rcv_error_pkg.set_token('PRIMARY', l_primary_qty);
1501: rcv_error_pkg.set_token('SUB', l_att);
1502: rcv_error_pkg.log_interface_error('PRIMARY_QUANTITY', FALSE);
1503: EXIT;
1504: END IF; --}
1505:
1506: IF (p_transaction_type = 'CORRECT') THEN --{