[Home] [Help]
194: AND object_type = x_object_type
195: AND org_id = g_org_id;
196: END IF;
197: EXCEPTION WHEN OTHERS THEN
198: cn_message_pkg.debug('IN check_create_object Exception handler name is ' || x_name ||
199: ' object_type is ' || x_object_type || ' object_id is ' || x_object_id );
200: RAISE;
201: END check_create_object;
202:
489: cn_utils.appindcr(body_code, ' (p_count => x_msg_count , ');
490: cn_utils.appindcr(body_code, ' p_data => x_msg_data , ');
491: cn_utils.appindcr(body_code, ' p_encoded => FND_API.G_FALSE ');
492: cn_utils.appindcr(body_code, ' ); ');
493: cn_utils.appindcr(body_code, 'cn_message_pkg.debug(''EXCEPTION IN get_winning_rule, '' || sqlerrm);');
494: cn_utils.proc_end( procedure_name, 'N', body_code );
495:
496: EXCEPTION when others then
497: cn_message_pkg.debug('IN get_perf exception handler, error is '||sqlcode||' '||sqlerrm);
493: cn_utils.appindcr(body_code, 'cn_message_pkg.debug(''EXCEPTION IN get_winning_rule, '' || sqlerrm);');
494: cn_utils.proc_end( procedure_name, 'N', body_code );
495:
496: EXCEPTION when others then
497: cn_message_pkg.debug('IN get_perf exception handler, error is '||sqlcode||' '||sqlerrm);
498: RAISE;
499:
500: END get_winning_rule;
501:
655: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
656: retval:=DBMS_SQL.EXECUTE(cursor1);
657: DBMS_SQL.CLOSE_CURSOR(cursor1);
658:
659: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');
660: fnd_file.put_line(fnd_file.Log, 'The rule dynamic package is created successfully. Continue to intall the package.');
661:
662: -- check whether package is installed successfully
663: SELECT COUNT(*)