DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_UTILS dependencies on FND_MSG_PUB

Line 156: l_msg_count := FND_MSG_PUB.count_msg;

152: , x_msg_count => x_msg_count
153: , x_msg_data => x_msg_data);
154:
155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
156: l_msg_count := FND_MSG_PUB.count_msg;
157: IF l_msg_count = 1 THEN
158: PA_INTERFACE_UTILS_PUB.get_messages
159: (p_encoded => FND_API.G_TRUE,
160: p_msg_index => 1,

Line 331: l_msg_count := FND_MSG_PUB.count_msg;

327:
328: EXCEPTION
329:
330: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
331: l_msg_count := FND_MSG_PUB.count_msg;
332: IF l_msg_count = 1 THEN
333: PA_INTERFACE_UTILS_PUB.get_messages
334: (p_encoded => FND_API.G_TRUE
335: ,p_msg_index => 1

Line 361: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'

357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: x_msg_count := 1;
359: x_msg_data := SQLERRM;
360:
361: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'
362: ,p_procedure_name => 'get_metadata_info');
363:
364: IF l_debug_mode = 'Y' THEN
365: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 484: l_msg_count := FND_MSG_PUB.count_msg;

480:
481: EXCEPTION
482: WHEN FND_API.G_EXC_ERROR or PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: l_msg_count := FND_MSG_PUB.count_msg;
485: IF l_msg_count = 1 THEN
486: PA_INTERFACE_UTILS_PUB.get_messages
487: (p_encoded => FND_API.G_TRUE,
488: p_msg_index => 1,

Line 898: l_msg_count := FND_MSG_PUB.count_msg;

894:
895: EXCEPTION
896: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: l_msg_count := FND_MSG_PUB.count_msg;
899: IF l_msg_count = 1 THEN
900: PA_INTERFACE_UTILS_PUB.get_messages
901: (p_encoded => FND_API.G_TRUE,
902: p_msg_index => 1,

Line 926: FND_MSG_PUB.add_exc_msg

922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
923: x_msg_count := 1;
924: x_msg_data := SQLERRM;
925:
926: FND_MSG_PUB.add_exc_msg
927: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
928: ,p_procedure_name => 'GET_RES_ASSIGNMENT_INFO'
929: ,p_error_text => sqlerrm);
930:

Line 1008: l_msg_count := FND_MSG_PUB.count_msg;

1004: EXCEPTION
1005:
1006: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: l_msg_count := FND_MSG_PUB.count_msg;
1009: IF l_msg_count = 1 THEN
1010: PA_INTERFACE_UTILS_PUB.get_messages
1011: (p_encoded => FND_API.G_TRUE,
1012: p_msg_index => 1,

Line 1042: FND_MSG_PUB.add_exc_msg

1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: x_msg_count := 1;
1040: x_msg_data := SQLERRM;
1041:
1042: FND_MSG_PUB.add_exc_msg
1043: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
1044: ,p_procedure_name => 'VALIDATE_CHANGE_REASON_CODE'
1045: ,p_error_text => sqlerrm);
1046:

Line 1163: l_msg_count := FND_MSG_PUB.count_msg;

1159:
1160: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1161:
1162: x_return_status := FND_API.G_RET_STS_ERROR;
1163: l_msg_count := FND_MSG_PUB.count_msg;
1164:
1165: -- Close the cursor if its open
1166:
1167: IF C_TXN_CURR_CODE%ISOPEN THEN

Line 1204: FND_MSG_PUB.add_exc_msg

1200: CLOSE C_TXN_CURR_CODE ;
1201: END IF ;
1202:
1203:
1204: FND_MSG_PUB.add_exc_msg
1205: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
1206: ,p_procedure_name => 'VALIDATE_TXN_CURRENCY_CODE'
1207: ,p_error_text => sqlerrm);
1208:

Line 1621: l_msg_count := FND_MSG_PUB.count_msg;

1617: EXCEPTION
1618: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: l_msg_count := FND_MSG_PUB.count_msg;
1622: -- Close the cursor
1623:
1624: IF C_PERIOD_DATES_CUR%ISOPEN THEN
1625: CLOSE C_PERIOD_DATES_CUR ;

Line 1662: FND_MSG_PUB.add_exc_msg

1658: IF C_PERIOD_DATES_CUR%ISOPEN THEN
1659: CLOSE C_PERIOD_DATES_CUR ;
1660: END IF ;
1661:
1662: FND_MSG_PUB.add_exc_msg
1663: ( p_pkg_name => 'PA_FP_WEBADI_PKG'
1664: ,p_procedure_name => 'GET_VERSION_PERIOD_INFO' );
1665: IF l_debug_mode = 'Y' THEN
1666: pa_debug.write('DELETE_XFACE' || g_module_name,SQLERRM,4);

Line 1779: l_msg_count := FND_MSG_PUB.count_msg;

1775:
1776: EXCEPTION
1777: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1778: x_return_status := FND_API.G_RET_STS_ERROR;
1779: l_msg_count := FND_MSG_PUB.count_msg;
1780:
1781: -- Close the cursor
1782:
1783: IF C_OVERLAPPING_CUR%ISOPEN THEN

Line 1821: FND_MSG_PUB.add_exc_msg

1817: IF C_OVERLAPPING_CUR%ISOPEN THEN
1818: CLOSE C_OVERLAPPING_CUR ;
1819: END IF ;
1820:
1821: FND_MSG_PUB.add_exc_msg
1822: ( p_pkg_name => 'PA_FP_WEBADI_PKG'
1823: ,p_procedure_name => 'C_OVERLAPPING_CUR' );
1824: IF l_debug_mode = 'Y' THEN
1825: pa_debug.write('check_overlapping_dates' || g_module_name,SQLERRM,4);

Line 2004: l_msg_count := FND_MSG_PUB.count_msg;

2000:
2001: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2002:
2003: x_return_status := FND_API.G_RET_STS_ERROR;
2004: l_msg_count := FND_MSG_PUB.count_msg;
2005:
2006: IF l_msg_count = 1 and x_msg_data IS NULL THEN
2007: PA_INTERFACE_UTILS_PUB.get_messages
2008: (p_encoded => FND_API.G_TRUE

Line 2030: FND_MSG_PUB.add_exc_msg

2026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2027: x_msg_count := 1;
2028: x_msg_data := SQLERRM;
2029:
2030: FND_MSG_PUB.add_exc_msg
2031: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
2032: ,p_procedure_name => 'GET_ERROR_LOOKUP_CODE'
2033: ,p_error_text => x_msg_data);
2034:

Line 2209: l_msg_count := FND_MSG_PUB.count_msg;

2205:
2206: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2207:
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209: l_msg_count := FND_MSG_PUB.count_msg;
2210:
2211:
2212: IF l_msg_count = 1 and x_msg_data IS NULL THEN
2213: PA_INTERFACE_UTILS_PUB.get_messages

Line 2236: FND_MSG_PUB.add_exc_msg

2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2233: x_msg_count := 1;
2234: x_msg_data := SQLERRM;
2235:
2236: FND_MSG_PUB.add_exc_msg
2237: ( p_pkg_name => 'PA_FP_WEBADI_UTILS'
2238: ,p_procedure_name => 'CONV_MC_ATTR_MEANING_TO_CODE'
2239: ,p_error_text => x_msg_data);
2240:

Line 2364: l_msg_count := FND_MSG_PUB.count_msg;

2360:
2361: EXCEPTION
2362:
2363: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2364: l_msg_count := FND_MSG_PUB.count_msg;
2365: IF l_msg_count = 1 THEN
2366: PA_INTERFACE_UTILS_PUB.get_messages
2367: (p_encoded => FND_API.G_TRUE
2368: ,p_msg_index => 1

Line 2394: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'

2390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2391: x_msg_count := 1;
2392: x_msg_data := SQLERRM;
2393:
2394: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_utils'
2395: ,p_procedure_name => 'get_layout_details');
2396:
2397: IF l_debug_mode = 'Y' THEN
2398: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2530: l_msg_count := FND_MSG_PUB.count_msg;

2526: pa_debug.reset_curr_function;
2527:
2528: EXCEPTION
2529: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2530: l_msg_count := FND_MSG_PUB.count_msg;
2531: IF l_msg_count = 1 THEN
2532: PA_INTERFACE_UTILS_PUB.get_messages
2533: (p_encoded => FND_API.G_TRUE
2534: ,p_msg_index => 1

Line 2542: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPWAUB'

2538: ,p_msg_index_out => l_msg_index_out);
2539: END IF;
2540: pa_debug.reset_curr_function;
2541: WHEN OTHERS THEN
2542: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPWAUB'
2543: ,p_procedure_name => 'delete_interface_tbl_data');
2544:
2545: IF l_debug_mode = 'Y' THEN
2546: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 2715: l_msg_count := FND_MSG_PUB.count_msg;

2711: pa_debug.reset_curr_function;
2712:
2713: EXCEPTION
2714: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2715: l_msg_count := FND_MSG_PUB.count_msg;
2716: IF l_msg_count = 1 THEN
2717: PA_INTERFACE_UTILS_PUB.get_messages
2718: (p_encoded => FND_API.G_TRUE
2719: ,p_msg_index => 1

Line 2727: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPWAUB'

2723: ,p_msg_index_out => l_msg_index_out);
2724: END IF;
2725: pa_debug.reset_curr_function;
2726: WHEN OTHERS THEN
2727: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPWAUB'
2728: ,p_procedure_name => 'resubmit_conc_request');
2729:
2730: IF l_debug_mode = 'Y' THEN
2731: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;