63: AND vat_reporting_entity_id = p_vat_reporting_entity_id
64: AND type_of_upload = p_type_of_upload;
65:
66: BEGIN
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start PROCEDURE Extract_data');
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters are :');
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
64: AND type_of_upload = p_type_of_upload;
65:
66: BEGIN
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start PROCEDURE Extract_data');
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters are :');
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
65:
66: BEGIN
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start PROCEDURE Extract_data');
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters are :');
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
66: BEGIN
67: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start PROCEDURE Extract_data');
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters are :');
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
68: FND_FILE.PUT_LINE(FND_FILE.LOG,'Parameters are :');
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
69: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_vat_reporting_entity_id :'||p_vat_reporting_entity_id);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_year :'||p_year);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
71:
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_type_of_upload :'||p_type_of_upload);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
73: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_transmission_code :'||p_transmission_code);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_protocol_number :'||p_protocol_num);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
82: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_max_no_of_records :'||p_max_no_of_records);
75: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_province_code :'||p_province_code);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
82: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_max_no_of_records :'||p_max_no_of_records);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_gen_eft_report :'||p_gen_eft_report);
76: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_decl_inc_company :'||p_decl_inc_company);
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
82: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_max_no_of_records :'||p_max_no_of_records);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_gen_eft_report :'||p_gen_eft_report);
84:
77: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_inv_acctg_status :'||p_inv_acctg_status);
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
82: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_max_no_of_records :'||p_max_no_of_records);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_gen_eft_report :'||p_gen_eft_report);
84:
85: g_vat_reporting_entity_id := p_vat_reporting_entity_id;
78: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_end_date_for_cm_dm :'||p_end_date_for_cm_dm);
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
82: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_max_no_of_records :'||p_max_no_of_records);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_gen_eft_report :'||p_gen_eft_report);
84:
85: g_vat_reporting_entity_id := p_vat_reporting_entity_id;
86: g_year := p_year;
79: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2b_threshold :'||p_b2b_threshold);
80: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_threshold :'||p_b2c_threshold);
81: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_b2c_trx_start_date :'||p_b2c_trx_start_date);
82: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_max_no_of_records :'||p_max_no_of_records);
83: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_gen_eft_report :'||p_gen_eft_report);
84:
85: g_vat_reporting_entity_id := p_vat_reporting_entity_id;
86: g_year := p_year;
87: g_type_of_upload := p_type_of_upload;
430: ,fnd_languages FL
431: WHERE NSP.parameter = 'NLS_LANGUAGE'
432: AND NSP.value = FL.nls_language;
433:
434: fnd_file.put_line(fnd_file.log,'l_template_language :'||l_template_language);
435: fnd_file.put_line(fnd_file.log,'l_template_territory :'||l_template_territory);
436:
437: l_xml_layout := FND_REQUEST.ADD_LAYOUT(l_appln_name,'JEITIATA',l_template_language,l_template_territory,'PDF');
438: l_request_id := fnd_request.submit_request(application => l_appln_name,
431: WHERE NSP.parameter = 'NLS_LANGUAGE'
432: AND NSP.value = FL.nls_language;
433:
434: fnd_file.put_line(fnd_file.log,'l_template_language :'||l_template_language);
435: fnd_file.put_line(fnd_file.log,'l_template_territory :'||l_template_territory);
436:
437: l_xml_layout := FND_REQUEST.ADD_LAYOUT(l_appln_name,'JEITIATA',l_template_language,l_template_territory,'PDF');
438: l_request_id := fnd_request.submit_request(application => l_appln_name,
439: program => l_con_cp_audit,
2360: PROCEDURE debug_message(p_message_str VARCHAR2)
2361: IS
2362: BEGIN
2363: IF g_debug_flag = 'Y' THEN
2364: fnd_file.put_line(fnd_file.log,p_message_str);
2365: END IF;
2366: END debug_message;
2367:
2368: END JE_IT_INVOICES_ABOVE_THRESHOLD;