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 INV_KANBAN_PVT

Line 969: if l_source_type = inv_kanban_pvt.G_Source_Type_InterOrg then

965: FETCH c_inv_item into lr_inv_item;
966:
967: if lr_inv_item.inventory_item_id is not null then
968:
969: if l_source_type = inv_kanban_pvt.G_Source_Type_InterOrg then
970: --item is not inter org enabled and inter org source type selected
971: IF (NVL(lr_inv_item.internal_order_enabled_flag, 'N' ) <> 'Y' ) THEN
972: FND_MESSAGE.SET_NAME ( 'INV' , 'INV_ENTER_INTORD_ITEM' );
973: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 993: elsif l_source_type = inv_kanban_pvt.G_Source_Type_Supplier then

989: FND_MESSAGE.SET_NAME ( 'FLM' , 'FLM_INTERORG_ITEM' );
990: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
991: END IF;
992:
993: elsif l_source_type = inv_kanban_pvt.G_Source_Type_Supplier then
994: --if item is not purchase enabled and Supplier source type selected
995: IF (NVL(lr_inv_item.purchasing_enabled_flag, 'N' ) <> 'Y') THEN
996: FND_MESSAGE.SET_NAME ( 'FLM' , 'FLM_PURCHASE_ENABLED_ITEM' );
997: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1005: elsif l_source_type = inv_kanban_pvt.G_Source_Type_IntraOrg then

1001: FND_MESSAGE.SET_NAME ( 'INV' , 'INV_ENTER_PURCHASE_ITEM' );
1002: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1003: END IF;
1004:
1005: elsif l_source_type = inv_kanban_pvt.G_Source_Type_IntraOrg then
1006: --if the item is not transactable and source_type 'Intra-Org' is selected
1007: IF (NVL(lr_inv_item.mtl_transactions_enabled_flag, 'N' ) <> 'Y') THEN
1008: FND_MESSAGE.SET_NAME ( 'INV' , 'INV_ENTER_TRANSACT_ITEM' );
1009: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1012: elsif l_source_type = inv_kanban_pvt.G_Source_Type_Production then

1008: FND_MESSAGE.SET_NAME ( 'INV' , 'INV_ENTER_TRANSACT_ITEM' );
1009: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1010: END IF;
1011:
1012: elsif l_source_type = inv_kanban_pvt.G_Source_Type_Production then
1013: --if item is not production enabled and production source type selected
1014: IF (NVL(lr_inv_item.planning_make_buy_code, 0 ) <> 1 ) THEN
1015: FND_MESSAGE.SET_NAME ( 'INV' , 'INV_ENTER_MAKE_ITEM' );
1016: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1025: IF (lr_inv_item.reservable_type = 2 AND l_source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg

1021: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1022: end if;
1023:
1024: -- checking if item is a reservable item
1025: IF (lr_inv_item.reservable_type = 2 AND l_source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg
1026: ,inv_kanban_pvt.G_Source_Type_IntraOrg))
1027: THEN
1028: FND_MESSAGE.SET_NAME ('FLM' , 'FLM_NOT_RESERVABLE_ITEM');
1029: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1026: ,inv_kanban_pvt.G_Source_Type_IntraOrg))

1022: end if;
1023:
1024: -- checking if item is a reservable item
1025: IF (lr_inv_item.reservable_type = 2 AND l_source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg
1026: ,inv_kanban_pvt.G_Source_Type_IntraOrg))
1027: THEN
1028: FND_MESSAGE.SET_NAME ('FLM' , 'FLM_NOT_RESERVABLE_ITEM');
1029: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1030: END IF;

Line 1037: if l_source_type IN (INV_Kanban_PVT.G_Source_type_IntraOrg

1033: end if;
1034:
1035: -- Validate source subinventory and source org id
1036: -- if source type is inter or intra org
1037: if l_source_type IN (INV_Kanban_PVT.G_Source_type_IntraOrg
1038: ,INV_Kanban_PVT.G_Source_Type_InterOrg)
1039: then
1040:
1041: /*if p_pull_seq_rec.source_organization_id is null

Line 1038: ,INV_Kanban_PVT.G_Source_Type_InterOrg)

1034:
1035: -- Validate source subinventory and source org id
1036: -- if source type is inter or intra org
1037: if l_source_type IN (INV_Kanban_PVT.G_Source_type_IntraOrg
1038: ,INV_Kanban_PVT.G_Source_Type_InterOrg)
1039: then
1040:
1041: /*if p_pull_seq_rec.source_organization_id is null
1042: then

Line 1049: if l_source_type = INV_Kanban_PVT.G_Source_type_IntraOrg then

1045: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1046: else*/
1047:
1048: --Default Source org id as org id if intra org
1049: if l_source_type = INV_Kanban_PVT.G_Source_type_IntraOrg then
1050: p_pull_seq_rec.source_organization_id := p_pull_seq_rec.organization_id;
1051: end if;
1052:
1053: if p_pull_seq_rec.source_organization_id is not null then

Line 1135: if l_source_type = inv_kanban_pvt.G_Source_Type_Supplier then

1131: will not work because if supplier_id is the PRIMARY KEY in the table,
1132: there won't be a way to update supplier of existing pull sequence*/
1133:
1134: -- Supplier defaulting for pull sequence level
1135: if l_source_type = inv_kanban_pvt.G_Source_Type_Supplier then
1136:
1137: -- check if multiple suppliers exists for pull seq
1138: -- and updating supplier details at pull seq level
1139: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then

Line 1202: if l_source_type = inv_kanban_pvt.G_Source_Type_Production then

1198:
1199: end if;
1200:
1201: -- Validate wip line id only if source type is production
1202: if l_source_type = inv_kanban_pvt.G_Source_Type_Production then
1203: -- Fix bug 12433772, change the defaulting logic for wip_line_id
1204: /* Fix bug 12886421 , we need to call default_wip_line_id to bring up the correct line id even p_pull_seq_rec.wip_line_id is not null
1205: because p_pull_seq_rec.wip_line_id will always be defaulted to mkps.wip_line_id before come into here*/
1206: if p_pull_seq_rec.wip_line_code is not null then

Line 1384: if l_source_type = inv_kanban_pvt.G_Source_Type_Production and

1380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Consolidation');
1381: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1382: end if;
1383:
1384: if l_source_type = inv_kanban_pvt.G_Source_Type_Production and
1385: p_pull_seq_rec.consolidation = FLM_KANBAN_MASSLOAD.CONSOLIDATION_YES then
1386: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Consolidation');
1388: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1396: if l_source_type IN (INV_Kanban_PVT.G_Source_Type_Supplier

1392: -- calculate size is selected or that kanban size is not null if calculate
1393: -- cards has been entered.
1394: -----------------------------------------------------------------------
1395:
1396: if l_source_type IN (INV_Kanban_PVT.G_Source_Type_Supplier
1397: ,INV_Kanban_PVT.G_Source_Type_Production)
1398: then
1399: l_source_subinventory := p_pull_seq_rec.source_subinventory;
1400: end if;

Line 1397: ,INV_Kanban_PVT.G_Source_Type_Production)

1393: -- cards has been entered.
1394: -----------------------------------------------------------------------
1395:
1396: if l_source_type IN (INV_Kanban_PVT.G_Source_Type_Supplier
1397: ,INV_Kanban_PVT.G_Source_Type_Production)
1398: then
1399: l_source_subinventory := p_pull_seq_rec.source_subinventory;
1400: end if;
1401:

Line 1465: if l_source_type = INV_Kanban_PVT.G_Source_Type_InterOrg then

1461: mydebug('Default fields to null based on source type.');
1462: ------------------------------------------------------------
1463: -- Fields not allowed for insert/update based on source type
1464: ------------------------------------------------------------
1465: if l_source_type = INV_Kanban_PVT.G_Source_Type_InterOrg then
1466: p_pull_seq_rec.auto_allocate_flag := null;
1467: p_pull_seq_rec.supplier_id := null;
1468: p_pull_seq_rec.supplier_site_id := null;
1469: p_pull_seq_rec.wip_line_id := null;

Line 1470: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then

1466: p_pull_seq_rec.auto_allocate_flag := null;
1467: p_pull_seq_rec.supplier_id := null;
1468: p_pull_seq_rec.supplier_site_id := null;
1469: p_pull_seq_rec.wip_line_id := null;
1470: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
1471: p_pull_seq_rec.auto_allocate_flag := null;
1472: p_pull_seq_rec.source_organization_id := null;
1473: p_pull_seq_rec.source_subinventory := null;
1474: p_pull_seq_rec.source_locator_id := null;

Line 1476: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg then

1472: p_pull_seq_rec.source_organization_id := null;
1473: p_pull_seq_rec.source_subinventory := null;
1474: p_pull_seq_rec.source_locator_id := null;
1475: p_pull_seq_rec.wip_line_id := null;
1476: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg then
1477: p_pull_seq_rec.supplier_id := null;
1478: p_pull_seq_rec.supplier_site_id := null;
1479: p_pull_seq_rec.wip_line_id := null;
1480: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Production then

Line 1480: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Production then

1476: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_IntraOrg then
1477: p_pull_seq_rec.supplier_id := null;
1478: p_pull_seq_rec.supplier_site_id := null;
1479: p_pull_seq_rec.wip_line_id := null;
1480: elsif l_source_type = INV_Kanban_PVT.G_Source_Type_Production then
1481: p_pull_seq_rec.auto_allocate_flag := null;
1482: p_pull_seq_rec.supplier_id := null;
1483: p_pull_seq_rec.supplier_site_id := null;
1484: p_pull_seq_rec.source_organization_id := null;

Line 1745: AND MKC.card_status IN (INV_Kanban_PVT.G_Card_Status_Active, INV_Kanban_PVT.G_Card_Status_Hold);

1741: IS
1742: SELECT COUNT(MKC.kanban_card_id)
1743: FROM MTL_KANBAN_CARDS MKC
1744: WHERE MKC.pull_sequence_id = p_pull_sequence_id
1745: AND MKC.card_status IN (INV_Kanban_PVT.G_Card_Status_Active, INV_Kanban_PVT.G_Card_Status_Hold);
1746:
1747: --Cursor to validate Kanban Card Id
1748: CURSOR c_card_exist(p_kanban_card_id IN NUMBER)
1749: IS

Line 2061: r_kanban_card_rec.supply_status NOT IN (INV_Kanban_PVT.G_Supply_Status_New,INV_Kanban_PVT.G_Supply_Status_Full,INV_Kanban_PVT.G_Supply_Status_Empty)

2057: END IF;
2058:
2059: -- Validate supply status
2060: IF r_kanban_card_rec.supply_status IS NOT NULL AND
2061: r_kanban_card_rec.supply_status NOT IN (INV_Kanban_PVT.G_Supply_Status_New,INV_Kanban_PVT.G_Supply_Status_Full,INV_Kanban_PVT.G_Supply_Status_Empty)
2062: THEN
2063: fnd_message.set_name ('FLM','FLM_ATTRIBUTE_INVALID');
2064: fnd_message.set_token ('ATTRIBUTE', 'Supply Status');
2065: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;

Line 2069: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;

2065: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2066: END IF;
2067:
2068: IF r_kanban_card_rec.supply_status IS NULL THEN
2069: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
2070: END IF;
2071:
2072: -- Validate Card status
2073: IF r_kanban_card_rec.card_status IS NOT NULL AND

Line 2074: r_kanban_card_rec.card_status = INV_Kanban_PVT.G_Card_Status_Cancel THEN

2070: END IF;
2071:
2072: -- Validate Card status
2073: IF r_kanban_card_rec.card_status IS NOT NULL AND
2074: r_kanban_card_rec.card_status = INV_Kanban_PVT.G_Card_Status_Cancel THEN
2075: fnd_message.set_name ('FLM','FLM_ATTRIBUTE_INVALID');
2076: fnd_message.set_token ('ATTRIBUTE', 'Card Status');
2077: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2078: END IF;

Line 2081: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;

2077: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2078: END IF;
2079:
2080: IF r_kanban_card_rec.card_status IS NULL THEN
2081: r_kanban_card_rec.card_status := INV_Kanban_PVT.G_Card_Status_Active;
2082: END IF;
2083:
2084: IF r_kanban_card_rec.supplier_id IS NULL THEN
2085: r_kanban_card_rec.supplier_id := lr_pullseq_info.supplier_id;

Line 2173: /*IF l_supply_sts <> INV_Kanban_PVT.G_Supply_Status_New THEN

2169: END IF;
2170:
2171: --Fix bug 12426260, user can only delete card in cancel status
2172: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN
2173: /*IF l_supply_sts <> INV_Kanban_PVT.G_Supply_Status_New THEN
2174: fnd_message.set_name ('FLM','FLM_CANNOT_DELETE_CARD');
2175: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2176: END IF;*/
2177: IF l_card_sts <> INV_Kanban_PVT.G_Card_Status_Cancel THEN

Line 2177: IF l_card_sts <> INV_Kanban_PVT.G_Card_Status_Cancel THEN

2173: /*IF l_supply_sts <> INV_Kanban_PVT.G_Supply_Status_New THEN
2174: fnd_message.set_name ('FLM','FLM_CANNOT_DELETE_CARD');
2175: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2176: END IF;*/
2177: IF l_card_sts <> INV_Kanban_PVT.G_Card_Status_Cancel THEN
2178: fnd_message.set_name ('FLM','FLM_CANNOT_DELETE_CARD');
2179: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2180: END IF;
2181: END IF;

Line 2277: IF l_card_sts = INV_Kanban_PVT.G_Card_Status_Cancel THEN

2273: FROM MTL_KANBAN_CARDS MKC
2274: WHERE MKC.kanban_card_id = l_card_id;
2275: END IF;
2276:
2277: IF l_card_sts = INV_Kanban_PVT.G_Card_Status_Cancel THEN
2278: fnd_message.set_name ('FLM','FLM_CANNOT_UPDATE_CARD');
2279: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2280: END IF;
2281:

Line 2367: IF r_kanban_card_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier THEN

2363: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2364: END IF;
2365: END IF;
2366:
2367: IF r_kanban_card_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier THEN
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

Line 2419: IF r_kanban_card_rec.source_type IN (inv_kanban_pvt.g_source_type_intraorg

2415: END IF;
2416:
2417: -- Validate source subinventory and source org id
2418: -- if source type is inter or intra org
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

Line 2420: ,inv_kanban_pvt.g_source_type_interorg)

2416:
2417: -- Validate source subinventory and source org id
2418: -- if source type is inter or intra org
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');

Line 2482: IF r_kanban_card_rec.source_type = inv_kanban_pvt.g_source_type_production THEN

2478: mydebug(fnd_message.get);
2479: END IF;
2480: END IF;--end if for source type
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

Line 2563: --r_card_tab_rec inv_kanban_pvt.kanban_card_rec_type;

2559: ,x_ret_status OUT NOCOPY VARCHAR2
2560: ,x_err_msg OUT NOCOPY VARCHAR2
2561: )
2562: IS
2563: --r_card_tab_rec inv_kanban_pvt.kanban_card_rec_type;
2564: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
2565: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
2566: -- l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type; This is not required
2567: l_report_id NUMBER := NULL;

Line 2565: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;

2561: )
2562: IS
2563: --r_card_tab_rec inv_kanban_pvt.kanban_card_rec_type;
2564: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
2565: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
2566: -- l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type; This is not required
2567: l_report_id NUMBER := NULL;
2568: l_no_of_cards NUMBER := 1;
2569: l_release_kanban_flag NUMBER;

Line 2566: -- l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type; This is not required

2562: IS
2563: --r_card_tab_rec inv_kanban_pvt.kanban_card_rec_type;
2564: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;
2565: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
2566: -- l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type; This is not required
2567: l_report_id NUMBER := NULL;
2568: l_no_of_cards NUMBER := 1;
2569: l_release_kanban_flag NUMBER;
2570: l_print_kanban_card NUMBER := 0;

Line 2607: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;

2603: END IF;
2604:
2605:
2606: IF r_kanban_card_rec.supply_status IS NULL THEN
2607: r_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_New;
2608: END IF;
2609:
2610: -- This is not required
2611: /*

Line 2632: INV_kanban_PVT.create_kanban_cards(l_ret_status,

2628:
2629: mydebug('Calling INVKBCGN.card_check_and_create');
2630: -- This API doesn't allow us to create cards in Plan Status from Planning. Also card doesn't get created in 'Onhold' status.
2631: /*
2632: INV_kanban_PVT.create_kanban_cards(l_ret_status,
2633: l_kanban_card_ids,
2634: l_pull_seq_rec,
2635: r_kanban_card_rec.supply_status,
2636: r_kanban_card_rec.kanban_card_id,

Line 2646: r_kanban_card_rec.card_status := INV_Kanban_Pvt.G_Card_Status_Hold;

2642: );
2643: */
2644:
2645: IF l_release_kanban_flag = 2 THEN
2646: r_kanban_card_rec.card_status := INV_Kanban_Pvt.G_Card_Status_Hold;
2647: r_kanban_card_rec.supply_status := inv_kanban_pvt.g_supply_status_full;
2648: END IF;
2649:
2650: -- Default it from Custom Hook

Line 2647: r_kanban_card_rec.supply_status := inv_kanban_pvt.g_supply_status_full;

2643: */
2644:
2645: IF l_release_kanban_flag = 2 THEN
2646: r_kanban_card_rec.card_status := INV_Kanban_Pvt.G_Card_Status_Hold;
2647: r_kanban_card_rec.supply_status := inv_kanban_pvt.g_supply_status_full;
2648: END IF;
2649:
2650: -- Default it from Custom Hook
2651: if r_kanban_card_rec.kanban_card_number is null then

Line 2683: P_Kanban_Card_Type => Nvl(r_kanban_card_rec.kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable),

2679: P_Organization_id => r_kanban_card_rec.organization_id,
2680: P_Subinventory_name => r_kanban_card_rec.subinventory_name,
2681: P_Supply_Status => r_kanban_card_rec.supply_status,
2682: P_Card_Status => r_kanban_card_rec.card_status,
2683: P_Kanban_Card_Type => Nvl(r_kanban_card_rec.kanban_card_type,INV_Kanban_Pvt.g_card_type_replenishable),
2684: P_Source_type => r_kanban_card_rec.Source_type,
2685: P_Kanban_size => nvl(r_kanban_card_rec.Kanban_size,0),
2686: P_Last_Update_Date => SYSDATE,
2687: P_Last_Updated_By => FND_GLOBAL.USER_ID,

Line 2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');

2733: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
2734: Raise FND_API.G_EXC_ERROR;
2735: END IF;
2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');
2738: l_error_msg := 'Unexpected error after INV_kanban_PVT.create_kanban_cards ';
2739: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2740: END IF;
2741: -- r_kanban_card_rec.kanban_card_id := l_kanban_card_ids(1);

Line 2738: l_error_msg := 'Unexpected error after INV_kanban_PVT.create_kanban_cards ';

2734: Raise FND_API.G_EXC_ERROR;
2735: END IF;
2736: IF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2737: mydebug('Unexpected error after INV_kanban_PVT.create_kanban_cards');
2738: l_error_msg := 'Unexpected error after INV_kanban_PVT.create_kanban_cards ';
2739: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2740: END IF;
2741: -- r_kanban_card_rec.kanban_card_id := l_kanban_card_ids(1);
2742:

Line 3314: l_Pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type;

3310: ,x_ret_status OUT NOCOPY VARCHAR2
3311: ,x_error_msg OUT NOCOPY VARCHAR2)
3312: IS
3313: r_pull_seq_rec flm_ekanban_pub.pull_sequence_rec_type;
3314: l_Pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type;
3315: l_ret_status VARCHAR2(1);
3316: l_error_msg VARCHAR2(4000);
3317: BEGIN
3318:

Line 3966: if p_pull_sequence_rec.source_type = inv_kanban_pvt.G_Source_Type_Supplier then

3962: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;
3963: p_pull_sequence_rec.source_type := l_source_type;
3964: end if;
3965:
3966: if p_pull_sequence_rec.source_type = inv_kanban_pvt.G_Source_Type_Supplier then
3967:
3968: -- call process_suppliers procedure to Process multiple suppliers
3969: FOR i IN 1..l_supplier_count LOOP
3970:

Line 4029: elsif p_pull_sequence_rec.source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg,

4025: ,supplier_site_id = null
4026: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;
4027: end if;
4028:
4029: elsif p_pull_sequence_rec.source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg,
4030: inv_kanban_pvt.G_Source_Type_IntraOrg,
4031: inv_kanban_pvt.G_Source_Type_Production) then
4032: if l_supplier_count > 0 then
4033: l_ret_status := FND_API.G_RET_STS_ERROR;

Line 4030: inv_kanban_pvt.G_Source_Type_IntraOrg,

4026: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;
4027: end if;
4028:
4029: elsif p_pull_sequence_rec.source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg,
4030: inv_kanban_pvt.G_Source_Type_IntraOrg,
4031: inv_kanban_pvt.G_Source_Type_Production) then
4032: if l_supplier_count > 0 then
4033: l_ret_status := FND_API.G_RET_STS_ERROR;
4034: FND_MESSAGE.SET_NAME('FLM','FLM_NO_SUPPLIERS_REQUIRED');

Line 4031: inv_kanban_pvt.G_Source_Type_Production) then

4027: end if;
4028:
4029: elsif p_pull_sequence_rec.source_type IN (inv_kanban_pvt.G_Source_Type_InterOrg,
4030: inv_kanban_pvt.G_Source_Type_IntraOrg,
4031: inv_kanban_pvt.G_Source_Type_Production) then
4032: if l_supplier_count > 0 then
4033: l_ret_status := FND_API.G_RET_STS_ERROR;
4034: FND_MESSAGE.SET_NAME('FLM','FLM_NO_SUPPLIERS_REQUIRED');
4035: l_error_msg := x_error_msg || FND_CONST.NEWLINE||FND_MESSAGE.GET;