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_008 dependencies on IGS_GE_S_LOG

Line 2471: CURSOR cur_check(cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE) IS

2467: -------------------------------------------------------------------------------------------------------------------------------------
2468:
2469:
2470: --This cursor added by sarakshi,bug#2332807
2471: CURSOR cur_check(cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE) IS
2472: SELECT 'X'
2473: FROM igs_ge_s_log_entry
2474: WHERE s_log_type='USEC-ROLL'
2475: AND creation_dt=cp_creation_dt;

Line 2473: FROM igs_ge_s_log_entry

2469:
2470: --This cursor added by sarakshi,bug#2332807
2471: CURSOR cur_check(cp_creation_dt igs_ge_s_log_entry.creation_dt%TYPE) IS
2472: SELECT 'X'
2473: FROM igs_ge_s_log_entry
2474: WHERE s_log_type='USEC-ROLL'
2475: AND creation_dt=cp_creation_dt;
2476:
2477:

Line 2479: CURSOR cur_check_log(cp_creation_dt igs_ge_s_log.creation_dt%TYPE) IS

2475: AND creation_dt=cp_creation_dt;
2476:
2477:
2478: --This cursor added by jbegum for Bug#2563596
2479: CURSOR cur_check_log(cp_creation_dt igs_ge_s_log.creation_dt%TYPE) IS
2480: SELECT rowid
2481: FROM igs_ge_s_log
2482: WHERE s_log_type='USEC-ROLL'
2483: AND creation_dt=cp_creation_dt;

Line 2481: FROM igs_ge_s_log

2477:
2478: --This cursor added by jbegum for Bug#2563596
2479: CURSOR cur_check_log(cp_creation_dt igs_ge_s_log.creation_dt%TYPE) IS
2480: SELECT rowid
2481: FROM igs_ge_s_log
2482: WHERE s_log_type='USEC-ROLL'
2483: AND creation_dt=cp_creation_dt;
2484:
2485: l_var VARCHAR2(1);

Line 2616: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which

2612: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
2613:
2614: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
2615: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', l_message_name)
2616: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
2617: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
2618: -- Also the concatenated string being passed to parameter p_text has only l_message_name concatenated to it instead of
2619: -- FND_MESSAGE.GET_STRING('IGS', l_message_name)
2620:

Line 3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being

3110: CLOSE c_uop_dest_rec;
3111:
3112: -- Added by jbegum as part of bug #2563596
3113: -- The package IGS_PS_GEN_006 has a call to IGS_PS_GEN_008.crsp_ins_uop_uoo.Before this call in the package IGS_PS_GEN_006
3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being
3115: -- passed to the call of IGS_PS_GEN_008.crsp_ins_uop_uoo.Hence added code here to check for existence of the record in
3116: -- igs_ge_s_log table before inserting into it.Thus preventing the error 'Record already exists' being thrown up as unhandled
3117: -- exception by the procedure IGS_PS_GEN_006.crsp_ins_ci_uop_uoo
3118:

Line 3116: -- igs_ge_s_log table before inserting into it.Thus preventing the error 'Record already exists' being thrown up as unhandled

3112: -- Added by jbegum as part of bug #2563596
3113: -- The package IGS_PS_GEN_006 has a call to IGS_PS_GEN_008.crsp_ins_uop_uoo.Before this call in the package IGS_PS_GEN_006
3114: -- an insert is happening into igs_ge_s_log table thru a call to IGS_GE_GEN_003.genp_ins_log.The same creation date is being
3115: -- passed to the call of IGS_PS_GEN_008.crsp_ins_uop_uoo.Hence added code here to check for existence of the record in
3116: -- igs_ge_s_log table before inserting into it.Thus preventing the error 'Record already exists' being thrown up as unhandled
3117: -- exception by the procedure IGS_PS_GEN_006.crsp_ins_ci_uop_uoo
3118:
3119:
3120: OPEN cur_check_log(p_log_creation_date);

Line 3125: --If any error condition occurs , from the exception handlers we are inserting to igs_ge_s_log_entry table

3121: FETCH cur_check_log INTO l_var_log;
3122: IF cur_check_log%NOTFOUND THEN
3123:
3124: --Added by sarakshi, as a part of bug#2332807
3125: --If any error condition occurs , from the exception handlers we are inserting to igs_ge_s_log_entry table
3126: --which is child table so here inserting in the parent table first which is to be deleted if no child
3127: --entries are found
3128: igs_ge_s_log_pkg.insert_row( x_rowid => l_rowid ,
3129: x_s_log_type => 'USEC-ROLL',

Line 3128: igs_ge_s_log_pkg.insert_row( x_rowid => l_rowid ,

3124: --Added by sarakshi, as a part of bug#2332807
3125: --If any error condition occurs , from the exception handlers we are inserting to igs_ge_s_log_entry table
3126: --which is child table so here inserting in the parent table first which is to be deleted if no child
3127: --entries are found
3128: igs_ge_s_log_pkg.insert_row( x_rowid => l_rowid ,
3129: x_s_log_type => 'USEC-ROLL',
3130: x_creation_dt =>p_log_creation_date,
3131: x_key =>NULL,
3132: x_mode => 'R' );

Line 3827: igs_ge_s_log_pkg.delete_row(x_rowid=>l_rowid);

3823: --then delete the parent record.
3824: OPEN cur_check(p_log_creation_date);
3825: FETCH cur_check INTO l_var;
3826: IF cur_check%NOTFOUND THEN
3827: igs_ge_s_log_pkg.delete_row(x_rowid=>l_rowid);
3828: END IF;
3829: CLOSE cur_check;
3830:
3831: RETURN v_ret_val;

Line 3858: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which

3854: END;
3855:
3856: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
3857: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', p_message_name)
3858: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which
3859: -- was in turn causing function IGS_PS_GEN_008.crsp_ins_uop_uoo to throw up an unhandled exception.
3860: -- Also the concatenated string being passed to parameter p_text has only p_message_name concatenated to it instead of
3861: -- FND_MESSAGE.GET_STRING('IGS', p_message_name)
3862: