DBA Data[Home] [Help]

APPS.CST_TPRICE_PVT dependencies on FND_FILE

Line 137: FND_FILE.put_line(FND_FILE.LOG, 'In procedure CST_TPRICE_PVT.Adjust_Acct');

133: OR mp.organization_id = p_txf_org_id;
134:
135:
136: if (G_DEBUG = 'Y') then
137: FND_FILE.put_line(FND_FILE.LOG, 'In procedure CST_TPRICE_PVT.Adjust_Acct');
138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);
139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);
140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);
141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);

Line 138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);

134:
135:
136: if (G_DEBUG = 'Y') then
137: FND_FILE.put_line(FND_FILE.LOG, 'In procedure CST_TPRICE_PVT.Adjust_Acct');
138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);
139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);
140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);
141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);
142: FND_FILE.put_line(FND_FILE.LOG, 'Internal Order invoicing = ' || l_io_invoicing);

Line 139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);

135:
136: if (G_DEBUG = 'Y') then
137: FND_FILE.put_line(FND_FILE.LOG, 'In procedure CST_TPRICE_PVT.Adjust_Acct');
138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);
139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);
140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);
141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);
142: FND_FILE.put_line(FND_FILE.LOG, 'Internal Order invoicing = ' || l_io_invoicing);
143: end if;

Line 140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);

136: if (G_DEBUG = 'Y') then
137: FND_FILE.put_line(FND_FILE.LOG, 'In procedure CST_TPRICE_PVT.Adjust_Acct');
138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);
139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);
140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);
141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);
142: FND_FILE.put_line(FND_FILE.LOG, 'Internal Order invoicing = ' || l_io_invoicing);
143: end if;
144:

Line 141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);

137: FND_FILE.put_line(FND_FILE.LOG, 'In procedure CST_TPRICE_PVT.Adjust_Acct');
138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);
139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);
140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);
141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);
142: FND_FILE.put_line(FND_FILE.LOG, 'Internal Order invoicing = ' || l_io_invoicing);
143: end if;
144:
145: if (p_txn_act_id in (21, 22)) then

Line 142: FND_FILE.put_line(FND_FILE.LOG, 'Internal Order invoicing = ' || l_io_invoicing);

138: FND_FILE.put_line(FND_FILE.LOG, 'p_tprice_option = ' || p_tprice_option);
139: FND_FILE.put_line(FND_FILE.LOG, 'p_txf_price = ' || p_txf_price);
140: FND_FILE.put_line(FND_FILE.LOG, 'l_pd_txfr_ind = ' || l_pd_txfr_ind);
141: FND_FILE.put_line(FND_FILE.LOG, 'p_txn_act_id = ' || p_txn_act_id);
142: FND_FILE.put_line(FND_FILE.LOG, 'Internal Order invoicing = ' || l_io_invoicing);
143: end if;
144:
145: if (p_txn_act_id in (21, 22)) then
146: l_from_org := p_txn_org_id;

Line 188: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_sum = ' || l_rcv_sum);

184: AND accounting_line_type = 9;
185: end if;
186:
187: if (G_DEBUG = 'Y') then
188: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_sum = ' || l_rcv_sum);
189: FND_FILE.put_line(FND_FILE.LOG, 'l_pay_sum = ' || l_pay_sum);
190: end if;
191:
192:

Line 189: FND_FILE.put_line(FND_FILE.LOG, 'l_pay_sum = ' || l_pay_sum);

185: end if;
186:
187: if (G_DEBUG = 'Y') then
188: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_sum = ' || l_rcv_sum);
189: FND_FILE.put_line(FND_FILE.LOG, 'l_pay_sum = ' || l_pay_sum);
190: end if;
191:
192:
193: /* OPM INVCONV: process/discrete xfers

Line 213: FND_FILE.put_line(FND_FILE.LOG,

209: AND organization_id = l_to_org;
210:
211:
212: if (G_DEBUG = 'Y') then
213: FND_FILE.put_line(FND_FILE.LOG,
214: 'p_src_type_id/l_from_ou/l_to_ou/l_io_invoicing/p_txn_act_id/l_rcv_count: ' ||
215: p_src_type_id ||'/'|| l_from_ou ||'/'|| l_to_ou ||'/'|| l_io_invoicing ||'/'||
216: p_txn_act_id ||'/'|| l_rcv_count );
217: end if;

Line 261: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_curr = ' || l_snd_curr);

257: FROM gl_sets_of_books
258: WHERE set_of_books_id = l_rcv_sob_id;
259:
260: if (G_DEBUG = 'Y') then
261: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_curr = ' || l_snd_curr);
262: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_curr = ' || l_rcv_curr);
263: FND_FILE.put_line(FND_FILE.LOG, 'l_conv_rate = ' || l_conv_rate);
264: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_coa_id = ' || l_rcv_coa_id);
265: end if;

Line 262: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_curr = ' || l_rcv_curr);

258: WHERE set_of_books_id = l_rcv_sob_id;
259:
260: if (G_DEBUG = 'Y') then
261: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_curr = ' || l_snd_curr);
262: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_curr = ' || l_rcv_curr);
263: FND_FILE.put_line(FND_FILE.LOG, 'l_conv_rate = ' || l_conv_rate);
264: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_coa_id = ' || l_rcv_coa_id);
265: end if;
266:

Line 263: FND_FILE.put_line(FND_FILE.LOG, 'l_conv_rate = ' || l_conv_rate);

259:
260: if (G_DEBUG = 'Y') then
261: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_curr = ' || l_snd_curr);
262: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_curr = ' || l_rcv_curr);
263: FND_FILE.put_line(FND_FILE.LOG, 'l_conv_rate = ' || l_conv_rate);
264: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_coa_id = ' || l_rcv_coa_id);
265: end if;
266:
267: -- Get the primary unit of measure for sending and receiving orgs

Line 264: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_coa_id = ' || l_rcv_coa_id);

260: if (G_DEBUG = 'Y') then
261: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_curr = ' || l_snd_curr);
262: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_curr = ' || l_rcv_curr);
263: FND_FILE.put_line(FND_FILE.LOG, 'l_conv_rate = ' || l_conv_rate);
264: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_coa_id = ' || l_rcv_coa_id);
265: end if;
266:
267: -- Get the primary unit of measure for sending and receiving orgs
268: l_stmt_num := 100;

Line 293: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_uom = ' || l_snd_uom);

289: raise process_error;
290: end if;
291:
292: if (G_DEBUG = 'Y') then
293: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_uom = ' || l_snd_uom);
294: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_uom = ' || l_rcv_uom);
295: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_qty = ' || l_snd_qty);
296: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_qty = ' || l_rcv_qty);
297: end if;

Line 294: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_uom = ' || l_rcv_uom);

290: end if;
291:
292: if (G_DEBUG = 'Y') then
293: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_uom = ' || l_snd_uom);
294: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_uom = ' || l_rcv_uom);
295: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_qty = ' || l_snd_qty);
296: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_qty = ' || l_rcv_qty);
297: end if;
298:

Line 295: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_qty = ' || l_snd_qty);

291:
292: if (G_DEBUG = 'Y') then
293: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_uom = ' || l_snd_uom);
294: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_uom = ' || l_rcv_uom);
295: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_qty = ' || l_snd_qty);
296: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_qty = ' || l_rcv_qty);
297: end if;
298:
299: -- Get the internal order information from the shipment transaction

Line 296: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_qty = ' || l_rcv_qty);

292: if (G_DEBUG = 'Y') then
293: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_uom = ' || l_snd_uom);
294: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_uom = ' || l_rcv_uom);
295: FND_FILE.put_line(FND_FILE.LOG, 'l_snd_qty = ' || l_snd_qty);
296: FND_FILE.put_line(FND_FILE.LOG, 'l_rcv_qty = ' || l_rcv_qty);
297: end if;
298:
299: -- Get the internal order information from the shipment transaction
300: -- OPM INVCONV: added action id 15

Line 358: FND_FILE.put_line(FND_FILE.LOG, 'l_line_id = ' || l_line_id);

354: end if;
355: end if;
356:
357: if (G_DEBUG = 'Y') then
358: FND_FILE.put_line(FND_FILE.LOG, 'l_line_id = ' || l_line_id);
359: FND_FILE.put_line(FND_FILE.LOG, 'l_header_id = ' || l_header_id);
360: FND_FILE.put_line(FND_FILE.LOG, 'l_cust_id = ' || l_cust_id);
361: FND_FILE.put_line(FND_FILE.LOG, 'l_order_type = ' || l_order_type);
362: end if;

Line 359: FND_FILE.put_line(FND_FILE.LOG, 'l_header_id = ' || l_header_id);

355: end if;
356:
357: if (G_DEBUG = 'Y') then
358: FND_FILE.put_line(FND_FILE.LOG, 'l_line_id = ' || l_line_id);
359: FND_FILE.put_line(FND_FILE.LOG, 'l_header_id = ' || l_header_id);
360: FND_FILE.put_line(FND_FILE.LOG, 'l_cust_id = ' || l_cust_id);
361: FND_FILE.put_line(FND_FILE.LOG, 'l_order_type = ' || l_order_type);
362: end if;
363:

Line 360: FND_FILE.put_line(FND_FILE.LOG, 'l_cust_id = ' || l_cust_id);

356:
357: if (G_DEBUG = 'Y') then
358: FND_FILE.put_line(FND_FILE.LOG, 'l_line_id = ' || l_line_id);
359: FND_FILE.put_line(FND_FILE.LOG, 'l_header_id = ' || l_header_id);
360: FND_FILE.put_line(FND_FILE.LOG, 'l_cust_id = ' || l_cust_id);
361: FND_FILE.put_line(FND_FILE.LOG, 'l_order_type = ' || l_order_type);
362: end if;
363:
364: -- Get the COGS account for the sending org from OE workflow, if not succeeded,

Line 361: FND_FILE.put_line(FND_FILE.LOG, 'l_order_type = ' || l_order_type);

357: if (G_DEBUG = 'Y') then
358: FND_FILE.put_line(FND_FILE.LOG, 'l_line_id = ' || l_line_id);
359: FND_FILE.put_line(FND_FILE.LOG, 'l_header_id = ' || l_header_id);
360: FND_FILE.put_line(FND_FILE.LOG, 'l_cust_id = ' || l_cust_id);
361: FND_FILE.put_line(FND_FILE.LOG, 'l_order_type = ' || l_order_type);
362: end if;
363:
364: -- Get the COGS account for the sending org from OE workflow, if not succeeded,
365: -- default it to the item COGS

Line 394: FND_FILE.put_line(FND_FILE.LOG, 'l_om_ccid = ' || l_om_ccid);

390: AND MP.organization_id = MSI.organization_id;
391: end if;
392:
393: if (G_DEBUG = 'Y') then
394: FND_FILE.put_line(FND_FILE.LOG, 'l_om_ccid = ' || l_om_ccid);
395: end if;
396:
397: end if;
398:

Line 417: FND_FILE.put_line(FND_FILE.LOG, 'l_inv_ccid = ' || l_inv_ccid);

413: raise inv_exp_acct_err;
414: end if;
415:
416: if (G_DEBUG = 'Y') then
417: FND_FILE.put_line(FND_FILE.LOG, 'l_inv_ccid = ' || l_inv_ccid);
418: end if;
419:
420: end if;
421:

Line 434: FND_FILE.put_line(FND_FILE.LOG, 'Start first adjustment');

430:
431: -- First adjustment: delete interorg receivable and payable. They are not needed as the
432: -- intercompany receivable and payable will be generated from intercompany invoice processors
433: if (G_DEBUG = 'Y') then
434: FND_FILE.put_line(FND_FILE.LOG, 'Start first adjustment');
435: end if;
436:
437: l_stmt_num := 180;
438:

Line 450: FND_FILE.put_line(FND_FILE.LOG, 'Start second adjustment');

446: AND accounting_line_type in (9,10,34);
447:
448: -- Second adjustment: debit elemental COGS for the sending org
449: if (G_DEBUG = 'Y') then
450: FND_FILE.put_line(FND_FILE.LOG, 'Start second adjustment');
451: end if;
452:
453: l_stmt_num := 185;
454:

Line 561: FND_FILE.put_line(FND_FILE.LOG, 'Start third adjustment');

557: end if; -- if (l_from_exp_item <> 1)
558:
559: -- Third adjustment: credit intercompany expense for the receiving org
560: if (G_DEBUG = 'Y') then
561: FND_FILE.put_line(FND_FILE.LOG, 'Start third adjustment');
562: end if;
563:
564: /* OPM INVCONV: Process/Discrete Xfer
565: * IC Expense only for Logical Intransit Receipt Txn

Line 607: FND_FILE.put_line(FND_FILE.LOG, 'Start fourth adjustment');

603: -- If the option is not to treat transfer price as incoming cost, need fourth adjustment:
604: -- debit/credit profit in inventory for the receiving org
605: if (p_tprice_option = 1) then
606: if (G_DEBUG = 'Y') then
607: FND_FILE.put_line(FND_FILE.LOG, 'Start fourth adjustment');
608: end if;
609:
610: l_stmt_num := 260;
611:

Line 619: FND_FILE.put_line(FND_FILE.LOG, 'l_prf = ' || l_prf);

615: WHERE organization_id = l_to_org
616: AND transaction_id = p_txn_id;
617:
618: if (G_DEBUG = 'Y') then
619: FND_FILE.put_line(FND_FILE.LOG, 'l_prf = ' || l_prf);
620: end if;
621:
622: if (l_prf <> 0) then
623: l_stmt_num := 270;

Line 677: FND_FILE.put_line(FND_FILE.LOG, 'Out of procedure CST_TPRICE_PVT.Adjust_Acct');

673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
674: p_data => x_msg_data);
675:
676: if (G_DEBUG = 'Y') then
677: FND_FILE.put_line(FND_FILE.LOG, 'Out of procedure CST_TPRICE_PVT.Adjust_Acct');
678: end if;
679:
680: EXCEPTION
681: