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_OR_INST_IMP_001 dependencies on IGS_OR_INST_IMP_002

Line 9: -- Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master which includes

5: --Who When What
6: -- kumma 14-JUN-2002 Uncommented call to message IGS_OR_INST_IMP_SUCC , 2410165
7: -- kumma 08-JUL-2002 Bug 2446067, In all the three procedures numericAltidcomp, simpleAltidcomp and exactAltidcomp,
8: -- Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
9: -- Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master which includes
10: -- existing institution cd
11: -- and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
12: -- In the Exception section of numericAltidcomp procedure, checked for the invalid_number exception,
13: -- as the alternate_id_value for this procedure should be neumeric, if it is not so then

Line 11: -- and IGS_OR_INST_IMP_002.Create_Crosswalk_master.

7: -- kumma 08-JUL-2002 Bug 2446067, In all the three procedures numericAltidcomp, simpleAltidcomp and exactAltidcomp,
8: -- Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
9: -- Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master which includes
10: -- existing institution cd
11: -- and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
12: -- In the Exception section of numericAltidcomp procedure, checked for the invalid_number exception,
13: -- as the alternate_id_value for this procedure should be neumeric, if it is not so then
14: -- we need to log a message stating that it should be neumeric only
15: --pkpatel 26-OCT-2002 Bug No: 2613704

Line 236: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_002') THEN

232: ELSE
233: gb_write_exception_log1 := FALSE;
234: END IF;
235:
236: IF FND_LOG.test(FND_LOG.LEVEL_EXCEPTION,'igs.plsql.igs_or_inst_imp_002') THEN
237: gb_write_exception_log2 := TRUE;
238: ELSE
239: gb_write_exception_log2 := FALSE;
240: END IF;

Line 337: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master

333: pkpatel 6-JAN-2003 Bug No: 2528605
334: Added the create_alternate_id procedures for the all the conditions.
335: Made the data_source_value as UPPER at the beginning and initialize the record varuable to NULL
336: kumma 08-JUL-2002 Bug 2446067, Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
337: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master
338: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
339: ***************************************************************/
340: CURSOR c_inst_cur (cp_data_source VARCHAR2,
341: cp_batch_id NUMBER,

Line 338: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.

334: Added the create_alternate_id procedures for the all the conditions.
335: Made the data_source_value as UPPER at the beginning and initialize the record varuable to NULL
336: kumma 08-JUL-2002 Bug 2446067, Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
337: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master
338: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
339: ***************************************************************/
340: CURSOR c_inst_cur (cp_data_source VARCHAR2,
341: cp_batch_id NUMBER,
342: cp_status IGS_OR_INST_INT.STATUS%TYPE) IS

Line 445: IGS_OR_INST_IMP_002.Update_Institution(l_cwlkinst_rec.inst_code, v_inst_rec,l_Errind,l_error_code,l_error_text);

441: IF validate_field_level_data(v_inst_rec,l_val_err) then
442: SAVEPOINT s_point;
443: -- Update the existing Institution
444:
445: IGS_OR_INST_IMP_002.Update_Institution(l_cwlkinst_rec.inst_code, v_inst_rec,l_Errind,l_error_code,l_error_text);
446: -- No Records need to be either inserted or Updated in the Crosswalk Master and Crosswalk Detail Tables
447: /* Rollback if there was an error during Update Institutions */
448: IF l_Errind = 'Y' THEN
449: ROLLBACK TO s_point;

Line 462: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_cwlkinst_rec.inst_code,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

458: WHERE INTERFACE_ID = v_inst_rec.interface_id;
459:
460: ELSE
461:
462: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_cwlkinst_rec.inst_code,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
463:
464: IF l_errind = 'Y' THEN
465:
466: ROLLBACK TO s_point;

Line 515: IGS_OR_INST_IMP_002.Create_Institution(v_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text); -- Create a new institution

511: IF v_inst_rec.exst_institution_cd IS NULL THEN -- If the exst_inst_code of the interface rec is null, then create
512: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
513: SAVEPOINT s_point;
514:
515: IGS_OR_INST_IMP_002.Create_Institution(v_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text); -- Create a new institution
516: /* Update the Crosswalk Master with the newly created Institution Code if no error has occured
517: during creation of new institution. If an error has occured then rollback to savepoint s_point */
518: IF l_Errind = 'Y' THEN
519: ROLLBACK TO s_point;

Line 532: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,l_Newinstcd,l_Errind);

528: WHERE INTERFACE_ID = v_inst_rec.interface_id;
529:
530: ELSE
531:
532: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,l_Newinstcd,l_Errind);
533:
534:
535: IF l_Errind = 'Y' THEN
536: ROLLBACK TO s_point;

Line 553: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

549: -- No records needs to be inserted to the Crosswalk Detail as the record is already found
550: /* Create a New Record in the table IGS_OR_ORG_ALT_ID if no error has occured during
551: updation of Crosswalk Master. If an error has occured then rollback to savepoint s_point */
552:
553: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
554:
555: /* Rollback if there is an error during the create in the above step else call the import of child records */
556: IF l_Errind = 'Y' THEN -- STEP A
557: ROLLBACK TO s_point;

Line 626: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);

622: ELSE -- Institution is existing in the OSS system
623: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
624: SAVEPOINT s_point;
625:
626: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);
627: /* Update the Crosswalk Table if the Previous update is successful, else rollback to savepoint */
628: IF l_Errind = 'Y' THEN
629: ROLLBACK TO s_point;
630: -- ssawhney moved all together

Line 664: IGS_OR_INST_IMP_002.Update_Crosswalk_master(l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);

660: WHERE INTERFACE_ID = v_inst_rec.interface_id;
661: l_Errind := 'Y';
662: l_error_code := 'E051';
663: ELSE
664: IGS_OR_INST_IMP_002.Update_Crosswalk_master(l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
665: END IF;
666: ELSE
667: IGS_OR_INST_IMP_002.Update_Crosswalk_master(l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
668: END IF;

Line 667: IGS_OR_INST_IMP_002.Update_Crosswalk_master(l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);

663: ELSE
664: IGS_OR_INST_IMP_002.Update_Crosswalk_master(l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
665: END IF;
666: ELSE
667: IGS_OR_INST_IMP_002.Update_Crosswalk_master(l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
668: END IF;
669:
670: -- additition of code ends here, kumma
671:

Line 692: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

688:
689: END IF;
690: ELSE
691:
692: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
693:
694: IF l_Errind = 'Y' THEN
695: ROLLBACK TO s_point;
696: --Log a message to the Log File that the Create of Alternate Id failed

Line 747: IGS_OR_INST_IMP_002.Create_Institution(p_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text);

743: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
744: SAVEPOINT s_point;
745: p_inst_rec := v_inst_rec;
746:
747: IGS_OR_INST_IMP_002.Create_Institution(p_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text);
748:
749: IF l_Errind = 'Y' THEN
750: ROLLBACK TO s_point;
751: IF gb_write_exception_log1 = TRUE THEN

Line 771: IGS_OR_INST_IMP_002.Create_Crosswalk_Master(l_Newinstcd,v_inst_rec.NAME,l_Errind,l_Crswlkid);

767: OPEN c_cwlk_master_present(l_Newinstcd);
768: FETCH c_cwlk_master_present INTO l_cwlk_master_present;
769: CLOSE c_cwlk_master_present;
770: IF l_cwlk_master_present.institution_code IS NULL THEN
771: IGS_OR_INST_IMP_002.Create_Crosswalk_Master(l_Newinstcd,v_inst_rec.NAME,l_Errind,l_Crswlkid);
772: ELSE
773: l_Crswlkid := l_cwlk_master_present.crosswalk_id;
774: END IF;
775:

Line 790: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Crswlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind);

786: SET ERROR_CODE = 'E004',error_text =NULL, STATUS = '3'
787: WHERE INTERFACE_ID = v_inst_rec.interface_id;
788:
789: ELSE
790: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Crswlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind);
791: /* Create a Record in the Alternate Ids table IGS_OR_ORG_ALT_IDS if the Previous Create is successful else rollback to the savepoint */
792: IF l_Errind = 'Y' THEN
793: ROLLBACK TO s_point;
794: --Log a message to the Log File that the Update of Crosswalk Master failed

Line 804: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

800: SET error_code = 'E007',error_text=NULL , STATUS = '3'
801: WHERE INTERFACE_ID = v_inst_rec.interface_id;
802:
803: ELSE
804: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
805: /* Call the Child process if the Above Create is successful else rollback */
806: IF l_Errind = 'Y' THEN
807: ROLLBACK TO s_point;
808: --Log a message to the Log File that the Create of Alternate Id failed

Line 871: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);

867: ELSE -- Institution is existing in the OSS system
868: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
869: SAVEPOINT s_point ;
870:
871: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);
872: /* Create a Record in Crosswalk Master if the Previous Create was successful else rollback to the savepoint */
873: IF l_Errind = 'Y' THEN
874: ROLLBACK TO s_point;
875: --Log a message to the Log File that the Create of table failed

Line 892: IGS_OR_INST_IMP_002.Create_Crosswalk_Master(v_inst_rec.exst_institution_cd,v_inst_rec.name,l_Errind,l_Crswlkid);

888: OPEN c_cwlk_master_present(v_inst_rec.exst_institution_cd);
889: FETCH c_cwlk_master_present INTO l_cwlk_master_present;
890: CLOSE c_cwlk_master_present;
891: IF l_cwlk_master_present.institution_code IS NULL THEN
892: IGS_OR_INST_IMP_002.Create_Crosswalk_Master(v_inst_rec.exst_institution_cd,v_inst_rec.name,l_Errind,l_Crswlkid);
893: ELSE
894: l_Crswlkid := l_cwlk_master_present.crosswalk_id;
895: END IF;
896:

Line 910: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Crswlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind);

906: SET error_code = 'E004' , error_text =NULL, STATUS = '3'
907: WHERE INTERFACE_ID = v_inst_rec.interface_id;
908:
909: ELSE
910: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Crswlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind);
911: /* Create a Record in the Alternate Ids table IGS_OR_ORG_ALT_IDS if the Previous Create is successful else rollback to the savepoint */
912: IF l_Errind = 'Y' THEN
913: ROLLBACK TO s_point;
914: --Log a message to the Log File that the Creation of Crosswalk detail failed

Line 925: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

921: WHERE INTERFACE_ID = v_inst_rec.interface_id;
922:
923: ELSE
924:
925: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
926:
927: /* Call the Child process if the Above Create is successful else rollback */
928: IF l_Errind = 'Y' THEN
929: ROLLBACK TO s_point;

Line 1014: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master

