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_DUP_MERGE_PUB dependencies on FND_API

Line 19: -- be fnd_api.g_ret_sts_success (success),

15: -- p_note_text note for the merge request
16: --
17: -- OUT:
18: -- x_return_status Return status after the call. The status can
19: -- be fnd_api.g_ret_sts_success (success),
20: -- fnd_api.g_ret_sts_error (error),
21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22: -- x_msg_count Number of messages in message stack.
23: -- x_msg_data Message text if x_msg_count is 1.

Line 20: -- fnd_api.g_ret_sts_error (error),

16: --
17: -- OUT:
18: -- x_return_status Return status after the call. The status can
19: -- be fnd_api.g_ret_sts_success (success),
20: -- fnd_api.g_ret_sts_error (error),
21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22: -- x_msg_count Number of messages in message stack.
23: -- x_msg_data Message text if x_msg_count is 1.
24: -- x_merge_request_id merge request id

Line 21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

17: -- OUT:
18: -- x_return_status Return status after the call. The status can
19: -- be fnd_api.g_ret_sts_success (success),
20: -- fnd_api.g_ret_sts_error (error),
21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22: -- x_msg_count Number of messages in message stack.
23: -- x_msg_data Message text if x_msg_count is 1.
24: -- x_merge_request_id merge request id
25: --

Line 38: IF((p_os is null or p_os = fnd_api.g_miss_char)

34: p_os IN VARCHAR2,
35: p_osr IN VARCHAR2
36: ) RETURN VARCHAR2 IS
37: BEGIN
38: IF((p_os is null or p_os = fnd_api.g_miss_char)
39: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN
40: RETURN 'N';
41: ELSE
42: RETURN 'Y';

Line 39: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN

35: p_osr IN VARCHAR2
36: ) RETURN VARCHAR2 IS
37: BEGIN
38: IF((p_os is null or p_os = fnd_api.g_miss_char)
39: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN
40: RETURN 'N';
41: ELSE
42: RETURN 'Y';
43: END IF;

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

70: p_prefix=>l_debug_prefix,
71: p_msg_level=>fnd_log.level_procedure);
72: END IF;
73:
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:
76: -- if px_id pass in, check if px_id is valid or not
77: IF(px_id IS NOT NULL) THEN
78:

Line 88: RAISE fnd_api.g_exc_error;

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:
92: l_ss_flag := is_ss_provided(p_os => px_os,

Line 120: RAISE fnd_api.g_exc_error;

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

Line 133: RAISE fnd_api.g_exc_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
137: IF(l_ss_flag = 'Y') THEN

Line 142: RAISE fnd_api.g_exc_error;

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
146: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 146: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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
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;

Line 150: RAISE fnd_api.g_exc_error;

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
154: -- do nothing

Line 162: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

158: ELSE
159: -- check if px_os/px_osr can find TCA identifier, owner_table_id
160: -- if not found, raise error
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);

Line 168: RAISE fnd_api.g_exc_error;

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:
172: EXCEPTION

Line 173: WHEN fnd_api.g_exc_error THEN

169: END IF;
170: END IF;
171:
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,

Line 174: x_return_status := fnd_api.g_ret_sts_error;

170: END IF;
171:
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);

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 192: WHEN fnd_api.g_exc_unexpected_error THEN

188: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
189: p_prefix=>l_debug_prefix,
190: p_msg_level=>fnd_log.level_procedure);
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,

Line 193: x_return_status := fnd_api.g_ret_sts_unexp_error;

189: p_prefix=>l_debug_prefix,
190: p_msg_level=>fnd_log.level_procedure);
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);

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 212: x_return_status := fnd_api.g_ret_sts_unexp_error;

208: p_prefix=>l_debug_prefix,
209: p_msg_level=>fnd_log.level_procedure);
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;

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 250: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

246: return 'N';
247: end;
248:
249: PROCEDURE create_dup_merge_request(
250: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
251: p_dup_id_objs IN HZ_DUP_ID_OBJ_TBL,
252: p_note_text IN VARCHAR2,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_msg_count OUT NOCOPY NUMBER,

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: -- Standard start of API savepoint
279: SAVEPOINT create_dup_merge_req_pub;
280:
281: -- initialize API return status to success.
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: -- Debug info.
285: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
286: hz_utility_v2pub.debug(p_message=>'create_dup_merge_request(+)',

Line 291: IF FND_API.to_Boolean(p_init_msg_list) THEN

287: p_prefix=>l_debug_prefix,
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;

Line 305: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

301: x_return_status => x_return_status,
302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data);
304:
305: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: end loop;

Line 306: RAISE fnd_api.g_exc_error;

302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data);
304:
305: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: end loop;
310:

Line 317: RAISE fnd_api.g_exc_error;

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
321: FETCH get_party_name INTO l_party_name;

Line 357: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

353: ,x_return_status => x_return_status
354: ,x_msg_count => x_msg_count
355: ,x_msg_data => x_msg_data );
356:
357: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: if p_dup_id_objs.count > 1

Line 358: RAISE FND_API.G_EXC_ERROR;

354: ,x_msg_count => x_msg_count
355: ,x_msg_data => x_msg_data );
356:
357: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: if p_dup_id_objs.count > 1
362: then

Line 371: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

367: x_return_status => x_return_status,
368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data );
370:
371: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: update hz_dup_batch

Line 372: RAISE FND_API.G_EXC_ERROR;

368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data );
370:
371: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374:
375: update hz_dup_batch
376: set dup_batch_name = l_party_name || ' - '||l_dup_batch_id

Line 384: p_init_msg_list => FND_API.G_FALSE,

380:
381: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
382: p_dup_set_id => l_dup_set_id,
383: p_merge_batch_id => null,
384: p_init_msg_list => FND_API.G_FALSE,
385: p_reject_req_flag => 'N',
386: x_return_status => x_return_status,
387: x_msg_count => x_msg_count,
388: x_msg_data => x_msg_data);

Line 390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

386: x_return_status => x_return_status,
387: x_msg_count => x_msg_count,
388: x_msg_data => x_msg_data);
389:
390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- populate merge tables

Line 391: RAISE FND_API.G_EXC_ERROR;

387: x_msg_count => x_msg_count,
388: x_msg_data => x_msg_data);
389:
390: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: -- populate merge tables
395: hz_dup_pvt.submit_dup (

Line 402: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

398: ,x_return_status => x_return_status
399: ,x_msg_count => x_msg_count
400: ,x_msg_data => x_msg_data);
401:
402: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;
405:
406: IF p_note_text IS NOT NULL THEN

Line 403: RAISE FND_API.G_EXC_ERROR;

399: ,x_msg_count => x_msg_count
400: ,x_msg_data => x_msg_data);
401:
402: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;
405:
406: IF p_note_text IS NOT NULL THEN
407:

Line 412: ,p_init_msg_list =>FND_API.g_false

408: jtf_notes_pub.Create_note
409: (p_parent_note_id =>null
410: ,p_jtf_note_id =>null
411: ,p_api_version =>1
412: ,p_init_msg_list =>FND_API.g_false
413: ,p_commit =>FND_API.g_false
414: ,p_validation_level =>100
415: ,x_return_status =>x_return_status
416: ,x_msg_count =>x_msg_count

Line 413: ,p_commit =>FND_API.g_false

409: (p_parent_note_id =>null
410: ,p_jtf_note_id =>null
411: ,p_api_version =>1
412: ,p_init_msg_list =>FND_API.g_false
413: ,p_commit =>FND_API.g_false
414: ,p_validation_level =>100
415: ,x_return_status =>x_return_status
416: ,x_msg_count =>x_msg_count
417: ,x_msg_data =>x_msg_data

Line 451: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

447: ,p_context => NULL
448: ,p_note_type => 'GENERAL'
449: );
450:
451: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:
455: END IF; --p_note_text

Line 452: RAISE FND_API.G_EXC_ERROR;

448: ,p_note_type => 'GENERAL'
449: );
450:
451: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:
455: END IF; --p_note_text
456: x_merge_request_id := l_dup_set_id;

Line 473: WHEN fnd_api.g_exc_error THEN

469: p_msg_level=>fnd_log.level_procedure);
470: END IF;
471:
472: EXCEPTION
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,

Line 475: x_return_status := fnd_api.g_ret_sts_error;

471:
472: EXCEPTION
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);

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 494: WHEN fnd_api.g_exc_unexpected_error THEN

490: p_prefix=>l_debug_prefix,
491: p_msg_level=>fnd_log.level_procedure);
492: END IF;
493:
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,

Line 496: x_return_status := fnd_api.g_ret_sts_unexp_error;

492: END IF;
493:
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);

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 517: x_return_status := fnd_api.g_ret_sts_unexp_error;

513: END IF;
514:
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;

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.