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

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28:
29: l_valid_flag varchar2(1);
30: begin
31: -- initialize API return status to success.
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: open c1;
35: fetch c1 into l_valid_flag;
36: close c1;

Line 44: x_return_status := FND_API.G_RET_STS_ERROR;

40: if p_party_id is null
41: then
42: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_ID');
43: FND_MSG_PUB.ADD;
44: x_return_status := FND_API.G_RET_STS_ERROR;
45: RAISE FND_API.G_EXC_ERROR;
46: else
47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_ID');
48: FND_MSG_PUB.ADD;

Line 45: RAISE FND_API.G_EXC_ERROR;

41: then
42: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_ID');
43: FND_MSG_PUB.ADD;
44: x_return_status := FND_API.G_RET_STS_ERROR;
45: RAISE FND_API.G_EXC_ERROR;
46: else
47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_ID');
48: FND_MSG_PUB.ADD;
49: x_return_status := FND_API.G_RET_STS_ERROR;

Line 49: x_return_status := FND_API.G_RET_STS_ERROR;

45: RAISE FND_API.G_EXC_ERROR;
46: else
47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_ID');
48: FND_MSG_PUB.ADD;
49: x_return_status := FND_API.G_RET_STS_ERROR;
50: RAISE FND_API.G_EXC_ERROR;
51: end if;
52: end if;
53:

Line 50: RAISE FND_API.G_EXC_ERROR;

46: else
47: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_EVENT_OBJ_ID');
48: FND_MSG_PUB.ADD;
49: x_return_status := FND_API.G_RET_STS_ERROR;
50: RAISE FND_API.G_EXC_ERROR;
51: end if;
52: end if;
53:
54:

Line 149: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

145:
146: -- Central procedure for getting root event id.
147:
148: procedure get_bo_root_ids(
149: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
150: p_event_id IN NUMBER,
151: x_obj_root_ids OUT NOCOPY BO_ID_TBL,
152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS;

163: and child_entity_name = 'HZ_PARTIES';
164:
165: begin
166: -- initialize API return status to success.
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: -- Initialize message list if p_init_msg_list is set to TRUE
170: IF FND_API.to_Boolean(p_init_msg_list) THEN
171: FND_MSG_PUB.initialize;

Line 170: IF FND_API.to_Boolean(p_init_msg_list) THEN

166: -- initialize API return status to success.
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: -- Initialize message list if p_init_msg_list is set to TRUE
170: IF FND_API.to_Boolean(p_init_msg_list) THEN
171: FND_MSG_PUB.initialize;
172: END IF;
173:
174:

Line 205: WHEN fnd_api.g_exc_error THEN

201:
202:
203: EXCEPTION
204:
205: WHEN fnd_api.g_exc_error THEN
206: x_return_status := fnd_api.g_ret_sts_error;
207:
208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
209: p_count => x_msg_count,

Line 206: x_return_status := fnd_api.g_ret_sts_error;

202:
203: EXCEPTION
204:
205: WHEN fnd_api.g_exc_error THEN
206: x_return_status := fnd_api.g_ret_sts_error;
207:
208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
209: p_count => x_msg_count,
210: p_data => x_msg_data);

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

204:
205: WHEN fnd_api.g_exc_error THEN
206: x_return_status := fnd_api.g_ret_sts_error;
207:
208: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
209: p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212: -- Debug info.

Line 224: WHEN fnd_api.g_exc_unexpected_error THEN

220: hz_utility_v2pub.debug(p_message=>'get_bo_root_ids(-)',
221: p_prefix=>l_debug_prefix,
222: p_msg_level=>fnd_log.level_procedure);
223: END IF;
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226:
227: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
228: p_count => x_msg_count,

Line 225: x_return_status := fnd_api.g_ret_sts_unexp_error;

221: p_prefix=>l_debug_prefix,
222: p_msg_level=>fnd_log.level_procedure);
223: END IF;
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226:
227: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
228: p_count => x_msg_count,
229: p_data => x_msg_data);

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

223: END IF;
224: WHEN fnd_api.g_exc_unexpected_error THEN
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226:
227: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
228: p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: -- Debug info.

Line 244: x_return_status := fnd_api.g_ret_sts_unexp_error;

240: p_prefix=>l_debug_prefix,
241: p_msg_level=>fnd_log.level_procedure);
242: END IF;
243: WHEN OTHERS THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245:
246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR' ,SQLERRM);
248: fnd_msg_pub.add;

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

246: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
247: fnd_message.set_token('ERROR' ,SQLERRM);
248: fnd_msg_pub.add;
249:
250: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
251: p_count => x_msg_count,
252: p_data => x_msg_data);
253:
254: -- Debug info.

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

270: p_os IN VARCHAR2,
271: p_osr IN VARCHAR2
272: ) RETURN VARCHAR2 IS
273: BEGIN
274: IF((p_os is null or p_os = fnd_api.g_miss_char)
275: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN
276: RETURN 'N';
277: ELSE
278: RETURN 'Y';

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

271: p_osr IN VARCHAR2
272: ) RETURN VARCHAR2 IS
273: BEGIN
274: IF((p_os is null or p_os = fnd_api.g_miss_char)
275: and (p_osr is null or p_osr = fnd_api.g_miss_char))THEN
276: RETURN 'N';
277: ELSE
278: RETURN 'Y';
279: END IF;

Line 356: x_return_status := FND_API.G_RET_STS_SUCCESS;

352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;
355:
356: x_return_status := FND_API.G_RET_STS_SUCCESS;
357:
358: l_ss_flag := is_ss_provided(p_os => px_os,
359: p_osr => px_osr);
360:

Line 438: RAISE fnd_api.g_exc_error;

434: CLOSE is_cp_valid;
435: IF(l_dummy IS NULL) THEN
436: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_TCA_ID');
437: FND_MSG_PUB.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440: END IF;
441: END IF;
442: END IF;

Line 450: RAISE fnd_api.g_exc_error;

446: -- if px_id is invalid, raise error
447: IF(l_valid_id IS NULL) THEN
448: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_ID');
449: FND_MSG_PUB.ADD();
450: RAISE fnd_api.g_exc_error;
451: -- if px_id is valid
452: ELSE
453: -- check if px_os/px_osr is passed
454: IF(l_ss_flag = 'Y') THEN

Line 458: RAISE fnd_api.g_exc_error;

454: IF(l_ss_flag = 'Y') THEN
455: IF(l_count = 0) THEN
456: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
457: FND_MSG_PUB.ADD();
458: RAISE fnd_api.g_exc_error;
459: -- if px_os/px_osr is valid
460: ELSE
461: -- if px_os/px_osr is valid, but not same as px_id
462: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

458: RAISE fnd_api.g_exc_error;
459: -- if px_os/px_osr is valid
460: ELSE
461: -- if px_os/px_osr is valid, but not same as px_id
462: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_SSM_ID');
464: FND_MSG_PUB.ADD();
465: RAISE fnd_api.g_exc_error;
466: END IF;

Line 465: RAISE fnd_api.g_exc_error;

461: -- if px_os/px_osr is valid, but not same as px_id
462: IF(l_owner_table_id <> px_id) OR (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
463: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_TCA_SSM_ID');
464: FND_MSG_PUB.ADD();
465: RAISE fnd_api.g_exc_error;
466: END IF;
467: END IF;
468: -- if px_os/px_osr is valid and return value is same as px_id
469: -- do nothing

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

473: ELSE
474: -- check if px_os/px_osr can find TCA identifier, owner_table_id
475: -- if not found, raise error
476: -- else, get owner_table_id and assign it to px_id
477: IF(l_ss_flag = 'Y') AND (l_count = 1) AND (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
478: px_id := l_owner_table_id;
479: ELSE
480: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
481: FND_MSG_PUB.ADD();

Line 482: RAISE fnd_api.g_exc_error;

478: px_id := l_owner_table_id;
479: ELSE
480: FND_MESSAGE.SET_NAME('AR','HZ_API_INVALID_SSM_ID');
481: FND_MSG_PUB.ADD();
482: RAISE fnd_api.g_exc_error;
483: END IF;
484: END IF;
485:
486: EXCEPTION

Line 487: WHEN fnd_api.g_exc_error THEN

483: END IF;
484: END IF;
485:
486: EXCEPTION
487: WHEN fnd_api.g_exc_error THEN
488: x_return_status := fnd_api.g_ret_sts_error;
489:
490: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
491: p_count => x_msg_count,

Line 488: x_return_status := fnd_api.g_ret_sts_error;

484: END IF;
485:
486: EXCEPTION
487: WHEN fnd_api.g_exc_error THEN
488: x_return_status := fnd_api.g_ret_sts_error;
489:
490: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data);

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

486: EXCEPTION
487: WHEN fnd_api.g_exc_error THEN
488: x_return_status := fnd_api.g_ret_sts_error;
489:
490: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
491: p_count => x_msg_count,
492: p_data => x_msg_data);
493:
494: -- Debug info.

Line 506: WHEN fnd_api.g_exc_unexpected_error THEN

502: hz_utility_v2pub.debug(p_message=>'validate_ssm_id(-)',
503: p_prefix=>l_debug_prefix,
504: p_msg_level=>fnd_log.level_procedure);
505: END IF;
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508:
509: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
510: p_count => x_msg_count,

Line 507: x_return_status := fnd_api.g_ret_sts_unexp_error;

503: p_prefix=>l_debug_prefix,
504: p_msg_level=>fnd_log.level_procedure);
505: END IF;
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508:
509: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
510: p_count => x_msg_count,
511: p_data => x_msg_data);

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

505: END IF;
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508:
509: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
510: p_count => x_msg_count,
511: p_data => x_msg_data);
512:
513: -- Debug info.

Line 526: x_return_status := fnd_api.g_ret_sts_unexp_error;

522: p_prefix=>l_debug_prefix,
523: p_msg_level=>fnd_log.level_procedure);
524: END IF;
525: WHEN OTHERS THEN
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527:
528: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
529: fnd_message.set_token('ERROR' ,SQLERRM);
530: fnd_msg_pub.add;

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

528: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
529: fnd_message.set_token('ERROR' ,SQLERRM);
530: fnd_msg_pub.add;
531:
532: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
533: p_count => x_msg_count,
534: p_data => x_msg_data);
535:
536: -- Debug info.