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.JTF_TERR_TRIGGER_HANDLERS dependencies on FND_MSG_PUB

Line 116: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error checking for existing terr record(1): ' || sqlerrm);

112: --dbms_output.put_line('JTDT- no data found in table');
113: exist_terr_id := NULL;
114: When OTHERS then
115: --dbms_output.put_line('JTDT- error while looking for existing records.');
116: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error checking for existing terr record(1): ' || sqlerrm);
117: null;
118: End;
119:
120: -- Write to JTF_CHANGED_TERR table in appropriate fasion

Line 154: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error updating record for inserting terr' || sqlerrm);

150:
151: EXCEPTION
152: When OTHERS then
153: --dbms_output.put_line('ON-INSERT/UPDATE-TERR: error updating record');
154: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error updating record for inserting terr' || sqlerrm);
155: End;
156: Else -- Terr_Exist = False -- New Territory Added
157: -- TEST results:
158: BEGIN

Line 171: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error inserting record for inserting terr' || sqlerrm);

167: n_end_date_active, n_rank, n_update_flag, n_num_winners, n_parent_territory_id);
168: EXCEPTION
169: When OTHERS then
170: --dbms_output.put_line('ON-INSERT/INSERT-TERR: error updating record');
171: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error inserting record for inserting terr' || sqlerrm);
172: End;
173: End if;
174: elsif Trigger_Mode = 'ON-UPDATE' then
175: -- (Territory Modified) items that may change:

Line 217: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error updating record for updating terr' || sqlerrm);

213:
214: EXCEPTION
215: When OTHERS then
216: --dbms_output.put_line('ON-UPDATE/UPDATE-TERR: error updating record');
217: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error updating record for updating terr' || sqlerrm);
218: End;
219:
220: Else -- Changed_Terr_rec_Exist = 'False'
221: -- New Territory Added

Line 242: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error inserting record for updating terr' || sqlerrm);

238: n_creation_date, n_created_by, n_last_update_login, n_start_date_active,
239: n_end_date_active, n_rank, n_update_flag, n_num_winners, n_parent_territory_id);
240: EXCEPTION
241: When OTHERS then
242: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error inserting record for updating terr' || sqlerrm);
243: null;
244: End;
245: End if;
246: else -- Trigger_mode = 'ON-DELETE'

Line 263: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr' || sqlerrm);

259: and request_id is null;
260: EXCEPTION
261: When OTHERS then
262: null;
263: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr' || sqlerrm);
264: End;
265: Else -- Changed_Terr_rec_Exist = 'False'
266: -- Now insert the jtf_changed_terr record documenting the deletion of this territory.
267: BEGIN

Line 279: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error inserting record for deleting terr' || sqlerrm);

275: o_end_date_active, o_rank, o_update_flag, o_num_winners, o_parent_territory_id);
276: EXCEPTION
277: When OTHERS then
278: null;
279: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error inserting record for deleting terr' || sqlerrm);
280: End;
281: End if;
282: End if;
283: EXCEPTION

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

283: EXCEPTION
284: When NOT_SALES_TERR_CHANGE then
285: null;
286: When OTHERS then
287: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Problems: ' || sqlerrm);
288: null;
289: END Territory_Trigger_Handler;
290:
291: --**************************************************************

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

367: WHEN NO_DATA_FOUND then
368: --dbms_output.put_line('JTDT- No data found error with extracting terr_qual_id or terr_id: ' || sqlerrm);
369: -- this should never happen since terr_qual_id req'd in jtf_terr_values
370: -- and terr_id terr_qual_id required in jtf_terr_qual
371: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
372: WHEN OTHERS then
373: --dbms_output.put_line('JTDT- Terr_val_trigger error with extracting terr_qual_id or terr_id: ' || sqlerrm);
374: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
375:

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

370: -- and terr_id terr_qual_id required in jtf_terr_qual
371: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
372: WHEN OTHERS then
373: --dbms_output.put_line('JTDT- Terr_val_trigger error with extracting terr_qual_id or terr_id: ' || sqlerrm);
374: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
375:
376: End;
377: -- check source of current territory
378: -- only add / modify records in jtf_changed_terr all

Line 413: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);

409: --dbms_output.put_line('JTDT- no data found in table: ' || sqlerrm);
410: When OTHERS then
411: null;
412: --dbms_output.put_line('JTDT- error while looking for existing records: ' || sqlerrm);
413: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);
414: End;
415:
416: -- Extract the terr_id for this terr_value_id
417: If Trigger_Mode = 'ON-INSERT' then

Line 451: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error inserting record for inserting terr val' || sqlerrm);

447: n_PRIMARY_INTEREST_CODE_ID, n_SECONDARY_INTEREST_CODE_ID, n_CURRENCY_CODE);
448: EXCEPTION
449: WHEN OTHERS THEN
450: --dbms_output.put_line('Failed at ON-INSERT, NEW_RECORD'|| sqlerrm);
451: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error inserting record for inserting terr val' || sqlerrm);
452: END;
453: End if;
454: elsif Trigger_mode = 'ON-UPDATE' then
455: If Changed_Terr_Value_Rec_Exists = 'True' then

Line 510: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while updating record for updating terr val: ' || sqlerrm);

506: and request_id is null;
507: EXCEPTION
508: WHEN OTHERS THEN
509: --dbms_output.put_line('Failed at ON-UPDATE, UPDATED_RECORD'|| sqlerrm);
510: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while updating record for updating terr val: ' || sqlerrm);
511: END;
512: else
513: -- Changed_Terr_Value_Rec_Exists = 'False'
514: -- Insert record

Line 544: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while inserting record for updating terr val' || sqlerrm);

540: n_PRIMARY_INTEREST_CODE_ID, n_SECONDARY_INTEREST_CODE_ID, n_CURRENCY_CODE, P_ORG_ID);
541: EXCEPTION
542: WHEN OTHERS THEN
543: --dbms_output.put_line('Failed at ON-UPDATE, NEW_RECORD'|| sqlerrm);
544: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while inserting record for updating terr val' || sqlerrm);
545: END;
546: End if;
547: else
548: -- Trigger_mode = 'ON-DELETE'

Line 563: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr value' || sqlerrm);

559: and request_id is null;
560: EXCEPTION
561: When OTHERS then
562: null;
563: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr value' || sqlerrm);
564: End;
565: else -- Changed_Terr_Value_Rec_Exists = 'False'
566: -- Insert record
567: BEGIN

Line 596: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while inserting record for deleting terr val ' || sqlerrm);

592: n_PRIMARY_INTEREST_CODE_ID, n_SECONDARY_INTEREST_CODE_ID, n_CURRENCY_CODE, P_ORG_ID);
593: EXCEPTION
594: WHEN OTHERS THEN
595: --dbms_output.put_line('Failed at ON-DELETE, NEW_RECORD' || sqlerrm);
596: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while inserting record for deleting terr val ' || sqlerrm);
597: END;
598: End if;
599: End if;
600: EXCEPTION

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

600: EXCEPTION
601: When NOT_SALES_TERR_CHANGE then
602: null;
603: When OTHERS then
604: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Problems: ' || sqlerrm);
605: null;
606:
607: END Terr_Values_Trigger_Handler;
608:

Line 688: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);

684: When NO_DATA_FOUND then
685: exist_terr_rsc_id := NULL;
686: Terr_Rsc_Rec_Exists := 'False';
687: When OTHERS then
688: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);
689: End;
690:
691: If Trigger_Mode = 'ON-INSERT' then
692: If Terr_Rsc_Rec_Exists = 'True' then

Line 719: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error inserting record for inserting terr rsc' || sqlerrm);

715: n_END_DATE_ACTIVE, n_FULL_ACCESS_FLAG);
716: --dbms_output.put_line('JTF_TERR_RSC_BIUD-Handler Success: ON-INSERT, NEW_RECORD'|| sqlerrm);
717: EXCEPTION
718: WHEN OTHERS THEN
719: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error inserting record for inserting terr rsc' || sqlerrm);
720: END;
721: End if;
722: elsif Trigger_mode = 'ON-UPDATE' then
723: If Terr_Rsc_Rec_Exists = 'True' then

Line 765: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error while updating record for updating terr rsc: ' || sqlerrm);

761: and terr_id = l_terr_id
762: and request_id is null;
763: EXCEPTION
764: WHEN OTHERS THEN
765: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error while updating record for updating terr rsc: ' || sqlerrm);
766: END;
767: else
768: -- Changed_Terr_Value_Rec_Exists = 'False'
769: -- Insert record

Line 791: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error while inserting record for updating terr rsc' || sqlerrm);

787: n_ROLE, n_PRIMARY_CONTACT_FLAG, n_START_DATE_ACTIVE, n_END_DATE_ACTIVE,
788: n_FULL_ACCESS_FLAG);
789: EXCEPTION
790: WHEN OTHERS THEN
791: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error while inserting record for updating terr rsc' || sqlerrm);
792: END;
793: End if;
794: else -- Trigger_mode = 'ON-DELETE'
795: If Terr_Rsc_Rec_Exists = 'True' then

Line 807: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);

803: and request_id is null;
804: EXCEPTION
805: When OTHERS then
806: null;
807: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);
808: End;
809: else -- Changed_Terr_Value_Rec_Exists = 'False'
810: BEGIN
811: INSERT INTO JTF_CHANGED_TERR

Line 831: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error while inserting record for deleting terr rsc ' || sqlerrm);

827: n_RESOURCE_TYPE, n_ROLE, n_PRIMARY_CONTACT_FLAG, n_START_DATE_ACTIVE,
828: n_END_DATE_ACTIVE, n_FULL_ACCESS_FLAG);
829: EXCEPTION
830: WHEN OTHERS THEN
831: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error while inserting record for deleting terr rsc ' || sqlerrm);
832: END;
833: End if;
834:
835: End if;

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

836: EXCEPTION
837: When NOT_SALES_TERR_CHANGE then
838: null;
839: When OTHERS then
840: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Problems: ' || sqlerrm);
841: null;
842:
843: END Terr_Rsc_Trigger_Handler;
844:

Line 919: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);

915: --dbms_output.put_line('JTDT- no data found in table: ' || sqlerrm);
916: When OTHERS then
917: null;
918: --dbms_output.put_line('JTDT- error while looking for existing records: ' || sqlerrm);
919: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);
920: End;
921:
922: -- Extract the terr_id for this terr_value_id
923: If Trigger_Mode = 'ON-INSERT' then

Line 944: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error inserting record for inserting terr qtype' || sqlerrm);

940:
941: EXCEPTION
942: WHEN OTHERS THEN
943: --dbms_output.put_line('Failed at ON-INSERT, NEW_RECORD'|| sqlerrm);
944: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error inserting record for inserting terr qtype' || sqlerrm);
945: END;
946: End if;
947: elsif Trigger_mode = 'ON-UPDATE' then
948: If Changed_Terr_QType_Rec_Exists = 'True' then

Line 977: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error while updating record for updating terr qtype: ' || sqlerrm);

973: and request_id is null;
974: EXCEPTION
975: WHEN OTHERS THEN
976: --dbms_output.put_line('Failed at ON-UPDATE, UPDATED_RECORD'|| sqlerrm);
977: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error while updating record for updating terr qtype: ' || sqlerrm);
978: END;
979: else
980: -- Changed_Terr_Value_Rec_Exists = 'False'
981: -- Insert record

Line 996: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error while inserting record for updating terr qtype: ' || sqlerrm);

992: o_qual_type_usg_id, n_qual_type_usg_id);
993: EXCEPTION
994: WHEN OTHERS THEN
995: --dbms_output.put_line('Failed at ON-UPDATE, NEW_RECORD'|| sqlerrm);
996: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error while inserting record for updating terr qtype: ' || sqlerrm);
997: END;
998: End if;
999: else
1000: -- Trigger_mode = 'ON-DELETE'

Line 1014: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);

1010: and request_id is null;
1011: EXCEPTION
1012: When OTHERS then
1013: null;
1014: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);
1015: End;
1016: else -- Changed_Terr_Value_Rec_Exists = 'False'
1017: BEGIN
1018: INSERT INTO JTF_CHANGED_TERR

Line 1031: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error while inserting record for deleting terr qtype: ' || sqlerrm);

1027: o_qual_type_usg_id, n_qual_type_usg_id);
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: --dbms_output.put_line('Failed at ON-DELETE, NEW_RECORD' || sqlerrm);
1031: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_USGS_BIUD-Handler', 'Error while inserting record for deleting terr qtype: ' || sqlerrm);
1032: END;
1033: End if;
1034: End if;
1035: EXCEPTION

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

1035: EXCEPTION
1036: When NOT_SALES_TERR_CHANGE then
1037: null;
1038: When OTHERS then
1039: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Problems: ' || sqlerrm);
1040: null;
1041:
1042: END Terr_QType_Trigger_Handler;
1043:

Line 1090: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'terr_id does not exist for terr_rsc_access_id');

1086: from jtf_terr_rsc
1087: where terr_rsc_id = l_terr_rsc_id;
1088: EXCEPTION
1089: WHEN NO_DATA_FOUND then
1090: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'terr_id does not exist for terr_rsc_access_id');
1091: WHEN OTHERS then
1092: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while fetching terr_id from terr_rsc_access_id: ' || sqlerrm);
1093: End;
1094:

Line 1092: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while fetching terr_id from terr_rsc_access_id: ' || sqlerrm);

1088: EXCEPTION
1089: WHEN NO_DATA_FOUND then
1090: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'terr_id does not exist for terr_rsc_access_id');
1091: WHEN OTHERS then
1092: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while fetching terr_id from terr_rsc_access_id: ' || sqlerrm);
1093: End;
1094:
1095: -- check source of current territory
1096: -- only add / modify records in jtf_changed_terr all

Line 1131: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);

1127: --dbms_output.put_line('JTDT- no data found in table: ' || sqlerrm);
1128: When OTHERS then
1129: null;
1130: --dbms_output.put_line('JTDT- error while looking for existing records: ' || sqlerrm);
1131: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error testing for existing record: ' || sqlerrm);
1132: End;
1133:
1134: -- Extract the terr_id for this terr_value_id
1135: If Trigger_Mode = 'ON-INSERT' then

Line 1156: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error inserting record for inserting rsc access' || sqlerrm);

1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: --dbms_output.put_line('Failed at ON-INSERT, NEW_RECORD'|| sqlerrm);
1156: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error inserting record for inserting rsc access' || sqlerrm);
1157: END;
1158: End if;
1159: elsif Trigger_mode = 'ON-UPDATE' then
1160: If Changed_Terr_RscAcc_Rec_Exists = 'True' then

Line 1189: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while updating record for updating rsc access: ' || sqlerrm);

1185: and request_id is null;
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: --dbms_output.put_line('Failed at ON-UPDATE, UPDATED_RECORD'|| sqlerrm);
1189: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while updating record for updating rsc access: ' || sqlerrm);
1190: END;
1191: else
1192: -- Changed_Terr_RscAccess_Rec_Exists = 'False'
1193: -- Insert record

Line 1208: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while inserting record for updating rsc access' || sqlerrm);

1204: o_access_type, n_access_type);
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: --dbms_output.put_line('Failed at ON-UPDATE, NEW_RECORD'|| sqlerrm);
1208: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while inserting record for updating rsc access' || sqlerrm);
1209: END;
1210: End if;
1211: else
1212: -- Trigger_mode = 'ON-DELETE'

Line 1225: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);

1221: and request_id is null;
1222: EXCEPTION
1223: When OTHERS then
1224: null;
1225: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Error deleting record for deleting terr rsc' || sqlerrm);
1226: End;
1227: else -- Changed_Terr_RscAccess_Rec_Exists = 'False'
1228: BEGIN
1229: INSERT INTO JTF_CHANGED_TERR

Line 1242: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while inserting record for deleting rsc access ' || sqlerrm);

1238: o_access_type, n_access_type);
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: --dbms_output.put_line('Failed at ON-DELETE, NEW_RECORD' || sqlerrm);
1242: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Error while inserting record for deleting rsc access ' || sqlerrm);
1243: END;
1244: End if;
1245: End if;
1246: EXCEPTION

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

1246: EXCEPTION
1247: When NOT_SALES_TERR_CHANGE then
1248: null;
1249: When OTHERS then
1250: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Problems: ' || sqlerrm);
1251: null;
1252: END Terr_RscAccess_Trigger_Handler;
1253:
1254: