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

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

12: +=======================================================================*/
13: PROCEDURE Insert_Row
14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,

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

13: PROCEDURE Insert_Row
14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,

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

14: (
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
17: p_commit IN VARCHAR2 := FND_API.G_FALSE,
18: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2,
22:

Line 45: IF NOT FND_API.Compatible_API_Call ( l_api_version,

41: BEGIN
42:
43: SAVEPOINT Insert_Row_Pvt ;
44:
45: IF NOT FND_API.Compatible_API_Call ( l_api_version,
46: p_api_version,
47: l_api_name,
48: G_PKG_NAME )
49: THEN

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

46: p_api_version,
47: l_api_name,
48: G_PKG_NAME )
49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
51: END IF;
52:
53:
54: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 54: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
51: END IF;
52:
53:
54: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
55: FND_MSG_PUB.initialize ;
56: END IF;
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS ;

54: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
55: FND_MSG_PUB.initialize ;
56: END IF;
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS ;
59:
60: INSERT INTO igc_cc_bc_enable
61: (
62: set_of_books_id,

Line 86: RAISE FND_API.G_EXC_ERROR ;

82: OPEN C;
83: FETCH C INTO p_row_id;
84: IF (C%NOTFOUND) THEN
85: CLOSE C;
86: RAISE FND_API.G_EXC_ERROR ;
87: END IF;
88: CLOSE C;
89:
90:

Line 91: IF FND_API.To_Boolean ( p_commit ) THEN

87: END IF;
88: CLOSE C;
89:
90:
91: IF FND_API.To_Boolean ( p_commit ) THEN
92: COMMIT WORK;
93: END iF;
94:
95: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 100: WHEN FND_API.G_EXC_ERROR THEN

96: p_data => x_msg_data );
97:
98: EXCEPTION
99:
100: WHEN FND_API.G_EXC_ERROR THEN
101:
102: ROLLBACK TO Insert_Row_Pvt ;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 103: x_return_status := FND_API.G_RET_STS_ERROR;

99:
100: WHEN FND_API.G_EXC_ERROR THEN
101:
102: ROLLBACK TO Insert_Row_Pvt ;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
105: p_data => x_msg_data );
106:
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

103: x_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
105: p_data => x_msg_data );
106:
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108:
109: ROLLBACK TO Insert_Row_Pvt ;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

106:
107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
108:
109: ROLLBACK TO Insert_Row_Pvt ;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
112: p_data => x_msg_data );
113:
114: WHEN OTHERS THEN

Line 117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

113:
114: WHEN OTHERS THEN
115:
116: ROLLBACK TO Insert_Row_Pvt ;
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
118:
119: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
121: l_api_name);

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

134: +==========================================================================*/
135: PROCEDURE Lock_Row
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,

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

135: PROCEDURE Lock_Row
136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,

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

136: (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144:

Line 169: IF NOT FND_API.Compatible_API_Call ( l_api_version,

165: BEGIN
166:
167: SAVEPOINT Lock_Row_Pvt ;
168:
169: IF NOT FND_API.Compatible_API_Call ( l_api_version,
170: p_api_version,
171: l_api_name,
172: G_PKG_NAME )
173: THEN

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

170: p_api_version,
171: l_api_name,
172: G_PKG_NAME )
173: THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
175: END IF;
176:
177:
178: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 178: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
175: END IF;
176:
177:
178: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
179: FND_MSG_PUB.initialize ;
180: END IF;
181:
182: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS ;

178: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
179: FND_MSG_PUB.initialize ;
180: END IF;
181:
182: x_return_status := FND_API.G_RET_STS_SUCCESS ;
183: p_row_locked := FND_API.G_TRUE ;
184:
185: OPEN C;
186:

Line 183: p_row_locked := FND_API.G_TRUE ;

179: FND_MSG_PUB.initialize ;
180: END IF;
181:
182: x_return_status := FND_API.G_RET_STS_SUCCESS ;
183: p_row_locked := FND_API.G_TRUE ;
184:
185: OPEN C;
186:
187: FETCH C INTO Recinfo;

Line 192: RAISE FND_API.G_EXC_ERROR ;

188: IF (C%NOTFOUND) then
189: CLOSE C;
190: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
191: FND_MSG_PUB.Add;
192: RAISE FND_API.G_EXC_ERROR ;
193: END IF;
194: CLOSE C;
195: IF ( (Recinfo.set_of_books_id = p_set_of_books_id)
196: AND ( (Recinfo.cc_bc_enable_flag = p_cc_bc_enable_flag)

Line 207: RAISE FND_API.G_EXC_ERROR ;

203: Null;
204: ELSE
205: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
206: FND_MSG_PUB.Add;
207: RAISE FND_API.G_EXC_ERROR ;
208: END IF;
209:
210:
211: IF FND_API.To_Boolean ( p_commit ) THEN

Line 211: IF FND_API.To_Boolean ( p_commit ) THEN

207: RAISE FND_API.G_EXC_ERROR ;
208: END IF;
209:
210:
211: IF FND_API.To_Boolean ( p_commit ) THEN
212: COMMIT WORK;
213: END iF;
214:
215: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 223: p_row_locked := FND_API.G_FALSE;

219:
220: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
221:
222: ROLLBACK TO Lock_Row_Pvt ;
223: p_row_locked := FND_API.G_FALSE;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
226: p_data => x_msg_data );
227:

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
221:
222: ROLLBACK TO Lock_Row_Pvt ;
223: p_row_locked := FND_API.G_FALSE;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
226: p_data => x_msg_data );
227:
228: WHEN FND_API.G_EXC_ERROR THEN

Line 228: WHEN FND_API.G_EXC_ERROR THEN

224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
226: p_data => x_msg_data );
227:
228: WHEN FND_API.G_EXC_ERROR THEN
229:
230: ROLLBACK TO Lock_Row_Pvt ;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227:
228: WHEN FND_API.G_EXC_ERROR THEN
229:
230: ROLLBACK TO Lock_Row_Pvt ;
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
233: p_data => x_msg_data );
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
233: p_data => x_msg_data );
234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:
237: ROLLBACK TO Lock_Row_Pvt ;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234:
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236:
237: ROLLBACK TO Lock_Row_Pvt ;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
240: p_data => x_msg_data );
241:
242: WHEN OTHERS THEN

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241:
242: WHEN OTHERS THEN
243:
244: ROLLBACK TO Lock_Row_Pvt ;
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
248: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
249: l_api_name);

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

263: +==========================================================================*/
264: PROCEDURE Update_Row
265: (
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,

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

264: PROCEDURE Update_Row
265: (
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,

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

265: (
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273:

Line 291: IF NOT FND_API.Compatible_API_Call ( l_api_version,

287: BEGIN
288:
289: SAVEPOINT Update_Row_Pvt ;
290:
291: IF NOT FND_API.Compatible_API_Call ( l_api_version,
292: p_api_version,
293: l_api_name,
294: G_PKG_NAME )
295: THEN

Line 296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

292: p_api_version,
293: l_api_name,
294: G_PKG_NAME )
295: THEN
296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
297: END IF;
298:
299:
300: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 300: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
297: END IF;
298:
299:
300: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
301: FND_MSG_PUB.initialize ;
302: END IF;
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS ;

300: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
301: FND_MSG_PUB.initialize ;
302: END IF;
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS ;
305:
306:
307: UPDATE igc_cc_bc_enable
308: SET

Line 322: IF FND_API.To_Boolean ( p_commit ) THEN

318: RAISE NO_DATA_FOUND ;
319: END IF;
320:
321:
322: IF FND_API.To_Boolean ( p_commit ) THEN
323: COMMIT WORK;
324: END iF;
325:
326: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 331: WHEN FND_API.G_EXC_ERROR THEN

327: p_data => x_msg_data );
328:
329: EXCEPTION
330:
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: ROLLBACK TO Update_Row_Pvt ;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 334: x_return_status := FND_API.G_RET_STS_ERROR;

330:
331: WHEN FND_API.G_EXC_ERROR THEN
332:
333: ROLLBACK TO Update_Row_Pvt ;
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
336: p_data => x_msg_data );
337:
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
336: p_data => x_msg_data );
337:
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339:
340: ROLLBACK TO Update_Row_Pvt ;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

337:
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339:
340: ROLLBACK TO Update_Row_Pvt ;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
343: p_data => x_msg_data );
344:
345: WHEN OTHERS THEN

Line 348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344:
345: WHEN OTHERS THEN
346:
347: ROLLBACK TO Update_Row_Pvt ;
348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
349:
350: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
352: l_api_name);

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

366: +==========================================================================*/
367: PROCEDURE Delete_Row
368: (
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY NUMBER,

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

367: PROCEDURE Delete_Row
368: (
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY NUMBER,
375: x_msg_data OUT NOCOPY VARCHAR2,

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

368: (
369: p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_commit IN VARCHAR2 := FND_API.G_FALSE,
372: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
373: x_return_status OUT NOCOPY VARCHAR2,
374: x_msg_count OUT NOCOPY NUMBER,
375: x_msg_data OUT NOCOPY VARCHAR2,
376:

Line 392: IF NOT FND_API.Compatible_API_Call ( l_api_version,

388: BEGIN
389:
390: SAVEPOINT Delete_Row_Pvt ;
391:
392: IF NOT FND_API.Compatible_API_Call ( l_api_version,
393: p_api_version,
394: l_api_name,
395: G_PKG_NAME )
396: THEN

Line 397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

393: p_api_version,
394: l_api_name,
395: G_PKG_NAME )
396: THEN
397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
398: END IF;
399:
400:
401: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 401: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
398: END IF;
399:
400:
401: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
402: FND_MSG_PUB.initialize ;
403: END IF ;
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS ;

401: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
402: FND_MSG_PUB.initialize ;
403: END IF ;
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS ;
406:
407: -- Deleting the record in igc_cc_bc_enable.
408:
409: DELETE FROM igc_cc_bc_enable

Line 418: IF FND_API.To_Boolean ( p_commit ) THEN

414: RAISE NO_DATA_FOUND ;
415: END IF;
416:
417:
418: IF FND_API.To_Boolean ( p_commit ) THEN
419: COMMIT WORK;
420: END iF;
421:
422: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 427: WHEN FND_API.G_EXC_ERROR THEN

423: p_data => x_msg_data );
424:
425: EXCEPTION
426:
427: WHEN FND_API.G_EXC_ERROR THEN
428:
429: ROLLBACK TO Delete_Row_Pvt ;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426:
427: WHEN FND_API.G_EXC_ERROR THEN
428:
429: ROLLBACK TO Delete_Row_Pvt ;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
432: p_data => x_msg_data );
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
432: p_data => x_msg_data );
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: ROLLBACK TO Delete_Row_Pvt ;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435:
436: ROLLBACK TO Delete_Row_Pvt ;
437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
439: p_data => x_msg_data );
440:
441: WHEN OTHERS THEN

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

440:
441: WHEN OTHERS THEN
442:
443: ROLLBACK TO Delete_Row_Pvt ;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445:
446: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
447: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
448: l_api_name);

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

460: +==========================================================================*/
461: PROCEDURE Check_Unique
462: (
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
465: p_commit IN VARCHAR2 := FND_API.G_FALSE,
466: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,

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

461: PROCEDURE Check_Unique
462: (
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
465: p_commit IN VARCHAR2 := FND_API.G_FALSE,
466: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,

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

462: (
463: p_api_version IN NUMBER,
464: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
465: p_commit IN VARCHAR2 := FND_API.G_FALSE,
466: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
467: x_return_status OUT NOCOPY VARCHAR2,
468: x_msg_count OUT NOCOPY NUMBER,
469: x_msg_data OUT NOCOPY VARCHAR2,
470:

Line 497: IF NOT FND_API.Compatible_API_Call ( l_api_version,

493: BEGIN
494:
495: SAVEPOINT Check_Unique_Pvt ;
496:
497: IF NOT FND_API.Compatible_API_Call ( l_api_version,
498: p_api_version,
499: l_api_name,
500: G_PKG_NAME )
501: THEN

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

498: p_api_version,
499: l_api_name,
500: G_PKG_NAME )
501: THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
503: END IF;
504:
505:
506: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 506: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
503: END IF;
504:
505:
506: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
507: FND_MSG_PUB.initialize ;
508: END IF;
509:
510: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS ;

506: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
507: FND_MSG_PUB.initialize ;
508: END IF;
509:
510: x_return_status := FND_API.G_RET_STS_SUCCESS ;
511:
512: -- Checking the igc_cc_bc_enable table for uniqueness.
513: OPEN c;
514: FETCH c INTO l_tmp;

Line 525: IF FND_API.To_Boolean ( p_commit ) THEN

521: END IF;
522:
523: CLOSE c;
524:
525: IF FND_API.To_Boolean ( p_commit ) THEN
526: COMMIT WORK;
527: END iF;
528:
529: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 534: WHEN FND_API.G_EXC_ERROR THEN

530: p_data => x_msg_data );
531:
532: EXCEPTION
533:
534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: ROLLBACK TO Check_Unique_Pvt ;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533:
534: WHEN FND_API.G_EXC_ERROR THEN
535:
536: ROLLBACK TO Check_Unique_Pvt ;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
539: p_data => x_msg_data );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

537: x_return_status := FND_API.G_RET_STS_ERROR;
538: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
539: p_data => x_msg_data );
540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542:
543: ROLLBACK TO Check_Unique_Pvt ;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

540:
541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542:
543: ROLLBACK TO Check_Unique_Pvt ;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
546: p_data => x_msg_data );
547:
548: WHEN OTHERS THEN

Line 551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

547:
548: WHEN OTHERS THEN
549:
550: ROLLBACK TO Check_Unique_Pvt ;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552:
553: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
554: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
555: l_api_name);