DBA Data[Home] [Help]

APPS.PSP_UPGRADE_EFF_REPORTS dependencies on FND_FILE

Line 252: fnd_file.put_line( FND_FILE.LOG, l_msg_buf);

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;
256: eff_master_rec.person_id.delete;

Line 284: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

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;
288: eff_master_rec.full_name.delete;

Line 317: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

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;
321: eff_master_rec.person_id.delete;

Line 338: -- fnd_file.put_line( FND_FILE.LOG, ' Before ES');

334: hr_utility.trace('Migration:START');
335:
336: /* Regular Mode, No pending Distribution Adjustments, No pending Effort Reports */
337:
338: -- fnd_file.put_line( FND_FILE.LOG, ' Before ES');
339:
340: hr_utility.trace('Set the Element Set Name');
341: IF p_element_Set_name is null then
342:

Line 374: -- fnd_file.put_line (FND_FILE.LOG, 'Deep l_element_Set_name= '||l_element_Set_name );

370:
371: -- IF (l_is_element_set_alredy_exist = 1) then
372: -- l_element_Set_name := substr(l_element_Set_name,1,length(l_element_Set_name)-length(l_element_set_suffix_number-1)) || l_element_set_suffix_number ;
373: -- l_element_set_suffix_number := l_element_set_suffix_number + 1;
374: -- fnd_file.put_line (FND_FILE.LOG, 'Deep l_element_Set_name= '||l_element_Set_name );
375: -- GOTO loop_again;
376: -- END IF;
377:
378: OPEN effort_element_csr(l_business_group_id);

Line 394: -- FND_FILE.PUT_LINE( FND_FILE.LOG, ' After ES insert ');

390: l_element_Set_name := substr(l_element_Set_name,1,length(l_element_Set_name)-length(l_element_set_suffix_number-1)) || l_element_set_suffix_number ;
391: END IF;
392: l_element_set_suffix_number := l_element_set_suffix_number + 1;
393:
394: -- FND_FILE.PUT_LINE( FND_FILE.LOG, ' After ES insert ');
395:
396: -- FORALL i in 1..eff_element_rec.element_type_id.count
397:
398: For i in 1..eff_element_rec.element_type_id.count

Line 408: -- fnd_file.put_line( FND_FILE.LOG, ' After members insert ');

404: pay_element_type_rules_pkg.insert_row(l_rowid, eff_element_rec.element_type_id(i), l_element_Set_id, 'I',
405: sysdate, fnd_global.user_id, fnd_global.user_id, fnd_global.user_id, sysdate);
406:
407: END LOOP;
408: -- fnd_file.put_line( FND_FILE.LOG, ' After members insert ');
409: psp_message_s.print_success;
410:
411:
412: END LOOP;

Line 420: -- fnd_file.put_line( FND_FILE.LOG, ' Before menu delete ');

416:
417:
418: /* Delete the obsolete menu items */
419:
420: -- fnd_file.put_line( FND_FILE.LOG, ' Before menu delete ');
421:
422: hr_utility.trace(' Delete Menus : START');
423: hr_utility.trace(' Delete Menu : Effort Report Period Summary');
424:

Line 558: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

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
562: ROLLBACK;

Line 566: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

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;
570: WHEN l_migration_not_allowed then

Line 574: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );

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;
578: WHEN OTHERS THEN

Line 583: psp_message_s.print_error(p_mode => FND_FILE.LOG,

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;
586: hr_utility.trace_off;
587: END migrate_eff_reports;