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

Line 224: fnd_file.put_line(fnd_file.log , g_error);

220: exception
221: when others then
222: table_delete;
223: g_error := sqlcode || ' ' || sqlerrm;
224: fnd_file.put_line(fnd_file.log , g_error);
225:
226: END Run_Engine;
227:
228: --

Line 561: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);

557: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ;
558: EXECUTE IMMEDIATE (insert_stmnt_sum);
559: ELSE
560: RAISE SUMMATION_ERROR;
561: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);
562: END IF;
563:
564: END IF;
565:

Line 750: fnd_file.put_line(fnd_file.log , g_error);

746: EXCEPTION
747: when Tablesegment_full then
748: CSC_Profile_Engine_PKG.Handle_Exception;
749: g_error := sqlcode || ' ' || sqlerrm;
750: fnd_file.put_line(fnd_file.log , g_error);
751: App_Exception.raise_exception;
752:
753: when Indexsegment_full then
754: CSC_Profile_Engine_PKG.Handle_Exception;

Line 756: fnd_file.put_line(fnd_file.log , g_error);

752:
753: when Indexsegment_full then
754: CSC_Profile_Engine_PKG.Handle_Exception;
755: g_error := sqlcode || ' ' || sqlerrm;
756: fnd_file.put_line(fnd_file.log , g_error);
757: App_Exception.raise_exception;
758:
759: when SNAPSHOT_TOO_OLD THEN
760: CSC_Profile_Engine_PKG.Handle_Exception;

Line 762: fnd_file.put_line(fnd_file.log,g_error);

758:
759: when SNAPSHOT_TOO_OLD THEN
760: CSC_Profile_Engine_PKG.Handle_Exception;
761: g_error := sqlcode || ' ' || sqlerrm;
762: fnd_file.put_line(fnd_file.log,g_error);
763: App_Exception.raise_exception;
764:
765: WHEN INTERNAL_ERROR THEN
766: CSC_Profile_Engine_PKG.Handle_Exception;

Line 768: fnd_file.put_line(fnd_file.log,g_error);

764:
765: WHEN INTERNAL_ERROR THEN
766: CSC_Profile_Engine_PKG.Handle_Exception;
767: g_error := sqlcode || ' ' || sqlerrm;
768: fnd_file.put_line(fnd_file.log,g_error);
769: App_Exception.raise_exception;
770:
771: WHEN SUMMATION_ERROR THEN
772: CSC_Profile_Engine_PKG.Handle_Exception;

Line 780: fnd_file.put_line(fnd_file.log , g_error);

776:
777: WHEN OTHERS THEN
778: CSC_Profile_Engine_PKG.Handle_Exception;
779: g_error := sqlcode || ' ' || sqlerrm;
780: fnd_file.put_line(fnd_file.log , g_error);
781:
782: END Evaluate_Checks1_Var;
783: --
784: -- Evaluate_Checks1_No_Batch

Line 1057: fnd_file.close;

1053: retcode := 0;
1054: END IF;
1055:
1056: IF (debug) THEN
1057: fnd_file.close;
1058: END IF;
1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN

Line 1073: fnd_file.close;

1069: IF (caccount_csr%isopen) THEN
1070: CLOSE caccount_csr;
1071: END IF;
1072: IF (debug) THEN
1073: fnd_file.close;
1074: END IF;
1075:
1076: -- Retrieve error message into errbuf
1077: errbuf := Sqlerrm;

Line 1083: fnd_file.put_line(fnd_file.log , g_error);

1079: -- Return 2 for error
1080: retcode := 2;
1081:
1082: g_error := sqlcode || ' ' || sqlerrm;
1083: fnd_file.put_line(fnd_file.log , g_error);
1084:
1085: /* End of R12 Employee HelpDesk Modifications */
1086:
1087: END Evaluate_Checks1_No_Batch;

Line 1413: fnd_file.close;

1409: retcode := 0;
1410: END IF;
1411:
1412: IF (debug) THEN
1413: fnd_file.close;
1414: END IF;
1415:
1416: EXCEPTION
1417: WHEN OTHERS THEN

Line 1429: fnd_file.close;

1425: IF (caccount_csr%isopen) THEN
1426: CLOSE caccount_csr;
1427: END IF;
1428: IF (debug) THEN
1429: fnd_file.close;
1430: END IF;
1431:
1432: -- Retrieve error message into errbuf
1433: errbuf := Sqlerrm;

Line 1439: fnd_file.put_line(fnd_file.log , g_error);

1435: -- Return 2 for error
1436: retcode := 2;
1437:
1438: g_error := sqlcode || ' ' || sqlerrm;
1439: fnd_file.put_line(fnd_file.log , g_error);
1440:
1441: END Evaluate_Checks1_Rule;
1442:
1443: /******************************************

Line 1956: fnd_file.close;

1952: retcode := 0;
1953: END IF;
1954:
1955: IF (debug) THEN
1956: fnd_file.close;
1957: END IF;
1958:
1959: EXCEPTION
1960: WHEN OTHERS THEN

Line 1967: fnd_file.close;

1963: CLOSE checks_csr;
1964: END IF;
1965:
1966: IF (debug) THEN
1967: fnd_file.close;
1968: END IF;
1969:
1970: -- Retrieve error message into errbuf
1971: errbuf := Sqlerrm;

Line 1977: fnd_file.put_line(fnd_file.log , g_error);

1973: -- Return 2 for error
1974: retcode := 2;
1975:
1976: g_error := sqlcode || ' ' || sqlerrm;
1977: fnd_file.put_line(fnd_file.log , g_error);
1978:
1979: END Evaluate_Checks2;
1980:
1981:

Line 2465: fnd_file.close;

2461: retcode := 0;
2462: END IF;
2463:
2464: IF (debug) THEN
2465: fnd_file.close;
2466: END IF;
2467:
2468: EXCEPTION
2469: WHEN OTHERS THEN

Line 2475: fnd_file.close;

2471: IF (checks_csr%isopen) THEN
2472: CLOSE checks_csr;
2473: END IF;
2474: IF (debug) THEN
2475: fnd_file.close;
2476: END IF;
2477: -- Retrieve error message into errbuf
2478: errbuf := Sqlerrm;
2479: -- Return 2 for error

Line 2482: fnd_file.put_line(fnd_file.log , g_error);

2478: errbuf := Sqlerrm;
2479: -- Return 2 for error
2480: retcode := 2;
2481: g_error := sqlcode || ' ' || sqlerrm;
2482: fnd_file.put_line(fnd_file.log , g_error);
2483:
2484: END Evaluate_Checks3;
2485:
2486: -- This procedure evaluates the checks for all parties/account in a particular group

Line 2744: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);

2740: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T ' || v_select_sum ;
2741: EXECUTE IMMEDIATE (insert_stmnt_sum);
2742: ELSE
2743: RAISE SUMMATION_ERROR;
2744: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);
2745: END IF;
2746:
2747: END IF;
2748:

Line 3255: fnd_file.close;

3251: retcode := 0;
3252: END IF;
3253:
3254: IF (debug) THEN
3255: fnd_file.close;
3256: END IF;
3257:
3258: EXCEPTION
3259: WHEN OTHERS THEN

Line 3271: fnd_file.close;

3267: IF (caccount_csr%isopen) THEN
3268: CLOSE caccount_csr;
3269: END IF;
3270: IF (debug) THEN
3271: fnd_file.close;
3272: END IF;
3273:
3274: -- Retrieve error message into errbuf
3275: errbuf := Sqlerrm;

Line 3281: fnd_file.put_line(fnd_file.log , g_error);

3277: -- Return 2 for error
3278: retcode := 2;
3279:
3280: g_error := sqlcode || ' ' || sqlerrm;
3281: fnd_file.put_line(fnd_file.log , g_error);
3282:
3283: END Evaluate_Checks4_No_Batch;
3284: --
3285: -- Evaluate_Checks4_Rule

Line 3615: fnd_file.close;

3611: retcode := 0;
3612: END IF;
3613:
3614: IF (debug) THEN
3615: fnd_file.close;
3616: END IF;
3617:
3618: EXCEPTION
3619: WHEN OTHERS THEN

Line 3631: fnd_file.close;

3627: IF (caccount_csr%isopen) THEN
3628: CLOSE caccount_csr;
3629: END IF;
3630: IF (debug) THEN
3631: fnd_file.close;
3632: END IF;
3633:
3634: -- Retrieve error message into errbuf
3635: errbuf := Sqlerrm;

Line 3641: fnd_file.put_line(fnd_file.log , g_error);

3637: -- Return 2 for error
3638: retcode := 2;
3639:
3640: g_error := sqlcode || ' ' || sqlerrm;
3641: fnd_file.put_line(fnd_file.log , g_error);
3642:
3643: END Evaluate_Checks4_Rule;
3644: --
3645: -- Evaluate_One_Check

Line 5649: fnd_file.close;

5645: retcode := 0;
5646: END IF;
5647:
5648: IF (debug) THEN
5649: fnd_file.close;
5650: END IF;
5651:
5652: EXCEPTION
5653: WHEN OTHERS THEN

Line 5663: fnd_file.close;

5659: CLOSE crelparty_csr;
5660: END IF;
5661:
5662: IF (debug) THEN
5663: fnd_file.close;
5664: END IF;
5665: errbuf := Sqlerrm;
5666: retcode := 2;
5667:

Line 5669: fnd_file.put_line(fnd_file.log , g_error);

5665: errbuf := Sqlerrm;
5666: retcode := 2;
5667:
5668: g_error := sqlcode || ' ' || sqlerrm;
5669: fnd_file.put_line(fnd_file.log , g_error);
5670:
5671: END Evaluate_Checks_Rel;
5672:
5673: /* R12 Employee HelpDesk Modifications */

Line 6111: fnd_file.close;

6107: retcode := 0;
6108: END IF;
6109:
6110: IF (debug) THEN
6111: fnd_file.close;
6112: END IF;
6113:
6114: EXCEPTION
6115: WHEN OTHERS THEN

Line 6125: fnd_file.close;

6121: CLOSE employee_csr;
6122: END IF;
6123:
6124: IF (debug) THEN
6125: fnd_file.close;
6126: END IF;
6127: errbuf := Sqlerrm;
6128: retcode := 2;
6129:

Line 6131: fnd_file.put_line(fnd_file.log , g_error);

6127: errbuf := Sqlerrm;
6128: retcode := 2;
6129:
6130: g_error := sqlcode || ' ' || sqlerrm;
6131: fnd_file.put_line(fnd_file.log , g_error);
6132:
6133: END Evaluate_Checks_Emp;
6134:
6135: /* End of R12 Employee HelpDesk Modifications */

Line 6554: fnd_file.put_line(fnd_file.log , g_error);

6550:
6551: exception
6552: when Indexsegment_full then
6553: g_error := sqlcode || ' ' || sqlerrm;
6554: fnd_file.put_line(fnd_file.log , g_error);
6555: App_Exception.raise_exception;
6556:
6557: when Tablesegment_full then
6558: g_error := sqlcode || ' ' || sqlerrm;

Line 6559: fnd_file.put_line(fnd_file.log , g_error);

6555: App_Exception.raise_exception;
6556:
6557: when Tablesegment_full then
6558: g_error := sqlcode || ' ' || sqlerrm;
6559: fnd_file.put_line(fnd_file.log , g_error);
6560: App_Exception.raise_exception;
6561:
6562: WHEN SNAPSHOT_TOO_OLD THEN
6563: g_error := sqlcode || ' ' || sqlerrm;

Line 6564: fnd_file.put_line(fnd_file.log,g_error);

6560: App_Exception.raise_exception;
6561:
6562: WHEN SNAPSHOT_TOO_OLD THEN
6563: g_error := sqlcode || ' ' || sqlerrm;
6564: fnd_file.put_line(fnd_file.log,g_error);
6565: App_Exception.raise_exception;
6566:
6567: when Others then
6568: table_delete;

Line 6570: fnd_file.put_line(fnd_file.log , g_error);

6566:
6567: when Others then
6568: table_delete;
6569: g_error := sqlcode || ' ' || sqlerrm;
6570: fnd_file.put_line(fnd_file.log , g_error);
6571:
6572: END Insert_Update_Block_Results;
6573:
6574: --

Line 6758: fnd_file.put_line(fnd_file.log , g_error);

6754: exception
6755:
6756: when Tablesegment_full then
6757: g_error := sqlcode || ' ' || sqlerrm;
6758: fnd_file.put_line(fnd_file.log , g_error);
6759: App_Exception.raise_exception;
6760:
6761: when Indexsegment_full then
6762: g_error := sqlcode || ' ' || sqlerrm;

Line 6763: fnd_file.put_line(fnd_file.log , g_error);

6759: App_Exception.raise_exception;
6760:
6761: when Indexsegment_full then
6762: g_error := sqlcode || ' ' || sqlerrm;
6763: fnd_file.put_line(fnd_file.log , g_error);
6764: App_Exception.raise_exception;
6765:
6766: when SNAPSHOT_TOO_OLD THEN
6767: g_error := sqlcode || ' ' || sqlerrm;

Line 6768: fnd_file.put_line(fnd_file.log,g_error);

6764: App_Exception.raise_exception;
6765:
6766: when SNAPSHOT_TOO_OLD THEN
6767: g_error := sqlcode || ' ' || sqlerrm;
6768: fnd_file.put_line(fnd_file.log,g_error);
6769: App_Exception.raise_exception;
6770: when Others then
6771: table_delete;
6772: g_error := sqlcode || ' ' || sqlerrm;

Line 6773: fnd_file.put_line(fnd_file.log , g_error);

6769: App_Exception.raise_exception;
6770: when Others then
6771: table_delete;
6772: g_error := sqlcode || ' ' || sqlerrm;
6773: fnd_file.put_line(fnd_file.log , g_error);
6774:
6775: END Insert_Update_Check_Results;
6776:
6777:

Line 7695: fnd_file.put(FND_FILE.LOG, proc_name||'(');

7691: BEGIN
7692:
7693: -- Start with procedure name.
7694: IF (proc_name IS NOT NULL) THEN
7695: fnd_file.put(FND_FILE.LOG, proc_name||'(');
7696: END IF;
7697:
7698: -- Add all defined args.
7699: IF (arg1 <> '*none*') THEN

Line 7700: fnd_file.put(FND_FILE.LOG, arg1);

7696: END IF;
7697:
7698: -- Add all defined args.
7699: IF (arg1 <> '*none*') THEN
7700: fnd_file.put(FND_FILE.LOG, arg1);
7701: END IF;
7702: IF (arg2 <> '*none*') THEN
7703: fnd_file.put(FND_FILE.LOG, ', '||arg2);
7704: END IF;

Line 7703: fnd_file.put(FND_FILE.LOG, ', '||arg2);

7699: IF (arg1 <> '*none*') THEN
7700: fnd_file.put(FND_FILE.LOG, arg1);
7701: END IF;
7702: IF (arg2 <> '*none*') THEN
7703: fnd_file.put(FND_FILE.LOG, ', '||arg2);
7704: END IF;
7705: IF (arg3 <> '*none*') THEN
7706: fnd_file.put(FND_FILE.LOG, ', '||arg3);
7707: END IF;

Line 7706: fnd_file.put(FND_FILE.LOG, ', '||arg3);

7702: IF (arg2 <> '*none*') THEN
7703: fnd_file.put(FND_FILE.LOG, ', '||arg2);
7704: END IF;
7705: IF (arg3 <> '*none*') THEN
7706: fnd_file.put(FND_FILE.LOG, ', '||arg3);
7707: END IF;
7708: IF (arg4 <> '*none*') THEN
7709: fnd_file.put(FND_FILE.LOG, ', '||arg4);
7710: END IF;

Line 7709: fnd_file.put(FND_FILE.LOG, ', '||arg4);

7705: IF (arg3 <> '*none*') THEN
7706: fnd_file.put(FND_FILE.LOG, ', '||arg3);
7707: END IF;
7708: IF (arg4 <> '*none*') THEN
7709: fnd_file.put(FND_FILE.LOG, ', '||arg4);
7710: END IF;
7711: IF (arg5 <> '*none*') THEN
7712: fnd_file.put(FND_FILE.LOG, ', '||arg5);
7713: END IF;

Line 7712: fnd_file.put(FND_FILE.LOG, ', '||arg5);

7708: IF (arg4 <> '*none*') THEN
7709: fnd_file.put(FND_FILE.LOG, ', '||arg4);
7710: END IF;
7711: IF (arg5 <> '*none*') THEN
7712: fnd_file.put(FND_FILE.LOG, ', '||arg5);
7713: END IF;
7714:
7715: IF (proc_name IS NOT NULL) THEN
7716: fnd_file.put_line(FND_FILE.LOG, ')');

Line 7716: fnd_file.put_line(FND_FILE.LOG, ')');

7712: fnd_file.put(FND_FILE.LOG, ', '||arg5);
7713: END IF;
7714:
7715: IF (proc_name IS NOT NULL) THEN
7716: fnd_file.put_line(FND_FILE.LOG, ')');
7717: ELSE
7718: fnd_file.new_line(FND_FILE.LOG);
7719: END IF;
7720:

Line 7718: fnd_file.new_line(FND_FILE.LOG);

7714:
7715: IF (proc_name IS NOT NULL) THEN
7716: fnd_file.put_line(FND_FILE.LOG, ')');
7717: ELSE
7718: fnd_file.new_line(FND_FILE.LOG);
7719: END IF;
7720:
7721: EXCEPTION
7722: WHEN UTL_FILE.INVALID_FILEHANDLE THEN