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.AS_UTILITY_PVT dependencies on FND_API

Line 64: -- WHEN FND_API.G_EXC_ERROR THEN

60: --
61: -- The following is example of calling exception handling routines:
62: --
63: -- EXCEPTION
64: -- WHEN FND_API.G_EXC_ERROR THEN
65: -- AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
66: -- P_API_NAME => L_API_NAME
67: -- , P_PGK_NAME => G_PKG_NAME
68: -- , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 75: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

71: -- , X_MSG_DATA => X_MSG_DATA
72: -- , X_RETURN_STATUS => x_return_status
73: -- );
74:
75: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
76: -- AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
77: -- P_API_NAME => L_API_NAME
78: -- , P_PGK_NAME => G_PKG_NAME
79: -- , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 135: col_choice NUMBER := FND_API.G_MISS_NUM,

131: -- End of Comments
132:
133: TYPE util_order_by_rec_type IS RECORD
134: (
135: col_choice NUMBER := FND_API.G_MISS_NUM,
136: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
137: );
138:
139: G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;

Line 136: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR

132:
133: TYPE util_order_by_rec_type IS RECORD
134: (
135: col_choice NUMBER := FND_API.G_MISS_NUM,
136: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
137: );
138:
139: G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;
140:

Line 157: name VARCHAR2(30) := FND_API.G_MISS_CHAR,

153: -- End of Comments
154:
155: TYPE flex_where_rec_type IS RECORD
156: (
157: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: value VARCHAR2(150) := FND_API.G_MISS_CHAR
159: );
160:
161: TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type

Line 158: value VARCHAR2(150) := FND_API.G_MISS_CHAR

154:
155: TYPE flex_where_rec_type IS RECORD
156: (
157: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
158: value VARCHAR2(150) := FND_API.G_MISS_CHAR
159: );
160:
161: TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type
162: INDEX BY BINARY_INTEGER;

Line 268: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

264: -- End of Comments
265: PROCEDURE Handle_Exceptions(
266: P_API_NAME IN VARCHAR2,
267: P_PKG_NAME IN VARCHAR2,
268: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
269: P_SQLCODE IN NUMBER DEFAULT NULL,
270: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
271: P_PACKAGE_TYPE IN VARCHAR2,
272: P_ROLLBACK_FLAG IN VARCHAR2 := 'Y',

Line 281: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,

277: PROCEDURE Handle_Exceptions(
278: P_MODULE IN VARCHAR2,
279: P_API_NAME IN VARCHAR2,
280: P_PKG_NAME IN VARCHAR2,
281: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
282: P_SQLCODE IN NUMBER DEFAULT NULL,
283: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
284: P_PACKAGE_TYPE IN VARCHAR2,
285: P_ROLLBACK_FLAG IN VARCHAR2 := 'Y',

Line 321: := FND_API.G_FALSE,

317:
318: PROCEDURE Translate_OrderBy(
319: p_api_version_number IN NUMBER,
320: p_init_msg_list IN VARCHAR2
321: := FND_API.G_FALSE,
322: p_validation_level IN NUMBER
323: := FND_API.G_VALID_LEVEL_FULL,
324: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
325: x_order_by_clause OUT NOCOPY VARCHAR2,

Line 323: := FND_API.G_VALID_LEVEL_FULL,

319: p_api_version_number IN NUMBER,
320: p_init_msg_list IN VARCHAR2
321: := FND_API.G_FALSE,
322: p_validation_level IN NUMBER
323: := FND_API.G_VALID_LEVEL_FULL,
324: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
325: x_order_by_clause OUT NOCOPY VARCHAR2,
326: x_return_status OUT NOCOPY VARCHAR2,
327: x_msg_count OUT NOCOPY NUMBER,

Line 391: -- p_encoded => FND_API.G_TRUE);

387: -- l_count := FND_MSG_PUB.Count_Msg;
388: -- FOR l_index IN 1..l_count LOOP
389: -- l_msg_data := FND_MSG_PUB.Get(
390: -- p_msg_index => l_index,
391: -- p_encoded => FND_API.G_TRUE);
392: -- dbms_output.put_line(l_msg_data);
393: -- END LOOP;
394: --
395: -- End of Comments

Line 701: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

697: p_token3 IN VARCHAR2,
698: p_token3_value IN VARCHAR2,
699: p_token4 IN VARCHAR2,
700: p_token4_value IN VARCHAR2,
701: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

698: p_token3_value IN VARCHAR2,
699: p_token4 IN VARCHAR2,
700: p_token4_value IN VARCHAR2,
701: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

699: p_token4 IN VARCHAR2,
700: p_token4_value IN VARCHAR2,
701: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
707: );

Line 704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

700: p_token4_value IN VARCHAR2,
701: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
707: );
708: PROCEDURE Set_Message(

Line 705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

701: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
707: );
708: PROCEDURE Set_Message(
709: p_module IN VARCHAR2,

Line 706: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

702: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
703: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
704: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
707: );
708: PROCEDURE Set_Message(
709: p_module IN VARCHAR2,
710: p_msg_level IN NUMBER,

Line 720: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

716: p_token3 IN VARCHAR2,
717: p_token3_value IN VARCHAR2,
718: p_token4 IN VARCHAR2,
719: p_token4_value IN VARCHAR2,
720: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

717: p_token3_value IN VARCHAR2,
718: p_token4 IN VARCHAR2,
719: p_token4_value IN VARCHAR2,
720: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

718: p_token4 IN VARCHAR2,
719: p_token4_value IN VARCHAR2,
720: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
726: );

Line 723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

719: p_token4_value IN VARCHAR2,
720: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
726: );
727:

Line 724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

720: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
726: );
727:
728:

Line 725: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

721: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
722: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
723: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
724: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
725: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
726: );
727:
728:
729: