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

Line 23: IF FND_API.to_Boolean( p_init_msg_list )

19: l_status_rule_rec IEX_STATUS_RULE_PUB.STATUS_RULE_REC_TYPE;
20:
21: BEGIN
22: -- Initialize message list IF p_init_msg_list is set to TRUE.
23: IF FND_API.to_Boolean( p_init_msg_list )
24: THEN
25: FND_MSG_PUB.initialize;
26: END IF;
27: l_status_rule_rec := p_status_rule_rec;

Line 34: P_Init_Msg_List => FND_API.G_FALSE);

30: P_TABLE_NAME => 'IEX_STATUS_RULES',
31: X_Return_Status => x_return_status,
32: X_Msg_Count => x_msg_count,
33: X_Msg_Data => x_msg_data,
34: P_Init_Msg_List => FND_API.G_FALSE);
35:
36: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;

Line 36: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

32: X_Msg_Count => x_msg_count,
33: X_Msg_Data => x_msg_data,
34: P_Init_Msg_List => FND_API.G_FALSE);
35:
36: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;
39:
40: Validate_Status_Rule_ID_Name(P_Init_Msg_List => FND_API.G_FALSE,

Line 37: RAISE FND_API.G_EXC_ERROR;

33: X_Msg_Data => x_msg_data,
34: P_Init_Msg_List => FND_API.G_FALSE);
35:
36: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;
39:
40: Validate_Status_Rule_ID_Name(P_Init_Msg_List => FND_API.G_FALSE,
41: P_STATUS_RULE_ID => l_status_rule_rec.status_rule_id,

Line 40: Validate_Status_Rule_ID_Name(P_Init_Msg_List => FND_API.G_FALSE,

36: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
37: RAISE FND_API.G_EXC_ERROR;
38: END IF;
39:
40: Validate_Status_Rule_ID_Name(P_Init_Msg_List => FND_API.G_FALSE,
41: P_STATUS_RULE_ID => l_status_rule_rec.status_rule_id,
42: P_STATUS_RULE_Name => l_status_rule_rec.status_rule_Name,
43: X_Dup_Status => x_dup_status,
44: X_Return_Status => x_return_status,

Line 48: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

44: X_Return_Status => x_return_status,
45: X_Msg_Count => x_msg_count,
46: X_Msg_Data => x_msg_data);
47:
48: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;
51: END Validate_Status_Rule;
52:

Line 49: RAISE FND_API.G_EXC_ERROR;

45: X_Msg_Count => x_msg_count,
46: X_Msg_Data => x_msg_data);
47:
48: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;
51: END Validate_Status_Rule;
52:
53: Procedure Validate_STATUS_RULE_Name(P_Init_Msg_List IN VARCHAR2,

Line 69: IF FND_API.to_Boolean( p_init_msg_list )

65: l_status_rule_Name VARCHAR2(50);
66:
67: BEGIN
68: -- Initialize message list IF p_init_msg_list is set to TRUE.
69: IF FND_API.to_Boolean( p_init_msg_list )
70: THEN
71: FND_MSG_PUB.initialize;
72: END IF;
73:

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: FND_MSG_PUB.initialize;
72: END IF;
73:
74: -- Initialize API return status to SUCCESS
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: IF P_STATUS_RULE_Name is NULL
78: THEN
79: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
80: FND_MESSAGE.Set_Token('API_NAME', 'Validate_Status_Rule_Name', FALSE);
81: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
82: FND_MSG_PUB.Add;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84:
85: ELSE -- IF P_STATUS_RULE_Name is NULL
86:
87: OPEN C_Get_Status_Rule_Name (p_status_rule_Name);

Line 99: x_return_status := FND_API.G_RET_STS_ERROR;

95: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
96: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
97: FND_MSG_PUB.Add;
98: END IF;
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: x_dup_status := IEX_DUPLICATE_NAME;
101: END IF;
102: CLOSE C_GET_STATUS_RULE_Name;
103: END IF;

Line 131: IF FND_API.to_Boolean( p_init_msg_list )

127: l_status_rule_Name VARCHAR2(50);
128:
129: BEGIN
130: -- Initialize message list IF p_init_msg_list is set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )
132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:

Line 137: x_return_status := FND_API.G_RET_STS_SUCCESS;

133: FND_MSG_PUB.initialize;
134: END IF;
135:
136: -- Initialize API return status to SUCCESS
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138:
139: IF P_STATUS_RULE_Name is NULL
140: THEN
141: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');

Line 145: x_return_status := FND_API.G_RET_STS_ERROR;

141: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
142: FND_MESSAGE.Set_Token('API_NAME', 'Validate_STATUS_RULE_ID_Name', FALSE);
143: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: ELSE -- IF P_STATUS_RULE_Name is NULL or P_STATUS_RULE_Name = FND_API.G_FALSE
148:
149: OPEN C_Get_Status_Rule_ID_Name (p_status_rule_Name, P_STATUS_RULE_ID);

Line 147: ELSE -- IF P_STATUS_RULE_Name is NULL or P_STATUS_RULE_Name = FND_API.G_FALSE

143: FND_MESSAGE.Set_Token('MISSING_PARAM', 'STATUS_RULE_NAME', FALSE);
144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: ELSE -- IF P_STATUS_RULE_Name is NULL or P_STATUS_RULE_Name = FND_API.G_FALSE
148:
149: OPEN C_Get_Status_Rule_ID_Name (p_status_rule_Name, P_STATUS_RULE_ID);
150: FETCH C_Get_Status_Rule_ID_Name INTO l_status_rule_Name;
151:

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: FND_MESSAGE.Set_Token('COLUMN', 'STATUS_RULE_NAME', FALSE);
158: FND_MESSAGE.Set_Token('VALUE', p_status_rule_Name, FALSE);
159: FND_MSG_PUB.Add;
160: END IF;
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: x_dup_status := IEX_DUPLICATE_NAME;
163: END IF;
164: CLOSE C_GET_STATUS_RULE_ID_Name;
165: END IF;

Line 206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

202: SAVEPOINT CREATE_STATUS_RULE_PVT;
203:
204: l_STATUS_RULE_REC := p_status_rule_rec;
205: -- Standard call to check for call compatibility.
206: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
207: p_api_version,
208: l_api_name,
209: G_PKG_NAME)
210: THEN

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207: p_api_version,
208: l_api_name,
209: G_PKG_NAME)
210: THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list IF p_init_msg_list is set to TRUE.
215: IF FND_API.to_Boolean( p_init_msg_list )

Line 215: IF FND_API.to_Boolean( p_init_msg_list )

211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: -- Initialize message list IF p_init_msg_list is set to TRUE.
215: IF FND_API.to_Boolean( p_init_msg_list )
216: THEN
217: FND_MSG_PUB.initialize;
218: END IF;
219:

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: END IF;
219:
220:
221: -- Initialize API return status to SUCCESS
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: --
225: -- API body
226: --

Line 230: Validate_Status_Rule_Name(P_Init_Msg_List => FND_API.G_FALSE,

226: --
227:
228: -- Validate Data
229:
230: Validate_Status_Rule_Name(P_Init_Msg_List => FND_API.G_FALSE,
231: P_STATUS_RULE_Name => l_status_rule_rec.status_rule_Name,
232: X_Dup_Status => x_Dup_status,
233: X_Return_Status => x_return_status,
234: X_Msg_Count => x_msg_count,

Line 237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

233: X_Return_Status => x_return_status,
234: X_Msg_Count => x_msg_count,
235: X_Msg_Data => x_msg_data);
236:
237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: -- ******************************************************************
241: -- Validate Environment

Line 238: RAISE FND_API.G_EXC_ERROR;

234: X_Msg_Count => x_msg_count,
235: X_Msg_Data => x_msg_data);
236:
237: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: -- ******************************************************************
241: -- Validate Environment
242: -- ******************************************************************

Line 254: RAISE FND_API.G_EXC_ERROR;

250: p_token1 => 'PROFILE',
251: p_token1_value => 'USER_ID');
252:
253: END IF;
254: RAISE FND_API.G_EXC_ERROR;
255: END IF;
256:
257: If ( (l_status_rule_rec.status_rule_id IS NULL) OR
258: (l_status_rule_rec.status_rule_id = 0) ) then

Line 283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

279: , p_object_version_number => 1.0
280: );
281:
282:
283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;

Line 284: RAISE FND_API.G_EXC_ERROR;

280: );
281:
282:
283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:

Line 285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

281:
282:
283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289:

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282:
283: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289:
290: --

Line 295: IF FND_API.to_Boolean( p_commit )

291: -- End of API body
292: --
293:
294: -- Standard check for p_commit
295: IF FND_API.to_Boolean( p_commit )
296: THEN
297: COMMIT WORK;
298: END IF;
299:

Line 308: WHEN FND_API.G_EXC_ERROR THEN

304: p_data => x_msg_data
305: );
306:
307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: ROLLBACK TO CREATE_STATUS_RULE_PVT;
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: FND_MSG_PUB.Count_And_Get
312: ( p_count => x_msg_count,

Line 310: x_return_status := FND_API.G_RET_STS_ERROR;

306:
307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: ROLLBACK TO CREATE_STATUS_RULE_PVT;
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: FND_MSG_PUB.Count_And_Get
312: ( p_count => x_msg_count,
313: p_data => x_msg_data
314: );

Line 316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

312: ( p_count => x_msg_count,
313: p_data => x_msg_data
314: );
315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: ROLLBACK TO CREATE_STATUS_RULE_PVT;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

314: );
315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: ROLLBACK TO CREATE_STATUS_RULE_PVT;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,
321: p_data => x_msg_data
322: );

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: );
323:
324: WHEN OTHERS THEN
325: ROLLBACK TO CREATE_STATUS_RULE_PVT;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data
330: );

Line 383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

379: SAVEPOINT UPDATE_STATUS_RULE_PVT;
380:
381: l_STATUS_RULE_REC := p_status_rule_rec;
382: -- Standard call to check for call compatibility.
383: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
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: -- Initialize message list IF p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )

Line 392: IF FND_API.to_Boolean( p_init_msg_list )

388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391: -- Initialize message list IF p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )
393: THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: END IF;
396:
397:
398: -- Initialize API return status to SUCCESS
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401:
402: --
403: -- Api body

Line 429: RAISE FND_API.G_EXC_ERROR;

425: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
426: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rules', FALSE);
427: FND_MSG_PUB.Add;
428: END IF;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432:
433: Close C_Get_Status_Rule_Rec;

Line 444: RAISE FND_API.G_EXC_ERROR;

440: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
441: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
442: FND_MSG_PUB.ADD;
443: END IF;
444: RAISE FND_API.G_EXC_ERROR;
445: End IF;
446:
447:
448: -- Transfer Data into target record

Line 486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

482: , p_last_update_login => FND_GLOBAL.USER_ID
483: , p_object_version_number => l_status_rule_rec.object_version_number);
484:
485:
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;

Line 487: RAISE FND_API.G_EXC_ERROR;

483: , p_object_version_number => l_status_rule_rec.object_version_number);
484:
485:
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491:

Line 488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

484:
485:
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491:
492: --

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485:
486: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491:
492: --
493: -- End of API body.

Line 497: IF FND_API.to_Boolean( p_commit )

493: -- End of API body.
494: --
495:
496: -- Standard check for p_commit
497: IF FND_API.to_Boolean( p_commit )
498: THEN
499: COMMIT WORK;
500: END IF;
501:

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504: ( p_count => x_msg_count,
505: p_data => x_msg_data );
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO UPDATE_STATUS_RULE_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count,

Line 510: x_return_status := FND_API.G_RET_STS_ERROR;

506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO UPDATE_STATUS_RULE_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count,
513: p_data => x_msg_data
514: );

Line 516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

512: ( p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO UPDATE_STATUS_RULE_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,

Line 518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

514: );
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: ROLLBACK TO UPDATE_STATUS_RULE_PVT;
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: FND_MSG_PUB.Count_And_Get
520: ( p_count => x_msg_count,
521: p_data => x_msg_data
522: );

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: );
523:
524: WHEN OTHERS THEN
525: ROLLBACK TO UPDATE_STATUS_RULE_PVT;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: FND_MSG_PUB.Count_And_Get
528: ( p_count => x_msg_count,
529: p_data => x_msg_data
530: );

Line 569: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

565: -- Standard Start of API savepoint
566: SAVEPOINT DELETE_STATUS_RULE_PVT;
567:
568: -- Standard call to check for call compatibility.
569: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
570: p_api_version,
571: l_api_name,
572: G_PKG_NAME)
573: THEN

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

570: p_api_version,
571: l_api_name,
572: G_PKG_NAME)
573: THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END IF;
576:
577: -- Initialize message list IF p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )

Line 578: IF FND_API.to_Boolean( p_init_msg_list )

574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END IF;
576:
577: -- Initialize message list IF p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:

Line 585: x_return_status := FND_API.G_RET_STS_SUCCESS;

581: END IF;
582:
583:
584: -- Initialize API return status to SUCCESS
585: x_return_status := FND_API.G_RET_STS_SUCCESS;
586:
587: --
588: -- Api body
589: --

Line 602: RAISE FND_API.G_EXC_ERROR;

598: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
599: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rules', FALSE);
600: FND_MSG_PUB.Add;
601: END IF;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: Close C_Get_Status_Rule;
606:

Line 611: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

607: -- Invoke table handler
608: IEX_STATUS_RULE_PKG.Delete_Row(
609: x_rowid => l_rowid);
610:
611: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;

Line 612: RAISE FND_API.G_EXC_ERROR;

608: IEX_STATUS_RULE_PKG.Delete_Row(
609: x_rowid => l_rowid);
610:
611: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:

Line 613: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

609: x_rowid => l_rowid);
610:
611: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: --

Line 614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

610:
611: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;
613: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616:
617: --
618: -- End of API body

Line 622: IF FND_API.to_Boolean( p_commit )

618: -- End of API body
619: --
620:
621: -- Standard check for p_commit
622: IF FND_API.to_Boolean( p_commit )
623: THEN
624: COMMIT WORK;
625: END IF;
626:

Line 633: WHEN FND_API.G_EXC_ERROR THEN

629: ( p_count => x_msg_count,
630: p_data => x_msg_data );
631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: ROLLBACK TO DELETE_STATUS_RULE_PVT;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: ROLLBACK TO DELETE_STATUS_RULE_PVT;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,
638: p_data => x_msg_data
639: );

Line 641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

637: ( p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO DELETE_STATUS_RULE_PVT;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: ROLLBACK TO DELETE_STATUS_RULE_PVT;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: FND_MSG_PUB.Count_And_Get
645: ( p_count => x_msg_count,
646: p_data => x_msg_data
647: );

Line 651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

647: );
648:
649: WHEN OTHERS THEN
650: ROLLBACK TO DELETE_STATUS_RULE_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: FND_MSG_PUB.Count_And_Get
653: ( p_count => x_msg_count,
654: p_data => x_msg_data
655: );

Line 687: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

683: -- Standard Start of API savepoint
684: SAVEPOINT CREATE_status_rule_line_PVT;
685:
686: -- Standard call to check for call compatibility.
687: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
688: p_api_version,
689: l_api_name,
690: G_PKG_NAME)
691: THEN

Line 692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

688: p_api_version,
689: l_api_name,
690: G_PKG_NAME)
691: THEN
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: END IF;
694:
695:
696: -- Initialize message list IF p_init_msg_list is set to TRUE.

Line 697: IF FND_API.to_Boolean( p_init_msg_list )

693: END IF;
694:
695:
696: -- Initialize message list IF p_init_msg_list is set to TRUE.
697: IF FND_API.to_Boolean( p_init_msg_list )
698: THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701:

Line 704: x_return_status := FND_API.G_RET_STS_SUCCESS;

700: END IF;
701:
702:
703: -- Initialize API return status to SUCCESS
704: x_return_status := FND_API.G_RET_STS_SUCCESS;
705:
706: --
707: -- API body
708: --

Line 736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

732: , p_last_update_login => FND_GLOBAL.USER_ID
733: , p_object_version_number => 1.0);
734:
735:
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: RAISE FND_API.G_EXC_ERROR;
738: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;

Line 737: RAISE FND_API.G_EXC_ERROR;

733: , p_object_version_number => 1.0);
734:
735:
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: RAISE FND_API.G_EXC_ERROR;
738: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741:

Line 738: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

734:
735:
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: RAISE FND_API.G_EXC_ERROR;
738: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741:
742:

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735:
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: RAISE FND_API.G_EXC_ERROR;
738: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741:
742:
743: --

Line 748: IF FND_API.to_Boolean( p_commit )

744: -- End of API body
745: --
746:
747: -- Standard check for p_commit
748: IF FND_API.to_Boolean( p_commit )
749: THEN
750: COMMIT WORK;
751: END IF;
752:

Line 761: WHEN FND_API.G_EXC_ERROR THEN

757: p_data => x_msg_data
758: );
759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK To CREATE_status_rule_line_PVT;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get
765: ( p_count => x_msg_count,

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759:
760: EXCEPTION
761: WHEN FND_API.G_EXC_ERROR THEN
762: ROLLBACK To CREATE_status_rule_line_PVT;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get
765: ( p_count => x_msg_count,
766: p_data => x_msg_data );
767:

Line 768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

764: FND_MSG_PUB.Count_And_Get
765: ( p_count => x_msg_count,
766: p_data => x_msg_data );
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769: ROLLBACK To CREATE_status_rule_line_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: FND_MSG_PUB.Count_And_Get
772: ( p_count => x_msg_count,

Line 770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

766: p_data => x_msg_data );
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769: ROLLBACK To CREATE_status_rule_line_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: FND_MSG_PUB.Count_And_Get
772: ( p_count => x_msg_count,
773: p_data => x_msg_data );
774:

Line 777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

773: p_data => x_msg_data );
774:
775: WHEN OTHERS THEN
776: ROLLBACK To CREATE_status_rule_line_PVT;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.Count_And_Get
779: ( p_count => x_msg_count,
780: p_data => x_msg_data );
781:

Line 828: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

824: -- Standard Start of API savepoint
825: SAVEPOINT UPDATE_status_rule_line_PVT;
826:
827: -- Standard call to check for call compatibility.
828: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
829: p_api_version,
830: l_api_name,
831: G_PKG_NAME)
832: THEN

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: p_api_version,
830: l_api_name,
831: G_PKG_NAME)
832: THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835:
836: -- Initialize message list IF p_init_msg_list is set to TRUE.
837: IF FND_API.to_Boolean( p_init_msg_list )

Line 837: IF FND_API.to_Boolean( p_init_msg_list )

833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: END IF;
835:
836: -- Initialize message list IF p_init_msg_list is set to TRUE.
837: IF FND_API.to_Boolean( p_init_msg_list )
838: THEN
839: FND_MSG_PUB.initialize;
840: END IF;
841:

Line 844: x_return_status := FND_API.G_RET_STS_SUCCESS;

840: END IF;
841:
842:
843: -- Initialize API return status to SUCCESS
844: x_return_status := FND_API.G_RET_STS_SUCCESS;
845:
846: --
847: -- Api body
848: --

Line 873: RAISE FND_API.G_EXC_ERROR;

869: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
870: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rule_lines', FALSE);
871: FND_MSG_PUB.Add;
872: END IF;
873: RAISE FND_API.G_EXC_ERROR;
874: END IF;
875:
876: Close C_Get_status_rule_line_Rec;
877:

Line 888: RAISE FND_API.G_EXC_ERROR;

884: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
885: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
886: FND_MSG_PUB.ADD;
887: END IF;
888: RAISE FND_API.G_EXC_ERROR;
889: End IF;
890:
891:
892: -- Transfer Data into target record

Line 923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

919: , p_enabled_flag => l_status_rule_line_rec.enabled_flag
920: , p_status_rule_id => l_status_rule_line_rec.status_rule_id
921: , p_object_version_number => l_status_rule_line_rec.object_version_number);
922:
923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;

Line 924: RAISE FND_API.G_EXC_ERROR;

920: , p_status_rule_id => l_status_rule_line_rec.status_rule_id
921: , p_object_version_number => l_status_rule_line_rec.object_version_number);
922:
923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:

Line 925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

921: , p_object_version_number => l_status_rule_line_rec.object_version_number);
922:
923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:
929: --

Line 926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

922:
923: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
924: RAISE FND_API.G_EXC_ERROR;
925: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
927: END IF;
928:
929: --
930: -- End of API body.

Line 934: IF FND_API.to_Boolean( p_commit )

930: -- End of API body.
931: --
932:
933: -- Standard check for p_commit
934: IF FND_API.to_Boolean( p_commit )
935: THEN
936: COMMIT WORK;
937: END IF;
938:

Line 946: WHEN FND_API.G_EXC_ERROR THEN

942: ( p_count => x_msg_count,
943: p_data => x_msg_data );
944:
945: EXCEPTION
946: WHEN FND_API.G_EXC_ERROR THEN
947: ROLLBACK To UPDATE_status_rule_line_PVT;
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,

Line 948: x_return_status := FND_API.G_RET_STS_ERROR;

944:
945: EXCEPTION
946: WHEN FND_API.G_EXC_ERROR THEN
947: ROLLBACK To UPDATE_status_rule_line_PVT;
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,
951: p_data => x_msg_data );
952:

Line 953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

949: FND_MSG_PUB.Count_And_Get
950: ( p_count => x_msg_count,
951: p_data => x_msg_data );
952:
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: ROLLBACK To UPDATE_status_rule_line_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: FND_MSG_PUB.Count_And_Get
957: ( p_count => x_msg_count,

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

951: p_data => x_msg_data );
952:
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: ROLLBACK To UPDATE_status_rule_line_PVT;
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: FND_MSG_PUB.Count_And_Get
957: ( p_count => x_msg_count,
958: p_data => x_msg_data );
959:

Line 962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

958: p_data => x_msg_data );
959:
960: WHEN OTHERS THEN
961: ROLLBACK To UPDATE_status_rule_line_PVT;
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: FND_MSG_PUB.Count_And_Get
964: ( p_count => x_msg_count,
965: p_data => x_msg_data );
966: END Update_status_rule_line;

Line 998: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

994: -- Standard Start of API savepoint
995: SAVEPOINT DELETE_status_rule_line_PUB;
996:
997: -- Standard call to check for call compatibility.
998: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
999: p_api_version,
1000: l_api_name,
1001: G_PKG_NAME)
1002: THEN

Line 1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

999: p_api_version,
1000: l_api_name,
1001: G_PKG_NAME)
1002: THEN
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: END IF;
1005:
1006: -- Initialize message list IF p_init_msg_list is set to TRUE.
1007: IF FND_API.to_Boolean( p_init_msg_list )

Line 1007: IF FND_API.to_Boolean( p_init_msg_list )

1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: END IF;
1005:
1006: -- Initialize message list IF p_init_msg_list is set to TRUE.
1007: IF FND_API.to_Boolean( p_init_msg_list )
1008: THEN
1009: FND_MSG_PUB.initialize;
1010: END IF;
1011:

Line 1014: x_return_status := FND_API.G_RET_STS_SUCCESS;

1010: END IF;
1011:
1012:
1013: -- Initialize API return status to SUCCESS
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015:
1016: --
1017: -- Api body
1018: --

Line 1030: RAISE FND_API.G_EXC_ERROR;

1026: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1027: FND_MESSAGE.Set_Token ('INFO', 'iex_status_rule_lines', FALSE);
1028: FND_MSG_PUB.Add;
1029: END IF;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: Close C_Get_status_rule_line;
1034:

Line 1039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1035:
1036: -- Invoke table handler
1037: iex_status_rule_line_PKG.Delete_Row(x_rowid => l_rowid);
1038:
1039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;

Line 1040: RAISE FND_API.G_EXC_ERROR;

1036: -- Invoke table handler
1037: iex_status_rule_line_PKG.Delete_Row(x_rowid => l_rowid);
1038:
1039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044:

Line 1041: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1037: iex_status_rule_line_PKG.Delete_Row(x_rowid => l_rowid);
1038:
1039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044:
1045: --

Line 1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1038:
1039: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1040: RAISE FND_API.G_EXC_ERROR;
1041: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044:
1045: --
1046: -- End of API body

Line 1050: IF FND_API.to_Boolean( p_commit )

1046: -- End of API body
1047: --
1048:
1049: -- Standard check for p_commit
1050: IF FND_API.to_Boolean( p_commit )
1051: THEN
1052: COMMIT WORK;
1053: END IF;
1054:

Line 1061: WHEN FND_API.G_EXC_ERROR THEN

1057: ( p_count => x_msg_count,
1058: p_data => x_msg_data );
1059:
1060: EXCEPTION
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: ROLLBACK To DELETE_status_rule_line_PVT;
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: FND_MSG_PUB.Count_And_Get
1065: ( p_count => x_msg_count,

Line 1063: x_return_status := FND_API.G_RET_STS_ERROR;

1059:
1060: EXCEPTION
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: ROLLBACK To DELETE_status_rule_line_PVT;
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: FND_MSG_PUB.Count_And_Get
1065: ( p_count => x_msg_count,
1066: p_data => x_msg_data );
1067:

Line 1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1064: FND_MSG_PUB.Count_And_Get
1065: ( p_count => x_msg_count,
1066: p_data => x_msg_data );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK To DELETE_status_rule_line_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: FND_MSG_PUB.Count_And_Get
1072: ( p_count => x_msg_count,

Line 1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1066: p_data => x_msg_data );
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: ROLLBACK To DELETE_status_rule_line_PVT;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071: FND_MSG_PUB.Count_And_Get
1072: ( p_count => x_msg_count,
1073: p_data => x_msg_data );
1074:

Line 1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1073: p_data => x_msg_data );
1074:
1075: WHEN OTHERS THEN
1076: ROLLBACK To DELETE_status_rule_line_PVT;
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1078: FND_MSG_PUB.Count_And_Get
1079: ( p_count => x_msg_count,
1080: p_data => x_msg_data );
1081: END Delete_status_rule_line;