APPS.PA_SYSTEM_NUMBERS_PKG dependencies on FND_API

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: BEGIN
47:
48: pa_debug.init_err_stack('PA_SYSTEM_NUMBERS_PKG:GET_NEXT_NUMBER');
49:
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:
52: if p_system_number_id is null then
53: if p_object1_pk1_value is null OR p_object1_type is null then
54: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52: if p_system_number_id is null then
53: if p_object1_pk1_value is null OR p_object1_type is null then
54: PA_UTILS.Add_Message( p_app_short_name => 'PA'
55: ,p_msg_name => 'PA_CI_SYS_NUM_NULL_VALUES');
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: PA_DEBUG.RESET_ERR_STACK;
58: return;
59: end if;
60: end if;

Line 111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

107: l_system_id,null,null,null,null,l_next_number+1,x_return_status,x_msg_count,x_msg_data);
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
112: RAISE;
113:
114: end GET_NEXT_NUMBER;
115:

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138:
139:
140: BEGIN
141:
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: --get the unique system number id from the Oracle Sequence
145: /* Commented for bug 3866224 to remove hard coded schema reference and modified as below
146: SELECT pa.pa_system_numbers_s.nextval */

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196: -- set error message: in case more than user CREATED a new row
197: WHEN DUP_VAL_ON_INDEX then
198: PA_UTILS.Add_Message( p_app_short_name => 'PA'
199: ,p_msg_name => 'PA_UPDATE_FAILED');
200: x_return_status := FND_API.G_RET_STS_ERROR;
201:
202:
203: WHEN OTHERS THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

200: x_return_status := FND_API.G_RET_STS_ERROR;
201:
202:
203: WHEN OTHERS THEN
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
205: RAISE;
206:
207: end INSERT_ROW;
208:

Line 223: x_return_status := FND_API.G_RET_STS_SUCCESS;

219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2
221: ) is
222: begin
223: x_return_status := FND_API.G_RET_STS_SUCCESS;
224:
225: update PA_SYSTEM_NUMBERS set
226: object1_pk1_value = Nvl(p_object1_pk1_value,object1_pk1_value)
227: ,object1_type = Nvl(p_object1_type,object1_type)

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: nvl(p_object2_type,' ') = nvl(p_object2_type,' ') );
239:
240: if (sql%notfound) then
241: PA_UTILS.Add_Message ( p_app_short_name => 'PA',p_msg_name => 'PA_CI_SYS_NUM_NOT_FOUND');
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: end if;
244:
245: EXCEPTION
246: WHEN OTHERS THEN

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: end if;
244:
245: EXCEPTION
246: WHEN OTHERS THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: RAISE;
249: end UPDATE_ROW;
250:
251:

Line 267: x_return_status := FND_API.G_RET_STS_SUCCESS;

263: ,x_msg_data OUT NOCOPY VARCHAR2
264:
265: ) is
266: begin
267: x_return_status := FND_API.G_RET_STS_SUCCESS;
268:
269: DELETE FROM PA_SYSTEM_NUMBERS
270: where system_number_id = nvl(p_system_number_id,0)
271: OR (object1_pk1_value = p_object1_pk1_value AND

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276:
277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: RAISE;
282: end DELETE_ROW;
283:
284: END PA_SYSTEM_NUMBERS_PKG;