332:
333:
334: -- dbms_session.set_sql_trace(true);
335: -- Initialize API return status to SUCCESS
336: l_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: /* Check the required profiles for Strategy Concurrent before starting */
339: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
340: write_log(FND_LOG.LEVEL_UNEXPECTED, 'Strategy creation aborted. ' );
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,
1273: p_strategy_rec => l_strategy_rec,
1274: x_return_status=>l_return_status,
1275: x_msg_count=>l_msg_count,
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,
1273: p_strategy_rec => l_strategy_rec,
1274: x_return_status=>l_return_status,
1275: x_msg_count=>l_msg_count,
1276: x_msg_data=>l_msg_data,
1305: -- bug 4141678 end - ctlee
1306:
1307: iex_strategy_wf_pub.start_workflow(
1308: P_Api_Version =>2.0,
1309: P_Init_Msg_List => FND_API.G_TRUE,
1310: p_commit => FND_API.G_FALSE,
1311: p_strategy_rec => l_strategy_rec,
1312: x_return_status=>l_return_status,
1313: x_msg_count=>l_msg_count,
1306:
1307: iex_strategy_wf_pub.start_workflow(
1308: P_Api_Version =>2.0,
1309: P_Init_Msg_List => FND_API.G_TRUE,
1310: p_commit => FND_API.G_FALSE,
1311: p_strategy_rec => l_strategy_rec,
1312: x_return_status=>l_return_status,
1313: x_msg_count=>l_msg_count,
1314: x_msg_data=>l_msg_data
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;
1333: -- bug 4141678 end - ctlee
1334: END;
1335: end if; --if p_strategy_mode = 'FINAL' then
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
1396: END open_strategies;
1397:
1398: /* not used anywhere */
1442: l_api_name := 'START_WORKFLOW';
1443: l_stry_cnt_rec := IEX_STRATEGY_TYPE_PUB.INST_STRY_CNT_REC;
1444:
1445: -- Initialize API return status to SUCCESS
1446: l_return_status := FND_API.G_RET_STS_SUCCESS;
1447: -- Standard Start of API savepoint
1448: SAVEPOINT CLOSE_STRY_CONT;
1449:
1450: write_log(FND_LOG.LEVEL_STATEMENT, 'Close Strategy cursor started ');
1537: -- initialize variables
1538: l_api_name := 'START_WORKFLOW';
1539:
1540: -- Initialize API return status to SUCCESS
1541: l_return_status := FND_API.G_RET_STS_SUCCESS;
1542:
1543: if (NVL(FND_PROFILE.VALUE('IEX_STRATEGY_DISABLED'), 'N') = 'Y') then
1544: write_log(FND_LOG.LEVEL_STATEMENT,' Profile Name IEX: Strategy Disabled (IEX_STRATEGY_DISABLED) set to YES ');
1545: return;