DBA Data[Home] [Help]

APPS.ZX_SIM_CONDITIONS_PKG dependencies on FND_LOG

Line 41: g_level_statement := FND_LOG.LEVEL_STATEMENT;

37: p_application_id IN NUMBER,
38: p_return_status OUT NOCOPY VARCHAR2,
39: p_error_buffer OUT NOCOPY VARCHAR2) AS
40: BEGIN
41: g_level_statement := FND_LOG.LEVEL_STATEMENT;
42: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
43:
44: IF (g_level_statement >= g_current_runtime_level ) THEN
45: FND_LOG.STRING(g_level_statement,

Line 42: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

38: p_return_status OUT NOCOPY VARCHAR2,
39: p_error_buffer OUT NOCOPY VARCHAR2) AS
40: BEGIN
41: g_level_statement := FND_LOG.LEVEL_STATEMENT;
42: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
43:
44: IF (g_level_statement >= g_current_runtime_level ) THEN
45: FND_LOG.STRING(g_level_statement,
46: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules.BEGIN',

Line 45: FND_LOG.STRING(g_level_statement,

41: g_level_statement := FND_LOG.LEVEL_STATEMENT;
42: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
43:
44: IF (g_level_statement >= g_current_runtime_level ) THEN
45: FND_LOG.STRING(g_level_statement,
46: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules.BEGIN',
47: 'ZX_SIM_CONDITIONS_PKG: create_from_existing_rules(+)');
48:
49: FND_LOG.STRING(g_level_statement,

Line 49: FND_LOG.STRING(g_level_statement,

45: FND_LOG.STRING(g_level_statement,
46: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules.BEGIN',
47: 'ZX_SIM_CONDITIONS_PKG: create_from_existing_rules(+)');
48:
49: FND_LOG.STRING(g_level_statement,
50: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
51: 'Simulate Rules');
52: END IF;
53:

Line 105: FND_LOG.STRING(g_level_statement,

101: 'DET_TAX_STATUS',
102: 'DET_TAX_RATE');
103:
104: IF (g_level_statement >= g_current_runtime_level ) THEN
105: FND_LOG.STRING(g_level_statement,
106: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
107: 'Simulate Translation of Rules');
108: END IF;
109:

Line 134: FND_LOG.STRING(g_level_statement,

130: WHERE tax_rule_id IN (select sim_tax_rule_id
131: from zx_sim_rules_b);
132:
133: IF (g_level_statement >= g_current_runtime_level ) THEN
134: FND_LOG.STRING(g_level_statement,
135: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
136: 'Simulate Process Results');
137: END IF;
138:

Line 173: FND_LOG.STRING(g_level_statement,

169: WHERE tax_rule_id IN (select sim_tax_rule_id
170: from zx_sim_rules_b);
171:
172: IF (g_level_statement >= g_current_runtime_level ) THEN
173: FND_LOG.STRING(g_level_statement,
174: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
175: 'Simulate Conditions');
176: END IF;
177:

Line 225: FND_LOG.STRING(g_level_statement,

221: from zx_sim_process_results
222: group by condition_group_code);
223:
224: IF (g_level_statement >= g_current_runtime_level ) THEN
225: FND_LOG.STRING(g_level_statement,
226: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules.END',
227: 'ZX_SIM_CONDITIONS_PKG: create_from_existing_rules(-)');
228: END IF;
229:

Line 240: FND_LOG.STRING(g_level_unexpected,

236: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
237: FND_MSG_PUB.Add;
238:
239: IF (g_level_unexpected >= g_current_runtime_level ) THEN
240: FND_LOG.STRING(g_level_unexpected,
241: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
242: p_error_buffer);
243: END IF;
244:

Line 298: g_level_statement := FND_LOG.LEVEL_STATEMENT;

294: l_msg_count NUMBER;
295: j NUMBER;
296:
297: BEGIN
298: g_level_statement := FND_LOG.LEVEL_STATEMENT;
299: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
301:
302: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 299: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

295: j NUMBER;
296:
297: BEGIN
298: g_level_statement := FND_LOG.LEVEL_STATEMENT;
299: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
301:
302: IF (g_level_statement >= g_current_runtime_level ) THEN
303: FND_LOG.STRING(g_level_statement,

Line 300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

296:
297: BEGIN
298: g_level_statement := FND_LOG.LEVEL_STATEMENT;
299: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
301:
302: IF (g_level_statement >= g_current_runtime_level ) THEN
303: FND_LOG.STRING(g_level_statement,
304: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions.BEGIN',

Line 303: FND_LOG.STRING(g_level_statement,

299: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
300: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
301:
302: IF (g_level_statement >= g_current_runtime_level ) THEN
303: FND_LOG.STRING(g_level_statement,
304: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions.BEGIN',
305: 'ZX_SIM_CONDITIONS_PKG: create_sim_conditions(+)');
306: END IF;
307:

Line 323: FND_LOG.STRING(g_level_statement,

319: fetch c_sim_cond into l_cond_cnt;
320: close c_sim_cond;
321: If nvl(l_cond_cnt,0) > 0 then
322: IF (g_level_statement >= g_current_runtime_level ) THEN
323: FND_LOG.STRING(g_level_statement,
324: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',
325: 'Conditions are already simulated');
326: END IF;
327:

Line 357: FND_LOG.STRING(g_level_statement,

353:
354: If pr_detfactor_class_tab(i) = 'TRX_INPUT_FACTOR' Then
355:
356: IF (g_level_statement >= g_current_runtime_level ) THEN
357: FND_LOG.STRING(g_level_statement,
358: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',
359: 'Fetching and Assigning Values for Transaction Input Factors');
360: END IF;
361:

Line 386: FND_LOG.STRING(g_level_statement,

382: End If;
383: End Loop;
384:
385: IF (g_level_statement >= g_current_runtime_level ) THEN
386: FND_LOG.STRING(g_level_statement,
387: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',
388: 'Insert All Simulated Conditions containing derived values');
389: END IF;
390:

Line 457: FND_LOG.STRING(g_level_statement,

453: End Loop; -- Loop for Trx Lines
454: End Loop; -- Loop for Trx Header
455:
456: IF (g_level_statement >= g_current_runtime_level ) THEN
457: FND_LOG.STRING(g_level_statement,
458: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions.END',
459: 'ZX_SIM_CONDITIONS_PKG: create_sim_conditions(-)');
460: END IF;
461:

Line 473: FND_LOG.STRING(g_level_unexpected,

469: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
470: FND_MSG_PUB.Add;
471:
472: IF (g_level_unexpected >= g_current_runtime_level ) THEN
473: FND_LOG.STRING(g_level_unexpected,
474: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',
475: p_error_buffer);
476: END IF;
477:

Line 497: g_level_statement := FND_LOG.LEVEL_STATEMENT;

493: l_rule_id NUMBER;
494: l_cg_id NUMBER;
495:
496: BEGIN
497: g_level_statement := FND_LOG.LEVEL_STATEMENT;
498: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
499: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
500:
501: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 498: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

494: l_cg_id NUMBER;
495:
496: BEGIN
497: g_level_statement := FND_LOG.LEVEL_STATEMENT;
498: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
499: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
500:
501: IF (g_level_statement >= g_current_runtime_level ) THEN
502: FND_LOG.STRING(g_level_statement,

Line 499: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

495:
496: BEGIN
497: g_level_statement := FND_LOG.LEVEL_STATEMENT;
498: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
499: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
500:
501: IF (g_level_statement >= g_current_runtime_level ) THEN
502: FND_LOG.STRING(g_level_statement,
503: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules.BEGIN',

Line 502: FND_LOG.STRING(g_level_statement,

498: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
499: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
500:
501: IF (g_level_statement >= g_current_runtime_level ) THEN
502: FND_LOG.STRING(g_level_statement,
503: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules.BEGIN',
504: 'ZX_SIM_CONDITIONS_PKG: create_sim_rules(+)');
505: END IF;
506:

Line 510: FND_LOG.STRING(g_level_statement,

506:
507: p_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: IF (g_level_statement >= g_current_runtime_level ) THEN
510: FND_LOG.STRING(g_level_statement,
511: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
512: 'Delete any existing Simulated Rules, Process Results and Conditions');
513: END IF;
514: DELETE zx_sim_rules_b;

Line 520: FND_LOG.STRING(g_level_statement,

516: DELETE zx_sim_process_results;
517: DELETE zx_sim_rule_conditions;
518:
519: IF (g_level_statement >= g_current_runtime_level ) THEN
520: FND_LOG.STRING(g_level_statement,
521: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
522: 'Simulate Rules, Process Results and Conditions from existing Setup');
523: END IF;
524: create_from_existing_rules (p_tax_regime_code,

Line 533: FND_LOG.STRING(g_level_statement,

529: p_error_buffer);
530:
531: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
532: IF (g_level_statement >= g_current_runtime_level ) THEN
533: FND_LOG.STRING(g_level_statement,
534: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
535: 'Unable to Create Simulated Rules from Existing Setup');
536: p_return_status := FND_API.G_RET_STS_ERROR;
537: p_error_buffer := 'Unable to Create Simulated Rules from Existing Setup';

Line 544: FND_LOG.STRING(g_level_statement,

540: return;
541: END IF;
542:
543: IF (g_level_statement >= g_current_runtime_level ) THEN
544: FND_LOG.STRING(g_level_statement,
545: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
546: 'Simulate Rules and Process Results for Applicability');
547: END IF;
548:

Line 620: FND_LOG.STRING(g_level_statement,

616: from zx_sim_conditions
617: where applicability_flag='Y');
618:
619: IF (g_level_statement >= g_current_runtime_level ) THEN
620: FND_LOG.STRING(g_level_statement,
621: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
622: 'Simulate Rule Conditions for Applicability');
623: END IF;
624:

Line 671: FND_LOG.STRING(g_level_statement,

667: and tax_line_number = p_taxline_number
668: and NVL(applicability_flag,'N') = 'Y';
669:
670: IF (g_level_statement >= g_current_runtime_level ) THEN
671: FND_LOG.STRING(g_level_statement,
672: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
673: 'Simulate Rules and Process Results for Status Determination');
674: END IF;
675: Select zx_rules_b_s.nextval,

Line 747: FND_LOG.STRING(g_level_statement,

743: from zx_sim_conditions
744: where status_determine_flag='Y');
745:
746: IF (g_level_statement >= g_current_runtime_level ) THEN
747: FND_LOG.STRING(g_level_statement,
748: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
749: 'Simulate Rule Conditions for Status Determination');
750: END IF;
751:

Line 790: FND_LOG.STRING(g_level_statement,

786: and tax_line_number = p_taxline_number
787: and NVL(status_determine_flag,'N') = 'Y';
788:
789: IF (g_level_statement >= g_current_runtime_level ) THEN
790: FND_LOG.STRING(g_level_statement,
791: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
792: 'Simulate Rules and Process Results for Rate Determination');
793: END IF;
794:

Line 868: FND_LOG.STRING(g_level_statement,

864: from zx_sim_conditions
865: where rate_determine_flag='Y');
866:
867: IF (g_level_statement >= g_current_runtime_level ) THEN
868: FND_LOG.STRING(g_level_statement,
869: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
870: 'Simulate Rule Conditions for Rate Determination');
871: END IF;
872:

Line 911: FND_LOG.STRING(g_level_statement,

907: and tax_line_number = p_taxline_number
908: and NVL(rate_determine_flag,'N') = 'Y';
909:
910: IF (g_level_statement >= g_current_runtime_level ) THEN
911: FND_LOG.STRING(g_level_statement,
912: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
913: 'Simulate Translation of Rules');
914: END IF;
915:

Line 943: FND_LOG.STRING(g_level_statement,

939: where t.sim_tax_rule_id = b.sim_tax_rule_id
940: and t.language = l.language_code);
941:
942: IF (g_level_statement >= g_current_runtime_level ) THEN
943: FND_LOG.STRING(g_level_statement,
944: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules.END',
945: 'ZX_SIM_CONDITIONS_PKG: create_sim_rules(-)');
946: END IF;
947:

Line 959: FND_LOG.STRING(g_level_unexpected,

955: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
956: FND_MSG_PUB.Add;
957:
958: IF (g_level_unexpected >= g_current_runtime_level ) THEN
959: FND_LOG.STRING(g_level_unexpected,
960: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
961: p_error_buffer);
962: END IF;
963:

Line 995: g_level_statement := FND_LOG.LEVEL_STATEMENT;

991:
992: l_cond_cnt NUMBER;
993:
994: BEGIN
995: g_level_statement := FND_LOG.LEVEL_STATEMENT;
996: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:
999: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 996: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;

992: l_cond_cnt NUMBER;
993:
994: BEGIN
995: g_level_statement := FND_LOG.LEVEL_STATEMENT;
996: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:
999: IF (g_level_statement >= g_current_runtime_level ) THEN
1000: FND_LOG.STRING(g_level_statement,

Line 997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

993:
994: BEGIN
995: g_level_statement := FND_LOG.LEVEL_STATEMENT;
996: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:
999: IF (g_level_statement >= g_current_runtime_level ) THEN
1000: FND_LOG.STRING(g_level_statement,
1001: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules.BEGIN',

Line 1000: FND_LOG.STRING(g_level_statement,

996: g_level_unexpected := FND_LOG.LEVEL_UNEXPECTED;
997: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
998:
999: IF (g_level_statement >= g_current_runtime_level ) THEN
1000: FND_LOG.STRING(g_level_statement,
1001: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules.BEGIN',
1002: 'ZX_SIM_CONDITIONS_PKG: create_rules(+)');
1003: END IF;
1004:

Line 1008: FND_LOG.STRING(g_level_statement,

1004:
1005: p_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: IF (g_level_statement >= g_current_runtime_level ) THEN
1008: FND_LOG.STRING(g_level_statement,
1009: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1010: 'Create Template Header Setup');
1011: END IF;
1012:

Line 1037: FND_LOG.STRING(g_level_statement,

1033: WHERE simulated_flag = 'Y'
1034: GROUP BY det_factor_templ_code;
1035:
1036: IF (g_level_statement >= g_current_runtime_level ) THEN
1037: FND_LOG.STRING(g_level_statement,
1038: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1039: 'Create Translation for Template Header Setup');
1040: END IF;
1041:

Line 1072: FND_LOG.STRING(g_level_statement,

1068: Where t.det_factor_templ_id = b.det_factor_templ_id
1069: And t.language = l.language_code);
1070:
1071: IF (g_level_statement >= g_current_runtime_level ) THEN
1072: FND_LOG.STRING(g_level_statement,
1073: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1074: 'Create Template Details Setup');
1075: END IF;
1076:

Line 1117: FND_LOG.STRING(g_level_statement,

1113: WHERE cond.condition_group_code = rule.condition_group_code
1114: AND simulated_flag = 'Y';
1115:
1116: IF (g_level_statement >= g_current_runtime_level ) THEN
1117: FND_LOG.STRING(g_level_statement,
1118: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1119: 'Create Condition Groups Setup without Conditions');
1120: END IF;
1121:

Line 1153: FND_LOG.STRING(g_level_statement,

1149: AND result.simulated_flag = 'Y'
1150: GROUP BY condition_group_code, det_factor_templ_code;
1151:
1152: IF (g_level_statement >= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_statement,
1154: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1155: 'Create Translation for Condition Groups Setup');
1156: END IF;
1157:

Line 1188: FND_LOG.STRING(g_level_statement,

1184: Where t.condition_group_id = b.condition_group_id
1185: And t.language = l.language_code);
1186:
1187: IF (g_level_statement >= g_current_runtime_level ) THEN
1188: FND_LOG.STRING(g_level_statement,
1189: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1190: 'Update Condition Groups Setup with conditions having 10 or fewer Conditions');
1191: END IF;
1192:

Line 1354: FND_LOG.STRING(g_level_statement,

1350: END LOOP;
1351: END LOOP;
1352:
1353: IF (g_level_statement >= g_current_runtime_level ) THEN
1354: FND_LOG.STRING(g_level_statement,
1355: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1356: 'Create Conditions Setup');
1357: END IF;
1358:

Line 1402: FND_LOG.STRING(g_level_statement,

1398: FROM zx_sim_rule_conditions
1399: WHERE simulated_flag = 'Y';
1400:
1401: IF (g_level_statement >= g_current_runtime_level ) THEN
1402: FND_LOG.STRING(g_level_statement,
1403: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1404: 'Create Rules Setup');
1405: END IF;
1406:

Line 1444: FND_LOG.STRING(g_level_statement,

1440: FROM zx_sim_rules_b
1441: WHERE simulated_flag = 'Y';
1442:
1443: IF (g_level_statement >= g_current_runtime_level ) THEN
1444: FND_LOG.STRING(g_level_statement,
1445: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1446: 'Create Translation for Rules Setup');
1447: END IF;
1448:

Line 1479: FND_LOG.STRING(g_level_statement,

1475: Where t.tax_rule_id = b.tax_rule_id
1476: And t.language = l.language_code);
1477:
1478: IF (g_level_statement >= g_current_runtime_level ) THEN
1479: FND_LOG.STRING(g_level_statement,
1480: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1481: 'Update Rules Setup for which Priority has been changed in Simulator');
1482: END IF;
1483:

Line 1494: FND_LOG.STRING(g_level_statement,

1490: Where sim.priority <> zx_rules_b.priority
1491: And sim.simulated_flag <> 'Y');
1492:
1493: IF (g_level_statement >= g_current_runtime_level ) THEN
1494: FND_LOG.STRING(g_level_statement,
1495: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1496: 'Create Process Results Setup');
1497: END IF;
1498:

Line 1538: FND_LOG.STRING(g_level_statement,

1534: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id
1535: AND result.simulated_flag = 'Y';
1536:
1537: IF (g_level_statement >= g_current_runtime_level ) THEN
1538: FND_LOG.STRING(g_level_statement,
1539: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
1540: 'Update Process Results for which Priority has been changed in Simulator');
1541: END IF;
1542:

Line 1553: FND_LOG.STRING(g_level_statement,

1549: Where sim.priority <> zx_process_results.priority
1550: And sim.simulated_flag <> 'Y');
1551:
1552: IF (g_level_statement >= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement,
1554: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules.END',
1555: 'ZX_SIM_CONDITIONS_PKG: create_rules(-)');
1556: END IF;
1557:

Line 1570: FND_LOG.STRING(g_level_unexpected,

1566: FND_MESSAGE.SET_NAME('ZX','ZX_UNEXPECTED_ERROR');
1567: FND_MSG_PUB.Add;
1568:
1569: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1570: FND_LOG.STRING(g_level_unexpected,
1571: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules',
1572: p_error_buffer);
1573: END IF;
1574: