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 1174: FND_MSG_PUB.Count_And_Get(

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

Line 1183: FND_MSG_PUB.Count_And_Get(

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

Line 1192: FND_MSG_PUB.Count_And_Get(

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

Line 1202: fnd_msg_pub.add;

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

Line 1203: FND_MSG_PUB.Count_And_Get(

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

Line 1229: FND_MSG_PUB.initialize;

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

Line 1240: fnd_msg_pub.add;

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

Line 1350: FND_MSG_PUB.Count_And_Get(

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

Line 1359: FND_MSG_PUB.Count_And_Get(

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

Line 1367: FND_MSG_PUB.Count_And_Get(

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

Line 1377: fnd_msg_pub.add;

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

Line 1379: FND_MSG_PUB.Count_And_Get(

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

Line 1561: FND_MSG_PUB.Count_And_Get(

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

Line 1571: FND_MSG_PUB.Count_And_Get(

1567: EXCEPTION
1568: WHEN FND_API.G_EXC_ERROR THEN
1569: ROLLBACK TO create_org_contact;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: FND_MSG_PUB.Count_And_Get(
1572: p_encoded => FND_API.G_FALSE,
1573: p_count => x_msg_count,
1574: p_data => x_msg_data);
1575:

Line 1580: FND_MSG_PUB.Count_And_Get(

1576:
1577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1578: ROLLBACK TO create_org_contact;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: FND_MSG_PUB.Count_And_Get(
1581: p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data);
1584:

Line 1591: fnd_msg_pub.add;

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

Line 1592: FND_MSG_PUB.Count_And_Get(

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

Line 1618: FND_MSG_PUB.initialize;

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

Line 1628: fnd_msg_pub.add;

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

Line 1701: FND_MSG_PUB.Count_And_Get(

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

Line 1710: FND_MSG_PUB.Count_And_Get(

1706: EXCEPTION
1707: WHEN FND_API.G_EXC_ERROR THEN
1708: x_return_status := FND_API.G_RET_STS_ERROR;
1709:
1710: FND_MSG_PUB.Count_And_Get(
1711: p_encoded => FND_API.G_FALSE,
1712: p_count => x_msg_count,
1713: p_data => x_msg_data );
1714:

Line 1718: FND_MSG_PUB.Count_And_Get(

1714:
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1717:
1718: FND_MSG_PUB.Count_And_Get(
1719: p_encoded => FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data );
1722:

Line 1727: fnd_msg_pub.add;

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

Line 1728: FND_MSG_PUB.Count_And_Get(

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

Line 2094: FND_MSG_PUB.initialize;

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

Line 2130: FND_MSG_PUB.Count_And_Get(

2126: -- Call to indicate Party Site creation to DQM
2127: HZ_DQM_SYNC.sync_party_site(l_party_site_rec.party_site_id,'C');
2128:
2129: -- standard call to get message count and if count is 1, get message info.
2130: FND_MSG_PUB.Count_And_Get(
2131: p_encoded => FND_API.G_FALSE,
2132: p_count => x_msg_count,
2133: p_data => x_msg_data);
2134:

Line 2139: FND_MSG_PUB.Count_And_Get(

2135: EXCEPTION
2136: WHEN FND_API.G_EXC_ERROR THEN
2137: ROLLBACK TO create_party_site;
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139: FND_MSG_PUB.Count_And_Get(
2140: p_encoded => FND_API.G_FALSE,
2141: p_count => x_msg_count,
2142: p_data => x_msg_data);
2143:

Line 2147: FND_MSG_PUB.Count_And_Get(

2143:
2144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2145: ROLLBACK TO create_party_site;
2146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2147: FND_MSG_PUB.Count_And_Get(
2148: p_encoded => FND_API.G_FALSE,
2149: p_count => x_msg_count,
2150: p_data => x_msg_data);
2151: WHEN OTHERS THEN

Line 2156: fnd_msg_pub.add;

2152: ROLLBACK TO create_party_site;
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2155: fnd_message.set_token('ERROR' ,SQLERRM);
2156: fnd_msg_pub.add;
2157: FND_MSG_PUB.Count_And_Get(
2158: p_encoded => FND_API.G_FALSE,
2159: p_count => x_msg_count,
2160: p_data => x_msg_data);

Line 2157: FND_MSG_PUB.Count_And_Get(

2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2155: fnd_message.set_token('ERROR' ,SQLERRM);
2156: fnd_msg_pub.add;
2157: FND_MSG_PUB.Count_And_Get(
2158: p_encoded => FND_API.G_FALSE,
2159: p_count => x_msg_count,
2160: p_data => x_msg_data);
2161:

Line 2183: FND_MSG_PUB.initialize;

2179: BEGIN
2180:
2181: --Initialize message list if p_init_msg_list is set to TRUE.
2182: IF FND_API.to_Boolean(p_init_msg_list) THEN
2183: FND_MSG_PUB.initialize;
2184: END IF;
2185:
2186: --Initialize API return status to success.
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2194: fnd_msg_pub.add;

2190: IF p_party_site_id IS NULL OR
2191: p_party_site_id = FND_API.G_MISS_NUM THEN
2192: fnd_message.set_name( 'AR', 'HZ_API_MISSING_COLUMN' );
2193: fnd_message.set_token( 'COLUMN', 'party_site_id' );
2194: fnd_msg_pub.add;
2195: RAISE FND_API.G_EXC_ERROR;
2196: END IF;
2197:
2198: x_party_site_rec.party_site_id := p_party_site_id;

Line 2241: FND_MSG_PUB.Count_And_Get(

2237: X_DUNS_NUMBER_C => x_party_site_rec.duns_number_c
2238: );
2239:
2240: --Standard call to get message count and if count is 1, get message info.
2241: FND_MSG_PUB.Count_And_Get(
2242: p_encoded => FND_API.G_FALSE,
2243: p_count => x_msg_count,
2244: p_data => x_msg_data );
2245:

Line 2250: FND_MSG_PUB.Count_And_Get(

2246: EXCEPTION
2247: WHEN FND_API.G_EXC_ERROR THEN
2248: x_return_status := FND_API.G_RET_STS_ERROR;
2249:
2250: FND_MSG_PUB.Count_And_Get(
2251: p_encoded => FND_API.G_FALSE,
2252: p_count => x_msg_count,
2253: p_data => x_msg_data );
2254:

Line 2258: FND_MSG_PUB.Count_And_Get(

2254:
2255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2257:
2258: FND_MSG_PUB.Count_And_Get(
2259: p_encoded => FND_API.G_FALSE,
2260: p_count => x_msg_count,
2261: p_data => x_msg_data );
2262:

Line 2267: fnd_msg_pub.add;

2263: WHEN OTHERS THEN
2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2266: fnd_message.set_token( 'ERROR' ,SQLERRM );
2267: fnd_msg_pub.add;
2268: FND_MSG_PUB.Count_And_Get(
2269: p_encoded => FND_API.G_FALSE,
2270: p_count => x_msg_count,
2271: p_data => x_msg_data );

Line 2268: FND_MSG_PUB.Count_And_Get(

2264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2266: fnd_message.set_token( 'ERROR' ,SQLERRM );
2267: fnd_msg_pub.add;
2268: FND_MSG_PUB.Count_And_Get(
2269: p_encoded => FND_API.G_FALSE,
2270: p_count => x_msg_count,
2271: p_data => x_msg_data );
2272:

Line 2677: FND_MSG_PUB.initialize;

2673:
2674:
2675: -- Initialize message list if p_init_msg_list is set to TRUE.
2676: IF FND_API.to_Boolean(p_init_msg_list) THEN
2677: FND_MSG_PUB.initialize;
2678: END IF;
2679:
2680: -- Initialize API return status to success.
2681: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2697: FND_MSG_PUB.Count_And_Get(

2693: l_cust_acct_site_rec );
2694: END IF;
2695:
2696: -- Standard call to get message count and if count is 1, get message info.
2697: FND_MSG_PUB.Count_And_Get(
2698: p_encoded => FND_API.G_FALSE,
2699: p_count => x_msg_count,
2700: p_data => x_msg_data );
2701:

Line 2708: FND_MSG_PUB.Count_And_Get(

2704: WHEN FND_API.G_EXC_ERROR THEN
2705: ROLLBACK TO create_cust_acct_site;
2706: x_return_status := FND_API.G_RET_STS_ERROR;
2707:
2708: FND_MSG_PUB.Count_And_Get(
2709: p_encoded => FND_API.G_FALSE,
2710: p_count => x_msg_count,
2711: p_data => x_msg_data );
2712:

Line 2718: FND_MSG_PUB.Count_And_Get(

2714: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2715: ROLLBACK TO create_cust_acct_site;
2716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2717:
2718: FND_MSG_PUB.Count_And_Get(
2719: p_encoded => FND_API.G_FALSE,
2720: p_count => x_msg_count,
2721: p_data => x_msg_data );
2722:

Line 2729: fnd_msg_pub.add;

2725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2726:
2727: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2728: fnd_message.set_token( 'ERROR' ,SQLERRM );
2729: fnd_msg_pub.add;
2730:
2731: FND_MSG_PUB.Count_And_Get(
2732: p_encoded => FND_API.G_FALSE,
2733: p_count => x_msg_count,

Line 2731: FND_MSG_PUB.Count_And_Get(

2727: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2728: fnd_message.set_token( 'ERROR' ,SQLERRM );
2729: fnd_msg_pub.add;
2730:
2731: FND_MSG_PUB.Count_And_Get(
2732: p_encoded => FND_API.G_FALSE,
2733: p_count => x_msg_count,
2734: p_data => x_msg_data );
2735:

Line 2764: FND_MSG_PUB.initialize;

2760: SAVEPOINT create_cust_site_use;
2761:
2762: -- Initialize message list if p_init_msg_list is set to TRUE.
2763: IF FND_API.to_Boolean(p_init_msg_list) THEN
2764: FND_MSG_PUB.initialize;
2765: END IF;
2766:
2767: -- Initialize API return status to success.
2768: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2790: FND_MSG_PUB.Count_And_Get(

2786: p_create_profile_amt );
2787: END IF;
2788:
2789: -- Standard call to get message count and if count is 1, get message info.
2790: FND_MSG_PUB.Count_And_Get(
2791: p_encoded => FND_API.G_FALSE,
2792: p_count => x_msg_count,
2793: p_data => x_msg_data );
2794:

Line 2800: FND_MSG_PUB.Count_And_Get(

2796: WHEN FND_API.G_EXC_ERROR THEN
2797: ROLLBACK TO create_cust_site_use;
2798: x_return_status := FND_API.G_RET_STS_ERROR;
2799:
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 2809: FND_MSG_PUB.Count_And_Get(

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

Line 2821: fnd_msg_pub.add;

2817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2818:
2819: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2820: fnd_message.set_token( 'ERROR' ,SQLERRM );
2821: fnd_msg_pub.add;
2822:
2823: FND_MSG_PUB.Count_And_Get(
2824: p_encoded => FND_API.G_FALSE,
2825: p_count => x_msg_count,

Line 2823: FND_MSG_PUB.Count_And_Get(

2819: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
2820: fnd_message.set_token( 'ERROR' ,SQLERRM );
2821: fnd_msg_pub.add;
2822:
2823: FND_MSG_PUB.Count_And_Get(
2824: p_encoded => FND_API.G_FALSE,
2825: p_count => x_msg_count,
2826: p_data => x_msg_data );
2827:

Line 3128: FND_MSG_PUB.initialize;

3124:
3125:
3126: -- Initialize message list if p_init_msg_list is set to TRUE.
3127: IF FND_API.to_Boolean(p_init_msg_list) THEN
3128: FND_MSG_PUB.initialize;
3129: END IF;
3130:
3131: -- Initialize API return status to success.
3132: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3149: FND_MSG_PUB.Count_And_Get(

3145: p_create_profile_amt );
3146: END IF;
3147:
3148: -- Standard call to get message count and if count is 1, get message info.
3149: FND_MSG_PUB.Count_And_Get(
3150: p_encoded => FND_API.G_FALSE,
3151: p_count => x_msg_count,
3152: p_data => x_msg_data );
3153:

Line 3160: FND_MSG_PUB.Count_And_Get(

3156: WHEN FND_API.G_EXC_ERROR THEN
3157: ROLLBACK TO create_customer_profile;
3158: x_return_status := FND_API.G_RET_STS_ERROR;
3159:
3160: FND_MSG_PUB.Count_And_Get(
3161: p_encoded => FND_API.G_FALSE,
3162: p_count => x_msg_count,
3163: p_data => x_msg_data );
3164:

Line 3170: FND_MSG_PUB.Count_And_Get(

3166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3167: ROLLBACK TO create_customer_profile;
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3169:
3170: FND_MSG_PUB.Count_And_Get(
3171: p_encoded => FND_API.G_FALSE,
3172: p_count => x_msg_count,
3173: p_data => x_msg_data );
3174:

Line 3182: fnd_msg_pub.add;

3178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3179:
3180: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3181: fnd_message.set_token( 'ERROR' ,SQLERRM );
3182: fnd_msg_pub.add;
3183:
3184: FND_MSG_PUB.Count_And_Get(
3185: p_encoded => FND_API.G_FALSE,
3186: p_count => x_msg_count,

Line 3184: FND_MSG_PUB.Count_And_Get(

3180: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3181: fnd_message.set_token( 'ERROR' ,SQLERRM );
3182: fnd_msg_pub.add;
3183:
3184: FND_MSG_PUB.Count_And_Get(
3185: p_encoded => FND_API.G_FALSE,
3186: p_count => x_msg_count,
3187: p_data => x_msg_data );
3188:

Line 3214: FND_MSG_PUB.initialize;

3210: SAVEPOINT create_cust_profile_amt;
3211:
3212: -- Initialize message list if p_init_msg_list is set to TRUE.
3213: IF FND_API.to_Boolean(p_init_msg_list) THEN
3214: FND_MSG_PUB.initialize;
3215: END IF;
3216:
3217: -- Initialize API return status to success.
3218: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3234: FND_MSG_PUB.Count_And_Get(

3230: l_cust_profile_amt_rec );
3231: END IF;
3232:
3233: -- Standard call to get message count and if count is 1, get message info.
3234: FND_MSG_PUB.Count_And_Get(
3235: p_encoded => FND_API.G_FALSE,
3236: p_count => x_msg_count,
3237: p_data => x_msg_data );
3238:

Line 3245: FND_MSG_PUB.Count_And_Get(

3241: WHEN FND_API.G_EXC_ERROR THEN
3242: ROLLBACK TO create_cust_profile_amt;
3243: x_return_status := FND_API.G_RET_STS_ERROR;
3244:
3245: FND_MSG_PUB.Count_And_Get(
3246: p_encoded => FND_API.G_FALSE,
3247: p_count => x_msg_count,
3248: p_data => x_msg_data );
3249:

Line 3254: FND_MSG_PUB.Count_And_Get(

3250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3251: ROLLBACK TO create_cust_profile_amt;
3252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3253:
3254: FND_MSG_PUB.Count_And_Get(
3255: p_encoded => FND_API.G_FALSE,
3256: p_count => x_msg_count,
3257: p_data => x_msg_data );
3258:

Line 3265: fnd_msg_pub.add;

3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3262:
3263: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3264: fnd_message.set_token( 'ERROR' ,SQLERRM );
3265: fnd_msg_pub.add;
3266:
3267: FND_MSG_PUB.Count_And_Get(
3268: p_encoded => FND_API.G_FALSE,
3269: p_count => x_msg_count,

Line 3267: FND_MSG_PUB.Count_And_Get(

3263: fnd_message.set_name( 'AR', 'HZ_API_OTHERS_EXCEP' );
3264: fnd_message.set_token( 'ERROR' ,SQLERRM );
3265: fnd_msg_pub.add;
3266:
3267: FND_MSG_PUB.Count_And_Get(
3268: p_encoded => FND_API.G_FALSE,
3269: p_count => x_msg_count,
3270: p_data => x_msg_data );
3271:

Line 3755: fnd_msg_pub.count_and_get(

3751: -- Call to indicate contact point creation to DQM
3752: hz_dqm_sync.sync_contact_point(l_contact_point_rec.contact_point_id, 'C');
3753:
3754: -- Standard call to get message count and if count is 1, get message info.
3755: fnd_msg_pub.count_and_get(
3756: p_encoded => fnd_api.g_false,
3757: p_count => x_msg_count,
3758: p_data => x_msg_data);
3759:

Line 3766: fnd_msg_pub.count_and_get(

3762: WHEN fnd_api.g_exc_error THEN
3763: ROLLBACK TO create_contact_point;
3764: x_return_status := fnd_api.g_ret_sts_error;
3765:
3766: fnd_msg_pub.count_and_get(
3767: p_encoded => fnd_api.g_false,
3768: p_count => x_msg_count,
3769: p_data => x_msg_data);
3770:

Line 3775: fnd_msg_pub.count_and_get(

3771: WHEN fnd_api.g_exc_unexpected_error THEN
3772: ROLLBACK TO create_contact_point;
3773: x_return_status := fnd_api.g_ret_sts_unexp_error;
3774:
3775: fnd_msg_pub.count_and_get(
3776: p_encoded => fnd_api.g_false,
3777: p_count => x_msg_count,
3778: p_data => x_msg_data);
3779:

Line 3786: fnd_msg_pub.add;

3782: x_return_status := fnd_api.g_ret_sts_unexp_error;
3783:
3784: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3785: fnd_message.set_token('ERROR' ,SQLERRM);
3786: fnd_msg_pub.add;
3787:
3788: fnd_msg_pub.count_and_get(
3789: p_encoded => fnd_api.g_false,
3790: p_count => x_msg_count,

Line 3788: fnd_msg_pub.count_and_get(

3784: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3785: fnd_message.set_token('ERROR' ,SQLERRM);
3786: fnd_msg_pub.add;
3787:
3788: fnd_msg_pub.count_and_get(
3789: p_encoded => fnd_api.g_false,
3790: p_count => x_msg_count,
3791: p_data => x_msg_data);
3792:

Line 3823: fnd_msg_pub.add;

3819: IF p_contact_point_id IS NULL OR
3820: p_contact_point_id = FND_API.G_MISS_NUM THEN
3821: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
3822: fnd_message.set_token('COLUMN', 'contact_point_id');
3823: fnd_msg_pub.add;
3824: RAISE fnd_api.g_exc_error;
3825: END IF;
3826:
3827: x_contact_point_rec.contact_point_id := p_contact_point_id;

Line 3896: fnd_msg_pub.count_and_get(

3892: );
3893:
3894:
3895: -- Standard call to get message count and if count is 1, get message info.
3896: fnd_msg_pub.count_and_get(
3897: p_encoded => fnd_api.g_false,
3898: p_count => x_msg_count,
3899: p_data => x_msg_data);
3900:

Line 3905: fnd_msg_pub.count_and_get(

3901: EXCEPTION
3902: WHEN fnd_api.g_exc_error THEN
3903: x_return_status := fnd_api.g_ret_sts_error;
3904:
3905: fnd_msg_pub.count_and_get(
3906: p_encoded => fnd_api.g_false,
3907: p_count => x_msg_count,
3908: p_data => x_msg_data);
3909:

Line 3913: fnd_msg_pub.count_and_get(

3909:
3910: WHEN fnd_api.g_exc_unexpected_error THEN
3911: x_return_status := fnd_api.g_ret_sts_unexp_error;
3912:
3913: fnd_msg_pub.count_and_get(
3914: p_encoded => fnd_api.g_false,
3915: p_count => x_msg_count,
3916: p_data => x_msg_data);
3917:

Line 3923: fnd_msg_pub.add;

3919: x_return_status := fnd_api.g_ret_sts_unexp_error;
3920:
3921: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3922: fnd_message.set_token('ERROR' ,SQLERRM);
3923: fnd_msg_pub.add;
3924:
3925: fnd_msg_pub.count_and_get(
3926: p_encoded => fnd_api.g_false,
3927: p_count => x_msg_count,

Line 3925: fnd_msg_pub.count_and_get(

3921: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3922: fnd_message.set_token('ERROR' ,SQLERRM);
3923: fnd_msg_pub.add;
3924:
3925: fnd_msg_pub.count_and_get(
3926: p_encoded => fnd_api.g_false,
3927: p_count => x_msg_count,
3928: p_data => x_msg_data);
3929:

Line 3980: FND_MSG_PUB.initialize;

3976: BEGIN
3977:
3978: --Initialize message list if p_init_msg_list is set to TRUE.
3979: IF FND_API.to_Boolean(p_init_msg_list) THEN
3980: FND_MSG_PUB.initialize;
3981: END IF;
3982:
3983: --Initialize API return status to success.
3984: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3991: FND_MSG_PUB.ADD;

3987: IF p_party_site_use_id IS NULL OR
3988: p_party_site_use_id = FND_API.G_MISS_NUM THEN
3989: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3990: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'p_party_site_use_id' );
3991: FND_MSG_PUB.ADD;
3992: RAISE FND_API.G_EXC_ERROR;
3993: END IF;
3994:
3995: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;

Line 4009: FND_MSG_PUB.Count_And_Get(

4005: X_APPLICATION_ID => x_party_site_use_rec.application_id
4006: );
4007:
4008: --Standard call to get message count and if count is 1, get message info.
4009: FND_MSG_PUB.Count_And_Get(
4010: p_encoded => FND_API.G_FALSE,
4011: p_count => x_msg_count,
4012: p_data => x_msg_data );
4013:

Line 4018: FND_MSG_PUB.Count_And_Get(

4014: EXCEPTION
4015: WHEN FND_API.G_EXC_ERROR THEN
4016: x_return_status := FND_API.G_RET_STS_ERROR;
4017:
4018: FND_MSG_PUB.Count_And_Get(
4019: p_encoded => FND_API.G_FALSE,
4020: p_count => x_msg_count,
4021: p_data => x_msg_data );
4022:

Line 4026: FND_MSG_PUB.Count_And_Get(

4022:
4023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4025:
4026: FND_MSG_PUB.Count_And_Get(
4027: p_encoded => FND_API.G_FALSE,
4028: p_count => x_msg_count,
4029: p_data => x_msg_data );
4030:

Line 4035: FND_MSG_PUB.ADD;

4031: WHEN OTHERS THEN
4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4033: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
4034: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: FND_MSG_PUB.Count_And_Get(
4037: p_encoded => FND_API.G_FALSE,
4038: p_count => x_msg_count,
4039: p_data => x_msg_data );

Line 4036: FND_MSG_PUB.Count_And_Get(

4032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4033: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
4034: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
4035: FND_MSG_PUB.ADD;
4036: FND_MSG_PUB.Count_And_Get(
4037: p_encoded => FND_API.G_FALSE,
4038: p_count => x_msg_count,
4039: p_data => x_msg_data );
4040:

Line 4108: FND_MSG_PUB.ADD;

4104: EXCEPTION
4105: WHEN OTHERS THEN
4106: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
4107: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
4108: FND_MSG_PUB.ADD;
4109: RAISE FND_API.G_EXC_ERROR;
4110: END;
4111:
4112: IF l_rowid IS NOT NULL THEN

Line 4271: FND_MSG_PUB.initialize;

4267: SAVEPOINT create_party_site_use;
4268:
4269: -- initialize message list if p_init_msg_list is set to TRUE.
4270: IF FND_API.to_Boolean(p_init_msg_list) THEN
4271: FND_MSG_PUB.initialize;
4272: END IF;
4273:
4274: -- initialize API return status to success.
4275: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4291: FND_MSG_PUB.Count_And_Get(

4287: l_party_site_use_rec );
4288: END IF;
4289:
4290: -- standard call to get message count and if count is 1, get message info.
4291: FND_MSG_PUB.Count_And_Get(
4292: p_encoded => FND_API.G_FALSE,
4293: p_count => x_msg_count,
4294: p_data => x_msg_data);
4295:

Line 4301: FND_MSG_PUB.Count_And_Get(

4297: EXCEPTION
4298: WHEN FND_API.G_EXC_ERROR THEN
4299: ROLLBACK TO create_party_site_use;
4300: x_return_status := FND_API.G_RET_STS_ERROR;
4301: FND_MSG_PUB.Count_And_Get(
4302: p_encoded => FND_API.G_FALSE,
4303: p_count => x_msg_count,
4304: p_data => x_msg_data);
4305:

Line 4309: FND_MSG_PUB.Count_And_Get(

4305:
4306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4307: ROLLBACK TO create_party_site_use;
4308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4309: FND_MSG_PUB.Count_And_Get(
4310: p_encoded => FND_API.G_FALSE,
4311: p_count => x_msg_count,
4312: p_data => x_msg_data);
4313:

Line 4319: FND_MSG_PUB.ADD;

4315: ROLLBACK TO create_party_site_use;
4316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4319: FND_MSG_PUB.ADD;
4320: FND_MSG_PUB.Count_And_Get(
4321: p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,
4323: p_data => x_msg_data);

Line 4320: FND_MSG_PUB.Count_And_Get(

4316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4318: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4319: FND_MSG_PUB.ADD;
4320: FND_MSG_PUB.Count_And_Get(
4321: p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,
4323: p_data => x_msg_data);
4324: