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

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

9: ===============================================================================*/
10:
11: PROCEDURE Insert_Row(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,

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

10:
11: PROCEDURE Insert_Row(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,

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

11: PROCEDURE Insert_Row(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: X_return_status OUT NOCOPY VARCHAR2,
17: X_msg_count OUT NOCOPY NUMBER,
18: X_msg_data OUT NOCOPY VARCHAR2,
19: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 40: IF NOT FND_API.Compatible_API_Call ( l_api_version,

36: BEGIN
37:
38: SAVEPOINT Insert_Row_Pvt ;
39:
40: IF NOT FND_API.Compatible_API_Call ( l_api_version,
41: p_api_version,
42: l_api_name,
43: G_PKG_NAME )
44: THEN

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

41: p_api_version,
42: l_api_name,
43: G_PKG_NAME )
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
46: END IF;
47:
48:
49: IF FND_API.to_Boolean (p_init_msg_list ) THEN

Line 49: IF FND_API.to_Boolean (p_init_msg_list ) THEN

45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
46: END IF;
47:
48:
49: IF FND_API.to_Boolean (p_init_msg_list ) THEN
50: FND_MSG_PUB.initialize ;
51: END IF;
52:
53: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 53: X_return_status := FND_API.G_RET_STS_SUCCESS ;

49: IF FND_API.to_Boolean (p_init_msg_list ) THEN
50: FND_MSG_PUB.initialize ;
51: END IF;
52:
53: X_return_status := FND_API.G_RET_STS_SUCCESS ;
54:
55: INSERT INTO IGC_CC_MC_HEADERS (
56: CC_Header_Id,
57: Set_Of_Books_Id,

Line 74: RAISE FND_API.G_EXC_ERROR ;

70: OPEN C;
71: FETCH C INTO p_Rowid;
72: if (C%NOTFOUND) then
73: CLOSE C;
74: RAISE FND_API.G_EXC_ERROR ;
75: end if;
76: CLOSE C;
77:
78: IF FND_API.To_Boolean ( p_commit ) THEN

Line 78: IF FND_API.To_Boolean ( p_commit ) THEN

74: RAISE FND_API.G_EXC_ERROR ;
75: end if;
76: CLOSE C;
77:
78: IF FND_API.To_Boolean ( p_commit ) THEN
79: COMMIT WORK;
80: END iF;
81:
82: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 87: WHEN FND_API.G_EXC_ERROR THEN

83: p_data => X_msg_data );
84:
85: EXCEPTION
86:
87: WHEN FND_API.G_EXC_ERROR THEN
88:
89: ROLLBACK TO Insert_Row_Pvt ;
90: X_return_status := FND_API.G_RET_STS_ERROR;
91: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

Line 90: X_return_status := FND_API.G_RET_STS_ERROR;

86:
87: WHEN FND_API.G_EXC_ERROR THEN
88:
89: ROLLBACK TO Insert_Row_Pvt ;
90: X_return_status := FND_API.G_RET_STS_ERROR;
91: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
92: p_data => X_msg_data );
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

90: X_return_status := FND_API.G_RET_STS_ERROR;
91: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
92: p_data => X_msg_data );
93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: ROLLBACK TO Insert_Row_Pvt ;
97: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 97: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93:
94: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95:
96: ROLLBACK TO Insert_Row_Pvt ;
97: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
99: p_data => X_msg_data );
100:
101: WHEN OTHERS THEN

Line 104: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100:
101: WHEN OTHERS THEN
102:
103: ROLLBACK TO Insert_Row_Pvt ;
104: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105:
106: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
107: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
108: l_api_name);

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

118: ===============================================================================*/
119:
120: PROCEDURE Lock_Row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: X_return_status OUT NOCOPY VARCHAR2,
126: X_msg_count OUT NOCOPY NUMBER,

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

119:
120: PROCEDURE Lock_Row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: X_return_status OUT NOCOPY VARCHAR2,
126: X_msg_count OUT NOCOPY NUMBER,
127: X_msg_data OUT NOCOPY VARCHAR2,

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

120: PROCEDURE Lock_Row(
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
125: X_return_status OUT NOCOPY VARCHAR2,
126: X_msg_count OUT NOCOPY NUMBER,
127: X_msg_data OUT NOCOPY VARCHAR2,
128: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 150: IF NOT FND_API.Compatible_API_Call ( l_api_version,

146: BEGIN
147:
148: SAVEPOINT Lock_Row_Pvt ;
149:
150: IF NOT FND_API.Compatible_API_Call ( l_api_version,
151: p_api_version,
152: l_api_name,
153: G_PKG_NAME )
154: THEN

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

151: p_api_version,
152: l_api_name,
153: G_PKG_NAME )
154: THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
156: END IF;
157:
158:
159: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 159: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
156: END IF;
157:
158:
159: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
160: FND_MSG_PUB.initialize ;
161: END IF;
162:
163: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 163: X_return_status := FND_API.G_RET_STS_SUCCESS ;

159: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
160: FND_MSG_PUB.initialize ;
161: END IF;
162:
163: X_return_status := FND_API.G_RET_STS_SUCCESS ;
164: X_row_locked := FND_API.G_TRUE ;
165:
166: OPEN C;
167:

Line 164: X_row_locked := FND_API.G_TRUE ;

160: FND_MSG_PUB.initialize ;
161: END IF;
162:
163: X_return_status := FND_API.G_RET_STS_SUCCESS ;
164: X_row_locked := FND_API.G_TRUE ;
165:
166: OPEN C;
167:
168: FETCH C INTO Recinfo;

Line 173: RAISE FND_API.G_EXC_ERROR;

169: if (C%NOTFOUND) then
170: CLOSE C;
171: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
172: FND_MSG_PUB.Add;
173: RAISE FND_API.G_EXC_ERROR;
174: end if;
175: CLOSE C;
176: if (
177: (Recinfo.CC_Header_Id = p_CC_Header_Id)

Line 196: RAISE FND_API.G_EXC_ERROR ;

192: null;
193: else
194: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
195: FND_MSG_PUB.Add;
196: RAISE FND_API.G_EXC_ERROR ;
197: end if;
198:
199: IF FND_API.To_Boolean ( p_commit ) THEN
200: COMMIT WORK;

Line 199: IF FND_API.To_Boolean ( p_commit ) THEN

195: FND_MSG_PUB.Add;
196: RAISE FND_API.G_EXC_ERROR ;
197: end if;
198:
199: IF FND_API.To_Boolean ( p_commit ) THEN
200: COMMIT WORK;
201: END iF;
202:
203: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 211: X_row_locked := FND_API.G_FALSE;

207:
208: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
209:
210: ROLLBACK TO Lock_Row_Pvt ;
211: X_row_locked := FND_API.G_FALSE;
212: X_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
214: p_data => X_msg_data );
215:

Line 212: X_return_status := FND_API.G_RET_STS_ERROR;

208: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
209:
210: ROLLBACK TO Lock_Row_Pvt ;
211: X_row_locked := FND_API.G_FALSE;
212: X_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
214: p_data => X_msg_data );
215:
216: WHEN FND_API.G_EXC_ERROR THEN

Line 216: WHEN FND_API.G_EXC_ERROR THEN

212: X_return_status := FND_API.G_RET_STS_ERROR;
213: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
214: p_data => X_msg_data );
215:
216: WHEN FND_API.G_EXC_ERROR THEN
217:
218: ROLLBACK TO Lock_Row_Pvt ;
219: X_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 219: X_return_status := FND_API.G_RET_STS_ERROR;

215:
216: WHEN FND_API.G_EXC_ERROR THEN
217:
218: ROLLBACK TO Lock_Row_Pvt ;
219: X_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
221: p_data => X_msg_data );
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

219: X_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
221: p_data => X_msg_data );
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224:
225: ROLLBACK TO Lock_Row_Pvt ;
226: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 226: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224:
225: ROLLBACK TO Lock_Row_Pvt ;
226: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
228: p_data => X_msg_data );
229:
230: WHEN OTHERS THEN

Line 233: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229:
230: WHEN OTHERS THEN
231:
232: ROLLBACK TO Lock_Row_Pvt ;
233: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234:
235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
237: l_api_name);

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

246: ===============================================================================*/
247:
248: PROCEDURE Update_Row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: X_return_status OUT NOCOPY VARCHAR2,
254: X_msg_count OUT NOCOPY NUMBER,

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

247:
248: PROCEDURE Update_Row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: X_return_status OUT NOCOPY VARCHAR2,
254: X_msg_count OUT NOCOPY NUMBER,
255: X_msg_data OUT NOCOPY VARCHAR2,

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

248: PROCEDURE Update_Row(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
251: p_commit IN VARCHAR2 := FND_API.G_FALSE,
252: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253: X_return_status OUT NOCOPY VARCHAR2,
254: X_msg_count OUT NOCOPY NUMBER,
255: X_msg_data OUT NOCOPY VARCHAR2,
256: p_Rowid IN OUT NOCOPY VARCHAR2,

Line 272: IF NOT FND_API.Compatible_API_Call ( l_api_version,

268: BEGIN
269:
270: SAVEPOINT Update_Row_Pvt ;
271:
272: IF NOT FND_API.Compatible_API_Call ( l_api_version,
273: p_api_version,
274: l_api_name,
275: G_PKG_NAME )
276: THEN

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

273: p_api_version,
274: l_api_name,
275: G_PKG_NAME )
276: THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
278: END IF;
279:
280:
281: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 281: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
278: END IF;
279:
280:
281: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize ;
283: END IF;
284:
285: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 285: X_return_status := FND_API.G_RET_STS_SUCCESS ;

281: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
282: FND_MSG_PUB.initialize ;
283: END IF;
284:
285: X_return_status := FND_API.G_RET_STS_SUCCESS ;
286:
287: UPDATE IGC_CC_MC_HEADERS
288: SET
289: CC_Header_Id = p_CC_Header_Id,

Line 300: IF FND_API.To_Boolean ( p_commit ) THEN

296: if (SQL%NOTFOUND) then
297: Raise NO_DATA_FOUND;
298: end if;
299:
300: IF FND_API.To_Boolean ( p_commit ) THEN
301: COMMIT WORK;
302: END iF;
303:
304: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305: p_data => X_msg_data );
306:
307: EXCEPTION
308:
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: ROLLBACK TO Update_Row_Pvt ;
312: X_return_status := FND_API.G_RET_STS_ERROR;
313: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 312: X_return_status := FND_API.G_RET_STS_ERROR;

308:
309: WHEN FND_API.G_EXC_ERROR THEN
310:
311: ROLLBACK TO Update_Row_Pvt ;
312: X_return_status := FND_API.G_RET_STS_ERROR;
313: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
314: p_data => X_msg_data );
315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

312: X_return_status := FND_API.G_RET_STS_ERROR;
313: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
314: p_data => X_msg_data );
315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317:
318: ROLLBACK TO Update_Row_Pvt ;
319: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 319: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317:
318: ROLLBACK TO Update_Row_Pvt ;
319: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
321: p_data => X_msg_data );
322:
323: WHEN OTHERS THEN

Line 326: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322:
323: WHEN OTHERS THEN
324:
325: ROLLBACK TO Update_Row_Pvt ;
326: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327:
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
329: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
330: l_api_name);

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

340: ===============================================================================*/
341:
342: PROCEDURE Delete_Row(
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
347: X_return_status OUT NOCOPY VARCHAR2,
348: X_msg_count OUT NOCOPY NUMBER,

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

341:
342: PROCEDURE Delete_Row(
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
347: X_return_status OUT NOCOPY VARCHAR2,
348: X_msg_count OUT NOCOPY NUMBER,
349: X_msg_data OUT NOCOPY VARCHAR2,

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

342: PROCEDURE Delete_Row(
343: p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345: p_commit IN VARCHAR2 := FND_API.G_FALSE,
346: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
347: X_return_status OUT NOCOPY VARCHAR2,
348: X_msg_count OUT NOCOPY NUMBER,
349: X_msg_data OUT NOCOPY VARCHAR2,
350: p_Rowid IN OUT NOCOPY VARCHAR2

Line 364: IF NOT FND_API.Compatible_API_Call ( l_api_version,

360: BEGIN
361:
362: SAVEPOINT Delete_Row_Pvt ;
363:
364: IF NOT FND_API.Compatible_API_Call ( l_api_version,
365: p_api_version,
366: l_api_name,
367: G_PKG_NAME )
368: THEN

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

365: p_api_version,
366: l_api_name,
367: G_PKG_NAME )
368: THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
370: END IF;
371:
372:
373: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 373: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
370: END IF;
371:
372:
373: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
374: FND_MSG_PUB.initialize ;
375: END IF ;
376:
377: X_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 377: X_return_status := FND_API.G_RET_STS_SUCCESS ;

373: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
374: FND_MSG_PUB.initialize ;
375: END IF ;
376:
377: X_return_status := FND_API.G_RET_STS_SUCCESS ;
378:
379: DELETE
380: FROM IGC_CC_MC_HEADERS
381: WHERE rowid = p_Rowid;

Line 387: IF FND_API.To_Boolean ( p_commit ) THEN

383: if (SQL%NOTFOUND) then
384: Raise NO_DATA_FOUND;
385: end if;
386:
387: IF FND_API.To_Boolean ( p_commit ) THEN
388: COMMIT WORK;
389: END iF;
390:
391: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 396: WHEN FND_API.G_EXC_ERROR THEN

392: p_data => X_msg_data );
393:
394: EXCEPTION
395:
396: WHEN FND_API.G_EXC_ERROR THEN
397:
398: ROLLBACK TO Delete_Row_Pvt ;
399: X_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 399: X_return_status := FND_API.G_RET_STS_ERROR;

395:
396: WHEN FND_API.G_EXC_ERROR THEN
397:
398: ROLLBACK TO Delete_Row_Pvt ;
399: X_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
401: p_data => X_msg_data );
402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

399: X_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
401: p_data => X_msg_data );
402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404:
405: ROLLBACK TO Delete_Row_Pvt ;
406: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 406: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404:
405: ROLLBACK TO Delete_Row_Pvt ;
406: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
408: p_data => X_msg_data );
409:
410: WHEN OTHERS THEN

Line 413: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

409:
410: WHEN OTHERS THEN
411:
412: ROLLBACK TO Delete_Row_Pvt ;
413: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414:
415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
417: l_api_name);