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_POSITION_CONTROL_PVT dependencies on FND_MSG_PUB

Line 265: FND_MSG_PUB.Add;

261: end loop;
262:
263: end if;
264:
265: FND_MSG_PUB.Add;
266:
267: end if;
268:
269: -- Clear Message Token stack

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

5357:
5358: when FND_API.G_EXC_ERROR then
5359: p_return_status := FND_API.G_RET_STS_ERROR;
5360:
5361: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5362: p_data => p_msg_data);
5363:
5364: when FND_API.G_EXC_UNEXPECTED_ERROR then
5365: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5363:
5364: when FND_API.G_EXC_UNEXPECTED_ERROR then
5365: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5366:
5367: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5368: p_data => p_msg_data);
5369:
5370: when OTHERS then
5371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5373: if FND_MSG_PUB.Check_Msg_Level

5369:
5370: when OTHERS then
5371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5372:
5373: if FND_MSG_PUB.Check_Msg_Level
5374: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5375: FND_MSG_PUB.Add_Exc_Msg
5376: (p_pkg_name => G_PKG_NAME,
5377: p_procedure_name => l_api_name);

Line 5374: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

5370: when OTHERS then
5371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5372:
5373: if FND_MSG_PUB.Check_Msg_Level
5374: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5375: FND_MSG_PUB.Add_Exc_Msg
5376: (p_pkg_name => G_PKG_NAME,
5377: p_procedure_name => l_api_name);
5378: end if;

Line 5375: FND_MSG_PUB.Add_Exc_Msg

5371: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5372:
5373: if FND_MSG_PUB.Check_Msg_Level
5374: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5375: FND_MSG_PUB.Add_Exc_Msg
5376: (p_pkg_name => G_PKG_NAME,
5377: p_procedure_name => l_api_name);
5378: end if;
5379:

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

5376: (p_pkg_name => G_PKG_NAME,
5377: p_procedure_name => l_api_name);
5378: end if;
5379:
5380: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5381: p_data => p_msg_data);
5382: END Record_Position_Transaction;
5383:
5384: /* ----------------------------------------------------------------------- */

Line 5631: FND_MSG_PUB.Add;

5627:
5628: if ((l_no_hr_pos_count > 0) or (l_no_acct_dist > 0)) then
5629: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
5630: FND_MESSAGE.SET_TOKEN('MESSAGE', 'HR Pos Count 0');
5631: FND_MSG_PUB.Add;
5632: raise FND_API.G_EXC_ERROR;
5633: end if;
5634:
5635: -- Initialize API return status to success

Line 5643: FND_MSG_PUB.Add_Exc_Msg

5639:
5640: when FND_API.G_EXC_ERROR then
5641: p_return_status := FND_API.G_RET_STS_ERROR;
5642:
5643: FND_MSG_PUB.Add_Exc_Msg
5644: (p_pkg_name => G_PKG_NAME,
5645: p_procedure_name => l_api_name);
5646:
5647: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

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

5643: FND_MSG_PUB.Add_Exc_Msg
5644: (p_pkg_name => G_PKG_NAME,
5645: p_procedure_name => l_api_name);
5646:
5647: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
5648: p_data => l_msg_data);
5649:
5650: when FND_API.G_EXC_UNEXPECTED_ERROR then
5651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5653: FND_MSG_PUB.Add_Exc_Msg

5649:
5650: when FND_API.G_EXC_UNEXPECTED_ERROR then
5651: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5652:
5653: FND_MSG_PUB.Add_Exc_Msg
5654: (p_pkg_name => G_PKG_NAME,
5655: p_procedure_name => l_api_name);
5656:
5657: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,

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

5653: FND_MSG_PUB.Add_Exc_Msg
5654: (p_pkg_name => G_PKG_NAME,
5655: p_procedure_name => l_api_name);
5656:
5657: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
5658: p_data => l_msg_data);
5659:
5660: when OTHERS then
5661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5663: if FND_MSG_PUB.Check_Msg_Level

5659:
5660: when OTHERS then
5661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5662:
5663: if FND_MSG_PUB.Check_Msg_Level
5664: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5665: FND_MSG_PUB.Add_Exc_Msg
5666: (p_pkg_name => G_PKG_NAME,
5667: p_procedure_name => l_api_name);

Line 5664: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

5660: when OTHERS then
5661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5662:
5663: if FND_MSG_PUB.Check_Msg_Level
5664: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5665: FND_MSG_PUB.Add_Exc_Msg
5666: (p_pkg_name => G_PKG_NAME,
5667: p_procedure_name => l_api_name);
5668: end if;

Line 5665: FND_MSG_PUB.Add_Exc_Msg

5661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5662:
5663: if FND_MSG_PUB.Check_Msg_Level
5664: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
5665: FND_MSG_PUB.Add_Exc_Msg
5666: (p_pkg_name => G_PKG_NAME,
5667: p_procedure_name => l_api_name);
5668: end if;
5669:

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

5666: (p_pkg_name => G_PKG_NAME,
5667: p_procedure_name => l_api_name);
5668: end if;
5669:
5670: FND_MSG_PUB.Count_And_Get (p_count => l_msg_count,
5671: p_data => l_msg_data);
5672:
5673: END Validate_Position_Budget;
5674:

Line 5750: FND_MSG_PUB.initialize;

5746:
5747: -- Initialize message list if p_init_msg_list is set to TRUE.
5748:
5749: if FND_API.to_Boolean (p_init_msg_list) then
5750: FND_MSG_PUB.initialize;
5751: end if;
5752:
5753: for c_WS_Rec in c_WS loop
5754: l_data_extract_id := c_WS_Rec.data_extract_id;

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

5979: commit work;
5980: end if;
5981:
5982: -- Standard call to get message count and if count is 1, get message info.
5983: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5984: p_data => p_msg_data);
5985:
5986: -- Initialize API return status to success
5987: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

5994: rollback;
5995: /*For Bug No : 2434152 End*/
5996: p_return_status := FND_API.G_RET_STS_ERROR;
5997:
5998: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
5999: p_data => p_msg_data);
6000:
6001: when FND_API.G_EXC_UNEXPECTED_ERROR then
6002: /*For Bug No : 2434152 Start*/

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

6004: rollback;
6005: /*For Bug No : 2434152 End*/
6006: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6007:
6008: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6009: p_data => p_msg_data);
6010:
6011: when OTHERS then
6012: /*For Bug No : 2434152 Start*/

Line 6018: if FND_MSG_PUB.Check_Msg_Level

6014: rollback;
6015: /*For Bug No : 2434152 End*/
6016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6017:
6018: if FND_MSG_PUB.Check_Msg_Level
6019: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6020: FND_MSG_PUB.Add_Exc_Msg
6021: (p_pkg_name => G_PKG_NAME,
6022: p_procedure_name => l_api_name);

Line 6019: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6015: /*For Bug No : 2434152 End*/
6016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6017:
6018: if FND_MSG_PUB.Check_Msg_Level
6019: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6020: FND_MSG_PUB.Add_Exc_Msg
6021: (p_pkg_name => G_PKG_NAME,
6022: p_procedure_name => l_api_name);
6023: end if;

Line 6020: FND_MSG_PUB.Add_Exc_Msg

6016: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6017:
6018: if FND_MSG_PUB.Check_Msg_Level
6019: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6020: FND_MSG_PUB.Add_Exc_Msg
6021: (p_pkg_name => G_PKG_NAME,
6022: p_procedure_name => l_api_name);
6023: end if;
6024:

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

6021: (p_pkg_name => G_PKG_NAME,
6022: p_procedure_name => l_api_name);
6023: end if;
6024:
6025: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6026: p_data => p_msg_data);
6027:
6028: END Upload_Worksheet;
6029:

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

6181: p_print_header => FND_API.G_TRUE);
6182: retcode := 2;
6183:
6184: when OTHERS then
6185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6186: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6187: l_api_name);
6188: end if;
6189:

Line 6186: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

6182: retcode := 2;
6183:
6184: when OTHERS then
6185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6186: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6187: l_api_name);
6188: end if;
6189:
6190: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,

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

6254:
6255: when FND_API.G_EXC_ERROR then
6256: p_return_status := FND_API.G_RET_STS_ERROR;
6257:
6258: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6259: p_data => p_msg_data);
6260:
6261: when FND_API.G_EXC_UNEXPECTED_ERROR then
6262: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6260:
6261: when FND_API.G_EXC_UNEXPECTED_ERROR then
6262: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6263:
6264: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6265: p_data => p_msg_data);
6266:
6267: when OTHERS then
6268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6270: if FND_MSG_PUB.Check_Msg_Level

6266:
6267: when OTHERS then
6268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6269:
6270: if FND_MSG_PUB.Check_Msg_Level
6271: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6272: FND_MSG_PUB.Add_Exc_Msg
6273: (p_pkg_name => G_PKG_NAME,
6274: p_procedure_name => l_api_name);

Line 6271: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6267: when OTHERS then
6268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6269:
6270: if FND_MSG_PUB.Check_Msg_Level
6271: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6272: FND_MSG_PUB.Add_Exc_Msg
6273: (p_pkg_name => G_PKG_NAME,
6274: p_procedure_name => l_api_name);
6275: end if;

Line 6272: FND_MSG_PUB.Add_Exc_Msg

6268: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6269:
6270: if FND_MSG_PUB.Check_Msg_Level
6271: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6272: FND_MSG_PUB.Add_Exc_Msg
6273: (p_pkg_name => G_PKG_NAME,
6274: p_procedure_name => l_api_name);
6275: end if;
6276:

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

6273: (p_pkg_name => G_PKG_NAME,
6274: p_procedure_name => l_api_name);
6275: end if;
6276:
6277: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6278: p_data => p_msg_data);
6279:
6280: END Insert_Position_Accounts;
6281:

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

6313:
6314: when FND_API.G_EXC_ERROR then
6315: p_return_status := FND_API.G_RET_STS_ERROR;
6316:
6317: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6318: p_data => p_msg_data);
6319:
6320: when FND_API.G_EXC_UNEXPECTED_ERROR then
6321: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6319:
6320: when FND_API.G_EXC_UNEXPECTED_ERROR then
6321: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6322:
6323: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6324: p_data => p_msg_data);
6325:
6326: when OTHERS then
6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6329: if FND_MSG_PUB.Check_Msg_Level

6325:
6326: when OTHERS then
6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6328:
6329: if FND_MSG_PUB.Check_Msg_Level
6330: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6331: FND_MSG_PUB.Add_Exc_Msg
6332: (p_pkg_name => G_PKG_NAME,
6333: p_procedure_name => l_api_name);

Line 6330: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6326: when OTHERS then
6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6328:
6329: if FND_MSG_PUB.Check_Msg_Level
6330: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6331: FND_MSG_PUB.Add_Exc_Msg
6332: (p_pkg_name => G_PKG_NAME,
6333: p_procedure_name => l_api_name);
6334: end if;

Line 6331: FND_MSG_PUB.Add_Exc_Msg

6327: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6328:
6329: if FND_MSG_PUB.Check_Msg_Level
6330: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6331: FND_MSG_PUB.Add_Exc_Msg
6332: (p_pkg_name => G_PKG_NAME,
6333: p_procedure_name => l_api_name);
6334: end if;
6335:

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

6332: (p_pkg_name => G_PKG_NAME,
6333: p_procedure_name => l_api_name);
6334: end if;
6335:
6336: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6337: p_data => p_msg_data);
6338:
6339: END Update_Position_Accounts;
6340:

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

6361:
6362: when FND_API.G_EXC_ERROR then
6363: p_return_status := FND_API.G_RET_STS_ERROR;
6364:
6365: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6366: p_data => p_msg_data);
6367:
6368: when FND_API.G_EXC_UNEXPECTED_ERROR then
6369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6367:
6368: when FND_API.G_EXC_UNEXPECTED_ERROR then
6369: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6370:
6371: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6372: p_data => p_msg_data);
6373:
6374: when OTHERS then
6375: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6377: if FND_MSG_PUB.Check_Msg_Level

6373:
6374: when OTHERS then
6375: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6376:
6377: if FND_MSG_PUB.Check_Msg_Level
6378: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6379: FND_MSG_PUB.Add_Exc_Msg
6380: (p_pkg_name => G_PKG_NAME,
6381: p_procedure_name => l_api_name);

Line 6378: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6374: when OTHERS then
6375: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6376:
6377: if FND_MSG_PUB.Check_Msg_Level
6378: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6379: FND_MSG_PUB.Add_Exc_Msg
6380: (p_pkg_name => G_PKG_NAME,
6381: p_procedure_name => l_api_name);
6382: end if;

Line 6379: FND_MSG_PUB.Add_Exc_Msg

6375: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6376:
6377: if FND_MSG_PUB.Check_Msg_Level
6378: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6379: FND_MSG_PUB.Add_Exc_Msg
6380: (p_pkg_name => G_PKG_NAME,
6381: p_procedure_name => l_api_name);
6382: end if;
6383:

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

6380: (p_pkg_name => G_PKG_NAME,
6381: p_procedure_name => l_api_name);
6382: end if;
6383:
6384: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6385: p_data => p_msg_data);
6386:
6387: END Delete_Position_Accounts;
6388:

Line 6459: FND_MSG_PUB.initialize;

6455:
6456: -- Initialize message list if p_init_msg_list is set to TRUE.
6457:
6458: if FND_API.to_Boolean (p_init_msg_list) then
6459: FND_MSG_PUB.initialize;
6460: end if;
6461:
6462: /*For Bug No : 1808322 Start*/
6463: IF p_budget_revision_id IS NOT null THEN

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

6778: commit work;
6779: end if;
6780:
6781: -- Standard call to get message count and if count is 1, get message info.
6782: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6783: p_data => p_msg_data);
6784:
6785: -- Initialize API return status to success
6786: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

6789:
6790: when FND_API.G_EXC_ERROR then
6791: p_return_status := FND_API.G_RET_STS_ERROR;
6792:
6793: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6794: p_data => p_msg_data);
6795:
6796: when FND_API.G_EXC_UNEXPECTED_ERROR then
6797: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6795:
6796: when FND_API.G_EXC_UNEXPECTED_ERROR then
6797: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6798:
6799: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6800: p_data => p_msg_data);
6801:
6802: when OTHERS then
6803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6805: if FND_MSG_PUB.Check_Msg_Level

6801:
6802: when OTHERS then
6803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6804:
6805: if FND_MSG_PUB.Check_Msg_Level
6806: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6807: FND_MSG_PUB.Add_Exc_Msg
6808: (p_pkg_name => G_PKG_NAME,
6809: p_procedure_name => l_api_name);

Line 6806: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6802: when OTHERS then
6803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6804:
6805: if FND_MSG_PUB.Check_Msg_Level
6806: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6807: FND_MSG_PUB.Add_Exc_Msg
6808: (p_pkg_name => G_PKG_NAME,
6809: p_procedure_name => l_api_name);
6810: end if;

Line 6807: FND_MSG_PUB.Add_Exc_Msg

6803: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6804:
6805: if FND_MSG_PUB.Check_Msg_Level
6806: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6807: FND_MSG_PUB.Add_Exc_Msg
6808: (p_pkg_name => G_PKG_NAME,
6809: p_procedure_name => l_api_name);
6810: end if;
6811:

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

6808: (p_pkg_name => G_PKG_NAME,
6809: p_procedure_name => l_api_name);
6810: end if;
6811:
6812: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6813: p_data => p_msg_data);
6814:
6815: END Modify_Position_Accounts;
6816:

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

6852:
6853: when FND_API.G_EXC_ERROR then
6854: p_return_status := FND_API.G_RET_STS_ERROR;
6855:
6856: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6857: p_data => p_msg_data);
6858:
6859: when FND_API.G_EXC_UNEXPECTED_ERROR then
6860: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6858:
6859: when FND_API.G_EXC_UNEXPECTED_ERROR then
6860: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6861:
6862: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6863: p_data => p_msg_data);
6864:
6865: when OTHERS then
6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6868: if FND_MSG_PUB.Check_Msg_Level

6864:
6865: when OTHERS then
6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6867:
6868: if FND_MSG_PUB.Check_Msg_Level
6869: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6870: FND_MSG_PUB.Add_Exc_Msg
6871: (p_pkg_name => G_PKG_NAME,
6872: p_procedure_name => l_api_name);

Line 6869: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6865: when OTHERS then
6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6867:
6868: if FND_MSG_PUB.Check_Msg_Level
6869: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6870: FND_MSG_PUB.Add_Exc_Msg
6871: (p_pkg_name => G_PKG_NAME,
6872: p_procedure_name => l_api_name);
6873: end if;

Line 6870: FND_MSG_PUB.Add_Exc_Msg

6866: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6867:
6868: if FND_MSG_PUB.Check_Msg_Level
6869: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6870: FND_MSG_PUB.Add_Exc_Msg
6871: (p_pkg_name => G_PKG_NAME,
6872: p_procedure_name => l_api_name);
6873: end if;
6874:

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

6906:
6907: when FND_API.G_EXC_ERROR then
6908: p_return_status := FND_API.G_RET_STS_ERROR;
6909:
6910: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6911: p_data => p_msg_data);
6912:
6913: when FND_API.G_EXC_UNEXPECTED_ERROR then
6914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6912:
6913: when FND_API.G_EXC_UNEXPECTED_ERROR then
6914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6915:
6916: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6917: p_data => p_msg_data);
6918:
6919: when OTHERS then
6920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6922: if FND_MSG_PUB.Check_Msg_Level

6918:
6919: when OTHERS then
6920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6921:
6922: if FND_MSG_PUB.Check_Msg_Level
6923: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6924: FND_MSG_PUB.Add_Exc_Msg
6925: (p_pkg_name => G_PKG_NAME,
6926: p_procedure_name => l_api_name);

Line 6923: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6919: when OTHERS then
6920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6921:
6922: if FND_MSG_PUB.Check_Msg_Level
6923: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6924: FND_MSG_PUB.Add_Exc_Msg
6925: (p_pkg_name => G_PKG_NAME,
6926: p_procedure_name => l_api_name);
6927: end if;

Line 6924: FND_MSG_PUB.Add_Exc_Msg

6920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6921:
6922: if FND_MSG_PUB.Check_Msg_Level
6923: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6924: FND_MSG_PUB.Add_Exc_Msg
6925: (p_pkg_name => G_PKG_NAME,
6926: p_procedure_name => l_api_name);
6927: end if;
6928:

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

6925: (p_pkg_name => G_PKG_NAME,
6926: p_procedure_name => l_api_name);
6927: end if;
6928:
6929: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6930: p_data => p_msg_data);
6931:
6932: END Update_Position_Costs;
6933:

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

6954:
6955: when FND_API.G_EXC_ERROR then
6956: p_return_status := FND_API.G_RET_STS_ERROR;
6957:
6958: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6959: p_data => p_msg_data);
6960:
6961: when FND_API.G_EXC_UNEXPECTED_ERROR then
6962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6960:
6961: when FND_API.G_EXC_UNEXPECTED_ERROR then
6962: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6963:
6964: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6965: p_data => p_msg_data);
6966:
6967: when OTHERS then
6968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6970: if FND_MSG_PUB.Check_Msg_Level

6966:
6967: when OTHERS then
6968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6969:
6970: if FND_MSG_PUB.Check_Msg_Level
6971: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6972: FND_MSG_PUB.Add_Exc_Msg
6973: (p_pkg_name => G_PKG_NAME,
6974: p_procedure_name => l_api_name);

Line 6971: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6967: when OTHERS then
6968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6969:
6970: if FND_MSG_PUB.Check_Msg_Level
6971: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6972: FND_MSG_PUB.Add_Exc_Msg
6973: (p_pkg_name => G_PKG_NAME,
6974: p_procedure_name => l_api_name);
6975: end if;

Line 6972: FND_MSG_PUB.Add_Exc_Msg

6968: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6969:
6970: if FND_MSG_PUB.Check_Msg_Level
6971: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6972: FND_MSG_PUB.Add_Exc_Msg
6973: (p_pkg_name => G_PKG_NAME,
6974: p_procedure_name => l_api_name);
6975: end if;
6976:

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

6973: (p_pkg_name => G_PKG_NAME,
6974: p_procedure_name => l_api_name);
6975: end if;
6976:
6977: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6978: p_data => p_msg_data);
6979:
6980: END Delete_Position_Costs;
6981:

Line 7051: FND_MSG_PUB.initialize;

7047:
7048: -- Initialize message list if p_init_msg_list is set to TRUE.
7049:
7050: if FND_API.to_Boolean (p_init_msg_list) then
7051: FND_MSG_PUB.initialize;
7052: end if;
7053:
7054: /*For Bug No : 1808322 Start*/
7055: IF p_budget_revision_id IS NOT null THEN

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

7357: commit work;
7358: end if;
7359:
7360: -- Standard call to get message count and if count is 1, get message info.
7361: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7362: p_data => p_msg_data);
7363:
7364: -- Initialize API return status to success
7365: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

7368:
7369: when FND_API.G_EXC_ERROR then
7370: p_return_status := FND_API.G_RET_STS_ERROR;
7371:
7372: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7373: p_data => p_msg_data);
7374:
7375: when FND_API.G_EXC_UNEXPECTED_ERROR then
7376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7374:
7375: when FND_API.G_EXC_UNEXPECTED_ERROR then
7376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7377:
7378: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7379: p_data => p_msg_data);
7380:
7381: when OTHERS then
7382: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7384: if FND_MSG_PUB.Check_Msg_Level

7380:
7381: when OTHERS then
7382: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7383:
7384: if FND_MSG_PUB.Check_Msg_Level
7385: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7386: FND_MSG_PUB.Add_Exc_Msg
7387: (p_pkg_name => G_PKG_NAME,
7388: p_procedure_name => l_api_name);

Line 7385: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

7381: when OTHERS then
7382: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7383:
7384: if FND_MSG_PUB.Check_Msg_Level
7385: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7386: FND_MSG_PUB.Add_Exc_Msg
7387: (p_pkg_name => G_PKG_NAME,
7388: p_procedure_name => l_api_name);
7389: end if;

Line 7386: FND_MSG_PUB.Add_Exc_Msg

7382: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7383:
7384: if FND_MSG_PUB.Check_Msg_Level
7385: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7386: FND_MSG_PUB.Add_Exc_Msg
7387: (p_pkg_name => G_PKG_NAME,
7388: p_procedure_name => l_api_name);
7389: end if;
7390:

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

7387: (p_pkg_name => G_PKG_NAME,
7388: p_procedure_name => l_api_name);
7389: end if;
7390:
7391: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7392: p_data => p_msg_data);
7393:
7394: END Modify_Position_Costs;
7395:

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

7430:
7431: when FND_API.G_EXC_ERROR then
7432: p_return_status := FND_API.G_RET_STS_ERROR;
7433:
7434: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7435: p_data => p_msg_data);
7436:
7437: when FND_API.G_EXC_UNEXPECTED_ERROR then
7438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7436:
7437: when FND_API.G_EXC_UNEXPECTED_ERROR then
7438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7439:
7440: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7441: p_data => p_msg_data);
7442:
7443: when OTHERS then
7444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7446: if FND_MSG_PUB.Check_Msg_Level

7442:
7443: when OTHERS then
7444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7445:
7446: if FND_MSG_PUB.Check_Msg_Level
7447: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7448: FND_MSG_PUB.Add_Exc_Msg
7449: (p_pkg_name => G_PKG_NAME,
7450: p_procedure_name => l_api_name);

Line 7447: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

7443: when OTHERS then
7444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7445:
7446: if FND_MSG_PUB.Check_Msg_Level
7447: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7448: FND_MSG_PUB.Add_Exc_Msg
7449: (p_pkg_name => G_PKG_NAME,
7450: p_procedure_name => l_api_name);
7451: end if;

Line 7448: FND_MSG_PUB.Add_Exc_Msg

7444: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7445:
7446: if FND_MSG_PUB.Check_Msg_Level
7447: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7448: FND_MSG_PUB.Add_Exc_Msg
7449: (p_pkg_name => G_PKG_NAME,
7450: p_procedure_name => l_api_name);
7451: end if;
7452:

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

7449: (p_pkg_name => G_PKG_NAME,
7450: p_procedure_name => l_api_name);
7451: end if;
7452:
7453: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7454: p_data => p_msg_data);
7455:
7456: END Insert_Position_FTE;
7457:

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

7487:
7488: when FND_API.G_EXC_ERROR then
7489: p_return_status := FND_API.G_RET_STS_ERROR;
7490:
7491: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7492: p_data => p_msg_data);
7493:
7494: when FND_API.G_EXC_UNEXPECTED_ERROR then
7495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7493:
7494: when FND_API.G_EXC_UNEXPECTED_ERROR then
7495: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7496:
7497: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7498: p_data => p_msg_data);
7499:
7500: when OTHERS then
7501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7503: if FND_MSG_PUB.Check_Msg_Level

7499:
7500: when OTHERS then
7501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7502:
7503: if FND_MSG_PUB.Check_Msg_Level
7504: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7505: FND_MSG_PUB.Add_Exc_Msg
7506: (p_pkg_name => G_PKG_NAME,
7507: p_procedure_name => l_api_name);

Line 7504: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

7500: when OTHERS then
7501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7502:
7503: if FND_MSG_PUB.Check_Msg_Level
7504: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7505: FND_MSG_PUB.Add_Exc_Msg
7506: (p_pkg_name => G_PKG_NAME,
7507: p_procedure_name => l_api_name);
7508: end if;

Line 7505: FND_MSG_PUB.Add_Exc_Msg

7501: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7502:
7503: if FND_MSG_PUB.Check_Msg_Level
7504: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7505: FND_MSG_PUB.Add_Exc_Msg
7506: (p_pkg_name => G_PKG_NAME,
7507: p_procedure_name => l_api_name);
7508: end if;
7509:

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

7506: (p_pkg_name => G_PKG_NAME,
7507: p_procedure_name => l_api_name);
7508: end if;
7509:
7510: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7511: p_data => p_msg_data);
7512:
7513: END Update_Position_FTE;
7514:

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

7535:
7536: when FND_API.G_EXC_ERROR then
7537: p_return_status := FND_API.G_RET_STS_ERROR;
7538:
7539: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7540: p_data => p_msg_data);
7541:
7542: when FND_API.G_EXC_UNEXPECTED_ERROR then
7543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7541:
7542: when FND_API.G_EXC_UNEXPECTED_ERROR then
7543: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7544:
7545: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7546: p_data => p_msg_data);
7547:
7548: when OTHERS then
7549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7551: if FND_MSG_PUB.Check_Msg_Level

7547:
7548: when OTHERS then
7549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7550:
7551: if FND_MSG_PUB.Check_Msg_Level
7552: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7553: FND_MSG_PUB.Add_Exc_Msg
7554: (p_pkg_name => G_PKG_NAME,
7555: p_procedure_name => l_api_name);

Line 7552: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

7548: when OTHERS then
7549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7550:
7551: if FND_MSG_PUB.Check_Msg_Level
7552: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7553: FND_MSG_PUB.Add_Exc_Msg
7554: (p_pkg_name => G_PKG_NAME,
7555: p_procedure_name => l_api_name);
7556: end if;

Line 7553: FND_MSG_PUB.Add_Exc_Msg

7549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7550:
7551: if FND_MSG_PUB.Check_Msg_Level
7552: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7553: FND_MSG_PUB.Add_Exc_Msg
7554: (p_pkg_name => G_PKG_NAME,
7555: p_procedure_name => l_api_name);
7556: end if;
7557:

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

7554: (p_pkg_name => G_PKG_NAME,
7555: p_procedure_name => l_api_name);
7556: end if;
7557:
7558: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7559: p_data => p_msg_data);
7560:
7561: END Delete_Position_FTE;
7562:

Line 7628: FND_MSG_PUB.initialize;

7624:
7625: -- Initialize message list if p_init_msg_list is set to TRUE.
7626:
7627: if FND_API.to_Boolean (p_init_msg_list) then
7628: FND_MSG_PUB.initialize;
7629: end if;
7630:
7631: /*For Bug No : 1808322 Start*/
7632: IF p_budget_revision_id IS NOT null THEN

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

7906: commit work;
7907: end if;
7908:
7909: -- Standard call to get message count and if count is 1, get message info.
7910: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7911: p_data => p_msg_data);
7912:
7913: -- Initialize API return status to success
7914: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

7917:
7918: when FND_API.G_EXC_ERROR then
7919: p_return_status := FND_API.G_RET_STS_ERROR;
7920:
7921: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7922: p_data => p_msg_data);
7923:
7924: when FND_API.G_EXC_UNEXPECTED_ERROR then
7925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7923:
7924: when FND_API.G_EXC_UNEXPECTED_ERROR then
7925: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7926:
7927: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7928: p_data => p_msg_data);
7929:
7930: when OTHERS then
7931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7933: if FND_MSG_PUB.Check_Msg_Level

7929:
7930: when OTHERS then
7931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7932:
7933: if FND_MSG_PUB.Check_Msg_Level
7934: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7935: FND_MSG_PUB.Add_Exc_Msg
7936: (p_pkg_name => G_PKG_NAME,
7937: p_procedure_name => l_api_name);

Line 7934: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

7930: when OTHERS then
7931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7932:
7933: if FND_MSG_PUB.Check_Msg_Level
7934: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7935: FND_MSG_PUB.Add_Exc_Msg
7936: (p_pkg_name => G_PKG_NAME,
7937: p_procedure_name => l_api_name);
7938: end if;

Line 7935: FND_MSG_PUB.Add_Exc_Msg

7931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7932:
7933: if FND_MSG_PUB.Check_Msg_Level
7934: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
7935: FND_MSG_PUB.Add_Exc_Msg
7936: (p_pkg_name => G_PKG_NAME,
7937: p_procedure_name => l_api_name);
7938: end if;
7939:

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

7936: (p_pkg_name => G_PKG_NAME,
7937: p_procedure_name => l_api_name);
7938: end if;
7939:
7940: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7941: p_data => p_msg_data);
7942:
7943: END Modify_Position_FTE;
7944:

Line 7992: FND_MSG_PUB.Add;

7988:
7989: if l_org_notmapped then
7990: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
7991: FND_MESSAGE.SET_TOKEN('MESSAGE', ' Org Mapping Failed');
7992: FND_MSG_PUB.Add;
7993: raise FND_API.G_EXC_ERROR;
7994: end if;
7995:
7996: -- Initialize API return status to success

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

8000:
8001: when FND_API.G_EXC_ERROR then
8002: p_return_status := FND_API.G_RET_STS_ERROR;
8003:
8004: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8005: p_data => p_msg_data);
8006:
8007: when FND_API.G_EXC_UNEXPECTED_ERROR then
8008: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

8006:
8007: when FND_API.G_EXC_UNEXPECTED_ERROR then
8008: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8009:
8010: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8011: p_data => p_msg_data);
8012:
8013: when OTHERS then
8014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8016: if FND_MSG_PUB.Check_Msg_Level

8012:
8013: when OTHERS then
8014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8015:
8016: if FND_MSG_PUB.Check_Msg_Level
8017: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8018: FND_MSG_PUB.Add_Exc_Msg
8019: (p_pkg_name => G_PKG_NAME,
8020: p_procedure_name => l_api_name);

Line 8017: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

8013: when OTHERS then
8014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8015:
8016: if FND_MSG_PUB.Check_Msg_Level
8017: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8018: FND_MSG_PUB.Add_Exc_Msg
8019: (p_pkg_name => G_PKG_NAME,
8020: p_procedure_name => l_api_name);
8021: end if;

Line 8018: FND_MSG_PUB.Add_Exc_Msg

8014: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8015:
8016: if FND_MSG_PUB.Check_Msg_Level
8017: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8018: FND_MSG_PUB.Add_Exc_Msg
8019: (p_pkg_name => G_PKG_NAME,
8020: p_procedure_name => l_api_name);
8021: end if;
8022:

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

8019: (p_pkg_name => G_PKG_NAME,
8020: p_procedure_name => l_api_name);
8021: end if;
8022:
8023: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8024: p_data => p_msg_data);
8025:
8026: END Validate_Budget_Group;
8027:

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

8125:
8126: when FND_API.G_EXC_ERROR then
8127: p_return_status := FND_API.G_RET_STS_ERROR;
8128:
8129: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8130: p_data => p_msg_data);
8131:
8132: when FND_API.G_EXC_UNEXPECTED_ERROR then
8133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

8131:
8132: when FND_API.G_EXC_UNEXPECTED_ERROR then
8133: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8134:
8135: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8136: p_data => p_msg_data);
8137:
8138: when OTHERS then
8139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8141: if FND_MSG_PUB.Check_Msg_Level

8137:
8138: when OTHERS then
8139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8140:
8141: if FND_MSG_PUB.Check_Msg_Level
8142: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8143: FND_MSG_PUB.Add_Exc_Msg
8144: (p_pkg_name => G_PKG_NAME,
8145: p_procedure_name => l_api_name);

Line 8142: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

8138: when OTHERS then
8139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8140:
8141: if FND_MSG_PUB.Check_Msg_Level
8142: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8143: FND_MSG_PUB.Add_Exc_Msg
8144: (p_pkg_name => G_PKG_NAME,
8145: p_procedure_name => l_api_name);
8146: end if;

Line 8143: FND_MSG_PUB.Add_Exc_Msg

8139: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8140:
8141: if FND_MSG_PUB.Check_Msg_Level
8142: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8143: FND_MSG_PUB.Add_Exc_Msg
8144: (p_pkg_name => G_PKG_NAME,
8145: p_procedure_name => l_api_name);
8146: end if;
8147:

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

8144: (p_pkg_name => G_PKG_NAME,
8145: p_procedure_name => l_api_name);
8146: end if;
8147:
8148: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8149: p_data => p_msg_data);
8150:
8151: END Validate_Period_Granularity;
8152:

Line 8436: FND_MSG_PUB.Add;

8432:
8433: if (l_no_hr_pos_count > 0) then
8434: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
8435: FND_MESSAGE.SET_TOKEN('MESSAGE', 'No HR Pos Count');
8436: FND_MSG_PUB.Add;
8437: raise FND_API.G_EXC_ERROR;
8438: end if;
8439:
8440: -- Initialize API return status to success

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

8444:
8445: when FND_API.G_EXC_ERROR then
8446: p_return_status := FND_API.G_RET_STS_ERROR;
8447:
8448: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8449: p_data => p_msg_data);
8450:
8451: when FND_API.G_EXC_UNEXPECTED_ERROR then
8452: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

8450:
8451: when FND_API.G_EXC_UNEXPECTED_ERROR then
8452: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8453:
8454: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8455: p_data => p_msg_data);
8456:
8457: when OTHERS then
8458: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8460: if FND_MSG_PUB.Check_Msg_Level

8456:
8457: when OTHERS then
8458: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8459:
8460: if FND_MSG_PUB.Check_Msg_Level
8461: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8462: FND_MSG_PUB.Add_Exc_Msg
8463: (p_pkg_name => G_PKG_NAME,
8464: p_procedure_name => l_api_name);

Line 8461: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

8457: when OTHERS then
8458: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8459:
8460: if FND_MSG_PUB.Check_Msg_Level
8461: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8462: FND_MSG_PUB.Add_Exc_Msg
8463: (p_pkg_name => G_PKG_NAME,
8464: p_procedure_name => l_api_name);
8465: end if;

Line 8462: FND_MSG_PUB.Add_Exc_Msg

8458: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8459:
8460: if FND_MSG_PUB.Check_Msg_Level
8461: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8462: FND_MSG_PUB.Add_Exc_Msg
8463: (p_pkg_name => G_PKG_NAME,
8464: p_procedure_name => l_api_name);
8465: end if;
8466:

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

8463: (p_pkg_name => G_PKG_NAME,
8464: p_procedure_name => l_api_name);
8465: end if;
8466:
8467: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8468: p_data => p_msg_data);
8469:
8470: END Validate_Budget_Document;
8471:

Line 8508: FND_MSG_PUB.Add;

8504:
8505: if l_no_elem_count > 0 then
8506: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
8507: FND_MESSAGE.SET_TOKEN('MESSAGE', 'No Element Count');
8508: FND_MSG_PUB.Add;
8509: raise FND_API.G_EXC_ERROR;
8510: end if;
8511:
8512: -- Initialize API return status to success

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

8516:
8517: when FND_API.G_EXC_ERROR then
8518: p_return_status := FND_API.G_RET_STS_ERROR;
8519:
8520: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8521: p_data => p_msg_data);
8522:
8523: when FND_API.G_EXC_UNEXPECTED_ERROR then
8524: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

8522:
8523: when FND_API.G_EXC_UNEXPECTED_ERROR then
8524: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8525:
8526: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8527: p_data => p_msg_data);
8528:
8529: when OTHERS then
8530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8532: if FND_MSG_PUB.Check_Msg_Level

8528:
8529: when OTHERS then
8530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8531:
8532: if FND_MSG_PUB.Check_Msg_Level
8533: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8534: FND_MSG_PUB.Add_Exc_Msg
8535: (p_pkg_name => G_PKG_NAME,
8536: p_procedure_name => l_api_name);

Line 8533: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

8529: when OTHERS then
8530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8531:
8532: if FND_MSG_PUB.Check_Msg_Level
8533: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8534: FND_MSG_PUB.Add_Exc_Msg
8535: (p_pkg_name => G_PKG_NAME,
8536: p_procedure_name => l_api_name);
8537: end if;

Line 8534: FND_MSG_PUB.Add_Exc_Msg

8530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8531:
8532: if FND_MSG_PUB.Check_Msg_Level
8533: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
8534: FND_MSG_PUB.Add_Exc_Msg
8535: (p_pkg_name => G_PKG_NAME,
8536: p_procedure_name => l_api_name);
8537: end if;
8538:

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

8535: (p_pkg_name => G_PKG_NAME,
8536: p_procedure_name => l_api_name);
8537: end if;
8538:
8539: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8540: p_data => p_msg_data);
8541:
8542: END Validate_Budget_Set;
8543:

Line 8918: FND_MSG_PUB.Add;

8914: l_element_name := l_dist.name(l_dist_index);
8915: fnd_file.put_line(fnd_file.log, ' Element : '||l_element_name||' , Position id : '|| l_hr_position_id);
8916: /* End bug 3666828 */
8917:
8918: FND_MSG_PUB.Add;
8919: raise FND_API.G_EXC_ERROR;
8920: end if;
8921:
8922: for l_index in 1..PSB_WS_ACCT1.g_num_segs loop

Line 9066: FND_MSG_PUB.Add;

9062: l_element_name := l_dist.name(l_dist_index);
9063: fnd_file.put_line(fnd_file.log, 'Element : '||l_element_name||' , Position id : '|| l_hr_position_id);
9064: /* End bug 3666828 */
9065:
9066: FND_MSG_PUB.Add;
9067: raise FND_API.G_EXC_ERROR;
9068: end if;
9069:
9070: g_num_element_dists := g_num_element_dists + 1;

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

9128: CLOSE c_Dist;
9129: END IF;
9130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9131: --
9132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9133: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9134: 'Distribute_Other_Elements');
9135: END IF;
9136: --

Line 9133: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

9129: END IF;
9130: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9131: --
9132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9133: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9134: 'Distribute_Other_Elements');
9135: END IF;
9136: --
9137: END Distribute_Other_Elements;

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

9343:
9344: WHEN OTHERS THEN
9345: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9346: --
9347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9349: 'Distribute_Position_Cost') ;
9350: END IF;
9351: --

Line 9348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

9344: WHEN OTHERS THEN
9345: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9346: --
9347: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9348: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
9349: 'Distribute_Position_Cost') ;
9350: END IF;
9351: --
9352: End Distribute_Position_Cost;

Line 9692: FND_MSG_PUB.Add;

9688: p_effective_date => sysdate);
9689:
9690: EXCEPTION
9691: when OTHERS then
9692: FND_MSG_PUB.Add;
9693: message_token('BUDGET', p_pqh_budget_name);
9694: message_token('VERSION', l_version_number);
9695: message_token('STARTDATE', p_start_date);
9696: message_token('ENDDATE', p_end_date);

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

9707:
9708: when FND_API.G_EXC_ERROR then
9709: p_return_status := FND_API.G_RET_STS_ERROR;
9710:
9711: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9712: p_data => p_msg_data);
9713:
9714: when FND_API.G_EXC_UNEXPECTED_ERROR then
9715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

9713:
9714: when FND_API.G_EXC_UNEXPECTED_ERROR then
9715: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9716:
9717: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9718: p_data => p_msg_data);
9719:
9720: when OTHERS then
9721: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9723: if FND_MSG_PUB.Check_Msg_Level

9719:
9720: when OTHERS then
9721: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9722:
9723: if FND_MSG_PUB.Check_Msg_Level
9724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9725: FND_MSG_PUB.Add_Exc_Msg
9726: (p_pkg_name => G_PKG_NAME,
9727: p_procedure_name => l_api_name);

Line 9724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

9720: when OTHERS then
9721: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9722:
9723: if FND_MSG_PUB.Check_Msg_Level
9724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9725: FND_MSG_PUB.Add_Exc_Msg
9726: (p_pkg_name => G_PKG_NAME,
9727: p_procedure_name => l_api_name);
9728: end if;

Line 9725: FND_MSG_PUB.Add_Exc_Msg

9721: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9722:
9723: if FND_MSG_PUB.Check_Msg_Level
9724: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
9725: FND_MSG_PUB.Add_Exc_Msg
9726: (p_pkg_name => G_PKG_NAME,
9727: p_procedure_name => l_api_name);
9728: end if;
9729:

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

9726: (p_pkg_name => G_PKG_NAME,
9727: p_procedure_name => l_api_name);
9728: end if;
9729:
9730: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9731: p_data => p_msg_data);
9732: END Create_Pqh_Budget_Version;
9733:
9734: /* ----------------------------------------------------------------------- */

Line 9955: FND_MSG_PUB.Add;

9951: p_object_version_number => l_object_version_number);
9952:
9953: EXCEPTION
9954: when OTHERS then
9955: FND_MSG_PUB.Add;
9956: message_token('POSITION', p_position_name);
9957: add_message('PSB', 'PSB_PQH_CREATE_BUDGET_ELEMENT');
9958: raise FND_API.G_EXC_ERROR;
9959: end;

Line 9975: FND_MSG_PUB.Add;

9971: p_object_version_number => c_pqh_budget_elements_rec.object_version_number);
9972:
9973: EXCEPTION
9974: when OTHERS then
9975: FND_MSG_PUB.Add;
9976: message_token('POSITION', p_position_name);
9977: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_ELEMENT');
9978: raise FND_API.G_EXC_ERROR;
9979: end;

Line 9998: FND_MSG_PUB.Add;

9994:
9995: if l_cost_keyflex_id = 0 then
9996: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
9997: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Cost Keyflex not found');
9998: FND_MSG_PUB.Add;
9999: raise FND_API.G_EXC_ERROR;
10000: end if;
10001:
10002: open c_pqh_fund_srcs;

Line 10019: FND_MSG_PUB.Add;

10015: p_object_version_number => l_fund_object_version_number);
10016:
10017: EXCEPTION
10018: when OTHERS then
10019: FND_MSG_PUB.Add;
10020: message_token('POSITION', p_position_name);
10021: add_message('PSB', 'PSB_PQH_CREATE_BUDGET_FUND_SRC');
10022: raise FND_API.G_EXC_ERROR;
10023: end;

Line 10039: FND_MSG_PUB.Add;

10035: p_object_version_number => c_pqh_fund_srcs_rec.object_version_number);
10036:
10037: EXCEPTION
10038: when OTHERS then
10039: FND_MSG_PUB.Add;
10040: message_token('POSITION', p_position_name);
10041: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_FUND_SRC');
10042: raise FND_API.G_EXC_ERROR;
10043:

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

10059:
10060: when FND_API.G_EXC_ERROR then
10061: p_return_status := FND_API.G_RET_STS_ERROR;
10062:
10063: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
10064: p_data => p_msg_data);
10065:
10066: when FND_API.G_EXC_UNEXPECTED_ERROR then
10067: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

10065:
10066: when FND_API.G_EXC_UNEXPECTED_ERROR then
10067: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10068:
10069: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
10070: p_data => p_msg_data);
10071:
10072: when OTHERS then
10073: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10075: if FND_MSG_PUB.Check_Msg_Level

10071:
10072: when OTHERS then
10073: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10074:
10075: if FND_MSG_PUB.Check_Msg_Level
10076: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
10077: FND_MSG_PUB.Add_Exc_Msg
10078: (p_pkg_name => G_PKG_NAME,
10079: p_procedure_name => l_api_name);

Line 10076: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

10072: when OTHERS then
10073: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10074:
10075: if FND_MSG_PUB.Check_Msg_Level
10076: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
10077: FND_MSG_PUB.Add_Exc_Msg
10078: (p_pkg_name => G_PKG_NAME,
10079: p_procedure_name => l_api_name);
10080: end if;

Line 10077: FND_MSG_PUB.Add_Exc_Msg

10073: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10074:
10075: if FND_MSG_PUB.Check_Msg_Level
10076: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
10077: FND_MSG_PUB.Add_Exc_Msg
10078: (p_pkg_name => G_PKG_NAME,
10079: p_procedure_name => l_api_name);
10080: end if;
10081:

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

10078: (p_pkg_name => G_PKG_NAME,
10079: p_procedure_name => l_api_name);
10080: end if;
10081:
10082: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
10083: p_data => p_msg_data);
10084:
10085: END Create_Pqh_Budget_Elements;
10086:

Line 10375: FND_MSG_PUB.Add;

10371: p_object_version_number => l_object_version_number);
10372:
10373: EXCEPTION
10374: WHEN OTHERS THEN
10375: FND_MSG_PUB.Add;
10376: message_token('POSITION', p_position_name);
10377: add_message('PSB', 'PSB_PQH_CREATE_BUDGET_PERIOD');
10378: raise FND_API.G_EXC_ERROR;
10379: end;

Line 10401: FND_MSG_PUB.Add;

10397: p_object_version_number => c_pqh_budget_periods_rec.object_version_number);
10398:
10399: EXCEPTION
10400: when OTHERS then
10401: FND_MSG_PUB.Add;
10402: message_token('POSITION', p_position_name);
10403: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_PERIOD');
10404: raise FND_API.G_EXC_ERROR;
10405: end;

Line 10461: FND_MSG_PUB.Add;

10457: p_effective_date => sysdate);
10458:
10459: EXCEPTION
10460: when OTHERS then
10461: FND_MSG_PUB.Add;
10462: message_token('POSITION', p_position_name);
10463: add_message('PSB', 'PSB_PQH_CREATE_BUDGET_SET');
10464: raise FND_API.G_EXC_ERROR;
10465:

Line 10489: FND_MSG_PUB.Add;

10485: p_effective_date => sysdate);
10486:
10487: EXCEPTION
10488: when OTHERS then
10489: FND_MSG_PUB.Add;
10490: message_token('POSITION', p_position_name);
10491: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_SET');
10492: raise FND_API.G_EXC_ERROR;
10493: end;

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

10547: if c_budget_set_cost%ISOPEN then
10548: close c_budget_set_cost;
10549: end if;
10550: p_return_status := FND_API.G_RET_STS_ERROR;
10551: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
10552: p_data => p_msg_data);
10553:
10554: when FND_API.G_EXC_UNEXPECTED_ERROR then
10555: if c_period_rec%ISOPEN then

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

10558: if c_budget_set_cost%ISOPEN then
10559: close c_budget_set_cost;
10560: end if;
10561: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10562: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
10563: p_data => p_msg_data);
10564:
10565: when OTHERS then
10566: if c_period_rec%ISOPEN then

Line 10574: if FND_MSG_PUB.Check_Msg_Level

10570: close c_budget_set_cost;
10571: end if;
10572: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10573:
10574: if FND_MSG_PUB.Check_Msg_Level
10575: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
10576: FND_MSG_PUB.Add_Exc_Msg
10577: (p_pkg_name => G_PKG_NAME,
10578: p_procedure_name => l_api_name);

Line 10575: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

10571: end if;
10572: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10573:
10574: if FND_MSG_PUB.Check_Msg_Level
10575: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
10576: FND_MSG_PUB.Add_Exc_Msg
10577: (p_pkg_name => G_PKG_NAME,
10578: p_procedure_name => l_api_name);
10579: end if;

Line 10576: FND_MSG_PUB.Add_Exc_Msg

10572: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10573:
10574: if FND_MSG_PUB.Check_Msg_Level
10575: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
10576: FND_MSG_PUB.Add_Exc_Msg
10577: (p_pkg_name => G_PKG_NAME,
10578: p_procedure_name => l_api_name);
10579: end if;
10580:

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

10577: (p_pkg_name => G_PKG_NAME,
10578: p_procedure_name => l_api_name);
10579: end if;
10580:
10581: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
10582: p_data => p_msg_data);
10583:
10584: END Create_Pqh_Budget_Periods;
10585:

Line 11194: FND_MSG_PUB.Add;

11190: p_object_version_number => l_object_version_number);
11191:
11192: EXCEPTION
11193: WHEN OTHERS THEN
11194: FND_MSG_PUB.Add;
11195: message_token('POSITION', l_position_name);
11196: add_message('PSB', 'PSB_PQH_CREATE_BUDGET_DETAIL');
11197: raise FND_API.G_EXC_ERROR;
11198:

Line 11247: FND_MSG_PUB.Add;

11243: p_object_version_number => c_pqh_budget_details_rec.object_version_number);
11244:
11245: EXCEPTION
11246: when OTHERS then
11247: FND_MSG_PUB.Add;
11248: message_token('POSITION', l_position_name);
11249: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_DETAIL');
11250: raise FND_API.G_EXC_ERROR;
11251:

Line 11327: FND_MSG_PUB.Add;

11323: p_object_version_number => l_new_object_version_number);
11324:
11325: EXCEPTION
11326: when OTHERS then
11327: FND_MSG_PUB.Add;
11328: message_token('POSITION', l_position_name);
11329: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_DETAIL');
11330: raise FND_API.G_EXC_ERROR;
11331:

Line 11360: FND_MSG_PUB.Add;

11356: p_object_version_number => l_new_object_version_number);
11357:
11358: EXCEPTION
11359: when OTHERS then
11360: FND_MSG_PUB.Add;
11361: message_token('POSITION', l_position_name);
11362: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_DETAIL');
11363: raise FND_API.G_EXC_ERROR;
11364:

Line 11393: FND_MSG_PUB.Add;

11389: p_object_version_number => l_new_object_version_number);
11390:
11391: EXCEPTION
11392: when OTHERS then
11393: FND_MSG_PUB.Add;
11394: message_token('POSITION', l_position_name);
11395: add_message('PSB', 'PSB_PQH_UPDATE_BUDGET_DETAIL');
11396: raise FND_API.G_EXC_ERROR;
11397:

Line 11442: FND_MSG_PUB.Add;

11438: p_effective_date => sysdate);
11439:
11440: EXCEPTION
11441: when OTHERS then
11442: FND_MSG_PUB.Add;
11443: message_token('BUDGET', p_pqh_budget_name);
11444: message_token('VERSION', l_version_number);
11445: message_token('STARTDATE', l_start_date);
11446: message_token('ENDDATE', l_end_date);

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

11488: if c_position%ISOPEN then
11489: close c_position;
11490: end if;
11491: p_return_status := FND_API.G_RET_STS_ERROR;
11492: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11493: p_data => p_msg_data);
11494:
11495: when FND_API.G_EXC_UNEXPECTED_ERROR then
11496: if c_position%ISOPEN then

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

11496: if c_position%ISOPEN then
11497: close c_position;
11498: end if;
11499: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11500: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11501: p_data => p_msg_data);
11502:
11503: when OTHERS then
11504: if c_position%ISOPEN then

Line 11509: if FND_MSG_PUB.Check_Msg_Level

11505: close c_position;
11506: end if;
11507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11508:
11509: if FND_MSG_PUB.Check_Msg_Level
11510: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
11511: FND_MSG_PUB.Add_Exc_Msg
11512: (p_pkg_name => G_PKG_NAME,
11513: p_procedure_name => l_api_name);

Line 11510: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

11506: end if;
11507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11508:
11509: if FND_MSG_PUB.Check_Msg_Level
11510: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
11511: FND_MSG_PUB.Add_Exc_Msg
11512: (p_pkg_name => G_PKG_NAME,
11513: p_procedure_name => l_api_name);
11514: end if;

Line 11511: FND_MSG_PUB.Add_Exc_Msg

11507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11508:
11509: if FND_MSG_PUB.Check_Msg_Level
11510: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
11511: FND_MSG_PUB.Add_Exc_Msg
11512: (p_pkg_name => G_PKG_NAME,
11513: p_procedure_name => l_api_name);
11514: end if;
11515:

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

11512: (p_pkg_name => G_PKG_NAME,
11513: p_procedure_name => l_api_name);
11514: end if;
11515:
11516: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11517: p_data => p_msg_data);
11518:
11519: END Create_Pqh_Budget_detail;
11520:

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

11891: commit work;
11892: END IF;
11893:
11894: -- Standard call to get message count and if count is 1, get message info.
11895: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11896: p_data => p_msg_data);
11897:
11898:
11899: -- Initialize API return status to success

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

11903:
11904: when FND_API.G_EXC_ERROR then
11905: p_return_status := FND_API.G_RET_STS_ERROR;
11906:
11907: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11908: p_data => p_msg_data);
11909:
11910: when FND_API.G_EXC_UNEXPECTED_ERROR then
11911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

11909:
11910: when FND_API.G_EXC_UNEXPECTED_ERROR then
11911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11912:
11913: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11914: p_data => p_msg_data);
11915:
11916: when OTHERS then
11917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11919: if FND_MSG_PUB.Check_Msg_Level

11915:
11916: when OTHERS then
11917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11918:
11919: if FND_MSG_PUB.Check_Msg_Level
11920: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
11921: FND_MSG_PUB.Add_Exc_Msg
11922: (p_pkg_name => G_PKG_NAME,
11923: p_procedure_name => l_api_name);

Line 11920: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

11916: when OTHERS then
11917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11918:
11919: if FND_MSG_PUB.Check_Msg_Level
11920: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
11921: FND_MSG_PUB.Add_Exc_Msg
11922: (p_pkg_name => G_PKG_NAME,
11923: p_procedure_name => l_api_name);
11924: end if;

Line 11921: FND_MSG_PUB.Add_Exc_Msg

11917: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11918:
11919: if FND_MSG_PUB.Check_Msg_Level
11920: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
11921: FND_MSG_PUB.Add_Exc_Msg
11922: (p_pkg_name => G_PKG_NAME,
11923: p_procedure_name => l_api_name);
11924: end if;
11925:

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

11922: (p_pkg_name => G_PKG_NAME,
11923: p_procedure_name => l_api_name);
11924: end if;
11925:
11926: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
11927: p_data => p_msg_data);
11928:
11929: END Upload_Budget_HRMS;
11930:

Line 11977: FND_MSG_PUB.initialize;

11973:
11974: -- Initialize message list if p_init_msg_list is set to TRUE.
11975:
11976: if FND_API.to_Boolean (p_init_msg_list) then
11977: FND_MSG_PUB.initialize;
11978: end if;
11979:
11980: l_sysorg_id := NULL;
11981:

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

12106: commit work;
12107: END IF;
12108:
12109: -- Standard call to get message count and if count is 1, get message info.
12110: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
12111: p_data => p_msg_data);
12112:
12113:
12114: -- Initialize API return status to success

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

12119: when FND_API.G_EXC_ERROR then
12120: rollback to Convert_Organization_Attr;
12121: p_return_status := FND_API.G_RET_STS_ERROR;
12122:
12123: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
12124: p_data => p_msg_data);
12125:
12126: when FND_API.G_EXC_UNEXPECTED_ERROR then
12127: rollback to Convert_Organization_Attr;

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

12126: when FND_API.G_EXC_UNEXPECTED_ERROR then
12127: rollback to Convert_Organization_Attr;
12128: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12129:
12130: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
12131: p_data => p_msg_data);
12132:
12133: when OTHERS then
12134: rollback to Convert_Organization_Attr;

Line 12137: if FND_MSG_PUB.Check_Msg_Level

12133: when OTHERS then
12134: rollback to Convert_Organization_Attr;
12135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12136:
12137: if FND_MSG_PUB.Check_Msg_Level
12138: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
12139: FND_MSG_PUB.Add_Exc_Msg
12140: (p_pkg_name => G_PKG_NAME,
12141: p_procedure_name => l_api_name);

Line 12138: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

12134: rollback to Convert_Organization_Attr;
12135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12136:
12137: if FND_MSG_PUB.Check_Msg_Level
12138: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
12139: FND_MSG_PUB.Add_Exc_Msg
12140: (p_pkg_name => G_PKG_NAME,
12141: p_procedure_name => l_api_name);
12142: end if;

Line 12139: FND_MSG_PUB.Add_Exc_Msg

12135: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12136:
12137: if FND_MSG_PUB.Check_Msg_Level
12138: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
12139: FND_MSG_PUB.Add_Exc_Msg
12140: (p_pkg_name => G_PKG_NAME,
12141: p_procedure_name => l_api_name);
12142: end if;
12143:

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

12140: (p_pkg_name => G_PKG_NAME,
12141: p_procedure_name => l_api_name);
12142: end if;
12143:
12144: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
12145: p_data => p_msg_data);
12146:
12147: END Convert_Organization_Attr;
12148:

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

12198: p_print_header => FND_API.G_TRUE);
12199: retcode := 2;
12200:
12201: when OTHERS then
12202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
12203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
12204: l_api_name);
12205: end if;
12206:

Line 12203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

12199: retcode := 2;
12200:
12201: when OTHERS then
12202: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
12203: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
12204: l_api_name);
12205: end if;
12206:
12207: PSB_MESSAGE_S.Print_Error (p_mode => FND_FILE.LOG,