DBA Data[Home] [Help]

APPS.IEX_STRATEGY_CNT_PUB dependencies on FND_API

Line 173: l_return_status := FND_API.G_RET_STS_SUCCESS;

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. ' );

Line 793: p_commit => FND_API.G_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,
795: p_strategy_rec => l_strategy_rec,
796: x_return_status=>l_return_status,
797: x_msg_count=>l_msg_count,

Line 794: P_Init_Msg_List =>FND_API.G_TRUE,

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,

Line 831: P_Init_Msg_List => FND_API.G_TRUE,

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,

Line 832: p_commit => FND_API.G_FALSE,

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

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 */

Line 949: l_return_status := FND_API.G_RET_STS_SUCCESS;

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 ');

Line 1039: l_return_status := FND_API.G_RET_STS_SUCCESS;

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;