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

Line 137: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');

133:
134: if l_temp = 'X' then
135: fnd_msg_pub.initialize;
136: x_return_status := FND_API.G_RET_STS_ERROR ;
137: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
138: FND_MSG_PUB.ADD;
139: FND_MSG_PUB.Count_And_Get( P_count => x_msg_count,
140: P_data => x_msg_data);
141: end if;

Line 203: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');

199:
200: if l_temp = 'X' then
201: fnd_msg_pub.initialize;
202: x_return_status := FND_API.G_RET_STS_ERROR ;
203: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
204: FND_MSG_PUB.ADD;
205: FND_MSG_PUB.Count_And_Get ( P_count => x_msg_count, P_data => x_msg_data);
206: end if;
207:

Line 268: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');

264:
265: if l_temp = 'X' then
266: fnd_msg_pub.initialize;
267: x_return_status := FND_API.G_RET_STS_ERROR ;
268: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
269: FND_MSG_PUB.ADD;
270: FND_MSG_PUB.Count_And_Get ( P_count => x_msg_count, P_data => x_msg_data);
271: end if;
272:

Line 316: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');

312:
313: if l_temp = 'X'
314: then
315: x_return_status := FND_API.G_RET_STS_ERROR ;
316: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
317: FND_MSG_PUB.ADD;
318: FND_MSG_PUB.Count_And_Get
319: ( P_count => x_msg_count,
320: P_data => x_msg_data

Line 380: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');

376:
377: if l_temp = 'X'
378: then
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
381: FND_MSG_PUB.ADD;
382: FND_MSG_PUB.Count_And_Get
383: ( P_count => x_msg_count,
384: P_data => x_msg_data

Line 503: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

499:
500: -- Debug Message
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
502: THEN
503: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
504: fnd_message.set_name ('PROC_NAME', l_api_name);
505: FND_MSG_PUB.Add;
506: END IF;
507:

Line 504: fnd_message.set_name ('PROC_NAME', l_api_name);

500: -- Debug Message
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
502: THEN
503: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
504: fnd_message.set_name ('PROC_NAME', l_api_name);
505: FND_MSG_PUB.Add;
506: END IF;
507:
508: -- Initialize API return status to success

Line 628: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

624:
625: -- Debug Message
626: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
627: THEN
628: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
629: fnd_message.set_name ('PROC_NAME', l_api_name);
630: FND_MSG_PUB.Add;
631: END IF;
632:

Line 629: fnd_message.set_name ('PROC_NAME', l_api_name);

625: -- Debug Message
626: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
627: THEN
628: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
629: fnd_message.set_name ('PROC_NAME', l_api_name);
630: FND_MSG_PUB.Add;
631: END IF;
632:
633:

Line 769: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

765:
766: -- Debug Message
767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
768: THEN
769: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
770: fnd_message.set_name ('PROC_NAME', l_api_name);
771: FND_MSG_PUB.Add;
772: END IF;
773:

Line 770: fnd_message.set_name ('PROC_NAME', l_api_name);

766: -- Debug Message
767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
768: THEN
769: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
770: fnd_message.set_name ('PROC_NAME', l_api_name);
771: FND_MSG_PUB.Add;
772: END IF;
773:
774: -- Initialize API return status to success

Line 894: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

890:
891: -- Debug Message
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
893: THEN
894: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
895: fnd_message.set_name ('PROC_NAME', l_api_name);
896: FND_MSG_PUB.Add;
897: END IF;
898:

Line 895: fnd_message.set_name ('PROC_NAME', l_api_name);

891: -- Debug Message
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
893: THEN
894: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
895: fnd_message.set_name ('PROC_NAME', l_api_name);
896: FND_MSG_PUB.Add;
897: END IF;
898:
899:

Line 1033: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1029:
1030: -- Debug Message
1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1032: THEN
1033: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1034: fnd_message.set_name ('PROC_NAME', l_api_name);
1035: FND_MSG_PUB.Add;
1036: END IF;
1037:

Line 1034: fnd_message.set_name ('PROC_NAME', l_api_name);

1030: -- Debug Message
1031: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1032: THEN
1033: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1034: fnd_message.set_name ('PROC_NAME', l_api_name);
1035: FND_MSG_PUB.Add;
1036: END IF;
1037:
1038: -- Initialize API return status to success

Line 1075: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1071:
1072: -- Debug Message
1073: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1074: THEN
1075: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1076: fnd_message.set_name ('PROC_NAME', l_api_name);
1077: FND_MSG_PUB.Add;
1078: END IF;
1079:

Line 1076: fnd_message.set_name ('PROC_NAME', l_api_name);

1072: -- Debug Message
1073: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1074: THEN
1075: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1076: fnd_message.set_name ('PROC_NAME', l_api_name);
1077: FND_MSG_PUB.Add;
1078: END IF;
1079:
1080:

Line 1212: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1208:
1209: -- Debug Message
1210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1211: THEN
1212: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1213: fnd_message.set_name ('PROC_NAME', l_api_name);
1214: FND_MSG_PUB.Add;
1215: END IF;
1216:

Line 1213: fnd_message.set_name ('PROC_NAME', l_api_name);

1209: -- Debug Message
1210: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1211: THEN
1212: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1213: fnd_message.set_name ('PROC_NAME', l_api_name);
1214: FND_MSG_PUB.Add;
1215: END IF;
1216:
1217:

Line 1265: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1261:
1262: -- Debug Message
1263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1264: THEN
1265: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1266: fnd_message.set_name ('PROC_NAME', l_api_name);
1267: FND_MSG_PUB.Add;
1268: END IF;
1269:

Line 1266: fnd_message.set_name ('PROC_NAME', l_api_name);

1262: -- Debug Message
1263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1264: THEN
1265: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1266: fnd_message.set_name ('PROC_NAME', l_api_name);
1267: FND_MSG_PUB.Add;
1268: END IF;
1269:
1270:

Line 1336: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1332:
1333: -- Debug Message
1334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1335: THEN
1336: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1337: fnd_message.set_name ('PROC_NAME', l_api_name);
1338: FND_MSG_PUB.Add;
1339: END IF;
1340:

Line 1337: fnd_message.set_name ('PROC_NAME', l_api_name);

1333: -- Debug Message
1334: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1335: THEN
1336: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1337: fnd_message.set_name ('PROC_NAME', l_api_name);
1338: FND_MSG_PUB.Add;
1339: END IF;
1340:
1341: -- Initialize API return status to success

Line 1360: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');

1356: THEN
1357: -- Debug message
1358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1359: THEN
1360: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1361: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
1362: FND_MSG_PUB.Add;
1363: END IF;
1364: --

Line 1361: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');

1357: -- Debug message
1358: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1359: THEN
1360: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1361: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
1362: FND_MSG_PUB.Add;
1363: END IF;
1364: --
1365: -- Invoke validation procedures

Line 1432: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1428:
1429: -- Debug Message
1430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1431: THEN
1432: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1433: fnd_message.set_name ('PROC_NAME', l_api_name);
1434: FND_MSG_PUB.Add;
1435: END IF;
1436:

Line 1433: fnd_message.set_name ('PROC_NAME', l_api_name);

1429: -- Debug Message
1430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1431: THEN
1432: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1433: fnd_message.set_name ('PROC_NAME', l_api_name);
1434: FND_MSG_PUB.Add;
1435: END IF;
1436:
1437: --dbms_output.put_line('Create_Terr_Resource REC: Exiting API');

Line 1518: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1514:
1515: -- Debug Message
1516: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1517: THEN
1518: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1519: fnd_message.set_name ('PROC_NAME', l_api_name);
1520: FND_MSG_PUB.Add;
1521: END IF;
1522:

Line 1519: fnd_message.set_name ('PROC_NAME', l_api_name);

1515: -- Debug Message
1516: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1517: THEN
1518: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1519: fnd_message.set_name ('PROC_NAME', l_api_name);
1520: FND_MSG_PUB.Add;
1521: END IF;
1522:
1523: -- Initialize API return status to success

Line 1542: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');

1538: THEN
1539: -- Debug message
1540: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1541: THEN
1542: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1543: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
1544: FND_MSG_PUB.Add;
1545: END IF;
1546: --

Line 1543: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');

1539: -- Debug message
1540: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1541: THEN
1542: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1543: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
1544: FND_MSG_PUB.Add;
1545: END IF;
1546: --
1547: -- Invoke validation procedures

Line 1598: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1594:
1595: -- Debug Message
1596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1597: THEN
1598: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1599: fnd_message.set_name ('PROC_NAME', l_api_name);
1600: FND_MSG_PUB.Add;
1601: END IF;
1602:

Line 1599: fnd_message.set_name ('PROC_NAME', l_api_name);

1595: -- Debug Message
1596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1597: THEN
1598: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1599: fnd_message.set_name ('PROC_NAME', l_api_name);
1600: FND_MSG_PUB.Add;
1601: END IF;
1602:
1603: --dbms_output.put_line('Create_Terr_Resource REC: Exiting API');

Line 1661: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1657:
1658: -- Debug Message
1659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1660: THEN
1661: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1662: fnd_message.set_name ('PROC_NAME', l_api_name);
1663: FND_MSG_PUB.Add;
1664: END IF;
1665:

Line 1662: fnd_message.set_name ('PROC_NAME', l_api_name);

1658: -- Debug Message
1659: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1660: THEN
1661: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1662: fnd_message.set_name ('PROC_NAME', l_api_name);
1663: FND_MSG_PUB.Add;
1664: END IF;
1665:
1666: -- Initialize API return status to success

Line 1724: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1720:
1721: -- Debug Message
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1723: THEN
1724: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1725: fnd_message.set_name ('PROC_NAME', l_api_name);
1726: FND_MSG_PUB.Add;
1727: END IF;
1728: --dbms_output.put_line('Create_Terr_Resource TBL: Exiting API');

Line 1725: fnd_message.set_name ('PROC_NAME', l_api_name);

1721: -- Debug Message
1722: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1723: THEN
1724: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1725: fnd_message.set_name ('PROC_NAME', l_api_name);
1726: FND_MSG_PUB.Add;
1727: END IF;
1728: --dbms_output.put_line('Create_Terr_Resource TBL: Exiting API');
1729: --

Line 1789: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

1785:
1786: -- Debug Message
1787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1788: THEN
1789: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1790: fnd_message.set_name ('PROC_NAME', l_api_name);
1791: FND_MSG_PUB.Add;
1792: END IF;
1793:

Line 1790: fnd_message.set_name ('PROC_NAME', l_api_name);

1786: -- Debug Message
1787: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1788: THEN
1789: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1790: fnd_message.set_name ('PROC_NAME', l_api_name);
1791: FND_MSG_PUB.Add;
1792: END IF;
1793:
1794: -- Initialize API return status to success

Line 1852: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1848:
1849: -- Debug Message
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1851: THEN
1852: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1853: fnd_message.set_name ('PROC_NAME', l_api_name);
1854: FND_MSG_PUB.Add;
1855: END IF;
1856: --dbms_output.put_line('Create_Terr_Resource TBL: Exiting API');

Line 1853: fnd_message.set_name ('PROC_NAME', l_api_name);

1849: -- Debug Message
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1851: THEN
1852: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1853: fnd_message.set_name ('PROC_NAME', l_api_name);
1854: FND_MSG_PUB.Add;
1855: END IF;
1856: --dbms_output.put_line('Create_Terr_Resource TBL: Exiting API');
1857: --

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

1909:
1910: -- Debug Message
1911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1912: THEN
1913: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1914: fnd_message.set_name ('PROC_NAME', l_api_name);
1915: FND_MSG_PUB.Add;
1916: END IF;
1917:

Line 1914: fnd_message.set_name ('PROC_NAME', l_api_name);

1910: -- Debug Message
1911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1912: THEN
1913: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1914: fnd_message.set_name ('PROC_NAME', l_api_name);
1915: FND_MSG_PUB.Add;
1916: END IF;
1917:
1918: -- Initialize API return status to success

Line 1927: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');

1923: THEN
1924: -- Debug message
1925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1926: THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1928: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
1929: FND_MSG_PUB.Add;
1930: END IF;
1931: --

Line 1928: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');

1924: -- Debug message
1925: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1926: THEN
1927: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1928: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
1929: FND_MSG_PUB.Add;
1930: END IF;
1931: --
1932: -- Invoke validation procedures

Line 1991: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

1987:
1988: -- Debug Message
1989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1990: THEN
1991: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1992: fnd_message.set_name ('PROC_NAME', l_api_name);
1993: FND_MSG_PUB.Add;
1994: END IF;
1995:

Line 1992: fnd_message.set_name ('PROC_NAME', l_api_name);

1988: -- Debug Message
1989: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1990: THEN
1991: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1992: fnd_message.set_name ('PROC_NAME', l_api_name);
1993: FND_MSG_PUB.Add;
1994: END IF;
1995:
1996: --dbms_output.put_line('Create_Resource _Access REC: Exiting API');

Line 2090: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

2086:
2087: -- Debug Message
2088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2089: THEN
2090: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2091: fnd_message.set_name ('PROC_NAME', l_api_name);
2092: FND_MSG_PUB.Add;
2093: END IF;
2094:

Line 2091: fnd_message.set_name ('PROC_NAME', l_api_name);

2087: -- Debug Message
2088: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2089: THEN
2090: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2091: fnd_message.set_name ('PROC_NAME', l_api_name);
2092: FND_MSG_PUB.Add;
2093: END IF;
2094:
2095:

Line 2151: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

2147:
2148: -- Debug Message
2149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2150: THEN
2151: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2152: fnd_message.set_name ('PROC_NAME', l_api_name);
2153: FND_MSG_PUB.Add;
2154: END IF;
2155:

Line 2152: fnd_message.set_name ('PROC_NAME', l_api_name);

2148: -- Debug Message
2149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2150: THEN
2151: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2152: fnd_message.set_name ('PROC_NAME', l_api_name);
2153: FND_MSG_PUB.Add;
2154: END IF;
2155:
2156: --

Line 2226: FND_MESSAGE.Set_Name('JTF', 'Delete TerrRscAccess : Start');

2222:
2223: -- Debug Message
2224: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2225: THEN
2226: FND_MESSAGE.Set_Name('JTF', 'Delete TerrRscAccess : Start');
2227: FND_MSG_PUB.Add;
2228: END IF;
2229:
2230: --Initialize the return status to success

Line 2236: FND_MESSAGE.SET_NAME('JTF','TERR_RSCACCESSES_DELETED');

2232: --
2233: JTF_TERR_RSC_ACCESS_PKG.Delete_Row(x_TERR_RSC_ACCESS_ID => P_TerrRsc_Access_Id );
2234: --
2235: --Prepare message name
2236: FND_MESSAGE.SET_NAME('JTF','TERR_RSCACCESSES_DELETED');
2237:
2238: IF SQL%FOUND THEN
2239: x_return_status := FND_API.G_RET_STS_SUCCESS;
2240: l_row_count := SQL%ROWCOUNT;

Line 2244: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);

2240: l_row_count := SQL%ROWCOUNT;
2241: END IF;
2242:
2243: --Prepare message token
2244: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);
2245: --Add message to API message list
2246: FND_MSG_PUB.ADD();
2247:
2248: -- Debug Message

Line 2251: FND_MESSAGE.Set_Name('JTF', 'Delete TerrRscAccess: End');

2247:
2248: -- Debug Message
2249: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2250: THEN
2251: FND_MESSAGE.Set_Name('JTF', 'Delete TerrRscAccess: End');
2252: FND_MSG_PUB.Add;
2253: END IF;
2254:
2255:

Line 2272: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);

2268: WHEN NO_DATA_FOUND THEN
2269: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: l_row_count := 0;
2271: --Prepare message token
2272: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);
2273: --Add message to API message list
2274: FND_MSG_PUB.ADD();
2275: --
2276: FND_MSG_PUB.Count_And_Get

Line 2364: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

2360:
2361: -- Debug Message
2362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2363: THEN
2364: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2365: fnd_message.set_name ('PROC_NAME', l_api_name);
2366: FND_MSG_PUB.Add;
2367: END IF;
2368:

Line 2365: fnd_message.set_name ('PROC_NAME', l_api_name);

2361: -- Debug Message
2362: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2363: THEN
2364: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2365: fnd_message.set_name ('PROC_NAME', l_api_name);
2366: FND_MSG_PUB.Add;
2367: END IF;
2368:
2369: --Initialize the return status to success

Line 2375: FND_MESSAGE.SET_NAME('JTF','TERR_RESOURCE_DELETED');

2371: --
2372: JTF_TERR_RSC_PKG.Delete_Row(x_TERR_RSC_ID => P_TerrRsc_Id);
2373: --
2374: --Prepare message name
2375: FND_MESSAGE.SET_NAME('JTF','TERR_RESOURCE_DELETED');
2376:
2377: IF SQL%FOUND THEN
2378: x_return_status := FND_API.G_RET_STS_SUCCESS;
2379: l_row_count := SQL%ROWCOUNT;

Line 2383: FND_MESSAGE.SET_TOKEN('ITEMS_DELETED', l_row_count);

2379: l_row_count := SQL%ROWCOUNT;
2380: END IF;
2381:
2382: --Prepare message token
2383: FND_MESSAGE.SET_TOKEN('ITEMS_DELETED', l_row_count);
2384:
2385: --Add message to API message list
2386: FND_MSG_PUB.ADD();
2387:

Line 2391: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');

2387:
2388: -- Debug Message
2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2390: THEN
2391: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2392: fnd_message.set_name ('PROC_NAME', l_api_name);
2393: FND_MSG_PUB.Add;
2394: END IF;
2395:

Line 2392: fnd_message.set_name ('PROC_NAME', l_api_name);

2388: -- Debug Message
2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2390: THEN
2391: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2392: fnd_message.set_name ('PROC_NAME', l_api_name);
2393: FND_MSG_PUB.Add;
2394: END IF;
2395:
2396:

