DBA Data[Home] [Help]

APPS.PSP_UPGRADE_EFF_REPORTS dependencies on FND_MESSAGE

Line 246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');

242: hr_utility.trace('Pending Effort reports count =' || l_appr_exists);
243:
244: FOR i in 1..l_appr_exists
245: LOOP
246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');
247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));

Line 247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));

243:
244: FOR i in 1..l_appr_exists
245: LOOP
246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');
247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
251: l_msg_buf := Fnd_Message.Get ;

Line 248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));

244: FOR i in 1..l_appr_exists
245: LOOP
246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');
247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
251: l_msg_buf := Fnd_Message.Get ;
252: fnd_file.put_line( FND_FILE.LOG, l_msg_buf);

Line 249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));

245: LOOP
246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');
247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
251: l_msg_buf := Fnd_Message.Get ;
252: fnd_file.put_line( FND_FILE.LOG, l_msg_buf);
253: END LOOP;

Line 250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));

246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');
247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
251: l_msg_buf := Fnd_Message.Get ;
252: fnd_file.put_line( FND_FILE.LOG, l_msg_buf);
253: END LOOP;
254:

Line 251: l_msg_buf := Fnd_Message.Get ;

247: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
248: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
249: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
250: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
251: l_msg_buf := Fnd_Message.Get ;
252: fnd_file.put_line( FND_FILE.LOG, l_msg_buf);
253: END LOOP;
254:
255: eff_master_rec.effort_report_id.delete;

Line 277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');

273: l_pending_da := eff_master_rec.effort_report_id.count;
274: hr_utility.trace('Pending distribution adjustments =' || l_pending_da );
275: FOR i in 1..l_pending_da
276: LOOP
277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');
278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));

Line 278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));

274: hr_utility.trace('Pending distribution adjustments =' || l_pending_da );
275: FOR i in 1..l_pending_da
276: LOOP
277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');
278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));

Line 279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));

275: FOR i in 1..l_pending_da
276: LOOP
277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');
278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
283: l_msg_buf := Fnd_Message.Get ;

Line 280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));

276: LOOP
277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');
278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
283: l_msg_buf := Fnd_Message.Get ;
284: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

Line 281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));

277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');
278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
283: l_msg_buf := Fnd_Message.Get ;
284: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
285: END LOOP;

Line 282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));

278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
283: l_msg_buf := Fnd_Message.Get ;
284: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
285: END LOOP;
286: eff_master_rec.effort_report_id.delete;

Line 283: l_msg_buf := Fnd_Message.Get ;

279: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
280: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
281: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
282: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
283: l_msg_buf := Fnd_Message.Get ;
284: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
285: END LOOP;
286: eff_master_rec.effort_report_id.delete;
287: eff_master_rec.person_id.delete;

Line 310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');

306: l_pending_summ_trans := eff_master_rec.effort_report_id.count;
307: hr_utility.trace('distribution adjustments not S and T ='|| l_pending_summ_trans);
308: FOR i in 1..l_pending_summ_trans
309: LOOP
310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');
311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));

Line 311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));

307: hr_utility.trace('distribution adjustments not S and T ='|| l_pending_summ_trans);
308: FOR i in 1..l_pending_summ_trans
309: LOOP
310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');
311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));

Line 312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));

308: FOR i in 1..l_pending_summ_trans
309: LOOP
310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');
311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
316: l_msg_buf := Fnd_Message.Get ;

Line 313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));

309: LOOP
310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');
311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
316: l_msg_buf := Fnd_Message.Get ;
317: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

Line 314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));

310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');
311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
316: l_msg_buf := Fnd_Message.Get ;
317: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
318: END LOOP;

Line 315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));

311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));
312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
316: l_msg_buf := Fnd_Message.Get ;
317: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
318: END LOOP;
319: END IF;

Line 316: l_msg_buf := Fnd_Message.Get ;

312: fnd_message.set_token('BGNAME',eff_master_rec.business_group_name(i));
313: fnd_message.set_token('EMPNAME',eff_master_rec.full_name(i));
314: fnd_message.set_token('STARTDATE',eff_master_rec.start_date(i));
315: fnd_message.set_token('ENDDATE',eff_master_rec.end_date(i));
316: l_msg_buf := Fnd_Message.Get ;
317: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
318: END LOOP;
319: END IF;
320: eff_master_rec.effort_report_id.delete;

Line 556: fnd_message.set_name('PSP', 'PSP_ER_ALREADY_MIGRATED');

552: END IF;
553: EXCEPTION
554: WHEN l_er_already_migrated then
555: ROLLBACK;
556: fnd_message.set_name('PSP', 'PSP_ER_ALREADY_MIGRATED');
557: l_msg_buf := Fnd_Message.Get ;
558: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
559: fnd_msg_pub.add;
560: retCode :=0;

Line 557: l_msg_buf := Fnd_Message.Get ;

553: EXCEPTION
554: WHEN l_er_already_migrated then
555: ROLLBACK;
556: fnd_message.set_name('PSP', 'PSP_ER_ALREADY_MIGRATED');
557: l_msg_buf := Fnd_Message.Get ;
558: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
559: fnd_msg_pub.add;
560: retCode :=0;
561: WHEN l_element_set_alredy_exist then

Line 563: fnd_message.set_name('PSP', 'PSP_ER_DUPLICATE_ELEMENT_SET');

559: fnd_msg_pub.add;
560: retCode :=0;
561: WHEN l_element_set_alredy_exist then
562: ROLLBACK;
563: fnd_message.set_name('PSP', 'PSP_ER_DUPLICATE_ELEMENT_SET');
564: fnd_message.set_token('ELEMENTSET',p_element_set_name);
565: l_msg_buf := Fnd_Message.Get ;
566: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
567: fnd_msg_pub.add;

Line 564: fnd_message.set_token('ELEMENTSET',p_element_set_name);

560: retCode :=0;
561: WHEN l_element_set_alredy_exist then
562: ROLLBACK;
563: fnd_message.set_name('PSP', 'PSP_ER_DUPLICATE_ELEMENT_SET');
564: fnd_message.set_token('ELEMENTSET',p_element_set_name);
565: l_msg_buf := Fnd_Message.Get ;
566: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
567: fnd_msg_pub.add;
568: retCode :=2;

Line 565: l_msg_buf := Fnd_Message.Get ;

561: WHEN l_element_set_alredy_exist then
562: ROLLBACK;
563: fnd_message.set_name('PSP', 'PSP_ER_DUPLICATE_ELEMENT_SET');
564: fnd_message.set_token('ELEMENTSET',p_element_set_name);
565: l_msg_buf := Fnd_Message.Get ;
566: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
567: fnd_msg_pub.add;
568: retCode :=2;
569: hr_utility.trace_off;

Line 572: fnd_message.set_name('PSP', 'PSP_ER_MIGRATION_NOT_ALLOWED');

568: retCode :=2;
569: hr_utility.trace_off;
570: WHEN l_migration_not_allowed then
571: ROLLBACK;
572: fnd_message.set_name('PSP', 'PSP_ER_MIGRATION_NOT_ALLOWED');
573: l_msg_buf := Fnd_Message.Get ;
574: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
575: fnd_msg_pub.add;
576: retCode :=2;

Line 573: l_msg_buf := Fnd_Message.Get ;

569: hr_utility.trace_off;
570: WHEN l_migration_not_allowed then
571: ROLLBACK;
572: fnd_message.set_name('PSP', 'PSP_ER_MIGRATION_NOT_ALLOWED');
573: l_msg_buf := Fnd_Message.Get ;
574: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
575: fnd_msg_pub.add;
576: retCode :=2;
577: hr_utility.trace_off;

Line 580: fnd_message.set_name('PSP','PSP_SQL_ERROR');

576: retCode :=2;
577: hr_utility.trace_off;
578: WHEN OTHERS THEN
579: ROLLBACK;
580: fnd_message.set_name('PSP','PSP_SQL_ERROR');
581: fnd_message.set_token('SQLERROR',sqlerrm||l_err_phase);
582: fnd_msg_pub.add;
583: psp_message_s.print_error(p_mode => FND_FILE.LOG,
584: p_print_header => FND_API.G_TRUE);

Line 581: fnd_message.set_token('SQLERROR',sqlerrm||l_err_phase);

577: hr_utility.trace_off;
578: WHEN OTHERS THEN
579: ROLLBACK;
580: fnd_message.set_name('PSP','PSP_SQL_ERROR');
581: fnd_message.set_token('SQLERROR',sqlerrm||l_err_phase);
582: fnd_msg_pub.add;
583: psp_message_s.print_error(p_mode => FND_FILE.LOG,
584: p_print_header => FND_API.G_TRUE);
585: retCode :=2;