DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on FND_MSG_PUB

Line 862: Fnd_Msg_Pub.add_exc_msg

858: x_utl_aut_flag := 'N';
859: x_frcst_prim_ctct_flag := 'N';
860:
861: -- Populate the Error Message
862: Fnd_Msg_Pub.add_exc_msg
863: ( p_pkg_name => 'pa_resource_utils'
864: , p_procedure_name => 'populate_role_flags'
865: , p_error_text => SUBSTRB(SQLERRM,1,100));
866:

Line 1025: Fnd_Msg_Pub.add_exc_msg

1021: --4537865
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1025: Fnd_Msg_Pub.add_exc_msg
1026: ( p_pkg_name => 'pa_resource_utils'
1027: , p_procedure_name => 'insert_grant'
1028: , p_error_text => SUBSTRB(SQLERRM,1,100));
1029: RAISE;

Line 1138: Fnd_Msg_Pub.add_exc_msg

1134: --4537865
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1138: Fnd_Msg_Pub.add_exc_msg
1139: ( p_pkg_name => 'pa_resource_utils'
1140: , p_procedure_name => 'delete_grant'
1141: , p_error_text => SUBSTRB(SQLERRM,1,100));
1142: RAISE;

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

1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: -- set the exception message and stack
1747: -- FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1748: -- ,PA_DEBUG.g_err_stack);
1749: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: -- raise;
1751: -- null; 4537865

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

1833:
1834: WHEN OTHERS THEN
1835: -- set the exception message and stack
1836: x_PersonId := NULL ; -- 4537865
1837: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_id'
1838: ,PA_DEBUG.g_err_stack);
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1840: raise;
1841:

Line 2018: v_msg_count := FND_MSG_PUB.count_msg;

2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: END IF;
2017:
2018: v_msg_count := FND_MSG_PUB.count_msg;
2019:
2020: -- if num of message is one then pass it to out parameter x_msg_data
2021: IF v_msg_count = 1 and (x_ManagerId is NULL and x_primarycontactid is NULL) then
2022: PA_INTERFACE_UTILS_PUB.get_messages(

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

2046: x_ManagerName := NULL ;
2047: x_return_Status := NULL ;
2048:
2049: -- set the exception message and stack
2050: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_primary_contact'
2051: ,PA_DEBUG.g_err_stack);
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: -- dbms_output.put_line('missing');
2054: raise;

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

2598: -- RESET OUT PARAM 4537865
2599: x_person_name := null;
2600:
2601: -- set the exception message and stack
2602: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_person_name'
2603: ,PA_DEBUG.g_err_stack);
2604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2605: raise;
2606:

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

2679: x_postal_code := null;
2680: x_country := null;
2681:
2682: -- set the exception message and stack
2683: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_location_details'
2684: ,PA_DEBUG.g_err_stack);
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: raise;
2687:

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

2754: x_default_ou := null;
2755: x_default_cal_id := null;
2756:
2757: -- set the exception message and stack
2758: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.get_org_defaults'
2759: ,PA_DEBUG.g_err_stack);
2760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2761: raise;
2762:

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

2827:
2828: x_valid := 'N';
2829:
2830: -- set the exception message and stack
2831: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_exp_org'
2832: ,PA_DEBUG.g_err_stack);
2833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2834: raise;
2835:

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

2890: --4537865 RESET OUT PARAMS
2891: x_valid := 'N';
2892:
2893: -- set the exception message and stack
2894: FND_MSG_PUB.add_exc_msg('PA_RESOURCE_UTILS.check_res_exists'
2895: ,PA_DEBUG.g_err_stack);
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2897: raise;
2898:

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

4001: EXCEPTION
4002:
4003: WHEN OTHERS THEN
4004: -- Set the exception Message and the stack
4005: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_RESOURCE_UTILS.Validate_person'
4006: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4008: RAISE;
4009:

Line 4539: x_msg_count := FND_MSG_PUB.Count_Msg;

4535: END IF;
4536: END IF;
4537:
4538: x_return_status := FND_API.G_RET_STS_SUCCESS;
4539: x_msg_count := FND_MSG_PUB.Count_Msg;
4540:
4541: EXCEPTION
4542: WHEN NO_DATA_FOUND THEN
4543: x_manager_id := NULL;

Line 4546: x_msg_count := FND_MSG_PUB.Count_Msg;

4542: WHEN NO_DATA_FOUND THEN
4543: x_manager_id := NULL;
4544: x_return_status := FND_API.G_RET_STS_ERROR;
4545: x_error_message_code := 'PA_RES_INVALID_MGR_HIER';
4546: x_msg_count := FND_MSG_PUB.Count_Msg;
4547:
4548: WHEN TOO_MANY_ROWS THEN
4549: x_manager_id := NULL;
4550: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4552: x_msg_count := FND_MSG_PUB.Count_Msg;

4548: WHEN TOO_MANY_ROWS THEN
4549: x_manager_id := NULL;
4550: x_return_status := FND_API.G_RET_STS_ERROR;
4551: x_error_message_code := 'PA_MULTIPLE_RESOURCE';
4552: x_msg_count := FND_MSG_PUB.Count_Msg;
4553:
4554: WHEN OTHERS THEN
4555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4556: x_manager_id := NULL;

Line 4557: x_msg_count := FND_MSG_PUB.Count_Msg;

4553:
4554: WHEN OTHERS THEN
4555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4556: x_manager_id := NULL;
4557: x_msg_count := FND_MSG_PUB.Count_Msg;
4558:
4559: END Check_ManagerName_Or_Id;
4560:
4561:

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

5048: WHEN OTHERS THEN
5049: x_return_status := FND_API.G_RET_STS_ERROR;
5050: x_msg_count := 1;
5051: x_msg_data := substr(SQLERRM,1,240);
5052: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5053: p_procedure_name => 'Init_FTE_sync_wf');
5054: If x_msg_count = 1 THEN
5055: pa_interface_utils_pub.get_messages
5056: (p_encoded => FND_API.G_TRUE,

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

5113: WHEN OTHERS THEN
5114: x_return_status := FND_API.G_RET_STS_ERROR;
5115: x_msg_count := 1;
5116: x_msg_data := substr(SQLERRM,1,240);
5117: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5118: p_procedure_name => 'set_fte_flag');
5119: If x_msg_count = 1 THEN
5120: pa_interface_utils_pub.get_messages
5121: (p_encoded => FND_API.G_TRUE,

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

5181: x_future_term_wf_flag := NULL;
5182: x_return_status := FND_API.G_RET_STS_ERROR;
5183: x_msg_count := 1;
5184: x_msg_data := substr(SQLERRM,1,240);
5185: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5186: p_procedure_name => 'get_fte_flag');
5187: If x_msg_count = 1 THEN
5188: pa_interface_utils_pub.get_messages
5189: (p_encoded => FND_API.G_TRUE,

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

5279: WHEN OTHERS THEN
5280: x_return_status := FND_API.G_RET_STS_ERROR;
5281: x_msg_count := 1;
5282: x_msg_data := substr(SQLERRM,1,240);
5283: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5284: p_procedure_name => 'is_fte');
5285: If x_msg_count = 1 THEN
5286: pa_interface_utils_pub.get_messages
5287: (p_encoded => FND_API.G_TRUE,

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

5347: WHEN OTHERS THEN
5348: x_return_status := FND_API.G_RET_STS_ERROR;
5349: x_msg_count := 1;
5350: x_msg_data := substr(SQLERRM,1,240);
5351: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_RESOURCE_UTILS',
5352: p_procedure_name => 'get_valid_enddate');
5353: If x_msg_count = 1 THEN
5354: pa_interface_utils_pub.get_messages
5355: (p_encoded => FND_API.G_TRUE,