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.FV_IPAC dependencies on FND_LOG

Line 347: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

343: EXCEPTION
344: WHEN OTHERS THEN
345: errbuf := SQLERRM;
346: errbuf := 'When others ' || SQLERRM;
347: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
349: l_module_name, errbuf);
350: END IF;
351: RAISE;

Line 348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

344: WHEN OTHERS THEN
345: errbuf := SQLERRM;
346: errbuf := 'When others ' || SQLERRM;
347: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
349: l_module_name, errbuf);
350: END IF;
351: RAISE;
352: END ; --init_vars

Line 375: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

371: EXCEPTION
372: WHEN OTHERS THEN
373: errcode := SQLCODE;
374: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- del_exception_recs' ;
375: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
377: END IF;
378: RAISE;
379: END; -- del_exception_recs

Line 376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

372: WHEN OTHERS THEN
373: errcode := SQLCODE;
374: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- del_exception_recs' ;
375: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
377: END IF;
378: RAISE;
379: END; -- del_exception_recs
380:

Line 397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

393: AND ipac_billing_id BETWEEN g_start_billing_id AND g_end_billing_id ;
394: EXCEPTION
395:
396: WHEN NO_DATA_FOUND THEN
397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
398: 'No Records For Deletion ' );
399:
400: WHEN OTHERS THEN
401: errcode := SQLCODE;

Line 403: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

399:
400: WHEN OTHERS THEN
401: errcode := SQLCODE;
402: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- delete_records' ;
403: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
404: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
405: END IF;
406: RAISE;
407: END delete_records;

Line 404: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

400: WHEN OTHERS THEN
401: errcode := SQLCODE;
402: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- delete_records' ;
403: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
404: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
405: END IF;
406: RAISE;
407: END delete_records;
408:

Line 444: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Chart of Accounts Id,Bal Segment,Acct Segment,Flex Value Set Id:'|| flex_num||','||bl_seg_name||','||gbl_gl_segment_name||','|| gbl_gl_acc_value_set_id);

440: errcode := SQLCODE;
441: errmsg := SQLERRM ||' -- Error in geting the Value set ID ' || 'attached to the GL Account segment :' || 'Procedure :- get_bal_seg_name' ;
442: RAISE;
443: END;
444: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Chart of Accounts Id,Bal Segment,Acct Segment,Flex Value Set Id:'|| flex_num||','||bl_seg_name||','||gbl_gl_segment_name||','|| gbl_gl_acc_value_set_id);
445: EXCEPTION
446: WHEN OTHERS THEN
447: IF errcode IS NULL THEN
448: errcode := SQLCODE;

Line 451: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

447: IF errcode IS NULL THEN
448: errcode := SQLCODE;
449: errmsg := SQLERRM ||' -- Error IN geting the Segment Name :' || ' Procedure :- get_bal_seg_name' ;
450: END IF;
451: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
453: END IF;
454: RAISE;
455: END; -- get_bal_seg_name

Line 452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

448: errcode := SQLCODE;
449: errmsg := SQLERRM ||' -- Error IN geting the Segment Name :' || ' Procedure :- get_bal_seg_name' ;
450: END IF;
451: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
453: END IF;
454: RAISE;
455: END; -- get_bal_seg_name
456:

Line 489: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

485: v_treasury_symbol := '1';
486: WHEN OTHERS THEN
487: errmsg := SQLERRM;
488: errcode := SQLCODE;
489: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
491: END IF;
492: RAISE;
493: END; -- get_treasury_symbol

Line 490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

486: WHEN OTHERS THEN
487: errmsg := SQLERRM;
488: errcode := SQLCODE;
489: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
491: END IF;
492: RAISE;
493: END; -- get_treasury_symbol
494:

Line 508: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

504: -- Get the exception only if the account class is not REC
505: IF transaction_rec.account_class <> 'REC' THEN -- REC check
506: IF (v_receipt_method_id IS NULL ) THEN --RM check
507: v_trx_excpt_cat := 'MISSING_PAYMENT_METHOD';
508: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_PAYMENT_METHOD');
510: END IF;
511: --
512: /*

Line 509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_PAYMENT_METHOD');

505: IF transaction_rec.account_class <> 'REC' THEN -- REC check
506: IF (v_receipt_method_id IS NULL ) THEN --RM check
507: v_trx_excpt_cat := 'MISSING_PAYMENT_METHOD';
508: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_PAYMENT_METHOD');
510: END IF;
511: --
512: /*
513: ELSIF v_receipt_method_id IS NOT NULL THEN --RM check

Line 525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

521: AND aba.currency_code = nvl(parm_currency,v_invoice_currency)
522: AND arma.primary_flag = 'Y'
523: AND arma.receipt_method_id = v_receipt_method_id;
524:
525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
526: THEN
527: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
528: l_module_name,'receipt_method_id IS NOT null,
529: v_sender_alc ='|| v_sender_alc);

Line 527: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

523: AND arma.receipt_method_id = v_receipt_method_id;
524:
525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
526: THEN
527: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
528: l_module_name,'receipt_method_id IS NOT null,
529: v_sender_alc ='|| v_sender_alc);
530: END IF;
531:

Line 534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

530: END IF;
531:
532: IF v_sender_alc IS NULL THEN
533: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
535: THEN
536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
537: l_module_name,'MISSING_BANK_ACCT_ALC');
538: END IF;

Line 536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

532: IF v_sender_alc IS NULL THEN
533: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
534: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
535: THEN
536: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
537: l_module_name,'MISSING_BANK_ACCT_ALC');
538: END IF;
539: END IF;
540: EXCEPTION

Line 545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

541: WHEN NO_DATA_FOUND THEN
542: IF v_default_alc <> 'N' THEN
543: v_sender_alc := v_default_alc;
544:
545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
546: THEN
547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
548: l_module_name,'no data and DEFAULT alc v_sender_alc ='
549: || v_sender_alc);

Line 547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

543: v_sender_alc := v_default_alc;
544:
545: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
546: THEN
547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
548: l_module_name,'no data and DEFAULT alc v_sender_alc ='
549: || v_sender_alc);
550: END IF;
551: ELSE

Line 553: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

549: || v_sender_alc);
550: END IF;
551: ELSE
552: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
553: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
554: THEN
555: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
556: l_module_name,'MISSING_BANK_ACCT_ALC');
557: END IF;

Line 555: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

551: ELSE
552: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
553: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
554: THEN
555: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
556: l_module_name,'MISSING_BANK_ACCT_ALC');
557: END IF;
558: END IF;
559: WHEN OTHERS THEN

Line 562: IF ( FND_LOG.LEVEL_UNEXPECTED >=

558: END IF;
559: WHEN OTHERS THEN
560: errmsg := SQLERRM||'-- Error in Get_Trx_Exception when
561: getting the ALC,when receipt method is not null';
562: IF ( FND_LOG.LEVEL_UNEXPECTED >=
563: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
565: l_module_name,errmsg);
566: END IF;

Line 563: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

559: WHEN OTHERS THEN
560: errmsg := SQLERRM||'-- Error in Get_Trx_Exception when
561: getting the ALC,when receipt method is not null';
562: IF ( FND_LOG.LEVEL_UNEXPECTED >=
563: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
565: l_module_name,errmsg);
566: END IF;
567: RAISE;

Line 564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

560: errmsg := SQLERRM||'-- Error in Get_Trx_Exception when
561: getting the ALC,when receipt method is not null';
562: IF ( FND_LOG.LEVEL_UNEXPECTED >=
563: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
565: l_module_name,errmsg);
566: END IF;
567: RAISE;
568: END;

Line 572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

568: END;
569: ELSIF (v_receipt_method_id IS NULL AND v_default_alc <> 'N')
570: THEN --RM check
571: v_sender_alc := v_default_alc;
572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
573: THEN
574: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
575: 'Receipt Method is null and sender ALC ='|| v_sender_alc);
576: END IF;

Line 574: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

570: THEN --RM check
571: v_sender_alc := v_default_alc;
572: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
573: THEN
574: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
575: 'Receipt Method is null and sender ALC ='|| v_sender_alc);
576: END IF;
577: */
578:

Line 589: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

585: --Bug9025655. Since there could be multiple bank accounts
586: --without end dates, this select will bring in multiple rows.
587: --Restricting to fetch one row.
588: BEGIN
589: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
590: 'Customer ID = ' || transaction_rec.customer_id ||
591: ' p_bill_to_address_id = ' || p_bill_to_address_id);
592: SELECT eb.agency_location_code
593: INTO v_customer_alc

Line 613: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

609: AND iby_ins.instrument_id = eb.ext_bank_account_id
610: AND rownum = 1;
611: EXCEPTION
612: WHEN NO_DATA_FOUND THEN
613: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
614: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC-No Primary Bank AcctDefined');
615: END IF;
616: v_trx_excpt_cat := 'MISSING_CUST_ALC';
617: END;

Line 614: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC-No Primary Bank AcctDefined');

610: AND rownum = 1;
611: EXCEPTION
612: WHEN NO_DATA_FOUND THEN
613: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
614: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC-No Primary Bank AcctDefined');
615: END IF;
616: v_trx_excpt_cat := 'MISSING_CUST_ALC';
617: END;
618: IF v_customer_alc IS NULL THEN

Line 619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

615: END IF;
616: v_trx_excpt_cat := 'MISSING_CUST_ALC';
617: END;
618: IF v_customer_alc IS NULL THEN
619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
620: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC - No ALC defined');
621: END IF;
622: v_trx_excpt_cat := 'MISSING_CUST_ALC';
623: END IF;

Line 620: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC - No ALC defined');

616: v_trx_excpt_cat := 'MISSING_CUST_ALC';
617: END;
618: IF v_customer_alc IS NULL THEN
619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
620: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC - No ALC defined');
621: END IF;
622: v_trx_excpt_cat := 'MISSING_CUST_ALC';
623: END IF;
624: END IF; -- end customer alc check

Line 660: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

656: RETURN v_trx_excpt_cat;
657: EXCEPTION
658: WHEN OTHERS THEN
659: errmsg :=SQLERRM;
660: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
662: END IF;
663: RAISE;
664: END ; -- get_trx_exception

Line 661: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

657: EXCEPTION
658: WHEN OTHERS THEN
659: errmsg :=SQLERRM;
660: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
662: END IF;
663: RAISE;
664: END ; -- get_trx_exception
665:

Line 787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

783: l_module_name VARCHAR2(200);
784: BEGIN
785: l_module_name:=g_module_name||'gl_account_num';
786:
787: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
788: 'gl_account_num begins');
789:
790:
791: SELECT DECODE (gbl_gl_segment_name,

Line 827: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

823: FROM gl_code_combinations glc
824: WHERE code_combination_id = p_ccid
825: AND glc.chart_of_accounts_id = flex_num;
826:
827: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
828: 'l_gl_account_num = '||l_gl_account_num);
829:
830: RETURN l_gl_account_num;
831: EXCEPTION

Line 838: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

