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

Line 126: FND_MSG_PUB.add_exc_msg

122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
123: x_msg_count := 1;
124: x_msg_data := SQLERRM;
125:
126: FND_MSG_PUB.add_exc_msg
127: ( p_pkg_name => 'PA_BUDGET_PUB'
128: ,p_procedure_name => 'VALID_RATE_TYPE'
129: ,p_error_text => sqlerrm);
130:

Line 476: FND_MSG_PUB.initialize;

472: -- this point.
473: IF FND_API.TO_BOOLEAN( p_init_msg_list )
474: THEN
475:
476: FND_MSG_PUB.initialize;
477:
478: END IF;
479:
480:

Line 527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

523: --product_code is mandatory
524: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
525: OR p_pm_product_code IS NULL
526: THEN
527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
528: THEN
529: pa_interface_utils_pub.map_new_amg_msg
530: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
531: ,p_msg_attribute => 'CHANGE'

Line 539: --dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);

535: ,p_attribute2 => ''
536: ,p_attribute3 => ''
537: ,p_attribute4 => ''
538: ,p_attribute5 => '');
539: --dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
540: --dbms_output.put_line('added msg to stack');
541: --dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);
542: IF l_debug_mode = 'Y' THEN
543: pa_debug.g_err_stage:= 'PM Product code is missing';

Line 541: --dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);

537: ,p_attribute4 => ''
538: ,p_attribute5 => '');
539: --dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
540: --dbms_output.put_line('added msg to stack');
541: --dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);
542: IF l_debug_mode = 'Y' THEN
543: pa_debug.g_err_stage:= 'PM Product code is missing';
544: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
545: END IF;

Line 564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

560: FETCH p_product_code_csr INTO l_pm_product_code;
561: CLOSE p_product_code_csr;
562: IF l_pm_product_code <> 'X'
563: THEN
564: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
565: THEN
566: pa_interface_utils_pub.map_new_amg_msg
567: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
568: ,p_msg_attribute => 'CHANGE'

Line 792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

788: x_budget_amount_code := l_budget_amount_code; -- Added for bug 4224464
789:
790: IF l_budget_amount_code_csr%NOTFOUND
791: THEN
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
793: THEN
794: pa_interface_utils_pub.map_new_amg_msg
795: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
796: ,p_msg_attribute => 'CHANGE'

Line 825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

821:
822: IF l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C THEN
823:
824: IF NVL(l_allow_cost_budget_entry_flag,'N') = 'N' THEN
825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
826: THEN
827: PA_UTILS.ADD_MESSAGE
828: (p_app_short_name => 'PA',
829: p_msg_name => 'PA_COST_BUDGET_NOT_ALLOWED',

Line 848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

844:
845: ELSIF l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_R THEN
846:
847: IF NVL(l_allow_rev_budget_entry_flag,'N') = 'N' THEN
848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
849: THEN
850: PA_UTILS.ADD_MESSAGE
851: (p_app_short_name => 'PA',
852: p_msg_name => 'PA_REV_BUDGET_NOT_ALLOWED',

Line 875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

871:
872: --Added this for bug#4460139
873: --Verify that the budget is not of type FORECASTING_BUDGET_TYPE
874: IF p_budget_type_code='FORECASTING_BUDGET_TYPE' THEN
875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
876: THEN
877: PA_UTILS.add_message
878: (p_app_short_name => 'PA',
879: p_msg_name => 'PA_FP_CANT_EDIT_FCST_BUD_TYPE');

Line 930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

926: END IF;
927:
928: IF (nvl(l_fck_req_flag,'N') = 'Y')
929: THEN
930: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
931: THEN
932: pa_interface_utils_pub.map_new_amg_msg
933: ( p_old_message_code => 'PA_BC_BGT_TYPE_IS_BAD_AMG'
934: ,p_msg_attribute => 'CHANGE'

Line 957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

953: IF p_entry_method_code IS NULL
954: OR p_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
955: THEN
956:
957: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
958: THEN
959: pa_interface_utils_pub.map_new_amg_msg
960: ( p_old_message_code => 'PA_ENTRY_METHOD_IS_MISSING'
961: ,p_msg_attribute => 'CHANGE'

Line 989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

985:
986: IF l_budget_entry_method_csr%NOTFOUND
987: THEN
988:
989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
990: THEN
991: pa_interface_utils_pub.map_new_amg_msg
992: ( p_old_message_code => 'PA_ENTRY_METHOD_IS_INVALID'
993: ,p_msg_attribute => 'CHANGE'

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

1144: ELSE -- There is no valid resource list id
1145: x_return_status := FND_API.G_RET_STS_ERROR; --AMG UT2
1146: l_any_error_occurred_flag := 'Y';
1147:
1148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1149: pa_interface_utils_pub.map_new_amg_msg
1150: ( p_old_message_code => 'PA_RESOURCE_LIST_IS_MISSING'
1151: ,p_msg_attribute => 'CHANGE'
1152: ,p_resize_flag => 'Y'

Line 1329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1325:
1326: --if working bugdet is submitted no new working budget can be created
1327: IF l_budget_status_code = 'S'
1328: THEN
1329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1330: THEN
1331: pa_interface_utils_pub.map_new_amg_msg
1332: ( p_old_message_code => 'PA_BUDGET_IS_SUBMITTED'
1333: ,p_msg_attribute => 'CHANGE'

Line 2540: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2536: END IF;
2537: IF l_budget_change_reason_csr%NOTFOUND THEN
2538: CLOSE l_budget_change_reason_csr;
2539:
2540: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2541: THEN
2542: pa_interface_utils_pub.map_new_amg_msg
2543: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
2544: ,p_msg_attribute => 'CHANGE'

Line 2577: --dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);

2573: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2574: END IF;
2575:
2576: -- Stop further processing if any errors are reported
2577: --dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
2578: IF(l_any_error_occurred_flag='Y') THEN
2579: IF(l_debug_mode='Y') THEN
2580: pa_debug.g_err_stage := 'About to display all the messages';
2581: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 2599: l_msg_count := FND_MSG_PUB.count_msg;

2595: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: END IF;
2598:
2599: l_msg_count := FND_MSG_PUB.count_msg;
2600: --dbms_output.put_line('MSG count in the stack ' || l_msg_count);
2601:
2602: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
2603: PA_INTERFACE_UTILS_PUB.get_messages

Line 2628: FND_MSG_PUB.add_exc_msg

2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: x_msg_count := 1;
2626: x_msg_data := SQLERRM;
2627:
2628: FND_MSG_PUB.add_exc_msg
2629: ( p_pkg_name => 'PA_BUDGET_PVT'
2630: ,p_procedure_name => 'VALIDATE_HEADER_INFO'
2631: ,p_error_text => sqlerrm);
2632:

Line 2879: FND_MSG_PUB.initialize;

2875:
2876: -- Initialize the message table if requested.
2877: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2878: THEN
2879: FND_MSG_PUB.initialize;
2880: END IF;
2881:
2882: IF l_debug_mode = 'Y' THEN
2883: pa_debug.g_err_stage:= 'Validating input parameters';

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

2923: -- Both Budget Type Code and Fin Plan Type Id should not be null
2924: IF (px_budget_type_code IS NULL AND px_fin_plan_type_name IS NULL AND
2925: px_fin_plan_type_id IS NULL) THEN
2926:
2927: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2928: PA_UTILS.ADD_MESSAGE
2929: (p_app_short_name => 'PA',
2930: p_msg_name => 'PA_BUDGET_FP_BOTH_MISSING');
2931: END IF;

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

2943:
2944: IF ((px_budget_type_code IS NOT NULL) AND
2945: (px_fin_plan_type_name IS NOT NULL OR px_fin_plan_type_id IS NOT NULL)) THEN
2946:
2947: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2948: PA_UTILS.ADD_MESSAGE
2949: (p_app_short_name => 'PA',
2950: p_msg_name => 'PA_BUDGET_FP_BOTH_NOT_NULL');
2951: END IF;

Line 2966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2962: --product_code is mandatory
2963: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2964: OR p_pm_product_code IS NULL
2965: THEN
2966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2967: THEN
2968: PA_INTERFACE_UTILS_PUB.map_new_amg_msg
2969: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
2970: ,p_msg_attribute => 'CHANGE'

Line 2994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

2990: FETCH p_product_code_csr INTO l_pm_product_code;
2991: CLOSE p_product_code_csr;
2992: IF l_pm_product_code <> 'X'
2993: THEN
2994: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2995: THEN
2996: pa_interface_utils_pub.map_new_amg_msg
2997: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
2998: ,p_msg_attribute => 'CHANGE'

Line 3107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3103:
3104: IF l_budget_amount_code_csr%NOTFOUND
3105: THEN
3106: CLOSE l_budget_amount_code_csr;
3107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3108: THEN
3109: pa_interface_utils_pub.map_new_amg_msg
3110: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
3111: ,p_msg_attribute => 'CHANGE'

Line 3135: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3131:
3132:
3133: --Verify that the budget is not of type FORECASTING_BUDGET_TYPE
3134: IF px_budget_type_code='FORECASTING_BUDGET_TYPE' THEN
3135: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3136: THEN
3137: PA_UTILS.add_message
3138: (p_app_short_name => 'PA',
3139: p_msg_name => 'PA_FP_CANT_EDIT_FCST_BUD_TYPE');

Line 3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3227: END IF;
3228:
3229:
3230: /* Since PA.M, this rule no longer applies for bugetary control
3231: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3232: THEN
3233: pa_interface_utils_pub.map_new_amg_msg
3234: ( p_old_message_code => 'PA_BC_BGT_TYPE_IS_BAD_AMG'
3235: ,p_msg_attribute => 'CHANGE'

Line 3266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3262: , x_resource_list_id;
3263:
3264: IF l_budget_version_csr%NOTFOUND
3265: THEN
3266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3267: THEN
3268: pa_interface_utils_pub.map_new_amg_msg
3269: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
3270: ,p_msg_attribute => 'CHANGE'

Line 3292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3288: IF x_budget_entry_method_code IS NULL
3289: OR x_budget_entry_method_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3290: THEN
3291:
3292: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3293: THEN
3294: pa_interface_utils_pub.map_new_amg_msg
3295: (p_old_message_code => 'PA_ENTRY_METHOD_IS_MISSING'
3296: ,p_msg_attribute => 'CHANGE'

Line 3324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3320:
3321: IF l_budget_entry_method_csr%NOTFOUND
3322: THEN
3323: CLOSE l_budget_entry_method_csr;
3324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3325: THEN
3326: pa_interface_utils_pub.map_new_amg_msg
3327: ( p_old_message_code => 'PA_ENTRY_METHOD_IS_INVALID'
3328: ,p_msg_attribute => 'CHANGE'

Line 3379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3375: CLOSE l_use_for_wp_csr;
3376:
3377: IF l_dummy = 1
3378: THEN
3379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3380: THEN
3381: PA_UTILS.add_message
3382: (p_app_short_name => 'PA',
3383: p_msg_name => 'PA_FP_CANT_EDIT_WP_DATA');

Line 3416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3412: END IF;
3413:
3414: --if the budget version belongs to an org forecasting project then throw an error
3415: IF px_version_type = 'ORG_FORECAST' THEN
3416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3417: THEN
3418: PA_UTILS.add_message
3419: (p_app_short_name => 'PA',
3420: p_msg_name => 'PA_FP_ORG_FCST_PLAN_TYPE');

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

3483: --If budget version id can't be found throw appropriate error message
3484: IF x_budget_version_id IS NULL OR x_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3485: THEN
3486: --Throw appropriate error message
3487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3488: PA_UTILS.ADD_MESSAGE
3489: (p_app_short_name => 'PA',
3490: p_msg_name => 'PA_FP_NO_WORKING_VERSION',
3491: p_token1 => 'PROJECT',

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

3541: --Control will never really enter this IF block since this check is
3542: --already made inside pa_fin_plan_utils.get_version_type before
3543: --control reaches here
3544: IF (l_proj_fp_options_csr%NOTFOUND) THEN
3545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3546: PA_UTILS.ADD_MESSAGE
3547: (p_app_short_name => 'PA',
3548: p_msg_name => 'PA_FP_NO_PLAN_TYPE_OPTION',
3549: p_token1 => 'PROJECT',

Line 3584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3580:
3581: IF l_budget_change_reason_csr%NOTFOUND THEN
3582: CLOSE l_budget_change_reason_csr;
3583:
3584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3585: THEN
3586: pa_interface_utils_pub.map_new_amg_msg
3587: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
3588: ,p_msg_attribute => 'CHANGE'

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

3628: pa_debug.g_err_stage := 'Auto baselining enabled for the project';
3629: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3630: END IF;
3631:
3632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3633: PA_UTILS.ADD_MESSAGE(
3634: p_app_short_name => 'PA'
3635: ,p_msg_name => 'PA_FP_AB_AR_VER_NON_EDITABLE'
3636: ,p_token1 => 'PROJECT'

Line 3909: x_msg_count := FND_MSG_PUB.count_msg;

3905: OR x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3906: x_return_status := FND_API.G_RET_STS_ERROR;
3907: END IF;
3908:
3909: x_msg_count := FND_MSG_PUB.count_msg;
3910:
3911: IF x_msg_count = 1 AND x_msg_data IS NULL THEN
3912: PA_INTERFACE_UTILS_PUB.get_messages
3913: (p_encoded => FND_API.G_TRUE,

Line 3934: FND_MSG_PUB.count_and_get

3930: THEN
3931:
3932: x_return_status := FND_API.G_RET_STS_ERROR;
3933:
3934: FND_MSG_PUB.count_and_get
3935: ( p_count => x_msg_count ,
3936: p_data => x_msg_data );
3937:
3938: IF ( l_debug_mode = 'Y' ) THEN

Line 3947: FND_MSG_PUB.count_and_get

3943: THEN
3944:
3945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3946:
3947: FND_MSG_PUB.count_and_get
3948: ( p_count => x_msg_count ,
3949: p_data => x_msg_data );
3950:
3951: IF ( l_debug_mode = 'Y' ) THEN

Line 3960: FND_MSG_PUB.add_exc_msg

3956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3957: x_msg_count := 1;
3958: x_msg_data := SQLERRM;
3959:
3960: FND_MSG_PUB.add_exc_msg
3961: ( p_pkg_name => 'PA_BUDGET_PVT'
3962: ,p_procedure_name => 'VALIDATE_HEADER_INFO'
3963: ,p_error_text => sqlerrm);
3964:

Line 4146: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4142: ,p_resource_list_id );
4143: FETCH l_resource_csr INTO l_unit_of_measure, l_track_as_labor_flag;
4144: IF l_resource_csr%NOTFOUND
4145: THEN
4146: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4147: THEN
4148: pa_interface_utils_pub.map_new_amg_msg
4149: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
4150: ,p_msg_attribute => 'CHANGE'

Line 4178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4174: --product_code is mandatory : this validation was missing altogether
4175: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4176: OR p_pm_product_code IS NULL
4177: THEN
4178: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4179: THEN
4180: pa_interface_utils_pub.map_new_amg_msg
4181: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4182: ,p_msg_attribute => 'CHANGE'

Line 4190: dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);

4186: ,p_attribute2 => ''
4187: ,p_attribute3 => ''
4188: ,p_attribute4 => ''
4189: ,p_attribute5 => '');
4190: dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
4191: dbms_output.put_line('added msg to stack');
4192: dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);
4193: END IF;
4194: p_return_status := FND_API.G_RET_STS_ERROR;

Line 4192: dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);

4188: ,p_attribute4 => ''
4189: ,p_attribute5 => '');
4190: dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
4191: dbms_output.put_line('added msg to stack');
4192: dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);
4193: END IF;
4194: p_return_status := FND_API.G_RET_STS_ERROR;
4195: END IF;
4196: -- bug 3062294

Line 4635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4631:
4632: IF l_err_code > 0
4633: then
4634:
4635: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4636: THEN
4637:
4638: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4639: THEN

Line 4672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4668: THEN
4669:
4670: IF l_err_code = -1 --special handling of duplicate line error
4671: THEN
4672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4673: THEN
4674: pa_interface_utils_pub.map_new_amg_msg
4675: ( p_old_message_code => 'PA_BUDGET_LINE_ALREADY_EXISTS'
4676: ,p_msg_attribute => 'CHANGE'

Line 4688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4684: END IF;
4685: RAISE FND_API.G_EXC_ERROR;
4686: ELSE
4687:
4688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4689: THEN
4690:
4691: FND_MSG_PUB.add_exc_msg
4692: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 4691: FND_MSG_PUB.add_exc_msg

4687:
4688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4689: THEN
4690:
4691: FND_MSG_PUB.add_exc_msg
4692: ( p_pkg_name => 'PA_BUDGET_UTILS'
4693: , p_procedure_name => 'CREATE_LINE'
4694: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4695:

Line 4725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4721: ROLLBACK TO insert_budget_line_pvt;
4722:
4723: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4724:
4725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4726: THEN
4727: FND_MSG_PUB.add_exc_msg
4728: ( p_pkg_name => G_PKG_NAME
4729: , p_procedure_name => l_api_name );

Line 4727: FND_MSG_PUB.add_exc_msg

4723: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4724:
4725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4726: THEN
4727: FND_MSG_PUB.add_exc_msg
4728: ( p_pkg_name => G_PKG_NAME
4729: , p_procedure_name => l_api_name );
4730:
4731: END IF;

Line 5479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5475: EXCEPTION
5476: WHEN OTHERS
5477: THEN
5478:
5479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5480: THEN
5481: FND_MSG_PUB.add_exc_msg
5482: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5483: , p_procedure_name => 'DELETE_ROW'

Line 5481: FND_MSG_PUB.add_exc_msg

5477: THEN
5478:
5479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5480: THEN
5481: FND_MSG_PUB.add_exc_msg
5482: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5483: , p_procedure_name => 'DELETE_ROW'
5484: , p_error_text => SQLCODE );
5485: END IF;

Line 5515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5511: ROLLBACK TO update_budget_line_sql_pvt;
5512:
5513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5514:
5515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5516: THEN
5517: FND_MSG_PUB.add_exc_msg
5518: ( p_pkg_name => G_PKG_NAME
5519: , p_procedure_name => l_api_name );

Line 5517: FND_MSG_PUB.add_exc_msg

5513: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5514:
5515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5516: THEN
5517: FND_MSG_PUB.add_exc_msg
5518: ( p_pkg_name => G_PKG_NAME
5519: , p_procedure_name => l_api_name );
5520:
5521: END IF;

Line 6400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6396: FETCH p_product_code_csr INTO l_pm_product_code;
6397: CLOSE p_product_code_csr;
6398: IF l_pm_product_code <> 'X'
6399: THEN
6400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6401: THEN
6402: pa_interface_utils_pub.map_new_amg_msg
6403: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
6404: ,p_msg_attribute => 'CHANGE'

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

6563: IF(p_budget_type_code IS NOT NULL) THEN --Budget Model
6564:
6565: IF p_entry_level_code = 'T' THEN -- then check whether it is top task
6566: IF px_budget_lines_in(i).pa_task_id <> pa_task_utils.get_top_task_id( px_budget_lines_in(i).pa_task_id ) THEN
6567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6568: pa_interface_utils_pub.map_new_amg_msg
6569: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6570: ,p_msg_attribute => 'CHANGE'
6571: ,p_resize_flag => 'N'

Line 6591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6587: THEN
6588: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,
6589: px_budget_lines_in(i).pa_task_id);
6590: IF l_return_status_task <> 0 THEN
6591: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6592: THEN
6593: pa_interface_utils_pub.map_new_amg_msg
6594: ( p_old_message_code => 'PA_TASK_IS_NOT_LOWEST'
6595: ,p_msg_attribute => 'CHANGE'

Line 6629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

6625: ELSE
6626: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
6627: , px_budget_lines_in(i).pa_task_id);
6628: IF l_return_status_task <> 0 THEN
6629: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6630: THEN
6631: pa_interface_utils_pub.map_new_amg_msg
6632: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP_OR_LOWEST'
6633: ,p_msg_attribute => 'CHANGE'

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

6720: l_webadi_err_txn_curr_tbl(l_webadi_err_txn_curr_tbl.COUNT) := px_budget_lines_in(i).txn_currency_code;
6721: l_webadi_err_amt_type_tbl.extend(1);
6722: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
6723: ELSE
6724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6725: pa_interface_utils_pub.map_new_amg_msg
6726: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6727: ,p_msg_attribute => 'CHANGE'
6728: ,p_resize_flag => 'N'

Line 7075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

7071: ,p_resource_list_id );
7072: FETCH l_resource_csr INTO l_unit_of_measure, l_track_as_labor_flag, l_rlm_migration_code;
7073: IF l_resource_csr%NOTFOUND THEN
7074: l_context_info := p_budget_type_code;
7075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7076: THEN
7077: pa_interface_utils_pub.map_new_amg_msg
7078: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7079: ,p_msg_attribute => 'CHANGE'

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

7125: l_webadi_err_txn_curr_tbl(l_webadi_err_txn_curr_tbl.COUNT) := px_budget_lines_in(i).txn_currency_code;
7126: l_webadi_err_amt_type_tbl.extend(1);
7127: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
7128: ELSE
7129: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7130: pa_interface_utils_pub.map_new_amg_msg
7131: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7132: ,p_msg_attribute => 'CHANGE'
7133: ,p_resize_flag => 'N'

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

7279: ELSE
7280: l_context_info := p_budget_type_code;
7281: END IF;
7282:
7283: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7284: pa_interface_utils_pub.map_new_amg_msg
7285: ( p_old_message_code => 'PA_RESOURCE_IS_MISSING'
7286: ,p_msg_attribute => 'CHANGE'
7287: ,p_resize_flag => 'N'

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

7725: ELSE
7726:
7727: l_context_info := p_budget_type_code;
7728: END IF;
7729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7730: PA_UTILS.add_message
7731: (p_app_short_name => 'PA',
7732: p_msg_name => 'PA_CHANGE_REASON_INVALID_AMG',
7733: p_token1 => 'PROJECT',

Line 8362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

8358:
8359: IF budget_version_info_cur%NOTFOUND
8360: THEN
8361: l_any_error_occurred_flag := 'Y';
8362: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8363: THEN
8364: PA_UTILS.add_message
8365: (p_app_short_name => 'PA'
8366: ,p_msg_name => 'PA_FP_NO_WORKING_VERSION'

Line 8392: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

8388: p_time_phased_code IS NOT NULL AND
8389: p_time_phased_code <> 'N')
8390: THEN
8391: l_any_error_occurred_flag := 'Y';
8392: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8393: THEN
8394: PA_UTILS.add_message
8395: (p_app_short_name => 'PA'
8396: ,p_msg_name => 'PA_FP_FCST_ACTUALS_AMG'

Line 8485: l_msg_count := FND_MSG_PUB.count_msg;

8481: x_return_status := FND_API.G_RET_STS_ERROR;
8482:
8483: END IF;
8484:
8485: l_msg_count := FND_MSG_PUB.count_msg;
8486:
8487: IF l_msg_count = 1 and x_msg_data IS NULL THEN
8488: PA_INTERFACE_UTILS_PUB.get_messages
8489: (p_encoded => FND_API.G_TRUE

Line 8509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

8505: WHEN OTHERS THEN
8506:
8507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8508:
8509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8510:
8511: THEN
8512: FND_MSG_PUB.add_exc_msg
8513: ( p_pkg_name => G_PKG_NAME

Line 8512: FND_MSG_PUB.add_exc_msg

8508:
8509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8510:
8511: THEN
8512: FND_MSG_PUB.add_exc_msg
8513: ( p_pkg_name => G_PKG_NAME
8514: , p_procedure_name => 'Validate_Budget_Lines' );
8515:
8516: END IF;

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

8590: ,x_return_status => l_return_status ) ;
8591:
8592: IF l_return_status ='U' THEN
8593:
8594: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8595:
8596: FND_MSG_PUB.add_exc_msg
8597: ( p_pkg_name => 'PA_BUDGET_PVT'
8598: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS' );

Line 8596: FND_MSG_PUB.add_exc_msg

8592: IF l_return_status ='U' THEN
8593:
8594: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8595:
8596: FND_MSG_PUB.add_exc_msg
8597: ( p_pkg_name => 'PA_BUDGET_PVT'
8598: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS' );
8599:
8600: END IF;

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

8602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8603:
8604: END IF;
8605:
8606: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8607:
8608: IF nvl(l_fin_plan_line_id_tab.LAST,0) > 0 THEN /* Bug # 3588604 */
8609:
8610: FOR I in l_fin_plan_line_id_tab.FIRST .. l_fin_plan_line_id_tab.LAST LOOP

Line 8747: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'

8743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8744: x_msg_count := 1;
8745: x_msg_data := SQLERRM;
8746:
8747: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'
8748: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS');
8749:
8750: IF l_debug_mode = 'Y' THEN
8751: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

Line 8755: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count

8751: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
8752: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8753: pa_debug.reset_err_stack;
8754: END IF;
8755: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
8756: ,p_data => x_msg_data );
8757: RAISE;
8758:
8759:

Line 8857: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'

8853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8854: x_msg_count := 1;
8855: x_msg_data := SQLERRM;
8856:
8857: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'
8858: ,p_procedure_name => 'GET_LATEST_BC_YEAR');
8859: IF l_debug_mode = 'Y' THEN
8860: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
8861: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 8864: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count

8860: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
8861: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8862: pa_debug.reset_err_stack;
8863: END IF;
8864: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
8865: ,p_data => x_msg_data );
8866: RAISE;
8867:
8868: