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_012 dependencies on IGS_PE_ATH_PRG_INT

Line 2140: l_error_code igs_pe_ath_prg_int.error_code%TYPE;

2136: lookup caching related changes, and cursor parameterization.
2137: */
2138:
2139: l_rule VARCHAR2(1);
2140: l_error_code igs_pe_ath_prg_int.error_code%TYPE;
2141: l_status igs_pe_ath_prg_int.status%TYPE;
2142: l_default_date DATE := IGS_GE_DATE.IGSDATE('4712/12/31');
2143: l_processed_records NUMBER(5) := 0;
2144: -- variables for logging

Line 2141: l_status igs_pe_ath_prg_int.status%TYPE;

2137: */
2138:
2139: l_rule VARCHAR2(1);
2140: l_error_code igs_pe_ath_prg_int.error_code%TYPE;
2141: l_status igs_pe_ath_prg_int.status%TYPE;
2142: l_default_date DATE := IGS_GE_DATE.IGSDATE('4712/12/31');
2143: l_processed_records NUMBER(5) := 0;
2144: -- variables for logging
2145: l_prog_label VARCHAR2(4000);

Line 2156: FROM igs_pe_ath_prg_int ai, igs_ad_interface_all i

2152:
2153: --Pick up the records for processing from the Athletic Programs Interface Table
2154: CURSOR ath_prg_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
2155: SELECT ai.*, i.person_id
2156: FROM igs_pe_ath_prg_int ai, igs_ad_interface_all i
2157: WHERE ai.interface_run_id = cp_interface_run_id
2158: AND i.interface_id = ai.interface_id
2159: AND i.interface_run_id = cp_interface_run_id
2160: AND ai.status = '2';

Line 2185: l_error_code igs_pe_ath_prg_int.error_code%TYPE;

2181: )
2182: AS
2183: l_rowid VARCHAR2(25);
2184: l_athletic_prg_id igs_pe_athletic_prg.athletic_prg_id%TYPE;
2185: l_error_code igs_pe_ath_prg_int.error_code%TYPE;
2186: BEGIN
2187: -- Call Log header
2188: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
2189:

Line 2218: UPDATE igs_pe_ath_prg_int

2214: x_last_update_dt => p_ath_prg_rec.last_update_date,
2215: x_mode => 'R'
2216: );
2217: l_error_code:=NULL;
2218: UPDATE igs_pe_ath_prg_int
2219: SET status = '1',
2220: error_code = l_error_code
2221: WHERE interface_athletic_prg_id = p_ath_prg_rec.interface_athletic_prg_id;
2222:

Line 2227: UPDATE igs_pe_ath_prg_int

2223: EXCEPTION
2224: WHEN OTHERS THEN
2225: l_error_code := 'E099'; -- Athletics Program Insertion Failed
2226:
2227: UPDATE igs_pe_ath_prg_int
2228: SET status = '3',
2229: error_code = l_error_code
2230: WHERE interface_athletic_prg_id = p_ath_prg_rec.interface_athletic_prg_id;
2231:

Line 2255: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2251: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2252: END IF;
2253:
2254: IF l_enable_log = 'Y' THEN
2255: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2256: END IF;
2257: END crt_apcnt_ath_prg;
2258: -- END OF LOCAL PROCEDURE crt_apcnt_ath_prg
2259:

Line 2263: l_error_code igs_pe_ath_prg_int.error_code%TYPE;

2259:
2260: -- Start Local function Validate_Record
2261: FUNCTION validate_record(p_ath_prg_rec IN ath_prg_cur%ROWTYPE)
2262: RETURN BOOLEAN IS
2263: l_error_code igs_pe_ath_prg_int.error_code%TYPE;
2264: l_birth_dt IGS_AD_INTERFACE.BIRTH_DT%TYPE;
2265:
2266: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS
2267: SELECT Birth_date

Line 2327: UPDATE igs_pe_ath_prg_int

2323: RETURN TRUE;
2324: EXCEPTION
2325: WHEN OTHERS THEN
2326:
2327: UPDATE igs_pe_ath_prg_int
2328: SET status = '3',
2329: error_code = l_error_code
2330: WHERE interface_athletic_prg_id = p_ath_prg_rec.interface_athletic_prg_id;
2331:

Line 2355: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2351: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2352: END IF;
2353:
2354: IF l_enable_log = 'Y' THEN
2355: igs_ad_imp_001.logerrormessage(p_ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2356: END IF;
2357:
2358: RETURN FALSE;
2359: END validate_record;

Line 2392: UPDATE igs_pe_ath_prg_int

2388:
2389:
2390: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid
2391: IF l_rule IN ('E','I') THEN
2392: UPDATE igs_pe_ath_prg_int
2393: SET status = cst_stat_val_3,
2394: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
2395: WHERE match_ind IS NOT NULL
2396: AND interface_run_id = l_interface_run_id

Line 2403: UPDATE igs_pe_ath_prg_int ai

2399:
2400: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
2401: IF l_rule = 'E' THEN
2402: --skpandey, Bug#3702782, Changed select statement for optimization
2403: UPDATE igs_pe_ath_prg_int ai
2404: SET status = cst_stat_val_1,
2405: match_ind = cst_mi_val_19
2406: WHERE ai.interface_run_id = l_interface_run_id
2407: AND ai.status = cst_stat_val_2

Line 2421: UPDATE igs_pe_ath_prg_int

2417:
2418: -- 3.If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
2419: -- processed in prior runs and didn't get updated .. update to status 1
2420: IF l_rule = 'R' THEN
2421: UPDATE igs_pe_ath_prg_int
2422: SET status = cst_stat_val_1
2423: WHERE interface_run_id = l_interface_run_id
2424: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
2425: AND status=cst_stat_val_2;

Line 2430: UPDATE igs_pe_ath_prg_int

2426: END IF;
2427:
2428: -- 4.If rule is R and match_ind is neither 21 nor 25 then error
2429: IF l_rule = 'R' THEN
2430: UPDATE igs_pe_ath_prg_int
2431: SET status = cst_stat_val_3,
2432: ERROR_CODE = cst_err_val_695
2433: WHERE interface_run_id = l_interface_run_id
2434: AND (match_ind IS NOT NULL AND match_ind NOT IN (cst_mi_val_21,cst_mi_val_25))

Line 2441: UPDATE igs_pe_ath_prg_int ai

2437:
2438: -- 5.If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
2439: IF l_rule = 'R' THEN
2440: --skpandey, Bug#3702782, Changed select statement for optimization
2441: UPDATE igs_pe_ath_prg_int ai
2442: SET status = cst_stat_val_1,
2443: match_ind = cst_mi_val_23
2444: WHERE ai.interface_run_id = l_interface_run_id
2445: AND ai.match_ind IS NULL

Line 2463: UPDATE igs_pe_ath_prg_int ai

2459:
2460: -- 6.If rule in R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
2461: IF l_rule = 'R' THEN
2462: --skpandey, Bug#3702782, Changed select statement for optimization
2463: UPDATE igs_pe_ath_prg_int ai
2464: SET status = cst_stat_val_3,
2465: match_ind = cst_mi_val_20,
2466: dup_athletic_prg_id = (SELECT athletic_prg_id
2467: FROM igs_pe_athletic_prg pe, igs_ad_interface_all i

Line 2525: UPDATE igs_pe_ath_prg_int

2521: );
2522: l_error_code := NULL;
2523: l_status := '1';
2524:
2525: UPDATE igs_pe_ath_prg_int
2526: SET status = l_status,
2527: error_code = l_error_code,
2528: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
2529: WHERE interface_athletic_prg_id = ath_prg_rec.interface_athletic_prg_id;

Line 2536: UPDATE igs_pe_ath_prg_int

2532: WHEN OTHERS THEN
2533: l_error_code := 'E100'; -- Could not update Person Athletics Program Details
2534: l_status := '3';
2535:
2536: UPDATE igs_pe_ath_prg_int
2537: SET status = l_status,
2538: error_code = l_error_code
2539: WHERE interface_athletic_prg_id = ath_prg_rec.interface_athletic_prg_id;
2540:

Line 2564: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2560: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2561: END IF;
2562:
2563: IF l_enable_log = 'Y' THEN
2564: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2565: END IF;
2566:
2567: END;
2568:

Line 2588: UPDATE igs_pe_ath_prg_int

2584: );
2585: l_error_code := NULL;
2586: l_status := '1';
2587:
2588: UPDATE igs_pe_ath_prg_int
2589: SET status = l_status,
2590: error_code = l_error_code,
2591: match_ind = cst_mi_val_18
2592: WHERE interface_athletic_prg_id = ath_prg_rec.interface_athletic_prg_id;

Line 2599: UPDATE igs_pe_ath_prg_int

2595: WHEN OTHERS THEN
2596: l_error_code := 'E100'; -- Could not update Person Athletics Program Details
2597: l_status := '3';
2598:
2599: UPDATE igs_pe_ath_prg_int
2600: SET status = l_status,
2601: error_code = l_error_code
2602: WHERE interface_athletic_prg_id = ath_prg_rec.interface_athletic_prg_id;
2603:

Line 2627: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');

2623: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2624: END IF;
2625:
2626: IF l_enable_log = 'Y' THEN
2627: igs_ad_imp_001.logerrormessage(ath_prg_rec.interface_athletic_prg_id,l_error_code,'IGS_PE_ATH_PRG_INT');
2628: END IF;
2629:
2630: END;
2631: