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_ST_GEN_002 dependencies on IGS_GE_GEN_003

Line 614: IGS_GE_GEN_003.genp_ins_log_entry(

610:
611: p_logged_ind := TRUE;
612: END IF;
613: -- Create an entry in the System Log Entry
614: IGS_GE_GEN_003.genp_ins_log_entry(
615: p_s_log_type,
616: p_creation_dt,
617: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
618: p_message_name,

Line 651: -- using IGS_GE_GEN_003.genp_log_error

647: CLOSE c_get_person_dtls;
648: IF (v_birth_dt IS NULL) THEN
649: IF (p_logged_ind = FALSE) THEN
650: -- log an error to the IGS_GE_S_ERROR_LOG
651: -- using IGS_GE_GEN_003.genp_log_error
652: -- set that an error has been logged
653: p_logged_ind := TRUE;
654: END IF;
655: -- create an entry in the system log entry

Line 656: IGS_GE_GEN_003.genp_ins_log_entry (

652: -- set that an error has been logged
653: p_logged_ind := TRUE;
654: END IF;
655: -- create an entry in the system log entry
656: IGS_GE_GEN_003.genp_ins_log_entry (
657: p_s_log_type,
658: p_creation_dt,
659: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
660: 4194,

Line 667: -- using IGS_GE_GEN_003.genp_log_error

663: IF (v_sex NOT IN('M','F')) THEN
664: --Check if an entry has been written to the error log.
665: IF p_logged_ind = FALSE THEN
666: -- log an error to the IGS_GE_S_ERROR_LOG
667: -- using IGS_GE_GEN_003.genp_log_error
668:
669: -- set that an error has been logged
670: p_logged_ind := TRUE;
671: END IF;

Line 673: IGS_GE_GEN_003.genp_ins_log_entry (

669: -- set that an error has been logged
670: p_logged_ind := TRUE;
671: END IF;
672: -- create an entry in the system log entry
673: IGS_GE_GEN_003.genp_ins_log_entry (
674: p_s_log_type,
675: p_creation_dt,
676: 'IGS_PE_PERSON,' || TO_CHAR(p_person_id),
677: 4195,

Line 711: -- using IGS_GE_GEN_003.genp_log_error

707: CLOSE c_prsn_stats;
708: -- Check if an entry has been written to the error log
709: IF (p_logged_ind = FALSE) THEN
710: -- log an error to the IGS_GE_S_ERROR_LOG
711: -- using IGS_GE_GEN_003.genp_log_error
712:
713: -- set that an error has been logged
714: p_logged_ind := TRUE;
715: END IF;

Line 717: IGS_GE_GEN_003.genp_ins_log_entry (

713: -- set that an error has been logged
714: p_logged_ind := TRUE;
715: END IF;
716: -- create an entry in the system log entry
717: IGS_GE_GEN_003.genp_ins_log_entry (
718: p_s_log_type,
719: p_creation_dt,
720: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
721: 4196,

Line 738: -- using IGS_GE_GEN_003.genp_log_error

734: IF v_govt_aborig_torres_cd = 9 THEN
735: -- Check if an entry has been written to the error log
736: IF p_logged_ind = FALSE THEN
737: -- log an error to the IGS_GE_S_ERROR_LOG
738: -- using IGS_GE_GEN_003.genp_log_error
739:
740: -- set that an error has been logged
741: p_logged_ind := TRUE;
742: END IF;

Line 744: IGS_GE_GEN_003.genp_ins_log_entry (

740: -- set that an error has been logged
741: p_logged_ind := TRUE;
742: END IF;
743: -- create an entry in the system log entry
744: IGS_GE_GEN_003.genp_ins_log_entry (
745: p_s_log_type,
746: p_creation_dt,
747: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
748: 4197,

Line 757: -- using IGS_GE_GEN_003.genp_log_error

753: v_govt_aborig_torres_cd := 9;
754: -- Check if an entry has been written to the error log
755: IF p_logged_ind = FALSE THEN
756: -- log an error to the IGS_GE_S_ERROR_LOG
757: -- using IGS_GE_GEN_003.genp_log_error
758:
759: -- set that an error has been logged
760: p_logged_ind := TRUE;
761: END IF;

Line 763: IGS_GE_GEN_003.genp_ins_log_entry (

759: -- set that an error has been logged
760: p_logged_ind := TRUE;
761: END IF;
762: -- create an entry in the system log entry
763: IGS_GE_GEN_003.genp_ins_log_entry (
764: p_s_log_type,
765: p_creation_dt,
766: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
767: 4197,

Line 781: -- using IGS_GE_GEN_003.genp_log_error

777: IF v_govt_citizenship_cd = 9 THEN
778: -- Check if an entry has been written to the error log
779: IF p_logged_ind = FALSE THEN
780: -- log an error to the IGS_GE_S_ERROR_LOG
781: -- using IGS_GE_GEN_003.genp_log_error
782:
783: -- set that an error has been logged
784: p_logged_ind := TRUE;
785: END IF;

Line 787: IGS_GE_GEN_003.genp_ins_log_entry (

783: -- set that an error has been logged
784: p_logged_ind := TRUE;
785: END IF;
786: -- create an entry in the system log entry
787: IGS_GE_GEN_003.genp_ins_log_entry (
788: p_s_log_type,
789: p_creation_dt,
790: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
791: 4202,

Line 800: -- using IGS_GE_GEN_003.genp_log_error

796: v_govt_citizenship_cd := 9;
797: -- Check if an entry has been written to the error log
798: IF p_logged_ind = FALSE THEN
799: -- log an error to the IGS_GE_S_ERROR_LOG
800: -- using IGS_GE_GEN_003.genp_log_error
801:
802: -- set that an error has been logged
803: p_logged_ind := TRUE;
804: END IF;

Line 806: IGS_GE_GEN_003.genp_ins_log_entry (

802: -- set that an error has been logged
803: p_logged_ind := TRUE;
804: END IF;
805: -- create an entry in the system log entry
806: IGS_GE_GEN_003.genp_ins_log_entry (
807: p_s_log_type,
808: p_creation_dt,
809: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
810: 4202,

Line 828: -- using IGS_GE_GEN_003.genp_log_error

824: v_govt_perm_resident_cd := 9;
825: -- Check if an entry has been written to the error log
826: IF p_logged_ind = FALSE THEN
827: -- log an error to the IGS_GE_S_ERROR_LOG
828: -- using IGS_GE_GEN_003.genp_log_error
829:
830: -- set that an error has been logged
831: p_logged_ind := TRUE;
832: END IF;

Line 834: IGS_GE_GEN_003.genp_ins_log_entry (

830: -- set that an error has been logged
831: p_logged_ind := TRUE;
832: END IF;
833: -- create an entry in the system log entry
834: IGS_GE_GEN_003.genp_ins_log_entry (
835: p_s_log_type,
836: p_creation_dt,
837: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
838: 4203,

Line 846: -- using IGS_GE_GEN_003.genp_log_error

842: v_govt_perm_resident_cd := 0;
843: -- Check if an entry has been written to the error log
844: IF p_logged_ind = FALSE THEN
845: -- log an error to the IGS_GE_S_ERROR_LOG
846: -- using IGS_GE_GEN_003.genp_log_error
847:
848: -- set that an error has been logged
849: p_logged_ind := TRUE;
850: END IF;

Line 852: IGS_GE_GEN_003.genp_ins_log_entry (

848: -- set that an error has been logged
849: p_logged_ind := TRUE;
850: END IF;
851: -- create an entry in the system log entry
852: IGS_GE_GEN_003.genp_ins_log_entry (
853: p_s_log_type,
854: p_creation_dt,
855: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
856: 4644,

Line 886: -- using IGS_GE_GEN_003.genp_log_error

882: v_govt_home_location := '9999';
883: -- Check if an entry has been written to the error log
884: IF p_logged_ind = FALSE THEN
885: -- log an error to the IGS_GE_S_ERROR_LOG
886: -- using IGS_GE_GEN_003.genp_log_error
887:
888: -- set that an error has been logged
889: p_logged_ind := TRUE;
890: END IF;

Line 892: IGS_GE_GEN_003.genp_ins_log_entry (

888: -- set that an error has been logged
889: p_logged_ind := TRUE;
890: END IF;
891: -- create an entry in the system log entry
892: IGS_GE_GEN_003.genp_ins_log_entry (
893: p_s_log_type,
894: p_creation_dt,
895: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
896: 4204,

Line 925: -- using IGS_GE_GEN_003.genp_log_error

921: v_govt_term_location := '9999';
922: -- Check if an entry has been written to the error log
923: IF p_logged_ind = FALSE THEN
924: -- log an error to the IGS_GE_S_ERROR_LOG
925: -- using IGS_GE_GEN_003.genp_log_error
926:
927: -- set that an error has been logged
928: p_logged_ind := TRUE;
929: END IF;

Line 931: IGS_GE_GEN_003.genp_ins_log_entry (

927: -- set that an error has been logged
928: p_logged_ind := TRUE;
929: END IF;
930: -- create an entry in the system log entry
931: IGS_GE_GEN_003.genp_ins_log_entry (
932: p_s_log_type,
933: p_creation_dt,
934: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
935: 4205,

Line 957: -- using IGS_GE_GEN_003.genp_log_error

953: IF v_govt_birth_country_cd = '9999' THEN
954: -- Check if an entry has been written to the error log
955: IF p_logged_ind = FALSE THEN
956: -- log an error to the IGS_GE_S_ERROR_LOG
957: -- using IGS_GE_GEN_003.genp_log_error
958:
959: -- set that an error has been logged
960: p_logged_ind := TRUE;
961: END IF;

Line 963: IGS_GE_GEN_003.genp_ins_log_entry (

959: -- set that an error has been logged
960: p_logged_ind := TRUE;
961: END IF;
962: -- create an entry in the system log entry
963: IGS_GE_GEN_003.genp_ins_log_entry (
964: p_s_log_type,
965: p_creation_dt,
966: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
967: 4206,

Line 976: -- using IGS_GE_GEN_003.genp_log_error

972: v_yr_arrival := 'A9';
973: -- Check if an entry has been written to the error log
974: IF p_logged_ind = FALSE THEN
975: -- log an error to the IGS_GE_S_ERROR_LOG
976: -- using IGS_GE_GEN_003.genp_log_error
977:
978: -- set that an error has been logged
979: p_logged_ind := TRUE;
980: END IF;

Line 982: IGS_GE_GEN_003.genp_ins_log_entry (

978: -- set that an error has been logged
979: p_logged_ind := TRUE;
980: END IF;
981: -- create an entry in the system log entry
982: IGS_GE_GEN_003.genp_ins_log_entry (
983: p_s_log_type,
984: p_creation_dt,
985: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
986: 4207,

Line 993: -- using IGS_GE_GEN_003.genp_log_error

989: v_yr_arrival = 'A9' THEN
990: -- Check if an entry has been written to the error log
991: IF p_logged_ind = FALSE THEN
992: -- log an error to the IGS_GE_S_ERROR_LOG
993: -- using IGS_GE_GEN_003.genp_log_error
994:
995: -- set that an error has been logged
996: p_logged_ind := TRUE;
997: END IF;

Line 999: IGS_GE_GEN_003.genp_ins_log_entry (

995: -- set that an error has been logged
996: p_logged_ind := TRUE;
997: END IF;
998: -- create an entry in the system log entry
999: IGS_GE_GEN_003.genp_ins_log_entry (
1000: p_s_log_type,
1001: p_creation_dt,
1002: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1003: 4207,

Line 1024: -- using IGS_GE_GEN_003.genp_log_error

1020: v_govt_home_language_cd := 99;
1021: -- Check if an entry has been written to the error log
1022: IF p_logged_ind = FALSE THEN
1023: -- log an error to the IGS_GE_S_ERROR_LOG
1024: -- using IGS_GE_GEN_003.genp_log_error
1025:
1026: -- set that an error has been logged
1027: p_logged_ind := TRUE;
1028: END IF;

Line 1030: IGS_GE_GEN_003.genp_ins_log_entry (

1026: -- set that an error has been logged
1027: p_logged_ind := TRUE;
1028: END IF;
1029: -- create an entry in the system log entry
1030: IGS_GE_GEN_003.genp_ins_log_entry (
1031: p_s_log_type,
1032: p_creation_dt,
1033: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1034: 4208,

Line 1061: -- using IGS_GE_GEN_003.genp_log_error

1057: IF v_govt_prior_ug_inst = '9999' THEN
1058: -- Check if an entry has been written to the error log
1059: IF p_logged_ind = FALSE THEN
1060: -- log an error to the IGS_GE_S_ERROR_LOG
1061: -- using IGS_GE_GEN_003.genp_log_error
1062:
1063: -- set that an error has been logged
1064: p_logged_ind := TRUE;
1065: END IF;

Line 1067: IGS_GE_GEN_003.genp_ins_log_entry (

1063: -- set that an error has been logged
1064: p_logged_ind := TRUE;
1065: END IF;
1066: -- create an entry in the system log entry
1067: IGS_GE_GEN_003.genp_ins_log_entry (
1068: p_s_log_type,
1069: p_creation_dt,
1070: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1071: 4209,

Line 1080: -- using IGS_GE_GEN_003.genp_log_error

1076: v_govt_prior_ug_inst := '9999';
1077: -- Check if an entry has been written to the error log
1078: IF p_logged_ind = FALSE THEN
1079: -- log an error to the IGS_GE_S_ERROR_LOG
1080: -- using IGS_GE_GEN_003.genp_log_error
1081:
1082: -- set that an error has been logged
1083: p_logged_ind := TRUE;
1084: END IF;

Line 1086: IGS_GE_GEN_003.genp_ins_log_entry (

1082: -- set that an error has been logged
1083: p_logged_ind := TRUE;
1084: END IF;
1085: -- create an entry in the system log entry
1086: IGS_GE_GEN_003.genp_ins_log_entry (
1087: p_s_log_type,
1088: p_creation_dt,
1089: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1090: 4209,

Line 1106: -- using IGS_GE_GEN_003.genp_log_error

1102: v_prior_other_qual := '999';
1103: -- Check if an entry has been written to the error log
1104: IF p_logged_ind = FALSE THEN
1105: -- log an error to the IGS_GE_S_ERROR_LOG
1106: -- using IGS_GE_GEN_003.genp_log_error
1107:
1108: -- set that an error has been logged
1109: p_logged_ind := TRUE;
1110: END IF;

Line 1112: IGS_GE_GEN_003.genp_ins_log_entry (

1108: -- set that an error has been logged
1109: p_logged_ind := TRUE;
1110: END IF;
1111: -- create an entry in the system log entry
1112: IGS_GE_GEN_003.genp_ins_log_entry (
1113: p_s_log_type,
1114: p_creation_dt,
1115: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1116: 4210,

Line 1132: -- using IGS_GE_GEN_003.genp_log_error

1128: v_prior_post_grad := '999';
1129: -- Check if an entry has been written to the error log
1130: IF p_logged_ind = FALSE THEN
1131: -- log an error to the IGS_GE_S_ERROR_LOG
1132: -- using IGS_GE_GEN_003.genp_log_error
1133:
1134: -- set that an error has been logged
1135: p_logged_ind := TRUE;
1136: END IF;

Line 1138: IGS_GE_GEN_003.genp_ins_log_entry (

1134: -- set that an error has been logged
1135: p_logged_ind := TRUE;
1136: END IF;
1137: -- create an entry in the system log entry
1138: IGS_GE_GEN_003.genp_ins_log_entry (
1139: p_s_log_type,
1140: p_creation_dt,
1141: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1142: 4211,

Line 1158: -- using IGS_GE_GEN_003.genp_log_error

1154: v_prior_degree := '999';
1155: -- Check if an entry has been written to the error log
1156: IF p_logged_ind = FALSE THEN
1157: -- log an error to the IGS_GE_S_ERROR_LOG
1158: -- using IGS_GE_GEN_003.genp_log_error
1159:
1160: -- set that an error has been logged
1161: p_logged_ind := TRUE;
1162: END IF;

Line 1164: IGS_GE_GEN_003.genp_ins_log_entry (

1160: -- set that an error has been logged
1161: p_logged_ind := TRUE;
1162: END IF;
1163: -- create an entry in the system log entry
1164: IGS_GE_GEN_003.genp_ins_log_entry (
1165: p_s_log_type,
1166: p_creation_dt,
1167: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1168: 4212,

Line 1184: -- using IGS_GE_GEN_003.genp_log_error

1180: v_prior_subdeg_notafe := '999';
1181: -- Check if an entry has been written to the error log
1182: IF p_logged_ind = FALSE THEN
1183: -- log an error to the IGS_GE_S_ERROR_LOG
1184: -- using IGS_GE_GEN_003.genp_log_error
1185:
1186: -- set that an error has been logged
1187: p_logged_ind := TRUE;
1188: END IF;

Line 1190: IGS_GE_GEN_003.genp_ins_log_entry (

1186: -- set that an error has been logged
1187: p_logged_ind := TRUE;
1188: END IF;
1189: -- create an entry in the system log entry
1190: IGS_GE_GEN_003.genp_ins_log_entry (
1191: p_s_log_type,
1192: p_creation_dt,
1193: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1194: 4213,

Line 1210: -- using IGS_GE_GEN_003.genp_log_error

1206: v_prior_subdeg_tafe := '999';
1207: -- Check if an entry has been written to the error log
1208: IF p_logged_ind = FALSE THEN
1209: -- log an error to the IGS_GE_S_ERROR_LOG
1210: -- using IGS_GE_GEN_003.genp_log_error
1211:
1212: -- set that an error has been logged
1213: p_logged_ind := TRUE;
1214: END IF;

Line 1216: IGS_GE_GEN_003.genp_ins_log_entry (

1212: -- set that an error has been logged
1213: p_logged_ind := TRUE;
1214: END IF;
1215: -- create an entry in the system log entry
1216: IGS_GE_GEN_003.genp_ins_log_entry (
1217: p_s_log_type,
1218: p_creation_dt,
1219: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1220: 4214,

Line 1236: -- using IGS_GE_GEN_003.genp_log_error

1232: v_prior_seced_tafe := '999';
1233: -- Check if an entry has been written to the error log
1234: IF p_logged_ind = FALSE THEN
1235: -- log an error to the IGS_GE_S_ERROR_LOG
1236: -- using IGS_GE_GEN_003.genp_log_error
1237:
1238: -- set that an error has been logged
1239: p_logged_ind := TRUE;
1240: END IF;

Line 1242: IGS_GE_GEN_003.genp_ins_log_entry (

1238: -- set that an error has been logged
1239: p_logged_ind := TRUE;
1240: END IF;
1241: -- create an entry in the system log entry
1242: IGS_GE_GEN_003.genp_ins_log_entry (
1243: p_s_log_type,
1244: p_creation_dt,
1245: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1246: 4215,

Line 1262: -- using IGS_GE_GEN_003.genp_log_error

1258: v_prior_seced_school := '999';
1259: -- Check if an entry has been written to the error log
1260: IF p_logged_ind = FALSE THEN
1261: -- log an error to the IGS_GE_S_ERROR_LOG
1262: -- using IGS_GE_GEN_003.genp_log_error
1263:
1264: -- set that an error has been logged
1265: p_logged_ind := TRUE;
1266: END IF;

Line 1268: IGS_GE_GEN_003.genp_ins_log_entry (

1264: -- set that an error has been logged
1265: p_logged_ind := TRUE;
1266: END IF;
1267: -- create an entry in the system log entry
1268: IGS_GE_GEN_003.genp_ins_log_entry (
1269: p_s_log_type,
1270: p_creation_dt,
1271: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1272: 4216,

Line 1288: -- using IGS_GE_GEN_003.genp_log_error

1284: v_prior_tafe_award := '999';
1285: -- Check if an entry has been written to the error log
1286: IF p_logged_ind = FALSE THEN
1287: -- log an error to the IGS_GE_S_ERROR_LOG
1288: -- using IGS_GE_GEN_003.genp_log_error
1289:
1290: -- set that an error has been logged
1291: p_logged_ind := TRUE;
1292: END IF;

Line 1294: IGS_GE_GEN_003.genp_ins_log_entry (

1290: -- set that an error has been logged
1291: p_logged_ind := TRUE;
1292: END IF;
1293: -- create an entry in the system log entry
1294: IGS_GE_GEN_003.genp_ins_log_entry (
1295: p_s_log_type,
1296: p_creation_dt,
1297: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1298: 4217,