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

Line 63: x_return_status := FND_API.G_RET_STS_ERROR;

59: IF p_start_date IS NULL THEN
60: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
61: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_start_date' );
62: FND_MSG_PUB.ADD;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;
65:
66: IF p_end_date IS NULL THEN
67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 70: x_return_status := FND_API.G_RET_STS_ERROR;

66: IF p_end_date IS NULL THEN
67: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
68: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_end_date' );
69: FND_MSG_PUB.ADD;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: END IF;
72:
73: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
74: IF p_start_date < p_end_date THEN

Line 73: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

69: FND_MSG_PUB.ADD;
70: x_return_status := FND_API.G_RET_STS_ERROR;
71: END IF;
72:
73: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
74: IF p_start_date < p_end_date THEN
75: arp_standard.debug(' end date should be greater than the start date');
76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
77: --Int'l Calendar Project

Line 81: x_return_status := fnd_api.g_ret_sts_error;

77: --Int'l Calendar Project
78: fnd_message.set_token('DATE2', fnd_date.date_to_chardate(p_end_date, calendar_aware=> FND_DATE.calendar_aware_alt));
79: fnd_message.set_token('DATE1', fnd_date.date_to_chardate(p_start_date, calendar_aware=> FND_DATE.calendar_aware_alt));
80: fnd_msg_pub.add;
81: x_return_status := fnd_api.g_ret_sts_error;
82: END IF;
83: END IF;
84:
85: IF p_org_id IS NOT NULL THEN

Line 94: x_return_status := FND_API.G_RET_STS_ERROR;

90: FND_MESSAGE.SET_TOKEN('FK', 'org id');
91: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_id');
92: FND_MESSAGE.SET_TOKEN('TABLE', 'ar_system_parameters_all');
93: FND_MSG_PUB.ADD;
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: END IF;
96: CLOSE c_ou;
97: END IF;
98:

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
102: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
103: FND_MESSAGE.SET_TOKEN( 'VALUES', 'INV,CM,CB,DM,DEP,GUAR,ALL,INVDEPGUAR');
104: FND_MSG_PUB.ADD;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: END IF;
107: ELSIF p_entity = 'AR_CASH_RECEIPT_HISTORY_ALL' THEN
108: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
109: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
110: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
111: FND_MESSAGE.SET_TOKEN( 'VALUES', 'CASH,MISC,ALL');
112: FND_MSG_PUB.ADD;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: END IF;
115: ELSIF p_entity = 'AR_RECEIVABLE_APPLICATIONS_ALL' THEN
116: IF p_type NOT IN ('APP', 'CMAPP', 'ALL') THEN
117: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
118: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'trx_type' );
119: FND_MESSAGE.SET_TOKEN( 'VALUES', 'APP,CMAPP,ALL');
120: FND_MSG_PUB.ADD;
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: END IF;
123: END IF;
124:
125: END;

Line 189: l_upg_trx_date DATE := FND_API.G_MISS_DATE;

185: AND gld.event_id = distev.event_id(+)
186: ORDER BY DECODE(gld.account_set_flag,'N',1,2) asc;
187:
188: l_rec c%ROWTYPE;
189: l_upg_trx_date DATE := FND_API.G_MISS_DATE;
190: l_upg_gl_date DATE := FND_API.G_MISS_DATE;
191:
192: l_event_source_info xla_events_pub_pkg.t_event_source_info;
193: l_event_id NUMBER;

Line 190: l_upg_gl_date DATE := FND_API.G_MISS_DATE;

186: ORDER BY DECODE(gld.account_set_flag,'N',1,2) asc;
187:
188: l_rec c%ROWTYPE;
189: l_upg_trx_date DATE := FND_API.G_MISS_DATE;
190: l_upg_gl_date DATE := FND_API.G_MISS_DATE;
191:
192: l_event_source_info xla_events_pub_pkg.t_event_source_info;
193: l_event_id NUMBER;
194: l_valuation_method VARCHAR2(10);

Line 313: IF l_upg_trx_date <> FND_API.G_MISS_DATE OR l_upg_gl_date <> FND_API.G_MISS_DATE THEN

309: END IF;
310:
311:
312:
313: IF l_upg_trx_date <> FND_API.G_MISS_DATE OR l_upg_gl_date <> FND_API.G_MISS_DATE THEN
314: arp_standard.debug(' call update event with at transaction level');
315: xla_events_pub_pkg.update_event
316: (p_event_source_info => l_event_source_info,
317: p_event_id => l_event_id,

Line 560: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

556:
557:
558:
559: PROCEDURE upgrade_status_per_doc
560: (p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
561: p_entity_code IN VARCHAR2,
562: p_source_int_id IN NUMBER,
563: x_upgrade_status OUT NOCOPY VARCHAR2,
564: x_return_status OUT NOCOPY VARCHAR2,

Line 574: x_return_status := fnd_api.g_ret_sts_success;

570: BEGIN
571: arp_standard.debug('upgrade_status_per_doc +');
572: arp_standard.debug(' p_entity_code :'||p_entity_code);
573: arp_standard.debug(' p_source_int_id:'||p_source_int_id);
574: x_return_status := fnd_api.g_ret_sts_success;
575:
576: -- initialize message list if p_init_msg_list is set to TRUE.
577: IF FND_API.to_Boolean(p_init_msg_list) THEN
578: FND_MSG_PUB.initialize;

Line 577: IF FND_API.to_Boolean(p_init_msg_list) THEN

573: arp_standard.debug(' p_source_int_id:'||p_source_int_id);
574: x_return_status := fnd_api.g_ret_sts_success;
575:
576: -- initialize message list if p_init_msg_list is set to TRUE.
577: IF FND_API.to_Boolean(p_init_msg_list) THEN
578: FND_MSG_PUB.initialize;
579: END IF;
580:
581: IF p_entity_code NOT IN

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: FND_MESSAGE.SET_NAME( 'AR', 'AR_ONLY_VALUE_ALLOWED' );
587: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );
588: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');
589: FND_MSG_PUB.ADD;
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: RAISE fnd_api.G_EXC_ERROR;
592: END IF;
593:
594: DELETE FROM ar_detect_gt

Line 591: RAISE fnd_api.G_EXC_ERROR;

587: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'ENTITY_CODE' );
588: FND_MESSAGE.SET_TOKEN( 'VALUES', 'TRANSACTIONS,RECEIPTS,ADJUSTMENTS,BILLS_RECEIVABLE');
589: FND_MSG_PUB.ADD;
590: x_return_status := FND_API.G_RET_STS_ERROR;
591: RAISE fnd_api.G_EXC_ERROR;
592: END IF;
593:
594: DELETE FROM ar_detect_gt
595: WHERE entity_code = p_entity_code

Line 636: WHEN fnd_api.G_EXC_ERROR THEN

632: arp_standard.debug('upgrade_status_per_doc -');
633: EXCEPTION
634: WHEN end_execution THEN
635: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
636: WHEN fnd_api.G_EXC_ERROR THEN
637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: WHEN OTHERS THEN

Line 637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

633: EXCEPTION
634: WHEN end_execution THEN
635: arp_standard.debug(' x_upgrade_status :'||x_upgrade_status);
636: WHEN fnd_api.G_EXC_ERROR THEN
637: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: WHEN OTHERS THEN
641: arp_standard.debug('EXCEPTION OTHERS in upgrade_status_per_doc:'||SQLERRM);

Line 642: x_return_status := fnd_api.g_ret_sts_unexp_error;

638: p_count => x_msg_count,
639: p_data => x_msg_data);
640: WHEN OTHERS THEN
641: arp_standard.debug('EXCEPTION OTHERS in upgrade_status_per_doc:'||SQLERRM);
642: x_return_status := fnd_api.g_ret_sts_unexp_error;
643: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
644: fnd_message.set_token('ERROR' ,SQLERRM);
645: fnd_msg_pub.add;
646: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 646: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

642: x_return_status := fnd_api.g_ret_sts_unexp_error;
643: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
644: fnd_message.set_token('ERROR' ,SQLERRM);
645: fnd_msg_pub.add;
646: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
647: p_count => x_msg_count,
648: p_data => x_msg_data);
649: END;
650:

Line 688: x_return_status := FND_API.G_RET_STS_SUCCESS;

684: AND lk.ae_line_num = ae.ae_line_num);
685: l_adj_id NUMBER;
686: l_text VARCHAR2(2000);
687: BEGIN
688: x_return_status := FND_API.G_RET_STS_SUCCESS;
689: validate_parameter
690: (p_start_date => p_start_date,
691: p_end_date => p_end_date,
692: p_org_id => p_org_id,

Line 696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

692: p_org_id => p_org_id,
693: p_type => 'ADJ',
694: p_entity => 'AR_ADJUSTMENTS_ALL',
695: x_return_status => x_return_status);
696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
697: RAISE fnd_api.g_exc_error;
698: END IF;
699: OPEN c_adj(p_start_date, p_end_date,p_org_id);
700: FETCH c_adj INTO l_adj_id;

Line 697: RAISE fnd_api.g_exc_error;

693: p_type => 'ADJ',
694: p_entity => 'AR_ADJUSTMENTS_ALL',
695: x_return_status => x_return_status);
696: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
697: RAISE fnd_api.g_exc_error;
698: END IF;
699: OPEN c_adj(p_start_date, p_end_date,p_org_id);
700: FETCH c_adj INTO l_adj_id;
701: IF c_adj%FOUND THEN

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: That is the adjustment does not have accounting created - adjustment_id :'||l_adj_id;
704: log(l_text);
705: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
706: FND_MSG_PUB.ADD;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: END IF;
709: CLOSE c_adj;
710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: RAISE fnd_api.g_exc_error;

Line 710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

706: FND_MSG_PUB.ADD;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: END IF;
709: CLOSE c_adj;
710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: RAISE fnd_api.g_exc_error;
712: END IF;
713: EXCEPTION
714: WHEN fnd_api.g_exc_error THEN

Line 711: RAISE fnd_api.g_exc_error;

707: x_return_status := FND_API.G_RET_STS_ERROR;
708: END IF;
709: CLOSE c_adj;
710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: RAISE fnd_api.g_exc_error;
712: END IF;
713: EXCEPTION
714: WHEN fnd_api.g_exc_error THEN
715: fnd_msg_pub.count_and_get(

Line 714: WHEN fnd_api.g_exc_error THEN

710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: RAISE fnd_api.g_exc_error;
712: END IF;
713: EXCEPTION
714: WHEN fnd_api.g_exc_error THEN
715: fnd_msg_pub.count_and_get(
716: p_encoded => fnd_api.g_false,
717: p_count => x_msg_count,
718: p_data => x_msg_data);

Line 716: p_encoded => fnd_api.g_false,

712: END IF;
713: EXCEPTION
714: WHEN fnd_api.g_exc_error THEN
715: fnd_msg_pub.count_and_get(
716: p_encoded => fnd_api.g_false,
717: p_count => x_msg_count,
718: p_data => x_msg_data);
719: log(x_msg_data);
720: WHEN OTHERS THEN

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

717: p_count => x_msg_count,
718: p_data => x_msg_data);
719: log(x_msg_data);
720: WHEN OTHERS THEN
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
723: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
724: FND_MSG_PUB.ADD;
725: FND_MSG_PUB.Count_And_Get(

Line 726: p_encoded => FND_API.G_FALSE,

722: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
723: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
724: FND_MSG_PUB.ADD;
725: FND_MSG_PUB.Count_And_Get(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data);
729: log(x_msg_data);
730: END;

Line 784: x_return_status := FND_API.G_RET_STS_SUCCESS;

780: l_trx_id NUMBER;
781: l_text VARCHAR2(2000);
782: l_tag VARCHAR2(80);
783: BEGIN
784: x_return_status := FND_API.G_RET_STS_SUCCESS;
785: validate_parameter
786: (p_start_date => p_start_date,
787: p_end_date => p_end_date,
788: p_org_id => p_org_id,

Line 792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

788: p_org_id => p_org_id,
789: p_type => p_type,
790: p_entity => 'RA_CUST_TRX_LINE_GL_DIST_ALL',
791: x_return_status => x_return_status);
792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: RAISE fnd_api.g_exc_error;
794: END IF;
795: IF p_type = 'INV' THEN l_tag := 'Sales Invoice';
796: ELSIF p_type = 'CM' THEN l_tag := 'Credit Memo';

Line 793: RAISE fnd_api.g_exc_error;

789: p_type => p_type,
790: p_entity => 'RA_CUST_TRX_LINE_GL_DIST_ALL',
791: x_return_status => x_return_status);
792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: RAISE fnd_api.g_exc_error;
794: END IF;
795: IF p_type = 'INV' THEN l_tag := 'Sales Invoice';
796: ELSIF p_type = 'CM' THEN l_tag := 'Credit Memo';
797: ELSIF p_type = 'DM' THEN l_tag := 'Debit Memo';

Line 810: x_return_status := FND_API.G_RET_STS_ERROR;

806: The '|| l_tag ||' does not have accounting created - customer_trx_id :'||l_trx_id;
807: log(l_text);
808: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
809: FND_MSG_PUB.ADD;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END IF;
812: CLOSE c_trx;
813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
814: RAISE fnd_api.g_exc_error;

Line 813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

809: FND_MSG_PUB.ADD;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END IF;
812: CLOSE c_trx;
813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
814: RAISE fnd_api.g_exc_error;
815: END IF;
816: EXCEPTION
817: WHEN fnd_api.g_exc_error THEN

Line 814: RAISE fnd_api.g_exc_error;

810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END IF;
812: CLOSE c_trx;
813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
814: RAISE fnd_api.g_exc_error;
815: END IF;
816: EXCEPTION
817: WHEN fnd_api.g_exc_error THEN
818: fnd_msg_pub.count_and_get(

Line 817: WHEN fnd_api.g_exc_error THEN

813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
814: RAISE fnd_api.g_exc_error;
815: END IF;
816: EXCEPTION
817: WHEN fnd_api.g_exc_error THEN
818: fnd_msg_pub.count_and_get(
819: p_encoded => fnd_api.g_false,
820: p_count => x_msg_count,
821: p_data => x_msg_data);

Line 819: p_encoded => fnd_api.g_false,

815: END IF;
816: EXCEPTION
817: WHEN fnd_api.g_exc_error THEN
818: fnd_msg_pub.count_and_get(
819: p_encoded => fnd_api.g_false,
820: p_count => x_msg_count,
821: p_data => x_msg_data);
822: log(x_msg_data);
823: WHEN OTHERS THEN

Line 824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

820: p_count => x_msg_count,
821: p_data => x_msg_data);
822: log(x_msg_data);
823: WHEN OTHERS THEN
824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
826: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
827: FND_MSG_PUB.ADD;
828: FND_MSG_PUB.Count_And_Get(

Line 829: p_encoded => FND_API.G_FALSE,

825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
826: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
827: FND_MSG_PUB.ADD;
828: FND_MSG_PUB.Count_And_Get(
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data);
832: log(x_msg_data);
833: END;

Line 880: x_return_status := FND_API.G_RET_STS_SUCCESS;

876: l_cr_id NUMBER;
877: l_text VARCHAR2(2000);
878: l_tag VARCHAR2(80);
879: BEGIN
880: x_return_status := FND_API.G_RET_STS_SUCCESS;
881: validate_parameter
882: (p_start_date => p_start_date,
883: p_end_date => p_end_date,
884: p_org_id => p_org_id,

Line 888: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

884: p_org_id => p_org_id,
885: p_type => p_type,
886: p_entity => 'AR_CASH_RECEIPT_HISTORY_ALL',
887: x_return_status => x_return_status);
888: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
889: RAISE fnd_api.g_exc_error;
890: END IF;
891: IF p_type = 'CASH' THEN
892: l_tag := 'Trade Receipt';

Line 889: RAISE fnd_api.g_exc_error;

885: p_type => p_type,
886: p_entity => 'AR_CASH_RECEIPT_HISTORY_ALL',
887: x_return_status => x_return_status);
888: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
889: RAISE fnd_api.g_exc_error;
890: END IF;
891: IF p_type = 'CASH' THEN
892: l_tag := 'Trade Receipt';
893: ELSE

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900: That is the '|| l_tag ||' does not have accounting created - cash_receipt_id :'||l_cr_id;
901: log(l_text);
902: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
903: FND_MSG_PUB.ADD;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906: CLOSE c_recp;
907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
908: RAISE fnd_api.g_exc_error;

Line 907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

903: FND_MSG_PUB.ADD;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906: CLOSE c_recp;
907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
908: RAISE fnd_api.g_exc_error;
909: END IF;
910: EXCEPTION
911: WHEN fnd_api.g_exc_error THEN

Line 908: RAISE fnd_api.g_exc_error;

904: x_return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906: CLOSE c_recp;
907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
908: RAISE fnd_api.g_exc_error;
909: END IF;
910: EXCEPTION
911: WHEN fnd_api.g_exc_error THEN
912: fnd_msg_pub.count_and_get(

Line 911: WHEN fnd_api.g_exc_error THEN

907: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
908: RAISE fnd_api.g_exc_error;
909: END IF;
910: EXCEPTION
911: WHEN fnd_api.g_exc_error THEN
912: fnd_msg_pub.count_and_get(
913: p_encoded => fnd_api.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data);

Line 913: p_encoded => fnd_api.g_false,

909: END IF;
910: EXCEPTION
911: WHEN fnd_api.g_exc_error THEN
912: fnd_msg_pub.count_and_get(
913: p_encoded => fnd_api.g_false,
914: p_count => x_msg_count,
915: p_data => x_msg_data);
916: log(x_msg_data);
917: WHEN OTHERS THEN

Line 918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

914: p_count => x_msg_count,
915: p_data => x_msg_data);
916: log(x_msg_data);
917: WHEN OTHERS THEN
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
920: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
921: FND_MSG_PUB.ADD;
922: FND_MSG_PUB.Count_And_Get(

Line 923: p_encoded => FND_API.G_FALSE,

919: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
920: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
921: FND_MSG_PUB.ADD;
922: FND_MSG_PUB.Count_And_Get(
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926: log(x_msg_data);
927: END;

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: l_ra_id NUMBER;
973: l_text VARCHAR2(2000);
974: l_tag VARCHAR2(80);
975: BEGIN
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977: validate_parameter
978: (p_start_date => p_start_date,
979: p_end_date => p_end_date,
980: p_org_id => p_org_id,

Line 984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

980: p_org_id => p_org_id,
981: p_type => p_type,
982: p_entity => 'AR_RECEIVABLE_APPLICATIONS_ALL',
983: x_return_status => x_return_status);
984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE fnd_api.g_exc_error;
986: END IF;
987: IF p_type = 'APP' THEN
988: l_tag := 'Cash Receipt Application';

Line 985: RAISE fnd_api.g_exc_error;

981: p_type => p_type,
982: p_entity => 'AR_RECEIVABLE_APPLICATIONS_ALL',
983: x_return_status => x_return_status);
984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE fnd_api.g_exc_error;
986: END IF;
987: IF p_type = 'APP' THEN
988: l_tag := 'Cash Receipt Application';
989: ELSIF p_type = 'CMAPP' THEN

Line 1002: x_return_status := FND_API.G_RET_STS_ERROR;

998: That is the '|| l_tag ||' does not have accounting created - receivable_application_id :'||l_ra_id;
999: log(l_text);
1000: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
1001: FND_MSG_PUB.ADD;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: END IF;
1004: CLOSE c_app;
1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1006: RAISE fnd_api.g_exc_error;

Line 1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1001: FND_MSG_PUB.ADD;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: END IF;
1004: CLOSE c_app;
1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1006: RAISE fnd_api.g_exc_error;
1007: END IF;
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error THEN

Line 1006: RAISE fnd_api.g_exc_error;

1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: END IF;
1004: CLOSE c_app;
1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1006: RAISE fnd_api.g_exc_error;
1007: END IF;
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error THEN
1010: fnd_msg_pub.count_and_get(

Line 1009: WHEN fnd_api.g_exc_error THEN

1005: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1006: RAISE fnd_api.g_exc_error;
1007: END IF;
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error THEN
1010: fnd_msg_pub.count_and_get(
1011: p_encoded => fnd_api.g_false,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data);

Line 1011: p_encoded => fnd_api.g_false,

1007: END IF;
1008: EXCEPTION
1009: WHEN fnd_api.g_exc_error THEN
1010: fnd_msg_pub.count_and_get(
1011: p_encoded => fnd_api.g_false,
1012: p_count => x_msg_count,
1013: p_data => x_msg_data);
1014: log(x_msg_data);
1015: WHEN OTHERS THEN

Line 1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1012: p_count => x_msg_count,
1013: p_data => x_msg_data);
1014: log(x_msg_data);
1015: WHEN OTHERS THEN
1016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1017: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1018: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1019: FND_MSG_PUB.ADD;
1020: FND_MSG_PUB.Count_And_Get(

Line 1021: p_encoded => FND_API.G_FALSE,

1017: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1018: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1019: FND_MSG_PUB.ADD;
1020: FND_MSG_PUB.Count_And_Get(
1021: p_encoded => FND_API.G_FALSE,
1022: p_count => x_msg_count,
1023: p_data => x_msg_data);
1024: log(x_msg_data);
1025: END;

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: AND lk.ae_line_num = ae.ae_line_num);
1059: l_trx_id NUMBER;
1060: l_text VARCHAR2(2000);
1061: BEGIN
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063: validate_parameter
1064: (p_start_date => p_start_date,
1065: p_end_date => p_end_date,
1066: p_org_id => p_org_id,

Line 1070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1066: p_org_id => p_org_id,
1067: p_type => 'BILL',
1068: p_entity => 'AR_TRANSACTION_HISTORY_ALL',
1069: x_return_status => x_return_status);
1070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1071: RAISE fnd_api.g_exc_error;
1072: END IF;
1073: OPEN c(p_start_date, p_end_date,p_org_id);
1074: FETCH c INTO l_trx_id;

Line 1071: RAISE fnd_api.g_exc_error;

1067: p_type => 'BILL',
1068: p_entity => 'AR_TRANSACTION_HISTORY_ALL',
1069: x_return_status => x_return_status);
1070: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1071: RAISE fnd_api.g_exc_error;
1072: END IF;
1073: OPEN c(p_start_date, p_end_date,p_org_id);
1074: FETCH c INTO l_trx_id;
1075: IF c%FOUND THEN

Line 1081: x_return_status := FND_API.G_RET_STS_ERROR;

1077: That is the bill does not have accounting created - customer_trx_id :'||l_trx_id;
1078: log(l_text);
1079: FND_MESSAGE.SET_NAME('AR','AR_SUBMIT_ACCT_REQ');
1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: END IF;
1083: CLOSE c;
1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: RAISE fnd_api.g_exc_error;

Line 1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1080: FND_MSG_PUB.ADD;
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: END IF;
1083: CLOSE c;
1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: RAISE fnd_api.g_exc_error;
1086: END IF;
1087: EXCEPTION
1088: WHEN fnd_api.g_exc_error THEN

Line 1085: RAISE fnd_api.g_exc_error;

1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: END IF;
1083: CLOSE c;
1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: RAISE fnd_api.g_exc_error;
1086: END IF;
1087: EXCEPTION
1088: WHEN fnd_api.g_exc_error THEN
1089: fnd_msg_pub.count_and_get(

Line 1088: WHEN fnd_api.g_exc_error THEN

1084: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1085: RAISE fnd_api.g_exc_error;
1086: END IF;
1087: EXCEPTION
1088: WHEN fnd_api.g_exc_error THEN
1089: fnd_msg_pub.count_and_get(
1090: p_encoded => fnd_api.g_false,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data);

Line 1090: p_encoded => fnd_api.g_false,

1086: END IF;
1087: EXCEPTION
1088: WHEN fnd_api.g_exc_error THEN
1089: fnd_msg_pub.count_and_get(
1090: p_encoded => fnd_api.g_false,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data);
1093: log(x_msg_data);
1094: WHEN OTHERS THEN

Line 1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1091: p_count => x_msg_count,
1092: p_data => x_msg_data);
1093: log(x_msg_data);
1094: WHEN OTHERS THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1097: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1098: FND_MSG_PUB.ADD;
1099: FND_MSG_PUB.Count_And_Get(

Line 1100: p_encoded => FND_API.G_FALSE,

1096: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1097: FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);
1098: FND_MSG_PUB.ADD;
1099: FND_MSG_PUB.Count_And_Get(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);
1103: log(x_msg_data);
1104: END;

Line 1109: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

1105:
1106:
1107:
1108: PROCEDURE r12_dist_in_xla
1109: (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1110: p_start_date IN DATE,
1111: p_end_date IN DATE,
1112: p_xla_post_status IN VARCHAR2 DEFAULT 'Y',
1113: p_inv_flag IN VARCHAR2 DEFAULT 'Y',

Line 1146: x_return_status := fnd_api.g_ret_sts_success;

1142: log(' p_recp_flag :'||p_recp_flag);
1143: log(' p_misc_flag :'||p_misc_flag);
1144: log(' p_bill_flag :'||p_bill_flag);
1145: log(' p_org_id :'||p_org_id);
1146: x_return_status := fnd_api.g_ret_sts_success;
1147: l_return_status := fnd_api.g_ret_sts_success;
1148: IF fnd_api.to_boolean(p_init_msg_list) THEN
1149: fnd_msg_pub.initialize;
1150: END IF;

Line 1147: l_return_status := fnd_api.g_ret_sts_success;

1143: log(' p_misc_flag :'||p_misc_flag);
1144: log(' p_bill_flag :'||p_bill_flag);
1145: log(' p_org_id :'||p_org_id);
1146: x_return_status := fnd_api.g_ret_sts_success;
1147: l_return_status := fnd_api.g_ret_sts_success;
1148: IF fnd_api.to_boolean(p_init_msg_list) THEN
1149: fnd_msg_pub.initialize;
1150: END IF;
1151: IF p_xla_post_status = 'Y' THEN

Line 1148: IF fnd_api.to_boolean(p_init_msg_list) THEN

1144: log(' p_bill_flag :'||p_bill_flag);
1145: log(' p_org_id :'||p_org_id);
1146: x_return_status := fnd_api.g_ret_sts_success;
1147: l_return_status := fnd_api.g_ret_sts_success;
1148: IF fnd_api.to_boolean(p_init_msg_list) THEN
1149: fnd_msg_pub.initialize;
1150: END IF;
1151: IF p_xla_post_status = 'Y' THEN
1152: RAISE only_posted_jle;

Line 1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1157: p_org_id => p_org_id,
1158: p_type => 'NOT_SPECIFIED',
1159: p_entity => 'NOT_SPECIFIED',
1160: x_return_status => l_return_status);
1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1162: RAISE fnd_api.g_exc_error;
1163: END IF;
1164: --
1165: --Running for transactions

Line 1162: RAISE fnd_api.g_exc_error;

1158: p_type => 'NOT_SPECIFIED',
1159: p_entity => 'NOT_SPECIFIED',
1160: x_return_status => l_return_status);
1161: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1162: RAISE fnd_api.g_exc_error;
1163: END IF;
1164: --
1165: --Running for transactions
1166: --

Line 1176: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1172: p_org_id => p_org_id,
1173: x_return_status => l_return_status,
1174: x_msg_count => l_msg_count,
1175: x_msg_data => l_msg_data);
1176: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1177: x_return_status := l_return_status;
1178: RAISE fnd_api.g_exc_error;
1179: END IF;
1180: ELSE

Line 1178: RAISE fnd_api.g_exc_error;

1174: x_msg_count => l_msg_count,
1175: x_msg_data => l_msg_data);
1176: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1177: x_return_status := l_return_status;
1178: RAISE fnd_api.g_exc_error;
1179: END IF;
1180: ELSE
1181: IF (p_inv_flag = 'Y') THEN
1182: r12_trx_in_xla

Line 1190: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1186: p_org_id => p_org_id,
1187: x_return_status => l_return_status,
1188: x_msg_count => l_msg_count,
1189: x_msg_data => l_msg_data);
1190: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1191: x_return_status := l_return_status;
1192: RAISE fnd_api.g_exc_error;
1193: END IF;
1194: END IF;

Line 1192: RAISE fnd_api.g_exc_error;

1188: x_msg_count => l_msg_count,
1189: x_msg_data => l_msg_data);
1190: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1191: x_return_status := l_return_status;
1192: RAISE fnd_api.g_exc_error;
1193: END IF;
1194: END IF;
1195: IF (p_dm_flag = 'Y') THEN
1196: r12_trx_in_xla

Line 1204: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1200: p_org_id => p_org_id,
1201: x_return_status => l_return_status,
1202: x_msg_count => l_msg_count,
1203: x_msg_data => l_msg_data);
1204: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1205: x_return_status := l_return_status;
1206: RAISE fnd_api.g_exc_error;
1207: END IF;
1208: END IF;

Line 1206: RAISE fnd_api.g_exc_error;

1202: x_msg_count => l_msg_count,
1203: x_msg_data => l_msg_data);
1204: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1205: x_return_status := l_return_status;
1206: RAISE fnd_api.g_exc_error;
1207: END IF;
1208: END IF;
1209: IF (p_cb_flag = 'Y') THEN
1210: r12_trx_in_xla

Line 1218: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1214: p_org_id => p_org_id,
1215: x_return_status => l_return_status,
1216: x_msg_count => l_msg_count,
1217: x_msg_data => l_msg_data);
1218: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1219: x_return_status := l_return_status;
1220: RAISE fnd_api.g_exc_error;
1221: END IF;
1222: END IF;

Line 1220: RAISE fnd_api.g_exc_error;

1216: x_msg_count => l_msg_count,
1217: x_msg_data => l_msg_data);
1218: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1219: x_return_status := l_return_status;
1220: RAISE fnd_api.g_exc_error;
1221: END IF;
1222: END IF;
1223: IF (p_cm_flag = 'Y') THEN
1224: r12_trx_in_xla

Line 1232: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1228: p_org_id => p_org_id,
1229: x_return_status => l_return_status,
1230: x_msg_count => l_msg_count,
1231: x_msg_data => l_msg_data);
1232: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1233: x_return_status := l_return_status;
1234: RAISE fnd_api.g_exc_error;
1235: END IF;
1236: END IF;

Line 1234: RAISE fnd_api.g_exc_error;

