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
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
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: ;
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');