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.ENGECOBO dependencies on FND_API

Line 336: x_return_status := FND_API.G_RET_STS_SUCCESS;

332: p_change_id => p_change_id
333: , p_local_organization_id => p_local_organization_id
334: , x_local_change_id => l_local_change_id);
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337:
338: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: l_local_change_id'||l_local_change_id);
339: IF l_local_change_id IS null
340: THEN

Line 353: l_return_status := FND_API.G_RET_STS_SUCCESS;

349: LOOP
350: -- initialize pk value and local attachment id
351: l_pk3_value := NULL;
352: l_local_attachment_id := -1;
353: l_return_status := FND_API.G_RET_STS_SUCCESS;
354: -- set the pk3 value if the attachment belongs to item revision
355: IF (ac.entity_name = 'MTL_ITEM_REVISIONS')
356: THEN
357: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Value: p_revised_item_unexp_rec.new_item_revision_id'|| p_revised_item_unexp_rec.new_item_revision_id);

Line 489: l_return_status := FND_API.G_RET_STS_ERROR;

485: , p_entity_name => Eng_Propagation_Log_Util.G_ENTITY_REVISED_LINE
486: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR
487: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
488: );
489: l_return_status := FND_API.G_RET_STS_ERROR;
490: -- this case should not be reached as validation of attachments has already been done.
491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment does not exist');
492: END IF;
493: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed attachment change with l_return_status'|| l_return_status);

Line 494: IF l_return_status = FND_API.G_RET_STS_SUCCESS

490: -- this case should not be reached as validation of attachments has already been done.
491: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Attachment does not exist');
492: END IF;
493: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed attachment change with l_return_status'|| l_return_status);
494: IF l_return_status = FND_API.G_RET_STS_SUCCESS
495: THEN
496: Eng_Propagation_Log_Util.add_entity_map(
497: p_change_id => p_change_id
498: , p_revised_item_sequence_id => p_revised_item_sequence_id

Line 509: IF l_return_status = FND_API.G_RET_STS_ERROR

505: , p_entity_action_status => Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS
506: , p_bo_entity_identifier => 'ATCH'--Eco_Error_Handler.G_ATCH_LEVEL
507: );
508: END IF;
509: IF l_return_status = FND_API.G_RET_STS_ERROR
510: THEN
511: x_return_status := l_return_status;
512: END IF;
513: END LOOP; /* end loop 2 */

Line 516: IF x_return_status = FND_API.G_RET_STS_ERROR

512: END IF;
513: END LOOP; /* end loop 2 */
514: END IF;
515: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Processed All attachment change with x_return_status'||x_return_status);
516: IF x_return_status = FND_API.G_RET_STS_ERROR
517: THEN
518: Error_Handler.Add_Error_Token(
519: p_Message_Name => 'ENG_PRP_ATT_REVITEM_ERR'
520: , p_Mesg_Token_Tbl => x_mesg_token_tbl

Line 528: x_return_status := FND_API.G_RET_STS_ERROR;

524: Eng_Propagation_log_Util.Debug_Log(G_LOG_STMT, 'Propagate_Attach_Lines.END');
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;
529:
530: Error_Handler.Add_Error_Token(
531: p_Message_Name => NULL
532: , p_Message_Text => 'Unexpected Error Occurred when propagating attachment changes' ||SQLERRM

Line 652: x_return_status := FND_API.G_RET_STS_SUCCESS;

648: l_api_version CONSTANT NUMBER := 1.0;
649: l_error_table INV_ITEM_GRP.Error_Tbl_Type;
650:
651: BEGIN
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653: -- Standard Start of API savepoint
654: SAVEPOINT Auto_Enable_Item;
655:
656: -- Standard call to check for call compatibility

Line 657: IF NOT FND_API.Compatible_API_Call ( l_api_version

653: -- Standard Start of API savepoint
654: SAVEPOINT Auto_Enable_Item;
655:
656: -- Standard call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call ( l_api_version
658: ,p_api_version
659: ,l_api_name
660: ,G_PKG_NAME )
661: THEN

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: ,p_api_version
659: ,l_api_name
660: ,G_PKG_NAME )
661: THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664:
665: -- Initialize message list if p_init_msg_list is set to TRUE.
666: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 666: IF FND_API.to_Boolean( p_init_msg_list ) THEN

662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END IF;
664:
665: -- Initialize message list if p_init_msg_list is set to TRUE.
666: IF FND_API.to_Boolean( p_init_msg_list ) THEN
667: FND_MSG_PUB.initialize;
668: END IF ;
669:
670: AUTO_ENABLE_ITEM_IN_ORG(

Line 676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

672: , p_organization_id => p_local_organization_id
673: , X_error_table => l_error_table
674: , x_return_status => x_return_status);
675:
676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
677: THEN
678: FOR i IN 1..l_error_table.COUNT
679: LOOP
680: FND_MESSAGE.Set_Name('INV', l_error_table(i).message_name);

Line 688: IF FND_API.To_Boolean ( p_commit ) THEN

684: p_count => x_msg_count
685: , p_data => x_msg_data);
686: END IF;
687: -- Standard ending code ------------------------------------------------
688: IF FND_API.To_Boolean ( p_commit ) THEN
689: COMMIT WORK;
690: END IF;
691:
692: EXCEPTION

Line 695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

691:
692: EXCEPTION
693: WHEN OTHERS THEN
694: ROLLBACK TO Auto_Enable_Item;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
697: THEN
698: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
699: END IF;

Line 837: x_return_status := FND_API.G_RET_STS_SUCCESS;

833: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.BEGIN');
834: --
835: -- Initialize
836: l_error_logged := G_VAL_FALSE;
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: -- validate attachment changes propagation
840: FOR ac IN c_attachment_changes
841: LOOP

Line 869: p_global_new_item_rev <> FND_API.G_MISS_CHAR AND

865: l_local_revision := NULL;
866: END;
867:
868: IF p_global_new_item_rev IS NOT NULL AND
869: p_global_new_item_rev <> FND_API.G_MISS_CHAR AND
870: p_global_new_item_rev <> l_local_revision
871: THEN
872: l_Token_Tbl.delete;
873: l_Token_Tbl(1).Token_name := 'REVISION';

Line 887: p_global_new_item_rev = FND_API.G_MISS_CHAR

883: l_error_logged := G_VAL_TRUE;
884: l_rev_mismatch := G_VAL_TRUE;
885:
886: ELSIF p_global_new_item_rev IS NULL OR
887: p_global_new_item_rev = FND_API.G_MISS_CHAR
888: THEN
889: BEGIN
890: SELECT revision
891: INTO l_global_revision

Line 1027: x_return_status := FND_API.G_RET_STS_ERROR;

1023: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'Value: l_error_logged'||l_error_logged);
1024:
1025: IF (l_error_logged = G_VAL_TRUE)
1026: THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: -- Log any messages that have been logged with the additional error
1029: -- message into error handler
1030: Eco_Error_Handler.Log_Error(
1031: p_error_status => FND_API.G_RET_STS_ERROR

Line 1031: p_error_status => FND_API.G_RET_STS_ERROR

1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: -- Log any messages that have been logged with the additional error
1029: -- message into error handler
1030: Eco_Error_Handler.Log_Error(
1031: p_error_status => FND_API.G_RET_STS_ERROR
1032: , p_mesg_token_tbl => l_mesg_token_tbl
1033: , p_error_scope => Error_Handler.G_SCOPE_ALL
1034: , p_error_level => Eco_Error_Handler.G_ATCH_LEVEL
1035: , x_eco_rec => ENG_Eco_PUB.G_MISS_ECO_REC

Line 1110: x_return_status := FND_API.G_RET_STS_ERROR;

1106: END IF;
1107: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Validate_Attach_Lines.ERROR');
1108: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in validation attachments ' || SQLERRM);
1109: l_error_logged := 1;
1110: x_return_status := FND_API.G_RET_STS_ERROR;
1111: Error_Handler.Add_Error_Token(
1112: p_Message_Name => NULL
1113: , p_Message_Text => 'Unexpected Error Occurred when validating attachment changes' ||SQLERRM
1114: , p_Mesg_Token_Tbl => x_Mesg_Token_Tbl

Line 2351: IF ((ri.new_item_revision = FND_API.G_MISS_CHAR) OR

2347: IF (l_item_exits_in_org_flag = 1) THEN
2348: l_revised_item_tbl(i).eco_name := ri.change_notice;
2349: l_revised_item_tbl(i).organization_code := l_org_code;
2350: l_revised_item_tbl(i).revised_item_name := l_revised_item_number;
2351: IF ((ri.new_item_revision = FND_API.G_MISS_CHAR) OR
2352: (ri.new_item_revision IS NULL)) THEN
2353: l_revised_item_tbl(i).new_revised_item_revision := NULL;
2354: ELSE
2355: l_revised_item_tbl(i).new_revised_item_revision :=

Line 3387: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3383: , p_mesg_token_tbl => l_mesg_token_tbl
3384: , x_mesg_token_tbl => l_mesg_token_tbl
3385: );
3386:
3387: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3388: THEN
3389: BOM_Globals.Set_Debug('N');
3390: BOM_Rtg_Globals.Set_Debug('N'); -- Added by MK on 11/08/00
3391: END IF;

Line 3401: l_return_status := FND_API.G_RET_STS_SUCCESS;

3397: Eng_Globals.Set_Org_Id( p_org_id => p_organization_id);
3398: -- Load environment information into the SYSTEM_INFORMATION record
3399: -- (USER_ID, LOGIN_ID, PROG_APPID, PROG_ID)
3400:
3401: l_return_status := FND_API.G_RET_STS_SUCCESS;
3402: ENG_GLOBALS.Init_System_Info_Rec(
3403: x_mesg_token_tbl => l_mesg_token_tbl
3404: , x_return_status => l_return_status
3405: );

Line 3417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3413: BOM_Globals.Set_Unit_Effectivity (FALSE);
3414: ENG_Globals.Set_Unit_Effectivity (FALSE);
3415: END IF;
3416: x_return_status := l_return_status;
3417: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3418: THEN
3419: RAISE EXC_ERR_PVT_API_MAIN;
3420: END IF;
3421: END Initialize_Business_Object;

Line 3539: l_return_status := FND_API.G_RET_STS_SUCCESS;

3535: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');
3536: Error_Handler.Initialize;
3537:
3538: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;
3539: l_return_status := FND_API.G_RET_STS_SUCCESS;
3540: -- Strat processing for each component
3541: FOR rc in c_component_details
3542: LOOP
3543:

Line 3570: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

3566: , p_organization_id => p_local_organization_id
3567: , x_error_table => l_item_error_table
3568: , x_return_status => l_return_status);
3569: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Component Item Is auto enabled. l_return_status'||l_return_status);
3570: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
3571: THEN
3572: OPEN c_get_item_details(rc.component_item_id, p_local_organization_id);
3573: FETCH c_get_item_details INTO l_component_item_name;
3574: IF c_get_item_details%NOTFOUND

Line 3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL

3924:
3925: END LOOP; -- End of loop of revised components Only one is selected
3926:
3927: Eng_Eco_Pvt.Process_Rev_Comp(
3928: p_validation_level => FND_API.G_VALID_LEVEL_FULL
3929: , p_change_notice => p_revised_item_rec.eco_name
3930: , p_organization_id => p_local_organization_id
3931: , I => 1
3932: , p_rev_component_rec => l_rev_component_tbl(1)

Line 3943: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

3939: , x_Mesg_Token_Tbl => l_bo_Mesg_Token_Tbl
3940: , x_return_status => l_return_status
3941: , x_bill_sequence_id => p_revised_item_unexp_rec.bill_sequence_id
3942: );
3943: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3944: THEN
3945: RAISE EXC_EXP_SKIP_OBJECT;
3946: END IF;
3947: --

Line 3984: l_return_status := FND_API.G_RET_STS_ERROR;

3980: -- TODO: How to handle substitue component and reference designator errors
3981: EXCEPTION
3982: WHEN EXC_EXP_SKIP_OBJECT THEN
3983: -- Set the return status
3984: l_return_status := FND_API.G_RET_STS_ERROR;
3985: -- Log any messages that have been logged with the additional error
3986: -- message into error handler
3987: Eco_Error_Handler.Log_Error(
3988: p_error_status => l_return_status

Line 4039: l_return_status := FND_API.G_RET_STS_SUCCESS;

4035: l_err_text VARCHAR2(2000);
4036: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4037:
4038: BEGIN
4039: l_return_status := FND_API.G_RET_STS_SUCCESS;
4040:
4041: l_change_exists := G_VAL_NOT_EXISTS;
4042:
4043: OPEN c_change_notice;

Line 4049: l_return_status := FND_API.G_RET_STS_ERROR;

4045: CLOSE c_change_notice;
4046:
4047: IF l_change_exists = G_VAL_EXISTS
4048: THEN
4049: l_return_status := FND_API.G_RET_STS_ERROR;
4050: Error_Handler.Add_Error_Token(
4051: p_Message_Name => 'ENG_PRP_ECO_EXISTS'
4052: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4053: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 4063: l_return_status := FND_API.G_RET_STS_ERROR;

4059: IF c_change_notice%ISOPEN
4060: THEN
4061: CLOSE c_change_notice;
4062: END IF;
4063: l_return_status := FND_API.G_RET_STS_ERROR;
4064: END Check_Change_Existance;
4065:
4066: PROCEDURE Init_Local_Change_Lifecycle (
4067: p_local_change_id IN NUMBER

Line 4114: x_return_status := FND_API.G_RET_STS_SUCCESS;

4110: FROM eng_engineering_changes
4111: WHERE change_id = els.entity_id1
4112: AND status_type = 0);
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: OPEN c_get_schedule_enabled;
4116: FETCH c_get_schedule_enabled INTO l_schedule_immediately;
4117: CLOSE c_get_schedule_enabled;
4118: OPEN c_get_init_status;

Line 4157: x_return_status := FND_API.G_RET_STS_ERROR;

4153: IF c_get_schedule_enabled%ISOPEN
4154: THEN
4155: CLOSE c_get_schedule_enabled;
4156: END IF;
4157: x_return_status := FND_API.G_RET_STS_ERROR;
4158: END Init_Local_Change_Lifecycle;
4159:
4160: PROCEDURE Propagate_Change_Header (
4161: p_change_id IN NUMBER

Line 4320: l_return_status := FND_API.G_RET_STS_SUCCESS;

4316: WHERE (us.employee_id IS NULL AND (us.person_party_id = pa.party_id or (us.person_party_id is null and us.supplier_id = pa.party_id)))
4317: AND pa.party_id = v_party_id;
4318:
4319: BEGIN
4320: l_return_status := FND_API.G_RET_STS_SUCCESS;
4321: --
4322: -- Check if the change header has already been propagated
4323: --
4324: Propagated_Local_Change(

Line 4355: IF l_return_status = FND_API.G_RET_STS_ERROR

4351: , p_organization_id => p_local_organization_id
4352: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4353: , x_Return_Status => l_return_status
4354: );
4355: IF l_return_status = FND_API.G_RET_STS_ERROR
4356: THEN
4357: RAISE EXC_EXP_SKIP_OBJECT;
4358: END IF;
4359:

Line 4541: l_return_status := FND_API.G_RET_STS_ERROR;

4537: WHERE inventory_item_id = l_pk1_value
4538: AND organization_id = p_local_organization_id;
4539: EXCEPTION
4540: WHEN NO_DATA_FOUND THEN
4541: l_return_status := FND_API.G_RET_STS_ERROR;
4542: Error_Handler.Add_Error_Token(
4543: p_Message_Name => 'ENG_PRP_SUBJECT_ITEM_INVALID'
4544: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4545: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 4570: l_return_status := FND_API.G_RET_STS_ERROR;

4566: from mtl_item_revisions
4567: where revision_id = l_pk3_value);
4568: EXCEPTION
4569: WHEN NO_DATA_FOUND THEN
4570: l_return_status := FND_API.G_RET_STS_ERROR;
4571:
4572: l_token_tbl(1).token_name := 'ITEM';
4573: l_token_tbl(1).token_value := l_pk1_name;
4574:

Line 4761: IF l_return_status = FND_API.G_RET_STS_SUCCESS

4757: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl
4758: );
4759: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Propagation ECO l_return_status'|| l_return_status);
4760:
4761: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4762: THEN
4763:
4764: Eco_Error_Handler.Log_Error(
4765: p_error_status => FND_API.G_RET_STS_SUCCESS

Line 4765: p_error_status => FND_API.G_RET_STS_SUCCESS

4761: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4762: THEN
4763:
4764: Eco_Error_Handler.Log_Error(
4765: p_error_status => FND_API.G_RET_STS_SUCCESS
4766: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4767: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4768: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4769: , p_other_status => l_return_status

Line 4794: l_return_status := FND_API.G_RET_STS_ERROR;

4790: -- Rollback any changes that may have been made to the DB
4791: --
4792: ROLLBACK;
4793: -- Set the return status
4794: l_return_status := FND_API.G_RET_STS_ERROR;
4795: -- Log any messages that have been logged with the additional error
4796: -- message into error handler
4797: Eco_Error_Handler.Log_Error(
4798: p_error_status => l_return_status

Line 5003: l_return_status := FND_API.G_RET_STS_SUCCESS;

4999: l_sourcing_rules_exists := 2;
5000: -- Set Savepoint
5001: SAVEPOINT BEGIN_REV_ITEM_PROCESSING;
5002: -- Error Handling
5003: l_return_status := FND_API.G_RET_STS_SUCCESS;
5004: l_error_logged := G_VAL_FALSE;
5005: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;
5006:
5007: Error_Handler.Initialize;

Line 5005: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;

5001: SAVEPOINT BEGIN_REV_ITEM_PROCESSING;
5002: -- Error Handling
5003: l_return_status := FND_API.G_RET_STS_SUCCESS;
5004: l_error_logged := G_VAL_FALSE;
5005: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;
5006:
5007: Error_Handler.Initialize;
5008:
5009: IF (l_ris.enable_item_in_local_org = 'Y')

Line 5108: IF (l_new_item_revision IS NOT NULL AND l_new_item_revision <> FND_API.G_MISS_CHAR)

5104: END;
5105:
5106: l_new_item_revision := ri.new_item_revision;
5107:
5108: IF (l_new_item_revision IS NOT NULL AND l_new_item_revision <> FND_API.G_MISS_CHAR)
5109: THEN
5110: BEGIN
5111: select 1
5112: into l_new_revision_exists

Line 5135: (l_new_item_revision IS NULL OR l_new_item_revision = FND_API.G_MISS_CHAR) AND

5131: l_new_item_revision := NULL;
5132: END IF;
5133:
5134: IF (FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION') = '1') AND
5135: (l_new_item_revision IS NULL OR l_new_item_revision = FND_API.G_MISS_CHAR) AND
5136: ri.new_item_revision IS NOT NULL
5137: THEN
5138: l_token_tbl.delete;
5139:

Line 5182: IF (l_new_struc_revision IS NOT NULL AND l_new_struc_revision <> FND_API.G_MISS_CHAR)

5178: EXCEPTION
5179: WHEN NO_DATA_FOUND THEN
5180: l_current_struc_revision := NULL;
5181: END;*/
5182: IF (l_new_struc_revision IS NOT NULL AND l_new_struc_revision <> FND_API.G_MISS_CHAR)
5183: THEN
5184: l_new_revision_exists := 0;
5185: /* not supported in 11.5.10
5186: BEGIN

Line 5376: p_validation_level => FND_API.G_VALID_LEVEL_FULL

5372: l_revised_item_tbl(l_revised_item_count).transaction_type := 'CREATE';
5373: l_revised_item_tbl(l_revised_item_count).structure_type_name := l_structure_type_name;
5374:
5375: Eng_Eco_Pvt.Process_Rev_Item(
5376: p_validation_level => FND_API.G_VALID_LEVEL_FULL
5377: , p_change_notice => p_change_notice
5378: , p_organization_id => p_local_organization_id
5379: , I => l_revised_item_count
5380: , p_revised_item_rec => l_revised_item_tbl(l_revised_item_count)

Line 5401: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

5397: , x_disable_revision => l_disable_revision
5398: );
5399:
5400: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After processing revised item through BO return status is '||l_return_status);
5401: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5402: THEN
5403: RAISE EXC_EXP_SKIP_OBJECT;
5404: END IF;
5405:

Line 5419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

5415: , p_revised_item_unexp_rec => l_revised_item_unexp_rec
5416: , p_local_organization_id => p_local_organization_id
5417: , x_Return_Status => l_return_status
5418: );
5419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5420: THEN
5421: l_propagate_revised_item := G_VAL_FALSE;
5422: END IF;
5423: END LOOP;

Line 5436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

5432: , p_revised_item_unexp_rec => l_revised_item_unexp_rec
5433: , p_local_organization_id => p_local_organization_id
5434: , x_Return_Status => l_return_status
5435: );
5436: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5437: THEN
5438: l_propagate_revised_item := G_VAL_FALSE;
5439: END IF;
5440: END LOOP;

Line 5475: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS

5471: , x_return_status => l_attach_return_status
5472: , x_mesg_token_tbl => l_mesg_token_tbl
5473: );
5474:
5475: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS
5476: THEN
5477: l_propagate_revised_item := G_VAL_FALSE;
5478: END IF;
5479: IF l_propagate_revised_item = G_VAL_TRUE

Line 5491: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS

5487: , p_local_line_rev_id => l_local_line_rev_id
5488: , x_Return_Status => l_attach_return_status
5489: , x_mesg_token_tbl => l_mesg_token_tbl
5490: );
5491: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS
5492: THEN
5493: l_propagate_revised_item := G_VAL_FALSE;
5494: END IF;
5495: END IF;

Line 5507: IF (p_commit = FND_API.G_TRUE)

5503:
5504: END LOOP;
5505:
5506: -- Commit the changes if the api hasnt exit so far
5507: IF (p_commit = FND_API.G_TRUE)
5508: THEN
5509: COMMIT;
5510: END IF;
5511: Eco_Error_Handler.Log_Error(

Line 5549: l_return_status := FND_API.G_RET_STS_ERROR;

5545: CLOSE c_revised_items_data;
5546: End IF;
5547:
5548: -- Set the return status
5549: l_return_status := FND_API.G_RET_STS_ERROR;
5550: -- Log any messages that have been logged with the additional error
5551: -- message into error handler
5552: Eco_Error_Handler.Log_Error(
5553: p_error_status => l_return_status

Line 5591: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5587: THEN
5588: CLOSE c_revised_items_data;
5589: End IF;
5590: -- Set the return status
5591: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5592: l_err_text := G_PKG_NAME || ' : (Revised Item Propagation) ' || substrb(SQLERRM,1,200);
5593:
5594: Error_Handler.Add_Error_Token(
5595: p_Message_Name => NULL

Line 5732: IF NOT FND_API.Compatible_API_Call ( l_api_version

5728:
5729: BEGIN
5730: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);
5731: -- Standard call to check for call compatibility
5732: IF NOT FND_API.Compatible_API_Call ( l_api_version
5733: , p_api_version
5734: , l_api_name
5735: , G_PKG_NAME )
5736: THEN

Line 5737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5733: , p_api_version
5734: , l_api_name
5735: , G_PKG_NAME )
5736: THEN
5737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5738: END IF;
5739:
5740: --
5741: -- Initialize return status

Line 5742: l_return_status := FND_API.G_RET_STS_SUCCESS;

5738: END IF;
5739:
5740: --
5741: -- Initialize return status
5742: l_return_status := FND_API.G_RET_STS_SUCCESS;
5743: Error_Handler.Initialize;
5744: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
5745: -- Removed check for local orgs same master org when propagating change orders
5746: -- as if required this can be added to the Business Object ---- 6/15/2005

Line 5780: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

5776: , p_local_organization_id => p_local_organization_id
5777: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5778: , x_Return_Status => l_return_status
5779: );
5780: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5781: THEN
5782: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5783: RAISE EXC_EXP_SKIP_OBJECT;
5784: END IF;

Line 5824: , p_commit => FND_API.G_TRUE

5820: , p_organization_code => l_global_org_code
5821: , p_organization_id => p_organization_id
5822: , p_local_organization_code => l_org_code
5823: , p_local_organization_id => p_local_organization_id
5824: , p_commit => FND_API.G_TRUE
5825: , x_Return_Status => l_return_status
5826: );
5827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5828: THEN

Line 5827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

5823: , p_local_organization_id => p_local_organization_id
5824: , p_commit => FND_API.G_TRUE
5825: , x_Return_Status => l_return_status
5826: );
5827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5828: THEN
5829: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5830: END IF;
5831: END LOOP;

Line 6237: x_return_status := FND_API.G_RET_STS_SUCCESS;

6233: l_org_Idx NUMBER;
6234: l_orgs_Cnt NUMBER;
6235:
6236: BEGIN
6237: x_return_status := FND_API.G_RET_STS_SUCCESS;
6238: IF p_local_organization_id IS NOT NULL
6239: THEN
6240: x_organizations_list(1) := p_organization_id;
6241: x_organizations_list(2) := p_local_organization_id;

Line 6264: x_return_status := FND_API.G_RET_STS_ERROR;

6260: l_orgs_Cnt := x_organizations_list.COUNT;
6261: IF (l_orgs_Cnt IN (0, 1))
6262: THEN
6263: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists for propagating changes');
6264: x_return_status := FND_API.G_RET_STS_ERROR;
6265: END IF;
6266: END Get_Local_Orgs_List;
6267:
6268: -- ****************************************************************** --

Line 6353: IF l_return_status = FND_API.G_RET_STS_ERROR

6349: , p_local_organization_id => p_local_organization_id
6350: , x_organizations_list => l_org_code_list
6351: , x_return_status => l_return_status);
6352:
6353: IF l_return_status = FND_API.G_RET_STS_ERROR
6354: THEN
6355: RETURN;
6356: END IF;
6357:

Line 6445: IF NOT FND_API.Compatible_API_Call ( l_api_version

6441: -- Standard Start of API savepoint
6442: SAVEPOINT PreProcess_Propagate_Request;
6443: --
6444: -- Standard call to check for call compatibility
6445: IF NOT FND_API.Compatible_API_Call ( l_api_version
6446: ,p_api_version
6447: ,l_api_name
6448: ,G_PKG_NAME )
6449: THEN

Line 6450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6446: ,p_api_version
6447: ,l_api_name
6448: ,G_PKG_NAME )
6449: THEN
6450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6451: END IF;
6452: --
6453: -- Initialize message list if p_init_msg_list is set to TRUE.
6454: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 6454: IF FND_API.to_Boolean( p_init_msg_list ) THEN

6450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6451: END IF;
6452: --
6453: -- Initialize message list if p_init_msg_list is set to TRUE.
6454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6455: FND_MSG_PUB.initialize;
6456: END IF ;
6457: --
6458: -- Fetch the change details

Line 6473: IF l_return_status = FND_API.G_RET_STS_SUCCESS

6469: , x_organizations_list => l_org_code_list
6470: , x_return_status => l_return_status);
6471: --
6472: -- If successful , then proceed
6473: IF l_return_status = FND_API.G_RET_STS_SUCCESS
6474: THEN
6475: --
6476: -- For each organization, check if propagation process had already been
6477: -- initiated for the change in that organization

Line 6540: END IF; -- IF l_return_status = FND_API.G_RET_STS_SUCCESS

6536: , last_update_login = FND_GLOBAL.LOGIN_ID
6537: WHERE change_propagation_map_id = l_change_map_id;
6538: END IF; -- IF l_change_map_id IS NULL
6539: END LOOP; -- FOR l_org_count IN 2..l_org_code_list.LAST
6540: END IF; -- IF l_return_status = FND_API.G_RET_STS_SUCCESS
6541:
6542: -- Standard ending code ------------------------------------------------
6543: IF FND_API.To_Boolean ( p_commit ) THEN
6544: COMMIT WORK;

Line 6543: IF FND_API.To_Boolean ( p_commit ) THEN

6539: END LOOP; -- FOR l_org_count IN 2..l_org_code_list.LAST
6540: END IF; -- IF l_return_status = FND_API.G_RET_STS_SUCCESS
6541:
6542: -- Standard ending code ------------------------------------------------
6543: IF FND_API.To_Boolean ( p_commit ) THEN
6544: COMMIT WORK;
6545: END IF;
6546:
6547: EXCEPTION

Line 6555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6551: END IF;
6552: -- Begin Exception handling
6553: ROLLBACK TO PreProcess_Propagate_Request;
6554:
6555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6556: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6557: THEN
6558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6559: END IF;