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.GMI_SHIPPING_UTIL dependencies on FND_API

Line 203: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199: /* B1504749, 21-Nov-2000 odaboval : added CLOSE cursor here. */
200: --CLOSE get_opm_transaction_c;
201:
202: GMI_RESERVATION_UTIL.println('OPM Transaction Not Found');
203: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: EXIT; /* Exit after First Select */
206: END LOOP;
207:

Line 239: RAISE FND_API.G_EXC_ERROR;

235: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
236: FND_MESSAGE.Set_Token('BY_PROC', 'Update default staged indicator');
237: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_Backorder_Txn');
238: FND_MSG_PUB.Add;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: /* BUG 1577035 END
242: ================== */
243: ELSE

Line 263: , FND_API.G_FALSE

259: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
260:
261: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
262: ( 1
263: , FND_API.G_FALSE
264: , FND_API.G_FALSE
265: , FND_API.G_VALID_LEVEL_FULL
266: , l_old_transaction_rec
267: , l_old_transaction_row

Line 264: , FND_API.G_FALSE

260:
261: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
262: ( 1
263: , FND_API.G_FALSE
264: , FND_API.G_FALSE
265: , FND_API.G_VALID_LEVEL_FULL
266: , l_old_transaction_rec
267: , l_old_transaction_row
268: , x_return_status

Line 265: , FND_API.G_VALID_LEVEL_FULL

261: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
262: ( 1
263: , FND_API.G_FALSE
264: , FND_API.G_FALSE
265: , FND_API.G_VALID_LEVEL_FULL
266: , l_old_transaction_rec
267: , l_old_transaction_row
268: , x_return_status
269: , x_msg_count

Line 273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

269: , x_msg_count
270: , x_msg_data
271: );
272:
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
274: THEN
275: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;

Line 276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

272:
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
274: THEN
275: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: /* I am Assuming That There Will Always Be A Default Transaction. */
280: /* So Lets Get It. */

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: FETCH default_transaction_c INTO l_trans_id, l_staged_ind;
290: IF default_transaction_c%NOTFOUND THEN
291: Close default_transaction_c;
292: GMI_RESERVATION_UTIL.println('Default Transaction Not Found');
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295: Close default_transaction_c;
296:
297: /* Set Trans Id To fetch */

Line 314: , FND_API.G_FALSE

310: PRINT_DEBUG (l_new_transaction_rec,' Update Default Transaction');
311:
312: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
313: ( 1
314: , FND_API.G_FALSE
315: , FND_API.G_FALSE
316: , FND_API.G_VALID_LEVEL_FULL
317: , l_new_transaction_rec
318: , l_new_transaction_row

Line 315: , FND_API.G_FALSE

311:
312: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
313: ( 1
314: , FND_API.G_FALSE
315: , FND_API.G_FALSE
316: , FND_API.G_VALID_LEVEL_FULL
317: , l_new_transaction_rec
318: , l_new_transaction_row
319: , x_return_status

Line 316: , FND_API.G_VALID_LEVEL_FULL

312: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
313: ( 1
314: , FND_API.G_FALSE
315: , FND_API.G_FALSE
316: , FND_API.G_VALID_LEVEL_FULL
317: , l_new_transaction_rec
318: , l_new_transaction_row
319: , x_return_status
320: , x_msg_count

Line 324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

320: , x_msg_count
321: , x_msg_data
322: );
323:
324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
325: THEN
326: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

323:
324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
325: THEN
326: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329: END IF;
330:
331: ELSE

Line 346: , FND_API.G_FALSE

342: GMI_RESERVATION_UTIL.println('Backout Original Staged Qty ' || l_old_transaction_rec.trans_qty);
343:
344: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
345: ( 1
346: , FND_API.G_FALSE
347: , FND_API.G_FALSE
348: , FND_API.G_VALID_LEVEL_FULL
349: , l_old_transaction_rec
350: , l_old_transaction_row

Line 347: , FND_API.G_FALSE

343:
344: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
345: ( 1
346: , FND_API.G_FALSE
347: , FND_API.G_FALSE
348: , FND_API.G_VALID_LEVEL_FULL
349: , l_old_transaction_rec
350: , l_old_transaction_row
351: , x_return_status

Line 348: , FND_API.G_VALID_LEVEL_FULL

344: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
345: ( 1
346: , FND_API.G_FALSE
347: , FND_API.G_FALSE
348: , FND_API.G_VALID_LEVEL_FULL
349: , l_old_transaction_rec
350: , l_old_transaction_row
351: , x_return_status
352: , x_msg_count

Line 356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

352: , x_msg_count
353: , x_msg_data
354: );
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
357: THEN
358: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
357: THEN
358: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361:
362: /* Reduce the existing transaction quantity by the amount */
363: /* being back-ordered (any trans_qty2 figures are reduced */

Line 393: , FND_API.G_FALSE

389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
390:
391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
392: ( 1
393: , FND_API.G_FALSE
394: , FND_API.G_FALSE
395: , FND_API.G_VALID_LEVEL_FULL
396: , l_new_transaction_rec
397: , l_new_transaction_row

Line 394: , FND_API.G_FALSE

390:
391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
392: ( 1
393: , FND_API.G_FALSE
394: , FND_API.G_FALSE
395: , FND_API.G_VALID_LEVEL_FULL
396: , l_new_transaction_rec
397: , l_new_transaction_row
398: , x_return_status

Line 395: , FND_API.G_VALID_LEVEL_FULL

391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
392: ( 1
393: , FND_API.G_FALSE
394: , FND_API.G_FALSE
395: , FND_API.G_VALID_LEVEL_FULL
396: , l_new_transaction_rec
397: , l_new_transaction_row
398: , x_return_status
399: , x_msg_count

Line 403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

399: , x_msg_count
400: , x_msg_data
401: );
402:
403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
404: THEN
405: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;

Line 406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

402:
403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
404: THEN
405: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:
409: /* We now need to sort out the transaction for the default lot. */
410: /* There are three cases to consider and the cursor will retrieve */

Line 449: , FND_API.G_FALSE

445: PRINT_DEBUG (l_old_transaction_rec,'Create Default Back Order');
446:
447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
448: ( 1
449: , FND_API.G_FALSE
450: , FND_API.G_FALSE
451: , FND_API.G_VALID_LEVEL_FULL
452: , l_new_transaction_rec
453: , l_new_transaction_row

Line 450: , FND_API.G_FALSE

446:
447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
448: ( 1
449: , FND_API.G_FALSE
450: , FND_API.G_FALSE
451: , FND_API.G_VALID_LEVEL_FULL
452: , l_new_transaction_rec
453: , l_new_transaction_row
454: , x_return_status

Line 451: , FND_API.G_VALID_LEVEL_FULL

447: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
448: ( 1
449: , FND_API.G_FALSE
450: , FND_API.G_FALSE
451: , FND_API.G_VALID_LEVEL_FULL
452: , l_new_transaction_rec
453: , l_new_transaction_row
454: , x_return_status
455: , x_msg_count

Line 459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

455: , x_msg_count
456: , x_msg_data
457: );
458:
459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
460: THEN
461: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
462: /* CLOSE default_transaction_c; */
463:

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
462: /* CLOSE default_transaction_c; */
463:
464: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467:
468: ELSE
469: CLOSE default_transaction_c;

Line 484: , FND_API.G_FALSE

480: PRINT_DEBUG (l_old_transaction_rec,'Update Default Back Order');
481:
482: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
483: ( 1
484: , FND_API.G_FALSE
485: , FND_API.G_FALSE
486: , FND_API.G_VALID_LEVEL_FULL
487: , l_old_transaction_rec
488: , l_old_transaction_row

Line 485: , FND_API.G_FALSE

481:
482: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
483: ( 1
484: , FND_API.G_FALSE
485: , FND_API.G_FALSE
486: , FND_API.G_VALID_LEVEL_FULL
487: , l_old_transaction_rec
488: , l_old_transaction_row
489: , x_return_status

Line 486: , FND_API.G_VALID_LEVEL_FULL

482: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
483: ( 1
484: , FND_API.G_FALSE
485: , FND_API.G_FALSE
486: , FND_API.G_VALID_LEVEL_FULL
487: , l_old_transaction_rec
488: , l_old_transaction_row
489: , x_return_status
490: , x_msg_count

Line 494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

490: , x_msg_count
491: , x_msg_data
492: );
493:
494: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
495: THEN
496: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
497: /* CLOSE default_transaction_c; */
498:

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
497: /* CLOSE default_transaction_c; */
498:
499: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502: END IF;
503: END IF;
504:

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

505: END IF;
506: ELSE
507: GMI_RESERVATION_UTIL.println('could not locate the original transaction');
508: /* We could not locate the original transaction. */
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: END IF; /* Non-loc or location controlled */
513: END IF;

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: EXCEPTION
516: WHEN OTHERS
517: THEN
518: rollback to process_backorders;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
521: /* CLOSE default_transaction_c; */
522: END GMI_CREATE_BACKORDER_TXN;
523:

Line 582: , FND_API.G_FALSE

578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
579:
580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
581: ( 1
582: , FND_API.G_FALSE
583: , FND_API.G_FALSE
584: , FND_API.G_VALID_LEVEL_FULL
585: , l_transaction_rec
586: , l_transaction_row

Line 583: , FND_API.G_FALSE

579:
580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
581: ( 1
582: , FND_API.G_FALSE
583: , FND_API.G_FALSE
584: , FND_API.G_VALID_LEVEL_FULL
585: , l_transaction_rec
586: , l_transaction_row
587: , x_return_status

Line 584: , FND_API.G_VALID_LEVEL_FULL

580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
581: ( 1
582: , FND_API.G_FALSE
583: , FND_API.G_FALSE
584: , FND_API.G_VALID_LEVEL_FULL
585: , l_transaction_rec
586: , l_transaction_row
587: , x_return_status
588: , l_msg_count

Line 592: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

588: , l_msg_count
589: , l_msg_data
590: );
591:
592: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
593: THEN
594: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591:
592: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
593: THEN
594: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597:
598: END IF;
599: /* hwahdani BUG#:1495550 get proper value of default location from profile */

Line 612: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: );
609:
610: IF nvl(l_trans_id,0) = 0 THEN
611: GMI_RESERVATION_UTIL.println('Default Transaction Not Found');
612: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: /* create a default lot, in case we are backordering */
614: l_transaction_rec.location := l_location;
615: l_transaction_rec.lot_id := 0;
616: l_transaction_rec.trans_qty := 0;

Line 622: , p_init_msg_list => FND_API.G_FALSE

618: l_transaction_rec.staged_ind := 0;
619: l_transaction_rec.line_detail_id := null;
620: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
621: ( p_api_version => 1.0
622: , p_init_msg_list => FND_API.G_FALSE
623: , p_commit => FND_API.G_FALSE
624: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
625: , p_tran_rec => l_transaction_rec
626: , x_tran_row => l_transaction_row

Line 623: , p_commit => FND_API.G_FALSE

619: l_transaction_rec.line_detail_id := null;
620: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
621: ( p_api_version => 1.0
622: , p_init_msg_list => FND_API.G_FALSE
623: , p_commit => FND_API.G_FALSE
624: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
625: , p_tran_rec => l_transaction_rec
626: , x_tran_row => l_transaction_row
627: , x_return_status => x_return_status

Line 624: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

620: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
621: ( p_api_version => 1.0
622: , p_init_msg_list => FND_API.G_FALSE
623: , p_commit => FND_API.G_FALSE
624: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
625: , p_tran_rec => l_transaction_rec
626: , x_tran_row => l_transaction_row
627: , x_return_status => x_return_status
628: , x_msg_count => l_msg_count

Line 631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

627: , x_return_status => x_return_status
628: , x_msg_count => l_msg_count
629: , x_msg_data => l_msg_data
630: );
631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
632: THEN
633: GMI_RESERVATION_UTIL.PrintLn('Error returned by creating pending default lot');
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;

Line 634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

630: );
631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
632: THEN
633: GMI_RESERVATION_UTIL.PrintLn('Error returned by creating pending default lot');
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636: l_trans_id := l_transaction_row.trans_id;
637: GMI_RESERVATION_UTIL.println('created Default Transaction trans_id '||l_trans_id);
638: END IF;

Line 653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

649: , x_return_status => x_return_status
650: , x_msg_count => l_msg_count
651: , x_msg_data => l_msg_data
652: );
653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
654: THEN
655: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

652: );
653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
654: THEN
655: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658: END IF;
659:
660: EXCEPTION

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660: EXCEPTION
661: WHEN OTHERS
662: THEN
663: rollback to process_backorders;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: END unreserve_inv;
666:
667: -- this is obsoleted once the WSH had made changes for backorder, new int, omchanges
668: PROCEDURE GMI_UPDATE_SHIPMENT_TXN

Line 846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

842: , x_msg_count => x_msg_count
843: , x_msg_data => x_msg_data
844: );
845: GMI_RESERVATION_UTIL.println('Finished calling GMI_Shipping_Util.GMI_UPDATE _SHIPMENT_TXN');
846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
847: THEN
848: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
849: Close check_wsh; /* B2886561 close cursor before exception */
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
847: THEN
848: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
849: Close check_wsh; /* B2886561 close cursor before exception */
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: IF check_wsh%ISOPEN THEN
853: Close check_wsh;
854: END IF;

Line 948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

944: FETCH get_opm_transaction_cnt into l_cnt_trans;
945: CLOSE get_opm_transaction_cnt;
946: IF (l_cnt_trans > 1) THEN
947: GMI_RESERVATION_UTIL.println('Multiple deleted transactions found - Manual updates are necessary');
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: ELSIF (l_cnt_trans = 1) THEN
950: /* update the transaction's delete mark to 0 and proceed */
951: UPDATE ic_tran_pnd
952: SET delete_mark = 0

Line 962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

958: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
959: ELSE
960: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
961: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;
964: /* End B2547509 */
965: END IF;
966:

Line 976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/

972: END IF;
973:
974: /*ELSE
975: GMI_RESERVATION_UTIL.println('OPM Transaction Not Found');
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/
977: END IF;
978: END IF;
979:
980:

Line 1072: RAISE FND_API.G_EXC_ERROR;

1068: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1069: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1070: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1071: FND_MSG_PUB.Add;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1075: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1076: ( 1

Line 1077: , FND_API.G_FALSE

1073: END IF;
1074:
1075: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1076: ( 1
1077: , FND_API.G_FALSE
1078: , FND_API.G_FALSE
1079: , FND_API.G_VALID_LEVEL_FULL
1080: , l_old_transaction_rec
1081: , l_old_transaction_row

Line 1078: , FND_API.G_FALSE

1074:
1075: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1076: ( 1
1077: , FND_API.G_FALSE
1078: , FND_API.G_FALSE
1079: , FND_API.G_VALID_LEVEL_FULL
1080: , l_old_transaction_rec
1081: , l_old_transaction_row
1082: , x_return_status

Line 1079: , FND_API.G_VALID_LEVEL_FULL

1075: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1076: ( 1
1077: , FND_API.G_FALSE
1078: , FND_API.G_FALSE
1079: , FND_API.G_VALID_LEVEL_FULL
1080: , l_old_transaction_rec
1081: , l_old_transaction_row
1082: , x_return_status
1083: , x_msg_count

Line 1087: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1083: , x_msg_count
1084: , x_msg_data
1085: );
1086:
1087: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1088: THEN
1089: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1090: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1088: THEN
1089: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1090: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093:
1094: ELSIF p_shipping_line.shipped_quantity <= ABS(l_src_qty)
1095: + l_ship_qty_above

Line 1107: , FND_API.G_FALSE

1103: PRINT_DEBUG (l_old_transaction_rec, 'DELETE RECORD');
1104:
1105: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1106: ( 1
1107: , FND_API.G_FALSE
1108: , FND_API.G_FALSE
1109: , FND_API.G_VALID_LEVEL_FULL
1110: , l_old_transaction_rec
1111: , l_old_transaction_row

Line 1108: , FND_API.G_FALSE

1104:
1105: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1106: ( 1
1107: , FND_API.G_FALSE
1108: , FND_API.G_FALSE
1109: , FND_API.G_VALID_LEVEL_FULL
1110: , l_old_transaction_rec
1111: , l_old_transaction_row
1112: , x_return_status

Line 1109: , FND_API.G_VALID_LEVEL_FULL

1105: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1106: ( 1
1107: , FND_API.G_FALSE
1108: , FND_API.G_FALSE
1109: , FND_API.G_VALID_LEVEL_FULL
1110: , l_old_transaction_rec
1111: , l_old_transaction_row
1112: , x_return_status
1113: , x_msg_count

Line 1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1113: , x_msg_count
1114: , x_msg_data
1115: );
1116:
1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1118: THEN
1119: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;

Line 1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1116:
1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1118: THEN
1119: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;
1122:
1123: l_new_transaction_rec := l_old_transaction_rec;
1124: l_new_transaction_rec.trans_qty2:= -1 * p_shipping_line.shipped_quantity2;

Line 1137: , FND_API.G_FALSE

1133: PRINT_DEBUG (l_new_transaction_rec,'CREATE NEW');
1134:
1135: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1136: ( 1
1137: , FND_API.G_FALSE
1138: , FND_API.G_FALSE
1139: , FND_API.G_VALID_LEVEL_FULL
1140: , l_new_transaction_rec
1141: , l_new_transaction_row

Line 1138: , FND_API.G_FALSE

1134:
1135: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1136: ( 1
1137: , FND_API.G_FALSE
1138: , FND_API.G_FALSE
1139: , FND_API.G_VALID_LEVEL_FULL
1140: , l_new_transaction_rec
1141: , l_new_transaction_row
1142: , x_return_status

Line 1139: , FND_API.G_VALID_LEVEL_FULL

1135: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1136: ( 1
1137: , FND_API.G_FALSE
1138: , FND_API.G_FALSE
1139: , FND_API.G_VALID_LEVEL_FULL
1140: , l_new_transaction_rec
1141: , l_new_transaction_row
1142: , x_return_status
1143: , x_msg_count

Line 1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1143: , x_msg_count
1144: , x_msg_data
1145: );
1146:
1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1148: THEN
1149: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;

Line 1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1146:
1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1148: THEN
1149: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152:
1153: l_new_transaction_rec.trans_id := l_new_transaction_row.trans_id;
1154:

Line 1179: , FND_API.G_FALSE

1175: PRINT_DEBUG (l_new_transaction_rec,'UPDATE TO COMPLETE');
1176:
1177: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1178: ( 1
1179: , FND_API.G_FALSE
1180: , FND_API.G_FALSE
1181: , FND_API.G_VALID_LEVEL_FULL
1182: , l_new_transaction_rec
1183: , l_new_transaction_row

Line 1180: , FND_API.G_FALSE

1176:
1177: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1178: ( 1
1179: , FND_API.G_FALSE
1180: , FND_API.G_FALSE
1181: , FND_API.G_VALID_LEVEL_FULL
1182: , l_new_transaction_rec
1183: , l_new_transaction_row
1184: , x_return_status

Line 1181: , FND_API.G_VALID_LEVEL_FULL

1177: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1178: ( 1
1179: , FND_API.G_FALSE
1180: , FND_API.G_FALSE
1181: , FND_API.G_VALID_LEVEL_FULL
1182: , l_new_transaction_rec
1183: , l_new_transaction_row
1184: , x_return_status
1185: , x_msg_count

Line 1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1185: , x_msg_count
1186: , x_msg_data
1187: );
1188:
1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1190: THEN
1191: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1192: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1190: THEN
1191: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1192: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: GMI_RESERVATION_UTIL.find_default_lot
1196: ( x_return_status => x_return_status,
1197: x_msg_count => x_msg_count,

Line 1215: , FND_API.G_FALSE

1211: PRINT_DEBUG (l_new_transaction_rec,' 0 out Default Transaction');
1212:
1213: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1214: ( 1
1215: , FND_API.G_FALSE
1216: , FND_API.G_FALSE
1217: , FND_API.G_VALID_LEVEL_FULL
1218: , l_new_transaction_rec
1219: , l_new_transaction_row

Line 1216: , FND_API.G_FALSE

1212:
1213: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1214: ( 1
1215: , FND_API.G_FALSE
1216: , FND_API.G_FALSE
1217: , FND_API.G_VALID_LEVEL_FULL
1218: , l_new_transaction_rec
1219: , l_new_transaction_row
1220: , x_return_status

Line 1217: , FND_API.G_VALID_LEVEL_FULL

1213: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1214: ( 1
1215: , FND_API.G_FALSE
1216: , FND_API.G_FALSE
1217: , FND_API.G_VALID_LEVEL_FULL
1218: , l_new_transaction_rec
1219: , l_new_transaction_row
1220: , x_return_status
1221: , x_msg_count

Line 1224: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1220: , x_return_status
1221: , x_msg_count
1222: , x_msg_data
1223: );
1224: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1225: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;

Line 1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1222: , x_msg_data
1223: );
1224: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1225: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;
1229: END IF;
1230: ELSIF p_shipping_line.shipped_quantity >

Line 1249: , FND_API.G_FALSE

1245: PRINT_DEBUG (l_old_transaction_rec,'Delete Original');
1246:
1247: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1248: ( 1
1249: , FND_API.G_FALSE
1250: , FND_API.G_FALSE
1251: , FND_API.G_VALID_LEVEL_FULL
1252: , l_old_transaction_rec
1253: , l_old_transaction_row

Line 1250: , FND_API.G_FALSE

1246:
1247: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1248: ( 1
1249: , FND_API.G_FALSE
1250: , FND_API.G_FALSE
1251: , FND_API.G_VALID_LEVEL_FULL
1252: , l_old_transaction_rec
1253: , l_old_transaction_row
1254: , x_return_status

Line 1251: , FND_API.G_VALID_LEVEL_FULL

1247: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1248: ( 1
1249: , FND_API.G_FALSE
1250: , FND_API.G_FALSE
1251: , FND_API.G_VALID_LEVEL_FULL
1252: , l_old_transaction_rec
1253: , l_old_transaction_row
1254: , x_return_status
1255: , x_msg_count

Line 1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1255: , x_msg_count
1256: , x_msg_data
1257: );
1258:
1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1260: THEN
1261: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;

Line 1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1258:
1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1260: THEN
1261: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264:
1265: /* Create a new transaction for the shipped quantity */
1266:

Line 1283: , FND_API.G_FALSE

1279: PRINT_DEBUG (l_new_transaction_rec,'Create NEW');
1280:
1281: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1282: ( 1
1283: , FND_API.G_FALSE
1284: , FND_API.G_FALSE
1285: , FND_API.G_VALID_LEVEL_FULL
1286: , l_new_transaction_rec
1287: , l_new_transaction_row

Line 1284: , FND_API.G_FALSE

1280:
1281: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1282: ( 1
1283: , FND_API.G_FALSE
1284: , FND_API.G_FALSE
1285: , FND_API.G_VALID_LEVEL_FULL
1286: , l_new_transaction_rec
1287: , l_new_transaction_row
1288: , x_return_status

Line 1285: , FND_API.G_VALID_LEVEL_FULL

1281: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1282: ( 1
1283: , FND_API.G_FALSE
1284: , FND_API.G_FALSE
1285: , FND_API.G_VALID_LEVEL_FULL
1286: , l_new_transaction_rec
1287: , l_new_transaction_row
1288: , x_return_status
1289: , x_msg_count

Line 1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1289: , x_msg_count
1290: , x_msg_data
1291: );
1292:
1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1294: THEN
1295: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;

Line 1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1292:
1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1294: THEN
1295: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;
1298:
1299: l_new_transaction_rec.trans_id := l_new_transaction_row.trans_id;
1300: /* Need To Update The Actual Shipment Date */

Line 1322: , FND_API.G_FALSE

1318: PRINT_DEBUG (l_new_transaction_rec,'UPDATE NEW');
1319:
1320: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1321: ( 1
1322: , FND_API.G_FALSE
1323: , FND_API.G_FALSE
1324: , FND_API.G_VALID_LEVEL_FULL
1325: , l_new_transaction_rec
1326: , l_new_transaction_row

Line 1323: , FND_API.G_FALSE

1319:
1320: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1321: ( 1
1322: , FND_API.G_FALSE
1323: , FND_API.G_FALSE
1324: , FND_API.G_VALID_LEVEL_FULL
1325: , l_new_transaction_rec
1326: , l_new_transaction_row
1327: , x_return_status

Line 1324: , FND_API.G_VALID_LEVEL_FULL

1320: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1321: ( 1
1322: , FND_API.G_FALSE
1323: , FND_API.G_FALSE
1324: , FND_API.G_VALID_LEVEL_FULL
1325: , l_new_transaction_rec
1326: , l_new_transaction_row
1327: , x_return_status
1328: , x_msg_count

Line 1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1328: , x_msg_count
1329: , x_msg_data
1330: );
1331:
1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1333: THEN
1334: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1335: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1333: THEN
1334: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1335: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339: GMI_RESERVATION_UTIL.println('Handle Split');
1340: GMI_RESERVATION_UTIL.println('OLD QTY = > ' || l_old_transaction_rec.trans_qty);

Line 1396: , FND_API.G_FALSE

1392: PRINT_DEBUG (l_new_transaction_rec,'CREATE NEW Staged');
1393:
1394: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1395: ( 1
1396: , FND_API.G_FALSE
1397: , FND_API.G_FALSE
1398: , FND_API.G_VALID_LEVEL_FULL
1399: , l_new_transaction_rec
1400: , l_new_transaction_row

Line 1397: , FND_API.G_FALSE

1393:
1394: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1395: ( 1
1396: , FND_API.G_FALSE
1397: , FND_API.G_FALSE
1398: , FND_API.G_VALID_LEVEL_FULL
1399: , l_new_transaction_rec
1400: , l_new_transaction_row
1401: , x_return_status

Line 1398: , FND_API.G_VALID_LEVEL_FULL

1394: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1395: ( 1
1396: , FND_API.G_FALSE
1397: , FND_API.G_FALSE
1398: , FND_API.G_VALID_LEVEL_FULL
1399: , l_new_transaction_rec
1400: , l_new_transaction_row
1401: , x_return_status
1402: , x_msg_count

Line 1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1402: , x_msg_count
1403: , x_msg_data
1404: );
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1407: THEN
1408: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;

Line 1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1407: THEN
1408: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:
1412: GMI_RESERVATION_UTIL.println('created trans_id='||l_new_transaction_row.trans_id);
1413: GMI_RESERVATION_UTIL.println('and its staged_ind='||l_new_transaction_row.staged_ind);

Line 1433: , FND_API.G_FALSE

1429: GMI_RESERVATION_UTIL.println('Update Default For Staged');
1430:
1431: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1432: ( 1
1433: , FND_API.G_FALSE
1434: , FND_API.G_FALSE
1435: , FND_API.G_VALID_LEVEL_FULL
1436: , l_old_transaction_rec
1437: , l_old_transaction_row

Line 1434: , FND_API.G_FALSE

1430:
1431: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1432: ( 1
1433: , FND_API.G_FALSE
1434: , FND_API.G_FALSE
1435: , FND_API.G_VALID_LEVEL_FULL
1436: , l_old_transaction_rec
1437: , l_old_transaction_row
1438: , x_return_status

Line 1435: , FND_API.G_VALID_LEVEL_FULL

1431: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1432: ( 1
1433: , FND_API.G_FALSE
1434: , FND_API.G_FALSE
1435: , FND_API.G_VALID_LEVEL_FULL
1436: , l_old_transaction_rec
1437: , l_old_transaction_row
1438: , x_return_status
1439: , x_msg_count

Line 1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1439: , x_msg_count
1440: , x_msg_data
1441: );
1442:
1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1444: THEN
1445: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;

Line 1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1442:
1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1444: THEN
1445: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448: END IF;
1449: END IF;
1450: ELSE

Line 1477: , FND_API.G_FALSE

1473: END IF;
1474:
1475: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1476: ( 1
1477: , FND_API.G_FALSE
1478: , FND_API.G_FALSE
1479: , FND_API.G_VALID_LEVEL_FULL
1480: , l_new_transaction_rec
1481: , l_new_transaction_row

Line 1478: , FND_API.G_FALSE

1474:
1475: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1476: ( 1
1477: , FND_API.G_FALSE
1478: , FND_API.G_FALSE
1479: , FND_API.G_VALID_LEVEL_FULL
1480: , l_new_transaction_rec
1481: , l_new_transaction_row
1482: , x_return_status

Line 1479: , FND_API.G_VALID_LEVEL_FULL

1475: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1476: ( 1
1477: , FND_API.G_FALSE
1478: , FND_API.G_FALSE
1479: , FND_API.G_VALID_LEVEL_FULL
1480: , l_new_transaction_rec
1481: , l_new_transaction_row
1482: , x_return_status
1483: , x_msg_count

Line 1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1483: , x_msg_count
1484: , x_msg_data
1485: );
1486:
1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1488: THEN
1489: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1490: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1488: THEN
1489: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1490: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493: /* find the default transaction */
1494: OPEN default_transaction_c;
1495: FETCH default_transaction_c INTO l_trans_id;

Line 1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1505: , x_return_status => x_return_status
1506: , x_msg_count => x_msg_count
1507: , x_msg_data => x_msg_data
1508: );
1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1510: THEN
1511: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: END IF;

Line 1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1508: );
1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1510: THEN
1511: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: END IF;
1514: END IF;
1515: END IF;
1516:

Line 1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1519: END IF;
1520: ELSE
1521: GMI_RESERVATION_UTIL.println('could not locate the original transaction');
1522: /* We could not locate the original transaction. */
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525:
1526: EXCEPTION
1527:

Line 1533: x_return_status := FND_API.G_RET_STS_ERROR;

1529: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1530:
1531: WHEN NO_DATA_FOUND THEN
1532: rollback to process_shipments;
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534: GMI_RESERVATION_UTIL.Println('Raised No Data Found');
1535:
1536: WHEN OTHERS
1537: THEN

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535:
1536: WHEN OTHERS
1537: THEN
1538: rollback to process_shipments;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: GMI_RESERVATION_UTIL.Println('Raised When Others');
1541:
1542: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
1543: /* CLOSE default_transaction_c; */

Line 1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1625: FETCH get_opm_transaction_cnt into l_cnt_trans;
1626: CLOSE get_opm_transaction_cnt;
1627: IF (l_cnt_trans > 1) THEN
1628: GMI_RESERVATION_UTIL.println('Multiple deleted transactions found - Manual updates are necessary');
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF (l_cnt_trans = 1) THEN
1631: /* update the transaction's delete mark to 0 and proceed */
1632: UPDATE ic_tran_pnd
1633: SET delete_mark = 0

Line 1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1639: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
1640: ELSE
1641: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
1642: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644: END IF;
1645: /* End B2547509 */
1646: END IF;
1647: /* B2886561 check if cursor is open before closing */

Line 1711: RAISE FND_API.G_EXC_ERROR;

1707: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1708: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1709: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1710: FND_MSG_PUB.Add;
1711: RAISE FND_API.G_EXC_ERROR;
1712: END IF;
1713:
1714: PRINT_DEBUG (l_new_transaction_rec,'COMPLETE RECORD');
1715:

Line 1718: , FND_API.G_FALSE

1714: PRINT_DEBUG (l_new_transaction_rec,'COMPLETE RECORD');
1715:
1716: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1717: ( 1
1718: , FND_API.G_FALSE
1719: , FND_API.G_FALSE
1720: , FND_API.G_VALID_LEVEL_FULL
1721: , l_new_transaction_rec
1722: , l_new_transaction_row

Line 1719: , FND_API.G_FALSE

1715:
1716: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1717: ( 1
1718: , FND_API.G_FALSE
1719: , FND_API.G_FALSE
1720: , FND_API.G_VALID_LEVEL_FULL
1721: , l_new_transaction_rec
1722: , l_new_transaction_row
1723: , x_return_status

Line 1720: , FND_API.G_VALID_LEVEL_FULL

1716: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1717: ( 1
1718: , FND_API.G_FALSE
1719: , FND_API.G_FALSE
1720: , FND_API.G_VALID_LEVEL_FULL
1721: , l_new_transaction_rec
1722: , l_new_transaction_row
1723: , x_return_status
1724: , x_msg_count

Line 1728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1724: , x_msg_count
1725: , x_msg_data
1726: );
1727:
1728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1729: THEN
1730: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1731: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1729: THEN
1730: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1731: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734: /* only need to balance default lot for overpickiing */
1735: GMI_RESERVATION_UTIL.println('find_deafult_lot ');
1736: /* find the default transaction */

Line 1770: , FND_API.G_FALSE

1766: PRINT_DEBUG (l_new_transaction_rec,' 0 out Default Transaction');
1767:
1768: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1769: ( 1
1770: , FND_API.G_FALSE
1771: , FND_API.G_FALSE
1772: , FND_API.G_VALID_LEVEL_FULL
1773: , l_new_transaction_rec
1774: , l_new_transaction_row

Line 1771: , FND_API.G_FALSE

1767:
1768: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1769: ( 1
1770: , FND_API.G_FALSE
1771: , FND_API.G_FALSE
1772: , FND_API.G_VALID_LEVEL_FULL
1773: , l_new_transaction_rec
1774: , l_new_transaction_row
1775: , x_return_status

Line 1772: , FND_API.G_VALID_LEVEL_FULL

1768: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1769: ( 1
1770: , FND_API.G_FALSE
1771: , FND_API.G_FALSE
1772: , FND_API.G_VALID_LEVEL_FULL
1773: , l_new_transaction_rec
1774: , l_new_transaction_row
1775: , x_return_status
1776: , x_msg_count

Line 1779: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1775: , x_return_status
1776: , x_msg_count
1777: , x_msg_data
1778: );
1779: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1780: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783: ELSE

Line 1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1777: , x_msg_data
1778: );
1779: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1780: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783: ELSE
1784: GMI_RESERVATION_UTIL.println('balancing default lot.');
1785: GMI_RESERVATION_UTIL.balance_default_lot

Line 1792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1788: , x_return_status => x_return_status
1789: , x_msg_count => x_msg_count
1790: , x_msg_data => x_msg_data
1791: );
1792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1793: THEN
1794: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: END IF;

Line 1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1791: );
1792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1793: THEN
1794: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: END IF;
1797: END IF;
1798: END IF;
1799: END IF;

Line 1809: x_return_status := FND_API.G_RET_STS_ERROR;

1805: RAISE;
1806:
1807: WHEN NO_DATA_FOUND THEN
1808: rollback to process_shipments;
1809: x_return_status := FND_API.G_RET_STS_ERROR;
1810: GMI_RESERVATION_UTIL.Println('Raised No Data Found');
1811:
1812: WHEN OTHERS
1813: THEN

Line 1815: x_return_status := FND_API.G_RET_STS_ERROR;

1811:
1812: WHEN OTHERS
1813: THEN
1814: rollback to process_shipments;
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: GMI_RESERVATION_UTIL.Println('Raised When Others');
1817:
1818: END GMI_UPDATE_SHIPMENT_TXN_new;
1819:

Line 1979: x_return_status := FND_API.G_RET_STS_ERROR;

1975: THEN
1976: GMI_RESERVATION_UTIL.println('No Data Found raised');
1977: WHEN OTHERS
1978: THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: GMI_RESERVATION_UTIL.println('RAISE WHEN OTHERS');
1981: END GMI_APPLY_BACKORDER_UPDATES;
1982:
1983: /* NC Added the following two procedures. Bug#1675561 */

Line 2159: , FND_API.G_FALSE

2155: l_old_transaction_rec.trans_qty2 := -1 * (p_old_req_quantity2 - p_req_quantity2);
2156:
2157: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
2158: ( 1
2159: , FND_API.G_FALSE
2160: , FND_API.G_FALSE
2161: , FND_API.G_VALID_LEVEL_FULL
2162: , l_old_transaction_rec
2163: , l_old_transaction_row

Line 2160: , FND_API.G_FALSE

2156:
2157: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
2158: ( 1
2159: , FND_API.G_FALSE
2160: , FND_API.G_FALSE
2161: , FND_API.G_VALID_LEVEL_FULL
2162: , l_old_transaction_rec
2163: , l_old_transaction_row
2164: , x_return_status

Line 2161: , FND_API.G_VALID_LEVEL_FULL

2157: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
2158: ( 1
2159: , FND_API.G_FALSE
2160: , FND_API.G_FALSE
2161: , FND_API.G_VALID_LEVEL_FULL
2162: , l_old_transaction_rec
2163: , l_old_transaction_row
2164: , x_return_status
2165: , x_msg_count

Line 2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2165: , x_msg_count
2166: , x_msg_data
2167: );
2168:
2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2170: THEN
2171: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
2172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2173: END IF;

Line 2172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2168:
2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2170: THEN
2171: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
2172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2173: END IF;
2174:
2175: l_new_transaction_rec := l_old_transaction_rec;
2176: l_new_transaction_rec.line_detail_id := p_new_delivery_detail_id;

Line 2183: , FND_API.G_FALSE

2179: l_new_transaction_rec.trans_qty2 := -1 * (p_req_quantity2);
2180:
2181: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2182: ( 1
2183: , FND_API.G_FALSE
2184: , FND_API.G_FALSE
2185: , FND_API.G_VALID_LEVEL_FULL
2186: , l_new_transaction_rec
2187: , l_new_transaction_row

Line 2184: , FND_API.G_FALSE

2180:
2181: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2182: ( 1
2183: , FND_API.G_FALSE
2184: , FND_API.G_FALSE
2185: , FND_API.G_VALID_LEVEL_FULL
2186: , l_new_transaction_rec
2187: , l_new_transaction_row
2188: , x_return_status

Line 2185: , FND_API.G_VALID_LEVEL_FULL

2181: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
2182: ( 1
2183: , FND_API.G_FALSE
2184: , FND_API.G_FALSE
2185: , FND_API.G_VALID_LEVEL_FULL
2186: , l_new_transaction_rec
2187: , l_new_transaction_row
2188: , x_return_status
2189: , x_msg_count

Line 2193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

2189: , x_msg_count
2190: , x_msg_data
2191: );
2192:
2193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2194: THEN
2195: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END IF;

Line 2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2192:
2193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2194: THEN
2195: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END IF;
2198:
2199: END IF;
2200:

Line 2204: x_return_status := FND_API.G_RET_STS_ERROR;

2200:
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN
2203: rollback to update_txn;
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: RAISE NO_DATA_FOUND;
2206: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in UPDATE_OPM_TRANSACTION');
2207:
2208: WHEN OTHERS THEN

Line 2210: x_return_status := FND_API.G_RET_STS_ERROR;

2206: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in UPDATE_OPM_TRANSACTION');
2207:
2208: WHEN OTHERS THEN
2209: rollback to update_txn;
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: GMI_RESERVATION_UTIL.Println('Raised When Others in UPDATE_OPM_TRANSACTION');
2212: END UPDATE_OPM_TRANSACTION;
2213:
2214: PROCEDURE UPDATE_OPM_IC_TRAN_PND

Line 2502: RAISE FND_API.G_EXC_ERROR;

2498: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2499: FND_MSG_PUB.Add;
2500: Close get_default_loct; /* B2886561 close cursor before exception */
2501: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI
2502: RAISE FND_API.G_EXC_ERROR;
2503: */
2504: END IF;
2505: --esle if item not location cotrolled then get def subinv from MTL_ITEM_SUB_DEFAULTS
2506: ELSIF l_ctl_ind = 'N' THEN

Line 2518: RAISE FND_API.G_EXC_ERROR;

2514: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2515: FND_MSG_PUB.Add;
2516: Close get_default_sub; /* B2886561 close cursor before exception */
2517: /* Bug #3415847 punkumar,commeting out the exception so that it does not stop insertion of record in RTI
2518: RAISE FND_API.G_EXC_ERROR;
2519: */
2520: END IF;
2521: END IF;
2522: --Close cursors.

Line 3113: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;

3109: and mo.txn_source_line_id = wdd.source_line_id
3110: and wdd.released_status = 'S'
3111: ;
3112:
3113: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;
3114: --END BUG#2736088
3115: l_return_status VARCHAR2(1);
3116: l_msg_count NUMBER;
3117: l_msg_data VARCHAR2(2000);

Line 3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3448: x_return_status => x_return_status,
3449: x_msg_count => x_msg_count,
3450: x_msg_data => x_msg_data );
3451: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3453: END IF;
3454: oe_debug_pub.add('Done calling update_opm_transaction',2);
3455: ELSE /* not staged */
3456: GMI_SHIPPING_UTIL.split_trans

Line 3468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3464: x_msg_count => x_msg_count,
3465: x_msg_data => x_msg_data
3466: );
3467: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3469: END IF;
3470: oe_debug_pub.add('Done calling split_trans',2);
3471:
3472: END IF;

Line 3477: x_return_status := FND_API.G_RET_STS_ERROR;

3473:
3474: EXCEPTION
3475: WHEN NO_DATA_FOUND THEN
3476: rollback to update_txn;
3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: RAISE NO_DATA_FOUND;
3479: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in split_opm_trans');
3480:
3481: WHEN OTHERS THEN

Line 3483: x_return_status := FND_API.G_RET_STS_ERROR;

3479: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in split_opm_trans');
3480:
3481: WHEN OTHERS THEN
3482: rollback to split_txn;
3483: x_return_status := FND_API.G_RET_STS_ERROR;
3484: GMI_RESERVATION_UTIL.Println('Raised When Others in split_opm_trans');
3485: END split_opm_trans;
3486:
3487: /* this procedure fulfills the trans for the old dd and updates the rest of

Line 3655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3651: p_line_id => p_old_source_line_id
3652: );
3653: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3654: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
3655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3656: END IF;
3657:
3658: l_old_transaction_rec.trans_id := l_trans_id;
3659: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

Line 3671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3667: , x_return_status => x_return_status
3668: , x_msg_count => x_msg_count
3669: , x_msg_data => x_msg_data
3670: );
3671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3672: THEN
3673: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: END IF;

Line 3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3670: );
3671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3672: THEN
3673: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: END IF;
3676: ELSE
3677: l_orig_txn_exists := 0; --Bug3149635
3678: END IF;

Line 3692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3688: );
3689:
3690: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3691: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
3692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3693: END IF;
3694:
3695: --Bug3149635 (added AND condition below)
3696: IF (nvl(l_trans_id, 0) = 0 AND l_orig_txn_exists = 1 ) THEN

Line 3703: ,p_init_msg_list => FND_API.G_FALSE

3699: l_old_transaction_rec.line_detail_id := null;
3700: -- create a new default
3701: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3702: p_api_version => 1.0
3703: ,p_init_msg_list => FND_API.G_FALSE
3704: ,p_commit => FND_API.G_FALSE
3705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3706: ,p_tran_rec => l_old_transaction_rec
3707: ,x_tran_row => l_new_transaction_row

Line 3704: ,p_commit => FND_API.G_FALSE

3700: -- create a new default
3701: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3702: p_api_version => 1.0
3703: ,p_init_msg_list => FND_API.G_FALSE
3704: ,p_commit => FND_API.G_FALSE
3705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3706: ,p_tran_rec => l_old_transaction_rec
3707: ,x_tran_row => l_new_transaction_row
3708: ,x_return_status => x_return_status

Line 3705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3701: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION(
3702: p_api_version => 1.0
3703: ,p_init_msg_list => FND_API.G_FALSE
3704: ,p_commit => FND_API.G_FALSE
3705: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3706: ,p_tran_rec => l_old_transaction_rec
3707: ,x_tran_row => l_new_transaction_row
3708: ,x_return_status => x_return_status
3709: ,x_msg_count => x_msg_count

Line 3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

3710: ,x_msg_data => x_msg_data);
3711:
3712: GMI_reservation_Util.PrintLn('created new default lot with trans_id '||l_new_transaction_row.trans_id);
3713: GMI_reservation_Util.PrintLn('created new default lot with line_detail_id '||l_new_transaction_row.line_detail_id);
3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');

Line 3721: RAISE FND_API.G_EXC_ERROR;

3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3719: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3720: FND_MSG_PUB.Add;
3721: RAISE FND_API.G_EXC_ERROR;
3722: END IF;
3723: l_old_transaction_rec.trans_id := l_new_transaction_row.trans_id;
3724: ELSE
3725: l_old_transaction_rec.trans_id := l_trans_id;

Line 3738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3734: , x_return_status => x_return_status
3735: , x_msg_count => x_msg_count
3736: , x_msg_data => x_msg_data
3737: );
3738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3739: THEN
3740: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3742: END IF;

Line 3741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3737: );
3738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3739: THEN
3740: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3742: END IF;
3743: END IF;
3744: /* split reservations if neccessary */
3745: GML_BATCH_OM_RES_PVT.split_reservations

Line 3815: , FND_API.G_FALSE

3811: l_new_transaction_rec.line_id := p_new_source_line_id;
3812:
3813: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3814: ( 1
3815: , FND_API.G_FALSE
3816: , FND_API.G_FALSE
3817: , FND_API.G_VALID_LEVEL_FULL
3818: , l_new_transaction_rec
3819: , l_new_transaction_row

Line 3816: , FND_API.G_FALSE

3812:
3813: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3814: ( 1
3815: , FND_API.G_FALSE
3816: , FND_API.G_FALSE
3817: , FND_API.G_VALID_LEVEL_FULL
3818: , l_new_transaction_rec
3819: , l_new_transaction_row
3820: , x_return_status

Line 3817: , FND_API.G_VALID_LEVEL_FULL

3813: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3814: ( 1
3815: , FND_API.G_FALSE
3816: , FND_API.G_FALSE
3817: , FND_API.G_VALID_LEVEL_FULL
3818: , l_new_transaction_rec
3819: , l_new_transaction_row
3820: , x_return_status
3821: , x_msg_count

Line 3825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3821: , x_msg_count
3822: , x_msg_data
3823: );
3824:
3825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3826: THEN
3827: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: END IF;

Line 3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3824:
3825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3826: THEN
3827: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: END IF;
3830: /* qty filfilled*/
3831: l_qty_to_fulfil := 0;
3832: l_qty2_to_fulfil := 0;

Line 3868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3864: , x_return_status => x_return_status
3865: , x_msg_count => x_msg_count
3866: , x_msg_data => x_msg_data
3867: );
3868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3869: THEN
3870: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;

Line 3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3867: );
3868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3869: THEN
3870: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873: END IF;
3874: END IF;
3875: GMI_RESERVATION_UTIL.find_default_lot

Line 3897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3893: , x_return_status => x_return_status
3894: , x_msg_count => x_msg_count
3895: , x_msg_data => x_msg_data
3896: );
3897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3898: THEN
3899: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: END IF;

Line 3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3896: );
3897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3898: THEN
3899: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: END IF;
3902: END IF;
3903: -- Begin Bug 2985470
3904: ELSIF (l_orig_txn_exists = 1 AND p_new_source_line_id <> p_old_source_line_id) THEN -- need to create txn for split line.

Line 3915: , FND_API.G_FALSE

3911: l_new_transaction_rec.line_id := p_new_source_line_id;
3912:
3913: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3914: ( 1
3915: , FND_API.G_FALSE
3916: , FND_API.G_FALSE
3917: , FND_API.G_VALID_LEVEL_FULL
3918: , l_new_transaction_rec
3919: , l_new_transaction_row

Line 3916: , FND_API.G_FALSE

3912:
3913: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3914: ( 1
3915: , FND_API.G_FALSE
3916: , FND_API.G_FALSE
3917: , FND_API.G_VALID_LEVEL_FULL
3918: , l_new_transaction_rec
3919: , l_new_transaction_row
3920: , x_return_status

Line 3917: , FND_API.G_VALID_LEVEL_FULL

3913: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3914: ( 1
3915: , FND_API.G_FALSE
3916: , FND_API.G_FALSE
3917: , FND_API.G_VALID_LEVEL_FULL
3918: , l_new_transaction_rec
3919: , l_new_transaction_row
3920: , x_return_status
3921: , x_msg_count

Line 3925: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3921: , x_msg_count
3922: , x_msg_data
3923: );
3924:
3925: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3926: THEN
3927: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END IF;

Line 3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3924:
3925: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3926: THEN
3927: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END IF;
3930: /* qty filfilled*/
3931: l_qty_to_fulfil := 0;
3932: l_qty2_to_fulfil := 0;

Line 3957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

3953: , x_return_status => x_return_status
3954: , x_msg_count => x_msg_count
3955: , x_msg_data => x_msg_data
3956: );
3957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3958: THEN
3959: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;

Line 3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3956: );
3957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3958: THEN
3959: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;
3962: END IF;
3963: END IF;
3964:

Line 4098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4094: , x_return_status => x_return_status
4095: , x_msg_count => l_msg_count
4096: , x_msg_data => l_msg_data
4097: );
4098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4099: THEN
4100: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4102: END IF;

Line 4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4097: );
4098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4099: THEN
4100: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4102: END IF;
4103: l_get_trans := 0;
4104: /* need to fetch it again */
4105: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

Line 4145: , FND_API.G_FALSE

4141:
4142: GMI_RESERVATION_UTIL.println('create trans '||l_trans_id );
4143: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4144: ( 1
4145: , FND_API.G_FALSE
4146: , FND_API.G_FALSE
4147: , FND_API.G_VALID_LEVEL_FULL
4148: , l_new_transaction_rec
4149: , l_new_transaction_row

Line 4146: , FND_API.G_FALSE

4142: GMI_RESERVATION_UTIL.println('create trans '||l_trans_id );
4143: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4144: ( 1
4145: , FND_API.G_FALSE
4146: , FND_API.G_FALSE
4147: , FND_API.G_VALID_LEVEL_FULL
4148: , l_new_transaction_rec
4149: , l_new_transaction_row
4150: , x_return_status

Line 4147: , FND_API.G_VALID_LEVEL_FULL

4143: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4144: ( 1
4145: , FND_API.G_FALSE
4146: , FND_API.G_FALSE
4147: , FND_API.G_VALID_LEVEL_FULL
4148: , l_new_transaction_rec
4149: , l_new_transaction_row
4150: , x_return_status
4151: , l_msg_count

Line 4155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4151: , l_msg_count
4152: , l_msg_data
4153: );
4154:
4155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4156: THEN
4157: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;

Line 4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4154:
4155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4156: THEN
4157: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;
4160: GMI_RESERVATION_UTIL.println('create trans '||l_new_transaction_row.trans_id );
4161: END IF;
4162: END IF;

Line 4221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4217: GMI_SHIPPING_UTIL.unreserve_inv
4218: ( p_trans_id => l_trans_id
4219: , x_return_status => x_return_status
4220: );
4221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4222: THEN
4223: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: END IF;

Line 4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4220: );
4221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4222: THEN
4223: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: END IF;
4226: ELSE
4227: GMI_RESERVATION_UTIL.println('update the ic_tran_pnd');
4228: Update ic_tran_pnd

Line 4243: x_return_status := FND_API.G_RET_STS_ERROR;

4239: --END LOOP;
4240:
4241: EXCEPTION
4242: WHEN OTHERS THEN
4243: x_return_status := FND_API.G_RET_STS_ERROR;
4244:
4245: END unreserve_delivery_detail;
4246:
4247: /* Bug 2547509. Function to validate the trans_date. Returns sysdate if date is in closed period */

Line 4424: x_return_status := FND_API.G_RET_STS_ERROR;

4420: FETCH find_new_source_line into l_new_source_line_id;
4421: IF ( find_new_source_line%NOTFOUND) THEN
4422: CLOSE find_new_source_line;
4423: gmi_reservation_util.println('Can not find source_line from WSH_DELIVERY_DETAILS for source_line'||p_cons_dd_id);
4424: x_return_status := FND_API.G_RET_STS_ERROR;
4425: RETURN;
4426: END IF;
4427: CLOSE find_new_source_line;
4428:

Line 4494: x_return_status := FND_API.G_RET_STS_ERROR;

4490:
4491: EXCEPTION
4492:
4493: WHEN NO_DATA_FOUND THEN
4494: x_return_status := FND_API.G_RET_STS_ERROR;
4495: RAISE NO_DATA_FOUND;
4496: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4497:
4498: WHEN OTHERS THEN

Line 4508: x_return_status := FND_API.G_RET_STS_ERROR;

4504: IF find_new_source_line%ISOPEN THEN
4505: CLOSE find_new_source_line;
4506: END IF;
4507:
4508: x_return_status := FND_API.G_RET_STS_ERROR;
4509:
4510: END UPDATE_NEW_LINE_DETAIL_ID;
4511:
4512: