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 57: P_Process_Version IN Varchar2 Default Fnd_Api.G_True,

53: P_EffectiveFrom IN Date,
54: P_EffectiveTo IN Date,
55: P_Use_For_Alloc_Flag IN Varchar2 Default 'N',
56: P_RecordVersionNumber IN Number,
57: P_Process_Version IN Varchar2 Default Fnd_Api.G_True,
58: X_Return_status OUT NOCOPY Varchar2,
59: X_Msg_Data OUT NOCOPY Varchar2,
60: X_Msg_Count OUT NOCOPY Number )
61:

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

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

Line 106: If Not Fnd_Api.Compatible_API_Call (

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

Line 113: Raise Fnd_Api.G_Exc_Unexpected_Error;

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

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

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

Line 125: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

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

Line 332: If P_Process_Version = Fnd_Api.G_True Then

328:
329: End If;
330:
331: Pa_Debug.G_Stage := 'No frozen version record was found. Check if allow to update the version record in this module.';
332: If P_Process_Version = Fnd_Api.G_True Then
333:
334: Pa_Debug.G_Stage := 'No frozen version record was found. Update the working version record for ' ||
335: 'the Rbs header by calling the Pa_Rbs_Header_Pvt.Update_Versions procedure.';
336: Pa_Rbs_Header_Pvt.Update_Versions(

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

467:
468: End If;
469:
470: Pa_Debug.G_Stage := 'Check if need to commit data.';
471: If Fnd_Api.To_Boolean(Nvl(P_Commit,Fnd_Api.G_False)) Then
472:
473: Pa_Debug.G_Stage := 'Commit inserts to db.';
474: Commit;
475:

Line 484: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

480:
481: Exception
482:
483: When l_Error Then
484: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
485: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
486: If l_msg_count = 1 Then
487: Pa_Interface_Utils_Pub.Get_Messages(
488: p_encoded => Fnd_Api.G_True,

Line 488: p_encoded => Fnd_Api.G_True,

484: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
485: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
486: If l_msg_count = 1 Then
487: Pa_Interface_Utils_Pub.Get_Messages(
488: p_encoded => Fnd_Api.G_True,
489: p_msg_index => 1,
490: p_msg_count => l_msg_count,
491: p_msg_data => l_msg_data,
492: p_data => l_data,

Line 556: P_Commit IN Varchar2 Default Fnd_Api.G_False,

552:
553:
554:
555: PROCEDURE Insert_Header(
556: P_Commit IN Varchar2 Default Fnd_Api.G_False,
557: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
558: P_API_Version_Number IN Number,
559: P_Name IN Varchar2,
560: P_Description IN Varchar2,

Line 557: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,

553:
554:
555: PROCEDURE Insert_Header(
556: P_Commit IN Varchar2 Default Fnd_Api.G_False,
557: P_Init_Msg_List IN Varchar2 Default Fnd_Api.G_True,
558: P_API_Version_Number IN Number,
559: P_Name IN Varchar2,
560: P_Description IN Varchar2,
561: P_EffectiveFrom IN Date,

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

590:
591: Pa_Debug.G_Stage := 'Entering Insert_Header().';
592: Pa_Debug.TrackPath('ADD','Insert_Header');
593:
594: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';
595: If Not Fnd_Api.Compatible_API_Call (
596: Pa_Rbs_Elements_Pub.G_Api_Version_Number,
597: P_Api_Version_Number,
598: l_Api_Name,

Line 595: If Not Fnd_Api.Compatible_API_Call (

591: Pa_Debug.G_Stage := 'Entering Insert_Header().';
592: Pa_Debug.TrackPath('ADD','Insert_Header');
593:
594: Pa_Debug.G_Stage := 'Check API Version compatibility by calling Fnd_Api.Compatible_API_Call() procedure.';
595: If Not Fnd_Api.Compatible_API_Call (
596: Pa_Rbs_Elements_Pub.G_Api_Version_Number,
597: P_Api_Version_Number,
598: l_Api_Name,
599: Pa_Rbs_Elements_Pub.G_Pkg_Name) Then

Line 602: Raise Fnd_Api.G_Exc_Unexpected_Error;

598: l_Api_Name,
599: Pa_Rbs_Elements_Pub.G_Pkg_Name) Then
600:
601: Pa_Debug.G_Stage := 'API Version compatibility failure.';
602: Raise Fnd_Api.G_Exc_Unexpected_Error;
603:
604: End If;
605:
606: Pa_Debug.G_Stage := 'Check if need to initialize the message error stack.';

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

603:
604: End If;
605:
606: Pa_Debug.G_Stage := 'Check if need to initialize the message error stack.';
607: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
608:
609: Pa_Debug.G_Stage := 'Initilize the message error stack by calling the Fnd_Msg_Pub.Initialize() procedure.';
610: Fnd_Msg_Pub.Initialize;
611:

Line 614: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;

610: Fnd_Msg_Pub.Initialize;
611:
612: End If;
613:
614: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
615: X_Msg_Count := 0;
616:
617: /* validation: Rbs name cannot be null */
618: Pa_Debug.G_Stage := 'Check if the paramter p_name is null.';

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

746:
747: End If;
748:
749: Pa_Debug.G_Stage := 'Check if need to commit data.';
750: If Fnd_Api.To_Boolean(Nvl(P_Commit,Fnd_Api.G_False)) Then
751:
752: Pa_Debug.G_Stage := 'Commit inserts to db.';
753: Commit;
754:

Line 762: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;

758: Pa_Debug.TrackPath('STRIP','Insert_Header');
759:
760: Exception
761: When l_Error Then
762: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
763: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
764: If l_msg_count = 1 Then
765: Pa_Interface_Utils_Pub.Get_Messages(
766: p_encoded => Fnd_Api.G_True,

Line 766: p_encoded => Fnd_Api.G_True,

762: X_Return_Status := Fnd_Api.G_Ret_Sts_Error;
763: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
764: If l_msg_count = 1 Then
765: Pa_Interface_Utils_Pub.Get_Messages(
766: p_encoded => Fnd_Api.G_True,
767: p_msg_index => 1,
768: p_msg_count => l_msg_count,
769: p_msg_data => l_msg_data,
770: p_data => l_data,