DBA Data[Home] [Help]

APPS.PSP_ROLLBACK_EFF_REPORTS dependencies on FND_MESSAGE

Line 79: fnd_message.set_name('PSP', 'PSP_EFF_REP_APPR_STATUS');

75: END;
76:
77: IF (l_appr_exists =1) then
78: raise l_eff_report_approved;
79: fnd_message.set_name('PSP', 'PSP_EFF_REP_APPR_STATUS');
80:
81: -- One or more effort reports in Approved status already exists for the person
82:
83: ELSE

Line 172: fnd_message.set_name('PSP', 'PSP_EFF_REP_APPR_STATUS');

168: --END IF;
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

Line 179: fnd_message.set_name('PSP','PSP_SQL_ERROR');

175:
176: WHEN OTHERS
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);

Line 180: fnd_message.set_token('SQLERROR',sqlerrm);

176: WHEN OTHERS
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;