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

Line 79: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

75:
76:
77: Procedure Change_Doc_LC_Phase
78: ( p_api_version IN NUMBER --
79: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
80: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
81: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
82: ,p_change_id IN NUMBER
83: ,p_lc_phase_code IN NUMBER

Line 80: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --

76:
77: Procedure Change_Doc_LC_Phase
78: ( p_api_version IN NUMBER --
79: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
80: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
81: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
82: ,p_change_id IN NUMBER
83: ,p_lc_phase_code IN NUMBER
84: ,p_action_type IN VARCHAR2-- 'PROMOTE' or 'DEMOTE'

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

77: Procedure Change_Doc_LC_Phase
78: ( p_api_version IN NUMBER --
79: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
80: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
81: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
82: ,p_change_id IN NUMBER
83: ,p_lc_phase_code IN NUMBER
84: ,p_action_type IN VARCHAR2-- 'PROMOTE' or 'DEMOTE'
85: ,p_api_caller IN VARCHAR2

Line 118: IF p_commit = FND_API.G_TRUE THEN

114:
115: UPDATE dom_document_revisions SET lifecycle_phase_id = p_lc_phase_code
116: WHERE lifecycle_tracking_id = p_change_id;
117:
118: IF p_commit = FND_API.G_TRUE THEN
119: commit;
120: END IF;
121:
122: -- Initialize API return status to success

Line 123: x_return_status := FND_API.G_RET_STS_SUCCESS;

119: commit;
120: END IF;
121:
122: -- Initialize API return status to success
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124: -- Standard ending code ------------------------------------------------
125:
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137:
138:
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN
142: x_return_status := FND_API.G_RET_STS_ERROR;
143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count
145: ,p_data => x_msg_data );

Line 142: x_return_status := FND_API.G_RET_STS_ERROR;

138:
139: EXCEPTION
140:
141: WHEN FND_API.G_EXC_ERROR THEN
142: x_return_status := FND_API.G_RET_STS_ERROR;
143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count
145: ,p_data => x_msg_data );
146:

Line 147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

143: FND_MSG_PUB.Count_And_Get
144: ( p_count => x_msg_count
145: ,p_data => x_msg_data );
146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count
151: ,p_data => x_msg_data );

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: ( p_count => x_msg_count
145: ,p_data => x_msg_data );
146:
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: FND_MSG_PUB.Count_And_Get
150: ( p_count => x_msg_count
151: ,p_data => x_msg_data );
152:

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

150: ( p_count => x_msg_count
151: ,p_data => x_msg_data );
152:
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
155: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
158: END IF;

Line 168: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

164:
165:
166: Procedure Update_Approval_Status
167: ( p_api_version IN NUMBER --
168: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
170: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
171: ,p_change_id IN NUMBER
172: ,p_approval_status IN NUMBER

Line 169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --

165:
166: Procedure Update_Approval_Status
167: ( p_api_version IN NUMBER --
168: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
170: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
171: ,p_change_id IN NUMBER
172: ,p_approval_status IN NUMBER
173: ,p_wf_route_status IN VARCHAR2

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

166: Procedure Update_Approval_Status
167: ( p_api_version IN NUMBER --
168: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
170: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
171: ,p_change_id IN NUMBER
172: ,p_approval_status IN NUMBER
173: ,p_wf_route_status IN VARCHAR2
174: ,p_api_caller IN VARCHAR2

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

220: END IF ;
221:
222:
223: -- Initialize API return status to success
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226:
227: SELECT rev.lifecycle_phase_id, status_type, life.sequence_number
228: INTO l_status_code, l_status_type, l_seq_num

Line 312: IF p_commit = FND_API.G_TRUE THEN

308: WHERE ver.revision_id = rev.revision_id
309: AND rev.revision_id = ver.revision_id
310: AND rev.lifecycle_tracking_id = p_change_id));
311:
312: IF p_commit = FND_API.G_TRUE THEN
313: commit;
314: END IF;
315:
316:

Line 334: WHEN FND_API.G_EXC_ERROR THEN

330:
331:
332: EXCEPTION
333:
334: WHEN FND_API.G_EXC_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count
338: ,p_data => x_msg_data );

Line 335: x_return_status := FND_API.G_RET_STS_ERROR;

331:
332: EXCEPTION
333:
334: WHEN FND_API.G_EXC_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_ERROR;
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count
338: ,p_data => x_msg_data );
339:

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count
338: ,p_data => x_msg_data );
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count
344: ,p_data => x_msg_data );

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

337: ( p_count => x_msg_count
338: ,p_data => x_msg_data );
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count
344: ,p_data => x_msg_data );
345:

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

343: ( p_count => x_msg_count
344: ,p_data => x_msg_data );
345:
346: WHEN OTHERS THEN
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
349: THEN
350: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
351: END IF;

Line 367: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

363: -- We can put validation logic here
364: --
365: Procedure Start_Doc_LC_Phase_WF
366: ( p_api_version IN NUMBER --
367: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
368: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
369: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
370: ,x_return_status OUT NOCOPY VARCHAR2 --
371: ,x_msg_count OUT NOCOPY NUMBER --

Line 368: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --

364: --
365: Procedure Start_Doc_LC_Phase_WF
366: ( p_api_version IN NUMBER --
367: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
368: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
369: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
370: ,x_return_status OUT NOCOPY VARCHAR2 --
371: ,x_msg_count OUT NOCOPY NUMBER --
372: ,x_msg_data OUT NOCOPY VARCHAR2

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

365: Procedure Start_Doc_LC_Phase_WF
366: ( p_api_version IN NUMBER --
367: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
368: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
369: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
370: ,x_return_status OUT NOCOPY VARCHAR2 --
371: ,x_msg_count OUT NOCOPY NUMBER --
372: ,x_msg_data OUT NOCOPY VARCHAR2
373: ,p_change_id IN NUMBER

Line 396: IF NOT FND_API.Compatible_API_Call( l_api_version

392: -- Standard Start of API savepoint
393: SAVEPOINT l_api_name;
394:
395: -- Standard call to check for call compatibility.
396: IF NOT FND_API.Compatible_API_Call( l_api_version
397: , p_api_version
398: , l_api_name
399: , G_PKG_NAME )
400: THEN

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

397: , p_api_version
398: , l_api_name
399: , G_PKG_NAME )
400: THEN
401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 405: IF FND_API.to_Boolean( p_init_msg_list ) THEN

401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
402: END IF;
403:
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list ) THEN
406: FND_MSG_PUB.initialize;
407: END IF ;
408:
409: -- Initialize API return status to success

Line 410: x_return_status := FND_API.G_RET_STS_SUCCESS;

406: FND_MSG_PUB.initialize;
407: END IF ;
408:
409: -- Initialize API return status to success
410: x_return_status := FND_API.G_RET_STS_SUCCESS;
411:
412:
413: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
414: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Begin ' || l_api_name);

Line 469: x_return_status := FND_API.G_RET_STS_ERROR ;

465: IF DOM_LOG.CHECK_LOG_LEVEL THEN
466: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Document LC Workflow cannot be started in this status') ;
467: END IF ;
468:
469: x_return_status := FND_API.G_RET_STS_ERROR ;
470: FND_MESSAGE.SET_NAME('DOM', 'DOM_LC_WF_CANNOT_START') ;
471: FND_MESSAGE.SET_TOKEN('LC_PHASE', l_lc_phase_display_name ) ;
472: FND_MSG_PUB.Add ;
473:

Line 485: IF FND_API.To_Boolean( p_commit ) THEN

481: -----------------------------------------------------------------
482:
483:
484: -- Standard check of p_commit.
485: IF FND_API.To_Boolean( p_commit ) THEN
486:
487: IF DOM_LOG.CHECK_LOG_LEVEL THEN
488: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;
489: END IF ;

Line 506: WHEN FND_API.G_EXC_ERROR THEN

502: END IF ;
503:
504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: -- Standard check of p_commit.
508: IF FND_API.To_Boolean( p_commit ) THEN
509:
510: IF DOM_LOG.CHECK_LOG_LEVEL THEN

Line 508: IF FND_API.To_Boolean( p_commit ) THEN

504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: -- Standard check of p_commit.
508: IF FND_API.To_Boolean( p_commit ) THEN
509:
510: IF DOM_LOG.CHECK_LOG_LEVEL THEN
511: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
512: END IF ;

Line 516: x_return_status := FND_API.G_RET_STS_ERROR ;

512: END IF ;
513: ROLLBACK TO l_api_name ;
514: END IF;
515:
516: x_return_status := FND_API.G_RET_STS_ERROR ;
517:
518: FND_MSG_PUB.Count_And_Get
519: ( p_count => x_msg_count
520: , p_data => x_msg_data

Line 527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

523: IF DOM_LOG.CHECK_LOG_LEVEL THEN
524: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
525: END IF ;
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF FND_API.To_Boolean( p_commit ) THEN
529:
530: IF DOM_LOG.CHECK_LOG_LEVEL THEN
531: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

Line 528: IF FND_API.To_Boolean( p_commit ) THEN

524: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
525: END IF ;
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF FND_API.To_Boolean( p_commit ) THEN
529:
530: IF DOM_LOG.CHECK_LOG_LEVEL THEN
531: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
532: END IF ;

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

532: END IF ;
533: ROLLBACK TO l_api_name ;
534: END IF;
535:
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
537:
538: FND_MSG_PUB.Count_And_Get
539: ( p_count => x_msg_count
540: , p_data => x_msg_data

Line 548: IF FND_API.To_Boolean( p_commit ) THEN

544: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;
545: END IF ;
546:
547: WHEN OTHERS THEN
548: IF FND_API.To_Boolean( p_commit ) THEN
549: IF DOM_LOG.CHECK_LOG_LEVEL THEN
550: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
551: END IF ;
552: ROLLBACK TO l_api_name ;

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

551: END IF ;
552: ROLLBACK TO l_api_name ;
553: END IF;
554:
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556:
557: FND_MSG_PUB.Count_And_Get
558: ( p_count => x_msg_count
559: , p_data => x_msg_data

Line 593: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --

589: -- We can put validation logic here
590: --
591: Procedure Abort_Doc_LC_Phase_WF
592: ( p_api_version IN NUMBER --
593: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
594: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
595: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
596: ,x_return_status OUT NOCOPY VARCHAR2 --
597: ,x_msg_count OUT NOCOPY NUMBER --

Line 594: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --

590: --
591: Procedure Abort_Doc_LC_Phase_WF
592: ( p_api_version IN NUMBER --
593: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
594: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
595: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
596: ,x_return_status OUT NOCOPY VARCHAR2 --
597: ,x_msg_count OUT NOCOPY NUMBER --
598: ,x_msg_data OUT NOCOPY VARCHAR2

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

591: Procedure Abort_Doc_LC_Phase_WF
592: ( p_api_version IN NUMBER --
593: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
594: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
595: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
596: ,x_return_status OUT NOCOPY VARCHAR2 --
597: ,x_msg_count OUT NOCOPY NUMBER --
598: ,x_msg_data OUT NOCOPY VARCHAR2
599: ,p_change_id IN NUMBER

Line 617: IF NOT FND_API.Compatible_API_Call( l_api_version

613: -- Standard Start of API savepoint
614: SAVEPOINT l_api_name;
615:
616: -- Standard call to check for call compatibility.
617: IF NOT FND_API.Compatible_API_Call( l_api_version
618: , p_api_version
619: , l_api_name
620: , G_PKG_NAME )
621: THEN

Line 622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

618: , p_api_version
619: , l_api_name
620: , G_PKG_NAME )
621: THEN
622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 626: IF FND_API.to_Boolean( p_init_msg_list ) THEN

622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list ) THEN
627: FND_MSG_PUB.initialize;
628: END IF ;
629:
630: -- Initialize API return status to success

Line 631: x_return_status := FND_API.G_RET_STS_SUCCESS;

627: FND_MSG_PUB.initialize;
628: END IF ;
629:
630: -- Initialize API return status to success
631: x_return_status := FND_API.G_RET_STS_SUCCESS;
632:
633:
634: IF ( DOM_LOG.CHECK_LOG_LEVEL) THEN
635: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'begin ' || l_api_name);

Line 663: IF FND_API.To_Boolean( p_commit ) THEN

659: END IF ;
660:
661:
662: -- Standard check of p_commit.
663: IF FND_API.To_Boolean( p_commit ) THEN
664:
665: IF DOM_LOG.CHECK_LOG_LEVEL THEN
666: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Do Commit.') ;
667: END IF ;

Line 684: WHEN FND_API.G_EXC_ERROR THEN

680: END IF ;
681:
682:
683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: -- Standard check of p_commit.
686: IF FND_API.To_Boolean( p_commit ) THEN
687: IF DOM_LOG.CHECK_LOG_LEVEL THEN
688: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;

Line 686: IF FND_API.To_Boolean( p_commit ) THEN

682:
683: EXCEPTION
684: WHEN FND_API.G_EXC_ERROR THEN
685: -- Standard check of p_commit.
686: IF FND_API.To_Boolean( p_commit ) THEN
687: IF DOM_LOG.CHECK_LOG_LEVEL THEN
688: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
689: END IF ;
690: ROLLBACK TO l_api_name ;

Line 693: x_return_status := FND_API.G_RET_STS_ERROR ;

689: END IF ;
690: ROLLBACK TO l_api_name ;
691: END IF;
692:
693: x_return_status := FND_API.G_RET_STS_ERROR ;
694:
695: FND_MSG_PUB.Count_And_Get
696: ( p_count => x_msg_count
697: , p_data => x_msg_data

Line 704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

700: IF DOM_LOG.CHECK_LOG_LEVEL THEN
701: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
702: END IF ;
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: IF FND_API.To_Boolean( p_commit ) THEN
706: IF DOM_LOG.CHECK_LOG_LEVEL THEN
707: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
708: END IF ;

Line 705: IF FND_API.To_Boolean( p_commit ) THEN

701: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'RollBack and Finish with Error.') ;
702: END IF ;
703:
704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: IF FND_API.To_Boolean( p_commit ) THEN
706: IF DOM_LOG.CHECK_LOG_LEVEL THEN
707: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
708: END IF ;
709: ROLLBACK TO l_api_name ;

Line 712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

708: END IF ;
709: ROLLBACK TO l_api_name ;
710: END IF;
711:
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713:
714: FND_MSG_PUB.Count_And_Get
715: ( p_count => x_msg_count
716: , p_data => x_msg_data

Line 724: IF FND_API.To_Boolean( p_commit ) THEN

720: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback and Finish with unxepcted error.') ;
721: END IF ;
722:
723: WHEN OTHERS THEN
724: IF FND_API.To_Boolean( p_commit ) THEN
725: IF DOM_LOG.CHECK_LOG_LEVEL THEN
726: DOM_LOG.LOG_STR(G_PKG_NAME,l_api_name, null,'Rollback . . .') ;
727: END IF ;
728: ROLLBACK TO l_api_name ;

Line 731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

727: END IF ;
728: ROLLBACK TO l_api_name ;
729: END IF;
730:
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732:
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count
735: , p_data => x_msg_data