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.RCV_INT_ORDER_PP_PVT dependencies on RCV_ERROR_PKG

Line 130: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

126: we are not able to default the shipment_header_id.
127: Reason: If shipment_header_id is not defaulted, we won't be able to stamp
128: the receipt number created in RCV_SHIPMENT_HEADERS table, through
129: rcv_int_order_pp_pvt.update_header() procedure.*/
130: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
131: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM', p_header_record.error_record.error_message);
132: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM', false);/* Bug 4907179 */
133:
134: RETURN;

Line 131: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM', p_header_record.error_record.error_message);

127: Reason: If shipment_header_id is not defaulted, we won't be able to stamp
128: the receipt number created in RCV_SHIPMENT_HEADERS table, through
129: rcv_int_order_pp_pvt.update_header() procedure.*/
130: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
131: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM', p_header_record.error_record.error_message);
132: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM', false);/* Bug 4907179 */
133:
134: RETURN;
135: END IF;

Line 132: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM', false);/* Bug 4907179 */

128: the receipt number created in RCV_SHIPMENT_HEADERS table, through
129: rcv_int_order_pp_pvt.update_header() procedure.*/
130: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;
131: rcv_error_pkg.set_error_message('RCV_NO_SHIPMENT_NUM', p_header_record.error_record.error_message);
132: rcv_error_pkg.log_interface_error('RCV_HEADERS_INTERFACE', 'SHIPMENT_NUM', false);/* Bug 4907179 */
133:
134: RETURN;
135: END IF;
136:

Line 148: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');

144: IF (g_asn_debug = 'Y') THEN
145: asn_debug.put_line('Exception in when others in default_shipment_info ');
146: END IF;
147:
148: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');
149: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
150: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
151: END default_shipment_info;
152:

Line 149: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;

145: asn_debug.put_line('Exception in when others in default_shipment_info ');
146: END IF;
147:
148: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');
149: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
150: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
151: END default_shipment_info;
152:
153: PROCEDURE update_header(

Line 150: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;

146: END IF;
147:
148: rcv_error_pkg.set_sql_error_message('default_shipment_info', '000');
149: p_header_record.error_record.error_status := rcv_error_pkg.g_ret_sts_unexp_error;
150: p_header_record.error_record.error_message := rcv_error_pkg.get_last_message;
151: END default_shipment_info;
152:
153: PROCEDURE update_header(
154: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type

Line 299: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

295: /* Bug3591830 - START */
296: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n);
297: temp_cascaded_table(n).locator_id := x_cascaded_table(n).locator_id;
298: asn_debug.put_line('progress in Internal Orders rcv : after derive_to_locator_id -> locator_id = ' || temp_cascaded_table(n).locator_id);
299: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
300: 'LOCATOR_ID',
301: FALSE
302: );
303: /* Bug3591830 - END */

Line 822: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

818: IF (g_asn_debug = 'Y') THEN
819: asn_debug.put_line('quantity is <= zero. cascade will fail');
820: END IF;
821:
822: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
823: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
824: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
825: rcv_error_pkg.log_interface_error('QUANTITY');
826: END IF; --} end qty > 0 check

Line 823: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);

819: asn_debug.put_line('quantity is <= zero. cascade will fail');
820: END IF;
821:
822: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
823: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
824: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
825: rcv_error_pkg.log_interface_error('QUANTITY');
826: END IF; --} end qty > 0 check
827:

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

820: END IF;
821:
822: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
823: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
824: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
825: rcv_error_pkg.log_interface_error('QUANTITY');
826: END IF; --} end qty > 0 check
827:
828: x_progress := '098';

Line 825: rcv_error_pkg.log_interface_error('QUANTITY');

821:
822: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
823: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
824: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
825: rcv_error_pkg.log_interface_error('QUANTITY');
826: END IF; --} end qty > 0 check
827:
828: x_progress := '098';
829:

Line 844: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

840: asn_debug.put_line('no shipment num/shipment header specified ');
841: asn_debug.put_line('status = ' || x_cascaded_table(n).error_status);
842: END IF;
843:
844: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
845: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
846: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
847: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
848: END IF; -- } of (asn quantity_shipped was valid)

Line 845: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);

841: asn_debug.put_line('status = ' || x_cascaded_table(n).error_status);
842: END IF;
843:
844: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
845: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
846: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
847: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
848: END IF; -- } of (asn quantity_shipped was valid)
849:

Line 846: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);

842: END IF;
843:
844: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
845: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
846: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
847: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
848: END IF; -- } of (asn quantity_shipped was valid)
849:
850: -- copy record from main table to temp table

Line 847: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');

843:
844: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
845: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
846: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
847: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
848: END IF; -- } of (asn quantity_shipped was valid)
849:
850: -- copy record from main table to temp table
851:

Line 888: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

884: END IF;
885: EXCEPTION
886: WHEN NO_DATA_FOUND
887: THEN
888: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
889: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
890: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
891: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
892:

Line 889: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);

