DBA Data[Home] [Help]

APPS.CZ_PUBL_SYNC_CRASH dependencies on FND_LOG

Line 222: cz_utils.log_report(pkg_name, 'DELETE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);

218: EXCEPTION
219: WHEN OTHERS THEN
220: ERRNO := czError;
221: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
222: cz_utils.log_report(pkg_name, 'DELETE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
223: RAISE DELETE_PUBLICATION_ERROR;
224: END DELETE_PUBLICATION_DATA ;
225:
226: -----------------------------------------------------------------------------------------

Line 592: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);

588: exception
589: when no_data_found then
590: -- ERRNO := czError;
591: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MODEL_NOT_FOUND', 'PUBID', lPublicationId);
592: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
593: -- RAISE SOURCE_MODEL_NOT_FOUND;
594: END;
595: -- resolve source_ui_def_id
596: BEGIN

Line 609: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);

605: exception
606: when no_data_found then
607: -- ERRNO := czError;
608: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MODEL_NOT_FOUND', 'PUBID', lPublicationId);
609: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
610: -- RAISE SOURCE_UI_NOT_FOUND;
611: when others then
612: CLOSE publications_cur;
613: ERRNO := czError;

Line 615: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);

611: when others then
612: CLOSE publications_cur;
613: ERRNO := czError;
614: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
615: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
616: END;
617:
618: -- insert
619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;

Line 847: cz_utils.log_report(pkg_name, 'REPUBLISH_MODELS', null, ERRBUF, fnd_log.LEVEL_ERROR);

843: CZ_PB_MGR.REPUBLISH_MODEL(v_pub_tbl(i),lStartDate,lEndDate,x_run_id,x_status);
844: IF (x_status <> PUBLICATION_OK) THEN
845: err_count := err_count + 1;
846: ERRBUF := CZ_UTILS.GET_TEXT('CZ_REPUBLISH_ERROR','PUBL_ID',v_pub_tbl(i),'ERROR',SQLERRM);
847: cz_utils.log_report(pkg_name, 'REPUBLISH_MODELS', null, ERRBUF, fnd_log.LEVEL_ERROR);
848: ELSE
849: ok_count := ok_count + 1;
850: END IF;
851: ELSE

Line 854: cz_utils.log_report(pkg_name, 'REPUBLISH_MODELS', null, ERRBUF, fnd_log.LEVEL_ERROR);

850: END IF;
851: ELSE
852: -- Republishing :Publication Id
853: ERRBUF := CZ_UTILS.GET_TEXT('CZ_REPUBLISH','PUBL_ID',v_pub_tbl(i));
854: cz_utils.log_report(pkg_name, 'REPUBLISH_MODELS', null, ERRBUF, fnd_log.LEVEL_ERROR);
855: END IF;
856: END LOOP;
857: END IF;
858: okCount := ok_count;

Line 962: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

958: WHEN NO_DATA_FOUND THEN
959: ROLLBACK;
960: ERRNO := czError;
961: ERRBUF := CZ_UTILS.GET_TEXT(sqlerrm);
962: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
963: RESET_DBMS_INFO;
964: WHEN INCORRECT_SOURCE THEN
965: ROLLBACK;
966: ERRNO := czError;

Line 968: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

964: WHEN INCORRECT_SOURCE THEN
965: ROLLBACK;
966: ERRNO := czError;
967: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SERVER_NOT_SOURCE','SERVERNAME',lServerName);
968: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
969: RESET_DBMS_INFO;
970: WHEN CZ_SYNC_ERROR THEN
971: ROLLBACK;
972: ERRNO := czError;

Line 974: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

970: WHEN CZ_SYNC_ERROR THEN
971: ROLLBACK;
972: ERRNO := czError;
973: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);
974: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
975: RESET_DBMS_INFO;
976: WHEN SERVER_NOT_FOUND THEN
977: ROLLBACK;
978: ERRNO := czError;

Line 980: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

976: WHEN SERVER_NOT_FOUND THEN
977: ROLLBACK;
978: ERRNO := czError;
979: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);
980: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
981: RESET_DBMS_INFO;
982: WHEN DB_LINK_DOWN THEN
983: ROLLBACK;
984: ERRNO := czError;

Line 986: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

982: WHEN DB_LINK_DOWN THEN
983: ROLLBACK;
984: ERRNO := czError;
985: ERRBUF := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','LINK_NAME', lLinkName);
986: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
987: RESET_DBMS_INFO;
988: WHEN DB_TNS_INCORRECT THEN
989: ROLLBACK;
990: ERRNO := czError;

Line 992: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

988: WHEN DB_TNS_INCORRECT THEN
989: ROLLBACK;
990: ERRNO := czError;
991: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName);
992: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
993: RESET_DBMS_INFO;
994: WHEN VALIDATE_SERVER_ERROR THEN
995: ROLLBACK;
996: ERRNO := czError;

Line 998: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

994: WHEN VALIDATE_SERVER_ERROR THEN
995: ROLLBACK;
996: ERRNO := czError;
997: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);
998: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
999: RESET_DBMS_INFO;
1000: WHEN DELETE_PUBLICATION_ERROR THEN
1001: ROLLBACK;
1002: ERRNO := czError;

Line 1004: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1000: WHEN DELETE_PUBLICATION_ERROR THEN
1001: ROLLBACK;
1002: ERRNO := czError;
1003: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
1004: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1005: RESET_DBMS_INFO;
1006: /* WHEN SOURCE_MODEL_NOT_FOUND THEN
1007: ROLLBACK;
1008: ERRNO := czError;

Line 1010: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1006: /* WHEN SOURCE_MODEL_NOT_FOUND THEN
1007: ROLLBACK;
1008: ERRNO := czError;
1009: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MODEL_NOT_FOUND', 'MODELID', n_Source_Model_Id);
1010: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1011: RESET_DBMS_INFO;
1012: WHEN SOURCE_UI_NOT_FOUND THEN
1013: ROLLBACK;
1014: ERRNO := czError;

Line 1016: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1012: WHEN SOURCE_UI_NOT_FOUND THEN
1013: ROLLBACK;
1014: ERRNO := czError;
1015: ERRBUF := CZ_UTILS.GET_TEXT('CZ_UI_MODEL_NOT_FOUND', 'MODELID', n_Source_Model_Id);
1016: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1017: RESET_DBMS_INFO;
1018: */
1019: WHEN CREATE_PUBLICATION_ERROR THEN
1020: ROLLBACK;

Line 1023: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1019: WHEN CREATE_PUBLICATION_ERROR THEN
1020: ROLLBACK;
1021: ERRNO := czError;
1022: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
1023: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1024: RESET_DBMS_INFO;
1025: WHEN REDO_SEQUENCE_ERROR THEN
1026: ROLLBACK;
1027: ERRNO := czError;

Line 1029: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1025: WHEN REDO_SEQUENCE_ERROR THEN
1026: ROLLBACK;
1027: ERRNO := czError;
1028: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);
1029: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1030: RESET_DBMS_INFO;
1031: /* WHEN WRONG_INCR THEN
1032: ERRNO := czWarning;
1033: ERRBUF := CZ_UTILS.GET_TEXT('CZ_NO_SEQ_INCREMENT_VAL');

Line 1034: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1030: RESET_DBMS_INFO;
1031: /* WHEN WRONG_INCR THEN
1032: ERRNO := czWarning;
1033: ERRBUF := CZ_UTILS.GET_TEXT('CZ_NO_SEQ_INCREMENT_VAL');
1034: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1035: RESET_DBMS_INFO;
1036: */
1037: WHEN REPORT_RESULTS_ERROR THEN
1038: ERRNO := czWarning;

Line 1040: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1036: */
1037: WHEN REPORT_RESULTS_ERROR THEN
1038: ERRNO := czWarning;
1039: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);
1040: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1041: RESET_DBMS_INFO;
1042: WHEN OTHERS THEN
1043: --'Unable to continue because of %ERRORTEXT'
1044: ROLLBACK;

Line 1047: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);

1043: --'Unable to continue because of %ERRORTEXT'
1044: ROLLBACK;
1045: ERRNO := czError;
1046: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);
1047: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);
1048: RESET_DBMS_INFO;
1049: END SYNC_SINGLE_SOURCE_CP;
1050: ------------------------------------------------------------------------------------------
1051:

