DBA Data[Home] [Help]

APPS.HZ_DUP_MERGE_PUB dependencies on FND_MESSAGE

Line 86: FND_MESSAGE.SET_NAME('AR','HZ_DL_ALREADY_MERGED');

82: end if;
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:

Line 118: FND_MESSAGE.SET_NAME('AR','HZ_DL_ALREADY_MERGED');

114: FETCH is_pty_valid INTO l_status, l_valid_id;
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;

Line 130: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INV_PARTYNUM');

126: -- if px_id pass in
127: IF(px_id IS NOT NULL) THEN
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

Line 131: fnd_message.set_token('PARTY_ID', px_id);

127: IF(px_id IS NOT NULL) THEN
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

Line 139: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INV_OSOSR');

135: ELSE
136: -- check if px_os/px_osr is passed
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

Line 140: fnd_message.set_token('OSOSR', px_os||' - '||px_osr);

136: -- check if px_os/px_osr is passed
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

Line 147: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INVALID');

143: -- if px_os/px_osr is valid
144: ELSE
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;

Line 148: fnd_message.set_token('OSOSR', px_os||' - '||px_osr);

144: ELSE
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;

Line 165: FND_MESSAGE.SET_NAME('AR','HZ_DL_MR_INV_OSOSR');

161: -- else, get owner_table_id and assign it to px_id
162: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
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;

Line 166: fnd_message.set_token('OSOSR', px_os||' - '||px_osr);

162: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
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;

Line 214: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

210: END IF;
211: WHEN OTHERS THEN
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,

Line 215: fnd_message.set_token('ERROR' ,SQLERRM);

211: WHEN OTHERS THEN
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,

Line 315: FND_MESSAGE.SET_NAME('AR','HZ_MERGE_UNIQUE_CONST');

311: l_dup := check_obj_dup_value(l_dup_id_objs);
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:

Line 519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

515: WHEN OTHERS THEN
516: ROLLBACK TO create_dup_merge_req_pub;
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,

Line 520: fnd_message.set_token('ERROR' ,SQLERRM);

516: ROLLBACK TO create_dup_merge_req_pub;
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,