1230: x_msg_count => l_msg_count,
1231: x_msg_data => l_msg_data);
1232: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1233: x_return_status := l_return_status;
1234: RAISE fnd_api.g_exc_error;
1235: END IF;
1236: END IF;
1237: END IF;
1238: --

Line 1249: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1245: p_org_id => p_org_id,
1246: x_return_status => l_return_status,
1247: x_msg_count => l_msg_count,
1248: x_msg_data => l_msg_data);
1249: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1250: x_return_status := l_return_status;
1251: RAISE fnd_api.g_exc_error;
1252: END IF;
1253: END IF;

Line 1251: RAISE fnd_api.g_exc_error;

1247: x_msg_count => l_msg_count,
1248: x_msg_data => l_msg_data);
1249: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1250: x_return_status := l_return_status;
1251: RAISE fnd_api.g_exc_error;
1252: END IF;
1253: END IF;
1254: --
1255: --Running for receipts

Line 1266: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1262: p_type => 'ALL',
1263: x_return_status => l_return_status,
1264: x_msg_count => l_msg_count,
1265: x_msg_data => l_msg_data);
1266: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1267: x_return_status := l_return_status;
1268: RAISE fnd_api.g_exc_error;
1269: END IF;
1270: ELSE

Line 1268: RAISE fnd_api.g_exc_error;

1264: x_msg_count => l_msg_count,
1265: x_msg_data => l_msg_data);
1266: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1267: x_return_status := l_return_status;
1268: RAISE fnd_api.g_exc_error;
1269: END IF;
1270: ELSE
1271: IF p_recp_flag = 'Y' THEN
1272: r12_crh_in_xla

Line 1280: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1276: p_type => 'CASH',
1277: x_return_status => l_return_status,
1278: x_msg_count => l_msg_count,
1279: x_msg_data => l_msg_data);
1280: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1281: x_return_status := l_return_status;
1282: RAISE fnd_api.g_exc_error;
1283: END IF;
1284: END IF;

Line 1282: RAISE fnd_api.g_exc_error;

1278: x_msg_count => l_msg_count,
1279: x_msg_data => l_msg_data);
1280: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1281: x_return_status := l_return_status;
1282: RAISE fnd_api.g_exc_error;
1283: END IF;
1284: END IF;
1285: IF p_misc_flag = 'Y' THEN
1286: r12_crh_in_xla

Line 1294: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1290: p_type => 'MISC',
1291: x_return_status => l_return_status,
1292: x_msg_count => l_msg_count,
1293: x_msg_data => l_msg_data);
1294: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1295: x_return_status := l_return_status;
1296: RAISE fnd_api.g_exc_error;
1297: END IF;
1298: END IF;

Line 1296: RAISE fnd_api.g_exc_error;

1292: x_msg_count => l_msg_count,
1293: x_msg_data => l_msg_data);
1294: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1295: x_return_status := l_return_status;
1296: RAISE fnd_api.g_exc_error;
1297: END IF;
1298: END IF;
1299: END IF;
1300: --

Line 1312: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1308: p_type => 'ALL',
1309: x_return_status => l_return_status,
1310: x_msg_count => l_msg_count,
1311: x_msg_data => l_msg_data);
1312: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1313: x_return_status := l_return_status;
1314: RAISE fnd_api.g_exc_error;
1315: END IF;
1316: ELSE

Line 1314: RAISE fnd_api.g_exc_error;

1310: x_msg_count => l_msg_count,
1311: x_msg_data => l_msg_data);
1312: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1313: x_return_status := l_return_status;
1314: RAISE fnd_api.g_exc_error;
1315: END IF;
1316: ELSE
1317: IF p_recp_flag = 'Y' THEN
1318: r12_app_in_xla

Line 1326: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1322: p_type => 'APP',
1323: x_return_status => l_return_status,
1324: x_msg_count => l_msg_count,
1325: x_msg_data => l_msg_data);
1326: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1327: x_return_status := l_return_status;
1328: RAISE fnd_api.g_exc_error;
1329: END IF;
1330: END IF;

Line 1328: RAISE fnd_api.g_exc_error;

1324: x_msg_count => l_msg_count,
1325: x_msg_data => l_msg_data);
1326: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1327: x_return_status := l_return_status;
1328: RAISE fnd_api.g_exc_error;
1329: END IF;
1330: END IF;
1331: IF p_cmapp_flag = 'Y' THEN
1332: r12_app_in_xla

Line 1340: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1336: p_type => 'CMAPP',
1337: x_return_status => l_return_status,
1338: x_msg_count => l_msg_count,
1339: x_msg_data => l_msg_data);
1340: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1341: x_return_status := l_return_status;
1342: RAISE fnd_api.g_exc_error;
1343: END IF;
1344: END IF;

Line 1342: RAISE fnd_api.g_exc_error;

1338: x_msg_count => l_msg_count,
1339: x_msg_data => l_msg_data);
1340: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1341: x_return_status := l_return_status;
1342: RAISE fnd_api.g_exc_error;
1343: END IF;
1344: END IF;
1345: END IF;
1346: --

Line 1357: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1353: p_org_id => p_org_id,
1354: x_return_status => l_return_status,
1355: x_msg_count => l_msg_count,
1356: x_msg_data => l_msg_data);
1357: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1358: x_return_status := l_return_status;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;

Line 1359: RAISE fnd_api.g_exc_error;

1355: x_msg_count => l_msg_count,
1356: x_msg_data => l_msg_data);
1357: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1358: x_return_status := l_return_status;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361: END IF;
1362: log('r12_dist_in_xla -');
1363: EXCEPTION

Line 1366: WHEN fnd_api.g_exc_error THEN

1362: log('r12_dist_in_xla -');
1363: EXCEPTION
1364: WHEN only_posted_jle THEN
1365: log('the user wants to see only posted documents, no check to verify data in XLA');
1366: WHEN fnd_api.g_exc_error THEN
1367: x_msg_count := l_msg_count;
1368: IF l_msg_count > 1 THEN
1369: FOR i IN 1..l_msg_count LOOP
1370: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

Line 1370: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

1366: WHEN fnd_api.g_exc_error THEN
1367: x_msg_count := l_msg_count;
1368: IF l_msg_count > 1 THEN
1369: FOR i IN 1..l_msg_count LOOP
1370: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1371: x_msg_data := x_msg_data||'-'||l_msg_data;
1372: log(l_msg_data);
1373: END LOOP;
1374: ELSE

Line 1378: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

1374: ELSE
1375: x_msg_data := l_msg_data;
1376: END IF;
1377: WHEN OTHERS THEN
1378: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
1379: log('EXCEPTION OTHERS in r12_dist_in_xla :'||SQLERRM);
1380: END;
1381:
1382:

Line 1498: RAISE fnd_api.g_exc_error;

1494: FROM AR_RECEIVABLE_APPLICATIONS
1495: WHERE CASH_RECEIPT_ID = p_source_id_int_1 )
1496: AND source_type NOT IN ('UNID');
1497: ELSE
1498: RAISE fnd_api.g_exc_error;
1499:
1500: END IF;
1501:
1502: END IF;

Line 1556: x_return_status := FND_API.g_ret_sts_success;

1552:
1553: l_date DATE;
1554: BEGIN
1555: arp_standard.debug('check_period_open +');
1556: x_return_status := FND_API.g_ret_sts_success;
1557:
1558: OPEN c_verif_date(p_entity_id);
1559: FETCH c_verif_date INTO l_date;
1560: IF c_verif_date%FOUND THEN

Line 1561: x_return_status := FND_API.g_ret_sts_error;

1557:
1558: OPEN c_verif_date(p_entity_id);
1559: FETCH c_verif_date INTO l_date;
1560: IF c_verif_date%FOUND THEN
1561: x_return_status := FND_API.g_ret_sts_error;
1562: arp_standard.debug(' event_date :' || l_date);
1563: FND_MESSAGE.SET_NAME('AR','AR_NOT_OPEN_PERIOD_EXISTS');
1564: FND_MSG_PUB.ADD; --BUG#5386043
1565: END IF;

Line 1568: IF x_return_status <> FND_API.g_ret_sts_success THEN

1564: FND_MSG_PUB.ADD; --BUG#5386043
1565: END IF;
1566: CLOSE c_verif_date;
1567:
1568: IF x_return_status <> FND_API.g_ret_sts_success THEN
1569: RAISE fnd_api.G_EXC_ERROR;
1570: END IF;
1571: arp_standard.debug('check_period_open -');
1572: EXCEPTION

Line 1569: RAISE fnd_api.G_EXC_ERROR;

1565: END IF;
1566: CLOSE c_verif_date;
1567:
1568: IF x_return_status <> FND_API.g_ret_sts_success THEN
1569: RAISE fnd_api.G_EXC_ERROR;
1570: END IF;
1571: arp_standard.debug('check_period_open -');
1572: EXCEPTION
1573: WHEN fnd_api.G_EXC_ERROR THEN

Line 1573: WHEN fnd_api.G_EXC_ERROR THEN

1569: RAISE fnd_api.G_EXC_ERROR;
1570: END IF;
1571: arp_standard.debug('check_period_open -');
1572: EXCEPTION
1573: WHEN fnd_api.G_EXC_ERROR THEN
1574: arp_standard.debug('EXCEPTION G_EXC_ERROR');
1575: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1576: p_count => x_msg_count,
1577: p_data => x_msg_data);

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

1571: arp_standard.debug('check_period_open -');
1572: EXCEPTION
1573: WHEN fnd_api.G_EXC_ERROR THEN
1574: arp_standard.debug('EXCEPTION G_EXC_ERROR');
1575: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1576: p_count => x_msg_count,
1577: p_data => x_msg_data);
1578: WHEN OTHERS THEN
1579: arp_standard.debug('EXCEPTION OTHERS:'|| SQLERRM);

Line 1580: x_return_status := FND_API.g_ret_sts_error;

1576: p_count => x_msg_count,
1577: p_data => x_msg_data);
1578: WHEN OTHERS THEN
1579: arp_standard.debug('EXCEPTION OTHERS:'|| SQLERRM);
1580: x_return_status := FND_API.g_ret_sts_error;
1581: x_msg_data := SQLERRM;
1582: x_msg_count := 1;
1583: END;
1584: