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 FND_MSG_PUB

Line 417: l_msg_count := fnd_msg_pub.count_msg;

413:
414: when FND_API.G_EXC_ERROR then
415: x_ci_impact_id := null;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: l_msg_count := fnd_msg_pub.count_msg;
418: if l_msg_count = 1 then
419: pa_interface_utils_pub.get_messages
420: (p_encoded => fnd_api.g_false,
421: p_msg_index => 1,

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 446: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
448: --Reset the stack
449: if l_debug_mode = 'Y' then
450: pa_debug.reset_curr_function;

Line 1177: l_msg_count := fnd_msg_pub.count_msg;

1173: Exception
1174:
1175: when FND_API.G_EXC_ERROR then
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: l_msg_count := fnd_msg_pub.count_msg;
1178: x_rowid := null; --assign to the initial value
1179: x_ci_transaction_id := null; --assign to the initial value
1180: if l_msg_count = 1 then
1181: pa_interface_utils_pub.get_messages

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 1207: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
1209: --Reset the stack
1210: if l_debug_mode = 'Y' then
1211: pa_debug.reset_curr_function;

Line 1460: l_msg_count := fnd_msg_pub.count_msg;

1456:
1457: exception
1458: when fnd_api.g_exc_error then
1459: x_return_status := fnd_api.g_ret_sts_error;
1460: l_msg_count := fnd_msg_pub.count_msg;
1461: if l_msg_count = 1 then
1462: pa_interface_utils_pub.get_messages
1463: (p_encoded => fnd_api.g_false,
1464: p_msg_index => 1,

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 1493: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
1495: /*Initialize the out variables back to null*/
1496: x_ci_type_class_code := null;
1497: x_auto_number_flag := null;

Line 2365: FND_MSG_PUB.Count_And_Get(

2361:
2362: exception
2363: when fnd_api.g_exc_unexpected_error then
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2365: FND_MSG_PUB.Count_And_Get(
2366: p_count => x_msg_count ,
2367: p_data => x_msg_data );
2368: /*Initialize the out variables back to null*/
2369: x_ci_id := null;

Line 2379: l_msg_count := fnd_msg_pub.count_msg;

2375: --raise the exception
2376: raise;
2377: when fnd_api.g_exc_error then
2378: x_return_status := fnd_api.g_ret_sts_error;
2379: l_msg_count := fnd_msg_pub.count_msg;
2380: if l_msg_count = 1 then
2381: pa_interface_utils_pub.get_messages
2382: (p_encoded => fnd_api.g_false,
2383: p_msg_index => 1,

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 2409: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
2411:
2412: /*Initialize the out variables back to null*/
2413: x_ci_id := null;

Line 2534: l_msg_count := fnd_msg_pub.count_msg;

2530:
2531: Exception
2532: when fnd_api.g_exc_error then
2533: x_return_status := fnd_api.g_ret_sts_error;
2534: l_msg_count := fnd_msg_pub.count_msg;
2535: if l_msg_count = 1 then
2536: pa_interface_utils_pub.get_messages
2537: (p_encoded => fnd_api.g_false,
2538: p_msg_index => 1,

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 2562: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
2564: /*initializing the out variables to null*/
2565: x_project_id := null;
2566: /* no in/out paramters to be set to their initial values here*/

Line 2689: l_msg_count := fnd_msg_pub.count_msg;

2685:
2686: Exception
2687: when fnd_api.g_exc_error then
2688: x_return_status := fnd_api.g_ret_sts_error;
2689: l_msg_count := fnd_msg_pub.count_msg;
2690: if l_msg_count = 1 then
2691: pa_interface_utils_pub.get_messages
2692: (p_encoded => fnd_api.g_false,
2693: p_msg_index => 1,

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 2716: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
2718: /*inititalise the out variables to null here*/
2719: x_assignee_id := null;
2720: /* no in/out paramters to be set to their initial values here*/

Line 3037: l_msg_count := fnd_msg_pub.count_msg;

3033:
3034: Exception
3035: when fnd_api.g_exc_error then
3036: x_return_status := fnd_api.g_ret_sts_error;
3037: l_msg_count := fnd_msg_pub.count_msg;
3038: if l_msg_count = 1 then
3039: pa_interface_utils_pub.get_messages
3040: (p_encoded => fnd_api.g_false,
3041: p_msg_index => 1,

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 3064: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
3066: /*Not initializing the out table of records to null as it wont be used in the calling API if exception occurs*/
3067: /* no in/out paramters to be set to their initial values here*/
3068: --reset the err stack

Line 3296: FND_MSG_PUB.Count_And_Get(

3292: When fnd_api.g_exc_unexpected_error then
3293:
3294: x_return_status := fnd_api.g_ret_sts_unexp_error;
3295: --do a rollback;
3296: FND_MSG_PUB.Count_And_Get(
3297: p_count => x_msg_count ,
3298: p_data => x_msg_data );
3299:
3300: /*Not initializing the out table of records to null as it wont be used in the calling API if exception occurs*/

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 3313: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
3315: /*Not initializing the out table of records to null as it wont be used in the calling API if exception occurs*/
3316: /* no in/out paramters to be set to their initial values here*/
3317: --reset the err stack

Line 3469: l_msg_count := fnd_msg_pub.count_msg;

3465: --do the exception handling;
3466: exception
3467: when fnd_api.g_exc_error then
3468: x_return_status := fnd_api.g_ret_sts_error;
3469: l_msg_count := fnd_msg_pub.count_msg;
3470: if l_msg_count = 1 then
3471: pa_interface_utils_pub.get_messages
3472: (p_encoded => fnd_api.g_false,
3473: p_msg_index => 1,

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 3501: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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);
3503:
3504: /*Initialize the out variables back to null*/
3505: x_action_id := null;

Line 3567: FND_MSG_PUB.Initialize;

3563: x_Msg_Count := 0;
3564:
3565: -- Clear the Global PL/SQL Message table.
3566: IF (FND_API.To_Boolean (p_Init_Msg_List)) THEN
3567: FND_MSG_PUB.Initialize;
3568: END IF;
3569:
3570: -- If the Ci_Id that is passed in is NULL then report
3571: -- Error.

Line 3713: l_Msg_Count := FND_MSG_PUB.Count_Msg;

3709: WHEN FND_API.G_EXC_ERROR THEN
3710: -- Set the Return Status as Error.
3711: x_Return_Status := FND_API.g_Ret_Sts_Error;
3712: -- Get the Message Count.
3713: l_Msg_Count := FND_MSG_PUB.Count_Msg;
3714:
3715: IF (l_Msg_Count = 1) THEN
3716: PA_INTERFACE_UTILS_PUB.Get_Messages (
3717: p_Encoded => FND_API.g_False

Line 3743: FND_MSG_PUB.Add_Exc_Msg (

3739: -- Set the Return Status as Error.
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: );

Line 3749: FND_MSG_PUB.Count_And_Get (

3745: p_Procedure_Name => 'Delete_CI',
3746: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
3747: );
3748:
3749: FND_MSG_PUB.Count_And_Get (
3750: p_Count => x_Msg_Count,
3751: p_Data => x_Msg_Data
3752: );
3753: