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));
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 ;
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);
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;
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:
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;
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));
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));
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 ;
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 );
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;
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;
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;
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));
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));
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 ;
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 );
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;
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;
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;
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;
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
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;
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;
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;
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;
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;
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);
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;