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_RGM_PROCESSING_PKG dependencies on FND_GLOBAL

Line 481: FND_GLOBAL.user_id,

477: p_rgm_registration_num,
478: p_trx_from_date,
479: p_trx_till_date,
480: sysdate,
481: FND_GLOBAL.user_id,
482: sysdate,
483: fnd_global.user_id,
484: fnd_global.login_id,
485: fnd_profile.value('PROG_APPL_ID'),

Line 483: fnd_global.user_id,

479: p_trx_till_date,
480: sysdate,
481: FND_GLOBAL.user_id,
482: sysdate,
483: fnd_global.user_id,
484: fnd_global.login_id,
485: fnd_profile.value('PROG_APPL_ID'),
486: fnd_profile.value('CONC_PROGRAM_ID'),
487: fnd_profile.value('CONC_LOGIN_ID')

Line 484: fnd_global.login_id,

480: sysdate,
481: FND_GLOBAL.user_id,
482: sysdate,
483: fnd_global.user_id,
484: fnd_global.login_id,
485: fnd_profile.value('PROG_APPL_ID'),
486: fnd_profile.value('CONC_PROGRAM_ID'),
487: fnd_profile.value('CONC_LOGIN_ID')
488: ) RETURNING batch_id INTO p_batch_id;

Line 3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;

3332: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;
3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
3337: ln_conc_request_id := FND_GLOBAL.conc_request_id;
3338: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
3339: lv_inv_gen_process_flag := jai_constants.successful;
3340: lv_acct_process_flag := jai_constants.successful;

Line 3337: ln_conc_request_id := FND_GLOBAL.conc_request_id;

3333: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;
3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
3337: ln_conc_request_id := FND_GLOBAL.conc_request_id;
3338: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
3339: lv_inv_gen_process_flag := jai_constants.successful;
3340: lv_acct_process_flag := jai_constants.successful;
3341: lv_inv_gen_process_message := NULL;

Line 3338: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;

3334: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
3335: END IF;
3336: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
3337: ln_conc_request_id := FND_GLOBAL.conc_request_id;
3338: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
3339: lv_inv_gen_process_flag := jai_constants.successful;
3340: lv_acct_process_flag := jai_constants.successful;
3341: lv_inv_gen_process_message := NULL;
3342: lv_acct_process_message := NULL;

Line 3632: , last_update_login = fnd_global.conc_login_id

3628: , vat_inv_gen_err_message = NULL
3629: , request_id = ln_conc_request_id
3630: , program_id = ln_conc_progam_id
3631: , program_application_id = ln_conc_prog_appl_id
3632: , last_update_login = fnd_global.conc_login_id
3633: , last_update_Date = sysdate
3634: WHERE Delivery_id = mainrec.delivery_id;
3635:
3636: IF lv_debug = 'Y' THEN

Line 3713: , LAST_UPDATE_LOGIN = fnd_global.login_id

3709: UPDATE JAI_OM_WSH_LINES_ALL
3710: SET VAT_INVOICE_NO = lv_vat_invoice_number
3711: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
3712: , LAST_UPDATE_DATE = sysdate
3713: , LAST_UPDATE_LOGIN = fnd_global.login_id
3714: , LAST_UPDATED_BY = fnd_global.user_id
3715: WHERE DELIVERY_ID = mainrec.delivery_id;
3716:
3717: UPDATE JAI_RGM_INVOICE_GEN_T

Line 3714: , LAST_UPDATED_BY = fnd_global.user_id

3710: SET VAT_INVOICE_NO = lv_vat_invoice_number
3711: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
3712: , LAST_UPDATE_DATE = sysdate
3713: , LAST_UPDATE_LOGIN = fnd_global.login_id
3714: , LAST_UPDATED_BY = fnd_global.user_id
3715: WHERE DELIVERY_ID = mainrec.delivery_id;
3716:
3717: UPDATE JAI_RGM_INVOICE_GEN_T
3718: SET vat_invoice_no = lv_vat_invoice_number

Line 3723: , last_update_login = fnd_global.conc_login_id

3719: , vat_inv_gen_status = 'C'
3720: , request_id = ln_conc_request_id
3721: , program_id = ln_conc_progam_id
3722: , program_application_id = ln_conc_prog_appl_id
3723: , last_update_login = fnd_global.conc_login_id
3724: , last_update_date = sysdate
3725: WHERE delivery_id = mainrec.delivery_id;
3726: ELSE
3727: lv_inv_gen_process_flag := jai_constants.unexpected_error;

Line 3748: last_update_login = fnd_global.login_id,

3744: UPDATE JAI_OM_WSH_LINES_ALL
3745: SET vat_invoice_no = lv_vat_invoice_number,
3746: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
3747: last_update_date = sysdate,
3748: last_update_login = fnd_global.login_id,
3749: last_updated_by = fnd_global.user_id
3750: WHERE delivery_id IN (SELECT delivery_id
3751: FROM JAI_RGM_INVOICE_GEN_T jrigt
3752: WHERE party_id = ln_current_party_id

Line 3749: last_updated_by = fnd_global.user_id

3745: SET vat_invoice_no = lv_vat_invoice_number,
3746: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
3747: last_update_date = sysdate,
3748: last_update_login = fnd_global.login_id,
3749: last_updated_by = fnd_global.user_id
3750: WHERE delivery_id IN (SELECT delivery_id
3751: FROM JAI_RGM_INVOICE_GEN_T jrigt
3752: WHERE party_id = ln_current_party_id
3753: AND party_site_id = ln_current_party_site_id

Line 3777: last_update_login = fnd_global.conc_login_id

3773: vat_inv_gen_status = 'C',
3774: request_id = ln_conc_request_id,
3775: program_id = ln_conc_progam_id,
3776: program_application_id = ln_conc_prog_appl_id,
3777: last_update_login = fnd_global.conc_login_id
3778: WHERE delivery_id IN (SELECT delivery_id
3779: FROM JAI_RGM_INVOICE_GEN_T jrigt
3780: WHERE party_id = ln_current_party_id
3781: AND party_site_id = ln_current_party_site_id

Line 3856: last_update_login = fnd_global.login_id,

3852: UPDATE JAI_OM_WSH_LINES_ALL
3853: SET vat_invoice_no = lv_vat_invoice_number,
3854: vat_invoice_date = nvl(ld_override_invoice_date ,sysdate),
3855: last_update_date = sysdate,
3856: last_update_login = fnd_global.login_id,
3857: last_updated_by = fnd_global.user_id
3858: WHERE delivery_id = mainrec.delivery_id;
3859:
3860: UPDATE JAI_RGM_INVOICE_GEN_T

Line 3857: last_updated_by = fnd_global.user_id

3853: SET vat_invoice_no = lv_vat_invoice_number,
3854: vat_invoice_date = nvl(ld_override_invoice_date ,sysdate),
3855: last_update_date = sysdate,
3856: last_update_login = fnd_global.login_id,
3857: last_updated_by = fnd_global.user_id
3858: WHERE delivery_id = mainrec.delivery_id;
3859:
3860: UPDATE JAI_RGM_INVOICE_GEN_T
3861: SET vat_invoice_no = lv_vat_invoice_number,

Line 3867: last_update_login = fnd_global.conc_login_id,

3863: vat_inv_gen_err_message = NULL ,
3864: request_id = ln_conc_request_id,
3865: program_id = ln_conc_progam_id,
3866: program_application_id = ln_conc_prog_appl_id,
3867: last_update_login = fnd_global.conc_login_id,
3868: last_update_date = sysdate
3869: WHERE delivery_id = mainrec.delivery_id;
3870:
3871: ELSE

Line 3883: last_update_login = fnd_global.conc_login_id,

3879: vat_inv_gen_status = 'E',
3880: request_id = ln_conc_request_id,
3881: program_id = ln_conc_progam_id,
3882: program_application_id = ln_conc_prog_appl_id,
3883: last_update_login = fnd_global.conc_login_id,
3884: last_update_date = sysdate
3885: WHERE delivery_id = mainrec.delivery_id;
3886: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
3887: END IF; -- lv_inv_gen_process_flag = jai_constants.successful

Line 3949: , last_update_login = fnd_global.conc_login_id

3945: , vat_inv_gen_err_message = NULL
3946: , request_id = ln_conc_request_id
3947: , program_id = ln_conc_progam_id
3948: , program_application_id = ln_conc_prog_appl_id
3949: , last_update_login = fnd_global.conc_login_id
3950: , last_update_Date = sysdate
3951: WHERE order_line_id = mainrec.order_line_id;
3952:
3953: IF lv_debug = 'Y' THEN

Line 4022: , LAST_UPDATE_LOGIN = fnd_global.login_id

4018: UPDATE JAI_OM_WSH_LINES_ALL
4019: SET VAT_INVOICE_NO = lv_vat_invoice_number
4020: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4021: , LAST_UPDATE_DATE = sysdate
4022: , LAST_UPDATE_LOGIN = fnd_global.login_id
4023: , LAST_UPDATED_BY = fnd_global.user_id
4024: WHERE order_line_id = mainrec.order_line_id
4025: AND delivery_id IS NULL;
4026:

Line 4023: , LAST_UPDATED_BY = fnd_global.user_id

4019: SET VAT_INVOICE_NO = lv_vat_invoice_number
4020: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4021: , LAST_UPDATE_DATE = sysdate
4022: , LAST_UPDATE_LOGIN = fnd_global.login_id
4023: , LAST_UPDATED_BY = fnd_global.user_id
4024: WHERE order_line_id = mainrec.order_line_id
4025: AND delivery_id IS NULL;
4026:
4027: UPDATE JAI_RGM_INVOICE_GEN_T

Line 4033: , last_update_login = fnd_global.conc_login_id

4029: , vat_inv_gen_status = 'C'
4030: , request_id = ln_conc_request_id
4031: , program_id = ln_conc_progam_id
4032: , program_application_id = ln_conc_prog_appl_id
4033: , last_update_login = fnd_global.conc_login_id
4034: , last_update_date = sysdate
4035: WHERE order_line_id = mainrec.order_line_id;
4036: ELSE
4037: lv_inv_gen_process_flag := jai_constants.unexpected_error;

Line 4056: , last_update_login = fnd_global.login_id

4052: UPDATE JAI_OM_WSH_LINES_ALL
4053: SET vat_invoice_no = lv_vat_invoice_number
4054: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4055: , last_update_date = sysdate
4056: , last_update_login = fnd_global.login_id
4057: , last_updated_by = fnd_global.user_id
4058: WHERE order_line_id = mainrec.order_line_id
4059: AND delivery_id IS NULL;
4060:

Line 4057: , last_updated_by = fnd_global.user_id

4053: SET vat_invoice_no = lv_vat_invoice_number
4054: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4055: , last_update_date = sysdate
4056: , last_update_login = fnd_global.login_id
4057: , last_updated_by = fnd_global.user_id
4058: WHERE order_line_id = mainrec.order_line_id
4059: AND delivery_id IS NULL;
4060:
4061: UPDATE JAI_RGM_INVOICE_GEN_T

Line 4067: , last_update_login = fnd_global.conc_login_id

4063: , vat_inv_gen_status = 'C'
4064: , request_id = ln_conc_request_id
4065: , program_id = ln_conc_progam_id
4066: , program_application_id = ln_conc_prog_appl_id
4067: , last_update_login = fnd_global.conc_login_id
4068: WHERE order_line_id = mainrec.order_line_id;
4069:
4070: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1 ;
4071: END IF; -- lv_vat_invoice_number IS NOT NULL

Line 4121: , LAST_UPDATE_LOGIN = fnd_global.login_id

4117: UPDATE JAI_OM_WSH_LINES_ALL
4118: SET VAT_INVOICE_NO = lv_vat_invoice_number
4119: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4120: , LAST_UPDATE_DATE = sysdate
4121: , LAST_UPDATE_LOGIN = fnd_global.login_id
4122: , LAST_UPDATED_BY = fnd_global.user_id
4123: WHERE order_line_id = mainrec.order_line_id
4124: AND delivery_id IS NULL;
4125:

Line 4122: , LAST_UPDATED_BY = fnd_global.user_id

4118: SET VAT_INVOICE_NO = lv_vat_invoice_number
4119: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4120: , LAST_UPDATE_DATE = sysdate
4121: , LAST_UPDATE_LOGIN = fnd_global.login_id
4122: , LAST_UPDATED_BY = fnd_global.user_id
4123: WHERE order_line_id = mainrec.order_line_id
4124: AND delivery_id IS NULL;
4125:
4126: UPDATE JAI_RGM_INVOICE_GEN_T

Line 4132: , last_update_login = fnd_global.conc_login_id

4128: , vat_inv_gen_status = 'C'
4129: , request_id = ln_conc_request_id
4130: , program_id = ln_conc_progam_id
4131: , program_application_id = ln_conc_prog_appl_id
4132: , last_update_login = fnd_global.conc_login_id
4133: , last_update_date = sysdate
4134: WHERE order_line_id = mainrec.order_line_id;
4135: ELSE
4136: lv_inv_gen_process_flag := jai_constants.unexpected_error;

Line 4155: , last_update_login = fnd_global.login_id

4151: UPDATE JAI_OM_WSH_LINES_ALL
4152: SET vat_invoice_no = lv_vat_invoice_number
4153: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4154: , last_update_date = sysdate
4155: , last_update_login = fnd_global.login_id
4156: , last_updated_by = fnd_global.user_id
4157: WHERE order_line_id = mainrec.order_line_id
4158: AND delivery_id IS NULL;
4159:

Line 4156: , last_updated_by = fnd_global.user_id

4152: SET vat_invoice_no = lv_vat_invoice_number
4153: , VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate)
4154: , last_update_date = sysdate
4155: , last_update_login = fnd_global.login_id
4156: , last_updated_by = fnd_global.user_id
4157: WHERE order_line_id = mainrec.order_line_id
4158: AND delivery_id IS NULL;
4159:
4160: UPDATE JAI_RGM_INVOICE_GEN_T

Line 4166: , last_update_login = fnd_global.conc_login_id

4162: , vat_inv_gen_status = 'C'
4163: , request_id = ln_conc_request_id
4164: , program_id = ln_conc_progam_id
4165: , program_application_id = ln_conc_prog_appl_id
4166: , last_update_login = fnd_global.conc_login_id
4167: WHERE order_line_id = mainrec.order_line_id;
4168:
4169: ln_success_delivery_Ctr := NVL(ln_success_Delivery_Ctr,0) + 1;
4170: END IF; -- lv_vat_invoice_number IS NOT NULL

Line 4255: last_update_login = fnd_global.conc_login_id,

4251: vat_inv_gen_err_message = NULL, /*following columns added by srjayara for bug 4702156*/
4252: request_id = ln_conc_request_id,
4253: program_id = ln_conc_progam_id,
4254: program_application_id = ln_conc_prog_appl_id,
4255: last_update_login = fnd_global.conc_login_id,
4256: last_update_date = sysdate
4257: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
4258: -- WHERE delivery_id = mainrec.delivery_id;
4259: WHERE delivery_id = NVL(mainrec.delivery_id, -1)

Line 4283: last_update_login = fnd_global.conc_login_id,

4279: vat_inv_gen_status = 'E',
4280: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
4281: program_id = ln_conc_progam_id,
4282: program_application_id = ln_conc_prog_appl_id,
4283: last_update_login = fnd_global.conc_login_id,
4284: last_update_date = sysdate
4285: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
4286: -- WHERE delivery_id = mainrec.delivery_id;
4287: WHERE delivery_id = NVL(mainrec.delivery_id, -1)

Line 4299: last_update_login = fnd_global.conc_login_id,

4295: vat_acct_status = 'E',
4296: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
4297: program_id = ln_conc_progam_id,
4298: program_application_id = ln_conc_prog_appl_id,
4299: last_update_login = fnd_global.conc_login_id,
4300: last_update_date = sysdate
4301: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
4302: -- WHERE delivery_id = mainrec.delivery_id;
4303: WHERE delivery_id = NVL(mainrec.delivery_id, -1)