Line 2415: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);

2411: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2412: l_row_count := 0;
2413:
2414: --Prepare message token
2415: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);
2416:
2417: --Add message to API message list
2418: FND_MSG_PUB.ADD();
2419: --

Line 2517: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');

2513:
2514: --Validate the incomming record
2515: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
2516: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2517: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2518: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
2519: FND_MSG_PUB.Add;
2520: END IF;
2521:

Line 2518: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');

2514: --Validate the incomming record
2515: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
2516: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2517: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2518: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
2519: FND_MSG_PUB.Add;
2520: END IF;
2521:
2522: -- Invoke validation procedures

Line 2543: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');

2539: l_ref_TerrRsc_Rec.ORG_ID;
2540:
2541: If (C_GetTerrResource%NOTFOUND) Then
2542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2543: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2544: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
2545: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));
2546: FND_MSG_PUB.Add;
2547: END IF;

Line 2544: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');

2540:
2541: If (C_GetTerrResource%NOTFOUND) Then
2542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2543: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2544: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
2545: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));
2546: FND_MSG_PUB.Add;
2547: END IF;
2548: raise FND_API.G_EXC_ERROR;

Line 2545: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));

2541: If (C_GetTerrResource%NOTFOUND) Then
2542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2543: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2544: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
2545: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));
2546: FND_MSG_PUB.Add;
2547: END IF;
2548: raise FND_API.G_EXC_ERROR;
2549: End if;

Line 2777: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');

2773: THEN
2774: -- Debug message
2775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2776: THEN
2777: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2778: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
2779: FND_MSG_PUB.Add;
2780: END IF;
2781: --

Line 2778: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');

2774: -- Debug message
2775: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2776: THEN
2777: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2778: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
2779: FND_MSG_PUB.Add;
2780: END IF;
2781: --
2782: -- Invoke validation procedures

Line 2815: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');

2811: If ( C_GetTerrResAccess%NOTFOUND) Then
2812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2813: THEN
2814: --dbms_output.put_line('Update_Resource_Access REC: DATA-NOT-FOUND');
2815: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2816: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');
2817: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));
2818: FND_MSG_PUB.Add;
2819: END IF;

Line 2816: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');

2812: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2813: THEN
2814: --dbms_output.put_line('Update_Resource_Access REC: DATA-NOT-FOUND');
2815: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2816: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');
2817: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));
2818: FND_MSG_PUB.Add;
2819: END IF;
2820: raise FND_API.G_EXC_ERROR;

Line 2817: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));

2813: THEN
2814: --dbms_output.put_line('Update_Resource_Access REC: DATA-NOT-FOUND');
2815: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2816: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');
2817: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));
2818: FND_MSG_PUB.Add;
2819: END IF;
2820: raise FND_API.G_EXC_ERROR;
2821: End if;

Line 3033: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');

3029: --
3030: WHEN NO_DATA_FOUND THEN
3031: --dbms_output.put_line('Validate_Foreign_Keys: NO_DATA_FOUND');
3032: x_return_status := FND_API.G_RET_STS_ERROR ;
3033: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');
3034: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );
3035: FND_MSG_PUB.ADD;
3036: FND_MSG_PUB.Count_And_Get
3037: ( P_count => x_msg_count,

Line 3034: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );

3030: WHEN NO_DATA_FOUND THEN
3031: --dbms_output.put_line('Validate_Foreign_Keys: NO_DATA_FOUND');
3032: x_return_status := FND_API.G_RET_STS_ERROR ;
3033: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');
3034: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );
3035: FND_MSG_PUB.ADD;
3036: FND_MSG_PUB.Count_And_Get
3037: ( P_count => x_msg_count,
3038: P_data => x_msg_data

Line 3119: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');

3115: --
3116: WHEN NO_DATA_FOUND THEN
3117: --dbms_output.put_line('Validate_Foreign_Keys: NO_DATA_FOUND');
3118: x_return_status := FND_API.G_RET_STS_ERROR ;
3119: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');
3120: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );
3121: FND_MSG_PUB.ADD;
3122: FND_MSG_PUB.Count_And_Get
3123: ( P_count => x_msg_count,

Line 3120: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );

3116: WHEN NO_DATA_FOUND THEN
3117: --dbms_output.put_line('Validate_Foreign_Keys: NO_DATA_FOUND');
3118: x_return_status := FND_API.G_RET_STS_ERROR ;
3119: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');
3120: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );
3121: FND_MSG_PUB.ADD;
3122: FND_MSG_PUB.Count_And_Get
3123: ( P_count => x_msg_count,
3124: P_data => x_msg_data

Line 3170: fnd_message.set_name('JTF', 'JTF_TERR_MULTIPLE_PRIMARY_FLAG');

3166:
3167: -- Cannot have more than one Primary flag
3168: If l_Primary_Count > 1 Then
3169: --
3170: fnd_message.set_name('JTF', 'JTF_TERR_MULTIPLE_PRIMARY_FLAG');
3171: FND_MSG_PUB.ADD;
3172: raise FND_API.G_EXC_ERROR;
3173: --
3174: End If;

Line 3265: fnd_message.set_name('JTF', 'JTF_TERR_MULTIPLE_PRIMARY_FLAG');

3261:
3262: -- Cannot have more than one Primary flag
3263: If l_Primary_Count > 1 Then
3264: --
3265: fnd_message.set_name('JTF', 'JTF_TERR_MULTIPLE_PRIMARY_FLAG');
3266: FND_MSG_PUB.ADD;
3267: raise FND_API.G_EXC_ERROR;
3268: --
3269: End If;

Line 3361: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_TERRRES_REC');

3357:
3358: -- If the territory Usage records is missing
3359: If (p_TerrRsc_Tbl.count = 0 ) Then
3360: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3361: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_TERRRES_REC');
3362: FND_MSG_PUB.ADD;
3363: END IF;
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: raise FND_API.G_EXC_ERROR;

Line 3485: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_TERRRES_REC');

3481:
3482: -- If the territory Usage records is missing
3483: If (p_TerrRsc_Tbl.count = 0 ) Then
3484: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3485: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_TERRRES_REC');
3486: FND_MSG_PUB.ADD;
3487: END IF;
3488: x_return_status := FND_API.G_RET_STS_ERROR;
3489: raise FND_API.G_EXC_ERROR;

Line 3576: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3572: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3573: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then
3574: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3576: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3577: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3578: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3579: FND_MSG_PUB.ADD;
3580: END IF;

Line 3577: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

3573: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then
3574: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3576: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3577: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3578: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3579: FND_MSG_PUB.ADD;
3580: END IF;
3581: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3578: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

3574: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3576: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3577: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3578: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3579: FND_MSG_PUB.ADD;
3580: END IF;
3581: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3582: End If;

Line 3585: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3581: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3582: End If;
3583: Else
3584: -- Invalid Territory Id specified
3585: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3586: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3587: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3588: FND_MSG_PUB.ADD;
3589: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3586: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

3582: End If;
3583: Else
3584: -- Invalid Territory Id specified
3585: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3586: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3587: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3588: FND_MSG_PUB.ADD;
3589: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3590: End If;

Line 3587: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

3583: Else
3584: -- Invalid Territory Id specified
3585: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3586: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3587: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3588: FND_MSG_PUB.ADD;
3589: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3590: End If;
3591:

Line 3596: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3592: --Check last update login
3593: If ( p_TerrRsc_Rec.RESOURCE_TYPE is NULL OR
3594: p_TerrRsc_Rec.RESOURCE_TYPE = FND_API.G_MISS_CHAR ) THEN
3595: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3596: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3597: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );
3598: FND_MSG_PUB.ADD;
3599: END IF;
3600: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3597: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );

3593: If ( p_TerrRsc_Rec.RESOURCE_TYPE is NULL OR
3594: p_TerrRsc_Rec.RESOURCE_TYPE = FND_API.G_MISS_CHAR ) THEN
3595: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3596: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3597: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );
3598: FND_MSG_PUB.ADD;
3599: END IF;
3600: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3601: End If;

Line 3607: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3603: --Check created by
3604: IF ( p_TerrRsc_Rec.CREATED_BY is NULL OR
3605: p_TerrRsc_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3607: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3608: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3609: FND_MSG_PUB.ADD;
3610: END IF;
3611: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3608: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );

3604: IF ( p_TerrRsc_Rec.CREATED_BY is NULL OR
3605: p_TerrRsc_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3606: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3607: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3608: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3609: FND_MSG_PUB.ADD;
3610: END IF;
3611: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3612: End If;

Line 3618: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3614: --Check creation date
3615: If ( p_TerrRsc_Rec.CREATION_DATE is NULL OR
3616: p_TerrRsc_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3618: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3619: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3620: FND_MSG_PUB.ADD;
3621: END IF;
3622: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3619: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );

3615: If ( p_TerrRsc_Rec.CREATION_DATE is NULL OR
3616: p_TerrRsc_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3617: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3618: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3619: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3620: FND_MSG_PUB.ADD;
3621: END IF;
3622: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3623: End If;

Line 3629: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3625: -- Validate last updated by
3626: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
3627: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3629: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3630: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3631: FND_MSG_PUB.ADD;
3632: END IF;
3633: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3630: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );

3626: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
3627: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3628: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3629: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3630: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3631: FND_MSG_PUB.ADD;
3632: END IF;
3633: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3634: End If;

Line 3640: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3636: -- Check last update date
3637: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
3638: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3640: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3641: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3642: FND_MSG_PUB.ADD;
3643: END IF;
3644: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3641: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );

3637: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
3638: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3639: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3640: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3641: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3642: FND_MSG_PUB.ADD;
3643: END IF;
3644: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3645: End If;

Line 3651: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3647: --Check last update login
3648: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
3649: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3651: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3652: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3653: FND_MSG_PUB.ADD;
3654: END IF;
3655: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3652: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );

3648: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
3649: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3651: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3652: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3653: FND_MSG_PUB.ADD;
3654: END IF;
3655: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3656: End If;

Line 3726: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3722: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3723: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then
3724: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3727: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3728: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3729: FND_MSG_PUB.ADD;
3730: END IF;

Line 3727: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

3723: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then
3724: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3727: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3728: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3729: FND_MSG_PUB.ADD;
3730: END IF;
3731: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3728: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

3724: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3727: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3728: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3729: FND_MSG_PUB.ADD;
3730: END IF;
3731: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3732: End If;

Line 3735: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3731: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3732: End If;
3733: Else
3734: -- Invalid Territory Id specified
3735: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3736: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3737: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3738: FND_MSG_PUB.ADD;
3739: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3736: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

3732: End If;
3733: Else
3734: -- Invalid Territory Id specified
3735: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3736: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3737: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3738: FND_MSG_PUB.ADD;
3739: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3740: End If;

Line 3737: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

3733: Else
3734: -- Invalid Territory Id specified
3735: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3736: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3737: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3738: FND_MSG_PUB.ADD;
3739: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3740: End If;
3741:

Line 3746: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3742: --Check last update login
3743: If ( p_TerrRsc_Rec.RESOURCE_TYPE is NULL OR
3744: p_TerrRsc_Rec.RESOURCE_TYPE = FND_API.G_MISS_CHAR ) THEN
3745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3746: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3747: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );
3748: FND_MSG_PUB.ADD;
3749: END IF;
3750: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3747: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );

3743: If ( p_TerrRsc_Rec.RESOURCE_TYPE is NULL OR
3744: p_TerrRsc_Rec.RESOURCE_TYPE = FND_API.G_MISS_CHAR ) THEN
3745: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3746: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3747: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );
3748: FND_MSG_PUB.ADD;
3749: END IF;
3750: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3751: End If;

Line 3757: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3753: --Check created by
3754: IF ( p_TerrRsc_Rec.CREATED_BY is NULL OR
3755: p_TerrRsc_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3757: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3758: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3759: FND_MSG_PUB.ADD;
3760: END IF;
3761: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3758: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );

3754: IF ( p_TerrRsc_Rec.CREATED_BY is NULL OR
3755: p_TerrRsc_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3757: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3758: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3759: FND_MSG_PUB.ADD;
3760: END IF;
3761: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3762: End If;

Line 3768: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3764: --Check creation date
3765: If ( p_TerrRsc_Rec.CREATION_DATE is NULL OR
3766: p_TerrRsc_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3768: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3769: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3770: FND_MSG_PUB.ADD;
3771: END IF;
3772: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3769: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );

3765: If ( p_TerrRsc_Rec.CREATION_DATE is NULL OR
3766: p_TerrRsc_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3767: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3768: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3769: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3770: FND_MSG_PUB.ADD;
3771: END IF;
3772: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3773: End If;

Line 3779: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3775: -- Validate last updated by
3776: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
3777: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3779: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3780: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3781: FND_MSG_PUB.ADD;
3782: END IF;
3783: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3780: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );

3776: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
3777: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3779: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3780: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3781: FND_MSG_PUB.ADD;
3782: END IF;
3783: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3784: End If;

Line 3790: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3786: -- Check last update date
3787: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
3788: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3789: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3790: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3791: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3792: FND_MSG_PUB.ADD;
3793: END IF;
3794: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3791: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );

3787: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
3788: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3789: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3790: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3791: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3792: FND_MSG_PUB.ADD;
3793: END IF;
3794: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3795: End If;

Line 3801: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3797: --Check last update login
3798: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
3799: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3800: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3801: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3802: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3803: FND_MSG_PUB.ADD;
3804: END IF;
3805: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3802: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );

3798: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
3799: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3800: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3801: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3802: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3803: FND_MSG_PUB.ADD;
3804: END IF;
3805: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3806: End If;

Line 3880: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3876: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3877: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC') <> FND_API.G_TRUE Then
3878: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3880: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3881: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3882: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3883: FND_MSG_PUB.ADD;
3884: END IF;

Line 3881: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');

3877: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC') <> FND_API.G_TRUE Then
3878: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3880: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3881: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3882: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3883: FND_MSG_PUB.ADD;
3884: END IF;
3885: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3882: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');

3878: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3880: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3881: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3882: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3883: FND_MSG_PUB.ADD;
3884: END IF;
3885: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3886: End If;

Line 3889: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3885: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3886: End If;
3887: Else
3888: -- Invalid Territory Id specified
3889: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3890: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3891: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3892: FND_MSG_PUB.ADD;
3893: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3890: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');

3886: End If;
3887: Else
3888: -- Invalid Territory Id specified
3889: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3890: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3891: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3892: FND_MSG_PUB.ADD;
3893: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3894: End If;

Line 3891: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');

3887: Else
3888: -- Invalid Territory Id specified
3889: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3890: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3891: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3892: FND_MSG_PUB.ADD;
3893: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3894: End If;
3895:

Line 3905: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');

3901:
3902: EXCEPTION
3903: WHEN NO_DATA_FOUND THEN
3904: -- Invalid Territory Id specified
3905: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3906: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3907: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3908: FND_MSG_PUB.ADD;
3909: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3906: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');

3902: EXCEPTION
3903: WHEN NO_DATA_FOUND THEN
3904: -- Invalid Territory Id specified
3905: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3906: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3907: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3908: FND_MSG_PUB.ADD;
3909: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3910: END;

Line 3907: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');

3903: WHEN NO_DATA_FOUND THEN
3904: -- Invalid Territory Id specified
3905: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3906: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3907: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3908: FND_MSG_PUB.ADD;
3909: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3910: END;
3911:

Line 3916: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3912: --Check created by
3913: IF ( p_TerrRsc_Access_Rec.CREATED_BY is NULL OR
3914: p_TerrRsc_Access_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3916: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3917: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3918: FND_MSG_PUB.ADD;
3919: END IF;
3920: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3917: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );

3913: IF ( p_TerrRsc_Access_Rec.CREATED_BY is NULL OR
3914: p_TerrRsc_Access_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3915: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3916: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3917: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3918: FND_MSG_PUB.ADD;
3919: END IF;
3920: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3921: End If;

Line 3927: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3923: --Check creation date
3924: If ( p_TerrRsc_Access_Rec.CREATION_DATE is NULL OR
3925: p_TerrRsc_Access_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3927: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3928: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3929: FND_MSG_PUB.ADD;
3930: END IF;
3931: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3928: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );

3924: If ( p_TerrRsc_Access_Rec.CREATION_DATE is NULL OR
3925: p_TerrRsc_Access_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3926: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3927: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3928: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3929: FND_MSG_PUB.ADD;
3930: END IF;
3931: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3932: End If;

Line 3938: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3934: -- Validate last updated by
3935: IF ( p_TerrRsc_Access_Rec.LAST_UPDATED_BY is NULL OR
3936: p_TerrRsc_Access_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3938: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3939: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3940: FND_MSG_PUB.ADD;
3941: END IF;
3942: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3939: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );

3935: IF ( p_TerrRsc_Access_Rec.LAST_UPDATED_BY is NULL OR
3936: p_TerrRsc_Access_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3937: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3938: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3939: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3940: FND_MSG_PUB.ADD;
3941: END IF;
3942: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3943: End If;

Line 3949: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3945: -- Check last update date
3946: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_DATE IS NULL OR
3947: p_TerrRsc_Access_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3949: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3950: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3951: FND_MSG_PUB.ADD;
3952: END IF;
3953: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3950: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );

3946: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_DATE IS NULL OR
3947: p_TerrRsc_Access_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3949: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3950: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3951: FND_MSG_PUB.ADD;
3952: END IF;
3953: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3954: End If;

Line 3960: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');

3956: --Check last update login
3957: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN is NULL OR
3958: p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3960: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3961: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3962: FND_MSG_PUB.ADD;
3963: END IF;
3964: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3961: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );

3957: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN is NULL OR
3958: p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3960: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3961: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3962: FND_MSG_PUB.ADD;
3963: END IF;
3964: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3965: End If;

Line 4573: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');

4569:
4570: -- Debug Message
4571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4572: THEN
4573: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4574: fnd_message.set_name ('PROC_NAME', l_api_name);
4575: FND_MSG_PUB.Add;
4576: END IF;
4577:

Line 4574: fnd_message.set_name ('PROC_NAME', l_api_name);

4570: -- Debug Message
4571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4572: THEN
4573: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4574: fnd_message.set_name ('PROC_NAME', l_api_name);
4575: FND_MSG_PUB.Add;
4576: END IF;
4577:
4578: -- Initialize API return status to success

Line 4628: fnd_message.set_name('JTF', 'JTF_ERROR_TERRRSC_API');

4624: dbms_output.put_line(
4625: 'Unexpected Execution Error from call to Create Terr Resource API');
4626: */
4627:
4628: fnd_message.set_name('JTF', 'JTF_ERROR_TERRRSC_API');
4629: fnd_msg_pub.add;
4630: RAISE fnd_api.g_exc_unexpected_error;
4631:
4632: END IF;

Line 4674: fnd_message.set_name('JTF', 'JTF_ERROR_TERRRSCACCESS_API');

4670: /*
4671: dbms_output.put_line(
4672: 'Unexpected Execution Error from call to Create Terr Resource Access API');
4673: */
4674: fnd_message.set_name('JTF', 'JTF_ERROR_TERRRSCACCESS_API');
4675: fnd_msg_pub.add;
4676: RAISE fnd_api.g_exc_unexpected_error;
4677: END IF;
4678:

Line 4779: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_RSC_ACCESS_UK_CON');

4775:
4776: /* Debug message */
4777: --arpatel bug#1500581 (part of fix)
4778: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4779: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_RSC_ACCESS_UK_CON');
4780: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');
4781: FND_MSG_PUB.ADD;
4782: --END IF;
4783:

Line 4780: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');

4776: /* Debug message */
4777: --arpatel bug#1500581 (part of fix)
4778: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4779: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_RSC_ACCESS_UK_CON');
4780: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');
4781: FND_MSG_PUB.ADD;
4782: --END IF;
4783:
4784: END IF; /* c_chk_uk_violation%FOUND */

Line 4797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');

4793:
4794: WHEN OTHERS THEN
4795: --dbms_output('Validate_Foreign_Key: Others exception' || SQLERRM);
4796: X_return_status := FND_API.G_RET_STS_ERROR;
4797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4798: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );
4799: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
4800: FND_MSG_PUB.ADD;
4801: FND_MSG_PUB.Count_And_Get

Line 4798: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );

4794: WHEN OTHERS THEN
4795: --dbms_output('Validate_Foreign_Key: Others exception' || SQLERRM);
4796: X_return_status := FND_API.G_RET_STS_ERROR;
4797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4798: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );
4799: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
4800: FND_MSG_PUB.ADD;
4801: FND_MSG_PUB.Count_And_Get
4802: ( p_count => x_msg_count,

Line 4799: FND_MESSAGE.Set_Token('ERROR', sqlerrm );

4795: --dbms_output('Validate_Foreign_Key: Others exception' || SQLERRM);
4796: X_return_status := FND_API.G_RET_STS_ERROR;
4797: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4798: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );
4799: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
4800: FND_MSG_PUB.ADD;
4801: FND_MSG_PUB.Count_And_Get
4802: ( p_count => x_msg_count,
4803: p_data => x_msg_data

Line 4919: fnd_message.set_name ('JTF', 'JTF_TERRITORY_START_MSG');

4915:
4916: -- Debug Message
4917: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4918: THEN
4919: fnd_message.set_name ('JTF', 'JTF_TERRITORY_START_MSG');
4920: fnd_message.set_name ('PROC_NAME', l_api_name);
4921: FND_MSG_PUB.Add;
4922: END IF;
4923:

Line 4920: fnd_message.set_name ('PROC_NAME', l_api_name);

4916: -- Debug Message
4917: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4918: THEN
4919: fnd_message.set_name ('JTF', 'JTF_TERRITORY_START_MSG');
4920: fnd_message.set_name ('PROC_NAME', l_api_name);
4921: FND_MSG_PUB.Add;
4922: END IF;
4923:
4924: -- Initialize API return status to success

Line 5172: fnd_message.set_name ('JTF', 'JTF_TERRITORY_END_MSG');

5168:
5169: -- Debug Message
5170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
5171: THEN
5172: fnd_message.set_name ('JTF', 'JTF_TERRITORY_END_MSG');
5173: fnd_message.set_name ('PROC_NAME', l_api_name);
5174: FND_MSG_PUB.Add;
5175: END IF;
5176:

Line 5173: fnd_message.set_name ('PROC_NAME', l_api_name);

5169: -- Debug Message
5170: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
5171: THEN
5172: fnd_message.set_name ('JTF', 'JTF_TERRITORY_END_MSG');
5173: fnd_message.set_name ('PROC_NAME', l_api_name);
5174: FND_MSG_PUB.Add;
5175: END IF;
5176:
5177: FND_MSG_PUB.Count_And_Get