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 385: fnd_file.put_line(FND_FILE.LOG, 'Pre Delinquency flag raised exception; sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

381: SELECT decode(COUNT(*), 0, 'N', 'Y') into pre_delinquency_flag FROM IEX_STRATEGY_TEMPLATES_VL
382: WHERE CATEGORY_TYPE = l_DelStatusPreDel;
383: EXCEPTION
384: WHEN OTHERS THEN
385: fnd_file.put_line(FND_FILE.LOG, 'Pre Delinquency flag raised exception; sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
386: end;
387:
388: write_log(FND_LOG.LEVEL_UNEXPECTED, 'pre-delinquency strategy template flag = ' ||pre_delinquency_flag);
389:

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

650: end if;
651: END IF;
652: --Bug#6870773 Naveen
653:
654: fnd_file.put_line(FND_FILE.LOG, l_del_query);
655: -- Begin - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records
656: OPEN c_open_delinquencies
657: FOR l_del_query;
658: -- End - Andre Araujo -- 01/18/2005 - 4924879 - Improve performance by selecting less records

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

749: -- End - Andre Araujo -- bug#4551569 - 08/18/2005 - Scores for delinquencies still not being picked up
750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: fnd_file.put_line(FND_FILE.LOG, 'NO score available ' ||
754: ' object Type ' || l_stry_cnt_rec.jtf_object_type ||
755: ' object ID ' || l_stry_cnt_rec.jtf_object_id);
756: l_strategy_rec.score_value := 0;
757: l_stry_cnt_rec.score_value := 0;

Line 964: fnd_file.put_line(FND_FILE.LOG, ' Get Template for object '|| l_stry_cnt_rec.jtf_object_id);

960: /* No Strategy exists or Existing running are closed, create a new strategy */
961: if (((vStrategyStatus IS NULL)) or (vStrategyStatus = l_StratStatusClosed)
962: or (vStrategyStatus = l_StratStatusCancelled)) then
963:
964: fnd_file.put_line(FND_FILE.LOG, ' Get Template for object '|| l_stry_cnt_rec.jtf_object_id);
965: /* Get the strategy template ID based on the score */
966: IEX_STRATEGY_CNT_PUB.GetStrategyTempID(
967: x_return_status=>l_return_status,
968: p_stry_cnt_rec => l_stry_cnt_rec,

Line 971: fnd_file.put_line(FND_FILE.LOG, ' Template ID selected ' || l_strategy_template_id);

967: x_return_status=>l_return_status,
968: p_stry_cnt_rec => l_stry_cnt_rec,
969: x_strategy_template_id => l_strategy_template_id
970: );
971: fnd_file.put_line(FND_FILE.LOG, ' Template ID selected ' || l_strategy_template_id);
972: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
973: write_log(FND_LOG.LEVEL_PROCEDURE, 'Delinquency ID ' || l_stry_cnt_rec.delinquency_id ||
974: ' Strategy Template ID selected ' || l_strategy_template_id );
975: end if;

Line 985: fnd_file.put_line(FND_FILE.LOG, 'Cancelletion of other level Strategies completed for object ' || l_stry_cnt_rec.party_cust_id);

981: --end if;
982: cancel_strategy( l_stry_cnt_rec.party_cust_id, l_DefaultStrategyLevel,p_strategy_mode,
983: l_stry_cnt_rec.cust_account_id, l_stry_cnt_rec.customer_site_use_id, l_stry_cnt_rec.delinquency_id, p_show_output);
984: -- end for bug 8708271 multi level strategy
985: fnd_file.put_line(FND_FILE.LOG, 'Cancelletion of other level Strategies completed for object ' || l_stry_cnt_rec.party_cust_id);
986: -- begin bug 4944801 ctlee 01/18/2006
987: -- check if the template is the same
988: BEGIN
989: -- old template is vStrategyTemplateId

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

1263: Begin
1264: -- bug 4141678 begin - ctlee
1265: -- p_commit set to false
1266: -- bug 4141678 end - ctlee
1267: fnd_file.put_line(FND_FILE.LOG,'Value of l_strategy_rec.org_id : '|| l_strategy_rec.org_id);
1268: fnd_file.put_line(FND_FILE.LOG, ' Creating Strategy for ' || l_strategy_rec.object_id || ' of type ' || l_strategy_rec.object_type);
1269: iex_strategy_pvt.create_strategy(
1270: P_Api_Version_Number=>2.0,
1271: p_commit => FND_API.G_FALSE,

Line 1268: fnd_file.put_line(FND_FILE.LOG, ' Creating Strategy for ' || l_strategy_rec.object_id || ' of type ' || l_strategy_rec.object_type);

1264: -- bug 4141678 begin - ctlee
1265: -- p_commit set to false
1266: -- bug 4141678 end - ctlee
1267: fnd_file.put_line(FND_FILE.LOG,'Value of l_strategy_rec.org_id : '|| l_strategy_rec.org_id);
1268: fnd_file.put_line(FND_FILE.LOG, ' Creating Strategy for ' || l_strategy_rec.object_id || ' of type ' || l_strategy_rec.object_type);
1269: iex_strategy_pvt.create_strategy(
1270: P_Api_Version_Number=>2.0,
1271: p_commit => FND_API.G_FALSE,
1272: P_Init_Msg_List =>FND_API.G_TRUE,

Line 1281: fnd_file.put_line(FND_FILE.LOG, 'Strategy Created . Id = ' || l_strategy_id);

1277: x_strategy_id => l_strategy_id
1278: );
1279:
1280: l_strategy_rec.strategy_id := l_strategy_id;
1281: fnd_file.put_line(FND_FILE.LOG, 'Strategy Created . Id = ' || l_strategy_id);
1282: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1283: write_log(FND_LOG.LEVEL_PROCEDURE, 'Return status = ' || l_return_status);
1284: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy created. id = ' || l_strategy_id);
1285: end if;

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

1319: || l_return_status) ;
1320: end if;
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: fnd_file.put_line(FND_FILE.LOG, ' Exception: Create Strategy/Workflow Launch Return status = '
1324: || l_return_status || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1325: retcode := '2';
1326: -- bug 4141678 begin - ctlee
1327: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);

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

1323: fnd_file.put_line(FND_FILE.LOG, ' Exception: Create Strategy/Workflow Launch Return status = '
1324: || l_return_status || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1325: retcode := '2';
1326: -- bug 4141678 begin - ctlee
1327: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);
1328: fnd_file.put_line(FND_FILE.LOG, 'save count = ' || l_save_count);
1329: rollback;
1330: l_save_count := 0;
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1324: || l_return_status || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1325: retcode := '2';
1326: -- bug 4141678 begin - ctlee
1327: fnd_file.put_line(FND_FILE.LOG, 'commit count = ' || l_commit_count);
1328: fnd_file.put_line(FND_FILE.LOG, 'save count = ' || l_save_count);
1329: rollback;
1330: l_save_count := 0;
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: exit;

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

1387: close c_open_delinquencies;
1388:
1389: EXCEPTION
1390: WHEN OTHERS THEN
1391: fnd_file.put_line(FND_FILE.LOG, 'Delinquency Concurrent raised exception sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1392: close c_open_delinquencies;
1393: -- bug 4141678 begin - ctlee
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: -- bug 4141678 end - ctlee

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

1478: write_log(FND_LOG.LEVEL_PROCEDURE, 'Strategy Closed. id = ' || l_stry_cnt_rec.strategy_id);
1479:
1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: fnd_file.put_line(FND_FILE.LOG, 'Strategy Closed Raised Exception = ' ||
1483: l_stry_cnt_rec.strategy_id || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1484: END;
1485:
1486: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor ends' );

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

1489: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor EXIT ');
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: fnd_file.put_line(FND_FILE.LOG, 'Close Strategy raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1494:
1495: END CLOSE_ALL_STRY;
1496:
1497: /* Procedure for closing strategy when associated customer delinquencies are closed */

Line 1664: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Close Strategies vPLSQL :' || vPLSQL);

1660:
1661: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1662: write_log(FND_LOG.LEVEL_PROCEDURE, 'Close Strategies vPLSQL :' || vPLSQL);
1663: END IF;
1664: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Close Strategies vPLSQL :' || vPLSQL);
1665:
1666: OPEN c_open_strategies FOR vPLSQL;
1667:
1668: -- FOR f_strategy_rec in C_Open_strategies loop

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

1695: end if;
1696:
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: fnd_file.put_line(FND_FILE.LOG, 'Strategy Closed Rised Exception = '
1700: || l_strategy_id || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1701: retcode := '2';
1702: END;
1703: end if; --if p_strategy_mode = 'FINAL' then

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

1717: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor EXIT ');
1718: close c_open_strategies;
1719: EXCEPTION
1720: WHEN OTHERS THEN
1721: fnd_file.put_line(FND_FILE.LOG, 'Close Strategy raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
1722: close c_open_strategies;
1723:
1724: END close_strategies;
1725:

Line 1839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);

1835:
1836: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1837: write_log(FND_LOG.LEVEL_PROCEDURE, 'ON-HOLD vPLSQL :' || vPLSQL);
1838: END IF;
1839: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);
1840:
1841: open c_onhold_strategies for vPLSQL;
1842: loop
1843: fetch c_onhold_strategies into l_strategy_id, l_strategy_template_id, l_status_code, l_party_id;

Line 1907: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);

1903:
1904: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1905: write_log(FND_LOG.LEVEL_PROCEDURE, 'ON-HOLD vPLSQL :' || vPLSQL);
1906: END IF;
1907: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);
1908:
1909: open c_onhold_strategies for vPLSQL;
1910: loop
1911: fetch c_onhold_strategies into l_strategy_id, l_strategy_template_id, l_status_code, l_cust_account_id;

Line 1977: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);

1973:
1974: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1975: write_log(FND_LOG.LEVEL_PROCEDURE, 'ON-HOLD vPLSQL :' || vPLSQL);
1976: END IF;
1977: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);
1978:
1979: open c_onhold_strategies for vPLSQL;
1980: loop
1981: fetch c_onhold_strategies into l_strategy_id, l_strategy_template_id, l_status_code, l_cust_site_use_id;

Line 2045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);

2041:
2042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2043: write_log(FND_LOG.LEVEL_PROCEDURE, 'ON-HOLD vPLSQL :' || vPLSQL);
2044: END IF;
2045: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ON-HOLD vPLSQL :' || vPLSQL);
2046:
2047: open c_onhold_strategies for vPLSQL;
2048: loop
2049: fetch c_onhold_strategies into l_strategy_id, l_strategy_template_id, l_status_code, l_delinquency_id;

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

2306: --Execute Immediate c_DynSql into v_Exists;
2307:
2308: EXCEPTION
2309: When no_data_found then
2310: -- fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When No Data Found: ' || c_DynSql );
2311: write_log(FND_LOG.LEVEL_STATEMENT, ' Get Strategy Template: When No Data Found: ' || c_DynSql ); -- changed for bug 9039794
2312: v_SkipTemp := 'T';
2313: When Others then
2314: -- fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When Others: ' || c_DynSql );

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

2310: -- fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When No Data Found: ' || c_DynSql );
2311: write_log(FND_LOG.LEVEL_STATEMENT, ' Get Strategy Template: When No Data Found: ' || c_DynSql ); -- changed for bug 9039794
2312: v_SkipTemp := 'T';
2313: When Others then
2314: -- fnd_file.put_line(FND_FILE.LOG, ' Get Strategy Template: When Others: ' || c_DynSql );
2315: write_log(FND_LOG.LEVEL_STATEMENT, ' Get Strategy Template: When Others: ' || c_DynSql ); -- changed for bug 9039794
2316: v_SkipTemp := 'T';
2317: END;
2318: end if;

Line 2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'STRATEGYMODE : ' || p_strategy_mode);

2466:
2467:
2468: --Start adding for bug 8630852 by gnramasa 13-July-09
2469: l_api_name := 'Main ';
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'STRATEGYMODE : ' || p_strategy_mode);
2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);

Line 2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);

2467:
2468: --Start adding for bug 8630852 by gnramasa 13-July-09
2469: l_api_name := 'Main ';
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'STRATEGYMODE : ' || p_strategy_mode);
2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);

Line 2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);

2468: --Start adding for bug 8630852 by gnramasa 13-July-09
2469: l_api_name := 'Main ';
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'STRATEGYMODE : ' || p_strategy_mode);
2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);

Line 2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);

2469: l_api_name := 'Main ';
2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'STRATEGYMODE : ' || p_strategy_mode);
2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);

Line 2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);

2470: FND_FILE.PUT_LINE(FND_FILE.LOG, 'STRATEGYMODE : ' || p_strategy_mode);
2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2478:

Line 2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);

2471: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SHOW OUTPUT : '|| p_show_output);
2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2478:
2479: writelog(G_PKG_NAME || ' ' || l_api_name || ' - strategy mode :' || p_strategy_mode);

Line 2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);

2472: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME LOW : ' || p_customer_name_low);
2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2478:
2479: writelog(G_PKG_NAME || ' ' || l_api_name || ' - strategy mode :' || p_strategy_mode);
2480: writelog(G_PKG_NAME || ' ' || l_api_name || ' - p_show_output :'|| p_show_output);

Line 2477: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);

2473: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CUSTOMER NAME HIGH : ' || p_customer_name_high);
2474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER LOW : ' || p_account_number_low);
2475: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ACCOUNT NUMBER HIGH : ' || p_account_number_high);
2476: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION LOW : ' || p_billto_location_low);
2477: FND_FILE.PUT_LINE(FND_FILE.LOG, 'BILLTO LOCATION HIGH : ' || p_billto_location_high);
2478:
2479: writelog(G_PKG_NAME || ' ' || l_api_name || ' - strategy mode :' || p_strategy_mode);
2480: writelog(G_PKG_NAME || ' ' || l_api_name || ' - p_show_output :'|| p_show_output);
2481: writelog(G_PKG_NAME || ' ' || l_api_name || ' - p_customer_name_low :' || p_customer_name_low);

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

2505: --End adding for bug 8630852 by gnramasa 13-July-09
2506:
2507: --Bug5022607. Fix By LKKUMAR. Remove p_trace_mode parameter. Start.
2508: -- IF p_trace_mode = 'Y' THEN
2509: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);
2510: IF PG_DEBUG = 1 THEN
2511: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
2512: dbms_session.set_sql_trace(TRUE);
2513: ELSE

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

2507: --Bug5022607. Fix By LKKUMAR. Remove p_trace_mode parameter. Start.
2508: -- IF p_trace_mode = 'Y' THEN
2509: fnd_file.put_line(FND_FILE.LOG,'Value of profile IEX: Debug Level is : '|| PG_DEBUG);
2510: IF PG_DEBUG = 1 THEN
2511: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
2512: dbms_session.set_sql_trace(TRUE);
2513: ELSE
2514: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
2515: dbms_session.set_sql_trace(FALSE);

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

2510: IF PG_DEBUG = 1 THEN
2511: fnd_file.put_line(FND_FILE.LOG, ' Enabling the trace');
2512: dbms_session.set_sql_trace(TRUE);
2513: ELSE
2514: fnd_file.put_line(FND_FILE.LOG,' Trace not enabled');
2515: dbms_session.set_sql_trace(FALSE);
2516: END IF;
2517: --Bug# 6870773 Naveen
2518: l_org_enabled := nvl(fnd_profile.value('IEX_PROC_STR_ORG'),'N');

Line 2526: fnd_file.put_line(FND_FILE.LOG, 'Update Multi Level Strategy Setup in Questionnaire table');

2522: --call gen_xml_header_data_strategy to generate the xml header data
2523: IF p_show_output ='Y' THEN
2524: gen_xml_header_data_strategy (p_strategy_mode => p_strategy_mode);
2525: END IF;
2526: fnd_file.put_line(FND_FILE.LOG, 'Update Multi Level Strategy Setup in Questionnaire table');
2527: writelog(' Update Multi Level Strategy Setup in Questionnaire table');
2528: IEX_CHECKLIST_UTILITY.UPDATE_MLSETUP;
2529: writelog(' End update Multi Level Setup in Questionnaire table');
2530: OPEN c_collections_method;

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

2532: close c_collections_method;
2533: -- below condition added by snuthala for bug 10221334 on 12/2/2010
2534: if l_collection_method <> 'DUNNING' then
2535: if l_org_enabled = 'Y' then
2536: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is On ' || ' Org Id = ' || l_org_id);
2537:
2538: select count(1)
2539: into l_count
2540: from iex_strategies

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

2541: where org_id is null
2542: and strategy_level=l_DefaultStrategyLevel;
2543:
2544: if l_count>0 then
2545: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies without having org_id.');
2546: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
2547: return;
2548: end if;
2549:

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

2542: and strategy_level=l_DefaultStrategyLevel;
2543:
2544: if l_count>0 then
2545: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies without having org_id.');
2546: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
2547: return;
2548: end if;
2549:
2550: -- start for bug 11844672 pnaveenk

Line 2558: fnd_file.put_line(FND_FILE.LOG,' Collections method is set up as Dunning and Strategies');

2554: FETCH c_check_ou_methods INTO l_ou_methods;
2555: CLOSE c_check_ou_methods;
2556:
2557: IF l_ou_methods = 0 AND l_collection_method = 'DUN_STR' THEN
2558: fnd_file.put_line(FND_FILE.LOG,' Collections method is set up as Dunning and Strategies');
2559: IF p_org_id IS NULL THEN
2560: fnd_file.put_line(FND_FILE.LOG,' But none of the Operating Units got registered with business level ');
2561: ELSE
2562: fnd_file.put_line(FND_FILE.LOG,' Operating Unit '|| p_org_id|| ' is not registered with business level');

Line 2560: fnd_file.put_line(FND_FILE.LOG,' But none of the Operating Units got registered with business level ');

2556:
2557: IF l_ou_methods = 0 AND l_collection_method = 'DUN_STR' THEN
2558: fnd_file.put_line(FND_FILE.LOG,' Collections method is set up as Dunning and Strategies');
2559: IF p_org_id IS NULL THEN
2560: fnd_file.put_line(FND_FILE.LOG,' But none of the Operating Units got registered with business level ');
2561: ELSE
2562: fnd_file.put_line(FND_FILE.LOG,' Operating Unit '|| p_org_id|| ' is not registered with business level');
2563: END IF;
2564: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',

Line 2562: fnd_file.put_line(FND_FILE.LOG,' Operating Unit '|| p_org_id|| ' is not registered with business level');

2558: fnd_file.put_line(FND_FILE.LOG,' Collections method is set up as Dunning and Strategies');
2559: IF p_org_id IS NULL THEN
2560: fnd_file.put_line(FND_FILE.LOG,' But none of the Operating Units got registered with business level ');
2561: ELSE
2562: fnd_file.put_line(FND_FILE.LOG,' Operating Unit '|| p_org_id|| ' is not registered with business level');
2563: END IF;
2564: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',
2565: message => 'Atleast one OU must be registered with business level to run the program ');
2566: return;

Line 2569: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );

2565: message => 'Atleast one OU must be registered with business level to run the program ');
2566: return;
2567: END IF;
2568: -- end for bug 11844672
2569: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2570: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2571: MO_GLOBAL.INIT('IEX');
2572: IF P_ORG_ID IS NOT NULL THEN
2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.

Line 2570: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);

2566: return;
2567: END IF;
2568: -- end for bug 11844672
2569: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2570: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2571: MO_GLOBAL.INIT('IEX');
2572: IF P_ORG_ID IS NOT NULL THEN
2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
2574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);

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

2570: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2571: MO_GLOBAL.INIT('IEX');
2572: IF P_ORG_ID IS NOT NULL THEN
2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
2574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
2575: ELSE
2576: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
2578: END IF;

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

2573: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID); -- Single Org.
2574: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || p_org_id);
2575: ELSE
2576: MO_GLOBAL.SET_POLICY_CONTEXT('M',NULL); -- Multi Org.
2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
2578: END IF;
2579: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
2580: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);

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

2577: FND_FILE.PUT_LINE(FND_FILE.LOG, 'MO: Operating Unit=' || 'All');
2578: END IF;
2579: FOR I_ORG IN C_ORG LOOP -- Moac Changes. Loop through for Party.
2580: MO_GLOBAL.SET_POLICY_CONTEXT('S',I_ORG.organization_id); -- Moac Changes. Set Org.
2581: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Party Loop, Operating Unit Set =' ||I_ORG.organization_id);
2582: l_org_id:=mo_global.get_current_org_id;
2583: -- Start for bug 8708271 multi level strategy
2584: l_c_org_count := l_c_org_count + 1; -- added by snuthala for bug 10221334 on 21-10-2010
2585: if l_org_override ='Y' then

Line 2586: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is on');

2582: l_org_id:=mo_global.get_current_org_id;
2583: -- Start for bug 8708271 multi level strategy
2584: l_c_org_count := l_c_org_count + 1; -- added by snuthala for bug 10221334 on 21-10-2010
2585: if l_org_override ='Y' then
2586: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is on');
2587: -- Start added by snuthala for bug 10221334 on 21-10-2010
2588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id : '|| l_org_id);
2589: OPEN c_collections_method;
2590: FETCH c_collections_method INTO l_collection_method;

Line 2588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id : '|| l_org_id);

2584: l_c_org_count := l_c_org_count + 1; -- added by snuthala for bug 10221334 on 21-10-2010
2585: if l_org_override ='Y' then
2586: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is on');
2587: -- Start added by snuthala for bug 10221334 on 21-10-2010
2588: FND_FILE.PUT_LINE(FND_FILE.LOG, 'org_id : '|| l_org_id);
2589: OPEN c_collections_method;
2590: FETCH c_collections_method INTO l_collection_method;
2591: close c_collections_method;
2592: -- select collections_methods into from iex_questionnaire_items;

Line 2593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collection_method);

2589: OPEN c_collections_method;
2590: FETCH c_collections_method INTO l_collection_method;
2591: close c_collections_method;
2592: -- select collections_methods into from iex_questionnaire_items;
2593: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collection_method);
2594: OPEN C_org_id_coll_method (l_org_id);
2595: FETCH C_org_id_coll_method INTO l_org_id_coll_method;
2596: if l_collection_method = 'DUN_STR' and C_org_id_coll_method%NOTFOUND THEN
2597: l_unregistered_org_ids := l_unregistered_org_ids +1;

Line 2598: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' is not registered');

2594: OPEN C_org_id_coll_method (l_org_id);
2595: FETCH C_org_id_coll_method INTO l_org_id_coll_method;
2596: if l_collection_method = 'DUN_STR' and C_org_id_coll_method%NOTFOUND THEN
2597: l_unregistered_org_ids := l_unregistered_org_ids +1;
2598: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' is not registered');
2599: END IF;
2600: close C_org_id_coll_method;
2601: -- select nvl(collections_method,'STRATEGIES') into l_org_id_coll_method from IEX_app_preferences_b where org_id = l_org_id and enabled_flag ='Y';
2602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);

Line 2602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);

2598: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' is not registered');
2599: END IF;
2600: close C_org_id_coll_method;
2601: -- select nvl(collections_method,'STRATEGIES') into l_org_id_coll_method from IEX_app_preferences_b where org_id = l_org_id and enabled_flag ='Y';
2602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);
2603:
2604: if l_org_id_coll_method is not null and l_collection_method = 'DUN_STR' and l_org_id_coll_method <> 'STRATEGIES' then
2605: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' setup for ' || l_org_id_coll_method);
2606: fnd_file.put_line(FND_FILE.LOG, 'Not running Strategy Management for this ORG_ID' || l_org_id);

Line 2605: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' setup for ' || l_org_id_coll_method);

2601: -- select nvl(collections_method,'STRATEGIES') into l_org_id_coll_method from IEX_app_preferences_b where org_id = l_org_id and enabled_flag ='Y';
2602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);
2603:
2604: if l_org_id_coll_method is not null and l_collection_method = 'DUN_STR' and l_org_id_coll_method <> 'STRATEGIES' then
2605: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' setup for ' || l_org_id_coll_method);
2606: fnd_file.put_line(FND_FILE.LOG, 'Not running Strategy Management for this ORG_ID' || l_org_id);
2607: l_unPocessed_orgids := l_unPocessed_orgids + 1;
2608: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : ' || l_unPocessed_orgids);
2609:

Line 2606: fnd_file.put_line(FND_FILE.LOG, 'Not running Strategy Management for this ORG_ID' || l_org_id);

2602: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);
2603:
2604: if l_org_id_coll_method is not null and l_collection_method = 'DUN_STR' and l_org_id_coll_method <> 'STRATEGIES' then
2605: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' setup for ' || l_org_id_coll_method);
2606: fnd_file.put_line(FND_FILE.LOG, 'Not running Strategy Management for this ORG_ID' || l_org_id);
2607: l_unPocessed_orgids := l_unPocessed_orgids + 1;
2608: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : ' || l_unPocessed_orgids);
2609:
2610: else

Line 2608: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : ' || l_unPocessed_orgids);

2604: if l_org_id_coll_method is not null and l_collection_method = 'DUN_STR' and l_org_id_coll_method <> 'STRATEGIES' then
2605: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit is ' || l_org_id || ' setup for ' || l_org_id_coll_method);
2606: fnd_file.put_line(FND_FILE.LOG, 'Not running Strategy Management for this ORG_ID' || l_org_id);
2607: l_unPocessed_orgids := l_unPocessed_orgids + 1;
2608: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : ' || l_unPocessed_orgids);
2609:
2610: else
2611: -- End added by snuthala for bug 10221334 on 21-10-2010
2612:

Line 2617: fnd_file.put_line(FND_FILE.LOG, 'Strategy Level set for Operating Unit' || l_org_id || 'is' || l_system_strategy_level);

2613: open c_system_str_level(l_org_id);
2614: fetch c_system_str_level into l_system_strategy_level;
2615: close c_system_str_level;
2616:
2617: fnd_file.put_line(FND_FILE.LOG, 'Strategy Level set for Operating Unit' || l_org_id || 'is' || l_system_strategy_level);
2618:
2619: for l_str_levels in c_str_levels loop
2620:
2621: l_StrategyLevelName := l_str_levels.lookup_code;

Line 2667: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is off and Party Level override is on');

2663: open c_system_strategy_level;
2664: fetch c_system_strategy_level into l_system_strategy_level;
2665: close c_system_strategy_level;
2666:
2667: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is off and Party Level override is on');
2668: fnd_file.put_line(FND_FILE.LOG, 'System Strategy Level ' || l_system_strategy_level);
2669:
2670: for l_str_levels in c_str_levels loop
2671:

Line 2668: fnd_file.put_line(FND_FILE.LOG, 'System Strategy Level ' || l_system_strategy_level);

2664: fetch c_system_strategy_level into l_system_strategy_level;
2665: close c_system_strategy_level;
2666:
2667: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override is off and Party Level override is on');
2668: fnd_file.put_line(FND_FILE.LOG, 'System Strategy Level ' || l_system_strategy_level);
2669:
2670: for l_str_levels in c_str_levels loop
2671:
2672: l_StrategyLevelName := l_str_levels.lookup_code;

Line 2713: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override and Party Level override are off');

2709: end loop;
2710:
2711: else
2712:
2713: fnd_file.put_line(FND_FILE.LOG, 'Operating Unit Level override and Party Level override are off');
2714:
2715: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value
2716: into l_DefaultStrategyLevel,l_StrategyLevelName
2717: from iex_app_preferences_b

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

2760:
2761: END LOOP;
2762:
2763: else
2764: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is Off ');
2765: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2766: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2767:
2768: select count(1)

Line 2765: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );

2761: END LOOP;
2762:
2763: else
2764: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is Off ');
2765: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2766: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2767:
2768: select count(1)
2769: into l_count

Line 2766: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);

2762:
2763: else
2764: fnd_file.put_line(FND_FILE.LOG, 'Profile for processing strategies by operating unit is Off ');
2765: fnd_file.put_line(FND_FILE.LOG, ' Party Level Strategy Override value ' || l_party_override );
2766: fnd_file.put_line(FND_FILE.LOG, ' Operating Unit Level Strategy Override value ' || l_org_override);
2767:
2768: select count(1)
2769: into l_count
2770: from iex_strategies

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

2771: where org_id is not null
2772: and strategy_level=l_DefaultStrategyLevel;
2773:
2774: if l_count>0 then
2775: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies with org_id.');
2776: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
2777: return;
2778: end if;
2779: l_org_id := null;

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

2772: and strategy_level=l_DefaultStrategyLevel;
2773:
2774: if l_count>0 then
2775: fnd_file.put_line(FND_FILE.LOG, 'Found '||l_count||' strategies with org_id.');
2776: fnd_file.put_line(FND_FILE.LOG, 'Please run the script iexstorg.sql before running this concurrent program.');
2777: return;
2778: end if;
2779: l_org_id := null;
2780:

Line 2782: fnd_file.put_line(FND_FILE.LOG, ' Operating unit override is set. So enable profile for processing strategies by opearating');

2778: end if;
2779: l_org_id := null;
2780:
2781: if l_org_override = 'Y' then
2782: fnd_file.put_line(FND_FILE.LOG, ' Operating unit override is set. So enable profile for processing strategies by opearating');
2783: return;
2784: end if;
2785:
2786: if l_party_override ='Y' then

Line 2788: fnd_file.put_line(FND_FILE.LOG, 'Party Level override is on');

2784: end if;
2785:
2786: if l_party_override ='Y' then
2787:
2788: fnd_file.put_line(FND_FILE.LOG, 'Party Level override is on');
2789:
2790: open c_system_strategy_level;
2791: fetch c_system_strategy_level into l_system_strategy_level;
2792: close c_system_strategy_level;

Line 2836: fnd_file.put_line(FND_FILE.LOG, 'Party Level override is off');

2832: p_show_output => p_show_output);
2833:
2834: end loop;
2835: else
2836: fnd_file.put_line(FND_FILE.LOG, 'Party Level override is off');
2837:
2838: select decode(preference_value, 'CUSTOMER', 10, 'ACCOUNT', 20, 'BILL_TO', 30, 'DELINQUENCY', 40, 50),preference_value
2839: into l_DefaultStrategyLevel,l_StrategyLevelName
2840: from iex_app_preferences_b

Line 2885: fnd_file.put_line(FND_FILE.LOG, 'Iex Strategy Management concurrent program failed to run as the collections method is set up for dunning.');

2881:
2882:
2883: end if; -- org enabled
2884: else
2885: fnd_file.put_line(FND_FILE.LOG, 'Iex Strategy Management concurrent program failed to run as the collections method is set up for dunning.');
2886: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2887: message => 'Iex Strategy Management concurrent program failed to run as the collections method is set up for dunning.');
2888: end if; -- Added by snuthala for 10221334 12/2/2010
2889: -- end Naveen

Line 2906: fnd_file.put_line(FND_FILE.LOG, 'After gen_xml_append_closetag_sty ');

2902: p_unregistered_org_ids => l_unregistered_org_ids); -- added by snuthala for bug 10221334 on 21-10-2010
2903: END IF;
2904: -- End adding by gnramasa for bug 8833868 3-Sep-09
2905: -- Start added by snuthala for bug 10221334 on 21-10-2010
2906: fnd_file.put_line(FND_FILE.LOG, 'After gen_xml_append_closetag_sty ');
2907: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : '||l_unPocessed_orgids);
2908: fnd_file.put_line(FND_FILE.LOG, ' Number of Rows returned bu c_org cursor : '||l_c_org_count);
2909: if l_unPocessed_orgids > 0 and l_collection_method <> 'DUNNING' then
2910:

Line 2907: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : '||l_unPocessed_orgids);

2903: END IF;
2904: -- End adding by gnramasa for bug 8833868 3-Sep-09
2905: -- Start added by snuthala for bug 10221334 on 21-10-2010
2906: fnd_file.put_line(FND_FILE.LOG, 'After gen_xml_append_closetag_sty ');
2907: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : '||l_unPocessed_orgids);
2908: fnd_file.put_line(FND_FILE.LOG, ' Number of Rows returned bu c_org cursor : '||l_c_org_count);
2909: if l_unPocessed_orgids > 0 and l_collection_method <> 'DUNNING' then
2910:
2911: if l_c_org_count = l_unPocessed_orgids then

Line 2908: fnd_file.put_line(FND_FILE.LOG, ' Number of Rows returned bu c_org cursor : '||l_c_org_count);

2904: -- End adding by gnramasa for bug 8833868 3-Sep-09
2905: -- Start added by snuthala for bug 10221334 on 21-10-2010
2906: fnd_file.put_line(FND_FILE.LOG, 'After gen_xml_append_closetag_sty ');
2907: fnd_file.put_line(FND_FILE.LOG, ' l_unPocessed_orgids : '||l_unPocessed_orgids);
2908: fnd_file.put_line(FND_FILE.LOG, ' Number of Rows returned bu c_org cursor : '||l_c_org_count);
2909: if l_unPocessed_orgids > 0 and l_collection_method <> 'DUNNING' then
2910:
2911: if l_c_org_count = l_unPocessed_orgids then
2912: if p_org_id is not null then

Line 2913: fnd_file.put_line(FND_FILE.LOG, ' Opearting Unit passed is Not Setup for Startegy please check Setup');

2909: if l_unPocessed_orgids > 0 and l_collection_method <> 'DUNNING' then
2910:
2911: if l_c_org_count = l_unPocessed_orgids then
2912: if p_org_id is not null then
2913: fnd_file.put_line(FND_FILE.LOG, ' Opearting Unit passed is Not Setup for Startegy please check Setup');
2914: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2915: message => 'Opearting Unit passed is Not Setup for Startegy please check Setup');
2916: else
2917: fnd_file.put_line(FND_FILE.LOG, 'No Opearting Unit is Setup for Startegy please check Setup');

Line 2917: fnd_file.put_line(FND_FILE.LOG, 'No Opearting Unit is Setup for Startegy please check Setup');

2913: fnd_file.put_line(FND_FILE.LOG, ' Opearting Unit passed is Not Setup for Startegy please check Setup');
2914: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2915: message => 'Opearting Unit passed is Not Setup for Startegy please check Setup');
2916: else
2917: fnd_file.put_line(FND_FILE.LOG, 'No Opearting Unit is Setup for Startegy please check Setup');
2918: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2919: message => 'No Opearting Unit is Setup for Startegy please check Setup');
2920: end if;
2921: else

Line 2922: fnd_file.put_line(FND_FILE.LOG, 'At least one Opearting Unit is Setup for Dunning please check Setup');

2918: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2919: message => 'No Opearting Unit is Setup for Startegy please check Setup');
2920: end if;
2921: else
2922: fnd_file.put_line(FND_FILE.LOG, 'At least one Opearting Unit is Setup for Dunning please check Setup');
2923: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'WARNING',
2924: message => 'At least one Opearting Unit is Setup for Dunning please check Setup');
2925: end if;
2926: end if;

Line 2933: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

2929:
2930: EXCEPTION
2931:
2932: WHEN OTHERS THEN
2933: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
2934: writelog('In Main Procedure, err: '||sqlerrm);
2935: l_con_update_re_st := fnd_concurrent.set_completion_status (status => 'ERROR',
2936: message => 'Exception occured while running the Concurrent Program : '||sqlerrm); -- added by snuthala for bug 10221334 on 21-10-2010
2937:

Line 2972: fnd_file.put_line(FND_FILE.LOG, ' Found other level strategy exists for party ' || p_party_id || ' Strategy id is ' || l_str_id.strategy_id);

2968: end if;
2969:
2970: l_itemtype := 'IEXSTRY';
2971: l_itemkey := to_char(l_str_id.strategy_id);
2972: fnd_file.put_line(FND_FILE.LOG, ' Found other level strategy exists for party ' || p_party_id || ' Strategy id is ' || l_str_id.strategy_id);
2973:
2974: if p_str_level = 10 then
2975: l_party_id := p_party_id;
2976: elsif p_str_level = 20 then

Line 2999: fnd_file.put_line(FND_FILE.LOG, 'Strategy Cancelled. id = '|| l_str_id.strategy_id);

2995: process => l_itemtype,
2996: strategy_id => l_itemkey,
2997: status => l_StratStatusCancelled
2998: );
2999: fnd_file.put_line(FND_FILE.LOG, 'Strategy Cancelled. id = '|| l_str_id.strategy_id);
3000: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3001: write_log(FND_LOG.LEVEL_STATEMENT, 'Strategy Cancelled. id = ' || l_str_id.strategy_id);
3002: end if;
3003:

Line 3006: fnd_file.put_line(FND_FILE.LOG, 'Strategy Cancelled Raised Exception = '

3002: end if;
3003:
3004: EXCEPTION
3005: WHEN OTHERS THEN
3006: fnd_file.put_line(FND_FILE.LOG, 'Strategy Cancelled Raised Exception = '
3007: || l_str_id.strategy_id || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
3008: update iex_strategies set status_code='CANCELLED' where strategy_id = l_str_id.strategy_id;
3009: commit;
3010: END;

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

3029: l_schema := 'iex';
3030: l_dot := '.';
3031: l_module := 'strategy';
3032: if (mesg_level >= l_msgLevel) then
3033: fnd_file.put_line(FND_FILE.LOG, mesg);
3034: FND_LOG.STRING(mesg_level, l_schema || l_dot || l_module , mesg);
3035: end if;
3036: END;
3037: --Bug# 6870773 Naveen

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

3172: CLOSE c_strat_with_ou;
3173: END IF;
3174:
3175: end if;
3176: fnd_file.put_line(FND_FILE.LOG, 'Checking..');
3177: fnd_file.put_line(FND_FILE.LOG, 'Updating number of strategies ' || strategies.count);
3178: if strategies.count>0 then
3179:
3180: forall i in strategies.first..strategies.last

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

3173: END IF;
3174:
3175: end if;
3176: fnd_file.put_line(FND_FILE.LOG, 'Checking..');
3177: fnd_file.put_line(FND_FILE.LOG, 'Updating number of strategies ' || strategies.count);
3178: if strategies.count>0 then
3179:
3180: forall i in strategies.first..strategies.last
3181: update iex_strategies

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

3186:
3187: EXCEPTION
3188: WHEN OTHERS THEN
3189: write_log(FND_LOG.LEVEL_STATEMENT, 'In API update_strat_org raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
3190: fnd_file.put_line(FND_FILE.LOG, 'In API update_strat_org raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
3191: rollback;
3192:
3193: END;
3194:

Line 3221: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);

3217: BEGIN
3218: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3219: LOOP
3220: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
3221: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
3222: IF (NVL (l_end, 0) < 1) THEN
3223: EXIT;
3224: END IF;
3225: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );

Line 3226: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);

3222: IF (NVL (l_end, 0) < 1) THEN
3223: EXIT;
3224: END IF;
3225: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
3226: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
3227: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
3228: l_start := l_end + c_endline_len;
3229: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
3230: --FND_FILE.put_line( FND_FILE.LOG,'32');

Line 3227: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);

3223: EXIT;
3224: END IF;
3225: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
3226: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
3227: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
3228: l_start := l_end + c_endline_len;
3229: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
3230: --FND_FILE.put_line( FND_FILE.LOG,'32');
3231: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

Line 3229: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

3225: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
3226: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
3227: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
3228: l_start := l_end + c_endline_len;
3229: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
3230: --FND_FILE.put_line( FND_FILE.LOG,'32');
3231: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
3232: END LOOP;
3233: END PRINT_CLOB;

Line 3230: --FND_FILE.put_line( FND_FILE.LOG,'32');

3226: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
3227: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
3228: l_start := l_end + c_endline_len;
3229: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
3230: --FND_FILE.put_line( FND_FILE.LOG,'32');
3231: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
3232: END LOOP;
3233: END PRINT_CLOB;
3234:

Line 3231: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

3227: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
3228: l_start := l_end + c_endline_len;
3229: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
3230: --FND_FILE.put_line( FND_FILE.LOG,'32');
3231: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
3232: END LOOP;
3233: END PRINT_CLOB;
3234:
3235: /*========================================================================+

Line 3338: fnd_file.put_line(FND_FILE.LOG, 'In get_resource raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

3334: writelog('In get_resource raised Exception l_resource_name: ' || l_resource_name);
3335: EXCEPTION
3336: WHEN OTHERS THEN
3337: writelog('In get_resource raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
3338: fnd_file.put_line(FND_FILE.LOG, 'In get_resource raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
3339: end get_resource;
3340:
3341: Procedure gen_xml_header_data_strategy (p_strategy_mode IN VARCHAR2)
3342: is

Line 3406: FND_FILE.put_line( FND_FILE.LOG,'XML header data generation starts');

3402:
3403:
3404: begin
3405: writelog('Begin gen_xml_header_data_strategy');
3406: FND_FILE.put_line( FND_FILE.LOG,'XML header data generation starts');
3407:
3408: select to_char(sysdate, 'YYYY-MM-DD')
3409: into l_report_date
3410: from dual;

Line 3498: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML Header');

3494:
3495:
3496: l_grace_preiod := NVL(to_number(FND_PROFILE.VALUE('IEX_STRY_GRACE_PERIOD')), 0);
3497:
3498: FND_FILE.put_line( FND_FILE.LOG,'Start constructing the XML Header');
3499: l_new_line := '
3500: ';
3501: /*Get the special characters replaced */
3502: l_report_date := format_string(l_report_date);

Line 3548: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');

3544:
3545:
3546: l_xml_header_length := length(l_xml_header);
3547: tempResult := l_xml_header;
3548: FND_FILE.put_line( FND_FILE.LOG,'Constructing the XML Header is success');
3549:
3550: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
3551: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
3552: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

Line 3558: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

3554: writelog('End gen_xml_header_data_strategy');
3555:
3556: EXCEPTION
3557: WHEN OTHERS THEN
3558: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
3559: RAISE;
3560: END gen_xml_header_data_strategy;
3561:
3562: Procedure gen_xml_body_strategy (p_strategy_id IN NUMBER DEFAULT NULL,

Line 3891: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

3887: writelog('End gen_xml_body_strategy');
3888:
3889: EXCEPTION
3890: WHEN OTHERS THEN
3891: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
3892: writelog('in gen_xml_body_strategy, err: '||sqlerrm);
3893: RAISE;
3894: END gen_xml_body_strategy;
3895:

Line 3985: FND_FILE.put_line( FND_FILE.LOG,'XML append close tag generation starts');

3981:
3982:
3983: begin
3984: writelog('Begin gen_xml_append_closetag_sty');
3985: FND_FILE.put_line( FND_FILE.LOG,'XML append close tag generation starts');
3986: FND_FILE.put_line( FND_FILE.LOG,'p_org_id : '||p_org_id); -- added by snuthala for bug 10221334 on 21-10-2010
3987:
3988:
3989: if (p_customer_name_low IS NOT NULL OR p_customer_name_high IS NOT NULL OR p_account_number_low IS NOT NULL OR

Line 3986: FND_FILE.put_line( FND_FILE.LOG,'p_org_id : '||p_org_id); -- added by snuthala for bug 10221334 on 21-10-2010

3982:
3983: begin
3984: writelog('Begin gen_xml_append_closetag_sty');
3985: FND_FILE.put_line( FND_FILE.LOG,'XML append close tag generation starts');
3986: FND_FILE.put_line( FND_FILE.LOG,'p_org_id : '||p_org_id); -- added by snuthala for bug 10221334 on 21-10-2010
3987:
3988:
3989: if (p_customer_name_low IS NOT NULL OR p_customer_name_high IS NOT NULL OR p_account_number_low IS NOT NULL OR
3990: p_account_number_high IS NOT NULL OR p_billto_location_low IS NOT NULL OR p_billto_location_high IS NOT NULL) then

Line 4012: FND_FILE.put_line( FND_FILE.LOG,'gen_xml_append_closetag_sty: vPLSQL = ' || vPLSQL);

4008: if l_custom_select IS NOT NULL then
4009: vPLSQL := vPLSQL || ' and exists ( ' || l_custom_select || '= s.party_id) ';
4010: end if;
4011: writelog('gen_xml_append_closetag_sty: vPLSQL = ' || vPLSQL);
4012: FND_FILE.put_line( FND_FILE.LOG,'gen_xml_append_closetag_sty: vPLSQL = ' || vPLSQL);
4013:
4014: open c_mou_party for vPLSQL;
4015: loop
4016: fetch c_mou_party into l_party_id, l_party_name;

Line 4056: FND_FILE.put_line( FND_FILE.LOG,'gen_xml_append_closetag_sty: vPLSQL1 = ' || vPLSQL1);

4052: if l_custom_select IS NOT NULL then
4053: vPLSQL1 := vPLSQL1 || ' and exists ( ' || l_custom_select || '= cu_ac.cust_account_id) ';
4054: end if;
4055: writelog('gen_xml_append_closetag_sty: vPLSQL1 = ' || vPLSQL1);
4056: FND_FILE.put_line( FND_FILE.LOG,'gen_xml_append_closetag_sty: vPLSQL1 = ' || vPLSQL1);
4057:
4058: open c_mou_account for vPLSQL1;
4059: loop
4060: fetch c_mou_account into l_party_id, l_party_name, l_account_number, l_cust_account_id;

Line 4090: FND_FILE.put_line( FND_FILE.LOG,'gen_xml_append_closetag_sty: vPLSQL2 = ' || vPLSQL2);

4086: end if;
4087:
4088:
4089: writelog('gen_xml_append_closetag_sty: vPLSQL2 = ' || vPLSQL2);
4090: FND_FILE.put_line( FND_FILE.LOG,'gen_xml_append_closetag_sty: vPLSQL2 = ' || vPLSQL2);
4091:
4092: open c_org for vPLSQL2;
4093: loop
4094: fetch c_org into l_org_id, l_org_name ;

Line 4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collection_method);

4100: OPEN c_collections_method;
4101: FETCH c_collections_method INTO l_collection_method;
4102: close c_collections_method;
4103: -- select collections_methods into l_collection_method from iex_questionnaire_items;
4104: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods : '|| l_collection_method);
4105:
4106: OPEN C_ORG_ID_COLL_METHOD (l_org_id);
4107: FETCH C_ORG_ID_COLL_METHOD INTO l_org_id_coll_method;
4108: if l_collection_method = 'DUN_STR' and (C_ORG_ID_COLL_METHOD%NOTFOUND) THEN

Line 4121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);

4117: end if;
4118:
4119: close C_ORG_ID_COLL_METHOD;
4120:
4121: FND_FILE.PUT_LINE(FND_FILE.LOG, 'collections_methods set up for Org id : '|| l_org_id_coll_method);
4122:
4123: if l_org_id_coll_method is not null and l_collection_method = 'DUN_STR' and l_org_id_coll_method <> 'STRATEGIES' then
4124: l_mou_org_tag := l_new_line||'';
4125: l_mou_org_tag := l_mou_org_tag ||l_new_line||' ' || l_org_id || '';

Line 4159: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');

4155: l_close_tag := l_close_tag ||l_new_line||'' || p_unprocessed_orgid_count || ''; -- added by snuthala for bug 10221334 on 21-10-2010
4156: l_close_tag := l_close_tag ||l_new_line||''||l_new_line;
4157:
4158: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
4159: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
4160: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
4161: print_clob(lob_loc => tempResult);
4162: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
4163: writelog('End gen_xml_append_closetag_sty');

Line 4160: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);

4156: l_close_tag := l_close_tag ||l_new_line||''||l_new_line;
4157:
4158: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
4159: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
4160: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
4161: print_clob(lob_loc => tempResult);
4162: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
4163: writelog('End gen_xml_append_closetag_sty');
4164:

Line 4162: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');

4158: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
4159: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
4160: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
4161: print_clob(lob_loc => tempResult);
4162: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
4163: writelog('End gen_xml_append_closetag_sty');
4164:
4165: EXCEPTION
4166: WHEN OTHERS THEN

Line 4167: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

4163: writelog('End gen_xml_append_closetag_sty');
4164:
4165: EXCEPTION
4166: WHEN OTHERS THEN
4167: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
4168: RAISE;
4169: END gen_xml_append_closetag_sty;
4170: --End adding for bug 8761053 gnramasa 18th Aug 09
4171: --End adding for bug 8630852 by gnramasa 9-July-09

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

4212: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Default Template Name :' || l_DefaultTempName || ' , Enabled Flag :' || l_EnabledFlag );
4213: EXCEPTION
4214: WHEN OTHERS THEN
4215: l_DefaultTempName := 'N';
4216: fnd_file.put_line(FND_FILE.LOG, 'Default Template Name raised Exception ' || SQLCODE || ' ' || SQLERRM);
4217: END;
4218:
4219: begin
4220: l_default_rs_id := NVL(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'), 0);

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

4224: where RESOURCE_ID=l_default_rs_id;
4225: 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);
4226: EXCEPTION
4227: WHEN OTHERS THEN
4228: fnd_file.put_line(FND_FILE.LOG, 'Resource Name raised Exception ' || SQLCODE || ' ' || SQLERRM);
4229: END;
4230: -- Start for bug # 5877743 on 28/02/2007 by gnramasa
4231: begin
4232: --Begin Bug#7205287 31-Jul-2008 barathsr

Line 4238: fnd_file.put_line(FND_FILE.LOG, 'Work Item Assignment Collector level raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

4234: || NVL(fnd_profile.value('IEX_ACCESS_LEVEL'), 'PARTY'));
4235: --End Bug#7205287 31-Jul-2008 barathsr
4236: EXCEPTION
4237: WHEN OTHERS THEN
4238: fnd_file.put_line(FND_FILE.LOG, 'Work Item Assignment Collector level raised exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
4239: END;
4240: -- End for bug # 5877743 on 28/02/2007 by gnramasa
4241: -- Start for bug 8708271 multi level strategy
4242: /* begin

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

4248:
4249: -- End for bug # 5487449 on 28/08/2006 by gnramasa
4250: EXCEPTION
4251: WHEN OTHERS THEN
4252: fnd_file.put_line(FND_FILE.LOG, 'Strategy Level Rised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
4253: END; */
4254:
4255: begin
4256:

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

4261: write_log(FND_LOG.LEVEL_STATEMENT, 'Party Level Strategy Override and Operating Unit Level Override values ' || l_party_override || ' , ' || l_org_override);
4262:
4263: EXCEPTION
4264: WHEN OTHERS THEN
4265: fnd_file.put_line(FND_FILE.LOG, 'Strategy Level Rised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
4266: END;
4267: -- end for bug 8708271 multi level strategy
4268: END IEX_STRATEGY_CNT_PUB;