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_DTL_INT

Line 1607: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;

1603: lookup caching related changes, and cursor parameterization.
1604: */
1605:
1606: l_rule VARCHAR2(1);
1607: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;
1608: l_status igs_pe_ath_dtl_int.status%TYPE;
1609: l_default_date DATE := IGS_GE_DATE.IGSDATE('4712/12/31');
1610: l_processed_records NUMBER(5) := 0;
1611: -- variables for logging

Line 1608: l_status igs_pe_ath_dtl_int.status%TYPE;

1604: */
1605:
1606: l_rule VARCHAR2(1);
1607: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;
1608: l_status igs_pe_ath_dtl_int.status%TYPE;
1609: l_default_date DATE := IGS_GE_DATE.IGSDATE('4712/12/31');
1610: l_processed_records NUMBER(5) := 0;
1611: -- variables for logging
1612: l_prog_label VARCHAR2(4000);

Line 1624: FROM igs_pe_ath_dtl_int ai,

1620:
1621: --Pick up the records for processing from the Athletic Details Interface Table
1622: CURSOR ath_dtl_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1623: SELECT ai.*, i.person_id
1624: FROM igs_pe_ath_dtl_int ai,
1625: igs_ad_interface_all i
1626: WHERE ai.interface_run_id = cp_interface_run_id
1627: AND i.interface_id = ai.interface_id
1628: AND i.interface_run_id = cp_interface_run_id

Line 1650: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;

1646: )
1647: AS
1648: l_rowid VARCHAR2(25);
1649: l_athletic_details_id igs_pe_athletic_dtl.athletic_details_id%TYPE;
1650: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;
1651: BEGIN
1652: -- Call Log header
1653: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
1654:

Line 1681: UPDATE igs_pe_ath_dtl_int

1677: x_comments => p_ath_dtl_rec.comments,
1678: x_mode => 'R'
1679: );
1680: l_error_code:=NULL;
1681: UPDATE igs_pe_ath_dtl_int
1682: SET status = '1',
1683: error_code = l_error_code
1684: WHERE interface_athletic_dtls_id = p_ath_dtl_rec.interface_athletic_dtls_id;
1685:

Line 1690: UPDATE igs_pe_ath_dtl_int

1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: l_error_code := 'E093'; -- Athletics Details Insertion Failed
1689:
1690: UPDATE igs_pe_ath_dtl_int
1691: SET status = '3',
1692: error_code = l_error_code
1693: WHERE interface_athletic_dtls_id = p_ath_dtl_rec.interface_athletic_dtls_id;
1694:

Line 1718: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,'E093','IGS_PE_ATH_DTL_INT');

1714: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1715: END IF;
1716:
1717: IF l_enable_log = 'Y' THEN
1718: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,'E093','IGS_PE_ATH_DTL_INT');
1719: END IF;
1720:
1721: END crt_apcnt_ath_dtl;
1722: -- END OF LOCAL PROCEDURE crt_apcnt_ath_dtl

Line 1729: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;

1725: -- Start Local function Validate_Record
1726:
1727: FUNCTION validate_record(p_ath_dtl_rec IN ath_dtl_cur%ROWTYPE)
1728: RETURN BOOLEAN IS
1729: l_error_code igs_pe_ath_dtl_int.error_code%TYPE;
1730: l_birth_dt IGS_AD_INTERFACE.BIRTH_DT%TYPE;
1731: l_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE;
1732:
1733: CURSOR birth_dt_cur(p_person_id IGS_AD_INTERFACE.PERSON_ID%TYPE) IS

Line 1802: UPDATE igs_pe_ath_dtl_int

1798: RETURN TRUE;
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801:
1802: UPDATE igs_pe_ath_dtl_int
1803: SET status = '3',
1804: error_code = l_error_code
1805: WHERE interface_athletic_dtls_id = p_ath_dtl_rec.interface_athletic_dtls_id;
1806:

Line 1830: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');

1826: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1827: END IF;
1828:
1829: IF l_enable_log = 'Y' THEN
1830: igs_ad_imp_001.logerrormessage(p_ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');
1831: END IF;
1832: RETURN FALSE;
1833: END validate_record;
1834: -- End Local function Validate_Record

Line 1868: UPDATE igs_pe_ath_dtl_int

1864:
1865: -- 1.If rule is E or I, then if the match_ind is not null, the combination is invalid
1866: IF l_rule IN ('E','I') THEN
1867:
1868: UPDATE igs_pe_ath_dtl_int
1869: SET status = cst_stat_val_3,
1870: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
1871: WHERE match_ind IS NOT NULL
1872: AND interface_run_id = l_interface_run_id

Line 1878: UPDATE igs_pe_ath_dtl_int ai

1874: END IF;
1875:
1876: --2. If rule is E and duplicate exists, update match_ind to 19 and status to 1
1877: IF l_rule = 'E' THEN
1878: UPDATE igs_pe_ath_dtl_int ai
1879: SET status = cst_stat_val_1,
1880: match_ind = cst_mi_val_19
1881: WHERE ai.interface_run_id = l_interface_run_id
1882: AND ai.status = cst_stat_val_2

Line 1894: UPDATE igs_pe_ath_dtl_int

1890:
1891: -- 3.If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
1892: -- processed in prior runs and didn't get updated .. update to status 1
1893: IF l_rule = 'R' THEN
1894: UPDATE igs_pe_ath_dtl_int
1895: SET status = cst_stat_val_1
1896: WHERE interface_run_id = l_interface_run_id
1897: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
1898: AND status=cst_stat_val_2;

Line 1903: UPDATE igs_pe_ath_dtl_int

1899: END IF;
1900:
1901: -- 4.If rule is R and match_ind is neither 21 nor 25 then error
1902: IF l_rule = 'R' THEN
1903: UPDATE igs_pe_ath_dtl_int
1904: SET status = cst_stat_val_3,
1905: ERROR_CODE = cst_err_val_695
1906: WHERE interface_run_id = l_interface_run_id
1907: AND (match_ind IS NOT NULL AND match_ind NOT IN (cst_mi_val_21,cst_mi_val_25))

Line 1913: UPDATE igs_pe_ath_dtl_int mi

1909: END IF;
1910:
1911: -- 5.If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
1912: IF l_rule = 'R' THEN
1913: UPDATE igs_pe_ath_dtl_int mi
1914: SET status = cst_stat_val_1,
1915: match_ind = cst_mi_val_23
1916: WHERE mi.interface_run_id = l_interface_run_id
1917: AND mi.match_ind IS NULL

Line 1934: UPDATE igs_pe_ath_dtl_int ai

1930: END IF;
1931:
1932: -- 6.If rule in R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
1933: IF l_rule = 'R' THEN
1934: UPDATE igs_pe_ath_dtl_int ai
1935: SET status = cst_stat_val_3,
1936: match_ind = cst_mi_val_18,
1937: dup_athletic_details_id = (SELECT athletic_details_id
1938: FROM igs_pe_athletic_dtl pe, igs_ad_interface_all i

Line 1990: UPDATE igs_pe_ath_dtl_int

1986: );
1987: l_error_code := NULL;
1988: l_status := '1';
1989:
1990: UPDATE igs_pe_ath_dtl_int
1991: SET status = l_status,
1992: error_code = l_error_code,
1993: match_ind = cst_mi_val_18 -- '18' Match occured and used import values
1994: WHERE interface_athletic_dtls_id = ath_dtl_rec.interface_athletic_dtls_id;

Line 2001: UPDATE igs_pe_ath_dtl_int

1997: WHEN OTHERS THEN
1998: l_error_code := 'E094'; -- Could not update Person Athletics Details
1999: l_status := '3';
2000:
2001: UPDATE igs_pe_ath_dtl_int
2002: SET status = l_status,
2003: error_code = l_error_code
2004: WHERE interface_athletic_dtls_id = ath_dtl_rec.interface_athletic_dtls_id;
2005:

Line 2029: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');

2025: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2026: END IF;
2027:
2028: IF l_enable_log = 'Y' THEN
2029: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');
2030: END IF;
2031:
2032: END;
2033:

Line 2052: UPDATE igs_pe_ath_dtl_int

2048: );
2049: l_error_code := NULL;
2050: l_status := '1';
2051:
2052: UPDATE igs_pe_ath_dtl_int
2053: SET status = l_status,
2054: error_code = l_error_code,
2055: match_ind = cst_mi_val_18
2056: WHERE interface_athletic_dtls_id = ath_dtl_rec.interface_athletic_dtls_id;

Line 2063: UPDATE igs_pe_ath_dtl_int

2059: WHEN OTHERS THEN
2060: l_error_code := 'E094'; -- Could not update Person Athletics Details
2061: l_status := '3';
2062:
2063: UPDATE igs_pe_ath_dtl_int
2064: SET status = l_status,
2065: error_code = l_error_code
2066: WHERE interface_athletic_dtls_id = ath_dtl_rec.interface_athletic_dtls_id;
2067:

Line 2091: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');

2087: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2088: END IF;
2089:
2090: IF l_enable_log = 'Y' THEN
2091: igs_ad_imp_001.logerrormessage(ath_dtl_rec.interface_athletic_dtls_id,l_error_code,'IGS_PE_ATH_DTL_INT');
2092: END IF;
2093:
2094: END;
2095: END IF; -- ath_dtl_rec.MATCH_IND check