DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on FND_MSG_PUB

Line 786: Fnd_Msg_Pub.add_exc_msg

782: x_utl_aut_flag := 'N';
783: x_frcst_prim_ctct_flag := 'N';
784:
785: -- Populate the Error Message
786: Fnd_Msg_Pub.add_exc_msg
787: ( p_pkg_name => 'pa_resource_utils'
788: , p_procedure_name => 'populate_role_flags'
789: , p_error_text => SUBSTRB(SQLERRM,1,100));
790:

Line 946: Fnd_Msg_Pub.add_exc_msg

942: --4537865
943: EXCEPTION
944: WHEN OTHERS THEN
945: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
946: Fnd_Msg_Pub.add_exc_msg
947: ( p_pkg_name => 'pa_resource_utils'
948: , p_procedure_name => 'insert_grant'
949: , p_error_text => SUBSTRB(SQLERRM,1,100));
950: RAISE;

Line 1059: Fnd_Msg_Pub.add_exc_msg

1055: --4537865
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1059: Fnd_Msg_Pub.add_exc_msg
1060: ( p_pkg_name => 'pa_resource_utils'
1061: , p_procedure_name => 'delete_grant'
1062: , p_error_text => SUBSTRB(SQLERRM,1,100));
1063: RAISE;

Line 1635: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'

1631:
1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: -- set the exception message and stack
1635: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1636: -- ,PA_DEBUG.g_err_stack);
1637: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: -- raise;
1639: -- null; 4537865

Line 1725: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'

1721:
1722: WHEN OTHERS THEN
1723: -- set the exception message and stack
1724: x_PersonId := NULL ; -- 4537865
1725: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1726: ,PA_DEBUG.g_err_stack);
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: raise;
1729:

Line 1901: v_msg_count := FND_MSG_PUB.count_msg;

1897: x_return_status := FND_API.G_RET_STS_ERROR;
1898:
1899: END IF;
1900:
1901: v_msg_count := FND_MSG_PUB.count_msg;
1902:
1903: -- if num of message is one then pass it to out parameter x_msg_data
1904: IF v_msg_count = 1 and (x_ManagerId is NULL and x_primarycontactid is NULL) then
1905: PA_INTERFACE_UTILS_PUB.get_messages(

Line 1933: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'

1929: x_ManagerName := NULL ;
1930: x_return_Status := NULL ;
1931:
1932: -- set the exception message and stack
1933: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'
1934: ,PA_DEBUG.g_err_stack);
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936: -- dbms_output.put_line('missing');
1937: raise;

Line 2485: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'

2481: -- RESET OUT PARAM 4537865
2482: x_person_name := null;
2483:
2484: -- set the exception message and stack
2485: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'
2486: ,PA_DEBUG.g_err_stack);
2487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2488: raise;
2489:

Line 2566: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'

2562: x_postal_code := null;
2563: x_country := null;
2564:
2565: -- set the exception message and stack
2566: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'
2567: ,PA_DEBUG.g_err_stack);
2568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2569: raise;
2570:

Line 2641: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'

2637: x_default_ou := null;
2638: x_default_cal_id := null;
2639:
2640: -- set the exception message and stack
2641: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'
2642: ,PA_DEBUG.g_err_stack);
2643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2644: raise;
2645:

Line 2714: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'

2710:
2711: x_valid := 'N';
2712:
2713: -- set the exception message and stack
2714: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'
2715: ,PA_DEBUG.g_err_stack);
2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2717: raise;
2718:

Line 2777: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'

2773: --4537865 RESET OUT PARAMS
2774: x_valid := 'N';
2775:
2776: -- set the exception message and stack
2777: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'
2778: ,PA_DEBUG.g_err_stack);
2779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2780: raise;
2781:

Line 3669: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'

3665: EXCEPTION
3666:
3667: WHEN OTHERS THEN
3668: -- Set the exception Message and the stack
3669: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'
3670: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3672: RAISE;
3673:

Line 4203: x_msg_count := FND_MSG_PUB.Count_Msg;

4199: END IF;
4200: END IF;
4201:
4202: x_return_status := FND_API.G_RET_STS_SUCCESS;
4203: x_msg_count := FND_MSG_PUB.Count_Msg;
4204:
4205: EXCEPTION
4206: WHEN NO_DATA_FOUND THEN
4207: x_manager_id := NULL;

Line 4210: x_msg_count := FND_MSG_PUB.Count_Msg;

4206: WHEN NO_DATA_FOUND THEN
4207: x_manager_id := NULL;
4208: x_return_status := FND_API.G_RET_STS_ERROR;
4209: x_error_message_code := 'PA_RES_INVALID_MGR_HIER';
4210: x_msg_count := FND_MSG_PUB.Count_Msg;
4211:
4212: WHEN TOO_MANY_ROWS THEN
4213: x_manager_id := NULL;
4214: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4216: x_msg_count := FND_MSG_PUB.Count_Msg;

4212: WHEN TOO_MANY_ROWS THEN
4213: x_manager_id := NULL;
4214: x_return_status := FND_API.G_RET_STS_ERROR;
4215: x_error_message_code := 'PA_MULTIPLE_RESOURCE';
4216: x_msg_count := FND_MSG_PUB.Count_Msg;
4217:
4218: WHEN OTHERS THEN
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4220: x_manager_id := NULL;

Line 4221: x_msg_count := FND_MSG_PUB.Count_Msg;

4217:
4218: WHEN OTHERS THEN
4219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4220: x_manager_id := NULL;
4221: x_msg_count := FND_MSG_PUB.Count_Msg;
4222:
4223: END Check_ManagerName_Or_Id;
4224:
4225:

Line 4696: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

4692: WHEN OTHERS THEN
4693: x_return_status := FND_API.G_RET_STS_ERROR;
4694: x_msg_count := 1;
4695: x_msg_data := substr(SQLERRM,1,240);
4696: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
4697: p_procedure_name => 'Init_FTE_sync_wf');
4698: If x_msg_count = 1 THEN
4699: pa_interface_utils_pub.get_messages
4700: (p_encoded => FND_API.G_TRUE,

Line 4761: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

4757: WHEN OTHERS THEN
4758: x_return_status := FND_API.G_RET_STS_ERROR;
4759: x_msg_count := 1;
4760: x_msg_data := substr(SQLERRM,1,240);
4761: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
4762: p_procedure_name => 'set_fte_flag');
4763: If x_msg_count = 1 THEN
4764: pa_interface_utils_pub.get_messages
4765: (p_encoded => FND_API.G_TRUE,

Line 4829: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

4825: x_future_term_wf_flag := NULL;
4826: x_return_status := FND_API.G_RET_STS_ERROR;
4827: x_msg_count := 1;
4828: x_msg_data := substr(SQLERRM,1,240);
4829: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
4830: p_procedure_name => 'get_fte_flag');
4831: If x_msg_count = 1 THEN
4832: pa_interface_utils_pub.get_messages
4833: (p_encoded => FND_API.G_TRUE,

Line 4927: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

4923: WHEN OTHERS THEN
4924: x_return_status := FND_API.G_RET_STS_ERROR;
4925: x_msg_count := 1;
4926: x_msg_data := substr(SQLERRM,1,240);
4927: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
4928: p_procedure_name => 'is_fte');
4929: If x_msg_count = 1 THEN
4930: pa_interface_utils_pub.get_messages
4931: (p_encoded => FND_API.G_TRUE,

Line 4995: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',

4991: WHEN OTHERS THEN
4992: x_return_status := FND_API.G_RET_STS_ERROR;
4993: x_msg_count := 1;
4994: x_msg_data := substr(SQLERRM,1,240);
4995: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
4996: p_procedure_name => 'get_valid_enddate');
4997: If x_msg_count = 1 THEN
4998: pa_interface_utils_pub.get_messages
4999: (p_encoded => FND_API.G_TRUE,