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_TTY_WEBADI_SALSTEAM_UPDATE dependencies on FND_MESSAGE

Line 103: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_GROUP_NAME');

99: x_group_id := group_rec.group_id; -- group_id assigned
100:
101: IF counter=2 THEN
102: x_status := 'E';
103: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_GROUP_NAME');
104: x_error_code := 1;
105: RETURN;
106: END IF;
107: END LOOP;

Line 121: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_ROLE_NAME');

117: counter := counter +1;
118: x_role_code := role_rec.role_code; -- role_code assigned
119: IF counter=2 THEN
120: x_status := 'E';
121: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_ROLE_NAME');
122: x_error_code := 1;
123: RETURN;
124: END IF;
125: END LOOP;

Line 135: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');

131:
132: EXCEPTION
133: WHEN NO_DATA_FOUND THEN
134: x_status := 'E';
135: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');
136: x_error_code := 1;
137: RETURN;
138:
139: END; -- of check group name and role name

Line 209: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

205: WHEN TOO_MANY_ROWS THEN RAISE TOO_MANY_ROWS; -- not common error.
206: WHEN OTHERS THEN
207: x_status := 'E';
208: x_error_code := 4;
209: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
210: END;
211: END LOOP;
212:
213: IF l_num_valid_rsc_id > 1 THEN

Line 224: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');

220:
221: EXCEPTION
222: WHEN NO_DATA_FOUND THEN
223: x_status := 'E';
224: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');
225: x_error_code := 1;
226: RETURN;
227: WHEN TOO_MANY_ROWS THEN
228: x_status := 'E';

Line 229: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_SALES_DATA');

225: x_error_code := 1;
226: RETURN;
227: WHEN TOO_MANY_ROWS THEN
228: x_status := 'E';
229: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_SALES_DATA');
230: x_error_code := 1;
231: RETURN;
232: WHEN OTHERS THEN
233: x_status := 'E';

Line 235: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

231: RETURN;
232: WHEN OTHERS THEN
233: x_status := 'E';
234: x_error_code := 4;
235: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
236: END; /* of xxx */
237:
238: -- check the role code
239: BEGIN

Line 250: fnd_message.set_name ('JTF', 'JTF_TTY_ROLE_NOT_IN_TG');

246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: x_status := 'E';
249: x_error_code := 2;
250: fnd_message.set_name ('JTF', 'JTF_TTY_ROLE_NOT_IN_TG');
251: RETURN;
252: END;
253:
254:

Line 284: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

280: WHEN TOO_MANY_ROWS THEN RAISE TOO_MANY_ROWS; -- not common error.
281: WHEN OTHERS THEN
282: x_status := 'E';
283: x_error_code := 4;
284: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
285: END;
286: END LOOP;
287:
288: IF l_num_valid_rsc_id > 1 THEN

Line 298: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');

294:
295: EXCEPTION
296: WHEN NO_DATA_FOUND THEN
297: x_status := 'E';
298: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');
299: x_error_code := 1;
300: RETURN;
301: WHEN TOO_MANY_ROWS THEN
302: x_status := 'E';

Line 303: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_SALES_DATA');

299: x_error_code := 1;
300: RETURN;
301: WHEN TOO_MANY_ROWS THEN
302: x_status := 'E';
303: fnd_message.set_name ('JTF', 'JTF_TTY_NON_UNIQUE_SALES_DATA');
304: x_error_code := 1;
305: RETURN;
306: WHEN OTHERS THEN
307: x_status := 'E';

Line 309: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

305: RETURN;
306: WHEN OTHERS THEN
307: x_status := 'E';
308: x_error_code := 4;
309: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
310:
311: END; /* of yyy */
312:
313:

Line 320: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');

316:
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: x_status := 'E';
320: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');
321: x_error_code := 1;
322: RETURN;
323:
324: END;

Line 343: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');

339:
340: EXCEPTION
341: WHEN NO_DATA_FOUND THEN
342: x_status := 'E';
343: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');
344: x_error_code := 1;
345: RETURN;
346: END;
347: END IF; --p_alignment_id is null */

Line 353: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_MANDATORY');

349:
350: ELSE
351: x_status := 'E';
352: x_error_code := 3;
353: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_MANDATORY');
354: RETURN;
355: END IF;
356:
357: EXCEPTION

Line 361: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

357: EXCEPTION
358: WHEN OTHERS THEN
359: x_status := 'E';
360: x_error_code := 4;
361: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
362:
363: END validate_resource;
364:
365:

Line 407: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');

403: EXCEPTION
404: WHEN NO_DATA_FOUND THEN
405: x_status := 'E';
406: x_error_code := 1;
407: fnd_message.set_name ('JTF', 'JTF_TTY_SALES_DATA_NOT_VALID');
408: RETURN;
409:
410: WHEN OTHERS THEN
411: x_status := 'E';

Line 413: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

409:
410: WHEN OTHERS THEN
411: x_status := 'E';
412: x_error_code := 4;
413: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
414: RETURN;
415: END;
416:
417:

Line 554: -- fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_SALES_REC');

550: when no_data_found then
551: x_status := 'E'; -- no error message necessary;
552: RETURN;
553: -- x_error_code := 5;
554: -- fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_SALES_REC');
555:
556: when others then
557: x_status := 'E';
558: x_error_code := 4;

Line 559: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

555:
556: when others then
557: x_status := 'E';
558: x_error_code := 4;
559: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
560:
561: end CHECK_VALID_RESOURCE_REMOVE;
562:
563:

Line 805: fnd_message.set_name ('JTF', 'JTF_TTY_DO_NOT_OWN_ALIGN');

801: END IF;
802:
803: EXCEPTION
804: WHEN NO_DATA_FOUND THEN
805: fnd_message.set_name ('JTF', 'JTF_TTY_DO_NOT_OWN_ALIGN');
806: RETURN;
807:
808: END;
809:

Line 825: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TG');

821: WHERE terr_group_account_id = l_terr_grp_acct_id;
822:
823: exception
824: when others then
825: fnd_message.set_name ('JTF', 'JTF_TTY_INVALID_TG');
826: return;
827:
828:
829: end;

Line 934: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '1'); end if;

930: l_added_rscs_tbl(i).attribute1 := 'N';
931: l_added_rscs_tbl(i).attribute2 := '1';
932: elsif x_status = 'I' then NULL;
933: else
934: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '1'); end if;
935: return;
936: end if;
937: end if;
938:

Line 972: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '2'); end if;

968: l_added_rscs_tbl(i).attribute1 := 'N';
969: l_added_rscs_tbl(i).attribute2 := '2';
970: elsif x_status = 'I' then NULL;
971: else
972: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '2'); end if;
973: return;
974: end if;
975: end if;
976:

Line 1010: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '3'); end if;

1006: l_added_rscs_tbl(i).attribute1 := 'N';
1007: l_added_rscs_tbl(i).attribute2 := '3';
1008: elsif x_status = 'I' then NULL;
1009: else
1010: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '3'); end if;
1011: return;
1012: end if;
1013: end if;
1014:

Line 1048: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '4'); end if;

1044: l_added_rscs_tbl(i).attribute1 := 'N';
1045: l_added_rscs_tbl(i).attribute2 := '4';
1046: elsif x_status = 'I' then NULL;
1047: else
1048: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '4'); end if;
1049: return;
1050: end if;
1051: end if;
1052:

Line 1086: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '5'); end if;

1082: l_added_rscs_tbl(i).attribute1 := 'N';
1083: l_added_rscs_tbl(i).attribute2 := '5';
1084: elsif x_status = 'I' then NULL;
1085: else
1086: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '5'); end if;
1087: return;
1088: end if;
1089: end if;
1090:

Line 1123: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '6'); end if;

1119: l_added_rscs_tbl(i).attribute1 := 'N';
1120: l_added_rscs_tbl(i).attribute2 := '6';
1121: elsif x_status = 'I' then NULL;
1122: else
1123: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '6'); end if;
1124: return;
1125: end if;
1126: end if;
1127:

Line 1160: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '7'); end if;

1156: l_added_rscs_tbl(i).attribute1 := 'N';
1157: l_added_rscs_tbl(i).attribute2 := '7';
1158: elsif x_status = 'I' then NULL;
1159: else
1160: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '7'); end if;
1161: return;
1162: end if;
1163: end if;
1164:

Line 1197: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '8'); end if;

1193: l_added_rscs_tbl(i).attribute1 := 'N';
1194: l_added_rscs_tbl(i).attribute2 := '8';
1195: elsif x_status = 'I' then NULL;
1196: else
1197: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '8'); end if;
1198: return;
1199: end if;
1200: end if;
1201:

Line 1234: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '9'); end if;

1230: l_added_rscs_tbl(i).attribute1 := 'N';
1231: l_added_rscs_tbl(i).attribute2 := '9';
1232: elsif x_status = 'I' then NULL;
1233: else
1234: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '9'); end if;
1235: return;
1236: end if;
1237: end if;
1238:

Line 1271: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '10'); end if;

1267: l_added_rscs_tbl(i).attribute1 := 'N';
1268: l_added_rscs_tbl(i).attribute2 := '10';
1269: elsif x_status = 'I' then NULL;
1270: else
1271: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '10'); end if;
1272: return;
1273: end if;
1274: end if;
1275:

Line 1308: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '11'); end if;

1304: l_added_rscs_tbl(i).attribute1 := 'N';
1305: l_added_rscs_tbl(i).attribute2 := '11';
1306: elsif x_status = 'I' then NULL;
1307: else
1308: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '11'); end if;
1309: return;
1310: end if;
1311: end if;
1312:

Line 1345: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '12'); end if;

1341: l_added_rscs_tbl(i).attribute1 := 'N';
1342: l_added_rscs_tbl(i).attribute2 := '12';
1343: elsif x_status = 'I' then NULL;
1344: else
1345: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '12'); end if;
1346: return;
1347: end if;
1348: end if;
1349:

Line 1382: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '13'); end if;

1378: l_added_rscs_tbl(i).attribute1 := 'N';
1379: l_added_rscs_tbl(i).attribute2 := '13';
1380: elsif x_status = 'I' then NULL;
1381: else
1382: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '13'); end if;
1383: return;
1384: end if;
1385: end if;
1386:

Line 1419: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '14'); end if;

1415: l_added_rscs_tbl(i).attribute1 := 'N';
1416: l_added_rscs_tbl(i).attribute2 := '14';
1417: elsif x_status = 'I' then NULL;
1418: else
1419: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '14'); end if;
1420: return;
1421: end if;
1422: end if;
1423:

Line 1456: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '15'); end if;

1452: l_added_rscs_tbl(i).attribute1 := 'N';
1453: l_added_rscs_tbl(i).attribute2 := '15';
1454: elsif x_status = 'I' then NULL;
1455: else
1456: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '15'); end if;
1457: return;
1458: end if;
1459: end if;
1460:

Line 1493: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '16'); end if;

1489: l_added_rscs_tbl(i).attribute1 := 'N';
1490: l_added_rscs_tbl(i).attribute2 := '16';
1491: elsif x_status = 'I' then NULL;
1492: else
1493: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '16'); end if;
1494: return;
1495: end if;
1496: end if;
1497:

Line 1530: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '17'); end if;

1526: l_added_rscs_tbl(i).attribute1 := 'N';
1527: l_added_rscs_tbl(i).attribute2 := '17';
1528: elsif x_status = 'I' then NULL;
1529: else
1530: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '17'); end if;
1531: return;
1532: end if;
1533: end if;
1534:

Line 1567: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '18'); end if;

1563: l_added_rscs_tbl(i).attribute1 := 'N';
1564: l_added_rscs_tbl(i).attribute2 := '18';
1565: elsif x_status = 'I' then NULL;
1566: else
1567: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '18'); end if;
1568: return;
1569: end if;
1570: end if;
1571:

Line 1604: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '19'); end if;

1600: l_added_rscs_tbl(i).attribute1 := 'N';
1601: l_added_rscs_tbl(i).attribute2 := '19';
1602: elsif x_status = 'I' then NULL;
1603: else
1604: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '19'); end if;
1605: return;
1606: end if;
1607: end if;
1608:

Line 1641: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '20'); end if;

1637: l_added_rscs_tbl(i).attribute1 := 'N';
1638: l_added_rscs_tbl(i).attribute2 := '20';
1639: elsif x_status = 'I' then NULL;
1640: else
1641: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '20'); end if;
1642: return;
1643: end if;
1644: end if;
1645:

Line 1678: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '21'); end if;

1674: l_added_rscs_tbl(i).attribute1 := 'N';
1675: l_added_rscs_tbl(i).attribute2 := '21';
1676: elsif x_status = 'I' then NULL;
1677: else
1678: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '21'); end if;
1679: return;
1680: return;
1681: end if;
1682: end if;

Line 1716: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '22'); end if;

1712: l_added_rscs_tbl(i).attribute1 := 'N';
1713: l_added_rscs_tbl(i).attribute2 := '22';
1714: elsif x_status = 'I' then NULL;
1715: else
1716: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '22'); end if;
1717: return;
1718: end if;
1719: end if;
1720:

Line 1753: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '23'); end if;

1749: l_added_rscs_tbl(i).attribute1 := 'N';
1750: l_added_rscs_tbl(i).attribute2 := '23';
1751: elsif x_status = 'I' then NULL;
1752: else
1753: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '23'); end if;
1754: return;
1755: end if;
1756: end if;
1757:

Line 1790: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '24'); end if;

1786: l_added_rscs_tbl(i).attribute1 := 'N';
1787: l_added_rscs_tbl(i).attribute2 := '24';
1788: elsif x_status = 'I' then NULL;
1789: else
1790: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '24'); end if;
1791: return;
1792: end if;
1793: end if;
1794:

Line 1827: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '25'); end if;

1823: l_added_rscs_tbl(i).attribute1 := 'N';
1824: l_added_rscs_tbl(i).attribute2 := '25';
1825: elsif x_status = 'I' then NULL;
1826: else
1827: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '25'); end if;
1828: return;
1829: end if;
1830: end if;
1831:

Line 1864: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '26'); end if;

1860: l_added_rscs_tbl(i).attribute1 := 'N';
1861: l_added_rscs_tbl(i).attribute2 := '26';
1862: elsif x_status = 'I' then NULL;
1863: else
1864: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '26'); end if;
1865: return;
1866: end if;
1867: end if;
1868:

Line 1901: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '27'); end if;

1897: l_added_rscs_tbl(i).attribute1 := 'N';
1898: l_added_rscs_tbl(i).attribute2 := '27';
1899: elsif x_status = 'I' then NULL;
1900: else
1901: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '27'); end if;
1902: return;
1903: end if;
1904: end if;
1905:

Line 1938: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '28'); end if;

1934: l_added_rscs_tbl(i).attribute1 := 'N';
1935: l_added_rscs_tbl(i).attribute2 := '28';
1936: elsif x_status = 'I' then NULL;
1937: else
1938: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '28'); end if;
1939: return;
1940: end if;
1941: end if;
1942:

Line 1975: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '29'); end if;

1971: l_added_rscs_tbl(i).attribute1 := 'N';
1972: l_added_rscs_tbl(i).attribute2 := '29';
1973: elsif x_status = 'I' then NULL;
1974: else
1975: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '29'); end if;
1976: return;
1977: end if;
1978: end if;
1979:

Line 2012: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '30'); end if;

2008: l_added_rscs_tbl(i).attribute1 := 'N';
2009: l_added_rscs_tbl(i).attribute2 := '30';
2010: elsif x_status = 'I' then NULL;
2011: else
2012: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', '30'); end if;
2013: return;
2014: end if;
2015: end if;
2016:

Line 2073: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', l_added_rscs_tbl(j).attribute2); end if;

2069: l_add_rscs_tbl(l_add_count).group_id := l_added_rscs_tbl(j).group_id;
2070: l_add_rscs_tbl(l_add_count).role_code := l_added_rscs_tbl(j).role_code;
2071: l_add_rscs_tbl(l_add_count).attribute1 := 'N';
2072: else
2073: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', l_added_rscs_tbl(j).attribute2); end if;
2074: return;
2075: end if;
2076: when others then
2077: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

Line 2077: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

2073: if x_error_code < 4 then FND_MESSAGE.Set_Token ('POSITION', l_added_rscs_tbl(j).attribute2); end if;
2074: return;
2075: end if;
2076: when others then
2077: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
2078: return;
2079: end;
2080: end loop;
2081: end if; -- end of l_added_rscs table not being null

Line 2123: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

2119: l_removed_rscs_tbl(l_delete_count).attribute1 := 'N';
2120: end if;
2121: Exception
2122: when others then
2123: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
2124: return;
2125: end;
2126: end if; -- if l_res_found = FALSE
2127: end loop; -- end of c_res loop

Line 2159: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

2155: l_add_rscs_tbl(l_add_count).group_id := l_added_rscs_tbl(j).group_id;
2156: l_add_rscs_tbl(l_add_count).role_code := l_added_rscs_tbl(j).role_code;
2157: l_add_rscs_tbl(l_add_count).attribute1 := 'N';
2158: when others then
2159: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
2160: return;
2161: end;
2162: end loop;
2163: end if; -- end of l_added_rscs table not being null

Line 2330: fnd_message.set_name ('JTF', 'JTF_TTY_NA_NOT_ASSIGED');

2326: -- commit;
2327:
2328: exception
2329: when no_data_found then
2330: fnd_message.set_name ('JTF', 'JTF_TTY_NA_NOT_ASSIGED');
2331: return;
2332:
2333: when others then
2334: --insert into tmp2 values('when others SALTEAM update','when others SALTEAM update'); commit;

Line 2335: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');

2331: return;
2332:
2333: when others then
2334: --insert into tmp2 values('when others SALTEAM update','when others SALTEAM update'); commit;
2335: fnd_message.set_name ('JTF', 'JTF_TTY_UNEXPECTED_ERROR');
2336: return;
2337:
2338:
2339: end;