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

Line 64: x_return_status := fnd_api.g_ret_sts_success;

60: p_geo_type_exists_flag := 'N';
61: END;
62:
63: -- do validations
64: x_return_status := fnd_api.g_ret_sts_success;
65: IF(p_geo_type is null OR p_geo_name is null
66: OR p_geo_code is null OR p_country_code is null) THEN
67: x_return_status := fnd_api.g_ret_sts_error;
68: fnd_message.set_name('JTF', 'JTF_TTY_NOT_NULL');

Line 67: x_return_status := fnd_api.g_ret_sts_error;

63: -- do validations
64: x_return_status := fnd_api.g_ret_sts_success;
65: IF(p_geo_type is null OR p_geo_name is null
66: OR p_geo_code is null OR p_country_code is null) THEN
67: x_return_status := fnd_api.g_ret_sts_error;
68: fnd_message.set_name('JTF', 'JTF_TTY_NOT_NULL');
69: x_error_msg := fnd_message.Get();
70: -- check if parent geo is there
71: elsif (p_geo_type_exists_flag = 'N') THEN

Line 72: x_return_status := fnd_api.g_ret_sts_error;

68: fnd_message.set_name('JTF', 'JTF_TTY_NOT_NULL');
69: x_error_msg := fnd_message.Get();
70: -- check if parent geo is there
71: elsif (p_geo_type_exists_flag = 'N') THEN
72: x_return_status := fnd_api.g_ret_sts_error;
73: fnd_message.set_name('JTF', 'JTF_TTY_GEO_TYPE_INVALID');
74: fnd_message.set_token('p_geo_type',p_geo_type);
75: x_error_msg := fnd_message.Get();
76: elsif (p_geo_type = 'STATE') THEN

Line 89: x_return_status := fnd_api.g_ret_sts_error;

85: WHEN NO_DATA_FOUND THEN
86: p_parent_exists_flag := 'N';
87: END;
88: if (p_parent_exists_flag = 'N') then
89: x_return_status := fnd_api.g_ret_sts_error;
90: fnd_message.set_name('JTF', 'JTF_TTY_GEO_PARENT_NOTEXIST');
91: fnd_message.set_token('p_geo_code',p_geo_code);
92: fnd_message.set_token('p_geo_type',p_geo_type);
93: fnd_message.set_token('p_country_code',p_country_code);

Line 110: x_return_status := fnd_api.g_ret_sts_error;

106: WHEN NO_DATA_FOUND THEN
107: p_exists_flag := 'N';
108: END;
109: if (p_exists_flag = 'Y') then
110: x_return_status := fnd_api.g_ret_sts_error;
111: fnd_message.set_name('JTF', 'JTF_TTY_GEO_UNIQUE');
112: -- fnd_message.set_token('p_geo_code',p_geo_code);
113: -- fnd_message.set_token('p_geo_type',p_geo_type);
114: -- fnd_message.set_token('p_country_code',p_country_code);

Line 131: x_return_status := fnd_api.g_ret_sts_error;

127: WHEN NO_DATA_FOUND THEN
128: p_parent_exists_flag := 'N';
129: END;
130: if (p_parent_exists_flag = 'N') then
131: x_return_status := fnd_api.g_ret_sts_error;
132: fnd_message.set_name('JTF', 'JTF_TTY_GEO_PARENT_NOTEXIST');
133: fnd_message.set_token('p_geo_code',p_geo_code);
134: fnd_message.set_token('p_geo_type',p_geo_type);
135: fnd_message.set_token('p_country_code',p_country_code);

Line 152: x_return_status := fnd_api.g_ret_sts_error;

148: WHEN NO_DATA_FOUND THEN
149: p_exists_flag := 'N';
150: END;
151: if (p_exists_flag = 'Y') then
152: x_return_status := fnd_api.g_ret_sts_error;
153: fnd_message.set_name('JTF', 'JTF_TTY_GEO_UNIQUE');
154: -- fnd_message.set_token('p_geo_code',p_geo_code);
155: -- fnd_message.set_token('p_geo_type',p_geo_type);
156: -- fnd_message.set_token('p_country_code',p_country_code);

Line 184: x_return_status := fnd_api.g_ret_sts_error;

180: WHEN NO_DATA_FOUND THEN
181: p_parent_exists_flag := 'N';
182: END;
183: if (p_parent_exists_flag = 'N') then
184: x_return_status := fnd_api.g_ret_sts_error;
185: fnd_message.set_name('JTF', 'JTF_TTY_GEO_PARENT_NOTEXIST');
186: fnd_message.set_token('p_geo_code',p_geo_code);
187: fnd_message.set_token('p_geo_type',p_geo_type);
188: fnd_message.set_token('p_country_code',p_country_code);

Line 213: x_return_status := fnd_api.g_ret_sts_error;

209: WHEN NO_DATA_FOUND THEN
210: p_parent_exists_flag := 'N';
211: END;
212: if (p_parent_exists_flag = 'N') then
213: x_return_status := fnd_api.g_ret_sts_error;
214: fnd_message.set_name('JTF', 'JTF_TTY_GEO_PARENT_NOTEXIST');
215: fnd_message.set_token('p_geo_code',p_geo_code);
216: fnd_message.set_token('p_geo_type',p_geo_type);
217: fnd_message.set_token('p_country_code',p_country_code);

Line 247: x_return_status := fnd_api.g_ret_sts_error;

243: WHEN NO_DATA_FOUND THEN
244: p_parent_exists_flag := 'N';
245: END;
246: if (p_parent_exists_flag = 'N') then
247: x_return_status := fnd_api.g_ret_sts_error;
248: fnd_message.set_name('JTF', 'JTF_TTY_GEO_PARENT_NOTEXIST');
249: fnd_message.set_token('p_geo_code',p_geo_code);
250: fnd_message.set_token('p_geo_type',p_geo_type);
251: fnd_message.set_token('p_country_code',p_country_code);

Line 256: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

252: fnd_message.set_token('p_geo_name',p_geo_name);
253: x_error_msg := fnd_message.Get();
254: end if;
255: END IF;
256: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
257: RAISE fnd_api.g_exc_error;
258: END IF;
259: -- Create the geography, validations done
260: INSERT INTO jtf_tty_geographies(

Line 257: RAISE fnd_api.g_exc_error;

253: x_error_msg := fnd_message.Get();
254: end if;
255: END IF;
256: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
257: RAISE fnd_api.g_exc_error;
258: END IF;
259: -- Create the geography, validations done
260: INSERT INTO jtf_tty_geographies(
261: geo_id,

Line 295: WHEN fnd_api.g_exc_unexpected_error THEN

291: p_date);
292: COMMIT;
293: EXCEPTION
294:
295: WHEN fnd_api.g_exc_unexpected_error THEN
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297:
298: WHEN fnd_api.g_exc_error THEN
299: x_return_status := fnd_api.g_ret_sts_error;

Line 296: x_return_status := fnd_api.g_ret_sts_unexp_error;

292: COMMIT;
293: EXCEPTION
294:
295: WHEN fnd_api.g_exc_unexpected_error THEN
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297:
298: WHEN fnd_api.g_exc_error THEN
299: x_return_status := fnd_api.g_ret_sts_error;
300:

Line 298: WHEN fnd_api.g_exc_error THEN

294:
295: WHEN fnd_api.g_exc_unexpected_error THEN
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297:
298: WHEN fnd_api.g_exc_error THEN
299: x_return_status := fnd_api.g_ret_sts_error;
300:
301: WHEN OTHERS THEN
302: fnd_message.set_name('JTF', 'JTF_TTY_GEO_API_OTHERS');

Line 299: x_return_status := fnd_api.g_ret_sts_error;

295: WHEN fnd_api.g_exc_unexpected_error THEN
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297:
298: WHEN fnd_api.g_exc_error THEN
299: x_return_status := fnd_api.g_ret_sts_error;
300:
301: WHEN OTHERS THEN
302: fnd_message.set_name('JTF', 'JTF_TTY_GEO_API_OTHERS');
303: fnd_message.set_token('P_SQLCODE', SQLCODE);

Line 308: x_return_status := fnd_api.g_ret_sts_unexp_error;

304: fnd_message.set_token('P_SQLERRM', SQLERRM);
305: fnd_message.set_token('P_API_NAME', l_api_name);
306: x_error_msg := fnd_message.Get();
307: -- FND_MSG_PUB.add;
308: x_return_status := fnd_api.g_ret_sts_unexp_error;
309:
310: END create_geo;
311:
312: /***********************************************************

Line 332: x_return_status := fnd_api.g_ret_sts_success;

328: p_user_id := fnd_global.user_id;
329: p_date := sysdate;
330:
331: -- do validations
332: x_return_status := fnd_api.g_ret_sts_success;
333: IF (p_geo_id is null OR p_geo_name is null) THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335: x_return_status := fnd_api.g_ret_sts_error;
336: fnd_message.set_name('JTF', 'JTF_TTY_UPDATE_NOT_ENOUGHVALUES');

Line 334: x_return_status := fnd_api.g_ret_sts_error;

330:
331: -- do validations
332: x_return_status := fnd_api.g_ret_sts_success;
333: IF (p_geo_id is null OR p_geo_name is null) THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335: x_return_status := fnd_api.g_ret_sts_error;
336: fnd_message.set_name('JTF', 'JTF_TTY_UPDATE_NOT_ENOUGHVALUES');
337: x_error_msg := fnd_message.Get();
338: END IF;

Line 335: x_return_status := fnd_api.g_ret_sts_error;

331: -- do validations
332: x_return_status := fnd_api.g_ret_sts_success;
333: IF (p_geo_id is null OR p_geo_name is null) THEN
334: x_return_status := fnd_api.g_ret_sts_error;
335: x_return_status := fnd_api.g_ret_sts_error;
336: fnd_message.set_name('JTF', 'JTF_TTY_UPDATE_NOT_ENOUGHVALUES');
337: x_error_msg := fnd_message.Get();
338: END IF;
339: BEGIN

Line 349: x_return_status := fnd_api.g_ret_sts_error;

345: WHEN NO_DATA_FOUND THEN
346: p_exists_flag := 'N';
347: END;
348: IF (p_exists_flag = 'N') THEN
349: x_return_status := fnd_api.g_ret_sts_error;
350: fnd_message.set_name('JTF', 'JTF_TTY_GEOID_NOTEXIST');
351: fnd_message.set_token('p_geo_id',p_geo_id);
352: fnd_message.set_token('p_action_type','updated');
353: x_error_msg := fnd_message.Get();

Line 355: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

351: fnd_message.set_token('p_geo_id',p_geo_id);
352: fnd_message.set_token('p_action_type','updated');
353: x_error_msg := fnd_message.Get();
354: END IF;
355: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
356: RAISE fnd_api.g_exc_error;
357: END IF;
358: -- passed all validations, now perform update operation
359: UPDATE jtf_tty_geographies

Line 356: RAISE fnd_api.g_exc_error;

352: fnd_message.set_token('p_action_type','updated');
353: x_error_msg := fnd_message.Get();
354: END IF;
355: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
356: RAISE fnd_api.g_exc_error;
357: END IF;
358: -- passed all validations, now perform update operation
359: UPDATE jtf_tty_geographies
360: SET geo_name = p_geo_name,

Line 367: WHEN fnd_api.g_exc_unexpected_error THEN

363: WHERE geo_id = p_geo_id;
364: COMMIT;
365: EXCEPTION
366:
367: WHEN fnd_api.g_exc_unexpected_error THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369:
370: WHEN fnd_api.g_exc_error THEN
371: x_return_status := fnd_api.g_ret_sts_error;

Line 368: x_return_status := fnd_api.g_ret_sts_unexp_error;

364: COMMIT;
365: EXCEPTION
366:
367: WHEN fnd_api.g_exc_unexpected_error THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369:
370: WHEN fnd_api.g_exc_error THEN
371: x_return_status := fnd_api.g_ret_sts_error;
372:

Line 370: WHEN fnd_api.g_exc_error THEN

366:
367: WHEN fnd_api.g_exc_unexpected_error THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369:
370: WHEN fnd_api.g_exc_error THEN
371: x_return_status := fnd_api.g_ret_sts_error;
372:
373: WHEN OTHERS THEN
374: fnd_message.set_name('JTF', 'JTF_TTY_GEO_API_OTHERS');

Line 371: x_return_status := fnd_api.g_ret_sts_error;

367: WHEN fnd_api.g_exc_unexpected_error THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369:
370: WHEN fnd_api.g_exc_error THEN
371: x_return_status := fnd_api.g_ret_sts_error;
372:
373: WHEN OTHERS THEN
374: fnd_message.set_name('JTF', 'JTF_TTY_GEO_API_OTHERS');
375: fnd_message.set_token('P_SQLCODE', SQLCODE);

Line 379: x_return_status := fnd_api.g_ret_sts_unexp_error;

375: fnd_message.set_token('P_SQLCODE', SQLCODE);
376: fnd_message.set_token('P_SQLERRM', SQLERRM);
377: fnd_message.set_token('P_API_NAME', l_api_name);
378: x_error_msg := fnd_message.Get();
379: x_return_status := fnd_api.g_ret_sts_unexp_error;
380: END update_geo;
381:
382: /***********************************************************
383: * Deletes a Geography

Line 440: x_return_status := fnd_api.g_ret_sts_success;

436: p_geo_type_exists_flag := 'N';
437: END;
438:
439: -- do validations
440: x_return_status := fnd_api.g_ret_sts_success;
441: IF(p_geo_type is null
442: OR p_geo_code is null OR p_country_code is null) THEN
443: x_return_status := fnd_api.g_ret_sts_error;
444: fnd_message.set_name('JTF', 'JTF_TTY_NOT_NULL');

Line 443: x_return_status := fnd_api.g_ret_sts_error;

439: -- do validations
440: x_return_status := fnd_api.g_ret_sts_success;
441: IF(p_geo_type is null
442: OR p_geo_code is null OR p_country_code is null) THEN
443: x_return_status := fnd_api.g_ret_sts_error;
444: fnd_message.set_name('JTF', 'JTF_TTY_NOT_NULL');
445: x_error_msg := fnd_message.Get();
446: elsif(p_exists_flag = 'N') THEN
447: x_return_status := fnd_api.g_ret_sts_error;

Line 447: x_return_status := fnd_api.g_ret_sts_error;

443: x_return_status := fnd_api.g_ret_sts_error;
444: fnd_message.set_name('JTF', 'JTF_TTY_NOT_NULL');
445: x_error_msg := fnd_message.Get();
446: elsif(p_exists_flag = 'N') THEN
447: x_return_status := fnd_api.g_ret_sts_error;
448: fnd_message.set_name('JTF', 'JTF_TTY_GEO_NOTEXIST');
449: x_error_msg := fnd_message.Get();
450: -- check if parent geo is there
451: elsif (p_geo_type_exists_flag = 'N') THEN

Line 452: x_return_status := fnd_api.g_ret_sts_error;

448: fnd_message.set_name('JTF', 'JTF_TTY_GEO_NOTEXIST');
449: x_error_msg := fnd_message.Get();
450: -- check if parent geo is there
451: elsif (p_geo_type_exists_flag = 'N') THEN
452: x_return_status := fnd_api.g_ret_sts_error;
453: fnd_message.set_name('JTF', 'JTF_TTY_GEO_TYPE_INVALID');
454: fnd_message.set_token('p_geo_type',p_geo_type);
455: x_error_msg := fnd_message.Get();
456: elsif (p_geo_type = 'COUNTRY') THEN

Line 470: x_return_status := fnd_api.g_ret_sts_error;

466: WHEN NO_DATA_FOUND THEN
467: p_child_exists_flag := 'N';
468: END;
469: if (p_child_exists_flag = 'Y') then
470: x_return_status := fnd_api.g_ret_sts_error;
471: fnd_message.set_name('JTF', 'JTF_TTY_GEO_CHILDEXIST');
472: x_error_msg := fnd_message.Get();
473: end if;
474: end if;

Line 492: x_return_status := fnd_api.g_ret_sts_error;

488: WHEN NO_DATA_FOUND THEN
489: p_child_exists_flag := 'N';
490: END;
491: if (p_child_exists_flag = 'Y') then
492: x_return_status := fnd_api.g_ret_sts_error;
493: fnd_message.set_name('JTF', 'JTF_TTY_GEO_CHILDEXIST');
494: x_error_msg := fnd_message.Get();
495: end if;
496: end if;

Line 514: x_return_status := fnd_api.g_ret_sts_error;

510: WHEN NO_DATA_FOUND THEN
511: p_child_exists_flag := 'N';
512: END;
513: if (p_child_exists_flag = 'Y') then
514: x_return_status := fnd_api.g_ret_sts_error;
515: fnd_message.set_name('JTF', 'JTF_TTY_GEO_CHILDEXIST');
516: x_error_msg := fnd_message.Get();
517: end if;
518: end if;

Line 537: x_return_status := fnd_api.g_ret_sts_error;

533: WHEN NO_DATA_FOUND THEN
534: p_child_exists_flag := 'N';
535: END;
536: if (p_child_exists_flag = 'Y') then
537: x_return_status := fnd_api.g_ret_sts_error;
538: fnd_message.set_name('JTF', 'JTF_TTY_GEO_CHILDEXIST');
539: x_error_msg := fnd_message.Get();
540: end if;
541: end if;

Line 561: x_return_status := fnd_api.g_ret_sts_error;

557: WHEN NO_DATA_FOUND THEN
558: p_child_exists_flag := 'N';
559: END;
560: if (p_child_exists_flag = 'Y') then
561: x_return_status := fnd_api.g_ret_sts_error;
562: fnd_message.set_name('JTF', 'JTF_TTY_GEO_CHILDEXIST');
563: x_error_msg := fnd_message.Get();
564: end if;
565: end if;

Line 569: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

565: end if;
566: elsif (p_geo_type = 'POSTAL_CODE') THEN
567: null;
568: END IF;
569: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
570: RAISE fnd_api.g_exc_error;
571: END IF;
572: -- delete the geography, validations done
573: IF (p_geo_type = 'STATE') THEN

Line 570: RAISE fnd_api.g_exc_error;

566: elsif (p_geo_type = 'POSTAL_CODE') THEN
567: null;
568: END IF;
569: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
570: RAISE fnd_api.g_exc_error;
571: END IF;
572: -- delete the geography, validations done
573: IF (p_geo_type = 'STATE') THEN
574: if (p_delete_cascade_flag = 'Y') THEN

Line 589: WHEN fnd_api.g_exc_unexpected_error THEN

585:
586: COMMIT;
587: EXCEPTION
588:
589: WHEN fnd_api.g_exc_unexpected_error THEN
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591:
592: WHEN fnd_api.g_exc_error THEN
593: x_return_status := fnd_api.g_ret_sts_error;

Line 590: x_return_status := fnd_api.g_ret_sts_unexp_error;

586: COMMIT;
587: EXCEPTION
588:
589: WHEN fnd_api.g_exc_unexpected_error THEN
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591:
592: WHEN fnd_api.g_exc_error THEN
593: x_return_status := fnd_api.g_ret_sts_error;
594:

Line 592: WHEN fnd_api.g_exc_error THEN

588:
589: WHEN fnd_api.g_exc_unexpected_error THEN
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591:
592: WHEN fnd_api.g_exc_error THEN
593: x_return_status := fnd_api.g_ret_sts_error;
594:
595: WHEN OTHERS THEN
596: fnd_message.set_name('JTF', 'JTF_TTY_GEO_API_OTHERS');

Line 593: x_return_status := fnd_api.g_ret_sts_error;

589: WHEN fnd_api.g_exc_unexpected_error THEN
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591:
592: WHEN fnd_api.g_exc_error THEN
593: x_return_status := fnd_api.g_ret_sts_error;
594:
595: WHEN OTHERS THEN
596: fnd_message.set_name('JTF', 'JTF_TTY_GEO_API_OTHERS');
597: fnd_message.set_token('P_SQLCODE', SQLCODE);

Line 602: x_return_status := fnd_api.g_ret_sts_unexp_error;

598: fnd_message.set_token('P_SQLERRM', SQLERRM);
599: fnd_message.set_token('P_API_NAME', l_api_name);
600: x_error_msg := fnd_message.Get();
601: -- FND_MSG_PUB.add;
602: x_return_status := fnd_api.g_ret_sts_unexp_error;
603:
604: END delete_geo;
605:
606: END JTF_TTY_GEOSOURCE_PUB;