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_TROLIN_UTIL dependencies on FND_MSG_PUB

Line 1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1982: --INVCONV END;
1983: WHERE line_id = p_trolin_rec.line_id;
1984: EXCEPTION
1985: WHEN OTHERS THEN
1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1987: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1988: END IF;
1989:
1990: RAISE fnd_api.g_exc_unexpected_error;

Line 1987: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');

1983: WHERE line_id = p_trolin_rec.line_id;
1984: EXCEPTION
1985: WHEN OTHERS THEN
1986: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1987: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1988: END IF;
1989:
1990: RAISE fnd_api.g_exc_unexpected_error;
1991: END update_row;

Line 2007: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2003: l_trolin_rec.last_update_login := fnd_global.login_id;
2004: inv_trolin_util.update_row(l_trolin_rec);
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2008: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
2009: END IF;
2010:
2011: RAISE fnd_api.g_exc_unexpected_error;

Line 2008: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');

2004: inv_trolin_util.update_row(l_trolin_rec);
2005: EXCEPTION
2006: WHEN OTHERS THEN
2007: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2008: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
2009: END IF;
2010:
2011: RAISE fnd_api.g_exc_unexpected_error;
2012: END update_row_status;

Line 2203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2199: --INVCONV END;
2200: );
2201: EXCEPTION
2202: WHEN OTHERS THEN
2203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2204: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
2205: END IF;
2206:
2207: RAISE fnd_api.g_exc_unexpected_error;

Line 2204: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');

2200: );
2201: EXCEPTION
2202: WHEN OTHERS THEN
2203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2204: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
2205: END IF;
2206:
2207: RAISE fnd_api.g_exc_unexpected_error;
2208: END insert_row;

Line 2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2214: DELETE FROM mtl_txn_request_lines
2215: WHERE line_id = p_line_id;
2216: EXCEPTION
2217: WHEN OTHERS THEN
2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2219: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
2220: END IF;
2221:
2222: RAISE fnd_api.g_exc_unexpected_error;

Line 2219: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');

2215: WHERE line_id = p_line_id;
2216: EXCEPTION
2217: WHEN OTHERS THEN
2218: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2219: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
2220: END IF;
2221:
2222: RAISE fnd_api.g_exc_unexpected_error;
2223: END delete_row;

Line 2446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2442: )
2443: AND (p_header_id IS NOT NULL
2444: AND p_header_id <> fnd_api.g_miss_num
2445: ) THEN
2446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2447: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query Rows', 'Keys are mutually exclusive: line_id = ' || p_line_id || ', header_id = ' || p_header_id);
2448: END IF;
2449:
2450: RAISE fnd_api.g_exc_unexpected_error;

Line 2447: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query Rows', 'Keys are mutually exclusive: line_id = ' || p_line_id || ', header_id = ' || p_header_id);

2443: AND (p_header_id IS NOT NULL
2444: AND p_header_id <> fnd_api.g_miss_num
2445: ) THEN
2446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2447: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query Rows', 'Keys are mutually exclusive: line_id = ' || p_line_id || ', header_id = ' || p_header_id);
2448: END IF;
2449:
2450: RAISE fnd_api.g_exc_unexpected_error;
2451: END IF;

Line 2662: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2658: EXCEPTION
2659: WHEN fnd_api.g_exc_unexpected_error THEN
2660: RAISE fnd_api.g_exc_unexpected_error;
2661: WHEN OTHERS THEN
2662: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2663: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2664: END IF;
2665:
2666: RAISE fnd_api.g_exc_unexpected_error;

Line 2663: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');

2659: WHEN fnd_api.g_exc_unexpected_error THEN
2660: RAISE fnd_api.g_exc_unexpected_error;
2661: WHEN OTHERS THEN
2662: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2663: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2664: END IF;
2665:
2666: RAISE fnd_api.g_exc_unexpected_error;
2667: END query_rows;

Line 3200: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

3196:
3197: x_return_status := fnd_api.g_ret_sts_error;
3198: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3199:
3200: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3201: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3202: fnd_msg_pub.ADD;
3203: END IF;
3204: END IF;

Line 3202: fnd_msg_pub.ADD;

3198: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3199:
3200: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3201: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3202: fnd_msg_pub.ADD;
3203: END IF;
3204: END IF;
3205: --Line2086
3206: EXCEPTION

Line 3211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

3207: WHEN NO_DATA_FOUND THEN
3208: x_return_status := fnd_api.g_ret_sts_error;
3209: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3210:
3211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3212: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3213: fnd_msg_pub.ADD;
3214: END IF;
3215: WHEN app_exceptions.record_lock_exception THEN

Line 3213: fnd_msg_pub.ADD;

3209: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3210:
3211: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3212: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3213: fnd_msg_pub.ADD;
3214: END IF;
3215: WHEN app_exceptions.record_lock_exception THEN
3216: x_return_status := fnd_api.g_ret_sts_error;
3217: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;

Line 3219: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

3215: WHEN app_exceptions.record_lock_exception THEN
3216: x_return_status := fnd_api.g_ret_sts_error;
3217: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3218:
3219: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3220: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3221: fnd_msg_pub.ADD;
3222: END IF;
3223: WHEN OTHERS THEN

Line 3221: fnd_msg_pub.ADD;

3217: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3218:
3219: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3220: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3221: fnd_msg_pub.ADD;
3222: END IF;
3223: WHEN OTHERS THEN
3224: x_return_status := fnd_api.g_ret_sts_unexp_error;
3225: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;

Line 3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3223: WHEN OTHERS THEN
3224: x_return_status := fnd_api.g_ret_sts_unexp_error;
3225: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3226:
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3229: END IF;
3230: END lock_row;
3231:

Line 3228: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');

3224: x_return_status := fnd_api.g_ret_sts_unexp_error;
3225: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3226:
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3229: END IF;
3230: END lock_row;
3231:
3232: -- Function Get_Values

Line 3393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3389: IF p_trolin_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
3390:
3391: l_trolin_rec.from_locator_id := p_trolin_rec.from_locator_id;
3392:
3393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3394: THEN
3395:
3396: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator');

Line 3398: FND_MSG_PUB.Add;

3394: THEN
3395:
3396: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3397: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator');
3398: FND_MSG_PUB.Add;
3399:
3400: END IF;
3401:
3402: ELSE

Line 3422: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3418: IF p_trolin_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
3419: IF p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num THEN
3420: l_trolin_rec.from_subinventory_id := p_trolin_rec.from_subinventory_id;
3421:
3422: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3423: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3424: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
3425: fnd_msg_pub.ADD;
3426: END IF;

Line 3425: fnd_msg_pub.ADD;

3421:
3422: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3423: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3424: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
3425: fnd_msg_pub.ADD;
3426: END IF;
3427: ELSE
3428: l_trolin_rec.from_subinventory_id := inv_value_to_id.from_subinventory(p_organization_id => p_trolin_rec.organization_id, p_from_subinventory => p_trolin_val_rec.from_subinventory);
3429:

Line 3440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3436: IF p_trolin_val_rec.header <> fnd_api.g_miss_char THEN
3437: IF p_trolin_rec.header_id <> fnd_api.g_miss_num THEN
3438: l_trolin_rec.header_id := p_trolin_rec.header_id;
3439:
3440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3441: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3442: fnd_message.set_token('ATTRIBUTE', 'header');
3443: fnd_msg_pub.ADD;
3444: END IF;

Line 3443: fnd_msg_pub.ADD;

3439:
3440: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3441: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3442: fnd_message.set_token('ATTRIBUTE', 'header');
3443: fnd_msg_pub.ADD;
3444: END IF;
3445: ELSE
3446: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3447:

Line 3458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3454: IF p_trolin_val_rec.inventory_item <> fnd_api.g_miss_char THEN
3455: IF p_trolin_rec.inventory_item_id <> fnd_api.g_miss_num THEN
3456: l_trolin_rec.inventory_item_id := p_trolin_rec.inventory_item_id;
3457:
3458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3459: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3460: fnd_message.set_token('ATTRIBUTE', 'inventory_item');
3461: fnd_msg_pub.ADD;
3462: END IF;

Line 3461: fnd_msg_pub.ADD;

3457:
3458: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3459: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3460: fnd_message.set_token('ATTRIBUTE', 'inventory_item');
3461: fnd_msg_pub.ADD;
3462: END IF;
3463: ELSE
3464: l_trolin_rec.inventory_item_id := inv_value_to_id.inventory_item(p_organization_id => p_trolin_rec.organization_id, p_inventory_item => p_trolin_val_rec.inventory_item);
3465:

Line 3476: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3472: IF p_trolin_val_rec.line <> fnd_api.g_miss_char THEN
3473: IF p_trolin_rec.line_id <> fnd_api.g_miss_num THEN
3474: l_trolin_rec.line_id := p_trolin_rec.line_id;
3475:
3476: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3477: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3478: fnd_message.set_token('ATTRIBUTE', 'line');
3479: fnd_msg_pub.ADD;
3480: END IF;

Line 3479: fnd_msg_pub.ADD;

3475:
3476: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3477: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3478: fnd_message.set_token('ATTRIBUTE', 'line');
3479: fnd_msg_pub.ADD;
3480: END IF;
3481: ELSE
3482: l_trolin_rec.line_id := inv_value_to_id.line(p_line => p_trolin_val_rec.line);
3483:

Line 3494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3490: IF p_trolin_val_rec.ORGANIZATION <> fnd_api.g_miss_char THEN
3491: IF p_trolin_rec.organization_id <> fnd_api.g_miss_num THEN
3492: l_trolin_rec.organization_id := p_trolin_rec.organization_id;
3493:
3494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3495: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3496: fnd_message.set_token('ATTRIBUTE', 'organization');
3497: fnd_msg_pub.ADD;
3498: END IF;

Line 3497: fnd_msg_pub.ADD;

3493:
3494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3495: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3496: fnd_message.set_token('ATTRIBUTE', 'organization');
3497: fnd_msg_pub.ADD;
3498: END IF;
3499: ELSE
3500: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3501:

Line 3512: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3508: IF p_trolin_val_rec.to_organization <> fnd_api.g_miss_char THEN
3509: IF p_trolin_rec.to_organization_id <> fnd_api.g_miss_num THEN
3510: l_trolin_rec.to_organization_id := p_trolin_rec.to_organization_id;
3511:
3512: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3513: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3514: fnd_message.set_token('ATTRIBUTE', 'to_organization');
3515: fnd_msg_pub.ADD;
3516: END IF;

Line 3515: fnd_msg_pub.ADD;

3511:
3512: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3513: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3514: fnd_message.set_token('ATTRIBUTE', 'to_organization');
3515: fnd_msg_pub.ADD;
3516: END IF;
3517: ELSE
3518: l_trolin_rec.to_organization_id := inv_value_to_id.to_organization(p_to_organization => p_trolin_val_rec.to_organization);
3519:

Line 3530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3526: IF p_trolin_val_rec.project <> fnd_api.g_miss_char THEN
3527: IF p_trolin_rec.project_id <> fnd_api.g_miss_num THEN
3528: l_trolin_rec.project_id := p_trolin_rec.project_id;
3529:
3530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3531: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3532: fnd_message.set_token('ATTRIBUTE', 'project');
3533: fnd_msg_pub.ADD;
3534: END IF;

Line 3533: fnd_msg_pub.ADD;

3529:
3530: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3531: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3532: fnd_message.set_token('ATTRIBUTE', 'project');
3533: fnd_msg_pub.ADD;
3534: END IF;
3535: ELSE
3536: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3537:

Line 3548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3544: IF p_trolin_val_rec.reason <> fnd_api.g_miss_char THEN
3545: IF p_trolin_rec.reason_id <> fnd_api.g_miss_num THEN
3546: l_trolin_rec.reason_id := p_trolin_rec.reason_id;
3547:
3548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3549: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3550: fnd_message.set_token('ATTRIBUTE', 'reason');
3551: fnd_msg_pub.ADD;
3552: END IF;

Line 3551: fnd_msg_pub.ADD;

3547:
3548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3549: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3550: fnd_message.set_token('ATTRIBUTE', 'reason');
3551: fnd_msg_pub.ADD;
3552: END IF;
3553: ELSE
3554: l_trolin_rec.reason_id := inv_value_to_id.reason(p_reason => p_trolin_val_rec.reason);
3555:

Line 3566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3562: IF p_trolin_val_rec.REFERENCE <> fnd_api.g_miss_char THEN
3563: IF p_trolin_rec.reference_id <> fnd_api.g_miss_num THEN
3564: l_trolin_rec.reference_id := p_trolin_rec.reference_id;
3565:
3566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3567: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3568: fnd_message.set_token('ATTRIBUTE', 'reference');
3569: fnd_msg_pub.ADD;
3570: END IF;

Line 3569: fnd_msg_pub.ADD;

3565:
3566: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3567: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3568: fnd_message.set_token('ATTRIBUTE', 'reference');
3569: fnd_msg_pub.ADD;
3570: END IF;
3571: ELSE
3572: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3573:

Line 3584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3580: IF p_trolin_val_rec.reference_type <> fnd_api.g_miss_char THEN
3581: IF p_trolin_rec.reference_type_code <> fnd_api.g_miss_num THEN
3582: l_trolin_rec.reference_type_code := p_trolin_rec.reference_type_code;
3583:
3584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3585: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3586: fnd_message.set_token('ATTRIBUTE', 'reference_type');
3587: fnd_msg_pub.ADD;
3588: END IF;

Line 3587: fnd_msg_pub.ADD;

3583:
3584: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3585: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3586: fnd_message.set_token('ATTRIBUTE', 'reference_type');
3587: fnd_msg_pub.ADD;
3588: END IF;
3589: ELSE
3590: l_trolin_rec.reference_type_code := inv_value_to_id.reference_type(p_reference_type => p_trolin_val_rec.reference_type);
3591:

Line 3602: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3598: IF p_trolin_val_rec.task <> fnd_api.g_miss_char THEN
3599: IF p_trolin_rec.task_id <> fnd_api.g_miss_num THEN
3600: l_trolin_rec.task_id := p_trolin_rec.task_id;
3601:
3602: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3603: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3604: fnd_message.set_token('ATTRIBUTE', 'task');
3605: fnd_msg_pub.ADD;
3606: END IF;

Line 3605: fnd_msg_pub.ADD;

3601:
3602: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3603: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3604: fnd_message.set_token('ATTRIBUTE', 'task');
3605: fnd_msg_pub.ADD;
3606: END IF;
3607: ELSE
3608: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3609:

Line 3620: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3616: IF p_trolin_val_rec.to_account <> fnd_api.g_miss_char THEN
3617: IF p_trolin_rec.to_account_id <> fnd_api.g_miss_num THEN
3618: l_trolin_rec.to_account_id := p_trolin_rec.to_account_id;
3619:
3620: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3621: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3622: fnd_message.set_token('ATTRIBUTE', 'to_account');
3623: fnd_msg_pub.ADD;
3624: END IF;

Line 3623: fnd_msg_pub.ADD;

3619:
3620: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3621: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3622: fnd_message.set_token('ATTRIBUTE', 'to_account');
3623: fnd_msg_pub.ADD;
3624: END IF;
3625: ELSE
3626: l_trolin_rec.to_account_id := inv_value_to_id.to_account(p_organization_id => p_trolin_rec.organization_id, p_to_account => p_trolin_val_rec.to_account);
3627:

Line 3642: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3638: IF p_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
3639:
3640: l_trolin_rec.to_locator_id := p_trolin_rec.to_locator_id;
3641:
3642: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3643: THEN
3644:
3645: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator');

Line 3647: FND_MSG_PUB.Add;

3643: THEN
3644:
3645: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator');
3647: FND_MSG_PUB.Add;
3648:
3649: END IF;
3650:
3651: ELSE

Line 3670: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3666: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3667: IF p_trolin_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
3668: l_trolin_rec.to_subinventory_code := p_trolin_rec.to_subinventory_code;
3669:
3670: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3671: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3672: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3673: fnd_msg_pub.ADD;
3674: END IF;

Line 3673: fnd_msg_pub.ADD;

3669:
3670: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3671: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3672: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3673: fnd_msg_pub.ADD;
3674: END IF;
3675: ELSE
3676: l_trolin_rec.to_subinventory_code := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3677:

Line 3689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3685: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3686: IF p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num THEN
3687: l_trolin_rec.to_subinventory_id := p_trolin_rec.to_subinventory_id;
3688:
3689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3690: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3691: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3692: fnd_msg_pub.ADD;
3693: END IF;

Line 3692: fnd_msg_pub.ADD;

3688:
3689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3690: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3691: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3692: fnd_msg_pub.ADD;
3693: END IF;
3694: ELSE
3695: l_trolin_rec.to_subinventory_id := inv_value_to_id.to_subinventory(p_organization_id => p_trolin_rec.organization_id, p_to_subinventory => p_trolin_val_rec.to_subinventory);
3696:

Line 3707: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3703: IF p_trolin_val_rec.transaction_header <> fnd_api.g_miss_char THEN
3704: IF p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num THEN
3705: l_trolin_rec.transaction_header_id := p_trolin_rec.transaction_header_id;
3706:
3707: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3708: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3709: fnd_message.set_token('ATTRIBUTE', 'transaction_header');
3710: fnd_msg_pub.ADD;
3711: END IF;

Line 3710: fnd_msg_pub.ADD;

3706:
3707: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3708: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3709: fnd_message.set_token('ATTRIBUTE', 'transaction_header');
3710: fnd_msg_pub.ADD;
3711: END IF;
3712: ELSE
3713: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3714:

Line 3725: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3721: IF p_trolin_val_rec.transaction_type <> fnd_api.g_miss_char THEN
3722: IF p_trolin_rec.transaction_type_id <> fnd_api.g_miss_num THEN
3723: l_trolin_rec.transaction_type_id := p_trolin_rec.transaction_type_id;
3724:
3725: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3726: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3727: fnd_message.set_token('ATTRIBUTE', 'transaction_type');
3728: fnd_msg_pub.ADD;
3729: END IF;

Line 3728: fnd_msg_pub.ADD;

3724:
3725: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3726: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3727: fnd_message.set_token('ATTRIBUTE', 'transaction_type');
3728: fnd_msg_pub.ADD;
3729: END IF;
3730: ELSE
3731: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3732:

Line 3744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

3740: IF p_trolin_val_rec.uom <> fnd_api.g_miss_char THEN
3741: IF p_trolin_rec.uom_code <> fnd_api.g_miss_char THEN
3742: l_trolin_rec.uom_code := p_trolin_rec.uom_code;
3743:
3744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3745: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3746: fnd_message.set_token('ATTRIBUTE', 'uom');
3747: fnd_msg_pub.ADD;
3748: END IF;

Line 3747: fnd_msg_pub.ADD;

3743:
3744: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3745: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3746: fnd_message.set_token('ATTRIBUTE', 'uom');
3747: fnd_msg_pub.ADD;
3748: END IF;
3749: ELSE
3750: -- Line2917
3751: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);