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.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on OZF_UTILITY_PVT

Line 28: Ozf_Utility_pvt.write_conc_log (p_text);

24: p_text IN VARCHAR2
25: ) IS
26: BEGIN
27: IF G_DEBUG_LEVEL THEN
28: Ozf_Utility_pvt.write_conc_log (p_text);
29: -- Ozf_Utility_pvt.write_conc_log (p_text);
30: END IF;
31: END write_conc_log;
32: /*****************************************************************************

Line 29: -- Ozf_Utility_pvt.write_conc_log (p_text);

25: ) IS
26: BEGIN
27: IF G_DEBUG_LEVEL THEN
28: Ozf_Utility_pvt.write_conc_log (p_text);
29: -- Ozf_Utility_pvt.write_conc_log (p_text);
30: END IF;
31: END write_conc_log;
32: /*****************************************************************************
33: * NAME

Line 686: Ozf_Utility_pvt.write_conc_log(l_full_name || ': START for territory ' || p_terr_id);

682: --
683: p_retcode := 0;
684: FND_MSG_PUB.initialize;
685: --
686: Ozf_Utility_pvt.write_conc_log(l_full_name || ': START for territory ' || p_terr_id);
687: --
688: l_terr_id := p_terr_id;
689:
690: --R12: mkothari

Line 1452: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Rows inserted in ams denorm table: '||l_index);

1448: l_index := dbms_sql.execute(l_denorm_csr);
1449: write_conc_log('D: After executing ');
1450: dbms_sql.close_cursor(l_denorm_csr);
1451:
1452: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Rows inserted in ams denorm table: '||l_index);
1453:
1454: --TRAY
1455: --Needs to be done here so that the copied row is not lost
1456: if l_store_index>0 then

Line 1586: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Success for territory ' || p_terr_id);

1582: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1583: AND acct_site.cust_account_id = acct.cust_account_id)
1584: WHERE a.market_qualifier_type = 'TERRITORY'
1585: AND a.market_qualifier_reference = p_terr_id;
1586: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Success for territory ' || p_terr_id);
1587:
1588: ---R12 ------
1589: Ozf_Utility_pvt.write_conc_log(l_full_name || ': BEGIN - Adjusting Account Targets for Territory = '|| p_terr_id || ';');
1590: OZF_ALLOCATION_ENGINE_PVT.adjust_account_targets(p_retcode, p_errbuf, p_terr_id);

Line 1589: Ozf_Utility_pvt.write_conc_log(l_full_name || ': BEGIN - Adjusting Account Targets for Territory = '|| p_terr_id || ';');

1585: AND a.market_qualifier_reference = p_terr_id;
1586: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Success for territory ' || p_terr_id);
1587:
1588: ---R12 ------
1589: Ozf_Utility_pvt.write_conc_log(l_full_name || ': BEGIN - Adjusting Account Targets for Territory = '|| p_terr_id || ';');
1590: OZF_ALLOCATION_ENGINE_PVT.adjust_account_targets(p_retcode, p_errbuf, p_terr_id);
1591: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END - Adjusting Account Targets for Territory = ' || p_terr_id || ';');
1592:
1593:

Line 1591: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END - Adjusting Account Targets for Territory = ' || p_terr_id || ';');

1587:
1588: ---R12 ------
1589: Ozf_Utility_pvt.write_conc_log(l_full_name || ': BEGIN - Adjusting Account Targets for Territory = '|| p_terr_id || ';');
1590: OZF_ALLOCATION_ENGINE_PVT.adjust_account_targets(p_retcode, p_errbuf, p_terr_id);
1591: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END - Adjusting Account Targets for Territory = ' || p_terr_id || ';');
1592:
1593:
1594: /* recursively generate party list for the territory's children
1595: passing in parent's qualifier directly so don't need to calculate again

Line 1624: Ozf_Utility_pvt.write_conc_log('Exception in get_party_territory ' || sqlerrm);

1620: END LOOP;
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: /* Let the master procdure handle exception */
1624: Ozf_Utility_pvt.write_conc_log('Exception in get_party_territory ' || sqlerrm);
1625: p_retcode := 1;
1626: l_err_msg := 'Exception while generating parties for territory id=' ||
1627: p_terr_id || ' - ' || sqlerrm;
1628: p_errbuf := l_err_msg;

Line 1679: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start buyinggroup_id=' || p_bg_id);

1675: CURSOR c_party_mkt_seg_seq IS -- generate an ID
1676: SELECT AMS_PARTY_MARKET_SEGMENTS_S.NEXTVAL
1677: FROM DUAL;
1678: BEGIN
1679: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start buyinggroup_id=' || p_bg_id);
1680: p_errbuf := null;
1681: p_retcode := 0;
1682: -- delete all buying group records for this subject_id
1683:

Line 1739: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END buyinggroup_id=' || p_bg_id);

1735: -- dbms_output.put_line('buy(' || p_bg_id || '): object count=' || l_obj_list.count);
1736: IF l_obj_list.count = 0 THEN
1737: -- return. Leaf node.
1738: p_obj_list := l_obj_list;
1739: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END buyinggroup_id=' || p_bg_id);
1740: return;
1741: END IF;
1742: FOR I IN NVL(l_obj_list.FIRST, 1) .. NVL(l_obj_list.LAST, 0) LOOP
1743: OPEN c_party_mkt_seg_seq;

Line 1855: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END buyinggroup_id=' || p_bg_id);

1851: , l_all_obj_list(I)
1852: );
1853: END IF;
1854: p_obj_list := l_all_obj_list;
1855: Ozf_Utility_pvt.write_conc_log(l_full_name || ': END buyinggroup_id=' || p_bg_id);
1856: EXCEPTION
1857: WHEN OTHERS THEN
1858: /* Let the master procdure handle exception */
1859: p_retcode := 1;

Line 1992: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start ');

1988: -- R12
1989: CURSOR client_info_csr(l_terr_id NUMBER) IS select org_id from jtf_terr_all where terr_id = l_terr_id;
1990:
1991: BEGIN
1992: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Start ');
1993: SAVEPOINT LOAD_PARTY_MARKET_QUALIFIER;
1994: -- mo_global.init('JTF');
1995: -- mo_global.set_policy_context('M',null);
1996: errbuf := null;

Line 2085: Ozf_Utility_pvt.write_conc_log(l_full_name||': Org for territory ' ||p_terr_id||' is => '||l_org_id);

2081: -- R12 - Added
2082: OPEN client_info_csr(p_terr_id);
2083: FETCH client_info_csr into l_org_id;
2084: CLOSE client_info_csr;
2085: Ozf_Utility_pvt.write_conc_log(l_full_name||': Org for territory ' ||p_terr_id||' is => '||l_org_id);
2086: mo_global.init('JTF');
2087: mo_global.set_policy_context('S',l_org_id);
2088: generate_party_for_territory(errbuf, retcode, p_terr_id, 'Y', l_bind_vars);
2089:

Line 2092: ---Ozf_Utility_pvt.write_conc_log(l_full_name || ': Adjusting Account Targets for Territory = '

2088: generate_party_for_territory(errbuf, retcode, p_terr_id, 'Y', l_bind_vars);
2089:
2090: -- mkothari - sep-09-2005 --R12
2091: -- adjust the account targets if any accounts have moved
2092: ---Ozf_Utility_pvt.write_conc_log(l_full_name || ': Adjusting Account Targets for Territory = '
2093: --- || p_terr_id || ' ... ');
2094: --OZF_ALLOCATION_ENGINE_PVT.adjust_account_targets(retcode, errbuf, p_terr_id);
2095:
2096: ELSE

Line 2149: Ozf_Utility_pvt.write_conc_log(l_full_name||': Org for territory ' ||l_terr_id||' is => '||l_org_id);

2145: -- R12 - Added
2146: OPEN client_info_csr(l_terr_id);
2147: FETCH client_info_csr into l_org_id;
2148: CLOSE client_info_csr;
2149: Ozf_Utility_pvt.write_conc_log(l_full_name||': Org for territory ' ||l_terr_id||' is => '||l_org_id);
2150: mo_global.init('JTF');
2151: mo_global.set_policy_context('S',l_org_id);
2152: generate_party_for_territory(errbuf, retcode, l_terr_id, 'N', l_bind_vars);
2153: END LOOP;

Line 2159: ---Ozf_Utility_pvt.write_conc_log(l_full_name || ': Adjusting Account Targets ... ');

2155:
2156:
2157: -- mkothari - sep-09-2005 --R12
2158: -- adjust the account targets if any accounts have moved
2159: ---Ozf_Utility_pvt.write_conc_log(l_full_name || ': Adjusting Account Targets ... ');
2160: --OZF_ALLOCATION_ENGINE_PVT.adjust_account_targets(retcode, errbuf, NULL);
2161:
2162: END IF;
2163: Ozf_Utility_pvt.write_conc_log;

Line 2163: Ozf_Utility_pvt.write_conc_log;

2159: ---Ozf_Utility_pvt.write_conc_log(l_full_name || ': Adjusting Account Targets ... ');
2160: --OZF_ALLOCATION_ENGINE_PVT.adjust_account_targets(retcode, errbuf, NULL);
2161:
2162: END IF;
2163: Ozf_Utility_pvt.write_conc_log;
2164: COMMIT;
2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: ROLLBACK TO LOAD_PARTY_MARKET_QUALIFIER;

Line 2169: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Exception ' || sqlerrm);

2165: EXCEPTION
2166: WHEN OTHERS THEN
2167: ROLLBACK TO LOAD_PARTY_MARKET_QUALIFIER;
2168: retcode := 1;
2169: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Exception ' || sqlerrm);
2170: Ozf_Utility_pvt.write_conc_log;
2171: END LOAD_PARTY_MARKET_QUALIFIER;
2172: END OZF_Party_Mkt_Seg_Loader_PVT;

Line 2170: Ozf_Utility_pvt.write_conc_log;

2166: WHEN OTHERS THEN
2167: ROLLBACK TO LOAD_PARTY_MARKET_QUALIFIER;
2168: retcode := 1;
2169: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Exception ' || sqlerrm);
2170: Ozf_Utility_pvt.write_conc_log;
2171: END LOAD_PARTY_MARKET_QUALIFIER;
2172: END OZF_Party_Mkt_Seg_Loader_PVT;