DBA Data[Home] [Help]

APPS.INV_DEFAULT_TROLIN dependencies on FND_API

Line 100: g_trolin_rec.header_id <> FND_API.G_MISS_NUM

96: BEGIN
97: /* inv_debug.message('In Get Line Num for header id:'||to_char(g_trolin_rec.header_id)); */
98: /* inv_debug.message('Prev header id:'||to_char(g_max_line_num_header_id)); */
99: IF g_trolin_rec.header_id IS NOT NULL AND
100: g_trolin_rec.header_id <> FND_API.G_MISS_NUM
101: THEN
102: /*
103: l_trohdr_rec :=
104: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );

Line 288: g_trolin_rec.header_id <> FND_API.G_MISS_NUM

284: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
285: BEGIN
286: /*
287: IF g_trolin_rec.header_id IS NOT NULL AND
288: g_trolin_rec.header_id <> FND_API.G_MISS_NUM
289: THEN
290: l_trohdr_rec :=
291: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );
292:

Line 328: g_trolin_rec.header_id <> FND_API.G_MISS_NUM

324: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
325: BEGIN
326: /*
327: IF g_trolin_rec.header_id IS NOT NULL AND
328: g_trolin_rec.header_id <> FND_API.G_MISS_NUM
329: THEN
330: l_trohdr_rec :=
331: INV_default_Trohdr.Load_Request_header(g_trolin_rec.header_id );
332:

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

441: BEGIN
442:
443: -- In the future call Flex APIs for defaults
444:
445: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR THEN
446: g_trolin_rec.attribute1 := NULL;
447: END IF;
448:
449: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

445: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR THEN
446: g_trolin_rec.attribute1 := NULL;
447: END IF;
448:
449: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN
450: g_trolin_rec.attribute10 := NULL;
451: END IF;
452:
453: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

449: IF g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR THEN
450: g_trolin_rec.attribute10 := NULL;
451: END IF;
452:
453: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN
454: g_trolin_rec.attribute11 := NULL;
455: END IF;
456:
457: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

453: IF g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR THEN
454: g_trolin_rec.attribute11 := NULL;
455: END IF;
456:
457: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN
458: g_trolin_rec.attribute12 := NULL;
459: END IF;
460:
461: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

457: IF g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR THEN
458: g_trolin_rec.attribute12 := NULL;
459: END IF;
460:
461: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN
462: g_trolin_rec.attribute13 := NULL;
463: END IF;
464:
465: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

461: IF g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR THEN
462: g_trolin_rec.attribute13 := NULL;
463: END IF;
464:
465: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN
466: g_trolin_rec.attribute14 := NULL;
467: END IF;
468:
469: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

465: IF g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR THEN
466: g_trolin_rec.attribute14 := NULL;
467: END IF;
468:
469: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN
470: g_trolin_rec.attribute15 := NULL;
471: END IF;
472:
473: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

469: IF g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR THEN
470: g_trolin_rec.attribute15 := NULL;
471: END IF;
472:
473: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN
474: g_trolin_rec.attribute2 := NULL;
475: END IF;
476:
477: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

473: IF g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR THEN
474: g_trolin_rec.attribute2 := NULL;
475: END IF;
476:
477: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN
478: g_trolin_rec.attribute3 := NULL;
479: END IF;
480:
481: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

477: IF g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR THEN
478: g_trolin_rec.attribute3 := NULL;
479: END IF;
480:
481: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN
482: g_trolin_rec.attribute4 := NULL;
483: END IF;
484:
485: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

481: IF g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR THEN
482: g_trolin_rec.attribute4 := NULL;
483: END IF;
484:
485: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN
486: g_trolin_rec.attribute5 := NULL;
487: END IF;
488:
489: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

485: IF g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR THEN
486: g_trolin_rec.attribute5 := NULL;
487: END IF;
488:
489: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN
490: g_trolin_rec.attribute6 := NULL;
491: END IF;
492:
493: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

489: IF g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR THEN
490: g_trolin_rec.attribute6 := NULL;
491: END IF;
492:
493: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN
494: g_trolin_rec.attribute7 := NULL;
495: END IF;
496:
497: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

493: IF g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR THEN
494: g_trolin_rec.attribute7 := NULL;
495: END IF;
496:
497: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN
498: g_trolin_rec.attribute8 := NULL;
499: END IF;
500:
501: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

497: IF g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR THEN
498: g_trolin_rec.attribute8 := NULL;
499: END IF;
500:
501: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN
502: g_trolin_rec.attribute9 := NULL;
503: END IF;
504:
505: IF g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR THEN

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

501: IF g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR THEN
502: g_trolin_rec.attribute9 := NULL;
503: END IF;
504:
505: IF g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR THEN
506: g_trolin_rec.attribute_category := NULL;
507: END IF;
508:
509: END Get_Flex_Trolin;

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

556:
557: PROCEDURE convert_quantity
558: ( x_return_status OUT NOCOPY VARCHAR2,
559: p_trolin_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type) IS
560: l_return_status VARCHAR2(1):= fnd_api.g_ret_sts_success;
561: l_primary_uom_code VARCHAR2(3);
562: l_tmp_secondary_quantity NUMBER := NULL; -- INVCONV
563: l_tmp_quantity NUMBER := NULL;
564: l_tracking_quantity_ind MTL_SYSTEM_ITEMS.tracking_quantity_ind%TYPE; --INVCONV

Line 605: l_return_status := fnd_api.g_ret_sts_error;

601: IF l_tmp_secondary_quantity = -99999 THEN
602: -- conversion failed
603: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-SECOND-UOM'); -- INVCONV NEW MESSAGE
604: fnd_msg_pub.ADD;
605: l_return_status := fnd_api.g_ret_sts_error;
606: RAISE fnd_api.g_exc_error;
607: END IF;
608: p_trolin_rec.secondary_quantity := l_tmp_secondary_quantity; -- INVCONV
609: END IF;

Line 606: RAISE fnd_api.g_exc_error;

602: -- conversion failed
603: fnd_message.set_name('INV', 'CAN-NOT-CONVERT-TO-SECOND-UOM'); -- INVCONV NEW MESSAGE
604: fnd_msg_pub.ADD;
605: l_return_status := fnd_api.g_ret_sts_error;
606: RAISE fnd_api.g_exc_error;
607: END IF;
608: p_trolin_rec.secondary_quantity := l_tmp_secondary_quantity; -- INVCONV
609: END IF;
610:

Line 615: WHEN fnd_api.g_exc_error THEN

611: -- INVCONV END
612: x_return_status := l_return_status;
613: --
614: EXCEPTION
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: --
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 616: x_return_status := fnd_api.g_ret_sts_error;

612: x_return_status := l_return_status;
613: --
614: EXCEPTION
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: --
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: --

Line 618: WHEN fnd_api.g_exc_unexpected_error THEN

614: EXCEPTION
615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: --
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: --
621: WHEN OTHERS THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 619: x_return_status := fnd_api.g_ret_sts_unexp_error;

615: WHEN fnd_api.g_exc_error THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617: --
618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: --
621: WHEN OTHERS THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623:

Line 622: x_return_status := fnd_api.g_ret_sts_unexp_error;

618: WHEN fnd_api.g_exc_unexpected_error THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620: --
621: WHEN OTHERS THEN
622: x_return_status := fnd_api.g_ret_sts_unexp_error;
623:
624: --
625: /* IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
626: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Convert_Quantity');

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

650: l_trans inv_validate.transaction;
651: l_acct_txn NUMBER;
652:
653: l_mov_order_type NUMBER;
654: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
655:
656: BEGIN
657: -- Check number of iterations.
658:

Line 669: RAISE FND_API.G_EXC_ERROR;

665: FND_MSG_PUB.Add;
666:
667: END IF;
668:
669: RAISE FND_API.G_EXC_ERROR;
670:
671: END IF;
672:
673: -- Initialize g_trolin_rec

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

677: -- Default missing attributes.
678:
679: -- Changes for bug 6441724
680: IF (g_trolin_rec.operation = inv_globals.g_opr_create)
681: AND (g_trolin_rec.project_id = FND_API.G_MISS_NUM )
682: AND (g_trolin_rec.to_locator_id IS NOT NULL)
683: AND (g_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM)
684: THEN
685: select project_id,task_id

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

679: -- Changes for bug 6441724
680: IF (g_trolin_rec.operation = inv_globals.g_opr_create)
681: AND (g_trolin_rec.project_id = FND_API.G_MISS_NUM )
682: AND (g_trolin_rec.to_locator_id IS NOT NULL)
683: AND (g_trolin_rec.to_locator_id <> FND_API.G_MISS_NUM)
684: THEN
685: select project_id,task_id
686: into g_trolin_rec.project_id,g_trolin_rec.task_id
687: from mtl_item_locations

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

686: into g_trolin_rec.project_id,g_trolin_rec.task_id
687: from mtl_item_locations
688: where inventory_location_id = g_trolin_rec.to_locator_id;
689: IF g_trolin_rec.project_id IS NULL THEN
690: g_trolin_rec.project_id := FND_API.G_MISS_NUM;
691: g_trolin_rec.task_id := FND_API.G_MISS_NUM;
692: END IF;
693: END IF;
694:

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

687: from mtl_item_locations
688: where inventory_location_id = g_trolin_rec.to_locator_id;
689: IF g_trolin_rec.project_id IS NULL THEN
690: g_trolin_rec.project_id := FND_API.G_MISS_NUM;
691: g_trolin_rec.task_id := FND_API.G_MISS_NUM;
692: END IF;
693: END IF;
694:
695:

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

692: END IF;
693: END IF;
694:
695:
696: IF g_trolin_rec.organization_id = FND_API.G_MISS_NUM THEN
697:
698: g_trolin_rec.organization_id := Get_Organization;
699:
700: IF g_trolin_rec.organization_id IS NOT NULL THEN

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

714: END IF;
715:
716: END IF;
717:
718: IF g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
719:
720: g_trolin_rec.inventory_item_id := Get_Inventory_Item;
721:
722: IF g_trolin_rec.inventory_item_id IS NOT NULL THEN

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

737: END IF;
738:
739: END IF;
740:
741: IF g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
742: g_trolin_rec.transaction_type_id := Get_Transaction_Type_Id;
743: END IF;
744: IF g_trolin_rec.transaction_type_id IS NOT NULL THEN
745: l_trans.transaction_type_id := g_trolin_rec.transaction_type_id;

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

761: ELSE
762: l_acct_txn := 0;
763: END IF;
764:
765: IF g_trolin_rec.date_required = FND_API.G_MISS_DATE THEN
766:
767: g_trolin_rec.date_required := Get_Date_Required;
768:
769: IF g_trolin_rec.date_required IS NOT NULL THEN

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

783:
784: END IF;
785:
786:
787: IF g_trolin_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
788:
789: g_trolin_rec.from_subinventory_code := Get_From_Subinventory;
790:
791: IF g_trolin_rec.from_subinventory_code IS NOT NULL THEN

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

807:
808: END IF;
809:
810:
811: IF g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
812:
813: g_trolin_rec.from_subinventory_id := Get_From_Subinventory_Id;
814:
815: IF g_trolin_rec.from_subinventory_id IS NOT NULL THEN

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

831:
832: END IF;
833:
834:
835: IF g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM THEN
836:
837: g_trolin_rec.from_locator_id := Get_From_Locator;
838:
839: IF g_trolin_rec.from_locator_id IS NOT NULL THEN

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

854: END IF;
855:
856: END IF;
857:
858: IF g_trolin_rec.line_id = FND_API.G_MISS_NUM THEN
859:
860: /* inv_debug.message('Calling Get Line'); */
861: g_trolin_rec.line_id := Get_Line;
862:

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

876: END IF;
877:
878: END IF;
879:
880: IF g_trolin_rec.line_number = FND_API.G_MISS_NUM THEN
881:
882: g_trolin_rec.line_number := Get_Line_Number;
883:
884: IF g_trolin_rec.line_number IS NOT NULL THEN

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

899: END IF;
900:
901: END IF;
902:
903: IF g_trolin_rec.line_status = FND_API.G_MISS_NUM THEN
904:
905: g_trolin_rec.line_status := Get_Line_Status;
906:
907: IF g_trolin_rec.line_status IS NOT NULL THEN

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

921:
922: END IF;
923:
924:
925: IF g_trolin_rec.lot_number = FND_API.G_MISS_CHAR THEN
926:
927: g_trolin_rec.lot_number := Get_Lot_Number;
928:
929: IF g_trolin_rec.lot_number IS NOT NULL THEN

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

966: END IF;
967:
968: END IF;
969:
970: IF g_trolin_rec.project_id = FND_API.G_MISS_NUM THEN
971:
972: g_trolin_rec.project_id := Get_Project;
973:
974: IF g_trolin_rec.project_id IS NOT NULL THEN

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

987: END IF;
988:
989: END IF;
990:
991: IF g_trolin_rec.quantity = FND_API.G_MISS_NUM THEN
992:
993: g_trolin_rec.quantity := Get_Quantity;
994:
995: IF g_trolin_rec.quantity IS NOT NULL THEN

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

1008: END IF;
1009:
1010: END IF;
1011:
1012: IF g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM THEN
1013:
1014: g_trolin_rec.quantity_delivered := Get_Quantity_Delivered;
1015:
1016: IF g_trolin_rec.quantity_delivered IS NOT NULL THEN

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

1030: END IF;
1031:
1032: END IF;
1033:
1034: IF g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM THEN
1035:
1036: g_trolin_rec.quantity_detailed := Get_Quantity_Detailed;
1037:
1038: IF g_trolin_rec.quantity_detailed IS NOT NULL THEN

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

1052: END IF;
1053:
1054: END IF;
1055:
1056: IF g_trolin_rec.reason_id = FND_API.G_MISS_NUM THEN
1057:
1058: g_trolin_rec.reason_id := Get_Reason;
1059:
1060: IF g_trolin_rec.reason_id IS NOT NULL THEN

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

1073: END IF;
1074:
1075: END IF;
1076:
1077: IF g_trolin_rec.reference = FND_API.G_MISS_CHAR THEN
1078:
1079: g_trolin_rec.reference := Get_Reference;
1080:
1081: IF g_trolin_rec.reference IS NOT NULL THEN

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

1095:
1096: END IF;
1097:
1098:
1099: IF g_trolin_rec.reference_id = FND_API.G_MISS_NUM THEN
1100:
1101: g_trolin_rec.reference_id := Get_Reference;
1102:
1103: IF g_trolin_rec.reference_id IS NOT NULL THEN

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

1116: END IF;
1117:
1118: END IF;
1119:
1120: IF g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM THEN
1121:
1122: g_trolin_rec.reference_type_code := Get_Reference_Type;
1123:
1124: IF g_trolin_rec.reference_type_code IS NOT NULL THEN

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

1139: END IF;
1140:
1141: END IF;
1142:
1143: IF g_trolin_rec.revision = FND_API.G_MISS_CHAR THEN
1144:
1145: g_trolin_rec.revision := Get_Revision;
1146:
1147: IF g_trolin_rec.revision IS NOT NULL THEN

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

1161:
1162: END IF;
1163:
1164:
1165: IF g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR THEN
1166:
1167: g_trolin_rec.serial_number_end := Get_Serial_Number_End;
1168:
1169: IF g_trolin_rec.serial_number_end IS NOT NULL THEN

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

1185:
1186: END IF;
1187:
1188:
1189: IF g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR THEN
1190:
1191: g_trolin_rec.serial_number_start := Get_Serial_Number_Start;
1192:
1193: IF g_trolin_rec.serial_number_start IS NOT NULL THEN

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

1208: END IF;
1209:
1210: END IF;
1211:
1212: IF g_trolin_rec.status_date = FND_API.G_MISS_DATE THEN
1213:
1214: g_trolin_rec.status_date := Get_Status_Date;
1215:
1216: IF g_trolin_rec.status_date IS NOT NULL THEN

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

1230:
1231: END IF;
1232:
1233:
1234: IF g_trolin_rec.task_id = FND_API.G_MISS_NUM THEN
1235:
1236: g_trolin_rec.task_id := Get_Task;
1237:
1238: IF g_trolin_rec.task_id IS NOT NULL THEN

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

1252:
1253: END IF;
1254:
1255:
1256: IF g_trolin_rec.to_account_id = FND_API.G_MISS_NUM THEN
1257:
1258: g_trolin_rec.to_account_id := Get_To_Account;
1259:
1260: IF g_trolin_rec.to_account_id IS NOT NULL THEN

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

1274:
1275: END IF;
1276:
1277:
1278: IF g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM THEN
1279:
1280: g_trolin_rec.to_locator_id := Get_To_Locator;
1281:
1282: IF g_trolin_rec.to_locator_id IS NOT NULL THEN

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

1297:
1298: END IF;
1299:
1300:
1301: IF g_trolin_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
1302:
1303: g_trolin_rec.to_subinventory_code := Get_To_Subinventory;
1304:
1305: IF g_trolin_rec.to_subinventory_code IS NOT NULL THEN

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

1321:
1322: END IF;
1323:
1324:
1325: IF g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
1326:
1327: g_trolin_rec.to_subinventory_id := Get_To_Subinventory_Id;
1328:
1329: IF g_trolin_rec.to_subinventory_id IS NOT NULL THEN

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

1345:
1346: END IF;
1347:
1348:
1349: IF g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
1350:
1351: g_trolin_rec.transaction_header_id := Get_Transaction_Header;
1352:
1353: IF g_trolin_rec.transaction_header_id IS NOT NULL THEN

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

1367: END IF;
1368:
1369: END IF;
1370:
1371: IF g_trolin_rec.uom_code = FND_API.G_MISS_CHAR THEN
1372:
1373: g_trolin_rec.uom_code := Get_Uom;
1374:
1375: IF g_trolin_rec.uom_code IS NOT NULL THEN

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

1388: END IF;
1389:
1390: END IF;
1391:
1392: IF g_trolin_rec.unit_number = FND_API.G_MISS_CHAR THEN
1393: g_trolin_rec.unit_number := Get_Unit_number;
1394: END IF;
1395:
1396: IF g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN

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

1392: IF g_trolin_rec.unit_number = FND_API.G_MISS_CHAR THEN
1393: g_trolin_rec.unit_number := Get_Unit_number;
1394: END IF;
1395:
1396: IF g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
1397: g_trolin_rec.transaction_source_type_id := Get_Transaction_Source_Type_ID(g_trolin_rec.transaction_Type_id);
1398: IF g_trolin_rec.transaction_source_type_id IS NOT NULL THEN
1399: --IF INV_Validate.Transaction_Source_Type(g_trolin_rec.transaction_source_type_id)
1400: --THEN

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

1408: --END IF;
1409: END IF;
1410: END IF;
1411:
1412: IF g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM THEN
1413: g_trolin_rec.txn_source_id := Get_Txn_Source_ID;
1414: IF g_trolin_rec.txn_source_id IS NOT NULL THEN
1415: --IF INV_Validate.Txn_Source(g_trolin_rec.txn_source_id)
1416: --THEN

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

1424: --END IF;
1425: END IF;
1426: END IF;
1427:
1428: IF g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
1429: g_trolin_rec.txn_source_line_id := Get_Txn_Source_Line_ID;
1430: IF g_trolin_rec.txn_source_line_id IS NOT NULL THEN
1431: --IF INV_Validate.Txn_Source_Line(g_trolin_rec.txn_source_line_id)
1432: --THEN

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

1440: --END IF;
1441: END IF;
1442: END IF;
1443:
1444: IF g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
1445: g_trolin_rec.txn_source_line_detail_id := Get_Txn_Source_Line_Detail_ID;
1446: IF g_trolin_rec.txn_source_line_detail_id IS NOT NULL THEN
1447: --IF INV_Validate.Txn_Source_Line_Detail(g_trolin_rec.txn_source_line_detail_id)
1448: --THEN

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

1456: --END IF;
1457: END IF;
1458: END IF;
1459:
1460: IF g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM THEN
1461: g_trolin_rec.primary_quantity := Get_Primary_Quantity;
1462: IF g_trolin_rec.primary_quantity IS NOT NULL THEN
1463: --IF INV_Validate.Primary_Quantity(g_trolin_rec.primary_quantity)
1464: --THEN

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

1472: --END IF;
1473: END IF;
1474: END IF;
1475:
1476: IF g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1477: g_trolin_rec.to_organization_id := Get_To_Organization_Id;
1478: IF g_trolin_rec.to_organization_id IS NOT NULL THEN
1479: --IF INV_Validate.To_Organization(g_trolin_rec.to_organization_id)
1480: --THEN

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

1488: --END IF;
1489: END IF;
1490: END IF;
1491:
1492: IF g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
1493: g_trolin_rec.pick_strategy_id := Get_Pick_Strategy_Id;
1494: IF g_trolin_rec.pick_strategy_id IS NOT NULL THEN
1495: --IF INV_Validate.Pick_Strategy(g_trolin_rec.pick_strategy_id)
1496: --THEN

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

1504: --END IF;
1505: END IF;
1506: END IF;
1507:
1508: IF g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
1509: g_trolin_rec.put_away_strategy_id := Get_Put_Away_Strategy_ID;
1510: IF g_trolin_rec.put_away_strategy_id IS NOT NULL THEN
1511: --IF INV_Validate.Put_Away_Strategy(g_trolin_rec.put_away_strategy_id)
1512: --THEN

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

1520: --END IF;
1521: END IF;
1522: END IF;
1523: --INVCONV
1524: IF g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM THEN
1525:
1526: g_trolin_rec.secondary_quantity := Get_Quantity;
1527:
1528: IF g_trolin_rec.secondary_quantity IS NOT NULL THEN

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

1540: END IF;
1541:
1542: END IF;
1543:
1544: IF g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM THEN
1545:
1546: g_trolin_rec.secondary_quantity_delivered := Get_Quantity_Delivered;
1547:
1548: IF g_trolin_rec.secondary_quantity_delivered IS NOT NULL THEN

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

1562: END IF;
1563:
1564: END IF;
1565:
1566: IF g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM THEN
1567:
1568: g_trolin_rec.secondary_quantity_detailed := Get_Quantity_Detailed;
1569:
1570: IF g_trolin_rec.secondary_quantity_detailed IS NOT NULL THEN

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

1584: END IF;
1585:
1586: END IF;
1587:
1588: IF g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR THEN
1589:
1590: g_trolin_rec.secondary_uom := Get_Secondary_Uom;
1591: /*
1592: IF g_trolin_rec.secondary_uom IS NOT NULL THEN

Line 1609: IF l_return_status = fnd_api.g_ret_sts_error THEN

1605: END IF;
1606: */
1607: ELSIF g_trolin_rec.secondary_uom IS NULL AND g_trolin_rec.secondary_quantity = 0 THEN
1608: convert_quantity(x_return_status => l_return_status, p_trolin_rec => g_trolin_rec);
1609: IF l_return_status = fnd_api.g_ret_sts_error THEN
1610: g_trolin_rec.secondary_quantity := NULL;
1611: END IF;
1612: END IF;
1613:

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

1610: g_trolin_rec.secondary_quantity := NULL;
1611: END IF;
1612: END IF;
1613:
1614: IF g_trolin_rec.grade_code = FND_API.G_MISS_CHAR THEN
1615:
1616: g_trolin_rec.grade_code := Get_Grade_Code;
1617: /*
1618: IF g_trolin_rec.grade_code IS NOT NULL THEN

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

1634:
1635: --INVCONV
1636:
1637:
1638: IF g_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1639: g_trolin_rec.ship_to_location_id := NULL; -- nothing to default;
1640: END IF;
1641:
1642: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN

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

1638: IF g_trolin_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
1639: g_trolin_rec.ship_to_location_id := NULL; -- nothing to default;
1640: END IF;
1641:
1642: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1643: g_trolin_rec.from_cost_group_id := NULL; -- nothing to default;
1644: END IF;
1645:
1646: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN

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

1642: IF g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM THEN
1643: g_trolin_rec.from_cost_group_id := NULL; -- nothing to default;
1644: END IF;
1645:
1646: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1647: g_trolin_rec.to_cost_group_id := NULL; -- nothing to default;
1648: END IF;
1649:
1650: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN

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

1646: IF g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM THEN
1647: g_trolin_rec.to_cost_group_id := NULL; -- nothing to default;
1648: END IF;
1649:
1650: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1651: g_trolin_rec.lpn_id := NULL; -- nothing to default;
1652: END IF;
1653:
1654: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN

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

1650: IF g_trolin_rec.lpn_id = FND_API.G_MISS_NUM THEN
1651: g_trolin_rec.lpn_id := NULL; -- nothing to default;
1652: END IF;
1653:
1654: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1655: g_trolin_rec.to_lpn_id := NULL; -- nothing to default;
1656: END IF;
1657:
1658: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN

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

1654: IF g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM THEN
1655: g_trolin_rec.to_lpn_id := NULL; -- nothing to default;
1656: END IF;
1657:
1658: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1659: g_trolin_rec.pick_methodology_id := NULL; -- nothing to default;
1660: END IF;
1661:
1662: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN

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

1658: IF g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM THEN
1659: g_trolin_rec.pick_methodology_id := NULL; -- nothing to default;
1660: END IF;
1661:
1662: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1663: g_trolin_rec.container_item_id := NULL; -- nothing to default;
1664: END IF;
1665:
1666: IF g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN

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

1662: IF g_trolin_rec.container_item_id = FND_API.G_MISS_NUM THEN
1663: g_trolin_rec.container_item_id := NULL; -- nothing to default;
1664: END IF;
1665:
1666: IF g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM THEN
1667: g_trolin_rec.carton_grouping_id := NULL; -- nothing to default;
1668: END IF;
1669:
1670:

Line 1671: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR

1667: g_trolin_rec.carton_grouping_id := NULL; -- nothing to default;
1668: END IF;
1669:
1670:
1671: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR

1668: END IF;
1669:
1670:
1671: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR

1669:
1670:
1671: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR

1670:
1671: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

1671: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

1672: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

1673: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

1674: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

1675: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

1676: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

1677: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

1678: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1686: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

Line 1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

1679: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1686: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1687: THEN

Line 1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

1680: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1686: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1687: THEN
1688:

Line 1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

1681: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1686: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1687: THEN
1688:
1689: Get_Flex_Trolin;

Line 1686: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

1682: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1683: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1684: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1685: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1686: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1687: THEN
1688:
1689: Get_Flex_Trolin;
1690:

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

1689: Get_Flex_Trolin;
1690:
1691: END IF;
1692:
1693: IF g_trolin_rec.created_by = FND_API.G_MISS_NUM THEN
1694:
1695: g_trolin_rec.created_by := NULL;
1696:
1697: END IF;

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

1695: g_trolin_rec.created_by := NULL;
1696:
1697: END IF;
1698:
1699: IF g_trolin_rec.creation_date = FND_API.G_MISS_DATE THEN
1700:
1701: g_trolin_rec.creation_date := NULL;
1702:
1703: END IF;

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

1701: g_trolin_rec.creation_date := NULL;
1702:
1703: END IF;
1704:
1705: IF g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1706:
1707: g_trolin_rec.last_updated_by := NULL;
1708:
1709: END IF;

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

1707: g_trolin_rec.last_updated_by := NULL;
1708:
1709: END IF;
1710:
1711: IF g_trolin_rec.last_update_date = FND_API.G_MISS_DATE THEN
1712:
1713: g_trolin_rec.last_update_date := NULL;
1714:
1715: END IF;

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

1713: g_trolin_rec.last_update_date := NULL;
1714:
1715: END IF;
1716:
1717: IF g_trolin_rec.last_update_login = FND_API.G_MISS_NUM THEN
1718:
1719: g_trolin_rec.last_update_login := NULL;
1720:
1721: END IF;

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

1719: g_trolin_rec.last_update_login := NULL;
1720:
1721: END IF;
1722:
1723: IF g_trolin_rec.program_application_id = FND_API.G_MISS_NUM THEN
1724:
1725: g_trolin_rec.program_application_id := NULL;
1726:
1727: END IF;

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

1725: g_trolin_rec.program_application_id := NULL;
1726:
1727: END IF;
1728:
1729: IF g_trolin_rec.program_id = FND_API.G_MISS_NUM THEN
1730:
1731: g_trolin_rec.program_id := NULL;
1732:
1733: END IF;

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

1731: g_trolin_rec.program_id := NULL;
1732:
1733: END IF;
1734:
1735: IF g_trolin_rec.program_update_date = FND_API.G_MISS_DATE THEN
1736:
1737: g_trolin_rec.program_update_date := NULL;
1738:
1739: END IF;

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

1737: g_trolin_rec.program_update_date := NULL;
1738:
1739: END IF;
1740:
1741: IF g_trolin_rec.request_id = FND_API.G_MISS_NUM THEN
1742:
1743: g_trolin_rec.request_id := NULL;
1744:
1745: END IF;

Line 1749: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR

1745: END IF;
1746:
1747: -- Redefault if there are any missing attributes.
1748:
1749: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR

1746:
1747: -- Redefault if there are any missing attributes.
1748:
1749: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR

1747: -- Redefault if there are any missing attributes.
1748:
1749: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR

1748:
1749: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

Line 1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR

1749: IF g_trolin_rec.attribute1 = FND_API.G_MISS_CHAR
1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

Line 1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR

1750: OR g_trolin_rec.attribute10 = FND_API.G_MISS_CHAR
1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR

1751: OR g_trolin_rec.attribute11 = FND_API.G_MISS_CHAR
1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR

1752: OR g_trolin_rec.attribute12 = FND_API.G_MISS_CHAR
1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR

1753: OR g_trolin_rec.attribute13 = FND_API.G_MISS_CHAR
1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR

1754: OR g_trolin_rec.attribute14 = FND_API.G_MISS_CHAR
1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR

1755: OR g_trolin_rec.attribute15 = FND_API.G_MISS_CHAR
1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR

1756: OR g_trolin_rec.attribute2 = FND_API.G_MISS_CHAR
1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

Line 1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR

1757: OR g_trolin_rec.attribute3 = FND_API.G_MISS_CHAR
1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM

Line 1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR

1758: OR g_trolin_rec.attribute4 = FND_API.G_MISS_CHAR
1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE

Line 1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR

1759: OR g_trolin_rec.attribute5 = FND_API.G_MISS_CHAR
1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE

Line 1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR

1760: OR g_trolin_rec.attribute6 = FND_API.G_MISS_CHAR
1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM

Line 1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM

1761: OR g_trolin_rec.attribute7 = FND_API.G_MISS_CHAR
1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char

Line 1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE

1762: OR g_trolin_rec.attribute8 = FND_API.G_MISS_CHAR
1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM

Line 1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE

1763: OR g_trolin_rec.attribute9 = FND_API.G_MISS_CHAR
1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM

Line 1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM

1764: OR g_trolin_rec.attribute_category = FND_API.G_MISS_CHAR
1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM

Line 1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char

1765: OR g_trolin_rec.created_by = FND_API.G_MISS_NUM
1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM

Line 1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM

1766: OR g_trolin_rec.creation_date = FND_API.G_MISS_DATE
1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE

Line 1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM

1767: OR g_trolin_rec.date_required = FND_API.G_MISS_DATE
1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM

Line 1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM

1768: OR g_trolin_rec.from_locator_id = FND_API.G_MISS_NUM
1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM

Line 1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM

1769: OR g_trolin_rec.from_subinventory_code = FND_API.g_miss_char
1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM

Line 1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE

1770: OR g_trolin_rec.from_subinventory_id = FND_API.G_MISS_NUM
1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM

Line 1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM

1771: OR g_trolin_rec.header_id = FND_API.G_MISS_NUM
1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR

Line 1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM

1772: OR g_trolin_rec.inventory_item_id = FND_API.G_MISS_NUM
1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM

Line 1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM

1773: OR g_trolin_rec.last_updated_by = FND_API.G_MISS_NUM
1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM

Line 1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM

1774: OR g_trolin_rec.last_update_date = FND_API.G_MISS_DATE
1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM

Line 1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR

1775: OR g_trolin_rec.last_update_login = FND_API.G_MISS_NUM
1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE

Line 1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM

1776: OR g_trolin_rec.line_id = FND_API.G_MISS_NUM
1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM

Line 1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM

1777: OR g_trolin_rec.line_number = FND_API.G_MISS_NUM
1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM

Line 1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM

1778: OR g_trolin_rec.line_status = FND_API.G_MISS_NUM
1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM

Line 1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE

1779: OR g_trolin_rec.lot_number = FND_API.G_MISS_CHAR
1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM

Line 1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM

1780: OR g_trolin_rec.organization_id = FND_API.G_MISS_NUM
1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM

Line 1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM

1781: OR g_trolin_rec.program_application_id = FND_API.G_MISS_NUM
1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR

Line 1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM

1782: OR g_trolin_rec.program_id = FND_API.G_MISS_NUM
1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM

Line 1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM

1783: OR g_trolin_rec.program_update_date = FND_API.G_MISS_DATE
1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM

Line 1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM

1784: OR g_trolin_rec.project_id = FND_API.G_MISS_NUM
1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM

Line 1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR

1785: OR g_trolin_rec.quantity = FND_API.G_MISS_NUM
1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR

Line 1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM

1786: OR g_trolin_rec.quantity_delivered = FND_API.G_MISS_NUM
1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR

Line 1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM

1787: OR g_trolin_rec.quantity_detailed = FND_API.G_MISS_NUM
1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR

Line 1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM

1788: OR g_trolin_rec.reason_id = FND_API.G_MISS_NUM
1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE

Line 1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR

1789: OR g_trolin_rec.reference = FND_API.G_MISS_CHAR
1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM

Line 1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR

1790: OR g_trolin_rec.reference_id = FND_API.G_MISS_NUM
1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM

Line 1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR

1791: OR g_trolin_rec.reference_type_code = FND_API.G_MISS_NUM
1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM

Line 1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE

1792: OR g_trolin_rec.request_id = FND_API.G_MISS_NUM
1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char

Line 1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM

1793: OR g_trolin_rec.revision = FND_API.G_MISS_CHAR
1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM

Line 1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM

1794: OR g_trolin_rec.serial_number_end = FND_API.G_MISS_CHAR
1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM

Line 1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM

1795: OR g_trolin_rec.serial_number_start = FND_API.G_MISS_CHAR
1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR

Line 1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char

1796: OR g_trolin_rec.status_date = FND_API.G_MISS_DATE
1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM

Line 1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM

1797: OR g_trolin_rec.task_id = FND_API.G_MISS_NUM
1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM

Line 1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM

1798: OR g_trolin_rec.to_account_id = FND_API.G_MISS_NUM
1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM

Line 1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR

1799: OR g_trolin_rec.to_locator_id = FND_API.G_MISS_NUM
1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM

Line 1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM

1800: OR g_trolin_rec.to_subinventory_code = FND_API.g_miss_char
1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM

Line 1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM

1801: OR g_trolin_rec.to_subinventory_id = FND_API.G_MISS_NUM
1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM

Line 1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM

1802: OR g_trolin_rec.transaction_header_id = FND_API.G_MISS_NUM
1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM

Line 1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM

1803: OR g_trolin_rec.uom_code = FND_API.G_MISS_CHAR
1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM

Line 1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM

1804: OR g_trolin_rec.transaction_type_id = FND_API.G_MISS_NUM
1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM

Line 1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM

1805: OR g_trolin_rec.transaction_source_type_id = FND_API.G_MISS_NUM
1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR

Line 1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM

1806: OR g_trolin_rec.txn_source_id = FND_API.G_MISS_NUM
1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM

Line 1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM

1807: OR g_trolin_rec.txn_source_line_id = FND_API.G_MISS_NUM
1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM

Line 1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM

1808: OR g_trolin_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM
1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM

Line 1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR

1809: OR g_trolin_rec.primary_quantity = FND_API.G_MISS_NUM
1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM

Line 1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM

1810: OR g_trolin_rec.to_organization_id = FND_API.G_MISS_NUM
1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM

Line 1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM

1811: OR g_trolin_rec.pick_strategy_id = FND_API.G_MISS_NUM
1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM

Line 1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM

1812: OR g_trolin_rec.put_away_strategy_id = FND_API.G_MISS_NUM
1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM

Line 1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM

1813: OR g_trolin_Rec.unit_number = FND_API.G_MISS_CHAR
1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV

Line 1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM

1814: OR g_trolin_rec.from_cost_group_id = FND_API.G_MISS_NUM
1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR

Line 1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM

1815: OR g_trolin_rec.to_cost_group_id = FND_API.G_MISS_NUM
1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR

Line 1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM

1816: OR g_trolin_rec.lpn_id = FND_API.G_MISS_NUM
1817: OR g_trolin_rec.to_lpn_id = FND_API.G_MISS_NUM
1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM

Line 1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR

1818: OR g_trolin_rec.pick_methodology_id = FND_API.G_MISS_NUM
1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM

Line 1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR

1819: OR g_trolin_rec.container_item_id = FND_API.G_MISS_NUM
1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1827: --INVCONV

Line 1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM

1820: OR g_trolin_rec.carton_grouping_id = FND_API.G_MISS_NUM
1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1827: --INVCONV
1828: THEN

Line 1825: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM

1821: --INVCONV
1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1827: --INVCONV
1828: THEN
1829:

Line 1826: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM

1822: OR g_trolin_rec.secondary_uom = FND_API.G_MISS_CHAR
1823: OR g_trolin_rec.grade_code = FND_API.G_MISS_CHAR
1824: OR g_trolin_rec.secondary_quantity = FND_API.G_MISS_NUM
1825: OR g_trolin_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM
1826: OR g_trolin_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM
1827: --INVCONV
1828: THEN
1829:
1830: INV_Default_Trolin.Attributes