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 2895: l_return_status := FND_API.G_RET_STS_SUCCESS;

2891: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
2892: program_debug(p_call,'ARP_PROGRAM_GENERATE_BR.create_BR (+)');
2893: END IF;
2894:
2895: l_return_status := FND_API.G_RET_STS_SUCCESS;
2896:
2897: SAVEPOINT create_BR_SVP;
2898:
2899: -------------------------------------------------------------------------------

Line 3514: l_return_status := FND_API.G_RET_STS_SUCCESS;

3510: WHEN NO_DATA_FOUND THEN
3511: NULL;
3512: END;
3513:
3514: l_return_status := FND_API.G_RET_STS_SUCCESS;
3515:
3516: /* -----------------------------------------------------------------------------------------
3517: 4109513 : Transferred following sequence above, right after l_br_maturity_date is defined
3518:

Line 3647: p_init_msg_list =>FND_API.G_TRUE,

3643:
3644: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
3645: (
3646: p_api_version =>1.0,
3647: p_init_msg_list =>FND_API.G_TRUE,
3648: p_commit =>FND_API.G_FALSE,
3649: x_return_status =>l_return_status,
3650: x_msg_count =>l_msg_count,
3651: x_msg_data =>l_msg_data,

Line 3648: p_commit =>FND_API.G_FALSE,

3644: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
3645: (
3646: p_api_version =>1.0,
3647: p_init_msg_list =>FND_API.G_TRUE,
3648: p_commit =>FND_API.G_FALSE,
3649: x_return_status =>l_return_status,
3650: x_msg_count =>l_msg_count,
3651: x_msg_data =>l_msg_data,
3652: p_payer =>l_payer,

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

3721:
3722: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3723: WHEN OTHERS THEN
3724:
3725: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3726: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3727: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header()- unexpected error');
3728: END IF;
3729: IF p_call = 3 THEN

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

3729: IF p_call = 3 THEN
3730: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3731: END IF;
3732: APP_EXCEPTION.raise_exception;
3733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3734: l_msg_data := FND_MESSAGE.Get;
3735: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3736: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);
3737: END IF;

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

3743: -- EXIT; /* Bug 3472744 Commented the EXIT */
3744: END IF;
3745: END ; /* create_br_header block change6*/
3746:
3747: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3748:
3749: /*----------------------------------------------------
3750: Assign the payment schedules to the Bill receivable
3751: ----------------------------------------------------*/

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

3803:
3804: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3805: WHEN OTHERS
3806: THEN
3807: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3808: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3809: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3810: '- unexpected error ');
3811: END IF;

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

3812: IF p_call = 3 THEN
3813: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3814: END IF;
3815: APP_EXCEPTION.raise_exception;
3816: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3817: l_msg_data := FND_MESSAGE.Get;
3818: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3819: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3820: ' - error :'||l_msg_data);

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

3830: END LOOP;
3831: CLOSE c_trx;
3832:
3833:
3834: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3835:
3836: -- 2nd temporary table
3837: l_statement := 'SELECT payment_schedule_id, amount_assigned, org_id FROM '||
3838: g_tmp_table_imm||' WHERE amount_assigned IS NOT NULL';

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

3886:
3887: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3888: WHEN OTHERS
3889: THEN
3890: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3891: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3892: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3893: '- unexpected error ');
3894: END IF;

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

3895: IF p_call = 3 THEN
3896: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3897: END IF;
3898: APP_EXCEPTION.raise_exception;
3899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3900: l_msg_data := FND_MESSAGE.Get;
3901: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3902: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3903: ' - error :'||l_msg_data);

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

3916:
3917:
3918: -- END IF; /* Bug 3472744 Moved the end if to the position before Else */
3919:
3920: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3921:
3922: /*----------------------------
3923: Complete the Bill receivable
3924: -----------------------------*/

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

3949:
3950: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3951: WHEN OTHERS
3952: THEN
3953: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3954: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3955: program_debug(p_call,
3956: 'EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||
3957: ' - unexpected error ');

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

3959: IF p_call = 3 THEN
3960: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3961: END IF;
3962: APP_EXCEPTION.raise_exception;
3963: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3964: l_msg_data := FND_MESSAGE.Get;
3965: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3966: program_debug(p_call,
3967: '>>>> EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||

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

3982: Bug 3589636/3617582, restructure IF clause to ensure g_num_br_created
3983: is incremented when BR creation returns success
3984: */
3985:
3986: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3987:
3988: g_num_br_created := g_num_br_created + 1;
3989:
3990: IF (p_call <> 3) THEN

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

4028: END IF;
4029:
4030:
4031:
4032: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) AND (p_call <> 3) THEN
4033:
4034: /*------------------------------
4035: fill the report table
4036: ------------------------------*/

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

4843: | |
4844: +===========================================================================*/
4845: PROCEDURE auto_create_br_API(
4846: p_api_version IN NUMBER,
4847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
4848: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4850: x_return_status OUT NOCOPY VARCHAR2,
4851: x_msg_count OUT NOCOPY NUMBER,

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

4844: +===========================================================================*/
4845: PROCEDURE auto_create_br_API(
4846: p_api_version IN NUMBER,
4847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
4848: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4850: x_return_status OUT NOCOPY VARCHAR2,
4851: x_msg_count OUT NOCOPY NUMBER,
4852: x_msg_data OUT NOCOPY VARCHAR2,

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

4845: PROCEDURE auto_create_br_API(
4846: p_api_version IN NUMBER,
4847: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
4848: p_commit IN VARCHAR2 := FND_API.G_TRUE,
4849: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4850: x_return_status OUT NOCOPY VARCHAR2,
4851: x_msg_count OUT NOCOPY NUMBER,
4852: x_msg_data OUT NOCOPY VARCHAR2,
4853: p_customer_trx_id IN RA_CUSTOMER_TRX.customer_trx_id%TYPE,

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

4918: arp_util.debug('ARP_PROGRAM_GENERATE_BR.auto_create_br_API (+)');
4919: END IF;
4920:
4921: -- Standard call to check for call compatability
4922: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4924: END IF;
4925:
4926: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4919: END IF;
4920:
4921: -- Standard call to check for call compatability
4922: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4924: END IF;
4925:
4926: x_return_status := FND_API.G_RET_STS_SUCCESS;
4927:

Line 4926: x_return_status := FND_API.G_RET_STS_SUCCESS;

4922: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4924: END IF;
4925:
4926: x_return_status := FND_API.G_RET_STS_SUCCESS;
4927:
4928: -------------------------------------------------------------------------
4929: -- Validations
4930: -------------------------------------------------------------------------

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

5152: ---- FIRST LOOP END
5153: END LOOP;
5154: CLOSE c_grouping;
5155:
5156: IF (p_commit = FND_API.G_TRUE) THEN
5157: COMMIT;
5158: END IF;
5159:
5160:

Line 5187: WHEN FND_API.G_EXC_ERROR THEN

5183:
5184:
5185:
5186: EXCEPTION
5187: WHEN FND_API.G_EXC_ERROR THEN
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5190: END IF;
5191: x_return_status := FND_API.G_RET_STS_ERROR;

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

5185:
5186: EXCEPTION
5187: WHEN FND_API.G_EXC_ERROR THEN
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5190: END IF;
5191: x_return_status := FND_API.G_RET_STS_ERROR;
5192:
5193: IF c_grouping%ISOPEN THEN

Line 5191: x_return_status := FND_API.G_RET_STS_ERROR;

5187: WHEN FND_API.G_EXC_ERROR THEN
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROGRAM_GENERATE_BR.auto_create_br_API ');
5190: END IF;
5191: x_return_status := FND_API.G_RET_STS_ERROR;
5192:
5193: IF c_grouping%ISOPEN THEN
5194: CLOSE c_grouping;
5195: END IF;

Line 5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5204:
5205: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5206: raise;
5207:
5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5209: IF PG_DEBUG in ('Y', 'C') THEN
5210: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5211: END IF;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5206: raise;
5207:
5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5209: IF PG_DEBUG in ('Y', 'C') THEN
5210: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5211: END IF;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213:
5214: IF c_grouping%ISOPEN THEN

Line 5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5209: IF PG_DEBUG in ('Y', 'C') THEN
5210: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROGRAM_GENERATE_BR.auto_create_br_API');
5211: END IF;
5212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5213:
5214: IF c_grouping%ISOPEN THEN
5215: CLOSE c_grouping;
5216: END IF;

Line 5248: x_return_status := FND_API.G_RET_STS_ERROR;

5244: END IF;
5245:
5246: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;
5247: IF (SQLCODE = -20001) THEN
5248: x_return_status := FND_API.G_RET_STS_ERROR;
5249: END IF;
5250:
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5252: raise;

Line 5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5247: IF (SQLCODE = -20001) THEN
5248: x_return_status := FND_API.G_RET_STS_ERROR;
5249: END IF;
5250:
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5252: raise;
5253:
5254: END auto_create_br_API;
5255: