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_STRY_CHECKLIST_PUB dependencies on FND_API

Line 17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

13:
14: PROCEDURE create_checklist_strategy
15: (
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: X_Return_Status OUT NOCOPY VARCHAR2,
21: X_Msg_Count OUT NOCOPY NUMBER,

Line 18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

14: PROCEDURE create_checklist_strategy
15: (
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: X_Return_Status OUT NOCOPY VARCHAR2,
21: X_Msg_Count OUT NOCOPY NUMBER,
22: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

15: (
16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20: X_Return_Status OUT NOCOPY VARCHAR2,
21: X_Msg_Count OUT NOCOPY NUMBER,
22: X_Msg_Data OUT NOCOPY VARCHAR2,
23: p_StrategyID IN NUMBER

Line 71: l_return_status := FND_API.G_RET_STS_SUCCESS;

67: -- Standard Start of API savepoint
68: SAVEPOINT create_checklist_strategy;
69:
70: -- Initialize API return status to SUCCESS
71: l_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- Initialize message list IF p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;

Line 74: IF FND_API.to_Boolean( p_init_msg_list ) THEN

70: -- Initialize API return status to SUCCESS
71: l_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: -- Initialize message list IF p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: print_date => 'Y');
95: END IF;
96:
97: -- Initialize API return status to SUCCESS
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: BEGIN
101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
102: iex_debug_pub.logmessage( debug_msg => '15. S.ID= ' || p_StrategyID, print_date => 'Y');

Line 123: RAISE FND_API.G_EXC_ERROR;

119:
120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
121: iex_debug_pub.logmessage( debug_msg => '17. IEX_STRATEGY_NOT_EXISTS', print_date => 'Y');
122: END IF;
123: RAISE FND_API.G_EXC_ERROR;
124: return;
125: When OTHERS then
126: x_return_status := 'F';
127: AS_UTILITY_PVT.Set_Message(

Line 135: RAISE FND_API.G_EXC_ERROR;

131: p_token1_value => to_char(p_StrategyID));
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: iex_debug_pub.logmessage( debug_msg => '18. ERROR: IEX_OTHERS_SQL ', print_date => 'Y');
134: END IF;
135: RAISE FND_API.G_EXC_ERROR;
136: return;
137:
138: END;
139:

Line 156: RAISE FND_API.G_EXC_ERROR;

152: p_token1_value => to_char(p_StrategyID));
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: iex_debug_pub.logmessage( debug_msg => '20. CheckListTemplate Not exists ', print_date => 'Y');
155: END IF;
156: RAISE FND_API.G_EXC_ERROR;
157: return;
158: end if;
159:
160: BEGIN

Line 187: p_commit => FND_API.G_FALSE,

183: IEX_DEBUG_PUB.LogMessage('2. Create Checklist strategy ');
184:
185: iex_strategy_pvt.create_strategy(
186: P_Api_Version_Number=>2.0,
187: p_commit => FND_API.G_FALSE,
188: P_Init_Msg_List =>FND_API.G_FALSE,
189: p_strategy_rec => l_strategy_rec,
190: x_return_status=>l_return_status,
191: x_msg_count=>l_msg_count,

Line 188: P_Init_Msg_List =>FND_API.G_FALSE,

184:
185: iex_strategy_pvt.create_strategy(
186: P_Api_Version_Number=>2.0,
187: p_commit => FND_API.G_FALSE,
188: P_Init_Msg_List =>FND_API.G_FALSE,
189: p_strategy_rec => l_strategy_rec,
190: x_return_status=>l_return_status,
191: x_msg_count=>l_msg_count,
192: x_msg_data=>l_msg_data,

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
198: END IF;
199: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
200: if (x_return_status <> 'S') then
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: end if;
203:
204: l_strategy_rec.strategy_id := l_strategy_id;
205:

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
218: p_msg_name => 'IEX_STRATEGY_CREATE_FAILED',
219: p_token1 => 'OBJECT_ID ',
220: p_token1_value => to_char(fObjectID));
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END;
223:
224:
225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 257: P_Init_Msg_List =>FND_API.G_TRUE,

253: END IF;
254:
255: iex_strategy_work_items_pvt.create_strategy_work_items
256: (P_Api_Version_Number =>2.0,
257: P_Init_Msg_List =>FND_API.G_TRUE,
258: P_Commit =>FND_API.G_FALSE,
259: p_validation_level =>FND_API.G_VALID_LEVEL_NONE,
260: p_strategy_work_item_rec =>l_strategy_work_item_rec,
261: x_work_item_id =>x_work_item_id,

Line 258: P_Commit =>FND_API.G_FALSE,

254:
255: iex_strategy_work_items_pvt.create_strategy_work_items
256: (P_Api_Version_Number =>2.0,
257: P_Init_Msg_List =>FND_API.G_TRUE,
258: P_Commit =>FND_API.G_FALSE,
259: p_validation_level =>FND_API.G_VALID_LEVEL_NONE,
260: p_strategy_work_item_rec =>l_strategy_work_item_rec,
261: x_work_item_id =>x_work_item_id,
262: x_return_status =>l_return_status,

Line 259: p_validation_level =>FND_API.G_VALID_LEVEL_NONE,

255: iex_strategy_work_items_pvt.create_strategy_work_items
256: (P_Api_Version_Number =>2.0,
257: P_Init_Msg_List =>FND_API.G_TRUE,
258: P_Commit =>FND_API.G_FALSE,
259: p_validation_level =>FND_API.G_VALID_LEVEL_NONE,
260: p_strategy_work_item_rec =>l_strategy_work_item_rec,
261: x_work_item_id =>x_work_item_id,
262: x_return_status =>l_return_status,
263: x_msg_count =>l_msg_count,

Line 275: RAISE FND_API.G_EXC_ERROR;

271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: iex_debug_pub.logmessage ('create_checklist_strategy: ' || 'and l_return_status from the pvt ='||l_return_status);
273: END IF;
274: if (x_return_status <> 'S') then
275: RAISE FND_API.G_EXC_ERROR;
276: end if;
277:
278: END LOOP;
279:

Line 295: p_commit => FND_API.G_FALSE,

291: IEX_DEBUG_PUB.LogMessage('2. Update Main Strategy ');
292:
293: iex_strategy_pvt.update_strategy(
294: P_Api_Version_Number=>2.0,
295: p_commit => FND_API.G_FALSE,
296: P_Init_Msg_List =>FND_API.G_FALSE,
297: p_strategy_rec => l_strategy2_rec,
298: x_return_status=>l_return_status,
299: x_msg_count=>l_msg_count,

Line 296: P_Init_Msg_List =>FND_API.G_FALSE,

292:
293: iex_strategy_pvt.update_strategy(
294: P_Api_Version_Number=>2.0,
295: p_commit => FND_API.G_FALSE,
296: P_Init_Msg_List =>FND_API.G_FALSE,
297: p_strategy_rec => l_strategy2_rec,
298: x_return_status=>l_return_status,
299: x_msg_count=>l_msg_count,
300: x_msg_data=>l_msg_data,

Line 308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

304: iex_debug_pub.logmessage( debug_msg => 'Return status = ' || l_return_status, print_date => 'Y');
305: END IF;
306: IEX_DEBUG_PUB.LogMessage('Return status = ' || l_return_status);
307: if (x_return_status <> 'S') then
308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: end if;
310:
311: -- Standard check for p_commit
312: IF FND_API.to_Boolean(p_commit) THEN

Line 312: IF FND_API.to_Boolean(p_commit) THEN

308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
309: end if;
310:
311: -- Standard check for p_commit
312: IF FND_API.to_Boolean(p_commit) THEN
313: COMMIT WORK;
314: END IF;
315:
316: -- Standard call to get message count and if count is 1, get message info.

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323:
324:
325: EXCEPTION
326:
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324:
325: EXCEPTION
326:
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
334:
335: WHEN OTHERS THEN

Line 332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

328: x_return_status := FND_API.G_RET_STS_ERROR;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330:
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
334:
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
334:
335: WHEN OTHERS THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
338: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
339: END IF;
340: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);