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_PREPAYMENTS_PUB dependencies on FND_API

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

54: *=======================================================================*/
55: PROCEDURE Create_Prepayment(
56: -- Standard API parameters.
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,

Line 59: p_commit IN VARCHAR2 := FND_API.G_FALSE,

55: PROCEDURE Create_Prepayment(
56: -- Standard API parameters.
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,

Line 60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

56: -- Standard API parameters.
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
61: x_return_status OUT NOCOPY VARCHAR2,
62: x_msg_count OUT NOCOPY NUMBER,
63: x_msg_data OUT NOCOPY VARCHAR2,
64: -- Receipt info. parameters

Line 138: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,

134: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
135: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
136:
137: ---Bug 3220078 Change the parameter to TRUE
138: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
139:
140: p_payment_response_error_code OUT NOCOPY VARCHAR2,
141: -- OUT NOCOPY parameter for the Application
142: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 205: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

201: rct_info rct_info_cur%ROWTYPE;
202: l_cr_rec ar_cash_receipts_all%ROWTYPE;
203: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
204: l_action VARCHAR2(80);
205: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
206: l_msg_count NUMBER;
207: l_msg_data VARCHAR2(2000);
208: l_iby_msg_data VARCHAR2(2000);
209: l_vend_msg_data VARCHAR2(2000);

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: /*-----------------------------------------+
250: | Initialize return status to SUCCESS |
251: +-----------------------------------------*/
252:
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: /*--------------------------------------------------+
256: | Standard call to check for call compatibility |
257: +--------------------------------------------------*/

Line 259: IF NOT FND_API.Compatible_API_Call(

255: /*--------------------------------------------------+
256: | Standard call to check for call compatibility |
257: +--------------------------------------------------*/
258:
259: IF NOT FND_API.Compatible_API_Call(
260: l_api_version,
261: p_api_version,
262: l_api_name,
263: G_PKG_NAME

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: l_api_name,
263: G_PKG_NAME
264: )
265: THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: END IF;
269:
270: /*--------------------------------------------------------------+

Line 267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

263: G_PKG_NAME
264: )
265: THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: END IF;
269:
270: /*--------------------------------------------------------------+
271: | Initialize message list if p_init_msg_list is set to TRUE |

Line 273: IF FND_API.to_Boolean( p_init_msg_list )

269:
270: /*--------------------------------------------------------------+
271: | Initialize message list if p_init_msg_list is set to TRUE |
272: +--------------------------------------------------------------*/
273: IF FND_API.to_Boolean( p_init_msg_list )
274: THEN
275: FND_MSG_PUB.initialize;
276: END IF;
277:

Line 283: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

279:
280:
281: /* SSA change */
282: l_org_id := p_org_id;
283: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
284: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
285: p_return_status =>l_org_return_status);
286: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
287: x_return_status := FND_API.G_RET_STS_ERROR;

Line 286: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

282: l_org_id := p_org_id;
283: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
284: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
285: p_return_status =>l_org_return_status);
286: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: ELSE
289: ----Multiple prepayments allow payment types other than credit card
290: /*--------------------------------------------------------------------

Line 287: x_return_status := FND_API.G_RET_STS_ERROR;

283: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
284: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
285: p_return_status =>l_org_return_status);
286: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: ELSE
289: ----Multiple prepayments allow payment types other than credit card
290: /*--------------------------------------------------------------------
291: IF p_receipt_method_id is not null THEN

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300: arp_util.debug('Create_Prepayment: ' || 'Prepayment only allowed for credit card');
301: END IF;
302: FND_MESSAGE.SET_NAME('AR','AR_RAPI_PREPAY_ONLYFOR_CC');
303: FND_MSG_PUB.Add;
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: RETURN;
306: END;
307:
308: END IF;

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: arp_util.debug('Create_Prepayment: ' || 'For Prepayment, customer banks account details must be passed');
318: END IF;
319: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_2_INVALID');
320: FND_MSG_PUB.Add;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: RETURN;
323: END IF;
324:
325: */

Line 335: p_commit => FND_API.G_FALSE,

331: --calling the internal create_cash routine
332: ar_receipt_api_pub.Create_Cash(
333: p_api_version => p_api_version,
334: p_init_msg_list => p_init_msg_list,
335: p_commit => FND_API.G_FALSE,
336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
337: x_return_status => l_create_return_status,
338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data,

Line 336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

332: ar_receipt_api_pub.Create_Cash(
333: p_api_version => p_api_version,
334: p_init_msg_list => p_init_msg_list,
335: p_commit => FND_API.G_FALSE,
336: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
337: x_return_status => l_create_return_status,
338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data,
340: -- Receipt info. parameters

Line 392: IF l_create_return_status = FND_API.G_RET_STS_SUCCESS THEN

388:
389: --IF the receipt creation part returns no errors then
390: --call the application routine.
391:
392: IF l_create_return_status = FND_API.G_RET_STS_SUCCESS THEN
393:
394: IF x_msg_count = 1 THEN
395: /* If one message, like warning, then put this back on stack as the
396: Create routine must have removed it from the stack and put it on x_msg_data

Line 417: x_return_status := FND_API.G_RET_STS_ERROR;

413: arp_util.debug('Create_Prepayment: ' || 'Payment set id sequence generation failed'||sqlerrm);
414: END IF;
415: FND_MESSAGE.SET_NAME('AR','AR_RAPI_PREPAY_SEQ_FAILED');
416: FND_MSG_PUB.Add;
417: x_return_status := FND_API.G_RET_STS_ERROR;
418: RETURN;
419: END;
420: ELSE
421: l_payment_set_id := p_payment_set_id;

Line 431: IF l_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN

427: 'PREPAYMENT',
428: l_receivables_trx_id,
429: l_activity_return_status);
430:
431: IF l_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: ROLLBACK TO Create_Prepayment_PVT;
433: x_return_status := l_activity_return_status;
434:
435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

431: IF l_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: ROLLBACK TO Create_Prepayment_PVT;
433: x_return_status := l_activity_return_status;
434:
435: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data);
438:
439: RETURN; -- exit back to caller

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

457:
458: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_INVALID_STATUS');
459: FND_MSG_PUB.Add;
460:
461: x_return_status := FND_API.G_RET_STS_ERROR; -- should never happen
462:
463: RETURN;
464: END IF;
465:

Line 610: p_init_msg_list => FND_API.G_TRUE,

606: END IF;
607:
608: IBY_FNDCPT_TRXN_PUB.Create_Authorization(
609: p_api_version => 1.0,
610: p_init_msg_list => FND_API.G_TRUE,
611: x_return_status => l_return_status,
612: x_msg_count => l_msg_count,
613: x_msg_data => l_msg_data,
614: p_payer => l_payer_rec,

Line 632: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');

628: arp_standard.debug('x_msg_count :<' || l_msg_count || '>');
629:
630: FOR i IN 1..l_msg_count LOOP
631: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
632: SUBSTR(fnd_msg_pub.get(p_msg_index => i,p_encoded => FND_API.G_FALSE),1,150) || '>');
633: END LOOP;
634:
635: IF PG_DEBUG in ('Y', 'C') THEN
636: arp_standard.debug( '-------------------------------------');

Line 651: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

647: -- arp_standard.debug( 'l_authresult_rec.Risk_Result: ' || l_authresult_rec.Risk_Result);
648:
649: END IF;
650:
651: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
652: -- update cash receipt with authorization code and
653:
654: ARP_CASH_RECEIPTS_PKG.set_to_dummy(l_cr_rec);
655: l_cr_rec.approval_code := l_authresult_rec.Auth_code ||'AR'||to_char(l_authresult_rec.Auth_Id);

Line 683: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);

679: arp_standard.debug( l_MSG_DATA);
680: END IF;
681: ELSIF(l_MSG_COUNT>1)THEN
682: LOOP
683: l_MSG_DATA:=FND_MSG_PUB.GET(p_encoded=>FND_API.G_FALSE);
684: IF (l_MSG_DATA IS NULL)THEN
685: EXIT;
686: END IF;
687: IF PG_DEBUG in ('Y', 'C') THEN

Line 694: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

690: END LOOP;
691: END IF;
692: END IF;
693:
694: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
695: AND (NVL(p_called_from,'NONE') = 'IREC') then
696:
697: ROLLBACK TO Create_Prepayment_Pvt;
698: FND_MESSAGE.set_name('AR', 'AR_PAY_PROCESS_AUTHFAILURE');

Line 703: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

699: FND_MSG_PUB.Add;
700: x_return_status := l_return_status;
701: RETURN;
702:
703: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
704:
705: ROLLBACK TO Create_Prepayment_Pvt;
706: arp_standard.debug('create_cash_126');
707: FND_MESSAGE.set_name('AR', 'AR_CC_AUTH_FAILED');

Line 740: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

736:
737: END IF;
738:
739:
740: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
741: p_count => x_msg_count,
742: p_data => x_msg_data );
743:
744: x_return_status := l_return_status;

Line 762: p_init_msg_list => FND_API.G_FALSE, --message stack is not initialized

758:
759: ar_receipt_api_pub.Apply_other_account(
760: -- Standard API parameters.
761: p_api_version => p_api_version,
762: p_init_msg_list => FND_API.G_FALSE, --message stack is not initialized
763: p_commit => p_commit,
764: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
765: x_return_status => l_create_return_status,
766: x_msg_count => x_msg_count,

Line 764: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

760: -- Standard API parameters.
761: p_api_version => p_api_version,
762: p_init_msg_list => FND_API.G_FALSE, --message stack is not initialized
763: p_commit => p_commit,
764: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
765: x_return_status => l_create_return_status,
766: x_msg_count => x_msg_count,
767: x_msg_data => x_msg_data,
768: p_receivable_application_id => p_receivable_application_id,

Line 792: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN

788: );
789:
790: --If the application fails then we need to rollback all the changes
791: --made in the create() routine also.
792: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: ROLLBACK TO Create_Prepayment_Pvt;
794: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data);

Line 794: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

790: --If the application fails then we need to rollback all the changes
791: --made in the create() routine also.
792: IF l_create_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: ROLLBACK TO Create_Prepayment_Pvt;
794: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => x_msg_data);
797: x_return_status := l_create_return_status;
798: RETURN;

Line 836: /* if (p_call_payment_processor = FND_API.G_TRUE) then

832:
833: IF PG_DEBUG in ('Y', 'C') THEN
834: arp_standard.debug('Create_Prepayment: ' || 'Checking p_call_payment_processor: ' || p_call_payment_processor);
835: END IF;
836: /* if (p_call_payment_processor = FND_API.G_TRUE) then
837:
838: Process_Credit_Card(
839: p_cash_receipt_id => l_cash_receipt_id,
840: p_payment_server_order_num =>

Line 853: IF l_cc_return_status <> FND_API.G_RET_STS_SUCCESS THEN

849: -- If the payment processor call fails, then we
850: -- need to rollback all the changes
851: -- made in the create() and apply() routines also.
852:
853: IF l_cc_return_status <> FND_API.G_RET_STS_SUCCESS THEN
854: x_return_status := l_cc_return_status;
855: p_payment_response_error_code := l_response_error_code;
856:
857: ROLLBACK TO Create_Prepayment_PVT;

Line 858: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

854: x_return_status := l_cc_return_status;
855: p_payment_response_error_code := l_response_error_code;
856:
857: ROLLBACK TO Create_Prepayment_PVT;
858: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: RETURN; -- exit back to caller

Line 865: end if; -- if p_call_payment_processor = fnd_api.g_true */

861:
862: RETURN; -- exit back to caller
863: END IF;
864:
865: end if; -- if p_call_payment_processor = fnd_api.g_true */
866: END IF; --l_payment_type
867:
868: -- need to pass back cr_id
869: p_cr_id := l_cash_receipt_id;

Line 882: IF FND_API.To_Boolean( p_commit )

878: /*--------------------------------+
879: | Standard check of p_commit |
880: +--------------------------------*/
881:
882: IF FND_API.To_Boolean( p_commit )
883: THEN
884: IF PG_DEBUG in ('Y', 'C') THEN
885: arp_util.debug('Create_Prepayments: ' || 'committing');
886: END IF;

Line 890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

886: END IF;
887: Commit;
888: END IF;
889:
890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
891: p_count => x_msg_count,
892: p_data => x_msg_data);
893:
894: IF PG_DEBUG in ('Y', 'C') THEN

Line 904: x_return_status := FND_API.G_RET_STS_ERROR ;

900: IF (SQLCODE = -20001) THEN
901: ROLLBACK TO Create_Prepayment_PVT;
902:
903: -- Display_Parameters;
904: x_return_status := FND_API.G_RET_STS_ERROR ;
905: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
906: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_PREPAYMENT : '||SQLERRM);
907: FND_MSG_PUB.Add;
908:

Line 909: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

905: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
906: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_PREPAYMENT : '||SQLERRM);
907: FND_MSG_PUB.Add;
908:
909: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
910: p_count => x_msg_count,
911: p_data => x_msg_data
912: );
913: RETURN;

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

911: p_data => x_msg_data
912: );
913: RETURN;
914: ELSE
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
917: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_PREPAYMENT : '||SQLERRM);
918: FND_MSG_PUB.Add;
919: END IF;

Line 935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

931: );
932: END IF;
933:
934: -- Display_Parameters;
935: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
936: p_count => x_msg_count,
937: p_data => x_msg_data);
938:
939:

Line 996: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

992: BEGIN
993:
994: /* SSA change */
995: l_org_id := p_org_id;
996: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
997: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
998: p_return_status =>l_org_return_status);
999: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;

Line 999: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

995: l_org_id := p_org_id;
996: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
997: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
998: p_return_status =>l_org_return_status);
999: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: ELSE
1002:
1003: AR_PREPAYMENTS.get_installment(

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

996: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
997: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
998: p_return_status =>l_org_return_status);
999: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: ELSE
1002:
1003: AR_PREPAYMENTS.get_installment(
1004: p_term_id,