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

Line 104: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

100: p_to_party_id,
101: p_merge_reason_code,
102: x_return_status);
103:
104: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: --Check the From Party and the HQ Branch

Line 105: RAISE FND_API.G_EXC_ERROR;

101: p_merge_reason_code,
102: x_return_status);
103:
104: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: --Check the From Party and the HQ Branch
109: check_party_hq(p_batch_id ,

Line 228: RAISE FND_API.G_EXC_ERROR;

224: /* BugNo 3024162 Commented the code If num>0 ... END IF;*/
225: /* IF num>0 THEN
226: fnd_message.set_name('AR','HZ_NUM_RELN_PARTY_REQD');
227: fnd_message.set_token('NUM_PARTIES',TO_CHAR(num));
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: */
231:
232: EXCEPTION

Line 273: RAISE FND_API.G_EXC_ERROR;

269: CLOSE c_check_from_party;
270: FND_MESSAGE.SET_NAME('AR','HZ_PARTY_ALREADY_IN_BATCH');
271: -----------Srini y'r msg involves party number etc whose value we don't know here
272: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: CLOSE c_check_from_party;
276:
277: /*OPEN c_check_hq_branch(cp_from_party_id ,cp_to_party_id);

Line 284: RAISE FND_API.G_EXC_ERROR;

280: CLOSE c_check_hq_branch;
281: FND_MESSAGE.SET_NAME('AR','HZ_DNB_BRANCH');
282: -----------y'r msg involves party name etc whose value we don't have
283: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286: CLOSE c_check_hq_branch; */
287:
288: END CHECK_PARTY_HQ;

Line 359: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

355: +===========================================================================**/
356:
357: procedure create_merge_party (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
360: p_commit IN VARCHAR2:= FND_API.G_FALSE,
361: p_batch_id IN NUMBER,
362: p_merge_type IN VARCHAR2,
363: p_from_party_id IN NUMBER,

Line 360: p_commit IN VARCHAR2:= FND_API.G_FALSE,

356:
357: procedure create_merge_party (
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
360: p_commit IN VARCHAR2:= FND_API.G_FALSE,
361: p_batch_id IN NUMBER,
362: p_merge_type IN VARCHAR2,
363: p_from_party_id IN NUMBER,
364: p_to_party_id IN NUMBER,

Line 370: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL

366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
368: x_msg_data OUT NOCOPY VARCHAR2,
369: x_batch_party_id OUT NOCOPY NUMBER,
370: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL
371: ) IS
372:
373: l_api_name CONSTANT VARCHAR2(30) := 'create_merge_batch';
374: l_api_version CONSTANT NUMBER := 1.0;

Line 387: IF NOT FND_API.Compatible_API_Call(

383: -- standard start of API savepoint
384: SAVEPOINT create_merge_party;
385:
386: -- standard call to check for call compatibility.
387: IF NOT FND_API.Compatible_API_Call(
388: l_api_version,
389: p_api_version,
390: l_api_name,
391: G_PKG_NAME)

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

389: p_api_version,
390: l_api_name,
391: G_PKG_NAME)
392: THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
396: -- initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 397: IF FND_API.to_Boolean(p_init_msg_list) THEN

393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: END IF;
395:
396: -- initialize message list if p_init_msg_list is set to TRUE.
397: IF FND_API.to_Boolean(p_init_msg_list) THEN
398: FND_MSG_PUB.initialize;
399: END IF;
400:
401: -- initialize API return status to success.

Line 402: x_return_status := FND_API.G_RET_STS_SUCCESS;

398: FND_MSG_PUB.initialize;
399: END IF;
400:
401: -- initialize API return status to success.
402: x_return_status := FND_API.G_RET_STS_SUCCESS;
403:
404:
405: -- call to business logic.
406: do_create_merge_party(

Line 427: IF FND_API.to_Boolean(p_commit) THEN

423: insert_reln_parties(x_batch_party_id ,
424: l_batch_id );
425:
426: -- standard check of p_commit.
427: IF FND_API.to_Boolean(p_commit) THEN
428: COMMIT;
429: END IF;
430:
431: -- standard call to get message count and if count is 1, get message info.

Line 433: p_encoded => FND_API.G_FALSE,

429: END IF;
430:
431: -- standard call to get message count and if count is 1, get message info.
432: FND_MSG_PUB.Count_And_Get(
433: p_encoded => FND_API.G_FALSE,
434: p_count => x_msg_count,
435: p_data => x_msg_data);
436:
437: EXCEPTION

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: p_count => x_msg_count,
435: p_data => x_msg_data);
436:
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO create_merge_party;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436:
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO create_merge_party;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data);

Line 442: p_encoded => FND_API.G_FALSE,

438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO create_merge_party;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data);
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data);
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO create_merge_party;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get(
450: p_encoded => FND_API.G_FALSE,

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444: p_data => x_msg_data);
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO create_merge_party;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get(
450: p_encoded => FND_API.G_FALSE,
451: p_count => x_msg_count,
452: p_data => x_msg_data);

Line 450: p_encoded => FND_API.G_FALSE,

446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO create_merge_party;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get(
450: p_encoded => FND_API.G_FALSE,
451: p_count => x_msg_count,
452: p_data => x_msg_data);
453:
454: WHEN OTHERS THEN

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: p_data => x_msg_data);
453:
454: WHEN OTHERS THEN
455: ROLLBACK TO create_merge_party;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457:
458: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
460: FND_MSG_PUB.ADD;

Line 463: p_encoded => FND_API.G_FALSE,

459: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
460: FND_MSG_PUB.ADD;
461:
462: FND_MSG_PUB.Count_And_Get(
463: p_encoded => FND_API.G_FALSE,
464: p_count => x_msg_count,
465: p_data => x_msg_data);
466:
467: END create_merge_party;