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

Line 493: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

489: and revision_number = l_rev_number(indx)
490: and organization_id = l_Org_Ids(indx);
491: Exception
492: WHEN OTHERS THEN
493: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
494: fnd_file.put_line(fnd_file.LOG, ' Error in Revision '||sqlerrm);
495: fnd_file.put_line(fnd_file.LOG, l_msg_data);
496: raise;
497:

Line 610: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

606: x_msg_count out nocopy number,
607: x_msg_data out nocopy varchar2)
608: is
609: l_api_name CONSTANT varchar2(30) := 'add_delete_ex_child';
610: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
611: l_dummy number;
612:
613: begin
614:

Line 615: x_return_status := FND_API.G_RET_STS_SUCCESS;

611: l_dummy number;
612:
613: begin
614:
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616: if FND_API.to_Boolean(p_init_msg_list) then
617: FND_MSG_PUB.initialize;
618: end if;
619:

Line 616: if FND_API.to_Boolean(p_init_msg_list) then

612:
613: begin
614:
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616: if FND_API.to_Boolean(p_init_msg_list) then
617: FND_MSG_PUB.initialize;
618: end if;
619:
620: if FND_GLOBAL.user_id is null then

Line 622: raise FND_API.G_EXC_ERROR;

618: end if;
619:
620: if FND_GLOBAL.user_id is null then
621: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
622: raise FND_API.G_EXC_ERROR;
623: end if;
624:
625: -- find out if the latest revision for parent_id is approved or not.
626: -- if approved, revise it. if draft, don't do anything

Line 645: when FND_API.G_EXC_ERROR then

641: end if;
642:
643:
644: exception
645: when FND_API.G_EXC_ERROR then
646: ROLLBACK;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
649: p_count => x_msg_count,

Line 647: x_return_status := FND_API.G_RET_STS_ERROR;

643:
644: exception
645: when FND_API.G_EXC_ERROR then
646: ROLLBACK;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
649: p_count => x_msg_count,
650: p_data => x_msg_data);
651:

Line 648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

644: exception
645: when FND_API.G_EXC_ERROR then
646: ROLLBACK;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
649: p_count => x_msg_count,
650: p_data => x_msg_data);
651:
652:

Line 653: when FND_API.G_EXC_UNEXPECTED_ERROR then

649: p_count => x_msg_count,
650: p_data => x_msg_data);
651:
652:
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: ROLLBACK;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,

Line 655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

651:
652:
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: ROLLBACK;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data);
659:

Line 656: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

652:
653: when FND_API.G_EXC_UNEXPECTED_ERROR then
654: ROLLBACK;
655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
656: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
657: p_count => x_msg_count,
658: p_data => x_msg_data);
659:
660: when OTHERS then

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

658: p_data => x_msg_data);
659:
660: when OTHERS then
661: ROLLBACK;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663:
664: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
665: p_procedure_name => l_api_name,
666: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 668: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

664: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,
665: p_procedure_name => l_api_name,
666: p_error_text => SUBSTRB(SQLERRM,1,240));
667:
668: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data);
671:
672: end add_delete_ex_child;

Line 975: p_check_for_existing => FND_API.G_FALSE);

971: p_end_date => party_list_rec.end_date,
972: x_return_status => l_return_status,
973: x_errorcode => l_msg_count,
974: x_grant_guid => l_msg_data,
975: p_check_for_existing => FND_API.G_FALSE);
976:
977: elsif party_list_rec.role_name = 'AMW_RL_PROC_FINANCE_OWNER_ROLE' then
978:
979: AMW_SECURITY_PUB.grant_role_guid

Line 997: p_check_for_existing => FND_API.G_FALSE);

993: p_end_date => party_list_rec.end_date,
994: x_return_status => l_return_status,
995: x_errorcode => l_msg_count,
996: x_grant_guid => l_msg_data,
997: p_check_for_existing => FND_API.G_FALSE);
998:
999: elsif party_list_rec.role_name = 'AMW_RL_PROC_APPL_OWNER_ROLE' then
1000:
1001: AMW_SECURITY_PUB.grant_role_guid

Line 1019: p_check_for_existing => FND_API.G_FALSE);

1015: p_end_date => party_list_rec.end_date,
1016: x_return_status => l_return_status,
1017: x_errorcode => l_msg_count,
1018: x_grant_guid => l_msg_data,
1019: p_check_for_existing => FND_API.G_FALSE);
1020:
1021: end if;
1022:
1023: end loop;

Line 2564: then raise FND_API.G_EXC_UNEXPECTED_ERROR;

2560:
2561: exception
2562:
2563: when others
2564: then raise FND_API.G_EXC_UNEXPECTED_ERROR;
2565:
2566: end upd_ltst_risk_count;
2567:
2568: -- ****************************************************************************

Line 2935: RAISE FND_API.G_EXC_ERROR;

2931: BEGIN
2932:
2933: IF FND_GLOBAL.User_Id IS NULL THEN
2934: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
2935: RAISE FND_API.G_EXC_ERROR;
2936: END IF;
2937: if p_process_id = -1 OR p_process_id = -2 then
2938: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');
2939: return;

Line 2967: p_update_count => FND_API.G_FALSE,

2963: p_org_id => l_audit_units_tbl(orgid).organization_id,
2964: p_mode => p_mode,
2965: p_apply_rcm => p_apply_rcm,
2966: p_synchronize => p_synchronize,
2967: p_update_count => FND_API.G_FALSE,
2968: p_commit => FND_API.G_FALSE,
2969: x_return_status => l_return_status,
2970: x_msg_count => l_msg_count,
2971: x_msg_data => l_msg_data);

Line 2968: p_commit => FND_API.G_FALSE,

2964: p_mode => p_mode,
2965: p_apply_rcm => p_apply_rcm,
2966: p_synchronize => p_synchronize,
2967: p_update_count => FND_API.G_FALSE,
2968: p_commit => FND_API.G_FALSE,
2969: x_return_status => l_return_status,
2970: x_msg_count => l_msg_count,
2971: x_msg_data => l_msg_data);
2972:

Line 2989: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);

2985: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
2986: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
2987: BEGIN
2988: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
2989: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
2990: EXCEPTION
2991: WHEN OTHERS THEN
2992: show_warning := true;
2993: ROLLBACK;

Line 2995: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

2991: WHEN OTHERS THEN
2992: show_warning := true;
2993: ROLLBACK;
2994: -- Unapproved object associations exists exception may happen..catche them here..
2995: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
2996: fnd_file.put_line(fnd_file.LOG, ' Error when Approving the process in organization ' ||l_audit_units_tbl(orgid).org_name );
2997: fnd_file.put_line(fnd_file.LOG, l_msg_data);
2998: END;
2999: END IF;

Line 3304: WHEN FND_API.G_EXC_ERROR THEN

3300: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_ORG_SRS.End','END');
3301: end if;
3302: EXCEPTION
3303:
3304: WHEN FND_API.G_EXC_ERROR THEN
3305: ROLLBACK;
3306: retcode := 2;
3307: errbuf := SUBSTR(SQLERRM,1,1000);
3308: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

Line 3310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3306: retcode := 2;
3307: errbuf := SUBSTR(SQLERRM,1,1000);
3308: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
3309:
3310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3311: ROLLBACK;
3312: retcode := 2;
3313: errbuf := SUBSTR(SQLERRM,1,1000);
3314: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

Line 3535: p_update_count => FND_API.G_FALSE,

3531: p_org_id => l_audit_units_tbl(orgid).organization_id,
3532: p_mode => p_mode,
3533: p_apply_rcm => p_apply_rcm,
3534: p_synchronize => p_synchronize,
3535: p_update_count => FND_API.G_FALSE,
3536: p_commit => FND_API.G_FALSE,
3537: x_return_status => l_return_status,
3538: x_msg_count => l_msg_count,
3539: x_msg_data => l_msg_data);

Line 3536: p_commit => FND_API.G_FALSE,

3532: p_mode => p_mode,
3533: p_apply_rcm => p_apply_rcm,
3534: p_synchronize => p_synchronize,
3535: p_update_count => FND_API.G_FALSE,
3536: p_commit => FND_API.G_FALSE,
3537: x_return_status => l_return_status,
3538: x_msg_count => l_msg_count,
3539: x_msg_data => l_msg_data);
3540:

Line 3557: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);

3553: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
3554: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
3555: BEGIN
3556: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
3557: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
3558: EXCEPTION
3559: WHEN OTHERS THEN
3560: show_warning := true;
3561: ROLLBACK;

Line 3563: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

3559: WHEN OTHERS THEN
3560: show_warning := true;
3561: ROLLBACK;
3562: -- Unapproved object associations exists exception may happen..catche them here..
3563: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
3564: fnd_file.put_line(fnd_file.LOG, ' Error when Approving the process in organization ' ||l_audit_units_tbl(orgid).org_name );
3565: fnd_file.put_line(fnd_file.LOG, l_msg_data);
3566: END;
3567: END IF;

Line 3757: p_update_count in varchar2 := FND_API.G_TRUE,

3753: p_org_id_string in varchar2,
3754: p_mode in varchar2,
3755: p_apply_rcm in varchar2,
3756: p_synchronize in varchar2,
3757: p_update_count in varchar2 := FND_API.G_TRUE,
3758: p_commit in varchar2 := FND_API.G_FALSE,
3759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3761: x_return_status out nocopy varchar2,

Line 3758: p_commit in varchar2 := FND_API.G_FALSE,

3754: p_mode in varchar2,
3755: p_apply_rcm in varchar2,
3756: p_synchronize in varchar2,
3757: p_update_count in varchar2 := FND_API.G_TRUE,
3758: p_commit in varchar2 := FND_API.G_FALSE,
3759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3761: x_return_status out nocopy varchar2,
3762: x_msg_count out nocopy number,

Line 3759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3755: p_apply_rcm in varchar2,
3756: p_synchronize in varchar2,
3757: p_update_count in varchar2 := FND_API.G_TRUE,
3758: p_commit in varchar2 := FND_API.G_FALSE,
3759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3761: x_return_status out nocopy varchar2,
3762: x_msg_count out nocopy number,
3763: x_msg_data out nocopy varchar2 )

Line 3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3756: p_synchronize in varchar2,
3757: p_update_count in varchar2 := FND_API.G_TRUE,
3758: p_commit in varchar2 := FND_API.G_FALSE,
3759: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3760: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3761: x_return_status out nocopy varchar2,
3762: x_msg_count out nocopy number,
3763: x_msg_data out nocopy varchar2 )
3764:

Line 3790: x_return_status := FND_API.G_RET_STS_SUCCESS;

3786:
3787:
3788: begin
3789:
3790: x_return_status := FND_API.G_RET_STS_SUCCESS;
3791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3792: FND_MSG_PUB.initialize;
3793: END IF;
3794: IF FND_GLOBAL.User_Id IS NULL THEN

Line 3791: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3787:
3788: begin
3789:
3790: x_return_status := FND_API.G_RET_STS_SUCCESS;
3791: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3792: FND_MSG_PUB.initialize;
3793: END IF;
3794: IF FND_GLOBAL.User_Id IS NULL THEN
3795: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 3796: RAISE FND_API.G_EXC_ERROR;

3792: FND_MSG_PUB.initialize;
3793: END IF;
3794: IF FND_GLOBAL.User_Id IS NULL THEN
3795: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3796: RAISE FND_API.G_EXC_ERROR;
3797: END IF;
3798:
3799:
3800: l_org_string := p_org_id_string;

Line 3822: raise FND_API.G_EXC_ERROR;

3818: x_msg_count => l_msg_count,
3819: x_msg_data => l_msg_data);
3820:
3821: if l_return_status <> 'S' then
3822: raise FND_API.G_EXC_ERROR;
3823: end if;
3824:
3825:
3826:

Line 3844: IF (p_update_count = FND_API.G_TRUE) THEN

3840:
3841: select LTRIM(str, 'x') into l_org_string from dual;
3842: end loop;
3843:
3844: IF (p_update_count = FND_API.G_TRUE) THEN
3845: -- update the org counts of the child process and its hierarchy....
3846: for descendents_rec in c1(p_process_id) loop
3847: exit when c1%notfound;
3848: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);

Line 3852: IF (p_commit = FND_API.G_TRUE) then

3848: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);
3849: end loop;
3850: END IF;
3851:
3852: IF (p_commit = FND_API.G_TRUE) then
3853: commit;
3854: END IF;
3855:
3856: exception

Line 3858: WHEN FND_API.G_EXC_ERROR THEN

3854: END IF;
3855:
3856: exception
3857:
3858: WHEN FND_API.G_EXC_ERROR THEN
3859: ROLLBACK;
3860: x_return_status := FND_API.G_RET_STS_ERROR;
3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3862:

Line 3860: x_return_status := FND_API.G_RET_STS_ERROR;

3856: exception
3857:
3858: WHEN FND_API.G_EXC_ERROR THEN
3859: ROLLBACK;
3860: x_return_status := FND_API.G_RET_STS_ERROR;
3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3862:
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;

Line 3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3857:
3858: WHEN FND_API.G_EXC_ERROR THEN
3859: ROLLBACK;
3860: x_return_status := FND_API.G_RET_STS_ERROR;
3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3862:
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3859: ROLLBACK;
3860: x_return_status := FND_API.G_RET_STS_ERROR;
3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3862:
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3867:

Line 3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3862:
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3867:
3868: WHEN OTHERS THEN
3869: ROLLBACK;

Line 3866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3862:
3863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3864: ROLLBACK;
3865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3867:
3868: WHEN OTHERS THEN
3869: ROLLBACK;
3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3866: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3867:
3868: WHEN OTHERS THEN
3869: ROLLBACK;
3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3872: THEN
3873: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3874: END IF;

Line 3875: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3872: THEN
3873: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3874: END IF;
3875: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
3876:
3877: end push_proc_org;
3878:
3879:

Line 3888: p_update_count in varchar2 := FND_API.G_TRUE,

3884: p_org_id in number,
3885: p_mode in varchar2,
3886: p_apply_rcm in varchar2,
3887: p_synchronize in varchar2,
3888: p_update_count in varchar2 := FND_API.G_TRUE,
3889: p_commit in varchar2 := FND_API.G_FALSE,
3890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3892: x_return_status out nocopy varchar2,

Line 3889: p_commit in varchar2 := FND_API.G_FALSE,

3885: p_mode in varchar2,
3886: p_apply_rcm in varchar2,
3887: p_synchronize in varchar2,
3888: p_update_count in varchar2 := FND_API.G_TRUE,
3889: p_commit in varchar2 := FND_API.G_FALSE,
3890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3892: x_return_status out nocopy varchar2,
3893: x_msg_count out nocopy number,

Line 3890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

3886: p_apply_rcm in varchar2,
3887: p_synchronize in varchar2,
3888: p_update_count in varchar2 := FND_API.G_TRUE,
3889: p_commit in varchar2 := FND_API.G_FALSE,
3890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3892: x_return_status out nocopy varchar2,
3893: x_msg_count out nocopy number,
3894: x_msg_data out nocopy varchar2 )

Line 3891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3887: p_synchronize in varchar2,
3888: p_update_count in varchar2 := FND_API.G_TRUE,
3889: p_commit in varchar2 := FND_API.G_FALSE,
3890: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3891: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3892: x_return_status out nocopy varchar2,
3893: x_msg_count out nocopy number,
3894: x_msg_data out nocopy varchar2 )
3895:

Line 3912: x_return_status := FND_API.G_RET_STS_SUCCESS;

3908: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.Begin',
3909: 'OrgId:' ||p_org_id || ';ProcessId:'||p_process_id
3910: ||';ParentProcessId:'||p_parent_orgprocess_id||';reviseExisting:'||p_synchronize||';ApplyRCM:'||p_apply_rcm);
3911: end if;
3912: x_return_status := FND_API.G_RET_STS_SUCCESS;
3913: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3914: FND_MSG_PUB.initialize;
3915: END IF;
3916: IF FND_GLOBAL.User_Id IS NULL THEN

Line 3913: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3909: 'OrgId:' ||p_org_id || ';ProcessId:'||p_process_id
3910: ||';ParentProcessId:'||p_parent_orgprocess_id||';reviseExisting:'||p_synchronize||';ApplyRCM:'||p_apply_rcm);
3911: end if;
3912: x_return_status := FND_API.G_RET_STS_SUCCESS;
3913: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3914: FND_MSG_PUB.initialize;
3915: END IF;
3916: IF FND_GLOBAL.User_Id IS NULL THEN
3917: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 3918: RAISE FND_API.G_EXC_ERROR;

3914: FND_MSG_PUB.initialize;
3915: END IF;
3916: IF FND_GLOBAL.User_Id IS NULL THEN
3917: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
3918: RAISE FND_API.G_EXC_ERROR;
3919: END IF;
3920:
3921: if( l_log_stmt_level >= l_curr_log_level ) then
3922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3949: IF p_update_count = FND_API.G_TRUE THEN

3945: 'Begin update denrom; OrgId:' ||p_org_id );
3946: end if;
3947: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_org_id);
3948: */
3949: IF p_update_count = FND_API.G_TRUE THEN
3950: -- ko update the risk1 counts of the child process..
3951: if( l_log_stmt_level >= l_curr_log_level ) then
3952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3953: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.update_counts',

Line 3962: if (p_commit = FND_API.G_TRUE) then

3958:
3959: upd_ltst_control_count(p_org_id => p_org_id, p_process_id => null);
3960: END IF;
3961:
3962: if (p_commit = FND_API.G_TRUE) then
3963: commit;
3964: end if;
3965:
3966: if( l_log_stmt_level >= l_curr_log_level ) then

Line 3974: WHEN FND_API.G_EXC_ERROR THEN

3970: end if;
3971:
3972: exception
3973:
3974: WHEN FND_API.G_EXC_ERROR THEN
3975: ROLLBACK;
3976:
3977: x_return_status := FND_API.G_RET_STS_ERROR;
3978: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 3977: x_return_status := FND_API.G_RET_STS_ERROR;

3973:
3974: WHEN FND_API.G_EXC_ERROR THEN
3975: ROLLBACK;
3976:
3977: x_return_status := FND_API.G_RET_STS_ERROR;
3978: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3979:
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: ROLLBACK;

Line 3978: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3974: WHEN FND_API.G_EXC_ERROR THEN
3975: ROLLBACK;
3976:
3977: x_return_status := FND_API.G_RET_STS_ERROR;
3978: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3979:
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: ROLLBACK;
3982:

Line 3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3976:
3977: x_return_status := FND_API.G_RET_STS_ERROR;
3978: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3979:
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: ROLLBACK;
3982:
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3984: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3979:
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: ROLLBACK;
3982:
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3984: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3985:
3986: WHEN OTHERS THEN
3987: ROLLBACK;

Line 3984: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: ROLLBACK;
3982:
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3984: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
3985:
3986: WHEN OTHERS THEN
3987: ROLLBACK;
3988:

Line 3989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3985:
3986: WHEN OTHERS THEN
3987: ROLLBACK;
3988:
3989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3990: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3991: THEN
3992: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3993: END IF;

Line 3994: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

3990: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3991: THEN
3992: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
3993: END IF;
3994: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
3995:
3996: end push_proc_per_org;
3997:
3998: -- **********************************************************************************************************

Line 4022: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4018: P_parent_id IN NUMBER,
4019: P_add_from IN VARCHAR2,
4020: p_revise_existing IN VARCHAR2,
4021: P_apply_rcm IN VARCHAR2,
4022: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4023: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4024: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4025: x_return_status OUT NOCOPY VARCHAR2,
4026: x_msg_count OUT NOCOPY VARCHAR2,

Line 4023: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4019: P_add_from IN VARCHAR2,
4020: p_revise_existing IN VARCHAR2,
4021: P_apply_rcm IN VARCHAR2,
4022: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4023: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4024: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4025: x_return_status OUT NOCOPY VARCHAR2,
4026: x_msg_count OUT NOCOPY VARCHAR2,
4027: x_msg_data OUT NOCOPY VARCHAR2)

Line 4024: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4020: p_revise_existing IN VARCHAR2,
4021: P_apply_rcm IN VARCHAR2,
4022: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4023: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4024: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4025: x_return_status OUT NOCOPY VARCHAR2,
4026: x_msg_count OUT NOCOPY VARCHAR2,
4027: x_msg_data OUT NOCOPY VARCHAR2)
4028:

Line 4048: x_return_status := FND_API.G_RET_STS_SUCCESS;

4044:
4045: --always initialize global variables in th api's used from SelfSerivice Fwk..
4046: G_USER_ID := FND_GLOBAL.USER_ID;
4047: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4048: x_return_status := FND_API.G_RET_STS_SUCCESS;
4049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4050: FND_MSG_PUB.initialize;
4051: END IF;
4052: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4049: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4045: --always initialize global variables in th api's used from SelfSerivice Fwk..
4046: G_USER_ID := FND_GLOBAL.USER_ID;
4047: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4048: x_return_status := FND_API.G_RET_STS_SUCCESS;
4049: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4050: FND_MSG_PUB.initialize;
4051: END IF;
4052: IF FND_GLOBAL.User_Id IS NULL THEN
4053: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4054: RAISE FND_API.G_EXC_ERROR;

4050: FND_MSG_PUB.initialize;
4051: END IF;
4052: IF FND_GLOBAL.User_Id IS NULL THEN
4053: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4054: RAISE FND_API.G_EXC_ERROR;
4055: END IF;
4056:
4057: -- Make sure latest revision of parent is existing in the organization..
4058:

Line 4148: WHEN FND_API.G_EXC_ERROR THEN

4144:
4145: END IF;
4146:
4147: exception
4148: WHEN FND_API.G_EXC_ERROR THEN
4149: ROLLBACK;
4150: x_return_status := FND_API.G_RET_STS_ERROR;
4151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4152:

Line 4150: x_return_status := FND_API.G_RET_STS_ERROR;

4146:
4147: exception
4148: WHEN FND_API.G_EXC_ERROR THEN
4149: ROLLBACK;
4150: x_return_status := FND_API.G_RET_STS_ERROR;
4151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4152:
4153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4154: ROLLBACK;

Line 4151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4147: exception
4148: WHEN FND_API.G_EXC_ERROR THEN
4149: ROLLBACK;
4150: x_return_status := FND_API.G_RET_STS_ERROR;
4151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4152:
4153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4154: ROLLBACK;
4155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4149: ROLLBACK;
4150: x_return_status := FND_API.G_RET_STS_ERROR;
4151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4152:
4153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4154: ROLLBACK;
4155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4157:

Line 4155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4152:
4153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4154: ROLLBACK;
4155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4157:
4158: WHEN OTHERS THEN
4159: ROLLBACK;

Line 4156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4152:
4153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4154: ROLLBACK;
4155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4157:
4158: WHEN OTHERS THEN
4159: ROLLBACK;
4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4156: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4157:
4158: WHEN OTHERS THEN
4159: ROLLBACK;
4160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4162: THEN
4163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4164: END IF;

Line 4165: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4162: THEN
4163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4164: END IF;
4165: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4166: END add_organization_child;
4167:
4168: -- **********************************************************************************************************
4169:

Line 4180: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4176: PROCEDURE delete_organization_child
4177: ( p_organization_id IN NUMBER,
4178: p_child_id IN NUMBER,
4179: P_parent_id IN NUMBER,
4180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4183: x_return_status OUT NOCOPY VARCHAR2,
4184: x_msg_count OUT NOCOPY VARCHAR2,

Line 4181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4177: ( p_organization_id IN NUMBER,
4178: p_child_id IN NUMBER,
4179: P_parent_id IN NUMBER,
4180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4183: x_return_status OUT NOCOPY VARCHAR2,
4184: x_msg_count OUT NOCOPY VARCHAR2,
4185: x_msg_data OUT NOCOPY VARCHAR2)

Line 4182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4178: p_child_id IN NUMBER,
4179: P_parent_id IN NUMBER,
4180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4183: x_return_status OUT NOCOPY VARCHAR2,
4184: x_msg_count OUT NOCOPY VARCHAR2,
4185: x_msg_data OUT NOCOPY VARCHAR2)
4186:

Line 4197: x_return_status := FND_API.G_RET_STS_SUCCESS;

4193:
4194: --always initialize global variables in th api's used from SelfSerivice Fwk..
4195: G_USER_ID := FND_GLOBAL.USER_ID;
4196: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4197: x_return_status := FND_API.G_RET_STS_SUCCESS;
4198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4199: FND_MSG_PUB.initialize;
4200: END IF;
4201: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4198: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4194: --always initialize global variables in th api's used from SelfSerivice Fwk..
4195: G_USER_ID := FND_GLOBAL.USER_ID;
4196: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4197: x_return_status := FND_API.G_RET_STS_SUCCESS;
4198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4199: FND_MSG_PUB.initialize;
4200: END IF;
4201: IF FND_GLOBAL.User_Id IS NULL THEN
4202: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4203: RAISE FND_API.G_EXC_ERROR;

4199: FND_MSG_PUB.initialize;
4200: END IF;
4201: IF FND_GLOBAL.User_Id IS NULL THEN
4202: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4203: RAISE FND_API.G_EXC_ERROR;
4204: END IF;
4205:
4206: -- Make sure latest revision of parent is existing in the organization..
4207:

Line 4256: WHEN FND_API.G_EXC_ERROR THEN

4252:
4253:
4254:
4255: exception
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: ROLLBACK;
4258: x_return_status := FND_API.G_RET_STS_ERROR;
4259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4260:

Line 4258: x_return_status := FND_API.G_RET_STS_ERROR;

4254:
4255: exception
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: ROLLBACK;
4258: x_return_status := FND_API.G_RET_STS_ERROR;
4259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4260:
4261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4262: ROLLBACK;

Line 4259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4255: exception
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: ROLLBACK;
4258: x_return_status := FND_API.G_RET_STS_ERROR;
4259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4260:
4261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4262: ROLLBACK;
4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4257: ROLLBACK;
4258: x_return_status := FND_API.G_RET_STS_ERROR;
4259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4260:
4261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4262: ROLLBACK;
4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4265:

Line 4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4259: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4260:
4261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4262: ROLLBACK;
4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4265:
4266: WHEN OTHERS THEN
4267: ROLLBACK;

Line 4264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4260:
4261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4262: ROLLBACK;
4263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4265:
4266: WHEN OTHERS THEN
4267: ROLLBACK;
4268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4264: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4265:
4266: WHEN OTHERS THEN
4267: ROLLBACK;
4268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4270: THEN
4271: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4272: END IF;

Line 4273: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4270: THEN
4271: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4272: END IF;
4273: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4274: END delete_organization_child;
4275:
4276: --============================================================================================================================================
4277:

Line 4281: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4277:
4278: PROCEDURE disassociate_org_process
4279: ( p_organization_id IN NUMBER,
4280: p_process_id IN NUMBER,
4281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4284: x_return_status OUT NOCOPY VARCHAR2,
4285: x_msg_count OUT NOCOPY VARCHAR2,

Line 4282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4278: PROCEDURE disassociate_org_process
4279: ( p_organization_id IN NUMBER,
4280: p_process_id IN NUMBER,
4281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4284: x_return_status OUT NOCOPY VARCHAR2,
4285: x_msg_count OUT NOCOPY VARCHAR2,
4286: x_msg_data OUT NOCOPY VARCHAR2)

Line 4283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4279: ( p_organization_id IN NUMBER,
4280: p_process_id IN NUMBER,
4281: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4282: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4284: x_return_status OUT NOCOPY VARCHAR2,
4285: x_msg_count OUT NOCOPY VARCHAR2,
4286: x_msg_data OUT NOCOPY VARCHAR2)
4287: IS

Line 4297: x_return_status := FND_API.G_RET_STS_SUCCESS;

4293:
4294: --always initialize global variables in th api's used from SelfSerivice Fwk..
4295: G_USER_ID := FND_GLOBAL.USER_ID;
4296: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4299: FND_MSG_PUB.initialize;
4300: END IF;
4301: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4298: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4294: --always initialize global variables in th api's used from SelfSerivice Fwk..
4295: G_USER_ID := FND_GLOBAL.USER_ID;
4296: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4299: FND_MSG_PUB.initialize;
4300: END IF;
4301: IF FND_GLOBAL.User_Id IS NULL THEN
4302: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4303: RAISE FND_API.G_EXC_ERROR;

4299: FND_MSG_PUB.initialize;
4300: END IF;
4301: IF FND_GLOBAL.User_Id IS NULL THEN
4302: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4303: RAISE FND_API.G_EXC_ERROR;
4304: END IF;
4305:
4306: -- Disassociation functionality is to delete the process as a child and mark the process as deleted
4307: disassociate_process_org(p_org_id => p_organization_id,p_process_id => p_process_id);

Line 4320: WHEN FND_API.G_EXC_ERROR THEN

4316:
4317: upd_ltst_control_count(p_org_id => p_organization_id, p_process_id => NULL);
4318:
4319: exception
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: ROLLBACK;
4322: x_return_status := FND_API.G_RET_STS_ERROR;
4323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4324:

Line 4322: x_return_status := FND_API.G_RET_STS_ERROR;

4318:
4319: exception
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: ROLLBACK;
4322: x_return_status := FND_API.G_RET_STS_ERROR;
4323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4324:
4325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4326: ROLLBACK;

Line 4323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4319: exception
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: ROLLBACK;
4322: x_return_status := FND_API.G_RET_STS_ERROR;
4323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4324:
4325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4326: ROLLBACK;
4327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4321: ROLLBACK;
4322: x_return_status := FND_API.G_RET_STS_ERROR;
4323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4324:
4325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4326: ROLLBACK;
4327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4328: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4329:

Line 4327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4323: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4324:
4325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4326: ROLLBACK;
4327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4328: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4329:
4330: WHEN OTHERS THEN
4331: ROLLBACK;

Line 4328: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4324:
4325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4326: ROLLBACK;
4327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4328: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4329:
4330: WHEN OTHERS THEN
4331: ROLLBACK;
4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4328: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4329:
4330: WHEN OTHERS THEN
4331: ROLLBACK;
4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4333: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4334: THEN
4335: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4336: END IF;

Line 4337: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4333: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4334: THEN
4335: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4336: END IF;
4337: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4338: END disassociate_org_process;
4339:
4340:
4341: --============================================================================================================================================

Line 4351: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4347: p_sync_hierarchy in varchar2,
4348: p_sync_attributes in varchar2,
4349: p_sync_rcm in varchar2,
4350: p_sync_people in varchar2,
4351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4354: x_return_status OUT NOCOPY VARCHAR2,
4355: x_msg_count OUT NOCOPY VARCHAR2,

Line 4352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4348: p_sync_attributes in varchar2,
4349: p_sync_rcm in varchar2,
4350: p_sync_people in varchar2,
4351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4354: x_return_status OUT NOCOPY VARCHAR2,
4355: x_msg_count OUT NOCOPY VARCHAR2,
4356: x_msg_data OUT NOCOPY VARCHAR2)

Line 4353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4349: p_sync_rcm in varchar2,
4350: p_sync_people in varchar2,
4351: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4353: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4354: x_return_status OUT NOCOPY VARCHAR2,
4355: x_msg_count OUT NOCOPY VARCHAR2,
4356: x_msg_data OUT NOCOPY VARCHAR2)
4357: IS

Line 4374: x_return_status := FND_API.G_RET_STS_SUCCESS;

4370:
4371: --always initialize global variables in th api's used from SelfSerivice Fwk..
4372: G_USER_ID := FND_GLOBAL.USER_ID;
4373: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4374: x_return_status := FND_API.G_RET_STS_SUCCESS;
4375: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4376: FND_MSG_PUB.initialize;
4377: END IF;
4378: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4375: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4371: --always initialize global variables in th api's used from SelfSerivice Fwk..
4372: G_USER_ID := FND_GLOBAL.USER_ID;
4373: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4374: x_return_status := FND_API.G_RET_STS_SUCCESS;
4375: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4376: FND_MSG_PUB.initialize;
4377: END IF;
4378: IF FND_GLOBAL.User_Id IS NULL THEN
4379: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4380: RAISE FND_API.G_EXC_ERROR;

4376: FND_MSG_PUB.initialize;
4377: END IF;
4378: IF FND_GLOBAL.User_Id IS NULL THEN
4379: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4380: RAISE FND_API.G_EXC_ERROR;
4381: END IF;
4382:
4383: -- do the basic validation..i.e. the process can not be locked state..
4384:

Line 4416: WHEN FND_API.G_EXC_ERROR THEN

4412:
4413:
4414:
4415: exception
4416: WHEN FND_API.G_EXC_ERROR THEN
4417: ROLLBACK;
4418: x_return_status := FND_API.G_RET_STS_ERROR;
4419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4420:

Line 4418: x_return_status := FND_API.G_RET_STS_ERROR;

4414:
4415: exception
4416: WHEN FND_API.G_EXC_ERROR THEN
4417: ROLLBACK;
4418: x_return_status := FND_API.G_RET_STS_ERROR;
4419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4420:
4421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4422: ROLLBACK;

Line 4419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4415: exception
4416: WHEN FND_API.G_EXC_ERROR THEN
4417: ROLLBACK;
4418: x_return_status := FND_API.G_RET_STS_ERROR;
4419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4420:
4421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4422: ROLLBACK;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4417: ROLLBACK;
4418: x_return_status := FND_API.G_RET_STS_ERROR;
4419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4420:
4421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4422: ROLLBACK;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4425:

Line 4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4420:
4421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4422: ROLLBACK;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4425:
4426: WHEN OTHERS THEN
4427: ROLLBACK;

Line 4424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4420:
4421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4422: ROLLBACK;
4423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4425:
4426: WHEN OTHERS THEN
4427: ROLLBACK;
4428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4425:
4426: WHEN OTHERS THEN
4427: ROLLBACK;
4428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4430: THEN
4431: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4432: END IF;

Line 4433: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4430: THEN
4431: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4432: END IF;
4433: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4434: END synchronize_org_process;
4435:
4436:
4437: --============================================================================================================================================

Line 4442: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4438:
4439: PROCEDURE update_latest_rc_counts
4440: ( p_organization_id IN NUMBER,
4441: P_process_id IN NUMBER,
4442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4445: x_return_status OUT NOCOPY VARCHAR2,
4446: x_msg_count OUT NOCOPY VARCHAR2,

Line 4443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4439: PROCEDURE update_latest_rc_counts
4440: ( p_organization_id IN NUMBER,
4441: P_process_id IN NUMBER,
4442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4445: x_return_status OUT NOCOPY VARCHAR2,
4446: x_msg_count OUT NOCOPY VARCHAR2,
4447: x_msg_data OUT NOCOPY VARCHAR2)

Line 4444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4440: ( p_organization_id IN NUMBER,
4441: P_process_id IN NUMBER,
4442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4443: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4445: x_return_status OUT NOCOPY VARCHAR2,
4446: x_msg_count OUT NOCOPY VARCHAR2,
4447: x_msg_data OUT NOCOPY VARCHAR2)
4448: IS

Line 4458: x_return_status := FND_API.G_RET_STS_SUCCESS;

4454:
4455: --always initialize global variables in th api's used from SelfSerivice Fwk..
4456: G_USER_ID := FND_GLOBAL.USER_ID;
4457: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4458: x_return_status := FND_API.G_RET_STS_SUCCESS;
4459: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4460: FND_MSG_PUB.initialize;
4461: END IF;
4462: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4459: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4455: --always initialize global variables in th api's used from SelfSerivice Fwk..
4456: G_USER_ID := FND_GLOBAL.USER_ID;
4457: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4458: x_return_status := FND_API.G_RET_STS_SUCCESS;
4459: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4460: FND_MSG_PUB.initialize;
4461: END IF;
4462: IF FND_GLOBAL.User_Id IS NULL THEN
4463: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4464: RAISE FND_API.G_EXC_ERROR;

4460: FND_MSG_PUB.initialize;
4461: END IF;
4462: IF FND_GLOBAL.User_Id IS NULL THEN
4463: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4464: RAISE FND_API.G_EXC_ERROR;
4465: END IF;
4466:
4467: -- Update the Risk Counts..
4468: upd_ltst_risk_count(p_org_id => p_organization_id, p_process_id => p_process_id);

Line 4474: WHEN FND_API.G_EXC_ERROR THEN

4470: upd_ltst_control_count(p_org_id => p_organization_id, p_process_id => p_process_id);
4471:
4472:
4473: exception
4474: WHEN FND_API.G_EXC_ERROR THEN
4475: ROLLBACK;
4476: x_return_status := FND_API.G_RET_STS_ERROR;
4477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4478:

Line 4476: x_return_status := FND_API.G_RET_STS_ERROR;

4472:
4473: exception
4474: WHEN FND_API.G_EXC_ERROR THEN
4475: ROLLBACK;
4476: x_return_status := FND_API.G_RET_STS_ERROR;
4477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4478:
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: ROLLBACK;

Line 4477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4473: exception
4474: WHEN FND_API.G_EXC_ERROR THEN
4475: ROLLBACK;
4476: x_return_status := FND_API.G_RET_STS_ERROR;
4477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4478:
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: ROLLBACK;
4481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4475: ROLLBACK;
4476: x_return_status := FND_API.G_RET_STS_ERROR;
4477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4478:
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: ROLLBACK;
4481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4483:

Line 4481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4477: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4478:
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: ROLLBACK;
4481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4483:
4484: WHEN OTHERS THEN
4485: ROLLBACK;

Line 4482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4478:
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: ROLLBACK;
4481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4483:
4484: WHEN OTHERS THEN
4485: ROLLBACK;
4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4483:
4484: WHEN OTHERS THEN
4485: ROLLBACK;
4486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4488: THEN
4489: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4490: END IF;

Line 4491: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4488: THEN
4489: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4490: END IF;
4491: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4492: END update_latest_rc_counts;
4493:
4494: --============================================================================================================================================
4495:

Line 4499: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4495:
4496: PROCEDURE update_approved_rc_counts
4497: ( p_organization_id IN NUMBER,
4498: P_process_id IN NUMBER,
4499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4502: x_return_status OUT NOCOPY VARCHAR2,
4503: x_msg_count OUT NOCOPY VARCHAR2,

Line 4500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4496: PROCEDURE update_approved_rc_counts
4497: ( p_organization_id IN NUMBER,
4498: P_process_id IN NUMBER,
4499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4502: x_return_status OUT NOCOPY VARCHAR2,
4503: x_msg_count OUT NOCOPY VARCHAR2,
4504: x_msg_data OUT NOCOPY VARCHAR2)

Line 4501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4497: ( p_organization_id IN NUMBER,
4498: P_process_id IN NUMBER,
4499: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4500: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4502: x_return_status OUT NOCOPY VARCHAR2,
4503: x_msg_count OUT NOCOPY VARCHAR2,
4504: x_msg_data OUT NOCOPY VARCHAR2)
4505: IS

Line 4515: x_return_status := FND_API.G_RET_STS_SUCCESS;

4511:
4512: --always initialize global variables in th api's used from SelfSerivice Fwk..
4513: G_USER_ID := FND_GLOBAL.USER_ID;
4514: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4515: x_return_status := FND_API.G_RET_STS_SUCCESS;
4516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4517: FND_MSG_PUB.initialize;
4518: END IF;
4519: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4516: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4512: --always initialize global variables in th api's used from SelfSerivice Fwk..
4513: G_USER_ID := FND_GLOBAL.USER_ID;
4514: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4515: x_return_status := FND_API.G_RET_STS_SUCCESS;
4516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4517: FND_MSG_PUB.initialize;
4518: END IF;
4519: IF FND_GLOBAL.User_Id IS NULL THEN
4520: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4521: RAISE FND_API.G_EXC_ERROR;

4517: FND_MSG_PUB.initialize;
4518: END IF;
4519: IF FND_GLOBAL.User_Id IS NULL THEN
4520: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4521: RAISE FND_API.G_EXC_ERROR;
4522: END IF;
4523:
4524: -- Update the Risk Counts..
4525: upd_appr_risk_count(p_org_id => p_organization_id, p_process_id => p_process_id);

Line 4531: WHEN FND_API.G_EXC_ERROR THEN

4527: upd_appr_control_count(p_org_id => p_organization_id, p_process_id => p_process_id);
4528:
4529:
4530: exception
4531: WHEN FND_API.G_EXC_ERROR THEN
4532: ROLLBACK;
4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4535:

Line 4533: x_return_status := FND_API.G_RET_STS_ERROR;

4529:
4530: exception
4531: WHEN FND_API.G_EXC_ERROR THEN
4532: ROLLBACK;
4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4535:
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: ROLLBACK;

Line 4534: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4530: exception
4531: WHEN FND_API.G_EXC_ERROR THEN
4532: ROLLBACK;
4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4535:
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: ROLLBACK;
4538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4532: ROLLBACK;
4533: x_return_status := FND_API.G_RET_STS_ERROR;
4534: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4535:
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: ROLLBACK;
4538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4540:

Line 4538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4534: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4535:
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: ROLLBACK;
4538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4540:
4541: WHEN OTHERS THEN
4542: ROLLBACK;

Line 4539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4535:
4536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4537: ROLLBACK;
4538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4540:
4541: WHEN OTHERS THEN
4542: ROLLBACK;
4543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4540:
4541: WHEN OTHERS THEN
4542: ROLLBACK;
4543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4545: THEN
4546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4547: END IF;

Line 4548: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4545: THEN
4546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4547: END IF;
4548: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4549: END update_approved_rc_counts;
4550:
4551:
4552: -- ===============================================================================================================================================================================

Line 4556: p_commit in varchar2 := FND_API.G_FALSE,

4552: -- ===============================================================================================================================================================================
4553: PROCEDURE insert_exception_justification (
4554: p_exception_Id IN Number,
4555: p_justification IN Varchar2,
4556: p_commit in varchar2 := FND_API.G_FALSE,
4557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4559: x_return_status out nocopy varchar2,
4560: x_msg_count out nocopy number,

Line 4557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

4553: PROCEDURE insert_exception_justification (
4554: p_exception_Id IN Number,
4555: p_justification IN Varchar2,
4556: p_commit in varchar2 := FND_API.G_FALSE,
4557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4559: x_return_status out nocopy varchar2,
4560: x_msg_count out nocopy number,
4561: x_msg_data out nocopy varchar2

Line 4558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4554: p_exception_Id IN Number,
4555: p_justification IN Varchar2,
4556: p_commit in varchar2 := FND_API.G_FALSE,
4557: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4558: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4559: x_return_status out nocopy varchar2,
4560: x_msg_count out nocopy number,
4561: x_msg_data out nocopy varchar2
4562: )

Line 4573: x_return_status := FND_API.G_RET_STS_SUCCESS;

4569:
4570: --always initialize global variables in th api's used from SelfSerivice Fwk..
4571: G_USER_ID := FND_GLOBAL.USER_ID;
4572: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4573: x_return_status := FND_API.G_RET_STS_SUCCESS;
4574: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4575: FND_MSG_PUB.initialize;
4576: END IF;
4577: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4574: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4570: --always initialize global variables in th api's used from SelfSerivice Fwk..
4571: G_USER_ID := FND_GLOBAL.USER_ID;
4572: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4573: x_return_status := FND_API.G_RET_STS_SUCCESS;
4574: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4575: FND_MSG_PUB.initialize;
4576: END IF;
4577: IF FND_GLOBAL.User_Id IS NULL THEN
4578: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4579: RAISE FND_API.G_EXC_ERROR;

4575: FND_MSG_PUB.initialize;
4576: END IF;
4577: IF FND_GLOBAL.User_Id IS NULL THEN
4578: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4579: RAISE FND_API.G_EXC_ERROR;
4580: END IF;
4581:
4582: -- insert the justification rows.
4583: insert into amw_exceptions_tl

Line 4615: WHEN FND_API.G_EXC_ERROR THEN

4611: and T.LANGUAGE = L.LANGUAGE_CODE);
4612:
4613:
4614: exception
4615: WHEN FND_API.G_EXC_ERROR THEN
4616: ROLLBACK;
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4619:

Line 4617: x_return_status := FND_API.G_RET_STS_ERROR;

4613:
4614: exception
4615: WHEN FND_API.G_EXC_ERROR THEN
4616: ROLLBACK;
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4619:
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: ROLLBACK;

Line 4618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4614: exception
4615: WHEN FND_API.G_EXC_ERROR THEN
4616: ROLLBACK;
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4619:
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: ROLLBACK;
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4616: ROLLBACK;
4617: x_return_status := FND_API.G_RET_STS_ERROR;
4618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4619:
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: ROLLBACK;
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4624:

Line 4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4619:
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: ROLLBACK;
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4624:
4625: WHEN OTHERS THEN
4626: ROLLBACK;

Line 4623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4619:
4620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4621: ROLLBACK;
4622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4624:
4625: WHEN OTHERS THEN
4626: ROLLBACK;
4627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4624:
4625: WHEN OTHERS THEN
4626: ROLLBACK;
4627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4629: THEN
4630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4631: END IF;

Line 4632: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

4628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4629: THEN
4630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4631: END IF;
4632: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4633: END insert_exception_justification;
4634:
4635: -- ===============================================================================================================================================================================
4636: function areChildListSame(p_organization_id IN NUMBER,p_process_id in number) return varchar is

Line 4713: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

4709: x_msg_count out nocopy number,
4710: x_msg_data out nocopy varchar2) is
4711:
4712: l_api_name constant varchar2(30) := 'isProcessUndoAble';
4713: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
4714: err_msg varchar2(4000);
4715: l_dummy number;
4716: appstatus varchar2(10);
4717:

Line 4722: x_return_status := FND_API.G_RET_STS_SUCCESS;

4718: begin
4719: --always initialize global variables in th api's used from SelfSerivice Fwk..
4720: G_USER_ID := FND_GLOBAL.USER_ID;
4721: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4722: x_return_status := FND_API.G_RET_STS_SUCCESS;
4723: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4724: FND_MSG_PUB.initialize;
4725: END IF;
4726: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4723: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4719: --always initialize global variables in th api's used from SelfSerivice Fwk..
4720: G_USER_ID := FND_GLOBAL.USER_ID;
4721: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4722: x_return_status := FND_API.G_RET_STS_SUCCESS;
4723: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4724: FND_MSG_PUB.initialize;
4725: END IF;
4726: IF FND_GLOBAL.User_Id IS NULL THEN
4727: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4728: RAISE FND_API.G_EXC_ERROR;

4724: FND_MSG_PUB.initialize;
4725: END IF;
4726: IF FND_GLOBAL.User_Id IS NULL THEN
4727: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4728: RAISE FND_API.G_EXC_ERROR;
4729: END IF;
4730:
4731: ret_value := 'N';
4732:

Line 4755: WHEN FND_API.G_EXC_ERROR THEN

4751: return;
4752: end if;
4753:
4754: exception
4755: WHEN FND_API.G_EXC_ERROR THEN
4756: ROLLBACK;
4757: x_return_status := FND_API.G_RET_STS_ERROR;
4758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4759: p_count => x_msg_count,

Line 4757: x_return_status := FND_API.G_RET_STS_ERROR;

4753:
4754: exception
4755: WHEN FND_API.G_EXC_ERROR THEN
4756: ROLLBACK;
4757: x_return_status := FND_API.G_RET_STS_ERROR;
4758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4759: p_count => x_msg_count,
4760: p_data => x_msg_data);
4761:

Line 4758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4754: exception
4755: WHEN FND_API.G_EXC_ERROR THEN
4756: ROLLBACK;
4757: x_return_status := FND_API.G_RET_STS_ERROR;
4758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4759: p_count => x_msg_count,
4760: p_data => x_msg_data);
4761:
4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4758: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4759: p_count => x_msg_count,
4760: p_data => x_msg_data);
4761:
4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4763: ROLLBACK;
4764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4765: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4766: p_count => x_msg_count,

Line 4764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4760: p_data => x_msg_data);
4761:
4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4763: ROLLBACK;
4764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4765: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4766: p_count => x_msg_count,
4767: p_data => x_msg_data);
4768:

Line 4765: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

4761:
4762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4763: ROLLBACK;
4764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4765: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4766: p_count => x_msg_count,
4767: p_data => x_msg_data);
4768:
4769: WHEN OTHERS THEN

Line 4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4767: p_data => x_msg_data);
4768:
4769: WHEN OTHERS THEN
4770: ROLLBACK;
4771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4773: THEN
4774: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4775: END IF;

Line 4776: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

4772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4773: THEN
4774: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
4775: END IF;
4776: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
4777: p_count => x_msg_count,
4778: p_data => x_msg_data);
4779: end;
4780:

Line 4792: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

4788: x_msg_count out nocopy number,
4789: x_msg_data out nocopy varchar2) is
4790:
4791: l_api_name constant varchar2(30) := 'delete_draft';
4792: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
4793: err_msg varchar2(4000);
4794: appexst varchar2(1);
4795: l_risk_exists boolean :=false;
4796: l_control_exists boolean :=false;

Line 4813: x_return_status := FND_API.G_RET_STS_SUCCESS;

4809: begin
4810: --always initialize global variables in th api's used from SelfSerivice Fwk..
4811: G_USER_ID := FND_GLOBAL.USER_ID;
4812: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4813: x_return_status := FND_API.G_RET_STS_SUCCESS;
4814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4815: FND_MSG_PUB.initialize;
4816: END IF;
4817: IF FND_GLOBAL.User_Id IS NULL THEN

Line 4814: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4810: --always initialize global variables in th api's used from SelfSerivice Fwk..
4811: G_USER_ID := FND_GLOBAL.USER_ID;
4812: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
4813: x_return_status := FND_API.G_RET_STS_SUCCESS;
4814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4815: FND_MSG_PUB.initialize;
4816: END IF;
4817: IF FND_GLOBAL.User_Id IS NULL THEN
4818: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 4819: RAISE FND_API.G_EXC_ERROR;

4815: FND_MSG_PUB.initialize;
4816: END IF;
4817: IF FND_GLOBAL.User_Id IS NULL THEN
4818: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
4819: RAISE FND_API.G_EXC_ERROR;
4820: END IF;
4821:
4822: select process_org_rev_id
4823: into previd from amw_process_organization

Line 4848: raise FND_API.G_EXC_ERROR;

4844: err_msg := fnd_message.get;
4845: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_ORG_hierarchy_pkg',
4846: p_procedure_name => 'delete_draft',
4847: p_error_text => err_msg);
4848: raise FND_API.G_EXC_ERROR;
4849: end if;
4850: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4852: end if;

Line 4850: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

4846: p_procedure_name => 'delete_draft',
4847: p_error_text => err_msg);
4848: raise FND_API.G_EXC_ERROR;
4849: end if;
4850: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4852: end if;
4853:
4854:

Line 4851: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4847: p_error_text => err_msg);
4848: raise FND_API.G_EXC_ERROR;
4849: end if;
4850: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4851: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4852: end if;
4853:
4854:
4855:

Line 5023: WHEN FND_API.G_EXC_ERROR THEN

5019:
5020: end if;
5021:
5022: exception
5023: WHEN FND_API.G_EXC_ERROR THEN
5024: ROLLBACK;
5025: x_return_status := FND_API.G_RET_STS_ERROR;
5026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5027: p_count => x_msg_count,

Line 5025: x_return_status := FND_API.G_RET_STS_ERROR;

5021:
5022: exception
5023: WHEN FND_API.G_EXC_ERROR THEN
5024: ROLLBACK;
5025: x_return_status := FND_API.G_RET_STS_ERROR;
5026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5027: p_count => x_msg_count,
5028: p_data => x_msg_data);
5029:

Line 5026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

5022: exception
5023: WHEN FND_API.G_EXC_ERROR THEN
5024: ROLLBACK;
5025: x_return_status := FND_API.G_RET_STS_ERROR;
5026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5027: p_count => x_msg_count,
5028: p_data => x_msg_data);
5029:
5030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5026: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5027: p_count => x_msg_count,
5028: p_data => x_msg_data);
5029:
5030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5031: ROLLBACK;
5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5034: p_count => x_msg_count,

Line 5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5028: p_data => x_msg_data);
5029:
5030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5031: ROLLBACK;
5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5034: p_count => x_msg_count,
5035: p_data => x_msg_data);
5036:

Line 5033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

5029:
5030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5031: ROLLBACK;
5032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5034: p_count => x_msg_count,
5035: p_data => x_msg_data);
5036:
5037: WHEN OTHERS THEN

Line 5039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5035: p_data => x_msg_data);
5036:
5037: WHEN OTHERS THEN
5038: ROLLBACK;
5039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5041: THEN
5042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5043: END IF;

Line 5044: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

5040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5041: THEN
5042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5043: END IF;
5044: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
5045: p_count => x_msg_count,
5046: p_data => x_msg_data);
5047: end;
5048:

Line 5059: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

5055: x_msg_count out nocopy number,
5056: x_msg_data out nocopy varchar2) is
5057:
5058: l_api_name constant varchar2(30) := 'UPDATE_ORG_PROC_AP';
5059: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
5060: err_msg varchar2(4000);
5061:
5062: begin
5063: --always initialize global variables in th api's used from SelfSerivice Fwk..

Line 5066: x_return_status := FND_API.G_RET_STS_SUCCESS;

5062: begin
5063: --always initialize global variables in th api's used from SelfSerivice Fwk..
5064: G_USER_ID := FND_GLOBAL.USER_ID;
5065: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
5066: x_return_status := FND_API.G_RET_STS_SUCCESS;
5067: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5068: FND_MSG_PUB.initialize;
5069: END IF;
5070: IF FND_GLOBAL.User_Id IS NULL THEN

Line 5067: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5063: --always initialize global variables in th api's used from SelfSerivice Fwk..
5064: G_USER_ID := FND_GLOBAL.USER_ID;
5065: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
5066: x_return_status := FND_API.G_RET_STS_SUCCESS;
5067: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5068: FND_MSG_PUB.initialize;
5069: END IF;
5070: IF FND_GLOBAL.User_Id IS NULL THEN
5071: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 5072: RAISE FND_API.G_EXC_ERROR;

5068: FND_MSG_PUB.initialize;
5069: END IF;
5070: IF FND_GLOBAL.User_Id IS NULL THEN
5071: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5072: RAISE FND_API.G_EXC_ERROR;
5073: END IF;
5074:
5075:
5076: insert into amw_ap_associations

Line 5148: WHEN FND_API.G_EXC_ERROR THEN

5144: AND PK2 = p_process_id
5145: AND approval_date is null);
5146:
5147: exception
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: ROLLBACK;
5150: x_return_status := FND_API.G_RET_STS_ERROR;
5151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5152: p_count => x_msg_count,

Line 5150: x_return_status := FND_API.G_RET_STS_ERROR;

5146:
5147: exception
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: ROLLBACK;
5150: x_return_status := FND_API.G_RET_STS_ERROR;
5151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5152: p_count => x_msg_count,
5153: p_data => x_msg_data);
5154:

Line 5151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

5147: exception
5148: WHEN FND_API.G_EXC_ERROR THEN
5149: ROLLBACK;
5150: x_return_status := FND_API.G_RET_STS_ERROR;
5151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5152: p_count => x_msg_count,
5153: p_data => x_msg_data);
5154:
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5151: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5152: p_count => x_msg_count,
5153: p_data => x_msg_data);
5154:
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: ROLLBACK;
5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5159: p_count => x_msg_count,

Line 5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5153: p_data => x_msg_data);
5154:
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: ROLLBACK;
5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5159: p_count => x_msg_count,
5160: p_data => x_msg_data);
5161:

Line 5158: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

5154:
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: ROLLBACK;
5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5159: p_count => x_msg_count,
5160: p_data => x_msg_data);
5161:
5162: WHEN OTHERS THEN

Line 5164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5160: p_data => x_msg_data);
5161:
5162: WHEN OTHERS THEN
5163: ROLLBACK;
5164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5166: THEN
5167: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5168: END IF;

Line 5169: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

5165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5166: THEN
5167: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5168: END IF;
5169: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
5170: p_count => x_msg_count,
5171: p_data => x_msg_data);
5172: end;
5173:

Line 5183: p_init_msg_list varchar2(10) := FND_API.G_FALSE;

5179: x_msg_count out nocopy number,
5180: x_msg_data out nocopy varchar2) is
5181:
5182: l_api_name constant varchar2(30) := 'UPDATE_ENTITY_AP';
5183: p_init_msg_list varchar2(10) := FND_API.G_FALSE;
5184: err_msg varchar2(4000);
5185:
5186: begin
5187: --always initialize global variables in th api's used from SelfSerivice Fwk..

Line 5190: x_return_status := FND_API.G_RET_STS_SUCCESS;

5186: begin
5187: --always initialize global variables in th api's used from SelfSerivice Fwk..
5188: G_USER_ID := FND_GLOBAL.USER_ID;
5189: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
5190: x_return_status := FND_API.G_RET_STS_SUCCESS;
5191: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5192: FND_MSG_PUB.initialize;
5193: END IF;
5194: IF FND_GLOBAL.User_Id IS NULL THEN

Line 5191: IF FND_API.to_Boolean( p_init_msg_list ) THEN

5187: --always initialize global variables in th api's used from SelfSerivice Fwk..
5188: G_USER_ID := FND_GLOBAL.USER_ID;
5189: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
5190: x_return_status := FND_API.G_RET_STS_SUCCESS;
5191: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5192: FND_MSG_PUB.initialize;
5193: END IF;
5194: IF FND_GLOBAL.User_Id IS NULL THEN
5195: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 5196: RAISE FND_API.G_EXC_ERROR;

5192: FND_MSG_PUB.initialize;
5193: END IF;
5194: IF FND_GLOBAL.User_Id IS NULL THEN
5195: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
5196: RAISE FND_API.G_EXC_ERROR;
5197: END IF;
5198:
5199:
5200: insert into amw_ap_associations

Line 5264: WHEN FND_API.G_EXC_ERROR THEN

5260: AND PK1 = p_organization_id
5261: );
5262:
5263: exception
5264: WHEN FND_API.G_EXC_ERROR THEN
5265: ROLLBACK;
5266: x_return_status := FND_API.G_RET_STS_ERROR;
5267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5268: p_count => x_msg_count,

Line 5266: x_return_status := FND_API.G_RET_STS_ERROR;

5262:
5263: exception
5264: WHEN FND_API.G_EXC_ERROR THEN
5265: ROLLBACK;
5266: x_return_status := FND_API.G_RET_STS_ERROR;
5267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5268: p_count => x_msg_count,
5269: p_data => x_msg_data);
5270:

Line 5267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

5263: exception
5264: WHEN FND_API.G_EXC_ERROR THEN
5265: ROLLBACK;
5266: x_return_status := FND_API.G_RET_STS_ERROR;
5267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5268: p_count => x_msg_count,
5269: p_data => x_msg_data);
5270:
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5268: p_count => x_msg_count,
5269: p_data => x_msg_data);
5270:
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: ROLLBACK;
5273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5274: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5275: p_count => x_msg_count,

Line 5273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5269: p_data => x_msg_data);
5270:
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: ROLLBACK;
5273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5274: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5275: p_count => x_msg_count,
5276: p_data => x_msg_data);
5277:

Line 5274: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

5270:
5271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5272: ROLLBACK;
5273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5274: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
5275: p_count => x_msg_count,
5276: p_data => x_msg_data);
5277:
5278: WHEN OTHERS THEN

Line 5280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5276: p_data => x_msg_data);
5277:
5278: WHEN OTHERS THEN
5279: ROLLBACK;
5280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5282: THEN
5283: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5284: END IF;

Line 5285: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

5281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5282: THEN
5283: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
5284: END IF;
5285: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
5286: p_count => x_msg_count,
5287: p_data => x_msg_data);
5288: end;
5289:

Line 7320: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

7316: END IF;
7317:
7318: Exception
7319: when others then
7320: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
7321: fnd_file.put_line(fnd_file.LOG, ' Error in sync_people_revoke_grant '||sqlerrm);
7322: fnd_file.put_line(fnd_file.LOG, l_msg_data);
7323: raise;
7324: END ;

Line 7421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

7417: END IF;
7418:
7419: Exception
7420: when others then
7421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
7422: fnd_file.put_line(fnd_file.LOG, ' Error in sync_people_add_grant '||sqlerrm);
7423: fnd_file.put_line(fnd_file.LOG, l_msg_data);
7424: raise;
7425:

Line 7452: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

7448: sync_people_add_grant(Org_Ids(indx),p_process_id,'AMW_ORG_PROC_APPL_OWNER_ROLE','AMW_RL_PROC_APPL_OWNER_ROLE');
7449: END LOOP;
7450: EXCEPTION
7451: when others then
7452: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
7453: fnd_file.put_line(fnd_file.LOG, ' Error in sync_process_people '||sqlerrm);
7454: fnd_file.put_line(fnd_file.LOG, l_msg_data);
7455: raise;
7456: END;

Line 7797: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

7793: END IF;
7794: END IF;
7795: EXCEPTION
7796: when pending_approval_exception then
7797: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
7798: fnd_file.put_line(fnd_file.LOG, ' Error in Revision '||sqlerrm);
7799: fnd_file.put_line(fnd_file.LOG, l_msg_data);
7800:
7801: raise;

Line 7803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

7799: fnd_file.put_line(fnd_file.LOG, l_msg_data);
7800:
7801: raise;
7802: WHEN no_data_found THEN
7803: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
7804: fnd_file.put_line(fnd_file.LOG, ' Error in Revision '||sqlerrm);
7805: fnd_file.put_line(fnd_file.LOG, l_msg_data);
7806:
7807: return;

Line 7818: p_commit in varchar2 := FND_API.G_FALSE,

7814: p_sync_hierarchy in varchar2,
7815: p_sync_attributes in varchar2,
7816: p_sync_rcm in varchar2,
7817: p_sync_people in varchar2,
7818: p_commit in varchar2 := FND_API.G_FALSE,
7819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7821: x_return_status out nocopy varchar2,
7822: x_msg_count out nocopy number,

Line 7819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

7815: p_sync_attributes in varchar2,
7816: p_sync_rcm in varchar2,
7817: p_sync_people in varchar2,
7818: p_commit in varchar2 := FND_API.G_FALSE,
7819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7821: x_return_status out nocopy varchar2,
7822: x_msg_count out nocopy number,
7823: x_msg_data out nocopy varchar2 )is

Line 7820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7816: p_sync_rcm in varchar2,
7817: p_sync_people in varchar2,
7818: p_commit in varchar2 := FND_API.G_FALSE,
7819: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
7820: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7821: x_return_status out nocopy varchar2,
7822: x_msg_count out nocopy number,
7823: x_msg_data out nocopy varchar2 )is
7824:

Line 7844: x_return_status := FND_API.G_RET_STS_SUCCESS;

7840:
7841:
7842: begin
7843:
7844: x_return_status := FND_API.G_RET_STS_SUCCESS;
7845: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7846: FND_MSG_PUB.initialize;
7847: END IF;
7848: IF FND_GLOBAL.User_Id IS NULL THEN

Line 7845: IF FND_API.to_Boolean( p_init_msg_list ) THEN

7841:
7842: begin
7843:
7844: x_return_status := FND_API.G_RET_STS_SUCCESS;
7845: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7846: FND_MSG_PUB.initialize;
7847: END IF;
7848: IF FND_GLOBAL.User_Id IS NULL THEN
7849: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 7850: RAISE FND_API.G_EXC_ERROR;

7846: FND_MSG_PUB.initialize;
7847: END IF;
7848: IF FND_GLOBAL.User_Id IS NULL THEN
7849: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
7850: RAISE FND_API.G_EXC_ERROR;
7851: END IF;
7852:
7853:
7854: l_org_string := p_org_id_string;

Line 7893: WHEN FND_API.G_EXC_ERROR THEN

7889: end loop;
7890:
7891: exception
7892:
7893: WHEN FND_API.G_EXC_ERROR THEN
7894: ROLLBACK;
7895: x_return_status := FND_API.G_RET_STS_ERROR;
7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7897:

Line 7895: x_return_status := FND_API.G_RET_STS_ERROR;

7891: exception
7892:
7893: WHEN FND_API.G_EXC_ERROR THEN
7894: ROLLBACK;
7895: x_return_status := FND_API.G_RET_STS_ERROR;
7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7897:
7898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7899: ROLLBACK;

Line 7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

7892:
7893: WHEN FND_API.G_EXC_ERROR THEN
7894: ROLLBACK;
7895: x_return_status := FND_API.G_RET_STS_ERROR;
7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7897:
7898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7899: ROLLBACK;
7900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7894: ROLLBACK;
7895: x_return_status := FND_API.G_RET_STS_ERROR;
7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7897:
7898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7899: ROLLBACK;
7900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7902:

Line 7900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7896: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7897:
7898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7899: ROLLBACK;
7900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7902:
7903: WHEN OTHERS THEN
7904: ROLLBACK;

Line 7901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

7897:
7898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7899: ROLLBACK;
7900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7902:
7903: WHEN OTHERS THEN
7904: ROLLBACK;
7905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
7902:
7903: WHEN OTHERS THEN
7904: ROLLBACK;
7905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7907: THEN
7908: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7909: END IF;

Line 7910: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

7906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7907: THEN
7908: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
7909: END IF;
7910: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
7911:
7912: end sync_proc_organizations;
7913:
7914:

Line 8002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

7998:
7999: procedure delete_activities(p_parent_process_id in number,
8000: p_organization_id in number,
8001: p_child_id_string in varchar2,
8002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8003: x_return_status out nocopy varchar2,
8004: x_msg_count out nocopy number,
8005: x_msg_data out nocopy varchar2)
8006: is

Line 8016: x_return_status := FND_API.G_RET_STS_SUCCESS;

8012: l_child_id number;
8013:
8014: begin
8015:
8016: x_return_status := FND_API.G_RET_STS_SUCCESS;
8017: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8018: FND_MSG_PUB.initialize;
8019: END IF;
8020: if FND_GLOBAL.user_id is null then

Line 8017: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8013:
8014: begin
8015:
8016: x_return_status := FND_API.G_RET_STS_SUCCESS;
8017: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8018: FND_MSG_PUB.initialize;
8019: END IF;
8020: if FND_GLOBAL.user_id is null then
8021: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 8022: raise FND_API.G_EXC_ERROR;

8018: FND_MSG_PUB.initialize;
8019: END IF;
8020: if FND_GLOBAL.user_id is null then
8021: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8022: raise FND_API.G_EXC_ERROR;
8023: end if;
8024:
8025: --check if parent_process_id is null
8026: if p_parent_process_id is null or p_organization_id is null then

Line 8027: raise FND_API.G_EXC_ERROR;

8023: end if;
8024:
8025: --check if parent_process_id is null
8026: if p_parent_process_id is null or p_organization_id is null then
8027: raise FND_API.G_EXC_ERROR;
8028: end if;
8029:
8030: l_child_string := p_child_id_string;
8031: while LENGTH(l_child_string) <> 0 loop

Line 8048: WHEN FND_API.G_EXC_ERROR THEN

8044:
8045: select LTRIM(str, 'x') into l_child_string from dual;
8046: end loop;
8047: exception
8048: WHEN FND_API.G_EXC_ERROR THEN
8049: ROLLBACK;
8050: x_return_status := FND_API.G_RET_STS_ERROR;
8051: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8052:

Line 8050: x_return_status := FND_API.G_RET_STS_ERROR;

8046: end loop;
8047: exception
8048: WHEN FND_API.G_EXC_ERROR THEN
8049: ROLLBACK;
8050: x_return_status := FND_API.G_RET_STS_ERROR;
8051: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8052:
8053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8054: ROLLBACK;

Line 8051: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8047: exception
8048: WHEN FND_API.G_EXC_ERROR THEN
8049: ROLLBACK;
8050: x_return_status := FND_API.G_RET_STS_ERROR;
8051: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8052:
8053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8054: ROLLBACK;
8055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8049: ROLLBACK;
8050: x_return_status := FND_API.G_RET_STS_ERROR;
8051: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8052:
8053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8054: ROLLBACK;
8055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8057:

Line 8055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8051: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8052:
8053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8054: ROLLBACK;
8055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8057:
8058: WHEN OTHERS THEN
8059: ROLLBACK;

Line 8056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8052:
8053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8054: ROLLBACK;
8055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8057:
8058: WHEN OTHERS THEN
8059: ROLLBACK;
8060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8056: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8057:
8058: WHEN OTHERS THEN
8059: ROLLBACK;
8060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8061: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8062: THEN
8063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8064: END IF;

Line 8065: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

8061: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8062: THEN
8063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8064: END IF;
8065: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
8066: end delete_activities;
8067:
8068: procedure add_org_activities(p_parent_process_id in number,
8069: p_organization_id in number,

Line 8071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

8067:
8068: procedure add_org_activities(p_parent_process_id in number,
8069: p_organization_id in number,
8070: p_child_id_string in varchar2,
8071: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8072: x_return_status out nocopy varchar2,
8073: x_msg_count out nocopy number,
8074: x_msg_data out nocopy varchar2)
8075: is

Line 8085: x_return_status := FND_API.G_RET_STS_SUCCESS;

8081: l_child_id number;
8082: l_child_order_num amw_latest_hierarchies.child_order_number%type;
8083:
8084: begin
8085: x_return_status := FND_API.G_RET_STS_SUCCESS;
8086: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8087: FND_MSG_PUB.initialize;
8088: END IF;
8089: if FND_GLOBAL.user_id is null then

Line 8086: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8082: l_child_order_num amw_latest_hierarchies.child_order_number%type;
8083:
8084: begin
8085: x_return_status := FND_API.G_RET_STS_SUCCESS;
8086: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8087: FND_MSG_PUB.initialize;
8088: END IF;
8089: if FND_GLOBAL.user_id is null then
8090: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 8091: raise FND_API.G_EXC_ERROR;

8087: FND_MSG_PUB.initialize;
8088: END IF;
8089: if FND_GLOBAL.user_id is null then
8090: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8091: raise FND_API.G_EXC_ERROR;
8092: end if;
8093:
8094: --check if parent_process_id is null
8095: if p_parent_process_id is null or p_organization_id is null then

Line 8096: raise FND_API.G_EXC_ERROR;

8092: end if;
8093:
8094: --check if parent_process_id is null
8095: if p_parent_process_id is null or p_organization_id is null then
8096: raise FND_API.G_EXC_ERROR;
8097: end if;
8098:
8099: l_child_string := p_child_id_string;
8100: while LENGTH(l_child_string) <> 0 loop

Line 8131: WHEN FND_API.G_EXC_ERROR THEN

8127:
8128: select LTRIM(str, 'x') into l_child_string from dual;
8129: end loop;
8130: exception
8131: WHEN FND_API.G_EXC_ERROR THEN
8132: ROLLBACK;
8133: x_return_status := FND_API.G_RET_STS_ERROR;
8134: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8135:

Line 8133: x_return_status := FND_API.G_RET_STS_ERROR;

8129: end loop;
8130: exception
8131: WHEN FND_API.G_EXC_ERROR THEN
8132: ROLLBACK;
8133: x_return_status := FND_API.G_RET_STS_ERROR;
8134: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8135:
8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8137: ROLLBACK;

Line 8134: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8130: exception
8131: WHEN FND_API.G_EXC_ERROR THEN
8132: ROLLBACK;
8133: x_return_status := FND_API.G_RET_STS_ERROR;
8134: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8135:
8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8137: ROLLBACK;
8138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8132: ROLLBACK;
8133: x_return_status := FND_API.G_RET_STS_ERROR;
8134: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8135:
8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8137: ROLLBACK;
8138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8140:

Line 8138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8134: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8135:
8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8137: ROLLBACK;
8138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8140:
8141: WHEN OTHERS THEN
8142: ROLLBACK;

Line 8139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8135:
8136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8137: ROLLBACK;
8138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8140:
8141: WHEN OTHERS THEN
8142: ROLLBACK;
8143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8140:
8141: WHEN OTHERS THEN
8142: ROLLBACK;
8143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8145: THEN
8146: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8147: END IF;

Line 8148: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

8144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8145: THEN
8146: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8147: END IF;
8148: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);
8149: end add_org_activities;
8150:
8151: procedure add_rl_activities(p_parent_process_id in number,
8152: p_organization_id in number,

Line 8154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

8150:
8151: procedure add_rl_activities(p_parent_process_id in number,
8152: p_organization_id in number,
8153: p_comb_string in varchar2,
8154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8155: x_return_status out nocopy varchar2,
8156: x_msg_count out nocopy number,
8157: x_msg_data out nocopy varchar2)
8158: is

Line 8178: x_return_status := FND_API.G_RET_STS_SUCCESS;

8174: union
8175: select pid process_to_count from dual;
8176: begin
8177:
8178: x_return_status := FND_API.G_RET_STS_SUCCESS;
8179: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8180: FND_MSG_PUB.initialize;
8181: END IF;
8182: if FND_GLOBAL.user_id is null then

Line 8179: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8175: select pid process_to_count from dual;
8176: begin
8177:
8178: x_return_status := FND_API.G_RET_STS_SUCCESS;
8179: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8180: FND_MSG_PUB.initialize;
8181: END IF;
8182: if FND_GLOBAL.user_id is null then
8183: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 8184: raise FND_API.G_EXC_ERROR;

8180: FND_MSG_PUB.initialize;
8181: END IF;
8182: if FND_GLOBAL.user_id is null then
8183: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8184: raise FND_API.G_EXC_ERROR;
8185: end if;
8186:
8187: while (true) loop
8188:

Line 8236: WHEN FND_API.G_EXC_ERROR THEN

8232: end loop;
8233: END;
8234: end loop;
8235: exception
8236: WHEN FND_API.G_EXC_ERROR THEN
8237: ROLLBACK;
8238: x_return_status := FND_API.G_RET_STS_ERROR;
8239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8240:

Line 8238: x_return_status := FND_API.G_RET_STS_ERROR;

8234: end loop;
8235: exception
8236: WHEN FND_API.G_EXC_ERROR THEN
8237: ROLLBACK;
8238: x_return_status := FND_API.G_RET_STS_ERROR;
8239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8240:
8241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8242: ROLLBACK;

Line 8239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8235: exception
8236: WHEN FND_API.G_EXC_ERROR THEN
8237: ROLLBACK;
8238: x_return_status := FND_API.G_RET_STS_ERROR;
8239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8240:
8241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8242: ROLLBACK;
8243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8237: ROLLBACK;
8238: x_return_status := FND_API.G_RET_STS_ERROR;
8239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8240:
8241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8242: ROLLBACK;
8243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8245:

Line 8243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8239: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8240:
8241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8242: ROLLBACK;
8243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8245:
8246: WHEN OTHERS THEN
8247: ROLLBACK;

Line 8244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8240:
8241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8242: ROLLBACK;
8243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8245:
8246: WHEN OTHERS THEN
8247: ROLLBACK;
8248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8245:
8246: WHEN OTHERS THEN
8247: ROLLBACK;
8248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8249: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8250: THEN
8251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8252: END IF;

Line 8253: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8249: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8250: THEN
8251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8252: END IF;
8253: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8254:
8255: end add_rl_activities;
8256:
8257: PROCEDURE update_latest_denorm_counts

Line 8260: p_commit IN VARCHAR2 := FND_API.G_FALSE,

8256:
8257: PROCEDURE update_latest_denorm_counts
8258: ( p_organization_id IN NUMBER,
8259: P_process_id IN NUMBER,
8260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8263: x_return_status OUT NOCOPY VARCHAR2,
8264: x_msg_count OUT NOCOPY VARCHAR2,

Line 8261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

8257: PROCEDURE update_latest_denorm_counts
8258: ( p_organization_id IN NUMBER,
8259: P_process_id IN NUMBER,
8260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8263: x_return_status OUT NOCOPY VARCHAR2,
8264: x_msg_count OUT NOCOPY VARCHAR2,
8265: x_msg_data OUT NOCOPY VARCHAR2)

Line 8262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

8258: ( p_organization_id IN NUMBER,
8259: P_process_id IN NUMBER,
8260: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8261: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
8262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8263: x_return_status OUT NOCOPY VARCHAR2,
8264: x_msg_count OUT NOCOPY VARCHAR2,
8265: x_msg_data OUT NOCOPY VARCHAR2)
8266: IS

Line 8276: x_return_status := FND_API.G_RET_STS_SUCCESS;

8272:
8273: --always initialize global variables in th api's used from SelfSerivice Fwk..
8274: G_USER_ID := FND_GLOBAL.USER_ID;
8275: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
8276: x_return_status := FND_API.G_RET_STS_SUCCESS;
8277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8278: FND_MSG_PUB.initialize;
8279: END IF;
8280: IF FND_GLOBAL.User_Id IS NULL THEN

Line 8277: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8273: --always initialize global variables in th api's used from SelfSerivice Fwk..
8274: G_USER_ID := FND_GLOBAL.USER_ID;
8275: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
8276: x_return_status := FND_API.G_RET_STS_SUCCESS;
8277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8278: FND_MSG_PUB.initialize;
8279: END IF;
8280: IF FND_GLOBAL.User_Id IS NULL THEN
8281: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 8282: RAISE FND_API.G_EXC_ERROR;

8278: FND_MSG_PUB.initialize;
8279: END IF;
8280: IF FND_GLOBAL.User_Id IS NULL THEN
8281: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8282: RAISE FND_API.G_EXC_ERROR;
8283: END IF;
8284:
8285: -- update the latest denorm hierarchy..
8286: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);

Line 8294: WHEN FND_API.G_EXC_ERROR THEN

8290: upd_ltst_control_count(p_org_id => p_organization_id, p_process_id => p_process_id);
8291:
8292:
8293: exception
8294: WHEN FND_API.G_EXC_ERROR THEN
8295: ROLLBACK;
8296: x_return_status := FND_API.G_RET_STS_ERROR;
8297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8298:

Line 8296: x_return_status := FND_API.G_RET_STS_ERROR;

8292:
8293: exception
8294: WHEN FND_API.G_EXC_ERROR THEN
8295: ROLLBACK;
8296: x_return_status := FND_API.G_RET_STS_ERROR;
8297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8298:
8299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8300: ROLLBACK;

Line 8297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8293: exception
8294: WHEN FND_API.G_EXC_ERROR THEN
8295: ROLLBACK;
8296: x_return_status := FND_API.G_RET_STS_ERROR;
8297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8298:
8299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8300: ROLLBACK;
8301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8295: ROLLBACK;
8296: x_return_status := FND_API.G_RET_STS_ERROR;
8297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8298:
8299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8300: ROLLBACK;
8301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8303:

Line 8301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8298:
8299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8300: ROLLBACK;
8301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8303:
8304: WHEN OTHERS THEN
8305: ROLLBACK;

Line 8302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8298:
8299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8300: ROLLBACK;
8301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8303:
8304: WHEN OTHERS THEN
8305: ROLLBACK;
8306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8302: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8303:
8304: WHEN OTHERS THEN
8305: ROLLBACK;
8306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8308: THEN
8309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8310: END IF;

Line 8311: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

8307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8308: THEN
8309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
8310: END IF;
8311: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
8312: END update_latest_denorm_counts;
8313:
8314: --******************************************************************************
8315: -- Initialize the Nested Tables used in Synchronize Process to Organization.

Line 8379: RAISE FND_API.G_EXC_ERROR;

8375: END IF;
8376:
8377: IF FND_GLOBAL.User_Id IS NULL THEN
8378: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8379: RAISE FND_API.G_EXC_ERROR;
8380: END IF;
8381:
8382: IF p_process_id = -1 OR p_process_id = -2 THEN
8383: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');

Line 8461: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, Org_Ids(indx),FND_API.G_FALSE);

8457: */
8458: IF p_sync_approve = 'AUTO' THEN
8459: BEGIN
8460: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, Org_Ids(indx));
8461: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, Org_Ids(indx),FND_API.G_FALSE);
8462: EXCEPTION
8463: WHEN OTHERS THEN
8464: show_warning := true;
8465: ROLLBACK;

Line 8467: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

8463: WHEN OTHERS THEN
8464: show_warning := true;
8465: ROLLBACK;
8466: -- Unapproved object associations exists exception may happen..catche them here..
8467: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
8468: fnd_file.put_line(fnd_file.LOG, ' Error when Approving the process in organization ' ||Org_Ids(indx) );
8469: fnd_file.put_line(fnd_file.LOG, l_msg_data);
8470: END;
8471: END IF;

Line 8480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

8476: EXCEPTION
8477: when pending_approval_exception then
8478: show_warning := true;
8479: ROLLBACK;
8480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
8481: fnd_file.put_line(fnd_file.LOG, ' Error when Synchronizing the process in organization');
8482: fnd_file.put_line(fnd_file.LOG, l_msg_data);
8483: when OTHERS then
8484: show_warning := true;

Line 8486: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

8482: fnd_file.put_line(fnd_file.LOG, l_msg_data);
8483: when OTHERS then
8484: show_warning := true;
8485: ROLLBACK;
8486: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
8487: fnd_file.put_line(fnd_file.LOG, ' Error when Synchronizing the process in organization ');
8488: fnd_file.put_line(fnd_file.LOG, l_msg_data);
8489: END;
8490:

Line 8534: WHEN FND_API.G_EXC_ERROR THEN

8530: END IF;
8531: END IF;
8532: commit;
8533: EXCEPTION
8534: WHEN FND_API.G_EXC_ERROR THEN
8535: ROLLBACK;
8536: retcode := 2;
8537: errbuf := SUBSTR(SQLERRM,1,1000);
8538: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

Line 8540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8536: retcode := 2;
8537: errbuf := SUBSTR(SQLERRM,1,1000);
8538: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8539:
8540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8541: ROLLBACK;
8542: retcode := 2;
8543: errbuf := SUBSTR(SQLERRM,1,1000);
8544: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

Line 8694: RAISE FND_API.G_EXC_ERROR;

8690: BEGIN
8691:
8692: IF FND_GLOBAL.User_Id IS NULL THEN
8693: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
8694: RAISE FND_API.G_EXC_ERROR;
8695: END IF;
8696: if p_process_id = -1 OR p_process_id = -2 then
8697: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','Warning: Cannot Associate Root Process');
8698: return;

Line 8773: p_update_count => FND_API.G_FALSE,

8769: p_org_id => l_audit_units_tbl(orgid).organization_id,
8770: p_mode => p_mode,
8771: p_apply_rcm => p_apply_rcm,
8772: p_synchronize => p_synchronize,
8773: p_update_count => FND_API.G_FALSE,
8774: p_commit => FND_API.G_FALSE,
8775: x_return_status => l_return_status,
8776: x_msg_count => l_msg_count,
8777: x_msg_data => l_msg_data);

Line 8774: p_commit => FND_API.G_FALSE,

8770: p_mode => p_mode,
8771: p_apply_rcm => p_apply_rcm,
8772: p_synchronize => p_synchronize,
8773: p_update_count => FND_API.G_FALSE,
8774: p_commit => FND_API.G_FALSE,
8775: x_return_status => l_return_status,
8776: x_msg_count => l_msg_count,
8777: x_msg_data => l_msg_data);
8778:

Line 8795: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);

8791: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
8792: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
8793: BEGIN
8794: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
8795: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
8796: EXCEPTION
8797: WHEN OTHERS THEN
8798: show_warning := true;
8799: ROLLBACK;

Line 8801: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);

8797: WHEN OTHERS THEN
8798: show_warning := true;
8799: ROLLBACK;
8800: -- Unapproved object associations exists exception may happen..catche them here..
8801: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count,p_data => l_msg_data);
8802: fnd_file.put_line(fnd_file.LOG, ' Error when Approving the process in organization ' ||l_audit_units_tbl(orgid).org_name );
8803: fnd_file.put_line(fnd_file.LOG, l_msg_data);
8804: END;
8805: END IF;

Line 8828: WHEN FND_API.G_EXC_ERROR THEN

8824: 'There is already a concurrent process running for a similar process id.'||
8825: 'This concurrent request is also being run with the same value for parameter "Process id" '||
8826: ' and the parameter "Organization Name or Range" that the earlier concurrent program is running with. '
8827: );
8828: WHEN FND_API.G_EXC_ERROR THEN
8829: ROLLBACK;
8830: retcode := 2;
8831: errbuf := SUBSTR(SQLERRM,1,1000);
8832: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);

Line 8834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8830: retcode := 2;
8831: errbuf := SUBSTR(SQLERRM,1,1000);
8832: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
8833:
8834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8835: ROLLBACK;
8836: retcode := 2;
8837: errbuf := SUBSTR(SQLERRM,1,1000);
8838: conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);