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.CN_IMP_RULE_PVT dependencies on CN_RULES

Line 13: -- cn_rulesets, cn_rules, cn_attributes, cn_rules_hierarchy

9: -- Start of comments
10: -- API name : Rules_Import
11: -- Type : Private.
12: -- Function : program to transfer data from staging table into
13: -- cn_rulesets, cn_rules, cn_attributes, cn_rules_hierarchy
14: -- Pre-reqs : None.
15: -- Parameters :
16: -- IN : p_imp_header_id IN NUMBER Required
17: -- OUT : errbuf OUT VARCHAR2 Required

Line 47: l_ruleset_rec CN_Ruleset_PVT.ruleset_rec_type;

43: l_process_audit_id cn_process_audits.process_audit_id%TYPE;
44: l_current_ruleset_id NUMBER;
45: l_current_imp_line_id NUMBER;
46: l_temp_count NUMBER := 0;
47: l_ruleset_rec CN_Ruleset_PVT.ruleset_rec_type;
48: l_err_imp_line_id NUMBER;
49: l_org_id NUMBER;
50:
51: -- Cursor to check if the ruleset is present in the system

Line 52: CURSOR c_is_ruleset_present_csr (l_name cn_rulesets.name%TYPE, l_start_date cn_rulesets.start_date%TYPE, l_end_date cn_rulesets.end_date%TYPE, l_module_type cn_rulesets.module_type%TYPE) IS

48: l_err_imp_line_id NUMBER;
49: l_org_id NUMBER;
50:
51: -- Cursor to check if the ruleset is present in the system
52: CURSOR c_is_ruleset_present_csr (l_name cn_rulesets.name%TYPE, l_start_date cn_rulesets.start_date%TYPE, l_end_date cn_rulesets.end_date%TYPE, l_module_type cn_rulesets.module_type%TYPE) IS
53: SELECT ruleset_id
54: FROM cn_rulesets
55: WHERE name = l_name
56: AND start_date = l_start_date

Line 54: FROM cn_rulesets

50:
51: -- Cursor to check if the ruleset is present in the system
52: CURSOR c_is_ruleset_present_csr (l_name cn_rulesets.name%TYPE, l_start_date cn_rulesets.start_date%TYPE, l_end_date cn_rulesets.end_date%TYPE, l_module_type cn_rulesets.module_type%TYPE) IS
53: SELECT ruleset_id
54: FROM cn_rulesets
55: WHERE name = l_name
56: AND start_date = l_start_date
57: AND end_date = l_end_date
58: AND module_type = l_module_type

Line 64: FROM CN_RULES_IMP_V

60:
61: -- Cursor to get start date, end_date, ruleset type for the specified ruleset name
62: CURSOR c_ruleset_details_csr IS
63: SELECT ruleset_name, start_date, end_date, ruleset_type
64: FROM CN_RULES_IMP_V
65: WHERE imp_header_id = p_imp_header_id
66: AND status_code = l_stage_status
67: GROUP BY ruleset_name, start_date, end_date, ruleset_type
68: ORDER BY start_date;

Line 137: p_error_code => 'CN_RULESET_NAME_TOO_LONG',

133: p_start_date => detail_rec.start_date,
134: p_end_date => detail_rec.end_date,
135: p_ruleset_type => detail_rec.ruleset_type,
136: p_head_id => l_imp_header.imp_header_id,
137: p_error_code => 'CN_RULESET_NAME_TOO_LONG',
138: p_error_mssg => fnd_message.get_string('CN','CN_RULESET_NAME_TOO_LONG'),
139: x_failed_row => l_failed_row,
140: x_processed_row => l_processed_row);
141: GOTO end_of_ruleset_loop;

Line 138: p_error_mssg => fnd_message.get_string('CN','CN_RULESET_NAME_TOO_LONG'),

134: p_end_date => detail_rec.end_date,
135: p_ruleset_type => detail_rec.ruleset_type,
136: p_head_id => l_imp_header.imp_header_id,
137: p_error_code => 'CN_RULESET_NAME_TOO_LONG',
138: p_error_mssg => fnd_message.get_string('CN','CN_RULESET_NAME_TOO_LONG'),
139: x_failed_row => l_failed_row,
140: x_processed_row => l_processed_row);
141: GOTO end_of_ruleset_loop;
142: END IF;

Line 183: cn_message_pkg.debug('Rules_Import: Before calling CN_RULESET_PVT.create_ruleset, ruleset name: ' || detail_rec.ruleset_name);

179: cn_message_pkg.debug('value of l_current_ruleset_id:' || l_current_ruleset_id);
180:
181: IF l_current_ruleset_id = 0 THEN
182: l_return_status := FND_API.G_RET_STS_SUCCESS;
183: cn_message_pkg.debug('Rules_Import: Before calling CN_RULESET_PVT.create_ruleset, ruleset name: ' || detail_rec.ruleset_name);
184:
185: CN_RULESET_PVT.create_ruleset
186: ( p_api_version => 1.0,
187: p_init_msg_list => fnd_api.g_true,

Line 185: CN_RULESET_PVT.create_ruleset

181: IF l_current_ruleset_id = 0 THEN
182: l_return_status := FND_API.G_RET_STS_SUCCESS;
183: cn_message_pkg.debug('Rules_Import: Before calling CN_RULESET_PVT.create_ruleset, ruleset name: ' || detail_rec.ruleset_name);
184:
185: CN_RULESET_PVT.create_ruleset
186: ( p_api_version => 1.0,
187: p_init_msg_list => fnd_api.g_true,
188: p_commit => FND_API.G_FALSE,
189: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 197: cn_message_pkg.debug('Rules_Import: After CN_RULESET_PVT.create_ruleset call, return status: ' || l_return_status);

193: x_loading_status => l_loading_status,
194: x_ruleset_id => l_current_ruleset_id,
195: p_ruleset_rec => l_ruleset_rec);
196:
197: cn_message_pkg.debug('Rules_Import: After CN_RULESET_PVT.create_ruleset call, return status: ' || l_return_status);
198: cn_message_pkg.debug('After CN_RULESET_PVT.create_ruleset call, l_message: ' || l_message);
199:
200: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: cn_message_pkg.debug('Rules_Import: Error after returning from CN_RULESET_PVT.create_ruleset');

Line 198: cn_message_pkg.debug('After CN_RULESET_PVT.create_ruleset call, l_message: ' || l_message);

194: x_ruleset_id => l_current_ruleset_id,
195: p_ruleset_rec => l_ruleset_rec);
196:
197: cn_message_pkg.debug('Rules_Import: After CN_RULESET_PVT.create_ruleset call, return status: ' || l_return_status);
198: cn_message_pkg.debug('After CN_RULESET_PVT.create_ruleset call, l_message: ' || l_message);
199:
200: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: cn_message_pkg.debug('Rules_Import: Error after returning from CN_RULESET_PVT.create_ruleset');
202: retcode := 2;

Line 201: cn_message_pkg.debug('Rules_Import: Error after returning from CN_RULESET_PVT.create_ruleset');

197: cn_message_pkg.debug('Rules_Import: After CN_RULESET_PVT.create_ruleset call, return status: ' || l_return_status);
198: cn_message_pkg.debug('After CN_RULESET_PVT.create_ruleset call, l_message: ' || l_message);
199:
200: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
201: cn_message_pkg.debug('Rules_Import: Error after returning from CN_RULESET_PVT.create_ruleset');
202: retcode := 2;
203: errbuf:= l_message;
204: -- update all the rows related to the ruleset with a general message
205: update_imp_lines

Line 255: IF CN_Ruleset_PVT.check_sync_allowed

