DBA Data[Home] [Help]

APPS.IGC_CC_MC_DET_PF_HST_PKG dependencies on FND_MSG_PUB

Line 59: FND_MSG_PUB.initialize ;

55: END IF;
56:
57:
58: IF FND_API.to_Boolean (p_init_msg_list ) THEN
59: FND_MSG_PUB.initialize ;
60: END IF;
61:
62: X_return_status := FND_API.G_RET_STS_SUCCESS ;
63: -- -----------------------------------------------------------------

Line 108: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

104: IF FND_API.To_Boolean ( p_commit ) THEN
105: COMMIT WORK;
106: END iF;
107:
108: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
109: p_data => X_msg_data );
110: RETURN;
111:
112: EXCEPTION

Line 122: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,

118: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
119: CLOSE c_det_pf_mrc_hst_rowid;
120: END IF;
121:
122: FND_MSG_PUB.Count_And_Get (p_count => X_msg_count,
123: p_data => X_msg_data );
124:
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126:

Line 133: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

129: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
130: CLOSE c_det_pf_mrc_hst_rowid;
131: END IF;
132:
133: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
134: p_data => X_msg_data );
135:
136: WHEN OTHERS THEN
137:

Line 143: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

139: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
141: CLOSE c_det_pf_mrc_hst_rowid;
142: END IF;
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);
146: END if;
147:

Line 144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

140: IF (c_det_pf_mrc_hst_rowid%ISOPEN) THEN
141: CLOSE c_det_pf_mrc_hst_rowid;
142: END IF;
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);
146: END if;
147:
148: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 148: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

144: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
145: l_api_name);
146: END if;
147:
148: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
149: p_data => X_msg_data );
150:
151: END Insert_Row;
152:

Line 201: FND_MSG_PUB.initialize ;

197: END IF;
198:
199:
200: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
201: FND_MSG_PUB.initialize ;
202: END IF;
203:
204: X_return_status := FND_API.G_RET_STS_SUCCESS ;
205: X_row_locked := FND_API.G_TRUE ;

Line 213: FND_MSG_PUB.Add;

209: FETCH C INTO Recinfo;
210: if (C%NOTFOUND) then
211: CLOSE C;
212: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
213: FND_MSG_PUB.Add;
214: RAISE FND_API.G_EXC_ERROR;
215: end if;
216: CLOSE C;
217: if (

Line 248: FND_MSG_PUB.Add;

244: ) then
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

Line 256: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

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,
257: p_data => X_msg_data );
258:
259: EXCEPTION
260:

Line 266: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

262:
263: ROLLBACK TO Lock_Row_Pvt ;
264: X_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
270:

Line 273: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

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
277:

Line 280: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

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
284:

Line 288: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) 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);
291: END if;
292:

Line 289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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);
291: END if;
292:
293: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 293: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

289: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
290: l_api_name);
291: END if;
292:
293: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
294: p_data => X_msg_data );
295:
296: END Lock_Row;
297: /* ================================================================================

Line 339: FND_MSG_PUB.initialize ;

335: END IF;
336:
337:
338: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
339: FND_MSG_PUB.initialize ;
340: END IF;
341:
342: X_return_status := FND_API.G_RET_STS_SUCCESS ;
343:

Line 364: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

360: IF FND_API.To_Boolean ( p_commit ) THEN
361: COMMIT WORK;
362: END iF;
363:
364: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
365: p_data => X_msg_data );
366:
367: EXCEPTION
368:

Line 373: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

369: WHEN FND_API.G_EXC_ERROR THEN
370:
371: ROLLBACK TO Update_Row_Pvt ;
372: X_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
374: p_data => X_msg_data );
375:
376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377:

Line 380: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377:
378: ROLLBACK TO Update_Row_Pvt ;
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
381: p_data => X_msg_data );
382:
383: WHEN OTHERS THEN
384:

Line 388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

384:
385: ROLLBACK TO Update_Row_Pvt ;
386: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
389: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
390: l_api_name);
391: END if;
392:

Line 389: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

385: ROLLBACK TO Update_Row_Pvt ;
386: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
389: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
390: l_api_name);
391: END if;
392:
393: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 393: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

389: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
390: l_api_name);
391: END if;
392:
393: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
394: p_data => X_msg_data );
395:
396: END Update_Row;
397:

Line 434: FND_MSG_PUB.initialize ;

430: END IF;
431:
432:
433: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
434: FND_MSG_PUB.initialize ;
435: END IF ;
436:
437: X_return_status := FND_API.G_RET_STS_SUCCESS ;
438:

Line 450: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

446: IF FND_API.To_Boolean ( p_commit ) THEN
447: COMMIT WORK;
448: END iF;
449:
450: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
451: p_data => X_msg_data );
452:
453: EXCEPTION
454:

Line 459: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

455: WHEN FND_API.G_EXC_ERROR THEN
456:
457: ROLLBACK TO Delete_Row_Pvt ;
458: X_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
460: p_data => X_msg_data );
461:
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:

Line 466: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463:
464: ROLLBACK TO Delete_Row_Pvt ;
465: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
467: p_data => X_msg_data );
468:
469: WHEN OTHERS THEN
470:

Line 474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

470:
471: ROLLBACK TO Delete_Row_Pvt ;
472: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
475: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
476: l_api_name);
477: END if;
478:

Line 475: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

471: ROLLBACK TO Delete_Row_Pvt ;
472: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473:
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
475: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
476: l_api_name);
477: END if;
478:
479: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

Line 479: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,

475: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
476: l_api_name);
477: END if;
478:
479: FND_MSG_PUB.Count_And_Get ( p_count => X_msg_count,
480: p_data => X_msg_data );
481:
482:
483: END Delete_Row;