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_MASSLOAD

Line 604: elsif p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,

600: if p_transaction_type is null then
601: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Transaction Type');
603: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
604: elsif p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
605: FLM_KANBAN_MASSLOAD.kanban_change,
606: FLM_KANBAN_MASSLOAD.kanban_delete)
607: then
608: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

Line 605: FLM_KANBAN_MASSLOAD.kanban_change,

601: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Transaction Type');
603: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
604: elsif p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
605: FLM_KANBAN_MASSLOAD.kanban_change,
606: FLM_KANBAN_MASSLOAD.kanban_delete)
607: then
608: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Transaction Type');

Line 606: FLM_KANBAN_MASSLOAD.kanban_delete)

602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Transaction Type');
603: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
604: elsif p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
605: FLM_KANBAN_MASSLOAD.kanban_change,
606: FLM_KANBAN_MASSLOAD.kanban_delete)
607: then
608: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Transaction Type');
610: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 653: IF l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add THEN

649: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
650: end if;
651:
652: -- Validate pull sequence
653: IF l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add THEN
654:
655: l_pullseq_id := get_pull_sequence_id(p_pull_seq_rec.inventory_item_id,
656: p_pull_seq_rec.organization_id,
657: FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN,

Line 657: FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN,

653: IF l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add THEN
654:
655: l_pullseq_id := get_pull_sequence_id(p_pull_seq_rec.inventory_item_id,
656: p_pull_seq_rec.organization_id,
657: FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN,
658: p_pull_seq_rec.subinventory_name,
659: p_pull_seq_rec.locator_id);
660:
661: -- if pull sequence already exists or pull_sequence_id is already used

Line 684: ELSIF l_transaction_type IN (FLM_KANBAN_MASSLOAD.kanban_change,

680: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
681:
682: END IF;
683:
684: ELSIF l_transaction_type IN (FLM_KANBAN_MASSLOAD.kanban_change,
685: FLM_KANBAN_MASSLOAD.kanban_delete) THEN
686:
687: IF p_pull_seq_rec.pull_sequence_id IS NULL THEN
688: l_pullseq_id := get_pull_sequence_id(p_pull_seq_rec.inventory_item_id,

Line 685: FLM_KANBAN_MASSLOAD.kanban_delete) THEN

681:
682: END IF;
683:
684: ELSIF l_transaction_type IN (FLM_KANBAN_MASSLOAD.kanban_change,
685: FLM_KANBAN_MASSLOAD.kanban_delete) THEN
686:
687: IF p_pull_seq_rec.pull_sequence_id IS NULL THEN
688: l_pullseq_id := get_pull_sequence_id(p_pull_seq_rec.inventory_item_id,
689: p_pull_seq_rec.organization_id,

Line 690: FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN,

686:
687: IF p_pull_seq_rec.pull_sequence_id IS NULL THEN
688: l_pullseq_id := get_pull_sequence_id(p_pull_seq_rec.inventory_item_id,
689: p_pull_seq_rec.organization_id,
690: FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN,
691: p_pull_seq_rec.subinventory_name,
692: p_pull_seq_rec.locator_id);
693: p_pull_seq_rec.pull_sequence_id := l_pullseq_id;
694: ELSIF is_valid_pull_sequence_id(p_pull_seq_rec.pull_sequence_id) THEN

Line 724: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change and l_pullseq_id is not null then

720: END IF;
721:
722: -- Default pull sequence values while updating..
723:
724: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change and l_pullseq_id is not null then
725:
726: SELECT
727: mkps.pull_sequence_id
728: ,mkps.creation_date

Line 839: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add then

835: end if;
836:
837: mydebug('Validating mandatory fields.');
838:
839: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add then
840:
841: -- validate organization
842: IF p_pull_seq_rec.organization_id IS NULL AND
843: p_pull_seq_rec.organization_code IS NULL

Line 908: IF l_locator_control <> FLM_KANBAN_MASSLOAD.LOCATOR_NONE AND

904: p_pull_seq_rec.organization_id,
905: p_pull_seq_rec.subinventory_name);
906:
907: -- Validate locator
908: IF l_locator_control <> FLM_KANBAN_MASSLOAD.LOCATOR_NONE AND
909: p_pull_seq_rec.locator_id IS NULL
910: THEN
911: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
912: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Locator');

Line 930: /*if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then

926: end if; -- l_transaction_type = kanban_add
927:
928: -- Validate the Source Type - Inter Org, Intra Org, Supplier, Production
929:
930: /*if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then
931: open c_pull_seq_data(p_invitem_id => p_pull_seq_rec.inventory_item_id
932: ,p_org_id => p_pull_seq_rec.organization_id
933: ,p_kan_plan_id => FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN
934: ,p_sub_name => p_pull_seq_rec.subinventory_name

Line 933: ,p_kan_plan_id => FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN

929:
930: /*if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then
931: open c_pull_seq_data(p_invitem_id => p_pull_seq_rec.inventory_item_id
932: ,p_org_id => p_pull_seq_rec.organization_id
933: ,p_kan_plan_id => FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN
934: ,p_sub_name => p_pull_seq_rec.subinventory_name
935: ,p_loc_id => p_pull_seq_rec.locator_id );
936:
937: fetch c_pull_seq_data into lr_pull_seq_data;

Line 947: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change and

943: then
944: l_source_type := p_pull_seq_rec.source_type;
945: end if;
946:
947: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change and
948: p_pull_seq_rec.source_type is null
949: then
950: l_source_type := lr_pull_seq_data.source_type;
951: end if;*/

Line 954: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.kanban_add,FLM_KANBAN_MASSLOAD.kanban_change) then

950: l_source_type := lr_pull_seq_data.source_type;
951: end if;*/
952:
953:
954: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.kanban_add,FLM_KANBAN_MASSLOAD.kanban_change) then
955:
956: -- Validate the Source Type - Inter Org, Intra Org, Supplier, Production
957: if is_lookup_code_valid(p_lookup_type => 'MTL_KANBAN_SOURCE_TYPE'
958: ,p_lookup_code => p_pull_seq_rec.source_type)

Line 1082: IF l_source_locator_control <> FLM_KANBAN_MASSLOAD.LOCATOR_NONE AND

1078: p_pull_seq_rec.source_organization_id,
1079: p_pull_seq_rec.source_subinventory);
1080:
1081: -- Validate source locator
1082: IF l_source_locator_control <> FLM_KANBAN_MASSLOAD.LOCATOR_NONE AND
1083: p_pull_seq_rec.source_locator_id IS NULL
1084: THEN
1085: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
1086: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Source Locator');

Line 1139: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then

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
1140: DECLARE
1141: l_count number;
1142: BEGIN
1143: SELECT COUNT(*)

Line 1309: if trunc(nvl(p_pull_seq_rec.planning_effectivity,sysdate+2)) <= trunc(SYSDATE) and l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add then

1305:
1306: mydebug('Validation of additonal fields.');
1307:
1308: -- Planning effectivity. Changes for Bug 12615810.
1309: if trunc(nvl(p_pull_seq_rec.planning_effectivity,sysdate+2)) <= trunc(SYSDATE) and l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add then
1310: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Planning effectivity');
1312: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1313: end if;

Line 1316: if trunc(nvl(p_pull_seq_rec.planning_effectivity,sysdate+2)) <= trunc(SYSDATE) and l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then

1312: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1313: end if;
1314:
1315: -- Make Future effective current if it's currently effective. Changes for Bug 12615810.
1316: if trunc(nvl(p_pull_seq_rec.planning_effectivity,sysdate+2)) <= trunc(SYSDATE) and l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then
1317: p_pull_seq_rec.planning_effectivity := null;
1318: if nvl(p_pull_seq_rec.number_of_cards,-1) = nvl(l_no_of_cards,-1) then
1319: p_pull_seq_rec.number_of_cards := nvl(p_pull_seq_rec.future_no_of_cards,p_pull_seq_rec.number_of_cards);
1320: end if;

Line 1359: p_pull_seq_rec.replenishment_type := FLM_KANBAN_MASSLOAD.PHYSICAL;

1355: end if;
1356:
1357: -- Replenishment Type
1358: if p_pull_seq_rec.replenishment_type is null then
1359: p_pull_seq_rec.replenishment_type := FLM_KANBAN_MASSLOAD.PHYSICAL;
1360: else
1361: --if not is_lookup_code_valid(p_lookup_type => 'MTL_KANBAN_REPLENISHMENT_TYPE'
1362: -- ,p_lookup_code => p_pull_seq_rec.replenishment_type)
1363: if p_pull_seq_rec.replenishment_type NOT IN (FLM_KANBAN_MASSLOAD.PHYSICAL

Line 1363: if p_pull_seq_rec.replenishment_type NOT IN (FLM_KANBAN_MASSLOAD.PHYSICAL

1359: p_pull_seq_rec.replenishment_type := FLM_KANBAN_MASSLOAD.PHYSICAL;
1360: else
1361: --if not is_lookup_code_valid(p_lookup_type => 'MTL_KANBAN_REPLENISHMENT_TYPE'
1362: -- ,p_lookup_code => p_pull_seq_rec.replenishment_type)
1363: if p_pull_seq_rec.replenishment_type NOT IN (FLM_KANBAN_MASSLOAD.PHYSICAL
1364: ,FLM_KANBAN_MASSLOAD.LOGICAL)
1365: then
1366: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1367: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Replenishment Type');

Line 1364: ,FLM_KANBAN_MASSLOAD.LOGICAL)

1360: else
1361: --if not is_lookup_code_valid(p_lookup_type => 'MTL_KANBAN_REPLENISHMENT_TYPE'
1362: -- ,p_lookup_code => p_pull_seq_rec.replenishment_type)
1363: if p_pull_seq_rec.replenishment_type NOT IN (FLM_KANBAN_MASSLOAD.PHYSICAL
1364: ,FLM_KANBAN_MASSLOAD.LOGICAL)
1365: then
1366: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1367: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Replenishment Type');
1368: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1375: p_pull_seq_rec.consolidation := FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO;

1371: end if;
1372:
1373: -- Consolidation
1374: if p_pull_seq_rec.consolidation is null then
1375: p_pull_seq_rec.consolidation := FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO;
1376: elsif p_pull_seq_rec.consolidation NOT IN (FLM_KANBAN_MASSLOAD.CONSOLIDATION_YES,
1377: FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO)
1378: then
1379: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

Line 1376: elsif p_pull_seq_rec.consolidation NOT IN (FLM_KANBAN_MASSLOAD.CONSOLIDATION_YES,

1372:
1373: -- Consolidation
1374: if p_pull_seq_rec.consolidation is null then
1375: p_pull_seq_rec.consolidation := FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO;
1376: elsif p_pull_seq_rec.consolidation NOT IN (FLM_KANBAN_MASSLOAD.CONSOLIDATION_YES,
1377: FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO)
1378: then
1379: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Consolidation');

Line 1377: FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO)

1373: -- Consolidation
1374: if p_pull_seq_rec.consolidation is null then
1375: p_pull_seq_rec.consolidation := FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO;
1376: elsif p_pull_seq_rec.consolidation NOT IN (FLM_KANBAN_MASSLOAD.CONSOLIDATION_YES,
1377: FLM_KANBAN_MASSLOAD.CONSOLIDATION_NO)
1378: then
1379: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
1380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Consolidation');
1381: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 1385: p_pull_seq_rec.consolidation = FLM_KANBAN_MASSLOAD.CONSOLIDATION_YES then

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;
1389: end if;

Line 1402: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change and

1398: then
1399: l_source_subinventory := p_pull_seq_rec.source_subinventory;
1400: end if;
1401:
1402: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change and
1403: l_pullseq_id IS NOT NULL
1404: then
1405: OPEN c_pull_seq_calc(p_pull_seq_rec.kanban_size
1406: ,l_calculate_kanban_flag

Line 1417: l_transaction_type in (FLM_KANBAN_MASSLOAD.kanban_add,FLM_KANBAN_MASSLOAD.kanban_change)

1413: CLOSE c_pull_seq_calc;
1414: end if;
1415:
1416: if p_pull_seq_rec.calculate_kanban_flag IS NOT NULL and
1417: l_transaction_type in (FLM_KANBAN_MASSLOAD.kanban_add,FLM_KANBAN_MASSLOAD.kanban_change)
1418: then
1419: if p_pull_seq_rec.calculate_kanban_flag IN (1, 2, 3) then
1420: l_calculate_kanban_flag := p_pull_seq_rec.calculate_kanban_flag;
1421: else

Line 1427: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add then

1423: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Calculate Kanban Flag');
1424: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1425: end if;
1426:
1427: if l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add then
1428: lr_pull_seq_calc.kanban_size := p_pull_seq_rec.kanban_size;
1429: lr_pull_seq_calc.calculate_kanban_flag:= l_calculate_kanban_flag;
1430: lr_pull_seq_calc.number_of_cards := p_pull_seq_rec.number_of_cards;
1431: lr_pull_seq_calc.release_kanban_flag := p_pull_seq_rec.release_kanban_flag;

Line 1448: elsif (l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add and

1444: FND_MESSAGE.SET_NAME ('FLM', 'FLM_ATTRIBUTE_REQUIRED');
1445: FND_MESSAGE.SET_TOKEN ('ATTRIBUTE', 'KANBAN_SIZE');
1446: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
1447: end if;
1448: elsif (l_transaction_type = FLM_KANBAN_MASSLOAD.kanban_add and
1449: p_pull_seq_rec.calculate_kanban_flag IS NULL) then
1450: if (lr_pull_seq_calc.kanban_size IS NULL and
1451: lr_pull_seq_calc.number_of_cards IS NULL) then
1452: l_calculate_kanban_flag := 3;

Line 1506: PROCEDURE process_ps(p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type

1502:
1503: -----------------------
1504: --procedure process_ps
1505: -----------------------
1506: PROCEDURE process_ps(p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type
1507: ,p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type
1508: ,x_ret_status OUT NOCOPY VARCHAR2
1509: )
1510: IS

Line 1507: ,p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type

1503: -----------------------
1504: --procedure process_ps
1505: -----------------------
1506: PROCEDURE process_ps(p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type
1507: ,p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type
1508: ,x_ret_status OUT NOCOPY VARCHAR2
1509: )
1510: IS
1511:

Line 1630: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;

1626: ,x_error_msg => l_error_msg);
1627:
1628: if l_ret_status = FND_API.G_RET_STS_SUCCESS then
1629: p_pull_sequence_tbl(i).pull_sequence_id := r_pull_seq_rec.pull_sequence_id;
1630: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;
1631: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1632: ' was processed successfully . ');
1633: /* elsif l_ret_status = 'W' then
1634: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;

Line 1634: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;

1630: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;
1631: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1632: ' was processed successfully . ');
1633: /* elsif l_ret_status = 'W' then
1634: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;
1635: p_pull_sequence_tbl(i).error_text := l_error_msg;*/
1636: elsif l_ret_status = FND_API.G_RET_STS_ERROR then
1637: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
1638: p_pull_sequence_tbl(i).error_text := l_error_msg;

Line 1637: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;

1633: /* elsif l_ret_status = 'W' then
1634: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;
1635: p_pull_sequence_tbl(i).error_text := l_error_msg;*/
1636: elsif l_ret_status = FND_API.G_RET_STS_ERROR then
1637: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
1638: p_pull_sequence_tbl(i).error_text := l_error_msg;
1639: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1640: ' failed due to following : '|| l_error_msg );
1641: else

Line 1642: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;

1638: p_pull_sequence_tbl(i).error_text := l_error_msg;
1639: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1640: ' failed due to following : '|| l_error_msg );
1641: else
1642: p_pull_sequence_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
1643: p_pull_sequence_tbl(i).error_text := l_error_msg;
1644: fnd_file.put_line(fnd_file.log,' Pull Sequence details with Interface Id : '|| p_pull_sequence_tbl(i).interface_id ||
1645: ' failed due to following : '|| l_error_msg );
1646: end if;

Line 1793: ELSIF p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,

1789: IF p_transaction_type IS NULL THEN
1790: fnd_message.set_name('FLM','FLM_ATTRIBUTE_REQUIRED');
1791: fnd_message.set_token('ATTRIBUTE','Transaction Type');
1792: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1793: ELSIF p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
1794: FLM_KANBAN_MASSLOAD.kanban_change,
1795: FLM_KANBAN_MASSLOAD.kanban_delete)
1796: THEN
1797: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');

Line 1794: FLM_KANBAN_MASSLOAD.kanban_change,

1790: fnd_message.set_name('FLM','FLM_ATTRIBUTE_REQUIRED');
1791: fnd_message.set_token('ATTRIBUTE','Transaction Type');
1792: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1793: ELSIF p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
1794: FLM_KANBAN_MASSLOAD.kanban_change,
1795: FLM_KANBAN_MASSLOAD.kanban_delete)
1796: THEN
1797: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
1798: fnd_message.set_token ('ATTRIBUTE', 'Transaction Type');

Line 1795: FLM_KANBAN_MASSLOAD.kanban_delete)

1791: fnd_message.set_token('ATTRIBUTE','Transaction Type');
1792: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
1793: ELSIF p_transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
1794: FLM_KANBAN_MASSLOAD.kanban_change,
1795: FLM_KANBAN_MASSLOAD.kanban_delete)
1796: THEN
1797: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_INVALID');
1798: fnd_message.set_token ('ATTRIBUTE', 'Transaction Type');
1799: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;

Line 1913: IF l_locator_control <> FLM_KANBAN_MASSLOAD.locator_none THEN

1909: r_kanban_card_rec.organization_id,
1910: r_kanban_card_rec.subinventory_name);
1911:
1912: -- Validate locator_id
1913: IF l_locator_control <> FLM_KANBAN_MASSLOAD.locator_none THEN
1914: -- mandatory if subinventory is locator controlled
1915: IF r_kanban_card_rec.locator_id IS NULL THEN
1916: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_REQUIRED');
1917: fnd_message.set_token ('ATTRIBUTE', 'Locator Id');

Line 1944: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD THEN

1940: END IF; --End Subinventory Name
1941: END IF;
1942:
1943: --Fix bug 12430551
1944: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD THEN
1945: IF r_kanban_card_rec.pull_sequence_id IS NULL THEN
1946: /************************/
1947: --Derive Pull sequence id
1948: /************************/

Line 2121: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE OR

2117: r_kanban_card_rec.current_replnsh_cycle_id := null;
2118:
2119: END IF; --For p_transaction_type ADD
2120:
2121: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE OR
2122: l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN
2123:
2124: --Fix bug 12430551, derive pull sequence id if it's null
2125: IF r_kanban_card_rec.pull_sequence_id IS NULL THEN

Line 2122: l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN

2118:
2119: END IF; --For p_transaction_type ADD
2120:
2121: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE OR
2122: l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN
2123:
2124: --Fix bug 12430551, derive pull sequence id if it's null
2125: IF r_kanban_card_rec.pull_sequence_id IS NULL THEN
2126: r_kanban_card_rec.pull_sequence_id := get_pull_sequence_id(p_invitem_id => r_kanban_card_rec.inventory_item_id

Line 2172: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN

2168: END IF;
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;*/

Line 2183: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN

2179: p_error_text := p_error_text || FND_CONST.NEWLINE || FND_MESSAGE.GET;
2180: END IF;
2181: END IF;
2182:
2183: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2184:
2185: IF l_card_id IS NOT NULL AND l_card_id <> 0 THEN
2186: -- Default kanban card values while updating..
2187: SELECT MKC.kanban_card_id

Line 2308: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD

2304: END IF;
2305: END IF;
2306:
2307:
2308: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD
2309: OR l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2310:
2311: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2312: lr_pullseq_info.supplier_id := NULL;

Line 2309: OR l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN

2305: END IF;
2306:
2307:
2308: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD
2309: OR l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2310:
2311: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2312: lr_pullseq_info.supplier_id := NULL;
2313: lr_pullseq_info.supplier_site_id := NULL;

Line 2311: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN

2307:
2308: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD
2309: OR l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2310:
2311: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2312: lr_pullseq_info.supplier_id := NULL;
2313: lr_pullseq_info.supplier_site_id := NULL;
2314: lr_pullseq_info.wip_line_id := NULL;
2315: lr_pullseq_info.source_organization_id := NULL;

Line 2348: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE

2344: END IF;
2345:
2346: -- Validate Max Replenishments
2347: IF r_kanban_card_rec.max_replenishments IS NOT NULL THEN
2348: IF l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE
2349: AND r_kanban_card_rec.kanban_card_id IS NOT NULL THEN
2350: -- Consider replenishments done instead of status changes.
2351: SELECT count(distinct replenishment_cycle_id)
2352: INTO l_max_replenishments

Line 2454: IF l_source_locator_control <> FLM_KANBAN_MASSLOAD.LOCATOR_NONE THEN

2450: r_kanban_card_rec.source_organization_id,
2451: r_kanban_card_rec.source_subinventory);
2452:
2453: -- Validate source locator_id
2454: IF l_source_locator_control <> FLM_KANBAN_MASSLOAD.LOCATOR_NONE THEN
2455: -- mandatory if source subinventory is locator controlled
2456: IF r_kanban_card_rec.source_locator_id IS NOT NULL AND lr_pullseq_info.source_organization_id IS NULL
2457: THEN
2458: IF NOT is_locator_id_valid (p_subinv_name => r_kanban_card_rec.source_subinventory

Line 2587: IF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD THEN

2583: r_kanban_card_rec := p_kanban_card_rec;
2584: l_release_kanban_flag := p_release_kanban_flag;
2585: l_supplier_id := NULL;
2586: l_supp_site_id := NULL;
2587: IF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD THEN
2588: mydebug('Transaction Type ADD');
2589:
2590: -- To fetch supplier information
2591: mydebug('Calling mtl_multiple_suppliers.get_supplier');

Line 2743: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN

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:
2743: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE THEN
2744: -- Check for the card status change/ supply status change/ supplier info/ error code
2745: mydebug('Transaction Type UPDATE');
2746: SELECT MTC.supply_status
2747: ,MTC.card_status

Line 2830: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN

2826: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
2827: x_err_msg := l_error_msg;
2828: END IF;
2829:
2830: ELSIF p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE THEN
2831: mydebug('Transaction Type DELETE');
2832: INV_KanbanCard_PKG.delete_row(x_return_status => l_ret_status,
2833: p_kanban_card_id => r_kanban_card_rec.kanban_card_id);
2834: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN

Line 3015: if p_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then

3011: x_ret_status := l_ret_status;
3012: x_err_msg := l_err_msg;
3013: END IF;
3014: -- Added for Bug 12425069.
3015: if p_transaction_type = FLM_KANBAN_MASSLOAD.kanban_change then
3016: if nvl(p_kanban_size,r_kanban_card_rec.kanban_size) <> r_kanban_card_rec.kanban_size then
3017: l_ret_status := 'W';
3018: fnd_message.set_name ('FLM', 'FLM_ATTRIBUTE_IGNORED');
3019: fnd_message.set_token ('ATTRIBUTE', 'Kanban Size');

Line 3131: PROCEDURE process_kc(p_card_int_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type

3127:
3128: ---------------------------------
3129: --Procedure to load Kanban Cards
3130: ---------------------------------
3131: PROCEDURE process_kc(p_card_int_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type
3132: ,x_ret_status OUT NOCOPY VARCHAR2
3133: )
3134: IS
3135: r_kanban_card_rec flm_ekanban_pub.kanban_card_rec_type;

Line 3209: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;

3205: ,x_err_msg => l_err_msg
3206: );
3207:
3208: IF l_ret_status = FND_API.G_RET_STS_ERROR THEN
3209: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
3210: p_card_int_tbl(i).error_text := l_err_msg;
3211: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3212: ' failed due to following : '|| l_err_msg );
3213: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3214: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;

3210: p_card_int_tbl(i).error_text := l_err_msg;
3211: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3212: ' failed due to following : '|| l_err_msg );
3213: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3214: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.ERROR;
3215: p_card_int_tbl(i).error_text := l_err_msg ;
3216: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3217: ' failed due to following : '|| l_err_msg );
3218: ELSIF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN

Line 3219: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;

3215: p_card_int_tbl(i).error_text := l_err_msg ;
3216: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3217: ' failed due to following : '|| l_err_msg );
3218: ELSIF l_ret_status = FND_API.G_RET_STS_SUCCESS THEN
3219: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.COMPLETED;
3220: p_card_int_tbl(i).kanban_card_id := r_kanban_card_rec.kanban_card_id;
3221: mydebug('Kanban Card Id : '|| p_card_int_tbl(i).kanban_card_id);
3222: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3223: ' was processed successfully. ');

Line 3225: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;

3221: mydebug('Kanban Card Id : '|| p_card_int_tbl(i).kanban_card_id);
3222: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3223: ' was processed successfully. ');
3224: ELSIF l_ret_status = 'W' THEN
3225: p_card_int_tbl(i).process_status := FLM_KANBAN_MASSLOAD.WARNING;
3226: p_card_int_tbl(i).kanban_card_id := r_kanban_card_rec.kanban_card_id;
3227: fnd_file.put_line(fnd_file.log,' Kanban card details with Interface Id : '|| p_card_int_tbl(i).interface_id ||
3228: ' had following warnings : '|| l_err_msg );
3229: END IF;

Line 3403: l_pull_sequence_rec.Kanban_plan_id := FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN;

3399: l_pull_sequence_rec.pull_sequence_id := r_pull_seq_rec.pull_sequence_id;
3400: l_pull_sequence_rec.inventory_item_id := r_pull_seq_rec.inventory_item_id;
3401: l_pull_sequence_rec.organization_id := r_pull_seq_rec.organization_id;
3402: l_pull_sequence_rec.subinventory_name := r_pull_seq_rec.subinventory_name;
3403: l_pull_sequence_rec.Kanban_plan_id := FLM_KANBAN_MASSLOAD.G_PRODUCTION_KANBAN;
3404: l_pull_sequence_rec.source_type := r_pull_seq_rec.source_type;
3405: l_pull_sequence_rec.last_update_date := r_pull_seq_rec.last_update_date;
3406: l_pull_sequence_rec.last_updated_by := r_pull_seq_rec.last_updated_by;
3407: l_pull_sequence_rec.creation_date := r_pull_seq_rec.creation_date;

Line 3472: if p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then

3468: l_pull_sequence_rec.program_id := FND_GLOBAL.CONC_PROGRAM_ID;
3469: l_pull_sequence_rec.program_update_date := SYSDATE;
3470: END IF;
3471:
3472: if p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then
3473:
3474: -- insert pull sequence
3475: --INV_PullSequence_PKG.Insert_Row(p_pull_sequence_rec => l_pull_sequence_rec);
3476: mydebug('Calling INV_PullSequence_PKG.Insert_Row procedure.');

Line 3553: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then

3549: ELSIF l_ret_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3550: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3551: END IF;
3552:
3553: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3554: -- update pull sequence
3555: --INV_PullSequence_PKG.Update_Row(p_pull_sequence_rec => l_pull_sequence_rec);
3556: mydebug('Calling INV_PullSequence_PKG.Update_Row procedure.');
3557:

Line 3639: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE then

3635: ELSE
3636: l_error_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_LAST, FND_API.G_FALSE);
3637: END IF;
3638:
3639: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE then
3640: -- delete pull sequence
3641: mydebug('Calling INV_PullSequence_PKG.Delete_Row procedure.');
3642:
3643: INV_PullSequence_PKG.Delete_Row(x_return_status => l_ret_status

Line 3703: elsif p_supplier_rec.transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,

3699: if p_supplier_rec.transaction_type is null then
3700: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
3701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Supplier Transaction Type');
3702: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3703: elsif p_supplier_rec.transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
3704: FLM_KANBAN_MASSLOAD.kanban_change,
3705: FLM_KANBAN_MASSLOAD.kanban_delete)
3706: then
3707: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');

Line 3704: FLM_KANBAN_MASSLOAD.kanban_change,

3700: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
3701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Supplier Transaction Type');
3702: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3703: elsif p_supplier_rec.transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
3704: FLM_KANBAN_MASSLOAD.kanban_change,
3705: FLM_KANBAN_MASSLOAD.kanban_delete)
3706: then
3707: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
3708: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Supplier Transaction Type');

Line 3705: FLM_KANBAN_MASSLOAD.kanban_delete)

3701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Supplier Transaction Type');
3702: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3703: elsif p_supplier_rec.transaction_type NOT IN (FLM_KANBAN_MASSLOAD.kanban_add,
3704: FLM_KANBAN_MASSLOAD.kanban_change,
3705: FLM_KANBAN_MASSLOAD.kanban_delete)
3706: then
3707: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_INVALID');
3708: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Supplier Transaction Type');
3709: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;

Line 3752: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD

3748: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3749: end if;
3750: end if;
3751:
3752: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD
3753: ,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE) then
3754: --Validate supplier_site_id
3755: if p_supplier_rec.supplier_site_id is null then
3756: if p_supplier_rec.supplier_site_code is not null then

Line 3753: ,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE) then

3749: end if;
3750: end if;
3751:
3752: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD
3753: ,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE) then
3754: --Validate supplier_site_id
3755: if p_supplier_rec.supplier_site_id is null then
3756: if p_supplier_rec.supplier_site_code is not null then
3757: p_supplier_rec.supplier_site_id :=

Line 3779: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD) then

3775: end if;
3776: end if;
3777:
3778: --Unique constaint for pull_sequence_id and supplier_id combination; Added for Bug 12533212
3779: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD) then
3780: select count(*)
3781: into l_supplier_count
3782: from mtl_pull_seq_suppliers
3783: where pull_sequence_id = p_supplier_rec.pull_sequence_id

Line 3794: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then

3790: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3791: end if;
3792: end if;
3793:
3794: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3795: begin
3796: --Fix bug 12419603, should only check mtl_pull_seq_suppliers based on
3797: --supplier_id during update of pull seq since supplier_id is the primary key
3798: --of mtl_pull_seq_suppliers table

Line 3815: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then

3811:
3812: --Sourcing Percentage
3813: IF p_supplier_rec.sourcing_percentage IS NULL THEN
3814: -- During update null means retain old value.
3815: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then
3816: FND_MESSAGE.SET_NAME('FLM','FLM_ATTRIBUTE_REQUIRED');
3817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing Percentage');
3818: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3819: end if;

Line 3821: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then

