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_ADAPTER_PUB dependencies on FND_MESSAGE

Line 115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

111:
112: WHEN OTHERS THEN
113: ROLLBACK TO create_adapter_pub;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
117: FND_MSG_PUB.ADD;
118: FND_MSG_PUB.Count_And_Get(
119: p_encoded => FND_API.G_FALSE,

Line 116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

112: WHEN OTHERS THEN
113: ROLLBACK TO create_adapter_pub;
114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
117: FND_MSG_PUB.ADD;
118: FND_MSG_PUB.Count_And_Get(
119: p_encoded => FND_API.G_FALSE,
120: p_count => x_msg_count,

Line 180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

176:
177: WHEN OTHERS THEN
178: ROLLBACK TO create_adapter_terr_pub;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.Count_And_Get(
184: p_encoded => FND_API.G_FALSE,

Line 181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

177: WHEN OTHERS THEN
178: ROLLBACK TO create_adapter_terr_pub;
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
181: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
182: FND_MSG_PUB.ADD;
183: FND_MSG_PUB.Count_And_Get(
184: p_encoded => FND_API.G_FALSE,
185: p_count => x_msg_count,

Line 226: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

222: ( px_object_version_number IS NOT NULL AND
223: l_object_version_number IS NOT NULL AND
224: px_object_version_number = l_object_version_number ) )
225: THEN
226: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;

Line 227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );

223: l_object_version_number IS NOT NULL AND
224: px_object_version_number = l_object_version_number ) )
225: THEN
226: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
227: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:

Line 236: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

232: px_object_version_number := NVL(l_object_version_number,1)+1;
233:
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
237: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
238: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_ERROR;

Line 237: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );

233:
234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
237: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
238: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_ERROR;
241: END;

Line 238: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);

234: EXCEPTION
235: WHEN NO_DATA_FOUND THEN
236: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
237: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
238: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
239: FND_MSG_PUB.ADD;
240: RAISE FND_API.G_EXC_ERROR;
241: END;
242:

Line 290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

286:
287: WHEN OTHERS THEN
288: ROLLBACK TO update_adapter_pub;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_encoded => FND_API.G_FALSE,

Line 291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

287: WHEN OTHERS THEN
288: ROLLBACK TO update_adapter_pub;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
291: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(
294: p_encoded => FND_API.G_FALSE,
295: p_count => x_msg_count,

Line 338: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

334: ( px_object_version_number IS NOT NULL AND
335: l_object_version_number IS NOT NULL AND
336: px_object_version_number = l_object_version_number ) )
337: THEN
338: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
339: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
340: FND_MSG_PUB.ADD;
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;

Line 339: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );

335: l_object_version_number IS NOT NULL AND
336: px_object_version_number = l_object_version_number ) )
337: THEN
338: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
339: FND_MESSAGE.SET_TOKEN( 'TABLE', 'HZ_ADAPTERS' );
340: FND_MSG_PUB.ADD;
341: RAISE FND_API.G_EXC_ERROR;
342: END IF;
343:

Line 348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

344: px_object_version_number := NVL(l_object_version_number,1)+1;
345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
349: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
350: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;

Line 349: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );

345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
349: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
350: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;
353: END;

Line 350: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);

346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
349: FND_MESSAGE.SET_TOKEN( 'RECORD', 'Adapter' );
350: FND_MESSAGE.SET_TOKEN( 'VALUE', l_adapter_id);
351: FND_MSG_PUB.ADD;
352: RAISE FND_API.G_EXC_ERROR;
353: END;
354:

Line 395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

391:
392: WHEN OTHERS THEN
393: ROLLBACK TO update_adapter_terr_pub;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
397: FND_MSG_PUB.ADD;
398: FND_MSG_PUB.Count_And_Get(
399: p_encoded => FND_API.G_FALSE,

Line 396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

392: WHEN OTHERS THEN
393: ROLLBACK TO update_adapter_terr_pub;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
396: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
397: FND_MSG_PUB.ADD;
398: FND_MSG_PUB.Count_And_Get(
399: p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,

Line 467: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

463: l_default_batch_size := p_adapter_rec.default_batch_size;
464:
465: -- check not null first
466: IF(l_adapter_content_source IS NULL OR l_adapter_content_source = FND_API.G_MISS_CHAR) THEN
467: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
468: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_CONTENT_SOURCE');
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;

Line 468: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_CONTENT_SOURCE');

464:
465: -- check not null first
466: IF(l_adapter_content_source IS NULL OR l_adapter_content_source = FND_API.G_MISS_CHAR) THEN
467: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
468: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_CONTENT_SOURCE');
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472:

Line 474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

470: RAISE FND_API.G_EXC_ERROR;
471: END IF;
472:
473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN
474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
475: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;

Line 475: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');

471: END IF;
472:
473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN
474: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
475: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
476: FND_MSG_PUB.ADD;
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:

Line 481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN
481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
482: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;

Line 482: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');

478: END IF;
479:
480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN
481: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
482: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
483: FND_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:

Line 488: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN
488: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
489: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MAXIMUM_BATCH_SIZE');
490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;

Line 489: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MAXIMUM_BATCH_SIZE');

485: END IF;
486:
487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN
488: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
489: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MAXIMUM_BATCH_SIZE');
490: FND_MSG_PUB.ADD;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:

Line 495: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN
495: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
496: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DEFAULT_BATCH_SIZE');
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;
499: END IF;

Line 496: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DEFAULT_BATCH_SIZE');

492: END IF;
493:
494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN
495: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
496: FND_MESSAGE.SET_TOKEN('COLUMN' ,'DEFAULT_BATCH_SIZE');
497: FND_MSG_PUB.ADD;
498: RAISE FND_API.G_EXC_ERROR;
499: END IF;
500:

Line 508: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_DUP_ADPT');

504: FETCH check_lookup INTO l_dummy;
505: -- if found, then raise error saying already exist
506: IF(check_lookup%FOUND) THEN
507: -- error saying that content source already exist
508: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_DUP_ADPT');
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512: CLOSE check_lookup;

Line 518: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');

514: OPEN check_lookup(l_adapter_content_source, 'CONTENT_SOURCE_TYPE');
515: FETCH check_lookup INTO l_dummy;
516: IF(check_lookup%NOTFOUND) THEN
517: -- error saying that content source not found
518: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522: CLOSE check_lookup;

Line 529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');

525: -- check message_format_code
526: OPEN check_lookup(l_message_format_code, 'HZ_MESSAGE_FORMAT');
527: FETCH check_lookup INTO l_dummy;
528: IF(check_lookup%NOTFOUND) THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
530: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
531: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_MESSAGE_FORMAT');
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;

Line 530: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');

526: OPEN check_lookup(l_message_format_code, 'HZ_MESSAGE_FORMAT');
527: FETCH check_lookup INTO l_dummy;
528: IF(check_lookup%NOTFOUND) THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
530: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
531: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_MESSAGE_FORMAT');
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;

Line 531: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_MESSAGE_FORMAT');

527: FETCH check_lookup INTO l_dummy;
528: IF(check_lookup%NOTFOUND) THEN
529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
530: FND_MESSAGE.SET_TOKEN('COLUMN' ,'MESSAGE_FORMAT_CODE');
531: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_MESSAGE_FORMAT');
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE check_lookup;

Line 541: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');

537: -- check invoke_method_code
538: OPEN check_lookup(l_invoke_method_code, 'HZ_INVOKE_METHOD');
539: FETCH check_lookup INTO l_dummy;
540: IF(check_lookup%NOTFOUND) THEN
541: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
542: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
543: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_INVOKE_METHOD');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;

Line 542: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');

538: OPEN check_lookup(l_invoke_method_code, 'HZ_INVOKE_METHOD');
539: FETCH check_lookup INTO l_dummy;
540: IF(check_lookup%NOTFOUND) THEN
541: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
542: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
543: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_INVOKE_METHOD');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;

Line 543: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_INVOKE_METHOD');

539: FETCH check_lookup INTO l_dummy;
540: IF(check_lookup%NOTFOUND) THEN
541: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
542: FND_MESSAGE.SET_TOKEN('COLUMN' ,'INVOKE_METHOD_CODE');
543: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE' , 'HZ_INVOKE_METHOD');
544: FND_MSG_PUB.ADD;
545: RAISE FND_API.G_EXC_ERROR;
546: END IF;
547: CLOSE check_lookup;

Line 551: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_BATCH_SIZE');

547: CLOSE check_lookup;
548:
549: -- check maximum_batch_size and default_batch_size
550: IF((l_maximum_batch_size < 1) OR (l_default_batch_size < 1))THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_BATCH_SIZE');
552: FND_MSG_PUB.ADD;
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555:

Line 565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
562:
563: WHEN OTHERS THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
567: FND_MSG_PUB.ADD;
568: END validate_adapter;
569:

Line 566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

562:
563: WHEN OTHERS THEN
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
566: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
567: FND_MSG_PUB.ADD;
568: END validate_adapter;
569:
570: PROCEDURE validate_adapter_terr(

Line 610: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

606: l_default_flag := p_adapter_terr_rec.default_flag;
607:
608: -- check not null
609: IF(l_adapter_id IS NULL OR l_adapter_id = FND_API.G_MISS_NUM) THEN
610: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
611: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_ID');
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;

Line 611: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_ID');

607:
608: -- check not null
609: IF(l_adapter_id IS NULL OR l_adapter_id = FND_API.G_MISS_NUM) THEN
610: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
611: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADAPTER_ID');
612: FND_MSG_PUB.ADD;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:

Line 617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
618: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
619: FND_MSG_PUB.ADD;
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;

Line 618: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');

614: END IF;
615:
616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN
617: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
618: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
619: FND_MSG_PUB.ADD;
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:

Line 626: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

622:
623: -- if create a loc adapter territory, it can't be disabled and set to default 'Y'
624: -- give message saying that this setting is not allowed
625: IF((l_enabled_flag = 'N') AND (l_default_flag = 'Y')) THEN
626: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
627: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
628: FND_MSG_PUB.ADD;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;

Line 627: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');

623: -- if create a loc adapter territory, it can't be disabled and set to default 'Y'
624: -- give message saying that this setting is not allowed
625: IF((l_enabled_flag = 'N') AND (l_default_flag = 'Y')) THEN
626: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
627: FND_MESSAGE.SET_TOKEN('COLUMN' ,'TERRITORY_CODE');
628: FND_MSG_PUB.ADD;
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631:

Line 637: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');

633: -- if not found, then raise error saying adapter_content_source not exist
634: OPEN check_adapter(l_adapter_id);
635: FETCH check_adapter INTO l_dummy;
636: IF(check_adapter%NOTFOUND) THEN
637: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641: CLOSE check_adapter;

Line 648: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_TERRITORY');

644: -- if not found, then raise error saying territory_code not exist
645: OPEN check_terr(l_territory_code);
646: FETCH check_terr INTO l_dummy;
647: IF(check_terr%NOTFOUND) THEN
648: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_TERRITORY');
649: FND_MSG_PUB.ADD;
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652: CLOSE check_terr;

Line 659: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_DEFAULT');

655: IF(l_default_flag = 'Y') THEN
656: OPEN check_terr_default(l_adapter_id, l_territory_code);
657: FETCH check_terr_default INTO l_dummy;
658: IF(check_terr_default%FOUND) THEN
659: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_DEFAULT');
660: FND_MSG_PUB.ADD;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;
663: CLOSE check_terr_default;

Line 675: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678:
679: END validate_adapter_terr;

Line 676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

672:
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
676: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
677: FND_MSG_PUB.ADD;
678:
679: END validate_adapter_terr;
680: