DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on FND_API

Line 3440: x_return_status := FND_API.G_RET_STS_SUCCESS;

3436: arp_debug.debug( 'arp_process_application.receipt_application()+' );
3437: END IF;
3438:
3439: /* Bug 3773036: Initializing return status ..*/
3440: x_return_status := FND_API.G_RET_STS_SUCCESS;
3441:
3442: /* move parm gt_id into local var. It may get set by prorate_recoverable
3443: if discounts are present */
3444: l_gt_id := p_gt_id;

Line 4195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

4191: END IF;
4192:
4193: /* Bug 3773036 - treat all non success errors the same and ensure
4194: errors returned from TM are displayed */
4195: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4196: THEN
4197: RAISE trade_mgt_err;
4198: END IF;
4199:

Line 5857: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;

5853: l_exchange_rate ra_customer_trx.exchange_rate%TYPE;
5854: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5855: l_func_amount_due_remaining ar_payment_schedules.amount_due_remaining%TYPE;
5856:
5857: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
5858: l_fnd_msg_pub_constants_rec ar_bills_main.fnd_msg_pub_constants_type := ar_bills_main.get_fnd_msg_pub_constants_rec;
5859: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
5860: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type;
5861: l_return_status VARCHAR2(1);

Line 6005: p_init_msg_list=>l_fnd_api_constants_rec.G_FALSE,

6001: --Call Misc receipt creation routine.
6002: AR_RECEIPT_API_PUB.create_misc(
6003: -- IN parameters
6004: p_api_version=>1.0,
6005: p_init_msg_list=>l_fnd_api_constants_rec.G_FALSE,
6006: p_commit=>l_fnd_api_constants_rec.G_FALSE,
6007: p_validation_level=>l_fnd_api_constants_rec.G_VALID_LEVEL_FULL,
6008: p_attribute_record=>l_attribute_rec,
6009: p_global_attribute_record=>l_global_attribute_rec,

Line 6006: p_commit=>l_fnd_api_constants_rec.G_FALSE,

6002: AR_RECEIPT_API_PUB.create_misc(
6003: -- IN parameters
6004: p_api_version=>1.0,
6005: p_init_msg_list=>l_fnd_api_constants_rec.G_FALSE,
6006: p_commit=>l_fnd_api_constants_rec.G_FALSE,
6007: p_validation_level=>l_fnd_api_constants_rec.G_VALID_LEVEL_FULL,
6008: p_attribute_record=>l_attribute_rec,
6009: p_global_attribute_record=>l_global_attribute_rec,
6010: p_receipt_date=>p_apply_date,

Line 6007: p_validation_level=>l_fnd_api_constants_rec.G_VALID_LEVEL_FULL,

6003: -- IN parameters
6004: p_api_version=>1.0,
6005: p_init_msg_list=>l_fnd_api_constants_rec.G_FALSE,
6006: p_commit=>l_fnd_api_constants_rec.G_FALSE,
6007: p_validation_level=>l_fnd_api_constants_rec.G_VALID_LEVEL_FULL,
6008: p_attribute_record=>l_attribute_rec,
6009: p_global_attribute_record=>l_global_attribute_rec,
6010: p_receipt_date=>p_apply_date,
6011: p_amount=>(p_amount_applied * -1),

Line 6062: FND_API.G_FALSE);

6058:
6059: FOR l_count IN 1..l_msg_count LOOP
6060:
6061: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
6062: FND_API.G_FALSE);
6063: IF PG_DEBUG in ('Y', 'C') THEN
6064: arp_debug.debug( to_char(l_count)||' : '||l_msg_data);
6065: END IF;
6066:

Line 6076: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then

6072:
6073: /*-----------------------------------------------------+
6074: | If API return status is not SUCCESS raise exception |
6075: +-----------------------------------------------------*/
6076: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then
6077:
6078: /*-----------------------------------------------------+
6079: | Success do nothing, else branch introduced to make |
6080: | sure that NULL case will also raise exception |

Line 6102: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,

6098: arp_debug.debug( 'API EXCEPTION: ' ||
6099: 'arp_process_application.activity_application(misc_receipt creation))'
6100: ||SQLERRM);
6101: END IF;
6102: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
6103: l_msg_data, l_msg_index);
6104: FND_MESSAGE.Set_Encoded (l_msg_data);
6105: app_exception.raise_exception;
6106:

Line 7113: x_return_status := FND_API.G_RET_STS_SUCCESS;

7109: BEGIN
7110: IF PG_DEBUG in ('Y', 'C') THEN
7111: arp_debug.debug( 'arp_process_application.other_account_application()+' );
7112: END IF;
7113: x_return_status := FND_API.G_RET_STS_SUCCESS;
7114:
7115: IF PG_DEBUG in ('Y', 'C') THEN
7116: arp_debug.debug( '-- p_receipt_ps_id = '||TO_CHAR(p_receipt_ps_id));
7117: arp_debug.debug( '-- p_amount_applied = '||

Line 7208: x_return_status := FND_API.G_RET_STS_ERROR;

7204: EXCEPTION
7205: WHEN no_data_found THEN
7206: null;
7207: WHEN too_many_rows THEN
7208: x_return_status := FND_API.G_RET_STS_ERROR;
7209: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );
7210: APP_EXCEPTION.raise_exception;
7211: END;
7212: END IF;

Line 7439: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7435: , x_msg_data => x_msg_data
7436: , p_reason_id => to_number(p_application_ref_reason)--Yao Zhang add for bug 10197191
7437: );
7438: END IF;
7439: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7440: raise trade_mgt_err;
7441: END IF;
7442: END IF;
7443: x_application_ref_id := l_ra_rec.secondary_application_ref_id;

Line 7559: x_return_status := FND_API.G_RET_STS_ERROR;

7555: arp_debug.debug( 'arp_process_application.other_account_application()-' );
7556: END IF;
7557: EXCEPTION
7558: WHEN trade_mgt_err THEN
7559: x_return_status := FND_API.G_RET_STS_ERROR;
7560: IF PG_DEBUG in ('Y', 'C') THEN
7561: arp_debug.debug('Trade Management : ' ||
7562: 'EXCEPTION: arp_process_application.other_account_application' );
7563: END IF;

Line 7565: x_return_status := FND_API.G_RET_STS_ERROR;

7561: arp_debug.debug('Trade Management : ' ||
7562: 'EXCEPTION: arp_process_application.other_account_application' );
7563: END IF;
7564: WHEN OTHERS THEN
7565: x_return_status := FND_API.G_RET_STS_ERROR;
7566: IF PG_DEBUG in ('Y', 'C') THEN
7567: arp_debug.debug(
7568: 'EXCEPTION: arp_process_application.other_account_application' );
7569: END IF;

Line 7745: ,p_init_msg_list => FND_API.G_TRUE

7741: END IF;
7742:
7743: OZF_Claim_GRP.Create_Deduction
7744: (p_api_version_number => 1.0
7745: ,p_init_msg_list => FND_API.G_TRUE
7746: ,p_commit => FND_API.G_FALSE
7747: ,x_return_status => l_return_status
7748: ,x_msg_count => x_msg_count
7749: ,x_msg_data => x_msg_data

Line 7746: ,p_commit => FND_API.G_FALSE

7742:
7743: OZF_Claim_GRP.Create_Deduction
7744: (p_api_version_number => 1.0
7745: ,p_init_msg_list => FND_API.G_TRUE
7746: ,p_commit => FND_API.G_FALSE
7747: ,x_return_status => l_return_status
7748: ,x_msg_count => x_msg_count
7749: ,x_msg_data => x_msg_data
7750: ,p_deduction => l_claim_rec

Line 7755: IF l_return_status = FND_API.G_RET_STS_SUCCESS

7751: ,x_claim_id => x_claim_id
7752: ,x_claim_number => x_claim_number
7753: ,x_claim_reason_code_id => l_claim_reason_code_id
7754: ,x_claim_reason_name => x_claim_reason_name );
7755: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7756: THEN
7757: x_return_status := 'S';
7758: IF p_customer_trx_id IS NOT NULL and p_customer_trx_id > 0
7759: THEN

Line 7768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

7764: put_trx_in_dispute(p_invoice_ps_id
7765: ,p_amount
7766: ,'Y');
7767: END IF;
7768: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
7769: THEN
7770: x_return_status := 'E';
7771: ELSE
7772: x_return_status := 'U';

Line 7867: l_return_status := FND_API.G_RET_STS_SUCCESS;

7863: IF PG_DEBUG in ('Y', 'C') THEN
7864: arp_debug.debug( 'arp_process_application.update_claim()+' );
7865: END IF;
7866:
7867: l_return_status := FND_API.G_RET_STS_SUCCESS;
7868:
7869: IF p_claim_id IS NOT NULL THEN
7870: l_claim_rec.claim_id := p_claim_id;
7871: ELSE

Line 7921: ,p_init_msg_list => FND_API.G_TRUE

7917: END IF;
7918:
7919: OZF_Claim_GRP.Update_Deduction
7920: (p_api_version_number => 1.0
7921: ,p_init_msg_list => FND_API.G_TRUE
7922: ,p_commit => FND_API.G_FALSE
7923: ,x_return_status => l_return_status
7924: ,x_msg_count => x_msg_count
7925: ,x_msg_data => x_msg_data

Line 7922: ,p_commit => FND_API.G_FALSE

7918:
7919: OZF_Claim_GRP.Update_Deduction
7920: (p_api_version_number => 1.0
7921: ,p_init_msg_list => FND_API.G_TRUE
7922: ,p_commit => FND_API.G_FALSE
7923: ,x_return_status => l_return_status
7924: ,x_msg_count => x_msg_count
7925: ,x_msg_data => x_msg_data
7926: ,p_deduction => l_claim_rec

Line 7933: IF l_return_status = FND_API.G_RET_STS_SUCCESS

7929: ,x_claim_reason_name => x_claim_reason_name
7930: ,x_claim_id => p_claim_id
7931: ,x_claim_number => x_claim_number );
7932:
7933: IF l_return_status = FND_API.G_RET_STS_SUCCESS
7934: THEN
7935: x_return_status := 'S';
7936:
7937: --Bug 1812328 : added the call to remove_dispute_on_trx().

Line 8041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

8037: /*End of change, Bug 11841102*/
8038:
8039: END IF;
8040:
8041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
8042: THEN
8043: x_return_status := 'E';
8044: ELSE
8045: x_return_status := 'U';

Line 8048: IF PG_DEBUG in ('Y', 'C') AND l_return_status <> FND_API.G_RET_STS_SUCCESS

8044: ELSE
8045: x_return_status := 'U';
8046: END IF;
8047:
8048: IF PG_DEBUG in ('Y', 'C') AND l_return_status <> FND_API.G_RET_STS_SUCCESS
8049: THEN
8050: arp_debug.debug( 'arp_process_application.update_claim: ERROR occurred calling update_deduction: '||SQLERRM );
8051: END IF;
8052: IF PG_DEBUG in ('Y', 'C') THEN

Line 8471: p_init_msg_list => FND_API.G_TRUE,

8467: -- reverse Misc Receipt
8468:
8469: AR_RECEIPT_API_PUB.Reverse(
8470: p_api_version => 1.0,
8471: p_init_msg_list => FND_API.G_TRUE,
8472: x_return_status => l_return_status,
8473: x_msg_count => l_msg_count,
8474: x_msg_data => l_msg_data,
8475: p_cash_receipt_id => p_cash_receipt_id,

Line 8512: FND_API.G_FALSE);

8508:
8509: FOR l_count IN 1..l_msg_count LOOP
8510:
8511: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
8512: FND_API.G_FALSE);
8513: IF PG_DEBUG in ('Y', 'C') THEN
8514: arp_debug.debug( to_char(l_count)||' : '||l_msg_data);
8515: END IF;
8516:

Line 8526: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then

8522:
8523: /*-----------------------------------------------------+
8524: | If API return status is not SUCCESS raise exception |
8525: +-----------------------------------------------------*/
8526: IF l_return_status = FND_API.G_RET_STS_SUCCESS Then
8527:
8528: /*-----------------------------------------------------+
8529: | Success do nothing, else branch introduced to make |
8530: | sure that NULL case will also raise exception |

Line 8555: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,

8551: arp_debug.debug( 'API EXCEPTION: ' ||
8552: 'arp_process_application.reverse_action_misc_receipt'
8553: ||SQLERRM);
8554: END IF;
8555: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
8556: l_msg_data, l_msg_index);
8557: FND_MESSAGE.Set_Encoded (l_msg_data);
8558: app_exception.raise_exception;
8559:

Line 8720: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;

8716: l_cm_ps_rec ar_payment_schedules%ROWTYPE;
8717: l_ae_doc_rec ae_doc_rec_type;
8718: l_source_type ar_distributions.source_type%TYPE; /* jrautiai BR implementation */
8719: l_flag char;
8720: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
8721:
8722: l_inv_bal_amount NUMBER;
8723: l_inv_orig_amount NUMBER;
8724: l_allow_over_application VARCHAR2(1);

Line 8765: x_return_status := FND_API.G_RET_STS_SUCCESS;

8761: IF PG_DEBUG in ('Y', 'C') THEN
8762: arp_debug.debug('arp_process_application.cm_activity_application()+' );
8763: END IF;
8764:
8765: x_return_status := FND_API.G_RET_STS_SUCCESS;
8766:
8767: -- Output IN parameters
8768: IF PG_DEBUG in ('Y', 'C') THEN
8769: arp_debug.debug('CM PS Id. : '||TO_CHAR( p_cm_ps_id ) );

Line 9062: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

9058: l_trx_number ra_customer_trx.trx_number%TYPE;
9059: l_message_text VARCHAR2(2000);
9060: l_cnt NUMBER;
9061:
9062: x_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
9063: x_msg_count NUMBER;
9064: x_msg_data VARCHAR2(2000);
9065: l_count NUMBER;
9066: l_msg_data VARCHAR2(1000);

Line 9139: p_init_msg_list => FND_API.G_FALSE,

9135: /* Bug 9928392 - Remove association to invoice tax in etax tables */
9136: BEGIN
9137: zx_api_pub.unapply_applied_cm(
9138: p_api_version => '1.0',
9139: p_init_msg_list => FND_API.G_FALSE,
9140: p_commit => FND_API.G_FALSE,
9141: p_validation_level => 1,
9142: p_trx_id => p_cust_trx_id,
9143: x_return_status => x_return_status,

Line 9140: p_commit => FND_API.G_FALSE,

9136: BEGIN
9137: zx_api_pub.unapply_applied_cm(
9138: p_api_version => '1.0',
9139: p_init_msg_list => FND_API.G_FALSE,
9140: p_commit => FND_API.G_FALSE,
9141: p_validation_level => 1,
9142: p_trx_id => p_cust_trx_id,
9143: x_return_status => x_return_status,
9144: x_msg_count => x_msg_count,

Line 9147: IF x_return_status = FND_API.G_RET_STS_SUCCESS

9143: x_return_status => x_return_status,
9144: x_msg_count => x_msg_count,
9145: x_msg_data => x_msg_data);
9146:
9147: IF x_return_status = FND_API.G_RET_STS_SUCCESS
9148: THEN
9149: NULL;
9150: ELSE
9151: arp_debug.debug(x_msg_count || ':' ||