DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on AR_BILLS_CREATION_PUB

Line 3579: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Header');

3575:
3576:
3577: -- Bug 1708420 : pass l_trx_number rather than NULL
3578:
3579: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Header');
3580: if p_call <> 3 then
3581: -- SSA-R12 : add l_org_id
3582: AR_BILLS_CREATION_PUB.Create_BR_Header (
3583: 1.0, -- p_api_version

Line 3582: AR_BILLS_CREATION_PUB.Create_BR_Header (

3578:
3579: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Header');
3580: if p_call <> 3 then
3581: -- SSA-R12 : add l_org_id
3582: AR_BILLS_CREATION_PUB.Create_BR_Header (
3583: 1.0, -- p_api_version
3584: NULL, -- p_init_msg_list
3585: NULL, -- p_commit,
3586: NULL, -- p_validation_level

Line 3661: AR_BILLS_CREATION_PUB.Create_BR_Header (

3657: x_response =>l_result
3658: );
3659:
3660:
3661: AR_BILLS_CREATION_PUB.Create_BR_Header (
3662: 1.0, -- p_api_version
3663: NULL, -- p_init_msg_list
3664: NULL, -- p_commit,
3665: NULL, -- p_validation_level

Line 3719: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||

3715:
3716: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;
3717: select org_id into jnk2 from ar_transaction_history where customer_trx_id = l_bill_id;
3718:
3719: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||
3720: to_char(jnk2));
3721:
3722: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3723: WHEN OTHERS THEN

Line 3727: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header()- unexpected error');

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
3730: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3731: END IF;

Line 3736: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);

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;
3738: ROLLBACK TO create_BR_SVP2;
3739: IF p_call = 3 THEN
3740: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

Line 3769: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM');

3765: EXIT WHEN c_trx%NOTFOUND;
3766:
3767: program_debug(p_call,'nimm: l_org_id '||l_org_id);
3768:
3769: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM');
3770: AR_BILLS_CREATION_PUB.create_br_assignment (
3771: 1.0, -- p_api_version
3772: NULL, -- p_init_msg_list
3773: NULL, -- p_commit

Line 3770: AR_BILLS_CREATION_PUB.create_br_assignment (

3766:
3767: program_debug(p_call,'nimm: l_org_id '||l_org_id);
3768:
3769: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM');
3770: AR_BILLS_CREATION_PUB.create_br_assignment (
3771: 1.0, -- p_api_version
3772: NULL, -- p_init_msg_list
3773: NULL, -- p_commit
3774: NULL, -- p_validation_level,

Line 3801: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '

3797: l_org_id, -- p_org_id
3798: l_customer_trx_line_id);
3799:
3800: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;
3801: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '
3802: || to_char(jnk1));
3803:
3804: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3805: WHEN OTHERS

Line 3809: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||

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;
3812: IF p_call = 3 THEN
3813: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

Line 3819: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||

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);
3821: END IF;
3822: ROLLBACK TO create_BR_SVP2;
3823: IF p_call = 3 THEN

Line 3851: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');

3847: FETCH c_trx INTO l_payment_schedule_id, l_assigned_amount, l_org_id;
3848: EXIT WHEN c_trx%NOTFOUND;
3849:
3850: program_debug(p_call,'imm: l_org_id '||l_org_id);
3851: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');
3852:
3853:
3854: AR_BILLS_CREATION_PUB.create_br_assignment (
3855: 1.0, -- p_api_version

Line 3854: AR_BILLS_CREATION_PUB.create_br_assignment (

3850: program_debug(p_call,'imm: l_org_id '||l_org_id);
3851: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');
3852:
3853:
3854: AR_BILLS_CREATION_PUB.create_br_assignment (
3855: 1.0, -- p_api_version
3856: NULL, -- p_init_msg_list
3857: NULL, -- p_commit
3858: NULL, -- p_validation_level,

Line 3884: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');

3880: NULL, -- p_attribute15
3881: l_org_id, -- p_org_id
3882: l_customer_trx_line_id);
3883:
3884: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');
3885:
3886:
3887: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3888: WHEN OTHERS

Line 3892: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||

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;
3895: IF p_call = 3 THEN
3896: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

Line 3902: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||

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);
3904: END IF;
3905: ROLLBACK TO create_BR_SVP2;
3906: IF p_call = 3 THEN

Line 3956: 'EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||

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 ');
3958: END IF;
3959: IF p_call = 3 THEN
3960: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

Line 3967: '>>>> EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||

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() ' ||
3968: '- error :'||l_msg_data);
3969: END IF;
3970: ROLLBACK TO create_BR_SVP2;
3971: IF p_call = 3 THEN