[Home] [Help]
996: IF p_start_dt IS NOT NULL AND p_end_dt IS NOT NULL THEN
997: IF p_start_dt > p_end_dt THEN
998: FND_MESSAGE.SET_NAME ('IGS','IGS_GE_INVALID_DATE');
999: IGS_GE_MSG_STACK.ADD;
1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001: END IF;
1002: END IF;
1003:
1004: IF p_mode='UPDATE' THEN
1536: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_DT_VAL_FAIL');
1537: FND_MESSAGE.SET_TOKEN ('DATE1',v_other_dt);
1538: FND_MESSAGE.SET_TOKEN ('DATE2',v_mar_dt);
1539: IGS_GE_MSG_STACK.ADD;
1540: APP_EXCEPTION.RAISE_EXCEPTION;
1541: END IF;
1542: END IF;
1543:
1544: OPEN get_dob_dt_cur(p_person_id);
1555: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_DT_VAL_FAIL');
1556: FND_MESSAGE.SET_TOKEN ('DATE1',v_mar_dt);
1557: FND_MESSAGE.SET_TOKEN ('DATE2',v_other_dt);
1558: IGS_GE_MSG_STACK.ADD;
1559: APP_EXCEPTION.RAISE_EXCEPTION;
1560: END IF;
1561: END IF;
1562:
1563: OPEN c_pe_stat(P_PERSON_ID);
2023:
2024: IF l_test_date > TRUNC(SYSDATE) THEN
2025: Fnd_Message.Set_Name ('IGS', 'IGS_SS_AD_SEG_NOT_IN_FUTURE');
2026: IGS_GE_MSG_STACK.ADD;
2027: App_Exception.Raise_Exception;
2028: END IF;
2029:
2030: igs_ad_tst_rslt_dtls_pkg.insert_row(
2031: X_ROWID => l_rowid,
2614:
2615: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SS_NO_PRIM_ADDR');
2616: FND_MESSAGE.SET_TOKEN('SUBJECT_NAME',l_sub_party_name);
2617: IGS_GE_MSG_STACK.ADD;
2618: App_Exception.Raise_Exception;
2619: END IF;
2620: END IF; --P_COPY_PRIMARY_ADDR = 'Y'
2621:
2622: IGS_PE_RELATIONSHIPS_PKG.CREATUPDATE_PARTY_RELATIONSHIP(
2845:
2846: FND_MESSAGE.SET_NAME('IGS','IGS_PE_SS_NO_PRIM_ADDR');
2847: FND_MESSAGE.SET_TOKEN('SUBJECT_NAME',l_sub_party_name);
2848: IGS_GE_MSG_STACK.ADD;
2849: App_Exception.Raise_Exception;
2850: ELSE
2851: CLOSE c_location;
2852: l_loc_exists := CHECK_DUPLICATE_LOC(
2853: p_country => rec_student_addr.COUNTRY_CD,