DBA Data[Home] [Help]

APPS.PSP_NON_ORCL_RLBK_PKG dependencies on FND_MSG_PUB

Line 26: fnd_msg_pub.initialize;

22: cursor_batch_agg cursor_batch%RowType;
23:
24: BEGIN
25:
26: fnd_msg_pub.initialize;
27:
28: FOR cursor_batch_agg IN cursor_batch LOOP
29:
30: l_dist_dr_amount := cursor_batch_agg.dist_dr_amount;

Line 45: fnd_msg_pub.add;

41: --dbms_output.put_line('after calling the change_record procedure');
42: ELSE
43: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK');
44: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
45: fnd_msg_pub.add;
46: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
47: --dbms_output.put_line('......The BAtch Name Does not exists');
48: END IF;
49: END LOOP;

Line 55: fnd_msg_pub.add;

51: EXCEPTION
52: WHEN NO_DATA_FOUND THEN
53: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');
54: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
55: fnd_msg_pub.add;
56: --dbms_output.put_line('No data found for the particular batch_name');
57:
58: retcode := 2;
59: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 66: fnd_msg_pub.add;

62:
63: WHEN OTHERS THEN
64: fnd_message.set_name('PSP','PSP_NON_ORCL_RLBK_EXCP');
65: fnd_message.set_token('BATCH_NAME',p_Batch_Name);
66: fnd_msg_pub.add;
67: --dbms_output.put_line('Query raised unhandled exceptions');
68:
69: retcode := 2;
70: psp_message_s.print_error(p_mode => FND_FILE.LOG,