APPS.PA_RBS_HEADER_PUB dependencies on FND_API

Line 47: P_Commit IN Varchar2 Default Fnd_Api.G_False,

43: -- P_RecordVersionNumber NUMBER Yes The record version number of the rbs header which is
44: -- used to ensure syncronization.
45:
46: Procedure Update_Header(
47: P_Commit IN Varchar2 Default Fnd_Api.G_False,
48: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
49: P_API_Version_Number IN Number,
50: P_RbsHeaderId IN Number,
51: P_Name IN Varchar2,

Line 48: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,

44: -- used to ensure syncronization.
45:
46: Procedure Update_Header(
47: P_Commit IN Varchar2 Default Fnd_Api.G_False,
48: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
49: P_API_Version_Number IN Number,
50: P_RbsHeaderId IN Number,
51: P_Name IN Varchar2,
52: P_Description IN Varchar2,

Line 59: P_Process_Version IN Varchar2 Default Fnd_Api.G_True,

55: P_Use_For_Alloc_Flag IN Varchar2 Default 'N',
56: P_Cbs_Enabled IN Varchar2 Default NULL, --bug#15834912
57: P_ACTIVE_FLAG IN Varchar2 Default NULL, --bug#15834912
58: P_RecordVersionNumber IN Number,
59: P_Process_Version IN Varchar2 Default Fnd_Api.G_True,
60: X_Return_status OUT NOCOPY Varchar2,
61: X_Msg_Data OUT NOCOPY Varchar2,
62: X_Msg_Count OUT NOCOPY Number )
63:

Line 107: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';

103:
104: Pa_Debug.G_Stage := 'Entering Update_Header().';
105: Pa_Debug.TrackPath('ADD','Update_Header');
106:
107: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';
108: If Not Fnd_Api.Compatible_API_Call (
109: Pa_Rbs_Header_Pub.G_Api_Version_Number,
110: P_Api_Version_Number,
111: l_Api_Name,

Line 108: If Not Fnd_Api.Compatible_API_Call (

104: Pa_Debug.G_Stage := 'Entering Update_Header().';
105: Pa_Debug.TrackPath('ADD','Update_Header');
106:
107: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';
108: If Not Fnd_Api.Compatible_API_Call (
109: Pa_Rbs_Header_Pub.G_Api_Version_Number,
110: P_Api_Version_Number,
111: l_Api_Name,
112: Pa_Rbs_Header_Pub.G_Pkg_Name) Then

Line 115: Raise Fnd_Api.G_Exc_Unexpected_Error;

111: l_Api_Name,
112: Pa_Rbs_Header_Pub.G_Pkg_Name) Then
113:
114: Pa_Debug.G_Stage := 'API Version compatibility failure.';
115: Raise Fnd_Api.G_Exc_Unexpected_Error;
116:
117: End If;
118:
119: Pa_Debug.G_Stage := 'Check if need to initialize the error message stack.';

Line 120: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then

116:
117: End If;
118:
119: Pa_Debug.G_Stage := 'Check if need to initialize the error message stack.';
120: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
121:
122: Pa_Debug.G_Stage := 'Initialize the error message stack by callling Fnd_Msg_Pub.Initialize() procedure.';
123: Fnd_Msg_Pub.Initialize;
124:

Line 127: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

123: Fnd_Msg_Pub.Initialize;
124:
125: End If;
126:
127: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
128: X_Msg_Count := 0;
129:
130: /* validation: Rbs name cannot be null*/
131: Pa_Debug.G_Stage := 'Check if the paramter p_name is null.';

Line 347: If P_Process_Version = Fnd_Api.G_True Then

343:
344: End If;
345:
346: Pa_Debug.G_Stage := 'No frozen version record was found. Check if allow to update the version record in this module.';
347: If P_Process_Version = Fnd_Api.G_True Then
348:
349: Pa_Debug.G_Stage := 'No frozen version record was found. Update the working version record for ' ||
350: 'the Rbs header by calling the Pa_Rbs_Header_Pvt.Update_Versions procedure.';
351: Pa_Rbs_Header_Pvt.Update_Versions(

Line 487: If Fnd_Api.To_Boolean(Nvl(P_Commit,Fnd_Api.G_False)) Then

483:
484: End If;
485:
486: Pa_Debug.G_Stage := 'Check if need to commit data.';
487: If Fnd_Api.To_Boolean(Nvl(P_Commit,Fnd_Api.G_False)) Then
488:
489: Pa_Debug.G_Stage := 'Commit inserts to db.';
490: Commit;
491:

Line 500: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

496:
497: Exception
498:
499: When l_Error Then
500: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
501: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
502: If l_msg_count = 1 Then
503: Pa_Interface_Utils_Pub.Get_Messages(
504: p_encoded => Fnd_Api.G_True,

Line 504: p_encoded => Fnd_Api.G_True,

500: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
501: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
502: If l_msg_count = 1 Then
503: Pa_Interface_Utils_Pub.Get_Messages(
504: p_encoded => Fnd_Api.G_True,
505: p_msg_index => 1,
506: p_msg_count => l_msg_count,
507: p_msg_data => l_msg_data,
508: p_data => l_data,

Line 572: P_Commit IN Varchar2 Default Fnd_Api.G_False,

568:
569:
570:
571: PROCEDURE Insert_Header(
572: P_Commit IN Varchar2 Default Fnd_Api.G_False,
573: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
574: P_API_Version_Number IN Number,
575: P_Name IN Varchar2,
576: P_Description IN Varchar2,

Line 573: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,

569:
570:
571: PROCEDURE Insert_Header(
572: P_Commit IN Varchar2 Default Fnd_Api.G_False,
573: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
574: P_API_Version_Number IN Number,
575: P_Name IN Varchar2,
576: P_Description IN Varchar2,
577: P_EffectiveFrom IN Date,

Line 612: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';

608:
609: Pa_Debug.G_Stage := 'Entering Insert_Header().';
610: Pa_Debug.TrackPath('ADD','Insert_Header');
611:
612: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';
613: If Not Fnd_Api.Compatible_API_Call (
614: Pa_Rbs_Elements_Pub.G_Api_Version_Number,
615: P_Api_Version_Number,
616: l_Api_Name,

Line 613: If Not Fnd_Api.Compatible_API_Call (

609: Pa_Debug.G_Stage := 'Entering Insert_Header().';
610: Pa_Debug.TrackPath('ADD','Insert_Header');
611:
612: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';
613: If Not Fnd_Api.Compatible_API_Call (
614: Pa_Rbs_Elements_Pub.G_Api_Version_Number,
615: P_Api_Version_Number,
616: l_Api_Name,
617: Pa_Rbs_Elements_Pub.G_Pkg_Name) Then

Line 620: Raise Fnd_Api.G_Exc_Unexpected_Error;

616: l_Api_Name,
617: Pa_Rbs_Elements_Pub.G_Pkg_Name) Then
618:
619: Pa_Debug.G_Stage := 'API Version compatibility failure.';
620: Raise Fnd_Api.G_Exc_Unexpected_Error;
621:
622: End If;
623:
624: Pa_Debug.G_Stage := 'Check if need to initialize the message error stack.';

Line 625: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then

621:
622: End If;
623:
624: Pa_Debug.G_Stage := 'Check if need to initialize the message error stack.';
625: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
626:
627: Pa_Debug.G_Stage := 'Initilize the message error stack by calling the Fnd_Msg_Pub.Initialize() procedure.';
628: Fnd_Msg_Pub.Initialize;
629:

Line 632: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

628: Fnd_Msg_Pub.Initialize;
629:
630: End If;
631:
632: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
633: X_Msg_Count := 0;
634:
635: /* validation: Rbs name cannot be null */
636: Pa_Debug.G_Stage := 'Check if the paramter p_name is null.';

Line 790: If Fnd_Api.To_Boolean(Nvl(P_Commit,Fnd_Api.G_False)) Then

786:
787: End If;
788:
789: Pa_Debug.G_Stage := 'Check if need to commit data.';
790: If Fnd_Api.To_Boolean(Nvl(P_Commit,Fnd_Api.G_False)) Then
791:
792: Pa_Debug.G_Stage := 'Commit inserts to db.';
793: Commit;
794:

Line 802: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

798: Pa_Debug.TrackPath('STRIP','Insert_Header');
799:
800: Exception
801: When l_Error Then
802: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
803: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
804: If l_msg_count = 1 Then
805: Pa_Interface_Utils_Pub.Get_Messages(
806: p_encoded => Fnd_Api.G_True,

Line 806: p_encoded => Fnd_Api.G_True,

802: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
803: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
804: If l_msg_count = 1 Then
805: Pa_Interface_Utils_Pub.Get_Messages(
806: p_encoded => Fnd_Api.G_True,
807: p_msg_index => 1,
808: p_msg_count => l_msg_count,
809: p_msg_data => l_msg_data,
810: p_data => l_data,