Line 1082: cz_utils.log_report(pkg_name, 'SYNC_ALL_SOURCE_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);

1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: ERRNO := 2;
1081: ERRBUF := SQLERRM;
1082: cz_utils.log_report(pkg_name, 'SYNC_ALL_SOURCE_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);
1083: END;
1084: END LOOP;
1085: CLOSE c_get_all_remote_servers;
1086:

Line 1145: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1141: /* ELSE
1142: ERRNO := czError;
1143: -- This instance is not the source for the selected Target server
1144: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SERVER_NOT_SOURCE');
1145: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1146: END IF;
1147: **/
1148: ELSE
1149: ERRNO := czError;

Line 1152: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1148: ELSE
1149: ERRNO := czError;
1150: -- The selected Target's tns details do not match with that in CZ_SERVERS
1151: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_TARGET');
1152: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1153: END IF;
1154: IF (inCommitYesNo = 0) THEN
1155: COMMIT;
1156: END IF;

Line 1163: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);

1159: WHEN NO_DATA_FOUND THEN
1160: ROLLBACK;
1161: ERRNO := czError;
1162: ERRBUF := CZ_UTILS.GET_TEXT(sqlerrm);
1163: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1164: RESET_DBMS_INFO;
1165: WHEN INCORRECT_SOURCE THEN
1166: ROLLBACK;
1167: ERRNO := czError;

Line 1169: cz_utils.log_report(pkg_name, 'CHECK_IF_SOURCE', null, ERRBUF, fnd_log.LEVEL_ERROR);

1165: WHEN INCORRECT_SOURCE THEN
1166: ROLLBACK;
1167: ERRNO := czError;
1168: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SERVER_NOT_SOURCE','SERVERNAME',lServerName);
1169: cz_utils.log_report(pkg_name, 'CHECK_IF_SOURCE', null, ERRBUF, fnd_log.LEVEL_ERROR);
1170: RESET_DBMS_INFO;
1171: WHEN CZ_SYNC_ERROR THEN
1172: ROLLBACK;
1173: ERRNO := czError;

Line 1175: cz_utils.log_report(pkg_name, 'CHECK_IF_SOURCE', null, ERRBUF, fnd_log.LEVEL_ERROR);

1171: WHEN CZ_SYNC_ERROR THEN
1172: ROLLBACK;
1173: ERRNO := czError;
1174: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);
1175: cz_utils.log_report(pkg_name, 'CHECK_IF_SOURCE', null, ERRBUF, fnd_log.LEVEL_ERROR);
1176: RESET_DBMS_INFO;
1177: WHEN SERVER_NOT_FOUND THEN
1178: ROLLBACK;
1179: ERRNO := czError;

Line 1181: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);

1177: WHEN SERVER_NOT_FOUND THEN
1178: ROLLBACK;
1179: ERRNO := czError;
1180: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);
1181: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);
1182: RESET_DBMS_INFO;
1183: WHEN DB_LINK_DOWN THEN
1184: ROLLBACK;
1185: ERRNO := czError;

Line 1187: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);

1183: WHEN DB_LINK_DOWN THEN
1184: ROLLBACK;
1185: ERRNO := czError;
1186: ERRBUF := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','LINK_NAME', lLinkName);
1187: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);
1188: RESET_DBMS_INFO;
1189: WHEN DB_TNS_INCORRECT THEN
1190: ROLLBACK;
1191: ERRNO := czError;

Line 1193: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);

1189: WHEN DB_TNS_INCORRECT THEN
1190: ROLLBACK;
1191: ERRNO := czError;
1192: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName);
1193: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);
1194: RESET_DBMS_INFO;
1195: WHEN VALIDATE_SERVER_ERROR THEN
1196: ROLLBACK;
1197: ERRNO := czError;

Line 1199: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);

1195: WHEN VALIDATE_SERVER_ERROR THEN
1196: ROLLBACK;
1197: ERRNO := czError;
1198: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);
1199: cz_utils.log_report(pkg_name, 'VALIDATE_SERVER', null, ERRBUF, fnd_log.LEVEL_ERROR);
1200: RESET_DBMS_INFO;
1201: WHEN TNS_INCORRECT THEN -- target validation
1202: ROLLBACK;
1203: ERRNO := czError;

Line 1205: cz_utils.log_report(pkg_name, 'VALIDATETARGET', null, ERRBUF, fnd_log.LEVEL_ERROR);

1201: WHEN TNS_INCORRECT THEN -- target validation
1202: ROLLBACK;
1203: ERRNO := czError;
1204: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_TARGET','SERVERNAME',lServerName);
1205: cz_utils.log_report(pkg_name, 'VALIDATETARGET', null, ERRBUF, fnd_log.LEVEL_ERROR);
1206: RESET_DBMS_INFO;
1207: WHEN DELETE_DEL_PUBLICATION_ERROR THEN
1208: ROLLBACK;
1209: ERRNO := czError;

Line 1211: cz_utils.log_report(pkg_name, 'DELETE_DELETED_PUBLICATIONS', null, ERRBUF, fnd_log.LEVEL_ERROR);

1207: WHEN DELETE_DEL_PUBLICATION_ERROR THEN
1208: ROLLBACK;
1209: ERRNO := czError;
1210: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
1211: cz_utils.log_report(pkg_name, 'DELETE_DELETED_PUBLICATIONS', null, ERRBUF, fnd_log.LEVEL_ERROR);
1212: RESET_DBMS_INFO;
1213: WHEN DELETE_PUBLICATION_ERROR THEN
1214: ROLLBACK;
1215: ERRNO := czError;

Line 1217: cz_utils.log_report(pkg_name, 'DELETE_DELETED_PUBLICATIONS', null, ERRBUF, fnd_log.LEVEL_ERROR);

1213: WHEN DELETE_PUBLICATION_ERROR THEN
1214: ROLLBACK;
1215: ERRNO := czError;
1216: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
1217: cz_utils.log_report(pkg_name, 'DELETE_DELETED_PUBLICATIONS', null, ERRBUF, fnd_log.LEVEL_ERROR);
1218: RESET_DBMS_INFO;
1219: WHEN REPUBLISH_ERROR THEN
1220: ROLLBACK;
1221: ERRNO := czError;

Line 1223: cz_utils.log_report(pkg_name, 'REPUBLISH_MODELS', null, ERRBUF, fnd_log.LEVEL_ERROR);

1219: WHEN REPUBLISH_ERROR THEN
1220: ROLLBACK;
1221: ERRNO := czError;
1222: ERRBUF := CZ_UTILS.GET_TEXT('REPUBLISH_ERROR');
1223: cz_utils.log_report(pkg_name, 'REPUBLISH_MODELS', null, ERRBUF, fnd_log.LEVEL_ERROR);
1224: RESET_DBMS_INFO;
1225: WHEN REPORT_RESULTS_ERROR THEN
1226: ERRNO := czWarning;
1227: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);

Line 1228: cz_utils.log_report(pkg_name, 'REDO_SEQUENCES', null, ERRBUF, fnd_log.LEVEL_ERROR);

1224: RESET_DBMS_INFO;
1225: WHEN REPORT_RESULTS_ERROR THEN
1226: ERRNO := czWarning;
1227: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);
1228: cz_utils.log_report(pkg_name, 'REDO_SEQUENCES', null, ERRBUF, fnd_log.LEVEL_ERROR);
1229: RESET_DBMS_INFO;
1230: WHEN OTHERS THEN
1231: --'Unable to continue because of %ERRORTEXT'
1232: ROLLBACK;

Line 1235: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);

1231: --'Unable to continue because of %ERRORTEXT'
1232: ROLLBACK;
1233: ERRNO := czError;
1234: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);
1235: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);
1236: RESET_DBMS_INFO;
1237: END;
1238: ------------------------------------------------------------------------------------------
1239:

Line 1277: cz_utils.log_report(pkg_name, 'SYNC_ALL_SOURCE_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);

1273: END IF;
1274:
1275: EXCEPTION
1276: WHEN NO_DATA_FOUND THEN
1277: cz_utils.log_report(pkg_name, 'SYNC_ALL_SOURCE_CP', null, ERRBUF, fnd_log.LEVEL_UNEXPECTED);
1278: END;
1279: ------------------------------------------------------------------------------------------
1280: PROCEDURE SYNC_TARGET_LIST_CP(ERRNO IN OUT NOCOPY NUMBER,
1281: ERRBUF IN OUT NOCOPY VARCHAR2,