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_WITHIN_SEGMENT_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_WITHIN_SEGMENT_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 39: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 48: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

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

Line 52: p_return_status := FND_API.G_RET_STS_SUCCESS ;

48: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
49: FND_MSG_PUB.initialize ;
50: END IF;
51: --
52: p_return_status := FND_API.G_RET_STS_SUCCESS ;
53: --
54:
55: insert into PSB_RULE_WITHIN_SEGMENT (
56: RULE_ID,

Line 79: raise FND_API.G_EXC_ERROR;

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

Line 84: IF FND_API.To_Boolean ( p_commit ) THEN

80: end if;
81: close c;
82:
83: --
84: IF FND_API.To_Boolean ( p_commit ) THEN
85: COMMIT WORK;
86: END iF;
87: --
88: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 93: WHEN FND_API.G_EXC_ERROR THEN

89: p_data => p_msg_data );
90: --
91: EXCEPTION
92: --
93: WHEN FND_API.G_EXC_ERROR THEN
94: --
95: ROLLBACK TO Insert_Row_Pvt ;
96: p_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 96: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 103: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 110: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

106: --
107: WHEN OTHERS THEN
108: --
109: ROLLBACK TO Insert_Row_Pvt ;
110: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: --
112: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
113: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
114: l_api_name);

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

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

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

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

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

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

Line 152: IF NOT FND_API.Compatible_API_Call ( l_api_version,

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

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 161: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
158: END IF;
159: --
160:
161: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
162: FND_MSG_PUB.initialize ;
163: END IF;
164: --
165: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 165: p_return_status := FND_API.G_RET_STS_SUCCESS ;

161: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
162: FND_MSG_PUB.initialize ;
163: END IF;
164: --
165: p_return_status := FND_API.G_RET_STS_SUCCESS ;
166: --
167: open c1;
168: fetch c1 into tlinfo;
169: if (c1%notfound) then

Line 180: p_lock_row := FND_API.G_TRUE;

176:
177: if ( (tlinfo.SEGMENT_NAME = P_SEGMENT_NAME)
178: AND (tlinfo.APPLICATION_COLUMN_NAME = P_APPLICATION_COLUMN_NAME)
179: ) then
180: p_lock_row := FND_API.G_TRUE;
181: ELSE
182: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR ;

Line 184: RAISE FND_API.G_EXC_ERROR ;

180: p_lock_row := FND_API.G_TRUE;
181: ELSE
182: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
183: FND_MSG_PUB.Add;
184: RAISE FND_API.G_EXC_ERROR ;
185: END IF;
186:
187: --
188: IF FND_API.To_Boolean ( p_commit ) THEN

Line 188: IF FND_API.To_Boolean ( p_commit ) THEN

184: RAISE FND_API.G_EXC_ERROR ;
185: END IF;
186:
187: --
188: IF FND_API.To_Boolean ( p_commit ) THEN
189: COMMIT WORK;
190: END iF;
191: --
192: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 200: p_lock_row := FND_API.G_FALSE;

196: --
197: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
198: --
199: ROLLBACK TO Lock_Row_Pvt ;
200: p_lock_row := FND_API.G_FALSE;
201: p_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
203: p_data => p_msg_data );
204: --

Line 201: p_return_status := FND_API.G_RET_STS_ERROR;

197: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
198: --
199: ROLLBACK TO Lock_Row_Pvt ;
200: p_lock_row := FND_API.G_FALSE;
201: p_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
203: p_data => p_msg_data );
204: --
205: WHEN FND_API.G_EXC_ERROR THEN

Line 205: WHEN FND_API.G_EXC_ERROR THEN

201: p_return_status := FND_API.G_RET_STS_ERROR;
202: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
203: p_data => p_msg_data );
204: --
205: WHEN FND_API.G_EXC_ERROR THEN
206: --
207: ROLLBACK TO Lock_Row_Pvt ;
208: p_lock_row := FND_API.G_FALSE;
209: p_return_status := FND_API.G_RET_STS_ERROR;

Line 208: p_lock_row := FND_API.G_FALSE;

204: --
205: WHEN FND_API.G_EXC_ERROR THEN
206: --
207: ROLLBACK TO Lock_Row_Pvt ;
208: p_lock_row := FND_API.G_FALSE;
209: p_return_status := FND_API.G_RET_STS_ERROR;
210: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
211: p_data => p_msg_data );
212: --

Line 209: p_return_status := FND_API.G_RET_STS_ERROR;

205: WHEN FND_API.G_EXC_ERROR THEN
206: --
207: ROLLBACK TO Lock_Row_Pvt ;
208: p_lock_row := FND_API.G_FALSE;
209: p_return_status := FND_API.G_RET_STS_ERROR;
210: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
211: p_data => p_msg_data );
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

209: p_return_status := FND_API.G_RET_STS_ERROR;
210: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
211: p_data => p_msg_data );
212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: --
215: ROLLBACK TO Lock_Row_Pvt ;
216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: --
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: --
215: ROLLBACK TO Lock_Row_Pvt ;
216: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
218: p_data => p_msg_data );
219: --
220: WHEN OTHERS THEN

Line 223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

219: --
220: WHEN OTHERS THEN
221: --
222: ROLLBACK TO Lock_Row_Pvt ;
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: --
225: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
226: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
227: l_api_name);

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

233: END Lock_Row;
234:
235: procedure UPDATE_ROW (
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240: p_return_status OUT NOCOPY VARCHAR2,
241: p_msg_count OUT NOCOPY NUMBER,

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

234:
235: procedure UPDATE_ROW (
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240: p_return_status OUT NOCOPY VARCHAR2,
241: p_msg_count OUT NOCOPY NUMBER,
242: p_msg_data OUT NOCOPY VARCHAR2,

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

235: procedure UPDATE_ROW (
236: p_api_version IN NUMBER,
237: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
238: p_commit IN VARCHAR2 := FND_API.G_FALSE,
239: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
240: p_return_status OUT NOCOPY VARCHAR2,
241: p_msg_count OUT NOCOPY NUMBER,
242: p_msg_data OUT NOCOPY VARCHAR2,
243: --

Line 259: IF NOT FND_API.Compatible_API_Call ( l_api_version,

255: BEGIN
256: --
257: SAVEPOINT Update_Row_Pvt ;
258: --
259: IF NOT FND_API.Compatible_API_Call ( l_api_version,
260: p_api_version,
261: l_api_name,
262: G_PKG_NAME )
263: THEN

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

260: p_api_version,
261: l_api_name,
262: G_PKG_NAME )
263: THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
265: END IF;
266: --
267:
268: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 268: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
265: END IF;
266: --
267:
268: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
269: FND_MSG_PUB.initialize ;
270: END IF;
271: --
272: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 272: p_return_status := FND_API.G_RET_STS_SUCCESS ;

268: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
269: FND_MSG_PUB.initialize ;
270: END IF;
271: --
272: p_return_status := FND_API.G_RET_STS_SUCCESS ;
273: --
274: update PSB_RULE_WITHIN_SEGMENT set
275: SEGMENT_NAME = P_SEGMENT_NAME,
276: APPLICATION_COLUMN_NAME = P_APPLICATION_COLUMN_NAME,

Line 283: raise FND_API.G_EXC_ERROR;

279: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
280: where RULE_ID = P_RULE_ID
281: ;
282: if (sql%notfound) then
283: raise FND_API.G_EXC_ERROR;
284: end if;
285: --
286: IF FND_API.To_Boolean ( p_commit ) THEN
287: COMMIT WORK;

Line 286: IF FND_API.To_Boolean ( p_commit ) THEN

282: if (sql%notfound) then
283: raise FND_API.G_EXC_ERROR;
284: end if;
285: --
286: IF FND_API.To_Boolean ( p_commit ) THEN
287: COMMIT WORK;
288: END iF;
289: --
290: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 295: WHEN FND_API.G_EXC_ERROR THEN

291: p_data => p_msg_data );
292: --
293: EXCEPTION
294: --
295: WHEN FND_API.G_EXC_ERROR THEN
296: --
297: ROLLBACK TO Update_Row_Pvt ;
298: p_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 298: p_return_status := FND_API.G_RET_STS_ERROR;

294: --
295: WHEN FND_API.G_EXC_ERROR THEN
296: --
297: ROLLBACK TO Update_Row_Pvt ;
298: p_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
300: p_data => p_msg_data );
301: --
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

298: p_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
300: p_data => p_msg_data );
301: --
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: --
304: ROLLBACK TO Update_Row_Pvt ;
305: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 305: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

301: --
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: --
304: ROLLBACK TO Update_Row_Pvt ;
305: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
307: p_data => p_msg_data );
308: --
309: WHEN OTHERS THEN

Line 312: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

308: --
309: WHEN OTHERS THEN
310: --
311: ROLLBACK TO Update_Row_Pvt ;
312: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: --
314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
315: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
316: l_api_name);

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

323:
324:
325: procedure DELETE_ROW (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: p_return_status OUT NOCOPY VARCHAR2,
331: p_msg_count OUT NOCOPY NUMBER,

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

324:
325: procedure DELETE_ROW (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: p_return_status OUT NOCOPY VARCHAR2,
331: p_msg_count OUT NOCOPY NUMBER,
332: p_msg_data OUT NOCOPY VARCHAR2,

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

325: procedure DELETE_ROW (
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
330: p_return_status OUT NOCOPY VARCHAR2,
331: p_msg_count OUT NOCOPY NUMBER,
332: p_msg_data OUT NOCOPY VARCHAR2,
333: --

Line 345: IF NOT FND_API.Compatible_API_Call ( l_api_version,

341: BEGIN
342: --
343: SAVEPOINT Delete_Row_Pvt ;
344: --
345: IF NOT FND_API.Compatible_API_Call ( l_api_version,
346: p_api_version,
347: l_api_name,
348: G_PKG_NAME )
349: THEN

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

346: p_api_version,
347: l_api_name,
348: G_PKG_NAME )
349: THEN
350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
351: END IF;
352: --
353:
354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

Line 354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN

350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
351: END IF;
352: --
353:
354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize ;
356: END IF;
357: --
358: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 358: p_return_status := FND_API.G_RET_STS_SUCCESS ;

354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize ;
356: END IF;
357: --
358: p_return_status := FND_API.G_RET_STS_SUCCESS ;
359: --
360: delete from PSB_RULE_WITHIN_SEGMENT
361: where RULE_ID = P_RULE_ID
362: and APPLICATION_COLUMN_NAME = P_APPLICATION_COLUMN_NAME;

Line 367: IF FND_API.To_Boolean ( p_commit ) THEN

363: if (sql%notfound) then
364: raise no_data_found;
365: end if;
366: --
367: IF FND_API.To_Boolean ( p_commit ) THEN
368: COMMIT WORK;
369: END iF;
370: --
371: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 376: WHEN FND_API.G_EXC_ERROR THEN

372: p_data => p_msg_data );
373:
374: EXCEPTION
375: --
376: WHEN FND_API.G_EXC_ERROR THEN
377: --
378: ROLLBACK TO Delete_Row_Pvt ;
379: p_return_status := FND_API.G_RET_STS_ERROR;
380: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 379: p_return_status := FND_API.G_RET_STS_ERROR;

375: --
376: WHEN FND_API.G_EXC_ERROR THEN
377: --
378: ROLLBACK TO Delete_Row_Pvt ;
379: p_return_status := FND_API.G_RET_STS_ERROR;
380: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
381: p_data => p_msg_data );
382: --
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

379: p_return_status := FND_API.G_RET_STS_ERROR;
380: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
381: p_data => p_msg_data );
382: --
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: --
385: ROLLBACK TO Delete_Row_Pvt ;
386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: --
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: --
385: ROLLBACK TO Delete_Row_Pvt ;
386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
388: p_data => p_msg_data );
389: --
390: WHEN OTHERS THEN

Line 393: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: --
390: WHEN OTHERS THEN
391: --
392: ROLLBACK TO Delete_Row_Pvt ;
393: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: --
395: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
396: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
397: l_api_name);