APPS.CN_IMP_RULE_PVT dependencies on CN_RULESET_PVT

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 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,