eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ARCHIVE_RETRIEVE dependencies on FND_MESSAGE

Line 188: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');

184: FETCH effort_pending_cur INTO effort_pending_rec;
185: l_effort_count := effort_pending_cur%ROWCOUNT;
186: CLOSE effort_pending_cur;
187: --End of Bug Fix
188: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);

Line 189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);

185: l_effort_count := effort_pending_cur%ROWCOUNT;
186: CLOSE effort_pending_cur;
187: --End of Bug Fix
188: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

Line 190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);

186: CLOSE effort_pending_cur;
187: --End of Bug Fix
188: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
194: fnd_msg_pub.add;

Line 191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);

187: --End of Bug Fix
188: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
194: fnd_msg_pub.add;
195:

Line 192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);

188: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
194: fnd_msg_pub.add;
195:
196: -- Checking for periods which have unprocessed lines

Line 193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

189: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
190: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
191: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
192: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
193: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
194: fnd_msg_pub.add;
195:
196: -- Checking for periods which have unprocessed lines
197: OPEN error_check_cur;

Line 210: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDO_CANNOT_ARCHIVE');

206: EXIT WHEN error_check_cur%NOTFOUND ;
207: l_time_period := error_check_rec.time_period_id;
208: l_period_name := error_check_rec.period_name;
209: IF (error_check_rec.source_type = 'O') THEN
210: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDO_CANNOT_ARCHIVE');
211: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
212: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
213: fnd_msg_pub.add;
214:

Line 211: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

207: l_time_period := error_check_rec.time_period_id;
208: l_period_name := error_check_rec.period_name;
209: IF (error_check_rec.source_type = 'O') THEN
210: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDO_CANNOT_ARCHIVE');
211: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
212: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
213: fnd_msg_pub.add;
214:
215: ELSIF (error_check_rec.source_type = 'N') THEN

Line 212: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);

208: l_period_name := error_check_rec.period_name;
209: IF (error_check_rec.source_type = 'O') THEN
210: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDO_CANNOT_ARCHIVE');
211: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
212: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
213: fnd_msg_pub.add;
214:
215: ELSIF (error_check_rec.source_type = 'N') THEN
216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');

Line 216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');

212: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
213: fnd_msg_pub.add;
214:
215: ELSIF (error_check_rec.source_type = 'N') THEN
216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');
217: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
218: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
219: fnd_msg_pub.add;
220:

Line 217: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

213: fnd_msg_pub.add;
214:
215: ELSIF (error_check_rec.source_type = 'N') THEN
216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');
217: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
218: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
219: fnd_msg_pub.add;
220:
221: ELSIF (error_check_rec.source_type = 'P') THEN

Line 218: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);

214:
215: ELSIF (error_check_rec.source_type = 'N') THEN
216: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDN_CANNOT_ARCHIVE');
217: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
218: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
219: fnd_msg_pub.add;
220:
221: ELSIF (error_check_rec.source_type = 'P') THEN
222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');

Line 222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');

218: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
219: fnd_msg_pub.add;
220:
221: ELSIF (error_check_rec.source_type = 'P') THEN
222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');
223: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
224: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
225: fnd_msg_pub.add;
226:

Line 223: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

219: fnd_msg_pub.add;
220:
221: ELSIF (error_check_rec.source_type = 'P') THEN
222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');
223: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
224: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
225: fnd_msg_pub.add;
226:
227: ELSIF (error_check_rec.source_type = 'A') THEN

Line 224: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);

220:
221: ELSIF (error_check_rec.source_type = 'P') THEN
222: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_LDP_CANNOT_ARCHIVE');
223: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
224: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
225: fnd_msg_pub.add;
226:
227: ELSIF (error_check_rec.source_type = 'A') THEN
228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');

Line 228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');

224: FND_MESSAGE.SET_TOKEN('TIME_PERIOD',l_period_name);
225: fnd_msg_pub.add;
226:
227: ELSIF (error_check_rec.source_type = 'A') THEN
228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');
229: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
230: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
231: fnd_msg_pub.add;
232: END IF;

Line 229: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

225: fnd_msg_pub.add;
226:
227: ELSIF (error_check_rec.source_type = 'A') THEN
228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');
229: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
230: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
231: fnd_msg_pub.add;
232: END IF;
233: END LOOP;

Line 230: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

226:
227: ELSIF (error_check_rec.source_type = 'A') THEN
228: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LDA_CANNOT_ARCHIVE');
229: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
230: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
231: fnd_msg_pub.add;
232: END IF;
233: END LOOP;
234: CLOSE error_check_cur;

Line 246: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');

242: FETCH effort_pending_cur INTO effort_pending_rec;
243: EXIT WHEN effort_pending_cur%NOTFOUND ;
244:
245: l_period_name := effort_pending_rec.period_name;
246: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
247: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
248: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
249: fnd_msg_pub.add;
250: END LOOP;

Line 247: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

243: EXIT WHEN effort_pending_cur%NOTFOUND ;
244:
245: l_period_name := effort_pending_rec.period_name;
246: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
247: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
248: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
249: fnd_msg_pub.add;
250: END LOOP;
251: CLOSE effort_pending_cur;

Line 248: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

244:
245: l_period_name := effort_pending_rec.period_name;
246: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
247: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
248: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
249: fnd_msg_pub.add;
250: END LOOP;
251: CLOSE effort_pending_cur;
252: END IF;

Line 257: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

253: --End of Bug Fix
254:
255: l_status := 'unsuccessful';
256:
257: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
258: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
259: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
260: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
261: fnd_msg_pub.add;

Line 258: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);

254:
255: l_status := 'unsuccessful';
256:
257: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
258: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
259: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
260: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
261: fnd_msg_pub.add;
262: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 259: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);

255: l_status := 'unsuccessful';
256:
257: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
258: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
259: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
260: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
261: fnd_msg_pub.add;
262: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;

Line 260: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

256:
257: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
258: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
259: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
260: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
261: fnd_msg_pub.add;
262: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264:

Line 276: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');

272: FETCH effort_pending_cur INTO effort_pending_rec;
273: EXIT WHEN effort_pending_cur%NOTFOUND ;
274:
275: l_period_name := effort_pending_rec.period_name;
276: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
277: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
278: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
279: fnd_msg_pub.add;
280: END LOOP;

Line 277: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

273: EXIT WHEN effort_pending_cur%NOTFOUND ;
274:
275: l_period_name := effort_pending_rec.period_name;
276: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
277: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
278: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
279: fnd_msg_pub.add;
280: END LOOP;
281: CLOSE effort_pending_cur;

Line 278: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

274:
275: l_period_name := effort_pending_rec.period_name;
276: FND_MESSAGE.SET_NAME('PSP', 'PSP_EFFORT_ARCH_PENDING');
277: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
278: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
279: fnd_msg_pub.add;
280: END LOOP;
281: CLOSE effort_pending_cur;
282:

Line 283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

279: fnd_msg_pub.add;
280: END LOOP;
281: CLOSE effort_pending_cur;
282:
283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
284: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
285: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
286: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
287: fnd_msg_pub.add;

Line 284: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);

280: END LOOP;
281: CLOSE effort_pending_cur;
282:
283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
284: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
285: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
286: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
287: fnd_msg_pub.add;
288: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 285: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);

281: CLOSE effort_pending_cur;
282:
283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
284: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
285: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
286: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
287: fnd_msg_pub.add;
288: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;

Line 286: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

282:
283: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
284: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
285: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
286: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
287: fnd_msg_pub.add;
288: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290: --End of Bug Fix

Line 581: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_ARCHIVE_PERIOD');

577: SET PPC.archive_flag = 'Y'
578: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
579:
580: Commit;
581: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_ARCHIVE_PERIOD');
582: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
583: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
584: fnd_msg_pub.add;
585: END LOOP;

Line 582: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

578: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
579:
580: Commit;
581: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_ARCHIVE_PERIOD');
582: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
583: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
584: fnd_msg_pub.add;
585: END LOOP;
586: CLOSE valid_period_cur;

Line 583: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

579:
580: Commit;
581: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_ARCHIVE_PERIOD');
582: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
583: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
584: fnd_msg_pub.add;
585: END LOOP;
586: CLOSE valid_period_cur;
587:

Line 589: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

585: END LOOP;
586: CLOSE valid_period_cur;
587:
588: l_status:='successful';
589: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
590: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
593: fnd_msg_pub.add;

Line 590: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);

586: CLOSE valid_period_cur;
587:
588: l_status:='successful';
589: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
590: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
593: fnd_msg_pub.add;
594: --psp_message_s.print_success;

Line 591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);

587:
588: l_status:='successful';
589: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
590: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
593: fnd_msg_pub.add;
594: --psp_message_s.print_success;
595: psp_message_s.print_error(p_mode=>FND_FILE.log,

Line 592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

588: l_status:='successful';
589: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
590: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
591: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
592: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
593: fnd_msg_pub.add;
594: --psp_message_s.print_success;
595: psp_message_s.print_error(p_mode=>FND_FILE.log,
596: p_print_header=>FND_API.G_FALSE);

Line 704: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');

700: FETCH end_period_name_cur INTO end_period_name_rec;
701: l_end_period_name := end_period_name_rec.period_name;
702: CLOSE end_period_name_cur;
703:
704: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);

Line 705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);

701: l_end_period_name := end_period_name_rec.period_name;
702: CLOSE end_period_name_cur;
703:
704: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

Line 706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);

702: CLOSE end_period_name_cur;
703:
704: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
710: fnd_msg_pub.add;

Line 707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);

703:
704: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
710: fnd_msg_pub.add;
711:

Line 708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);

704: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_START');
705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
710: fnd_msg_pub.add;
711:
712: OPEN valid_period_cur;

Line 709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

705: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
706: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
707: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD', l_begin_period_name);
708: FND_MESSAGE.SET_TOKEN('END_PERIOD', l_end_period_name);
709: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
710: fnd_msg_pub.add;
711:
712: OPEN valid_period_cur;
713: LOOP

Line 1002: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_RETRIEVE_PERIOD');

998: SET PPC.archive_flag = NULL
999: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
1000:
1001: Commit;
1002: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_RETRIEVE_PERIOD');
1003: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1004: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1005: fnd_msg_pub.add;
1006: END LOOP;

Line 1003: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

999: WHERE PPC.time_period_id = valid_period_rec.time_period_id;
1000:
1001: Commit;
1002: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_RETRIEVE_PERIOD');
1003: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1004: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1005: fnd_msg_pub.add;
1006: END LOOP;
1007: CLOSE valid_period_cur;

Line 1004: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

1000:
1001: Commit;
1002: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_LD_RETRIEVE_PERIOD');
1003: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1004: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1005: fnd_msg_pub.add;
1006: END LOOP;
1007: CLOSE valid_period_cur;
1008:

Line 1010: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

1006: END LOOP;
1007: CLOSE valid_period_cur;
1008:
1009: l_status:='successful';
1010: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1011: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1014: fnd_msg_pub.add;

Line 1011: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);

1007: CLOSE valid_period_cur;
1008:
1009: l_status:='successful';
1010: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1011: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1014: fnd_msg_pub.add;
1015: --psp_message_s.print_success;

Line 1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);

1008:
1009: l_status:='successful';
1010: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1011: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1014: fnd_msg_pub.add;
1015: --psp_message_s.print_success;
1016: psp_message_s.print_error(p_mode=>FND_FILE.log,

Line 1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);

1009: l_status:='successful';
1010: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1011: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE', l_process_type);
1012: FND_MESSAGE.SET_TOKEN('LINES_TYPE', l_lines_type);
1013: FND_MESSAGE.SET_TOKEN('STATUS', l_status);
1014: fnd_msg_pub.add;
1015: --psp_message_s.print_success;
1016: psp_message_s.print_error(p_mode=>FND_FILE.log,
1017: p_print_header=>FND_API.G_FALSE);

Line 1113: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');

1109: Fetch parameter_cur Into l_payroll_name, l_begin_period, l_end_period;
1110: Close parameter_cur;
1111:
1112: -- Process Initialization Message
1113: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);

Line 1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);

1110: Close parameter_cur;
1111:
1112: -- Process Initialization Message
1113: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);

Line 1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

1111:
1112: -- Process Initialization Message
1113: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1119: fnd_msg_pub.add;

Line 1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);

1112: -- Process Initialization Message
1113: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1119: fnd_msg_pub.add;
1120:

Line 1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);

1113: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1119: fnd_msg_pub.add;
1120:
1121: -- Check for Error time periods, If present log their corresponding messages

Line 1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);

1114: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1115: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1116: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1117: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1118: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1119: fnd_msg_pub.add;
1120:
1121: -- Check for Error time periods, If present log their corresponding messages
1122: Open invalid_period_cur;

Line 1129: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_CANNOT_ARCHIVE');

1125:
1126: If (l_error_period_count > 0) Then
1127: Loop
1128: -- Print the log message for the current period
1129: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_CANNOT_ARCHIVE');
1130: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1131: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1132: fnd_msg_pub.add;
1133:

Line 1130: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

1126: If (l_error_period_count > 0) Then
1127: Loop
1128: -- Print the log message for the current period
1129: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_CANNOT_ARCHIVE');
1130: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1131: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1132: fnd_msg_pub.add;
1133:
1134: Fetch invalid_period_cur Into l_period_name;

Line 1131: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

1127: Loop
1128: -- Print the log message for the current period
1129: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_CANNOT_ARCHIVE');
1130: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1131: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1132: fnd_msg_pub.add;
1133:
1134: Fetch invalid_period_cur Into l_period_name;
1135: Exit When invalid_period_cur%NOTFOUND;

Line 1144: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

1140: -- Set the status flag to 'Unsuccesful' for printing it on the log message
1141: l_status:='Unsuccessful';
1142:
1143: -- Print the process end log message
1144: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1145: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1146: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1147: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1148: fnd_msg_pub.add;

Line 1145: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);

1141: l_status:='Unsuccessful';
1142:
1143: -- Print the process end log message
1144: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1145: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1146: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1147: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1148: fnd_msg_pub.add;
1149:

Line 1146: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);

1142:
1143: -- Print the process end log message
1144: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1145: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1146: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1147: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1148: fnd_msg_pub.add;
1149:
1150: -- Raise Unexpected Error exception to end the Procedure

Line 1147: FND_MESSAGE.SET_TOKEN('STATUS',l_status);

1143: -- Print the process end log message
1144: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1145: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1146: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1147: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1148: fnd_msg_pub.add;
1149:
1150: -- Raise Unexpected Error exception to end the Procedure
1151: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1279: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD');

1275: -- Commit the changes made for thecurrent period
1276: COMMIT;
1277:
1278: -- Update the log with with current periods message
1279: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD');
1280: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1281: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1282: fnd_msg_pub.add;
1283:

Line 1280: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

1276: COMMIT;
1277:
1278: -- Update the log with with current periods message
1279: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD');
1280: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1281: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1282: fnd_msg_pub.add;
1283:
1284: -- Continue with the next period

Line 1281: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

1277:
1278: -- Update the log with with current periods message
1279: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD');
1280: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1281: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1282: fnd_msg_pub.add;
1283:
1284: -- Continue with the next period
1285: End Loop;

Line 1291: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

1287: -- Set the status flag to 'Successfull' as all the periods have been successfully archived
1288: l_status:='Successful';
1289:
1290: -- Print the end of process message to the log
1291: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1292: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1293: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1295: fnd_msg_pub.add;

Line 1292: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);

1288: l_status:='Successful';
1289:
1290: -- Print the end of process message to the log
1291: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1292: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1293: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1295: fnd_msg_pub.add;
1296:

Line 1293: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);

1289:
1290: -- Print the end of process message to the log
1291: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1292: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1293: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1295: fnd_msg_pub.add;
1296:
1297: -- Write all the accumulated messages into the log

Line 1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);

1290: -- Print the end of process message to the log
1291: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1292: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1293: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1294: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1295: fnd_msg_pub.add;
1296:
1297: -- Write all the accumulated messages into the log
1298: psp_message_s.print_error( p_mode => FND_FILE.LOG,

Line 1395: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');

1391: Fetch parameter_cur Into l_payroll_name, l_begin_period, l_end_period;
1392: Close parameter_cur;
1393:
1394: -- Process Initialization Message
1395: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);

Line 1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);

1392: Close parameter_cur;
1393:
1394: -- Process Initialization Message
1395: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);

Line 1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);

1393:
1394: -- Process Initialization Message
1395: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1401: fnd_msg_pub.add;

Line 1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);

1394: -- Process Initialization Message
1395: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1401: fnd_msg_pub.add;
1402:

Line 1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);

1395: FND_MESSAGE.SET_NAME('PSP','PSP_ARC_ARCHIVE_RETRIEVE_START');
1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1401: fnd_msg_pub.add;
1402:
1403: -- The valid period loop starts here

Line 1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);

1396: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1397: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME',l_payroll_name);
1398: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1399: FND_MESSAGE.SET_TOKEN('BEGIN_PERIOD',l_begin_period);
1400: FND_MESSAGE.SET_TOKEN('END_PERIOD',l_end_period);
1401: fnd_msg_pub.add;
1402:
1403: -- The valid period loop starts here
1404: Open valid_period_cur;

Line 1530: -- FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD'); --For Bug 2783253

1526: -- Commit the changes made for thecurrent period
1527: COMMIT;
1528:
1529: -- Update the log with with current periods message
1530: -- FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD'); --For Bug 2783253
1531: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_RETRIEVE_PERIOD'); --For Bug 2783253
1532: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1533: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1534: fnd_msg_pub.add;

Line 1531: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_RETRIEVE_PERIOD'); --For Bug 2783253

1527: COMMIT;
1528:
1529: -- Update the log with with current periods message
1530: -- FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD'); --For Bug 2783253
1531: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_RETRIEVE_PERIOD'); --For Bug 2783253
1532: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1533: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1534: fnd_msg_pub.add;
1535:

Line 1532: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);

1528:
1529: -- Update the log with with current periods message
1530: -- FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD'); --For Bug 2783253
1531: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_RETRIEVE_PERIOD'); --For Bug 2783253
1532: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1533: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1534: fnd_msg_pub.add;
1535:
1536: -- Continue with the next period

Line 1533: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);

1529: -- Update the log with with current periods message
1530: -- FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_ARCHIVE_PERIOD'); --For Bug 2783253
1531: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_EN_RETRIEVE_PERIOD'); --For Bug 2783253
1532: FND_MESSAGE.SET_TOKEN('PAYROLL_NAME', l_payroll_name);
1533: FND_MESSAGE.SET_TOKEN('TIME_PERIOD', l_period_name);
1534: fnd_msg_pub.add;
1535:
1536: -- Continue with the next period
1537: End Loop;

Line 1543: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');

1539: -- Set the status flag to 'Successfull' as all the periods have been successfully archived
1540: l_status:='Successful';
1541:
1542: -- Print the end of process message to the log
1543: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1544: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1545: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1547: fnd_msg_pub.add;

Line 1544: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);

1540: l_status:='Successful';
1541:
1542: -- Print the end of process message to the log
1543: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1544: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1545: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1547: fnd_msg_pub.add;
1548:

Line 1545: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);

1541:
1542: -- Print the end of process message to the log
1543: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1544: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1545: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1547: fnd_msg_pub.add;
1548:
1549: -- Write all messages into Log

Line 1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);

1542: -- Print the end of process message to the log
1543: FND_MESSAGE.SET_NAME('PSP', 'PSP_ARC_ARCHIVE_RETRIEVE_END');
1544: FND_MESSAGE.SET_TOKEN('PROCESS_TYPE',l_process_type);
1545: FND_MESSAGE.SET_TOKEN('LINES_TYPE',l_lines_type);
1546: FND_MESSAGE.SET_TOKEN('STATUS',l_status);
1547: fnd_msg_pub.add;
1548:
1549: -- Write all messages into Log
1550: psp_message_s.print_error( p_mode => FND_FILE.LOG,