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:
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:
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;
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:
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);
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:
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:
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:
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:
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;
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:
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:
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: -------------------------------------------------------------------------------------------------------
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:
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:
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
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;
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:
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);
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 (
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:
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:
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:
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
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;
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:
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);
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 (
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:
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:
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:
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:
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:
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;
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:
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,
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;
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:
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:
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:
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;
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;
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:
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:
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;