[Home] [Help]
1: PACKAGE BODY IGS_UC_MV_DATA_UPLD AS
2: /* $Header: IGSUC31B.pls 120.5 2006/08/21 03:52:35 jbaber ship $ */
3:
4: /*===============================================================================+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA |
6: | All rights reserved. |
7: +===============================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL spec for package: IGS_UC_MV_DATA_UPLD |
11: | |
12: | NOTES |
13: | This is a Concurrent requeset set which segregates the data into |
14: | dummy hercules table after checking and validating the data. |
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);
506: igs_ge_msg_stack.add;
507: app_exception.raise_exception;
508:
509: END transfer_to_stara;
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);
718: igs_ge_msg_stack.add;
719: app_exception.raise_exception;
720:
721: END transfer_to_starc;
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);
840: igs_ge_msg_stack.add;
841: app_exception.raise_exception;
842:
843: END transfer_to_starg;
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);
928: igs_ge_msg_stack.add;
929: app_exception.raise_exception;
930:
931: END transfer_to_starh;
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);
1268: igs_ge_msg_stack.add;
1269: app_exception.raise_exception;
1270:
1271: END transfer_to_stark;
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);
1442: igs_ge_msg_stack.add;
1443: app_exception.raise_exception;
1444:
1445: END transfer_to_starn;
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);
1603: igs_ge_msg_stack.add;
1604: app_exception.raise_exception;
1605:
1606: END transfer_to_starpqr;
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);
1680: igs_ge_msg_stack.add;
1681: app_exception.raise_exception;
1682:
1683: END transfer_to_start;
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);
1770: igs_ge_msg_stack.add;
1771: app_exception.raise_exception;
1772:
1773: END transfer_to_starw;
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);
1857: igs_ge_msg_stack.add;
1858: app_exception.raise_exception;
1859:
1860: END transfer_to_starx;
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);
1993: igs_ge_msg_stack.add;
1994: app_exception.raise_exception;
1995:
1996: END transfer_to_starz;
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);
2058: igs_ge_msg_stack.add;
2059: app_exception.raise_exception;
2060:
2061: END transfer_to_qa;
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);
2181: igs_ge_msg_stack.add;
2182: app_exception.raise_exception;
2183:
2184: END transfer_to_qc;
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);
2353: igs_ge_msg_stack.add;
2354: app_exception.raise_exception;
2355:
2356: END transfer_ack_to_trans;
2446:
2447: 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;
2500: RAISE;
2501:
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;
2547: RAISE;
2548:
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;
2713: EXCEPTION
2714: WHEN OTHERS THEN
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;
2839: WHEN OTHERS THEN
2840: ROLLBACK;
2841: retcode := 2;
2842: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2843: fnd_message.set_token('NAME','IGS_UC_MV_DATA_UPLD.PROCESS_MARVIN_DATA - '||SQLERRM);
2844: errbuf := fnd_message.get;
2845: igs_ge_msg_stack.conc_exception_hndl;
2846:
2847: END process_marvin_data;
2845: igs_ge_msg_stack.conc_exception_hndl;
2846:
2847: END process_marvin_data;
2848:
2849: END igs_uc_mv_data_upld;