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_RE_THE_LGCY_PUB dependencies on IGS_RE_THESIS

Line 57: igs_re_thesis_pkg.check_constraints('final_title_ind',p_the_dtls_rec.final_title_ind);

53:
54: --check constraint for final_title_ind, it should be 'Y' or 'N'
55: IF p_the_dtls_rec.final_title_ind IS NOT NULL THEN
56: BEGIN
57: igs_re_thesis_pkg.check_constraints('final_title_ind',p_the_dtls_rec.final_title_ind);
58: EXCEPTION
59: WHEN OTHERS THEN
60: l_msg_count := FND_MSG_PUB.COUNT_MSG;
61: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

Line 71: igs_re_thesis_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.final_thesis_result_cd);

67:
68: --Check constraint for the final thesis result code
69: IF p_the_dtls_rec.final_thesis_result_cd IS NOT NULL THEN
70: BEGIN
71: igs_re_thesis_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.final_thesis_result_cd);
72: EXCEPTION
73: WHEN OTHERS THEN
74: l_msg_count := FND_MSG_PUB.COUNT_MSG;
75: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

Line 85: igs_re_thesis_exam_pkg.check_constraints('thesis_exam_type',p_the_dtls_rec.thesis_exam_type);

81:
82: --Check constraint for thesis exam type
83: IF p_the_dtls_rec.thesis_exam_type IS NOT NULL THEN
84: BEGIN
85: igs_re_thesis_exam_pkg.check_constraints('thesis_exam_type',p_the_dtls_rec.thesis_exam_type);
86: EXCEPTION
87: WHEN OTHERS THEN
88: l_msg_count := FND_MSG_PUB.COUNT_MSG;
89: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

Line 99: igs_re_thesis_exam_pkg.check_constraints('thesis_panel_type',p_the_dtls_rec.thesis_panel_type);

95:
96: --Check constraint for the Thesis Panel Type parameter
97: IF p_the_dtls_rec.thesis_panel_type IS NOT NULL THEN
98: BEGIN
99: igs_re_thesis_exam_pkg.check_constraints('thesis_panel_type',p_the_dtls_rec.thesis_panel_type);
100: EXCEPTION
101: WHEN OTHERS THEN
102: l_msg_count := FND_MSG_PUB.COUNT_MSG;
103: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

Line 113: igs_re_thesis_exam_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.thesis_result_cd);

109:
110: --Check Constraint for the thesis result code
111: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
112: BEGIN
113: igs_re_thesis_exam_pkg.check_constraints('thesis_result_cd',p_the_dtls_rec.thesis_result_cd);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_msg_count := FND_MSG_PUB.COUNT_MSG;
117: FND_MSG_PUB.DELETE_MSG (p_msg_index => l_msg_count);

Line 156: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (

152: END IF;
153:
154: -- FK check in the Thesis Result table
155: IF p_the_dtls_rec.final_thesis_result_cd IS NOT NULL THEN
156: IF NOT IGS_RE_THESIS_RESULT_PKG.Get_PK_For_Validation (
157: p_the_dtls_rec.final_thesis_result_cd ) THEN
158: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_RESULT_CD_INVALID_VAL');
159: FND_MSG_PUB.ADD;
160: l_ret_status := 'E';

Line 356: --FK check to the table igs_re_thesis_result for the field thesis_result_cd

352: l_ret_status := 'E';
353: END IF;
354: END IF;
355:
356: --FK check to the table igs_re_thesis_result for the field thesis_result_cd
357: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
358: IF NOT igs_re_thesis_result_pkg.get_pk_for_validation (
359: p_the_dtls_rec.thesis_result_cd ) THEN
360: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_THE_RES_CD_INV');

Line 358: IF NOT igs_re_thesis_result_pkg.get_pk_for_validation (

354: END IF;
355:
356: --FK check to the table igs_re_thesis_result for the field thesis_result_cd
357: IF p_the_dtls_rec.thesis_result_cd IS NOT NULL THEN
358: IF NOT igs_re_thesis_result_pkg.get_pk_for_validation (
359: p_the_dtls_rec.thesis_result_cd ) THEN
360: FND_MESSAGE.SET_NAME ('IGS', 'IGS_RE_THE_RES_CD_INV');
361: FND_MSG_PUB.ADD;
362: l_ret_status := 'E';

Line 464: SELECT IGS_RE_THESIS_SEQ_NUM_S.NEXTVAL

460: || Otherwise Insert only the Thesis Details Record, skip the Thesis Exam record.
461: */
462:
463: CURSOR c_the_seq_num IS
464: SELECT IGS_RE_THESIS_SEQ_NUM_S.NEXTVAL
465: FROM DUAL;
466: l_the_seq_num igs_re_thesis_all.sequence_number%TYPE;
467:
468: l_api_name CONSTANT VARCHAR2(30) := 'Thesis Details';

Line 466: l_the_seq_num igs_re_thesis_all.sequence_number%TYPE;

462:
463: CURSOR c_the_seq_num IS
464: SELECT IGS_RE_THESIS_SEQ_NUM_S.NEXTVAL
465: FROM DUAL;
466: l_the_seq_num igs_re_thesis_all.sequence_number%TYPE;
467:
468: l_api_name CONSTANT VARCHAR2(30) := 'Thesis Details';
469: l_api_version CONSTANT NUMBER := 1.0;
470: l_the_exam_status VARCHAR2(15) := 'VALID';

Line 471: l_person_id igs_re_thesis.person_id%TYPE := NULL;

467:
468: l_api_name CONSTANT VARCHAR2(30) := 'Thesis Details';
469: l_api_version CONSTANT NUMBER := 1.0;
470: l_the_exam_status VARCHAR2(15) := 'VALID';
471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;

Line 473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;

469: l_api_version CONSTANT NUMBER := 1.0;
470: l_the_exam_status VARCHAR2(15) := 'VALID';
471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:

Line 474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;

470: l_the_exam_status VARCHAR2(15) := 'VALID';
471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:
478: BEGIN

Line 475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;

471: l_person_id igs_re_thesis.person_id%TYPE := NULL;
472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:
478: BEGIN
479: -- Standard Start of API savepoint

Line 476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;

472: l_ca_sequence_number igs_re_candidature_all.sequence_number%TYPE;
473: l_creation_dt igs_re_thesis_exam.creation_dt%TYPE := SYSDATE;
474: l_last_update_date igs_re_thesis_all.creation_date%TYPE;
475: l_last_updated_by igs_re_thesis_all.last_updated_by%TYPE;
476: l_last_update_login igs_re_thesis_all.last_update_login%TYPE;
477:
478: BEGIN
479: -- Standard Start of API savepoint
480: SAVEPOINT THEDET_PUB;

Line 564: INSERT INTO igs_re_thesis_all (

560: CLOSE c_the_seq_num;
561:
562: BEGIN
563: --insert data into Thesis Details table
564: INSERT INTO igs_re_thesis_all (
565: PERSON_ID,
566: CA_SEQUENCE_NUMBER,
567: SEQUENCE_NUMBER,
568: TITLE,

Line 647: INSERT INTO igs_re_thesis_exam (

643:
644: IF l_the_exam_status <> 'INVALID' THEN --3rd level IF clause starts here
645: BEGIN
646: --insert data into thesis exam table
647: INSERT INTO igs_re_thesis_exam (
648: PERSON_ID,
649: CA_SEQUENCE_NUMBER,
650: THE_SEQUENCE_NUMBER,
651: CREATION_DT,