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.0 2006/11/24 09:10:30 vgottimu noship $*/
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.0 2006/11/24 09:10:30 vgottimu noship $*/
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 660: pa_debug.g_err_stage:= ' Starting the PA_CONTROL_API_PVT.add_supplier_details ';

656: end if;
657:
658:
659: if l_debug_mode = 'Y' then
660: pa_debug.g_err_stage:= ' Starting the PA_CONTROL_API_PVT.add_supplier_details ';
661: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
662: end if;
663:
664: l_org_id := FND_GLOBAL.org_id;

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

1200: when others then
1201: x_return_status := fnd_api.g_ret_sts_unexp_error;
1202: x_rowid := null; --assign to the initial value
1203: x_ci_transaction_id := null; --assign to the initial value
1204: fnd_msg_pub.add_exc_msg ( p_pkg_name => 'PA_CONTROL_API_PVT',
1205: p_procedure_name => 'update_impacts',
1206: p_error_text => substrb(sqlerrm,1,240));
1207: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1208: p_data => x_msg_data);

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

1291: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1292: l_module_name := 'check_create_ci_allowed' || g_module_name;
1293:
1294: if l_debug_mode = 'Y' then
1295: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_ci_allowed', p_debug_mode => l_debug_mode);
1296: end if;
1297:
1298: if l_debug_mode = 'Y' then
1299: pa_debug.write(l_module_name, 'start of check_create_ci_allowed', l_debug_level3);

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

1486: --raise the exception
1487: raise;
1488: when others then
1489: x_return_status := fnd_api.g_ret_sts_unexp_error;
1490: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
1491: p_procedure_name => 'check_create_ci_allowed',
1492: p_error_text => substrb(sqlerrm,1,240));
1493: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1494: p_data => x_msg_data);

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

1789: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
1790: l_module_name := 'validate_param_and_create' || g_module_name;
1791:
1792: if l_debug_mode = 'Y' then
1793: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_param_and_create', p_debug_mode => l_debug_mode);
1794: end if;
1795:
1796: if l_debug_mode = 'Y' then
1797: pa_debug.write(l_module_name, 'start of validate_param_and_create', l_debug_level3);

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

2402: --raise the exception
2403: raise;
2404: when others then
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
2407: p_procedure_name => 'validate_param_and_create',
2408: p_error_text => substrb(sqlerrm,1,240));
2409: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2410: p_data => x_msg_data);

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

2454: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2455: l_module_name := 'check_create_action_allow' || g_module_name;
2456:
2457: if l_debug_mode = 'Y' then
2458: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.check_create_action_allow', p_debug_mode => l_debug_mode);
2459: end if;
2460:
2461: if l_debug_mode = 'Y' then
2462: pa_debug.write(l_module_name, 'start of check_create_action_allow', l_debug_level3);

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

2555: --raise the exception
2556: raise;
2557: when others then
2558: x_return_status := fnd_api.g_ret_sts_unexp_error;
2559: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
2560: p_procedure_name => 'check_create_action_allow',
2561: p_error_text => substrb(sqlerrm,1,240));
2562: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2563: p_data => x_msg_data);

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

2620: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2621: l_module_name := 'validate_assignee_id' || g_module_name;
2622:
2623: if l_debug_mode = 'Y' then
2624: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_assignee_id', p_debug_mode => l_debug_mode);
2625: end if;
2626:
2627: if l_debug_mode = 'Y' then
2628: pa_debug.write(l_module_name, 'start of validate_assignee_id', l_debug_level3);

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

2709: end if;
2710:
2711: when others then
2712: x_return_status := fnd_api.g_ret_sts_unexp_error;
2713: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
2714: p_procedure_name => 'validate_assignee_id',
2715: p_error_text => substrb(sqlerrm,1,240));
2716: fnd_msg_pub.count_and_get(p_count => x_msg_count,
2717: p_data => x_msg_data);

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

2791: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
2792: l_module_name := 'validate_action_attributes' || g_module_name;
2793:
2794: if l_debug_mode = 'Y' then
2795: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.validate_action_attributes', p_debug_mode => l_debug_mode);
2796: end if;
2797:
2798: if l_debug_mode = 'Y' then
2799: pa_debug.write(l_module_name, 'start of validate_action_attributes', l_debug_level3);

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

3057: --raise the exception
3058: raise;
3059: when others then
3060: x_return_status := fnd_api.g_ret_sts_unexp_error;
3061: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
3062: p_procedure_name => 'validate_action_attributes',
3063: p_error_text => substrb(sqlerrm,1,240));
3064: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3065: p_data => x_msg_data);

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

3113: l_debug_mode := NVL(FND_PROFILE.VALUE_SPECIFIC('PA_DEBUG_MODE', fnd_global.user_id, fnd_global.resp_id, 275, null, null), 'N');
3114: l_module_name := 'create_action' || g_module_name;
3115:
3116: if l_debug_mode = 'Y' then
3117: pa_debug.set_curr_function(p_function => 'pa_control_api_pvt.create_action', p_debug_mode => l_debug_mode);
3118: end if;
3119:
3120: if l_debug_mode = 'Y' then
3121: pa_debug.write(l_module_name, 'start of create_action', l_debug_level3);

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

3306: --raise the exception;
3307: raise;
3308: when others then
3309: x_return_status := fnd_api.g_ret_sts_unexp_error;
3310: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
3311: p_procedure_name => 'create_action',
3312: p_error_text => substrb(sqlerrm,1,240));
3313: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3314: p_data => x_msg_data);

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

3494: --raise the exception
3495: raise;
3496: when others then
3497: x_return_status := fnd_api.g_ret_sts_unexp_error;
3498: fnd_msg_pub.add_exc_msg(p_pkg_name => 'pa_control_api_pvt',
3499: p_procedure_name => 'validate_priv_and_action',
3500: p_error_text => substrb(sqlerrm,1,240));
3501: fnd_msg_pub.count_and_get(p_count => x_msg_count,
3502: p_data => x_msg_data);

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

3555: if l_debug_mode = 'Y' then
3556: pa_debug.write(l_module_name, 'start of Delete_CI', l_debug_level3);
3557: end if;
3558: -- Initialize the Error Stack.
3559: --PA_DEBUG.Init_Err_Stack ('PA_CONTROL_API_PVT.Delete_CI');
3560:
3561: -- Initialize the Return Status to Success.
3562: x_Return_Status := FND_API.g_Ret_Sts_Success;
3563: x_Msg_Count := 0;

Line 3744: p_Pkg_Name => 'PA_CONTROL_API_PVT',

3740: x_Return_Status := FND_API.g_Ret_Sts_Unexp_Error;
3741:
3742: -- Add the message that is reported in SQL Error.
3743: FND_MSG_PUB.Add_Exc_Msg (
3744: p_Pkg_Name => 'PA_CONTROL_API_PVT',
3745: p_Procedure_Name => 'Delete_CI',
3746: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
3747: );
3748:

Line 3764: END PA_CONTROL_API_PVT;

3760: RAISE;
3761: END Delete_CI;
3762:
3763:
3764: END PA_CONTROL_API_PVT;