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 177: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');

173:
174: if l_temp = 'X' then
175: fnd_msg_pub.initialize;
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
178: FND_MSG_PUB.ADD;
179: FND_MSG_PUB.Count_And_Get( P_count => x_msg_count,
180: P_data => x_msg_data);
181: end if;

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

251:
252: if l_temp = 'X' then
253: fnd_msg_pub.initialize;
254: x_return_status := FND_API.G_RET_STS_ERROR ;
255: fnd_message.set_name('JTF', 'JTF_TERR_DUPLICATE_RESOURCE');
256: FND_MSG_PUB.ADD;
257: FND_MSG_PUB.Count_And_Get ( P_count => x_msg_count, P_data => x_msg_data);
258: end if;
259:

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

421:
422: -- Debug Message
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
424: THEN
425: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
426: fnd_message.set_name ('PROC_NAME', l_api_name);
427: FND_MSG_PUB.Add;
428: END IF;
429:

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

422: -- Debug Message
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
424: THEN
425: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
426: fnd_message.set_name ('PROC_NAME', l_api_name);
427: FND_MSG_PUB.Add;
428: END IF;
429:
430: -- Initialize API return status to success

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

467: --
468: -- Debug Message
469: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
470: THEN
471: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
472: fnd_message.set_name ('PROC_NAME', l_api_name);
473: fnd_msg_pub.add;
474: END IF;
475:

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

468: -- Debug Message
469: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_debug_low)
470: THEN
471: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
472: fnd_message.set_name ('PROC_NAME', l_api_name);
473: fnd_msg_pub.add;
474: END IF;
475:
476: -- Standard check for p_commit

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

616:
617: -- Debug Message
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
619: THEN
620: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
621: fnd_message.set_name ('PROC_NAME', l_api_name);
622: FND_MSG_PUB.Add;
623: END IF;
624:

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

617: -- Debug Message
618: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
619: THEN
620: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
621: fnd_message.set_name ('PROC_NAME', l_api_name);
622: FND_MSG_PUB.Add;
623: END IF;
624:
625: -- Initialize API return status to success

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

815:
816: -- Debug Message
817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
818: THEN
819: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
820: fnd_message.set_name ('PROC_NAME', l_api_name);
821: FND_MSG_PUB.Add;
822: END IF;
823:

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

816: -- Debug Message
817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
818: THEN
819: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
820: fnd_message.set_name ('PROC_NAME', l_api_name);
821: FND_MSG_PUB.Add;
822: END IF;
823:
824:

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

953:
954: -- Debug Message
955: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
956: THEN
957: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
958: fnd_message.set_name ('PROC_NAME', l_api_name);
959: FND_MSG_PUB.Add;
960: END IF;
961:

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

954: -- Debug Message
955: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
956: THEN
957: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
958: fnd_message.set_name ('PROC_NAME', l_api_name);
959: FND_MSG_PUB.Add;
960: END IF;
961:
962: -- Initialize API return status to success

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

1001:
1002: -- Debug Message
1003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1004: THEN
1005: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1006: fnd_message.set_name ('PROC_NAME', l_api_name);
1007: FND_MSG_PUB.Add;
1008: END IF;
1009:

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

1002: -- Debug Message
1003: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1004: THEN
1005: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1006: fnd_message.set_name ('PROC_NAME', l_api_name);
1007: FND_MSG_PUB.Add;
1008: END IF;
1009:
1010:

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

1141:
1142: -- Debug Message
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1144: THEN
1145: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1146: fnd_message.set_name ('PROC_NAME', l_api_name);
1147: FND_MSG_PUB.Add;
1148: END IF;
1149:

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

1142: -- Debug Message
1143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1144: THEN
1145: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1146: fnd_message.set_name ('PROC_NAME', l_api_name);
1147: FND_MSG_PUB.Add;
1148: END IF;
1149:
1150:

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

1194:
1195: -- Debug Message
1196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1197: THEN
1198: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1199: fnd_message.set_name ('PROC_NAME', l_api_name);
1200: FND_MSG_PUB.Add;
1201: END IF;
1202:

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

1195: -- Debug Message
1196: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1197: THEN
1198: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1199: fnd_message.set_name ('PROC_NAME', l_api_name);
1200: FND_MSG_PUB.Add;
1201: END IF;
1202:
1203:

Line 1295: fnd_message.set_name('JTF', 'JTY_TERR_INVALID_RESOURCE');

1291: EXECUTE IMMEDIATE l_rsc_validate_sql INTO l_temp;
1292: EXCEPTION
1293: WHEN NO_DATA_FOUND THEN
1294: x_return_status := FND_API.G_RET_STS_ERROR ;
1295: fnd_message.set_name('JTF', 'JTY_TERR_INVALID_RESOURCE');
1296: FND_MSG_PUB.ADD;
1297: END;
1298: --
1299: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1416: fnd_message.set_name('JTF', 'JTY_TERR_INVALID_RESOURCE');

1412: EXECUTE IMMEDIATE l_rsc_validate_sql INTO l_temp;
1413: EXCEPTION
1414: WHEN NO_DATA_FOUND THEN
1415: x_return_status := FND_API.G_RET_STS_ERROR ;
1416: fnd_message.set_name('JTF', 'JTY_TERR_INVALID_RESOURCE');
1417: FND_MSG_PUB.ADD;
1418: END;
1419: --
1420: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

1492:
1493: -- Debug Message
1494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1495: THEN
1496: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1497: fnd_message.set_name ('PROC_NAME', l_api_name);
1498: FND_MSG_PUB.Add;
1499: END IF;
1500:

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

1493: -- Debug Message
1494: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1495: THEN
1496: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1497: fnd_message.set_name ('PROC_NAME', l_api_name);
1498: FND_MSG_PUB.Add;
1499: END IF;
1500:
1501: -- Initialize API return status to success

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

1506:
1507: -- Debug message
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1509: THEN
1510: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1511: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
1512: FND_MSG_PUB.Add;
1513: END IF;
1514: --

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

1507: -- Debug message
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1509: THEN
1510: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1511: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
1512: FND_MSG_PUB.Add;
1513: END IF;
1514: --
1515: -- Invoke validation procedures

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

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

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

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

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

1682:
1683: -- Debug Message
1684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1685: THEN
1686: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1687: fnd_message.set_name ('PROC_NAME', l_api_name);
1688: FND_MSG_PUB.Add;
1689: END IF;
1690:

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

1683: -- Debug Message
1684: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1685: THEN
1686: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1687: fnd_message.set_name ('PROC_NAME', l_api_name);
1688: FND_MSG_PUB.Add;
1689: END IF;
1690:
1691: -- Initialize API return status to success

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

1745:
1746: -- Debug Message
1747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1748: THEN
1749: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1750: fnd_message.set_name ('PROC_NAME', l_api_name);
1751: FND_MSG_PUB.Add;
1752: END IF;
1753: --dbms_output.put_line('Create_Terr_Resource TBL: Exiting API');

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

1746: -- Debug Message
1747: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1748: THEN
1749: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1750: fnd_message.set_name ('PROC_NAME', l_api_name);
1751: FND_MSG_PUB.Add;
1752: END IF;
1753: --dbms_output.put_line('Create_Terr_Resource TBL: Exiting API');
1754: --

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

1803:
1804: -- Debug Message
1805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1806: THEN
1807: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1808: fnd_message.set_name ('PROC_NAME', l_api_name);
1809: FND_MSG_PUB.Add;
1810: END IF;
1811:

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

1804: -- Debug Message
1805: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1806: THEN
1807: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
1808: fnd_message.set_name ('PROC_NAME', l_api_name);
1809: FND_MSG_PUB.Add;
1810: END IF;
1811:
1812: -- Initialize API return status to success

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

1817: THEN
1818: -- Debug message
1819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1820: THEN
1821: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1822: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
1823: FND_MSG_PUB.Add;
1824: END IF;
1825: --Check created by

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

1818: -- Debug message
1819: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1820: THEN
1821: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
1822: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
1823: FND_MSG_PUB.Add;
1824: END IF;
1825: --Check created by
1826: IF ( p_TerrRsc_Access_Rec.CREATED_BY is NULL OR

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

1825: --Check created by
1826: IF ( p_TerrRsc_Access_Rec.CREATED_BY is NULL OR
1827: p_TerrRsc_Access_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
1828: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1829: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1830: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
1831: FND_MSG_PUB.ADD;
1832: END IF;
1833: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

1826: IF ( p_TerrRsc_Access_Rec.CREATED_BY is NULL OR
1827: p_TerrRsc_Access_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
1828: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1829: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1830: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
1831: FND_MSG_PUB.ADD;
1832: END IF;
1833: x_Return_Status := FND_API.G_RET_STS_ERROR ;
1834: End If;

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

1836: --Check creation date
1837: If ( p_TerrRsc_Access_Rec.CREATION_DATE is NULL OR
1838: p_TerrRsc_Access_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
1839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1840: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1841: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
1842: FND_MSG_PUB.ADD;
1843: END IF;
1844: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

1837: If ( p_TerrRsc_Access_Rec.CREATION_DATE is NULL OR
1838: p_TerrRsc_Access_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
1839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1840: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1841: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
1842: FND_MSG_PUB.ADD;
1843: END IF;
1844: x_Return_Status := FND_API.G_RET_STS_ERROR ;
1845: End If;

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

1847: --Check ACCESS_TYPE
1848: IF ( p_TerrRsc_Access_Rec.ACCESS_TYPE is NULL OR
1849: p_TerrRsc_Access_Rec.ACCESS_TYPE = FND_API.G_MISS_CHAR ) THEN
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1851: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1852: FND_MESSAGE.Set_Token('COL_NAME', 'ACCESS_TYPE' );
1853: FND_MSG_PUB.ADD;
1854: END IF;
1855: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 1852: FND_MESSAGE.Set_Token('COL_NAME', 'ACCESS_TYPE' );

1848: IF ( p_TerrRsc_Access_Rec.ACCESS_TYPE is NULL OR
1849: p_TerrRsc_Access_Rec.ACCESS_TYPE = FND_API.G_MISS_CHAR ) THEN
1850: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1851: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1852: FND_MESSAGE.Set_Token('COL_NAME', 'ACCESS_TYPE' );
1853: FND_MSG_PUB.ADD;
1854: END IF;
1855: x_Return_Status := FND_API.G_RET_STS_ERROR ;
1856: End If;

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

1858: --Check TRANS_ACCESS_CODE
1859: IF ( p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE is NULL OR
1860: p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE = FND_API.G_MISS_CHAR ) THEN
1861: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1862: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1863: FND_MESSAGE.Set_Token('COL_NAME', 'TRANS_ACCESS_CODE' );
1864: FND_MSG_PUB.ADD;
1865: END IF;
1866: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 1863: FND_MESSAGE.Set_Token('COL_NAME', 'TRANS_ACCESS_CODE' );

1859: IF ( p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE is NULL OR
1860: p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE = FND_API.G_MISS_CHAR ) THEN
1861: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1862: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
1863: FND_MESSAGE.Set_Token('COL_NAME', 'TRANS_ACCESS_CODE' );
1864: FND_MSG_PUB.ADD;
1865: END IF;
1866: x_Return_Status := FND_API.G_RET_STS_ERROR ;
1867: End If;

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

1925:
1926: -- Debug Message
1927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1928: THEN
1929: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1930: fnd_message.set_name ('PROC_NAME', l_api_name);
1931: FND_MSG_PUB.Add;
1932: END IF;
1933:

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

1926: -- Debug Message
1927: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1928: THEN
1929: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
1930: fnd_message.set_name ('PROC_NAME', l_api_name);
1931: FND_MSG_PUB.Add;
1932: END IF;
1933:
1934: --dbms_output.put_line('Create_Resource _Access REC: Exiting API');

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

2024:
2025: -- Debug Message
2026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2027: THEN
2028: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2029: fnd_message.set_name ('PROC_NAME', l_api_name);
2030: FND_MSG_PUB.Add;
2031: END IF;
2032:

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

2025: -- Debug Message
2026: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2027: THEN
2028: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2029: fnd_message.set_name ('PROC_NAME', l_api_name);
2030: FND_MSG_PUB.Add;
2031: END IF;
2032:
2033:

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

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

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

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

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

2160:
2161: -- Debug Message
2162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2163: THEN
2164: FND_MESSAGE.Set_Name('JTF', 'Delete TerrRscAccess : Start');
2165: FND_MSG_PUB.Add;
2166: END IF;
2167:
2168: --Initialize the return status to success

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

2170: --
2171: JTF_TERR_RSC_ACCESS_PKG.Delete_Row(x_TERR_RSC_ACCESS_ID => P_TerrRsc_Access_Id );
2172: --
2173: --Prepare message name
2174: FND_MESSAGE.SET_NAME('JTF','TERR_RSCACCESSES_DELETED');
2175:
2176: IF SQL%FOUND THEN
2177: x_return_status := FND_API.G_RET_STS_SUCCESS;
2178: l_row_count := SQL%ROWCOUNT;

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

2178: l_row_count := SQL%ROWCOUNT;
2179: END IF;
2180:
2181: --Prepare message token
2182: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);
2183: --Add message to API message list
2184: FND_MSG_PUB.ADD();
2185:
2186: -- Debug Message

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

2185:
2186: -- Debug Message
2187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2188: THEN
2189: FND_MESSAGE.Set_Name('JTF', 'Delete TerrRscAccess: End');
2190: FND_MSG_PUB.Add;
2191: END IF;
2192:
2193:

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

2206: WHEN NO_DATA_FOUND THEN
2207: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2208: l_row_count := 0;
2209: --Prepare message token
2210: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);
2211: --Add message to API message list
2212: FND_MSG_PUB.ADD();
2213: --
2214: FND_MSG_PUB.Count_And_Get

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

2298:
2299: -- Debug Message
2300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2301: THEN
2302: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2303: fnd_message.set_name ('PROC_NAME', l_api_name);
2304: FND_MSG_PUB.Add;
2305: END IF;
2306:

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

2299: -- Debug Message
2300: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2301: THEN
2302: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
2303: fnd_message.set_name ('PROC_NAME', l_api_name);
2304: FND_MSG_PUB.Add;
2305: END IF;
2306:
2307: --Initialize the return status to success

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

2309: --
2310: JTF_TERR_RSC_PKG.Delete_Row(x_TERR_RSC_ID => P_TerrRsc_Id);
2311: --
2312: --Prepare message name
2313: FND_MESSAGE.SET_NAME('JTF','TERR_RESOURCE_DELETED');
2314:
2315: IF SQL%FOUND THEN
2316: x_return_status := FND_API.G_RET_STS_SUCCESS;
2317: l_row_count := SQL%ROWCOUNT;

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

2317: l_row_count := SQL%ROWCOUNT;
2318: END IF;
2319:
2320: --Prepare message token
2321: FND_MESSAGE.SET_TOKEN('ITEMS_DELETED', l_row_count);
2322:
2323: --Add message to API message list
2324: FND_MSG_PUB.ADD();
2325:

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

2325:
2326: -- Debug Message
2327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2328: THEN
2329: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2330: fnd_message.set_name ('PROC_NAME', l_api_name);
2331: FND_MSG_PUB.Add;
2332: END IF;
2333:

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

2326: -- Debug Message
2327: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2328: THEN
2329: fnd_message.set_name ('JTF', 'JTF_TERR_END_MSG');
2330: fnd_message.set_name ('PROC_NAME', l_api_name);
2331: FND_MSG_PUB.Add;
2332: END IF;
2333:
2334:

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

2349: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2350: l_row_count := 0;
2351:
2352: --Prepare message token
2353: FND_MESSAGE.SET_NAME('ITEMS_DELETED', l_row_count);
2354:
2355: --Add message to API message list
2356: FND_MSG_PUB.ADD();
2357: --

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

2415: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
2416: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2417: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2419: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2420: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
2421: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
2422: FND_MSG_PUB.ADD;
2423: END IF;

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

2416: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2417: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2419: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2420: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
2421: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
2422: FND_MSG_PUB.ADD;
2423: END IF;
2424: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

2417: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2419: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2420: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
2421: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
2422: FND_MSG_PUB.ADD;
2423: END IF;
2424: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2425: End If;

Line 2466: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_INV_DATE_RANGE');

2462:
2463: IF (l_res_start_date_active IS NOT NULL ) AND (l_res_end_date_active IS NOT NULL ) THEN
2464: IF ( l_res_start_date_active > l_res_end_date_active ) THEN
2465: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2466: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_INV_DATE_RANGE');
2467: FND_MSG_PUB.ADD;
2468: END IF;
2469: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2470: END IF;

Line 2483: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_STARTDATE_NOT_VALID');

2479:
2480: -- Validate start date .
2481: IF ( l_res_start_date_active < l_terr_start_date ) OR ( l_res_start_date_active > l_terr_end_date ) THEN
2482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2483: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_STARTDATE_NOT_VALID');
2484: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
2485: FND_MSG_PUB.ADD;
2486: END IF;
2487: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 2484: FND_MESSAGE.Set_Token('RES_NAME', ' ' );

2480: -- Validate start date .
2481: IF ( l_res_start_date_active < l_terr_start_date ) OR ( l_res_start_date_active > l_terr_end_date ) THEN
2482: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2483: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_STARTDATE_NOT_VALID');
2484: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
2485: FND_MSG_PUB.ADD;
2486: END IF;
2487: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2488: END IF;

Line 2493: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_ENDDATE_NOT_VALID');

2489:
2490: -- Validate end date.
2491: IF ( l_res_end_date_active < l_terr_start_date ) OR ( l_res_end_date_active > l_terr_end_date ) THEN
2492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2493: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_ENDDATE_NOT_VALID');
2494: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
2495: FND_MSG_PUB.ADD;
2496: END IF;
2497: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 2494: FND_MESSAGE.Set_Token('RES_NAME', ' ' );

2490: -- Validate end date.
2491: IF ( l_res_end_date_active < l_terr_start_date ) OR ( l_res_end_date_active > l_terr_end_date ) THEN
2492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2493: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_ENDDATE_NOT_VALID');
2494: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
2495: FND_MSG_PUB.ADD;
2496: END IF;
2497: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2498: END IF;

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

2510: -- Validate last updated by
2511: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
2512: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
2513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2514: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
2515: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
2516: FND_MSG_PUB.ADD;
2517: END IF;
2518: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

2511: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
2512: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
2513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2514: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
2515: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
2516: FND_MSG_PUB.ADD;
2517: END IF;
2518: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2519: End If;

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

2521: -- Check last update date
2522: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
2523: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2525: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
2526: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
2527: FND_MSG_PUB.ADD;
2528: END IF;
2529: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

2522: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
2523: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
2524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2525: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
2526: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
2527: FND_MSG_PUB.ADD;
2528: END IF;
2529: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2530: End If;

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

2532: --Check last update login
2533: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
2534: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
2535: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2536: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
2537: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
2538: FND_MSG_PUB.ADD;
2539: END IF;
2540: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

2533: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
2534: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
2535: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2536: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
2537: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
2538: FND_MSG_PUB.ADD;
2539: END IF;
2540: x_Return_Status := FND_API.G_RET_STS_ERROR ;
2541: End If;

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

2640: l_ref_TerrRsc_Rec.ORG_ID;
2641:
2642: If (C_GetTerrResource%NOTFOUND) Then
2643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2644: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2645: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
2646: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));
2647: FND_MSG_PUB.Add;
2648: END IF;

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

2641:
2642: If (C_GetTerrResource%NOTFOUND) Then
2643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2644: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2645: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
2646: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));
2647: FND_MSG_PUB.Add;
2648: END IF;
2649: raise FND_API.G_EXC_ERROR;

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

