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 301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

297: x_return_status => x_return_status,
298: x_msg_count => x_msg_count,
299: x_msg_data => x_msg_data);
300:
301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
302: RAISE fnd_api.g_exc_error;
303: END IF;
304:
305: end loop;

Line 302: RAISE fnd_api.g_exc_error;

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

Line 313: RAISE fnd_api.g_exc_error;

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

Line 353: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

349: ,x_return_status => x_return_status
350: ,x_msg_count => x_msg_count
351: ,x_msg_data => x_msg_data );
352:
353: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: if p_dup_id_objs.count > 1

Line 354: RAISE FND_API.G_EXC_ERROR;

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

Line 367: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

363: x_return_status => x_return_status,
364: x_msg_count => x_msg_count,
365: x_msg_data => x_msg_data );
366:
367: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371: update hz_dup_batch

Line 368: RAISE FND_API.G_EXC_ERROR;

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

Line 380: p_init_msg_list => FND_API.G_FALSE,

376:
377: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(
378: p_dup_set_id => l_dup_set_id,
379: p_merge_batch_id => null,
380: p_init_msg_list => FND_API.G_FALSE,
381: p_reject_req_flag => 'N',
382: x_return_status => x_return_status,
383: x_msg_count => x_msg_count,
384: x_msg_data => x_msg_data);

Line 386: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

382: x_return_status => x_return_status,
383: x_msg_count => x_msg_count,
384: x_msg_data => x_msg_data);
385:
386: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: -- populate merge tables

Line 387: RAISE FND_API.G_EXC_ERROR;

383: x_msg_count => x_msg_count,
384: x_msg_data => x_msg_data);
385:
386: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: -- populate merge tables
391: hz_dup_pvt.submit_dup (

Line 398: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

394: ,x_return_status => x_return_status
395: ,x_msg_count => x_msg_count
396: ,x_msg_data => x_msg_data);
397:
398: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: jtf_notes_pub.Create_note

Line 399: RAISE FND_API.G_EXC_ERROR;

395: ,x_msg_count => x_msg_count
396: ,x_msg_data => x_msg_data);
397:
398: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: jtf_notes_pub.Create_note
403: (p_parent_note_id =>null

Line 406: ,p_init_msg_list =>FND_API.g_false

402: jtf_notes_pub.Create_note
403: (p_parent_note_id =>null
404: ,p_jtf_note_id =>null
405: ,p_api_version =>1
406: ,p_init_msg_list =>FND_API.g_false
407: ,p_commit =>FND_API.g_false
408: ,p_validation_level =>100
409: ,x_return_status =>x_return_status
410: ,x_msg_count =>x_msg_count

Line 407: ,p_commit =>FND_API.g_false

403: (p_parent_note_id =>null
404: ,p_jtf_note_id =>null
405: ,p_api_version =>1
406: ,p_init_msg_list =>FND_API.g_false
407: ,p_commit =>FND_API.g_false
408: ,p_validation_level =>100
409: ,x_return_status =>x_return_status
410: ,x_msg_count =>x_msg_count
411: ,x_msg_data =>x_msg_data

Line 445: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

441: ,p_context => NULL
442: ,p_note_type => 'GENERAL'
443: );
444:
445: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: x_merge_request_id := l_dup_set_id;

Line 446: RAISE FND_API.G_EXC_ERROR;

442: ,p_note_type => 'GENERAL'
443: );
444:
445: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: x_merge_request_id := l_dup_set_id;
450:

Line 466: WHEN fnd_api.g_exc_error THEN

462: p_msg_level=>fnd_log.level_procedure);
463: END IF;
464:
465: EXCEPTION
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,

Line 468: x_return_status := fnd_api.g_ret_sts_error;

464:
465: EXCEPTION
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);

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

483: p_prefix=>l_debug_prefix,
484: p_msg_level=>fnd_log.level_procedure);
485: END IF;
486:
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,

Line 489: x_return_status := fnd_api.g_ret_sts_unexp_error;

485: END IF;
486:
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);

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

506: END IF;
507:
508: WHEN OTHERS THEN
509: ROLLBACK TO create_dup_merge_req_pub;
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;

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.