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 1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1947: --INVCONV END;
1948: WHERE line_id = p_trolin_rec.line_id;
1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1952: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1953: END IF;
1954:
1955: RAISE fnd_api.g_exc_unexpected_error;

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

1948: WHERE line_id = p_trolin_rec.line_id;
1949: EXCEPTION
1950: WHEN OTHERS THEN
1951: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1952: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1953: END IF;
1954:
1955: RAISE fnd_api.g_exc_unexpected_error;
1956: END update_row;

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

1968: l_trolin_rec.last_update_login := fnd_global.login_id;
1969: inv_trolin_util.update_row(l_trolin_rec);
1970: EXCEPTION
1971: WHEN OTHERS THEN
1972: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1973: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
1974: END IF;
1975:
1976: RAISE fnd_api.g_exc_unexpected_error;

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

1969: inv_trolin_util.update_row(l_trolin_rec);
1970: EXCEPTION
1971: WHEN OTHERS THEN
1972: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1973: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row_Status');
1974: END IF;
1975:
1976: RAISE fnd_api.g_exc_unexpected_error;
1977: END update_row_status;

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

2164: --INVCONV END;
2165: );
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
2170: END IF;
2171:
2172: RAISE fnd_api.g_exc_unexpected_error;

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

2165: );
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2169: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
2170: END IF;
2171:
2172: RAISE fnd_api.g_exc_unexpected_error;
2173: END insert_row;

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

2179: DELETE FROM mtl_txn_request_lines
2180: WHERE line_id = p_line_id;
2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
2185: END IF;
2186:
2187: RAISE fnd_api.g_exc_unexpected_error;

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

2180: WHERE line_id = p_line_id;
2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
2185: END IF;
2186:
2187: RAISE fnd_api.g_exc_unexpected_error;
2188: END delete_row;

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

2407: )
2408: AND (p_header_id IS NOT NULL
2409: AND p_header_id <> fnd_api.g_miss_num
2410: ) THEN
2411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2412: 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);
2413: END IF;
2414:
2415: RAISE fnd_api.g_exc_unexpected_error;

Line 2412: 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);

2408: AND (p_header_id IS NOT NULL
2409: AND p_header_id <> fnd_api.g_miss_num
2410: ) THEN
2411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2412: 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);
2413: END IF;
2414:
2415: RAISE fnd_api.g_exc_unexpected_error;
2416: END IF;

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

2623: EXCEPTION
2624: WHEN fnd_api.g_exc_unexpected_error THEN
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: WHEN OTHERS THEN
2627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2629: END IF;
2630:
2631: RAISE fnd_api.g_exc_unexpected_error;

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

2624: WHEN fnd_api.g_exc_unexpected_error THEN
2625: RAISE fnd_api.g_exc_unexpected_error;
2626: WHEN OTHERS THEN
2627: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2628: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Rows');
2629: END IF;
2630:
2631: RAISE fnd_api.g_exc_unexpected_error;
2632: END query_rows;

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

3161:
3162: x_return_status := fnd_api.g_ret_sts_error;
3163: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3164:
3165: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3166: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3167: fnd_msg_pub.ADD;
3168: END IF;
3169: END IF;

Line 3167: fnd_msg_pub.ADD;

3163: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3164:
3165: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3166: fnd_message.set_name('INV', 'OE_LOCK_ROW_CHANGED');
3167: fnd_msg_pub.ADD;
3168: END IF;
3169: END IF;
3170: --Line2086
3171: EXCEPTION

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

3172: WHEN NO_DATA_FOUND THEN
3173: x_return_status := fnd_api.g_ret_sts_error;
3174: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3175:
3176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3177: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN app_exceptions.record_lock_exception THEN

Line 3178: fnd_msg_pub.ADD;

3174: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3175:
3176: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3177: fnd_message.set_name('INV', 'OE_LOCK_ROW_DELETED');
3178: fnd_msg_pub.ADD;
3179: END IF;
3180: WHEN app_exceptions.record_lock_exception THEN
3181: x_return_status := fnd_api.g_ret_sts_error;
3182: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;

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

3180: WHEN app_exceptions.record_lock_exception THEN
3181: x_return_status := fnd_api.g_ret_sts_error;
3182: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3183:
3184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3185: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3186: fnd_msg_pub.ADD;
3187: END IF;
3188: WHEN OTHERS THEN

Line 3186: fnd_msg_pub.ADD;

3182: x_trolin_rec.return_status := fnd_api.g_ret_sts_error;
3183:
3184: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
3185: fnd_message.set_name('INV', 'OE_LOCK_ROW_ALREADY_LOCKED');
3186: fnd_msg_pub.ADD;
3187: END IF;
3188: WHEN OTHERS THEN
3189: x_return_status := fnd_api.g_ret_sts_unexp_error;
3190: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;

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

3188: WHEN OTHERS THEN
3189: x_return_status := fnd_api.g_ret_sts_unexp_error;
3190: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3191:
3192: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3193: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3194: END IF;
3195: END lock_row;
3196:

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

3189: x_return_status := fnd_api.g_ret_sts_unexp_error;
3190: x_trolin_rec.return_status := fnd_api.g_ret_sts_unexp_error;
3191:
3192: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3193: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Lock_Row');
3194: END IF;
3195: END lock_row;
3196:
3197: -- Function Get_Values

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

3354: IF p_trolin_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
3355:
3356: l_trolin_rec.from_locator_id := p_trolin_rec.from_locator_id;
3357:
3358: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3359: THEN
3360:
3361: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator');

Line 3363: FND_MSG_PUB.Add;

3359: THEN
3360:
3361: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','from_locator');
3363: FND_MSG_PUB.Add;
3364:
3365: END IF;
3366:
3367: ELSE

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

3383: IF p_trolin_val_rec.from_subinventory <> fnd_api.g_miss_char THEN
3384: IF p_trolin_rec.from_subinventory_id <> fnd_api.g_miss_num THEN
3385: l_trolin_rec.from_subinventory_id := p_trolin_rec.from_subinventory_id;
3386:
3387: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3388: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3389: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
3390: fnd_msg_pub.ADD;
3391: END IF;

Line 3390: fnd_msg_pub.ADD;

3386:
3387: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3388: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3389: fnd_message.set_token('ATTRIBUTE', 'from_subinventory');
3390: fnd_msg_pub.ADD;
3391: END IF;
3392: ELSE
3393: 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);
3394:

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

3401: IF p_trolin_val_rec.header <> fnd_api.g_miss_char THEN
3402: IF p_trolin_rec.header_id <> fnd_api.g_miss_num THEN
3403: l_trolin_rec.header_id := p_trolin_rec.header_id;
3404:
3405: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3406: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3407: fnd_message.set_token('ATTRIBUTE', 'header');
3408: fnd_msg_pub.ADD;
3409: END IF;

Line 3408: fnd_msg_pub.ADD;

3404:
3405: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3406: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3407: fnd_message.set_token('ATTRIBUTE', 'header');
3408: fnd_msg_pub.ADD;
3409: END IF;
3410: ELSE
3411: l_trolin_rec.header_id := inv_value_to_id.header(p_header => p_trolin_val_rec.header);
3412:

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

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

Line 3426: fnd_msg_pub.ADD;

3422:
3423: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3424: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3425: fnd_message.set_token('ATTRIBUTE', 'inventory_item');
3426: fnd_msg_pub.ADD;
3427: END IF;
3428: ELSE
3429: 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);
3430:

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

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

Line 3444: fnd_msg_pub.ADD;

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

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

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

Line 3462: fnd_msg_pub.ADD;

3458:
3459: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3460: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3461: fnd_message.set_token('ATTRIBUTE', 'organization');
3462: fnd_msg_pub.ADD;
3463: END IF;
3464: ELSE
3465: l_trolin_rec.organization_id := inv_value_to_id.ORGANIZATION(p_organization => p_trolin_val_rec.ORGANIZATION);
3466:

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

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

Line 3480: fnd_msg_pub.ADD;

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

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

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

Line 3498: fnd_msg_pub.ADD;

3494:
3495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3496: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3497: fnd_message.set_token('ATTRIBUTE', 'project');
3498: fnd_msg_pub.ADD;
3499: END IF;
3500: ELSE
3501: l_trolin_rec.project_id := inv_value_to_id.project(p_project => p_trolin_val_rec.project);
3502:

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

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

Line 3516: fnd_msg_pub.ADD;

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

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

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

Line 3534: fnd_msg_pub.ADD;

3530:
3531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3532: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3533: fnd_message.set_token('ATTRIBUTE', 'reference');
3534: fnd_msg_pub.ADD;
3535: END IF;
3536: ELSE
3537: l_trolin_rec.reference_id := inv_value_to_id.REFERENCE(p_reference => p_trolin_val_rec.REFERENCE);
3538:

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

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

Line 3552: fnd_msg_pub.ADD;

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

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

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

Line 3570: fnd_msg_pub.ADD;

3566:
3567: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3568: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3569: fnd_message.set_token('ATTRIBUTE', 'task');
3570: fnd_msg_pub.ADD;
3571: END IF;
3572: ELSE
3573: l_trolin_rec.task_id := inv_value_to_id.task(p_task => p_trolin_val_rec.task);
3574:

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

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

Line 3588: fnd_msg_pub.ADD;

3584:
3585: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3586: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3587: fnd_message.set_token('ATTRIBUTE', 'to_account');
3588: fnd_msg_pub.ADD;
3589: END IF;
3590: ELSE
3591: 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);
3592:

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

3603: IF p_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
3604:
3605: l_trolin_rec.to_locator_id := p_trolin_rec.to_locator_id;
3606:
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3608: THEN
3609:
3610: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator');

Line 3612: FND_MSG_PUB.Add;

3608: THEN
3609:
3610: FND_MESSAGE.SET_NAME('INV','FND_BOTH_VAL_AND_ID_EXIST');
3611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','to_locator');
3612: FND_MSG_PUB.Add;
3613:
3614: END IF;
3615:
3616: ELSE

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

3631: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3632: IF p_trolin_rec.to_subinventory_code <> fnd_api.g_miss_char THEN
3633: l_trolin_rec.to_subinventory_code := p_trolin_rec.to_subinventory_code;
3634:
3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3636: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3637: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3638: fnd_msg_pub.ADD;
3639: END IF;

Line 3638: fnd_msg_pub.ADD;

3634:
3635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3636: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3637: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3638: fnd_msg_pub.ADD;
3639: END IF;
3640: ELSE
3641: 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);
3642:

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

3650: IF p_trolin_val_rec.to_subinventory <> fnd_api.g_miss_char THEN
3651: IF p_trolin_rec.to_subinventory_id <> fnd_api.g_miss_num THEN
3652: l_trolin_rec.to_subinventory_id := p_trolin_rec.to_subinventory_id;
3653:
3654: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3655: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3656: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3657: fnd_msg_pub.ADD;
3658: END IF;

Line 3657: fnd_msg_pub.ADD;

3653:
3654: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3655: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3656: fnd_message.set_token('ATTRIBUTE', 'to_subinventory');
3657: fnd_msg_pub.ADD;
3658: END IF;
3659: ELSE
3660: 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);
3661:

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

3668: IF p_trolin_val_rec.transaction_header <> fnd_api.g_miss_char THEN
3669: IF p_trolin_rec.transaction_header_id <> fnd_api.g_miss_num THEN
3670: l_trolin_rec.transaction_header_id := p_trolin_rec.transaction_header_id;
3671:
3672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3673: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3674: fnd_message.set_token('ATTRIBUTE', 'transaction_header');
3675: fnd_msg_pub.ADD;
3676: END IF;

Line 3675: fnd_msg_pub.ADD;

3671:
3672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3673: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3674: fnd_message.set_token('ATTRIBUTE', 'transaction_header');
3675: fnd_msg_pub.ADD;
3676: END IF;
3677: ELSE
3678: l_trolin_rec.transaction_header_id := inv_value_to_id.transaction_header(p_transaction_header => p_trolin_val_rec.transaction_header);
3679:

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

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

Line 3693: fnd_msg_pub.ADD;

3689:
3690: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3691: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3692: fnd_message.set_token('ATTRIBUTE', 'transaction_type');
3693: fnd_msg_pub.ADD;
3694: END IF;
3695: ELSE
3696: l_trolin_rec.transaction_type_id := inv_value_to_id.transaction_type(p_transaction_type => p_trolin_val_rec.transaction_type);
3697:

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

3705: IF p_trolin_val_rec.uom <> fnd_api.g_miss_char THEN
3706: IF p_trolin_rec.uom_code <> fnd_api.g_miss_char THEN
3707: l_trolin_rec.uom_code := p_trolin_rec.uom_code;
3708:
3709: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3710: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3711: fnd_message.set_token('ATTRIBUTE', 'uom');
3712: fnd_msg_pub.ADD;
3713: END IF;

Line 3712: fnd_msg_pub.ADD;

3708:
3709: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN
3710: fnd_message.set_name('INV', 'FND_BOTH_VAL_AND_ID_EXIST');
3711: fnd_message.set_token('ATTRIBUTE', 'uom');
3712: fnd_msg_pub.ADD;
3713: END IF;
3714: ELSE
3715: -- Line2917
3716: l_trolin_rec.uom_code := inv_value_to_id.uom(p_uom => p_trolin_val_rec.uom);