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_MSG_PUB

Line 108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

104:
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;

Line 111: FND_MSG_PUB.ADD;

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;
115:

Line 186: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

182:
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;

Line 189: FND_MSG_PUB.ADD;

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;
193:

Line 306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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

Line 309: FND_MSG_PUB.ADD;

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

Line 430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

426: p_qual_usgs_rec.qual_col1_table_alias = FND_API.G_MISS_CHAR
427: )
428: THEN
429: -- Debug message
430: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
431: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Miss mandtry itms');
432: FND_MESSAGE.Set_Token ( 'COLUMN',
433: 'QUAL_TYPE_USG_ID, ' ||
434: 'QUAL_COL1, QUAL_COL1_ALIAS, QUAL_COL1_DATATYPE, ' ||

Line 436: FND_MSG_PUB.ADD;

432: FND_MESSAGE.Set_Token ( 'COLUMN',
433: 'QUAL_TYPE_USG_ID, ' ||
434: 'QUAL_COL1, QUAL_COL1_ALIAS, QUAL_COL1_DATATYPE, ' ||
435: 'QUAL_COL1_TABLE, QUAL_COL1_TABLE_ALIAS');
436: FND_MSG_PUB.ADD;
437: END IF;
438:
439: RETURN FND_API.G_TRUE;
440: ELSE

Line 492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

488:
489: l_return_variable := FND_API.G_FALSE;
490:
491: /* Debug message */
492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
493: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');
494: FND_MESSAGE.Set_Token ('TABLE', p_table_name);
495: FND_MSG_PUB.ADD;
496: END IF;

Line 495: FND_MSG_PUB.ADD;

491: /* Debug message */
492: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
493: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Table dnot exist');
494: FND_MESSAGE.Set_Token ('TABLE', p_table_name);
495: FND_MSG_PUB.ADD;
496: END IF;
497:
498: END IF;
499:

Line 515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

511:
512: l_return_variable := FND_API.G_FALSE;
513:
514: /* Debug message */
515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
516: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');
517: FND_MESSAGE.Set_Token ('COLUMN', p_col_name);
518: FND_MSG_PUB.ADD;
519: END IF;

Line 518: FND_MSG_PUB.ADD;

514: /* Debug message */
515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
516: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:Column dnot exist');
517: FND_MESSAGE.Set_Token ('COLUMN', p_col_name);
518: FND_MSG_PUB.ADD;
519: END IF;
520:
521: END IF;
522:

Line 677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

673:
674: l_return_status := FND_API.G_RET_STS_ERROR;
675:
676: /* Debug message */
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
678: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');
679: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');
680: FND_MSG_PUB.ADD;
681: END IF;

Line 680: FND_MSG_PUB.ADD;

676: /* Debug message */
677: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
678: FND_MESSAGE.Set_Name ('JTF', 'PVTQUAL API:UK Violation');
679: FND_MESSAGE.Set_Token ('TABLE', 'JTF_QUAL_USGS');
680: FND_MSG_PUB.ADD;
681: END IF;
682:
683: END IF; /* c_chk_uk_violation%FOUND */
684:

Line 1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

997: FETCH c_chk_sq_child INTO dummy_csr;
998: IF c_chk_sq_child%FOUND THEN
999:
1000: /* Debug Message */
1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1002: THEN
1003: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL1');
1004: FND_MSG_PUB.Add;
1005: END IF;

Line 1004: FND_MSG_PUB.Add;

1000: /* Debug Message */
1001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1002: THEN
1003: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL1');
1004: FND_MSG_PUB.Add;
1005: END IF;
1006:
1007: l_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF;

Line 1019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1015: FETCH c_chk_seeded_flag INTO dummy_csr;
1016: IF c_chk_seeded_flag%FOUND THEN
1017:
1018: /* Debug Message */
1019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1020: THEN
1021: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL2');
1022: FND_MSG_PUB.Add;
1023: END IF;

Line 1022: FND_MSG_PUB.Add;

1018: /* Debug Message */
1019: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1020: THEN
1021: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL2');
1022: FND_MSG_PUB.Add;
1023: END IF;
1024:
1025: l_return_status := FND_API.G_RET_STS_ERROR;
1026: END IF;

Line 1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1032:
1033:
1034: IF c_chk_terr%FOUND THEN
1035: /* Debug Message */
1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1037: THEN
1038: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL3');
1039: FND_MSG_PUB.Add;
1040: END IF;

Line 1039: FND_MSG_PUB.Add;

1035: /* Debug Message */
1036: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1037: THEN
1038: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL3');
1039: FND_MSG_PUB.Add;
1040: END IF;
1041:
1042: l_return_status := FND_API.G_RET_STS_ERROR;
1043: END IF;

Line 1055: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1051: FETCH c_chk_terr_type INTO dummy_csr;
1052: IF c_chk_terr_type%FOUND THEN
1053:
1054: /* Debug Message */
1055: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1056: THEN
1057: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL4');
1058: FND_MSG_PUB.Add;
1059: END IF;

Line 1058: FND_MSG_PUB.Add;

1054: /* Debug Message */
1055: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1056: THEN
1057: FND_MESSAGE.Set_Name('JTF', 'DELETE QUAL PVT: CHECK_DEL4');
1058: FND_MSG_PUB.Add;
1059: END IF;
1060:
1061: l_return_status := FND_API.G_RET_STS_ERROR;
1062: END IF;

Line 1183: FND_MSG_PUB.initialize;

1179:
1180: -- Initialize message list if p_init_msg_list is set to TRUE.
1181: IF FND_API.to_Boolean( p_init_msg_list )
1182: THEN
1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:
1186: /* Debug Message */
1187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 1187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1183: FND_MSG_PUB.initialize;
1184: END IF;
1185:
1186: /* Debug Message */
1187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1188: THEN
1189: FND_MESSAGE.Set_Name('JTF', 'PVT Create Qual: Start');
1190: FND_MSG_PUB.Add;
1191: END IF;

Line 1190: FND_MSG_PUB.Add;

1186: /* Debug Message */
1187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1188: THEN
1189: FND_MESSAGE.Set_Name('JTF', 'PVT Create Qual: Start');
1190: FND_MSG_PUB.Add;
1191: END IF;
1192:
1193:
1194: -- ******************************************************************

Line 1222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1218:
1219: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1220:
1221: -- Debug message
1222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1223: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Validate Rec');
1224: FND_MSG_PUB.ADD;
1225: END IF;
1226:

Line 1224: FND_MSG_PUB.ADD;

1220:
1221: -- Debug message
1222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1223: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Validate Rec');
1224: FND_MSG_PUB.ADD;
1225: END IF;
1226:
1227:
1228: -- validate the seeded qualifier record

Line 1256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1252: -- Process Seeded Qualifier Record
1253: ----------------------------------
1254:
1255: -- Debug message
1256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1257: FND_MESSAGE.Set_Name('JTF', 'PVT QUALIFIER API:');
1258: FND_MSG_PUB.ADD;
1259: END IF;
1260:

Line 1258: FND_MSG_PUB.ADD;

1254:
1255: -- Debug message
1256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1257: FND_MESSAGE.Set_Name('JTF', 'PVT QUALIFIER API:');
1258: FND_MSG_PUB.ADD;
1259: END IF;
1260:
1261: -- Insert seeded qualifier record into database
1262: create_seed_qual_record ( l_seed_qual_rec,

Line 1279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1275: -- Process Qualifier Usages Record
1276: ----------------------------------
1277:
1278: -- Debug message
1279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1280: FND_MESSAGE.Set_Name('JTF', 'PVT API: Ins');
1281: FND_MSG_PUB.ADD;
1282: END IF;
1283:

Line 1281: FND_MSG_PUB.ADD;

1277:
1278: -- Debug message
1279: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1280: FND_MESSAGE.Set_Name('JTF', 'PVT API: Ins');
1281: FND_MSG_PUB.ADD;
1282: END IF;
1283:
1284: create_qual_usgs_record ( l_seed_qual_out_rec.seeded_qual_id,
1285: l_qual_usgs_rec,

Line 1310: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND

1306: -- *************************************************************************************
1307:
1308:
1309: -- Success Message
1310: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1311: l_return_status = FND_API.G_RET_STS_SUCCESS
1312: THEN
1313: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1314: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);

Line 1315: FND_MSG_PUB.Add;

1311: l_return_status = FND_API.G_RET_STS_SUCCESS
1312: THEN
1313: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1314: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1315: FND_MSG_PUB.Add;
1316: END IF;
1317:
1318: -- Standard check of p_commit.
1319: IF FND_API.To_Boolean ( p_commit )

Line 1325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1321: COMMIT WORK;
1322: END IF;
1323:
1324: -- Debug Message
1325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1326: THEN
1327: FND_MESSAGE.Set_Name('JTF', 'PVT Create Qual API: End');
1328: FND_MSG_PUB.Add;
1329: END IF;

Line 1328: FND_MSG_PUB.Add;

1324: -- Debug Message
1325: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1326: THEN
1327: FND_MESSAGE.Set_Name('JTF', 'PVT Create Qual API: End');
1328: FND_MSG_PUB.Add;
1329: END IF;
1330:
1331: -- Standard call to get message count and if count is 1, get message info.
1332: FND_MSG_PUB.Count_And_Get

Line 1332: FND_MSG_PUB.Count_And_Get

1328: FND_MSG_PUB.Add;
1329: END IF;
1330:
1331: -- Standard call to get message count and if count is 1, get message info.
1332: FND_MSG_PUB.Count_And_Get
1333: ( p_count => x_msg_count,
1334: p_data => x_msg_data
1335: );
1336:

Line 1343: FND_MSG_PUB.Count_And_Get

1339: WHEN FND_API.G_EXC_ERROR THEN
1340: ROLLBACK TO CREATE_QUALIFIER_PVT;
1341: x_return_status := FND_API.G_RET_STS_ERROR ;
1342:
1343: FND_MSG_PUB.Count_And_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data
1346: );
1347:

Line 1353: FND_MSG_PUB.Count_And_Get

1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO CREATE_QUALIFIER_PVT;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352:
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );
1357:

