DBA Data[Home] [Help]

APPS.PA_STATUS_LIST_ITEMS_PVT dependencies on FND_API

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: x_msg_data := NULL;
34:
35:
36: -- Initialize the return status to success
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39:
40: PA_STATUS_LIST_ITEMS_PKG.INSERT_ROW
41: (

Line 59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

55: EXCEPTION
56: WHEN OTHERS THEN
57: x_msg_count := 1;
58: x_msg_data := substr(SQLERRM,1,240);
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60: FND_MSG_PUB.add_exc_msg
61: (p_pkg_name => 'PA_STATUS_LIST_ITEMS_PVT'
62: , p_procedure_name => PA_DEBUG.G_Err_Stack
63: , p_error_text => substr(SQLERRM,1,240));

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: x_msg_count := 0;
99: x_msg_data := NULL;
100:
101: -- Initialize the return status to success
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104:
105: PA_STATUS_LIST_ITEMS_PKG.UPDATE_ROW
106: (

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

121: EXCEPTION
122: WHEN OTHERS THEN
123: x_msg_count := 1;
124: x_msg_data := substr(SQLERRM,1,240);
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.add_exc_msg
127: (p_pkg_name => 'PA_STATUS_LIST_ITEMS_PVT'
128: , p_procedure_name => PA_DEBUG.G_Err_Stack
129: , p_error_text => substr(SQLERRM,1,240));

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162: x_msg_count := 0;
163: x_msg_data := NULL;
164:
165: -- Initialize the return status to success
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168:
169: -- Delete Role
170: PA_STATUS_LIST_ITEMS_PKG.DELETE_ROW

Line 183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

179: EXCEPTION
180: WHEN OTHERS THEN
181: x_msg_count := 1;
182: x_msg_data := substr(SQLERRM,1,240);
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: FND_MSG_PUB.add_exc_msg
185: (p_pkg_name => 'PA_STATUS_LIST_ITEMS_PVT'
186: , p_procedure_name => PA_DEBUG.G_Err_Stack
187: , p_error_text => substr(SQLERRM,1,240));