DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on FND_API

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR;

1042: x_where_clause := l_where_clause;
1043:
1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1047: WHEN FND_API.G_EXC_ERROR THEN

1043:
1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: BIS_UTILITIES_PVT.Add_Error_Message

Line 1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: BIS_UTILITIES_PVT.Add_Error_Message
1052: (p_error_msg_id => SQLCODE

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: BIS_UTILITIES_PVT.Add_Error_Message
1052: (p_error_msg_id => SQLCODE
1053: ,p_error_description => SQLERRM
1054: ,p_error_proc_name => 'POA_REPORT_UTIL.Retrieve_Org_Where_Clause'

Line 1076: x_return_status := FND_API.G_RET_STS_SUCCESS;

1072:
1073: l_rec POA_REPORT_UTIL.SOB_Rec_Type;
1074:
1075: BEGIN
1076: x_return_status := FND_API.G_RET_STS_SUCCESS;
1077:
1078:
1079: FOR i IN 1..x_Responsibility_tbl.COUNT LOOP
1080: FOR cr in sob_cur(x_Responsibility_tbl(i).Responsibility_ID) LOOP

Line 1088: x_return_status := FND_API.G_RET_STS_ERROR;

1084: END LOOP;
1085:
1086: EXCEPTION
1087: WHEN NO_DATA_FOUND THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE FND_API.G_EXC_ERROR;
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085:
1086: EXCEPTION
1087: WHEN NO_DATA_FOUND THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE FND_API.G_EXC_ERROR;
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: WHEN others THEN

Line 1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then

1086: EXCEPTION
1087: WHEN NO_DATA_FOUND THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE FND_API.G_EXC_ERROR;
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: WHEN others THEN
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1087: WHEN NO_DATA_FOUND THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE FND_API.G_EXC_ERROR;
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: WHEN others THEN
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: BIS_UTILITIES_PVT.Add_Error_Message

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE FND_API.G_EXC_ERROR;
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: WHEN others THEN
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: BIS_UTILITIES_PVT.Add_Error_Message
1096: ( p_error_msg_id => SQLCODE

Line 1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093: WHEN others THEN
1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1095: BIS_UTILITIES_PVT.Add_Error_Message
1096: ( p_error_msg_id => SQLCODE
1097: ,p_error_description => SQLERRM
1098: ,p_error_proc_name => 'POA_REPORT_UTIL.Retrieve_Set_of_Books_Id'

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1096: ( p_error_msg_id => SQLCODE
1097: ,p_error_description => SQLERRM
1098: ,p_error_proc_name => 'POA_REPORT_UTIL.Retrieve_Set_of_Books_Id'
1099: );
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101:
1102: END Retrieve_Set_of_Books_Id;
1103:
1104: END POA_REPORT_UTIL;