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.JTY_WEBADI_OTH_TERR_UPDATE_PKG dependencies on FND_MESSAGE

Line 198: fnd_message.clear;

194: and user_sequence = p_user_sequence
195: and interface_type = p_intf_type;
196: else
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: fnd_message.clear;
199: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
200: FND_MESSAGE.set_token ('POSITION', l_parent);
201: X_Msg_Data := fnd_message.get();
202: update JTY_WEBADI_OTH_TERR_INTF

Line 199: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');

195: and interface_type = p_intf_type;
196: else
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: fnd_message.clear;
199: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
200: FND_MESSAGE.set_token ('POSITION', l_parent);
201: X_Msg_Data := fnd_message.get();
202: update JTY_WEBADI_OTH_TERR_INTF
203: set status = x_return_status

Line 200: FND_MESSAGE.set_token ('POSITION', l_parent);

196: else
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: fnd_message.clear;
199: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
200: FND_MESSAGE.set_token ('POSITION', l_parent);
201: X_Msg_Data := fnd_message.get();
202: update JTY_WEBADI_OTH_TERR_INTF
203: set status = x_return_status
204: , error_msg = X_Msg_Data

Line 201: X_Msg_Data := fnd_message.get();

197: x_return_status := FND_API.G_RET_STS_ERROR;
198: fnd_message.clear;
199: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
200: FND_MESSAGE.set_token ('POSITION', l_parent);
201: X_Msg_Data := fnd_message.get();
202: update JTY_WEBADI_OTH_TERR_INTF
203: set status = x_return_status
204: , error_msg = X_Msg_Data
205: where terr_name = l_hierarchy_tbl(c).terr_name

Line 240: fnd_message.clear;

236: and name = l_parent
237: and parent_territory_id = l_anc_id;
238: else
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.clear;
241: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
242: FND_MESSAGE.set_token ('POSITION', l_parent);
243: X_Msg_Data := fnd_message.get();
244:

Line 241: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');

237: and parent_territory_id = l_anc_id;
238: else
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.clear;
241: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
242: FND_MESSAGE.set_token ('POSITION', l_parent);
243: X_Msg_Data := fnd_message.get();
244:
245: update JTY_WEBADI_OTH_TERR_INTF

Line 242: FND_MESSAGE.set_token ('POSITION', l_parent);

238: else
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.clear;
241: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
242: FND_MESSAGE.set_token ('POSITION', l_parent);
243: X_Msg_Data := fnd_message.get();
244:
245: update JTY_WEBADI_OTH_TERR_INTF
246: set status = x_return_status

Line 243: X_Msg_Data := fnd_message.get();

239: x_return_status := FND_API.G_RET_STS_ERROR;
240: fnd_message.clear;
241: FND_MESSAGE.set_name ('JTF', 'JTY_OTH_TERR_NON_UNIQUE_TERR');
242: FND_MESSAGE.set_token ('POSITION', l_parent);
243: X_Msg_Data := fnd_message.get();
244:
245: update JTY_WEBADI_OTH_TERR_INTF
246: set status = x_return_status
247: , error_msg = X_Msg_Data

Line 527: fnd_message.clear;

523: qual_rec Qual_Rec_Type;
524: BEGIN
525:
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: fnd_message.clear;
528: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_NAME');
529: X_Msg_Data := fnd_message.get();
530:
531: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 528: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_NAME');

524: BEGIN
525:
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: fnd_message.clear;
528: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_NAME');
529: X_Msg_Data := fnd_message.get();
530:
531: update JTY_WEBADI_OTH_TERR_INTF jwot
532: set status = x_return_status,

Line 529: X_Msg_Data := fnd_message.get();

525:
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: fnd_message.clear;
528: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_NAME');
529: X_Msg_Data := fnd_message.get();
530:
531: update JTY_WEBADI_OTH_TERR_INTF jwot
532: set status = x_return_status,
533: error_msg = X_Msg_Data

Line 543: fnd_message.clear;

539: l_header := 'RSC';
540: l_action_flag := 'D';
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: fnd_message.clear;
544: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ID');
545: X_Msg_Data := fnd_message.get();
546:
547: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 544: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ID');

540: l_action_flag := 'D';
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: fnd_message.clear;
544: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ID');
545: X_Msg_Data := fnd_message.get();
546:
547: update JTY_WEBADI_OTH_TERR_INTF jwot
548: set status = x_return_status,

Line 545: X_Msg_Data := fnd_message.get();

541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: fnd_message.clear;
544: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ID');
545: X_Msg_Data := fnd_message.get();
546:
547: update JTY_WEBADI_OTH_TERR_INTF jwot
548: set status = x_return_status,
549: error_msg = X_Msg_Data

Line 577: fnd_message.clear;

573:
574: l_action_flag := 'U';
575:
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_message.clear;
578: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_TEMPLATE');
579: X_Msg_Data := fnd_message.get();
580:
581: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 578: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_TEMPLATE');

574: l_action_flag := 'U';
575:
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_message.clear;
578: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_TEMPLATE');
579: X_Msg_Data := fnd_message.get();
580:
581: update JTY_WEBADI_OTH_TERR_INTF jwot
582: set jwot.status = x_return_status,

Line 579: X_Msg_Data := fnd_message.get();

575:
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_message.clear;
578: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_TEMPLATE');
579: X_Msg_Data := fnd_message.get();
580:
581: update JTY_WEBADI_OTH_TERR_INTF jwot
582: set jwot.status = x_return_status,
583: jwot.error_msg = X_Msg_Data

Line 597: fnd_message.clear;

593: and jwot.status is null
594: AND jwot.TERR_ID is not null;
595:
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: fnd_message.clear;
598: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_TEMPLATE');
599: X_Msg_Data := fnd_message.get();
600:
601: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 598: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_TEMPLATE');

594: AND jwot.TERR_ID is not null;
595:
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: fnd_message.clear;
598: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_TEMPLATE');
599: X_Msg_Data := fnd_message.get();
600:
601: update JTY_WEBADI_OTH_TERR_INTF jwot
602: set status = x_return_status,

Line 599: X_Msg_Data := fnd_message.get();

595:
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: fnd_message.clear;
598: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_TEMPLATE');
599: X_Msg_Data := fnd_message.get();
600:
601: update JTY_WEBADI_OTH_TERR_INTF jwot
602: set status = x_return_status,
603: error_msg = X_Msg_Data

Line 613: fnd_message.clear;

609:
610: -- Commented it as a part of fix for bug #5479649
611: /*
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: fnd_message.clear;
614: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
615: X_Msg_Data := fnd_message.get();
616:
617: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 614: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');

610: -- Commented it as a part of fix for bug #5479649
611: /*
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: fnd_message.clear;
614: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
615: X_Msg_Data := fnd_message.get();
616:
617: update JTY_WEBADI_OTH_TERR_INTF jwot
618: set jwot.status = x_return_status,

Line 615: X_Msg_Data := fnd_message.get();

611: /*
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: fnd_message.clear;
614: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
615: X_Msg_Data := fnd_message.get();
616:
617: update JTY_WEBADI_OTH_TERR_INTF jwot
618: set jwot.status = x_return_status,
619: jwot.error_msg = X_Msg_Data

Line 667: fnd_message.clear;

663: -- Fix for bug #5479649 START
664: -- An error message should be displayed when all the access types
665: -- are NONE for all the transaction type of a resource.
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: fnd_message.clear;
668: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
669: X_Msg_Data := fnd_message.get();
670: update JTY_WEBADI_OTH_TERR_INTF jwot
671: set jwot.status = x_return_status,

Line 668: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');

664: -- An error message should be displayed when all the access types
665: -- are NONE for all the transaction type of a resource.
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: fnd_message.clear;
668: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
669: X_Msg_Data := fnd_message.get();
670: update JTY_WEBADI_OTH_TERR_INTF jwot
671: set jwot.status = x_return_status,
672: jwot.error_msg = X_Msg_Data

Line 669: X_Msg_Data := fnd_message.get();

665: -- are NONE for all the transaction type of a resource.
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: fnd_message.clear;
668: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_ACCESS');
669: X_Msg_Data := fnd_message.get();
670: update JTY_WEBADI_OTH_TERR_INTF jwot
671: set jwot.status = x_return_status,
672: jwot.error_msg = X_Msg_Data
673: where exists

Line 699: fnd_message.clear;

695:
696: -- Fix for bug # 6372728 START
697: -- Should display a error message when user tries to add a duplicate reosurce.
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: fnd_message.clear;
700: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_RESOURCE');
701: X_Msg_Data := fnd_message.get();
702:
703: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 700: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_RESOURCE');

696: -- Fix for bug # 6372728 START
697: -- Should display a error message when user tries to add a duplicate reosurce.
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: fnd_message.clear;
700: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_RESOURCE');
701: X_Msg_Data := fnd_message.get();
702:
703: update JTY_WEBADI_OTH_TERR_INTF jwot
704: set status = x_return_status

Line 701: X_Msg_Data := fnd_message.get();

697: -- Should display a error message when user tries to add a duplicate reosurce.
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: fnd_message.clear;
700: fnd_message.set_name ('JTF', 'JTF_TTY_DUPLICATE_RESOURCE');
701: X_Msg_Data := fnd_message.get();
702:
703: update JTY_WEBADI_OTH_TERR_INTF jwot
704: set status = x_return_status
705: , error_msg = X_Msg_Data

Line 726: fnd_message.clear;

722: -- Fix for bug # 6372728 END
723:
724:
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: fnd_message.clear;
727: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_START_DATE');
728: X_Msg_Data := fnd_message.get();
729:
730: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot

Line 727: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_START_DATE');

723:
724:
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: fnd_message.clear;
727: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_START_DATE');
728: X_Msg_Data := fnd_message.get();
729:
730: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
731: set jwot.status = x_return_status,

Line 728: X_Msg_Data := fnd_message.get();

724:
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: fnd_message.clear;
727: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_START_DATE');
728: X_Msg_Data := fnd_message.get();
729:
730: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
731: set jwot.status = x_return_status,
732: jwot.error_msg = X_Msg_Data

Line 748: fnd_message.clear;

744: and jwot.header = l_header
745: and jwot.status is null;
746:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: fnd_message.clear;
749: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_END_DATE');
750: X_Msg_Data := fnd_message.get();
751:
752: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot

Line 749: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_END_DATE');

745: and jwot.status is null;
746:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: fnd_message.clear;
749: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_END_DATE');
750: X_Msg_Data := fnd_message.get();
751:
752: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
753: set jwot.status = x_return_status,

Line 750: X_Msg_Data := fnd_message.get();

746:
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: fnd_message.clear;
749: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_RSC_END_DATE');
750: X_Msg_Data := fnd_message.get();
751:
752: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
753: set jwot.status = x_return_status,
754: jwot.error_msg = X_Msg_Data

Line 772: fnd_message.clear;

768:
769:
770: l_header := 'QUAL';
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: fnd_message.clear;
773: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_QUAL');
774: X_Msg_Data := fnd_message.get();
775:
776: open get_qual_csr(p_user_sequence, p_intf_type, l_header);

Line 773: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_QUAL');

769:
770: l_header := 'QUAL';
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: fnd_message.clear;
773: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_QUAL');
774: X_Msg_Data := fnd_message.get();
775:
776: open get_qual_csr(p_user_sequence, p_intf_type, l_header);
777: fetch get_qual_csr bulk collect into qual_rec.qualifier_name, qual_rec.lay_seq_num;

Line 774: X_Msg_Data := fnd_message.get();

770: l_header := 'QUAL';
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: fnd_message.clear;
773: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_INVALID_QUAL');
774: X_Msg_Data := fnd_message.get();
775:
776: open get_qual_csr(p_user_sequence, p_intf_type, l_header);
777: fetch get_qual_csr bulk collect into qual_rec.qualifier_name, qual_rec.lay_seq_num;
778: close get_qual_csr;

Line 795: fnd_message.clear;

791:
792: l_header := 'TERR';
793:
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: fnd_message.clear;
796: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_START_DATE');
797: X_Msg_Data := fnd_message.get();
798:
799: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot

Line 796: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_START_DATE');

792: l_header := 'TERR';
793:
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: fnd_message.clear;
796: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_START_DATE');
797: X_Msg_Data := fnd_message.get();
798:
799: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
800: set status = x_return_status,

Line 797: X_Msg_Data := fnd_message.get();

793:
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: fnd_message.clear;
796: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_START_DATE');
797: X_Msg_Data := fnd_message.get();
798:
799: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
800: set status = x_return_status,
801: error_msg = X_Msg_Data

Line 821: fnd_message.clear;

817: and NOT(jwot.TERR_START_DATE between jta.START_DATE_ACTIVE and jta.END_DATE_ACTIVE))
818: );
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: fnd_message.clear;
822: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_END_DATE');
823: X_Msg_Data := fnd_message.get();
824:
825: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot

Line 822: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_END_DATE');

818: );
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: fnd_message.clear;
822: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_END_DATE');
823: X_Msg_Data := fnd_message.get();
824:
825: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
826: set status = x_return_status,

Line 823: X_Msg_Data := fnd_message.get();

819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: fnd_message.clear;
822: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_END_DATE');
823: X_Msg_Data := fnd_message.get();
824:
825: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
826: set status = x_return_status,
827: error_msg = X_Msg_Data

Line 847: fnd_message.clear;

843: and NOT(jwot.TERR_END_DATE between jta.START_DATE_ACTIVE and jta.END_DATE_ACTIVE))
844: );
845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: fnd_message.clear;
848: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_ACCESS');
849: X_Msg_Data := fnd_message.get();
850:
851: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 848: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_ACCESS');

844: );
845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: fnd_message.clear;
848: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_ACCESS');
849: X_Msg_Data := fnd_message.get();
850:
851: update JTY_WEBADI_OTH_TERR_INTF jwot
852: set status = x_return_status,

Line 849: X_Msg_Data := fnd_message.get();

845:
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: fnd_message.clear;
848: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_NO_ACCESS');
849: X_Msg_Data := fnd_message.get();
850:
851: update JTY_WEBADI_OTH_TERR_INTF jwot
852: set status = x_return_status,
853: error_msg = X_Msg_Data

Line 1912: fnd_message.clear;

1908:
1909: EXCEPTION
1910: when others then
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.clear;
1913: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_TERR');
1914: X_Msg_Data := fnd_message.get();
1915:
1916: forall i in l_del_terr_rec.lay_seq_num.first..l_del_terr_rec.lay_seq_num.last

Line 1913: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_TERR');

1909: EXCEPTION
1910: when others then
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.clear;
1913: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_TERR');
1914: X_Msg_Data := fnd_message.get();
1915:
1916: forall i in l_del_terr_rec.lay_seq_num.first..l_del_terr_rec.lay_seq_num.last
1917: update JTY_WEBADI_OTH_TERR_INTF

Line 1914: X_Msg_Data := fnd_message.get();

1910: when others then
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.clear;
1913: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_TERR');
1914: X_Msg_Data := fnd_message.get();
1915:
1916: forall i in l_del_terr_rec.lay_seq_num.first..l_del_terr_rec.lay_seq_num.last
1917: update JTY_WEBADI_OTH_TERR_INTF
1918: set status = x_return_status,

Line 1961: fnd_message.clear;

1957:
1958: EXCEPTION
1959: when others then
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: fnd_message.clear;
1962: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL');
1963: X_Msg_Data := fnd_message.get();
1964:
1965: forall i in l_del_qual_val_rec.lay_seq_num.first..l_del_qual_val_rec.lay_seq_num.last

Line 1962: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL');

1958: EXCEPTION
1959: when others then
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: fnd_message.clear;
1962: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL');
1963: X_Msg_Data := fnd_message.get();
1964:
1965: forall i in l_del_qual_val_rec.lay_seq_num.first..l_del_qual_val_rec.lay_seq_num.last
1966: update JTY_WEBADI_OTH_TERR_INTF

Line 1963: X_Msg_Data := fnd_message.get();

1959: when others then
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961: fnd_message.clear;
1962: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL');
1963: X_Msg_Data := fnd_message.get();
1964:
1965: forall i in l_del_qual_val_rec.lay_seq_num.first..l_del_qual_val_rec.lay_seq_num.last
1966: update JTY_WEBADI_OTH_TERR_INTF
1967: set status = x_return_status,

Line 2008: fnd_message.clear;

2004:
2005: EXCEPTION
2006: when others then
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: fnd_message.clear;
2009: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_RSC');
2010: X_Msg_Data := fnd_message.get();
2011:
2012: forall i in l_del_rsc_rec.lay_seq_num.first..l_del_rsc_rec.lay_seq_num.last

Line 2009: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_RSC');

2005: EXCEPTION
2006: when others then
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: fnd_message.clear;
2009: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_RSC');
2010: X_Msg_Data := fnd_message.get();
2011:
2012: forall i in l_del_rsc_rec.lay_seq_num.first..l_del_rsc_rec.lay_seq_num.last
2013: update JTY_WEBADI_OTH_TERR_INTF

Line 2010: X_Msg_Data := fnd_message.get();

2006: when others then
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: fnd_message.clear;
2009: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_RSC');
2010: X_Msg_Data := fnd_message.get();
2011:
2012: forall i in l_del_rsc_rec.lay_seq_num.first..l_del_rsc_rec.lay_seq_num.last
2013: update JTY_WEBADI_OTH_TERR_INTF
2014: set status = x_return_status,

Line 2067: fnd_message.clear;

2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: fnd_message.clear;
2068: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL');
2069: X_Msg_Data := fnd_message.get();
2070:
2071: END INSERT_TERR_QUAL;

Line 2068: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL');

2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: fnd_message.clear;
2068: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL');
2069: X_Msg_Data := fnd_message.get();
2070:
2071: END INSERT_TERR_QUAL;
2072:

Line 2069: X_Msg_Data := fnd_message.get();

2065: WHEN OTHERS THEN
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: fnd_message.clear;
2068: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL');
2069: X_Msg_Data := fnd_message.get();
2070:
2071: END INSERT_TERR_QUAL;
2072:
2073: PROCEDURE INSERT_TERR_VALUES (

Line 2266: fnd_message.clear;

2262: END IF; -- TERR_QUAL_ID count
2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: fnd_message.clear;
2267: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL_VAL');
2268: X_Msg_Data := fnd_message.get();
2269:
2270: --dbms_output.put_line(sqlerrm);

Line 2267: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL_VAL');

2263: EXCEPTION
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: fnd_message.clear;
2267: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL_VAL');
2268: X_Msg_Data := fnd_message.get();
2269:
2270: --dbms_output.put_line(sqlerrm);
2271:

Line 2268: X_Msg_Data := fnd_message.get();

2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_ERROR;
2266: fnd_message.clear;
2267: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_QUAL_VAL');
2268: X_Msg_Data := fnd_message.get();
2269:
2270: --dbms_output.put_line(sqlerrm);
2271:
2272: END INSERT_TERR_VALUES;

Line 4607: fnd_message.clear;

4603:
4604: EXCEPTION
4605: WHEN OTHERS THEN
4606: x_return_status := FND_API.G_RET_STS_ERROR;
4607: fnd_message.clear;
4608: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_QUAL_VAL');
4609: X_Msg_Data := fnd_message.get();
4610:
4611: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last

Line 4608: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_QUAL_VAL');

4604: EXCEPTION
4605: WHEN OTHERS THEN
4606: x_return_status := FND_API.G_RET_STS_ERROR;
4607: fnd_message.clear;
4608: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_QUAL_VAL');
4609: X_Msg_Data := fnd_message.get();
4610:
4611: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4612: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot

Line 4609: X_Msg_Data := fnd_message.get();

4605: WHEN OTHERS THEN
4606: x_return_status := FND_API.G_RET_STS_ERROR;
4607: fnd_message.clear;
4608: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_QUAL_VAL');
4609: X_Msg_Data := fnd_message.get();
4610:
4611: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4612: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
4613: SET STATUS = x_return_status,

Line 4676: fnd_message.clear;

4672:
4673: EXCEPTION
4674: WHEN OTHERS THEN
4675: x_return_status := FND_API.G_RET_STS_ERROR;
4676: fnd_message.clear;
4677: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL_VAL');
4678: X_Msg_Data := fnd_message.get();
4679:
4680: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last

Line 4677: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL_VAL');

4673: EXCEPTION
4674: WHEN OTHERS THEN
4675: x_return_status := FND_API.G_RET_STS_ERROR;
4676: fnd_message.clear;
4677: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL_VAL');
4678: X_Msg_Data := fnd_message.get();
4679:
4680: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4681: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot

Line 4678: X_Msg_Data := fnd_message.get();

4674: WHEN OTHERS THEN
4675: x_return_status := FND_API.G_RET_STS_ERROR;
4676: fnd_message.clear;
4677: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_DELETE_QUAL_VAL');
4678: X_Msg_Data := fnd_message.get();
4679:
4680: forall i in l_Terr_Qual_Rec.TERR_QUAL_ID.first..l_Terr_Qual_Rec.TERR_QUAL_ID.last
4681: UPDATE JTY_WEBADI_OTH_TERR_INTF jwot
4682: SET STATUS = x_return_status,

Line 5245: fnd_message.clear;

5241:
5242: exception
5243: when others then
5244: x_return_status := FND_API.G_RET_STS_ERROR;
5245: fnd_message.clear;
5246: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_ACCESS');
5247: X_Msg_Data := fnd_message.get();
5248:
5249: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last

Line 5246: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_ACCESS');

5242: exception
5243: when others then
5244: x_return_status := FND_API.G_RET_STS_ERROR;
5245: fnd_message.clear;
5246: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_ACCESS');
5247: X_Msg_Data := fnd_message.get();
5248:
5249: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5250: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 5247: X_Msg_Data := fnd_message.get();

5243: when others then
5244: x_return_status := FND_API.G_RET_STS_ERROR;
5245: fnd_message.clear;
5246: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_CREATE_ACCESS');
5247: X_Msg_Data := fnd_message.get();
5248:
5249: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5250: update JTY_WEBADI_OTH_TERR_INTF jwot
5251: set status = x_return_status,

Line 5310: fnd_message.clear;

5306:
5307: exception
5308: when others then
5309: x_return_status := FND_API.G_RET_STS_ERROR;
5310: fnd_message.clear;
5311: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_ACCESS');
5312: X_Msg_Data := fnd_message.get();
5313:
5314: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last

Line 5311: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_ACCESS');

5307: exception
5308: when others then
5309: x_return_status := FND_API.G_RET_STS_ERROR;
5310: fnd_message.clear;
5311: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_ACCESS');
5312: X_Msg_Data := fnd_message.get();
5313:
5314: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5315: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 5312: X_Msg_Data := fnd_message.get();

5308: when others then
5309: x_return_status := FND_API.G_RET_STS_ERROR;
5310: fnd_message.clear;
5311: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_ACCESS');
5312: X_Msg_Data := fnd_message.get();
5313:
5314: forall i in l_rsc_access_rec.TERR_RSC_ID.first..l_rsc_access_rec.TERR_RSC_ID.last
5315: update JTY_WEBADI_OTH_TERR_INTF jwot
5316: set status = x_return_status,

Line 5334: fnd_message.clear;

5330:
5331: exception
5332: when others then
5333: x_return_status := FND_API.G_RET_STS_ERROR;
5334: fnd_message.clear;
5335: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_RSC');
5336: X_Msg_Data := fnd_message.get();
5337:
5338: update JTY_WEBADI_OTH_TERR_INTF jwot

Line 5335: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_RSC');

5331: exception
5332: when others then
5333: x_return_status := FND_API.G_RET_STS_ERROR;
5334: fnd_message.clear;
5335: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_RSC');
5336: X_Msg_Data := fnd_message.get();
5337:
5338: update JTY_WEBADI_OTH_TERR_INTF jwot
5339: set status = x_return_status,

Line 5336: X_Msg_Data := fnd_message.get();

5332: when others then
5333: x_return_status := FND_API.G_RET_STS_ERROR;
5334: fnd_message.clear;
5335: fnd_message.set_name ('JTF', 'JTY_OTH_TERR_UPDATE_RSC');
5336: X_Msg_Data := fnd_message.get();
5337:
5338: update JTY_WEBADI_OTH_TERR_INTF jwot
5339: set status = x_return_status,
5340: error_msg = X_Msg_Data