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 80: fnd_msg_pub.add;

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

Line 111: fnd_msg_pub.add;

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

Line 132: fnd_msg_pub.add;

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