eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_CCEOI_ACTION_PVT dependencies on MTL_CCEOI_VAR_PVT

Line 19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,

15: PROCEDURE Process_Error(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18: p_commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
20: p_message_name IN MTL_CC_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE,
21: p_error_column_name IN MTL_CC_INTERFACE_ERRORS.ERROR_COLUMN_NAME%TYPE,
22: p_error_table_name IN MTL_CC_INTERFACE_ERRORS.ERROR_TABLE_NAME%TYPE,
23: p_flags IN VARCHAR2,

Line 59: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN

55:
56: FND_MESSAGE.SET_NAME('INV', p_message_name);
57: FND_MSG_PUB.Add;
58:
59: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
60:
61: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
62: p_interface_rec=> p_interface_rec,
63: x_return_status => x_return_status);

Line 79: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

75: p_api_version => 0.9,
76: x_return_status => x_return_status,
77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,
79: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
80: p_flags => p_flags);
81:
82: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
83: -- TODO: post FND message about not being able to set flags

Line 90: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

86:
87: --
88: -- Write INTO Error TABLE
89: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
90: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
91: p_error_column_name => p_error_column_name,
92: p_error_table_name => p_error_table_name,
93: p_message_name => p_message_name );
94: --

Line 156: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

152: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
153: x_return_status OUT NOCOPY VARCHAR2 ,
154: x_msg_count OUT NOCOPY NUMBER ,
155: x_msg_data OUT NOCOPY VARCHAR2 ,
156: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
157: IS
158: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
159: BEGIN
160: -- Start OF comments

Line 303: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

299: x_return_status OUT NOCOPY VARCHAR2 ,
300: x_msg_count OUT NOCOPY NUMBER ,
301: x_msg_data OUT NOCOPY VARCHAR2 ,
302: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
303: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
304: IS
305: L_api_version CONSTANT NUMBER := 0.9;
306: L_api_name CONSTANT VARCHAR2(30) := 'Create_CountRequest';
307: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 407: MDEBUG( 'Process: Begin Unsch? '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY));

403: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
404:
405: --
406: IF (l_debug = 1) THEN
407: MDEBUG( 'Process: Begin Unsch? '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY));
408: END IF;
409:
410: -- Unscheduled entries NOT allowed
411: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2 THEN

Line 411: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2 THEN

407: MDEBUG( 'Process: Begin Unsch? '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY));
408: END IF;
409:
410: -- Unscheduled entries NOT allowed
411: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2 THEN
412: --
413: IF (l_debug = 1) THEN
414: MDEBUG( 'Process: No Unsch ');
415: END IF;

Line 434: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = TRUE THEN

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: RAISE FND_API.G_EXC_ERROR;
432: --
433: -- Validation ok AND OPEN request exists
434: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = TRUE THEN
435: --
436:
437: IF (l_debug = 1) THEN
438: MDEBUG( 'Process: No Unsch -Open Request ');

Line 463: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_TYPE_CODE := 2;

459: MDEBUG( 'Create_CountRequest: Inserting CC Request');
460: END IF;
461:
462: -- set unscheduled count type code
463: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_TYPE_CODE := 2;
464:
465: -- create count request if not in simulation mode
466: IF (p_simulate = FND_API.G_FALSE) THEN
467:

Line 474: l_interface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE :=

470: MTL_CCEOI_PROCESS_PVT.Insert_CCEntry(
471: p_interface_rec=> p_interface_rec);
472:
473: declare
474: l_interface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE :=
475: p_interface_rec;
476: l_cycle_count_entry_id number :=
477: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID;
478: begin

Line 477: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID;

473: declare
474: l_interface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE :=
475: p_interface_rec;
476: l_cycle_count_entry_id number :=
477: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID;
478: begin
479:
480: -- make sure we save id's inside interface record because
481: -- open interface forms only works with id's

Line 483: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;

479:
480: -- make sure we save id's inside interface record because
481: -- open interface forms only works with id's
482: l_interface_rec.inventory_item_id :=
483: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;
484: l_interface_rec.locator_id := MTL_CCEOI_VAR_PVT.G_LOCATOR_ID;
485:
486: l_interface_rec.cycle_count_header_id :=
487: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;

Line 484: l_interface_rec.locator_id := MTL_CCEOI_VAR_PVT.G_LOCATOR_ID;

480: -- make sure we save id's inside interface record because
481: -- open interface forms only works with id's
482: l_interface_rec.inventory_item_id :=
483: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;
484: l_interface_rec.locator_id := MTL_CCEOI_VAR_PVT.G_LOCATOR_ID;
485:
486: l_interface_rec.cycle_count_header_id :=
487: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
488:

Line 487: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;

483: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID;
484: l_interface_rec.locator_id := MTL_CCEOI_VAR_PVT.G_LOCATOR_ID;
485:
486: l_interface_rec.cycle_count_header_id :=
487: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
488:
489: l_interface_rec.count_list_sequence :=
490: nvl(p_interface_rec.COUNT_LIST_SEQUENCE,
491: MTL_CCEOI_VAR_PVT.G_Seq_No);

Line 491: MTL_CCEOI_VAR_PVT.G_Seq_No);

487: MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
488:
489: l_interface_rec.count_list_sequence :=
490: nvl(p_interface_rec.COUNT_LIST_SEQUENCE,
491: MTL_CCEOI_VAR_PVT.G_Seq_No);
492:
493: l_interface_rec.cycle_count_entry_id := null;
494:
495: -- update CCI entry with cycle count entry id

Line 518: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

514: end;
515:
516: END IF;
517:
518: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
519: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
520: p_api_version => 0.9,
521: x_return_status => x_return_status,
522: x_msg_count => x_msg_count,

Line 524: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

520: p_api_version => 0.9,
521: x_return_status => x_return_status,
522: x_msg_count => x_msg_count,
523: x_msg_data => x_msg_data,
524: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
525: p_flags => '2$0$');
526: -- the flag means no errors, successful processed
527: END IF; -- if record is in system
528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 599: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

595: x_return_status OUT NOCOPY VARCHAR2 ,
596: x_msg_count OUT NOCOPY NUMBER ,
597: x_msg_data OUT NOCOPY VARCHAR2 ,
598: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
599: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
600: IS
601: L_error_code NUMBER;
602: --
603: L_api_version CONSTANT NUMBER := 0.9;

Line 652: --MDEBUG( 'Process: CCEId '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID));

648: -- Initial version 0.9
649: -- Notes : Note text
650: -- END OF comments
651:
652: --MDEBUG( 'Process: CCEId '||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID));
653: -- Standard start of API savepoint
654: SAVEPOINT Process_CountRequest;
655: --
656: -- Standard Call to check for call compatibility

Line 704: IF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE

700: , p_interface_rec => p_interface_rec
701: );
702:
703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
704: IF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE
705: AND MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2
706: THEN
707: IF (l_debug = 1) THEN
708: MDEBUG('Process: After Validate in Process NOSCHED');

Line 705: AND MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2

701: );
702:
703: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
704: IF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE
705: AND MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=2
706: THEN
707: IF (l_debug = 1) THEN
708: MDEBUG('Process: After Validate in Process NOSCHED');
709: END IF;

Line 725: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE AND

721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724:
725: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE AND
726: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=1
727: THEN
728:
729: IF (l_debug = 1) THEN

Line 726: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=1

722: END IF;
723: RAISE FND_API.G_EXC_ERROR;
724:
725: ELSIF MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST = FALSE AND
726: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.UNSCHEDULED_COUNT_ENTRY=1
727: THEN
728:
729: IF (l_debug = 1) THEN
730: MDEBUG('Process : Create Unscheduled Entries');

Line 787: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

783: mdebug('Return status success while there are errors in the table');
784: END IF;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: /*
787: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
788: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
789: p_api_version => 0.9,
790: x_return_status => x_return_status,
791: x_msg_count => x_msg_count,

Line 794: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

790: x_return_status => x_return_status,
791: x_msg_count => x_msg_count,
792: x_msg_data => x_msg_data,
793: p_cc_entry_interface_id =>
794: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
795: p_flags => '1$22');
796:
797: END IF;
798:

Line 802: IF MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE = 3

798:
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: */
801: ELSE
802: IF MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE = 3
803: THEN
804: -- Added by suresh
805: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
806: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(

Line 805: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

801: ELSE
802: IF MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE = 3
803: THEN
804: -- Added by suresh
805: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
806: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
807: p_api_version => 0.9,
808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,

Line 812: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,
810: x_msg_data => x_msg_data,
811: p_cc_entry_interface_id =>
812: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
813: p_flags => '2$3$');
814: END IF;
815:
816: ELSE

Line 818: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

814: END IF;
815:
816: ELSE
817:
818: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
819: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
820: p_api_version => 0.9,
821: x_return_status => x_return_status,
822: x_msg_count => x_msg_count,

Line 825: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

821: x_return_status => x_return_status,
822: x_msg_count => x_msg_count,
823: x_msg_data => x_msg_data,
824: p_cc_entry_interface_id=>
825: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
826: p_flags => '2$0$');
827: END IF;
828:
829: END IF;

Line 835: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is NULL THEN

831: IF (p_simulate = FND_API.G_FALSE) THEN
832:
833: -- XXX this is leftover from previous poor error
834: -- processing. This line should go
835: IF MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is NULL THEN
836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END IF;
838:
839: MTL_CCEOI_PROCESS_PVT.Update_CCEntry(

Line 840: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID);

836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
837: END IF;
838:
839: MTL_CCEOI_PROCESS_PVT.Update_CCEntry(
840: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID);
841:
842: END IF;
843:
844: END IF;

Line 944: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

940: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_NONE,
941: x_return_status OUT NOCOPY VARCHAR2 ,
942: x_msg_count OUT NOCOPY NUMBER ,
943: x_msg_data OUT NOCOPY VARCHAR2 ,
944: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
945: IS
946: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
947: BEGIN
948: -- Start OF comments

Line 992: L_inventory_rec MTL_CCEOI_VAR_PVT.Inv_Item_rec_type;

988: -- Initial version 0.9
989: -- Notes : Note text
990: -- END OF comments
991: DECLARE
992: L_inventory_rec MTL_CCEOI_VAR_PVT.Inv_Item_rec_type;
993: L_sku_rec MTL_CCEOI_VAR_PVT.INV_SKU_REC_TYPE;
994: L_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE;
995: L_subinventory MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY%TYPE;
996: l_derivable_item_sku BOOLEAN := TRUE;

Line 993: L_sku_rec MTL_CCEOI_VAR_PVT.INV_SKU_REC_TYPE;

989: -- Notes : Note text
990: -- END OF comments
991: DECLARE
992: L_inventory_rec MTL_CCEOI_VAR_PVT.Inv_Item_rec_type;
993: L_sku_rec MTL_CCEOI_VAR_PVT.INV_SKU_REC_TYPE;
994: L_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE;
995: L_subinventory MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY%TYPE;
996: l_derivable_item_sku BOOLEAN := TRUE;
997: L_errorcode NUMBER := 0;

Line 994: L_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE;

990: -- END OF comments
991: DECLARE
992: L_inventory_rec MTL_CCEOI_VAR_PVT.Inv_Item_rec_type;
993: L_sku_rec MTL_CCEOI_VAR_PVT.INV_SKU_REC_TYPE;
994: L_locator_rec MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE;
995: L_subinventory MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY%TYPE;
996: l_derivable_item_sku BOOLEAN := TRUE;
997: L_errorcode NUMBER := 0;
998: L_return_status VARCHAR2(30);

Line 1050: if (p_interface_rec.action_code = mtl_cceoi_var_pvt.g_valsim) then

1046: --
1047:
1048: -- determine whether this is a simulation run in which we
1049: -- shall not modify non-interface related tables
1050: if (p_interface_rec.action_code = mtl_cceoi_var_pvt.g_valsim) then
1051: l_simulate := fnd_api.g_true;
1052: else
1053: l_simulate := fnd_api.g_false;
1054: end if;

Line 1072: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=

1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070:
1071: -- Current processed interface RECORD
1072: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=
1073: p_interface_rec.cc_entry_interface_id;
1074: --
1075: IF (l_debug = 1) THEN
1076: MDEBUG( 'G_CC_ENTRY_INTERFACE_ID ='|| MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID);

Line 1076: MDEBUG( 'G_CC_ENTRY_INTERFACE_ID ='|| MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID);

1072: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=
1073: p_interface_rec.cc_entry_interface_id;
1074: --
1075: IF (l_debug = 1) THEN
1076: MDEBUG( 'G_CC_ENTRY_INTERFACE_ID ='|| MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID);
1077: END IF;
1078:
1079:
1080:

Line 1117: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,

1113: x_msg_count => x_msg_count,
1114: x_msg_data => x_msg_data,
1115: X_ErrorCode => L_errorcode,
1116: -- p_cycle_count_header_id => p_interface_rec.cycle_count_header_id,
1117: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,
1118: p_cycle_count_entry_id => p_interface_rec.cycle_count_entry_id,
1119: p_count_list_sequence => p_interface_rec.count_list_sequence,
1120: p_organization_id =>
1121: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID

Line 1121: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID

1117: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,
1118: p_cycle_count_entry_id => p_interface_rec.cycle_count_entry_id,
1119: p_count_list_sequence => p_interface_rec.count_list_sequence,
1120: p_organization_id =>
1121: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1122: -- p_organization_id => p_interface_rec.organization_id
1123: );
1124: --
1125: IF (l_debug = 1) THEN

Line 1130: MTL_CCEOI_VAR_PVT.G_Seq_No := p_interface_rec.count_list_sequence ;

1126: mdebug('Return Sequence Count List='||L_return_status);
1127: END IF;
1128:
1129: -- this is added for unschedule entry
1130: MTL_CCEOI_VAR_PVT.G_Seq_No := p_interface_rec.count_list_sequence ;
1131: IF L_errorcode = 65 then -- NEW NULL count_list_sequence
1132: begin
1133: l_derivable_item_sku := FALSE;
1134:

Line 1137: into MTL_CCEOI_VAR_PVT.G_Seq_No

1133: l_derivable_item_sku := FALSE;
1134:
1135:
1136: select next_user_count_sequence
1137: into MTL_CCEOI_VAR_PVT.G_Seq_No
1138: FROM mtl_cycle_count_headers where
1139: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
1140:
1141:

Line 1139: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;

1135:
1136: select next_user_count_sequence
1137: into MTL_CCEOI_VAR_PVT.G_Seq_No
1138: FROM mtl_cycle_count_headers where
1139: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
1140:
1141:
1142: -- the following piece of code makes sure that count list sequence
1143: -- which we just derived is not conflicting with another already

Line 1147: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No - 1;

1143: -- which we just derived is not conflicting with another already
1144: -- existing count list sequence that is still not closed
1145: -- (not counted, counted, waiting for approval, marked for recount)
1146: l_same_seq_not_closed_entries := 1;
1147: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No - 1;
1148:
1149: while (l_same_seq_not_closed_entries <> 0) loop
1150: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No + 1;
1151: select count(*)

Line 1150: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No + 1;

1146: l_same_seq_not_closed_entries := 1;
1147: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No - 1;
1148:
1149: while (l_same_seq_not_closed_entries <> 0) loop
1150: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No + 1;
1151: select count(*)
1152: into l_same_seq_not_closed_entries
1153: from mtl_cycle_count_entries
1154: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No

Line 1154: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No

1150: MTL_CCEOI_VAR_PVT.G_Seq_No := MTL_CCEOI_VAR_PVT.G_Seq_No + 1;
1151: select count(*)
1152: into l_same_seq_not_closed_entries
1153: from mtl_cycle_count_entries
1154: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No
1155: and cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID
1156: and entry_status_code not in (4, 5);
1157: IF (l_debug = 1) THEN
1158: mdebug(l_same_seq_not_closed_entries||' not processed requests found for count list sequence=' || MTL_CCEOI_VAR_PVT.G_Seq_No);

Line 1155: and cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID

1151: select count(*)
1152: into l_same_seq_not_closed_entries
1153: from mtl_cycle_count_entries
1154: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No
1155: and cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID
1156: and entry_status_code not in (4, 5);
1157: IF (l_debug = 1) THEN
1158: mdebug(l_same_seq_not_closed_entries||' not processed requests found for count list sequence=' || MTL_CCEOI_VAR_PVT.G_Seq_No);
1159: END IF;

Line 1158: mdebug(l_same_seq_not_closed_entries||' not processed requests found for count list sequence=' || MTL_CCEOI_VAR_PVT.G_Seq_No);

1154: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No
1155: and cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID
1156: and entry_status_code not in (4, 5);
1157: IF (l_debug = 1) THEN
1158: mdebug(l_same_seq_not_closed_entries||' not processed requests found for count list sequence=' || MTL_CCEOI_VAR_PVT.G_Seq_No);
1159: END IF;
1160: end loop;
1161:
1162: --

Line 1164: MDEBUG( 'Create New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));

1160: end loop;
1161:
1162: --
1163: IF (l_debug = 1) THEN
1164: MDEBUG( 'Create New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1165: END IF;
1166: --
1167: update mtl_cycle_count_headers
1168: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1

Line 1168: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1

1164: MDEBUG( 'Create New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1165: END IF;
1166: --
1167: update mtl_cycle_count_headers
1168: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1
1169: where cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1170: L_errorcode := 0;
1171: L_return_status := FND_API.G_RET_STS_SUCCESS ;
1172: exception

Line 1179: MDEBUG( 'Existing New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));

1175: ELSIF L_errorcode = 66 then -- new count_list_sequence not found in CCE
1176: L_errorcode := 0;
1177: L_return_status := FND_API.G_RET_STS_SUCCESS ;
1178: IF (l_debug = 1) THEN
1179: MDEBUG( 'Existing New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1180: END IF;
1181: l_derivable_item_sku := FALSE;
1182: END IF;
1183: IF (l_debug = 1) THEN

Line 1184: MDEBUG( 'New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));

1180: END IF;
1181: l_derivable_item_sku := FALSE;
1182: END IF;
1183: IF (l_debug = 1) THEN
1184: MDEBUG( 'New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1185: END IF;
1186: -- Else condition is introduced by suresh to errored out with correct status
1187: IF L_errorcode <>0 AND L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1188: IF (l_debug = 1) THEN

Line 1258: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.inventory_item_id;

1254: MDEBUG('Validate_CountRequest: Derived item id: ' || L_INVENTORY_REC.inventory_item_id);
1255: END IF;
1256:
1257: l_inventory_rec.inventory_item_id :=
1258: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.inventory_item_id;
1259:
1260: l_sku_rec.revision :=
1261: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.REVISION;
1262:

Line 1261: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.REVISION;

1257: l_inventory_rec.inventory_item_id :=
1258: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.inventory_item_id;
1259:
1260: l_sku_rec.revision :=
1261: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.REVISION;
1262:
1263: l_sku_rec.lot_number :=
1264: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.LOT_NUMBER;
1265:

Line 1264: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.LOT_NUMBER;

1260: l_sku_rec.revision :=
1261: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.REVISION;
1262:
1263: l_sku_rec.lot_number :=
1264: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.LOT_NUMBER;
1265:
1266: l_sku_rec.serial_number :=
1267: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.SERIAL_NUMBER;
1268:

Line 1267: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.SERIAL_NUMBER;

1263: l_sku_rec.lot_number :=
1264: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.LOT_NUMBER;
1265:
1266: l_sku_rec.serial_number :=
1267: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.SERIAL_NUMBER;
1268:
1269: l_locator_rec.locator_id :=
1270: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;
1271:

Line 1270: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;

1266: l_sku_rec.serial_number :=
1267: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.SERIAL_NUMBER;
1268:
1269: l_locator_rec.locator_id :=
1270: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;
1271:
1272: l_subinventory :=
1273: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.subinventory;
1274:

Line 1273: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.subinventory;

1269: l_locator_rec.locator_id :=
1270: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;
1271:
1272: l_subinventory :=
1273: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.subinventory;
1274:
1275: END IF; -- IF l_derivable_item_sku = FALSE
1276:
1277:

Line 1289: p_cycle_count_header_id => mtl_cceoi_var_pvt.g_cc_header_id,

1285: x_return_status => L_return_status,
1286: x_msg_count => x_msg_count,
1287: x_msg_data => x_msg_data,
1288: x_ErrorCode => L_errorcode,
1289: p_cycle_count_header_id => mtl_cceoi_var_pvt.g_cc_header_id,
1290: p_inventory_item_rec => L_inventory_rec,
1291: p_sku_rec => L_sku_rec,
1292: p_subinventory => L_subinventory,
1293: p_locator_rec => L_locator_rec,

Line 1295: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,

1291: p_sku_rec => L_sku_rec,
1292: p_subinventory => L_subinventory,
1293: p_locator_rec => L_locator_rec,
1294: p_organization_id =>
1295: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,
1296: p_simulate => l_simulate
1297: -- p_organization_id => p_interface_rec.organization_id
1298: );
1299: --

Line 1317: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,

1313:
1314: -- BEGIN INVCONV
1315: OPEN cur_get_item_attr
1316: (
1317: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1318: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1319: );
1320:
1321: FETCH cur_get_item_attr

Line 1318: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID

1314: -- BEGIN INVCONV
1315: OPEN cur_get_item_attr
1316: (
1317: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1318: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1319: );
1320:
1321: FETCH cur_get_item_attr
1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,

Line 1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,

1318: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1319: );
1320:
1321: FETCH cur_get_item_attr
1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1323: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1324: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1325: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1326: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;

Line 1323: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,

1319: );
1320:
1321: FETCH cur_get_item_attr
1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1323: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1324: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1325: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1326: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1327:

Line 1324: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,

1320:
1321: FETCH cur_get_item_attr
1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1323: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1324: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1325: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1326: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1327:
1328: CLOSE cur_get_item_attr;

Line 1325: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,

1321: FETCH cur_get_item_attr
1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1323: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1324: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1325: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1326: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1327:
1328: CLOSE cur_get_item_attr;
1329: -- END INVCONV

Line 1326: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;

1322: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1323: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1324: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1325: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1326: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1327:
1328: CLOSE cur_get_item_attr;
1329: -- END INVCONV
1330:

Line 1346: mdebug('ORGANIZATION_ID'||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID));

1342: mdebug('L_errorcode'||to_char(L_errorcode));
1343: mdebug('PrQTY'||to_char(p_interface_rec.primary_uom_quantity));
1344: mdebug('count_uom'||p_interface_rec.count_uom);
1345: mdebug('count_unit_of_measure'||p_interface_rec.count_unit_of_measure);
1346: mdebug('ORGANIZATION_ID'||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID));
1347: mdebug('NVENTORY_ITEM_ID'||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID));
1348: mdebug('count_quantity'||to_char(p_interface_rec.count_quantity));
1349: mdebug('SERIAL_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER);
1350: mdebug('subinventory'||p_interface_rec.subinventory);

Line 1347: mdebug('NVENTORY_ITEM_ID'||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID));

1343: mdebug('PrQTY'||to_char(p_interface_rec.primary_uom_quantity));
1344: mdebug('count_uom'||p_interface_rec.count_uom);
1345: mdebug('count_unit_of_measure'||p_interface_rec.count_unit_of_measure);
1346: mdebug('ORGANIZATION_ID'||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID));
1347: mdebug('NVENTORY_ITEM_ID'||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID));
1348: mdebug('count_quantity'||to_char(p_interface_rec.count_quantity));
1349: mdebug('SERIAL_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER);
1350: mdebug('subinventory'||p_interface_rec.subinventory);
1351: mdebug('REVISION'||MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION);

Line 1349: mdebug('SERIAL_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER);

1345: mdebug('count_unit_of_measure'||p_interface_rec.count_unit_of_measure);
1346: mdebug('ORGANIZATION_ID'||to_char(MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID));
1347: mdebug('NVENTORY_ITEM_ID'||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID));
1348: mdebug('count_quantity'||to_char(p_interface_rec.count_quantity));
1349: mdebug('SERIAL_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER);
1350: mdebug('subinventory'||p_interface_rec.subinventory);
1351: mdebug('REVISION'||MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION);
1352: mdebug('LOT_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER);
1353: mdebug('system_quantity'||to_char(p_interface_rec.system_quantity));

Line 1351: mdebug('REVISION'||MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION);

1347: mdebug('NVENTORY_ITEM_ID'||to_char(MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID));
1348: mdebug('count_quantity'||to_char(p_interface_rec.count_quantity));
1349: mdebug('SERIAL_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER);
1350: mdebug('subinventory'||p_interface_rec.subinventory);
1351: mdebug('REVISION'||MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION);
1352: mdebug('LOT_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER);
1353: mdebug('system_quantity'||to_char(p_interface_rec.system_quantity));
1354: END IF;
1355: */ -- Check the UOM AND quantity information Step 4

Line 1352: mdebug('LOT_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER);

1348: mdebug('count_quantity'||to_char(p_interface_rec.count_quantity));
1349: mdebug('SERIAL_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER);
1350: mdebug('subinventory'||p_interface_rec.subinventory);
1351: mdebug('REVISION'||MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION);
1352: mdebug('LOT_NUMBER'||MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER);
1353: mdebug('system_quantity'||to_char(p_interface_rec.system_quantity));
1354: END IF;
1355: */ -- Check the UOM AND quantity information Step 4
1356: MTL_CCEOI_PROCESS_PVT.Validate_UOMQuantity(

Line 1366: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,

1362: p_primary_uom_quantity=>p_interface_rec.primary_uom_quantity,
1363: p_count_uom=> p_interface_rec.count_uom,
1364: p_count_unit_of_measure=>p_interface_rec.count_unit_of_measure,
1365: p_organization_id=>
1366: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,
1367: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1368: p_count_quantity=>p_interface_rec.count_quantity,
1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,
1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,

Line 1367: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,

1363: p_count_uom=> p_interface_rec.count_uom,
1364: p_count_unit_of_measure=>p_interface_rec.count_unit_of_measure,
1365: p_organization_id=>
1366: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,
1367: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1368: p_count_quantity=>p_interface_rec.count_quantity,
1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,
1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,
1371: p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION,

Line 1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,

1365: p_organization_id=>
1366: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,
1367: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1368: p_count_quantity=>p_interface_rec.count_quantity,
1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,
1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,
1371: p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION,
1372: p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER,
1373: p_system_quantity => p_interface_rec.system_quantity,

Line 1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,

1366: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,
1367: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1368: p_count_quantity=>p_interface_rec.count_quantity,
1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,
1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,
1371: p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION,
1372: p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER,
1373: p_system_quantity => p_interface_rec.system_quantity,
1374: p_secondary_system_quantity => p_interface_rec.secondary_system_quantity -- INVCONV

Line 1371: p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION,

1367: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1368: p_count_quantity=>p_interface_rec.count_quantity,
1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,
1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,
1371: p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION,
1372: p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER,
1373: p_system_quantity => p_interface_rec.system_quantity,
1374: p_secondary_system_quantity => p_interface_rec.secondary_system_quantity -- INVCONV
1375: );

Line 1372: p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER,

1368: p_count_quantity=>p_interface_rec.count_quantity,
1369: p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER,
1370: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,
1371: p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION,
1372: p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER,
1373: p_system_quantity => p_interface_rec.system_quantity,
1374: p_secondary_system_quantity => p_interface_rec.secondary_system_quantity -- INVCONV
1375: );
1376: --

Line 1401: , p_organization_id => MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID

1397: , x_return_status => l_return_status
1398: , x_msg_count => x_msg_count
1399: , x_msg_data => x_msg_data
1400: , x_errorcode => l_errorcode
1401: , p_organization_id => MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID
1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER
1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY
1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION

Line 1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID

1398: , x_msg_count => x_msg_count
1399: , x_msg_data => x_msg_data
1400: , x_errorcode => l_errorcode
1401: , p_organization_id => MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID
1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER
1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY
1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION
1406: , p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER

Line 1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER

1399: , x_msg_data => x_msg_data
1400: , x_errorcode => l_errorcode
1401: , p_organization_id => MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID
1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER
1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY
1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION
1406: , p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER
1407: , p_secondary_uom => p_interface_rec.secondary_uom

Line 1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY

1400: , x_errorcode => l_errorcode
1401: , p_organization_id => MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID
1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER
1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY
1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION
1406: , p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER
1407: , p_secondary_uom => p_interface_rec.secondary_uom
1408: , p_secondary_unit_of_measure => p_interface_rec.secondary_unit_of_measure

Line 1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION

1401: , p_organization_id => MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID
1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER
1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY
1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION
1406: , p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER
1407: , p_secondary_uom => p_interface_rec.secondary_uom
1408: , p_secondary_unit_of_measure => p_interface_rec.secondary_unit_of_measure
1409: , p_secondary_count_quantity => p_interface_rec.secondary_count_quantity

Line 1406: , p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER

1402: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID
1403: , p_serial_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.SERIAL_NUMBER
1404: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY
1405: , p_revision => MTL_CCEOI_VAR_PVT.G_SKU_REC.REVISION
1406: , p_lot_number => MTL_CCEOI_VAR_PVT.G_SKU_REC.LOT_NUMBER
1407: , p_secondary_uom => p_interface_rec.secondary_uom
1408: , p_secondary_unit_of_measure => p_interface_rec.secondary_unit_of_measure
1409: , p_secondary_count_quantity => p_interface_rec.secondary_count_quantity
1410: , p_secondary_system_quantity => p_interface_rec.secondary_system_quantity

Line 1411: , p_tracking_quantity_ind => MTL_CCEOI_VAR_PVT.G_TRACKING_QUANTITY_IND

1407: , p_secondary_uom => p_interface_rec.secondary_uom
1408: , p_secondary_unit_of_measure => p_interface_rec.secondary_unit_of_measure
1409: , p_secondary_count_quantity => p_interface_rec.secondary_count_quantity
1410: , p_secondary_system_quantity => p_interface_rec.secondary_system_quantity
1411: , p_tracking_quantity_ind => MTL_CCEOI_VAR_PVT.G_TRACKING_QUANTITY_IND
1412: , p_secondary_default_ind => MTL_CCEOI_VAR_PVT.G_SECONDARY_DEFAULT_IND
1413: );
1414:
1415: IF (l_debug = 1) THEN

Line 1412: , p_secondary_default_ind => MTL_CCEOI_VAR_PVT.G_SECONDARY_DEFAULT_IND

1408: , p_secondary_unit_of_measure => p_interface_rec.secondary_unit_of_measure
1409: , p_secondary_count_quantity => p_interface_rec.secondary_count_quantity
1410: , p_secondary_system_quantity => p_interface_rec.secondary_system_quantity
1411: , p_tracking_quantity_ind => MTL_CCEOI_VAR_PVT.G_TRACKING_QUANTITY_IND
1412: , p_secondary_default_ind => MTL_CCEOI_VAR_PVT.G_SECONDARY_DEFAULT_IND
1413: );
1414:
1415: IF (l_debug = 1) THEN
1416: mdebug('Secondary UOM Quantity Error = '||to_char(L_errorcode));

Line 1467: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

1463: --
1464: -- UPDATE the interface TABLE flags
1465: IF L_return_status = FND_API.G_RET_STS_SUCCESS
1466: AND p_validation_level=1 THEN
1467: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1468: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1469: p_api_version => 0.9,
1470: x_return_status => L_return_status,
1471: x_msg_count => x_msg_count,

Line 1473: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,

1469: p_api_version => 0.9,
1470: x_return_status => L_return_status,
1471: x_msg_count => x_msg_count,
1472: x_msg_data => x_msg_data,
1473: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,
1474: p_flags => '2$51');
1475: END IF; -- record is stored in the interface
1476: IF (l_debug = 1) THEN
1477: MDEBUG( 'Successfully Validated ');

Line 1483: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

1479: -- the flag means no errors, successful validated, valid
1480: ELSIF
1481: L_return_status = FND_API.G_RET_STS_SUCCESS
1482: AND p_validation_level=0 THEN
1483: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1484: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1485: p_api_version => 0.9,
1486: x_return_status => L_return_status,
1487: x_msg_count => x_msg_count,

Line 1489: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,

1485: p_api_version => 0.9,
1486: x_return_status => L_return_status,
1487: x_msg_count => x_msg_count,
1488: x_msg_data => x_msg_data,
1489: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,
1490: p_flags => '2$51');
1491: -- the flag means no errors,marked FOR deletion,
1492: -- successful validated, valid
1493: END IF;

Line 1499: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN

1495: MDEBUG( 'Successfully Validated-');
1496: END IF;
1497: ELSE
1498: -- IF error AND online, INSERT the interface RECORD
1499: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1500:
1501: IF (l_debug = 1) THEN
1502: MDEBUG('Inserting interface entry');
1503: END IF;

Line 1515: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,

1511: p_api_version => 0.9,
1512: x_return_status => L_return_status,
1513: x_msg_count => x_msg_count,
1514: x_msg_data => x_msg_data,
1515: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,
1516: p_flags => '1$22');
1517: IF (l_debug = 1) THEN
1518: MDEBUG( 'Processed with errors ');
1519: END IF;

Line 1583: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

1579: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1580: x_return_status OUT NOCOPY VARCHAR2 ,
1581: x_msg_count OUT NOCOPY NUMBER ,
1582: x_msg_data OUT NOCOPY VARCHAR2 ,
1583: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
1584: IS
1585: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1586: BEGIN
1587: -- Start OF comments

Line 1666: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN

1662: --
1663: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1664: --
1665: -- If online mode insert interface record first
1666: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1667: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1668: p_interface_rec => p_interface_rec,
1669: x_return_status => L_return_status);
1670: END IF;

Line 1678: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id

1674: (p_api_version => 0.9
1675: , x_return_status => L_return_status
1676: , x_msg_count => x_msg_count
1677: , x_msg_data => x_msg_data
1678: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id
1679: p_flags => '1$2$');
1680: -- error, processed with errors
1681: --
1682: ELSE

Line 1683: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

1679: p_flags => '1$2$');
1680: -- error, processed with errors
1681: --
1682: ELSE
1683: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1684: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags
1685: (p_api_version => 0.9
1686: , x_return_status => L_return_status
1687: , x_msg_count => x_msg_count

Line 1689: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id

1685: (p_api_version => 0.9
1686: , x_return_status => L_return_status
1687: , x_msg_count => x_msg_count
1688: , x_msg_data => x_msg_data
1689: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id
1690: p_flags => '2$6$');
1691: -- no error, succesfully validated and simulated
1692: END IF;
1693: END IF;

Line 1751: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

1747: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1748: x_return_status OUT NOCOPY VARCHAR2 ,
1749: x_msg_count OUT NOCOPY NUMBER ,
1750: x_msg_data OUT NOCOPY VARCHAR2 ,
1751: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
1752: IS
1753: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1754: BEGIN
1755: -- Start OF comments