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_CONCT_INT

Line 1229: FROM igs_pe_sn_conct_int ai,

1225: --Pick up the records for processing from the Special Needs Contact Interface Table
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

Line 1617: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

1613:
1614: EXCEPTION
1615: WHEN NO_DATA_FOUND THEN
1616: IF l_enable_log = 'Y' THEN
1617: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
1618: END IF;
1619:
1620: UPDATE igs_pe_sn_conct_int
1621: SET status = '3',

Line 1620: UPDATE igs_pe_sn_conct_int

1616: IF l_enable_log = 'Y' THEN
1617: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
1618: END IF;
1619:
1620: UPDATE igs_pe_sn_conct_int
1621: SET status = '3',
1622: ERROR_CODE = l_error_code
1623: WHERE interface_sn_contact_id = p_sn_contact_rec.interface_sn_contact_id;
1624:

Line 2035: l_error_code igs_pe_sn_conct_int.error_code%TYPE;

2031: || (reverse chronological order - newest change first)
2032: */
2033: l_rowid VARCHAR2(25);
2034: l_success VARCHAR2(1);
2035: l_error_code igs_pe_sn_conct_int.error_code%TYPE;
2036: l_sn_contact_id igs_pe_sn_contact.sn_contact_id%TYPE;
2037:
2038: BEGIN
2039:

Line 2072: UPDATE igs_pe_sn_conct_int

2068: );
2069: l_error_code := NULL;
2070:
2071:
2072: UPDATE igs_pe_sn_conct_int
2073: SET status ='1',
2074: error_code = l_error_code
2075: WHERE interface_sn_contact_id = p_sn_contact_rec.interface_sn_contact_id;
2076:

Line 2086: UPDATE igs_pe_sn_conct_int

2082: WHEN OTHERS THEN
2083: l_error_code := 'E153';
2084: p_status := '3';
2085:
2086: UPDATE igs_pe_sn_conct_int
2087: SET status ='3',
2088: error_code = l_error_code
2089: WHERE interface_sn_contact_id = p_sn_contact_rec.interface_sn_contact_id;
2090:

Line 2114: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

2110: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2111: END IF;
2112:
2113: IF l_enable_log = 'Y' THEN
2114: igs_ad_imp_001.logerrormessage(p_sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
2115: END IF;
2116:
2117: END create_sn_contact;
2118:

Line 2439: UPDATE igs_pe_sn_conct_int

2435: END IF;
2436:
2437: --1. If rule is E or I, then if the match_ind is not null, the combination is invalid
2438: IF l_rule IN ('E','I') THEN
2439: UPDATE igs_pe_sn_conct_int
2440: SET status = cst_stat_val_3,
2441: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
2442: WHERE match_ind IS NOT NULL
2443: AND status = cst_stat_val_2

Line 2449: UPDATE igs_pe_sn_conct_int mi

2445: END IF;
2446:
2447: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
2448: IF l_rule = 'E' THEN
2449: UPDATE igs_pe_sn_conct_int mi
2450: SET status = cst_stat_val_1,
2451: match_ind = cst_mi_val_19
2452: WHERE mi.interface_run_id = l_interface_run_id
2453: AND mi.status = cst_stat_val_2

Line 2466: UPDATE igs_pe_sn_conct_int

2462:
2463: --3. If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
2464: -- processed in prior runs and didn't get updated .. update to status 1
2465: IF l_rule = 'R' THEN
2466: UPDATE igs_pe_sn_conct_int
2467: SET status = cst_stat_val_1
2468: WHERE interface_run_id = l_interface_run_id
2469: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
2470: AND status = cst_stat_val_2;

Line 2475: UPDATE igs_pe_sn_conct_int

2471: END IF;
2472:
2473: --4. If rule is R and match_ind is neither 21 nor 25 then error
2474: IF l_rule = 'R' THEN
2475: UPDATE igs_pe_sn_conct_int
2476: SET status = cst_stat_val_3,
2477: ERROR_CODE = cst_err_val_695
2478: WHERE interface_run_id = l_interface_run_id
2479: AND status = cst_stat_val_2

Line 2485: UPDATE igs_pe_sn_conct_int mi

2481: END IF;
2482:
2483: --5. If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
2484: IF l_rule = 'R' THEN
2485: UPDATE igs_pe_sn_conct_int mi
2486: SET status = cst_stat_val_1,
2487: match_ind = cst_mi_val_23
2488: WHERE mi.interface_run_id = l_interface_run_id
2489: AND mi.match_ind IS NULL

Line 2502: UPDATE igs_pe_sn_conct_int mi

2498: END IF;
2499:
2500: --6. If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
2501: IF l_rule = 'R' THEN
2502: UPDATE igs_pe_sn_conct_int mi
2503: SET status = cst_stat_val_3,
2504: match_ind = cst_mi_val_20,
2505: dup_sn_contact_id = (SELECT sn_contact_id
2506: FROM igs_pe_sn_contact pe

Line 2548: UPDATE igs_pe_sn_conct_int

2544: x_comments => NVL(sn_contact_rec.comments, dup_chk_sn_contact_rec.comments),
2545: x_mode => 'R'
2546: );
2547: l_error_code := NULL;
2548: UPDATE igs_pe_sn_conct_int
2549: SET status =cst_stat_val_1,
2550: error_code = l_error_code,
2551: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
2552: WHERE interface_sn_contact_id = sn_contact_rec.interface_sn_contact_id;

Line 2562: UPDATE igs_pe_sn_conct_int

2558: WHEN OTHERS THEN
2559: l_error_code := 'E154';
2560: p_status := '3';
2561:
2562: UPDATE igs_pe_sn_conct_int
2563: SET status ='3',
2564: error_code = l_error_code
2565: WHERE interface_sn_contact_id = sn_contact_rec.interface_sn_contact_id;
2566:

Line 2590: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

2586: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2587: END IF;
2588:
2589: IF l_enable_log = 'Y' THEN
2590: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
2591: END IF;
2592:
2593:
2594: END;

Line 2614: UPDATE igs_pe_sn_conct_int

2610: x_mode => 'R'
2611: );
2612: l_error_code := NULL;
2613:
2614: UPDATE igs_pe_sn_conct_int
2615: SET status =cst_stat_val_1,
2616: error_code = l_error_code,
2617: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
2618: WHERE interface_sn_contact_id = sn_contact_rec.interface_sn_contact_id;

Line 2628: UPDATE igs_pe_sn_conct_int

2624: WHEN OTHERS THEN
2625: l_error_code := 'E154';
2626: p_status := '3';
2627:
2628: UPDATE igs_pe_sn_conct_int
2629: SET status ='3',
2630: error_code = l_error_code
2631: WHERE interface_sn_contact_id = sn_contact_rec.interface_sn_contact_id;
2632:

Line 2656: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');

2652: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2653: END IF;
2654:
2655: IF l_enable_log = 'Y' THEN
2656: igs_ad_imp_001.logerrormessage(sn_contact_rec.interface_sn_contact_id,l_error_code,'IGS_PE_SN_CONCT_INT');
2657: END IF;
2658:
2659:
2660: END;

Line 2900: UPDATE igs_pe_sn_conct_int

2896: SET status ='3',
2897: error_code = 'E271'
2898: WHERE INTERFACE_DISABLTY_ID = disability_rec.interface_disablty_id;
2899:
2900: UPDATE igs_pe_sn_conct_int
2901: SET status ='3',
2902: error_code = 'E272'
2903: WHERE INTERFACE_DISABLTY_ID = disability_rec.interface_disablty_id;
2904:

Line 2909: (EXISTS (SELECT 1 FROM igs_pe_sn_conct_int WHERE interface_disablty_id = disability_rec.interface_disablty_id AND status = '3')

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')
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');

Line 2981: UPDATE igs_pe_sn_conct_int

2977: SET status ='3',
2978: error_code = 'E271'
2979: WHERE INTERFACE_DISABLTY_ID = sp_disability_rec.interface_disablty_id;
2980:
2981: UPDATE igs_pe_sn_conct_int
2982: SET status ='3',
2983: error_code = 'E272'
2984: WHERE INTERFACE_DISABLTY_ID = sp_disability_rec.interface_disablty_id;
2985:

Line 2991: EXISTS(SELECT 1 FROM igs_pe_sn_conct_int WHERE

2987: SET status = '4',
2988: error_code = 'E347'
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: );