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: fnd_message.set_token('DATE2', p_end_date);

Line 80: x_return_status := fnd_api.g_ret_sts_error;

76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
77: fnd_message.set_token('DATE2', p_end_date);
78: fnd_message.set_token('DATE1', p_start_date);
79: fnd_msg_pub.add;
80: x_return_status := fnd_api.g_ret_sts_error;
81: END IF;
82: END IF;
83:
84: IF p_org_id IS NOT NULL THEN

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 104: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 188: l_upg_trx_date DATE := FND_API.G_MISS_DATE;

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

Line 189: l_upg_gl_date DATE := FND_API.G_MISS_DATE;

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

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

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

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

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

Line 572: x_return_status := fnd_api.g_ret_sts_success;

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

Line 575: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 588: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 589: RAISE fnd_api.G_EXC_ERROR;

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

Line 634: WHEN fnd_api.G_EXC_ERROR THEN

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

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

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

Line 640: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 694: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 695: RAISE fnd_api.g_exc_error;

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

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 708: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 709: RAISE fnd_api.g_exc_error;

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

Line 712: WHEN fnd_api.g_exc_error THEN

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

Line 714: p_encoded => fnd_api.g_false,

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

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 724: p_encoded => FND_API.G_FALSE,

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

Line 782: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 791: RAISE fnd_api.g_exc_error;

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

Line 808: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 811: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 812: RAISE fnd_api.g_exc_error;

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

Line 815: WHEN fnd_api.g_exc_error THEN

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

Line 817: p_encoded => fnd_api.g_false,

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

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 827: p_encoded => FND_API.G_FALSE,

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

Line 878: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 886: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 887: RAISE fnd_api.g_exc_error;

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

Line 902: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 906: RAISE fnd_api.g_exc_error;

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

Line 909: WHEN fnd_api.g_exc_error THEN

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

Line 911: p_encoded => fnd_api.g_false,

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

Line 916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 921: p_encoded => FND_API.G_FALSE,

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

Line 974: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 983: RAISE fnd_api.g_exc_error;

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

Line 1000: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1003: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1004: RAISE fnd_api.g_exc_error;

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

Line 1007: WHEN fnd_api.g_exc_error THEN

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

Line 1009: p_encoded => fnd_api.g_false,

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

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1019: p_encoded => FND_API.G_FALSE,

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

Line 1060: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1068: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1069: RAISE fnd_api.g_exc_error;

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

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1082: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 1083: RAISE fnd_api.g_exc_error;

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

Line 1086: WHEN fnd_api.g_exc_error THEN

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

Line 1088: p_encoded => fnd_api.g_false,

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

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1098: p_encoded => FND_API.G_FALSE,

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

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

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

Line 1144: x_return_status := fnd_api.g_ret_sts_success;

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

Line 1145: l_return_status := fnd_api.g_ret_sts_success;

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

Line 1146: IF fnd_api.to_boolean(p_init_msg_list) THEN

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

Line 1159: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1160: RAISE fnd_api.g_exc_error;

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

Line 1174: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1176: RAISE fnd_api.g_exc_error;

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

Line 1188: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1190: RAISE fnd_api.g_exc_error;

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

Line 1202: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1204: RAISE fnd_api.g_exc_error;

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

Line 1216: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1218: RAISE fnd_api.g_exc_error;

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

Line 1230: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1232: RAISE fnd_api.g_exc_error;

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

Line 1247: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1249: RAISE fnd_api.g_exc_error;

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

Line 1264: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1266: RAISE fnd_api.g_exc_error;

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

Line 1278: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1280: RAISE fnd_api.g_exc_error;

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

Line 1292: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1294: RAISE fnd_api.g_exc_error;

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

Line 1310: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1312: RAISE fnd_api.g_exc_error;

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

Line 1324: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1326: RAISE fnd_api.g_exc_error;

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

Line 1338: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1340: RAISE fnd_api.g_exc_error;

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

Line 1355: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1357: RAISE fnd_api.g_exc_error;

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

Line 1364: WHEN fnd_api.g_exc_error THEN

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

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

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

Line 1376: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

Line 1496: RAISE fnd_api.g_exc_error;

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

Line 1554: x_return_status := FND_API.g_ret_sts_success;

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

Line 1559: x_return_status := FND_API.g_ret_sts_error;

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

Line 1566: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

Line 1567: RAISE fnd_api.G_EXC_ERROR;

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

Line 1571: WHEN fnd_api.G_EXC_ERROR THEN

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

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

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

Line 1578: x_return_status := FND_API.g_ret_sts_error;

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