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 2299: IF ((ri.new_item_revision = FND_API.G_MISS_CHAR) OR

2295: IF (l_item_exits_in_org_flag = 1) THEN
2296: l_revised_item_tbl(i).eco_name := ri.change_notice;
2297: l_revised_item_tbl(i).organization_code := l_org_code;
2298: l_revised_item_tbl(i).revised_item_name := l_revised_item_number;
2299: IF ((ri.new_item_revision = FND_API.G_MISS_CHAR) OR
2300: (ri.new_item_revision IS NULL)) THEN
2301: l_revised_item_tbl(i).new_revised_item_revision := NULL;
2302: ELSE
2303: l_revised_item_tbl(i).new_revised_item_revision :=

Line 3262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3258: , p_mesg_token_tbl => l_mesg_token_tbl
3259: , x_mesg_token_tbl => l_mesg_token_tbl
3260: );
3261:
3262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3263: THEN
3264: BOM_Globals.Set_Debug('N');
3265: BOM_Rtg_Globals.Set_Debug('N'); -- Added by MK on 11/08/00
3266: END IF;

Line 3276: l_return_status := FND_API.G_RET_STS_SUCCESS;

3272: Eng_Globals.Set_Org_Id( p_org_id => p_organization_id);
3273: -- Load environment information into the SYSTEM_INFORMATION record
3274: -- (USER_ID, LOGIN_ID, PROG_APPID, PROG_ID)
3275:
3276: l_return_status := FND_API.G_RET_STS_SUCCESS;
3277: ENG_GLOBALS.Init_System_Info_Rec(
3278: x_mesg_token_tbl => l_mesg_token_tbl
3279: , x_return_status => l_return_status
3280: );

Line 3292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

3288: BOM_Globals.Set_Unit_Effectivity (FALSE);
3289: ENG_Globals.Set_Unit_Effectivity (FALSE);
3290: END IF;
3291: x_return_status := l_return_status;
3292: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3293: THEN
3294: RAISE EXC_ERR_PVT_API_MAIN;
3295: END IF;
3296: END Initialize_Business_Object;

Line 3414: l_return_status := FND_API.G_RET_STS_SUCCESS;

3410: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'Propagate_Revised_Component.BEGIN');
3411: Error_Handler.Initialize;
3412:
3413: l_entity_action_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_SUCCESS;
3414: l_return_status := FND_API.G_RET_STS_SUCCESS;
3415: -- Strat processing for each component
3416: FOR rc in c_component_details
3417: LOOP
3418:

Line 3445: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)

3441: , p_organization_id => p_local_organization_id
3442: , x_error_table => l_item_error_table
3443: , x_return_status => l_return_status);
3444: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Component Item Is auto enabled. l_return_status'||l_return_status);
3445: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
3446: THEN
3447: OPEN c_get_item_details(rc.component_item_id, p_local_organization_id);
3448: FETCH c_get_item_details INTO l_component_item_name;
3449: IF c_get_item_details%NOTFOUND

Line 3803: p_validation_level => FND_API.G_VALID_LEVEL_FULL

3799:
3800: END LOOP; -- End of loop of revised components Only one is selected
3801:
3802: Eng_Eco_Pvt.Process_Rev_Comp(
3803: p_validation_level => FND_API.G_VALID_LEVEL_FULL
3804: , p_change_notice => p_revised_item_rec.eco_name
3805: , p_organization_id => p_local_organization_id
3806: , I => 1
3807: , p_rev_component_rec => l_rev_component_tbl(1)

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

3814: , x_Mesg_Token_Tbl => l_bo_Mesg_Token_Tbl
3815: , x_return_status => l_return_status
3816: , x_bill_sequence_id => p_revised_item_unexp_rec.bill_sequence_id
3817: );
3818: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
3819: THEN
3820: RAISE EXC_EXP_SKIP_OBJECT;
3821: END IF;
3822: --

Line 3859: l_return_status := FND_API.G_RET_STS_ERROR;

3855: -- TODO: How to handle substitue component and reference designator errors
3856: EXCEPTION
3857: WHEN EXC_EXP_SKIP_OBJECT THEN
3858: -- Set the return status
3859: l_return_status := FND_API.G_RET_STS_ERROR;
3860: -- Log any messages that have been logged with the additional error
3861: -- message into error handler
3862: Eco_Error_Handler.Log_Error(
3863: p_error_status => l_return_status

Line 3914: l_return_status := FND_API.G_RET_STS_SUCCESS;

3910: l_err_text VARCHAR2(2000);
3911: l_Token_Tbl Error_Handler.Token_Tbl_Type;
3912:
3913: BEGIN
3914: l_return_status := FND_API.G_RET_STS_SUCCESS;
3915:
3916: l_change_exists := G_VAL_NOT_EXISTS;
3917:
3918: OPEN c_change_notice;

Line 3924: l_return_status := FND_API.G_RET_STS_ERROR;

3920: CLOSE c_change_notice;
3921:
3922: IF l_change_exists = G_VAL_EXISTS
3923: THEN
3924: l_return_status := FND_API.G_RET_STS_ERROR;
3925: Error_Handler.Add_Error_Token(
3926: p_Message_Name => 'ENG_PRP_ECO_EXISTS'
3927: , p_Mesg_Token_Tbl => l_mesg_token_tbl
3928: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 3938: l_return_status := FND_API.G_RET_STS_ERROR;

3934: IF c_change_notice%ISOPEN
3935: THEN
3936: CLOSE c_change_notice;
3937: END IF;
3938: l_return_status := FND_API.G_RET_STS_ERROR;
3939: END Check_Change_Existance;
3940:
3941: PROCEDURE Init_Local_Change_Lifecycle (
3942: p_local_change_id IN NUMBER

Line 3989: x_return_status := FND_API.G_RET_STS_SUCCESS;

3985: FROM eng_engineering_changes
3986: WHERE change_id = els.entity_id1
3987: AND status_type = 0);
3988: BEGIN
3989: x_return_status := FND_API.G_RET_STS_SUCCESS;
3990: OPEN c_get_schedule_enabled;
3991: FETCH c_get_schedule_enabled INTO l_schedule_immediately;
3992: CLOSE c_get_schedule_enabled;
3993: OPEN c_get_init_status;

Line 4032: x_return_status := FND_API.G_RET_STS_ERROR;

4028: IF c_get_schedule_enabled%ISOPEN
4029: THEN
4030: CLOSE c_get_schedule_enabled;
4031: END IF;
4032: x_return_status := FND_API.G_RET_STS_ERROR;
4033: END Init_Local_Change_Lifecycle;
4034:
4035: PROCEDURE Propagate_Change_Header (
4036: p_change_id IN NUMBER

Line 4195: l_return_status := FND_API.G_RET_STS_SUCCESS;

4191: 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)))
4192: AND pa.party_id = v_party_id;
4193:
4194: BEGIN
4195: l_return_status := FND_API.G_RET_STS_SUCCESS;
4196: --
4197: -- Check if the change header has already been propagated
4198: --
4199: Propagated_Local_Change(

Line 4230: IF l_return_status = FND_API.G_RET_STS_ERROR

4226: , p_organization_id => p_local_organization_id
4227: , x_Mesg_Token_Tbl => l_mesg_token_tbl
4228: , x_Return_Status => l_return_status
4229: );
4230: IF l_return_status = FND_API.G_RET_STS_ERROR
4231: THEN
4232: RAISE EXC_EXP_SKIP_OBJECT;
4233: END IF;
4234:

Line 4416: l_return_status := FND_API.G_RET_STS_ERROR;

4412: WHERE inventory_item_id = l_pk1_value
4413: AND organization_id = p_local_organization_id;
4414: EXCEPTION
4415: WHEN NO_DATA_FOUND THEN
4416: l_return_status := FND_API.G_RET_STS_ERROR;
4417: Error_Handler.Add_Error_Token(
4418: p_Message_Name => 'ENG_PRP_SUBJECT_ITEM_INVALID'
4419: , p_Mesg_Token_Tbl => l_mesg_token_tbl
4420: , x_Mesg_Token_Tbl => l_mesg_token_tbl

Line 4445: l_return_status := FND_API.G_RET_STS_ERROR;

4441: from mtl_item_revisions
4442: where revision_id = l_pk3_value);
4443: EXCEPTION
4444: WHEN NO_DATA_FOUND THEN
4445: l_return_status := FND_API.G_RET_STS_ERROR;
4446:
4447: l_token_tbl(1).token_name := 'ITEM';
4448: l_token_tbl(1).token_value := l_pk1_name;
4449:

Line 4635: IF l_return_status = FND_API.G_RET_STS_SUCCESS

4631: , x_rev_sub_resource_tbl => l_rev_sub_resource_tbl
4632: );
4633: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After Propagation ECO l_return_status'|| l_return_status);
4634:
4635: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4636: THEN
4637:
4638: Eco_Error_Handler.Log_Error(
4639: p_error_status => FND_API.G_RET_STS_SUCCESS

Line 4639: p_error_status => FND_API.G_RET_STS_SUCCESS

4635: IF l_return_status = FND_API.G_RET_STS_SUCCESS
4636: THEN
4637:
4638: Eco_Error_Handler.Log_Error(
4639: p_error_status => FND_API.G_RET_STS_SUCCESS
4640: , p_error_scope => Error_Handler.G_SCOPE_RECORD
4641: , p_error_level => Eco_Error_Handler.G_ECO_LEVEL
4642: , p_other_message => 'ENG_PRP_CHG_ORDER_SUCC'
4643: , p_other_status => l_return_status

Line 4668: l_return_status := FND_API.G_RET_STS_ERROR;

4664: -- Rollback any changes that may have been made to the DB
4665: --
4666: ROLLBACK;
4667: -- Set the return status
4668: l_return_status := FND_API.G_RET_STS_ERROR;
4669: -- Log any messages that have been logged with the additional error
4670: -- message into error handler
4671: Eco_Error_Handler.Log_Error(
4672: p_error_status => l_return_status

Line 4876: l_return_status := FND_API.G_RET_STS_SUCCESS;

4872: l_sourcing_rules_exists := 2;
4873: -- Set Savepoint
4874: SAVEPOINT BEGIN_REV_ITEM_PROCESSING;
4875: -- Error Handling
4876: l_return_status := FND_API.G_RET_STS_SUCCESS;
4877: l_error_logged := G_VAL_FALSE;
4878: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;
4879:
4880: Error_Handler.Initialize;

Line 4878: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;

4874: SAVEPOINT BEGIN_REV_ITEM_PROCESSING;
4875: -- Error Handling
4876: l_return_status := FND_API.G_RET_STS_SUCCESS;
4877: l_error_logged := G_VAL_FALSE;
4878: l_attach_return_status := FND_API.G_RET_STS_SUCCESS;
4879:
4880: Error_Handler.Initialize;
4881:
4882: IF (l_ris.enable_item_in_local_org = 'Y')

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

4977: END;
4978:
4979: l_new_item_revision := ri.new_item_revision;
4980:
4981: IF (l_new_item_revision IS NOT NULL AND l_new_item_revision <> FND_API.G_MISS_CHAR)
4982: THEN
4983: BEGIN
4984: select 1
4985: into l_new_revision_exists

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

5004: l_new_item_revision := NULL;
5005: END IF;
5006:
5007: IF (FND_PROFILE.VALUE('ENG:ECO_REVISED_ITEM_REVISION') = '1') AND
5008: (l_new_item_revision IS NULL OR l_new_item_revision = FND_API.G_MISS_CHAR) AND
5009: ri.new_item_revision IS NOT NULL
5010: THEN
5011: l_token_tbl.delete;
5012:

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

5051: EXCEPTION
5052: WHEN NO_DATA_FOUND THEN
5053: l_current_struc_revision := NULL;
5054: END;*/
5055: IF (l_new_struc_revision IS NOT NULL AND l_new_struc_revision <> FND_API.G_MISS_CHAR)
5056: THEN
5057: l_new_revision_exists := 0;
5058: /* not supported in 11.5.10
5059: BEGIN

Line 5248: p_validation_level => FND_API.G_VALID_LEVEL_FULL

5244: l_revised_item_tbl(l_revised_item_count).transaction_type := 'CREATE';
5245: l_revised_item_tbl(l_revised_item_count).structure_type_name := l_structure_type_name;
5246:
5247: Eng_Eco_Pvt.Process_Rev_Item(
5248: p_validation_level => FND_API.G_VALID_LEVEL_FULL
5249: , p_change_notice => p_change_notice
5250: , p_organization_id => p_local_organization_id
5251: , I => l_revised_item_count
5252: , p_revised_item_rec => l_revised_item_tbl(l_revised_item_count)

Line 5273: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

5269: , x_disable_revision => l_disable_revision
5270: );
5271:
5272: Eng_Propagation_Log_Util.Debug_Log(G_LOG_STMT, 'After processing revised item through BO return status is '||l_return_status);
5273: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5274: THEN
5275: RAISE EXC_EXP_SKIP_OBJECT;
5276: END IF;
5277:

Line 5291: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

5287: , p_revised_item_unexp_rec => l_revised_item_unexp_rec
5288: , p_local_organization_id => p_local_organization_id
5289: , x_Return_Status => l_return_status
5290: );
5291: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5292: THEN
5293: l_propagate_revised_item := G_VAL_FALSE;
5294: END IF;
5295: END LOOP;

Line 5308: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

5304: , p_revised_item_unexp_rec => l_revised_item_unexp_rec
5305: , p_local_organization_id => p_local_organization_id
5306: , x_Return_Status => l_return_status
5307: );
5308: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
5309: THEN
5310: l_propagate_revised_item := G_VAL_FALSE;
5311: END IF;
5312: END LOOP;

Line 5347: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS

5343: , x_return_status => l_attach_return_status
5344: , x_mesg_token_tbl => l_mesg_token_tbl
5345: );
5346:
5347: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS
5348: THEN
5349: l_propagate_revised_item := G_VAL_FALSE;
5350: END IF;
5351: IF l_propagate_revised_item = G_VAL_TRUE

Line 5363: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS

5359: , p_local_line_rev_id => l_local_line_rev_id
5360: , x_Return_Status => l_attach_return_status
5361: , x_mesg_token_tbl => l_mesg_token_tbl
5362: );
5363: IF l_attach_return_status <> FND_API.G_RET_STS_SUCCESS
5364: THEN
5365: l_propagate_revised_item := G_VAL_FALSE;
5366: END IF;
5367: END IF;

Line 5379: IF (p_commit = FND_API.G_TRUE)

5375:
5376: END LOOP;
5377:
5378: -- Commit the changes if the api hasnt exit so far
5379: IF (p_commit = FND_API.G_TRUE)
5380: THEN
5381: COMMIT;
5382: END IF;
5383: Eco_Error_Handler.Log_Error(

Line 5421: l_return_status := FND_API.G_RET_STS_ERROR;

5417: CLOSE c_revised_items_data;
5418: End IF;
5419:
5420: -- Set the return status
5421: l_return_status := FND_API.G_RET_STS_ERROR;
5422: -- Log any messages that have been logged with the additional error
5423: -- message into error handler
5424: Eco_Error_Handler.Log_Error(
5425: p_error_status => l_return_status

Line 5463: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5459: THEN
5460: CLOSE c_revised_items_data;
5461: End IF;
5462: -- Set the return status
5463: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5464: l_err_text := G_PKG_NAME || ' : (Revised Item Propagation) ' || substrb(SQLERRM,1,200);
5465:
5466: Error_Handler.Add_Error_Token(
5467: p_Message_Name => NULL

Line 5591: IF NOT FND_API.Compatible_API_Call ( l_api_version

5587:
5588: BEGIN
5589: Eng_Propagation_Log_Util.Debug_Log(G_LOG_PROC, 'PROPAGATE_ECO_PLM.Begin For Organization: '|| l_org_code);
5590: -- Standard call to check for call compatibility
5591: IF NOT FND_API.Compatible_API_Call ( l_api_version
5592: , p_api_version
5593: , l_api_name
5594: , G_PKG_NAME )
5595: THEN

Line 5596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5592: , p_api_version
5593: , l_api_name
5594: , G_PKG_NAME )
5595: THEN
5596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5597: END IF;
5598:
5599: --
5600: -- Initialize return status

Line 5601: l_return_status := FND_API.G_RET_STS_SUCCESS;

5597: END IF;
5598:
5599: --
5600: -- Initialize return status
5601: l_return_status := FND_API.G_RET_STS_SUCCESS;
5602: Error_Handler.Initialize;
5603: ENG_GLOBALS.G_ENG_LAUNCH_IMPORT := 2 ;--Indicates call is from propagation
5604: -- Removed check for local orgs same master org when propagating change orders
5605: -- as if required this can be added to the Business Object ---- 6/15/2005

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

5635: , p_local_organization_id => p_local_organization_id
5636: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
5637: , x_Return_Status => l_return_status
5638: );
5639: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5640: THEN
5641: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5642: RAISE EXC_EXP_SKIP_OBJECT;
5643: END IF;

Line 5683: , p_commit => FND_API.G_TRUE

5679: , p_organization_code => l_global_org_code
5680: , p_organization_id => p_organization_id
5681: , p_local_organization_code => l_org_code
5682: , p_local_organization_id => p_local_organization_id
5683: , p_commit => FND_API.G_TRUE
5684: , x_Return_Status => l_return_status
5685: );
5686: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5687: THEN

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

5682: , p_local_organization_id => p_local_organization_id
5683: , p_commit => FND_API.G_TRUE
5684: , x_Return_Status => l_return_status
5685: );
5686: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5687: THEN
5688: l_top_entity_process_status := Eng_Propagation_Log_Util.G_PRP_PRC_STS_ERROR;
5689: END IF;
5690: END LOOP;

Line 5764: x_return_status := FND_API.G_RET_STS_SUCCESS;

5760: l_org_Idx NUMBER;
5761: l_orgs_Cnt NUMBER;
5762:
5763: BEGIN
5764: x_return_status := FND_API.G_RET_STS_SUCCESS;
5765: IF p_local_organization_id IS NOT NULL
5766: THEN
5767: x_organizations_list(1) := p_organization_id;
5768: x_organizations_list(2) := p_local_organization_id;

Line 5791: x_return_status := FND_API.G_RET_STS_ERROR;

5787: l_orgs_Cnt := x_organizations_list.COUNT;
5788: IF (l_orgs_Cnt IN (0, 1))
5789: THEN
5790: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No Organization exists for propagating changes');
5791: x_return_status := FND_API.G_RET_STS_ERROR;
5792: END IF;
5793: END Get_Local_Orgs_List;
5794:
5795: -- ****************************************************************** --

Line 5880: IF l_return_status = FND_API.G_RET_STS_ERROR

5876: , p_local_organization_id => p_local_organization_id
5877: , x_organizations_list => l_org_code_list
5878: , x_return_status => l_return_status);
5879:
5880: IF l_return_status = FND_API.G_RET_STS_ERROR
5881: THEN
5882: RETURN;
5883: END IF;
5884:

Line 5972: IF NOT FND_API.Compatible_API_Call ( l_api_version

5968: -- Standard Start of API savepoint
5969: SAVEPOINT PreProcess_Propagate_Request;
5970: --
5971: -- Standard call to check for call compatibility
5972: IF NOT FND_API.Compatible_API_Call ( l_api_version
5973: ,p_api_version
5974: ,l_api_name
5975: ,G_PKG_NAME )
5976: THEN

Line 5977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5973: ,p_api_version
5974: ,l_api_name
5975: ,G_PKG_NAME )
5976: THEN
5977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5978: END IF;
5979: --
5980: -- Initialize message list if p_init_msg_list is set to TRUE.
5981: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 5981: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5978: END IF;
5979: --
5980: -- Initialize message list if p_init_msg_list is set to TRUE.
5981: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5982: FND_MSG_PUB.initialize;
5983: END IF ;
5984: --
5985: -- Fetch the change details

Line 6000: IF l_return_status = FND_API.G_RET_STS_SUCCESS

5996: , x_organizations_list => l_org_code_list
5997: , x_return_status => l_return_status);
5998: --
5999: -- If successful , then proceed
6000: IF l_return_status = FND_API.G_RET_STS_SUCCESS
6001: THEN
6002: --
6003: -- For each organization, check if propagation process had already been
6004: -- initiated for the change in that organization

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

6063: , last_update_login = FND_GLOBAL.LOGIN_ID
6064: WHERE change_propagation_map_id = l_change_map_id;
6065: END IF; -- IF l_change_map_id IS NULL
6066: END LOOP; -- FOR l_org_count IN 2..l_org_code_list.LAST
6067: END IF; -- IF l_return_status = FND_API.G_RET_STS_SUCCESS
6068:
6069: -- Standard ending code ------------------------------------------------
6070: IF FND_API.To_Boolean ( p_commit ) THEN
6071: COMMIT WORK;

Line 6070: IF FND_API.To_Boolean ( p_commit ) THEN

6066: END LOOP; -- FOR l_org_count IN 2..l_org_code_list.LAST
6067: END IF; -- IF l_return_status = FND_API.G_RET_STS_SUCCESS
6068:
6069: -- Standard ending code ------------------------------------------------
6070: IF FND_API.To_Boolean ( p_commit ) THEN
6071: COMMIT WORK;
6072: END IF;
6073:
6074: EXCEPTION

Line 6082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6078: END IF;
6079: -- Begin Exception handling
6080: ROLLBACK TO PreProcess_Propagate_Request;
6081:
6082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6083: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6084: THEN
6085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
6086: END IF;