DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DEBUG

Line 1177: fnd_oam_debug.log(2, l_ctxt, 'ENTER');

1173: l_algo_weight NUMBER;
1174: l_object_id NUMBER;
1175: begin
1176:
1177: fnd_oam_debug.log(2, l_ctxt, 'ENTER');
1178:
1179: -- pset_id := 3022;
1180: -- OPEN pset_policy_c(pset_id);
1181:

Line 1182: fnd_oam_debug.log(1, l_ctxt, 'Obtaining Policy Set ID...');

1178:
1179: -- pset_id := 3022;
1180: -- OPEN pset_policy_c(pset_id);
1181:
1182: fnd_oam_debug.log(1, l_ctxt, 'Obtaining Policy Set ID...');
1183: l_pset_id := FND_OAM_DSCFG_API_PKG.GET_CURRENT_POLICYSET_ID;
1184:
1185: fnd_oam_debug.log(1, l_ctxt, 'Querying Policies for Policy Set ID:'||l_pset_id);
1186: OPEN pset_policy_c(l_pset_id);

Line 1185: fnd_oam_debug.log(1, l_ctxt, 'Querying Policies for Policy Set ID:'||l_pset_id);

1181:
1182: fnd_oam_debug.log(1, l_ctxt, 'Obtaining Policy Set ID...');
1183: l_pset_id := FND_OAM_DSCFG_API_PKG.GET_CURRENT_POLICYSET_ID;
1184:
1185: fnd_oam_debug.log(1, l_ctxt, 'Querying Policies for Policy Set ID:'||l_pset_id);
1186: OPEN pset_policy_c(l_pset_id);
1187:
1188: --loop over the policies of the policy set
1189: LOOP

Line 1192: fnd_oam_debug.log(1, l_ctxt, 'Processing Policy ID: '||policy_rec.policy_id);

1188: --loop over the policies of the policy set
1189: LOOP
1190: FETCH pset_policy_c INTO policy_rec;
1191: EXIT WHEN pset_policy_c%NOTFOUND;
1192: fnd_oam_debug.log(1, l_ctxt, 'Processing Policy ID: '||policy_rec.policy_id);
1193:
1194: --fetch the PII_ATTRIBUTEs of the policy
1195: OPEN policy_attri_c(policy_rec.policy_id);
1196:

Line 1202: fnd_oam_debug.log(1, l_ctxt, 'Processing Attribute Code: '||attri_rec.privacy_attribute_code);

1198: --for each PII_ATTRIBUTE element,
1199: --if there is no attribute for this policy, exit this loop
1200: FETCH policy_attri_c INTO attri_rec;
1201: EXIT WHEN policy_attri_c%NOTFOUND;
1202: fnd_oam_debug.log(1, l_ctxt, 'Processing Attribute Code: '||attri_rec.privacy_attribute_code);
1203:
1204: --algo_id resolution is in the following order, higher is more specific:
1205: -- 1)fnd_oam_ds_pii_extensions for col_priv
1206: -- 2)fnd_col_priv_attributes_b

Line 1213: fnd_oam_debug.log(1, l_ctxt, 'Fetching default algo for datatype: '||attri_rec.column_type);

1209: l_algo_id := NVL(attri_rec.ext_col_algo, NVL(attri_rec.col_algo, NVL(attri_rec.ext_attri_algo, attri_rec.attri_algo)));
1210:
1211: --if there is no algo id specified, use the default algo for this datatype
1212: IF l_algo_id IS NULL THEN
1213: fnd_oam_debug.log(1, l_ctxt, 'Fetching default algo for datatype: '||attri_rec.column_type);
1214: FND_OAM_DS_ALGOS_PKG.GET_DEFAULT_ALGO_FOR_DATATYPE(P_DATATYPE => attri_rec.column_type,
1215: X_ALGO_ID => l_algo_id);
1216: END IF;
1217:

Line 1219: fnd_oam_debug.log(1, l_ctxt, 'Resolving Algo ID: '||l_algo_id);

1215: X_ALGO_ID => l_algo_id);
1216: END IF;
1217:
1218: --convert the algo_id to the new_column_value sql
1219: fnd_oam_debug.log(1, l_ctxt, 'Resolving Algo ID: '||l_algo_id);
1220: FND_OAM_DS_ALGOS_PKG.RESOLVE_ALGO_ID(p_algo_id => l_algo_id,
1221: p_table_owner => attri_rec.owner,
1222: p_table_name => attri_rec.table_name,
1223: p_column_name => attri_rec.column_name,

Line 1240: fnd_oam_debug.log(1, l_ctxt, 'Querying Deletes/Truncates for Policy...');

1236: END LOOP;
1237: CLOSE policy_attri_c;
1238:
1239: -- query out the delete/truncate statements for the policy
1240: fnd_oam_debug.log(1, l_ctxt, 'Querying Deletes/Truncates for Policy...');
1241: OPEN policy_delete_c(policy_rec.policy_id);
1242:
1243: LOOP
1244: --for each DML_DELETE element

Line 1248: fnd_oam_debug.log(1, l_ctxt, 'Processing Delete ID: '||delete_rec.delete_id);

1244: --for each DML_DELETE element
1245: --if there is no deletes for this policy, exit this loop
1246: FETCH policy_delete_c INTO delete_rec;
1247: EXIT WHEN policy_delete_c%NOTFOUND;
1248: fnd_oam_debug.log(1, l_ctxt, 'Processing Delete ID: '||delete_rec.delete_id);
1249: --see if the delete's a truncate
1250: IF delete_rec.use_truncate_flag IS NOT NULL AND delete_rec.USE_TRUNCATE_FLAG = FND_API.G_TRUE THEN
1251: FND_OAM_DSCFG_API_PKG.ADD_DML_TRUNCATE_STMT(P_TABLE_OWNER => delete_rec.owner,
1252: P_TABLE_NAME => delete_rec.table_name,

Line 1270: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1266:
1267: END LOOP;
1268: CLOSE pset_policy_c;
1269:
1270: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1271: EXCEPTION
1272: WHEN NO_DATA_FOUND THEN
1273: ROLLBACK;
1274: fnd_oam_debug.log(6, l_ctxt, 'Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 1274: fnd_oam_debug.log(6, l_ctxt, 'Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

1270: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1271: EXCEPTION
1272: WHEN NO_DATA_FOUND THEN
1273: ROLLBACK;
1274: fnd_oam_debug.log(6, l_ctxt, 'Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1275: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1276: RAISE;
1277: WHEN OTHERS THEN
1278: ROLLBACK;

Line 1275: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1271: EXCEPTION
1272: WHEN NO_DATA_FOUND THEN
1273: ROLLBACK;
1274: fnd_oam_debug.log(6, l_ctxt, 'Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1275: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1276: RAISE;
1277: WHEN OTHERS THEN
1278: ROLLBACK;
1279: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

Line 1279: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');

1275: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1276: RAISE;
1277: WHEN OTHERS THEN
1278: ROLLBACK;
1279: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1280: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1281: RAISE;
1282: end;
1283:

Line 1280: fnd_oam_debug.log(2, l_ctxt, 'EXIT');

1276: RAISE;
1277: WHEN OTHERS THEN
1278: ROLLBACK;
1279: fnd_oam_debug.log(6, l_ctxt, 'Unexpected Error: (Code('||SQLCODE||'), Message("'||SQLERRM||'"))');
1280: fnd_oam_debug.log(2, l_ctxt, 'EXIT');
1281: RAISE;
1282: end;
1283:
1284: end fnd_oam_dscram;