APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on FND_MSG_PUB

Line 289: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Problems: ' || sqlerrm);

285: END IF; /* end IF (Trigger_Mode = 'ON-UPDATE') */
286:
287: EXCEPTION
288: When OTHERS then
289: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Problems: ' || sqlerrm);
290: RAISE;
291: END Territory_Trigger_Handler;
292:
293: --**************************************************************

Line 314: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');

310: EXCEPTION
311: WHEN NO_DATA_FOUND then
312: -- this should never happen since terr_qual_id req'd in jtf_terr_values
313: -- and terr_id terr_qual_id required in jtf_terr_qual
314: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
315: RAISE;
316: WHEN OTHERS then
317: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
318: RAISE;

Line 317: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);

313: -- and terr_id terr_qual_id required in jtf_terr_qual
314: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
315: RAISE;
316: WHEN OTHERS then
317: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
318: RAISE;
319: END;
320:
321: BEGIN

Line 370: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

366: ,'N'
367: ,'N');
368:
369: WHEN OTHERS THEN
370: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
371: RAISE;
372: END;
373:
374: EXCEPTION

Line 376: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Problems: ' || sqlerrm);

372: END;
373:
374: EXCEPTION
375: When OTHERS then
376: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Problems: ' || sqlerrm);
377: RAISE;
378:
379: END Terr_Values_Trigger_Handler;
380:

Line 433: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Problems: ' || sqlerrm);

429: END IF;
430:
431: EXCEPTION
432: When OTHERS then
433: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Problems: ' || sqlerrm);
434: RAISE;
435:
436: END Terr_Rsc_Trigger_Handler;
437:

Line 500: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

496: ,'Y'
497: ,'N');
498:
499: WHEN OTHERS THEN
500: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
501: RAISE;
502: END;
503:
504: EXCEPTION

Line 506: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Problems: ' || sqlerrm);

502: END;
503:
504: EXCEPTION
505: When OTHERS then
506: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Problems: ' || sqlerrm);
507: RAISE;
508:
509: END Terr_QType_Trigger_Handler;
510:

Line 530: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error getting terr_id: ' || sqlerrm);

526: from jtf_terr_rsc_all
527: where terr_rsc_id = p_terr_rsc_id;
528: EXCEPTION
529: When OTHERS then
530: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error getting terr_id: ' || sqlerrm);
531: RAISE;
532: End;
533:
534: BEGIN

Line 575: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Problems: ' || sqlerrm);

571: END IF;
572:
573: EXCEPTION
574: When OTHERS then
575: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Problems: ' || sqlerrm);
576: RAISE;
577: END Terr_RscAccess_Trigger_Handler;
578:
579:

Line 637: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

633: ,'Y'
634: ,'N');
635:
636: WHEN OTHERS THEN
637: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
638: RAISE;
639: END;
640:
641: EXCEPTION

Line 643: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Problems: ' || sqlerrm);

639: END;
640:
641: EXCEPTION
642: When OTHERS then
643: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Problems: ' || sqlerrm);
644: RAISE;
645:
646: END Terr_Qual_Trigger_Handler;
647:

Line 715: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_USGS_BIUD-Handler', 'Problems: ' || sqlerrm);

711: END IF;
712:
713: EXCEPTION
714: When OTHERS then
715: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_USGS_BIUD-Handler', 'Problems: ' || sqlerrm);
716: RAISE;
717:
718: END Terr_Usgs_Trigger_Handler;
719: