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

Line 38: errbuf := cz_utils.get_text('CZ_SYNC_CONCURRENT_ERROR');

34: IF(ErrorFlag = ERROR_FLAG_ERROR)THEN
35:
36: retcode := CONCURRENT_ERROR;
37: --'Syncronization failed, please see log for details'
38: errbuf := cz_utils.get_text('CZ_SYNC_CONCURRENT_ERROR');
39: END IF;
40: END;
41: ---------------------------------------------------------------------------------------
42: --Verifies the specified model against the corresponding bill in the specified target

Line 64: errbuf := cz_utils.get_text('CZ_SYNC_CONCURRENT_ERROR');

60: IF(ErrorFlag = ERROR_FLAG_ERROR)THEN
61:
62: retcode := CONCURRENT_ERROR;
63: --'Syncronization failed, please see log for details'
64: errbuf := cz_utils.get_text('CZ_SYNC_CONCURRENT_ERROR');
65: END IF;
66: END;
67: ---------------------------------------------------------------------------------------
68: --Verifies all the models in one instance against to corresponding bills in the specified

Line 89: errbuf := cz_utils.get_text('CZ_SYNC_CONCURRENT_ERROR');

85: IF(ErrorFlag = ERROR_FLAG_ERROR)THEN
86:
87: retcode := CONCURRENT_ERROR;
88: --'Syncronization failed, please see log for details'
89: errbuf := cz_utils.get_text('CZ_SYNC_CONCURRENT_ERROR');
90: END IF;
91: END;
92: ---------------------------------------------------------------------------------------
93: --Verifies the specified model against the corresponding bill in the specified target

Line 259: cz_utils.log_report('cz_bom_synch', 'BOM Synchronization', nDebug, inMessage, l_log_level);

255: l_log_level := fnd_log.LEVEL_STATEMENT;
256: END IF;
257:
258: -- passing null routime name and nDebug
259: cz_utils.log_report('cz_bom_synch', 'BOM Synchronization', nDebug, inMessage, l_log_level);
260:
261: --Bug #4318949.
262: IF((inUrgency <= p_log_level + 1) AND (FND_GLOBAL.CONC_REQUEST_ID > 0))THEN
263: FND_FILE.PUT_LINE(FND_FILE.LOG, inMessage);

Line 336: report(CZ_UTILS.GET_TEXT('CZ_SYNC_BAD_DATABASE_LINK', 'LINKNAME', inLinkName, 'ERRORTEXT', SQLERRM), URGENCY_ERROR);

332:
333: EXCEPTION
334: WHEN OTHERS THEN
335: --'Problem accessing database link ''%LINKNAME'': %ERRORTEXT'
336: report(CZ_UTILS.GET_TEXT('CZ_SYNC_BAD_DATABASE_LINK', 'LINKNAME', inLinkName, 'ERRORTEXT', SQLERRM), URGENCY_ERROR);
337: RAISE CZ_SYNC_GENERAL_EXCEPTION;
338: END;
339: END; --verify_database_link
340: ---------------------------------------------------------------------------------------

Line 363: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_SOURCE', 'SERVERID', sourceServer), URGENCY_ERROR);

359:
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: --'Unable to resolve import source server with server id: %SERVERID'
363: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_SOURCE', 'SERVERID', sourceServer), URGENCY_ERROR);
364: RAISE CZ_SYNC_GENERAL_EXCEPTION;
365: END;
366:
367: IF(linkName IS NOT NULL)THEN

Line 383: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SOURCE_LINK', 'TARGETNAME', instanceName), URGENCY_ERROR);

379:
380: EXCEPTION
381: WHEN CZ_SYNC_NO_DATABASE_LINK THEN
382: --'Database link does not exist for the import source instance ''%TARGETNAME'''
383: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SOURCE_LINK', 'TARGETNAME', instanceName), URGENCY_ERROR);
384: RAISE CZ_SYNC_GENERAL_EXCEPTION;
385: END;
386: ---------------------------------------------------------------------------------------
387: --build_structure_map->execute_model

Line 472: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INVALID_ITEM_ID', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);

468: RETURN TO_NUMBER(NVL(SUBSTR(tabItemOrigSysRef(j), 1, INSTR(tabItemOrigSysRef(j), ORIGINAL_SEPARATOR) - 1), 'NULL'));
469: EXCEPTION
470: WHEN OTHERS THEN
471: --'Unable to extract item id for item ''%ITEMNAME'' in configuration model ''%MODELNAME'''
472: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INVALID_ITEM_ID', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);
473: RETURN NULL;
474: END; --extract_item_id
475: ---------------------------------------------------------------------------------------
476: --build_structure_map->execute_model->execute_structure_map->extract_project_reference

Line 709: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_PROP_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);

705: END IF;
706: IF((l_flag = 1) OR ((l_val IS NULL) <> (elementValue IS NULL)) OR (RTRIM(l_val) <> RTRIM(elementValue)))THEN
707: IF (l_src_application_id=APC_APPL_ID) THEN
708: --The value of the user-defined attribute ATTRIBUTENAME for Inventory Item ITEMNAME with parent PARENTNAME does not match the corresponding Property value.
709: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_PROP_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
710: ELSE
711: --'Value of descriptive element ''%ELEMENTNAME'' for inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not match with corresponding property value'
712: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VALUE_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
713: END IF;

Line 712: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VALUE_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);

708: --The value of the user-defined attribute ATTRIBUTENAME for Inventory Item ITEMNAME with parent PARENTNAME does not match the corresponding Property value.
709: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_PROP_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
710: ELSE
711: --'Value of descriptive element ''%ELEMENTNAME'' for inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not match with corresponding property value'
712: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VALUE_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
713: END IF;
714: END IF;
715:
716: EXCEPTION

Line 720: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_NOT_PRESENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);

716: EXCEPTION
717: WHEN NO_DATA_FOUND THEN
718: IF (l_src_application_id=APC_APPL_ID) THEN
719: --The Inventory Item ITEMNAME with parent PARENTNAME does not contain the user-defined attribute ATTRIBUTENAME.
720: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_NOT_PRESENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
721: ELSE
722: --'Inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not have descriptive element ''%ELEMENTNAME'''
723: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SUCH_ELEMENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
724: END IF;

Line 723: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SUCH_ELEMENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);

719: --The Inventory Item ITEMNAME with parent PARENTNAME does not contain the user-defined attribute ATTRIBUTENAME.
720: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_NOT_PRESENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
721: ELSE
722: --'Inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not have descriptive element ''%ELEMENTNAME'''
723: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SUCH_ELEMENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
724: END IF;
725: END;
726: END LOOP;
727: END; --verify_item_properties

Line 743: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_CATALOG_GROUP', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'MODELNAME', generate_name, 'TYPENAME', typeName), URGENCY_WARNING);

739:
740: IF(itemCatalogGroupId IS NULL)THEN
741:
742: --'Inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' is not assigned to any catalog group. Its corresponding item in model ''%MODELNAME'' is assigned to type ''%TYPENAME'''
743: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_CATALOG_GROUP', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'MODELNAME', generate_name, 'TYPENAME', typeName), URGENCY_WARNING);
744: RETURN;
745: END IF;
746:
747: catalog_group_id_map(catalogId) := itemCatalogGroupId;

Line 779: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MODEL_NO_BILL', 'MODELNAME', generate_name), URGENCY_WARNING);

775:
776: IF(j = jRootNode)THEN
777:
778: --'There is no root bill for configuration model ''%MODELNAME'', unable to verify the model'
779: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MODEL_NO_BILL', 'MODELNAME', generate_name), URGENCY_WARNING);
780: ELSE
781:
782: --'Item ''%ITEMNAME'' in configuration model ''%MODELNAME'' has no corresponding bill'
783: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_BILL', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);

Line 783: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_BILL', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);

779: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MODEL_NO_BILL', 'MODELNAME', generate_name), URGENCY_WARNING);
780: ELSE
781:
782: --'Item ''%ITEMNAME'' in configuration model ''%MODELNAME'' has no corresponding bill'
783: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_BILL', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);
784: END IF;
785: RETURN;
786: END;
787:

Line 883: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');

879: IF(slidePointer > childrenLast)THEN
880:
881: IF(bomItemType = ORACLE_BOM_MODEL)THEN
882:
883: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
884: ELSIF(bomItemType = ORACLE_BOM_OPTIONCLASS)THEN
885:
886: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
887: ELSIF(bomItemType = ORACLE_BOM_STANDARD)THEN

Line 886: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');

882:
883: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
884: ELSIF(bomItemType = ORACLE_BOM_OPTIONCLASS)THEN
885:
886: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
887: ELSIF(bomItemType = ORACLE_BOM_STANDARD)THEN
888:
889: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
890: ELSE

Line 889: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');

885:
886: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
887: ELSIF(bomItemType = ORACLE_BOM_STANDARD)THEN
888:
889: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
890: ELSE
891:
892: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_UNKNOWN_BOM');
893: END IF;

Line 892: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_UNKNOWN_BOM');

888:
889: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
890: ELSE
891:
892: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_UNKNOWN_BOM');
893: END IF;
894:
895: IF(localParentType = PS_NODE_TYPE_BOM_MODEL)THEN
896:

Line 897: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');

893: END IF;
894:
895: IF(localParentType = PS_NODE_TYPE_BOM_MODEL)THEN
896:
897: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
898: ELSIF(localParentType = PS_NODE_TYPE_BOM_OPTIONCLASS)THEN
899:
900: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
901: ELSIF(localParentType = PS_NODE_TYPE_BOM_STANDARD)THEN

Line 900: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');

896:
897: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
898: ELSIF(localParentType = PS_NODE_TYPE_BOM_OPTIONCLASS)THEN
899:
900: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
901: ELSIF(localParentType = PS_NODE_TYPE_BOM_STANDARD)THEN
902:
903: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
904: ELSE

Line 903: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');

899:
900: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
901: ELSIF(localParentType = PS_NODE_TYPE_BOM_STANDARD)THEN
902:
903: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
904: ELSE
905:
906: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');
907: END IF;

Line 906: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');

902:
903: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
904: ELSE
905:
906: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');
907: END IF;
908:
909: --'%ITEMTYPE ''%ITEMNAME'' with parent %PARENTTYPE ''%PARENTNAME'' has no match in configuration model ''%MODELNAME'''
910: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INV_NO_MATCH', 'ITEMTYPE', l_item_type_msg, 'ITEMNAME', itemConcatSegments,

Line 910: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INV_NO_MATCH', 'ITEMTYPE', l_item_type_msg, 'ITEMNAME', itemConcatSegments,

906: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');
907: END IF;
908:
909: --'%ITEMTYPE ''%ITEMNAME'' with parent %PARENTTYPE ''%PARENTNAME'' has no match in configuration model ''%MODELNAME'''
910: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INV_NO_MATCH', 'ITEMTYPE', l_item_type_msg, 'ITEMNAME', itemConcatSegments,
911: 'PARENTTYPE', l_parent_type_msg, 'PARENTNAME', localParentName, 'MODELNAME', generate_name),
912: URGENCY_WARNING);
913:
914: ELSE

Line 922: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_MATCH', 'ITEMNAME', tabRefPartNbr(i), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

918:
919: FOR i IN startPointer..slidePointer - 1 LOOP
920:
921: --'Item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'' cannot be matched with any inventory item'
922: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_MATCH', 'ITEMNAME', tabRefPartNbr(i), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
923:
924: END LOOP;
925:
926: debug('Match found at position: ' || slidePointer || ', comparing items...');

Line 939: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INITIAL_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

935: IF(localString = '0')THEN localString := '1'; END IF;
936: IF(localString <> tabInitNumVal(slidePointer))THEN -- sselahi
937:
938: --'Initial value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
939: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INITIAL_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
940: END IF;
941:
942: IF ( modelEngineType = 'L' OR bomLowQuantity IS NOT NULL ) THEN
943:

Line 954: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MINIMUM_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

950:
951: IF(bomQuantity <> nodeQuantity)THEN
952:
953: --'Minimum value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
954: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MINIMUM_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
955: END IF;
956: END IF;
957:
958: IF ( modelEngineType = 'L' OR bomHighQuantity IS NOT NULL ) THEN

Line 972: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MAXIMUM_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

968:
969: IF(bomQuantity <> nodeQuantity)THEN
970:
971: --'Maximum value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
972: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MAXIMUM_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
973: END IF;
974: END IF;
975:
976: IF(bomMutuallyExclusive = ORACLE_YES AND

Line 980: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MAXIMUM_SELECTED', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

976: IF(bomMutuallyExclusive = ORACLE_YES AND
977: (tabMaximumSelected(slidePointer) IS NULL OR tabMaximumSelected(slidePointer) < 1))THEN
978:
979: --'Maximum selected value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
980: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MAXIMUM_SELECTED', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
981: END IF;
982:
983: IF(bomRequiredFlag <> tabBomRequiredFlag(slidePointer))THEN
984:

Line 986: report(CZ_UTILS.GET_TEXT('CZ_SYNC_BOM_REQUIRED', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

982:
983: IF(bomRequiredFlag <> tabBomRequiredFlag(slidePointer))THEN
984:
985: --'Required when parent is selected property does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
986: report(CZ_UTILS.GET_TEXT('CZ_SYNC_BOM_REQUIRED', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
987: END IF;
988:
989: IF(lastConcatSegments = itemConcatSegments)THEN
990:

Line 998: report(CZ_UTILS.GET_TEXT('CZ_SYNC_EFFECTIVITY_RANGE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

994: IF(bomEffectivityDate <> tabEffectiveFrom(slidePointer) OR
995: bomDisableDate <> tabEffectiveUntil(slidePointer))THEN
996:
997: --'Effectivity range does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
998: report(CZ_UTILS.GET_TEXT('CZ_SYNC_EFFECTIVITY_RANGE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
999: END IF;
1000: ELSE
1001:
1002: --If there are more than one items with the same concatenated_segments, then this is the

Line 1010: report(CZ_UTILS.GET_TEXT('CZ_SYNC_EFFECTIVITY_RANGE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

1006: bomEffectivityDate <> tabEffectiveFrom(slidePointer)) OR
1007: (bomDisableDate <> tabEffectiveUntil(slidePointer)))THEN
1008:
1009: --'Effectivity range does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
1010: report(CZ_UTILS.GET_TEXT('CZ_SYNC_EFFECTIVITY_RANGE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
1011: END IF;
1012: END IF;
1013:
1014: --If a configuration item belongs to an imported item type, the corresponding bom item should

Line 1050: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_MATCH', 'ITEMNAME', tabRefPartNbr(i), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);

1046:
1047: FOR i IN startPointer..childrenLast LOOP
1048:
1049: --'Item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'' cannot be matched with any inventory item'
1050: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_MATCH', 'ITEMNAME', tabRefPartNbr(i), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
1051:
1052: END LOOP;
1053:
1054: debug('Returning to caller after processing children of item id ' || tabPsNodeId(j) || ', item name ''' || tabRefPartNbr(j) || '''');

Line 1196: report(CZ_UTILS.GET_TEXT('CZ_SYNC_UNEXPECTED_STRUCTURE', 'MODELNAME', tabPsNodeName(jRootNode)), URGENCY_ERROR);

1192:
1193: EXCEPTION
1194: WHEN CZ_SYNC_UNEXPECTED_STRUCTURE THEN
1195: --'Configuration model ''%MODELNAME'' has incorrect structure and cannot be synchronized'
1196: report(CZ_UTILS.GET_TEXT('CZ_SYNC_UNEXPECTED_STRUCTURE', 'MODELNAME', tabPsNodeName(jRootNode)), URGENCY_ERROR);
1197: WHEN OTHERS THEN
1198: RAISE;
1199: END; --execute_structure_map
1200: ---------------------------------------------------------------------------------------

Line 1221: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INVALID_ORG_ID', 'MODELNAME', modelName, 'ORIGSYSREF', modelOrigSysRef), URGENCY_WARNING);

1217: RETURN TO_NUMBER(NVL(SUBSTR(modelOrigSysRef, startPos, endPos - startPos), 'NULL'));
1218: EXCEPTION
1219: WHEN OTHERS THEN
1220: --'Unable to extract organization id for model ''%MODELNAME'', original system reference ''%ORIGSYSREF'''
1221: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INVALID_ORG_ID', 'MODELNAME', modelName, 'ORIGSYSREF', modelOrigSysRef), URGENCY_WARNING);
1222: RAISE CZ_SYNC_NO_ORGANIZATION_ID;
1223: END;
1224: ---------------------------------------------------------------------------------------
1225: BEGIN --execute_model

Line 1331: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_MODEL', 'MODELID', p_model_id), URGENCY_WARNING);

1327:
1328: EXCEPTION
1329: WHEN CZ_SYNC_INCORRECT_MODEL THEN
1330: --'Unable to resolve the specified model id: %MODELID'
1331: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_MODEL', 'MODELID', p_model_id), URGENCY_WARNING);
1332: WHEN CZ_SYNC_NO_ORGANIZATION_ID THEN
1333: --'Unable to resolve source organization for the configuration model ''%MODELNAME'''
1334: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ORGANIZATION_ID', 'MODELNAME', modelName), URGENCY_WARNING);
1335: END; --execute_model

Line 1334: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ORGANIZATION_ID', 'MODELNAME', modelName), URGENCY_WARNING);

1330: --'Unable to resolve the specified model id: %MODELID'
1331: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_MODEL', 'MODELID', p_model_id), URGENCY_WARNING);
1332: WHEN CZ_SYNC_NO_ORGANIZATION_ID THEN
1333: --'Unable to resolve source organization for the configuration model ''%MODELNAME'''
1334: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ORGANIZATION_ID', 'MODELNAME', modelName), URGENCY_WARNING);
1335: END; --execute_model
1336: ---------------------------------------------------------------------------------------
1337: --build_structure_map->verify_target_instance
1338:

Line 1358: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_TARGET', 'TARGETNAME', p_target_name), URGENCY_ERROR);

1354:
1355: EXCEPTION
1356: WHEN NO_DATA_FOUND THEN
1357: --'Unable to resolve the specified target instance name: %TARGETNAME'
1358: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_TARGET', 'TARGETNAME', p_target_name), URGENCY_ERROR);
1359: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1360: END;
1361:
1362: IF(linkName IS NOT NULL)THEN

Line 1376: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_DATABASE_LINK', 'TARGETNAME', p_target_name), URGENCY_ERROR);

1372:
1373: EXCEPTION
1374: WHEN CZ_SYNC_NO_DATABASE_LINK THEN
1375: --'Database link does not exist for the specified target instance ''%TARGETNAME'''
1376: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_DATABASE_LINK', 'TARGETNAME', p_target_name), URGENCY_ERROR);
1377: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1378: END; --verify_target_instance
1379: ---------------------------------------------------------------------------------------
1380: --build_structure_map->verify_source_instance

Line 1399: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_MODELS'), URGENCY_ERROR);

1395:
1396: EXCEPTION
1397: WHEN NO_DATA_FOUND THEN
1398: --'Unable to find any imported models to synchronize, import control table is empty'
1399: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_MODELS'), URGENCY_ERROR);
1400: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1401: WHEN TOO_MANY_ROWS THEN
1402: --'Multiple import source servers found, unable to synchronize'
1403: report(CZ_UTILS.GET_TEXT('CZ_SYNC_TOO_MANY_SERVERS'), URGENCY_ERROR);

Line 1403: report(CZ_UTILS.GET_TEXT('CZ_SYNC_TOO_MANY_SERVERS'), URGENCY_ERROR);

1399: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_MODELS'), URGENCY_ERROR);
1400: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1401: WHEN TOO_MANY_ROWS THEN
1402: --'Multiple import source servers found, unable to synchronize'
1403: report(CZ_UTILS.GET_TEXT('CZ_SYNC_TOO_MANY_SERVERS'), URGENCY_ERROR);
1404: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1405: END;
1406:
1407: --Check if any publication is currently processing.

Line 1414: report(CZ_UTILS.GET_TEXT('CZ_SYNC_PUB_PROCESSING'), URGENCY_ERROR);

1410: WHERE deleted_flag = FLAG_NOT_DELETED
1411: AND export_status = PUBLICATION_STATUS_PROCESSING)LOOP
1412:
1413: --'Synchronization cannot be done while a publication is processing. At least one publication (%PUBLICATIONID) is currently in processing status'
1414: report(CZ_UTILS.GET_TEXT('CZ_SYNC_PUB_PROCESSING'), URGENCY_ERROR);
1415: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1416: END LOOP;
1417:
1418: IF(sourceServer = g_target_instance)THEN

Line 1420: report(CZ_UTILS.GET_TEXT('CZ_SYNC_SAME_INSTANCE'), URGENCY_WARNING);

1416: END LOOP;
1417:
1418: IF(sourceServer = g_target_instance)THEN
1419: --'Import source server and synchronization target instance are the same, synchronization is not required'
1420: report(CZ_UTILS.GET_TEXT('CZ_SYNC_SAME_INSTANCE'), URGENCY_WARNING);
1421: RAISE CZ_SYNC_NORMAL_EXCEPTION;
1422: END IF;
1423:
1424: verify_source_server;

Line 1873: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VERSION_INFO', 'VERSION', thisVersionString, 'DATETIME',

1869: thisVersionString := SUBSTR(SUBSTR(GenHeader, INSTR(GenHeader, THIS_FILE_NAME) + LENGTH(THIS_FILE_NAME) + 1), 1,
1870: INSTR(SUBSTR(GenHeader, INSTR(GenHeader, THIS_FILE_NAME) + LENGTH(THIS_FILE_NAME) + 1), ' ') - 1);
1871:
1872: --'Synchronization software version %VERSION started %DATETIME, session run ID: %RUNID'
1873: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VERSION_INFO', 'VERSION', thisVersionString, 'DATETIME',
1874: TO_CHAR(SYSDATE, THIS_DATE_FORMAT),'RUNID', p_run_id), URGENCY_MESSAGE);
1875:
1876: EXCEPTION
1877: WHEN OTHERS THEN

Line 1934: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_LANGUAGE_INFO'), URGENCY_WARNING);

1930:
1931: EXCEPTION
1932: WHEN OTHERS THEN
1933: --'Language information is not available'
1934: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_LANGUAGE_INFO'), URGENCY_WARNING);
1935: END;
1936:
1937: clear_structure_maps;
1938: verify_target_instance;

Line 1961: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ITEM_TYPES', 'ERRORTEXT', SQLERRM), URGENCY_WARNING);

1957:
1958: EXCEPTION
1959: WHEN OTHERS THEN
1960: --'Error while reading item types: %ERRORTEXT'
1961: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ITEM_TYPES', 'ERRORTEXT', SQLERRM), URGENCY_WARNING);
1962: END;
1963:
1964: IF(p_model_id IS NOT NULL)THEN
1965:

Line 2035: report_on_exit(CZ_UTILS.GET_TEXT('CZ_G_GENERAL_ERROR', 'ERRORTEXT', SQLERRM));

2031: p_error_flag := ERROR_FLAG_ERROR;
2032: WHEN OTHERS THEN
2033: p_error_flag := ERROR_FLAG_ERROR;
2034: --'Unable to continue because of %ERRORTEXT'
2035: report_on_exit(CZ_UTILS.GET_TEXT('CZ_G_GENERAL_ERROR', 'ERRORTEXT', SQLERRM));
2036: END; --build_structure_map
2037: ---------------------------------------------------------------------------------------
2038: ---------------------------------------------------------------------------------------
2039: ---------------------------------------------------------------------------------------