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_AD_DISABLTY_INT_ALL

Line 1197: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i

1193:
1194: --Pick up the records for processing from the Special Needs Disability Interface Table
1195: CURSOR disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1196: SELECT mi.*,i.person_id
1197: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i
1198: WHERE mi.interface_run_id = cp_interface_run_id
1199: AND i.interface_run_id = cp_interface_run_id
1200: AND mi.interface_id = i.interface_id
1201: AND mi.status = '2';

Line 1206: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i

1202:
1203: -- Pick up the records processed before the loop from the Disability Interface Table
1204: CURSOR sp_disability_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1205: SELECT mi.*,i.person_id
1206: FROM igs_ad_disablty_int_all mi,igs_ad_interface_all i
1207: WHERE mi.interface_run_id = cp_interface_run_id
1208: AND i.interface_run_id = cp_interface_run_id
1209: AND mi.interface_id = i.interface_id
1210: AND mi.status = '1'

Line 1218: igs_ad_disablty_int_all ad

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
1222: ai.interface_disablty_id = ad.interface_disablty_id AND

Line 1230: igs_ad_disablty_int_all ad

1226: CURSOR sn_contact_cur(cp_interface_disablty_id igs_ad_disablty_int.interface_disablty_id%TYPE,
1227: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE ) IS
1228: SELECT ai.*
1229: FROM igs_pe_sn_conct_int ai,
1230: igs_ad_disablty_int_all ad
1231: WHERE ai.interface_run_id = cp_interface_run_id AND
1232: ad.interface_run_id = cp_interface_run_id AND
1233: ai.interface_disablty_id = cp_interface_disablty_id AND
1234: ai.interface_disablty_id = ad.interface_disablty_id AND

Line 1451: UPDATE igs_ad_disablty_int_all

1447: l_error_code := NULL;
1448: END IF;
1449: END IF;
1450:
1451: UPDATE igs_ad_disablty_int_all
1452: SET status = '1',
1453: ERROR_CODE = NULL
1454: WHERE interface_disablty_id = p_disability_rec.interface_disablty_id;
1455:

Line 1461: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');

1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459:
1460: IF l_enable_log = 'Y' THEN
1461: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1462: END IF;
1463:
1464: UPDATE igs_ad_disablty_int_all
1465: SET status = '3',

Line 1464: UPDATE igs_ad_disablty_int_all

1460: IF l_enable_log = 'Y' THEN
1461: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1462: END IF;
1463:
1464: UPDATE igs_ad_disablty_int_all
1465: SET status = '3',
1466: ERROR_CODE = l_error_code
1467: WHERE interface_disablty_id = p_disability_rec.interface_disablty_id;
1468:

Line 1711: UPDATE igs_ad_disablty_int_all

1707: x_mode => 'R'
1708: );
1709: p_error_code := NULL;
1710:
1711: UPDATE igs_ad_disablty_int_all
1712: SET status ='1',
1713: ERROR_CODE = p_error_code
1714: WHERE interface_disablty_id = p_disability_rec.interface_disablty_id;
1715:

Line 1731: UPDATE igs_ad_disablty_int_all

1727: p_error_code := 'E145';
1728: END IF;
1729:
1730:
1731: UPDATE igs_ad_disablty_int_all
1732: SET status ='3',
1733: ERROR_CODE = p_error_code
1734: WHERE interface_disablty_id = p_disability_rec.interface_disablty_id;
1735:

Line 1751: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,'E145','IGS_AD_DISABLTY_INT_ALL');

1747: l_debug_str, NULL,
1748: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1749: END IF;
1750: IF l_enable_log = 'Y' THEN
1751: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,'E145','IGS_AD_DISABLTY_INT_ALL');
1752: END IF;
1753: ELSE
1754: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1755: IF (l_request_id IS NULL) THEN

Line 1768: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,p_error_code,'IGS_AD_DISABLTY_INT_ALL');

1764: l_debug_str, NULL,
1765: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1766: END IF;
1767: IF l_enable_log = 'Y' THEN
1768: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,p_error_code,'IGS_AD_DISABLTY_INT_ALL');
1769: END IF;
1770: END IF;
1771:
1772:

Line 1835: UPDATE igs_ad_disablty_int_all

1831: x_mode => 'R'
1832: );
1833: l_error_code := NULL;
1834:
1835: UPDATE igs_ad_disablty_int_all
1836: SET status =cst_stat_val_1,
1837: error_code = l_error_code,
1838: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
1839: WHERE interface_disablty_id = p_disability_rec.interface_disablty_id;

Line 1852: UPDATE igs_ad_disablty_int_all

1848: ELSE
1849: l_error_code := 'E146';
1850: END IF;
1851:
1852: UPDATE igs_ad_disablty_int_all
1853: SET status ='3',
1854: error_code = l_error_code
1855: WHERE interface_disablty_id = p_disability_rec.interface_disablty_id;
1856:

Line 1878: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');

1874: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1875: END IF;
1876:
1877: IF l_enable_log = 'Y' THEN
1878: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1879: END IF;
1880:
1881: ELSE
1882: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN

Line 1902: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');

1898: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1899: END IF;
1900:
1901: IF l_enable_log = 'Y' THEN
1902: igs_ad_imp_001.logerrormessage(p_disability_rec.interface_disablty_id,l_error_code,'IGS_AD_DISABLTY_INT_ALL');
1903: END IF;
1904:
1905: END IF;
1906:

Line 2725: UPDATE igs_ad_disablty_int_all

2721:
2722:
2723: --1. If rule is E or I, then if the match_ind is not null, the combination is invalid
2724: IF l_rule IN ('E','I') THEN
2725: UPDATE igs_ad_disablty_int_all
2726: SET status = cst_stat_val_3,
2727: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
2728: WHERE match_ind IS NOT NULL
2729: AND status = cst_stat_val_2

Line 2736: UPDATE igs_ad_disablty_int_all mi

2732:
2733: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
2734: IF l_rule = 'E' THEN
2735: --skpandey, Bug#3702774, Changed select statement for optimization
2736: UPDATE igs_ad_disablty_int_all mi
2737: SET status = cst_stat_val_1,
2738: match_ind = cst_mi_val_19,
2739: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2740: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

Line 2760: UPDATE igs_ad_disablty_int_all

2756:
2757: --3. If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
2758: -- processed in prior runs and didn't get updated .. update to status 1
2759: IF l_rule = 'R' THEN
2760: UPDATE igs_ad_disablty_int_all
2761: SET status = cst_stat_val_1
2762: WHERE interface_run_id = l_interface_run_id
2763: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
2764: AND status = cst_stat_val_2;

Line 2769: UPDATE igs_ad_disablty_int_all

2765: END IF;
2766:
2767: --4. If rule is R and match_ind is neither 21 nor 25 then error
2768: IF l_rule = 'R' THEN
2769: UPDATE igs_ad_disablty_int_all
2770: SET status = cst_stat_val_3,
2771: ERROR_CODE = cst_err_val_695
2772: WHERE interface_run_id = l_interface_run_id
2773: AND status = cst_stat_val_2

Line 2780: UPDATE igs_ad_disablty_int_all mi

2776:
2777: --5. If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
2778: IF l_rule = 'R' THEN
2779: --skpandey, Bug#3702774, Changed select statement for optimization
2780: UPDATE igs_ad_disablty_int_all mi
2781: SET status = cst_stat_val_1,
2782: match_ind = cst_mi_val_23,
2783: dup_disability_id = ( SELECT pe.igs_pe_pers_disablty_id
2784: FROM igs_pe_pers_disablty pe, igs_ad_interface_all ii

Line 2819: UPDATE igs_ad_disablty_int_all mi

2815:
2816: --6. If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
2817: IF l_rule = 'R' THEN
2818: --skpandey, Bug#3702774, Changed select statement for optimization
2819: UPDATE igs_ad_disablty_int_all mi
2820: SET status = cst_stat_val_3,
2821: match_ind = cst_mi_val_20
2822: WHERE mi.interface_run_id = l_interface_run_id
2823: AND mi.match_ind IS NULL

Line 2905: UPDATE igs_ad_disablty_int_all

2901: SET status ='3',
2902: error_code = 'E272'
2903: WHERE INTERFACE_DISABLTY_ID = disability_rec.interface_disablty_id;
2904:
2905: UPDATE igs_ad_disablty_int_all
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')

Line 2915: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');

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);
2915: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');
2916: END IF;
2917:
2918: ELSE
2919: process_sn_service(disability_rec.interface_disablty_id, l_disability_id, disability_rec.person_id,l_contact_status);

Line 2922: UPDATE igs_ad_disablty_int_all

2918: ELSE
2919: process_sn_service(disability_rec.interface_disablty_id, l_disability_id, disability_rec.person_id,l_contact_status);
2920: process_sn_contact(disability_rec.interface_disablty_id, l_disability_id, disability_rec.person_id,l_service_status);
2921: IF l_contact_status = '3' AND l_service_status = '3' THEN
2922: UPDATE igs_ad_disablty_int_all
2923: SET status = '4',
2924: error_code = 'E155'
2925: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2926:

Line 2928: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');

2924: error_code = 'E155'
2925: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2926:
2927: IF l_enable_log = 'Y' THEN
2928: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');
2929: END IF;
2930:
2931: ELSIF l_contact_status = '3' THEN
2932:

Line 2933: UPDATE igs_ad_disablty_int_all

2929: END IF;
2930:
2931: ELSIF l_contact_status = '3' THEN
2932:
2933: UPDATE igs_ad_disablty_int_all
2934: SET status = '4',
2935: error_code = 'E148'
2936: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2937:

Line 2939: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');

2935: error_code = 'E148'
2936: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2937:
2938: IF l_enable_log = 'Y' THEN
2939: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');
2940: END IF;
2941:
2942: ELSIF l_service_status = '3' THEN
2943:

Line 2944: UPDATE igs_ad_disablty_int_all

2940: END IF;
2941:
2942: ELSIF l_service_status = '3' THEN
2943:
2944: UPDATE igs_ad_disablty_int_all
2945: SET status = '4',
2946: error_code = 'E147'
2947: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2948:

Line 2950: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');

2946: error_code = 'E147'
2947: WHERE interface_disablty_id = disability_rec.interface_disablty_id;
2948:
2949: IF l_enable_log = 'Y' THEN
2950: igs_ad_imp_001.logerrormessage(disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');
2951: END IF;
2952:
2953: END IF;
2954: END IF;

Line 2986: UPDATE igs_ad_disablty_int_all

2982: SET status ='3',
2983: error_code = 'E272'
2984: WHERE INTERFACE_DISABLTY_ID = sp_disability_rec.interface_disablty_id;
2985:
2986: UPDATE igs_ad_disablty_int_all
2987: SET status = '4',
2988: error_code = 'E347'
2989: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id AND
2990: (

Line 3000: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');

2996:
2997: IF ((l_enable_log = 'Y') and (SQL%FOUND)) THEN
2998: fnd_message.set_name('IGS','IGS_EN_CONIND_NOTSET_NONE');
2999: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
3000: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E347','IGS_AD_DISABLTY_INT_ALL');
3001: END IF;
3002:
3003: ELSE
3004: process_sn_service(sp_disability_rec.interface_disablty_id, l_disability_id, sp_disability_rec.person_id,l_contact_status);

Line 3007: UPDATE igs_ad_disablty_int_all

3003: ELSE
3004: process_sn_service(sp_disability_rec.interface_disablty_id, l_disability_id, sp_disability_rec.person_id,l_contact_status);
3005: process_sn_contact(sp_disability_rec.interface_disablty_id, l_disability_id, sp_disability_rec.person_id,l_service_status);
3006: IF l_contact_status = '3' AND l_service_status = '3' THEN
3007: UPDATE igs_ad_disablty_int_all
3008: SET status = '4',
3009: error_code = 'E155'
3010: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3011:

Line 3013: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');

3009: error_code = 'E155'
3010: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3011:
3012: IF l_enable_log = 'Y' THEN
3013: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E155','IGS_AD_DISABLTY_INT_ALL');
3014: END IF;
3015:
3016: ELSIF l_contact_status = '3' THEN
3017:

Line 3018: UPDATE igs_ad_disablty_int_all

3014: END IF;
3015:
3016: ELSIF l_contact_status = '3' THEN
3017:
3018: UPDATE igs_ad_disablty_int_all
3019: SET status = '4',
3020: error_code = 'E148'
3021: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3022: IF l_enable_log = 'Y' THEN

Line 3023: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');

3019: SET status = '4',
3020: error_code = 'E148'
3021: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3022: IF l_enable_log = 'Y' THEN
3023: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E148','IGS_AD_DISABLTY_INT_ALL');
3024: END IF;
3025:
3026: ELSIF l_service_status = '3' THEN
3027:

Line 3028: UPDATE igs_ad_disablty_int_all

3024: END IF;
3025:
3026: ELSIF l_service_status = '3' THEN
3027:
3028: UPDATE igs_ad_disablty_int_all
3029: SET status = '4',
3030: error_code = 'E147'
3031: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3032: IF l_enable_log = 'Y' THEN

Line 3033: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');

3029: SET status = '4',
3030: error_code = 'E147'
3031: WHERE interface_disablty_id = sp_disability_rec.interface_disablty_id;
3032: IF l_enable_log = 'Y' THEN
3033: igs_ad_imp_001.logerrormessage(sp_disability_rec.interface_disablty_id,'E147','IGS_AD_DISABLTY_INT_ALL');
3034: END IF;
3035: END IF;
3036: END IF;
3037: END;