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_AD_IMP_003 dependencies on IGS_AD_GEN_016

Line 77: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

73: l_msg_at_index NUMBER := 0;
74: l_return_status VARCHAR2(1);
75: l_msg_count NUMBER;
76: l_msg_data VARCHAR2(2000);
77: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
78:
79: l_prog_label VARCHAR2(100);
80: p_error_code VARCHAR2(30);
81: p_status VARCHAR2(1);

Line 114: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

110:
111: fnd_log.string_with_context( fnd_log.level_procedure, l_label,l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
112: END IF;
113:
114: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
115:
116: UPDATE igs_ad_acadint_int a
117: SET status = '3',
118: error_code = 'E678',

Line 128: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E420', 8405);

124: WHERE b.person_id = a.person_id
125: AND b.admission_appl_number = a.admission_appl_number
126: AND b.field_of_study = a.field_of_study );
127:
128: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E420', 8405);
129:
130: UPDATE igs_ad_acadint_int a
131: SET status = '3',
132: error_code = 'E420',

Line 146: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => c_acadint_rec.admission_application_type,

142: BEGIN
143:
144: SAVEPOINT acadint_save;
145:
146: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => c_acadint_rec.admission_application_type,
147: p_admission_cat => l_admission_cat,
148: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
149:
150: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 150: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

146: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => c_acadint_rec.admission_application_type,
147: p_admission_cat => l_admission_cat,
148: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
149:
150: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
151: p_s_admission_process_type => l_s_admission_process_type,
152: p_s_admission_step_type => 'ACAD-INTEREST') = 'FALSE' THEN
153:
154: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

Line 159: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

155: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
156: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
157:
158: l_error_text := FND_MESSAGE.GET;
159: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
160:
161: UPDATE igs_ad_acadint_int
162: SET status = cst_s_val_3,
163: error_code = cst_ec_val_E701,

Line 182: igs_ad_gen_016.extract_msg_from_stack (

178: x_field_of_study => c_acadint_rec.field_of_study ,
179: x_mode => 'R'
180: );
181:
182: igs_ad_gen_016.extract_msg_from_stack (
183: p_msg_at_index => l_msg_at_index,
184: p_return_status => l_return_status,
185: p_msg_count => l_msg_count,
186: p_msg_data => l_msg_data,

Line 237: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

233: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
234: FND_MESSAGE.SET_TOKEN ('APPLTYPE', c_acadint_rec.admission_application_type);
235:
236: l_error_text := FND_MESSAGE.GET;
237: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
238:
239: UPDATE igs_ad_acadint_int
240: SET status = cst_s_val_3,
241: error_code = cst_ec_val_E701,

Line 257: igs_ad_gen_016.extract_msg_from_stack (

253:
254: l_status := '3';
255: l_error_code := 'E322';
256:
257: igs_ad_gen_016.extract_msg_from_stack (
258: p_msg_at_index => l_msg_at_index,
259: p_return_status => l_return_status,
260: p_msg_count => l_msg_count,
261: p_msg_data => l_msg_data,

Line 264: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

260: p_msg_count => l_msg_count,
261: p_msg_data => l_msg_data,
262: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
263:
264: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
265:
266: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
267: IF l_enable_log = 'Y' THEN
268: igs_ad_imp_001.logerrormessage(c_acadint_rec.interface_acadint_id,l_msg_data);

Line 333: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

329: l_msg_at_index NUMBER := 0;
330: l_return_status VARCHAR2(1);
331: l_msg_count NUMBER;
332: l_msg_data VARCHAR2(2000);
333: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
334:
335: l_prog_label VARCHAR2(100);
336: p_error_code VARCHAR2(30);
337: p_status VARCHAR2(1);

Line 370: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

366:
367: fnd_log.string_with_context( fnd_log.level_procedure, l_label,l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
368: END IF;
369:
370: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
371:
372: UPDATE igs_ad_appint_int a
373: SET status = '3',
374: error_code = 'E678',

Line 394: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_appint_rec.admission_application_type,

390:
391: igs_ge_msg_stack.initialize;
392:
393:
394: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_appint_rec.admission_application_type,
395: p_admission_cat => l_admission_cat,
396: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
397:
398: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 398: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

394: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_appint_rec.admission_application_type,
395: p_admission_cat => l_admission_cat,
396: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
397:
398: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
399: p_s_admission_process_type => l_s_admission_process_type,
400: p_s_admission_step_type => 'APPL-INTENT') = 'FALSE' THEN
401:
402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

Line 406: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

402: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');
403: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
404: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
405: l_error_text := FND_MESSAGE.GET;
406: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
407:
408: UPDATE igs_ad_appint_int
409: SET status = cst_s_val_3,
410: error_code = cst_ec_val_E701,

Line 445: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E423', 8405);

441: p_attribute20 => l_appint_rec.attribute20,
442: p_desc_flex_name => 'IGS_AD_APP_INTENT_FLEX'
443: ) THEN
444:
445: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E423', 8405);
446:
447: UPDATE igs_ad_appint_int
448: SET status = '3',
449: error_code = 'E423',

Line 488: igs_ad_gen_016.extract_msg_from_stack (

484: x_attribute20 => l_appint_rec.attribute20,
485: x_mode => 'R'
486: );
487:
488: igs_ad_gen_016.extract_msg_from_stack (
489: p_msg_at_index => l_msg_at_index,
490: p_return_status => l_return_status,
491: p_msg_count => l_msg_count,
492: p_msg_data => l_msg_data,

Line 540: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

536: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
537: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_appint_rec.admission_application_type);
538:
539: l_error_text := FND_MESSAGE.GET;
540: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
541:
542: UPDATE igs_ad_appint_int
543: SET status = cst_s_val_3,
544: error_code = cst_ec_val_E701,

Line 561: igs_ad_gen_016.extract_msg_from_stack (

557: WHEN OTHERS THEN
558: l_status := '3';
559: l_error_code := 'E322';
560:
561: igs_ad_gen_016.extract_msg_from_stack (
562: p_msg_at_index => l_msg_at_index,
563: p_return_status => l_return_status,
564: p_msg_count => l_msg_count,
565: p_msg_data => l_msg_data,

Line 568: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

564: p_msg_count => l_msg_count,
565: p_msg_data => l_msg_data,
566: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
567:
568: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
569:
570: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
571: IF l_enable_log = 'Y' THEN
572: igs_ad_imp_001.logerrormessage(l_appint_rec.interface_appint_id,l_msg_data);

Line 637: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

633: l_msg_at_index NUMBER := 0;
634: l_return_status VARCHAR2(1);
635: l_msg_count NUMBER;
636: l_msg_data VARCHAR2(2000);
637: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
638:
639: l_prog_label VARCHAR2(100);
640: p_error_code VARCHAR2(30);
641: p_status VARCHAR2(1);

Line 675: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

671: fnd_log.string_with_context( fnd_log.level_procedure, l_label,
672: l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
673: END IF;
674:
675: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
676:
677: UPDATE igs_ad_othinst_int a
678: SET status = '3',
679: error_code = 'E678',

Line 689: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E425', 8405);

685: WHERE b.person_id = a.person_id
686: AND b.admission_appl_number = a.admission_appl_number
687: AND b.institution_code = a.institution_cd );
688:
689: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E425', 8405);
690:
691: UPDATE igs_ad_othinst_int a
692: SET status = '3',
693: error_code = 'E425',

Line 712: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_oth_inst_rec.admission_application_type,

708: BEGIN
709:
710: SAVEPOINT oth_inst_save;
711:
712: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_oth_inst_rec.admission_application_type,
713: p_admission_cat => l_admission_cat,
714: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
715:
716: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 716: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

712: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_oth_inst_rec.admission_application_type,
713: p_admission_cat => l_admission_cat,
714: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
715:
716: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
717: p_s_admission_process_type => l_s_admission_process_type,
718: p_s_admission_step_type => 'OTH-INST-APPL') = 'FALSE' THEN
719:
720: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

Line 725: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

721: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
722: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
723:
724: l_error_text := FND_MESSAGE.GET;
725: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
726:
727: UPDATE igs_ad_othinst_int
728: SET status = cst_s_val_3,
729: error_code = cst_ec_val_E701,

Line 747: igs_ad_gen_016.extract_msg_from_stack (

743: x_admission_appl_number => l_oth_inst_rec.admission_appl_number,
744: x_institution_code => l_oth_inst_rec.institution_cd,
745: x_mode => 'R'
746: );
747: igs_ad_gen_016.extract_msg_from_stack (
748: p_msg_at_index => l_msg_at_index,
749: p_return_status => l_return_status,
750: p_msg_count => l_msg_count,
751: p_msg_data => l_msg_data,

Line 801: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

797: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
798: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_oth_inst_rec.admission_application_type);
799:
800: l_error_text := FND_MESSAGE.GET;
801: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
802:
803: UPDATE igs_ad_othinst_int
804: SET status = cst_s_val_3,
805: error_code = cst_ec_val_E701,

Line 819: igs_ad_gen_016.extract_msg_from_stack (

815: WHEN OTHERS THEN
816: l_status := '3';
817: l_error_code := 'E322';
818:
819: igs_ad_gen_016.extract_msg_from_stack (
820: p_msg_at_index => l_msg_at_index,
821: p_return_status => l_return_status,
822: p_msg_count => l_msg_count,
823: p_msg_data => l_msg_data,

Line 826: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

822: p_msg_count => l_msg_count,
823: p_msg_data => l_msg_data,
824: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
825:
826: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
827:
828: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
829: IF l_enable_log = 'Y' THEN
830: igs_ad_imp_001.logerrormessage(l_oth_inst_rec.interface_othinst_id,l_msg_data);

Line 892: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

888: l_msg_at_index NUMBER := 0;
889: l_return_status VARCHAR2(1);
890: l_msg_count NUMBER;
891: l_msg_data VARCHAR2(2000);
892: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
893:
894: l_prog_label VARCHAR2(100);
895: p_error_code VARCHAR2(30);
896: p_status VARCHAR2(1);

Line 930: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

926: fnd_log.string_with_context( fnd_log.level_procedure, l_label,
927: l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
928: END IF;
929:
930: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
931:
932: UPDATE IGS_AD_SPLINT_INT a
933: SET status = '3',
934: error_code = 'E678',

Line 949: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_spl_intrst_rec.admission_application_type,

945: BEGIN
946:
947: SAVEPOINT spl_intrst_save;
948:
949: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_spl_intrst_rec.admission_application_type,
950: p_admission_cat => l_admission_cat,
951: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
952:
953: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 953: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

949: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_spl_intrst_rec.admission_application_type,
950: p_admission_cat => l_admission_cat,
951: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
952:
953: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
954: p_s_admission_process_type => l_s_admission_process_type,
955: p_s_admission_step_type => 'SPL-INTEREST') = 'FALSE' THEN
956:
957: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

Line 962: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

958: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
959: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
960:
961: l_error_text := FND_MESSAGE.GET;
962: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
963:
964: UPDATE igs_ad_splint_int
965: SET status = cst_s_val_3,
966: error_code = cst_ec_val_E701,

Line 983: igs_ad_gen_016.extract_msg_from_stack (

979: x_special_interest_type_id => l_spl_intrst_rec.special_interest_type_id ,
980: x_mode => 'R'
981: );
982:
983: igs_ad_gen_016.extract_msg_from_stack (
984: p_msg_at_index => l_msg_at_index,
985: p_return_status => l_return_status,
986: p_msg_count => l_msg_count,
987: p_msg_data => l_msg_data,

Line 1038: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

1034: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1035: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_intrst_rec.admission_application_type);
1036:
1037: l_error_text := FND_MESSAGE.GET;
1038: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1039:
1040: UPDATE igs_ad_splint_int
1041: SET status = cst_s_val_3,
1042: error_code = cst_ec_val_E701,

Line 1057: igs_ad_gen_016.extract_msg_from_stack (

1053:
1054: l_status := '3';
1055: l_error_code := 'E322';
1056:
1057: igs_ad_gen_016.extract_msg_from_stack (
1058: p_msg_at_index => l_msg_at_index,
1059: p_return_status => l_return_status,
1060: p_msg_count => l_msg_count,
1061: p_msg_data => l_msg_data,

Line 1064: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

1060: p_msg_count => l_msg_count,
1061: p_msg_data => l_msg_data,
1062: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1063:
1064: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1065:
1066: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1067: IF l_enable_log = 'Y' THEN
1068: igs_ad_imp_001.logerrormessage(l_spl_intrst_rec.interface_splint_id,l_msg_data);

Line 1131: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1127: l_msg_at_index NUMBER := 0;
1128: l_return_status VARCHAR2(1);
1129: l_msg_count NUMBER;
1130: l_msg_data VARCHAR2(2000);
1131: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1132:
1133: l_prog_label VARCHAR2(100);
1134: p_error_code VARCHAR2(30);
1135: p_status VARCHAR2(1);

Line 1168: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

1164:
1165: fnd_log.string_with_context( fnd_log.level_procedure, l_label,l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1166: END IF;
1167:
1168: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
1169:
1170: UPDATE IGS_AD_SPLTAL_INT a
1171: SET status = '3',
1172: error_code = 'E678',

Line 1187: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_spl_tal_rec.admission_application_type,

1183: BEGIN
1184:
1185: SAVEPOINT spl_tal_save;
1186:
1187: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_spl_tal_rec.admission_application_type,
1188: p_admission_cat => l_admission_cat,
1189: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
1190:
1191: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

Line 1191: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,

1187: IF igs_ad_gen_016.get_appl_type_apc (p_application_type => l_spl_tal_rec.admission_application_type,
1188: p_admission_cat => l_admission_cat,
1189: p_s_admission_process_type => l_s_admission_process_type) = 'TRUE' THEN
1190:
1191: IF igs_ad_gen_016.get_apcs (p_admission_cat => l_admission_cat,
1192: p_s_admission_process_type => l_s_admission_process_type,
1193: p_s_admission_step_type => 'SPL-TALENT') = 'FALSE' THEN
1194:
1195: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_NOT_APC_STEP');

Line 1200: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

1196: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1197: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1198:
1199: l_error_text := FND_MESSAGE.GET;
1200: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1201:
1202: UPDATE igs_ad_spltal_int
1203: SET status = cst_s_val_3,
1204: error_code = cst_ec_val_E701,

Line 1220: igs_ad_gen_016.extract_msg_from_stack (

1216: x_admission_appl_number => l_spl_tal_rec.admission_appl_number ,
1217: x_special_talent_type_id => l_spl_tal_rec.special_talent_type_id,
1218: x_mode => 'R' );
1219:
1220: igs_ad_gen_016.extract_msg_from_stack (
1221: p_msg_at_index => l_msg_at_index,
1222: p_return_status => l_return_status,
1223: p_msg_count => l_msg_count,
1224: p_msg_data => l_msg_data,

Line 1273: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);

1269: FND_MESSAGE.SET_TOKEN ('CATEGORY', p_category_meaning);
1270: FND_MESSAGE.SET_TOKEN ('APPLTYPE', l_spl_tal_rec.admission_application_type);
1271:
1272: l_error_text := FND_MESSAGE.GET;
1273: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E701', 8405);
1274:
1275: UPDATE igs_ad_spltal_int
1276: SET status = cst_s_val_3,
1277: error_code = cst_ec_val_E701,

Line 1293: igs_ad_gen_016.extract_msg_from_stack (

1289:
1290: l_status := '3';
1291: l_error_code := 'E322';
1292:
1293: igs_ad_gen_016.extract_msg_from_stack (
1294: p_msg_at_index => l_msg_at_index,
1295: p_return_status => l_return_status,
1296: p_msg_count => l_msg_count,
1297: p_msg_data => l_msg_data,

Line 1300: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

1296: p_msg_count => l_msg_count,
1297: p_msg_data => l_msg_data,
1298: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1299:
1300: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1301:
1302: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1303: IF l_enable_log = 'Y' THEN
1304: igs_ad_imp_001.logerrormessage(l_spl_tal_rec.interface_spltal_id,l_msg_data);

Line 1368: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1364: l_msg_at_index NUMBER := 0;
1365: l_return_status VARCHAR2(1);
1366: l_msg_count NUMBER;
1367: l_msg_data VARCHAR2(2000);
1368: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1369:
1370: l_prog_label VARCHAR2(100);
1371: p_error_code VARCHAR2(30);
1372: p_status VARCHAR2(1);

Line 1405: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);

1401: fnd_log.string_with_context( fnd_log.level_procedure, l_label,
1402: l_debug_str, NULL, NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1403: END IF;
1404:
1405: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E678', 8405);
1406:
1407: UPDATE igs_ad_perstmt_int a
1408: SET status = '3',
1409: error_code = 'E678',

Line 1434: igs_ad_gen_016.extract_msg_from_stack (

1430: x_persl_stat_type => l_appl_pers_rec.persl_stat_type,
1431: x_date_received => TRUNC(l_appl_pers_rec.date_received),
1432: x_mode => 'R');
1433:
1434: igs_ad_gen_016.extract_msg_from_stack (
1435: p_msg_at_index => l_msg_at_index,
1436: p_return_status => l_return_status,
1437: p_msg_count => l_msg_count,
1438: p_msg_data => l_msg_data,

Line 1488: igs_ad_gen_016.extract_msg_from_stack (

1484:
1485: l_status := '3';
1486: l_error_code := 'E322';
1487:
1488: igs_ad_gen_016.extract_msg_from_stack (
1489: p_msg_at_index => l_msg_at_index,
1490: p_return_status => l_return_status,
1491: p_msg_count => l_msg_count,
1492: p_msg_data => l_msg_data,

Line 1495: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

1491: p_msg_count => l_msg_count,
1492: p_msg_data => l_msg_data,
1493: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1494:
1495: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1496:
1497: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1498: IF l_enable_log = 'Y' THEN
1499: igs_ad_imp_001.logerrormessage(l_appl_pers_rec.interface_perstmt_id,l_msg_data);

Line 1600: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1596: l_msg_at_index NUMBER := 0;
1597: l_return_status VARCHAR2(1);
1598: l_msg_count NUMBER;
1599: l_msg_data VARCHAR2(2000);
1600: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1601:
1602: l_prog_label VARCHAR2(100);
1603: p_error_code VARCHAR2(30);
1604: p_status VARCHAR2(1);

Line 1623: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);

1619: l_msg_at_index := igs_ge_msg_stack.count_msg;
1620:
1621: IF p_rule IN ('E' ,'I' ) THEN
1622:
1623: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
1624:
1625: UPDATE igs_ad_fee_int
1626: SET status = '3',
1627: error_code = 'E700',

Line 1645: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E681', 8405);

1641: AND match_ind IN ('17','18','19','22','23','24','27');
1642: END IF;
1643:
1644: IF p_rule IN ( 'R', 'I') THEN
1645: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E681', 8405);
1646: UPDATE igs_ad_fee_int a
1647: SET status = '3'
1648: ,error_code = 'E681',
1649: error_text = l_error_text1

Line 1764: igs_ad_gen_016.extract_msg_from_stack (

1760: ELSIF l_fee_int_rec.dmlmode = cst_insert THEN
1761: l_error_code := 'E322';
1762: END IF;
1763:
1764: igs_ad_gen_016.extract_msg_from_stack (
1765: p_msg_at_index => l_msg_at_index,
1766: p_return_status => l_return_status,
1767: p_msg_count => l_msg_count,
1768: p_msg_data => l_msg_data,

Line 1771: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

1767: p_msg_count => l_msg_count,
1768: p_msg_data => l_msg_data,
1769: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
1770:
1771: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
1772:
1773: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
1774: IF l_enable_log = 'Y' THEN
1775: igs_ad_imp_001.logerrormessage(l_fee_int_rec.interface_fee_id,l_msg_data);

Line 1861: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);

1857: END IF;
1858:
1859: -- Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
1860: IF p_rule = 'R' THEN
1861: l_error_text1 := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
1862:
1863: UPDATE igs_ad_fee_int
1864: SET
1865: status = cst_s_val_3