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

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

853: -----------
854:
855: IF l_err_code > 0
856: THEN
857: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
858: THEN
859:
860: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
861: THEN

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

893:
894: ELSIF l_err_code < 0
895: THEN
896:
897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899:
900: FND_MSG_PUB.add_exc_msg
901: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 900: FND_MSG_PUB.add_exc_msg

896:
897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
898: THEN
899:
900: FND_MSG_PUB.add_exc_msg
901: ( p_pkg_name => 'PA_BUDGET_UTILS'
902: , p_procedure_name => 'CREATE_DRAFT'
903: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
904:

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

2219:
2220: IF l_err_code > 0
2221: THEN
2222:
2223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2224: THEN
2225: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2226: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2227:

Line 2228: FND_MSG_PUB.add;

2224: THEN
2225: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2226: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2227:
2228: FND_MSG_PUB.add;
2229: END IF;
2230:
2231: IF l_debug_mode = 'Y' THEN
2232: pa_debug.g_err_stage := 'Error executing check_overlapping_dates';

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

2238:
2239: ELSIF l_err_code < 0
2240: THEN
2241:
2242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2243: THEN
2244:
2245: FND_MSG_PUB.add_exc_msg
2246: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

Line 2245: FND_MSG_PUB.add_exc_msg

2241:
2242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2243: THEN
2244:
2245: FND_MSG_PUB.add_exc_msg
2246: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
2247: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
2248: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2249:

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

2300:
2301: IF l_err_code > 0
2302: THEN
2303:
2304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2305: THEN
2306:
2307: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
2308: THEN

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

2341:
2342: ELSIF l_err_code < 0
2343: THEN
2344:
2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2346: THEN
2347:
2348: FND_MSG_PUB.add_exc_msg
2349: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 2348: FND_MSG_PUB.add_exc_msg

2344:
2345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2346: THEN
2347:
2348: FND_MSG_PUB.add_exc_msg
2349: ( p_pkg_name => 'PA_BUDGET_UTILS'
2350: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
2351: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2352:

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

2389:
2390:
2391: EXCEPTION
2392: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2393: -- dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
2394: ROLLBACK TO create_draft_budget_pub;
2395:
2396: IF p_return_status IS NULL OR
2397: p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2401: l_msg_count := FND_MSG_PUB.count_msg;

2397: p_return_status = FND_API.G_RET_STS_SUCCESS THEN
2398: p_return_status := FND_API.G_RET_STS_ERROR;
2399: END IF;
2400:
2401: l_msg_count := FND_MSG_PUB.count_msg;
2402: -- dbms_output.put_line('MSG count in the stack ' || l_msg_count);
2403:
2404: IF l_msg_count = 1 AND p_msg_data IS NULL THEN
2405: PA_INTERFACE_UTILS_PUB.get_messages

Line 2436: FND_MSG_PUB.Count_And_Get

2432: ROLLBACK TO create_draft_budget_pub;
2433:
2434: p_return_status := FND_API.G_RET_STS_ERROR;
2435:
2436: FND_MSG_PUB.Count_And_Get
2437: ( p_count => p_msg_count ,
2438: p_data => p_msg_data );
2439: --Changes for bug 3182963
2440: IF l_debug_mode = 'Y' THEN

Line 2454: FND_MSG_PUB.Count_And_Get

2450: ROLLBACK TO create_draft_budget_pub;
2451:
2452: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453:
2454: FND_MSG_PUB.Count_And_Get
2455: ( p_count => p_msg_count ,
2456: p_data => p_msg_data );
2457:
2458: --Changes for bug 3182963

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

2466: ROLLBACK TO create_draft_budget_pub;
2467:
2468: p_return_status := FND_API.G_RET_STS_ERROR;
2469:
2470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2471: THEN
2472: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');

Line 2479: FND_MSG_PUB.ADD;

2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2479: FND_MSG_PUB.ADD;
2480: END IF;
2481:
2482: FND_MSG_PUB.Count_And_Get
2483: ( p_count => p_msg_count ,

Line 2482: FND_MSG_PUB.Count_And_Get

2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2479: FND_MSG_PUB.ADD;
2480: END IF;
2481:
2482: FND_MSG_PUB.Count_And_Get
2483: ( p_count => p_msg_count ,
2484: p_data => p_msg_data );
2485:
2486: --Changes for bug 3182963

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

2497: ROLLBACK TO create_draft_budget_pub;
2498:
2499: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500:
2501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2502: THEN
2503: FND_MSG_PUB.add_exc_msg
2504: ( p_pkg_name => G_PKG_NAME
2505: , p_procedure_name => l_api_name );

Line 2503: FND_MSG_PUB.add_exc_msg

2499: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2500:
2501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2502: THEN
2503: FND_MSG_PUB.add_exc_msg
2504: ( p_pkg_name => G_PKG_NAME
2505: , p_procedure_name => l_api_name );
2506:
2507: END IF;

Line 2509: FND_MSG_PUB.Count_And_Get

2505: , p_procedure_name => l_api_name );
2506:
2507: END IF;
2508:
2509: FND_MSG_PUB.Count_And_Get
2510: ( p_count => p_msg_count ,
2511: p_data => p_msg_data );
2512:
2513: --Changes for bug 3182963

Line 2544: FND_MSG_PUB.Initialize;

2540: IS
2541:
2542: BEGIN
2543:
2544: FND_MSG_PUB.Initialize;
2545:
2546: -- Initialize global table and record types
2547:
2548: G_budget_lines_in_tbl.delete;

Line 2714: FND_MSG_PUB.initialize;

2710:
2711: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2712: THEN
2713:
2714: FND_MSG_PUB.initialize;
2715:
2716: END IF;
2717:
2718: -- Set API return status to success

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

2818: ROLLBACK TO load_budget_line_pub;
2819:
2820: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821:
2822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2823: THEN
2824: FND_MSG_PUB.add_exc_msg
2825: ( p_pkg_name => G_PKG_NAME
2826: , p_procedure_name => l_api_name );

Line 2824: FND_MSG_PUB.add_exc_msg

2820: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821:
2822: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2823: THEN
2824: FND_MSG_PUB.add_exc_msg
2825: ( p_pkg_name => G_PKG_NAME
2826: , p_procedure_name => l_api_name );
2827:
2828: END IF;

Line 2944: FND_MSG_PUB.initialize;

2940:
2941: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2942: THEN
2943:
2944: FND_MSG_PUB.initialize;
2945:
2946: END IF;
2947:
2948: -- Set API return status to success

Line 3052: FND_MSG_PUB.Count_And_Get

3048: ROLLBACK TO execute_create_budget_pub;
3049:
3050: p_return_status := FND_API.G_RET_STS_ERROR;
3051:
3052: FND_MSG_PUB.Count_And_Get
3053: ( p_count => p_msg_count ,
3054: p_data => p_msg_data );
3055:
3056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3065: FND_MSG_PUB.Count_And_Get

3061: ROLLBACK TO execute_create_budget_pub;
3062:
3063: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3064:
3065: FND_MSG_PUB.Count_And_Get
3066: ( p_count => p_msg_count ,
3067: p_data => p_msg_data );
3068:
3069: WHEN OTHERS THEN

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

3072: ROLLBACK TO execute_create_budget_pub;
3073:
3074: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3075:
3076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3077: THEN
3078: FND_MSG_PUB.add_exc_msg
3079: ( p_pkg_name => G_PKG_NAME
3080: , p_procedure_name => l_api_name );

Line 3078: FND_MSG_PUB.add_exc_msg

3074: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3075:
3076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3077: THEN
3078: FND_MSG_PUB.add_exc_msg
3079: ( p_pkg_name => G_PKG_NAME
3080: , p_procedure_name => l_api_name );
3081:
3082: END IF;

Line 3084: FND_MSG_PUB.Count_And_Get

3080: , p_procedure_name => l_api_name );
3081:
3082: END IF;
3083:
3084: FND_MSG_PUB.Count_And_Get
3085: ( p_count => p_msg_count ,
3086: p_data => p_msg_data );
3087:
3088: END execute_create_draft_budget;

Line 3142: FND_MSG_PUB.initialize;

3138:
3139: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3140: THEN
3141:
3142: FND_MSG_PUB.initialize;
3143:
3144: END IF;
3145:
3146: -- Set API return status to success

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

3152:
3153: IF p_line_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3154: OR p_line_index IS NULL
3155: THEN
3156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3157: THEN
3158: pa_interface_utils_pub.map_new_amg_msg
3159: ( p_old_message_code => 'PA_BUGDET_LINE_INDEX_MISSING'
3160: ,p_msg_attribute => 'CHANGE'

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

3199: ROLLBACK TO fetch_budget_line_pub;
3200:
3201: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202:
3203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3204: THEN
3205: FND_MSG_PUB.add_exc_msg
3206: ( p_pkg_name => G_PKG_NAME
3207: , p_procedure_name => l_api_name );

Line 3205: FND_MSG_PUB.add_exc_msg

3201: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202:
3203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3204: THEN
3205: FND_MSG_PUB.add_exc_msg
3206: ( p_pkg_name => G_PKG_NAME
3207: , p_procedure_name => l_api_name );
3208:
3209: END IF;

Line 3522: FND_MSG_PUB.initialize;

3518: --Initialize the message table if requested.
3519: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3520: THEN
3521:
3522: FND_MSG_PUB.initialize;
3523:
3524: END IF;
3525:
3526: --Get the user id and responsibility Ids

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

3547: --product_code is mandatory
3548: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3549: OR p_pm_product_code IS NULL
3550: THEN
3551: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3552: THEN
3553: pa_interface_utils_pub.map_new_amg_msg
3554: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
3555: ,p_msg_attribute => 'CHANGE'

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

3581: -- dbms_output.put_line('l_pm_product_code is 2'||l_pm_product_code);
3582: IF l_pm_product_code <> 'X'
3583: THEN
3584:
3585: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3586: THEN
3587: pa_interface_utils_pub.map_new_amg_msg
3588: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
3589: ,p_msg_attribute => 'CHANGE'

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

3707: END IF;
3708:
3709: IF l_project_id IS NULL --never happens because previous procedure checks this.
3710: THEN
3711: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3712: THEN
3713: pa_interface_utils_pub.map_new_amg_msg
3714: ( p_old_message_code => 'PA_PROJECT_IS_MISSING'
3715: ,p_msg_attribute => 'CHANGE'

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

3825: INTO l_row_found;
3826:
3827: IF l_budget_types_csr%NOTFOUND
3828: THEN
3829: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3830: THEN
3831: pa_interface_utils_pub.map_new_amg_msg
3832: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
3833: ,p_msg_attribute => 'CHANGE'

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

3854:
3855: --Added this validation for bug#4460120
3856: --Verify that the budget is not of type FORECASTING_BUDGET_TYPE
3857: IF p_budget_type_code='FORECASTING_BUDGET_TYPE' THEN
3858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3859: THEN
3860: PA_UTILS.add_message
3861: (p_app_short_name => 'PA',
3862: p_msg_name => 'PA_FP_CANT_BLINE_FCST_BUD_TYPE');

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

4047:
4048:
4049: IF (nvl(l_fck_req_flag,'N') = 'Y')
4050: THEN
4051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4052: THEN
4053: pa_interface_utils_pub.map_new_amg_msg
4054: ( p_old_message_code => 'PA_BC_BGT_TYPE_IS_BAD_AMG'
4055: ,p_msg_attribute => 'CHANGE'

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

4126: INTO l_budget_versions_rec;
4127:
4128: IF l_budget_versions_csr%NOTFOUND
4129: THEN
4130: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4131: THEN
4132: pa_interface_utils_pub.map_new_amg_msg
4133: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
4134: ,p_msg_attribute => 'CHANGE'

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

4178: END IF;
4179:
4180: IF l_curr_working_version_id IS NULL
4181: THEN
4182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4183: THEN
4184: pa_interface_utils_pub.map_new_amg_msg
4185: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
4186: ,p_msg_attribute => 'CHANGE'

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

4282: FETCH l_budget_lines_csr INTO l_row_found;
4283:
4284: IF l_budget_lines_csr%NOTFOUND
4285: THEN
4286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4287: THEN
4288: pa_interface_utils_pub.map_new_amg_msg
4289: ( p_old_message_code => 'PA_NO_BUDGET_LINES'
4290: ,p_msg_attribute => 'CHANGE'

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

4313: FETCH l_resource_assignments_csr INTO l_row_found;
4314:
4315: IF l_resource_assignments_csr%NOTFOUND THEN
4316:
4317: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4318: pa_interface_utils_pub.map_new_amg_msg
4319: ( p_old_message_code => 'PA_NO_BUDGET_LINES'
4320: ,p_msg_attribute => 'CHANGE'
4321: ,p_resize_flag => 'N'

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

4353:
4354: IF l_err_code > 0
4355: THEN
4356:
4357: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4358: THEN
4359:
4360: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4361: THEN

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

4389:
4390: ELSIF l_err_code < 0
4391: THEN
4392:
4393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4394: THEN
4395:
4396: FND_MSG_PUB.add_exc_msg
4397: ( p_pkg_name => 'PA_BUDGET_CORE'

Line 4396: FND_MSG_PUB.add_exc_msg

4392:
4393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4394: THEN
4395:
4396: FND_MSG_PUB.add_exc_msg
4397: ( p_pkg_name => 'PA_BUDGET_CORE'
4398: , p_procedure_name => 'VERIFY'
4399: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4400:

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

4431:
4432: IF ( l_budget_rules_csr%NOTFOUND)
4433: THEN
4434:
4435: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4436: THEN
4437: pa_interface_utils_pub.map_new_amg_msg
4438: ( p_old_message_code => 'PA_NO_BUDGET_RULES_ATTR'
4439: ,p_msg_attribute => 'CHANGE'

Line 4567: -- dbms_output.put_line('The no of messages in the stack 2 '||FND_MSG_PUB.count_msg);

4563: END IF;
4564: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4565:
4566: END IF;
4567: -- dbms_output.put_line('The no of messages in the stack 2 '||FND_MSG_PUB.count_msg);
4568:
4569: END IF;--If for buget model check
4570:
4571: -- dbms_output.put_line('Starting with workflow l_err_code '||l_err_code);

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

4611:
4612: -- dbms_output.put_line('l_err_code after is WD '||l_err_code);
4613: IF (l_err_code > 0)
4614: THEN
4615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4616: THEN
4617: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4618: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4619: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);

Line 4621: FND_MSG_PUB.add;

4617: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4618: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4619: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4620: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4621: FND_MSG_PUB.add;
4622: END IF;
4623:
4624: -- RAISE FND_API.G_EXC_ERROR;
4625: l_any_error_occurred_flag := 'Y';

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

4624: -- RAISE FND_API.G_EXC_ERROR;
4625: l_any_error_occurred_flag := 'Y';
4626: ELSIF (l_err_code < 0)
4627: THEN
4628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4629: THEN
4630: FND_MSG_PUB.add_exc_msg
4631: ( p_pkg_name => 'PA_BUDGET_WF'
4632: , p_procedure_name => 'BUDGET_WF_IS_USED'

Line 4630: FND_MSG_PUB.add_exc_msg

4626: ELSIF (l_err_code < 0)
4627: THEN
4628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4629: THEN
4630: FND_MSG_PUB.add_exc_msg
4631: ( p_pkg_name => 'PA_BUDGET_WF'
4632: , p_procedure_name => 'BUDGET_WF_IS_USED'
4633: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4634: END IF;

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

4677: );
4678:
4679: IF (l_err_code > 0)
4680: THEN
4681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4682: THEN
4683: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4684: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4685: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);

Line 4687: FND_MSG_PUB.add;

4683: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4684: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4685: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4686: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4687: FND_MSG_PUB.add;
4688: END IF;
4689:
4690: RAISE FND_API.G_EXC_ERROR;
4691:

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

4690: RAISE FND_API.G_EXC_ERROR;
4691:
4692: ELSIF (l_err_code < 0)
4693: THEN
4694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4695: THEN
4696: FND_MSG_PUB.add_exc_msg
4697: ( p_pkg_name => 'PA_BUDGET_WF'
4698: , p_procedure_name => 'START_BUDGET_WF'

Line 4696: FND_MSG_PUB.add_exc_msg

4692: ELSIF (l_err_code < 0)
4693: THEN
4694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4695: THEN
4696: FND_MSG_PUB.add_exc_msg
4697: ( p_pkg_name => 'PA_BUDGET_WF'
4698: , p_procedure_name => 'START_BUDGET_WF'
4699: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4700: END IF;

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

4767: /* -- dbms_output.put_line('Err_code: '||l_err_code); */
4768: /* -- dbms_output.put_line('Err_stage: '||l_err_stage); */
4769: /* -- dbms_output.put_line('Err_stack: '||l_err_stack); */
4770:
4771: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4772: THEN
4773:
4774: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4775: THEN

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

4802:
4803: ELSIF l_err_code < 0
4804: THEN
4805:
4806: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4807: THEN
4808:
4809: /* -- dbms_output.put_line('Err_code: '||l_err_code); */
4810: /* -- dbms_output.put_line('Err_stage: '||l_err_stage); */

Line 4813: FND_MSG_PUB.add_exc_msg

4809: /* -- dbms_output.put_line('Err_code: '||l_err_code); */
4810: /* -- dbms_output.put_line('Err_stage: '||l_err_stage); */
4811: /* -- dbms_output.put_line('Err_stack: '||l_err_stack); */
4812:
4813: FND_MSG_PUB.add_exc_msg
4814: ( p_pkg_name => 'PA_BUDGET_CORE'
4815: , p_procedure_name => 'BASELINE'
4816: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4817:

Line 4998: l_msg_count := FND_MSG_PUB.count_msg;

4994: IF p_return_status IS NULL OR
4995: p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4996: p_return_status := FND_API.G_RET_STS_ERROR;
4997: END IF;
4998: l_msg_count := FND_MSG_PUB.count_msg;
4999: IF l_msg_count = 1 THEN
5000: PA_INTERFACE_UTILS_PUB.get_messages
5001: (p_encoded => FND_API.G_TRUE,
5002: p_msg_index => 1,

Line 5025: FND_MSG_PUB.Count_And_Get

5021: ROLLBACK TO baseline_budget_pub;
5022:
5023: p_return_status := FND_API.G_RET_STS_ERROR;
5024:
5025: FND_MSG_PUB.Count_And_Get
5026: ( p_count => p_msg_count ,
5027: p_data => p_msg_data );
5028:
5029: pa_debug.reset_curr_function;

Line 5039: FND_MSG_PUB.Count_And_Get

5035: ROLLBACK TO baseline_budget_pub;
5036:
5037: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5038:
5039: FND_MSG_PUB.Count_And_Get
5040: ( p_count => p_msg_count ,
5041: p_data => p_msg_data );
5042:
5043: pa_debug.reset_curr_function;

Line 5052: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

5048: ROLLBACK TO baseline_budget_pub;
5049:
5050: p_return_status := FND_API.G_RET_STS_ERROR ;
5051:
5052: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5053: THEN
5054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');

Line 5061: FND_MSG_PUB.Add;

5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5061: FND_MSG_PUB.Add;
5062: END IF;
5063:
5064: FND_MSG_PUB.Count_And_Get
5065: (p_count => p_msg_count

Line 5064: FND_MSG_PUB.Count_And_Get

5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5061: FND_MSG_PUB.Add;
5062: END IF;
5063:
5064: FND_MSG_PUB.Count_And_Get
5065: (p_count => p_msg_count
5066: , p_data => p_msg_data
5067: );
5068: pa_debug.reset_curr_function;

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

5075: ROLLBACK TO baseline_budget_pub;
5076:
5077: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5078:
5079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5080: THEN
5081: FND_MSG_PUB.add_exc_msg
5082: ( p_pkg_name => G_PKG_NAME
5083: , p_procedure_name => l_api_name );

Line 5081: FND_MSG_PUB.add_exc_msg

5077: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5078:
5079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5080: THEN
5081: FND_MSG_PUB.add_exc_msg
5082: ( p_pkg_name => G_PKG_NAME
5083: , p_procedure_name => l_api_name );
5084:
5085: END IF;

Line 5087: FND_MSG_PUB.Count_And_Get

5083: , p_procedure_name => l_api_name );
5084:
5085: END IF;
5086:
5087: FND_MSG_PUB.Count_And_Get
5088: ( p_count => p_msg_count ,
5089: p_data => p_msg_data );
5090:
5091: pa_debug.reset_curr_function;

Line 5267: FND_MSG_PUB.initialize;

5263:
5264: --Initialize the message table if requested.
5265: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5266: THEN
5267: FND_MSG_PUB.initialize;
5268: END IF;
5269:
5270: --Set API return status to success
5271: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

5442: pa_debug.g_err_stage := 'check_overlapping_dates API falied';
5443: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5444: END IF;
5445:
5446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5447: THEN
5448: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5449: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5450:

Line 5451: FND_MSG_PUB.add;

5447: THEN
5448: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5449: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5450:
5451: FND_MSG_PUB.add;
5452: END IF;
5453:
5454: RAISE FND_API.G_EXC_ERROR;
5455:

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

5460: pa_debug.g_err_stage := 'check_overlapping_dates API falied';
5461: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5462: END IF;
5463:
5464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5465: THEN
5466: FND_MSG_PUB.add_exc_msg
5467: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5468: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'

Line 5466: FND_MSG_PUB.add_exc_msg

5462: END IF;
5463:
5464: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5465: THEN
5466: FND_MSG_PUB.add_exc_msg
5467: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5468: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
5469: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5470: END IF;

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

5487: pa_debug.g_err_stage := 'summerize_project_totals API falied';
5488: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5489: END IF;
5490:
5491: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5492: THEN
5493: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
5494: THEN
5495: pa_interface_utils_pub.map_new_amg_msg

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

5524: pa_debug.g_err_stage := 'summerize_project_totals API falied';
5525: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5526: END IF;
5527:
5528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5529: THEN
5530: FND_MSG_PUB.add_exc_msg
5531: ( p_pkg_name => 'PA_BUDGET_UTILS'
5532: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'

Line 5530: FND_MSG_PUB.add_exc_msg

5526: END IF;
5527:
5528: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5529: THEN
5530: FND_MSG_PUB.add_exc_msg
5531: ( p_pkg_name => 'PA_BUDGET_UTILS'
5532: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
5533: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5534: END IF;

Line 6003: l_msg_count := FND_MSG_PUB.count_msg;

5999:
6000: ROLLBACK TO add_budget_line_pub;
6001:
6002: p_return_status := FND_API.G_RET_STS_ERROR;
6003: l_msg_count := FND_MSG_PUB.count_msg;
6004:
6005: IF l_msg_count = 1 and p_msg_data IS NULL THEN
6006: PA_INTERFACE_UTILS_PUB.get_messages
6007: (p_encoded => FND_API.G_TRUE

Line 6033: FND_MSG_PUB.count_and_get

6029: ROLLBACK TO add_budget_line_pub;
6030:
6031: p_return_status := FND_API.G_RET_STS_ERROR;
6032:
6033: FND_MSG_PUB.count_and_get
6034: ( p_count => p_msg_count ,
6035: p_data => p_msg_data );
6036:
6037: IF ( l_debug_mode = 'Y' ) THEN

Line 6049: FND_MSG_PUB.count_and_get

6045: ROLLBACK TO add_budget_line_pub;
6046:
6047: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6048:
6049: FND_MSG_PUB.count_and_get
6050: ( p_count => p_msg_count ,
6051: p_data => p_msg_data );
6052:
6053: IF ( l_debug_mode = 'Y' ) THEN

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

6061: ROLLBACK TO add_budget_line_pub;
6062:
6063: p_return_status := FND_API.G_RET_STS_ERROR;
6064:
6065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6066: THEN
6067: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);

Line 6074: FND_MSG_PUB.add;

6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6074: FND_MSG_PUB.add;
6075: END IF;
6076:
6077: FND_MSG_PUB.count_and_get
6078: ( p_count => p_msg_count ,

Line 6077: FND_MSG_PUB.count_and_get

6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6074: FND_MSG_PUB.add;
6075: END IF;
6076:
6077: FND_MSG_PUB.count_and_get
6078: ( p_count => p_msg_count ,
6079: p_data => p_msg_data );
6080:
6081: IF ( l_debug_mode = 'Y' ) THEN

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

6089: ROLLBACK TO add_budget_line_pub;
6090:
6091: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6092:
6093: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6094: THEN
6095: FND_MSG_PUB.add_exc_msg
6096: ( p_pkg_name => G_PKG_NAME
6097: , p_procedure_name => l_api_name );

Line 6095: FND_MSG_PUB.add_exc_msg

6091: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6092:
6093: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6094: THEN
6095: FND_MSG_PUB.add_exc_msg
6096: ( p_pkg_name => G_PKG_NAME
6097: , p_procedure_name => l_api_name );
6098: END IF;
6099:

Line 6100: FND_MSG_PUB.count_and_get

6096: ( p_pkg_name => G_PKG_NAME
6097: , p_procedure_name => l_api_name );
6098: END IF;
6099:
6100: FND_MSG_PUB.count_and_get
6101: ( p_count => p_msg_count ,
6102: p_data => p_msg_data );
6103:
6104: IF ( l_debug_mode = 'Y' ) THEN

Line 6279: FND_MSG_PUB.initialize;

6275:
6276: IF FND_API.TO_BOOLEAN( p_init_msg_list )
6277: THEN
6278:
6279: FND_MSG_PUB.initialize;
6280:
6281: END IF;
6282: -- This api will initialize the data that will be used by the map_new_amg_msg.
6283: l_resp_id := FND_GLOBAL.Resp_id;

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

6352:
6353: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6354: OR p_pm_product_code IS NULL
6355: THEN
6356: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6357: THEN
6358: pa_interface_utils_pub.map_new_amg_msg
6359: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
6360: ,p_msg_attribute => 'CHANGE'

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

6382: CLOSE p_product_code_csr;
6383: IF l_pm_product_code <> 'X'
6384: THEN
6385:
6386: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6387: THEN
6388: pa_interface_utils_pub.map_new_amg_msg
6389: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
6390: ,p_msg_attribute => 'CHANGE'

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

6475: FETCH l_budget_type_csr INTO l_dummy;
6476:
6477: IF l_budget_type_csr%NOTFOUND
6478: THEN
6479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6480: THEN
6481: pa_interface_utils_pub.map_new_amg_msg
6482: (p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
6483: ,p_msg_attribute => 'CHANGE'

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

6503: CLOSE l_budget_type_csr;
6504:
6505: --Verify that the budget is not of type FORECASTING_BUDGET_TYPE
6506: IF p_budget_type_code='FORECASTING_BUDGET_TYPE' THEN
6507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6508: THEN
6509: PA_UTILS.add_message
6510: (p_app_short_name => 'PA',
6511: p_msg_name => 'PA_FP_CANT_EDIT_FCST_BUD_TYPE');

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

6528: FETCH l_budget_version_csr INTO l_budget_version_id;
6529:
6530: IF l_budget_version_csr%NOTFOUND
6531: THEN
6532: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6533: THEN
6534: pa_interface_utils_pub.map_new_amg_msg
6535: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
6536: ,p_msg_attribute => 'CHANGE'

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

6566: || 'budgetary control is enabled';
6567: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
6568: END IF;
6569:
6570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6571: THEN
6572: PA_UTILS.ADD_MESSAGE(
6573: p_app_short_name => 'PA'
6574: ,p_msg_name => 'PA_FP_DEL_BC_ENABLED_BV_AMG'

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

6605:
6606: IF l_err_code > 0
6607: THEN
6608:
6609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6610: THEN
6611:
6612: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
6613: THEN

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

6650: ELSIF l_err_code < 0
6651: THEN
6652:
6653:
6654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6655: THEN
6656: IF(l_debug_mode='Y') THEN
6657: pa_debug.g_err_stage := 'Unexpected Error in Delete draft';
6658: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 6661: FND_MSG_PUB.add_exc_msg

6657: pa_debug.g_err_stage := 'Unexpected Error in Delete draft';
6658: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
6659: END IF;
6660:
6661: FND_MSG_PUB.add_exc_msg
6662: ( p_pkg_name => 'PA_BUDGET_UTILS'
6663: , p_procedure_name => 'DELETE_DRAFT'
6664: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
6665:

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

6705: CLOSE l_use_for_wp_csr;
6706:
6707: IF l_dummy = 1
6708: THEN
6709: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6710: THEN
6711: PA_UTILS.add_message
6712: (p_app_short_name => 'PA',
6713: p_msg_name => 'PA_FP_CANT_DEL_WP_DATA');

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

6803: ,x_msg_data => p_msg_data );
6804:
6805: -- If the budget version is a control item version throw error
6806: IF l_ci_id IS NOT NULL THEN
6807: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6808: PA_UTILS.ADD_MESSAGE(
6809: p_app_short_name => 'PA'
6810: ,p_msg_name => 'PA_FP_CI_VERSION_NON_EDITABLE'
6811: ,p_token1 => 'BUDGET_VERSION_ID'

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

6836: INTO l_fin_plan_type_name
6837: FROM pa_fin_plan_types_vl
6838: WHERE fin_plan_type_id = l_fin_plan_type_id;
6839:
6840: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6841: THEN
6842: PA_UTILS.add_message
6843: (p_app_short_name => 'PA'
6844: ,p_msg_name => 'PA_FP_NO_WORKING_VERSION'

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

6862: --FP M Changes for delete_draft_budget. If the budget version
6863: --belongs to an org forecast project then throw an error
6864: IF (PA_FIN_PLAN_UTILS.is_orgforecast_plan(l_budget_version_id) = 'Y')
6865: THEN
6866: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6867: THEN
6868: PA_UTILS.add_message
6869: (p_app_short_name => 'PA',
6870: p_msg_name => 'PA_FP_CANT_DEL_ORG_FCST_PLAN');

Line 7009: l_msg_count := FND_MSG_PUB.count_msg;

7005: EXCEPTION
7006: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7007:
7008: p_return_status := FND_API.G_RET_STS_ERROR;
7009: l_msg_count := FND_MSG_PUB.count_msg;
7010:
7011: IF l_msg_count = 1 and p_msg_data IS NULL THEN
7012: PA_INTERFACE_UTILS_PUB.get_messages
7013: (p_encoded => FND_API.G_TRUE

Line 7036: FND_MSG_PUB.Count_And_Get

7032: ROLLBACK TO delete_draft_budget_pub;
7033:
7034: p_return_status := FND_API.G_RET_STS_ERROR;
7035:
7036: FND_MSG_PUB.Count_And_Get
7037: ( p_count => p_msg_count ,
7038: p_data => p_msg_data );
7039: IF ( l_debug_mode = 'Y' ) THEN
7040: pa_debug.reset_curr_function;

Line 7050: FND_MSG_PUB.Count_And_Get

7046: ROLLBACK TO delete_draft_budget_pub;
7047:
7048: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7049:
7050: FND_MSG_PUB.Count_And_Get
7051: ( p_count => p_msg_count ,
7052: p_data => p_msg_data );
7053: IF ( l_debug_mode = 'Y' ) THEN
7054: pa_debug.reset_curr_function;

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

7059: ROLLBACK TO delete_draft_budget_pub;
7060:
7061: p_return_status := FND_API.G_RET_STS_ERROR;
7062:
7063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7064: THEN
7065: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');

Line 7072: FND_MSG_PUB.ADD;

7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7072: FND_MSG_PUB.ADD;
7073: END IF;
7074:
7075: FND_MSG_PUB.Count_And_Get
7076: ( p_count => p_msg_count ,

Line 7075: FND_MSG_PUB.Count_And_Get

7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7072: FND_MSG_PUB.ADD;
7073: END IF;
7074:
7075: FND_MSG_PUB.Count_And_Get
7076: ( p_count => p_msg_count ,
7077: p_data => p_msg_data );
7078: IF ( l_debug_mode = 'Y' ) THEN
7079: pa_debug.reset_curr_function;

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

7084: ROLLBACK TO delete_draft_budget_pub;
7085:
7086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7087:
7088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7089: THEN
7090: FND_MSG_PUB.add_exc_msg
7091: ( p_pkg_name => G_PKG_NAME
7092: , p_procedure_name => l_api_name );

Line 7090: FND_MSG_PUB.add_exc_msg

7086: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7087:
7088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7089: THEN
7090: FND_MSG_PUB.add_exc_msg
7091: ( p_pkg_name => G_PKG_NAME
7092: , p_procedure_name => l_api_name );
7093:
7094: END IF;

Line 7096: FND_MSG_PUB.Count_And_Get

7092: , p_procedure_name => l_api_name );
7093:
7094: END IF;
7095:
7096: FND_MSG_PUB.Count_And_Get
7097: ( p_count => p_msg_count ,
7098: p_data => p_msg_data );
7099: IF ( l_debug_mode = 'Y' ) THEN
7100: pa_debug.reset_curr_function;

Line 7280: FND_MSG_PUB.initialize;

7276: --Initialize the message table if requested.
7277:
7278: IF FND_API.to_boolean( p_init_msg_list )
7279: THEN
7280: FND_MSG_PUB.initialize;
7281: END IF;
7282:
7283: --Standard call to check for call compatibility.
7284:

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

7332:
7333: IF (l_budget_type_code IS NULL AND l_fin_plan_type_name IS NULL AND l_fin_plan_type_id IS NULL)
7334: THEN
7335:
7336: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7337: PA_UTILS.add_message
7338: (p_app_short_name => 'PA',
7339: p_msg_name => 'PA_BUDGET_FP_BOTH_MISSING');
7340: END IF;

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

7353: IF ((l_budget_type_code IS NOT NULL) AND
7354: (l_fin_plan_type_name IS NOT NULL OR l_fin_plan_type_id IS NOT NULL ))
7355: THEN
7356:
7357: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7358: PA_UTILS.add_message
7359: (p_app_short_name => 'PA',
7360: p_msg_name => 'PA_BUDGET_FP_BOTH_NOT_NULL');
7361: END IF;

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

7373: --product_code is mandatory
7374: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7375: OR p_pm_product_code IS NULL
7376: THEN
7377: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7378: --This function checks if the message being written to the message table
7379: --is higher or equal to the message level threshold.
7380: THEN
7381: PA_UTILS.add_message

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

7399:
7400: IF l_pm_product_code <> 'X'
7401: THEN
7402:
7403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7404: THEN
7405: PA_UTILS.add_message
7406: (p_app_short_name => 'PA',
7407: p_msg_name => 'PA_PRODUCT_CODE_IS_INVALID_AMG');

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

7420:
7421: --p_version_number is mandatory
7422: IF l_version_number IS NULL
7423: THEN
7424: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7425: THEN
7426: PA_UTILS.add_message
7427: (p_app_short_name => 'PA',
7428: p_msg_name => 'PA_FP_VERSION_NUMBER_REQD');

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

7479: FETCH l_budget_type_csr INTO l_dummy;
7480:
7481: IF l_budget_type_csr%NOTFOUND
7482: THEN
7483: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7484: THEN
7485: PA_INTERFACE_UTILS_PUB.map_new_amg_msg
7486: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
7487: ,p_msg_attribute => 'CHANGE'

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

7513: CLOSE l_budget_version_no_csr;
7514:
7515: IF (l_budget_version_no_rec.budget_version_id IS NULL)
7516: THEN
7517: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7518: THEN
7519: PA_UTILS.add_message
7520: (p_app_short_name => 'PA',
7521: p_msg_name => 'PA_FP_VERSION_NO_IS_INVALID');

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

7531: ELSE --l_budget_version_no_rec has been fetched
7532:
7533: IF (l_budget_version_no_rec.current_flag = 'Y'
7534: OR l_budget_version_no_rec.current_original_flag = 'Y') THEN
7535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7536: PA_UTILS.add_message
7537: (p_app_short_name => 'PA',
7538: p_msg_name => 'PA_FP_DEL_CUR_OR_ORIG_BASELINE');
7539: END IF;

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

7593: || 'budgetary control is enabled';
7594: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7595: END IF;
7596:
7597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7598: THEN
7599: PA_UTILS.ADD_MESSAGE(
7600: p_app_short_name => 'PA'
7601: ,p_msg_name => 'PA_FP_DEL_BC_ENABLED_BV_AMG'

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

7630: ,x_err_stack => l_err_stack );
7631:
7632: IF l_err_code > 0 THEN
7633:
7634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7635: THEN
7636: IF NOT PA_PROJECT_PVT.check_valid_message(l_err_stage)
7637: THEN
7638: IF(l_debug_mode='Y') THEN

Line 7671: END IF; --FND_MSG_PUB.check_msg_level

7667: ,p_attribute4 => ''
7668: ,p_attribute5 => '');
7669: END IF;
7670:
7671: END IF; --FND_MSG_PUB.check_msg_level
7672: RAISE FND_API.G_EXC_ERROR;
7673:
7674: ELSIF l_err_code < 0 THEN
7675:

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

7672: RAISE FND_API.G_EXC_ERROR;
7673:
7674: ELSIF l_err_code < 0 THEN
7675:
7676: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7677: THEN
7678: IF(l_debug_mode='Y') THEN
7679: pa_debug.g_err_stage := 'Unexpected Error in Delete_draft api';
7680: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 7683: FND_MSG_PUB.add_exc_msg

7679: pa_debug.g_err_stage := 'Unexpected Error in Delete_draft api';
7680: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7681: END IF;
7682:
7683: FND_MSG_PUB.add_exc_msg
7684: ( p_pkg_name => 'PA_BUDGET_UTILS'
7685: , p_procedure_name => 'DELETE_DRAFT'
7686: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
7687: END IF; --FND_MSG_PUB.check_msg_level

Line 7687: END IF; --FND_MSG_PUB.check_msg_level

7683: FND_MSG_PUB.add_exc_msg
7684: ( p_pkg_name => 'PA_BUDGET_UTILS'
7685: , p_procedure_name => 'DELETE_DRAFT'
7686: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
7687: END IF; --FND_MSG_PUB.check_msg_level
7688:
7689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7690:
7691: END IF; --l_err_code > 0

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

7718: CLOSE l_use_for_wp_csr;
7719:
7720: IF l_dummy = 1
7721: THEN
7722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7723: THEN
7724: PA_UTILS.add_message
7725: (p_app_short_name => 'PA',
7726: p_msg_name => 'PA_FP_CANT_DEL_WP_DATA');

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

7782: CLOSE l_finplan_version_no_csr;
7783:
7784: IF (l_budget_version_id IS NULL)
7785: THEN
7786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7787: THEN
7788: PA_UTILS.add_message
7789: (p_app_short_name => 'PA',
7790: p_msg_name => 'PA_FP_VERSION_NO_IS_INVALID');

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

7800:
7801: --if the budget version belongs to an org forecast project then throw an error
7802: IF (PA_FIN_PLAN_UTILS.is_orgforecast_plan(l_budget_version_id) = 'Y')
7803: THEN
7804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7805: THEN
7806: PA_UTILS.add_message
7807: (p_app_short_name => 'PA',
7808: p_msg_name => 'PA_FP_CANT_DEL_ORG_FCST_PLAN');

Line 7921: l_msg_count := FND_MSG_PUB.count_msg;

7917: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc
7918: THEN
7919:
7920: p_return_status := FND_API.G_RET_STS_ERROR;
7921: l_msg_count := FND_MSG_PUB.count_msg;
7922:
7923: IF l_msg_count = 1 and p_msg_data IS NULL THEN
7924: PA_INTERFACE_UTILS_PUB.get_messages
7925: (p_encoded => FND_API.G_TRUE

Line 7950: FND_MSG_PUB.count_and_get

7946: ROLLBACK TO delete_baseline_budget_pub;
7947:
7948: p_return_status := FND_API.G_RET_STS_ERROR;
7949:
7950: FND_MSG_PUB.count_and_get
7951: ( p_count => p_msg_count ,
7952: p_data => p_msg_data );
7953:
7954: IF ( l_debug_mode = 'Y' ) THEN

Line 7965: FND_MSG_PUB.count_and_get

7961: ROLLBACK TO delete_baseline_budget_pub;
7962:
7963: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7964:
7965: FND_MSG_PUB.count_and_get
7966: ( p_count => p_msg_count ,
7967: p_data => p_msg_data );
7968:
7969: IF ( l_debug_mode = 'Y' ) THEN

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

7975: ROLLBACK TO delete_baseline_budget_pub;
7976:
7977: p_return_status := FND_API.G_RET_STS_ERROR;
7978:
7979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7980: THEN
7981: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');

Line 7988: FND_MSG_PUB.add;

7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7988: FND_MSG_PUB.add;
7989: END IF;
7990:
7991: FND_MSG_PUB.count_and_get
7992: ( p_count => p_msg_count ,

Line 7991: FND_MSG_PUB.count_and_get

7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7988: FND_MSG_PUB.add;
7989: END IF;
7990:
7991: FND_MSG_PUB.count_and_get
7992: ( p_count => p_msg_count ,
7993: p_data => p_msg_data );
7994:
7995: IF ( l_debug_mode = 'Y' ) THEN

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

8001: ROLLBACK TO delete_baseline_budget_pub;
8002:
8003: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8004:
8005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8006: THEN
8007: FND_MSG_PUB.add_exc_msg
8008: ( p_pkg_name => G_PKG_NAME
8009: , p_procedure_name => l_api_name );

Line 8007: FND_MSG_PUB.add_exc_msg

8003: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8004:
8005: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8006: THEN
8007: FND_MSG_PUB.add_exc_msg
8008: ( p_pkg_name => G_PKG_NAME
8009: , p_procedure_name => l_api_name );
8010:
8011: END IF;

Line 8013: FND_MSG_PUB.count_and_get

8009: , p_procedure_name => l_api_name );
8010:
8011: END IF;
8012:
8013: FND_MSG_PUB.count_and_get
8014: ( p_count => p_msg_count ,
8015: p_data => p_msg_data );
8016:
8017: IF ( l_debug_mode = 'Y' ) THEN

Line 8284: FND_MSG_PUB.initialize;

8280:
8281: --Initialize the message table if requested.
8282: IF FND_API.TO_BOOLEAN( p_init_msg_list )
8283: THEN
8284: FND_MSG_PUB.initialize;
8285: END IF;
8286:
8287: --Set API return status to success
8288: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

8436: FETCH l_resource_assignment_csr INTO l_resource_assignment_id;
8437:
8438: IF l_resource_assignment_csr%NOTFOUND
8439: THEN
8440: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8441: THEN
8442: pa_interface_utils_pub.map_new_amg_msg
8443: ( p_old_message_code => 'PA_NO_RESOURCE_ASSIGNMENT'
8444: ,p_msg_attribute => 'CHANGE'

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

8470: FETCH l_budget_periods_csr INTO l_start_date;
8471:
8472: IF l_budget_periods_csr%NOTFOUND
8473: THEN
8474: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8475: THEN
8476: pa_interface_utils_pub.map_new_amg_msg
8477: ( p_old_message_code => 'PA_PERIOD_NAME_INVALID'
8478: ,p_msg_attribute => 'CHANGE'

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

8505: FETCH l_start_date_csr INTO l_dummy;
8506:
8507: IF l_start_date_csr%NOTFOUND
8508: THEN
8509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8510: THEN
8511: pa_interface_utils_pub.map_new_amg_msg
8512: ( p_old_message_code => 'PA_START_DATE_INVALID'
8513: ,p_msg_attribute => 'CHANGE'

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

8585: CLOSE l_proj_func_currency_csr;
8586:
8587: IF l_dummy = 0 THEN --currency_code not equal to PFC
8588:
8589: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8590: THEN
8591: PA_UTILS.ADD_MESSAGE
8592: ( p_app_short_name => 'PA',
8593: p_msg_name => 'PA_FP_TXN_NOT_PFC_FOR_APP_REV',

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

8611: CLOSE l_plan_ver_txn_curr_csr;
8612:
8613: IF l_dummy = 0 THEN --currency_code is not valid
8614:
8615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8616: THEN
8617: PA_UTILS.ADD_MESSAGE
8618: ( p_app_short_name => 'PA',
8619: p_msg_name => 'PA_FP_TXN_NOT_ADDED_FOR_PT',

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

8638: IF (l_multi_curr_flag = 'Y' AND
8639: l_currency_code IS NULL AND
8640: l_start_date IS NOT NULL)
8641: THEN
8642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8643: THEN
8644: PA_UTILS.add_message
8645: (p_app_short_name => 'PA'
8646: ,p_msg_name => 'PA_FP_CURRENCY_NULL_AMG'

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

8684: ((l_start_date IS NOT NULL AND l_etc_start_date > l_start_date) OR l_start_date IS NULL) AND -- Bug 5998035
8685: l_time_phased_code IS NOT NULL AND
8686: l_time_phased_code <> 'N')
8687: THEN
8688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8689: THEN
8690: PA_UTILS.add_message
8691: (p_app_short_name => 'PA'
8692: ,p_msg_name => 'PA_FP_FCST_ACTUALS_AMG'

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

8733: ,l_line_end_date ;
8734:
8735: IF l_budget_line_rowid_csr%NOTFOUND
8736: THEN
8737: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8738: THEN
8739: pa_interface_utils_pub.map_new_amg_msg
8740: ( p_old_message_code => 'PA_BUDGET_LINE_NOT_FOUND'
8741: ,p_msg_attribute => 'CHANGE'

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

8776:
8777: WHEN OTHERS
8778: THEN
8779:
8780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8781: THEN
8782: FND_MSG_PUB.add_exc_msg
8783: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
8784: , p_procedure_name => 'DELETE_ROW'

Line 8782: FND_MSG_PUB.add_exc_msg

8778: THEN
8779:
8780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8781: THEN
8782: FND_MSG_PUB.add_exc_msg
8783: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
8784: , p_procedure_name => 'DELETE_ROW'
8785: , p_error_text => SQLCODE );
8786:

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

8844:
8845: IF l_err_code > 0
8846: THEN
8847:
8848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8849: THEN
8850:
8851: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
8852: THEN

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

8879:
8880: ELSIF l_err_code < 0
8881: THEN
8882:
8883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8884: THEN
8885:
8886: FND_MSG_PUB.add_exc_msg
8887: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 8886: FND_MSG_PUB.add_exc_msg

8882:
8883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8884: THEN
8885:
8886: FND_MSG_PUB.add_exc_msg
8887: ( p_pkg_name => 'PA_BUDGET_UTILS'
8888: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
8889: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
8890:

Line 9014: l_msg_count := FND_MSG_PUB.count_msg;

9010:
9011: ROLLBACK TO delete_budget_line_pub;
9012:
9013: p_return_status := FND_API.G_RET_STS_ERROR;
9014: l_msg_count := FND_MSG_PUB.count_msg;
9015:
9016: IF l_msg_count = 1 and p_msg_data IS NULL THEN
9017: PA_INTERFACE_UTILS_PUB.get_messages
9018: (p_encoded => FND_API.G_TRUE

Line 9044: FND_MSG_PUB.Count_And_Get

9040: ROLLBACK TO delete_budget_line_pub;
9041:
9042: p_return_status := FND_API.G_RET_STS_ERROR;
9043:
9044: FND_MSG_PUB.Count_And_Get
9045: ( p_count => p_msg_count ,
9046: p_data => p_msg_data );
9047:
9048: IF ( l_debug_mode = 'Y' ) THEN

Line 9060: FND_MSG_PUB.Count_And_Get

9056: ROLLBACK TO delete_budget_line_pub;
9057:
9058: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9059:
9060: FND_MSG_PUB.Count_And_Get
9061: ( p_count => p_msg_count ,
9062: p_data => p_msg_data );
9063:
9064: IF ( l_debug_mode = 'Y' ) THEN

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

9071: ROLLBACK TO delete_budget_line_pub;
9072:
9073: p_return_status := FND_API.G_RET_STS_ERROR;
9074:
9075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9076: THEN
9077: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);

Line 9084: FND_MSG_PUB.ADD;

9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9084: FND_MSG_PUB.ADD;
9085: END IF;
9086:
9087: FND_MSG_PUB.Count_And_Get
9088: ( p_count => p_msg_count ,

Line 9087: FND_MSG_PUB.Count_And_Get

9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9084: FND_MSG_PUB.ADD;
9085: END IF;
9086:
9087: FND_MSG_PUB.Count_And_Get
9088: ( p_count => p_msg_count ,
9089: p_data => p_msg_data );
9090:
9091: IF ( l_debug_mode = 'Y' ) THEN

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

9098: ROLLBACK TO delete_budget_line_pub;
9099:
9100: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9101:
9102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9103: THEN
9104: FND_MSG_PUB.add_exc_msg
9105: ( p_pkg_name => G_PKG_NAME
9106: , p_procedure_name => l_api_name );

Line 9104: FND_MSG_PUB.add_exc_msg

9100: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9101:
9102: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9103: THEN
9104: FND_MSG_PUB.add_exc_msg
9105: ( p_pkg_name => G_PKG_NAME
9106: , p_procedure_name => l_api_name );
9107:
9108: END IF;

Line 9110: FND_MSG_PUB.Count_And_Get

9106: , p_procedure_name => l_api_name );
9107:
9108: END IF;
9109:
9110: FND_MSG_PUB.Count_And_Get
9111: ( p_count => p_msg_count ,
9112: p_data => p_msg_data );
9113:
9114: IF ( l_debug_mode = 'Y' ) THEN

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

9860:
9861:
9862: IF l_budget_version_id IS NULL THEN
9863:
9864: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9865: THEN
9866: pa_interface_utils_pub.map_new_amg_msg
9867: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
9868: ,p_msg_attribute => 'CHANGE'

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

10032: IF l_budget_change_reason_csr%NOTFOUND
10033: THEN
10034: CLOSE l_budget_change_reason_csr;
10035:
10036: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10037: THEN
10038: pa_interface_utils_pub.map_new_amg_msg
10039: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
10040: ,p_msg_attribute => 'CHANGE'

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

10403: ,p_validate_status => l_validate_status
10404: );
10405: IF l_validate_status = 'N'
10406: THEN
10407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10408: THEN
10409: pa_interface_utils_pub.map_new_amg_msg
10410: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
10411: ,p_msg_attribute => 'CHANGE'

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

11212:
11213: IF l_budget_periods_csr%NOTFOUND
11214: THEN
11215:
11216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
11217: THEN
11218: pa_interface_utils_pub.map_new_amg_msg
11219: ( p_old_message_code => 'PA_BUDGET_PERIOD_IS_INVALID'
11220: ,p_msg_attribute => 'CHANGE'

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

11243: l_budget_start_date := trunc(l_budget_line_in_rec.budget_start_date);
11244:
11245: ELSE
11246:
11247: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
11248: THEN
11249: pa_interface_utils_pub.map_new_amg_msg
11250: ( p_old_message_code => 'PA_START_DATE_MISSING'
11251: ,p_msg_attribute => 'CHANGE'

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

12666:
12667: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );
12668:
12669: IF l_err_code > 0 THEN
12670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12671: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12672: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12673:
12674: FND_MSG_PUB.add;

Line 12674: FND_MSG_PUB.add;

12670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12671: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12672: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12673:
12674: FND_MSG_PUB.add;
12675: END IF;
12676: RAISE FND_API.G_EXC_ERROR;
12677: ELSIF l_err_code < 0 THEN
12678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

12674: FND_MSG_PUB.add;
12675: END IF;
12676: RAISE FND_API.G_EXC_ERROR;
12677: ELSIF l_err_code < 0 THEN
12678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12679: FND_MSG_PUB.add_exc_msg
12680: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
12681: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
12682: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );

Line 12679: FND_MSG_PUB.add_exc_msg

12675: END IF;
12676: RAISE FND_API.G_EXC_ERROR;
12677: ELSIF l_err_code < 0 THEN
12678: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12679: FND_MSG_PUB.add_exc_msg
12680: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
12681: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
12682: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12683: END IF;

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

12690: , x_err_stage => l_err_stage
12691: , x_err_stack => l_err_stack );
12692:
12693: IF l_err_code > 0 THEN
12694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12695: IF NOT pa_project_pvt.check_valid_message(l_err_stage) THEN
12696: pa_interface_utils_pub.map_new_amg_msg
12697: ( p_old_message_code => 'PA_SUMMERIZE_TOTALS_FAILED'
12698: ,p_msg_attribute => 'CHANGE'

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

12717: END IF;
12718: END IF;
12719: RAISE FND_API.G_EXC_ERROR;
12720: ELSIF l_err_code < 0 THEN
12721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12722: FND_MSG_PUB.add_exc_msg
12723: ( p_pkg_name => 'PA_BUDGET_UTILS'
12724: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
12725: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );

Line 12722: FND_MSG_PUB.add_exc_msg

12718: END IF;
12719: RAISE FND_API.G_EXC_ERROR;
12720: ELSIF l_err_code < 0 THEN
12721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12722: FND_MSG_PUB.add_exc_msg
12723: ( p_pkg_name => 'PA_BUDGET_UTILS'
12724: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
12725: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12726:

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

12738:
12739: EXCEPTION
12740:
12741: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12742: -- dbms_output.put_line('Invalid_Arg_Exc MSG count in the stack ' || FND_MSG_PUB.count_msg);
12743: ROLLBACK TO update_budget_pub;
12744:
12745: IF p_return_status IS NULL OR
12746: p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 12750: l_msg_count := FND_MSG_PUB.count_msg;

12746: p_return_status = FND_API.G_RET_STS_SUCCESS THEN
12747: p_return_status := FND_API.G_RET_STS_ERROR;
12748: END IF;
12749:
12750: l_msg_count := FND_MSG_PUB.count_msg;
12751: -- dbms_output.put_line('Invalid_Arg_Exc MSG count in the stack ' || l_msg_count);
12752:
12753: IF l_msg_count = 1 AND p_msg_data IS NULL THEN
12754: PA_INTERFACE_UTILS_PUB.get_messages

Line 12783: FND_MSG_PUB.Count_And_Get

12779: ROLLBACK TO update_budget_pub;
12780:
12781: p_return_status := FND_API.G_RET_STS_ERROR;
12782:
12783: FND_MSG_PUB.Count_And_Get
12784: ( p_count => p_msg_count ,
12785: p_data => p_msg_data );
12786:
12787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 12795: FND_MSG_PUB.Count_And_Get

12791: ROLLBACK TO update_budget_pub;
12792:
12793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12794:
12795: FND_MSG_PUB.Count_And_Get
12796: ( p_count => p_msg_count ,
12797: p_data => p_msg_data );
12798:
12799: WHEN ROW_ALREADY_LOCKED

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

12801: ROLLBACK TO update_budget_pub;
12802:
12803: p_return_status := FND_API.G_RET_STS_ERROR;
12804:
12805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12806: THEN
12807: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);

Line 12816: FND_MSG_PUB.ADD;

12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12814: fnd_date.date_to_chardate(dateval => l_budget_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar_aware
12815: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12816: FND_MSG_PUB.ADD;
12817: END IF;
12818:
12819: FND_MSG_PUB.Count_And_Get
12820: ( p_count => p_msg_count ,

Line 12819: FND_MSG_PUB.Count_And_Get

12815: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12816: FND_MSG_PUB.ADD;
12817: END IF;
12818:
12819: FND_MSG_PUB.Count_And_Get
12820: ( p_count => p_msg_count ,
12821: p_data => p_msg_data );
12822:
12823: WHEN OTHERS

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

12827: ROLLBACK TO update_budget_pub;
12828:
12829: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12830:
12831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12832: THEN
12833: FND_MSG_PUB.add_exc_msg
12834: ( p_pkg_name => G_PKG_NAME
12835: , p_procedure_name => l_api_name );

Line 12833: FND_MSG_PUB.add_exc_msg

12829: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12830:
12831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12832: THEN
12833: FND_MSG_PUB.add_exc_msg
12834: ( p_pkg_name => G_PKG_NAME
12835: , p_procedure_name => l_api_name );
12836:
12837: END IF;

Line 12839: FND_MSG_PUB.Count_And_Get

12835: , p_procedure_name => l_api_name );
12836:
12837: END IF;
12838:
12839: FND_MSG_PUB.Count_And_Get
12840: ( p_count => p_msg_count ,
12841: p_data => p_msg_data );
12842:
12843:

Line 12950: FND_MSG_PUB.initialize;

12946:
12947: IF FND_API.TO_BOOLEAN( p_init_msg_list )
12948: THEN
12949:
12950: FND_MSG_PUB.initialize;
12951:
12952: END IF;
12953:
12954: -- Set API return status to success

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

12960:
12961: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12962: OR p_pm_product_code IS NULL
12963: THEN
12964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12965: THEN
12966: pa_interface_utils_pub.map_new_amg_msg
12967: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
12968: ,p_msg_attribute => 'CHANGE'

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

12986: CLOSE p_product_code_csr;
12987: IF l_pm_product_code <> 'X'
12988: THEN
12989:
12990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12991: THEN
12992: pa_interface_utils_pub.map_new_amg_msg
12993: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
12994: ,p_msg_attribute => 'CHANGE'

Line 13083: FND_MSG_PUB.Count_And_Get

13079: ROLLBACK TO execute_update_budget_pub;
13080:
13081: p_return_status := FND_API.G_RET_STS_ERROR;
13082:
13083: FND_MSG_PUB.Count_And_Get
13084: ( p_count => p_msg_count ,
13085: p_data => p_msg_data );
13086:
13087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 13096: FND_MSG_PUB.Count_And_Get

13092: ROLLBACK TO execute_update_budget_pub;
13093:
13094: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13095:
13096: FND_MSG_PUB.Count_And_Get
13097: ( p_count => p_msg_count ,
13098: p_data => p_msg_data );
13099:
13100: WHEN OTHERS THEN

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

13104: ROLLBACK TO execute_update_budget_pub;
13105:
13106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13107:
13108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13109: THEN
13110: FND_MSG_PUB.add_exc_msg
13111: ( p_pkg_name => G_PKG_NAME
13112: , p_procedure_name => l_api_name );

Line 13110: FND_MSG_PUB.add_exc_msg

13106: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13107:
13108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13109: THEN
13110: FND_MSG_PUB.add_exc_msg
13111: ( p_pkg_name => G_PKG_NAME
13112: , p_procedure_name => l_api_name );
13113:
13114: END IF;

Line 13116: FND_MSG_PUB.Count_And_Get

13112: , p_procedure_name => l_api_name );
13113:
13114: END IF;
13115:
13116: FND_MSG_PUB.Count_And_Get
13117: ( p_count => p_msg_count ,
13118: p_data => p_msg_data );
13119:
13120: END execute_update_budget;

Line 13342: FND_MSG_PUB.initialize;

13338:
13339: --Initialize the message table if requested.
13340: IF FND_API.TO_BOOLEAN( p_init_msg_list )
13341: THEN
13342: FND_MSG_PUB.initialize;
13343: END IF;
13344:
13345: --Set API return status to success
13346: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

13808: FETCH l_resource_assignment_csr INTO l_resource_assignment_id;
13809:
13810: IF l_resource_assignment_csr%NOTFOUND
13811: THEN
13812: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13813: THEN
13814: pa_interface_utils_pub.map_new_amg_msg
13815: ( p_old_message_code => 'PA_NO_RESOURCE_ASSIGNMENT'
13816: ,p_msg_attribute => 'CHANGE'

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

13845: ,l_budget_line_id;
13846:
13847: IF l_budget_line_csr%NOTFOUND
13848: THEN
13849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13850: THEN
13851: pa_interface_utils_pub.map_new_amg_msg
13852: ( p_old_message_code => 'PA_BUDGET_LINE_NOT_FOUND'
13853: ,p_msg_attribute => 'CHANGE'

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

13927: pa_debug.g_err_stage := 'summerize_project_totals API falied';
13928: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
13929: END IF;
13930:
13931: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13932: THEN
13933: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
13934: THEN
13935: pa_interface_utils_pub.map_new_amg_msg

Line 13957: END IF;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

13953: ,p_attribute3 => l_budget_type_code
13954: ,p_attribute4 => l_budget_lines_in(1).resource_alias
13955: ,p_attribute5 => to_char(l_budget_lines_in(1).budget_start_date));
13956: END IF;
13957: END IF;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13958:
13959: RAISE FND_API.G_EXC_ERROR;
13960:
13961: ELSIF l_err_code < 0

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

13965: pa_debug.g_err_stage := 'summerize_project_totals API falied';
13966: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
13967: END IF;
13968:
13969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13970: THEN
13971: FND_MSG_PUB.add_exc_msg
13972: ( p_pkg_name => 'PA_BUDGET_UTILS'
13973: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'

Line 13971: FND_MSG_PUB.add_exc_msg

13967: END IF;
13968:
13969: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13970: THEN
13971: FND_MSG_PUB.add_exc_msg
13972: ( p_pkg_name => 'PA_BUDGET_UTILS'
13973: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
13974: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
13975: END IF;

Line 14175: l_msg_count := FND_MSG_PUB.count_msg;

14171:
14172: ROLLBACK TO update_budget_line_pub;
14173:
14174: p_return_status := FND_API.G_RET_STS_ERROR;
14175: l_msg_count := FND_MSG_PUB.count_msg;
14176:
14177: IF l_msg_count = 1 and p_msg_data IS NULL THEN
14178: PA_INTERFACE_UTILS_PUB.get_messages
14179: (p_encoded => FND_API.G_TRUE

Line 14205: FND_MSG_PUB.count_and_get

14201: ROLLBACK TO update_budget_line_pub;
14202:
14203: p_return_status := FND_API.G_RET_STS_ERROR;
14204:
14205: FND_MSG_PUB.count_and_get
14206: ( p_count => p_msg_count ,
14207: p_data => p_msg_data );
14208:
14209: IF ( l_debug_mode = 'Y' ) THEN

Line 14221: FND_MSG_PUB.count_and_get

14217: ROLLBACK TO update_budget_line_pub;
14218:
14219: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14220:
14221: FND_MSG_PUB.count_and_get
14222: ( p_count => p_msg_count ,
14223: p_data => p_msg_data );
14224:
14225: IF ( l_debug_mode = 'Y' ) THEN

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

14233: ROLLBACK TO update_budget_line_pub;
14234:
14235: p_return_status := FND_API.G_RET_STS_ERROR;
14236:
14237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14238: THEN
14239: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);

Line 14246: FND_MSG_PUB.add;

14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14246: FND_MSG_PUB.add;
14247: END IF;
14248:
14249: FND_MSG_PUB.count_and_get
14250: ( p_count => p_msg_count ,

Line 14249: FND_MSG_PUB.count_and_get

14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14246: FND_MSG_PUB.add;
14247: END IF;
14248:
14249: FND_MSG_PUB.count_and_get
14250: ( p_count => p_msg_count ,
14251: p_data => p_msg_data );
14252:
14253: IF ( l_debug_mode = 'Y' ) THEN

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

14261: ROLLBACK TO update_budget_line_pub;
14262:
14263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14264:
14265: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14266: THEN
14267: FND_MSG_PUB.add_exc_msg
14268: ( p_pkg_name => G_PKG_NAME
14269: , p_procedure_name => l_api_name );

Line 14267: FND_MSG_PUB.add_exc_msg

14263: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14264:
14265: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14266: THEN
14267: FND_MSG_PUB.add_exc_msg
14268: ( p_pkg_name => G_PKG_NAME
14269: , p_procedure_name => l_api_name );
14270: END IF;
14271:

Line 14272: FND_MSG_PUB.count_and_get

14268: ( p_pkg_name => G_PKG_NAME
14269: , p_procedure_name => l_api_name );
14270: END IF;
14271:
14272: FND_MSG_PUB.count_and_get
14273: ( p_count => p_msg_count ,
14274: p_data => p_msg_data );
14275:
14276: IF ( l_debug_mode = 'Y' ) THEN

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

14641:
14642: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14643: OR p_pm_product_code IS NULL
14644: THEN
14645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14646: THEN
14647: pa_interface_utils_pub.map_new_amg_msg
14648: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
14649: ,p_msg_attribute => 'CHANGE'

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

14667: CLOSE p_product_code_csr;
14668:
14669: IF l_pm_product_code <> 'X'
14670: THEN
14671: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14672: THEN
14673: pa_interface_utils_pub.map_new_amg_msg
14674: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
14675: ,p_msg_attribute => 'CHANGE'

Line 14756: FND_MSG_PUB.initialize;

14752:
14753: IF FND_API.TO_BOOLEAN( p_init_msg_list )
14754: THEN
14755:
14756: FND_MSG_PUB.initialize;
14757:
14758: END IF;
14759:
14760: -- Set API return status to success

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

15516: -- budget type code is mandatory
15517: IF p_budget_type_code IS NULL
15518: OR p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15519:
15520: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15521: pa_interface_utils_pub.map_new_amg_msg
15522: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
15523: ,p_msg_attribute => 'CHANGE'
15524: ,p_resize_flag => 'N'

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

15544:
15545: FETCH l_budget_type_csr INTO l_dummy;
15546:
15547: IF l_budget_type_csr%NOTFOUND THEN
15548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15549: pa_interface_utils_pub.map_new_amg_msg
15550: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
15551: ,p_msg_attribute => 'CHANGE'
15552: ,p_resize_flag => 'N'

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

15894: OPEN l_task_csr (l_task_id_tbl(i));
15895: FETCH l_task_csr INTO l_pm_task_reference
15896: ,l_task_name; -- Bug 2863564
15897: IF l_task_csr%NOTFOUND THEN
15898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15899: pa_interface_utils_pub.map_new_amg_msg
15900: ( p_old_message_code => 'PA_TASK_ID_INVALID'
15901: ,p_msg_attribute => 'CHANGE'
15902: ,p_resize_flag => 'N'

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

16023: THEN
16024:
16025: IF l_context = l_context_budget
16026: THEN
16027: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16028: THEN
16029:
16030: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
16031: THEN

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

16076:
16077: ELSIF l_err_code < 0
16078: THEN
16079:
16080: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16081: THEN
16082:
16083: FND_MSG_PUB.add_exc_msg
16084: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'

Line 16083: FND_MSG_PUB.add_exc_msg

16079:
16080: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16081: THEN
16082:
16083: FND_MSG_PUB.add_exc_msg
16084: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'
16085: , p_procedure_name => 'CALC_RAW_COST'
16086: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16087:

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

16165: THEN
16166:
16167: IF l_context = l_context_budget
16168: THEN
16169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16170: THEN
16171:
16172: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
16173: THEN

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

16218:
16219: ELSIF l_err_code < 0
16220: THEN
16221:
16222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16223: THEN
16224:
16225: FND_MSG_PUB.add_exc_msg
16226: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'

Line 16225: FND_MSG_PUB.add_exc_msg

16221:
16222: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16223: THEN
16224:
16225: FND_MSG_PUB.add_exc_msg
16226: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'
16227: , p_procedure_name => 'CALC_BURDENED_COST'
16228: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16229:

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

16282: THEN
16283:
16284: IF l_context = l_context_budget
16285: THEN
16286: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16287: THEN
16288:
16289: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
16290: THEN

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

16335:
16336: ELSIF l_err_code < 0
16337: THEN
16338:
16339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16340: THEN
16341:
16342: FND_MSG_PUB.add_exc_msg
16343: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'

Line 16342: FND_MSG_PUB.add_exc_msg

16338:
16339: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16340: THEN
16341:
16342: FND_MSG_PUB.add_exc_msg
16343: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'
16344: , p_procedure_name => 'CALC_REVENUE'
16345: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16346:

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

16529:
16530: IF l_err_code > 0
16531: THEN
16532:
16533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16534: THEN
16535:
16536: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
16537: THEN

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

16569:
16570: ELSIF l_err_code < 0
16571: THEN
16572:
16573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16574: THEN
16575:
16576: FND_MSG_PUB.add_exc_msg
16577: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 16576: FND_MSG_PUB.add_exc_msg

16572:
16573: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16574: THEN
16575:
16576: FND_MSG_PUB.add_exc_msg
16577: ( p_pkg_name => 'PA_BUDGET_UTILS'
16578: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
16579: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16580:

Line 16886: FND_MSG_PUB.Count_And_Get

16882: ROLLBACK TO calculate_amounts_pub;
16883:
16884: p_return_status := FND_API.G_RET_STS_ERROR;
16885:
16886: FND_MSG_PUB.Count_And_Get
16887: (p_count => p_msg_count ,
16888: p_data => p_msg_data );
16889:
16890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 16897: FND_MSG_PUB.Count_And_Get

16893: ROLLBACK TO calculate_amounts_pub;
16894:
16895: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16896:
16897: FND_MSG_PUB.Count_And_Get
16898: (p_count => p_msg_count ,
16899: p_data => p_msg_data );
16900: WHEN OTHERS
16901: THEN

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

16902: ROLLBACK TO calculate_amounts_pub;
16903:
16904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16905:
16906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16907: THEN
16908: FND_MSG_PUB.add_exc_msg
16909: ( p_pkg_name => G_PKG_NAME
16910: ,p_procedure_name => l_api_name );

Line 16908: FND_MSG_PUB.add_exc_msg

16904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16905:
16906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16907: THEN
16908: FND_MSG_PUB.add_exc_msg
16909: ( p_pkg_name => G_PKG_NAME
16910: ,p_procedure_name => l_api_name );
16911: END IF;
16912:

Line 16913: FND_MSG_PUB.Count_And_Get

16909: ( p_pkg_name => G_PKG_NAME
16910: ,p_procedure_name => l_api_name );
16911: END IF;
16912:
16913: FND_MSG_PUB.Count_And_Get
16914: (p_count => p_msg_count ,
16915: p_data => p_msg_data );
16916:
16917: END Calculate_Amounts;

Line 16937: FND_MSG_PUB.Initialize;

16933: --
16934: --
16935: PROCEDURE Init_Calculate_Amounts IS
16936: BEGIN
16937: FND_MSG_PUB.Initialize;
16938: -- Initialize global table and record types
16939: G_calc_budget_lines_tbl_count := 0;
16940: G_calc_budget_lines_out_tbl.delete;
16941: END Init_Calculate_Amounts;

Line 17003: FND_MSG_PUB.initialize;

16999: -- Initialize the message table if requested.
17000:
17001: IF FND_API.TO_BOOLEAN( p_init_msg_list )
17002: THEN
17003: FND_MSG_PUB.initialize;
17004: END IF;
17005: -- Set API return status to success
17006: p_return_status := FND_API.G_RET_STS_SUCCESS;
17007: p_tot_budget_lines_calculated := 0;

Line 17055: FND_MSG_PUB.Count_And_Get

17051: EXCEPTION
17052: WHEN FND_API.G_EXC_ERROR THEN
17053: ROLLBACK TO execute_calculate_amounts;
17054: p_return_status := FND_API.G_RET_STS_ERROR;
17055: FND_MSG_PUB.Count_And_Get
17056: ( p_count => p_msg_count ,
17057: p_data => p_msg_data );
17058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
17059: ROLLBACK TO execute_calculate_amounts;

Line 17061: FND_MSG_PUB.Count_And_Get

17057: p_data => p_msg_data );
17058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
17059: ROLLBACK TO execute_calculate_amounts;
17060: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17061: FND_MSG_PUB.Count_And_Get
17062: ( p_count => p_msg_count ,
17063: p_data => p_msg_data );
17064: WHEN OTHERS THEN
17065: ROLLBACK TO execute_calculate_amounts;

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

17063: p_data => p_msg_data );
17064: WHEN OTHERS THEN
17065: ROLLBACK TO execute_calculate_amounts;
17066: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17067: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17068: THEN
17069: FND_MSG_PUB.add_exc_msg
17070: ( p_pkg_name => G_PKG_NAME
17071: , p_procedure_name => l_api_name );

Line 17069: FND_MSG_PUB.add_exc_msg

17065: ROLLBACK TO execute_calculate_amounts;
17066: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17067: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17068: THEN
17069: FND_MSG_PUB.add_exc_msg
17070: ( p_pkg_name => G_PKG_NAME
17071: , p_procedure_name => l_api_name );
17072: END IF;
17073:

Line 17074: FND_MSG_PUB.Count_And_Get

17070: ( p_pkg_name => G_PKG_NAME
17071: , p_procedure_name => l_api_name );
17072: END IF;
17073:
17074: FND_MSG_PUB.Count_And_Get
17075: ( p_count => p_msg_count ,
17076: p_data => p_msg_data );
17077: END Execute_Calculate_Amounts;
17078:

Line 17140: FND_MSG_PUB.initialize;

17136:
17137: IF FND_API.TO_BOOLEAN( p_init_msg_list )
17138: THEN
17139:
17140: FND_MSG_PUB.initialize;
17141:
17142: END IF;
17143:
17144: -- Set API return status to success

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

17150:
17151: IF p_line_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17152: OR p_line_index IS NULL
17153: THEN
17154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
17155: THEN
17156: pa_interface_utils_pub.map_new_amg_msg
17157: ( p_old_message_code => 'PA_BUGDET_LINE_INDEX_MISSING'
17158: ,p_msg_attribute => 'CHANGE'

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

17214: WHEN OTHERS THEN
17215:
17216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17217:
17218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17219: THEN
17220: FND_MSG_PUB.add_exc_msg
17221: ( p_pkg_name => G_PKG_NAME
17222: , p_procedure_name => l_api_name );

Line 17220: FND_MSG_PUB.add_exc_msg

17216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17217:
17218: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17219: THEN
17220: FND_MSG_PUB.add_exc_msg
17221: ( p_pkg_name => G_PKG_NAME
17222: , p_procedure_name => l_api_name );
17223:
17224: END IF;

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

17349: WHEN OTHERS THEN
17350:
17351: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17352:
17353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17354: THEN
17355: FND_MSG_PUB.add_exc_msg
17356: ( p_pkg_name => G_PKG_NAME
17357: ,p_procedure_name => l_api_name );

Line 17355: FND_MSG_PUB.add_exc_msg

17351: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17352:
17353: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17354: THEN
17355: FND_MSG_PUB.add_exc_msg
17356: ( p_pkg_name => G_PKG_NAME
17357: ,p_procedure_name => l_api_name );
17358:
17359: END IF;

Line 18920: l_msg_count := FND_MSG_PUB.count_msg;

18916: pa_debug.g_err_stage:='In invalid args exception';
18917: pa_debug.write(l_module_name,pa_debug.g_err_stage, 3);
18918: END IF;
18919:
18920: l_msg_count := FND_MSG_PUB.count_msg;
18921: IF l_msg_count = 1 THEN
18922:
18923: IF l_debug_mode = 'Y' THEN
18924: pa_debug.g_err_stage:='In invalid args exception 1';

Line 18963: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

18959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18960: x_msg_count := 1;
18961: x_msg_data := SQLERRM;
18962:
18963: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
18964: ,p_procedure_name => 'Update_Planning_Transactions');
18965:
18966: IF l_debug_mode = 'Y' THEN
18967: pa_debug.g_err_stage:='Unexpected Error' || SQLERRM;

Line 19491: FND_MSG_PUB.initialize;

19487: x_return_status := FND_API.G_RET_STS_SUCCESS;
19488:
19489: IF FND_API.TO_BOOLEAN( p_init_msg_list )
19490: THEN
19491: FND_MSG_PUB.initialize;
19492: END IF;
19493:
19494: --initialize
19495:

Line 19605: FND_MSG_PUB.add;

19601: l_err_field := 'p_distribute_amounts';
19602: FND_MESSAGE.SET_NAME('PA','PA_PMC_INVALID_LOV_VAL');
19603: FND_MESSAGE.SET_TOKEN('VALUE',l_err_value);
19604: FND_MESSAGE.SET_TOKEN('FIELD',l_err_field);
19605: FND_MSG_PUB.add;
19606: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
19607: END IF;
19608: -- Bug 9610380 : End
19609:

Line 19991: l_msg_count := FND_MSG_PUB.count_msg;

19987:
19988: EXCEPTION
19989: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
19990:
19991: l_msg_count := FND_MSG_PUB.count_msg;
19992:
19993: IF l_msg_count = 1 THEN
19994: PA_INTERFACE_UTILS_PUB.get_messages
19995: ( p_encoded => FND_API.G_TRUE

Line 20025: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_PUB'

20021:
20022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20023: x_msg_count := 1;
20024: x_msg_data := SQLERRM;
20025: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_PUB'
20026: ,p_procedure_name => 'update_plannning_element_attr');
20027: IF l_debug_mode = 'Y' THEN
20028: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
20029: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);