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 2213: /* FND_MESSAGE.SET_NAME('INV', 'BAD_INPUT_ARGUMENTS');

2209: );
2210:
2211: END IF;
2212:
2213: /* FND_MESSAGE.SET_NAME('INV', 'BAD_INPUT_ARGUMENTS');
2214: FND_MSG_PUB.ADD;
2215: RAISE FND_API.G_EXC_ERROR; */
2216:
2217: /*----------------------------------------------------------+

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

2380: THEN
2381: COMMIT WORK;
2382: END IF;
2383:
2384: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2385: l_disp := fnd_message.get;
2386:
2387: IF (l_debug = 1)
2388: THEN

Line 2385: l_disp := fnd_message.get;

2381: COMMIT WORK;
2382: END IF;
2383:
2384: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2385: l_disp := fnd_message.get;
2386:
2387: IF (l_debug = 1)
2388: THEN
2389: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

2416: , 9
2417: );
2418: END IF;
2419:
2420: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2421: fnd_message.set_token ('token1', l_header_id);
2422: fnd_message.set_token ('token2', l_totrows);
2423: l_disp := fnd_message.get;
2424:

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

2417: );
2418: END IF;
2419:
2420: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2421: fnd_message.set_token ('token1', l_header_id);
2422: fnd_message.set_token ('token2', l_totrows);
2423: l_disp := fnd_message.get;
2424:
2425: IF (l_debug = 1)

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

2418: END IF;
2419:
2420: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2421: fnd_message.set_token ('token1', l_header_id);
2422: fnd_message.set_token ('token2', l_totrows);
2423: l_disp := fnd_message.get;
2424:
2425: IF (l_debug = 1)
2426: THEN

Line 2423: l_disp := fnd_message.get;

2419:
2420: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2421: fnd_message.set_token ('token1', l_header_id);
2422: fnd_message.set_token ('token2', l_totrows);
2423: l_disp := fnd_message.get;
2424:
2425: IF (l_debug = 1)
2426: THEN
2427: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

2472: END IF;
2473:
2474: IF (l_result <> 0)
2475: THEN
2476: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
2477:
2478: IF (l_debug = 1)
2479: THEN
2480: inv_log_util.TRACE ('Error from PROCESS_LPN_TRX.. ' || l_msg_data

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

2506: END IF;
2507:
2508: IF (FIRST)
2509: THEN
2510: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
2511: l_disp := fnd_message.get;
2512:
2513: IF (l_debug = 1)
2514: THEN

Line 2511: l_disp := fnd_message.get;

2507:
2508: IF (FIRST)
2509: THEN
2510: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
2511: l_disp := fnd_message.get;
2512:
2513: IF (l_debug = 1)
2514: THEN
2515: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 2528: l_error_exp := fnd_message.get;

2524: IF (FIRST)
2525: THEN
2526: IF (NOT bflushchk (l_header_id))
2527: THEN
2528: l_error_exp := fnd_message.get;
2529:
2530: IF (l_debug = 1)
2531: THEN
2532: inv_log_util.TRACE ('Error in call to bflushchk'

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

2540: END IF;
2541:
2542: IF (l_header_id <> -1)
2543: THEN
2544: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
2545: l_disp := fnd_message.get;
2546:
2547: IF (l_debug = 1)
2548: THEN

Line 2545: l_disp := fnd_message.get;

2541:
2542: IF (l_header_id <> -1)
2543: THEN
2544: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
2545: l_disp := fnd_message.get;
2546:
2547: IF (l_debug = 1)
2548: THEN
2549: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

2567: AND process_flag = 'Y'
2568: AND ROWNUM < 201;
2569: END IF;
2570:
2571: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2572: fnd_message.set_token ('token1', l_header_id);
2573: fnd_message.set_token ('token2', l_totrows);
2574: l_disp := fnd_message.get;
2575:

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

2568: AND ROWNUM < 201;
2569: END IF;
2570:
2571: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2572: fnd_message.set_token ('token1', l_header_id);
2573: fnd_message.set_token ('token2', l_totrows);
2574: l_disp := fnd_message.get;
2575:
2576: IF (l_debug = 1)

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

2569: END IF;
2570:
2571: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2572: fnd_message.set_token ('token1', l_header_id);
2573: fnd_message.set_token ('token2', l_totrows);
2574: l_disp := fnd_message.get;
2575:
2576: IF (l_debug = 1)
2577: THEN

Line 2574: l_disp := fnd_message.get;

2570:
2571: fnd_message.set_name ('INV', 'INV_CALL_PROC');
2572: fnd_message.set_token ('token1', l_header_id);
2573: fnd_message.set_token ('token2', l_totrows);
2574: l_disp := fnd_message.get;
2575:
2576: IF (l_debug = 1)
2577: THEN
2578: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

2590: AND ROWNUM < 201;
2591:
2592: IF SQL%NOTFOUND
2593: THEN
2594: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
2595: done := TRUE;
2596: END IF;
2597: END IF;
2598: END LOOP;

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

2692: END IF;
2693:
2694: IF (l_totrows = 0)
2695: THEN
2696: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2697: l_disp := fnd_message.get;
2698:
2699: IF (l_debug = 1)
2700: THEN

Line 2697: l_disp := fnd_message.get;

2693:
2694: IF (l_totrows = 0)
2695: THEN
2696: fnd_message.set_name ('INV', 'INV_PROC_WARN');
2697: l_disp := fnd_message.get;
2698:
2699: IF (l_debug = 1)
2700: THEN
2701: inv_log_util.TRACE (l_disp || ' totrows = 0'

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

2978: IF (l_index = 1)
2979: THEN
2980: IF (l_line_rec_type.transaction_action_id = 40)
2981: THEN
2982: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
2983: l_error_code := fnd_message.get;
2984: inv_lot_trx_validation_pvt.validate_lot_split_trx
2985: (x_return_status => x_return_status
2986: , x_msg_count => x_msg_count

Line 2983: l_error_code := fnd_message.get;

2979: THEN
2980: IF (l_line_rec_type.transaction_action_id = 40)
2981: THEN
2982: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
2983: l_error_code := fnd_message.get;
2984: inv_lot_trx_validation_pvt.validate_lot_split_trx
2985: (x_return_status => x_return_status
2986: , x_msg_count => x_msg_count
2987: , x_msg_data => x_msg_data

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

3023: RAISE rollback_line_validation;
3024: END IF;
3025: ELSIF (l_line_rec_type.transaction_action_id = 41)
3026: THEN
3027: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3028: l_error_code := fnd_message.get;
3029: inv_lot_trx_validation_pvt.validate_lot_merge_trx
3030: (x_return_status => x_return_status
3031: , x_msg_count => x_msg_count

Line 3028: l_error_code := fnd_message.get;

3024: END IF;
3025: ELSIF (l_line_rec_type.transaction_action_id = 41)
3026: THEN
3027: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3028: l_error_code := fnd_message.get;
3029: inv_lot_trx_validation_pvt.validate_lot_merge_trx
3030: (x_return_status => x_return_status
3031: , x_msg_count => x_msg_count
3032: , x_msg_data => x_msg_data

Line 3072: fnd_message.set_name ('INV'

3068: RAISE rollback_line_validation;
3069: END IF;
3070: ELSIF (l_line_rec_type.transaction_action_id = 42)
3071: THEN
3072: fnd_message.set_name ('INV'
3073: , 'INV_LOT_TRANSLATE_VALIDATIONS'
3074: );
3075: l_error_code := fnd_message.get;
3076: inv_lot_trx_validation_pvt.validate_lot_translate_trx

Line 3075: l_error_code := fnd_message.get;

3071: THEN
3072: fnd_message.set_name ('INV'
3073: , 'INV_LOT_TRANSLATE_VALIDATIONS'
3074: );
3075: l_error_code := fnd_message.get;
3076: inv_lot_trx_validation_pvt.validate_lot_translate_trx
3077: (x_return_status => x_return_status
3078: , x_msg_count => x_msg_count
3079: , x_msg_data => x_msg_data

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

3127: )
3128: THEN
3129: IF (l_line_rec_type.transaction_action_id = 40)
3130: THEN
3131: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3132: l_error_code := fnd_message.get;
3133: ELSIF (l_line_rec_type.transaction_action_id = 41)
3134: THEN
3135: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');

Line 3132: l_error_code := fnd_message.get;

3128: THEN
3129: IF (l_line_rec_type.transaction_action_id = 40)
3130: THEN
3131: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3132: l_error_code := fnd_message.get;
3133: ELSIF (l_line_rec_type.transaction_action_id = 41)
3134: THEN
3135: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3136: l_error_code := fnd_message.get;

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

3131: fnd_message.set_name ('INV', 'INV_LOT_SPLIT_VALIDATIONS');
3132: l_error_code := fnd_message.get;
3133: ELSIF (l_line_rec_type.transaction_action_id = 41)
3134: THEN
3135: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3136: l_error_code := fnd_message.get;
3137: ELSIF (l_line_rec_type.transaction_action_id = 42)
3138: THEN
3139: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');

Line 3136: l_error_code := fnd_message.get;

3132: l_error_code := fnd_message.get;
3133: ELSIF (l_line_rec_type.transaction_action_id = 41)
3134: THEN
3135: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3136: l_error_code := fnd_message.get;
3137: ELSIF (l_line_rec_type.transaction_action_id = 42)
3138: THEN
3139: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3140: l_error_code := fnd_message.get;

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

3135: fnd_message.set_name ('INV', 'INV_LOT_MERGE_VALIDATIONS');
3136: l_error_code := fnd_message.get;
3137: ELSIF (l_line_rec_type.transaction_action_id = 42)
3138: THEN
3139: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3140: l_error_code := fnd_message.get;
3141: END IF;
3142:
3143: UPDATE mtl_transactions_interface

Line 3140: l_error_code := fnd_message.get;

3136: l_error_code := fnd_message.get;
3137: ELSIF (l_line_rec_type.transaction_action_id = 42)
3138: THEN
3139: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_VALIDATIONS');
3140: l_error_code := fnd_message.get;
3141: END IF;
3142:
3143: UPDATE mtl_transactions_interface
3144: SET last_update_date = SYSDATE

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

3407: IF l_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) THEN
3408: IF (l_debug = 1) THEN
3409: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3410: END IF;
3411: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
3412: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3413: l_error_code := FND_MESSAGE.get;
3414: l_error_exp := l_msg_data;
3415: x_msg_data := l_msg_data;

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

3408: IF (l_debug = 1) THEN
3409: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3410: END IF;
3411: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
3412: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3413: l_error_code := FND_MESSAGE.get;
3414: l_error_exp := l_msg_data;
3415: x_msg_data := l_msg_data;
3416: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3413: l_error_code := FND_MESSAGE.get;

3409: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3410: END IF;
3411: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
3412: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
3413: l_error_code := FND_MESSAGE.get;
3414: l_error_exp := l_msg_data;
3415: x_msg_data := l_msg_data;
3416: UPDATE MTL_TRANSACTIONS_INTERFACE
3417: SET LAST_UPDATE_DATE = SYSDATE,

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

3473: IF (l_debug = 1) THEN
3474: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3475: END IF;
3476:
3477: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3478: FND_MESSAGE.set_token('token1','XACT_QTY1');
3479: l_error_code := FND_MESSAGE.get;
3480: l_error_exp := l_msg_data;
3481: x_msg_data := l_msg_data;

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

3474: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3475: END IF;
3476:
3477: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3478: FND_MESSAGE.set_token('token1','XACT_QTY1');
3479: l_error_code := FND_MESSAGE.get;
3480: l_error_exp := l_msg_data;
3481: x_msg_data := l_msg_data;
3482: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3479: l_error_code := FND_MESSAGE.get;

3475: END IF;
3476:
3477: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3478: FND_MESSAGE.set_token('token1','XACT_QTY1');
3479: l_error_code := FND_MESSAGE.get;
3480: l_error_exp := l_msg_data;
3481: x_msg_data := l_msg_data;
3482: UPDATE MTL_TRANSACTIONS_INTERFACE
3483: SET LAST_UPDATE_DATE = SYSDATE,

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

3514: IF (l_debug = 1) THEN
3515: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3516: END IF;
3517:
3518: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3519: FND_MESSAGE.set_token('token1','XACT_QTY1');
3520: l_error_code := FND_MESSAGE.get;
3521: l_error_exp := l_msg_data;
3522: x_msg_data := l_msg_data;

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

3515: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3516: END IF;
3517:
3518: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3519: FND_MESSAGE.set_token('token1','XACT_QTY1');
3520: l_error_code := FND_MESSAGE.get;
3521: l_error_exp := l_msg_data;
3522: x_msg_data := l_msg_data;
3523: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3520: l_error_code := FND_MESSAGE.get;

3516: END IF;
3517:
3518: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3519: FND_MESSAGE.set_token('token1','XACT_QTY1');
3520: l_error_code := FND_MESSAGE.get;
3521: l_error_exp := l_msg_data;
3522: x_msg_data := l_msg_data;
3523: UPDATE MTL_TRANSACTIONS_INTERFACE
3524: SET LAST_UPDATE_DATE = SYSDATE,

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

3608: existing reservation and can drive inventory go negative.
3609: */
3610: IF (l_override_rsv_for_backflush <> 1 ) THEN
3611: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3612: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3613: l_error_code := FND_MESSAGE.get;
3614: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3615: l_error_exp := FND_MESSAGE.get;
3616: x_msg_data := l_error_exp;

Line 3613: l_error_code := FND_MESSAGE.get;

3609: */
3610: IF (l_override_rsv_for_backflush <> 1 ) THEN
3611: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3612: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3613: l_error_code := FND_MESSAGE.get;
3614: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3615: l_error_exp := FND_MESSAGE.get;
3616: x_msg_data := l_error_exp;
3617: UPDATE MTL_TRANSACTIONS_INTERFACE

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

3610: IF (l_override_rsv_for_backflush <> 1 ) THEN
3611: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3612: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3613: l_error_code := FND_MESSAGE.get;
3614: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3615: l_error_exp := FND_MESSAGE.get;
3616: x_msg_data := l_error_exp;
3617: UPDATE MTL_TRANSACTIONS_INTERFACE
3618: SET LAST_UPDATE_DATE = SYSDATE,

Line 3615: l_error_exp := FND_MESSAGE.get;

3611: inv_log_util.trace('Transaction quantity must be less than or equal to available quantity','INV_TXN_MANAGER_PUB', 9);
3612: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3613: l_error_code := FND_MESSAGE.get;
3614: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3615: l_error_exp := FND_MESSAGE.get;
3616: x_msg_data := l_error_exp;
3617: UPDATE MTL_TRANSACTIONS_INTERFACE
3618: SET LAST_UPDATE_DATE = SYSDATE,
3619: LAST_UPDATED_BY = l_userid,

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

3670: IF (l_debug = 1) THEN
3671: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3672: END IF;
3673:
3674: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3675: FND_MESSAGE.set_token('token1','XACT_QTY1');
3676: l_error_code := FND_MESSAGE.get;
3677: l_error_exp := l_msg_data;
3678: x_msg_data := l_msg_data;

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

3671: inv_log_util.trace('Expected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3672: END IF;
3673:
3674: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3675: FND_MESSAGE.set_token('token1','XACT_QTY1');
3676: l_error_code := FND_MESSAGE.get;
3677: l_error_exp := l_msg_data;
3678: x_msg_data := l_msg_data;
3679: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3676: l_error_code := FND_MESSAGE.get;

3672: END IF;
3673:
3674: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3675: FND_MESSAGE.set_token('token1','XACT_QTY1');
3676: l_error_code := FND_MESSAGE.get;
3677: l_error_exp := l_msg_data;
3678: x_msg_data := l_msg_data;
3679: UPDATE MTL_TRANSACTIONS_INTERFACE
3680: SET LAST_UPDATE_DATE = SYSDATE,

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

3710: IF (l_debug = 1) THEN
3711: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3712: END IF;
3713:
3714: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3715: FND_MESSAGE.set_token('token1','XACT_QTY1');
3716: l_error_code := FND_MESSAGE.get;
3717: l_error_exp := l_msg_data;
3718: x_msg_data := l_msg_data;

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

3711: inv_log_util.trace('UnExpected Error while querying tree : ' || l_msg_data,'INV_TXN_MANAGER_PUB', 9);
3712: END IF;
3713:
3714: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3715: FND_MESSAGE.set_token('token1','XACT_QTY1');
3716: l_error_code := FND_MESSAGE.get;
3717: l_error_exp := l_msg_data;
3718: x_msg_data := l_msg_data;
3719: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3716: l_error_code := FND_MESSAGE.get;

3712: END IF;
3713:
3714: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3715: FND_MESSAGE.set_token('token1','XACT_QTY1');
3716: l_error_code := FND_MESSAGE.get;
3717: l_error_exp := l_msg_data;
3718: x_msg_data := l_msg_data;
3719: UPDATE MTL_TRANSACTIONS_INTERFACE
3720: SET LAST_UPDATE_DATE = SYSDATE,

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

3764: consume existing reservations.Else it can consume existing reservation and can
3765: drive inventory negative. */
3766: IF (l_override_rsv_for_backflush <> 1 ) THEN
3767: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3768: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3769: l_error_code := FND_MESSAGE.get;
3770: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3771: l_error_exp := FND_MESSAGE.get;
3772: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');

Line 3769: l_error_code := FND_MESSAGE.get;

3765: drive inventory negative. */
3766: IF (l_override_rsv_for_backflush <> 1 ) THEN
3767: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3768: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3769: l_error_code := FND_MESSAGE.get;
3770: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3771: l_error_exp := FND_MESSAGE.get;
3772: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3773: x_msg_data := l_error_exp;

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

3766: IF (l_override_rsv_for_backflush <> 1 ) THEN
3767: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3768: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3769: l_error_code := FND_MESSAGE.get;
3770: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3771: l_error_exp := FND_MESSAGE.get;
3772: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3773: x_msg_data := l_error_exp;
3774: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3771: l_error_exp := FND_MESSAGE.get;

3767: inv_log_util.trace('Total Org quantity cannot become negative when there are reservations present','INV_TXN_MANAGER_PUB', 9);
3768: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3769: l_error_code := FND_MESSAGE.get;
3770: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3771: l_error_exp := FND_MESSAGE.get;
3772: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3773: x_msg_data := l_error_exp;
3774: UPDATE MTL_TRANSACTIONS_INTERFACE
3775: SET LAST_UPDATE_DATE = SYSDATE,

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

3768: FND_MESSAGE.set_name('INV','INV_INT_PROCCODE');
3769: l_error_code := FND_MESSAGE.get;
3770: FND_MESSAGE.set_name('INV','INV_ORG_QUANTITY');
3771: l_error_exp := FND_MESSAGE.get;
3772: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3773: x_msg_data := l_error_exp;
3774: UPDATE MTL_TRANSACTIONS_INTERFACE
3775: SET LAST_UPDATE_DATE = SYSDATE,
3776: LAST_UPDATED_BY = l_userid,

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

3808: ELSE --(neg_inv_rcpt = 1)
3809: IF (l_debug = 1) THEN
3810: inv_log_util.trace('Not Enough Qty: l_att,l_trx_qty:' || l_att||','||l_trx_qty,'INV_TXN_MANAGER_PUB', 9);
3811: END IF;
3812: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3813: l_error_code := FND_MESSAGE.get;
3814: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);

Line 3813: l_error_code := FND_MESSAGE.get;

3809: IF (l_debug = 1) THEN
3810: inv_log_util.trace('Not Enough Qty: l_att,l_trx_qty:' || l_att||','||l_trx_qty,'INV_TXN_MANAGER_PUB', 9);
3811: END IF;
3812: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3813: l_error_code := FND_MESSAGE.get;
3814: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3817: l_error_exp := FND_MESSAGE.get;

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

3810: inv_log_util.trace('Not Enough Qty: l_att,l_trx_qty:' || l_att||','||l_trx_qty,'INV_TXN_MANAGER_PUB', 9);
3811: END IF;
3812: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3813: l_error_code := FND_MESSAGE.get;
3814: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3817: l_error_exp := FND_MESSAGE.get;
3818: x_msg_data := l_error_exp;

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

3811: END IF;
3812: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3813: l_error_code := FND_MESSAGE.get;
3814: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3817: l_error_exp := FND_MESSAGE.get;
3818: x_msg_data := l_error_exp;
3819: UPDATE MTL_TRANSACTIONS_INTERFACE

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

3812: FND_MESSAGE.set_name('INV','INV_NO_NEG_BALANCES');
3813: l_error_code := FND_MESSAGE.get;
3814: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3817: l_error_exp := FND_MESSAGE.get;
3818: x_msg_data := l_error_exp;
3819: UPDATE MTL_TRANSACTIONS_INTERFACE
3820: SET LAST_UPDATE_DATE = SYSDATE,

Line 3817: l_error_exp := FND_MESSAGE.get;

3813: l_error_code := FND_MESSAGE.get;
3814: FND_MESSAGE.set_name('INV','INV_LESS_OR_EQUAL');
3815: FND_MESSAGE.set_token('ENTITY1','INV_QUANTITY',l_translate);
3816: FND_MESSAGE.set_token('ENTITY2','AVAIL_TO_TRANSACT',l_translate);
3817: l_error_exp := FND_MESSAGE.get;
3818: x_msg_data := l_error_exp;
3819: UPDATE MTL_TRANSACTIONS_INTERFACE
3820: SET LAST_UPDATE_DATE = SYSDATE,
3821: LAST_UPDATED_BY = l_userid,

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

3881: x_atr => l_atr);
3882:
3883:
3884: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3885: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3886: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3887: l_error_code:= fnd_message.get;
3888: l_error_exp :=l_msg_data;
3889: x_msg_data := l_msg_data;

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

3882:
3883:
3884: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3885: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3886: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3887: l_error_code:= fnd_message.get;
3888: l_error_exp :=l_msg_data;
3889: x_msg_data := l_msg_data;
3890: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3887: l_error_code:= fnd_message.get;

3883:
3884: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3885: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3886: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3887: l_error_code:= fnd_message.get;
3888: l_error_exp :=l_msg_data;
3889: x_msg_data := l_msg_data;
3890: UPDATE MTL_TRANSACTIONS_INTERFACE
3891: SET LAST_UPDATE_DATE = SYSDATE,

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

3950: x_att => l_att,
3951: x_atr => l_atr);
3952:
3953: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3954: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3955: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3956: l_error_code:= fnd_message.get;
3957: l_error_exp :=l_msg_data;
3958: x_msg_data := l_msg_data;

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

3951: x_atr => l_atr);
3952:
3953: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3954: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3955: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3956: l_error_code:= fnd_message.get;
3957: l_error_exp :=l_msg_data;
3958: x_msg_data := l_msg_data;
3959: UPDATE MTL_TRANSACTIONS_INTERFACE

Line 3956: l_error_code:= fnd_message.get;

3952:
3953: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3954: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3955: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3956: l_error_code:= fnd_message.get;
3957: l_error_exp :=l_msg_data;
3958: x_msg_data := l_msg_data;
3959: UPDATE MTL_TRANSACTIONS_INTERFACE
3960: SET LAST_UPDATE_DATE = SYSDATE,

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

4018:
4019: IF l_location_required_flag = 'Y' AND
4020: l_line_rec_type.ship_to_location_id IS NULL THEN
4021:
4022: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');
4023: l_error_code := FND_MESSAGE.GET;
4024:
4025: UPDATE MTL_TRANSACTIONS_INTERFACE
4026: SET LAST_UPDATE_DATE = SYSDATE,

Line 4023: l_error_code := FND_MESSAGE.GET;

4019: IF l_location_required_flag = 'Y' AND
4020: l_line_rec_type.ship_to_location_id IS NULL THEN
4021:
4022: FND_MESSAGE.SET_NAME('INV','INV_LOCATION_MANDATORY');
4023: l_error_code := FND_MESSAGE.GET;
4024:
4025: UPDATE MTL_TRANSACTIONS_INTERFACE
4026: SET LAST_UPDATE_DATE = SYSDATE,
4027: LAST_UPDATED_BY = l_userid,

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

4039: END;
4040: --End of new code added as per the eIB TDD; Bug# 4348541
4041:
4042: SAVEPOINT line_validation_svpt;
4043: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');
4044: fnd_message.set_token ('token', l_header_id);
4045: l_disp := fnd_message.get;
4046:
4047: IF (l_debug = 1)

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

4040: --End of new code added as per the eIB TDD; Bug# 4348541
4041:
4042: SAVEPOINT line_validation_svpt;
4043: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');
4044: fnd_message.set_token ('token', l_header_id);
4045: l_disp := fnd_message.get;
4046:
4047: IF (l_debug = 1)
4048: THEN

Line 4045: l_disp := fnd_message.get;

4041:
4042: SAVEPOINT line_validation_svpt;
4043: fnd_message.set_name ('INV', 'INV_MOVE_TO_TEMP');
4044: fnd_message.set_token ('token', l_header_id);
4045: l_disp := fnd_message.get;
4046:
4047: IF (l_debug = 1)
4048: THEN
4049: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

Line 4072: l_error_exp := fnd_message.get;

4068: , l_index
4069: )
4070: )
4071: THEN
4072: l_error_exp := fnd_message.get;
4073:
4074: IF (l_debug = 1)
4075: THEN
4076: inv_log_util.TRACE ( 'Error in Check_Partial_Split= '

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

4079: , 9
4080: );
4081: END IF;
4082:
4083: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4084: l_error_code := fnd_message.get;
4085: ROLLBACK TO line_validation_svpt;
4086:
4087: UPDATE mtl_transactions_interface

Line 4084: l_error_code := fnd_message.get;

4080: );
4081: END IF;
4082:
4083: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4084: l_error_code := fnd_message.get;
4085: ROLLBACK TO line_validation_svpt;
4086:
4087: UPDATE mtl_transactions_interface
4088: SET last_update_date = SYSDATE

Line 4305: l_error_exp := fnd_message.get;

4301: END IF;
4302:
4303: IF (NOT tmpinsert (l_header_id))
4304: THEN
4305: l_error_exp := fnd_message.get;
4306:
4307: IF (l_debug = 1)
4308: THEN
4309: inv_log_util.TRACE ('Error in tmpinsert=' || l_error_exp

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

4311: , 9
4312: );
4313: END IF;
4314:
4315: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4316: l_error_code := fnd_message.get;
4317: RAISE fnd_api.g_exc_unexpected_error;
4318: ELSE
4319: BEGIN

Line 4316: l_error_code := fnd_message.get;

4312: );
4313: END IF;
4314:
4315: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4316: l_error_code := fnd_message.get;
4317: RAISE fnd_api.g_exc_unexpected_error;
4318: ELSE
4319: BEGIN
4320: IF(l_debug = 1) THEN

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

4340: inv_log_util.TRACE ( 'tmpinsert2 raised exception '
4341: , 'INV_TXN_MANAGER_PUB'
4342: , 9
4343: );
4344: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4345: l_error_code := fnd_message.get;
4346: RAISE fnd_api.g_exc_unexpected_error;
4347: END;
4348:

Line 4345: l_error_code := fnd_message.get;

4341: , 'INV_TXN_MANAGER_PUB'
4342: , 9
4343: );
4344: fnd_message.set_name ('INV', 'INV_INT_TMPXFRCODE');
4345: l_error_code := fnd_message.get;
4346: RAISE fnd_api.g_exc_unexpected_error;
4347: END;
4348:
4349: IF(x_return_status <> fnd_api.g_ret_sts_success OR

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

4457: SAVEPOINT process_trx_save;
4458:
4459: IF (FIRST)
4460: THEN
4461: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4462: fnd_message.set_token ('token1', l_header_id);
4463: fnd_message.set_token ('token2', l_totrows);
4464: l_disp := fnd_message.get;
4465:

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

4458:
4459: IF (FIRST)
4460: THEN
4461: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4462: fnd_message.set_token ('token1', l_header_id);
4463: fnd_message.set_token ('token2', l_totrows);
4464: l_disp := fnd_message.get;
4465:
4466: IF (l_debug = 1)

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

4459: IF (FIRST)
4460: THEN
4461: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4462: fnd_message.set_token ('token1', l_header_id);
4463: fnd_message.set_token ('token2', l_totrows);
4464: l_disp := fnd_message.get;
4465:
4466: IF (l_debug = 1)
4467: THEN

Line 4464: l_disp := fnd_message.get;

4460: THEN
4461: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4462: fnd_message.set_token ('token1', l_header_id);
4463: fnd_message.set_token ('token2', l_totrows);
4464: l_disp := fnd_message.get;
4465:
4466: IF (l_debug = 1)
4467: THEN
4468: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

4467: THEN
4468: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);
4469: END IF;
4470:
4471: --FND_MESSAGE.set_name('INV','INV_RETURN_PROC');
4472: --l_disp := FND_MESSAGE.get;
4473: --inv_log_util.trace(l_disp, 'INV_TXN_MANAGER_PUB',9);
4474: SELECT COUNT (*)
4475: INTO l_totrows

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

4468: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);
4469: END IF;
4470:
4471: --FND_MESSAGE.set_name('INV','INV_RETURN_PROC');
4472: --l_disp := FND_MESSAGE.get;
4473: --inv_log_util.trace(l_disp, 'INV_TXN_MANAGER_PUB',9);
4474: SELECT COUNT (*)
4475: INTO l_totrows
4476: FROM mtl_material_transactions_temp

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

4479: x_trans_count := l_totrows;
4480:
4481: IF (l_totrows = 0)
4482: THEN
4483: fnd_message.set_name ('INV', 'INV_PROC_WARN');
4484: l_disp := fnd_message.get;
4485:
4486: IF (l_debug = 1)
4487: THEN

Line 4484: l_disp := fnd_message.get;

4480:
4481: IF (l_totrows = 0)
4482: THEN
4483: fnd_message.set_name ('INV', 'INV_PROC_WARN');
4484: l_disp := fnd_message.get;
4485:
4486: IF (l_debug = 1)
4487: THEN
4488: inv_log_util.TRACE (l_disp || ' totrows = 0'

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

4552: THEN
4553: l_error_exp := l_msg_data;
4554: x_msg_data := l_msg_data;
4555: x_return_status := l_return_status;
4556: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
4557: l_error_code := fnd_message.get;
4558:
4559: IF (l_debug = 1)
4560: THEN

Line 4557: l_error_code := fnd_message.get;

4553: l_error_exp := l_msg_data;
4554: x_msg_data := l_msg_data;
4555: x_return_status := l_return_status;
4556: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
4557: l_error_code := fnd_message.get;
4558:
4559: IF (l_debug = 1)
4560: THEN
4561: inv_log_util.TRACE ( 'PROCESS_LPN_TRX failed for header_id '

Line 4635: l_error_code := fnd_message.get;

4631: END IF;
4632:
4633: IF (NOT bflushchk (l_header_id))
4634: THEN
4635: l_error_code := fnd_message.get;
4636:
4637: IF (l_debug = 1)
4638: THEN
4639: inv_log_util.TRACE ( 'Error in bflushchk header_id:'

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

4650: END IF;
4651:
4652: IF (l_header_id <> -1)
4653: THEN
4654: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
4655: l_disp := fnd_message.get;
4656:
4657: IF (l_debug = 1)
4658: THEN

Line 4655: l_disp := fnd_message.get;

4651:
4652: IF (l_header_id <> -1)
4653: THEN
4654: fnd_message.set_name ('INV', 'INV_BFLUSH_PROC');
4655: l_disp := fnd_message.get;
4656:
4657: IF (l_debug = 1)
4658: THEN
4659: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

4685: AND process_flag = 'Y'
4686: AND ROWNUM < 201;
4687: END IF;
4688:
4689: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4690: fnd_message.set_token ('token1', l_header_id);
4691: fnd_message.set_token ('token2', l_totrows);
4692: l_disp := fnd_message.get;
4693:

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

4686: AND ROWNUM < 201;
4687: END IF;
4688:
4689: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4690: fnd_message.set_token ('token1', l_header_id);
4691: fnd_message.set_token ('token2', l_totrows);
4692: l_disp := fnd_message.get;
4693:
4694: IF (l_debug = 1)

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

4687: END IF;
4688:
4689: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4690: fnd_message.set_token ('token1', l_header_id);
4691: fnd_message.set_token ('token2', l_totrows);
4692: l_disp := fnd_message.get;
4693:
4694: IF (l_debug = 1)
4695: THEN

Line 4692: l_disp := fnd_message.get;

4688:
4689: fnd_message.set_name ('INV', 'INV_CALL_PROC');
4690: fnd_message.set_token ('token1', l_header_id);
4691: fnd_message.set_token ('token2', l_totrows);
4692: l_disp := fnd_message.get;
4693:
4694: IF (l_debug = 1)
4695: THEN
4696: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

4707: AND ROWNUM < 201;
4708:
4709: IF SQL%NOTFOUND
4710: THEN
4711: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
4712: l_disp := fnd_message.get;
4713:
4714: IF (l_debug = 1)
4715: THEN

Line 4712: l_disp := fnd_message.get;

4708:
4709: IF SQL%NOTFOUND
4710: THEN
4711: fnd_message.set_name ('INV', 'INV_RETURN_PROC');
4712: l_disp := fnd_message.get;
4713:
4714: IF (l_debug = 1)
4715: THEN
4716: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

4722: END LOOP;
4723:
4724: IF (l_initotrows > l_midtotrows)
4725: THEN
4726: fnd_message.set_name ('INV', 'INV_MGR_WARN');
4727: l_disp := fnd_message.get;
4728:
4729: IF (l_debug = 1)
4730: THEN

Line 4727: l_disp := fnd_message.get;

4723:
4724: IF (l_initotrows > l_midtotrows)
4725: THEN
4726: fnd_message.set_name ('INV', 'INV_MGR_WARN');
4727: l_disp := fnd_message.get;
4728:
4729: IF (l_debug = 1)
4730: THEN
4731: inv_log_util.TRACE (l_disp, 'INV_TXN_MANAGER_PUB', 9);

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

4755: );
4756: END IF;
4757:
4758:
4759: fnd_message.set_name ('INV', 'INV_INT_SQLCODE');
4760: l_error_code := fnd_message.get;
4761:
4762: IF NOT fnd_api.to_boolean (p_commit)
4763: THEN

Line 4760: l_error_code := fnd_message.get;

4756: END IF;
4757:
4758:
4759: fnd_message.set_name ('INV', 'INV_INT_SQLCODE');
4760: l_error_code := fnd_message.get;
4761:
4762: IF NOT fnd_api.to_boolean (p_commit)
4763: THEN
4764: ROLLBACK TO process_transactions_svpt;

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

4813: IF (p_relief_type = mds_relief)
4814: THEN
4815: IF (p_disposition <> r_sales_order)
4816: THEN
4817: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4818: fnd_message.set_token ('ENTITY', 'disposition');
4819: fnd_message.set_token ('VALUE', p_disposition);
4820: RETURN (FALSE);
4821: END IF;

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

4814: THEN
4815: IF (p_disposition <> r_sales_order)
4816: THEN
4817: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4818: fnd_message.set_token ('ENTITY', 'disposition');
4819: fnd_message.set_token ('VALUE', p_disposition);
4820: RETURN (FALSE);
4821: END IF;
4822: ELSE

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

4815: IF (p_disposition <> r_sales_order)
4816: THEN
4817: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4818: fnd_message.set_token ('ENTITY', 'disposition');
4819: fnd_message.set_token ('VALUE', p_disposition);
4820: RETURN (FALSE);
4821: END IF;
4822: ELSE
4823: IF (p_relief_type = mps_relief)

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

4824: THEN
4825: IF (p_disposition <> r_work_order)
4826: AND (p_disposition <> r_purch_order)
4827: THEN
4828: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4829: fnd_message.set_token ('ENTITY', 'disposition');
4830: fnd_message.set_token ('VALUE', p_disposition);
4831: RETURN (FALSE);
4832: END IF;

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

4825: IF (p_disposition <> r_work_order)
4826: AND (p_disposition <> r_purch_order)
4827: THEN
4828: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4829: fnd_message.set_token ('ENTITY', 'disposition');
4830: fnd_message.set_token ('VALUE', p_disposition);
4831: RETURN (FALSE);
4832: END IF;
4833: ELSE

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

4826: AND (p_disposition <> r_purch_order)
4827: THEN
4828: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4829: fnd_message.set_token ('ENTITY', 'disposition');
4830: fnd_message.set_token ('VALUE', p_disposition);
4831: RETURN (FALSE);
4832: END IF;
4833: ELSE
4834: fnd_message.set_name ('MRP', 'GEN-invalid entity');

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

4830: fnd_message.set_token ('VALUE', p_disposition);
4831: RETURN (FALSE);
4832: END IF;
4833: ELSE
4834: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4835: fnd_message.set_token ('ENTITY', 'relief_type');
4836: fnd_message.set_token ('VALUE', p_relief_type);
4837: RETURN (FALSE);
4838: END IF;

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

4831: RETURN (FALSE);
4832: END IF;
4833: ELSE
4834: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4835: fnd_message.set_token ('ENTITY', 'relief_type');
4836: fnd_message.set_token ('VALUE', p_relief_type);
4837: RETURN (FALSE);
4838: END IF;
4839: END IF;

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

4832: END IF;
4833: ELSE
4834: fnd_message.set_name ('MRP', 'GEN-invalid entity');
4835: fnd_message.set_token ('ENTITY', 'relief_type');
4836: fnd_message.set_token ('VALUE', p_relief_type);
4837: RETURN (FALSE);
4838: END IF;
4839: END IF;
4840:

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

5295: || l_msg_data
5296: , l_procedure_name
5297: , 9
5298: );
5299: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');
5300: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');
5301: l_error_code := fnd_message.get;
5302: l_error_exp := l_msg_data;
5303: RAISE fnd_api.g_exc_error;

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

5296: , l_procedure_name
5297: , 9
5298: );
5299: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');
5300: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');
5301: l_error_code := fnd_message.get;
5302: l_error_exp := l_msg_data;
5303: RAISE fnd_api.g_exc_error;
5304: END IF;

Line 5301: l_error_code := fnd_message.get;

5297: , 9
5298: );
5299: fnd_message.set_name ('INV', 'INV_ERR_CREATETREE');
5300: fnd_message.set_token ('ROUTINE', 'UE:AVAIL_TO_TRX');
5301: l_error_code := fnd_message.get;
5302: l_error_exp := l_msg_data;
5303: RAISE fnd_api.g_exc_error;
5304: END IF;
5305:

Line 5365: l_error_code := fnd_message.get;

5361: || l_msg_data
5362: , l_procedure_name
5363: , 9
5364: );
5365: l_error_code := fnd_message.get;
5366: l_error_exp := l_msg_data;
5367: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5368: fnd_message.set_token ('token1', 'XACT_QTY1');
5369: RAISE fnd_api.g_exc_error;

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

5363: , 9
5364: );
5365: l_error_code := fnd_message.get;
5366: l_error_exp := l_msg_data;
5367: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5368: fnd_message.set_token ('token1', 'XACT_QTY1');
5369: RAISE fnd_api.g_exc_error;
5370: END IF;
5371:

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

5364: );
5365: l_error_code := fnd_message.get;
5366: l_error_exp := l_msg_data;
5367: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5368: fnd_message.set_token ('token1', 'XACT_QTY1');
5369: RAISE fnd_api.g_exc_error;
5370: END IF;
5371:
5372: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 5378: l_error_code := fnd_message.get;

5374: || l_msg_data
5375: , l_procedure_name
5376: , 9
5377: );
5378: l_error_code := fnd_message.get;
5379: l_error_exp := l_msg_data;
5380: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5381: fnd_message.set_token ('token1', 'XACT_QTY1');
5382: RAISE fnd_api.g_exc_unexpected_error;

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

5376: , 9
5377: );
5378: l_error_code := fnd_message.get;
5379: l_error_exp := l_msg_data;
5380: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5381: fnd_message.set_token ('token1', 'XACT_QTY1');
5382: RAISE fnd_api.g_exc_unexpected_error;
5383: END IF;
5384:

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

5377: );
5378: l_error_code := fnd_message.get;
5379: l_error_exp := l_msg_data;
5380: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5381: fnd_message.set_token ('token1', 'XACT_QTY1');
5382: RAISE fnd_api.g_exc_unexpected_error;
5383: END IF;
5384:
5385: l_progress_indicator := '110';

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

5410: 'Transaction quantity must be less than or equal to available quantity'
5411: , l_procedure_name
5412: , 9
5413: );
5414: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5415: l_error_code := fnd_message.get;
5416: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5417: l_error_exp := fnd_message.get;
5418: RAISE fnd_api.g_exc_error;

Line 5415: l_error_code := fnd_message.get;

5411: , l_procedure_name
5412: , 9
5413: );
5414: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5415: l_error_code := fnd_message.get;
5416: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5417: l_error_exp := fnd_message.get;
5418: RAISE fnd_api.g_exc_error;
5419: END IF;

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

5412: , 9
5413: );
5414: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5415: l_error_code := fnd_message.get;
5416: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5417: l_error_exp := fnd_message.get;
5418: RAISE fnd_api.g_exc_error;
5419: END IF;
5420:

Line 5417: l_error_exp := fnd_message.get;

5413: );
5414: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5415: l_error_code := fnd_message.get;
5416: fnd_message.set_name ('INV', 'INV_QTY_LESS_OR_EQUAL');
5417: l_error_exp := fnd_message.get;
5418: RAISE fnd_api.g_exc_error;
5419: END IF;
5420:
5421: l_progress_indicator := '140';

Line 5449: l_error_code := fnd_message.get;

5445: || l_msg_data
5446: , l_procedure_name
5447: , 9
5448: );
5449: l_error_code := fnd_message.get;
5450: l_error_exp := l_msg_data;
5451: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5452: fnd_message.set_token ('token1', 'XACT_QTY1');
5453: RAISE fnd_api.g_exc_error;

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

5447: , 9
5448: );
5449: l_error_code := fnd_message.get;
5450: l_error_exp := l_msg_data;
5451: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5452: fnd_message.set_token ('token1', 'XACT_QTY1');
5453: RAISE fnd_api.g_exc_error;
5454: END IF;
5455:

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

5448: );
5449: l_error_code := fnd_message.get;
5450: l_error_exp := l_msg_data;
5451: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5452: fnd_message.set_token ('token1', 'XACT_QTY1');
5453: RAISE fnd_api.g_exc_error;
5454: END IF;
5455:
5456: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 5464: l_error_code := fnd_message.get;

5460: , l_procedure_name
5461: , 9
5462: );
5463:
5464: l_error_code := fnd_message.get;
5465: l_error_exp := l_msg_data;
5466: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5467: fnd_message.set_token ('token1', 'XACT_QTY1');
5468: RAISE fnd_api.g_exc_unexpected_error;

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

5462: );
5463:
5464: l_error_code := fnd_message.get;
5465: l_error_exp := l_msg_data;
5466: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5467: fnd_message.set_token ('token1', 'XACT_QTY1');
5468: RAISE fnd_api.g_exc_unexpected_error;
5469: END IF;
5470:

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

5463:
5464: l_error_code := fnd_message.get;
5465: l_error_exp := l_msg_data;
5466: fnd_message.set_name ('INV', 'INV_INTERNAL_ERROR');
5467: fnd_message.set_token ('token1', 'XACT_QTY1');
5468: RAISE fnd_api.g_exc_unexpected_error;
5469: END IF;
5470:
5471: l_progress_indicator := '150';

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

5524: 'Total Org quantity cannot become negative when there are reservations present'
5525: ,l_procedure_name
5526: ,9
5527: );
5528: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5529: l_error_code := fnd_message.get;
5530: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5531: l_error_exp := fnd_message.get;
5532: RAISE fnd_api.g_exc_error;

Line 5529: l_error_code := fnd_message.get;

5525: ,l_procedure_name
5526: ,9
5527: );
5528: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5529: l_error_code := fnd_message.get;
5530: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5531: l_error_exp := fnd_message.get;
5532: RAISE fnd_api.g_exc_error;
5533: END IF;

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

5526: ,9
5527: );
5528: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5529: l_error_code := fnd_message.get;
5530: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5531: l_error_exp := fnd_message.get;
5532: RAISE fnd_api.g_exc_error;
5533: END IF;
5534: END IF;

Line 5531: l_error_exp := fnd_message.get;

5527: );
5528: fnd_message.set_name ('INV', 'INV_INT_PROCCODE');
5529: l_error_code := fnd_message.get;
5530: fnd_message.set_name ('INV', 'INV_ORG_QUANTITY');
5531: l_error_exp := fnd_message.get;
5532: RAISE fnd_api.g_exc_error;
5533: END IF;
5534: END IF;
5535: END IF;

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

5534: END IF;
5535: END IF;
5536: ELSE --if (neg_inv_rcpt = 1)
5537: l_progress_indicator := '180';
5538: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5539: l_error_code := fnd_message.get;
5540: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5541: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5542: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');

Line 5539: l_error_code := fnd_message.get;

5535: END IF;
5536: ELSE --if (neg_inv_rcpt = 1)
5537: l_progress_indicator := '180';
5538: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5539: l_error_code := fnd_message.get;
5540: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5541: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5542: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5543: l_error_exp := fnd_message.get;

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

5536: ELSE --if (neg_inv_rcpt = 1)
5537: l_progress_indicator := '180';
5538: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5539: l_error_code := fnd_message.get;
5540: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5541: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5542: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5543: l_error_exp := fnd_message.get;
5544: RAISE fnd_api.g_exc_error;

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

5537: l_progress_indicator := '180';
5538: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5539: l_error_code := fnd_message.get;
5540: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5541: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5542: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5543: l_error_exp := fnd_message.get;
5544: RAISE fnd_api.g_exc_error;
5545: --exit;

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

5538: fnd_message.set_name ('INV', 'INV_NO_NEG_BALANCES');
5539: l_error_code := fnd_message.get;
5540: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5541: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5542: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5543: l_error_exp := fnd_message.get;
5544: RAISE fnd_api.g_exc_error;
5545: --exit;
5546: END IF; -- neg_inv_rcpt

Line 5543: l_error_exp := fnd_message.get;

5539: l_error_code := fnd_message.get;
5540: fnd_message.set_name ('INV', 'INV_LESS_OR_EQUAL');
5541: fnd_message.set_token ('ENTITY1', 'INV_QUANTITY');
5542: fnd_message.set_token ('ENTITY2', 'AVAIL_TO_TRANSACT');
5543: l_error_exp := fnd_message.get;
5544: RAISE fnd_api.g_exc_error;
5545: --exit;
5546: END IF; -- neg_inv_rcpt
5547: END IF; -- l_att

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

6169: IF l_return_status = fnd_api.g_ret_sts_error THEN
6170: IF (l_debug = 1) THEN
6171: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,l_procedure_name, 9);
6172: END IF;
6173: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
6174: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
6175:
6176: l_error_code := FND_MESSAGE.get;
6177: l_error_exp := l_msg_data;

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

6170: IF (l_debug = 1) THEN
6171: inv_log_util.trace('Error while creating tree : x_msg_data = ' || l_msg_data,l_procedure_name, 9);
6172: END IF;
6173: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
6174: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
6175:
6176: l_error_code := FND_MESSAGE.get;
6177: l_error_exp := l_msg_data;
6178: RAISE fnd_api.g_exc_error;

Line 6176: l_error_code := FND_MESSAGE.get;

6172: END IF;
6173: FND_MESSAGE.set_name('INV','INV_ERR_CREATETREE');
6174: FND_MESSAGE.set_token('ROUTINE','UE:AVAIL_TO_TRX');
6175:
6176: l_error_code := FND_MESSAGE.get;
6177: l_error_exp := l_msg_data;
6178: RAISE fnd_api.g_exc_error;
6179: END IF ;
6180:

Line 6208: l_error_code := fnd_message.get;

6204: )
6205: )
6206: THEN
6207:
6208: l_error_code := fnd_message.get;
6209:
6210: UPDATE mtl_transactions_interface
6211: SET last_update_date = SYSDATE
6212: , last_updated_by = l_userid