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 924: p_init_msg_list => FND_API.G_TRUE,

920: l_create_credit_card.expiration_date := p_expiration_date;
921:
922: IBY_FNDCPT_SETUP_PUB.update_card(
923: p_api_version => 1.0,
924: p_init_msg_list => FND_API.G_TRUE,
925: p_commit => FND_API.G_FALSE,
926: x_return_status => x_return_status,
927: x_msg_count => x_msg_count,
928: x_msg_data => x_msg_data,

Line 925: p_commit => FND_API.G_FALSE,

921:
922: IBY_FNDCPT_SETUP_PUB.update_card(
923: p_api_version => 1.0,
924: p_init_msg_list => FND_API.G_TRUE,
925: p_commit => FND_API.G_FALSE,
926: x_return_status => x_return_status,
927: x_msg_count => x_msg_count,
928: x_msg_data => x_msg_data,
929: p_card_instrument => l_create_credit_card,

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

929: p_card_instrument => l_create_credit_card,
930: x_response => l_result_rec);
931:
932:
933: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
934: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
935: fnd_log.string(fnd_log.LEVEL_STATEMENT,
936: G_PKG_NAME||l_procedure_name,
937: 'ERROR IN UPDATING CREDIT CARD');

Line 942: x_return_status := FND_API.G_RET_STS_ERROR;

938: fnd_log.string(fnd_log.LEVEL_STATEMENT,
939: G_PKG_NAME||l_procedure_name,l_result_rec.result_code);
940: end if;
941: x_msg_data := l_result_rec.result_code;
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: write_error_messages(x_msg_data, x_msg_count);
944: END IF;
945: ELSE
946:

Line 972: p_init_msg_list => FND_API.G_TRUE,

968: 'l_acct_type '||l_acct_type||' l_start_date '||l_start_date);
969:
970: IBY_EXT_BANKACCT_PUB.update_ext_bank_acct(
971: p_api_version => 1.0,
972: p_init_msg_list => FND_API.G_TRUE,
973: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
974: x_return_status => x_return_status,
975: x_msg_count => x_msg_count,
976: x_msg_data => x_msg_data,

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

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

Line 988: x_return_status := FND_API.G_RET_STS_ERROR;

984: 'ERROR IN UPDATING BANK ACCOUNT');
985: fnd_log.string(fnd_log.LEVEL_STATEMENT,
986: G_PKG_NAME||l_procedure_name,x_msg_data);
987: end if;
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: write_error_messages(x_msg_data, x_msg_count);
990: END IF;
991: END IF;
992:

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

1740: , x_return_status => p_status
1741: , x_msg_count => l_msg_count
1742: , x_msg_data => l_msg_data);
1743:
1744: IF ( p_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1745: write_error_messages(l_msg_data, l_msg_count);
1746: ROLLBACK TO STORE_INST;
1747: RETURN;
1748: END IF;

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

1766: , x_return_status => p_status
1767: , x_msg_count => l_msg_count
1768: , x_msg_data => l_msg_data);
1769:
1770: IF ( p_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1771: write_error_messages(l_msg_data, l_msg_count);
1772: ROLLBACK TO STORE_INST;
1773: RETURN;
1774: END IF;

Line 1844: p_init_msg_list => FND_API.G_FALSE,

1840: IF p_routing_number IS NULL THEN
1841:
1842: IBY_FNDCPT_SETUP_PUB.Card_Exists(
1843: p_api_version => 1.0,
1844: p_init_msg_list => FND_API.G_FALSE,
1845: x_return_status => l_return_status,
1846: x_msg_count => l_msg_count,
1847: x_msg_data => l_msg_data,
1848: p_owner_id => null,

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

1849: p_card_number => p_bank_account_number,
1850: x_card_instrument => l_create_credit_card,
1851: x_response => l_result_rec);
1852:
1853: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1854: -- no card exists
1855: return 0;
1856: ELSE
1857: OPEN cc_cur(l_create_credit_card.card_id);

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

2058: --Bug 3810143 - Ensure that the messages are picked up from the message
2059: --stack in any case.
2060: FOR l_count IN 1..p_msg_count LOOP
2061:
2062: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
2063: write_debug_and_log(to_char(l_count)||' : '||l_msg_data);
2064:
2065: END LOOP;
2066:

Line 2799: l_commit := FND_API.G_FALSE;

2795:
2796: BEGIN
2797:
2798: l_procedure_name := '.create_payment_instrument';
2799: l_commit := FND_API.G_FALSE;
2800:
2801: IF (p_payment_instrument = 'BANK_ACCOUNT') THEN
2802: --------------------------------------------------------------------------------------------------------
2803: l_debug_info := 'Call IBY create external bank acct - create_ext_bank_acct - to Create a new bank account';

Line 2819: p_init_msg_list => FND_API.G_FALSE,

2815: l_ext_bank_act_rec.iban := p_iban;
2816:
2817: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct(
2818: p_api_version => 1.0,
2819: p_init_msg_list => FND_API.G_FALSE,
2820: p_ext_bank_acct_rec => l_ext_bank_act_rec,
2821: x_acct_id => l_bank_account_id,
2822: x_return_status => x_return_status,
2823: x_msg_count => x_msg_count,

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

2824: x_msg_data => x_msg_data,
2825: x_response => l_result_rec);
2826:
2827: write_debug_and_log('l_bank_account_id :'||l_bank_account_id);
2828: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2829: x_msg_data := l_result_rec.result_code;
2830: p_status := FND_API.G_RET_STS_ERROR;
2831: write_error_messages(x_msg_data, x_msg_count);
2832: RETURN;

Line 2830: p_status := FND_API.G_RET_STS_ERROR;

2826:
2827: write_debug_and_log('l_bank_account_id :'||l_bank_account_id);
2828: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2829: x_msg_data := l_result_rec.result_code;
2830: p_status := FND_API.G_RET_STS_ERROR;
2831: write_error_messages(x_msg_data, x_msg_count);
2832: RETURN;
2833: END IF;
2834:

Line 2862: p_init_msg_list => FND_API.G_FALSE,

2858: l_create_credit_card.Info_Only_Flag := 'N';
2859:
2860: IBY_FNDCPT_SETUP_PUB.create_card(
2861: p_api_version => 1.0,
2862: p_init_msg_list => FND_API.G_FALSE,
2863: p_commit => l_commit,
2864: x_return_status => x_return_status,
2865: x_msg_count => x_msg_count,
2866: x_msg_data => x_msg_data,

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

2868: x_card_id => l_bank_account_id,
2869: x_response => l_result_rec);
2870:
2871: write_debug_and_log('l_card_id :'||l_bank_account_id);
2872: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2873: p_status := FND_API.G_RET_STS_ERROR;
2874: x_msg_data := l_result_rec.result_code;
2875: write_error_messages(x_msg_data, x_msg_count);
2876: RETURN;

Line 2873: p_status := FND_API.G_RET_STS_ERROR;

2869: x_response => l_result_rec);
2870:
2871: write_debug_and_log('l_card_id :'||l_bank_account_id);
2872: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2873: p_status := FND_API.G_RET_STS_ERROR;
2874: x_msg_data := l_result_rec.result_code;
2875: write_error_messages(x_msg_data, x_msg_count);
2876: RETURN;
2877: END IF;

Line 2912: p_init_msg_list => FND_API.G_FALSE,

2908:
2909:
2910: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
2911: p_api_version => 1.0,
2912: p_init_msg_list => FND_API.G_FALSE,
2913: p_commit => FND_API.G_TRUE,
2914: x_return_status => x_return_status,
2915: x_msg_count => x_msg_count,
2916: x_msg_data => x_msg_data,

Line 2913: p_commit => FND_API.G_TRUE,

2909:
2910: IBY_FNDCPT_SETUP_PUB.Set_Payer_Instr_Assignment(
2911: p_api_version => 1.0,
2912: p_init_msg_list => FND_API.G_FALSE,
2913: p_commit => FND_API.G_TRUE,
2914: x_return_status => x_return_status,
2915: x_msg_count => x_msg_count,
2916: x_msg_data => x_msg_data,
2917: p_payer => l_payerContext_Rec_type,

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

2919: x_assign_id => l_assignment_id,
2920: x_response => l_result_rec
2921: );
2922:
2923: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2924: p_status := FND_API.G_RET_STS_ERROR;
2925: x_msg_data := l_result_rec.result_code;
2926: write_error_messages(x_msg_data, x_msg_count);
2927: RETURN;

Line 2924: p_status := FND_API.G_RET_STS_ERROR;

2920: x_response => l_result_rec
2921: );
2922:
2923: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2924: p_status := FND_API.G_RET_STS_ERROR;
2925: x_msg_data := l_result_rec.result_code;
2926: write_error_messages(x_msg_data, x_msg_count);
2927: RETURN;
2928: END IF;

Line 2949: p_status := FND_API.G_RET_STS_ERROR;

2945:
2946:
2947: EXCEPTION
2948: WHEN OTHERS THEN
2949: p_status := FND_API.G_RET_STS_ERROR;
2950: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
2951: write_debug_and_log('- Card Number: '||p_account_number);
2952: write_debug_and_log('- CC Billing Addrress Site Id: '||p_cc_bill_to_site_id);
2953: write_debug_and_log('- Singe Use Flag: '||p_single_use_flag);

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

2983: | Date Author Description of Changes
2984: | 17-Aug-2005 rsinthre Created
2985: +============================================================*/
2986: PROCEDURE create_cc_bill_to_site(
2987: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2988: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2989: p_cc_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2990: p_payer_party_id IN NUMBER,
2991: x_cc_bill_to_site_id IN OUT NOCOPY NUMBER,

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

2984: | 17-Aug-2005 rsinthre Created
2985: +============================================================*/
2986: PROCEDURE create_cc_bill_to_site(
2987: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2988: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2989: p_cc_location_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
2990: p_payer_party_id IN NUMBER,
2991: x_cc_bill_to_site_id IN OUT NOCOPY NUMBER,
2992: x_return_status OUT NOCOPY VARCHAR2,

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

3019: x_return_status => x_return_status,
3020: x_msg_count => x_msg_count,
3021: x_msg_data => x_msg_data);
3022:
3023: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025: write_error_messages(x_msg_data, x_msg_count);
3026: RETURN;
3027: END IF;

Line 3024: x_return_status := FND_API.G_RET_STS_ERROR;

3020: x_msg_count => x_msg_count,
3021: x_msg_data => x_msg_data);
3022:
3023: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025: write_error_messages(x_msg_data, x_msg_count);
3026: RETURN;
3027: END IF;
3028:

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

3044: );
3045:
3046: write_debug_and_log('cc_billing_site_id :'||x_cc_bill_to_site_id);
3047:
3048: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050: write_error_messages(x_msg_data, x_msg_count);
3051: RETURN;
3052: END IF;

Line 3049: x_return_status := FND_API.G_RET_STS_ERROR;

3045:
3046: write_debug_and_log('cc_billing_site_id :'||x_cc_bill_to_site_id);
3047:
3048: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050: write_error_messages(x_msg_data, x_msg_count);
3051: RETURN;
3052: END IF;
3053:

Line 3056: x_return_status := FND_API.G_RET_STS_ERROR;

3052: END IF;
3053:
3054: EXCEPTION
3055: WHEN OTHERS THEN
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057:
3058: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3059: write_debug_and_log('- Return Status: '||x_return_status);
3060: write_debug_and_log('ERROR =>'|| SQLERRM);

Line 3137: p_init_msg_list => FND_API.G_TRUE,

3133: -------------------------------------------------------------------------------------------
3134:
3135: AR_RECEIPT_API_PUB.create_cash(
3136: p_api_version => 1.0,
3137: p_init_msg_list => FND_API.G_TRUE,
3138: p_commit => FND_API.G_FALSE,
3139: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3140: x_return_status => x_return_status,
3141: x_msg_count => x_msg_count,

Line 3138: p_commit => FND_API.G_FALSE,

3134:
3135: AR_RECEIPT_API_PUB.create_cash(
3136: p_api_version => 1.0,
3137: p_init_msg_list => FND_API.G_TRUE,
3138: p_commit => FND_API.G_FALSE,
3139: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3140: x_return_status => x_return_status,
3141: x_msg_count => x_msg_count,
3142: x_msg_data => x_msg_data,

Line 3139: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3135: AR_RECEIPT_API_PUB.create_cash(
3136: p_api_version => 1.0,
3137: p_init_msg_list => FND_API.G_TRUE,
3138: p_commit => FND_API.G_FALSE,
3139: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3140: x_return_status => x_return_status,
3141: x_msg_count => x_msg_count,
3142: x_msg_data => x_msg_data,
3143: p_amount => p_payment_amount,

Line 3173: p_status := FND_API.G_RET_STS_ERROR;

3169: arp_standard.debug('X_MSG_COUNT=>'||to_char(X_MSG_COUNT));
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN
3173: p_status := FND_API.G_RET_STS_ERROR;
3174:
3175: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3176: write_debug_and_log('- Customer Id: '||p_customer_id);
3177: write_debug_and_log('- Customer Site Id: '||p_site_use_id);

Line 3344: p_init_msg_list => FND_API.G_TRUE,

3340: end if;
3341:
3342: AR_RECEIPT_API_PUB.apply(
3343: p_api_version => 1.0,
3344: p_init_msg_list => FND_API.G_TRUE,
3345: p_commit => FND_API.G_FALSE,
3346: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3347: x_return_status => x_return_status,
3348: x_msg_count => x_msg_count,

Line 3345: p_commit => FND_API.G_FALSE,

3341:
3342: AR_RECEIPT_API_PUB.apply(
3343: p_api_version => 1.0,
3344: p_init_msg_list => FND_API.G_TRUE,
3345: p_commit => FND_API.G_FALSE,
3346: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3347: x_return_status => x_return_status,
3348: x_msg_count => x_msg_count,
3349: x_msg_data => x_msg_data,

Line 3346: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3342: AR_RECEIPT_API_PUB.apply(
3343: p_api_version => 1.0,
3344: p_init_msg_list => FND_API.G_TRUE,
3345: p_commit => FND_API.G_FALSE,
3346: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3347: x_return_status => x_return_status,
3348: x_msg_count => x_msg_count,
3349: x_msg_data => x_msg_data,
3350: p_cash_receipt_id => p_cash_receipt_id,

Line 3380: p_init_msg_list => FND_API.G_TRUE,

3376: end if;
3377:
3378: AR_RECEIPT_API_PUB.apply_open_receipt
3379: (p_api_version => 1.0,
3380: p_init_msg_list => FND_API.G_TRUE,
3381: p_commit => FND_API.G_FALSE,
3382: x_return_status => x_return_status,
3383: x_msg_count => x_msg_count,
3384: x_msg_data => x_msg_data,

Line 3381: p_commit => FND_API.G_FALSE,

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

Line 3408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3404: end if;
3405:
3406: -- Check for errors and increment the count for
3407: -- errored applcations
3408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3409: l_apply_err_count := l_apply_err_count + 1;
3410: p_apply_err_count := l_apply_err_count;
3411: p_return_status := FND_API.G_RET_STS_ERROR;
3412: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;

Line 3411: p_return_status := FND_API.G_RET_STS_ERROR;

3407: -- errored applcations
3408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3409: l_apply_err_count := l_apply_err_count + 1;
3410: p_apply_err_count := l_apply_err_count;
3411: p_return_status := FND_API.G_RET_STS_ERROR;
3412: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;
3413: RETURN;
3414: END IF;
3415:

Line 3451: p_init_msg_list => FND_API.G_TRUE,

3447: -- Call the application API
3448: --
3449: AR_RECEIPT_API_PUB.apply(
3450: p_api_version => 1.0,
3451: p_init_msg_list => FND_API.G_TRUE,
3452: p_commit => FND_API.G_FALSE,
3453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3454: x_return_status => x_return_status,
3455: x_msg_count => x_msg_count,

Line 3452: p_commit => FND_API.G_FALSE,

3448: --
3449: AR_RECEIPT_API_PUB.apply(
3450: p_api_version => 1.0,
3451: p_init_msg_list => FND_API.G_TRUE,
3452: p_commit => FND_API.G_FALSE,
3453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3454: x_return_status => x_return_status,
3455: x_msg_count => x_msg_count,
3456: x_msg_data => x_msg_data,

Line 3453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3449: AR_RECEIPT_API_PUB.apply(
3450: p_api_version => 1.0,
3451: p_init_msg_list => FND_API.G_TRUE,
3452: p_commit => FND_API.G_FALSE,
3453: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3454: x_return_status => x_return_status,
3455: x_msg_count => x_msg_count,
3456: x_msg_data => x_msg_data,
3457: p_cash_receipt_id => p_cash_receipt_id,

Line 3472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3468: end if;
3469:
3470: -- Check for errors and increment the count for
3471: -- errored applcations
3472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3473: l_apply_err_count := l_apply_err_count + 1;
3474: p_apply_err_count := l_apply_err_count;
3475: p_return_status := FND_API.G_RET_STS_ERROR;
3476: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;

Line 3475: p_return_status := FND_API.G_RET_STS_ERROR;

3471: -- errored applcations
3472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3473: l_apply_err_count := l_apply_err_count + 1;
3474: p_apply_err_count := l_apply_err_count;
3475: p_return_status := FND_API.G_RET_STS_ERROR;
3476: ROLLBACK TO ARI_Apply_Cash_Receipt_PVT;
3477: RETURN;
3478: END IF;
3479:

Line 3492: p_return_status := FND_API.G_RET_STS_SUCCESS;

3488:
3489: p_apply_err_count := l_apply_err_count;
3490: -- There are no errored applications; set the
3491: -- return status to success
3492: p_return_status := FND_API.G_RET_STS_SUCCESS;
3493:
3494: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3495: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Exiting apply_cash with return status: '||p_return_status);
3496: end if;

Line 3501: p_return_status := FND_API.G_RET_STS_ERROR;

3497:
3498: EXCEPTION
3499: WHEN OTHERS THEN
3500: BEGIN
3501: p_return_status := FND_API.G_RET_STS_ERROR;
3502:
3503: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3504: write_debug_and_log('- Customer Id: '||p_customer_id);
3505: write_debug_and_log('- Customer Site Id: '||p_site_use_id);

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

3768: l_debug_info := 'Apply service charge';
3769: ----------------------------------------------------------------------------------
3770: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);
3771:
3772: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3773: -- bug 3672530 - Ensure graceful error handling
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3776: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);

Line 3774: x_return_status := FND_API.G_RET_STS_ERROR;

3770: l_return_status := ARI_SERVICE_CHARGE_PKG.apply_charge(l_invoice_list);
3771:
3772: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3773: -- bug 3672530 - Ensure graceful error handling
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3776: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'ERROR: Loop count is: '||l_count);
3777: end if;
3778: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3788: x_return_status := FND_API.G_RET_STS_ERROR;

3784:
3785: EXCEPTION
3786: WHEN OTHERS THEN
3787: BEGIN
3788: x_return_status := FND_API.G_RET_STS_ERROR;
3789:
3790: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
3791: write_debug_and_log('- Customer Id: '||p_customer_id);
3792: write_debug_and_log('- Customer Site Id: '||p_site_use_id);

Line 3927: l_call_payment_processor := FND_API.G_TRUE;

3923: BEGIN
3924: --Assign default values
3925:
3926: l_receipt_currency_code := 'USD';
3927: l_call_payment_processor := FND_API.G_TRUE;
3928: l_apply_err_count := 0;
3929: x_msg_count := 0;
3930: x_msg_data := '';
3931: l_procedure_name := '.pay_multiple_invoices';

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

4027: x_billing_addr_use => l_billing_addr_use,
4028: x_msg_count => x_msg_count,
4029: x_msg_data => x_msg_data
4030: );
4031: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4032:
4033: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4034: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4035: G_PKG_NAME||l_procedure_name,

Line 4039: x_return_status := FND_API.G_RET_STS_ERROR;

4035: G_PKG_NAME||l_procedure_name,
4036: 'ERROR IN GETTING IBY PAYMENT CHANNEL ATTRIBUTES');
4037: end if;
4038:
4039: x_return_status := FND_API.G_RET_STS_ERROR;
4040: write_error_messages(x_msg_data, x_msg_count);
4041: RETURN;
4042: END IF;
4043:

Line 4098: p_init_msg_list => FND_API.G_FALSE,

4094:
4095: IF(p_payment_instrument = 'CREDIT_CARD') and l_cc_bill_to_site_id = -1 THEN
4096: IF(l_billing_addr_use = 'REQUIRED') THEN
4097: create_cc_bill_to_site(
4098: p_init_msg_list => FND_API.G_FALSE,
4099: p_commit => FND_API.G_FALSE,
4100: p_cc_location_rec => l_cc_location_rec,
4101: p_payer_party_id => l_payer_party_id,
4102: x_cc_bill_to_site_id => l_cc_bill_to_site_id,

Line 4099: p_commit => FND_API.G_FALSE,

4095: IF(p_payment_instrument = 'CREDIT_CARD') and l_cc_bill_to_site_id = -1 THEN
4096: IF(l_billing_addr_use = 'REQUIRED') THEN
4097: create_cc_bill_to_site(
4098: p_init_msg_list => FND_API.G_FALSE,
4099: p_commit => FND_API.G_FALSE,
4100: p_cc_location_rec => l_cc_location_rec,
4101: p_payer_party_id => l_payer_party_id,
4102: x_cc_bill_to_site_id => l_cc_bill_to_site_id,
4103: x_return_status => x_return_status,

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

4103: x_return_status => x_return_status,
4104: x_msg_count => l_msg_count,
4105: x_msg_data => l_msg_data);
4106:
4107: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4108:
4109: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4110: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4111: G_PKG_NAME||l_procedure_name,

Line 4115: p_status := FND_API.G_RET_STS_ERROR;

4111: G_PKG_NAME||l_procedure_name,
4112: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4113: end if;
4114:
4115: p_status := FND_API.G_RET_STS_ERROR;
4116: ROLLBACK TO ARI_Create_Cash_PVT;
4117: write_error_messages(x_msg_data, x_msg_count);
4118: RETURN;
4119: END IF;

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

4151: p_bank_account_id => p_bank_account_id) ;
4152:
4153:
4154: -- Check if the payment instrument was created successfully
4155: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4156: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4157: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4158: G_PKG_NAME||l_procedure_name,
4159: 'ERROR IN CREATING PAYMENT INSTRUMENT');

Line 4162: p_status := FND_API.G_RET_STS_ERROR;

4158: G_PKG_NAME||l_procedure_name,
4159: 'ERROR IN CREATING PAYMENT INSTRUMENT');
4160: end if;
4161:
4162: p_status := FND_API.G_RET_STS_ERROR;
4163: write_error_messages(x_msg_data, x_msg_count);
4164: ROLLBACK TO ARI_Create_Cash_PVT;
4165: RETURN;
4166: ELSE

Line 4227: p_init_msg_list =>FND_API.G_TRUE,

4223:
4224: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
4225: (
4226: p_api_version =>1.0,
4227: p_init_msg_list =>FND_API.G_TRUE,
4228: p_commit => FND_API.G_FALSE,
4229: x_return_status =>x_return_status,
4230: x_msg_count =>l_msg_count,
4231: x_msg_data => l_msg_data,

Line 4228: p_commit => FND_API.G_FALSE,

4224: IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension
4225: (
4226: p_api_version =>1.0,
4227: p_init_msg_list =>FND_API.G_TRUE,
4228: p_commit => FND_API.G_FALSE,
4229: x_return_status =>x_return_status,
4230: x_msg_count =>l_msg_count,
4231: x_msg_data => l_msg_data,
4232: p_payer => l_payer_rec,

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

4235: p_trxn_attribs => l_trxn_rec,
4236: x_entity_id => l_extn_id,
4237: x_response => l_result_rec);
4238:
4239: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4240: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4241: fnd_log.string(fnd_log.LEVEL_STATEMENT,
4242: G_PKG_NAME||l_procedure_name,
4243: 'ERROR IN CREATING TRANSACTION EXTENSION');

Line 4254: p_status := FND_API.G_RET_STS_ERROR;

4250: x_msg_data := x_msg_data || l_msg_data || '*';
4251: end if;
4252:
4253: x_msg_data := x_msg_data || '*' || l_result_rec.result_code;
4254: p_status := FND_API.G_RET_STS_ERROR;
4255: ROLLBACK TO ARI_Create_Cash_PVT;
4256: write_error_messages(x_msg_data, x_msg_count);
4257: RETURN;
4258: END IF;

Line 4295: l_call_payment_processor := FND_API.G_FALSE;

4291: | iPayment is called in receivables remittance process |
4292: +------------------------------------------------------*/
4293: IF (fnd_function.test('ARIPAYMENTDEMOMODE')
4294: OR p_payment_instrument = 'BANK_ACCOUNT') THEN /* J Rautiainen ACH Implementation */
4295: l_call_payment_processor := FND_API.G_FALSE;
4296: ELSE
4297: l_call_payment_processor := FND_API.G_TRUE;
4298: END IF;
4299:

Line 4297: l_call_payment_processor := FND_API.G_TRUE;

4293: IF (fnd_function.test('ARIPAYMENTDEMOMODE')
4294: OR p_payment_instrument = 'BANK_ACCOUNT') THEN /* J Rautiainen ACH Implementation */
4295: l_call_payment_processor := FND_API.G_FALSE;
4296: ELSE
4297: l_call_payment_processor := FND_API.G_TRUE;
4298: END IF;
4299:
4300: IF (p_receipt_site_id <> -1) THEN
4301: l_site_use_id := p_receipt_site_id;

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

4333: end if;
4334:
4335: -- Check for error in receipt creation. If it is an error
4336: -- the rollback and return.
4337: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR p_cash_receipt_id IS NULL ) THEN
4338: --Bug 3672530 - Error handling
4339: p_status := FND_API.G_RET_STS_ERROR;
4340: ROLLBACK TO ARI_Create_Cash_PVT;
4341: write_error_messages(x_msg_data, x_msg_count);

Line 4339: p_status := FND_API.G_RET_STS_ERROR;

4335: -- Check for error in receipt creation. If it is an error
4336: -- the rollback and return.
4337: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS OR p_cash_receipt_id IS NULL ) THEN
4338: --Bug 3672530 - Error handling
4339: p_status := FND_API.G_RET_STS_ERROR;
4340: ROLLBACK TO ARI_Create_Cash_PVT;
4341: write_error_messages(x_msg_data, x_msg_count);
4342: RETURN;
4343: END IF;

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

4354: ---------------------------------------------------------------------------------
4355: l_debug_info := 'Service charge enabled: adjust the invoice with service charge';
4356: ---------------------------------------------------------------------------------
4357: apply_service_charge(p_customer_id, l_site_use_id, x_return_status);
4358: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4359: --Bug 3672530 - Error handling
4360: p_status := FND_API.G_RET_STS_ERROR;
4361: ROLLBACK TO ARI_Create_Cash_PVT;
4362: write_error_messages(x_msg_data, x_msg_count);

Line 4360: p_status := FND_API.G_RET_STS_ERROR;

4356: ---------------------------------------------------------------------------------
4357: apply_service_charge(p_customer_id, l_site_use_id, x_return_status);
4358: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4359: --Bug 3672530 - Error handling
4360: p_status := FND_API.G_RET_STS_ERROR;
4361: ROLLBACK TO ARI_Create_Cash_PVT;
4362: write_error_messages(x_msg_data, x_msg_count);
4363: RETURN;
4364: END IF;

Line 4399: p_status := FND_API.G_RET_STS_ERROR;

4395: x_msg_count := x_msg_count + l_msg_count;
4396: if (l_msg_data is not null) then
4397: x_msg_data := x_msg_data || l_msg_data || '*';
4398: end if;
4399: p_status := FND_API.G_RET_STS_ERROR;
4400: ROLLBACK TO ARI_Create_Cash_PVT;
4401: write_error_messages(x_msg_data, x_msg_count);
4402: RETURN;
4403: END IF;

Line 4409: l_call_payment_processor = FND_API.G_TRUE) THEN

4405: -- Seems like all is fine. So we shall go ahead and
4406: -- do the final task of capturing the CC payment
4407: -- only if it is a credit card payment
4408: IF (p_payment_instrument = 'CREDIT_CARD' AND
4409: l_call_payment_processor = FND_API.G_TRUE) THEN
4410:
4411: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4412: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Calling process_payment .....');
4413: end if;

Line 4432: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4428: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Response Code: '|| l_response_error_code);
4429: end if;
4430: -- If the payment processor call fails, then we need to rollback all the changes
4431: -- made in the create() and apply() routines also.
4432: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4433: x_msg_count := x_msg_count + l_msg_count;
4434: if (l_msg_data is not null) then
4435: x_msg_data := x_msg_data || l_msg_data || '*';
4436: end if;

Line 4440: p_status := FND_API.G_RET_STS_ERROR;

4436: end if;
4437:
4438: x_msg_data := x_msg_data || '*' || l_result_rec.result_code;
4439: --Bug 3672530 - Error handling
4440: p_status := FND_API.G_RET_STS_ERROR;
4441: ROLLBACK TO ARI_Create_Cash_PVT;
4442: write_error_messages(x_msg_data, x_msg_count);
4443: RETURN; -- exit back to caller
4444: END IF;

Line 4465: p_init_msg_list => FND_API.G_TRUE,

4461:
4462: IBY_FNDCPT_SETUP_PUB.Update_Card
4463: (
4464: p_api_version => 1.0,
4465: p_init_msg_list => FND_API.G_TRUE,
4466: p_commit => FND_API.G_FALSE,
4467: x_return_status => x_return_status,
4468: x_msg_count => l_msg_count,
4469: x_msg_data => l_msg_data,

Line 4466: p_commit => FND_API.G_FALSE,

4462: IBY_FNDCPT_SETUP_PUB.Update_Card
4463: (
4464: p_api_version => 1.0,
4465: p_init_msg_list => FND_API.G_TRUE,
4466: p_commit => FND_API.G_FALSE,
4467: x_return_status => x_return_status,
4468: x_msg_count => l_msg_count,
4469: x_msg_data => l_msg_data,
4470: p_card_instrument => l_create_credit_card,

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

4470: p_card_instrument => l_create_credit_card,
4471: x_response => l_result_rec_type
4472: );
4473:
4474: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4475: p_status := FND_API.G_RET_STS_ERROR;
4476: x_msg_count := x_msg_count + l_msg_count;
4477: if (l_msg_data is not null) then
4478: x_msg_data := x_msg_data || l_msg_data || '*';

Line 4475: p_status := FND_API.G_RET_STS_ERROR;

4471: x_response => l_result_rec_type
4472: );
4473:
4474: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4475: p_status := FND_API.G_RET_STS_ERROR;
4476: x_msg_count := x_msg_count + l_msg_count;
4477: if (l_msg_data is not null) then
4478: x_msg_data := x_msg_data || l_msg_data || '*';
4479: end if;

Line 4500: p_init_msg_list => FND_API.G_TRUE,

4496:
4497: IBY_FNDCPT_SETUP_PUB.Update_Card
4498: (
4499: p_api_version => 1.0,
4500: p_init_msg_list => FND_API.G_TRUE,
4501: p_commit => FND_API.G_FALSE,
4502: x_return_status => x_return_status,
4503: x_msg_count => l_msg_count,
4504: x_msg_data => l_msg_data,

Line 4501: p_commit => FND_API.G_FALSE,

4497: IBY_FNDCPT_SETUP_PUB.Update_Card
4498: (
4499: p_api_version => 1.0,
4500: p_init_msg_list => FND_API.G_TRUE,
4501: p_commit => FND_API.G_FALSE,
4502: x_return_status => x_return_status,
4503: x_msg_count => l_msg_count,
4504: x_msg_data => l_msg_data,
4505: p_card_instrument => l_create_credit_card,

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

4505: p_card_instrument => l_create_credit_card,
4506: x_response => l_result_rec_type
4507: );
4508:
4509: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4510: p_status := FND_API.G_RET_STS_ERROR;
4511: x_msg_count := x_msg_count + l_msg_count;
4512: if (l_msg_data is not null) then
4513: x_msg_data := x_msg_data || l_msg_data || '*';

Line 4510: p_status := FND_API.G_RET_STS_ERROR;

4506: x_response => l_result_rec_type
4507: );
4508:
4509: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4510: p_status := FND_API.G_RET_STS_ERROR;
4511: x_msg_count := x_msg_count + l_msg_count;
4512: if (l_msg_data is not null) then
4513: x_msg_data := x_msg_data || l_msg_data || '*';
4514: end if;

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

4534: x_msg_count => l_msg_count,
4535: x_msg_data => l_msg_data);
4536:
4537:
4538: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4539: p_status := FND_API.G_RET_STS_ERROR;
4540: x_msg_count := x_msg_count + l_msg_count;
4541: if (l_msg_data is not null) then
4542: x_msg_data := x_msg_data || l_msg_data || '*';

Line 4539: p_status := FND_API.G_RET_STS_ERROR;

4535: x_msg_data => l_msg_data);
4536:
4537:
4538: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4539: p_status := FND_API.G_RET_STS_ERROR;
4540: x_msg_count := x_msg_count + l_msg_count;
4541: if (l_msg_data is not null) then
4542: x_msg_data := x_msg_data || l_msg_data || '*';
4543: end if;

Line 4552: p_status := FND_API.G_RET_STS_SUCCESS;

4548: END IF;
4549:
4550: END IF;
4551:
4552: p_status := FND_API.G_RET_STS_SUCCESS;
4553:
4554: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4555: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,
4556: 'End-');

Line 4574: p_status := FND_API.G_RET_STS_ERROR;

4570: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4571: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
4572: FND_MSG_PUB.ADD;
4573:
4574: p_status := FND_API.G_RET_STS_ERROR;
4575: write_error_messages(x_msg_data, x_msg_count);
4576:
4577: END pay_multiple_invoices;
4578:

Line 4650: l_return_status := FND_API.G_RET_STS_SUCCESS;

4646: l_debug_info VARCHAR2(200);
4647:
4648: BEGIN
4649: --Assign default values
4650: l_return_status := FND_API.G_RET_STS_SUCCESS;
4651: l_procedure_name := '.process_payment';
4652:
4653: arp_standard.debug('Entering credit card processing...'||p_cash_receipt_id);
4654: ---------------------------------------------------------------------------------

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

4680: arp_standard.debug('ERROR: Creation status is ' || rct_info.creation_status);
4681: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
4682: FND_MSG_PUB.Add;
4683:
4684: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
4685: RETURN;
4686: end if;
4687: l_payment_trxn_extension_id:= rct_info.payment_trxn_extension_id;
4688: -- Step 1: (always performed):

Line 4725: p_init_msg_list => FND_API.G_TRUE,

4721:
4722:
4723: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
4724: p_api_version => 1.0,
4725: p_init_msg_list => FND_API.G_TRUE,
4726: x_return_status => l_return_status,
4727: x_msg_count => l_msg_count,
4728: x_msg_data => l_msg_data,
4729: p_payer => p_payer_rec,

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

4756: -- check if call was successful
4757: --Add message to message stack only it it is called from iReceivables
4758: --if not pass the message stack received from iPayment
4759:
4760: if (l_return_status <> FND_API.G_RET_STS_SUCCESS)
4761: AND (NVL(p_called_from,'NONE') = 'IREC') then
4762:
4763: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');
4764: FND_MSG_PUB.Add;

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

4766: --Bug 7673372 - When IBY API throws an error without contacting 3rd pmt system the error msg would
4767: --returned in x_response.Result_Message;
4768: x_msg_data := x_response.Result_Message;
4769: RETURN;
4770: elsif (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4771: x_return_status := l_return_status;
4772: RETURN;
4773: end if;
4774:

Line 4801: p_init_msg_list => FND_API.G_TRUE,

4797: l_debug_info := 'Call iPayment API to capture funds';
4798: ---------------------------------------------------------------------------------
4799: IBY_FNDCPT_TRXN_PUB.Create_Settlement(
4800: p_api_version => 1.0,
4801: p_init_msg_list => FND_API.G_TRUE,
4802: x_return_status => l_return_status,
4803: x_msg_count => l_msg_count,
4804: x_msg_data => l_msg_data,
4805: p_payer => p_payer_rec,

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

4823:
4824: --Add message to message stack only it it is called from iReceivables
4825: --if not pass the message stack received from iPayment
4826:
4827: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) AND (NVL(p_called_from,'NONE') = 'IREC') then
4828: FND_MESSAGE.set_name('AR', 'AR_CC_CAPTURE_FAILED');
4829: FND_MSG_PUB.Add;
4830: end if;
4831: x_return_status := l_return_status;

Line 4848: x_return_status := FND_API.G_RET_STS_ERROR;

4844:
4845: EXCEPTION
4846: WHEN OTHERS THEN
4847: BEGIN
4848: x_return_status := FND_API.G_RET_STS_ERROR;
4849:
4850: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
4851: write_debug_and_log('- Cash Receipt Id: '||p_cash_receipt_id);
4852: write_debug_and_log('- Return Status: '||x_return_status);

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

5722: BEGIN
5723: p_msg_data := p_msg_data || '*';
5724: p_msg_count := 0;
5725: LOOP
5726: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
5727: IF (l_msg_data IS NULL)THEN
5728: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_TRUE);
5729: IF (l_msg_data IS NULL)THEN
5730: EXIT;

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

5724: p_msg_count := 0;
5725: LOOP
5726: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
5727: IF (l_msg_data IS NULL)THEN
5728: l_msg_data:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_TRUE);
5729: IF (l_msg_data IS NULL)THEN
5730: EXIT;
5731: END IF;
5732: END IF;

Line 5892: x_return_status := FND_API.G_RET_STS_ERROR;

5888: l_location_id := location_id_rec.location_id;
5889: l_object_version_number := location_id_rec.object_version_number;
5890: ELSE
5891: write_debug_and_log('No Location found for site:'||x_cc_bill_to_site_id );
5892: x_return_status := FND_API.G_RET_STS_ERROR;
5893: write_error_messages(x_msg_data, x_msg_count);
5894: RETURN;
5895: END IF;
5896: CLOSE location_id_cur;

Line 5911: p_init_msg_list => FND_API.G_TRUE,

5907: l_location_rec.state := p_cc_location_rec.state;
5908: l_location_rec.county := p_cc_location_rec.county;
5909:
5910: HZ_LOCATION_V2PUB.update_location(
5911: p_init_msg_list => FND_API.G_TRUE,
5912: p_location_rec => l_location_rec,
5913: p_object_version_number => l_object_version_number,
5914: x_return_status => x_return_status,
5915: x_msg_count => x_msg_count,

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

5914: x_return_status => x_return_status,
5915: x_msg_count => x_msg_count,
5916: x_msg_data => x_msg_data);
5917:
5918: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5919: x_return_status := FND_API.G_RET_STS_ERROR;
5920: write_error_messages(x_msg_data, x_msg_count);
5921: RETURN;
5922: END IF;

Line 5919: x_return_status := FND_API.G_RET_STS_ERROR;

5915: x_msg_count => x_msg_count,
5916: x_msg_data => x_msg_data);
5917:
5918: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5919: x_return_status := FND_API.G_RET_STS_ERROR;
5920: write_error_messages(x_msg_data, x_msg_count);
5921: RETURN;
5922: END IF;
5923:

Line 5926: x_return_status := FND_API.G_RET_STS_ERROR;

5922: END IF;
5923:
5924: EXCEPTION
5925: WHEN OTHERS THEN
5926: x_return_status := FND_API.G_RET_STS_ERROR;
5927:
5928: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5929:
5930: write_debug_and_log('l_location_id'|| l_location_id);

Line 5994: x_return_status := FND_API.G_RET_STS_ERROR;

5990: x_billing_addr_use := useRecType.Instr_Billing_Address;
5991:
5992: EXCEPTION
5993: WHEN OTHERS THEN
5994: x_return_status := FND_API.G_RET_STS_ERROR;
5995:
5996: write_debug_and_log('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
5997:
5998: write_debug_and_log('p_channel_code'|| p_channel_code);

Line 6049: x_return_status := FND_API.G_RET_STS_SUCCESS;

6045: LAST_UPDATE_DATE = l_last_update_date, LAST_UPDATED_BY = l_last_updated_by,
6046: LAST_UPDATE_LOGIN = l_last_update_login
6047: where payment_schedule_id = p_payment_schedule_id_list(trx);
6048:
6049: x_return_status := FND_API.G_RET_STS_SUCCESS;
6050: x_msg_count := 0;
6051:
6052: EXCEPTION
6053: WHEN OTHERS THEN

Line 6054: x_return_status := FND_API.G_RET_STS_ERROR;

6050: x_msg_count := 0;
6051:
6052: EXCEPTION
6053: WHEN OTHERS THEN
6054: x_return_status := FND_API.G_RET_STS_ERROR;
6055: FND_MSG_PUB.count_and_get(p_encoded => fnd_api.g_false,
6056: p_count => x_msg_count,
6057: p_data => x_msg_data);
6058:

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

6051:
6052: EXCEPTION
6053: WHEN OTHERS THEN
6054: x_return_status := FND_API.G_RET_STS_ERROR;
6055: FND_MSG_PUB.count_and_get(p_encoded => fnd_api.g_false,
6056: p_count => x_msg_count,
6057: p_data => x_msg_data);
6058:
6059: END update_invoice_payment_status;