Results for “return_transpose_phone”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_STD is a shared utility package body in the APPS schema that supports Oracle E-Business Suite's Service (CS) modules, including TeleService, Field Service, and Depot Repair. Its central role is to consolidate repetitive lookup, validation, and formatting logic that would otherwise be duplicated across forms, APIs, and concurrent programs. The package resolves display-level information — customer names, system names, item revisions, site addresses, and phone numbers — and applies Oracle-standard naming and messaging conventions through FND_MESSAGE, FND_API, and FND_PROFILE. In EBS 12.1.1 and 12.2.2 the body remains VALID and is documented with API classification OTHER, meaning it is an internal helper rather than a public, formally versioned API. The package is heavily depended upon: it is referenced by 95 other packages, and it is not itself referenced by any database object, confirming its position as a leaf-level utility that others call downward. It cites dependencies on APP_EXCEPTION, FND_API, FND_MESSAGE, FND_PROFILE, and HZ_FORMAT_PUB, indicating adherence to the EBS error-handling and formatting standards.

Key Procedures and Functions

The metadata documents 27 procedures and functions. Among them:

• GET_DEFAULT_VALUES — returns default field values for service forms, typically seeded from profile options.
• GET_CONTACT_PHONE, RETURN_PRIMARY_PHONE, RETURN_TRANSPOSE_PHONE — retrieve and normalize telephone numbers for contacts and parties.
• GET_ITEM_REV_DESC — returns the description of a given item revision from MTL_ITEM_REVISIONS.
• GET_SITE_USE_LOCATION, SITE_USE_ADDRESS, GET_ADDRESS_FROM_ID — resolve address identifiers to formatted site-use locations.
• GET_CUST_NAME, GET_PRIMARY_ADDRESS — fetch customer party name and primary address from HZ_PARTIES.
• GET_WAR_ITEM_IDS — return warranty item identifiers associated with a service system.
• GET_SYSTEM_NAME — resolve a CS_SYSTEMS identifier to its display name.
• WARRANTY_EXISTS — tests whether warranty coverage exists for a given item or system.
• CS_GET_SERVICED_STATUS — returns the serviced status of an installed base record.
• OUTPUT_MESSAGES — emits accumulated FND_MESSAGE errors to the calling form.
• GETNEXTVALINPERIOD — obtains the next sequence value within a period context.
• GETITEMCATEGORY, GET_ITEM_VALDN_ORGZN_ID — resolve item category assignments and the validating organization.
• FORMAT_ADDRESS, FORMAT_ADDRESS_CONCAT — apply HZ_FORMAT_PUB address formatting rules, with concatenation.

Tables Accessed

Documented table access runs through APPS synonyms. Customer and contact data come from HZ_PARTIES, HZ_PARTY_SITES, HZ_CONTACT_POINTS, PER_ALL_PEOPLE_F, and PER_PHONES. Installed base and service data come from CS_SYSTEMS and CSC_PROF_CHECK_RESULTS. Item and inventory metadata come from MTL_SYSTEM_ITEMS, MTL_ITEM_REVISIONS, MTL_CATEGORIES, MTL_ITEM_CATEGORIES, MTL_DEFAULT_CATEGORY_SETS, and MTL_UNITS_OF_MEASURE. These reads support name lookups, revision descriptions, category resolution, and unit-of-measure display. The package performs no documented writes; its function is read-oriented enrichment and validation.

Usage Notes

CS_STD is invoked implicitly by Service forms (for example, the TeleService and Field Service windows) and by the 95 dependent packages that require standardized address, phone, item, and warranty lookups. Because it is an internal utility, custom code should not treat it as a supported public API; Oracle recommends using the documented HZ_FORMAT_PUB and FND_API entry points directly where equivalent functionality exists. Profile values retrieved through FND_PROFILE and messages raised via FND_MESSAGE mean behavior is affected by site-level setup. When troubleshooting display or validation anomalies in Service modules, CS_STD is a common root cause candidate, particularly where customer names, addresses, or item revisions appear incorrectly.