1: PACKAGE BODY GL_JOURNAL_IMPORT_TAX_PKG AS
2: /* $Header: glujitxb.pls 120.3 2006/01/17 21:43:20 xiwu noship $ */
3: --
4: -- Wrappers
5: --
29: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
30: token_num => 2,
31: t1 =>'ROUTINE',
32: v1 =>
33: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
34: t2 =>'ACTION',
35: v2 =>'Wrong batch name: '
36: || p_batch_name);
37: --RAISE move_taxes_err;
37: --RAISE move_taxes_err;
38: RETURN;
39: END IF;
40: --
41: GL_JOURNAL_IMPORT_TAX_PKG.move_taxes_srs(l_batch_id);
42: --
43: EXCEPTION
44: WHEN OTHERS THEN
45: errbuf := SQLERRM;
123: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
124: token_num => 2,
125: t1 =>'ROUTINE',
126: v1 =>
127: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
128: t2 =>'ACTION',
129: v2 =>'Batch name:'
130: || l_name
131: ||' :SOB does not exist');
140: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
141: token_num => 2,
142: t1 =>'ROUTINE',
143: v1 =>
144: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
145: t2 =>'ACTION',
146: v2 =>'Batch name: '
147: || l_name
148: || ':cannot be taxed because '
157: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
158: token_num => 2,
159: t1 =>'ROUTINE',
160: v1 =>
161: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
162: t2 =>'ACTION',
163: v2 =>'Batch name: '
164: || l_name
165: || ':cannot be taxed because '
174: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
175: token_num => 2,
176: t1 =>'ROUTINE',
177: v1 =>
178: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
179: t2 =>'ACTION',
180: v2 =>'Batch name: '
181: || l_name
182: || ':cannot be taxed because '
191: -- GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
192: -- token_num => 2,
193: -- t1 =>'ROUTINE',
194: -- v1 =>
195: -- 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
196: -- t2 =>'ACTION',
197: -- v2 =>'Batch name: '
198: -- || l_name
199: -- || ':cannot be taxed because '
227: --GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
228: -- token_num => 2,
229: -- t1 =>'ROUTINE',
230: -- v1 =>
231: -- 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
232: -- t2 =>'ACTION',
233: -- v2 =>'Profile ORG_ID organization name:'
234: -- || l_org_name
235: -- || ':is used for further processing');
253: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
254: token_num => 2,
255: t1 =>'ROUTINE',
256: v1 =>
257: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
258: t2 =>'ACTION',
259: v2 =>'Batch :'
260: || l_name
261: ||':was not created by Spreadsheet');
349: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
350: token_num => 2,
351: t1 =>'ROUTINE',
352: v1 =>
353: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
354: t2 =>'ACTION',
355: v2 =>'Tax code:'
356: || l_je_line_attribute9
357: ||':cannot be found');
465: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
466: token_num => 2,
467: t1 =>'ROUTINE',
468: v1 =>
469: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
470: t2 =>'ACTION',
471: v2 =>'Batch name:'
472: || l_name
473: ||' :SOB does not exist');
481: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
482: token_num => 2,
483: t1 =>'ROUTINE',
484: v1 =>
485: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
486: t2 =>'ACTION',
487: v2 =>'Batch name: '
488: || l_name
489: || ':cannot be taxed because '
498: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
499: token_num => 2,
500: t1 =>'ROUTINE',
501: v1 =>
502: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
503: t2 =>'ACTION',
504: v2 =>'Batch name: '
505: || l_name
506: || ':cannot be taxed because '
515: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
516: token_num => 2,
517: t1 =>'ROUTINE',
518: v1 =>
519: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
520: t2 =>'ACTION',
521: v2 =>'Batch name: '
522: || l_name
523: || ':cannot be taxed because '
532: -- GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
533: -- token_num => 2,
534: -- t1 =>'ROUTINE',
535: -- v1 =>
536: -- 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
537: -- t2 =>'ACTION',
538: -- v2 =>'Batch name: '
539: -- || l_name
540: -- || ':cannot be taxed because '
568: --GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
569: -- token_num => 2,
570: -- t1 =>'ROUTINE',
571: -- v1 =>
572: -- 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
573: -- t2 =>'ACTION',
574: -- v2 =>'Profile ORG_ID organization name:'
575: -- || l_org_name
576: -- || ':is used for further processing');
594: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
595: token_num => 2,
596: t1 =>'ROUTINE',
597: v1 =>
598: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
599: t2 =>'ACTION',
600: v2 =>'Batch name:'
601: || l_name
602: ||':was not created by Spreadsheet');
692: GL_MESSAGE.Write_Log(msg_name =>'SHRD0180',
693: token_num => 2,
694: t1 =>'ROUTINE',
695: v1 =>
696: 'GL_JOURNAL_IMPORT_TAX_PKG.move_taxes',
697: t2 =>'ACTION',
698: v2 =>'Tax code:'
699: || l_je_line_attribute9
700: ||':cannot be found');
752: THEN
753: l_cur_batch_id_str :=
754: SUBSTR(p_batch_ids,l_last_sep_pos+1,l_new_sep_pos-l_last_sep_pos-1);
755: l_cur_batch_id_num := to_number(l_cur_batch_id_str,'9999999999');
756: GL_JOURNAL_IMPORT_TAX_PKG.move_taxes_hook(l_cur_batch_id_num);
757: --
758: IF (l_new_sep_pos = LENGTH(p_batch_ids))
759: THEN
760: EXIT;
767: END LOOP;
768: --
769: END process_batch_list;
770: --
771: END GL_JOURNAL_IMPORT_TAX_PKG;