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 329: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,

325: /* Bug3591830 - START */
326: rcv_roi_transaction.derive_to_locator_id(x_cascaded_table, n);
327: temp_cascaded_table(n).locator_id := x_cascaded_table(n).locator_id;
328: asn_debug.put_line('progress in Internal Orders rcv : after derive_to_locator_id -> locator_id = ' || temp_cascaded_table(n).locator_id);
329: rcv_error_pkg.log_interface_message(x_cascaded_table(n).error_status,
330: 'LOCATOR_ID',
331: FALSE
332: );
333: /* Bug3591830 - END */

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

864: IF (g_asn_debug = 'Y') THEN
865: asn_debug.put_line('quantity is <= zero. cascade will fail');
866: END IF;
867:
868: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
869: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
870: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
871: rcv_error_pkg.log_interface_error('QUANTITY');
872: END IF; --} end qty > 0 check

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

865: asn_debug.put_line('quantity is <= zero. cascade will fail');
866: END IF;
867:
868: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
869: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
870: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
871: rcv_error_pkg.log_interface_error('QUANTITY');
872: END IF; --} end qty > 0 check
873:

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

866: END IF;
867:
868: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
869: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
870: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
871: rcv_error_pkg.log_interface_error('QUANTITY');
872: END IF; --} end qty > 0 check
873:
874: x_progress := '098';

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

867:
868: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
869: rcv_error_pkg.set_error_message('RCV_ITEM_NO_SHIP_QTY', x_cascaded_table(n).error_message);
870: rcv_error_pkg.set_token('ITEM', x_cascaded_table(n).item_num);
871: rcv_error_pkg.log_interface_error('QUANTITY');
872: END IF; --} end qty > 0 check
873:
874: x_progress := '098';
875:

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

886: asn_debug.put_line('no shipment num/shipment header specified ');
887: asn_debug.put_line('status = ' || x_cascaded_table(n).error_status);
888: END IF;
889:
890: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
891: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
892: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
893: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
894: END IF; -- } of (asn quantity_shipped was valid)

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

887: asn_debug.put_line('status = ' || x_cascaded_table(n).error_status);
888: END IF;
889:
890: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
891: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
892: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
893: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
894: END IF; -- } of (asn quantity_shipped was valid)
895:

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

888: END IF;
889:
890: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
891: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
892: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
893: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
894: END IF; -- } of (asn quantity_shipped was valid)
895:
896: -- copy record from main table to temp table

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

889:
890: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
891: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
892: rcv_error_pkg.set_token('SHIPMENT_NUM', x_cascaded_table(n).shipment_num);
893: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
894: END IF; -- } of (asn quantity_shipped was valid)
895:
896: -- copy record from main table to temp table
897:

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

930: END IF;
931: EXCEPTION
932: WHEN NO_DATA_FOUND
933: THEN
934: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
936: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
937: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
938:

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

931: EXCEPTION
932: WHEN NO_DATA_FOUND
933: THEN
934: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
936: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
937: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
938:
939: IF (g_asn_debug = 'Y') THEN

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

932: WHEN NO_DATA_FOUND
933: THEN
934: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
936: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
937: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
938:
939: IF (g_asn_debug = 'Y') THEN
940: asn_debug.put_line(TO_CHAR(n));

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

933: THEN
934: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
935: rcv_error_pkg.set_error_message('RCV_IOT_NO_SHIP_INFO', x_cascaded_table(n).error_message);
936: rcv_error_pkg.set_token('SHIPMENT_NUM', temp_cascaded_table(current_n).shipment_num);
937: rcv_error_pkg.log_interface_error('SHIPMENT_NUM');
938:
939: IF (g_asn_debug = 'Y') THEN
940: asn_debug.put_line(TO_CHAR(n));
941: asn_debug.put_line('No shipment_header_id found for shipment_num = ' || temp_cascaded_table(current_n).shipment_num );

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

942: asn_debug.put_line('error ' || x_progress);
943: END IF;
944: WHEN OTHERS
945: THEN
946: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
947: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
948: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
949: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
950:

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

943: END IF;
944: WHEN OTHERS
945: THEN
946: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
947: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
948: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
949: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
950:
951: IF (g_asn_debug = 'Y') THEN

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

944: WHEN OTHERS
945: THEN
946: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
947: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
948: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
949: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
950:
951: IF (g_asn_debug = 'Y') THEN
952: asn_debug.put_line(TO_CHAR(n));

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

945: THEN
946: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
947: rcv_error_pkg.set_sql_error_message('derive_int_org_rcv_line_qty', x_progress);
948: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
949: rcv_error_pkg.log_interface_error('INTERFACE_TRANSACTION_ID');
950:
951: IF (g_asn_debug = 'Y') THEN
952: asn_debug.put_line(TO_CHAR(n));
953: asn_debug.put_line('Error while selecting shipment_header_id for shipment_num = ' || temp_cascaded_table(current_n).shipment_num );

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

1124: IF (g_asn_debug = 'Y') THEN
1125: asn_debug.put_line('Need to insert a row into po_interface_errors for transfer');
1126: END IF;
1127:
1128: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1129: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1130: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1131: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1132: rcv_error_pkg.log_interface_error('QUANTITY');

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

1125: asn_debug.put_line('Need to insert a row into po_interface_errors for transfer');
1126: END IF;
1127:
1128: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1129: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1130: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1131: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1132: rcv_error_pkg.log_interface_error('QUANTITY');
1133: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true

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

1126: END IF;
1127:
1128: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1129: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1130: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1131: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1132: rcv_error_pkg.log_interface_error('QUANTITY');
1133: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true
1134: IF rows_fetched = 0 THEN

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

1127:
1128: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1129: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1130: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1131: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1132: rcv_error_pkg.log_interface_error('QUANTITY');
1133: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true
1134: IF rows_fetched = 0 THEN
1135: IF (g_asn_debug = 'Y') THEN

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

1128: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1129: rcv_error_pkg.set_error_message('RCV_SHIP_QTY_OVER_TOLERANCE', x_cascaded_table(n).error_message);
1130: rcv_error_pkg.set_token('QTY_A', x_cascaded_table(n).quantity);
1131: rcv_error_pkg.set_token('QTY_B', x_cascaded_table(n).quantity - x_remaining_quantity);
1132: rcv_error_pkg.log_interface_error('QUANTITY');
1133: ELSE --}{ else for rows fetched = 0 OR x_first_trans = true
1134: IF rows_fetched = 0 THEN
1135: IF (g_asn_debug = 'Y') THEN
1136: asn_debug.put_line('No rows were retrieved from cursor.');

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

1151: temp_cascaded_table.DELETE(i);
1152: END LOOP;
1153: END IF;
1154:
1155: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1156: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);
1157: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
1158: END IF; --} ends row fetched > 0 and not first transaction
1159:

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

1152: END LOOP;
1153: END IF;
1154:
1155: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1156: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);
1157: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
1158: END IF; --} ends row fetched > 0 and not first transaction
1159:
1160: -- all the rows in the temp cascaded table

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

1153: END IF;
1154:
1155: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;
1156: rcv_error_pkg.set_error_message('RCV_TP_INVALID_TRX_TYPE', x_cascaded_table(n).error_message);
1157: rcv_error_pkg.log_interface_error('PARENT_TRANSACTION_ID');
1158: END IF; --} ends row fetched > 0 and not first transaction
1159:
1160: -- all the rows in the temp cascaded table
1161: -- will be deleted

Line 1587: WHEN rcv_error_pkg.e_fatal_error THEN

1583: IF (g_asn_debug = 'Y') THEN
1584: asn_debug.put_line('exit derive_io_rcv_line_qty');
1585: END IF;
1586: EXCEPTION
1587: WHEN rcv_error_pkg.e_fatal_error THEN
1588: IF shipments%ISOPEN THEN
1589: CLOSE shipments;
1590: END IF;
1591:

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

1600: IF count_shipments%ISOPEN THEN
1601: CLOSE count_shipments;
1602: END IF;
1603:
1604: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);
1605: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1606: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1607:
1608: IF (g_asn_debug = 'Y') THEN

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

1601: CLOSE count_shipments;
1602: END IF;
1603:
1604: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);
1605: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1606: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1607:
1608: IF (g_asn_debug = 'Y') THEN
1609: asn_debug.put_line(TO_CHAR(n));

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

1602: END IF;
1603:
1604: rcv_error_pkg.set_sql_error_message('derive_io_rcv_line_qty', x_progress);
1605: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_unexp_error;
1606: x_cascaded_table(n).error_message := rcv_error_pkg.get_last_message;
1607:
1608: IF (g_asn_debug = 'Y') THEN
1609: asn_debug.put_line(TO_CHAR(n));
1610: asn_debug.put_line(SQLERRM);