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 339: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

335: EXCEPTION
336: WHEN OTHERS THEN
337: errbuf := SQLERRM;
338: errbuf := 'When others ' || SQLERRM;
339: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
341: l_module_name, errbuf);
342: END IF;
343: RAISE;

Line 340: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

336: WHEN OTHERS THEN
337: errbuf := SQLERRM;
338: errbuf := 'When others ' || SQLERRM;
339: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
341: l_module_name, errbuf);
342: END IF;
343: RAISE;
344: END ; --init_vars

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

363: EXCEPTION
364: WHEN OTHERS THEN
365: errcode := SQLCODE;
366: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- del_exception_recs' ;
367: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
369: END IF;
370: RAISE;
371: END; -- del_exception_recs

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

364: WHEN OTHERS THEN
365: errcode := SQLCODE;
366: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- del_exception_recs' ;
367: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
368: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
369: END IF;
370: RAISE;
371: END; -- del_exception_recs
372:

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

385: AND ipac_billing_id BETWEEN g_start_billing_id AND g_end_billing_id ;
386: EXCEPTION
387:
388: WHEN NO_DATA_FOUND THEN
389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
390: 'No Records For Deletion ' );
391:
392: WHEN OTHERS THEN
393: errcode := SQLCODE;

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

391:
392: WHEN OTHERS THEN
393: errcode := SQLCODE;
394: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- delete_records' ;
395: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
397: END IF;
398: RAISE;
399: END delete_records;

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

392: WHEN OTHERS THEN
393: errcode := SQLCODE;
394: errmsg := SQLERRM || ' -- Error IN deleleting the records' || ' form IPAC TABLE PROCEDURE ' || ':- delete_records' ;
395: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
397: END IF;
398: RAISE;
399: END delete_records;
400:

Line 436: 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);

432: errcode := SQLCODE;
433: errmsg := SQLERRM ||' -- Error in geting the Value set ID ' || 'attached to the GL Account segment :' || 'Procedure :- get_bal_seg_name' ;
434: RAISE;
435: END;
436: 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);
437: EXCEPTION
438: WHEN OTHERS THEN
439: IF errcode IS NULL THEN
440: errcode := SQLCODE;

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

439: IF errcode IS NULL THEN
440: errcode := SQLCODE;
441: errmsg := SQLERRM ||' -- Error IN geting the Segment Name :' || ' Procedure :- get_bal_seg_name' ;
442: END IF;
443: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
445: END IF;
446: RAISE;
447: END; -- get_bal_seg_name

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

440: errcode := SQLCODE;
441: errmsg := SQLERRM ||' -- Error IN geting the Segment Name :' || ' Procedure :- get_bal_seg_name' ;
442: END IF;
443: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
445: END IF;
446: RAISE;
447: END; -- get_bal_seg_name
448:

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

477: v_treasury_symbol := '1';
478: WHEN OTHERS THEN
479: errmsg := SQLERRM;
480: errcode := SQLCODE;
481: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
482: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
483: END IF;
484: RAISE;
485: END; -- get_treasury_symbol

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

478: WHEN OTHERS THEN
479: errmsg := SQLERRM;
480: errcode := SQLCODE;
481: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
482: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
483: END IF;
484: RAISE;
485: END; -- get_treasury_symbol
486:

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

