DBA Data[Home] [Help]

APPS.JTF_EC_PUB dependencies on FND_MSG_PUB

Line 189: fnd_msg_pub.count_and_get (

185: WHEN fnd_api.g_exc_error
186: THEN
187: ROLLBACK TO Create_Esc_Note;
188: x_return_status := fnd_api.g_ret_sts_error;
189: fnd_msg_pub.count_and_get (
190: p_count => x_msg_count,
191: p_data => x_msg_data
192: );
193:

Line 199: fnd_msg_pub.count_and_get (

195: THEN
196:
197: ROLLBACK TO Create_Esc_Note;
198: x_return_status := fnd_api.g_ret_sts_unexp_error;
199: fnd_msg_pub.count_and_get (
200: p_count => x_msg_count,
201: p_data => x_msg_data
202: );
203:

Line 209: if FND_MSG_PUB.Check_Msg_Level

205: THEN
206: ROLLBACK TO Create_Esc_Note;
207: x_return_status := fnd_api.g_ret_sts_unexp_error;
208:
209: if FND_MSG_PUB.Check_Msg_Level
210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
211: then
212: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
213: end if;

Line 210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

206: ROLLBACK TO Create_Esc_Note;
207: x_return_status := fnd_api.g_ret_sts_unexp_error;
208:
209: if FND_MSG_PUB.Check_Msg_Level
210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
211: then
212: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
213: end if;
214:

Line 212: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

208:
209: if FND_MSG_PUB.Check_Msg_Level
210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
211: then
212: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
213: end if;
214:
215: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
216: p_data => x_msg_data);

Line 215: fnd_msg_pub.count_and_get ( p_count => x_msg_count,

211: then
212: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
213: end if;
214:
215: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
216: p_data => x_msg_data);
217:
218: END Create_Esc_Note;
219:

Line 330: fnd_msg_pub.add;

326:
327: fnd_message.set_name('JTF', 'JTF_API_ALL_DUPLICATE_VALUE');
328: fnd_message.set_token('API_NAME', l_api_name);
329: fnd_message.set_token('DUPLICATE_VAL_PARAM', 'Contact ID: ' || to_char(l_esc_contacts.contact_id));
330: fnd_msg_pub.add;
331: raise fnd_api.g_exc_error;
332:
333: end if;
334:

Line 341: fnd_msg_pub.count_and_get (

337: WHEN fnd_api.g_exc_error
338: THEN
339: ROLLBACK TO Create_Esc_Contacts;
340: x_return_status := fnd_api.g_ret_sts_error;
341: fnd_msg_pub.count_and_get (
342: p_count => x_msg_count,
343: p_data => x_msg_data
344: );
345:

Line 351: fnd_msg_pub.count_and_get (

347: THEN
348:
349: ROLLBACK TO Create_Esc_Contacts;
350: x_return_status := fnd_api.g_ret_sts_unexp_error;
351: fnd_msg_pub.count_and_get (
352: p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355:

Line 360: if FND_MSG_PUB.Check_Msg_Level

356: WHEN OTHERS
357: THEN
358: ROLLBACK TO Create_Esc_Contacts;
359: x_return_status := fnd_api.g_ret_sts_unexp_error;
360: if FND_MSG_PUB.Check_Msg_Level
361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: then
363: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
364: end if;

Line 361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

357: THEN
358: ROLLBACK TO Create_Esc_Contacts;
359: x_return_status := fnd_api.g_ret_sts_unexp_error;
360: if FND_MSG_PUB.Check_Msg_Level
361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: then
363: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
364: end if;
365:

Line 363: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

359: x_return_status := fnd_api.g_ret_sts_unexp_error;
360: if FND_MSG_PUB.Check_Msg_Level
361: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: then
363: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
364: end if;
365:
366: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
367:

Line 366: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);

362: then
363: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
364: end if;
365:
366: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
367:
368: END Create_Esc_Contacts;
369:
370: -------------------------------------------------------------------------------------------------------

Line 450: fnd_msg_pub.Add;

446:
447: fnd_message.set_name ('JTF', 'JTF_TK_ESC_DOC_EXIST');
448: fnd_message.set_token('OBJECT_TYPE',l_reference_documents.object_type_code);
449: fnd_message.set_token('OBJECT_NUMBER',l_reference_documents.object_name);
450: fnd_msg_pub.Add;
451: raise fnd_api.g_exc_error;
452: end if;
453: end if;
454:

Line 511: fnd_msg_pub.count_and_get (

507: WHEN fnd_api.g_exc_error
508: THEN
509: ROLLBACK TO Create_Esc_Reference;
510: x_return_status := fnd_api.g_ret_sts_error;
511: fnd_msg_pub.count_and_get (
512: p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515:

Line 521: fnd_msg_pub.count_and_get ( p_count => x_msg_count,

517: THEN
518:
519: ROLLBACK TO Create_Esc_Reference;
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
522: p_data => x_msg_data);
523:
524: WHEN OTHERS
525: THEN

Line 529: if FND_MSG_PUB.Check_Msg_Level

525: THEN
526: ROLLBACK TO Create_Esc_Reference;
527: x_return_status := fnd_api.g_ret_sts_unexp_error;
528:
529: if FND_MSG_PUB.Check_Msg_Level
530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: then
532: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
533: end if;

Line 530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

526: ROLLBACK TO Create_Esc_Reference;
527: x_return_status := fnd_api.g_ret_sts_unexp_error;
528:
529: if FND_MSG_PUB.Check_Msg_Level
530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: then
532: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
533: end if;
534:

Line 532: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

528:
529: if FND_MSG_PUB.Check_Msg_Level
530: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
531: then
532: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
533: end if;
534:
535: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
536: p_data => x_msg_data);

Line 535: fnd_msg_pub.count_and_get ( p_count => x_msg_count,

531: then
532: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
533: end if;
534:
535: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
536: p_data => x_msg_data);
537: END Create_Esc_Reference;
538:
539: PROCEDURE CREATE_ESCALATION (

Line 616: FND_MSG_PUB.initialize;

612:
613: -- Check p_init_msg_list
614:
615: IF FND_API.To_Boolean( p_init_msg_list ) THEN
616: FND_MSG_PUB.initialize;
617: END IF;
618:
619: -- Initialize API return status to success
620:

Line 1156: fnd_msg_pub.count_and_get

1152: IF FND_API.To_Boolean( p_commit ) THEN
1153: COMMIT WORK;
1154: END IF;
1155:
1156: fnd_msg_pub.count_and_get
1157: ( p_count => x_msg_count,
1158: p_data => x_msg_data
1159: );
1160:

Line 1168: fnd_msg_pub.count_and_get (

1164: THEN
1165: ROLLBACK TO Create_Escalation;
1166: x_return_status := fnd_api.g_ret_sts_error;
1167:
1168: fnd_msg_pub.count_and_get (
1169: p_count => x_msg_count,
1170: p_data => x_msg_data
1171: );
1172:

Line 1178: fnd_msg_pub.count_and_get ( p_count => x_msg_count,

1174: THEN
1175:
1176: ROLLBACK TO Create_Escalation;
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:
1181: WHEN OTHERS
1182: THEN

Line 1186: if FND_MSG_PUB.Check_Msg_Level

1182: THEN
1183: ROLLBACK TO Create_Escalation;
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185:
1186: if FND_MSG_PUB.Check_Msg_Level
1187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1188: then
1189: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1190: end if;

Line 1187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1183: ROLLBACK TO Create_Escalation;
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185:
1186: if FND_MSG_PUB.Check_Msg_Level
1187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1188: then
1189: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1190: end if;
1191:

Line 1189: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

1185:
1186: if FND_MSG_PUB.Check_Msg_Level
1187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1188: then
1189: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1190: end if;
1191:
1192: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
1193: p_data => x_msg_data);

Line 1192: fnd_msg_pub.count_and_get ( p_count => x_msg_count,

1188: then
1189: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1190: end if;
1191:
1192: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
1193: p_data => x_msg_data);
1194: END CREATE_ESCALATION;
1195:
1196: PROCEDURE UPDATE_ESCALATION (

Line 1288: FND_MSG_PUB.initialize;

1284:
1285: -- Check p_init_msg_list
1286:
1287: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1288: FND_MSG_PUB.initialize;
1289: END IF;
1290:
1291: -- Initialize API return status to success
1292:

Line 1675: fnd_msg_pub.Add;

1671: if l_task_ref_id <> l_reference_documents(j).reference_id then
1672: fnd_message.set_name ('JTF', 'JTF_TK_ESC_DOC_EXIST');
1673: fnd_message.set_token('OBJECT_TYPE',l_object_type_code);
1674: fnd_message.set_token('OBJECT_NUMBER',l_object_name);
1675: fnd_msg_pub.Add;
1676: raise fnd_api.g_exc_error;
1677: end if;
1678: end if;
1679:

Line 2308: fnd_msg_pub.count_and_get

2304: IF FND_API.To_Boolean( p_commit ) THEN
2305: COMMIT WORK;
2306: END IF;
2307:
2308: fnd_msg_pub.count_and_get
2309: ( p_count => x_msg_count,
2310: p_data => x_msg_data
2311: );
2312:

Line 2319: fnd_msg_pub.count_and_get (

2315: WHEN fnd_api.g_exc_error
2316: THEN
2317: ROLLBACK TO Update_Escalation;
2318: x_return_status := fnd_api.g_ret_sts_error;
2319: fnd_msg_pub.count_and_get (
2320: p_count => x_msg_count,
2321: p_data => x_msg_data
2322: );
2323:

Line 2329: fnd_msg_pub.count_and_get (

2325: THEN
2326:
2327: ROLLBACK TO Update_Escalation;
2328: x_return_status := fnd_api.g_ret_sts_unexp_error;
2329: fnd_msg_pub.count_and_get (
2330: p_count => x_msg_count,
2331: p_data => x_msg_data
2332: );
2333:

Line 2338: if FND_MSG_PUB.Check_Msg_Level

2334: WHEN OTHERS
2335: THEN
2336: ROLLBACK TO Update_Escalation;
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: if FND_MSG_PUB.Check_Msg_Level
2339: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2340: then
2341: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2342: end if;

Line 2339: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2335: THEN
2336: ROLLBACK TO Update_Escalation;
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: if FND_MSG_PUB.Check_Msg_Level
2339: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2340: then
2341: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2342: end if;
2343:

Line 2341: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: if FND_MSG_PUB.Check_Msg_Level
2339: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2340: then
2341: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2342: end if;
2343:
2344: fnd_msg_pub.count_and_get (
2345: p_count => x_msg_count,

Line 2344: fnd_msg_pub.count_and_get (

2340: then
2341: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2342: end if;
2343:
2344: fnd_msg_pub.count_and_get (
2345: p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );
2348: END UPDATE_ESCALATION;

Line 2391: FND_MSG_PUB.initialize;

2387:
2388: -- Check p_init_msg_list
2389:
2390: IF FND_API.To_Boolean( p_init_msg_list ) THEN
2391: FND_MSG_PUB.initialize;
2392: END IF;
2393:
2394: -- Initialize API return status to success
2395:

Line 2557: fnd_msg_pub.count_and_get

2553: IF FND_API.To_Boolean( p_commit ) THEN
2554: COMMIT WORK;
2555: END IF;
2556:
2557: fnd_msg_pub.count_and_get
2558: ( p_count => x_msg_count,
2559: p_data => x_msg_data
2560: );
2561:

Line 2569: fnd_msg_pub.count_and_get (

2565: THEN
2566: ROLLBACK TO Delete_Escalation;
2567: x_return_status := fnd_api.g_ret_sts_error;
2568:
2569: fnd_msg_pub.count_and_get (
2570: p_count => x_msg_count,
2571: p_data => x_msg_data
2572: );
2573:

Line 2579: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);

2575: THEN
2576:
2577: ROLLBACK TO Delete_Escalation;
2578: x_return_status := fnd_api.g_ret_sts_unexp_error;
2579: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
2580:
2581: WHEN OTHERS
2582: THEN
2583: ROLLBACK TO Delete_Escalation;

Line 2586: if FND_MSG_PUB.Check_Msg_Level

2582: THEN
2583: ROLLBACK TO Delete_Escalation;
2584: x_return_status := fnd_api.g_ret_sts_unexp_error;
2585:
2586: if FND_MSG_PUB.Check_Msg_Level
2587: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2588: then
2589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2590: end if;

Line 2587: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2583: ROLLBACK TO Delete_Escalation;
2584: x_return_status := fnd_api.g_ret_sts_unexp_error;
2585:
2586: if FND_MSG_PUB.Check_Msg_Level
2587: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2588: then
2589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2590: end if;
2591:

Line 2589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);

2585:
2586: if FND_MSG_PUB.Check_Msg_Level
2587: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2588: then
2589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2590: end if;
2591:
2592: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
2593:

Line 2592: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);

2588: then
2589: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
2590: end if;
2591:
2592: fnd_msg_pub.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
2593:
2594: END DELETE_ESCALATION;
2595:
2596: END JTF_EC_PUB;