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

Line 2753: l_return_status := FND_API.G_RET_STS_SUCCESS;

2749: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
2750: program_debug(p_call,'ARP_PROGRAM_GENERATE_BR.create_BR (+)');
2751: END IF;
2752:
2753: l_return_status := FND_API.G_RET_STS_SUCCESS;
2754:
2755: SAVEPOINT create_BR_SVP;
2756:
2757: -------------------------------------------------------------------------------

Line 3355: l_return_status := FND_API.G_RET_STS_SUCCESS;

3351: l_bill_id := NULL;
3352: l_bill_number := NULL;
3353: l_bill_status := NULL;
3354:
3355: l_return_status := FND_API.G_RET_STS_SUCCESS;
3356:
3357: /* -----------------------------------------------------------------------------------------
3358: 4109513 : Transferred following sequence above, right after l_br_maturity_date is defined
3359:

Line 3488: p_init_msg_list =>FND_API.G_TRUE,

3484:
3485: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
3486: (
3487: p_api_version =>1.0,
3488: p_init_msg_list =>FND_API.G_TRUE,
3489: p_commit =>FND_API.G_FALSE,
3490: x_return_status =>l_return_status,
3491: x_msg_count =>l_msg_count,
3492: x_msg_data =>l_msg_data,

Line 3489: p_commit =>FND_API.G_FALSE,

3485: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
3486: (
3487: p_api_version =>1.0,
3488: p_init_msg_list =>FND_API.G_TRUE,
3489: p_commit =>FND_API.G_FALSE,
3490: x_return_status =>l_return_status,
3491: x_msg_count =>l_msg_count,
3492: x_msg_data =>l_msg_data,
3493: p_payer =>l_payer,

Line 3566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3562:
3563: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3564: WHEN OTHERS THEN
3565:
3566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3567: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3568: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header()- unexpected error');
3569: END IF;
3570: IF p_call = 3 THEN

Line 3574: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3570: IF p_call = 3 THEN
3571: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3572: END IF;
3573: APP_EXCEPTION.raise_exception;
3574: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3575: l_msg_data := FND_MESSAGE.Get;
3576: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3577: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);
3578: END IF;

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

3584: -- EXIT; /* Bug 3472744 Commented the EXIT */
3585: END IF;
3586: END ; /* create_br_header block change6*/
3587:
3588: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3589:
3590: /*----------------------------------------------------
3591: Assign the payment schedules to the Bill receivable
3592: ----------------------------------------------------*/

Line 3648: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3644:
3645: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3646: WHEN OTHERS
3647: THEN
3648: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3649: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3650: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3651: '- unexpected error ');
3652: END IF;

Line 3657: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3653: IF p_call = 3 THEN
3654: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3655: END IF;
3656: APP_EXCEPTION.raise_exception;
3657: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3658: l_msg_data := FND_MESSAGE.Get;
3659: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3660: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3661: ' - error :'||l_msg_data);

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

3671: END LOOP;
3672: CLOSE c_trx;
3673:
3674:
3675: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3676:
3677: -- 2nd temporary table
3678: l_statement := 'SELECT payment_schedule_id, amount_assigned, org_id FROM '||
3679: g_tmp_table_imm||' WHERE amount_assigned IS NOT NULL';

Line 3731: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3727:
3728: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3729: WHEN OTHERS
3730: THEN
3731: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3732: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3733: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3734: '- unexpected error ');
3735: END IF;

Line 3740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3736: IF p_call = 3 THEN
3737: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3738: END IF;
3739: APP_EXCEPTION.raise_exception;
3740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3741: l_msg_data := FND_MESSAGE.Get;
3742: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3743: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3744: ' - error :'||l_msg_data);

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

3757:
3758:
3759: -- END IF; /* Bug 3472744 Moved the end if to the position before Else */
3760:
3761: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3762:
3763: /*----------------------------
3764: Complete the Bill receivable
3765: -----------------------------*/

Line 3794: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3790:
3791: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3792: WHEN OTHERS
3793: THEN
3794: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3795: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3796: program_debug(p_call,
3797: 'EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||
3798: ' - unexpected error ');

Line 3804: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3800: IF p_call = 3 THEN
3801: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3802: END IF;
3803: APP_EXCEPTION.raise_exception;
3804: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3805: l_msg_data := FND_MESSAGE.Get;
3806: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3807: program_debug(p_call,
3808: '>>>> EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||

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

3823: Bug 3589636/3617582, restructure IF clause to ensure g_num_br_created
3824: is incremented when BR creation returns success
3825: */
3826:
3827: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3828:
3829: g_num_br_created := g_num_br_created + 1;
3830:
3831: IF (p_call <> 3) THEN

Line 3873: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_call <> 3) THEN

3869: END IF;
3870:
3871:
3872:
3873: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_call <> 3) THEN
3874:
3875: /*------------------------------
3876: fill the report table
3877: ------------------------------*/

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

4684: | |
4685: +===========================================================================*/
4686: PROCEDURE auto_create_br_API(
4687: p_api_version IN NUMBER,
4688: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
4689: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4691: x_return_status OUT NOCOPY VARCHAR2,
4692: x_msg_count OUT NOCOPY NUMBER,

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

4685: +===========================================================================*/
4686: PROCEDURE auto_create_br_API(
4687: p_api_version IN NUMBER,
4688: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
4689: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4691: x_return_status OUT NOCOPY VARCHAR2,
4692: x_msg_count OUT NOCOPY NUMBER,
4693: x_msg_data OUT NOCOPY VARCHAR2,

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

4686: PROCEDURE auto_create_br_API(
4687: p_api_version IN NUMBER,
4688: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
4689: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4690: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4691: x_return_status OUT NOCOPY VARCHAR2,
4692: x_msg_count OUT NOCOPY NUMBER,
4693: x_msg_data OUT NOCOPY VARCHAR2,
4694: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

Line 4763: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

4759: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (+)');
4760: END IF;
4761:
4762: -- Standard call to check for call compatability
4763: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4765: END IF;
4766:
4767: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4760: END IF;
4761:
4762: -- Standard call to check for call compatability
4763: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4765: END IF;
4766:
4767: x_return_status := FND_API.G_RET_STS_SUCCESS;
4768:

Line 4767: x_return_status := FND_API.G_RET_STS_SUCCESS;

4763: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4765: END IF;
4766:
4767: x_return_status := FND_API.G_RET_STS_SUCCESS;
4768:
4769: -------------------------------------------------------------------------
4770: -- Validations
4771: -------------------------------------------------------------------------

Line 4997: IF (p_commit = FND_API.G_TRUE) THEN

4993: ---- FIRST LOOP END
4994: END LOOP;
4995: CLOSE c_grouping;
4996:
4997: IF (p_commit = FND_API.G_TRUE) THEN
4998: COMMIT;
4999: END IF;
5000:
5001:

Line 5028: WHEN FND_API.G_EXC_ERROR THEN

5024:
5025:
5026:
5027: EXCEPTION
5028: WHEN FND_API.G_EXC_ERROR THEN
5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5030: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');

5026:
5027: EXCEPTION
5028: WHEN FND_API.G_EXC_ERROR THEN
5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_ERROR;
5033:
5034: IF c_grouping%ISOPEN THEN

Line 5032: x_return_status := FND_API.G_RET_STS_ERROR;

5028: WHEN FND_API.G_EXC_ERROR THEN
5029: IF PG_DEBUG in ('Y', 'C') THEN
5030: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5031: END IF;
5032: x_return_status := FND_API.G_RET_STS_ERROR;
5033:
5034: IF c_grouping%ISOPEN THEN
5035: CLOSE c_grouping;
5036: END IF;

Line 5049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5045:
5046: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5047: raise;
5048:
5049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5050: IF PG_DEBUG in ('Y', 'C') THEN
5051: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5052: END IF;
5053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5051: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');

5047: raise;
5048:
5049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5050: IF PG_DEBUG in ('Y', 'C') THEN
5051: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5052: END IF;
5053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5054:
5055: IF c_grouping%ISOPEN THEN

Line 5053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5050: IF PG_DEBUG in ('Y', 'C') THEN
5051: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5052: END IF;
5053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5054:
5055: IF c_grouping%ISOPEN THEN
5056: CLOSE c_grouping;
5057: END IF;

Line 5089: x_return_status := FND_API.G_RET_STS_ERROR;

5085: END IF;
5086:
5087: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5088: IF (SQLCODE = -20001) THEN
5089: x_return_status := FND_API.G_RET_STS_ERROR;
5090: END IF;
5091:
5092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5093: raise;

Line 5092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5088: IF (SQLCODE = -20001) THEN
5089: x_return_status := FND_API.G_RET_STS_ERROR;
5090: END IF;
5091:
5092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5093: raise;
5094:
5095: END auto_create_br_API;
5096: