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_SYSTEM_OPTIONS_PKG dependencies on FND_API

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

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

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

23: PROCEDURE Insert_Row
24: (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,

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

24: (
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2,
32: p_row_id IN OUT NOCOPY VARCHAR2,

Line 60: IF NOT FND_API.Compatible_API_Call ( l_api_version,

56: BEGIN
57:
58: SAVEPOINT Insert_Row_Pvt;
59:
60: IF NOT FND_API.Compatible_API_Call ( l_api_version,
61: p_api_version,
62: l_api_name,
63: G_PKG_NAME )
64: THEN

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: p_api_version,
62: l_api_name,
63: G_PKG_NAME )
64: THEN
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68:
69: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 69: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66: END IF;
67:
68:
69: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
70: FND_MSG_PUB.initialize ;
71: END IF;
72:
73: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
70: FND_MSG_PUB.initialize ;
71: END IF;
72:
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: INSERT INTO IGC_CC_SYSTEM_OPTIONS_ALL
76: (
77: org_id,

Line 110: RAISE FND_API.G_EXC_ERROR;

106: OPEN cur_sys_options;
107: FETCH cur_sys_options INTO p_row_id;
108: IF (cur_sys_options%NOTFOUND) THEN
109: CLOSE cur_sys_options;
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112: CLOSE cur_sys_options;
113:
114:

Line 115: IF FND_API.To_Boolean ( p_commit ) THEN

111: END IF;
112: CLOSE cur_sys_options;
113:
114:
115: IF FND_API.To_Boolean ( p_commit ) THEN
116: COMMIT WORK;
117: END iF;
118:
119: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: p_data => x_msg_data );
121:
122: EXCEPTION
123:
124: WHEN FND_API.G_EXC_ERROR THEN
125:
126: ROLLBACK TO Insert_Row_Pvt ;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123:
124: WHEN FND_API.G_EXC_ERROR THEN
125:
126: ROLLBACK TO Insert_Row_Pvt ;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
129: p_data => x_msg_data );
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: x_return_status := FND_API.G_RET_STS_ERROR;
128: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
129: p_data => x_msg_data );
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: ROLLBACK TO Insert_Row_Pvt ;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132:
133: ROLLBACK TO Insert_Row_Pvt ;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
136: p_data => x_msg_data );
137:
138: WHEN OTHERS THEN

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137:
138: WHEN OTHERS THEN
139:
140: ROLLBACK TO Insert_Row_Pvt ;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142:
143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
145: l_api_name);

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

156: +==========================================================================*/
157: PROCEDURE Lock_Row
158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,

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

157: PROCEDURE Lock_Row
158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,

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

158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_row_id IN OUT NOCOPY VARCHAR2,

Line 195: IF NOT FND_API.Compatible_API_Call ( l_api_version,

191: BEGIN
192:
193: SAVEPOINT Lock_Row_Pvt;
194:
195: IF NOT FND_API.Compatible_API_Call ( l_api_version,
196: p_api_version,
197: l_api_name,
198: G_PKG_NAME )
199: THEN

Line 200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

196: p_api_version,
197: l_api_name,
198: G_PKG_NAME )
199: THEN
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: END IF;
202:
203:
204: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 204: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: END IF;
202:
203:
204: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207:
208: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 208: x_return_status := FND_API.G_RET_STS_SUCCESS;

204: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
205: FND_MSG_PUB.initialize;
206: END IF;
207:
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209: p_row_locked := FND_API.G_TRUE;
210:
211: OPEN cur_sys_options;
212:

Line 209: p_row_locked := FND_API.G_TRUE;

205: FND_MSG_PUB.initialize;
206: END IF;
207:
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209: p_row_locked := FND_API.G_TRUE;
210:
211: OPEN cur_sys_options;
212:
213: FETCH cur_sys_options INTO Recinfo;

Line 218: RAISE FND_API.G_EXC_ERROR;

214: IF (cur_sys_options%NOTFOUND) THEN
215: CLOSE cur_sys_options;
216: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
217: FND_MSG_PUB.Add;
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220:
221: CLOSE cur_sys_options;
222:

Line 249: RAISE FND_API.G_EXC_ERROR;

245: Null;
246: ELSE
247: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
248: FND_MSG_PUB.Add;
249: RAISE FND_API.G_EXC_ERROR;
250: END IF;
251:
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;

Line 252: IF FND_API.To_Boolean ( p_commit ) THEN

248: FND_MSG_PUB.Add;
249: RAISE FND_API.G_EXC_ERROR;
250: END IF;
251:
252: IF FND_API.To_Boolean ( p_commit ) THEN
253: COMMIT WORK;
254: END iF;
255:
256: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 264: p_row_locked := FND_API.G_FALSE;

260:
261: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
262:
263: ROLLBACK TO Lock_Row_Pvt;
264: p_row_locked := FND_API.G_FALSE;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
267: p_data => x_msg_data );
268:

Line 265: x_return_status := FND_API.G_RET_STS_ERROR;

261: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
262:
263: ROLLBACK TO Lock_Row_Pvt;
264: p_row_locked := FND_API.G_FALSE;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
267: p_data => x_msg_data );
268:
269: WHEN FND_API.G_EXC_ERROR THEN

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265: x_return_status := FND_API.G_RET_STS_ERROR;
266: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
267: p_data => x_msg_data );
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270:
271: ROLLBACK TO Lock_Row_Pvt;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268:
269: WHEN FND_API.G_EXC_ERROR THEN
270:
271: ROLLBACK TO Lock_Row_Pvt;
272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
274: p_data => x_msg_data );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272: x_return_status := FND_API.G_RET_STS_ERROR;
273: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
274: p_data => x_msg_data );
275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277:
278: ROLLBACK TO Lock_Row_Pvt;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277:
278: ROLLBACK TO Lock_Row_Pvt;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
281: p_data => x_msg_data );
282:
283: WHEN OTHERS THEN

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

282:
283: WHEN OTHERS THEN
284:
285: ROLLBACK TO Lock_Row_Pvt ;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
287:
288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
290: l_api_name);

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

301: +==========================================================================*/
302: PROCEDURE Update_Row
303: (
304: p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,

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

302: PROCEDURE Update_Row
303: (
304: p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,

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

303: (
304: p_api_version IN NUMBER,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_row_id IN OUT NOCOPY VARCHAR2,

Line 332: IF NOT FND_API.Compatible_API_Call ( l_api_version,

328: BEGIN
329:
330: SAVEPOINT Update_Row_Pvt;
331:
332: IF NOT FND_API.Compatible_API_Call ( l_api_version,
333: p_api_version,
334: l_api_name,
335: G_PKG_NAME )
336: THEN

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

333: p_api_version,
334: l_api_name,
335: G_PKG_NAME )
336: THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
338: END IF;
339:
340:
341: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 341: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
338: END IF;
339:
340:
341: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
342: FND_MSG_PUB.initialize;
343: END IF;
344:
345: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 345: x_return_status := FND_API.G_RET_STS_SUCCESS;

341: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
342: FND_MSG_PUB.initialize;
343: END IF;
344:
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: UPDATE IGC_CC_SYSTEM_OPTIONS_ALL
348: SET
349: org_id = p_org_id,

Line 365: IF FND_API.To_Boolean ( p_commit ) THEN

361: IF (SQL%NOTFOUND) THEN
362: RAISE NO_DATA_FOUND;
363: END IF;
364:
365: IF FND_API.To_Boolean ( p_commit ) THEN
366: COMMIT WORK;
367: END iF;
368:
369: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 374: WHEN FND_API.G_EXC_ERROR THEN

370: p_data => x_msg_data );
371:
372: EXCEPTION
373:
374: WHEN FND_API.G_EXC_ERROR THEN
375:
376: ROLLBACK TO Update_Row_Pvt ;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373:
374: WHEN FND_API.G_EXC_ERROR THEN
375:
376: ROLLBACK TO Update_Row_Pvt ;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
379: p_data => x_msg_data );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
379: p_data => x_msg_data );
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: ROLLBACK TO Update_Row_Pvt ;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: ROLLBACK TO Update_Row_Pvt ;
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
386: p_data => x_msg_data );
387:
388: WHEN OTHERS THEN

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387:
388: WHEN OTHERS THEN
389:
390: ROLLBACK TO Update_Row_Pvt ;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392:
393: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
395: l_api_name);

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

406: +==========================================================================*/
407: PROCEDURE Delete_Row
408: (
409: p_api_version IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
413: x_return_status OUT NOCOPY VARCHAR2,
414: x_msg_count OUT NOCOPY NUMBER,

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

407: PROCEDURE Delete_Row
408: (
409: p_api_version IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
413: x_return_status OUT NOCOPY VARCHAR2,
414: x_msg_count OUT NOCOPY NUMBER,
415: x_msg_data OUT NOCOPY VARCHAR2,

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

408: (
409: p_api_version IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_commit IN VARCHAR2 := FND_API.G_FALSE,
412: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
413: x_return_status OUT NOCOPY VARCHAR2,
414: x_msg_count OUT NOCOPY NUMBER,
415: x_msg_data OUT NOCOPY VARCHAR2,
416: p_row_id IN VARCHAR2

Line 427: IF NOT FND_API.Compatible_API_Call ( l_api_version,

423: BEGIN
424:
425: SAVEPOINT Delete_Row_Pvt;
426:
427: IF NOT FND_API.Compatible_API_Call ( l_api_version,
428: p_api_version,
429: l_api_name,
430: G_PKG_NAME )
431: THEN

Line 432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

428: p_api_version,
429: l_api_name,
430: G_PKG_NAME )
431: THEN
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:
435: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
436: FND_MSG_PUB.initialize;

Line 435: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

431: THEN
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:
435: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
436: FND_MSG_PUB.initialize;
437: END IF;
438:
439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
436: FND_MSG_PUB.initialize;
437: END IF;
438:
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- Deleting the record in igc_cc_system_options_all.
442:
443: DELETE FROM IGC_CC_SYSTEM_OPTIONS_ALL

Line 450: IF FND_API.To_Boolean ( p_commit ) THEN

446: IF (SQL%NOTFOUND) THEN
447: RAISE NO_DATA_FOUND;
448: END IF;
449:
450: IF FND_API.To_Boolean ( p_commit ) THEN
451: COMMIT WORK;
452: END IF;
453:
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455: p_data => x_msg_data );
456:
457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_ERROR THEN
460:
461: ROLLBACK TO Delete_Row_Pvt;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458:
459: WHEN FND_API.G_EXC_ERROR THEN
460:
461: ROLLBACK TO Delete_Row_Pvt;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
464: p_data => x_msg_data );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
464: p_data => x_msg_data );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: ROLLBACK TO Delete_Row_Pvt;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467:
468: ROLLBACK TO Delete_Row_Pvt;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
471: p_data => x_msg_data );
472:
473: WHEN OTHERS THEN

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472:
473: WHEN OTHERS THEN
474:
475: ROLLBACK TO Delete_Row_Pvt;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
479: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
480: l_api_name);

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

491: +==========================================================================*/
492: PROCEDURE Check_Unique
493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,

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

492: PROCEDURE Check_Unique
493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,

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

493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_commit IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
501: p_row_id IN OUT NOCOPY VARCHAR2,

Line 526: IF NOT FND_API.Compatible_API_Call ( l_api_version,

522: BEGIN
523:
524: SAVEPOINT Check_Unique_Pvt ;
525:
526: IF NOT FND_API.Compatible_API_Call ( l_api_version,
527: p_api_version,
528: l_api_name,
529: G_PKG_NAME )
530: THEN

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

527: p_api_version,
528: l_api_name,
529: G_PKG_NAME )
530: THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
532: END IF;
533:
534:
535: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 535: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
532: END IF;
533:
534:
535: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
536: FND_MSG_PUB.initialize ;
537: END IF;
538:
539: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS ;

535: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
536: FND_MSG_PUB.initialize ;
537: END IF;
538:
539: x_return_status := FND_API.G_RET_STS_SUCCESS ;
540:
541: -- Checking the igc_cc_number_methods table for uniqueness.
542: OPEN c;
543: FETCH c INTO l_tmp;

Line 554: IF FND_API.To_Boolean ( p_commit ) THEN

550: END IF;
551:
552: CLOSE c;
553:
554: IF FND_API.To_Boolean ( p_commit ) THEN
555: COMMIT WORK;
556: END iF;
557:
558: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 563: WHEN FND_API.G_EXC_ERROR THEN

559: p_data => x_msg_data );
560:
561: EXCEPTION
562:
563: WHEN FND_API.G_EXC_ERROR THEN
564:
565: ROLLBACK TO Check_Unique_Pvt ;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562:
563: WHEN FND_API.G_EXC_ERROR THEN
564:
565: ROLLBACK TO Check_Unique_Pvt ;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
568: p_data => x_msg_data );
569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

566: x_return_status := FND_API.G_RET_STS_ERROR;
567: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
568: p_data => x_msg_data );
569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571:
572: ROLLBACK TO Check_Unique_Pvt ;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569:
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571:
572: ROLLBACK TO Check_Unique_Pvt ;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
575: p_data => x_msg_data );
576:
577: WHEN OTHERS THEN

Line 580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

576:
577: WHEN OTHERS THEN
578:
579: ROLLBACK TO Check_Unique_Pvt ;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581:
582: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
583: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
584: l_api_name);

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

597:
598: PROCEDURE Create_Auto_CC_Num
599: (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
602: p_commit IN VARCHAR2 := FND_API.G_FALSE,
603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,

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

598: PROCEDURE Create_Auto_CC_Num
599: (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
602: p_commit IN VARCHAR2 := FND_API.G_FALSE,
603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,

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

599: (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
602: p_commit IN VARCHAR2 := FND_API.G_FALSE,
603: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,
607: p_org_id IN igc_cc_headers.org_id%TYPE,

Line 645: IF NOT FND_API.Compatible_API_Call ( l_api_version,

641: BEGIN
642:
643: -- SAVEPOINT Create_Auto_CC_Num_Pvt;
644:
645: IF NOT FND_API.Compatible_API_Call ( l_api_version,
646: p_api_version,
647: l_api_name,
648: G_PKG_NAME )
649: THEN

Line 650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

646: p_api_version,
647: l_api_name,
648: G_PKG_NAME )
649: THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653:
654: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 654: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653:
654: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
655: FND_MSG_PUB.initialize;
656: END IF;
657:
658: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 658: x_return_status := FND_API.G_RET_STS_SUCCESS;

654: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
655: FND_MSG_PUB.initialize;
656: END IF;
657:
658: x_return_status := FND_API.G_RET_STS_SUCCESS;
659: -- sb: x_cc_num is not a number, so set to null not 0
660: -- x_cc_num := 0;
661: x_cc_num := '';
662: -- sb: end

Line 803: x_return_status := FND_API.G_RET_STS_ERROR;

799: EXCEPTION
800:
801: -- sb: define the exceptions
802: WHEN e_no_number_setup THEN
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: fnd_message.set_name('IGC','IGC_NO_NUMBERING_SETUP');
805: fnd_msg_pub.add;
806: fnd_msg_pub.count_and_get(p_count => x_msg_count,
807: p_data => x_msg_data);

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: p_data => x_msg_data);
808: ROLLBACK; -- Added for bug 3329666
809:
810: WHEN e_no_prefix_setup THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: fnd_message.set_name('IGC','IGC_CC_PREFIX_REQD');
813: fnd_msg_pub.add;
814: fnd_msg_pub.count_and_get(p_count => x_msg_count,
815: p_data => x_msg_data);

Line 819: WHEN FND_API.G_EXC_ERROR THEN

815: p_data => x_msg_data);
816: -- sb: end
817: ROLLBACK; -- Added for bug 3329666
818:
819: WHEN FND_API.G_EXC_ERROR THEN
820:
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
823: p_data => x_msg_data );

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817: ROLLBACK; -- Added for bug 3329666
818:
819: WHEN FND_API.G_EXC_ERROR THEN
820:
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
823: p_data => x_msg_data );
824: ROLLBACK; -- Added for bug 3329666
825:

Line 826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
823: p_data => x_msg_data );
824: ROLLBACK; -- Added for bug 3329666
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827:
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data );

Line 828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

824: ROLLBACK; -- Added for bug 3329666
825:
826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
827:
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
830: p_data => x_msg_data );
831:
832: ROLLBACK; -- Added for bug 3329666

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833:
834: WHEN OTHERS THEN
835:
836: ROLLBACK ;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838:
839: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
840: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
841: l_api_name);

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

852: +==========================================================================*/
853: PROCEDURE Validate_Numeric_CC_Num
854: (
855: p_api_version IN NUMBER,
856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
857: p_commit IN VARCHAR2 := FND_API.G_FALSE,
858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
859: x_return_status OUT NOCOPY VARCHAR2,
860: x_msg_count OUT NOCOPY NUMBER,

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

853: PROCEDURE Validate_Numeric_CC_Num
854: (
855: p_api_version IN NUMBER,
856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
857: p_commit IN VARCHAR2 := FND_API.G_FALSE,
858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
859: x_return_status OUT NOCOPY VARCHAR2,
860: x_msg_count OUT NOCOPY NUMBER,
861: x_msg_data OUT NOCOPY VARCHAR2,

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

854: (
855: p_api_version IN NUMBER,
856: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
857: p_commit IN VARCHAR2 := FND_API.G_FALSE,
858: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
859: x_return_status OUT NOCOPY VARCHAR2,
860: x_msg_count OUT NOCOPY NUMBER,
861: x_msg_data OUT NOCOPY VARCHAR2,
862: p_cc_num IN igc_cc_headers.cc_num%TYPE

Line 874: IF NOT FND_API.Compatible_API_Call ( l_api_version,

870: BEGIN
871:
872: SAVEPOINT Validate_Numeric_CC_Num_Pvt;
873:
874: IF NOT FND_API.Compatible_API_Call ( l_api_version,
875: p_api_version,
876: l_api_name,
877: G_PKG_NAME )
878: THEN

Line 879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

875: p_api_version,
876: l_api_name,
877: G_PKG_NAME )
878: THEN
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: END IF;
881:
882: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
883: FND_MSG_PUB.initialize;

Line 882: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

878: THEN
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: END IF;
881:
882: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: -- --------------------------------------------------------------------
889: -- Create seperate block for exception to be caught seperately
890: -- --------------------------------------------------------------------

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893:
894: EXCEPTION
895:
896: WHEN OTHERS THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: END;
899:
900: IF FND_API.To_Boolean ( p_commit ) THEN
901: COMMIT WORK;

Line 900: IF FND_API.To_Boolean ( p_commit ) THEN

896: WHEN OTHERS THEN
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: END;
899:
900: IF FND_API.To_Boolean ( p_commit ) THEN
901: COMMIT WORK;
902: END IF;
903:
904: RETURN;

Line 909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: ROLLBACK TO Validate_Numeric_CC_Num_Pvt;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910:
911: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
912: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
913: l_api_name);