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_PULLSEQUENCE_PKG dependencies on FND_API

Line 76: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

72: p_no_of_temp_cycle NUMBER DEFAULT NULL,
73: p_temp_exp_date DATE DEFAULT NULL)
74: IS
75:
76: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
77: --add for Ekanban business
78: l_msg_data VARCHAR2(1000);
79:
80: BEGIN

Line 169: WHEN FND_API.G_EXC_ERROR THEN

165:
166: end if;
167: EXCEPTION
168:
169: WHEN FND_API.G_EXC_ERROR THEN
170:
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: EXCEPTION
168:
169: WHEN FND_API.G_EXC_ERROR THEN
170:
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174:
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: WHEN FND_API.G_EXC_ERROR THEN
170:
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174:
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: WHEN OTHERS THEN

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171: x_return_status := FND_API.G_RET_STS_ERROR;
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174:
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: WHEN OTHERS THEN
178:
179: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: , 'Update_Row'
184: );
185: END IF;
186:
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188:
189: END Update_Row;
190:
191: PROCEDURE Insert_Row(x_return_status OUT NOCOPY Varchar2,

Line 266: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

262: p_temp_exp_date DATE DEFAULT NULL)
263:
264: is
265: l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;
266: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
267: --add for Ekanban business event
268: l_msg_data VARCHAR2(1000);
269: BEGIN
270: FND_MSG_PUB.Initialize;

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: x_msg_data =>l_msg_data,
435: x_return_status =>l_return_status);
436: end if;
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: end if;
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443:
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

438: WHEN FND_API.G_EXC_ERROR THEN
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443:
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445:
446: WHEN OTHERS THEN

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
443:
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445:
446: WHEN OTHERS THEN
447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451: , 'Insert_Row'
452: );
453: END IF;
454:
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:
457: End Insert_Row;
458:
459:

Line 665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

661: , 'Query_Row'
662: );
663: END IF;
664:
665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
666:
667: END Query_Row;
668:
669: FUNCTION Convert_Miss_To_Null

Line 676: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN

672: IS
673: l_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type := p_pull_sequence_rec;
674: BEGIN
675:
676: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
677: l_pull_sequence_rec.pull_sequence_id := NULL;
678: END IF;
679:
680: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

Line 680: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

676: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
677: l_pull_sequence_rec.pull_sequence_id := NULL;
678: END IF;
679:
680: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
681: l_pull_sequence_rec.inventory_item_id := NULL;
682: END IF;
683:
684: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 684: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

680: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
681: l_pull_sequence_rec.inventory_item_id := NULL;
682: END IF;
683:
684: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
685: l_pull_sequence_rec.organization_id := NULL;
686: END IF;
687:
688: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

Line 688: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

684: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
685: l_pull_sequence_rec.organization_id := NULL;
686: END IF;
687:
688: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
689: l_pull_sequence_rec.subinventory_name := NULL;
690: END IF;
691:
692: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN

Line 692: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN

688: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
689: l_pull_sequence_rec.subinventory_name := NULL;
690: END IF;
691:
692: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN
693: l_pull_sequence_rec.kanban_plan_id := NULL;
694: END IF;
695:
696: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

Line 696: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

692: IF l_pull_sequence_rec.kanban_plan_id = FND_API.G_MISS_NUM THEN
693: l_pull_sequence_rec.kanban_plan_id := NULL;
694: END IF;
695:
696: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
697: l_pull_sequence_rec.source_type := NULL;
698: END IF;
699:
700: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 700: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

696: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
697: l_pull_sequence_rec.source_type := NULL;
698: END IF;
699:
700: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
701: l_pull_sequence_rec.last_update_date := NULL;
702: END IF;
703:
704: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 704: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

700: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
701: l_pull_sequence_rec.last_update_date := NULL;
702: END IF;
703:
704: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
705: l_pull_sequence_rec.last_updated_by := NULL;
706: END IF;
707:
708: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 708: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

704: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
705: l_pull_sequence_rec.last_updated_by := NULL;
706: END IF;
707:
708: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
709: l_pull_sequence_rec.creation_date := NULL;
710: END IF;
711:
712: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

Line 712: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

708: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
709: l_pull_sequence_rec.creation_date := NULL;
710: END IF;
711:
712: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
713: l_pull_sequence_rec.created_by := NULL;
714: END IF;
715:
716: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 716: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

712: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
713: l_pull_sequence_rec.created_by := NULL;
714: END IF;
715:
716: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
717: l_pull_sequence_rec.last_update_login := NULL;
718: END IF;
719:
720: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

Line 720: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

716: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
717: l_pull_sequence_rec.last_update_login := NULL;
718: END IF;
719:
720: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
721: l_pull_sequence_rec.locator_id := NULL;
722: END IF;
723:
724: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

Line 724: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

720: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
721: l_pull_sequence_rec.locator_id := NULL;
722: END IF;
723:
724: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
725: l_pull_sequence_rec.supplier_id := NULL;
726: END IF;
727:
728: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

Line 728: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

724: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
725: l_pull_sequence_rec.supplier_id := NULL;
726: END IF;
727:
728: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
729: l_pull_sequence_rec.source_organization_id := NULL;
730: END IF;
731:
732: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

Line 732: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

728: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
729: l_pull_sequence_rec.source_organization_id := NULL;
730: END IF;
731:
732: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
733: l_pull_sequence_rec.source_subinventory := NULL;
734: END IF;
735:
736: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

Line 736: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

732: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
733: l_pull_sequence_rec.source_subinventory := NULL;
734: END IF;
735:
736: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
737: l_pull_sequence_rec.source_locator_id := NULL;
738: END IF;
739:
740: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

Line 740: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

736: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
737: l_pull_sequence_rec.source_locator_id := NULL;
738: END IF;
739:
740: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
741: l_pull_sequence_rec.wip_line_id := NULL;
742: END IF;
743:
744: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN

Line 744: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN

740: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
741: l_pull_sequence_rec.wip_line_id := NULL;
742: END IF;
743:
744: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN
745: l_pull_sequence_rec.release_kanban_flag := NULL;
746: END IF;
747:
748: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN

Line 748: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN

744: IF l_pull_sequence_rec.release_kanban_flag = FND_API.G_MISS_NUM THEN
745: l_pull_sequence_rec.release_kanban_flag := NULL;
746: END IF;
747:
748: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN
749: l_pull_sequence_rec.calculate_kanban_flag := NULL;
750: END IF;
751:
752: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

Line 752: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

748: IF l_pull_sequence_rec.calculate_kanban_flag = FND_API.G_MISS_NUM THEN
749: l_pull_sequence_rec.calculate_kanban_flag := NULL;
750: END IF;
751:
752: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
753: l_pull_sequence_rec.kanban_size := NULL;
754: END IF;
755:
756: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

Line 756: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

752: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
753: l_pull_sequence_rec.kanban_size := NULL;
754: END IF;
755:
756: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
757: l_pull_sequence_rec.replenishment_lead_time := NULL;
758: END IF;
759:
760: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

Line 760: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

756: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
757: l_pull_sequence_rec.replenishment_lead_time := NULL;
758: END IF;
759:
760: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
761: l_pull_sequence_rec.fixed_lot_multiplier := NULL;
762: END IF;
763:
764: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

Line 764: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

760: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
761: l_pull_sequence_rec.fixed_lot_multiplier := NULL;
762: END IF;
763:
764: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
765: l_pull_sequence_rec.safety_stock_days := NULL;
766: END IF;
767:
768: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

Line 768: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

764: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
765: l_pull_sequence_rec.safety_stock_days := NULL;
766: END IF;
767:
768: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
769: l_pull_sequence_rec.number_of_cards := NULL;
770: END IF;
771:
772: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

Line 772: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

768: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
769: l_pull_sequence_rec.number_of_cards := NULL;
770: END IF;
771:
772: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
773: l_pull_sequence_rec.minimum_order_quantity := NULL;
774: END IF;
775:
776: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

Line 776: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

772: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
773: l_pull_sequence_rec.minimum_order_quantity := NULL;
774: END IF;
775:
776: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
777: l_pull_sequence_rec.aggregation_type := NULL;
778: END IF;
779:
780: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN

Line 780: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN

776: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
777: l_pull_sequence_rec.aggregation_type := NULL;
778: END IF;
779:
780: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN
781: l_pull_sequence_rec.allocation_percent := NULL;
782: END IF;
783:
784: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 784: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

780: IF l_pull_sequence_rec.allocation_percent = FND_API.G_MISS_NUM THEN
781: l_pull_sequence_rec.allocation_percent := NULL;
782: END IF;
783:
784: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
785: l_pull_sequence_rec.last_update_login := NULL;
786: END IF;
787:
788: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

Line 788: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

784: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
785: l_pull_sequence_rec.last_update_login := NULL;
786: END IF;
787:
788: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
789: l_pull_sequence_rec.updated_flag := NULL;
790: END IF;
791:
792: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 792: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

788: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
789: l_pull_sequence_rec.updated_flag := NULL;
790: END IF;
791:
792: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
793: l_pull_sequence_rec.attribute_category := NULL;
794: END IF;
795:
796: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 796: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

792: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
793: l_pull_sequence_rec.attribute_category := NULL;
794: END IF;
795:
796: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
797: l_pull_sequence_rec.attribute1 := NULL;
798: END IF;
799:
800: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 800: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

796: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
797: l_pull_sequence_rec.attribute1 := NULL;
798: END IF;
799:
800: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
801: l_pull_sequence_rec.attribute2 := NULL;
802: END IF;
803:
804: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 804: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

800: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
801: l_pull_sequence_rec.attribute2 := NULL;
802: END IF;
803:
804: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
805: l_pull_sequence_rec.attribute3 := NULL;
806: END IF;
807:
808: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 808: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

804: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
805: l_pull_sequence_rec.attribute3 := NULL;
806: END IF;
807:
808: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
809: l_pull_sequence_rec.attribute4 := NULL;
810: END IF;
811:
812: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 812: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

808: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
809: l_pull_sequence_rec.attribute4 := NULL;
810: END IF;
811:
812: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
813: l_pull_sequence_rec.attribute5 := NULL;
814: END IF;
815:
816: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 816: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

812: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
813: l_pull_sequence_rec.attribute5 := NULL;
814: END IF;
815:
816: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
817: l_pull_sequence_rec.attribute6 := NULL;
818: END IF;
819:
820: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 820: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

816: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
817: l_pull_sequence_rec.attribute6 := NULL;
818: END IF;
819:
820: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
821: l_pull_sequence_rec.attribute7 := NULL;
822: END IF;
823:
824: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 824: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

820: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
821: l_pull_sequence_rec.attribute7 := NULL;
822: END IF;
823:
824: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
825: l_pull_sequence_rec.attribute8 := NULL;
826: END IF;
827:
828: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 828: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

824: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
825: l_pull_sequence_rec.attribute8 := NULL;
826: END IF;
827:
828: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
829: l_pull_sequence_rec.attribute9 := NULL;
830: END IF;
831:
832: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 832: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

828: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
829: l_pull_sequence_rec.attribute9 := NULL;
830: END IF;
831:
832: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
833: l_pull_sequence_rec.attribute10 := NULL;
834: END IF;
835:
836: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 836: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

832: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
833: l_pull_sequence_rec.attribute10 := NULL;
834: END IF;
835:
836: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
837: l_pull_sequence_rec.attribute11 := NULL;
838: END IF;
839:
840: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 840: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

836: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
837: l_pull_sequence_rec.attribute11 := NULL;
838: END IF;
839:
840: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
841: l_pull_sequence_rec.attribute12 := NULL;
842: END IF;
843:
844: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 844: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

840: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
841: l_pull_sequence_rec.attribute12 := NULL;
842: END IF;
843:
844: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
845: l_pull_sequence_rec.attribute13 := NULL;
846: END IF;
847:
848: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 848: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

844: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
845: l_pull_sequence_rec.attribute13 := NULL;
846: END IF;
847:
848: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
849: l_pull_sequence_rec.attribute14 := NULL;
850: END IF;
851:
852: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 852: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

848: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
849: l_pull_sequence_rec.attribute14 := NULL;
850: END IF;
851:
852: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
853: l_pull_sequence_rec.attribute15 := NULL;
854: END IF;
855:
856: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

Line 856: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

852: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
853: l_pull_sequence_rec.attribute15 := NULL;
854: END IF;
855:
856: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
857: l_pull_sequence_rec.request_id := NULL;
858: END IF;
859:
860: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 860: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

856: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
857: l_pull_sequence_rec.request_id := NULL;
858: END IF;
859:
860: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
861: l_pull_sequence_rec.program_application_id := NULL;
862: END IF;
863:
864: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

Line 864: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

860: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
861: l_pull_sequence_rec.program_application_id := NULL;
862: END IF;
863:
864: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
865: l_pull_sequence_rec.program_id := NULL;
866: END IF;
867:
868: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 868: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

864: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
865: l_pull_sequence_rec.program_id := NULL;
866: END IF;
867:
868: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
869: l_pull_sequence_rec.program_update_date := NULL;
870: END IF;
871:
872: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN

Line 872: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN

868: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
869: l_pull_sequence_rec.program_update_date := NULL;
870: END IF;
871:
872: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN
873: l_pull_sequence_rec.point_of_use_x := NULL;
874: END IF;
875:
876: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

Line 876: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

872: IF l_pull_sequence_rec.point_of_use_x= FND_API.G_MISS_NUM THEN
873: l_pull_sequence_rec.point_of_use_x := NULL;
874: END IF;
875:
876: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
877: l_pull_sequence_rec.point_of_use_y := NULL;
878: END IF;
879:
880: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

Line 880: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

876: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
877: l_pull_sequence_rec.point_of_use_y := NULL;
878: END IF;
879:
880: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
881: l_pull_sequence_rec.point_of_supply_x := NULL;
882: END IF;
883:
884: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

Line 884: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

880: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
881: l_pull_sequence_rec.point_of_supply_x := NULL;
882: END IF;
883:
884: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
885: l_pull_sequence_rec.point_of_supply_y := NULL;
886: END IF;
887:
888: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

Line 888: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

884: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
885: l_pull_sequence_rec.point_of_supply_y := NULL;
886: END IF;
887:
888: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
889: l_pull_sequence_rec.planning_update_status := NULL;
890: END IF;
891:
892: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

Line 892: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

888: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
889: l_pull_sequence_rec.planning_update_status := NULL;
890: END IF;
891:
892: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN
893: l_pull_sequence_rec.auto_request := NULL;
894: END IF;
895:
896: /*Added the following IF statement for 3905884.*/

Line 897: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN

893: l_pull_sequence_rec.auto_request := NULL;
894: END IF;
895:
896: /*Added the following IF statement for 3905884.*/
897: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN
898: l_pull_sequence_rec.auto_allocate_flag := NULL;
899: END IF;
900:
901: RETURN l_pull_sequence_rec;

Line 913: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN

909: IS
910: l_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type := p_pull_sequence_rec;
911: BEGIN
912:
913: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
914: l_pull_sequence_rec.pull_sequence_id := p_old_pull_sequence_rec.pull_sequence_id;
915: END IF;
916:
917: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

Line 917: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

913: IF l_pull_sequence_rec.pull_sequence_id = FND_API.G_MISS_NUM THEN
914: l_pull_sequence_rec.pull_sequence_id := p_old_pull_sequence_rec.pull_sequence_id;
915: END IF;
916:
917: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
918: l_pull_sequence_rec.inventory_item_id := p_old_pull_sequence_rec.inventory_item_id;
919: END IF;
920:
921: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 921: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN

917: IF l_pull_sequence_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
918: l_pull_sequence_rec.inventory_item_id := p_old_pull_sequence_rec.inventory_item_id;
919: END IF;
920:
921: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
922: l_pull_sequence_rec.organization_id := p_old_pull_sequence_rec.organization_id;
923: END IF;
924:
925: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

Line 925: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN

921: IF l_pull_sequence_rec.organization_id = FND_API.G_MISS_NUM THEN
922: l_pull_sequence_rec.organization_id := p_old_pull_sequence_rec.organization_id;
923: END IF;
924:
925: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
926: l_pull_sequence_rec.subinventory_name := p_old_pull_sequence_rec.subinventory_name;
927: END IF;
928:
929: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN

Line 929: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN

925: IF l_pull_sequence_rec.subinventory_name = FND_API.G_MISS_CHAR THEN
926: l_pull_sequence_rec.subinventory_name := p_old_pull_sequence_rec.subinventory_name;
927: END IF;
928:
929: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN
930: l_pull_sequence_rec.Kanban_plan_id := p_old_pull_sequence_rec.Kanban_plan_id;
931: END IF;
932:
933: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

Line 933: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN

929: IF l_pull_sequence_rec.Kanban_plan_id = FND_API.G_MISS_NUM THEN
930: l_pull_sequence_rec.Kanban_plan_id := p_old_pull_sequence_rec.Kanban_plan_id;
931: END IF;
932:
933: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
934: l_pull_sequence_rec.source_type := p_old_pull_sequence_rec.source_type;
935: END IF;
936:
937: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 937: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN

933: IF l_pull_sequence_rec.source_type = FND_API.G_MISS_NUM THEN
934: l_pull_sequence_rec.source_type := p_old_pull_sequence_rec.source_type;
935: END IF;
936:
937: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
938: l_pull_sequence_rec.last_update_date := p_old_pull_sequence_rec.last_update_date;
939: END IF;
940:
941: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 941: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN

937: IF l_pull_sequence_rec.last_update_date = FND_API.G_MISS_DATE THEN
938: l_pull_sequence_rec.last_update_date := p_old_pull_sequence_rec.last_update_date;
939: END IF;
940:
941: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
942: l_pull_sequence_rec.last_updated_by := p_old_pull_sequence_rec.last_updated_by;
943: END IF;
944:
945: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 945: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN

941: IF l_pull_sequence_rec.last_updated_by = FND_API.G_MISS_NUM THEN
942: l_pull_sequence_rec.last_updated_by := p_old_pull_sequence_rec.last_updated_by;
943: END IF;
944:
945: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
946: l_pull_sequence_rec.creation_date := p_old_pull_sequence_rec.creation_date;
947: END IF;
948:
949: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

Line 949: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN

945: IF l_pull_sequence_rec.creation_date = FND_API.G_MISS_DATE THEN
946: l_pull_sequence_rec.creation_date := p_old_pull_sequence_rec.creation_date;
947: END IF;
948:
949: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
950: l_pull_sequence_rec.created_by := p_old_pull_sequence_rec.created_by;
951: END IF;
952:
953: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

Line 953: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN

949: IF l_pull_sequence_rec.created_by = FND_API.G_MISS_NUM THEN
950: l_pull_sequence_rec.created_by := p_old_pull_sequence_rec.created_by;
951: END IF;
952:
953: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
954: l_pull_sequence_rec.locator_id := p_old_pull_sequence_rec.locator_id;
955: END IF;
956:
957: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

Line 957: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN

953: IF l_pull_sequence_rec.locator_id = FND_API.G_MISS_NUM THEN
954: l_pull_sequence_rec.locator_id := p_old_pull_sequence_rec.locator_id;
955: END IF;
956:
957: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
958: l_pull_sequence_rec.supplier_id := p_old_pull_sequence_rec.supplier_id;
959: END IF;
960:
961: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN

Line 961: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN

957: IF l_pull_sequence_rec.supplier_id = FND_API.G_MISS_NUM THEN
958: l_pull_sequence_rec.supplier_id := p_old_pull_sequence_rec.supplier_id;
959: END IF;
960:
961: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN
962: l_pull_sequence_rec.supplier_site_id := p_old_pull_sequence_rec.supplier_site_id;
963: END IF;
964:
965: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

Line 965: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN

961: IF l_pull_sequence_rec.supplier_site_id = FND_API.G_MISS_NUM THEN
962: l_pull_sequence_rec.supplier_site_id := p_old_pull_sequence_rec.supplier_site_id;
963: END IF;
964:
965: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
966: l_pull_sequence_rec.source_organization_id := p_old_pull_sequence_rec.source_organization_id;
967: END IF;
968:
969: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

Line 969: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN

965: IF l_pull_sequence_rec.source_organization_id = FND_API.G_MISS_NUM THEN
966: l_pull_sequence_rec.source_organization_id := p_old_pull_sequence_rec.source_organization_id;
967: END IF;
968:
969: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
970: l_pull_sequence_rec.source_subinventory := p_old_pull_sequence_rec.source_subinventory;
971: END IF;
972:
973: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

Line 973: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN

969: IF l_pull_sequence_rec.source_subinventory = FND_API.G_MISS_CHAR THEN
970: l_pull_sequence_rec.source_subinventory := p_old_pull_sequence_rec.source_subinventory;
971: END IF;
972:
973: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
974: l_pull_sequence_rec.source_locator_id := p_old_pull_sequence_rec.source_locator_id;
975: END IF;
976:
977: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

Line 977: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN

973: IF l_pull_sequence_rec.source_locator_id = FND_API.G_MISS_NUM THEN
974: l_pull_sequence_rec.source_locator_id := p_old_pull_sequence_rec.source_locator_id;
975: END IF;
976:
977: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
978: l_pull_sequence_rec.wip_line_id := p_old_pull_sequence_rec.wip_line_id;
979: END IF;
980:
981: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

Line 981: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN

977: IF l_pull_sequence_rec.wip_line_id = FND_API.G_MISS_NUM THEN
978: l_pull_sequence_rec.wip_line_id := p_old_pull_sequence_rec.wip_line_id;
979: END IF;
980:
981: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
982: l_pull_sequence_rec.replenishment_lead_time := p_old_pull_sequence_rec.replenishment_lead_time;
983: END IF;
984:
985: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN

Line 985: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN

981: IF l_pull_sequence_rec.replenishment_lead_time = FND_API.G_MISS_NUM THEN
982: l_pull_sequence_rec.replenishment_lead_time := p_old_pull_sequence_rec.replenishment_lead_time;
983: END IF;
984:
985: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN
986: l_pull_sequence_rec.Release_Kanban_Flag := p_old_pull_sequence_rec.Release_Kanban_Flag;
987:
988: END IF;
989: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN

Line 989: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN

985: IF l_pull_sequence_rec.Release_Kanban_Flag = FND_API.G_MISS_NUM THEN
986: l_pull_sequence_rec.Release_Kanban_Flag := p_old_pull_sequence_rec.Release_Kanban_Flag;
987:
988: END IF;
989: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN
990: l_pull_sequence_rec.Calculate_Kanban_Flag := p_old_pull_sequence_rec.Calculate_Kanban_Flag;
991: END IF;
992:
993: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

Line 993: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN

989: IF l_pull_sequence_rec.Calculate_Kanban_Flag = FND_API.G_MISS_NUM THEN
990: l_pull_sequence_rec.Calculate_Kanban_Flag := p_old_pull_sequence_rec.Calculate_Kanban_Flag;
991: END IF;
992:
993: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
994: l_pull_sequence_rec.kanban_size := p_old_pull_sequence_rec.kanban_size;
995: END IF;
996:
997: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

Line 997: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN

993: IF l_pull_sequence_rec.kanban_size = FND_API.G_MISS_NUM THEN
994: l_pull_sequence_rec.kanban_size := p_old_pull_sequence_rec.kanban_size;
995: END IF;
996:
997: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
998: l_pull_sequence_rec.fixed_lot_multiplier := p_old_pull_sequence_rec.fixed_lot_multiplier;
999: END IF;
1000:
1001: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

Line 1001: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN

997: IF l_pull_sequence_rec.fixed_lot_multiplier = FND_API.G_MISS_NUM THEN
998: l_pull_sequence_rec.fixed_lot_multiplier := p_old_pull_sequence_rec.fixed_lot_multiplier;
999: END IF;
1000:
1001: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
1002: l_pull_sequence_rec.safety_stock_days := p_old_pull_sequence_rec.safety_stock_days;
1003: END IF;
1004:
1005: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

Line 1005: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN

1001: IF l_pull_sequence_rec.safety_stock_days = FND_API.G_MISS_NUM THEN
1002: l_pull_sequence_rec.safety_stock_days := p_old_pull_sequence_rec.safety_stock_days;
1003: END IF;
1004:
1005: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
1006: l_pull_sequence_rec.number_of_cards := p_old_pull_sequence_rec.number_of_cards;
1007: END IF;
1008:
1009: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

Line 1009: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN

1005: IF l_pull_sequence_rec.number_of_cards = FND_API.G_MISS_NUM THEN
1006: l_pull_sequence_rec.number_of_cards := p_old_pull_sequence_rec.number_of_cards;
1007: END IF;
1008:
1009: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
1010: l_pull_sequence_rec.minimum_order_quantity := p_old_pull_sequence_rec.minimum_order_quantity;
1011: END IF;
1012:
1013: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

Line 1013: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN

1009: IF l_pull_sequence_rec.minimum_order_quantity = FND_API.G_MISS_NUM THEN
1010: l_pull_sequence_rec.minimum_order_quantity := p_old_pull_sequence_rec.minimum_order_quantity;
1011: END IF;
1012:
1013: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
1014: l_pull_sequence_rec.aggregation_type := p_old_pull_sequence_rec.aggregation_type;
1015: END IF;
1016:
1017: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

Line 1017: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN

1013: IF l_pull_sequence_rec.aggregation_type = FND_API.G_MISS_NUM THEN
1014: l_pull_sequence_rec.aggregation_type := p_old_pull_sequence_rec.aggregation_type;
1015: END IF;
1016:
1017: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
1018: l_pull_sequence_rec.Allocation_Percent := p_old_pull_sequence_rec.Allocation_Percent;
1019: END IF;
1020:
1021: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1021: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN

1017: IF l_pull_sequence_rec.Allocation_Percent = FND_API.G_MISS_NUM THEN
1018: l_pull_sequence_rec.Allocation_Percent := p_old_pull_sequence_rec.Allocation_Percent;
1019: END IF;
1020:
1021: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
1022: l_pull_sequence_rec.last_update_login := p_old_pull_sequence_rec.last_update_login;
1023: END IF;
1024:
1025: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

Line 1025: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN

1021: IF l_pull_sequence_rec.last_update_login = FND_API.G_MISS_NUM THEN
1022: l_pull_sequence_rec.last_update_login := p_old_pull_sequence_rec.last_update_login;
1023: END IF;
1024:
1025: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
1026: l_pull_sequence_rec.updated_flag := p_old_pull_sequence_rec.updated_flag;
1027: END IF;
1028:
1029: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 1029: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1025: IF l_pull_sequence_rec.updated_flag = FND_API.G_MISS_NUM THEN
1026: l_pull_sequence_rec.updated_flag := p_old_pull_sequence_rec.updated_flag;
1027: END IF;
1028:
1029: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1030: l_pull_sequence_rec.attribute_category := p_old_pull_sequence_rec.attribute_category;
1031: END IF;
1032:
1033: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1033: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1029: IF l_pull_sequence_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1030: l_pull_sequence_rec.attribute_category := p_old_pull_sequence_rec.attribute_category;
1031: END IF;
1032:
1033: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1034: l_pull_sequence_rec.attribute1 := p_old_pull_sequence_rec.attribute1;
1035: END IF;
1036:
1037: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1037: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1033: IF l_pull_sequence_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1034: l_pull_sequence_rec.attribute1 := p_old_pull_sequence_rec.attribute1;
1035: END IF;
1036:
1037: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1038: l_pull_sequence_rec.attribute2 := p_old_pull_sequence_rec.attribute2;
1039: END IF;
1040:
1041: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1041: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1037: IF l_pull_sequence_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1038: l_pull_sequence_rec.attribute2 := p_old_pull_sequence_rec.attribute2;
1039: END IF;
1040:
1041: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1042: l_pull_sequence_rec.attribute3 := p_old_pull_sequence_rec.attribute3;
1043: END IF;
1044:
1045: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1045: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1041: IF l_pull_sequence_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1042: l_pull_sequence_rec.attribute3 := p_old_pull_sequence_rec.attribute3;
1043: END IF;
1044:
1045: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1046: l_pull_sequence_rec.attribute4 := p_old_pull_sequence_rec.attribute4;
1047: END IF;
1048:
1049: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1049: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1045: IF l_pull_sequence_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1046: l_pull_sequence_rec.attribute4 := p_old_pull_sequence_rec.attribute4;
1047: END IF;
1048:
1049: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1050: l_pull_sequence_rec.attribute5 := p_old_pull_sequence_rec.attribute5;
1051: END IF;
1052:
1053: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1053: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1049: IF l_pull_sequence_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1050: l_pull_sequence_rec.attribute5 := p_old_pull_sequence_rec.attribute5;
1051: END IF;
1052:
1053: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1054: l_pull_sequence_rec.attribute6 := p_old_pull_sequence_rec.attribute6;
1055: END IF;
1056:
1057: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1057: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1053: IF l_pull_sequence_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1054: l_pull_sequence_rec.attribute6 := p_old_pull_sequence_rec.attribute6;
1055: END IF;
1056:
1057: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1058: l_pull_sequence_rec.attribute7 := p_old_pull_sequence_rec.attribute7;
1059: END IF;
1060:
1061: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1061: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1057: IF l_pull_sequence_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1058: l_pull_sequence_rec.attribute7 := p_old_pull_sequence_rec.attribute7;
1059: END IF;
1060:
1061: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1062: l_pull_sequence_rec.attribute8 := p_old_pull_sequence_rec.attribute8;
1063: END IF;
1064:
1065: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1065: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1061: IF l_pull_sequence_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1062: l_pull_sequence_rec.attribute8 := p_old_pull_sequence_rec.attribute8;
1063: END IF;
1064:
1065: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1066: l_pull_sequence_rec.attribute9 := p_old_pull_sequence_rec.attribute9;
1067: END IF;
1068:
1069: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1069: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1065: IF l_pull_sequence_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1066: l_pull_sequence_rec.attribute9 := p_old_pull_sequence_rec.attribute9;
1067: END IF;
1068:
1069: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1070: l_pull_sequence_rec.attribute10 := p_old_pull_sequence_rec.attribute10;
1071: END IF;
1072:
1073: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1073: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1069: IF l_pull_sequence_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1070: l_pull_sequence_rec.attribute10 := p_old_pull_sequence_rec.attribute10;
1071: END IF;
1072:
1073: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1074: l_pull_sequence_rec.attribute11 := p_old_pull_sequence_rec.attribute11;
1075: END IF;
1076:
1077: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1077: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1073: IF l_pull_sequence_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1074: l_pull_sequence_rec.attribute11 := p_old_pull_sequence_rec.attribute11;
1075: END IF;
1076:
1077: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1078: l_pull_sequence_rec.attribute12 := p_old_pull_sequence_rec.attribute12;
1079: END IF;
1080:
1081: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1081: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1077: IF l_pull_sequence_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1078: l_pull_sequence_rec.attribute12 := p_old_pull_sequence_rec.attribute12;
1079: END IF;
1080:
1081: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1082: l_pull_sequence_rec.attribute13 := p_old_pull_sequence_rec.attribute13;
1083: END IF;
1084:
1085: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1085: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1081: IF l_pull_sequence_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1082: l_pull_sequence_rec.attribute13 := p_old_pull_sequence_rec.attribute13;
1083: END IF;
1084:
1085: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1086: l_pull_sequence_rec.attribute14 := p_old_pull_sequence_rec.attribute14;
1087: END IF;
1088:
1089: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1089: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1085: IF l_pull_sequence_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1086: l_pull_sequence_rec.attribute14 := p_old_pull_sequence_rec.attribute14;
1087: END IF;
1088:
1089: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1090: l_pull_sequence_rec.attribute15 := p_old_pull_sequence_rec.attribute15;
1091: END IF;
1092:
1093: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1093: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN

1089: IF l_pull_sequence_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1090: l_pull_sequence_rec.attribute15 := p_old_pull_sequence_rec.attribute15;
1091: END IF;
1092:
1093: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
1094: l_pull_sequence_rec.request_id := p_old_pull_sequence_rec.request_id;
1095: END IF;
1096:
1097: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1097: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN

1093: IF l_pull_sequence_rec.request_id = FND_API.G_MISS_NUM THEN
1094: l_pull_sequence_rec.request_id := p_old_pull_sequence_rec.request_id;
1095: END IF;
1096:
1097: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
1098: l_pull_sequence_rec.program_application_id := p_old_pull_sequence_rec.program_application_id;
1099: END IF;
1100:
1101: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1101: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN

1097: IF l_pull_sequence_rec.program_application_id = FND_API.G_MISS_NUM THEN
1098: l_pull_sequence_rec.program_application_id := p_old_pull_sequence_rec.program_application_id;
1099: END IF;
1100:
1101: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
1102: l_pull_sequence_rec.program_id := p_old_pull_sequence_rec.program_id;
1103: END IF;
1104:
1105: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1105: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN

1101: IF l_pull_sequence_rec.program_id = FND_API.G_MISS_NUM THEN
1102: l_pull_sequence_rec.program_id := p_old_pull_sequence_rec.program_id;
1103: END IF;
1104:
1105: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
1106: l_pull_sequence_rec.program_update_date := p_old_pull_sequence_rec.program_update_date;
1107: END IF;
1108:
1109: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN

Line 1109: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN

1105: IF l_pull_sequence_rec.program_update_date = FND_API.G_MISS_DATE THEN
1106: l_pull_sequence_rec.program_update_date := p_old_pull_sequence_rec.program_update_date;
1107: END IF;
1108:
1109: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN
1110: l_pull_sequence_rec.point_of_use_x := p_old_pull_sequence_rec.point_of_use_x;
1111: END IF;
1112:
1113: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

Line 1113: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN

1109: IF l_pull_sequence_rec.point_of_use_x = FND_API.G_MISS_NUM THEN
1110: l_pull_sequence_rec.point_of_use_x := p_old_pull_sequence_rec.point_of_use_x;
1111: END IF;
1112:
1113: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
1114: l_pull_sequence_rec.point_of_use_y := p_old_pull_sequence_rec.point_of_use_y;
1115: END IF;
1116:
1117: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

Line 1117: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN

1113: IF l_pull_sequence_rec.point_of_use_y = FND_API.G_MISS_NUM THEN
1114: l_pull_sequence_rec.point_of_use_y := p_old_pull_sequence_rec.point_of_use_y;
1115: END IF;
1116:
1117: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
1118: l_pull_sequence_rec.point_of_supply_x := p_old_pull_sequence_rec.point_of_supply_x;
1119: END IF;
1120:
1121: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

Line 1121: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN

1117: IF l_pull_sequence_rec.point_of_supply_x = FND_API.G_MISS_NUM THEN
1118: l_pull_sequence_rec.point_of_supply_x := p_old_pull_sequence_rec.point_of_supply_x;
1119: END IF;
1120:
1121: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
1122: l_pull_sequence_rec.point_of_supply_y := p_old_pull_sequence_rec.point_of_supply_y;
1123: END IF;
1124:
1125: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

Line 1125: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN

1121: IF l_pull_sequence_rec.point_of_supply_y = FND_API.G_MISS_NUM THEN
1122: l_pull_sequence_rec.point_of_supply_y := p_old_pull_sequence_rec.point_of_supply_y;
1123: END IF;
1124:
1125: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
1126: l_pull_sequence_rec.planning_update_status := p_old_pull_sequence_rec.planning_update_status;
1127: END IF;
1128:
1129: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

Line 1129: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN

1125: IF l_pull_sequence_rec.planning_update_status = FND_API.G_MISS_NUM THEN
1126: l_pull_sequence_rec.planning_update_status := p_old_pull_sequence_rec.planning_update_status;
1127: END IF;
1128:
1129: IF l_pull_sequence_rec.auto_request = FND_API.G_MISS_CHAR THEN
1130: l_pull_sequence_rec.auto_request := p_old_pull_sequence_rec.auto_request;
1131: END IF;
1132:
1133: /*Added the following IF statement for 3905884.*/

Line 1134: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN

1130: l_pull_sequence_rec.auto_request := p_old_pull_sequence_rec.auto_request;
1131: END IF;
1132:
1133: /*Added the following IF statement for 3905884.*/
1134: IF l_pull_sequence_rec.auto_allocate_flag = FND_API.G_MISS_NUM THEN
1135: l_pull_sequence_rec.auto_allocate_flag := p_old_pull_sequence_rec.auto_allocate_flag;
1136: END IF;
1137:
1138: RETURN l_pull_sequence_rec;

Line 1210: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1206: p_avg_dependent_demand NUMBER DEFAULT NULL,
1207: p_avg_independent_demand NUMBER DEFAULT NULL)
1208: is
1209: l_pull_sequence_Id MTL_Kanban_Pull_Sequences.Pull_Sequence_Id%Type;
1210: l_return_status Varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1211: BEGIN
1212: FND_MSG_PUB.Initialize;
1213: If nvl(p_Pull_sequence_Id,0) <= 0
1214: Then

Line 1362: WHEN FND_API.G_EXC_ERROR THEN

1358: p_pull_sequence_id := l_Pull_Sequence_id;
1359:
1360: x_return_status := l_return_status;
1361: EXCEPTION
1362: WHEN FND_API.G_EXC_ERROR THEN
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1364: x_return_status := FND_API.G_RET_STS_ERROR;

1360: x_return_status := l_return_status;
1361: EXCEPTION
1362: WHEN FND_API.G_EXC_ERROR THEN
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367:
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1362: WHEN FND_API.G_EXC_ERROR THEN
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367:
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369:
1370: WHEN OTHERS THEN

Line 1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367:
1368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1369:
1370: WHEN OTHERS THEN
1371: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN

Line 1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1375: , 'Insert_Row'
1376: );
1377: END IF;
1378:
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380:
1381: End Insert_Row;
1382: */
1383: Procedure Insert_Row(p_pull_sequence_rec INV_Kanban_PVT.Pull_Sequence_Rec_Type)

Line 1465: if l_return_status = FND_API.G_RET_STS_ERROR

1461: p_no_of_temp_card => null,
1462: p_no_of_temp_cycle => null,
1463: p_temp_exp_date => null);
1464:
1465: if l_return_status = FND_API.G_RET_STS_ERROR
1466: Then
1467: Raise FND_API.G_EXC_ERROR;
1468: End if;
1469:

Line 1467: Raise FND_API.G_EXC_ERROR;

1463: p_temp_exp_date => null);
1464:
1465: if l_return_status = FND_API.G_RET_STS_ERROR
1466: Then
1467: Raise FND_API.G_EXC_ERROR;
1468: End if;
1469:
1470: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1471: Then

Line 1470: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1466: Then
1467: Raise FND_API.G_EXC_ERROR;
1468: End if;
1469:
1470: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1471: Then
1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End If;
1474:

Line 1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1468: End if;
1469:
1470: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1471: Then
1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End If;
1474:
1475: EXCEPTION
1476: WHEN FND_API.G_EXC_ERROR THEN

Line 1476: WHEN FND_API.G_EXC_ERROR THEN

1472: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1473: End If;
1474:
1475: EXCEPTION
1476: WHEN FND_API.G_EXC_ERROR THEN
1477:
1478: Raise FND_API.G_EXC_ERROR;
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1478: Raise FND_API.G_EXC_ERROR;

1474:
1475: EXCEPTION
1476: WHEN FND_API.G_EXC_ERROR THEN
1477:
1478: Raise FND_API.G_EXC_ERROR;
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481:
1482: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1476: WHEN FND_API.G_EXC_ERROR THEN
1477:
1478: Raise FND_API.G_EXC_ERROR;
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481:
1482: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1483:
1484: WHEN OTHERS THEN

Line 1482: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1478: Raise FND_API.G_EXC_ERROR;
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481:
1482: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1483:
1484: WHEN OTHERS THEN
1485:
1486: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1494: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1490: , 'Insert_Row'
1491: );
1492: END IF;
1493:
1494: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1495:
1496: End Insert_Row;
1497:
1498: PROCEDURE Lock_Row (p_Pull_Sequence_Id NUMBER,

Line 1761: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1757: p_avg_independent_demand NUMBER DEFAULT NULL)
1758:
1759: IS
1760:
1761: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1762:
1763: BEGIN
1764: FND_MSG_PUB.Initialize;
1765: UPDATE MTL_KANBAN_PULL_SEQUENCES

Line 1836: WHEN FND_API.G_EXC_ERROR THEN

1832: x_return_status := l_return_status;
1833:
1834: EXCEPTION
1835:
1836: WHEN FND_API.G_EXC_ERROR THEN
1837:
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1838: x_return_status := FND_API.G_RET_STS_ERROR;

1834: EXCEPTION
1835:
1836: WHEN FND_API.G_EXC_ERROR THEN
1837:
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1841:
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1836: WHEN FND_API.G_EXC_ERROR THEN
1837:
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1841:
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843:
1844: WHEN OTHERS THEN

Line 1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839:
1840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1841:
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1843:
1844: WHEN OTHERS THEN
1845:
1846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1850: , 'Update_Row'
1851: );
1852: END IF;
1853:
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1855:
1856: END Update_Row;
1857: */
1858: PROCEDURE Update_Row(

Line 1936: if l_return_status = FND_API.G_RET_STS_ERROR

1932: p_no_of_temp_card =>null,
1933: p_no_of_temp_cycle =>null,
1934: p_temp_exp_date =>null );
1935:
1936: if l_return_status = FND_API.G_RET_STS_ERROR
1937: Then
1938: Raise FND_API.G_EXC_ERROR;
1939: End if;
1940:

Line 1938: Raise FND_API.G_EXC_ERROR;

1934: p_temp_exp_date =>null );
1935:
1936: if l_return_status = FND_API.G_RET_STS_ERROR
1937: Then
1938: Raise FND_API.G_EXC_ERROR;
1939: End if;
1940:
1941: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1942: Then

Line 1941: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1937: Then
1938: Raise FND_API.G_EXC_ERROR;
1939: End if;
1940:
1941: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1942: Then
1943: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1944: End If;
1945:

Line 1943: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1939: End if;
1940:
1941: if l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1942: Then
1943: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1944: End If;
1945:
1946: EXCEPTION
1947:

Line 1948: WHEN FND_API.G_EXC_ERROR THEN

1944: End If;
1945:
1946: EXCEPTION
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949:
1950: Raise FND_API.G_EXC_ERROR;
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1950: Raise FND_API.G_EXC_ERROR;

1946: EXCEPTION
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949:
1950: Raise FND_API.G_EXC_ERROR;
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953:
1954: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1948: WHEN FND_API.G_EXC_ERROR THEN
1949:
1950: Raise FND_API.G_EXC_ERROR;
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953:
1954: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1955:
1956: WHEN OTHERS THEN

Line 1954: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1950: Raise FND_API.G_EXC_ERROR;
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953:
1954: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1955:
1956: WHEN OTHERS THEN
1957:
1958: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1965: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1961: ( G_PKG_NAME
1962: , 'Update_Row'
1963: );
1964: END IF;
1965: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1966:
1967: END Update_Row;
1968:
1969: PROCEDURE Delete_Row(x_return_status OUT NOCOPY VARCHAR2,

Line 1972: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;

1968:
1969: PROCEDURE Delete_Row(x_return_status OUT NOCOPY VARCHAR2,
1970: p_Pull_Sequence_Id Number)
1971: IS
1972: l_return_status varchar2(1) := FND_API.G_RET_STS_ERROR;
1973:
1974: BEGIN
1975: FND_MSG_PUB.Initialize;
1976: if INV_Kanban_PVT.Ok_To_Delete_Pull_Sequence(p_pull_sequence_Id)

Line 1983: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

1979: DELETE FROM MTL_KANBAN_PULL_SEQUENCES
1980: WHERE pull_sequence_id = p_pull_sequence_id;
1981:
1982: if (SQL%NOTFOUND) then
1983: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1984: else
1985: l_return_status := FND_API.G_RET_STS_SUCCESS;
1986: end if;
1987: else

Line 1985: l_return_status := FND_API.G_RET_STS_SUCCESS;

1981:
1982: if (SQL%NOTFOUND) then
1983: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1984: else
1985: l_return_status := FND_API.G_RET_STS_SUCCESS;
1986: end if;
1987: else
1988: Raise FND_API.G_EXC_ERROR;
1989: end if;

Line 1988: Raise FND_API.G_EXC_ERROR;

1984: else
1985: l_return_status := FND_API.G_RET_STS_SUCCESS;
1986: end if;
1987: else
1988: Raise FND_API.G_EXC_ERROR;
1989: end if;
1990:
1991: -- eKanban changes
1992: -- Delete all suppliers for the pull sequence

Line 2000: WHEN FND_API.G_EXC_ERROR THEN

1996:
1997: x_return_status := l_return_status;
1998:
1999: EXCEPTION
2000: WHEN FND_API.G_EXC_ERROR THEN
2001:
2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003:
2004: WHEN OTHERS THEN

Line 2002: x_return_status := FND_API.G_RET_STS_ERROR;

1998:
1999: EXCEPTION
2000: WHEN FND_API.G_EXC_ERROR THEN
2001:
2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003:
2004: WHEN OTHERS THEN
2005:
2006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003:
2004: WHEN OTHERS THEN
2005:
2006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2007: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2008: THEN
2009: FND_MSG_PUB.Add_Exc_Msg
2010: ( G_PKG_NAME