885: EXCEPTION
886: WHEN NO_DATA_FOUND
887: THEN
888: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
889: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
890: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
891: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
892:
893: IF (g_asn_debug = 'Y') THEN

Line 890: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);

886: WHEN NO_DATA_FOUND
887: THEN
888: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
889: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
890: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
891: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
892:
893: IF (g_asn_debug = 'Y') THEN
894: asn_debug.put_line(TO_CHAR(n));

Line 891: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');

887: THEN
888: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
889: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
890: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
891: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
892:
893: IF (g_asn_debug = 'Y') THEN
894: asn_debug.put_line(TO_CHAR(n));
895: asn_debug.put_line('No shipment_header_id found for shipment_num = ' || temp_cascaded_table(current_n).shipment_num );

Line 900: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;

896: asn_debug.put_line('error ' || x_progress);
897: END IF;
898: WHEN OTHERS
899: THEN
900: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
901: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
902: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
903: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
904:

Line 901: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);

897: END IF;
898: WHEN OTHERS
899: THEN
900: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
901: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
902: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
903: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
904:
905: IF (g_asn_debug = 'Y') THEN

Line 902: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

898: WHEN OTHERS
899: THEN
900: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
901: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
902: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
903: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
904:
905: IF (g_asn_debug = 'Y') THEN
906: asn_debug.put_line(TO_CHAR(n));

Line 903: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');

899: THEN
900: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
901: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
902: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
903: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
904:
905: IF (g_asn_debug = 'Y') THEN
906: asn_debug.put_line(TO_CHAR(n));
907: asn_debug.put_line('Error while selecting shipment_header_id for shipment_num = ' || temp_cascaded_table(current_n).shipment_num );

Line 1079: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

1075: IF (g_asn_debug = 'Y') THEN
1076: asn_debug.put_line('Need to insert a row into po_interface_errors for transfer');
1077: END IF;
1078:
1079: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1080: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1081: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1082: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1083: rcv_error_pkg.log_interface_error('QUANTITY');

Line 1080: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);

1076: asn_debug.put_line('Need to insert a row into po_interface_errors for transfer');
1077: END IF;
1078:
1079: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1080: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1081: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1082: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1083: rcv_error_pkg.log_interface_error('QUANTITY');
1084: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true

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

1077: END IF;
1078:
1079: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1080: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1081: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1082: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1083: rcv_error_pkg.log_interface_error('QUANTITY');
1084: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true
1085: IF rows_fetched = 0 THEN

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

1078:
1079: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1080: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1081: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1082: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1083: rcv_error_pkg.log_interface_error('QUANTITY');
1084: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true
1085: IF rows_fetched = 0 THEN
1086: IF (g_asn_debug = 'Y') THEN

Line 1083: rcv_error_pkg.log_interface_error('QUANTITY');

1079: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1080: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1081: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1082: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1083: rcv_error_pkg.log_interface_error('QUANTITY');
1084: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true
1085: IF rows_fetched = 0 THEN
1086: IF (g_asn_debug = 'Y') THEN
1087: asn_debug.put_line('No rows were retrieved from cursor.');

Line 1106: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

1102: temp_cascaded_table.DELETE(i);
1103: END LOOP;
1104: END IF;
1105:
1106: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1107: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);
1108: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
1109: END IF; --} ends row fetched > 0 and not first transaction
1110:

Line 1107: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);

1103: END LOOP;
1104: END IF;
1105:
1106: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1107: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);
1108: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
1109: END IF; --} ends row fetched > 0 and not first transaction
1110:
1111: -- all the rows in the temp cascaded table

Line 1108: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');

1104: END IF;
1105:
1106: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1107: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);
1108: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
1109: END IF; --} ends row fetched > 0 and not first transaction
1110:
1111: -- all the rows in the temp cascaded table
1112: -- will be deleted

Line 1528: WHEN rcv_error_pkg.e_fatal_error THEN

1524: IF (g_asn_debug = 'Y') THEN
1525: asn_debug.put_line('exit derive_io_rcv_line_qty');
1526: END IF;
1527: EXCEPTION
1528: WHEN rcv_error_pkg.e_fatal_error THEN
1529: IF shipments%ISOPEN THEN
1530: CLOSE shipments;
1531: END IF;
1532:

Line 1545: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);

1541: IF count_shipments%ISOPEN THEN
1542: CLOSE count_shipments;
1543: END IF;
1544:
1545: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);
1546: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1547: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1548:
1549: IF (g_asn_debug = 'Y') THEN

Line 1546: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;

1542: CLOSE count_shipments;
1543: END IF;
1544:
1545: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);
1546: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1547: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1548:
1549: IF (g_asn_debug = 'Y') THEN
1550: asn_debug.put_line(TO_CHAR(n));

Line 1547: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;

1543: END IF;
1544:
1545: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);
1546: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1547: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1548:
1549: IF (g_asn_debug = 'Y') THEN
1550: asn_debug.put_line(TO_CHAR(n));
1551: asn_debug.put_line(SQLERRM);