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_CONTROL_API_PVT dependencies on PA_CONTROL_API_PVT

Line 1: package body PA_CONTROL_API_PVT as

1: package body PA_CONTROL_API_PVT as
2: /*$Header: PACIAMVB.pls 120.2 2010/03/24 11:06:16 jravisha ship $*/
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_CONTROL_API_PVT';
5:

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_CONTROL_API_PVT';

1: package body PA_CONTROL_API_PVT as
2: /*$Header: PACIAMVB.pls 120.2 2010/03/24 11:06:16 jravisha ship $*/
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_CONTROL_API_PVT';
5:
6:
7:
8: api_error Exception;

Line 132: l_module_name VARCHAR2(200):='PA_CONTROL_API_PVT.UPDATE_IMPACTS';

128: l_version_number NUMBER(15);
129: l_data VARCHAR2(2000);
130: l_msg_data VARCHAR2(2000);
131: l_msg_index_out NUMBER;
132: l_module_name VARCHAR2(200):='PA_CONTROL_API_PVT.UPDATE_IMPACTS';
133: l_msg_count NUMBER := 0;
134:
135:
136: c_check_impact_exists_rec c_check_impact_exists %rowtype;

Line 443: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PVT',

439:
440: when others then
441: x_ci_impact_id := null;
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PVT',
444: p_procedure_name => 'update_impacts',
445: p_error_text => substrb(sqlerrm,1,240));
446: fnd_msg_pub.count_and_get(p_count => x_msg_count,
447: p_data => x_msg_data);

Line 501: l_module_name VARCHAR2(200) := 'PA_CONTROL_API_PVT.add_supplier_details';

497: l_org_id po_headers_all.org_id%TYPE := null;
498: l_data VARCHAR2(2000);
499: l_msg_data VARCHAR2(2000);
500: l_msg_index_out NUMBER;
501: l_module_name VARCHAR2(200) := 'PA_CONTROL_API_PVT.add_supplier_details';
502: l_msg_count NUMBER := 0;
503: l_record_status VARCHAR2(20) := 'NEW';
504:
505:

Line 664: pa_debug.g_err_stage:= ' Starting the PA_CONTROL_API_PVT.add_supplier_details ';

660: end if;
661:
662:
663: if l_debug_mode = 'Y' then
664: pa_debug.g_err_stage:= ' Starting the PA_CONTROL_API_PVT.add_supplier_details ';
665: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
666: end if;
667:
668: l_org_id := FND_GLOBAL.org_id;

Line 1221: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PVT',

1217: when others then
1218: x_return_status := fnd_api.g_ret_sts_unexp_error;
1219: x_rowid := null; --assign to the initial value
1220: x_ci_transaction_id := null; --assign to the initial value
1221: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PVT',
1222: p_procedure_name => 'update_impacts',
1223: p_error_text => substrb(sqlerrm,1,240));
1224: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1225: p_data => x_msg_data);

Line 1312: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_ci_allowed', p_debug_mode => l_debug_mode);

1308: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1309: l_module_name := 'check_create_ci_allowed' || g_module_name;
1310:
1311: if l_debug_mode = 'Y' then
1312: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_ci_allowed', p_debug_mode => l_debug_mode);
1313: end if;
1314:
1315: if l_debug_mode = 'Y' then
1316: pa_debug.write(l_module_name, 'start of check_create_ci_allowed', l_debug_level3);

Line 1507: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

1503: --raise the exception
1504: raise;
1505: when others then
1506: x_return_status := fnd_api.g_ret_sts_unexp_error;
1507: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
1508: p_procedure_name => 'check_create_ci_allowed',
1509: p_error_text => substrb(sqlerrm,1,240));
1510: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1511: p_data => x_msg_data);

Line 1810: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_param_and_create', p_debug_mode => l_debug_mode);

1806: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1807: l_module_name := 'validate_param_and_create' || g_module_name;
1808:
1809: if l_debug_mode = 'Y' then
1810: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_param_and_create', p_debug_mode => l_debug_mode);
1811: end if;
1812:
1813: if l_debug_mode = 'Y' then
1814: pa_debug.write(l_module_name, 'start of validate_param_and_create', l_debug_level3);

Line 2423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

2419: --raise the exception
2420: raise;
2421: when others then
2422: x_return_status := fnd_api.g_ret_sts_unexp_error;
2423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
2424: p_procedure_name => 'validate_param_and_create',
2425: p_error_text => substrb(sqlerrm,1,240));
2426: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2427: p_data => x_msg_data);

Line 2475: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_action_allow', p_debug_mode => l_debug_mode);

2471: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2472: l_module_name := 'check_create_action_allow' || g_module_name;
2473:
2474: if l_debug_mode = 'Y' then
2475: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_action_allow', p_debug_mode => l_debug_mode);
2476: end if;
2477:
2478: if l_debug_mode = 'Y' then
2479: pa_debug.write(l_module_name, 'start of check_create_action_allow', l_debug_level3);

Line 2576: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

2572: --raise the exception
2573: raise;
2574: when others then
2575: x_return_status := fnd_api.g_ret_sts_unexp_error;
2576: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
2577: p_procedure_name => 'check_create_action_allow',
2578: p_error_text => substrb(sqlerrm,1,240));
2579: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2580: p_data => x_msg_data);

Line 2641: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_assignee_id', p_debug_mode => l_debug_mode);

2637: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2638: l_module_name := 'validate_assignee_id' || g_module_name;
2639:
2640: if l_debug_mode = 'Y' then
2641: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_assignee_id', p_debug_mode => l_debug_mode);
2642: end if;
2643:
2644: if l_debug_mode = 'Y' then
2645: pa_debug.write(l_module_name, 'start of validate_assignee_id', l_debug_level3);

Line 2730: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

2726: end if;
2727:
2728: when others then
2729: x_return_status := fnd_api.g_ret_sts_unexp_error;
2730: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
2731: p_procedure_name => 'validate_assignee_id',
2732: p_error_text => substrb(sqlerrm,1,240));
2733: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2734: p_data => x_msg_data);

Line 2812: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_action_attributes', p_debug_mode => l_debug_mode);

2808: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2809: l_module_name := 'validate_action_attributes' || g_module_name;
2810:
2811: if l_debug_mode = 'Y' then
2812: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_action_attributes', p_debug_mode => l_debug_mode);
2813: end if;
2814:
2815: if l_debug_mode = 'Y' then
2816: pa_debug.write(l_module_name, 'start of validate_action_attributes', l_debug_level3);

Line 3078: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

3074: --raise the exception
3075: raise;
3076: when others then
3077: x_return_status := fnd_api.g_ret_sts_unexp_error;
3078: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
3079: p_procedure_name => 'validate_action_attributes',
3080: p_error_text => substrb(sqlerrm,1,240));
3081: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3082: p_data => x_msg_data);

Line 3134: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.create_action', p_debug_mode => l_debug_mode);

3130: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3131: l_module_name := 'create_action' || g_module_name;
3132:
3133: if l_debug_mode = 'Y' then
3134: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.create_action', p_debug_mode => l_debug_mode);
3135: end if;
3136:
3137: if l_debug_mode = 'Y' then
3138: pa_debug.write(l_module_name, 'start of create_action', l_debug_level3);

Line 3327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

3323: --raise the exception;
3324: raise;
3325: when others then
3326: x_return_status := fnd_api.g_ret_sts_unexp_error;
3327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
3328: p_procedure_name => 'create_action',
3329: p_error_text => substrb(sqlerrm,1,240));
3330: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3331: p_data => x_msg_data);

Line 3515: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',

3511: --raise the exception
3512: raise;
3513: when others then
3514: x_return_status := fnd_api.g_ret_sts_unexp_error;
3515: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
3516: p_procedure_name => 'validate_priv_and_action',
3517: p_error_text => substrb(sqlerrm,1,240));
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3519: p_data => x_msg_data);

Line 3576: --PA_DEBUG.Init_Err_Stack ('PA_CONTROL_API_PVT.Delete_CI');

3572: if l_debug_mode = 'Y' then
3573: pa_debug.write(l_module_name, 'start of Delete_CI', l_debug_level3);
3574: end if;
3575: -- Initialize the Error Stack.
3576: --PA_DEBUG.Init_Err_Stack ('PA_CONTROL_API_PVT.Delete_CI');
3577:
3578: -- Initialize the Return Status to Success.
3579: x_Return_Status := FND_API.g_Ret_Sts_Success;
3580: x_Msg_Count := 0;

Line 3761: p_Pkg_Name => 'PA_CONTROL_API_PVT',

3757: x_Return_Status := FND_API.g_Ret_Sts_Unexp_Error;
3758:
3759: -- Add the message that is reported in SQL Error.
3760: FND_MSG_PUB.Add_Exc_Msg (
3761: p_Pkg_Name => 'PA_CONTROL_API_PVT',
3762: p_Procedure_Name => 'Delete_CI',
3763: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
3764: );
3765:

Line 3781: END PA_CONTROL_API_PVT;

3777: RAISE;
3778: END Delete_CI;
3779:
3780:
3781: END PA_CONTROL_API_PVT;