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_PUB dependencies on FND_API

Line 34: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

30: -- Standard Start of API savepoint
31: SAVEPOINT Create_Status_Rule_PUB;
32:
33: -- Standard call to check for call compatibility.
34: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
35: p_api_version,
36: l_api_name,
37: G_PKG_NAME)
38: THEN

Line 39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

35: p_api_version,
36: l_api_name,
37: G_PKG_NAME)
38: THEN
39: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
40: END IF;
41:
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 44: IF FND_API.to_Boolean( p_init_msg_list )

40: END IF;
41:
42:
43: -- Initialize message list if p_init_msg_list is set to TRUE.
44: IF FND_API.to_Boolean( p_init_msg_list )
45: THEN
46: FND_MSG_PUB.initialize;
47: END IF;
48:

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
53:
54:
55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: --
59: -- API body
60: --

Line 66: , p_init_msg_list => FND_API.G_FALSE

62: IEX_DEBUG_PUB.LogMessage('Public API: Calling IEX_STATUS_RULE_PVT.Create_Status_Rule');
63:
64: IEX_STATUS_RULE_PVT.Create_Status_Rule(
65: p_api_version => p_api_version
66: , p_init_msg_list => FND_API.G_FALSE
67: , p_commit => p_commit
68: , p_status_rule_rec => p_status_rule_rec
69: , x_status_rule_id => x_status_rule_id
70: , x_dup_status => x_dup_status

Line 75: IF x_return_status = FND_API.G_RET_STS_ERROR then

71: , x_return_status => x_return_status
72: , x_msg_count => x_msg_count
73: , x_msg_data => x_msg_data);
74:
75: IF x_return_status = FND_API.G_RET_STS_ERROR then
76: raise FND_API.G_EXC_ERROR;
77: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
78: raise FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;

Line 76: raise FND_API.G_EXC_ERROR;

72: , x_msg_count => x_msg_count
73: , x_msg_data => x_msg_data);
74:
75: IF x_return_status = FND_API.G_RET_STS_ERROR then
76: raise FND_API.G_EXC_ERROR;
77: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
78: raise FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:

Line 77: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

73: , x_msg_data => x_msg_data);
74:
75: IF x_return_status = FND_API.G_RET_STS_ERROR then
76: raise FND_API.G_EXC_ERROR;
77: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
78: raise FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: --

Line 78: raise FND_API.G_EXC_UNEXPECTED_ERROR;

74:
75: IF x_return_status = FND_API.G_RET_STS_ERROR then
76: raise FND_API.G_EXC_ERROR;
77: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
78: raise FND_API.G_EXC_UNEXPECTED_ERROR;
79: END IF;
80:
81: --
82: -- End of API body

Line 86: IF FND_API.to_Boolean( p_commit )

82: -- End of API body
83: --
84:
85: -- Standard check for p_commit
86: IF FND_API.to_Boolean( p_commit )
87: THEN
88: COMMIT WORK;
89: END IF;
90:

Line 103: WHEN FND_API.G_EXC_ERROR THEN

99: p_data => x_msg_data
100: );
101:
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: ROLLBACK TO Create_Status_Rule_PUB;
105: x_return_status := FND_API.G_RET_STS_ERROR ;
106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count,

Line 105: x_return_status := FND_API.G_RET_STS_ERROR ;

101:
102: EXCEPTION
103: WHEN FND_API.G_EXC_ERROR THEN
104: ROLLBACK TO Create_Status_Rule_PUB;
105: x_return_status := FND_API.G_RET_STS_ERROR ;
106: FND_MSG_PUB.Count_And_Get
107: ( p_count => x_msg_count,
108: p_data => x_msg_data
109: );

Line 121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

117: ,X_MSG_DATA => X_MSG_DATA
118: ,X_RETURN_STATUS => X_RETURN_STATUS);
119: */
120:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: ROLLBACK TO Create_Status_Rule_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,

Line 123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

119: */
120:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: ROLLBACK TO Create_Status_Rule_PUB;
123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
124: FND_MSG_PUB.Count_And_Get
125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137: */
138:
139: WHEN OTHERS THEN
140: ROLLBACK TO Create_Status_Rule_PUB;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count,
144: p_data => x_msg_data
145: );

Line 185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

181: -- Standard Start of API savepoint
182: SAVEPOINT Update_Status_Rule_PUB;
183:
184: -- Standard call to check for call compatibility.
185: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
186: p_api_version,
187: l_api_name,
188: G_PKG_NAME)
189: THEN

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: p_api_version,
187: l_api_name,
188: G_PKG_NAME)
189: THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )

Line 194: IF FND_API.to_Boolean( p_init_msg_list )

190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198:

Line 205: x_return_status := FND_API.G_RET_STS_SUCCESS;

201: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
202:
203:
204: -- Initialize API return status to SUCCESS
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: --
208: -- Api body
209: --

Line 229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

225: , x_msg_count => x_msg_count
226: , x_msg_data => x_msg_data
227: );
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: RAISE FND_API.G_EXC_ERROR;
231: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
232: raise FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;

Line 230: RAISE FND_API.G_EXC_ERROR;

226: , x_msg_data => x_msg_data
227: );
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: RAISE FND_API.G_EXC_ERROR;
231: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
232: raise FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:

Line 231: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

227: );
228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: RAISE FND_API.G_EXC_ERROR;
231: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
232: raise FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END LOOP;

Line 232: raise FND_API.G_EXC_UNEXPECTED_ERROR;

228:
229: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
230: RAISE FND_API.G_EXC_ERROR;
231: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
232: raise FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: END LOOP;
236: --

Line 241: IF FND_API.to_Boolean( p_commit )

237: -- End of API body.
238: --
239:
240: -- Standard check for p_commit
241: IF FND_API.to_Boolean( p_commit )
242: THEN
243: COMMIT WORK;
244: END IF;
245:

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: ( p_count => x_msg_count,
254: p_data => x_msg_data );
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO Update_Status_Rule_PUB;
259: x_return_status := FND_API.G_RET_STS_ERROR ;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,

Line 259: x_return_status := FND_API.G_RET_STS_ERROR ;

255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO Update_Status_Rule_PUB;
259: x_return_status := FND_API.G_RET_STS_ERROR ;
260: FND_MSG_PUB.Count_And_Get
261: ( p_count => x_msg_count,
262: p_data => x_msg_data
263: );

Line 275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273: */
274:
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: ROLLBACK TO Update_Status_Rule_PUB;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: FND_MSG_PUB.Count_And_Get
279: ( p_count => x_msg_count,

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

273: */
274:
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: ROLLBACK TO Update_Status_Rule_PUB;
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: FND_MSG_PUB.Count_And_Get
279: ( p_count => x_msg_count,
280: p_data => x_msg_data
281: );

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

291: */
292:
293: WHEN OTHERS THEN
294: ROLLBACK TO Update_Status_Rule_PUB;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: ( p_count => x_msg_count,
298: p_data => x_msg_data
299: );

Line 338: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

334: -- Standard Start of API savepoint
335: SAVEPOINT Delete_Status_Rule_PUB;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
339: p_api_version,
340: l_api_name,
341: G_PKG_NAME)
342: THEN

Line 343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

339: p_api_version,
340: l_api_name,
341: G_PKG_NAME)
342: THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )

Line 347: IF FND_API.to_Boolean( p_init_msg_list )

343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )
348: THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:

Line 358: x_return_status := FND_API.G_RET_STS_SUCCESS;

354: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
355:
356:
357: -- Initialize API return status to SUCCESS
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359:
360: --
361: -- Api body
362: --

Line 380: IF x_return_status = FND_API.G_RET_STS_ERROR then

376: , x_msg_count => l_msg_count
377: , x_msg_data => l_msg_data
378: );
379:
380: IF x_return_status = FND_API.G_RET_STS_ERROR then
381: raise FND_API.G_EXC_ERROR;
382: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
383: raise FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;

Line 381: raise FND_API.G_EXC_ERROR;

377: , x_msg_data => l_msg_data
378: );
379:
380: IF x_return_status = FND_API.G_RET_STS_ERROR then
381: raise FND_API.G_EXC_ERROR;
382: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
383: raise FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:

Line 382: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

378: );
379:
380: IF x_return_status = FND_API.G_RET_STS_ERROR then
381: raise FND_API.G_EXC_ERROR;
382: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
383: raise FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:
386: END loop;

Line 383: raise FND_API.G_EXC_UNEXPECTED_ERROR;

379:
380: IF x_return_status = FND_API.G_RET_STS_ERROR then
381: raise FND_API.G_EXC_ERROR;
382: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
383: raise FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385:
386: END loop;
387:

Line 393: IF FND_API.to_Boolean( p_commit )

389: -- End of API body
390: --
391:
392: -- Standard check for p_commit
393: IF FND_API.to_Boolean( p_commit )
394: THEN
395: COMMIT WORK;
396: END IF;
397:

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: ( p_count => x_msg_count,
405: p_data => x_msg_data );
406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO Delete_Status_Rule_PUB;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,

Line 410: x_return_status := FND_API.G_RET_STS_ERROR ;

406:
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO Delete_Status_Rule_PUB;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );

Line 425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

421: ,X_MSG_COUNT => X_MSG_COUNT
422: ,X_MSG_DATA => X_MSG_DATA
423: ,X_RETURN_STATUS => X_RETURN_STATUS);
424: */
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO Delete_Status_Rule_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

423: ,X_RETURN_STATUS => X_RETURN_STATUS);
424: */
425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
426: ROLLBACK TO Delete_Status_Rule_PUB;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,
430: p_data => x_msg_data
431: );

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

440: ,X_RETURN_STATUS => X_RETURN_STATUS);
441: */
442: WHEN OTHERS THEN
443: ROLLBACK TO Delete_Status_Rule_PUB;
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
445: FND_MSG_PUB.Count_And_Get
446: ( p_count => x_msg_count,
447: p_data => x_msg_data
448: );

Line 487: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

483: -- Standard Start of API savepoint
484: SAVEPOINT Create_Status_Rule_Line_PUB;
485:
486: -- Standard call to check for call compatibility.
487: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
488: p_api_version,
489: l_api_name,
490: G_PKG_NAME)
491: THEN

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

488: p_api_version,
489: l_api_name,
490: G_PKG_NAME)
491: THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495:
496: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 497: IF FND_API.to_Boolean( p_init_msg_list )

493: END IF;
494:
495:
496: -- Initialize message list if p_init_msg_list is set to TRUE.
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
505:
506:
507: -- Initialize API return status to SUCCESS
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: --
511: -- API body
512: --

Line 519: , p_init_msg_list => FND_API.G_FALSE

515:
516:
517: IEX_STATUS_RULE_PVT.Create_Status_Rule_Line(
518: p_api_version => p_api_version
519: , p_init_msg_list => FND_API.G_FALSE
520: , p_commit => p_Commit
521: , p_status_rule_line_rec => p_status_rule_line_rec
522: , x_return_status => x_return_status
523: , x_msg_count => x_msg_count

Line 528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

524: , x_msg_data => x_msg_data
525: , x_status_rule_line_id => x_status_rule_line_id
526: );
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE FND_API.G_EXC_ERROR;
530: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;

Line 529: RAISE FND_API.G_EXC_ERROR;

525: , x_status_rule_line_id => x_status_rule_line_id
526: );
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE FND_API.G_EXC_ERROR;
530: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:

Line 530: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

526: );
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE FND_API.G_EXC_ERROR;
530: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: --

Line 531: raise FND_API.G_EXC_UNEXPECTED_ERROR;

527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE FND_API.G_EXC_ERROR;
530: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
531: raise FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534: --
535: -- End of API body

Line 539: IF FND_API.to_Boolean( p_commit )

535: -- End of API body
536: --
537:
538: -- Standard check for p_commit
539: IF FND_API.to_Boolean( p_commit )
540: THEN
541: COMMIT WORK;
542: END IF;
543:

Line 556: WHEN FND_API.G_EXC_ERROR THEN

552: p_data => x_msg_data
553: );
554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK To Create_Status_Rule_Line_PUB;
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,

Line 558: x_return_status := FND_API.G_RET_STS_ERROR ;

554:
555: EXCEPTION
556: WHEN FND_API.G_EXC_ERROR THEN
557: ROLLBACK To Create_Status_Rule_Line_PUB;
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get
560: ( p_count => x_msg_count,
561: p_data => x_msg_data
562: );

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

560: ( p_count => x_msg_count,
561: p_data => x_msg_data
562: );
563:
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Create_Status_Rule_Line_PUB;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: FND_MSG_PUB.Count_And_Get
568: ( p_count => x_msg_count,

Line 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

562: );
563:
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: ROLLBACK TO Create_Status_Rule_Line_PUB;
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: FND_MSG_PUB.Count_And_Get
568: ( p_count => x_msg_count,
569: p_data => x_msg_data
570: );

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

570: );
571:
572: WHEN OTHERS THEN
573: ROLLBACK TO Create_Status_Rule_Line_PUB;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count,
577: p_data => x_msg_data
578: );

Line 608: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

604: -- Standard Start of API savepoint
605: SAVEPOINT Update_Status_Rule_Line_PUB;
606:
607: -- Standard call to check for call compatibility.
608: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
609: p_api_version,
610: l_api_name,
611: G_PKG_NAME)
612: THEN

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

609: p_api_version,
610: l_api_name,
611: G_PKG_NAME)
612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615:
616: -- Initialize message list if p_init_msg_list is set to TRUE.
617: IF FND_API.to_Boolean( p_init_msg_list )

Line 617: IF FND_API.to_Boolean( p_init_msg_list )

613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615:
616: -- Initialize message list if p_init_msg_list is set to TRUE.
617: IF FND_API.to_Boolean( p_init_msg_list )
618: THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
625:
626:
627: -- Initialize API return status to SUCCESS
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: --
631: -- Api body
632: --

Line 642: , p_init_msg_list => FND_API.G_FALSE

638: l_status_rule_line_rec := p_status_rule_line_tbl(i);
639:
640: IEX_STATUS_RULE_PVT.Update_Status_Rule_Line(
641: p_api_version => p_api_version
642: , p_init_msg_list => FND_API.G_FALSE
643: , p_commit => p_commit
644: , p_status_rule_line_rec => l_status_rule_line_rec
645: , x_return_status => x_return_status
646: , x_msg_count => x_msg_count

Line 650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

646: , x_msg_count => x_msg_count
647: , x_msg_data => x_msg_data
648: );
649:
650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;

Line 651: RAISE FND_API.G_EXC_ERROR;

647: , x_msg_data => x_msg_data
648: );
649:
650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;
655: END LOOP;

Line 652: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

648: );
649:
650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;
655: END LOOP;
656: --

Line 653: raise FND_API.G_EXC_UNEXPECTED_ERROR;

649:
650: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
653: raise FND_API.G_EXC_UNEXPECTED_ERROR;
654: END IF;
655: END LOOP;
656: --
657: -- End of API body.

Line 661: IF FND_API.to_Boolean( p_commit )

657: -- End of API body.
658: --
659:
660: -- Standard check for p_commit
661: IF FND_API.to_Boolean( p_commit )
662: THEN
663: COMMIT WORK;
664: END IF;
665:

Line 677: WHEN FND_API.G_EXC_ERROR THEN

673: ( p_count => x_msg_count,
674: p_data => x_msg_data );
675:
676: EXCEPTION
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK To Update_Status_Rule_Line_PUB;
679: x_return_status := FND_API.G_RET_STS_ERROR ;
680: FND_MSG_PUB.Count_And_Get
681: ( p_count => x_msg_count,

Line 679: x_return_status := FND_API.G_RET_STS_ERROR ;

675:
676: EXCEPTION
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK To Update_Status_Rule_Line_PUB;
679: x_return_status := FND_API.G_RET_STS_ERROR ;
680: FND_MSG_PUB.Count_And_Get
681: ( p_count => x_msg_count,
682: p_data => x_msg_data
683: );

Line 685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

681: ( p_count => x_msg_count,
682: p_data => x_msg_data
683: );
684:
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO Update_Status_Rule_Line_PUB;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: FND_MSG_PUB.Count_And_Get
689: ( p_count => x_msg_count,

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

683: );
684:
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO Update_Status_Rule_Line_PUB;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: FND_MSG_PUB.Count_And_Get
689: ( p_count => x_msg_count,
690: p_data => x_msg_data
691: );

Line 695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

691: );
692:
693: WHEN OTHERS THEN
694: ROLLBACK TO Update_Status_Rule_Line_PUB;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
696: FND_MSG_PUB.Count_And_Get
697: ( p_count => x_msg_count,
698: p_data => x_msg_data
699: );

Line 728: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

724: -- Standard Start of API savepoint
725: SAVEPOINT Delete_Status_Rule_Line_PUB;
726:
727: -- Standard call to check for call compatibility.
728: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
729: p_api_version,
730: l_api_name,
731: G_PKG_NAME)
732: THEN

Line 733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

729: p_api_version,
730: l_api_name,
731: G_PKG_NAME)
732: THEN
733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: -- Initialize message list if p_init_msg_list is set to TRUE.
737: IF FND_API.to_Boolean( p_init_msg_list )

Line 737: IF FND_API.to_Boolean( p_init_msg_list )

733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: -- Initialize message list if p_init_msg_list is set to TRUE.
737: IF FND_API.to_Boolean( p_init_msg_list )
738: THEN
739: FND_MSG_PUB.initialize;
740: END IF;
741:

Line 748: x_return_status := FND_API.G_RET_STS_SUCCESS;

744: IEX_DEBUG_PUB.LogMessage('Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
745:
746:
747: -- Initialize API return status to SUCCESS
748: x_return_status := FND_API.G_RET_STS_SUCCESS;
749:
750: --
751: -- Api body
752: --

Line 762: , p_init_msg_list => FND_API.G_FALSE

758: l_status_rule_line_id := p_status_rule_line_id_tbl(i);
759:
760: IEX_STATUS_RULE_PVT.Delete_Status_Rule_Line(
761: p_api_version => p_api_version
762: , p_init_msg_list => FND_API.G_FALSE
763: , p_commit => p_commit
764: , p_status_rule_id => p_status_rule_id
765: , p_status_rule_line_id => l_status_rule_line_id
766: , x_return_status => x_return_status

Line 771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

767: , x_msg_count => x_msg_count
768: , x_msg_data => x_msg_data
769: );
770:
771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;

Line 772: RAISE FND_API.G_EXC_ERROR;

768: , x_msg_data => x_msg_data
769: );
770:
771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: end loop;

Line 773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

769: );
770:
771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: end loop;
777: --

Line 774: raise FND_API.G_EXC_UNEXPECTED_ERROR;

770:
771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
772: RAISE FND_API.G_EXC_ERROR;
773: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
774: raise FND_API.G_EXC_UNEXPECTED_ERROR;
775: END IF;
776: end loop;
777: --
778: -- End of API body

Line 782: IF FND_API.to_Boolean( p_commit )

778: -- End of API body
779: --
780:
781: -- Standard check for p_commit
782: IF FND_API.to_Boolean( p_commit )
783: THEN
784: COMMIT WORK;
785: END IF;
786:

Line 796: WHEN FND_API.G_EXC_ERROR THEN

792: ( p_count => x_msg_count,
793: p_data => x_msg_data );
794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK To Delete_Status_Rule_Line_PUB;
798: x_return_status := FND_API.G_RET_STS_ERROR ;
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count,

Line 798: x_return_status := FND_API.G_RET_STS_ERROR ;

794:
795: EXCEPTION
796: WHEN FND_API.G_EXC_ERROR THEN
797: ROLLBACK To Delete_Status_Rule_Line_PUB;
798: x_return_status := FND_API.G_RET_STS_ERROR ;
799: FND_MSG_PUB.Count_And_Get
800: ( p_count => x_msg_count,
801: p_data => x_msg_data
802: );

Line 804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

800: ( p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803:
804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
805: ROLLBACK TO Delete_Status_Rule_Line_PUB;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

802: );
803:
804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
805: ROLLBACK TO Delete_Status_Rule_Line_PUB;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

810: );
811:
812: WHEN OTHERS THEN
813: ROLLBACK TO Delete_Status_Rule_Line_PUB;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815: FND_MSG_PUB.Count_And_Get
816: ( p_count => x_msg_count,
817: p_data => x_msg_data
818: );