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.CZ_PB_MGR dependencies on CZ_DB_LOGS

Line 1630: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

1626: || ' EXCEPTION WHEN OTHERS THEN '
1627: || ' '
1628: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1629: || ' '
1630: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1631: || ' '
1632: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1633:
1634: EXECUTE IMMEDIATE v_insertstring;

Line 1752: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

1748: || ' EXCEPTION WHEN OTHERS THEN'
1749: || ' '
1750: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1751: || ' '
1752: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1753: || ' '
1754: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1755:
1756: EXECUTE IMMEDIATE v_insertstring;

Line 1872: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

1868: || ' EXCEPTION WHEN OTHERS THEN'
1869: || ' '
1870: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1871: || ' '
1872: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1873: || ' '
1874: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1875:
1876: EXECUTE IMMEDIATE v_insertstring;

Line 1990: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

1986: || ' EXCEPTION WHEN OTHERS THEN '
1987: || ' '
1988: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
1989: || ' '
1990: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
1991: || ' '
1992: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
1993:
1994: EXECUTE IMMEDIATE v_insertstring;

Line 2106: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

2102: || ' EXCEPTION WHEN OTHERS THEN '
2103: || ' '
2104: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2105: || ' '
2106: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
2107: || ' '
2108: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2109:
2110: EXECUTE IMMEDIATE v_insertstring;

Line 2222: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

2218: || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN NULL; WHEN OTHERS THEN'
2219: || ' '
2220: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2221: || ' '
2222: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
2223: || ' '
2224: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2225:
2226: EXECUTE IMMEDIATE v_insertstring;

Line 2340: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'

2336: || ' EXCEPTION WHEN OTHERS THEN '
2337: || ' '
2338: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2339: || ' '
2340: || 'ROLLBACK; insert into cz_db_logs (message, message_id,run_id,caller) values(cz_pb_mgr.v_err_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id, ''INSERTINTOTABLE'');'
2341: || ' '
2342: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2343:
2344: EXECUTE IMMEDIATE v_insertstring;

Line 3402: INSERT INTO cz_db_logs

3398: ELSE
3399: l_msg := SQLERRM;
3400: END IF;
3401:
3402: INSERT INTO cz_db_logs
3403: (logtime, caller, MESSAGE
3404: )
3405: VALUES (SYSDATE, 'CZJRADLOAD', l_msg
3406: );

Line 6027: INSERT INTO cz_db_logs

6023: THEN
6024: fnd_file.put_line(fnd_file.LOG, v_message);
6025: END IF;
6026:
6027: INSERT INTO cz_db_logs
6028: (logtime, loguser, urgency, caller, statuscode, MESSAGE, message_id, run_id
6029: )
6030: VALUES (SYSDATE, cz_pb_mgr.loguser, p_urgency, p_caller, p_statuscode, v_message, cz_pb_mgr.v_publication_id, cz_pb_mgr.v_pb_run_id
6031: );

Line 6037: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;

6033: COMMIT;
6034: EXCEPTION
6035: WHEN OTHERS
6036: THEN
6037: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;
6038: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SESSN', SQLCODE);
6039: END log_pb_errors;
6040:
6041: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 6074: INSERT INTO cz_db_logs

6070: fnd_file.put_line(fnd_file.LOG, cz_pb_mgr.v_msg_tbl(i).msg_text);
6071: END IF;
6072:
6073: BEGIN
6074: INSERT INTO cz_db_logs
6075: (logtime, caller, statuscode, MESSAGE
6076: ,message_id, creation_date, run_id
6077: )
6078: VALUES (SYSDATE, cz_pb_mgr.v_msg_tbl(i).called_proc, cz_pb_mgr.v_msg_tbl(i).sql_code, cz_pb_mgr.v_msg_tbl(i).msg_text

Line 6117: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;

6113: cz_pb_mgr.v_msg_tbl.DELETE;
6114: EXCEPTION
6115: WHEN OTHERS
6116: THEN
6117: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;
6118: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SESSN', SQLCODE);
6119: cz_pb_mgr.v_msg_tbl.DELETE;
6120: END log_pb_trace;
6121:

Line 9734: TYPE verify_model_message_list IS TABLE OF cz_db_logs.MESSAGE%TYPE

9730: v_verify_model_run_id NUMBER;
9731: v_bomsynch_err_flag VARCHAR2(2000);
9732: v_model_name cz_devl_projects.NAME%TYPE;
9733:
9734: TYPE verify_model_message_list IS TABLE OF cz_db_logs.MESSAGE%TYPE
9735: INDEX BY BINARY_INTEGER;
9736:
9737: v_verify_model_msg_ref verify_model_message_list;
9738: BEGIN

Line 9803: ----trap errors from verify model to populate cz_db_logs

9799:
9800: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_BOMSYNCH_VERIFY_ERR', 'MODELNAME', v_model_name);
9801: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROC', SQLCODE);
9802:
9803: ----trap errors from verify model to populate cz_db_logs
9804: BEGIN
9805: SELECT MESSAGE
9806: BULK COLLECT INTO v_verify_model_msg_ref
9807: FROM cz_db_logs

Line 9807: FROM cz_db_logs

9803: ----trap errors from verify model to populate cz_db_logs
9804: BEGIN
9805: SELECT MESSAGE
9806: BULK COLLECT INTO v_verify_model_msg_ref
9807: FROM cz_db_logs
9808: WHERE cz_db_logs.run_id = v_verify_model_run_id;
9809: EXCEPTION
9810: WHEN NO_DATA_FOUND
9811: THEN

Line 9808: WHERE cz_db_logs.run_id = v_verify_model_run_id;

9804: BEGIN
9805: SELECT MESSAGE
9806: BULK COLLECT INTO v_verify_model_msg_ref
9807: FROM cz_db_logs
9808: WHERE cz_db_logs.run_id = v_verify_model_run_id;
9809: EXCEPTION
9810: WHEN NO_DATA_FOUND
9811: THEN
9812: cz_pb_mgr.v_err_message := 'No messages from verify model procedure';

Line 18216: v_run_id cz_db_logs.run_id%TYPE;

18212: AND UPPER(object_type) = model_publication
18213: ORDER BY publication_id;
18214:
18215: v_tobepublished cz_model_publications.publication_id%TYPE;
18216: v_run_id cz_db_logs.run_id%TYPE;
18217: v_pb_status cz_model_publications.export_status%TYPE;
18218: BEGIN
18219:
18220: OPEN tobepublished_cur;