DBA Data[Home] [Help]

APPS.INV_DEFAULT_TROLIN dependencies on FND_API

Line 129: g_trolin_rec.header_id <> FND_API.G_MISS_NUM

125:
126: /* inv_debug.message('In Get Line Num for header id:'||to_char(g_trolin_rec.header_id)); */
127: /* inv_debug.message('Prev header id:'||to_char(g_max_line_num_header_id)); */
128: IF g_trolin_rec.header_id IS NOT NULL AND
129: g_trolin_rec.header_id <> FND_API.G_MISS_NUM
130: THEN
131: /*
132: l_trohdr_rec :=
133: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );

Line 317: g_trolin_rec.header_id <> FND_API.G_MISS_NUM

313: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
314: BEGIN
315: /*
316: IF g_trolin_rec.header_id IS NOT NULL AND
317: g_trolin_rec.header_id <> FND_API.G_MISS_NUM
318: THEN
319: l_trohdr_rec :=
320: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );
321:

Line 357: g_trolin_rec.header_id <> FND_API.G_MISS_NUM

353: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
354: BEGIN
355: /*
356: IF g_trolin_rec.header_id IS NOT NULL AND
357: g_trolin_rec.header_id <> FND_API.G_MISS_NUM
358: THEN
359: l_trohdr_rec :=
360: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );
361:

Line 474: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR THEN

470: BEGIN
471:
472: -- In the future call Flex APIs for defaults
473:
474: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR THEN
475: g_trolin_rec.attribute1 := NULL;
476: END IF;
477:
478: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 478: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN

474: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR THEN
475: g_trolin_rec.attribute1 := NULL;
476: END IF;
477:
478: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN
479: g_trolin_rec.attribute10 := NULL;
480: END IF;
481:
482: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 482: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN

478: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN
479: g_trolin_rec.attribute10 := NULL;
480: END IF;
481:
482: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN
483: g_trolin_rec.attribute11 := NULL;
484: END IF;
485:
486: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 486: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN

482: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN
483: g_trolin_rec.attribute11 := NULL;
484: END IF;
485:
486: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN
487: g_trolin_rec.attribute12 := NULL;
488: END IF;
489:
490: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 490: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN

486: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN
487: g_trolin_rec.attribute12 := NULL;
488: END IF;
489:
490: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN
491: g_trolin_rec.attribute13 := NULL;
492: END IF;
493:
494: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 494: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN

490: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN
491: g_trolin_rec.attribute13 := NULL;
492: END IF;
493:
494: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN
495: g_trolin_rec.attribute14 := NULL;
496: END IF;
497:
498: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 498: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN

494: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN
495: g_trolin_rec.attribute14 := NULL;
496: END IF;
497:
498: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN
499: g_trolin_rec.attribute15 := NULL;
500: END IF;
501:
502: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 502: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN

498: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN
499: g_trolin_rec.attribute15 := NULL;
500: END IF;
501:
502: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN
503: g_trolin_rec.attribute2 := NULL;
504: END IF;
505:
506: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 506: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN

502: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN
503: g_trolin_rec.attribute2 := NULL;
504: END IF;
505:
506: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN
507: g_trolin_rec.attribute3 := NULL;
508: END IF;
509:
510: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 510: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN

506: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN
507: g_trolin_rec.attribute3 := NULL;
508: END IF;
509:
510: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN
511: g_trolin_rec.attribute4 := NULL;
512: END IF;
513:
514: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 514: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN

510: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN
511: g_trolin_rec.attribute4 := NULL;
512: END IF;
513:
514: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN
515: g_trolin_rec.attribute5 := NULL;
516: END IF;
517:
518: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 518: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN

514: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN
515: g_trolin_rec.attribute5 := NULL;
516: END IF;
517:
518: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN
519: g_trolin_rec.attribute6 := NULL;
520: END IF;
521:
522: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 522: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN

518: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN
519: g_trolin_rec.attribute6 := NULL;
520: END IF;
521:
522: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN
523: g_trolin_rec.attribute7 := NULL;
524: END IF;
525:
526: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 526: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN

522: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN
523: g_trolin_rec.attribute7 := NULL;
524: END IF;
525:
526: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN
527: g_trolin_rec.attribute8 := NULL;
528: END IF;
529:
530: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 530: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN

526: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN
527: g_trolin_rec.attribute8 := NULL;
528: END IF;
529:
530: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN
531: g_trolin_rec.attribute9 := NULL;
532: END IF;
533:
534: IF g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 534: IF g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR THEN

530: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN
531: g_trolin_rec.attribute9 := NULL;
532: END IF;
533:
534: IF g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR THEN
535: g_trolin_rec.attribute_category := NULL;
536: END IF;
537:
538: END Get_Flex_Trolin;

Line 589: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;

585:
586: PROCEDURE convert_quantity
587: ( x_return_status OUT NOCOPY VARCHAR2,
588: p_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS
589: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
590: l_primary_uom_code VARCHAR2(3);
591: l_tmp_secondary_quantity NUMBER := NULL; -- INVCONV
592: l_tmp_quantity NUMBER := NULL;
593: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV

Line 639: l_return_status := fnd_api.g_ret_sts_error;

635: IF l_tmp_secondary_quantity = -99999 THEN
636: -- conversion failed
637: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-SECOND-UOM'); -- INVCONV NEW MESSAGE
638: fnd_msg_pub.ADD;
639: l_return_status := fnd_api.g_ret_sts_error;
640: RAISE fnd_api.g_exc_error;
641: END IF;
642: p_trolin_rec.secondary_quantity := l_tmp_secondary_quantity; -- INVCONV
643: END IF;

Line 640: RAISE fnd_api.g_exc_error;

636: -- conversion failed
637: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-SECOND-UOM'); -- INVCONV NEW MESSAGE
638: fnd_msg_pub.ADD;
639: l_return_status := fnd_api.g_ret_sts_error;
640: RAISE fnd_api.g_exc_error;
641: END IF;
642: p_trolin_rec.secondary_quantity := l_tmp_secondary_quantity; -- INVCONV
643: END IF;
644:

Line 649: WHEN fnd_api.g_exc_error THEN

645: -- INVCONV END
646: x_return_status := l_return_status;
647: --
648: EXCEPTION
649: WHEN fnd_api.g_exc_error THEN
650: x_return_status := fnd_api.g_ret_sts_error;
651: --
652: WHEN fnd_api.g_exc_unexpected_error THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 650: x_return_status := fnd_api.g_ret_sts_error;

646: x_return_status := l_return_status;
647: --
648: EXCEPTION
649: WHEN fnd_api.g_exc_error THEN
650: x_return_status := fnd_api.g_ret_sts_error;
651: --
652: WHEN fnd_api.g_exc_unexpected_error THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: --

Line 652: WHEN fnd_api.g_exc_unexpected_error THEN

648: EXCEPTION
649: WHEN fnd_api.g_exc_error THEN
650: x_return_status := fnd_api.g_ret_sts_error;
651: --
652: WHEN fnd_api.g_exc_unexpected_error THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: --
655: WHEN OTHERS THEN
656: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 653: x_return_status := fnd_api.g_ret_sts_unexp_error;

649: WHEN fnd_api.g_exc_error THEN
650: x_return_status := fnd_api.g_ret_sts_error;
651: --
652: WHEN fnd_api.g_exc_unexpected_error THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: --
655: WHEN OTHERS THEN
656: x_return_status := fnd_api.g_ret_sts_unexp_error;
657:

Line 656: x_return_status := fnd_api.g_ret_sts_unexp_error;

652: WHEN fnd_api.g_exc_unexpected_error THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: --
655: WHEN OTHERS THEN
656: x_return_status := fnd_api.g_ret_sts_unexp_error;
657:
658: --
659: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
660: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert_Quantity');

Line 688: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

684: l_trans inv_validate.transaction;
685: l_acct_txn NUMBER;
686:
687: l_mov_order_type NUMBER;
688: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
689:
690: BEGIN
691: -- Check number of iterations.
692:

Line 703: RAISE FND_API.G_EXC_ERROR;

699: FND_MSG_PUB.Add;
700:
701: END IF;
702:
703: RAISE FND_API.G_EXC_ERROR;
704:
705: END IF;
706:
707: -- Initialize g_trolin_rec

Line 715: AND (g_trolin_rec.project_id = FND_API.G_MISS_NUM )

711: -- Default missing attributes.
712:
713: -- Changes for bug 6441724
714: IF (g_trolin_rec.operation = inv_globals.g_opr_create)
715: AND (g_trolin_rec.project_id = FND_API.G_MISS_NUM )
716: AND (g_trolin_rec.to_locator_id IS NOT NULL)
717: AND (g_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM)
718: THEN
719: select project_id,task_id

Line 717: AND (g_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM)

713: -- Changes for bug 6441724
714: IF (g_trolin_rec.operation = inv_globals.g_opr_create)
715: AND (g_trolin_rec.project_id = FND_API.G_MISS_NUM )
716: AND (g_trolin_rec.to_locator_id IS NOT NULL)
717: AND (g_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM)
718: THEN
719: select project_id,task_id
720: into g_trolin_rec.project_id,g_trolin_rec.task_id
721: from mtl_item_locations

Line 724: g_trolin_rec.project_id := FND_API.G_MISS_NUM;

720: into g_trolin_rec.project_id,g_trolin_rec.task_id
721: from mtl_item_locations
722: where inventory_location_id = g_trolin_rec.to_locator_id;
723: IF g_trolin_rec.project_id IS NULL THEN
724: g_trolin_rec.project_id := FND_API.G_MISS_NUM;
725: g_trolin_rec.task_id := FND_API.G_MISS_NUM;
726: END IF;
727: END IF;
728:

Line 725: g_trolin_rec.task_id := FND_API.G_MISS_NUM;

721: from mtl_item_locations
722: where inventory_location_id = g_trolin_rec.to_locator_id;
723: IF g_trolin_rec.project_id IS NULL THEN
724: g_trolin_rec.project_id := FND_API.G_MISS_NUM;
725: g_trolin_rec.task_id := FND_API.G_MISS_NUM;
726: END IF;
727: END IF;
728:
729:

Line 730: IF g_trolin_rec.organization_id = FND_API.G_MISS_NUM THEN

726: END IF;
727: END IF;
728:
729:
730: IF g_trolin_rec.organization_id = FND_API.G_MISS_NUM THEN
731:
732: g_trolin_rec.organization_id := Get_Organization;
733:
734: IF g_trolin_rec.organization_id IS NOT NULL THEN

Line 752: IF g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

748: END IF;
749:
750: END IF;
751:
752: IF g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
753:
754: g_trolin_rec.inventory_item_id := Get_Inventory_Item;
755:
756: IF g_trolin_rec.inventory_item_id IS NOT NULL THEN

Line 775: IF g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN

771: END IF;
772:
773: END IF;
774:
775: IF g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
776: g_trolin_rec.transaction_type_id := Get_Transaction_Type_Id;
777: END IF;
778: IF g_trolin_rec.transaction_type_id IS NOT NULL THEN
779: l_trans.transaction_type_id := g_trolin_rec.transaction_type_id;

Line 799: IF g_trolin_rec.date_required = FND_API.G_MISS_DATE THEN

795: ELSE
796: l_acct_txn := 0;
797: END IF;
798:
799: IF g_trolin_rec.date_required = FND_API.G_MISS_DATE THEN
800:
801: g_trolin_rec.date_required := Get_Date_Required;
802:
803: IF g_trolin_rec.date_required IS NOT NULL THEN

Line 821: IF g_trolin_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN

817:
818: END IF;
819:
820:
821: IF g_trolin_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
822:
823: g_trolin_rec.from_subinventory_code := Get_From_Subinventory;
824:
825: IF g_trolin_rec.from_subinventory_code IS NOT NULL THEN

Line 845: IF g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN

841:
842: END IF;
843:
844:
845: IF g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
846:
847: g_trolin_rec.from_subinventory_id := Get_From_Subinventory_Id;
848:
849: IF g_trolin_rec.from_subinventory_id IS NOT NULL THEN

Line 869: IF g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN

865:
866: END IF;
867:
868:
869: IF g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN
870:
871: g_trolin_rec.from_locator_id := Get_From_Locator;
872:
873: IF g_trolin_rec.from_locator_id IS NOT NULL THEN

Line 892: IF g_trolin_rec.line_id = FND_API.G_MISS_NUM THEN

888: END IF;
889:
890: END IF;
891:
892: IF g_trolin_rec.line_id = FND_API.G_MISS_NUM THEN
893:
894: /* inv_debug.message('Calling Get Line'); */
895: g_trolin_rec.line_id := Get_Line;
896:

Line 914: IF g_trolin_rec.line_number = FND_API.G_MISS_NUM THEN

910: END IF;
911:
912: END IF;
913:
914: IF g_trolin_rec.line_number = FND_API.G_MISS_NUM THEN
915:
916: g_trolin_rec.line_number := Get_Line_Number;
917:
918: IF g_trolin_rec.line_number IS NOT NULL THEN

Line 937: IF g_trolin_rec.line_status = FND_API.G_MISS_NUM THEN

933: END IF;
934:
935: END IF;
936:
937: IF g_trolin_rec.line_status = FND_API.G_MISS_NUM THEN
938:
939: g_trolin_rec.line_status := Get_Line_Status;
940:
941: IF g_trolin_rec.line_status IS NOT NULL THEN

Line 959: IF g_trolin_rec.lot_number = FND_API.G_MISS_CHAR THEN

955:
956: END IF;
957:
958:
959: IF g_trolin_rec.lot_number = FND_API.G_MISS_CHAR THEN
960:
961: g_trolin_rec.lot_number := Get_Lot_Number;
962:
963: IF g_trolin_rec.lot_number IS NOT NULL THEN

Line 1004: IF g_trolin_rec.project_id = FND_API.G_MISS_NUM THEN

1000: END IF;
1001:
1002: END IF;
1003:
1004: IF g_trolin_rec.project_id = FND_API.G_MISS_NUM THEN
1005:
1006: g_trolin_rec.project_id := Get_Project;
1007:
1008: IF g_trolin_rec.project_id IS NOT NULL THEN

Line 1025: IF g_trolin_rec.quantity = FND_API.G_MISS_NUM THEN

1021: END IF;
1022:
1023: END IF;
1024:
1025: IF g_trolin_rec.quantity = FND_API.G_MISS_NUM THEN
1026:
1027: g_trolin_rec.quantity := Get_Quantity;
1028:
1029: IF g_trolin_rec.quantity IS NOT NULL THEN

Line 1046: IF g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM THEN

1042: END IF;
1043:
1044: END IF;
1045:
1046: IF g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM THEN
1047:
1048: g_trolin_rec.quantity_delivered := Get_Quantity_Delivered;
1049:
1050: IF g_trolin_rec.quantity_delivered IS NOT NULL THEN

Line 1068: IF g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM THEN

1064: END IF;
1065:
1066: END IF;
1067:
1068: IF g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM THEN
1069:
1070: g_trolin_rec.quantity_detailed := Get_Quantity_Detailed;
1071:
1072: IF g_trolin_rec.quantity_detailed IS NOT NULL THEN

Line 1090: IF g_trolin_rec.reason_id = FND_API.G_MISS_NUM THEN

1086: END IF;
1087:
1088: END IF;
1089:
1090: IF g_trolin_rec.reason_id = FND_API.G_MISS_NUM THEN
1091:
1092: g_trolin_rec.reason_id := Get_Reason;
1093:
1094: IF g_trolin_rec.reason_id IS NOT NULL THEN

Line 1111: IF g_trolin_rec.reference = FND_API.G_MISS_CHAR THEN

1107: END IF;
1108:
1109: END IF;
1110:
1111: IF g_trolin_rec.reference = FND_API.G_MISS_CHAR THEN
1112:
1113: g_trolin_rec.reference := Get_Reference;
1114:
1115: IF g_trolin_rec.reference IS NOT NULL THEN

Line 1133: IF g_trolin_rec.reference_id = FND_API.G_MISS_NUM THEN

1129:
1130: END IF;
1131:
1132:
1133: IF g_trolin_rec.reference_id = FND_API.G_MISS_NUM THEN
1134:
1135: g_trolin_rec.reference_id := Get_Reference;
1136:
1137: IF g_trolin_rec.reference_id IS NOT NULL THEN

Line 1154: IF g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM THEN

1150: END IF;
1151:
1152: END IF;
1153:
1154: IF g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM THEN
1155:
1156: g_trolin_rec.reference_type_code := Get_Reference_Type;
1157:
1158: IF g_trolin_rec.reference_type_code IS NOT NULL THEN

Line 1177: IF g_trolin_rec.revision = FND_API.G_MISS_CHAR THEN

1173: END IF;
1174:
1175: END IF;
1176:
1177: IF g_trolin_rec.revision = FND_API.G_MISS_CHAR THEN
1178:
1179: g_trolin_rec.revision := Get_Revision;
1180:
1181: IF g_trolin_rec.revision IS NOT NULL THEN

Line 1199: IF g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR THEN

1195:
1196: END IF;
1197:
1198:
1199: IF g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR THEN
1200:
1201: g_trolin_rec.serial_number_end := Get_Serial_Number_End;
1202:
1203: IF g_trolin_rec.serial_number_end IS NOT NULL THEN

Line 1223: IF g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR THEN

1219:
1220: END IF;
1221:
1222:
1223: IF g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR THEN
1224:
1225: g_trolin_rec.serial_number_start := Get_Serial_Number_Start;
1226:
1227: IF g_trolin_rec.serial_number_start IS NOT NULL THEN

Line 1246: IF g_trolin_rec.status_date = FND_API.G_MISS_DATE THEN

1242: END IF;
1243:
1244: END IF;
1245:
1246: IF g_trolin_rec.status_date = FND_API.G_MISS_DATE THEN
1247:
1248: g_trolin_rec.status_date := Get_Status_Date;
1249:
1250: IF g_trolin_rec.status_date IS NOT NULL THEN

Line 1268: IF g_trolin_rec.task_id = FND_API.G_MISS_NUM THEN

1264:
1265: END IF;
1266:
1267:
1268: IF g_trolin_rec.task_id = FND_API.G_MISS_NUM THEN
1269:
1270: g_trolin_rec.task_id := Get_Task;
1271:
1272: IF g_trolin_rec.task_id IS NOT NULL THEN

Line 1290: IF g_trolin_rec.to_account_id = FND_API.G_MISS_NUM THEN

1286:
1287: END IF;
1288:
1289:
1290: IF g_trolin_rec.to_account_id = FND_API.G_MISS_NUM THEN
1291:
1292: g_trolin_rec.to_account_id := Get_To_Account;
1293:
1294: IF g_trolin_rec.to_account_id IS NOT NULL THEN

Line 1312: IF g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN

1308:
1309: END IF;
1310:
1311:
1312: IF g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN
1313:
1314: g_trolin_rec.to_locator_id := Get_To_Locator;
1315:
1316: IF g_trolin_rec.to_locator_id IS NOT NULL THEN

Line 1335: IF g_trolin_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN

1331:
1332: END IF;
1333:
1334:
1335: IF g_trolin_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
1336:
1337: g_trolin_rec.to_subinventory_code := Get_To_Subinventory;
1338:
1339: IF g_trolin_rec.to_subinventory_code IS NOT NULL THEN

Line 1359: IF g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN

1355:
1356: END IF;
1357:
1358:
1359: IF g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
1360:
1361: g_trolin_rec.to_subinventory_id := Get_To_Subinventory_Id;
1362:
1363: IF g_trolin_rec.to_subinventory_id IS NOT NULL THEN

Line 1383: IF g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM THEN

1379:
1380: END IF;
1381:
1382:
1383: IF g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
1384:
1385: g_trolin_rec.transaction_header_id := Get_Transaction_Header;
1386:
1387: IF g_trolin_rec.transaction_header_id IS NOT NULL THEN

Line 1405: IF g_trolin_rec.uom_code = FND_API.G_MISS_CHAR THEN

1401: END IF;
1402:
1403: END IF;
1404:
1405: IF g_trolin_rec.uom_code = FND_API.G_MISS_CHAR THEN
1406:
1407: g_trolin_rec.uom_code := Get_Uom;
1408:
1409: IF g_trolin_rec.uom_code IS NOT NULL THEN

Line 1426: IF g_trolin_rec.unit_number = FND_API.G_MISS_CHAR THEN

1422: END IF;
1423:
1424: END IF;
1425:
1426: IF g_trolin_rec.unit_number = FND_API.G_MISS_CHAR THEN
1427: g_trolin_rec.unit_number := Get_Unit_number;
1428: END IF;
1429:
1430: IF g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN

Line 1430: IF g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN

1426: IF g_trolin_rec.unit_number = FND_API.G_MISS_CHAR THEN
1427: g_trolin_rec.unit_number := Get_Unit_number;
1428: END IF;
1429:
1430: IF g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1431: g_trolin_rec.transaction_source_type_id := Get_Transaction_Source_Type_ID(g_trolin_rec.transaction_Type_id);
1432: IF g_trolin_rec.transaction_source_type_id IS NOT NULL THEN
1433: --IF INV_Validate.Transaction_Source_Type(g_trolin_rec.transaction_source_type_id)
1434: --THEN

Line 1446: IF g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN

1442: --END IF;
1443: END IF;
1444: END IF;
1445:
1446: IF g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1447: g_trolin_rec.txn_source_id := Get_Txn_Source_ID;
1448: IF g_trolin_rec.txn_source_id IS NOT NULL THEN
1449: --IF INV_Validate.Txn_Source(g_trolin_rec.txn_source_id)
1450: --THEN

Line 1462: IF g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN

1458: --END IF;
1459: END IF;
1460: END IF;
1461:
1462: IF g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1463: g_trolin_rec.txn_source_line_id := Get_Txn_Source_Line_ID;
1464: IF g_trolin_rec.txn_source_line_id IS NOT NULL THEN
1465: --IF INV_Validate.Txn_Source_Line(g_trolin_rec.txn_source_line_id)
1466: --THEN

Line 1478: IF g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN

1474: --END IF;
1475: END IF;
1476: END IF;
1477:
1478: IF g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1479: g_trolin_rec.txn_source_line_detail_id := Get_Txn_Source_Line_Detail_ID;
1480: IF g_trolin_rec.txn_source_line_detail_id IS NOT NULL THEN
1481: --IF INV_Validate.Txn_Source_Line_Detail(g_trolin_rec.txn_source_line_detail_id)
1482: --THEN

Line 1494: IF g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN

1490: --END IF;
1491: END IF;
1492: END IF;
1493:
1494: IF g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1495: g_trolin_rec.primary_quantity := Get_Primary_Quantity;
1496: IF g_trolin_rec.primary_quantity IS NOT NULL THEN
1497: --IF INV_Validate.Primary_Quantity(g_trolin_rec.primary_quantity)
1498: --THEN

Line 1510: IF g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN

1506: --END IF;
1507: END IF;
1508: END IF;
1509:
1510: IF g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1511: g_trolin_rec.to_organization_id := Get_To_Organization_Id;
1512: IF g_trolin_rec.to_organization_id IS NOT NULL THEN
1513: --IF INV_Validate.To_Organization(g_trolin_rec.to_organization_id)
1514: --THEN

Line 1526: IF g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN

1522: --END IF;
1523: END IF;
1524: END IF;
1525:
1526: IF g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1527: g_trolin_rec.pick_strategy_id := Get_Pick_Strategy_Id;
1528: IF g_trolin_rec.pick_strategy_id IS NOT NULL THEN
1529: --IF INV_Validate.Pick_Strategy(g_trolin_rec.pick_strategy_id)
1530: --THEN

Line 1542: IF g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN

1538: --END IF;
1539: END IF;
1540: END IF;
1541:
1542: IF g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1543: g_trolin_rec.put_away_strategy_id := Get_Put_Away_Strategy_ID;
1544: IF g_trolin_rec.put_away_strategy_id IS NOT NULL THEN
1545: --IF INV_Validate.Put_Away_Strategy(g_trolin_rec.put_away_strategy_id)
1546: --THEN

Line 1558: IF g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM THEN

1554: --END IF;
1555: END IF;
1556: END IF;
1557: --INVCONV
1558: IF g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM THEN
1559:
1560: g_trolin_rec.secondary_quantity := Get_Quantity;
1561:
1562: IF g_trolin_rec.secondary_quantity IS NOT NULL THEN

Line 1578: IF g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM THEN

1574: END IF;
1575:
1576: END IF;
1577:
1578: IF g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM THEN
1579:
1580: g_trolin_rec.secondary_quantity_delivered := Get_Quantity_Delivered;
1581:
1582: IF g_trolin_rec.secondary_quantity_delivered IS NOT NULL THEN

Line 1600: IF g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM THEN

1596: END IF;
1597:
1598: END IF;
1599:
1600: IF g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM THEN
1601:
1602: g_trolin_rec.secondary_quantity_detailed := Get_Quantity_Detailed;
1603:
1604: IF g_trolin_rec.secondary_quantity_detailed IS NOT NULL THEN

Line 1622: IF g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR THEN

1618: END IF;
1619:
1620: END IF;
1621:
1622: IF g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR THEN
1623:
1624: g_trolin_rec.secondary_uom := Get_Secondary_Uom;
1625: /*
1626: IF g_trolin_rec.secondary_uom IS NOT NULL THEN

Line 1643: IF l_return_status = fnd_api.g_ret_sts_error THEN

1639: END IF;
1640: */
1641: ELSIF g_trolin_rec.secondary_uom IS NULL AND g_trolin_rec.secondary_quantity = 0 THEN
1642: convert_quantity(x_return_status => l_return_status, p_trolin_rec => g_trolin_rec);
1643: IF l_return_status = fnd_api.g_ret_sts_error THEN
1644: g_trolin_rec.secondary_quantity := NULL;
1645: END IF;
1646: END IF;
1647:

Line 1648: IF g_trolin_rec.grade_code = FND_API.G_MISS_CHAR THEN

1644: g_trolin_rec.secondary_quantity := NULL;
1645: END IF;
1646: END IF;
1647:
1648: IF g_trolin_rec.grade_code = FND_API.G_MISS_CHAR THEN
1649:
1650: g_trolin_rec.grade_code := Get_Grade_Code;
1651: /*
1652: IF g_trolin_rec.grade_code IS NOT NULL THEN

Line 1672: IF g_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN

1668:
1669: --INVCONV
1670:
1671:
1672: IF g_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1673: g_trolin_rec.ship_to_location_id := NULL; -- nothing to default;
1674: END IF;
1675:
1676: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN

Line 1676: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN

1672: IF g_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1673: g_trolin_rec.ship_to_location_id := NULL; -- nothing to default;
1674: END IF;
1675:
1676: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1677: g_trolin_rec.from_cost_group_id := NULL; -- nothing to default;
1678: END IF;
1679:
1680: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN

Line 1680: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN

1676: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1677: g_trolin_rec.from_cost_group_id := NULL; -- nothing to default;
1678: END IF;
1679:
1680: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1681: g_trolin_rec.to_cost_group_id := NULL; -- nothing to default;
1682: END IF;
1683:
1684: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN

Line 1684: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN

1680: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1681: g_trolin_rec.to_cost_group_id := NULL; -- nothing to default;
1682: END IF;
1683:
1684: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1685: g_trolin_rec.lpn_id := NULL; -- nothing to default;
1686: END IF;
1687:
1688: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN

Line 1688: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN

1684: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1685: g_trolin_rec.lpn_id := NULL; -- nothing to default;
1686: END IF;
1687:
1688: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1689: g_trolin_rec.to_lpn_id := NULL; -- nothing to default;
1690: END IF;
1691:
1692: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN

Line 1692: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN

1688: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1689: g_trolin_rec.to_lpn_id := NULL; -- nothing to default;
1690: END IF;
1691:
1692: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1693: g_trolin_rec.pick_methodology_id := NULL; -- nothing to default;
1694: END IF;
1695:
1696: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN

Line 1696: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN

1692: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1693: g_trolin_rec.pick_methodology_id := NULL; -- nothing to default;
1694: END IF;
1695:
1696: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1697: g_trolin_rec.container_item_id := NULL; -- nothing to default;
1698: END IF;
1699:
1700: IF g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN

Line 1700: IF g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN

1696: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1697: g_trolin_rec.container_item_id := NULL; -- nothing to default;
1698: END IF;
1699:
1700: IF g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN
1701: g_trolin_rec.carton_grouping_id := NULL; -- nothing to default;
1702: END IF;
1703:
1704:

Line 1705: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR

1701: g_trolin_rec.carton_grouping_id := NULL; -- nothing to default;
1702: END IF;
1703:
1704:
1705: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR

1702: END IF;
1703:
1704:
1705: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR

1703:
1704:
1705: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR

1704:
1705: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

1705: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

1706: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

1707: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

1708: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

1709: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

1710: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

1711: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

1712: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1720: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

Line 1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

1713: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1720: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1721: THEN

Line 1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

1714: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1720: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1721: THEN
1722:

Line 1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

1715: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1720: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1721: THEN
1722:
1723: Get_Flex_Trolin;

Line 1720: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

1716: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1717: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1718: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1719: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1720: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1721: THEN
1722:
1723: Get_Flex_Trolin;
1724:

Line 1727: IF g_trolin_rec.created_by = FND_API.G_MISS_NUM THEN

1723: Get_Flex_Trolin;
1724:
1725: END IF;
1726:
1727: IF g_trolin_rec.created_by = FND_API.G_MISS_NUM THEN
1728:
1729: g_trolin_rec.created_by := NULL;
1730:
1731: END IF;

Line 1733: IF g_trolin_rec.creation_date = FND_API.G_MISS_DATE THEN

1729: g_trolin_rec.created_by := NULL;
1730:
1731: END IF;
1732:
1733: IF g_trolin_rec.creation_date = FND_API.G_MISS_DATE THEN
1734:
1735: g_trolin_rec.creation_date := NULL;
1736:
1737: END IF;

Line 1739: IF g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1735: g_trolin_rec.creation_date := NULL;
1736:
1737: END IF;
1738:
1739: IF g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1740:
1741: g_trolin_rec.last_updated_by := NULL;
1742:
1743: END IF;

Line 1745: IF g_trolin_rec.last_update_date = FND_API.G_MISS_DATE THEN

1741: g_trolin_rec.last_updated_by := NULL;
1742:
1743: END IF;
1744:
1745: IF g_trolin_rec.last_update_date = FND_API.G_MISS_DATE THEN
1746:
1747: g_trolin_rec.last_update_date := NULL;
1748:
1749: END IF;

Line 1751: IF g_trolin_rec.last_update_login = FND_API.G_MISS_NUM THEN

1747: g_trolin_rec.last_update_date := NULL;
1748:
1749: END IF;
1750:
1751: IF g_trolin_rec.last_update_login = FND_API.G_MISS_NUM THEN
1752:
1753: g_trolin_rec.last_update_login := NULL;
1754:
1755: END IF;

Line 1757: IF g_trolin_rec.program_application_id = FND_API.G_MISS_NUM THEN

1753: g_trolin_rec.last_update_login := NULL;
1754:
1755: END IF;
1756:
1757: IF g_trolin_rec.program_application_id = FND_API.G_MISS_NUM THEN
1758:
1759: g_trolin_rec.program_application_id := NULL;
1760:
1761: END IF;

Line 1763: IF g_trolin_rec.program_id = FND_API.G_MISS_NUM THEN

1759: g_trolin_rec.program_application_id := NULL;
1760:
1761: END IF;
1762:
1763: IF g_trolin_rec.program_id = FND_API.G_MISS_NUM THEN
1764:
1765: g_trolin_rec.program_id := NULL;
1766:
1767: END IF;

Line 1769: IF g_trolin_rec.program_update_date = FND_API.G_MISS_DATE THEN

1765: g_trolin_rec.program_id := NULL;
1766:
1767: END IF;
1768:
1769: IF g_trolin_rec.program_update_date = FND_API.G_MISS_DATE THEN
1770:
1771: g_trolin_rec.program_update_date := NULL;
1772:
1773: END IF;

Line 1775: IF g_trolin_rec.request_id = FND_API.G_MISS_NUM THEN

1771: g_trolin_rec.program_update_date := NULL;
1772:
1773: END IF;
1774:
1775: IF g_trolin_rec.request_id = FND_API.G_MISS_NUM THEN
1776:
1777: g_trolin_rec.request_id := NULL;
1778:
1779: END IF;

Line 1783: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR

1779: END IF;
1780:
1781: -- Redefault if there are any missing attributes.
1782:
1783: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR

1780:
1781: -- Redefault if there are any missing attributes.
1782:
1783: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR

1781: -- Redefault if there are any missing attributes.
1782:
1783: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR

1782:
1783: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

1783: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

1784: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

1785: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

1786: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

1787: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

1788: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

1789: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

1790: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

Line 1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

1791: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM

Line 1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

1792: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE

Line 1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

1793: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE

Line 1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

1794: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM

Line 1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM

1795: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char

Line 1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE

1796: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM

Line 1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE

1797: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM

Line 1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM

1798: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM

Line 1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char

1799: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM

Line 1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM

1800: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE

Line 1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM

1801: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM

Line 1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM

1802: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM

Line 1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM

1803: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM

Line 1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE

1804: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM

Line 1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM

1805: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR

Line 1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM

1806: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM

Line 1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM

1807: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM

Line 1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM

1808: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM

Line 1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR

1809: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE

Line 1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM

1810: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM

Line 1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM

1811: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM

Line 1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM

1812: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM

Line 1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE

1813: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM

Line 1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM

1814: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM

Line 1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM

1815: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR

Line 1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM

1816: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM

Line 1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM

1817: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM

Line 1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM

1818: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM

Line 1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR

1819: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR

Line 1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM

1820: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR

Line 1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM

1821: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR

Line 1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM

1822: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE

Line 1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR

1823: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM

Line 1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR

1824: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM

Line 1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR

1825: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM

Line 1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE

1826: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char

Line 1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM

1827: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM

Line 1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM

1828: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM

Line 1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM

1829: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR

Line 1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char

1830: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM

Line 1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM

1831: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM

Line 1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM

1832: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM

Line 1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR

1833: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM

Line 1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM

1834: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM

Line 1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM

1835: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM

Line 1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM

1836: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM

Line 1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM

1837: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM

Line 1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM

1838: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM

Line 1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM

1839: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR

Line 1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM

1840: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM

Line 1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM

1841: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM

Line 1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM

1842: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM

Line 1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR

1843: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM

Line 1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM

1844: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM

Line 1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM

1845: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM

Line 1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM

1846: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM

Line 1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM

1847: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV

Line 1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM

1848: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR

Line 1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM

1849: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR

Line 1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM

1850: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1851: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM

Line 1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR

1852: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1859: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1860: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM

Line 1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR

1853: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1859: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1860: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1861: --INVCONV

Line 1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM

1854: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1859: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1860: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1861: --INVCONV
1862: THEN

Line 1859: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM

1855: --INVCONV
1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1859: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1860: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1861: --INVCONV
1862: THEN
1863:

Line 1860: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM

1856: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1857: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1858: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1859: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1860: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1861: --INVCONV
1862: THEN
1863:
1864: INV_Default_Trolin.Attributes