APPS.PSP_ROLLBACK_DIST_LINES dependencies on FND_MSG_PUB

Line 46: fnd_msg_pub.initialize;

42: l_payroll_name VARCHAR2(80); -- Bug 6686483
43: l_deleted BOOLEAN := TRUE;
44: cnt NUMBER := 0;
45: BEGIN
46: fnd_msg_pub.initialize;
47:
48: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Rollback CDL parameters :' );
49: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_type = ' || p_source_type);
50: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' p_source_code = ' || p_source_code);

Line 81: fnd_msg_pub.add;

77: IF payroll_control_rec.status_code in ('P','I')
78: THEN
79: fnd_message.set_name('PSP','PSP_DL_ALREADY_PROCESSED');
80: fnd_message.set_token('TIME_PERIOD',l_period_name);
81: fnd_msg_pub.add;
82: l_deleted := FALSE;
83: ELSIF payroll_control_rec.status_code = 'N'
84: THEN
85: SELECT COUNT(*) INTO cnt

Line 112: fnd_msg_pub.add;

108: but the lines have processed by ST but failed. */
109:
110: fnd_message.set_name('PSP','PSP_DL_ALREADY_PROCESSED');
111: fnd_message.set_token('TIME_PERIOD',l_period_name);
112: fnd_msg_pub.add;
113: l_deleted := FALSE;
114: END IF; /* count(*) = 0 */
115: END IF;
116: END;

Line 133: fnd_msg_pub.add;

129: THEN
130: ROLLBACK;
131: fnd_message.set_name('PSP','PSP_SQL_ERROR');
132: fnd_message.set_token('SQLERROR',sqlerrm);
133: fnd_msg_pub.add;
134: --For Bug 2665152 : Introduced the Error Message and assigned value to retcode
135: psp_message_s.print_error(p_mode => FND_FILE.LOG,
136: p_print_header => FND_API.G_TRUE);
137: retcode:=2;