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 255: cz_utils.log_report('cz_bom_synch', 'BOM Synchronization', nDebug, inMessage, l_log_level);

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

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

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

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

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

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

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

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

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

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

694: END IF;
695: IF((l_flag = 1) OR ((l_val IS NULL) <> (elementValue IS NULL)) OR (RTRIM(l_val) <> RTRIM(elementValue)))THEN
696: IF (l_src_application_id=APC_APPL_ID) THEN
697: --The value of the user-defined attribute ATTRIBUTENAME for Inventory Item ITEMNAME with parent PARENTNAME does not match the corresponding Property value.
698: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_PROP_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
699: ELSE
700: --'Value of descriptive element ''%ELEMENTNAME'' for inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not match with corresponding property value'
701: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VALUE_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
702: END IF;

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

697: --The value of the user-defined attribute ATTRIBUTENAME for Inventory Item ITEMNAME with parent PARENTNAME does not match the corresponding Property value.
698: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_PROP_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
699: ELSE
700: --'Value of descriptive element ''%ELEMENTNAME'' for inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not match with corresponding property value'
701: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VALUE_NO_MATCH', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
702: END IF;
703: END IF;
704:
705: EXCEPTION

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

705: EXCEPTION
706: WHEN NO_DATA_FOUND THEN
707: IF (l_src_application_id=APC_APPL_ID) THEN
708: --The Inventory Item ITEMNAME with parent PARENTNAME does not contain the user-defined attribute ATTRIBUTENAME.
709: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_NOT_PRESENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
710: ELSE
711: --'Inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not have descriptive element ''%ELEMENTNAME'''
712: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SUCH_ELEMENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
713: END IF;

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

708: --The Inventory Item ITEMNAME with parent PARENTNAME does not contain the user-defined attribute ATTRIBUTENAME.
709: report(CZ_UTILS.GET_TEXT('CZ_SYN_USR_ATTR_NOT_PRESENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ATTRIBUTENAME', c_prop.name), URGENCY_WARNING);
710: ELSE
711: --'Inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' does not have descriptive element ''%ELEMENTNAME'''
712: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_SUCH_ELEMENT', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'ELEMENTNAME', c_prop.name), URGENCY_WARNING);
713: END IF;
714: END;
715: END LOOP;
716: END; --verify_item_properties

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

728:
729: IF(itemCatalogGroupId IS NULL)THEN
730:
731: --'Inventory item ''%ITEMNAME'' with parent ''%PARENTNAME'' is not assigned to any catalog group. Its corresponding item in model ''%MODELNAME'' is assigned to type ''%TYPENAME'''
732: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_CATALOG_GROUP', 'ITEMNAME', itemConcatSegments, 'PARENTNAME', localParentName, 'MODELNAME', generate_name, 'TYPENAME', typeName), URGENCY_WARNING);
733: RETURN;
734: END IF;
735:
736: catalog_group_id_map(catalogId) := itemCatalogGroupId;

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

764:
765: IF(j = jRootNode)THEN
766:
767: --'There is no root bill for configuration model ''%MODELNAME'', unable to verify the model'
768: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MODEL_NO_BILL', 'MODELNAME', generate_name), URGENCY_WARNING);
769: ELSE
770:
771: --'Item ''%ITEMNAME'' in configuration model ''%MODELNAME'' has no corresponding bill'
772: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_BILL', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);

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

768: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MODEL_NO_BILL', 'MODELNAME', generate_name), URGENCY_WARNING);
769: ELSE
770:
771: --'Item ''%ITEMNAME'' in configuration model ''%MODELNAME'' has no corresponding bill'
772: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_BILL', 'ITEMNAME', tabRefPartNbr(j), 'MODELNAME', generate_name), URGENCY_WARNING);
773: END IF;
774: RETURN;
775: END;
776:

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

868: IF(slidePointer > childrenLast)THEN
869:
870: IF(bomItemType = ORACLE_BOM_MODEL)THEN
871:
872: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
873: ELSIF(bomItemType = ORACLE_BOM_OPTIONCLASS)THEN
874:
875: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
876: ELSIF(bomItemType = ORACLE_BOM_STANDARD)THEN

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

871:
872: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
873: ELSIF(bomItemType = ORACLE_BOM_OPTIONCLASS)THEN
874:
875: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
876: ELSIF(bomItemType = ORACLE_BOM_STANDARD)THEN
877:
878: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
879: ELSE

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

