DBA Data[Home] [Help]

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on FND_MSG_PUB

Line 140: FND_MSG_PUB.initialize;

136: x_return_status := FND_API.G_RET_STS_SUCCESS;
137:
138: -- Initialize message list if p_init_msg_list is set to TRUE
139: IF FND_API.to_Boolean(p_init_msg_list) THEN
140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: -- Debug info.
144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

230:
231: WHEN fnd_api.g_exc_error THEN
232: x_return_status := fnd_api.g_ret_sts_error;
233:
234: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
235: p_count => x_msg_count,
236: p_data => x_msg_data);
237:
238: -- Debug info.

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

249: END IF;
250: WHEN fnd_api.g_exc_unexpected_error THEN
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:
253: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256:
257: -- Debug info.

Line 274: fnd_msg_pub.add;

270: x_return_status := fnd_api.g_ret_sts_unexp_error;
271:
272: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
273: fnd_message.set_token('ERROR' ,SQLERRM);
274: fnd_msg_pub.add;
275:
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
277: p_count => x_msg_count,
278: p_data => x_msg_data);

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

272: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
273: fnd_message.set_token('ERROR' ,SQLERRM);
274: fnd_msg_pub.add;
275:
276: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
277: p_count => x_msg_count,
278: p_data => x_msg_data);
279:
280: -- Debug info.

Line 1017: FND_MSG_PUB.initialize;

1013: x_return_status := FND_API.G_RET_STS_SUCCESS;
1014:
1015: -- Initialize message list if p_init_msg_list is set to TRUE
1016: IF FND_API.to_Boolean(p_init_msg_list) THEN
1017: FND_MSG_PUB.initialize;
1018: END IF;
1019:
1020: -- Debug info.
1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1033: FND_MSG_PUB.ADD();

1029: FND_MESSAGE.SET_TOKEN('COLUMN1','getMergeDetailFlag');
1030: FND_MESSAGE.SET_TOKEN('VALUE1',p_get_merge_detail_flag);
1031: FND_MESSAGE.SET_TOKEN('COLUMN2','getMergeDetailFlag');
1032: FND_MESSAGE.SET_TOKEN('VALUE2','Y/N');
1033: FND_MSG_PUB.ADD();
1034: RAISE fnd_api.g_exc_error;
1035: END IF;
1036:
1037: BEGIN

Line 1044: FND_MSG_PUB.ADD();

1040: WHERE customer_merge_header_id = p_customer_merge_header_id;
1041: EXCEPTION
1042: WHEN NO_DATA_FOUND THEN
1043: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');
1044: FND_MSG_PUB.ADD();
1045: RAISE fnd_api.g_exc_error;
1046: END;
1047:
1048: OPEN account_merge_details;

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

1385:
1386: WHEN fnd_api.g_exc_error THEN
1387: x_return_status := fnd_api.g_ret_sts_error;
1388:
1389: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1390: p_count => x_msg_count,
1391: p_data => x_msg_data);
1392:
1393: -- Debug info.

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

1404: END IF;
1405: WHEN fnd_api.g_exc_unexpected_error THEN
1406: x_return_status := fnd_api.g_ret_sts_unexp_error;
1407:
1408: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1409: p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:
1412: -- Debug info.

Line 1429: fnd_msg_pub.add;

1425: x_return_status := fnd_api.g_ret_sts_unexp_error;
1426:
1427: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1428: fnd_message.set_token('ERROR' ,SQLERRM);
1429: fnd_msg_pub.add;
1430:
1431: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1432: p_count => x_msg_count,
1433: p_data => x_msg_data);

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

1427: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1428: fnd_message.set_token('ERROR' ,SQLERRM);
1429: fnd_msg_pub.add;
1430:
1431: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1432: p_count => x_msg_count,
1433: p_data => x_msg_data);
1434:
1435: -- Debug info.

Line 1749: FND_MSG_PUB.initialize;

1745: x_return_status := FND_API.G_RET_STS_SUCCESS;
1746:
1747: -- Initialize message list if p_init_msg_list is set to TRUE
1748: IF FND_API.to_Boolean(p_init_msg_list) THEN
1749: FND_MSG_PUB.initialize;
1750: END IF;
1751:
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(+)',

Line 1764: FND_MSG_PUB.ADD();

1760: FND_MESSAGE.SET_TOKEN('COLUMN1','getMergeDetailFlag');
1761: FND_MESSAGE.SET_TOKEN('VALUE1',p_get_merge_detail_flag);
1762: FND_MESSAGE.SET_TOKEN('COLUMN2','getMergeDetailFlag');
1763: FND_MESSAGE.SET_TOKEN('VALUE2','Y/N');
1764: FND_MSG_PUB.ADD();
1765: RAISE fnd_api.g_exc_error;
1766: END IF;
1767:
1768: BEGIN

Line 1775: FND_MSG_PUB.ADD();

1771: WHERE batch_id = p_batch_id;
1772: EXCEPTION
1773: WHEN NO_DATA_FOUND THEN
1774: FND_MESSAGE.SET_NAME('AR','HZ_INVALID_DUP_BATCH');
1775: FND_MSG_PUB.ADD();
1776: RAISE fnd_api.g_exc_error;
1777: END;
1778: IF p_merge_to_party_id IS NOT NULL THEN
1779: BEGIN

Line 1788: FND_MSG_PUB.ADD();

1784: AND rownum = 1;
1785: EXCEPTION
1786: WHEN NO_DATA_FOUND THEN
1787: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');
1788: FND_MSG_PUB.ADD();
1789: RAISE fnd_api.g_exc_error;
1790: END;
1791: ELSE
1792: SELECT to_party_id INTO l_merge_to_party_id

Line 1801: FND_MSG_PUB.ADD();

1797: END IF;
1798:
1799: IF l_merge_status <> 'COMPLETE' THEN
1800: FND_MESSAGE.SET_NAME('AR','HZ_CANNOT_SUBMIT_PROCESSING');
1801: FND_MSG_PUB.ADD();
1802: RAISE fnd_api.g_exc_error;
1803: END IF;
1804:
1805: open party_merge_details;

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

1855:
1856: WHEN fnd_api.g_exc_error THEN
1857: x_return_status := fnd_api.g_ret_sts_error;
1858:
1859: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1860: p_count => x_msg_count,
1861: p_data => x_msg_data);
1862:
1863: -- Debug info.

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

1874: END IF;
1875: WHEN fnd_api.g_exc_unexpected_error THEN
1876: x_return_status := fnd_api.g_ret_sts_unexp_error;
1877:
1878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881:
1882: -- Debug info.

Line 1899: fnd_msg_pub.add;

1895: x_return_status := fnd_api.g_ret_sts_unexp_error;
1896:
1897: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1898: fnd_message.set_token('ERROR' ,SQLERRM);
1899: fnd_msg_pub.add;
1900:
1901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1902: p_count => x_msg_count,
1903: p_data => x_msg_data);

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

1897: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1898: fnd_message.set_token('ERROR' ,SQLERRM);
1899: fnd_msg_pub.add;
1900:
1901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1902: p_count => x_msg_count,
1903: p_data => x_msg_data);
1904:
1905: -- Debug info.