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.

[Home] [Help]

APPS.PSB_ENTITY_PVT dependencies on FND_API

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

5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_ENTITY_PVT';
6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,

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

6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,

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

7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,
15: --

Line 24: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

20: P_NAME in VARCHAR2,
21: P_DESCRIPTION in VARCHAR2,
22: P_DATA_EXTRACT_ID in NUMBER,
23: P_SET_OF_BOOKS_ID in NUMBER,
24: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
25: P_ALLOCATION_TYPE in VARCHAR2,
26: P_BUDGET_YEAR_TYPE_ID in NUMBER,
27: P_BALANCE_TYPE in VARCHAR2,
28: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 48: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

44: P_ATTRIBUTE8 in VARCHAR2,
45: P_ATTRIBUTE9 in VARCHAR2,
46: P_ATTRIBUTE10 in VARCHAR2,
47: P_CONTEXT in VARCHAR2,
48: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
49: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
50: p_Last_Update_Date DATE,
51: p_Last_Updated_By NUMBER,
52: p_Last_Update_Login NUMBER,

Line 49: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

45: P_ATTRIBUTE9 in VARCHAR2,
46: P_ATTRIBUTE10 in VARCHAR2,
47: P_CONTEXT in VARCHAR2,
48: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
49: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
50: p_Last_Update_Date DATE,
51: p_Last_Updated_By NUMBER,
52: p_Last_Update_Login NUMBER,
53: p_Created_By NUMBER,

Line 69: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 78: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 82: p_return_status := FND_API.G_RET_STS_SUCCESS ;

78: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
79: FND_MSG_PUB.initialize ;
80: END IF;
81: --
82: p_return_status := FND_API.G_RET_STS_SUCCESS ;
83: --
84:
85: insert into PSB_ENTITY (
86: ENTITY_ID,

Line 132: decode(P_BUDGET_GROUP_ID, FND_API.G_MISS_NUM, null, P_BUDGET_GROUP_ID),

128: P_NAME,
129: P_DESCRIPTION,
130: P_DATA_EXTRACT_ID,
131: P_SET_OF_BOOKS_ID,
132: decode(P_BUDGET_GROUP_ID, FND_API.G_MISS_NUM, null, P_BUDGET_GROUP_ID),
133: P_ALLOCATION_TYPE,
134: P_BUDGET_YEAR_TYPE_ID,
135: P_BALANCE_TYPE,
136: P_PARAMETER_AUTOINC_RULE,

Line 156: decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, null,

152: P_ATTRIBUTE8,
153: P_ATTRIBUTE9,
154: P_ATTRIBUTE10,
155: P_CONTEXT,
156: decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, null,
157: P_EFFECTIVE_START_DATE),
158: decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, null,
159: P_EFFECTIVE_END_DATE),
160: P_LAST_UPDATE_DATE,

Line 158: decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, null,

154: P_ATTRIBUTE10,
155: P_CONTEXT,
156: decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, null,
157: P_EFFECTIVE_START_DATE),
158: decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, null,
159: P_EFFECTIVE_END_DATE),
160: P_LAST_UPDATE_DATE,
161: P_LAST_UPDATED_BY,
162: P_LAST_UPDATE_DATE,

Line 171: raise FND_API.G_EXC_ERROR;

167: open c;
168: fetch c into P_ROWID;
169: if (c%notfound) then
170: close c;
171: raise FND_API.G_EXC_ERROR;
172: end if;
173: close c;
174:
175: --

Line 176: IF FND_API.To_Boolean ( p_commit ) THEN

172: end if;
173: close c;
174:
175: --
176: IF FND_API.To_Boolean ( p_commit ) THEN
177: COMMIT WORK;
178: END iF;
179: --
180: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 185: WHEN FND_API.G_EXC_ERROR THEN

181: p_data => p_msg_data );
182: --
183: EXCEPTION
184: --
185: WHEN FND_API.G_EXC_ERROR THEN
186: --
187: ROLLBACK TO Insert_Row_Pvt ;
188: p_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 188: p_return_status := FND_API.G_RET_STS_ERROR;

184: --
185: WHEN FND_API.G_EXC_ERROR THEN
186: --
187: ROLLBACK TO Insert_Row_Pvt ;
188: p_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
190: p_data => p_msg_data );
191: --
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

188: p_return_status := FND_API.G_RET_STS_ERROR;
189: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
190: p_data => p_msg_data );
191: --
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: --
194: ROLLBACK TO Insert_Row_Pvt ;
195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: --
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: --
194: ROLLBACK TO Insert_Row_Pvt ;
195: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
197: p_data => p_msg_data );
198: --
199: WHEN OTHERS THEN

Line 202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: --
199: WHEN OTHERS THEN
200: --
201: ROLLBACK TO Insert_Row_Pvt ;
202: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: --
204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
205: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
206: l_api_name);

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

212: END Insert_Row;
213:
214: procedure LOCK_ROW (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_return_status OUT NOCOPY VARCHAR2,
220: p_msg_count OUT NOCOPY NUMBER,

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

213:
214: procedure LOCK_ROW (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_return_status OUT NOCOPY VARCHAR2,
220: p_msg_count OUT NOCOPY NUMBER,
221: p_msg_data OUT NOCOPY VARCHAR2,

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

214: procedure LOCK_ROW (
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
217: p_commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: p_return_status OUT NOCOPY VARCHAR2,
220: p_msg_count OUT NOCOPY NUMBER,
221: p_msg_data OUT NOCOPY VARCHAR2,
222: p_lock_row OUT NOCOPY VARCHAR2,

Line 231: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

227: P_NAME in VARCHAR2,
228: P_DESCRIPTION in VARCHAR2,
229: P_DATA_EXTRACT_ID in NUMBER,
230: P_SET_OF_BOOKS_ID in NUMBER,
231: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
232: P_ALLOCATION_TYPE in VARCHAR2,
233: P_BUDGET_YEAR_TYPE_ID in NUMBER,
234: P_BALANCE_TYPE in VARCHAR2,
235: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 255: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

251: P_ATTRIBUTE8 in VARCHAR2,
252: P_ATTRIBUTE9 in VARCHAR2,
253: P_ATTRIBUTE10 in VARCHAR2,
254: P_CONTEXT in VARCHAR2,
255: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
256: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE
257: ) is
258: --
259: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 256: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE

252: P_ATTRIBUTE9 in VARCHAR2,
253: P_ATTRIBUTE10 in VARCHAR2,
254: P_CONTEXT in VARCHAR2,
255: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
256: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE
257: ) is
258: --
259: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
260: l_api_version CONSTANT NUMBER := 1.0;

Line 305: IF NOT FND_API.Compatible_API_Call ( l_api_version,

301: BEGIN
302: --
303: SAVEPOINT Lock_Row_Pvt ;
304: --
305: IF NOT FND_API.Compatible_API_Call ( l_api_version,
306: p_api_version,
307: l_api_name,
308: G_PKG_NAME )
309: THEN

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

306: p_api_version,
307: l_api_name,
308: G_PKG_NAME )
309: THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
311: END IF;
312: --
313:
314: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 314: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
311: END IF;
312: --
313:
314: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
315: FND_MSG_PUB.initialize ;
316: END IF;
317: --
318: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 318: p_return_status := FND_API.G_RET_STS_SUCCESS ;

314: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
315: FND_MSG_PUB.initialize ;
316: END IF;
317: --
318: p_return_status := FND_API.G_RET_STS_SUCCESS ;
319: --
320: open c1;
321: fetch c1 into tlinfo;
322: if (c1%notfound) then

Line 346: AND (P_BUDGET_GROUP_ID = FND_API.G_MISS_NUM)))

342: AND ((tlinfo.BUDGET_GROUP_ID = P_BUDGET_GROUP_ID)
343: OR ((tlinfo.BUDGET_GROUP_ID is null)
344: AND (P_BUDGET_GROUP_ID is null))
345: OR ((tlinfo.BUDGET_GROUP_ID is null)
346: AND (P_BUDGET_GROUP_ID = FND_API.G_MISS_NUM)))
347: AND ((tlinfo.ALLOCATION_TYPE = P_ALLOCATION_TYPE)
348: OR ((tlinfo.ALLOCATION_TYPE is null)
349: AND (P_ALLOCATION_TYPE is null)))
350: AND ((tlinfo.BUDGET_YEAR_TYPE_ID = P_BUDGET_YEAR_TYPE_ID)

Line 417: AND (P_EFFECTIVE_START_DATE = FND_API.G_MISS_DATE)))

413: AND ((tlinfo.EFFECTIVE_START_DATE = P_EFFECTIVE_START_DATE)
414: OR ((tlinfo.EFFECTIVE_START_DATE is null)
415: AND (P_EFFECTIVE_START_DATE is null))
416: OR ((tlinfo.EFFECTIVE_START_DATE is null)
417: AND (P_EFFECTIVE_START_DATE = FND_API.G_MISS_DATE)))
418: AND ((tlinfo.EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE)
419: OR ((tlinfo.EFFECTIVE_END_DATE is null)
420: AND (P_EFFECTIVE_END_DATE is null))
421: OR ((tlinfo.EFFECTIVE_END_DATE is null)

Line 422: AND (P_EFFECTIVE_END_DATE = FND_API.G_MISS_DATE)))

418: AND ((tlinfo.EFFECTIVE_END_DATE = P_EFFECTIVE_END_DATE)
419: OR ((tlinfo.EFFECTIVE_END_DATE is null)
420: AND (P_EFFECTIVE_END_DATE is null))
421: OR ((tlinfo.EFFECTIVE_END_DATE is null)
422: AND (P_EFFECTIVE_END_DATE = FND_API.G_MISS_DATE)))
423: ) then
424: p_lock_row := FND_API.G_TRUE;
425: ELSE
426: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 424: p_lock_row := FND_API.G_TRUE;

420: AND (P_EFFECTIVE_END_DATE is null))
421: OR ((tlinfo.EFFECTIVE_END_DATE is null)
422: AND (P_EFFECTIVE_END_DATE = FND_API.G_MISS_DATE)))
423: ) then
424: p_lock_row := FND_API.G_TRUE;
425: ELSE
426: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
427: FND_MSG_PUB.Add;
428: RAISE FND_API.G_EXC_ERROR ;

Line 428: RAISE FND_API.G_EXC_ERROR ;

424: p_lock_row := FND_API.G_TRUE;
425: ELSE
426: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
427: FND_MSG_PUB.Add;
428: RAISE FND_API.G_EXC_ERROR ;
429: END IF;
430:
431: --
432: IF FND_API.To_Boolean ( p_commit ) THEN

Line 432: IF FND_API.To_Boolean ( p_commit ) THEN

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

Line 444: p_lock_row := FND_API.G_FALSE;

440: --
441: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
442: --
443: ROLLBACK TO Lock_Row_Pvt ;
444: p_lock_row := FND_API.G_FALSE;
445: p_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
447: p_data => p_msg_data );
448: --

Line 445: p_return_status := FND_API.G_RET_STS_ERROR;

441: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
442: --
443: ROLLBACK TO Lock_Row_Pvt ;
444: p_lock_row := FND_API.G_FALSE;
445: p_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
447: p_data => p_msg_data );
448: --
449: WHEN FND_API.G_EXC_ERROR THEN

Line 449: WHEN FND_API.G_EXC_ERROR THEN

445: p_return_status := FND_API.G_RET_STS_ERROR;
446: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
447: p_data => p_msg_data );
448: --
449: WHEN FND_API.G_EXC_ERROR THEN
450: --
451: ROLLBACK TO Lock_Row_Pvt ;
452: p_lock_row := FND_API.G_FALSE;
453: p_return_status := FND_API.G_RET_STS_ERROR;

Line 452: p_lock_row := FND_API.G_FALSE;

448: --
449: WHEN FND_API.G_EXC_ERROR THEN
450: --
451: ROLLBACK TO Lock_Row_Pvt ;
452: p_lock_row := FND_API.G_FALSE;
453: p_return_status := FND_API.G_RET_STS_ERROR;
454: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
455: p_data => p_msg_data );
456: --

Line 453: p_return_status := FND_API.G_RET_STS_ERROR;

449: WHEN FND_API.G_EXC_ERROR THEN
450: --
451: ROLLBACK TO Lock_Row_Pvt ;
452: p_lock_row := FND_API.G_FALSE;
453: p_return_status := FND_API.G_RET_STS_ERROR;
454: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
455: p_data => p_msg_data );
456: --
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

453: p_return_status := FND_API.G_RET_STS_ERROR;
454: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
455: p_data => p_msg_data );
456: --
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: --
459: ROLLBACK TO Lock_Row_Pvt ;
460: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 460: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

456: --
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: --
459: ROLLBACK TO Lock_Row_Pvt ;
460: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
461: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
462: p_data => p_msg_data );
463: --
464: WHEN OTHERS THEN

Line 467: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463: --
464: WHEN OTHERS THEN
465: --
466: ROLLBACK TO Lock_Row_Pvt ;
467: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: --
469: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
470: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
471: l_api_name);

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

477: END Lock_Row;
478:
479: procedure UPDATE_ROW (
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
484: p_return_status OUT NOCOPY VARCHAR2,
485: p_msg_count OUT NOCOPY NUMBER,

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

478:
479: procedure UPDATE_ROW (
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
484: p_return_status OUT NOCOPY VARCHAR2,
485: p_msg_count OUT NOCOPY NUMBER,
486: p_msg_data OUT NOCOPY VARCHAR2,

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

479: procedure UPDATE_ROW (
480: p_api_version IN NUMBER,
481: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
484: p_return_status OUT NOCOPY VARCHAR2,
485: p_msg_count OUT NOCOPY NUMBER,
486: p_msg_data OUT NOCOPY VARCHAR2,
487: --

Line 495: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,

491: P_NAME in VARCHAR2,
492: P_DESCRIPTION in VARCHAR2,
493: P_DATA_EXTRACT_ID in NUMBER,
494: P_SET_OF_BOOKS_ID in NUMBER,
495: P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
496: P_ALLOCATION_TYPE in VARCHAR2,
497: P_BUDGET_YEAR_TYPE_ID in NUMBER,
498: P_BALANCE_TYPE in VARCHAR2,
499: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 519: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

515: P_ATTRIBUTE8 in VARCHAR2,
516: P_ATTRIBUTE9 in VARCHAR2,
517: P_ATTRIBUTE10 in VARCHAR2,
518: P_CONTEXT in VARCHAR2,
519: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
520: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
521: p_Last_Update_Date DATE,
522: p_Last_Updated_By NUMBER,
523: p_Last_Update_Login NUMBER

Line 520: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

516: P_ATTRIBUTE9 in VARCHAR2,
517: P_ATTRIBUTE10 in VARCHAR2,
518: P_CONTEXT in VARCHAR2,
519: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
520: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
521: p_Last_Update_Date DATE,
522: p_Last_Updated_By NUMBER,
523: p_Last_Update_Login NUMBER
524: ) is

Line 533: IF NOT FND_API.Compatible_API_Call ( l_api_version,

529: BEGIN
530: --
531: SAVEPOINT Update_Row_Pvt ;
532: --
533: IF NOT FND_API.Compatible_API_Call ( l_api_version,
534: p_api_version,
535: l_api_name,
536: G_PKG_NAME )
537: THEN

Line 538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

534: p_api_version,
535: l_api_name,
536: G_PKG_NAME )
537: THEN
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
539: END IF;
540: --
541:
542: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 542: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
539: END IF;
540: --
541:
542: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
543: FND_MSG_PUB.initialize ;
544: END IF;
545: --
546: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 546: p_return_status := FND_API.G_RET_STS_SUCCESS ;

542: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
543: FND_MSG_PUB.initialize ;
544: END IF;
545: --
546: p_return_status := FND_API.G_RET_STS_SUCCESS ;
547: --
548: update PSB_ENTITY set
549: ENTITY_TYPE = P_ENTITY_TYPE,
550: ENTITY_SUBTYPE = P_ENTITY_SUBTYPE,

Line 555: BUDGET_GROUP_ID = decode(P_BUDGET_GROUP_ID, FND_API.G_MISS_NUM,

551: NAME = P_NAME,
552: DESCRIPTION = P_DESCRIPTION,
553: DATA_EXTRACT_ID = P_DATA_EXTRACT_ID,
554: SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID,
555: BUDGET_GROUP_ID = decode(P_BUDGET_GROUP_ID, FND_API.G_MISS_NUM,
556: null, P_BUDGET_GROUP_ID),
557: ALLOCATION_TYPE = P_ALLOCATION_TYPE,
558: BUDGET_YEAR_TYPE_ID = P_BUDGET_YEAR_TYPE_ID,
559: BALANCE_TYPE = P_BALANCE_TYPE,

Line 580: EFFECTIVE_START_DATE = decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE,

576: ATTRIBUTE8 = P_ATTRIBUTE8,
577: ATTRIBUTE9 = P_ATTRIBUTE9,
578: ATTRIBUTE10 = P_ATTRIBUTE10,
579: CONTEXT = P_CONTEXT,
580: EFFECTIVE_START_DATE = decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE,
581: null, P_EFFECTIVE_START_DATE),
582: EFFECTIVE_END_DATE = decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE,
583: null, P_EFFECTIVE_END_DATE),
584: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,

Line 582: EFFECTIVE_END_DATE = decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE,

578: ATTRIBUTE10 = P_ATTRIBUTE10,
579: CONTEXT = P_CONTEXT,
580: EFFECTIVE_START_DATE = decode(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE,
581: null, P_EFFECTIVE_START_DATE),
582: EFFECTIVE_END_DATE = decode(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE,
583: null, P_EFFECTIVE_END_DATE),
584: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
585: LAST_UPDATED_BY = P_LAST_UPDATED_BY,
586: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN

Line 590: raise FND_API.G_EXC_ERROR;

586: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
587: where ENTITY_ID = P_ENTITY_ID
588: ;
589: if (sql%notfound) then
590: raise FND_API.G_EXC_ERROR;
591: end if;
592: --
593: IF FND_API.To_Boolean ( p_commit ) THEN
594: COMMIT WORK;

Line 593: IF FND_API.To_Boolean ( p_commit ) THEN

589: if (sql%notfound) then
590: raise FND_API.G_EXC_ERROR;
591: end if;
592: --
593: IF FND_API.To_Boolean ( p_commit ) THEN
594: COMMIT WORK;
595: END iF;
596: --
597: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 602: WHEN FND_API.G_EXC_ERROR THEN

598: p_data => p_msg_data );
599: --
600: EXCEPTION
601: --
602: WHEN FND_API.G_EXC_ERROR THEN
603: --
604: ROLLBACK TO Update_Row_Pvt ;
605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 605: p_return_status := FND_API.G_RET_STS_ERROR;

601: --
602: WHEN FND_API.G_EXC_ERROR THEN
603: --
604: ROLLBACK TO Update_Row_Pvt ;
605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
607: p_data => p_msg_data );
608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

605: p_return_status := FND_API.G_RET_STS_ERROR;
606: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
607: p_data => p_msg_data );
608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: --
611: ROLLBACK TO Update_Row_Pvt ;
612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

608: --
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: --
611: ROLLBACK TO Update_Row_Pvt ;
612: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
613: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
614: p_data => p_msg_data );
615: --
616: WHEN OTHERS THEN

Line 619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: --
616: WHEN OTHERS THEN
617: --
618: ROLLBACK TO Update_Row_Pvt ;
619: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: --
621: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
622: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
623: l_api_name);

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

629: END Update_Row;
630:
631: procedure ADD_ROW(
632: p_api_version IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_commit IN VARCHAR2 := FND_API.G_FALSE,
635: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
636: p_return_status OUT NOCOPY VARCHAR2,
637: p_msg_count OUT NOCOPY NUMBER,

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

630:
631: procedure ADD_ROW(
632: p_api_version IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_commit IN VARCHAR2 := FND_API.G_FALSE,
635: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
636: p_return_status OUT NOCOPY VARCHAR2,
637: p_msg_count OUT NOCOPY NUMBER,
638: p_msg_data OUT NOCOPY VARCHAR2,

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

631: procedure ADD_ROW(
632: p_api_version IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_commit IN VARCHAR2 := FND_API.G_FALSE,
635: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
636: p_return_status OUT NOCOPY VARCHAR2,
637: p_msg_count OUT NOCOPY NUMBER,
638: p_msg_data OUT NOCOPY VARCHAR2,
639: --

Line 648: P_BUDGET_GROUP_ID in NUMBER :=FND_API.G_MISS_NUM,

644: P_NAME in VARCHAR2,
645: P_DESCRIPTION in VARCHAR2,
646: P_DATA_EXTRACT_ID in NUMBER,
647: P_SET_OF_BOOKS_ID in NUMBER,
648: P_BUDGET_GROUP_ID in NUMBER :=FND_API.G_MISS_NUM,
649: P_ALLOCATION_TYPE in VARCHAR2,
650: P_BUDGET_YEAR_TYPE_ID in NUMBER,
651: P_BALANCE_TYPE in VARCHAR2,
652: P_PARAMETER_AUTOINC_RULE in VARCHAR2,

Line 672: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,

668: P_ATTRIBUTE8 in VARCHAR2,
669: P_ATTRIBUTE9 in VARCHAR2,
670: P_ATTRIBUTE10 in VARCHAR2,
671: P_CONTEXT in VARCHAR2,
672: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
673: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
674: p_Last_Update_Date DATE,
675: p_Last_Updated_By NUMBER,
676: p_Last_Update_Login NUMBER,

Line 673: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,

669: P_ATTRIBUTE9 in VARCHAR2,
670: P_ATTRIBUTE10 in VARCHAR2,
671: P_CONTEXT in VARCHAR2,
672: P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
673: P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
674: p_Last_Update_Date DATE,
675: p_Last_Updated_By NUMBER,
676: p_Last_Update_Login NUMBER,
677: p_Created_By NUMBER,

Line 696: if FND_API.to_Boolean (p_init_msg_list) then

692: SAVEPOINT Add_Row;
693: --
694: -- Initialize message list if p_init_msg_list is set to TRUE.
695: --
696: if FND_API.to_Boolean (p_init_msg_list) then
697: FND_MSG_PUB.initialize;
698: end if;
699: --
700: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 700: p_return_status := FND_API.G_RET_STS_SUCCESS ;

696: if FND_API.to_Boolean (p_init_msg_list) then
697: FND_MSG_PUB.initialize;
698: end if;
699: --
700: p_return_status := FND_API.G_RET_STS_SUCCESS ;
701: --
702: open c;
703: fetch c into dummy;
704: if (c%notfound) then

Line 807: if FND_API.to_Boolean (p_commit) then

803: p_last_update_login );
804:
805: --
806: -- Standard check of p_commit.
807: if FND_API.to_Boolean (p_commit) then
808: commit work;
809: end if;
810: -- Standard call to get message count and if count is 1, get message info.
811: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 817: when FND_API.G_EXC_ERROR then

813: --
814:
815: EXCEPTION
816: --
817: when FND_API.G_EXC_ERROR then
818: --
819: rollback to ADD_ROW ;
820: p_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 820: p_return_status := FND_API.G_RET_STS_ERROR;

816: --
817: when FND_API.G_EXC_ERROR then
818: --
819: rollback to ADD_ROW ;
820: p_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
822: p_data => p_msg_data);
823: --
824: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 824: when FND_API.G_EXC_UNEXPECTED_ERROR then

820: p_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
822: p_data => p_msg_data);
823: --
824: when FND_API.G_EXC_UNEXPECTED_ERROR then
825: --
826: rollback to ADD_ROW ;
827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

823: --
824: when FND_API.G_EXC_UNEXPECTED_ERROR then
825: --
826: rollback to ADD_ROW ;
827: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
828: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
829: p_data => p_msg_data);
830: --
831: when OTHERS then

Line 834: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

830: --
831: when OTHERS then
832: --
833: rollback to ADD_ROW ;
834: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
835: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
836: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
837: l_api_name);
838: END if;

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

843:
844:
845: procedure DELETE_ROW (
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
848: p_commit IN VARCHAR2 := FND_API.G_FALSE,
849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
850: p_return_status OUT NOCOPY VARCHAR2,
851: p_msg_count OUT NOCOPY NUMBER,

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

844:
845: procedure DELETE_ROW (
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
848: p_commit IN VARCHAR2 := FND_API.G_FALSE,
849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
850: p_return_status OUT NOCOPY VARCHAR2,
851: p_msg_count OUT NOCOPY NUMBER,
852: p_msg_data OUT NOCOPY VARCHAR2,

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

845: procedure DELETE_ROW (
846: p_api_version IN NUMBER,
847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
848: p_commit IN VARCHAR2 := FND_API.G_FALSE,
849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
850: p_return_status OUT NOCOPY VARCHAR2,
851: p_msg_count OUT NOCOPY NUMBER,
852: p_msg_data OUT NOCOPY VARCHAR2,
853: --

Line 864: IF NOT FND_API.Compatible_API_Call ( l_api_version,

860: BEGIN
861: --
862: SAVEPOINT Delete_Row_Pvt ;
863: --
864: IF NOT FND_API.Compatible_API_Call ( l_api_version,
865: p_api_version,
866: l_api_name,
867: G_PKG_NAME )
868: THEN

Line 869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

865: p_api_version,
866: l_api_name,
867: G_PKG_NAME )
868: THEN
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
870: END IF;
871: --
872:
873: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 873: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
870: END IF;
871: --
872:
873: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
874: FND_MSG_PUB.initialize ;
875: END IF;
876: --
877: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 877: p_return_status := FND_API.G_RET_STS_SUCCESS ;

873: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
874: FND_MSG_PUB.initialize ;
875: END IF;
876: --
877: p_return_status := FND_API.G_RET_STS_SUCCESS ;
878: --
879: delete from PSB_ENTITY
880: where ENTITY_ID = P_ENTITY_ID;
881: if (sql%notfound) then

Line 885: IF FND_API.To_Boolean ( p_commit ) THEN

881: if (sql%notfound) then
882: raise no_data_found;
883: end if;
884: --
885: IF FND_API.To_Boolean ( p_commit ) THEN
886: COMMIT WORK;
887: END iF;
888: --
889: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 894: WHEN FND_API.G_EXC_ERROR THEN

890: p_data => p_msg_data );
891:
892: EXCEPTION
893: --
894: WHEN FND_API.G_EXC_ERROR THEN
895: --
896: ROLLBACK TO Delete_Row_Pvt ;
897: p_return_status := FND_API.G_RET_STS_ERROR;
898: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 897: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 904: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: --
908: WHEN OTHERS THEN
909: --
910: ROLLBACK TO Delete_Row_Pvt ;
911: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: --
913: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
914: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
915: l_api_name);