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_011 dependencies on IGS_PE_SN_SRVCE_INT

Line 1217: FROM igs_pe_sn_srvce_int ai,

1213: --Pick up the records for processing from the Special Needs Service Interface Table
1214: CURSOR sn_service_cur(cp_interface_disablty_id igs_ad_disablty_int.interface_disablty_id%TYPE,
1215: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE ) IS
1216: SELECT ai.*
1217: FROM igs_pe_sn_srvce_int ai,
1218: igs_ad_disablty_int_all ad
1219: WHERE ai.interface_run_id = cp_interface_run_id AND
1220: ad.interface_run_id = cp_interface_run_id AND
1221: ai.interface_disablty_id = cp_interface_disablty_id AND

Line 1555: UPDATE igs_pe_sn_srvce_int

1551: END IF;
1552: CLOSE birth_dt_cur;
1553: END IF;
1554:
1555: UPDATE igs_pe_sn_srvce_int
1556: SET status = '1',
1557: ERROR_CODE = NULL
1558: WHERE interface_sn_service_id = p_sn_service_rec.interface_sn_service_id;
1559:

Line 1566: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

1562: EXCEPTION
1563:
1564: WHEN NO_DATA_FOUND THEN
1565: IF l_enable_log = 'Y' THEN
1566: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
1567: END IF;
1568:
1569:
1570: UPDATE igs_pe_sn_srvce_int

Line 1570: UPDATE igs_pe_sn_srvce_int

1566: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
1567: END IF;
1568:
1569:
1570: UPDATE igs_pe_sn_srvce_int
1571: SET status = '3',
1572: ERROR_CODE = l_error_code
1573: WHERE interface_sn_service_id = p_sn_service_rec.interface_sn_service_id;
1574:

Line 1930: l_error_code igs_pe_sn_srvce_int.error_code%TYPE;

1926: || (reverse chronological order - newest change first)
1927: */
1928: l_rowid VARCHAR2(25);
1929: l_success VARCHAR2(1);
1930: l_error_code igs_pe_sn_srvce_int.error_code%TYPE;
1931: l_sn_service_id igs_pe_sn_service.sn_service_id%TYPE;
1932:
1933: BEGIN
1934:

Line 1968: UPDATE igs_pe_sn_srvce_int

1964: x_mode => 'R'
1965: );
1966: l_error_code := NULL;
1967:
1968: UPDATE igs_pe_sn_srvce_int
1969: SET status ='1',
1970: error_code = l_error_code
1971: WHERE interface_sn_service_id = p_sn_service_rec.interface_sn_service_id;
1972:

Line 1981: UPDATE igs_pe_sn_srvce_int

1977: WHEN OTHERS THEN
1978: l_error_code := 'E151';
1979: p_status := '3';
1980:
1981: UPDATE igs_pe_sn_srvce_int
1982: SET status ='3',
1983: error_code = l_error_code
1984: WHERE interface_sn_service_id = p_sn_service_rec.interface_sn_service_id;
1985:

Line 2009: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

2005: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2006: END IF;
2007:
2008: IF l_enable_log = 'Y' THEN
2009: igs_ad_imp_001.logerrormessage(p_sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
2010: END IF;
2011:
2012: END create_sn_service;
2013:

Line 2162: UPDATE igs_pe_sn_srvce_int

2158: END IF;
2159:
2160: --1. If rule is E or I, then if the match_ind is not null, the combination is invalid
2161: IF l_rule IN ('E','I') THEN
2162: UPDATE igs_pe_sn_srvce_int
2163: SET status = cst_stat_val_3,
2164: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
2165: WHERE match_ind IS NOT NULL
2166: AND status = cst_stat_val_2

Line 2172: UPDATE igs_pe_sn_srvce_int mi

2168: END IF;
2169:
2170: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
2171: IF l_rule = 'E' THEN
2172: UPDATE igs_pe_sn_srvce_int mi
2173: SET status = cst_stat_val_1,
2174: match_ind = cst_mi_val_19
2175: WHERE mi.interface_run_id = l_interface_run_id
2176: AND mi.status = cst_stat_val_2

Line 2189: UPDATE igs_pe_sn_srvce_int

2185:
2186: --3. If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
2187: -- processed in prior runs and didn't get updated .. update to status 1
2188: IF l_rule = 'R' THEN
2189: UPDATE igs_pe_sn_srvce_int
2190: SET status = cst_stat_val_1
2191: WHERE interface_run_id = l_interface_run_id
2192: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
2193: AND status = cst_stat_val_2;

Line 2198: UPDATE igs_pe_sn_srvce_int

2194: END IF;
2195:
2196: --4. If rule is R and match_ind is neither 21 nor 25 then error
2197: IF l_rule = 'R' THEN
2198: UPDATE igs_pe_sn_srvce_int
2199: SET status = cst_stat_val_3,
2200: ERROR_CODE = cst_err_val_695
2201: WHERE interface_run_id = l_interface_run_id
2202: AND status = cst_stat_val_2

Line 2208: UPDATE igs_pe_sn_srvce_int mi

2204: END IF;
2205:
2206: --5. If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
2207: IF l_rule = 'R' THEN
2208: UPDATE igs_pe_sn_srvce_int mi
2209: SET status = cst_stat_val_1,
2210: match_ind = cst_mi_val_23
2211: WHERE mi.interface_run_id = l_interface_run_id
2212: AND mi.match_ind IS NULL

Line 2228: UPDATE igs_pe_sn_srvce_int mi

2224:
2225:
2226: --6. If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
2227: IF l_rule = 'R' THEN
2228: UPDATE igs_pe_sn_srvce_int mi
2229: SET status = cst_stat_val_3,
2230: match_ind = cst_mi_val_20,
2231: dup_sn_service_id = (SELECT sn_service_id
2232: FROM igs_pe_sn_service pe

Line 2277: UPDATE igs_pe_sn_srvce_int

2273: x_end_dt => NVL(sn_service_rec.end_dt,dup_chk_sn_service_rec.end_dt),
2274: x_mode => 'R'
2275: );
2276: l_error_code := NULL;
2277: UPDATE igs_pe_sn_srvce_int
2278: SET status =cst_stat_val_1,
2279: error_code = l_error_code,
2280: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
2281: WHERE interface_sn_service_id = sn_service_rec.interface_sn_service_id;

Line 2291: UPDATE igs_pe_sn_srvce_int

2287: WHEN OTHERS THEN
2288: l_error_code := 'E152';
2289: p_status := '3';
2290:
2291: UPDATE igs_pe_sn_srvce_int
2292: SET status ='3',
2293: error_code = l_error_code
2294: WHERE interface_sn_service_id = sn_service_rec.interface_sn_service_id;
2295:

Line 2319: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

2315: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2316: END IF;
2317:
2318: IF l_enable_log = 'Y' THEN
2319: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
2320: END IF;
2321:
2322: END;
2323: ELSIF l_rule = 'R' THEN

Line 2342: UPDATE igs_pe_sn_srvce_int

2338: x_mode => 'R'
2339: );
2340: l_error_code := NULL;
2341:
2342: UPDATE igs_pe_sn_srvce_int
2343: SET status =cst_stat_val_1,
2344: error_code = l_error_code,
2345: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
2346: WHERE interface_sn_service_id = sn_service_rec.interface_sn_service_id;

Line 2356: UPDATE igs_pe_sn_srvce_int

2352: WHEN OTHERS THEN
2353: l_error_code := 'E152';
2354: p_status := '3';
2355:
2356: UPDATE igs_pe_sn_srvce_int
2357: SET status ='3',
2358: error_code = l_error_code
2359: WHERE interface_sn_service_id = sn_service_rec.interface_sn_service_id;
2360:

Line 2384: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');

2380: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2381: END IF;
2382:
2383: IF l_enable_log = 'Y' THEN
2384: igs_ad_imp_001.logerrormessage(sn_service_rec.interface_sn_service_id,l_error_code,'IGS_PE_SN_SRVCE_INT');
2385: END IF;
2386:
2387: END;
2388: END IF; -- service_rec.MATCH_IND check

Line 2895: UPDATE igs_pe_sn_srvce_int

2891: OPEN check_none_disablity_cur(disability_rec.disability_type,'NONE');
2892: FETCH check_none_disablity_cur INTO l_var;
2893: CLOSE check_none_disablity_cur;
2894: IF l_var = 'X' THEN
2895: UPDATE igs_pe_sn_srvce_int
2896: SET status ='3',
2897: error_code = 'E271'
2898: WHERE INTERFACE_DISABLTY_ID = disability_rec.interface_disablty_id;
2899:

Line 2910: OR EXISTS (SELECT 1 FROM igs_pe_sn_srvce_int WHERE interface_disablty_id = disability_rec.interface_disablty_id AND status = '3'));

2906: SET status = '4',
2907: error_code = 'E347'
2908: WHERE interface_disablty_id = disability_rec.interface_disablty_id AND
2909: (EXISTS (SELECT 1 FROM igs_pe_sn_conct_int WHERE interface_disablty_id = disability_rec.interface_disablty_id AND status = '3')
2910: OR EXISTS (SELECT 1 FROM igs_pe_sn_srvce_int WHERE interface_disablty_id = disability_rec.interface_disablty_id AND status = '3'));
2911:
2912: IF ((l_enable_log = 'Y') and (SQL%FOUND)) THEN
2913: fnd_message.set_name('IGS','IGS_EN_CONIND_NOTSET_NONE');
2914: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

Line 2976: UPDATE igs_pe_sn_srvce_int

2972: OPEN check_none_disablity_cur(sp_disability_rec.disability_type,'NONE');
2973: FETCH check_none_disablity_cur INTO l_var;
2974: CLOSE check_none_disablity_cur;
2975: IF l_var = 'X' THEN
2976: UPDATE igs_pe_sn_srvce_int
2977: SET status ='3',
2978: error_code = 'E271'
2979: WHERE INTERFACE_DISABLTY_ID = sp_disability_rec.interface_disablty_id;
2980:

Line 2993: OR EXISTS (SELECT 1 FROM igs_pe_sn_srvce_int WHERE

2989: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id AND
2990: (
2991: EXISTS(SELECT 1 FROM igs_pe_sn_conct_int WHERE
2992: interface_disablty_id = sp_disability_rec.interface_disablty_id AND status = '3')
2993: OR EXISTS (SELECT 1 FROM igs_pe_sn_srvce_int WHERE
2994: interface_disablty_id = sp_disability_rec.interface_disablty_id AND status = '3')
2995: );
2996:
2997: IF ((l_enable_log = 'Y') and (SQL%FOUND)) THEN