169:
170:
171: -- dbms_session.set_sql_trace(true);
172: -- Initialize API return status to SUCCESS
173: l_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175: /* Check the required profiles for Strategy Concurrent before starting */
176: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
177: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy creation aborted. ' );
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,
795: p_strategy_rec => l_strategy_rec,
796: x_return_status=>l_return_status,
797: x_msg_count=>l_msg_count,
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,
795: p_strategy_rec => l_strategy_rec,
796: x_return_status=>l_return_status,
797: x_msg_count=>l_msg_count,
798: x_msg_data=>l_msg_data,
827: -- bug 4141678 end - ctlee
828:
829: iex_strategy_wf_pub.start_workflow(
830: P_Api_Version =>2.0,
831: P_Init_Msg_List => FND_API.G_TRUE,
832: p_commit => FND_API.G_FALSE,
833: p_strategy_rec => l_strategy_rec,
834: x_return_status=>l_return_status,
835: x_msg_count=>l_msg_count,
828:
829: iex_strategy_wf_pub.start_workflow(
830: P_Api_Version =>2.0,
831: P_Init_Msg_List => FND_API.G_TRUE,
832: p_commit => FND_API.G_FALSE,
833: p_strategy_rec => l_strategy_rec,
834: x_return_status=>l_return_status,
835: x_msg_count=>l_msg_count,
836: x_msg_data=>l_msg_data
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;
855: -- bug 4141678 end - ctlee
856: END;
857: -- bug 4141678 begin - ctlee
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
899: END open_strategies;
900:
901: /* not used anywhere */
945: l_api_name := 'START_WORKFLOW';
946: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
947:
948: -- Initialize API return status to SUCCESS
949: l_return_status := FND_API.G_RET_STS_SUCCESS;
950: -- Standard Start of API savepoint
951: SAVEPOINT CLOSE_STRY_CONT;
952:
953: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor started ');
1035: -- initialize variables
1036: l_api_name := 'START_WORKFLOW';
1037:
1038: -- Initialize API return status to SUCCESS
1039: l_return_status := FND_API.G_RET_STS_SUCCESS;
1040:
1041: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1042: write_log(FND_LOG.LEVEL_STATEMENT,' Profile Name IEX: Strategy Disabled (IEX_STRATEGY_DISABLED) set to YES ');
1043: return;