DBA Data[Home] [Help]

APPS.PA_PLAN_RES_LIST_PUB dependencies on FND_MSG_PUB

Line 1270: FND_MSG_PUB.initialize;

1266:
1267: --Initialize the message stack before starting any further processing.
1268: IF FND_API.to_boolean( p_init_msg_list )
1269: THEN
1270: FND_MSG_PUB.initialize;
1271: END IF;
1272:
1273: --Initialize the Out Variables.
1274: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1473: FND_MSG_PUB.Add_Exc_Msg

1469: x_msg_count := x_msg_count + 1;
1470: X_Msg_Data := SUBSTRB(SQLERRM,1,240); -- 4537865
1471: ROLLBACK ;
1472: -- 4537865
1473: FND_MSG_PUB.Add_Exc_Msg
1474: ( p_pkg_name => G_PKG_NAME ,
1475: p_procedure_name => l_api_name,
1476: p_error_text => X_Msg_Data
1477: );

Line 1485: FND_MSG_PUB.Add_Exc_Msg

1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: x_msg_count := x_msg_count + 1; -- 4537865
1483: X_Msg_Data := SUBSTRB(SQLERRM,1,240); -- 4537865
1484: ROLLBACK;
1485: FND_MSG_PUB.Add_Exc_Msg
1486: ( p_pkg_name => G_PKG_NAME ,
1487: p_procedure_name => l_api_name,
1488: p_error_text => x_msg_data -- 4537865
1489: );

Line 1560: Fnd_Msg_Pub.Initialize;

1556: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
1557: --Initialize the message stack before starting any further processing.
1558: If Fnd_Api.To_Boolean( P_Init_Msg_List ) Then
1559:
1560: Fnd_Msg_Pub.Initialize;
1561:
1562: End If;
1563:
1564: --Initialize the Out Variables.

Line 2194: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;

2190:
2191:
2192: Exception
2193: When l_ERROR Then
2194: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
2195:
2196:
2197: If l_Msg_Count = 1 Then
2198:

Line 2224: Fnd_Msg_Pub.Add_Exc_Msg(

2220: X_Msg_Data := SUBSTRB(SQLERRM,1,240);
2221: X_Msg_Count := X_Msg_Count + 1;
2222: -- 4537865 : End
2223: Rollback ;
2224: Fnd_Msg_Pub.Add_Exc_Msg(
2225: p_pkg_name => G_PKG_NAME ,
2226: p_procedure_name => l_api_name);
2227: Return;
2228:

Line 2266: FND_MSG_PUB.initialize;

2262: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
2263: --Initialize the message stack before starting any further processing.
2264: IF FND_API.to_boolean( p_init_msg_list )
2265: THEN
2266: FND_MSG_PUB.initialize;
2267: END IF;
2268:
2269: --Initialize the Out Variables.
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2482: FND_MSG_PUB.Add_Exc_Msg

2478: X_Msg_Data := SUBSTRB(SQLERRM,1,240);
2479: x_msg_count := x_msg_count + 1 ;
2480: -- 4537865 : End
2481: ROLLBACK ;
2482: FND_MSG_PUB.Add_Exc_Msg
2483: ( p_pkg_name => G_PKG_NAME ,
2484: p_procedure_name => l_api_name
2485: );
2486: Return;

Line 2519: FND_MSG_PUB.initialize;

2515:
2516: -- First clear the message stack.
2517: IF FND_API.to_boolean( p_init_msg_list )
2518: THEN
2519: FND_MSG_PUB.initialize;
2520: END IF;
2521:
2522:
2523:

Line 2607: Fnd_Msg_Pub.Add_Exc_Msg(

2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2604: x_msg_count := x_msg_count + 1;
2605: -- 4537865
2606: x_msg_data := SUBSTRB(SQLERRM,1,240);
2607: Fnd_Msg_Pub.Add_Exc_Msg(
2608: P_Pkg_Name => 'Pa_Plan_Res_List_Pub',
2609: P_Procedure_Name => 'Create_Plan_RL_Format',
2610: P_error_text => x_msg_data);
2611: END Create_Plan_RL_Format;

Line 2638: FND_MSG_PUB.initialize;

2634: BEGIN
2635: -- First clear the message stack.
2636: IF FND_API.to_boolean( p_init_msg_list )
2637: THEN
2638: FND_MSG_PUB.initialize;
2639: END IF;
2640:
2641: Convert_Missing_Format_IN_Rec(
2642: P_Plan_RL_Format_Tbl => P_Plan_RL_Format_Tbl,

Line 2737: Fnd_Msg_Pub.Initialize;

2733: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
2734: -- First clear the message stack.
2735: If Fnd_Api.To_Boolean( P_Init_Msg_List ) Then
2736:
2737: Fnd_Msg_Pub.Initialize;
2738:
2739: End If;
2740:
2741: /* Added for CBS changes */

Line 3148: x_msg_count := Fnd_Msg_Pub.Count_Msg;

3144: Commit;
3145:
3146: End If;
3147: x_return_status := Fnd_Api.G_Ret_Sts_Success;
3148: x_msg_count := Fnd_Msg_Pub.Count_Msg;
3149:
3150:
3151: Exception
3152: When FMT_NULL_ERR Then

Line 3445: Fnd_Msg_Pub.Initialize;

3441: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
3442: -- First clear the message stack.
3443: If Fnd_Api.To_Boolean( p_init_msg_list ) Then
3444:
3445: Fnd_Msg_Pub.Initialize;
3446:
3447: End If;
3448:
3449: /* Eugene

Line 3652: x_msg_count := Fnd_Msg_Pub.Count_Msg;

3648:
3649: End If;
3650:
3651: x_return_status := Fnd_Api.G_Ret_Sts_Success;
3652: x_msg_count := Fnd_Msg_Pub.Count_Msg;
3653:
3654: Exception
3655: When Others Then
3656: Rollback;

Line 3684: FND_MSG_PUB.initialize;

3680: Pa_Planning_Resource_Pvt.g_amg_flow := 'Y';
3681: -- First clear the message stack.
3682: IF FND_API.to_boolean( p_init_msg_list )
3683: THEN
3684: FND_MSG_PUB.initialize;
3685: END IF;
3686: /********************************************
3687: * To Check if resource_list member is currently being
3688: * used in a planning transaction.

Line 3729: FND_MSG_PUB.initialize;

3725: PROCEDURE Init_Create_Resource_List
3726: IS
3727: l_api_name CONSTANT VARCHAR2(30) := 'Init_Create_Resource_List';
3728: BEGIN
3729: FND_MSG_PUB.initialize;
3730:
3731: G_Plan_Res_List_IN_Rec := G_Res_List_empty_rec;
3732: G_Plan_Res_List_Out_Rec := G_Res_List_empty_out_rec;
3733:

Line 3746: FND_MSG_PUB.Add_Exc_Msg

3742: G_Plan_Resource_tbl_count := 0;
3743:
3744: EXCEPTION
3745: WHEN OTHERS THEN
3746: FND_MSG_PUB.Add_Exc_Msg
3747: ( p_pkg_name => G_PKG_NAME ,
3748: p_procedure_name => l_api_name
3749: );
3750:

Line 3766: FND_MSG_PUB.initialize;

3762: PROCEDURE Init_Update_Resource_List
3763: IS
3764: l_api_name CONSTANT VARCHAR2(30) := 'Init_Update_Resource_List';
3765: BEGIN
3766: FND_MSG_PUB.initialize;
3767:
3768: G_Plan_Res_List_IN_Rec := G_Res_List_empty_rec;
3769: G_Plan_Res_List_Out_Rec := G_Res_List_empty_out_rec;
3770:

Line 3783: FND_MSG_PUB.Add_Exc_Msg

3779: G_Plan_Resource_tbl_count := 0;
3780:
3781: EXCEPTION
3782: WHEN OTHERS THEN
3783: FND_MSG_PUB.Add_Exc_Msg
3784: ( p_pkg_name => G_PKG_NAME ,
3785: p_procedure_name => l_api_name
3786: );
3787: END Init_Update_Resource_List;

Line 3840: FND_MSG_PUB.Add_Exc_Msg

3836: THEN
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3838: WHEN OTHERS THEN
3839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3840: FND_MSG_PUB.Add_Exc_Msg
3841: ( p_pkg_name => G_PKG_NAME ,
3842: p_procedure_name => l_api_name
3843: );
3844: END Load_Resource_List;

Line 3883: FND_MSG_PUB.Add_Exc_Msg

3879: THEN
3880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3881: WHEN OTHERS THEN
3882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3883: FND_MSG_PUB.Add_Exc_Msg
3884: ( p_pkg_name => G_PKG_NAME ,
3885: p_procedure_name => l_api_name
3886: );
3887: END Load_Resource_Format;

Line 4115: FND_MSG_PUB.Add_Exc_Msg

4111: THEN
4112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4113: WHEN OTHERS THEN
4114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4115: FND_MSG_PUB.Add_Exc_Msg
4116: ( p_pkg_name => G_PKG_NAME ,
4117: p_procedure_name => l_api_name
4118: );
4119: END Load_Planning_Resource;

Line 4175: FND_MSG_PUB.Add_Exc_Msg

4171: -- 4537865
4172: x_msg_data := SUBSTRB(SQLERRM,1,240);
4173: x_msg_count := 1 ;
4174: -- 4537865
4175: FND_MSG_PUB.Add_Exc_Msg
4176: ( p_pkg_name => G_PKG_NAME ,
4177: p_procedure_name => l_api_name
4178: );
4179: END Exec_Create_Resource_List;

Line 4232: FND_MSG_PUB.Add_Exc_Msg

4228: WHEN OTHERS THEN
4229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4230: x_msg_data := SUBSTRB(SQLERRM,1,240);
4231: x_msg_count := 1 ;
4232: FND_MSG_PUB.Add_Exc_Msg
4233: ( p_pkg_name => G_PKG_NAME ,
4234: p_procedure_name => l_api_name ,
4235: p_error_text => x_msg_data
4236: );

Line 4278: FND_MSG_PUB.Add_Exc_Msg

4274: -- 4537865 : RESETTING x_resource_list_id also
4275: x_resource_list_id := NULL ;
4276:
4277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4278: FND_MSG_PUB.Add_Exc_Msg
4279: ( p_pkg_name => G_PKG_NAME ,
4280: p_procedure_name => l_api_name
4281: );
4282: END Fetch_Resource_List;

Line 4334: FND_MSG_PUB.Add_Exc_Msg

4330: WHEN OTHERS THEN
4331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4332: -- 4537865 : RESETTING X_Plan_RL_Format_Id also
4333: X_Plan_RL_Format_Id := NULL ;
4334: FND_MSG_PUB.Add_Exc_Msg
4335: ( p_pkg_name => G_PKG_NAME ,
4336: p_procedure_name => l_api_name
4337: );
4338: END Fetch_Plan_Format;

Line 4384: FND_MSG_PUB.Add_Exc_Msg

4380: EXCEPTION
4381: WHEN OTHERS THEN
4382: x_resource_list_member_id := NULL ;
4383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4384: FND_MSG_PUB.Add_Exc_Msg
4385: ( p_pkg_name => G_PKG_NAME ,
4386: p_procedure_name => l_api_name
4387: );
4388: -- Not RAISING because other similar APIs dont have RAISE