834: errmsg := SQLERRM
835: || ' -- Error in getting the GL Account number :'
836: || ' Funcation :- gl_account_num';
837:
838: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
839: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
840: l_module_name, errmsg);
841: END IF;
842: RAISE;

Line 839: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

835: || ' -- Error in getting the GL Account number :'
836: || ' Funcation :- gl_account_num';
837:
838: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
839: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
840: l_module_name, errmsg);
841: END IF;
842: RAISE;
843: END gl_account_num;

Line 856: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

852: l_module_name VARCHAR2(200);
853: BEGIN
854: l_module_name:=g_module_name||'gl_account_type';
855:
856: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
857: 'gl_account_type begins');
858:
859: -- Account Type of the Code combination ID
860: SELECT SUBSTR(compiled_value_attributes, 5, 1)

Line 866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

862: FROM fnd_flex_values
863: WHERE flex_value = p_gl_account
864: AND flex_value_set_id = gbl_gl_acc_value_set_id;
865:
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
867: 'l_account_type='||l_account_type);
868:
869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

865:
866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
867: 'l_account_type='||l_account_type);
868:
869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
871: 'Account: '||p_gl_account || ' Account type: '|| l_account_type );
872: END IF;
873: RETURN l_account_type;

Line 870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

866: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
867: 'l_account_type='||l_account_type);
868:
869: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
871: 'Account: '||p_gl_account || ' Account type: '|| l_account_type );
872: END IF;
873: RETURN l_account_type;
874: EXCEPTION

Line 880: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

876: errcode :=SQLCODE;
877: errmsg := SQLERRM
878: || ' -- Error in getting the GL Account type :'
879: || ' Funcation :- gl_account_type';
880: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
881: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
882: errmsg);
883: END IF;
884: RAISE;

Line 881: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

877: errmsg := SQLERRM
878: || ' -- Error in getting the GL Account type :'
879: || ' Funcation :- gl_account_type';
880: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
881: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
882: errmsg);
883: END IF;
884: RAISE;
885: END gl_account_type;

Line 946: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

942: END ;
943: WHEN OTHERS THEN
944: errcode := SQLCODE;
945: errmsg := SQLERRM || ' -- Error in geting the USSGL Account :' || ' Function :- get_ussgl_account';
946: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
948: END IF;
949: RAISE;
950: END get_ussgl_account;

Line 947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

943: WHEN OTHERS THEN
944: errcode := SQLCODE;
945: errmsg := SQLERRM || ' -- Error in geting the USSGL Account :' || ' Function :- get_ussgl_account';
946: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
948: END IF;
949: RAISE;
950: END get_ussgl_account;
951:

Line 961: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

957: IS
958: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
959: l_valid_flag VARCHAR2(1);
960: BEGIN
961: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
962: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC FY2003-04 GET SGL EXCEPTION');
963: END IF;
964: -- Checking for the Account type
965: -- If the account type is budgetary Cr/Dr and account class

Line 962: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC FY2003-04 GET SGL EXCEPTION');

958: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
959: l_valid_flag VARCHAR2(1);
960: BEGIN
961: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
962: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC FY2003-04 GET SGL EXCEPTION');
963: END IF;
964: -- Checking for the Account type
965: -- If the account type is budgetary Cr/Dr and account class
966: -- is equal to the REC then return the exception else return the

Line 975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

971: -- Get the USSGL Number and the Valid Flag
972: p_sgl_acct_num := get_ussgl_account(p_acct_num,l_valid_flag);
973: IF l_valid_flag = 'N' THEN
974: -- Invalid USSGL Account
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Exception SGL Account - Invalid SGL Account: ' || l_sgl_acct_num);
977: END IF;
978: RETURN 'INVALID_SGL_ACCOUNT';
979: END IF;

Line 976: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Exception SGL Account - Invalid SGL Account: ' || l_sgl_acct_num);

972: p_sgl_acct_num := get_ussgl_account(p_acct_num,l_valid_flag);
973: IF l_valid_flag = 'N' THEN
974: -- Invalid USSGL Account
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Exception SGL Account - Invalid SGL Account: ' || l_sgl_acct_num);
977: END IF;
978: RETURN 'INVALID_SGL_ACCOUNT';
979: END IF;
980: -- No SGL Exception

Line 986: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

982: EXCEPTION
983: WHEN OTHERS THEN
984: errcode :=SQLCODE;
985: errmsg :=SQLERRM|| ' -- Error in getting the USSGL Exception Function ' || ' - get_sgl_exception';
986: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
988: END IF;
989: RAISE;
990: END get_sgl_exception;

Line 987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

