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

Line 120: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS)

116: ,x_return_status => l_log_return_status
117: ,x_error_mesg => l_errbuff
118: );
119:
120: IF (l_log_return_status <> FND_API.G_RET_STS_SUCCESS)
121: THEN
122: FND_FILE.put_line(FND_FILE.LOG, 'Unable to open error log file. Error => '||l_errbuff) ;
123: END IF;
124:

Line 217: OR FND_API.to_Boolean(p_debug_flag)

213: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
214: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
215:
216: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
217: OR FND_API.to_Boolean(p_debug_flag)
218: THEN
219:
220: ----------------------------------------------------------------------------------
221: -- Opens Error_Handler debug session, only if Debug session is not already open.

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

353: --
354: PROCEDURE Update_Approval_Status
355: (
356: p_api_version IN NUMBER --
357: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
361: ,p_output_dir IN VARCHAR2 := NULL

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

354: PROCEDURE Update_Approval_Status
355: (
356: p_api_version IN NUMBER --
357: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
361: ,p_output_dir IN VARCHAR2 := NULL
362: ,p_debug_filename IN VARCHAR2 := NULL

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

355: (
356: p_api_version IN NUMBER --
357: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
361: ,p_output_dir IN VARCHAR2 := NULL
362: ,p_debug_filename IN VARCHAR2 := NULL
363: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 360: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

356: p_api_version IN NUMBER --
357: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
358: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
359: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
360: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
361: ,p_output_dir IN VARCHAR2 := NULL
362: ,p_debug_filename IN VARCHAR2 := NULL
363: ,x_return_status OUT NOCOPY VARCHAR2 --
364: ,x_msg_count OUT NOCOPY NUMBER --

Line 395: l_return_status := FND_API.G_RET_STS_SUCCESS ;

391: Write_Debug('Calling DOM_LIFECYCLE_UTIL.UPDATE_APPROVAL_STATUS');
392: END IF ;
393:
394:
395: l_return_status := FND_API.G_RET_STS_SUCCESS ;
396:
397: -- We always pass p_commit FND_API.G_FALSE
398: -- DOM API should NOT commit or rollback
399: l_pls_block := ' BEGIN '

Line 397: -- We always pass p_commit FND_API.G_FALSE

393:
394:
395: l_return_status := FND_API.G_RET_STS_SUCCESS ;
396:
397: -- We always pass p_commit FND_API.G_FALSE
398: -- DOM API should NOT commit or rollback
399: l_pls_block := ' BEGIN '
400: || ' DOM_DOCUMENT_UTIL.UPDATE_APPROVAL_STATUS'
401: || ' ( p_api_version => :1 '

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS ;

432:
433: -- Until DOM team implemented the logic indeed
434: IF x_return_status IS NULL
435: THEN
436: x_return_status := FND_API.G_RET_STS_SUCCESS ;
437: END IF ;
438:
439: IF g_debug_flag THEN
440: Write_Debug('After Calling DOM_DOCUMENT_UTIL.UPDATE_APPROVAL_STATUS: ' || l_return_status);

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS ;

443:
444: EXCEPTION
445: WHEN PLSQL_COMPILE_ERROR THEN
446: -- Assuming DOM is not installed
447: x_return_status := FND_API.G_RET_STS_SUCCESS ;
448: x_msg_count := 0;
449: x_msg_data := NULL;
450:
451:

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

460: Write_Debug('Unexpected Exception Update_Approval_Status: ' || SQLERRM);
461: END IF ;
462:
463:
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
465:
466: FND_MSG_PUB.Add_Exc_Msg
467: ( p_pkg_name => 'DOM_DOCUMENT_UTIL' ,
468: p_procedure_name => 'UPDATE_APPROVAL_STATUS',

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

484: --
485: PROCEDURE Change_Doc_LC_Phase
486: (
487: p_api_version IN NUMBER --
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
492: ,p_output_dir IN VARCHAR2 := NULL

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

485: PROCEDURE Change_Doc_LC_Phase
486: (
487: p_api_version IN NUMBER --
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
492: ,p_output_dir IN VARCHAR2 := NULL
493: ,p_debug_filename IN VARCHAR2 := NULL

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

486: (
487: p_api_version IN NUMBER --
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
492: ,p_output_dir IN VARCHAR2 := NULL
493: ,p_debug_filename IN VARCHAR2 := NULL
494: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 491: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

487: p_api_version IN NUMBER --
488: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
489: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
490: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
491: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
492: ,p_output_dir IN VARCHAR2 := NULL
493: ,p_debug_filename IN VARCHAR2 := NULL
494: ,x_return_status OUT NOCOPY VARCHAR2 --
495: ,x_msg_count OUT NOCOPY NUMBER --

Line 527: l_return_status := FND_API.G_RET_STS_SUCCESS ;

523: Write_Debug('-----------------------------------------------------');
524: Write_Debug('Calling DOM_DOCUMENT_UTIL.CHANGE_DOC_LC_PHASE');
525: END IF ;
526:
527: l_return_status := FND_API.G_RET_STS_SUCCESS ;
528:
529:
530: -- We always pass p_commit FND_API.G_FALSE
531: -- DOM API should NOT commit or rollback

Line 530: -- We always pass p_commit FND_API.G_FALSE

526:
527: l_return_status := FND_API.G_RET_STS_SUCCESS ;
528:
529:
530: -- We always pass p_commit FND_API.G_FALSE
531: -- DOM API should NOT commit or rollback
532: l_pls_block := ' BEGIN '
533: || ' DOM_DOCUMENT_UTIL.CHANGE_DOC_LC_PHASE'
534: || ' ( p_api_version => :1 '

Line 570: x_return_status := FND_API.G_RET_STS_SUCCESS ;

566:
567: -- Until DOM team implemented the logic indeed
568: IF x_return_status IS NULL
569: THEN
570: x_return_status := FND_API.G_RET_STS_SUCCESS ;
571: END IF ;
572:
573:
574: IF g_debug_flag THEN

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS ;

578:
579: EXCEPTION
580: WHEN PLSQL_COMPILE_ERROR THEN
581: -- Assuming DOM is not installed
582: x_return_status := FND_API.G_RET_STS_SUCCESS ;
583: x_msg_count := 0;
584: x_msg_data := NULL;
585:
586: IF g_debug_flag THEN

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

594: IF g_debug_flag THEN
595: Write_Debug('Unexpected Exception Change_Doc_LC_Phase: ' || SQLERRM);
596: END IF ;
597:
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
599:
600: FND_MSG_PUB.Add_Exc_Msg
601: ( p_pkg_name => 'DOM_DOCUMENT_UTIL' ,
602: p_procedure_name => 'CHANGE_DOC_LC_PHASE',

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

619: --
620: PROCEDURE Start_Doc_LC_Phase_WF
621: (
622: p_api_version IN NUMBER --
623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
627: ,p_output_dir IN VARCHAR2 := NULL

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

620: PROCEDURE Start_Doc_LC_Phase_WF
621: (
622: p_api_version IN NUMBER --
623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
627: ,p_output_dir IN VARCHAR2 := NULL
628: ,p_debug_filename IN VARCHAR2 := NULL

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

621: (
622: p_api_version IN NUMBER --
623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
627: ,p_output_dir IN VARCHAR2 := NULL
628: ,p_debug_filename IN VARCHAR2 := NULL
629: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 626: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

622: p_api_version IN NUMBER --
623: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
624: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
625: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
626: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
627: ,p_output_dir IN VARCHAR2 := NULL
628: ,p_debug_filename IN VARCHAR2 := NULL
629: ,x_return_status OUT NOCOPY VARCHAR2 --
630: ,x_msg_count OUT NOCOPY NUMBER --

Line 662: l_return_status := FND_API.G_RET_STS_SUCCESS ;

658: Write_Debug('-----------------------------------------------------');
659: Write_Debug('Calling DOM_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF');
660: END IF ;
661:
662: l_return_status := FND_API.G_RET_STS_SUCCESS ;
663:
664:
665: -- We always pass p_commit FND_API.G_FALSE
666: -- DOM API should NOT commit or rollback

Line 665: -- We always pass p_commit FND_API.G_FALSE

661:
662: l_return_status := FND_API.G_RET_STS_SUCCESS ;
663:
664:
665: -- We always pass p_commit FND_API.G_FALSE
666: -- DOM API should NOT commit or rollback
667: l_pls_block := ' BEGIN '
668: || ' DOM_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF'
669: || ' ( p_api_version => :1 '

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS ;

701:
702: -- Until DOM team implemented the logic indeed
703: IF x_return_status IS NULL
704: THEN
705: x_return_status := FND_API.G_RET_STS_SUCCESS ;
706: END IF ;
707:
708:
709: IF g_debug_flag THEN

Line 717: x_return_status := FND_API.G_RET_STS_SUCCESS ;

713:
714: EXCEPTION
715: WHEN PLSQL_COMPILE_ERROR THEN
716: -- Assuming DOM is not installed
717: x_return_status := FND_API.G_RET_STS_SUCCESS ;
718: x_msg_count := 0;
719: x_msg_data := NULL;
720:
721: IF g_debug_flag THEN

Line 733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

729: IF g_debug_flag THEN
730: Write_Debug('Unexpected Exception Start_Doc_LC_Phase_WF: ' || SQLERRM);
731: END IF ;
732:
733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
734:
735: FND_MSG_PUB.Add_Exc_Msg
736: ( p_pkg_name => 'DOM_DOCUMENT_UTIL' ,
737: p_procedure_name => 'Start_Doc_LC_Phase_WF',

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

753: --
754: PROCEDURE Abort_Doc_LC_Phase_WF
755: (
756: p_api_version IN NUMBER --
757: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
758: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
759: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
760: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
761: ,p_output_dir IN VARCHAR2 := NULL

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

754: PROCEDURE Abort_Doc_LC_Phase_WF
755: (
756: p_api_version IN NUMBER --
757: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
758: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
759: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
760: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
761: ,p_output_dir IN VARCHAR2 := NULL
762: ,p_debug_filename IN VARCHAR2 := NULL

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

755: (
756: p_api_version IN NUMBER --
757: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
758: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
759: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
760: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
761: ,p_output_dir IN VARCHAR2 := NULL
762: ,p_debug_filename IN VARCHAR2 := NULL
763: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 760: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

756: p_api_version IN NUMBER --
757: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
758: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
759: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
760: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
761: ,p_output_dir IN VARCHAR2 := NULL
762: ,p_debug_filename IN VARCHAR2 := NULL
763: ,x_return_status OUT NOCOPY VARCHAR2 --
764: ,x_msg_count OUT NOCOPY NUMBER --

Line 796: l_return_status := FND_API.G_RET_STS_SUCCESS ;

792: Write_Debug('-----------------------------------------------------');
793: Write_Debug('Calling DOM_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF');
794: END IF ;
795:
796: l_return_status := FND_API.G_RET_STS_SUCCESS ;
797:
798:
799: -- We always pass p_commit FND_API.G_FALSE
800: -- DOM API should NOT commit or rollback

Line 799: -- We always pass p_commit FND_API.G_FALSE

795:
796: l_return_status := FND_API.G_RET_STS_SUCCESS ;
797:
798:
799: -- We always pass p_commit FND_API.G_FALSE
800: -- DOM API should NOT commit or rollback
801: l_pls_block := ' BEGIN '
802: || ' DOM_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF'
803: || ' ( p_api_version => :1 '

Line 839: x_return_status := FND_API.G_RET_STS_SUCCESS ;

835:
836: -- Until DOM team implemented the logic indeed
837: IF x_return_status IS NULL
838: THEN
839: x_return_status := FND_API.G_RET_STS_SUCCESS ;
840: END IF ;
841:
842: IF g_debug_flag THEN
843: Write_Debug('After Calling DOM_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF: ' || l_return_status);

Line 850: x_return_status := FND_API.G_RET_STS_SUCCESS ;

846:
847: EXCEPTION
848: WHEN PLSQL_COMPILE_ERROR THEN
849: -- Assuming DOM is not installed
850: x_return_status := FND_API.G_RET_STS_SUCCESS ;
851: x_msg_count := 0;
852: x_msg_data := NULL;
853:
854: IF g_debug_flag THEN

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

862: IF g_debug_flag THEN
863: Write_Debug('Unexpected Exception Abort_Doc_LC_Phase_WF: ' || SQLERRM);
864: END IF ;
865:
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
867:
868: FND_MSG_PUB.Add_Exc_Msg
869: ( p_pkg_name => 'DOM_DOCUMENT_UTIL' ,
870: p_procedure_name => 'CHANGE_DOC_LC_PHASE',

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

885: --
886: PROCEDURE Grant_Document_Role
887: (
888: p_api_version IN NUMBER --
889: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
890: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
891: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
892: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
893: ,p_output_dir IN VARCHAR2 := NULL

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

886: PROCEDURE Grant_Document_Role
887: (
888: p_api_version IN NUMBER --
889: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
890: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
891: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
892: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
893: ,p_output_dir IN VARCHAR2 := NULL
894: ,p_debug_filename IN VARCHAR2 := NULL

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

887: (
888: p_api_version IN NUMBER --
889: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
890: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
891: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
892: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
893: ,p_output_dir IN VARCHAR2 := NULL
894: ,p_debug_filename IN VARCHAR2 := NULL
895: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 892: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

888: p_api_version IN NUMBER --
889: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
890: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
891: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
892: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
893: ,p_output_dir IN VARCHAR2 := NULL
894: ,p_debug_filename IN VARCHAR2 := NULL
895: ,x_return_status OUT NOCOPY VARCHAR2 --
896: ,x_msg_count OUT NOCOPY NUMBER --

Line 935: l_return_status := FND_API.G_RET_STS_SUCCESS ;

931: Write_Debug('Calling DOM_SECURITY_PUB.Grant_Document_Role');
932: END IF ;
933:
934:
935: l_return_status := FND_API.G_RET_STS_SUCCESS ;
936:
937: l_change_line_id := p_change_line_id ;
938:
939: IF l_change_line_id <= 0 THEN

Line 950: -- We always pass p_commit FND_API.G_FALSE

946: Write_Debug('Param: Change Line Id : ' || TO_CHAR(l_change_line_id) );
947: END IF ;
948:
949:
950: -- We always pass p_commit FND_API.G_FALSE
951: -- DOM API should NOT commit or rollback
952:
953: /*
954: --

Line 1036: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1032:
1033: -- Until DOM team implemented the logic indeed
1034: IF x_return_status IS NULL
1035: THEN
1036: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1037: END IF ;
1038:
1039:
1040: IF g_debug_flag THEN

Line 1047: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1043:
1044: EXCEPTION
1045: WHEN PLSQL_COMPILE_ERROR THEN
1046: -- Assuming DOM is not installed
1047: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1048: x_msg_count := 0;
1049: x_msg_data := NULL;
1050:
1051: IF g_debug_flag THEN

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1057: IF g_debug_flag THEN
1058: Write_Debug('Unexpected Exception Grant_Document_Role: ' || SQLERRM);
1059: END IF ;
1060:
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062:
1063: FND_MSG_PUB.Add_Exc_Msg
1064: ( p_pkg_name => 'DOM_SECURITY_PUB' ,
1065: p_procedure_name => 'Grant_Document_Role',

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

1081: --
1082: PROCEDURE Revoke_Document_Role
1083: (
1084: p_api_version IN NUMBER --
1085: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1086: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1088: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1089: ,p_output_dir IN VARCHAR2 := NULL

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

1082: PROCEDURE Revoke_Document_Role
1083: (
1084: p_api_version IN NUMBER --
1085: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1086: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1088: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1089: ,p_output_dir IN VARCHAR2 := NULL
1090: ,p_debug_filename IN VARCHAR2 := NULL

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

1083: (
1084: p_api_version IN NUMBER --
1085: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1086: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1088: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1089: ,p_output_dir IN VARCHAR2 := NULL
1090: ,p_debug_filename IN VARCHAR2 := NULL
1091: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 1088: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

1084: p_api_version IN NUMBER --
1085: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1086: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1087: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1088: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1089: ,p_output_dir IN VARCHAR2 := NULL
1090: ,p_debug_filename IN VARCHAR2 := NULL
1091: ,x_return_status OUT NOCOPY VARCHAR2 --
1092: ,x_msg_count OUT NOCOPY NUMBER --

Line 1130: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1126: Write_Debug('Calling DOM_SECURITY_PUB.Revoke_Document_Role');
1127: END IF ;
1128:
1129:
1130: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1131:
1132: l_change_line_id := p_change_line_id ;
1133:
1134: IF l_change_line_id <= 0 THEN

Line 1147: -- We always pass p_commit FND_API.G_FALSE

1143: END IF ;
1144:
1145:
1146:
1147: -- We always pass p_commit FND_API.G_FALSE
1148: -- DOM API should NOT commit or rollback
1149: -- We always pass p_commit FND_API.G_FALSE
1150: -- DOM API should NOT commit or rollback
1151: -- No need to pass p_role_id

Line 1149: -- We always pass p_commit FND_API.G_FALSE

1145:
1146:
1147: -- We always pass p_commit FND_API.G_FALSE
1148: -- DOM API should NOT commit or rollback
1149: -- We always pass p_commit FND_API.G_FALSE
1150: -- DOM API should NOT commit or rollback
1151: -- No need to pass p_role_id
1152:
1153: /*

Line 1235: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1231:
1232: -- Until DOM team implemented the logic indeed
1233: IF x_return_status IS NULL
1234: THEN
1235: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1236: END IF ;
1237:
1238:
1239: IF g_debug_flag THEN

Line 1248: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1244:
1245: EXCEPTION
1246: WHEN PLSQL_COMPILE_ERROR THEN
1247: -- Assuming DOM is not installed
1248: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1249: x_msg_count := 0;
1250: x_msg_data := NULL;
1251:
1252: IF g_debug_flag THEN

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1259: Write_Debug('Unexpected Exception Revoke_Document_Role: ' || SQLERRM);
1260: END IF ;
1261:
1262:
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264:
1265: FND_MSG_PUB.Add_Exc_Msg
1266: ( p_pkg_name => 'DOM_SECURITY_PUB' ,
1267: p_procedure_name => 'Revoke_Document_Role',

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

1281: --
1282: PROCEDURE Grant_Attachments_OCSRole
1283: (
1284: p_api_version IN NUMBER --
1285: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1286: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1287: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1288: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1289: ,p_output_dir IN VARCHAR2 := NULL

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

1282: PROCEDURE Grant_Attachments_OCSRole
1283: (
1284: p_api_version IN NUMBER --
1285: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1286: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1287: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1288: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1289: ,p_output_dir IN VARCHAR2 := NULL
1290: ,p_debug_filename IN VARCHAR2 := NULL

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

1283: (
1284: p_api_version IN NUMBER --
1285: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1286: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1287: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1288: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1289: ,p_output_dir IN VARCHAR2 := NULL
1290: ,p_debug_filename IN VARCHAR2 := NULL
1291: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 1288: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

1284: p_api_version IN NUMBER --
1285: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1286: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1287: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1288: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1289: ,p_output_dir IN VARCHAR2 := NULL
1290: ,p_debug_filename IN VARCHAR2 := NULL
1291: ,x_return_status OUT NOCOPY VARCHAR2 --
1292: ,x_msg_count OUT NOCOPY NUMBER --

Line 1336: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1332: Write_Debug('Calling DOM_SECURITY_PUB.Grant_Attachments_OCSRole');
1333: END IF ;
1334:
1335:
1336: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1337:
1338: -- We always pass p_commit FND_API.G_FALSE
1339: -- DOM API should NOT commit or rollback
1340:

Line 1338: -- We always pass p_commit FND_API.G_FALSE

1334:
1335:
1336: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1337:
1338: -- We always pass p_commit FND_API.G_FALSE
1339: -- DOM API should NOT commit or rollback
1340:
1341: /*
1342: --

Line 1411: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1407: );
1408:
1409: IF x_return_status IS NULL
1410: THEN
1411: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1412: END IF ;
1413:
1414: if x_return_status = FND_API.G_RET_STS_SUCCESS
1415: AND p_source_media_id_tbl is not null and p_source_media_id_tbl.count > 0

Line 1414: if x_return_status = FND_API.G_RET_STS_SUCCESS

1410: THEN
1411: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1412: END IF ;
1413:
1414: if x_return_status = FND_API.G_RET_STS_SUCCESS
1415: AND p_source_media_id_tbl is not null and p_source_media_id_tbl.count > 0
1416: AND p_repository_id_tbl is not null and p_repository_id_tbl.count>0
1417: then
1418: for ind in p_source_media_id_tbl.first .. p_source_media_id_tbl.last

Line 1455: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1451:
1452: -- Until DOM team implemented the logic indeed
1453: IF x_return_status IS NULL
1454: THEN
1455: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1456: END IF ;
1457:
1458:
1459: IF g_debug_flag THEN

Line 1466: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1462:
1463: EXCEPTION
1464: WHEN PLSQL_COMPILE_ERROR THEN
1465: -- Assuming DOM is not installed
1466: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1467: x_msg_count := 0;
1468: x_msg_data := NULL;
1469:
1470:

Line 1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1476: IF g_debug_flag THEN
1477: Write_Debug('Unexpected Exception Grant_Attachments_OCSRole: ' || SQLERRM);
1478: END IF ;
1479:
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1481:
1482: FND_MSG_PUB.Add_Exc_Msg
1483: ( p_pkg_name => 'DOM_SECURITY_PUB' ,
1484: p_procedure_name => 'Grant_Attachments_OCSRole',

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

1500: --
1501: PROCEDURE Revoke_Attachments_OCSRole
1502: (
1503: p_api_version IN NUMBER --
1504: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1505: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1506: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1507: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1508: ,p_output_dir IN VARCHAR2 := NULL

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

1501: PROCEDURE Revoke_Attachments_OCSRole
1502: (
1503: p_api_version IN NUMBER --
1504: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1505: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1506: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1507: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1508: ,p_output_dir IN VARCHAR2 := NULL
1509: ,p_debug_filename IN VARCHAR2 := NULL

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

1502: (
1503: p_api_version IN NUMBER --
1504: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1505: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1506: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1507: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1508: ,p_output_dir IN VARCHAR2 := NULL
1509: ,p_debug_filename IN VARCHAR2 := NULL
1510: ,x_return_status OUT NOCOPY VARCHAR2 --

Line 1507: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --

1503: p_api_version IN NUMBER --
1504: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
1505: ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
1506: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1507: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
1508: ,p_output_dir IN VARCHAR2 := NULL
1509: ,p_debug_filename IN VARCHAR2 := NULL
1510: ,x_return_status OUT NOCOPY VARCHAR2 --
1511: ,x_msg_count OUT NOCOPY NUMBER --

Line 1550: l_return_status := FND_API.G_RET_STS_SUCCESS ;

1546: Write_Debug('-----------------------------------------------------');
1547: Write_Debug('Calling DOM_SECURITY_PUB.Revoke_Attachments_OCSRole');
1548: END IF ;
1549:
1550: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1551:
1552:
1553:
1554: -- We always pass p_commit FND_API.G_FALSE

Line 1554: -- We always pass p_commit FND_API.G_FALSE

1550: l_return_status := FND_API.G_RET_STS_SUCCESS ;
1551:
1552:
1553:
1554: -- We always pass p_commit FND_API.G_FALSE
1555: -- DOM API should NOT commit or rollback
1556: -- No need to pass p_ocs_role
1557:
1558: /*

Line 1644: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1640:
1641: -- Until DOM team implemented the logic indeed
1642: IF x_return_status IS NULL
1643: THEN
1644: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1645: END IF ;
1646:
1647:
1648:

Line 1657: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1653:
1654: EXCEPTION
1655: WHEN PLSQL_COMPILE_ERROR THEN
1656: -- Assuming DOM is not installed
1657: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1658: x_msg_count := 0;
1659: x_msg_data := NULL;
1660:
1661:

Line 1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1668: IF g_debug_flag THEN
1669: Write_Debug('Unexpected Exception Grant_Attachments_OCSRole: ' || SQLERRM);
1670: END IF ;
1671:
1672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1673:
1674: FND_MSG_PUB.Add_Exc_Msg
1675: ( p_pkg_name => 'DOM_SECURITY_PUB' ,
1676: p_procedure_name => 'Revoke_Attachments_OCSRole',