eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_SIM_CONDITIONS_PKG dependencies on ZX_SIM_CONDITIONS_PKG

Line 1: PACKAGE BODY ZX_SIM_CONDITIONS_PKG AS

1: PACKAGE BODY ZX_SIM_CONDITIONS_PKG AS
2: /* $Header: zxrisimrulespvtb.pls 120.8 2005/06/29 17:53:54 lxzhang ship $ */
3:
4: Cursor c_sim_cond (c_trxline_id NUMBER,
5: c_taxline_number NUMBER) Is

Line 46: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules.BEGIN',

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,
50: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

Line 47: 'ZX_SIM_CONDITIONS_PKG: create_from_existing_rules(+)');

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,
50: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',
51: 'Simulate Rules');

Line 50: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

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:
54: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 106: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

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:
110: INSERT INTO zx_sim_rules_tl (

Line 135: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

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:
139: INSERT INTO zx_sim_process_results (

Line 174: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

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:
178: INSERT INTO zx_sim_rule_conditions (

Line 226: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules.END',

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:
230:

Line 227: 'ZX_SIM_CONDITIONS_PKG: create_from_existing_rules(-)');

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:
230:
231: EXCEPTION

Line 241: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

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:
245: END create_from_existing_rules;

Line 304: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions.BEGIN',

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:
308: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 305: 'ZX_SIM_CONDITIONS_PKG: create_sim_conditions(+)');

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:
308: p_return_status := FND_API.G_RET_STS_SUCCESS;
309:

Line 324: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',

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:
328: exit;

Line 358: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',

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:
362: If pr_detfactor_code_tab(i) = 'INTENDED_USE' Then

Line 387: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',

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:
391: FORALL j IN pr_detfactor_class_tab.first..pr_detfactor_class_tab.last

Line 458: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions.END',

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:
462: commit;

Line 459: 'ZX_SIM_CONDITIONS_PKG: create_sim_conditions(-)');

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:
462: commit;
463:

Line 474: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_conditions',

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:
478: END create_sim_conditions;

Line 503: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules.BEGIN',

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:
507: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 504: 'ZX_SIM_CONDITIONS_PKG: create_sim_rules(+)');

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:
507: p_return_status := FND_API.G_RET_STS_SUCCESS;
508:

Line 511: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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;
515: DELETE zx_sim_rules_tl;

Line 521: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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,
525: p_tax,

Line 534: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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';
538: END IF;

Line 545: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
549: Select zx_rules_b_s.nextval,

Line 621: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
625: INSERT INTO zx_sim_rule_conditions (

Line 672: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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,
676: zx_condition_groups_b_s.nextval

Line 748: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
752: INSERT INTO zx_sim_rule_conditions (

Line 791: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
795: Select zx_rules_b_s.nextval,

Line 869: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
873: INSERT INTO zx_sim_rule_conditions (

Line 912: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
916: INSERT INTO zx_sim_rules_tl (

Line 944: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules.END',

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:
948: commit;

Line 945: 'ZX_SIM_CONDITIONS_PKG: create_sim_rules(-)');

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:
948: commit;
949:

Line 960: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
964: END create_sim_rules;

Line 1001: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules.BEGIN',

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:
1005: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1002: 'ZX_SIM_CONDITIONS_PKG: create_rules(+)');

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:
1005: p_return_status := FND_API.G_RET_STS_SUCCESS;
1006:

Line 1009: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1013: INSERT ALL WHEN (1=1) Then

Line 1038: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1042: INSERT INTO zx_det_factor_templ_tl (

Line 1073: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1077: INSERT ALL WHEN (1=1) Then

Line 1118: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1122: INSERT ALL WHEN (1=1) Then

Line 1154: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1158: INSERT INTO zx_condition_groups_tl (

Line 1189: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1193: FOR i IN c_condgroups

Line 1355: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1359: INSERT INTO zx_conditions (

Line 1403: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1407: INSERT INTO zx_rules_b (

Line 1445: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1449: INSERT INTO zx_rules_tl (

Line 1480: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1484: UPDATE zx_rules_b

Line 1495: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1499: INSERT INTO zx_process_results (

Line 1539: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',

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:
1543: UPDATE zx_process_results

Line 1554: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules.END',

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:
1558: commit;

Line 1555: 'ZX_SIM_CONDITIONS_PKG: create_rules(-)');

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:
1558: commit;
1559:

Line 1571: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_rules',

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:
1575: END create_rules;

Line 1577: END ZX_SIM_CONDITIONS_PKG;

1573: END IF;
1574:
1575: END create_rules;
1576:
1577: END ZX_SIM_CONDITIONS_PKG;