874:
875: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
876: ELSIF(bomItemType = ORACLE_BOM_STANDARD)THEN
877:
878: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
879: ELSE
880:
881: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_UNKNOWN_BOM');
882: END IF;

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

877:
878: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
879: ELSE
880:
881: l_item_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_UNKNOWN_BOM');
882: END IF;
883:
884: IF(localParentType = PS_NODE_TYPE_BOM_MODEL)THEN
885:

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

882: END IF;
883:
884: IF(localParentType = PS_NODE_TYPE_BOM_MODEL)THEN
885:
886: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
887: ELSIF(localParentType = PS_NODE_TYPE_BOM_OPTIONCLASS)THEN
888:
889: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
890: ELSIF(localParentType = PS_NODE_TYPE_BOM_STANDARD)THEN

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

885:
886: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_BOM_MODEL');
887: ELSIF(localParentType = PS_NODE_TYPE_BOM_OPTIONCLASS)THEN
888:
889: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
890: ELSIF(localParentType = PS_NODE_TYPE_BOM_STANDARD)THEN
891:
892: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
893: ELSE

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

888:
889: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_OPTION_CLASS');
890: ELSIF(localParentType = PS_NODE_TYPE_BOM_STANDARD)THEN
891:
892: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
893: ELSE
894:
895: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');
896: END IF;

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

891:
892: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_STD_ITEM');
893: ELSE
894:
895: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');
896: END IF;
897:
898: --'%ITEMTYPE ''%ITEMNAME'' with parent %PARENTTYPE ''%PARENTNAME'' has no match in configuration model ''%MODELNAME'''
899: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INV_NO_MATCH', 'ITEMTYPE', l_item_type_msg, 'ITEMNAME', itemConcatSegments,

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

895: l_parent_type_msg := CZ_UTILS.GET_TEXT('CZ_DEV_TEXT_NON_BOM');
896: END IF;
897:
898: --'%ITEMTYPE ''%ITEMNAME'' with parent %PARENTTYPE ''%PARENTNAME'' has no match in configuration model ''%MODELNAME'''
899: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INV_NO_MATCH', 'ITEMTYPE', l_item_type_msg, 'ITEMNAME', itemConcatSegments,
900: 'PARENTTYPE', l_parent_type_msg, 'PARENTNAME', localParentName, 'MODELNAME', generate_name),
901: URGENCY_WARNING);
902:
903: ELSE

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

907:
908: FOR i IN startPointer..slidePointer - 1 LOOP
909:
910: --'Item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'' cannot be matched with any inventory item'
911: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_MATCH', 'ITEMNAME', tabRefPartNbr(i), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
912:
913: END LOOP;
914:
915: debug('Match found at position: ' || slidePointer || ', comparing items...');

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

924: IF(localString = '0')THEN localString := '1'; END IF;
925: IF(localString <> tabInitNumVal(slidePointer))THEN -- sselahi
926:
927: --'Initial value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
928: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INITIAL_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
929: END IF;
930:
931: IF ( modelEngineType = 'L' OR bomLowQuantity IS NOT NULL ) THEN
932:

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

939:
940: IF(bomQuantity <> nodeQuantity)THEN
941:
942: --'Minimum value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
943: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MINIMUM_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
944: END IF;
945: END IF;
946:
947: IF ( modelEngineType = 'L' OR bomHighQuantity IS NOT NULL ) THEN

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

957:
958: IF(bomQuantity <> nodeQuantity)THEN
959:
960: --'Maximum value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
961: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MAXIMUM_VALUE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
962: END IF;
963: END IF;
964:
965: IF(bomMutuallyExclusive = ORACLE_YES AND

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

965: IF(bomMutuallyExclusive = ORACLE_YES AND
966: (tabMaximumSelected(slidePointer) IS NULL OR tabMaximumSelected(slidePointer) < 1))THEN
967:
968: --'Maximum selected value does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
969: report(CZ_UTILS.GET_TEXT('CZ_SYNC_MAXIMUM_SELECTED', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
970: END IF;
971:
972: IF(bomRequiredFlag <> tabBomRequiredFlag(slidePointer))THEN
973:

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

971:
972: IF(bomRequiredFlag <> tabBomRequiredFlag(slidePointer))THEN
973:
974: --'Required when parent is selected property does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
975: report(CZ_UTILS.GET_TEXT('CZ_SYNC_BOM_REQUIRED', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
976: END IF;
977:
978: IF(lastConcatSegments = itemConcatSegments)THEN
979:

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

983: IF(bomEffectivityDate <> tabEffectiveFrom(slidePointer) OR
984: bomDisableDate <> tabEffectiveUntil(slidePointer))THEN
985:
986: --'Effectivity range does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
987: report(CZ_UTILS.GET_TEXT('CZ_SYNC_EFFECTIVITY_RANGE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
988: END IF;
989: ELSE
990:
991: --If there are more than one items with the same concatenated_segments, then this is the

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

995: bomEffectivityDate <> tabEffectiveFrom(slidePointer)) OR
996: (bomDisableDate <> tabEffectiveUntil(slidePointer)))THEN
997:
998: --'Effectivity range does not match for item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'''
999: report(CZ_UTILS.GET_TEXT('CZ_SYNC_EFFECTIVITY_RANGE', 'ITEMNAME', tabRefPartNbr(slidePointer), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
1000: END IF;
1001: END IF;
1002:
1003: --If a configuration item belongs to an imported item type, the corresponding bom item should

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

1035:
1036: FOR i IN startPointer..childrenLast LOOP
1037:
1038: --'Item ''%ITEMNAME'' with parent ''%PARENTNAME'' in configuration model ''%MODELNAME'' cannot be matched with any inventory item'
1039: report(CZ_UTILS.GET_TEXT('CZ_SYNC_ITEM_NO_MATCH', 'ITEMNAME', tabRefPartNbr(i), 'PARENTNAME', localParentName, 'MODELNAME', generate_name), URGENCY_WARNING);
1040:
1041: END LOOP;
1042:
1043: debug('Returning to caller after processing children of item id ' || tabPsNodeId(j) || ', item name ''' || tabRefPartNbr(j) || '''');

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

1181:
1182: EXCEPTION
1183: WHEN CZ_SYNC_UNEXPECTED_STRUCTURE THEN
1184: --'Configuration model ''%MODELNAME'' has incorrect structure and cannot be synchronized'
1185: report(CZ_UTILS.GET_TEXT('CZ_SYNC_UNEXPECTED_STRUCTURE', 'MODELNAME', tabPsNodeName(jRootNode)), URGENCY_ERROR);
1186: WHEN OTHERS THEN
1187: RAISE;
1188: END; --execute_structure_map
1189: ---------------------------------------------------------------------------------------

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

1206: RETURN TO_NUMBER(NVL(SUBSTR(modelOrigSysRef, startPos, endPos - startPos), 'NULL'));
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: --'Unable to extract organization id for model ''%MODELNAME'', original system reference ''%ORIGSYSREF'''
1210: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INVALID_ORG_ID', 'MODELNAME', modelName, 'ORIGSYSREF', modelOrigSysRef), URGENCY_WARNING);
1211: RAISE CZ_SYNC_NO_ORGANIZATION_ID;
1212: END;
1213: ---------------------------------------------------------------------------------------
1214: BEGIN --execute_model

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

1316:
1317: EXCEPTION
1318: WHEN CZ_SYNC_INCORRECT_MODEL THEN
1319: --'Unable to resolve the specified model id: %MODELID'
1320: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_MODEL', 'MODELID', p_model_id), URGENCY_WARNING);
1321: WHEN CZ_SYNC_NO_ORGANIZATION_ID THEN
1322: --'Unable to resolve source organization for the configuration model ''%MODELNAME'''
1323: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ORGANIZATION_ID', 'MODELNAME', modelName), URGENCY_WARNING);
1324: END; --execute_model

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

1319: --'Unable to resolve the specified model id: %MODELID'
1320: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_MODEL', 'MODELID', p_model_id), URGENCY_WARNING);
1321: WHEN CZ_SYNC_NO_ORGANIZATION_ID THEN
1322: --'Unable to resolve source organization for the configuration model ''%MODELNAME'''
1323: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ORGANIZATION_ID', 'MODELNAME', modelName), URGENCY_WARNING);
1324: END; --execute_model
1325: ---------------------------------------------------------------------------------------
1326: --build_structure_map->verify_target_instance
1327:

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

1343:
1344: EXCEPTION
1345: WHEN NO_DATA_FOUND THEN
1346: --'Unable to resolve the specified target instance name: %TARGETNAME'
1347: report(CZ_UTILS.GET_TEXT('CZ_SYNC_INCORRECT_TARGET', 'TARGETNAME', p_target_name), URGENCY_ERROR);
1348: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1349: END;
1350:
1351: IF(linkName IS NOT NULL)THEN

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

1361:
1362: EXCEPTION
1363: WHEN CZ_SYNC_NO_DATABASE_LINK THEN
1364: --'Database link does not exist for the specified target instance ''%TARGETNAME'''
1365: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_DATABASE_LINK', 'TARGETNAME', p_target_name), URGENCY_ERROR);
1366: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1367: END; --verify_target_instance
1368: ---------------------------------------------------------------------------------------
1369: --build_structure_map->verify_source_instance

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

1384:
1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN
1387: --'Unable to find any imported models to synchronize, import control table is empty'
1388: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_MODELS'), URGENCY_ERROR);
1389: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1390: WHEN TOO_MANY_ROWS THEN
1391: --'Multiple import source servers found, unable to synchronize'
1392: report(CZ_UTILS.GET_TEXT('CZ_SYNC_TOO_MANY_SERVERS'), URGENCY_ERROR);

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

1388: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_MODELS'), URGENCY_ERROR);
1389: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1390: WHEN TOO_MANY_ROWS THEN
1391: --'Multiple import source servers found, unable to synchronize'
1392: report(CZ_UTILS.GET_TEXT('CZ_SYNC_TOO_MANY_SERVERS'), URGENCY_ERROR);
1393: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1394: END;
1395:
1396: --Check if any publication is currently processing.

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

1399: WHERE deleted_flag = FLAG_NOT_DELETED
1400: AND export_status = PUBLICATION_STATUS_PROCESSING)LOOP
1401:
1402: --'Synchronization cannot be done while a publication is processing. At least one publication (%PUBLICATIONID) is currently in processing status'
1403: report(CZ_UTILS.GET_TEXT('CZ_SYNC_PUB_PROCESSING'), URGENCY_ERROR);
1404: RAISE CZ_SYNC_GENERAL_EXCEPTION;
1405: END LOOP;
1406:
1407: IF(sourceServer = g_target_instance)THEN

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

1405: END LOOP;
1406:
1407: IF(sourceServer = g_target_instance)THEN
1408: --'Import source server and synchronization target instance are the same, synchronization is not required'
1409: report(CZ_UTILS.GET_TEXT('CZ_SYNC_SAME_INSTANCE'), URGENCY_WARNING);
1410: RAISE CZ_SYNC_NORMAL_EXCEPTION;
1411: END IF;
1412:
1413: verify_source_server;

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

1858: thisVersionString := SUBSTR(SUBSTR(GenHeader, INSTR(GenHeader, THIS_FILE_NAME) + LENGTH(THIS_FILE_NAME) + 1), 1,
1859: INSTR(SUBSTR(GenHeader, INSTR(GenHeader, THIS_FILE_NAME) + LENGTH(THIS_FILE_NAME) + 1), ' ') - 1);
1860:
1861: --'Synchronization software version %VERSION started %DATETIME, session run ID: %RUNID'
1862: report(CZ_UTILS.GET_TEXT('CZ_SYNC_VERSION_INFO', 'VERSION', thisVersionString, 'DATETIME',
1863: TO_CHAR(SYSDATE, THIS_DATE_FORMAT),'RUNID', p_run_id), URGENCY_MESSAGE);
1864:
1865: EXCEPTION
1866: WHEN OTHERS THEN

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

1919:
1920: EXCEPTION
1921: WHEN OTHERS THEN
1922: --'Language information is not available'
1923: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_LANGUAGE_INFO'), URGENCY_WARNING);
1924: END;
1925:
1926: clear_structure_maps;
1927: verify_target_instance;

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

1946:
1947: EXCEPTION
1948: WHEN OTHERS THEN
1949: --'Error while reading item types: %ERRORTEXT'
1950: report(CZ_UTILS.GET_TEXT('CZ_SYNC_NO_ITEM_TYPES', 'ERRORTEXT', SQLERRM), URGENCY_WARNING);
1951: END;
1952:
1953: IF(p_model_id IS NOT NULL)THEN
1954:

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

2020: p_error_flag := ERROR_FLAG_ERROR;
2021: WHEN OTHERS THEN
2022: p_error_flag := ERROR_FLAG_ERROR;
2023: --'Unable to continue because of %ERRORTEXT'
2024: report_on_exit(CZ_UTILS.GET_TEXT('CZ_G_GENERAL_ERROR', 'ERRORTEXT', SQLERRM));
2025: END; --build_structure_map
2026: ---------------------------------------------------------------------------------------
2027: ---------------------------------------------------------------------------------------
2028: ---------------------------------------------------------------------------------------