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.PO_CHARGES_GRP dependencies on ASN_DEBUG

Line 9: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PO_CHARGES_GRP';
6: G_LOG_MODULE CONSTANT VARCHAR2(40) := 'po.plsql.' || G_PKG_NAME;
7: G_CONC_LOG VARCHAR2(32767);
8:
9: g_asn_debug VARCHAR2(1) := NVL(fnd_profile.VALUE('RCV_DEBUG_MODE'), 'N');
10: g_fte_cost_factor_details pon_price_element_types_vl%ROWTYPE:= pon_cf_type_grp.get_cost_factor_details('ORACLE_FTE_COST');
11: g_dummy_rci_tbl RCV_CHARGES_GRP.charge_interface_table_type;
12: g_charge_numbers NUMBER;
13:

Line 16: -- wrapper for asn_debug

12: g_charge_numbers NUMBER;
13:
14: -- Private support procedures
15:
16: -- wrapper for asn_debug
17: PROCEDURE string
18: ( log_level IN number
19: , module IN varchar2
20: , message IN varchar2

Line 24: asn_debug.put_line(module||': '||message,log_level);

20: , message IN varchar2
21: ) IS
22: BEGIN
23: -- add to fnd_log_messages
24: asn_debug.put_line(module||': '||message,log_level);
25: END string;
26:
27: -- helper function for testing if a line has been rated in FTE
28: FUNCTION shipment_line_fte_rated(p_shipment_line_id NUMBER) RETURN BOOLEAN IS

Line 62: IF (g_asn_debug = 'Y') THEN

58: l_cost_factor_details PON_PRICE_ELEMENT_TYPES_VL%ROWTYPE;
59: k NUMBER;
60: BEGIN
61:
62: IF (g_asn_debug = 'Y') THEN
63: asn_debug.put_line('Entering Capture_QP_Charges() for group_id:' || p_group_id
64: || ' and request_id:'|| p_request_id);
65: END IF;
66: k := 1;

Line 63: asn_debug.put_line('Entering Capture_QP_Charges() for group_id:' || p_group_id

59: k NUMBER;
60: BEGIN
61:
62: IF (g_asn_debug = 'Y') THEN
63: asn_debug.put_line('Entering Capture_QP_Charges() for group_id:' || p_group_id
64: || ' and request_id:'|| p_request_id);
65: END IF;
66: k := 1;
67: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 102: IF (g_asn_debug = 'Y') THEN

98: AND rsh.receipt_source_code = 'VENDOR'
99: AND rsh.ship_to_org_id = rp.organization_id
100: AND rp.advanced_pricing = 'Y');
101:
102: IF (g_asn_debug = 'Y') THEN
103: asn_debug.put_line('Number of shipment headers retrieved for QP:' || l_rsh_id_table.count);
104: END IF;
105:
106: IF l_rsh_id_table.count < 1 THEN

Line 103: asn_debug.put_line('Number of shipment headers retrieved for QP:' || l_rsh_id_table.count);

99: AND rsh.ship_to_org_id = rp.organization_id
100: AND rp.advanced_pricing = 'Y');
101:
102: IF (g_asn_debug = 'Y') THEN
103: asn_debug.put_line('Number of shipment headers retrieved for QP:' || l_rsh_id_table.count);
104: END IF;
105:
106: IF l_rsh_id_table.count < 1 THEN
107: IF (g_asn_debug = 'Y') THEN

Line 107: IF (g_asn_debug = 'Y') THEN

103: asn_debug.put_line('Number of shipment headers retrieved for QP:' || l_rsh_id_table.count);
104: END IF;
105:
106: IF l_rsh_id_table.count < 1 THEN
107: IF (g_asn_debug = 'Y') THEN
108: asn_debug.put_line('No shipment found for QP charges -> Return.');
109: END IF;
110: RETURN;
111: END IF;

Line 108: asn_debug.put_line('No shipment found for QP charges -> Return.');

104: END IF;
105:
106: IF l_rsh_id_table.count < 1 THEN
107: IF (g_asn_debug = 'Y') THEN
108: asn_debug.put_line('No shipment found for QP charges -> Return.');
109: END IF;
110: RETURN;
111: END IF;
112:

Line 115: IF (g_asn_debug = 'Y') THEN

111: END IF;
112:
113: FOR i IN l_rsh_id_table.FIRST..l_rsh_id_table.LAST LOOP --{
114:
115: IF (g_asn_debug = 'Y') THEN
116: asn_debug.put_line('Inside QP rsh loop for rsh_id_tbl('||i||'): '|| l_rsh_id_table(i));
117: END IF;
118:
119: DECLARE

Line 116: asn_debug.put_line('Inside QP rsh loop for rsh_id_tbl('||i||'): '|| l_rsh_id_table(i));

112:
113: FOR i IN l_rsh_id_table.FIRST..l_rsh_id_table.LAST LOOP --{
114:
115: IF (g_asn_debug = 'Y') THEN
116: asn_debug.put_line('Inside QP rsh loop for rsh_id_tbl('||i||'): '|| l_rsh_id_table(i));
117: END IF;
118:
119: DECLARE
120: l_header_rec PO_ADVANCED_PRICE_PVT.Header_Rec_Type;

Line 138: IF (g_asn_debug = 'Y') THEN

134: l_qp_charge_exception EXCEPTION;
135: BEGIN
136: l_rsh_id := l_rsh_id_table(i);
137:
138: IF (g_asn_debug = 'Y') THEN
139: asn_debug.put_line('Populating l_header_rec');
140: END IF;
141: -- populate l_header_rec
142: SELECT PO_MOAC_UTILS_PVT.get_current_org_id,

Line 139: asn_debug.put_line('Populating l_header_rec');

135: BEGIN
136: l_rsh_id := l_rsh_id_table(i);
137:
138: IF (g_asn_debug = 'Y') THEN
139: asn_debug.put_line('Populating l_header_rec');
140: END IF;
141: -- populate l_header_rec
142: SELECT PO_MOAC_UTILS_PVT.get_current_org_id,
143: NULL, --p_order_header_id

Line 168: IF (g_asn_debug = 'Y') THEN

164: INTO l_header_rec
165: FROM rcv_shipment_headers
166: WHERE shipment_header_id = l_rsh_id;
167:
168: IF (g_asn_debug = 'Y') THEN
169: asn_debug.put_line('Populating l_line_rec');
170: END IF;
171: -- populate l_line_rec_table
172: -- Passing Vendor_id and vendor_site_id so that line level modifiers with qualifiers will be applied.

Line 169: asn_debug.put_line('Populating l_line_rec');

165: FROM rcv_shipment_headers
166: WHERE shipment_header_id = l_rsh_id;
167:
168: IF (g_asn_debug = 'Y') THEN
169: asn_debug.put_line('Populating l_line_rec');
170: END IF;
171: -- populate l_line_rec_table
172: -- Passing Vendor_id and vendor_site_id so that line level modifiers with qualifiers will be applied.
173: SELECT NULL, --order_line_id

Line 209: IF (g_asn_debug = 'Y') THEN

205: AND nvl(plla.lcm_flag,'N') = 'N'; -- lcm changes
206:
207: -- lcm changes
208: IF (l_line_rec_table.COUNT = 0) THEN
209: IF (g_asn_debug = 'Y') THEN
210: asn_debug.put_line('No shipment line found for QP charges -> Return.');
211: END IF;
212: RETURN;
213: END IF;

Line 210: asn_debug.put_line('No shipment line found for QP charges -> Return.');

206:
207: -- lcm changes
208: IF (l_line_rec_table.COUNT = 0) THEN
209: IF (g_asn_debug = 'Y') THEN
210: asn_debug.put_line('No shipment line found for QP charges -> Return.');
211: END IF;
212: RETURN;
213: END IF;
214:

Line 218: IF (g_asn_debug = 'Y') THEN

214:
215: -- Bug 4776006: Use the currency_code of the first receipt line
216: -- if there is no currency defined on receipt header level.
217: IF l_header_rec.currency_code IS NULL THEN
218: IF (g_asn_debug = 'Y') THEN
219: asn_debug.put_line('Use first receipt line currency_code: '
220: || l_line_rec_table(1).currency_code);
221: END IF;
222: l_header_rec.currency_code := l_line_rec_table(1).currency_code;

Line 219: asn_debug.put_line('Use first receipt line currency_code: '

215: -- Bug 4776006: Use the currency_code of the first receipt line
216: -- if there is no currency defined on receipt header level.
217: IF l_header_rec.currency_code IS NULL THEN
218: IF (g_asn_debug = 'Y') THEN
219: asn_debug.put_line('Use first receipt line currency_code: '
220: || l_line_rec_table(1).currency_code);
221: END IF;
222: l_header_rec.currency_code := l_line_rec_table(1).currency_code;
223: END IF;

Line 225: IF (g_asn_debug = 'Y') THEN

221: END IF;
222: l_header_rec.currency_code := l_line_rec_table(1).currency_code;
223: END IF;
224:
225: IF (g_asn_debug = 'Y') THEN
226: asn_debug.put_line('Calling PO_ADVANCED_PRICE_PVT.get_advanced_price');
227: END IF;
228:
229: --PO_LOG.enable_logging();

Line 226: asn_debug.put_line('Calling PO_ADVANCED_PRICE_PVT.get_advanced_price');

222: l_header_rec.currency_code := l_line_rec_table(1).currency_code;
223: END IF;
224:
225: IF (g_asn_debug = 'Y') THEN
226: asn_debug.put_line('Calling PO_ADVANCED_PRICE_PVT.get_advanced_price');
227: END IF;
228:
229: --PO_LOG.enable_logging();
230:

Line 242: IF (g_asn_debug = 'Y') THEN

238: ,p_return_freight_flag => TRUE
239: ,x_price_tbl => l_qp_cost_table
240: ,x_return_status => l_return_status);
241:
242: IF (g_asn_debug = 'Y') THEN
243: asn_debug.put_line('l_return_status: '|| l_return_status);
244: END IF;
245:
246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 243: asn_debug.put_line('l_return_status: '|| l_return_status);

239: ,x_price_tbl => l_qp_cost_table
240: ,x_return_status => l_return_status);
241:
242: IF (g_asn_debug = 'Y') THEN
243: asn_debug.put_line('l_return_status: '|| l_return_status);
244: END IF;
245:
246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
247: RAISE l_qp_api_exception;

Line 254: IF (g_asn_debug = 'Y') THEN

250: IF l_qp_cost_table.count < 1 THEN
251: RAISE l_no_qp_charge;
252: END IF;
253:
254: IF (g_asn_debug = 'Y') THEN
255: asn_debug.put_line('Number of lines in l_qp_cost_table: ' ||l_qp_cost_table.count);
256: END IF;
257:
258: l_currency_code := l_header_rec.currency_code;

Line 255: asn_debug.put_line('Number of lines in l_qp_cost_table: ' ||l_qp_cost_table.count);

251: RAISE l_no_qp_charge;
252: END IF;
253:
254: IF (g_asn_debug = 'Y') THEN
255: asn_debug.put_line('Number of lines in l_qp_cost_table: ' ||l_qp_cost_table.count);
256: END IF;
257:
258: l_currency_code := l_header_rec.currency_code;
259:

Line 266: IF (g_asn_debug = 'Y') THEN

262: l_line_quantities(l_line_rec_table(l).shipment_line_id) := NVL(l_line_rec_table(l).quantity, 1);
263: END LOOP;
264:
265: FOR j IN l_qp_cost_table.FIRST..l_qp_cost_table.LAST LOOP --{
266: IF (g_asn_debug = 'Y') THEN
267: asn_debug.put_line('Retrieving freight charges from l_qp_cost_table('||j||').'
268: ||' with line_id = '|| l_qp_cost_table(j).line_id);
269: END IF;
270:

Line 267: asn_debug.put_line('Retrieving freight charges from l_qp_cost_table('||j||').'

263: END LOOP;
264:
265: FOR j IN l_qp_cost_table.FIRST..l_qp_cost_table.LAST LOOP --{
266: IF (g_asn_debug = 'Y') THEN
267: asn_debug.put_line('Retrieving freight charges from l_qp_cost_table('||j||').'
268: ||' with line_id = '|| l_qp_cost_table(j).line_id);
269: END IF;
270:
271: BEGIN --{ line loop block

Line 278: IF (g_asn_debug = 'Y') THEN

274: END IF;
275:
276: IF l_qp_cost_table(j).line_id <> l_rsh_id THEN
277: l_rsl_id := l_qp_cost_table(j).line_id;
278: IF (g_asn_debug = 'Y') THEN
279: asn_debug.put_line('This is a line level charge.');
280: END IF;
281: ELSE
282: IF (g_asn_debug = 'Y') THEN

Line 279: asn_debug.put_line('This is a line level charge.');

275:
276: IF l_qp_cost_table(j).line_id <> l_rsh_id THEN
277: l_rsl_id := l_qp_cost_table(j).line_id;
278: IF (g_asn_debug = 'Y') THEN
279: asn_debug.put_line('This is a line level charge.');
280: END IF;
281: ELSE
282: IF (g_asn_debug = 'Y') THEN
283: asn_debug.put_line('This is a header level charge.');

Line 282: IF (g_asn_debug = 'Y') THEN

278: IF (g_asn_debug = 'Y') THEN
279: asn_debug.put_line('This is a line level charge.');
280: END IF;
281: ELSE
282: IF (g_asn_debug = 'Y') THEN
283: asn_debug.put_line('This is a header level charge.');
284: END IF;
285: END IF;
286:

Line 283: asn_debug.put_line('This is a header level charge.');

279: asn_debug.put_line('This is a line level charge.');
280: END IF;
281: ELSE
282: IF (g_asn_debug = 'Y') THEN
283: asn_debug.put_line('This is a header level charge.');
284: END IF;
285: END IF;
286:
287: l_freight_charge_tbl := l_qp_cost_table(j).freight_charge_rec_tbl;

Line 289: IF (g_asn_debug = 'Y') THEN

285: END IF;
286:
287: l_freight_charge_tbl := l_qp_cost_table(j).freight_charge_rec_tbl;
288: FOR n IN l_freight_charge_tbl.FIRST..l_freight_charge_tbl.LAST LOOP --{
289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Getting cost factor detail for cost_factor_id '
291: ||l_freight_charge_tbl(n).charge_type_code);
292: END IF;
293: l_cost_factor_details :=

Line 290: asn_debug.put_line('Getting cost factor detail for cost_factor_id '

286:
287: l_freight_charge_tbl := l_qp_cost_table(j).freight_charge_rec_tbl;
288: FOR n IN l_freight_charge_tbl.FIRST..l_freight_charge_tbl.LAST LOOP --{
289: IF (g_asn_debug = 'Y') THEN
290: asn_debug.put_line('Getting cost factor detail for cost_factor_id '
291: ||l_freight_charge_tbl(n).charge_type_code);
292: END IF;
293: l_cost_factor_details :=
294: pon_cf_type_grp.get_cost_factor_details(TO_NUMBER(l_freight_charge_tbl(n).charge_type_code));

Line 300: IF (g_asn_debug = 'Y') THEN

296: SELECT po_rcv_charges_s.NEXTVAL
297: INTO l_charge_table(k).charge_id
298: FROM dual;
299:
300: IF (g_asn_debug = 'Y') THEN
301: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);
302: END IF;
303:
304: l_charge_table(k).creation_date := SYSDATE;

Line 301: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);

297: INTO l_charge_table(k).charge_id
298: FROM dual;
299:
300: IF (g_asn_debug = 'Y') THEN
301: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);
302: END IF;
303:
304: l_charge_table(k).creation_date := SYSDATE;
305: l_charge_table(k).created_by := FND_GLOBAL.user_id;

Line 334: IF (g_asn_debug = 'Y') THEN

330: l_charge_table(k).cost_component_class_id := l_cost_factor_details.cost_component_class_id;
331: l_charge_table(k).cost_analysis_code := l_cost_factor_details.cost_analysis_code;
332: l_charge_table(k).include_in_acquisition_cost := l_cost_factor_details.cost_acquisition_code;--Bug#6821589
333:
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('After populating charge_table(:' || k || ')');
336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );

Line 335: asn_debug.put_line('After populating charge_table(:' || k || ')');

331: l_charge_table(k).cost_analysis_code := l_cost_factor_details.cost_analysis_code;
332: l_charge_table(k).include_in_acquisition_cost := l_cost_factor_details.cost_acquisition_code;--Bug#6821589
333:
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('After populating charge_table(:' || k || ')');
336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );

Line 336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );

332: l_charge_table(k).include_in_acquisition_cost := l_cost_factor_details.cost_acquisition_code;--Bug#6821589
333:
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('After populating charge_table(:' || k || ')');
336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );

Line 337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );

333:
334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('After populating charge_table(:' || k || ')');
336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );

Line 338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );

334: IF (g_asn_debug = 'Y') THEN
335: asn_debug.put_line('After populating charge_table(:' || k || ')');
336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );

Line 339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );

335: asn_debug.put_line('After populating charge_table(:' || k || ')');
336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );

Line 340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );

336: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
344: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589

Line 341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );

337: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
344: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
345: END IF;

Line 342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );

338: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
344: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
345: END IF;
346: k := k + 1; --increment k for every new charge record

Line 343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );

339: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
344: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
345: END IF;
346: k := k + 1; --increment k for every new charge record
347: END LOOP; --} end of l_freight_charge_tbl loop

Line 344: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589

340: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
341: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
342: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
343: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
344: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
345: END IF;
346: k := k + 1; --increment k for every new charge record
347: END LOOP; --} end of l_freight_charge_tbl loop
348: EXCEPTION

Line 350: IF (g_asn_debug = 'Y') THEN

346: k := k + 1; --increment k for every new charge record
347: END LOOP; --} end of l_freight_charge_tbl loop
348: EXCEPTION
349: WHEN l_no_freight_charge THEN
350: IF (g_asn_debug = 'Y') THEN
351: asn_debug.put_line('No QP charge for the line : ' ||l_qp_cost_table(j).line_id);
352: END IF;
353: END; --} end of line loop block
354: END LOOP; --} end of qp_cost_table loop

Line 351: asn_debug.put_line('No QP charge for the line : ' ||l_qp_cost_table(j).line_id);

347: END LOOP; --} end of l_freight_charge_tbl loop
348: EXCEPTION
349: WHEN l_no_freight_charge THEN
350: IF (g_asn_debug = 'Y') THEN
351: asn_debug.put_line('No QP charge for the line : ' ||l_qp_cost_table(j).line_id);
352: END IF;
353: END; --} end of line loop block
354: END LOOP; --} end of qp_cost_table loop
355: EXCEPTION

Line 357: IF (g_asn_debug = 'Y') THEN

353: END; --} end of line loop block
354: END LOOP; --} end of qp_cost_table loop
355: EXCEPTION
356: WHEN l_no_qp_charge THEN
357: IF (g_asn_debug = 'Y') THEN
358: asn_debug.put_line('No QP charge for shipment header: ' ||l_rsh_id_table(i) );
359: END IF;
360: WHEN l_qp_api_exception THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;

Line 358: asn_debug.put_line('No QP charge for shipment header: ' ||l_rsh_id_table(i) );

354: END LOOP; --} end of qp_cost_table loop
355: EXCEPTION
356: WHEN l_no_qp_charge THEN
357: IF (g_asn_debug = 'Y') THEN
358: asn_debug.put_line('No QP charge for shipment header: ' ||l_rsh_id_table(i) );
359: END IF;
360: WHEN l_qp_api_exception THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: IF (g_asn_debug = 'Y') THEN

Line 362: IF (g_asn_debug = 'Y') THEN

358: asn_debug.put_line('No QP charge for shipment header: ' ||l_rsh_id_table(i) );
359: END IF;
360: WHEN l_qp_api_exception THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: IF (g_asn_debug = 'Y') THEN
363: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );
364: END IF;
365: WHEN others THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 363: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );

359: END IF;
360: WHEN l_qp_api_exception THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: IF (g_asn_debug = 'Y') THEN
363: asn_debug.put_line('QP API returned error for shipment_id: ' ||l_rsh_id_table(i) );
364: END IF;
365: WHEN others THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: x_msg_data := sqlerrm;

Line 368: IF (g_asn_debug = 'Y') THEN

364: END IF;
365: WHEN others THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: x_msg_data := sqlerrm;
368: IF (g_asn_debug = 'Y') THEN
369: asn_debug.put_line('Unexpected exception occured in QP loop: '|| x_msg_data);
370: END IF;
371:
372: END;

Line 369: asn_debug.put_line('Unexpected exception occured in QP loop: '|| x_msg_data);

365: WHEN others THEN
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: x_msg_data := sqlerrm;
368: IF (g_asn_debug = 'Y') THEN
369: asn_debug.put_line('Unexpected exception occured in QP loop: '|| x_msg_data);
370: END IF;
371:
372: END;
373: END LOOP; --} end of rsh_id_table loop

Line 375: IF (g_asn_debug = 'Y') THEN

371:
372: END;
373: END LOOP; --} end of rsh_id_table loop
374:
375: IF (g_asn_debug = 'Y') THEN
376: asn_debug.put_line('Total number of QP charges retrieved: ' || l_charge_table.COUNT );
377: END IF;
378:
379: -- Allocate all the QP charges

Line 376: asn_debug.put_line('Total number of QP charges retrieved: ' || l_charge_table.COUNT );

372: END;
373: END LOOP; --} end of rsh_id_table loop
374:
375: IF (g_asn_debug = 'Y') THEN
376: asn_debug.put_line('Total number of QP charges retrieved: ' || l_charge_table.COUNT );
377: END IF;
378:
379: -- Allocate all the QP charges
380: -- QP charges can be header level or line level

Line 388: IF (g_asn_debug = 'Y') THEN

384: FORALL i IN INDICES OF l_charge_table
385: INSERT INTO po_rcv_charges
386: VALUES l_charge_table(i);
387:
388: IF (g_asn_debug = 'Y') THEN
389: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charges');
390: END IF;
391:
392: -- bulk insert po_rcv_charge_allocations from the charge table

Line 389: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charges');

385: INSERT INTO po_rcv_charges
386: VALUES l_charge_table(i);
387:
388: IF (g_asn_debug = 'Y') THEN
389: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charges');
390: END IF;
391:
392: -- bulk insert po_rcv_charge_allocations from the charge table
393: FORALL i IN INDICES OF l_charge_alloc_table

Line 397: IF (g_asn_debug = 'Y') THEN

393: FORALL i IN INDICES OF l_charge_alloc_table
394: INSERT INTO po_rcv_charge_allocations
395: VALUES l_charge_alloc_table(i);
396:
397: IF (g_asn_debug = 'Y') THEN
398: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charge_allocations');
399: END IF;
400:
401: EXCEPTION

Line 398: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charge_allocations');

394: INSERT INTO po_rcv_charge_allocations
395: VALUES l_charge_alloc_table(i);
396:
397: IF (g_asn_debug = 'Y') THEN
398: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charge_allocations');
399: END IF;
400:
401: EXCEPTION
402: WHEN OTHERS THEN

Line 405: IF (g_asn_debug = 'Y') THEN

401: EXCEPTION
402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_data := sqlerrm;
405: IF (g_asn_debug = 'Y') THEN
406: asn_debug.put_line('Unexpected exception occured in Capture_QP_Charges(): '|| x_msg_data);
407: END IF;
408: END Capture_QP_Charges; --}
409:

Line 406: asn_debug.put_line('Unexpected exception occured in Capture_QP_Charges(): '|| x_msg_data);

402: WHEN OTHERS THEN
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_data := sqlerrm;
405: IF (g_asn_debug = 'Y') THEN
406: asn_debug.put_line('Unexpected exception occured in Capture_QP_Charges(): '|| x_msg_data);
407: END IF;
408: END Capture_QP_Charges; --}
409:
410: PROCEDURE Capture_FTE_Estimated_Charges

Line 431: IF (g_asn_debug = 'Y') THEN

427: k NUMBER;
428:
429: BEGIN
430:
431: IF (g_asn_debug = 'Y') THEN
432: asn_debug.put_line('Entering Capture_FTE_Estimated_Charges for group_id:' || p_group_id
433: || ' and request_id:'|| p_request_id);
434: END IF;
435:

Line 432: asn_debug.put_line('Entering Capture_FTE_Estimated_Charges for group_id:' || p_group_id

428:
429: BEGIN
430:
431: IF (g_asn_debug = 'Y') THEN
432: asn_debug.put_line('Entering Capture_FTE_Estimated_Charges for group_id:' || p_group_id
433: || ' and request_id:'|| p_request_id);
434: END IF;
435:
436: k := 1;

Line 454: IF (g_asn_debug = 'Y') THEN

450: AND rp.transportation_execution = 'Y'
451: AND rt.po_line_location_id = pll.line_location_id
452: AND nvl(pll.lcm_flag, 'N') = 'N';
453:
454: IF (g_asn_debug = 'Y') THEN
455: asn_debug.put_line('Number of shipment headers retreived:' || l_rsh_id_table.COUNT);
456: END IF;
457:
458: IF l_rsh_id_table.count < 1 THEN

Line 455: asn_debug.put_line('Number of shipment headers retreived:' || l_rsh_id_table.COUNT);

451: AND rt.po_line_location_id = pll.line_location_id
452: AND nvl(pll.lcm_flag, 'N') = 'N';
453:
454: IF (g_asn_debug = 'Y') THEN
455: asn_debug.put_line('Number of shipment headers retreived:' || l_rsh_id_table.COUNT);
456: END IF;
457:
458: IF l_rsh_id_table.count < 1 THEN
459: IF (g_asn_debug = 'Y') THEN

Line 459: IF (g_asn_debug = 'Y') THEN

455: asn_debug.put_line('Number of shipment headers retreived:' || l_rsh_id_table.COUNT);
456: END IF;
457:
458: IF l_rsh_id_table.count < 1 THEN
459: IF (g_asn_debug = 'Y') THEN
460: asn_debug.put_line('No shipment found for FTE charges -> Return.');
461: END IF;
462: RETURN;
463: END IF;

Line 460: asn_debug.put_line('No shipment found for FTE charges -> Return.');

456: END IF;
457:
458: IF l_rsh_id_table.count < 1 THEN
459: IF (g_asn_debug = 'Y') THEN
460: asn_debug.put_line('No shipment found for FTE charges -> Return.');
461: END IF;
462: RETURN;
463: END IF;
464:

Line 467: IF (g_asn_debug = 'Y') THEN

463: END IF;
464:
465: FOR i IN 1..l_rsh_id_table.COUNT LOOP --{
466:
467: IF (g_asn_debug = 'Y') THEN
468: asn_debug.put_line('Inside FTE rsh loop for rsh_id_tbl('||i||'): '|| l_rsh_id_table(i));
469: END IF;
470:
471: DECLARE

Line 468: asn_debug.put_line('Inside FTE rsh loop for rsh_id_tbl('||i||'): '|| l_rsh_id_table(i));

464:
465: FOR i IN 1..l_rsh_id_table.COUNT LOOP --{
466:
467: IF (g_asn_debug = 'Y') THEN
468: asn_debug.put_line('Inside FTE rsh loop for rsh_id_tbl('||i||'): '|| l_rsh_id_table(i));
469: END IF;
470:
471: DECLARE
472: l_return_status VARCHAR2(1);

Line 492: IF (g_asn_debug = 'Y') THEN

488: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
489: RAISE l_fte_exception;
490: END IF;
491:
492: IF (g_asn_debug = 'Y') THEN
493: asn_debug.put_line('Numbers of FTE charges fetched for this rsh: '|| l_fte_cost_table.count);
494: END IF;
495:
496: IF l_fte_cost_table.count < 1 THEN

Line 493: asn_debug.put_line('Numbers of FTE charges fetched for this rsh: '|| l_fte_cost_table.count);

489: RAISE l_fte_exception;
490: END IF;
491:
492: IF (g_asn_debug = 'Y') THEN
493: asn_debug.put_line('Numbers of FTE charges fetched for this rsh: '|| l_fte_cost_table.count);
494: END IF;
495:
496: IF l_fte_cost_table.count < 1 THEN
497: RAISE l_no_fte_charge;

Line 504: IF (g_asn_debug = 'Y') THEN

500: -- l_fte_cost_table is indexed by rsl_id
501: j:= l_fte_cost_table.FIRST;
502: WHILE j IS NOT NULL
503: LOOP --{
504: IF (g_asn_debug = 'Y') THEN
505: asn_debug.put_line('Processing charge for shipment line: ' ||j);
506: END IF;
507:
508: -- get the precision for rounding

Line 505: asn_debug.put_line('Processing charge for shipment line: ' ||j);

501: j:= l_fte_cost_table.FIRST;
502: WHILE j IS NOT NULL
503: LOOP --{
504: IF (g_asn_debug = 'Y') THEN
505: asn_debug.put_line('Processing charge for shipment line: ' ||j);
506: END IF;
507:
508: -- get the precision for rounding
509: DECLARE

Line 526: IF (g_asn_debug = 'Y') THEN

522: -- the amount is differnt than that on the original charge.
523: -- This handles partial receipt and add to receipt, where
524: -- currency and vendor remains the same as previous receipt.
525:
526: IF (g_asn_debug = 'Y') THEN
527: asn_debug.put_line('FTE charge exists for shipment_line: ' || j);
528: END IF;
529:
530: UPDATE po_rcv_charges

Line 527: asn_debug.put_line('FTE charge exists for shipment_line: ' || j);

523: -- This handles partial receipt and add to receipt, where
524: -- currency and vendor remains the same as previous receipt.
525:
526: IF (g_asn_debug = 'Y') THEN
527: asn_debug.put_line('FTE charge exists for shipment_line: ' || j);
528: END IF;
529:
530: UPDATE po_rcv_charges
531: SET estimated_amount = ROUND(l_fte_cost_table(j).total_cost, l_precision)

Line 535: IF (g_asn_debug = 'Y') THEN

531: SET estimated_amount = ROUND(l_fte_cost_table(j).total_cost, l_precision)
532: WHERE shipment_line_id = j
533: AND estimated_amount <> ROUND(l_fte_cost_table(j).total_cost, l_precision);
534:
535: IF (g_asn_debug = 'Y') THEN
536: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charges');
537: END IF;
538:
539: UPDATE po_rcv_charge_allocations

Line 536: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charges');

532: WHERE shipment_line_id = j
533: AND estimated_amount <> ROUND(l_fte_cost_table(j).total_cost, l_precision);
534:
535: IF (g_asn_debug = 'Y') THEN
536: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charges');
537: END IF;
538:
539: UPDATE po_rcv_charge_allocations
540: SET estimated_amount = ROUND(l_fte_cost_table(j).total_cost, l_precision)

Line 544: IF (g_asn_debug = 'Y') THEN

540: SET estimated_amount = ROUND(l_fte_cost_table(j).total_cost, l_precision)
541: WHERE shipment_line_id = j
542: AND estimated_amount <> ROUND(l_fte_cost_table(j).total_cost, l_precision);
543:
544: IF (g_asn_debug = 'Y') THEN
545: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');
546: END IF;
547: ELSE
548: IF (g_asn_debug = 'Y') THEN

Line 545: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');

541: WHERE shipment_line_id = j
542: AND estimated_amount <> ROUND(l_fte_cost_table(j).total_cost, l_precision);
543:
544: IF (g_asn_debug = 'Y') THEN
545: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');
546: END IF;
547: ELSE
548: IF (g_asn_debug = 'Y') THEN
549: asn_debug.put_line('Populating charge_table (' || k ||')');

Line 548: IF (g_asn_debug = 'Y') THEN

544: IF (g_asn_debug = 'Y') THEN
545: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');
546: END IF;
547: ELSE
548: IF (g_asn_debug = 'Y') THEN
549: asn_debug.put_line('Populating charge_table (' || k ||')');
550: END IF;
551:
552: SELECT po_rcv_charges_s.NEXTVAL

Line 549: asn_debug.put_line('Populating charge_table (' || k ||')');

545: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');
546: END IF;
547: ELSE
548: IF (g_asn_debug = 'Y') THEN
549: asn_debug.put_line('Populating charge_table (' || k ||')');
550: END IF;
551:
552: SELECT po_rcv_charges_s.NEXTVAL
553: INTO l_charge_table(k).charge_id

Line 556: IF (g_asn_debug = 'Y') THEN

552: SELECT po_rcv_charges_s.NEXTVAL
553: INTO l_charge_table(k).charge_id
554: FROM dual;
555:
556: IF (g_asn_debug = 'Y') THEN
557: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);
558: END IF;
559:
560: l_charge_table(k).creation_date := SYSDATE;

Line 557: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);

553: INTO l_charge_table(k).charge_id
554: FROM dual;
555:
556: IF (g_asn_debug = 'Y') THEN
557: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);
558: END IF;
559:
560: l_charge_table(k).creation_date := SYSDATE;
561: l_charge_table(k).created_by := FND_GLOBAL.user_id;

Line 577: IF (g_asn_debug = 'Y') THEN

573: l_charge_table(k).cost_analysis_code := g_fte_cost_factor_details.cost_analysis_code;
574: l_charge_table(k).include_in_acquisition_cost := g_fte_cost_factor_details.cost_acquisition_code;--Bug#6821589
575: l_charge_table(k).estimated_amount := ROUND(l_fte_cost_table(j).total_cost, l_precision);
576:
577: IF (g_asn_debug = 'Y') THEN
578: asn_debug.put_line('currency_precision: ' || l_precision);
579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );

Line 578: asn_debug.put_line('currency_precision: ' || l_precision);

574: l_charge_table(k).include_in_acquisition_cost := g_fte_cost_factor_details.cost_acquisition_code;--Bug#6821589
575: l_charge_table(k).estimated_amount := ROUND(l_fte_cost_table(j).total_cost, l_precision);
576:
577: IF (g_asn_debug = 'Y') THEN
578: asn_debug.put_line('currency_precision: ' || l_precision);
579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );

Line 579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );

575: l_charge_table(k).estimated_amount := ROUND(l_fte_cost_table(j).total_cost, l_precision);
576:
577: IF (g_asn_debug = 'Y') THEN
578: asn_debug.put_line('currency_precision: ' || l_precision);
579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);

Line 580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );

576:
577: IF (g_asn_debug = 'Y') THEN
578: asn_debug.put_line('currency_precision: ' || l_precision);
579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);

Line 581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );

577: IF (g_asn_debug = 'Y') THEN
578: asn_debug.put_line('currency_precision: ' || l_precision);
579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );

Line 582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );

578: asn_debug.put_line('currency_precision: ' || l_precision);
579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );

Line 583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);

579: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );

Line 584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);

580: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );

Line 585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );

581: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589

Line 586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );

582: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
590: END IF;

Line 587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );

583: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
590: END IF;
591:

Line 588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );

584: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
590: END IF;
591:
592: IF (g_asn_debug = 'Y') THEN

Line 589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589

585: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
586: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
587: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
590: END IF;
591:
592: IF (g_asn_debug = 'Y') THEN
593: asn_debug.put_line('Done populating charge_table (' || k || ')');

Line 592: IF (g_asn_debug = 'Y') THEN

588: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
590: END IF;
591:
592: IF (g_asn_debug = 'Y') THEN
593: asn_debug.put_line('Done populating charge_table (' || k || ')');
594: END IF;
595:
596: k := k + 1;

Line 593: asn_debug.put_line('Done populating charge_table (' || k || ')');

589: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
590: END IF;
591:
592: IF (g_asn_debug = 'Y') THEN
593: asn_debug.put_line('Done populating charge_table (' || k || ')');
594: END IF;
595:
596: k := k + 1;
597: END IF;

Line 602: IF (g_asn_debug = 'Y') THEN

598: j := l_fte_cost_table.NEXT(j);
599: END LOOP; --} end of fte_cost_table loop
600: EXCEPTION
601: WHEN l_no_fte_charge THEN
602: IF (g_asn_debug = 'Y') THEN
603: asn_debug.put_line('No FTE charges retreived for shipment_id: '||l_rsh_id_table(i));
604: END IF;
605: WHEN l_fte_exception THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;

Line 603: asn_debug.put_line('No FTE charges retreived for shipment_id: '||l_rsh_id_table(i));

599: END LOOP; --} end of fte_cost_table loop
600: EXCEPTION
601: WHEN l_no_fte_charge THEN
602: IF (g_asn_debug = 'Y') THEN
603: asn_debug.put_line('No FTE charges retreived for shipment_id: '||l_rsh_id_table(i));
604: END IF;
605: WHEN l_fte_exception THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_msg_data := l_msg_data;

Line 608: IF (g_asn_debug = 'Y') THEN

604: END IF;
605: WHEN l_fte_exception THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_msg_data := l_msg_data;
608: IF (g_asn_debug = 'Y') THEN
609: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );
610: END IF;
611: WHEN others THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 609: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );

605: WHEN l_fte_exception THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: x_msg_data := l_msg_data;
608: IF (g_asn_debug = 'Y') THEN
609: asn_debug.put_line('FTE API failed for shipment_id: '||l_rsh_id_table(i)||'. msg_data: '|| l_msg_data );
610: END IF;
611: WHEN others THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: x_msg_data := sqlerrm;

Line 614: IF (g_asn_debug = 'Y') THEN

610: END IF;
611: WHEN others THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: x_msg_data := sqlerrm;
614: IF (g_asn_debug = 'Y') THEN
615: asn_debug.put_line('Unexpected exception occured in FTE loop: '|| x_msg_data);
616: END IF;
617: END;
618: END LOOP; --} end of rsh_id_table loop

Line 615: asn_debug.put_line('Unexpected exception occured in FTE loop: '|| x_msg_data);

611: WHEN others THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: x_msg_data := sqlerrm;
614: IF (g_asn_debug = 'Y') THEN
615: asn_debug.put_line('Unexpected exception occured in FTE loop: '|| x_msg_data);
616: END IF;
617: END;
618: END LOOP; --} end of rsh_id_table loop
619:

Line 620: IF (g_asn_debug = 'Y') THEN

616: END IF;
617: END;
618: END LOOP; --} end of rsh_id_table loop
619:
620: IF (g_asn_debug = 'Y') THEN
621: asn_debug.put_line('Total number of FTE charges retrieved: ' || l_charge_table.COUNT );
622: END IF;
623:
624: -- Allocate all the FTE charges

Line 621: asn_debug.put_line('Total number of FTE charges retrieved: ' || l_charge_table.COUNT );

617: END;
618: END LOOP; --} end of rsh_id_table loop
619:
620: IF (g_asn_debug = 'Y') THEN
621: asn_debug.put_line('Total number of FTE charges retrieved: ' || l_charge_table.COUNT );
622: END IF;
623:
624: -- Allocate all the FTE charges
625: -- FTE charges are always line level charges

Line 633: IF (g_asn_debug = 'Y') THEN

629: FORALL i IN INDICES OF l_charge_table
630: INSERT INTO po_rcv_charges
631: VALUES l_charge_table(i);
632:
633: IF (g_asn_debug = 'Y') THEN
634: asn_debug.put_line('Done bulk insert into po_rcv_charges');
635: END IF;
636:
637: -- bulk insert po_rcv_charge_allocations from the charge table

Line 634: asn_debug.put_line('Done bulk insert into po_rcv_charges');

630: INSERT INTO po_rcv_charges
631: VALUES l_charge_table(i);
632:
633: IF (g_asn_debug = 'Y') THEN
634: asn_debug.put_line('Done bulk insert into po_rcv_charges');
635: END IF;
636:
637: -- bulk insert po_rcv_charge_allocations from the charge table
638: FORALL i IN INDICES OF l_charge_alloc_table

Line 642: IF (g_asn_debug = 'Y') THEN

638: FORALL i IN INDICES OF l_charge_alloc_table
639: INSERT INTO po_rcv_charge_allocations
640: VALUES l_charge_alloc_table(i);
641:
642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
644: END IF;
645:
646: IF (g_asn_debug = 'Y') THEN

Line 643: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

639: INSERT INTO po_rcv_charge_allocations
640: VALUES l_charge_alloc_table(i);
641:
642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
644: END IF;
645:
646: IF (g_asn_debug = 'Y') THEN
647: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');

Line 646: IF (g_asn_debug = 'Y') THEN

642: IF (g_asn_debug = 'Y') THEN
643: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
644: END IF;
645:
646: IF (g_asn_debug = 'Y') THEN
647: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');
648: END IF;
649: EXCEPTION
650: WHEN OTHERS THEN

Line 647: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');

643: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
644: END IF;
645:
646: IF (g_asn_debug = 'Y') THEN
647: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');
648: END IF;
649: EXCEPTION
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 653: IF (g_asn_debug = 'Y') THEN

649: EXCEPTION
650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: x_msg_data := sqlerrm;
653: IF (g_asn_debug = 'Y') THEN
654: asn_debug.put_line('Unexpected exception occured in Capture_FTE_Estimated_Charges(): ' || x_msg_data);
655: END IF;
656: END Capture_FTE_Estimated_Charges;
657:

Line 654: asn_debug.put_line('Unexpected exception occured in Capture_FTE_Estimated_Charges(): ' || x_msg_data);

650: WHEN OTHERS THEN
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: x_msg_data := sqlerrm;
653: IF (g_asn_debug = 'Y') THEN
654: asn_debug.put_line('Unexpected exception occured in Capture_FTE_Estimated_Charges(): ' || x_msg_data);
655: END IF;
656: END Capture_FTE_Estimated_Charges;
657:
658: -- capture the actual freight charge for each shipment_line upon bill approval

Line 675: IF (g_asn_debug = 'Y') THEN

671: l_fte_actual_charge_allocs CHARGE_ALLOCATION_TABLE_TYPE;
672: l_invalid_shipment EXCEPTION;
673:
674: BEGIN
675: IF (g_asn_debug = 'Y') THEN
676: asn_debug.put_line('Entering Capture_FTE_Actual_Charges()');
677: END IF;
678:
679: SAVEPOINT PO_FTE_ACTUAL;

Line 676: asn_debug.put_line('Entering Capture_FTE_Actual_Charges()');

672: l_invalid_shipment EXCEPTION;
673:
674: BEGIN
675: IF (g_asn_debug = 'Y') THEN
676: asn_debug.put_line('Entering Capture_FTE_Actual_Charges()');
677: END IF;
678:
679: SAVEPOINT PO_FTE_ACTUAL;
680:

Line 687: IF (g_asn_debug = 'Y') THEN

683: THEN
684: FND_MSG_PUB.initialize;
685: END IF;
686:
687: IF (g_asn_debug = 'Y') THEN
688: asn_debug.put_line('Initialized FND message');
689: END IF;
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 688: asn_debug.put_line('Initialized FND message');

684: FND_MSG_PUB.initialize;
685: END IF;
686:
687: IF (g_asn_debug = 'Y') THEN
688: asn_debug.put_line('Initialized FND message');
689: END IF;
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: x_msg_count := 0;

Line 695: IF (g_asn_debug = 'Y') THEN

691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692: x_msg_count := 0;
693: x_msg_data := '';
694:
695: IF (g_asn_debug = 'Y') THEN
696: asn_debug.put_line('Data passed in by FTE');
697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );

Line 696: asn_debug.put_line('Data passed in by FTE');

692: x_msg_count := 0;
693: x_msg_data := '';
694:
695: IF (g_asn_debug = 'Y') THEN
696: asn_debug.put_line('Data passed in by FTE');
697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);

Line 697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );

693: x_msg_data := '';
694:
695: IF (g_asn_debug = 'Y') THEN
696: asn_debug.put_line('Data passed in by FTE');
697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);
701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);

Line 698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );

694:
695: IF (g_asn_debug = 'Y') THEN
696: asn_debug.put_line('Data passed in by FTE');
697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);
701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);
702: asn_debug.put_line('cost_factor_id: ' || g_fte_cost_factor_details.price_element_type_id);

Line 699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );

695: IF (g_asn_debug = 'Y') THEN
696: asn_debug.put_line('Data passed in by FTE');
697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);
701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);
702: asn_debug.put_line('cost_factor_id: ' || g_fte_cost_factor_details.price_element_type_id);
703: END IF;

Line 700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);

696: asn_debug.put_line('Data passed in by FTE');
697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);
701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);
702: asn_debug.put_line('cost_factor_id: ' || g_fte_cost_factor_details.price_element_type_id);
703: END IF;
704:

Line 701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);

697: asn_debug.put_line('shipment_line_id: ' || p_fte_actual_charge.shipment_line_id );
698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);
701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);
702: asn_debug.put_line('cost_factor_id: ' || g_fte_cost_factor_details.price_element_type_id);
703: END IF;
704:
705: -- The actual charge is a previously FTE-estimated charge if:

Line 702: asn_debug.put_line('cost_factor_id: ' || g_fte_cost_factor_details.price_element_type_id);

698: asn_debug.put_line('actual_amount: ' || p_fte_actual_charge.actual_amount );
699: asn_debug.put_line('currency_code: ' || p_fte_actual_charge.currency_code );
700: asn_debug.put_line('vendor_id: ' || p_fte_actual_charge.vendor_id);
701: asn_debug.put_line('vendor_site_id: ' || p_fte_actual_charge.vendor_site_id);
702: asn_debug.put_line('cost_factor_id: ' || g_fte_cost_factor_details.price_element_type_id);
703: END IF;
704:
705: -- The actual charge is a previously FTE-estimated charge if:
706: -- shipment_line_id matches an existing FTE charge

Line 721: IF (g_asn_debug = 'Y') THEN

717: AND NVL(vendor_site_id, p_fte_actual_charge.vendor_site_id)
718: = p_fte_actual_charge.vendor_site_id;
719:
720:
721: IF (g_asn_debug = 'Y') THEN
722: asn_debug.put_line('New FTE Charge? : ' || l_new_fte_charge);
723: END IF;
724:
725: -- For existing FTE charges, update the charge with the actual cost.

Line 722: asn_debug.put_line('New FTE Charge? : ' || l_new_fte_charge);

718: = p_fte_actual_charge.vendor_site_id;
719:
720:
721: IF (g_asn_debug = 'Y') THEN
722: asn_debug.put_line('New FTE Charge? : ' || l_new_fte_charge);
723: END IF;
724:
725: -- For existing FTE charges, update the charge with the actual cost.
726: IF l_new_fte_charge = 'N' THEN

Line 728: IF (g_asn_debug = 'Y') THEN

724:
725: -- For existing FTE charges, update the charge with the actual cost.
726: IF l_new_fte_charge = 'N' THEN
727:
728: IF (g_asn_debug = 'Y') THEN
729: asn_debug.put_line('Updating PO_RCV_CHARGES with actual amount: '
730: || p_fte_actual_charge.actual_amount);
731: END IF;
732:

Line 729: asn_debug.put_line('Updating PO_RCV_CHARGES with actual amount: '

725: -- For existing FTE charges, update the charge with the actual cost.
726: IF l_new_fte_charge = 'N' THEN
727:
728: IF (g_asn_debug = 'Y') THEN
729: asn_debug.put_line('Updating PO_RCV_CHARGES with actual amount: '
730: || p_fte_actual_charge.actual_amount);
731: END IF;
732:
733: UPDATE po_rcv_charges

Line 739: IF (g_asn_debug = 'Y') THEN

735: , vendor_id = NVL(vendor_id, p_fte_actual_charge.vendor_id)
736: , vendor_site_id = NVL(vendor_site_id, p_fte_actual_charge.vendor_site_id)
737: WHERE shipment_line_id = p_fte_actual_charge.shipment_line_id;
738:
739: IF (g_asn_debug = 'Y') THEN
740: asn_debug.put_line('Updating PO_RCV_CHARGE_ALLOCATIONS with actual amount'||
741: p_fte_actual_charge.actual_amount);
742: END IF;
743:

Line 740: asn_debug.put_line('Updating PO_RCV_CHARGE_ALLOCATIONS with actual amount'||

736: , vendor_site_id = NVL(vendor_site_id, p_fte_actual_charge.vendor_site_id)
737: WHERE shipment_line_id = p_fte_actual_charge.shipment_line_id;
738:
739: IF (g_asn_debug = 'Y') THEN
740: asn_debug.put_line('Updating PO_RCV_CHARGE_ALLOCATIONS with actual amount'||
741: p_fte_actual_charge.actual_amount);
742: END IF;
743:
744: UPDATE po_rcv_charge_allocations

Line 748: IF (g_asn_debug = 'Y') THEN

744: UPDATE po_rcv_charge_allocations
745: SET actual_amount = p_fte_actual_charge.actual_amount
746: WHERE shipment_line_id = p_fte_actual_charge.shipment_line_id;
747:
748: IF (g_asn_debug = 'Y') THEN
749: asn_debug.put_line('Done updating actual amounts for existing charge');
750: END IF;
751: -- For new charges, populate new rows in po_rcv_charges and po_rcv_charge_allocations.
752: ELSE

Line 749: asn_debug.put_line('Done updating actual amounts for existing charge');

745: SET actual_amount = p_fte_actual_charge.actual_amount
746: WHERE shipment_line_id = p_fte_actual_charge.shipment_line_id;
747:
748: IF (g_asn_debug = 'Y') THEN
749: asn_debug.put_line('Done updating actual amounts for existing charge');
750: END IF;
751: -- For new charges, populate new rows in po_rcv_charges and po_rcv_charge_allocations.
752: ELSE
753: IF (g_asn_debug = 'Y') THEN

Line 753: IF (g_asn_debug = 'Y') THEN

749: asn_debug.put_line('Done updating actual amounts for existing charge');
750: END IF;
751: -- For new charges, populate new rows in po_rcv_charges and po_rcv_charge_allocations.
752: ELSE
753: IF (g_asn_debug = 'Y') THEN
754: asn_debug.put_line('This is a new charge');
755: END IF;
756:
757: l_fte_actual_charges(1) := p_fte_actual_charge;

Line 754: asn_debug.put_line('This is a new charge');

750: END IF;
751: -- For new charges, populate new rows in po_rcv_charges and po_rcv_charge_allocations.
752: ELSE
753: IF (g_asn_debug = 'Y') THEN
754: asn_debug.put_line('This is a new charge');
755: END IF;
756:
757: l_fte_actual_charges(1) := p_fte_actual_charge;
758:

Line 783: IF (g_asn_debug = 'Y') THEN

779: l_fte_actual_charges(1).cost_component_class_id := g_fte_cost_factor_details.cost_component_class_id;
780: l_fte_actual_charges(1).cost_analysis_code := g_fte_cost_factor_details.cost_analysis_code;
781: l_fte_actual_charges(1).include_in_acquisition_cost := g_fte_cost_factor_details.cost_acquisition_code;--Bug#6821589
782:
783: IF (g_asn_debug = 'Y') THEN
784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );
785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );

Line 784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );

780: l_fte_actual_charges(1).cost_analysis_code := g_fte_cost_factor_details.cost_analysis_code;
781: l_fte_actual_charges(1).include_in_acquisition_cost := g_fte_cost_factor_details.cost_acquisition_code;--Bug#6821589
782:
783: IF (g_asn_debug = 'Y') THEN
784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );
785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);

Line 785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );

781: l_fte_actual_charges(1).include_in_acquisition_cost := g_fte_cost_factor_details.cost_acquisition_code;--Bug#6821589
782:
783: IF (g_asn_debug = 'Y') THEN
784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );
785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);

Line 786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );

782:
783: IF (g_asn_debug = 'Y') THEN
784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );
785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );

Line 787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );

783: IF (g_asn_debug = 'Y') THEN
784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );
785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );

Line 788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);

784: asn_debug.put_line('shipment_header_id: ' || l_fte_actual_charges(1).shipment_header_id );
785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );

Line 789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);

785: asn_debug.put_line('shipment_line_id: ' || l_fte_actual_charges(1).shipment_line_id );
786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );
793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );

Line 790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );

786: asn_debug.put_line('actual_amount: ' || l_fte_actual_charges(1).actual_amount );
787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );
793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );
794: asn_debug.put_line('include_in_acquisition_cost: ' || l_fte_actual_charges(1).include_in_acquisition_cost );--Bug#6821589

Line 791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );

787: asn_debug.put_line('currency_code: ' || l_fte_actual_charges(1).currency_code );
788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );
793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );
794: asn_debug.put_line('include_in_acquisition_cost: ' || l_fte_actual_charges(1).include_in_acquisition_cost );--Bug#6821589
795: END IF;

Line 792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );

788: asn_debug.put_line('vendor_id: ' || l_fte_actual_charges(1).vendor_id);
789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );
793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );
794: asn_debug.put_line('include_in_acquisition_cost: ' || l_fte_actual_charges(1).include_in_acquisition_cost );--Bug#6821589
795: END IF;
796:

Line 793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );

789: asn_debug.put_line('vendor_site_id: ' || l_fte_actual_charges(1).vendor_site_id);
790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );
793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );
794: asn_debug.put_line('include_in_acquisition_cost: ' || l_fte_actual_charges(1).include_in_acquisition_cost );--Bug#6821589
795: END IF;
796:
797: RCV_CHARGES_GRP.Allocate_charges(l_fte_actual_charges, l_fte_actual_charge_allocs, g_dummy_rci_tbl);

Line 794: asn_debug.put_line('include_in_acquisition_cost: ' || l_fte_actual_charges(1).include_in_acquisition_cost );--Bug#6821589

790: asn_debug.put_line('cost_factor_id: ' || l_fte_actual_charges(1).cost_factor_id );
791: asn_debug.put_line('allocation_method: ' ||l_fte_actual_charges(1).allocation_method );
792: asn_debug.put_line('cost_component_class_id: ' || l_fte_actual_charges(1).cost_component_class_id );
793: asn_debug.put_line('cost_analysis_code: ' || l_fte_actual_charges(1).cost_analysis_code );
794: asn_debug.put_line('include_in_acquisition_cost: ' || l_fte_actual_charges(1).include_in_acquisition_cost );--Bug#6821589
795: END IF;
796:
797: RCV_CHARGES_GRP.Allocate_charges(l_fte_actual_charges, l_fte_actual_charge_allocs, g_dummy_rci_tbl);
798:

Line 805: IF (g_asn_debug = 'Y') THEN

801: FORALL i in 1..l_fte_actual_charges.COUNT
802: INSERT INTO po_rcv_charges
803: VALUES l_fte_actual_charges(i);
804:
805: IF (g_asn_debug = 'Y') THEN
806: asn_debug.put_line('Done bulk insert into po_rcv_charges');
807: END IF;
808:
809: -- bulk insert po_rcv_charge_allocations from the charge table

Line 806: asn_debug.put_line('Done bulk insert into po_rcv_charges');

802: INSERT INTO po_rcv_charges
803: VALUES l_fte_actual_charges(i);
804:
805: IF (g_asn_debug = 'Y') THEN
806: asn_debug.put_line('Done bulk insert into po_rcv_charges');
807: END IF;
808:
809: -- bulk insert po_rcv_charge_allocations from the charge table
810: FORALL i IN 1..l_fte_actual_charge_allocs.COUNT

Line 814: IF (g_asn_debug = 'Y') THEN

810: FORALL i IN 1..l_fte_actual_charge_allocs.COUNT
811: INSERT INTO po_rcv_charge_allocations
812: VALUES l_fte_actual_charge_allocs(i);
813:
814: IF (g_asn_debug = 'Y') THEN
815: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
816: END IF;
817:
818: END IF;

Line 815: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

811: INSERT INTO po_rcv_charge_allocations
812: VALUES l_fte_actual_charge_allocs(i);
813:
814: IF (g_asn_debug = 'Y') THEN
815: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
816: END IF;
817:
818: END IF;
819:

Line 831: IF (g_asn_debug = 'Y') THEN

827: EXCEPTION
828: WHEN l_invalid_shipment THEN
829: x_msg_data := 'Invalid Shipment';
830: x_return_status:= FND_API.G_RET_STS_ERROR;
831: IF (g_asn_debug = 'Y') THEN
832: asn_debug.put_line('Invalid shipment.' );
833: END IF;
834: WHEN OTHERS THEN
835: ROLLBACK TO PO_FTE_ACTUAL;

Line 832: asn_debug.put_line('Invalid shipment.' );

828: WHEN l_invalid_shipment THEN
829: x_msg_data := 'Invalid Shipment';
830: x_return_status:= FND_API.G_RET_STS_ERROR;
831: IF (g_asn_debug = 'Y') THEN
832: asn_debug.put_line('Invalid shipment.' );
833: END IF;
834: WHEN OTHERS THEN
835: ROLLBACK TO PO_FTE_ACTUAL;
836: x_msg_data := sqlerrm;

Line 838: IF (g_asn_debug = 'Y') THEN

834: WHEN OTHERS THEN
835: ROLLBACK TO PO_FTE_ACTUAL;
836: x_msg_data := sqlerrm;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: IF (g_asn_debug = 'Y') THEN
839: asn_debug.put_line('Unexpected error in Capture_FTE_Actual_Charges(), err_msg:'
840: || x_msg_data);
841: END IF;
842: END Capture_FTE_Actual_Charges;

Line 839: asn_debug.put_line('Unexpected error in Capture_FTE_Actual_Charges(), err_msg:'

835: ROLLBACK TO PO_FTE_ACTUAL;
836: x_msg_data := sqlerrm;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: IF (g_asn_debug = 'Y') THEN
839: asn_debug.put_line('Unexpected error in Capture_FTE_Actual_Charges(), err_msg:'
840: || x_msg_data);
841: END IF;
842: END Capture_FTE_Actual_Charges;
843:

Line 860: IF (g_asn_debug = 'Y') THEN

856: G_CONC_LOG := '';
857: g_charge_numbers := 0;
858: k := 1;
859:
860: IF (g_asn_debug = 'Y') THEN
861: asn_debug.put_line('Entering extract AP charges program.');
862: END IF;
863:
864:

Line 861: asn_debug.put_line('Entering extract AP charges program.');

857: g_charge_numbers := 0;
858: k := 1;
859:
860: IF (g_asn_debug = 'Y') THEN
861: asn_debug.put_line('Entering extract AP charges program.');
862: END IF;
863:
864:
865: FOR l_ap_po_charge_distribution in po_charges_grp.ap_po_charge_distributions_csr LOOP --{

Line 867: IF (g_asn_debug = 'Y') THEN

863:
864:
865: FOR l_ap_po_charge_distribution in po_charges_grp.ap_po_charge_distributions_csr LOOP --{
866:
867: IF (g_asn_debug = 'Y') THEN
868: asn_debug.put_line('Inside the cursor loop.');
869: asn_debug.put_line('Charge cursor has '||
870: po_charges_grp.ap_po_charge_distributions_csr%rowcount||' rows.');
871: END IF;

Line 868: asn_debug.put_line('Inside the cursor loop.');

864:
865: FOR l_ap_po_charge_distribution in po_charges_grp.ap_po_charge_distributions_csr LOOP --{
866:
867: IF (g_asn_debug = 'Y') THEN
868: asn_debug.put_line('Inside the cursor loop.');
869: asn_debug.put_line('Charge cursor has '||
870: po_charges_grp.ap_po_charge_distributions_csr%rowcount||' rows.');
871: END IF;
872:

Line 869: asn_debug.put_line('Charge cursor has '||

865: FOR l_ap_po_charge_distribution in po_charges_grp.ap_po_charge_distributions_csr LOOP --{
866:
867: IF (g_asn_debug = 'Y') THEN
868: asn_debug.put_line('Inside the cursor loop.');
869: asn_debug.put_line('Charge cursor has '||
870: po_charges_grp.ap_po_charge_distributions_csr%rowcount||' rows.');
871: END IF;
872:
873: Process_AP_Actual_Charges(l_ap_po_charge_distribution,l_charge_table,

Line 879: IF (g_asn_debug = 'Y') THEN

875:
876: g_charge_numbers := g_charge_numbers + 1;
877: END LOOP; --}
878:
879: IF (g_asn_debug = 'Y') THEN
880: asn_debug.put_line('After Loop ' || g_charge_numbers||
881: ' AP charges after l_ap_po_charge_distribution, '
882: ||l_charge_table.COUNT||' of them are new charges');
883: END IF;

Line 880: asn_debug.put_line('After Loop ' || g_charge_numbers||

876: g_charge_numbers := g_charge_numbers + 1;
877: END LOOP; --}
878:
879: IF (g_asn_debug = 'Y') THEN
880: asn_debug.put_line('After Loop ' || g_charge_numbers||
881: ' AP charges after l_ap_po_charge_distribution, '
882: ||l_charge_table.COUNT||' of them are new charges');
883: END IF;
884:

Line 888: IF (g_asn_debug = 'Y') THEN

884:
885:
886: FOR l_ap_rcv_charge_distribution in po_charges_grp.ap_rcv_charge_distr_csr LOOP --{
887:
888: IF (g_asn_debug = 'Y') THEN
889: asn_debug.put_line('Inside the cursor loop.');
890: asn_debug.put_line('Charge cursor has '||
891: po_charges_grp.ap_rcv_charge_distr_csr%rowcount||' rows.');
892: END IF;

Line 889: asn_debug.put_line('Inside the cursor loop.');

885:
886: FOR l_ap_rcv_charge_distribution in po_charges_grp.ap_rcv_charge_distr_csr LOOP --{
887:
888: IF (g_asn_debug = 'Y') THEN
889: asn_debug.put_line('Inside the cursor loop.');
890: asn_debug.put_line('Charge cursor has '||
891: po_charges_grp.ap_rcv_charge_distr_csr%rowcount||' rows.');
892: END IF;
893:

Line 890: asn_debug.put_line('Charge cursor has '||

886: FOR l_ap_rcv_charge_distribution in po_charges_grp.ap_rcv_charge_distr_csr LOOP --{
887:
888: IF (g_asn_debug = 'Y') THEN
889: asn_debug.put_line('Inside the cursor loop.');
890: asn_debug.put_line('Charge cursor has '||
891: po_charges_grp.ap_rcv_charge_distr_csr%rowcount||' rows.');
892: END IF;
893:
894: Process_AP_Actual_Charges(l_ap_rcv_charge_distribution,

Line 901: IF (g_asn_debug = 'Y') THEN

897: g_charge_numbers := g_charge_numbers + 1;
898: END LOOP; --}
899:
900:
901: IF (g_asn_debug = 'Y') THEN
902: asn_debug.put_line('After Loop ' || g_charge_numbers||
903: ' AP charges after l_ap_rcv_charge_distribution, '
904: ||l_charge_table.COUNT||' of them are new charges');
905: END IF;

Line 902: asn_debug.put_line('After Loop ' || g_charge_numbers||

898: END LOOP; --}
899:
900:
901: IF (g_asn_debug = 'Y') THEN
902: asn_debug.put_line('After Loop ' || g_charge_numbers||
903: ' AP charges after l_ap_rcv_charge_distribution, '
904: ||l_charge_table.COUNT||' of them are new charges');
905: END IF;
906:

Line 913: IF (g_asn_debug = 'Y') THEN

909: FORALL i IN 1..l_charge_table.COUNT
910: INSERT INTO po_rcv_charges
911: VALUES l_charge_table(i);
912:
913: IF (g_asn_debug = 'Y') THEN
914: asn_debug.put_line('Done bulk insert into po_rcv_charges');
915: END IF;
916:
917: -- bulk insert po_rcv_charge_allocations from the charge table

Line 914: asn_debug.put_line('Done bulk insert into po_rcv_charges');

910: INSERT INTO po_rcv_charges
911: VALUES l_charge_table(i);
912:
913: IF (g_asn_debug = 'Y') THEN
914: asn_debug.put_line('Done bulk insert into po_rcv_charges');
915: END IF;
916:
917: -- bulk insert po_rcv_charge_allocations from the charge table
918: FORALL i IN 1..l_charge_alloc_table.COUNT

Line 922: IF (g_asn_debug = 'Y') THEN

918: FORALL i IN 1..l_charge_alloc_table.COUNT
919: INSERT INTO po_rcv_charge_allocations
920: VALUES l_charge_alloc_table(i);
921:
922: IF (g_asn_debug = 'Y') THEN
923: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
924: END IF;
925:
926: -- generate summary report

Line 923: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

919: INSERT INTO po_rcv_charge_allocations
920: VALUES l_charge_alloc_table(i);
921:
922: IF (g_asn_debug = 'Y') THEN
923: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
924: END IF;
925:
926: -- generate summary report
927: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' ||

Line 936: IF (g_asn_debug = 'Y') THEN

932: -- send output to concurrent log
933: errbuf := G_CONC_LOG;
934: retcode := 0;
935:
936: IF (g_asn_debug = 'Y') THEN
937: asn_debug.put_line('AP extracting completed');
938: END IF;
939: EXCEPTION
940: WHEN OTHERS THEN

Line 937: asn_debug.put_line('AP extracting completed');

933: errbuf := G_CONC_LOG;
934: retcode := 0;
935:
936: IF (g_asn_debug = 'Y') THEN
937: asn_debug.put_line('AP extracting completed');
938: END IF;
939: EXCEPTION
940: WHEN OTHERS THEN
941: string( log_level => FND_LOG.LEVEL_UNEXPECTED

Line 970: IF (g_asn_debug = 'Y') THEN

966: l_new_ap_charge VARCHAR2(1) := 'Y';
967:
968: BEGIN
969:
970: IF (g_asn_debug = 'Y') THEN
971: asn_debug.put_line('Entering Process AP charges program.');
972: END IF;
973:
974: select sum(amount)

Line 971: asn_debug.put_line('Entering Process AP charges program.');

967:
968: BEGIN
969:
970: IF (g_asn_debug = 'Y') THEN
971: asn_debug.put_line('Entering Process AP charges program.');
972: END IF;
973:
974: select sum(amount)
975: into l_ap_charge_distribution.rec_tax

Line 987: IF (g_asn_debug = 'Y') THEN

983: line_type_lookup_code = 'NONREC_TAX' and
984: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
985:
986:
987: IF (g_asn_debug = 'Y') THEN
988: asn_debug.put_line('costfactor id '||l_ap_charge_distribution.cost_factor_id);
989: END IF;
990:
991: If (l_ap_charge_distribution.cost_factor_id = 0 ) then

Line 988: asn_debug.put_line('costfactor id '||l_ap_charge_distribution.cost_factor_id);

984: charge_applicable_to_dist_id = l_ap_charge_distribution.invoice_distribution_id;
985:
986:
987: IF (g_asn_debug = 'Y') THEN
988: asn_debug.put_line('costfactor id '||l_ap_charge_distribution.cost_factor_id);
989: END IF;
990:
991: If (l_ap_charge_distribution.cost_factor_id = 0 ) then
992: l_cost_factor_details := pon_cf_type_grp.get_cost_factor_details( l_ap_charge_distribution.cost_factor_code );

Line 997: IF (g_asn_debug = 'Y') THEN

993: else
994: l_cost_factor_details := pon_cf_type_grp.get_cost_factor_details( l_ap_charge_distribution.cost_factor_id );
995: end if;
996:
997: IF (g_asn_debug = 'Y') THEN
998: asn_debug.put_line('price_element_type_id id '||l_cost_factor_details.price_element_type_id);
999: END IF;
1000:
1001: SELECT decode(count(*), 0, 'Y', 'N')

Line 998: asn_debug.put_line('price_element_type_id id '||l_cost_factor_details.price_element_type_id);

994: l_cost_factor_details := pon_cf_type_grp.get_cost_factor_details( l_ap_charge_distribution.cost_factor_id );
995: end if;
996:
997: IF (g_asn_debug = 'Y') THEN
998: asn_debug.put_line('price_element_type_id id '||l_cost_factor_details.price_element_type_id);
999: END IF;
1000:
1001: SELECT decode(count(*), 0, 'Y', 'N')
1002: INTO l_new_ap_charge

Line 1011: IF (g_asn_debug = 'Y') THEN

1007: = l_ap_charge_distribution.vendor_id
1008: AND NVL(vendor_site_id, l_ap_charge_distribution.vendor_site_id)
1009: = l_ap_charge_distribution.vendor_site_id;
1010:
1011: IF (g_asn_debug = 'Y') THEN
1012: asn_debug.put_line('Is it a new AP charge? : ' || l_new_ap_charge);
1013: END IF;
1014:
1015: IF l_new_ap_charge = 'N' THEN --{

Line 1012: asn_debug.put_line('Is it a new AP charge? : ' || l_new_ap_charge);

1008: AND NVL(vendor_site_id, l_ap_charge_distribution.vendor_site_id)
1009: = l_ap_charge_distribution.vendor_site_id;
1010:
1011: IF (g_asn_debug = 'Y') THEN
1012: asn_debug.put_line('Is it a new AP charge? : ' || l_new_ap_charge);
1013: END IF;
1014:
1015: IF l_new_ap_charge = 'N' THEN --{
1016:

Line 1017: IF (g_asn_debug = 'Y') THEN

1013: END IF;
1014:
1015: IF l_new_ap_charge = 'N' THEN --{
1016:
1017: IF (g_asn_debug = 'Y') THEN
1018: asn_debug.put_line('Updating charge amount for existing charge');
1019: END IF;
1020:
1021: UPDATE po_rcv_charges

Line 1018: asn_debug.put_line('Updating charge amount for existing charge');

1014:
1015: IF l_new_ap_charge = 'N' THEN --{
1016:
1017: IF (g_asn_debug = 'Y') THEN
1018: asn_debug.put_line('Updating charge amount for existing charge');
1019: END IF;
1020:
1021: UPDATE po_rcv_charges
1022: SET actual_amount = nvl(actual_amount, 0) + l_ap_charge_distribution.amount

Line 1031: IF (g_asn_debug = 'Y') THEN

1027: WHERE cost_factor_id = l_cost_factor_details.price_element_type_id
1028: AND shipment_line_id = l_ap_charge_distribution.shipment_line_id
1029: RETURNING charge_id INTO l_charge_id;
1030:
1031: IF (g_asn_debug = 'Y') THEN
1032: asn_debug.put_line('Updated PRC (charge_id=' || l_charge_id || ') with amount'||l_ap_charge_distribution.amount);
1033: END IF;
1034:
1035: UPDATE po_rcv_charge_allocations

Line 1032: asn_debug.put_line('Updated PRC (charge_id=' || l_charge_id || ') with amount'||l_ap_charge_distribution.amount);

1028: AND shipment_line_id = l_ap_charge_distribution.shipment_line_id
1029: RETURNING charge_id INTO l_charge_id;
1030:
1031: IF (g_asn_debug = 'Y') THEN
1032: asn_debug.put_line('Updated PRC (charge_id=' || l_charge_id || ') with amount'||l_ap_charge_distribution.amount);
1033: END IF;
1034:
1035: UPDATE po_rcv_charge_allocations
1036: SET actual_amount = nvl(actual_amount,0) + l_ap_charge_distribution.amount

Line 1042: IF (g_asn_debug = 'Y') THEN

1038: , act_non_recoverable_tax = l_ap_charge_distribution.nonrec_tax
1039: WHERE shipment_line_id = l_ap_charge_distribution.shipment_line_id
1040: AND charge_id = l_charge_id;
1041:
1042: IF (g_asn_debug = 'Y') THEN
1043: asn_debug.put_line('Updated corresponding PRCA with amount '||l_ap_charge_distribution.amount);
1044: END IF;
1045: ELSE --}{
1046: IF (g_asn_debug = 'Y') THEN

Line 1043: asn_debug.put_line('Updated corresponding PRCA with amount '||l_ap_charge_distribution.amount);

1039: WHERE shipment_line_id = l_ap_charge_distribution.shipment_line_id
1040: AND charge_id = l_charge_id;
1041:
1042: IF (g_asn_debug = 'Y') THEN
1043: asn_debug.put_line('Updated corresponding PRCA with amount '||l_ap_charge_distribution.amount);
1044: END IF;
1045: ELSE --}{
1046: IF (g_asn_debug = 'Y') THEN
1047: asn_debug.put_line('Populating charge_table (' || k ||') for a new charge');

Line 1046: IF (g_asn_debug = 'Y') THEN

1042: IF (g_asn_debug = 'Y') THEN
1043: asn_debug.put_line('Updated corresponding PRCA with amount '||l_ap_charge_distribution.amount);
1044: END IF;
1045: ELSE --}{
1046: IF (g_asn_debug = 'Y') THEN
1047: asn_debug.put_line('Populating charge_table (' || k ||') for a new charge');
1048: END IF;
1049:
1050: SELECT po_rcv_charges_s.NEXTVAL

Line 1047: asn_debug.put_line('Populating charge_table (' || k ||') for a new charge');

1043: asn_debug.put_line('Updated corresponding PRCA with amount '||l_ap_charge_distribution.amount);
1044: END IF;
1045: ELSE --}{
1046: IF (g_asn_debug = 'Y') THEN
1047: asn_debug.put_line('Populating charge_table (' || k ||') for a new charge');
1048: END IF;
1049:
1050: SELECT po_rcv_charges_s.NEXTVAL
1051: INTO l_charge_table(k).charge_id

Line 1054: IF (g_asn_debug = 'Y') THEN

1050: SELECT po_rcv_charges_s.NEXTVAL
1051: INTO l_charge_table(k).charge_id
1052: FROM dual;
1053:
1054: IF (g_asn_debug = 'Y') THEN
1055: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);
1056: END IF;
1057:
1058: l_charge_table(k).creation_date := SYSDATE;

Line 1055: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);

1051: INTO l_charge_table(k).charge_id
1052: FROM dual;
1053:
1054: IF (g_asn_debug = 'Y') THEN
1055: asn_debug.put_line('charge_id: ' ||l_charge_table(k).charge_id);
1056: END IF;
1057:
1058: l_charge_table(k).creation_date := SYSDATE;
1059: l_charge_table(k).created_by := FND_GLOBAL.user_id;

Line 1079: IF (g_asn_debug = 'Y') THEN

1075:
1076: l_charge_table(k).actual_tax :=
1077: l_ap_charge_distribution.rec_tax + l_ap_charge_distribution.nonrec_tax;
1078:
1079: IF (g_asn_debug = 'Y') THEN
1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );

Line 1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );

1076: l_charge_table(k).actual_tax :=
1077: l_ap_charge_distribution.rec_tax + l_ap_charge_distribution.nonrec_tax;
1078:
1079: IF (g_asn_debug = 'Y') THEN
1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);

Line 1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );

1077: l_ap_charge_distribution.rec_tax + l_ap_charge_distribution.nonrec_tax;
1078:
1079: IF (g_asn_debug = 'Y') THEN
1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);

Line 1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );

1078:
1079: IF (g_asn_debug = 'Y') THEN
1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );

Line 1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );

1079: IF (g_asn_debug = 'Y') THEN
1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );

Line 1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);

1080: asn_debug.put_line('shipment_header_id: ' || l_charge_table(k).shipment_header_id );
1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );

Line 1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);

1081: asn_debug.put_line('shipment_line_id: ' || l_charge_table(k).shipment_line_id );
1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );

Line 1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );

1082: asn_debug.put_line('estimated_amount: ' || l_charge_table(k).estimated_amount );
1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589

Line 1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );

1083: asn_debug.put_line('currency_code: ' || l_charge_table(k).currency_code );
1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
1091: END IF;

Line 1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );

1084: asn_debug.put_line('vendor_id: ' || l_charge_table(k).vendor_id);
1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
1091: END IF;
1092:

Line 1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );

1085: asn_debug.put_line('vendor_site_id: ' || l_charge_table(k).vendor_site_id);
1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
1091: END IF;
1092:
1093: IF (g_asn_debug = 'Y') THEN

Line 1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589

1086: asn_debug.put_line('cost_factor_id: ' || l_charge_table(k).cost_factor_id );
1087: asn_debug.put_line('allocation_method: ' ||l_charge_table(k).allocation_method );
1088: asn_debug.put_line('cost_component_class_id: ' || l_charge_table(k).cost_component_class_id );
1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
1091: END IF;
1092:
1093: IF (g_asn_debug = 'Y') THEN
1094: asn_debug.put_line('Done populating charge_table (' || k || ')');

Line 1093: IF (g_asn_debug = 'Y') THEN

1089: asn_debug.put_line('cost_analysis_code: ' || l_charge_table(k).cost_analysis_code );
1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
1091: END IF;
1092:
1093: IF (g_asn_debug = 'Y') THEN
1094: asn_debug.put_line('Done populating charge_table (' || k || ')');
1095: END IF;
1096:
1097: SELECT po_rcv_charge_allocations_s.NEXTVAL

Line 1094: asn_debug.put_line('Done populating charge_table (' || k || ')');

1090: asn_debug.put_line('include_in_acquisition_cost: ' || l_charge_table(k).include_in_acquisition_cost );--Bug#6821589
1091: END IF;
1092:
1093: IF (g_asn_debug = 'Y') THEN
1094: asn_debug.put_line('Done populating charge_table (' || k || ')');
1095: END IF;
1096:
1097: SELECT po_rcv_charge_allocations_s.NEXTVAL
1098: INTO l_charge_alloc_table(k).charge_allocation_id

Line 1113: IF (g_asn_debug = 'Y') THEN

1109:
1110: l_charge_alloc_table(k).act_recoverable_tax := l_ap_charge_distribution.rec_tax;
1111: l_charge_alloc_table(k).act_non_recoverable_tax := l_ap_charge_distribution.nonrec_tax;
1112:
1113: IF (g_asn_debug = 'Y') THEN
1114: asn_debug.put_line('charge_allocation_id: ' || l_charge_alloc_table(k).charge_allocation_id);
1115: asn_debug.put_line('act_recoverable_tax: ' || l_charge_alloc_table(k).act_recoverable_tax);
1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);
1117: END IF;

Line 1114: asn_debug.put_line('charge_allocation_id: ' || l_charge_alloc_table(k).charge_allocation_id);

1110: l_charge_alloc_table(k).act_recoverable_tax := l_ap_charge_distribution.rec_tax;
1111: l_charge_alloc_table(k).act_non_recoverable_tax := l_ap_charge_distribution.nonrec_tax;
1112:
1113: IF (g_asn_debug = 'Y') THEN
1114: asn_debug.put_line('charge_allocation_id: ' || l_charge_alloc_table(k).charge_allocation_id);
1115: asn_debug.put_line('act_recoverable_tax: ' || l_charge_alloc_table(k).act_recoverable_tax);
1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);
1117: END IF;
1118:

Line 1115: asn_debug.put_line('act_recoverable_tax: ' || l_charge_alloc_table(k).act_recoverable_tax);

1111: l_charge_alloc_table(k).act_non_recoverable_tax := l_ap_charge_distribution.nonrec_tax;
1112:
1113: IF (g_asn_debug = 'Y') THEN
1114: asn_debug.put_line('charge_allocation_id: ' || l_charge_alloc_table(k).charge_allocation_id);
1115: asn_debug.put_line('act_recoverable_tax: ' || l_charge_alloc_table(k).act_recoverable_tax);
1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);
1117: END IF;
1118:
1119: IF (g_asn_debug = 'Y') THEN

Line 1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);

1112:
1113: IF (g_asn_debug = 'Y') THEN
1114: asn_debug.put_line('charge_allocation_id: ' || l_charge_alloc_table(k).charge_allocation_id);
1115: asn_debug.put_line('act_recoverable_tax: ' || l_charge_alloc_table(k).act_recoverable_tax);
1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);
1117: END IF;
1118:
1119: IF (g_asn_debug = 'Y') THEN
1120: asn_debug.put_line('Done populating charge_alloc_table (' || k || ')');

Line 1119: IF (g_asn_debug = 'Y') THEN

1115: asn_debug.put_line('act_recoverable_tax: ' || l_charge_alloc_table(k).act_recoverable_tax);
1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);
1117: END IF;
1118:
1119: IF (g_asn_debug = 'Y') THEN
1120: asn_debug.put_line('Done populating charge_alloc_table (' || k || ')');
1121: END IF;
1122:
1123: k := k + 1;

Line 1120: asn_debug.put_line('Done populating charge_alloc_table (' || k || ')');

1116: asn_debug.put_line('act_non_recoverable_tax: ' || l_charge_alloc_table(k).act_non_recoverable_tax);
1117: END IF;
1118:
1119: IF (g_asn_debug = 'Y') THEN
1120: asn_debug.put_line('Done populating charge_alloc_table (' || k || ')');
1121: END IF;
1122:
1123: k := k + 1;
1124:

Line 1125: IF (g_asn_debug = 'Y') THEN

1121: END IF;
1122:
1123: k := k + 1;
1124:
1125: IF (g_asn_debug = 'Y') THEN
1126: asn_debug.put_line('Created new charge and allocation record for new charge');
1127: END IF;
1128:
1129: END IF; --}

Line 1126: asn_debug.put_line('Created new charge and allocation record for new charge');

1122:
1123: k := k + 1;
1124:
1125: IF (g_asn_debug = 'Y') THEN
1126: asn_debug.put_line('Created new charge and allocation record for new charge');
1127: END IF;
1128:
1129: END IF; --}
1130:

Line 1137: IF (g_asn_debug = 'Y') THEN

1133: SET rcv_charge_addition_flag = 'Y'
1134: WHERE invoice_distribution_id = l_ap_charge_distribution.invoice_distribution_id;
1135:
1136:
1137: IF (g_asn_debug = 'Y') THEN
1138: asn_debug.put_line('Exit Process AP extracting completed');
1139: END IF;
1140:
1141: EXCEPTION

Line 1138: asn_debug.put_line('Exit Process AP extracting completed');

1134: WHERE invoice_distribution_id = l_ap_charge_distribution.invoice_distribution_id;
1135:
1136:
1137: IF (g_asn_debug = 'Y') THEN
1138: asn_debug.put_line('Exit Process AP extracting completed');
1139: END IF;
1140:
1141: EXCEPTION
1142: WHEN OTHERS THEN