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_PROCESS_CERT_SUMMARY dependencies on FND_FILE

Line 785: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in update_summary_table'

781:
782: EXCEPTION
783: WHEN NO_DATA_FOUND
784: THEN
785: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in update_summary_table'
786: || SUBSTR (SQLERRM, 1, 100), 1, 200));
787:
788: WHEN OTHERS
789: THEN

Line 790: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in update_summary_table'

786: || SUBSTR (SQLERRM, 1, 100), 1, 200));
787:
788: WHEN OTHERS
789: THEN
790: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in update_summary_table'
791: || SUBSTR (SQLERRM, 1, 100), 1, 200));
792:
793:
794: END update_summary_table;

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

821:
822: proc_rec get_all_processes%rowtype;
823:
824: BEGIN
825: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
826: fnd_file.put_line(fnd_file.LOG, 'start timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
827: OPEN get_specific_records;
828: CLOSE get_specific_records;
829:

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

822: proc_rec get_all_processes%rowtype;
823:
824: BEGIN
825: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
826: fnd_file.put_line(fnd_file.LOG, 'start timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
827: OPEN get_specific_records;
828: CLOSE get_specific_records;
829:
830: FOR proc_rec IN get_all_processes LOOP

Line 837: fnd_file.put_line(fnd_file.LOG, 'end timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

833:
834: END LOOP;
835:
836: populate_assoc_opinion(p_certification_id);
837: fnd_file.put_line(fnd_file.LOG, 'end timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
838: COMMIT;
839: EXCEPTION
840: WHEN NO_DATA_FOUND
841: THEN

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

838: COMMIT;
839: EXCEPTION
840: WHEN NO_DATA_FOUND
841: THEN
842: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Summary'
843: || SUBSTR (SQLERRM, 1, 100), 1, 200));
844:
845: WHEN OTHERS
846: THEN

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

843: || SUBSTR (SQLERRM, 1, 100), 1, 200));
844:
845: WHEN OTHERS
846: THEN
847: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Summary'
848: || SUBSTR (SQLERRM, 1, 100), 1, 200));
849:
850: END populate_summary;
851:

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

869:
870: proc_rec get_all_processes%rowtype;
871:
872: BEGIN
873: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
874:
875: IF p_certification_id IS NOT NULL
876: THEN
877: Populate_Summary(p_certification_id);

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

883:
884: EXCEPTION
885: WHEN NO_DATA_FOUND
886: THEN
887: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_Summary'
888: || SUBSTR (SQLERRM, 1, 100), 1, 200));
889:
890: WHEN OTHERS
891: THEN

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

888: || SUBSTR (SQLERRM, 1, 100), 1, 200));
889:
890: WHEN OTHERS
891: THEN
892: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_Summary'
893: || SUBSTR (SQLERRM, 1, 100), 1, 200));
894:
895: END POPULATE_ALL_CERT_SUMMARY;
896:

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

1251: l_orgs_pending_cert NUMBER;
1252:
1253: BEGIN
1254:
1255: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
1256:
1257: fnd_file.put_line(fnd_file.LOG, 'before new_risks_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1258: OPEN new_risks_added;
1259: FETCH new_risks_added INTO l_new_risks_added;

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

1253: BEGIN
1254:
1255: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
1256:
1257: fnd_file.put_line(fnd_file.LOG, 'before new_risks_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1258: OPEN new_risks_added;
1259: FETCH new_risks_added INTO l_new_risks_added;
1260: CLOSE new_risks_added;
1261:

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

1258: OPEN new_risks_added;
1259: FETCH new_risks_added INTO l_new_risks_added;
1260: CLOSE new_risks_added;
1261:
1262: fnd_file.put_line(fnd_file.LOG, 'before new_controls_added :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1263: OPEN new_controls_added;
1264: FETCH new_controls_added INTO l_new_controls_added;
1265: CLOSE new_controls_added;
1266:

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

1263: OPEN new_controls_added;
1264: FETCH new_controls_added INTO l_new_controls_added;
1265: CLOSE new_controls_added;
1266:
1267: fnd_file.put_line(fnd_file.LOG, 'before global_proc_not_certified:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1268: OPEN global_proc_not_certified;
1269: FETCH global_proc_not_certified INTO l_global_proc_not_certified;
1270: CLOSE global_proc_not_certified;
1271:

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

1268: OPEN global_proc_not_certified;
1269: FETCH global_proc_not_certified INTO l_global_proc_not_certified;
1270: CLOSE global_proc_not_certified;
1271:
1272: fnd_file.put_line(fnd_file.LOG, 'before global_proc_with_issue:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1273: OPEN global_proc_with_issue;
1274: FETCH global_proc_with_issue INTO l_global_proc_with_issue;
1275: CLOSE global_proc_with_issue;
1276:

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

1273: OPEN global_proc_with_issue;
1274: FETCH global_proc_with_issue INTO l_global_proc_with_issue;
1275: CLOSE global_proc_with_issue;
1276:
1277: fnd_file.put_line(fnd_file.LOG, 'before local_proc_not_certified:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1278: OPEN local_proc_not_certified;
1279: FETCH local_proc_not_certified INTO l_local_proc_not_certified;
1280: CLOSE local_proc_not_certified;
1281:

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

1278: OPEN local_proc_not_certified;
1279: FETCH local_proc_not_certified INTO l_local_proc_not_certified;
1280: CLOSE local_proc_not_certified;
1281:
1282: fnd_file.put_line(fnd_file.LOG, 'before local_proc_with_issue:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1283: OPEN local_proc_with_issue;
1284: FETCH local_proc_with_issue INTO l_local_proc_with_issue;
1285: CLOSE local_proc_with_issue;
1286:

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

1283: OPEN local_proc_with_issue;
1284: FETCH local_proc_with_issue INTO l_local_proc_with_issue;
1285: CLOSE local_proc_with_issue;
1286:
1287: fnd_file.put_line(fnd_file.LOG, 'before global_proc_with_ineff_ctrl:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1288: OPEN global_proc_with_ineff_ctrl;
1289: FETCH global_proc_with_ineff_ctrl INTO l_global_proc_with_ineff_ctrl;
1290: CLOSE global_proc_with_ineff_ctrl;
1291:

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

1288: OPEN global_proc_with_ineff_ctrl;
1289: FETCH global_proc_with_ineff_ctrl INTO l_global_proc_with_ineff_ctrl;
1290: CLOSE global_proc_with_ineff_ctrl;
1291:
1292: fnd_file.put_line(fnd_file.LOG, 'before local_proc_with_ineff_ctrl:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1293: OPEN local_proc_with_ineff_ctrl;
1294: FETCH local_proc_with_ineff_ctrl INTO l_local_proc_with_ineff_ctrl;
1295: CLOSE local_proc_with_ineff_ctrl;
1296:

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

1293: OPEN local_proc_with_ineff_ctrl;
1294: FETCH local_proc_with_ineff_ctrl INTO l_local_proc_with_ineff_ctrl;
1295: CLOSE local_proc_with_ineff_ctrl;
1296:
1297: fnd_file.put_line(fnd_file.LOG, 'before unmitigated_risks:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1298: OPEN unmitigated_risks;
1299: FETCH unmitigated_risks INTO l_unmitigated_risks;
1300: CLOSE unmitigated_risks;
1301:

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

1298: OPEN unmitigated_risks;
1299: FETCH unmitigated_risks INTO l_unmitigated_risks;
1300: CLOSE unmitigated_risks;
1301:
1302: fnd_file.put_line(fnd_file.LOG, 'before ineffective_controls:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1303: OPEN ineffective_controls;
1304: FETCH ineffective_controls INTO l_ineffective_controls;
1305: CLOSE ineffective_controls;
1306:

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

1303: OPEN ineffective_controls;
1304: FETCH ineffective_controls INTO l_ineffective_controls;
1305: CLOSE ineffective_controls;
1306:
1307: fnd_file.put_line(fnd_file.LOG, 'before orgs_pending_in_scop:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1308: OPEN orgs_pending_in_scope;
1309: FETCH orgs_pending_in_scope INTO l_orgs_pending_in_scope;
1310: CLOSE orgs_pending_in_scope;
1311:

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

1308: OPEN orgs_pending_in_scope;
1309: FETCH orgs_pending_in_scope INTO l_orgs_pending_in_scope;
1310: CLOSE orgs_pending_in_scope;
1311:
1312: fnd_file.put_line(fnd_file.LOG, 'before orgs_in_scope:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1313: OPEN orgs_in_scope;
1314: FETCH orgs_in_scope INTO l_orgs_in_scope;
1315: CLOSE orgs_in_scope;
1316: fnd_file.put_line(fnd_file.LOG, 'after orgs_in_scope:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

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

1312: fnd_file.put_line(fnd_file.LOG, 'before orgs_in_scope:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1313: OPEN orgs_in_scope;
1314: FETCH orgs_in_scope INTO l_orgs_in_scope;
1315: CLOSE orgs_in_scope;
1316: fnd_file.put_line(fnd_file.LOG, 'after orgs_in_scope:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1317:
1318:
1319: OPEN orgs_pending_cert;
1320: FETCH orgs_pending_cert INTO l_orgs_pending_cert;

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

1318:
1319: OPEN orgs_pending_cert;
1320: FETCH orgs_pending_cert INTO l_orgs_pending_cert;
1321: CLOSE orgs_pending_cert;
1322: fnd_file.put_line(fnd_file.LOG, 'after orgs_pending_cert:'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1323:
1324: UPDATE AMW_CERT_DASHBOARD_SUM
1325: SET NEW_RISKS_ADDED = l_new_risks_added,
1326: NEW_CONTROLS_ADDED = l_new_controls_added,

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

1387: END IF;
1388: commit;
1389: EXCEPTION
1390: WHEN OTHERS THEN
1391: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_DetSummary'
1392: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1393:
1394: END POPULATE_CERT_GENERAL_SUM;
1395:

Line 1427: fnd_file.put_line (fnd_file.LOG,

1423: l_start_date DATE;
1424:
1425: BEGIN
1426:
1427: fnd_file.put_line (fnd_file.LOG,
1428: 'Certification_Id:'||p_certification_id);
1429: IF p_certification_id IS NOT NULL
1430: THEN
1431: OPEN c_start_date;

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

1441:
1442: EXCEPTION
1443: WHEN NO_DATA_FOUND
1444: THEN
1445: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_General_Sum'
1446: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1447: WHEN OTHERS
1448: THEN
1449: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_General_Sum'

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

1445: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_All_Cert_General_Sum'
1446: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1447: WHEN OTHERS
1448: THEN
1449: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_All_Cert_General_Sum'
1450: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1451: errbuf := SQLERRM;
1452: ---05.24.2005 npanandi: changed retcode to 2 to comply with number datatype
1453: retcode := 2; --FND_API.G_RET_STS_UNEXP_ERROR;

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

1493: WHERE cert.certification_status in ('ACTIVE','DRAFT')
1494: AND cert.object_type = 'PROCESS';
1495:
1496: BEGIN
1497: fnd_file.put_line (fnd_file.LOG,'Certification Id :' || p_certification_id);
1498:
1499: l_reqdata := FND_CONC_GLOBAL.request_data;
1500: IF (l_reqdata is NOT NULL) THEN
1501: return;

Line 1505: fnd_file.put_line(fnd_file.LOG, 'reset execution scope start...'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1501: return;
1502: END IF;
1503: l_reqdata := 1;
1504:
1505: fnd_file.put_line(fnd_file.LOG, 'reset execution scope start...'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1506:
1507: --The following section is commented
1508: --In AMW.D and future releases we don't need to rescope everytime the user runs the concurrent program
1509:

Line 1520: fnd_file.put_line(fnd_file.LOG, 'Problems in insert audit units' || lx_msg_data ||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1516: x_msg_data => lx_msg_data);
1517: commit;
1518:
1519: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1520: fnd_file.put_line(fnd_file.LOG, 'Problems in insert audit units' || lx_msg_data ||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1521: END IF;
1522:
1523: ELSE
1524: FOR each_record IN get_all_certifications

Line 1534: fnd_file.put_line(fnd_file.LOG, 'Problems in insert audit units' || lx_msg_data || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1530: x_msg_data => lx_msg_data);
1531: commit;
1532:
1533: IF lx_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1534: fnd_file.put_line(fnd_file.LOG, 'Problems in insert audit units' || lx_msg_data || to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1535: END IF;
1536: END LOOP;
1537: END IF;*/
1538:

Line 1540: fnd_file.put_line(fnd_file.LOG, 'reset execution scope end...'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1536: END LOOP;
1537: END IF;*/
1538:
1539:
1540: fnd_file.put_line(fnd_file.LOG, 'reset execution scope end...'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1541:
1542: /* Sub Request for Dashboard Summary */
1543: l_request_id := FND_REQUEST.SUBMIT_REQUEST('AMW',
1544: 'PCDASHSUM',

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

1547: TRUE,
1548: to_char(p_certification_id));
1549: IF l_request_id = 0 THEN
1550: l_msg:=FND_MESSAGE.GET;
1551: fnd_file.put_line (fnd_file.LOG,l_msg);
1552: ELSE
1553: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Dashboard Summary :' || l_request_id );
1554: END IF;
1555:

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

1549: IF l_request_id = 0 THEN
1550: l_msg:=FND_MESSAGE.GET;
1551: fnd_file.put_line (fnd_file.LOG,l_msg);
1552: ELSE
1553: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Dashboard Summary :' || l_request_id );
1554: END IF;
1555:
1556:
1557: /* Sub Request for Evaluation Summary for Processes */

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

1562: TRUE,
1563: to_char(p_certification_id));
1564: IF l_request_id = 0 THEN
1565: l_msg:=FND_MESSAGE.GET;
1566: fnd_file.put_line (fnd_file.LOG,l_msg);
1567: ELSE
1568: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Evaluation Summary for processes :' || l_request_id );
1569: END IF;
1570:

Line 1568: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Evaluation Summary for processes :' || l_request_id );

1564: IF l_request_id = 0 THEN
1565: l_msg:=FND_MESSAGE.GET;
1566: fnd_file.put_line (fnd_file.LOG,l_msg);
1567: ELSE
1568: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Evaluation Summary for processes :' || l_request_id );
1569: END IF;
1570:
1571: /* Sub Request for Evaluation Summary for Organizations */
1572: l_request_id := FND_REQUEST.SUBMIT_REQUEST('AMW',

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

1576: TRUE,
1577: to_char(p_certification_id));
1578: IF l_request_id = 0 THEN
1579: l_msg:=FND_MESSAGE.GET;
1580: fnd_file.put_line (fnd_file.LOG,l_msg);
1581: ELSE
1582: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Evaluation Summary for organizations :' || l_request_id );
1583: END IF;
1584:

Line 1582: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Evaluation Summary for organizations :' || l_request_id );

1578: IF l_request_id = 0 THEN
1579: l_msg:=FND_MESSAGE.GET;
1580: fnd_file.put_line (fnd_file.LOG,l_msg);
1581: ELSE
1582: fnd_file.put_line (fnd_file.LOG,'Submitted Request for Evaluation Summary for organizations :' || l_request_id );
1583: END IF;
1584:
1585:
1586: FND_CONC_GLOBAL.set_req_globals(conc_status => 'PAUSED',

Line 1592: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Proc_Cert_Sum'

1588: COMMIT;
1589:
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Proc_Cert_Sum'
1593: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1594: errbuf := SQLERRM;
1595: retcode := FND_API.G_RET_STS_UNEXP_ERROR;
1596:

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

1623: l_open_issues NUMBER;
1624:
1625:
1626: BEGIN
1627: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
1628: fnd_file.put_line(fnd_file.LOG, 'start timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1629:
1630:
1631: FOR proc_rec IN get_all_processes LOOP

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

1624:
1625:
1626: BEGIN
1627: fnd_file.put_line (fnd_file.LOG, 'p_certification_id='||to_char(p_certification_id));
1628: fnd_file.put_line(fnd_file.LOG, 'start timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1629:
1630:
1631: FOR proc_rec IN get_all_processes LOOP
1632: l_open_findings := amw_findings_pkg.calculate_open_findings(

Line 1694: fnd_file.put_line(fnd_file.LOG, 'end timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));

1690: WHERE certification_id = p_certification_id
1691: AND organization_id = org_rec.organization_id;
1692: END LOOP;
1693:
1694: fnd_file.put_line(fnd_file.LOG, 'end timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1695: COMMIT;
1696: EXCEPTION
1697: WHEN NO_DATA_FOUND THEN
1698: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Summary'

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

1694: fnd_file.put_line(fnd_file.LOG, 'end timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
1695: COMMIT;
1696: EXCEPTION
1697: WHEN NO_DATA_FOUND THEN
1698: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Summary'
1699: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1700: WHEN OTHERS THEN
1701: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Summary'
1702: || SUBSTR (SQLERRM, 1, 100), 1, 200));

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

1697: WHEN NO_DATA_FOUND THEN
1698: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Summary'
1699: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1700: WHEN OTHERS THEN
1701: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Summary'
1702: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1703:
1704: END populate_findings;
1705:

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

1719:
1720: proc_rec get_all_processes%rowtype;
1721:
1722: BEGIN
1723: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
1724:
1725: IF p_certification_id IS NOT NULL
1726: THEN
1727: Populate_Findings(p_certification_id);

Line 1737: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Proccert_Findings'

1733:
1734: EXCEPTION
1735: WHEN NO_DATA_FOUND
1736: THEN
1737: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in Populate_Proccert_Findings'
1738: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1739:
1740: WHEN OTHERS
1741: THEN

Line 1742: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Proccert_Findings'

1738: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1739:
1740: WHEN OTHERS
1741: THEN
1742: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in Populate_Proccert_Findings'
1743: || SUBSTR (SQLERRM, 1, 100), 1, 200));
1744:
1745: END Populate_Proccert_Findings;
1746: