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

Line 59: when FND_API.G_EXC_ERROR then

55:
56: commit;
57:
58: EXCEPTION
59: when FND_API.G_EXC_ERROR then
60: -- Add proper error logging
61: -- dbms_output.put_line('1 ' || sqlerrm );
62: NULL;
63:

Line 64: when FND_API.G_EXC_UNEXPECTED_ERROR then

60: -- Add proper error logging
61: -- dbms_output.put_line('1 ' || sqlerrm );
62: NULL;
63:
64: when FND_API.G_EXC_UNEXPECTED_ERROR then
65: -- Add proper error logging
66: -- dbms_output.put_line('2 ' || sqlerrm );
67: NULL;
68: when others then

Line 135: when FND_API.G_EXC_ERROR then

131:
132: commit;
133:
134: EXCEPTION
135: when FND_API.G_EXC_ERROR then
136: NULL;
137:
138: when FND_API.G_EXC_UNEXPECTED_ERROR then
139: NULL;

Line 138: when FND_API.G_EXC_UNEXPECTED_ERROR then

134: EXCEPTION
135: when FND_API.G_EXC_ERROR then
136: NULL;
137:
138: when FND_API.G_EXC_UNEXPECTED_ERROR then
139: NULL;
140:
141: when others then
142: NULL;

Line 167: when FND_API.G_EXC_ERROR then

163:
164: commit;
165:
166: EXCEPTION
167: when FND_API.G_EXC_ERROR then
168: NULL;
169:
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: NULL;

Line 170: when FND_API.G_EXC_UNEXPECTED_ERROR then

166: EXCEPTION
167: when FND_API.G_EXC_ERROR then
168: NULL;
169:
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: NULL;
172: when others then
173: NULL;
174: END update_terr_enddate_active;

Line 195: when FND_API.G_EXC_ERROR then

191:
192: commit;
193:
194: EXCEPTION
195: when FND_API.G_EXC_ERROR then
196: NULL;
197: when FND_API.G_EXC_UNEXPECTED_ERROR then
198: NULL;
199: when others then

Line 197: when FND_API.G_EXC_UNEXPECTED_ERROR then

193:
194: EXCEPTION
195: when FND_API.G_EXC_ERROR then
196: NULL;
197: when FND_API.G_EXC_UNEXPECTED_ERROR then
198: NULL;
199: when others then
200: NULL;
201: END update_self_service_flag;

Line 248: when FND_API.G_EXC_ERROR then

244:
245: commit;
246:
247: EXCEPTION
248: when FND_API.G_EXC_ERROR then
249: NULL;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: NULL;
252: when others then

Line 250: when FND_API.G_EXC_UNEXPECTED_ERROR then

246:
247: EXCEPTION
248: when FND_API.G_EXC_ERROR then
249: NULL;
250: when FND_API.G_EXC_UNEXPECTED_ERROR then
251: NULL;
252: when others then
253: NULL;
254: END update_terr_type_for_terr;

Line 279: when FND_API.G_EXC_ERROR then

275:
276: commit;
277:
278: EXCEPTION
279: when FND_API.G_EXC_ERROR then
280: -- Add proper error logging
281: -- dbms_output.put_line('10' || sqlerrm );
282: NULL;
283: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 283: when FND_API.G_EXC_UNEXPECTED_ERROR then

279: when FND_API.G_EXC_ERROR then
280: -- Add proper error logging
281: -- dbms_output.put_line('10' || sqlerrm );
282: NULL;
283: when FND_API.G_EXC_UNEXPECTED_ERROR then
284: -- Add proper error logging
285: -- dbms_output.put_line('11' || sqlerrm );
286: NULL;
287: when others then

Line 316: when FND_API.G_EXC_ERROR then

312: where substr(name,1,7) = 'General'
313: and created_by = 2
314: and rownum < 2;
315: EXCEPTION
316: when FND_API.G_EXC_ERROR then
317: -- Add proper error logging
318: -- dbms_output.put_line('21' || sqlerrm );
319: NULL;
320: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 320: when FND_API.G_EXC_UNEXPECTED_ERROR then

316: when FND_API.G_EXC_ERROR then
317: -- Add proper error logging
318: -- dbms_output.put_line('21' || sqlerrm );
319: NULL;
320: when FND_API.G_EXC_UNEXPECTED_ERROR then
321: -- Add proper error logging
322: -- dbms_output.put_line('22' || sqlerrm );
323: NULL;
324: when others then

Line 372: when FND_API.G_EXC_ERROR then

368: from jtf_terr_usgs_all jtu
369: , jtf_sources_all jsa
370: where jsa.source_id = jtu.source_id);
371: EXCEPTION
372: when FND_API.G_EXC_ERROR then
373: -- Add proper error logging
374: -- dbms_output.put_line('24' || sqlerrm );
375: NULL;
376: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 376: when FND_API.G_EXC_UNEXPECTED_ERROR then

372: when FND_API.G_EXC_ERROR then
373: -- Add proper error logging
374: -- dbms_output.put_line('24' || sqlerrm );
375: NULL;
376: when FND_API.G_EXC_UNEXPECTED_ERROR then
377: -- Add proper error logging
378: -- dbms_output.put_line('26' || sqlerrm );
379: NULL;
380: when others then

Line 455: when FND_API.G_EXC_ERROR then

451: from jtf_terr_all
452: where geo_terr_flag = 'Y');
453:
454: EXCEPTION
455: when FND_API.G_EXC_ERROR then
456: -- Add proper error logging
457: -- dbms_output.put_line('28' || sqlerrm );
458: NULL;
459: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 459: when FND_API.G_EXC_UNEXPECTED_ERROR then

455: when FND_API.G_EXC_ERROR then
456: -- Add proper error logging
457: -- dbms_output.put_line('28' || sqlerrm );
458: NULL;
459: when FND_API.G_EXC_UNEXPECTED_ERROR then
460: -- Add proper error logging
461: -- dbms_output.put_line('29' || sqlerrm );
462: NULL;
463: when others then

Line 497: when FND_API.G_EXC_ERROR then

493: where ORIG_SYSTEM_REFERENCE_ID is not null
494: and CREATED_BY = 2;
495:
496: EXCEPTION
497: when FND_API.G_EXC_ERROR then
498: -- Add proper error logging
499: -- dbms_output.put_line('31' || sqlerrm );
500: NULL;
501: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 501: when FND_API.G_EXC_UNEXPECTED_ERROR then

497: when FND_API.G_EXC_ERROR then
498: -- Add proper error logging
499: -- dbms_output.put_line('31' || sqlerrm );
500: NULL;
501: when FND_API.G_EXC_UNEXPECTED_ERROR then
502: -- Add proper error logging
503: -- dbms_output.put_line('32' || sqlerrm );
504: NULL;
505: when others then

Line 544: when FND_API.G_EXC_ERROR then

540: and jqtu.qual_type_usg_id <> -1005 -- Exclude service account transaction type
541: and jttu.created_by = 2;
542:
543: EXCEPTION
544: when FND_API.G_EXC_ERROR then
545: -- Add proper error logging
546: -- dbms_output.put_line('34' || sqlerrm );
547: NULL;
548: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 548: when FND_API.G_EXC_UNEXPECTED_ERROR then

544: when FND_API.G_EXC_ERROR then
545: -- Add proper error logging
546: -- dbms_output.put_line('34' || sqlerrm );
547: NULL;
548: when FND_API.G_EXC_UNEXPECTED_ERROR then
549: -- Add proper error logging
550: -- dbms_output.put_line('35' || sqlerrm );
551: NULL;
552: when others then

Line 592: when FND_API.G_EXC_ERROR then

588: and jttu.terr_type_id <> -1 -- For NA territories this table is not populated
589: and jqu.ENABLED_FLAG = 'Y';
590:
591: EXCEPTION
592: when FND_API.G_EXC_ERROR then
593: -- Add proper error logging
594: -- dbms_output.put_line('37' || sqlerrm );
595: NULL;
596: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 596: when FND_API.G_EXC_UNEXPECTED_ERROR then

592: when FND_API.G_EXC_ERROR then
593: -- Add proper error logging
594: -- dbms_output.put_line('37' || sqlerrm );
595: NULL;
596: when FND_API.G_EXC_UNEXPECTED_ERROR then
597: -- Add proper error logging
598: -- dbms_output.put_line('38' || sqlerrm );
599: NULL;
600: when others then

Line 611: when FND_API.G_EXC_ERROR then

607:
608: commit;
609:
610: EXCEPTION
611: when FND_API.G_EXC_ERROR then
612: -- Add proper error logging
613: -- dbms_output.put_line('13' || sqlerrm );
614: NULL;
615: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 615: when FND_API.G_EXC_UNEXPECTED_ERROR then

611: when FND_API.G_EXC_ERROR then
612: -- Add proper error logging
613: -- dbms_output.put_line('13' || sqlerrm );
614: NULL;
615: when FND_API.G_EXC_UNEXPECTED_ERROR then
616: -- Add proper error logging
617: -- dbms_output.put_line('14' || sqlerrm );
618: NULL;
619: when others then

Line 652: when FND_API.G_EXC_ERROR then

648:
649: commit;
650:
651: EXCEPTION
652: when FND_API.G_EXC_ERROR then
653: -- Add proper error logging
654: -- dbms_output.put_line('1 ' || sqlerrm );
655: NULL;
656:

Line 657: when FND_API.G_EXC_UNEXPECTED_ERROR then

653: -- Add proper error logging
654: -- dbms_output.put_line('1 ' || sqlerrm );
655: NULL;
656:
657: when FND_API.G_EXC_UNEXPECTED_ERROR then
658: -- Add proper error logging
659: -- dbms_output.put_line('2 ' || sqlerrm );
660: NULL;
661: when others then

Line 698: when FND_API.G_EXC_ERROR then

694:
695: commit;
696:
697: EXCEPTION
698: when FND_API.G_EXC_ERROR then
699: -- Add proper error logging
700: -- dbms_output.put_line('16' || sqlerrm );
701: NULL;
702: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 702: when FND_API.G_EXC_UNEXPECTED_ERROR then

698: when FND_API.G_EXC_ERROR then
699: -- Add proper error logging
700: -- dbms_output.put_line('16' || sqlerrm );
701: NULL;
702: when FND_API.G_EXC_UNEXPECTED_ERROR then
703: -- Add proper error logging
704: -- dbms_output.put_line('17' || sqlerrm );
705: NULL;
706: when others then