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.FLM_KANBAN_PUB dependencies on FLM_KANBAN_PUB

Line 1: PACKAGE BODY FLM_KANBAN_PUB AS

1: PACKAGE BODY FLM_KANBAN_PUB AS
2: /* $Header: FLMKBNPB.pls 120.16.12020000.3 2012/08/09 12:19:56 akuppa ship $ */
3:
4: --global variables
5: g_user_id number := fnd_global.user_id;

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_KANBAN_PUB';

6: g_user_login_id number := fnd_global.login_id;
7: g_last_update_date date := sysdate;
8: g_creation_date date := sysdate;
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'FLM_KANBAN_PUB';
11:
12:
13: PROCEDURE mydebug(msg IN VARCHAR2) IS
14: BEGIN

Line 15: inv_log_util.trace(msg, 'FLM_KANBAN_PUB', 9);

11:
12:
13: PROCEDURE mydebug(msg IN VARCHAR2) IS
14: BEGIN
15: inv_log_util.trace(msg, 'FLM_KANBAN_PUB', 9);
16: END mydebug;
17:
18: -- private funtion to get pull sequence id
19: FUNCTION get_pull_sequence_id (p_invitem_id IN mtl_kanban_pull_sequences.inventory_item_id%TYPE

Line 1816: r_kanban_card_rec.organization_id := FLM_KANBAN_PUB.default_org_id(r_kanban_card_rec.organization_code);

1812: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_REQUIRED');
1813: fnd_message.set_token ('ATTRIBUTE', 'Organization');
1814: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1815: ELSE
1816: r_kanban_card_rec.organization_id := FLM_KANBAN_PUB.default_org_id(r_kanban_card_rec.organization_code);
1817: IF r_kanban_card_rec.organization_id IS NULL THEN
1818: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
1819: fnd_message.set_token ('ATTRIBUTE', 'Organization Code');
1820: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;

Line 1824: IF FLM_KANBAN_PUB.is_org_id_invalid (r_kanban_card_rec.organization_id) THEN

1820: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1821: END IF;
1822: END IF;
1823: ELSE
1824: IF FLM_KANBAN_PUB.is_org_id_invalid (r_kanban_card_rec.organization_id) THEN
1825: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
1826: fnd_message.set_token ('ATTRIBUTE', 'Organization Id');
1827: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1828: END IF;

Line 1838: r_kanban_card_rec.inventory_item_id := FLM_KANBAN_PUB.default_inv_item_id(p_org_id => r_kanban_card_rec.organization_id

1834: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_REQUIRED');
1835: fnd_message.set_token ('ATTRIBUTE', 'Inventory Item');
1836: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1837: ELSE
1838: r_kanban_card_rec.inventory_item_id := FLM_KANBAN_PUB.default_inv_item_id(p_org_id => r_kanban_card_rec.organization_id
1839: ,p_conc_segments => r_kanban_card_rec.inventory_item_code);
1840: IF r_kanban_card_rec.inventory_item_id IS NULL THEN
1841: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
1842: fnd_message.set_token ('ATTRIBUTE', 'Inventory Item Name');

Line 2140: r_kanban_card_rec.kanban_card_id := FLM_KANBAN_PUB.default_kanban_card_id(p_pull_sequence_id => r_kanban_card_rec.pull_sequence_id

2136: fnd_message.set_token ('ATTRIBUTE', 'Kanban Card');
2137: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2138: ELSE
2139: IF r_kanban_card_rec.pull_sequence_id IS NOT NULL THEN
2140: r_kanban_card_rec.kanban_card_id := FLM_KANBAN_PUB.default_kanban_card_id(p_pull_sequence_id => r_kanban_card_rec.pull_sequence_id
2141: ,p_kanban_card_number => r_kanban_card_rec.kanban_card_number);
2142: IF r_kanban_card_rec.kanban_card_id IS NULL THEN
2143: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
2144: fnd_message.set_token ('ATTRIBUTE', 'Pull Sequence Id / Kanban card Number');

Line 2372: r_kanban_card_rec.supplier_id := FLM_KANBAN_PUB.default_supplier_id(p_supplier_name => r_kanban_card_rec.supplier_name);

2368: --Validate Supplier
2369: IF lr_pullseq_info.supplier_id IS NULL THEN
2370: IF r_kanban_card_rec.supplier_id IS NULL THEN
2371: IF r_kanban_card_rec.supplier_name IS NOT NULL THEN
2372: r_kanban_card_rec.supplier_id := FLM_KANBAN_PUB.default_supplier_id(p_supplier_name => r_kanban_card_rec.supplier_name);
2373: END IF;
2374: ELSE
2375: IF is_supplier_id_invalid(p_supplier_id => r_kanban_card_rec.supplier_id) THEN
2376: fnd_message.set_name ('FLM','FLM_ATTRIBUTE_INVALID');

Line 2390: r_kanban_card_rec.supplier_site_id := FLM_KANBAN_PUB.default_supplier_site_id(p_supplier_id => r_kanban_card_rec.supplier_id

2386: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_REQUIRED');
2387: fnd_message.set_token ('ATTRIBUTE', 'Supplier Site');
2388: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2389: ELSE
2390: r_kanban_card_rec.supplier_site_id := FLM_KANBAN_PUB.default_supplier_site_id(p_supplier_id => r_kanban_card_rec.supplier_id
2391: ,p_supplier_site_code => r_kanban_card_rec.supplier_site_code
2392: ,p_org_id => r_kanban_card_rec.organization_id
2393: );
2394: END IF;

Line 2423: IF FLM_KANBAN_PUB.is_org_id_invalid (r_kanban_card_rec.source_organization_id) THEN

2419: IF r_kanban_card_rec.source_type IN (inv_kanban_pvt.g_source_type_intraorg
2420: ,inv_kanban_pvt.g_source_type_interorg)
2421: THEN
2422: IF r_kanban_card_rec.source_organization_id IS NOT NULL AND lr_pullseq_info.source_organization_id IS NULL THEN
2423: IF FLM_KANBAN_PUB.is_org_id_invalid (r_kanban_card_rec.source_organization_id) THEN
2424: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
2425: fnd_message.set_token ('ATTRIBUTE', 'Source Organization Id');
2426: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2427: ELSE

Line 2485: r_kanban_card_rec.wip_line_id := FLM_KANBAN_PUB.default_wip_line_id(p_wip_line_code => r_kanban_card_rec.wip_line_code

2481: -- Validate wip line id only if source type is production
2482: IF r_kanban_card_rec.source_type = inv_kanban_pvt.g_source_type_production THEN
2483: IF r_kanban_card_rec.wip_line_id IS NULL AND lr_pullseq_info.wip_line_id IS NULL THEN
2484: IF r_kanban_card_rec.wip_line_code IS NOT NULL AND r_kanban_card_rec.wip_line_code <> FND_API.G_MISS_CHAR THEN
2485: r_kanban_card_rec.wip_line_id := FLM_KANBAN_PUB.default_wip_line_id(p_wip_line_code => r_kanban_card_rec.wip_line_code
2486: ,p_org_id => r_kanban_card_rec.organization_id
2487: );
2488: IF r_kanban_card_rec.wip_line_id IS NULL THEN
2489: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');

Line 2926: mydebug('In Procedure FLM_KANBAN_PUB.process_cards');

2922: l_release_kanban_flag NUMBER;
2923: l_ret_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
2924: l_err_msg VARCHAR2(2000);
2925: BEGIN
2926: mydebug('In Procedure FLM_KANBAN_PUB.process_cards');
2927: mydebug('Assigning values to record type variable ');
2928:
2929: r_kanban_card_rec.pull_sequence_id := p_pull_sequence_id;
2930: r_kanban_card_rec.kanban_card_id := p_kanban_card_id;

Line 3140: mydebug('In Procedure FLM_KANBAN_PUB.process_kc');

3136: l_ret_status VARCHAR2(1);
3137: l_err_msg VARCHAR2(2000);
3138: l_count NUMBER := 0;
3139: BEGIN
3140: mydebug('In Procedure FLM_KANBAN_PUB.process_kc');
3141:
3142: FOR i IN p_card_int_tbl.first..p_card_int_tbl.last
3143: LOOP
3144:

Line 4511: END FLM_KANBAN_PUB;

4507: when others then
4508: return null;
4509: end default_kanban_card_id;
4510:
4511: END FLM_KANBAN_PUB;