APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_VALIDATE_GENERIC_PKG

Line 341: igs_ps_validate_generic_pkg.validate_usec_rsvpri (p_usec_rsv_rec,l_n_uoo_id,l_insert_update);

337: END IF;
338:
339:
340: IF p_usec_rsv_rec.status = 'S' THEN
341: igs_ps_validate_generic_pkg.validate_usec_rsvpri (p_usec_rsv_rec,l_n_uoo_id,l_insert_update);
342:
343: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
344: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_res_seat.create_rsvpri.status_after_Business_validation',
345: 'Unit code:'||p_usec_rsv_rec.unit_cd||' '||'Version number:'||p_usec_rsv_rec.version_number||' '||'teach_cal_alternate_code:'

Line 653: igs_ps_validate_generic_pkg.validate_usec_rsvprf (p_usec_rsv_rec,l_insert_update);

649: END IF;
650:
651:
652: IF p_usec_rsv_rec.status = 'S' THEN
653: igs_ps_validate_generic_pkg.validate_usec_rsvprf (p_usec_rsv_rec,l_insert_update);
654:
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_res_seat.create_rsvprf.status_after_Business_validation',
657: 'Unit code:'||p_usec_rsv_rec.unit_cd||' '||'Version number:'||p_usec_rsv_rec.version_number||' '||'teach_cal_alternate_code:'

Line 811: IF NOT igs_ps_validate_generic_pkg.post_usec_rsv(p_usec_res_seat_tbl,l_tbl_uoo) THEN

807: END IF;--exists
808: END LOOP;
809:
810: /* Post Insert/Update Checks */
811: IF NOT igs_ps_validate_generic_pkg.post_usec_rsv(p_usec_res_seat_tbl,l_tbl_uoo) THEN
812: p_c_rec_status := 'E';
813: END IF;
814:
815: l_tbl_uoo.DELETE;

Line 1048: igs_ps_validate_generic_pkg.validate_facility ( p_usec_occurs_facility_tbl(I),l_n_uoo_id,l_n_uso_id,p_calling_context) ;

1044:
1045: /* Business Validations */
1046: /* Proceed with business validations only if the status is Success, 'S' */
1047: IF p_usec_occurs_facility_tbl(I).status = 'S' THEN
1048: igs_ps_validate_generic_pkg.validate_facility ( p_usec_occurs_facility_tbl(I),l_n_uoo_id,l_n_uso_id,p_calling_context) ;
1049:
1050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1051: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_uso_facility.status_after_Business_validations',
1052: 'Unit code:'||p_usec_occurs_facility_tbl(I).unit_cd||' '||'Version number:'||p_usec_occurs_facility_tbl(I).version_number||' '||'teach_cal_alternate_code:'

Line 1316: igs_ps_validate_generic_pkg.validate_category( p_usec_cat_tbl(I),l_n_uoo_id ) ;

1312:
1313: /* Proceed with business validations only if the status is Success, 'S' */
1314: IF p_usec_cat_tbl(I).status = 'S' THEN
1315: /* Validation# 1: Check for the closed_ind for UNIT_CAT */
1316: igs_ps_validate_generic_pkg.validate_category( p_usec_cat_tbl(I),l_n_uoo_id ) ;
1317:
1318: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1319: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_cat.status_after_Business_Validation',
1320: 'Unit code:'||p_usec_cat_tbl(I).unit_cd||' '||'Version number:'||p_usec_cat_tbl(I).version_number||' '||'teach_cal_alternate_code:'

Line 1734: igs_ps_validate_generic_pkg.validate_tch_rsp_ovrd ( p_usec_teach_resp_ovrd_tbl(I),l_n_uoo_id );

1730:
1731: /* Business Validations */
1732: /* Proceed with business validations only if the status is Success, 'S' */
1733: IF p_usec_teach_resp_ovrd_tbl(I).status = 'S' THEN
1734: igs_ps_validate_generic_pkg.validate_tch_rsp_ovrd ( p_usec_teach_resp_ovrd_tbl(I),l_n_uoo_id );
1735:
1736: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1737: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_teach_resp_ovrd.status_after_Business_validation',
1738: 'Unit code:'||p_usec_teach_resp_ovrd_tbl(I).unit_cd||' '||'Version number:'||p_usec_teach_resp_ovrd_tbl(I).version_number||' '||'teach_cal_alternate_code:'

Line 1878: IF NOT igs_ps_validate_generic_pkg.post_tch_rsp_ovrd (p_usec_teach_resp_ovrd_tbl,l_tbl_uoo) THEN

1874: END IF;--exists
1875: END LOOP;
1876:
1877: /* Post Insert/Update Checks */
1878: IF NOT igs_ps_validate_generic_pkg.post_tch_rsp_ovrd (p_usec_teach_resp_ovrd_tbl,l_tbl_uoo) THEN
1879: p_c_rec_status := 'E';
1880: END IF;
1881: l_tbl_uoo.DELETE;
1882:

Line 2300: igs_ps_validate_generic_pkg.validate_as_us_ai_group(p_as_us_ai_group_rec, l_n_uoo_id);

2296:
2297: END IF;
2298:
2299: IF p_as_us_ai_group_rec.status = 'S' THEN
2300: igs_ps_validate_generic_pkg.validate_as_us_ai_group(p_as_us_ai_group_rec, l_n_uoo_id);
2301:
2302: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2303: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_ass_item_grp.create_group.status_after_Business_validation',
2304: 'Unit code:'||p_as_us_ai_group_rec.unit_cd||' '||'Version number:'||p_as_us_ai_group_rec.version_number||' '||'teach_cal_alternate_code:'

Line 2858: igs_ps_validate_generic_pkg.validate_unitass_item (p_unitass_item_rec, l_c_cal_type ,l_n_seq_num ,l_n_uoo_id,l_insert_update);

2854:
2855: END IF;
2856:
2857: IF p_unitass_item_rec.status = 'S' THEN
2858: igs_ps_validate_generic_pkg.validate_unitass_item (p_unitass_item_rec, l_c_cal_type ,l_n_seq_num ,l_n_uoo_id,l_insert_update);
2859:
2860: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2861: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_ass_item_grp.create_item.Status_after_Business_validation',
2862: 'Unit code:'||p_unitass_item_rec.unit_cd||' '||'Version number:'||p_unitass_item_rec.version_number||' '||'teach_cal_alternate_code:'

Line 3050: IF NOT igs_ps_validate_generic_pkg.post_as_us_ai(p_usec_ass_item_grp_tbl,l_tbl_uoo) THEN

3046: END IF;--exists
3047: END LOOP;
3048:
3049: /* Post Insert/Update Checks */
3050: IF NOT igs_ps_validate_generic_pkg.post_as_us_ai(p_usec_ass_item_grp_tbl,l_tbl_uoo) THEN
3051: p_c_rec_status := 'E';
3052: END IF;
3053:
3054: l_tbl_uoo.DELETE;

Line 3369: igs_ps_validate_generic_pkg.validate_uso_cm_grp(p_uso_cm_grp_rec, l_c_cal_type,l_n_seq_num,l_insert_update,class_meet_rec);

3365:
3366: END IF;
3367:
3368: IF p_uso_cm_grp_rec.status = 'S' THEN
3369: igs_ps_validate_generic_pkg.validate_uso_cm_grp(p_uso_cm_grp_rec, l_c_cal_type,l_n_seq_num,l_insert_update,class_meet_rec);
3370:
3371: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3372: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_meet_with.create_uso_cm_grp.status_after_Business_validation',
3373: 'Unit code:'||p_uso_cm_grp_rec.unit_cd||' '||'Version number:'||p_uso_cm_grp_rec.version_number||' '||'teach_cal_alternate_code:'

Line 3650: igs_ps_validate_generic_pkg.validate_uso_clas_meet(p_uso_clas_meet_rec,l_n_uoo_id,l_n_class_meet_group_id,l_c_cal_type,l_n_seq_num);

3646: END IF;
3647:
3648:
3649: IF p_uso_clas_meet_rec.status = 'S' THEN
3650: igs_ps_validate_generic_pkg.validate_uso_clas_meet(p_uso_clas_meet_rec,l_n_uoo_id,l_n_class_meet_group_id,l_c_cal_type,l_n_seq_num);
3651:
3652: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3653: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_meet_with.create_uso_clas_meet.status_after_Business_validation',
3654: 'Unit code:'||p_uso_clas_meet_rec.unit_cd||' '||'Version number:'||p_uso_clas_meet_rec.version_number||' '||'teach_cal_alternate_code:'

Line 3801: IF NOT igs_ps_validate_generic_pkg.post_usec_meet_with(p_usec_meet_with_tbl,class_meet_tab) THEN

3797: END LOOP;
3798:
3799:
3800: /* Post Insert/Update Checks */
3801: IF NOT igs_ps_validate_generic_pkg.post_usec_meet_with(p_usec_meet_with_tbl,class_meet_tab) THEN
3802: p_c_rec_status := 'E';
3803: END IF;
3804:
3805: class_meet_tab.DELETE;

Line 4118: igs_ps_validate_generic_pkg.validate_usec_x_grp(p_usec_x_grp_rec, l_c_cal_type,l_n_seq_num,l_insert_update,cross_group_rec);

4114:
4115: END IF;
4116:
4117: IF p_usec_x_grp_rec.status = 'S' THEN
4118: igs_ps_validate_generic_pkg.validate_usec_x_grp(p_usec_x_grp_rec, l_c_cal_type,l_n_seq_num,l_insert_update,cross_group_rec);
4119:
4120: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4121: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_cross_group.create_usec_x_grp.status_after_Business_validation',
4122: 'Unit code:'||p_usec_x_grp_rec.unit_cd||' '||'Version number:'||p_usec_x_grp_rec.version_number||' '||'teach_cal_alternate_code:'

Line 4408: igs_ps_validate_generic_pkg.validate_usec_x_grpmem(p_usec_x_grpmem,l_n_uoo_id,l_n_usec_x_listed_group_id,l_c_cal_type,l_n_seq_num);

4404:
4405: END IF;
4406:
4407: IF p_usec_x_grpmem.status = 'S' THEN
4408: igs_ps_validate_generic_pkg.validate_usec_x_grpmem(p_usec_x_grpmem,l_n_uoo_id,l_n_usec_x_listed_group_id,l_c_cal_type,l_n_seq_num);
4409:
4410: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4411: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_cross_group.create_usec_x_grpmem.status_after_Business_validation',
4412: 'Unit code:'||p_usec_x_grpmem.unit_cd||' '||'Version number:'||p_usec_x_grpmem.version_number||' '||'teach_cal_alternate_code:'

Line 4559: IF NOT igs_ps_validate_generic_pkg.post_usec_cross_group(p_usec_cross_group_tbl,cross_group_tab) THEN

4555: END IF;--exists
4556: END LOOP;
4557:
4558: /* Post Insert/Update Checks */
4559: IF NOT igs_ps_validate_generic_pkg.post_usec_cross_group(p_usec_cross_group_tbl,cross_group_tab) THEN
4560: p_c_rec_status := 'E';
4561: END IF;
4562:
4563: cross_group_tab.DELETE;

Line 4852: igs_ps_validate_generic_pkg.validate_usec_wlstpri (p_usec_wlst_rec,l_n_uoo_id,l_insert_update);

4848:
4849: END IF;
4850:
4851: IF p_usec_wlst_rec.status = 'S' THEN
4852: igs_ps_validate_generic_pkg.validate_usec_wlstpri (p_usec_wlst_rec,l_n_uoo_id,l_insert_update);
4853: END IF;
4854:
4855: IF p_usec_wlst_rec.status = 'S' THEN
4856: IF l_insert_update = 'I' THEN

Line 5124: igs_ps_validate_generic_pkg.validate_usec_wlstprf(p_usec_wlst_rec,l_insert_update);

5120:
5121: END IF;
5122:
5123: IF p_usec_wlst_rec.status = 'S' THEN
5124: igs_ps_validate_generic_pkg.validate_usec_wlstprf(p_usec_wlst_rec,l_insert_update);
5125:
5126: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5127: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_waitlist.create_wlstprf.status_after_Business_validation',
5128: 'Unit code:'||p_usec_wlst_rec.unit_cd||' '||'Version number:'||p_usec_wlst_rec.version_number||' '||'teach_cal_alternate_code:'

Line 5281: IF NOT igs_ps_validate_generic_pkg.post_usec_wlst(p_usec_waitlist_tbl,l_tbl_uoo) THEN

5277: END IF;--exists
5278: END LOOP;
5279:
5280: /* Post Insert/Update Checks */
5281: IF NOT igs_ps_validate_generic_pkg.post_usec_wlst(p_usec_waitlist_tbl,l_tbl_uoo) THEN
5282: p_c_rec_status := 'E';
5283: END IF;
5284: l_tbl_uoo.DELETE;
5285:

Line 5548: igs_ps_validate_generic_pkg.validate_usec_notes ( p_usec_notes_tbl(I),l_n_uoo_id );

5544:
5545: /* Business Validations */
5546: /* Proceed with business validations only if the status is Success, 'S' */
5547: IF p_usec_notes_tbl(I).status = 'S' THEN
5548: igs_ps_validate_generic_pkg.validate_usec_notes ( p_usec_notes_tbl(I),l_n_uoo_id );
5549:
5550: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5551: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_notes.status_after_validate_usec_notes',
5552: 'Unit code:'||p_usec_notes_tbl(I).unit_cd||' '||'Version number:'||p_usec_notes_tbl(I).version_number||' '||'teach_cal_alternate_code:'

Line 6096: igs_ps_validate_generic_pkg.validate_usec_assmnt ( p_usec_assmnt_tbl(I),l_n_uoo_id,l_d_exam_start_time,l_d_exam_end_time,l_n_building_id,l_n_room_id,l_insert_update);

6092:
6093: /* Business Validations */
6094: /* Proceed with business validations only if the status is Success, 'S' */
6095: IF p_usec_assmnt_tbl(I).status = 'S' THEN
6096: igs_ps_validate_generic_pkg.validate_usec_assmnt ( p_usec_assmnt_tbl(I),l_n_uoo_id,l_d_exam_start_time,l_d_exam_end_time,l_n_building_id,l_n_room_id,l_insert_update);
6097:
6098: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6099: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_create_generic_pkg.create_usec_assmnt.status_after_Business_validation',
6100: 'Unit code:'||p_usec_assmnt_tbl(I).unit_cd||' '||'Version number:'||p_usec_assmnt_tbl(I).version_number||' '||'teach_cal_alternate_code:'