APPS.IEX_STRATEGY_WF_PUB dependencies on FND_API

Line 15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

11:
12: PROCEDURE start_workflow
13: (
14: p_api_version IN NUMBER := 2.0,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_strategy_rec IN IEX_STRATEGY_PVT.STRATEGY_REC_TYPE,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,

Line 16: p_commit IN VARCHAR2 := FND_API.G_FALSE,

12: PROCEDURE start_workflow
13: (
14: p_api_version IN NUMBER := 2.0,
15: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16: p_commit IN VARCHAR2 := FND_API.G_FALSE,
17: p_strategy_rec IN IEX_STRATEGY_PVT.STRATEGY_REC_TYPE,
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,

Line 44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

40: -- Standard Start of API savepoint
41: SAVEPOINT START_WORKFLOW;
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version,
46: l_api_name,
47: G_PKG_NAME) THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version,
46: l_api_name,
47: G_PKG_NAME) THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49:
50: END IF;
51: if (bConcProg = 'YES') then
52: -- Debug Message

Line 58: IF FND_API.to_Boolean( p_init_msg_list ) THEN

54: write_log(FND_LOG.LEVEL_STATEMENT, 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
55: else
56:
57: -- Initialize message list IF p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: -- Debug Message

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: IEX_DEBUG_PUB.LogMessage( 'API: IEX_STRATEGY_WF_PUB.' || l_api_name || ' start');
64: end if;
65:
66: -- Initialize API return status to SUCCESS
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: itemtype := 'IEXSTRY';
70: workflowprocess := 'STRATEGY_WORKFLOW';
71:

Line 127: raise fnd_api.g_exc_unexpected_error;

123: else
124: x_return_status := 'F';
125: fnd_file.put_line(FND_FILE.LOG, 'Failed Workflow: STATUS = ' || l_return_status || ' l_result= ' || l_result);
126: fnd_file.put_line(FND_FILE.LOG, 'Database Error if any ' || 'sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
127: raise fnd_api.g_exc_unexpected_error;
128: end if;
129:
130: if (bConcProg = 'YES') then
131: write_log(FND_LOG.LEVEL_STATEMENT, 'GET ITEM STATUS = ' || l_return_status);

Line 146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

142:
143: end if;
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: if (bConcProg = 'YES') then
148: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
149: fnd_file.put_line(FND_FILE.LOG, 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
150: fnd_file.put_line(FND_FILE.LOG, 'PUB: ' || l_api_name || ' end');

Line 157: raise FND_API.G_EXC_UNEXPECTED_ERROR;

153: IEX_DEBUG_PUB.LogMessage( 'UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
154: IEX_DEBUG_PUB.LogMessage( 'PUB: ' || l_api_name || ' end');
155: IEX_DEBUG_PUB.LogMessage( 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
156: end if;
157: raise FND_API.G_EXC_UNEXPECTED_ERROR;
158:
159: WHEN OTHERS THEN
160: if (bConcProg = 'YES') then
161: fnd_file.put_line(FND_FILE.LOG, 'UNHANDLED WORKFLOW EXCEPTION ERROR: ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

Line 170: raise FND_API.G_EXC_UNEXPECTED_ERROR;

166: IEX_DEBUG_PUB.LogMessage( 'UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_rec.strategy_id);
167: IEX_DEBUG_PUB.LogMessage( 'PUB: ' || l_api_name || ' end');
168: IEX_DEBUG_PUB.LogMessage( 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
169: end if;
170: raise FND_API.G_EXC_UNEXPECTED_ERROR;
171:
172: END start_workflow;
173:
174: PROCEDURE write_log(mesg_level IN NUMBER, mesg IN VARCHAR2) is