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 1194: l_msg_count := fnd_msg_pub.count_msg;

1190: Exception
1191:
1192: when FND_API.G_EXC_ERROR then
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: l_msg_count := fnd_msg_pub.count_msg;
1195: x_rowid := null; --assign to the initial value
1196: x_ci_transaction_id := null; --assign to the initial value
1197: if l_msg_count = 1 then
1198: pa_interface_utils_pub.get_messages

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

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);
1226: --Reset the stack
1227: if l_debug_mode = 'Y' then
1228: pa_debug.reset_curr_function;

Line 1477: l_msg_count := fnd_msg_pub.count_msg;

1473:
1474: exception
1475: when fnd_api.g_exc_error then
1476: x_return_status := fnd_api.g_ret_sts_error;
1477: l_msg_count := fnd_msg_pub.count_msg;
1478: if l_msg_count = 1 then
1479: pa_interface_utils_pub.get_messages
1480: (p_encoded => fnd_api.g_false,
1481: p_msg_index => 1,

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

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);
1512: /*Initialize the out variables back to null*/
1513: x_ci_type_class_code := null;
1514: x_auto_number_flag := null;

Line 2382: FND_MSG_PUB.Count_And_Get(

2378:
2379: exception
2380: when fnd_api.g_exc_unexpected_error then
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2382: FND_MSG_PUB.Count_And_Get(
2383: p_count => x_msg_count ,
2384: p_data => x_msg_data );
2385: /*Initialize the out variables back to null*/
2386: x_ci_id := null;

Line 2396: l_msg_count := fnd_msg_pub.count_msg;

2392: --raise the exception
2393: raise;
2394: when fnd_api.g_exc_error then
2395: x_return_status := fnd_api.g_ret_sts_error;
2396: l_msg_count := fnd_msg_pub.count_msg;
2397: if l_msg_count = 1 then
2398: pa_interface_utils_pub.get_messages
2399: (p_encoded => fnd_api.g_false,
2400: p_msg_index => 1,

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

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);
2428:
2429: /*Initialize the out variables back to null*/
2430: x_ci_id := null;

Line 2551: l_msg_count := fnd_msg_pub.count_msg;

2547:
2548: Exception
2549: when fnd_api.g_exc_error then
2550: x_return_status := fnd_api.g_ret_sts_error;
2551: l_msg_count := fnd_msg_pub.count_msg;
2552: if l_msg_count = 1 then
2553: pa_interface_utils_pub.get_messages
2554: (p_encoded => fnd_api.g_false,
2555: p_msg_index => 1,

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

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

Line 2706: l_msg_count := fnd_msg_pub.count_msg;

2702:
2703: Exception
2704: when fnd_api.g_exc_error then
2705: x_return_status := fnd_api.g_ret_sts_error;
2706: l_msg_count := fnd_msg_pub.count_msg;
2707: if l_msg_count = 1 then
2708: pa_interface_utils_pub.get_messages
2709: (p_encoded => fnd_api.g_false,
2710: p_msg_index => 1,

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

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

Line 3054: l_msg_count := fnd_msg_pub.count_msg;

3050:
3051: Exception
3052: when fnd_api.g_exc_error then
3053: x_return_status := fnd_api.g_ret_sts_error;
3054: l_msg_count := fnd_msg_pub.count_msg;
3055: if l_msg_count = 1 then
3056: pa_interface_utils_pub.get_messages
3057: (p_encoded => fnd_api.g_false,
3058: p_msg_index => 1,

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

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

Line 3313: FND_MSG_PUB.Count_And_Get(

3309: When fnd_api.g_exc_unexpected_error then
3310:
3311: x_return_status := fnd_api.g_ret_sts_unexp_error;
3312: --do a rollback;
3313: FND_MSG_PUB.Count_And_Get(
3314: p_count => x_msg_count ,
3315: p_data => x_msg_data );
3316:
3317: /*Not initializing the out table of records to null as it wont be used in the calling API if exception occurs*/

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

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

Line 3486: l_msg_count := fnd_msg_pub.count_msg;

3482: --do the exception handling;
3483: exception
3484: when fnd_api.g_exc_error then
3485: x_return_status := fnd_api.g_ret_sts_error;
3486: l_msg_count := fnd_msg_pub.count_msg;
3487: if l_msg_count = 1 then
3488: pa_interface_utils_pub.get_messages
3489: (p_encoded => fnd_api.g_false,
3490: p_msg_index => 1,

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

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);
3520:
3521: /*Initialize the out variables back to null*/
3522: x_action_id := null;

Line 3584: FND_MSG_PUB.Initialize;

3580: x_Msg_Count := 0;
3581:
3582: -- Clear the Global PL/SQL Message table.
3583: IF (FND_API.To_Boolean (p_Init_Msg_List)) THEN
3584: FND_MSG_PUB.Initialize;
3585: END IF;
3586:
3587: -- If the Ci_Id that is passed in is NULL then report
3588: -- Error.

Line 3730: l_Msg_Count := FND_MSG_PUB.Count_Msg;

3726: WHEN FND_API.G_EXC_ERROR THEN
3727: -- Set the Return Status as Error.
3728: x_Return_Status := FND_API.g_Ret_Sts_Error;
3729: -- Get the Message Count.
3730: l_Msg_Count := FND_MSG_PUB.Count_Msg;
3731:
3732: IF (l_Msg_Count = 1) THEN
3733: PA_INTERFACE_UTILS_PUB.Get_Messages (
3734: p_Encoded => FND_API.g_False

Line 3760: FND_MSG_PUB.Add_Exc_Msg (

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

Line 3766: FND_MSG_PUB.Count_And_Get (

3762: p_Procedure_Name => 'Delete_CI',
3763: p_Error_Text => SUBSTRB (sqlerrm, 1, 240)
3764: );
3765:
3766: FND_MSG_PUB.Count_And_Get (
3767: p_Count => x_Msg_Count,
3768: p_Data => x_Msg_Data
3769: );
3770: