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_CHARGES_GRP dependencies on RCV_CHARGES_INTERFACE

Line 44: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

40: RETURN g_base_volume_uom;
41: END get_base_volume_uom;
42:
43: PROCEDURE Derive_Cost_Factor
44: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
45: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
46: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
47: ) IS
48: BEGIN

Line 62: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

58: END IF;
59: END Derive_Cost_Factor;
60:
61: Procedure default_vendor_info
62: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
63: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
64: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
65: ) IS
66: BEGIN

Line 93: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

89: END IF;
90: END;
91:
92: Procedure default_currency_info
93: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
94: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
95: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
96: ) IS
97: BEGIN

Line 119: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

115: END;
116:
117: -- make sure cost factor is defined in cost factor setup.
118: Procedure Validate_cost_factor
119: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
120: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
121: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
122: ) IS
123: BEGIN

Line 137: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'

133: rcv_error_pkg.set_error_message('RCV_INVALID_ROI_VALUE');
134: rcv_error_pkg.set_token('COLUMN', 'COST_FACTOR_ID');
135: rcv_error_pkg.set_token('ROI_VALUE', p_charge_record.cost_factor_id);
136: rcv_error_pkg.set_token('SYS_VALUE', '');
137: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'
138: , 'COST_FACTOR_ID'
139: , FALSE
140: );
141:

Line 148: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

144: END;
145:
146: -- validate vendor_id and vendor_site_id exist.
147: Procedure Validate_vendor_info
148: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
149: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
150: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
151: ) IS
152: l_vendor_record RCV_SHIPMENT_HEADER_SV.vendorrectype;

Line 174: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'

170: IF l_vendor_record.error_record.error_message = 'VEN_DISABLED' THEN
171: asn_debug.put_line('Invalid vendor id: ' || p_charge_record.vendor_id);
172: rcv_error_pkg.set_error_message('PO_PDOI_INVALID_VENDOR');
173: rcv_error_pkg.set_token('VALUE', l_vendor_record.vendor_id);
174: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'
175: , 'VENDOR_ID'
176: , FALSE
177: );
178: ELSIF l_vendor_record.error_record.error_message = 'VEN_HOLD' THEN

Line 182: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'

178: ELSIF l_vendor_record.error_record.error_message = 'VEN_HOLD' THEN
179: asn_debug.put_line('Invalid vendor id: ' || p_charge_record.vendor_id);
180: rcv_error_pkg.set_error_message('PO_PO_VENDOR_ON_HOLD');
181: rcv_error_pkg.set_token('VALUE', l_vendor_record.vendor_id);
182: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'
183: , 'VENDOR_ID'
184: , FALSE
185: );
186: ELSIF l_vendor_record.error_record.error_message = 'VEN_ID' THEN

Line 190: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'

186: ELSIF l_vendor_record.error_record.error_message = 'VEN_ID' THEN
187: asn_debug.put_line('Invalid vendor id: ' || p_charge_record.vendor_id);
188: rcv_error_pkg.set_error_message('RCV_VEN_ID');
189: rcv_error_pkg.set_token('SUPPLIER', l_vendor_record.vendor_id);
190: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'
191: , 'VENDOR_ID'
192: , FALSE
193: );
194: END IF;

Line 201: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

197: END IF;
198: END Validate_vendor_info;
199:
200: Procedure Validate_vendor_site_info
201: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
202: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
203: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
204: ) IS
205: l_vendor_site_record RCV_SHIPMENT_HEADER_SV.vendorsiterectype;

Line 241: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

237: END Validate_vendor_site_info;
238:
239: -- validate positive amount
240: Procedure Validate_amount
241: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
242: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
243: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
244: ) IS
245: BEGIN

Line 255: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'

251: rcv_error_pkg.set_error_message('RCV_ROI_INVALID_VALUE');
252: rcv_error_pkg.set_token('COLUMN', 'AMOUNT');
253: rcv_error_pkg.set_token('ROI_VALUE', p_charge_record.amount);
254: rcv_error_pkg.set_token('SYS_VALUE', 'a positive value');
255: rcv_error_pkg.log_interface_error( 'RCV_CHARGES_INTERFACE'
256: , 'ESTIMATED_AMOUNT'
257: , FALSE);
258:
259: p_charge_record.processing_status_code := 'E';

Line 265: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

261: END;
262:
263: -- validate currency code exists in system
264: Procedure Validate_currency_info
265: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
266: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
267: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
268: ) IS
269: l_currency_record rcv_shipment_header_sv.currectype;

Line 295: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

291: END IF;
292: END;
293:
294: Procedure Derive_Charge_Info
295: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
296: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
297: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
298: ) IS
299: BEGIN

Line 307: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

303: );
304: END Derive_Charge_Info;
305:
306: Procedure Default_charge_info
307: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
308: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
309: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
310: ) IS
311: BEGIN

Line 317: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

313: default_currency_info(p_charge_record, p_header_record, p_transaction_record);
314: END;
315:
316: Procedure Validate_charge_info
317: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
318: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
319: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
320: ) IS
321: BEGIN

Line 338: UPDATE rcv_charges_interface

334: l_interface_charge_id_tbl(i) := p_charge_interface_table(i).interface_charge_id;
335: END LOOP;
336:
337: FORALL i IN 1..p_charge_interface_table.COUNT
338: UPDATE rcv_charges_interface
339: SET ROW = p_charge_interface_table(i)
340: WHERE interface_charge_id = l_interface_charge_id_tbl(i);
341: END Update_Interface_Charges;
342:

Line 344: ( p_charge_interface IN rcv_charges_interface%ROWTYPE

340: WHERE interface_charge_id = l_interface_charge_id_tbl(i);
341: END Update_Interface_Charges;
342:
343: Procedure Add_Charge_From_Interface
344: ( p_charge_interface IN rcv_charges_interface%ROWTYPE
345: , p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type
346: , p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
347: , p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
348: ) IS

Line 873: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE

869: asn_debug.put_line('Done allocating charges');
870: END Allocate_Charges;
871:
872: Procedure Preprocess_Charge_Line
873: ( p_charge_record IN OUT NOCOPY rcv_charges_interface%ROWTYPE
874: , p_header_record IN RCV_ROI_PREPROCESSOR.headers_cur%ROWTYPE
875: , p_transaction_record IN RCV_ROI_PREPROCESSOR.txns_cur%ROWTYPE
876: ) IS
877: BEGIN

Line 902: FROM rcv_charges_interface

898:
899: --fetch relevant charges into the temporary charge interface table
900: SELECT *
901: BULK COLLECT INTO l_charge_interface_table
902: FROM rcv_charges_interface
903: WHERE ( parent_header_interface_id = p_transaction_record.header_interface_id OR
904: parent_interface_id = p_transaction_record.interface_transaction_id
905: )
906: AND processing_status_code = 'P'

Line 939: -- Update the preprocessed charge interface data on rcv_charges_interface.

935: END LOOP;
936:
937: asn_debug.put_line('Done preprocessing, updating RCI');
938:
939: -- Update the preprocessed charge interface data on rcv_charges_interface.
940: Update_Interface_Charges(l_charge_interface_table);
941:
942: asn_debug.put_line('Done preprocessing charges');
943: EXCEPTION

Line 976: FROM rcv_charges_interface

972:
973: -- fetch relevant charges into the temporary charge interface table
974: SELECT *
975: BULK COLLECT INTO l_charge_interface_table
976: FROM rcv_charges_interface
977: WHERE ( parent_interface_id = p_rti_id
978: OR ( parent_header_interface_id = p_rhi_id
979: AND parent_interface_id IS NULL
980: AND NOT EXISTS (

Line 1054: -- update rcv_charges_interface with status code

1050: VALUES l_charge_allocation_table(i);
1051:
1052: asn_debug.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into PO_RCV_CHARGE_ALLOCATIONS');
1053:
1054: -- update rcv_charges_interface with status code
1055: Update_Interface_Charges(l_charge_interface_table);
1056:
1057: -- delete all successfully processed rows from interfacet table
1058: DELETE FROM rcv_charges_interface

Line 1058: DELETE FROM rcv_charges_interface

1054: -- update rcv_charges_interface with status code
1055: Update_Interface_Charges(l_charge_interface_table);
1056:
1057: -- delete all successfully processed rows from interfacet table
1058: DELETE FROM rcv_charges_interface
1059: WHERE transaction_status_code IN ('S','W');
1060:
1061: asn_debug.put_line('Deleted ' || SQL%ROWCOUNT || ' successful rows from rcv_charges_interface');
1062:

Line 1061: asn_debug.put_line('Deleted ' || SQL%ROWCOUNT || ' successful rows from rcv_charges_interface');

1057: -- delete all successfully processed rows from interfacet table
1058: DELETE FROM rcv_charges_interface
1059: WHERE transaction_status_code IN ('S','W');
1060:
1061: asn_debug.put_line('Deleted ' || SQL%ROWCOUNT || ' successful rows from rcv_charges_interface');
1062:
1063: asn_debug.put_line('Done processing charges');
1064: EXCEPTION
1065: WHEN OTHERS THEN