DBA Data[Home] [Help]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3379: CLOSE l_use_for_wp_csr;
3380:
3381: IF l_dummy = 1
3382: THEN
3383: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3384: THEN
3385: PA_UTILS.add_message
3386: (p_app_short_name => 'PA',
3387: p_msg_name => 'PA_FP_CANT_EDIT_WP_DATA');

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

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

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

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

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

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

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

3584:
3585: IF l_budget_change_reason_csr%NOTFOUND THEN
3586: CLOSE l_budget_change_reason_csr;
3587:
3588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3589: THEN
3590: pa_interface_utils_pub.map_new_amg_msg
3591: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
3592: ,p_msg_attribute => 'CHANGE'

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

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

Line 3913: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 3938: FND_MSG_PUB.count_and_get

3934: THEN
3935:
3936: x_return_status := FND_API.G_RET_STS_ERROR;
3937:
3938: FND_MSG_PUB.count_and_get
3939: ( p_count => x_msg_count ,
3940: p_data => x_msg_data );
3941:
3942: IF ( l_debug_mode = 'Y' ) THEN

Line 3951: FND_MSG_PUB.count_and_get

3947: THEN
3948:
3949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3950:
3951: FND_MSG_PUB.count_and_get
3952: ( p_count => x_msg_count ,
3953: p_data => x_msg_data );
3954:
3955: IF ( l_debug_mode = 'Y' ) THEN

Line 3964: FND_MSG_PUB.add_exc_msg

3960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3961: x_msg_count := 1;
3962: x_msg_data := SQLERRM;
3963:
3964: FND_MSG_PUB.add_exc_msg
3965: ( p_pkg_name => 'PA_BUDGET_PVT'
3966: ,p_procedure_name => 'VALIDATE_HEADER_INFO'
3967: ,p_error_text => sqlerrm);
3968:

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

4148: ,p_resource_list_id );
4149: FETCH l_resource_csr INTO l_unit_of_measure, l_track_as_labor_flag;
4150: IF l_resource_csr%NOTFOUND
4151: THEN
4152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4153: THEN
4154: pa_interface_utils_pub.map_new_amg_msg
4155: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
4156: ,p_msg_attribute => 'CHANGE'

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

4180: --product_code is mandatory : this validation was missing altogether
4181: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4182: OR p_pm_product_code IS NULL
4183: THEN
4184: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4185: THEN
4186: pa_interface_utils_pub.map_new_amg_msg
4187: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
4188: ,p_msg_attribute => 'CHANGE'

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

4192: ,p_attribute2 => ''
4193: ,p_attribute3 => ''
4194: ,p_attribute4 => ''
4195: ,p_attribute5 => '');
4196: dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
4197: dbms_output.put_line('added msg to stack');
4198: dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);
4199: END IF;
4200: p_return_status := FND_API.G_RET_STS_ERROR;

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

4194: ,p_attribute4 => ''
4195: ,p_attribute5 => '');
4196: dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
4197: dbms_output.put_line('added msg to stack');
4198: dbms_output.put_line('MSG count in the stack 2 ' || FND_MSG_PUB.count_msg);
4199: END IF;
4200: p_return_status := FND_API.G_RET_STS_ERROR;
4201: END IF;
4202: -- bug 3062294

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

4648:
4649: IF l_err_code > 0
4650: then
4651:
4652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4653: THEN
4654:
4655: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4656: THEN

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

4685: THEN
4686:
4687: IF l_err_code = -1 --special handling of duplicate line error
4688: THEN
4689: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4690: THEN
4691: pa_interface_utils_pub.map_new_amg_msg
4692: ( p_old_message_code => 'PA_BUDGET_LINE_ALREADY_EXISTS'
4693: ,p_msg_attribute => 'CHANGE'

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

4701: END IF;
4702: RAISE FND_API.G_EXC_ERROR;
4703: ELSE
4704:
4705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4706: THEN
4707:
4708: FND_MSG_PUB.add_exc_msg
4709: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 4708: FND_MSG_PUB.add_exc_msg

4704:
4705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4706: THEN
4707:
4708: FND_MSG_PUB.add_exc_msg
4709: ( p_pkg_name => 'PA_BUDGET_UTILS'
4710: , p_procedure_name => 'CREATE_LINE'
4711: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4712:

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

4738: ROLLBACK TO insert_budget_line_pvt;
4739:
4740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4741:
4742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4743: THEN
4744: FND_MSG_PUB.add_exc_msg
4745: ( p_pkg_name => G_PKG_NAME
4746: , p_procedure_name => l_api_name );

Line 4744: FND_MSG_PUB.add_exc_msg

4740: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4741:
4742: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4743: THEN
4744: FND_MSG_PUB.add_exc_msg
4745: ( p_pkg_name => G_PKG_NAME
4746: , p_procedure_name => l_api_name );
4747:
4748: END IF;

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

5492: EXCEPTION
5493: WHEN OTHERS
5494: THEN
5495:
5496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5497: THEN
5498: FND_MSG_PUB.add_exc_msg
5499: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5500: , p_procedure_name => 'DELETE_ROW'

Line 5498: FND_MSG_PUB.add_exc_msg

5494: THEN
5495:
5496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5497: THEN
5498: FND_MSG_PUB.add_exc_msg
5499: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5500: , p_procedure_name => 'DELETE_ROW'
5501: , p_error_text => SQLCODE );
5502: END IF;

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

5528: ROLLBACK TO update_budget_line_sql_pvt;
5529:
5530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5531:
5532: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5533: THEN
5534: FND_MSG_PUB.add_exc_msg
5535: ( p_pkg_name => G_PKG_NAME
5536: , p_procedure_name => l_api_name );

Line 5534: FND_MSG_PUB.add_exc_msg

5530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5531:
5532: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5533: THEN
5534: FND_MSG_PUB.add_exc_msg
5535: ( p_pkg_name => G_PKG_NAME
5536: , p_procedure_name => l_api_name );
5537:
5538: END IF;

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

6423: FETCH p_product_code_csr INTO l_pm_product_code;
6424: CLOSE p_product_code_csr;
6425: IF l_pm_product_code <> 'X'
6426: THEN
6427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6428: THEN
6429: pa_interface_utils_pub.map_new_amg_msg
6430: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
6431: ,p_msg_attribute => 'CHANGE'

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

6592: IF(p_budget_type_code IS NOT NULL) THEN --Budget Model
6593:
6594: IF p_entry_level_code = 'T' THEN -- then check whether it is top task
6595: 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
6596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6597: pa_interface_utils_pub.map_new_amg_msg
6598: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6599: ,p_msg_attribute => 'CHANGE'
6600: ,p_resize_flag => 'N'

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

6616: THEN
6617: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task,
6618: px_budget_lines_in(i).pa_task_id);
6619: IF l_return_status_task <> 0 THEN
6620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6621: THEN
6622: pa_interface_utils_pub.map_new_amg_msg
6623: ( p_old_message_code => 'PA_TASK_IS_NOT_LOWEST'
6624: ,p_msg_attribute => 'CHANGE'

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

6654: ELSE
6655: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
6656: , px_budget_lines_in(i).pa_task_id);
6657: IF l_return_status_task <> 0 THEN
6658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6659: THEN
6660: pa_interface_utils_pub.map_new_amg_msg
6661: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP_OR_LOWEST'
6662: ,p_msg_attribute => 'CHANGE'

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

6749: l_webadi_err_txn_curr_tbl(l_webadi_err_txn_curr_tbl.COUNT) := px_budget_lines_in(i).txn_currency_code;
6750: l_webadi_err_amt_type_tbl.extend(1);
6751: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
6752: ELSE
6753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6754: pa_interface_utils_pub.map_new_amg_msg
6755: ( p_old_message_code => 'PA_TASK_IS_NOT_TOP'
6756: ,p_msg_attribute => 'CHANGE'
6757: ,p_resize_flag => 'N'

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

7148: ,p_resource_list_id );
7149: FETCH l_resource_csr INTO l_unit_of_measure, l_track_as_labor_flag, l_rlm_migration_code;
7150: IF l_resource_csr%NOTFOUND THEN
7151: l_context_info := p_budget_type_code;
7152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7153: THEN
7154: pa_interface_utils_pub.map_new_amg_msg
7155: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7156: ,p_msg_attribute => 'CHANGE'

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

7202: l_webadi_err_txn_curr_tbl(l_webadi_err_txn_curr_tbl.COUNT) := px_budget_lines_in(i).txn_currency_code;
7203: l_webadi_err_amt_type_tbl.extend(1);
7204: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
7205: ELSE
7206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7207: pa_interface_utils_pub.map_new_amg_msg
7208: ( p_old_message_code => 'PA_LIST_MEMBER_INVALID'
7209: ,p_msg_attribute => 'CHANGE'
7210: ,p_resize_flag => 'N'

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

7356: ELSE
7357: l_context_info := p_budget_type_code;
7358: END IF;
7359:
7360: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7361: pa_interface_utils_pub.map_new_amg_msg
7362: ( p_old_message_code => 'PA_RESOURCE_IS_MISSING'
7363: ,p_msg_attribute => 'CHANGE'
7364: ,p_resize_flag => 'N'

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

7803: ELSE
7804:
7805: l_context_info := p_budget_type_code;
7806: END IF;
7807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7808: PA_UTILS.add_message
7809: (p_app_short_name => 'PA',
7810: p_msg_name => 'PA_CHANGE_REASON_INVALID_AMG',
7811: p_token1 => 'PROJECT',

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

8476:
8477: IF budget_version_info_cur%NOTFOUND
8478: THEN
8479: l_any_error_occurred_flag := 'Y';
8480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8481: THEN
8482: PA_UTILS.add_message
8483: (p_app_short_name => 'PA'
8484: ,p_msg_name => 'PA_FP_NO_WORKING_VERSION'

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

8506: p_time_phased_code IS NOT NULL AND
8507: p_time_phased_code <> 'N')
8508: THEN
8509: l_any_error_occurred_flag := 'Y';
8510: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8511: THEN
8512: PA_UTILS.add_message
8513: (p_app_short_name => 'PA'
8514: ,p_msg_name => 'PA_FP_FCST_ACTUALS_AMG'

Line 8603: l_msg_count := FND_MSG_PUB.count_msg;

8599: x_return_status := FND_API.G_RET_STS_ERROR;
8600:
8601: END IF;
8602:
8603: l_msg_count := FND_MSG_PUB.count_msg;
8604:
8605: IF l_msg_count = 1 and x_msg_data IS NULL THEN
8606: PA_INTERFACE_UTILS_PUB.get_messages
8607: (p_encoded => FND_API.G_TRUE

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

8623: WHEN OTHERS THEN
8624:
8625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8626:
8627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8628:
8629: THEN
8630: FND_MSG_PUB.add_exc_msg
8631: ( p_pkg_name => G_PKG_NAME

Line 8630: FND_MSG_PUB.add_exc_msg

8626:
8627: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8628:
8629: THEN
8630: FND_MSG_PUB.add_exc_msg
8631: ( p_pkg_name => G_PKG_NAME
8632: , p_procedure_name => 'Validate_Budget_Lines' );
8633:
8634: END IF;

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

8709: ,x_return_status => l_return_status ) ;
8710:
8711: IF l_return_status ='U' THEN
8712:
8713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8714:
8715: FND_MSG_PUB.add_exc_msg
8716: ( p_pkg_name => 'PA_BUDGET_PVT'
8717: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS' );

Line 8715: FND_MSG_PUB.add_exc_msg

8711: IF l_return_status ='U' THEN
8712:
8713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8714:
8715: FND_MSG_PUB.add_exc_msg
8716: ( p_pkg_name => 'PA_BUDGET_PVT'
8717: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS' );
8718:
8719: END IF;

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

8721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8722:
8723: END IF;
8724:
8725: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8726:
8727: IF nvl(l_fin_plan_line_id_tab.LAST,0) > 0 THEN /* Bug # 3588604 */
8728:
8729: FOR I in l_fin_plan_line_id_tab.FIRST .. l_fin_plan_line_id_tab.LAST LOOP

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

8897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8898: x_msg_count := 1;
8899: x_msg_data := SQLERRM;
8900:
8901: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'
8902: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS');
8903:
8904: IF l_debug_mode = 'Y' THEN
8905: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;

Line 8912: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count

8908: -- pa_debug.reset_err_stack;
8909: pa_debug.reset_curr_function;
8910:
8911: END IF;
8912: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
8913: ,p_data => x_msg_data );
8914: RAISE;
8915:
8916:

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

9010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9011: x_msg_count := 1;
9012: x_msg_data := SQLERRM;
9013:
9014: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'
9015: ,p_procedure_name => 'GET_LATEST_BC_YEAR');
9016: IF l_debug_mode = 'Y' THEN
9017: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
9018: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 9021: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count

9017: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
9018: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
9019: pa_debug.reset_err_stack;
9020: END IF;
9021: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
9022: ,p_data => x_msg_data );
9023: RAISE;
9024:
9025: