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

Line 98: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

94: costcenters_tab costcenters_tab_type;
95: l_api_name CONSTANT VARCHAR2(30) :='REVERT_NEGATIVE_JOURNALS';
96: BEGIN
97: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
98: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
99: G_PKG_NAME||': '||l_api_name||'()+');
100: END IF;
101:
102: --fnd_file.put_line(fnd_file.log,'in revert negative journals');

Line 122: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

118: IF g_debug_flag = 'Y' THEN
119: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
120: END IF;
121: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
122: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
123: END IF;
124: g_errbuf := 'ERROR While reverting the negative journals '||SQLERRM;
125: g_retcode := 2;
126: return;

Line 193: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

189: IF g_debug_flag = 'Y' THEN
190: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
191: END IF;
192: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
193: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
194: END IF;
195: g_errbuf := 'ERROR While updating the negative journals '||SQLERRM;
196: g_retcode := 2;
197: return;

Line 201: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

197: return;
198: END;
199:
200: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
202: G_PKG_NAME||': ' ||l_api_name||'()-');
203: END IF;
204:
205: END revert_negative_journals;

Line 259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

255: ORDER BY assignment_date, value_attribute_type) ;
256:
257: BEGIN
258: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
260: G_PKG_NAME||': '||l_api_name||'()+');
261: END IF;
262:
263: g_created_by := NVL(fnd_profile.value('USER_ID'),1);

Line 364: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No company found for Legal Entity Id: '||p_legal_entity_id||' Establishment Id :'||p_establishment_id);

360: END IF;
361: EXCEPTION
362: WHEN NO_DATA_FOUND THEN
363: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No company found for Legal Entity Id: '||p_legal_entity_id||' Establishment Id :'||p_establishment_id);
365: END IF;
366: g_errbuf := 'Company Not Found ';
367: g_retcode := 2;
368: return;

Line 371: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

367: g_retcode := 2;
368: return;
369: WHEN OTHERS THEN
370: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
372: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get company Name. Legal Entity Id: '||p_legal_entity_id||' Establishment Id :'||p_establishment_id);
373: END IF;
374: g_errbuf := 'Faied to get Company Name ';
375: g_retcode := 2;

Line 372: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get company Name. Legal Entity Id: '||p_legal_entity_id||' Establishment Id :'||p_establishment_id);

368: return;
369: WHEN OTHERS THEN
370: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
372: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get company Name. Legal Entity Id: '||p_legal_entity_id||' Establishment Id :'||p_establishment_id);
373: END IF;
374: g_errbuf := 'Faied to get Company Name ';
375: g_retcode := 2;
376: return;

Line 391: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No record exists for ledger: '||g_ledger_id);

387:
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
391: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No record exists for ledger: '||g_ledger_id);
392: END IF;
393: g_errbuf := 'Error while fetching Pertiod Set Name and Currency Code ';
394: g_retcode := 2;
395: return;

Line 398: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

394: g_retcode := 2;
395: return;
396: WHEN OTHERS THEN
397: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
398: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get period_set_name for Ledger: '||g_ledger_id);
400: END IF;
401: g_errbuf := 'Error while fetching Pertiod Set Name and Currency Code ';
402: g_retcode := 2;

Line 399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get period_set_name for Ledger: '||g_ledger_id);

395: return;
396: WHEN OTHERS THEN
397: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
398: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get period_set_name for Ledger: '||g_ledger_id);
400: END IF;
401: g_errbuf := 'Error while fetching Pertiod Set Name and Currency Code ';
402: g_retcode := 2;
403: return;

Line 441: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

437: END IF;
438: EXCEPTION
439: WHEN OTHERS THEN
440: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
442: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to check whether it is exclusive mode or shared mode');
443: END IF;
444: g_errbuf := 'Failed to check whether it is exclusive mode or shared mode';
445: g_retcode := 2;

Line 442: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to check whether it is exclusive mode or shared mode');

438: EXCEPTION
439: WHEN OTHERS THEN
440: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
441: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
442: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to check whether it is exclusive mode or shared mode');
443: END IF;
444: g_errbuf := 'Failed to check whether it is exclusive mode or shared mode';
445: g_retcode := 2;
446: return;

Line 500: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Not a valid period: '||p_period_name);

496:
497: EXCEPTION
498: WHEN NO_DATA_FOUND THEN
499: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Not a valid period: '||p_period_name);
501: END IF;
502: g_errbuf := 'Not a valid period ';
503: g_retcode := 2;
504: return;

Line 507: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

503: g_retcode := 2;
504: return;
505: WHEN OTHERS THEN
506: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
507: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get start and end dates for '||p_period_name);
509: END IF;
510: g_errbuf := 'Failed to get start and end dates for '||p_period_name;
511: g_retcode := 2;

Line 508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get start and end dates for '||p_period_name);

504: return;
505: WHEN OTHERS THEN
506: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
507: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get start and end dates for '||p_period_name);
509: END IF;
510: g_errbuf := 'Failed to get start and end dates for '||p_period_name;
511: g_retcode := 2;
512: return;

Line 535: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Start and end dates do not belong to same period: '||p_start_date||' '||p_end_date);

531:
532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
535: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Start and end dates do not belong to same period: '||p_start_date||' '||p_end_date);
536: END IF;
537: g_errbuf := 'Start and end date do not belong to same period: '||p_start_date||' '||p_end_date;
538: g_retcode := 2;
539: return;

Line 542: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

538: g_retcode := 2;
539: return;
540: WHEN OTHERS THEN
541: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
543: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get period name for given start and end dates '||p_start_date||' '||p_end_date);
544:
545: END IF;
546: g_errbuf := 'Failed to get period name for given start and end date '||p_start_date||' '||p_end_date||' '||SQLERRM;

Line 543: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get period name for given start and end dates '||p_start_date||' '||p_end_date);

539: return;
540: WHEN OTHERS THEN
541: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
543: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get period name for given start and end dates '||p_start_date||' '||p_end_date);
544:
545: END IF;
546: g_errbuf := 'Failed to get period name for given start and end date '||p_start_date||' '||p_end_date||' '||SQLERRM;
547: g_retcode := 2;

Line 566: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Not a valid period: '||p_period_name);

562:
563: EXCEPTION
564: WHEN NO_DATA_FOUND THEN
565: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
566: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Not a valid period: '||p_period_name);
567: END IF;
568: g_errbuf := 'Not a valid adjustment period ';
569: g_retcode := 2;
570: return;

Line 573: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

569: g_retcode := 2;
570: return;
571: WHEN OTHERS THEN
572: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
574: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get start and end dates for '||p_period_name);
575: END IF;
576: g_errbuf := 'Failed to get start and end dates for adjustment period '||p_period_name;
577: g_retcode := 2;

Line 574: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get start and end dates for '||p_period_name);

570: return;
571: WHEN OTHERS THEN
572: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
574: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get start and end dates for '||p_period_name);
575: END IF;
576: g_errbuf := 'Failed to get start and end dates for adjustment period '||p_period_name;
577: g_retcode := 2;
578: return;

Line 597: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No balacing segment found in fnd_segment_attribute_values' );

593: AND id_flex_num = g_chart_of_accounts_id;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No balacing segment found in fnd_segment_attribute_values' );
598: END IF;
599: g_errbuf := 'No balancing segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;
600: g_retcode := 2;
601: return;

Line 604: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

600: g_retcode := 2;
601: return;
602: WHEN OTHERS THEN
603: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
605: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for Balancing segment');
606: END IF;
607: g_errbuf := 'Failed to get column used for Balancing segment';
608: g_retcode := 2;

Line 605: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for Balancing segment');

601: return;
602: WHEN OTHERS THEN
603: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
605: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for Balancing segment');
606: END IF;
607: g_errbuf := 'Failed to get column used for Balancing segment';
608: g_retcode := 2;
609: return;

Line 627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Natural account segment found in fnd_segment_attribute_values' );

623:
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Natural account segment found in fnd_segment_attribute_values' );
628: END IF;
629: g_errbuf := 'No Natural account segment found in fnd_segment_attribute_values for '||g_chart_of_accounts_id;
630: g_retcode := 2;
631: return;

Line 634: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

630: g_retcode := 2;
631: return;
632: WHEN OTHERS THEN
633: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
635: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for Natural account');
636: END IF;
637: g_errbuf := 'Failed to get column used for Natural account';
638: g_retcode := 2;

Line 635: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for Natural account');

631: return;
632: WHEN OTHERS THEN
633: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
635: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for Natural account');
636: END IF;
637: g_errbuf := 'Failed to get column used for Natural account';
638: g_retcode := 2;
639: return;

Line 659: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No cost center segment found in fnd_segment_attribute_values' );

655:
656: EXCEPTION
657: WHEN NO_DATA_FOUND THEN
658: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
659: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No cost center segment found in fnd_segment_attribute_values' );
660: END IF;
661:
662: l_cc_exists_flag := 0; -- cost center setup doesn't exist
663: g_cost_center_segment := 'SEGMENT20'; -- To frame the dynamic query in I155,I310 assigned this column name. But we won't retrieve this column values.

Line 667: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

663: g_cost_center_segment := 'SEGMENT20'; -- To frame the dynamic query in I155,I310 assigned this column name. But we won't retrieve this column values.
664: -- If l_cc_exists_flag = 0 then we will retrieve null
665: WHEN OTHERS THEN
666: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
668: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for cost center');
669: END IF;
670:
671: l_cc_exists_flag := 0;

Line 668: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for cost center');

664: -- If l_cc_exists_flag = 0 then we will retrieve null
665: WHEN OTHERS THEN
666: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
668: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get column used for cost center');
669: END IF;
670:
671: l_cc_exists_flag := 0;
672: g_cost_center_segment := 'SEGMENT20';

Line 690: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No value set found for: '||g_account_segment);

686:
687: EXCEPTION
688: WHEN NO_DATA_FOUND THEN
689: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
690: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No value set found for: '||g_account_segment);
691: END IF;
692: g_errbuf := 'No value set found for: '||g_account_segment;
693: g_retcode := 2;
694: return;

Line 697: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

693: g_retcode := 2;
694: return;
695: WHEN OTHERS THEN
696: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
697: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
698: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_account_segment);
699: END IF;
700: g_errbuf := 'Failed in retrieving value set for'||g_account_segment;
701: g_retcode := 2;

Line 698: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_account_segment);

694: return;
695: WHEN OTHERS THEN
696: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
697: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
698: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_account_segment);
699: END IF;
700: g_errbuf := 'Failed in retrieving value set for'||g_account_segment;
701: g_retcode := 2;
702: return;

Line 726: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No value set found for: '||g_cost_center_segment);

722:
723: EXCEPTION
724: WHEN NO_DATA_FOUND THEN
725: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
726: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No value set found for: '||g_cost_center_segment);
727: END IF;
728: g_errbuf := 'No value set found for: '||g_cost_center_segment;
729: g_retcode := 2;
730: return;

Line 733: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

729: g_retcode := 2;
730: return;
731: WHEN OTHERS THEN
732: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
734: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_cost_center_segment);
735: END IF;
736: g_errbuf := 'Failed in retrieving value set for'||g_cost_center_segment;
737: g_retcode := 2;

Line 734: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_cost_center_segment);

730: return;
731: WHEN OTHERS THEN
732: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
733: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
734: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_cost_center_segment);
735: END IF;
736: g_errbuf := 'Failed in retrieving value set for'||g_cost_center_segment;
737: g_retcode := 2;
738: return;

Line 781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

777:
778: EXCEPTION
779: WHEN OTHERS THEN
780: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
782: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_cost_center_segment);
783: END IF;
784: g_errbuf := 'Failed in Deriving the position of account and sped qualifiers';
785: g_retcode := 2;

Line 782: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_cost_center_segment);

778: EXCEPTION
779: WHEN OTHERS THEN
780: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
782: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving value set'||g_cost_center_segment);
783: END IF;
784: g_errbuf := 'Failed in Deriving the position of account and sped qualifiers';
785: g_retcode := 2;
786: return;

Line 801: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

797:
798: EXCEPTION
799: WHEN OTHERS THEN
800: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
802: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving Balance Sheet Report ID');
803: END IF;
804: END;
805:

Line 802: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving Balance Sheet Report ID');

798: EXCEPTION
799: WHEN OTHERS THEN
800: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
801: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
802: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving Balance Sheet Report ID');
803: END IF;
804: END;
805:
806: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): Balance Sheet Report Id : '||g_balance_statement_report_id);

Line 819: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

815:
816: EXCEPTION
817: WHEN OTHERS THEN
818: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
819: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
820: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving Income Statement Report ID');
821: END IF;
822: END;
823: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): Income Statement Report Id : '||g_income_statement_report_id);

Line 820: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving Income Statement Report ID');

816: EXCEPTION
817: WHEN OTHERS THEN
818: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
819: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
820: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed in retrieving Income Statement Report ID');
821: END IF;
822: END;
823: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): Income Statement Report Id : '||g_income_statement_report_id);
824:

Line 839: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

835:
836: EXCEPTION
837: WHEN OTHERS THEN
838: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
839: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
840: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Verifiying the auxiliary books setup availabiblity.');
841: END IF;
842: END;
843:

Line 840: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Verifiying the auxiliary books setup availabiblity.');

836: EXCEPTION
837: WHEN OTHERS THEN
838: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
839: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
840: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Verifiying the auxiliary books setup availabiblity.');
841: END IF;
842: END;
843:
844: IF substr(g_bookkeeping_type,1,1) = 'A' AND g_ap_ar_auxbook_exist = 0 THEN

Line 872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No data found for Balance sheet request Id:'||g_balance_statement_request_id);

868:
869: EXCEPTION
870: WHEN NO_DATA_FOUND THEN
871: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No data found for Balance sheet request Id:'||g_balance_statement_request_id);
873: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
874: END IF;
875: WHEN OTHERS THEN
876: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 873: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

869: EXCEPTION
870: WHEN NO_DATA_FOUND THEN
871: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No data found for Balance sheet request Id:'||g_balance_statement_request_id);
873: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
874: END IF;
875: WHEN OTHERS THEN
876: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
877: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Balance sheet request Id:'||g_balance_statement_request_id);

Line 877: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Balance sheet request Id:'||g_balance_statement_request_id);

873: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
874: END IF;
875: WHEN OTHERS THEN
876: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
877: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Balance sheet request Id:'||g_balance_statement_request_id);
878: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
879: END IF;
880: END;
881:

Line 878: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

874: END IF;
875: WHEN OTHERS THEN
876: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
877: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Balance sheet request Id:'||g_balance_statement_request_id);
878: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
879: END IF;
880: END;
881:
882: END IF; --END for IF g_balance_statement_request_id is not null

Line 906: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No data found exception while trying to fetch amount type for Income Statement Report'||g_income_statement_request_id);

902:
903: EXCEPTION
904: WHEN NO_DATA_FOUND THEN
905: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No data found exception while trying to fetch amount type for Income Statement Report'||g_income_statement_request_id);
907: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
908: END IF;
909: WHEN OTHERS THEN
910: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 907: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

903: EXCEPTION
904: WHEN NO_DATA_FOUND THEN
905: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
906: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No data found exception while trying to fetch amount type for Income Statement Report'||g_income_statement_request_id);
907: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
908: END IF;
909: WHEN OTHERS THEN
910: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Income statement request id:'||g_income_statement_request_id);

Line 911: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Income statement request id:'||g_income_statement_request_id);

907: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
908: END IF;
909: WHEN OTHERS THEN
910: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Income statement request id:'||g_income_statement_request_id);
912: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
913: END IF;
914: END;
915:

Line 912: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

908: END IF;
909: WHEN OTHERS THEN
910: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
911: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Failed to get information for Income statement request id:'||g_income_statement_request_id);
912: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
913: END IF;
914: END;
915:
916: END IF; -- End for IF g_income_statement_request_id is not null

Line 932: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the tax regime and tax used to create state inscription.');

928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
932: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the tax regime and tax used to create state inscription.');
933: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
934: END IF;
935: END;
936:

Line 933: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

929: EXCEPTION
930: WHEN OTHERS THEN
931: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
932: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the tax regime and tax used to create state inscription.');
933: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
934: END IF;
935: END;
936:
937: END IF; -- End for IF p_state_insc_tax_id IS NOT NULL

Line 950: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the tax regime and tax used to create municipal inscription.');

946:
947: EXCEPTION
948: WHEN OTHERS THEN
949: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
950: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the tax regime and tax used to create municipal inscription.');
951: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
952: END IF;
953: END;
954:

Line 951: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

947: EXCEPTION
948: WHEN OTHERS THEN
949: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
950: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the tax regime and tax used to create municipal inscription.');
951: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
952: END IF;
953: END;
954:
955: END IF; -- End for IF p_state_insc_tax_id IS NOT NULL

Line 1038: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR While inserting into JL_BR_SPED_EXTR_PARAM ');
1040: END IF;
1041: g_errbuf := 'ERROR While inserting into JL_BR_SPED_EXTR_PARAM '||SQLERRM;
1042: g_retcode := 2;

Line 1039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR While inserting into JL_BR_SPED_EXTR_PARAM ');

1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1039: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR While inserting into JL_BR_SPED_EXTR_PARAM ');
1040: END IF;
1041: g_errbuf := 'ERROR While inserting into JL_BR_SPED_EXTR_PARAM '||SQLERRM;
1042: g_retcode := 2;
1043: return;

Line 1047: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1043: return;
1044: END;
1045:
1046: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1047: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1048: G_PKG_NAME||': ' ||l_api_name||'()-');
1049: END IF;
1050:
1051: EXCEPTION

Line 1059: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1055: IF g_debug_flag = 'Y' THEN
1056: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1057: END IF;
1058: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1060: END IF;
1061: g_errbuf := 'ERROR in Intialize Procedure '||SQLERRM;
1062: g_retcode := 2;
1063: return;

Line 1079: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1075: BEGIN
1076:
1077:
1078: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1080: G_PKG_NAME||': '||l_api_name||'()+');
1081: END IF;
1082:
1083: sqlstmt := 'SELECT to_char('||segment_code||') FROM gl_code_combinations WHERE code_combination_id = :ccid';

Line 1090: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1086: EXECUTE IMMEDIATE sqlstmt INTO segment_value USING ccid;
1087: EXCEPTION
1088: WHEN NO_DATA_FOUND THEN
1089: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1090: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1091: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No '||segment_code||' value found for: '||ccid);
1092: END IF;
1093: RETURN NULL;
1094: WHEN OTHERS THEN

Line 1091: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No '||segment_code||' value found for: '||ccid);

1087: EXCEPTION
1088: WHEN NO_DATA_FOUND THEN
1089: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1090: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1091: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No '||segment_code||' value found for: '||ccid);
1092: END IF;
1093: RETURN NULL;
1094: WHEN OTHERS THEN
1095: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1096: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1092: END IF;
1093: RETURN NULL;
1094: WHEN OTHERS THEN
1095: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1097: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get '||segment_code||' value for '||ccid);
1098: END IF;
1099: RETURN NULL;
1100:

Line 1097: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get '||segment_code||' value for '||ccid);

1093: RETURN NULL;
1094: WHEN OTHERS THEN
1095: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1096: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1097: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get '||segment_code||' value for '||ccid);
1098: END IF;
1099: RETURN NULL;
1100:
1101: END;

Line 1105: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1101: END;
1102: RETURN segment_value;
1103:
1104: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1105: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1106: G_PKG_NAME||': ' ||l_api_name||'()-');
1107: END IF;
1108: EXCEPTION
1109: WHEN OTHERS THEN

Line 1116: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1112: IF g_debug_flag = 'Y' THEN
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1114: END IF;
1115: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1116: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1117: END IF;
1118:
1119: END get_segment_value;
1120:

Line 1151: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1147: WHEN NO_DATA_FOUND THEN
1148: l_sped_code := null;
1149: WHEN OTHERS THEN
1150: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1151: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1152: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to sped accounting code for: '||p_flex_value_id);
1153: END IF;
1154: END;
1155: END IF;

Line 1152: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to sped accounting code for: '||p_flex_value_id);

1148: l_sped_code := null;
1149: WHEN OTHERS THEN
1150: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1151: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1152: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to sped accounting code for: '||p_flex_value_id);
1153: END IF;
1154: END;
1155: END IF;
1156:

Line 1175: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1171: WHEN NO_DATA_FOUND THEN
1172: l_acct_code := null;
1173: WHEN OTHERS THEN
1174: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1176: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get accounting code for: '||p_flex_value_id);
1177: END IF;
1178: END;
1179:

Line 1176: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get accounting code for: '||p_flex_value_id);

1172: l_acct_code := null;
1173: WHEN OTHERS THEN
1174: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1175: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1176: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Faied to get accounting code for: '||p_flex_value_id);
1177: END IF;
1178: END;
1179:
1180: SELECT DECODE(l_acct_code, 'A', '01', 'L','02', 'O','03', 'E','04', 'R','04',null)

Line 1212: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1208: l_api_name CONSTANT VARCHAR2(30) :='GET_PARTICIPANT_CODE';
1209:
1210: BEGIN
1211: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1212: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1213: G_PKG_NAME||': '||l_api_name||'()+');
1214: END IF;
1215:
1216:

Line 1218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num||' Source'||p_journal_source);

1214: END IF;
1215:
1216:
1217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num||' Source'||p_journal_source);
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'CCID :'||p_je_line_ccid||' Third Party Id:'||p_third_party_id||' Site Id :'||p_third_party_site_id);
1220: END IF;
1221:
1222:

Line 1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'CCID :'||p_je_line_ccid||' Third Party Id:'||p_third_party_id||' Site Id :'||p_third_party_site_id);

1215:
1216:
1217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num||' Source'||p_journal_source);
1219: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'CCID :'||p_je_line_ccid||' Third Party Id:'||p_third_party_id||' Site Id :'||p_third_party_site_id);
1220: END IF;
1221:
1222:
1223: -- In case of Manual Journal, User can enter Participant Code at Jounral Header or Lines level GDF.

Line 1231: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

1227:
1228: BEGIN
1229:
1230: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1231: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1232: 'Manual Journal:'||p_je_header_id||'-'||p_je_line_num);
1233: END IF;
1234:
1235:

Line 1256: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);

1252:
1253: EXCEPTION
1254: WHEN NO_DATA_FOUND THEN
1255: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1256: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);
1257: END IF;
1258: l_participant_code := NULL;
1259: WHEN OTHERS THEN
1260: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1261: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);

1257: END IF;
1258: l_participant_code := NULL;
1259: WHEN OTHERS THEN
1260: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1261: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);
1262: END IF;
1263: l_participant_code := NULL;
1264: END;
1265:

Line 1281: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);

1277:
1278: EXCEPTION
1279: WHEN NO_DATA_FOUND THEN
1280: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);
1282: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'Source'||p_journal_source||'Participant_type'||g_participant_type);
1283: END IF;
1284: l_participant_code := NULL;
1285: WHEN OTHERS THEN

Line 1282: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'Source'||p_journal_source||'Participant_type'||g_participant_type);

1278: EXCEPTION
1279: WHEN NO_DATA_FOUND THEN
1280: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);
1282: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'Source'||p_journal_source||'Participant_type'||g_participant_type);
1283: END IF;
1284: l_participant_code := NULL;
1285: WHEN OTHERS THEN
1286: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1287: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);

1283: END IF;
1284: l_participant_code := NULL;
1285: WHEN OTHERS THEN
1286: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1287: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLCODE||' '||SQLERRM);
1288: END IF;
1289: l_participant_code := NULL;
1290: END;
1291: RETURN l_participant_code;

Line 1317: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No participant code found');

1313:
1314: EXCEPTION
1315: WHEN NO_DATA_FOUND THEN
1316: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No participant code found');
1318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1319: END IF;
1320: l_participant_code := NULL;
1321: WHEN OTHERS THEN

Line 1318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1314: EXCEPTION
1315: WHEN NO_DATA_FOUND THEN
1316: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No participant code found');
1318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1319: END IF;
1320: l_participant_code := NULL;
1321: WHEN OTHERS THEN
1322: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1323: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the participant code.');

1319: END IF;
1320: l_participant_code := NULL;
1321: WHEN OTHERS THEN
1322: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1323: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the participant code.');
1324: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1325: END IF;
1326: l_participant_code := NULL;
1327: END;

Line 1324: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1320: l_participant_code := NULL;
1321: WHEN OTHERS THEN
1322: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1323: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while retrieving the participant code.');
1324: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1325: END IF;
1326: l_participant_code := NULL;
1327: END;
1328:

Line 1360: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1356: WHEN NO_DATA_FOUND THEN
1357: RETURN NULL; --participant_code not found.
1358: WHEN OTHERS THEN
1359: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1361: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1362: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1363: END IF;
1364: RETURN NULL;

Line 1361: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);

1357: RETURN NULL; --participant_code not found.
1358: WHEN OTHERS THEN
1359: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1361: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1362: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1363: END IF;
1364: RETURN NULL;
1365: END;

Line 1362: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);

1358: WHEN OTHERS THEN
1359: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1360: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1361: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1362: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1363: END IF;
1364: RETURN NULL;
1365: END;
1366:

Line 1393: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);

1389: RETURN l_participant_code;
1390: EXCEPTION
1391: WHEN NO_DATA_FOUND THEN
1392: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1393: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);
1394: END IF;
1395: RETURN NULL; --participant_code not found.
1396:
1397: WHEN OTHERS THEN

Line 1399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1395: RETURN NULL; --participant_code not found.
1396:
1397: WHEN OTHERS THEN
1398: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1400: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1402: END IF;
1403: RETURN NULL;

Line 1400: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);

1396:
1397: WHEN OTHERS THEN
1398: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1400: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1402: END IF;
1403: RETURN NULL;
1404: END;

Line 1401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);

1397: WHEN OTHERS THEN
1398: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1399: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1400: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1402: END IF;
1403: RETURN NULL;
1404: END;
1405:

Line 1430: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);

1426:
1427: EXCEPTION
1428: WHEN NO_DATA_FOUND THEN
1429: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);
1431: END IF;
1432: RETURN NULL; --participant_code not found.
1433: WHEN OTHERS THEN
1434: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1435: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1431: END IF;
1432: RETURN NULL; --participant_code not found.
1433: WHEN OTHERS THEN
1434: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1436: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1437: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1438: END IF;
1439: RETURN NULL;

Line 1436: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);

1432: RETURN NULL; --participant_code not found.
1433: WHEN OTHERS THEN
1434: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1436: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1437: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1438: END IF;
1439: RETURN NULL;
1440: END;

Line 1437: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);

1433: WHEN OTHERS THEN
1434: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1436: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1437: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1438: END IF;
1439: RETURN NULL;
1440: END;
1441:

Line 1466: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);

1462: RETURN l_participant_code;
1463: EXCEPTION
1464: WHEN NO_DATA_FOUND THEN
1465: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1466: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);
1467: END IF;
1468: RETURN NULL; --participant_code not found.
1469: WHEN OTHERS THEN
1470: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1471: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1467: END IF;
1468: RETURN NULL; --participant_code not found.
1469: WHEN OTHERS THEN
1470: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1472: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1473: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1474: RETURN NULL;
1475: END IF;

Line 1472: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);

1468: RETURN NULL; --participant_code not found.
1469: WHEN OTHERS THEN
1470: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1472: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1473: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1474: RETURN NULL;
1475: END IF;
1476: END;

Line 1473: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);

1469: WHEN OTHERS THEN
1470: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1471: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1472: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1473: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1474: RETURN NULL;
1475: END IF;
1476: END;
1477:

Line 1503: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);

1499: RETURN l_participant_code;
1500: EXCEPTION
1501: WHEN NO_DATA_FOUND THEN
1502: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Participant Code found '||SQLERRM);
1504: END IF;
1505: RETURN NULL; --participant_code not found.
1506: WHEN OTHERS THEN
1507: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1504: END IF;
1505: RETURN NULL; --participant_code not found.
1506: WHEN OTHERS THEN
1507: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1509: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1510: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1511: END IF;
1512: RETURN NULL;

Line 1509: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);

1505: RETURN NULL; --participant_code not found.
1506: WHEN OTHERS THEN
1507: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1509: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1510: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1511: END IF;
1512: RETURN NULL;
1513: END;

Line 1510: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);

1506: WHEN OTHERS THEN
1507: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1508: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1509: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Journal Header: '||p_je_header_id||' Journal Line: '||p_je_line_num);
1510: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||' Source'||p_journal_source||' Participant_type'||g_participant_type);
1511: END IF;
1512: RETURN NULL;
1513: END;
1514:

Line 1520: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1516:
1517: END IF; --End for IF p_journal_source = 'Payables'
1518:
1519: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1520: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1521: G_PKG_NAME||': ' ||l_api_name||'()-');
1522: END IF;
1523:
1524:

Line 1534: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1530: IF g_debug_flag = 'Y' THEN
1531: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1532: END IF;
1533: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1534: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1535: END IF;
1536: g_errbuf := 'ERROR While deriving the participant code for journal header_id and line num '||p_je_header_id||'-'||p_je_line_num||SQLERRM;
1537: FND_FILE.PUT_LINE(FND_FILE.LOG, g_errbuf);
1538: return NULL;

Line 1552: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1548:
1549: BEGIN
1550:
1551: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1552: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1553: G_PKG_NAME||': ' ||l_api_name||'()+');
1554: END IF;
1555:
1556: IF l_estb_acts_as_company='N' THEN -- If LE acts as company

Line 1578: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge city code');

1574: WHEN OTHERS THEN
1575: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge city code');
1576: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1577: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge city code');
1579: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1580: END IF;
1581: END;
1582:

Line 1579: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1575: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge city code');
1576: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1577: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1578: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge city code');
1579: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1580: END IF;
1581: END;
1582:
1583: BEGIN -- retrieving cnpj

Line 1604: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');

1600: WHEN OTHERS THEN
1601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');
1602: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1603: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1604: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');
1605: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1606: END IF;
1607: END;
1608:

Line 1605: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');
1602: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1603: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1604: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');
1605: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1606: END IF;
1607: END;
1608:
1609:

Line 1627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');

1623:
1624: EXCEPTION
1625: WHEN OTHERS THEN
1626: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');
1628: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1629: END IF;
1630: END;
1631: BEGIN -- --Retrieving municipal inscription

Line 1628: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1624: EXCEPTION
1625: WHEN OTHERS THEN
1626: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1627: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');
1628: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1629: END IF;
1630: END;
1631: BEGIN -- --Retrieving municipal inscription
1632: SELECT registration_number

Line 1646: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');

1642: AND rownum =1;
1643: EXCEPTION
1644: WHEN OTHERS THEN
1645: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');
1647: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1648: END IF;
1649: END;
1650: ELSE -- g_inscription_source ='EBTax'(ZX)

Line 1647: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1643: EXCEPTION
1644: WHEN OTHERS THEN
1645: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');
1647: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1648: END IF;
1649: END;
1650: ELSE -- g_inscription_source ='EBTax'(ZX)
1651:

Line 1673: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');

1669: AND rownum =1;
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
1674: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1675: END IF;
1676: END;
1677:

Line 1674: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1673: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
1674: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1675: END IF;
1676: END;
1677:
1678: BEGIN -- retreive municipal inscription

Line 1699: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');

1695: AND rownum =1;
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1699: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');
1700: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1701: END IF;
1702: END;
1703:

Line 1700: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1699: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');
1700: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1701: END IF;
1702: END;
1703:
1704: END IF; -- END for p_insciption_source='LE'

Line 1729: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge_city_code');

1725: WHEN OTHERS THEN
1726: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge_city_code');
1727: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1728: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1729: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge_city_code');
1730: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1731: END IF;
1732: END;
1733:

Line 1730: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1726: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge_city_code');
1727: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1728: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1729: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge_city_code');
1730: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1731: END IF;
1732: END;
1733:
1734:

Line 1756: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');

1752: WHEN OTHERS THEN
1753: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1755: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1756: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');
1757: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1758: END IF;
1759: END;
1760:

Line 1757: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1753: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1755: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1756: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');
1757: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1758: END IF;
1759: END;
1760:
1761:

Line 1781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');

1777:
1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');
1782: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1783: END IF;
1784: END;
1785: BEGIN --Retrieving municipal inscription

Line 1782: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1778: EXCEPTION
1779: WHEN OTHERS THEN
1780: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');
1782: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1783: END IF;
1784: END;
1785: BEGIN --Retrieving municipal inscription
1786: SELECT registration_number

Line 1800: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');

1796: AND rownum=1;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1800: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');
1801: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1802: END IF;
1803: END;
1804: ELSE -- g_inscription_source ='EBTax' ('ZX')

Line 1801: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1800: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');
1801: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1802: END IF;
1803: END;
1804: ELSE -- g_inscription_source ='EBTax' ('ZX')
1805:

Line 1825: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');

1821: AND rownum =1;
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1825: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
1826: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1827: END IF;
1828: END;
1829:

Line 1826: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1825: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
1826: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1827: END IF;
1828: END;
1829:
1830: BEGIN -- retreive municipal inscription

Line 1849: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving Municipal inscription for EBTax');

1845: AND rownum =1;
1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving Municipal inscription for EBTax');
1850: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1851: END IF;
1852: END;
1853:

Line 1850: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1846: EXCEPTION
1847: WHEN OTHERS THEN
1848: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving Municipal inscription for EBTax');
1850: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1851: END IF;
1852: END;
1853:
1854: END IF; -- END for p_insciption_source='XLE'

Line 1928: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1924: WHEN OTHERS THEN
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Inserting data into 0000 register');
1926: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
1927: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1928: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1929: END IF;
1930: g_errbuf := 'ERROR While inserting 0000 register '||SQLERRM;
1931: g_retcode := 2;
1932: return;

Line 1935: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1931: g_retcode := 2;
1932: return;
1933: END;
1934: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1935: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1936: G_PKG_NAME||': ' ||l_api_name||'()-');
1937: END IF;
1938: EXCEPTION
1939: WHEN OTHERS THEN

Line 1941: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in 0000 register'||SQLERRM);

1937: END IF;
1938: EXCEPTION
1939: WHEN OTHERS THEN
1940: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1941: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in 0000 register'||SQLERRM);
1942: END IF;
1943:
1944:
1945: END register_0000;

Line 1953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

1949:
1950: BEGIN
1951:
1952: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1953: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
1954: G_PKG_NAME||': '||l_api_name||'()+');
1955: END IF;
1956:
1957: INSERT INTO jl_br_sped_extr_data_t

Line 1986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

1982:
1983: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
1984:
1985: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1986: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
1987: G_PKG_NAME||': ' ||l_api_name||'()-');
1988: END IF;
1989:
1990: EXCEPTION

Line 1998: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

1994: IF g_debug_flag = 'Y' THEN
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1996: END IF;
1997: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
1998: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
1999: END IF;
2000: g_errbuf := 'ERROR While inserting 0001 register '||SQLERRM;
2001: g_retcode := 2;
2002: return;

Line 2012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

2008:
2009: BEGIN
2010:
2011: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
2013: G_PKG_NAME||': '||l_api_name||'()+');
2014: END IF;
2015:
2016: IF l_estb_acts_as_company = 'N' THEN --LE acts as company

Line 2099: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

2095:
2096: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
2097:
2098: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2099: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2100: G_PKG_NAME||': ' ||l_api_name||'()-');
2101: END IF;
2102:
2103: EXCEPTION

Line 2111: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2107: IF g_debug_flag = 'Y' THEN
2108: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2109: END IF;
2110: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2111: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2112: END IF;
2113: g_errbuf := 'ERROR While inserting 0007 register '||SQLERRM;
2114: g_retcode := 2;
2115: return;

Line 2146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

2142:
2143: BEGIN
2144:
2145: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2146: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
2147: G_PKG_NAME||': ' ||l_api_name||'()+');
2148: END IF;
2149:
2150:

Line 2172: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving main establishment flag');

2168: WHEN OTHERS THEN
2169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving main establishment flag');
2170: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2171: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2172: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving main establishment flag');
2173: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2174: END IF;
2175: END;
2176:

Line 2173: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2169: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving main establishment flag');
2170: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2171: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2172: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving main establishment flag');
2173: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2174: END IF;
2175: END;
2176:
2177: IF l_main_estb_flag = 'N' THEN -- running the report for secondary establishment. need to display LE info in 0020 register.

Line 2199: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge_city_code');

2195: WHEN OTHERS THEN
2196: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge_city_code');
2197: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2198: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge_city_code');
2200: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2201: END IF;
2202: END;
2203:

Line 2200: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2196: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge_city_code');
2197: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2198: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2199: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state and ibge_city_code');
2200: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2201: END IF;
2202: END;
2203:
2204: BEGIN -- retrieving cnpj

Line 2225: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');

2221: WHEN OTHERS THEN
2222: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while Retrieving cnpj of LE');
2223: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2224: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');
2226: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2227: END IF;
2228: END;
2229:

Line 2226: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2222: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while Retrieving cnpj of LE');
2223: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2224: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2225: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving cnpj');
2226: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2227: END IF;
2228: END;
2229:
2230: --Begin for retrieving NIRE.

Line 2258: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');

2254:
2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2258: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');
2259: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2260: END IF;
2261: END;
2262: ELSE

Line 2259: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2255: EXCEPTION
2256: WHEN OTHERS THEN
2257: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2258: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');
2259: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2260: END IF;
2261: END;
2262: ELSE
2263:

Line 2280: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');

2276:
2277: EXCEPTION
2278: WHEN OTHERS THEN
2279: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2280: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');
2281: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2282: END IF;
2283: END;
2284:

Line 2281: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2277: EXCEPTION
2278: WHEN OTHERS THEN
2279: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2280: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');
2281: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2282: END IF;
2283: END;
2284:
2285: END IF;

Line 2306: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');

2302:
2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2306: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');
2307: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2308: END IF;
2309: END;
2310: BEGIN -- --Retrieving municipal inscription

Line 2307: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2303: EXCEPTION
2304: WHEN OTHERS THEN
2305: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2306: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription');
2307: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2308: END IF;
2309: END;
2310: BEGIN -- --Retrieving municipal inscription
2311: SELECT registration_number

Line 2325: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');

2321: AND rownum =1;
2322: EXCEPTION
2323: WHEN OTHERS THEN
2324: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2325: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');
2326: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2327: END IF;
2328: END;
2329: ELSE -- g_inscription_source ='EBTax'('ZX')

Line 2326: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2322: EXCEPTION
2323: WHEN OTHERS THEN
2324: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2325: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription');
2326: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2327: END IF;
2328: END;
2329: ELSE -- g_inscription_source ='EBTax'('ZX')
2330:

Line 2352: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');

2348: AND rownum =1;
2349: EXCEPTION
2350: WHEN OTHERS THEN
2351: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2352: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
2353: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2354: END IF;
2355: END;
2356:

Line 2353: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2349: EXCEPTION
2350: WHEN OTHERS THEN
2351: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2352: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
2353: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2354: END IF;
2355: END;
2356:
2357: BEGIN -- retreive municipal inscription

Line 2378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');

2374: AND rownum =1;
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');
2379: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2380: END IF;
2381: END;
2382:

Line 2379: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');
2379: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2380: END IF;
2381: END;
2382:
2383: END IF; -- END for p_insciption_source='XLE'

Line 2442: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2438: WHEN OTHERS THEN
2439: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Inserting data into 0020 register');
2440: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2441: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2442: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2443: END IF;
2444: g_errbuf := 'ERROR While inserting 0020 register '||SQLERRM;
2445: g_retcode := 2;
2446: return;

Line 2461: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Establishment_id : '||l_establishment_id);

2457: l_cnpj := null;
2458: l_nire := null;
2459:
2460: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2461: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Establishment_id : '||l_establishment_id);
2462: END IF;
2463:
2464: BEGIN
2465: --retrieving cnpj,state,ibge_city_code

Line 2484: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state,ibge_city_code of ESTB');

2480: WHEN OTHERS THEN
2481: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge_city_code');
2482: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2483: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2484: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state,ibge_city_code of ESTB');
2485: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2486: END IF;
2487: END;
2488:

Line 2485: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2481: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving state and ibge_city_code');
2482: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2483: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2484: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state,ibge_city_code of ESTB');
2485: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2486: END IF;
2487: END;
2488:
2489: --Begin for retrieving NIRE.

Line 2517: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');

2513:
2514: EXCEPTION
2515: WHEN OTHERS THEN
2516: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');
2518: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2519: END IF;
2520: END;
2521: ELSE

Line 2518: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2514: EXCEPTION
2515: WHEN OTHERS THEN
2516: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2517: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');
2518: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2519: END IF;
2520: END;
2521: ELSE
2522:

Line 2539: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');

2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2539: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');
2540: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2541: END IF;
2542: END;
2543:

Line 2540: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2539: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');
2540: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2541: END IF;
2542: END;
2543:
2544: END IF;

Line 2568: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while Retrieving cnpj of ESTB');

2564: WHEN OTHERS THEN
2565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while Retrieving cnpj of ESTB');
2566: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2567: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2568: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while Retrieving cnpj of ESTB');
2569: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2570: END IF;
2571: END;
2572:

Line 2569: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2565: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error while Retrieving cnpj of ESTB');
2566: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2567: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2568: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while Retrieving cnpj of ESTB');
2569: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2570: END IF;
2571: END;
2572:
2573:

Line 2593: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription of ESTB from XLE');

2589:
2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2593: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription of ESTB from XLE');
2594: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2595: END IF;
2596: END;
2597: BEGIN --Retrieving municipal inscription

Line 2594: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2590: EXCEPTION
2591: WHEN OTHERS THEN
2592: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2593: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving state inscription of ESTB from XLE');
2594: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2595: END IF;
2596: END;
2597: BEGIN --Retrieving municipal inscription
2598: SELECT registration_number

Line 2612: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription of ESTB from XLE');

2608: AND rownum=1;
2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2612: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription of ESTB from XLE');
2613: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2614: END IF;
2615: END;
2616: ELSE -- g_inscription_source ='EBTax'('ZX')

Line 2613: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2612: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving municipal inscription of ESTB from XLE');
2613: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2614: END IF;
2615: END;
2616: ELSE -- g_inscription_source ='EBTax'('ZX')
2617:

Line 2637: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');

2633: AND rownum =1;
2634: EXCEPTION
2635: WHEN OTHERS THEN
2636: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2637: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
2638: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2639: END IF;
2640: END;
2641:

Line 2638: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2634: EXCEPTION
2635: WHEN OTHERS THEN
2636: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2637: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving State inscription for EBTax');
2638: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2639: END IF;
2640: END;
2641:
2642: BEGIN -- retreive municipal inscription

Line 2661: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');

2657: AND rownum =1;
2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2661: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');
2662: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2663: END IF;
2664: END;
2665:

Line 2662: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2661: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error in retreiving municipal inscription for EBTax');
2662: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2663: END IF;
2664: END;
2665:
2666: END IF; -- END for p_insciption_source='XLE'

Line 2725: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2721: WHEN OTHERS THEN
2722: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Inserting data into 0020 register-establishments');
2723: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
2724: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2725: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2726: END IF;
2727: g_errbuf := 'ERROR While inserting 0020 register '||SQLERRM;
2728: g_retcode := 2;
2729: return;

Line 2737: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

2733: END IF; -- End for l_main_estb_flag = 'N'
2734:
2735:
2736: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2737: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2738: G_PKG_NAME||': ' ||l_api_name||'()-');
2739: END IF;
2740:
2741: END register_0020;

Line 2788: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

2784:
2785: IF g_bookkeeping_type <> 'B' THEN -- 0150 and 0180 are not required for book keeping type 'B'
2786:
2787: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2788: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
2789: G_PKG_NAME||': '||l_api_name||'()+');
2790: END IF;
2791:
2792: For partic_record in c_participants LOOP

Line 2924: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

2920: AND field1 = '0180';
2921: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): 0180 Records Inserted : '||l_count);
2922:
2923: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2924: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2925: G_PKG_NAME||': ' ||l_api_name||'()-');
2926: END IF;
2927:
2928: END IF; -- End for IF g_bookkeeping_type <> 'B'

Line 2938: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2934: IF g_debug_flag = 'Y' THEN
2935: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2936: END IF;
2937: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2938: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2939: END IF;
2940: g_errbuf := 'ERROR While inserting 0150 and 0180 register '||SQLERRM;
2941: g_retcode := 2;
2942: return;

Line 2950: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

2946: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_0990';
2947: BEGIN
2948:
2949: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2950: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
2951: G_PKG_NAME||': '||l_api_name||'()+');
2952: END IF;
2953: INSERT INTO jl_br_sped_extr_data_t
2954: (request_id,

Line 2983: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

2979:
2980: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
2981:
2982: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2983: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
2984: G_PKG_NAME||': ' ||l_api_name||'()-');
2985: END IF;
2986: EXCEPTION
2987: WHEN OTHERS THEN

Line 2994: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

2990: IF g_debug_flag = 'Y' THEN
2991: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2992: END IF;
2993: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
2994: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
2995: END IF;
2996: g_errbuf := 'ERROR While inserting 0990 register '||SQLERRM;
2997: g_retcode := 2;
2998: return;

Line 3006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3002: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I001';
3003: BEGIN
3004:
3005: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3006: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3007: G_PKG_NAME||': '||l_api_name||'()+');
3008: END IF;
3009:
3010: INSERT INTO jl_br_sped_extr_data_t

Line 3039: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

3035:
3036: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
3037:
3038: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3039: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3040: G_PKG_NAME||': ' ||l_api_name||'()-');
3041: END IF;
3042: EXCEPTION
3043: WHEN OTHERS THEN

Line 3049: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3045: IF g_debug_flag = 'Y' THEN
3046: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3047: END IF;
3048: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3049: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3050: END IF;
3051: g_errbuf := 'ERROR While inserting I0001 register '||SQLERRM;
3052: g_retcode := 2;
3053: return;

Line 3062: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3058: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I010';
3059: BEGIN
3060:
3061: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3062: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3063: G_PKG_NAME||': '||l_api_name||'()+');
3064: END IF;
3065: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'G_BOOKKEEPING_TYPE: ' ||g_bookkeeping_type);
3066:

Line 3101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

3097: );
3098: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
3099:
3100: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3102: G_PKG_NAME||': ' ||l_api_name||'()-');
3103: END IF;
3104: EXCEPTION
3105: WHEN OTHERS THEN

Line 3112: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3108: IF g_debug_flag = 'Y' THEN
3109: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3110: END IF;
3111: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3112: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3113: END IF;
3114: g_errbuf := 'ERROR While inserting I010 register '||SQLERRM;
3115: g_retcode := 2;
3116: return;

Line 3128: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3124:
3125: IF g_bookkeeping_type <> 'G' THEN
3126:
3127: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3128: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3129: G_PKG_NAME||': '||l_api_name||'()+');
3130: END IF;
3131:
3132: INSERT INTO jl_br_sped_extr_data_t

Line 3187: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

3183:
3184: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
3185:
3186: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3187: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3188: G_PKG_NAME||': ' ||l_api_name||'()-');
3189: END IF;
3190: END IF; -- End for IF g_bookkeeping_type <> 'G'
3191: EXCEPTION

Line 3199: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3195: IF g_debug_flag = 'Y' THEN
3196: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3197: END IF;
3198: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3199: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3200: END IF;
3201: g_errbuf := 'ERROR While inserting I012 register '||SQLERRM;
3202: g_retcode := 2;
3203: return;

Line 3217: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3213: return;
3214: END IF;
3215:
3216: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3217: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3218: G_PKG_NAME||': '||l_api_name||'()+');
3219: END IF;
3220:
3221: l_query := 'INSERT INTO jl_br_sped_extr_data_t

Line 3285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

3281:
3282: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
3283:
3284: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3286: G_PKG_NAME||': ' ||l_api_name||'()-');
3287: END IF;
3288:
3289:

Line 3297: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3293: IF g_debug_flag = 'Y' THEN
3294: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3295: END IF;
3296: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3297: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3298: END IF;
3299: g_errbuf := 'ERROR While inserting I015 register '||SQLERRM;
3300: g_retcode := 2;
3301: return;

Line 3319: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3315:
3316: BEGIN
3317:
3318: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3319: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3320: G_PKG_NAME||': ' ||l_api_name||'()+');
3321: END IF;
3322:
3323: IF l_estb_acts_as_company = 'N' THEN --LE acts as company.

Line 3342: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving the Book Information');

3338: WHEN OTHERS THEN
3339: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving the Book Information');
3340: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3341: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3342: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving the Book Information');
3343: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3344: END IF;
3345: END;
3346:

Line 3343: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3339: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving the Book Information');
3340: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3341: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3342: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving the Book Information');
3343: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3344: END IF;
3345: END;
3346:
3347: --Begin for retrieving NIRE.

Line 3377: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');

3373: WHEN OTHERS THEN
3374: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving nire using place of registration');
3375: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3376: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');
3378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3379: END IF;
3380: END;
3381: ELSE

Line 3378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3374: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving nire using place of registration');
3375: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3376: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using place of registration');
3378: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3379: END IF;
3380: END;
3381: ELSE
3382:

Line 3401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');

3397: WHEN OTHERS THEN
3398: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving nire using Commercial Law');
3399: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3400: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');
3402: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3403: END IF;
3404: END;
3405:

Line 3402: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3398: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving nire using Commercial Law');
3399: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3400: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3401: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving nire using Commercial Law');
3402: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3403: END IF;
3404: END;
3405:
3406: END IF;

Line 3425: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3421: WHEN OTHERS THEN
3422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving CNPJ');
3423: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3424: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3425: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3426: END IF;
3427: END;
3428:
3429: BEGIN -- retrieving cnpj

Line 3450: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3446: WHEN OTHERS THEN
3447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');
3448: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3449: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3450: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3451: END IF;
3452: END;
3453:
3454: l_count :=0;

Line 3479: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving conversion Date');

3475: WHEN OTHERS THEN
3476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving conversion Date');
3477: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3478: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3479: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving conversion Date');
3480: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3481: END IF;
3482: END;
3483:

Line 3480: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3476: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving conversion Date');
3477: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3478: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3479: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving conversion Date');
3480: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3481: END IF;
3482: END;
3483:
3484: END IF; --End for IF l_count >=1

Line 3506: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3502: WHEN OTHERS THEN
3503: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving the Book Information');
3504: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3505: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3506: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3507: END IF;
3508: END;
3509:
3510: --Begin for retrieving NIRE.

Line 3540: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3536: WHEN OTHERS THEN
3537: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving nire using place of registration');
3538: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3539: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3540: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3541: END IF;
3542: END;
3543: ELSE
3544:

Line 3563: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3559: WHEN OTHERS THEN
3560: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving nire using Commercial Law');
3561: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3562: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3563: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3564: END IF;
3565: END;
3566:
3567: END IF;

Line 3586: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3582: WHEN OTHERS THEN
3583: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving CNPJ');
3584: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3585: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3586: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3587: END IF;
3588: END;
3589: BEGIN -- retrieving cnpj
3590:

Line 3610: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3606: WHEN OTHERS THEN
3607: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving cnpj');
3608: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3609: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3610: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3611: END IF;
3612: END;
3613:
3614: l_count :=0;

Line 3639: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving conversion Date');

3635: WHEN OTHERS THEN
3636: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving conversion Date');
3637: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3638: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3639: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving conversion Date');
3640: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3641: END IF;
3642: END;
3643:

Line 3640: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3636: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Retrieving conversion Date');
3637: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3638: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3639: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While Retrieving conversion Date');
3640: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3641: END IF;
3642: END;
3643:
3644: END IF; -- End for l_count >=1

Line 3717: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3713: WHEN OTHERS THEN
3714: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Inserting Data into I030 register');
3715: FND_FILE.PUT_LINE(FND_FILE.LOG,SQLERRM);
3716: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3717: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3718: END IF;
3719: g_errbuf := 'ERROR While inserting 0000 register '||SQLERRM;
3720: g_retcode := 2;
3721: return;

Line 3724: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

3720: g_retcode := 2;
3721: return;
3722: END;
3723: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3724: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
3725: G_PKG_NAME||': ' ||l_api_name||'()-');
3726: END IF;
3727:
3728: END register_I030;

Line 3776: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

3772:
3773: BEGIN
3774:
3775: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3776: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
3777: G_PKG_NAME||': '||l_api_name||'()+');
3778: END IF;
3779:
3780: FND_FILE.put_line(fnd_file.log,'Start Of I050');

Line 3837: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'I050-Query',l_query);

3833: ' AND b.flex_value >= a.child_flex_value_low
3834: AND b.flex_value <= a.child_flex_value_high))';
3835:
3836: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3837: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'I050-Query',l_query);
3838: END IF;
3839:
3840:
3841: --FND_FILE.put_line(fnd_file.log,l_query);

Line 3893: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

3889: IF g_debug_flag = 'Y' THEN
3890: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3891: END IF;
3892: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3893: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
3894: END IF;
3895: g_errbuf := 'ERROR While deleting the parent accounts in I050 register '||SQLERRM;
3896: g_retcode := 2;
3897: return;

Line 3929: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR in I050, While getting level 1 parent information Flex Value := '||fv_parent_value(i)||' '||SQLERRM);

3925: IF g_debug_flag = 'Y' THEN
3926: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
3927: END IF;
3928: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
3929: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR in I050, While getting level 1 parent information Flex Value := '||fv_parent_value(i)||' '||SQLERRM);
3930: END IF;
3931: g_errbuf := 'ERROR in I050, While getting level 1 parent information Flex Value := '||fv_parent_value(i)||' '||SQLERRM;
3932: g_retcode := 2;
3933: return;

Line 4061: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4057:
4058: END LOOP;
4059: END IF; -- IF fv_id.COUNT > 0 THEN
4060: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4061: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4062: G_PKG_NAME||': ' ||l_api_name||'()-');
4063: END IF;
4064:
4065: EXCEPTION

Line 4073: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4069: IF g_debug_flag = 'Y' THEN
4070: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4071: END IF;
4072: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4073: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4074: END IF;
4075: g_errbuf := 'ERROR While inserting I050 register '||SQLERRM;
4076: g_retcode := 2;
4077: return;

Line 4094: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4090: RETURN;
4091: END IF;
4092:
4093: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4094: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4095: G_PKG_NAME||': '||l_api_name||'()+');
4096: END IF;
4097:
4098: -- fnd_file.put_line(fnd_file.log,'Felx value :'||p_account_flex_value||' G_coa_maping_id :'||g_coa_mapping_id);

Line 4121: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4117: IF g_debug_flag = 'Y' THEN
4118: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4119: END IF;
4120: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4121: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4122: END IF;
4123: g_errbuf := 'ERROR While finding Number of referential chart of accounts associated for an account in I051 register '||SQLERRM;
4124: g_retcode := 2;
4125: return;

Line 4155: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4151: IF g_debug_flag = 'Y' THEN
4152: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4153: END IF;
4154: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4155: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4156: END IF;
4157: g_errbuf := 'ERROR While finding referential chart of accounts mapping in I051 register '||SQLERRM;
4158: g_retcode := 2;
4159: return;

Line 4188: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Data Found for Entity_RESP_REFERENTIAL_COA -'||SQLERRM);

4184:
4185: EXCEPTION
4186: WHEN NO_DATA_FOUND THEN
4187: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4188: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'No Data Found for Entity_RESP_REFERENTIAL_COA -'||SQLERRM);
4189: END IF;
4190: l_institution_resp_code := NULL; -- verify
4191: WHEN OTHERS THEN
4192: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 4197: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4193: IF g_debug_flag = 'Y' THEN
4194: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4195: END IF;
4196: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4197: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4198: END IF;
4199: g_errbuf := 'ERROR While finding institution responsibility code in I051 register '||SQLERRM;
4200: g_retcode := 2;
4201: return;

Line 4244: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4240:
4241: END IF; --END for IF l_referential_account IS NOT NULL THEN
4242:
4243: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4244: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4245: G_PKG_NAME||': ' ||l_api_name||'()-');
4246: END IF;
4247: EXCEPTION
4248: WHEN OTHERS THEN

Line 4255: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4251: IF g_debug_flag = 'Y' THEN
4252: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4253: END IF;
4254: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4255: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4256: END IF;
4257: g_errbuf := 'ERROR While inserting data into I051 register '||SQLERRM;
4258: g_retcode := 2;
4259: return;

Line 4274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4270: RETURN;
4271: END IF;
4272:
4273: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4275: G_PKG_NAME||': '||l_api_name||'()+');
4276: END IF;
4277:
4278:

Line 4380: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4376: EXECUTE IMMEDIATE sql_stmt using p_account_flex_value,p_account_flex_value;
4377:
4378:
4379: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4380: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4381: G_PKG_NAME||': ' ||l_api_name||'()-');
4382: END IF;
4383:
4384: EXCEPTION

Line 4392: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4388: IF g_debug_flag = 'Y' THEN
4389: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4390: END IF;
4391: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4392: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4393: END IF;
4394: g_errbuf := 'ERROR While inserting data into I052 register '||SQLERRM;
4395: g_retcode := 2;
4396: return;

Line 4405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4401: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I100';
4402: l_query VARCHAR2(6000);
4403: BEGIN
4404: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4406: G_PKG_NAME||': '||l_api_name||'()+');
4407: END IF;
4408:
4409: -- FND_FILE.PUT_LINE(FND_FILE.LOG,' in register I100');

Line 4462: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4458:
4459: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
4460:
4461: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4462: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4463: G_PKG_NAME||': ' ||l_api_name||'()-');
4464: END IF;
4465:
4466: EXCEPTION

Line 4473: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4469: IF g_debug_flag = 'Y' THEN
4470: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4471: END IF;
4472: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4473: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4474: END IF;
4475: g_errbuf := 'ERROR While inserting data into I100 register '||SQLERRM;
4476: g_retcode := 2;
4477: return;

Line 4487: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4483: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I150';
4484: BEGIN
4485:
4486: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4487: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4488: G_PKG_NAME||': ' ||l_api_name||'()+');
4489: END IF;
4490:
4491: INSERT INTO jl_br_sped_extr_data_t

Line 4526: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4522:
4523: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
4524:
4525: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4526: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4527: G_PKG_NAME||': ' ||l_api_name||'()-');
4528: END IF;
4529:
4530: EXCEPTION

Line 4538: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4534: IF g_debug_flag = 'Y' THEN
4535: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4536: END IF;
4537: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4538: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4539: END IF;
4540: g_errbuf := 'ERROR While inserting data into I150 register '||SQLERRM;
4541: g_retcode := 2;
4542: return;

Line 4551: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4547: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I151';
4548: BEGIN
4549:
4550: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4551: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4552: G_PKG_NAME||': ' ||l_api_name||'()+');
4553: END IF;
4554:
4555: INSERT INTO jl_br_sped_extr_data_t

Line 4584: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4580:
4581: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
4582:
4583: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4584: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4585: G_PKG_NAME||': ' ||l_api_name||'()-');
4586: END IF;
4587:
4588: EXCEPTION

Line 4596: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4592: IF g_debug_flag = 'Y' THEN
4593: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4594: END IF;
4595: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4596: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4597: END IF;
4598: g_errbuf := 'ERROR While inserting data into I151 register '||SQLERRM;
4599: g_retcode := 2;
4600: return;

Line 4610: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4606:
4607: BEGIN
4608:
4609: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4610: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4611: G_PKG_NAME||': '||l_api_name||'()+');
4612: END IF;
4613:
4614:

Line 4866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4862:
4863: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
4864:
4865: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4867: G_PKG_NAME||': ' ||l_api_name||'()-');
4868: END IF;
4869:
4870: EXCEPTION

Line 4878: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4874: IF g_debug_flag = 'Y' THEN
4875: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
4876: END IF;
4877: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
4878: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4879: END IF;
4880: g_errbuf := 'ERROR While inserting data into I155 register '||SQLERRM;
4881: g_retcode := 2;
4882: return;

Line 4926: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

4922: END IF;
4923:
4924:
4925: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4926: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
4927: G_PKG_NAME||': '||l_api_name||'()+');
4928: END IF;
4929:
4930: FOR c_journal_header in c_journals LOOP

Line 4990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

4986:
4987: END LOOP;
4988:
4989: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4990: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
4991: G_PKG_NAME||': ' ||l_api_name||'()-');
4992: END IF;
4993:
4994:

Line 5003: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

4999: IF g_debug_flag = 'Y' THEN
5000: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5001: END IF;
5002: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5003: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5004: END IF;
5005: g_errbuf := 'ERROR While inserting data into I200 register '||SQLERRM;
5006: g_retcode := 2;
5007: return;

Line 5030: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Journal Header : '||p_journal_header_id||' Journal Source : '||p_journal_source);

5026: BEGIN
5027:
5028:
5029: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5030: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Journal Header : '||p_journal_header_id||' Journal Source : '||p_journal_source);
5031: END IF;
5032:
5033: IF SUBSTR(g_bookkeeping_type,1,1) <> 'A' OR (p_journal_source='Payables' AND g_ap_ar_auxbook_exist=0)
5034: OR (p_journal_source='Receivables' AND g_ap_ar_auxbook_exist=0)

Line 5167: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While inserting data into I250 register for the Header Id :'||p_journal_header_id);

5163:
5164: EXCEPTION
5165: WHEN OTHERS THEN
5166: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5167: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While inserting data into I250 register for the Header Id :'||p_journal_header_id);
5168: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5169: END IF;
5170: END;
5171: ELSE -- If g_bookkeeping_type = 'A/R' or 'A/B' and auxiliary book exists.

Line 5168: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5164: EXCEPTION
5165: WHEN OTHERS THEN
5166: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5167: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While inserting data into I250 register for the Header Id :'||p_journal_header_id);
5168: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5169: END IF;
5170: END;
5171: ELSE -- If g_bookkeeping_type = 'A/R' or 'A/B' and auxiliary book exists.
5172:

Line 5323: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While inserting data into I250 register for the Header Id :'||p_journal_header_id);

5319:
5320: EXCEPTION
5321: WHEN OTHERS THEN
5322: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5323: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While inserting data into I250 register for the Header Id :'||p_journal_header_id);
5324: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5325: END IF;
5326: END;
5327:

Line 5324: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5320: EXCEPTION
5321: WHEN OTHERS THEN
5322: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5323: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While inserting data into I250 register for the Header Id :'||p_journal_header_id);
5324: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5325: END IF;
5326: END;
5327:
5328: END IF; --End for substr(Bookkeeping_type,1,1) <> 'A' ..

Line 5364: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5360: END IF;
5361:
5362:
5363: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5364: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5365: G_PKG_NAME||': '||l_api_name||'()+');
5366: END IF;
5367:
5368:

Line 5478: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

5474:
5475: END LOOP;
5476:
5477: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5478: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
5479: G_PKG_NAME||': ' ||l_api_name||'()-');
5480: END IF;
5481:
5482: EXCEPTION

Line 5490: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5486: IF g_debug_flag = 'Y' THEN
5487: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5488: END IF;
5489: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5490: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5491: END IF;
5492: g_errbuf := 'ERROR While inserting into I300 and I310 registers '||SQLERRM;
5493: g_retcode := 2;
5494: return;

Line 5511: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5507: RETURN;
5508: END IF;
5509:
5510: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5511: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5512: G_PKG_NAME||': '||l_api_name||'()+');
5513: END IF;
5514:
5515:

Line 5547: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

5543:
5544: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
5545:
5546: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5547: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
5548: G_PKG_NAME||': ' ||l_api_name||'()-');
5549: END IF;
5550:
5551: EXCEPTION

Line 5559: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5555: IF g_debug_flag = 'Y' THEN
5556: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5557: END IF;
5558: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5559: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5560: END IF;
5561: g_errbuf := 'ERROR While inserting into I350 register '||SQLERRM;
5562: g_retcode := 2;
5563: return;

Line 5584: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5580: RETURN;
5581: END IF;
5582:
5583: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5584: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5585: G_PKG_NAME||': '||l_api_name||'()+');
5586: END IF;
5587:
5588: IF g_adjustment_period_name IS NOT NULL THEN -- It will be true always. so is this check require???

Line 5660: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

5656:
5657: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'After execution of dynamic query');
5658:
5659: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5660: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
5661: G_PKG_NAME||': ' ||l_api_name||'()-');
5662: END IF;
5663:
5664: EXCEPTION

Line 5672: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5668: IF g_debug_flag = 'Y' THEN
5669: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5670: END IF;
5671: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5672: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5673: END IF;
5674: g_errbuf := 'ERROR While inserting data into I355 register'||SQLERRM;
5675: g_retcode := 2;
5676: return;

Line 5686: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5682:
5683: BEGIN
5684:
5685: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5686: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5687: G_PKG_NAME||': '||l_api_name||'()+');
5688: END IF;
5689:
5690: INSERT INTO jl_br_sped_extr_data_t

Line 5719: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

5715:
5716: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
5717:
5718: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5719: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
5720: G_PKG_NAME||': ' ||l_api_name||'()-');
5721: END IF;
5722:
5723: EXCEPTION

Line 5731: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5727: IF g_debug_flag = 'Y' THEN
5728: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5729: END IF;
5730: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5731: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5732: END IF;
5733: g_errbuf := 'ERROR While inserting data into I990 registers '||SQLERRM;
5734: g_retcode := 2;
5735: return;

Line 5744: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5740:
5741: BEGIN
5742:
5743: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5744: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5745: G_PKG_NAME||': '||l_api_name||'()+');
5746: END IF;
5747:
5748: INSERT INTO jl_br_sped_extr_data_t

Line 5777: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

5773:
5774: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
5775:
5776: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5777: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
5778: G_PKG_NAME||': ' ||l_api_name||'()-');
5779: END IF;
5780:
5781: EXCEPTION

Line 5789: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5785: IF g_debug_flag = 'Y' THEN
5786: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5787: END IF;
5788: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5789: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5790: END IF;
5791: g_errbuf := 'ERROR While inserting data into J001 register'||SQLERRM;
5792: g_retcode := 2;
5793: return;

Line 5813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5809:
5810: IF g_bookkeeping_type = 'G' OR g_bookkeeping_type = 'R' OR g_bookkeeping_type = 'B' THEN
5811:
5812: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5814: G_PKG_NAME||': '||l_api_name||'()+');
5815: END IF;
5816:
5817: INSERT INTO jl_br_sped_extr_data_t

Line 5858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

5854:
5855: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
5856:
5857: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5858: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
5859: G_PKG_NAME||': ' ||l_api_name||'()-');
5860: END IF;
5861:
5862: END IF; -- END for checking on book keeping type

Line 5872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

5868: IF g_debug_flag = 'Y' THEN
5869: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
5870: END IF;
5871: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
5872: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
5873: END IF;
5874: g_errbuf := 'ERROR While inserting data into J001 register'||SQLERRM;
5875: g_retcode := 2;
5876: return;

Line 5932: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

5928: RETURN;
5929: END IF;
5930:
5931: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5932: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
5933: G_PKG_NAME||': '||l_api_name||'()+');
5934: END IF;
5935:
5936: SELECT row_set_id

Line 5944: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

5940:
5941: l_icx_num_format := NVL(fnd_profile.value('ICX_NUMERIC_CHARACTERS'),',.');
5942:
5943: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5944: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
5945: G_PKG_NAME||': ' ||l_api_name||'(): ICX Numeric Format: '||l_icx_num_format);
5946: END IF;
5947:
5948:

Line 6167: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6163: AND field1 ='J100'
6164: AND field4 = '0'; --field4=0 means all the accounts in the specified account assignments are of not same acct type.
6165:
6166: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6167: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6168: G_PKG_NAME||': '||l_api_name||'()-');
6169: END IF;
6170:
6171: EXCEPTION

Line 6179: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6175: IF g_debug_flag = 'Y' THEN
6176: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6177: END IF;
6178: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6179: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6180: END IF;
6181: g_errbuf := 'ERROR While processing data Of J100 register '||SQLERRM;
6182: g_retcode := 2;
6183: return;

Line 6212: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6208: RETURN;
6209: END IF;
6210:
6211: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6212: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6213: G_PKG_NAME||': '||l_api_name||'()+');
6214: END IF;
6215:
6216: SELECT row_set_id

Line 6224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

6220:
6221: l_icx_num_format :=fnd_profile.value('ICX_NUMERIC_CHARACTERS');
6222:
6223: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6224: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
6225: G_PKG_NAME||': ' ||l_api_name||'(): ICX Numeric Format: '||l_icx_num_format);
6226: END IF;
6227:
6228: /* SELECT fmt

Line 6344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6340:
6341: END LOOP;
6342:
6343: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6344: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6345: G_PKG_NAME||': '||l_api_name||'()-');
6346: END IF;
6347:
6348: EXCEPTION

Line 6356: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6352: IF g_debug_flag = 'Y' THEN
6353: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6354: END IF;
6355: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6356: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6357: END IF;
6358: g_errbuf := 'ERROR While processing data Of J150 register'||SQLERRM;
6359: g_retcode := 2;
6360: return;

Line 6394: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6390:
6391: IF g_bookkeeping_type = 'G' OR g_bookkeeping_type = 'R' OR g_bookkeeping_type = 'B' THEN
6392:
6393: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6394: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6395: G_PKG_NAME||': '||l_api_name||'()+');
6396: END IF;
6397:
6398: FOR l_file_ids_rec IN file_ids_cur(g_journal_for_rtf) LOOP

Line 6418: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6414: IF g_debug_flag = 'Y' THEN
6415: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6416: END IF;
6417: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6418: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6419: END IF;
6420: END;
6421:
6422: l_data_length := DBMS_LOB.GETLENGTH(l_lob_data); --getting the total length of rtf file

Line 6470: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6466: END LOOP; -- for while
6467: END LOOP; -- for cursor loop
6468:
6469: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6470: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6471: G_PKG_NAME||': ' ||l_api_name||'()-');
6472: END IF;
6473:
6474: END IF; -- End for book keeping type checking

Line 6483: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6479: IF g_debug_flag = 'Y' THEN
6480: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6481: END IF;
6482: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6483: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6484: END IF;
6485: g_errbuf := 'ERROR While inserting data into J800 register'||SQLERRM;
6486: g_retcode := 2;
6487: return;

Line 6500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6496: l_company_name VARCHAR2(200);
6497: BEGIN
6498:
6499: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6501: G_PKG_NAME||': '||l_api_name||'()+');
6502: END IF;
6503:
6504: SELECT SUBSTR(meaning,1,80)

Line 6530: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6526: IF g_debug_flag = 'Y' THEN
6527: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6528: END IF;
6529: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6530: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6531: END IF;
6532: END;
6533:
6534:

Line 6590: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6586:
6587: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
6588:
6589: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6590: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6591: G_PKG_NAME||': ' ||l_api_name||'()-');
6592: END IF;
6593:
6594: EXCEPTION

Line 6602: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6598: IF g_debug_flag = 'Y' THEN
6599: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6600: END IF;
6601: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6602: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6603: END IF;
6604: g_errbuf := 'ERROR While inserting data into J900 register'||SQLERRM;
6605: g_retcode := 2;
6606: return;

Line 6618: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6614: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_J930';
6615: BEGIN
6616:
6617: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6618: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6619: G_PKG_NAME||': '||l_api_name||'()+');
6620: END IF;
6621:
6622: IF ((upper(g_accounting_type) = 'CENTRALIZED' AND g_establishment_id is null) --LE is the company

Line 6736: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6732: and lk.lookup_type = crole.lookup_type
6733: and lk.lookup_code = crole.lookup_code;
6734:
6735: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6736: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6737: G_PKG_NAME||': ' ||l_api_name||'()-');
6738: END IF;
6739: END IF;
6740:

Line 6749: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6745: IF g_debug_flag = 'Y' THEN
6746: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6747: END IF;
6748: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6749: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6750: END IF;
6751: g_errbuf := 'ERROR While inserting data into J930 register'||SQLERRM;
6752: g_retcode := 2;
6753: return;

Line 6763: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6759:
6760: BEGIN
6761:
6762: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6763: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6764: G_PKG_NAME||': '||l_api_name||'()+');
6765: END IF;
6766:
6767: INSERT INTO jl_br_sped_extr_data_t

Line 6796: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6792:
6793: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
6794:
6795: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6796: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6797: G_PKG_NAME||': ' ||l_api_name||'()-');
6798: END IF;
6799:
6800: EXCEPTION

Line 6808: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6804: IF g_debug_flag = 'Y' THEN
6805: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6806: END IF;
6807: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6808: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6809: END IF;
6810: g_errbuf := 'ERROR While inserting data into J990 register'||SQLERRM;
6811: g_retcode := 2;
6812: return;

Line 6826: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6822:
6823: BEGIN
6824:
6825: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6826: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6827: G_PKG_NAME||': '||l_api_name||'()+');
6828: END IF;
6829:
6830: INSERT INTO jl_br_sped_extr_data_t

Line 6859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

6855:
6856: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
6857:
6858: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6859: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
6860: G_PKG_NAME||': ' ||l_api_name||'()-');
6861: END IF;
6862:
6863: EXCEPTION

Line 6871: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

6867: IF g_debug_flag = 'Y' THEN
6868: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
6869: END IF;
6870: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
6871: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
6872: END IF;
6873: g_errbuf := 'ERROR While inserting data into 9001 register'||SQLERRM;
6874: g_retcode := 2;
6875: return;

Line 6889: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

6885:
6886: BEGIN
6887:
6888: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6889: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
6890: G_PKG_NAME||': '||l_api_name||'()+');
6891: END IF;
6892:
6893: INSERT INTO jl_br_sped_extr_data_t

Line 7057: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

7053: g_last_update_login );
7054:
7055:
7056: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7057: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
7058: G_PKG_NAME||': ' ||l_api_name||'()-');
7059: END IF;
7060:
7061: EXCEPTION

Line 7069: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

7065: IF g_debug_flag = 'Y' THEN
7066: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
7067: END IF;
7068: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7069: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
7070: END IF;
7071: g_errbuf := 'ERROR While inserting data into 9900 register'||SQLERRM;
7072: g_retcode := 2;
7073: return;

Line 7084: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

7080:
7081: BEGIN
7082:
7083: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7084: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
7085: G_PKG_NAME||': '||l_api_name||'()+');
7086: END IF;
7087:
7088: INSERT INTO jl_br_sped_extr_data_t

Line 7117: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

7113:
7114: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
7115:
7116: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7117: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
7118: G_PKG_NAME||': ' ||l_api_name||'()-');
7119: END IF;
7120:
7121: EXCEPTION

Line 7129: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

7125: IF g_debug_flag = 'Y' THEN
7126: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
7127: END IF;
7128: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7129: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
7130: END IF;
7131: g_errbuf := 'ERROR While inserting data into 9990 register'||SQLERRM;
7132: g_retcode := 2;
7133: return;

Line 7145: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

7141:
7142: BEGIN
7143:
7144: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7145: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
7146: G_PKG_NAME||': '||l_api_name||'()+');
7147: END IF;
7148:
7149: INSERT INTO jl_br_sped_extr_data_t

Line 7178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

7174:
7175: -- FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'(): No of Records Inserted:' ||SQL%ROWCOUNT);
7176:
7177: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
7179: G_PKG_NAME||': ' ||l_api_name||'()-');
7180: END IF;
7181:
7182: EXCEPTION

Line 7190: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

7186: IF g_debug_flag = 'Y' THEN
7187: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
7188: END IF;
7189: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7190: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
7191: END IF;
7192: g_errbuf := 'ERROR While inserting data into 9999 register'||SQLERRM;
7193: g_retcode := 2;
7194: return;

Line 7203: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

7199: l_api_name CONSTANT VARCHAR2(30) :='UPDATE_REGISTER_CNT';
7200: BEGIN
7201:
7202: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7203: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
7204: G_PKG_NAME||': '||l_api_name||'()+');
7205: END IF;
7206:
7207: /*This procedure is to update the details about number of records inserted into sped temp table.

Line 7335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

7331:
7332: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Updated 9999 register');
7333:
7334: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
7336: G_PKG_NAME||': '||l_api_name||'()-');
7337: END IF;
7338:
7339: EXCEPTION

Line 7347: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

7343: IF g_debug_flag = 'Y' THEN
7344: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
7345: END IF;
7346: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7347: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
7348: END IF;
7349:
7350: END update_register_cnt;
7351:

Line 7601: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

7597:
7598: BEGIN
7599:
7600: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
7601: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
7602: G_PKG_NAME||': '||l_api_name||'()+');
7603: END IF;
7604: /*When the running the report in detail mode, Check if summary mode posted data exists or not?
7605: If summary data exists warn the user. If program is run for summary mode info check if detail data exists,If exists earn the user*/

Line 7705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

7701: END IF;
7702: END IF;
7703:
7704: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
7706: G_PKG_NAME||': ' ||l_api_name||'(): Validation for Journal''s Posting done ');
7707: END IF;
7708:
7709: BEGIN

Line 7782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

7778:
7779: END IF;
7780:
7781: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
7783: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_SOMA_SALDO_INICIAL'' was completed ');
7784: END IF;
7785:
7786: EXCEPTION

Line 7791: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_SOMA_SALDO_INICIAL'''||SQLERRM);

7787: WHEN NO_DATA_FOUND THEN
7788: null;
7789: WHEN OTHERS THEN
7790: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7791: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_SOMA_SALDO_INICIAL'''||SQLERRM);
7792: END IF;
7793: END;
7794:
7795: /*validation for REGRA_VALIDACAO_SOMA_SALDO_FINAL - Verifies if the sum of VL_SLD_FIN (Register I155)

Line 7848: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

7844: FND_MESSAGE.SET_NAME('JL','JLBR_SPED_SOMA_SALDO_FINAL');
7845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'REGRA_VALIDACAO_SOMA_SALDO_FINAL : '||FND_MESSAGE.GET);
7846: END IF;
7847: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7848: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
7849: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_SOMA_SALDO_FINAL'' was completed ');
7850: END IF;
7851:
7852: EXCEPTION

Line 7857: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_SOMA_SALDO_FINAL'''||SQLERRM);

7853: WHEN NO_DATA_FOUND THEN
7854: null;
7855: WHEN OTHERS THEN
7856: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7857: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_SOMA_SALDO_FINAL'''||SQLERRM);
7858: END IF;
7859: END;
7860:
7861:

Line 7916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

7912: ,g_last_update_login );
7913: END IF;
7914:
7915: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
7917: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_DEB_DIF_CRED'' was completed ');
7918: END IF;
7919:
7920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 7929: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_DEB_DIF_CRED'''||SQLERRM);

7925: WHEN NO_DATA_FOUND THEN
7926: null;
7927: WHEN OTHERS THEN
7928: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
7929: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_DEB_DIF_CRED'''||SQLERRM);
7930: END IF;
7931: END;
7932:
7933: END IF; --End for check on number of records existance for I155 register.

Line 8003: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

7999: END LOOP;
8000:
8001: END IF;
8002: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8003: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
8004: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_VALOR_DEB'' was completed ');
8005: END IF;
8006:
8007: EXCEPTION

Line 8012: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_VALOR_DEB'''||SQLERRM);

8008: WHEN NO_DATA_FOUND THEN
8009: null;
8010: WHEN OTHERS THEN
8011: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8012: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_VALOR_DEB'''||SQLERRM);
8013: END IF;
8014: END;
8015: /* validation for REGRA_VALIDACAO_VALOR_CRED*/
8016: /*journals total credits (month, account and cost center) should equal to monthly balance from gl_balances */

Line 8081: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

8077:
8078: END IF;
8079:
8080: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8081: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
8082: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_VALOR_CRED'' was completed ');
8083: END IF;
8084: EXCEPTION
8085: WHEN NO_DATA_FOUND THEN

Line 8089: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_VALIDACAO_VALOR_CRED'''||SQLERRM);

8085: WHEN NO_DATA_FOUND THEN
8086: null;
8087: WHEN OTHERS THEN
8088: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8089: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_VALIDACAO_VALOR_CRED'''||SQLERRM);
8090: END IF;
8091: END;
8092:
8093:

Line 8154: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

8150: END LOOP;
8151: END IF;
8152:
8153: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8154: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
8155: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_VL_LCTO_DEB'' was completed ');
8156: END IF;
8157:
8158: EXCEPTION

Line 8163: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_VL_LCTO_DEB'''||SQLERRM);

8159: WHEN NO_DATA_FOUND THEN
8160: null;
8161: WHEN OTHERS THEN
8162: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8163: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data for ''REGRA_VALIDACAO_VL_LCTO_DEB'''||SQLERRM);
8164: END IF;
8165: END;
8166: /* validation for REGRA_VALIDACAO_VL_LCTO_CRED */
8167:

Line 8228: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

8224:
8225: END IF;
8226:
8227: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8228: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
8229: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_VL_LCTO_CRED'' was completed ');
8230: END IF;
8231:
8232: EXCEPTION

Line 8237: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_VALIDACAO_VL_LCTO_CRED'''||SQLERRM);

8233: WHEN NO_DATA_FOUND THEN
8234: null;
8235: WHEN OTHERS THEN
8236: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8237: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_VALIDACAO_VL_LCTO_CRED'''||SQLERRM);
8238: END IF;
8239: END;
8240: END IF; --END IF for g_bookkeeping_type logic
8241: END IF; --END FOR IF g_bookkeeping_type <> 'B' THEN

Line 8309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

8305:
8306: END IF;
8307:
8308: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
8310: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_VALIDACAO_DC_BALANCETE'' was completed ');
8311: END IF;
8312: END IF;
8313: EXCEPTION

Line 8318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_VALIDACAO_DC_BALANCETE'''||SQLERRM);

8314: WHEN NO_DATA_FOUND THEN
8315: null;
8316: WHEN OTHERS THEN
8317: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8318: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_VALIDACAO_DC_BALANCETE'''||SQLERRM);
8319: END IF;
8320: END;
8321: END IF; -- END FOR IF g_bookkeeping_type = 'B' THEN
8322:

Line 8413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

8409: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'REGRA_OBRIGATORIO_ASSIN_CONTADOR : '||FND_MESSAGE.GET);
8410: END IF;
8411:
8412: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8413: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
8414: G_PKG_NAME||': ' ||l_api_name||'(): Validation for ''REGRA_OBRIGATORIO_ASSIN_CONTADOR'' was completed ');
8415: END IF;
8416:
8417: EXCEPTION

Line 8422: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_OBRIGATORIO_ASSIN_CONTADOR'''||SQLERRM);

8418: WHEN NO_DATA_FOUND THEN
8419: null;
8420: WHEN OTHERS THEN
8421: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8422: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'ERROR Occurred while validating extract data fpr ''REGRA_OBRIGATORIO_ASSIN_CONTADOR'''||SQLERRM);
8423: END IF;
8424: END; /* End for Validation for REGRA_OBRIGATORIO_ASSIN_CONTADOR */
8425:
8426: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 8427: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

8423: END IF;
8424: END; /* End for Validation for REGRA_OBRIGATORIO_ASSIN_CONTADOR */
8425:
8426: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8427: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
8428: G_PKG_NAME||': '||l_api_name||'()-');
8429: END IF;
8430:
8431: END validation_after_extract;

Line 8439: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',

8435: l_request_id NUMBER;
8436: l_api_name CONSTANT VARCHAR2(30) := 'purge_data';
8437: BEGIN
8438: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8439: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',
8440: G_PKG_NAME||': '||l_api_name||'()+');
8441: END IF;
8442:
8443: BEGIN

Line 8467: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

8463: WHEN NO_DATA_FOUND THEN
8464: l_request_id := 0;
8465: WHEN OTHERS THEN
8466: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8467: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
8468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'LE: '||g_legal_entity_id);
8469: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'ESTB'||g_establishment_id);
8470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Period: '||g_period_name);
8471: END IF;

Line 8468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'LE: '||g_legal_entity_id);

8464: l_request_id := 0;
8465: WHEN OTHERS THEN
8466: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8467: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
8468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'LE: '||g_legal_entity_id);
8469: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'ESTB'||g_establishment_id);
8470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Period: '||g_period_name);
8471: END IF;
8472: --l_request_id := 0;

Line 8469: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'ESTB'||g_establishment_id);

8465: WHEN OTHERS THEN
8466: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8467: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
8468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'LE: '||g_legal_entity_id);
8469: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'ESTB'||g_establishment_id);
8470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Period: '||g_period_name);
8471: END IF;
8472: --l_request_id := 0;
8473: g_errbuf := 'Error in finding the request_id to purge the data ';

Line 8470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Period: '||g_period_name);

8466: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
8467: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
8468: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'LE: '||g_legal_entity_id);
8469: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Book keeping type: '||g_bookkeeping_type||'ESTB'||g_establishment_id);
8470: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Period: '||g_period_name);
8471: END IF;
8472: --l_request_id := 0;
8473: g_errbuf := 'Error in finding the request_id to purge the data ';
8474: g_retcode := 2;

Line 8493: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',

8489:
8490: END IF;
8491:
8492: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8493: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',
8494: G_PKG_NAME||': '||l_api_name||'()-');
8495: END IF;
8496: END purge_data;
8497:

Line 8753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Start of Code Hook register_I015');

8749: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling code hook, which populates I015 for Integrated Receiving system');
8750: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Starting Sequence Value :'||l_sequence_value);
8751:
8752: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Start of Code Hook register_I015');
8754: END IF;
8755: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8756: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I105 : Starting Sequence Value :'||l_sequence_value);
8757: END IF;

Line 8756: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I105 : Starting Sequence Value :'||l_sequence_value);

8752: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Start of Code Hook register_I015');
8754: END IF;
8755: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8756: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I105 : Starting Sequence Value :'||l_sequence_value);
8757: END IF;
8758:
8759:
8760: JL_BR_SPED_DATA_EXTRACT_PUB.register_I015( g_retcode

Line 8779: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I105 : Ending Sequence Value :'||l_sequence_value);

8775: FROM DUAL;
8776:
8777: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Ending Sequence Value :'||l_sequence_value);
8778: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8779: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I105 : Ending Sequence Value :'||l_sequence_value);
8780: END IF;
8781:
8782: IF g_retcode = 2 THEN
8783: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occurred in Custom package JL_BR_SPED_DATA_EXTRACT_PUB.register_I015');

Line 8863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Start of Code Hook register_I200_I250');

8859: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Calling code hook, which populates I200 and I250 for Integrated Receiving system');
8860: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Starting Sequence Value :'||l_sequence_value);
8861:
8862: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Start of Code Hook register_I200_I250');
8864: END IF;
8865: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I200_I250 Starting Sequence Value :'||l_sequence_value);
8867: END IF;

Line 8866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I200_I250 Starting Sequence Value :'||l_sequence_value);

8862: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8863: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Start of Code Hook register_I200_I250');
8864: END IF;
8865: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8866: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I200_I250 Starting Sequence Value :'||l_sequence_value);
8867: END IF;
8868:
8869:
8870: JL_BR_SPED_DATA_EXTRACT_PUB.register_I200_I250( g_retcode

Line 8889: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I200_I250 Ending Sequence Value :'||l_sequence_value);

8885: FROM DUAL;
8886:
8887: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Code Hook Ending Sequence Value :'||l_sequence_value);
8888: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
8889: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME, 'Code Hook register_I200_I250 Ending Sequence Value :'||l_sequence_value);
8890: END IF;
8891:
8892: IF g_retcode = 2 THEN
8893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occurred in Custom package JL_BR_SPED_DATA_EXTRACT_PUB.register_I200_I250');

Line 9213: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

9209:
9210: EXCEPTION
9211: WHEN OTHERS THEN
9212: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
9213: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
9214: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While displaying the accounts that has one or more journal entries with more than 19 digits');
9215: END IF;
9216: END;
9217:

Line 9214: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While displaying the accounts that has one or more journal entries with more than 19 digits');

9210: EXCEPTION
9211: WHEN OTHERS THEN
9212: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
9213: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
9214: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error While displaying the accounts that has one or more journal entries with more than 19 digits');
9215: END IF;
9216: END;
9217:
9218: