DBA Data[Home] [Help]

APPS.PSB_RULE_TRANSACTION_TYPE_PVT dependencies on FND_MSG_PUB

Line 50: FND_MSG_PUB.initialize ;

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: p_return_status := FND_API.G_RET_STS_SUCCESS ;
54: --

Line 89: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

85: IF FND_API.To_Boolean ( p_commit ) THEN
86: COMMIT WORK;
87: END iF;
88: --
89: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
90: p_data => p_msg_data );
91: --
92: EXCEPTION
93: --

Line 98: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

94: WHEN FND_API.G_EXC_ERROR THEN
95: --
96: ROLLBACK TO Insert_Row_Pvt ;
97: p_return_status := FND_API.G_RET_STS_ERROR;
98: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
99: p_data => p_msg_data );
100: --
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
102: --

Line 105: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
102: --
103: ROLLBACK TO Insert_Row_Pvt ;
104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
106: p_data => p_msg_data );
107: --
108: WHEN OTHERS THEN
109: --

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

109: --
110: ROLLBACK TO Insert_Row_Pvt ;
111: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: --
113: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
115: l_api_name);
116: END if;
117: --

Line 114: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

110: ROLLBACK TO Insert_Row_Pvt ;
111: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
112: --
113: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
115: l_api_name);
116: END if;
117: --
118: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 118: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

114: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
115: l_api_name);
116: END if;
117: --
118: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
119: p_data => p_msg_data );
120: --
121: END Insert_Row;
122:

Line 175: FND_MSG_PUB.initialize ;

171: END IF;
172: --
173:
174: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
175: FND_MSG_PUB.initialize ;
176: END IF;
177: --
178: p_return_status := FND_API.G_RET_STS_SUCCESS ;
179: --

Line 207: FND_MSG_PUB.Add;

203: /* For Bug # 2123930 : End */
204: p_lock_row := FND_API.G_TRUE;
205: ELSE
206: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR ;
209: END IF;
210:
211: --

Line 216: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

212: IF FND_API.To_Boolean ( p_commit ) THEN
213: COMMIT WORK;
214: END iF;
215: --
216: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
217: p_data => p_msg_data );
218: --
219: EXCEPTION
220: --

Line 226: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

222: --
223: ROLLBACK TO Lock_Row_Pvt ;
224: p_lock_row := FND_API.G_FALSE;
225: p_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
227: p_data => p_msg_data );
228: --
229: WHEN FND_API.G_EXC_ERROR THEN
230: --

Line 234: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

230: --
231: ROLLBACK TO Lock_Row_Pvt ;
232: p_lock_row := FND_API.G_FALSE;
233: p_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
235: p_data => p_msg_data );
236: --
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: --

Line 241: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: --
239: ROLLBACK TO Lock_Row_Pvt ;
240: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
242: p_data => p_msg_data );
243: --
244: WHEN OTHERS THEN
245: --

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

245: --
246: ROLLBACK TO Lock_Row_Pvt ;
247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: --
249: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
250: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
251: l_api_name);
252: END if;
253: --

Line 250: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

246: ROLLBACK TO Lock_Row_Pvt ;
247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: --
249: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
250: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
251: l_api_name);
252: END if;
253: --
254: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 254: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

250: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
251: l_api_name);
252: END if;
253: --
254: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
255: p_data => p_msg_data );
256: --
257: END Lock_Row;
258:

Line 294: FND_MSG_PUB.initialize ;

290: END IF;
291: --
292:
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
294: FND_MSG_PUB.initialize ;
295: END IF;
296: --
297: p_return_status := FND_API.G_RET_STS_SUCCESS ;
298: --

Line 326: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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 => p_msg_count,
327: p_data => p_msg_data );
328: --
329: EXCEPTION
330: --

Line 335: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

331: WHEN FND_API.G_EXC_ERROR THEN
332: --
333: ROLLBACK TO Update_Row_Pvt ;
334: p_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
336: p_data => p_msg_data );
337: --
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: --

Line 342: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: --
340: ROLLBACK TO Update_Row_Pvt ;
341: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
343: p_data => p_msg_data );
344: --
345: WHEN OTHERS THEN
346: --

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

346: --
347: ROLLBACK TO Update_Row_Pvt ;
348: p_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);
353: END if;
354: --

Line 351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

347: ROLLBACK TO Update_Row_Pvt ;
348: p_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);
353: END if;
354: --
355: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 355: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

351: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
352: l_api_name);
353: END if;
354: --
355: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
356: p_data => p_msg_data );
357: --
358: END Update_Row;
359:

Line 393: FND_MSG_PUB.initialize ;

389: END IF;
390: --
391:
392: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
393: FND_MSG_PUB.initialize ;
394: END IF;
395: --
396: p_return_status := FND_API.G_RET_STS_SUCCESS ;
397: --

Line 409: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

405: IF FND_API.To_Boolean ( p_commit ) THEN
406: COMMIT WORK;
407: END iF;
408: --
409: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
410: p_data => p_msg_data );
411:
412: EXCEPTION
413: --

Line 418: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

414: WHEN FND_API.G_EXC_ERROR THEN
415: --
416: ROLLBACK TO Delete_Row_Pvt ;
417: p_return_status := FND_API.G_RET_STS_ERROR;
418: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
419: p_data => p_msg_data );
420: --
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: --

Line 425: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: --
423: ROLLBACK TO Delete_Row_Pvt ;
424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
426: p_data => p_msg_data );
427: --
428: WHEN OTHERS THEN
429: --

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

429: --
430: ROLLBACK TO Delete_Row_Pvt ;
431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: --
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
435: l_api_name);
436: END if;
437: --

Line 434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

430: ROLLBACK TO Delete_Row_Pvt ;
431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
432: --
433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
435: l_api_name);
436: END if;
437: --
438: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 438: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
435: l_api_name);
436: END if;
437: --
438: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
439: p_data => p_msg_data );
440: --
441: END Delete_Row;
442: