DBA Data[Home] [Help]

APPS.GMI_ITEM_LOT_CONV_WRP dependencies on FND_API

Line 98: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;

94:
95: /* Local variables */
96:
97: l_status VARCHAR2(1);
98: l_return_status VARCHAR2(1) :=FND_API.G_RET_STS_SUCCESS;
99: l_count NUMBER ;
100: l_dummy_cnt NUMBER :=0;
101: l_loop_cnt NUMBER :=0;
102: l_record_count NUMBER :=0;

Line 204: , p_init_msg_list => FND_API.G_TRUE

200: /* dbms_output.put_line('Calling creation routine'); */
201:
202: GMIPAPI.Create_Item_Lot_Conv
203: ( p_api_version => 3.0
204: , p_init_msg_list => FND_API.G_TRUE
205: , p_commit => FND_API.G_TRUE
206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
207: , p_conv_rec => item_cnv_rec
208: , x_ic_item_cnv_row => l_ic_item_cnv_row

Line 205: , p_commit => FND_API.G_TRUE

201:
202: GMIPAPI.Create_Item_Lot_Conv
203: ( p_api_version => 3.0
204: , p_init_msg_list => FND_API.G_TRUE
205: , p_commit => FND_API.G_TRUE
206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
207: , p_conv_rec => item_cnv_rec
208: , x_ic_item_cnv_row => l_ic_item_cnv_row
209: , x_return_status =>l_status

Line 206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

202: GMIPAPI.Create_Item_Lot_Conv
203: ( p_api_version => 3.0
204: , p_init_msg_list => FND_API.G_TRUE
205: , p_commit => FND_API.G_TRUE
206: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
207: , p_conv_rec => item_cnv_rec
208: , x_ic_item_cnv_row => l_ic_item_cnv_row
209: , x_return_status =>l_status
210: , x_msg_count =>l_count

Line 222: p_encoded => FND_API.G_FALSE,

218:
219: FND_MSG_PUB.Get(
220: p_msg_index => l_loop_cnt,
221: p_data => l_data,
222: p_encoded => FND_API.G_FALSE,
223: p_msg_index_out => l_dummy_cnt);
224:
225: /* dbms_output.put_line('Message ' || l_data ); */
226:

Line 275: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

271: EXCEPTION
272: WHEN UTL_FILE.INVALID_OPERATION THEN
273: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
274: UTL_FILE.FCLOSE_ALL;
275: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
276:
277: WHEN UTL_FILE.INVALID_PATH THEN
278: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
279: UTL_FILE.FCLOSE_ALL;

Line 280: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

276:
277: WHEN UTL_FILE.INVALID_PATH THEN
278: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
279: UTL_FILE.FCLOSE_ALL;
280: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: WHEN UTL_FILE.INVALID_MODE THEN
283: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
284: UTL_FILE.FCLOSE_ALL;

Line 285: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

281:
282: WHEN UTL_FILE.INVALID_MODE THEN
283: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
284: UTL_FILE.FCLOSE_ALL;
285: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
286:
287: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
288: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
289: UTL_FILE.FCLOSE_ALL;

Line 290: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

286:
287: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
288: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
289: UTL_FILE.FCLOSE_ALL;
290: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
291:
292: WHEN UTL_FILE.WRITE_ERROR THEN
293: /* dbms_output.put_line('Invalid Write Error '|| l_global_file);*/
294: UTL_FILE.FCLOSE_ALL;

Line 295: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

291:
292: WHEN UTL_FILE.WRITE_ERROR THEN
293: /* dbms_output.put_line('Invalid Write Error '|| l_global_file);*/
294: UTL_FILE.FCLOSE_ALL;
295: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
296:
297: WHEN UTL_FILE.READ_ERROR THEN
298: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
299: UTL_FILE.FCLOSE_ALL;

Line 300: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

296:
297: WHEN UTL_FILE.READ_ERROR THEN
298: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
299: UTL_FILE.FCLOSE_ALL;
300: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
301:
302: WHEN UTL_FILE.INTERNAL_ERROR THEN
303: /* dbms_output.put_line('Internal Error'); */
304: UTL_FILE.FCLOSE_ALL;

Line 305: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

301:
302: WHEN UTL_FILE.INTERNAL_ERROR THEN
303: /* dbms_output.put_line('Internal Error'); */
304: UTL_FILE.FCLOSE_ALL;
305: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
306:
307: WHEN OTHERS THEN
308: /* dbms_output.put_line('Other Error'); */
309: UTL_FILE.FCLOSE_ALL;

Line 310: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

306:
307: WHEN OTHERS THEN
308: /* dbms_output.put_line('Other Error'); */
309: UTL_FILE.FCLOSE_ALL;
310: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: END Create_Conv;
313:
314: /* +==========================================================================+