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 80: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

76: x NUMBER := 0;
77: BEGIN
78: IF (array_to_dump.COUNT > 0) THEN
79: FOR j IN array_to_dump.first .. array_to_dump.last LOOP
80: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
81: (Sysdate, 'MM_DUMP_ARRAY', 'Array ' || array_name || ', index ' || j || ': ' || array_to_dump(j));
82: END LOOP;
83: END IF;
84: END mm_dump_array;

Line 93: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

89: x NUMBER := 0;
90: BEGIN
91: IF (array_to_dump.COUNT > 0) THEN
92: FOR j IN array_to_dump.first .. array_to_dump.last LOOP
93: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
94: (Sysdate, 'MM_DUMP_OSR_ARRAY', 'Array ' || array_name || ', index ' || j || ': ' || array_to_dump(j));
95: END LOOP;
96: END IF;
97: END mm_dump_osr_array;

Line 603: INSERT INTO cz_db_logs

599: THEN
600: fnd_file.put_line(fnd_file.LOG, v_message);
601: END IF;
602:
603: INSERT INTO cz_db_logs
604: (logtime, loguser, urgency, caller, statuscode, MESSAGE, message_id, run_id
605: )
606: 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
607: );

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

609: COMMIT;
610: EXCEPTION
611: WHEN OTHERS
612: THEN
613: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;
614: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SESSN', SQLCODE);
615: END log_pb_errors;
616:
617: ----------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 650: INSERT INTO cz_db_logs

646: fnd_file.put_line(fnd_file.LOG, cz_pb_mgr.v_msg_tbl(i).msg_text);
647: END IF;
648:
649: BEGIN
650: INSERT INTO cz_db_logs
651: (logtime, caller, statuscode, MESSAGE
652: ,message_id, creation_date, run_id
653: )
654: 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 693: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;

689: cz_pb_mgr.v_msg_tbl.DELETE;
690: EXCEPTION
691: WHEN OTHERS
692: THEN
693: cz_pb_mgr.v_err_message := 'Error in inserting into cz_db_logs: ' || SQLERRM;
694: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.SESSN', SQLCODE);
695: cz_pb_mgr.v_msg_tbl.DELETE;
696: END log_pb_trace;
697:

Line 1554: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1550: IF ((cz_pb_mgr.v_pb_log_flag = 'YES') OR (cz_pb_mgr.v_status_code = PUBLICATION_ERROR)) THEN
1551:
1552: tmp_array_count := cz_pb_mgr.mm_source_array1.COUNT;
1553:
1554: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1555: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of item type source array: ' || tmp_array_count);
1556:
1557: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1558:

Line 1559: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1555: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of item type source array: ' || tmp_array_count);
1556:
1557: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1558:
1559: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1560: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item type id): ' || tmp_array_count);
1561:
1562: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1563:

Line 1564: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1560: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item type id): ' || tmp_array_count);
1561:
1562: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1563:
1564: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1565: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array3 (orig_sys_ref item type ): ' || tmp_array_count);
1566:
1567: mm_dump_array(cz_pb_mgr.mm_source_array1, 'ITEM TYPE SOURCE');
1568: mm_dump_array(cz_pb_mgr.mm_insert_array1, 'ITEM TYPE INSERT');

Line 1676: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1672: IF ((cz_pb_mgr.v_pb_log_flag = 'YES') OR (cz_pb_mgr.v_status_code = PUBLICATION_ERROR)) THEN
1673:
1674: tmp_array_count := cz_pb_mgr.mm_source_array1.COUNT;
1675:
1676: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1677: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of source array: ' || tmp_array_count);
1678:
1679: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1680:

Line 1681: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1677: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of source array: ' || tmp_array_count);
1678:
1679: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1680:
1681: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1682: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item_id): ' || tmp_array_count);
1683:
1684: tmp_array_count := cz_pb_mgr.mm_insert_array2.COUNT;
1685:

Line 1686: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1682: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item_id): ' || tmp_array_count);
1683:
1684: tmp_array_count := cz_pb_mgr.mm_insert_array2.COUNT;
1685:
1686: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1687: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array2 (item_type): ' || tmp_array_count);
1688:
1689: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1690:

Line 1691: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1687: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array2 (item_type): ' || tmp_array_count);
1688:
1689: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1690:
1691: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1692: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array3 (orig_sys_ref): ' || tmp_array_count);
1693:
1694: mm_dump_array(cz_pb_mgr.mm_source_array1, 'ITEM SOURCE');
1695: mm_dump_array(cz_pb_mgr.mm_insert_array1, 'ITEM INSERT');

Line 1845: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1841: IF ((cz_pb_mgr.v_pb_log_flag = 'YES') OR (cz_pb_mgr.v_status_code = PUBLICATION_ERROR)) THEN
1842:
1843: tmp_array_count := cz_pb_mgr.mm_source_array1.COUNT;
1844:
1845: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1846: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of item type prop source array: ' || tmp_array_count);
1847:
1848: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1849:

Line 1850: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1846: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of item type prop source array: ' || tmp_array_count);
1847:
1848: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1849:
1850: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1851: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item type prop id): ' || tmp_array_count);
1852:
1853: tmp_array_count := cz_pb_mgr.mm_insert_array2.COUNT;
1854:

