DBA Data[Home] [Help]

APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on FND_MSG_PUB

Line 52: -- fnd_msg_pub.initialize;

48: l_eff_report_approved Exception;
49: l_approved_eff_rep_exist Number:= 0;
50:
51: BEGIN
52: -- fnd_msg_pub.initialize;
53:
54: fnd_file.put_line (FND_FILE.LOG, 'p_person_id= '||p_person_id );
55:
56: OPEN c_get_approved_eff_rep(p_request_id,P_PERSON_ID);

Line 173: fnd_msg_pub.add;

169: EXCEPTION
170: WHEN l_eff_report_approved THEN
171: ROLLBACK;
172: fnd_message.set_name('PSP', 'PSP_EFF_REP_APPR_STATUS');
173: fnd_msg_pub.add;
174: retCode :=2;
175:
176: WHEN OTHERS
177: THEN

Line 181: fnd_msg_pub.add;

177: THEN
178: ROLLBACK;
179: fnd_message.set_name('PSP','PSP_SQL_ERROR');
180: fnd_message.set_token('SQLERROR',sqlerrm);
181: fnd_msg_pub.add;
182: psp_message_s.print_error(p_mode => FND_FILE.LOG,
183: p_print_header => FND_API.G_TRUE);
184: retCode :=2;
185: