DBA Data[Home] [Help]

APPS.IGS_UC_MV_DATA_UPLD dependencies on IGS_GE_MSG_STACK

Line 132: igs_ge_msg_stack.add;

128: 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:

Line 168: igs_ge_msg_stack.add;

164: l_num := 0;
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);

Line 178: igs_ge_msg_stack.add;

174: 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:

Line 258: igs_ge_msg_stack.add;

254: 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:

Line 350: igs_ge_msg_stack.add;

346: 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:

Line 500: igs_ge_msg_stack.add;

496: WHEN VALUE_ERROR THEN
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');

Line 506: igs_ge_msg_stack.add;

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;
510:

Line 712: igs_ge_msg_stack.add;

708: WHEN VALUE_ERROR THEN
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');

Line 718: igs_ge_msg_stack.add;

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;
722:

Line 834: igs_ge_msg_stack.add;

830: WHEN VALUE_ERROR THEN
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');

Line 840: igs_ge_msg_stack.add;

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;
844:

Line 922: igs_ge_msg_stack.add;

918: WHEN VALUE_ERROR THEN
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');

Line 928: igs_ge_msg_stack.add;

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;
932:

Line 1262: igs_ge_msg_stack.add;

1258: WHEN VALUE_ERROR THEN
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');

Line 1268: igs_ge_msg_stack.add;

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;
1272:

Line 1436: igs_ge_msg_stack.add;

1432: WHEN VALUE_ERROR THEN
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');

Line 1442: igs_ge_msg_stack.add;

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;
1446:

Line 1597: igs_ge_msg_stack.add;

1593: WHEN VALUE_ERROR THEN
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');

Line 1603: igs_ge_msg_stack.add;

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;
1607:

Line 1674: igs_ge_msg_stack.add;

1670: WHEN VALUE_ERROR THEN
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');

Line 1680: igs_ge_msg_stack.add;

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;
1684:

Line 1764: igs_ge_msg_stack.add;

1760: WHEN VALUE_ERROR THEN
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');

Line 1770: igs_ge_msg_stack.add;

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;
1774:

Line 1851: igs_ge_msg_stack.add;

1847: WHEN VALUE_ERROR THEN
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');

Line 1857: igs_ge_msg_stack.add;

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;
1861:

Line 1987: igs_ge_msg_stack.add;

1983: WHEN VALUE_ERROR THEN
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');

Line 1993: igs_ge_msg_stack.add;

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;
1997:

Line 2052: igs_ge_msg_stack.add;

2048: WHEN VALUE_ERROR THEN
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');

Line 2058: igs_ge_msg_stack.add;

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;
2062:

Line 2175: igs_ge_msg_stack.add;

2171: WHEN VALUE_ERROR THEN
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');

Line 2181: igs_ge_msg_stack.add;

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;
2185:

Line 2298: igs_ge_msg_stack.add;

2294: fnd_message.set_token('TTYPE',p_trans_type);
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

Line 2347: igs_ge_msg_stack.add;

2343: WHEN VALUE_ERROR THEN
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');

Line 2353: igs_ge_msg_stack.add;

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;
2357:

Line 2451: igs_ge_msg_stack.add;

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;
2455:

Line 2505: igs_ge_msg_stack.add;

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;
2509:

Line 2552: igs_ge_msg_stack.add;

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;
2556:

Line 2718: igs_ge_msg_stack.add;

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;
2722:

Line 2837: igs_ge_msg_stack.conc_exception_hndl;

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;
2838:
2839: WHEN OTHERS THEN
2840: ROLLBACK;
2841: retcode := 2;

Line 2845: igs_ge_msg_stack.conc_exception_hndl;

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;
2848:
2849: END igs_uc_mv_data_upld;