DBA Data[Home] [Help]

APPS.FLM_EKANBAN_PUB dependencies on FND_MSG_PUB

Line 13: FND_MSG_PUB.Add;

9: BEGIN
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;

Line 45: FND_MSG_PUB.Add;

41: CLOSE c_kanbard_card_id;
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;

Line 88: FND_MSG_PUB.Initialize;

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;
92:

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 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 128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
131: END IF;
132:

Line 129: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,

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);
131: END IF;
132:
133: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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 173: FND_MSG_PUB.Initialize;

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;
177:

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 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 212: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
215: END IF;
216:

Line 213: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,

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);
215: END IF;
216:
217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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 254: FND_MSG_PUB.Initialize;

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;
258:

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 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 292: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
295: END IF;
296:

Line 293: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,

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);
295: END IF;
296:
297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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 333: FND_MSG_PUB.Initialize;

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;
337:

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 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 370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
373: END IF;
374:

Line 371: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,

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);
373: END IF;
374:
375: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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 416: FND_MSG_PUB.Initialize;

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;
420:

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 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 457: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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);
460: END IF;
461:

Line 458: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,

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);
460: END IF;
461:
462: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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;