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.CS_SR_INTERFACE_CP dependencies on FND_LOG

Line 238: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

234: l_succ_cst_rec := l_cst_arry();
235: l_err_rec := l_err_arry();*/
236:
237:
238: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
239: THEN
240: FND_LOG.String
241: (
242: FND_LOG.level_procedure

Line 240: FND_LOG.String

236:
237:
238: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
239: THEN
240: FND_LOG.String
241: (
242: FND_LOG.level_procedure
243: , L_LOG_MODULE || 'start_time'
244: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')

Line 242: FND_LOG.level_procedure

238: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
239: THEN
240: FND_LOG.String
241: (
242: FND_LOG.level_procedure
243: , L_LOG_MODULE || 'start_time'
244: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
245: );
246:

Line 248: FND_LOG.String

244: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
245: );
246:
247:
248: FND_LOG.String
249: (
250: FND_LOG.level_procedure
251: , L_LOG_MODULE || 'start'
252: , 'Inside ' || 'Interface Cost Details ' || ', called with parameters below:'

Line 250: FND_LOG.level_procedure

246:
247:
248: FND_LOG.String
249: (
250: FND_LOG.level_procedure
251: , L_LOG_MODULE || 'start'
252: , 'Inside ' || 'Interface Cost Details ' || ', called with parameters below:'
253: );
254:

Line 255: FND_LOG.String

251: , L_LOG_MODULE || 'start'
252: , 'Inside ' || 'Interface Cost Details ' || ', called with parameters below:'
253: );
254:
255: FND_LOG.String
256: (
257: FND_LOG.level_procedure
258: , L_LOG_MODULE || 'param 1'
259: , 'errbuf:' || errbuf

Line 257: FND_LOG.level_procedure

253: );
254:
255: FND_LOG.String
256: (
257: FND_LOG.level_procedure
258: , L_LOG_MODULE || 'param 1'
259: , 'errbuf:' || errbuf
260: );
261: FND_LOG.String

Line 261: FND_LOG.String

257: FND_LOG.level_procedure
258: , L_LOG_MODULE || 'param 1'
259: , 'errbuf:' || errbuf
260: );
261: FND_LOG.String
262: (
263: FND_LOG.level_procedure
264: , L_LOG_MODULE || 'param 2'
265: , 'errcode:' || errcode

Line 263: FND_LOG.level_procedure

259: , 'errbuf:' || errbuf
260: );
261: FND_LOG.String
262: (
263: FND_LOG.level_procedure
264: , L_LOG_MODULE || 'param 2'
265: , 'errcode:' || errcode
266: );
267:

Line 269: FND_LOG.String

265: , 'errcode:' || errcode
266: );
267:
268:
269: FND_LOG.String
270: (
271: FND_LOG.level_procedure
272: , L_LOG_MODULE || 'param 3'
273: , 'p_creation_from_date: ' || p_creation_from_date

Line 271: FND_LOG.level_procedure

267:
268:
269: FND_LOG.String
270: (
271: FND_LOG.level_procedure
272: , L_LOG_MODULE || 'param 3'
273: , 'p_creation_from_date: ' || p_creation_from_date
274: );
275: FND_LOG.String

Line 275: FND_LOG.String

271: FND_LOG.level_procedure
272: , L_LOG_MODULE || 'param 3'
273: , 'p_creation_from_date: ' || p_creation_from_date
274: );
275: FND_LOG.String
276: (
277: FND_LOG.level_procedure
278: , L_LOG_MODULE || 'param 4'
279: , 'p_creation_to_date: ' || p_creation_to_date

Line 277: FND_LOG.level_procedure

273: , 'p_creation_from_date: ' || p_creation_from_date
274: );
275: FND_LOG.String
276: (
277: FND_LOG.level_procedure
278: , L_LOG_MODULE || 'param 4'
279: , 'p_creation_to_date: ' || p_creation_to_date
280: );
281:

Line 282: FND_LOG.String

278: , L_LOG_MODULE || 'param 4'
279: , 'p_creation_to_date: ' || p_creation_to_date
280: );
281:
282: FND_LOG.String
283: (
284: FND_LOG.level_procedure
285: , L_LOG_MODULE || 'param 5'
286: , 'p_project_id ' || p_project_id

Line 284: FND_LOG.level_procedure

280: );
281:
282: FND_LOG.String
283: (
284: FND_LOG.level_procedure
285: , L_LOG_MODULE || 'param 5'
286: , 'p_project_id ' || p_project_id
287: );
288:

Line 290: FND_LOG.String

286: , 'p_project_id ' || p_project_id
287: );
288:
289:
290: FND_LOG.String
291: (
292: FND_LOG.level_procedure
293: , L_LOG_MODULE || 'param 6'
294: , 'p_project_task_id ' || p_project_task_id

Line 292: FND_LOG.level_procedure

288:
289:
290: FND_LOG.String
291: (
292: FND_LOG.level_procedure
293: , L_LOG_MODULE || 'param 6'
294: , 'p_project_task_id ' || p_project_task_id
295: );
296:

Line 298: FND_LOG.String

294: , 'p_project_task_id ' || p_project_task_id
295: );
296:
297:
298: FND_LOG.String
299: (
300: FND_LOG.level_procedure
301: , L_LOG_MODULE || 'param 7'
302: , 'p_transaction_type_id ' || p_transaction_type_id

Line 300: FND_LOG.level_procedure

296:
297:
298: FND_LOG.String
299: (
300: FND_LOG.level_procedure
301: , L_LOG_MODULE || 'param 7'
302: , 'p_transaction_type_id ' || p_transaction_type_id
303: );
304:

Line 305: FND_LOG.String

301: , L_LOG_MODULE || 'param 7'
302: , 'p_transaction_type_id ' || p_transaction_type_id
303: );
304:
305: FND_LOG.String
306: (
307: FND_LOG.level_procedure
308: , L_LOG_MODULE || 'param 8'
309: , 'p_billing_type ' || p_billing_type

Line 307: FND_LOG.level_procedure

303: );
304:
305: FND_LOG.String
306: (
307: FND_LOG.level_procedure
308: , L_LOG_MODULE || 'param 8'
309: , 'p_billing_type ' || p_billing_type
310: );
311:

Line 312: FND_LOG.String

308: , L_LOG_MODULE || 'param 8'
309: , 'p_billing_type ' || p_billing_type
310: );
311:
312: FND_LOG.String
313: (
314: FND_LOG.level_procedure
315: , L_LOG_MODULE || 'param 9'
316: , 'p_incident_id ' || p_incident_id

Line 314: FND_LOG.level_procedure

310: );
311:
312: FND_LOG.String
313: (
314: FND_LOG.level_procedure
315: , L_LOG_MODULE || 'param 9'
316: , 'p_incident_id ' || p_incident_id
317: );
318:

Line 319: FND_LOG.String

315: , L_LOG_MODULE || 'param 9'
316: , 'p_incident_id ' || p_incident_id
317: );
318:
319: FND_LOG.String
320: (
321: FND_LOG.level_procedure
322: , L_LOG_MODULE || 'param 10'
323: , 'p_incident_status_id ' || p_incident_status_id

Line 321: FND_LOG.level_procedure

317: );
318:
319: FND_LOG.String
320: (
321: FND_LOG.level_procedure
322: , L_LOG_MODULE || 'param 10'
323: , 'p_incident_status_id ' || p_incident_status_id
324: );
325:

Line 326: FND_LOG.String

322: , L_LOG_MODULE || 'param 10'
323: , 'p_incident_status_id ' || p_incident_status_id
324: );
325:
326: FND_LOG.String
327: (
328: FND_LOG.level_procedure
329: , L_LOG_MODULE || 'param 11'
330: , 'p_source_code ' || p_source_code

Line 328: FND_LOG.level_procedure

324: );
325:
326: FND_LOG.String
327: (
328: FND_LOG.level_procedure
329: , L_LOG_MODULE || 'param 11'
330: , 'p_source_code ' || p_source_code
331: );
332:

Line 333: FND_LOG.String

329: , L_LOG_MODULE || 'param 11'
330: , 'p_source_code ' || p_source_code
331: );
332:
333: FND_LOG.String
334: (
335: FND_LOG.level_procedure
336: , L_LOG_MODULE || 'param 12'
337: , 'p_source_number ' || p_source_number

Line 335: FND_LOG.level_procedure

331: );
332:
333: FND_LOG.String
334: (
335: FND_LOG.level_procedure
336: , L_LOG_MODULE || 'param 12'
337: , 'p_source_number ' || p_source_number
338: );
339:

Line 340: FND_LOG.String

336: , L_LOG_MODULE || 'param 12'
337: , 'p_source_number ' || p_source_number
338: );
339:
340: FND_LOG.String
341: (
342: FND_LOG.level_procedure
343: , L_LOG_MODULE || 'param 13'
344: , 'p_org_id ' || p_org_id

Line 342: FND_LOG.level_procedure

338: );
339:
340: FND_LOG.String
341: (
342: FND_LOG.level_procedure
343: , L_LOG_MODULE || 'param 13'
344: , 'p_org_id ' || p_org_id
345: );
346:

Line 347: FND_LOG.String

343: , L_LOG_MODULE || 'param 13'
344: , 'p_org_id ' || p_org_id
345: );
346:
347: FND_LOG.String
348: (
349: FND_LOG.level_procedure
350: , L_LOG_MODULE || 'param 14'
351: , 'p_inv_org_id ' || p_inv_org_id

Line 349: FND_LOG.level_procedure

345: );
346:
347: FND_LOG.String
348: (
349: FND_LOG.level_procedure
350: , L_LOG_MODULE || 'param 14'
351: , 'p_inv_org_id ' || p_inv_org_id
352: );
353:

Line 500: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

496: Exception
497:
498: WHEN TOO_MANY_ROWS THEN
499:
500: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
501: THEN
502: FND_LOG.String
503: (
504: FND_LOG.level_unexpected

Line 502: FND_LOG.String

498: WHEN TOO_MANY_ROWS THEN
499:
500: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
501: THEN
502: FND_LOG.String
503: (
504: FND_LOG.level_unexpected
505: , L_LOG_MODULE || 'TOO_MANY_ROWS'
506: , 'Not able to fetch Employeee Number '

Line 504: FND_LOG.level_unexpected

500: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
501: THEN
502: FND_LOG.String
503: (
504: FND_LOG.level_unexpected
505: , L_LOG_MODULE || 'TOO_MANY_ROWS'
506: , 'Not able to fetch Employeee Number '
507: );
508: END IF ;

Line 521: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

517:
518: RAISE l_interface_error;
519:
520: WHEN NO_DATA_FOUND THEN
521: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
522: THEN
523: FND_LOG.String
524: (
525: FND_LOG.level_unexpected

Line 523: FND_LOG.String

519:
520: WHEN NO_DATA_FOUND THEN
521: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
522: THEN
523: FND_LOG.String
524: (
525: FND_LOG.level_unexpected
526: , L_LOG_MODULE || 'NO_DATA_FOUND'
527: , 'Not able to fetch Employeee Number '

Line 525: FND_LOG.level_unexpected

521: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
522: THEN
523: FND_LOG.String
524: (
525: FND_LOG.level_unexpected
526: , L_LOG_MODULE || 'NO_DATA_FOUND'
527: , 'Not able to fetch Employeee Number '
528: );
529: END IF ;

Line 545: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542:
543: WHEN OTHERS then
544:
545: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
546: THEN
547: FND_LOG.String
548: (
549: FND_LOG.level_unexpected

Line 547: FND_LOG.String

543: WHEN OTHERS then
544:
545: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
546: THEN
547: FND_LOG.String
548: (
549: FND_LOG.level_unexpected
550: , L_LOG_MODULE || 'OTHERS'
551: , 'Not able to fetch Employeee Number '

Line 549: FND_LOG.level_unexpected

545: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
546: THEN
547: FND_LOG.String
548: (
549: FND_LOG.level_unexpected
550: , L_LOG_MODULE || 'OTHERS'
551: , 'Not able to fetch Employeee Number '
552: );
553: END IF ;

Line 568: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

564:
565:
566:
567:
568: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
569: THEN
570: FND_LOG.String
571: (
572: FND_LOG.level_procedure

Line 570: FND_LOG.String

566:
567:
568: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
569: THEN
570: FND_LOG.String
571: (
572: FND_LOG.level_procedure
573: , L_LOG_MODULE || 'After Fetching Employee Number'
574: , 'Employee Number :'||l_employee_num

Line 572: FND_LOG.level_procedure

568: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
569: THEN
570: FND_LOG.String
571: (
572: FND_LOG.level_procedure
573: , L_LOG_MODULE || 'After Fetching Employee Number'
574: , 'Employee Number :'||l_employee_num
575: );
576:

Line 595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

591: WHERE organization_id = (select expenditure_org_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
592:
593: Exception
594: WHEN TOO_MANY_ROWS THEN
595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
596: THEN
597: FND_LOG.String
598: (
599: FND_LOG.level_unexpected

Line 597: FND_LOG.String

593: Exception
594: WHEN TOO_MANY_ROWS THEN
595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
596: THEN
597: FND_LOG.String
598: (
599: FND_LOG.level_unexpected
600: , L_LOG_MODULE || 'TOO_MANY_ROWS'
601: , 'Not able to fetch the organization name '

Line 599: FND_LOG.level_unexpected

595: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
596: THEN
597: FND_LOG.String
598: (
599: FND_LOG.level_unexpected
600: , L_LOG_MODULE || 'TOO_MANY_ROWS'
601: , 'Not able to fetch the organization name '
602: );
603: END IF ;

Line 612: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

608:
609: RAISE l_interface_error;
610:
611: WHEN NO_DATA_FOUND THEN
612: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
613: THEN
614: FND_LOG.String
615: (
616: FND_LOG.level_unexpected

Line 614: FND_LOG.String

610:
611: WHEN NO_DATA_FOUND THEN
612: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
613: THEN
614: FND_LOG.String
615: (
616: FND_LOG.level_unexpected
617: , L_LOG_MODULE || 'NO_DATA_FOUND'
618: , 'Not able to fetch the organization name '

Line 616: FND_LOG.level_unexpected

612: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
613: THEN
614: FND_LOG.String
615: (
616: FND_LOG.level_unexpected
617: , L_LOG_MODULE || 'NO_DATA_FOUND'
618: , 'Not able to fetch the organization name '
619: );
620: END IF ;

Line 632: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

628:
629: RAISE l_interface_error;
630:
631: WHEN OTHERS then
632: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
633: THEN
634: FND_LOG.String
635: (
636: FND_LOG.level_unexpected

Line 634: FND_LOG.String

630:
631: WHEN OTHERS then
632: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
633: THEN
634: FND_LOG.String
635: (
636: FND_LOG.level_unexpected
637: , L_LOG_MODULE || 'OTHERS'
638: , 'Not able to fetch the organization name '

Line 636: FND_LOG.level_unexpected

632: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
633: THEN
634: FND_LOG.String
635: (
636: FND_LOG.level_unexpected
637: , L_LOG_MODULE || 'OTHERS'
638: , 'Not able to fetch the organization name '
639: );
640: END IF ;

Line 651: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

647: End;
648:
649:
650:
651: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
652: THEN
653: FND_LOG.String
654: (
655: FND_LOG.level_procedure

Line 653: FND_LOG.String

649:
650:
651: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
652: THEN
653: FND_LOG.String
654: (
655: FND_LOG.level_procedure
656: , L_LOG_MODULE || 'After Fetching Expenditure Organization Name'
657: , 'Organization Name :'||l_organization_name

Line 655: FND_LOG.level_procedure

651: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
652: THEN
653: FND_LOG.String
654: (
655: FND_LOG.level_procedure
656: , L_LOG_MODULE || 'After Fetching Expenditure Organization Name'
657: , 'Organization Name :'||l_organization_name
658: );
659:

Line 688: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

684: WHERE project_id = (select project_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
685:
686: Exception
687: WHEN TOO_MANY_ROWS THEN
688: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
689: THEN
690: FND_LOG.String
691: (
692: FND_LOG.level_unexpected

Line 690: FND_LOG.String

686: Exception
687: WHEN TOO_MANY_ROWS THEN
688: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
689: THEN
690: FND_LOG.String
691: (
692: FND_LOG.level_unexpected
693: , L_LOG_MODULE || 'TOO_MANY_ROWS'
694: , 'Not able to fetch the Project Number '

Line 692: FND_LOG.level_unexpected

688: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
689: THEN
690: FND_LOG.String
691: (
692: FND_LOG.level_unexpected
693: , L_LOG_MODULE || 'TOO_MANY_ROWS'
694: , 'Not able to fetch the Project Number '
695: );
696: END IF ;

Line 704: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

700: FND_MSG_PUB.Add;
701: RAISE l_interface_error;
702:
703: WHEN NO_DATA_FOUND THEN
704: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
705: THEN
706: FND_LOG.String
707: (
708: FND_LOG.level_unexpected

Line 706: FND_LOG.String

702:
703: WHEN NO_DATA_FOUND THEN
704: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
705: THEN
706: FND_LOG.String
707: (
708: FND_LOG.level_unexpected
709: , L_LOG_MODULE || 'NO_DATA_FOUND'
710: , 'Not able to fetch the Project Number '

Line 708: FND_LOG.level_unexpected

704: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
705: THEN
706: FND_LOG.String
707: (
708: FND_LOG.level_unexpected
709: , L_LOG_MODULE || 'NO_DATA_FOUND'
710: , 'Not able to fetch the Project Number '
711: );
712: END IF ;

Line 724: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

720: FND_MSG_PUB.Add;
721:
722: RAISE l_interface_error;
723: WHEN OTHERS then
724: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
725: THEN
726: FND_LOG.String
727: (
728: FND_LOG.level_unexpected

Line 726: FND_LOG.String

722: RAISE l_interface_error;
723: WHEN OTHERS then
724: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
725: THEN
726: FND_LOG.String
727: (
728: FND_LOG.level_unexpected
729: , L_LOG_MODULE || 'OTHERS'
730: , 'Not able to fetch the Project Number '

Line 728: FND_LOG.level_unexpected

724: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
725: THEN
726: FND_LOG.String
727: (
728: FND_LOG.level_unexpected
729: , L_LOG_MODULE || 'OTHERS'
730: , 'Not able to fetch the Project Number '
731: );
732: END IF ;

Line 756: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

752: INTO l_task_num
753: FROM pa_tasks where task_id = (select project_task_id from cs_estimate_details where estimate_detail_id =l_estimate_detail_id );
754: Exception
755: WHEN TOO_MANY_ROWS THEN
756: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
757: THEN
758: FND_LOG.String
759: (
760: FND_LOG.level_unexpected

Line 758: FND_LOG.String

754: Exception
755: WHEN TOO_MANY_ROWS THEN
756: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
757: THEN
758: FND_LOG.String
759: (
760: FND_LOG.level_unexpected
761: , L_LOG_MODULE || 'TOO_MANY_ROWS'
762: , 'Not able to fetch the Project Task Number '

Line 760: FND_LOG.level_unexpected

756: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
757: THEN
758: FND_LOG.String
759: (
760: FND_LOG.level_unexpected
761: , L_LOG_MODULE || 'TOO_MANY_ROWS'
762: , 'Not able to fetch the Project Task Number '
763: );
764: END IF ;

Line 775: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

771:
772: RAISE l_interface_error;
773:
774: WHEN NO_DATA_FOUND THEN
775: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
776: THEN
777: FND_LOG.String
778: (
779: FND_LOG.level_unexpected

Line 777: FND_LOG.String

773:
774: WHEN NO_DATA_FOUND THEN
775: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
776: THEN
777: FND_LOG.String
778: (
779: FND_LOG.level_unexpected
780: , L_LOG_MODULE || 'NO_DATA_FOUND'
781: , 'Not able to fetch the Project Task Number '

Line 779: FND_LOG.level_unexpected

775: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
776: THEN
777: FND_LOG.String
778: (
779: FND_LOG.level_unexpected
780: , L_LOG_MODULE || 'NO_DATA_FOUND'
781: , 'Not able to fetch the Project Task Number '
782: );
783: END IF ;

Line 795: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

791:
792:
793: RAISE l_interface_error;
794: WHEN OTHERS then
795: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: (
799: FND_LOG.level_unexpected

Line 797: FND_LOG.String

793: RAISE l_interface_error;
794: WHEN OTHERS then
795: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: (
799: FND_LOG.level_unexpected
800: , L_LOG_MODULE || 'OTHERS'
801: , 'Not able to fetch the Project Task Number '

Line 799: FND_LOG.level_unexpected

795: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: (
799: FND_LOG.level_unexpected
800: , L_LOG_MODULE || 'OTHERS'
801: , 'Not able to fetch the Project Task Number '
802: );
803: END IF ;

Line 816: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

812:
813: End;
814:
815:
816: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
817: THEN
818: FND_LOG.String
819: (
820: FND_LOG.level_procedure

Line 818: FND_LOG.String

814:
815:
816: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
817: THEN
818: FND_LOG.String
819: (
820: FND_LOG.level_procedure
821: , L_LOG_MODULE || 'After Fetching Project Number and Task Number'
822: , 'Project Number :'||l_project_num ||'Project Task Number :'||l_task_num

Line 820: FND_LOG.level_procedure

816: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
817: THEN
818: FND_LOG.String
819: (
820: FND_LOG.level_procedure
821: , L_LOG_MODULE || 'After Fetching Project Number and Task Number'
822: , 'Project Number :'||l_project_num ||'Project Task Number :'||l_task_num
823: );
824:

Line 873: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

869: WHERE project_id = l_project_id;
870:
871: Exception
872: WHEN TOO_MANY_ROWS THEN
873: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
874: THEN
875: FND_LOG.String
876: (
877: FND_LOG.level_unexpected

Line 875: FND_LOG.String

871: Exception
872: WHEN TOO_MANY_ROWS THEN
873: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
874: THEN
875: FND_LOG.String
876: (
877: FND_LOG.level_unexpected
878: , L_LOG_MODULE || 'TOO_MANY_ROWS'
879: , 'Not able to fetch the Project Currency Code '

Line 877: FND_LOG.level_unexpected

873: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
874: THEN
875: FND_LOG.String
876: (
877: FND_LOG.level_unexpected
878: , L_LOG_MODULE || 'TOO_MANY_ROWS'
879: , 'Not able to fetch the Project Currency Code '
880: );
881: END IF ;

Line 887: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

883:
884: RAISE l_interface_error;
885:
886: WHEN NO_DATA_FOUND THEN
887: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
888: THEN
889: FND_LOG.String
890: (
891: FND_LOG.level_unexpected

Line 889: FND_LOG.String

885:
886: WHEN NO_DATA_FOUND THEN
887: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
888: THEN
889: FND_LOG.String
890: (
891: FND_LOG.level_unexpected
892: , L_LOG_MODULE || 'NO_DATA_FOUND'
893: , 'Not able to fetch the Project Currency Code '

Line 891: FND_LOG.level_unexpected

887: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
888: THEN
889: FND_LOG.String
890: (
891: FND_LOG.level_unexpected
892: , L_LOG_MODULE || 'NO_DATA_FOUND'
893: , 'Not able to fetch the Project Currency Code '
894: );
895: END IF ;

Line 907: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

903:
904:
905: RAISE l_interface_error;
906: WHEN OTHERS then
907: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
908: THEN
909: FND_LOG.String
910: (
911: FND_LOG.level_unexpected

Line 909: FND_LOG.String

905: RAISE l_interface_error;
906: WHEN OTHERS then
907: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
908: THEN
909: FND_LOG.String
910: (
911: FND_LOG.level_unexpected
912: , L_LOG_MODULE || 'OTHERS'
913: , 'Not able to fetch the Project Currency Code '

Line 911: FND_LOG.level_unexpected

907: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
908: THEN
909: FND_LOG.String
910: (
911: FND_LOG.level_unexpected
912: , L_LOG_MODULE || 'OTHERS'
913: , 'Not able to fetch the Project Currency Code '
914: );
915: END IF ;

Line 938: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

934:
935:
936:
937:
938: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
939: THEN
940: FND_LOG.String
941: (
942: FND_LOG.level_procedure

Line 940: FND_LOG.String

936:
937:
938: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
939: THEN
940: FND_LOG.String
941: (
942: FND_LOG.level_procedure
943: , L_LOG_MODULE || 'After Fetching Raw Cost'
944: , 'Raw Cost :'||l_raw_cost

Line 942: FND_LOG.level_procedure

938: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
939: THEN
940: FND_LOG.String
941: (
942: FND_LOG.level_procedure
943: , L_LOG_MODULE || 'After Fetching Raw Cost'
944: , 'Raw Cost :'||l_raw_cost
945: );
946:

Line 1126: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1122: and transaction_source = l_transaction_source;
1123:
1124: Exception
1125: WHEN OTHERS then
1126: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1127: THEN
1128: FND_LOG.String
1129: (
1130: FND_LOG.level_unexpected

Line 1128: FND_LOG.String

1124: Exception
1125: WHEN OTHERS then
1126: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1127: THEN
1128: FND_LOG.String
1129: (
1130: FND_LOG.level_unexpected
1131: , L_LOG_MODULE || 'OTHERS'
1132: , 'Not able to fetch the Costed Flag '

Line 1130: FND_LOG.level_unexpected

1126: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1127: THEN
1128: FND_LOG.String
1129: (
1130: FND_LOG.level_unexpected
1131: , L_LOG_MODULE || 'OTHERS'
1132: , 'Not able to fetch the Costed Flag '
1133: );
1134: END IF ;

Line 1257: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1253:
1254: End if;
1255: Exception
1256: WHEN TOO_MANY_ROWS THEN
1257: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1258: THEN
1259: FND_LOG.String
1260: (
1261: FND_LOG.level_unexpected

Line 1259: FND_LOG.String

1255: Exception
1256: WHEN TOO_MANY_ROWS THEN
1257: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1258: THEN
1259: FND_LOG.String
1260: (
1261: FND_LOG.level_unexpected
1262: , L_LOG_MODULE || 'TOO_MANY_ROWS'
1263: , 'Not able to fetch the Person Id '

Line 1261: FND_LOG.level_unexpected

1257: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1258: THEN
1259: FND_LOG.String
1260: (
1261: FND_LOG.level_unexpected
1262: , L_LOG_MODULE || 'TOO_MANY_ROWS'
1263: , 'Not able to fetch the Person Id '
1264: );
1265: END IF ;

Line 1275: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1271:
1272: RAISE l_interface_error;
1273:
1274: WHEN NO_DATA_FOUND THEN
1275: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1276: THEN
1277: FND_LOG.String
1278: (
1279: FND_LOG.level_unexpected

Line 1277: FND_LOG.String

1273:
1274: WHEN NO_DATA_FOUND THEN
1275: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1276: THEN
1277: FND_LOG.String
1278: (
1279: FND_LOG.level_unexpected
1280: , L_LOG_MODULE || 'NO_DATA_FOUND'
1281: , 'Not able to fetch the Person Id '

Line 1279: FND_LOG.level_unexpected

1275: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1276: THEN
1277: FND_LOG.String
1278: (
1279: FND_LOG.level_unexpected
1280: , L_LOG_MODULE || 'NO_DATA_FOUND'
1281: , 'Not able to fetch the Person Id '
1282: );
1283: END IF ;

Line 1294: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1290: -- FND_MSG_PUB.ADD;
1291:
1292: RAISE l_interface_error;
1293: WHEN OTHERS then
1294: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1295: THEN
1296: FND_LOG.String
1297: (
1298: FND_LOG.level_unexpected

Line 1296: FND_LOG.String

1292: RAISE l_interface_error;
1293: WHEN OTHERS then
1294: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1295: THEN
1296: FND_LOG.String
1297: (
1298: FND_LOG.level_unexpected
1299: , L_LOG_MODULE || 'OTHERS'
1300: , 'Not able to fetch the Person Id '

Line 1298: FND_LOG.level_unexpected

1294: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1295: THEN
1296: FND_LOG.String
1297: (
1298: FND_LOG.level_unexpected
1299: , L_LOG_MODULE || 'OTHERS'
1300: , 'Not able to fetch the Person Id '
1301: );
1302: END IF ;

Line 1320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1316:
1317:
1318:
1319:
1320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1321: THEN
1322: FND_LOG.String
1323: (
1324: FND_LOG.level_procedure

Line 1322: FND_LOG.String

1318:
1319:
1320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1321: THEN
1322: FND_LOG.String
1323: (
1324: FND_LOG.level_procedure
1325: , L_LOG_MODULE || 'After Fetching Person Id'
1326: , 'Person Id:'||l_person_id

Line 1324: FND_LOG.level_procedure

1320: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1321: THEN
1322: FND_LOG.String
1323: (
1324: FND_LOG.level_procedure
1325: , L_LOG_MODULE || 'After Fetching Person Id'
1326: , 'Person Id:'||l_person_id
1327: );
1328:

Line 1378: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1374:
1375:
1376: Exception
1377: WHEN TOO_MANY_ROWS THEN
1378: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1379: THEN
1380: FND_LOG.String
1381: (
1382: FND_LOG.level_unexpected

Line 1380: FND_LOG.String

1376: Exception
1377: WHEN TOO_MANY_ROWS THEN
1378: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1379: THEN
1380: FND_LOG.String
1381: (
1382: FND_LOG.level_unexpected
1383: , L_LOG_MODULE || 'TOO_MANY_ROWS'
1384: , 'Not able to fetch the business_group_id '

Line 1382: FND_LOG.level_unexpected

1378: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1379: THEN
1380: FND_LOG.String
1381: (
1382: FND_LOG.level_unexpected
1383: , L_LOG_MODULE || 'TOO_MANY_ROWS'
1384: , 'Not able to fetch the business_group_id '
1385: );
1386: END IF ;

Line 1395: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1391:
1392: RAISE l_interface_error;
1393:
1394: WHEN NO_DATA_FOUND THEN
1395: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1396: THEN
1397: FND_LOG.String
1398: (
1399: FND_LOG.level_unexpected

Line 1397: FND_LOG.String

1393:
1394: WHEN NO_DATA_FOUND THEN
1395: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1396: THEN
1397: FND_LOG.String
1398: (
1399: FND_LOG.level_unexpected
1400: , L_LOG_MODULE || 'NO_DATA_FOUND'
1401: , 'Not able to fetch the business_group_id '

Line 1399: FND_LOG.level_unexpected

1395: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1396: THEN
1397: FND_LOG.String
1398: (
1399: FND_LOG.level_unexpected
1400: , L_LOG_MODULE || 'NO_DATA_FOUND'
1401: , 'Not able to fetch the business_group_id '
1402: );
1403: END IF ;

Line 1414: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1410: FND_MSG_PUB.Add;
1411:
1412: RAISE l_interface_error;
1413: WHEN OTHERS then
1414: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1415: THEN
1416: FND_LOG.String
1417: (
1418: FND_LOG.level_unexpected

Line 1416: FND_LOG.String

1412: RAISE l_interface_error;
1413: WHEN OTHERS then
1414: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1415: THEN
1416: FND_LOG.String
1417: (
1418: FND_LOG.level_unexpected
1419: , L_LOG_MODULE || 'OTHERS'
1420: , 'Not able to fetch the business_group_id '

Line 1418: FND_LOG.level_unexpected

1414: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1415: THEN
1416: FND_LOG.String
1417: (
1418: FND_LOG.level_unexpected
1419: , L_LOG_MODULE || 'OTHERS'
1420: , 'Not able to fetch the business_group_id '
1421: );
1422: END IF ;

Line 1433: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1429: End;
1430:
1431:
1432:
1433: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1434: THEN
1435: FND_LOG.String
1436: (
1437: FND_LOG.level_procedure

Line 1435: FND_LOG.String

1431:
1432:
1433: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1434: THEN
1435: FND_LOG.String
1436: (
1437: FND_LOG.level_procedure
1438: , L_LOG_MODULE || 'After Fetching Business Group Id'
1439: , 'l_business_group_id:'||l_business_group_id

Line 1437: FND_LOG.level_procedure

1433: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1434: THEN
1435: FND_LOG.String
1436: (
1437: FND_LOG.level_procedure
1438: , L_LOG_MODULE || 'After Fetching Business Group Id'
1439: , 'l_business_group_id:'||l_business_group_id
1440: );
1441:

Line 1528: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1524: End if;
1525:
1526:
1527:
1528: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1529: THEN
1530: FND_LOG.String
1531: (
1532: FND_LOG.level_procedure

Line 1530: FND_LOG.String

1526:
1527:
1528: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1529: THEN
1530: FND_LOG.String
1531: (
1532: FND_LOG.level_procedure
1533: , L_LOG_MODULE || 'Before inserting into PA_TRANSACTION_INTERFACE_ALL table'
1534: , 'Begins'

Line 1532: FND_LOG.level_procedure

1528: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1529: THEN
1530: FND_LOG.String
1531: (
1532: FND_LOG.level_procedure
1533: , L_LOG_MODULE || 'Before inserting into PA_TRANSACTION_INTERFACE_ALL table'
1534: , 'Begins'
1535: );
1536:

Line 1802: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1798: end if;
1799:
1800:
1801:
1802: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1803: THEN
1804: FND_LOG.String
1805: (
1806: FND_LOG.level_procedure

Line 1804: FND_LOG.String

1800:
1801:
1802: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1803: THEN
1804: FND_LOG.String
1805: (
1806: FND_LOG.level_procedure
1807: , L_LOG_MODULE || 'After inserting into PA_TRANSACTION_INTERFACE_ALL table'
1808: , 'ends'

Line 1806: FND_LOG.level_procedure

1802: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1803: THEN
1804: FND_LOG.String
1805: (
1806: FND_LOG.level_procedure
1807: , L_LOG_MODULE || 'After inserting into PA_TRANSACTION_INTERFACE_ALL table'
1808: , 'ends'
1809: );
1810:

Line 1821: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1817:
1818: When l_interface_error then
1819:
1820:
1821: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1822: THEN
1823: FND_LOG.String
1824: (
1825: FND_LOG.level_procedure

Line 1823: FND_LOG.String

1819:
1820:
1821: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1822: THEN
1823: FND_LOG.String
1824: (
1825: FND_LOG.level_procedure
1826: , L_LOG_MODULE || 'Inside exception'
1827: ,'sqlerrm:'||sqlerrm

Line 1825: FND_LOG.level_procedure

1821: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1822: THEN
1823: FND_LOG.String
1824: (
1825: FND_LOG.level_procedure
1826: , L_LOG_MODULE || 'Inside exception'
1827: ,'sqlerrm:'||sqlerrm
1828: );
1829:

Line 1865: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

1861:
1862: WHEN OTHERS THEN
1863:
1864:
1865: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1866: THEN
1867: FND_LOG.String
1868: (
1869: FND_LOG.level_procedure

Line 1867: FND_LOG.String

1863:
1864:
1865: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1866: THEN
1867: FND_LOG.String
1868: (
1869: FND_LOG.level_procedure
1870: , L_LOG_MODULE || 'Inside exception'
1871: ,'sqlerrm:'||sqlerrm

Line 1869: FND_LOG.level_procedure

1865: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1866: THEN
1867: FND_LOG.String
1868: (
1869: FND_LOG.level_procedure
1870: , L_LOG_MODULE || 'Inside exception'
1871: ,'sqlerrm:'||sqlerrm
1872: );
1873: