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_CMN_GST_INV_GEN_PKG dependencies on JAI_CONSTANTS

Line 197: lv_inv_num_already_generated := jai_constants.value_false;

193: /*
194: ||convert from canonical to date format
195: */
196: ld_override_invoice_date := fnd_date.canonical_to_date(p_override_invoice_date);
197: lv_inv_num_already_generated := jai_constants.value_false;
198: lv_debug := NVL(P_DEBUG,jai_constants.no);
199: ln_current_party_id := -9999;
200: ln_current_party_site_id := -9999;
201: ln_current_order_number := -9999;

Line 198: lv_debug := NVL(P_DEBUG,jai_constants.no);

194: ||convert from canonical to date format
195: */
196: ld_override_invoice_date := fnd_date.canonical_to_date(p_override_invoice_date);
197: lv_inv_num_already_generated := jai_constants.value_false;
198: lv_debug := NVL(P_DEBUG,jai_constants.no);
199: ln_current_party_id := -9999;
200: ln_current_party_site_id := -9999;
201: ln_current_order_number := -9999;
202:

Line 220: lv_inv_gen_process_flag := jai_constants.successful;

216: END IF;
217: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
218: ln_conc_request_id := FND_GLOBAL.conc_request_id;
219: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
220: lv_inv_gen_process_flag := jai_constants.successful;
221: lv_acct_process_flag := jai_constants.successful;
222: lv_inv_gen_process_message := NULL;
223: lv_acct_process_message := NULL;
224: ln_batch_id := ln_conc_request_id;

Line 221: lv_acct_process_flag := jai_constants.successful;

217: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
218: ln_conc_request_id := FND_GLOBAL.conc_request_id;
219: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
220: lv_inv_gen_process_flag := jai_constants.successful;
221: lv_acct_process_flag := jai_constants.successful;
222: lv_inv_gen_process_message := NULL;
223: lv_acct_process_message := NULL;
224: ln_batch_id := ln_conc_request_id;
225:

Line 323: lv_p_source := jai_constants.source_wsh;

319:
320: -- start processing records
321: IF mainrec.delivery_id IS NOT NULL -- for shippable line
322: THEN
323: lv_p_source := jai_constants.source_wsh;
324: ln_interface_status:= 0;
325: OPEN c_check_interface_status(mainrec.delivery_id);
326: FETCH c_check_interface_status into ln_interface_status;
327: CLOSE c_check_interface_status;

Line 342: lv_p_source := jai_constants.source_nsh;

338: IF lv_debug = 'Y' THEN
339: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Delivery - ' || mainrec.delivery_id);
340: END IF; -- lv_debug = 'Y'
341: ELSE -- else for non-shippable line
342: lv_p_source := jai_constants.source_nsh;
343: IF lv_debug = 'Y' THEN
344: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Processing Non-shippable Order Line - ' ||
345: mainrec.order_line_id);
346: END IF; -- lv_debug = 'Y'

Line 376: lv_party_has_changed := jai_constants.value_true;

372: || Hence a new loop needs to start
373: */
374: ln_current_party_id := mainrec.party_id;
375: ln_current_party_site_id := mainrec.party_site_id;
376: lv_party_has_changed := jai_constants.value_true;
377: lv_inv_num_already_generated :=jai_constants.value_false;--9772724
378: ELSE
379: lv_party_has_changed := jai_constants.value_false;
380: END IF; -- ln_current_party_id <> mainrec.party_id OR ... ...

Line 377: lv_inv_num_already_generated :=jai_constants.value_false;--9772724

373: */
374: ln_current_party_id := mainrec.party_id;
375: ln_current_party_site_id := mainrec.party_site_id;
376: lv_party_has_changed := jai_constants.value_true;
377: lv_inv_num_already_generated :=jai_constants.value_false;--9772724
378: ELSE
379: lv_party_has_changed := jai_constants.value_false;
380: END IF; -- ln_current_party_id <> mainrec.party_id OR ... ...
381:

Line 379: lv_party_has_changed := jai_constants.value_false;

375: ln_current_party_site_id := mainrec.party_site_id;
376: lv_party_has_changed := jai_constants.value_true;
377: lv_inv_num_already_generated :=jai_constants.value_false;--9772724
378: ELSE
379: lv_party_has_changed := jai_constants.value_false;
380: END IF; -- ln_current_party_id <> mainrec.party_id OR ... ...
381:
382:
383: OPEN c_inv_gen_status(mainrec.delivery_id,

Line 408: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true

404:
405: -- here comes the detail logic of GST generation for shippable and non-shippable lines
406: IF mainrec.delivery_id IS NOT NULL -- current is shippable line
407: THEN
408: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
409: THEN
410: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed
411: THEN
412: /* generate new GST invoice number by document sequence;

Line 410: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed

406: IF mainrec.delivery_id IS NOT NULL -- current is shippable line
407: THEN
408: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
409: THEN
410: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed
411: THEN
412: /* generate new GST invoice number by document sequence;
413: 1. jai_cmn_rgm_setup_pkg.Gen_Invoice_number();
414: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

Line 423: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)

419: THEN
420: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
421: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
422: END IF; -- lv_Debug = 'Y'
423: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
424: THEN
425: IF lv_inv_num_already_generated = jai_constants.value_false
426: THEN
427: IF lv_Debug = 'Y' THEN

Line 425: IF lv_inv_num_already_generated = jai_constants.value_false

421: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
422: END IF; -- lv_Debug = 'Y'
423: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
424: THEN
425: IF lv_inv_num_already_generated = jai_constants.value_false
426: THEN
427: IF lv_Debug = 'Y' THEN
428: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
429: END IF; -- lv_Debug = 'Y'

Line 445: IF lv_inv_gen_process_flag = jai_constants.successful

441: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number ||','|| lv_inv_gen_process_flag ||','||lv_inv_gen_process_message);
442: END IF; -- lv_Debug = 'Y'
443:
444: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
445: IF lv_inv_gen_process_flag = jai_constants.successful
446: THEN
447: IF lv_invoice_number IS NOT NULL
448: THEN
449: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;

Line 450: lv_inv_num_already_generated := jai_constants.value_true;

446: THEN
447: IF lv_invoice_number IS NOT NULL
448: THEN
449: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
450: lv_inv_num_already_generated := jai_constants.value_true;
451: UPDATE JAI_OM_WSH_LINES_ALL
452: SET GST_INVOICE_NO = lv_invoice_number
453: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
454: , LAST_UPDATE_DATE = sysdate

Line 470: lv_inv_gen_process_flag := jai_constants.unexpected_error;

466: , last_update_login = fnd_global.conc_login_id
467: , last_update_date = sysdate
468: WHERE delivery_id = mainrec.delivery_id;
469: ELSE
470: lv_inv_gen_process_flag := jai_constants.unexpected_error;
471: lv_acct_process_flag := jai_constants.expected_error;
472: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
473: END IF; -- lv_vat_invoice_number IS NOT NULL
474: ELSE

Line 471: lv_acct_process_flag := jai_constants.expected_error;

467: , last_update_date = sysdate
468: WHERE delivery_id = mainrec.delivery_id;
469: ELSE
470: lv_inv_gen_process_flag := jai_constants.unexpected_error;
471: lv_acct_process_flag := jai_constants.expected_error;
472: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
473: END IF; -- lv_vat_invoice_number IS NOT NULL
474: ELSE
475: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;

Line 476: END IF; -- lv_inv_gen_process_flag = jai_constants.successful

472: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
473: END IF; -- lv_vat_invoice_number IS NOT NULL
474: ELSE
475: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
476: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
477: END IF; -- lv_inv_num_already_generated = jai_constants.value_false
478: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
479:
480: ELSE -- party not change

Line 477: END IF; -- lv_inv_num_already_generated = jai_constants.value_false

473: END IF; -- lv_vat_invoice_number IS NOT NULL
474: ELSE
475: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
476: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
477: END IF; -- lv_inv_num_already_generated = jai_constants.value_false
478: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
479:
480: ELSE -- party not change
481: /* 1. use existing GST invoice number for this record;

Line 478: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)

474: ELSE
475: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
476: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
477: END IF; -- lv_inv_num_already_generated = jai_constants.value_false
478: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
479:
480: ELSE -- party not change
481: /* 1. use existing GST invoice number for this record;
482: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;

Line 586: IF lv_inv_gen_process_flag = jai_constants.successful

582: || lv_invoice_number || '+++');
583: Fnd_File.PUT_LINE(Fnd_File.LOG, ' +++ after call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with lv_inv_gen_process_flag = '
584: || lv_inv_gen_process_flag || 'lv_inv_gen_process_message '|| lv_inv_gen_process_message || '+++');
585: END IF; -- lv_Debug = 'Y'
586: IF lv_inv_gen_process_flag = jai_constants.successful
587: THEN
588:
589: IF lv_invoice_number IS NOT NULL
590: THEN

Line 621: lv_inv_gen_process_flag := jai_constants.unexpected_error;

617: WHERE delivery_id = mainrec.delivery_id;
618: commit;
619: ELSE
620:
621: lv_inv_gen_process_flag := jai_constants.unexpected_error;
622: lv_inv_gen_process_message := 'No GST Invoice Number Generated';
623: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
624: END IF; -- lv_vat_invoice_number IS NOT NULL
625: ELSE

Line 637: END IF; -- lv_inv_gen_process_flag = jai_constants.successful

633: last_update_login = fnd_global.conc_login_id,
634: last_update_date = sysdate
635: WHERE delivery_id = mainrec.delivery_id;
636: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
637: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
638: END IF; -- NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes
639: -- below logic is for non-shippable lines
640: ELSE -- current line is non-shippable line
641: IF ln_current_order_number <> mainrec.order_number

Line 638: END IF; -- NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes

634: last_update_date = sysdate
635: WHERE delivery_id = mainrec.delivery_id;
636: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
637: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
638: END IF; -- NVL(lv_Same_invoice_no,jai_constants.no) = jai_constants.yes
639: -- below logic is for non-shippable lines
640: ELSE -- current line is non-shippable line
641: IF ln_current_order_number <> mainrec.order_number
642: THEN

Line 648: lv_order_has_changed := jai_constants.value_true;

644: || There has been a change in order number .
645: || Hence a new loop needs to start
646: */
647: ln_current_order_number := mainrec.order_number;
648: lv_order_has_changed := jai_constants.value_true;
649: ELSE
650: lv_order_has_changed := jai_constants.value_false;
651: END IF; -- ln_current_order_number <> mainrec.order_number
652:

Line 650: lv_order_has_changed := jai_constants.value_false;

646: */
647: ln_current_order_number := mainrec.order_number;
648: lv_order_has_changed := jai_constants.value_true;
649: ELSE
650: lv_order_has_changed := jai_constants.value_false;
651: END IF; -- ln_current_order_number <> mainrec.order_number
652:
653: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
654: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);

Line 656: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true

652:
653: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
654: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);
655:
656: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
657: THEN
658: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed
659: THEN
660: /* generate new GST invoice number by document sequence;

Line 658: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed

654: Fnd_File.PUT_LINE(Fnd_File.LOG, ' p_single_invoice_num :' || p_single_invoice_num);
655:
656: IF NVL(p_single_invoice_num,jai_constants.No) = jai_constants.yes -- single invoice number is true
657: THEN
658: IF NVL(lv_party_has_changed,jai_constants.value_false) = jai_constants.value_true -- party has changed
659: THEN
660: /* generate new GST invoice number by document sequence;
661: 1. jai_cmn_rgm_setup_pkg.Gen_Invoice_number();
662: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

Line 671: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)

667: THEN
668: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_party_has_changed :' || lv_party_has_changed);
669: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
670: END IF; -- lv_Debug = 'Y'
671: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
672: THEN
673: --IF lv_inv_num_already_generated = jai_constants.value_false
674: --THEN
675: IF lv_Debug = 'Y' THEN

Line 673: --IF lv_inv_num_already_generated = jai_constants.value_false

669: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
670: END IF; -- lv_Debug = 'Y'
671: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
672: THEN
673: --IF lv_inv_num_already_generated = jai_constants.value_false
674: --THEN
675: IF lv_Debug = 'Y' THEN
676: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
677: END IF; -- lv_Debug = 'Y'

Line 693: IF lv_inv_gen_process_flag = jai_constants.successful

689: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
690: END IF; -- lv_Debug = 'Y'
691:
692: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
693: IF lv_inv_gen_process_flag = jai_constants.successful
694: THEN
695: IF lv_invoice_number IS NOT NULL
696: THEN
697: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;

Line 698: lv_inv_num_already_generated := jai_constants.value_true;

694: THEN
695: IF lv_invoice_number IS NOT NULL
696: THEN
697: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
698: lv_inv_num_already_generated := jai_constants.value_true;
699: UPDATE JAI_OM_WSH_LINES_ALL
700: SET GST_INVOICE_NO = lv_invoice_number
701: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
702: , LAST_UPDATE_DATE = sysdate

Line 719: lv_inv_gen_process_flag := jai_constants.unexpected_error;

715: , last_update_login = fnd_global.conc_login_id
716: , last_update_date = sysdate
717: WHERE order_line_id = mainrec.order_line_id;
718: ELSE
719: lv_inv_gen_process_flag := jai_constants.unexpected_error;
720: lv_acct_process_flag := jai_constants.expected_error;
721: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
722: END IF; -- lv_vat_invoice_number IS NOT NULL
723: ELSE

Line 720: lv_acct_process_flag := jai_constants.expected_error;

716: , last_update_date = sysdate
717: WHERE order_line_id = mainrec.order_line_id;
718: ELSE
719: lv_inv_gen_process_flag := jai_constants.unexpected_error;
720: lv_acct_process_flag := jai_constants.expected_error;
721: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
722: END IF; -- lv_vat_invoice_number IS NOT NULL
723: ELSE
724: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;

Line 725: END IF; -- lv_inv_gen_process_flag = jai_constants.successful

721: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
722: END IF; -- lv_vat_invoice_number IS NOT NULL
723: ELSE
724: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
725: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
726: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false
727: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
728: ELSE -- party not change
729: /* 1. use existing invoice number for this record;

Line 726: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false

722: END IF; -- lv_vat_invoice_number IS NOT NULL
723: ELSE
724: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
725: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
726: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false
727: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
728: ELSE -- party not change
729: /* 1. use existing invoice number for this record;
730: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;

Line 727: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)

723: ELSE
724: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
725: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
726: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false
727: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
728: ELSE -- party not change
729: /* 1. use existing invoice number for this record;
730: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;
731: */

Line 758: IF NVL(lv_order_has_changed,jai_constants.value_false) = jai_constants.value_true -- order number has changed

754: END IF; -- lv_party_has_changed
755: ELSE -- single invoice number is false
756: -- if single invoice number option is 'NO', then generate VAT invoice by Order Numbers
757:
758: IF NVL(lv_order_has_changed,jai_constants.value_false) = jai_constants.value_true -- order number has changed
759: THEN
760: /* generate new GST invoice number by document sequence;
761: 1. jai_cmn_rgm_setup_pkg.Gen_Invoice_number();
762: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

Line 771: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)

767: THEN
768: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_order_has_changed :' || lv_order_has_changed);
769: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
770: END IF; -- lv_Debug = 'Y'
771: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
772: THEN
773: --IF lv_inv_num_already_generated = jai_constants.value_false
774: --THEN
775: IF lv_Debug = 'Y' THEN

Line 773: --IF lv_inv_num_already_generated = jai_constants.value_false

769: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_num_already_generated :' || lv_inv_num_already_generated);
770: END IF; -- lv_Debug = 'Y'
771: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
772: THEN
773: --IF lv_inv_num_already_generated = jai_constants.value_false
774: --THEN
775: IF lv_Debug = 'Y' THEN
776: Fnd_File.PUT_LINE(Fnd_File.LOG, ' before call to jai_cmn_rgm_setup_pkg.Gen_Invoice_number with ln_order_type_id' || ln_order_type_id || 'date ' || mainrec.delivery_date );
777: END IF; -- lv_Debug = 'Y'

Line 793: IF lv_inv_gen_process_flag = jai_constants.successful

789: Fnd_File.PUT_LINE(Fnd_File.LOG, ' after call with lv_invoice_number:' || lv_invoice_number || lv_inv_gen_process_flag ||lv_inv_gen_process_message);
790: END IF; -- lv_Debug = 'Y'
791:
792: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number
793: IF lv_inv_gen_process_flag = jai_constants.successful
794: THEN
795: IF lv_invoice_number IS NOT NULL
796: THEN
797:

Line 799: lv_inv_num_already_generated := jai_constants.value_true;

795: IF lv_invoice_number IS NOT NULL
796: THEN
797:
798: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
799: lv_inv_num_already_generated := jai_constants.value_true;
800: UPDATE JAI_OM_WSH_LINES_ALL
801: SET GST_INVOICE_NO = lv_invoice_number
802: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
803: , LAST_UPDATE_DATE = sysdate

Line 820: lv_inv_gen_process_flag := jai_constants.unexpected_error;

816: , last_update_login = fnd_global.conc_login_id
817: , last_update_date = sysdate
818: WHERE order_line_id = mainrec.order_line_id;
819: ELSE
820: lv_inv_gen_process_flag := jai_constants.unexpected_error;
821: lv_acct_process_flag := jai_constants.expected_error;
822: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
823: END IF; -- lv_invoice_number IS NOT NULL
824:

Line 821: lv_acct_process_flag := jai_constants.expected_error;

817: , last_update_date = sysdate
818: WHERE order_line_id = mainrec.order_line_id;
819: ELSE
820: lv_inv_gen_process_flag := jai_constants.unexpected_error;
821: lv_acct_process_flag := jai_constants.expected_error;
822: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
823: END IF; -- lv_invoice_number IS NOT NULL
824:
825:

Line 828: END IF; -- lv_inv_gen_process_flag = jai_constants.successful

824:
825:
826: ELSE
827: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
828: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
829: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false
830: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
831: ELSE -- order number not change
832: /* 1. use existing gst invoice number for this record;

Line 829: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false

825:
826: ELSE
827: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
828: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
829: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false
830: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
831: ELSE -- order number not change
832: /* 1. use existing gst invoice number for this record;
833: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;

Line 830: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)

826: ELSE
827: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
828: END IF; -- lv_inv_gen_process_flag = jai_constants.successful
829: --END IF; -- lv_inv_num_already_generated = jai_constants.value_false
830: END IF; -- p_process_action in (jai_constants.om_action_gen_inv_n_accnt ,jai_constants.om_action_gen_invoice)
831: ELSE -- order number not change
832: /* 1. use existing gst invoice number for this record;
833: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;
834: */

Line 874: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt,jai_constants.om_action_gen_accounting) THEN

870: IF lv_debug = 'Y' THEN
871: Fnd_File.PUT_LINE(Fnd_File.LOG, ' In process accounting section with p_process_action = ' || p_process_action);
872: END IF;
873:
874: IF p_process_action in (jai_constants.om_action_gen_inv_n_accnt,jai_constants.om_action_gen_accounting) THEN
875: \*
876: || Only In case the parameter p_process_action in ('PROCESS ALL','PROCESS ACCOUNTING') AND
877: ||
878: *\

Line 888: IF lv_inv_gen_process_flag = jai_constants.successful THEN

884: END IF;
885: IF lv_Debug = 'Y' THEN
886: Fnd_File.PUT_LINE(Fnd_File.LOG, ' lv_inv_gen_process_flag = ' || lv_inv_gen_process_flag );
887: END IF;
888: IF lv_inv_gen_process_flag = jai_constants.successful THEN
889:
890: IF lv_vat_invoice_number IS NULL THEN
891: lv_vat_invoice_number:= mainrec.vat_invoice_no;
892: END IF;

Line 894: IF p_process_action = jai_constants.om_action_gen_accounting

890: IF lv_vat_invoice_number IS NULL THEN
891: lv_vat_invoice_number:= mainrec.vat_invoice_no;
892: END IF;
893:
894: IF p_process_action = jai_constants.om_action_gen_accounting
895: THEN
896: lv_vat_invoice_number := mainrec.vat_invoice_no;
897: END IF;
898:

Line 906: -- P_SOURCE => jai_constants.source_wsh ,

902: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice(
903: P_REGIME_ID => ln_regime_id ,
904: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
905: P_SOURCE => lv_p_source,
906: -- P_SOURCE => jai_constants.source_wsh ,
907: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
908: P_ORGANIZATION_ID => mainrec.organization_id,
909: P_LOCATION_ID => mainrec.location_id ,
910: P_DELIVERY_ID => mainrec.delivery_id ,

Line 927: IF lv_acct_process_flag = jai_constants.successful THEN

923: );
924: IF lv_Debug = 'Y' THEN
925: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after Call to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice with status = ' || lv_acct_process_flag);
926: END IF;
927: IF lv_acct_process_flag = jai_constants.successful THEN
928: \*
929: || If the control comes here it means that Accounting got processed successfully.
930: || Check here if Delivery for successfully processed and invoice got successfully processed
931: || and only then do a commit

Line 933: IF lv_inv_gen_process_flag = jai_constants.successful AND lv_acct_process_flag = jai_constants.successful THEN

929: || If the control comes here it means that Accounting got processed successfully.
930: || Check here if Delivery for successfully processed and invoice got successfully processed
931: || and only then do a commit
932: *\
933: IF lv_inv_gen_process_flag = jai_constants.successful AND lv_acct_process_flag = jai_constants.successful THEN
934: \*
935: || Both the activities have been succesfully completed
936: || Can commit the changes made to the delivery.
937: *\

Line 958: IF lv_inv_gen_process_flag <> jai_constants.successful OR lv_acct_process_flag <> jai_constants.successful THEN

954: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
955: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered after call to process_order_invoice is ' || lv_acct_process_message);
956: END IF;
957:
958: IF lv_inv_gen_process_flag <> jai_constants.successful OR lv_acct_process_flag <> jai_constants.successful THEN
959:
960: \*
961: || There have been some errors which have happened during accounting
962: *\

Line 965: IF lv_inv_gen_process_flag <> jai_constants.successful THEN

961: || There have been some errors which have happened during accounting
962: *\
963: ROLLBACK;
964:
965: IF lv_inv_gen_process_flag <> jai_constants.successful THEN
966: UPDATE JAI_RGM_GST_INVOICE_GEN_T
967: SET vat_inv_gen_err_message = substr(lv_inv_gen_process_message,1,1000),
968: vat_inv_gen_status = 'E',
969: request_id = ln_conc_request_id, \*following columns added by srjayara for bug 4702156*\

Line 981: IF lv_acct_process_flag <> jai_constants.successful THEN

977: OR order_line_id = NVL(mainrec.order_line_id, -1);
978: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
979: END IF;
980:
981: IF lv_acct_process_flag <> jai_constants.successful THEN
982: UPDATE JAI_RGM_GST_INVOICE_GEN_T
983: SET vat_acct_err_message = substr(lv_acct_process_message,1,1000),
984: vat_acct_status = 'E',
985: request_id = ln_conc_request_id, \*following columns added by srjayara for bug 4702156*\

Line 999: END IF; \* END IF For IF lv_inv_gen_process_flag = jai_constants.successful THEN *\

995: END IF;
996: COMMIT;
997: END IF;
998:
999: END IF; \* END IF For IF lv_inv_gen_process_flag = jai_constants.successful THEN *\
1000: END IF; \* END IF For IF p_process_action in ('ALL','PROCESS ACCOUNTING') THEN *\*/
1001: <>
1002: NULL;
1003: END LOOP;

Line 1061: lv_inv_gen_process_flag := jai_constants.unexpected_error;

1057: RETCODE := '2';
1058: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
1059: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
1060: ERRBUF := substr(sqlerrm,1,1000);
1061: lv_inv_gen_process_flag := jai_constants.unexpected_error;
1062: lv_acct_process_flag := jai_constants.unexpected_error;
1063: lv_inv_gen_process_message := sqlerrm;
1064: lv_acct_process_message := sqlerrm;
1065:

Line 1062: lv_acct_process_flag := jai_constants.unexpected_error;

1058: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
1059: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
1060: ERRBUF := substr(sqlerrm,1,1000);
1061: lv_inv_gen_process_flag := jai_constants.unexpected_error;
1062: lv_acct_process_flag := jai_constants.unexpected_error;
1063: lv_inv_gen_process_message := sqlerrm;
1064: lv_acct_process_message := sqlerrm;
1065:
1066: END PROCESS;

Line 1070: gn_cgst_regime_id := JAI_GST_GENERAL_PKG.get_regime_id(jai_constants.cgst_regime);

1066: END PROCESS;
1067:
1068: BEGIN
1069:
1070: gn_cgst_regime_id := JAI_GST_GENERAL_PKG.get_regime_id(jai_constants.cgst_regime);
1071: gn_sgst_regime_id := JAI_GST_GENERAL_PKG.get_regime_id(jai_constants.sgst_regime);
1072:
1073: end jai_cmn_gst_inv_gen_pkg;

Line 1071: gn_sgst_regime_id := JAI_GST_GENERAL_PKG.get_regime_id(jai_constants.sgst_regime);

1067:
1068: BEGIN
1069:
1070: gn_cgst_regime_id := JAI_GST_GENERAL_PKG.get_regime_id(jai_constants.cgst_regime);
1071: gn_sgst_regime_id := JAI_GST_GENERAL_PKG.get_regime_id(jai_constants.sgst_regime);
1072:
1073: end jai_cmn_gst_inv_gen_pkg;