DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on FND_GLOBAL

Line 244: FND_GLOBAL.user_id,

240: p_rgm_registration_num,
241: p_trx_from_date,
242: p_trx_till_date,
243: sysdate,
244: FND_GLOBAL.user_id,
245: sysdate,
246: fnd_global.user_id,
247: fnd_global.login_id,
248: fnd_profile.value('PROG_APPL_ID'),

Line 246: fnd_global.user_id,

242: p_trx_till_date,
243: sysdate,
244: FND_GLOBAL.user_id,
245: sysdate,
246: fnd_global.user_id,
247: fnd_global.login_id,
248: fnd_profile.value('PROG_APPL_ID'),
249: fnd_profile.value('CONC_PROGRAM_ID'),
250: fnd_profile.value('CONC_LOGIN_ID')

Line 247: fnd_global.login_id,

243: sysdate,
244: FND_GLOBAL.user_id,
245: sysdate,
246: fnd_global.user_id,
247: fnd_global.login_id,
248: fnd_profile.value('PROG_APPL_ID'),
249: fnd_profile.value('CONC_PROGRAM_ID'),
250: fnd_profile.value('CONC_LOGIN_ID')
251: ) RETURNING batch_id INTO p_batch_id;

Line 1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;

1783: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_PROCESS_ACTION :' || P_PROCESS_ACTION);
1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;
1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
1788: ln_conc_request_id := FND_GLOBAL.conc_request_id;
1789: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
1790: lv_inv_gen_process_flag := jai_constants.successful;
1791: lv_acct_process_flag := jai_constants.successful;

Line 1788: ln_conc_request_id := FND_GLOBAL.conc_request_id;

1784: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_SINGLE_INVOICE_NUM :' || P_SINGLE_INVOICE_NUM);
1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;
1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
1788: ln_conc_request_id := FND_GLOBAL.conc_request_id;
1789: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
1790: lv_inv_gen_process_flag := jai_constants.successful;
1791: lv_acct_process_flag := jai_constants.successful;
1792: lv_inv_gen_process_message := NULL;

Line 1789: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;

1785: Fnd_File.PUT_LINE(Fnd_File.LOG, ' P_OVERRIDE_INVOICE_DATE :' ||P_OVERRIDE_INVOICE_DATE);
1786: END IF;
1787: ln_conc_progam_id := FND_GLOBAL.conc_program_id;
1788: ln_conc_request_id := FND_GLOBAL.conc_request_id;
1789: ln_conc_prog_appl_id := FND_GLOBAL.prog_appl_id;
1790: lv_inv_gen_process_flag := jai_constants.successful;
1791: lv_acct_process_flag := jai_constants.successful;
1792: lv_inv_gen_process_message := NULL;
1793: lv_acct_process_message := NULL;

Line 1961: last_update_login = fnd_global.conc_login_id,

1957: vat_inv_gen_err_message = NULL , /* added the following in the update columns - srjayara for bug 4702156*/
1958: request_id = ln_conc_request_id,
1959: program_id = ln_conc_progam_id,
1960: program_application_id = ln_conc_prog_appl_id,
1961: last_update_login = fnd_global.conc_login_id,
1962: last_update_Date = sysdate
1963:
1964: WHERE Delivery_id = mainrec.delivery_id;
1965:

Line 2060: LAST_UPDATE_LOGIN = fnd_global.login_id,

2056: UPDATE JAI_OM_WSH_LINES_ALL
2057: SET VAT_INVOICE_NO = lv_vat_invoice_number,
2058: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
2059: LAST_UPDATE_DATE = sysdate,
2060: LAST_UPDATE_LOGIN = fnd_global.login_id,
2061: LAST_UPDATED_BY = fnd_global.user_id
2062: WHERE DELIVERY_ID = mainrec.delivery_id;
2063:
2064: UPDATE JAI_RGM_INVOICE_GEN_T

Line 2061: LAST_UPDATED_BY = fnd_global.user_id

2057: SET VAT_INVOICE_NO = lv_vat_invoice_number,
2058: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
2059: LAST_UPDATE_DATE = sysdate,
2060: LAST_UPDATE_LOGIN = fnd_global.login_id,
2061: LAST_UPDATED_BY = fnd_global.user_id
2062: WHERE DELIVERY_ID = mainrec.delivery_id;
2063:
2064: UPDATE JAI_RGM_INVOICE_GEN_T
2065: SET vat_invoice_no = lv_vat_invoice_number,

Line 2070: last_update_login = fnd_global.conc_login_id,

2066: vat_inv_gen_status = 'C',
2067: request_id = ln_conc_request_id,
2068: program_id = ln_conc_progam_id,
2069: program_application_id = ln_conc_prog_appl_id,
2070: last_update_login = fnd_global.conc_login_id,
2071: last_update_date = sysdate /*added by srjayara for bug 4702156*/
2072: WHERE delivery_id = mainrec.delivery_id;
2073: ELSE
2074: lv_inv_gen_process_flag := jai_constants.unexpected_error;

Line 2095: last_update_login = fnd_global.login_id,

2091: UPDATE JAI_OM_WSH_LINES_ALL
2092: SET vat_invoice_no = lv_vat_invoice_number,
2093: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
2094: last_update_date = sysdate,
2095: last_update_login = fnd_global.login_id,
2096: last_updated_by = fnd_global.user_id
2097: WHERE delivery_id IN
2098: (SELECT delivery_id
2099: FROM JAI_RGM_INVOICE_GEN_T

Line 2096: last_updated_by = fnd_global.user_id

2092: SET vat_invoice_no = lv_vat_invoice_number,
2093: VAT_INVOICE_DATE = nvl(ld_override_invoice_date ,sysdate),
2094: last_update_date = sysdate,
2095: last_update_login = fnd_global.login_id,
2096: last_updated_by = fnd_global.user_id
2097: WHERE delivery_id IN
2098: (SELECT delivery_id
2099: FROM JAI_RGM_INVOICE_GEN_T
2100: WHERE party_id = ln_current_party_id

Line 2114: last_update_login = fnd_global.conc_login_id

2110: vat_inv_gen_status = 'C',
2111: request_id = ln_conc_request_id,
2112: program_id = ln_conc_progam_id,
2113: program_application_id = ln_conc_prog_appl_id,
2114: last_update_login = fnd_global.conc_login_id
2115: WHERE delivery_id IN
2116: (SELECT delivery_id
2117: FROM JAI_RGM_INVOICE_GEN_T
2118: WHERE party_id = ln_current_party_id

Line 2169: last_update_login = fnd_global.login_id,

2165: UPDATE JAI_OM_WSH_LINES_ALL
2166: SET vat_invoice_no = lv_vat_invoice_number,
2167: vat_invoice_date = nvl(ld_override_invoice_date ,sysdate),
2168: last_update_date = sysdate,
2169: last_update_login = fnd_global.login_id,
2170: last_updated_by = fnd_global.user_id
2171: WHERE delivery_id = mainrec.delivery_id;
2172:
2173: UPDATE JAI_RGM_INVOICE_GEN_T

Line 2170: last_updated_by = fnd_global.user_id

2166: SET vat_invoice_no = lv_vat_invoice_number,
2167: vat_invoice_date = nvl(ld_override_invoice_date ,sysdate),
2168: last_update_date = sysdate,
2169: last_update_login = fnd_global.login_id,
2170: last_updated_by = fnd_global.user_id
2171: WHERE delivery_id = mainrec.delivery_id;
2172:
2173: UPDATE JAI_RGM_INVOICE_GEN_T
2174: SET vat_invoice_no = lv_vat_invoice_number,

Line 2180: last_update_login = fnd_global.conc_login_id,

2176: vat_inv_gen_err_message = NULL , /*following columns added by srjayara for bug 4702156*/
2177: request_id = ln_conc_request_id,
2178: program_id = ln_conc_progam_id,
2179: program_application_id = ln_conc_prog_appl_id,
2180: last_update_login = fnd_global.conc_login_id,
2181: last_update_date = sysdate
2182: WHERE delivery_id = mainrec.delivery_id;
2183:
2184: ELSE

Line 2196: last_update_login = fnd_global.conc_login_id,

2192: vat_inv_gen_status = 'E',
2193: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
2194: program_id = ln_conc_progam_id,
2195: program_application_id = ln_conc_prog_appl_id,
2196: last_update_login = fnd_global.conc_login_id,
2197: last_update_date = sysdate
2198: WHERE delivery_id = mainrec.delivery_id;
2199: ln_failure_delivery_ctr := NVL(ln_failure_Delivery_ctr,0) + 1;
2200: END IF;

Line 2276: last_update_login = fnd_global.conc_login_id,

2272: vat_inv_gen_err_message = NULL, /*following columns added by srjayara for bug 4702156*/
2273: request_id = ln_conc_request_id,
2274: program_id = ln_conc_progam_id,
2275: program_application_id = ln_conc_prog_appl_id,
2276: last_update_login = fnd_global.conc_login_id,
2277: last_update_date = sysdate
2278: WHERE delivery_id = mainrec.delivery_id;
2279: COMMIT;
2280: END IF;

Line 2300: last_update_login = fnd_global.conc_login_id,

2296: vat_inv_gen_status = 'E',
2297: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
2298: program_id = ln_conc_progam_id,
2299: program_application_id = ln_conc_prog_appl_id,
2300: last_update_login = fnd_global.conc_login_id,
2301: last_update_date = sysdate
2302: WHERE delivery_id = mainrec.delivery_id;
2303: END IF;
2304:

Line 2312: last_update_login = fnd_global.conc_login_id,

2308: vat_acct_status = 'E',
2309: request_id = ln_conc_request_id, /*following columns added by srjayara for bug 4702156*/
2310: program_id = ln_conc_progam_id,
2311: program_application_id = ln_conc_prog_appl_id,
2312: last_update_login = fnd_global.conc_login_id,
2313: last_update_date = sysdate
2314:
2315: WHERE delivery_id = mainrec.delivery_id;
2316: END IF;