Line 1855: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1851: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item type prop id): ' || tmp_array_count);
1852:
1853: tmp_array_count := cz_pb_mgr.mm_insert_array2.COUNT;
1854:
1855: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1856: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array2(item type): ' || tmp_array_count);
1857:
1858: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1859:

Line 1860: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1856: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array2(item type): ' || tmp_array_count);
1857:
1858: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1859:
1860: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1861: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array3 (item type prop orig_sys_ref): ' || tmp_array_count);
1862:
1863: mm_dump_array(cz_pb_mgr.mm_source_array1, 'ITEM TYPE PROP SOURCE');
1864: mm_dump_array(cz_pb_mgr.mm_insert_array1, 'ITEM TYPE PROP INSERT');

Line 1953: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1949: IF ((cz_pb_mgr.v_pb_log_flag = 'YES') OR (cz_pb_mgr.v_status_code = PUBLICATION_ERROR)) THEN
1950:
1951: tmp_array_count := cz_pb_mgr.mm_source_array1.COUNT;
1952:
1953: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1954: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of item prop val source array: ' || tmp_array_count);
1955:
1956: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1957:

Line 1958: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1954: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of item prop val source array: ' || tmp_array_count);
1955:
1956: tmp_array_count := cz_pb_mgr.mm_insert_array1.COUNT;
1957:
1958: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1959: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item prop val prop id): ' || tmp_array_count);
1960:
1961: tmp_array_count := cz_pb_mgr.mm_insert_array2.COUNT;
1962:

Line 1963: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1959: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array1 (item prop val prop id): ' || tmp_array_count);
1960:
1961: tmp_array_count := cz_pb_mgr.mm_insert_array2.COUNT;
1962:
1963: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1964: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array2(item prop val item id): ' || tmp_array_count);
1965:
1966: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1967:

Line 1968: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES

1964: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array2(item prop val item id): ' || tmp_array_count);
1965:
1966: tmp_array_count := cz_pb_mgr.mm_insert_array3.COUNT;
1967:
1968: INSERT INTO cz_db_logs (logtime, loguser, message) VALUES
1969: (Sysdate, 'CZ_PB_MGR.INSERT_ITEM_SCHEMA', 'Length of insert array3 (item prop val orig_sys_ref): ' || tmp_array_count);
1970:
1971: mm_dump_array(cz_pb_mgr.mm_source_array1, 'ITEM PROP VAL SOURCE');
1972: mm_dump_array(cz_pb_mgr.mm_insert_array1, 'ITEM PROP VAL INSERT');

Line 2128: || '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'');'

2124: || ' EXCEPTION WHEN OTHERS THEN '
2125: || ' '
2126: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2127: || ' '
2128: || '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'');'
2129: || ' '
2130: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2131:
2132: EXECUTE IMMEDIATE v_insertstring;

Line 2254: || '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'');'

2250: || ' EXCEPTION WHEN OTHERS THEN'
2251: || ' '
2252: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2253: || ' '
2254: || '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'');'
2255: || ' '
2256: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2257:
2258: EXECUTE IMMEDIATE v_insertstring;

Line 2378: || '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'');'

2374: || ' EXCEPTION WHEN OTHERS THEN'
2375: || ' '
2376: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2377: || ' '
2378: || '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'');'
2379: || ' '
2380: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2381:
2382: EXECUTE IMMEDIATE v_insertstring;

Line 2500: || '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'');'

2496: || ' EXCEPTION WHEN OTHERS THEN '
2497: || ' '
2498: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2499: || ' '
2500: || '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'');'
2501: || ' '
2502: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2503:
2504: EXECUTE IMMEDIATE v_insertstring;

Line 2620: || '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'');'

2616: || ' EXCEPTION WHEN OTHERS THEN '
2617: || ' '
2618: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2619: || ' '
2620: || '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'');'
2621: || ' '
2622: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2623:
2624: EXECUTE IMMEDIATE v_insertstring;

Line 2740: || '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'');'

2736: || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN NULL; WHEN OTHERS THEN'
2737: || ' '
2738: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2739: || ' '
2740: || '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'');'
2741: || ' '
2742: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2743:
2744: EXECUTE IMMEDIATE v_insertstring;

Line 2866: || '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'');'

2862: || ' EXCEPTION WHEN OTHERS THEN '
2863: || ' '
2864: || 'cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT(''CZ_PB_INSERTION_ERR'', ''TABLENAME'', cz_pb_mgr.v_insert_table_name,''SQLERRM'',SQLERRM);'
2865: || ' '
2866: || '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'');'
2867: || ' '
2868: || 'COMMIT; cz_pb_mgr.v_status_code := ''ERR''; RAISE; END; ';
2869:
2870: EXECUTE IMMEDIATE v_insertstring;

Line 4031: INSERT INTO cz_db_logs

4027: ELSE
4028: l_msg := SQLERRM;
4029: END IF;
4030:
4031: INSERT INTO cz_db_logs
4032: (logtime, caller, MESSAGE
4033: )
4034: VALUES (SYSDATE, 'CZJRADLOAD', l_msg
4035: );

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

10486: v_verify_model_run_id NUMBER;
10487: v_bomsynch_err_flag VARCHAR2(2000);
10488: v_model_name cz_devl_projects.NAME%TYPE;
10489:
10490: TYPE verify_model_message_list IS TABLE OF cz_db_logs.MESSAGE%TYPE
10491: INDEX BY BINARY_INTEGER;
10492:
10493: v_verify_model_msg_ref verify_model_message_list;
10494: BEGIN

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

10555:
10556: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_BOMSYNCH_VERIFY_ERR', 'MODELNAME', v_model_name);
10557: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.BOMSYNCHPROC', SQLCODE);
10558:
10559: ----trap errors from verify model to populate cz_db_logs
10560: BEGIN
10561: SELECT MESSAGE
10562: BULK COLLECT INTO v_verify_model_msg_ref
10563: FROM cz_db_logs

Line 10563: FROM cz_db_logs

10559: ----trap errors from verify model to populate cz_db_logs
10560: BEGIN
10561: SELECT MESSAGE
10562: BULK COLLECT INTO v_verify_model_msg_ref
10563: FROM cz_db_logs
10564: WHERE cz_db_logs.run_id = v_verify_model_run_id;
10565: EXCEPTION
10566: WHEN NO_DATA_FOUND
10567: THEN

Line 10564: WHERE cz_db_logs.run_id = v_verify_model_run_id;

10560: BEGIN
10561: SELECT MESSAGE
10562: BULK COLLECT INTO v_verify_model_msg_ref
10563: FROM cz_db_logs
10564: WHERE cz_db_logs.run_id = v_verify_model_run_id;
10565: EXCEPTION
10566: WHEN NO_DATA_FOUND
10567: THEN
10568: cz_pb_mgr.v_err_message := 'No messages from verify model procedure';

Line 12621: -- Check the status of the RPC execution that will be in cz_db_logs table;

12617: END IF;
12618:
12619: END IF;
12620:
12621: -- Check the status of the RPC execution that will be in cz_db_logs table;
12622: -- Need to delete data in the same place using the same array of ps_node_id, property_id
12623: IF ( (CZ_PB_MGR.v_status_code <> PUBLICATION_ERROR) AND (CZ_PB_MGR.v_server_id <> 0) ) THEN
12624: BEGIN
12625: EXECUTE IMMEDIATE

Line 12627: 'FROM cz_db_logs'||CZ_PB_MGR.v_db_link||' '||

12623: IF ( (CZ_PB_MGR.v_status_code <> PUBLICATION_ERROR) AND (CZ_PB_MGR.v_server_id <> 0) ) THEN
12624: BEGIN
12625: EXECUTE IMMEDIATE
12626: 'SELECT statuscode, message '||' '||
12627: 'FROM cz_db_logs'||CZ_PB_MGR.v_db_link||' '||
12628: 'WHERE caller = ''REMOTE_INSERT_PS_PROP_VALS'' '||' '||
12629: 'AND trunc(logtime) = trunc (sysdate) ' INTO r_return_status, r_msg_string;
12630:
12631: EXCEPTION

Line 12692: DELETE FROM cz_db_logs WHERE caller = 'REMOTE_INSERT_PS_PROP_VALS';

12688: EXCEPTION
12689: WHEN OTHERS THEN
12690: r_return_status := FND_API.G_RET_STS_ERROR;
12691: r_msg_data := 'Error Executing Remote Bulk Insert - PS_PROP_VALS'||SQLERRM;
12692: DELETE FROM cz_db_logs WHERE caller = 'REMOTE_INSERT_PS_PROP_VALS';
12693:
12694: INSERT INTO cz_db_logs(logtime, caller, message, statuscode)
12695: VALUES(sysdate,'REMOTE_INSERT_PS_PROP_VALS',r_msg_data,r_return_status);
12696:

Line 12694: INSERT INTO cz_db_logs(logtime, caller, message, statuscode)

12690: r_return_status := FND_API.G_RET_STS_ERROR;
12691: r_msg_data := 'Error Executing Remote Bulk Insert - PS_PROP_VALS'||SQLERRM;
12692: DELETE FROM cz_db_logs WHERE caller = 'REMOTE_INSERT_PS_PROP_VALS';
12693:
12694: INSERT INTO cz_db_logs(logtime, caller, message, statuscode)
12695: VALUES(sysdate,'REMOTE_INSERT_PS_PROP_VALS',r_msg_data,r_return_status);
12696:
12697: COMMIT;
12698: RAISE;

Line 19351: v_run_id cz_db_logs.run_id%TYPE;

19347: AS
19348:
19349: l_publication_id_tbl cz_pb_mgr.number_type_tbl;
19350: v_tobepublished cz_model_publications.publication_id%TYPE;
19351: v_run_id cz_db_logs.run_id%TYPE;
19352: v_pb_status cz_model_publications.export_status%TYPE;
19353: BEGIN
19354:
19355: SELECT publication_id BULK COLLECT INTO l_publication_id_tbl