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.IGS_UC_MV_DATA_UPLD dependencies on APP_EXCEPTION

Line 133: app_exception.raise_exception;

129: WHEN OTHERS THEN
130: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
131: fnd_message.set_token('NAME','IS_NUMERIC - '||SQLERRM);
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134:
135: END is_numeric;
136:
137:

Line 169: app_exception.raise_exception;

165: fnd_message.set_name('IGS', 'IGS_UC_INVALID_CHOICE');
166: fnd_message.set_token('CHOICE',p_char);
167: fnd_file.put_line( fnd_file.log, fnd_message.get());
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;
171:
172: RETURN (l_num);
173:

Line 179: app_exception.raise_exception;

175: WHEN OTHERS THEN
176: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
177: fnd_message.set_token('NAME','GET_NUMERIC_CHOICE - '||SQLERRM);
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END get_numeric_choice;
181:
182:
183: PROCEDURE validate_file_seq_num(

Line 259: app_exception.raise_exception;

255: WHEN OTHERS THEN
256: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
257: fnd_message.set_token('NAME','VALIDATE_FILE_SEQ_NUM - '||SQLERRM);
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END validate_file_seq_num;
261:
262:
263: FUNCTION sequence_validity RETURN BOOLEAN IS

Line 351: app_exception.raise_exception;

347: WHEN OTHERS THEN
348: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
349: fnd_message.set_token('NAME','SEQUENCE_VALIDITY - '||SQLERRM);
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END sequence_validity;
353:
354:
355:

Line 501: app_exception.raise_exception;

497: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
498: fnd_message.set_token('TTYPE',p_trans_type);
499: fnd_file.put_line( fnd_file.log, fnd_message.get());
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502:
503: WHEN OTHERS THEN
504: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
505: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARA - '||SQLERRM);

Line 507: app_exception.raise_exception;

503: WHEN OTHERS THEN
504: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
505: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARA - '||SQLERRM);
506: igs_ge_msg_stack.add;
507: app_exception.raise_exception;
508:
509: END transfer_to_stara;
510:
511:

Line 713: app_exception.raise_exception;

709: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
710: fnd_message.set_token('TTYPE',p_trans_type);
711: fnd_file.put_line( fnd_file.log, fnd_message.get());
712: igs_ge_msg_stack.add;
713: app_exception.raise_exception;
714:
715: WHEN OTHERS THEN
716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARC - '||SQLERRM);

Line 719: app_exception.raise_exception;

715: WHEN OTHERS THEN
716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARC - '||SQLERRM);
718: igs_ge_msg_stack.add;
719: app_exception.raise_exception;
720:
721: END transfer_to_starc;
722:
723:

Line 835: app_exception.raise_exception;

831: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
832: fnd_message.set_token('TTYPE',p_trans_type);
833: fnd_file.put_line( fnd_file.log, fnd_message.get());
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836:
837: WHEN OTHERS THEN
838: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
839: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARG - '||SQLERRM);

Line 841: app_exception.raise_exception;

837: WHEN OTHERS THEN
838: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
839: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARG - '||SQLERRM);
840: igs_ge_msg_stack.add;
841: app_exception.raise_exception;
842:
843: END transfer_to_starg;
844:
845:

Line 923: app_exception.raise_exception;

919: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
920: fnd_message.set_token('TTYPE',p_trans_type);
921: fnd_file.put_line( fnd_file.log, fnd_message.get());
922: igs_ge_msg_stack.add;
923: app_exception.raise_exception;
924:
925: WHEN OTHERS THEN
926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
927: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARH - '||SQLERRM);

Line 929: app_exception.raise_exception;

925: WHEN OTHERS THEN
926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
927: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARH - '||SQLERRM);
928: igs_ge_msg_stack.add;
929: app_exception.raise_exception;
930:
931: END transfer_to_starh;
932:
933:

Line 1263: app_exception.raise_exception;

1259: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1260: fnd_message.set_token('TTYPE',p_trans_type);
1261: fnd_file.put_line( fnd_file.log, fnd_message.get());
1262: igs_ge_msg_stack.add;
1263: app_exception.raise_exception;
1264:
1265: WHEN OTHERS THEN
1266: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1267: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARK - '||SQLERRM);

Line 1269: app_exception.raise_exception;

1265: WHEN OTHERS THEN
1266: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1267: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARK - '||SQLERRM);
1268: igs_ge_msg_stack.add;
1269: app_exception.raise_exception;
1270:
1271: END transfer_to_stark;
1272:
1273:

Line 1437: app_exception.raise_exception;

1433: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1434: fnd_message.set_token('TTYPE',p_trans_type);
1435: fnd_file.put_line( fnd_file.log, fnd_message.get());
1436: igs_ge_msg_stack.add;
1437: app_exception.raise_exception;
1438:
1439: WHEN OTHERS THEN
1440: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1441: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARN - '||SQLERRM);

Line 1443: app_exception.raise_exception;

1439: WHEN OTHERS THEN
1440: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1441: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARN - '||SQLERRM);
1442: igs_ge_msg_stack.add;
1443: app_exception.raise_exception;
1444:
1445: END transfer_to_starn;
1446:
1447:

Line 1598: app_exception.raise_exception;

1594: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1595: fnd_message.set_token('TTYPE',p_trans_type);
1596: fnd_file.put_line( fnd_file.log, fnd_message.get());
1597: igs_ge_msg_stack.add;
1598: app_exception.raise_exception;
1599:
1600: WHEN OTHERS THEN
1601: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1602: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARPQR - '||SQLERRM);

Line 1604: app_exception.raise_exception;

1600: WHEN OTHERS THEN
1601: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1602: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARPQR - '||SQLERRM);
1603: igs_ge_msg_stack.add;
1604: app_exception.raise_exception;
1605:
1606: END transfer_to_starpqr;
1607:
1608:

Line 1675: app_exception.raise_exception;

1671: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1672: fnd_message.set_token('TTYPE',p_trans_type);
1673: fnd_file.put_line( fnd_file.log, fnd_message.get());
1674: igs_ge_msg_stack.add;
1675: app_exception.raise_exception;
1676:
1677: WHEN OTHERS THEN
1678: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1679: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_START - '||SQLERRM);

Line 1681: app_exception.raise_exception;

1677: WHEN OTHERS THEN
1678: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1679: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_START - '||SQLERRM);
1680: igs_ge_msg_stack.add;
1681: app_exception.raise_exception;
1682:
1683: END transfer_to_start;
1684:
1685:

Line 1765: app_exception.raise_exception;

1761: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1762: fnd_message.set_token('TTYPE',p_trans_type);
1763: fnd_file.put_line( fnd_file.log, fnd_message.get());
1764: igs_ge_msg_stack.add;
1765: app_exception.raise_exception;
1766:
1767: WHEN OTHERS THEN
1768: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1769: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARW - '||SQLERRM);

Line 1771: app_exception.raise_exception;

1767: WHEN OTHERS THEN
1768: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1769: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARW - '||SQLERRM);
1770: igs_ge_msg_stack.add;
1771: app_exception.raise_exception;
1772:
1773: END transfer_to_starw;
1774:
1775:

Line 1852: app_exception.raise_exception;

1848: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1849: fnd_message.set_token('TTYPE',p_trans_type);
1850: fnd_file.put_line( fnd_file.log, fnd_message.get());
1851: igs_ge_msg_stack.add;
1852: app_exception.raise_exception;
1853:
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1856: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARX - '||SQLERRM);

Line 1858: app_exception.raise_exception;

1854: WHEN OTHERS THEN
1855: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1856: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARX - '||SQLERRM);
1857: igs_ge_msg_stack.add;
1858: app_exception.raise_exception;
1859:
1860: END transfer_to_starx;
1861:
1862:

Line 1988: app_exception.raise_exception;

1984: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
1985: fnd_message.set_token('TTYPE',p_trans_type);
1986: fnd_file.put_line( fnd_file.log, fnd_message.get());
1987: igs_ge_msg_stack.add;
1988: app_exception.raise_exception;
1989:
1990: WHEN OTHERS THEN
1991: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1992: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARZ - '||SQLERRM);

Line 1994: app_exception.raise_exception;

1990: WHEN OTHERS THEN
1991: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1992: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_STARZ - '||SQLERRM);
1993: igs_ge_msg_stack.add;
1994: app_exception.raise_exception;
1995:
1996: END transfer_to_starz;
1997:
1998:

Line 2053: app_exception.raise_exception;

2049: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2050: fnd_message.set_token('TTYPE',p_trans_type);
2051: fnd_file.put_line( fnd_file.log, fnd_message.get());
2052: igs_ge_msg_stack.add;
2053: app_exception.raise_exception;
2054:
2055: WHEN OTHERS THEN
2056: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2057: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QA - '||SQLERRM);

Line 2059: app_exception.raise_exception;

2055: WHEN OTHERS THEN
2056: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2057: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QA - '||SQLERRM);
2058: igs_ge_msg_stack.add;
2059: app_exception.raise_exception;
2060:
2061: END transfer_to_qa;
2062:
2063:

Line 2176: app_exception.raise_exception;

2172: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2173: fnd_message.set_token('TTYPE',p_trans_type);
2174: fnd_file.put_line( fnd_file.log, fnd_message.get());
2175: igs_ge_msg_stack.add;
2176: app_exception.raise_exception;
2177:
2178: WHEN OTHERS THEN
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QC - '||SQLERRM);

Line 2182: app_exception.raise_exception;

2178: WHEN OTHERS THEN
2179: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2180: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_TO_QC - '||SQLERRM);
2181: igs_ge_msg_stack.add;
2182: app_exception.raise_exception;
2183:
2184: END transfer_to_qc;
2185:
2186:

Line 2299: app_exception.raise_exception;

2295: fnd_message.set_token('APPNO',ln_appno);
2296: fnd_message.set_token('CHCNO',ln_choiceno);
2297: fnd_file.put_line( fnd_file.log, fnd_message.get());
2298: igs_ge_msg_stack.add;
2299: app_exception.raise_exception;
2300:
2301: ELSE
2302: -- update the corresponding transaction record with Timestamp and Errorcode
2303: igs_uc_transactions_pkg.update_row(

Line 2348: app_exception.raise_exception;

2344: fnd_message.set_name('IGS', 'IGS_UC_NON_NUMERIC_DATA');
2345: fnd_message.set_token('TTYPE',p_trans_type);
2346: fnd_file.put_line( fnd_file.log, fnd_message.get());
2347: igs_ge_msg_stack.add;
2348: app_exception.raise_exception;
2349:
2350: WHEN OTHERS THEN
2351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2352: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_ACK_TO_TRANS - '||SQLERRM);

Line 2354: app_exception.raise_exception;

2350: WHEN OTHERS THEN
2351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2352: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_ACK_TO_TRANS - '||SQLERRM);
2353: igs_ge_msg_stack.add;
2354: app_exception.raise_exception;
2355:
2356: END transfer_ack_to_trans;
2357:
2358:

Line 2452: app_exception.raise_exception;

2448: WHEN OTHERS THEN
2449: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2450: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.CHECK_VALIDITY - '||SQLERRM);
2451: igs_ge_msg_stack.add;
2452: app_exception.raise_exception;
2453:
2454: END check_validity;
2455:
2456:

Line 2499: WHEN app_exception.record_lock_exception THEN

2495: RETURN (RPAD(NVL(ucas_rec.record_data,' '),67) || merge_data(ucas_rec.marvin_id + 1));
2496: END IF;
2497:
2498: EXCEPTION
2499: WHEN app_exception.record_lock_exception THEN
2500: RAISE;
2501:
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2506: app_exception.raise_exception;

2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.MERGE_DATA - '||SQLERRM);
2505: igs_ge_msg_stack.add;
2506: app_exception.raise_exception;
2507:
2508: END merge_data;
2509:
2510:

Line 2546: WHEN app_exception.record_lock_exception THEN

2542: UPDATE IGS_UC_LOAD_MV_T SET record_data = lv_record_data, record_status = 'R' WHERE CURRENT OF cur_ucas;
2543: END LOOP;
2544:
2545: EXCEPTION
2546: WHEN app_exception.record_lock_exception THEN
2547: RAISE;
2548:
2549: WHEN OTHERS THEN
2550: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

Line 2553: app_exception.raise_exception;

2549: WHEN OTHERS THEN
2550: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2551: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.REARRANGE_DATA - '||SQLERRM);
2552: igs_ge_msg_stack.add;
2553: app_exception.raise_exception;
2554:
2555: END rearrange_data;
2556:
2557:

Line 2719: app_exception.raise_exception;

2715: fnd_file.put_line( fnd_file.log, 'TRANSACTION: ' ||l_trans_type || ' DATA : ' || l_curr_rec_data);
2716: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2717: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.TRANSFER_DATA - '||SQLERRM);
2718: igs_ge_msg_stack.add;
2719: app_exception.raise_exception;
2720:
2721: END transfer_data;
2722:
2723:

Line 2833: WHEN app_exception.record_lock_exception THEN

2829: COMMIT;
2830: fnd_file.put_line( fnd_file.log, ' ');
2831:
2832: EXCEPTION
2833: WHEN app_exception.record_lock_exception THEN
2834: ROLLBACK;
2835: retcode := 2;
2836: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
2837: igs_ge_msg_stack.conc_exception_hndl;