Line 1363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1359: WHEN OTHERS THEN
1360: ROLLBACK TO CREATE_QUALIFIER_PVT;
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1362:
1363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1364: THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1366: END IF;
1367:

Line 1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1362:
1363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1364: THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1366: END IF;
1367:
1368: FND_MSG_PUB.Count_And_Get
1369: ( p_count => x_msg_count,

Line 1368: FND_MSG_PUB.Count_And_Get

1364: THEN
1365: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1366: END IF;
1367:
1368: FND_MSG_PUB.Count_And_Get
1369: ( p_count => x_msg_count,
1370: p_data => x_msg_data
1371: );
1372:

Line 1456: FND_MSG_PUB.initialize;

1452:
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list )
1455: THEN
1456: FND_MSG_PUB.initialize;
1457: END IF;
1458:
1459: -- Debug Message
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1456: FND_MSG_PUB.initialize;
1457: END IF;
1458:
1459: -- Debug Message
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1461: THEN
1462: FND_MESSAGE.Set_Name('JTF', 'PVT UpdateQual API: Start');
1463: FND_MSG_PUB.Add;
1464: END IF;

Line 1463: FND_MSG_PUB.Add;

1459: -- Debug Message
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1461: THEN
1462: FND_MESSAGE.Set_Name('JTF', 'PVT UpdateQual API: Start');
1463: FND_MSG_PUB.Add;
1464: END IF;
1465:
1466:
1467: -- ******************************************************************

Line 1487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1483:
1484: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1485:
1486: -- Debug message
1487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1488: FND_MESSAGE.Set_Name('JTF', 'PVT QUAL API: Valdte Record');
1489: FND_MSG_PUB.ADD;
1490: END IF;
1491:

Line 1489: FND_MSG_PUB.ADD;

1485:
1486: -- Debug message
1487: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1488: FND_MESSAGE.Set_Name('JTF', 'PVT QUAL API: Valdte Record');
1489: FND_MSG_PUB.ADD;
1490: END IF;
1491:
1492: -- validate the seeded qualifier record
1493: validate_seed_qual_rec ( l_seed_qual_rec,

Line 1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1523: -- Process Seeded Qualifier Record
1524: ----------------------------------
1525:
1526: -- Debug message
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1528: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Updte SeedQualRec');
1529: FND_MSG_PUB.ADD;
1530: END IF;
1531:

Line 1529: FND_MSG_PUB.ADD;

1525:
1526: -- Debug message
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1528: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Updte SeedQualRec');
1529: FND_MSG_PUB.ADD;
1530: END IF;
1531:
1532: -- Update seeded qualifier record into database
1533: update_seed_qual_record ( l_seed_qual_rec,

Line 1547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1543: -- Process Qualifier Usages Record
1544: ----------------------------------
1545:
1546: -- Debug message
1547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1548: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Update QualUsgRec');
1549: FND_MSG_PUB.ADD;
1550: END IF;
1551:

Line 1549: FND_MSG_PUB.ADD;

1545:
1546: -- Debug message
1547: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1548: FND_MESSAGE.Set_Name('JTF', 'PVTQUAL API:Update QualUsgRec');
1549: FND_MSG_PUB.ADD;
1550: END IF;
1551:
1552: update_qual_usgs_record ( l_qual_usgs_rec,
1553: l_qual_usgs_out_rec);

Line 1572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND

1568: -- *************************************************************************************
1569:
1570:
1571: -- Success Message
1572: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1573: l_return_status = FND_API.G_RET_STS_SUCCESS
1574: THEN
1575: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1576: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);

Line 1577: FND_MSG_PUB.Add;

1573: l_return_status = FND_API.G_RET_STS_SUCCESS
1574: THEN
1575: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1576: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1577: FND_MSG_PUB.Add;
1578: END IF;
1579:
1580:
1581:

Line 1589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1585: COMMIT WORK;
1586: END IF;
1587:
1588: -- Debug Message
1589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1590: THEN
1591: FND_MESSAGE.Set_Name('JTF', 'PVT Update Qual API: End');
1592: FND_MSG_PUB.Add;
1593: END IF;

Line 1592: FND_MSG_PUB.Add;

1588: -- Debug Message
1589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1590: THEN
1591: FND_MESSAGE.Set_Name('JTF', 'PVT Update Qual API: End');
1592: FND_MSG_PUB.Add;
1593: END IF;
1594:
1595: -- Standard call to get message count and if count is 1, get message info.
1596: FND_MSG_PUB.Count_And_Get

Line 1596: FND_MSG_PUB.Count_And_Get

1592: FND_MSG_PUB.Add;
1593: END IF;
1594:
1595: -- Standard call to get message count and if count is 1, get message info.
1596: FND_MSG_PUB.Count_And_Get
1597: ( p_count => x_msg_count,
1598: p_data => x_msg_data
1599: );
1600:

Line 1607: FND_MSG_PUB.Count_And_Get

1603: WHEN FND_API.G_EXC_ERROR THEN
1604: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1605: x_return_status := FND_API.G_RET_STS_ERROR ;
1606:
1607: FND_MSG_PUB.Count_And_Get
1608: ( p_count => x_msg_count,
1609: p_data => x_msg_data
1610: );
1611:

Line 1617: FND_MSG_PUB.Count_And_Get

1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1616:
1617: FND_MSG_PUB.Count_And_Get
1618: ( p_count => x_msg_count,
1619: p_data => x_msg_data
1620: );
1621:

Line 1627: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1623: WHEN OTHERS THEN
1624: ROLLBACK TO UPDATE_QUALIFIER_PVT;
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1626:
1627: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1628: THEN
1629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1630: END IF;
1631:

Line 1629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1626:
1627: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1628: THEN
1629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1630: END IF;
1631:
1632: FND_MSG_PUB.Count_And_Get
1633: ( p_count => x_msg_count,

Line 1632: FND_MSG_PUB.Count_And_Get

1628: THEN
1629: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1630: END IF;
1631:
1632: FND_MSG_PUB.Count_And_Get
1633: ( p_count => x_msg_count,
1634: p_data => x_msg_data
1635: );
1636:

Line 1715: FND_MSG_PUB.initialize;

1711:
1712: -- Initialize message list if p_init_msg_list is set to TRUE.
1713: IF FND_API.to_Boolean( p_init_msg_list )
1714: THEN
1715: FND_MSG_PUB.initialize;
1716: END IF;
1717:
1718: -- Debug Message
1719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 1719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1715: FND_MSG_PUB.initialize;
1716: END IF;
1717:
1718: -- Debug Message
1719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1720: THEN
1721: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Start');
1722: FND_MSG_PUB.Add;
1723: END IF;

Line 1722: FND_MSG_PUB.Add;

1718: -- Debug Message
1719: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1720: THEN
1721: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Start');
1722: FND_MSG_PUB.Add;
1723: END IF;
1724:
1725: -- ******************************************************************
1726: -- API BODY START

Line 1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1757: -- Process Seeded Qualifier Record
1758: ----------------------------------
1759:
1760: -- Debug message
1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1762: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug1');
1763: FND_MSG_PUB.ADD;
1764: END IF;
1765:

Line 1763: FND_MSG_PUB.ADD;

1759:
1760: -- Debug message
1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1762: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug1');
1763: FND_MSG_PUB.ADD;
1764: END IF;
1765:
1766:
1767:

Line 1784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1780: -- Process Qualifier Usages Record
1781: ----------------------------------
1782:
1783: -- Debug message
1784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1785: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug2');
1786: FND_MSG_PUB.ADD;
1787: END IF;
1788:

Line 1786: FND_MSG_PUB.ADD;

1782:
1783: -- Debug message
1784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1785: FND_MESSAGE.Set_Name('JTF', 'Delete Qualifier PVT: Debug2');
1786: FND_MSG_PUB.ADD;
1787: END IF;
1788:
1789:
1790:

Line 1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND

1804: -- *************************************************************************************
1805:
1806:
1807: -- Success Message
1808: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) AND
1809: l_return_status = FND_API.G_RET_STS_SUCCESS
1810: THEN
1811: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1812: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);

Line 1813: FND_MSG_PUB.Add;

1809: l_return_status = FND_API.G_RET_STS_SUCCESS
1810: THEN
1811: FND_MESSAGE.Set_Name('JTF', 'API_SUCCESS');
1812: FND_MESSAGE.Set_Token('ROW', 'JTF_QUALIFIER', TRUE);
1813: FND_MSG_PUB.Add;
1814: END IF;
1815:
1816: -- Standard check of p_commit.
1817: IF FND_API.To_Boolean ( p_commit )

Line 1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

1819: COMMIT WORK;
1820: END IF;
1821:
1822: -- Debug Message
1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1824: THEN
1825: FND_MESSAGE.Set_Name('JTF', 'PVT Delete Qual API: End');
1826: FND_MSG_PUB.Add;
1827: END IF;

Line 1826: FND_MSG_PUB.Add;

1822: -- Debug Message
1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1824: THEN
1825: FND_MESSAGE.Set_Name('JTF', 'PVT Delete Qual API: End');
1826: FND_MSG_PUB.Add;
1827: END IF;
1828:
1829: -- Standard call to get message count and if count is 1, get message info.
1830: FND_MSG_PUB.Count_And_Get

Line 1830: FND_MSG_PUB.Count_And_Get

1826: FND_MSG_PUB.Add;
1827: END IF;
1828:
1829: -- Standard call to get message count and if count is 1, get message info.
1830: FND_MSG_PUB.Count_And_Get
1831: ( p_count => x_msg_count,
1832: p_data => x_msg_data
1833: );
1834:

Line 1841: FND_MSG_PUB.Count_And_Get

1837: WHEN FND_API.G_EXC_ERROR THEN
1838: ROLLBACK TO DELETE_QUALIFIER_PVT;
1839: x_return_status := FND_API.G_RET_STS_ERROR ;
1840:
1841: FND_MSG_PUB.Count_And_Get
1842: ( p_count => x_msg_count,
1843: p_data => x_msg_data
1844: );
1845:

Line 1851: FND_MSG_PUB.Count_And_Get

1847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1848: ROLLBACK TO DELETE_QUALIFIER_PVT;
1849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1850:
1851: FND_MSG_PUB.Count_And_Get
1852: ( p_count => x_msg_count,
1853: p_data => x_msg_data
1854: );
1855:

Line 1861: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

1857: WHEN OTHERS THEN
1858: ROLLBACK TO DELETE_QUALIFIER_PVT;
1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1860:
1861: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1862: THEN
1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1864: END IF;
1865:

Line 1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);

1859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1860:
1861: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1862: THEN
1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1864: END IF;
1865:
1866: FND_MSG_PUB.Count_And_Get
1867: ( p_count => x_msg_count,

Line 1866: FND_MSG_PUB.Count_And_Get

1862: THEN
1863: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name);
1864: END IF;
1865:
1866: FND_MSG_PUB.Count_And_Get
1867: ( p_count => x_msg_count,
1868: p_data => x_msg_data
1869: );
1870: