1018: IF c_adv%FOUND THEN
1019: CLOSE c_adv;
1020: IF p_log_creation_dt IS NOT NULL THEN
1021: -- Write to the exception log
1022: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1023: cst_pre_enrol,
1024: p_log_creation_dt,
1025: cst_minor || ',' ||
1026: TO_CHAR(p_person_id) || ',' ||
1044: SYSDATE,
1045: v_message_name) THEN
1046: IF p_log_creation_dt IS NOT NULL THEN
1047: -- Write to the exception log
1048: IGS_GE_GEN_003.GENP_INS_LOG_ENTRY(
1049: cst_pre_enrol,
1050: p_log_creation_dt,
1051: cst_minor || ',' ||
1052: TO_CHAR(p_person_id) || ',' ||