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.FLM_EKANBAN_PUB dependencies on FND_API

Line 14: RAISE FND_API.G_EXC_ERROR;

10:
11: IF FND_PROFILE.Value('FLM_EKB_OPS_FLAG') <> 1 THEN
12: FND_MESSAGE.Set_Name('FLM', 'FLM_EKB_PROFILE_DISABLED');
13: FND_MSG_PUB.Add;
14: RAISE FND_API.G_EXC_ERROR;
15: END IF;
16:
17: END validate_ekanban_profile;
18:

Line 46: RAISE FND_API.G_EXC_ERROR;

42:
43: IF l_kanban_card_id IS NULL THEN
44: FND_MESSAGE.Set_Name('FLM', 'FLM_INV_CARD_ORG_COMB');
45: FND_MSG_PUB.Add;
46: RAISE FND_API.G_EXC_ERROR;
47: END IF;
48:
49: RETURN l_kanban_card_id;
50:

Line 78: IF NOT FND_API.Compatible_API_Call(l_api_version,

74:
75: SAVEPOINT Receive_PUB;
76:
77: -- Standard call to check for call compatibility
78: IF NOT FND_API.Compatible_API_Call(l_api_version,
79: p_api_version,
80: l_api_name,
81: G_PKG_NAME)
82: THEN

Line 83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

79: p_api_version,
80: l_api_name,
81: G_PKG_NAME)
82: THEN
83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE
87: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 87: IF FND_API.To_Boolean(p_init_msg_list) THEN

83: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
84: END IF;
85:
86: -- Initialize message list if p_init_msg_list is set to TRUE
87: IF FND_API.To_Boolean(p_init_msg_list) THEN
88: FND_MSG_PUB.Initialize;
89: END IF;
90:
91: validate_ekanban_profile;

Line 103: IF FND_API.To_Boolean(p_commit) THEN

99: x_ret_status => x_return_status,
100: x_err_msg => x_msg_data);
101:
102: -- Standard check of p_commit
103: IF FND_API.To_Boolean(p_commit) THEN
104: COMMIT;
105: END IF;
106:
107: EXCEPTION

Line 108: WHEN FND_API.G_EXC_ERROR THEN

104: COMMIT;
105: END IF;
106:
107: EXCEPTION
108: WHEN FND_API.G_EXC_ERROR THEN
109: ROLLBACK TO Receive_PUB;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111:
112: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 110: x_return_status := FND_API.G_RET_STS_ERROR;

106:
107: EXCEPTION
108: WHEN FND_API.G_EXC_ERROR THEN
109: ROLLBACK TO Receive_PUB;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111:
112: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
113: p_count => x_msg_count,
114: p_data => x_msg_data);

Line 112: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

108: WHEN FND_API.G_EXC_ERROR THEN
109: ROLLBACK TO Receive_PUB;
110: x_return_status := FND_API.G_RET_STS_ERROR;
111:
112: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
113: p_count => x_msg_count,
114: p_data => x_msg_data);
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

112: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
113: p_count => x_msg_count,
114: p_data => x_msg_data);
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: ROLLBACK TO Receive_PUB;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114: p_data => x_msg_data);
115:
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: ROLLBACK TO Receive_PUB;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
121: p_count => x_msg_count,
122: p_data => x_msg_data);

Line 120: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: ROLLBACK TO Receive_PUB;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119:
120: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
121: p_count => x_msg_count,
122: p_data => x_msg_data);
123:
124: WHEN OTHERS THEN

Line 126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

122: p_data => x_msg_data);
123:
124: WHEN OTHERS THEN
125: ROLLBACK TO Receive_PUB;
126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
127:
128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
129: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
130: p_procedure_name => l_api_name);

Line 133: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

129: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
130: p_procedure_name => l_api_name);
131: END IF;
132:
133: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
134: p_count => x_msg_count,
135: p_data => x_msg_data);
136:
137: END receive;

Line 163: IF NOT FND_API.Compatible_API_Call(l_api_version,

159:
160: SAVEPOINT Transfer_PUB;
161:
162: -- Standard call to check for call compatibility
163: IF NOT FND_API.Compatible_API_Call(l_api_version,
164: p_api_version,
165: l_api_name,
166: G_PKG_NAME)
167: THEN

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: p_api_version,
165: l_api_name,
166: G_PKG_NAME)
167: THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: -- Initialize message list if p_init_msg_list is set to TRUE
172: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 172: IF FND_API.To_Boolean(p_init_msg_list) THEN

168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171: -- Initialize message list if p_init_msg_list is set to TRUE
172: IF FND_API.To_Boolean(p_init_msg_list) THEN
173: FND_MSG_PUB.Initialize;
174: END IF;
175:
176: validate_ekanban_profile;

Line 187: IF FND_API.To_Boolean(p_commit) THEN

183: x_retcode => x_return_status,
184: x_errmsg => x_msg_data);
185:
186: -- Standard check of p_commit
187: IF FND_API.To_Boolean(p_commit) THEN
188: COMMIT;
189: END IF;
190:
191: EXCEPTION

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188: COMMIT;
189: END IF;
190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO Transfer_PUB;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195:
196: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 194: x_return_status := FND_API.G_RET_STS_ERROR;

190:
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO Transfer_PUB;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195:
196: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data);

Line 196: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO Transfer_PUB;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195:
196: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data);
199:
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

196: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
197: p_count => x_msg_count,
198: p_data => x_msg_data);
199:
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Transfer_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203:
204: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: p_data => x_msg_data);
199:
200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Transfer_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203:
204: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data);

Line 204: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
201: ROLLBACK TO Transfer_PUB;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203:
204: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
205: p_count => x_msg_count,
206: p_data => x_msg_data);
207:
208: WHEN OTHERS THEN

Line 210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

206: p_data => x_msg_data);
207:
208: WHEN OTHERS THEN
209: ROLLBACK TO Transfer_PUB;
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211:
212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
213: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
214: p_procedure_name => l_api_name);

Line 217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

213: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
214: p_procedure_name => l_api_name);
215: END IF;
216:
217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
218: p_count => x_msg_count,
219: p_data => x_msg_data);
220:
221: END transfer;

Line 244: IF NOT FND_API.Compatible_API_Call(l_api_version,

240:
241: SAVEPOINT Process_Pull_Sequence_PUB;
242:
243: -- Standard call to check for call compatibility
244: IF NOT FND_API.Compatible_API_Call(l_api_version,
245: p_api_version,
246: l_api_name,
247: G_PKG_NAME)
248: THEN

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: p_api_version,
246: l_api_name,
247: G_PKG_NAME)
248: THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: -- Initialize message list if p_init_msg_list is set to TRUE
253: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 253: IF FND_API.To_Boolean(p_init_msg_list) THEN

249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252: -- Initialize message list if p_init_msg_list is set to TRUE
253: IF FND_API.To_Boolean(p_init_msg_list) THEN
254: FND_MSG_PUB.Initialize;
255: END IF;
256:
257: validate_ekanban_profile;

Line 267: IF FND_API.To_Boolean(p_commit) THEN

263: x_ret_status => x_return_status,
264: x_error_msg => x_msg_data);
265:
266: -- Standard check of p_commit
267: IF FND_API.To_Boolean(p_commit) THEN
268: COMMIT;
269: END IF;
270:
271: EXCEPTION

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: COMMIT;
269: END IF;
270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO Process_Pull_Sequence_PUB;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 274: x_return_status := FND_API.G_RET_STS_ERROR;

270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO Process_Pull_Sequence_PUB;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data);

Line 276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO Process_Pull_Sequence_PUB;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data);
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data);
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO Process_Pull_Sequence_PUB;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: p_data => x_msg_data);
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO Process_Pull_Sequence_PUB;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data);

Line 284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO Process_Pull_Sequence_PUB;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283:
284: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
285: p_count => x_msg_count,
286: p_data => x_msg_data);
287:
288: WHEN OTHERS THEN

Line 290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

286: p_data => x_msg_data);
287:
288: WHEN OTHERS THEN
289: ROLLBACK TO Process_Pull_Sequence_PUB;
290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
291:
292: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
293: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
294: p_procedure_name => l_api_name);

Line 297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

293: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
294: p_procedure_name => l_api_name);
295: END IF;
296:
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
298: p_count => x_msg_count,
299: p_data => x_msg_data);
300:
301: END process_pull_sequence;

Line 323: IF NOT FND_API.Compatible_API_Call(l_api_version,

319:
320: SAVEPOINT Process_Cards_PUB;
321:
322: -- Standard call to check for call compatibility
323: IF NOT FND_API.Compatible_API_Call(l_api_version,
324: p_api_version,
325: l_api_name,
326: G_PKG_NAME)
327: THEN

Line 328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

324: p_api_version,
325: l_api_name,
326: G_PKG_NAME)
327: THEN
328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: -- Initialize message list if p_init_msg_list is set to TRUE
332: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 332: IF FND_API.To_Boolean(p_init_msg_list) THEN

328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
329: END IF;
330:
331: -- Initialize message list if p_init_msg_list is set to TRUE
332: IF FND_API.To_Boolean(p_init_msg_list) THEN
333: FND_MSG_PUB.Initialize;
334: END IF;
335:
336: validate_ekanban_profile;

Line 345: IF FND_API.To_Boolean(p_commit) THEN

341: x_ret_status => x_return_status,
342: x_err_msg => x_msg_data);
343:
344: -- Standard check of p_commit
345: IF FND_API.To_Boolean(p_commit) THEN
346: COMMIT;
347: END IF;
348:
349: EXCEPTION

Line 350: WHEN FND_API.G_EXC_ERROR THEN

346: COMMIT;
347: END IF;
348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: ROLLBACK TO Process_Cards_PUB;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353:
354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 352: x_return_status := FND_API.G_RET_STS_ERROR;

348:
349: EXCEPTION
350: WHEN FND_API.G_EXC_ERROR THEN
351: ROLLBACK TO Process_Cards_PUB;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353:
354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
355: p_count => x_msg_count,
356: p_data => x_msg_data);

Line 354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

350: WHEN FND_API.G_EXC_ERROR THEN
351: ROLLBACK TO Process_Cards_PUB;
352: x_return_status := FND_API.G_RET_STS_ERROR;
353:
354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
355: p_count => x_msg_count,
356: p_data => x_msg_data);
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
355: p_count => x_msg_count,
356: p_data => x_msg_data);
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO Process_Cards_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: p_data => x_msg_data);
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO Process_Cards_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);

Line 362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO Process_Cards_PUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data);
365:
366: WHEN OTHERS THEN

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

364: p_data => x_msg_data);
365:
366: WHEN OTHERS THEN
367: ROLLBACK TO Process_Cards_PUB;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369:
370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
371: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
372: p_procedure_name => l_api_name);

Line 375: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

371: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
372: p_procedure_name => l_api_name);
373: END IF;
374:
375: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
376: p_count => x_msg_count,
377: p_data => x_msg_data);
378:
379: END process_cards;

Line 406: IF NOT FND_API.Compatible_API_Call(l_api_version,

402:
403: SAVEPOINT Update_Card_Status_PUB;
404:
405: -- Standard call to check for call compatibility
406: IF NOT FND_API.Compatible_API_Call(l_api_version,
407: p_api_version,
408: l_api_name,
409: G_PKG_NAME)
410: THEN

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407: p_api_version,
408: l_api_name,
409: G_PKG_NAME)
410: THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: -- Initialize message list if p_init_msg_list is set to TRUE
415: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 415: IF FND_API.To_Boolean(p_init_msg_list) THEN

411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: -- Initialize message list if p_init_msg_list is set to TRUE
415: IF FND_API.To_Boolean(p_init_msg_list) THEN
416: FND_MSG_PUB.Initialize;
417: END IF;
418:
419: validate_ekanban_profile;

Line 432: IF FND_API.To_Boolean(p_commit) THEN

428: x_ret_msg_code => l_ret_msg_code,
429: x_err_msg => x_msg_data);
430:
431: -- Standard check of p_commit
432: IF FND_API.To_Boolean(p_commit) THEN
433: COMMIT;
434: END IF;
435:
436: EXCEPTION

Line 437: WHEN FND_API.G_EXC_ERROR THEN

433: COMMIT;
434: END IF;
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO Update_Card_Status_PUB;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO Update_Card_Status_PUB;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data);

Line 441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO Update_Card_Status_PUB;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

441: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO Update_Card_Status_PUB;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO Update_Card_Status_PUB;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data);

Line 449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO Update_Card_Status_PUB;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448:
449: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data);
452:
453: WHEN OTHERS THEN

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451: p_data => x_msg_data);
452:
453: WHEN OTHERS THEN
454: ROLLBACK TO Update_Card_Status_PUB;
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:
457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
458: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
459: p_procedure_name => l_api_name);

Line 462: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

458: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
459: p_procedure_name => l_api_name);
460: END IF;
461:
462: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
463: p_count => x_msg_count,
464: p_data => x_msg_data);
465:
466: END update_card_status;