DBA Data[Home] [Help]

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 292: FND_MSG_PUB.initialize;

288: p_msg_level=>fnd_log.level_procedure);
289: END IF;
290: --Bug8342391
291: IF FND_API.to_Boolean(p_init_msg_list) THEN
292: FND_MSG_PUB.initialize;
293: END IF;
294:
295: l_dup_id_objs := p_dup_id_objs;
296: for i in 1..l_dup_id_objs.count loop

Line 316: FND_MSG_PUB.ADD();

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

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

473: WHEN fnd_api.g_exc_error THEN
474: ROLLBACK TO create_dup_merge_req_pub;
475: x_return_status := fnd_api.g_ret_sts_error;
476:
477: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data);
480:
481: -- Debug info.

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

494: WHEN fnd_api.g_exc_unexpected_error THEN
495: ROLLBACK TO create_dup_merge_req_pub;
496: x_return_status := fnd_api.g_ret_sts_unexp_error;
497:
498: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
499: p_count => x_msg_count,
500: p_data => x_msg_data);
501:
502: -- Debug info.

Line 521: fnd_msg_pub.add;

517: x_return_status := fnd_api.g_ret_sts_unexp_error;
518:
519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
520: fnd_message.set_token('ERROR' ,SQLERRM);
521: fnd_msg_pub.add;
522:
523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
524: p_count => x_msg_count,
525: p_data => x_msg_data);

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

519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
520: fnd_message.set_token('ERROR' ,SQLERRM);
521: fnd_msg_pub.add;
522:
523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
524: p_count => x_msg_count,
525: p_data => x_msg_data);
526:
527: -- Debug info.