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 STANDARD

Line 461: -- Standard check of p_commit.

457: end if;
458: close c;
459: --
460: --
461: -- Standard check of p_commit.
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.

Line 465: -- Standard call to get message count and if count is 1, get message info.

461: -- Standard check of p_commit.
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

Line 942: -- Standard check of p_commit.

938: -- raise no_data_found;
939: raise FND_API.G_EXC_ERROR ;
940: end if;
941: --
942: -- Standard check of p_commit.
943: --
944: if FND_API.to_Boolean (p_commit) then
945: commit work;
946: end if;

Line 948: -- Standard call to get message count and if count is 1, get message info.

944: if FND_API.to_Boolean (p_commit) then
945: commit work;
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: --

Line 1101: -- Standard call to get message count and if count is 1, get message info.

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

Line 1152: -- Standard check of p_commit.

1148: p_attribute_category => p_attribute_category ,
1149: p_name => p_name ,
1150: p_mode => p_mode
1151: );
1152: -- Standard check of p_commit.
1153:
1154: if FND_API.to_Boolean (p_commit) then
1155: commit work;
1156: end if;

Line 1158: -- Standard call to get message count and if count is 1, get message info.

1154: if FND_API.to_Boolean (p_commit) then
1155: commit work;
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:

Line 1215: -- Standard check of p_commit.

1211: if (sql%notfound) THEN
1212: null;
1213: end if;
1214:
1215: -- Standard check of p_commit.
1216: --
1217: if FND_API.to_Boolean (p_commit) then
1218: commit work;
1219: end if;

Line 1221: -- Standard call to get message count and if count is 1, get message info.

1217: if FND_API.to_Boolean (p_commit) then
1218: commit work;
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: --

Line 1282: -- Standard check of p_commit.

1278: delete from PSB_POSITION_ASSIGNMENTS
1279: where worksheet_id = p_worksheet_id;
1280:
1281:
1282: -- Standard check of p_commit.
1283:
1284: if FND_API.to_Boolean (p_commit) then
1285: commit work;
1286: end if;

Line 1293: -- Standard call to get message count and if count is 1, get message info.

1289: -- Initialize API return status to success
1290:
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:

Line 1357: -- Standard check of p_commit.

1353: where assignment_type = 'EMPLOYEE'
1354: and data_extract_id = p_data_extract_id;
1355:
1356:
1357: -- Standard check of p_commit.
1358:
1359: if FND_API.to_Boolean (p_commit) then
1360: commit work;
1361: end if;

Line 1368: -- Standard call to get message count and if count is 1, get message info.

1364: -- Initialize API return status to success
1365:
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:

Line 2651: -- Standard check of p_commit.

2647:
2648: p_return_status := FND_API.G_RET_STS_SUCCESS;
2649:
2650:
2651: -- Standard check of p_commit.
2652:
2653: if FND_API.to_Boolean (p_commit) then
2654: commit work;
2655: end if;

Line 2657: -- Standard call to get message count and if count is 1, get message info.

2653: if FND_API.to_Boolean (p_commit) then
2654: commit work;
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:

Line 2869: -- Standard call to check for call compatibility.

2865: WHERE position_id = p_position_id ;
2866: --
2867: BEGIN
2868:
2869: -- Standard call to check for call compatibility.
2870: IF NOT FND_API.Compatible_API_Call (l_api_version,
2871: p_api_version,
2872: l_api_name,
2873: G_PKG_NAME)

Line 3063: -- Standard check of p_commit.

3059:
3060: -- Initialize API return status to success
3061: p_return_status := FND_API.G_RET_STS_SUCCESS;
3062:
3063: -- Standard check of p_commit.
3064: if FND_API.to_Boolean (p_commit) then
3065: commit work;
3066: end if;
3067:

Line 3068: -- Standard call to get message count and if count is 1, get message info.

3064: if FND_API.to_Boolean (p_commit) then
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:

Line 4248: -- Standard call to get message count and if count is 1, get message info.

4244: p_out_end_date := l_out_end_date ;
4245:
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: --

Line 4360: -- Standard call to check for call compatibility.

4356: l_salary_overlaps VARCHAR2(1) := FND_API.G_FALSE;
4357:
4358: BEGIN
4359:
4360: -- Standard call to check for call compatibility.
4361:
4362: if not FND_API.Compatible_API_Call (l_api_version,
4363: p_api_version,
4364: l_api_name,

Line 4394: -- Standard call to get message count and if count is 1, get message info.

4390:
4391: p_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 4478: -- Standard call to check for call compatibility.

4474: FROM psb_budget_groups_v
4475: WHERE budget_group_id = l_budget_group_id;
4476:
4477: BEGIN
4478: -- Standard call to check for call compatibility.
4479:
4480: g_validation_mode := p_validation_mode;
4481:
4482: if not FND_API.Compatible_API_Call (l_api_version,

Line 4600: -- Standard check of p_commit.

4596:
4597: p_validation_status := l_error_flag ;
4598: p_return_status := FND_API.G_RET_STS_SUCCESS;
4599:
4600: -- Standard check of p_commit.
4601:
4602: if FND_API.to_Boolean (p_commit) then
4603: commit work;
4604: end if;

Line 4606: -- Standard call to get message count and if count is 1, get message info.

4602: if FND_API.to_Boolean (p_commit) then
4603: commit work;
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:

Line 5672: -- Standard call to check for call compatibility

5668: where budget_revision_id = Worksheet;
5669:
5670: BEGIN
5671:
5672: -- Standard call to check for call compatibility
5673:
5674: if not FND_API.Compatible_API_Call (l_api_version,
5675: p_api_version,
5676: l_api_name,

Line 6367: -- Standard call to get message count and if count is 1, get message info

6363:
6364: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: