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

Line 110: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'

106:
107: EXCEPTION
108: WHEN NO_DATA_FOUND
109: THEN
110: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Next_Level_Proc_Info'
111: || SUBSTR (SQLERRM, 1, 100), 1, 200));
112:
113: WHEN OTHERS
114: THEN

Line 115: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'

111: || SUBSTR (SQLERRM, 1, 100), 1, 200));
112:
113: WHEN OTHERS
114: THEN
115: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Next_Level_Proc_Info'
116: || SUBSTR (SQLERRM, 1, 100), 1, 200));
117:
118: ---COMMIT;
119: end Update_Next_Level_Proc_Info;

Line 159: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Certification_Detail'

155:
156: EXCEPTION
157: WHEN NO_DATA_FOUND
158: THEN
159: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Certification_Detail'
160: || SUBSTR (SQLERRM, 1, 100), 1, 200));
161:
162: WHEN OTHERS
163: THEN

Line 164: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Certification_Detail'

160: || SUBSTR (SQLERRM, 1, 100), 1, 200));
161:
162: WHEN OTHERS
163: THEN
164: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Certification_Detail'
165: || SUBSTR (SQLERRM, 1, 100), 1, 200));
166:
167:
168:

Line 226: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Global_Proc_Info'

222:
223: EXCEPTION
224: WHEN NO_DATA_FOUND
225: THEN
226: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Global_Proc_Info'
227: || SUBSTR (SQLERRM, 1, 100), 1, 200));
228:
229:
230: WHEN OTHERS

Line 232: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Global_Proc_Info'

228:
229:
230: WHEN OTHERS
231: THEN
232: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Global_Proc_Info'
233: || SUBSTR (SQLERRM, 1, 100), 1, 200));
234:
235:
236:

Line 276: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Last_Evaluation_Info'

272:
273: EXCEPTION
274: WHEN NO_DATA_FOUND
275: THEN
276: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Last_Evaluation_Info'
277: || SUBSTR (SQLERRM, 1, 100), 1, 200));
278:
279: WHEN OTHERS
280: THEN

Line 281: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Last_Evaluation_Info'

277: || SUBSTR (SQLERRM, 1, 100), 1, 200));
278:
279: WHEN OTHERS
280: THEN
281: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Last_Evaluation_Info'
282: || SUBSTR (SQLERRM, 1, 100), 1, 200));
283:
284:
285: END UPDATE_LAST_EVALUATION_INFO;

Line 353: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Unmitigated_Risks'

349:
350: EXCEPTION
351: WHEN NO_DATA_FOUND
352: THEN
353: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Unmitigated_Risks'
354: || SUBSTR (SQLERRM, 1, 100), 1, 200));
355:
356: WHEN OTHERS
357: THEN

Line 358: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Unmitigated_Risks'

354: || SUBSTR (SQLERRM, 1, 100), 1, 200));
355:
356: WHEN OTHERS
357: THEN
358: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Unmitigated_Risks'
359: || SUBSTR (SQLERRM, 1, 100), 1, 200));
360:
361:
362:

Line 432: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Ineffective_Controls'

428:
429: EXCEPTION
430: WHEN NO_DATA_FOUND
431: THEN
432: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Update_Ineffective_Controls'
433: || SUBSTR (SQLERRM, 1, 100), 1, 200));
434:
435: WHEN OTHERS
436: THEN

Line 437: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Ineffective_Controls'

433: || SUBSTR (SQLERRM, 1, 100), 1, 200));
434:
435: WHEN OTHERS
436: THEN
437: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Update_Ineffective_Controls'
438: || SUBSTR (SQLERRM, 1, 100), 1, 200));
439:
440:
441:

Line 510: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Summary'

506:
507: EXCEPTION
508: WHEN NO_DATA_FOUND
509: THEN
510: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Summary'
511: || SUBSTR (SQLERRM, 1, 100), 1, 200));
512:
513: WHEN OTHERS
514: THEN

Line 515: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Summary'

511: || SUBSTR (SQLERRM, 1, 100), 1, 200));
512:
513: WHEN OTHERS
514: THEN
515: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Summary'
516: || SUBSTR (SQLERRM, 1, 100), 1, 200));
517:
518: END Populate_Summary;
519:

Line 550: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_Summary'

546:
547: EXCEPTION
548: WHEN NO_DATA_FOUND
549: THEN
550: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_Summary'
551: || SUBSTR (SQLERRM, 1, 100), 1, 200));
552:
553: WHEN OTHERS
554: THEN

Line 555: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_Summary'

551: || SUBSTR (SQLERRM, 1, 100), 1, 200));
552:
553: WHEN OTHERS
554: THEN
555: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_Summary'
556: || SUBSTR (SQLERRM, 1, 100), 1, 200));
557:
558: END Populate_All_Cert_Summary;
559:

Line 1351: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));

1347: l_orgs_pending_in_scope NUMBER;
1348:
1349: BEGIN
1350:
1351: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
1352: fnd_file.put_line(fnd_file.LOG, 'before new_risks_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1353:
1354: OPEN new_risks_added;
1355: FETCH new_risks_added INTO l_new_risks_added;

Line 1352: fnd_file.put_line(fnd_file.LOG, 'before new_risks_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1348:
1349: BEGIN
1350:
1351: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
1352: fnd_file.put_line(fnd_file.LOG, 'before new_risks_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1353:
1354: OPEN new_risks_added;
1355: FETCH new_risks_added INTO l_new_risks_added;
1356: CLOSE new_risks_added;

Line 1358: fnd_file.put_line(fnd_file.LOG, 'before new_controls_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1354: OPEN new_risks_added;
1355: FETCH new_risks_added INTO l_new_risks_added;
1356: CLOSE new_risks_added;
1357:
1358: fnd_file.put_line(fnd_file.LOG, 'before new_controls_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1359: OPEN new_controls_added;
1360: FETCH new_controls_added INTO l_new_controls_added;
1361: CLOSE new_controls_added;
1362:

Line 1363: fnd_file.put_line(fnd_file.LOG, 'before global_proc_not_certified :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1359: OPEN new_controls_added;
1360: FETCH new_controls_added INTO l_new_controls_added;
1361: CLOSE new_controls_added;
1362:
1363: fnd_file.put_line(fnd_file.LOG, 'before global_proc_not_certified :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1364: OPEN global_proc_not_certified;
1365: FETCH global_proc_not_certified INTO l_global_proc_not_certified;
1366: CLOSE global_proc_not_certified;
1367:

Line 1368: fnd_file.put_line(fnd_file.LOG, 'before global_proc_with_issue :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1364: OPEN global_proc_not_certified;
1365: FETCH global_proc_not_certified INTO l_global_proc_not_certified;
1366: CLOSE global_proc_not_certified;
1367:
1368: fnd_file.put_line(fnd_file.LOG, 'before global_proc_with_issue :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1369: OPEN global_proc_with_issue;
1370: FETCH global_proc_with_issue INTO l_global_proc_with_issue;
1371: CLOSE global_proc_with_issue;
1372:

Line 1373: fnd_file.put_line(fnd_file.LOG, 'before local_proc_not_certified :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1369: OPEN global_proc_with_issue;
1370: FETCH global_proc_with_issue INTO l_global_proc_with_issue;
1371: CLOSE global_proc_with_issue;
1372:
1373: fnd_file.put_line(fnd_file.LOG, 'before local_proc_not_certified :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1374: OPEN local_proc_not_certified;
1375: FETCH local_proc_not_certified INTO l_local_proc_not_certified;
1376: CLOSE local_proc_not_certified;
1377:

Line 1378: fnd_file.put_line(fnd_file.LOG, 'before local_proc_with_issue :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1374: OPEN local_proc_not_certified;
1375: FETCH local_proc_not_certified INTO l_local_proc_not_certified;
1376: CLOSE local_proc_not_certified;
1377:
1378: fnd_file.put_line(fnd_file.LOG, 'before local_proc_with_issue :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1379: OPEN local_proc_with_issue;
1380: FETCH local_proc_with_issue INTO l_local_proc_with_issue;
1381: CLOSE local_proc_with_issue;
1382:

Line 1383: fnd_file.put_line(fnd_file.LOG, 'before global_proc_with_ineff_ctrl :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1379: OPEN local_proc_with_issue;
1380: FETCH local_proc_with_issue INTO l_local_proc_with_issue;
1381: CLOSE local_proc_with_issue;
1382:
1383: fnd_file.put_line(fnd_file.LOG, 'before global_proc_with_ineff_ctrl :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1384: OPEN global_proc_with_ineff_ctrl;
1385: FETCH global_proc_with_ineff_ctrl INTO l_global_proc_with_ineff_ctrl;
1386: CLOSE global_proc_with_ineff_ctrl;
1387:

Line 1388: fnd_file.put_line(fnd_file.LOG, 'before local_proc_with_ineff_ctrl :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1384: OPEN global_proc_with_ineff_ctrl;
1385: FETCH global_proc_with_ineff_ctrl INTO l_global_proc_with_ineff_ctrl;
1386: CLOSE global_proc_with_ineff_ctrl;
1387:
1388: fnd_file.put_line(fnd_file.LOG, 'before local_proc_with_ineff_ctrl :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1389: OPEN local_proc_with_ineff_ctrl;
1390: FETCH local_proc_with_ineff_ctrl INTO l_local_proc_with_ineff_ctrl;
1391: CLOSE local_proc_with_ineff_ctrl;
1392:

Line 1393: fnd_file.put_line(fnd_file.LOG, 'before unmitigated_risks :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1389: OPEN local_proc_with_ineff_ctrl;
1390: FETCH local_proc_with_ineff_ctrl INTO l_local_proc_with_ineff_ctrl;
1391: CLOSE local_proc_with_ineff_ctrl;
1392:
1393: fnd_file.put_line(fnd_file.LOG, 'before unmitigated_risks :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1394: OPEN unmitigated_risks;
1395: FETCH unmitigated_risks INTO l_unmitigated_risks;
1396: CLOSE unmitigated_risks;
1397:

Line 1398: fnd_file.put_line(fnd_file.LOG, 'before ineffective_controls :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1394: OPEN unmitigated_risks;
1395: FETCH unmitigated_risks INTO l_unmitigated_risks;
1396: CLOSE unmitigated_risks;
1397:
1398: fnd_file.put_line(fnd_file.LOG, 'before ineffective_controls :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1399: OPEN ineffective_controls;
1400: FETCH ineffective_controls INTO l_ineffective_controls;
1401: CLOSE ineffective_controls;
1402:

Line 1403: fnd_file.put_line(fnd_file.LOG, 'before orgs_pending_in_scope :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1399: OPEN ineffective_controls;
1400: FETCH ineffective_controls INTO l_ineffective_controls;
1401: CLOSE ineffective_controls;
1402:
1403: fnd_file.put_line(fnd_file.LOG, 'before orgs_pending_in_scope :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1404: OPEN orgs_pending_in_scope;
1405: FETCH orgs_pending_in_scope INTO l_orgs_pending_in_scope;
1406: CLOSE orgs_pending_in_scope;
1407:

Line 1408: fnd_file.put_line(fnd_file.LOG, 'before orgs_in_scope :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1404: OPEN orgs_pending_in_scope;
1405: FETCH orgs_pending_in_scope INTO l_orgs_pending_in_scope;
1406: CLOSE orgs_pending_in_scope;
1407:
1408: fnd_file.put_line(fnd_file.LOG, 'before orgs_in_scope :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1409: OPEN orgs_in_scope;
1410: FETCH orgs_in_scope INTO l_orgs_in_scope;
1411: CLOSE orgs_in_scope;
1412:

Line 1477: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_DetSummary'

1473: END IF;
1474:
1475: commit;
1476: EXCEPTION WHEN OTHERS THEN
1477: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_DetSummary'
1478: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1479: END Populate_Cert_General_Sum;
1480:
1481:

Line 1507: fnd_file.put_line (fnd_file.LOG,

1503: AND cert.certification_id = p_certification_id;
1504:
1505: l_start_date DATE;
1506: BEGIN
1507: fnd_file.put_line (fnd_file.LOG,
1508: 'Certification_Id:'||p_certification_id);
1509: IF p_certification_id IS NOT NULL THEN
1510: OPEN c_start_date;
1511: FETCH c_start_date INTO l_start_date;

Line 1524: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_General_Sum'

1520: END IF;
1521:
1522: EXCEPTION
1523: WHEN NO_DATA_FOUND THEN
1524: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_General_Sum'
1525: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1526: WHEN OTHERS THEN
1527: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_General_Sum'
1528: || SUBSTR (SQLERRM, 1, 100), 1, 200));

Line 1527: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_General_Sum'

1523: WHEN NO_DATA_FOUND THEN
1524: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_General_Sum'
1525: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1526: WHEN OTHERS THEN
1527: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_General_Sum'
1528: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1529: errbuf := SQLERRM;
1530: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1531: END Populate_All_Cert_General_Sum;

Line 1858: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Fin_Process_Eval_Sum'

1854: END IF;
1855:
1856:
1857: EXCEPTION WHEN OTHERS THEN
1858: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Fin_Process_Eval_Sum'
1859: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1860: END Populate_Fin_Process_Eval_Sum;
1861:
1862: PROCEDURE Populate_All_Fin_Proc_Eval_Sum(

Line 1888: fnd_file.put_line(fnd_file.LOG, 'start populate_all_fin_proc_eval_sum:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1884:
1885: BEGIN
1886:
1887: SAVEPOINT Populate_All_Fin_Proc_Eval_Sum;
1888: fnd_file.put_line(fnd_file.LOG, 'start populate_all_fin_proc_eval_sum:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1889: fnd_file.put_line(fnd_file.LOG, 'p_certification_id = :' || p_certification_id);
1890:
1891: -- Initialize API return status to SUCCESS
1892: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1889: fnd_file.put_line(fnd_file.LOG, 'p_certification_id = :' || p_certification_id);

1885: BEGIN
1886:
1887: SAVEPOINT Populate_All_Fin_Proc_Eval_Sum;
1888: fnd_file.put_line(fnd_file.LOG, 'start populate_all_fin_proc_eval_sum:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1889: fnd_file.put_line(fnd_file.LOG, 'p_certification_id = :' || p_certification_id);
1890:
1891: -- Initialize API return status to SUCCESS
1892: l_return_status := FND_API.G_RET_STS_SUCCESS;
1893:

Line 1943: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Process_Eval_Sum'

1939:
1940:
1941: EXCEPTION
1942: WHEN NO_DATA_FOUND THEN
1943: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Process_Eval_Sum'
1944: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1945: WHEN OTHERS THEN
1946: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum'
1947: || SUBSTR (SQLERRM, 1, 100), 1, 200));

Line 1946: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum'

1942: WHEN NO_DATA_FOUND THEN
1943: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Process_Eval_Sum'
1944: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1945: WHEN OTHERS THEN
1946: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum'
1947: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1948: ROLLBACK TO Populate_All_Fin_Proc_Eval_Sum;
1949: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1950: FND_MSG_PUB.Count_And_Get(

Line 2099: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);

2095: l_total_org_var_processes NUMBER;
2096: l_total_org_processes NUMBER;
2097:
2098: BEGIN
2099: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
2100:
2101: IF p_certification_id IS NOT NULL THEN
2102:
2103: DELETE from AMW_FIN_PROCESS_EVAL_SUM

Line 2214: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Fin_Process_Eval_Sum'

2210: END IF;
2211:
2212: EXCEPTION
2213: WHEN NO_DATA_FOUND THEN
2214: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Fin_Process_Eval_Sum'
2215: || SUBSTR (SQLERRM, 1, 100), 1, 200));
2216: WHEN OTHERS THEN
2217: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Fin_Process_Eval_Sum'
2218: || SUBSTR (SQLERRM, 1, 100), 1, 200));

Line 2217: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Fin_Process_Eval_Sum'

2213: WHEN NO_DATA_FOUND THEN
2214: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Fin_Process_Eval_Sum'
2215: || SUBSTR (SQLERRM, 1, 100), 1, 200));
2216: WHEN OTHERS THEN
2217: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Fin_Process_Eval_Sum'
2218: || SUBSTR (SQLERRM, 1, 100), 1, 200));
2219: errbuf := SQLERRM;
2220: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
2221: END Populate_All_Fin_Proc_Eval_Sum;

Line 2819: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));

2815: l_sub_code VARCHAR2(150);
2816: l_lob_code VARCHAR2(150);
2817: BEGIN
2818:
2819: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
2820: fnd_file.put_line(fnd_file.LOG, 'p_organization_id='||to_char(p_organization_id));
2821: fnd_file.put_line(fnd_file.LOG, 'before last_evaludation:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2822:
2823: OPEN last_evaluation;

Line 2820: fnd_file.put_line(fnd_file.LOG, 'p_organization_id='||to_char(p_organization_id));

2816: l_lob_code VARCHAR2(150);
2817: BEGIN
2818:
2819: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
2820: fnd_file.put_line(fnd_file.LOG, 'p_organization_id='||to_char(p_organization_id));
2821: fnd_file.put_line(fnd_file.LOG, 'before last_evaludation:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2822:
2823: OPEN last_evaluation;
2824: FETCH last_evaluation INTO l_eval_opinion_id;

Line 2821: fnd_file.put_line(fnd_file.LOG, 'before last_evaludation:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2817: BEGIN
2818:
2819: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
2820: fnd_file.put_line(fnd_file.LOG, 'p_organization_id='||to_char(p_organization_id));
2821: fnd_file.put_line(fnd_file.LOG, 'before last_evaludation:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2822:
2823: OPEN last_evaluation;
2824: FETCH last_evaluation INTO l_eval_opinion_id;
2825: CLOSE last_evaluation;

Line 2826: fnd_file.put_line(fnd_file.LOG, 'after last_evaludation:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2822:
2823: OPEN last_evaluation;
2824: FETCH last_evaluation INTO l_eval_opinion_id;
2825: CLOSE last_evaluation;
2826: fnd_file.put_line(fnd_file.LOG, 'after last_evaludation:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2827:
2828: /*
2829: OPEN proc_pending_cert;
2830: FETCH proc_pending_cert INTO l_proc_pending_cert;

Line 2832: fnd_file.put_line(fnd_file.LOG, 'after proc_pending_cert:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2828: /*
2829: OPEN proc_pending_cert;
2830: FETCH proc_pending_cert INTO l_proc_pending_cert;
2831: CLOSE proc_pending_cert;
2832: fnd_file.put_line(fnd_file.LOG, 'after proc_pending_cert:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2833: */
2834:
2835: OPEN total_num_of_proc;
2836: FETCH total_num_of_proc INTO l_total_num_of_procs;

Line 2838: fnd_file.put_line(fnd_file.LOG, 'after total_num_of_proc:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2834:
2835: OPEN total_num_of_proc;
2836: FETCH total_num_of_proc INTO l_total_num_of_procs;
2837: CLOSE total_num_of_proc;
2838: fnd_file.put_line(fnd_file.LOG, 'after total_num_of_proc:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2839:
2840: OPEN proc_with_issue;
2841: FETCH proc_with_issue INTO l_proc_with_issue;
2842: CLOSE proc_with_issue;

Line 2843: fnd_file.put_line(fnd_file.LOG, 'after proc_with_issue:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2839:
2840: OPEN proc_with_issue;
2841: FETCH proc_with_issue INTO l_proc_with_issue;
2842: CLOSE proc_with_issue;
2843: fnd_file.put_line(fnd_file.LOG, 'after proc_with_issue:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2844:
2845: OPEN proc_without_issue;
2846: FETCH proc_without_issue INTO l_proc_without_issue;
2847: CLOSE proc_without_issue;

Line 2848: fnd_file.put_line(fnd_file.LOG, 'after proc_without_issue:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2844:
2845: OPEN proc_without_issue;
2846: FETCH proc_without_issue INTO l_proc_without_issue;
2847: CLOSE proc_without_issue;
2848: fnd_file.put_line(fnd_file.LOG, 'after proc_without_issue:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2849:
2850: l_proc_certified := l_proc_with_issue+l_proc_without_issue;
2851: l_proc_pending_cert := l_total_num_of_procs-l_proc_certified;
2852:

Line 2856: fnd_file.put_line(fnd_file.LOG, 'after proc_with_ineff_ctrl:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2852:
2853: OPEN proc_with_ineff_ctrl;
2854: FETCH proc_with_ineff_ctrl INTO l_proc_with_ineff_ctrl;
2855: CLOSE proc_with_ineff_ctrl;
2856: fnd_file.put_line(fnd_file.LOG, 'after proc_with_ineff_ctrl:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2857:
2858: OPEN unmitigated_risks;
2859: FETCH unmitigated_risks INTO l_unmitigated_risks;
2860: CLOSE unmitigated_risks;

Line 2861: fnd_file.put_line(fnd_file.LOG, 'after unmitigated:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2857:
2858: OPEN unmitigated_risks;
2859: FETCH unmitigated_risks INTO l_unmitigated_risks;
2860: CLOSE unmitigated_risks;
2861: fnd_file.put_line(fnd_file.LOG, 'after unmitigated:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2862:
2863: OPEN total_risks;
2864: FETCH total_risks INTO l_risks;
2865: CLOSE total_risks;

Line 2866: fnd_file.put_line(fnd_file.LOG, 'after total_risks:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2862:
2863: OPEN total_risks;
2864: FETCH total_risks INTO l_risks;
2865: CLOSE total_risks;
2866: fnd_file.put_line(fnd_file.LOG, 'after total_risks:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2867:
2868: OPEN ineffective_controls;
2869: FETCH ineffective_controls INTO l_ineff_controls;
2870: CLOSE ineffective_controls;

Line 2871: fnd_file.put_line(fnd_file.LOG, 'after ineffective_controls:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2867:
2868: OPEN ineffective_controls;
2869: FETCH ineffective_controls INTO l_ineff_controls;
2870: CLOSE ineffective_controls;
2871: fnd_file.put_line(fnd_file.LOG, 'after ineffective_controls:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2872:
2873: OPEN total_controls;
2874: FETCH total_controls INTO l_controls;
2875: CLOSE total_controls;

Line 2876: fnd_file.put_line(fnd_file.LOG, 'after total_controls:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2872:
2873: OPEN total_controls;
2874: FETCH total_controls INTO l_controls;
2875: CLOSE total_controls;
2876: fnd_file.put_line(fnd_file.LOG, 'after total_controls:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2877:
2878: OPEN c_org;
2879: FETCH c_org INTO l_sub_vs, l_sub_code, l_lob_vs, l_lob_code;
2880: CLOSE c_org;

Line 2881: fnd_file.put_line(fnd_file.LOG, 'after c_org:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2877:
2878: OPEN c_org;
2879: FETCH c_org INTO l_sub_vs, l_sub_code, l_lob_vs, l_lob_code;
2880: CLOSE c_org;
2881: fnd_file.put_line(fnd_file.LOG, 'after c_org:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2882:
2883: BEGIN
2884: l_open_findings := amw_findings_pkg.calculate_open_findings (
2885: 'AMW_PROJ_FINDING',

Line 2895: fnd_file.put_line(fnd_file.LOG, 'after open_findings:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

2891: EXCEPTION
2892: WHEN OTHERS THEN
2893: null;
2894: END;
2895: fnd_file.put_line(fnd_file.LOG, 'after open_findings:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
2896:
2897: UPDATE AMW_FIN_ORG_EVAL_SUM
2898: SET EVAL_OPINION_ID = l_eval_opinion_id,
2899: PROC_PENDING_CERTIFICATION = l_proc_pending_cert,

Line 2993: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Fin_Org_Eval_Sum'

2989: END IF;
2990:
2991: commit;
2992: EXCEPTION WHEN OTHERS THEN
2993: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Fin_Org_Eval_Sum'
2994: || SUBSTR (SQLERRM, 1, 100), 1, 200));
2995: END Populate_Fin_Org_Eval_Sum;
2996:
2997:

Line 3062: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);

3058: l_start_date DATE;
3059: l_end_date DATE;
3060:
3061: BEGIN
3062: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
3063:
3064: IF p_certification_id IS NOT NULL THEN
3065: OPEN c_period_date;
3066: FETCH c_period_date INTO l_start_date, l_end_date;

Line 3134: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Fin_Org_Eval_Sum'

3130: END IF;
3131:
3132: EXCEPTION
3133: WHEN OTHERS THEN
3134: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Fin_Org_Eval_Sum'
3135: || SUBSTR (SQLERRM, 1, 100), 1, 200));
3136: errbuf := SQLERRM;
3137: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
3138: END Populate_All_Fin_Org_Eval_Sum;

Line 4469: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

4465: end if;
4466:
4467: end;
4468: EXCEPTION WHEN OTHERS THEN
4469: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4470: --dbms_output.put_line(SQLERRM);
4471: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
4472: g_retcode := '2';
4473:

Line 4695: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

4691: AND OBJECT_TYPE = X_OBJECT_TYPE;
4692: end if;
4693: end;
4694: EXCEPTION WHEN OTHERS THEN
4695: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4696: -- dbms_output.put_line(SQLERRM);
4697: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
4698: g_retcode := '2';
4699:

Line 4726: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

4722:
4723: EXCEPTION
4724: WHEN NO_DATA_FOUND
4725: THEN
4726: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4727:
4728: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
4729: g_retcode := '2';
4730:

Line 4736: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));

4732: RETURN;
4733:
4734: WHEN OTHERS then
4735:
4736: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
4737: -- dbms_output.put_line(SQLERRM);
4738: g_errbuf := SUBSTR (SQLERRM, 1, 2000) ;
4739: g_retcode := '2';
4740:

Line 7976: fnd_file.put_line (fnd_file.LOG,'Certification Id :' || p_certification_id);

7972: l_msg VARCHAR2(2000);
7973: l_reqdata VARCHAR2(240);
7974:
7975: BEGIN
7976: fnd_file.put_line (fnd_file.LOG,'Certification Id :' || p_certification_id);
7977:
7978:
7979:
7980: l_reqdata := FND_CONC_GLOBAL.request_data;

Line 7998: fnd_file.put_line (fnd_file.LOG,l_msg);

7994: TRUE,
7995: to_char(p_certification_id));
7996: IF l_request_id = 0 THEN
7997: l_msg:=FND_MESSAGE.GET;
7998: fnd_file.put_line (fnd_file.LOG,l_msg);
7999: ELSE
8000: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Process Summary :' || l_request_id );
8001: END IF;
8002:

Line 8000: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Process Summary :' || l_request_id );

7996: IF l_request_id = 0 THEN
7997: l_msg:=FND_MESSAGE.GET;
7998: fnd_file.put_line (fnd_file.LOG,l_msg);
7999: ELSE
8000: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Process Summary :' || l_request_id );
8001: END IF;
8002:
8003: /*********************
8004: ----Sub Request for Financial Item Summary --

Line 8013: fnd_file.put_line (fnd_file.LOG,l_msg);

8009: TRUE,
8010: to_char(p_certification_id));
8011: IF l_request_id = 0 THEN
8012: l_msg:=FND_MESSAGE.GET;
8013: fnd_file.put_line (fnd_file.LOG,l_msg);
8014: ELSE
8015: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Financial Item Summary :' || l_request_id );
8016: END IF;
8017:

Line 8015: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Financial Item Summary :' || l_request_id );

8011: IF l_request_id = 0 THEN
8012: l_msg:=FND_MESSAGE.GET;
8013: fnd_file.put_line (fnd_file.LOG,l_msg);
8014: ELSE
8015: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Financial Item Summary :' || l_request_id );
8016: END IF;
8017:
8018:
8019: ---Sub Request for Dashboard Summary --

Line 8028: fnd_file.put_line (fnd_file.LOG,l_msg);

8024: TRUE,
8025: to_char(p_certification_id));
8026: IF l_request_id = 0 THEN
8027: l_msg:=FND_MESSAGE.GET;
8028: fnd_file.put_line (fnd_file.LOG,l_msg);
8029: ELSE
8030: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Dashboard Summary :' || l_request_id );
8031: END IF;
8032:

Line 8030: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Dashboard Summary :' || l_request_id );

8026: IF l_request_id = 0 THEN
8027: l_msg:=FND_MESSAGE.GET;
8028: fnd_file.put_line (fnd_file.LOG,l_msg);
8029: ELSE
8030: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Dashboard Summary :' || l_request_id );
8031: END IF;
8032:
8033:
8034: ---Sub Request for Organization Summary ---

Line 8043: fnd_file.put_line (fnd_file.LOG,l_msg);

8039: TRUE,
8040: to_char(p_certification_id));
8041: IF l_request_id = 0 THEN
8042: l_msg:=FND_MESSAGE.GET;
8043: fnd_file.put_line (fnd_file.LOG,l_msg);
8044: ELSE
8045: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Organization Summary :' || l_request_id );
8046: END IF;
8047:

Line 8045: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Organization Summary :' || l_request_id );

8041: IF l_request_id = 0 THEN
8042: l_msg:=FND_MESSAGE.GET;
8043: fnd_file.put_line (fnd_file.LOG,l_msg);
8044: ELSE
8045: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Organization Summary :' || l_request_id );
8046: END IF;
8047:
8048: **********************/
8049:

Line 8059: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Fin_Stmt_Cert_Sum'

8055:
8056:
8057: EXCEPTION
8058: WHEN OTHERS THEN
8059: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Fin_Stmt_Cert_Sum'
8060: || SUBSTR (SQLERRM, 1, 100), 1, 200));
8061: errbuf := SQLERRM;
8062: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
8063: