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

Line 819: IGS_GE_GEN_003.genp_ins_log_entry (

815: -- set that an error has been logged
816: p_logged_ind := TRUE;
817: END IF;
818: --Create an entry in the system log entry
819: IGS_GE_GEN_003.genp_ins_log_entry (
820: p_s_log_type,
821: p_creation_dt,
822: 'IGS_PE_PERSON IGS_PS_COURSE IGS_PS_UNIT ' || ',' ||
823: TO_CHAR(p_person_id) || ',' ||

Line 912: -- using IGS_GE_GEN_003.genp_log_error

908: CLOSE c_get_person_dtls;
909: IF (p_birth_dt IS NULL) THEN
910: IF (p_logged_ind = FALSE) THEN
911: -- log an error to the IGS_GE_S_ERROR_LOG
912: -- using IGS_GE_GEN_003.genp_log_error
913:
914: -- set that an error has been logged
915: p_logged_ind := TRUE;
916: END IF;

Line 918: IGS_GE_GEN_003.genp_ins_log_entry (

914: -- set that an error has been logged
915: p_logged_ind := TRUE;
916: END IF;
917: -- create an entry in the system log entry
918: IGS_GE_GEN_003.genp_ins_log_entry (
919: p_s_log_type,
920: p_creation_dt,
921: 'IGS_PE_PERSON' || ',' ||
922: TO_CHAR(p_current_person_id),

Line 937: -- using IGS_GE_GEN_003.genp_log_error

933: IF (c_prsn_stats%NOTFOUND) THEN
934: CLOSE c_prsn_stats;
935: IF (p_logged_ind = FALSE) THEN
936: -- log an error to the IGS_GE_S_ERROR_LOG
937: -- using IGS_GE_GEN_003.genp_log_error
938:
939: p_logged_ind := TRUE;
940: END IF;
941: -- create an entry in the system log entry

Line 942: IGS_GE_GEN_003.genp_ins_log_entry (

938:
939: p_logged_ind := TRUE;
940: END IF;
941: -- create an entry in the system log entry
942: IGS_GE_GEN_003.genp_ins_log_entry (
943: p_s_log_type,
944: p_creation_dt,
945: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_current_person_id),
946: 4196,

Line 964: -- using IGS_GE_GEN_003.genp_log_error

960: p_citizenship_cd := '9';
961: p_govt_citizenship_cd := 9;
962: IF (p_logged_ind = FALSE) THEN
963: -- log an error to the IGS_GE_S_ERROR_LOG
964: -- using IGS_GE_GEN_003.genp_log_error
965:
966: p_logged_ind := TRUE;
967: END IF;
968: -- create an entry in the system log entry

Line 969: IGS_GE_GEN_003.genp_ins_log_entry (

965:
966: p_logged_ind := TRUE;
967: END IF;
968: -- create an entry in the system log entry
969: IGS_GE_GEN_003.genp_ins_log_entry (
970: p_s_log_type,
971: p_creation_dt,
972: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_current_person_id),
973: 4202,

Line 989: -- using IGS_GE_GEN_003.genp_log_error

985: p_perm_resident_cd := '9';
986: p_govt_perm_resident_cd := 9;
987: IF (p_logged_ind = FALSE) THEN
988: -- log an error to the IGS_GE_S_ERROR_LOG
989: -- using IGS_GE_GEN_003.genp_log_error
990:
991: p_logged_ind := TRUE;
992: END IF;
993: -- create an entry in the system log entry

Line 994: IGS_GE_GEN_003.genp_ins_log_entry (

990:
991: p_logged_ind := TRUE;
992: END IF;
993: -- create an entry in the system log entry
994: IGS_GE_GEN_003.genp_ins_log_entry (
995: p_s_log_type,
996: p_creation_dt,
997: 'IGS_PE_PERSON' || ',' ||
998: TO_CHAR(p_current_person_id),

Line 1006: -- using IGS_GE_GEN_003.genp_log_error

1002: p_perm_resident_cd := '0';
1003: p_govt_perm_resident_cd := 0;
1004: IF (p_logged_ind = FALSE) THEN
1005: -- log an error to the IGS_GE_S_ERROR_LOG
1006: -- using IGS_GE_GEN_003.genp_log_error
1007:
1008: -- set that an error has been logged
1009: p_logged_ind := TRUE;
1010: END IF;

Line 1012: IGS_GE_GEN_003.genp_ins_log_entry (

1008: -- set that an error has been logged
1009: p_logged_ind := TRUE;
1010: END IF;
1011: -- create an entry in the system log entry
1012: IGS_GE_GEN_003.genp_ins_log_entry (
1013: p_s_log_type,
1014: p_creation_dt,
1015: 'IGS_PE_PERSON' || ',' ||
1016: TO_CHAR(p_current_person_id),

Line 1167: -- been written to the IGS_GE_S_ERROR_LOG table (using IGS_GE_GEN_003.genp_log_error),

1163: RETURN FALSE;
1164: END IF;
1165: -- initialise the system log variables
1166: -- this flag is used to indicate whether or not an entry has
1167: -- been written to the IGS_GE_S_ERROR_LOG table (using IGS_GE_GEN_003.genp_log_error),
1168: -- stating that entries have been written to the system log
1169: v_logged_ind := FALSE;
1170: v_s_log_type := 'GOVT-SBMSN';
1171: -- check if the submission is complete

Line 1331: IGS_GE_GEN_003.genp_ins_log (

1327: END;
1328: COMMIT;
1329:
1330: -- Create an entry in the system log.
1331: IGS_GE_GEN_003.genp_ins_log (
1332: v_s_log_type,
1333: TO_CHAR(p_submission_yr) ||
1334: ' ' ||
1335: TO_CHAR(p_submission_number) ||

Line 2329: IGS_GE_GEN_003.genp_ins_log_entry (

2325: END;
2326: IF v_total_eftsu > 1 THEN
2327: --Check if an entry has been written to the error log
2328: --Create an entry in the system log entry
2329: IGS_GE_GEN_003.genp_ins_log_entry (
2330: v_s_log_type,
2331: IGS_GE_DATE.igscharDT(v_creation_dt),
2332: 'IGS_PE_PERSON IGS_PS_COURSE ' || ',' || TO_CHAR(v_person_id) || ',' || v_course_cd,
2333: 4222,

Line 2631: IGS_GE_GEN_003.genp_ins_log_entry(

2627: IF v_logged_ind = FALSE THEN
2628:
2629: v_logged_ind := TRUE;
2630: END IF;
2631: IGS_GE_GEN_003.genp_ins_log_entry(
2632: v_s_log_type,
2633: v_creation_dt,
2634: 'IGS_PE_PERSON IGS_PS_COURSE,' ||
2635: TO_CHAR(v_update_total_eftsu.person_id) || ',' ||

Line 2690: IGS_GE_GEN_003.genp_ins_log_entry(

2686: IF v_update_indus_eftsu.v_upd_indus_eftsu > 1 THEN
2687: IF v_logged_ind = FALSE THEN
2688: v_logged_ind := TRUE;
2689: END IF;
2690: IGS_GE_GEN_003.genp_ins_log_entry(
2691: v_s_log_type,
2692: v_creation_dt,
2693: 'IGS_PE_PERSON IGS_PS_COURSE,' ||
2694: TO_CHAR(v_update_indus_eftsu.person_id) || ',' ||