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.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_CONSTANTS

Line 147: upper(registration_type) = upper(jai_constants.regn_type_tax_types) AND

143: FROM
144: JAI_RGM_REGISTRATIONS
145: WHERE
146: regime_id = cp_regime_id AND
147: upper(registration_type) = upper(jai_constants.regn_type_tax_types) AND
148: upper(attribute_code) = upper(cp_tax_type);
149:
150: lv_exists VARCHAR2(2) ;
151: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

Line 160: p_error_flag := jai_constants.successful ;

156:
157: /*################################################################################################################
158: || Initialize the variables
159: ################################################################################################################*/
160: p_error_flag := jai_constants.successful ;
161: p_error_message := NULL ;
162: p_regime_id := NULL ;
163:
164: /*################################################################################################################

Line 179: OPEN c_get_lookup_meaning ( cp_lookup_type => jai_constants.lk_type_tax_type ,

175: ||As regime has not been defined for this tax type hence error out
176: */
177: CLOSE c_get_regime_id;
178:
179: OPEN c_get_lookup_meaning ( cp_lookup_type => jai_constants.lk_type_tax_type ,
180: cp_lookup_code => p_tax_type_code
181: );
182: FETCH c_get_lookup_meaning INTO lv_meaning;
183: CLOSE c_get_lookup_meaning;

Line 184: p_error_flag := jai_constants.expected_error;

180: cp_lookup_code => p_tax_type_code
181: );
182: FETCH c_get_lookup_meaning INTO lv_meaning;
183: CLOSE c_get_lookup_meaning;
184: p_error_flag := jai_constants.expected_error;
185: p_error_message := 'A regime has to be defined for taxes with tax type as '||lv_meaning;
186: return;
187: END IF;
188: CLOSE c_get_regime_id;

Line 212: OPEN c_get_lookup_meaning ( cp_lookup_type => jai_constants.lk_type_tax_type ,

208: CLOSE c_chk_service_tax;
209: /*
210: || Get the meaning from lookup tables for lookup type TAX_TYPE and the lookup code as the current tax type
211: */
212: OPEN c_get_lookup_meaning ( cp_lookup_type => jai_constants.lk_type_tax_type ,
213: cp_lookup_code => p_tax_type_code
214: );
215: FETCH c_get_lookup_meaning INTO lv_meaning;
216: CLOSE c_get_lookup_meaning;

Line 220: OPEN c_get_lookup_meaning ( cp_lookup_type => jai_constants.lk_type_ind_tax_rgms ,

216: CLOSE c_get_lookup_meaning;
217: /*
218: || Get the meaning from lookup tables for lookup type 'JAI_INDIA_TAX_REGIMES' and the lookup code as 'SERVICE'
219: */
220: OPEN c_get_lookup_meaning ( cp_lookup_type => jai_constants.lk_type_ind_tax_rgms ,
221: cp_lookup_code => p_tax_type_code
222: );
223: FETCH c_get_lookup_meaning INTO lv_meaning_rgm;
224: CLOSE c_get_lookup_meaning;

Line 225: p_error_flag := jai_constants.expected_error;

221: cp_lookup_code => p_tax_type_code
222: );
223: FETCH c_get_lookup_meaning INTO lv_meaning_rgm;
224: CLOSE c_get_lookup_meaning;
225: p_error_flag := jai_constants.expected_error;
226: p_error_message := 'A tax type of '|| lv_meaning ||'should be defined for the regime '||lv_meaning_rgm;
227: return;
228: END IF;
229: CLOSE c_chk_service_tax;

Line 235: p_error_flag := jai_constants.unexpected_error;

231: p_regime_id := ln_regime_id ;
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: p_error_flag := jai_constants.unexpected_error;
236: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);
237: END get_regime_info;
238:
239: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,

Line 333: p_process_flag := jai_constants.successful ;

329:
330: /*
331: || Variable Intialization
332: */
333: p_process_flag := jai_constants.successful ;
334: p_process_message := null ;
335:
336: fnd_file.put_line(fnd_file.LOG,' 2 Variables Initialised ');
337:

Line 339: p_process_flag := jai_constants.expected_error;

335:
336: fnd_file.put_line(fnd_file.LOG,' 2 Variables Initialised ');
337:
338: IF p_total_disc_amount IS NULL THEN
339: p_process_flag := jai_constants.expected_error;
340: p_process_message := 'Service Tax Discounted cannot be NULL ';
341: fnd_file.put_line(fnd_file.LOG,' 3 EXPECTED ERROR - Service Tax Discounted amount cannot be NULL ');
342: return;
343: END IF;

Line 352: p_process_flag := jai_constants.expected_error;

348: OPEN cur_get_receivable_app ;
349: FETCH cur_get_receivable_app into rec_cur_get_receivable_app ;
350: IF CUR_GET_RECEIVABLE_APP%NOTFOUND THEN
351: CLOSE cur_get_receivable_app;
352: p_process_flag := jai_constants.expected_error;
353: p_process_message := 'Receivable Application record with the receivable_application_id -> '||p_receivable_application_id ||' not found ';
354: fnd_file.put_line(fnd_file.LOG,' 4 EXPECTED ERROR -Receivable Application record with the receivable_application_id -> '||p_receivable_application_id ||' not found ');
355: return;
356: END IF;

Line 396: p_process_flag := jai_constants.expected_error ;

392:
393: IF CUR_GET_DISC_CCID%NOTFOUND THEN
394: CLOSE cur_get_receivable_app;
395: CLOSE cur_get_disc_ccid;
396: p_process_flag := jai_constants.expected_error ;
397: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';
398: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');
399: return;
400: END IF;

Line 417: p_process_flag := jai_constants.expected_error ;

413:
414: IF CUR_GET_DISC_CCID%NOTFOUND THEN
415: CLOSE cur_get_receivable_app;
416: CLOSE cur_get_disc_ccid;
417: p_process_flag := jai_constants.expected_error ;
418: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';
419: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');
420: return;
421: END IF;

Line 439: p_process_flag := jai_constants.unexpected_error ;

435: fnd_file.put_line(fnd_file.LOG,'********************* 10 END OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *********************');
436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: p_process_flag := jai_constants.unexpected_error ;
440: p_process_message := 'Unexpeced error occured in procedure get_ar_tax_disc_accnt for receivable_application_id -> '||p_receivable_application_id ||substr(SQLERRM,1,300);
441:
442: END get_ar_tax_disc_accnt ;
443:

Line 452: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

448: p_from_date IN DATE ,
449: p_to_date IN DATE ,
450: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
451: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
452: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
453: p_process_flag OUT NOCOPY VARCHAR2 ,
454: p_process_message OUT NOCOPY VARCHAR2,
455: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL
456: )

Line 470: CURSOR c_fetch_inv_cm_rec ( cp_invoice_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_INV%TYPE ,

466: /******************************
467: ||Cursor Declarations Section
468: *******************************/
469:
470: CURSOR c_fetch_inv_cm_rec ( cp_invoice_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_INV%TYPE ,
471: cp_cm_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_CM%TYPE ,
472: cp_service_tax varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE%TYPE ,
473: cp_service_edu_cess varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE_EDU_CESS%TYPE
474: cp_sh_service_edu_cess JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS%TYPE --Added By Bgowrava for forward porting bug#5989740

Line 471: cp_cm_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_CM%TYPE ,

467: ||Cursor Declarations Section
468: *******************************/
469:
470: CURSOR c_fetch_inv_cm_rec ( cp_invoice_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_INV%TYPE ,
471: cp_cm_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_CM%TYPE ,
472: cp_service_tax varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE%TYPE ,
473: cp_service_edu_cess varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE_EDU_CESS%TYPE
474: cp_sh_service_edu_cess JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS%TYPE --Added By Bgowrava for forward porting bug#5989740
475: )

Line 472: cp_service_tax varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE%TYPE ,

468: *******************************/
469:
470: CURSOR c_fetch_inv_cm_rec ( cp_invoice_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_INV%TYPE ,
471: cp_cm_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_CM%TYPE ,
472: cp_service_tax varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE%TYPE ,
473: cp_service_edu_cess varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE_EDU_CESS%TYPE
474: cp_sh_service_edu_cess JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS%TYPE --Added By Bgowrava for forward porting bug#5989740
475: )
476: IS

Line 473: cp_service_edu_cess varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE_EDU_CESS%TYPE

469:
470: CURSOR c_fetch_inv_cm_rec ( cp_invoice_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_INV%TYPE ,
471: cp_cm_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_CM%TYPE ,
472: cp_service_tax varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE%TYPE ,
473: cp_service_edu_cess varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE_EDU_CESS%TYPE
474: cp_sh_service_edu_cess JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS%TYPE --Added By Bgowrava for forward porting bug#5989740
475: )
476: IS
477: SELECT

Line 474: cp_sh_service_edu_cess JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS%TYPE --Added By Bgowrava for forward porting bug#5989740

470: CURSOR c_fetch_inv_cm_rec ( cp_invoice_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_INV%TYPE ,
471: cp_cm_type varchar2, --File.Sql.35 Cbabu jai_constants.AR_INVOICE_TYPE_CM%TYPE ,
472: cp_service_tax varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE%TYPE ,
473: cp_service_edu_cess varchar2, --File.Sql.35 Cbabu jai_constants.TAX_TYPE_SERVICE_EDU_CESS%TYPE
474: cp_sh_service_edu_cess JAI_CONSTANTS.TAX_TYPE_SH_SERVICE_EDU_CESS%TYPE --Added By Bgowrava for forward porting bug#5989740
475: )
476: IS
477: SELECT
478: trx.customer_trx_id ,

Line 558: lv_process_flag := jai_constants.successful ;

554: /*
555: || Variable Initialization
556: */
557:
558: lv_process_flag := jai_constants.successful ;
559: lv_process_message := NULL ;
560:
561: p_process_flag := lv_process_flag ;
562: p_process_message := lv_process_message ;

Line 566: FOR rec_c_fetch_inv_cm_rec IN c_fetch_inv_cm_rec ( cp_invoice_type => upper(jai_constants.ar_invoice_type_inv) ,

562: p_process_message := lv_process_message ;
563:
564: ln_invoices_processed := 0 ;
565:
566: FOR rec_c_fetch_inv_cm_rec IN c_fetch_inv_cm_rec ( cp_invoice_type => upper(jai_constants.ar_invoice_type_inv) ,
567: cp_cm_type => upper(jai_constants.ar_invoice_type_cm) ,
568: cp_service_tax => upper(jai_constants.tax_type_service) ,
569: cp_service_edu_cess => upper(jai_constants.tax_type_service_edu_cess),
570: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740

Line 567: cp_cm_type => upper(jai_constants.ar_invoice_type_cm) ,

563:
564: ln_invoices_processed := 0 ;
565:
566: FOR rec_c_fetch_inv_cm_rec IN c_fetch_inv_cm_rec ( cp_invoice_type => upper(jai_constants.ar_invoice_type_inv) ,
567: cp_cm_type => upper(jai_constants.ar_invoice_type_cm) ,
568: cp_service_tax => upper(jai_constants.tax_type_service) ,
569: cp_service_edu_cess => upper(jai_constants.tax_type_service_edu_cess),
570: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740
571: )

Line 568: cp_service_tax => upper(jai_constants.tax_type_service) ,

564: ln_invoices_processed := 0 ;
565:
566: FOR rec_c_fetch_inv_cm_rec IN c_fetch_inv_cm_rec ( cp_invoice_type => upper(jai_constants.ar_invoice_type_inv) ,
567: cp_cm_type => upper(jai_constants.ar_invoice_type_cm) ,
568: cp_service_tax => upper(jai_constants.tax_type_service) ,
569: cp_service_edu_cess => upper(jai_constants.tax_type_service_edu_cess),
570: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740
571: )
572: LOOP

Line 569: cp_service_edu_cess => upper(jai_constants.tax_type_service_edu_cess),

565:
566: FOR rec_c_fetch_inv_cm_rec IN c_fetch_inv_cm_rec ( cp_invoice_type => upper(jai_constants.ar_invoice_type_inv) ,
567: cp_cm_type => upper(jai_constants.ar_invoice_type_cm) ,
568: cp_service_tax => upper(jai_constants.tax_type_service) ,
569: cp_service_edu_cess => upper(jai_constants.tax_type_service_edu_cess),
570: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740
571: )
572: LOOP
573:

Line 570: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740

566: FOR rec_c_fetch_inv_cm_rec IN c_fetch_inv_cm_rec ( cp_invoice_type => upper(jai_constants.ar_invoice_type_inv) ,
567: cp_cm_type => upper(jai_constants.ar_invoice_type_cm) ,
568: cp_service_tax => upper(jai_constants.tax_type_service) ,
569: cp_service_edu_cess => upper(jai_constants.tax_type_service_edu_cess),
570: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740
571: )
572: LOOP
573:
574: fnd_file.put_line(fnd_file.LOG,'2 processing record, customer_trx_id '||rec_c_fetch_inv_cm_rec.customer_trx_id

Line 604: p_party_type => jai_constants.party_type_customer ,

600: p_tax_type => rec_c_fetch_inv_cm_rec.tax_type ,
601: p_tax_id => rec_c_fetch_inv_cm_rec.tax_id ,
602: p_tax_rate => rec_c_fetch_inv_cm_rec.tax_rate ,
603: p_recoverable_ptg => rec_c_fetch_inv_cm_rec.mod_cr_percentage ,
604: p_party_type => jai_constants.party_type_customer ,
605: p_party_id => rec_c_fetch_inv_cm_rec.customer_id ,
606: p_party_site_id => rec_c_fetch_inv_cm_rec.customer_site_id ,
607: p_trx_tax_amount => rec_c_fetch_inv_cm_rec.tax_amount ,
608: p_trx_currency => rec_c_fetch_inv_cm_rec.invoice_currency_code ,

Line 628: IF lv_process_flag = jai_constants.expected_error OR

624: fnd_file.put_line(fnd_file.LOG,'4 returned from procedure jai_cmn_rgm_recording_pkg.insert_reference, lv_process_flag - '||lv_process_flag
625: ||'lv_process_message - '||lv_process_message);
626:
627:
628: IF lv_process_flag = jai_constants.expected_error OR
629: lv_process_flag = jai_constants.unexpected_error
630: THEN
631: /*
632: || as Returned status is an error hence:-

Line 629: lv_process_flag = jai_constants.unexpected_error

625: ||'lv_process_message - '||lv_process_message);
626:
627:
628: IF lv_process_flag = jai_constants.expected_error OR
629: lv_process_flag = jai_constants.unexpected_error
630: THEN
631: /*
632: || as Returned status is an error hence:-
633: ||1. Rollback to save point

Line 653: lv_process_flag := jai_constants.unexpected_error;

649:
650: EXCEPTION
651: WHEN OTHERS THEN
652:
653: lv_process_flag := jai_constants.unexpected_error;
654: lv_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_inv_cm_references'||substr(SQLERRM,1,500) ;
655: ROLLBACK to before_ref_inv_cm;
656:
657: END populate_inv_cm_references;

Line 664: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

660: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
661: p_from_date IN DATE ,
662: p_to_date IN DATE ,
663: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
664: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
665: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
666: p_process_flag OUT NOCOPY VARCHAR2 ,
667: p_process_message OUT NOCOPY VARCHAR2
668: ,p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)

Line 713: upper(trx_types.type) = upper(jai_constants.ar_invoice_type_cm) AND

709: WHERE
710: trx.customer_trx_id = rgtr.invoice_id AND
711: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND
712: trx_types.org_id = trx.org_id AND
713: upper(trx_types.type) = upper(jai_constants.ar_invoice_type_cm) AND
714: trx.complete_flag = 'Y'
715: )
716: GROUP BY
717: rgtr.invoice_id;

Line 769: lv_process_flag := jai_constants.successful ;

765:
766: /*
767: || Variable Intialization
768: */
769: lv_process_flag := jai_constants.successful ;
770: lv_process_message := null ;
771:
772: p_process_flag := lv_process_flag ;
773: p_process_message := lv_process_message ;

Line 781: lv_source_trx_type := jai_constants.trx_type_cm_rvs ;

777:
778: /*
779: || Source type would indicate CREDIT MEMO REVERSAL
780: */
781: lv_source_trx_type := jai_constants.trx_type_cm_rvs ;
782:
783: /*
784: || Update all the credit memo from reference, reset recovered_amount = 0
785: || Insert repository records ('CM-CM-APP') corresponding to the above effect

Line 851: IF lv_process_flag <> jai_constants.successful THEN

847: p_process_flag => lv_process_flag,
848: p_process_message => lv_process_message
849: );
850:
851: IF lv_process_flag <> jai_constants.successful THEN
852: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
853: return;
854: END IF;
855:

Line 870: p_source_table_name => UPPER(jai_constants.repository_name) ,

866: p_location_id => ln_location_id ,/*5879769*/
867: p_service_type_code => lv_service_type_code ,/*5879769*/
868: p_source => p_source ,
869: p_source_trx_type => lv_source_trx_type ,
870: p_source_table_name => UPPER(jai_constants.repository_name) ,
871: p_source_document_id => rec_c_get_cm_cm_app_rec.repository_id ,
872: p_transaction_date => rec_c_get_cm_cm_app_rec.creation_date ,
873: p_account_name => NULL ,
874: p_charge_account_id => NULL ,

Line 894: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu

890: p_curr_conv_rate => rec_c_get_cm_cm_app_rec.curr_conv_rate ,
891: p_trx_amount => ln_amount ,
892: p_attribute_context => lv_attribute_context ,
893: p_attribute2 => rec_c_get_incompleted_cm.cm_customer_trx_id
894: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
895: );
896:
897: fnd_file.put_line(fnd_file.LOG,' 4 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
898:

Line 900: IF lv_process_flag = jai_constants.expected_error OR

896:
897: fnd_file.put_line(fnd_file.LOG,' 4 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
898:
899:
900: IF lv_process_flag = jai_constants.expected_error OR
901: lv_process_flag = jai_constants.unexpected_error
902: THEN
903: /*
904: || as Returned status is an error hence:-

Line 901: lv_process_flag = jai_constants.unexpected_error

897: fnd_file.put_line(fnd_file.LOG,' 4 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
898:
899:
900: IF lv_process_flag = jai_constants.expected_error OR
901: lv_process_flag = jai_constants.unexpected_error
902: THEN
903: /*
904: || as Returned status is an error hence:-
905: ||1. set the ln_err_cm_customer_trx_id to the cm_customer_Trx_id which errored out

Line 939: IF lv_process_flag = jai_constants.expected_error OR

935: p_recovered_amount => rec_cur_upd_cm_ref.recovered_amount * (-1) ,
936: p_process_flag => lv_process_flag ,
937: p_process_message => lv_process_message
938: );
939: IF lv_process_flag = jai_constants.expected_error OR
940: lv_process_flag = jai_constants.unexpected_error
941: THEN
942: /*
943: || as Returned status is an error hence:-

Line 940: lv_process_flag = jai_constants.unexpected_error

936: p_process_flag => lv_process_flag ,
937: p_process_message => lv_process_message
938: );
939: IF lv_process_flag = jai_constants.expected_error OR
940: lv_process_flag = jai_constants.unexpected_error
941: THEN
942: /*
943: || as Returned status is an error hence:-
944: || Set out variables p_process_flag and p_process_message accordingly

Line 1002: IF lv_process_flag <> jai_constants.successful THEN

998: p_process_flag => lv_process_flag,
999: p_process_message => lv_process_message
1000: );
1001:
1002: IF lv_process_flag <> jai_constants.successful THEN
1003: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
1004: return;
1005: END IF;
1006:

Line 1046: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu

1042: p_trx_amount => ln_amount , --rchandan for bug#4428980
1043: p_attribute_context => lv_attribute_context ,
1044: p_attribute1 => rec_c_get_cm_inv_app_rec.attribute1 ,
1045: p_attribute2 => rec_c_get_cm_inv_app_rec.attribute2
1046: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1047: );
1048:
1049: fnd_file.put_line(fnd_file.LOG,' 10.1 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1050:

Line 1052: IF lv_process_flag = jai_constants.expected_error OR

1048:
1049: fnd_file.put_line(fnd_file.LOG,' 10.1 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1050:
1051:
1052: IF lv_process_flag = jai_constants.expected_error OR
1053: lv_process_flag = jai_constants.unexpected_error
1054: THEN
1055: /*
1056: || as Returned status is an error hence:-

Line 1053: lv_process_flag = jai_constants.unexpected_error

1049: fnd_file.put_line(fnd_file.LOG,' 10.1 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1050:
1051:
1052: IF lv_process_flag = jai_constants.expected_error OR
1053: lv_process_flag = jai_constants.unexpected_error
1054: THEN
1055: /*
1056: || as Returned status is an error hence:-
1057: ||1. Rollback to save point

Line 1086: IF lv_process_flag = jai_constants.expected_error OR

1082: p_recovered_amount => ln_amount ,
1083: p_process_flag => lv_process_flag ,
1084: p_process_message => lv_process_message
1085: );
1086: IF lv_process_flag = jai_constants.expected_error OR
1087: lv_process_flag = jai_constants.unexpected_error
1088: THEN
1089: /*
1090: || as Returned status is an error hence:-

Line 1087: lv_process_flag = jai_constants.unexpected_error

1083: p_process_flag => lv_process_flag ,
1084: p_process_message => lv_process_message
1085: );
1086: IF lv_process_flag = jai_constants.expected_error OR
1087: lv_process_flag = jai_constants.unexpected_error
1088: THEN
1089: /*
1090: || as Returned status is an error hence:-
1091: || Set out variables p_process_flag and p_process_message accordingly

Line 1134: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

1130: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1131: p_from_date IN DATE ,
1132: p_to_date IN DATE ,
1133: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1134: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1135: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1136: p_process_flag OUT NOCOPY VARCHAR2 ,
1137: p_process_message OUT NOCOPY VARCHAR2
1138: , p_organization_id JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )

Line 1178: CURSOR c_get_cm_rec_app ( cp_source_ar varchar2) --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE )

1174: || 4. Invoice tax line has not been fully recovered i.e recovered_amount < recoverable_amount - discounted_amount in references table
1175: */
1176:
1177:
1178: CURSOR c_get_cm_rec_app ( cp_source_ar varchar2) --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE )
1179: IS
1180: SELECT
1181: aral.customer_trx_id cm_customer_trx_id ,
1182: aral.applied_customer_trx_id inv_customer_trx_id ,

Line 1313: CURSOR c_get_refinvrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

1309: /*
1310: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -
1311:
1312: */
1313: CURSOR c_get_refinvrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1314: cp_inv_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1315: )
1316: IS
1317: SELECT

Line 1334: CURSOR c_get_refcmrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

1330: nvl(recoverable_amount,0) - nvl(discounted_amount,0) > nvl(recovered_amount,0)
1331: FOR UPDATE NOWAIT ;
1332:
1333:
1334: CURSOR c_get_refcmrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1335: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1336: )
1337: IS
1338: SELECT

Line 1356: CURSOR c_get_cmref_totrd_amt ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

1352:
1353: /*
1354: || Get the total effective CM amount from the CM lines in reference table against which a CM application has to be recovered.
1355: */
1356: CURSOR c_get_cmref_totrd_amt ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1357: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1358: )
1359: IS
1360: SELECT

Line 1374: p_process_flag := jai_constants.successful ;

1370: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_cm_app' );
1371: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );
1372: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
1373:
1374: p_process_flag := jai_constants.successful ;
1375: p_process_message := null ;
1376:
1377: /*****
1378: || Get all the valid CM receivables

Line 1401: lv_process_flag := jai_constants.successful ;

1397: ln_inv_tot_tax_amt := null ;
1398: ln_cm_ref_ratio := null ;
1399: ln_cm_ref_upd := null ;
1400: lv_source_trx_type := null ;
1401: lv_process_flag := jai_constants.successful ;
1402: lv_process_message := null ;
1403:
1404: ln_inclusive_total_amt := null ; --added by walton for inclusive tax 29-Nov-07
1405:

Line 1463: lv_source_trx_type := jai_constants.trx_type_cm_rvs ;

1459: IF ln_sign_of_credit_memo > 0 THEN
1460: /*
1461: || +ve credit memo hence CREDIT MEMO REVERSAL
1462: */
1463: lv_source_trx_type := jai_constants.trx_type_cm_rvs ;
1464:
1465: ELSIF ln_sign_of_credit_memo < 0 THEN
1466: /*
1467: || -ve credit memo hence CREDIT MEMO APPLICATION

Line 1469: lv_source_trx_type := jai_constants.trx_type_cm_app ;

1465: ELSIF ln_sign_of_credit_memo < 0 THEN
1466: /*
1467: || -ve credit memo hence CREDIT MEMO APPLICATION
1468: */
1469: lv_source_trx_type := jai_constants.trx_type_cm_app ;
1470:
1471: END IF;
1472:
1473: fnd_file.put_line(fnd_file.LOG,'7 credit memo type is lv_source_trx_type-> '||lv_source_trx_type);

Line 1546: IF lv_process_flag <> jai_constants.successful THEN

1542: p_process_flag => lv_process_flag,
1543: p_process_message => lv_process_message
1544: );
1545:
1546: IF lv_process_flag <> jai_constants.successful THEN
1547: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
1548: return;
1549: END IF;
1550:

Line 1589: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu

1585: p_trx_amount => ln_amount ,
1586: p_attribute_context => lv_attribute_context ,
1587: p_attribute1 => rec_c_get_cm_rec_app.inv_customer_trx_id ,
1588: p_attribute2 => rec_c_get_cm_rec_app.cm_customer_trx_id
1589: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1590: );
1591:
1592: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1593:

Line 1595: IF lv_process_flag = jai_constants.expected_error OR

1591:
1592: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1593:
1594:
1595: IF lv_process_flag = jai_constants.expected_error OR
1596: lv_process_flag = jai_constants.unexpected_error
1597: THEN
1598: /*
1599: || As Returned status is an error hence:-

Line 1596: lv_process_flag = jai_constants.unexpected_error

1592: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1593:
1594:
1595: IF lv_process_flag = jai_constants.expected_error OR
1596: lv_process_flag = jai_constants.unexpected_error
1597: THEN
1598: /*
1599: || As Returned status is an error hence:-
1600: ||1. Rollback to save point

Line 1626: IF lv_process_flag = jai_constants.expected_error OR

1622: p_recovered_amount => ln_amount ,
1623: p_process_flag => lv_process_flag ,
1624: p_process_message => lv_process_message
1625: );
1626: IF lv_process_flag = jai_constants.expected_error OR
1627: lv_process_flag = jai_constants.unexpected_error
1628: THEN
1629: /*
1630: || as Returned status is an error hence:-

Line 1627: lv_process_flag = jai_constants.unexpected_error

1623: p_process_flag => lv_process_flag ,
1624: p_process_message => lv_process_message
1625: );
1626: IF lv_process_flag = jai_constants.expected_error OR
1627: lv_process_flag = jai_constants.unexpected_error
1628: THEN
1629: /*
1630: || as Returned status is an error hence:-
1631: || Set out variables p_process_flag and p_process_message accordingly

Line 1725: IF lv_process_flag <> jai_constants.successful THEN

1721: p_process_flag => lv_process_flag,
1722: p_process_message => lv_process_message
1723: );
1724:
1725: IF lv_process_flag <> jai_constants.successful THEN
1726: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
1727: return;
1728: END IF;
1729:

Line 1768: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu

1764: p_curr_conv_rate => rec_c_get_cm_rec_app.cm_exchange_rate ,
1765: p_trx_amount => ln_cm_ref_upd ,
1766: p_attribute_context => lv_attribute_context ,
1767: p_attribute2 => rec_c_get_cm_rec_app.cm_customer_trx_id
1768: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1769: );
1770:
1771: fnd_file.put_line(fnd_file.LOG,' 24 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1772:

Line 1774: IF lv_process_flag = jai_constants.expected_error OR

1770:
1771: fnd_file.put_line(fnd_file.LOG,' 24 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1772:
1773:
1774: IF lv_process_flag = jai_constants.expected_error OR
1775: lv_process_flag = jai_constants.unexpected_error
1776: THEN
1777: /*
1778: || as Returned status is an error hence:-

Line 1775: lv_process_flag = jai_constants.unexpected_error

1771: fnd_file.put_line(fnd_file.LOG,' 24 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1772:
1773:
1774: IF lv_process_flag = jai_constants.expected_error OR
1775: lv_process_flag = jai_constants.unexpected_error
1776: THEN
1777: /*
1778: || as Returned status is an error hence:-
1779: ||1. Rollback to save point

Line 1809: IF lv_process_flag = jai_constants.expected_error OR

1805: p_process_message => lv_process_message
1806: );
1807: fnd_file.put_line(fnd_file.LOG,' 21 Returned from jai_cmn_rgm_recording_pkg.update_reference for credit memo references' );
1808:
1809: IF lv_process_flag = jai_constants.expected_error OR
1810: lv_process_flag = jai_constants.unexpected_error
1811: THEN
1812: /*
1813: || As Returned status is an error hence:-

Line 1810: lv_process_flag = jai_constants.unexpected_error

1806: );
1807: fnd_file.put_line(fnd_file.LOG,' 21 Returned from jai_cmn_rgm_recording_pkg.update_reference for credit memo references' );
1808:
1809: IF lv_process_flag = jai_constants.expected_error OR
1810: lv_process_flag = jai_constants.unexpected_error
1811: THEN
1812: /*
1813: || As Returned status is an error hence:-
1814: ||1. Rollback to save point

Line 1842: p_process_flag := jai_constants.unexpected_error;

1838:
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: fnd_file.put_line(fnd_file.LOG,' 27 In exception section of jai_ar_rgm_processing_pkg.populate_cm_app' );
1842: p_process_flag := jai_constants.unexpected_error;
1843: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
1844: END populate_cm_app;
1845:
1846:

Line 1852: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

1848: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1849: p_from_date IN DATE ,
1850: p_to_date IN DATE ,
1851: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1852: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1853: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1854: p_process_flag OUT NOCOPY VARCHAR2 ,
1855: p_process_message OUT NOCOPY VARCHAR2
1856: ,p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL )

Line 1887: CURSOR c_get_rec_app ( cp_source_ar varchar2) --File.Sql.35 Cbabu ( jai_constants.SOURCE_AR%TYPE )

1883: || 4. Invoice tax line has not been fully recovered i.e recovered_amount < recoverable_amount in references table
1884: */
1885:
1886:
1887: CURSOR c_get_rec_app ( cp_source_ar varchar2) --File.Sql.35 Cbabu ( jai_constants.SOURCE_AR%TYPE )
1888: IS
1889: SELECT
1890: trx.customer_trx_id ,
1891: acrl.cash_receipt_id ,

Line 1916: upper(aral.application_type) = upper(jai_constants.ar_cash) AND

1912: WHERE
1913: aral.cash_receipt_id = acrl.cash_receipt_id AND
1914: aral.applied_customer_trx_id = trx.customer_trx_id AND
1915: trunc(aral.creation_date) BETWEEN trunc(p_from_date) and trunc(p_to_date) AND
1916: upper(aral.application_type) = upper(jai_constants.ar_cash) AND
1917: upper(aral.status) = upper(jai_constants.ar_status_app) AND
1918: jtrx.organization_id =p_organization_id AND --Added by kunkumar for forward porting to R12
1919: /*nvl(aral.tax_applied,0) <> 0 AND*/--Modified by walton for inclusive tax 29-Nov-07
1920: trx.org_id = nvl(p_org_id,trx.org_id) AND

Line 1917: upper(aral.status) = upper(jai_constants.ar_status_app) AND

1913: aral.cash_receipt_id = acrl.cash_receipt_id AND
1914: aral.applied_customer_trx_id = trx.customer_trx_id AND
1915: trunc(aral.creation_date) BETWEEN trunc(p_from_date) and trunc(p_to_date) AND
1916: upper(aral.application_type) = upper(jai_constants.ar_cash) AND
1917: upper(aral.status) = upper(jai_constants.ar_status_app) AND
1918: jtrx.organization_id =p_organization_id AND --Added by kunkumar for forward porting to R12
1919: /*nvl(aral.tax_applied,0) <> 0 AND*/--Modified by walton for inclusive tax 29-Nov-07
1920: trx.org_id = nvl(p_org_id,trx.org_id) AND
1921: trx.complete_flag = 'Y' AND

Line 1923: upper(trx_types.type) IN (upper(jai_constants.ar_invoice_type_inv),upper(jai_constants.ar_invoice_type_cm)) AND

1919: /*nvl(aral.tax_applied,0) <> 0 AND*/--Modified by walton for inclusive tax 29-Nov-07
1920: trx.org_id = nvl(p_org_id,trx.org_id) AND
1921: trx.complete_flag = 'Y' AND
1922: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND
1923: upper(trx_types.type) IN (upper(jai_constants.ar_invoice_type_inv),upper(jai_constants.ar_invoice_type_cm)) AND
1924: trx_types.org_id = trx.org_id AND
1925: trx.customer_trx_id = jtrx.customer_trx_id AND
1926: NOT EXISTS ( SELECT /*A receipt application does not exist in repository */
1927: 1

Line 1942: rgtf.source = jai_constants.SOURCE_AR AND

1938: 1
1939: FROM
1940: jai_rgm_trx_refs rgtf
1941: WHERE
1942: rgtf.source = jai_constants.SOURCE_AR AND
1943: rgtf.invoice_id = aral.applied_customer_trx_id AND
1944: (
1945: ( /*Scope of recovery is possible for cash receipt application */
1946: nvl(rgtf.recoverable_amount,0) - nvl(rgtf.discounted_amount,0) > nvl(rgtf.recovered_amount,0) AND

Line 2001: CURSOR c_get_refrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,

1997: --------------------------------------------------------------------------------
1998: /*
1999: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -
2000: */
2001: CURSOR c_get_refrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
2002: cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
2003: )
2004: IS
2005: SELECT

Line 2029: p_process_flag := jai_constants.successful ;

2025:
2026: /*
2027: ||Initialize the variables
2028: */
2029: p_process_flag := jai_constants.successful ;
2030: p_process_message := null ;
2031:
2032:
2033: /*****

Line 2050: lv_process_flag := jai_constants.successful ;

2046: ln_eff_cr_tax_amount := null ;
2047: ln_eff_cr_disc_amount := null ;
2048: lv_source_trx_type := null ;
2049: ln_inv_tot_tax_amt := null ;
2050: lv_process_flag := jai_constants.successful ;
2051: lv_process_message := null ;
2052:
2053: ln_inclusive_total_amt := null ; --added by walton for inclusive tax 29-Nov-07
2054:

Line 2102: lv_source_trx_type := jai_constants.trx_type_rct_app ;

2098: IF rec_c_get_rec_app.sign_of_cash_receipt > 0 or ln_total_tax_applied >0 THEN --modified by walton for inclusive tax 29-Nov-07
2099: /*
2100: || +ve cash receipt hence RECEIPT APPLICATION
2101: */
2102: lv_source_trx_type := jai_constants.trx_type_rct_app ;
2103: lv_attribute_context := 'CR-INV-APP' ;
2104:
2105: ELSIF rec_c_get_rec_app.sign_of_cash_receipt < 0 or ln_total_tax_applied <0 THEN --modified by walton for inclusive tax 29-Nov-07
2106: /*

Line 2109: lv_source_trx_type := jai_constants.trx_type_rct_rvs ;

2105: ELSIF rec_c_get_rec_app.sign_of_cash_receipt < 0 or ln_total_tax_applied <0 THEN --modified by walton for inclusive tax 29-Nov-07
2106: /*
2107: || -ve cash receipt hence RECEIPT REVERSAL/UNAPPLICATION
2108: */
2109: lv_source_trx_type := jai_constants.trx_type_rct_rvs ;
2110: lv_attribute_context := 'CR-INV-REV' ;
2111:
2112: ELSE
2113: /*

Line 2212: IF lv_process_flag <> jai_constants.successful THEN

2208: p_process_flag => lv_process_flag,
2209: p_process_message => lv_process_message
2210: );
2211:
2212: IF lv_process_flag <> jai_constants.successful THEN
2213: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
2214: return;
2215: END IF;
2216:

Line 2257: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu

2253: p_trx_amount => ln_eff_cr_tax_amount ,
2254: p_attribute_context => lv_attribute_context ,
2255: p_attribute1 => rec_c_get_rec_app.customer_trx_id ,
2256: p_attribute2 => rec_c_get_rec_app.cash_receipt_id
2257: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
2258: );
2259:
2260: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2261:

Line 2263: IF lv_process_flag = jai_constants.expected_error OR

2259:
2260: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2261:
2262:
2263: IF lv_process_flag = jai_constants.expected_error OR
2264: lv_process_flag = jai_constants.unexpected_error
2265: THEN
2266: /*
2267: || as Returned status is an error hence:-

Line 2264: lv_process_flag = jai_constants.unexpected_error

2260: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2261:
2262:
2263: IF lv_process_flag = jai_constants.expected_error OR
2264: lv_process_flag = jai_constants.unexpected_error
2265: THEN
2266: /*
2267: || as Returned status is an error hence:-
2268: ||1. Rollback to save point

Line 2298: IF lv_process_flag = jai_constants.expected_error OR

2294: p_process_message => lv_process_message
2295: );
2296:
2297:
2298: IF lv_process_flag = jai_constants.expected_error OR
2299: lv_process_flag = jai_constants.unexpected_error
2300: THEN
2301: /*
2302: || as Returned status is an error hence:-

Line 2299: lv_process_flag = jai_constants.unexpected_error

2295: );
2296:
2297:
2298: IF lv_process_flag = jai_constants.expected_error OR
2299: lv_process_flag = jai_constants.unexpected_error
2300: THEN
2301: /*
2302: || as Returned status is an error hence:-
2303: ||Set out variables p_process_flag and p_process_message accordingly

Line 2330: p_process_flag := jai_constants.unexpected_error;

2326: END LOOP;
2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2330: p_process_flag := jai_constants.unexpected_error;
2331: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_receipt_records'||SQLERRM ;
2332:
2333: END populate_receipt_records;
2334:

Line 2351: lv_source_ar varchar2(2); --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ;

2347: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/
2348: )
2349: IS
2350:
2351: lv_source_ar varchar2(2); --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ;
2352: lv_process_flag VARCHAR2(2) ;
2353: lv_process_message VARCHAR2(1996) ;
2354: lv_organization_id jai_rgm_parties.organization_id%type;
2355: BEGIN

Line 2363: lv_source_ar := jai_constants.source_ar ;

2359: /*########################################################################################################
2360: || VARIABLES INITIALIZATION
2361: ########################################################################################################*/
2362:
2363: lv_source_ar := jai_constants.source_ar ;
2364:
2365: lv_process_flag := jai_constants.successful ;
2366: lv_process_message := null ;
2367:

Line 2365: lv_process_flag := jai_constants.successful ;

2361: ########################################################################################################*/
2362:
2363: lv_source_ar := jai_constants.source_ar ;
2364:
2365: lv_process_flag := jai_constants.successful ;
2366: lv_process_message := null ;
2367:
2368: p_process_flag := lv_process_flag ;
2369: p_process_message := lv_process_message ;

Line 2401: IF lv_process_flag = jai_constants.expected_error OR

2397: );
2398:
2399:
2400:
2401: IF lv_process_flag = jai_constants.expected_error OR
2402: lv_process_flag = jai_constants.unexpected_error
2403: THEN
2404: /*
2405: || As Returned status is an error hence:-

Line 2402: lv_process_flag = jai_constants.unexpected_error

2398:
2399:
2400:
2401: IF lv_process_flag = jai_constants.expected_error OR
2402: lv_process_flag = jai_constants.unexpected_error
2403: THEN
2404: /*
2405: || As Returned status is an error hence:-
2406: || Set out variables p_process_flag and p_process_message accordingly

Line 2441: IF lv_process_flag = jai_constants.expected_error OR

2437: p_process_flag => lv_process_flag ,
2438: p_process_message => lv_process_message
2439: );
2440:
2441: IF lv_process_flag = jai_constants.expected_error OR
2442: lv_process_flag = jai_constants.unexpected_error
2443: THEN
2444: /*
2445: || As Returned status is an error hence:-

Line 2442: lv_process_flag = jai_constants.unexpected_error

2438: p_process_message => lv_process_message
2439: );
2440:
2441: IF lv_process_flag = jai_constants.expected_error OR
2442: lv_process_flag = jai_constants.unexpected_error
2443: THEN
2444: /*
2445: || As Returned status is an error hence:-
2446: || Set out variables p_process_flag and p_process_message accordingly

Line 2480: IF lv_process_flag = jai_constants.expected_error OR

2476: p_process_message => lv_process_message
2477: );
2478:
2479:
2480: IF lv_process_flag = jai_constants.expected_error OR
2481: lv_process_flag = jai_constants.unexpected_error
2482: THEN
2483: /*
2484: || As Returned status is an error hence:-

Line 2481: lv_process_flag = jai_constants.unexpected_error

2477: );
2478:
2479:
2480: IF lv_process_flag = jai_constants.expected_error OR
2481: lv_process_flag = jai_constants.unexpected_error
2482: THEN
2483: /*
2484: || As Returned status is an error hence:-
2485: || Set out variables p_process_flag and p_process_message accordingly

Line 2517: IF lv_process_flag = jai_constants.expected_error OR

2513: p_process_flag => lv_process_flag ,
2514: p_process_message => lv_process_message
2515: );
2516:
2517: IF lv_process_flag = jai_constants.expected_error OR
2518: lv_process_flag = jai_constants.unexpected_error
2519: THEN
2520: /*
2521: || As Returned status is an error hence:-

Line 2518: lv_process_flag = jai_constants.unexpected_error

2514: p_process_message => lv_process_message
2515: );
2516:
2517: IF lv_process_flag = jai_constants.expected_error OR
2518: lv_process_flag = jai_constants.unexpected_error
2519: THEN
2520: /*
2521: || As Returned status is an error hence:-
2522: || Set out variables p_process_flag and p_process_message accordingly

Line 2538: lv_process_flag := jai_constants.unexpected_error;

2534: fnd_file.put_line(fnd_file.LOG,'############################## 15 END OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS - ##############################');
2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: lv_process_flag := jai_constants.unexpected_error;
2539: lv_process_message := ' 16 Unexpected error occured while processing jai_ar_rgm_processing_pkg.process_records'||SQLERRM ;
2540:
2541: END process_records;
2542: