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 FND_GLOBAL

Line 217: ln_conc_progam_id := FND_GLOBAL.conc_program_id;

213: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
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;

Line 218: ln_conc_request_id := FND_GLOBAL.conc_request_id;

214: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
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;

Line 219: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;

215: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
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;

Line 455: , LAST_UPDATE_LOGIN = fnd_global.login_id

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
456: , LAST_UPDATED_BY = fnd_global.user_id
457: WHERE DELIVERY_ID = mainrec.delivery_id;
458:
459: UPDATE JAI_RGM_GST_INVOICE_GEN_T

Line 456: , LAST_UPDATED_BY = fnd_global.user_id

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
456: , LAST_UPDATED_BY = fnd_global.user_id
457: WHERE DELIVERY_ID = mainrec.delivery_id;
458:
459: UPDATE JAI_RGM_GST_INVOICE_GEN_T
460: SET gst_invoice_no =lv_invoice_number

Line 466: , last_update_login = fnd_global.conc_login_id

462: , gst_inv_gen_err_message = NULL
463: , request_id = ln_conc_request_id
464: , program_id = ln_conc_progam_id
465: , program_application_id = ln_conc_prog_appl_id
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;

Line 491: last_update_login = fnd_global.login_id,

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,
492: last_updated_by = fnd_global.user_id
493: WHERE delivery_id IN (SELECT delivery_id
494: FROM JAI_RGM_GST_INVOICE_GEN_T jrigt
495: WHERE party_id = ln_current_party_id

Line 492: last_updated_by = fnd_global.user_id

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,
492: last_updated_by = fnd_global.user_id
493: WHERE delivery_id IN (SELECT delivery_id
494: FROM JAI_RGM_GST_INVOICE_GEN_T jrigt
495: WHERE party_id = ln_current_party_id
496: AND party_site_id = ln_current_party_site_id

Line 521: last_update_login = fnd_global.conc_login_id

517: gst_inv_gen_err_message = NULL,
518: request_id = ln_conc_request_id,
519: program_id = ln_conc_progam_id,
520: program_application_id = ln_conc_prog_appl_id,
521: last_update_login = fnd_global.conc_login_id
522: WHERE delivery_id IN (SELECT delivery_id
523: FROM JAI_RGM_GST_INVOICE_GEN_T jrigt
524: WHERE party_id = ln_current_party_id
525: AND party_site_id = ln_current_party_site_id

Line 604: last_update_login = fnd_global.login_id,

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,
605: last_updated_by = fnd_global.user_id
606: WHERE delivery_id = mainrec.delivery_id;
607:
608: UPDATE JAI_RGM_GST_INVOICE_GEN_T

Line 605: last_updated_by = fnd_global.user_id

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,
605: last_updated_by = fnd_global.user_id
606: WHERE delivery_id = mainrec.delivery_id;
607:
608: UPDATE JAI_RGM_GST_INVOICE_GEN_T
609: SET gst_invoice_no = lv_invoice_number,

Line 615: last_update_login = fnd_global.conc_login_id,

611: gst_inv_gen_err_message = NULL,
612: request_id = ln_conc_request_id,
613: program_id = ln_conc_progam_id,
614: program_application_id = ln_conc_prog_appl_id,
615: last_update_login = fnd_global.conc_login_id,
616: last_update_date = sysdate
617: WHERE delivery_id = mainrec.delivery_id;
618: commit;
619: ELSE

Line 633: last_update_login = fnd_global.conc_login_id,

629: gst_inv_gen_err_message = substr(lv_inv_gen_process_message,1,1000),
630: request_id = ln_conc_request_id,
631: program_id = ln_conc_progam_id,
632: program_application_id = ln_conc_prog_appl_id,
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

Line 703: , LAST_UPDATE_LOGIN = fnd_global.login_id

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
704: , LAST_UPDATED_BY = fnd_global.user_id
705: WHERE order_line_id = mainrec.order_line_id
706: AND delivery_id IS NULL;
707:

Line 704: , LAST_UPDATED_BY = fnd_global.user_id

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
704: , LAST_UPDATED_BY = fnd_global.user_id
705: WHERE order_line_id = mainrec.order_line_id
706: AND delivery_id IS NULL;
707:
708: UPDATE JAI_RGM_GST_INVOICE_GEN_T

Line 715: , last_update_login = fnd_global.conc_login_id

711: , gst_inv_gen_err_message = NULL
712: , request_id = ln_conc_request_id
713: , program_id = ln_conc_progam_id
714: , program_application_id = ln_conc_prog_appl_id
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;

Line 738: , last_update_login = fnd_global.login_id

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
739: , last_updated_by = fnd_global.user_id
740: WHERE order_line_id = mainrec.order_line_id
741: AND delivery_id IS NULL;
742:

Line 739: , last_updated_by = fnd_global.user_id

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
739: , last_updated_by = fnd_global.user_id
740: WHERE order_line_id = mainrec.order_line_id
741: AND delivery_id IS NULL;
742:
743: UPDATE JAI_RGM_GST_INVOICE_GEN_T

Line 749: , last_update_login = fnd_global.conc_login_id

745: , gst_inv_gen_status = 'C'
746: , request_id = ln_conc_request_id
747: , program_id = ln_conc_progam_id
748: , program_application_id = ln_conc_prog_appl_id
749: , last_update_login = fnd_global.conc_login_id
750: WHERE order_line_id = mainrec.order_line_id;
751:
752: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1 ;
753: END IF; -- lv_invoice_number IS NOT NULL

Line 804: , LAST_UPDATE_LOGIN = fnd_global.login_id

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
805: , LAST_UPDATED_BY = fnd_global.user_id
806: WHERE order_line_id = mainrec.order_line_id
807: AND delivery_id IS NULL;
808:

Line 805: , LAST_UPDATED_BY = fnd_global.user_id

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
805: , LAST_UPDATED_BY = fnd_global.user_id
806: WHERE order_line_id = mainrec.order_line_id
807: AND delivery_id IS NULL;
808:
809: UPDATE JAI_RGM_GST_INVOICE_GEN_T

Line 816: , last_update_login = fnd_global.conc_login_id

812: ,gst_inv_gen_err_message = NULL
813: , request_id = ln_conc_request_id
814: , program_id = ln_conc_progam_id
815: , program_application_id = ln_conc_prog_appl_id
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;

Line 841: , last_update_login = fnd_global.login_id

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
842: , last_updated_by = fnd_global.user_id
843: WHERE order_line_id = mainrec.order_line_id
844: AND delivery_id IS NULL;
845:

Line 842: , last_updated_by = fnd_global.user_id

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
842: , last_updated_by = fnd_global.user_id
843: WHERE order_line_id = mainrec.order_line_id
844: AND delivery_id IS NULL;
845:
846: UPDATE JAI_RGM_GST_INVOICE_GEN_T

Line 853: , last_update_login = fnd_global.conc_login_id

849: , gst_inv_gen_err_message = NULL
850: , request_id = ln_conc_request_id
851: , program_id = ln_conc_progam_id
852: , program_application_id = ln_conc_prog_appl_id
853: , last_update_login = fnd_global.conc_login_id
854: WHERE order_line_id = mainrec.order_line_id;
855:
856: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
857: END IF; -- lv_vat_invoice_number IS NOT NULL

Line 944: last_update_login = fnd_global.conc_login_id,

940: vat_inv_gen_err_message = NULL, \*following columns added by srjayara for bug 4702156*\
941: request_id = ln_conc_request_id,
942: program_id = ln_conc_progam_id,
943: program_application_id = ln_conc_prog_appl_id,
944: last_update_login = fnd_global.conc_login_id,
945: last_update_date = sysdate
946: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
947: -- WHERE delivery_id = mainrec.delivery_id;
948: WHERE delivery_id = NVL(mainrec.delivery_id, -1)

Line 972: last_update_login = fnd_global.conc_login_id,

968: vat_inv_gen_status = 'E',
969: request_id = ln_conc_request_id, \*following columns added by srjayara for bug 4702156*\
970: program_id = ln_conc_progam_id,
971: program_application_id = ln_conc_prog_appl_id,
972: last_update_login = fnd_global.conc_login_id,
973: last_update_date = sysdate
974: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
975: -- WHERE delivery_id = mainrec.delivery_id;
976: WHERE delivery_id = NVL(mainrec.delivery_id, -1)

Line 988: last_update_login = fnd_global.conc_login_id,

984: vat_acct_status = 'E',
985: request_id = ln_conc_request_id, \*following columns added by srjayara for bug 4702156*\
986: program_id = ln_conc_progam_id,
987: program_application_id = ln_conc_prog_appl_id,
988: last_update_login = fnd_global.conc_login_id,
989: last_update_date = sysdate
990: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
991: -- WHERE delivery_id = mainrec.delivery_id;
992: WHERE delivery_id = NVL(mainrec.delivery_id, -1)