74:
75: /* Record has been processed by Summarise and Transfer */
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'
75: /* Record has been processed by Summarise and Transfer */
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
105: ELSE /* count(*) != 0 */
106: /* Though the payroll control record are having status N
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 */
106: /* Though the payroll control record are having status N
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;
126: EXCEPTION
127: WHEN OTHERS
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,
127: WHEN OTHERS
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);