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 855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

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

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

Line 898: FND_MSG_PUB.add_exc_msg

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

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

2193:
2194: IF l_err_code > 0
2195: THEN
2196:
2197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2198: THEN
2199: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2200: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2201:

Line 2202: FND_MSG_PUB.add;

2198: THEN
2199: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2200: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2201:
2202: FND_MSG_PUB.add;
2203: END IF;
2204:
2205: IF l_debug_mode = 'Y' THEN
2206: pa_debug.g_err_stage := 'Error executing check_overlapping_dates';

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

2212:
2213: ELSIF l_err_code < 0
2214: THEN
2215:
2216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2217: THEN
2218:
2219: FND_MSG_PUB.add_exc_msg
2220: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'

Line 2219: FND_MSG_PUB.add_exc_msg

2215:
2216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2217: THEN
2218:
2219: FND_MSG_PUB.add_exc_msg
2220: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
2221: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
2222: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2223:

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

2274:
2275: IF l_err_code > 0
2276: THEN
2277:
2278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2279: THEN
2280:
2281: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
2282: THEN

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

2315:
2316: ELSIF l_err_code < 0
2317: THEN
2318:
2319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2320: THEN
2321:
2322: FND_MSG_PUB.add_exc_msg
2323: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 2322: FND_MSG_PUB.add_exc_msg

2318:
2319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2320: THEN
2321:
2322: FND_MSG_PUB.add_exc_msg
2323: ( p_pkg_name => 'PA_BUDGET_UTILS'
2324: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
2325: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
2326:

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

2363:
2364:
2365: EXCEPTION
2366: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2367: -- dbms_output.put_line('MSG count in the stack ' || FND_MSG_PUB.count_msg);
2368: ROLLBACK TO create_draft_budget_pub;
2369:
2370: IF p_return_status IS NULL OR
2371: p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2375: l_msg_count := FND_MSG_PUB.count_msg;

2371: p_return_status = FND_API.G_RET_STS_SUCCESS THEN
2372: p_return_status := FND_API.G_RET_STS_ERROR;
2373: END IF;
2374:
2375: l_msg_count := FND_MSG_PUB.count_msg;
2376: -- dbms_output.put_line('MSG count in the stack ' || l_msg_count);
2377:
2378: IF l_msg_count = 1 AND p_msg_data IS NULL THEN
2379: PA_INTERFACE_UTILS_PUB.get_messages

Line 2410: FND_MSG_PUB.Count_And_Get

2406: ROLLBACK TO create_draft_budget_pub;
2407:
2408: p_return_status := FND_API.G_RET_STS_ERROR;
2409:
2410: FND_MSG_PUB.Count_And_Get
2411: ( p_count => p_msg_count ,
2412: p_data => p_msg_data );
2413: --Changes for bug 3182963
2414: IF l_debug_mode = 'Y' THEN

Line 2428: FND_MSG_PUB.Count_And_Get

2424: ROLLBACK TO create_draft_budget_pub;
2425:
2426: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427:
2428: FND_MSG_PUB.Count_And_Get
2429: ( p_count => p_msg_count ,
2430: p_data => p_msg_data );
2431:
2432: --Changes for bug 3182963

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

2440: ROLLBACK TO create_draft_budget_pub;
2441:
2442: p_return_status := FND_API.G_RET_STS_ERROR;
2443:
2444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2445: THEN
2446: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');

Line 2453: FND_MSG_PUB.ADD;

2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2453: FND_MSG_PUB.ADD;
2454: END IF;
2455:
2456: FND_MSG_PUB.Count_And_Get
2457: ( p_count => p_msg_count ,

Line 2456: FND_MSG_PUB.Count_And_Get

2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2453: FND_MSG_PUB.ADD;
2454: END IF;
2455:
2456: FND_MSG_PUB.Count_And_Get
2457: ( p_count => p_msg_count ,
2458: p_data => p_msg_data );
2459:
2460: --Changes for bug 3182963

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

2471: ROLLBACK TO create_draft_budget_pub;
2472:
2473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2474:
2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2476: THEN
2477: FND_MSG_PUB.add_exc_msg
2478: ( p_pkg_name => G_PKG_NAME
2479: , p_procedure_name => l_api_name );

Line 2477: FND_MSG_PUB.add_exc_msg

2473: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2474:
2475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2476: THEN
2477: FND_MSG_PUB.add_exc_msg
2478: ( p_pkg_name => G_PKG_NAME
2479: , p_procedure_name => l_api_name );
2480:
2481: END IF;

Line 2483: FND_MSG_PUB.Count_And_Get

2479: , p_procedure_name => l_api_name );
2480:
2481: END IF;
2482:
2483: FND_MSG_PUB.Count_And_Get
2484: ( p_count => p_msg_count ,
2485: p_data => p_msg_data );
2486:
2487: --Changes for bug 3182963

Line 2518: FND_MSG_PUB.Initialize;

2514: IS
2515:
2516: BEGIN
2517:
2518: FND_MSG_PUB.Initialize;
2519:
2520: -- Initialize global table and record types
2521:
2522: G_budget_lines_in_tbl.delete;

Line 2656: FND_MSG_PUB.initialize;

2652:
2653: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2654: THEN
2655:
2656: FND_MSG_PUB.initialize;
2657:
2658: END IF;
2659:
2660: -- Set API return status to success

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

2754: ROLLBACK TO load_budget_line_pub;
2755:
2756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757:
2758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2759: THEN
2760: FND_MSG_PUB.add_exc_msg
2761: ( p_pkg_name => G_PKG_NAME
2762: , p_procedure_name => l_api_name );

Line 2760: FND_MSG_PUB.add_exc_msg

2756: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757:
2758: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2759: THEN
2760: FND_MSG_PUB.add_exc_msg
2761: ( p_pkg_name => G_PKG_NAME
2762: , p_procedure_name => l_api_name );
2763:
2764: END IF;

Line 2880: FND_MSG_PUB.initialize;

2876:
2877: IF FND_API.TO_BOOLEAN( p_init_msg_list )
2878: THEN
2879:
2880: FND_MSG_PUB.initialize;
2881:
2882: END IF;
2883:
2884: -- Set API return status to success

Line 2988: FND_MSG_PUB.Count_And_Get

2984: ROLLBACK TO execute_create_budget_pub;
2985:
2986: p_return_status := FND_API.G_RET_STS_ERROR;
2987:
2988: FND_MSG_PUB.Count_And_Get
2989: ( p_count => p_msg_count ,
2990: p_data => p_msg_data );
2991:
2992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 3001: FND_MSG_PUB.Count_And_Get

2997: ROLLBACK TO execute_create_budget_pub;
2998:
2999: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3000:
3001: FND_MSG_PUB.Count_And_Get
3002: ( p_count => p_msg_count ,
3003: p_data => p_msg_data );
3004:
3005: WHEN OTHERS THEN

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

3008: ROLLBACK TO execute_create_budget_pub;
3009:
3010: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3011:
3012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013: THEN
3014: FND_MSG_PUB.add_exc_msg
3015: ( p_pkg_name => G_PKG_NAME
3016: , p_procedure_name => l_api_name );

Line 3014: FND_MSG_PUB.add_exc_msg

3010: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3011:
3012: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013: THEN
3014: FND_MSG_PUB.add_exc_msg
3015: ( p_pkg_name => G_PKG_NAME
3016: , p_procedure_name => l_api_name );
3017:
3018: END IF;

Line 3020: FND_MSG_PUB.Count_And_Get

3016: , p_procedure_name => l_api_name );
3017:
3018: END IF;
3019:
3020: FND_MSG_PUB.Count_And_Get
3021: ( p_count => p_msg_count ,
3022: p_data => p_msg_data );
3023:
3024: END execute_create_draft_budget;

Line 3078: FND_MSG_PUB.initialize;

3074:
3075: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3076: THEN
3077:
3078: FND_MSG_PUB.initialize;
3079:
3080: END IF;
3081:
3082: -- Set API return status to success

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

3088:
3089: IF p_line_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3090: OR p_line_index IS NULL
3091: THEN
3092: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3093: THEN
3094: pa_interface_utils_pub.map_new_amg_msg
3095: ( p_old_message_code => 'PA_BUGDET_LINE_INDEX_MISSING'
3096: ,p_msg_attribute => 'CHANGE'

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

3135: ROLLBACK TO fetch_budget_line_pub;
3136:
3137: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138:
3139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3140: THEN
3141: FND_MSG_PUB.add_exc_msg
3142: ( p_pkg_name => G_PKG_NAME
3143: , p_procedure_name => l_api_name );

Line 3141: FND_MSG_PUB.add_exc_msg

3137: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138:
3139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3140: THEN
3141: FND_MSG_PUB.add_exc_msg
3142: ( p_pkg_name => G_PKG_NAME
3143: , p_procedure_name => l_api_name );
3144:
3145: END IF;

Line 3450: FND_MSG_PUB.initialize;

3446: --Initialize the message table if requested.
3447: IF FND_API.TO_BOOLEAN( p_init_msg_list )
3448: THEN
3449:
3450: FND_MSG_PUB.initialize;
3451:
3452: END IF;
3453:
3454: --Get the user id and responsibility Ids

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

3475: --product_code is mandatory
3476: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3477: OR p_pm_product_code IS NULL
3478: THEN
3479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3480: THEN
3481: pa_interface_utils_pub.map_new_amg_msg
3482: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
3483: ,p_msg_attribute => 'CHANGE'

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

3509: -- dbms_output.put_line('l_pm_product_code is 2'||l_pm_product_code);
3510: IF l_pm_product_code <> 'X'
3511: THEN
3512:
3513: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3514: THEN
3515: pa_interface_utils_pub.map_new_amg_msg
3516: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
3517: ,p_msg_attribute => 'CHANGE'

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

3635: END IF;
3636:
3637: IF l_project_id IS NULL --never happens because previous procedure checks this.
3638: THEN
3639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3640: THEN
3641: pa_interface_utils_pub.map_new_amg_msg
3642: ( p_old_message_code => 'PA_PROJECT_IS_MISSING'
3643: ,p_msg_attribute => 'CHANGE'

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

3753: INTO l_row_found;
3754:
3755: IF l_budget_types_csr%NOTFOUND
3756: THEN
3757: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3758: THEN
3759: pa_interface_utils_pub.map_new_amg_msg
3760: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
3761: ,p_msg_attribute => 'CHANGE'

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

3782:
3783: --Added this validation for bug#4460120
3784: --Verify that the budget is not of type FORECASTING_BUDGET_TYPE
3785: IF p_budget_type_code='FORECASTING_BUDGET_TYPE' THEN
3786: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3787: THEN
3788: PA_UTILS.add_message
3789: (p_app_short_name => 'PA',
3790: p_msg_name => 'PA_FP_CANT_BLINE_FCST_BUD_TYPE');

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

3975:
3976:
3977: IF (nvl(l_fck_req_flag,'N') = 'Y')
3978: THEN
3979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3980: THEN
3981: pa_interface_utils_pub.map_new_amg_msg
3982: ( p_old_message_code => 'PA_BC_BGT_TYPE_IS_BAD_AMG'
3983: ,p_msg_attribute => 'CHANGE'

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

4054: INTO l_budget_versions_rec;
4055:
4056: IF l_budget_versions_csr%NOTFOUND
4057: THEN
4058: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4059: THEN
4060: pa_interface_utils_pub.map_new_amg_msg
4061: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
4062: ,p_msg_attribute => 'CHANGE'

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

4106: END IF;
4107:
4108: IF l_curr_working_version_id IS NULL
4109: THEN
4110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4111: THEN
4112: pa_interface_utils_pub.map_new_amg_msg
4113: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
4114: ,p_msg_attribute => 'CHANGE'

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

4206: INTO l_row_found;
4207:
4208: IF l_budget_lines_csr%NOTFOUND
4209: THEN
4210: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4211: THEN
4212: pa_interface_utils_pub.map_new_amg_msg
4213: ( p_old_message_code => 'PA_NO_BUDGET_LINES'
4214: ,p_msg_attribute => 'CHANGE'

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

4247:
4248: IF l_err_code > 0
4249: THEN
4250:
4251: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4252: THEN
4253:
4254: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4255: THEN

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

4283:
4284: ELSIF l_err_code < 0
4285: THEN
4286:
4287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4288: THEN
4289:
4290: FND_MSG_PUB.add_exc_msg
4291: ( p_pkg_name => 'PA_BUDGET_CORE'

Line 4290: FND_MSG_PUB.add_exc_msg

4286:
4287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4288: THEN
4289:
4290: FND_MSG_PUB.add_exc_msg
4291: ( p_pkg_name => 'PA_BUDGET_CORE'
4292: , p_procedure_name => 'VERIFY'
4293: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4294:

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

4325:
4326: IF ( l_budget_rules_csr%NOTFOUND)
4327: THEN
4328:
4329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4330: THEN
4331: pa_interface_utils_pub.map_new_amg_msg
4332: ( p_old_message_code => 'PA_NO_BUDGET_RULES_ATTR'
4333: ,p_msg_attribute => 'CHANGE'

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

4457: END IF;
4458: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4459:
4460: END IF;
4461: -- dbms_output.put_line('The no of messages in the stack 2 '||FND_MSG_PUB.count_msg);
4462:
4463: END IF;--If for buget model check
4464:
4465: -- dbms_output.put_line('Starting with workflow l_err_code '||l_err_code);

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

4505:
4506: -- dbms_output.put_line('l_err_code after is WD '||l_err_code);
4507: IF (l_err_code > 0)
4508: THEN
4509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4510: THEN
4511: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4512: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4513: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);

Line 4515: FND_MSG_PUB.add;

4511: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4512: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4513: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4514: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4515: FND_MSG_PUB.add;
4516: END IF;
4517:
4518: -- RAISE FND_API.G_EXC_ERROR;
4519: l_any_error_occurred_flag := 'Y';

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

4518: -- RAISE FND_API.G_EXC_ERROR;
4519: l_any_error_occurred_flag := 'Y';
4520: ELSIF (l_err_code < 0)
4521: THEN
4522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4523: THEN
4524: FND_MSG_PUB.add_exc_msg
4525: ( p_pkg_name => 'PA_BUDGET_WF'
4526: , p_procedure_name => 'BUDGET_WF_IS_USED'

Line 4524: FND_MSG_PUB.add_exc_msg

4520: ELSIF (l_err_code < 0)
4521: THEN
4522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4523: THEN
4524: FND_MSG_PUB.add_exc_msg
4525: ( p_pkg_name => 'PA_BUDGET_WF'
4526: , p_procedure_name => 'BUDGET_WF_IS_USED'
4527: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4528: END IF;

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

4571: );
4572:
4573: IF (l_err_code > 0)
4574: THEN
4575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4576: THEN
4577: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4578: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4579: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);

Line 4581: FND_MSG_PUB.add;

4577: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4578: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4579: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4580: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4581: FND_MSG_PUB.add;
4582: END IF;
4583:
4584: RAISE FND_API.G_EXC_ERROR;
4585:

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

4584: RAISE FND_API.G_EXC_ERROR;
4585:
4586: ELSIF (l_err_code < 0)
4587: THEN
4588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4589: THEN
4590: FND_MSG_PUB.add_exc_msg
4591: ( p_pkg_name => 'PA_BUDGET_WF'
4592: , p_procedure_name => 'START_BUDGET_WF'

Line 4590: FND_MSG_PUB.add_exc_msg

4586: ELSIF (l_err_code < 0)
4587: THEN
4588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4589: THEN
4590: FND_MSG_PUB.add_exc_msg
4591: ( p_pkg_name => 'PA_BUDGET_WF'
4592: , p_procedure_name => 'START_BUDGET_WF'
4593: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4594: END IF;

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

4661: /* -- dbms_output.put_line('Err_code: '||l_err_code); */
4662: /* -- dbms_output.put_line('Err_stage: '||l_err_stage); */
4663: /* -- dbms_output.put_line('Err_stack: '||l_err_stack); */
4664:
4665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4666: THEN
4667:
4668: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
4669: THEN

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

4696:
4697: ELSIF l_err_code < 0
4698: THEN
4699:
4700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4701: THEN
4702:
4703: /* -- dbms_output.put_line('Err_code: '||l_err_code); */
4704: /* -- dbms_output.put_line('Err_stage: '||l_err_stage); */

Line 4707: FND_MSG_PUB.add_exc_msg

4703: /* -- dbms_output.put_line('Err_code: '||l_err_code); */
4704: /* -- dbms_output.put_line('Err_stage: '||l_err_stage); */
4705: /* -- dbms_output.put_line('Err_stack: '||l_err_stack); */
4706:
4707: FND_MSG_PUB.add_exc_msg
4708: ( p_pkg_name => 'PA_BUDGET_CORE'
4709: , p_procedure_name => 'BASELINE'
4710: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
4711:

Line 4892: l_msg_count := FND_MSG_PUB.count_msg;

4888: IF p_return_status IS NULL OR
4889: p_return_status = FND_API.G_RET_STS_SUCCESS THEN
4890: p_return_status := FND_API.G_RET_STS_ERROR;
4891: END IF;
4892: l_msg_count := FND_MSG_PUB.count_msg;
4893: IF l_msg_count = 1 THEN
4894: PA_INTERFACE_UTILS_PUB.get_messages
4895: (p_encoded => FND_API.G_TRUE,
4896: p_msg_index => 1,

Line 4919: FND_MSG_PUB.Count_And_Get

4915: ROLLBACK TO baseline_budget_pub;
4916:
4917: p_return_status := FND_API.G_RET_STS_ERROR;
4918:
4919: FND_MSG_PUB.Count_And_Get
4920: ( p_count => p_msg_count ,
4921: p_data => p_msg_data );
4922:
4923: pa_debug.reset_curr_function;

Line 4933: FND_MSG_PUB.Count_And_Get

4929: ROLLBACK TO baseline_budget_pub;
4930:
4931: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4932:
4933: FND_MSG_PUB.Count_And_Get
4934: ( p_count => p_msg_count ,
4935: p_data => p_msg_data );
4936:
4937: pa_debug.reset_curr_function;

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

4942: ROLLBACK TO baseline_budget_pub;
4943:
4944: p_return_status := FND_API.G_RET_STS_ERROR ;
4945:
4946: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4947: THEN
4948: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');

Line 4955: FND_MSG_PUB.Add;

4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4955: FND_MSG_PUB.Add;
4956: END IF;
4957:
4958: FND_MSG_PUB.Count_And_Get
4959: (p_count => p_msg_count

Line 4958: FND_MSG_PUB.Count_And_Get

4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4955: FND_MSG_PUB.Add;
4956: END IF;
4957:
4958: FND_MSG_PUB.Count_And_Get
4959: (p_count => p_msg_count
4960: , p_data => p_msg_data
4961: );
4962: pa_debug.reset_curr_function;

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

4969: ROLLBACK TO baseline_budget_pub;
4970:
4971: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4972:
4973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4974: THEN
4975: FND_MSG_PUB.add_exc_msg
4976: ( p_pkg_name => G_PKG_NAME
4977: , p_procedure_name => l_api_name );

Line 4975: FND_MSG_PUB.add_exc_msg

4971: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4972:
4973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4974: THEN
4975: FND_MSG_PUB.add_exc_msg
4976: ( p_pkg_name => G_PKG_NAME
4977: , p_procedure_name => l_api_name );
4978:
4979: END IF;

Line 4981: FND_MSG_PUB.Count_And_Get

4977: , p_procedure_name => l_api_name );
4978:
4979: END IF;
4980:
4981: FND_MSG_PUB.Count_And_Get
4982: ( p_count => p_msg_count ,
4983: p_data => p_msg_data );
4984:
4985: pa_debug.reset_curr_function;

Line 5153: FND_MSG_PUB.initialize;

5149:
5150: --Initialize the message table if requested.
5151: IF FND_API.TO_BOOLEAN( p_init_msg_list )
5152: THEN
5153: FND_MSG_PUB.initialize;
5154: END IF;
5155:
5156: --Set API return status to success
5157: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

5305: pa_debug.g_err_stage := 'check_overlapping_dates API falied';
5306: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5307: END IF;
5308:
5309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5310: THEN
5311: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5312: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5313:

Line 5314: FND_MSG_PUB.add;

5310: THEN
5311: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5312: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5313:
5314: FND_MSG_PUB.add;
5315: END IF;
5316:
5317: RAISE FND_API.G_EXC_ERROR;
5318:

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

5323: pa_debug.g_err_stage := 'check_overlapping_dates API falied';
5324: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5325: END IF;
5326:
5327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5328: THEN
5329: FND_MSG_PUB.add_exc_msg
5330: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5331: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'

Line 5329: FND_MSG_PUB.add_exc_msg

5325: END IF;
5326:
5327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5328: THEN
5329: FND_MSG_PUB.add_exc_msg
5330: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
5331: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
5332: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5333: END IF;

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

5350: pa_debug.g_err_stage := 'summerize_project_totals API falied';
5351: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5352: END IF;
5353:
5354: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5355: THEN
5356: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
5357: THEN
5358: pa_interface_utils_pub.map_new_amg_msg

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

5387: pa_debug.g_err_stage := 'summerize_project_totals API falied';
5388: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5389: END IF;
5390:
5391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5392: THEN
5393: FND_MSG_PUB.add_exc_msg
5394: ( p_pkg_name => 'PA_BUDGET_UTILS'
5395: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'

Line 5393: FND_MSG_PUB.add_exc_msg

5389: END IF;
5390:
5391: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5392: THEN
5393: FND_MSG_PUB.add_exc_msg
5394: ( p_pkg_name => 'PA_BUDGET_UTILS'
5395: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
5396: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
5397: END IF;

Line 5851: l_msg_count := FND_MSG_PUB.count_msg;

5847:
5848: ROLLBACK TO add_budget_line_pub;
5849:
5850: p_return_status := FND_API.G_RET_STS_ERROR;
5851: l_msg_count := FND_MSG_PUB.count_msg;
5852:
5853: IF l_msg_count = 1 and p_msg_data IS NULL THEN
5854: PA_INTERFACE_UTILS_PUB.get_messages
5855: (p_encoded => FND_API.G_TRUE

Line 5881: FND_MSG_PUB.count_and_get

5877: ROLLBACK TO add_budget_line_pub;
5878:
5879: p_return_status := FND_API.G_RET_STS_ERROR;
5880:
5881: FND_MSG_PUB.count_and_get
5882: ( p_count => p_msg_count ,
5883: p_data => p_msg_data );
5884:
5885: IF ( l_debug_mode = 'Y' ) THEN

Line 5897: FND_MSG_PUB.count_and_get

5893: ROLLBACK TO add_budget_line_pub;
5894:
5895: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5896:
5897: FND_MSG_PUB.count_and_get
5898: ( p_count => p_msg_count ,
5899: p_data => p_msg_data );
5900:
5901: IF ( l_debug_mode = 'Y' ) THEN

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

5909: ROLLBACK TO add_budget_line_pub;
5910:
5911: p_return_status := FND_API.G_RET_STS_ERROR;
5912:
5913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5914: THEN
5915: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);

Line 5922: FND_MSG_PUB.add;

5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5922: FND_MSG_PUB.add;
5923: END IF;
5924:
5925: FND_MSG_PUB.count_and_get
5926: ( p_count => p_msg_count ,

Line 5925: FND_MSG_PUB.count_and_get

5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5922: FND_MSG_PUB.add;
5923: END IF;
5924:
5925: FND_MSG_PUB.count_and_get
5926: ( p_count => p_msg_count ,
5927: p_data => p_msg_data );
5928:
5929: IF ( l_debug_mode = 'Y' ) THEN

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

5937: ROLLBACK TO add_budget_line_pub;
5938:
5939: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5940:
5941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5942: THEN
5943: FND_MSG_PUB.add_exc_msg
5944: ( p_pkg_name => G_PKG_NAME
5945: , p_procedure_name => l_api_name );

Line 5943: FND_MSG_PUB.add_exc_msg

5939: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5940:
5941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5942: THEN
5943: FND_MSG_PUB.add_exc_msg
5944: ( p_pkg_name => G_PKG_NAME
5945: , p_procedure_name => l_api_name );
5946: END IF;
5947:

Line 5948: FND_MSG_PUB.count_and_get

5944: ( p_pkg_name => G_PKG_NAME
5945: , p_procedure_name => l_api_name );
5946: END IF;
5947:
5948: FND_MSG_PUB.count_and_get
5949: ( p_count => p_msg_count ,
5950: p_data => p_msg_data );
5951:
5952: IF ( l_debug_mode = 'Y' ) THEN

Line 6127: FND_MSG_PUB.initialize;

6123:
6124: IF FND_API.TO_BOOLEAN( p_init_msg_list )
6125: THEN
6126:
6127: FND_MSG_PUB.initialize;
6128:
6129: END IF;
6130: -- This api will initialize the data that will be used by the map_new_amg_msg.
6131: l_resp_id := FND_GLOBAL.Resp_id;

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

6200:
6201: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
6202: OR p_pm_product_code IS NULL
6203: THEN
6204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6205: THEN
6206: pa_interface_utils_pub.map_new_amg_msg
6207: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
6208: ,p_msg_attribute => 'CHANGE'

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

6230: CLOSE p_product_code_csr;
6231: IF l_pm_product_code <> 'X'
6232: THEN
6233:
6234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6235: THEN
6236: pa_interface_utils_pub.map_new_amg_msg
6237: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
6238: ,p_msg_attribute => 'CHANGE'

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

6323: FETCH l_budget_type_csr INTO l_dummy;
6324:
6325: IF l_budget_type_csr%NOTFOUND
6326: THEN
6327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6328: THEN
6329: pa_interface_utils_pub.map_new_amg_msg
6330: (p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
6331: ,p_msg_attribute => 'CHANGE'

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

6351: CLOSE l_budget_type_csr;
6352:
6353: --Verify that the budget is not of type FORECASTING_BUDGET_TYPE
6354: IF p_budget_type_code='FORECASTING_BUDGET_TYPE' THEN
6355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6356: THEN
6357: PA_UTILS.add_message
6358: (p_app_short_name => 'PA',
6359: p_msg_name => 'PA_FP_CANT_EDIT_FCST_BUD_TYPE');

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

6376: FETCH l_budget_version_csr INTO l_budget_version_id;
6377:
6378: IF l_budget_version_csr%NOTFOUND
6379: THEN
6380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6381: THEN
6382: pa_interface_utils_pub.map_new_amg_msg
6383: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
6384: ,p_msg_attribute => 'CHANGE'

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

6414: || 'budgetary control is enabled';
6415: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
6416: END IF;
6417:
6418: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6419: THEN
6420: PA_UTILS.ADD_MESSAGE(
6421: p_app_short_name => 'PA'
6422: ,p_msg_name => 'PA_FP_DEL_BC_ENABLED_BV_AMG'

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

6453:
6454: IF l_err_code > 0
6455: THEN
6456:
6457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6458: THEN
6459:
6460: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
6461: THEN

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

6498: ELSIF l_err_code < 0
6499: THEN
6500:
6501:
6502: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6503: THEN
6504: IF(l_debug_mode='Y') THEN
6505: pa_debug.g_err_stage := 'Unexpected Error in Delete draft';
6506: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 6509: FND_MSG_PUB.add_exc_msg

6505: pa_debug.g_err_stage := 'Unexpected Error in Delete draft';
6506: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
6507: END IF;
6508:
6509: FND_MSG_PUB.add_exc_msg
6510: ( p_pkg_name => 'PA_BUDGET_UTILS'
6511: , p_procedure_name => 'DELETE_DRAFT'
6512: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
6513:

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

6553: CLOSE l_use_for_wp_csr;
6554:
6555: IF l_dummy = 1
6556: THEN
6557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6558: THEN
6559: PA_UTILS.add_message
6560: (p_app_short_name => 'PA',
6561: p_msg_name => 'PA_FP_CANT_DEL_WP_DATA');

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

6651: ,x_msg_data => p_msg_data );
6652:
6653: -- If the budget version is a control item version throw error
6654: IF l_ci_id IS NOT NULL THEN
6655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6656: PA_UTILS.ADD_MESSAGE(
6657: p_app_short_name => 'PA'
6658: ,p_msg_name => 'PA_FP_CI_VERSION_NON_EDITABLE'
6659: ,p_token1 => 'BUDGET_VERSION_ID'

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

6684: INTO l_fin_plan_type_name
6685: FROM pa_fin_plan_types_vl
6686: WHERE fin_plan_type_id = l_fin_plan_type_id;
6687:
6688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6689: THEN
6690: PA_UTILS.add_message
6691: (p_app_short_name => 'PA'
6692: ,p_msg_name => 'PA_FP_NO_WORKING_VERSION'

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

6710: --FP M Changes for delete_draft_budget. If the budget version
6711: --belongs to an org forecast project then throw an error
6712: IF (PA_FIN_PLAN_UTILS.is_orgforecast_plan(l_budget_version_id) = 'Y')
6713: THEN
6714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6715: THEN
6716: PA_UTILS.add_message
6717: (p_app_short_name => 'PA',
6718: p_msg_name => 'PA_FP_CANT_DEL_ORG_FCST_PLAN');

Line 6857: l_msg_count := FND_MSG_PUB.count_msg;

6853: EXCEPTION
6854: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6855:
6856: p_return_status := FND_API.G_RET_STS_ERROR;
6857: l_msg_count := FND_MSG_PUB.count_msg;
6858:
6859: IF l_msg_count = 1 and p_msg_data IS NULL THEN
6860: PA_INTERFACE_UTILS_PUB.get_messages
6861: (p_encoded => FND_API.G_TRUE

Line 6884: FND_MSG_PUB.Count_And_Get

6880: ROLLBACK TO delete_draft_budget_pub;
6881:
6882: p_return_status := FND_API.G_RET_STS_ERROR;
6883:
6884: FND_MSG_PUB.Count_And_Get
6885: ( p_count => p_msg_count ,
6886: p_data => p_msg_data );
6887: IF ( l_debug_mode = 'Y' ) THEN
6888: pa_debug.reset_curr_function;

Line 6898: FND_MSG_PUB.Count_And_Get

6894: ROLLBACK TO delete_draft_budget_pub;
6895:
6896: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6897:
6898: FND_MSG_PUB.Count_And_Get
6899: ( p_count => p_msg_count ,
6900: p_data => p_msg_data );
6901: IF ( l_debug_mode = 'Y' ) THEN
6902: pa_debug.reset_curr_function;

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

6907: ROLLBACK TO delete_draft_budget_pub;
6908:
6909: p_return_status := FND_API.G_RET_STS_ERROR;
6910:
6911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6912: THEN
6913: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');

Line 6920: FND_MSG_PUB.ADD;

6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6920: FND_MSG_PUB.ADD;
6921: END IF;
6922:
6923: FND_MSG_PUB.Count_And_Get
6924: ( p_count => p_msg_count ,

Line 6923: FND_MSG_PUB.Count_And_Get

6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6920: FND_MSG_PUB.ADD;
6921: END IF;
6922:
6923: FND_MSG_PUB.Count_And_Get
6924: ( p_count => p_msg_count ,
6925: p_data => p_msg_data );
6926: IF ( l_debug_mode = 'Y' ) THEN
6927: pa_debug.reset_curr_function;

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

6932: ROLLBACK TO delete_draft_budget_pub;
6933:
6934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6935:
6936: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6937: THEN
6938: FND_MSG_PUB.add_exc_msg
6939: ( p_pkg_name => G_PKG_NAME
6940: , p_procedure_name => l_api_name );

Line 6938: FND_MSG_PUB.add_exc_msg

6934: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6935:
6936: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6937: THEN
6938: FND_MSG_PUB.add_exc_msg
6939: ( p_pkg_name => G_PKG_NAME
6940: , p_procedure_name => l_api_name );
6941:
6942: END IF;

Line 6944: FND_MSG_PUB.Count_And_Get

6940: , p_procedure_name => l_api_name );
6941:
6942: END IF;
6943:
6944: FND_MSG_PUB.Count_And_Get
6945: ( p_count => p_msg_count ,
6946: p_data => p_msg_data );
6947: IF ( l_debug_mode = 'Y' ) THEN
6948: pa_debug.reset_curr_function;

Line 7126: FND_MSG_PUB.initialize;

7122: --Initialize the message table if requested.
7123:
7124: IF FND_API.to_boolean( p_init_msg_list )
7125: THEN
7126: FND_MSG_PUB.initialize;
7127: END IF;
7128:
7129: --Standard call to check for call compatibility.
7130:

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

7178:
7179: IF (l_budget_type_code IS NULL AND l_fin_plan_type_name IS NULL AND l_fin_plan_type_id IS NULL)
7180: THEN
7181:
7182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7183: PA_UTILS.add_message
7184: (p_app_short_name => 'PA',
7185: p_msg_name => 'PA_BUDGET_FP_BOTH_MISSING');
7186: END IF;

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

7199: IF ((l_budget_type_code IS NOT NULL) AND
7200: (l_fin_plan_type_name IS NOT NULL OR l_fin_plan_type_id IS NOT NULL ))
7201: THEN
7202:
7203: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7204: PA_UTILS.add_message
7205: (p_app_short_name => 'PA',
7206: p_msg_name => 'PA_BUDGET_FP_BOTH_NOT_NULL');
7207: END IF;

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

7219: --product_code is mandatory
7220: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
7221: OR p_pm_product_code IS NULL
7222: THEN
7223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7224: --This function checks if the message being written to the message table
7225: --is higher or equal to the message level threshold.
7226: THEN
7227: PA_UTILS.add_message

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

7245:
7246: IF l_pm_product_code <> 'X'
7247: THEN
7248:
7249: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7250: THEN
7251: PA_UTILS.add_message
7252: (p_app_short_name => 'PA',
7253: p_msg_name => 'PA_PRODUCT_CODE_IS_INVALID_AMG');

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

7266:
7267: --p_version_number is mandatory
7268: IF l_version_number IS NULL
7269: THEN
7270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7271: THEN
7272: PA_UTILS.add_message
7273: (p_app_short_name => 'PA',
7274: p_msg_name => 'PA_FP_VERSION_NUMBER_REQD');

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

7325: FETCH l_budget_type_csr INTO l_dummy;
7326:
7327: IF l_budget_type_csr%NOTFOUND
7328: THEN
7329: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7330: THEN
7331: PA_INTERFACE_UTILS_PUB.map_new_amg_msg
7332: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
7333: ,p_msg_attribute => 'CHANGE'

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

7359: CLOSE l_budget_version_no_csr;
7360:
7361: IF (l_budget_version_no_rec.budget_version_id IS NULL)
7362: THEN
7363: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7364: THEN
7365: PA_UTILS.add_message
7366: (p_app_short_name => 'PA',
7367: p_msg_name => 'PA_FP_VERSION_NO_IS_INVALID');

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

7377: ELSE --l_budget_version_no_rec has been fetched
7378:
7379: IF (l_budget_version_no_rec.current_flag = 'Y'
7380: OR l_budget_version_no_rec.current_original_flag = 'Y') THEN
7381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7382: PA_UTILS.add_message
7383: (p_app_short_name => 'PA',
7384: p_msg_name => 'PA_FP_DEL_CUR_OR_ORIG_BASELINE');
7385: END IF;

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

7439: || 'budgetary control is enabled';
7440: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7441: END IF;
7442:
7443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7444: THEN
7445: PA_UTILS.ADD_MESSAGE(
7446: p_app_short_name => 'PA'
7447: ,p_msg_name => 'PA_FP_DEL_BC_ENABLED_BV_AMG'

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

7476: ,x_err_stack => l_err_stack );
7477:
7478: IF l_err_code > 0 THEN
7479:
7480: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7481: THEN
7482: IF NOT PA_PROJECT_PVT.check_valid_message(l_err_stage)
7483: THEN
7484: IF(l_debug_mode='Y') THEN

Line 7517: END IF; --FND_MSG_PUB.check_msg_level

7513: ,p_attribute4 => ''
7514: ,p_attribute5 => '');
7515: END IF;
7516:
7517: END IF; --FND_MSG_PUB.check_msg_level
7518: RAISE FND_API.G_EXC_ERROR;
7519:
7520: ELSIF l_err_code < 0 THEN
7521:

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

7518: RAISE FND_API.G_EXC_ERROR;
7519:
7520: ELSIF l_err_code < 0 THEN
7521:
7522: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7523: THEN
7524: IF(l_debug_mode='Y') THEN
7525: pa_debug.g_err_stage := 'Unexpected Error in Delete_draft api';
7526: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 7529: FND_MSG_PUB.add_exc_msg

7525: pa_debug.g_err_stage := 'Unexpected Error in Delete_draft api';
7526: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
7527: END IF;
7528:
7529: FND_MSG_PUB.add_exc_msg
7530: ( p_pkg_name => 'PA_BUDGET_UTILS'
7531: , p_procedure_name => 'DELETE_DRAFT'
7532: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
7533: END IF; --FND_MSG_PUB.check_msg_level

Line 7533: END IF; --FND_MSG_PUB.check_msg_level

7529: FND_MSG_PUB.add_exc_msg
7530: ( p_pkg_name => 'PA_BUDGET_UTILS'
7531: , p_procedure_name => 'DELETE_DRAFT'
7532: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
7533: END IF; --FND_MSG_PUB.check_msg_level
7534:
7535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7536:
7537: END IF; --l_err_code > 0

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

7564: CLOSE l_use_for_wp_csr;
7565:
7566: IF l_dummy = 1
7567: THEN
7568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7569: THEN
7570: PA_UTILS.add_message
7571: (p_app_short_name => 'PA',
7572: p_msg_name => 'PA_FP_CANT_DEL_WP_DATA');

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

7628: CLOSE l_finplan_version_no_csr;
7629:
7630: IF (l_budget_version_id IS NULL)
7631: THEN
7632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7633: THEN
7634: PA_UTILS.add_message
7635: (p_app_short_name => 'PA',
7636: p_msg_name => 'PA_FP_VERSION_NO_IS_INVALID');

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

7646:
7647: --if the budget version belongs to an org forecast project then throw an error
7648: IF (PA_FIN_PLAN_UTILS.is_orgforecast_plan(l_budget_version_id) = 'Y')
7649: THEN
7650: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7651: THEN
7652: PA_UTILS.add_message
7653: (p_app_short_name => 'PA',
7654: p_msg_name => 'PA_FP_CANT_DEL_ORG_FCST_PLAN');

Line 7767: l_msg_count := FND_MSG_PUB.count_msg;

7763: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc
7764: THEN
7765:
7766: p_return_status := FND_API.G_RET_STS_ERROR;
7767: l_msg_count := FND_MSG_PUB.count_msg;
7768:
7769: IF l_msg_count = 1 and p_msg_data IS NULL THEN
7770: PA_INTERFACE_UTILS_PUB.get_messages
7771: (p_encoded => FND_API.G_TRUE

Line 7796: FND_MSG_PUB.count_and_get

7792: ROLLBACK TO delete_baseline_budget_pub;
7793:
7794: p_return_status := FND_API.G_RET_STS_ERROR;
7795:
7796: FND_MSG_PUB.count_and_get
7797: ( p_count => p_msg_count ,
7798: p_data => p_msg_data );
7799:
7800: IF ( l_debug_mode = 'Y' ) THEN

Line 7811: FND_MSG_PUB.count_and_get

7807: ROLLBACK TO delete_baseline_budget_pub;
7808:
7809: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7810:
7811: FND_MSG_PUB.count_and_get
7812: ( p_count => p_msg_count ,
7813: p_data => p_msg_data );
7814:
7815: IF ( l_debug_mode = 'Y' ) THEN

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

7821: ROLLBACK TO delete_baseline_budget_pub;
7822:
7823: p_return_status := FND_API.G_RET_STS_ERROR;
7824:
7825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7826: THEN
7827: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');

Line 7834: FND_MSG_PUB.add;

7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7834: FND_MSG_PUB.add;
7835: END IF;
7836:
7837: FND_MSG_PUB.count_and_get
7838: ( p_count => p_msg_count ,

Line 7837: FND_MSG_PUB.count_and_get

7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7834: FND_MSG_PUB.add;
7835: END IF;
7836:
7837: FND_MSG_PUB.count_and_get
7838: ( p_count => p_msg_count ,
7839: p_data => p_msg_data );
7840:
7841: IF ( l_debug_mode = 'Y' ) THEN

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

7847: ROLLBACK TO delete_baseline_budget_pub;
7848:
7849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7850:
7851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7852: THEN
7853: FND_MSG_PUB.add_exc_msg
7854: ( p_pkg_name => G_PKG_NAME
7855: , p_procedure_name => l_api_name );

Line 7853: FND_MSG_PUB.add_exc_msg

7849: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7850:
7851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7852: THEN
7853: FND_MSG_PUB.add_exc_msg
7854: ( p_pkg_name => G_PKG_NAME
7855: , p_procedure_name => l_api_name );
7856:
7857: END IF;

Line 7859: FND_MSG_PUB.count_and_get

7855: , p_procedure_name => l_api_name );
7856:
7857: END IF;
7858:
7859: FND_MSG_PUB.count_and_get
7860: ( p_count => p_msg_count ,
7861: p_data => p_msg_data );
7862:
7863: IF ( l_debug_mode = 'Y' ) THEN

Line 8120: FND_MSG_PUB.initialize;

8116:
8117: --Initialize the message table if requested.
8118: IF FND_API.TO_BOOLEAN( p_init_msg_list )
8119: THEN
8120: FND_MSG_PUB.initialize;
8121: END IF;
8122:
8123: --Set API return status to success
8124: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

8257: FETCH l_resource_assignment_csr INTO l_resource_assignment_id;
8258:
8259: IF l_resource_assignment_csr%NOTFOUND
8260: THEN
8261: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8262: THEN
8263: pa_interface_utils_pub.map_new_amg_msg
8264: ( p_old_message_code => 'PA_NO_RESOURCE_ASSIGNMENT'
8265: ,p_msg_attribute => 'CHANGE'

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

8291: FETCH l_budget_periods_csr INTO l_start_date;
8292:
8293: IF l_budget_periods_csr%NOTFOUND
8294: THEN
8295: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8296: THEN
8297: pa_interface_utils_pub.map_new_amg_msg
8298: ( p_old_message_code => 'PA_PERIOD_NAME_INVALID'
8299: ,p_msg_attribute => 'CHANGE'

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

8326: FETCH l_start_date_csr INTO l_dummy;
8327:
8328: IF l_start_date_csr%NOTFOUND
8329: THEN
8330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8331: THEN
8332: pa_interface_utils_pub.map_new_amg_msg
8333: ( p_old_message_code => 'PA_START_DATE_INVALID'
8334: ,p_msg_attribute => 'CHANGE'

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

8406: CLOSE l_proj_func_currency_csr;
8407:
8408: IF l_dummy = 0 THEN --currency_code not equal to PFC
8409:
8410: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8411: THEN
8412: PA_UTILS.ADD_MESSAGE
8413: ( p_app_short_name => 'PA',
8414: p_msg_name => 'PA_FP_TXN_NOT_PFC_FOR_APP_REV',

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

8432: CLOSE l_plan_ver_txn_curr_csr;
8433:
8434: IF l_dummy = 0 THEN --currency_code is not valid
8435:
8436: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8437: THEN
8438: PA_UTILS.ADD_MESSAGE
8439: ( p_app_short_name => 'PA',
8440: p_msg_name => 'PA_FP_TXN_NOT_ADDED_FOR_PT',

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

8459: IF (l_multi_curr_flag = 'Y' AND
8460: l_currency_code IS NULL AND
8461: l_start_date IS NOT NULL)
8462: THEN
8463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8464: THEN
8465: PA_UTILS.add_message
8466: (p_app_short_name => 'PA'
8467: ,p_msg_name => 'PA_FP_CURRENCY_NULL_AMG'

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

8505: ((l_start_date IS NOT NULL AND l_etc_start_date > l_start_date) OR l_start_date IS NULL) AND -- Bug 5998035
8506: l_time_phased_code IS NOT NULL AND
8507: l_time_phased_code <> 'N')
8508: THEN
8509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8510: THEN
8511: PA_UTILS.add_message
8512: (p_app_short_name => 'PA'
8513: ,p_msg_name => 'PA_FP_FCST_ACTUALS_AMG'

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

8554: ,l_line_end_date ;
8555:
8556: IF l_budget_line_rowid_csr%NOTFOUND
8557: THEN
8558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8559: THEN
8560: pa_interface_utils_pub.map_new_amg_msg
8561: ( p_old_message_code => 'PA_BUDGET_LINE_NOT_FOUND'
8562: ,p_msg_attribute => 'CHANGE'

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

8597:
8598: WHEN OTHERS
8599: THEN
8600:
8601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8602: THEN
8603: FND_MSG_PUB.add_exc_msg
8604: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
8605: , p_procedure_name => 'DELETE_ROW'

Line 8603: FND_MSG_PUB.add_exc_msg

8599: THEN
8600:
8601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8602: THEN
8603: FND_MSG_PUB.add_exc_msg
8604: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
8605: , p_procedure_name => 'DELETE_ROW'
8606: , p_error_text => SQLCODE );
8607:

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

8665:
8666: IF l_err_code > 0
8667: THEN
8668:
8669: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8670: THEN
8671:
8672: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
8673: THEN

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

8700:
8701: ELSIF l_err_code < 0
8702: THEN
8703:
8704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN
8706:
8707: FND_MSG_PUB.add_exc_msg
8708: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 8707: FND_MSG_PUB.add_exc_msg

8703:
8704: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8705: THEN
8706:
8707: FND_MSG_PUB.add_exc_msg
8708: ( p_pkg_name => 'PA_BUDGET_UTILS'
8709: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
8710: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
8711:

Line 8835: l_msg_count := FND_MSG_PUB.count_msg;

8831:
8832: ROLLBACK TO delete_budget_line_pub;
8833:
8834: p_return_status := FND_API.G_RET_STS_ERROR;
8835: l_msg_count := FND_MSG_PUB.count_msg;
8836:
8837: IF l_msg_count = 1 and p_msg_data IS NULL THEN
8838: PA_INTERFACE_UTILS_PUB.get_messages
8839: (p_encoded => FND_API.G_TRUE

Line 8865: FND_MSG_PUB.Count_And_Get

8861: ROLLBACK TO delete_budget_line_pub;
8862:
8863: p_return_status := FND_API.G_RET_STS_ERROR;
8864:
8865: FND_MSG_PUB.Count_And_Get
8866: ( p_count => p_msg_count ,
8867: p_data => p_msg_data );
8868:
8869: IF ( l_debug_mode = 'Y' ) THEN

Line 8881: FND_MSG_PUB.Count_And_Get

8877: ROLLBACK TO delete_budget_line_pub;
8878:
8879: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8880:
8881: FND_MSG_PUB.Count_And_Get
8882: ( p_count => p_msg_count ,
8883: p_data => p_msg_data );
8884:
8885: IF ( l_debug_mode = 'Y' ) THEN

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

8892: ROLLBACK TO delete_budget_line_pub;
8893:
8894: p_return_status := FND_API.G_RET_STS_ERROR;
8895:
8896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8897: THEN
8898: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);

Line 8905: FND_MSG_PUB.ADD;

8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8905: FND_MSG_PUB.ADD;
8906: END IF;
8907:
8908: FND_MSG_PUB.Count_And_Get
8909: ( p_count => p_msg_count ,

Line 8908: FND_MSG_PUB.Count_And_Get

8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8905: FND_MSG_PUB.ADD;
8906: END IF;
8907:
8908: FND_MSG_PUB.Count_And_Get
8909: ( p_count => p_msg_count ,
8910: p_data => p_msg_data );
8911:
8912: IF ( l_debug_mode = 'Y' ) THEN

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

8919: ROLLBACK TO delete_budget_line_pub;
8920:
8921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8922:
8923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8924: THEN
8925: FND_MSG_PUB.add_exc_msg
8926: ( p_pkg_name => G_PKG_NAME
8927: , p_procedure_name => l_api_name );

Line 8925: FND_MSG_PUB.add_exc_msg

8921: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8922:
8923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8924: THEN
8925: FND_MSG_PUB.add_exc_msg
8926: ( p_pkg_name => G_PKG_NAME
8927: , p_procedure_name => l_api_name );
8928:
8929: END IF;

Line 8931: FND_MSG_PUB.Count_And_Get

8927: , p_procedure_name => l_api_name );
8928:
8929: END IF;
8930:
8931: FND_MSG_PUB.Count_And_Get
8932: ( p_count => p_msg_count ,
8933: p_data => p_msg_data );
8934:
8935: IF ( l_debug_mode = 'Y' ) THEN

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

9677:
9678:
9679: IF l_budget_version_id IS NULL THEN
9680:
9681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9682: THEN
9683: pa_interface_utils_pub.map_new_amg_msg
9684: ( p_old_message_code => 'PA_NO_BUDGET_VERSION'
9685: ,p_msg_attribute => 'CHANGE'

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

9849: IF l_budget_change_reason_csr%NOTFOUND
9850: THEN
9851: CLOSE l_budget_change_reason_csr;
9852:
9853: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9854: THEN
9855: pa_interface_utils_pub.map_new_amg_msg
9856: ( p_old_message_code => 'PA_CHANGE_REASON_INVALID'
9857: ,p_msg_attribute => 'CHANGE'

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

10220: ,p_validate_status => l_validate_status
10221: );
10222: IF l_validate_status = 'N'
10223: THEN
10224: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10225: THEN
10226: pa_interface_utils_pub.map_new_amg_msg
10227: ( p_old_message_code => 'PA_INVALID_FF_VALUES'
10228: ,p_msg_attribute => 'CHANGE'

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

11014:
11015: IF l_budget_periods_csr%NOTFOUND
11016: THEN
11017:
11018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
11019: THEN
11020: pa_interface_utils_pub.map_new_amg_msg
11021: ( p_old_message_code => 'PA_BUDGET_PERIOD_IS_INVALID'
11022: ,p_msg_attribute => 'CHANGE'

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

11045: l_budget_start_date := trunc(l_budget_line_in_rec.budget_start_date);
11046:
11047: ELSE
11048:
11049: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
11050: THEN
11051: pa_interface_utils_pub.map_new_amg_msg
11052: ( p_old_message_code => 'PA_START_DATE_MISSING'
11053: ,p_msg_attribute => 'CHANGE'

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

12449:
12450: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );
12451:
12452: IF l_err_code > 0 THEN
12453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12454: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12455: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12456:
12457: FND_MSG_PUB.add;

Line 12457: FND_MSG_PUB.add;

12453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12454: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12455: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12456:
12457: FND_MSG_PUB.add;
12458: END IF;
12459: RAISE FND_API.G_EXC_ERROR;
12460: ELSIF l_err_code < 0 THEN
12461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

12457: FND_MSG_PUB.add;
12458: END IF;
12459: RAISE FND_API.G_EXC_ERROR;
12460: ELSIF l_err_code < 0 THEN
12461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12462: FND_MSG_PUB.add_exc_msg
12463: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
12464: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
12465: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );

Line 12462: FND_MSG_PUB.add_exc_msg

12458: END IF;
12459: RAISE FND_API.G_EXC_ERROR;
12460: ELSIF l_err_code < 0 THEN
12461: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12462: FND_MSG_PUB.add_exc_msg
12463: ( p_pkg_name => 'PA_BUDGET_LINES_V_PKG'
12464: , p_procedure_name => 'CHECK_OVERLAPPING_DATES'
12465: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12466: END IF;

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

12473: , x_err_stage => l_err_stage
12474: , x_err_stack => l_err_stack );
12475:
12476: IF l_err_code > 0 THEN
12477: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12478: IF NOT pa_project_pvt.check_valid_message(l_err_stage) THEN
12479: pa_interface_utils_pub.map_new_amg_msg
12480: ( p_old_message_code => 'PA_SUMMERIZE_TOTALS_FAILED'
12481: ,p_msg_attribute => 'CHANGE'

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

12500: END IF;
12501: END IF;
12502: RAISE FND_API.G_EXC_ERROR;
12503: ELSIF l_err_code < 0 THEN
12504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12505: FND_MSG_PUB.add_exc_msg
12506: ( p_pkg_name => 'PA_BUDGET_UTILS'
12507: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
12508: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );

Line 12505: FND_MSG_PUB.add_exc_msg

12501: END IF;
12502: RAISE FND_API.G_EXC_ERROR;
12503: ELSIF l_err_code < 0 THEN
12504: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
12505: FND_MSG_PUB.add_exc_msg
12506: ( p_pkg_name => 'PA_BUDGET_UTILS'
12507: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
12508: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
12509:

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

12521:
12522: EXCEPTION
12523:
12524: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12525: -- dbms_output.put_line('Invalid_Arg_Exc MSG count in the stack ' || FND_MSG_PUB.count_msg);
12526: ROLLBACK TO update_budget_pub;
12527:
12528: IF p_return_status IS NULL OR
12529: p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 12533: l_msg_count := FND_MSG_PUB.count_msg;

12529: p_return_status = FND_API.G_RET_STS_SUCCESS THEN
12530: p_return_status := FND_API.G_RET_STS_ERROR;
12531: END IF;
12532:
12533: l_msg_count := FND_MSG_PUB.count_msg;
12534: -- dbms_output.put_line('Invalid_Arg_Exc MSG count in the stack ' || l_msg_count);
12535:
12536: IF l_msg_count = 1 AND p_msg_data IS NULL THEN
12537: PA_INTERFACE_UTILS_PUB.get_messages

Line 12566: FND_MSG_PUB.Count_And_Get

12562: ROLLBACK TO update_budget_pub;
12563:
12564: p_return_status := FND_API.G_RET_STS_ERROR;
12565:
12566: FND_MSG_PUB.Count_And_Get
12567: ( p_count => p_msg_count ,
12568: p_data => p_msg_data );
12569:
12570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 12578: FND_MSG_PUB.Count_And_Get

12574: ROLLBACK TO update_budget_pub;
12575:
12576: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12577:
12578: FND_MSG_PUB.Count_And_Get
12579: ( p_count => p_msg_count ,
12580: p_data => p_msg_data );
12581:
12582: WHEN ROW_ALREADY_LOCKED

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

12584: ROLLBACK TO update_budget_pub;
12585:
12586: p_return_status := FND_API.G_RET_STS_ERROR;
12587:
12588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12589: THEN
12590: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);

Line 12599: FND_MSG_PUB.ADD;

12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12597: fnd_date.date_to_chardate(l_budget_start_date));
12598: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12599: FND_MSG_PUB.ADD;
12600: END IF;
12601:
12602: FND_MSG_PUB.Count_And_Get
12603: ( p_count => p_msg_count ,

Line 12602: FND_MSG_PUB.Count_And_Get

12598: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12599: FND_MSG_PUB.ADD;
12600: END IF;
12601:
12602: FND_MSG_PUB.Count_And_Get
12603: ( p_count => p_msg_count ,
12604: p_data => p_msg_data );
12605:
12606: WHEN OTHERS

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

12610: ROLLBACK TO update_budget_pub;
12611:
12612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12613:
12614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12615: THEN
12616: FND_MSG_PUB.add_exc_msg
12617: ( p_pkg_name => G_PKG_NAME
12618: , p_procedure_name => l_api_name );

Line 12616: FND_MSG_PUB.add_exc_msg

12612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12613:
12614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12615: THEN
12616: FND_MSG_PUB.add_exc_msg
12617: ( p_pkg_name => G_PKG_NAME
12618: , p_procedure_name => l_api_name );
12619:
12620: END IF;

Line 12622: FND_MSG_PUB.Count_And_Get

12618: , p_procedure_name => l_api_name );
12619:
12620: END IF;
12621:
12622: FND_MSG_PUB.Count_And_Get
12623: ( p_count => p_msg_count ,
12624: p_data => p_msg_data );
12625:
12626:

Line 12733: FND_MSG_PUB.initialize;

12729:
12730: IF FND_API.TO_BOOLEAN( p_init_msg_list )
12731: THEN
12732:
12733: FND_MSG_PUB.initialize;
12734:
12735: END IF;
12736:
12737: -- Set API return status to success

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

12743:
12744: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
12745: OR p_pm_product_code IS NULL
12746: THEN
12747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12748: THEN
12749: pa_interface_utils_pub.map_new_amg_msg
12750: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
12751: ,p_msg_attribute => 'CHANGE'

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

12769: CLOSE p_product_code_csr;
12770: IF l_pm_product_code <> 'X'
12771: THEN
12772:
12773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12774: THEN
12775: pa_interface_utils_pub.map_new_amg_msg
12776: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
12777: ,p_msg_attribute => 'CHANGE'

Line 12866: FND_MSG_PUB.Count_And_Get

12862: ROLLBACK TO execute_update_budget_pub;
12863:
12864: p_return_status := FND_API.G_RET_STS_ERROR;
12865:
12866: FND_MSG_PUB.Count_And_Get
12867: ( p_count => p_msg_count ,
12868: p_data => p_msg_data );
12869:
12870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 12879: FND_MSG_PUB.Count_And_Get

12875: ROLLBACK TO execute_update_budget_pub;
12876:
12877: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12878:
12879: FND_MSG_PUB.Count_And_Get
12880: ( p_count => p_msg_count ,
12881: p_data => p_msg_data );
12882:
12883: WHEN OTHERS THEN

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

12887: ROLLBACK TO execute_update_budget_pub;
12888:
12889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12890:
12891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12892: THEN
12893: FND_MSG_PUB.add_exc_msg
12894: ( p_pkg_name => G_PKG_NAME
12895: , p_procedure_name => l_api_name );

Line 12893: FND_MSG_PUB.add_exc_msg

12889: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12890:
12891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12892: THEN
12893: FND_MSG_PUB.add_exc_msg
12894: ( p_pkg_name => G_PKG_NAME
12895: , p_procedure_name => l_api_name );
12896:
12897: END IF;

Line 12899: FND_MSG_PUB.Count_And_Get

12895: , p_procedure_name => l_api_name );
12896:
12897: END IF;
12898:
12899: FND_MSG_PUB.Count_And_Get
12900: ( p_count => p_msg_count ,
12901: p_data => p_msg_data );
12902:
12903: END execute_update_budget;

Line 13116: FND_MSG_PUB.initialize;

13112:
13113: --Initialize the message table if requested.
13114: IF FND_API.TO_BOOLEAN( p_init_msg_list )
13115: THEN
13116: FND_MSG_PUB.initialize;
13117: END IF;
13118:
13119: --Set API return status to success
13120: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

13563: FETCH l_resource_assignment_csr INTO l_resource_assignment_id;
13564:
13565: IF l_resource_assignment_csr%NOTFOUND
13566: THEN
13567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13568: THEN
13569: pa_interface_utils_pub.map_new_amg_msg
13570: ( p_old_message_code => 'PA_NO_RESOURCE_ASSIGNMENT'
13571: ,p_msg_attribute => 'CHANGE'

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

13600: ,l_budget_line_id;
13601:
13602: IF l_budget_line_csr%NOTFOUND
13603: THEN
13604: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13605: THEN
13606: pa_interface_utils_pub.map_new_amg_msg
13607: ( p_old_message_code => 'PA_BUDGET_LINE_NOT_FOUND'
13608: ,p_msg_attribute => 'CHANGE'

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

13682: pa_debug.g_err_stage := 'summerize_project_totals API falied';
13683: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
13684: END IF;
13685:
13686: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13687: THEN
13688: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
13689: THEN
13690: pa_interface_utils_pub.map_new_amg_msg

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

13708: ,p_attribute3 => l_budget_type_code
13709: ,p_attribute4 => l_budget_lines_in(1).resource_alias
13710: ,p_attribute5 => to_char(l_budget_lines_in(1).budget_start_date));
13711: END IF;
13712: END IF;--FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13713:
13714: RAISE FND_API.G_EXC_ERROR;
13715:
13716: ELSIF l_err_code < 0

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

13720: pa_debug.g_err_stage := 'summerize_project_totals API falied';
13721: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
13722: END IF;
13723:
13724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13725: THEN
13726: FND_MSG_PUB.add_exc_msg
13727: ( p_pkg_name => 'PA_BUDGET_UTILS'
13728: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'

Line 13726: FND_MSG_PUB.add_exc_msg

13722: END IF;
13723:
13724: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
13725: THEN
13726: FND_MSG_PUB.add_exc_msg
13727: ( p_pkg_name => 'PA_BUDGET_UTILS'
13728: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
13729: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
13730: END IF;

Line 13929: l_msg_count := FND_MSG_PUB.count_msg;

13925:
13926: ROLLBACK TO update_budget_line_pub;
13927:
13928: p_return_status := FND_API.G_RET_STS_ERROR;
13929: l_msg_count := FND_MSG_PUB.count_msg;
13930:
13931: IF l_msg_count = 1 and p_msg_data IS NULL THEN
13932: PA_INTERFACE_UTILS_PUB.get_messages
13933: (p_encoded => FND_API.G_TRUE

Line 13959: FND_MSG_PUB.count_and_get

13955: ROLLBACK TO update_budget_line_pub;
13956:
13957: p_return_status := FND_API.G_RET_STS_ERROR;
13958:
13959: FND_MSG_PUB.count_and_get
13960: ( p_count => p_msg_count ,
13961: p_data => p_msg_data );
13962:
13963: IF ( l_debug_mode = 'Y' ) THEN

Line 13975: FND_MSG_PUB.count_and_get

13971: ROLLBACK TO update_budget_line_pub;
13972:
13973: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13974:
13975: FND_MSG_PUB.count_and_get
13976: ( p_count => p_msg_count ,
13977: p_data => p_msg_data );
13978:
13979: IF ( l_debug_mode = 'Y' ) THEN

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

13987: ROLLBACK TO update_budget_line_pub;
13988:
13989: p_return_status := FND_API.G_RET_STS_ERROR;
13990:
13991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13992: THEN
13993: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);

Line 14000: FND_MSG_PUB.add;

13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14000: FND_MSG_PUB.add;
14001: END IF;
14002:
14003: FND_MSG_PUB.count_and_get
14004: ( p_count => p_msg_count ,

Line 14003: FND_MSG_PUB.count_and_get

13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14000: FND_MSG_PUB.add;
14001: END IF;
14002:
14003: FND_MSG_PUB.count_and_get
14004: ( p_count => p_msg_count ,
14005: p_data => p_msg_data );
14006:
14007: IF ( l_debug_mode = 'Y' ) THEN

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

14015: ROLLBACK TO update_budget_line_pub;
14016:
14017: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14018:
14019: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14020: THEN
14021: FND_MSG_PUB.add_exc_msg
14022: ( p_pkg_name => G_PKG_NAME
14023: , p_procedure_name => l_api_name );

Line 14021: FND_MSG_PUB.add_exc_msg

14017: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14018:
14019: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
14020: THEN
14021: FND_MSG_PUB.add_exc_msg
14022: ( p_pkg_name => G_PKG_NAME
14023: , p_procedure_name => l_api_name );
14024: END IF;
14025:

Line 14026: FND_MSG_PUB.count_and_get

14022: ( p_pkg_name => G_PKG_NAME
14023: , p_procedure_name => l_api_name );
14024: END IF;
14025:
14026: FND_MSG_PUB.count_and_get
14027: ( p_count => p_msg_count ,
14028: p_data => p_msg_data );
14029:
14030: IF ( l_debug_mode = 'Y' ) THEN

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

14395:
14396: IF p_pm_product_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14397: OR p_pm_product_code IS NULL
14398: THEN
14399: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14400: THEN
14401: pa_interface_utils_pub.map_new_amg_msg
14402: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_MISSING'
14403: ,p_msg_attribute => 'CHANGE'

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

14421: CLOSE p_product_code_csr;
14422:
14423: IF l_pm_product_code <> 'X'
14424: THEN
14425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14426: THEN
14427: pa_interface_utils_pub.map_new_amg_msg
14428: ( p_old_message_code => 'PA_PRODUCT_CODE_IS_INVALID'
14429: ,p_msg_attribute => 'CHANGE'

Line 14510: FND_MSG_PUB.initialize;

14506:
14507: IF FND_API.TO_BOOLEAN( p_init_msg_list )
14508: THEN
14509:
14510: FND_MSG_PUB.initialize;
14511:
14512: END IF;
14513:
14514: -- Set API return status to success

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

15270: -- budget type code is mandatory
15271: IF p_budget_type_code IS NULL
15272: OR p_budget_type_code = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
15273:
15274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15275: pa_interface_utils_pub.map_new_amg_msg
15276: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
15277: ,p_msg_attribute => 'CHANGE'
15278: ,p_resize_flag => 'N'

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

15298:
15299: FETCH l_budget_type_csr INTO l_dummy;
15300:
15301: IF l_budget_type_csr%NOTFOUND THEN
15302: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15303: pa_interface_utils_pub.map_new_amg_msg
15304: ( p_old_message_code => 'PA_BUDGET_TYPE_IS_INVALID'
15305: ,p_msg_attribute => 'CHANGE'
15306: ,p_resize_flag => 'N'

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

15645: OPEN l_task_csr (l_task_id_tbl(i));
15646: FETCH l_task_csr INTO l_pm_task_reference
15647: ,l_task_name; -- Bug 2863564
15648: IF l_task_csr%NOTFOUND THEN
15649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
15650: pa_interface_utils_pub.map_new_amg_msg
15651: ( p_old_message_code => 'PA_TASK_ID_INVALID'
15652: ,p_msg_attribute => 'CHANGE'
15653: ,p_resize_flag => 'N'

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

15774: THEN
15775:
15776: IF l_context = l_context_budget
15777: THEN
15778: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
15779: THEN
15780:
15781: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
15782: THEN

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

15827:
15828: ELSIF l_err_code < 0
15829: THEN
15830:
15831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15832: THEN
15833:
15834: FND_MSG_PUB.add_exc_msg
15835: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'

Line 15834: FND_MSG_PUB.add_exc_msg

15830:
15831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15832: THEN
15833:
15834: FND_MSG_PUB.add_exc_msg
15835: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'
15836: , p_procedure_name => 'CALC_RAW_COST'
15837: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
15838:

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

15916: THEN
15917:
15918: IF l_context = l_context_budget
15919: THEN
15920: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
15921: THEN
15922:
15923: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
15924: THEN

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

15969:
15970: ELSIF l_err_code < 0
15971: THEN
15972:
15973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15974: THEN
15975:
15976: FND_MSG_PUB.add_exc_msg
15977: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'

Line 15976: FND_MSG_PUB.add_exc_msg

15972:
15973: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
15974: THEN
15975:
15976: FND_MSG_PUB.add_exc_msg
15977: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'
15978: , p_procedure_name => 'CALC_BURDENED_COST'
15979: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
15980:

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

16033: THEN
16034:
16035: IF l_context = l_context_budget
16036: THEN
16037: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16038: THEN
16039:
16040: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
16041: THEN

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

16086:
16087: ELSIF l_err_code < 0
16088: THEN
16089:
16090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16091: THEN
16092:
16093: FND_MSG_PUB.add_exc_msg
16094: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'

Line 16093: FND_MSG_PUB.add_exc_msg

16089:
16090: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16091: THEN
16092:
16093: FND_MSG_PUB.add_exc_msg
16094: ( p_pkg_name => 'PA_CLIENT_EXTN_BUDGET'
16095: , p_procedure_name => 'CALC_REVENUE'
16096: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16097:

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

16280:
16281: IF l_err_code > 0
16282: THEN
16283:
16284: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16285: THEN
16286:
16287: IF NOT pa_project_pvt.check_valid_message(l_err_stage)
16288: THEN

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

16320:
16321: ELSIF l_err_code < 0
16322: THEN
16323:
16324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16325: THEN
16326:
16327: FND_MSG_PUB.add_exc_msg
16328: ( p_pkg_name => 'PA_BUDGET_UTILS'

Line 16327: FND_MSG_PUB.add_exc_msg

16323:
16324: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16325: THEN
16326:
16327: FND_MSG_PUB.add_exc_msg
16328: ( p_pkg_name => 'PA_BUDGET_UTILS'
16329: , p_procedure_name => 'SUMMERIZE_PROJECT_TOTALS'
16330: , p_error_text => 'ORA-'||LPAD(substr(l_err_code,2),5,'0') );
16331:

Line 16637: FND_MSG_PUB.Count_And_Get

16633: ROLLBACK TO calculate_amounts_pub;
16634:
16635: p_return_status := FND_API.G_RET_STS_ERROR;
16636:
16637: FND_MSG_PUB.Count_And_Get
16638: (p_count => p_msg_count ,
16639: p_data => p_msg_data );
16640:
16641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 16648: FND_MSG_PUB.Count_And_Get

16644: ROLLBACK TO calculate_amounts_pub;
16645:
16646: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16647:
16648: FND_MSG_PUB.Count_And_Get
16649: (p_count => p_msg_count ,
16650: p_data => p_msg_data );
16651: WHEN OTHERS
16652: THEN

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

16653: ROLLBACK TO calculate_amounts_pub;
16654:
16655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16656:
16657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16658: THEN
16659: FND_MSG_PUB.add_exc_msg
16660: ( p_pkg_name => G_PKG_NAME
16661: ,p_procedure_name => l_api_name );

Line 16659: FND_MSG_PUB.add_exc_msg

16655: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16656:
16657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16658: THEN
16659: FND_MSG_PUB.add_exc_msg
16660: ( p_pkg_name => G_PKG_NAME
16661: ,p_procedure_name => l_api_name );
16662: END IF;
16663:

Line 16664: FND_MSG_PUB.Count_And_Get

16660: ( p_pkg_name => G_PKG_NAME
16661: ,p_procedure_name => l_api_name );
16662: END IF;
16663:
16664: FND_MSG_PUB.Count_And_Get
16665: (p_count => p_msg_count ,
16666: p_data => p_msg_data );
16667:
16668: END Calculate_Amounts;

Line 16688: FND_MSG_PUB.Initialize;

16684: --
16685: --
16686: PROCEDURE Init_Calculate_Amounts IS
16687: BEGIN
16688: FND_MSG_PUB.Initialize;
16689: -- Initialize global table and record types
16690: G_calc_budget_lines_tbl_count := 0;
16691: G_calc_budget_lines_out_tbl.delete;
16692: END Init_Calculate_Amounts;

Line 16754: FND_MSG_PUB.initialize;

16750: -- Initialize the message table if requested.
16751:
16752: IF FND_API.TO_BOOLEAN( p_init_msg_list )
16753: THEN
16754: FND_MSG_PUB.initialize;
16755: END IF;
16756: -- Set API return status to success
16757: p_return_status := FND_API.G_RET_STS_SUCCESS;
16758: p_tot_budget_lines_calculated := 0;

Line 16806: FND_MSG_PUB.Count_And_Get

16802: EXCEPTION
16803: WHEN FND_API.G_EXC_ERROR THEN
16804: ROLLBACK TO execute_calculate_amounts;
16805: p_return_status := FND_API.G_RET_STS_ERROR;
16806: FND_MSG_PUB.Count_And_Get
16807: ( p_count => p_msg_count ,
16808: p_data => p_msg_data );
16809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16810: ROLLBACK TO execute_calculate_amounts;

Line 16812: FND_MSG_PUB.Count_And_Get

16808: p_data => p_msg_data );
16809: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16810: ROLLBACK TO execute_calculate_amounts;
16811: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16812: FND_MSG_PUB.Count_And_Get
16813: ( p_count => p_msg_count ,
16814: p_data => p_msg_data );
16815: WHEN OTHERS THEN
16816: ROLLBACK TO execute_calculate_amounts;

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

16814: p_data => p_msg_data );
16815: WHEN OTHERS THEN
16816: ROLLBACK TO execute_calculate_amounts;
16817: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16819: THEN
16820: FND_MSG_PUB.add_exc_msg
16821: ( p_pkg_name => G_PKG_NAME
16822: , p_procedure_name => l_api_name );

Line 16820: FND_MSG_PUB.add_exc_msg

16816: ROLLBACK TO execute_calculate_amounts;
16817: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16819: THEN
16820: FND_MSG_PUB.add_exc_msg
16821: ( p_pkg_name => G_PKG_NAME
16822: , p_procedure_name => l_api_name );
16823: END IF;
16824:

Line 16825: FND_MSG_PUB.Count_And_Get

16821: ( p_pkg_name => G_PKG_NAME
16822: , p_procedure_name => l_api_name );
16823: END IF;
16824:
16825: FND_MSG_PUB.Count_And_Get
16826: ( p_count => p_msg_count ,
16827: p_data => p_msg_data );
16828: END Execute_Calculate_Amounts;
16829:

Line 16888: FND_MSG_PUB.initialize;

16884:
16885: IF FND_API.TO_BOOLEAN( p_init_msg_list )
16886: THEN
16887:
16888: FND_MSG_PUB.initialize;
16889:
16890: END IF;
16891:
16892: -- Set API return status to success

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

16898:
16899: IF p_line_index = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
16900: OR p_line_index IS NULL
16901: THEN
16902: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
16903: THEN
16904: pa_interface_utils_pub.map_new_amg_msg
16905: ( p_old_message_code => 'PA_BUGDET_LINE_INDEX_MISSING'
16906: ,p_msg_attribute => 'CHANGE'

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

16959: WHEN OTHERS THEN
16960:
16961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16962:
16963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16964: THEN
16965: FND_MSG_PUB.add_exc_msg
16966: ( p_pkg_name => G_PKG_NAME
16967: , p_procedure_name => l_api_name );

Line 16965: FND_MSG_PUB.add_exc_msg

16961: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16962:
16963: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
16964: THEN
16965: FND_MSG_PUB.add_exc_msg
16966: ( p_pkg_name => G_PKG_NAME
16967: , p_procedure_name => l_api_name );
16968:
16969: END IF;

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

17090: WHEN OTHERS THEN
17091:
17092: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17093:
17094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17095: THEN
17096: FND_MSG_PUB.add_exc_msg
17097: ( p_pkg_name => G_PKG_NAME
17098: ,p_procedure_name => l_api_name );

Line 17096: FND_MSG_PUB.add_exc_msg

17092: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17093:
17094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
17095: THEN
17096: FND_MSG_PUB.add_exc_msg
17097: ( p_pkg_name => G_PKG_NAME
17098: ,p_procedure_name => l_api_name );
17099:
17100: END IF;

Line 18648: l_msg_count := FND_MSG_PUB.count_msg;

18644: pa_debug.g_err_stage:='In invalid args exception';
18645: pa_debug.write(l_module_name,pa_debug.g_err_stage, 3);
18646: END IF;
18647:
18648: l_msg_count := FND_MSG_PUB.count_msg;
18649: IF l_msg_count = 1 THEN
18650:
18651: IF l_debug_mode = 'Y' THEN
18652: pa_debug.g_err_stage:='In invalid args exception 1';

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

18687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18688: x_msg_count := 1;
18689: x_msg_data := SQLERRM;
18690:
18691: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
18692: ,p_procedure_name => 'Update_Planning_Transactions');
18693:
18694: IF l_debug_mode = 'Y' THEN
18695: pa_debug.g_err_stage:='Unexpected Error' || SQLERRM;

Line 19193: FND_MSG_PUB.initialize;

19189: x_return_status := FND_API.G_RET_STS_SUCCESS;
19190:
19191: IF FND_API.TO_BOOLEAN( p_init_msg_list )
19192: THEN
19193: FND_MSG_PUB.initialize;
19194: END IF;
19195:
19196: --initialize
19197:

Line 19636: l_msg_count := FND_MSG_PUB.count_msg;

19632:
19633: EXCEPTION
19634: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
19635:
19636: l_msg_count := FND_MSG_PUB.count_msg;
19637:
19638: IF l_msg_count = 1 THEN
19639: PA_INTERFACE_UTILS_PUB.get_messages
19640: ( p_encoded => FND_API.G_TRUE

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

19666:
19667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19668: x_msg_count := 1;
19669: x_msg_data := SQLERRM;
19670: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_PUB'
19671: ,p_procedure_name => 'update_plannning_element_attr');
19672: IF l_debug_mode = 'Y' THEN
19673: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
19674: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);