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

Line 109: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss req itms');

105: l_return_status := FND_API.G_RET_STS_ERROR;
106:
107: /* Debug message */
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
109: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss req itms');
110: FND_MESSAGE.Set_Token ('COLUMN', 'NAME, DESCRIPTION');
111: FND_MSG_PUB.ADD;
112: END IF;
113:

Line 110: FND_MESSAGE.Set_Token ('COLUMN', 'NAME, DESCRIPTION');

106:
107: /* Debug message */
108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
109: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss req itms');
110: FND_MESSAGE.Set_Token ('COLUMN', 'NAME, DESCRIPTION');
111: FND_MSG_PUB.ADD;
112: END IF;
113:
114: END IF;

Line 187: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:name exists');

183: l_seed_qual_out_rec.seeded_qual_id := l_seeded_qual_id_csr;
184:
185: -- Debug message
186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
187: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:name exists');
188: FND_MESSAGE.Set_Token ('ROW', 'JTF_SEEDED_QUAL_B');
189: FND_MSG_PUB.ADD;
190: END IF;
191:

Line 188: FND_MESSAGE.Set_Token ('ROW', 'JTF_SEEDED_QUAL_B');

184:
185: -- Debug message
186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
187: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:name exists');
188: FND_MESSAGE.Set_Token ('ROW', 'JTF_SEEDED_QUAL_B');
189: FND_MSG_PUB.ADD;
190: END IF;
191:
192: END IF;

Line 310: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Col dtype noexist');

306: IF c_column_datatype%NOTFOUND THEN
307:
308: -- Debug message
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
310: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Col dtype noexist');
311: FND_MESSAGE.Set_Token ( 'COLUMN', 'QUAL_TABLE1');
312: FND_MSG_PUB.ADD;
313: END IF;
314:

Line 311: FND_MESSAGE.Set_Token ( 'COLUMN', 'QUAL_TABLE1');

307:
308: -- Debug message
309: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
310: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Col dtype noexist');
311: FND_MESSAGE.Set_Token ( 'COLUMN', 'QUAL_TABLE1');
312: FND_MSG_PUB.ADD;
313: END IF;
314:
315: l_column_datatype_csr := NULL;

Line 434: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss mandtry itms');

430: )
431: THEN
432: -- Debug message
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
434: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss mandtry itms');
435: FND_MESSAGE.Set_Token ( 'COLUMN',
436: 'QUAL_TYPE_USG_ID, ' ||
437: 'QUAL_COL1, QUAL_COL1_ALIAS, QUAL_COL1_DATATYPE, ' ||
438: 'QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS');

