APPS.WSH_FLEXFIELD_UTILS dependencies on WSH_FLEXFIELD_UTILS

Line 1: PACKAGE BODY WSH_FLEXFIELD_UTILS as

1: PACKAGE BODY WSH_FLEXFIELD_UTILS as
2: /* $Header: WSHFFUTB.pls 120.1.12000000.3 2007/03/30 09:36:11 nchellam ship $ */
3:
4: -- Private Type Definintions
5:

Line 53: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FLEXFIELD_UTILS';

49: *****/
50:
51:
52: --
53: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FLEXFIELD_UTILS';
54: --
55: PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
56: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
57: flexfield OUT NOCOPY fnd_dflex.dflex_r,

Line 58: flexinfo OUT NOCOPY wsh_flexfield_utils.dflex_dr)

54: --
55: PROCEDURE get_flexfield(appl_short_name IN fnd_application.application_short_name%TYPE,
56: flexfield_name IN fnd_descriptive_flexs_vl.descriptive_flexfield_name%TYPE,
57: flexfield OUT NOCOPY fnd_dflex.dflex_r,
58: flexinfo OUT NOCOPY wsh_flexfield_utils.dflex_dr)
59: IS
60: ffld fnd_dflex.dflex_r;
61: dflex wsh_flexfield_utils.dflex_dr;
62:

Line 61: dflex wsh_flexfield_utils.dflex_dr;

57: flexfield OUT NOCOPY fnd_dflex.dflex_r,
58: flexinfo OUT NOCOPY wsh_flexfield_utils.dflex_dr)
59: IS
60: ffld fnd_dflex.dflex_r;
61: dflex wsh_flexfield_utils.dflex_dr;
62:
63: CURSOR c_get_flexname IS
64: SELECT /* $Header: WSHFFUTB.pls 120.1.12000000.3 2007/03/30 09:36:11 nchellam ship $ */
65: a.application_id, df.descriptive_flexfield_name

Line 359: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.e_DFF_Segments');

355: --
356: WHEN Others THEN
357: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
358: WSH_UTIL_CORE.add_message (x_return_status);
359: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.e_DFF_Segments');
360: --
361: --
362: -- Debug Statements
363: --

Line 455: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Get_DFF_Defaults');

451: EXCEPTION
452: WHEN Others THEN
453: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
454: WSH_UTIL_CORE.add_message (x_return_status);
455: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Get_DFF_Defaults');
456:
457:
458: --
459: -- Debug Statements

Line 605: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Write_DFF_Attributes');

601: --
602: WHEN Others THEN
603: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
604: WSH_UTIL_CORE.add_message (x_return_status);
605: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Write_DFF_Attributes');
606:
607: --
608: -- Debug Statements
609: --

Line 820: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Get_Attribute_Values');

816: --
817: WHEN Others THEN
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
819: WSH_UTIL_CORE.add_message (x_return_status);
820: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Get_Attribute_Values');
821:
822: --
823: -- Debug Statements
824: --

Line 978: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Check_DFF_Req');

974: --
975: WHEN Others THEN
976: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
977: WSH_UTIL_CORE.add_message (x_return_status);
978: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Check_DFF_Req');
979: --
980: -- Debug Statements
981: --
982: IF l_debug_on THEN

Line 1162: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Cache_Context_Req');

1158:
1159: WHEN Others THEN
1160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1161: WSH_UTIL_CORE.add_message (x_return_status);
1162: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Cache_Context_Req');
1163: --
1164: --
1165: -- Debug Statements
1166: --

Line 1314: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Validate_DFF');

1310: --
1311: WHEN Others THEN
1312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1313: WSH_UTIL_CORE.add_message (x_return_status);
1314: WSH_UTIL_CORE.default_handler('WSH_FLEXFIELD_UTILS.Validate_DFF');
1315: --
1316: -- Debug Statements
1317: --
1318: IF l_debug_on THEN

Line 1325: END WSH_FLEXFIELD_UTILS;

1321: END IF;
1322: --
1323: END Validate_DFF;
1324:
1325: END WSH_FLEXFIELD_UTILS;