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_PUBL_SYNC_CRASH dependencies on CZ_UTILS

Line 69: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);

65: END IF;
66: ELSE
67: /*
68: ERRNO := czError;
69: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);
70: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);
71: return false;
72: */
73: RAISE SERVER_NOT_FOUND;

Line 70: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);

66: ELSE
67: /*
68: ERRNO := czError;
69: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);
70: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);
71: return false;
72: */
73: RAISE SERVER_NOT_FOUND;
74: END IF;

Line 79: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);

75: EXCEPTION
76: WHEN OTHERS THEN
77: /*
78: ERRNO := czError;
79: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);
80: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);
81: return false;
82: */
83: RAISE VALIDATE_SERVER_ERROR;

Line 80: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);

76: WHEN OTHERS THEN
77: /*
78: ERRNO := czError;
79: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);
80: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);
81: return false;
82: */
83: RAISE VALIDATE_SERVER_ERROR;
84: END validateServer;

Line 123: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName,'DATABASE',lSid);

119: IF ((upper(lSid) = upper(lServerName)) and (upper(lHost) = upper(lHostName))) THEN
120: return true;
121: ELSE
122: /* ERRNO := czError;
123: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName,'DATABASE',lSid);
124: return false; */
125: RAISE DB_TNS_INCORRECT;
126: END IF;
127: END IF;

Line 131: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);

127: END IF;
128: ELSE
129: /*
130: ERRNO := czError;
131: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);
132: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);
133: return false;
134: */
135: RAISE SERVER_NOT_FOUND;

Line 132: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);

128: ELSE
129: /*
130: ERRNO := czError;
131: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);
132: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.VALIDATE_SERVER',11276);
133: return false;
134: */
135: RAISE SERVER_NOT_FOUND;
136: END IF;

Line 221: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

217: COMMIT;
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:

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 316: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

312: EXCEPTION
313: WHEN OTHERS THEN
314: /*
315: ERRNO := czError;
316: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
317: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.SYNC_ALL_SOURCE_CP',11276);
318: */
319: RAISE DELETE_PUBLICATION_ERROR;
320: END DELETE_PUBLICATION;

Line 317: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.SYNC_ALL_SOURCE_CP',11276);

313: WHEN OTHERS THEN
314: /*
315: ERRNO := czError;
316: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
317: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.SYNC_ALL_SOURCE_CP',11276);
318: */
319: RAISE DELETE_PUBLICATION_ERROR;
320: END DELETE_PUBLICATION;
321:

Line 426: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

422: EXCEPTION
423: WHEN OTHERS THEN
424: /*
425: ERRNO := czError;
426: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
427: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.SYNC_ALL_SOURCE_CP',11276);
428: */
429: RAISE DELETE_DEL_PUBLICATION_ERROR;
430: END DELETE_DELETED_PUBLICATIONS ;

Line 427: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.SYNC_ALL_SOURCE_CP',11276);

423: WHEN OTHERS THEN
424: /*
425: ERRNO := czError;
426: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
427: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.SYNC_ALL_SOURCE_CP',11276);
428: */
429: RAISE DELETE_DEL_PUBLICATION_ERROR;
430: END DELETE_DELETED_PUBLICATIONS ;
431: ------------------------------------------------------------------------------------------

Line 591: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MODEL_NOT_FOUND', 'PUBID', lPublicationId);

587: 'and ps.name = p.name' ;
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

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 608: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MODEL_NOT_FOUND', 'PUBID', lPublicationId);

604: 'and ui.name = u.name' ;
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;

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 614: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

610: -- RAISE SOURCE_UI_NOT_FOUND;
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

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 705: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

701: WHEN OTHERS THEN
702: RAISE CREATE_PUBLICATION_ERROR;
703: /*
704: ERRNO := czError;
705: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
706: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.CREATE_PUBLICATION_DATA',11276);
707: */
708: END CREATE_PUBLICATION_DATA ;
709: ------------------------------------------------------------------------------------------

Line 706: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.CREATE_PUBLICATION_DATA',11276);

702: RAISE CREATE_PUBLICATION_ERROR;
703: /*
704: ERRNO := czError;
705: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
706: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.CREATE_PUBLICATION_DATA',11276);
707: */
708: END CREATE_PUBLICATION_DATA ;
709: ------------------------------------------------------------------------------------------
710: /* Redo item/ property sequences */

Line 795: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

791: WHEN OTHERS THEN
792: RAISE REDO_SEQUENCE_ERROR;
793: /*
794: ERRNO := czError;
795: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
796: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC.REDO_SEQUENCES',11276);
797: */
798: END;
799: ------------------------------------------------------------------------------------------

Line 796: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC.REDO_SEQUENCES',11276);

792: RAISE REDO_SEQUENCE_ERROR;
793: /*
794: ERRNO := czError;
795: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');
796: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC.REDO_SEQUENCES',11276);
797: */
798: END;
799: ------------------------------------------------------------------------------------------
800: PROCEDURE republish_models (ERRNO IN OUT NOCOPY NUMBER,

Line 846: ERRBUF := CZ_UTILS.GET_TEXT('CZ_REPUBLISH_ERROR','PUBL_ID',v_pub_tbl(i),'ERROR',SQLERRM);

842: IF (commitYesNo = 0 ) THEN
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;

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 853: ERRBUF := CZ_UTILS.GET_TEXT('CZ_REPUBLISH','PUBL_ID',v_pub_tbl(i));

849: ok_count := ok_count + 1;
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;

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 906: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_SOURCE');

902: WHEN OTHERS THEN
903: RAISE INCORRECT_SOURCE;
904: /*
905: ERRNO := czError;
906: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_SOURCE');
907: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.ValidateSource',11276);
908: */
909: END ValidateSource;
910:

Line 907: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.ValidateSource',11276);

903: RAISE INCORRECT_SOURCE;
904: /*
905: ERRNO := czError;
906: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_SOURCE');
907: xERROR := CZ_UTILS.REPORT(ERRBUF,1,'CZ_PUBL_SYNC_CRASH.ValidateSource',11276);
908: */
909: END ValidateSource;
910:
911: ------------------------------------------------------------------------------------------

Line 961: ERRBUF := CZ_UTILS.GET_TEXT(sqlerrm);

957: EXCEPTION
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;

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 967: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SERVER_NOT_SOURCE','SERVERNAME',lServerName);

963: RESET_DBMS_INFO;
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;

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 973: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);

969: RESET_DBMS_INFO;
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;

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 979: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);

975: RESET_DBMS_INFO;
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;

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 985: ERRBUF := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','LINK_NAME', lLinkName);

981: RESET_DBMS_INFO;
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;

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 991: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName);

987: RESET_DBMS_INFO;
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;

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 997: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);

993: RESET_DBMS_INFO;
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;

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 1003: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

999: RESET_DBMS_INFO;
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;

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 1009: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MODEL_NOT_FOUND', 'MODELID', n_Source_Model_Id);

1005: RESET_DBMS_INFO;
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;

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 1015: ERRBUF := CZ_UTILS.GET_TEXT('CZ_UI_MODEL_NOT_FOUND', 'MODELID', n_Source_Model_Id);

1011: RESET_DBMS_INFO;
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

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 1022: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

1018: */
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;

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 1028: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);

1024: RESET_DBMS_INFO;
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;

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 1033: ERRBUF := CZ_UTILS.GET_TEXT('CZ_NO_SEQ_INCREMENT_VAL');

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');
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

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 1039: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);

1035: RESET_DBMS_INFO;
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'

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 1046: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);

1042: WHEN OTHERS THEN
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: ------------------------------------------------------------------------------------------

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 1076: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_SYNC','SERVERNAME',l_server_name);

1072: LOOP
1073: BEGIN
1074: FETCH c_get_all_remote_servers INTO l_server_id, l_server_name;
1075: EXIT WHEN c_get_all_remote_servers%NOTFOUND;
1076: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_SYNC','SERVERNAME',l_server_name);
1077: CZ_PUBL_SYNC_CRASH.SYNC_SINGLE_SOURCE_CP(ERRNO,ERRBUF,p_run_id,l_server_id);
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: ERRNO := 2;

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 1144: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SERVER_NOT_SOURCE');

1140: END;
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

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 1151: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_TARGET');

1147: **/
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;

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 1162: ERRBUF := CZ_UTILS.GET_TEXT(sqlerrm);

1158: EXCEPTION
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;

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 1168: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SERVER_NOT_SOURCE','SERVERNAME',lServerName);

1164: RESET_DBMS_INFO;
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;

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 1174: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);

1170: RESET_DBMS_INFO;
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;

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 1180: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_NOT_FOUND','SERVERNAME',lServerName);

1176: RESET_DBMS_INFO;
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;

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 1186: ERRBUF := CZ_UTILS.GET_TEXT('CZ_DB_LINK_IS_DOWN','LINK_NAME', lLinkName);

1182: RESET_DBMS_INFO;
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;

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 1192: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName);

1188: RESET_DBMS_INFO;
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;

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 1198: ERRBUF := CZ_UTILS.GET_TEXT(SQLERRM);

1194: RESET_DBMS_INFO;
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;

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 1204: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_TARGET','SERVERNAME',lServerName);

1200: RESET_DBMS_INFO;
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;

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 1210: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

1206: RESET_DBMS_INFO;
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;

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 1216: ERRBUF := CZ_UTILS.GET_TEXT('SQLERRM');

1212: RESET_DBMS_INFO;
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;

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 1222: ERRBUF := CZ_UTILS.GET_TEXT('REPUBLISH_ERROR');

1218: RESET_DBMS_INFO;
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;

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 1227: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR','ERRORTEXT', SQLERRM);

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);
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'

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 1234: ERRBUF := CZ_UTILS.GET_TEXT('CZ_GENERAL_ERROR', 'ERRORTEXT', SQLERRM);

1230: WHEN OTHERS THEN
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: ------------------------------------------------------------------------------------------

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 1270: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName,'DATABASE',lSid);

1266: IF ((upper(lSid) = upper(lServerName)) and (upper(lHost) = upper(lHostName))) THEN
1267: return true;
1268: ELSE
1269: /* ERRNO := czError;
1270: ERRBUF := CZ_UTILS.GET_TEXT('CZ_SOURCE_MISMATCH','SERVERNAME',lServerName,'DATABASE',lSid);
1271: return false; */
1272: RAISE TNS_INCORRECT;
1273: END IF;
1274:

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,