2642: If (C_GetTerrResource%NOTFOUND) Then
2643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2644: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2645: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
2646: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Rec.TERR_RSC_ID));
2647: FND_MSG_PUB.Add;
2648: END IF;
2649: raise FND_API.G_EXC_ERROR;
2650: End if;

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

2652:
2653: --Validate the incomming record
2654: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
2655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2656: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2657: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
2658: FND_MSG_PUB.Add;
2659: END IF;
2660:

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

2653: --Validate the incomming record
2654: IF ( P_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
2655: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2656: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2657: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc');
2658: FND_MSG_PUB.Add;
2659: END IF;
2660:
2661: -- Invoke validation procedures

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

2933: THEN
2934: -- Debug message
2935: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2936: THEN
2937: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2938: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
2939: FND_MSG_PUB.Add;
2940: END IF;
2941: --

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

2934: -- Debug message
2935: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
2936: THEN
2937: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_VALIDATE_MSG');
2938: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Terr_Rsc_Access');
2939: FND_MSG_PUB.Add;
2940: END IF;
2941: --
2942: -- Invoke validation procedures

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

2971: If ( C_GetTerrResAccess%NOTFOUND) Then
2972: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2973: THEN
2974: --dbms_output.put_line('Update_Resource_Access REC: DATA-NOT-FOUND');
2975: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2976: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');
2977: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));
2978: FND_MSG_PUB.Add;
2979: END IF;

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

2972: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2973: THEN
2974: --dbms_output.put_line('Update_Resource_Access REC: DATA-NOT-FOUND');
2975: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2976: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');
2977: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));
2978: FND_MSG_PUB.Add;
2979: END IF;
2980: raise FND_API.G_EXC_ERROR;

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

2973: THEN
2974: --dbms_output.put_line('Update_Resource_Access REC: DATA-NOT-FOUND');
2975: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
2976: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC_ACCESS');
2977: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_TerrRsc_Access_Rec.TERR_RSC_ACCESS_ID));
2978: FND_MSG_PUB.Add;
2979: END IF;
2980: raise FND_API.G_EXC_ERROR;
2981: End if;

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

3217: --
3218: WHEN NO_DATA_FOUND THEN
3219: --dbms_output.put_line('Validate_Foreign_Keys: NO_DATA_FOUND');
3220: x_return_status := FND_API.G_RET_STS_ERROR ;
3221: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');
3222: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );
3223: FND_MSG_PUB.ADD;
3224: FND_MSG_PUB.Count_And_Get
3225: ( P_count => x_msg_count,

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

3218: WHEN NO_DATA_FOUND THEN
3219: --dbms_output.put_line('Validate_Foreign_Keys: NO_DATA_FOUND');
3220: x_return_status := FND_API.G_RET_STS_ERROR ;
3221: fnd_message.set_name('JTF', 'JTF_TERR_INVALID_TERRITORY');
3222: fnd_message.Set_Token('TERR_ID', to_char(l_Terr_Id) );
3223: FND_MSG_PUB.ADD;
3224: FND_MSG_PUB.Count_And_Get
3225: ( P_count => x_msg_count,
3226: P_data => x_msg_data

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

3295:
3296: -- Cannot have more than one Primary flag
3297: If l_Primary_Count > 1 Then
3298: --
3299: fnd_message.set_name('JTF', 'JTF_TERR_MULTIPLE_PRIMARY_FLAG');
3300: FND_MSG_PUB.ADD;
3301: raise FND_API.G_EXC_ERROR;
3302: --
3303: End If;

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

3391: */
3392: -- If the territory resource records is missing
3393: If (p_TerrRsc_Tbl.count = 0 ) Then
3394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3395: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_TERRRES_REC');
3396: FND_MSG_PUB.ADD;
3397: END IF;
3398: x_return_status := FND_API.G_RET_STS_ERROR;
3399: raise FND_API.G_EXC_ERROR;

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

3490: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3491: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
3492: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3494: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3495: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3496: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3497: FND_MSG_PUB.ADD;
3498: END IF;

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

3491: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
3492: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3494: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3495: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3496: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3492: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3494: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3495: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
3496: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');
3497: FND_MSG_PUB.ADD;
3498: END IF;
3499: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3500: End If;

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

3500: End If;
3501: Else
3502: -- Invalid Territory Id specified
3503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3504: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3505: FND_MESSAGE.Set_Token('COL_NAME', 'TERR_ID' );
3506: FND_MSG_PUB.ADD;
3507: END IF;
3508: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3505: FND_MESSAGE.Set_Token('COL_NAME', 'TERR_ID' );

3501: Else
3502: -- Invalid Territory Id specified
3503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3504: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3505: FND_MESSAGE.Set_Token('COL_NAME', 'TERR_ID' );
3506: FND_MSG_PUB.ADD;
3507: END IF;
3508: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3509: End If;

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

3511: --Check created by
3512: IF ( p_TerrRsc_Rec.CREATED_BY is NULL OR
3513: p_TerrRsc_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3515: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3516: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3517: FND_MSG_PUB.ADD;
3518: END IF;
3519: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3512: IF ( p_TerrRsc_Rec.CREATED_BY is NULL OR
3513: p_TerrRsc_Rec.CREATED_BY = FND_API.G_MISS_NUM ) THEN
3514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3515: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3516: FND_MESSAGE.Set_Token('COL_NAME', 'CREATED_BY' );
3517: FND_MSG_PUB.ADD;
3518: END IF;
3519: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3520: End If;

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

3521: --Check creation date
3522: If ( p_TerrRsc_Rec.CREATION_DATE is NULL OR
3523: p_TerrRsc_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3525: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3526: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3527: FND_MSG_PUB.ADD;
3528: END IF;
3529: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3522: If ( p_TerrRsc_Rec.CREATION_DATE is NULL OR
3523: p_TerrRsc_Rec.CREATION_DATE = FND_API.G_MISS_DATE ) THEN
3524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3525: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3526: FND_MESSAGE.Set_Token('COL_NAME', 'CREATION_DATE' );
3527: FND_MSG_PUB.ADD;
3528: END IF;
3529: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3530: End If;

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

3531: --Check ORG_ID
3532: If ( p_TerrRsc_Rec.ORG_ID is NULL OR
3533: p_TerrRsc_Rec.ORG_ID = FND_API.G_MISS_NUM ) THEN
3534: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3535: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3536: FND_MESSAGE.Set_Token('COL_NAME', 'ORG_ID' );
3537: FND_MSG_PUB.ADD;
3538: END IF;
3539: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3536: FND_MESSAGE.Set_Token('COL_NAME', 'ORG_ID' );

3532: If ( p_TerrRsc_Rec.ORG_ID is NULL OR
3533: p_TerrRsc_Rec.ORG_ID = FND_API.G_MISS_NUM ) THEN
3534: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3535: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3536: FND_MESSAGE.Set_Token('COL_NAME', 'ORG_ID' );
3537: FND_MSG_PUB.ADD;
3538: END IF;
3539: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3540: End If;

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

3541: --Check RESOURCE_ID
3542: If ( p_TerrRsc_Rec.RESOURCE_ID is NULL OR
3543: p_TerrRsc_Rec.RESOURCE_ID = FND_API.G_MISS_NUM ) THEN
3544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3545: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3546: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_ID' );
3547: FND_MSG_PUB.ADD;
3548: END IF;
3549: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3546: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_ID' );

3542: If ( p_TerrRsc_Rec.RESOURCE_ID is NULL OR
3543: p_TerrRsc_Rec.RESOURCE_ID = FND_API.G_MISS_NUM ) THEN
3544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3545: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3546: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_ID' );
3547: FND_MSG_PUB.ADD;
3548: END IF;
3549: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3550: End If;

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

3551: --Check RESOURCE_TYPE
3552: If ( p_TerrRsc_Rec.RESOURCE_TYPE is NULL OR
3553: p_TerrRsc_Rec.RESOURCE_TYPE = FND_API.G_MISS_CHAR ) THEN
3554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3555: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3556: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );
3557: FND_MSG_PUB.ADD;
3558: END IF;
3559: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3552: If ( p_TerrRsc_Rec.RESOURCE_TYPE is NULL OR
3553: p_TerrRsc_Rec.RESOURCE_TYPE = FND_API.G_MISS_CHAR ) THEN
3554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3555: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3556: FND_MESSAGE.Set_Token('COL_NAME', 'RESOURCE_TYPE' );
3557: FND_MSG_PUB.ADD;
3558: END IF;
3559: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3560: End If;

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

3561: --Check START_DATE_ACTIVE
3562: If ( p_TerrRsc_Rec.START_DATE_ACTIVE is NULL OR
3563: p_TerrRsc_Rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) THEN
3564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3565: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3566: FND_MESSAGE.Set_Token('COL_NAME', 'START_DATE_ACTIVE' );
3567: FND_MSG_PUB.ADD;
3568: END IF;
3569: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3566: FND_MESSAGE.Set_Token('COL_NAME', 'START_DATE_ACTIVE' );

3562: If ( p_TerrRsc_Rec.START_DATE_ACTIVE is NULL OR
3563: p_TerrRsc_Rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) THEN
3564: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3565: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3566: FND_MESSAGE.Set_Token('COL_NAME', 'START_DATE_ACTIVE' );
3567: FND_MSG_PUB.ADD;
3568: END IF;
3569: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3570: End If;

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

3571: --Check END_DATE_ACTIVE
3572: If ( p_TerrRsc_Rec.END_DATE_ACTIVE is NULL OR
3573: p_TerrRsc_Rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE ) THEN
3574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3575: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3576: FND_MESSAGE.Set_Token('COL_NAME', 'END_DATE_ACTIVE' );
3577: FND_MSG_PUB.ADD;
3578: END IF;
3579: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3576: FND_MESSAGE.Set_Token('COL_NAME', 'END_DATE_ACTIVE' );

3572: If ( p_TerrRsc_Rec.END_DATE_ACTIVE is NULL OR
3573: p_TerrRsc_Rec.END_DATE_ACTIVE = FND_API.G_MISS_DATE ) THEN
3574: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3575: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3576: FND_MESSAGE.Set_Token('COL_NAME', 'END_DATE_ACTIVE' );
3577: FND_MSG_PUB.ADD;
3578: END IF;
3579: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3580: End If;

Line 3587: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_INV_DATE_RANGE');

3583: AND (p_TerrRsc_Rec.END_DATE_ACTIVE IS NOT NULL AND p_TerrRsc_Rec.END_DATE_ACTIVE <> FND_API.G_MISS_DATE ) THEN
3584:
3585: IF ( p_TerrRsc_Rec.START_DATE_ACTIVE > p_TerrRsc_Rec.END_DATE_ACTIVE ) THEN
3586: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3587: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_INV_DATE_RANGE');
3588: FND_MSG_PUB.ADD;
3589: END IF;
3590: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3591: END IF;

Line 3604: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_STARTDATE_NOT_VALID');

3600:
3601: -- Validate start date .
3602: IF ( p_TerrRsc_Rec.START_DATE_ACTIVE < l_terr_start_date ) OR ( p_TerrRsc_Rec.START_DATE_ACTIVE > l_terr_end_date ) THEN
3603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3604: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_STARTDATE_NOT_VALID');
3605: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
3606: FND_MSG_PUB.ADD;
3607: END IF;
3608: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3605: FND_MESSAGE.Set_Token('RES_NAME', ' ' );

3601: -- Validate start date .
3602: IF ( p_TerrRsc_Rec.START_DATE_ACTIVE < l_terr_start_date ) OR ( p_TerrRsc_Rec.START_DATE_ACTIVE > l_terr_end_date ) THEN
3603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3604: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_STARTDATE_NOT_VALID');
3605: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
3606: FND_MSG_PUB.ADD;
3607: END IF;
3608: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3609: END IF;

Line 3614: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_ENDDATE_NOT_VALID');

3610:
3611: -- Validate end date.
3612: IF ( p_TerrRsc_Rec.END_DATE_ACTIVE < l_terr_start_date ) OR ( p_TerrRsc_Rec.END_DATE_ACTIVE > l_terr_end_date ) THEN
3613: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3614: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_ENDDATE_NOT_VALID');
3615: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
3616: FND_MSG_PUB.ADD;
3617: END IF;
3618: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3615: FND_MESSAGE.Set_Token('RES_NAME', ' ' );

3611: -- Validate end date.
3612: IF ( p_TerrRsc_Rec.END_DATE_ACTIVE < l_terr_start_date ) OR ( p_TerrRsc_Rec.END_DATE_ACTIVE > l_terr_end_date ) THEN
3613: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3614: FND_MESSAGE.Set_Name('JTF', 'JTY_RSC_ENDDATE_NOT_VALID');
3615: FND_MESSAGE.Set_Token('RES_NAME', ' ' );
3616: FND_MSG_PUB.ADD;
3617: END IF;
3618: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3619: END IF;

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

3631: -- Validate last updated by
3632: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
3633: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3635: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3636: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3637: FND_MSG_PUB.ADD;
3638: END IF;
3639: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3632: IF ( p_TerrRsc_Rec.LAST_UPDATED_BY is NULL OR
3633: p_TerrRsc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3634: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3635: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3636: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3637: FND_MSG_PUB.ADD;
3638: END IF;
3639: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3640: End If;

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

3642: -- Check last update date
3643: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
3644: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3646: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3647: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3648: FND_MSG_PUB.ADD;
3649: END IF;
3650: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3643: If ( p_TerrRsc_Rec.LAST_UPDATE_DATE IS NULL OR
3644: p_TerrRsc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3646: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3647: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3648: FND_MSG_PUB.ADD;
3649: END IF;
3650: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3651: End If;

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

3653: --Check last update login
3654: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
3655: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3657: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3658: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3659: FND_MSG_PUB.ADD;
3660: END IF;
3661: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3654: If ( p_TerrRsc_Rec.LAST_UPDATE_LOGIN is NULL OR
3655: p_TerrRsc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3657: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3658: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3659: FND_MSG_PUB.ADD;
3660: END IF;
3661: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3662: End If;

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

3729: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3730: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC_ALL') <> FND_API.G_TRUE Then
3731: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3733: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3734: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3735: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3736: FND_MSG_PUB.ADD;
3737: END IF;

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

3730: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC_ALL') <> FND_API.G_TRUE Then
3731: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3733: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3734: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3735: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3736: FND_MSG_PUB.ADD;
3737: END IF;
3738: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3731: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3733: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3734: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');
3735: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_RSC_ID');
3736: FND_MSG_PUB.ADD;
3737: END IF;
3738: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3739: End If;

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

3738: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3739: End If;
3740: Else
3741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3742: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3743: FND_MESSAGE.Set_Token('COL_NAME', 'TERR_RSC_ID' );
3744: FND_MSG_PUB.ADD;
3745: END IF;
3746: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3743: FND_MESSAGE.Set_Token('COL_NAME', 'TERR_RSC_ID' );

3739: End If;
3740: Else
3741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3742: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3743: FND_MESSAGE.Set_Token('COL_NAME', 'TERR_RSC_ID' );
3744: FND_MSG_PUB.ADD;
3745: END IF;
3746: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3747: End If;

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

3756:
3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN
3759: -- Invalid Territory Id specified
3760: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3761: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3762: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3763: FND_MSG_PUB.ADD;
3764: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3757: EXCEPTION
3758: WHEN NO_DATA_FOUND THEN
3759: -- Invalid Territory Id specified
3760: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3761: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3762: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3763: FND_MSG_PUB.ADD;
3764: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3765: END;

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

3758: WHEN NO_DATA_FOUND THEN
3759: -- Invalid Territory Id specified
3760: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3761: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_QUAL_TYPES');
3762: FND_MESSAGE.Set_Token('COLUMN_NAME', 'ACCESS_TYPE');
3763: FND_MSG_PUB.ADD;
3764: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3765: END;
3766: END IF;

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

3777: WHERE LOOKUP_CODE = p_TerrRsc_Access_Rec.TRANS_ACCESS_CODE;
3778: EXCEPTION
3779: WHEN NO_DATA_FOUND THEN
3780: -- Invalid TRANS_ACCESS_CODE specified
3781: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3782: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_LOOKUPS');
3783: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TRANS_ACCESS_CODE');
3784: FND_MSG_PUB.ADD;
3785: x_Return_Status := FND_API.G_RET_STS_ERROR ;

Line 3782: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_LOOKUPS');

3778: EXCEPTION
3779: WHEN NO_DATA_FOUND THEN
3780: -- Invalid TRANS_ACCESS_CODE specified
3781: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3782: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_LOOKUPS');
3783: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TRANS_ACCESS_CODE');
3784: FND_MSG_PUB.ADD;
3785: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3786: END;

Line 3783: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TRANS_ACCESS_CODE');

3779: WHEN NO_DATA_FOUND THEN
3780: -- Invalid TRANS_ACCESS_CODE specified
3781: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3782: FND_MESSAGE.Set_Token('TABLE_NAME', 'FND_LOOKUPS');
3783: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TRANS_ACCESS_CODE');
3784: FND_MSG_PUB.ADD;
3785: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3786: END;
3787: END IF;

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

3789: -- Validate last updated by
3790: IF ( p_TerrRsc_Access_Rec.LAST_UPDATED_BY is NULL OR
3791: p_TerrRsc_Access_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3793: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3794: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3795: FND_MSG_PUB.ADD;
3796: END IF;
3797: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3790: IF ( p_TerrRsc_Access_Rec.LAST_UPDATED_BY is NULL OR
3791: p_TerrRsc_Access_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM) Then
3792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3793: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3794: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATED_BY' );
3795: FND_MSG_PUB.ADD;
3796: END IF;
3797: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3798: End If;

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

3800: -- Check last update date
3801: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_DATE IS NULL OR
3802: p_TerrRsc_Access_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3804: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3805: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3806: FND_MSG_PUB.ADD;
3807: END IF;
3808: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3801: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_DATE IS NULL OR
3802: p_TerrRsc_Access_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE ) THEN
3803: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3804: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3805: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_DATE' );
3806: FND_MSG_PUB.ADD;
3807: END IF;
3808: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3809: End If;

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

3811: --Check last update login
3812: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN is NULL OR
3813: p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3814: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3815: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3816: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3817: FND_MSG_PUB.ADD;
3818: END IF;
3819: x_Return_Status := FND_API.G_RET_STS_ERROR ;

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

3812: If ( p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN is NULL OR
3813: p_TerrRsc_Access_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM ) THEN
3814: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3815: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_COL_VALUE');
3816: FND_MESSAGE.Set_Token('COL_NAME', 'LAST_UPDATE_LOGIN' );
3817: FND_MSG_PUB.ADD;
3818: END IF;
3819: x_Return_Status := FND_API.G_RET_STS_ERROR ;
3820: End If;

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

4424:
4425: -- Debug Message
4426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4427: THEN
4428: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4429: fnd_message.set_name ('PROC_NAME', l_api_name);
4430: FND_MSG_PUB.Add;
4431: END IF;
4432:

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

4425: -- Debug Message
4426: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4427: THEN
4428: fnd_message.set_name ('JTF', 'JTF_TERR_START_MSG');
4429: fnd_message.set_name ('PROC_NAME', l_api_name);
4430: FND_MSG_PUB.Add;
4431: END IF;
4432:
4433: -- Initialize API return status to success

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

4479: dbms_output.put_line(
4480: 'Unexpected Execution Error from call to Create Terr Resource API');
4481: */
4482:
4483: fnd_message.set_name('JTF', 'JTF_ERROR_TERRRSC_API');
4484: fnd_msg_pub.add;
4485: RAISE fnd_api.g_exc_unexpected_error;
4486:
4487: END IF;

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

4525: /*
4526: dbms_output.put_line(
4527: 'Unexpected Execution Error from call to Create Terr Resource Access API');
4528: */
4529: fnd_message.set_name('JTF', 'JTF_ERROR_TERRRSCACCESS_API');
4530: fnd_msg_pub.add;
4531: RAISE fnd_api.g_exc_unexpected_error;
4532: END IF;
4533:

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

4630:
4631: /* Debug message */
4632: --arpatel bug#1500581 (part of fix)
4633: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4634: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_RSC_ACCESS_UK_CON');
4635: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');
4636: FND_MSG_PUB.ADD;
4637: --END IF;
4638:

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

4631: /* Debug message */
4632: --arpatel bug#1500581 (part of fix)
4633: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4634: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_RSC_ACCESS_UK_CON');
4635: --FND_MESSAGE.Set_Token ('TABLE', 'JTF_TERR_RSC_ACCESS_ALL');
4636: FND_MSG_PUB.ADD;
4637: --END IF;
4638:
4639: END IF; /* c_chk_uk_violation%FOUND */

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

4648:
4649: WHEN OTHERS THEN
4650: --dbms_output('Validate_Foreign_Key: Others exception' || SQLERRM);
4651: X_return_status := FND_API.G_RET_STS_ERROR;
4652: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4653: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );
4654: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
4655: FND_MSG_PUB.ADD;
4656: FND_MSG_PUB.Count_And_Get

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

4649: WHEN OTHERS THEN
4650: --dbms_output('Validate_Foreign_Key: Others exception' || SQLERRM);
4651: X_return_status := FND_API.G_RET_STS_ERROR;
4652: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4653: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );
4654: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
4655: FND_MSG_PUB.ADD;
4656: FND_MSG_PUB.Count_And_Get
4657: ( p_count => x_msg_count,

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

4650: --dbms_output('Validate_Foreign_Key: Others exception' || SQLERRM);
4651: X_return_status := FND_API.G_RET_STS_ERROR;
4652: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_UNEXPECTED_ERROR');
4653: FND_MESSAGE.Set_Token('PROC_NAME', 'Validate_Unique_Key' );
4654: FND_MESSAGE.Set_Token('ERROR', sqlerrm );
4655: FND_MSG_PUB.ADD;
4656: FND_MSG_PUB.Count_And_Get
4657: ( p_count => x_msg_count,
4658: p_data => x_msg_data

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

4770:
4771: -- Debug Message
4772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4773: THEN
4774: fnd_message.set_name ('JTF', 'JTF_TERRITORY_START_MSG');
4775: fnd_message.set_name ('PROC_NAME', l_api_name);
4776: FND_MSG_PUB.Add;
4777: END IF;
4778:

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

4771: -- Debug Message
4772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
4773: THEN
4774: fnd_message.set_name ('JTF', 'JTF_TERRITORY_START_MSG');
4775: fnd_message.set_name ('PROC_NAME', l_api_name);
4776: FND_MSG_PUB.Add;
4777: END IF;
4778:
4779: -- Initialize API return status to success

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

5023:
5024: -- Debug Message
5025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
5026: THEN
5027: fnd_message.set_name ('JTF', 'JTF_TERRITORY_END_MSG');
5028: fnd_message.set_name ('PROC_NAME', l_api_name);
5029: FND_MSG_PUB.Add;
5030: END IF;
5031:

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

5024: -- Debug Message
5025: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
5026: THEN
5027: fnd_message.set_name ('JTF', 'JTF_TERRITORY_END_MSG');
5028: fnd_message.set_name ('PROC_NAME', l_api_name);
5029: FND_MSG_PUB.Add;
5030: END IF;
5031:
5032: FND_MSG_PUB.Count_And_Get