Line 435: FND_MESSAGE.Set_Token ( 'COLUMN',

431: THEN
432: -- Debug message
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
434: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss mandtry itms');
435: FND_MESSAGE.Set_Token ( 'COLUMN',
436: 'QUAL_TYPE_USG_ID, ' ||
437: 'QUAL_COL1, QUAL_COL1_ALIAS, QUAL_COL1_DATATYPE, ' ||
438: 'QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS');
439: FND_MSG_PUB.ADD;

Line 502: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');

498: l_return_variable := FND_API.G_FALSE;
499:
500: /* Debug message */
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
502: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');
503: FND_MESSAGE.Set_Token ('TABLE', p_table_name);
504: FND_MSG_PUB.ADD;
505: END IF;
506:

Line 503: FND_MESSAGE.Set_Token ('TABLE', p_table_name);

499:
500: /* Debug message */
501: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
502: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');
503: FND_MESSAGE.Set_Token ('TABLE', p_table_name);
504: FND_MSG_PUB.ADD;
505: END IF;
506:
507: END IF;

Line 525: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');

521: l_return_variable := FND_API.G_FALSE;
522:
523: /* Debug message */
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
525: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');
526: FND_MESSAGE.Set_Token ('COLUMN', p_col_name);
527: FND_MSG_PUB.ADD;
528: END IF;
529:

Line 526: FND_MESSAGE.Set_Token ('COLUMN', p_col_name);

522:
523: /* Debug message */
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
525: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');
526: FND_MESSAGE.Set_Token ('COLUMN', p_col_name);
527: FND_MSG_PUB.ADD;
528: END IF;
529:
530: END IF;

Line 687: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');

683: l_return_status := FND_API.G_RET_STS_ERROR;
684:
685: /* Debug message */
686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
687: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');
688: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');
689: FND_MSG_PUB.ADD;
690: END IF;
691:

Line 688: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');

684:
685: /* Debug message */
686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
687: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');
688: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');
689: FND_MSG_PUB.ADD;
690: END IF;
691:
692: END IF; /* c_chk_uk_violation%FOUND */

Line 1012: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL1');

1008:
1009: /* Debug Message */
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1011: THEN
1012: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL1');
1013: FND_MSG_PUB.Add;
1014: END IF;
1015:
1016: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1030: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL2');

1026:
1027: /* Debug Message */
1028: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1029: THEN
1030: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL2');
1031: FND_MSG_PUB.Add;
1032: END IF;
1033:
1034: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1047: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL3');

1043: IF c_chk_terr%FOUND THEN
1044: /* Debug Message */
1045: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1046: THEN
1047: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL3');
1048: FND_MSG_PUB.Add;
1049: END IF;
1050:
1051: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1066: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL4');

1062:
1063: /* Debug Message */
1064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1065: THEN
1066: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL4');
1067: FND_MSG_PUB.Add;
1068: END IF;
1069:
1070: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1198: FND_MESSAGE.Set_Name('JTF', 'PVT Create Qual: Start');

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', 'PVT Create Qual: Start');
1199: FND_MSG_PUB.Add;
1200: END IF;
1201:
1202:

Line 1232: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Validate Rec');

1228: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1229:
1230: -- Debug message
1231: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1232: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Validate Rec');
1233: FND_MSG_PUB.ADD;
1234: END IF;
1235:
1236:

Line 1266: FND_MESSAGE.Set_Name('JTF', 'PVT QUALIFIER API:');

1262: ----------------------------------
1263:
1264: -- Debug message
1265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1266: FND_MESSAGE.Set_Name('JTF', 'PVT QUALIFIER API:');
1267: FND_MSG_PUB.ADD;
1268: END IF;
1269:
1270: -- Insert seeded qualifier record into database

Line 1289: FND_MESSAGE.Set_Name('JTF', 'PVT API: Ins');

1285: ----------------------------------
1286:
1287: -- Debug message
1288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1289: FND_MESSAGE.Set_Name('JTF', 'PVT API: Ins');
1290: FND_MSG_PUB.ADD;
1291: END IF;
1292:
1293: create_qual_usgs_record ( l_seed_qual_out_rec.seeded_qual_id,

Line 1322: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');

1318: -- Success Message
1319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1320: l_return_status = FND_API.G_RET_STS_SUCCESS
1321: THEN
1322: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1323: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1324: FND_MSG_PUB.Add;
1325: END IF;
1326:

Line 1323: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);

1319: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1320: l_return_status = FND_API.G_RET_STS_SUCCESS
1321: THEN
1322: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1323: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1324: FND_MSG_PUB.Add;
1325: END IF;
1326:
1327: -- Standard check of p_commit.

Line 1336: FND_MESSAGE.Set_Name('JTF', 'PVT Create Qual API: End');

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', 'PVT Create Qual API: End');
1337: FND_MSG_PUB.Add;
1338: END IF;
1339:
1340: -- Standard call to get message count and if count is 1, get message info.

Line 1471: FND_MESSAGE.Set_Name('JTF', 'PVT UpdateQual API: Start');

1467:
1468: -- Debug Message
1469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1470: THEN
1471: FND_MESSAGE.Set_Name('JTF', 'PVT UpdateQual API: Start');
1472: FND_MSG_PUB.Add;
1473: END IF;
1474:
1475:

Line 1497: FND_MESSAGE.Set_Name('JTF', 'PVT QUAL API: Valdte Record');

1493: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1494:
1495: -- Debug message
1496: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1497: FND_MESSAGE.Set_Name('JTF', 'PVT QUAL API: Valdte Record');
1498: FND_MSG_PUB.ADD;
1499: END IF;
1500:
1501: -- validate the seeded qualifier record

Line 1537: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Updte SeedQualRec');

1533: ----------------------------------
1534:
1535: -- Debug message
1536: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1537: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Updte SeedQualRec');
1538: FND_MSG_PUB.ADD;
1539: END IF;
1540:
1541: -- Update seeded qualifier record into database

Line 1557: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Update QualUsgRec');

1553: ----------------------------------
1554:
1555: -- Debug message
1556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1557: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Update QualUsgRec');
1558: FND_MSG_PUB.ADD;
1559: END IF;
1560:
1561: update_qual_usgs_record ( l_qual_usgs_rec,

Line 1584: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');

1580: -- Success Message
1581: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1582: l_return_status = FND_API.G_RET_STS_SUCCESS
1583: THEN
1584: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1585: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1586: FND_MSG_PUB.Add;
1587: END IF;
1588:

Line 1585: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);

1581: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1582: l_return_status = FND_API.G_RET_STS_SUCCESS
1583: THEN
1584: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1585: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1586: FND_MSG_PUB.Add;
1587: END IF;
1588:
1589:

Line 1600: FND_MESSAGE.Set_Name('JTF', 'PVT Update Qual API: End');

1596:
1597: -- Debug Message
1598: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1599: THEN
1600: FND_MESSAGE.Set_Name('JTF', 'PVT Update Qual API: End');
1601: FND_MSG_PUB.Add;
1602: END IF;
1603:
1604: -- Standard call to get message count and if count is 1, get message info.

Line 1730: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Start');

1726:
1727: -- Debug Message
1728: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1729: THEN
1730: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Start');
1731: FND_MSG_PUB.Add;
1732: END IF;
1733:
1734: -- ******************************************************************

Line 1771: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug1');

1767: ----------------------------------
1768:
1769: -- Debug message
1770: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1771: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug1');
1772: FND_MSG_PUB.ADD;
1773: END IF;
1774:
1775:

Line 1794: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug2');

1790: ----------------------------------
1791:
1792: -- Debug message
1793: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1794: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug2');
1795: FND_MSG_PUB.ADD;
1796: END IF;
1797:
1798:

Line 1820: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');

1816: -- Success Message
1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1818: l_return_status = FND_API.G_RET_STS_SUCCESS
1819: THEN
1820: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1821: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1822: FND_MSG_PUB.Add;
1823: END IF;
1824:

Line 1821: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);

1817: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1818: l_return_status = FND_API.G_RET_STS_SUCCESS
1819: THEN
1820: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1821: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1822: FND_MSG_PUB.Add;
1823: END IF;
1824:
1825: -- Standard check of p_commit.

Line 1834: FND_MESSAGE.Set_Name('JTF', 'PVT Delete Qual API: End');

1830:
1831: -- Debug Message
1832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1833: THEN
1834: FND_MESSAGE.Set_Name('JTF', 'PVT Delete Qual API: End');
1835: FND_MSG_PUB.Add;
1836: END IF;
1837:
1838: -- Standard call to get message count and if count is 1, get message info.