1010: Who When What
1011: pkpatel 6-JAN-2003 Bug No: 2528605
1012: Made the data_source_value as UPPER at the beginning and initialize the record varuable to NULL
1013: kumma 08-JUL-2002 Bug 2446067, Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
1014: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master
1015: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
1016: ***************************************************************/
1017:
1018: CURSOR c_inst_cur(cp_status IGS_OR_INST_INT.STATUS%TYPE,

Line 1015: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.

1011: pkpatel 6-JAN-2003 Bug No: 2528605
1012: Made the data_source_value as UPPER at the beginning and initialize the record varuable to NULL
1013: kumma 08-JUL-2002 Bug 2446067, Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
1014: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master
1015: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
1016: ***************************************************************/
1017:
1018: CURSOR c_inst_cur(cp_status IGS_OR_INST_INT.STATUS%TYPE,
1019: cp_data_source VARCHAR2,

Line 1130: IGS_OR_INST_IMP_002.Update_Institution(l_cwlkinst_rec.inst_code, v_inst_rec,l_Errind,l_error_code,l_error_text);

1126: ELSE -- The Institution Code in the Crosswalk is present in the OSS System
1127: IF validate_field_level_data(v_inst_rec,l_val_err) then
1128: SAVEPOINT s_point;
1129:
1130: IGS_OR_INST_IMP_002.Update_Institution(l_cwlkinst_rec.inst_code, v_inst_rec,l_Errind,l_error_code,l_error_text);
1131: -- No Record Needs to Be created in Crosswalk Master
1132: -- Fetch the Crosswalk Id from the Master
1133: OPEN c_cwlk_id(l_cwlkinst_rec.inst_code);
1134: FETCH c_cwlk_id INTO l_Cwlkid;

Line 1152: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value

1148: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1149:
1150:
1151: ELSE
1152: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value
1153: /* Create a Record in the Alternate Ids table IGS_OR_ORG_ALT_IDS if the Previous Create is successful else rollback to the savepoint */
1154: IF l_Errind = 'Y' THEN
1155: ROLLBACK TO s_point;
1156: --Log a message to the Log File that the Create of Crosswalk Detail failed

Line 1166: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_cwlkinst_rec.inst_code,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

1162: SET error_code = 'E007' , error_text=NULL, STATUS = '3'
1163: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1164:
1165: ELSE
1166: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_cwlkinst_rec.inst_code,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
1167: IF l_Errind = 'Y' THEN
1168: ROLLBACK TO s_point;
1169: --Log a message to the Log File that the Create of Alternate Id failed
1170: IF gb_write_exception_log1 = TRUE THEN

Line 1216: IGS_OR_INST_IMP_002.Create_Institution(v_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text);

1212: IF v_inst_rec.exst_institution_cd IS NULL THEN -- If the exst_inst_code of the interface rec is null, then create
1213: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
1214: SAVEPOINT s_point;
1215:
1216: IGS_OR_INST_IMP_002.Create_Institution(v_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text);
1217: IF l_Errind = 'Y' THEN
1218: ROLLBACK TO s_point;
1219:
1220: --Log a message to the Log File that the Create of inst failed

Line 1233: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,l_Newinstcd,l_Errind);

1229:
1230:
1231: ELSE
1232:
1233: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,l_Newinstcd,l_Errind);
1234:
1235: IF l_Errind = 'Y' THEN
1236: ROLLBACK TO s_point;
1237: --Log a message to the Log File that the Update of Crosswalk Master failed

Line 1250: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value

1246: ELSE
1247: OPEN c_cwlk_id(l_Newinstcd);
1248: FETCH c_cwlk_id INTO l_Cwlkid;
1249: CLOSE c_cwlk_id;
1250: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value
1251: IF l_Errind = 'Y' THEN
1252: ROLLBACK TO s_point;
1253: --Log a message to the Log File that the Create of Crosswalk Detail failed
1254: IF gb_write_exception_log1 = TRUE THEN

Line 1263: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

1259: SET error_code = 'E007',error_text=NULL, STATUS = '3'
1260: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1261:
1262: ELSE
1263: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
1264: IF l_Errind = 'Y' THEN
1265: ROLLBACK TO s_point;
1266: --Log a message to the Log File that the Create of Alternate Id failed
1267: IF gb_write_exception_log1 = TRUE THEN

Line 1325: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);

1321:
1322: ELSE -- Institution is existing in the OSS system
1323: IF validate_field_level_data(v_inst_rec,l_val_err) then
1324: SAVEPOINT s_point;
1325: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);
1326: IF l_Errind = 'Y' THEN
1327: ROLLBACK TO s_point;
1328:
1329: IF gb_write_exception_log1 = TRUE THEN

Line 1362: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);

1358: l_Errind := 'Y';
1359: l_error_code := 'E051';
1360:
1361: ELSE
1362: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1363: END IF;
1364: ELSE
1365: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1366: END IF;

Line 1365: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);

1361: ELSE
1362: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1363: END IF;
1364: ELSE
1365: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1366: END IF;
1367: -- additition of code ends here, kumma
1368: -----------
1369:

Line 1387: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value

1383: ELSE
1384: OPEN c_cwlk_id(v_inst_rec.exst_institution_cd);
1385: FETCH c_cwlk_id INTO l_Cwlkid;
1386: CLOSE c_cwlk_id;
1387: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value
1388: IF l_Errind = 'Y' THEN
1389: ROLLBACK TO s_point;
1390: --Log a message to the Log File that the Create Crosswalk detail failed
1391: IF gb_write_exception_log1 = TRUE THEN

Line 1401: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

1397: SET error_code = 'E007', error_text=NULL, STATUS = '3'
1398: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1399:
1400: ELSE
1401: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
1402: IF l_Errind = 'Y' THEN
1403: ROLLBACK TO s_point;
1404: --Log a message to the Log File that the Create Alternate Id failed
1405: IF gb_write_exception_log1 = TRUE THEN

Line 1513: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master

1509: Who When What
1510: pkpatel 6-JAN-2003 Bug No: 2528605
1511: Made the data_source_value as UPPER at the beginning and initialize the record varuable to NULL
1512: kumma 08-JUL-2002 Bug 2446067, Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
1513: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master
1514: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
1515: In the Exception section checked for the invalid_number exception, as if the alternate_id_value
1516: is not neumeric we need to log a message stating that it should be neumeric only.
1517: Created a new cursor c_neumeric_test to check whether the Alternate Id value is neumeric or not.

Line 1514: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.

1510: pkpatel 6-JAN-2003 Bug No: 2528605
1511: Made the data_source_value as UPPER at the beginning and initialize the record varuable to NULL
1512: kumma 08-JUL-2002 Bug 2446067, Created two cursors c_cwlk_master_present and c_cwlk_detail_id.
1513: Used these cursor before every call to IGS_OR_INST_IMP_002.Update_Crosswalk_master
1514: which includes the existing institution cd and IGS_OR_INST_IMP_002.Create_Crosswalk_master.
1515: In the Exception section checked for the invalid_number exception, as if the alternate_id_value
1516: is not neumeric we need to log a message stating that it should be neumeric only.
1517: Created a new cursor c_neumeric_test to check whether the Alternate Id value is neumeric or not.
1518: In cursor c_record_found and c_inst_code removed the to_number function.

Line 1700: IGS_OR_INST_IMP_002.Update_Institution(l_cwlkinst_rec.inst_code, v_inst_rec,l_Errind,l_error_code,l_error_text);

1696:
1697: ELSE -- The Institution Code in the Crosswalk is present in the OSS System
1698: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
1699: SAVEPOINT s_point;
1700: IGS_OR_INST_IMP_002.Update_Institution(l_cwlkinst_rec.inst_code, v_inst_rec,l_Errind,l_error_code,l_error_text);
1701: -- No Record Needs to Be created in Crosswalk Master
1702: IF l_Errind = 'Y' THEN
1703: ROLLBACK TO s_point;
1704:

Line 1720: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value

1716: OPEN c_cwlk_id(l_cwlkinst_rec.inst_code);
1717: FETCH c_cwlk_id INTO l_Cwlkid;
1718: CLOSE c_cwlk_id;
1719:
1720: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value
1721: IF l_Errind = 'Y' THEN
1722: ROLLBACK TO s_point;
1723: --Log a message to the Log File that the Create of Crosswalk Detail failed
1724: IF gb_write_exception_log1 = TRUE THEN

Line 1733: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_cwlkinst_rec.inst_code,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

1729: SET error_code = 'E007', error_text=NULL, STATUS = '3'
1730: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1731:
1732: ELSE
1733: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_cwlkinst_rec.inst_code,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
1734: IF l_Errind = 'Y' THEN
1735: ROLLBACK TO s_point;
1736: --Log a message to the Log File that the Create of Alternate Id failed
1737: IF gb_write_exception_log1 = TRUE THEN

Line 1779: IGS_OR_INST_IMP_002.Create_Institution(v_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text);

1775: ELSE -- The Institution Code in the Crosswalk table is NULL
1776: IF v_inst_rec.exst_institution_cd IS NULL THEN -- If the exst_inst_code of the interface rec is null, then create
1777: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
1778: SAVEPOINT s_point;
1779: IGS_OR_INST_IMP_002.Create_Institution(v_inst_rec,l_Newinstcd,l_Errind,l_error_code,l_error_text);
1780:
1781: IF l_Errind = 'Y' THEN
1782: ROLLBACK TO s_point;
1783:

Line 1795: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,l_Newinstcd,l_Errind);

1791: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1792:
1793: ELSE
1794:
1795: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,l_Newinstcd,l_Errind);
1796:
1797: IF l_Errind = 'Y' THEN
1798: ROLLBACK TO s_point;
1799: --Log a message to the Log File that the Update of Crosswalk master failed

Line 1813: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value

1809: OPEN c_cwlk_id(l_Newinstcd);
1810: FETCH c_cwlk_id INTO l_Cwlkid;
1811: CLOSE c_cwlk_id;
1812:
1813: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value
1814:
1815: IF l_Errind = 'Y' THEN
1816: ROLLBACK TO s_point;
1817: --Log a message to the Log File that the Create of Crosswalk Detail failed

Line 1827: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

1823: SET error_code = 'E007',error_text=NULL, STATUS = '3'
1824: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1825:
1826: ELSE
1827: IGS_OR_INST_IMP_002.Create_Alternate_Id(l_Newinstcd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
1828: IF l_Errind = 'Y' THEN
1829: ROLLBACK TO s_point;
1830: --Log a message to the Log File that the Create of Alternate Id failed
1831: IF gb_write_exception_log1 = TRUE THEN

Line 1888: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);

1884: ELSE -- Institution is existing in the OSS system
1885: IF validate_field_level_data(v_inst_rec,l_val_err) THEN
1886: SAVEPOINT s_point;
1887:
1888: IGS_OR_INST_IMP_002.Update_Institution(v_inst_rec.exst_institution_cd, v_inst_rec,l_Errind,l_error_code,l_error_text);
1889: IF l_Errind = 'Y' THEN
1890: ROLLBACK TO s_point;
1891:
1892: IF gb_write_exception_log1 = TRUE THEN

Line 1927: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);

1923: l_error_code := 'E051';
1924:
1925: ELSE
1926:
1927: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1928: END IF;
1929: ELSE
1930: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1931: END IF;

Line 1930: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);

1926:
1927: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1928: END IF;
1929: ELSE
1930: IGS_OR_INST_IMP_002.Update_Crosswalk_master (l_cwlkinst_rec.crosswalk_id,v_inst_rec.exst_institution_cd,l_Errind);
1931: END IF;
1932: -- additition of code ends here, kumma
1933: ----
1934:

Line 1954: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value

1950: OPEN c_cwlk_id(v_inst_rec.exst_institution_cd);
1951: FETCH c_cwlk_id INTO l_Cwlkid;
1952: CLOSE c_cwlk_id;
1953:
1954: IGS_OR_INST_IMP_002.Create_Crosswalk_Detail(l_Cwlkid,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_Errind); -- create an entry for data_source, data_source_value
1955: IF l_Errind = 'Y' THEN
1956: ROLLBACK TO s_point;
1957: --Log a message to the Log File that the Create of Crosswalk Detail failed
1958: IF gb_write_exception_log1 = TRUE THEN

Line 1967: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);

1963: SET error_code = 'E007',error_text=NULL, STATUS = '3'
1964: WHERE INTERFACE_ID = v_inst_rec.interface_id;
1965:
1966: ELSE
1967: IGS_OR_INST_IMP_002.Create_Alternate_Id(v_inst_rec.exst_institution_cd,v_inst_rec.data_source_id,v_inst_rec.data_source_value,l_error_code,l_Errind);
1968: IF l_Errind = 'Y' THEN
1969: ROLLBACK TO s_point;
1970: --Log a message to the Log File that the Create of Alternate Id failed
1971: IF gb_write_exception_log1 = TRUE THEN