983: WHEN OTHERS THEN
984: errcode :=SQLCODE;
985: errmsg :=SQLERRM|| ' -- Error in getting the USSGL Exception Function ' || ' - get_sgl_exception';
986: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
988: END IF;
989: RAISE;
990: END get_sgl_exception;
991: /*

Line 1183: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: errcode :=SQLCODE;
1182: errmsg := SQLERRM || ' -- Error IN getting' ||' the EXCEED_CR_DR EXCEPTION :' ||' PROCEDURE :- exceed_dr_cr_count_exception';
1183: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1185: END IF;
1186: RAISE;
1187: END exceed_dr_cr_sgl_mismatch_exc;

Line 1184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

1180: WHEN OTHERS THEN
1181: errcode :=SQLCODE;
1182: errmsg := SQLERRM || ' -- Error IN getting' ||' the EXCEED_CR_DR EXCEPTION :' ||' PROCEDURE :- exceed_dr_cr_count_exception';
1183: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1184: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1185: END IF;
1186: RAISE;
1187: END exceed_dr_cr_sgl_mismatch_exc;
1188:

Line 1219: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');

1215: l_module_name VARCHAR2(200) ;
1216: l_bill_to_address_id Number;
1217: BEGIN
1218: l_module_name := g_module_name || 'main';
1219: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);

Line 1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);

1216: l_bill_to_address_id Number;
1217: BEGIN
1218: l_module_name := g_module_name || 'main';
1219: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);

Line 1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);

1217: BEGIN
1218: l_module_name := g_module_name || 'main';
1219: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);

Line 1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);

1218: l_module_name := g_module_name || 'main';
1219: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);

Line 1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);

1219: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);

Line 1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);

1220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1228: -- Assign parameter values to variables

Line 1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);

1221: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1228: -- Assign parameter values to variables
1229: parm_transaction_type := transaction_type;

Line 1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);

1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1228: -- Assign parameter values to variables
1229: parm_transaction_type := transaction_type;
1230: parm_profile_class_id := profile_class_id;

Line 1227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);

1223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1225: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1226: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1228: -- Assign parameter values to variables
1229: parm_transaction_type := transaction_type;
1230: parm_profile_class_id := profile_class_id;
1231: parm_customer_category := customer_category;

Line 1278: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Processing Transaction:'||trx_rec.trx_number);

1274: INTO trx_rec.contract_no
1275: FROM Ra_Customer_Trx
1276: WHERE customer_trx_id = v_commitment_id;
1277: END IF;
1278: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Processing Transaction:'||trx_rec.trx_number);
1279: SELECT SUM(amount_due_original),
1280: SUM(NVL(amount_adjusted,0)+ NVL(amount_credited,0)+ NVL(amount_due_remaining,0) + NVL(amount_applied,0))
1281: INTO v_original_amount,
1282: v_paid_amount

Line 1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1295: AND set_of_books_id = v_set_of_books_id
1296: AND NVL(org_id,-99) = NVL(v_org_id,-99);
1297: FOR det_select_rec IN det_select(trx_select_rec.customer_trx_id)
1298: LOOP -- detail_select
1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1301: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1302: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.amount_due_remaining);

Line 1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');

1296: AND NVL(org_id,-99) = NVL(v_org_id,-99);
1297: FOR det_select_rec IN det_select(trx_select_rec.customer_trx_id)
1298: LOOP -- detail_select
1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1301: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1302: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.amount_due_remaining);
1304: END IF;

Line 1301: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);

1297: FOR det_select_rec IN det_select(trx_select_rec.customer_trx_id)
1298: LOOP -- detail_select
1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1301: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1302: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.amount_due_remaining);
1304: END IF;
1305: get_treasury_symbol(bl_seg_name, det_select_rec.code_combination_id);

Line 1302: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);

1298: LOOP -- detail_select
1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1301: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1302: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.amount_due_remaining);
1304: END IF;
1305: get_treasury_symbol(bl_seg_name, det_select_rec.code_combination_id);
1306: trx_rec.trn_set_id := 810;

Line 1303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.amount_due_remaining);

1299: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1301: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1302: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1303: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.amount_due_remaining);
1304: END IF;
1305: get_treasury_symbol(bl_seg_name, det_select_rec.code_combination_id);
1306: trx_rec.trn_set_id := 810;
1307: trx_rec.amount := det_select_rec.amount_due_remaining;

Line 1317: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Account Class,Trx Line No,SGL Acct Num = '|| trx_rec.account_class||','||trx_rec.trx_line_no||','|| trx_rec.sgl_acct_num);

1313: trx_rec.unt_prc := det_select_rec.unit_selling_price;
1314: trx_rec.trx_line_no := det_select_rec.line_number;
1315: trx_rec.account_class := det_select_rec.account_class;
1316: trx_rec.sgl_acct_num := gl_account_num(det_select_rec.code_combination_id);
1317: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Account Class,Trx Line No,SGL Acct Num = '|| trx_rec.account_class||','||trx_rec.trx_line_no||','|| trx_rec.sgl_acct_num);
1318: -- Get the exception category
1319: trx_rec.exception_category := get_trx_exception(trx_rec, det_select_rec.customer_trx_line_id, l_bill_to_address_id);
1320: trx_rec.taxpayer_number := v_customer_alc;
1321: -- Set the Debit/Credit Flag based on the

Line 1362: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Process Complete');

1358: AND report_flag = 'N'
1359: )
1360: ;
1361: COMMIT;
1362: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Process Complete');
1363: -- Submit the IPAC Detail Report
1364: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVIPDTLR', '', '', FALSE, profile_class_id , customer_category ,
1365: customer_id, transaction_type, trx_date_low, trx_date_high, parm_currency, v_set_of_books_id,
1366: v_org_id );

Line 1368: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC Detail Report Request ID =' ||l_req_id);

1364: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVIPDTLR', '', '', FALSE, profile_class_id , customer_category ,
1365: customer_id, transaction_type, trx_date_low, trx_date_high, parm_currency, v_set_of_books_id,
1366: v_org_id );
1367: -- if concurrent request submission failed then abort process
1368: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC Detail Report Request ID =' ||l_req_id);
1369: IF l_req_id = 0 THEN
1370: errbuf := 'Unable to Submit IPAC transaction Detail Report';
1371: retcode := '-1';
1372: ROLLBACK;

Line 1388: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC TRANSACTION EXCEPTION Report '

1384: retcode := '2';
1385: END IF;
1386: -- Submit the Exception report
1387: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVIPEXCR', '', '', FALSE, v_set_of_books_id, v_org_id );
1388: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC TRANSACTION EXCEPTION Report '
1389: || 'Request ID ='||l_req_id);
1390: -- if concurrent request submission failed then abort process
1391: IF l_req_id = 0 THEN
1392: errbuf := 'Unable to Submit IPAC Transaction '|| 'Exception Report';

Line 1419: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1415: errmsg := SQLERRM || ' -- Error IN IPAC selection' || ' process : Procedure :- main';
1416: END IF;
1417: retcode := errcode;
1418: errbuf := errmsg;
1419: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1421: END IF;
1422: END; -- main
1423: -------------------------------------------------------------------------------

Line 1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

1416: END IF;
1417: retcode := errcode;
1418: errbuf := errmsg;
1419: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1421: END IF;
1422: END; -- main
1423: -------------------------------------------------------------------------------
1424: ---------------------------- End of Selection Process -------------------------

Line 1487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1483: AND Bulk_Exception IS NULL
1484: AND cash_receipt_id IS NOT NULL
1485: AND accounted_flag='Y';
1486:
1487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1488: 'v_header_count = '||v_header_count);
1489:
1490: -- get the count of total ussgl accounts
1491: SELECT COUNT(1)

Line 1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1510: AND cash_receipt_id IS NOT NULL
1511: AND accounted_flag='Y'
1512: )
1513: ;
1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1515: 'l_total_ussgl_count = '||l_total_ussgl_count);
1516:
1517: --IF total ussgl count is 0 then nothing to report
1518: --write message and return

Line 1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1539: trx_line_no,
1540: snd_app_sym
1541: );
1542:
1543: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1544: 'v_detail_count = '||v_detail_count);
1545:
1546: -- Multiply the detail Rec by 2 for Rec Records per detail record
1547: v_total_count :=v_total_count + v_header_count + v_detail_count

Line 1550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1546: -- Multiply the detail Rec by 2 for Rec Records per detail record
1547: v_total_count :=v_total_count + v_header_count + v_detail_count
1548: + l_total_ussgl_count;
1549:
1550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1551: 'v_total_count = '||v_total_count);
1552:
1553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1554: 'lv_sender_alc = '||lv_sender_alc);

Line 1553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1549:
1550: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1551: 'v_total_count = '||v_total_count);
1552:
1553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1554: 'lv_sender_alc = '||lv_sender_alc);
1555:
1556: --Added for Bug 12839610
1557: SELECT lpad(lv_sender_alc,8,'0')||

Line 1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1559: lpad(FV_IPAC_AR_BATCH_HDR_S.nextval,3,'0')
1560: INTO l_file_id
1561: FROM DUAL;
1562:
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1564: 'l_file_id = '||l_file_id);
1565:
1566: v_statement := 'SELECT ''B''||''IPAC'' || LPAD('
1567: || v_total_count||',8,''0'') ||

Line 1574: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1570: fv_flatfiles.create_flat_file(v_statement);
1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,
1576: errmsg);
1577: END IF;
1578: RAISE;

Line 1575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,

1571:
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1575: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,
1576: errmsg);
1577: END IF;
1578: RAISE;
1579: END ; -- create_batch_header

Line 1655: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: errcode :=SQLCODE;
1654: errmsg :=SQLERRM || 'Error in Creating the Detail Record ' || '- Procedure: create_trx_dtl_rec';
1655: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1656: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1657: END IF;
1658: RAISE;
1659: END create_trx_dtl_rec;

Line 1656: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);

1652: WHEN OTHERS THEN
1653: errcode :=SQLCODE;
1654: errmsg :=SQLERRM || 'Error in Creating the Detail Record ' || '- Procedure: create_trx_dtl_rec';
1655: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1656: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1657: END IF;
1658: RAISE;
1659: END create_trx_dtl_rec;
1660:

Line 1709: fv_utility.debug_mesg(fnd_log.level_unexpected, l_module_name, errmsg);

1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: errcode :=SQLCODE;
1708: errmsg :=SQLERRM|| '-- Error in creating' || ' the USSGL Record :' || 'Procedure - create_ussgl_rec';
1709: fv_utility.debug_mesg(fnd_log.level_unexpected, l_module_name, errmsg);
1710: RAISE;
1711: END create_ussgl_rec;
1712:
1713: -- -----------------------------------------------------------------------------

Line 1774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1770:
1771: BEGIN
1772: l_module_name := g_module_name || 'create_receipt_accounting';
1773:
1774: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1775: 'Inside create_receipt_accounting');
1776:
1777: IF trx_receipt_rec.cash_receipt_id IS NOT NULL
1778: OR p_cash_receipt_id IS NOT NULL THEN

Line 1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1776:
1777: IF trx_receipt_rec.cash_receipt_id IS NOT NULL
1778: OR p_cash_receipt_id IS NOT NULL THEN
1779:
1780: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1781: 'trx_receipt_rec.cash_receipt_id or p_Cash_receipt Is Not Null');
1782:
1783: x_retcode := 0;
1784: -- l_event_stat := '';

Line 1798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1794: WHERE source_id_int_1 = NVL(p_cash_receipt_id , trx_receipt_rec.cash_receipt_id )
1795: AND application_id=222
1796: AND entity_code ='RECEIPTS';
1797:
1798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1799: 'l_entity_id ='||l_entity_id);
1800: /*
1801: -- CHECK IT Won't there be two event_ids for receipt
1802: -- creation and application

Line 1815: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1811: */
1812:
1813: FOR get_evnt_rec IN get_evnt_cur(l_entity_id,1)
1814: LOOP
1815: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1816: 'l_event_id '|| get_evnt_rec.event_id);
1817:
1818: l_event_source_info.application_id := 222;
1819: l_event_source_info.legal_entity_id := l_legal_entity_id;

Line 1870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1866: INTO l_ae_header_id
1867: FROM xla_ae_headers
1868: WHERE event_id = get_evnt_rec.event_id;
1869:
1870: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1871: 'l_ae_header_id ='||l_ae_header_id);
1872:
1873: FOR xla_acnt_rec IN xla_acnt_cur (l_ae_header_id)
1874: LOOP -- Accounting Information Record

Line 1882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1878: then Debit Account is updated with cr_dr_flag='C'
1879: and Credit Account cr_dr_flag='D',
1880: Amount = for both the Accounts.
1881: This is required for the Bulk File reporting..*/
1882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1883: 'xla_acnt_rec.accounted_cr= '||xla_acnt_rec.accounted_cr);
1884: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1885: 'xla_acnt_rec.accounted_dr='||xla_acnt_rec.accounted_dr);
1886:

Line 1884: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1880: Amount = for both the Accounts.
1881: This is required for the Bulk File reporting..*/
1882: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1883: 'xla_acnt_rec.accounted_cr= '||xla_acnt_rec.accounted_cr);
1884: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1885: 'xla_acnt_rec.accounted_dr='||xla_acnt_rec.accounted_dr);
1886:
1887: IF xla_acnt_rec.accounted_cr IS NOT NULL THEN
1888: -- Credit Account

Line 1890: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1886:
1887: IF xla_acnt_rec.accounted_cr IS NOT NULL THEN
1888: -- Credit Account
1889: l_amount := xla_acnt_rec.accounted_cr;
1890: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1891: 'l_amount= '||l_amount);
1892:
1893: IF xla_acnt_rec.accounted_cr > 0 THEN
1894: l_cr_dr_flag := 'C';

Line 1902: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1898: END IF;
1899: ELSIF xla_acnt_rec.accounted_dr IS NOT NULL THEN
1900: -- Debit Account
1901: l_amount := xla_acnt_rec.accounted_dr;
1902: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1903: 'l_amount= '||l_amount);
1904:
1905: IF xla_acnt_rec.accounted_dr > 0 THEN
1906: l_cr_dr_flag := 'D';

Line 1937: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1933:
1934: EXCEPTION
1935: WHEN OTHERS THEN
1936:
1937: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1938: 'No line_number exists for header_id ='||
1939: xla_acnt_rec.ae_header_id || ' and line_num = ' ||
1940: xla_acnt_rec.ae_line_num);
1941:

Line 1947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1943: END;
1944:
1945: IF l_is_line_no = TRUE THEN
1946:
1947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1948: 'l_trx_line_no='||l_trx_line_no);
1949: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1950: 'xla_acnt_rec.code_combination_id='||xla_acnt_rec.code_combination_id);
1951: -- Determine the Natural account from the ccid for

Line 1949: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1945: IF l_is_line_no = TRUE THEN
1946:
1947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1948: 'l_trx_line_no='||l_trx_line_no);
1949: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1950: 'xla_acnt_rec.code_combination_id='||xla_acnt_rec.code_combination_id);
1951: -- Determine the Natural account from the ccid for
1952: -- each of the accounting lines.
1953: l_gl_account_num := gl_account_num(xla_acnt_rec.code_combination_id);

Line 1954: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1950: 'xla_acnt_rec.code_combination_id='||xla_acnt_rec.code_combination_id);
1951: -- Determine the Natural account from the ccid for
1952: -- each of the accounting lines.
1953: l_gl_account_num := gl_account_num(xla_acnt_rec.code_combination_id);
1954: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1955: 'l_gl_account_num ='||l_gl_account_num );
1956: -- Determine the Treasury Symbol
1957:
1958: get_treasury_symbol( bl_seg_name, xla_acnt_rec.code_combination_id );

Line 1960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

1956: -- Determine the Treasury Symbol
1957:
1958: get_treasury_symbol( bl_seg_name, xla_acnt_rec.code_combination_id );
1959:
1960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1961: 'bl_seg_name='||bl_seg_name );
1962: -- Insertion of Receipt Accounting information into
1963: -- the table fv_ipac_trx_all
1964: v_bulk_exception := NULL;

Line 2037: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2033:
2034: END LOOP; -- End FOR get_evnt_rec IN get_evnt_cur(l_entity_id)
2035:
2036: ELSE -- SLA Accounting Failed
2037: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2038: x_errbuf);
2039: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2040: -- and bulk_exception = 'ACCOUNTING_NOT_CREATED'
2041: -- for the particular transaction

Line 2114: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2110: COMMIT;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113:
2114: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2115: 'Create_Receipt_Accounting - Unexpected Error, Calling Update');
2116:
2117: UPDATE fv_ipac_trx_all
2118: SET accounted_flag = '',

Line 2151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2147: l_module_name VARCHAR2(200);
2148: l_payment_trxn_extension_id NUMBER;
2149: BEGIN
2150:
2151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2152: 'create_receipt_and_apply begins');
2153:
2154: -- Create new receipts only for those transactions which already don't have
2155: -- any receipts applied to them

Line 2157: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2153:
2154: -- Create new receipts only for those transactions which already don't have
2155: -- any receipts applied to them
2156:
2157: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2158: 'trx_receipt_rec.cash_receipt_id = ' || trx_receipt_rec.cash_receipt_id);
2159:
2160: IF trx_receipt_rec.cash_receipt_id IS NULL THEN
2161:

Line 2177: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2173: AND arma.org_id = v_org_id;
2174:
2175: EXCEPTION
2176: WHEN NO_DATA_FOUND THEN
2177: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2178: 'There is no Billing ALC defined for the Transaction '||trx_receipt_rec.trx_number);
2179: END;
2180:
2181: --bug 8654573

Line 2191: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2187: where CUSTOMER_TRX_ID = trx_receipt_rec.customer_trx_id;
2188:
2189: exception
2190: WHEN NO_DATA_FOUND THEN
2191: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2192: 'There is no Payment_trxn_extension_id for the Transaction '||trx_receipt_rec.trx_number);
2193: end;
2194: --bug 8654573
2195:

Line 2220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2216:
2217: -- If the create_and_apply receipt is done successfully
2218: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2219:
2220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2221: 'create_and_apply receipt is done successfully');
2222:
2223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2224: 'The receipt is created for the transaction number: '

Line 2223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2219:
2220: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2221: 'create_and_apply receipt is done successfully');
2222:
2223: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2224: 'The receipt is created for the transaction number: '
2225: || trx_receipt_rec.trx_number || ' with Receipt ID: '
2226: || to_char(x_cash_receipt_id));
2227:

Line 2300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2296: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2297: -- and bulk_exception = 'RECEIPT_NOT_CREATED' for the particular
2298: -- transaction
2299:
2300: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2301: 'create_and_apply receipt fails');
2302:
2303: INSERT
2304: INTO fv_ipac_trx_all

Line 2365: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2361: AND customer_trx_id = trx_receipt_rec.customer_trx_id
2362: AND exclude_flag = 'N'
2363: AND report_flag = 'Y'
2364: AND processed_flag = 'N';
2365: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2366: 'Error generated during the creation of receipt for the transaction number: '
2367: || trx_receipt_rec.trx_number);
2368:
2369: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2369: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2365: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2366: 'Error generated during the creation of receipt for the transaction number: '
2367: || trx_receipt_rec.trx_number);
2368:
2369: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2370: 'Return Status: ' || x_return_status);
2371:
2372: IF x_msg_data IS NOT NULL THEN
2373: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2373: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2369: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2370: 'Return Status: ' || x_return_status);
2371:
2372: IF x_msg_data IS NOT NULL THEN
2373: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2374: 'Error Information: ' || x_msg_data );
2375: END IF;
2376: END IF; -- Condition related with the success or failure
2377: -- of create_and_apply receipt process

Line 2398: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2394: errmsg := SQLERRM;
2395: END IF;
2396: retcode := errcode;
2397: errbuf := errmsg;
2398: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2399: 'Errbuf :'||errbuf);
2400: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2401: 'retcode :'||retcode);
2402:

Line 2400: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2396: retcode := errcode;
2397: errbuf := errmsg;
2398: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2399: 'Errbuf :'||errbuf);
2400: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2401: 'retcode :'||retcode);
2402:
2403: END; -- create_receipt_and_apply
2404:

Line 2425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2421: l_module_name VARCHAR2(200);
2422: BEGIN
2423: l_module_name:=g_module_name||'create_receipt_acct_main';
2424:
2425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2426: 'create_receipt_acct_main begins');
2427:
2428: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2429: 'Input parameters are :');

Line 2428: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2424:
2425: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2426: 'create_receipt_acct_main begins');
2427:
2428: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2429: 'Input parameters are :');
2430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2431: 'Parm_CURRENCY_CODE :'||parm_currency);
2432: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2426: 'create_receipt_acct_main begins');
2427:
2428: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2429: 'Input parameters are :');
2430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2431: 'Parm_CURRENCY_CODE :'||parm_currency);
2432: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2433: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2434: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2432: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2428: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2429: 'Input parameters are :');
2430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2431: 'Parm_CURRENCY_CODE :'||parm_currency);
2432: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2433: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2434: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2435: 'P_RECIPT_DATE :'||P_RECEIPT_DATE);
2436: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2434: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2431: 'Parm_CURRENCY_CODE :'||parm_currency);
2432: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2433: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2434: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2435: 'P_RECIPT_DATE :'||P_RECEIPT_DATE);
2436: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2437: 'P_GL_DATE :'||P_GL_DATE);
2438:

Line 2436: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2432: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2433: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2434: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2435: 'P_RECIPT_DATE :'||P_RECEIPT_DATE);
2436: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2437: 'P_GL_DATE :'||P_GL_DATE);
2438:
2439: get_bal_seg_name;
2440:

Line 2445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2441:
2442: for trx_receipt_rec in trx_receipt_cur
2443: loop
2444:
2445: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2446: 'Calling create_receipt_and_apply with customer_trx_id='||
2447: trx_receipt_rec.customer_trx_id);
2448:
2449: create_receipt_and_apply(errbuf,

Line 2461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2457:
2458: exceed_dr_cr_sgl_mismatch_exc;
2459:
2460: -- submit Bulk File Report
2461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2462: 'v_sender_alc =' ||v_sender_alc);
2463:
2464: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV',
2465: 'FVIBKRPT',

Line 2473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2469: v_org_id,
2470: v_sender_alc);
2471:
2472: -- if concurrent request submission failed then abort process
2473: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2474: 'IPAC Bulk File Report Request ID =' ||l_req_id);
2475:
2476: IF l_req_id = 0 THEN
2477: errbuf := 'Unable to Submit Bulk File Report ';

Line 2509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2505: v_set_of_books_id,
2506: v_org_id );
2507:
2508: -- if concurrent request submission failed then abort process
2509: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2510: 'IPAC Bulk File Exception Report Request ID =' ||l_req_id);
2511:
2512: IF l_req_id = 0 THEN
2513: errbuf := 'Unable to Submit Apply Cash Receipts Process';

Line 2538: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2534: END IF;
2535: EXCEPTION
2536: WHEN OTHERS THEN
2537: ROLLBACK;
2538: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2539: ' -- Error IN IPAC Bulk Exception process: Procedure:- create_bulk_file');
2540:
2541: IF errcode IS NULL THEN
2542: errcode := SQLCODE;

Line 2548: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2544: END IF;
2545: retcode := errcode;
2546: errbuf := errmsg;
2547:
2548: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2549: 'Errbuf :'||errbuf);
2550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2551: 'retcode :'||retcode);
2552: END;

Line 2550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2546: errbuf := errmsg;
2547:
2548: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2549: 'Errbuf :'||errbuf);
2550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2551: 'retcode :'||retcode);
2552: END;
2553: EXCEPTION
2554: WHEN OTHERS THEN

Line 2561: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2557: errmsg := SQLERRM;
2558: END IF;
2559: retcode := errcode;
2560: errbuf := errmsg;
2561: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2562: 'Errbuf :'||errbuf);
2563: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2564: 'retcode :'||retcode);
2565:

Line 2563: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2559: retcode := errcode;
2560: errbuf := errmsg;
2561: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2562: 'Errbuf :'||errbuf);
2563: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2564: 'retcode :'||retcode);
2565:
2566: END;
2567:

Line 2595: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2591: v_set_of_books_id,
2592: v_coa_id ,
2593: parm_currency ,
2594: p_status );
2595: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2596: 'create_bulk_file begins'||l_rec_count);
2597:
2598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2599: 'Org_id = '||p_org_id);

Line 2598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2594: p_status );
2595: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2596: 'create_bulk_file begins'||l_rec_count);
2597:
2598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2599: 'Org_id = '||p_org_id);
2600:
2601: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2602: 'v_set_of_books_id = '||v_set_of_books_id);

Line 2601: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2597:
2598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2599: 'Org_id = '||p_org_id);
2600:
2601: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2602: 'v_set_of_books_id = '||v_set_of_books_id);
2603:
2604:
2605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 2605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2601: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2602: 'v_set_of_books_id = '||v_set_of_books_id);
2603:
2604:
2605: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2606: 'v_coa_id = '||v_coa_id);
2607:
2608: SELECT count(1)
2609: INTO l_rec_count

Line 2619: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2615: AND exclude_flag ='N'
2616: AND processed_flag = 'N'
2617: AND bulk_exception is null;
2618:
2619: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2620: 'l_rec_count = '||l_rec_count);
2621:
2622: IF l_rec_count>0 then
2623: get_bal_seg_name;

Line 2634: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2630:
2631: FOR hdr_det_rec IN hdr_det(v_set_of_books_id, v_org_id)
2632: LOOP
2633:
2634: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2635: 'Creating trx header for customer_trx_id = '||hdr_det_rec.customer_trx_id);
2636:
2637: -- Create the Transaction Header Record
2638: create_trx_header(v_set_of_books_id,

Line 2667: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

2663: AND report_flag = 'Y';
2664: else
2665: retcode:=1;
2666: errbuf := 'No Records Found for Bulk File Report.';
2667: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2668: 'No Records Found for Bulk File Report.');
2669:
2670: return;
2671: end if;

Line 2681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2677: errmsg := SQLERRM;
2678: END IF;
2679: retcode := errcode;
2680: errbuf := errmsg;
2681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2682: 'Errbuf :'||errbuf);
2683: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2684: 'retcode :'||retcode);
2685: END ; -- create_bulk_file;

Line 2683: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2679: retcode := errcode;
2680: errbuf := errmsg;
2681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2682: 'Errbuf :'||errbuf);
2683: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2684: 'retcode :'||retcode);
2685: END ; -- create_bulk_file;
2686:
2687: -- -----------------------------------------------------------------------------

Line 2708: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, errbuf);

2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: errbuf := SQLERRM;
2707: retcode := SQLCODE;
2708: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, errbuf);
2709: RAISE ;
2710: RETURN;
2711: END;
2712: BEGIN

Line 2722: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,

2718: EXCEPTION
2719: WHEN OTHERS THEN
2720: retcode := SQLCODE ;
2721: errbuf := SQLERRM ;
2722: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
2723: l_module_name, errbuf) ;
2724: RAISE ;
2725: END ;
2726: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);

Line 2733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2729: EXCEPTION
2730: WHEN OTHERS THEN
2731: retcode := SQLCODE ;
2732: errbuf := SQLERRM ;
2733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2734: 'Create Sql ');
2735: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2736: errbuf) ;
2737: RAISE ;

Line 2735: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

2731: retcode := SQLCODE ;
2732: errbuf := SQLERRM ;
2733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2734: 'Create Sql ');
2735: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2736: errbuf) ;
2737: RAISE ;
2738: END;
2739: LOOP

Line 2749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2745: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);
2746: END LOOP;
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
2751: l_module_name, errmsg);
2752: END IF;
2753: RAISE;

Line 2750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

2746: END LOOP;
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
2751: l_module_name, errmsg);
2752: END IF;
2753: RAISE;
2754: END;

Line 2762: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2758:
2759: BEGIN
2760: v_org_id := mo_global.get_current_org_id;
2761:
2762: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2763: 'fv.plsql.fv_ipac','Org Id : '||v_org_id);
2764:
2765: fv_utility.get_ledger_info(v_org_id,
2766: v_set_of_books_id,