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.PSB_POSITIONS_PVT dependencies on FND_MSG_PUB

Line 293: FND_MSG_PUB.initialize;

289: --
290: SAVEPOINT Insert_Row ;
291: --
292: if FND_API.to_Boolean (p_init_msg_list) then
293: FND_MSG_PUB.initialize;
294: end if;
295: --
296: p_return_status := FND_API.G_RET_STS_SUCCESS ;
297: --

Line 313: FND_MSG_PUB.Add ;

309: P_LAST_UPDATE_LOGIN := -1;
310: end if;
311: else
312: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
313: FND_MSG_PUB.Add ;
314: raise FND_API.G_EXC_ERROR;
315: end if;
316: --
317:

Line 466: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

462: if FND_API.to_Boolean (p_commit) then
463: commit work;
464: end if;
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
467: p_data => p_msg_data);
468: --
469: EXCEPTION
470: --

Line 475: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

471: when FND_API.G_EXC_ERROR then
472: --
473: rollback to INSERT_ROW ;
474: p_return_status := FND_API.G_RET_STS_ERROR;
475: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
476: p_data => p_msg_data);
477: --
478: when FND_API.G_EXC_UNEXPECTED_ERROR then
479: --

Line 482: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

478: when FND_API.G_EXC_UNEXPECTED_ERROR then
479: --
480: rollback to INSERT_ROW ;
481: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
483: p_data => p_msg_data);
484: --
485: when OTHERS then
486: --

Line 489: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

485: when OTHERS then
486: --
487: rollback to INSERT_ROW ;
488: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
490: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
491: l_api_name);
492: END if;
493: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 490: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

486: --
487: rollback to INSERT_ROW ;
488: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
490: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
491: l_api_name);
492: END if;
493: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
494: p_data => p_msg_data);

Line 493: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

489: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
490: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
491: l_api_name);
492: END if;
493: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
494: p_data => p_msg_data);
495: --
496: END INSERT_ROW;
497: --

Line 588: FND_MSG_PUB.initialize;

584: --
585: SAVEPOINT Lock_Row ;
586: --
587: if FND_API.to_Boolean (p_init_msg_list) then
588: FND_MSG_PUB.initialize;
589: end if;
590: --
591: p_return_status := FND_API.G_RET_STS_SUCCESS ;
592: p_row_locked := FND_API.G_TRUE ;

Line 598: fnd_msg_pub.add ;

594: open c1;
595: fetch c1 into tlinfo;
596: if (c1%notfound) then
597: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
598: fnd_msg_pub.add ;
599: close c1;
600: raise fnd_api.g_exc_error ;
601: end if;
602: close c1;

Line 706: fnd_msg_pub.add ;

702: ) then
703: null;
704: else
705: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
706: fnd_msg_pub.add ;
707: raise fnd_api.g_exc_error ;
708: end if;
709:
710: EXCEPTION

Line 716: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

712: --
713: rollback to LOCK_ROW ;
714: p_row_locked := FND_API.G_FALSE ;
715: p_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
717: p_data => p_msg_data);
718: --
719: when FND_API.G_EXC_ERROR then
720: --

Line 723: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

719: when FND_API.G_EXC_ERROR then
720: --
721: rollback to LOCK_ROW ;
722: p_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
724: p_data => p_msg_data);
725: --
726: when FND_API.G_EXC_UNEXPECTED_ERROR then
727: --

Line 730: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

726: when FND_API.G_EXC_UNEXPECTED_ERROR then
727: --
728: rollback to LOCK_ROW ;
729: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
731: p_data => p_msg_data);
732: --
733: when OTHERS then
734: --

Line 737: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

733: when OTHERS then
734: --
735: rollback to LOCK_ROW ;
736: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
739: l_api_name);
740: END if;
741: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

734: --
735: rollback to LOCK_ROW ;
736: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
739: l_api_name);
740: END if;
741: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
742: p_data => p_msg_data);

Line 741: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

737: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
738: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
739: l_api_name);
740: END if;
741: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
742: p_data => p_msg_data);
743: --
744: END LOCK_ROW;
745: --

Line 819: FND_MSG_PUB.initialize;

815: --
816: SAVEPOINT Update_Row ;
817: --
818: if FND_API.to_Boolean (p_init_msg_list) then
819: FND_MSG_PUB.initialize;
820: end if;
821:
822: -- Initialize API return status to success
823:

Line 842: FND_MSG_PUB.Add ;

838: P_LAST_UPDATE_LOGIN := -1;
839: end if;
840: else
841: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
842: FND_MSG_PUB.Add ;
843: raise FND_API.G_EXC_ERROR ;
844: end if;
845:
846:

Line 950: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

946: end if;
947:
948: -- Standard call to get message count and if count is 1, get message info.
949:
950: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
951: p_data => p_msg_data);
952: --
953: EXCEPTION
954:

Line 959: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

955: when FND_API.G_EXC_ERROR then
956: --
957: rollback to Update_Row ;
958: p_return_status := FND_API.G_RET_STS_ERROR;
959: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
960: p_data => p_msg_data);
961: --
962: when FND_API.G_EXC_UNEXPECTED_ERROR then
963: --

Line 966: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

962: when FND_API.G_EXC_UNEXPECTED_ERROR then
963: --
964: rollback to Update_Row ;
965: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
966: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
967: p_data => p_msg_data);
968: --
969: when OTHERS then
970: --

Line 973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

969: when OTHERS then
970: --
971: rollback to Update_Row ;
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
974: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
975: l_api_name);
976: end if;
977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 974: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

970: --
971: rollback to Update_Row ;
972: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
974: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
975: l_api_name);
976: end if;
977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
978: p_data => p_msg_data);

Line 977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
974: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
975: l_api_name);
976: end if;
977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
978: p_data => p_msg_data);
979: --
980:
981: END UPDATE_ROW;

Line 1045: FND_MSG_PUB.initialize;

1041: --
1042: -- Initialize message list if p_init_msg_list is set to TRUE.
1043: --
1044: if FND_API.to_Boolean (p_init_msg_list) then
1045: FND_MSG_PUB.initialize;
1046: end if;
1047: --
1048: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1049: --

Line 1102: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1098: if FND_API.to_Boolean (p_commit) then
1099: commit work;
1100: end if;
1101: -- Standard call to get message count and if count is 1, get message info.
1102: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1103: p_data => p_msg_data);
1104:
1105: return;
1106: end if;

Line 1160: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1156: end if;
1157:
1158: -- Standard call to get message count and if count is 1, get message info.
1159:
1160: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1161: p_data => p_msg_data);
1162:
1163: END ADD_ROW;
1164: --

Line 1191: FND_MSG_PUB.initialize;

1187: --
1188: -- Initialize message list if p_init_msg_list is set to TRUE.
1189: --
1190: if FND_API.to_Boolean (p_init_msg_list) then
1191: FND_MSG_PUB.initialize;
1192: end if;
1193: --
1194: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1195: --

Line 1204: fnd_msg_pub.add ;

1200: WHERE position_id = p_position_id;
1201:
1202: IF (l_count <> 0) THEN
1203: fnd_message.set_name('PSB', 'PSB_POSITION_IN_WORKSHEET');
1204: fnd_msg_pub.add ;
1205: raise fnd_api.g_exc_error ;
1206: END IF;
1207: --
1208:

Line 1223: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1219: end if;
1220:
1221: -- Standard call to get message count and if count is 1, get message info.
1222:
1223: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1224: p_data => p_msg_data);
1225: --
1226: EXCEPTION
1227: when FND_API.G_EXC_ERROR then

Line 1231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1227: when FND_API.G_EXC_ERROR then
1228: --
1229: rollback to Delete_Row;
1230: p_return_status := FND_API.G_RET_STS_ERROR;
1231: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1232: p_data => p_msg_data);
1233: --
1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: --

Line 1238: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1234: when FND_API.G_EXC_UNEXPECTED_ERROR then
1235: --
1236: rollback to Delete_Row;
1237: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1239: p_data => p_msg_data);
1240: --
1241: when OTHERS then
1242: --

Line 1245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

1241: when OTHERS then
1242: --
1243: rollback to Delete_Row ;
1244: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1247: l_api_name);
1248: end if;
1249: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1242: --
1243: rollback to Delete_Row ;
1244: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1247: l_api_name);
1248: end if;
1249: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1250: p_data => p_msg_data);

Line 1249: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1245: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1247: l_api_name);
1248: end if;
1249: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1250: p_data => p_msg_data);
1251: --
1252: END DELETE_ROW;
1253:

Line 1275: FND_MSG_PUB.initialize;

1271:
1272: SAVEPOINT Delete_Assignments_Pvt;
1273:
1274: if FND_API.to_Boolean (p_init_msg_list) then
1275: FND_MSG_PUB.initialize;
1276: end if;
1277:
1278: delete from PSB_POSITION_ASSIGNMENTS
1279: where worksheet_id = p_worksheet_id;

Line 1295: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1291: p_return_status := FND_API.G_RET_STS_SUCCESS;
1292:
1293: -- Standard call to get message count and if count is 1, get message info.
1294:
1295: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1296: p_data => p_msg_data);
1297:
1298: EXCEPTION
1299:

Line 1304: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1300: when FND_API.G_EXC_ERROR then
1301: rollback to Delete_Assignments_Pvt;
1302: p_return_status := FND_API.G_RET_STS_ERROR;
1303:
1304: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1305: p_data => p_msg_data);
1306:
1307: when FND_API.G_EXC_UNEXPECTED_ERROR then
1308: rollback to Delete_Assignments_Pvt;

Line 1311: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1307: when FND_API.G_EXC_UNEXPECTED_ERROR then
1308: rollback to Delete_Assignments_Pvt;
1309: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1310:
1311: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1312: p_data => p_msg_data);
1313:
1314: when OTHERS then
1315: rollback to Delete_Assignments_Pvt;

Line 1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

1314: when OTHERS then
1315: rollback to Delete_Assignments_Pvt;
1316: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1319: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1320: l_api_name);
1321: end if;
1322:

Line 1319: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1315: rollback to Delete_Assignments_Pvt;
1316: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1319: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1320: l_api_name);
1321: end if;
1322:
1323: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1323: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1319: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1320: l_api_name);
1321: end if;
1322:
1323: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1324: p_data => p_msg_data);
1325:
1326: END Delete_Assignments;
1327:

Line 1349: FND_MSG_PUB.initialize;

1345:
1346: SAVEPOINT Delete_Assignment_Emp_Pvt;
1347:
1348: if FND_API.to_Boolean (p_init_msg_list) then
1349: FND_MSG_PUB.initialize;
1350: end if;
1351:
1352: delete from PSB_POSITION_ASSIGNMENTS
1353: where assignment_type = 'EMPLOYEE'

Line 1370: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1366: p_return_status := FND_API.G_RET_STS_SUCCESS;
1367:
1368: -- Standard call to get message count and if count is 1, get message info.
1369:
1370: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1371: p_data => p_msg_data);
1372:
1373: EXCEPTION
1374:

Line 1379: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1375: when FND_API.G_EXC_ERROR then
1376: rollback to Delete_Assignment_Emp_Pvt;
1377: p_return_status := FND_API.G_RET_STS_ERROR;
1378:
1379: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1380: p_data => p_msg_data);
1381:
1382: when FND_API.G_EXC_UNEXPECTED_ERROR then
1383: rollback to Delete_Assignment_Emp_Pvt;

Line 1386: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1382: when FND_API.G_EXC_UNEXPECTED_ERROR then
1383: rollback to Delete_Assignment_Emp_Pvt;
1384: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1385:
1386: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1387: p_data => p_msg_data);
1388:
1389: when OTHERS then
1390: rollback to Delete_Assignment_Emp_Pvt;

Line 1393: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

1389: when OTHERS then
1390: rollback to Delete_Assignment_Emp_Pvt;
1391: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392:
1393: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1395: l_api_name);
1396: end if;
1397:

Line 1394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

1390: rollback to Delete_Assignment_Emp_Pvt;
1391: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1392:
1393: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
1394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1395: l_api_name);
1396: end if;
1397:
1398: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 1398: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

1394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
1395: l_api_name);
1396: end if;
1397:
1398: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
1399: p_data => p_msg_data);
1400:
1401: END Delete_Assignment_Employees;
1402:

Line 1610: FND_MSG_PUB.initialize;

1606:
1607: BEGIN
1608:
1609: if FND_API.to_Boolean (p_init_msg_list) then
1610: FND_MSG_PUB.initialize;
1611: end if;
1612:
1613: l_userid := FND_GLOBAL.USER_ID;
1614: l_loginid := FND_GLOBAL.LOGIN_ID;

Line 2659: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2655: end if;
2656:
2657: -- Standard call to get message count and if count is 1, get message info.
2658:
2659: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2660: p_data => p_msg_data);
2661:
2662: EXCEPTION
2663:

Line 2667: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2663:
2664: when FND_API.G_EXC_ERROR then
2665: p_return_status := FND_API.G_RET_STS_ERROR;
2666:
2667: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2668: p_data => p_msg_data);
2669:
2670: when FND_API.G_EXC_UNEXPECTED_ERROR then
2671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2673: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2669:
2670: when FND_API.G_EXC_UNEXPECTED_ERROR then
2671: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2672:
2673: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2674: p_data => p_msg_data);
2675:
2676: when OTHERS then
2677: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2679: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

2675:
2676: when OTHERS then
2677: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2678:
2679: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2680: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2681: l_api_name);
2682: end if;
2683:

Line 2680: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

2676: when OTHERS then
2677: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2678:
2679: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
2680: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2681: l_api_name);
2682: end if;
2683:
2684: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 2684: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

2680: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
2681: l_api_name);
2682: end if;
2683:
2684: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
2685: p_data => p_msg_data);
2686:
2687: END Modify_Assignment;
2688:

Line 3069: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3065: commit work;
3066: end if;
3067:
3068: -- Standard call to get message count and if count is 1, get message info.
3069: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3070: p_data => p_msg_data);
3071: EXCEPTION
3072:
3073: when FND_API.G_EXC_ERROR then

Line 3076: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3072:
3073: when FND_API.G_EXC_ERROR then
3074: p_return_status := FND_API.G_RET_STS_ERROR;
3075:
3076: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3077: p_data => p_msg_data);
3078:
3079: when FND_API.G_EXC_UNEXPECTED_ERROR then
3080: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3082: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3078:
3079: when FND_API.G_EXC_UNEXPECTED_ERROR then
3080: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081:
3082: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3083: p_data => p_msg_data);
3084:
3085: when OTHERS then
3086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3088: if FND_MSG_PUB.Check_Msg_Level

3084:
3085: when OTHERS then
3086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087:
3088: if FND_MSG_PUB.Check_Msg_Level
3089: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3090: then
3091: FND_MSG_PUB.Add_Exc_Msg
3092: (p_pkg_name => G_PKG_NAME,

Line 3089: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3085: when OTHERS then
3086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087:
3088: if FND_MSG_PUB.Check_Msg_Level
3089: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3090: then
3091: FND_MSG_PUB.Add_Exc_Msg
3092: (p_pkg_name => G_PKG_NAME,
3093: p_procedure_name => l_api_name);

Line 3091: FND_MSG_PUB.Add_Exc_Msg

3087:
3088: if FND_MSG_PUB.Check_Msg_Level
3089: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3090: then
3091: FND_MSG_PUB.Add_Exc_Msg
3092: (p_pkg_name => G_PKG_NAME,
3093: p_procedure_name => l_api_name);
3094: end if;
3095:

Line 3096: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

3092: (p_pkg_name => G_PKG_NAME,
3093: p_procedure_name => l_api_name);
3094: end if;
3095:
3096: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
3097: p_data => p_msg_data);
3098:
3099: END Create_Default_Assignments;
3100:

Line 4094: FND_MSG_PUB.initialize;

4090: BEGIN
4091:
4092: --
4093: if FND_API.to_Boolean (p_init_msg_list) then
4094: FND_MSG_PUB.initialize;
4095: end if;
4096:
4097: -- STEP 1
4098: -- determine the worksheet id

Line 4118: FND_MSG_PUB.Add ;

4114: -- revision now has same structure as worksheet
4115:
4116: if (rev_csr%NOTFOUND) THEN
4117: FND_MESSAGE.SET_NAME('PSB', 'PSB_REVISION_NOT_FOUND') ;
4118: FND_MSG_PUB.Add ;
4119: raise FND_API.G_EXC_ERROR ;
4120: end if;
4121: CLOSE rev_csr ;
4122:

Line 4134: FND_MSG_PUB.Add ;

4130: l_global_worksheet_id ,
4131: l_budget_calendar_id ;
4132: if (worksheet_csr%NOTFOUND) THEN
4133: FND_MESSAGE.SET_NAME('PSB', 'PSB_WORKSHEET_NOT_FOUND') ;
4134: FND_MSG_PUB.Add ;
4135: raise FND_API.G_EXC_ERROR ;
4136: end if;
4137: CLOSE worksheet_csr ;
4138:

Line 4159: FND_MSG_PUB.Add ;

4155: FETCH calendar_csr INTO l_cal_start_date,
4156: l_cal_end_date ;
4157: if (calendar_csr%NOTFOUND) THEN
4158: FND_MESSAGE.SET_NAME('PSB', 'PSB_CALENDAR_NOT_FOUND') ;
4159: FND_MSG_PUB.Add ;
4160: raise FND_API.G_EXC_ERROR ;
4161: end if;
4162: --
4163: CLOSE calendar_csr ;

Line 4184: FND_MSG_PUB.Add ;

4180: FETCH position_csr INTO l_pos_effective_start_date,
4181: l_pos_effective_end_date ;
4182: if (position_csr%NOTFOUND) then
4183: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_NOT_FOUND') ;
4184: FND_MSG_PUB.Add ;
4185: raise FND_API.G_EXC_ERROR ;
4186: end if;
4187: CLOSE position_csr ;
4188: end if;

Line 4250: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4246: p_return_status := FND_API.G_RET_STS_SUCCESS ;
4247:
4248: -- Standard call to get message count and if count is 1, get message info.
4249:
4250: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4251: p_data => p_msg_data);
4252: --
4253:
4254: EXCEPTION

Line 4259: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4255: --
4256: when FND_API.G_EXC_ERROR then
4257: --
4258: p_return_status := FND_API.G_RET_STS_ERROR;
4259: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4260: p_data => p_msg_data);
4261: --
4262: when FND_API.G_EXC_UNEXPECTED_ERROR then
4263: --

Line 4265: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4261: --
4262: when FND_API.G_EXC_UNEXPECTED_ERROR then
4263: --
4264: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4265: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4266: p_data => p_msg_data);
4267: --
4268: when OTHERS then
4269: --

Line 4271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

4267: --
4268: when OTHERS then
4269: --
4270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4272: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4273: l_api_name);
4274: end if;
4275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 4272: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4268: when OTHERS then
4269: --
4270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4272: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4273: l_api_name);
4274: end if;
4275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4276: p_data => p_msg_data);

Line 4275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4272: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4273: l_api_name);
4274: end if;
4275: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4276: p_data => p_msg_data);
4277: --
4278: END Define_Worksheet_Values ;
4279:

Line 4371: FND_MSG_PUB.initialize;

4367: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4368: end if;
4369:
4370: if FND_API.to_Boolean (p_init_msg_list) then
4371: FND_MSG_PUB.initialize;
4372: end if;
4373:
4374: for c_Overlap_Rec in c_Overlap loop
4375: l_salary_overlaps := FND_API.G_TRUE;

Line 4383: FND_MSG_PUB.Add;

4379: begin
4380:
4381: if p_rowid is not null then
4382: FND_MESSAGE.SET_NAME('PSB', 'PSB_MULTIPLE_SALARY_IN_PERIOD');
4383: FND_MSG_PUB.Add;
4384: end if;
4385:
4386: raise FND_API.G_EXC_ERROR;
4387:

Line 4396: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4392:
4393:
4394: -- Standard call to get message count and if count is 1, get message info.
4395:
4396: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4397: p_data => p_msg_data);
4398:
4399:
4400: EXCEPTION

Line 4405: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4401:
4402: when FND_API.G_EXC_ERROR then
4403: p_return_status := FND_API.G_RET_STS_ERROR;
4404:
4405: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4406: p_data => p_msg_data);
4407:
4408: when FND_API.G_EXC_UNEXPECTED_ERROR then
4409: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4411: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4407:
4408: when FND_API.G_EXC_UNEXPECTED_ERROR then
4409: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4410:
4411: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4412: p_data => p_msg_data);
4413:
4414: when OTHERS then
4415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4417: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

4413:
4414: when OTHERS then
4415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4416:
4417: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4418: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4419: l_api_name);
4420: end if;
4421:

Line 4418: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4414: when OTHERS then
4415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4416:
4417: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4418: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4419: l_api_name);
4420: end if;
4421:
4422: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 4422: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4418: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4419: l_api_name);
4420: end if;
4421:
4422: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4423: p_data => p_msg_data);
4424:
4425: END Validate_Salary;
4426:

Line 4491: FND_MSG_PUB.initialize;

4487: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4488: end if;
4489:
4490: if FND_API.to_Boolean (p_init_msg_list) then
4491: FND_MSG_PUB.initialize;
4492: end if;
4493:
4494: OPEN c_ws;
4495: FETCH c_ws INTO

Line 4585: FND_MSG_PUB.ADD;

4581: IF NVL(l_error_flag,FND_API.G_RET_STS_SUCCESS) =
4582: FND_API.G_RET_STS_SUCCESS THEN
4583:
4584: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4585: FND_MSG_PUB.ADD;
4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');
4587: FND_MSG_PUB.ADD;
4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4589: FND_MSG_PUB.ADD;

Line 4587: FND_MSG_PUB.ADD;

4583:
4584: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4585: FND_MSG_PUB.ADD;
4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');
4587: FND_MSG_PUB.ADD;
4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4589: FND_MSG_PUB.ADD;
4590: END IF;
4591:

Line 4589: FND_MSG_PUB.ADD;

4585: FND_MSG_PUB.ADD;
4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');
4587: FND_MSG_PUB.ADD;
4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4589: FND_MSG_PUB.ADD;
4590: END IF;
4591:
4592: END IF;
4593:

Line 4608: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4604: end if;
4605:
4606: -- Standard call to get message count and if count is 1, get message info.
4607:
4608: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4609: p_data => p_msg_data);
4610:
4611: EXCEPTION
4612:

Line 4616: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4612:
4613: when FND_API.G_EXC_ERROR then
4614: p_return_status := FND_API.G_RET_STS_ERROR;
4615:
4616: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4617: p_data => p_msg_data);
4618:
4619: when FND_API.G_EXC_UNEXPECTED_ERROR then
4620: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4622: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4618:
4619: when FND_API.G_EXC_UNEXPECTED_ERROR then
4620: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4621:
4622: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4623: p_data => p_msg_data);
4624:
4625: when OTHERS then
4626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

4624:
4625: when OTHERS then
4626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627:
4628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4629: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4630: l_api_name);
4631: end if;
4632:

Line 4629: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

4625: when OTHERS then
4626: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627:
4628: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
4629: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4630: l_api_name);
4631: end if;
4632:
4633: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 4633: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

4629: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
4630: l_api_name);
4631: end if;
4632:
4633: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
4634: p_data => p_msg_data);
4635:
4636: END Position_WS_Validation;
4637:

Line 4953: FND_MSG_PUB.Add;

4949: combination_id => l_ccid,
4950: n_segments => l_last_index,
4951: segments => l_ccid_val) THEN
4952:
4953: FND_MSG_PUB.Add;
4954: raise FND_API.G_EXC_ERROR;
4955: END IF;
4956:
4957: FOR l_index IN 1..l_last_index LOOP

Line 5120: FND_MSG_PUB.ADD;

5116: END IF;
5117:
5118: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_CCID_FAILURE');
5119: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5120: FND_MSG_PUB.ADD;
5121: /* Bug 3692601 End */
5122: END;
5123: /* Bug 3692601 Start */
5124: ELSE

Line 5143: FND_MSG_PUB.ADD;

5139: OR cc_rec.summary_flag = 'Y' THEN
5140: SET_POS_HEADING(l_position_flag, p_name,p_employee_number, p_error_flag);
5141: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');
5142: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5143: FND_MSG_PUB.ADD;
5144: END IF;
5145: END LOOP;
5146: END IF;
5147: /* Bug 3692601 End */

Line 5168: FND_MSG_PUB.ADD;

5164: combination_id => c_dist_rec.code_combination_id);
5165: SET_POS_HEADING(l_position_flag, p_name,p_employee_number, p_error_flag);
5166: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');
5167: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5168: FND_MSG_PUB.ADD;
5169: END IF;
5170: END LOOP;
5171: END IF;
5172: /* Bug 3692601 End */

Line 5194: FND_MSG_PUB.Add;

5190: IF NOT FND_API.to_Boolean(l_job_exists) THEN
5191: SET_POS_HEADING(l_position_flag,
5192: p_name,p_employee_number,p_error_flag );
5193: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_NO_JOB_ATTRIBUTE');
5194: FND_MSG_PUB.Add;
5195: END IF;
5196:
5197: --++ paybasis
5198: /* Bug 3247574 Start

Line 5211: FND_MSG_PUB.Add; */

5207: IF FND_API.to_Boolean(l_pay_basis_invalid) THEN
5208: /* SET_POS_HEADING(l_position_flag ,
5209: p_name,p_employee_number,p_error_flag );
5210: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_PAY_BASIS');
5211: FND_MSG_PUB.Add; */
5212: SET_POS_HEADING(l_position_flag,
5213: p_name,p_employee_number,p_error_flag );
5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');
5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);

Line 5218: FND_MSG_PUB.ADD;

5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');
5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);
5216: FND_MESSAGE.SET_TOKEN('START_DATE', l_calc_start_date);
5217: FND_MESSAGE.SET_TOKEN('END_DATE', l_calc_end_date);
5218: FND_MSG_PUB.ADD;
5219: END IF;
5220:
5221: /* Bug 3247574 End */
5222:

Line 5295: FND_MSG_PUB.Add;

5291: if NOT FND_API.to_Boolean(l_weekly_hours_exists) THEN
5292: SET_POS_HEADING(l_position_flag ,
5293: p_name,p_employee_number,p_error_flag );
5294: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_NO_DEFAULT_WEEK_HOURS');
5295: FND_MSG_PUB.Add;
5296: end if;
5297:
5298: end if;
5299:

Line 5332: FND_MSG_PUB.Add;

5328:
5329: SET_POS_HEADING(l_position_flag ,
5330: p_name,p_employee_number,p_error_flag );
5331: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_MISSING_SALARY');
5332: FND_MSG_PUB.Add;
5333: END IF;
5334:
5335: p_return_status := FND_API.G_RET_STS_SUCCESS;
5336:

Line 5351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

5347: WHEN OTHERS then
5348:
5349: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5350:
5351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5352: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5353: l_api_name);
5354: END IF;
5355:

Line 5352: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5348:
5349: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5350:
5351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5352: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5353: l_api_name);
5354: END IF;
5355:
5356: END VALIDATE_POSITION;

Line 5439: FND_MSG_PUB.Add;

5435:
5436: SET_POS_HEADING(p_position_flag ,
5437: p_name,p_employee_number,p_error_flag );
5438: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INCOMPLETE_DISTR');
5439: FND_MSG_PUB.Add;
5440:
5441: END LOOP;
5442:
5443: --++

Line 5498: FND_MSG_PUB.Add;

5494: SET_POS_HEADING(p_position_flag ,
5495: p_name,p_employee_number,p_error_flag );
5496: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_CCID_NOTIN_BG');
5497: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);
5498: FND_MSG_PUB.Add;
5499:
5500: ELSE
5501: -- validate in in account range
5502: -- ... next check if the budget group belongs to the worksheet's

Line 5523: FND_MSG_PUB.Add;

5519: SET_POS_HEADING(p_position_flag ,
5520: p_name,p_employee_number,p_error_flag );
5521: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_CCID_IN_BG');
5522: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);
5523: FND_MSG_PUB.Add;
5524:
5525: END IF;
5526:
5527: --

Line 5537: FND_MSG_PUB.Add;

5533: IF NOT FND_API.to_Boolean(l_salary_distr_exists) THEN
5534: SET_POS_HEADING(p_position_flag ,
5535: p_name,p_employee_number,p_error_flag );
5536: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_MISSING_DISTRIBUTIONS');
5537: FND_MSG_PUB.Add;
5538: END IF;
5539:
5540: p_return_status := FND_API.G_RET_STS_SUCCESS;
5541: --

Line 5556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

5552: WHEN OTHERS then
5553:
5554: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5555:
5556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5557: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5558: l_api_name);
5559: END IF;
5560:

Line 5557: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

5553:
5554: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5555:
5556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5557: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
5558: l_api_name);
5559: END IF;
5560:
5561: END VALIDATE_DISTRIBUTION;

Line 5585: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

5581:
5582: l_reqid := FND_GLOBAL.CONC_REQUEST_ID;
5583: l_userid := FND_GLOBAL.USER_ID;
5584:
5585: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
5586: p_data => l_msg_buf );
5587:
5588: PSB_MESSAGE_S.Insert_Error ( p_source_process => 'POSITION_WORKSHEET_EXCEPTION',
5589: p_process_id => p_worksheet_id,

Line 5595: FND_MSG_PUB.initialize;

5591: p_msg_data => l_msg_buf,
5592: p_desc_sequence => FND_API.G_FALSE) ;
5593:
5594: -- initialize error message stack --
5595: FND_MSG_PUB.initialize;
5596:
5597: p_return_status := FND_API.G_RET_STS_SUCCESS;
5598:
5599: END Output_Message_To_Table;

Line 5615: FND_MSG_PUB.Add;

5611: IF p_position_flag IS NULL THEN
5612: -- header
5613: p_position_flag := 'Y';
5614: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5615: FND_MSG_PUB.Add;
5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;

Line 5619: FND_MSG_PUB.Add;

5615: FND_MSG_PUB.Add;
5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;
5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5621: FND_MSG_PUB.Add;
5622:
5623: END IF;

Line 5621: FND_MSG_PUB.Add;

5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;
5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5621: FND_MSG_PUB.Add;
5622:
5623: END IF;
5624: p_error_flag := FND_API.G_RET_STS_ERROR ;
5625:

Line 5704: if FND_MSG_PUB.Check_Msg_Level

5700:
5701: when OTHERS then
5702: return FND_API.G_FALSE;
5703:
5704: if FND_MSG_PUB.Check_Msg_Level
5705: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5706: then
5707: FND_MSG_PUB.Add_Exc_Msg
5708: (p_pkg_name => G_PKG_NAME,

Line 5705: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5701: when OTHERS then
5702: return FND_API.G_FALSE;
5703:
5704: if FND_MSG_PUB.Check_Msg_Level
5705: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5706: then
5707: FND_MSG_PUB.Add_Exc_Msg
5708: (p_pkg_name => G_PKG_NAME,
5709: p_procedure_name => l_api_name);

Line 5707: FND_MSG_PUB.Add_Exc_Msg

5703:
5704: if FND_MSG_PUB.Check_Msg_Level
5705: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5706: then
5707: FND_MSG_PUB.Add_Exc_Msg
5708: (p_pkg_name => G_PKG_NAME,
5709: p_procedure_name => l_api_name);
5710: end if;
5711:

Line 6369: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

6365:
6366:
6367: -- Standard call to get message count and if count is 1, get message info
6368:
6369: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
6370: p_data => x_msg_data);
6371:
6372: EXCEPTION
6373:

Line 6378: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

6374: WHEN FND_API.G_EXC_ERROR THEN
6375: ROLLBACK TO Apply_Position_Default_Rules;
6376: x_return_status := FND_API.G_RET_STS_ERROR;
6377:
6378: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
6379: p_data => x_msg_data);
6380:
6381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6382: ROLLBACK TO Apply_Position_Default_Rules;

Line 6385: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

6381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6382: ROLLBACK TO Apply_Position_Default_Rules;
6383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6384:
6385: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
6386: p_data => x_msg_data);
6387:
6388: WHEN OTHERS THEN
6389: ROLLBACK TO Apply_Position_Default_Rules;

Line 6392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6388: WHEN OTHERS THEN
6389: ROLLBACK TO Apply_Position_Default_Rules;
6390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6391:
6392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6393:
6394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6395: l_api_name);
6396: END IF;

Line 6394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

6390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6391:
6392: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6393:
6394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6395: l_api_name);
6396: END IF;
6397: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
6398: p_data => x_msg_data);

Line 6397: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

6393:
6394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6395: l_api_name);
6396: END IF;
6397: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
6398: p_data => x_msg_data);
6399:
6400: End Apply_Position_Default_Rules;
6401: /* Bug 1308558 End */