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 52: FND_MSG_PUB.initialize;

48: x_margin_derived_from_code := 'B';
49: IF P_PA_DEBUG_MODE = 'Y' THEN
50: pa_debug.init_err_stack('PA_FP_CONTROL_ITEMS_UTILS.Get_Fin_Plan_Dtls');
51: END IF;
52: FND_MSG_PUB.initialize;
53:
54: x_ci_est_qty := pa_fin_plan_utils.Get_Approved_Budget_Ver_Qty(
55: p_project_id => p_project_id,
56: p_version_code => 'CTRL_ITEM_VERSION',

Line 308: FND_MSG_PUB.Add_Exc_Msg(

304: END IF;
305: Pa_Debug.Reset_Err_Stack;
306: EXCEPTION
307: WHEN OTHERS THEN
308: FND_MSG_PUB.Add_Exc_Msg(
309: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.Get_Fin_Plan_Dtls'
310: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
311: IF P_PA_DEBUG_MODE = 'Y' THEN
312: pa_debug.write_file('Get_Fin_Plan_Dtls: ' || SQLERRM);

Line 387: FND_MSG_PUB.add_exc_msg(

383: EXCEPTION
384: WHEN NO_DATA_FOUND THEN
385: null;
386: WHEN OTHERS THEN
387: FND_MSG_PUB.add_exc_msg(
388: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.get_finplan_ci_type_name'
389: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
390: IF P_PA_DEBUG_MODE = 'Y' THEN
391: pa_debug.write_file('GET_FINPLAN_CI_TYPE_NAME: ' || SQLERRM);

Line 454: FND_MSG_PUB.add_exc_msg(

450: EXCEPTION
451: WHEN NO_DATA_FOUND THEN
452: null;
453: WHEN OTHERS THEN
454: FND_MSG_PUB.add_exc_msg(
455: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.get_fp_ci_agreement_dtls'
456: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
457: IF P_PA_DEBUG_MODE = 'Y' THEN
458: pa_debug.write_file('get_fp_ci_agreement_dtls: ' || SQLERRM);

Line 582: FND_MSG_PUB.add_exc_msg

578: WHERE pr.resource_list_id = x_resource_list_id;
579:
580: EXCEPTION
581: WHEN OTHERS THEN
582: FND_MSG_PUB.add_exc_msg
583: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
584: 'FP_CI_GET_VERSION_DETAILS'
585: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
586: ----DBMS_OUTPUT.PUT_LINE('FP_CI_GET_VERSION_DETAILS - 3');

Line 1523: FND_MSG_PUB.add_exc_msg

1519: -- For the Source Version Id
1520:
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: FND_MSG_PUB.add_exc_msg
1524: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
1525: 'FP_CI_CHECK_MERGE_POSSIBLE'
1526: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
1527: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1590: x_msg_count := FND_MSG_PUB.Count_Msg;

1586: open check_ci_funding_level;
1587: fetch check_ci_funding_level into l_ci_funding_level;
1588: IF check_ci_funding_level%NOTFOUND THEN
1589: x_return_status := FND_API.G_RET_STS_SUCCESS;
1590: x_msg_count := FND_MSG_PUB.Count_Msg;
1591: close check_ci_funding_level;
1592: return;
1593: END IF;
1594: close check_ci_funding_level;

Line 1616: x_msg_count := FND_MSG_PUB.Count_Msg;

1612: x_err_stack);
1613:
1614: if (x_err_code <> 0) then
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: x_msg_count := FND_MSG_PUB.Count_Msg;
1617: if x_msg_count = 1 then
1618: PA_INTERFACE_UTILS_PUB.get_messages
1619: (p_encoded => FND_API.G_TRUE,
1620: p_msg_index => 1,

Line 1638: x_msg_count := FND_MSG_PUB.Count_Msg;

1634: p_msg_name => 'PA_FP_CHK_FUNDING_LVL');
1635: END IF;
1636: END IF;
1637:
1638: x_msg_count := FND_MSG_PUB.Count_Msg;
1639:
1640: IF x_msg_count = 1 then
1641: PA_INTERFACE_UTILS_PUB.get_messages
1642: (p_encoded => FND_API.G_TRUE,

Line 1653: FND_MSG_PUB.add_exc_msg

1649: WHEN OTHERS THEN
1650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1651: x_msg_count := 1;
1652: x_msg_data := SQLERRM;
1653: FND_MSG_PUB.add_exc_msg
1654: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
1655: ,p_procedure_name => 'isFundingLevelChangeAllowed' );
1656:
1657:

Line 1701: x_msg_count := FND_MSG_PUB.Count_Msg;

1697: p_msg_name => 'PA_FP_AGR_CI_NO_DELETE');
1698: END IF;
1699:
1700:
1701: x_msg_count := FND_MSG_PUB.Count_Msg;
1702: IF x_msg_count = 1 then
1703: PA_INTERFACE_UTILS_PUB.get_messages
1704: (p_encoded => FND_API.G_TRUE,
1705: p_msg_index => 1,

Line 1713: x_msg_count := FND_MSG_PUB.Count_Msg;

1709:
1710: EXCEPTION
1711: WHEN NO_DATA_FOUND THEN
1712: x_return_status := FND_API.G_RET_STS_SUCCESS;
1713: x_msg_count := FND_MSG_PUB.Count_Msg;
1714: IF x_msg_count = 1 then
1715: PA_INTERFACE_UTILS_PUB.get_messages
1716: (p_encoded => FND_API.G_TRUE,
1717: p_msg_index => 1,

Line 1725: FND_MSG_PUB.add_exc_msg

1721: WHEN OTHERS THEN
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1723: x_msg_count := 1;
1724: x_msg_data := SQLERRM;
1725: FND_MSG_PUB.add_exc_msg
1726: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
1727: ,p_procedure_name => 'isAgreementDeletionAllowed' );
1728:
1729:

Line 1773: x_msg_count := FND_MSG_PUB.Count_Msg;

1769: p_msg_name => 'PA_FP_AGR_CUR_NO_CHANGE');
1770: END IF;
1771:
1772:
1773: x_msg_count := FND_MSG_PUB.Count_Msg;
1774: IF x_msg_count = 1 then
1775: PA_INTERFACE_UTILS_PUB.get_messages
1776: (p_encoded => FND_API.G_TRUE,
1777: p_msg_index => 1,

Line 1785: x_msg_count := FND_MSG_PUB.Count_Msg;

1781:
1782: EXCEPTION
1783: WHEN NO_DATA_FOUND THEN
1784: x_return_status := FND_API.G_RET_STS_SUCCESS;
1785: x_msg_count := FND_MSG_PUB.Count_Msg;
1786: IF x_msg_count = 1 then
1787: PA_INTERFACE_UTILS_PUB.get_messages
1788: (p_encoded => FND_API.G_TRUE,
1789: p_msg_index => 1,

Line 1797: FND_MSG_PUB.add_exc_msg

1793: WHEN OTHERS THEN
1794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1795: x_msg_count := 1;
1796: x_msg_data := SQLERRM;
1797: FND_MSG_PUB.add_exc_msg
1798: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
1799: ,p_procedure_name => 'isAgrCurrencyChangeAllowed' );
1800:
1801: END isAgrCurrencyChangeAllowed;

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: IF l_msg_count = 1 THEN
2211: PA_INTERFACE_UTILS_PUB.get_messages
2212: (p_encoded => FND_API.G_TRUE
2213: ,p_msg_index => 1

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

2230:
2231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2232: x_msg_count := 1;
2233: x_msg_data := SQLERRM;
2234: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
2235: ,p_procedure_name => 'Is_Create_CI_Version_Allowed');
2236: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
2237: IF P_PA_DEBUG_MODE = 'Y' THEN
2238: pa_debug.write('Is_Create_CI_Version_Allowed: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 2291: FND_MSG_PUB.Add_Exc_Msg(

2287: pa_debug.reset_err_stack;
2288: RETURN;
2289:
2290: WHEN OTHERS THEN
2291: FND_MSG_PUB.Add_Exc_Msg(
2292: p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS.IsValidAgreement'
2293: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2294: IF P_PA_DEBUG_MODE = 'Y' THEN
2295: pa_debug.write_file('IsValidAgreement: ' || SQLERRM);

Line 2443: FND_MSG_PUB.add_exc_msg

2439: END;
2440:
2441: EXCEPTION
2442: WHEN OTHERS THEN
2443: FND_MSG_PUB.add_exc_msg
2444: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
2445: 'GET_BUDGET_VERSION_INFO'
2446: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2447: ----DBMS_OUTPUT.PUT_LINE('GET_BUDGET_VERSION_INFO - 3');

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

2584: p_value2 => l_plan_name,
2585: p_token3 => 'VERSION_TYPE',
2586: p_value3 => l_version_type);
2587:
2588: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2589: p_data => x_msg_data);
2590: x_msg_count := fnd_msg_pub.count_msg;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: close c1;

Line 2590: x_msg_count := fnd_msg_pub.count_msg;

2586: p_value3 => l_version_type);
2587:
2588: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2589: p_data => x_msg_data);
2590: x_msg_count := fnd_msg_pub.count_msg;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: close c1;
2593:
2594: return;

Line 2600: x_msg_count := FND_MSG_PUB.Count_Msg;

2596:
2597: l_stage := 600;
2598: close c1;
2599:
2600: x_msg_count := FND_MSG_PUB.Count_Msg;
2601:
2602: IF x_msg_count = 1 then
2603: PA_INTERFACE_UTILS_PUB.get_messages
2604: (p_encoded => FND_API.G_TRUE,

Line 2616: FND_MSG_PUB.add_exc_msg

2612: WHEN OTHERS THEN
2613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2614: x_msg_count := 1;
2615: x_msg_data := to_char(l_stage)||'-'||SQLERRM;
2616: FND_MSG_PUB.add_exc_msg
2617: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
2618: ,p_procedure_name => 'Chk_Aprv_Cur_Working_BV_Exists' );
2619:
2620: END CHK_APRV_CUR_WORKING_BV_EXISTS;

Line 2666: x_msg_count := FND_MSG_PUB.Count_Msg;

2662: l_stage := 400;
2663: --For Bug 3642884
2664: x_attributes_same_flag := 'N';
2665: x_return_status := FND_API.G_RET_STS_SUCCESS;
2666: x_msg_count := FND_MSG_PUB.Count_Msg;
2667: x_msg_data := NULL;
2668:
2669: ELSE
2670: l_stage := 500;

Line 2674: x_msg_count := FND_MSG_PUB.Count_Msg;

2670: l_stage := 500;
2671: --For Bug 3642884
2672: x_attributes_same_flag := 'Y';
2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674: x_msg_count := FND_MSG_PUB.Count_Msg;
2675: x_msg_data := NULL;
2676: END IF;
2677:
2678: EXCEPTION

Line 2683: FND_MSG_PUB.add_exc_msg

2679: WHEN OTHERS THEN
2680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2681: x_msg_count := 1;
2682: x_msg_data := to_char(l_stage)||'-'||SQLERRM;
2683: FND_MSG_PUB.add_exc_msg
2684: ( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
2685: ,p_procedure_name => 'Compare_Source_Target_Ver_Attr' );
2686:
2687: END COMPARE_SOURCE_TARGET_VER_ATTR;

Line 2753: FND_MSG_PUB.add_exc_msg

2749: RETURN;
2750: END IF;
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: FND_MSG_PUB.add_exc_msg
2754: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
2755: 'CHECK_PLAN_VERSION_NAME_OR_ID'
2756: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2757: ----DBMS_OUTPUT.PUT_LINE('CHECK_PLAN_VERSION_NAME_OR_ID - 3');

Line 3065: x_msg_count := FND_MSG_PUB.Count_Msg;

3061: )THEN
3062:
3063: x_copy_possible_flag := 'Y';
3064: x_return_status := FND_API.G_RET_STS_SUCCESS;
3065: x_msg_count := FND_MSG_PUB.Count_Msg;
3066: x_msg_data := NULL;
3067:
3068: ELSE
3069: IF (l_time_phase_code_flag = 'N') THEN

Line 3105: x_msg_count := FND_MSG_PUB.Count_Msg;

3101: );
3102:
3103: x_copy_possible_flag := 'N';
3104: x_return_status := FND_API.G_RET_STS_SUCCESS;
3105: x_msg_count := FND_MSG_PUB.Count_Msg;
3106: x_msg_data := NULL;
3107: END IF;
3108: EXCEPTION
3109: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 3110: l_msg_count := FND_MSG_PUB.count_msg;

3106: x_msg_data := NULL;
3107: END IF;
3108: EXCEPTION
3109: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3110: l_msg_count := FND_MSG_PUB.count_msg;
3111: IF l_msg_count = 1 THEN
3112: PA_INTERFACE_UTILS_PUB.get_messages
3113: (p_encoded => FND_API.G_TRUE
3114: ,p_msg_index => 1

Line 3128: FND_MSG_PUB.add_exc_msg

3124: x_return_status := FND_API.G_RET_STS_ERROR;
3125: pa_debug.reset_err_stack;
3126: RAISE;
3127: WHEN OTHERS THEN
3128: FND_MSG_PUB.add_exc_msg
3129: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
3130: 'FP_CI_CHECK_COPY_POSSIBLE'
3131: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3132: ----DBMS_OUTPUT.PUT_LINE('FP_CI_CHECK_COPY_POSSIBLE - 3');

Line 3195: FND_MSG_PUB.add_exc_msg

3191: RETURN;
3192: END IF;
3193: EXCEPTION
3194: WHEN OTHERS THEN
3195: FND_MSG_PUB.add_exc_msg
3196: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils.' ||
3197: 'CHECK_FP_PLAN_VERSION_EXISTS'
3198: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3199: ----DBMS_OUTPUT.PUT_LINE('CHECK_FP_PLAN_VERSION_EXISTS - 3');

Line 3373: l_msg_count := FND_MSG_PUB.count_msg;

3369:
3370: EXCEPTION
3371: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: l_msg_count := FND_MSG_PUB.count_msg;
3374: IF l_msg_count = 1 THEN
3375: PA_INTERFACE_UTILS_PUB.get_messages
3376: (p_encoded => FND_API.G_TRUE
3377: ,p_msg_index => 1

Line 3398: FND_MSG_PUB.add_exc_msg

3394: WHEN OTHERS THEN
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3396: x_msg_count := 1;
3397: x_msg_data := SQLERRM;
3398: FND_MSG_PUB.add_exc_msg
3399: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
3400: ,p_procedure_name => 'Fp_Ci_Impact_Submit_Chk'
3401: ,p_error_text => x_msg_data);
3402:

Line 3568: l_msg_count := FND_MSG_PUB.count_msg;

3564:
3565: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3566:
3567: x_return_status := FND_API.G_RET_STS_ERROR;
3568: l_msg_count := FND_MSG_PUB.count_msg;
3569:
3570: IF l_msg_count = 1 and x_msg_data IS NULL THEN
3571: PA_INTERFACE_UTILS_PUB.get_messages
3572: (p_encoded => FND_API.G_TRUE

Line 3594: FND_MSG_PUB.add_exc_msg

3590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3591: x_msg_count := 1;
3592: x_msg_data := SQLERRM;
3593:
3594: FND_MSG_PUB.add_exc_msg
3595: ( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
3596: ,p_procedure_name => 'FP_CI_VALIDATE_UPDATE_IMPACT'
3597: ,p_error_text => x_msg_data);
3598:

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

3991: EXCEPTION
3992: WHEN OTHERS THEN
3993:
3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3995: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
3996: p_procedure_name => 'chk_res_resgrp_mismatch',
3997: p_error_text => SUBSTRB(SQLERRM,1,240));
3998: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3999: p_data => x_msg_data);

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

3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3995: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
3996: p_procedure_name => 'chk_res_resgrp_mismatch',
3997: p_error_text => SUBSTRB(SQLERRM,1,240));
3998: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3999: p_data => x_msg_data);
4000:
4001: END chk_res_resgrp_mismatch;
4002:

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

4274: IF p_pa_debug_mode = 'Y' THEN
4275: PA_DEBUG.Reset_Err_Stack;
4276: END IF;
4277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4278: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
4279: p_procedure_name => 'chk_tsk_plan_level_mismatch',
4280: p_error_text => SUBSTRB(SQLERRM,1,240));
4281: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4282: p_data => x_msg_data);

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

4277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4278: fnd_msg_pub.add_exc_msg(p_pkg_name => 'Pa_Fp_Control_Items_Utils',
4279: p_procedure_name => 'chk_tsk_plan_level_mismatch',
4280: p_error_text => SUBSTRB(SQLERRM,1,240));
4281: fnd_msg_pub.count_and_get(p_count => x_msg_count,
4282: p_data => x_msg_data);
4283: END chk_tsk_plan_level_mismatch;
4284:
4285: /* dbora - FP M - New function to check for valid status

Line 6001: l_msg_count := FND_MSG_PUB.count_msg;

5997: pa_debug.reset_curr_function;
5998: RETURN;
5999:
6000: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6001: l_msg_count := FND_MSG_PUB.count_msg;
6002: IF l_msg_count = 1 THEN
6003: PA_INTERFACE_UTILS_PUB.get_messages
6004: (p_encoded => FND_API.G_TRUE
6005: ,p_msg_index => 1

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

6019: WHEN OTHERS THEN
6020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6021: x_msg_count := 1;
6022: x_msg_data := SQLERRM;
6023: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
6024: ,p_procedure_name => 'get_summary_data');
6025:
6026: IF l_debug_mode = 'Y' THEN
6027: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7502: l_msg_count := FND_MSG_PUB.count_msg;

7498: pa_debug.reset_curr_function;
7499:
7500: EXCEPTION
7501: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7502: l_msg_count := FND_MSG_PUB.count_msg;
7503: IF l_msg_count = 1 THEN
7504: PA_INTERFACE_UTILS_PUB.get_messages
7505: (p_encoded => FND_API.G_TRUE
7506: ,p_msg_index => 1

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

7520: WHEN OTHERS THEN
7521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7522: x_msg_count := 1;
7523: x_msg_data := SQLERRM;
7524: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_CONTROL_ITEMS_UTILS'
7525: ,p_procedure_name => 'get_not_included');
7526:
7527: IF l_debug_mode = 'Y' THEN
7528: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 7634: l_msg_count := FND_MSG_PUB.count_msg;

7630: pa_debug.reset_curr_function;
7631: RETURN l_impact_type_code;
7632: EXCEPTION
7633: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7634: l_msg_count := FND_MSG_PUB.count_msg;
7635:
7636: IF l_msg_count = 1 THEN
7637: PA_INTERFACE_UTILS_PUB.get_messages
7638: (p_encoded => FND_API.G_TRUE

Line 7842: l_msg_count := FND_MSG_PUB.count_msg;

7838: pa_debug.reset_curr_function;
7839:
7840: EXCEPTION
7841: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7842: l_msg_count := FND_MSG_PUB.count_msg;
7843:
7844: IF l_msg_count = 1 and x_msg_data IS NULL THEN
7845: PA_INTERFACE_UTILS_PUB.get_messages
7846: (p_encoded => FND_API.G_TRUE

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

7868: IF c_vers_for_ci%ISOPEN THEN
7869: CLOSE c_vers_for_ci;
7870: END IF;
7871:
7872: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
7873: ,p_procedure_name => 'GET_CI_VERSIONS');
7874: IF P_PA_DEBUG_MODE = 'Y' THEN
7875: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
7876: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);

Line 8565: l_msg_count := FND_MSG_PUB.count_msg;

8561: pa_debug.reset_curr_function;
8562:
8563: EXCEPTION
8564: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8565: l_msg_count := FND_MSG_PUB.count_msg;
8566:
8567: IF c_plan_types_attached%ISOPEN THEN
8568: CLOSE c_plan_types_attached;
8569: END IF;

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

8593: IF c_plan_types_attached%ISOPEN THEN
8594: CLOSE c_plan_types_attached;
8595: END IF;
8596:
8597: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
8598: ,p_procedure_name => 'GET_PLAN_TYPES_FOR_IMPL');
8599: IF l_DEBUG_MODE = 'Y' THEN
8600: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
8601: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);

Line 9219: l_msg_count := FND_MSG_PUB.count_msg;

9215: pa_debug.reset_curr_function;
9216:
9217: EXCEPTION
9218: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9219: l_msg_count := FND_MSG_PUB.count_msg;
9220:
9221: IF l_msg_count = 1 and x_msg_data IS NULL THEN
9222: PA_INTERFACE_UTILS_PUB.get_messages
9223: (p_encoded => FND_API.G_TRUE

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

9240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9241: x_msg_count := 1;
9242: x_msg_data := SQLERRM;
9243:
9244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
9245: ,p_procedure_name => 'GET_IMPL_DETAILS');
9246: IF P_PA_DEBUG_MODE = 'Y' THEN
9247: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
9248: pa_debug.write(l_mod_name,pa_debug.g_err_stage,l_debug_level5);

Line 9661: l_msg_count := FND_MSG_PUB.count_msg;

9657:
9658: EXCEPTION
9659:
9660: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9661: l_msg_count := FND_MSG_PUB.count_msg;
9662: IF l_msg_count = 1 THEN
9663: PA_INTERFACE_UTILS_PUB.get_messages
9664: (p_encoded => FND_API.G_TRUE
9665: ,p_msg_index => 1

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

9681:
9682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9683: x_msg_count := 1;
9684: x_msg_data := SQLERRM;
9685: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
9686: ,p_procedure_name => 'get_dtls_for_view_fin_imp_pg');
9687:
9688: IF l_debug_mode = 'Y' THEN
9689: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9807: l_msg_count := FND_MSG_PUB.count_msg;

9803: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9804:
9805: CLOSE c_app_cw_ver_csr; -- Added for bug#6405905
9806:
9807: l_msg_count := FND_MSG_PUB.count_msg;
9808: IF l_msg_count = 1 THEN
9809: PA_INTERFACE_UTILS_PUB.get_messages
9810: (p_encoded => FND_API.G_TRUE
9811: ,p_msg_index => 1

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

9829:
9830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9831: x_msg_count := 1;
9832: x_msg_data := SQLERRM;
9833: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
9834: ,p_procedure_name => 'get_app_cw_ver_ids_for_proj');
9835:
9836: IF l_debug_mode = 'Y' THEN
9837: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9967: l_msg_count := FND_MSG_PUB.count_msg;

9963: RETURN l_impl_agr_rev_amt;
9964:
9965: EXCEPTION
9966: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
9967: l_msg_count := FND_MSG_PUB.count_msg;
9968: IF l_msg_count = 1 THEN
9969: PA_INTERFACE_UTILS_PUB.get_messages
9970: (p_encoded => FND_API.G_TRUE
9971: ,p_msg_index => 1

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

9976: END IF;
9977: pa_debug.reset_curr_function;
9978:
9979: WHEN OTHERS THEN
9980: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
9981: ,p_procedure_name => 'get_app_cw_ver_ids_for_proj');
9982:
9983: IF l_debug_mode = 'Y' THEN
9984: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10121: l_msg_count := FND_MSG_PUB.count_msg;

10117: End;
10118:
10119: EXCEPTION
10120: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10121: l_msg_count := FND_MSG_PUB.count_msg;
10122: IF l_msg_count = 1 THEN
10123: PA_INTERFACE_UTILS_PUB.get_messages
10124: (p_encoded => FND_API.G_TRUE
10125: ,p_msg_index => 1

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

10141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10142: x_msg_count := 1;
10143: x_msg_data := SQLERRM;
10144:
10145: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'Pa_Fp_Control_Items_Utils'
10146: ,p_procedure_name => 'get_txn_curr_code_of_ci_ver');
10147:
10148: IF P_PA_DEBUG_MODE = 'Y' THEN
10149: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10237: l_msg_count := FND_MSG_PUB.count_msg;

10233: RETURN is_delete_allowed;
10234:
10235: EXCEPTION
10236: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10237: l_msg_count := FND_MSG_PUB.count_msg;
10238: IF l_msg_count = 1 THEN
10239: PA_INTERFACE_UTILS_PUB.get_messages
10240: (p_encoded => FND_API.G_TRUE
10241: ,p_msg_index => 1

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

10245: ,p_msg_index_out => l_msg_index_out);
10246: END IF;
10247: pa_debug.reset_curr_function;
10248: WHEN OTHERS THEN
10249: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PAFPCIUB'
10250: ,p_procedure_name => 'validate_fp_ci_type_delete');
10251:
10252: IF l_debug_mode = 'Y' THEN
10253: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;