APPS.JAI_BOE_MIGRATION_PKG dependencies on FND_FILE

Line 58: Fnd_File.put_line(Fnd_File.LOG,'**Entering boe_migration_batch for org_id:' ||ln_org_id||' migration_type:'||pv_migration_type||' migration_date'||ld_gl_date);

54: BEGIN
55: ld_gl_date := fnd_date.canonical_to_date(pv_migration_date);
56: ln_org_id := MO_GLOBAL.get_current_org_id();
57:
58: Fnd_File.put_line(Fnd_File.LOG,'**Entering boe_migration_batch for org_id:' ||ln_org_id||' migration_type:'||pv_migration_type||' migration_date'||ld_gl_date);
59:
60: IF pv_migration_type <> 'NONE' THEN
61: -- no accounting migration needed for 'None',don't check gl Date.
62: is_in_open_period(ld_gl_date,ln_org_id,lv_valid_flag);

Line 64: Fnd_File.put_line(Fnd_File.LOG,' ** migration date ' || ld_gl_date ||' is not in open period. ** ');

60: IF pv_migration_type <> 'NONE' THEN
61: -- no accounting migration needed for 'None',don't check gl Date.
62: is_in_open_period(ld_gl_date,ln_org_id,lv_valid_flag);
63: IF lv_valid_flag = 'N' THEN
64: Fnd_File.put_line(Fnd_File.LOG,' ** migration date ' || ld_gl_date ||' is not in open period. ** ');
65: RETURN;
66: END IF;--IF pv_migration_type <> 'NONE'
67: END IF;--lv_valid_flag = 'N'
68:

Line 145: Fnd_File.put_line(Fnd_File.LOG,' **Entering boe_migration for boe_id: '|| pn_boe_id ||' tax_category:' || pn_tax_category);

141:
142: boe_hdr_rec boe_hdr_cur%ROWTYPE;
143:
144: BEGIN
145: Fnd_File.put_line(Fnd_File.LOG,' **Entering boe_migration for boe_id: '|| pn_boe_id ||' tax_category:' || pn_tax_category);
146: -- Do validation for the provided boe_id and tax_category_id.
147: validation_boe(pn_org_id => pn_org_id
148: ,pn_boe_id => pn_boe_id
149: ,pn_tax_category_id => pn_tax_category

Line 182: Fnd_File.put_line(Fnd_File.LOG,'**Ending boe_migration after finish all operations. **');

178: accounting_migration(pn_boe_id => pn_boe_id
179: ,pn_availabe_boe_amount => ln_available_amount
180: ,pd_migration_date => pd_migration_date);
181: END IF;--pv_migration_type <> 'NONE'
182: Fnd_File.put_line(Fnd_File.LOG,'**Ending boe_migration after finish all operations. **');
183: RETURN;
184: ELSE
185: Fnd_File.put_line(Fnd_File.LOG,'*Exit migration for validation errors.');
186: RETURN;

Line 185: Fnd_File.put_line(Fnd_File.LOG,'*Exit migration for validation errors.');

181: END IF;--pv_migration_type <> 'NONE'
182: Fnd_File.put_line(Fnd_File.LOG,'**Ending boe_migration after finish all operations. **');
183: RETURN;
184: ELSE
185: Fnd_File.put_line(Fnd_File.LOG,'*Exit migration for validation errors.');
186: RETURN;
187:
188: END IF;--lv_valid_category_flag = 'Y'
189:

Line 192: Fnd_File.put_line(Fnd_File.LOG,' **Exit migration for invalid_tax_category_tax_type. ');

188: END IF;--lv_valid_category_flag = 'Y'
189:
190: EXCEPTION
191: WHEN invalid_tax_category_tax_type THEN
192: Fnd_File.put_line(Fnd_File.LOG,' **Exit migration for invalid_tax_category_tax_type. ');
193: ROLLBACK TO do_migration;
194: RETURN;
195:
196: WHEN OTHERS THEN

Line 197: Fnd_File.put_line(Fnd_File.LOG,' **Exit migration for unknow errors: ' || SQLERRM);

193: ROLLBACK TO do_migration;
194: RETURN;
195:
196: WHEN OTHERS THEN
197: Fnd_File.put_line(Fnd_File.LOG,' **Exit migration for unknow errors: ' || SQLERRM);
198: ROLLBACK TO do_migration;
199: RETURN;
200:
201: END boe_migration;

Line 253: Fnd_File.put_line(Fnd_File.LOG,' **Start update_boe_hdr for boe_id:' || pn_boe_id ||' invoice num:' || pv_invoice_num ||'applied amount:' || pn_amount_applied || ' **');

249: boe_invoice_payment_status AP_INVOICES.PAYMENT_STATUS_FLAG%TYPE;
250: boe_status jai_cmn_boe_hdrs.status%TYPE;
251:
252: BEGIN
253: Fnd_File.put_line(Fnd_File.LOG,' **Start update_boe_hdr for boe_id:' || pn_boe_id ||' invoice num:' || pv_invoice_num ||'applied amount:' || pn_amount_applied || ' **');
254:
255: OPEN boe_invoice_cur(pv_invoice_num);
256: FETCH boe_invoice_cur INTO boe_invoice_payment_status;
257: CLOSE boe_invoice_cur;

Line 278: Fnd_File.put_line(Fnd_File.LOG,' **Finish update_boe_hdr for boe_id:' || pn_boe_id ||' with boe status:' || boe_status || '--- **');

274: BOE_DATE = IMPORT_DATE,
275: last_update_date = SYSDATE,
276: last_updated_by = fnd_global.user_id
277: WHERE boe_id = pn_boe_id;
278: Fnd_File.put_line(Fnd_File.LOG,' **Finish update_boe_hdr for boe_id:' || pn_boe_id ||' with boe status:' || boe_status || '--- **');
279:
280: END update_boe_hdr;
281:
282: --==========================================================================

Line 406: Fnd_File.put_line(Fnd_File.LOG,'**Start merge_consolidate_boe_details for boe_id:'||pn_boe_id || ' with applied percentage:'||pn_percentage || '--- **');

402: detail_line_rec detail_line_cur%ROWTYPE;
403: l_boe_detail_type_rec JAI_BOE_DETAILS%ROWTYPE;
404: dedicate_dtls_rec dedicate_dtls_summary_type;
405: BEGIN
406: Fnd_File.put_line(Fnd_File.LOG,'**Start merge_consolidate_boe_details for boe_id:'||pn_boe_id || ' with applied percentage:'||pn_percentage || '--- **');
407:
408: OPEN consolidate_boe_detail_cur(pn_boe_id);
409: FETCH consolidate_boe_detail_cur INTO consolidate_boe_detail_rec;
410: CLOSE consolidate_boe_detail_cur;

Line 440: Fnd_File.put_line(Fnd_File.LOG,'**total_tax_amount:' ||dedicate_dtls_rec.total_tax_amount);

436: dedicate_dtls_rec.additional_CVD := nvl(consolidate_boe_detail_rec.additional_CVD,0);
437: dedicate_dtls_rec.customs_sh_education_cess := nvl(consolidate_boe_detail_rec.customs_sh_education_cess,0);
438: dedicate_dtls_rec.cvd_sh_edu_cess := nvl(consolidate_boe_detail_rec.cvd_sh_edu_cess,0);
439:
440: Fnd_File.put_line(Fnd_File.LOG,'**total_tax_amount:' ||dedicate_dtls_rec.total_tax_amount);
441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);
442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);

Line 441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);

437: dedicate_dtls_rec.customs_sh_education_cess := nvl(consolidate_boe_detail_rec.customs_sh_education_cess,0);
438: dedicate_dtls_rec.cvd_sh_edu_cess := nvl(consolidate_boe_detail_rec.cvd_sh_edu_cess,0);
439:
440: Fnd_File.put_line(Fnd_File.LOG,'**total_tax_amount:' ||dedicate_dtls_rec.total_tax_amount);
441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);
442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);

Line 442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);

438: dedicate_dtls_rec.cvd_sh_edu_cess := nvl(consolidate_boe_detail_rec.cvd_sh_edu_cess,0);
439:
440: Fnd_File.put_line(Fnd_File.LOG,'**total_tax_amount:' ||dedicate_dtls_rec.total_tax_amount);
441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);
442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);

Line 443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);

439:
440: Fnd_File.put_line(Fnd_File.LOG,'**total_tax_amount:' ||dedicate_dtls_rec.total_tax_amount);
441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);
442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);
447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);

Line 444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);

440: Fnd_File.put_line(Fnd_File.LOG,'**total_tax_amount:' ||dedicate_dtls_rec.total_tax_amount);
441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);
442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);
447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);
448: Fnd_File.put_line(Fnd_File.LOG,'**cvd_sh_edu_cess:' ||dedicate_dtls_rec.cvd_sh_edu_cess);

Line 445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);

441: Fnd_File.put_line(Fnd_File.LOG,'**customs:' || dedicate_dtls_rec.customs);
442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);
447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);
448: Fnd_File.put_line(Fnd_File.LOG,'**cvd_sh_edu_cess:' ||dedicate_dtls_rec.cvd_sh_edu_cess);
449:

Line 446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);

442: Fnd_File.put_line(Fnd_File.LOG,'**additional_customs_duty:' ||dedicate_dtls_rec.additional_customs_duty);
443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);
447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);
448: Fnd_File.put_line(Fnd_File.LOG,'**cvd_sh_edu_cess:' ||dedicate_dtls_rec.cvd_sh_edu_cess);
449:
450: insert_boe_detail(p_boe_detail_rec => l_boe_detail_type_rec);

Line 447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);

443: Fnd_File.put_line(Fnd_File.LOG,'**surcharge_duty:' ||dedicate_dtls_rec.surcharge_duty);
444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);
447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);
448: Fnd_File.put_line(Fnd_File.LOG,'**cvd_sh_edu_cess:' ||dedicate_dtls_rec.cvd_sh_edu_cess);
449:
450: insert_boe_detail(p_boe_detail_rec => l_boe_detail_type_rec);
451: details_split(dedicate_dtl_rec => dedicate_dtls_rec

Line 448: Fnd_File.put_line(Fnd_File.LOG,'**cvd_sh_edu_cess:' ||dedicate_dtls_rec.cvd_sh_edu_cess);

444: Fnd_File.put_line(Fnd_File.LOG,'**cvd_education_cess:'||dedicate_dtls_rec.cvd_education_cess);
445: Fnd_File.put_line(Fnd_File.LOG,'**customs_edu_cess:'||dedicate_dtls_rec.customs_edu_cess);
446: Fnd_File.put_line(Fnd_File.LOG,'**additional_CVD:'||dedicate_dtls_rec.additional_CVD);
447: Fnd_File.put_line(Fnd_File.LOG,'**customs_sh_education_cess:' ||dedicate_dtls_rec.customs_sh_education_cess);
448: Fnd_File.put_line(Fnd_File.LOG,'**cvd_sh_edu_cess:' ||dedicate_dtls_rec.cvd_sh_edu_cess);
449:
450: insert_boe_detail(p_boe_detail_rec => l_boe_detail_type_rec);
451: details_split(dedicate_dtl_rec => dedicate_dtls_rec
452: ,pn_tax_category_id => pn_tax_category_id

Line 455: Fnd_File.put_line(Fnd_File.LOG,'**Finish merge_consolidate_boe_details --- **');

451: details_split(dedicate_dtl_rec => dedicate_dtls_rec
452: ,pn_tax_category_id => pn_tax_category_id
453: ,pn_boe_detail_id => ln_boe_detail_id
454: ,pn_applied_percentage => pn_percentage);
455: Fnd_File.put_line(Fnd_File.LOG,'**Finish merge_consolidate_boe_details --- **');
456:
457: END merge_consolidate_boe_details;
458: --==========================================================================
459:

Line 525: Fnd_File.put_line(Fnd_File.LOG,' **Start merge_item_boe_details for boe_id:' ||pn_boe_id || ' with applied percentage:' ||pn_percentage || '--- **');

521: item_boe_detail_rec item_boe_detail_cur%ROWTYPE;
522: l_boe_detail_type_rec JAI_BOE_DETAILS%ROWTYPE;
523: dedicate_dtls_rec dedicate_dtls_summary_type;
524: BEGIN
525: Fnd_File.put_line(Fnd_File.LOG,' **Start merge_item_boe_details for boe_id:' ||pn_boe_id || ' with applied percentage:' ||pn_percentage || '--- **');
526:
527: FOR item_boe_detail_rec IN item_boe_detail_cur(pn_boe_id) LOOP
528:
529: OPEN detail_line_cur(pn_boe_id,item_boe_detail_rec.item_number);

Line 568: Fnd_File.put_line(Fnd_File.LOG,'**Finish merge_item_boe_details for boe_id:' ||pn_boe_id || ' with boe_detail_id:' ||ln_boe_detail_id || '--- **');

564: details_split(dedicate_dtls_rec
565: ,pn_tax_category_id
566: ,ln_boe_detail_id
567: ,pn_percentage);
568: Fnd_File.put_line(Fnd_File.LOG,'**Finish merge_item_boe_details for boe_id:' ||pn_boe_id || ' with boe_detail_id:' ||ln_boe_detail_id || '--- **');
569: END LOOP;
570: --CLOSE item_boe_detail_cur; --Commented by zhiwei for Bug#12777985 on 20110722
571:
572: END merge_item_boe_details;

Line 604: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_detail for boe_detail_id:' ||p_boe_detail_rec.BOE_DETAIL_ID || '--- **');

600:
601: --=========================================================================
602: PROCEDURE insert_boe_detail(p_boe_detail_rec IN JAI_BOE_DETAILS%ROWTYPE) IS
603: BEGIN
604: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_detail for boe_detail_id:' ||p_boe_detail_rec.BOE_DETAIL_ID || '--- **');
605:
606: INSERT INTO JAI_BOE_DETAILS
607: (BOE_DETAIL_ID,
608: DETAIL_LINE_NUM,

Line 677: Fnd_File.put_line(Fnd_File.LOG,'**Start insert_boe_detail_tax for BOE_DETAIL_TAX_ID:'||p_boe_detail_tax_rec.BOE_DETAIL_TAX_ID || '--- **');

673:
674: --=========================================================================
675: PROCEDURE insert_boe_detail_tax(p_boe_detail_tax_rec IN JAI_BOE_DETAIL_TAXES%ROWTYPE) IS
676: BEGIN
677: Fnd_File.put_line(Fnd_File.LOG,'**Start insert_boe_detail_tax for BOE_DETAIL_TAX_ID:'||p_boe_detail_tax_rec.BOE_DETAIL_TAX_ID || '--- **');
678: INSERT INTO JAI_BOE_DETAIL_TAXES
679: (BOE_DETAIL_TAX_ID,
680: BOE_DETAIL_ID,
681: TAX_LINE_NO,

Line 756: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_rounding for boe_id:' ||pn_boe_id || '--- **');

752: GROUP BY jbt.tax_id;
753:
754: boe_dtl_tax_rec boe_dtl_tax_cur%ROWTYPE;
755: BEGIN
756: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_boe_rounding for boe_id:' ||pn_boe_id || '--- **');
757:
758: FOR boe_dtl_tax_rec IN boe_dtl_tax_cur(pn_boe_id) LOOP
759:
760: SELECT jai_boe_roundings_s.NEXTVAL INTO ln_boe_rounding_id FROM dual;

Line 859: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' is invalid since not only 1 tax_id for the composition of tax_category_id:' ||pn_tax_category_id ||' and tax_type : ' || pv_tax_type || '** ');

855: FETCH tax_cnt_cur INTO ln_tax_cnt;
856: CLOSE tax_cnt_cur;
857:
858: IF ln_tax_cnt <> 1 THEN
859: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' is invalid since not only 1 tax_id for the composition of tax_category_id:' ||pn_tax_category_id ||' and tax_type : ' || pv_tax_type || '** ');
860: RAISE invalid_tax_category_tax_type;
861: END IF;
862:
863: OPEN tax_cur(pn_tax_category_id,pv_tax_type);

Line 869: Fnd_File.put_line(Fnd_File.LOG,' **Finish get_tax_id for category_id:' ||pn_tax_category_id || ' tax_type:' || pv_tax_type ||'and get tax_id =' || xn_tax_id || ' --- **');

865: CLOSE tax_cur;
866:
867: xn_tax_id := tax_rec.tax_id;
868:
869: Fnd_File.put_line(Fnd_File.LOG,' **Finish get_tax_id for category_id:' ||pn_tax_category_id || ' tax_type:' || pv_tax_type ||'and get tax_id =' || xn_tax_id || ' --- **');
870:
871: END get_tax_id;
872:
873: --==========================================================================

Line 926: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_tax_wise_data for boe_detail_id:' ||pn_boe_detail_id || '--- **');

922: ln_boe_tax_id NUMBER;
923: l_boe_tax_type_rec JAI_BOE_DETAIL_TAXES%ROWTYPE;
924:
925: BEGIN
926: Fnd_File.put_line(Fnd_File.LOG,' **Start insert_tax_wise_data for boe_detail_id:' ||pn_boe_detail_id || '--- **');
927: get_tax_id(pn_tax_category_id => pn_tax_category_id
928: ,pv_tax_type => pv_tax_type
929: --OUT--
930: ,xn_tax_id => ln_tax_id);

Line 988: Fnd_File.put_line(Fnd_File.LOG,' **Start details_split for boe_detail_id:' ||pn_boe_detail_id || '--- **');

984: ,pn_applied_percentage NUMBER
985: ) IS
986: ln_boe_tax_line_num NUMBER := 0;
987: BEGIN
988: Fnd_File.put_line(Fnd_File.LOG,' **Start details_split for boe_detail_id:' ||pn_boe_detail_id || '--- **');
989: IF nvl(dedicate_dtl_rec.customs,0) > 0 THEN
990: ln_boe_tax_line_num := ln_boe_tax_line_num + 1;
991: insert_tax_wise_data(pn_tax_category_id => pn_tax_category_id
992: ,pv_tax_type => jai_constants.tax_type_customs

Line 1144: Fnd_File.put_line(Fnd_File.LOG,' **Start validation_boe for boe_id:' || pn_boe_id || '--- **');

1140: boe_rec boe_cur%ROWTYPE;
1141: ln_org_id_tax_category NUMBER;
1142: ln_available_amount NUMBER := 0;
1143: BEGIN
1144: Fnd_File.put_line(Fnd_File.LOG,' **Start validation_boe for boe_id:' || pn_boe_id || '--- **');
1145: xv_valid_flag := 'Y';
1146: OPEN boe_cur(pn_boe_id);
1147: FETCH boe_cur INTO boe_rec;
1148: CLOSE boe_cur;

Line 1156: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' does not exist. ** ');

1152: CLOSE tax_category_cur;
1153:
1154: IF boe_rec.boe_id IS NULL THEN
1155: xv_valid_flag := 'N';
1156: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' does not exist. ** ');
1157: RETURN;
1158: END IF;--boe_rec.boe_id IS NULL
1159:
1160: IF boe_rec.ou_id <> pn_org_id THEN

Line 1162: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id || 'with org_id '||boe_rec.ou_id ||' is not in the default ou'||pn_org_id ||' , no need to migrate. ** ');

1158: END IF;--boe_rec.boe_id IS NULL
1159:
1160: IF boe_rec.ou_id <> pn_org_id THEN
1161: xv_valid_flag := 'N';
1162: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id || 'with org_id '||boe_rec.ou_id ||' is not in the default ou'||pn_org_id ||' , no need to migrate. ** ');
1163: RETURN;
1164: END IF;-- boe_rec.ou_id <> pn_org_id
1165:
1166: IF ln_org_id_tax_category <> pn_org_id THEN

Line 1168: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id || ' is not in the default ou'||pn_org_id ||' , no need to migrate. ** ');

1164: END IF;-- boe_rec.ou_id <> pn_org_id
1165:
1166: IF ln_org_id_tax_category <> pn_org_id THEN
1167: xv_valid_flag := 'N';
1168: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id || ' is not in the default ou'||pn_org_id ||' , no need to migrate. ** ');
1169: RETURN;
1170: END IF;--ln_org_id_tax_category <> pn_org_id
1171:
1172: IF nvl(boe_rec.AMOUNT_WRITTEN_OFF,0) > 0 THEN

Line 1174: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' has been written off, no need to migrate. ** ');

1170: END IF;--ln_org_id_tax_category <> pn_org_id
1171:
1172: IF nvl(boe_rec.AMOUNT_WRITTEN_OFF,0) > 0 THEN
1173: xv_valid_flag := 'N';
1174: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' has been written off, no need to migrate. ** ');
1175: RETURN;
1176: END IF;--nvl(boe_rec.AMOUNT_WRITTEN_OFF,0) > 0
1177:
1178: ln_available_amount := nvl(boe_rec.BOE_AMOUNT,0) - nvl(boe_rec.amount_applied,0);

Line 1182: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' has no available amount but migration type is unapplied. ** ');

1178: ln_available_amount := nvl(boe_rec.BOE_AMOUNT,0) - nvl(boe_rec.amount_applied,0);
1179:
1180: IF ln_available_amount = 0 THEN
1181: xv_valid_flag := 'N';
1182: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' has no available amount but migration type is unapplied. ** ');
1183: RETURN;
1184: END IF;-- ln_available_amount = 0
1185:
1186: IF boe_rec.status IS NOT NULL OR boe_rec.migration_flag IS NOT NULL THEN

Line 1188: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' is not a dedicate BOE. ** ');

1184: END IF;-- ln_available_amount = 0
1185:
1186: IF boe_rec.status IS NOT NULL OR boe_rec.migration_flag IS NOT NULL THEN
1187: xv_valid_flag := 'N';
1188: Fnd_File.put_line(Fnd_File.LOG,' ** boe_id ' || pn_boe_id ||' is not a dedicate BOE. ** ');
1189: RETURN;
1190: END IF; --boe_rec.status IS NOT NULL OR boe_rec.migration_flag IS NOT NULL
1191: IS_BOE_TAX_Category(pn_tax_category_id
1192: ,xv_valid_flag);

Line 1194: Fnd_File.put_line(Fnd_File.LOG,' ** invalid tax_category_id. ** ');

1190: END IF; --boe_rec.status IS NOT NULL OR boe_rec.migration_flag IS NOT NULL
1191: IS_BOE_TAX_Category(pn_tax_category_id
1192: ,xv_valid_flag);
1193: IF xv_valid_flag = 'N' THEN
1194: Fnd_File.put_line(Fnd_File.LOG,' ** invalid tax_category_id. ** ');
1195: RETURN;
1196: END IF; --pv_valid_flag = 'N'
1197:
1198:

Line 1272: Fnd_File.put_line(Fnd_File.LOG,' **Start is_boe_tax_Category for tax_category_id:' ||pn_tax_category_id || '--- **');

1268: ln_cnt NUMBER := 0;
1269:
1270:
1271: BEGIN
1272: Fnd_File.put_line(Fnd_File.LOG,' **Start is_boe_tax_Category for tax_category_id:' ||pn_tax_category_id || '--- **');
1273: xv_valid_flag := 'Y';
1274:
1275: FOR tax_category_rec IN tax_category_cur(pn_tax_category_id) LOOP
1276: ln_cnt := ln_cnt + 1;

Line 1279: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||'has non customs tax_id ' ||tax_category_rec.tax_id || '** ');

1275: FOR tax_category_rec IN tax_category_cur(pn_tax_category_id) LOOP
1276: ln_cnt := ln_cnt + 1;
1277: IF tax_category_rec.regime_code <> jai_constants.customs_regime THEN
1278: xv_valid_flag := 'N';
1279: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||'has non customs tax_id ' ||tax_category_rec.tax_id || '** ');
1280: EXIT;
1281: END IF;
1282: END LOOP;
1283:

Line 1286: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' does not exist. ** ');

1282: END LOOP;
1283:
1284: IF ln_cnt = 0 THEN
1285: xv_valid_flag := 'N';
1286: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' does not exist. ** ');
1287: RETURN;
1288: END IF;
1289:
1290: FOR tax_id_cnt_rec IN tax_id_cnt_cur(pn_tax_category_id) LOOP

Line 1293: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' has more than 1 tax_id for the same tax_type. ** ');

1289:
1290: FOR tax_id_cnt_rec IN tax_id_cnt_cur(pn_tax_category_id) LOOP
1291: IF tax_id_cnt_rec.cnt_tax_id > 1 THEN
1292: xv_valid_flag := 'N';
1293: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' has more than 1 tax_id for the same tax_type. ** ');
1294: EXIT;
1295: END IF;
1296: END LOOP;
1297: Fnd_File.put_line(Fnd_File.LOG,' **Finished is_boe_tax_Category');

Line 1297: Fnd_File.put_line(Fnd_File.LOG,' **Finished is_boe_tax_Category');

1293: Fnd_File.put_line(Fnd_File.LOG,' ** tax_category_id ' || pn_tax_category_id ||' has more than 1 tax_id for the same tax_type. ** ');
1294: EXIT;
1295: END IF;
1296: END LOOP;
1297: Fnd_File.put_line(Fnd_File.LOG,' **Finished is_boe_tax_Category');
1298: END is_boe_tax_Category;
1299: --==========================================================================
1300:
1301: -- PROCEDURE NAME:

Line 1349: Fnd_File.put_line(Fnd_File.LOG,' **Start is_in_open_period for date:' || pd_date ||'--- **');

1345: WHERE organization_id = v_org_id;
1346: ln_ledger_id NUMBER;
1347:
1348: BEGIN
1349: Fnd_File.put_line(Fnd_File.LOG,' **Start is_in_open_period for date:' || pd_date ||'--- **');
1350: xv_open_flag := 'Y';
1351:
1352: OPEN ledger_cur(pn_ou_id);
1353: FETCH ledger_cur INTO ln_ledger_id;

Line 1356: Fnd_File.put_line(Fnd_File.LOG,'ledger id is:'||ln_ledger_id);

1352: OPEN ledger_cur(pn_ou_id);
1353: FETCH ledger_cur INTO ln_ledger_id;
1354: CLOSE ledger_cur;
1355:
1356: Fnd_File.put_line(Fnd_File.LOG,'ledger id is:'||ln_ledger_id);
1357:
1358: SELECT COUNT(1)
1359: INTO ln_count
1360: FROM gl_period_statuses_v gpsv,

Line 1368: Fnd_File.put_line(Fnd_File.LOG,'count of open period records:'||ln_count);

1364: AND pd_date BETWEEN gpsv.start_date AND NVL(gpsv.end_date,pd_date)
1365: AND fa.application_short_name = 'SQLGL'
1366: AND gpsv.set_of_books_id = ln_ledger_id;
1367:
1368: Fnd_File.put_line(Fnd_File.LOG,'count of open period records:'||ln_count);
1369: IF ln_count = 0 THEN
1370: xv_open_flag := 'N';
1371: END IF;--ln_count = 0
1372: END is_in_open_period;

Line 1506: Fnd_File.put_line(Fnd_File.LOG,'Paid_payables account is not setup for tax type:'||tax_type_amount_rec.tax_type);

1502: ,lv_reference24
1503: ,lv_reference25
1504: ,lv_reference26);
1505: ELSE
1506: Fnd_File.put_line(Fnd_File.LOG,'Paid_payables account is not setup for tax type:'||tax_type_amount_rec.tax_type);
1507: END IF; --ln_tax_account_ccid IS NOT NULL
1508:
1509: END LOOP;
1510: