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 1053: if (p_interface_rec.action_code = mtl_cceoi_var_pvt.g_valsim) then

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

Line 1075: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=

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

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

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

Line 1120: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,

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

Line 1124: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID

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

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

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

Line 1140: into MTL_CCEOI_VAR_PVT.G_Seq_No

1136: l_derivable_item_sku := FALSE;
1137:
1138:
1139: select next_user_count_sequence
1140: into MTL_CCEOI_VAR_PVT.G_Seq_No
1141: FROM mtl_cycle_count_headers where
1142: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
1143:
1144:

Line 1142: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;

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

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

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

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

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

Line 1157: where count_list_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No

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

Line 1158: and cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID

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

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

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

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

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

Line 1171: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1

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

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

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

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

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

Line 1261: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.inventory_item_id;

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

Line 1264: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.REVISION;

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

Line 1267: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.LOT_NUMBER;

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

Line 1270: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.SERIAL_NUMBER;

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

Line 1273: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;

1269: l_sku_rec.serial_number :=
1270: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.SERIAL_NUMBER;
1271:
1272: l_locator_rec.locator_id :=
1273: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;
1274:
1275: l_subinventory :=
1276: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.subinventory;
1277:

Line 1276: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.subinventory;

1272: l_locator_rec.locator_id :=
1273: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.locator_id;
1274:
1275: l_subinventory :=
1276: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.subinventory;
1277:
1278: END IF; -- IF l_derivable_item_sku = FALSE
1279:
1280:

Line 1292: p_cycle_count_header_id => mtl_cceoi_var_pvt.g_cc_header_id,

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

Line 1298: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,

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

Line 1320: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,

1316:
1317: -- BEGIN INVCONV
1318: OPEN cur_get_item_attr
1319: (
1320: MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1321: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1322: );
1323:
1324: FETCH cur_get_item_attr

Line 1321: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID

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

Line 1325: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,

1321: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID
1322: );
1323:
1324: FETCH cur_get_item_attr
1325: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1326: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1327: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1328: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1329: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;

Line 1326: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,

1322: );
1323:
1324: FETCH cur_get_item_attr
1325: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1326: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1327: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1328: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1329: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1330:

Line 1327: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,

1323:
1324: FETCH cur_get_item_attr
1325: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1326: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1327: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1328: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1329: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1330:
1331: CLOSE cur_get_item_attr;

Line 1328: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,

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

Line 1329: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;

1325: INTO MTL_CCEOI_VAR_PVT.g_tracking_quantity_ind,
1326: MTL_CCEOI_VAR_PVT.g_secondary_default_ind,
1327: MTL_CCEOI_VAR_PVT.g_secondary_uom_code,
1328: MTL_CCEOI_VAR_PVT.g_process_costing_enabled_flag,
1329: MTL_CCEOI_VAR_PVT.g_process_enabled_flag;
1330:
1331: CLOSE cur_get_item_attr;
1332: -- END INVCONV
1333:

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

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

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

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

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

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

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

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

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

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

Line 1369: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.ORGANIZATION_ID,

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

Line 1370: p_inventory_item_id=> MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,

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

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

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

Line 1373: p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY,

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

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

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

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

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

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

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

Line 1405: , p_inventory_item_id => MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID

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

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

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

Line 1407: , p_subinventory => MTL_CCEOI_VAR_PVT.G_SUBINVENTORY

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

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

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

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

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

Line 1414: , p_tracking_quantity_ind => MTL_CCEOI_VAR_PVT.G_TRACKING_QUANTITY_IND

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

Line 1415: , p_secondary_default_ind => MTL_CCEOI_VAR_PVT.G_SECONDARY_DEFAULT_IND

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

Line 1464: P_CC_ENTRY_INTERFACE_ID => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID

1460:
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462:
1463: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
1464: P_CC_ENTRY_INTERFACE_ID => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
1465: , P_ERROR_COLUMN_NAME => 'TRANSACTION_REASON_ID'
1466: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE'
1467: , p_message_name => 'INV_INT_REACODE'
1468: );

Line 1516: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

1512: --
1513: -- UPDATE the interface TABLE flags
1514: IF L_return_status = FND_API.G_RET_STS_SUCCESS
1515: AND p_validation_level=1 THEN
1516: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1517: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1518: p_api_version => 0.9,
1519: x_return_status => L_return_status,
1520: x_msg_count => x_msg_count,

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

1518: p_api_version => 0.9,
1519: x_return_status => L_return_status,
1520: x_msg_count => x_msg_count,
1521: x_msg_data => x_msg_data,
1522: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,
1523: p_flags => '2$51');
1524: END IF; -- record is stored in the interface
1525: IF (l_debug = 1) THEN
1526: MDEBUG( 'Successfully Validated ');

Line 1532: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

1528: -- the flag means no errors, successful validated, valid
1529: ELSIF
1530: L_return_status = FND_API.G_RET_STS_SUCCESS
1531: AND p_validation_level=0 THEN
1532: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1533: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
1534: p_api_version => 0.9,
1535: x_return_status => L_return_status,
1536: x_msg_count => x_msg_count,

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

1534: p_api_version => 0.9,
1535: x_return_status => L_return_status,
1536: x_msg_count => x_msg_count,
1537: x_msg_data => x_msg_data,
1538: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,
1539: p_flags => '2$51');
1540: -- the flag means no errors,marked FOR deletion,
1541: -- successful validated, valid
1542: END IF;

Line 1548: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN

1544: MDEBUG( 'Successfully Validated-');
1545: END IF;
1546: ELSE
1547: -- IF error AND online, INSERT the interface RECORD
1548: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1549:
1550: IF (l_debug = 1) THEN
1551: MDEBUG('Inserting interface entry');
1552: END IF;

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

1560: p_api_version => 0.9,
1561: x_return_status => L_return_status,
1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data,
1564: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id,
1565: p_flags => '1$22');
1566: IF (l_debug = 1) THEN
1567: MDEBUG( 'Processed with errors ');
1568: END IF;

Line 1632: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

1628: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1629: x_return_status OUT NOCOPY VARCHAR2 ,
1630: x_msg_count OUT NOCOPY NUMBER ,
1631: x_msg_data OUT NOCOPY VARCHAR2 ,
1632: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
1633: IS
1634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1635: BEGIN
1636: -- Start OF comments

Line 1715: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN

1711: --
1712: IF L_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1713: --
1714: -- If online mode insert interface record first
1715: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE THEN
1716: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
1717: p_interface_rec => p_interface_rec,
1718: x_return_status => L_return_status);
1719: END IF;

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

1723: (p_api_version => 0.9
1724: , x_return_status => L_return_status
1725: , x_msg_count => x_msg_count
1726: , x_msg_data => x_msg_data
1727: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id
1728: p_flags => '1$2$');
1729: -- error, processed with errors
1730: --
1731: ELSE

Line 1732: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN

1728: p_flags => '1$2$');
1729: -- error, processed with errors
1730: --
1731: ELSE
1732: IF MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = TRUE THEN
1733: MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags
1734: (p_api_version => 0.9
1735: , x_return_status => L_return_status
1736: , x_msg_count => x_msg_count

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

1734: (p_api_version => 0.9
1735: , x_return_status => L_return_status
1736: , x_msg_count => x_msg_count
1737: , x_msg_data => x_msg_data
1738: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID, --p_interface_rec.cc_entry_interface_id
1739: p_flags => '2$6$');
1740: -- no error, succesfully validated and simulated
1741: END IF;
1742: END IF;

Line 1800: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )

1796: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1797: x_return_status OUT NOCOPY VARCHAR2 ,
1798: x_msg_count OUT NOCOPY NUMBER ,
1799: x_msg_data OUT NOCOPY VARCHAR2 ,
1800: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
1801: IS
1802: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1803: BEGIN
1804: -- Start OF comments