eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_SLA_AR_PROCESSING_PKG dependencies on FV_SLA_UTL_PROCESSING_PKG

Line 29: fv_sla_utl_processing_pkg.trace

25: p_debug_info IN VARCHAR2
26: )
27: IS
28: BEGIN
29: fv_sla_utl_processing_pkg.trace
30: (
31: p_level => p_level,
32: p_procedure_name => p_procedure_name,
33: p_debug_info => p_debug_info

Line 45: fv_sla_utl_processing_pkg.stack_error

41: p_error_message IN VARCHAR2
42: )
43: IS
44: BEGIN
45: fv_sla_utl_processing_pkg.stack_error
46: (
47: p_program_name => p_program_name,
48: p_location => p_location,
49: p_error_message => p_error_message

Line 130: fv_sla_utl_processing_pkg.stack_error (l_procedure_name, 'FINAL', p_error_desc);

126: p_error_code := c_FAILURE;
127: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
128: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
129: p_error_desc := fnd_message.get;
130: fv_sla_utl_processing_pkg.stack_error (l_procedure_name, 'FINAL', p_error_desc);
131: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:FINAL:'||p_error_desc);
132: END;
133:
134: PROCEDURE get_ar_invoice_details

Line 557: l_ledger_info fv_sla_utl_processing_pkg.LedgerRecType;

553: )
554: IS
555: l_procedure_name VARCHAR2(100):='.AR_EXTRACT';
556: l_index NUMBER;
557: l_ledger_info fv_sla_utl_processing_pkg.LedgerRecType;
558: l_error_code NUMBER;
559: l_gt_error_code NUMBER;
560: l_error_desc VARCHAR2(1024);
561: l_fund_value VARCHAR(30);

Line 564: l_fv_extract_detail fv_sla_utl_processing_pkg.fv_ref_detail;

560: l_error_desc VARCHAR2(1024);
561: l_fund_value VARCHAR(30);
562: l_account_value VARCHAR2(30);
563: l_bfy_value VARCHAR2(30);
564: l_fv_extract_detail fv_sla_utl_processing_pkg.fv_ref_detail;
565: l_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
566: l_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
567: l_fund_category fv_fund_parameters.fund_category%TYPE;
568: l_fund_status VARCHAR2(100);

Line 667: fv_sla_utl_processing_pkg.get_ledger_info

663: l_index:=0;
664: FOR event_rec IN (SELECT *
665: FROM xla_events_gt
666: WHERE application_id = p_application_id) LOOP
667: fv_sla_utl_processing_pkg.get_ledger_info
668: (
669: p_ledger_id => event_rec.ledger_id,
670: p_ledger_rec => l_ledger_info,
671: p_error_code => l_error_code,

Line 703: fv_sla_utl_processing_pkg.get_fed_non_fed_ind

699:
700: IF (l_error_code = C_SUCCESS) THEN
701: trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_fed_non_fed_ind');
702: trace(C_STATE_LEVEL, l_procedure_name, 'l_customer_id='||l_customer_id);
703: fv_sla_utl_processing_pkg.get_fed_non_fed_ind
704: (
705: p_cust_vend_id => l_customer_id,
706: p_cust_or_vend => 'C',
707: p_fed_non_fed_ind => l_fed_non_fed_ind,

Line 731: fv_sla_utl_processing_pkg.get_segment_values

727: IF (l_error_code = C_SUCCESS) THEN
728: trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_segment_values');
729: trace(C_STATE_LEVEL, l_procedure_name, 'p_ledger_id='||l_ledger_info.ledger_id);
730: trace(C_STATE_LEVEL, l_procedure_name, 'p_ccid='||inv_rec.trx_line_dist_ccid);
731: fv_sla_utl_processing_pkg.get_segment_values
732: (
733: p_ledger_id => l_ledger_info.ledger_id,
734: p_ccid => inv_rec.trx_line_dist_ccid,
735: p_fund_value => l_fund_value,

Line 753: fv_sla_utl_processing_pkg.get_fund_details

749: trace(C_STATE_LEVEL, l_procedure_name, 'p_application_id='||p_application_id);
750: trace(C_STATE_LEVEL, l_procedure_name, 'p_ledger_id='||l_ledger_info.ledger_id);
751: trace(C_STATE_LEVEL, l_procedure_name, 'p_fund_value='||l_fund_value);
752: trace(C_STATE_LEVEL, l_procedure_name, 'p_gl_date='||event_rec.event_date);
753: fv_sla_utl_processing_pkg.get_fund_details
754: (
755: p_application_id => p_application_id,
756: p_ledger_id => l_ledger_info.ledger_id,
757: p_fund_value => l_fund_value,

Line 790: fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS

786:
787: ELSE
788: -- Added for bug 14189341
789: trace(C_STATE_LEVEL, l_procedure_name, ' Inserting accounting errors into xla_accounting_errors table for event :'||event_rec.event_id);
790: fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS
791: (
792: p_appli_s_name=> 'FV',
793: p_msg_name => 'FV_AR_FUND_NO_SETUP',
794: p_entity_id => event_rec.entity_id,

Line 827: fv_sla_utl_processing_pkg.get_segment_values

823: IF (l_error_code = C_SUCCESS) THEN
824: trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_segment_values');
825: trace(C_STATE_LEVEL, l_procedure_name, 'p_ledger_id='||l_ledger_info.ledger_id);
826: trace(C_STATE_LEVEL, l_procedure_name, 'p_ccid='||rec_rec.trx_line_dist_ccid);
827: fv_sla_utl_processing_pkg.get_segment_values
828: (
829: p_ledger_id => l_ledger_info.ledger_id,
830: p_ccid => rec_rec.trx_line_dist_ccid,
831: p_fund_value => l_fund_value,

Line 849: fv_sla_utl_processing_pkg.get_fund_details

845: trace(C_STATE_LEVEL, l_procedure_name, 'p_application_id='||p_application_id);
846: trace(C_STATE_LEVEL, l_procedure_name, 'p_ledger_id='||l_ledger_info.ledger_id);
847: trace(C_STATE_LEVEL, l_procedure_name, 'p_fund_value='||l_fund_value);
848: trace(C_STATE_LEVEL, l_procedure_name, 'p_gl_date='||event_rec.event_date);
849: fv_sla_utl_processing_pkg.get_fund_details
850: (
851: p_application_id => p_application_id,
852: p_ledger_id => l_ledger_info.ledger_id,
853: p_fund_value => l_fund_value,

Line 872: fv_sla_utl_processing_pkg.get_prior_year_status

868:
869: IF (l_error_code = C_SUCCESS) THEN
870: l_pya := 'N';
871: IF (NVL(l_no_pya_acct_flag, 'N') = 'N') THEN
872: fv_sla_utl_processing_pkg.get_prior_year_status
873: (
874: p_application_id => p_application_id,
875: p_ledger_id => l_ledger_info.ledger_id,
876: p_bfy_value => l_bfy_value,

Line 903: fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS

899: l_fv_extract_detail(l_index).direct_or_reimb := l_direct_or_reimb;
900: ELSE
901: -- Added for bug 14189341
902: trace(C_STATE_LEVEL, l_procedure_name, ' Inserting accounting errors into xla_accounting_errors table for event :'||event_rec.event_id);
903: fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS
904: (
905: p_appli_s_name=> 'FV',
906: p_msg_name => 'FV_AR_FUND_NO_SETUP',
907: p_entity_id => event_rec.entity_id,

Line 936: fv_sla_utl_processing_pkg.get_segment_values

932: IF (l_error_code = C_SUCCESS) THEN
933: trace(C_STATE_LEVEL, l_procedure_name, 'Calling get_segment_values');
934: trace(C_STATE_LEVEL, l_procedure_name, 'p_ledger_id='||l_ledger_info.ledger_id);
935: trace(C_STATE_LEVEL, l_procedure_name, 'p_ccid='||misc_rec.dist_code_combination_id);
936: fv_sla_utl_processing_pkg.get_segment_values
937: (
938: p_ledger_id => l_ledger_info.ledger_id,
939: p_ccid => misc_rec.dist_code_combination_id,
940: p_fund_value => l_fund_value,

Line 958: fv_sla_utl_processing_pkg.get_fund_details

954: trace(C_STATE_LEVEL, l_procedure_name, 'p_application_id='||p_application_id);
955: trace(C_STATE_LEVEL, l_procedure_name, 'p_ledger_id='||l_ledger_info.ledger_id);
956: trace(C_STATE_LEVEL, l_procedure_name, 'p_fund_value='||l_fund_value);
957: trace(C_STATE_LEVEL, l_procedure_name, 'p_gl_date='||event_rec.event_date);
958: fv_sla_utl_processing_pkg.get_fund_details
959: (
960: p_application_id => p_application_id,
961: p_ledger_id => l_ledger_info.ledger_id,
962: p_fund_value => l_fund_value,

Line 979: fv_sla_utl_processing_pkg.get_prior_year_status

975: END IF;
976: IF (l_error_code = C_SUCCESS) THEN
977: l_pya := 'N';
978: IF (NVL(l_no_pya_acct_flag, 'N') = 'N') THEN
979: fv_sla_utl_processing_pkg.get_prior_year_status
980: (
981: p_application_id => p_application_id,
982: p_ledger_id => l_ledger_info.ledger_id,
983: p_bfy_value => l_bfy_value,

Line 1010: fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS

1006: l_fv_extract_detail(l_index).direct_or_reimb := l_direct_or_reimb;
1007: ELSE
1008: -- Added for bug 14189341
1009: trace(C_STATE_LEVEL, l_procedure_name, ' Inserting accounting errors into xla_accounting_errors table for event :'||event_rec.event_id);
1010: fv_sla_utl_processing_pkg.INSERT_FV_XLA_ACC_ERRORS
1011: (
1012: p_appli_s_name=> 'FV',
1013: p_msg_name => 'FV_AR_FUND_NO_SETUP',
1014: p_entity_id => event_rec.entity_id,

Line 1047: fv_sla_utl_processing_pkg.dump_gt_table

1043: trace(C_STATE_LEVEL, l_procedure_name, 'Trxn Cat: '||l_rec_attribute_cat);
1044: trace(C_STATE_LEVEL, l_procedure_name, 'Dir or Reimb: '||l_direct_or_reimb);
1045: END IF;
1046: trace(C_STATE_LEVEL, l_procedure_name, 'Calling dump_gt_table');
1047: fv_sla_utl_processing_pkg.dump_gt_table
1048: (
1049: p_fv_extract_detail => l_fv_extract_detail,
1050: p_error_code => l_gt_error_code,
1051: p_error_desc => l_error_desc