3817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing Percentage');
3818: x_error_msg := x_error_msg||FND_CONST.NEWLINE||FND_MESSAGE.GET;
3819: end if;
3820: -- Fix bug 12419603, derive sourcing_percentage if it's not provided during update
3821: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3822: select sourcing_percentage into l_sourcing_percentage
3823: from mtl_pull_seq_suppliers
3824: where pull_sequence_id = p_supplier_rec.pull_sequence_id
3825: and supplier_id = p_supplier_rec.supplier_id;

Line 3954: p_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE)

3950: ,x_ret_status => l_ret_status
3951: ,x_error_msg => l_error_msg);
3952:
3953: if l_ret_status = FND_API.G_RET_STS_SUCCESS and
3954: p_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE)
3955: then
3956: -- Fix bug 12402610
3957: -- when updating pull sequence, if source_type is null, derive the source_type from mtl_kanban_pull_sequences table
3958: if (p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE and p_pull_sequence_rec.source_type is null) then

Line 3958: if (p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE and p_pull_sequence_rec.source_type is null) then

3954: p_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD,FLM_KANBAN_MASSLOAD.KANBAN_CHANGE)
3955: then
3956: -- Fix bug 12402610
3957: -- when updating pull sequence, if source_type is null, derive the source_type from mtl_kanban_pull_sequences table
3958: if (p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE and p_pull_sequence_rec.source_type is null) then
3959: select mkps.source_type
3960: into l_source_type
3961: from mtl_kanban_pull_sequences mkps
3962: WHERE pull_sequence_id = p_pull_sequence_rec.pull_sequence_id;

Line 4177: if p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then

4173: v_supplier_rec.creation_date := l_creation_date;
4174: v_supplier_rec.created_by := l_created_by;
4175: v_supplier_rec.last_update_login := l_last_update_login;
4176:
4177: if p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then
4178: -- call insert_supplier_row
4179: mydebug('Calling insert_supplier_row procedure. ');
4180: insert_supplier_row(p_supplier_rec => v_supplier_rec);
4181: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then

Line 4181: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then

4177: if p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_ADD then
4178: -- call insert_supplier_row
4179: mydebug('Calling insert_supplier_row procedure. ');
4180: insert_supplier_row(p_supplier_rec => v_supplier_rec);
4181: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
4182: -- call update_supplier_row
4183: mydebug('Calling update_supplier_row procedure. ');
4184: update_supplier_row(p_supplier_rec => v_supplier_rec);
4185: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE then

Line 4185: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE then

4181: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
4182: -- call update_supplier_row
4183: mydebug('Calling update_supplier_row procedure. ');
4184: update_supplier_row(p_supplier_rec => v_supplier_rec);
4185: elsif p_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_DELETE then
4186: -- call delete_supplier_row
4187: mydebug('Calling delete_supplier_row procedure. ');
4188: --Fix bug 12419603, pass v_supplier_rec.supplier_id instead of p_supplier_id
4189: --because v_supplier_rec.supplier_id will be defaulted by calling validate_suppliers

Line 4233: -- This procedure called from flm_kanban_massload package

4229: END process_suppliers;
4230:
4231: ----------------------------------------------------------
4232: -- Procedure process_kanban
4233: -- This procedure called from flm_kanban_massload package
4234: ----------------------------------------------------------
4235: PROCEDURE process_kanban
4236: ( p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type,
4237: p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type,

Line 4236: ( p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type,

4232: -- Procedure process_kanban
4233: -- This procedure called from flm_kanban_massload package
4234: ----------------------------------------------------------
4235: PROCEDURE process_kanban
4236: ( p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type,
4237: p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type,
4238: p_kanban_card_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type,
4239: x_ret_status OUT NOCOPY VARCHAR2
4240: )

Line 4237: p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type,

4233: -- This procedure called from flm_kanban_massload package
4234: ----------------------------------------------------------
4235: PROCEDURE process_kanban
4236: ( p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type,
4237: p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type,
4238: p_kanban_card_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type,
4239: x_ret_status OUT NOCOPY VARCHAR2
4240: )
4241: IS

Line 4238: p_kanban_card_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type,

4234: ----------------------------------------------------------
4235: PROCEDURE process_kanban
4236: ( p_pull_sequence_tbl IN OUT NOCOPY flm_kanban_massload.pull_seq_tbl_type,
4237: p_supplier_tbl IN OUT NOCOPY flm_kanban_massload.kanban_supp_tbl_type,
4238: p_kanban_card_tbl IN OUT NOCOPY flm_kanban_massload.card_int_tbl_type,
4239: x_ret_status OUT NOCOPY VARCHAR2
4240: )
4241: IS
4242: