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.ENG_ECO_PVT dependencies on ENG_GLOBALS

Line 126: l_rev_sub_res_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;

122: l_return_status := 'S';
123: l_bo_return_status := 'S';
124: --l_rev_sub_resource_tbl := p_rev_sub_resource_tbl;
125: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl;
126: l_rev_sub_res_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;
127:
128: FOR I IN 1..x_rev_sub_resource_tbl.COUNT LOOP
129: -- Processing records for which the return status is null
130: IF (x_rev_sub_resource_tbl(I).return_status IS NULL OR

Line 237: Eng_Globals.Transaction_Type_Validity

233: -- Process Flow step 3 : Check if transaction_type is valid
234: -- Transaction_Type must be CRATE, UPDATE, DELETE or CANCEL(in only ECO for Rrg)
235: -- Call the Bom_Rtg_Globals.Transaction_Type_Validity
236: --
237: Eng_Globals.Transaction_Type_Validity
238: ( p_transaction_type => l_rev_sub_resource_rec.transaction_type
239: , p_entity => 'Sub_Res'
240: , p_entity_id => l_rev_sub_resource_rec.Sub_Resource_Code
241: , x_valid => l_valid

Line 1500: l_rev_op_res_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;

1496: --l_rev_op_resource_tbl := p_rev_op_resource_tbl;
1497: x_rev_op_resource_tbl := p_rev_op_resource_tbl;
1498: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl;
1499:
1500: l_rev_op_res_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;
1501:
1502: FOR I IN 1..x_rev_op_resource_tbl.COUNT LOOP
1503: -- Processing records for which the return status is null
1504: IF (x_rev_op_resource_tbl(I).return_status IS NULL OR

Line 1628: Eng_Globals.Transaction_Type_Validity

1624: -- Transaction_Type must be CRATE, UPDATE, DELETE or CANCEL(in only ECO for Rrg)
1625: -- Call the Bom_Rtg_Globals.Transaction_Type_Validity
1626: --
1627:
1628: Eng_Globals.Transaction_Type_Validity
1629: ( p_transaction_type => l_rev_op_resource_rec.transaction_type
1630: , p_entity => 'Op_Res'
1631: , p_entity_id => l_rev_op_resource_rec.resource_sequence_number
1632: , x_valid => l_valid

Line 2191: IF (l_rev_op_resource_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

2187: -- Process flow step: Query the operation resource record using by Res Seq Num
2188: -- Call Bom_Res_Seq_Util.Query_Row
2189: --
2190:
2191: IF (l_rev_op_resource_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
2192: AND l_rev_op_resource_rec.acd_type IN ( 2, 3 )) -- ACD Type: Change or Disable
2193: THEN
2194:
2195: Bom_Op_Res_Util.Query_Row

Line 2210: IF l_return_status <> Eng_Globals.G_RECORD_FOUND

2206: IF Bom_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
2207: ('Query the original op res for rev op res with acd type : change or delete completed with return_status: ' || l_return_status) ;
2208: END IF ;
2209:
2210: IF l_return_status <> Eng_Globals.G_RECORD_FOUND
2211: THEN
2212: l_return_status := Error_Handler.G_STATUS_ERROR ;
2213: l_token_tbl(1).token_name := 'RES_SEQ_NUMBER';
2214: l_token_tbl(1).token_value :=

Line 2244: IF (l_rev_op_resource_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

2240:
2241: END IF;
2242:
2243:
2244: IF (l_rev_op_resource_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
2245: AND l_rev_op_resource_rec.acd_type IN ( 2, 3 ) ) -- ACD Type : Change or Disable
2246: OR
2247: l_rev_op_resource_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
2248: ENG_GLOBALS.G_OPR_DELETE)

Line 2247: l_rev_op_resource_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,

2243:
2244: IF (l_rev_op_resource_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
2245: AND l_rev_op_resource_rec.acd_type IN ( 2, 3 ) ) -- ACD Type : Change or Disable
2246: OR
2247: l_rev_op_resource_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
2248: ENG_GLOBALS.G_OPR_DELETE)
2249: THEN
2250:
2251: --

Line 2248: ENG_GLOBALS.G_OPR_DELETE)

2244: IF (l_rev_op_resource_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
2245: AND l_rev_op_resource_rec.acd_type IN ( 2, 3 ) ) -- ACD Type : Change or Disable
2246: OR
2247: l_rev_op_resource_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
2248: ENG_GLOBALS.G_OPR_DELETE)
2249: THEN
2250:
2251: --
2252: -- Process flow step 12: Populate NULL columns for Update and Delete

Line 2853: l_rev_op_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;

2849: x_rev_operation_tbl := p_rev_operation_tbl ;
2850: x_rev_op_resource_tbl := p_rev_op_resource_tbl ;
2851: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl ;
2852:
2853: l_rev_op_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;
2854:
2855:
2856: FOR I IN 1..x_rev_operation_tbl.COUNT LOOP
2857:

Line 2937: ENG_GLOBALS.Transaction_Type_Validity

2933: -- Transaction_Type must be CRATE, UPDATE, DELETE or CANCEL
2934: -- Call the Bom_Rtg_Globals.Transaction_Type_Validity
2935: --
2936:
2937: ENG_GLOBALS.Transaction_Type_Validity
2938: ( p_transaction_type => l_rev_operation_rec.transaction_type
2939: , p_entity => 'Op_Seq'
2940: , p_entity_id => l_rev_operation_rec.operation_sequence_number
2941: , x_valid => l_valid

Line 3591: IF (l_rev_operation_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3587: -- Process flow step: Query the operation record using by Old Op Seq Num
3588: -- and Old Effectivity Date Call Bom_Op_Seq_Util.Query_Row
3589: --
3590:
3591: IF (l_rev_operation_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3592: AND l_rev_operation_rec.acd_type IN (2 ,3) ) -- ACD Type: Change or Disable
3593: THEN
3594:
3595: IF l_rev_operation_rec.old_operation_sequence_number IS NULL OR

Line 3617: IF l_return_status <> Eng_Globals.G_RECORD_FOUND

3613: , x_mesg_token_tbl => l_mesg_token_tbl
3614: , x_return_status => l_return_status
3615: ) ;
3616:
3617: IF l_return_status <> Eng_Globals.G_RECORD_FOUND
3618: THEN
3619: l_return_status := Error_Handler.G_STATUS_ERROR ;
3620: l_Token_Tbl(1).token_name := 'OP_SEQ_NUMBER';
3621: l_Token_Tbl(1).token_value :=

Line 3647: IF (l_rev_operation_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

3643: END IF;
3644: END IF;
3645:
3646:
3647: IF (l_rev_operation_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3648: AND l_rev_operation_rec.acd_type IN ( 2,3 ) ) -- ACD Type : Change or Disable
3649: OR
3650: l_rev_operation_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
3651: ENG_GLOBALS.G_OPR_DELETE ,

Line 3650: l_rev_operation_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,

3646:
3647: IF (l_rev_operation_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3648: AND l_rev_operation_rec.acd_type IN ( 2,3 ) ) -- ACD Type : Change or Disable
3649: OR
3650: l_rev_operation_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
3651: ENG_GLOBALS.G_OPR_DELETE ,
3652: ENG_GLOBALS.G_OPR_CANCEL)
3653: THEN
3654:

Line 3651: ENG_GLOBALS.G_OPR_DELETE ,

3647: IF (l_rev_operation_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
3648: AND l_rev_operation_rec.acd_type IN ( 2,3 ) ) -- ACD Type : Change or Disable
3649: OR
3650: l_rev_operation_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
3651: ENG_GLOBALS.G_OPR_DELETE ,
3652: ENG_GLOBALS.G_OPR_CANCEL)
3653: THEN
3654:
3655: --

Line 3652: ENG_GLOBALS.G_OPR_CANCEL)

3648: AND l_rev_operation_rec.acd_type IN ( 2,3 ) ) -- ACD Type : Change or Disable
3649: OR
3650: l_rev_operation_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE ,
3651: ENG_GLOBALS.G_OPR_DELETE ,
3652: ENG_GLOBALS.G_OPR_CANCEL)
3653: THEN
3654:
3655: --
3656: -- Process flow step 15: Populate NULL columns for Update and Delete

Line 3941: ENG_Globals.Cancel_Operation

3937: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
3938: ('Operatin Sequence: Perform Cancel Operation . . .') ;
3939: END IF ;
3940:
3941: ENG_Globals.Cancel_Operation
3942: ( p_operation_sequence_id => l_rev_op_unexp_rec.operation_sequence_id
3943: , p_cancel_comments => l_rev_operation_rec.cancel_comments
3944: , p_op_seq_num => l_rev_operation_rec.operation_sequence_number
3945: , p_user_id => BOM_Rtg_Globals.Get_User_Id

Line 3958: ENG_Globals.Perform_Writes_For_Primary_Rtg

3954: ('Cancel Operation is completed with return status ' || l_return_status ) ;
3955: END IF ;
3956:
3957: ELSE
3958: ENG_Globals.Perform_Writes_For_Primary_Rtg
3959: ( p_rev_operation_rec => l_rev_operation_rec
3960: , p_rev_op_unexp_rec => l_rev_op_unexp_rec
3961: , x_mesg_token_tbl => l_mesg_token_tbl
3962: , x_return_status => l_return_status

Line 4482: l_sub_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;

4478: -- Init local table variables.
4479:
4480: x_sub_component_tbl := p_sub_component_tbl;
4481:
4482: l_sub_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
4483:
4484: FOR I IN 1..x_sub_component_tbl.COUNT LOOP
4485:
4486: IF (x_sub_component_tbl(I).return_status IS NULL OR

Line 4584: ENG_GLOBALS.Transaction_Type_Validity

4580: -- Check if transaction_type is valid
4581: --
4582:
4583: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
4584: ENG_GLOBALS.Transaction_Type_Validity
4585: ( p_transaction_type => l_sub_component_rec.transaction_type
4586: , p_entity => 'Sub_Comps'
4587: , p_entity_id => l_sub_component_rec.revised_item_name
4588: , x_valid => l_valid

Line 4898: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

4894: --
4895:
4896: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation'); END IF;
4897: IF l_sub_component_rec.Transaction_Type IN
4898: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
4899: THEN
4900: Bom_Validate_Sub_Component.Check_Attributes
4901: ( x_return_status => l_return_status
4902: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4941: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

4937: END IF;
4938: END IF;
4939:
4940: IF l_sub_component_rec.Transaction_Type IN
4941: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
4942: THEN
4943:
4944: -- Process flow step 13 - Populate NULL columns for Update and
4945: -- Delete.

Line 4957: ELSIF l_sub_component_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

4953: , x_sub_component_rec => l_sub_component_rec
4954: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec
4955: );
4956:
4957: ELSIF l_sub_component_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
4958:
4959: -- Process Flow step 14: Default missing values for Operation CREATE
4960: --
4961:

Line 5387: l_ref_desg_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;

5383:
5384: x_ref_designator_tbl := p_ref_designator_tbl;
5385: x_sub_component_tbl := p_sub_component_tbl;
5386:
5387: l_ref_desg_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
5388:
5389: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Within processing Ref Designators . . . '); END IF;
5390:
5391:

Line 5507: ENG_GLOBALS.Transaction_Type_Validity

5503:
5504: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
5505:
5506:
5507: ENG_GLOBALS.Transaction_Type_Validity
5508: ( p_transaction_type => l_ref_designator_rec.transaction_type
5509: , p_entity => 'Ref_Desgs'
5510: , p_entity_id => l_ref_designator_rec.revised_item_name
5511: , x_valid => l_valid

Line 5809: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

5805:
5806: END IF;
5807:
5808: IF l_ref_designator_rec.transaction_type IN
5809: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
5810: THEN
5811:
5812: -- Process flow step 11 - Populate NULL columns for Update and
5813: -- Delete.

Line 6214: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;

6210: l_bo_return_status := FND_API.G_RET_STS_SUCCESS;
6211: x_return_status := FND_API.G_RET_STS_SUCCESS;
6212: x_ref_designator_tbl := p_ref_designator_tbl;
6213: x_sub_component_tbl := p_sub_component_tbl;
6214: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
6215:
6216: BEGIN
6217:
6218: --

Line 6310: ENG_GLOBALS.Transaction_Type_Validity

6306: l_rev_component_rec.start_effective_date := p_effectivity_date;
6307: END IF;
6308:
6309: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
6310: ENG_GLOBALS.Transaction_Type_Validity
6311: ( p_transaction_type => l_rev_component_rec.transaction_type
6312: , p_entity => 'Rev_Comps'
6313: , p_entity_id => l_rev_component_rec.revised_item_name
6314: , x_valid => l_valid

Line 6746: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

6742: --
6743:
6744: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation'); END IF;
6745: IF l_rev_component_rec.Transaction_Type IN
6746: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
6747: THEN
6748: Bom_Validate_Bom_Component.Check_Attributes
6749: ( x_return_status => l_return_status
6750: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 6798: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

6794: );
6795: END IF;
6796: END IF;
6797:
6798: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
6799: AND l_rev_component_rec.acd_type IN ( 2, 3 ))
6800: THEN
6801:
6802: Bom_Bom_Component_Util.Query_Row

Line 6824: IF l_return_status <> Eng_Globals.G_RECORD_FOUND

6820: l_mesg_token_tbl
6821: , x_mesg_token_tbl => l_mesg_token_tbl
6822: );
6823:
6824: IF l_return_status <> Eng_Globals.G_RECORD_FOUND
6825: THEN
6826: l_return_status := Error_Handler.G_STATUS_ERROR ;
6827: l_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
6828: l_Token_Tbl(1).token_value := l_rev_component_rec.component_item_name;

Line 6853: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

6849:
6850: -- Process flow step 15 - Populate NULL columns for Update and
6851: -- Delete, and Creates with ACD_Type 'Add'.
6852:
6853: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
6854: AND l_rev_component_rec.acd_type = 2)
6855: OR
6856: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,
6857: ENG_GLOBALS.G_OPR_DELETE)

Line 6856: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,

6852:
6853: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
6854: AND l_rev_component_rec.acd_type = 2)
6855: OR
6856: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,
6857: ENG_GLOBALS.G_OPR_DELETE)
6858: THEN
6859: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populate NULL columns'); END IF;
6860: Bom_Default_Bom_Component.Populate_Null_Columns

Line 6857: ENG_GLOBALS.G_OPR_DELETE)

6853: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
6854: AND l_rev_component_rec.acd_type = 2)
6855: OR
6856: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,
6857: ENG_GLOBALS.G_OPR_DELETE)
6858: THEN
6859: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populate NULL columns'); END IF;
6860: Bom_Default_Bom_Component.Populate_Null_Columns
6861: ( p_rev_component_rec => l_rev_Component_Rec

Line 6869: ELSIF l_rev_component_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

6865: , x_rev_Component_Rec => l_rev_Component_Rec
6866: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec
6867: );
6868:
6869: ELSIF l_rev_component_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
6870:
6871: -- Process Flow step 16: Default missing values for Operation CREATE
6872: --
6873:

Line 6927: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

6923: --
6924:
6925: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
6926: IF l_rev_component_rec.Transaction_Type IN
6927: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
6928: THEN
6929: Bom_Default_Bom_Component.Entity_Defaulting
6930: ( p_rev_component_rec => l_rev_component_rec
6931: , p_old_rev_component_rec => l_old_rev_component_rec

Line 7560: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;

7556: x_rev_component_tbl := p_rev_component_tbl;
7557: x_ref_designator_tbl := p_ref_designator_tbl;
7558: x_sub_component_tbl := p_sub_component_tbl;
7559:
7560: l_rev_comp_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
7561:
7562: FOR I IN 1..x_rev_component_tbl.COUNT LOOP
7563: IF (x_rev_component_tbl(I).return_status IS NULL OR
7564: x_rev_component_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

Line 7660: ENG_GLOBALS.Transaction_Type_Validity

7656: l_rev_component_rec.start_effective_date := p_effectivity_date;
7657: END IF;
7658:
7659: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
7660: ENG_GLOBALS.Transaction_Type_Validity
7661: ( p_transaction_type => l_rev_component_rec.transaction_type
7662: , p_entity => 'Rev_Comps'
7663: , p_entity_id => l_rev_component_rec.revised_item_name
7664: , x_valid => l_valid

Line 8094: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

8090: --
8091:
8092: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation'); END IF;
8093: IF l_rev_component_rec.Transaction_Type IN
8094: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
8095: THEN
8096: Bom_Validate_Bom_Component.Check_Attributes
8097: ( x_return_status => l_return_status
8098: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 8146: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

8142: );
8143: END IF;
8144: END IF;
8145:
8146: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
8147: AND l_rev_component_rec.acd_type IN ( 2, 3 ))
8148: THEN
8149:
8150: Bom_Bom_Component_Util.Query_Row

Line 8172: IF l_return_status <> Eng_Globals.G_RECORD_FOUND

8168: l_mesg_token_tbl
8169: , x_mesg_token_tbl => l_mesg_token_tbl
8170: );
8171:
8172: IF l_return_status <> Eng_Globals.G_RECORD_FOUND
8173: THEN
8174: l_return_status := Error_Handler.G_STATUS_ERROR ;
8175: l_Token_Tbl(1).token_name := 'REVISED_COMPONENT_NAME';
8176: l_Token_Tbl(1).token_value := l_rev_component_rec.component_item_name;

Line 8201: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

8197:
8198: -- Process flow step 15 - Populate NULL columns for Update and
8199: -- Delete, and Creates with ACD_Type 'Add'.
8200:
8201: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
8202: AND l_rev_component_rec.acd_type = 2)
8203: OR
8204: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,
8205: ENG_GLOBALS.G_OPR_DELETE)

Line 8204: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,

8200:
8201: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
8202: AND l_rev_component_rec.acd_type = 2)
8203: OR
8204: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,
8205: ENG_GLOBALS.G_OPR_DELETE)
8206: THEN
8207: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populate NULL columns'); END IF;
8208: Bom_Default_Bom_Component.Populate_Null_Columns

Line 8205: ENG_GLOBALS.G_OPR_DELETE)

8201: IF (l_rev_component_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
8202: AND l_rev_component_rec.acd_type = 2)
8203: OR
8204: l_rev_component_rec.transaction_type IN (ENG_GLOBALS.G_OPR_UPDATE,
8205: ENG_GLOBALS.G_OPR_DELETE)
8206: THEN
8207: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Populate NULL columns'); END IF;
8208: Bom_Default_Bom_Component.Populate_Null_Columns
8209: ( p_rev_component_rec => l_rev_Component_Rec

Line 8217: ELSIF l_rev_component_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

8213: , x_rev_Component_Rec => l_rev_Component_Rec
8214: , x_rev_comp_unexp_rec => l_rev_comp_unexp_rec
8215: );
8216:
8217: ELSIF l_rev_component_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
8218:
8219: -- Process Flow step 16: Default missing values for Operation CREATE
8220: --
8221:

Line 8275: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

8271: --
8272:
8273: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
8274: IF l_rev_component_rec.Transaction_Type IN
8275: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
8276: THEN
8277: Bom_Default_Bom_Component.Entity_Defaulting
8278: ( p_rev_component_rec => l_rev_component_rec
8279: , p_old_rev_component_rec => l_old_rev_component_rec

Line 8930: l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;

8926: -- make sure that the unexposed record does not have remains of
8927: -- any previous processing. This could be possible in the consequent
8928: -- iterations of this loop
8929: l_rev_item_unexp_rec := l_rev_item_miss_rec;
8930: l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;
8931:
8932:
8933: l_revised_item_rec.transaction_type :=
8934: UPPER(l_revised_item_rec.transaction_type);

Line 8972: ENG_GLOBALS.Transaction_Type_Validity

8968: -- Check if transaction_type is valid
8969: --
8970:
8971: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
8972: ENG_GLOBALS.Transaction_Type_Validity
8973: ( p_transaction_type => l_revised_item_rec.transaction_type
8974: , p_entity => 'Rev_Items'
8975: , p_entity_id => l_revised_item_rec.revised_item_name
8976: , x_valid => l_valid

Line 9025: IF l_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

9021: -- object does not carry the ECO header
9022:
9023: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check parent existence'); END IF;
9024:
9025: IF l_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
9026: AND
9027: NOT l_eco_parent_exists
9028: THEN
9029: ENG_Validate_ECO.Check_Existence

Line 9061: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

9057: END IF;
9058: END IF;
9059:
9060: IF l_revised_item_rec.Transaction_Type IN
9061: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
9062: THEN
9063:
9064: -- Bug 2918350
9065: -- Start Changes

Line 9301: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

9297:
9298:
9299: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation'); END IF;
9300: IF l_revised_item_rec.Transaction_Type IN
9301: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
9302: THEN
9303: ENG_Validate_Revised_Item.Check_Attributes
9304: ( x_return_status => l_return_status
9305: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 9360: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

9356: END IF;
9357: END IF;
9358:
9359: IF l_revised_item_rec.Transaction_Type IN
9360: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
9361: THEN
9362:
9363: -- Process flow step 11 - Populate NULL columns for Update and
9364: -- Delete.

Line 9376: ELSIF l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

9372: , x_revised_item_rec => l_revised_item_rec
9373: , x_rev_item_unexp_rec => l_rev_item_unexp_rec
9374: );
9375:
9376: ELSIF l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
9377:
9378: -- Process Flow step 12: Default missing values for Operation CREATE
9379: --
9380:

Line 9499: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

9495: --
9496:
9497: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
9498: IF l_revised_item_rec.Transaction_Type IN
9499: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
9500: THEN
9501: ENG_Default_Revised_Item.Entity_Defaulting
9502: ( p_revised_item_rec => l_revised_item_rec
9503: , p_rev_item_unexp_rec => l_rev_item_unexp_rec

Line 9692: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9688: l_process_children := TRUE;
9689:
9690: -- Reset system_information flags
9691:
9692: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9693: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9694: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9695: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9696:

Line 9693: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9689:
9690: -- Reset system_information flags
9691:
9692: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9693: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9694: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9695: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9696:
9697: -- For loop exception handler.

Line 9694: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9690: -- Reset system_information flags
9691:
9692: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9693: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9694: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9695: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9696:
9697: -- For loop exception handler.
9698:

Line 9695: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9691:
9692: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9693: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9694: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9695: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9696:
9697: -- For loop exception handler.
9698:
9699:

Line 9746: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9742: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
9743:
9744: -- Reset system_information flags
9745:
9746: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9747: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9748: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9749: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9750:

Line 9747: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9743:
9744: -- Reset system_information flags
9745:
9746: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9747: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9748: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9749: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9750:
9751: WHEN EXC_SEV_QUIT_BRANCH THEN

Line 9748: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9744: -- Reset system_information flags
9745:
9746: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9747: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9748: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9749: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9750:
9751: WHEN EXC_SEV_QUIT_BRANCH THEN
9752:

Line 9749: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9745:
9746: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9747: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9748: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9749: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9750:
9751: WHEN EXC_SEV_QUIT_BRANCH THEN
9752:
9753: Eco_Error_Handler.Log_Error

Line 9798: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9794: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
9795:
9796: -- Reset system_information flags
9797:
9798: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9799: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9800: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9801: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9802:

Line 9799: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9795:
9796: -- Reset system_information flags
9797:
9798: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9799: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9800: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9801: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9802:
9803: WHEN EXC_SEV_SKIP_BRANCH THEN

Line 9800: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9796: -- Reset system_information flags
9797:
9798: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9799: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9800: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9801: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9802:
9803: WHEN EXC_SEV_SKIP_BRANCH THEN
9804:

Line 9801: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9797:
9798: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9799: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9800: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9801: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9802:
9803: WHEN EXC_SEV_SKIP_BRANCH THEN
9804:
9805: Eco_Error_Handler.Log_Error

Line 9850: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9846: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
9847:
9848: -- Reset system_information flags
9849:
9850: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9851: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9852: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9853: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9854:

Line 9851: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9847:
9848: -- Reset system_information flags
9849:
9850: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9851: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9852: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9853: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9854:
9855: WHEN EXC_SEV_QUIT_OBJECT THEN

Line 9852: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9848: -- Reset system_information flags
9849:
9850: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9851: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9852: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9853: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9854:
9855: WHEN EXC_SEV_QUIT_OBJECT THEN
9856:

Line 9853: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9849:
9850: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9851: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9852: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9853: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9854:
9855: WHEN EXC_SEV_QUIT_OBJECT THEN
9856:
9857: Eco_Error_Handler.Log_Error

Line 9898: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9894: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
9895:
9896: -- Reset system_information flags
9897:
9898: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9899: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9900: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9901: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9902:

Line 9899: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9895:
9896: -- Reset system_information flags
9897:
9898: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9899: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9900: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9901: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9902:
9903: WHEN EXC_FAT_QUIT_BRANCH THEN

Line 9900: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9896: -- Reset system_information flags
9897:
9898: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9899: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9900: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9901: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9902:
9903: WHEN EXC_FAT_QUIT_BRANCH THEN
9904:

Line 9901: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9897:
9898: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9899: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9900: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9901: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9902:
9903: WHEN EXC_FAT_QUIT_BRANCH THEN
9904:
9905: Eco_Error_Handler.Log_Error

Line 9946: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9942: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
9943:
9944: -- Reset system_information flags
9945:
9946: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9947: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9948: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9949: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9950:

Line 9947: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9943:
9944: -- Reset system_information flags
9945:
9946: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9947: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9948: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9949: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9950:
9951: WHEN EXC_FAT_QUIT_OBJECT THEN

Line 9948: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9944: -- Reset system_information flags
9945:
9946: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9947: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9948: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9949: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9950:
9951: WHEN EXC_FAT_QUIT_OBJECT THEN
9952:

Line 9949: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9945:
9946: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9947: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9948: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9949: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9950:
9951: WHEN EXC_FAT_QUIT_OBJECT THEN
9952:
9953: Eco_Error_Handler.Log_Error

Line 9991: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

9987: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
9988:
9989: -- Reset system_information flags
9990:
9991: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9992: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9993: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9994: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9995:

Line 9992: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

9988:
9989: -- Reset system_information flags
9990:
9991: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9992: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9993: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9994: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9995:
9996: l_return_status := 'Q';

Line 9993: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

9989: -- Reset system_information flags
9990:
9991: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9992: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9993: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9994: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9995:
9996: l_return_status := 'Q';
9997:

Line 9994: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

9990:
9991: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
9992: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
9993: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
9994: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
9995:
9996: l_return_status := 'Q';
9997:
9998: WHEN EXC_UNEXP_SKIP_OBJECT THEN

Line 10036: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

10032: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
10033:
10034: -- Reset system_information flags
10035:
10036: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
10037: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
10038: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
10039: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
10040:

Line 10037: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

10033:
10034: -- Reset system_information flags
10035:
10036: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
10037: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
10038: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
10039: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
10040:
10041: l_return_status := 'U';

Line 10038: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

10034: -- Reset system_information flags
10035:
10036: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
10037: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
10038: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
10039: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
10040:
10041: l_return_status := 'U';
10042:

Line 10039: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

10035:
10036: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
10037: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
10038: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
10039: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
10040:
10041: l_return_status := 'U';
10042:
10043: END; -- END block

Line 10347: -- l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;

10343: x_rev_operation_tbl := p_rev_operation_tbl; --L1
10344: x_rev_op_resource_tbl := p_rev_op_resource_tbl; --L1
10345: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl; --L1
10346:
10347: -- l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;
10348:
10349: FOR I IN 1..x_revised_item_tbl.COUNT LOOP
10350: IF (x_revised_item_tbl(I).return_status IS NULL OR
10351: x_revised_item_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

Line 10365: l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;

10361: -- make sure that the unexposed record does not have remains of
10362: -- any previous processing. This could be possible in the consequent
10363: -- iterations of this loop
10364: l_rev_item_unexp_rec := l_rev_item_miss_rec;
10365: l_Rev_Item_Unexp_Rec.organization_id := ENG_GLOBALS.Get_org_id;
10366:
10367:
10368: l_revised_item_rec.transaction_type :=
10369: UPPER(l_revised_item_rec.transaction_type);

Line 10407: ENG_GLOBALS.Transaction_Type_Validity

10403: -- Check if transaction_type is valid
10404: --
10405:
10406: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
10407: ENG_GLOBALS.Transaction_Type_Validity
10408: ( p_transaction_type => l_revised_item_rec.transaction_type
10409: , p_entity => 'Rev_Items'
10410: , p_entity_id => l_revised_item_rec.revised_item_name
10411: , x_valid => l_valid

Line 10460: IF l_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

10456: -- object does not carry the ECO header
10457:
10458: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check parent existence'); END IF;
10459:
10460: IF l_revised_item_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
10461: AND
10462: NOT l_eco_parent_exists
10463: THEN
10464: ENG_Validate_ECO.Check_Existence

Line 10496: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

10492: END IF;
10493: END IF;
10494:
10495: IF l_revised_item_rec.Transaction_Type IN
10496: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
10497: THEN
10498:
10499: -- Bug 2918350
10500: -- Start Changes

Line 10509: IF (l_revised_item_rec.Transaction_Type <> ENG_GLOBALS.G_OPR_UPDATE )

10505: END IF;
10506:
10507: -- Added for bug 5756870
10508: -- The update case when the CO is in scheduled status is handled saperately
10509: IF (l_revised_item_rec.Transaction_Type <> ENG_GLOBALS.G_OPR_UPDATE )
10510: AND (l_chk_co_sch = 4) THEN
10511: l_return_status := error_handler.g_status_error;
10512: error_handler.add_error_token (p_message_name => 'ENG_REV_ITM_NOT_UPD',
10513: p_mesg_token_tbl => l_mesg_token_tbl,

Line 10577: IF (l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_UPDATE ) THEN

10573: -- Process Flow step 7(a): Is ECO impl/cancl, or in wkflw process ?
10574: --
10575: -- Added for bug 5756870
10576: -- In case if the transaciton is update, pass parameter to avoid scheduled date validations
10577: IF (l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_UPDATE ) THEN
10578: ENG_Validate_ECO.Check_Access
10579: ( p_change_notice => l_revised_item_rec.ECO_Name
10580: , p_organization_id => l_rev_item_unexp_rec.organization_id
10581: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 10623: IF (l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_UPDATE ) THEN

10619: -- Bug No: 5246049
10620: -- Moved validation outside 'IF NOT l_eco_parent_exists' as validation should happen in all cases
10621:
10622: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check access'); END IF;
10623: IF (l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_UPDATE ) THEN
10624: ENG_Validate_Revised_Item.Check_Access
10625: ( p_change_notice => l_revised_item_rec.ECO_Name
10626: , p_organization_id => l_rev_item_unexp_rec.organization_id
10627: , p_revised_item_id => l_rev_item_unexp_rec.revised_item_id

Line 10827: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

10823:
10824:
10825: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation'); END IF;
10826: IF l_revised_item_rec.Transaction_Type IN
10827: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
10828: THEN
10829: ENG_Validate_Revised_Item.Check_Attributes
10830: ( x_return_status => l_return_status
10831: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 10886: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

10882: END IF;
10883: END IF;
10884:
10885: IF l_revised_item_rec.Transaction_Type IN
10886: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
10887: THEN
10888:
10889: -- Process flow step 11 - Populate NULL columns for Update and
10890: -- Delete.

Line 10902: ELSIF l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

10898: , x_revised_item_rec => l_revised_item_rec
10899: , x_rev_item_unexp_rec => l_rev_item_unexp_rec
10900: );
10901:
10902: ELSIF l_revised_item_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
10903:
10904: -- Process Flow step 12: Default missing values for Operation CREATE
10905: --
10906:

Line 11025: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

11021: --
11022:
11023: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
11024: IF l_revised_item_rec.Transaction_Type IN
11025: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
11026: THEN
11027: ENG_Default_Revised_Item.Entity_Defaulting
11028: ( p_revised_item_rec => l_revised_item_rec
11029: , p_rev_item_unexp_rec => l_rev_item_unexp_rec

Line 11218: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11214: l_process_children := TRUE;
11215:
11216: -- Reset system_information flags
11217:
11218: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11219: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11220: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11221: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11222:

Line 11219: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11215:
11216: -- Reset system_information flags
11217:
11218: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11219: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11220: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11221: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11222:
11223: -- For loop exception handler.

Line 11220: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11216: -- Reset system_information flags
11217:
11218: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11219: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11220: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11221: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11222:
11223: -- For loop exception handler.
11224:

Line 11221: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11217:
11218: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11219: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11220: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11221: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11222:
11223: -- For loop exception handler.
11224:
11225:

Line 11272: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11268: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11269:
11270: -- Reset system_information flags
11271:
11272: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11273: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11274: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11275: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11276:

Line 11273: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11269:
11270: -- Reset system_information flags
11271:
11272: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11273: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11274: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11275: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11276:
11277: WHEN EXC_SEV_QUIT_BRANCH THEN

Line 11274: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11270: -- Reset system_information flags
11271:
11272: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11273: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11274: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11275: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11276:
11277: WHEN EXC_SEV_QUIT_BRANCH THEN
11278:

Line 11275: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11271:
11272: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11273: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11274: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11275: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11276:
11277: WHEN EXC_SEV_QUIT_BRANCH THEN
11278:
11279: Eco_Error_Handler.Log_Error

Line 11324: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11320: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11321:
11322: -- Reset system_information flags
11323:
11324: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11325: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11326: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11327: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11328:

Line 11325: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11321:
11322: -- Reset system_information flags
11323:
11324: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11325: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11326: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11327: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11328:
11329: WHEN EXC_SEV_SKIP_BRANCH THEN

Line 11326: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11322: -- Reset system_information flags
11323:
11324: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11325: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11326: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11327: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11328:
11329: WHEN EXC_SEV_SKIP_BRANCH THEN
11330:

Line 11327: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11323:
11324: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11325: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11326: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11327: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11328:
11329: WHEN EXC_SEV_SKIP_BRANCH THEN
11330:
11331: Eco_Error_Handler.Log_Error

Line 11376: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11372: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11373:
11374: -- Reset system_information flags
11375:
11376: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11377: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11378: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11379: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11380:

Line 11377: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11373:
11374: -- Reset system_information flags
11375:
11376: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11377: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11378: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11379: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11380:
11381: WHEN EXC_SEV_QUIT_OBJECT THEN

Line 11378: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11374: -- Reset system_information flags
11375:
11376: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11377: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11378: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11379: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11380:
11381: WHEN EXC_SEV_QUIT_OBJECT THEN
11382:

Line 11379: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11375:
11376: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11377: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11378: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11379: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11380:
11381: WHEN EXC_SEV_QUIT_OBJECT THEN
11382:
11383: Eco_Error_Handler.Log_Error

Line 11424: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11420: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11421:
11422: -- Reset system_information flags
11423:
11424: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11425: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11426: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11427: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11428:

Line 11425: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11421:
11422: -- Reset system_information flags
11423:
11424: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11425: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11426: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11427: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11428:
11429: WHEN EXC_FAT_QUIT_BRANCH THEN

Line 11426: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11422: -- Reset system_information flags
11423:
11424: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11425: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11426: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11427: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11428:
11429: WHEN EXC_FAT_QUIT_BRANCH THEN
11430:

Line 11427: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11423:
11424: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11425: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11426: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11427: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11428:
11429: WHEN EXC_FAT_QUIT_BRANCH THEN
11430:
11431: Eco_Error_Handler.Log_Error

Line 11472: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11468: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11469:
11470: -- Reset system_information flags
11471:
11472: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11473: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11474: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11475: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11476:

Line 11473: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11469:
11470: -- Reset system_information flags
11471:
11472: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11473: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11474: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11475: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11476:
11477: WHEN EXC_FAT_QUIT_OBJECT THEN

Line 11474: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11470: -- Reset system_information flags
11471:
11472: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11473: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11474: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11475: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11476:
11477: WHEN EXC_FAT_QUIT_OBJECT THEN
11478:

Line 11475: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11471:
11472: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11473: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11474: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11475: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11476:
11477: WHEN EXC_FAT_QUIT_OBJECT THEN
11478:
11479: Eco_Error_Handler.Log_Error

Line 11517: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11513: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11514:
11515: -- Reset system_information flags
11516:
11517: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11518: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11519: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11520: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11521:

Line 11518: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11514:
11515: -- Reset system_information flags
11516:
11517: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11518: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11519: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11520: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11521:
11522: l_return_status := 'Q';

Line 11519: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11515: -- Reset system_information flags
11516:
11517: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11518: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11519: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11520: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11521:
11522: l_return_status := 'Q';
11523:

Line 11520: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11516:
11517: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11518: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11519: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11520: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11521:
11522: l_return_status := 'Q';
11523:
11524: WHEN EXC_UNEXP_SKIP_OBJECT THEN

Line 11562: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);

11558: --x_rev_sub_resource_tbl := l_rev_sub_resource_tbl; --L1
11559:
11560: -- Reset system_information flags
11561:
11562: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11563: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11564: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11565: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11566:

Line 11563: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);

11559:
11560: -- Reset system_information flags
11561:
11562: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11563: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11564: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11565: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11566:
11567: l_return_status := 'U';

Line 11564: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);

11560: -- Reset system_information flags
11561:
11562: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11563: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11564: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11565: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11566:
11567: l_return_status := 'U';
11568:

Line 11565: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);

11561:
11562: ENG_GLOBALS.Set_RITEM_Impl( p_ritem_impl => NULL);
11563: ENG_GLOBALS.Set_RITEM_Cancl( p_ritem_cancl => NULL);
11564: ENG_GLOBALS.Set_Bill_Sequence_Id( p_bill_sequence_id => NULL);
11565: ENG_GLOBALS.Set_Current_Revision( p_current_revision => NULL);
11566:
11567: l_return_status := 'U';
11568:
11569: END; -- END block

Line 11909: --l_change_line_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;

11905: -- Load local records.
11906: l_change_line_rec := x_change_line_tbl(I);
11907: l_change_line_rec.transaction_type :=
11908: UPPER(l_change_line_rec.transaction_type);
11909: --l_change_line_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;
11910:
11911: --
11912: -- Initialize the Unexposed Record for every iteration of the Loop
11913: -- so that sequence numbers get generated for every new row.

Line 11924: l_change_line_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;

11920: --l_change_line_unexp_rec.item_id := NULL ;
11921: --l_change_line_unexp_rec.item_revision_id := NULL ;
11922:
11923: --Organization_id is required for validations when we attach revised_items/lines to already existing ECO's
11924: l_change_line_unexp_rec.organization_id := Eng_Globals.Get_Org_Id;
11925:
11926:
11927:
11928: --

Line 11958: ENG_GLOBALS.Transaction_Type_Validity

11954: --
11955:
11956: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check transaction_type validity'); END IF;
11957:
11958: ENG_GLOBALS.Transaction_Type_Validity
11959: ( p_transaction_type => l_change_line_rec.transaction_type
11960: , p_entity => 'Change_Lines'
11961: , p_entity_id => l_change_line_rec.name
11962: , x_valid => l_valid

Line 12018: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12014: );
12015:
12016: IF l_return_status = Error_Handler.G_STATUS_ERROR
12017: THEN
12018: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12019: THEN
12020: l_other_message := 'ENG_CL_REQ_CSEV_SKIP';
12021: l_other_token_tbl(1).token_name := 'LINE_NAME';
12022: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 12073: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12069: -- object does not carry the ECO header
12070:
12071: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check parent existence'); END IF;
12072:
12073: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12074: AND NOT l_eco_parent_exists
12075: THEN
12076: ENG_Validate_ECO.Check_Existence
12077: ( p_change_notice => l_change_line_rec.eco_name

Line 12109: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

12105:
12106: END IF;
12107:
12108: IF l_change_line_rec.Transaction_Type IN
12109: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
12110: THEN
12111: -- Bug 2918350
12112: -- Start Changes
12113:

Line 12219: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12215: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('return_status: ' || l_return_status); END IF;
12216:
12217: IF l_return_status = Error_Handler.G_STATUS_ERROR
12218: THEN
12219: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12220: THEN
12221: l_other_message := 'ENG_RIT_VID_CSEV_SKIP';
12222: l_other_token_tbl(1).token_name := 'LINE_NAME';
12223: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 12304: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

12300: --
12301:
12302: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation'); END IF;
12303: IF l_change_line_rec.Transaction_Type IN
12304: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
12305: THEN
12306: ENG_Validate_Change_Line.Check_Attributes
12307: ( x_return_status => l_return_status
12308: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 12319: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12315: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('return_status: ' || l_return_status); END IF;
12316:
12317: IF l_return_status = Error_Handler.G_STATUS_ERROR
12318: THEN
12319: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12320: THEN
12321: l_other_message := 'ENG_RIT_ATTVAL_CSEV_SKIP';
12322: l_other_token_tbl(1).token_name := 'LINE_NAME';
12323: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 12372: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

12368:
12369: END IF;
12370:
12371: IF l_change_line_rec.Transaction_Type IN
12372: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
12373: THEN
12374:
12375: -- Process flow step 11 - Populate NULL columns for Update and
12376: -- Delete.

Line 12389: ELSIF l_change_line_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

12385: , x_change_line_rec => l_change_line_rec
12386: , x_change_line_unexp_rec => l_change_line_unexp_rec
12387: );
12388:
12389: ELSIF l_change_line_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
12390:
12391: -- Process Flow step 12: Default missing values for Operation CREATE
12392: --
12393:

Line 12470: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12466: );
12467:
12468: IF l_return_status = Error_Handler.G_STATUS_ERROR
12469: THEN
12470: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12471: THEN
12472: l_other_message := 'ENG_CL_CONREQ_CSEV_SKIP';
12473: l_other_token_tbl(1).token_name := 'LINE_NAME';
12474: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 12522: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)

12518:
12519: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity defaulting'); END IF;
12520:
12521: IF l_change_line_rec.Transaction_Type IN
12522: (ENG_GLOBALS.G_OPR_CREATE, ENG_GLOBALS.G_OPR_UPDATE)
12523: THEN
12524:
12525: ENG_Default_Change_Line.Entity_Defaulting
12526: ( p_change_line_rec => l_change_line_rec

Line 12540: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12536: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('return_status: ' || l_return_status); END IF;
12537:
12538: IF l_return_status = Error_Handler.G_STATUS_ERROR
12539: THEN
12540: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12541: THEN
12542: l_other_message := 'ENG_CL_ENTDEF_CSEV_SKIP';
12543: l_other_token_tbl(1).token_name := 'LINE_NAME';
12544: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 12591: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_DELETE

12587: --
12588:
12589: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity validation'); END IF;
12590:
12591: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_DELETE
12592: THEN
12593: ENG_Validate_Change_Line.Check_Entity_Delete
12594: ( p_change_line_rec => l_change_line_rec
12595: , p_change_line_unexp_rec => l_change_line_unexp_rec

Line 12614: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12610: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('return_status: ' || l_return_status); END IF;
12611:
12612: IF l_return_status = Error_Handler.G_STATUS_ERROR
12613: THEN
12614: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12615: THEN
12616: l_other_message := 'ENG_CL_ENTVAL_CSEV_SKIP';
12617: l_other_token_tbl(1).token_name := 'LINE_NAME';
12618: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 12684: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

12680: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('return_status: ' || l_return_status); END IF;
12681: -- Bug 4033384: Added error handling for subject validation for l_return_status G_STATUS_ERROR
12682: IF l_return_status = Error_Handler.G_STATUS_ERROR
12683: THEN
12684: IF l_change_line_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
12685: THEN
12686: l_other_message := 'ENG_CL_ENTVAL_CSEV_SKIP';
12687: l_other_token_tbl(1).token_name := 'LINE_NAME';
12688: l_other_token_tbl(1).token_value := l_change_line_rec.name;

Line 13100: l_eco_rev_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;

13096: x_rev_op_resource_tbl := p_rev_op_resource_tbl;
13097: x_rev_sub_resource_tbl := p_rev_sub_resource_tbl;
13098: x_change_line_tbl := p_change_line_tbl;
13099:
13100: l_eco_rev_unexp_rec.organization_id := ENG_GLOBALS.Get_org_id;
13101:
13102: FOR I IN 1..x_eco_revision_tbl.COUNT LOOP
13103: IF (x_eco_revision_tbl(I).return_status IS NULL OR
13104: x_eco_revision_tbl(I).return_status = FND_API.G_MISS_CHAR) THEN

Line 13143: ENG_GLOBALS.Transaction_Type_Validity

13139: -- Check if transaction_type is valid
13140: --
13141:
13142: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Transaction Type validity'); END IF;
13143: ENG_GLOBALS.Transaction_Type_Validity
13144: ( p_transaction_type => l_eco_revision_rec.transaction_type
13145: , p_entity => 'ECO_Rev'
13146: , p_entity_id => l_eco_revision_rec.revision
13147: , x_valid => l_valid

Line 13197: IF l_eco_revision_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE

13193: -- object does not carry the ECO header
13194:
13195: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Check parent existence'); END IF;
13196:
13197: IF l_eco_revision_rec.transaction_type = ENG_GLOBALS.G_OPR_CREATE
13198: AND
13199: NOT l_eco_parent_exists
13200: THEN
13201: ENG_Validate_ECO.Check_Existence

Line 13235: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

13231:
13232: -- Bug 2918350
13233: -- Start Changes
13234: IF l_eco_revision_rec.Transaction_Type IN
13235: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
13236: THEN
13237:
13238: IF p_change_notice IS NOT NULL AND p_organization_id IS NOT NULL THEN
13239: l_chk_co_sch := ret_co_status ( p_change_notice, p_organization_id);

Line 13320: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

13316:
13317: END IF;
13318:
13319: IF l_eco_revision_rec.Transaction_Type IN
13320: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
13321: THEN
13322:
13323: -- Process flow step 7 - Populate NULL columns for Update and
13324: -- Delete.

Line 13337: ELSIF l_eco_revision_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

13333: , x_eco_rev_unexp_rec => l_eco_rev_unexp_rec
13334: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
13335: );
13336:
13337: ELSIF l_eco_revision_rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
13338:
13339: -- Process Flow step 8: Default missing values for Operation CREATE
13340:
13341: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Defaulting'); END IF;

Line 14041: Eng_Globals.Get_User_Id,

14037: p_organization_id,
14038: null,
14039: null,
14040: sysdate,
14041: Eng_Globals.Get_User_Id,
14042: sysdate,
14043: Eng_Globals.Get_User_Id,
14044: Eng_Globals.Get_Login_id
14045: );

Line 14043: Eng_Globals.Get_User_Id,

14039: null,
14040: sysdate,
14041: Eng_Globals.Get_User_Id,
14042: sysdate,
14043: Eng_Globals.Get_User_Id,
14044: Eng_Globals.Get_Login_id
14045: );
14046:
14047:

Line 14044: Eng_Globals.Get_Login_id

14040: sysdate,
14041: Eng_Globals.Get_User_Id,
14042: sysdate,
14043: Eng_Globals.Get_User_Id,
14044: Eng_Globals.Get_Login_id
14045: );
14046:
14047:
14048: EXCEPTION

Line 14190: l_ECO_Unexp_rec.organization_id := ENG_GLOBALS.Get_Org_Id;

14186:
14187: BEGIN
14188:
14189: -- Load entity and record-specific details into system_information record
14190: l_ECO_Unexp_rec.organization_id := ENG_GLOBALS.Get_Org_Id;
14191: l_ECO_rec := p_ECO_rec;
14192: l_ECO_rec.transaction_type := UPPER(l_eco_rec.transaction_type);
14193:
14194: -- Process Flow Step 2: Check if record has not yet been processed

Line 14221: ENG_GLOBALS.Transaction_Type_Validity

14217:
14218: -- Check if transaction_type is valid
14219: --
14220:
14221: ENG_GLOBALS.Transaction_Type_Validity
14222: ( p_transaction_type => l_ECO_rec.transaction_type
14223: , p_entity => 'ECO_Header'
14224: , p_entity_id => l_ECO_rec.ECO_Name
14225: , x_valid => l_valid

Line 14438: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_CREATE)

14434: -- Process Flow step 7: Attribute Validation for Create and Update
14435: --
14436:
14437: IF l_ECO_rec.transaction_type IN
14438: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_CREATE)
14439: THEN
14440: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute validation'); END IF;
14441:
14442: ENG_Validate_ECO.Check_Attributes

Line 14505: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)

14501: END IF;
14502: END IF;
14503:
14504: IF l_ECO_Rec.Transaction_Type IN
14505: (ENG_GLOBALS.G_OPR_UPDATE, ENG_GLOBALS.G_OPR_DELETE)
14506: THEN
14507:
14508: -- Process flow step 8 - Populate NULL columns for Update and
14509: -- Delete.

Line 14521: ELSIF l_ECO_Rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN

14517: , x_ECO_rec => l_ECO_Rec
14518: , x_Unexp_ECO_rec => l_ECO_Unexp_Rec
14519: );
14520:
14521: ELSIF l_ECO_Rec.Transaction_Type = ENG_GLOBALS.G_OPR_CREATE THEN
14522:
14523: -- Process Flow step 9: Default missing values for Operation CREATE
14524:
14525: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Defaulting'); END IF;

Line 14859: l_ECO_rec.transaction_type = Eng_Globals.G_OPR_CREATE then

14855:
14856: l_profile_exist := FND_PROFILE.DEFINED ( 'EGO_ITEM_RESTRICT_INV_ACTIONS' );
14857:
14858: if l_return_status ='S'and l_ECO_rec.plm_or_erp_change='PLM' and
14859: l_ECO_rec.transaction_type = Eng_Globals.G_OPR_CREATE then
14860:
14861: -- if l_profile_exist = TRUE then
14862: /* The procedure first explodes and inserts the Statuses for
14863: the given Type, Routes for each Status, Steps for each Route,

Line 14866: l_user_id := Eng_Globals.Get_User_Id;

14862: /* The procedure first explodes and inserts the Statuses for
14863: the given Type, Routes for each Status, Steps for each Route,
14864: People for each Step, and Persons for each Group and Role. */
14865:
14866: l_user_id := Eng_Globals.Get_User_Id;
14867: l_login_id := Eng_Globals.Get_Login_Id;
14868: l_request_id := ENG_GLOBALS.Get_request_id;
14869: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
14870: l_prog_id := ENG_GLOBALS.Get_prog_id;

Line 14867: l_login_id := Eng_Globals.Get_Login_Id;

14863: the given Type, Routes for each Status, Steps for each Route,
14864: People for each Step, and Persons for each Group and Role. */
14865:
14866: l_user_id := Eng_Globals.Get_User_Id;
14867: l_login_id := Eng_Globals.Get_Login_Id;
14868: l_request_id := ENG_GLOBALS.Get_request_id;
14869: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
14870: l_prog_id := ENG_GLOBALS.Get_prog_id;
14871:

Line 14868: l_request_id := ENG_GLOBALS.Get_request_id;

14864: People for each Step, and Persons for each Group and Role. */
14865:
14866: l_user_id := Eng_Globals.Get_User_Id;
14867: l_login_id := Eng_Globals.Get_Login_Id;
14868: l_request_id := ENG_GLOBALS.Get_request_id;
14869: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
14870: l_prog_id := ENG_GLOBALS.Get_prog_id;
14871:
14872: /*

Line 14869: l_prog_appid := ENG_GLOBALS.Get_prog_appid;

14865:
14866: l_user_id := Eng_Globals.Get_User_Id;
14867: l_login_id := Eng_Globals.Get_Login_Id;
14868: l_request_id := ENG_GLOBALS.Get_request_id;
14869: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
14870: l_prog_id := ENG_GLOBALS.Get_prog_id;
14871:
14872: /*
14873: --subjects handling

Line 14870: l_prog_id := ENG_GLOBALS.Get_prog_id;

14866: l_user_id := Eng_Globals.Get_User_Id;
14867: l_login_id := Eng_Globals.Get_Login_Id;
14868: l_request_id := ENG_GLOBALS.Get_request_id;
14869: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
14870: l_prog_id := ENG_GLOBALS.Get_prog_id;
14871:
14872: /*
14873: --subjects handling
14874:

Line 15572: , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=

15568:
15569: PROCEDURE Process_Eco
15570: ( p_api_version_number IN NUMBER
15571: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
15572: , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=
15573: ENG_GLOBALS.G_MISS_CONTROL_REC
15574: , x_return_status OUT NOCOPY VARCHAR2
15575: , x_msg_count OUT NOCOPY NUMBER
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=

Line 15573: ENG_GLOBALS.G_MISS_CONTROL_REC

15569: PROCEDURE Process_Eco
15570: ( p_api_version_number IN NUMBER
15571: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
15572: , p_control_rec IN ENG_GLOBALS.Control_Rec_Type :=
15573: ENG_GLOBALS.G_MISS_CONTROL_REC
15574: , x_return_status OUT NOCOPY VARCHAR2
15575: , x_msg_count OUT NOCOPY NUMBER
15576: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type :=
15577: ENG_Eco_PUB.G_MISS_ECO_REC

Line 15618: l_control_rec ENG_GLOBALS.Control_Rec_Type;

15614: Added by AS on 03/17/99 to fix bug 852322
15615: */
15616: l_bo_return_status VARCHAR2(1);
15617:
15618: l_control_rec ENG_GLOBALS.Control_Rec_Type;
15619:
15620: l_ECO_rec ENG_Eco_PUB.Eco_Rec_Type := p_ECO_rec;
15621: l_eco_revision_rec ENG_Eco_PUB.Eco_Revision_Rec_Type;
15622: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 15710: ENG_GLOBALS.Init_System_Info_Rec

15706: -- Load environment information into the SYSTEM_INFORMATION record
15707: -- (USER_ID, LOGIN_ID, PROG_APPID, PROG_ID)
15708:
15709:
15710: ENG_GLOBALS.Init_System_Info_Rec
15711: ( x_mesg_token_tbl => l_mesg_token_tbl
15712: , x_return_status => l_return_status
15713: );
15714:

Line 15723: ENG_Globals.Set_Unit_Effectivity (TRUE);

15719: */
15720: IF PJM_UNIT_EFF.Enabled = 'Y'
15721: THEN
15722: BOM_Globals.Set_Unit_Effectivity (TRUE);
15723: ENG_Globals.Set_Unit_Effectivity (TRUE);
15724: ELSE
15725: BOM_Globals.Set_Unit_Effectivity (FALSE);
15726: ENG_Globals.Set_Unit_Effectivity (FALSE);
15727: END IF;

Line 15726: ENG_Globals.Set_Unit_Effectivity (FALSE);

15722: BOM_Globals.Set_Unit_Effectivity (TRUE);
15723: ENG_Globals.Set_Unit_Effectivity (TRUE);
15724: ELSE
15725: BOM_Globals.Set_Unit_Effectivity (FALSE);
15726: ENG_Globals.Set_Unit_Effectivity (FALSE);
15727: END IF;
15728:
15729: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
15730: THEN

Line 16181: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);

16177: END IF;
16178:
16179: -- Reset system_information business object flags
16180:
16181: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

Line 16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);

16178:
16179: -- Reset system_information business object flags
16180:
16181: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

Line 16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);

16179: -- Reset system_information business object flags
16180:
16181: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

Line 16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);

16180:
16181: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16188: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

Line 16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

16181: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16188: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16189:

Line 16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

16182: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16188: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16189:
16190:

Line 16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

16183: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16188: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16189:
16190:
16191: --Bug No: 3737881

Line 16188: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

16184: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16185: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16186: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16187: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16188: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16189:
16190:
16191: --Bug No: 3737881
16192: --Commenting out the following code as no 'Commit' should

Line 16194: --IF ENG_GLOBALS.G_ENG_LAUNCH_IMPORT = 1 THEN

16190:
16191: --Bug No: 3737881
16192: --Commenting out the following code as no 'Commit' should
16193: --be done in this API.
16194: --IF ENG_GLOBALS.G_ENG_LAUNCH_IMPORT = 1 THEN
16195: -- Error_Handler.Write_To_ConcurrentLog;
16196: -- Error_Handler.WRITE_TO_INTERFACETABLE;
16197: -- COMMIT;
16198: --END IF;

Line 16244: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);

16240: x_change_line_tbl := l_change_line_tbl ; -- Eng Change
16241:
16242: -- Reset system_information business object flags
16243:
16244: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

Line 16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);

16241:
16242: -- Reset system_information business object flags
16243:
16244: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

Line 16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);

16242: -- Reset system_information business object flags
16243:
16244: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

Line 16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);

16243:
16244: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16251: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

Line 16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

16244: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16251: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16252:

Line 16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

16245: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16251: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16252:
16253: WHEN G_EXC_QUIT_IMPORT THEN

Line 16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

16246: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16251: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16252:
16253: WHEN G_EXC_QUIT_IMPORT THEN
16254:

Line 16251: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

16247: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16248: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16249: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16250: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16251: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16252:
16253: WHEN G_EXC_QUIT_IMPORT THEN
16254:
16255: x_return_status := l_return_status;

Line 16269: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);

16265: x_change_line_tbl := l_change_line_tbl ; -- Eng Change
16266:
16267: -- Reset system_information business object flags
16268:
16269: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

Line 16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);

16266:
16267: -- Reset system_information business object flags
16268:
16269: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

Line 16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);

16267: -- Reset system_information business object flags
16268:
16269: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

Line 16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);

16268:
16269: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16276: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

Line 16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

16269: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16276: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16277:

Line 16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

16270: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16276: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16277:
16278: WHEN OTHERS THEN

Line 16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

16271: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16276: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16277:
16278: WHEN OTHERS THEN
16279:

Line 16276: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

16272: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16273: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16274: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16275: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16276: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16277:
16278: WHEN OTHERS THEN
16279:
16280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 16334: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);

16330: x_change_line_tbl := l_change_line_tbl ; -- Eng Change
16331:
16332: -- Reset system_information business object flags
16333:
16334: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

Line 16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);

16331:
16332: -- Reset system_information business object flags
16333:
16334: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

Line 16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);

16332: -- Reset system_information business object flags
16333:
16334: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

Line 16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);

16333:
16334: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16341: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

Line 16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);

16334: ENG_GLOBALS.Set_ECO_Impl( p_eco_impl => NULL);
16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16341: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16342:

Line 16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);

16335: ENG_GLOBALS.Set_ECO_Cancl( p_eco_cancl => NULL);
16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16341: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16342:
16343: END Process_Eco;

Line 16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);

16336: ENG_GLOBALS.Set_Wkfl_Process( p_wkfl_process=> NULL);
16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16341: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16342:
16343: END Process_Eco;
16344:

Line 16341: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);

16337: ENG_GLOBALS.Set_ECO_Access( p_eco_access => NULL);
16338: ENG_GLOBALS.Set_STD_Item_Access( p_std_item_access => NULL);
16339: ENG_GLOBALS.Set_MDL_Item_Access( p_mdl_item_access => NULL);
16340: ENG_GLOBALS.Set_PLN_Item_Access( p_pln_item_access => NULL);
16341: ENG_GLOBALS.Set_OC_Item_Access( p_oc_item_access => NULL);
16342:
16343: END Process_Eco;
16344:
16345: -- Start of Comments

Line 16426: IF p_ECO_rec.operation = ENG_GLOBALS.G_OPR_LOCK THEN

16422: SAVEPOINT Lock_Eco_PVT;
16423:
16424: -- Lock ECO
16425:
16426: IF p_ECO_rec.operation = ENG_GLOBALS.G_OPR_LOCK THEN
16427:
16428: ENG_Eco_Util.Lock_Row
16429: ( p_ECO_rec => p_ECO_rec
16430: , x_ECO_rec => x_ECO_rec

Line 16448: IF p_eco_revision_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN

16444: -- Lock eco_revision
16445:
16446: FOR I IN 1..p_eco_revision_tbl.COUNT LOOP
16447:
16448: IF p_eco_revision_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN
16449:
16450: ENG_Eco_Revision_Util.Lock_Row
16451: ( p_eco_revision_rec => p_eco_revision_tbl(I)
16452: , x_eco_revision_rec => l_eco_revision_rec

Line 16473: IF p_revised_item_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN

16469: -- Lock revised_item
16470:
16471: FOR I IN 1..p_revised_item_tbl.COUNT LOOP
16472:
16473: IF p_revised_item_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN
16474:
16475: ENG_Revised_Item_Util.Lock_Row
16476: ( p_revised_item_rec => p_revised_item_tbl(I)
16477: , x_revised_item_rec => l_revised_item_rec

Line 16498: IF p_rev_component_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN

16494: -- Lock rev_component
16495:
16496: FOR I IN 1..p_rev_component_tbl.COUNT LOOP
16497:
16498: IF p_rev_component_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN
16499:
16500: Bom_Bom_Component_Util.Lock_Row
16501: ( p_rev_component_rec => p_rev_component_tbl(I)
16502: , x_rev_component_rec => l_rev_component_rec

Line 16523: IF p_ref_designator_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN

16519: -- Lock ref_designator
16520:
16521: FOR I IN 1..p_ref_designator_tbl.COUNT LOOP
16522:
16523: IF p_ref_designator_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN
16524:
16525: Bom_Ref_Designator_Util.Lock_Row
16526: ( p_ref_designator_rec => p_ref_designator_tbl(I)
16527: , x_ref_designator_rec => l_ref_designator_rec

Line 16548: IF p_sub_component_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN

16544: -- Lock sub_component
16545:
16546: FOR I IN 1..p_sub_component_tbl.COUNT LOOP
16547:
16548: IF p_sub_component_tbl(I).operation = ENG_GLOBALS.G_OPR_LOCK THEN
16549:
16550: ENG_Sub_Component_Util.Lock_Row
16551: ( p_sub_component_rec => p_sub_component_tbl(I)
16552: , x_sub_component_rec => l_sub_component_rec