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.PSB_ACCOUNT_POSITION_SET_PVT dependencies on FND_API

Line 27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

23: +=======================================================================*/
24: PROCEDURE Insert_Row
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_return_status OUT NOCOPY VARCHAR2,
31: p_msg_count OUT NOCOPY NUMBER,

Line 28: p_commit IN VARCHAR2 := FND_API.G_FALSE,

24: PROCEDURE Insert_Row
25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_return_status OUT NOCOPY VARCHAR2,
31: p_msg_count OUT NOCOPY NUMBER,
32: p_msg_data OUT NOCOPY VARCHAR2,

Line 29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

25: (
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
30: p_return_status OUT NOCOPY VARCHAR2,
31: p_msg_count OUT NOCOPY NUMBER,
32: p_msg_data OUT NOCOPY VARCHAR2,
33: --

Line 38: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: p_row_id IN OUT NOCOPY VARCHAR2,
35: p_account_position_set_id IN OUT NOCOPY NUMBER,
36: p_name IN VARCHAR2,
37: p_set_of_books_id IN NUMBER,
38: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_data_extract_id IN NUMBER,
40: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_global_or_local_type IN VARCHAR2,
42: p_account_or_position_type IN VARCHAR2,

Line 40: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

36: p_name IN VARCHAR2,
37: p_set_of_books_id IN NUMBER,
38: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_data_extract_id IN NUMBER,
40: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
41: p_global_or_local_type IN VARCHAR2,
42: p_account_or_position_type IN VARCHAR2,
43: p_attribute_selection_type IN VARCHAR2,
44: p_business_group_id IN NUMBER,

Line 68: IF NOT FND_API.Compatible_API_Call ( l_api_version,

64: BEGIN
65: --
66: SAVEPOINT Insert_Row_Pvt ;
67: --
68: IF NOT FND_API.Compatible_API_Call ( l_api_version,
69: p_api_version,
70: l_api_name,
71: G_PKG_NAME )
72: THEN

Line 73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

69: p_api_version,
70: l_api_name,
71: G_PKG_NAME )
72: THEN
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
74: END IF;
75: --
76:
77: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 77: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
74: END IF;
75: --
76:
77: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize ;
79: END IF;
80: --
81: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 81: p_return_status := FND_API.G_RET_STS_SUCCESS ;

77: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize ;
79: END IF;
80: --
81: p_return_status := FND_API.G_RET_STS_SUCCESS ;
82: --
83:
84: IF (p_account_position_set_id is NULL) THEN
85: OPEN C2;

Line 113: FND_API.G_MISS_CHAR, NULL,

109: p_account_position_set_id,
110: p_name,
111: p_set_of_books_id,
112: DECODE(p_use_in_budget_group_flag,
113: FND_API.G_MISS_CHAR, NULL,
114: p_use_in_budget_group_flag),
115: p_data_extract_id,
116: DECODE(p_budget_group_id,FND_API.G_MISS_NUM,null,p_budget_group_id),
117: p_global_or_local_Type,

Line 116: DECODE(p_budget_group_id,FND_API.G_MISS_NUM,null,p_budget_group_id),

112: DECODE(p_use_in_budget_group_flag,
113: FND_API.G_MISS_CHAR, NULL,
114: p_use_in_budget_group_flag),
115: p_data_extract_id,
116: DECODE(p_budget_group_id,FND_API.G_MISS_NUM,null,p_budget_group_id),
117: p_global_or_local_Type,
118: p_account_or_position_Type,
119: p_attribute_selection_Type,
120: p_business_group_Id,

Line 131: RAISE FND_API.G_EXC_ERROR ;

127: OPEN C;
128: FETCH C INTO p_row_id;
129: IF (C%NOTFOUND) THEN
130: CLOSE C;
131: RAISE FND_API.G_EXC_ERROR ;
132: END IF;
133: CLOSE C;
134: --
135:

Line 137: IF FND_API.To_Boolean ( p_commit ) THEN

133: CLOSE C;
134: --
135:
136: --
137: IF FND_API.To_Boolean ( p_commit ) THEN
138: COMMIT WORK;
139: END iF;
140: --
141: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 146: WHEN FND_API.G_EXC_ERROR THEN

142: p_data => p_msg_data );
143: --
144: EXCEPTION
145: --
146: WHEN FND_API.G_EXC_ERROR THEN
147: --
148: ROLLBACK TO Insert_Row_Pvt ;
149: p_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 149: p_return_status := FND_API.G_RET_STS_ERROR;

145: --
146: WHEN FND_API.G_EXC_ERROR THEN
147: --
148: ROLLBACK TO Insert_Row_Pvt ;
149: p_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
151: p_data => p_msg_data );
152: --
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

149: p_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
151: p_data => p_msg_data );
152: --
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: --
155: ROLLBACK TO Insert_Row_Pvt ;
156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

152: --
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: --
155: ROLLBACK TO Insert_Row_Pvt ;
156: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
158: p_data => p_msg_data );
159: --
160: WHEN OTHERS THEN

Line 163: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: --
160: WHEN OTHERS THEN
161: --
162: ROLLBACK TO Insert_Row_Pvt ;
163: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: --
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
167: l_api_name);

Line 184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

180: +==========================================================================*/
181: PROCEDURE Lock_Row
182: (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,

Line 185: p_commit IN VARCHAR2 := FND_API.G_FALSE,

181: PROCEDURE Lock_Row
182: (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
189: p_msg_data OUT NOCOPY VARCHAR2,

Line 186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

182: (
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185: p_commit IN VARCHAR2 := FND_API.G_FALSE,
186: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187: p_return_status OUT NOCOPY VARCHAR2,
188: p_msg_count OUT NOCOPY NUMBER,
189: p_msg_data OUT NOCOPY VARCHAR2,
190: --

Line 195: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

191: p_row_id IN VARCHAR2,
192: p_account_position_set_id IN NUMBER,
193: p_name IN VARCHAR2,
194: p_set_of_books_id IN NUMBER,
195: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_data_extract_id IN NUMBER,
197: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_or_local_type IN VARCHAR2,
199: p_account_or_position_type IN VARCHAR2,

Line 197: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

193: p_name IN VARCHAR2,
194: p_set_of_books_id IN NUMBER,
195: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
196: p_data_extract_id IN NUMBER,
197: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_global_or_local_type IN VARCHAR2,
199: p_account_or_position_type IN VARCHAR2,
200: p_attribute_selection_type IN VARCHAR2,
201: p_business_group_id IN NUMBER,

Line 222: IF NOT FND_API.Compatible_API_Call ( l_api_version,

218: BEGIN
219: --
220: SAVEPOINT Lock_Row_Pvt ;
221: --
222: IF NOT FND_API.Compatible_API_Call ( l_api_version,
223: p_api_version,
224: l_api_name,
225: G_PKG_NAME )
226: THEN

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

223: p_api_version,
224: l_api_name,
225: G_PKG_NAME )
226: THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;
229: --
230:
231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
228: END IF;
229: --
230:
231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
232: FND_MSG_PUB.initialize ;
233: END IF;
234: --
235: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 235: p_return_status := FND_API.G_RET_STS_SUCCESS ;

231: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
232: FND_MSG_PUB.initialize ;
233: END IF;
234: --
235: p_return_status := FND_API.G_RET_STS_SUCCESS ;
236: p_row_locked := FND_API.G_TRUE ;
237: --
238: OPEN C;
239: --

Line 236: p_row_locked := FND_API.G_TRUE ;

232: FND_MSG_PUB.initialize ;
233: END IF;
234: --
235: p_return_status := FND_API.G_RET_STS_SUCCESS ;
236: p_row_locked := FND_API.G_TRUE ;
237: --
238: OPEN C;
239: --
240: FETCH C INTO Recinfo;

Line 245: RAISE FND_API.G_EXC_ERROR ;

241: IF (C%NOTFOUND) then
242: CLOSE C;
243: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
244: FND_MSG_PUB.Add;
245: RAISE FND_API.G_EXC_ERROR ;
246: END IF;
247: CLOSE C;
248:
249: IF

Line 265: AND (p_use_in_budget_group_flag = FND_API.G_MISS_NUM )))

261: AND ( (Recinfo.use_in_budget_group_flag = p_use_in_budget_group_flag)
262: OR ( (Recinfo.use_in_budget_group_flag IS NULL)
263: AND (p_use_in_budget_group_flag IS NULL))
264: OR ((Recinfo.use_in_budget_group_flag is NULL)
265: AND (p_use_in_budget_group_flag = FND_API.G_MISS_NUM )))
266:
267: AND ( (Recinfo.data_extract_id = p_data_extract_id)
268: OR ( (Recinfo.data_extract_id IS NULL)
269: AND (p_data_extract_id IS NULL)))

Line 275: AND (p_budget_group_id = FND_API.G_MISS_NUM )))

271: AND ( (Recinfo.budget_group_id = p_budget_group_id)
272: OR ( (Recinfo.budget_group_id IS NULL)
273: AND (p_budget_group_id IS NULL))
274: OR ((Recinfo.budget_group_id is null)
275: AND (p_budget_group_id = FND_API.G_MISS_NUM )))
276:
277: AND ( (Recinfo.global_or_local_type = p_global_or_local_type)
278: OR ( (Recinfo.global_or_local_type IS NULL)
279: AND (p_global_or_local_type IS NULL)))

Line 298: RAISE FND_API.G_EXC_ERROR ;

294: Null;
295: ELSE
296: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
297: FND_MSG_PUB.Add;
298: RAISE FND_API.G_EXC_ERROR ;
299: END IF;
300:
301: --
302: IF FND_API.To_Boolean ( p_commit ) THEN

Line 302: IF FND_API.To_Boolean ( p_commit ) THEN

298: RAISE FND_API.G_EXC_ERROR ;
299: END IF;
300:
301: --
302: IF FND_API.To_Boolean ( p_commit ) THEN
303: COMMIT WORK;
304: END iF;
305: --
306: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 314: p_row_locked := FND_API.G_FALSE;

310: --
311: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
312: --
313: ROLLBACK TO Lock_Row_Pvt ;
314: p_row_locked := FND_API.G_FALSE;
315: p_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
317: p_data => p_msg_data );
318: --

Line 315: p_return_status := FND_API.G_RET_STS_ERROR;

311: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
312: --
313: ROLLBACK TO Lock_Row_Pvt ;
314: p_row_locked := FND_API.G_FALSE;
315: p_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
317: p_data => p_msg_data );
318: --
319: WHEN FND_API.G_EXC_ERROR THEN

Line 319: WHEN FND_API.G_EXC_ERROR THEN

315: p_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
317: p_data => p_msg_data );
318: --
319: WHEN FND_API.G_EXC_ERROR THEN
320: --
321: ROLLBACK TO Lock_Row_Pvt ;
322: p_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 322: p_return_status := FND_API.G_RET_STS_ERROR;

318: --
319: WHEN FND_API.G_EXC_ERROR THEN
320: --
321: ROLLBACK TO Lock_Row_Pvt ;
322: p_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
324: p_data => p_msg_data );
325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: p_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
324: p_data => p_msg_data );
325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: --
328: ROLLBACK TO Lock_Row_Pvt ;
329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

325: --
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: --
328: ROLLBACK TO Lock_Row_Pvt ;
329: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
331: p_data => p_msg_data );
332: --
333: WHEN OTHERS THEN

Line 336: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332: --
333: WHEN OTHERS THEN
334: --
335: ROLLBACK TO Lock_Row_Pvt ;
336: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: --
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
339: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
340: l_api_name);

Line 357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

353: +==========================================================================*/
354: PROCEDURE Update_Row
355: (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_commit IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_return_status OUT NOCOPY VARCHAR2,
361: p_msg_count OUT NOCOPY NUMBER,

Line 358: p_commit IN VARCHAR2 := FND_API.G_FALSE,

354: PROCEDURE Update_Row
355: (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_commit IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_return_status OUT NOCOPY VARCHAR2,
361: p_msg_count OUT NOCOPY NUMBER,
362: p_msg_data OUT NOCOPY VARCHAR2,

Line 359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

355: (
356: p_api_version IN NUMBER,
357: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
358: p_commit IN VARCHAR2 := FND_API.G_FALSE,
359: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360: p_return_status OUT NOCOPY VARCHAR2,
361: p_msg_count OUT NOCOPY NUMBER,
362: p_msg_data OUT NOCOPY VARCHAR2,
363: --

Line 368: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

364: p_row_id IN VARCHAR2,
365: p_account_position_set_id IN NUMBER,
366: p_name IN VARCHAR2,
367: p_set_of_books_id IN NUMBER,
368: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_data_extract_id IN NUMBER,
370: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_global_or_local_type IN VARCHAR2,
372: p_account_or_position_type IN VARCHAR2,

Line 370: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

366: p_name IN VARCHAR2,
367: p_set_of_books_id IN NUMBER,
368: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
369: p_data_extract_id IN NUMBER,
370: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_global_or_local_type IN VARCHAR2,
372: p_account_or_position_type IN VARCHAR2,
373: p_attribute_selection_type IN VARCHAR2,
374: p_business_group_id IN NUMBER,

Line 388: IF NOT FND_API.Compatible_API_Call ( l_api_version,

384: BEGIN
385: --
386: SAVEPOINT Update_Row_Pvt ;
387: --
388: IF NOT FND_API.Compatible_API_Call ( l_api_version,
389: p_api_version,
390: l_api_name,
391: G_PKG_NAME )
392: THEN

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

389: p_api_version,
390: l_api_name,
391: G_PKG_NAME )
392: THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
394: END IF;
395: --
396:
397: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 397: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
394: END IF;
395: --
396:
397: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
398: FND_MSG_PUB.initialize ;
399: END IF;
400: --
401: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 401: p_return_status := FND_API.G_RET_STS_SUCCESS ;

397: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
398: FND_MSG_PUB.initialize ;
399: END IF;
400: --
401: p_return_status := FND_API.G_RET_STS_SUCCESS ;
402: --
403:
404: UPDATE psb_account_position_sets
405: SET

Line 410: FND_API.G_MISS_CHAR, NULL,

406: account_position_set_id = p_account_position_set_id,
407: name = p_name,
408: set_of_books_id = p_set_of_books_id,
409: use_in_budget_group_flag = DECODE( p_use_in_budget_group_flag,
410: FND_API.G_MISS_CHAR, NULL,
411: p_use_in_budget_group_flag),
412: data_extract_id = p_data_extract_id,
413: budget_group_id = DECODE( p_budget_group_id,
414: FND_API.G_MISS_NUM,null,

Line 414: FND_API.G_MISS_NUM,null,

410: FND_API.G_MISS_CHAR, NULL,
411: p_use_in_budget_group_flag),
412: data_extract_id = p_data_extract_id,
413: budget_group_id = DECODE( p_budget_group_id,
414: FND_API.G_MISS_NUM,null,
415: p_budget_group_id),
416: global_or_local_type = p_global_or_local_type,
417: account_or_position_type = p_account_or_position_type,
418: attribute_selection_type = p_attribute_selection_type,

Line 430: IF FND_API.To_Boolean ( p_commit ) THEN

426: RAISE NO_DATA_FOUND ;
427: END IF;
428:
429: --
430: IF FND_API.To_Boolean ( p_commit ) THEN
431: COMMIT WORK;
432: END iF;
433: --
434: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: p_data => p_msg_data );
436: --
437: EXCEPTION
438: --
439: WHEN FND_API.G_EXC_ERROR THEN
440: --
441: ROLLBACK TO Update_Row_Pvt ;
442: p_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 442: p_return_status := FND_API.G_RET_STS_ERROR;

438: --
439: WHEN FND_API.G_EXC_ERROR THEN
440: --
441: ROLLBACK TO Update_Row_Pvt ;
442: p_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
444: p_data => p_msg_data );
445: --
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

442: p_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
444: p_data => p_msg_data );
445: --
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: --
448: ROLLBACK TO Update_Row_Pvt ;
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

445: --
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: --
448: ROLLBACK TO Update_Row_Pvt ;
449: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
451: p_data => p_msg_data );
452: --
453: WHEN OTHERS THEN

Line 456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: --
453: WHEN OTHERS THEN
454: --
455: ROLLBACK TO Update_Row_Pvt ;
456: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: --
458: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
459: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
460: l_api_name);

Line 477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

473: +==========================================================================*/
474: PROCEDURE Delete_Row
475: (
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_msg_count OUT NOCOPY NUMBER,

Line 478: p_commit IN VARCHAR2 := FND_API.G_FALSE,

474: PROCEDURE Delete_Row
475: (
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_msg_count OUT NOCOPY NUMBER,
482: p_msg_data OUT NOCOPY VARCHAR2,

Line 479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

475: (
476: p_api_version IN NUMBER,
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_commit IN VARCHAR2 := FND_API.G_FALSE,
479: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
480: p_return_status OUT NOCOPY VARCHAR2,
481: p_msg_count OUT NOCOPY NUMBER,
482: p_msg_data OUT NOCOPY VARCHAR2,
483: --

Line 502: IF NOT FND_API.Compatible_API_Call ( l_api_version,

498: BEGIN
499: --
500: SAVEPOINT Delete_Row_Pvt ;
501: --
502: IF NOT FND_API.Compatible_API_Call ( l_api_version,
503: p_api_version,
504: l_api_name,
505: G_PKG_NAME )
506: THEN

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

503: p_api_version,
504: l_api_name,
505: G_PKG_NAME )
506: THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
508: END IF;
509: --
510:
511: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 511: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
508: END IF;
509: --
510:
511: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
512: FND_MSG_PUB.initialize ;
513: END IF ;
514: --
515: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 515: p_return_status := FND_API.G_RET_STS_SUCCESS ;

511: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
512: FND_MSG_PUB.initialize ;
513: END IF ;
514: --
515: p_return_status := FND_API.G_RET_STS_SUCCESS ;
516: --
517:
518: --
519: -- Deleting dependent detail records from psb_account_position_set_lines.

Line 543: p_init_msg_list => FND_API.G_FALSE,

539: --
540: PSB_Acct_Position_Set_Line_Pvt.Delete_Row
541: (
542: p_api_version => 1.0 ,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
546: p_return_status => l_return_status,
547: p_msg_count => l_msg_count,

Line 544: p_commit => FND_API.G_FALSE,

540: PSB_Acct_Position_Set_Line_Pvt.Delete_Row
541: (
542: p_api_version => 1.0 ,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
546: p_return_status => l_return_status,
547: p_msg_count => l_msg_count,
548: p_msg_data => l_msg_data,

Line 545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

541: (
542: p_api_version => 1.0 ,
543: p_init_msg_list => FND_API.G_FALSE,
544: p_commit => FND_API.G_FALSE,
545: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
546: p_return_status => l_return_status,
547: p_msg_count => l_msg_count,
548: p_msg_data => l_msg_data,
549: --

Line 553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

549: --
550: p_row_id => l_lines_rec.rowid
551: );
552: --
553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
555: END IF ;
556: --
557: END LOOP ;

Line 554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

550: p_row_id => l_lines_rec.rowid
551: );
552: --
553: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
555: END IF ;
556: --
557: END LOOP ;
558:

Line 570: IF FND_API.To_Boolean ( p_commit ) THEN

566: RAISE NO_DATA_FOUND ;
567: END IF;
568:
569: --
570: IF FND_API.To_Boolean ( p_commit ) THEN
571: COMMIT WORK;
572: END iF;
573: --
574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 579: WHEN FND_API.G_EXC_ERROR THEN

575: p_data => p_msg_data );
576:
577: EXCEPTION
578: --
579: WHEN FND_API.G_EXC_ERROR THEN
580: --
581: ROLLBACK TO Delete_Row_Pvt ;
582: p_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 582: p_return_status := FND_API.G_RET_STS_ERROR;

578: --
579: WHEN FND_API.G_EXC_ERROR THEN
580: --
581: ROLLBACK TO Delete_Row_Pvt ;
582: p_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
584: p_data => p_msg_data );
585: --
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

582: p_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
584: p_data => p_msg_data );
585: --
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: --
588: ROLLBACK TO Delete_Row_Pvt ;
589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

585: --
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: --
588: ROLLBACK TO Delete_Row_Pvt ;
589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
591: p_data => p_msg_data );
592: --
593: WHEN OTHERS THEN

Line 596: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

592: --
593: WHEN OTHERS THEN
594: --
595: ROLLBACK TO Delete_Row_Pvt ;
596: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: --
598: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
599: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
600: l_api_name);

Line 617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

613: +==========================================================================*/
614: PROCEDURE Check_Unique
615: (
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: p_return_status OUT NOCOPY VARCHAR2,
621: p_msg_count OUT NOCOPY NUMBER,

Line 618: p_commit IN VARCHAR2 := FND_API.G_FALSE,

614: PROCEDURE Check_Unique
615: (
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: p_return_status OUT NOCOPY VARCHAR2,
621: p_msg_count OUT NOCOPY NUMBER,
622: p_msg_data OUT NOCOPY VARCHAR2,

Line 619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

615: (
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
618: p_commit IN VARCHAR2 := FND_API.G_FALSE,
619: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
620: p_return_status OUT NOCOPY VARCHAR2,
621: p_msg_count OUT NOCOPY NUMBER,
622: p_msg_data OUT NOCOPY VARCHAR2,
623: --

Line 656: IF NOT FND_API.Compatible_API_Call ( l_api_version,

652: BEGIN
653: --
654: SAVEPOINT Check_Unique_Pvt ;
655: --
656: IF NOT FND_API.Compatible_API_Call ( l_api_version,
657: p_api_version,
658: l_api_name,
659: G_PKG_NAME )
660: THEN

Line 661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

657: p_api_version,
658: l_api_name,
659: G_PKG_NAME )
660: THEN
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
662: END IF;
663: --
664:
665: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 665: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
662: END IF;
663: --
664:
665: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
666: FND_MSG_PUB.initialize ;
667: END IF;
668: --
669: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 669: p_return_status := FND_API.G_RET_STS_SUCCESS ;

665: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
666: FND_MSG_PUB.initialize ;
667: END IF;
668: --
669: p_return_status := FND_API.G_RET_STS_SUCCESS ;
670: --
671:
672: -- Checking the Psb_set_relations table for references.
673: OPEN c;

Line 685: IF FND_API.To_Boolean ( p_commit ) THEN

681: END IF;
682:
683: CLOSE c;
684: --
685: IF FND_API.To_Boolean ( p_commit ) THEN
686: COMMIT WORK;
687: END iF;
688: --
689: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690: p_data => p_msg_data );
691: --
692: EXCEPTION
693: --
694: WHEN FND_API.G_EXC_ERROR THEN
695: --
696: ROLLBACK TO Check_Unique_Pvt ;
697: p_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 697: p_return_status := FND_API.G_RET_STS_ERROR;

693: --
694: WHEN FND_API.G_EXC_ERROR THEN
695: --
696: ROLLBACK TO Check_Unique_Pvt ;
697: p_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
699: p_data => p_msg_data );
700: --
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

697: p_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
699: p_data => p_msg_data );
700: --
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: --
703: ROLLBACK TO Check_Unique_Pvt ;
704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

700: --
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: --
703: ROLLBACK TO Check_Unique_Pvt ;
704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
706: p_data => p_msg_data );
707: --
708: WHEN OTHERS THEN

Line 711: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

707: --
708: WHEN OTHERS THEN
709: --
710: ROLLBACK TO Check_Unique_Pvt ;
711: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
712: --
713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
714: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
715: l_api_name);

Line 732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

728: +==========================================================================*/
729: PROCEDURE Check_References
730: (
731: p_api_version IN NUMBER,
732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
733: p_commit IN VARCHAR2 := FND_API.G_FALSE,
734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
735: p_return_status OUT NOCOPY VARCHAR2,
736: p_msg_count OUT NOCOPY NUMBER,

Line 733: p_commit IN VARCHAR2 := FND_API.G_FALSE,

729: PROCEDURE Check_References
730: (
731: p_api_version IN NUMBER,
732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
733: p_commit IN VARCHAR2 := FND_API.G_FALSE,
734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
735: p_return_status OUT NOCOPY VARCHAR2,
736: p_msg_count OUT NOCOPY NUMBER,
737: p_msg_data OUT NOCOPY VARCHAR2,

Line 734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

730: (
731: p_api_version IN NUMBER,
732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
733: p_commit IN VARCHAR2 := FND_API.G_FALSE,
734: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
735: p_return_status OUT NOCOPY VARCHAR2,
736: p_msg_count OUT NOCOPY NUMBER,
737: p_msg_data OUT NOCOPY VARCHAR2,
738: --

Line 786: IF NOT FND_API.Compatible_API_Call ( l_api_version,

782: */
783:
784: SAVEPOINT Check_References_Pvt ;
785: --
786: IF NOT FND_API.Compatible_API_Call ( l_api_version,
787: p_api_version,
788: l_api_name,
789: G_PKG_NAME )
790: THEN

Line 791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

787: p_api_version,
788: l_api_name,
789: G_PKG_NAME )
790: THEN
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
792: END IF;
793: --
794:
795: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 795: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
792: END IF;
793: --
794:
795: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
796: FND_MSG_PUB.initialize ;
797: END IF;
798: --
799: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 799: p_return_status := FND_API.G_RET_STS_SUCCESS ;

795: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
796: FND_MSG_PUB.initialize ;
797: END IF;
798: --
799: p_return_status := FND_API.G_RET_STS_SUCCESS ;
800: --
801:
802: -- First check whether it has been referenced by any entity.
803: OPEN l_check_set_relation_csr;

Line 888: IF FND_API.To_Boolean ( p_commit ) THEN

884: END IF;
885: -- End Checking references.
886:
887: --
888: IF FND_API.To_Boolean ( p_commit ) THEN
889: COMMIT WORK;
890: END iF;
891: --
892: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 897: WHEN FND_API.G_EXC_ERROR THEN

893: p_data => p_msg_data );
894:
895: EXCEPTION
896: --
897: WHEN FND_API.G_EXC_ERROR THEN
898: --
899: ROLLBACK TO Check_References_Pvt ;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 900: p_return_status := FND_API.G_RET_STS_ERROR;

896: --
897: WHEN FND_API.G_EXC_ERROR THEN
898: --
899: ROLLBACK TO Check_References_Pvt ;
900: p_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
902: p_data => p_msg_data );
903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

900: p_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
902: p_data => p_msg_data );
903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --
906: ROLLBACK TO Check_References_Pvt ;
907: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 907: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

903: --
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: --
906: ROLLBACK TO Check_References_Pvt ;
907: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
909: p_data => p_msg_data );
910: --
911: WHEN OTHERS THEN

Line 914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

910: --
911: WHEN OTHERS THEN
912: --
913: ROLLBACK TO Check_References_Pvt ;
914: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915: --
916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
917: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
918: l_api_name);

Line 939: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

935: --
936: PROCEDURE Copy_Position_Sets
937: (
938: p_api_version IN NUMBER,
939: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
940: p_commit IN VARCHAR2 := FND_API.G_FALSE,
941: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
942: p_return_status OUT NOCOPY VARCHAR2,
943: p_msg_count OUT NOCOPY NUMBER,

Line 940: p_commit IN VARCHAR2 := FND_API.G_FALSE,

936: PROCEDURE Copy_Position_Sets
937: (
938: p_api_version IN NUMBER,
939: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
940: p_commit IN VARCHAR2 := FND_API.G_FALSE,
941: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
942: p_return_status OUT NOCOPY VARCHAR2,
943: p_msg_count OUT NOCOPY NUMBER,
944: p_msg_data OUT NOCOPY VARCHAR2,

Line 941: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

937: (
938: p_api_version IN NUMBER,
939: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
940: p_commit IN VARCHAR2 := FND_API.G_FALSE,
941: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
942: p_return_status OUT NOCOPY VARCHAR2,
943: p_msg_count OUT NOCOPY NUMBER,
944: p_msg_data OUT NOCOPY VARCHAR2,
945: --

Line 978: IF NOT FND_API.Compatible_API_Call ( l_api_version,

974: BEGIN
975: --
976: SAVEPOINT Copy_Position_Sets_Pvt ;
977: --
978: IF NOT FND_API.Compatible_API_Call ( l_api_version,
979: p_api_version,
980: l_api_name,
981: G_PKG_NAME )
982: THEN

Line 983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

979: p_api_version,
980: l_api_name,
981: G_PKG_NAME )
982: THEN
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
984: END IF;
985: --
986:
987: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 987: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
984: END IF;
985: --
986:
987: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
988: FND_MSG_PUB.initialize ;
989: END IF;
990: --
991: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 991: p_return_status := FND_API.G_RET_STS_SUCCESS ;

987: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
988: FND_MSG_PUB.initialize ;
989: END IF;
990: --
991: p_return_status := FND_API.G_RET_STS_SUCCESS ;
992: --
993:
994: --
995: -- Validate the p_entity_table.

Line 1005: RAISE FND_API.G_EXC_ERROR ;

1001: --
1002: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_ENTITY_TYPE') ;
1003: Fnd_Message.Set_Token('ENTITY_TYPE', p_entity_table(i) ) ;
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_ERROR ;
1006: --
1007: END IF;
1008:
1009: END LOOP;

Line 1022: RAISE FND_API.G_EXC_ERROR ;

1018: --
1019: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_DATA_EXTRACT') ;
1020: Fnd_Message.Set_Token('DATA_EXTRACT', p_source_data_extract_id ) ;
1021: FND_MSG_PUB.Add;
1022: RAISE FND_API.G_EXC_ERROR ;
1023: --
1024: END IF ;
1025:
1026: --

Line 1037: RAISE FND_API.G_EXC_ERROR ;

1033: --
1034: Fnd_Message.Set_Name ('PSB', 'PSB_INVALID_DATA_EXTRACT') ;
1035: Fnd_Message.Set_Token('DATA_EXTRACT', p_target_data_extract_id ) ;
1036: FND_MSG_PUB.Add;
1037: RAISE FND_API.G_EXC_ERROR ;
1038: --
1039: END IF ;
1040:
1041:

Line 1056: p_init_msg_list => FND_API.G_TRUE,

1052:
1053: Copy_Position_Set
1054: (
1055: p_api_version => 1.0,
1056: p_init_msg_list => FND_API.G_TRUE,
1057: p_commit => FND_API.G_FALSE,
1058: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1059: p_return_status => l_return_status,
1060: p_msg_count => l_msg_count,

Line 1057: p_commit => FND_API.G_FALSE,

1053: Copy_Position_Set
1054: (
1055: p_api_version => 1.0,
1056: p_init_msg_list => FND_API.G_TRUE,
1057: p_commit => FND_API.G_FALSE,
1058: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1059: p_return_status => l_return_status,
1060: p_msg_count => l_msg_count,
1061: p_msg_data => l_msg_data,

Line 1058: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1054: (
1055: p_api_version => 1.0,
1056: p_init_msg_list => FND_API.G_TRUE,
1057: p_commit => FND_API.G_FALSE,
1058: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1059: p_return_status => l_return_status,
1060: p_msg_count => l_msg_count,
1061: p_msg_data => l_msg_data,
1062: --

Line 1070: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1066: p_target_business_group_id => l_target_business_group_id,
1067: p_new_position_set_id => l_new_position_set_id
1068: ) ;
1069: --
1070: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1071: RAISE FND_API.G_EXC_ERROR ;
1072: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1074: END IF;

Line 1071: RAISE FND_API.G_EXC_ERROR ;

1067: p_new_position_set_id => l_new_position_set_id
1068: ) ;
1069: --
1070: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1071: RAISE FND_API.G_EXC_ERROR ;
1072: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1074: END IF;
1075: --

Line 1072: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1068: ) ;
1069: --
1070: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1071: RAISE FND_API.G_EXC_ERROR ;
1072: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1074: END IF;
1075: --
1076:

Line 1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1069: --
1070: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1071: RAISE FND_API.G_EXC_ERROR ;
1072: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1074: END IF;
1075: --
1076:
1077: END LOOP ;

Line 1112: p_init_msg_list => FND_API.G_TRUE,

1108: --
1109: Copy_Position_Set
1110: (
1111: p_api_version => 1.0,
1112: p_init_msg_list => FND_API.G_TRUE,
1113: p_commit => FND_API.G_FALSE,
1114: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1115: p_return_status => l_return_status,
1116: p_msg_count => l_msg_count,

Line 1113: p_commit => FND_API.G_FALSE,

1109: Copy_Position_Set
1110: (
1111: p_api_version => 1.0,
1112: p_init_msg_list => FND_API.G_TRUE,
1113: p_commit => FND_API.G_FALSE,
1114: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1115: p_return_status => l_return_status,
1116: p_msg_count => l_msg_count,
1117: p_msg_data => l_msg_data,

Line 1114: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1110: (
1111: p_api_version => 1.0,
1112: p_init_msg_list => FND_API.G_TRUE,
1113: p_commit => FND_API.G_FALSE,
1114: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1115: p_return_status => l_return_status,
1116: p_msg_count => l_msg_count,
1117: p_msg_data => l_msg_data,
1118: --

Line 1126: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1122: p_target_business_group_id => l_target_business_group_id,
1123: p_new_position_set_id => l_new_position_set_id
1124: ) ;
1125: --
1126: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR ;
1128: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1130: END IF;

Line 1127: RAISE FND_API.G_EXC_ERROR ;

1123: p_new_position_set_id => l_new_position_set_id
1124: ) ;
1125: --
1126: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR ;
1128: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1130: END IF;
1131: --

Line 1128: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1124: ) ;
1125: --
1126: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR ;
1128: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1130: END IF;
1131: --
1132:

Line 1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1125: --
1126: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR ;
1128: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1130: END IF;
1131: --
1132:
1133: END LOOP ; -- End local sets.

Line 1138: IF FND_API.To_Boolean ( p_commit ) THEN

1134:
1135: END LOOP ; -- End p_entity_table table.
1136:
1137: --
1138: IF FND_API.To_Boolean ( p_commit ) THEN
1139: COMMIT WORK;
1140: END iF;
1141: --
1142: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1148: WHEN FND_API.G_EXC_ERROR THEN

1144:
1145: --
1146: EXCEPTION
1147: --
1148: WHEN FND_API.G_EXC_ERROR THEN
1149: --
1150: ROLLBACK TO Copy_Position_Sets_Pvt ;
1151: p_return_status := FND_API.G_RET_STS_ERROR;
1152: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1151: p_return_status := FND_API.G_RET_STS_ERROR;

1147: --
1148: WHEN FND_API.G_EXC_ERROR THEN
1149: --
1150: ROLLBACK TO Copy_Position_Sets_Pvt ;
1151: p_return_status := FND_API.G_RET_STS_ERROR;
1152: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1153: p_data => p_msg_data );
1154: --
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1151: p_return_status := FND_API.G_RET_STS_ERROR;
1152: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1153: p_data => p_msg_data );
1154: --
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: --
1157: ROLLBACK TO Copy_Position_Sets_Pvt ;
1158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1154: --
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: --
1157: ROLLBACK TO Copy_Position_Sets_Pvt ;
1158: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1160: p_data => p_msg_data );
1161: --
1162: WHEN OTHERS THEN

Line 1165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1161: --
1162: WHEN OTHERS THEN
1163: --
1164: ROLLBACK TO Copy_Position_Sets_Pvt ;
1165: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: --
1167: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1168: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1169: l_api_name);

Line 1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1185: --
1186: PROCEDURE Copy_Position_Set
1187: (
1188: p_api_version IN NUMBER,
1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1192: p_return_status OUT NOCOPY VARCHAR2,
1193: p_msg_count OUT NOCOPY NUMBER,

Line 1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1186: PROCEDURE Copy_Position_Set
1187: (
1188: p_api_version IN NUMBER,
1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1192: p_return_status OUT NOCOPY VARCHAR2,
1193: p_msg_count OUT NOCOPY NUMBER,
1194: p_msg_data OUT NOCOPY VARCHAR2,

Line 1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1187: (
1188: p_api_version IN NUMBER,
1189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1191: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1192: p_return_status OUT NOCOPY VARCHAR2,
1193: p_msg_count OUT NOCOPY NUMBER,
1194: p_msg_data OUT NOCOPY VARCHAR2,
1195: --

Line 1260: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1256: BEGIN
1257: --
1258: SAVEPOINT Copy_Position_Set_Pvt ;
1259: --
1260: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1261: p_api_version,
1262: l_api_name,
1263: G_PKG_NAME )
1264: THEN

Line 1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1261: p_api_version,
1262: l_api_name,
1263: G_PKG_NAME )
1264: THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1266: END IF;
1267: --
1268:
1269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 1269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1266: END IF;
1267: --
1268:
1269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1270: FND_MSG_PUB.initialize ;
1271: END IF;
1272: --
1273: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1273: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1269: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
1270: FND_MSG_PUB.initialize ;
1271: END IF;
1272: --
1273: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1274:
1275: pd( 'position set id :' || p_source_position_set_id ) ;
1276:
1277: --

Line 1310: p_init_msg_list => FND_API.G_TRUE,

1306:
1307: PSB_Account_Position_Set_Pvt.Insert_Row
1308: (
1309: p_api_version => 1.0,
1310: p_init_msg_list => FND_API.G_TRUE,
1311: p_commit => FND_API.G_FALSE,
1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1313: p_return_status => l_return_status,
1314: p_msg_count => l_msg_count,

Line 1311: p_commit => FND_API.G_FALSE,

1307: PSB_Account_Position_Set_Pvt.Insert_Row
1308: (
1309: p_api_version => 1.0,
1310: p_init_msg_list => FND_API.G_TRUE,
1311: p_commit => FND_API.G_FALSE,
1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1313: p_return_status => l_return_status,
1314: p_msg_count => l_msg_count,
1315: p_msg_data => l_msg_data,

Line 1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1308: (
1309: p_api_version => 1.0,
1310: p_init_msg_list => FND_API.G_TRUE,
1311: p_commit => FND_API.G_FALSE,
1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1313: p_return_status => l_return_status,
1314: p_msg_count => l_msg_count,
1315: p_msg_data => l_msg_data,
1316: --

Line 1334: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1330: p_created_by => l_current_user_id,
1331: p_creation_date => l_current_date
1332: );
1333: --
1334: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR ;
1336: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1338: END IF;

Line 1335: RAISE FND_API.G_EXC_ERROR ;

1331: p_creation_date => l_current_date
1332: );
1333: --
1334: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR ;
1336: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1338: END IF;
1339: --

Line 1336: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1332: );
1333: --
1334: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR ;
1336: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1338: END IF;
1339: --
1340:

Line 1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1333: --
1334: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR ;
1336: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1338: END IF;
1339: --
1340:
1341: -- Populate the new position id field.

Line 1377: p_init_msg_list => FND_API.G_TRUE,

1373:
1374: PSB_Acct_Position_Set_Line_Pvt.Insert_Row
1375: (
1376: p_api_version => 1.0,
1377: p_init_msg_list => FND_API.G_TRUE,
1378: p_commit => FND_API.G_FALSE,
1379: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1380: p_return_status => l_return_status,
1381: p_msg_count => l_msg_count,

Line 1378: p_commit => FND_API.G_FALSE,

1374: PSB_Acct_Position_Set_Line_Pvt.Insert_Row
1375: (
1376: p_api_version => 1.0,
1377: p_init_msg_list => FND_API.G_TRUE,
1378: p_commit => FND_API.G_FALSE,
1379: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1380: p_return_status => l_return_status,
1381: p_msg_count => l_msg_count,
1382: p_msg_data => l_msg_data,

Line 1379: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1375: (
1376: p_api_version => 1.0,
1377: p_init_msg_list => FND_API.G_TRUE,
1378: p_commit => FND_API.G_FALSE,
1379: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1380: p_return_status => l_return_status,
1381: p_msg_count => l_msg_count,
1382: p_msg_data => l_msg_data,
1383: --

Line 1469: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1465: p_created_by => l_current_user_id,
1466: p_creation_date => l_current_date
1467: );
1468: --
1469: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1470: RAISE FND_API.G_EXC_ERROR ;
1471: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1473: END IF;

Line 1470: RAISE FND_API.G_EXC_ERROR ;

1466: p_creation_date => l_current_date
1467: );
1468: --
1469: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1470: RAISE FND_API.G_EXC_ERROR ;
1471: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1473: END IF;
1474: --

Line 1471: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1467: );
1468: --
1469: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1470: RAISE FND_API.G_EXC_ERROR ;
1471: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1473: END IF;
1474: --
1475:

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1468: --
1469: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1470: RAISE FND_API.G_EXC_ERROR ;
1471: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1473: END IF;
1474: --
1475:
1476: pd( 'Created set line:' || l_line_sequence_id ) ;

Line 1524: p_init_msg_list => FND_API.G_TRUE,

1520:
1521: PSB_Pos_Set_Line_Values_Pvt.Insert_Row
1522: (
1523: p_api_version => 1.0,
1524: p_init_msg_list => FND_API.G_TRUE,
1525: p_commit => FND_API.G_FALSE,
1526: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1527: p_return_status => l_return_status,
1528: p_msg_count => l_msg_count,

Line 1525: p_commit => FND_API.G_FALSE,

1521: PSB_Pos_Set_Line_Values_Pvt.Insert_Row
1522: (
1523: p_api_version => 1.0,
1524: p_init_msg_list => FND_API.G_TRUE,
1525: p_commit => FND_API.G_FALSE,
1526: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1527: p_return_status => l_return_status,
1528: p_msg_count => l_msg_count,
1529: p_msg_data => l_msg_data,

Line 1526: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1522: (
1523: p_api_version => 1.0,
1524: p_init_msg_list => FND_API.G_TRUE,
1525: p_commit => FND_API.G_FALSE,
1526: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1527: p_return_status => l_return_status,
1528: p_msg_count => l_msg_count,
1529: p_msg_data => l_msg_data,
1530: --

Line 1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1539: p_created_by => l_current_user_id,
1540: p_creation_date => l_current_date
1541: );
1542: --
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR ;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1547: END IF;

Line 1544: RAISE FND_API.G_EXC_ERROR ;

1540: p_creation_date => l_current_date
1541: );
1542: --
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR ;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1547: END IF;
1548: --

Line 1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1541: );
1542: --
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR ;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1547: END IF;
1548: --
1549:

Line 1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1542: --
1543: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544: RAISE FND_API.G_EXC_ERROR ;
1545: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1547: END IF;
1548: --
1549:
1550: pd( 'Created val :' || l_line_sequence_id || '-' || l_value_sequence_id);

Line 1561: IF FND_API.To_Boolean ( p_commit ) THEN

1557: NULL;
1558: END LOOP ;
1559:
1560: --
1561: IF FND_API.To_Boolean ( p_commit ) THEN
1562: COMMIT WORK;
1563: END iF;
1564: --
1565: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1570: WHEN FND_API.G_EXC_ERROR THEN

1566: p_data => p_msg_data );
1567: --
1568: EXCEPTION
1569: --
1570: WHEN FND_API.G_EXC_ERROR THEN
1571: --
1572: ROLLBACK TO Copy_Position_Set_Pvt ;
1573: p_return_status := FND_API.G_RET_STS_ERROR ;
1574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1573: p_return_status := FND_API.G_RET_STS_ERROR ;

1569: --
1570: WHEN FND_API.G_EXC_ERROR THEN
1571: --
1572: ROLLBACK TO Copy_Position_Set_Pvt ;
1573: p_return_status := FND_API.G_RET_STS_ERROR ;
1574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1575: p_data => p_msg_data );
1576: --
1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1573: p_return_status := FND_API.G_RET_STS_ERROR ;
1574: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1575: p_data => p_msg_data );
1576: --
1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1578: --
1579: ROLLBACK TO Copy_Position_Set_Pvt ;
1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1576: --
1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1578: --
1579: ROLLBACK TO Copy_Position_Set_Pvt ;
1580: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
1582: p_data => p_msg_data );
1583: --
1584: WHEN OTHERS THEN

Line 1587: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1583: --
1584: WHEN OTHERS THEN
1585: --
1586: ROLLBACK TO Copy_Position_Set_Pvt ;
1587: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: --
1589: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1590: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
1591: l_api_name);