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 236: fnd_file.put_line(fnd_file.log , g_error);

232: Exception
233: when others then
234: table_delete;
235: g_error := sqlcode || ' ' || sqlerrm;
236: fnd_file.put_line(fnd_file.log , g_error);
237: END Run_Engine;
238:
239: --
240: -- Bug 1942032 to run engine as a concurrent program - overloaded procedure when

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

601: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) ' || v_select_sum ;
602: EXECUTE IMMEDIATE (insert_stmnt_sum);
603: ELSE
604: RAISE SUMMATION_ERROR;
605: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);
606: END IF;
607: END IF;
608: IF v_check_level = 'PARTY' THEN
609: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

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

914: EXCEPTION
915: when Tablesegment_full then
916: CSC_Profile_Engine_PKG.Handle_Exception;
917: g_error := sqlcode || ' ' || sqlerrm;
918: fnd_file.put_line(fnd_file.log , g_error);
919: App_Exception.raise_exception;
920:
921: when Indexsegment_full then
922: CSC_Profile_Engine_PKG.Handle_Exception;

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

920:
921: when Indexsegment_full then
922: CSC_Profile_Engine_PKG.Handle_Exception;
923: g_error := sqlcode || ' ' || sqlerrm;
924: fnd_file.put_line(fnd_file.log , g_error);
925: App_Exception.raise_exception;
926:
927: when SNAPSHOT_TOO_OLD THEN
928: CSC_Profile_Engine_PKG.Handle_Exception;

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

926:
927: when SNAPSHOT_TOO_OLD THEN
928: CSC_Profile_Engine_PKG.Handle_Exception;
929: g_error := sqlcode || ' ' || sqlerrm;
930: fnd_file.put_line(fnd_file.log,g_error);
931: App_Exception.raise_exception;
932:
933: WHEN INTERNAL_ERROR THEN
934: CSC_Profile_Engine_PKG.Handle_Exception;

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

932:
933: WHEN INTERNAL_ERROR THEN
934: CSC_Profile_Engine_PKG.Handle_Exception;
935: g_error := sqlcode || ' ' || sqlerrm;
936: fnd_file.put_line(fnd_file.log,g_error);
937: App_Exception.raise_exception;
938:
939: WHEN SUMMATION_ERROR THEN
940: CSC_Profile_Engine_PKG.Handle_Exception;

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

944:
945: WHEN OTHERS THEN
946: CSC_Profile_Engine_PKG.Handle_Exception;
947: g_error := sqlcode || ' ' || sqlerrm;
948: fnd_file.put_line(fnd_file.log , g_error);
949:
950: END Evaluate_Checks1_Var;
951: --
952: -- Evaluate_Checks1_No_Batch

Line 1363: fnd_file.close;

1359: retcode := 0;
1360: END IF;
1361:
1362: IF (debug) THEN
1363: fnd_file.close;
1364: END IF;
1365:
1366: EXCEPTION
1367: WHEN OTHERS THEN

Line 1384: fnd_file.close;

1380: CLOSE cpsite_csr;
1381: END IF;
1382: -- End fix by spamujul for ER#8473903
1383: IF (debug) THEN
1384: fnd_file.close;
1385: END IF;
1386:
1387: -- Retrieve error message into errbuf
1388: errbuf := Sqlerrm;

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

1390: -- Return 2 for error
1391: retcode := 2;
1392:
1393: g_error := sqlcode || ' ' || sqlerrm;
1394: fnd_file.put_line(fnd_file.log , g_error);
1395:
1396: /* End of R12 Employee HelpDesk Modifications */
1397:
1398: END Evaluate_Checks1_No_Batch;

Line 1873: fnd_file.close;

1869: retcode := 0;
1870: END IF;
1871:
1872: IF (debug) THEN
1873: fnd_file.close;
1874: END IF;
1875:
1876: EXCEPTION
1877: WHEN OTHERS THEN

Line 1894: fnd_file.close;

1890: CLOSE cpsite_csr;
1891: END IF;
1892: -- End fix by spamujul for ER#8473903
1893: IF (debug) THEN
1894: fnd_file.close;
1895: END IF;
1896:
1897: -- Retrieve error message into errbuf
1898: errbuf := Sqlerrm;

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

1900: -- Return 2 for error
1901: retcode := 2;
1902:
1903: g_error := sqlcode || ' ' || sqlerrm;
1904: fnd_file.put_line(fnd_file.log , g_error);
1905:
1906: END Evaluate_Checks1_Rule;
1907:
1908: /******************************************

Line 2669: fnd_file.close;

2665: retcode := 0;
2666: END IF;
2667:
2668: IF (debug) THEN
2669: fnd_file.close;
2670: END IF;
2671: EXCEPTION
2672: WHEN OTHERS THEN
2673: ROLLBACK;

Line 2678: fnd_file.close;

2674: IF (checks_csr%isopen) THEN
2675: CLOSE checks_csr;
2676: END IF;
2677: IF (debug) THEN
2678: fnd_file.close;
2679: END IF;
2680: -- Retrieve error message into errbuf
2681: errbuf := Sqlerrm;
2682: -- Return 2 for error

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

2681: errbuf := Sqlerrm;
2682: -- Return 2 for error
2683: retcode := 2;
2684: g_error := sqlcode || ' ' || sqlerrm;
2685: fnd_file.put_line(fnd_file.log , g_error);
2686: END Evaluate_Checks2;
2687: --
2688: -- Evaluate_Checks3
2689: -- Loop through all checks and evaluate the results

Line 3547: fnd_file.close;

3543: retcode := 0;
3544: END IF;
3545:
3546: IF (debug) THEN
3547: fnd_file.close;
3548: END IF;
3549:
3550: EXCEPTION
3551: WHEN OTHERS THEN

Line 3557: fnd_file.close;

3553: IF (checks_csr%isopen) THEN
3554: CLOSE checks_csr;
3555: END IF;
3556: IF (debug) THEN
3557: fnd_file.close;
3558: END IF;
3559: -- Retrieve error message into errbuf
3560: errbuf := Sqlerrm;
3561: -- Return 2 for error

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

3560: errbuf := Sqlerrm;
3561: -- Return 2 for error
3562: retcode := 2;
3563: g_error := sqlcode || ' ' || sqlerrm;
3564: fnd_file.put_line(fnd_file.log , g_error);
3565: END Evaluate_Checks3;
3566:
3567: -- This procedure evaluates the checks for all parties/account in a particular group
3568: -- The batch sql statement is not null and profile check is of type variable ('B')

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

3849: insert_stmnt_sum := 'INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE)' || v_select_sum ;
3850: EXECUTE IMMEDIATE (insert_stmnt_sum);
3851: ELSE
3852: RAISE SUMMATION_ERROR;
3853: fnd_file.put_line(fnd_file.log, 'Summation SQL failed for check_id' || chk_id);
3854: END IF;
3855: END IF;
3856: IF v_check_level = 'PARTY' THEN
3857: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,

Line 4581: fnd_file.close;

4577: errbuf := '';
4578: retcode := 0;
4579: END IF;
4580: IF (debug) THEN
4581: fnd_file.close;
4582: END IF;
4583: EXCEPTION
4584: WHEN OTHERS THEN
4585: ROLLBACK;

Line 4601: fnd_file.close;

4597: CLOSE cpsite_csr;
4598: END IF;
4599: -- End fix by spamujul for ER#8473903
4600: IF (debug) THEN
4601: fnd_file.close;
4602: END IF;
4603:
4604: -- Retrieve error message into errbuf
4605: errbuf := Sqlerrm;

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

4607: -- Return 2 for error
4608: retcode := 2;
4609:
4610: g_error := sqlcode || ' ' || sqlerrm;
4611: fnd_file.put_line(fnd_file.log , g_error);
4612:
4613: END Evaluate_Checks4_No_Batch;
4614: --
4615: -- Evaluate_Checks4_Rule

Line 5090: fnd_file.close;

5086: retcode := 0;
5087: END IF;
5088:
5089: IF (debug) THEN
5090: fnd_file.close;
5091: END IF;
5092: EXCEPTION
5093: WHEN OTHERS THEN
5094: ROLLBACK;

Line 5110: fnd_file.close;

5106: CLOSE cpsite_csr;
5107: END IF;
5108: -- End fix by spamujul for ER#8473903
5109: IF (debug) THEN
5110: fnd_file.close;
5111: END IF;
5112:
5113: -- Retrieve error message into errbuf
5114: errbuf := Sqlerrm;

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

5116: -- Return 2 for error
5117: retcode := 2;
5118:
5119: g_error := sqlcode || ' ' || sqlerrm;
5120: fnd_file.put_line(fnd_file.log , g_error);
5121:
5122: END Evaluate_Checks4_Rule;
5123: --
5124: -- Evaluate_One_Check

Line 8116: fnd_file.close;

8112: retcode := 0;
8113: END IF;
8114:
8115: IF (debug) THEN
8116: fnd_file.close;
8117: END IF;
8118:
8119: EXCEPTION
8120: WHEN OTHERS THEN

Line 8130: fnd_file.close;

8126: CLOSE crelparty_csr;
8127: END IF;
8128:
8129: IF (debug) THEN
8130: fnd_file.close;
8131: END IF;
8132: errbuf := Sqlerrm;
8133: retcode := 2;
8134:

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

8132: errbuf := Sqlerrm;
8133: retcode := 2;
8134:
8135: g_error := sqlcode || ' ' || sqlerrm;
8136: fnd_file.put_line(fnd_file.log , g_error);
8137:
8138: END Evaluate_Checks_Rel;
8139:
8140: /* R12 Employee HelpDesk Modifications */

Line 8611: fnd_file.close;

8607: retcode := 0;
8608: END IF;
8609:
8610: IF (debug) THEN
8611: fnd_file.close;
8612: END IF;
8613:
8614: EXCEPTION
8615: WHEN OTHERS THEN

Line 8625: fnd_file.close;

8621: CLOSE employee_csr;
8622: END IF;
8623:
8624: IF (debug) THEN
8625: fnd_file.close;
8626: END IF;
8627: errbuf := Sqlerrm;
8628: retcode := 2;
8629:

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

8627: errbuf := Sqlerrm;
8628: retcode := 2;
8629:
8630: g_error := sqlcode || ' ' || sqlerrm;
8631: fnd_file.put_line(fnd_file.log , g_error);
8632:
8633: END Evaluate_Checks_Emp;
8634:
8635: /* End of R12 Employee HelpDesk Modifications */

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

9186:
9187: exception
9188: when Indexsegment_full then
9189: g_error := sqlcode || ' ' || sqlerrm;
9190: fnd_file.put_line(fnd_file.log , g_error);
9191: App_Exception.raise_exception;
9192:
9193: when Tablesegment_full then
9194: g_error := sqlcode || ' ' || sqlerrm;

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

9191: App_Exception.raise_exception;
9192:
9193: when Tablesegment_full then
9194: g_error := sqlcode || ' ' || sqlerrm;
9195: fnd_file.put_line(fnd_file.log , g_error);
9196: App_Exception.raise_exception;
9197:
9198: WHEN SNAPSHOT_TOO_OLD THEN
9199: g_error := sqlcode || ' ' || sqlerrm;

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

9196: App_Exception.raise_exception;
9197:
9198: WHEN SNAPSHOT_TOO_OLD THEN
9199: g_error := sqlcode || ' ' || sqlerrm;
9200: fnd_file.put_line(fnd_file.log,g_error);
9201: App_Exception.raise_exception;
9202:
9203: when Others then
9204: table_delete;

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

9202:
9203: when Others then
9204: table_delete;
9205: g_error := sqlcode || ' ' || sqlerrm;
9206: fnd_file.put_line(fnd_file.log , g_error);
9207:
9208: END Insert_Update_Block_Results;
9209:
9210: --

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

9489: WHEN Tablesegment_full THEN
9490: g_error := SQLCODE
9491: || ' '
9492: || sqlerrm;
9493: fnd_file.put_line(fnd_file.log , g_error);
9494: App_Exception.raise_exception;
9495: WHEN Indexsegment_full THEN
9496: g_error := SQLCODE
9497: || ' '

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

9495: WHEN Indexsegment_full THEN
9496: g_error := SQLCODE
9497: || ' '
9498: || sqlerrm;
9499: fnd_file.put_line(fnd_file.log , g_error);
9500: App_Exception.raise_exception;
9501: WHEN SNAPSHOT_TOO_OLD THEN
9502: g_error := SQLCODE
9503: || ' '

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

9501: WHEN SNAPSHOT_TOO_OLD THEN
9502: g_error := SQLCODE
9503: || ' '
9504: || sqlerrm;
9505: fnd_file.put_line(fnd_file.log,g_error);
9506: App_Exception.raise_exception;
9507: WHEN OTHERS THEN
9508: table_delete;
9509: g_error := SQLCODE

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

9508: table_delete;
9509: g_error := SQLCODE
9510: || ' '
9511: || sqlerrm;
9512: fnd_file.put_line(fnd_file.log , g_error);
9513: END Insert_Update_Check_Results;
9514:
9515:
9516: /*******************************************

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

10433: ) IS
10434: BEGIN
10435: -- Start with procedure name.
10436: IF (proc_name IS NOT NULL) THEN
10437: fnd_file.put(FND_FILE.LOG, proc_name||'(');
10438: END IF;
10439: -- Add all defined args.
10440: IF (arg1 <> '*none*') THEN
10441: fnd_file.put(FND_FILE.LOG, arg1);

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

10437: fnd_file.put(FND_FILE.LOG, proc_name||'(');
10438: END IF;
10439: -- Add all defined args.
10440: IF (arg1 <> '*none*') THEN
10441: fnd_file.put(FND_FILE.LOG, arg1);
10442: END IF;
10443: IF (arg2 <> '*none*') THEN
10444: fnd_file.put(FND_FILE.LOG, ', '||arg2);
10445: END IF;

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

10440: IF (arg1 <> '*none*') THEN
10441: fnd_file.put(FND_FILE.LOG, arg1);
10442: END IF;
10443: IF (arg2 <> '*none*') THEN
10444: fnd_file.put(FND_FILE.LOG, ', '||arg2);
10445: END IF;
10446: IF (arg3 <> '*none*') THEN
10447: fnd_file.put(FND_FILE.LOG, ', '||arg3);
10448: END IF;

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

10443: IF (arg2 <> '*none*') THEN
10444: fnd_file.put(FND_FILE.LOG, ', '||arg2);
10445: END IF;
10446: IF (arg3 <> '*none*') THEN
10447: fnd_file.put(FND_FILE.LOG, ', '||arg3);
10448: END IF;
10449: IF (arg4 <> '*none*') THEN
10450: fnd_file.put(FND_FILE.LOG, ', '||arg4);
10451: END IF;

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

10446: IF (arg3 <> '*none*') THEN
10447: fnd_file.put(FND_FILE.LOG, ', '||arg3);
10448: END IF;
10449: IF (arg4 <> '*none*') THEN
10450: fnd_file.put(FND_FILE.LOG, ', '||arg4);
10451: END IF;
10452: IF (arg5 <> '*none*') THEN
10453: fnd_file.put(FND_FILE.LOG, ', '||arg5);
10454: END IF;

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

10449: IF (arg4 <> '*none*') THEN
10450: fnd_file.put(FND_FILE.LOG, ', '||arg4);
10451: END IF;
10452: IF (arg5 <> '*none*') THEN
10453: fnd_file.put(FND_FILE.LOG, ', '||arg5);
10454: END IF;
10455:
10456: IF (proc_name IS NOT NULL) THEN
10457: fnd_file.put_line(FND_FILE.LOG, ')');

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

10453: fnd_file.put(FND_FILE.LOG, ', '||arg5);
10454: END IF;
10455:
10456: IF (proc_name IS NOT NULL) THEN
10457: fnd_file.put_line(FND_FILE.LOG, ')');
10458: ELSE
10459: fnd_file.new_line(FND_FILE.LOG);
10460: END IF;
10461: EXCEPTION

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

10455:
10456: IF (proc_name IS NOT NULL) THEN
10457: fnd_file.put_line(FND_FILE.LOG, ')');
10458: ELSE
10459: fnd_file.new_line(FND_FILE.LOG);
10460: END IF;
10461: EXCEPTION
10462: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
10463: fnd_message.set_name('CSC', 'CSC_PROFILE_INVALID_FILEHANDLE');