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_UNIT_LGCY_PKG dependencies on IGS_PS_USEC_OCCURS_PKG

Line 6300: igs_ps_usec_occurs_pkg.check_constraints ( 'NO_SET_DAY_IND', p_uso_rec.no_set_day_ind );

6296:
6297: -- Following validation added as part of bug#2972950 for the PSP Scheduling Enhancements TD
6298: -- If No Set Day Indicator is not NULL then it should have a value of either of 'Y' or 'N'
6299: BEGIN
6300: igs_ps_usec_occurs_pkg.check_constraints ( 'NO_SET_DAY_IND', p_uso_rec.no_set_day_ind );
6301: EXCEPTION
6302: WHEN OTHERS THEN
6303: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'NO_SET_DAY_IND', 'LEGACY_TOKENS', TRUE);
6304: p_uso_rec.status := 'E';

Line 6308: igs_ps_usec_occurs_pkg.check_constraints ( 'TO_BE_ANNOUNCED', p_uso_rec.to_be_announced );

6304: p_uso_rec.status := 'E';
6305: END;
6306:
6307: BEGIN
6308: igs_ps_usec_occurs_pkg.check_constraints ( 'TO_BE_ANNOUNCED', p_uso_rec.to_be_announced );
6309: EXCEPTION
6310: WHEN OTHERS THEN
6311: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'TO_BE_ANNOUNCED', 'LEGACY_TOKENS', TRUE);
6312: p_uso_rec.status := 'E';

Line 6316: igs_ps_usec_occurs_pkg.check_constraints ( 'MONDAY', p_uso_rec.monday );

6312: p_uso_rec.status := 'E';
6313: END;
6314:
6315: BEGIN
6316: igs_ps_usec_occurs_pkg.check_constraints ( 'MONDAY', p_uso_rec.monday );
6317: EXCEPTION
6318: WHEN OTHERS THEN
6319: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'MONDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6320: p_uso_rec.status := 'E';

Line 6324: igs_ps_usec_occurs_pkg.check_constraints ( 'TUESDAY', p_uso_rec.tuesday );

6320: p_uso_rec.status := 'E';
6321: END;
6322:
6323: BEGIN
6324: igs_ps_usec_occurs_pkg.check_constraints ( 'TUESDAY', p_uso_rec.tuesday );
6325: EXCEPTION
6326: WHEN OTHERS THEN
6327: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'TUESDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6328: p_uso_rec.status := 'E';

Line 6332: igs_ps_usec_occurs_pkg.check_constraints ( 'WEDNESDAY', p_uso_rec.wednesday );

6328: p_uso_rec.status := 'E';
6329: END;
6330:
6331: BEGIN
6332: igs_ps_usec_occurs_pkg.check_constraints ( 'WEDNESDAY', p_uso_rec.wednesday );
6333: EXCEPTION
6334: WHEN OTHERS THEN
6335: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'WEDNESDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6336: p_uso_rec.status := 'E';

Line 6340: igs_ps_usec_occurs_pkg.check_constraints ( 'THURSDAY', p_uso_rec.thursday );

6336: p_uso_rec.status := 'E';
6337: END;
6338:
6339: BEGIN
6340: igs_ps_usec_occurs_pkg.check_constraints ( 'THURSDAY', p_uso_rec.thursday );
6341: EXCEPTION
6342: WHEN OTHERS THEN
6343: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'THURSDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6344: p_uso_rec.status := 'E';

Line 6348: igs_ps_usec_occurs_pkg.check_constraints ( 'FRIDAY', p_uso_rec.friday );

6344: p_uso_rec.status := 'E';
6345: END;
6346:
6347: BEGIN
6348: igs_ps_usec_occurs_pkg.check_constraints ( 'FRIDAY', p_uso_rec.friday );
6349: EXCEPTION
6350: WHEN OTHERS THEN
6351: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'FRIDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6352: p_uso_rec.status := 'E';

Line 6356: igs_ps_usec_occurs_pkg.check_constraints ( 'SATURDAY', p_uso_rec.saturday );

6352: p_uso_rec.status := 'E';
6353: END;
6354:
6355: BEGIN
6356: igs_ps_usec_occurs_pkg.check_constraints ( 'SATURDAY', p_uso_rec.saturday );
6357: EXCEPTION
6358: WHEN OTHERS THEN
6359: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'SATURDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6360: p_uso_rec.status := 'E';

Line 6364: igs_ps_usec_occurs_pkg.check_constraints ( 'SUNDAY', p_uso_rec.sunday );

6360: p_uso_rec.status := 'E';
6361: END;
6362:
6363: BEGIN
6364: igs_ps_usec_occurs_pkg.check_constraints ( 'SUNDAY', p_uso_rec.sunday );
6365: EXCEPTION
6366: WHEN OTHERS THEN
6367: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N', 'SUNDAY', 'DT_OFFSET_CONSTRAINT_TYPE', TRUE);
6368: p_uso_rec.status := 'E';

Line 6374: IF igs_ps_usec_occurs_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id ,

6370:
6371:
6372: IF p_insert = 'I' THEN
6373: /* Unique Key Validation */
6374: IF igs_ps_usec_occurs_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id ,
6375: x_occurrence_identifier => p_uso_rec.occurrence_identifier
6376: ) THEN
6377: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_OCCRS_ID', 'IGS_PS_LOG_PARAMETERS', FALSE);
6378: p_uso_rec.status := 'W';

Line 7767: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation(l_n_uso_id) THEN

7763: END IF;
7764: CLOSE c_res_flag;
7765:
7766: -- Foreign Key Validation : Unit Section Occurrence doesn't exists
7767: IF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation(l_n_uso_id) THEN
7768: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'USEC_OCCUR','LEGACY_TOKENS', FALSE);
7769: p_ref_cd_rec.status := 'E';
7770: END IF;
7771:

Line 8459: IF igs_ps_usec_occurs_pkg.get_pk_for_validation(p_uso_ins_rec.production_uso_id) THEN

8455:
8456: -- if the production unit section occurrence identifier is provided then validate it
8457: -- otherwise derive the production unit section occurrence identifier.
8458: IF p_uso_ins_rec.production_uso_id IS NOT NULL THEN
8459: IF igs_ps_usec_occurs_pkg.get_pk_for_validation(p_uso_ins_rec.production_uso_id) THEN
8460: l_n_uso_id := p_uso_ins_rec.production_uso_id;
8461: -- Also derive the unit section identifier uoo_id for the the unit section occurrence identifier
8462: OPEN c_uoo_id(l_n_uso_id);
8463: FETCH c_uoo_id INTO l_n_uoo_id;