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.CSTPPIPV dependencies on FND_FILE

Line 201: fnd_file.put_line(fnd_file.log,l_err_msg);

197: fnd_message.set_token('ORGCODE', l_organization_code);
198: l_err_msg := FND_MESSAGE.Get;
199: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
200: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
201: fnd_file.put_line(fnd_file.log,l_err_msg);
202: RETURN;
203: END IF;
204:
205: EXCEPTION

Line 228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Inventory');

224: l_txn_date_profile := FND_PROFILE.VALUE('TRANSACTION_DATE');
225:
226: l_stmt_num := 10;
227:
228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Inventory');
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
231: ||to_char(l_request_id));
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '

226: l_stmt_num := 10;
227:
228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Inventory');
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
231: ||to_char(l_request_id));
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
233: ||to_char(l_prog_app_id));
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '

Line 232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '

228: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Inventory');
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
231: ||to_char(l_request_id));
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
233: ||to_char(l_prog_app_id));
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
235: ||to_char(l_user_id));
236: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '

Line 234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '

230: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
231: ||to_char(l_request_id));
232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
233: ||to_char(l_prog_app_id));
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
235: ||to_char(l_user_id));
236: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
237: ||to_char(l_prog_id));
238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '

Line 236: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '

232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'prog_appl_id: '
233: ||to_char(l_prog_app_id));
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
235: ||to_char(l_user_id));
236: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
237: ||to_char(l_prog_id));
238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
239: ||to_char(l_login_id));
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '

Line 238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '

234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_user_id: '
235: ||to_char(l_user_id));
236: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
237: ||to_char(l_prog_id));
238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
239: ||to_char(l_login_id));
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
241: ||to_char(l_conc_program_id));
242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '

Line 240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '

236: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_program_id: '
237: ||to_char(l_prog_id));
238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
239: ||to_char(l_login_id));
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
241: ||to_char(l_conc_program_id));
242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
243: ||l_debug);
244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '

238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_login_id: '
239: ||to_char(l_login_id));
240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
241: ||to_char(l_conc_program_id));
242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
243: ||l_debug);
244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
245: ||TO_CHAR(l_txn_date_profile));
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '

Line 244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '

240: FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_conc_program_id: '
241: ||to_char(l_conc_program_id));
242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
243: ||l_debug);
244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
245: ||TO_CHAR(l_txn_date_profile));
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
247: ||TO_CHAR(p_organization_id));
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '

Line 246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '

242: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
243: ||l_debug);
244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
245: ||TO_CHAR(l_txn_date_profile));
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
247: ||TO_CHAR(p_organization_id));
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
249: ||p_description);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '

244: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
245: ||TO_CHAR(l_txn_date_profile));
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
247: ||TO_CHAR(p_organization_id));
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
249: ||p_description);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
251: ||TO_CHAR(p_item_option));
252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item dummy: '

Line 250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '

246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
247: ||TO_CHAR(p_organization_id));
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
249: ||p_description);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
251: ||TO_CHAR(p_item_option));
252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item dummy: '
253: ||TO_CHAR(p_item_dummy));
254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category_dummy: '

Line 252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item dummy: '

248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
249: ||p_description);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
251: ||TO_CHAR(p_item_option));
252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item dummy: '
253: ||TO_CHAR(p_item_dummy));
254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category_dummy: '
255: ||TO_CHAR(p_category_dummy));
256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '

Line 254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category_dummy: '

250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
251: ||TO_CHAR(p_item_option));
252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item dummy: '
253: ||TO_CHAR(p_item_dummy));
254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category_dummy: '
255: ||TO_CHAR(p_category_dummy));
256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
257: ||TO_CHAR(p_specific_item_id));
258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '

Line 256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '

252: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item dummy: '
253: ||TO_CHAR(p_item_dummy));
254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category_dummy: '
255: ||TO_CHAR(p_category_dummy));
256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
257: ||TO_CHAR(p_specific_item_id));
258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
259: ||TO_CHAR(p_category_set_id));
260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '

Line 258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '

254: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category_dummy: '
255: ||TO_CHAR(p_category_dummy));
256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
257: ||TO_CHAR(p_specific_item_id));
258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
259: ||TO_CHAR(p_category_set_id));
260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
261: ||p_category_validate_flag);
262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '

Line 260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '

256: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
257: ||TO_CHAR(p_specific_item_id));
258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
259: ||TO_CHAR(p_category_set_id));
260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
261: ||p_category_validate_flag);
262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
263: ||TO_CHAR(p_category_structure));
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '

258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
259: ||TO_CHAR(p_category_set_id));
260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
261: ||p_category_validate_flag);
262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
263: ||TO_CHAR(p_category_structure));
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
265: ||TO_CHAR(p_category_id));
266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '

Line 264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '

260: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Validate Flag: '
261: ||p_category_validate_flag);
262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
263: ||TO_CHAR(p_category_structure));
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
265: ||TO_CHAR(p_category_id));
266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
267: ||TO_CHAR(p_invoice_project_option));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Dummy: '

Line 266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '

262: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category Structure: '
263: ||TO_CHAR(p_category_structure));
264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
265: ||TO_CHAR(p_category_id));
266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
267: ||TO_CHAR(p_invoice_project_option));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Dummy: '
269: ||TO_CHAR(p_project_dummy));
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '

Line 268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Dummy: '

264: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
265: ||TO_CHAR(p_category_id));
266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
267: ||TO_CHAR(p_invoice_project_option));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Dummy: '
269: ||TO_CHAR(p_project_dummy));
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
271: ||TO_CHAR(p_project_id));
272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account Dummy: '

Line 270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '

266: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
267: ||TO_CHAR(p_invoice_project_option));
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Dummy: '
269: ||TO_CHAR(p_project_dummy));
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
271: ||TO_CHAR(p_project_id));
272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account Dummy: '
273: ||TO_CHAR(p_adj_account_dummy));
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '

Line 272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account Dummy: '

268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Dummy: '
269: ||TO_CHAR(p_project_dummy));
270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
271: ||TO_CHAR(p_project_id));
272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account Dummy: '
273: ||TO_CHAR(p_adj_account_dummy));
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
275: ||TO_CHAR(p_adj_account));
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '

Line 274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '

270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
271: ||TO_CHAR(p_project_id));
272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account Dummy: '
273: ||TO_CHAR(p_adj_account_dummy));
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
275: ||TO_CHAR(p_adj_account));
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '
277: ||p_cutoff_date);
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '

Line 276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '

272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account Dummy: '
273: ||TO_CHAR(p_adj_account_dummy));
274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
275: ||TO_CHAR(p_adj_account));
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '
277: ||p_cutoff_date);
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '
279: ||TO_CHAR(p_transaction_process_mode));
280:

Line 278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '

274: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
275: ||TO_CHAR(p_adj_account));
276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '
277: ||p_cutoff_date);
278: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '
279: ||TO_CHAR(p_transaction_process_mode));
280:
281: ----------------------------------------------------------------------
282: -- Make sure there is no other program running with the same args

Line 367: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

363: AND aida.invoice_id = aida2.invoice_id
364: );
365:
366: IF (l_debug = 'Y') THEN
367: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
368: ||' Rows marked as NULL in AIDA ');
369: END IF;
370:
371:

Line 445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch: '||TO_CHAR(l_batch_id));

441: RAISE cst_process_error;
442: END IF;
443:
444: IF (l_debug = 'Y') THEN
445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch: '||TO_CHAR(l_batch_id));
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Date: '
447: ||TO_CHAR(l_default_txn_date));
448: END IF;
449:

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Date: '

442: END IF;
443:
444: IF (l_debug = 'Y') THEN
445: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch: '||TO_CHAR(l_batch_id));
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Date: '
447: ||TO_CHAR(l_default_txn_date));
448: END IF;
449:
450: --------------------------------------------------------------------

Line 460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item: '

456:
457: l_cost_group_id := c_item_rec.cg_id;
458:
459: IF (l_debug = 'Y') THEN
460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item: '
461: ||TO_CHAR(c_item_rec.item_id));
462: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CG: '||TO_CHAR(l_cost_group_id));
463: END IF;
464:

Line 462: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CG: '||TO_CHAR(l_cost_group_id));

458:
459: IF (l_debug = 'Y') THEN
460: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item: '
461: ||TO_CHAR(c_item_rec.item_id));
462: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CG: '||TO_CHAR(l_cost_group_id));
463: END IF;
464:
465: l_stmt_num := 50;
466: CSTPPIPV.generate_trf_info

Line 562: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

558: AND cavh.organization_id = msi.organization_id
559: );
560:
561: IF (l_debug = 'Y') THEN
562: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
563: ||' Rows inserted into MTI');
564: END IF;
565:
566: -------------------------------------------------------------------

Line 608: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

604: );
605:
606: IF (l_debug = 'Y') THEN
607:
608: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
609: ||' Rows inserted into MTCDI');
610: END IF;
611:
612: COMMIT;

Line 632: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code

628:
629: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
630: l_err_msg := fnd_message.get;
631: l_err_msg := SUBSTR(l_err_msg,1,240);
632: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
633: ||' '
634: ||l_err_msg,1,240));
635: CONC_STATUS := FND_CONCURRENT.
636: SET_COMPLETION_STATUS('ERROR',l_err_msg);

Line 652: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

648:
649: fnd_message.set_name('BOM', 'CST_NO_AVG_ORG');
650: l_err_msg := fnd_message.get;
651: l_err_msg := SUBSTR(l_err_msg,1,240);
652: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
653: CONC_STATUS := FND_CONCURRENT.
654: SET_COMPLETION_STATUS('ERROR',l_err_msg);
655:
656:

Line 662: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

658: ROLLBACK;
659: l_err_num := l_err_num;
660: l_err_code := l_err_code;
661: l_err_msg := SUBSTR(l_err_msg,1,240);
662: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
663: CONC_STATUS := FND_CONCURRENT.
664: SET_COMPLETION_STATUS('ERROR',l_err_msg);
665:
666:

Line 675: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

671: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_inventory('
672: || to_char(l_stmt_num)
673: || '): '
674: ||SQLERRM,1,240);
675: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
676: CONC_STATUS := FND_CONCURRENT.
677: SET_COMPLETION_STATUS('ERROR',l_err_msg);
678:
679:

Line 925: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Work In Process');

921: l_txn_date_profile := FND_PROFILE.VALUE('TRANSACTION_DATE');
922:
923: l_stmt_num := 10;
924:
925: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Work In Process');
926:
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id: '
928: ||to_char(l_request_id));
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User Id: '

Line 927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id: '

923: l_stmt_num := 10;
924:
925: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Work In Process');
926:
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id: '
928: ||to_char(l_request_id));
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User Id: '
930: ||to_char(l_user_id));
931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Login Id: '

Line 929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User Id: '

925: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transfer Invoice to Work In Process');
926:
927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id: '
928: ||to_char(l_request_id));
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User Id: '
930: ||to_char(l_user_id));
931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Login Id: '
932: ||to_char(l_login_id));
933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program Id: '

Line 931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Login Id: '

927: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Request Id: '
928: ||to_char(l_request_id));
929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User Id: '
930: ||to_char(l_user_id));
931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Login Id: '
932: ||to_char(l_login_id));
933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program Id: '
934: ||to_char(l_prog_id));
935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prog Appl Id: '

Line 933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program Id: '

929: FND_FILE.PUT_LINE(FND_FILE.LOG, 'User Id: '
930: ||to_char(l_user_id));
931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Login Id: '
932: ||to_char(l_login_id));
933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program Id: '
934: ||to_char(l_prog_id));
935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prog Appl Id: '
936: ||to_char(l_prog_app_id));
937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Conc Program Id: '

Line 935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prog Appl Id: '

931: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Login Id: '
932: ||to_char(l_login_id));
933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program Id: '
934: ||to_char(l_prog_id));
935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prog Appl Id: '
936: ||to_char(l_prog_app_id));
937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Conc Program Id: '
938: ||to_char(l_conc_program_id));
939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '

Line 937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Conc Program Id: '

933: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Program Id: '
934: ||to_char(l_prog_id));
935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prog Appl Id: '
936: ||to_char(l_prog_app_id));
937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Conc Program Id: '
938: ||to_char(l_conc_program_id));
939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
940: ||l_debug);
941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '

Line 939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '

935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Prog Appl Id: '
936: ||to_char(l_prog_app_id));
937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Conc Program Id: '
938: ||to_char(l_conc_program_id));
939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
940: ||l_debug);
941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
942: ||TO_CHAR(l_txn_date_profile));
943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '

Line 941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '

937: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Conc Program Id: '
938: ||to_char(l_conc_program_id));
939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
940: ||l_debug);
941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
942: ||TO_CHAR(l_txn_date_profile));
943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
944: ||TO_CHAR(p_organization_id));
945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '

Line 943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '

939: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug: '
940: ||l_debug);
941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
942: ||TO_CHAR(l_txn_date_profile));
943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
944: ||TO_CHAR(p_organization_id));
945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
946: ||p_description);
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Work Order: '

Line 945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '

941: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Date Profile: '
942: ||TO_CHAR(l_txn_date_profile));
943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
944: ||TO_CHAR(p_organization_id));
945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
946: ||p_description);
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Work Order: '
948: ||TO_CHAR(p_work_order_id));
949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Type: '

Line 947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Work Order: '

943: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Organization: '
944: ||TO_CHAR(p_organization_id));
945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
946: ||p_description);
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Work Order: '
948: ||TO_CHAR(p_work_order_id));
949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Type: '
950: ||TO_CHAR(p_item_type));
951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '

Line 949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Type: '

945: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Description: '
946: ||p_description);
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Work Order: '
948: ||TO_CHAR(p_work_order_id));
949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Type: '
950: ||TO_CHAR(p_item_type));
951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
952: ||TO_CHAR(l_item_option));
953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '

Line 951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '

947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Work Order: '
948: ||TO_CHAR(p_work_order_id));
949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Type: '
950: ||TO_CHAR(p_item_type));
951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
952: ||TO_CHAR(l_item_option));
953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
954: ||TO_CHAR(p_specific_item_id));
955: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '

Line 953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '

949: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Type: '
950: ||TO_CHAR(p_item_type));
951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
952: ||TO_CHAR(l_item_option));
953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
954: ||TO_CHAR(p_specific_item_id));
955: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
956: ||TO_CHAR(p_category_set_id));
957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '

Line 955: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '

951: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item Option: '
952: ||TO_CHAR(l_item_option));
953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
954: ||TO_CHAR(p_specific_item_id));
955: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
956: ||TO_CHAR(p_category_set_id));
957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
958: ||TO_CHAR(p_category_id));
959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '

Line 957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '

953: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Specific Item: '
954: ||TO_CHAR(p_specific_item_id));
955: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
956: ||TO_CHAR(p_category_set_id));
957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
958: ||TO_CHAR(p_category_id));
959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
960: ||TO_CHAR(l_project_option));
961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '

Line 959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '

955: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category set id: '
956: ||TO_CHAR(p_category_set_id));
957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
958: ||TO_CHAR(p_category_id));
959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
960: ||TO_CHAR(l_project_option));
961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
962: ||TO_CHAR(p_project_id));
963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '

Line 961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '

957: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Category: '
958: ||TO_CHAR(p_category_id));
959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
960: ||TO_CHAR(l_project_option));
961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
962: ||TO_CHAR(p_project_id));
963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
964: ||TO_CHAR(p_adj_account));
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '

Line 963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '

959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Project Option: '
960: ||TO_CHAR(l_project_option));
961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
962: ||TO_CHAR(p_project_id));
963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
964: ||TO_CHAR(p_adj_account));
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '
966: ||p_cutoff_date);
967: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '

Line 965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '

961: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Project Id: '
962: ||TO_CHAR(p_project_id));
963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
964: ||TO_CHAR(p_adj_account));
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '
966: ||p_cutoff_date);
967: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '
968: ||TO_CHAR(p_transaction_process_mode));
969:

Line 967: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '

963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Adjustment Account: '
964: ||TO_CHAR(p_adj_account));
965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoice Cutoff Date: '
966: ||p_cutoff_date);
967: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Txn Process Mode: '
968: ||TO_CHAR(p_transaction_process_mode));
969:
970: ----------------------------------------------------------------------
971: -- Make sure there is no other program running with the same args

Line 1043: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)||' rows marked as S in AIDA');

1039:
1040: close c_po_dists2;
1041:
1042: IF (l_debug = 'Y') THEN
1043: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(l_row_count)||' rows marked as S in AIDA');
1044: END IF;
1045:
1046: ----------------------------------------------------------------------
1047: -- Set aida rows with 'N' status but which have no IPV to NULL.

Line 1072: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)||' rows marked as NULL in AIDA');

1068: );
1069:
1070:
1071: IF (l_debug = 'Y') THEN
1072: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)||' rows marked as NULL in AIDA');
1073: END IF;
1074:
1075: ----------------------------------------------------------------------
1076: -- Create a batch for the the process

Line 1158: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch: '||TO_CHAR(l_batch_id));

1154: RAISE cst_process_error;
1155: END IF;
1156:
1157: IF (l_debug = 'Y') THEN
1158: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch: '||TO_CHAR(l_batch_id));
1159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Date: '||TO_CHAR(l_default_txn_date));
1160: END IF;
1161:
1162: ----------------------------------------------------------------------

Line 1159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Date: '||TO_CHAR(l_default_txn_date));

1155: END IF;
1156:
1157: IF (l_debug = 'Y') THEN
1158: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch: '||TO_CHAR(l_batch_id));
1159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Date: '||TO_CHAR(l_default_txn_date));
1160: END IF;
1161:
1162: ----------------------------------------------------------------------
1163: -- Calculate timezone offset from legal entity time to server time

Line 1196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PO Distribution: '

1192:
1193: FOR c_po_dist_rec IN c_po_dist LOOP
1194:
1195: IF (l_debug = 'Y') THEN
1196: FND_FILE.PUT_LINE(FND_FILE.LOG, 'PO Distribution: '
1197: ||TO_CHAR(c_po_dist_rec.po_distribution_id));
1198: END IF;
1199:
1200: l_stmt_num := 50;

Line 1341: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

1337: AND mp.organization_id = cavh.organization_id
1338: AND fu.user_id = l_user_id);
1339:
1340: IF (l_debug = 'Y') THEN
1341: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
1342: ||' Rows inserted into WCTI');
1343: END IF;
1344:
1345: END IF;

Line 1366: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code

1362:
1363: fnd_message.set_name('BOM', 'CST_CSTPPIPV_RUNNING');
1364: l_err_msg := fnd_message.get;
1365: l_err_msg := SUBSTR(l_err_msg,1,240);
1366: FND_FILE.PUT_LINE(fnd_file.log,SUBSTR(l_err_code
1367: ||' '
1368: ||l_err_msg,1,240));
1369: CONC_STATUS := FND_CONCURRENT.
1370: SET_COMPLETION_STATUS('ERROR',l_err_msg);

Line 1378: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

1374: retcode := 1;
1375: l_err_num := l_err_num;
1376: l_err_code := l_err_code;
1377: l_err_msg := SUBSTR(l_err_msg,1,240);
1378: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1379: CONC_STATUS := FND_CONCURRENT.
1380: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1381:
1382: WHEN OTHERS THEN

Line 1391: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

1387: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_wip('
1388: || to_char(l_stmt_num)
1389: || '): '
1390: ||SQLERRM,1,240);
1391: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1392: CONC_STATUS := FND_CONCURRENT.
1393: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1394: END trf_invoice_to_wip;
1395:

Line 1456: fnd_file.put_line(fnd_file.log,l_err_msg);

1452: fnd_message.set_token('ORGCODE', l_organization_code);
1453: l_err_msg := FND_MESSAGE.Get;
1454: l_err_msg := substrb('CSTPIPVB : ' || l_err_msg,1,240);
1455: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
1456: fnd_file.put_line(fnd_file.log,l_err_msg);
1457: RETURN;
1458: END IF;
1459:
1460: EXCEPTION

Line 1506: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);

1502: l_err_msg := SUBSTR('CSTPPIPV.trf_invoice_to_wip('
1503: || to_char(l_stmt_num)
1504: || '): '
1505: ||SQLERRM,1,240);
1506: FND_FILE.PUT_LINE(fnd_file.log,l_err_msg);
1507: CONC_STATUS := FND_CONCURRENT.
1508: SET_COMPLETION_STATUS('ERROR',l_err_msg);
1509: END trf_invoice_to_wip;
1510:

Line 1703: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

1699: AND aida.corrected_invoice_dist_id IS NULL --same as change made earlier
1700: );
1701:
1702:
1703: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
1704: || ' Rows inserted into CAVL');
1705:
1706: l_stmt_num := 10;
1707:

Line 1779: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.podist: '

1775: FROM DUAL
1776: );
1777:
1778: -- Debug statements -----------------------------------------------
1779: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.podist: '
1780: -- ||to_char(c_cavl_po_rec.po_distribution_id));
1781: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.batch_id: '
1782: -- ||to_char(p_batch_id));
1783: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.var_amt: '

Line 1781: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.batch_id: '

1777:
1778: -- Debug statements -----------------------------------------------
1779: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.podist: '
1780: -- ||to_char(c_cavl_po_rec.po_distribution_id));
1781: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.batch_id: '
1782: -- ||to_char(p_batch_id));
1783: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.var_amt: '
1784: -- ||to_char(c_cavl_po_rec.var_amount));
1785: -- End Debug ------------------------------------------------------

Line 1783: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.var_amt: '

1779: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.podist: '
1780: -- ||to_char(c_cavl_po_rec.po_distribution_id));
1781: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.batch_id: '
1782: -- ||to_char(p_batch_id));
1783: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'cavh.var_amt: '
1784: -- ||to_char(c_cavl_po_rec.var_amount));
1785: -- End Debug ------------------------------------------------------
1786:
1787: END LOOP; -- c_cavl_po_rec

Line 1833: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

1829: AND cavl.cost_group_id = p_cost_group_id
1830: AND cavl.inventory_item_id = p_inventory_item_id
1831: );
1832:
1833: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
1834: || ' Rows marked as transferred in AIDA');
1835:
1836:
1837: EXCEPTION

Line 1977: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)|| ' Rows inserted into CAVL');

1973: -- AND aida.root_distribution_id IS NULL
1974: AND aida.corrected_invoice_dist_id IS NULL
1975: AND aida.po_distribution_id = p_po_distribution_id);
1976:
1977: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)|| ' Rows inserted into CAVL');
1978:
1979: l_stmt_num := 10;
1980:
1981: ---------------------------------------------------------------------

Line 2085: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)

2081: WHERE cavl.batch_id = p_batch_id
2082: AND cavl.invoice_distribution_id = aida.invoice_distribution_id
2083: );
2084:
2085: FND_FILE.PUT_LINE(FND_FILE.LOG, TO_CHAR(SQL%ROWCOUNT)
2086: || ' Rows marked as transferred in AIDA');
2087: END IF;
2088:
2089: EXCEPTION