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

Line 96: p_column_value = fnd_api.g_miss_char)) OR

92:
93: IF p_restricted = 'N' THEN
94: IF (p_create_update_flag = 'C' AND
95: (p_column_value IS NULL OR
96: p_column_value = fnd_api.g_miss_char)) OR
97: (p_create_update_flag = 'U' AND
98: p_column_value = fnd_api.g_miss_char)
99: THEN
100: l_error := TRUE;

Line 98: p_column_value = fnd_api.g_miss_char)

94: IF (p_create_update_flag = 'C' AND
95: (p_column_value IS NULL OR
96: p_column_value = fnd_api.g_miss_char)) OR
97: (p_create_update_flag = 'U' AND
98: p_column_value = fnd_api.g_miss_char)
99: THEN
100: l_error := TRUE;
101: END IF;
102: ELSE

Line 104: p_column_value = fnd_api.g_miss_char)

100: l_error := TRUE;
101: END IF;
102: ELSE
103: IF (p_column_value IS NULL OR
104: p_column_value = fnd_api.g_miss_char)
105: THEN
106: l_error := TRUE;
107: END IF;
108: END IF;

Line 114: x_return_status := fnd_api.g_ret_sts_error;

110: IF l_error THEN
111: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
112: fnd_message.set_token('COLUMN', p_column);
113: fnd_msg_pub.add;
114: x_return_status := fnd_api.g_ret_sts_error;
115: END IF;
116:
117: END validate_mandatory;
118:

Line 144: p_column_value = fnd_api.g_miss_num)) OR

140:
141: IF p_restricted = 'N' THEN
142: IF (p_create_update_flag = 'C' AND
143: (p_column_value IS NULL OR
144: p_column_value = fnd_api.g_miss_num)) OR
145: (p_create_update_flag = 'U' AND
146: p_column_value = fnd_api.g_miss_num)
147: THEN
148: l_error := TRUE;

Line 146: p_column_value = fnd_api.g_miss_num)

142: IF (p_create_update_flag = 'C' AND
143: (p_column_value IS NULL OR
144: p_column_value = fnd_api.g_miss_num)) OR
145: (p_create_update_flag = 'U' AND
146: p_column_value = fnd_api.g_miss_num)
147: THEN
148: l_error := TRUE;
149: END IF;
150: ELSE

Line 152: p_column_value = fnd_api.g_miss_num)

148: l_error := TRUE;
149: END IF;
150: ELSE
151: IF (p_column_value IS NULL OR
152: p_column_value = fnd_api.g_miss_num)
153: THEN
154: l_error := TRUE;
155: END IF;
156: END IF;

Line 162: x_return_status := fnd_api.g_ret_sts_error;

158: IF l_error THEN
159: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
160: fnd_message.set_token('COLUMN', p_column);
161: fnd_msg_pub.add;
162: x_return_status := fnd_api.g_ret_sts_error;
163: END IF;
164:
165: END validate_mandatory;
166:

Line 168: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

164:
165: END validate_mandatory;
166:
167: PROCEDURE do_email_domain_transfer(
168: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
169: x_to_id IN OUT NOCOPY NUMBER,
170: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
171: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
172: x_return_status IN OUT NOCOPY VARCHAR2

Line 170: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

166:
167: PROCEDURE do_email_domain_transfer(
168: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
169: x_to_id IN OUT NOCOPY NUMBER,
170: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
171: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
172: x_return_status IN OUT NOCOPY VARCHAR2
173: ) IS
174:

Line 171: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

167: PROCEDURE do_email_domain_transfer(
168: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
169: x_to_id IN OUT NOCOPY NUMBER,
170: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
171: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
172: x_return_status IN OUT NOCOPY VARCHAR2
173: ) IS
174:
175: BEGIN

Line 177: IF NOT (x_to_id <> FND_API.G_MISS_NUM AND

173: ) IS
174:
175: BEGIN
176:
177: IF NOT (x_to_id <> FND_API.G_MISS_NUM AND
178: x_to_id <> p_from_id) THEN
179:
180: --commented out because this part we are doing in email_domain_merge
181: --procedure

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

201: WHEN OTHERS THEN
202: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
203: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: END do_email_domain_transfer;
207:
208: /**
209: * FUNCTION transpose_domain

Line 289: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

285: *
286: * ARGUMENTS
287: * IN:
288: * p_party_id Initialize message stack if it is set to
289: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
290: * p_domain_name Financial report record.
291: * IN/OUT:
292: * OUT:
293: * x_return_status Return status after the call. The status can

Line 294: * be FND_API.G_RET_STS_SUCCESS (success),

290: * p_domain_name Financial report record.
291: * IN/OUT:
292: * OUT:
293: * x_return_status Return status after the call. The status can
294: * be FND_API.G_RET_STS_SUCCESS (success),
295: * FND_API.G_RET_STS_ERROR (error),
296: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
297: * x_msg_count Number of messages in message stack.
298: * x_msg_data Message text if x_msg_count is 1.

Line 295: * FND_API.G_RET_STS_ERROR (error),

291: * IN/OUT:
292: * OUT:
293: * x_return_status Return status after the call. The status can
294: * be FND_API.G_RET_STS_SUCCESS (success),
295: * FND_API.G_RET_STS_ERROR (error),
296: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
297: * x_msg_count Number of messages in message stack.
298: * x_msg_data Message text if x_msg_count is 1.
299: *

Line 296: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

292: * OUT:
293: * x_return_status Return status after the call. The status can
294: * be FND_API.G_RET_STS_SUCCESS (success),
295: * FND_API.G_RET_STS_ERROR (error),
296: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
297: * x_msg_count Number of messages in message stack.
298: * x_msg_data Message text if x_msg_count is 1.
299: *
300: * NOTES

Line 349: x_return_status := fnd_api.g_ret_sts_error;

345: IF NVL(c_unique_email_domain%FOUND, FALSE) THEN
346: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
347: fnd_message.set_token('COLUMN', 'party_id and domain_name combination');
348: fnd_msg_pub.add;
349: x_return_status := fnd_api.g_ret_sts_error;
350: END IF;
351: CLOSE c_unique_email_domain;
352:
353: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 382: p_party_id <> fnd_api.g_miss_num

378:
379: -- party_id has foreign key HZ_PARTIES.PARTY_ID
380: IF p_party_id IS NOT NULL
381: AND
382: p_party_id <> fnd_api.g_miss_num
383: THEN
384: BEGIN
385: SELECT 'Y'
386: INTO l_dummy

Line 397: x_return_status := fnd_api.g_ret_sts_error;

393: fnd_message.set_token('FK', 'party_id');
394: fnd_message.set_token('COLUMN', 'party_id');
395: fnd_message.set_token('TABLE', 'hz_parties');
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.g_ret_sts_error;
398: END;
399:
400:
401: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

418:
419: -------------------------------
420: -- Insert into HZ_EMAIL_DOMAINS
421: -------------------------------
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: INSERT INTO HZ_EMAIL_DOMAINS(

Line 423: RAISE FND_API.G_EXC_ERROR;

419: -------------------------------
420: -- Insert into HZ_EMAIL_DOMAINS
421: -------------------------------
422: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: INSERT INTO HZ_EMAIL_DOMAINS(
427: EMAIL_DOMAIN_ID

Line 471: x_return_status := fnd_api.g_ret_sts_error;

467: fnd_message.set_token('FK', 'party_id');
468: fnd_message.set_token('COLUMN', 'party_id');
469: fnd_message.set_token('TABLE', 'hz_parties');
470: fnd_msg_pub.add;
471: x_return_status := fnd_api.g_ret_sts_error;
472:
473:
474: END;
475:

Line 476: x_return_status := FND_API.G_RET_STS_SUCCESS;

472:
473:
474: END;
475:
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: --disable_debug;
478:
479: EXCEPTION
480: WHEN FND_API.G_EXC_ERROR THEN

Line 480: WHEN FND_API.G_EXC_ERROR THEN

476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: --disable_debug;
478:
479: EXCEPTION
480: WHEN FND_API.G_EXC_ERROR THEN
481: ROLLBACK TO create_email_domain;
482: x_return_status := fnd_api.g_ret_sts_error;
483: WHEN OTHERS THEN
484: ROLLBACK TO create_email_domain;

Line 482: x_return_status := fnd_api.g_ret_sts_error;

478:
479: EXCEPTION
480: WHEN FND_API.G_EXC_ERROR THEN
481: ROLLBACK TO create_email_domain;
482: x_return_status := fnd_api.g_ret_sts_error;
483: WHEN OTHERS THEN
484: ROLLBACK TO create_email_domain;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: ROLLBACK TO create_email_domain;
482: x_return_status := fnd_api.g_ret_sts_error;
483: WHEN OTHERS THEN
484: ROLLBACK TO create_email_domain;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
487: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
488: FND_MSG_PUB.ADD;
489:

Line 493: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

489:
490: END create_email_domain;
491:
492: PROCEDURE email_domains_merge(
493: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
494: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
495: x_to_id IN OUT NOCOPY NUMBER,
496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 494: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

490: END create_email_domain;
491:
492: PROCEDURE email_domains_merge(
493: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
494: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
495: x_to_id IN OUT NOCOPY NUMBER,
496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

492: PROCEDURE email_domains_merge(
493: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
494: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
495: x_to_id IN OUT NOCOPY NUMBER,
496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
499: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
500: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

493: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
494: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
495: x_to_id IN OUT NOCOPY NUMBER,
496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
499: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
500: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
501: x_return_status OUT NOCOPY VARCHAR2

Line 498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

494: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
495: x_to_id IN OUT NOCOPY NUMBER,
496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
499: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
500: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
501: x_return_status OUT NOCOPY VARCHAR2
502:

Line 499: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,

495: x_to_id IN OUT NOCOPY NUMBER,
496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
499: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
500: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
501: x_return_status OUT NOCOPY VARCHAR2
502:
503: ) IS

Line 500: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,

496: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
497: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
498: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
499: p_batch_id IN NUMBER:=FND_API.G_MISS_NUM,
500: p_batch_party_id IN NUMBER:=FND_API.G_MISS_NUM,
501: x_return_status OUT NOCOPY VARCHAR2
502:
503: ) IS
504:

Line 511: l_to_id := FND_API.G_MISS_NUM;

507:
508: BEGIN
509:
510: IF (x_to_id IS NULL) THEN
511: l_to_id := FND_API.G_MISS_NUM;
512: ELSE
513: l_to_id := x_to_id;
514: END IF;
515:

Line 516: x_return_status := FND_API.G_RET_STS_SUCCESS;

512: ELSE
513: l_to_id := x_to_id;
514: END IF;
515:
516: x_return_status := FND_API.G_RET_STS_SUCCESS;
517:
518: check_params(p_entity_name, p_from_id, l_to_id, NULL,
519: p_from_id, p_par_entity_name,
520: 'HZ_EMAIL_DOMAINS_V2PUB.email_domains_merge',

Line 524: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN

520: 'HZ_EMAIL_DOMAINS_V2PUB.email_domains_merge',
521: 'HZ_EMAIL_DOMAINS','HZ_PARTIES',
522: 'EMAIL_DOMAIN_ID', 'PARTY_ID',x_return_status);
523:
524: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
525: l_dup_exists := HZ_EMAIL_DOMAINS_V2PUB.check_email_domain_dup(
526: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
527: x_return_status);
528: END IF;

Line 532: IF (x_return_status =FND_API.G_RET_STS_SUCCESS AND l_dup_exists = FND_API.G_FALSE) THEN

528: END IF;
529:
530: --since hz_email_domains does n't has its own id, p_from_id=p_from_fk_id
531: --and p_to_fk_id = party_id
532: IF (x_return_status =FND_API.G_RET_STS_SUCCESS AND l_dup_exists = FND_API.G_FALSE) THEN
533:
534: do_email_domain_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
535: x_return_status);
536: ELSIF (l_dup_exists = FND_API.G_TRUE) THEN

Line 536: ELSIF (l_dup_exists = FND_API.G_TRUE) THEN

532: IF (x_return_status =FND_API.G_RET_STS_SUCCESS AND l_dup_exists = FND_API.G_FALSE) THEN
533:
534: do_email_domain_transfer(p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
535: x_return_status);
536: ELSIF (l_dup_exists = FND_API.G_TRUE) THEN
537: UPDATE HZ_EMAIL_DOMAINS
538: SET
539: STATUS = 'M',
540: last_update_date = hz_utility_pub.last_update_date,

Line 553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

549: WHEN OTHERS THEN
550: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
551: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
552: FND_MSG_PUB.ADD;
553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: END email_domains_merge;
555:
556: FUNCTION check_email_domain_dup(
557: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 557: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
554: END email_domains_merge;
555:
556: FUNCTION check_email_domain_dup(
557: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
558: x_to_id IN OUT NOCOPY NUMBER,
559: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
560: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
561: x_return_status IN OUT NOCOPY VARCHAR2)

Line 559: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

555:
556: FUNCTION check_email_domain_dup(
557: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
558: x_to_id IN OUT NOCOPY NUMBER,
559: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
560: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
561: x_return_status IN OUT NOCOPY VARCHAR2)
562: RETURN VARCHAR2 IS
563:

Line 560: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

556: FUNCTION check_email_domain_dup(
557: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
558: x_to_id IN OUT NOCOPY NUMBER,
559: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
560: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
561: x_return_status IN OUT NOCOPY VARCHAR2)
562: RETURN VARCHAR2 IS
563:
564: CURSOR dupcheck IS

Line 576: x_to_id := FND_API.G_MISS_NUM;

572: l_record_id NUMBER;
573:
574: BEGIN
575:
576: x_to_id := FND_API.G_MISS_NUM;
577:
578: OPEN dupcheck;
579: FETCH dupcheck INTO l_record_id;
580: IF dupcheck%NOTFOUND THEN

Line 582: RETURN FND_API.G_FALSE;

578: OPEN dupcheck;
579: FETCH dupcheck INTO l_record_id;
580: IF dupcheck%NOTFOUND THEN
581: CLOSE dupcheck;
582: RETURN FND_API.G_FALSE;
583: END IF;
584:
585: x_to_id := l_record_id;
586: CLOSE dupcheck;

Line 587: RETURN FND_API.G_TRUE;

583: END IF;
584:
585: x_to_id := l_record_id;
586: CLOSE dupcheck;
587: RETURN FND_API.G_TRUE;
588:
589: END check_email_domain_dup;
590:
591: PROCEDURE check_params(

Line 592: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

588:
589: END check_email_domain_dup;
590:
591: PROCEDURE check_params(
592: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

Line 593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,

589: END check_email_domain_dup;
590:
591: PROCEDURE check_params(
592: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,

590:
591: PROCEDURE check_params(
592: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,

Line 595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

591: PROCEDURE check_params(
592: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,

592: p_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

593: p_from_id IN NUMBER:=FND_API.G_MISS_NUM,
594: p_to_id IN NUMBER:=FND_API.G_MISS_NUM,
595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
601: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

595: p_from_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
601: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
602: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
603: x_return_status IN OUT NOCOPY VARCHAR2

Line 600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,

596: p_to_fk_id IN NUMBER:=FND_API.G_MISS_NUM,
597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
601: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
602: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
603: x_return_status IN OUT NOCOPY VARCHAR2
604: ) IS

Line 601: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,

597: p_par_entity_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
601: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
602: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
603: x_return_status IN OUT NOCOPY VARCHAR2
604: ) IS
605:

Line 602: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,

598: p_proc_name IN VARCHAR2,
599: p_exp_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
600: p_exp_par_ent_name IN VARCHAR2:=FND_API.G_MISS_CHAR,
601: p_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
602: p_par_pk_column IN VARCHAR2:=FND_API.G_MISS_CHAR,
603: x_return_status IN OUT NOCOPY VARCHAR2
604: ) IS
605:
606: BEGIN

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
611: FND_MESSAGE.SET_TOKEN('PENTITY' ,p_par_entity_name);
612: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
613: FND_MSG_PUB.ADD;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616:
617: IF (p_from_id = FND_API.G_MISS_NUM) THEN
618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');

Line 617: IF (p_from_id = FND_API.G_MISS_NUM) THEN

613: FND_MSG_PUB.ADD;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616:
617: IF (p_from_id = FND_API.G_MISS_NUM) THEN
618: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_REC');
619: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: FND_MESSAGE.SET_TOKEN('ENTITY',p_entity_name);
621: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
622: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
623: FND_MSG_PUB.ADD;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626:
627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN

Line 627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND

623: FND_MSG_PUB.ADD;
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626:
627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);

Line 628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN

624: x_return_status := FND_API.G_RET_STS_ERROR;
625: END IF;
626:
627: IF (p_exp_par_ent_name <> FND_API.G_MISS_CHAR AND
628: p_to_fk_id = FND_API.G_MISS_NUM ) THEN
629: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_FROM_PAR_REC');
630: FND_MESSAGE.SET_TOKEN('MPROC' ,p_proc_name);
631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: FND_MESSAGE.SET_TOKEN('ENTITY',p_par_entity_name);
632: FND_MESSAGE.SET_TOKEN('PKCOL',p_pk_column);
633: FND_MESSAGE.SET_TOKEN('PKVALUE',p_to_id);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: END IF;
637: EXCEPTION
638: WHEN OTHERS THEN
639: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638: WHEN OTHERS THEN
639: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
640: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
641: FND_MSG_PUB.ADD;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: END check_params;
644:
645: ---------------- VJN INTRODUCED -----------------------------------------------------
646:

Line 747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

743: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
744: FND_MESSAGE.SET_TOKEN('PROC' ,'GET_EMAIL_DOMAINS');
745: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
746: FND_MSG_PUB.ADD;
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END get_email_domains ;
749:
750:
751: -- this will return the concatenation of all full domain names

Line 831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

827: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
828: FND_MESSAGE.SET_TOKEN('PROC' ,'FULL_DOMAIN');
829: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
830: FND_MSG_PUB.ADD;
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832:
833: END FULL_DOMAIN;
834:
835:

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: FND_MESSAGE.SET_NAME('AR', 'HZ_EMAIL_DOMAINS_V2PUB');
1015: FND_MESSAGE.SET_TOKEN('PROC' ,'CORE_DOMAIN');
1016: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019:
1020:
1021: END CORE_DOMAIN;
1022: