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_FP_CONTROL_ITEMS_UTILS dependencies on FND_MSG_PUB

Line 45: FND_MSG_PUB.initialize;

41: x_margin_derived_from_code := 'B';
42: IF P_PA_DEBUG_MODE = 'Y' THEN
43: pa_debug.init_err_stack('PA_FP_CONTROL_ITEMS_UTILS.Get_Fin_Plan_Dtls');
44: END IF;
45: FND_MSG_PUB.initialize;
46:
47: x_ci_est_qty := pa_fin_plan_utils.Get_Approved_Budget_Ver_Qty(
48: p_project_id => p_project_id,
49: p_version_code => 'CTRL_ITEM_VERSION',

Line 284: FND_MSG_PUB.Add_Exc_Msg(

280: END IF;
281: Pa_Debug.Reset_Err_Stack;
282: EXCEPTION
283: WHEN OTHERS THEN
284: FND_MSG_PUB.Add_Exc_Msg(
285: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.Get_Fin_Plan_Dtls'
286: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
287: IF P_PA_DEBUG_MODE = 'Y' THEN
288: pa_debug.write_file('Get_Fin_Plan_Dtls: ' || SQLERRM);

Line 363: FND_MSG_PUB.add_exc_msg(

359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: null;
362: WHEN OTHERS THEN
363: FND_MSG_PUB.add_exc_msg(
364: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.get_finplan_ci_type_name'
365: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
366: IF P_PA_DEBUG_MODE = 'Y' THEN
367: pa_debug.write_file('GET_FINPLAN_CI_TYPE_NAME: ' || SQLERRM);

Line 430: FND_MSG_PUB.add_exc_msg(

426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: null;
429: WHEN OTHERS THEN
430: FND_MSG_PUB.add_exc_msg(
431: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.get_fp_ci_agreement_dtls'
432: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
433: IF P_PA_DEBUG_MODE = 'Y' THEN
434: pa_debug.write_file('get_fp_ci_agreement_dtls: ' || SQLERRM);

Line 558: FND_MSG_PUB.add_exc_msg

554: WHERE pr.resource_list_id = x_resource_list_id;
555:
556: EXCEPTION
557: WHEN OTHERS THEN
558: FND_MSG_PUB.add_exc_msg
559: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
560: 'FP_CI_GET_VERSION_DETAILS'
561: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
562: ----DBMS_OUTPUT.PUT_LINE('FP_CI_GET_VERSION_DETAILS - 3');

Line 1489: FND_MSG_PUB.add_exc_msg

1485: -- For the Source Version Id
1486:
1487: EXCEPTION
1488: WHEN OTHERS THEN
1489: FND_MSG_PUB.add_exc_msg
1490: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
1491: 'FP_CI_CHECK_MERGE_POSSIBLE'
1492: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
1493: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1556: x_msg_count := FND_MSG_PUB.Count_Msg;

1552: open check_ci_funding_level;
1553: fetch check_ci_funding_level into l_ci_funding_level;
1554: IF check_ci_funding_level%NOTFOUND THEN
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556: x_msg_count := FND_MSG_PUB.Count_Msg;
1557: close check_ci_funding_level;
1558: return;
1559: END IF;
1560: close check_ci_funding_level;

Line 1582: x_msg_count := FND_MSG_PUB.Count_Msg;

1578: x_err_stack);
1579:
1580: if (x_err_code <> 0) then
1581: x_return_status := FND_API.G_RET_STS_ERROR;
1582: x_msg_count := FND_MSG_PUB.Count_Msg;
1583: if x_msg_count = 1 then
1584: PA_INTERFACE_UTILS_PUB.get_messages
1585: (p_encoded => FND_API.G_TRUE,
1586: p_msg_index => 1,

Line 1604: x_msg_count := FND_MSG_PUB.Count_Msg;

1600: p_msg_name => 'PA_FP_CHK_FUNDING_LVL');
1601: END IF;
1602: END IF;
1603:
1604: x_msg_count := FND_MSG_PUB.Count_Msg;
1605:
1606: IF x_msg_count = 1 then
1607: PA_INTERFACE_UTILS_PUB.get_messages
1608: (p_encoded => FND_API.G_TRUE,

Line 1619: FND_MSG_PUB.add_exc_msg

1615: WHEN OTHERS THEN
1616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1617: x_msg_count := 1;
1618: x_msg_data := SQLERRM;
1619: FND_MSG_PUB.add_exc_msg
1620: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
1621: ,p_procedure_name => 'isFundingLevelChangeAllowed' );
1622:
1623:

Line 1667: x_msg_count := FND_MSG_PUB.Count_Msg;

1663: p_msg_name => 'PA_FP_AGR_CI_NO_DELETE');
1664: END IF;
1665:
1666:
1667: x_msg_count := FND_MSG_PUB.Count_Msg;
1668: IF x_msg_count = 1 then
1669: PA_INTERFACE_UTILS_PUB.get_messages
1670: (p_encoded => FND_API.G_TRUE,
1671: p_msg_index => 1,

Line 1679: x_msg_count := FND_MSG_PUB.Count_Msg;

1675:
1676: EXCEPTION
1677: WHEN NO_DATA_FOUND THEN
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679: x_msg_count := FND_MSG_PUB.Count_Msg;
1680: IF x_msg_count = 1 then
1681: PA_INTERFACE_UTILS_PUB.get_messages
1682: (p_encoded => FND_API.G_TRUE,
1683: p_msg_index => 1,

Line 1691: FND_MSG_PUB.add_exc_msg

1687: WHEN OTHERS THEN
1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1689: x_msg_count := 1;
1690: x_msg_data := SQLERRM;
1691: FND_MSG_PUB.add_exc_msg
1692: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
1693: ,p_procedure_name => 'isAgreementDeletionAllowed' );
1694:
1695:

Line 1739: x_msg_count := FND_MSG_PUB.Count_Msg;

1735: p_msg_name => 'PA_FP_AGR_CUR_NO_CHANGE');
1736: END IF;
1737:
1738:
1739: x_msg_count := FND_MSG_PUB.Count_Msg;
1740: IF x_msg_count = 1 then
1741: PA_INTERFACE_UTILS_PUB.get_messages
1742: (p_encoded => FND_API.G_TRUE,
1743: p_msg_index => 1,

Line 1751: x_msg_count := FND_MSG_PUB.Count_Msg;

1747:
1748: EXCEPTION
1749: WHEN NO_DATA_FOUND THEN
1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751: x_msg_count := FND_MSG_PUB.Count_Msg;
1752: IF x_msg_count = 1 then
1753: PA_INTERFACE_UTILS_PUB.get_messages
1754: (p_encoded => FND_API.G_TRUE,
1755: p_msg_index => 1,

Line 1763: FND_MSG_PUB.add_exc_msg

1759: WHEN OTHERS THEN
1760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1761: x_msg_count := 1;
1762: x_msg_data := SQLERRM;
1763: FND_MSG_PUB.add_exc_msg
1764: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
1765: ,p_procedure_name => 'isAgrCurrencyChangeAllowed' );
1766:
1767: END isAgrCurrencyChangeAllowed;

Line 2175: l_msg_count := FND_MSG_PUB.count_msg;

2171:
2172: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2173:
2174: x_return_status := FND_API.G_RET_STS_ERROR;
2175: l_msg_count := FND_MSG_PUB.count_msg;
2176: IF l_msg_count = 1 THEN
2177: PA_INTERFACE_UTILS_PUB.get_messages
2178: (p_encoded => FND_API.G_TRUE
2179: ,p_msg_index => 1

Line 2200: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'

2196:
2197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2198: x_msg_count := 1;
2199: x_msg_data := SQLERRM;
2200: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
2201: ,p_procedure_name => 'Is_Create_CI_Version_Allowed');
2202: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
2203: IF P_PA_DEBUG_MODE = 'Y' THEN
2204: pa_debug.write('Is_Create_CI_Version_Allowed: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 2257: FND_MSG_PUB.Add_Exc_Msg(

2253: pa_debug.reset_err_stack;
2254: RETURN;
2255:
2256: WHEN OTHERS THEN
2257: FND_MSG_PUB.Add_Exc_Msg(
2258: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.IsValidAgreement'
2259: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2260: IF P_PA_DEBUG_MODE = 'Y' THEN
2261: pa_debug.write_file('IsValidAgreement: ' || SQLERRM);

Line 2409: FND_MSG_PUB.add_exc_msg

2405: END;
2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN
2409: FND_MSG_PUB.add_exc_msg
2410: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
2411: 'GET_BUDGET_VERSION_INFO'
2412: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2413: ----DBMS_OUTPUT.PUT_LINE('GET_BUDGET_VERSION_INFO - 3');

Line 2539: fnd_msg_pub.count_and_get (p_count => x_msg_count,

2535: p_value2 => l_plan_name,
2536: p_token3 => 'VERSION_TYPE',
2537: p_value3 => l_version_type);
2538:
2539: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2540: p_data => x_msg_data);
2541: x_msg_count := fnd_msg_pub.count_msg;
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: close c1;

Line 2541: x_msg_count := fnd_msg_pub.count_msg;

2537: p_value3 => l_version_type);
2538:
2539: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2540: p_data => x_msg_data);
2541: x_msg_count := fnd_msg_pub.count_msg;
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543: close c1;
2544:
2545: return;

Line 2551: x_msg_count := FND_MSG_PUB.Count_Msg;

2547:
2548: l_stage := 600;
2549: close c1;
2550:
2551: x_msg_count := FND_MSG_PUB.Count_Msg;
2552:
2553: IF x_msg_count = 1 then
2554: PA_INTERFACE_UTILS_PUB.get_messages
2555: (p_encoded => FND_API.G_TRUE,

Line 2567: FND_MSG_PUB.add_exc_msg

2563: WHEN OTHERS THEN
2564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2565: x_msg_count := 1;
2566: x_msg_data := to_char(l_stage)||'-'||SQLERRM;
2567: FND_MSG_PUB.add_exc_msg
2568: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
2569: ,p_procedure_name => 'Chk_Aprv_Cur_Working_BV_Exists' );
2570:
2571: END CHK_APRV_CUR_WORKING_BV_EXISTS;

Line 2617: x_msg_count := FND_MSG_PUB.Count_Msg;

2613: l_stage := 400;
2614: --For Bug 3642884
2615: x_attributes_same_flag := 'N';
2616: x_return_status := FND_API.G_RET_STS_SUCCESS;
2617: x_msg_count := FND_MSG_PUB.Count_Msg;
2618: x_msg_data := NULL;
2619:
2620: ELSE
2621: l_stage := 500;

Line 2625: x_msg_count := FND_MSG_PUB.Count_Msg;

2621: l_stage := 500;
2622: --For Bug 3642884
2623: x_attributes_same_flag := 'Y';
2624: x_return_status := FND_API.G_RET_STS_SUCCESS;
2625: x_msg_count := FND_MSG_PUB.Count_Msg;
2626: x_msg_data := NULL;
2627: END IF;
2628:
2629: EXCEPTION

Line 2634: FND_MSG_PUB.add_exc_msg

2630: WHEN OTHERS THEN
2631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2632: x_msg_count := 1;
2633: x_msg_data := to_char(l_stage)||'-'||SQLERRM;
2634: FND_MSG_PUB.add_exc_msg
2635: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
2636: ,p_procedure_name => 'Compare_Source_Target_Ver_Attr' );
2637:
2638: END COMPARE_SOURCE_TARGET_VER_ATTR;

Line 2704: FND_MSG_PUB.add_exc_msg

2700: RETURN;
2701: END IF;
2702: EXCEPTION
2703: WHEN OTHERS THEN
2704: FND_MSG_PUB.add_exc_msg
2705: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
2706: 'CHECK_PLAN_VERSION_NAME_OR_ID'
2707: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2708: ----DBMS_OUTPUT.PUT_LINE('CHECK_PLAN_VERSION_NAME_OR_ID - 3');

Line 3016: x_msg_count := FND_MSG_PUB.Count_Msg;

3012: )THEN
3013:
3014: x_copy_possible_flag := 'Y';
3015: x_return_status := FND_API.G_RET_STS_SUCCESS;
3016: x_msg_count := FND_MSG_PUB.Count_Msg;
3017: x_msg_data := NULL;
3018:
3019: ELSE
3020: IF (l_time_phase_code_flag = 'N') THEN

Line 3056: x_msg_count := FND_MSG_PUB.Count_Msg;

3052: );
3053:
3054: x_copy_possible_flag := 'N';
3055: x_return_status := FND_API.G_RET_STS_SUCCESS;
3056: x_msg_count := FND_MSG_PUB.Count_Msg;
3057: x_msg_data := NULL;
3058: END IF;
3059: EXCEPTION
3060: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3061: l_msg_count := FND_MSG_PUB.count_msg;

3057: x_msg_data := NULL;
3058: END IF;
3059: EXCEPTION
3060: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3061: l_msg_count := FND_MSG_PUB.count_msg;
3062: IF l_msg_count = 1 THEN
3063: PA_INTERFACE_UTILS_PUB.get_messages
3064: (p_encoded => FND_API.G_TRUE
3065: ,p_msg_index => 1

Line 3079: FND_MSG_PUB.add_exc_msg

3075: x_return_status := FND_API.G_RET_STS_ERROR;
3076: pa_debug.reset_err_stack;
3077: RAISE;
3078: WHEN OTHERS THEN
3079: FND_MSG_PUB.add_exc_msg
3080: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
3081: 'FP_CI_CHECK_COPY_POSSIBLE'
3082: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3083: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_COPY_POSSIBLE - 3');

Line 3146: FND_MSG_PUB.add_exc_msg

3142: RETURN;
3143: END IF;
3144: EXCEPTION
3145: WHEN OTHERS THEN
3146: FND_MSG_PUB.add_exc_msg
3147: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
3148: 'CHECK_FP_PLAN_VERSION_EXISTS'
3149: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3150: ----DBMS_OUTPUT.PUT_LINE('CHECK_FP_PLAN_VERSION_EXISTS - 3');

Line 3324: l_msg_count := FND_MSG_PUB.count_msg;

3320:
3321: EXCEPTION
3322: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3323: x_return_status := FND_API.G_RET_STS_ERROR;
3324: l_msg_count := FND_MSG_PUB.count_msg;
3325: IF l_msg_count = 1 THEN
3326: PA_INTERFACE_UTILS_PUB.get_messages
3327: (p_encoded => FND_API.G_TRUE
3328: ,p_msg_index => 1

Line 3349: FND_MSG_PUB.add_exc_msg

3345: WHEN OTHERS THEN
3346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3347: x_msg_count := 1;
3348: x_msg_data := SQLERRM;
3349: FND_MSG_PUB.add_exc_msg
3350: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
3351: ,p_procedure_name => 'Fp_Ci_Impact_Submit_Chk'
3352: ,p_error_text => x_msg_data);
3353:

Line 3519: l_msg_count := FND_MSG_PUB.count_msg;

3515:
3516: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3517:
3518: x_return_status := FND_API.G_RET_STS_ERROR;
3519: l_msg_count := FND_MSG_PUB.count_msg;
3520:
3521: IF l_msg_count = 1 and x_msg_data IS NULL THEN
3522: PA_INTERFACE_UTILS_PUB.get_messages
3523: (p_encoded => FND_API.G_TRUE

Line 3545: FND_MSG_PUB.add_exc_msg

3541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3542: x_msg_count := 1;
3543: x_msg_data := SQLERRM;
3544:
3545: FND_MSG_PUB.add_exc_msg
3546: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
3547: ,p_procedure_name => 'FP_CI_VALIDATE_UPDATE_IMPACT'
3548: ,p_error_text => x_msg_data);
3549:

Line 3946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',

3942: EXCEPTION
3943: WHEN OTHERS THEN
3944:
3945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
3947: p_procedure_name => 'chk_res_resgrp_mismatch',
3948: p_error_text => SUBSTRB(SQLERRM,1,240));
3949: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3950: p_data => x_msg_data);

Line 3949: fnd_msg_pub.count_and_get(p_count => x_msg_count,

3945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3946: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
3947: p_procedure_name => 'chk_res_resgrp_mismatch',
3948: p_error_text => SUBSTRB(SQLERRM,1,240));
3949: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3950: p_data => x_msg_data);
3951:
3952: END chk_res_resgrp_mismatch;
3953:

Line 4229: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',

4225: IF p_pa_debug_mode = 'Y' THEN
4226: PA_DEBUG.Reset_Err_Stack;
4227: END IF;
4228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4229: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
4230: p_procedure_name => 'chk_tsk_plan_level_mismatch',
4231: p_error_text => SUBSTRB(SQLERRM,1,240));
4232: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4233: p_data => x_msg_data);

Line 4232: fnd_msg_pub.count_and_get(p_count => x_msg_count,

4228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4229: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
4230: p_procedure_name => 'chk_tsk_plan_level_mismatch',
4231: p_error_text => SUBSTRB(SQLERRM,1,240));
4232: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4233: p_data => x_msg_data);
4234: END chk_tsk_plan_level_mismatch;
4235:
4236: /* dbora - FP M - New function to check for valid status

Line 5945: l_msg_count := FND_MSG_PUB.count_msg;

5941: pa_debug.reset_curr_function;
5942: RETURN;
5943:
5944: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5945: l_msg_count := FND_MSG_PUB.count_msg;
5946: IF l_msg_count = 1 THEN
5947: PA_INTERFACE_UTILS_PUB.get_messages
5948: (p_encoded => FND_API.G_TRUE
5949: ,p_msg_index => 1

Line 5967: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'

5963: WHEN OTHERS THEN
5964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5965: x_msg_count := 1;
5966: x_msg_data := SQLERRM;
5967: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
5968: ,p_procedure_name => 'get_summary_data');
5969:
5970: IF l_debug_mode = 'Y' THEN
5971: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7430: l_msg_count := FND_MSG_PUB.count_msg;

7426: pa_debug.reset_curr_function;
7427:
7428: EXCEPTION
7429: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7430: l_msg_count := FND_MSG_PUB.count_msg;
7431: IF l_msg_count = 1 THEN
7432: PA_INTERFACE_UTILS_PUB.get_messages
7433: (p_encoded => FND_API.G_TRUE
7434: ,p_msg_index => 1

Line 7452: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'

7448: WHEN OTHERS THEN
7449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7450: x_msg_count := 1;
7451: x_msg_data := SQLERRM;
7452: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
7453: ,p_procedure_name => 'get_not_included');
7454:
7455: IF l_debug_mode = 'Y' THEN
7456: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7562: l_msg_count := FND_MSG_PUB.count_msg;

7558: pa_debug.reset_curr_function;
7559: RETURN l_impact_type_code;
7560: EXCEPTION
7561: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7562: l_msg_count := FND_MSG_PUB.count_msg;
7563:
7564: IF l_msg_count = 1 THEN
7565: PA_INTERFACE_UTILS_PUB.get_messages
7566: (p_encoded => FND_API.G_TRUE

Line 7752: l_msg_count := FND_MSG_PUB.count_msg;

7748: pa_debug.reset_curr_function;
7749:
7750: EXCEPTION
7751: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7752: l_msg_count := FND_MSG_PUB.count_msg;
7753:
7754: IF l_msg_count = 1 and x_msg_data IS NULL THEN
7755: PA_INTERFACE_UTILS_PUB.get_messages
7756: (p_encoded => FND_API.G_TRUE

Line 7782: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'

7778: IF c_vers_for_ci%ISOPEN THEN
7779: CLOSE c_vers_for_ci;
7780: END IF;
7781:
7782: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
7783: ,p_procedure_name => 'GET_CI_VERSIONS');
7784: IF P_PA_DEBUG_MODE = 'Y' THEN
7785: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
7786: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);

Line 8433: l_msg_count := FND_MSG_PUB.count_msg;

8429: pa_debug.reset_curr_function;
8430:
8431: EXCEPTION
8432: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8433: l_msg_count := FND_MSG_PUB.count_msg;
8434:
8435: IF c_plan_types_attached%ISOPEN THEN
8436: CLOSE c_plan_types_attached;
8437: END IF;

Line 8465: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'

8461: IF c_plan_types_attached%ISOPEN THEN
8462: CLOSE c_plan_types_attached;
8463: END IF;
8464:
8465: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
8466: ,p_procedure_name => 'GET_PLAN_TYPES_FOR_IMPL');
8467: IF l_DEBUG_MODE = 'Y' THEN
8468: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
8469: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);

Line 9061: l_msg_count := FND_MSG_PUB.count_msg;

9057: pa_debug.reset_curr_function;
9058:
9059: EXCEPTION
9060: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9061: l_msg_count := FND_MSG_PUB.count_msg;
9062:
9063: IF l_msg_count = 1 and x_msg_data IS NULL THEN
9064: PA_INTERFACE_UTILS_PUB.get_messages
9065: (p_encoded => FND_API.G_TRUE

Line 9086: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'

9082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9083: x_msg_count := 1;
9084: x_msg_data := SQLERRM;
9085:
9086: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
9087: ,p_procedure_name => 'GET_IMPL_DETAILS');
9088: IF P_PA_DEBUG_MODE = 'Y' THEN
9089: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
9090: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);

Line 9503: l_msg_count := FND_MSG_PUB.count_msg;

9499:
9500: EXCEPTION
9501:
9502: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9503: l_msg_count := FND_MSG_PUB.count_msg;
9504: IF l_msg_count = 1 THEN
9505: PA_INTERFACE_UTILS_PUB.get_messages
9506: (p_encoded => FND_API.G_TRUE
9507: ,p_msg_index => 1

Line 9527: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'

9523:
9524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9525: x_msg_count := 1;
9526: x_msg_data := SQLERRM;
9527: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
9528: ,p_procedure_name => 'get_dtls_for_view_fin_imp_pg');
9529:
9530: IF l_debug_mode = 'Y' THEN
9531: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9649: l_msg_count := FND_MSG_PUB.count_msg;

9645: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9646:
9647: CLOSE c_app_cw_ver_csr; -- Added for bug#6405905
9648:
9649: l_msg_count := FND_MSG_PUB.count_msg;
9650: IF l_msg_count = 1 THEN
9651: PA_INTERFACE_UTILS_PUB.get_messages
9652: (p_encoded => FND_API.G_TRUE
9653: ,p_msg_index => 1

Line 9675: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'

9671:
9672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9673: x_msg_count := 1;
9674: x_msg_data := SQLERRM;
9675: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
9676: ,p_procedure_name => 'get_app_cw_ver_ids_for_proj');
9677:
9678: IF l_debug_mode = 'Y' THEN
9679: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9809: l_msg_count := FND_MSG_PUB.count_msg;

9805: RETURN l_impl_agr_rev_amt;
9806:
9807: EXCEPTION
9808: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9809: l_msg_count := FND_MSG_PUB.count_msg;
9810: IF l_msg_count = 1 THEN
9811: PA_INTERFACE_UTILS_PUB.get_messages
9812: (p_encoded => FND_API.G_TRUE
9813: ,p_msg_index => 1

Line 9822: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'

9818: END IF;
9819: pa_debug.reset_curr_function;
9820:
9821: WHEN OTHERS THEN
9822: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
9823: ,p_procedure_name => 'get_app_cw_ver_ids_for_proj');
9824:
9825: IF l_debug_mode = 'Y' THEN
9826: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9937: l_msg_count := FND_MSG_PUB.count_msg;

9933: End;
9934:
9935: EXCEPTION
9936: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9937: l_msg_count := FND_MSG_PUB.count_msg;
9938: IF l_msg_count = 1 THEN
9939: PA_INTERFACE_UTILS_PUB.get_messages
9940: (p_encoded => FND_API.G_TRUE
9941: ,p_msg_index => 1

Line 9961: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'

9957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9958: x_msg_count := 1;
9959: x_msg_data := SQLERRM;
9960:
9961: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
9962: ,p_procedure_name => 'get_txn_curr_code_of_ci_ver');
9963:
9964: IF P_PA_DEBUG_MODE = 'Y' THEN
9965: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10053: l_msg_count := FND_MSG_PUB.count_msg;

10049: RETURN is_delete_allowed;
10050:
10051: EXCEPTION
10052: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10053: l_msg_count := FND_MSG_PUB.count_msg;
10054: IF l_msg_count = 1 THEN
10055: PA_INTERFACE_UTILS_PUB.get_messages
10056: (p_encoded => FND_API.G_TRUE
10057: ,p_msg_index => 1

Line 10065: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'

10061: ,p_msg_index_out => l_msg_index_out);
10062: END IF;
10063: pa_debug.reset_curr_function;
10064: WHEN OTHERS THEN
10065: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
10066: ,p_procedure_name => 'validate_fp_ci_type_delete');
10067:
10068: IF l_debug_mode = 'Y' THEN
10069: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;