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

Line 110: -- if (p_validation_level = FND_API.G_VALID_LEVEL_FULL)

106: -- data. If pass in validation level is FULL, all of the validations
107: -- above will be executed automatically. As for get_currentUser and
108: -- access check, we should do the following:
109: --
110: -- if (p_validation_level = FND_API.G_VALID_LEVEL_FULL)
111: -- then
112: -- Call get_currentUser;
113: -- Call has_xxxAccess;
114: -- end if;

Line 145: -- WHEN FND_API.G_EXC_ERROR THEN

141: --
142: -- The following is example of calling exception handling routines:
143: --
144: -- EXCEPTION
145: -- WHEN FND_API.G_EXC_ERROR THEN
146: -- JTF_PLSQL_API.HANDLE_EXCEPTIONS(
147: -- P_API_NAME => L_API_NAME
148: -- , P_PGK_NAME => G_PKG_NAME
149: -- , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 156: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

152: -- , X_MSG_DATA => X_MSG_DATA
153: -- , X_RETURN_STATUS => x_return_status
154: -- );
155:
156: -- WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: -- JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: -- P_API_NAME => L_API_NAME
159: -- , P_PGK_NAME => G_PKG_NAME
160: -- , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 216: col_choice NUMBER := FND_API.G_MISS_NUM,

212: -- End of Comments
213:
214: TYPE util_order_by_rec_type IS RECORD
215: (
216: col_choice NUMBER := FND_API.G_MISS_NUM,
217: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
218: );
219:
220: G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;

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

213:
214: TYPE util_order_by_rec_type IS RECORD
215: (
216: col_choice NUMBER := FND_API.G_MISS_NUM,
217: col_name VARCHAR2(30) := FND_API.G_MISS_CHAR
218: );
219:
220: G_MISS_UTIL_ORDER_BY_REC util_order_by_rec_type;
221:

Line 236: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,

232: -- End of Comments
233:
234: TYPE item_property_rec_type IS RECORD
235: (
236: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
240: default_num_val NUMBER := FND_API.G_MISS_NUM,

Line 237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR

233:
234: TYPE item_property_rec_type IS RECORD
235: (
236: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
240: default_num_val NUMBER := FND_API.G_MISS_NUM,
241: default_date_val DATE := FND_API.G_MISS_DATE

Line 238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR

234: TYPE item_property_rec_type IS RECORD
235: (
236: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
240: default_num_val NUMBER := FND_API.G_MISS_NUM,
241: default_date_val DATE := FND_API.G_MISS_DATE
242: );

Line 239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,

235: (
236: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
240: default_num_val NUMBER := FND_API.G_MISS_NUM,
241: default_date_val DATE := FND_API.G_MISS_DATE
242: );
243:

Line 240: default_num_val NUMBER := FND_API.G_MISS_NUM,

236: column_name VARCHAR2(30) := FND_API.G_MISS_CHAR,
237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
240: default_num_val NUMBER := FND_API.G_MISS_NUM,
241: default_date_val DATE := FND_API.G_MISS_DATE
242: );
243:
244: G_MISS_ITEM_PROPERTY_REC item_property_rec_type;

Line 241: default_date_val DATE := FND_API.G_MISS_DATE

237: required_flag VARCHAR2(1) := 'N', -- may be changed to FND_API.G_MISS_CHAR
238: update_allowed_flag VARCHAR2(1) := 'Y', -- may be changed to FND_API.G_MISS_CHAR
239: default_char_val VARCHAR2(320) := FND_API.G_MISS_CHAR,
240: default_num_val NUMBER := FND_API.G_MISS_NUM,
241: default_date_val DATE := FND_API.G_MISS_DATE
242: );
243:
244: G_MISS_ITEM_PROPERTY_REC item_property_rec_type;
245:

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

258: -- End of Comments
259:
260: TYPE flex_where_rec_type IS RECORD
261: (
262: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: value VARCHAR2(150) := FND_API.G_MISS_CHAR
264: );
265:
266: TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type

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

259:
260: TYPE flex_where_rec_type IS RECORD
261: (
262: name VARCHAR2(30) := FND_API.G_MISS_CHAR,
263: value VARCHAR2(150) := FND_API.G_MISS_CHAR
264: );
265:
266: TYPE flex_where_tbl_type IS TABLE OF flex_where_rec_type
267: INDEX BY BINARY_INTEGER;

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

369: -- End of Comments
370: PROCEDURE Handle_Exceptions(
371: P_API_NAME IN VARCHAR2,
372: P_PKG_NAME IN VARCHAR2,
373: P_EXCEPTION_LEVEL IN NUMBER := FND_API.G_MISS_NUM,
374: P_SQLCODE IN NUMBER DEFAULT NULL,
375: P_SQLERRM IN VARCHAR2 DEFAULT NULL,
376: P_PACKAGE_TYPE IN VARCHAR2,
377: P_ROLLBACK_FLAG IN VARCHAR2 := 'Y',

Line 413: := FND_API.G_FALSE,

409:
410: PROCEDURE Translate_OrderBy(
411: p_api_version_number IN NUMBER,
412: p_init_msg_list IN VARCHAR2
413: := FND_API.G_FALSE,
414: p_validation_level IN NUMBER
415: := FND_API.G_VALID_LEVEL_FULL,
416: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
417: x_order_by_clause OUT VARCHAR2,

Line 415: := FND_API.G_VALID_LEVEL_FULL,

411: p_api_version_number IN NUMBER,
412: p_init_msg_list IN VARCHAR2
413: := FND_API.G_FALSE,
414: p_validation_level IN NUMBER
415: := FND_API.G_VALID_LEVEL_FULL,
416: p_order_by_tbl IN UTIL_ORDER_BY_TBL_TYPE,
417: x_order_by_clause OUT VARCHAR2,
418: x_return_status OUT VARCHAR2,
419: x_msg_count OUT NUMBER,

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

479: -- l_count := FND_MSG_PUB.Count_Msg;
480: -- FOR l_index IN 1..l_count LOOP
481: -- l_msg_data := FND_MSG_PUB.Get(
482: -- p_msg_index => l_index,
483: -- p_encoded => FND_API.G_TRUE);
484: -- dbms_output.put_line(l_msg_data);
485: -- END LOOP;
486: --
487: -- End of Comments

Line 725: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

721: p_token2 IN VARCHAR2,
722: p_token2_value IN VARCHAR2,
723: p_token3 IN VARCHAR2,
724: p_token3_value IN VARCHAR2,
725: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

722: p_token2_value IN VARCHAR2,
723: p_token3 IN VARCHAR2,
724: p_token3_value IN VARCHAR2,
725: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

723: p_token3 IN VARCHAR2,
724: p_token3_value IN VARCHAR2,
725: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
731: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

724: p_token3_value IN VARCHAR2,
725: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
731: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
732: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

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

725: p_token4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
731: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
732: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
733: );

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

726: p_token4_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
731: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
732: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
733: );
734:

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

727: p_token5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
731: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
732: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
733: );
734:
735:

Line 732: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR

728: p_token5_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: p_token6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
730: p_token6_value IN VARCHAR2 := FND_API.G_MISS_CHAR,
731: p_token7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
732: p_token7_value IN VARCHAR2 := FND_API.G_MISS_CHAR
733: );
734:
735:
736: