eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_VALIDATIONS dependencies on FND_MESSAGE

Line 1814: fnd_message.set_name('INV', 'INV_LPN_RESERVED');

1810: IF (l_debug = 1) THEN
1811: mdebug ('lpn '||l_lpn_id||' is reserved.');
1812: END IF;
1813: x_return := 'N';
1814: fnd_message.set_name('INV', 'INV_LPN_RESERVED');
1815: x_return_msg := fnd_message.get;
1816: RETURN x_return;
1817: end if;
1818:

Line 1815: x_return_msg := fnd_message.get;

1811: mdebug ('lpn '||l_lpn_id||' is reserved.');
1812: END IF;
1813: x_return := 'N';
1814: fnd_message.set_name('INV', 'INV_LPN_RESERVED');
1815: x_return_msg := fnd_message.get;
1816: RETURN x_return;
1817: end if;
1818:
1819: END LOOP;

Line 1869: fnd_message.set_name('INV', 'INV_LPN_ALLOCATED');

1865: IF (l_debug = 1) THEN
1866: mdebug ('lpn '||l_lpn_id||' is allocated.');
1867: END IF;
1868: x_return := 'N';
1869: fnd_message.set_name('INV', 'INV_LPN_ALLOCATED');
1870: x_return_msg := fnd_message.get;
1871: RETURN x_return;
1872: end if;
1873: END LOOP;

Line 1870: x_return_msg := fnd_message.get;

1866: mdebug ('lpn '||l_lpn_id||' is allocated.');
1867: END IF;
1868: x_return := 'N';
1869: fnd_message.set_name('INV', 'INV_LPN_ALLOCATED');
1870: x_return_msg := fnd_message.get;
1871: RETURN x_return;
1872: end if;
1873: END LOOP;
1874: CLOSE c_lpn_content;

Line 1941: fnd_message.set_name('INV', 'INV_SERIAL_ALLOCATED');

1937: IF (l_debug = 1) THEN
1938: mdebug ('serial no: '||l_serial_number||' in lpn '||l_lpn_id||' is allocated.');
1939: END IF;
1940: x_return := 'N';
1941: fnd_message.set_name('INV', 'INV_SERIAL_ALLOCATED');
1942: x_return_msg := fnd_message.get;
1943: RETURN x_return;
1944: end if;
1945: exception

Line 1942: x_return_msg := fnd_message.get;

1938: mdebug ('serial no: '||l_serial_number||' in lpn '||l_lpn_id||' is allocated.');
1939: END IF;
1940: x_return := 'N';
1941: fnd_message.set_name('INV', 'INV_SERIAL_ALLOCATED');
1942: x_return_msg := fnd_message.get;
1943: RETURN x_return;
1944: end if;
1945: exception
1946: when no_data_found then

Line 1996: fnd_message.set_name('INV', 'INV_SERIAL_ALLOCATED');

1992: and msnt.transaction_temp_id = nvl(mtlt.serial_transaction_temp_id, mmtt.transaction_temp_id);
1993:
1994: if l_cnt = 1 then
1995: x_return := 'N';
1996: fnd_message.set_name('INV', 'INV_SERIAL_ALLOCATED');
1997: x_return_msg := fnd_message.get;
1998: RETURN x_return;
1999: end if;
2000:

Line 1997: x_return_msg := fnd_message.get;

1993:
1994: if l_cnt = 1 then
1995: x_return := 'N';
1996: fnd_message.set_name('INV', 'INV_SERIAL_ALLOCATED');
1997: x_return_msg := fnd_message.get;
1998: RETURN x_return;
1999: end if;
2000:
2001: exception

Line 2409: fnd_message.set_name('INV', 'INV_NOT_INVENTORY');

2405: l_lot_number := l_record.lot_number;
2406:
2407: IF l_lpn_context NOT IN (1) THEN
2408: x_return := 'N';
2409: fnd_message.set_name('INV', 'INV_NOT_INVENTORY');
2410: x_return_msg := fnd_message.get;
2411: RETURN x_return;
2412: END IF ;
2413:

Line 2410: x_return_msg := fnd_message.get;

2406:
2407: IF l_lpn_context NOT IN (1) THEN
2408: x_return := 'N';
2409: fnd_message.set_name('INV', 'INV_NOT_INVENTORY');
2410: x_return_msg := fnd_message.get;
2411: RETURN x_return;
2412: END IF ;
2413:
2414: SELECT revision_qty_control_code ,

Line 2472: FND_MESSAGE.set_name('INV', 'INV_LPN_QTY_ERR');

2468: x_return := 'Y';
2469: x_return_msg :='SUCCESS';
2470: ELSE
2471: x_return := 'F';
2472: FND_MESSAGE.set_name('INV', 'INV_LPN_QTY_ERR');
2473: x_return_msg :=fnd_message.get;
2474: RETURN x_return;
2475: END IF ;
2476: ELSE

Line 2473: x_return_msg :=fnd_message.get;

2469: x_return_msg :='SUCCESS';
2470: ELSE
2471: x_return := 'F';
2472: FND_MESSAGE.set_name('INV', 'INV_LPN_QTY_ERR');
2473: x_return_msg :=fnd_message.get;
2474: RETURN x_return;
2475: END IF ;
2476: ELSE
2477: x_return :='F';

Line 2478: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');

2474: RETURN x_return;
2475: END IF ;
2476: ELSE
2477: x_return :='F';
2478: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2479: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2480: x_return_msg := fnd_message.get;
2481: RETURN x_return;
2482: END IF ;

Line 2479: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2475: END IF ;
2476: ELSE
2477: x_return :='F';
2478: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2479: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2480: x_return_msg := fnd_message.get;
2481: RETURN x_return;
2482: END IF ;
2483: l_updt_qoh := - l_qoh;

Line 2480: x_return_msg := fnd_message.get;

2476: ELSE
2477: x_return :='F';
2478: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2479: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2480: x_return_msg := fnd_message.get;
2481: RETURN x_return;
2482: END IF ;
2483: l_updt_qoh := - l_qoh;
2484: /*need to update qty tree */

Line 2648: fnd_message.set_name('INV', 'INV_NOT_INVENTORY');

2644: l_lot_number := l_record.lot_number;
2645:
2646: IF l_lpn_context NOT IN (1) THEN
2647: x_return := 'N';
2648: fnd_message.set_name('INV', 'INV_NOT_INVENTORY');
2649: x_return_msg := fnd_message.get;
2650: RETURN x_return;
2651: END IF ;
2652:

Line 2649: x_return_msg := fnd_message.get;

2645:
2646: IF l_lpn_context NOT IN (1) THEN
2647: x_return := 'N';
2648: fnd_message.set_name('INV', 'INV_NOT_INVENTORY');
2649: x_return_msg := fnd_message.get;
2650: RETURN x_return;
2651: END IF ;
2652:
2653: SELECT revision_qty_control_code ,

Line 2714: FND_MESSAGE.set_name('INV', 'INV_LPN_QTY_ERR');

2710: x_return := 'Y';
2711: x_return_msg :='SUCCESS';
2712: ELSE
2713: x_return := 'F';
2714: FND_MESSAGE.set_name('INV', 'INV_LPN_QTY_ERR');
2715: x_return_msg :=fnd_message.get;
2716: RETURN x_return;
2717: END IF ;
2718: ELSE

Line 2715: x_return_msg :=fnd_message.get;

2711: x_return_msg :='SUCCESS';
2712: ELSE
2713: x_return := 'F';
2714: FND_MESSAGE.set_name('INV', 'INV_LPN_QTY_ERR');
2715: x_return_msg :=fnd_message.get;
2716: RETURN x_return;
2717: END IF ;
2718: ELSE
2719: x_return :='F';

Line 2720: FND_MESSAGE.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');

2716: RETURN x_return;
2717: END IF ;
2718: ELSE
2719: x_return :='F';
2720: FND_MESSAGE.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');
2721: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2722: x_return_msg := fnd_message.get;
2723: RETURN x_return;
2724: END IF ;

Line 2721: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2717: END IF ;
2718: ELSE
2719: x_return :='F';
2720: FND_MESSAGE.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');
2721: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2722: x_return_msg := fnd_message.get;
2723: RETURN x_return;
2724: END IF ;
2725:

Line 2722: x_return_msg := fnd_message.get;

2718: ELSE
2719: x_return :='F';
2720: FND_MESSAGE.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');
2721: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2722: x_return_msg := fnd_message.get;
2723: RETURN x_return;
2724: END IF ;
2725:
2726: -- Added for lpn reservations

Line 2840: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

2836: END IF ;
2837:
2838: IF (p_inventory_item_id IS NULL) THEN
2839: x_return := 'N';
2840: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2841: x_return_msg := fnd_message.get;
2842: RETURN x_return;
2843: END IF ;
2844:

Line 2841: x_return_msg := fnd_message.get;

2837:
2838: IF (p_inventory_item_id IS NULL) THEN
2839: x_return := 'N';
2840: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2841: x_return_msg := fnd_message.get;
2842: RETURN x_return;
2843: END IF ;
2844:
2845: IF (p_lpn_id is NOT NULL AND p_lpn_id <> 0)

Line 2862: fnd_message.set_name('INV', 'INV_LPN_INVALID');

2858:
2859: IF x_lpn_onhand is NULL
2860: THEN
2861: x_return := 'N';
2862: fnd_message.set_name('INV', 'INV_LPN_INVALID');
2863: x_return_msg := fnd_message.get;
2864: RETURN x_return;
2865: END IF;*/
2866: ELSE

Line 2863: x_return_msg := fnd_message.get;

2859: IF x_lpn_onhand is NULL
2860: THEN
2861: x_return := 'N';
2862: fnd_message.set_name('INV', 'INV_LPN_INVALID');
2863: x_return_msg := fnd_message.get;
2864: RETURN x_return;
2865: END IF;*/
2866: ELSE
2867: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

Line 2929: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');

2925: RETURN x_return;
2926: END IF ;
2927: ELSE
2928: x_return :='F';
2929: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2930: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2931: x_return_msg := fnd_message.get;
2932: RETURN x_return;
2933: END IF ;

Line 2930: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2926: END IF ;
2927: ELSE
2928: x_return :='F';
2929: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2930: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2931: x_return_msg := fnd_message.get;
2932: RETURN x_return;
2933: END IF ;
2934:

Line 2931: x_return_msg := fnd_message.get;

2927: ELSE
2928: x_return :='F';
2929: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2930: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2931: x_return_msg := fnd_message.get;
2932: RETURN x_return;
2933: END IF ;
2934:
2935: RETURN x_return;

Line 3020: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

3016: END IF ;
3017:
3018: IF (p_inventory_item_id IS NULL) THEN
3019: x_return := 'N';
3020: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
3021: x_return_msg := fnd_message.get;
3022: RETURN x_return;
3023: END IF ;
3024:

Line 3021: x_return_msg := fnd_message.get;

3017:
3018: IF (p_inventory_item_id IS NULL) THEN
3019: x_return := 'N';
3020: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
3021: x_return_msg := fnd_message.get;
3022: RETURN x_return;
3023: END IF ;
3024:
3025: IF (p_lpn_id is NOT NULL AND p_lpn_id <> 0)

Line 3042: fnd_message.set_name('INV', 'INV_LPN_INVALID');

3038:
3039: IF x_lpn_onhand is NULL
3040: THEN
3041: x_return := 'N';
3042: fnd_message.set_name('INV', 'INV_LPN_INVALID');
3043: x_return_msg := fnd_message.get;
3044: RETURN x_return;
3045: END IF;*/
3046: ELSE

Line 3043: x_return_msg := fnd_message.get;

3039: IF x_lpn_onhand is NULL
3040: THEN
3041: x_return := 'N';
3042: fnd_message.set_name('INV', 'INV_LPN_INVALID');
3043: x_return_msg := fnd_message.get;
3044: RETURN x_return;
3045: END IF;*/
3046: ELSE
3047: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

Line 3119: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');

3115: RETURN x_return;
3116: END IF ;
3117: ELSE
3118: x_return :='F';
3119: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3120: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3121: x_return_msg := fnd_message.get;
3122: RETURN x_return;
3123: END IF ;

Line 3120: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

3116: END IF ;
3117: ELSE
3118: x_return :='F';
3119: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3120: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3121: x_return_msg := fnd_message.get;
3122: RETURN x_return;
3123: END IF ;
3124:

Line 3121: x_return_msg := fnd_message.get;

3117: ELSE
3118: x_return :='F';
3119: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3120: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3121: x_return_msg := fnd_message.get;
3122: RETURN x_return;
3123: END IF ;
3124:
3125: RETURN x_return;

Line 3194: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

3190: END IF ;
3191:
3192: IF (p_inventory_item_id IS NULL) THEN
3193: x_return := 'N';
3194: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
3195: x_return_msg := fnd_message.get;
3196: RETURN x_return;
3197: END IF ;
3198:

Line 3195: x_return_msg := fnd_message.get;

3191:
3192: IF (p_inventory_item_id IS NULL) THEN
3193: x_return := 'N';
3194: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
3195: x_return_msg := fnd_message.get;
3196: RETURN x_return;
3197: END IF ;
3198:
3199: IF (p_lpn_id is NOT NULL AND p_lpn_id <> 0)

Line 3216: fnd_message.set_name('INV', 'INV_LPN_INVALID');

3212:
3213: IF x_lpn_onhand is NULL
3214: THEN
3215: x_return := 'N';
3216: fnd_message.set_name('INV', 'INV_LPN_INVALID');
3217: x_return_msg := fnd_message.get;
3218: RETURN x_return;
3219: END IF;*/
3220: ELSE

Line 3217: x_return_msg := fnd_message.get;

3213: IF x_lpn_onhand is NULL
3214: THEN
3215: x_return := 'N';
3216: fnd_message.set_name('INV', 'INV_LPN_INVALID');
3217: x_return_msg := fnd_message.get;
3218: RETURN x_return;
3219: END IF;*/
3220: ELSE
3221: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

Line 3275: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');

3271: RETURN x_return;
3272: END IF ;
3273: ELSE
3274: x_return :='F';
3275: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3276: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3277: x_return_msg := fnd_message.get;
3278: RETURN x_return;
3279: END IF ;

Line 3276: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

3272: END IF ;
3273: ELSE
3274: x_return :='F';
3275: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3276: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3277: x_return_msg := fnd_message.get;
3278: RETURN x_return;
3279: END IF ;
3280:

Line 3277: x_return_msg := fnd_message.get;

3273: ELSE
3274: x_return :='F';
3275: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3276: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3277: x_return_msg := fnd_message.get;
3278: RETURN x_return;
3279: END IF ;
3280:
3281: RETURN x_return;

Line 3633: fnd_message.set_name('INV', 'INV_NOT_SAME_LOC');

3629: x_serial_processed := 'NO'; -- No processing has been done
3630:
3631: IF p_subinventory_code = p_to_subinventory_code
3632: AND Nvl(p_locator_id, -1) = Nvl(p_to_locator_id, -1) THEN
3633: fnd_message.set_name('INV', 'INV_NOT_SAME_LOC');
3634:
3635: IF p_locator_id IS NOT NULL THEN
3636: x_serial_processed := 'TOLOC';
3637: ELSE

Line 3641: x_return_msg := fnd_message.get;

3637: ELSE
3638: x_serial_processed := 'TOSUB';
3639: END IF;
3640:
3641: x_return_msg := fnd_message.get;
3642: RETURN;
3643: END IF;
3644:
3645: -- Check if the serial number is available to be transacted for this transaction

Line 3664: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');

3660: IF (l_debug = 1) THEN
3661: inv_log_util.trace('Status Allowed: ' || l_status_allowed, 'process_serial_subxfr');
3662: END IF;
3663: IF l_status_allowed <> 'Y' THEN
3664: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
3665: fnd_message.set_token('TOKEN1', p_serial_number);
3666: fnd_message.set_token('TOKEN2', p_inventory_item);
3667: x_serial_processed := 'SERIAL';
3668: x_return_msg := fnd_message.get;

Line 3665: fnd_message.set_token('TOKEN1', p_serial_number);

3661: inv_log_util.trace('Status Allowed: ' || l_status_allowed, 'process_serial_subxfr');
3662: END IF;
3663: IF l_status_allowed <> 'Y' THEN
3664: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
3665: fnd_message.set_token('TOKEN1', p_serial_number);
3666: fnd_message.set_token('TOKEN2', p_inventory_item);
3667: x_serial_processed := 'SERIAL';
3668: x_return_msg := fnd_message.get;
3669: RETURN;

Line 3666: fnd_message.set_token('TOKEN2', p_inventory_item);

3662: END IF;
3663: IF l_status_allowed <> 'Y' THEN
3664: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
3665: fnd_message.set_token('TOKEN1', p_serial_number);
3666: fnd_message.set_token('TOKEN2', p_inventory_item);
3667: x_serial_processed := 'SERIAL';
3668: x_return_msg := fnd_message.get;
3669: RETURN;
3670: END IF;

Line 3668: x_return_msg := fnd_message.get;

3664: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
3665: fnd_message.set_token('TOKEN1', p_serial_number);
3666: fnd_message.set_token('TOKEN2', p_inventory_item);
3667: x_serial_processed := 'SERIAL';
3668: x_return_msg := fnd_message.get;
3669: RETURN;
3670: END IF;
3671:
3672: inv_ui_item_sub_loc_lovs.get_to_sub(x_to_sub => l_ref_cur,

Line 3703: fnd_message.set_name('INV', 'INV_INVALID_SUB');

3699: inv_log_util.trace('l_to_subinventory_code: ' || l_to_subinventory_code, 'process_serial_subxfr');
3700: END IF;
3701:
3702: IF p_to_subinventory_code <> Nvl(l_to_subinventory_code, '@@@') THEN
3703: fnd_message.set_name('INV', 'INV_INVALID_SUB');
3704: x_serial_processed := 'TOSUB';
3705: x_return_msg := fnd_message.get;
3706: RETURN;
3707: END IF;

Line 3705: x_return_msg := fnd_message.get;

3701:
3702: IF p_to_subinventory_code <> Nvl(l_to_subinventory_code, '@@@') THEN
3703: fnd_message.set_name('INV', 'INV_INVALID_SUB');
3704: x_serial_processed := 'TOSUB';
3705: x_return_msg := fnd_message.get;
3706: RETURN;
3707: END IF;
3708:
3709:

Line 3760: fnd_message.set_name('INV', 'INV_INT_LOCCODE');

3756: inv_log_util.trace('l_to_locator_id: ' || l_to_locator_id, 'process_serial_subxfr');
3757: END IF;
3758:
3759: IF p_to_locator_id <> Nvl(l_to_locator_id, -1) THEN
3760: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
3761: x_serial_processed := 'TOLOC';
3762: x_return_msg := fnd_message.get;
3763: RETURN;
3764: END IF;

Line 3762: x_return_msg := fnd_message.get;

3758:
3759: IF p_to_locator_id <> Nvl(l_to_locator_id, -1) THEN
3760: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
3761: x_serial_processed := 'TOLOC';
3762: x_return_msg := fnd_message.get;
3763: RETURN;
3764: END IF;
3765: END IF;
3766: -- End of the newly added loop I Development Bug 2634570

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

3805: x_att => l_att,
3806: x_atr => l_atr);
3807:
3808: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3809: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3810: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3811: x_return_msg := fnd_message.get;
3812: RETURN;
3813: END IF;

Line 3810: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

3806: x_atr => l_atr);
3807:
3808: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3809: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3810: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3811: x_return_msg := fnd_message.get;
3812: RETURN;
3813: END IF;
3814: IF (l_debug = 1) THEN

Line 3811: x_return_msg := fnd_message.get;

3807:
3808: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3809: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3810: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3811: x_return_msg := fnd_message.get;
3812: RETURN;
3813: END IF;
3814: IF (l_debug = 1) THEN
3815: inv_log_util.trace('ATT: ' || l_att, 'process_serial_subxfr');

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

3862: x_att => l_att,
3863: x_atr => l_atr);
3864:
3865: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3866: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3867: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3868: x_return_msg := fnd_message.get;
3869: RETURN;
3870: END IF;

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

3863: x_atr => l_atr);
3864:
3865: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3866: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3867: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3868: x_return_msg := fnd_message.get;
3869: RETURN;
3870: END IF;
3871: IF (l_debug = 1) THEN

Line 3868: x_return_msg := fnd_message.get;

3864:
3865: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3866: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3867: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3868: x_return_msg := fnd_message.get;
3869: RETURN;
3870: END IF;
3871: IF (l_debug = 1) THEN
3872: inv_log_util.trace('ATT in source: ' || l_att, 'process_serial_subxfr');

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

3899: x_att => l_att,
3900: x_atr => l_atr);
3901:
3902: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3903: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3904: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3905: x_return_msg := fnd_message.get;
3906: RETURN;
3907: END IF;

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

3900: x_atr => l_atr);
3901:
3902: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3903: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3904: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3905: x_return_msg := fnd_message.get;
3906: RETURN;
3907: END IF;
3908:

Line 3905: x_return_msg := fnd_message.get;

3901:
3902: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3903: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
3904: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
3905: x_return_msg := fnd_message.get;
3906: RETURN;
3907: END IF;
3908:
3909: IF (l_debug = 1) THEN

Line 4046: FND_MESSAGE.set_name('INV', 'INV_SERIAL_EXCEED_AVAILABLE');

4042:
4043: x_serial_processed := 'YES';
4044:
4045: ELSE -- att < 0
4046: FND_MESSAGE.set_name('INV', 'INV_SERIAL_EXCEED_AVAILABLE');
4047: x_return_msg := fnd_message.get;
4048: RETURN;
4049: END IF;
4050:

Line 4047: x_return_msg := fnd_message.get;

4043: x_serial_processed := 'YES';
4044:
4045: ELSE -- att < 0
4046: FND_MESSAGE.set_name('INV', 'INV_SERIAL_EXCEED_AVAILABLE');
4047: x_return_msg := fnd_message.get;
4048: RETURN;
4049: END IF;
4050:
4051: END IF;

Line 4569: fnd_message.set_name('INV', 'INV_PENDING_TXNS_EXISTS');

4565: IF (l_debug = 1) THEN
4566: mdebug ('lpn '||l_lpn_id||' has some pending transactions to be completed.');
4567: END IF;
4568: x_return := 'N';
4569: fnd_message.set_name('INV', 'INV_PENDING_TXNS_EXISTS');
4570: x_return_msg := fnd_message.get;
4571: RETURN x_return;
4572: end if;
4573: END LOOP;

Line 4570: x_return_msg := fnd_message.get;

4566: mdebug ('lpn '||l_lpn_id||' has some pending transactions to be completed.');
4567: END IF;
4568: x_return := 'N';
4569: fnd_message.set_name('INV', 'INV_PENDING_TXNS_EXISTS');
4570: x_return_msg := fnd_message.get;
4571: RETURN x_return;
4572: end if;
4573: END LOOP;
4574: CLOSE c_lpn_content;