APPS.HZ_DUP_MERGE_PUB dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.ADD();

83:
84: if l_status = 'M'
85: then
86: FND_MESSAGE.SET_NAME('AR','HZ_DL_ALREADY_MERGED');
87: FND_MSG_PUB.ADD();
88: RAISE fnd_api.g_exc_error;
89: end if;
90:
91:

Line 119: FND_MSG_PUB.ADD();

115: CLOSE is_pty_valid;
116: if l_status = 'M'
117: then
118: FND_MESSAGE.SET_NAME('AR','HZ_DL_ALREADY_MERGED');
119: FND_MSG_PUB.ADD();
120: RAISE fnd_api.g_exc_error;
121: end if;
122: end if;
123:

Line 132: FND_MSG_PUB.ADD();

128: -- if px_id is invalid, raise error
129: IF(l_valid_id IS NULL) THEN
130: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INV_PARTYNUM');
131: fnd_message.set_token('PARTY_ID', px_id);
132: FND_MSG_PUB.ADD();
133: RAISE fnd_api.g_exc_error;
134: -- if px_id is valid
135: ELSE
136: -- check if px_os/px_osr is passed

Line 141: FND_MSG_PUB.ADD();

137: IF(l_ss_flag = 'Y') THEN
138: IF(l_count = 0) THEN
139: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INV_OSOSR');
140: fnd_message.set_token('OSOSR', px_os||' - '||px_osr);
141: FND_MSG_PUB.ADD();
142: RAISE fnd_api.g_exc_error;
143: -- if px_os/px_osr is valid
144: ELSE
145: -- if px_os/px_osr is valid, but not same as px_id

Line 149: FND_MSG_PUB.ADD();

145: -- if px_os/px_osr is valid, but not same as px_id
146: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INVALID');
148: fnd_message.set_token('OSOSR', px_os||' - '||px_osr);
149: FND_MSG_PUB.ADD();
150: RAISE fnd_api.g_exc_error;
151: END IF;
152: END IF;
153: -- if px_os/px_osr is valid and return value is same as px_id

Line 167: FND_MSG_PUB.ADD();

163: px_id := l_owner_table_id;
164: ELSE
165: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INV_OSOSR');
166: fnd_message.set_token('OSOSR', px_os||' - '||px_osr);
167: FND_MSG_PUB.ADD();
168: RAISE fnd_api.g_exc_error;
169: END IF;
170: END IF;
171:

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

172: EXCEPTION
173: WHEN fnd_api.g_exc_error THEN
174: x_return_status := fnd_api.g_ret_sts_error;
175:
176: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
177: p_count => x_msg_count,
178: p_data => x_msg_data);
179:
180: -- Debug info.

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

191: END IF;
192: WHEN fnd_api.g_exc_unexpected_error THEN
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:
195: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
196: p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: -- Debug info.

Line 216: fnd_msg_pub.add;

212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213:
214: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
215: fnd_message.set_token('ERROR' ,SQLERRM);
216: fnd_msg_pub.add;
217:
218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
219: p_count => x_msg_count,
220: p_data => x_msg_data);

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

214: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
215: fnd_message.set_token('ERROR' ,SQLERRM);
216: fnd_msg_pub.add;
217:
218: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
219: p_count => x_msg_count,
220: p_data => x_msg_data);
221:
222: -- Debug info.

Line 312: FND_MSG_PUB.ADD();

308:
309: if l_dup = 'Y'
310: then
311: FND_MESSAGE.SET_NAME('AR','HZ_MERGE_UNIQUE_CONST');
312: FND_MSG_PUB.ADD();
313: RAISE fnd_api.g_exc_error;
314: end if;
315:
316: OPEN get_party_name(l_dup_id_objs(1).party_id); -- choose any party

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

466: WHEN fnd_api.g_exc_error THEN
467: ROLLBACK TO create_dup_merge_req_pub;
468: x_return_status := fnd_api.g_ret_sts_error;
469:
470: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
471: p_count => x_msg_count,
472: p_data => x_msg_data);
473:
474: -- Debug info.

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

487: WHEN fnd_api.g_exc_unexpected_error THEN
488: ROLLBACK TO create_dup_merge_req_pub;
489: x_return_status := fnd_api.g_ret_sts_unexp_error;
490:
491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
492: p_count => x_msg_count,
493: p_data => x_msg_data);
494:
495: -- Debug info.

Line 514: fnd_msg_pub.add;

510: x_return_status := fnd_api.g_ret_sts_unexp_error;
511:
512: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
513: fnd_message.set_token('ERROR' ,SQLERRM);
514: fnd_msg_pub.add;
515:
516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data);

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

512: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
513: fnd_message.set_token('ERROR' ,SQLERRM);
514: fnd_msg_pub.add;
515:
516: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data);
519:
520: -- Debug info.