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.PA_DELIVERABLE_UTILS dependencies on FND_MSG_PUB

Line 515: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'

511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: x_msg_count := 1;
513: x_msg_data := SQLERRM;
514:
515: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'
516: ,p_procedure_name => 'GET_OKE_FLAGS');
517:
518: IF l_debug_mode = 'Y' THEN
519: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 799: Fnd_Msg_Pub.add_exc_msg

795: IF c_complete_dlv_bill_check%ISOPEN THEN
796: CLOSE c_complete_dlv_bill_check;
797: END IF;
798:
799: Fnd_Msg_Pub.add_exc_msg
800: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
801: , p_procedure_name => 'IS_DLV_STATUS_CHANGE_ALLOWED'
802: , p_error_text => x_msg_data);
803:

Line 927: Fnd_Msg_Pub.add_exc_msg

923: IF l_doc_exists_csr%ISOPEN THEN
924: CLOSE l_doc_exists_csr;
925: END IF;
926:
927: Fnd_Msg_Pub.add_exc_msg
928: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
929: , p_procedure_name => 'IS_DLV_DOC_DEFINED'
930: , p_error_text => SUBSTRB(SQLERRM,1,240));
931:

Line 1077: Fnd_Msg_Pub.add_exc_msg

1073: IF l_struct_info_csr%ISOPEN THEN
1074: CLOSE l_struct_info_csr;
1075: END IF;
1076:
1077: Fnd_Msg_Pub.add_exc_msg
1078: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1079: , p_procedure_name => 'GET_STRUCTURE_INFO'
1080: , p_error_text => x_msg_data);
1081:

Line 1141: Fnd_Msg_Pub.add_exc_msg

1137: return x_organization_id;
1138:
1139: WHEN OTHERS THEN
1140:
1141: Fnd_Msg_Pub.add_exc_msg
1142: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1143: , p_procedure_name => 'GET_CARRYING_OUT_ORG'
1144: , p_error_text => SUBSTRB(SQLERRM,1,240));
1145:

Line 1202: Fnd_Msg_Pub.add_exc_msg

1198: return x_base_percent_comp_deriv_code;
1199:
1200: WHEN OTHERS THEN
1201:
1202: Fnd_Msg_Pub.add_exc_msg
1203: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1204: , p_procedure_name => 'GET_PROGRESS_ROLLUP_METHOD'
1205: , p_error_text => SUBSTRB(SQLERRM,1,240));
1206:

Line 1262: Fnd_Msg_Pub.add_exc_msg

1258: return x_actions_exists;
1259:
1260: WHEN OTHERS THEN
1261:
1262: Fnd_Msg_Pub.add_exc_msg
1263: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1264: , p_procedure_name => 'IS_ACTIONS_EXISTS'
1265: , p_error_text => SUBSTRB(SQLERRM,1,240));
1266:

Line 1325: Fnd_Msg_Pub.add_exc_msg

1321: return x_biling_function_exists;
1322:
1323: WHEN OTHERS THEN
1324:
1325: Fnd_Msg_Pub.add_exc_msg
1326: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1327: , p_procedure_name => 'IS_BILLING_FUNCTION_EXISTS'
1328: , p_error_text => SUBSTRB(SQLERRM,1,240));
1329:

Line 1373: Fnd_Msg_Pub.add_exc_msg

1369: x_deliverable_has_progress := 'N';
1370: return x_deliverable_has_progress;
1371:
1372: WHEN OTHERS THEN
1373: Fnd_Msg_Pub.add_exc_msg
1374: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1375: , p_procedure_name => 'IS_DELIVERABLE_HAS_PROGRESS'
1376: , p_error_text => SUBSTRB(SQLERRM,1,240));
1377:

Line 1427: Fnd_Msg_Pub.add_exc_msg

1423: EXCEPTION
1424:
1425: WHEN OTHERS THEN
1426:
1427: Fnd_Msg_Pub.add_exc_msg
1428: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1429: , p_procedure_name => 'IS_DLVR_PRG_ENABLED'
1430: , p_error_text => SUBSTRB(SQLERRM,1,240));
1431:

Line 1486: Fnd_Msg_Pub.add_exc_msg

1482: EXCEPTION
1483:
1484: WHEN OTHERS THEN
1485:
1486: Fnd_Msg_Pub.add_exc_msg
1487: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1488: , p_procedure_name => 'GET_DLVR_DETAIL'
1489: , p_error_text => SUBSTRB(SQLERRM,1,240));
1490:

Line 1548: Fnd_Msg_Pub.add_exc_msg

1544: EXCEPTION
1545:
1546: WHEN OTHERS THEN
1547:
1548: Fnd_Msg_Pub.add_exc_msg
1549: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1550: , p_procedure_name => 'GET_ACTION_DETAIL'
1551: , p_error_text => SUBSTRB(SQLERRM,1,240));
1552:

Line 1606: Fnd_Msg_Pub.add_exc_msg

1602: EXCEPTION
1603:
1604: WHEN OTHERS THEN
1605:
1606: Fnd_Msg_Pub.add_exc_msg
1607: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1608: , p_procedure_name => 'GET_PROJ_CURRENCY_CODE'
1609: , p_error_text => SUBSTRB(SQLERRM,1,240));
1610:

Line 1660: Fnd_Msg_Pub.add_exc_msg

1656: EXCEPTION
1657:
1658: WHEN OTHERS THEN
1659:
1660: Fnd_Msg_Pub.add_exc_msg
1661: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1662: , p_procedure_name => 'GET_DLVR_PROJECT_DETAIL'
1663: , p_error_text => SUBSTRB(SQLERRM,1,240));
1664:

Line 1719: Fnd_Msg_Pub.add_exc_msg

1715: EXCEPTION
1716:
1717: WHEN OTHERS THEN
1718:
1719: Fnd_Msg_Pub.add_exc_msg
1720: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1721: , p_procedure_name => 'GET_ACTION_PROJECT_DETAIL'
1722: , p_error_text => SUBSTRB(SQLERRM,1,240));
1723:

Line 1777: Fnd_Msg_Pub.add_exc_msg

1773: IF l_task_info_csr%ISOPEN THEN
1774: CLOSE l_task_info_csr;
1775: END IF;
1776:
1777: Fnd_Msg_Pub.add_exc_msg
1778: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1779: , p_procedure_name => 'GET_ACTION_TASK_DETAIL'
1780: , p_error_text => SUBSTRB(SQLERRM,1,240));
1781:

Line 1849: Fnd_Msg_Pub.add_exc_msg

1845: EXCEPTION
1846:
1847: WHEN OTHERS THEN
1848:
1849: Fnd_Msg_Pub.add_exc_msg
1850: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1851: , p_procedure_name => 'GET_DEFAULT_DLVR_OWNER'
1852: , p_error_text => SUBSTRB(SQLERRM,1,240));
1853:

Line 1954: Fnd_Msg_Pub.add_exc_msg

1950: EXCEPTION
1951:
1952: WHEN OTHERS THEN
1953:
1954: Fnd_Msg_Pub.add_exc_msg
1955: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
1956: , p_procedure_name => 'GET_DEFAULT_DLVR_DATE'
1957: , p_error_text => SUBSTRB(SQLERRM,1,240));
1958:

Line 2020: Fnd_Msg_Pub.add_exc_msg

2016: EXCEPTION
2017:
2018: WHEN OTHERS THEN
2019:
2020: Fnd_Msg_Pub.add_exc_msg
2021: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
2022: , p_procedure_name => 'GET_DEFAULT_ACTION_OWNER'
2023: , p_error_text => SUBSTRB(SQLERRM,1,240));
2024:

Line 2155: Fnd_Msg_Pub.add_exc_msg

2151: EXCEPTION
2152:
2153: WHEN OTHERS THEN
2154:
2155: Fnd_Msg_Pub.add_exc_msg
2156: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
2157: , p_procedure_name => 'GET_DEFAULT_ACTION_DATE'
2158: , p_error_text => SUBSTRB(SQLERRM,1,240));
2159:

Line 2427: Fnd_Msg_Pub.add_exc_msg

2423: EXCEPTION
2424:
2425: WHEN OTHERS THEN
2426:
2427: Fnd_Msg_Pub.add_exc_msg
2428: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
2429: , p_procedure_name => 'GET_PROJECT_DETAILS'
2430: , p_error_text => SUBSTRB(SQLERRM,1,240));
2431:

Line 2644: Fnd_Msg_Pub.add_exc_msg

2640: EXCEPTION
2641:
2642: WHEN OTHERS THEN
2643:
2644: Fnd_Msg_Pub.add_exc_msg
2645: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
2646: , p_procedure_name => 'GET_DEFAULT_ACTN_DATE'
2647: , p_error_text => SUBSTRB(SQLERRM,1,240));
2648:

Line 2850: Fnd_Msg_Pub.add_exc_msg

2846: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2847: pa_debug.reset_curr_function;
2848: END IF ;
2849:
2850: Fnd_Msg_Pub.add_exc_msg
2851: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
2852: , p_procedure_name => 'CHECK_DLVR_DISABLE_ALLOWED'
2853: , p_error_text => x_msg_data );
2854: RAISE;

Line 2985: Fnd_Msg_Pub.add_exc_msg

2981: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
2982: pa_debug.reset_curr_function;
2983: END IF ;
2984:
2985: Fnd_Msg_Pub.add_exc_msg
2986: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
2987: , p_procedure_name => 'UPDATE_TSK_STATUS_CANCELLED'
2988: , p_error_text => x_msg_data );
2989: RAISE;

Line 3086: Fnd_Msg_Pub.add_exc_msg

3082: END IF;
3083: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
3084: pa_debug.reset_curr_function;
3085: END IF ;
3086: Fnd_Msg_Pub.add_exc_msg
3087: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
3088: , p_procedure_name => 'CHECK_DLVR_DISABLE_ALLOWED'
3089: , p_error_text => x_msg_data );
3090: RAISE;

Line 3210: Fnd_Msg_Pub.add_exc_msg

3206: IF cur_dlvr_assoc_exists%ISOPEN THEN
3207: CLOSE cur_dlvr_assoc_exists;
3208: END IF;
3209:
3210: Fnd_Msg_Pub.add_exc_msg
3211: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
3212: , p_procedure_name => 'CHECK_PROGRESS_MTH_CODE_VALID'
3213: , p_error_text => x_msg_data );
3214: RAISE;

Line 3316: Fnd_Msg_Pub.add_exc_msg

3312: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
3313: pa_debug.reset_curr_function;
3314: END IF ;
3315:
3316: Fnd_Msg_Pub.add_exc_msg
3317: ( p_pkg_name => 'PA_DELIVERABLE_UTILS'
3318: , p_procedure_name => 'CHECK_PROJ_DLV_TXN_EXISTS'
3319: , p_error_text => x_msg_data );
3320: RAISE;

Line 3892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3888: -- Validating deliverable_name - not null
3889: IF p_dlvr_name IS NULL
3890: OR p_dlvr_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3891:
3892: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3893: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_NAME_MISSING') ;
3894: PA_UTILS.ADD_MESSAGE
3895: (p_app_short_name => 'PA',
3896: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 3919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3915: -- Validating deliverable_short_name - not null
3916: IF p_dlvr_number IS NULL
3917: OR p_dlvr_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
3918:
3919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3920: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_NUMBER_MISSING') ;
3921: PA_UTILS.ADD_MESSAGE
3922: (p_app_short_name => 'PA',
3923: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3942: -- Validating Deliverable Type Id - not null, valid value
3943: IF p_dlvr_type_id IS NULL
3944: OR p_dlvr_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN
3945:
3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3947: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_TYPE_MISSING') ;
3948: PA_UTILS.ADD_MESSAGE
3949: (p_app_short_name => 'PA',
3950: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 3966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3962: RAISE FND_API.G_EXC_ERROR;
3963:
3964: ELSE -- Deliverable type is not null, checking for valid value
3965: IF (Pa_Deliverable_Utils.IS_DLV_TYPE_ID_VALID(p_dlvr_type_id) = 'N') THEN
3966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3967: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_TYPE_INVALID') ;
3968: PA_UTILS.ADD_MESSAGE
3969: (p_app_short_name => 'PA',
3970: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4037: Pa_Debug.WRITE(g_module_name,' validated status code ['||px_status_code||'] outcome ['||l_status_code_valid||']' , l_debug_level3);
4038: END IF;
4039:
4040: IF (px_status_code IS NOT NULL and l_status_code_valid = 'N') THEN
4041: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4042: l_err_message := FND_MESSAGE.GET_STRING('PA','DLVR_STATUS_INVALID') ;
4043: PA_UTILS.ADD_MESSAGE
4044: (p_app_short_name => 'PA',
4045: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4133: IF l_debug_mode = 'Y' THEN --Added for bug 4945876
4134: pa_debug.reset_curr_function;
4135: END IF ;
4136:
4137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4138: FND_MSG_PUB.add_exc_msg
4139: ( p_pkg_name => g_module_name
4140: , p_procedure_name => l_api_name );
4141: END IF;

Line 4138: FND_MSG_PUB.add_exc_msg

4134: pa_debug.reset_curr_function;
4135: END IF ;
4136:
4137: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4138: FND_MSG_PUB.add_exc_msg
4139: ( p_pkg_name => g_module_name
4140: , p_procedure_name => l_api_name );
4141: END IF;
4142:

Line 4352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4348: FETCH l_dlvr_ref_csr INTO l_deliverable_id, l_project_number;
4349:
4350: IF l_dlvr_ref_csr%FOUND
4351: THEN
4352: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4353: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DUP_DLVR_REFERENCE') ;
4354: PA_UTILS.ADD_MESSAGE
4355: (p_app_short_name => 'PA',
4356: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4373: CLOSE l_dlvr_ref_csr;
4374:
4375: ELSE
4376:
4377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4378: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_REF_AND_ID_MISSING') ;
4379: PA_UTILS.ADD_MESSAGE
4380: (p_app_short_name => 'PA',
4381: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4404:
4405: WHEN OTHERS THEN
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4408: FND_MSG_PUB.add_exc_msg
4409: ( p_pkg_name => G_MODULE_NAME
4410: , p_procedure_name => l_api_name );
4411: END IF;

Line 4408: FND_MSG_PUB.add_exc_msg

4404:
4405: WHEN OTHERS THEN
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4408: FND_MSG_PUB.add_exc_msg
4409: ( p_pkg_name => G_MODULE_NAME
4410: , p_procedure_name => l_api_name );
4411: END IF;
4412:

Line 4483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4479: FETCH l_dlvr_id_csr INTO l_dummy;
4480:
4481: IF l_dlvr_id_csr%NOTFOUND
4482: THEN
4483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4484: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_ID_INVALID') ;
4485: PA_UTILS.ADD_MESSAGE
4486: (p_app_short_name => 'PA',
4487: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4511: FETCH l_dlvr_ref_csr INTO l_deliverable_id;
4512:
4513: IF l_dlvr_ref_csr%NOTFOUND
4514: THEN
4515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4516: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_REF_INVALID') ;
4517: PA_UTILS.ADD_MESSAGE
4518: (p_app_short_name => 'PA',
4519: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4533:
4534: CLOSE l_dlvr_ref_csr;
4535: p_out_deliverable_id := l_deliverable_id;
4536: ELSE
4537: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4538: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_DLVR_REF_AND_ID_MISSING') ;
4539: PA_UTILS.ADD_MESSAGE
4540: (p_app_short_name => 'PA',
4541: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4563: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4560:
4561: WHEN OTHERS THEN
4562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4563: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4564: FND_MSG_PUB.add_exc_msg
4565: ( p_pkg_name => G_MODULE_NAME
4566: , p_procedure_name => l_api_name );
4567: END IF;

Line 4564: FND_MSG_PUB.add_exc_msg

4560:
4561: WHEN OTHERS THEN
4562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4563: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4564: FND_MSG_PUB.add_exc_msg
4565: ( p_pkg_name => G_MODULE_NAME
4566: , p_procedure_name => l_api_name );
4567: END IF;
4568:

Line 4673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4669: OPEN l_action_ref_csr;
4670: FETCH l_action_ref_csr INTO l_dummy; -- 3749462 changed from l_action_id to l_dummy
4671:
4672: IF l_action_ref_csr%FOUND THEN
4673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4674: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_INVALID') ;
4675: PA_UTILS.ADD_MESSAGE
4676: (p_app_short_name => 'PA',
4677: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 4687: END IF; -- fnd_msg_pub.g_msg_lvl_error

4683: p_value3 => p_action_reference,
4684: p_token4 => 'MESSAGE',
4685: p_value4 => l_err_message
4686: );
4687: END IF; -- fnd_msg_pub.g_msg_lvl_error
4688:
4689: CLOSE l_action_ref_csr;
4690: x_unique_flag := 'N';
4691: RAISE FND_API.G_EXC_ERROR;

Line 4697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4693: END IF; -- l_action_dlvr_relation%FOUND
4694: CLOSE l_action_ref_csr;
4695:
4696: ELSE -- p_action_reference IS NULL
4697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4698: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_AND_ID_MISSING') ;
4699: PA_UTILS.ADD_MESSAGE
4700: (p_app_short_name => 'PA',
4701: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 4711: END IF;-- fnd_msg_pub.g_msg_lvl_error

4707: p_value3 => p_action_reference,
4708: p_token4 => 'MESSAGE',
4709: p_value4 => l_err_message
4710: );
4711: END IF;-- fnd_msg_pub.g_msg_lvl_error
4712:
4713: x_unique_flag := Null;
4714:
4715: RAISE FND_API.G_EXC_ERROR;

Line 4730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4727:
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4731: FND_MSG_PUB.add_exc_msg
4732: ( p_pkg_name => G_MODULE_NAME
4733: , p_procedure_name => l_api_name );
4734: END IF;

Line 4731: FND_MSG_PUB.add_exc_msg

4727:
4728: WHEN OTHERS THEN
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4731: FND_MSG_PUB.add_exc_msg
4732: ( p_pkg_name => G_MODULE_NAME
4733: , p_procedure_name => l_api_name );
4734: END IF;
4735:

Line 4847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4843: FETCH l_action_id_csr INTO l_action_id;
4844:
4845: IF l_action_id_csr%NOTFOUND
4846: THEN
4847: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4848: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_ID_INVALID') ;
4849: PA_UTILS.ADD_MESSAGE
4850: (p_app_short_name => 'PA',
4851: p_msg_name => 'PA_ACTION_VALID_ERR',

Line 4880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4876: FETCH l_action_ref_csr INTO l_action_id;
4877:
4878: IF l_action_ref_csr%NOTFOUND
4879: THEN
4880: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4881: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_INVALID') ;
4882: PA_UTILS.ADD_MESSAGE
4883: (p_app_short_name => 'PA',
4884: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

4899:
4900: CLOSE l_action_ref_csr;
4901: p_out_action_id := l_action_id;
4902: ELSE
4903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4904: l_err_message := FND_MESSAGE.GET_STRING('PA','PA_ACTION_REF_AND_ID_MISSING') ;
4905: PA_UTILS.ADD_MESSAGE
4906: (p_app_short_name => 'PA',
4907: p_msg_name => 'PA_DLVR_VALID_ERR',

Line 4931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4927: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4928:
4929: WHEN OTHERS THEN
4930: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4932: FND_MSG_PUB.add_exc_msg
4933: ( p_pkg_name => G_MODULE_NAME
4934: , p_procedure_name => l_api_name );
4935: END IF;

Line 4932: FND_MSG_PUB.add_exc_msg

4928:
4929: WHEN OTHERS THEN
4930: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4932: FND_MSG_PUB.add_exc_msg
4933: ( p_pkg_name => G_MODULE_NAME
4934: , p_procedure_name => l_api_name );
4935: END IF;
4936:

Line 5060: FND_MSG_PUB.initialize;

5056: BEGIN
5057:
5058: -- Initialize the message table if requested.
5059: IF FND_API.TO_BOOLEAN( p_init_msg_list ) THEN
5060: FND_MSG_PUB.initialize;
5061: END IF;
5062:
5063: IF (p_commit = FND_API.G_TRUE) THEN
5064: savepoint CREATE_DELIVERABLE_PUB;

Line 5175: x_msg_count := FND_MSG_PUB.count_msg;

5171: pa_debug.reset_curr_function;
5172: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_ERROR exception',5);
5173: END IF;
5174: x_return_status := FND_API.G_RET_STS_ERROR;
5175: x_msg_count := FND_MSG_PUB.count_msg;
5176:
5177: IF x_msg_count = 1 THEN
5178: PA_INTERFACE_UTILS_PUB.get_messages
5179: (p_encoded => FND_API.G_FALSE,

Line 5202: x_msg_count := FND_MSG_PUB.count_msg;

5198:
5199: pa_debug.write(g_module_name,l_api_name||': Inside G_EXC_UNEXPECTED_ERROR exception',5);
5200: END IF;
5201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5202: x_msg_count := FND_MSG_PUB.count_msg;
5203:
5204: IF x_msg_count = 1 THEN
5205: PA_INTERFACE_UTILS_PUB.get_messages
5206: (p_encoded => FND_API.G_FALSE,

Line 5235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5231: pa_debug.reset_curr_function;
5232: END IF;
5233:
5234:
5235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5236: FND_MSG_PUB.add_exc_msg
5237: ( p_pkg_name => g_module_name
5238: , p_procedure_name => l_api_name );
5239: END IF;

Line 5236: FND_MSG_PUB.add_exc_msg

5232: END IF;
5233:
5234:
5235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5236: FND_MSG_PUB.add_exc_msg
5237: ( p_pkg_name => g_module_name
5238: , p_procedure_name => l_api_name );
5239: END IF;
5240: END enable_deliverable;

Line 5822: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'

5818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5819: x_msg_count := 1;
5820: x_msg_data := SQLERRM;
5821:
5822: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'
5823: ,p_procedure_name => 'GET_DEFAULT_TASK');
5824:
5825: IF l_debug_mode = 'Y' THEN
5826: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 6043: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'

6039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6040: x_msg_count := 1;
6041: x_msg_data := SQLERRM;
6042:
6043: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_DELIVERABLE_UTILS'
6044: ,p_procedure_name => 'GET_BILLING_DETAILS');
6045:
6046: IF l_debug_mode = 'Y' THEN
6047: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;