DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.ADD;

58: BEGIN
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

Line 69: FND_MSG_PUB.ADD;

65:
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

Line 80: fnd_msg_pub.add;

76: fnd_message.set_name('AR', 'HZ_API_DATE_GREATER');
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:

Line 93: FND_MSG_PUB.ADD;

89: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
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;

Line 104: FND_MSG_PUB.ADD;

100: IF p_type NOT IN ('INV', 'CM', 'CB', 'DM', 'DEP', 'GUAR', 'ALL','INVDEPGUAR') THEN
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

Line 112: FND_MSG_PUB.ADD;

108: IF p_type NOT IN ('CASH', 'MISC', 'ALL') THEN
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

Line 120: FND_MSG_PUB.ADD;

116: IF p_type NOT IN ('APP', 'CMAPP', 'ALL') THEN
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:

Line 578: FND_MSG_PUB.initialize;

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
582: ('TRANSACTIONS','RECEIPTS',

Line 589: FND_MSG_PUB.ADD;

585: arp_standard.debug('Value for entity code should be TRANSACTIONS RECEIPTS ADJUSTMENTS BILLS_RECEIVABLE');
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:

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 645: fnd_msg_pub.add;

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,
647: p_count => x_msg_count,
648: p_data => x_msg_data);
649: END;

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 706: FND_MSG_PUB.ADD;

702: l_text := ' There is at least one adjustment not posted and does not have a xla distribution paired.
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

Line 715: fnd_msg_pub.count_and_get(

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);
719: log(x_msg_data);

Line 724: FND_MSG_PUB.ADD;

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(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data);

Line 725: FND_MSG_PUB.Count_And_Get(

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(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data);
729: log(x_msg_data);

Line 809: FND_MSG_PUB.ADD;

805: l_text := ' There is at least one '|| l_tag ||' not posted but does not have at least xla distribution paired.
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

Line 818: fnd_msg_pub.count_and_get(

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);
822: log(x_msg_data);

Line 827: FND_MSG_PUB.ADD;

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(
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data);

Line 828: FND_MSG_PUB.Count_And_Get(

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(
829: p_encoded => FND_API.G_FALSE,
830: p_count => x_msg_count,
831: p_data => x_msg_data);
832: log(x_msg_data);

Line 903: FND_MSG_PUB.ADD;

899: l_text := ' There is at least one '|| l_tag ||' not posted and does not have a xla distribution paired.
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

Line 912: fnd_msg_pub.count_and_get(

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);
916: log(x_msg_data);

Line 921: FND_MSG_PUB.ADD;

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(
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,
925: p_data => x_msg_data);

Line 922: FND_MSG_PUB.Count_And_Get(

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(
923: p_encoded => FND_API.G_FALSE,
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926: log(x_msg_data);

Line 1001: FND_MSG_PUB.ADD;

997: l_text := ' There is at least one '||l_tag||' not posted and does not have a xla distribution paired.
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

Line 1010: fnd_msg_pub.count_and_get(

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);
1014: log(x_msg_data);

Line 1019: FND_MSG_PUB.ADD;

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(
1021: p_encoded => FND_API.G_FALSE,
1022: p_count => x_msg_count,
1023: p_data => x_msg_data);

Line 1020: FND_MSG_PUB.Count_And_Get(

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(
1021: p_encoded => FND_API.G_FALSE,
1022: p_count => x_msg_count,
1023: p_data => x_msg_data);
1024: log(x_msg_data);

Line 1080: FND_MSG_PUB.ADD;

1076: l_text := ' There is at least one bill not posted and does not have a xla distribution paired.
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

Line 1089: fnd_msg_pub.count_and_get(

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);
1093: log(x_msg_data);

Line 1098: FND_MSG_PUB.ADD;

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(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);

Line 1099: FND_MSG_PUB.Count_And_Get(

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(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);
1103: log(x_msg_data);

Line 1149: fnd_msg_pub.initialize;

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;
1153: END IF;

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 1564: FND_MSG_PUB.ADD; --BUG#5386043

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;
1566: CLOSE c_verif_date;
1567:
1568: IF x_return_status <> FND_API.g_ret_sts_success THEN

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);