251:
252: cn_message_pkg.debug('Rules_Import: After call to load_rules, ruleset :' || detail_rec.ruleset_name);
253: cn_message_pkg.debug ('Rules_Import: Before synchronize, l_current_ruleset_id :' || l_current_ruleset_id);
254:
255: IF CN_Ruleset_PVT.check_sync_allowed
256: ( detail_rec.ruleset_name,
257: l_current_ruleset_id,
258: l_org_id,
259: x_loading_status,

Line 267: cn_rulesets_pkg.Sync_ruleset

263: GOTO end_of_ruleset_loop;
264:
265: END IF;
266: -- synchronize the package
267: cn_rulesets_pkg.Sync_ruleset
268: (x_ruleset_id_in => l_current_ruleset_id,
269: x_ruleset_status_in => l_return_status,
270: x_org_id => l_org_id);
271:

Line 371: -- This procedure will set error in cn_imp_lines(cn_rules_imp_v)

367:
368: -- --------------------------------------------------------+
369: -- seterr_imp_rules
370: --
371: -- This procedure will set error in cn_imp_lines(cn_rules_imp_v)
372: -- with passed in status and error code
373: -- --------------------------------------------------------+
374: PROCEDURE seterr_imp_rules
375: (p_status IN VARCHAR2,

Line 393: UPDATE cn_rules_imp_v

389: x_failed_row IN OUT NOCOPY NUMBER,
390: x_processed_row IN OUT NOCOPY NUMBER)
391: IS PRAGMA AUTONOMOUS_TRANSACTION;
392: BEGIN
393: UPDATE cn_rules_imp_v
394: SET status_code=p_status, error_code=p_error_code, error_msg=p_error_mssg
395: WHERE nvl(ruleset_name,FND_API.g_miss_char) = nvl(p_ruleset_name ,FND_API.g_miss_char)
396: AND nvl(start_date ,FND_API.g_miss_char) = nvl(p_ruleset_start_date, FND_API.g_miss_char)
397: AND nvl(end_date,FND_API.g_miss_char) = nvl(p_ruleset_end_date, FND_API.g_miss_char)

Line 477: FROM CN_RULES_IMP_V

473:
474: -- cursor to get the number of entries that have no rule name
475: CURSOR c_null_rule_name_csr IS
476: SELECT count(*)
477: FROM CN_RULES_IMP_V
478: WHERE imp_header_id = p_imp_header.imp_header_id
479: AND status_code = l_stage_status
480: AND ruleset_name = p_ruleset_name
481: AND start_date = p_ruleset_start_date

Line 488: FROM CN_RULES_IMP_V

484: AND rule_name IS NULL;
485:
486: CURSOR c_null_level_num_csr IS
487: SELECT count(*)
488: FROM CN_RULES_IMP_V
489: WHERE imp_header_id = p_imp_header.imp_header_id
490: AND status_code = l_stage_status
491: AND ruleset_name = p_ruleset_name
492: AND start_date = p_ruleset_start_date

Line 500: FROM CN_RULES_IMP_V

496:
497: -- Cursor to get rules of the ruleset
498: CURSOR c_rule_name_csr IS
499: SELECT distinct(rule_name) rule_name, parent_rule_name, level_num
500: FROM CN_RULES_IMP_V
501: WHERE imp_header_id = p_imp_header.imp_header_id
502: AND status_code = l_stage_status
503: AND ruleset_name = p_ruleset_name
504: AND start_date = p_ruleset_start_date

Line 512: CURSOR c_rules_dtl_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS

508: ORDER BY level_num;
509:
510: -- Cursor to check unique of revenue_class_name, expense_code,
511: -- liability_code
512: CURSOR c_rules_dtl_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
513: SELECT COUNT(1) FROM
514: (SELECT revenue_class_name, expense_code, liability_code
515: FROM CN_RULES_IMP_V
516: WHERE imp_header_id = p_imp_header.imp_header_id

Line 515: FROM CN_RULES_IMP_V

511: -- liability_code
512: CURSOR c_rules_dtl_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
513: SELECT COUNT(1) FROM
514: (SELECT revenue_class_name, expense_code, liability_code
515: FROM CN_RULES_IMP_V
516: WHERE imp_header_id = p_imp_header.imp_header_id
517: AND status_code = l_stage_status
518: AND ruleset_name = p_ruleset_name
519: AND start_date = p_ruleset_start_date

Line 528: CURSOR c_rules_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS

524: AND nvl(parent_rule_name,FND_API.g_miss_char) = nvl(l_parent_rule_name,FND_API.g_miss_char)
525: GROUP BY revenue_class_name, expense_code, liability_code) v1;
526:
527: -- Cursor to get rules details of the ruleset
528: CURSOR c_rules_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
529: SELECT revenue_class_name, expense_code, liability_code
530: FROM CN_RULES_IMP_V
531: WHERE imp_header_id = p_imp_header.imp_header_id
532: AND status_code = l_stage_status

Line 530: FROM CN_RULES_IMP_V

526:
527: -- Cursor to get rules details of the ruleset
528: CURSOR c_rules_csr (l_name cn_rules_imp_v.rule_name%TYPE, l_parent_rule_name cn_rules_imp_v.parent_rule_name%TYPE, l_level_num cn_rules_imp_v.level_num%TYPE) IS
529: SELECT revenue_class_name, expense_code, liability_code
530: FROM CN_RULES_IMP_V
531: WHERE imp_header_id = p_imp_header.imp_header_id
532: AND status_code = l_stage_status
533: AND ruleset_name = p_ruleset_name
534: AND start_date = p_ruleset_start_date

Line 542: CURSOR c_parent_rule_csr (l_name cn_rules.name%TYPE) IS

538: AND level_num = l_level_num
539: AND nvl(parent_rule_name,FND_API.g_miss_char) = nvl(l_parent_rule_name,FND_API.g_miss_char);
540:
541: -- Cursor to get the rule id given the rule name
542: CURSOR c_parent_rule_csr (l_name cn_rules.name%TYPE) IS
543: SELECT rule_id
544: FROM CN_RULES
545: WHERE name = l_name
546: AND ruleset_id=p_ruleset_id

Line 544: FROM CN_RULES

540:
541: -- Cursor to get the rule id given the rule name
542: CURSOR c_parent_rule_csr (l_name cn_rules.name%TYPE) IS
543: SELECT rule_id
544: FROM CN_RULES
545: WHERE name = l_name
546: AND ruleset_id=p_ruleset_id
547: AND org_id=p_org_id;
548:

Line 1011: FROM CN_RULES_IMP_V

1007: -- cursor to get attribute details, given ruleset name, rule name and parent rule name
1008: -- IMP parent rule name is required because we can have 2 rules with the same name but at different levels
1009: CURSOR c_rule_attrb_csr IS
1010: SELECT imp_line_id, record_num, rule_attribute, rule_value, not_flag, rule_hierarchy, rule_low_value, rule_high_value
1011: FROM CN_RULES_IMP_V
1012: WHERE imp_header_id = p_imp_header.imp_header_id
1013: AND status_code = l_stage_status
1014: AND ruleset_name = p_ruleset_name
1015: AND start_date = p_ruleset_start_date

Line 1254: FROM cn_rules_imp_v

1250: x_processed_row IN OUT NOCOPY NUMBER) IS
1251:
1252: CURSOR c_check_imp_line_id_csr IS
1253: SELECT count(*)
1254: FROM cn_rules_imp_v
1255: WHERE nvl(ruleset_name,FND_API.g_miss_char) = nvl(p_ruleset_name ,FND_API.g_miss_char)
1256: AND nvl(start_date ,FND_API.g_miss_char) = nvl(p_start_date, FND_API.g_miss_char)
1257: AND nvl(end_date,FND_API.g_miss_char) = nvl(p_end_date, FND_API.g_miss_char)
1258: AND nvl(ruleset_type,FND_API.g_miss_char) = nvl(p_ruleset_type, FND_API.g_miss_char)

Line 1267: cn_message_pkg.debug('Updating cn_rules_imp_v with status:' || p_status);

1263: l_temp NUMBER := 0;
1264:
1265: PRAGMA AUTONOMOUS_TRANSACTION;
1266: BEGIN
1267: cn_message_pkg.debug('Updating cn_rules_imp_v with status:' || p_status);
1268: cn_message_pkg.debug('p_ruleset_name:' || p_ruleset_name);
1269: cn_message_pkg.debug('p_start_date:' || p_start_date);
1270: cn_message_pkg.debug('p_end_date:' || p_end_date);
1271: cn_message_pkg.debug('p_ruleset_type:' || p_ruleset_type);

Line 1288: UPDATE cn_rules_imp_v

1284: END IF;
1285:
1286: cn_message_pkg.debug('l_temp:' || l_temp);
1287:
1288: UPDATE cn_rules_imp_v
1289: SET status_code=p_status, error_code=p_error_code, error_msg=p_error_mssg
1290: WHERE nvl(ruleset_name,FND_API.g_miss_char) = nvl(p_ruleset_name ,FND_API.g_miss_char)
1291: AND nvl(start_date ,FND_API.g_miss_char) = nvl(p_start_date, FND_API.g_miss_char)
1292: AND nvl(end_date,FND_API.g_miss_char) = nvl(p_end_date, FND_API.g_miss_char)