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

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

Line 92: FND_MSG_PUB.ADD;

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

Line 103: FND_MSG_PUB.ADD;

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

Line 111: FND_MSG_PUB.ADD;

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

Line 119: FND_MSG_PUB.ADD;

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

Line 576: FND_MSG_PUB.initialize;

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

Line 587: FND_MSG_PUB.ADD;

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

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

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

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

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

Line 713: fnd_msg_pub.count_and_get(

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

Line 722: FND_MSG_PUB.ADD;

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

Line 723: FND_MSG_PUB.Count_And_Get(

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

Line 807: FND_MSG_PUB.ADD;

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

Line 816: fnd_msg_pub.count_and_get(

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

Line 825: FND_MSG_PUB.ADD;

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

Line 826: FND_MSG_PUB.Count_And_Get(

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

Line 901: FND_MSG_PUB.ADD;

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

Line 910: fnd_msg_pub.count_and_get(

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

Line 919: FND_MSG_PUB.ADD;

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

Line 920: FND_MSG_PUB.Count_And_Get(

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

Line 999: FND_MSG_PUB.ADD;

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

Line 1008: fnd_msg_pub.count_and_get(

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

Line 1017: FND_MSG_PUB.ADD;

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

Line 1018: FND_MSG_PUB.Count_And_Get(

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

Line 1078: FND_MSG_PUB.ADD;

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

Line 1087: fnd_msg_pub.count_and_get(

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

Line 1096: FND_MSG_PUB.ADD;

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

Line 1097: FND_MSG_PUB.Count_And_Get(

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

Line 1147: fnd_msg_pub.initialize;

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

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

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

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