DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PUB dependencies on FND_FILE

Line 470: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

466: CLOSE func_acess_count_c;
467:
468: IF l_func_access_count = 0 THEN
469: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
470: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
471: has_violation := 'Y';
472: return has_violation;
473: END IF;
474: END IF;

Line 495: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

491: -- in ME type: if user can access at least two entries of this constraint,
492: -- he violates this constraint
493: IF l_func_access_count >= 2 THEN
494: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
495: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
496: has_violation := 'Y';
497: return has_violation;
498: END IF;
499: ELSIF 'SET' = l_all_valid_constraints.type_code THEN

Line 519: -- FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - SET = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

515: -- in SET type: if user can access at least two distinct groups(set) of this constraint,
516: -- he violates this constraint
517: IF l_group_access_count >= 2 THEN
518: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
519: -- FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - SET = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
520: has_violation := 'Y';
521: return has_violation;
522: END IF;
523: ELSIF 'RESPALL' = l_all_valid_constraints.type_code THEN

Line 564: FND_FILE.put_line(fnd_file.log, '----fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

560: CLOSE resp_acess_count_c;
561:
562: IF l_resp_access_count = 0 THEN
563: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
564: FND_FILE.put_line(fnd_file.log, '----fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
565: has_violation := 'Y';
566: return has_violation;
567: END IF;
568: END IF;

Line 591: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

587: -- in ME type: if user can access at least two entries of this constraint,
588: -- he violates this constraint
589: IF l_resp_access_count >= 2 THEN
590: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
591: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
592: has_violation := 'Y';
593:
594: IF( l_log_stmt_level >= l_curr_log_level ) THEN
595: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.PreventFormCustomization','has_violation = '|| has_violation );

Line 619: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - SET = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

615: -- in SET type: if user can access at least two distinct groups(set) of this constraint,
616: -- he violates this constraint
617: IF l_resp_access_count >= 2 THEN
618: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
619: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - SET = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
620: has_violation := 'Y';
621: return has_violation;
622: END IF;
623: ELSE

Line 976: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

972: -- in ALL type: if user can access to all entries of this constraint,
973: -- he violates this constraint
974: IF l_func_access_count = l_constraint_entries_count THEN
975: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
976: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
977: l_violat_existing_resp := Get_Violat_Existing_Resp_List (
978: p_user_id => p_user_id,
979: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
980: p_constraint_type_code => l_all_valid_constraints.type_code);

Line 1036: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

1032: -- in ME type: if user can access at least two entries of this constraint,
1033: -- he violates this constraint
1034: IF l_func_access_count >= 2 THEN
1035: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
1036: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - ME = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
1037: l_violat_existing_resp := Get_Violat_Existing_Resp_List (
1038: p_user_id => p_user_id,
1039: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
1040: p_constraint_type_code => l_all_valid_constraints.type_code);

Line 1096: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - SET = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

1092: -- in SET type: if user can access at least two distinct groups(set) of this constraint,
1093: -- he violates this constraint
1094: IF l_group_access_count >= 2 THEN
1095: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
1096: FND_FILE.put_line(fnd_file.log,'------------ fail on constraint - SET = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
1097: l_violat_existing_resp := Get_Violat_Existing_Resp_List (
1098: p_user_id => p_user_id,
1099: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
1100: p_constraint_type_code => l_all_valid_constraints.type_code);

Line 1180: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

1176: CLOSE resp_acess_count_c;
1177:
1178: IF l_resp_access_count = 0 THEN
1179: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
1180: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
1181: l_violat_existing_resp := Get_Violat_Existing_Resp_List (
1182: p_user_id => p_user_id,
1183: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
1184: p_constraint_type_code => l_all_valid_constraints.type_code);

Line 1243: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

1239: -- in ME type: if user can access at least two entries of this constraint,
1240: -- he violates this constraint
1241: IF l_resp_access_count >= 2 THEN
1242: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
1243: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
1244: l_violat_existing_resp := Get_Violat_Existing_Resp_List (
1245: p_user_id => p_user_id,
1246: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
1247: p_constraint_type_code => l_all_valid_constraints.type_code);

Line 1315: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');

1311: -- in SET type: if user can access at least two distinct groups(set) of this constraint,
1312: -- he violates this constraint
1313: IF l_resp_access_count >= 2 THEN
1314: -- once he violates at least one constraint, break the loop and inform FALSE to the caller
1315: FND_FILE.put_line(fnd_file.log, '------------ fail on constraint - ALL = '||l_all_valid_constraints.constraint_rev_id ||' ---------------');
1316: l_violat_existing_resp := Get_Violat_Existing_Resp_List (
1317: p_user_id => p_user_id,
1318: p_constraint_rev_id => l_all_valid_constraints.constraint_rev_id,
1319: p_constraint_type_code => l_all_valid_constraints.type_code);