DBA Data[Home] [Help]

APPS.AMW_ORG_CERT_EVAL_SUM_PVT dependencies on FND_FILE

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

36: BEGIN
37:
38: SAVEPOINT populate_org_summary;
39:
40: fnd_file.put_line (fnd_file.LOG, 'Certification_Id:'||p_certification_id);
41:
42: IF p_certification_id IS NULL
43: THEN
44: FOR each_rec in get_all_certifications LOOP

Line 53: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in populate_org_cert_summary'

49: END IF;
50:
51: EXCEPTION WHEN NO_DATA_FOUND
52: THEN
53: fnd_file.put_line (fnd_file.LOG, SUBSTR ('No data found in populate_org_cert_summary'
54: || SUBSTR (SQLERRM, 1, 100), 1, 200));
55:
56: WHEN OTHERS
57: THEN

Line 58: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in populate_org_cert_summary'

54: || SUBSTR (SQLERRM, 1, 100), 1, 200));
55:
56: WHEN OTHERS
57: THEN
58: fnd_file.put_line (fnd_file.LOG, SUBSTR ('Unexpected Error in populate_org_cert_summary'
59: || SUBSTR (SQLERRM, 1, 100), 1, 200));
60:
61: END populate_org_cert_summary
62: ;

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

98: x_msg_data => l_msg_data
99: );
100: END LOOP;
101:
102: fnd_file.put_line(fnd_file.LOG, 'end timestamp :'||to_char(sysdate, 'hh:mi:ss dd-mon-rrrr'));
103:
104: EXCEPTION WHEN OTHERS THEN
105: ROLLBACK TO POPULATE_ORG_SPECIFIC;
106: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'populate_org_cert_sum_spec');