DBA Data[Home] [Help]

APPS.CN_SCA_RULES_BATCH_GEN_PVT dependencies on CN_MESSAGE_PKG

Line 223: cn_message_pkg.debug('IN check_create_object Exception handler name is '||

219: AND object_type = x_object_type;
220: END IF;
221: --
222: EXCEPTION WHEN OTHERS THEN
223: cn_message_pkg.debug('IN check_create_object Exception handler name is '||
224: x_name ||' object_type is '|| x_object_type ||
225: ' object_id is '|| x_object_id );
226: RAISE;
227: END check_create_object;

Line 676: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''EXCEPTION IN populate_matches, '' || sqlerrm); ');

672: cn_utils.appendcr(body_code, ' END LOOP;');
673:
674: cn_utils.appindcr(body_code, 'EXCEPTION ');
675: cn_utils.appindcr(body_code, ' WHEN OTHERS THEN ');
676: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''EXCEPTION IN populate_matches, '' || sqlerrm); ');
677: cn_utils.appindcr(body_code, ' raise; ');
678:
679: cn_utils.appendcr(body_code, 'END;');
680:

Line 682: cn_message_pkg.debug('IN get_perf exception handler, error is '||sqlcode||' '||sqlerrm);

678:
679: cn_utils.appendcr(body_code, 'END;');
680:
681: EXCEPTION when others then
682: cn_message_pkg.debug('IN get_perf exception handler, error is '||sqlcode||' '||sqlerrm);
683: RAISE;
684: END populate_matches;
685:
686: FUNCTION create_sca_rules_batch_dyn (

Line 857: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');

853: DBMS_SQL.PARSE(cursor1,sqlstring,i,j,new_line_flag,DBMS_SQL.V7);
854: retval:=DBMS_SQL.EXECUTE(cursor1);
855: DBMS_SQL.CLOSE_CURSOR(cursor1);
856:
857: cn_message_pkg.debug('The rule dynamic package is created successfully. Continue to intall the package. ');
858: fnd_file.put_line(fnd_file.Log, 'The rule dynamic package is created successfully. Continue to intall the package.');
859: --dbms_output.put_line('The rule dynamic package is created successfully. ' );
860:
861: -- check whether package is installed successfully