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');
107:
108: END populate_org_cert_sum_spec;
109:
110:
484:
485: -- Initialize message list if p_init_msg_list is set to TRUE.
486: IF FND_API.to_Boolean( p_init_msg_list )
487: THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: OPEN get_certification_opinion;
492: FETCH get_certification_opinion into l_certification_opinion_id;
684:
685: EXCEPTION WHEN OTHERS
686: THEN
687: ROLLBACK TO populate_summ;
688: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'populate_summary');
689: FND_MSG_PUB.Count_And_Get(
690: p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count,
692: p_data => x_msg_data);
685: EXCEPTION WHEN OTHERS
686: THEN
687: ROLLBACK TO populate_summ;
688: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'populate_summary');
689: FND_MSG_PUB.Count_And_Get(
690: p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count,
692: p_data => x_msg_data);
693: END populate_summary;