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.IGS_PS_GEN_006 dependencies on FND_FILE

Line 44: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);

40: BEGIN
41: fnd_message.set_name('IGS','IGS_PS_DEL_PRIORITY_LOG');
42: fnd_message.set_token('PARAMETER_NAME', p_c_param_name );
43: fnd_message.set_token('PARAMETER_VAL' , p_c_param_value ) ;
44: fnd_file.put_line(fnd_file.LOG,FND_MESSAGE.GET);
45: END log_parameters ;
46:
47:
48: FUNCTION crsp_get_ucl_mode(

Line 418: fnd_file.put_line ( fnd_file.LOG, ' ' );

414: -- Log all the parameters passed. This has been added as part of Bug# 2550411 by shtatiko
415: l_start_dt := TO_DATE ( RTRIM(SUBSTR(p_source_cal, 12, 10)), 'DD/MM/YYYY' ) ;
416: l_end_dt := TO_DATE ( RTRIM(SUBSTR(p_source_cal, 23, 10)), 'DD/MM/YYYY' );
417:
418: fnd_file.put_line ( fnd_file.LOG, ' ' );
419: log_parameters ( p_c_param_name => igs_ge_gen_004.genp_get_lookup ( 'IGS_PS_LOG_PARAMETERS', 'SOURCE_CAL' ),
420: p_c_param_value => TO_CHAR ( l_start_dt, 'DD-MON-YYYY' ) || ' - ' ||
421: TO_CHAR ( l_end_dt, 'DD-MON-YYYY' ) || ' - ' ||
422: p_source_cal_type );

Line 435: fnd_file.put_line ( fnd_file.LOG, ' ' );

431:
432: log_parameters ( p_c_param_name => igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'ORG_UNIT_CD' ),
433: p_c_param_value => NVL(p_org_unit,'%') );
434:
435: fnd_file.put_line ( fnd_file.LOG, ' ' );
436: fnd_file.put_line ( fnd_file.LOG, ' ' );
437:
438: v_message := NULL;
439: v_uap_insert_error := FALSE;

Line 436: fnd_file.put_line ( fnd_file.LOG, ' ' );

432: log_parameters ( p_c_param_name => igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'ORG_UNIT_CD' ),
433: p_c_param_value => NVL(p_org_unit,'%') );
434:
435: fnd_file.put_line ( fnd_file.LOG, ' ' );
436: fnd_file.put_line ( fnd_file.LOG, ' ' );
437:
438: v_message := NULL;
439: v_uap_insert_error := FALSE;
440:

Line 507: fnd_file.put_line ( fnd_file.LOG, ' ');

503: FETCH gc_unit_offering_pattern INTO gv_uop_rec;
504: EXIT WHEN gc_unit_offering_pattern%NOTFOUND;
505:
506: -- This logging Unit information has been added as part of Bug# 2550411 by shtatiko
507: fnd_file.put_line ( fnd_file.LOG, ' ');
508: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
509: || ' : ' || gv_uop_rec.unit_cd );
510: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
511: || ' : ' || TO_CHAR (gv_uop_rec.version_number) );

Line 508: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )

504: EXIT WHEN gc_unit_offering_pattern%NOTFOUND;
505:
506: -- This logging Unit information has been added as part of Bug# 2550411 by shtatiko
507: fnd_file.put_line ( fnd_file.LOG, ' ');
508: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
509: || ' : ' || gv_uop_rec.unit_cd );
510: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
511: || ' : ' || TO_CHAR (gv_uop_rec.version_number) );
512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

Line 510: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )

506: -- This logging Unit information has been added as part of Bug# 2550411 by shtatiko
507: fnd_file.put_line ( fnd_file.LOG, ' ');
508: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
509: || ' : ' || gv_uop_rec.unit_cd );
510: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
511: || ' : ' || TO_CHAR (gv_uop_rec.version_number) );
512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
513: || ' : ' || p_dest_cal_type );
514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )

Line 512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )

508: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
509: || ' : ' || gv_uop_rec.unit_cd );
510: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
511: || ' : ' || TO_CHAR (gv_uop_rec.version_number) );
512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
513: || ' : ' || p_dest_cal_type );
514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );
516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )

Line 514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )

510: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )
511: || ' : ' || TO_CHAR (gv_uop_rec.version_number) );
512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
513: || ' : ' || p_dest_cal_type );
514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );
516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );
518: fnd_file.put_line ( fnd_file.LOG, ' ');

Line 516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )

512: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'CAL_TYPE' )
513: || ' : ' || p_dest_cal_type );
514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );
516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );
518: fnd_file.put_line ( fnd_file.LOG, ' ');
519:
520: -- Check that IGS_PS_UNIT version in not inactive, otherwise

Line 518: fnd_file.put_line ( fnd_file.LOG, ' ');

514: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'START_DT' )
515: || ' : ' || fnd_date.date_to_displaydate (gv_start_dt) );
516: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'END_DT' )
517: || ' : ' || fnd_date.date_to_displaydate (gv_end_dt) );
518: fnd_file.put_line ( fnd_file.LOG, ' ');
519:
520: -- Check that IGS_PS_UNIT version in not inactive, otherwise
521: -- it can't be updated
522: IF (igs_ps_val_unit.crsp_val_iud_uv_dtl( gv_uop_rec.unit_cd,

Line 536: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

532: IF (gc_check_dest_uo_exists%NOTFOUND) THEN
533: -- This message has been added as part of Bug# 2550411 by shtatiko to log more specific message in case
534: -- Destination Calendar is not defined for the current Unit.
535: fnd_message.set_name ( 'IGS', 'IGS_PS_NO_DEST_CAL_UNIT' );
536: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
537: ELSE
538: OPEN gc_check_uop_exists (gv_uop_rec.unit_cd,
539: gv_uop_rec.version_number);
540: FETCH gc_check_uop_exists INTO gv_check;

Line 561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

557:
558: gv_rec_inserted_cnt := gv_rec_inserted_cnt + 1;
559: -- This message has been added as part of Bug# 2550411 by shtatiko
560: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_SUCCESS' );
561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
562: ELSE
563: -- This message has been added as part of Bug# 2550411 by shtatiko
564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );
565: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

Line 565: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

561: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
562: ELSE
563: -- This message has been added as part of Bug# 2550411 by shtatiko
564: fnd_message.set_name ( 'IGS', 'IGS_PS_ROLL_UOP_EXISTS' );
565: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
566: END IF;
567: CLOSE gc_check_uop_exists;
568:
569: --Enhancement bug no 1800179

Line 584: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

580: -- This logging of message returned by the function has been added to log the
581: -- status of importing Unit Offering Pattern and other details. This has been done
582: -- as per Bug fix 2550411 by shtatiko
583: fnd_message.set_name ( 'IGS', gv_message );
584: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
585:
586: IF (gv_message = 'IGS_PS_NO_UOO_AND_UAI_ROLLED' OR
587: gv_message = 'IGS_PS_UOO_NO_UOO_TOBE_ROLLED' OR
588: gv_message = 'IGS_PS_UOO_NO_UAI_TOBE_ROLLED' OR

Line 611: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );

607: -- This logging of message returned by the function has been added to log the
608: -- status of importing Unit Offering Pattern and other details. This has been done
609: -- as per Bug fix 2550411 by shtatiko
610: fnd_message.set_name ( 'IGS', gv_message );
611: fnd_file.put_line ( fnd_file.LOG, ' ' || fnd_message.get );
612:
613: v_uoo_uai_error_flag := TRUE;
614: IF ( gv_message='IGS_PS_INV_NO_UOO_ROLLED' OR
615: gv_message = 'IGS_PS_INV_UOO_ROLLED' OR

Line 809: fnd_file.put_line ( fnd_file.LOG, ' ');

805: WHEN VALID THEN
806: COMMIT;
807: RETCODE:=0;
808: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
809: fnd_file.put_line ( fnd_file.LOG, ' ');
810: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
811: WHEN INVALID THEN
812: RETCODE:=2;
813: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)

Line 810: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );

806: COMMIT;
807: RETCODE:=0;
808: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
809: fnd_file.put_line ( fnd_file.LOG, ' ');
810: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
811: WHEN INVALID THEN
812: RETCODE:=2;
813: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
814: fnd_file.put_line ( fnd_file.LOG, ' ');

Line 814: fnd_file.put_line ( fnd_file.LOG, ' ');

810: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
811: WHEN INVALID THEN
812: RETCODE:=2;
813: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
814: fnd_file.put_line ( fnd_file.LOG, ' ');
815: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
816: WHEN OTHERS THEN
817: RETCODE:=2;
818: ROLLBACK;

Line 815: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );

811: WHEN INVALID THEN
812: RETCODE:=2;
813: -- Code has been changed to log the error message instead of assigning it to ERRBUF (Bug# 2550411)
814: fnd_file.put_line ( fnd_file.LOG, ' ');
815: fnd_file.put_line ( fnd_file.LOG, fnd_message.get_string('IGS',v_message) );
816: WHEN OTHERS THEN
817: RETCODE:=2;
818: ROLLBACK;
819: -- SQLERRM has been added as per Bug Fux 2550411