DBA Data[Home] [Help]

APPS.ENG_DOCUMENT_UTIL dependencies on DOM_SECURITY_PUB

Line 931: Write_Debug('Calling DOM_SECURITY_PUB.Grant_Document_Role');

927: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id) );
928: Write_Debug('Role Id : ' || TO_CHAR(p_role_id) );
929: Write_Debug('API Caller : ' || p_api_caller);
930: Write_Debug('-----------------------------------------------------');
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 ;

Line 959: -- || ' DOM_SECURITY_PUB.Grant_Document_Role'

955: -- Comment out: somehow dynamic call does not work
956: -- I guess we should use DBMS_SQL to achieve this
957: --
958: -- l_pls_block := ' BEGIN '
959: -- || ' DOM_SECURITY_PUB.Grant_Document_Role'
960: -- || ' ( p_api_version => :1 '
961: -- || ' ,p_init_msg_list => :2 '
962: -- || ' ,p_commit => :3 '
963: -- || ' ,p_validation_level => :4 '

Line 1000: DOM_SECURITY_PUB.Grant_Document_Role

996:
997:
998: BEGIN
999:
1000: DOM_SECURITY_PUB.Grant_Document_Role
1001: ( p_api_version => p_api_version
1002: ,p_init_msg_list => p_init_msg_list
1003: ,p_commit => p_commit
1004: ,p_validation_level => p_validation_level

Line 1022: Write_Debug('Unexpected Exception DOM_SECURITY_PUB.Grant_Document_Role: ' || SQLERRM);

1018:
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: IF g_debug_flag THEN
1022: Write_Debug('Unexpected Exception DOM_SECURITY_PUB.Grant_Document_Role: ' || SQLERRM);
1023: END IF ;
1024:
1025: END ;
1026:

Line 1041: Write_Debug('After Calling DOM_SECURITY_PUB.Grant_Document_Role: ' || l_return_status);

1037: END IF ;
1038:
1039:
1040: IF g_debug_flag THEN
1041: Write_Debug('After Calling DOM_SECURITY_PUB.Grant_Document_Role: ' || l_return_status);
1042: END IF ;
1043:
1044: EXCEPTION
1045: WHEN PLSQL_COMPILE_ERROR THEN

Line 1064: ( p_pkg_name => 'DOM_SECURITY_PUB' ,

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',
1066: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
1067: );
1068:

Line 1126: Write_Debug('Calling DOM_SECURITY_PUB.Revoke_Document_Role');

1122: Write_Debug('Change Line Id : ' || TO_CHAR(p_change_line_id) );
1123: Write_Debug('Role Id : ' || TO_CHAR(p_role_id) );
1124: Write_Debug('API Caller : ' || p_api_caller);
1125: Write_Debug('-----------------------------------------------------');
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 ;

Line 1159: -- || ' DOM_SECURITY_PUB.Revoke_Document_Role'

1155: -- Comment out: somehow dynamic call does not work
1156: -- I guess we should use DBMS_SQL to achieve this
1157: --
1158: -- l_pls_block := ' BEGIN '
1159: -- || ' DOM_SECURITY_PUB.Revoke_Document_Role'
1160: -- || ' ( p_api_version => :1 '
1161: -- || ' ,p_init_msg_list => :2 '
1162: -- || ' ,p_commit => :3 '
1163: -- || ' ,p_validation_level => :4 '

Line 1198: DOM_SECURITY_PUB.Revoke_Document_Role

1194: */
1195:
1196: BEGIN
1197:
1198: DOM_SECURITY_PUB.Revoke_Document_Role
1199: ( p_api_version => p_api_version
1200: ,p_init_msg_list => p_init_msg_list
1201: ,p_commit => p_commit
1202: ,p_validation_level => p_validation_level

Line 1220: Write_Debug('Unexpected Exception DOM_SECURITY_PUB.Revoke_Document_Role: ' || SQLERRM);

1216:
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: IF g_debug_flag THEN
1220: Write_Debug('Unexpected Exception DOM_SECURITY_PUB.Revoke_Document_Role: ' || SQLERRM);
1221: END IF ;
1222:
1223: END ;
1224:

Line 1240: Write_Debug('After Calling DOM_SECURITY_PUB.Revoke_Document_Role: ' || l_return_status);

1236: END IF ;
1237:
1238:
1239: IF g_debug_flag THEN
1240: Write_Debug('After Calling DOM_SECURITY_PUB.Revoke_Document_Role: ' || l_return_status);
1241: END IF ;
1242:
1243:
1244:

Line 1266: ( p_pkg_name => 'DOM_SECURITY_PUB' ,

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',
1268: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
1269: );
1270:

Line 1332: Write_Debug('Calling DOM_SECURITY_PUB.Grant_Attachments_OCSRole');

1328: Write_Debug('PK5 Value : ' || p_pk5value);
1329: Write_Debug('OCS ROle : ' || p_ocs_role);
1330: Write_Debug('API Caller : ' || p_api_caller);
1331: Write_Debug('-----------------------------------------------------');
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 ;

Line 1347: -- || ' DOM_SECURITY_PUB.Grant_Attachments_OCSRole'

1343: -- Comment out: somehow dynamic call does not work
1344: -- I guess we should use DBMS_SQL to achieve this
1345: --
1346: -- l_pls_block := ' BEGIN '
1347: -- || ' DOM_SECURITY_PUB.Grant_Attachments_OCSRole'
1348: -- || ' ( p_api_version => :1 '
1349: -- || ' ,p_init_msg_list => :2 '
1350: -- || ' ,p_commit => :3 '
1351: -- || ' ,p_validation_level => :4 '

Line 1390: DOM_SECURITY_PUB.Grant_Attachments_OCSRole

1386:
1387: BEGIN
1388:
1389:
1390: DOM_SECURITY_PUB.Grant_Attachments_OCSRole
1391: ( p_api_version => p_api_version
1392: ,p_init_msg_list => p_init_msg_list
1393: ,p_commit => p_commit
1394: ,p_validation_level => p_validation_level

Line 1420: DOM_SECURITY_PUB.Grant_Attachment_Access

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
1419: loop
1420: DOM_SECURITY_PUB.Grant_Attachment_Access
1421: (
1422: p_api_version => p_api_version,
1423: p_attached_document_id => p_attachment_id_tbl(ind),
1424: p_source_media_id => p_source_media_id_tbl(ind),

Line 1460: Write_Debug('After Calling DOM_SECURITY_PUB.Grant_Attachments_OCSRole: ' || l_return_status);

1456: END IF ;
1457:
1458:
1459: IF g_debug_flag THEN
1460: Write_Debug('After Calling DOM_SECURITY_PUB.Grant_Attachments_OCSRole: ' || l_return_status);
1461: END IF ;
1462:
1463: EXCEPTION
1464: WHEN PLSQL_COMPILE_ERROR THEN

Line 1483: ( p_pkg_name => 'DOM_SECURITY_PUB' ,

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',
1485: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
1486: );
1487:

Line 1547: Write_Debug('Calling DOM_SECURITY_PUB.Revoke_Attachments_OCSRole');

1543: Write_Debug('PK5 Value : ' || p_pk5value);
1544: Write_Debug('API Caller : ' || p_api_caller);
1545: Write_Debug('OCS ROle : ' || p_ocs_role);
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:

Line 1565: -- || ' DOM_SECURITY_PUB.Revoke_Attachments_OCSRole'

1561: -- I guess we should use DBMS_SQL to achieve this
1562: --
1563: --
1564: -- l_pls_block := ' BEGIN '
1565: -- || ' DOM_SECURITY_PUB.Revoke_Attachments_OCSRole'
1566: -- || ' ( p_api_version => :1 '
1567: -- || ' ,p_init_msg_list => :2 '
1568: -- || ' ,p_commit => :3 '
1569: -- || ' ,p_validation_level => :4 '

Line 1607: DOM_SECURITY_PUB.Revoke_Attachments_OCSRole

1603:
1604: BEGIN
1605:
1606:
1607: DOM_SECURITY_PUB.Revoke_Attachments_OCSRole
1608: ( p_api_version => p_api_version
1609: ,p_init_msg_list => p_init_msg_list
1610: ,p_commit => p_commit
1611: ,p_validation_level => p_validation_level

Line 1650: Write_Debug('After Calling DOM_SECURITY_PUB.Revoke_Attachments_OCSRole: ' || l_return_status);

1646:
1647:
1648:
1649: IF g_debug_flag THEN
1650: Write_Debug('After Calling DOM_SECURITY_PUB.Revoke_Attachments_OCSRole: ' || l_return_status);
1651: END IF ;
1652:
1653:
1654: EXCEPTION

Line 1675: ( p_pkg_name => 'DOM_SECURITY_PUB' ,

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',
1677: p_error_text => Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240)
1678: );
1679: