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_IH_CORE_UTIL_PVT dependencies on FND_API

Line 52: IF (x_token_value = fnd_api.g_miss_char) THEN

48: x_msg_data VARCHAR2(240);
49: x_token_value VARCHAR2(2000);
50: BEGIN
51: x_token_value := SUBSTR(p_token_v,1,2000);
52: IF (x_token_value = fnd_api.g_miss_char) THEN
53: x_token_value := '';
54: END IF;
55: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
56: fnd_message.set_name('JTF', 'JTF_API_ALL_INVALID_ARGUMENT');

Line 80: IF (x_token_value = fnd_api.g_miss_char) THEN

76: fnd_message.set_name('JTF', p_msg_code);
77:
78: FOR i IN 1..p_msg_param.COUNT LOOP
79: x_token_value := SUBSTR(p_msg_param(i).token_value,1,2000);
80: IF (x_token_value = fnd_api.g_miss_char) THEN
81: x_token_value := '';
82: END IF;
83: fnd_message.set_token(p_msg_param(i).token_name, x_token_value);
84: END LOOP;

Line 172: x_return_status := fnd_api.g_ret_sts_success;

168: x_lookup_code OUT NOCOPY VARCHAR2,
169: x_return_status OUT NOCOPY VARCHAR2 )
170: IS
171: BEGIN
172: x_return_status := fnd_api.g_ret_sts_success;
173:
174: SELECT lookup_code INTO x_lookup_code
175: FROM cs_lookups
176: WHERE lookup_type = p_lookup_type

Line 180: x_return_status := fnd_api.g_ret_sts_error;

176: WHERE lookup_type = p_lookup_type
177: AND meaning = p_meaning;
178: EXCEPTION
179: WHEN no_data_found THEN
180: x_return_status := fnd_api.g_ret_sts_error;
181: cs_core_util.add_invalid_argument_msg(p_api_name, p_meaning,
182: p_parameter_name);
183: END Convert_Lookup_To_Code;
184:

Line 206: IF p_resp_appl_id = fnd_api.g_miss_num THEN

202: -- returns -1 by default, which is an invalid value. FND_GLOBAL.USER_ID
203: -- is okay, because user ID -1 corresponds to user 'ANONYMOUS.' If
204: -- FND_GLOBAL returns -1, the variables are set to NULL instead.
205: -------------------------------------------------------------------------
206: IF p_resp_appl_id = fnd_api.g_miss_num THEN
207: IF fnd_global.resp_appl_id <> -1 THEN
208: p_resp_appl_id := fnd_global.resp_appl_id;
209: ELSE
210: p_resp_appl_id := NULL;

Line 214: IF p_resp_id = fnd_api.g_miss_num THEN

210: p_resp_appl_id := NULL;
211: END IF;
212: END IF;
213:
214: IF p_resp_id = fnd_api.g_miss_num THEN
215: IF fnd_global.resp_id <> -1 THEN
216: p_resp_id := fnd_global.resp_id;
217: ELSE
218: p_resp_id := NULL;

Line 222: IF p_user_id = fnd_api.g_miss_num THEN

218: p_resp_id := NULL;
219: END IF;
220: END IF;
221:
222: IF p_user_id = fnd_api.g_miss_num THEN
223: p_user_id := fnd_global.user_id;
224: END IF;
225:
226: IF p_login_id = fnd_api.g_miss_num THEN

Line 226: IF p_login_id = fnd_api.g_miss_num THEN

222: IF p_user_id = fnd_api.g_miss_num THEN
223: p_user_id := fnd_global.user_id;
224: END IF;
225:
226: IF p_login_id = fnd_api.g_miss_num THEN
227: IF fnd_global.login_id NOT IN (-1,0) THEN
228: p_login_id := fnd_global.login_id;
229: ELSE
230: p_login_id := NULL;

Line 240: IF p_org_id = fnd_api.g_miss_num THEN

236: -- CLIENT_INFO. If it is not set, get the default from the ORG_ID profile
237: -- option.
238: --
239: IF cs_core_util.is_multiorg_enabled THEN
240: IF p_org_id = fnd_api.g_miss_num THEN
241: SELECT To_number(Decode(substrb(userenv('CLIENT_INFO'),1,1), ' ',
242: NULL, substrb(userenv('CLIENT_INFO'),1,10)))
243: INTO p_org_id
244: FROM dual;

Line 254: IF p_inventory_org_id = fnd_api.g_miss_num THEN

250: END IF;
251: END IF;
252: END IF;
253:
254: IF p_inventory_org_id = fnd_api.g_miss_num THEN
255: p_inventory_org_id :=
256: To_number(fnd_profile.value_specific('SO_ORGANIZATION_ID', p_user_id,
257: p_resp_id, p_resp_appl_id));
258: END IF;

Line 352: x_return_status := fnd_api.g_ret_sts_success;

348: x_return_status OUT NOCOPY VARCHAR2 )
349: IS
350: l_error_message VARCHAR2(2000);
351: BEGIN
352: x_return_status := fnd_api.g_ret_sts_success;
353:
354: fnd_flex_descval.set_column_value(p_column_name1, p_column_value1);
355: fnd_flex_descval.set_column_value(p_column_name2, p_column_value2);
356: fnd_flex_descval.set_column_value(p_column_name3, p_column_value3);

Line 377: -- x_return_status := fnd_api.g_ret_sts_error;

373: -- resp_appl_id => p_resp_appl_id,
374: -- resp_id => p_resp_id ) THEN
375: -- l_error_message := fnd_flex_descval.error_message;
376: -- add_desc_flex_msg(p_api_name, l_error_message);
377: -- x_return_status := fnd_api.g_ret_sts_error;
378: --END IF;
379: END Validate_Desc_Flex;
380:
381:

Line 395: x_return_status := fnd_api.g_ret_sts_success;

391: x_return_status OUT NOCOPY VARCHAR2 )
392: IS
393: BEGIN
394: IF p_later_date >= p_earlier_date THEN
395: x_return_status := fnd_api.g_ret_sts_success;
396: ELSE
397: x_return_status := fnd_api.g_ret_sts_error;
398: add_invalid_argument_msg(p_api_name, To_char(p_later_date),
399: p_parameter_name);

Line 397: x_return_status := fnd_api.g_ret_sts_error;

393: BEGIN
394: IF p_later_date >= p_earlier_date THEN
395: x_return_status := fnd_api.g_ret_sts_success;
396: ELSE
397: x_return_status := fnd_api.g_ret_sts_error;
398: add_invalid_argument_msg(p_api_name, To_char(p_later_date),
399: p_parameter_name);
400: END IF;
401: END Validate_Later_Date;

Line 416: x_return_status := fnd_api.g_ret_sts_success;

412: x_return_status OUT NOCOPY VARCHAR2 )
413: IS
414: l_dummy VARCHAR2(1);
415: BEGIN
416: x_return_status := fnd_api.g_ret_sts_success;
417:
418: SELECT 'x' INTO l_dummy
419: FROM cs_lookups
420: WHERE lookup_code = p_lookup_code

Line 427: x_return_status := fnd_api.g_ret_sts_error;

423: AND Trunc(Sysdate) BETWEEN Trunc(Nvl(start_date_active, Sysdate))
424: AND Trunc(Nvl(end_date_active, Sysdate));
425: EXCEPTION
426: WHEN no_data_found THEN
427: x_return_status := fnd_api.g_ret_sts_error;
428: add_invalid_argument_msg(p_api_name, p_lookup_code, p_parameter_name);
429: END Validate_Lookup_Code;
430:
431: ------------------------------------------------------------------------------

Line 455: x_return_status := fnd_api.g_ret_sts_success;

451: x_return_status OUT NOCOPY VARCHAR2 )
452: IS
453: l_dummy VARCHAR2(1);
454: BEGIN
455: x_return_status := fnd_api.g_ret_sts_success;
456:
457: BEGIN
458: -- Special check to not check the dates when the user ID is (-1).
459: IF p_user_id = -1 THEN

Line 472: x_return_status := fnd_api.g_ret_sts_error;

468: AND Trunc(Nvl(end_date, Sysdate));
469: END IF;
470: EXCEPTION
471: WHEN no_data_found THEN
472: x_return_status := fnd_api.g_ret_sts_error;
473: add_invalid_argument_msg(p_api_name, To_char(p_user_id),
474: p_parameter_name_usr);
475: RETURN;
476: END;