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.IEX_STRATEGY_CNT_PUB dependencies on FND_FILE

Line 222: fnd_file.put_line(FND_FILE.LOG, 'Pre Delinquency flag raised exception; sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

218: SELECT decode(COUNT(*), 0, 'N', 'Y') into pre_delinquency_flag FROM IEX_STRATEGY_TEMPLATES_VL
219: WHERE CATEGORY_TYPE = l_DelStatusPreDel;
220: EXCEPTION
221: WHEN OTHERS THEN
222: fnd_file.put_line(FND_FILE.LOG, 'Pre Delinquency flag raised exception; sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
223: end;
224:
225: write_log(FND_LOG.LEVEL_UNEXPECTED, 'pre-delinquency strategy template flag = ' ||pre_delinquency_flag);
226:

Line 352: fnd_file.put_line(FND_FILE.LOG, l_del_query);

348: end if;
349: END IF;
350: --Bug#6870773 Naveen
351:
352: fnd_file.put_line(FND_FILE.LOG, l_del_query);
353: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
354: OPEN c_open_delinquencies
355: FOR l_del_query;
356: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records

Line 451: fnd_file.put_line(FND_FILE.LOG, 'NO score available ' ||

447: -- End - Andre Araujo -- bug#4551569 - 08/18/2005 - Scores for delinquencies still not being picked up
448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: fnd_file.put_line(FND_FILE.LOG, 'NO score available ' ||
452: ' object Type ' || l_stry_cnt_rec.jtf_object_type ||
453: ' object ID ' || l_stry_cnt_rec.jtf_object_id);
454: l_strategy_rec.score_value := 0;
455: l_stry_cnt_rec.score_value := 0;

Line 790: fnd_file.put_line(FND_FILE.LOG,'Value of l_strategy_rec.org_id : '|| l_strategy_rec.org_id);

786: Begin
787: -- bug 4141678 begin - ctlee
788: -- p_commit set to false
789: -- bug 4141678 end - ctlee
790: fnd_file.put_line(FND_FILE.LOG,'Value of l_strategy_rec.org_id : '|| l_strategy_rec.org_id);
791: iex_strategy_pvt.create_strategy(
792: P_Api_Version_Number=>2.0,
793: p_commit => FND_API.G_FALSE,
794: P_Init_Msg_List =>FND_API.G_TRUE,

Line 845: fnd_file.put_line(FND_FILE.LOG, ' Exception: Create Strategy/Workflow Launch Return status = '

841: || l_return_status) ;
842: end if;
843: EXCEPTION
844: WHEN OTHERS THEN
845: fnd_file.put_line(FND_FILE.LOG, ' Exception: Create Strategy/Workflow Launch Return status = '
846: || l_return_status || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
847: retcode := '2';
848: -- bug 4141678 begin - ctlee
849: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);

Line 849: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);

845: fnd_file.put_line(FND_FILE.LOG, ' Exception: Create Strategy/Workflow Launch Return status = '
846: || l_return_status || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
847: retcode := '2';
848: -- bug 4141678 begin - ctlee
849: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);
850: fnd_file.put_line(FND_FILE.LOG, 'save count = ' || l_save_count);
851: rollback;
852: l_save_count := 0;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 850: fnd_file.put_line(FND_FILE.LOG, 'save count = ' || l_save_count);

846: || l_return_status || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
847: retcode := '2';
848: -- bug 4141678 begin - ctlee
849: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);
850: fnd_file.put_line(FND_FILE.LOG, 'save count = ' || l_save_count);
851: rollback;
852: l_save_count := 0;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: exit;

Line 894: fnd_file.put_line(FND_FILE.LOG, 'Delinquency Concurrent raised exception sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

890: close c_open_delinquencies;
891:
892: EXCEPTION
893: WHEN OTHERS THEN
894: fnd_file.put_line(FND_FILE.LOG, 'Delinquency Concurrent raised exception sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
895: close c_open_delinquencies;
896: -- bug 4141678 begin - ctlee
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: -- bug 4141678 end - ctlee

Line 985: fnd_file.put_line(FND_FILE.LOG, 'Strategy Closed Raised Exception = ' ||

981: write_log(FND_LOG.LEVEL_PROCEDURE, 'Strategy Closed. id = ' || l_stry_cnt_rec.strategy_id);
982:
983: EXCEPTION
984: WHEN OTHERS THEN
985: fnd_file.put_line(FND_FILE.LOG, 'Strategy Closed Raised Exception = ' ||
986: l_stry_cnt_rec.strategy_id || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
987: END;
988:
989: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor ends' );

Line 996: fnd_file.put_line(FND_FILE.LOG, 'Close Strategy raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

992: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor EXIT ');
993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: fnd_file.put_line(FND_FILE.LOG, 'Close Strategy raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
997:
998: END CLOSE_ALL_STRY;
999:
1000: /* Procedure for closing strategy when associated customer delinquencies are closed */

Line 1155: fnd_file.put_line(FND_FILE.LOG, 'Strategy Closed Rised Exception = '

1151: end if;
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: fnd_file.put_line(FND_FILE.LOG, 'Strategy Closed Rised Exception = '
1156: || l_strategy_id || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1157: retcode := '2';
1158: END;
1159:

Line 1171: fnd_file.put_line(FND_FILE.LOG, 'Close Strategy raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

1167: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor EXIT ');
1168: close c_open_strategies;
1169: EXCEPTION
1170: WHEN OTHERS THEN
1171: fnd_file.put_line(FND_FILE.LOG, 'Close Strategy raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1172: close c_open_strategies;
1173:
1174: END close_strategies;
1175:

Line 1530: fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When No Data Found: ' || c_DynSql );

1526: --Execute Immediate c_DynSql into v_Exists;
1527:
1528: EXCEPTION
1529: When no_data_found then
1530: fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When No Data Found: ' || c_DynSql );
1531: v_SkipTemp := 'T';
1532: When Others then
1533: fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When Others: ' || c_DynSql );
1534: v_SkipTemp := 'T';

Line 1533: fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When Others: ' || c_DynSql );

1529: When no_data_found then
1530: fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When No Data Found: ' || c_DynSql );
1531: v_SkipTemp := 'T';
1532: When Others then
1533: fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When Others: ' || c_DynSql );
1534: v_SkipTemp := 'T';
1535: END;
1536: end if;
1537:

Line 1619: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);

1615:
1616: BEGIN
1617: --Bug5022607. Fix By LKKUMAR. Remove p_trace_mode parameter. Start.
1618: -- IF p_trace_mode = 'Y' THEN
1619: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);
1620: IF PG_DEBUG = 1 THEN
1621: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
1622: dbms_session.set_sql_trace(TRUE);
1623: ELSE

Line 1621: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');

1617: --Bug5022607. Fix By LKKUMAR. Remove p_trace_mode parameter. Start.
1618: -- IF p_trace_mode = 'Y' THEN
1619: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);
1620: IF PG_DEBUG = 1 THEN
1621: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
1622: dbms_session.set_sql_trace(TRUE);
1623: ELSE
1624: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
1625: dbms_session.set_sql_trace(FALSE);

Line 1624: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');

1620: IF PG_DEBUG = 1 THEN
1621: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
1622: dbms_session.set_sql_trace(TRUE);
1623: ELSE
1624: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
1625: dbms_session.set_sql_trace(FALSE);
1626: END IF;
1627: --Bug# 6870773 Naveen
1628: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');

Line 1633: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is On ' || ' Org Id = ' || l_org_id);

1629: -- l_org_id := fnd_profile.value('ORG_ID');
1630: l_org_id:=p_org_id;
1631:
1632: if l_org_enabled = 'Y' then
1633: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is On ' || ' Org Id = ' || l_org_id);
1634:
1635: select count(1)
1636: into l_count
1637: from iex_strategies

Line 1642: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies without having org_id.');

1638: where org_id is null
1639: and strategy_level=l_DefaultStrategyLevel;
1640:
1641: if l_count>0 then
1642: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies without having org_id.');
1643: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
1644: return;
1645: end if;
1646: MO_GLOBAL.INIT('IEX');

Line 1643: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');

1639: and strategy_level=l_DefaultStrategyLevel;
1640:
1641: if l_count>0 then
1642: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies without having org_id.');
1643: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
1644: return;
1645: end if;
1646: MO_GLOBAL.INIT('IEX');
1647: IF P_ORG_ID IS NOT NULL THEN

Line 1649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);

1645: end if;
1646: MO_GLOBAL.INIT('IEX');
1647: IF P_ORG_ID IS NOT NULL THEN
1648: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
1649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
1650: ELSE
1651: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
1652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
1653: END IF;

Line 1652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');

1648: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
1649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
1650: ELSE
1651: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
1652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
1653: END IF;
1654: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
1655: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
1656: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);

Line 1656: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);

1652: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
1653: END IF;
1654: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
1655: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
1656: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
1657: l_org_id:=mo_global.get_current_org_id;
1658:
1659: CLOSE_STRATEGIES(errbuf => errbuf,
1660: retcode => retcode);

Line 1671: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is Off ');

1667:
1668: END LOOP;
1669:
1670: else
1671: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is Off ');
1672:
1673: select count(1)
1674: into l_count
1675: from iex_strategies

Line 1680: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies with org_id.');

1676: where org_id is not null
1677: and strategy_level=l_DefaultStrategyLevel;
1678:
1679: if l_count>0 then
1680: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies with org_id.');
1681: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
1682: return;
1683: end if;
1684: l_org_id := null;

Line 1681: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');

1677: and strategy_level=l_DefaultStrategyLevel;
1678:
1679: if l_count>0 then
1680: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies with org_id.');
1681: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
1682: return;
1683: end if;
1684: l_org_id := null;
1685: CLOSE_STRATEGIES(errbuf => errbuf,

Line 1706: fnd_file.put_line(FND_FILE.LOG, mesg);

1702: l_schema := 'iex';
1703: l_dot := '.';
1704: l_module := 'strategy';
1705: if (mesg_level >= l_msgLevel) then
1706: fnd_file.put_line(FND_FILE.LOG, mesg);
1707: FND_LOG.STRING(mesg_level, l_schema || l_dot || l_module , mesg);
1708: end if;
1709: END;
1710: --Bug# 6870773 Naveen

Line 1849: fnd_file.put_line(FND_FILE.LOG, 'Checking..');

1845: CLOSE c_strat_with_ou;
1846: END IF;
1847:
1848: end if;
1849: fnd_file.put_line(FND_FILE.LOG, 'Checking..');
1850: fnd_file.put_line(FND_FILE.LOG, 'Updating number of strategies ' || strategies.count);
1851: if strategies.count>0 then
1852:
1853: forall i in strategies.first..strategies.last

Line 1850: fnd_file.put_line(FND_FILE.LOG, 'Updating number of strategies ' || strategies.count);

1846: END IF;
1847:
1848: end if;
1849: fnd_file.put_line(FND_FILE.LOG, 'Checking..');
1850: fnd_file.put_line(FND_FILE.LOG, 'Updating number of strategies ' || strategies.count);
1851: if strategies.count>0 then
1852:
1853: forall i in strategies.first..strategies.last
1854: update iex_strategies

Line 1863: fnd_file.put_line(FND_FILE.LOG, 'In API update_strat_org raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

1859:
1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: write_log(FND_LOG.LEVEL_STATEMENT, 'In API update_strat_org raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1863: fnd_file.put_line(FND_FILE.LOG, 'In API update_strat_org raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1864: rollback;
1865:
1866: END;
1867:

Line 1910: fnd_file.put_line(FND_FILE.LOG, 'Default Template Name raised Exception ' || SQLCODE || ' ' || SQLERRM);

1906:
1907: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Default Template Name :' || l_DefaultTempName || ' , Enabled Flag :' || l_EnabledFlag );
1908: EXCEPTION
1909: WHEN OTHERS THEN
1910: fnd_file.put_line(FND_FILE.LOG, 'Default Template Name raised Exception ' || SQLCODE || ' ' || SQLERRM);
1911: END;
1912:
1913: begin
1914: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);

Line 1922: fnd_file.put_line(FND_FILE.LOG, 'Resource Name raised Exception ' || SQLCODE || ' ' || SQLERRM);

1918: where RESOURCE_ID=l_default_rs_id;
1919: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Resource Id :' || l_default_rs_id || ' Profile Name IEX: Strategy Assignment Default Resource (IEX_STRY_DEFAULT_RESOURCE) , Resource Name :' || l_SourceName || ' , User Name :' || l_UserName);
1920: EXCEPTION
1921: WHEN OTHERS THEN
1922: fnd_file.put_line(FND_FILE.LOG, 'Resource Name raised Exception ' || SQLCODE || ' ' || SQLERRM);
1923: END;
1924: -- Start for bug # 5877743 on 28/02/2007 by gnramasa
1925: begin
1926: --Begin Bug#7205287 31-Jul-2008 barathsr

Line 1932: fnd_file.put_line(FND_FILE.LOG, 'Resource Name raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

1928: || NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY'));
1929: --End Bug#7205287 31-Jul-2008 barathsr
1930: EXCEPTION
1931: WHEN OTHERS THEN
1932: fnd_file.put_line(FND_FILE.LOG, 'Resource Name raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1933: END;
1934: -- End for bug # 5877743 on 28/02/2007 by gnramasa
1935: begin
1936: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value

Line 1944: fnd_file.put_line(FND_FILE.LOG, 'Strategy Level Rised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

1940: write_log(FND_LOG.LEVEL_STATEMENT, 'Current Strategy Level ' || l_DefaultStrategyLevel || ' , ' || l_StrategyLevelName);
1941: -- End for bug # 5487449 on 28/08/2006 by gnramasa
1942: EXCEPTION
1943: WHEN OTHERS THEN
1944: fnd_file.put_line(FND_FILE.LOG, 'Strategy Level Rised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1945: END;
1946: END IEX_STRATEGY_CNT_PUB;