DBA Data[Home] [Help]

APPS.IBY_FNDCPT_SETUP_PUB dependencies on FND_GLOBAL

Line 23: * If FND_GLOBAL.conc_request_id is -1, it implies that

19:
20: BEGIN
21:
22: /*
23: * If FND_GLOBAL.conc_request_id is -1, it implies that
24: * this method has not been invoked via the concurrent
25: * manager. In that case, write to apps log else write
26: * to concurrent manager log file.
27: */

Line 33: IF (FND_GLOBAL.conc_request_id = -1) THEN

29: -- INSERT INTO TEMP_IBY_LOGS VALUES (p_module || ': '
30: -- || p_debug_text, sysdate);
31: -- commit;
32:
33: IF (FND_GLOBAL.conc_request_id = -1) THEN
34:
35: /*
36: * OPTION I:
37: * Write debug text to the common application log file.

Line 378: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,

374: p_payer.Party_Id, p_payer.Org_Type, p_payer.Org_Id,
375: p_payer.Cust_Account_Id, p_payer.Account_Site_Id,
376: p_payer_attributes.Bank_Charge_Bearer,
377: p_payer_attributes.DirectDebit_BankInstruction,
378: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
379: fnd_global.login_id, 1 ,p_payer.Debit_Advice_Delivery_Method,
380: p_payer.Debit_Advice_Email, p_payer.Debit_Advice_Fax
381: );
382: ELSE

Line 379: fnd_global.login_id, 1 ,p_payer.Debit_Advice_Delivery_Method,

375: p_payer.Cust_Account_Id, p_payer.Account_Site_Id,
376: p_payer_attributes.Bank_Charge_Bearer,
377: p_payer_attributes.DirectDebit_BankInstruction,
378: fnd_global.user_id, SYSDATE, fnd_global.user_id, SYSDATE,
379: fnd_global.login_id, 1 ,p_payer.Debit_Advice_Delivery_Method,
380: p_payer.Debit_Advice_Email, p_payer.Debit_Advice_Fax
381: );
382: ELSE
383: UPDATE iby_external_payers_all

Line 391: last_updated_by = fnd_global.user_id,

387: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.DirectDebit_BankInstruction),
388: bank_charge_bearer_code =
389: DECODE(p_payer_attributes.Bank_Charge_Bearer,
390: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.Bank_Charge_Bearer),
391: last_updated_by = fnd_global.user_id,
392: last_update_date = SYSDATE,
393: last_update_login = fnd_global.login_id,
394: object_version_number = object_version_number + 1,
395: debit_advice_delivery_method = p_payer.Debit_Advice_Delivery_Method,

Line 393: last_update_login = fnd_global.login_id,

389: DECODE(p_payer_attributes.Bank_Charge_Bearer,
390: FND_API.G_MISS_CHAR,NULL, p_payer_attributes.Bank_Charge_Bearer),
391: last_updated_by = fnd_global.user_id,
392: last_update_date = SYSDATE,
393: last_update_login = fnd_global.login_id,
394: object_version_number = object_version_number + 1,
395: debit_advice_delivery_method = p_payer.Debit_Advice_Delivery_Method,
396: debit_advice_email = p_payer.Debit_Advice_Email,
397: debit_advice_fax = p_payer.Debit_Advice_Fax

Line 784: p_channel_assignment.Inactive_Date, fnd_global.user_id, SYSDATE,

780: last_update_login, object_version_number)
781: VALUES
782: (x_assignment_id, p_channel_assignment.Pmt_Channel_Code,
783: G_PMT_FLOW_FNDCPT, l_payer_id, p_payer.Payment_Function, 'Y',
784: p_channel_assignment.Inactive_Date, fnd_global.user_id, SYSDATE,
785: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);
786:
787: ELSE
788:

Line 785: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);

781: VALUES
782: (x_assignment_id, p_channel_assignment.Pmt_Channel_Code,
783: G_PMT_FLOW_FNDCPT, l_payer_id, p_payer.Payment_Function, 'Y',
784: p_channel_assignment.Inactive_Date, fnd_global.user_id, SYSDATE,
785: fnd_global.user_id, SYSDATE, fnd_global.login_id, 1);
786:
787: ELSE
788:
789: UPDATE iby_ext_party_pmt_mthds

Line 793: last_updated_by = fnd_global.user_id,

789: UPDATE iby_ext_party_pmt_mthds
790: SET inactive_date = p_channel_assignment.Inactive_Date,
791: payment_method_code =
792: NVL(p_channel_assignment.Pmt_Channel_code,payment_method_code),
793: last_updated_by = fnd_global.user_id,
794: last_update_date = SYSDATE,
795: last_update_login = fnd_global.login_id,
796: object_version_number = object_version_number + 1
797: WHERE ext_party_pmt_mthd_id = x_assignment_id;

Line 795: last_update_login = fnd_global.login_id,

791: payment_method_code =
792: NVL(p_channel_assignment.Pmt_Channel_code,payment_method_code),
793: last_updated_by = fnd_global.user_id,
794: last_update_date = SYSDATE,
795: last_update_login = fnd_global.login_id,
796: object_version_number = object_version_number + 1
797: WHERE ext_party_pmt_mthd_id = x_assignment_id;
798:
799: END IF;

Line 1348: last_updated_by = fnd_global.user_id,

1344: --also l_priority gets 1 when p_assignment_attribs.Priority is NULL
1345:
1346: UPDATE iby_pmt_instr_uses_all
1347: SET order_of_preference = order_of_preference + 1,
1348: last_updated_by = fnd_global.user_id,
1349: last_update_date = trunc(SYSDATE),
1350: last_update_login = fnd_global.login_id,
1351: object_version_number = object_version_number + 1
1352: WHERE ext_pmt_party_id = l_payer_id

Line 1350: last_update_login = fnd_global.login_id,

1346: UPDATE iby_pmt_instr_uses_all
1347: SET order_of_preference = order_of_preference + 1,
1348: last_updated_by = fnd_global.user_id,
1349: last_update_date = trunc(SYSDATE),
1350: last_update_login = fnd_global.login_id,
1351: object_version_number = object_version_number + 1
1352: WHERE ext_pmt_party_id = l_payer_id
1353: AND payment_flow = G_PMT_FLOW_FNDCPT
1354: AND instrument_type = l_instrtype

Line 1384: fnd_global.user_id, SYSDATE, fnd_global.user_id, l_last_update,

1380: p_payer.Payment_Function, G_PMT_FLOW_FNDCPT, l_priority,
1381: null, null, null, null, null,
1382: NVL(p_assignment_attribs.Start_Date,SYSDATE),
1383: p_assignment_attribs.End_Date,
1384: fnd_global.user_id, SYSDATE, fnd_global.user_id, l_last_update,
1385: fnd_global.login_id, 1);
1386:
1387: l_op_type := 'I';
1388: ELSE

Line 1385: fnd_global.login_id, 1);

1381: null, null, null, null, null,
1382: NVL(p_assignment_attribs.Start_Date,SYSDATE),
1383: p_assignment_attribs.End_Date,
1384: fnd_global.user_id, SYSDATE, fnd_global.user_id, l_last_update,
1385: fnd_global.login_id, 1);
1386:
1387: l_op_type := 'I';
1388: ELSE
1389: UPDATE iby_pmt_instr_uses_all

Line 1395: last_updated_by = fnd_global.user_id,

1391: order_of_preference =
1392: NVL(p_assignment_attribs.Priority,order_of_preference),
1393: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
1394: end_date = p_assignment_attribs.End_Date,
1395: last_updated_by = fnd_global.user_id,
1396: last_update_date = l_last_update,
1397: last_update_login = fnd_global.login_id,
1398: object_version_number = object_version_number + 1
1399: WHERE instrument_payment_use_id = x_assign_id;

Line 1397: last_update_login = fnd_global.login_id,

1393: start_date = NVL(p_assignment_attribs.Start_Date,start_date),
1394: end_date = p_assignment_attribs.End_Date,
1395: last_updated_by = fnd_global.user_id,
1396: last_update_date = l_last_update,
1397: last_update_login = fnd_global.login_id,
1398: object_version_number = object_version_number + 1
1399: WHERE instrument_payment_use_id = x_assign_id;
1400:
1401: l_op_type := 'U';

Line 2312: fnd_global.user_id,

2308: p_card_instrument.attribute29,
2309: p_card_instrument.attribute30,
2310: lx_result_code, x_card_id,
2311: p_card_instrument.Register_Invalid_Card,
2312: fnd_global.user_id,
2313: fnd_global.login_id
2314: );
2315: END IF;
2316:

Line 2313: fnd_global.login_id

2309: p_card_instrument.attribute30,
2310: lx_result_code, x_card_id,
2311: p_card_instrument.Register_Invalid_Card,
2312: fnd_global.user_id,
2313: fnd_global.login_id
2314: );
2315: END IF;
2316:
2317: ELSE

Line 3303: p_creditor_name,p_debit_auth_begin,fnd_global.user_id,

3299: p_initial_debit_auth_id,p_auth_rev_number,
3300: p_payment_code,p_amend_readon_code,
3301: p_auth_sign_date,p_auth_cancel_date,p_debit_auth_method,
3302: p_pre_notif_flag,p_creditor_id,
3303: p_creditor_name,p_debit_auth_begin,fnd_global.user_id,
3304: SYSDATE, fnd_global.user_id, SYSDATE,
3305: fnd_global.login_id, 1,p_cust_addr_id,
3306: p_debit_auth_flag,p_debit_auth_ref,p_cust_id_code,
3307: p_creditor_identifer,p_debit_auth_end, 'Y', p_mandate_file);

Line 3304: SYSDATE, fnd_global.user_id, SYSDATE,

3300: p_payment_code,p_amend_readon_code,
3301: p_auth_sign_date,p_auth_cancel_date,p_debit_auth_method,
3302: p_pre_notif_flag,p_creditor_id,
3303: p_creditor_name,p_debit_auth_begin,fnd_global.user_id,
3304: SYSDATE, fnd_global.user_id, SYSDATE,
3305: fnd_global.login_id, 1,p_cust_addr_id,
3306: p_debit_auth_flag,p_debit_auth_ref,p_cust_id_code,
3307: p_creditor_identifer,p_debit_auth_end, 'Y', p_mandate_file);
3308: COMMIT;

Line 3305: fnd_global.login_id, 1,p_cust_addr_id,

3301: p_auth_sign_date,p_auth_cancel_date,p_debit_auth_method,
3302: p_pre_notif_flag,p_creditor_id,
3303: p_creditor_name,p_debit_auth_begin,fnd_global.user_id,
3304: SYSDATE, fnd_global.user_id, SYSDATE,
3305: fnd_global.login_id, 1,p_cust_addr_id,
3306: p_debit_auth_flag,p_debit_auth_ref,p_cust_id_code,
3307: p_creditor_identifer,p_debit_auth_end, 'Y', p_mandate_file);
3308: COMMIT;
3309: x_result:=1;

Line 3486: last_updated_by = fnd_global.user_id,

3482: PRE_NOTIFICATION_REQUIRED_FLAG = p_pre_notif_flag,
3483: CREDITOR_LEGAL_ENTITY_ID = p_creditor_id,
3484: CREDITOR_LE_NAME = p_creditor_name,
3485: DEBIT_AUTH_BEGIN = p_debit_auth_begin,
3486: last_updated_by = fnd_global.user_id,
3487: last_update_date = SYSDATE ,
3488: last_update_login = fnd_global.user_id,
3489: object_version_number = object_version_number+1,
3490: CUST_ADDR_ID = p_cust_addr_id,

Line 3488: last_update_login = fnd_global.user_id,

3484: CREDITOR_LE_NAME = p_creditor_name,
3485: DEBIT_AUTH_BEGIN = p_debit_auth_begin,
3486: last_updated_by = fnd_global.user_id,
3487: last_update_date = SYSDATE ,
3488: last_update_login = fnd_global.user_id,
3489: object_version_number = object_version_number+1,
3490: CUST_ADDR_ID = p_cust_addr_id,
3491: DEBIT_AUTH_FLAG = p_debit_auth_flag ,DEBIT_AUTH_REFERENCE = p_debit_auth_ref,
3492: CUST_IDENTIFICATION_CODE = p_cust_id_code,