147: FOR l_lock_aad IN c_lock_aads LOOP
148: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
149: l_lock_aad.locking_status_flag = 'Y') THEN
150:
151: xla_validations_pkg.get_product_rule_info
152: (p_application_id => p_application_id
153: ,p_amb_context_code => l_lock_aad.amb_context_code
154: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
155: ,p_product_rule_code => l_lock_aad.product_rule_code
156: ,p_application_name => l_application_name
157: ,p_product_rule_name => l_product_rule_name
158: ,p_product_rule_type => l_product_rule_type);
159:
160: xla_validations_pkg.get_event_class_info
161: (p_application_id => p_application_id
162: ,p_entity_code => l_lock_aad.entity_code
163: ,p_event_class_code => l_lock_aad.event_class_code
164: ,p_event_class_name => l_event_class_name);
162: ,p_entity_code => l_lock_aad.entity_code
163: ,p_event_class_code => l_lock_aad.event_class_code
164: ,p_event_class_name => l_event_class_name);
165:
166: xla_validations_pkg.get_event_type_info
167: (p_application_id => p_application_id
168: ,p_entity_code => l_lock_aad.entity_code
169: ,p_event_class_code => l_lock_aad.event_class_code
170: ,p_event_type_code => l_lock_aad.event_type_code
336: FOR l_lock_aad IN c_lock_aads LOOP
337: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
338: l_lock_aad.locking_status_flag = 'Y') THEN
339:
340: xla_validations_pkg.get_product_rule_info
341: (p_application_id => p_application_id
342: ,p_amb_context_code => l_lock_aad.amb_context_code
343: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
344: ,p_product_rule_code => l_lock_aad.product_rule_code
345: ,p_application_name => l_application_name
346: ,p_product_rule_name => l_product_rule_name
347: ,p_product_rule_type => l_product_rule_type);
348:
349: xla_validations_pkg.get_event_class_info
350: (p_application_id => p_application_id
351: ,p_entity_code => l_lock_aad.entity_code
352: ,p_event_class_code => l_lock_aad.event_class_code
353: ,p_event_class_name => l_event_class_name);
351: ,p_entity_code => l_lock_aad.entity_code
352: ,p_event_class_code => l_lock_aad.event_class_code
353: ,p_event_class_name => l_event_class_name);
354:
355: xla_validations_pkg.get_event_type_info
356: (p_application_id => p_application_id
357: ,p_entity_code => l_lock_aad.entity_code
358: ,p_event_class_code => l_lock_aad.event_class_code
359: ,p_event_type_code => l_lock_aad.event_type_code
560: FOR l_lock_aad IN c_lock_aads LOOP
561: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
562: l_lock_aad.locking_status_flag = 'Y') THEN
563:
564: xla_validations_pkg.get_product_rule_info
565: (p_application_id => p_application_id
566: ,p_amb_context_code => l_lock_aad.amb_context_code
567: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
568: ,p_product_rule_code => l_lock_aad.product_rule_code
569: ,p_application_name => l_application_name
570: ,p_product_rule_name => l_product_rule_name
571: ,p_product_rule_type => l_product_rule_type);
572:
573: xla_validations_pkg.get_event_class_info
574: (p_application_id => p_application_id
575: ,p_entity_code => l_lock_aad.entity_code
576: ,p_event_class_code => l_lock_aad.event_class_code
577: ,p_event_class_name => l_event_class_name);
575: ,p_entity_code => l_lock_aad.entity_code
576: ,p_event_class_code => l_lock_aad.event_class_code
577: ,p_event_class_name => l_event_class_name);
578:
579: xla_validations_pkg.get_event_type_info
580: (p_application_id => p_application_id
581: ,p_entity_code => l_lock_aad.entity_code
582: ,p_event_class_code => l_lock_aad.event_class_code
583: ,p_event_type_code => l_lock_aad.event_type_code
764: FOR l_lock_aad IN c_lock_aads LOOP
765: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
766: l_lock_aad.locking_status_flag = 'Y') THEN
767:
768: xla_validations_pkg.get_product_rule_info
769: (p_application_id => l_lock_aad.application_id
770: ,p_amb_context_code => l_lock_aad.amb_context_code
771: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
772: ,p_product_rule_code => l_lock_aad.product_rule_code
773: ,p_application_name => l_application_name
774: ,p_product_rule_name => l_product_rule_name
775: ,p_product_rule_type => l_product_rule_type);
776:
777: xla_validations_pkg.get_event_class_info
778: (p_application_id => l_lock_aad.application_id
779: ,p_entity_code => l_lock_aad.entity_code
780: ,p_event_class_code => l_lock_aad.event_class_code
781: ,p_event_class_name => l_event_class_name);
779: ,p_entity_code => l_lock_aad.entity_code
780: ,p_event_class_code => l_lock_aad.event_class_code
781: ,p_event_class_name => l_event_class_name);
782:
783: xla_validations_pkg.get_event_type_info
784: (p_application_id => l_lock_aad.application_id
785: ,p_entity_code => l_lock_aad.entity_code
786: ,p_event_class_code => l_lock_aad.event_class_code
787: ,p_event_type_code => l_lock_aad.event_type_code
950: FOR l_lock_aad IN c_lock_aads LOOP
951: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
952: l_lock_aad.locking_status_flag = 'Y') THEN
953:
954: xla_validations_pkg.get_product_rule_info
955: (p_application_id => p_application_id
956: ,p_amb_context_code => l_lock_aad.amb_context_code
957: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
958: ,p_product_rule_code => l_lock_aad.product_rule_code
959: ,p_application_name => l_application_name
960: ,p_product_rule_name => l_product_rule_name
961: ,p_product_rule_type => l_product_rule_type);
962:
963: xla_validations_pkg.get_event_class_info
964: (p_application_id => p_application_id
965: ,p_entity_code => l_lock_aad.entity_code
966: ,p_event_class_code => l_lock_aad.event_class_code
967: ,p_event_class_name => l_event_class_name);
965: ,p_entity_code => l_lock_aad.entity_code
966: ,p_event_class_code => l_lock_aad.event_class_code
967: ,p_event_class_name => l_event_class_name);
968:
969: xla_validations_pkg.get_event_type_info
970: (p_application_id => p_application_id
971: ,p_entity_code => l_lock_aad.entity_code
972: ,p_event_class_code => l_lock_aad.event_class_code
973: ,p_event_type_code => l_lock_aad.event_type_code
1176: FOR l_lock_aad IN c_lock_aads LOOP
1177: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1178: trace('inside loop',C_LEVEL_STATEMENT,l_log_module);
1179: END IF;
1180: xla_validations_pkg.get_product_rule_info
1181: (p_application_id => p_application_id
1182: ,p_amb_context_code => l_lock_aad.amb_context_code
1183: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
1184: ,p_product_rule_code => l_lock_aad.product_rule_code
1185: ,p_application_name => l_application_name
1186: ,p_product_rule_name => l_product_rule_name
1187: ,p_product_rule_type => l_product_rule_type);
1188:
1189: xla_validations_pkg.get_event_class_info
1190: (p_application_id => p_application_id
1191: ,p_entity_code => l_lock_aad.entity_code
1192: ,p_event_class_code => l_lock_aad.event_class_code
1193: ,p_event_class_name => l_event_class_name);
1191: ,p_entity_code => l_lock_aad.entity_code
1192: ,p_event_class_code => l_lock_aad.event_class_code
1193: ,p_event_class_name => l_event_class_name);
1194:
1195: xla_validations_pkg.get_event_type_info
1196: (p_application_id => p_application_id
1197: ,p_entity_code => l_lock_aad.entity_code
1198: ,p_event_class_code => l_lock_aad.event_class_code
1199: ,p_event_type_code => l_lock_aad.event_type_code
1291: FOR l_lock_aad IN c_lock_aads LOOP
1292: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
1293: l_lock_aad.locking_status_flag = 'Y') THEN
1294:
1295: xla_validations_pkg.get_product_rule_info
1296: (p_application_id => l_lock_aad.application_id
1297: ,p_amb_context_code => l_lock_aad.amb_context_code
1298: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
1299: ,p_product_rule_code => l_lock_aad.product_rule_code
1300: ,p_application_name => l_application_name
1301: ,p_product_rule_name => l_product_rule_name
1302: ,p_product_rule_type => l_product_rule_type);
1303:
1304: xla_validations_pkg.get_event_class_info
1305: (p_application_id => l_lock_aad.application_id
1306: ,p_entity_code => l_lock_aad.entity_code
1307: ,p_event_class_code => l_lock_aad.event_class_code
1308: ,p_event_class_name => l_event_class_name);
1306: ,p_entity_code => l_lock_aad.entity_code
1307: ,p_event_class_code => l_lock_aad.event_class_code
1308: ,p_event_class_name => l_event_class_name);
1309:
1310: xla_validations_pkg.get_event_type_info
1311: (p_application_id => l_lock_aad.application_id
1312: ,p_entity_code => l_lock_aad.entity_code
1313: ,p_event_class_code => l_lock_aad.event_class_code
1314: ,p_event_type_code => l_lock_aad.event_type_code
1439: FOR l_lock_aad IN c_lock_aads LOOP
1440: IF (l_lock_aad.validation_status_code NOT IN ('E', 'Y', 'N') OR
1441: l_lock_aad.locking_status_flag = 'Y') THEN
1442:
1443: xla_validations_pkg.get_product_rule_info
1444: (p_application_id => l_lock_aad.application_id
1445: ,p_amb_context_code => l_lock_aad.amb_context_code
1446: ,p_product_rule_type_code => l_lock_aad.product_rule_type_code
1447: ,p_product_rule_code => l_lock_aad.product_rule_code
1448: ,p_application_name => l_application_name
1449: ,p_product_rule_name => l_product_rule_name
1450: ,p_product_rule_type => l_product_rule_type);
1451:
1452: xla_validations_pkg.get_event_class_info
1453: (p_application_id => l_lock_aad.application_id
1454: ,p_entity_code => l_lock_aad.entity_code
1455: ,p_event_class_code => l_lock_aad.event_class_code
1456: ,p_event_class_name => l_event_class_name);
1454: ,p_entity_code => l_lock_aad.entity_code
1455: ,p_event_class_code => l_lock_aad.event_class_code
1456: ,p_event_class_name => l_event_class_name);
1457:
1458: xla_validations_pkg.get_event_type_info
1459: (p_application_id => l_lock_aad.application_id
1460: ,p_entity_code => l_lock_aad.entity_code
1461: ,p_event_class_code => l_lock_aad.event_class_code
1462: ,p_event_type_code => l_lock_aad.event_type_code