DBA Data[Home] [Help]

APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_MSG_PUB

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 617: FND_MSG_PUB.initialize;

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
621: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

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 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 664: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => G_PKG_NAME,

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));
667:
668: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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 2301: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',

2297: when pending_approval_exception then
2298: rollback;
2299: fnd_message.set_name('AMW','AMW_ATTEMPT_MODIF_LOCKED');
2300: err_msg := fnd_message.get;
2301: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',
2302: p_procedure_name => 'produce_err_if_pa_or_locked',
2303: p_error_text => err_msg);
2304: raise;
2305:

Line 2334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',

2330: when circular_exception then
2331: rollback;
2332: fnd_message.set_name('AMW','AMW_ATTEMPT_CIRCULAR');
2333: err_msg := fnd_message.get;
2334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_org_hierarchy_pkg',
2335: p_procedure_name => 'produce_err_if_circular',
2336: p_error_text => err_msg);
2337: raise;
2338:

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 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 3792: FND_MSG_PUB.initialize;

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');
3796: RAISE FND_API.G_EXC_ERROR;

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 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 3871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
3875: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

Line 3873: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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;

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 3914: FND_MSG_PUB.initialize;

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');
3918: RAISE FND_API.G_EXC_ERROR;

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 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 3990: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
3994: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

Line 3992: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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;

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 4050: FND_MSG_PUB.initialize;

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');
4054: RAISE FND_API.G_EXC_ERROR;

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 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 4161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4165: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4199: FND_MSG_PUB.initialize;

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');
4203: RAISE FND_API.G_EXC_ERROR;

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 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 4269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4273: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4271: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4299: FND_MSG_PUB.initialize;

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');
4303: RAISE FND_API.G_EXC_ERROR;

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 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 4333: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4337: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4335: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4376: FND_MSG_PUB.initialize;

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');
4380: RAISE FND_API.G_EXC_ERROR;

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 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 4429: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4433: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4431: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4460: FND_MSG_PUB.initialize;

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');
4464: RAISE FND_API.G_EXC_ERROR;

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 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 4487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4491: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4489: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4517: FND_MSG_PUB.initialize;

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');
4521: RAISE FND_API.G_EXC_ERROR;

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 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 4544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4548: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4546: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4575: FND_MSG_PUB.initialize;

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');
4579: RAISE FND_API.G_EXC_ERROR;

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 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 4628: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4632: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 4630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 4724: FND_MSG_PUB.initialize;

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');
4728: RAISE FND_API.G_EXC_ERROR;

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 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 4772: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
4776: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 4774: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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);

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 4815: FND_MSG_PUB.initialize;

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');
4819: RAISE FND_API.G_EXC_ERROR;

Line 4845: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_ORG_hierarchy_pkg',

4841:
4842: if ret_val <> 'Y' then
4843: fnd_message.set_name('AMW','AMW_CANT_UNDO_DRAFT');
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;

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 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 5040: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
5044: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 5042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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);

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 5068: FND_MSG_PUB.initialize;

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');
5072: RAISE FND_API.G_EXC_ERROR;

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 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 5165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
5169: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 5167: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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);

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 5192: FND_MSG_PUB.initialize;

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');
5196: RAISE FND_API.G_EXC_ERROR;

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 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 5281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
5285: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

Line 5283: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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);

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 7846: FND_MSG_PUB.initialize;

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');
7850: RAISE FND_API.G_EXC_ERROR;

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 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 7906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
7910: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

Line 7908: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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;

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 8018: FND_MSG_PUB.initialize;

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');
8022: raise FND_API.G_EXC_ERROR;

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 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 8061: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
8065: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

Line 8063: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 8087: FND_MSG_PUB.initialize;

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');
8091: raise FND_API.G_EXC_ERROR;

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 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 8144: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
8148: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count, p_data => x_msg_data);

Line 8146: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 8180: FND_MSG_PUB.initialize;

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');
8184: raise FND_API.G_EXC_ERROR;

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 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 8249: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
8253: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 8251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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;

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 8278: FND_MSG_PUB.initialize;

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');
8282: RAISE FND_API.G_EXC_ERROR;

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 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 8307: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
8311: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

Line 8309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

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;
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:

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 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 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;