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.OKS_EXTWAR_UTIL_PUB dependencies on FND_LOG

Line 773: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

769:
770:
771: BEGIN
772:
773: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
774: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
775: 'Inside NOTIFY_TERRITORY_ADMIN');
776: END IF;
777:

Line 774: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

770:
771: BEGIN
772:
773: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
774: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
775: 'Inside NOTIFY_TERRITORY_ADMIN');
776: END IF;
777:
778: l_terr_admin_id := FND_PROFILE.VALUE('OKS_TERR_ADMIN_ID');

Line 787: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

783: IF l_terr_admin_id IS NOT NULL THEN
784: OPEN l_fnd_csr(l_terr_admin_id);
785: FETCH l_fnd_csr INTO l_user_name;
786: CLOSE l_fnd_csr;
787: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
788: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
789: 'Territory Admin is not null - ' || l_user_name);
790: END IF;
791: ELSIF l_contract_admin_id IS NOT NULL THEN

Line 788: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

784: OPEN l_fnd_csr(l_terr_admin_id);
785: FETCH l_fnd_csr INTO l_user_name;
786: CLOSE l_fnd_csr;
787: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
788: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
789: 'Territory Admin is not null - ' || l_user_name);
790: END IF;
791: ELSIF l_contract_admin_id IS NOT NULL THEN
792: OPEN l_fnd_csr(l_contract_admin_id);

Line 795: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

791: ELSIF l_contract_admin_id IS NOT NULL THEN
792: OPEN l_fnd_csr(l_contract_admin_id);
793: FETCH l_fnd_csr INTO l_user_name;
794: CLOSE l_fnd_csr;
795: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
796: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
797: 'Contract Admin is not null - ' || l_user_name);
798: END IF;
799: ELSE

Line 796: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

792: OPEN l_fnd_csr(l_contract_admin_id);
793: FETCH l_fnd_csr INTO l_user_name;
794: CLOSE l_fnd_csr;
795: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
796: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
797: 'Contract Admin is not null - ' || l_user_name);
798: END IF;
799: ELSE
800: l_user_name := FND_PROFILE.VALUE('OKC_K_APPROVER');

Line 801: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

797: 'Contract Admin is not null - ' || l_user_name);
798: END IF;
799: ELSE
800: l_user_name := FND_PROFILE.VALUE('OKC_K_APPROVER');
801: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
803: 'Contract Approver is not null - ' || l_user_name);
804: END IF;
805:

Line 802: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

798: END IF;
799: ELSE
800: l_user_name := FND_PROFILE.VALUE('OKC_K_APPROVER');
801: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
803: 'Contract Approver is not null - ' || l_user_name);
804: END IF;
805:
806: END IF;

Line 811: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

807:
808: l_con_num_prompt := FND_MESSAGE.get_string('OKS','OKS_CONTRACT_NUMBER');
809: l_subj := l_subj || ' ' || l_con_num_prompt || ' - ' || p_contract_number ||' '||p_contract_number_modifier;
810:
811: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
812: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
813: 'p_recipient is ' || l_user_name ||
814: 'p_contract_id is ' || p_chr_id );
815: END IF;

Line 812: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

808: l_con_num_prompt := FND_MESSAGE.get_string('OKS','OKS_CONTRACT_NUMBER');
809: l_subj := l_subj || ' ' || l_con_num_prompt || ' - ' || p_contract_number ||' '||p_contract_number_modifier;
810:
811: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
812: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
813: 'p_recipient is ' || l_user_name ||
814: 'p_contract_id is ' || p_chr_id );
815: END IF;
816: OKC_ASYNC_PUB.msg_call(p_api_version => 1,

Line 824: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

820: p_recipient => l_user_name,
821: p_msg_body => p_mesg,
822: p_msg_subj => l_subj,
823: p_contract_id => p_chr_id );
824: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
826: 'Exiting NOTIFY_TERR_ADMIN' || l_return_status);
827: END IF;
828: END NOTIFY_TERRITORY_ADMIN;

Line 825: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

821: p_msg_body => p_mesg,
822: p_msg_subj => l_subj,
823: p_contract_id => p_chr_id );
824: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
825: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
826: 'Exiting NOTIFY_TERR_ADMIN' || l_return_status);
827: END IF;
828: END NOTIFY_TERRITORY_ADMIN;
829:

Line 1849: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1845:
1846: fnd_file.put_line(FND_FILE.LOG,'Start Time ' || to_char(sysdate,'HH:MI:SS'));
1847: -- l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1848:
1849: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1850: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1851: 'Reassign: start time= '
1852: ||to_char(sysdate,'HH:MI:SS') ||' '
1853: || ' p_org_id : ' || p_org_id

Line 1850: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1846: fnd_file.put_line(FND_FILE.LOG,'Start Time ' || to_char(sysdate,'HH:MI:SS'));
1847: -- l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1848:
1849: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1850: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1851: 'Reassign: start time= '
1852: ||to_char(sysdate,'HH:MI:SS') ||' '
1853: || ' p_org_id : ' || p_org_id
1854: || ' p_salesrep_id: ' || p_salesrep_id

Line 1881: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1877: ELSE
1878: l_terr_res := 'C';
1879: END IF;
1880:
1881: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1882: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1883: 'Profile Value for OKS_SRC_TERR_QUALFIERS is '|| l_terr_res);
1884: END IF;
1885:

Line 1882: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1878: l_terr_res := 'C';
1879: END IF;
1880:
1881: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1882: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1883: 'Profile Value for OKS_SRC_TERR_QUALFIERS is '|| l_terr_res);
1884: END IF;
1885:
1886: IF l_terr_res = 'V' THEN

Line 1925: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1921: ELSE
1922: OPEN GET_ALL_CONTRACTS_8(l_cro_code,l_org_id);
1923: END IF;
1924: END IF;
1925: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1926: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1927: 'Before Cursor Fetch');
1928: END IF;
1929: LOOP

Line 1926: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1922: OPEN GET_ALL_CONTRACTS_8(l_cro_code,l_org_id);
1923: END IF;
1924: END IF;
1925: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1926: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1927: 'Before Cursor Fetch');
1928: END IF;
1929: LOOP
1930: IF GET_ALL_CONTRACTS_1%ISOPEN THEN

Line 1931: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1927: 'Before Cursor Fetch');
1928: END IF;
1929: LOOP
1930: IF GET_ALL_CONTRACTS_1%ISOPEN THEN
1931: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1932: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1933: ' GET_ALL_CONTRACTS_1%ISOPEN - ');
1934: END IF;
1935: FETCH GET_ALL_CONTRACTS_1 BULK COLLECT INTO lb_id,lb_contract_number,

Line 1932: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1928: END IF;
1929: LOOP
1930: IF GET_ALL_CONTRACTS_1%ISOPEN THEN
1931: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1932: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1933: ' GET_ALL_CONTRACTS_1%ISOPEN - ');
1934: END IF;
1935: FETCH GET_ALL_CONTRACTS_1 BULK COLLECT INTO lb_id,lb_contract_number,
1936: lb_contract_number_modifier,

Line 1946: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1942: lb_salesrep_id,
1943: lb_contact_start_date,
1944: lb_status limit 1000;
1945: ELSIF GET_ALL_CONTRACTS_2%ISOPEN THEN
1946: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1948: ' GET_ALL_CONTRACTS_2%ISOPEN - ');
1949: END IF;
1950: FETCH GET_ALL_CONTRACTS_2 BULK COLLECT INTO lb_id,lb_contract_number,

Line 1947: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1943: lb_contact_start_date,
1944: lb_status limit 1000;
1945: ELSIF GET_ALL_CONTRACTS_2%ISOPEN THEN
1946: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1947: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1948: ' GET_ALL_CONTRACTS_2%ISOPEN - ');
1949: END IF;
1950: FETCH GET_ALL_CONTRACTS_2 BULK COLLECT INTO lb_id,lb_contract_number,
1951: lb_contract_number_modifier,

Line 1961: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1957: lb_salesrep_id,
1958: lb_contact_start_date,
1959: lb_status limit 1000;
1960: ELSIF GET_ALL_CONTRACTS_3%ISOPEN THEN
1961: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1962: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1963: ' GET_ALL_CONTRACTS_3%ISOPEN - ');
1964: END IF;
1965: FETCH GET_ALL_CONTRACTS_3 BULK COLLECT INTO lb_id,lb_contract_number,

Line 1962: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1958: lb_contact_start_date,
1959: lb_status limit 1000;
1960: ELSIF GET_ALL_CONTRACTS_3%ISOPEN THEN
1961: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1962: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1963: ' GET_ALL_CONTRACTS_3%ISOPEN - ');
1964: END IF;
1965: FETCH GET_ALL_CONTRACTS_3 BULK COLLECT INTO lb_id,lb_contract_number,
1966: lb_contract_number_modifier,

Line 1976: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1972: lb_salesrep_id,
1973: lb_contact_start_date,
1974: lb_status limit 1000;
1975: ELSIF GET_ALL_CONTRACTS_4%ISOPEN THEN
1976: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1977: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1978: ' GET_ALL_CONTRACTS_4%ISOPEN - ');
1979: END IF;
1980: FETCH GET_ALL_CONTRACTS_4 BULK COLLECT INTO lb_id,lb_contract_number,

Line 1977: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1973: lb_contact_start_date,
1974: lb_status limit 1000;
1975: ELSIF GET_ALL_CONTRACTS_4%ISOPEN THEN
1976: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1977: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1978: ' GET_ALL_CONTRACTS_4%ISOPEN - ');
1979: END IF;
1980: FETCH GET_ALL_CONTRACTS_4 BULK COLLECT INTO lb_id,lb_contract_number,
1981: lb_contract_number_modifier,

Line 1992: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1988: lb_contact_start_date,
1989: lb_status limit 1000;
1990:
1991: ELSIF GET_ALL_CONTRACTS_5%ISOPEN THEN
1992: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1994: ' GET_ALL_CONTRACTS_5%ISOPEN - ');
1995: END IF;
1996: FETCH GET_ALL_CONTRACTS_5 BULK COLLECT INTO lb_id,lb_contract_number,

Line 1993: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

1989: lb_status limit 1000;
1990:
1991: ELSIF GET_ALL_CONTRACTS_5%ISOPEN THEN
1992: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
1994: ' GET_ALL_CONTRACTS_5%ISOPEN - ');
1995: END IF;
1996: FETCH GET_ALL_CONTRACTS_5 BULK COLLECT INTO lb_id,lb_contract_number,
1997: lb_contract_number_modifier,

Line 2007: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2003: lb_salesrep_id ,
2004: lb_contact_start_date,
2005: lb_status limit 1000;
2006: ELSIF GET_ALL_CONTRACTS_6%ISOPEN THEN
2007: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2009: ' GET_ALL_CONTRACTS_6%ISOPEN - ');
2010: END IF;
2011: FETCH GET_ALL_CONTRACTS_6 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2008: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2004: lb_contact_start_date,
2005: lb_status limit 1000;
2006: ELSIF GET_ALL_CONTRACTS_6%ISOPEN THEN
2007: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2008: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2009: ' GET_ALL_CONTRACTS_6%ISOPEN - ');
2010: END IF;
2011: FETCH GET_ALL_CONTRACTS_6 BULK COLLECT INTO lb_id,lb_contract_number,
2012: lb_contract_number_modifier,

Line 2022: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2018: lb_salesrep_id ,
2019: lb_contact_start_date,
2020: lb_status limit 1000;
2021: ELSIF GET_ALL_CONTRACTS_7%ISOPEN THEN
2022: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2023: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2024: ' GET_ALL_CONTRACTS_7%ISOPEN - ');
2025: END IF;
2026: FETCH GET_ALL_CONTRACTS_7 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2023: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2019: lb_contact_start_date,
2020: lb_status limit 1000;
2021: ELSIF GET_ALL_CONTRACTS_7%ISOPEN THEN
2022: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2023: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2024: ' GET_ALL_CONTRACTS_7%ISOPEN - ');
2025: END IF;
2026: FETCH GET_ALL_CONTRACTS_7 BULK COLLECT INTO lb_id,lb_contract_number,
2027: lb_contract_number_modifier,

Line 2037: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2033: lb_salesrep_id ,
2034: lb_contact_start_date,
2035: lb_status limit 1000;
2036: ELSIF GET_ALL_CONTRACTS_8%ISOPEN THEN
2037: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2039: ' GET_ALL_CONTRACTS_8%ISOPEN - ');
2040: END IF;
2041: FETCH GET_ALL_CONTRACTS_8 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2038: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2034: lb_contact_start_date,
2035: lb_status limit 1000;
2036: ELSIF GET_ALL_CONTRACTS_8%ISOPEN THEN
2037: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2038: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2039: ' GET_ALL_CONTRACTS_8%ISOPEN - ');
2040: END IF;
2041: FETCH GET_ALL_CONTRACTS_8 BULK COLLECT INTO lb_id,lb_contract_number,
2042: lb_contract_number_modifier,

Line 2053: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2049: lb_contact_start_date,
2050: lb_status limit 1000;
2051:
2052: ELSIF GET_ALL_CONTRACTS_9%ISOPEN THEN
2053: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2054: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2055: ' GET_ALL_CONTRACTS_9%ISOPEN - ');
2056: END IF;
2057: FETCH GET_ALL_CONTRACTS_9 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2054: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2050: lb_status limit 1000;
2051:
2052: ELSIF GET_ALL_CONTRACTS_9%ISOPEN THEN
2053: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2054: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2055: ' GET_ALL_CONTRACTS_9%ISOPEN - ');
2056: END IF;
2057: FETCH GET_ALL_CONTRACTS_9 BULK COLLECT INTO lb_id,lb_contract_number,
2058: lb_contract_number_modifier,

Line 2068: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2064: lb_salesrep_id,
2065: lb_contact_start_date,
2066: lb_status limit 1000;
2067: ELSIF GET_ALL_CONTRACTS_10%ISOPEN THEN
2068: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2070: ' GET_ALL_CONTRACTS_10%ISOPEN - ');
2071: END IF;
2072: FETCH GET_ALL_CONTRACTS_10 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2069: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2065: lb_contact_start_date,
2066: lb_status limit 1000;
2067: ELSIF GET_ALL_CONTRACTS_10%ISOPEN THEN
2068: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2069: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2070: ' GET_ALL_CONTRACTS_10%ISOPEN - ');
2071: END IF;
2072: FETCH GET_ALL_CONTRACTS_10 BULK COLLECT INTO lb_id,lb_contract_number,
2073: lb_contract_number_modifier,

Line 2083: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2079: lb_salesrep_id,
2080: lb_contact_start_date,
2081: lb_status limit 1000;
2082: ELSIF GET_ALL_CONTRACTS_11%ISOPEN THEN
2083: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2084: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2085: ' GET_ALL_CONTRACTS_11%ISOPEN - ');
2086: END IF;
2087: FETCH GET_ALL_CONTRACTS_11 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2084: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2080: lb_contact_start_date,
2081: lb_status limit 1000;
2082: ELSIF GET_ALL_CONTRACTS_11%ISOPEN THEN
2083: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2084: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2085: ' GET_ALL_CONTRACTS_11%ISOPEN - ');
2086: END IF;
2087: FETCH GET_ALL_CONTRACTS_11 BULK COLLECT INTO lb_id,lb_contract_number,
2088: lb_contract_number_modifier,

Line 2098: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2094: lb_salesrep_id,
2095: lb_contact_start_date,
2096: lb_status limit 1000;
2097: ELSIF GET_ALL_CONTRACTS_12%ISOPEN THEN
2098: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2099: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2100: ' GET_ALL_CONTRACTS_12%ISOPEN - ');
2101: END IF;
2102: FETCH GET_ALL_CONTRACTS_12 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2099: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2095: lb_contact_start_date,
2096: lb_status limit 1000;
2097: ELSIF GET_ALL_CONTRACTS_12%ISOPEN THEN
2098: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2099: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2100: ' GET_ALL_CONTRACTS_12%ISOPEN - ');
2101: END IF;
2102: FETCH GET_ALL_CONTRACTS_12 BULK COLLECT INTO lb_id,lb_contract_number,
2103: lb_contract_number_modifier,

Line 2114: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2110: lb_contact_start_date,
2111: lb_status limit 1000;
2112:
2113: ELSIF GET_ALL_CONTRACTS_13%ISOPEN THEN
2114: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2115: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2116: ' GET_ALL_CONTRACTS_13%ISOPEN - ');
2117: END IF;
2118: FETCH GET_ALL_CONTRACTS_13 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2115: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2111: lb_status limit 1000;
2112:
2113: ELSIF GET_ALL_CONTRACTS_13%ISOPEN THEN
2114: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2115: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2116: ' GET_ALL_CONTRACTS_13%ISOPEN - ');
2117: END IF;
2118: FETCH GET_ALL_CONTRACTS_13 BULK COLLECT INTO lb_id,lb_contract_number,
2119: lb_contract_number_modifier,

Line 2129: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2125: lb_salesrep_id ,
2126: lb_contact_start_date,
2127: lb_status limit 1000;
2128: ELSIF GET_ALL_CONTRACTS_14%ISOPEN THEN
2129: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2131: ' GET_ALL_CONTRACTS_14%ISOPEN - ');
2132: END IF;
2133: FETCH GET_ALL_CONTRACTS_14 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2126: lb_contact_start_date,
2127: lb_status limit 1000;
2128: ELSIF GET_ALL_CONTRACTS_14%ISOPEN THEN
2129: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2130: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2131: ' GET_ALL_CONTRACTS_14%ISOPEN - ');
2132: END IF;
2133: FETCH GET_ALL_CONTRACTS_14 BULK COLLECT INTO lb_id,lb_contract_number,
2134: lb_contract_number_modifier,

Line 2144: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2140: lb_salesrep_id ,
2141: lb_contact_start_date,
2142: lb_status limit 1000;
2143: ELSIF GET_ALL_CONTRACTS_15%ISOPEN THEN
2144: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2146: ' GET_ALL_CONTRACTS_15%ISOPEN - ');
2147: END IF;
2148: FETCH GET_ALL_CONTRACTS_15 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2145: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2141: lb_contact_start_date,
2142: lb_status limit 1000;
2143: ELSIF GET_ALL_CONTRACTS_15%ISOPEN THEN
2144: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2145: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2146: ' GET_ALL_CONTRACTS_15%ISOPEN - ');
2147: END IF;
2148: FETCH GET_ALL_CONTRACTS_15 BULK COLLECT INTO lb_id,lb_contract_number,
2149: lb_contract_number_modifier,

Line 2159: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2155: lb_salesrep_id ,
2156: lb_contact_start_date,
2157: lb_status limit 1000;
2158: ELSIF GET_ALL_CONTRACTS_16%ISOPEN THEN
2159: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2161: ' GET_ALL_CONTRACTS_16%ISOPEN - ');
2162: END IF;
2163: FETCH GET_ALL_CONTRACTS_16 BULK COLLECT INTO lb_id,lb_contract_number,

Line 2160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2156: lb_contact_start_date,
2157: lb_status limit 1000;
2158: ELSIF GET_ALL_CONTRACTS_16%ISOPEN THEN
2159: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2161: ' GET_ALL_CONTRACTS_16%ISOPEN - ');
2162: END IF;
2163: FETCH GET_ALL_CONTRACTS_16 BULK COLLECT INTO lb_id,lb_contract_number,
2164: lb_contract_number_modifier,

Line 2176: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2172: lb_status limit 1000;
2173:
2174: END IF;
2175:
2176: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2177: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2178: ' Main cursor count : ' || lb_id.count ||
2179: ' After Main Cursor Fetch time: ' || to_char(sysdate,'HH:MI:SS'));
2180: END IF;

Line 2177: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2173:
2174: END IF;
2175:
2176: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2177: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2178: ' Main cursor count : ' || lb_id.count ||
2179: ' After Main Cursor Fetch time: ' || to_char(sysdate,'HH:MI:SS'));
2180: END IF;
2181:

Line 2210: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2206: l_gen_bulk_rec.SQUAL_CHAR07(i) := lb_country_code(i);
2207: l_gen_bulk_rec.SQUAL_NUM01(i) := lb_party_id(i);
2208: l_use_type := 'RESOURCE';
2209:
2210: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2212: ' Parameters Passed to Territory: ' ||
2213: ' Party Name ' || lb_party_name(i) ||
2214: ' State ' || lb_state_code(i) ||

Line 2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2207: l_gen_bulk_rec.SQUAL_NUM01(i) := lb_party_id(i);
2208: l_use_type := 'RESOURCE';
2209:
2210: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2212: ' Parameters Passed to Territory: ' ||
2213: ' Party Name ' || lb_party_name(i) ||
2214: ' State ' || lb_state_code(i) ||
2215: ' Country ' || lb_country_code(i)||

Line 2243: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2239: );
2240:
2241: END LOOP;
2242:
2243: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2244: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2245: 'INSERTED INTO oks_reassign_resource_TMP : Successful'
2246: || 'Nmber of Recs passedto JTF: '
2247: || l_gen_bulk_rec.trans_object_id.count

Line 2244: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2240:
2241: END LOOP;
2242:
2243: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2244: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2245: 'INSERTED INTO oks_reassign_resource_TMP : Successful'
2246: || 'Nmber of Recs passedto JTF: '
2247: || l_gen_bulk_rec.trans_object_id.count
2248: || 'JTF_TERR_ASSIGN_PUB.get_winners start :'

Line 2276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2272: -- Handle error from territory API
2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSE
2276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2277: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2278: 'JTF_TERR_ASSIGN_PUB.get_winners end :'
2279: || to_char(sysdate,'HH:MI:SS') );
2280: END IF;

Line 2277: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSE
2276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2277: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2278: 'JTF_TERR_ASSIGN_PUB.get_winners end :'
2279: || to_char(sysdate,'HH:MI:SS') );
2280: END IF;
2281:

Line 2297: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2293: l_winning_tbl(l_counter).user_id := l_user_id;
2294: l_winning_tbl(l_counter).chr_id := l_gen_return_rec.trans_object_id(l_counter);
2295: l2_winning_tbl(1).chr_id:= l_gen_return_rec.trans_object_id(l_counter);
2296:
2297: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2298: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2299: ' Resource Returned from JTT API for Contract : ' || l_gen_return_rec.trans_object_id(l_counter)
2300: || ' is ' || l_gen_return_Rec.RESOURCE_ID(l_counter));
2301: END IF;

Line 2298: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2294: l_winning_tbl(l_counter).chr_id := l_gen_return_rec.trans_object_id(l_counter);
2295: l2_winning_tbl(1).chr_id:= l_gen_return_rec.trans_object_id(l_counter);
2296:
2297: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2298: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2299: ' Resource Returned from JTT API for Contract : ' || l_gen_return_rec.trans_object_id(l_counter)
2300: || ' is ' || l_gen_return_Rec.RESOURCE_ID(l_counter));
2301: END IF;
2302: END IF;

Line 2307: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2303: l_counter := l_counter + 1;
2304: END LOOP;
2305:
2306:
2307: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2309: 'l_winning_tbl count is : '|| l_winning_tbl.count ||
2310: ' Completed time '|| to_char(sysdate,'HH:MI:SS'));
2311: END IF;

Line 2308: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2304: END LOOP;
2305:
2306:
2307: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2309: 'l_winning_tbl count is : '|| l_winning_tbl.count ||
2310: ' Completed time '|| to_char(sysdate,'HH:MI:SS'));
2311: END IF;
2312:

Line 2321: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2317: l_temp_salesrep := GET_CHR_SALESREP_ID(l_winning_tbl(idx4).resource_id,
2318: l_winning_tbl(idx4).chr_id);
2319: l_temp_org_id := GET_ORG_ID(l_winning_tbl(idx4).chr_id);
2320: IF l_temp_salesrep IS NOT NULL THEN
2321: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2323: ' Contract selected to insert into JTF_RES_TEMP : ' || l_winning_tbl(idx4).chr_id);
2324: END IF;
2325:

Line 2322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2318: l_winning_tbl(idx4).chr_id);
2319: l_temp_org_id := GET_ORG_ID(l_winning_tbl(idx4).chr_id);
2320: IF l_temp_salesrep IS NOT NULL THEN
2321: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2322: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2323: ' Contract selected to insert into JTF_RES_TEMP : ' || l_winning_tbl(idx4).chr_id);
2324: END IF;
2325:
2326: INSERT INTO OKS_JTF_RES_TEMP (chr_id,resource_id,user_id,salesrep_id

Line 2342: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2338: OPEN get_contract_num_mod(l_winning_tbl(idx4).chr_id);
2339: FETCH get_contract_num_mod into l_e_contract_number,l_e_contract_number_mod;
2340: CLOSE get_contract_num_mod;
2341:
2342: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2343: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2344: ' Invalid salesrep returned for this Contract : ' || l_e_contract_number || ' ' || l_e_contract_number_mod);
2345: END IF;
2346:

Line 2343: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2339: FETCH get_contract_num_mod into l_e_contract_number,l_e_contract_number_mod;
2340: CLOSE get_contract_num_mod;
2341:
2342: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2343: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2344: ' Invalid salesrep returned for this Contract : ' || l_e_contract_number || ' ' || l_e_contract_number_mod);
2345: END IF;
2346:
2347: --Delete this contract

Line 2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2358: EXIT WHEN idx4 =l_winning_tbl.LAST;
2359: idx4 := l_winning_tbl.NEXT(idx4);
2360: END IF;
2361: END LOOP;
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2363: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2364: 'oks_jtf_resource_TMP Table population completed');
2365: END IF;
2366: END IF;

Line 2363: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2359: idx4 := l_winning_tbl.NEXT(idx4);
2360: END IF;
2361: END LOOP;
2362: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2363: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2364: 'oks_jtf_resource_TMP Table population completed');
2365: END IF;
2366: END IF;
2367:

Line 2384: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2380: -- Send notification for those contracts with no resource setup
2381: FOR contract_noresource_rec in contract_noresource
2382: LOOP
2383: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_NO_TERR_RESOURCES');
2384: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2385: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2386: 'Contract with no resource setup : ' || contract_noresource_rec.Contract_number || ' '
2387: || contract_noresource_rec.Contract_number_modifier);
2388: end if;

Line 2385: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2381: FOR contract_noresource_rec in contract_noresource
2382: LOOP
2383: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_NO_TERR_RESOURCES');
2384: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2385: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2386: 'Contract with no resource setup : ' || contract_noresource_rec.Contract_number || ' '
2387: || contract_noresource_rec.Contract_number_modifier);
2388: end if;
2389: NOTIFY_TERRITORY_ADMIN

Line 2403: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2399: l_f_chr_id := 0;
2400: FOR contact_resource_inf_rec IN contact_resource_in_future
2401: LOOP
2402: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_VENDOR_STAMP_ERROR');
2403: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2404: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2405: 'Contract with vendor contact starting in future: ' || contact_resource_inf_rec.Contract_number || ' '
2406: || contact_resource_inf_rec.Contract_number_modifier);
2407: end if;

Line 2404: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2400: FOR contact_resource_inf_rec IN contact_resource_in_future
2401: LOOP
2402: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_VENDOR_STAMP_ERROR');
2403: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2404: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2405: 'Contract with vendor contact starting in future: ' || contact_resource_inf_rec.Contract_number || ' '
2406: || contact_resource_inf_rec.Contract_number_modifier);
2407: end if;
2408: IF ( l_f_chr_id <> contact_resource_inf_rec.id) THEN

Line 2418: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2414: END IF;
2415: l_f_chr_id := contact_resource_inf_rec.id;
2416: END LOOP;
2417:
2418: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2419: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2420: 'Notifications sends for no resources and resources in future date');
2421: END IF;
2422:

Line 2419: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2415: l_f_chr_id := contact_resource_inf_rec.id;
2416: END LOOP;
2417:
2418: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2419: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2420: 'Notifications sends for no resources and resources in future date');
2421: END IF;
2422:
2423:

Line 2445: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2441: WHERE a.chr_id = b.id
2442: );
2443:
2444:
2445: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2446: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2447: 'Before fetching create_contact_resource cursor');
2448: END IF;
2449:

Line 2446: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2442: );
2443:
2444:
2445: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2446: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2447: 'Before fetching create_contact_resource cursor');
2448: END IF;
2449:
2450: -- Get all contracts to be stamped with new salesrep.

Line 2491: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2487: ELSE
2488: l_ctcv_tbl_in(idx1).sales_group_id := l_current_salesgrp_id ;
2489: END IF;
2490:
2491: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2493: 'contract selected to create new contact : ' || l_contract_number
2494: || ' ' || 'ID ' || lj_chr_id(i2) );
2495: END IF;

Line 2492: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2488: l_ctcv_tbl_in(idx1).sales_group_id := l_current_salesgrp_id ;
2489: END IF;
2490:
2491: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2492: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2493: 'contract selected to create new contact : ' || l_contract_number
2494: || ' ' || 'ID ' || lj_chr_id(i2) );
2495: END IF;
2496: idx1 := idx1 +1;

Line 2508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2504: CLOSE create_contact_resource;
2505: END IF;
2506:
2507:
2508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2509: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2510: 'Populating l_ctcv_tbl_in completed');
2511: END IF;
2512:

Line 2509: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2505: END IF;
2506:
2507:
2508: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2509: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2510: 'Populating l_ctcv_tbl_in completed');
2511: END IF;
2512:
2513: -- Get all contacts that has to be updated.

Line 2521: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2517: lr_cpl_id,lr_upd_cpl_org_id limit 1000;
2518: IF (lr_cpl_id.count > 0 ) THEN
2519: FOR i3 in lr_cpl_id.first .. lr_cpl_id.last
2520: LOOP
2521: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2523: 'Contacts selected for update ' || lr_cpl_id(i3) );
2524: END IF;
2525: l_ctcv_tbl_in_upd(idx2).id := lr_cpl_id(i3);

Line 2522: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2518: IF (lr_cpl_id.count > 0 ) THEN
2519: FOR i3 in lr_cpl_id.first .. lr_cpl_id.last
2520: LOOP
2521: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2522: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2523: 'Contacts selected for update ' || lr_cpl_id(i3) );
2524: END IF;
2525: l_ctcv_tbl_in_upd(idx2).id := lr_cpl_id(i3);
2526: l_ctcv_tbl_in_upd(idx2).end_date := sysdate-1;

Line 2538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2534: END LOOP;
2535: IF update_contact_resource%ISOPEN THEN
2536: CLOSE update_contact_resource;
2537: END IF;
2538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2539: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2540: 'Populating l_ctcv_tbl_in_upd completed');
2541: END IF;
2542:

Line 2539: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2535: IF update_contact_resource%ISOPEN THEN
2536: CLOSE update_contact_resource;
2537: END IF;
2538: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2539: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2540: 'Populating l_ctcv_tbl_in_upd completed');
2541: END IF;
2542:
2543: -- Get all contacts that has to be deleted.

Line 2551: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2547: lr_del_cpl_id,lr_del_cpl_org_id limit 1000;
2548: IF (lr_del_cpl_id.count >0 ) THEN
2549: FOR i4 in lr_del_cpl_id.first .. lr_del_cpl_id.last
2550: LOOP
2551: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2552: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2553: 'Contacts selected for delete ' || lr_del_cpl_id(i4));
2554: END IF;
2555: l_ctcv_tbl_in_del(i4).id := lr_del_cpl_id(i4);

Line 2552: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2548: IF (lr_del_cpl_id.count >0 ) THEN
2549: FOR i4 in lr_del_cpl_id.first .. lr_del_cpl_id.last
2550: LOOP
2551: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2552: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2553: 'Contacts selected for delete ' || lr_del_cpl_id(i4));
2554: END IF;
2555: l_ctcv_tbl_in_del(i4).id := lr_del_cpl_id(i4);
2556: l_ctcv_tbl_in_del(i4).attribute1 := lr_del_cpl_org_id(i4);

Line 2568: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2564: IF delete_contact_resource%ISOPEN THEN
2565: CLOSE delete_contact_resource;
2566: END IF;
2567:
2568: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2569: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2570: 'Completed populating PL/SQL tables for create, update and delete');
2571: END IF;
2572:

Line 2569: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2565: CLOSE delete_contact_resource;
2566: END IF;
2567:
2568: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2569: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2570: 'Completed populating PL/SQL tables for create, update and delete');
2571: END IF;
2572:
2573: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2573: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2569: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2570: 'Completed populating PL/SQL tables for create, update and delete');
2571: END IF;
2572:
2573: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2574: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2575: ' Number of records selected for update ' || l_ctcv_tbl_in_upd.count || ' ' ||
2576: ' Number of records selected for delete ' || l_ctcv_tbl_in_del.count || ' ' ||
2577: ' Number of records selected for create ' || l_ctcv_tbl_in.count) ;

Line 2574: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2570: 'Completed populating PL/SQL tables for create, update and delete');
2571: END IF;
2572:
2573: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2574: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2575: ' Number of records selected for update ' || l_ctcv_tbl_in_upd.count || ' ' ||
2576: ' Number of records selected for delete ' || l_ctcv_tbl_in_del.count || ' ' ||
2577: ' Number of records selected for create ' || l_ctcv_tbl_in.count) ;
2578: END IF;

Line 2601: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2597: END LOOP;
2598: END IF;
2599:
2600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2601: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2602: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2603: 'Exception in update contact ');
2604: END IF;
2605: fnd_file.put_line(FND_FILE.LOG,'Exception in update contact');

Line 2602: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2598: END IF;
2599:
2600: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2601: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2602: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2603: 'Exception in update contact ');
2604: END IF;
2605: fnd_file.put_line(FND_FILE.LOG,'Exception in update contact');
2606: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2630: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2626: END LOOP;
2627: END IF;
2628:
2629: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2630: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2632: 'Exception in delete contact ');
2633: END IF;
2634: fnd_file.put_line(FND_FILE.LOG,'Exception in delete contact');

Line 2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2627: END IF;
2628:
2629: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2630: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2632: 'Exception in delete contact ');
2633: END IF;
2634: fnd_file.put_line(FND_FILE.LOG,'Exception in delete contact');
2635: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2665: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2661: p_cvmv_rec => l_cvmv_rec,
2662: x_cvmv_rec => l_cvmv_out_rec);
2663:
2664:
2665: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2667: 'Contract ID: ' || l_cvmv_rec.chr_id
2668: ||' Update contract version return status '
2669: || l_return_status );

Line 2666: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2662: x_cvmv_rec => l_cvmv_out_rec);
2663:
2664:
2665: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2667: 'Contract ID: ' || l_cvmv_rec.chr_id
2668: ||' Update contract version return status '
2669: || l_return_status );
2670: END IF;

Line 2682: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2678: p_restricted_update => OKC_API.G_TRUE,
2679: p_chrv_rec => l_chrv_rec,
2680: x_chrv_rec => l_chrv_out_rec);
2681:
2682: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2683: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2684: 'Update contract header return status '
2685: || l_return_status );
2686: END IF;

Line 2683: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2679: p_chrv_rec => l_chrv_rec,
2680: x_chrv_rec => l_chrv_out_rec);
2681:
2682: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2683: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2684: 'Update contract header return status '
2685: || l_return_status );
2686: END IF;
2687: FND_MESSAGE.SET_NAME('OKS','OKS_NOTIFY_SALESREP');

Line 2700: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2696:
2697:
2698: ELSE
2699:
2700: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2701: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2702: 'This contract could not create vendor contact : '
2703: || l_ctcv_rec_out_ins.attribute1 || ' '
2704: || l_ctcv_rec_out_ins.attribute2 );

Line 2701: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2697:
2698: ELSE
2699:
2700: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2701: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2702: 'This contract could not create vendor contact : '
2703: || l_ctcv_rec_out_ins.attribute1 || ' '
2704: || l_ctcv_rec_out_ins.attribute2 );
2705: END IF;

Line 2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2713: idx3 := l_ctcv_tbl_in.NEXT(idx3);
2714: END LOOP;
2715: END IF;
2716:
2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2718: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2719: 'Start upadate and create contact process : No of contacts : '
2720: ||l_ctcv_tbl_in.count );
2721: END IF;

Line 2718: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2714: END LOOP;
2715: END IF;
2716:
2717: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2718: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2719: 'Start upadate and create contact process : No of contacts : '
2720: ||l_ctcv_tbl_in.count );
2721: END IF;
2722:

Line 2733: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2729:
2730: DELETE FROM oks_k_res_temp;
2731: DELETE FROM oks_jtf_res_temp;
2732:
2733: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2735: 'Completed Processing *****');
2736: END IF;
2737:

Line 2734: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2730: DELETE FROM oks_k_res_temp;
2731: DELETE FROM oks_jtf_res_temp;
2732:
2733: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2735: 'Completed Processing *****');
2736: END IF;
2737:
2738: IF GET_ALL_CONTRACTS_1%ISOPEN THEN

Line 2774: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2770:
2771: END IF;
2772: END LOOP;
2773:
2774: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2775: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2776: 'Out of Main Loop');
2777: END IF;
2778:

Line 2775: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2771: END IF;
2772: END LOOP;
2773:
2774: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2775: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2776: 'Out of Main Loop');
2777: END IF;
2778:
2779: IF GET_ALL_CONTRACTS_1%ISOPEN THEN

Line 2815: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2811: END IF;
2812:
2813: END IF; --CRO_CODE
2814: END IF; --Use JTF
2815: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2816: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2817: 'Reassugn End Time ' ||
2818: to_char(sysdate,'HH:MI:SS') );
2819: END IF;

Line 2816: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2812:
2813: END IF; --CRO_CODE
2814: END IF; --Use JTF
2815: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2816: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2817: 'Reassugn End Time ' ||
2818: to_char(sysdate,'HH:MI:SS') );
2819: END IF;
2820: fnd_file.put_line(FND_FILE.LOG,'Program completed successfully ' || to_char(sysdate,'HH:MI:SS'));

Line 2825: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2821: EXCEPTION
2822:
2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2825: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2827: 'Error occured : ' || get_fnd_message() );
2828: END IF;
2829: rollback;

Line 2826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2822:
2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2825: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2827: 'Error occured : ' || get_fnd_message() );
2828: END IF;
2829: rollback;
2830: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');

Line 2833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2829: rollback;
2830: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2832: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2835: 'Unexpected Error : ' || get_fnd_message() );
2836: END IF;
2837: rollback;

Line 2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2830: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2832: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2835: 'Unexpected Error : ' || get_fnd_message() );
2836: END IF;
2837: rollback;
2838: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');

Line 2848: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2844: p_token1_value => sqlcode,
2845: p_token2 => g_sqlerrm_token,
2846: p_token2_value => sqlerrm);
2847:
2848: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2850: 'Other Exception occured ' || sqlerrm);
2851: END IF;
2852: rollback;

Line 2849: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

2845: p_token2 => g_sqlerrm_token,
2846: p_token2_value => sqlerrm);
2847:
2848: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2849: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2850: 'Other Exception occured ' || sqlerrm);
2851: END IF;
2852: rollback;
2853: RAISE_APPLICATION_ERROR(-20001, 'Exception occured: other exception');