496: -- Get the exception only if the account class is not REC
497: IF transaction_rec.account_class <> 'REC' THEN -- REC check
498: IF (v_receipt_method_id IS NULL AND v_default_alc = 'N') THEN --RM check
499: v_trx_excpt_cat := 'MISSING_PAYMENT_METHOD';
500: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_PAYMENT_METHOD');
502: END IF;
503: --
504: /*

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

497: IF transaction_rec.account_class <> 'REC' THEN -- REC check
498: IF (v_receipt_method_id IS NULL AND v_default_alc = 'N') THEN --RM check
499: v_trx_excpt_cat := 'MISSING_PAYMENT_METHOD';
500: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_PAYMENT_METHOD');
502: END IF;
503: --
504: /*
505: ELSIF v_receipt_method_id IS NOT NULL THEN --RM check

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

513: AND aba.currency_code = nvl(parm_currency,v_invoice_currency)
514: AND arma.primary_flag = 'Y'
515: AND arma.receipt_method_id = v_receipt_method_id;
516:
517: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
518: THEN
519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
520: l_module_name,'receipt_method_id IS NOT null,
521: v_sender_alc ='|| v_sender_alc);

Line 519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

515: AND arma.receipt_method_id = v_receipt_method_id;
516:
517: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
518: THEN
519: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
520: l_module_name,'receipt_method_id IS NOT null,
521: v_sender_alc ='|| v_sender_alc);
522: END IF;
523:

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

522: END IF;
523:
524: IF v_sender_alc IS NULL THEN
525: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
526: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
527: THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
529: l_module_name,'MISSING_BANK_ACCT_ALC');
530: END IF;

Line 528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

524: IF v_sender_alc IS NULL THEN
525: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
526: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
527: THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
529: l_module_name,'MISSING_BANK_ACCT_ALC');
530: END IF;
531: END IF;
532: EXCEPTION

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

533: WHEN NO_DATA_FOUND THEN
534: IF v_default_alc <> 'N' THEN
535: v_sender_alc := v_default_alc;
536:
537: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
538: THEN
539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
540: l_module_name,'no data and DEFAULT alc v_sender_alc ='
541: || v_sender_alc);

Line 539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

535: v_sender_alc := v_default_alc;
536:
537: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
538: THEN
539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
540: l_module_name,'no data and DEFAULT alc v_sender_alc ='
541: || v_sender_alc);
542: END IF;
543: ELSE

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

541: || v_sender_alc);
542: END IF;
543: ELSE
544: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
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,'MISSING_BANK_ACCT_ALC');
549: END IF;

Line 547: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

543: ELSE
544: v_trx_excpt_cat := 'MISSING_BANK_ACCT_ALC';
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,'MISSING_BANK_ACCT_ALC');
549: END IF;
550: END IF;
551: WHEN OTHERS THEN

Line 554: IF ( FND_LOG.LEVEL_UNEXPECTED >=

550: END IF;
551: WHEN OTHERS THEN
552: errmsg := SQLERRM||'-- Error in Get_Trx_Exception when
553: getting the ALC,when receipt method is not null';
554: IF ( FND_LOG.LEVEL_UNEXPECTED >=
555: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
557: l_module_name,errmsg);
558: END IF;

Line 555: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

551: WHEN OTHERS THEN
552: errmsg := SQLERRM||'-- Error in Get_Trx_Exception when
553: getting the ALC,when receipt method is not null';
554: IF ( FND_LOG.LEVEL_UNEXPECTED >=
555: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
557: l_module_name,errmsg);
558: END IF;
559: RAISE;

Line 556: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

552: errmsg := SQLERRM||'-- Error in Get_Trx_Exception when
553: getting the ALC,when receipt method is not null';
554: IF ( FND_LOG.LEVEL_UNEXPECTED >=
555: FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
556: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
557: l_module_name,errmsg);
558: END IF;
559: RAISE;
560: END;

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

560: END;
561: ELSIF (v_receipt_method_id IS NULL AND v_default_alc <> 'N')
562: THEN --RM check
563: v_sender_alc := v_default_alc;
564: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
565: THEN
566: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
567: 'Receipt Method is null and sender ALC ='|| v_sender_alc);
568: END IF;

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

562: THEN --RM check
563: v_sender_alc := v_default_alc;
564: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
565: THEN
566: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
567: 'Receipt Method is null and sender ALC ='|| v_sender_alc);
568: END IF;
569: */
570:

Line 578: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Customer ID = ' || transaction_rec.customer_id || ' p_bill_to_address_id = ' || p_bill_to_address_id);

574: -- no exceptions found above so continue checking for exception
575: --find customer alc on the bill to customer account.
576: -- using the BILL_TO site to determine bank account assigned.
577: BEGIN
578: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Customer ID = ' || transaction_rec.customer_id || ' p_bill_to_address_id = ' || p_bill_to_address_id);
579: SELECT eb.agency_location_code
580: INTO v_customer_alc
581: FROM hz_cust_acct_sites_all hzcas,
582: hz_cust_site_uses_all hzcsu,

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

593: AND transaction_rec.trx_date BETWEEN iby_ins.start_date AND NVL(iby_ins.end_date, TO_DATE('12/31/9999', 'MM/DD/YYYY'))
594: AND iby_ins.instrument_id = eb.ext_bank_account_id;
595: EXCEPTION
596: WHEN NO_DATA_FOUND THEN
597: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC-No Primary Bank AcctDefined');
599: END IF;
600: v_trx_excpt_cat := 'MISSING_CUST_ALC';
601: END;

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

594: AND iby_ins.instrument_id = eb.ext_bank_account_id;
595: EXCEPTION
596: WHEN NO_DATA_FOUND THEN
597: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC-No Primary Bank AcctDefined');
599: END IF;
600: v_trx_excpt_cat := 'MISSING_CUST_ALC';
601: END;
602: IF v_customer_alc IS NULL THEN

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

599: END IF;
600: v_trx_excpt_cat := 'MISSING_CUST_ALC';
601: END;
602: IF v_customer_alc IS NULL THEN
603: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC - No ALC defined');
605: END IF;
606: v_trx_excpt_cat := 'MISSING_CUST_ALC';
607: END IF;

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

600: v_trx_excpt_cat := 'MISSING_CUST_ALC';
601: END;
602: IF v_customer_alc IS NULL THEN
603: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'MISSING_CUST_ALC - No ALC defined');
605: END IF;
606: v_trx_excpt_cat := 'MISSING_CUST_ALC';
607: END IF;
608: END IF; -- end customer alc check

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

640: RETURN v_trx_excpt_cat;
641: EXCEPTION
642: WHEN OTHERS THEN
643: errmsg :=SQLERRM;
644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
646: END IF;
647: RAISE;
648: END ; -- get_trx_exception

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

641: EXCEPTION
642: WHEN OTHERS THEN
643: errmsg :=SQLERRM;
644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
646: END IF;
647: RAISE;
648: END ; -- get_trx_exception
649:

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

767: l_module_name VARCHAR2(200);
768: BEGIN
769: l_module_name:=g_module_name||'gl_account_num';
770:
771: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
772: 'gl_account_num begins');
773:
774:
775: SELECT DECODE (gbl_gl_segment_name,

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

807: FROM gl_code_combinations glc
808: WHERE code_combination_id = p_ccid
809: AND glc.chart_of_accounts_id = flex_num;
810:
811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
812: 'l_gl_account_num = '||l_gl_account_num);
813:
814: RETURN l_gl_account_num;
815: EXCEPTION

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

818: errmsg := SQLERRM
819: || ' -- Error in getting the GL Account number :'
820: || ' Funcation :- gl_account_num';
821:
822: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
824: l_module_name, errmsg);
825: END IF;
826: RAISE;

Line 823: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

819: || ' -- Error in getting the GL Account number :'
820: || ' Funcation :- gl_account_num';
821:
822: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
824: l_module_name, errmsg);
825: END IF;
826: RAISE;
827: END gl_account_num;

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

836: l_module_name VARCHAR2(200);
837: BEGIN
838: l_module_name:=g_module_name||'gl_account_type';
839:
840: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
841: 'gl_account_type begins');
842:
843: -- Account Type of the Code combination ID
844: SELECT SUBSTR(compiled_value_attributes, 5, 1)

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

846: FROM fnd_flex_values
847: WHERE flex_value = p_gl_account
848: AND flex_value_set_id = gbl_gl_acc_value_set_id;
849:
850: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
851: 'l_account_type='||l_account_type);
852:
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

849:
850: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
851: 'l_account_type='||l_account_type);
852:
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
855: 'Account: '||p_gl_account || ' Account type: '|| l_account_type );
856: END IF;
857: RETURN l_account_type;

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

850: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
851: 'l_account_type='||l_account_type);
852:
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
855: 'Account: '||p_gl_account || ' Account type: '|| l_account_type );
856: END IF;
857: RETURN l_account_type;
858: EXCEPTION

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

860: errcode :=SQLCODE;
861: errmsg := SQLERRM
862: || ' -- Error in getting the GL Account type :'
863: || ' Funcation :- gl_account_type';
864: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
866: errmsg);
867: END IF;
868: RAISE;

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

861: errmsg := SQLERRM
862: || ' -- Error in getting the GL Account type :'
863: || ' Funcation :- gl_account_type';
864: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
865: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
866: errmsg);
867: END IF;
868: RAISE;
869: END gl_account_type;

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

926: END ;
927: WHEN OTHERS THEN
928: errcode := SQLCODE;
929: errmsg := SQLERRM || ' -- Error in geting the USSGL Account :' || ' Function :- get_ussgl_account';
930: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
932: END IF;
933: RAISE;
934: END get_ussgl_account;

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

927: WHEN OTHERS THEN
928: errcode := SQLCODE;
929: errmsg := SQLERRM || ' -- Error in geting the USSGL Account :' || ' Function :- get_ussgl_account';
930: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
931: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
932: END IF;
933: RAISE;
934: END get_ussgl_account;
935:

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

941: IS
942: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
943: l_valid_flag VARCHAR2(1);
944: BEGIN
945: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC FY2003-04 GET SGL EXCEPTION');
947: END IF;
948: -- Checking for the Account type
949: -- If the account type is budgetary Cr/Dr and account class

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

942: l_sgl_acct_num gl_code_combinations.segment1%TYPE;
943: l_valid_flag VARCHAR2(1);
944: BEGIN
945: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
946: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC FY2003-04 GET SGL EXCEPTION');
947: END IF;
948: -- Checking for the Account type
949: -- If the account type is budgetary Cr/Dr and account class
950: -- is equal to the REC then return the exception else return the

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

955: -- Get the USSGL Number and the Valid Flag
956: p_sgl_acct_num := get_ussgl_account(p_acct_num,l_valid_flag);
957: IF l_valid_flag = 'N' THEN
958: -- Invalid USSGL Account
959: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Exception SGL Account - Invalid SGL Account: ' || l_sgl_acct_num);
961: END IF;
962: RETURN 'INVALID_SGL_ACCOUNT';
963: END IF;

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

956: p_sgl_acct_num := get_ussgl_account(p_acct_num,l_valid_flag);
957: IF l_valid_flag = 'N' THEN
958: -- Invalid USSGL Account
959: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Exception SGL Account - Invalid SGL Account: ' || l_sgl_acct_num);
961: END IF;
962: RETURN 'INVALID_SGL_ACCOUNT';
963: END IF;
964: -- No SGL Exception

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

966: EXCEPTION
967: WHEN OTHERS THEN
968: errcode :=SQLCODE;
969: errmsg :=SQLERRM|| ' -- Error in getting the USSGL Exception Function ' || ' - get_sgl_exception';
970: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
972: END IF;
973: RAISE;
974: END get_sgl_exception;

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

967: WHEN OTHERS THEN
968: errcode :=SQLCODE;
969: errmsg :=SQLERRM|| ' -- Error in getting the USSGL Exception Function ' || ' - get_sgl_exception';
970: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
971: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
972: END IF;
973: RAISE;
974: END get_sgl_exception;
975: /*

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

1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: errcode :=SQLCODE;
1166: errmsg := SQLERRM || ' -- Error IN getting' ||' the EXCEED_CR_DR EXCEPTION :' ||' PROCEDURE :- exceed_dr_cr_count_exception';
1167: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1169: END IF;
1170: RAISE;
1171: END exceed_dr_cr_sgl_mismatch_exc;

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

1164: WHEN OTHERS THEN
1165: errcode :=SQLCODE;
1166: errmsg := SQLERRM || ' -- Error IN getting' ||' the EXCEED_CR_DR EXCEPTION :' ||' PROCEDURE :- exceed_dr_cr_count_exception';
1167: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1169: END IF;
1170: RAISE;
1171: END exceed_dr_cr_sgl_mismatch_exc;
1172:

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

1199: l_module_name VARCHAR2(200) ;
1200: l_bill_to_address_id Number;
1201: BEGIN
1202: l_module_name := g_module_name || 'main';
1203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);

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

1200: l_bill_to_address_id Number;
1201: BEGIN
1202: l_module_name := g_module_name || 'main';
1203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);

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

1201: BEGIN
1202: l_module_name := g_module_name || 'main';
1203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);

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

1202: l_module_name := g_module_name || 'main';
1203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);

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

1203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Input parameters are :');
1204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);

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

1204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROFILE_CLASS_ID :'||profile_class_id);
1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1212: -- Assign parameter values to variables

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

1205: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_CATEGORY :'||customer_category);
1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1212: -- Assign parameter values to variables
1213: parm_transaction_type := transaction_type;

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

1206: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CUSTOMER_ID :'||Customer_id);
1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1212: -- Assign parameter values to variables
1213: parm_transaction_type := transaction_type;
1214: parm_profile_class_id := profile_class_id;

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

1207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRANSACTION_TYPE :'||transaction_type);
1208: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_LOW :'||trx_date_low);
1209: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'TRX_DATE_HIGH :'||trx_date_high);
1210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONTACT_PH_NO :'||contact_ph_no);
1211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CURRENCY :'||parm_currency);
1212: -- Assign parameter values to variables
1213: parm_transaction_type := transaction_type;
1214: parm_profile_class_id := profile_class_id;
1215: parm_customer_category := customer_category;

Line 1229: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Default ALC is '||v_default_alc);

1225: v_last_update_date := SYSDATE;
1226: v_last_update_login := fnd_global.login_id;
1227: del_exception_recs;
1228: get_bal_seg_name;
1229: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Default ALC is '||v_default_alc);
1230: --get the start of billing Id
1231: SELECT fv_ipac_billing_id_s.NEXTVAL+1 INTO g_start_billing_id FROM dual ;
1232: FOR trx_select_rec IN trx_select
1233: LOOP -- trx_select

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

1258: INTO trx_rec.contract_no
1259: FROM Ra_Customer_Trx
1260: WHERE customer_trx_id = v_commitment_id;
1261: END IF;
1262: Fv_Utility.Log_Mesg(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Processing Transaction:'||trx_rec.trx_number);
1263: SELECT SUM(amount_due_original),
1264: SUM(NVL(amount_adjusted,0)+ NVL(amount_credited,0)+ NVL(amount_due_remaining,0) + NVL(amount_applied,0))
1265: INTO v_original_amount,
1266: v_paid_amount

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

1279: AND set_of_books_id = v_set_of_books_id
1280: AND NVL(org_id,-99) = NVL(v_org_id,-99);
1281: FOR det_select_rec IN det_select(trx_select_rec.customer_trx_id)
1282: LOOP -- detail_select
1283: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1284: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1285: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1286: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.acctd_amount);

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

1280: AND NVL(org_id,-99) = NVL(v_org_id,-99);
1281: FOR det_select_rec IN det_select(trx_select_rec.customer_trx_id)
1282: LOOP -- detail_select
1283: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1284: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1285: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1286: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.acctd_amount);
1288: END IF;

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

1281: FOR det_select_rec IN det_select(trx_select_rec.customer_trx_id)
1282: LOOP -- detail_select
1283: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1284: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1285: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1286: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.acctd_amount);
1288: END IF;
1289: get_treasury_symbol(bl_seg_name, det_select_rec.code_combination_id);

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

1282: LOOP -- detail_select
1283: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1284: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1285: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1286: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.acctd_amount);
1288: END IF;
1289: get_treasury_symbol(bl_seg_name, det_select_rec.code_combination_id);
1290: trx_rec.trn_set_id := 810;

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

1283: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1284: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '---- DETAILS -------');
1285: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Number: '||trx_select_rec.trx_number);
1286: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Trx Date: '||trx_select_rec.trx_date);
1287: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Amount: '||det_select_rec.acctd_amount);
1288: END IF;
1289: get_treasury_symbol(bl_seg_name, det_select_rec.code_combination_id);
1290: trx_rec.trn_set_id := 810;
1291: trx_rec.amount := det_select_rec.acctd_amount;

Line 1301: 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);

1297: trx_rec.unt_prc := det_select_rec.unit_selling_price;
1298: trx_rec.trx_line_no := det_select_rec.line_number;
1299: trx_rec.account_class := det_select_rec.account_class;
1300: trx_rec.sgl_acct_num := gl_account_num(det_select_rec.code_combination_id);
1301: 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);
1302: -- Get the exception category
1303: trx_rec.exception_category := get_trx_exception(trx_rec, det_select_rec.customer_trx_line_id, l_bill_to_address_id);
1304: trx_rec.taxpayer_number := v_customer_alc;
1305: -- Set the Debit/Credit Flag based on the

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

1342: AND report_flag = 'N'
1343: )
1344: ;
1345: COMMIT;
1346: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Process Complete');
1347: -- Submit the IPAC Detail Report
1348: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVIPDTLR', '', '', FALSE, profile_class_id , customer_category ,
1349: customer_id, transaction_type, trx_date_low, trx_date_high, parm_currency, v_set_of_books_id,
1350: v_org_id );

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

1348: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVIPDTLR', '', '', FALSE, profile_class_id , customer_category ,
1349: customer_id, transaction_type, trx_date_low, trx_date_high, parm_currency, v_set_of_books_id,
1350: v_org_id );
1351: -- if concurrent request submission failed then abort process
1352: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC Detail Report Request ID =' ||l_req_id);
1353: IF l_req_id = 0 THEN
1354: errbuf := 'Unable to Submit IPAC transaction Detail Report';
1355: retcode := '-1';
1356: ROLLBACK;

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

1368: retcode := '2';
1369: END IF;
1370: -- Submit the Exception report
1371: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV', 'FVIPEXCR', '', '', FALSE, v_set_of_books_id, v_org_id );
1372: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'IPAC TRANSACTION EXCEPTION Report '
1373: || 'Request ID ='||l_req_id);
1374: -- if concurrent request submission failed then abort process
1375: IF l_req_id = 0 THEN
1376: errbuf := 'Unable to Submit IPAC Transaction '|| 'Exception Report';

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

1399: errmsg := SQLERRM || ' -- Error IN IPAC selection' || ' process : Procedure :- main';
1400: END IF;
1401: retcode := errcode;
1402: errbuf := errmsg;
1403: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1404: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1405: END IF;
1406: END; -- main
1407: -------------------------------------------------------------------------------

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

1400: END IF;
1401: retcode := errcode;
1402: errbuf := errmsg;
1403: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1404: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1405: END IF;
1406: END; -- main
1407: -------------------------------------------------------------------------------
1408: ---------------------------- End of Selection Process -------------------------

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

1465: AND Bulk_Exception IS NULL
1466: AND cash_receipt_id IS NOT NULL
1467: AND accounted_flag='Y';
1468:
1469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1470: 'v_header_count = '||v_header_count);
1471:
1472: -- get the count of total ussgl accounts
1473: SELECT COUNT(1)

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

1492: AND cash_receipt_id IS NOT NULL
1493: AND accounted_flag='Y'
1494: )
1495: ;
1496: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1497: 'l_total_ussgl_count = '||l_total_ussgl_count);
1498:
1499: --Geting the count of total detail record
1500: SELECT COUNT(1)

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

1513: trx_line_no,
1514: snd_app_sym
1515: );
1516:
1517: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1518: 'v_detail_count = '||v_detail_count);
1519:
1520: -- Multiply the detail Rec by 2 for Rec Records per detail record
1521: v_total_count :=v_total_count + v_header_count + v_detail_count

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

1520: -- Multiply the detail Rec by 2 for Rec Records per detail record
1521: v_total_count :=v_total_count + v_header_count + v_detail_count
1522: + l_total_ussgl_count;
1523:
1524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1525: 'v_total_count = '||v_total_count);
1526:
1527: v_statement := 'SELECT ''B''||''IPAC'' || LPAD('
1528: || v_total_count||',8,''0'') ||

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

1529: RPAD('' '',19,'' '') FROM dual';
1530: fv_flatfiles.create_flat_file(v_statement);
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1534: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,
1535: errmsg);
1536: END IF;
1537: RAISE;

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

1530: fv_flatfiles.create_flat_file(v_statement);
1531: EXCEPTION
1532: WHEN OTHERS THEN
1533: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1534: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,
1535: errmsg);
1536: END IF;
1537: RAISE;
1538: END ; -- create_batch_header

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

1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: errcode :=SQLCODE;
1613: errmsg :=SQLERRM || 'Error in Creating the Detail Record ' || '- Procedure: create_trx_dtl_rec';
1614: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1615: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1616: END IF;
1617: RAISE;
1618: END create_trx_dtl_rec;

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

1611: WHEN OTHERS THEN
1612: errcode :=SQLCODE;
1613: errmsg :=SQLERRM || 'Error in Creating the Detail Record ' || '- Procedure: create_trx_dtl_rec';
1614: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1615: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name, errmsg);
1616: END IF;
1617: RAISE;
1618: END create_trx_dtl_rec;
1619:

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

1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: errcode :=SQLCODE;
1667: errmsg :=SQLERRM|| '-- Error in creating' || ' the USSGL Record :' || 'Procedure - create_ussgl_rec';
1668: fv_utility.debug_mesg(fnd_log.level_unexpected, l_module_name, errmsg);
1669: RAISE;
1670: END create_ussgl_rec;
1671:
1672: -- -----------------------------------------------------------------------------

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

1729:
1730: BEGIN
1731: l_module_name := g_module_name || 'create_receipt_accounting';
1732:
1733: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1734: 'Inside create_receipt_accounting');
1735:
1736: IF trx_receipt_rec.cash_receipt_id IS NOT NULL
1737: OR p_cash_receipt_id IS NOT NULL THEN

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

1735:
1736: IF trx_receipt_rec.cash_receipt_id IS NOT NULL
1737: OR p_cash_receipt_id IS NOT NULL THEN
1738:
1739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1740: 'trx_receipt_rec.cash_receipt_id or p_Cash_receipt Is Not Null');
1741:
1742: x_retcode := 0;
1743: -- l_event_stat := '';

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

1752: FROM xla_transaction_entities
1753: WHERE source_id_int_1 = NVL(p_cash_receipt_id , trx_receipt_rec.cash_receipt_id )
1754: AND application_id=222;
1755:
1756: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1757: 'l_entity_id ='||l_entity_id);
1758: /*
1759: -- CHECK IT Won't there be two event_ids for receipt
1760: -- creation and application

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

1769: */
1770:
1771: FOR get_evnt_rec IN get_evnt_cur(l_entity_id,1)
1772: LOOP
1773: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1774: 'l_event_id '|| get_evnt_rec.event_id);
1775:
1776: l_event_source_info.application_id := 222;
1777: l_event_source_info.legal_entity_id := l_legal_entity_id;

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

1824: INTO l_ae_header_id
1825: FROM xla_ae_headers
1826: WHERE event_id = get_evnt_rec.event_id;
1827:
1828: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1829: 'l_ae_header_id ='||l_ae_header_id);
1830:
1831: FOR xla_acnt_rec IN xla_acnt_cur (l_ae_header_id)
1832: LOOP -- Accounting Information Record

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

1836: then Debit Account is updated with cr_dr_flag='C'
1837: and Credit Account cr_dr_flag='D',
1838: Amount = for both the Accounts.
1839: This is required for the Bulk File reporting..*/
1840: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1841: 'xla_acnt_rec.accounted_cr= '||xla_acnt_rec.accounted_cr);
1842: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1843: 'xla_acnt_rec.accounted_dr='||xla_acnt_rec.accounted_dr);
1844:

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

1838: Amount = for both the Accounts.
1839: This is required for the Bulk File reporting..*/
1840: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1841: 'xla_acnt_rec.accounted_cr= '||xla_acnt_rec.accounted_cr);
1842: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1843: 'xla_acnt_rec.accounted_dr='||xla_acnt_rec.accounted_dr);
1844:
1845: IF xla_acnt_rec.accounted_cr IS NOT NULL THEN
1846: -- Credit Account

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

1844:
1845: IF xla_acnt_rec.accounted_cr IS NOT NULL THEN
1846: -- Credit Account
1847: l_amount := xla_acnt_rec.accounted_cr;
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1849: 'l_amount= '||l_amount);
1850:
1851: IF xla_acnt_rec.accounted_cr > 0 THEN
1852: l_cr_dr_flag := 'C';

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

1856: END IF;
1857: ELSIF xla_acnt_rec.accounted_dr IS NOT NULL THEN
1858: -- Debit Account
1859: l_amount := xla_acnt_rec.accounted_dr;
1860: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1861: 'l_amount= '||l_amount);
1862:
1863: IF xla_acnt_rec.accounted_dr > 0 THEN
1864: l_cr_dr_flag := 'D';

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

1891:
1892: EXCEPTION
1893: WHEN OTHERS THEN
1894:
1895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1896: 'No line_number exists for header_id ='||
1897: xla_acnt_rec.ae_header_id || ' and line_num = ' ||
1898: xla_acnt_rec.ae_line_num);
1899:

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

1901: END;
1902:
1903: IF l_is_line_no = TRUE THEN
1904:
1905: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1906: 'l_trx_line_no='||l_trx_line_no);
1907: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1908: 'xla_acnt_rec.code_combination_id='||xla_acnt_rec.code_combination_id);
1909: -- Determine the Natural account from the ccid for

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

1903: IF l_is_line_no = TRUE THEN
1904:
1905: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1906: 'l_trx_line_no='||l_trx_line_no);
1907: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1908: 'xla_acnt_rec.code_combination_id='||xla_acnt_rec.code_combination_id);
1909: -- Determine the Natural account from the ccid for
1910: -- each of the accounting lines.
1911: l_gl_account_num := gl_account_num(xla_acnt_rec.code_combination_id);

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

1908: 'xla_acnt_rec.code_combination_id='||xla_acnt_rec.code_combination_id);
1909: -- Determine the Natural account from the ccid for
1910: -- each of the accounting lines.
1911: l_gl_account_num := gl_account_num(xla_acnt_rec.code_combination_id);
1912: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1913: 'l_gl_account_num ='||l_gl_account_num );
1914: -- Determine the Treasury Symbol
1915:
1916: get_treasury_symbol( bl_seg_name, xla_acnt_rec.code_combination_id );

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

1914: -- Determine the Treasury Symbol
1915:
1916: get_treasury_symbol( bl_seg_name, xla_acnt_rec.code_combination_id );
1917:
1918: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1919: 'bl_seg_name='||bl_seg_name );
1920: -- Insertion of Receipt Accounting information into
1921: -- the table fv_ipac_trx_all
1922: v_bulk_exception := NULL;

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

1989:
1990: END LOOP; -- End FOR get_evnt_rec IN get_evnt_cur(l_entity_id)
1991:
1992: ELSE -- SLA Accounting Failed
1993: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
1994: x_errbuf);
1995: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
1996: -- and bulk_exception = 'ACCOUNTING_NOT_CREATED'
1997: -- for the particular transaction

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

2062: -- created, then generate SLA Accounting -- SLA Accounting Done Successfully
2063: EXCEPTION
2064: WHEN OTHERS THEN
2065:
2066: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2067: 'Create_Receipt_Accounting - Unexpected Error, Calling Update');
2068:
2069: UPDATE fv_ipac_trx_all
2070: SET accounted_flag = '',

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

2099: l_module_name VARCHAR2(200);
2100:
2101: BEGIN
2102:
2103: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2104: 'create_receipt_and_apply begins');
2105:
2106: -- Create new receipts only for those transactions which already don't have
2107: -- any receipts applied to them

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

2105:
2106: -- Create new receipts only for those transactions which already don't have
2107: -- any receipts applied to them
2108:
2109: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2110: 'trx_receipt_rec.cash_receipt_id = ' || trx_receipt_rec.cash_receipt_id);
2111:
2112: IF trx_receipt_rec.cash_receipt_id IS NULL THEN
2113:

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

2125: AND arma.org_id = v_org_id;
2126:
2127: EXCEPTION
2128: WHEN NO_DATA_FOUND THEN
2129: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2130: 'There is no Billing ALC defined for the Transaction '||trx_receipt_rec.trx_number);
2131: END;
2132:
2133: ar_receipt_api_pub.create_and_apply(p_api_version => 1.0,

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

2152:
2153: -- If the create_and_apply receipt is done successfully
2154: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2155:
2156: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2157: 'create_and_apply receipt is done successfully');
2158:
2159: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2160: 'The receipt is created for the transaction number: '

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

2155:
2156: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2157: 'create_and_apply receipt is done successfully');
2158:
2159: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2160: 'The receipt is created for the transaction number: '
2161: || trx_receipt_rec.trx_number || ' with Receipt ID: '
2162: || to_char(x_cash_receipt_id));
2163:

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

2232: -- Add a new row in fv_ipac_trx_all with unt_iss = '~RA'
2233: -- and bulk_exception = 'RECEIPT_NOT_CREATED' for the particular
2234: -- transaction
2235:
2236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2237: 'create_and_apply receipt fails');
2238:
2239: INSERT
2240: INTO fv_ipac_trx_all

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

2295: AND customer_trx_id = trx_receipt_rec.customer_trx_id
2296: AND exclude_flag = 'N'
2297: AND report_flag = 'Y'
2298: AND processed_flag = 'N';
2299: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2300: 'Error generated during the creation of receipt for the transaction number: '
2301: || trx_receipt_rec.trx_number);
2302:
2303: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

2299: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2300: 'Error generated during the creation of receipt for the transaction number: '
2301: || trx_receipt_rec.trx_number);
2302:
2303: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2304: 'Return Status: ' || x_return_status);
2305:
2306: IF x_msg_data IS NOT NULL THEN
2307: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

2303: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2304: 'Return Status: ' || x_return_status);
2305:
2306: IF x_msg_data IS NOT NULL THEN
2307: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2308: 'Error Information: ' || x_msg_data );
2309: END IF;
2310: END IF; -- Condition related with the success or failure
2311: -- of create_and_apply receipt process

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

2328: errmsg := SQLERRM;
2329: END IF;
2330: retcode := errcode;
2331: errbuf := errmsg;
2332: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2333: 'Errbuf :'||errbuf);
2334: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2335: 'retcode :'||retcode);
2336:

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

2330: retcode := errcode;
2331: errbuf := errmsg;
2332: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2333: 'Errbuf :'||errbuf);
2334: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2335: 'retcode :'||retcode);
2336:
2337: END; -- create_receipt_and_apply
2338:

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

2355: l_module_name VARCHAR2(200);
2356: BEGIN
2357: l_module_name:=g_module_name||'create_receipt_acct_main';
2358:
2359: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2360: 'create_receipt_acct_main begins');
2361:
2362: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2363: 'Input parameters are :');

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

2358:
2359: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2360: 'create_receipt_acct_main begins');
2361:
2362: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2363: 'Input parameters are :');
2364: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2365: 'Parm_CURRENCY_CODE :'||parm_currency);
2366: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

2360: 'create_receipt_acct_main begins');
2361:
2362: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2363: 'Input parameters are :');
2364: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2365: 'Parm_CURRENCY_CODE :'||parm_currency);
2366: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2367: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2368: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

2362: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2363: 'Input parameters are :');
2364: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2365: 'Parm_CURRENCY_CODE :'||parm_currency);
2366: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2367: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2368: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2369: 'P_RECIPT_DATE :'||P_RECEIPT_DATE);
2370: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

2364: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2365: 'Parm_CURRENCY_CODE :'||parm_currency);
2366: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2367: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2368: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2369: 'P_RECIPT_DATE :'||P_RECEIPT_DATE);
2370: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2371: 'P_GL_DATE :'||P_GL_DATE);
2372:

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

2366: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2367: 'P_RECEIPT_METHOD_ID :'||P_RECEIPT_METHOD_ID);
2368: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2369: 'P_RECIPT_DATE :'||P_RECEIPT_DATE);
2370: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2371: 'P_GL_DATE :'||P_GL_DATE);
2372:
2373: get_bal_seg_name;
2374:

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

2375:
2376: for trx_receipt_rec in trx_receipt_cur
2377: loop
2378:
2379: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2380: 'Calling create_receipt_and_apply with customer_trx_id='||
2381: trx_receipt_rec.customer_trx_id);
2382:
2383: create_receipt_and_apply(errbuf,

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

2399: FALSE,
2400: v_org_id);
2401:
2402: -- if concurrent request submission failed then abort process
2403: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2404: 'IPAC Bulk File Report Request ID =' ||l_req_id);
2405:
2406: IF l_req_id = 0 THEN
2407: errbuf := 'Unable to Submit Bulk File Report ';

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

2435: v_set_of_books_id,
2436: v_org_id );
2437:
2438: -- if concurrent request submission failed then abort process
2439: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2440: 'IPAC Bulk File Exception Report Request ID =' ||l_req_id);
2441:
2442: IF l_req_id = 0 THEN
2443: errbuf := 'Unable to Submit Apply Cash Receipts Process';

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

2464: END IF;
2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: ROLLBACK;
2468: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2469: ' -- Error IN IPAC Bulk Exception process: Procedure:- create_bulk_file');
2470:
2471: IF errcode IS NULL THEN
2472: errcode := SQLCODE;

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

2474: END IF;
2475: retcode := errcode;
2476: errbuf := errmsg;
2477:
2478: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2479: 'Errbuf :'||errbuf);
2480: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2481: 'retcode :'||retcode);
2482: END;

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

2476: errbuf := errmsg;
2477:
2478: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2479: 'Errbuf :'||errbuf);
2480: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2481: 'retcode :'||retcode);
2482: END;
2483: EXCEPTION
2484: WHEN OTHERS THEN

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

2487: errmsg := SQLERRM;
2488: END IF;
2489: retcode := errcode;
2490: errbuf := errmsg;
2491: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2492: 'Errbuf :'||errbuf);
2493: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2494: 'retcode :'||retcode);
2495:

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

2489: retcode := errcode;
2490: errbuf := errmsg;
2491: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2492: 'Errbuf :'||errbuf);
2493: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2494: 'retcode :'||retcode);
2495:
2496: END;
2497:

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

2520: v_set_of_books_id,
2521: v_coa_id ,
2522: parm_currency ,
2523: p_status );
2524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2525: 'create_bulk_file begins'||l_rec_count);
2526:
2527: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2528: 'Org_id = '||p_org_id);

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

2523: p_status );
2524: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2525: 'create_bulk_file begins'||l_rec_count);
2526:
2527: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2528: 'Org_id = '||p_org_id);
2529:
2530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2531: 'v_set_of_books_id = '||v_set_of_books_id);

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

2526:
2527: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2528: 'Org_id = '||p_org_id);
2529:
2530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2531: 'v_set_of_books_id = '||v_set_of_books_id);
2532:
2533:
2534: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

2530: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2531: 'v_set_of_books_id = '||v_set_of_books_id);
2532:
2533:
2534: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2535: 'v_coa_id = '||v_coa_id);
2536:
2537: SELECT count(1)
2538: INTO l_rec_count

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

2544: AND exclude_flag ='N'
2545: AND processed_flag = 'N'
2546: AND bulk_exception is null;
2547:
2548: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2549: 'l_rec_count = '||l_rec_count);
2550:
2551: IF l_rec_count>0 then
2552: get_bal_seg_name;

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

2559:
2560: FOR hdr_det_rec IN hdr_det(v_set_of_books_id, v_org_id)
2561: LOOP
2562:
2563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2564: 'Creating trx header for customer_trx_id = '||hdr_det_rec.customer_trx_id);
2565:
2566: -- Create the Transaction Header Record
2567: create_trx_header(v_set_of_books_id,

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

2592: AND report_flag = 'Y';
2593: else
2594: retcode:=1;
2595: errbuf := 'No Records Found for Bulk File Report.';
2596: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2597: 'No Records Found for Bulk File Report.');
2598:
2599: return;
2600: end if;

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

2606: errmsg := SQLERRM;
2607: END IF;
2608: retcode := errcode;
2609: errbuf := errmsg;
2610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2611: 'Errbuf :'||errbuf);
2612: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2613: 'retcode :'||retcode);
2614: END ; -- create_bulk_file;

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

2608: retcode := errcode;
2609: errbuf := errmsg;
2610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2611: 'Errbuf :'||errbuf);
2612: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2613: 'retcode :'||retcode);
2614: END ; -- create_bulk_file;
2615:
2616: -- -----------------------------------------------------------------------------

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

2633: EXCEPTION
2634: WHEN OTHERS THEN
2635: errbuf := SQLERRM;
2636: retcode := SQLCODE;
2637: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, errbuf);
2638: RAISE ;
2639: RETURN;
2640: END;
2641: BEGIN

Line 2651: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,

2647: EXCEPTION
2648: WHEN OTHERS THEN
2649: retcode := SQLCODE ;
2650: errbuf := SQLERRM ;
2651: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
2652: l_module_name, errbuf) ;
2653: RAISE ;
2654: END ;
2655: DBMS_SQL.DEFINE_COLUMN(v_cursor_id, 1, col1, 2000);

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

2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: retcode := SQLCODE ;
2661: errbuf := SQLERRM ;
2662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2663: 'Create Sql ');
2664: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2665: errbuf) ;
2666: RAISE ;

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

2660: retcode := SQLCODE ;
2661: errbuf := SQLERRM ;
2662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2663: 'Create Sql ');
2664: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2665: errbuf) ;
2666: RAISE ;
2667: END;
2668: LOOP

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

2674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, col1);
2675: END LOOP;
2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
2680: l_module_name, errmsg);
2681: END IF;
2682: RAISE;

Line 2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,

2675: END LOOP;
2676: EXCEPTION
2677: WHEN OTHERS THEN
2678: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2679: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED,
2680: l_module_name, errmsg);
2681: END IF;
2682: RAISE;
2683: END;

Line 2691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2687:
2688: BEGIN
2689: v_org_id := mo_global.get_current_org_id;
2690:
2691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2692: 'fv.plsql.fv_ipac','Org Id : '||v_org_id);
2693:
2694: fv_utility.get_ledger_info(v_org_id,
2695: v_set_of_books_id,