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

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

5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_RULE_TRANSACTION_TYPE_PVT';
6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,

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

6:
7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,

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

7: procedure INSERT_ROW (
8: p_api_version IN NUMBER,
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_return_status OUT NOCOPY VARCHAR2,
13: p_msg_count OUT NOCOPY NUMBER,
14: p_msg_data OUT NOCOPY VARCHAR2,
15: --

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

Line 53: p_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: p_return_status := FND_API.G_RET_STS_SUCCESS ;
54: --
55:
56: insert into PSB_RULE_TRANSACTION_TYPE (
57: RULE_ID,

Line 80: raise FND_API.G_EXC_ERROR;

76: open c;
77: fetch c into P_ROWID;
78: if (c%notfound) then
79: close c;
80: raise FND_API.G_EXC_ERROR;
81: end if;
82: close c;
83:
84: --

Line 85: IF FND_API.To_Boolean ( p_commit ) THEN

81: end if;
82: close c;
83:
84: --
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,

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: p_data => p_msg_data );
91: --
92: EXCEPTION
93: --
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,

Line 97: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 104: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 111: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

107: --
108: WHEN OTHERS 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);

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

121: END Insert_Row;
122:
123: procedure LOCK_ROW (
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: p_return_status OUT NOCOPY VARCHAR2,
129: p_msg_count OUT NOCOPY NUMBER,

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

122:
123: procedure LOCK_ROW (
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: p_return_status OUT NOCOPY VARCHAR2,
129: p_msg_count OUT NOCOPY NUMBER,
130: p_msg_data OUT NOCOPY VARCHAR2,

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

123: procedure LOCK_ROW (
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
126: p_commit IN VARCHAR2 := FND_API.G_FALSE,
127: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
128: p_return_status OUT NOCOPY VARCHAR2,
129: p_msg_count OUT NOCOPY NUMBER,
130: p_msg_data OUT NOCOPY VARCHAR2,
131: p_lock_row OUT NOCOPY VARCHAR2,

Line 165: IF NOT FND_API.Compatible_API_Call ( l_api_version,

161: BEGIN
162: --
163: SAVEPOINT Lock_Row_Pvt ;
164: --
165: IF NOT FND_API.Compatible_API_Call ( l_api_version,
166: p_api_version,
167: l_api_name,
168: G_PKG_NAME )
169: THEN

Line 170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

166: p_api_version,
167: l_api_name,
168: G_PKG_NAME )
169: THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
171: END IF;
172: --
173:
174: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 174: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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 ;

Line 178: p_return_status := FND_API.G_RET_STS_SUCCESS ;

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: --
180: /* For Bug # 2123930 : Start */
181: /*
182: open c1;

Line 204: p_lock_row := FND_API.G_TRUE;

200: end loop;
201:
202: if l_counter = 1 then
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 ;

Line 208: RAISE FND_API.G_EXC_ERROR ;

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: --
212: IF FND_API.To_Boolean ( p_commit ) THEN

Line 212: IF FND_API.To_Boolean ( p_commit ) THEN

208: RAISE FND_API.G_EXC_ERROR ;
209: END IF;
210:
211: --
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,

Line 224: p_lock_row := FND_API.G_FALSE;

220: --
221: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
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: --

Line 225: p_return_status := FND_API.G_RET_STS_ERROR;

221: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
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

Line 229: WHEN FND_API.G_EXC_ERROR THEN

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: --
231: ROLLBACK TO Lock_Row_Pvt ;
232: p_lock_row := FND_API.G_FALSE;
233: p_return_status := FND_API.G_RET_STS_ERROR;

Line 232: p_lock_row := FND_API.G_FALSE;

228: --
229: WHEN FND_API.G_EXC_ERROR THEN
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: --

Line 233: p_return_status := FND_API.G_RET_STS_ERROR;

229: WHEN FND_API.G_EXC_ERROR THEN
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

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 240: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 247: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: --
244: WHEN OTHERS 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);

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

257: END Lock_Row;
258:
259: procedure UPDATE_ROW (
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_return_status OUT NOCOPY VARCHAR2,
265: p_msg_count OUT NOCOPY NUMBER,

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

258:
259: procedure UPDATE_ROW (
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_return_status OUT NOCOPY VARCHAR2,
265: p_msg_count OUT NOCOPY NUMBER,
266: p_msg_data OUT NOCOPY VARCHAR2,

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

259: procedure UPDATE_ROW (
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
264: p_return_status OUT NOCOPY VARCHAR2,
265: p_msg_count OUT NOCOPY NUMBER,
266: p_msg_data OUT NOCOPY VARCHAR2,
267: --

Line 284: IF NOT FND_API.Compatible_API_Call ( l_api_version,

280: BEGIN
281: --
282: SAVEPOINT Update_Row_Pvt ;
283: --
284: IF NOT FND_API.Compatible_API_Call ( l_api_version,
285: p_api_version,
286: l_api_name,
287: G_PKG_NAME )
288: THEN

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

285: p_api_version,
286: l_api_name,
287: G_PKG_NAME )
288: THEN
289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
290: END IF;
291: --
292:
293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 293: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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 ;

Line 297: p_return_status := FND_API.G_RET_STS_SUCCESS ;

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: --
299: /* For Bug # 2123930 : Start */
300: /* update PSB_RULE_TRANSACTION_TYPE set
301: TRANSACTION_TYPE = P_TRANSACTION_TYPE,

Line 319: raise FND_API.G_EXC_ERROR;

315: ;
316: /* For Bug # 2123930 : End */
317:
318: if (sql%notfound) then
319: raise FND_API.G_EXC_ERROR;
320: end if;
321: --
322: IF FND_API.To_Boolean ( p_commit ) THEN
323: COMMIT WORK;

Line 322: IF FND_API.To_Boolean ( p_commit ) THEN

318: if (sql%notfound) then
319: raise FND_API.G_EXC_ERROR;
320: end if;
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 => p_msg_count,

Line 331: WHEN FND_API.G_EXC_ERROR THEN

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

Line 334: p_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: 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

Line 338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 341: p_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: 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

Line 348: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

344: --
345: WHEN OTHERS 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);

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

359:
360:
361: procedure DELETE_ROW (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: p_return_status OUT NOCOPY VARCHAR2,
367: p_msg_count OUT NOCOPY NUMBER,

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

360:
361: procedure DELETE_ROW (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: p_return_status OUT NOCOPY VARCHAR2,
367: p_msg_count OUT NOCOPY NUMBER,
368: p_msg_data OUT NOCOPY VARCHAR2,

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

361: procedure DELETE_ROW (
362: p_api_version IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: p_return_status OUT NOCOPY VARCHAR2,
367: p_msg_count OUT NOCOPY NUMBER,
368: p_msg_data OUT NOCOPY VARCHAR2,
369: --

Line 383: IF NOT FND_API.Compatible_API_Call ( l_api_version,

379: BEGIN
380: --
381: SAVEPOINT Delete_Row_Pvt ;
382: --
383: IF NOT FND_API.Compatible_API_Call ( l_api_version,
384: p_api_version,
385: l_api_name,
386: G_PKG_NAME )
387: THEN

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

384: p_api_version,
385: l_api_name,
386: G_PKG_NAME )
387: THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
389: END IF;
390: --
391:
392: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 392: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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 ;

Line 396: p_return_status := FND_API.G_RET_STS_SUCCESS ;

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: --
398: delete from PSB_RULE_TRANSACTION_TYPE
399: where RULE_ID = P_RULE_ID
400: and TRANSACTION_TYPE = P_TRANSACTION_TYPE;

Line 405: IF FND_API.To_Boolean ( p_commit ) THEN

401: if (sql%notfound) then
402: raise no_data_found;
403: end if;
404: --
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,

Line 414: WHEN FND_API.G_EXC_ERROR THEN

410: p_data => p_msg_data );
411:
412: EXCEPTION
413: --
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,

Line 417: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 431: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

427: --
428: WHEN OTHERS 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);