[Home] [Help]
PACKAGE BODY: APPS.PSB_ACCT_POS_SET_LINE_I_PVT
Source
1 PACKAGE BODY PSB_Acct_Pos_Set_Line_I_PVT AS
2 /* $Header: PSBWSLIB.pls 120.2 2005/07/13 11:37:30 shtripat ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_Acct_Pos_Set_Line_I_PVT';
5
6
7
8 /*=========================================================================+
9 | PROCEDURE Insert_Row |
10 +========================================================================*/
11
12 PROCEDURE Insert_Row
13 (
14 p_api_version IN NUMBER,
15 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
16 p_commit IN VARCHAR2 := FND_API.G_FALSE,
17 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
18 p_return_status OUT NOCOPY VARCHAR2,
19 p_msg_count OUT NOCOPY NUMBER,
20 p_msg_data OUT NOCOPY VARCHAR2,
21 --
22 p_Row_Id IN OUT NOCOPY VARCHAR2,
23 p_Line_Sequence_Id IN OUT NOCOPY NUMBER,
24 p_Account_Position_Set_Id NUMBER,
25 p_Description VARCHAR2,
26 p_Business_Group_Id NUMBER,
27 p_Attribute_Id NUMBER,
28 p_Include_Or_Exclude_Type VARCHAR2,
29 p_Segment1_Low VARCHAR2,
30 p_Segment2_Low VARCHAR2,
31 p_Segment3_Low VARCHAR2,
32 p_Segment4_Low VARCHAR2,
33 p_Segment5_Low VARCHAR2,
34 p_Segment6_Low VARCHAR2,
35 p_Segment7_Low VARCHAR2,
36 p_Segment8_Low VARCHAR2,
37 p_Segment9_Low VARCHAR2,
38 p_Segment10_Low VARCHAR2,
39 p_Segment11_Low VARCHAR2,
40 p_Segment12_Low VARCHAR2,
41 p_Segment13_Low VARCHAR2,
42 p_Segment14_Low VARCHAR2,
43 p_Segment15_Low VARCHAR2,
44 p_Segment16_Low VARCHAR2,
45 p_Segment17_Low VARCHAR2,
46 p_Segment18_Low VARCHAR2,
47 p_Segment19_Low VARCHAR2,
48 p_Segment20_Low VARCHAR2,
49 p_Segment21_Low VARCHAR2,
50 p_Segment22_Low VARCHAR2,
51 p_Segment23_Low VARCHAR2,
52 p_Segment24_Low VARCHAR2,
53 p_Segment25_Low VARCHAR2,
54 p_Segment26_Low VARCHAR2,
55 p_Segment27_Low VARCHAR2,
56 p_Segment28_Low VARCHAR2,
57 p_Segment29_Low VARCHAR2,
58 p_Segment30_Low VARCHAR2,
59 p_Segment1_High VARCHAR2,
60 p_Segment2_High VARCHAR2,
61 p_Segment3_High VARCHAR2,
62 p_Segment4_High VARCHAR2,
63 p_Segment5_High VARCHAR2,
64 p_Segment6_High VARCHAR2,
65 p_Segment7_High VARCHAR2,
66 p_Segment8_High VARCHAR2,
67 p_Segment9_High VARCHAR2,
68 p_Segment10_High VARCHAR2,
69 p_Segment11_High VARCHAR2,
70 p_Segment12_High VARCHAR2,
71 p_Segment13_High VARCHAR2,
72 p_Segment14_High VARCHAR2,
73 p_Segment15_High VARCHAR2,
74 p_Segment16_High VARCHAR2,
75 p_Segment17_High VARCHAR2,
76 p_Segment18_High VARCHAR2,
77 p_Segment19_High VARCHAR2,
78 p_Segment20_High VARCHAR2,
79 p_Segment21_High VARCHAR2,
80 p_Segment22_High VARCHAR2,
81 p_Segment23_High VARCHAR2,
82 p_Segment24_High VARCHAR2,
83 p_Segment25_High VARCHAR2,
84 p_Segment26_High VARCHAR2,
85 p_Segment27_High VARCHAR2,
86 p_Segment28_High VARCHAR2,
87 p_Segment29_High VARCHAR2,
88 p_Segment30_High VARCHAR2,
89 p_context VARCHAR2,
90 p_attribute1 VARCHAR2,
91 p_attribute2 VARCHAR2,
92 p_attribute3 VARCHAR2,
93 p_attribute4 VARCHAR2,
94 p_attribute5 VARCHAR2,
95 p_attribute6 VARCHAR2,
96 p_attribute7 VARCHAR2,
97 p_attribute8 VARCHAR2,
98 p_attribute9 VARCHAR2,
99 p_attribute10 VARCHAR2,
100 p_Last_Update_Date DATE,
101 p_Last_Updated_By NUMBER,
102 p_Last_Update_Login NUMBER,
103 p_Created_By NUMBER,
104 p_Creation_Date DATE
105 )
106 IS
107 --
108 l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
109 --
110 BEGIN
111 --
112 SAVEPOINT Insert_Row_Pvt ;
113 --
114
115 PSB_ACCT_POSITION_SET_LINE_PVT.Insert_Row
116 (
117 p_api_version => p_api_version ,
118 p_init_msg_list => p_init_msg_list ,
119 p_commit => p_commit ,
120 p_validation_level => p_validation_level,
121 p_return_status => p_return_status,
122 p_msg_count => p_msg_count,
123 p_msg_data => p_msg_data,
124 --
125 p_Row_Id => p_Row_Id,
126 p_Line_Sequence_Id => p_Line_Sequence_Id,
127 p_Account_Position_Set_Id => p_Account_Position_Set_Id,
128 p_Description => p_Description,
129 p_Business_Group_Id => p_Business_Group_Id,
130 p_Attribute_Id => p_Attribute_Id,
131 p_Include_Or_Exclude_Type => p_Include_Or_Exclude_Type,
132 p_Segment1_Low => p_Segment1_Low,
133 p_Segment2_Low => p_Segment2_Low,
134 p_Segment3_Low => p_Segment3_Low,
135 p_Segment4_Low => p_Segment4_Low,
136 p_Segment5_Low => p_Segment5_Low,
137 p_Segment6_Low => p_Segment6_Low,
138 p_Segment7_Low => p_Segment7_Low,
139 p_Segment8_Low => p_Segment8_Low,
140 p_Segment9_Low => p_Segment9_Low,
141 p_Segment10_Low => p_Segment10_Low,
142 p_Segment11_Low => p_Segment11_Low,
143 p_Segment12_Low => p_Segment12_Low,
144 p_Segment13_Low => p_Segment13_Low,
145 p_Segment14_Low => p_Segment14_Low,
146 p_Segment15_Low => p_Segment15_Low,
147 p_Segment16_Low => p_Segment16_Low,
148 p_Segment17_Low => p_Segment17_Low,
149 p_Segment18_Low => p_Segment18_Low,
150 p_Segment19_Low => p_Segment19_Low,
151 p_Segment20_Low => p_Segment20_Low,
152 p_Segment21_Low => p_Segment21_Low,
153 p_Segment22_Low => p_Segment22_Low,
154 p_Segment23_Low => p_Segment23_Low,
155 p_Segment24_Low => p_Segment24_Low,
156 p_Segment25_Low => p_Segment25_Low,
157 p_Segment26_Low => p_Segment26_Low,
158 p_Segment27_Low => p_Segment27_Low,
159 p_Segment28_Low => p_Segment28_Low,
160 p_Segment29_Low => p_Segment29_Low,
161 p_Segment30_Low => p_Segment30_Low,
162 p_Segment1_High => p_Segment1_High,
163 p_Segment2_High => p_Segment2_High,
164 p_Segment3_High => p_Segment3_High,
165 p_Segment4_High => p_Segment4_High,
166 p_Segment5_High => p_Segment5_High,
167 p_Segment6_High => p_Segment6_High,
168 p_Segment7_High => p_Segment7_High,
169 p_Segment8_High => p_Segment8_High,
170 p_Segment9_High => p_Segment9_High,
171 p_Segment10_High => p_Segment10_High,
172 p_Segment11_High => p_Segment11_High,
173 p_Segment12_High => p_Segment12_High,
174 p_Segment13_High => p_Segment13_High,
175 p_Segment14_High => p_Segment14_High,
176 p_Segment15_High => p_Segment15_High,
177 p_Segment16_High => p_Segment16_High,
178 p_Segment17_High => p_Segment17_High,
179 p_Segment18_High => p_Segment18_High,
180 p_Segment19_High => p_Segment19_High,
181 p_Segment20_High => p_Segment20_High,
182 p_Segment21_High => p_Segment21_High,
183 p_Segment22_High => p_Segment22_High,
184 p_Segment23_High => p_Segment23_High,
185 p_Segment24_High => p_Segment24_High,
186 p_Segment25_High => p_Segment25_High,
187 p_Segment26_High => p_Segment26_High,
188 p_Segment27_High => p_Segment27_High,
189 p_Segment28_High => p_Segment28_High,
190 p_Segment29_High => p_Segment29_High,
191 p_Segment30_High => p_Segment30_High,
192 p_context => p_context,
193 p_attribute1 => p_attribute1,
194 p_attribute2 => p_attribute2,
195 p_attribute3 => p_attribute3,
196 p_attribute4 => p_attribute4,
197 p_attribute5 => p_attribute5,
198 p_attribute6 => p_attribute6,
199 p_attribute7 => p_attribute7,
200 p_attribute8 => p_attribute8,
201 p_attribute9 => p_attribute9,
202 p_attribute10 => p_attribute10,
203 p_Last_Update_Date => p_Last_Update_Date,
204 p_Last_Updated_By => p_Last_Updated_By,
205 p_Last_Update_Login => p_Last_Update_Login,
206 p_Created_By => p_Created_By,
207 p_Creation_Date => p_Creation_Date
208 );
209
210 EXCEPTION
211 --
212 WHEN OTHERS THEN
213 --
214 ROLLBACK TO Insert_Row_Pvt ;
215 --
216 p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217 --
218 IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
219 FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
220 l_api_name );
221 END if;
222 --
223 FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
224 p_data => p_msg_data );
225 --
226
227 END Insert_Row;
228 /*-------------------------------------------------------------------------*/
229
230
231 END PSB_Acct_Pos_Set_Line_I_PVT;