DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on AR_BILLS_CREATION_PUB

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

3416:
3417:
3418: -- Bug 1708420 : pass l_trx_number rather than NULL
3419:
3420: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Header');
3421: if p_call <> 3 then
3422: -- SSA-R12 : add l_org_id
3423: AR_BILLS_CREATION_PUB.Create_BR_Header (
3424: 1.0, -- p_api_version

Line 3423: AR_BILLS_CREATION_PUB.Create_BR_Header (

3419:
3420: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Header');
3421: if p_call <> 3 then
3422: -- SSA-R12 : add l_org_id
3423: AR_BILLS_CREATION_PUB.Create_BR_Header (
3424: 1.0, -- p_api_version
3425: NULL, -- p_init_msg_list
3426: NULL, -- p_commit,
3427: NULL, -- p_validation_level

Line 3502: AR_BILLS_CREATION_PUB.Create_BR_Header (

3498: x_response =>l_result
3499: );
3500:
3501:
3502: AR_BILLS_CREATION_PUB.Create_BR_Header (
3503: 1.0, -- p_api_version
3504: NULL, -- p_init_msg_list
3505: NULL, -- p_commit,
3506: NULL, -- p_validation_level

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

3556:
3557: select org_id into jnk1 from ra_customer_trx where customer_trx_id = l_bill_id;
3558: select org_id into jnk2 from ar_transaction_history where customer_trx_id = l_bill_id;
3559:
3560: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Header org_id = ' || to_char(jnk1) || 'org_id = ' ||
3561: to_char(jnk2));
3562:
3563: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3564: WHEN OTHERS THEN

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

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

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

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

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

3606: EXIT WHEN c_trx%NOTFOUND;
3607:
3608: program_debug(p_call,'nimm: l_org_id '||l_org_id);
3609:
3610: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM');
3611: AR_BILLS_CREATION_PUB.create_br_assignment (
3612: 1.0, -- p_api_version
3613: NULL, -- p_init_msg_list
3614: NULL, -- p_commit

Line 3611: AR_BILLS_CREATION_PUB.create_br_assignment (

3607:
3608: program_debug(p_call,'nimm: l_org_id '||l_org_id);
3609:
3610: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM');
3611: AR_BILLS_CREATION_PUB.create_br_assignment (
3612: 1.0, -- p_api_version
3613: NULL, -- p_init_msg_list
3614: NULL, -- p_commit
3615: NULL, -- p_validation_level,

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

3638: l_org_id, -- p_org_id
3639: l_customer_trx_line_id);
3640:
3641: select org_id into jnk1 from ra_customer_trx_lines where customer_trx_line_id = l_customer_trx_line_id;
3642: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for NIMM, org_id = '
3643: || to_char(jnk1));
3644:
3645: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3646: WHEN OTHERS

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

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

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

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);
3662: END IF;
3663: ROLLBACK TO create_BR_SVP2;
3664: IF p_call = 3 THEN

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

3688: FETCH c_trx INTO l_payment_schedule_id, l_assigned_amount, l_org_id;
3689: EXIT WHEN c_trx%NOTFOUND;
3690:
3691: program_debug(p_call,'imm: l_org_id '||l_org_id);
3692: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');
3693:
3694:
3695: AR_BILLS_CREATION_PUB.create_br_assignment (
3696: 1.0, -- p_api_version

Line 3695: AR_BILLS_CREATION_PUB.create_br_assignment (

3691: program_debug(p_call,'imm: l_org_id '||l_org_id);
3692: program_debug(p_call,'will call AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');
3693:
3694:
3695: AR_BILLS_CREATION_PUB.create_br_assignment (
3696: 1.0, -- p_api_version
3697: NULL, -- p_init_msg_list
3698: NULL, -- p_commit
3699: NULL, -- p_validation_level,

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

3721: NULL, -- p_attribute15
3722: l_org_id, -- p_org_id
3723: l_customer_trx_line_id);
3724:
3725: program_debug(p_call,'done with AR_BILLS_CREATION_PUB.Create_BR_Assignment for IMM');
3726:
3727:
3728: EXCEPTION /* Bug 3472744 Enclosed the following check in Exception block */
3729: WHEN OTHERS

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

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

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

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);
3745: END IF;
3746: ROLLBACK TO create_BR_SVP2;
3747: IF p_call = 3 THEN

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

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

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

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() ' ||
3809: '- error :'||l_msg_data);
3810: END IF;
3811: ROLLBACK TO create_BR_SVP2;
3812: IF p_call = 3 THEN