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.PA_SCHEDULE_PKG dependencies on PA_SCHEDULE_UTILS

Line 89: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... before return ... ');

85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: /* Checking for the empty table of record */
88: IF (p_sch_record_tab.count = 0 ) THEN
89: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... before return ... ');
90: raise l_empty_tab_record;
91: END IF;
92:
93: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');

Line 93: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');

89: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... before return ... ');
90: raise l_empty_tab_record;
91: END IF;
92:
93: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');
94:
95: l_rounded_total := 0; --Bug 5126919
96:
97: FOR J IN p_sch_record_tab.first..p_sch_record_tab.last LOOP

Line 440: PA_SCHEDULE_UTILS.log_message(1, 'Insert_Row before apply_other_changes ....');

436:
437: --Setting exception_type_code for update workpattern in the exception record
438: l_sch_except_rec.exception_type_code := 'CHANGE_WORK_PATTERN';
439:
440: PA_SCHEDULE_UTILS.log_message(1, 'Insert_Row before apply_other_changes ....');
441:
442: PA_SCHEDULE_PVT.apply_other_changes(p_sch_record_tab,
443: l_sch_except_rec,
444: l_out_sch_rec_tab,

Line 449: PA_SCHEDULE_UTILS.log_message(1, 'Insert_Row After apply_other_changes ....' || l_x_return_status);

445: l_x_return_status,
446: x_msg_count,
447: x_msg_data);
448:
449: PA_SCHEDULE_UTILS.log_message(1, 'Insert_Row After apply_other_changes ....' || l_x_return_status);
450: PA_SCHEDULE_UTILS.log_message(1,'l_out_sch_rec_tab (change ) : ',l_out_sch_rec_tab );
451:
452:
453: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 450: PA_SCHEDULE_UTILS.log_message(1,'l_out_sch_rec_tab (change ) : ',l_out_sch_rec_tab );

446: x_msg_count,
447: x_msg_data);
448:
449: PA_SCHEDULE_UTILS.log_message(1, 'Insert_Row After apply_other_changes ....' || l_x_return_status);
450: PA_SCHEDULE_UTILS.log_message(1,'l_out_sch_rec_tab (change ) : ',l_out_sch_rec_tab );
451:
452:
453: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
454:

Line 459: PA_SCHEDULE_UTILS.log_message(1,'apply_other_changes retuned less count ');

455: IF l_out_sch_rec_tab.count < p_sch_record_tab.COUNT THEN
456: -- This condition will not happen since apply_other_changes will only append the change_type_code = D it will
457: -- not delete any record from p_sch_record_tab pl/sql table while generating l_out_sch_rec_tab
458: -- This has only been placed for debugging purposes in future to trap the error point in apply_other_changes
459: PA_SCHEDULE_UTILS.log_message(1,'apply_other_changes retuned less count ');
460: RAISE FND_API.G_EXC_ERROR;
461: ELSE
462: --Added for bug 5856987
463: l_schedule_id.delete;

Line 512: PA_SCHEDULE_UTILS.log_message(1,'l_x_return_status is not success ');

508:
509: END LOOP;
510: END IF;
511: ELSE
512: PA_SCHEDULE_UTILS.log_message(1,'l_x_return_status is not success ');
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: --- End of bug 5684828
516:

Line 577: PA_SCHEDULE_UTILS.log_message(1,'end of the schedule inser row .... ');

573: fnd_global.prog_appl_id () ,
574: fnd_global.conc_program_id() ,
575: trunc(sysdate) );
576:
577: PA_SCHEDULE_UTILS.log_message(1,'end of the schedule inser row .... ');
578:
579: EXCEPTION
580: WHEN FND_API.G_EXC_ERROR THEN --Added for bug 5684828
581: x_return_status := l_x_return_status;

Line 590: PA_SCHEDULE_UTILS.log_message(1,'ERROR ....'||sqlerrm);

586: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
587: p_procedure_name => 'insert_rows');
588: raise;
589:
590: PA_SCHEDULE_UTILS.log_message(1,'ERROR ....'||sqlerrm);
591: END insert_rows;
592:
593: -- This procedure will insert the record in pa_schedules table
594: -- Input parameters

Line 734: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');

730:
731: BEGIN
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');
735: if ( p_sch_record_tab.count = 0 ) then
736: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');
737: raise l_empty_tab_record;
738: end if;

Line 736: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');

732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: PA_SCHEDULE_UTILS.log_message(1,'start of the schedule inser row .... ');
735: if ( p_sch_record_tab.count = 0 ) then
736: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');
737: raise l_empty_tab_record;
738: end if;
739:
740: FOR J IN p_sch_record_tab.first..p_sch_record_tab.last LOOP

Line 742: PA_SCHEDULE_UTILS.log_message(1,' J '||to_char(J)||' sch_id '||to_char(p_sch_record_tab(J).schedule_id)

738: end if;
739:
740: FOR J IN p_sch_record_tab.first..p_sch_record_tab.last LOOP
741:
742: PA_SCHEDULE_UTILS.log_message(1,' J '||to_char(J)||' sch_id '||to_char(p_sch_record_tab(J).schedule_id)
743: || ' start_date '||p_sch_record_tab(J).start_date);
744: l_schrowid(J) := p_sch_record_tab(J).schrowid;
745: l_schedule_id(J) := p_sch_record_tab(J).schedule_id;
746: l_calendar_id(J) := p_sch_record_tab(J).calendar_id;

Line 761: PA_SCHEDULE_UTILS.log_message(1,' J '||to_char(J)||' l_sch_id '||to_char(l_schedule_id(J))||'start_date '|| to_char(l_start_date(J)));

757: l_friday_hours(J) := trunc(p_sch_record_tab(J).friday_hours, 2);
758: l_saturday_hours(J) := trunc(p_sch_record_tab(J).saturday_hours, 2);
759: l_sunday_hours(J) := trunc(p_sch_record_tab(J).sunday_hours, 2);
760:
761: PA_SCHEDULE_UTILS.log_message(1,' J '||to_char(J)||' l_sch_id '||to_char(l_schedule_id(J))||'start_date '|| to_char(l_start_date(J)));
762: END LOOP;
763:
764: FORALL J IN p_sch_record_tab.first..p_sch_record_tab.last
765: UPDATE PA_SCHEDULES

Line 788: PA_SCHEDULE_UTILS.log_message(1,'end of update row .... ');

784: last_update_by = fnd_global.user_id,
785: last_update_login = fnd_global.login_id
786: WHERE schedule_id = l_schedule_id(J);
787:
788: PA_SCHEDULE_UTILS.log_message(1,'end of update row .... ');
789: EXCEPTION
790: WHEN l_empty_tab_record THEN
791: NULL;
792: WHEN OTHERS THEN

Line 798: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update row '||sqlerrm);

794: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
795: p_procedure_name => 'update_rows');
796: raise;
797:
798: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update row '||sqlerrm);
799: END update_rows;
800:
801: -- This procedure will update the record in pa_schedules table
802: -- Input parameters

Line 966: PA_SCHEDULE_UTILS.log_message(1,'start of the delete row ..... ');

962:
963: BEGIN
964: x_return_status := FND_API.G_RET_STS_SUCCESS;
965:
966: PA_SCHEDULE_UTILS.log_message(1,'start of the delete row ..... ');
967: if ( p_sch_record_tab.count = 0 ) then
968: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');
969: raise l_empty_tab_record;
970: end if;

Line 968: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');

964: x_return_status := FND_API.G_RET_STS_SUCCESS;
965:
966: PA_SCHEDULE_UTILS.log_message(1,'start of the delete row ..... ');
967: if ( p_sch_record_tab.count = 0 ) then
968: PA_SCHEDULE_UTILS.log_message(1,'count 0 ... and returning ');
969: raise l_empty_tab_record;
970: end if;
971:
972: FOR J IN p_sch_record_tab.first..p_sch_record_tab.last LOOP

Line 973: PA_SCHEDULE_UTILS.log_message(1,' I : '||to_char(J)||' sch_id '||to_char(p_sch_record_tab(J).schedule_id));

969: raise l_empty_tab_record;
970: end if;
971:
972: FOR J IN p_sch_record_tab.first..p_sch_record_tab.last LOOP
973: PA_SCHEDULE_UTILS.log_message(1,' I : '||to_char(J)||' sch_id '||to_char(p_sch_record_tab(J).schedule_id));
974: l_schedule_id(J) := p_sch_record_tab(J).schedule_id;
975:
976: END LOOP;
977:

Line 981: PA_SCHEDULE_UTILS.log_message(1,'end of the delete row ..... ');

977:
978: FORALL J IN l_schedule_id.first..l_schedule_id.last
979: DELETE FROM PA_SCHEDULES WHERE schedule_id = l_schedule_id(J);
980:
981: PA_SCHEDULE_UTILS.log_message(1,'end of the delete row ..... ');
982: EXCEPTION
983: WHEN l_empty_tab_record THEN
984: NULL;
985: WHEN OTHERS THEN

Line 991: PA_SCHEDULE_UTILS.log_message(1,'ERROR in the delete row ..... '||sqlerrm);

987: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PKG',
988: p_procedure_name => 'delete_rows');
989: raise;
990:
991: PA_SCHEDULE_UTILS.log_message(1,'ERROR in the delete row ..... '||sqlerrm);
992: END delete_rows;
993:
994: -- This procedure will delete the record in pa_schedules table
995: -- Input parameters