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.AR_IREC_PAYMENTS dependencies on FND_API

Line 972: p_init_msg_list => FND_API.G_TRUE,

968: l_create_credit_card.expiration_date := p_expiration_date;
969:
970: IBY_FNDCPT_SETUP_PUB.update_card(
971: p_api_version => 1.0,
972: p_init_msg_list => FND_API.G_TRUE,
973: p_commit => FND_API.G_FALSE,
974: x_return_status => x_return_status,
975: x_msg_count => x_msg_count,
976: x_msg_data => x_msg_data,

Line 973: p_commit => FND_API.G_FALSE,

969:
970: IBY_FNDCPT_SETUP_PUB.update_card(
971: p_api_version => 1.0,
972: p_init_msg_list => FND_API.G_TRUE,
973: p_commit => FND_API.G_FALSE,
974: x_return_status => x_return_status,
975: x_msg_count => x_msg_count,
976: x_msg_data => x_msg_data,
977: p_card_instrument => l_create_credit_card,

Line 981: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

977: p_card_instrument => l_create_credit_card,
978: x_response => l_result_rec);
979:
980:
981: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
982: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
983: fnd_log.string(fnd_log.LEVEL_STATEMENT,
984: G_PKG_NAME||l_procedure_name,
985: 'ERROR IN UPDATING CREDIT CARD');

Line 990: x_return_status := FND_API.G_RET_STS_ERROR;

986: fnd_log.string(fnd_log.LEVEL_STATEMENT,
987: G_PKG_NAME||l_procedure_name,l_result_rec.result_code);
988: end if;
989: x_msg_data := l_result_rec.result_code;
990: x_return_status := FND_API.G_RET_STS_ERROR;
991: write_error_messages(x_msg_data, x_msg_count);
992: END IF;
993: ELSE
994: WRITE_DEBUG_AND_LOG('In BA expiration date update');

Line 1036: p_init_msg_list => FND_API.G_FALSE,

1032: 'l_customer_site_id '||l_customer_site_id);
1033:
1034: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
1035: p_api_version => 1.0,
1036: p_init_msg_list => FND_API.G_FALSE,
1037: p_commit => FND_API.G_FALSE,
1038: x_return_status => x_return_status,
1039: x_msg_count => x_msg_count,
1040: x_msg_data => x_msg_data,

Line 1037: p_commit => FND_API.G_FALSE,

1033:
1034: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
1035: p_api_version => 1.0,
1036: p_init_msg_list => FND_API.G_FALSE,
1037: p_commit => FND_API.G_FALSE,
1038: x_return_status => x_return_status,
1039: x_msg_count => x_msg_count,
1040: x_msg_data => x_msg_data,
1041: p_payer => l_payerContext_Rec_type,

Line 1048: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1044: x_response => l_result_rec
1045: );
1046: -- Modified for Bug# 16262617 : End
1047:
1048: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1049: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1050: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1051: G_PKG_NAME||l_procedure_name,
1052: 'ERROR IN UPDATING BANK ACCOUNT');

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: 'ERROR IN UPDATING BANK ACCOUNT');
1053: fnd_log.string(fnd_log.LEVEL_STATEMENT,
1054: G_PKG_NAME||l_procedure_name,x_msg_data);
1055: end if;
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: write_error_messages(x_msg_data, x_msg_count);
1058: END IF;
1059: END IF;
1060:

Line 1818: IF ( p_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1814: , x_return_status => p_status
1815: , x_msg_count => l_msg_count
1816: , x_msg_data => l_msg_data);
1817:
1818: IF ( p_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1819: write_error_messages(l_msg_data, l_msg_count);
1820: ROLLBACK TO STORE_INST;
1821: RETURN;
1822: END IF;

Line 1844: IF ( p_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1840: , x_return_status => p_status
1841: , x_msg_count => l_msg_count
1842: , x_msg_data => l_msg_data);
1843:
1844: IF ( p_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1845: write_error_messages(l_msg_data, l_msg_count);
1846: ROLLBACK TO STORE_INST;
1847: RETURN;
1848: END IF;

Line 1926: p_init_msg_list => FND_API.G_FALSE,

1922: end if;
1923:
1924: IBY_FNDCPT_SETUP_PUB.Card_Exists(
1925: p_api_version => 1.0,
1926: p_init_msg_list => FND_API.G_FALSE,
1927: x_return_status => l_return_status,
1928: x_msg_count => l_msg_count,
1929: x_msg_data => l_msg_data,
1930: p_owner_id => null,

Line 1942: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1938: end if;
1939: --Bug 14534172 - As per bug, do not validate the credit card exists from OIR.
1940: return 0;
1941: /*
1942: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1943: -- no card exists
1944: return 0;
1945: ELSE
1946: OPEN cc_cur(l_create_credit_card.card_id);

Line 2161: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

2157: --Bug 3810143 - Ensure that the messages are picked up from the message
2158: --stack in any case.
2159: FOR l_count IN 1..p_msg_count LOOP
2160:
2161: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2162: write_debug_and_log(to_char(l_count)||' : '||l_msg_data);
2163:
2164: END LOOP;
2165:

Line 2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;

2970: where CUST_ACCOUNT_ID = p_customer_id
2971: and ACCT_SITE_USE_ID = p_customer_site_id);
2972:
2973: l_api_version NUMBER := 1.0;
2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;

Line 2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;

2971: and ACCT_SITE_USE_ID = p_customer_site_id);
2972:
2973: l_api_version NUMBER := 1.0;
2974: l_init_msg_list VARCHAR2(30) DEFAULT FND_API.G_TRUE;
2975: l_commit VARCHAR2(30) DEFAULT FND_API.G_FALSE;
2976: l_bank_account_id iby_ext_bank_accounts_v.bank_account_id%TYPE;
2977: l_start_date iby_ext_bank_accounts_v.start_date%TYPE;
2978: l_end_date iby_ext_bank_accounts_v.end_date%TYPE;
2979: l_bank_acct_response iby_fndcpt_common_pub.result_rec_type;

Line 3002: l_commit := FND_API.G_FALSE;

2998:
2999: BEGIN
3000:
3001: l_procedure_name := '.create_payment_instrument';
3002: l_commit := FND_API.G_FALSE;
3003:
3004: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3005: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_id :: ' ||p_bank_id);
3006: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'p_bank_branch_id :: ' ||p_bank_branch_id);

Line 3109: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

3105: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3106: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3107: end if;
3108:
3109: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3110: l_bank_id := l_bank_party_id;
3111: l_branch_id := l_branch_party_id;
3112: end if;
3113:

Line 3150: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

3146: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_return_status ::' || x_return_status);
3147: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'bank x_msg_data ::' || x_msg_data);
3148: end if;
3149:
3150: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3151: l_bank_id := l_bank_party_id;
3152: end if;
3153:
3154: l_ext_branch_rec.branch_party_id := NULL;

Line 3185: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

3181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_return_status ::' || x_return_status);
3182: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'branch x_msg_data ::' || x_msg_data);
3183: end if;
3184:
3185: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3186: l_branch_id := l_branch_party_id;
3187: end if;
3188: end if;
3189: -- Added for Bug# 16306925

Line 3239: p_init_msg_list => FND_API.G_FALSE,

3235: end if;
3236:
3237: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(
3238: p_api_version => 1.0,
3239: p_init_msg_list => FND_API.G_FALSE,
3240: p_ext_bank_acct_rec => l_ext_bank_act_rec,
3241: x_acct_id => l_bank_account_id,
3242: x_return_status => x_return_status,
3243: x_msg_count => x_msg_count,

Line 3248: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3244: x_msg_data => x_msg_data,
3245: x_response => l_result_rec);
3246:
3247: write_debug_and_log('l_bank_account_id :'||l_bank_account_id);
3248: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3249: x_msg_data := l_result_rec.result_code;
3250: p_status := FND_API.G_RET_STS_ERROR;
3251: write_error_messages(x_msg_data, x_msg_count);
3252: RETURN;

Line 3250: p_status := FND_API.G_RET_STS_ERROR;

3246:
3247: write_debug_and_log('l_bank_account_id :'||l_bank_account_id);
3248: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3249: x_msg_data := l_result_rec.result_code;
3250: p_status := FND_API.G_RET_STS_ERROR;
3251: write_error_messages(x_msg_data, x_msg_count);
3252: RETURN;
3253: END IF;
3254: end; -- exception end

Line 3285: p_init_msg_list => FND_API.G_FALSE,

3281: l_create_credit_card.Info_Only_Flag := 'N';
3282:
3283: IBY_FNDCPT_SETUP_PUB.create_card(
3284: p_api_version => 1.0,
3285: p_init_msg_list => FND_API.G_FALSE,
3286: p_commit => l_commit,
3287: x_return_status => x_return_status,
3288: x_msg_count => x_msg_count,
3289: x_msg_data => x_msg_data,

Line 3295: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3291: x_card_id => l_bank_account_id,
3292: x_response => l_result_rec);
3293:
3294: write_debug_and_log('l_card_id :'||l_bank_account_id);
3295: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3296: p_status := FND_API.G_RET_STS_ERROR;
3297: x_msg_data := l_result_rec.result_code;
3298: write_error_messages(x_msg_data, x_msg_count);
3299: RETURN;

Line 3296: p_status := FND_API.G_RET_STS_ERROR;

3292: x_response => l_result_rec);
3293:
3294: write_debug_and_log('l_card_id :'||l_bank_account_id);
3295: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3296: p_status := FND_API.G_RET_STS_ERROR;
3297: x_msg_data := l_result_rec.result_code;
3298: write_error_messages(x_msg_data, x_msg_count);
3299: RETURN;
3300: END IF;

Line 3313: p_init_msg_list => FND_API.G_FALSE,

3309: if(l_count <= 0) then
3310: write_debug_and_log('Adding joint account owner >> l_bank_account_id '||l_bank_account_id||' p_payer_party_id :'||p_payer_party_id);
3311: IBY_EXT_BANKACCT_PUB.add_joint_account_owner(
3312: p_api_version => 1.0,
3313: p_init_msg_list => FND_API.G_FALSE,
3314: p_bank_account_id => l_bank_account_id,
3315: p_acct_owner_party_id => p_payer_party_id,
3316: x_joint_acct_owner_id => l_joint_acct_owner_id,
3317: x_return_status => x_return_status,

Line 3323: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3319: x_msg_data => x_msg_data,
3320: x_response => l_result_rec
3321: );
3322: write_debug_and_log('l_joint_acct_owner_id : '||l_joint_acct_owner_id);
3323: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3324: p_status := FND_API.G_RET_STS_ERROR;
3325: x_msg_data := l_result_rec.result_code;
3326: write_error_messages(x_msg_data, x_msg_count);
3327: RETURN;

Line 3324: p_status := FND_API.G_RET_STS_ERROR;

3320: x_response => l_result_rec
3321: );
3322: write_debug_and_log('l_joint_acct_owner_id : '||l_joint_acct_owner_id);
3323: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3324: p_status := FND_API.G_RET_STS_ERROR;
3325: x_msg_data := l_result_rec.result_code;
3326: write_error_messages(x_msg_data, x_msg_count);
3327: RETURN;
3328: END IF;

Line 3381: p_init_msg_list => FND_API.G_FALSE,

3377:
3378:
3379: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
3380: p_api_version => 1.0,
3381: p_init_msg_list => FND_API.G_FALSE,
3382: p_commit => FND_API.G_FALSE,
3383: x_return_status => x_return_status,
3384: x_msg_count => x_msg_count,
3385: x_msg_data => x_msg_data,

Line 3382: p_commit => FND_API.G_FALSE,

3378:
3379: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
3380: p_api_version => 1.0,
3381: p_init_msg_list => FND_API.G_FALSE,
3382: p_commit => FND_API.G_FALSE,
3383: x_return_status => x_return_status,
3384: x_msg_count => x_msg_count,
3385: x_msg_data => x_msg_data,
3386: p_payer => l_payerContext_Rec_type,

Line 3392: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3388: x_assign_id => l_assignment_id,
3389: x_response => l_result_rec
3390: );
3391:
3392: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3393: p_status := FND_API.G_RET_STS_ERROR;
3394: x_msg_data := l_result_rec.result_code;
3395: write_error_messages(x_msg_data, x_msg_count);
3396: RETURN;

Line 3393: p_status := FND_API.G_RET_STS_ERROR;

3389: x_response => l_result_rec
3390: );
3391:
3392: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3393: p_status := FND_API.G_RET_STS_ERROR;
3394: x_msg_data := l_result_rec.result_code;
3395: write_error_messages(x_msg_data, x_msg_count);
3396: RETURN;
3397: END IF;

Line 3418: p_status := FND_API.G_RET_STS_ERROR;

3414:
3415:
3416: EXCEPTION
3417: WHEN OTHERS THEN
3418: p_status := FND_API.G_RET_STS_ERROR;
3419: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3420: write_debug_and_log('- Card Number: '||p_account_number);
3421: write_debug_and_log('- CC Billing Addrress Site Id: '||p_cc_bill_to_site_id);
3422: write_debug_and_log('- Singe Use Flag: '||p_single_use_flag);

Line 3456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3452: | Date Author Description of Changes
3453: | 17-Aug-2005 rsinthre Created
3454: +============================================================*/
3455: PROCEDURE create_cc_bill_to_site(
3456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3457: p_commit IN VARCHAR2 := FND_API.G_TRUE,
3458: p_cc_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
3459: p_payer_party_id IN NUMBER,
3460: x_cc_bill_to_site_id IN OUT NOCOPY NUMBER,

Line 3457: p_commit IN VARCHAR2 := FND_API.G_TRUE,

3453: | 17-Aug-2005 rsinthre Created
3454: +============================================================*/
3455: PROCEDURE create_cc_bill_to_site(
3456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3457: p_commit IN VARCHAR2 := FND_API.G_TRUE,
3458: p_cc_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
3459: p_payer_party_id IN NUMBER,
3460: x_cc_bill_to_site_id IN OUT NOCOPY NUMBER,
3461: x_return_status OUT NOCOPY VARCHAR2,

Line 3492: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3488: x_return_status => x_return_status,
3489: x_msg_count => x_msg_count,
3490: x_msg_data => x_msg_data);
3491:
3492: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3493: x_return_status := FND_API.G_RET_STS_ERROR;
3494: write_error_messages(x_msg_data, x_msg_count);
3495: RETURN;
3496: END IF;

Line 3493: x_return_status := FND_API.G_RET_STS_ERROR;

3489: x_msg_count => x_msg_count,
3490: x_msg_data => x_msg_data);
3491:
3492: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3493: x_return_status := FND_API.G_RET_STS_ERROR;
3494: write_error_messages(x_msg_data, x_msg_count);
3495: RETURN;
3496: END IF;
3497:

Line 3517: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

3513: );
3514:
3515: write_debug_and_log('cc_billing_site_id :'||x_cc_bill_to_site_id);
3516:
3517: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3518: x_return_status := FND_API.G_RET_STS_ERROR;
3519: write_error_messages(x_msg_data, x_msg_count);
3520: RETURN;
3521: END IF;

Line 3518: x_return_status := FND_API.G_RET_STS_ERROR;

3514:
3515: write_debug_and_log('cc_billing_site_id :'||x_cc_bill_to_site_id);
3516:
3517: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3518: x_return_status := FND_API.G_RET_STS_ERROR;
3519: write_error_messages(x_msg_data, x_msg_count);
3520: RETURN;
3521: END IF;
3522:

Line 3525: x_return_status := FND_API.G_RET_STS_ERROR;

3521: END IF;
3522:
3523: EXCEPTION
3524: WHEN OTHERS THEN
3525: x_return_status := FND_API.G_RET_STS_ERROR;
3526:
3527: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3528: write_debug_and_log('- Return Status: '||x_return_status);
3529: write_debug_and_log('ERROR =>'|| SQLERRM);

Line 3606: p_init_msg_list => FND_API.G_TRUE,

3602: -------------------------------------------------------------------------------------------
3603:
3604: AR_RECEIPT_API_PUB.create_cash(
3605: p_api_version => 1.0,
3606: p_init_msg_list => FND_API.G_TRUE,
3607: p_commit => FND_API.G_FALSE,
3608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3609: x_return_status => x_return_status,
3610: x_msg_count => x_msg_count,

Line 3607: p_commit => FND_API.G_FALSE,

3603:
3604: AR_RECEIPT_API_PUB.create_cash(
3605: p_api_version => 1.0,
3606: p_init_msg_list => FND_API.G_TRUE,
3607: p_commit => FND_API.G_FALSE,
3608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3609: x_return_status => x_return_status,
3610: x_msg_count => x_msg_count,
3611: x_msg_data => x_msg_data,

Line 3608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3604: AR_RECEIPT_API_PUB.create_cash(
3605: p_api_version => 1.0,
3606: p_init_msg_list => FND_API.G_TRUE,
3607: p_commit => FND_API.G_FALSE,
3608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3609: x_return_status => x_return_status,
3610: x_msg_count => x_msg_count,
3611: x_msg_data => x_msg_data,
3612: p_amount => p_payment_amount,

Line 3642: p_status := FND_API.G_RET_STS_ERROR;

3638: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));
3639:
3640: EXCEPTION
3641: WHEN OTHERS THEN
3642: p_status := FND_API.G_RET_STS_ERROR;
3643:
3644: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3645: write_debug_and_log('- Customer Id: '||p_customer_id);
3646: write_debug_and_log('- Customer Site Id: '||p_site_use_id);

Line 3813: p_init_msg_list => FND_API.G_TRUE,

3809: end if;
3810:
3811: AR_RECEIPT_API_PUB.apply(
3812: p_api_version => 1.0,
3813: p_init_msg_list => FND_API.G_TRUE,
3814: p_commit => FND_API.G_FALSE,
3815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3816: x_return_status => x_return_status,
3817: x_msg_count => x_msg_count,

Line 3814: p_commit => FND_API.G_FALSE,

3810:
3811: AR_RECEIPT_API_PUB.apply(
3812: p_api_version => 1.0,
3813: p_init_msg_list => FND_API.G_TRUE,
3814: p_commit => FND_API.G_FALSE,
3815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3816: x_return_status => x_return_status,
3817: x_msg_count => x_msg_count,
3818: x_msg_data => x_msg_data,

Line 3815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3811: AR_RECEIPT_API_PUB.apply(
3812: p_api_version => 1.0,
3813: p_init_msg_list => FND_API.G_TRUE,
3814: p_commit => FND_API.G_FALSE,
3815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3816: x_return_status => x_return_status,
3817: x_msg_count => x_msg_count,
3818: x_msg_data => x_msg_data,
3819: p_cash_receipt_id => p_cash_receipt_id,

Line 3849: p_init_msg_list => FND_API.G_TRUE,

3845: end if;
3846:
3847: AR_RECEIPT_API_PUB.apply_open_receipt
3848: (p_api_version => 1.0,
3849: p_init_msg_list => FND_API.G_TRUE,
3850: p_commit => FND_API.G_FALSE,
3851: x_return_status => x_return_status,
3852: x_msg_count => x_msg_count,
3853: x_msg_data => x_msg_data,

Line 3850: p_commit => FND_API.G_FALSE,

3846:
3847: AR_RECEIPT_API_PUB.apply_open_receipt
3848: (p_api_version => 1.0,
3849: p_init_msg_list => FND_API.G_TRUE,
3850: p_commit => FND_API.G_FALSE,
3851: x_return_status => x_return_status,
3852: x_msg_count => x_msg_count,
3853: x_msg_data => x_msg_data,
3854: p_cash_receipt_id => p_cash_receipt_id,

Line 3877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3873: end if;
3874:
3875: -- Check for errors and increment the count for
3876: -- errored applcations
3877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3878: l_apply_err_count := l_apply_err_count + 1;
3879: p_apply_err_count := l_apply_err_count;
3880: p_return_status := FND_API.G_RET_STS_ERROR;
3881: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;

Line 3880: p_return_status := FND_API.G_RET_STS_ERROR;

3876: -- errored applcations
3877: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3878: l_apply_err_count := l_apply_err_count + 1;
3879: p_apply_err_count := l_apply_err_count;
3880: p_return_status := FND_API.G_RET_STS_ERROR;
3881: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;
3882: RETURN;
3883: END IF;
3884:

Line 3920: p_init_msg_list => FND_API.G_TRUE,

3916: -- Call the application API
3917: --
3918: AR_RECEIPT_API_PUB.apply(
3919: p_api_version => 1.0,
3920: p_init_msg_list => FND_API.G_TRUE,
3921: p_commit => FND_API.G_FALSE,
3922: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3923: x_return_status => x_return_status,
3924: x_msg_count => x_msg_count,

Line 3921: p_commit => FND_API.G_FALSE,

3917: --
3918: AR_RECEIPT_API_PUB.apply(
3919: p_api_version => 1.0,
3920: p_init_msg_list => FND_API.G_TRUE,
3921: p_commit => FND_API.G_FALSE,
3922: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3923: x_return_status => x_return_status,
3924: x_msg_count => x_msg_count,
3925: x_msg_data => x_msg_data,

Line 3922: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3918: AR_RECEIPT_API_PUB.apply(
3919: p_api_version => 1.0,
3920: p_init_msg_list => FND_API.G_TRUE,
3921: p_commit => FND_API.G_FALSE,
3922: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3923: x_return_status => x_return_status,
3924: x_msg_count => x_msg_count,
3925: x_msg_data => x_msg_data,
3926: p_cash_receipt_id => p_cash_receipt_id,

Line 3943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3939: end if;
3940:
3941: -- Check for errors and increment the count for
3942: -- errored applcations
3943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3944: l_apply_err_count := l_apply_err_count + 1;
3945: p_apply_err_count := l_apply_err_count;
3946: p_return_status := FND_API.G_RET_STS_ERROR;
3947: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;

Line 3946: p_return_status := FND_API.G_RET_STS_ERROR;

3942: -- errored applcations
3943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3944: l_apply_err_count := l_apply_err_count + 1;
3945: p_apply_err_count := l_apply_err_count;
3946: p_return_status := FND_API.G_RET_STS_ERROR;
3947: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;
3948: RETURN;
3949: END IF;
3950:

Line 3964: p_return_status := FND_API.G_RET_STS_SUCCESS;

3960:
3961: p_apply_err_count := l_apply_err_count;
3962: -- There are no errored applications; set the
3963: -- return status to success
3964: p_return_status := FND_API.G_RET_STS_SUCCESS;
3965:
3966: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3967: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Exiting apply_cash with return status: '||p_return_status);
3968: end if;

Line 3973: p_return_status := FND_API.G_RET_STS_ERROR;

3969:
3970: EXCEPTION
3971: WHEN OTHERS THEN
3972: BEGIN
3973: p_return_status := FND_API.G_RET_STS_ERROR;
3974:
3975: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3976: write_debug_and_log('- Customer Id: '||p_customer_id);
3977: write_debug_and_log('- Customer Site Id: '||p_site_use_id);

Line 4285: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4281: l_debug_info := 'Apply service charge';
4282: ----------------------------------------------------------------------------------
4283: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);
4284:
4285: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4286: -- bug 3672530 - Ensure graceful error handling
4287: x_return_status := FND_API.G_RET_STS_ERROR;
4288: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4289: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);

Line 4287: x_return_status := FND_API.G_RET_STS_ERROR;

4283: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);
4284:
4285: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4286: -- bug 3672530 - Ensure graceful error handling
4287: x_return_status := FND_API.G_RET_STS_ERROR;
4288: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4289: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);
4290: end if;
4291: APP_EXCEPTION.RAISE_EXCEPTION;

Line 4301: x_return_status := FND_API.G_RET_STS_ERROR;

4297:
4298: EXCEPTION
4299: WHEN OTHERS THEN
4300: BEGIN
4301: x_return_status := FND_API.G_RET_STS_ERROR;
4302:
4303: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
4304: write_debug_and_log('- Customer Id: '||p_customer_id);
4305: write_debug_and_log('- Customer Site Id: '||p_site_use_id);

Line 4449: l_call_payment_processor := FND_API.G_TRUE;

4445: BEGIN
4446: --Assign default values
4447:
4448: l_receipt_currency_code := 'USD';
4449: l_call_payment_processor := FND_API.G_TRUE;
4450: l_apply_err_count := 0;
4451: x_msg_count := 0;
4452: x_msg_data := '';
4453: l_procedure_name := '.pay_multiple_invoices';

Line 4605: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4601: x_billing_addr_use => l_billing_addr_use,
4602: x_msg_count => x_msg_count,
4603: x_msg_data => x_msg_data
4604: );
4605: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4606:
4607: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4608: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4609: G_PKG_NAME||l_procedure_name,

Line 4613: x_return_status := FND_API.G_RET_STS_ERROR;

4609: G_PKG_NAME||l_procedure_name,
4610: 'ERROR IN GETTING IBY PAYMENT CHANNEL ATTRIBUTES');
4611: end if;
4612:
4613: x_return_status := FND_API.G_RET_STS_ERROR;
4614: write_error_messages(x_msg_data, x_msg_count);
4615: RETURN;
4616: END IF;
4617:

Line 4671: p_init_msg_list => FND_API.G_FALSE,

4667: l_cc_location_rec.created_by_module := 'ARI';
4668: -- Bug#14797865 : Removed the condition if billing_addr_use is required
4669: IF(p_payment_instrument = 'CREDIT_CARD') and l_cc_bill_to_site_id = -1 THEN
4670: create_cc_bill_to_site(
4671: p_init_msg_list => FND_API.G_FALSE,
4672: p_commit => FND_API.G_FALSE,
4673: p_cc_location_rec => l_cc_location_rec,
4674: p_payer_party_id => l_payer_party_id,
4675: x_cc_bill_to_site_id => l_cc_bill_to_site_id,

Line 4672: p_commit => FND_API.G_FALSE,

4668: -- Bug#14797865 : Removed the condition if billing_addr_use is required
4669: IF(p_payment_instrument = 'CREDIT_CARD') and l_cc_bill_to_site_id = -1 THEN
4670: create_cc_bill_to_site(
4671: p_init_msg_list => FND_API.G_FALSE,
4672: p_commit => FND_API.G_FALSE,
4673: p_cc_location_rec => l_cc_location_rec,
4674: p_payer_party_id => l_payer_party_id,
4675: x_cc_bill_to_site_id => l_cc_bill_to_site_id,
4676: x_return_status => x_return_status,

Line 4680: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4676: x_return_status => x_return_status,
4677: x_msg_count => l_msg_count,
4678: x_msg_data => l_msg_data);
4679:
4680: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4681:
4682: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4683: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4684: G_PKG_NAME||l_procedure_name,

Line 4688: p_status := FND_API.G_RET_STS_ERROR;

4684: G_PKG_NAME||l_procedure_name,
4685: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4686: end if;
4687:
4688: p_status := FND_API.G_RET_STS_ERROR;
4689: ROLLBACK TO ARI_Create_Cash_PVT;
4690: write_error_messages(x_msg_data, x_msg_count);
4691: RETURN;
4692: END IF;

Line 4726: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4722: p_routing_number => p_routing_number,
4723: p_assignment_id => l_instr_assign_id,
4724: p_bank_account_id => l_bank_account_id) ;
4725: -- Check if the payment instrument was created successfully
4726: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4727: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4728: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4729: G_PKG_NAME||l_procedure_name,
4730: 'ERROR IN CREATING PAYMENT INSTRUMENT');

Line 4733: p_status := FND_API.G_RET_STS_ERROR;

4729: G_PKG_NAME||l_procedure_name,
4730: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4731: end if;
4732:
4733: p_status := FND_API.G_RET_STS_ERROR;
4734: write_error_messages(x_msg_data, x_msg_count);
4735: ROLLBACK TO ARI_Create_Cash_PVT;
4736: RETURN;
4737: ELSE

Line 4794: p_init_msg_list =>FND_API.G_TRUE,

4790: write_debug_and_log('l_payment_server_order_num'||l_payment_server_order_num);
4791: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
4792: (
4793: p_api_version =>1.0,
4794: p_init_msg_list =>FND_API.G_TRUE,
4795: -- p_commit => FND_API.G_FALSE, -- bug 9683510
4796: x_return_status =>x_return_status,
4797: x_msg_count =>l_msg_count,
4798: x_msg_data => l_msg_data,

Line 4795: -- p_commit => FND_API.G_FALSE, -- bug 9683510

4791: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
4792: (
4793: p_api_version =>1.0,
4794: p_init_msg_list =>FND_API.G_TRUE,
4795: -- p_commit => FND_API.G_FALSE, -- bug 9683510
4796: x_return_status =>x_return_status,
4797: x_msg_count =>l_msg_count,
4798: x_msg_data => l_msg_data,
4799: p_payer => l_payer_rec,

Line 4806: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4802: p_trxn_attribs => l_trxn_rec,
4803: x_entity_id => l_extn_id,
4804: x_response => l_result_rec);
4805:
4806: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4807: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4808: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4809: G_PKG_NAME||l_procedure_name,
4810: 'ERROR IN CREATING TRANSACTION EXTENSION');

Line 4820: p_status := FND_API.G_RET_STS_ERROR;

4816: x_msg_data := x_msg_data || l_msg_data || '*';
4817: end if;
4818:
4819: x_msg_data := x_msg_data || '*' || l_result_rec.result_code;
4820: p_status := FND_API.G_RET_STS_ERROR;
4821: ROLLBACK TO ARI_Create_Trans_Extn_PVT;
4822: write_error_messages(x_msg_data, x_msg_count);
4823: RETURN;
4824: END IF;

Line 4861: l_call_payment_processor := FND_API.G_FALSE;

4857: | iPayment is called in receivables remittance process |
4858: +------------------------------------------------------*/
4859: IF (fnd_function.test('ARIPAYMENTDEMOMODE')
4860: OR p_payment_instrument = 'BANK_ACCOUNT') THEN /* J Rautiainen ACH Implementation */
4861: l_call_payment_processor := FND_API.G_FALSE;
4862: ELSE
4863: l_call_payment_processor := FND_API.G_TRUE;
4864: END IF;
4865:

Line 4863: l_call_payment_processor := FND_API.G_TRUE;

4859: IF (fnd_function.test('ARIPAYMENTDEMOMODE')
4860: OR p_payment_instrument = 'BANK_ACCOUNT') THEN /* J Rautiainen ACH Implementation */
4861: l_call_payment_processor := FND_API.G_FALSE;
4862: ELSE
4863: l_call_payment_processor := FND_API.G_TRUE;
4864: END IF;
4865:
4866: -- commented for bug 9683510
4867: /* IF (p_receipt_site_id <> -1) THEN

Line 4913: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR p_cash_receipt_id IS NULL ) THEN

4909: end if;
4910:
4911: -- Check for error in receipt creation. If it is an error
4912: -- the rollback and return.
4913: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR p_cash_receipt_id IS NULL ) THEN
4914: --Bug 3672530 - Error handling
4915: p_status := FND_API.G_RET_STS_ERROR;
4916: p_status_reason := G_CREATION_FAILED;
4917: ROLLBACK TO ARI_Create_Receipt_PVT;

Line 4915: p_status := FND_API.G_RET_STS_ERROR;

4911: -- Check for error in receipt creation. If it is an error
4912: -- the rollback and return.
4913: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR p_cash_receipt_id IS NULL ) THEN
4914: --Bug 3672530 - Error handling
4915: p_status := FND_API.G_RET_STS_ERROR;
4916: p_status_reason := G_CREATION_FAILED;
4917: ROLLBACK TO ARI_Create_Receipt_PVT;
4918: write_error_messages(x_msg_data, x_msg_count);
4919: RETURN;

Line 4936: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4932: ---------------------------------------------------------------------------------
4933: l_debug_info := 'Service charge enabled: adjust the invoice with service charge';
4934: ---------------------------------------------------------------------------------
4935: apply_service_charge(p_customer_id, null, x_return_status); -- Bug 9596552
4936: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4937: --Bug 3672530 - Error handling
4938: p_status := FND_API.G_RET_STS_ERROR;
4939: p_status_reason := G_SVC_FAILED; -- Added for Bug 16471455
4940: ROLLBACK TO ARI_Create_Receipt_PVT;

Line 4938: p_status := FND_API.G_RET_STS_ERROR;

4934: ---------------------------------------------------------------------------------
4935: apply_service_charge(p_customer_id, null, x_return_status); -- Bug 9596552
4936: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4937: --Bug 3672530 - Error handling
4938: p_status := FND_API.G_RET_STS_ERROR;
4939: p_status_reason := G_SVC_FAILED; -- Added for Bug 16471455
4940: ROLLBACK TO ARI_Create_Receipt_PVT;
4941: write_error_messages(x_msg_data, x_msg_count);
4942: RETURN;

Line 4976: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

4972: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_apply_err_count : '||l_apply_err_count);
4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);
4974: end if;
4975:
4976: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4977: p_status := FND_API.G_RET_STS_ERROR;
4978: p_status_reason := G_APP_FAILED; -- Added for Bug 16471455
4979: ROLLBACK TO ARI_Create_Receipt_PVT;
4980: if (l_apply_err_count > 0) then

Line 4977: p_status := FND_API.G_RET_STS_ERROR;

4973: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'x_msg_data : '|| x_msg_data);
4974: end if;
4975:
4976: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4977: p_status := FND_API.G_RET_STS_ERROR;
4978: p_status_reason := G_APP_FAILED; -- Added for Bug 16471455
4979: ROLLBACK TO ARI_Create_Receipt_PVT;
4980: if (l_apply_err_count > 0) then
4981: x_msg_count := x_msg_count + l_msg_count;

Line 4994: l_call_payment_processor = FND_API.G_TRUE) THEN

4990: -- Seems like all is fine. So we shall go ahead and
4991: -- do the final task of capturing the CC payment
4992: -- only if it is a credit card payment
4993: IF (p_payment_instrument = 'CREDIT_CARD' AND
4994: l_call_payment_processor = FND_API.G_TRUE) THEN
4995:
4996: BEGIN
4997: select pr.home_country into l_home_country
4998: from ar_cash_receipts_all cr,

Line 5043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5039: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'l_auth_id: '|| l_auth_id);
5040: end if;
5041: -- If the payment processor call fails, then we need to rollback all the changes
5042: -- made in the create() and apply() routines also.
5043: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5044: x_msg_count := x_msg_count + l_msg_count;
5045: if (l_msg_data is not null) then
5046: x_msg_data := x_msg_data || l_msg_data || '*';
5047: end if;

Line 5050: p_status := FND_API.G_RET_STS_ERROR;

5046: x_msg_data := x_msg_data || l_msg_data || '*';
5047: end if;
5048: -- x_msg_data := x_msg_data || '*' || l_result_rec.result_code; -- bug 8353477
5049: --Bug 3672530 - Error handling
5050: p_status := FND_API.G_RET_STS_ERROR;
5051: p_status_reason := G_CC_AUTH_FAILED; -- Added for Bug 16471455
5052: ROLLBACK TO ARI_Create_Cash_PVT;
5053: write_error_messages(x_msg_data, x_msg_count);
5054: RETURN; -- exit back to caller

Line 5082: p_init_msg_list => FND_API.G_TRUE,

5078:
5079: IBY_FNDCPT_SETUP_PUB.Update_Card
5080: (
5081: p_api_version => 1.0,
5082: p_init_msg_list => FND_API.G_TRUE,
5083: p_commit => FND_API.G_FALSE,
5084: x_return_status => x_return_status,
5085: x_msg_count => l_msg_count,
5086: x_msg_data => l_msg_data,

Line 5083: p_commit => FND_API.G_FALSE,

5079: IBY_FNDCPT_SETUP_PUB.Update_Card
5080: (
5081: p_api_version => 1.0,
5082: p_init_msg_list => FND_API.G_TRUE,
5083: p_commit => FND_API.G_FALSE,
5084: x_return_status => x_return_status,
5085: x_msg_count => l_msg_count,
5086: x_msg_data => l_msg_data,
5087: p_card_instrument => l_create_credit_card,

Line 5091: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

5087: p_card_instrument => l_create_credit_card,
5088: x_response => l_result_rec_type
5089: );
5090:
5091: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5092: p_status := FND_API.G_RET_STS_ERROR;
5093: x_msg_count := x_msg_count + l_msg_count;
5094: if (l_msg_data is not null) then
5095: x_msg_data := x_msg_data || l_msg_data || '*';

Line 5092: p_status := FND_API.G_RET_STS_ERROR;

5088: x_response => l_result_rec_type
5089: );
5090:
5091: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5092: p_status := FND_API.G_RET_STS_ERROR;
5093: x_msg_count := x_msg_count + l_msg_count;
5094: if (l_msg_data is not null) then
5095: x_msg_data := x_msg_data || l_msg_data || '*';
5096: end if;

Line 5127: p_init_msg_list => FND_API.G_TRUE,

5123:
5124: IBY_FNDCPT_SETUP_PUB.Update_Card
5125: (
5126: p_api_version => 1.0,
5127: p_init_msg_list => FND_API.G_TRUE,
5128: p_commit => FND_API.G_FALSE,
5129: x_return_status => x_return_status,
5130: x_msg_count => l_msg_count,
5131: x_msg_data => l_msg_data,

Line 5128: p_commit => FND_API.G_FALSE,

5124: IBY_FNDCPT_SETUP_PUB.Update_Card
5125: (
5126: p_api_version => 1.0,
5127: p_init_msg_list => FND_API.G_TRUE,
5128: p_commit => FND_API.G_FALSE,
5129: x_return_status => x_return_status,
5130: x_msg_count => l_msg_count,
5131: x_msg_data => l_msg_data,
5132: p_card_instrument => l_create_credit_card,

Line 5136: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

5132: p_card_instrument => l_create_credit_card,
5133: x_response => l_result_rec_type
5134: );
5135:
5136: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5137: p_status := FND_API.G_RET_STS_ERROR;
5138: x_msg_count := x_msg_count + l_msg_count;
5139: if (l_msg_data is not null) then
5140: x_msg_data := x_msg_data || l_msg_data || '*';

Line 5137: p_status := FND_API.G_RET_STS_ERROR;

5133: x_response => l_result_rec_type
5134: );
5135:
5136: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5137: p_status := FND_API.G_RET_STS_ERROR;
5138: x_msg_count := x_msg_count + l_msg_count;
5139: if (l_msg_data is not null) then
5140: x_msg_data := x_msg_data || l_msg_data || '*';
5141: end if;

Line 5164: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

5160: x_msg_count => l_msg_count,
5161: x_msg_data => l_msg_data);
5162:
5163:
5164: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5165: p_status := FND_API.G_RET_STS_ERROR;
5166: x_msg_count := x_msg_count + l_msg_count;
5167: if (l_msg_data is not null) then
5168: x_msg_data := x_msg_data || l_msg_data || '*';

Line 5165: p_status := FND_API.G_RET_STS_ERROR;

5161: x_msg_data => l_msg_data);
5162:
5163:
5164: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5165: p_status := FND_API.G_RET_STS_ERROR;
5166: x_msg_count := x_msg_count + l_msg_count;
5167: if (l_msg_data is not null) then
5168: x_msg_data := x_msg_data || l_msg_data || '*';
5169: end if;

Line 5178: p_status := FND_API.G_RET_STS_SUCCESS;

5174: END IF;
5175:
5176: END IF;
5177:
5178: p_status := FND_API.G_RET_STS_SUCCESS;
5179:
5180: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5181: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
5182: 'End-');

Line 5200: p_status := FND_API.G_RET_STS_ERROR;

5196: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5197: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5198: FND_MSG_PUB.ADD;
5199:
5200: p_status := FND_API.G_RET_STS_ERROR;
5201: write_error_messages(x_msg_data, x_msg_count);
5202:
5203: END pay_multiple_invoices;
5204:

Line 5278: l_return_status := FND_API.G_RET_STS_SUCCESS;

5274: l_debug_info VARCHAR2(200);
5275:
5276: BEGIN
5277: --Assign default values
5278: l_return_status := FND_API.G_RET_STS_SUCCESS;
5279: l_procedure_name := '.process_payment';
5280:
5281: arp_standard.debug('Entering credit card processing...'||p_cash_receipt_id);
5282: ---------------------------------------------------------------------------------

Line 5312: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen

5308: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);
5309: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
5310: FND_MSG_PUB.Add;
5311:
5312: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
5313: RETURN;
5314: end if;
5315: l_payment_trxn_extension_id:= rct_info.payment_trxn_extension_id;
5316: -- Step 1: (always performed):

Line 5358: p_init_msg_list => FND_API.G_TRUE,

5354:
5355:
5356: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
5357: p_api_version => 1.0,
5358: p_init_msg_list => FND_API.G_TRUE,
5359: x_return_status => l_return_status,
5360: x_msg_count => l_msg_count,
5361: x_msg_data => l_msg_data,
5362: p_payer => p_payer_rec,

Line 5393: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)

5389: -- check if call was successful
5390: --Add message to message stack only it it is called from iReceivables
5391: --if not pass the message stack received from iPayment
5392:
5393: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5394: AND (NVL(p_called_from,'NONE') = 'IREC') then
5395:
5396: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
5397: FND_MSG_PUB.Add;

Line 5403: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5399: --Bug 7673372 - When IBY API throws an error without contacting 3rd pmt system the error msg would
5400: --returned in x_response.Result_Message;
5401: x_msg_data := x_response.Result_Message;
5402: RETURN;
5403: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5404: p_cc_auth_code := x_auth_result.Auth_Code;
5405: x_return_status := l_return_status;
5406: RETURN;
5407: end if;

Line 5435: p_init_msg_list => FND_API.G_TRUE,

5431: l_debug_info := 'Call iPayment API to capture funds';
5432: ---------------------------------------------------------------------------------
5433: IBY_FNDCPT_TRXN_PUB.Create_Settlement(
5434: p_api_version => 1.0,
5435: p_init_msg_list => FND_API.G_TRUE,
5436: x_return_status => l_return_status,
5437: x_msg_count => l_msg_count,
5438: x_msg_data => l_msg_data,
5439: p_payer => p_payer_rec,

Line 5461: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then

5457:
5458: --Add message to message stack only it it is called from iReceivables
5459: --if not pass the message stack received from iPayment
5460:
5461: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then
5462: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
5463: FND_MSG_PUB.Add;
5464: end if;
5465: x_return_status := l_return_status;

Line 5482: x_return_status := FND_API.G_RET_STS_ERROR;

5478:
5479: EXCEPTION
5480: WHEN OTHERS THEN
5481: BEGIN
5482: x_return_status := FND_API.G_RET_STS_ERROR;
5483:
5484: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5485: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
5486: write_debug_and_log('- Return Status: '||x_return_status);

Line 6373: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

6369: BEGIN
6370: p_msg_data := p_msg_data || '*';
6371: p_msg_count := 0;
6372: LOOP
6373: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
6374: IF (l_msg_data IS NULL)THEN
6375: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_TRUE);
6376: IF (l_msg_data IS NULL)THEN
6377: EXIT;

Line 6375: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_TRUE);

6371: p_msg_count := 0;
6372: LOOP
6373: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
6374: IF (l_msg_data IS NULL)THEN
6375: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_TRUE);
6376: IF (l_msg_data IS NULL)THEN
6377: EXIT;
6378: END IF;
6379: END IF;

Line 6540: x_return_status := FND_API.G_RET_STS_ERROR;

6536: l_location_id := location_id_rec.location_id;
6537: l_object_version_number := location_id_rec.object_version_number;
6538: ELSE
6539: write_debug_and_log('No Location found for site:'||x_cc_bill_to_site_id );
6540: x_return_status := FND_API.G_RET_STS_ERROR;
6541: write_error_messages(x_msg_data, x_msg_count);
6542: RETURN;
6543: END IF;
6544: CLOSE location_id_cur;

Line 6559: p_init_msg_list => FND_API.G_TRUE,

6555: l_location_rec.state := p_cc_location_rec.state;
6556: l_location_rec.county := p_cc_location_rec.county;
6557:
6558: HZ_LOCATION_V2PUB.update_location(
6559: p_init_msg_list => FND_API.G_TRUE,
6560: p_location_rec => l_location_rec,
6561: p_object_version_number => l_object_version_number,
6562: x_return_status => x_return_status,
6563: x_msg_count => x_msg_count,

Line 6566: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

6562: x_return_status => x_return_status,
6563: x_msg_count => x_msg_count,
6564: x_msg_data => x_msg_data);
6565:
6566: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6567: x_return_status := FND_API.G_RET_STS_ERROR;
6568: write_error_messages(x_msg_data, x_msg_count);
6569: RETURN;
6570: END IF;

Line 6567: x_return_status := FND_API.G_RET_STS_ERROR;

6563: x_msg_count => x_msg_count,
6564: x_msg_data => x_msg_data);
6565:
6566: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6567: x_return_status := FND_API.G_RET_STS_ERROR;
6568: write_error_messages(x_msg_data, x_msg_count);
6569: RETURN;
6570: END IF;
6571:

Line 6574: x_return_status := FND_API.G_RET_STS_ERROR;

6570: END IF;
6571:
6572: EXCEPTION
6573: WHEN OTHERS THEN
6574: x_return_status := FND_API.G_RET_STS_ERROR;
6575:
6576: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
6577:
6578: write_debug_and_log('l_location_id'|| l_location_id);

Line 6642: x_return_status := FND_API.G_RET_STS_ERROR;

6638: x_billing_addr_use := useRecType.Instr_Billing_Address;
6639:
6640: EXCEPTION
6641: WHEN OTHERS THEN
6642: x_return_status := FND_API.G_RET_STS_ERROR;
6643:
6644: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
6645:
6646: write_debug_and_log('p_channel_code'|| p_channel_code);

Line 6697: x_return_status := FND_API.G_RET_STS_SUCCESS;

6693: LAST_UPDATE_DATE = l_last_update_date, LAST_UPDATED_BY = l_last_updated_by,
6694: LAST_UPDATE_LOGIN = l_last_update_login
6695: where payment_schedule_id = p_payment_schedule_id_list(trx);
6696:
6697: x_return_status := FND_API.G_RET_STS_SUCCESS;
6698: x_msg_count := 0;
6699:
6700: EXCEPTION
6701: WHEN OTHERS THEN

Line 6702: x_return_status := FND_API.G_RET_STS_ERROR;

6698: x_msg_count := 0;
6699:
6700: EXCEPTION
6701: WHEN OTHERS THEN
6702: x_return_status := FND_API.G_RET_STS_ERROR;
6703: FND_MSG_PUB.count_and_get(p_encoded => fnd_api.g_false,
6704: p_count => x_msg_count,
6705: p_data => x_msg_data);
6706:

Line 6703: FND_MSG_PUB.count_and_get(p_encoded => fnd_api.g_false,

6699:
6700: EXCEPTION
6701: WHEN OTHERS THEN
6702: x_return_status := FND_API.G_RET_STS_ERROR;
6703: FND_MSG_PUB.count_and_get(p_encoded => fnd_api.g_false,
6704: p_count => x_msg_count,
6705: p_data => x_msg_data);
6706:
6707: END update_invoice_payment_status;