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_OM_WSH_LINES_ALL

Line 74: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,

70:
71: PROCEDURE process (
72: retcode OUT NOCOPY VARCHAR2,
73: errbuf OUT NOCOPY VARCHAR2,
74: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

Line 75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,

71: PROCEDURE process (
72: retcode OUT NOCOPY VARCHAR2,
73: errbuf OUT NOCOPY VARCHAR2,
74: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
79: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

Line 78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

74: p_organization_id JAI_OM_WSH_LINES_ALL.ORGANIZATION_ID%TYPE,
75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
79: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
80: pv_delivery_date_from VARCHAR2,
81: pv_delivery_date_to VARCHAR2,
82: p_process_action VARCHAR2,

Line 79: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,

75: p_location_id JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE,
76: p_order_number_from OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
77: p_order_number_to OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE,
78: p_delivery_id_from JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
79: p_delivery_id_to JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE,
80: pv_delivery_date_from VARCHAR2,
81: pv_delivery_date_to VARCHAR2,
82: p_process_action VARCHAR2,
83: p_single_invoice_num VARCHAR2,

Line 126: ln_order_type_id JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID%TYPE;

122: ln_failure_delivery_ctr NUMBER;
123: ln_success_delivery_Ctr NUMBER;
124: ln_regime_id NUMBER;
125: lv_debug VARCHAR2(5);
126: ln_order_type_id JAI_OM_WSH_LINES_ALL.ORDER_TYPE_ID%TYPE;
127: lv_inv_num_already_generated VARCHAR2(10);
128: ln_batch_id NUMBER;
129:
130: ln_current_party_id NUMBER;

Line 414: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

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
415: table JAI_RGM_GST_INVOICE_GEN_T (vat_invoice_no => lv_vat_invoice_number
416: , vat_inv_gen_status => 'C');
417: */
418: IF lv_Debug = 'Y'

Line 444: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number

440: IF lv_Debug = 'Y' THEN
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

Line 451: UPDATE JAI_OM_WSH_LINES_ALL

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
455: , LAST_UPDATE_LOGIN = fnd_global.login_id

Line 482: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;

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;
483: */
484: IF lv_invoice_number IS NOT NULL
485: THEN
486: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.

Line 486: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.

482: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;
483: */
484: IF lv_invoice_number IS NOT NULL
485: THEN
486: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
487: UPDATE JAI_OM_WSH_LINES_ALL
488: SET GST_INVOICE_NO = lv_invoice_number,
489: GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
490: last_update_date = sysdate,

Line 487: UPDATE JAI_OM_WSH_LINES_ALL

483: */
484: IF lv_invoice_number IS NOT NULL
485: THEN
486: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
487: UPDATE JAI_OM_WSH_LINES_ALL
488: SET GST_INVOICE_NO = lv_invoice_number,
489: GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
490: last_update_date = sysdate,
491: last_update_login = fnd_global.login_id,

Line 553: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

549: END IF; -- lv_party_has_changed
550: ELSE -- single invoice number is false
551: /* generate new GST invoice number by document sequence;
552: 1. jai_cmn_rgm_setup_pkg.Gen_Invoice_number();
553: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update
554: table JAI_RGM_GST_INVOICE_GEN_T (vat_invoice_no => lv_vat_invoice_number,
555: vat_inv_gen_status => 'C');
556: */
557: IF lv_Debug = 'Y' THEN

Line 600: UPDATE JAI_OM_WSH_LINES_ALL

596: fnd_file.put_line(fnd_file.log,'ld_override_invoice_date:'||ld_override_invoice_date);
597:
598: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
599:
600: UPDATE JAI_OM_WSH_LINES_ALL
601: SET GST_INVOICE_NO =lv_invoice_number,
602: GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
603: last_update_date = sysdate,
604: last_update_login = fnd_global.login_id,

Line 662: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

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
663: table JAI_RGM_GST_INVOICE_GEN_T (vat_invoice_no => lv_invoice_number,
664: vat_inv_gen_status => 'C');
665: */
666: IF lv_Debug = 'Y'

Line 692: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number

688: IF lv_Debug = 'Y' THEN
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

Line 699: UPDATE JAI_OM_WSH_LINES_ALL

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
703: , LAST_UPDATE_LOGIN = fnd_global.login_id

Line 730: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;

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: */
732: IF lv_invoice_number IS NOT NULL THEN
733: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current non-shippable line.
734: UPDATE JAI_OM_WSH_LINES_ALL

Line 733: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current non-shippable line.

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: */
732: IF lv_invoice_number IS NOT NULL THEN
733: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current non-shippable line.
734: UPDATE JAI_OM_WSH_LINES_ALL
735: SET GST_INVOICE_NO = lv_invoice_number
736: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
737: , last_update_date = sysdate

Line 734: UPDATE JAI_OM_WSH_LINES_ALL

730: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;
731: */
732: IF lv_invoice_number IS NOT NULL THEN
733: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current non-shippable line.
734: UPDATE JAI_OM_WSH_LINES_ALL
735: SET GST_INVOICE_NO = lv_invoice_number
736: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
737: , last_update_date = sysdate
738: , last_update_login = fnd_global.login_id

Line 762: 2. if successful, update GST invoice number to JAI_OM_WSH_LINES_ALL, and update

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
763: table JAI_RGM_GST_INVOICE_GEN_T (vat_invoice_no => lv_vat_invoice_number,
764: vat_inv_gen_status => 'C');
765: */
766: IF lv_Debug = 'Y'

Line 792: -- check the return status and update the JAI_OM_WSH_LINES_ALL table to set the vat invoice number

788: IF lv_Debug = 'Y' THEN
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

Line 800: UPDATE JAI_OM_WSH_LINES_ALL

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
804: , LAST_UPDATE_LOGIN = fnd_global.login_id

Line 833: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;

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: */
835: IF lv_invoice_number IS NOT NULL THEN
836: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
837: UPDATE JAI_OM_WSH_LINES_ALL

Line 836: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.

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: */
835: IF lv_invoice_number IS NOT NULL THEN
836: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
837: UPDATE JAI_OM_WSH_LINES_ALL
838: SET GST_INVOICE_NO = lv_invoice_number
839: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
840: , last_update_date = sysdate

Line 837: UPDATE JAI_OM_WSH_LINES_ALL

833: 2. update JAI_OM_WSH_LINES_ALL and JAI_RGM_GST_INVOICE_GEN_T;
834: */
835: IF lv_invoice_number IS NOT NULL THEN
836: -- Update the vat_invoice_num field in JAI_OM_WSH_LINES_ALL table for the current delivery.
837: UPDATE JAI_OM_WSH_LINES_ALL
838: SET GST_INVOICE_NO = lv_invoice_number
839: , GST_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
840: , last_update_date = sysdate
841: , last_update_login = fnd_global.login_id