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.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on FND_MSG_PUB

Line 110: fnd_msg_pub.initialize;

106: BEGIN
107:
108: --Initialize message list if p_init_msg_list is set to TRUE.
109: IF fnd_api.to_boolean(p_init_msg_list) THEN
110: fnd_msg_pub.initialize;
111: END IF;
112:
113: --Initialize API return status to success.
114: x_return_status := fnd_api.g_ret_sts_success;

Line 121: fnd_msg_pub.add;

117: IF p_party_id IS NULL OR
118: p_party_id = fnd_api.g_miss_num THEN
119: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
120: fnd_message.set_token( 'COLUMN', 'party_id' );
121: fnd_msg_pub.add;
122: RAISE fnd_api.g_exc_error;
123: END IF;
124:
125: x_party_rec.party_id := p_party_id;

Line 214: FND_MSG_PUB.Count_And_Get(

210: X_APPLICATION_ID => l_application_id
211: );
212:
213: --Standard call to get message count and if count is 1, get message info.
214: FND_MSG_PUB.Count_And_Get(
215: p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data );
218:

Line 223: FND_MSG_PUB.Count_And_Get(

219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222:
223: FND_MSG_PUB.Count_And_Get(
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data );
227:

Line 231: FND_MSG_PUB.Count_And_Get(

227:
228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: FND_MSG_PUB.Count_And_Get(
232: p_encoded => FND_API.G_FALSE,
233: p_count => x_msg_count,
234: p_data => x_msg_data );
235:

Line 241: fnd_msg_pub.add;

237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
240: fnd_message.set_token( 'ERROR' ,SQLERRM );
241: fnd_msg_pub.add;
242:
243: FND_MSG_PUB.Count_And_Get(
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,

Line 243: FND_MSG_PUB.Count_And_Get(

239: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
240: fnd_message.set_token( 'ERROR' ,SQLERRM );
241: fnd_msg_pub.add;
242:
243: FND_MSG_PUB.Count_And_Get(
244: p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data );
247:

Line 1128: FND_MSG_PUB.initialize;

1124: SAVEPOINT create_relationship;
1125:
1126: -- Initialize message list if p_init_msg_list is set to TRUE.
1127: IF FND_API.to_Boolean(p_init_msg_list) THEN
1128: FND_MSG_PUB.initialize;
1129: END IF;
1130:
1131: -- Initialize API return status to success.
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1176: FND_MSG_PUB.Count_And_Get(

1172: END IF;
1173: END IF;
1174:
1175: -- Standard call to get message count and if count is 1, get message info.
1176: FND_MSG_PUB.Count_And_Get(
1177: p_encoded => FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data);
1180:

Line 1185: FND_MSG_PUB.Count_And_Get(

1181: EXCEPTION
1182: WHEN FND_API.G_EXC_ERROR THEN
1183: ROLLBACK TO create_relationship;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: FND_MSG_PUB.Count_And_Get(
1186: p_encoded => FND_API.G_FALSE,
1187: p_count => x_msg_count,
1188: p_data => x_msg_data);
1189:

Line 1194: FND_MSG_PUB.Count_And_Get(

1190:
1191: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1192: ROLLBACK TO create_relationship;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: FND_MSG_PUB.Count_And_Get(
1195: p_encoded => FND_API.G_FALSE,
1196: p_count => x_msg_count,
1197: p_data => x_msg_data);
1198:

Line 1204: fnd_msg_pub.add;

1200: ROLLBACK TO create_relationship;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1203: fnd_message.set_token('ERROR' ,SQLERRM);
1204: fnd_msg_pub.add;
1205: FND_MSG_PUB.Count_And_Get(
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data);

Line 1205: FND_MSG_PUB.Count_And_Get(

1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1203: fnd_message.set_token('ERROR' ,SQLERRM);
1204: fnd_msg_pub.add;
1205: FND_MSG_PUB.Count_And_Get(
1206: p_encoded => FND_API.G_FALSE,
1207: p_count => x_msg_count,
1208: p_data => x_msg_data);
1209:

Line 1231: FND_MSG_PUB.initialize;

1227: BEGIN
1228:
1229: --Initialize message list if p_init_msg_list is set to TRUE.
1230: IF FND_API.to_Boolean(p_init_msg_list) THEN
1231: FND_MSG_PUB.initialize;
1232: END IF;
1233:
1234: --Initialize API return status to success.
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1242: fnd_msg_pub.add;

1238: IF p_relationship_id IS NULL OR
1239: p_relationship_id = FND_API.G_MISS_NUM THEN
1240: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
1241: fnd_message.set_token( 'COLUMN', 'relationship_id' );
1242: fnd_msg_pub.add;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245:
1246: x_rel_rec.relationship_id := p_relationship_id;

Line 1352: FND_MSG_PUB.Count_And_Get(

1348: END IF;
1349: END IF;
1350:
1351: --Standard call to get message count and if count is 1, get message info.
1352: FND_MSG_PUB.Count_And_Get(
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data );
1356:

Line 1361: FND_MSG_PUB.Count_And_Get(

1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: x_return_status := FND_API.G_RET_STS_ERROR;
1360:
1361: FND_MSG_PUB.Count_And_Get(
1362: p_encoded => FND_API.G_FALSE,
1363: p_count => x_msg_count,
1364: p_data => x_msg_data );
1365:

Line 1369: FND_MSG_PUB.Count_And_Get(

1365:
1366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368:
1369: FND_MSG_PUB.Count_And_Get(
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,
1372: p_data => x_msg_data );
1373:

Line 1379: fnd_msg_pub.add;

1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1376:
1377: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1378: fnd_message.set_token( 'ERROR' ,SQLERRM );
1379: fnd_msg_pub.add;
1380:
1381: FND_MSG_PUB.Count_And_Get(
1382: p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,

Line 1381: FND_MSG_PUB.Count_And_Get(

1377: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1378: fnd_message.set_token( 'ERROR' ,SQLERRM );
1379: fnd_msg_pub.add;
1380:
1381: FND_MSG_PUB.Count_And_Get(
1382: p_encoded => FND_API.G_FALSE,
1383: p_count => x_msg_count,
1384: p_data => x_msg_data );
1385:

Line 1565: FND_MSG_PUB.Count_And_Get(

1561: -- Call to indicate Org Contact creation to DQM
1562: HZ_DQM_SYNC.sync_contact(l_org_contact_rec.org_contact_id, 'C');
1563:
1564: -- standard call to get message count and if count is 1, get message info.
1565: FND_MSG_PUB.Count_And_Get(
1566: p_encoded => FND_API.G_FALSE,
1567: p_count => x_msg_count,
1568: p_data => x_msg_data);
1569:

Line 1575: FND_MSG_PUB.Count_And_Get(

1571: EXCEPTION
1572: WHEN FND_API.G_EXC_ERROR THEN
1573: ROLLBACK TO create_org_contact;
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MSG_PUB.Count_And_Get(
1576: p_encoded => FND_API.G_FALSE,
1577: p_count => x_msg_count,
1578: p_data => x_msg_data);
1579:

Line 1584: FND_MSG_PUB.Count_And_Get(

1580:
1581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1582: ROLLBACK TO create_org_contact;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: FND_MSG_PUB.Count_And_Get(
1585: p_encoded => FND_API.G_FALSE,
1586: p_count => x_msg_count,
1587: p_data => x_msg_data);
1588:

Line 1595: fnd_msg_pub.add;

1591: ROLLBACK TO create_org_contact;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1594: fnd_message.set_token('ERROR' ,SQLERRM);
1595: fnd_msg_pub.add;
1596: FND_MSG_PUB.Count_And_Get(
1597: p_encoded => FND_API.G_FALSE,
1598: p_count => x_msg_count,
1599: p_data => x_msg_data);

Line 1596: FND_MSG_PUB.Count_And_Get(

1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1594: fnd_message.set_token('ERROR' ,SQLERRM);
1595: fnd_msg_pub.add;
1596: FND_MSG_PUB.Count_And_Get(
1597: p_encoded => FND_API.G_FALSE,
1598: p_count => x_msg_count,
1599: p_data => x_msg_data);
1600:

Line 1622: FND_MSG_PUB.initialize;

1618: BEGIN
1619:
1620: --Initialize message list if p_init_msg_list is set to TRUE.
1621: IF FND_API.to_Boolean(p_init_msg_list) THEN
1622: FND_MSG_PUB.initialize;
1623: END IF;
1624:
1625: --Initialize API return status to success.
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1632: fnd_msg_pub.add;

1628: IF p_org_contact_id IS NULL OR
1629: p_org_contact_id = FND_API.G_MISS_NUM THEN
1630: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
1631: fnd_message.set_token( 'COLUMN', 'org_contact_id' );
1632: fnd_msg_pub.add;
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: x_org_contact_rec.org_contact_id := p_org_contact_id;

Line 1705: FND_MSG_PUB.Count_And_Get(

1701: END IF;
1702: END IF;
1703:
1704: --Standard call to get message count and if count is 1, get message info.
1705: FND_MSG_PUB.Count_And_Get(
1706: p_encoded => FND_API.G_FALSE,
1707: p_count => x_msg_count,
1708: p_data => x_msg_data );
1709:

Line 1714: FND_MSG_PUB.Count_And_Get(

1710: EXCEPTION
1711: WHEN FND_API.G_EXC_ERROR THEN
1712: x_return_status := FND_API.G_RET_STS_ERROR;
1713:
1714: FND_MSG_PUB.Count_And_Get(
1715: p_encoded => FND_API.G_FALSE,
1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:

Line 1722: FND_MSG_PUB.Count_And_Get(

1718:
1719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1721:
1722: FND_MSG_PUB.Count_And_Get(
1723: p_encoded => FND_API.G_FALSE,
1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726:

Line 1731: fnd_msg_pub.add;

1727: WHEN OTHERS THEN
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1730: fnd_message.set_token( 'ERROR' ,SQLERRM );
1731: fnd_msg_pub.add;
1732: FND_MSG_PUB.Count_And_Get(
1733: p_encoded => FND_API.G_FALSE,
1734: p_count => x_msg_count,
1735: p_data => x_msg_data );

Line 1732: FND_MSG_PUB.Count_And_Get(

1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1729: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
1730: fnd_message.set_token( 'ERROR' ,SQLERRM );
1731: fnd_msg_pub.add;
1732: FND_MSG_PUB.Count_And_Get(
1733: p_encoded => FND_API.G_FALSE,
1734: p_count => x_msg_count,
1735: p_data => x_msg_data );
1736:

Line 2098: FND_MSG_PUB.initialize;

2094: SAVEPOINT create_party_site;
2095:
2096: -- initialize message list if p_init_msg_list is set to TRUE.
2097: IF FND_API.to_Boolean(p_init_msg_list) THEN
2098: FND_MSG_PUB.initialize;
2099: END IF;
2100:
2101: -- initialize API return status to success.
2102: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2136: FND_MSG_PUB.Count_And_Get(

2132: -- Call to indicate Party Site creation to DQM
2133: HZ_DQM_SYNC.sync_party_site(l_party_site_rec.party_site_id,'C');
2134:
2135: -- standard call to get message count and if count is 1, get message info.
2136: FND_MSG_PUB.Count_And_Get(
2137: p_encoded => FND_API.G_FALSE,
2138: p_count => x_msg_count,
2139: p_data => x_msg_data);
2140:

Line 2145: FND_MSG_PUB.Count_And_Get(

2141: EXCEPTION
2142: WHEN FND_API.G_EXC_ERROR THEN
2143: ROLLBACK TO create_party_site;
2144: x_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MSG_PUB.Count_And_Get(
2146: p_encoded => FND_API.G_FALSE,
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:

Line 2153: FND_MSG_PUB.Count_And_Get(

2149:
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: ROLLBACK TO create_party_site;
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2153: FND_MSG_PUB.Count_And_Get(
2154: p_encoded => FND_API.G_FALSE,
2155: p_count => x_msg_count,
2156: p_data => x_msg_data);
2157: WHEN OTHERS THEN

Line 2162: fnd_msg_pub.add;

2158: ROLLBACK TO create_party_site;
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2161: fnd_message.set_token('ERROR' ,SQLERRM);
2162: fnd_msg_pub.add;
2163: FND_MSG_PUB.Count_And_Get(
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data);

Line 2163: FND_MSG_PUB.Count_And_Get(

2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2160: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2161: fnd_message.set_token('ERROR' ,SQLERRM);
2162: fnd_msg_pub.add;
2163: FND_MSG_PUB.Count_And_Get(
2164: p_encoded => FND_API.G_FALSE,
2165: p_count => x_msg_count,
2166: p_data => x_msg_data);
2167:

Line 2189: FND_MSG_PUB.initialize;

2185: BEGIN
2186:
2187: --Initialize message list if p_init_msg_list is set to TRUE.
2188: IF FND_API.to_Boolean(p_init_msg_list) THEN
2189: FND_MSG_PUB.initialize;
2190: END IF;
2191:
2192: --Initialize API return status to success.
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2200: fnd_msg_pub.add;

2196: IF p_party_site_id IS NULL OR
2197: p_party_site_id = FND_API.G_MISS_NUM THEN
2198: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
2199: fnd_message.set_token( 'COLUMN', 'party_site_id' );
2200: fnd_msg_pub.add;
2201: RAISE FND_API.G_EXC_ERROR;
2202: END IF;
2203:
2204: x_party_site_rec.party_site_id := p_party_site_id;

Line 2247: FND_MSG_PUB.Count_And_Get(

2243: X_DUNS_NUMBER_C => x_party_site_rec.duns_number_c
2244: );
2245:
2246: --Standard call to get message count and if count is 1, get message info.
2247: FND_MSG_PUB.Count_And_Get(
2248: p_encoded => FND_API.G_FALSE,
2249: p_count => x_msg_count,
2250: p_data => x_msg_data );
2251:

Line 2256: FND_MSG_PUB.Count_And_Get(

2252: EXCEPTION
2253: WHEN FND_API.G_EXC_ERROR THEN
2254: x_return_status := FND_API.G_RET_STS_ERROR;
2255:
2256: FND_MSG_PUB.Count_And_Get(
2257: p_encoded => FND_API.G_FALSE,
2258: p_count => x_msg_count,
2259: p_data => x_msg_data );
2260:

Line 2264: FND_MSG_PUB.Count_And_Get(

2260:
2261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2263:
2264: FND_MSG_PUB.Count_And_Get(
2265: p_encoded => FND_API.G_FALSE,
2266: p_count => x_msg_count,
2267: p_data => x_msg_data );
2268:

Line 2273: fnd_msg_pub.add;

2269: WHEN OTHERS THEN
2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2272: fnd_message.set_token( 'ERROR' ,SQLERRM );
2273: fnd_msg_pub.add;
2274: FND_MSG_PUB.Count_And_Get(
2275: p_encoded => FND_API.G_FALSE,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data );

Line 2274: FND_MSG_PUB.Count_And_Get(

2270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2272: fnd_message.set_token( 'ERROR' ,SQLERRM );
2273: fnd_msg_pub.add;
2274: FND_MSG_PUB.Count_And_Get(
2275: p_encoded => FND_API.G_FALSE,
2276: p_count => x_msg_count,
2277: p_data => x_msg_data );
2278:

Line 2683: FND_MSG_PUB.initialize;

2679:
2680:
2681: -- Initialize message list if p_init_msg_list is set to TRUE.
2682: IF FND_API.to_Boolean(p_init_msg_list) THEN
2683: FND_MSG_PUB.initialize;
2684: END IF;
2685:
2686: -- Initialize API return status to success.
2687: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2705: FND_MSG_PUB.Count_And_Get(

2701: END IF;
2702: END IF;
2703:
2704: -- Standard call to get message count and if count is 1, get message info.
2705: FND_MSG_PUB.Count_And_Get(
2706: p_encoded => FND_API.G_FALSE,
2707: p_count => x_msg_count,
2708: p_data => x_msg_data );
2709:

Line 2716: FND_MSG_PUB.Count_And_Get(

2712: WHEN FND_API.G_EXC_ERROR THEN
2713: ROLLBACK TO create_cust_acct_site;
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715:
2716: FND_MSG_PUB.Count_And_Get(
2717: p_encoded => FND_API.G_FALSE,
2718: p_count => x_msg_count,
2719: p_data => x_msg_data );
2720:

Line 2726: FND_MSG_PUB.Count_And_Get(

2722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2723: ROLLBACK TO create_cust_acct_site;
2724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2725:
2726: FND_MSG_PUB.Count_And_Get(
2727: p_encoded => FND_API.G_FALSE,
2728: p_count => x_msg_count,
2729: p_data => x_msg_data );
2730:

Line 2737: fnd_msg_pub.add;

2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734:
2735: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2736: fnd_message.set_token( 'ERROR' ,SQLERRM );
2737: fnd_msg_pub.add;
2738:
2739: FND_MSG_PUB.Count_And_Get(
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,

Line 2739: FND_MSG_PUB.Count_And_Get(

2735: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2736: fnd_message.set_token( 'ERROR' ,SQLERRM );
2737: fnd_msg_pub.add;
2738:
2739: FND_MSG_PUB.Count_And_Get(
2740: p_encoded => FND_API.G_FALSE,
2741: p_count => x_msg_count,
2742: p_data => x_msg_data );
2743:

Line 2772: FND_MSG_PUB.initialize;

2768: SAVEPOINT create_cust_site_use;
2769:
2770: -- Initialize message list if p_init_msg_list is set to TRUE.
2771: IF FND_API.to_Boolean(p_init_msg_list) THEN
2772: FND_MSG_PUB.initialize;
2773: END IF;
2774:
2775: -- Initialize API return status to success.
2776: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2800: FND_MSG_PUB.Count_And_Get(

2796: END IF;
2797: END IF;
2798:
2799: -- Standard call to get message count and if count is 1, get message info.
2800: FND_MSG_PUB.Count_And_Get(
2801: p_encoded => FND_API.G_FALSE,
2802: p_count => x_msg_count,
2803: p_data => x_msg_data );
2804:

Line 2810: FND_MSG_PUB.Count_And_Get(

2806: WHEN FND_API.G_EXC_ERROR THEN
2807: ROLLBACK TO create_cust_site_use;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: FND_MSG_PUB.Count_And_Get(
2811: p_encoded => FND_API.G_FALSE,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data );
2814:

Line 2819: FND_MSG_PUB.Count_And_Get(

2815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2816: ROLLBACK TO create_cust_site_use;
2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818:
2819: FND_MSG_PUB.Count_And_Get(
2820: p_encoded => FND_API.G_FALSE,
2821: p_count => x_msg_count,
2822: p_data => x_msg_data );
2823:

Line 2831: fnd_msg_pub.add;

2827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2828:
2829: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2830: fnd_message.set_token( 'ERROR' ,SQLERRM );
2831: fnd_msg_pub.add;
2832:
2833: FND_MSG_PUB.Count_And_Get(
2834: p_encoded => FND_API.G_FALSE,
2835: p_count => x_msg_count,

Line 2833: FND_MSG_PUB.Count_And_Get(

2829: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2830: fnd_message.set_token( 'ERROR' ,SQLERRM );
2831: fnd_msg_pub.add;
2832:
2833: FND_MSG_PUB.Count_And_Get(
2834: p_encoded => FND_API.G_FALSE,
2835: p_count => x_msg_count,
2836: p_data => x_msg_data );
2837:

Line 3139: FND_MSG_PUB.initialize;

3135:
3136:
3137: -- Initialize message list if p_init_msg_list is set to TRUE.
3138: IF FND_API.to_Boolean(p_init_msg_list) THEN
3139: FND_MSG_PUB.initialize;
3140: END IF;
3141:
3142: -- Initialize API return status to success.
3143: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3162: FND_MSG_PUB.Count_And_Get(

3158: END IF;
3159: END IF;
3160:
3161: -- Standard call to get message count and if count is 1, get message info.
3162: FND_MSG_PUB.Count_And_Get(
3163: p_encoded => FND_API.G_FALSE,
3164: p_count => x_msg_count,
3165: p_data => x_msg_data );
3166:

Line 3173: FND_MSG_PUB.Count_And_Get(

3169: WHEN FND_API.G_EXC_ERROR THEN
3170: ROLLBACK TO create_customer_profile;
3171: x_return_status := FND_API.G_RET_STS_ERROR;
3172:
3173: FND_MSG_PUB.Count_And_Get(
3174: p_encoded => FND_API.G_FALSE,
3175: p_count => x_msg_count,
3176: p_data => x_msg_data );
3177:

Line 3183: FND_MSG_PUB.Count_And_Get(

3179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3180: ROLLBACK TO create_customer_profile;
3181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3182:
3183: FND_MSG_PUB.Count_And_Get(
3184: p_encoded => FND_API.G_FALSE,
3185: p_count => x_msg_count,
3186: p_data => x_msg_data );
3187:

Line 3195: fnd_msg_pub.add;

3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3192:
3193: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3194: fnd_message.set_token( 'ERROR' ,SQLERRM );
3195: fnd_msg_pub.add;
3196:
3197: FND_MSG_PUB.Count_And_Get(
3198: p_encoded => FND_API.G_FALSE,
3199: p_count => x_msg_count,

Line 3197: FND_MSG_PUB.Count_And_Get(

3193: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3194: fnd_message.set_token( 'ERROR' ,SQLERRM );
3195: fnd_msg_pub.add;
3196:
3197: FND_MSG_PUB.Count_And_Get(
3198: p_encoded => FND_API.G_FALSE,
3199: p_count => x_msg_count,
3200: p_data => x_msg_data );
3201:

Line 3227: FND_MSG_PUB.initialize;

3223: SAVEPOINT create_cust_profile_amt;
3224:
3225: -- Initialize message list if p_init_msg_list is set to TRUE.
3226: IF FND_API.to_Boolean(p_init_msg_list) THEN
3227: FND_MSG_PUB.initialize;
3228: END IF;
3229:
3230: -- Initialize API return status to success.
3231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3249: FND_MSG_PUB.Count_And_Get(

3245: END IF;
3246: END IF;
3247:
3248: -- Standard call to get message count and if count is 1, get message info.
3249: FND_MSG_PUB.Count_And_Get(
3250: p_encoded => FND_API.G_FALSE,
3251: p_count => x_msg_count,
3252: p_data => x_msg_data );
3253:

Line 3260: FND_MSG_PUB.Count_And_Get(

3256: WHEN FND_API.G_EXC_ERROR THEN
3257: ROLLBACK TO create_cust_profile_amt;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_And_Get(
3261: p_encoded => FND_API.G_FALSE,
3262: p_count => x_msg_count,
3263: p_data => x_msg_data );
3264:

Line 3269: FND_MSG_PUB.Count_And_Get(

3265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3266: ROLLBACK TO create_cust_profile_amt;
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268:
3269: FND_MSG_PUB.Count_And_Get(
3270: p_encoded => FND_API.G_FALSE,
3271: p_count => x_msg_count,
3272: p_data => x_msg_data );
3273:

Line 3280: fnd_msg_pub.add;

3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3277:
3278: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3279: fnd_message.set_token( 'ERROR' ,SQLERRM );
3280: fnd_msg_pub.add;
3281:
3282: FND_MSG_PUB.Count_And_Get(
3283: p_encoded => FND_API.G_FALSE,
3284: p_count => x_msg_count,

Line 3282: FND_MSG_PUB.Count_And_Get(

3278: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3279: fnd_message.set_token( 'ERROR' ,SQLERRM );
3280: fnd_msg_pub.add;
3281:
3282: FND_MSG_PUB.Count_And_Get(
3283: p_encoded => FND_API.G_FALSE,
3284: p_count => x_msg_count,
3285: p_data => x_msg_data );
3286:

Line 3793: fnd_msg_pub.count_and_get(

3789: -- Call to indicate contact point creation to DQM
3790: hz_dqm_sync.sync_contact_point(l_contact_point_rec.contact_point_id, 'C');
3791:
3792: -- Standard call to get message count and if count is 1, get message info.
3793: fnd_msg_pub.count_and_get(
3794: p_encoded => fnd_api.g_false,
3795: p_count => x_msg_count,
3796: p_data => x_msg_data);
3797:

Line 3804: fnd_msg_pub.count_and_get(

3800: WHEN fnd_api.g_exc_error THEN
3801: ROLLBACK TO create_contact_point;
3802: x_return_status := fnd_api.g_ret_sts_error;
3803:
3804: fnd_msg_pub.count_and_get(
3805: p_encoded => fnd_api.g_false,
3806: p_count => x_msg_count,
3807: p_data => x_msg_data);
3808:

Line 3813: fnd_msg_pub.count_and_get(

3809: WHEN fnd_api.g_exc_unexpected_error THEN
3810: ROLLBACK TO create_contact_point;
3811: x_return_status := fnd_api.g_ret_sts_unexp_error;
3812:
3813: fnd_msg_pub.count_and_get(
3814: p_encoded => fnd_api.g_false,
3815: p_count => x_msg_count,
3816: p_data => x_msg_data);
3817:

Line 3824: fnd_msg_pub.add;

3820: x_return_status := fnd_api.g_ret_sts_unexp_error;
3821:
3822: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3823: fnd_message.set_token('ERROR' ,SQLERRM);
3824: fnd_msg_pub.add;
3825:
3826: fnd_msg_pub.count_and_get(
3827: p_encoded => fnd_api.g_false,
3828: p_count => x_msg_count,

Line 3826: fnd_msg_pub.count_and_get(

3822: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3823: fnd_message.set_token('ERROR' ,SQLERRM);
3824: fnd_msg_pub.add;
3825:
3826: fnd_msg_pub.count_and_get(
3827: p_encoded => fnd_api.g_false,
3828: p_count => x_msg_count,
3829: p_data => x_msg_data);
3830:

Line 3861: fnd_msg_pub.add;

3857: IF p_contact_point_id IS NULL OR
3858: p_contact_point_id = FND_API.G_MISS_NUM THEN
3859: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
3860: fnd_message.set_token('COLUMN', 'contact_point_id');
3861: fnd_msg_pub.add;
3862: RAISE fnd_api.g_exc_error;
3863: END IF;
3864:
3865: x_contact_point_rec.contact_point_id := p_contact_point_id;

Line 3934: fnd_msg_pub.count_and_get(

3930: );
3931:
3932:
3933: -- Standard call to get message count and if count is 1, get message info.
3934: fnd_msg_pub.count_and_get(
3935: p_encoded => fnd_api.g_false,
3936: p_count => x_msg_count,
3937: p_data => x_msg_data);
3938:

Line 3943: fnd_msg_pub.count_and_get(

3939: EXCEPTION
3940: WHEN fnd_api.g_exc_error THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942:
3943: fnd_msg_pub.count_and_get(
3944: p_encoded => fnd_api.g_false,
3945: p_count => x_msg_count,
3946: p_data => x_msg_data);
3947:

Line 3951: fnd_msg_pub.count_and_get(

3947:
3948: WHEN fnd_api.g_exc_unexpected_error THEN
3949: x_return_status := fnd_api.g_ret_sts_unexp_error;
3950:
3951: fnd_msg_pub.count_and_get(
3952: p_encoded => fnd_api.g_false,
3953: p_count => x_msg_count,
3954: p_data => x_msg_data);
3955:

Line 3961: fnd_msg_pub.add;

3957: x_return_status := fnd_api.g_ret_sts_unexp_error;
3958:
3959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3960: fnd_message.set_token('ERROR' ,SQLERRM);
3961: fnd_msg_pub.add;
3962:
3963: fnd_msg_pub.count_and_get(
3964: p_encoded => fnd_api.g_false,
3965: p_count => x_msg_count,

Line 3963: fnd_msg_pub.count_and_get(

3959: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3960: fnd_message.set_token('ERROR' ,SQLERRM);
3961: fnd_msg_pub.add;
3962:
3963: fnd_msg_pub.count_and_get(
3964: p_encoded => fnd_api.g_false,
3965: p_count => x_msg_count,
3966: p_data => x_msg_data);
3967:

Line 4018: FND_MSG_PUB.initialize;

4014: BEGIN
4015:
4016: --Initialize message list if p_init_msg_list is set to TRUE.
4017: IF FND_API.to_Boolean(p_init_msg_list) THEN
4018: FND_MSG_PUB.initialize;
4019: END IF;
4020:
4021: --Initialize API return status to success.
4022: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4029: FND_MSG_PUB.ADD;

4025: IF p_party_site_use_id IS NULL OR
4026: p_party_site_use_id = FND_API.G_MISS_NUM THEN
4027: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
4028: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
4029: FND_MSG_PUB.ADD;
4030: RAISE FND_API.G_EXC_ERROR;
4031: END IF;
4032:
4033: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;

Line 4047: FND_MSG_PUB.Count_And_Get(

4043: X_APPLICATION_ID => x_party_site_use_rec.application_id
4044: );
4045:
4046: --Standard call to get message count and if count is 1, get message info.
4047: FND_MSG_PUB.Count_And_Get(
4048: p_encoded => FND_API.G_FALSE,
4049: p_count => x_msg_count,
4050: p_data => x_msg_data );
4051:

Line 4056: FND_MSG_PUB.Count_And_Get(

4052: EXCEPTION
4053: WHEN FND_API.G_EXC_ERROR THEN
4054: x_return_status := FND_API.G_RET_STS_ERROR;
4055:
4056: FND_MSG_PUB.Count_And_Get(
4057: p_encoded => FND_API.G_FALSE,
4058: p_count => x_msg_count,
4059: p_data => x_msg_data );
4060:

Line 4064: FND_MSG_PUB.Count_And_Get(

4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063:
4064: FND_MSG_PUB.Count_And_Get(
4065: p_encoded => FND_API.G_FALSE,
4066: p_count => x_msg_count,
4067: p_data => x_msg_data );
4068:

Line 4073: FND_MSG_PUB.ADD;

4069: WHEN OTHERS THEN
4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
4072: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
4073: FND_MSG_PUB.ADD;
4074: FND_MSG_PUB.Count_And_Get(
4075: p_encoded => FND_API.G_FALSE,
4076: p_count => x_msg_count,
4077: p_data => x_msg_data );

Line 4074: FND_MSG_PUB.Count_And_Get(

4070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
4072: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
4073: FND_MSG_PUB.ADD;
4074: FND_MSG_PUB.Count_And_Get(
4075: p_encoded => FND_API.G_FALSE,
4076: p_count => x_msg_count,
4077: p_data => x_msg_data );
4078:

Line 4146: FND_MSG_PUB.ADD;

4142: EXCEPTION
4143: WHEN OTHERS THEN
4144: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
4145: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
4146: FND_MSG_PUB.ADD;
4147: RAISE FND_API.G_EXC_ERROR;
4148: END;
4149:
4150: IF l_rowid IS NOT NULL THEN

Line 4309: FND_MSG_PUB.initialize;

4305: SAVEPOINT create_party_site_use;
4306:
4307: -- initialize message list if p_init_msg_list is set to TRUE.
4308: IF FND_API.to_Boolean(p_init_msg_list) THEN
4309: FND_MSG_PUB.initialize;
4310: END IF;
4311:
4312: -- initialize API return status to success.
4313: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4331: FND_MSG_PUB.Count_And_Get(

4327: END IF;
4328: END IF;
4329:
4330: -- standard call to get message count and if count is 1, get message info.
4331: FND_MSG_PUB.Count_And_Get(
4332: p_encoded => FND_API.G_FALSE,
4333: p_count => x_msg_count,
4334: p_data => x_msg_data);
4335:

Line 4341: FND_MSG_PUB.Count_And_Get(

4337: EXCEPTION
4338: WHEN FND_API.G_EXC_ERROR THEN
4339: ROLLBACK TO create_party_site_use;
4340: x_return_status := FND_API.G_RET_STS_ERROR;
4341: FND_MSG_PUB.Count_And_Get(
4342: p_encoded => FND_API.G_FALSE,
4343: p_count => x_msg_count,
4344: p_data => x_msg_data);
4345:

Line 4349: FND_MSG_PUB.Count_And_Get(

4345:
4346: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4347: ROLLBACK TO create_party_site_use;
4348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4349: FND_MSG_PUB.Count_And_Get(
4350: p_encoded => FND_API.G_FALSE,
4351: p_count => x_msg_count,
4352: p_data => x_msg_data);
4353:

Line 4359: FND_MSG_PUB.ADD;

4355: ROLLBACK TO create_party_site_use;
4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4357: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4358: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4359: FND_MSG_PUB.ADD;
4360: FND_MSG_PUB.Count_And_Get(
4361: p_encoded => FND_API.G_FALSE,
4362: p_count => x_msg_count,
4363: p_data => x_msg_data);

Line 4360: FND_MSG_PUB.Count_And_Get(

4356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4357: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4358: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4359: FND_MSG_PUB.ADD;
4360: FND_MSG_PUB.Count_And_Get(
4361: p_encoded => FND_API.G_FALSE,
4362: p_count => x_msg_count,
4363: p_data => x_msg_data);
4364: