DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on FND_MESSAGE

Line 82: fnd_message.set_name ('INV', mesg1);

78: ******************************************************************/
79: PROCEDURE loaderrmsg (mesg1 IN VARCHAR2, mesg2 IN VARCHAR2)
80: IS
81: BEGIN
82: fnd_message.set_name ('INV', mesg1);
83: l_error_code := fnd_message.get;
84: fnd_message.set_name ('INV', mesg2);
85: l_error_exp := fnd_message.get;
86: END;

Line 83: l_error_code := fnd_message.get;

79: PROCEDURE loaderrmsg (mesg1 IN VARCHAR2, mesg2 IN VARCHAR2)
80: IS
81: BEGIN
82: fnd_message.set_name ('INV', mesg1);
83: l_error_code := fnd_message.get;
84: fnd_message.set_name ('INV', mesg2);
85: l_error_exp := fnd_message.get;
86: END;
87:

Line 84: fnd_message.set_name ('INV', mesg2);

80: IS
81: BEGIN
82: fnd_message.set_name ('INV', mesg1);
83: l_error_code := fnd_message.get;
84: fnd_message.set_name ('INV', mesg2);
85: l_error_exp := fnd_message.get;
86: END;
87:
88: /*******************************************************************

Line 85: l_error_exp := fnd_message.get;

81: BEGIN
82: fnd_message.set_name ('INV', mesg1);
83: l_error_code := fnd_message.get;
84: fnd_message.set_name ('INV', mesg2);
85: l_error_exp := fnd_message.get;
86: END;
87:
88: /*******************************************************************
89: * LotTrxInsert(p_transaction_interface_id IN NUMBER)

Line 870: fnd_message.set_name ('INV', 'INV_INVALID_SERIAL_RANGE');

866: , '9'
867: );
868: END IF;
869:
870: fnd_message.set_name ('INV', 'INV_INVALID_SERIAL_RANGE');
871: fnd_msg_pub.ADD;
872: RAISE fnd_api.g_exc_unexpected_error;
873: END IF;
874:

Line 911: fnd_message.set_name ('INV', 'INVALID_SERIAL_NUMBER');

907: , '9'
908: );
909: END IF;
910:
911: fnd_message.set_name ('INV', 'INVALID_SERIAL_NUMBER');
912: fnd_msg_pub.ADD;
913: RAISE fnd_api.g_exc_unexpected_error;
914: END IF;
915: END LOOP;

Line 955: fnd_message.set_name ('INV', 'INV_INVALID_SERIAL_RANGE');

951: , '9'
952: );
953: END IF;
954:
955: fnd_message.set_name ('INV', 'INV_INVALID_SERIAL_RANGE');
956: fnd_msg_pub.ADD;
957: RAISE fnd_api.g_exc_unexpected_error;
958: END IF;
959:

Line 1009: fnd_message.set_name ('INV', 'INVALID_SERIAL_NUMBER');

1005: , '9'
1006: );
1007: END IF;
1008:
1009: fnd_message.set_name ('INV', 'INVALID_SERIAL_NUMBER');
1010: fnd_msg_pub.ADD;
1011: RAISE fnd_api.g_exc_unexpected_error;
1012: END IF;
1013: END LOOP;

Line 1429: --FND_MESSAGE.clear;

1425: x_return_status := fnd_api.g_ret_sts_success;
1426: --Bug: 3559328: Performance bug fix. The fnd API to clear is
1427: --already called in the private API. Since this is just a wrapper,
1428: --we do not need to call it here as it would alreday have been cleared
1429: --FND_MESSAGE.clear;
1430: END IF;
1431: EXCEPTION
1432: WHEN OTHERS
1433: THEN

Line 1447: fnd_message.CLEAR;

1443: );
1444: END IF;
1445:
1446: x_return_status := fnd_api.g_ret_sts_error;
1447: fnd_message.CLEAR;
1448: END validate_group;
1449:
1450: /******* LINE VALIDATION OBJECTS ***************/
1451:

Line 2229: /* FND_MESSAGE.SET_NAME('INV', 'BAD_INPUT_ARGUMENTS');

2225: );
2226:
2227: END IF;
2228:
2229: /* FND_MESSAGE.SET_NAME('INV', 'BAD_INPUT_ARGUMENTS');
2230: FND_MSG_PUB.ADD;
2231: RAISE FND_API.G_EXC_ERROR; */
2232:
2233: /*----------------------------------------------------------+

Line 2400: fnd_message.set_name ('INV', 'INV_PROC_WARN');

2396: THEN
2397: COMMIT WORK;
2398: END IF;
2399:
2400: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2401: l_disp := fnd_message.get;
2402:
2403: IF (l_debug = 1)
2404: THEN

Line 2401: l_disp := fnd_message.get;

2397: COMMIT WORK;
2398: END IF;
2399:
2400: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2401: l_disp := fnd_message.get;
2402:
2403: IF (l_debug = 1)
2404: THEN
2405: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 2436: fnd_message.set_name ('INV', 'INV_CALL_PROC');

2432: , 9
2433: );
2434: END IF;
2435:
2436: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2437: fnd_message.set_token ('token1', l_header_id);
2438: fnd_message.set_token ('token2', l_totrows);
2439: l_disp := fnd_message.get;
2440:

Line 2437: fnd_message.set_token ('token1', l_header_id);

2433: );
2434: END IF;
2435:
2436: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2437: fnd_message.set_token ('token1', l_header_id);
2438: fnd_message.set_token ('token2', l_totrows);
2439: l_disp := fnd_message.get;
2440:
2441: IF (l_debug = 1)

Line 2438: fnd_message.set_token ('token2', l_totrows);

2434: END IF;
2435:
2436: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2437: fnd_message.set_token ('token1', l_header_id);
2438: fnd_message.set_token ('token2', l_totrows);
2439: l_disp := fnd_message.get;
2440:
2441: IF (l_debug = 1)
2442: THEN

Line 2439: l_disp := fnd_message.get;

2435:
2436: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2437: fnd_message.set_token ('token1', l_header_id);
2438: fnd_message.set_token ('token2', l_totrows);
2439: l_disp := fnd_message.get;
2440:
2441: IF (l_debug = 1)
2442: THEN
2443: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 2492: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');

2488: END IF;
2489:
2490: IF (l_result <> 0)
2491: THEN
2492: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
2493:
2494: IF (l_debug = 1)
2495: THEN
2496: inv_log_util.TRACE ('Error from PROCESS_LPN_TRX.. ' || l_msg_data

Line 2526: fnd_message.set_name ('INV', 'INV_RETURN_PROC');

2522: END IF;
2523:
2524: IF (FIRST)
2525: THEN
2526: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
2527: l_disp := fnd_message.get;
2528:
2529: IF (l_debug = 1)
2530: THEN

Line 2527: l_disp := fnd_message.get;

2523:
2524: IF (FIRST)
2525: THEN
2526: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
2527: l_disp := fnd_message.get;
2528:
2529: IF (l_debug = 1)
2530: THEN
2531: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 2544: l_error_exp := fnd_message.get;

2540: IF (FIRST)
2541: THEN
2542: IF (NOT bflushchk (l_header_id))
2543: THEN
2544: l_error_exp := fnd_message.get;
2545:
2546: IF (l_debug = 1)
2547: THEN
2548: inv_log_util.TRACE ('Error in call to bflushchk'

Line 2560: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');

2556: END IF;
2557:
2558: IF (l_header_id <> -1)
2559: THEN
2560: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
2561: l_disp := fnd_message.get;
2562:
2563: IF (l_debug = 1)
2564: THEN

Line 2561: l_disp := fnd_message.get;

2557:
2558: IF (l_header_id <> -1)
2559: THEN
2560: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
2561: l_disp := fnd_message.get;
2562:
2563: IF (l_debug = 1)
2564: THEN
2565: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 2587: fnd_message.set_name ('INV', 'INV_CALL_PROC');

2583: AND process_flag = 'Y'
2584: AND ROWNUM < 201;
2585: END IF;
2586:
2587: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2588: fnd_message.set_token ('token1', l_header_id);
2589: fnd_message.set_token ('token2', l_totrows);
2590: l_disp := fnd_message.get;
2591:

Line 2588: fnd_message.set_token ('token1', l_header_id);

2584: AND ROWNUM < 201;
2585: END IF;
2586:
2587: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2588: fnd_message.set_token ('token1', l_header_id);
2589: fnd_message.set_token ('token2', l_totrows);
2590: l_disp := fnd_message.get;
2591:
2592: IF (l_debug = 1)

Line 2589: fnd_message.set_token ('token2', l_totrows);

2585: END IF;
2586:
2587: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2588: fnd_message.set_token ('token1', l_header_id);
2589: fnd_message.set_token ('token2', l_totrows);
2590: l_disp := fnd_message.get;
2591:
2592: IF (l_debug = 1)
2593: THEN

Line 2590: l_disp := fnd_message.get;

2586:
2587: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2588: fnd_message.set_token ('token1', l_header_id);
2589: fnd_message.set_token ('token2', l_totrows);
2590: l_disp := fnd_message.get;
2591:
2592: IF (l_debug = 1)
2593: THEN
2594: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 2610: fnd_message.set_name ('INV', 'INV_RETURN_PROC');

2606: AND ROWNUM < 201;
2607:
2608: IF SQL%NOTFOUND
2609: THEN
2610: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
2611: done := TRUE;
2612: END IF;
2613: END IF;
2614: END LOOP;

Line 2740: fnd_message.set_name ('INV', 'INV_PROC_WARN');

2736: END IF;
2737:
2738: IF (l_totrows = 0)
2739: THEN
2740: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2741: l_disp := fnd_message.get;
2742:
2743: IF (l_debug = 1)
2744: THEN

Line 2741: l_disp := fnd_message.get;

2737:
2738: IF (l_totrows = 0)
2739: THEN
2740: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2741: l_disp := fnd_message.get;
2742:
2743: IF (l_debug = 1)
2744: THEN
2745: inv_log_util.TRACE (l_disp || ' totrows = 0'

Line 3026: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');

3022: IF (l_index = 1)
3023: THEN
3024: IF (l_line_rec_type.transaction_action_id = 40)
3025: THEN
3026: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3027: l_error_code := fnd_message.get;
3028: inv_lot_trx_validation_pvt.validate_lot_split_trx
3029: (x_return_status => x_return_status
3030: , x_msg_count => x_msg_count

Line 3027: l_error_code := fnd_message.get;

3023: THEN
3024: IF (l_line_rec_type.transaction_action_id = 40)
3025: THEN
3026: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3027: l_error_code := fnd_message.get;
3028: inv_lot_trx_validation_pvt.validate_lot_split_trx
3029: (x_return_status => x_return_status
3030: , x_msg_count => x_msg_count
3031: , x_msg_data => x_msg_data

Line 3071: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');

3067: RAISE rollback_line_validation;
3068: END IF;
3069: ELSIF (l_line_rec_type.transaction_action_id = 41)
3070: THEN
3071: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3072: l_error_code := fnd_message.get;
3073: inv_lot_trx_validation_pvt.validate_lot_merge_trx
3074: (x_return_status => x_return_status
3075: , x_msg_count => x_msg_count

Line 3072: l_error_code := fnd_message.get;

3068: END IF;
3069: ELSIF (l_line_rec_type.transaction_action_id = 41)
3070: THEN
3071: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3072: l_error_code := fnd_message.get;
3073: inv_lot_trx_validation_pvt.validate_lot_merge_trx
3074: (x_return_status => x_return_status
3075: , x_msg_count => x_msg_count
3076: , x_msg_data => x_msg_data

Line 3116: fnd_message.set_name ('INV'

3112: RAISE rollback_line_validation;
3113: END IF;
3114: ELSIF (l_line_rec_type.transaction_action_id = 42)
3115: THEN
3116: fnd_message.set_name ('INV'
3117: , 'INV_LOT_TRANSLATE_VALIDATIONS'
3118: );
3119: l_error_code := fnd_message.get;
3120: inv_lot_trx_validation_pvt.validate_lot_translate_trx

Line 3119: l_error_code := fnd_message.get;

3115: THEN
3116: fnd_message.set_name ('INV'
3117: , 'INV_LOT_TRANSLATE_VALIDATIONS'
3118: );
3119: l_error_code := fnd_message.get;
3120: inv_lot_trx_validation_pvt.validate_lot_translate_trx
3121: (x_return_status => x_return_status
3122: , x_msg_count => x_msg_count
3123: , x_msg_data => x_msg_data

Line 3175: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');

3171: )
3172: THEN
3173: IF (l_line_rec_type.transaction_action_id = 40)
3174: THEN
3175: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3176: l_error_code := fnd_message.get;
3177: ELSIF (l_line_rec_type.transaction_action_id = 41)
3178: THEN
3179: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');

Line 3176: l_error_code := fnd_message.get;

3172: THEN
3173: IF (l_line_rec_type.transaction_action_id = 40)
3174: THEN
3175: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3176: l_error_code := fnd_message.get;
3177: ELSIF (l_line_rec_type.transaction_action_id = 41)
3178: THEN
3179: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3180: l_error_code := fnd_message.get;

Line 3179: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');

3175: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3176: l_error_code := fnd_message.get;
3177: ELSIF (l_line_rec_type.transaction_action_id = 41)
3178: THEN
3179: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3180: l_error_code := fnd_message.get;
3181: ELSIF (l_line_rec_type.transaction_action_id = 42)
3182: THEN
3183: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');

Line 3180: l_error_code := fnd_message.get;

3176: l_error_code := fnd_message.get;
3177: ELSIF (l_line_rec_type.transaction_action_id = 41)
3178: THEN
3179: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3180: l_error_code := fnd_message.get;
3181: ELSIF (l_line_rec_type.transaction_action_id = 42)
3182: THEN
3183: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3184: l_error_code := fnd_message.get;

Line 3183: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');

3179: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3180: l_error_code := fnd_message.get;
3181: ELSIF (l_line_rec_type.transaction_action_id = 42)
3182: THEN
3183: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3184: l_error_code := fnd_message.get;
3185: END IF;
3186:
3187: UPDATE mtl_transactions_interface

Line 3184: l_error_code := fnd_message.get;

3180: l_error_code := fnd_message.get;
3181: ELSIF (l_line_rec_type.transaction_action_id = 42)
3182: THEN
3183: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3184: l_error_code := fnd_message.get;
3185: END IF;
3186:
3187: UPDATE mtl_transactions_interface
3188: SET last_update_date = SYSDATE

Line 3317: FND_MESSAGE.set_name('INV', 'INV_NO_CONVERSION_ERR');

3313: IF (l_trx_qty = -99999) THEN
3314: IF (l_debug = 1) THEN
3315: inv_log_util.trace('Validate_Transactions: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);
3316: END IF;
3317: FND_MESSAGE.set_name('INV', 'INV_NO_CONVERSION_ERR');
3318: l_error_code:= fnd_message.get;
3319:
3320: UPDATE MTL_TRANSACTIONS_INTERFACE
3321: SET LAST_UPDATE_DATE = SYSDATE,

Line 3318: l_error_code:= fnd_message.get;

3314: IF (l_debug = 1) THEN
3315: inv_log_util.trace('Validate_Transactions: INV_CONVERT.INV_UM_CONVERT error while calculating primary qty', 'INV_TXN_MANAGER_GRP', 9);
3316: END IF;
3317: FND_MESSAGE.set_name('INV', 'INV_NO_CONVERSION_ERR');
3318: l_error_code:= fnd_message.get;
3319:
3320: UPDATE MTL_TRANSACTIONS_INTERFACE
3321: SET LAST_UPDATE_DATE = SYSDATE,
3322: LAST_UPDATED_BY = l_userid,

Line 3530: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');

3526: IF l_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) THEN
3527: IF (l_debug = 1) THEN
3528: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3529: END IF;
3530: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
3531: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3532: l_error_code := FND_MESSAGE.get;
3533: l_error_exp := l_msg_data;
3534: x_msg_data := l_msg_data;

Line 3531: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');

3527: IF (l_debug = 1) THEN
3528: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3529: END IF;
3530: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
3531: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3532: l_error_code := FND_MESSAGE.get;
3533: l_error_exp := l_msg_data;
3534: x_msg_data := l_msg_data;
3535: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3532: l_error_code := FND_MESSAGE.get;

3528: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3529: END IF;
3530: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
3531: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3532: l_error_code := FND_MESSAGE.get;
3533: l_error_exp := l_msg_data;
3534: x_msg_data := l_msg_data;
3535: UPDATE MTL_TRANSACTIONS_INTERFACE
3536: SET LAST_UPDATE_DATE = SYSDATE,

Line 3596: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

3592: IF (l_debug = 1) THEN
3593: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3594: END IF;
3595:
3596: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3597: FND_MESSAGE.set_token('token1','XACT_QTY1');
3598: l_error_code := FND_MESSAGE.get;
3599: l_error_exp := l_msg_data;
3600: x_msg_data := l_msg_data;

Line 3597: FND_MESSAGE.set_token('token1','XACT_QTY1');

3593: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3594: END IF;
3595:
3596: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3597: FND_MESSAGE.set_token('token1','XACT_QTY1');
3598: l_error_code := FND_MESSAGE.get;
3599: l_error_exp := l_msg_data;
3600: x_msg_data := l_msg_data;
3601: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3598: l_error_code := FND_MESSAGE.get;

3594: END IF;
3595:
3596: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3597: FND_MESSAGE.set_token('token1','XACT_QTY1');
3598: l_error_code := FND_MESSAGE.get;
3599: l_error_exp := l_msg_data;
3600: x_msg_data := l_msg_data;
3601: UPDATE MTL_TRANSACTIONS_INTERFACE
3602: SET LAST_UPDATE_DATE = SYSDATE,

Line 3637: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

3633: IF (l_debug = 1) THEN
3634: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3635: END IF;
3636:
3637: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3638: FND_MESSAGE.set_token('token1','XACT_QTY1');
3639: l_error_code := FND_MESSAGE.get;
3640: l_error_exp := l_msg_data;
3641: x_msg_data := l_msg_data;

Line 3638: FND_MESSAGE.set_token('token1','XACT_QTY1');

3634: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3635: END IF;
3636:
3637: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3638: FND_MESSAGE.set_token('token1','XACT_QTY1');
3639: l_error_code := FND_MESSAGE.get;
3640: l_error_exp := l_msg_data;
3641: x_msg_data := l_msg_data;
3642: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3639: l_error_code := FND_MESSAGE.get;

3635: END IF;
3636:
3637: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3638: FND_MESSAGE.set_token('token1','XACT_QTY1');
3639: l_error_code := FND_MESSAGE.get;
3640: l_error_exp := l_msg_data;
3641: x_msg_data := l_msg_data;
3642: UPDATE MTL_TRANSACTIONS_INTERFACE
3643: SET LAST_UPDATE_DATE = SYSDATE,

Line 3731: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');

3727: existing reservation and can drive inventory go negative.
3728: */
3729: IF (l_override_rsv_for_backflush <> 1 ) THEN
3730: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3731: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3732: l_error_code := FND_MESSAGE.get;
3733: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3734: l_error_exp := FND_MESSAGE.get;
3735: x_msg_data := l_error_exp;

Line 3732: l_error_code := FND_MESSAGE.get;

3728: */
3729: IF (l_override_rsv_for_backflush <> 1 ) THEN
3730: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3731: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3732: l_error_code := FND_MESSAGE.get;
3733: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3734: l_error_exp := FND_MESSAGE.get;
3735: x_msg_data := l_error_exp;
3736: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3733: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');

3729: IF (l_override_rsv_for_backflush <> 1 ) THEN
3730: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3731: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3732: l_error_code := FND_MESSAGE.get;
3733: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3734: l_error_exp := FND_MESSAGE.get;
3735: x_msg_data := l_error_exp;
3736: UPDATE MTL_TRANSACTIONS_INTERFACE
3737: SET LAST_UPDATE_DATE = SYSDATE,

Line 3734: l_error_exp := FND_MESSAGE.get;

3730: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3731: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3732: l_error_code := FND_MESSAGE.get;
3733: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3734: l_error_exp := FND_MESSAGE.get;
3735: x_msg_data := l_error_exp;
3736: UPDATE MTL_TRANSACTIONS_INTERFACE
3737: SET LAST_UPDATE_DATE = SYSDATE,
3738: LAST_UPDATED_BY = l_userid,

Line 3793: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

3789: IF (l_debug = 1) THEN
3790: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3791: END IF;
3792:
3793: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3794: FND_MESSAGE.set_token('token1','XACT_QTY1');
3795: l_error_code := FND_MESSAGE.get;
3796: l_error_exp := l_msg_data;
3797: x_msg_data := l_msg_data;

Line 3794: FND_MESSAGE.set_token('token1','XACT_QTY1');

3790: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3791: END IF;
3792:
3793: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3794: FND_MESSAGE.set_token('token1','XACT_QTY1');
3795: l_error_code := FND_MESSAGE.get;
3796: l_error_exp := l_msg_data;
3797: x_msg_data := l_msg_data;
3798: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3795: l_error_code := FND_MESSAGE.get;

3791: END IF;
3792:
3793: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3794: FND_MESSAGE.set_token('token1','XACT_QTY1');
3795: l_error_code := FND_MESSAGE.get;
3796: l_error_exp := l_msg_data;
3797: x_msg_data := l_msg_data;
3798: UPDATE MTL_TRANSACTIONS_INTERFACE
3799: SET LAST_UPDATE_DATE = SYSDATE,

Line 3833: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

3829: IF (l_debug = 1) THEN
3830: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3831: END IF;
3832:
3833: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3834: FND_MESSAGE.set_token('token1','XACT_QTY1');
3835: l_error_code := FND_MESSAGE.get;
3836: l_error_exp := l_msg_data;
3837: x_msg_data := l_msg_data;

Line 3834: FND_MESSAGE.set_token('token1','XACT_QTY1');

3830: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3831: END IF;
3832:
3833: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3834: FND_MESSAGE.set_token('token1','XACT_QTY1');
3835: l_error_code := FND_MESSAGE.get;
3836: l_error_exp := l_msg_data;
3837: x_msg_data := l_msg_data;
3838: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3835: l_error_code := FND_MESSAGE.get;

3831: END IF;
3832:
3833: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3834: FND_MESSAGE.set_token('token1','XACT_QTY1');
3835: l_error_code := FND_MESSAGE.get;
3836: l_error_exp := l_msg_data;
3837: x_msg_data := l_msg_data;
3838: UPDATE MTL_TRANSACTIONS_INTERFACE
3839: SET LAST_UPDATE_DATE = SYSDATE,

Line 3887: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');

3883: consume existing reservations.Else it can consume existing reservation and can
3884: drive inventory negative. */
3885: IF (l_override_rsv_for_backflush <> 1 ) THEN
3886: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3887: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3888: l_error_code := FND_MESSAGE.get;
3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3890: l_error_exp := FND_MESSAGE.get;
3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

Line 3888: l_error_code := FND_MESSAGE.get;

3884: drive inventory negative. */
3885: IF (l_override_rsv_for_backflush <> 1 ) THEN
3886: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3887: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3888: l_error_code := FND_MESSAGE.get;
3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3890: l_error_exp := FND_MESSAGE.get;
3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3892: x_msg_data := l_error_exp;

Line 3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');

3885: IF (l_override_rsv_for_backflush <> 1 ) THEN
3886: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3887: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3888: l_error_code := FND_MESSAGE.get;
3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3890: l_error_exp := FND_MESSAGE.get;
3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3892: x_msg_data := l_error_exp;
3893: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3890: l_error_exp := FND_MESSAGE.get;

3886: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3887: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3888: l_error_code := FND_MESSAGE.get;
3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3890: l_error_exp := FND_MESSAGE.get;
3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3892: x_msg_data := l_error_exp;
3893: UPDATE MTL_TRANSACTIONS_INTERFACE
3894: SET LAST_UPDATE_DATE = SYSDATE,

Line 3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

3887: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3888: l_error_code := FND_MESSAGE.get;
3889: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3890: l_error_exp := FND_MESSAGE.get;
3891: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3892: x_msg_data := l_error_exp;
3893: UPDATE MTL_TRANSACTIONS_INTERFACE
3894: SET LAST_UPDATE_DATE = SYSDATE,
3895: LAST_UPDATED_BY = l_userid,

Line 3931: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');

3927: ELSE --(neg_inv_rcpt = 1)
3928: IF (l_debug = 1) THEN
3929: inv_log_util.trace('Not Enough Qty: l_att,l_trx_qty:' || l_att||','||l_trx_qty,'INV_TXN_MANAGER_PUB', 9);
3930: END IF;
3931: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3932: l_error_code := FND_MESSAGE.get;
3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);

Line 3932: l_error_code := FND_MESSAGE.get;

3928: IF (l_debug = 1) THEN
3929: inv_log_util.trace('Not Enough Qty: l_att,l_trx_qty:' || l_att||','||l_trx_qty,'INV_TXN_MANAGER_PUB', 9);
3930: END IF;
3931: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3932: l_error_code := FND_MESSAGE.get;
3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3936: l_error_exp := FND_MESSAGE.get;

Line 3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');

3929: inv_log_util.trace('Not Enough Qty: l_att,l_trx_qty:' || l_att||','||l_trx_qty,'INV_TXN_MANAGER_PUB', 9);
3930: END IF;
3931: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3932: l_error_code := FND_MESSAGE.get;
3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3936: l_error_exp := FND_MESSAGE.get;
3937: x_msg_data := l_error_exp;

Line 3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);

3930: END IF;
3931: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3932: l_error_code := FND_MESSAGE.get;
3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3936: l_error_exp := FND_MESSAGE.get;
3937: x_msg_data := l_error_exp;
3938: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);

3931: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3932: l_error_code := FND_MESSAGE.get;
3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3936: l_error_exp := FND_MESSAGE.get;
3937: x_msg_data := l_error_exp;
3938: UPDATE MTL_TRANSACTIONS_INTERFACE
3939: SET LAST_UPDATE_DATE = SYSDATE,

Line 3936: l_error_exp := FND_MESSAGE.get;

3932: l_error_code := FND_MESSAGE.get;
3933: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3934: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3935: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3936: l_error_exp := FND_MESSAGE.get;
3937: x_msg_data := l_error_exp;
3938: UPDATE MTL_TRANSACTIONS_INTERFACE
3939: SET LAST_UPDATE_DATE = SYSDATE,
3940: LAST_UPDATED_BY = l_userid,

Line 4004: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');

4000: x_atr => l_atr);
4001:
4002:
4003: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4004: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4005: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4006: l_error_code:= fnd_message.get;
4007: l_error_exp :=l_msg_data;
4008: x_msg_data := l_msg_data;

Line 4005: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');

4001:
4002:
4003: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4004: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4005: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4006: l_error_code:= fnd_message.get;
4007: l_error_exp :=l_msg_data;
4008: x_msg_data := l_msg_data;
4009: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 4006: l_error_code:= fnd_message.get;

4002:
4003: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4004: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4005: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4006: l_error_code:= fnd_message.get;
4007: l_error_exp :=l_msg_data;
4008: x_msg_data := l_msg_data;
4009: UPDATE MTL_TRANSACTIONS_INTERFACE
4010: SET LAST_UPDATE_DATE = SYSDATE,

Line 4073: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');

4069: x_att => l_att,
4070: x_atr => l_atr);
4071:
4072: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4073: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4074: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4075: l_error_code:= fnd_message.get;
4076: l_error_exp :=l_msg_data;
4077: x_msg_data := l_msg_data;

Line 4074: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');

4070: x_atr => l_atr);
4071:
4072: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4073: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4074: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4075: l_error_code:= fnd_message.get;
4076: l_error_exp :=l_msg_data;
4077: x_msg_data := l_msg_data;
4078: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 4075: l_error_code:= fnd_message.get;

4071:
4072: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4073: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4074: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4075: l_error_code:= fnd_message.get;
4076: l_error_exp :=l_msg_data;
4077: x_msg_data := l_msg_data;
4078: UPDATE MTL_TRANSACTIONS_INTERFACE
4079: SET LAST_UPDATE_DATE = SYSDATE,

Line 4144: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');

4140:
4141: IF l_location_required_flag = 'Y' AND
4142: l_line_rec_type.ship_to_location_id IS NULL THEN
4143:
4144: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');
4145: l_error_code := FND_MESSAGE.GET;
4146:
4147: UPDATE MTL_TRANSACTIONS_INTERFACE
4148: SET LAST_UPDATE_DATE = SYSDATE,

Line 4145: l_error_code := FND_MESSAGE.GET;

4141: IF l_location_required_flag = 'Y' AND
4142: l_line_rec_type.ship_to_location_id IS NULL THEN
4143:
4144: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');
4145: l_error_code := FND_MESSAGE.GET;
4146:
4147: UPDATE MTL_TRANSACTIONS_INTERFACE
4148: SET LAST_UPDATE_DATE = SYSDATE,
4149: LAST_UPDATED_BY = l_userid,

Line 4165: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');

4161: END;
4162: --End of new code added as per the eIB TDD; Bug# 4348541
4163:
4164: SAVEPOINT line_validation_svpt;
4165: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');
4166: fnd_message.set_token ('token', l_header_id);
4167: l_disp := fnd_message.get;
4168:
4169: IF (l_debug = 1)

Line 4166: fnd_message.set_token ('token', l_header_id);

4162: --End of new code added as per the eIB TDD; Bug# 4348541
4163:
4164: SAVEPOINT line_validation_svpt;
4165: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');
4166: fnd_message.set_token ('token', l_header_id);
4167: l_disp := fnd_message.get;
4168:
4169: IF (l_debug = 1)
4170: THEN

Line 4167: l_disp := fnd_message.get;

4163:
4164: SAVEPOINT line_validation_svpt;
4165: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');
4166: fnd_message.set_token ('token', l_header_id);
4167: l_disp := fnd_message.get;
4168:
4169: IF (l_debug = 1)
4170: THEN
4171: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4194: l_error_exp := fnd_message.get;

4190: , l_index
4191: )
4192: )
4193: THEN
4194: l_error_exp := fnd_message.get;
4195:
4196: IF (l_debug = 1)
4197: THEN
4198: inv_log_util.TRACE ( 'Error in Check_Partial_Split= '

Line 4205: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');

4201: , 9
4202: );
4203: END IF;
4204:
4205: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4206: l_error_code := fnd_message.get;
4207: ROLLBACK TO line_validation_svpt;
4208:
4209: UPDATE mtl_transactions_interface

Line 4206: l_error_code := fnd_message.get;

4202: );
4203: END IF;
4204:
4205: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4206: l_error_code := fnd_message.get;
4207: ROLLBACK TO line_validation_svpt;
4208:
4209: UPDATE mtl_transactions_interface
4210: SET last_update_date = SYSDATE

Line 4446: l_error_exp := fnd_message.get;

4442: END IF;
4443:
4444: IF (NOT tmpinsert (l_header_id))
4445: THEN
4446: l_error_exp := fnd_message.get;
4447:
4448: IF (l_debug = 1)
4449: THEN
4450: inv_log_util.TRACE ('Error in tmpinsert=' || l_error_exp

Line 4456: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');

4452: , 9
4453: );
4454: END IF;
4455:
4456: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4457: l_error_code := fnd_message.get;
4458: RAISE fnd_api.g_exc_unexpected_error;
4459: ELSE
4460: BEGIN

Line 4457: l_error_code := fnd_message.get;

4453: );
4454: END IF;
4455:
4456: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4457: l_error_code := fnd_message.get;
4458: RAISE fnd_api.g_exc_unexpected_error;
4459: ELSE
4460: BEGIN
4461: IF(l_debug = 1) THEN

Line 4485: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');

4481: inv_log_util.TRACE ( 'tmpinsert2 raised exception '
4482: , 'INV_TXN_MANAGER_PUB'
4483: , 9
4484: );
4485: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4486: l_error_code := fnd_message.get;
4487: RAISE fnd_api.g_exc_unexpected_error;
4488: END;
4489:

Line 4486: l_error_code := fnd_message.get;

4482: , 'INV_TXN_MANAGER_PUB'
4483: , 9
4484: );
4485: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4486: l_error_code := fnd_message.get;
4487: RAISE fnd_api.g_exc_unexpected_error;
4488: END;
4489:
4490: IF(x_return_status <> fnd_api.g_ret_sts_success OR

Line 4602: fnd_message.set_name ('INV', 'INV_CALL_PROC');

4598: SAVEPOINT process_trx_save;
4599:
4600: IF (FIRST)
4601: THEN
4602: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4603: fnd_message.set_token ('token1', l_header_id);
4604: fnd_message.set_token ('token2', l_totrows);
4605: l_disp := fnd_message.get;
4606:

Line 4603: fnd_message.set_token ('token1', l_header_id);

4599:
4600: IF (FIRST)
4601: THEN
4602: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4603: fnd_message.set_token ('token1', l_header_id);
4604: fnd_message.set_token ('token2', l_totrows);
4605: l_disp := fnd_message.get;
4606:
4607: IF (l_debug = 1)

Line 4604: fnd_message.set_token ('token2', l_totrows);

4600: IF (FIRST)
4601: THEN
4602: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4603: fnd_message.set_token ('token1', l_header_id);
4604: fnd_message.set_token ('token2', l_totrows);
4605: l_disp := fnd_message.get;
4606:
4607: IF (l_debug = 1)
4608: THEN

Line 4605: l_disp := fnd_message.get;

4601: THEN
4602: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4603: fnd_message.set_token ('token1', l_header_id);
4604: fnd_message.set_token ('token2', l_totrows);
4605: l_disp := fnd_message.get;
4606:
4607: IF (l_debug = 1)
4608: THEN
4609: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4612: --FND_MESSAGE.set_name('INV','INV_RETURN_PROC');

4608: THEN
4609: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);
4610: END IF;
4611:
4612: --FND_MESSAGE.set_name('INV','INV_RETURN_PROC');
4613: --l_disp := FND_MESSAGE.get;
4614: --inv_log_util.trace(l_disp, 'INV_TXN_MANAGER_PUB',9);
4615: SELECT COUNT (*)
4616: INTO l_totrows

Line 4613: --l_disp := FND_MESSAGE.get;

4609: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);
4610: END IF;
4611:
4612: --FND_MESSAGE.set_name('INV','INV_RETURN_PROC');
4613: --l_disp := FND_MESSAGE.get;
4614: --inv_log_util.trace(l_disp, 'INV_TXN_MANAGER_PUB',9);
4615: SELECT COUNT (*)
4616: INTO l_totrows
4617: FROM mtl_material_transactions_temp

Line 4624: fnd_message.set_name ('INV', 'INV_PROC_WARN');

4620: x_trans_count := l_totrows;
4621:
4622: IF (l_totrows = 0)
4623: THEN
4624: fnd_message.set_name ('INV', 'INV_PROC_WARN');
4625: l_disp := fnd_message.get;
4626:
4627: IF (l_debug = 1)
4628: THEN

Line 4625: l_disp := fnd_message.get;

4621:
4622: IF (l_totrows = 0)
4623: THEN
4624: fnd_message.set_name ('INV', 'INV_PROC_WARN');
4625: l_disp := fnd_message.get;
4626:
4627: IF (l_debug = 1)
4628: THEN
4629: inv_log_util.TRACE (l_disp || ' totrows = 0'

Line 4697: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');

4693: THEN
4694: l_error_exp := l_msg_data;
4695: x_msg_data := l_msg_data;
4696: x_return_status := l_return_status;
4697: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
4698: l_error_code := fnd_message.get;
4699:
4700: IF (l_debug = 1)
4701: THEN

Line 4698: l_error_code := fnd_message.get;

4694: l_error_exp := l_msg_data;
4695: x_msg_data := l_msg_data;
4696: x_return_status := l_return_status;
4697: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
4698: l_error_code := fnd_message.get;
4699:
4700: IF (l_debug = 1)
4701: THEN
4702: inv_log_util.TRACE ( 'PROCESS_LPN_TRX failed for header_id '

Line 4776: l_error_code := fnd_message.get;

4772: END IF;
4773:
4774: IF (NOT bflushchk (l_header_id))
4775: THEN
4776: l_error_code := fnd_message.get;
4777:
4778: IF (l_debug = 1)
4779: THEN
4780: inv_log_util.TRACE ( 'Error in bflushchk header_id:'

Line 4795: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');

4791: END IF;
4792:
4793: IF (l_header_id <> -1)
4794: THEN
4795: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
4796: l_disp := fnd_message.get;
4797:
4798: IF (l_debug = 1)
4799: THEN

Line 4796: l_disp := fnd_message.get;

4792:
4793: IF (l_header_id <> -1)
4794: THEN
4795: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
4796: l_disp := fnd_message.get;
4797:
4798: IF (l_debug = 1)
4799: THEN
4800: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4830: fnd_message.set_name ('INV', 'INV_CALL_PROC');

4826: AND process_flag = 'Y'
4827: AND ROWNUM < 201;
4828: END IF;
4829:
4830: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4831: fnd_message.set_token ('token1', l_header_id);
4832: fnd_message.set_token ('token2', l_totrows);
4833: l_disp := fnd_message.get;
4834:

Line 4831: fnd_message.set_token ('token1', l_header_id);

4827: AND ROWNUM < 201;
4828: END IF;
4829:
4830: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4831: fnd_message.set_token ('token1', l_header_id);
4832: fnd_message.set_token ('token2', l_totrows);
4833: l_disp := fnd_message.get;
4834:
4835: IF (l_debug = 1)

Line 4832: fnd_message.set_token ('token2', l_totrows);

4828: END IF;
4829:
4830: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4831: fnd_message.set_token ('token1', l_header_id);
4832: fnd_message.set_token ('token2', l_totrows);
4833: l_disp := fnd_message.get;
4834:
4835: IF (l_debug = 1)
4836: THEN

Line 4833: l_disp := fnd_message.get;

4829:
4830: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4831: fnd_message.set_token ('token1', l_header_id);
4832: fnd_message.set_token ('token2', l_totrows);
4833: l_disp := fnd_message.get;
4834:
4835: IF (l_debug = 1)
4836: THEN
4837: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4852: fnd_message.set_name ('INV', 'INV_RETURN_PROC');

4848: AND ROWNUM < 201;
4849:
4850: IF SQL%NOTFOUND
4851: THEN
4852: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
4853: l_disp := fnd_message.get;
4854:
4855: IF (l_debug = 1)
4856: THEN

Line 4853: l_disp := fnd_message.get;

4849:
4850: IF SQL%NOTFOUND
4851: THEN
4852: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
4853: l_disp := fnd_message.get;
4854:
4855: IF (l_debug = 1)
4856: THEN
4857: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4867: fnd_message.set_name ('INV', 'INV_MGR_WARN');

4863: END LOOP;
4864:
4865: IF (l_initotrows > l_midtotrows)
4866: THEN
4867: fnd_message.set_name ('INV', 'INV_MGR_WARN');
4868: l_disp := fnd_message.get;
4869:
4870: IF (l_debug = 1)
4871: THEN

Line 4868: l_disp := fnd_message.get;

4864:
4865: IF (l_initotrows > l_midtotrows)
4866: THEN
4867: fnd_message.set_name ('INV', 'INV_MGR_WARN');
4868: l_disp := fnd_message.get;
4869:
4870: IF (l_debug = 1)
4871: THEN
4872: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4900: fnd_message.set_name ('INV', 'INV_INT_SQLCODE');

4896: );
4897: END IF;
4898:
4899:
4900: fnd_message.set_name ('INV', 'INV_INT_SQLCODE');
4901: l_error_code := fnd_message.get;
4902:
4903: IF NOT fnd_api.to_boolean (p_commit)
4904: THEN

Line 4901: l_error_code := fnd_message.get;

4897: END IF;
4898:
4899:
4900: fnd_message.set_name ('INV', 'INV_INT_SQLCODE');
4901: l_error_code := fnd_message.get;
4902:
4903: IF NOT fnd_api.to_boolean (p_commit)
4904: THEN
4905: ROLLBACK TO process_transactions_svpt;

Line 4958: fnd_message.set_name ('MRP', 'GEN-invalid entity');

4954: IF (p_relief_type = mds_relief)
4955: THEN
4956: IF (p_disposition <> r_sales_order)
4957: THEN
4958: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4959: fnd_message.set_token ('ENTITY', 'disposition');
4960: fnd_message.set_token ('VALUE', p_disposition);
4961: RETURN (FALSE);
4962: END IF;

Line 4959: fnd_message.set_token ('ENTITY', 'disposition');

4955: THEN
4956: IF (p_disposition <> r_sales_order)
4957: THEN
4958: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4959: fnd_message.set_token ('ENTITY', 'disposition');
4960: fnd_message.set_token ('VALUE', p_disposition);
4961: RETURN (FALSE);
4962: END IF;
4963: ELSE

Line 4960: fnd_message.set_token ('VALUE', p_disposition);

4956: IF (p_disposition <> r_sales_order)
4957: THEN
4958: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4959: fnd_message.set_token ('ENTITY', 'disposition');
4960: fnd_message.set_token ('VALUE', p_disposition);
4961: RETURN (FALSE);
4962: END IF;
4963: ELSE
4964: IF (p_relief_type = mps_relief)

Line 4969: fnd_message.set_name ('MRP', 'GEN-invalid entity');

4965: THEN
4966: IF (p_disposition <> r_work_order)
4967: AND (p_disposition <> r_purch_order)
4968: THEN
4969: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4970: fnd_message.set_token ('ENTITY', 'disposition');
4971: fnd_message.set_token ('VALUE', p_disposition);
4972: RETURN (FALSE);
4973: END IF;

Line 4970: fnd_message.set_token ('ENTITY', 'disposition');

4966: IF (p_disposition <> r_work_order)
4967: AND (p_disposition <> r_purch_order)
4968: THEN
4969: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4970: fnd_message.set_token ('ENTITY', 'disposition');
4971: fnd_message.set_token ('VALUE', p_disposition);
4972: RETURN (FALSE);
4973: END IF;
4974: ELSE

Line 4971: fnd_message.set_token ('VALUE', p_disposition);

4967: AND (p_disposition <> r_purch_order)
4968: THEN
4969: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4970: fnd_message.set_token ('ENTITY', 'disposition');
4971: fnd_message.set_token ('VALUE', p_disposition);
4972: RETURN (FALSE);
4973: END IF;
4974: ELSE
4975: fnd_message.set_name ('MRP', 'GEN-invalid entity');

Line 4975: fnd_message.set_name ('MRP', 'GEN-invalid entity');

4971: fnd_message.set_token ('VALUE', p_disposition);
4972: RETURN (FALSE);
4973: END IF;
4974: ELSE
4975: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4976: fnd_message.set_token ('ENTITY', 'relief_type');
4977: fnd_message.set_token ('VALUE', p_relief_type);
4978: RETURN (FALSE);
4979: END IF;

Line 4976: fnd_message.set_token ('ENTITY', 'relief_type');

4972: RETURN (FALSE);
4973: END IF;
4974: ELSE
4975: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4976: fnd_message.set_token ('ENTITY', 'relief_type');
4977: fnd_message.set_token ('VALUE', p_relief_type);
4978: RETURN (FALSE);
4979: END IF;
4980: END IF;

Line 4977: fnd_message.set_token ('VALUE', p_relief_type);

4973: END IF;
4974: ELSE
4975: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4976: fnd_message.set_token ('ENTITY', 'relief_type');
4977: fnd_message.set_token ('VALUE', p_relief_type);
4978: RETURN (FALSE);
4979: END IF;
4980: END IF;
4981:

Line 5442: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');

5438: || l_msg_data
5439: , l_procedure_name
5440: , 9
5441: );
5442: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');
5443: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');
5444: l_error_code := fnd_message.get;
5445: l_error_exp := l_msg_data;
5446: RAISE fnd_api.g_exc_error;

Line 5443: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');

5439: , l_procedure_name
5440: , 9
5441: );
5442: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');
5443: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');
5444: l_error_code := fnd_message.get;
5445: l_error_exp := l_msg_data;
5446: RAISE fnd_api.g_exc_error;
5447: END IF;

Line 5444: l_error_code := fnd_message.get;

5440: , 9
5441: );
5442: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');
5443: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');
5444: l_error_code := fnd_message.get;
5445: l_error_exp := l_msg_data;
5446: RAISE fnd_api.g_exc_error;
5447: END IF;
5448:

Line 5508: l_error_code := fnd_message.get;

5504: || l_msg_data
5505: , l_procedure_name
5506: , 9
5507: );
5508: l_error_code := fnd_message.get;
5509: l_error_exp := l_msg_data;
5510: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5511: fnd_message.set_token ('token1', 'XACT_QTY1');
5512: RAISE fnd_api.g_exc_error;

Line 5510: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');

5506: , 9
5507: );
5508: l_error_code := fnd_message.get;
5509: l_error_exp := l_msg_data;
5510: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5511: fnd_message.set_token ('token1', 'XACT_QTY1');
5512: RAISE fnd_api.g_exc_error;
5513: END IF;
5514:

Line 5511: fnd_message.set_token ('token1', 'XACT_QTY1');

5507: );
5508: l_error_code := fnd_message.get;
5509: l_error_exp := l_msg_data;
5510: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5511: fnd_message.set_token ('token1', 'XACT_QTY1');
5512: RAISE fnd_api.g_exc_error;
5513: END IF;
5514:
5515: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 5521: l_error_code := fnd_message.get;

5517: || l_msg_data
5518: , l_procedure_name
5519: , 9
5520: );
5521: l_error_code := fnd_message.get;
5522: l_error_exp := l_msg_data;
5523: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5524: fnd_message.set_token ('token1', 'XACT_QTY1');
5525: RAISE fnd_api.g_exc_unexpected_error;

Line 5523: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');

5519: , 9
5520: );
5521: l_error_code := fnd_message.get;
5522: l_error_exp := l_msg_data;
5523: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5524: fnd_message.set_token ('token1', 'XACT_QTY1');
5525: RAISE fnd_api.g_exc_unexpected_error;
5526: END IF;
5527:

Line 5524: fnd_message.set_token ('token1', 'XACT_QTY1');

5520: );
5521: l_error_code := fnd_message.get;
5522: l_error_exp := l_msg_data;
5523: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5524: fnd_message.set_token ('token1', 'XACT_QTY1');
5525: RAISE fnd_api.g_exc_unexpected_error;
5526: END IF;
5527:
5528: l_progress_indicator := '110';

Line 5564: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');

5560: 'Transaction quantity must be less than or equal to available quantity'
5561: , l_procedure_name
5562: , 9
5563: );
5564: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5565: l_error_code := fnd_message.get;
5566: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5567: l_error_exp := fnd_message.get;
5568: RAISE fnd_api.g_exc_error;

Line 5565: l_error_code := fnd_message.get;

5561: , l_procedure_name
5562: , 9
5563: );
5564: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5565: l_error_code := fnd_message.get;
5566: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5567: l_error_exp := fnd_message.get;
5568: RAISE fnd_api.g_exc_error;
5569: END IF;

Line 5566: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');

5562: , 9
5563: );
5564: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5565: l_error_code := fnd_message.get;
5566: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5567: l_error_exp := fnd_message.get;
5568: RAISE fnd_api.g_exc_error;
5569: END IF;
5570: END IF;

Line 5567: l_error_exp := fnd_message.get;

5563: );
5564: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5565: l_error_code := fnd_message.get;
5566: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5567: l_error_exp := fnd_message.get;
5568: RAISE fnd_api.g_exc_error;
5569: END IF;
5570: END IF;
5571:

Line 5600: l_error_code := fnd_message.get;

5596: || l_msg_data
5597: , l_procedure_name
5598: , 9
5599: );
5600: l_error_code := fnd_message.get;
5601: l_error_exp := l_msg_data;
5602: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5603: fnd_message.set_token ('token1', 'XACT_QTY1');
5604: RAISE fnd_api.g_exc_error;

Line 5602: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');

5598: , 9
5599: );
5600: l_error_code := fnd_message.get;
5601: l_error_exp := l_msg_data;
5602: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5603: fnd_message.set_token ('token1', 'XACT_QTY1');
5604: RAISE fnd_api.g_exc_error;
5605: END IF;
5606:

Line 5603: fnd_message.set_token ('token1', 'XACT_QTY1');

5599: );
5600: l_error_code := fnd_message.get;
5601: l_error_exp := l_msg_data;
5602: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5603: fnd_message.set_token ('token1', 'XACT_QTY1');
5604: RAISE fnd_api.g_exc_error;
5605: END IF;
5606:
5607: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 5615: l_error_code := fnd_message.get;

5611: , l_procedure_name
5612: , 9
5613: );
5614:
5615: l_error_code := fnd_message.get;
5616: l_error_exp := l_msg_data;
5617: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5618: fnd_message.set_token ('token1', 'XACT_QTY1');
5619: RAISE fnd_api.g_exc_unexpected_error;

Line 5617: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');

5613: );
5614:
5615: l_error_code := fnd_message.get;
5616: l_error_exp := l_msg_data;
5617: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5618: fnd_message.set_token ('token1', 'XACT_QTY1');
5619: RAISE fnd_api.g_exc_unexpected_error;
5620: END IF;
5621:

Line 5618: fnd_message.set_token ('token1', 'XACT_QTY1');

5614:
5615: l_error_code := fnd_message.get;
5616: l_error_exp := l_msg_data;
5617: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5618: fnd_message.set_token ('token1', 'XACT_QTY1');
5619: RAISE fnd_api.g_exc_unexpected_error;
5620: END IF;
5621:
5622: l_progress_indicator := '150';

Line 5693: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');

5689: l_progress_indicator := '180';
5690: IF (l_debug = 1) THEN
5691: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present',l_procedure_name, 9);
5692: END IF;
5693: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
5694: l_error_code := FND_MESSAGE.get;
5695: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
5696: FND_MSG_PUB.add;
5697: l_error_exp := FND_MESSAGE.get;

Line 5694: l_error_code := FND_MESSAGE.get;

5690: IF (l_debug = 1) THEN
5691: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present',l_procedure_name, 9);
5692: END IF;
5693: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
5694: l_error_code := FND_MESSAGE.get;
5695: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
5696: FND_MSG_PUB.add;
5697: l_error_exp := FND_MESSAGE.get;
5698: RAISE fnd_api.g_exc_error;

Line 5695: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');

5691: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present',l_procedure_name, 9);
5692: END IF;
5693: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
5694: l_error_code := FND_MESSAGE.get;
5695: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
5696: FND_MSG_PUB.add;
5697: l_error_exp := FND_MESSAGE.get;
5698: RAISE fnd_api.g_exc_error;
5699: END IF;

Line 5697: l_error_exp := FND_MESSAGE.get;

5693: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
5694: l_error_code := FND_MESSAGE.get;
5695: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
5696: FND_MSG_PUB.add;
5697: l_error_exp := FND_MESSAGE.get;
5698: RAISE fnd_api.g_exc_error;
5699: END IF;
5700:
5701: /*

Line 5724: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');

5720: 'Total Org quantity cannot become negative when there are reservations present'
5721: ,l_procedure_name
5722: ,9
5723: );
5724: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5725: l_error_code := fnd_message.get;
5726: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5727: l_error_exp := fnd_message.get;
5728: RAISE fnd_api.g_exc_error;

Line 5725: l_error_code := fnd_message.get;

5721: ,l_procedure_name
5722: ,9
5723: );
5724: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5725: l_error_code := fnd_message.get;
5726: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5727: l_error_exp := fnd_message.get;
5728: RAISE fnd_api.g_exc_error;
5729: END IF;*/

Line 5726: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');

5722: ,9
5723: );
5724: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5725: l_error_code := fnd_message.get;
5726: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5727: l_error_exp := fnd_message.get;
5728: RAISE fnd_api.g_exc_error;
5729: END IF;*/
5730: END IF;

Line 5727: l_error_exp := fnd_message.get;

5723: );
5724: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5725: l_error_code := fnd_message.get;
5726: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5727: l_error_exp := fnd_message.get;
5728: RAISE fnd_api.g_exc_error;
5729: END IF;*/
5730: END IF;
5731: END IF;

Line 5734: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');

5730: END IF;
5731: END IF;
5732: ELSE --if (neg_inv_rcpt = 1)
5733: l_progress_indicator := '180';
5734: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5735: l_error_code := fnd_message.get;
5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');

Line 5735: l_error_code := fnd_message.get;

5731: END IF;
5732: ELSE --if (neg_inv_rcpt = 1)
5733: l_progress_indicator := '180';
5734: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5735: l_error_code := fnd_message.get;
5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5739: l_error_exp := fnd_message.get;

Line 5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');

5732: ELSE --if (neg_inv_rcpt = 1)
5733: l_progress_indicator := '180';
5734: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5735: l_error_code := fnd_message.get;
5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5739: l_error_exp := fnd_message.get;
5740: RAISE fnd_api.g_exc_error;

Line 5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');

5733: l_progress_indicator := '180';
5734: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5735: l_error_code := fnd_message.get;
5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5739: l_error_exp := fnd_message.get;
5740: RAISE fnd_api.g_exc_error;
5741: --exit;

Line 5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');

5734: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5735: l_error_code := fnd_message.get;
5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5739: l_error_exp := fnd_message.get;
5740: RAISE fnd_api.g_exc_error;
5741: --exit;
5742: END IF; -- neg_inv_rcpt

Line 5739: l_error_exp := fnd_message.get;

5735: l_error_code := fnd_message.get;
5736: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5737: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5738: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5739: l_error_exp := fnd_message.get;
5740: RAISE fnd_api.g_exc_error;
5741: --exit;
5742: END IF; -- neg_inv_rcpt
5743: END IF; -- l_att

Line 6369: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');

6365: IF l_return_status = fnd_api.g_ret_sts_error THEN
6366: IF (l_debug = 1) THEN
6367: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,l_procedure_name, 9);
6368: END IF;
6369: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
6370: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
6371:
6372: l_error_code := FND_MESSAGE.get;
6373: l_error_exp := l_msg_data;

Line 6370: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');

6366: IF (l_debug = 1) THEN
6367: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,l_procedure_name, 9);
6368: END IF;
6369: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
6370: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
6371:
6372: l_error_code := FND_MESSAGE.get;
6373: l_error_exp := l_msg_data;
6374: RAISE fnd_api.g_exc_error;

Line 6372: l_error_code := FND_MESSAGE.get;

6368: END IF;
6369: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
6370: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
6371:
6372: l_error_code := FND_MESSAGE.get;
6373: l_error_exp := l_msg_data;
6374: RAISE fnd_api.g_exc_error;
6375: END IF ;
6376:

Line 6404: l_error_code := fnd_message.get;

6400: )
6401: )
6402: THEN
6403:
6404: l_error_code := fnd_message.get;
6405:
6406: UPDATE mtl_transactions_interface
6407: SET last_update_date = SYSDATE
6408: , last_updated_by = l_userid