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_MSG_PUB

Line 23: FND_MSG_PUB.initialize;

19: l_adapter_rec adapter_rec_type;
20: BEGIN
21:
22: savepoint create_adapter_pub;
23: FND_MSG_PUB.initialize;
24:
25: l_adapter_rec := p_adapter_rec;
26:
27: --Initialize API return status to success.

Line 99: FND_MSG_PUB.Count_And_Get(

95:
96: WHEN FND_API.G_EXC_ERROR THEN
97: ROLLBACK TO create_adapter_pub;
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: FND_MSG_PUB.Count_And_Get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);
103:

Line 107: FND_MSG_PUB.Count_And_Get(

103:
104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
105: ROLLBACK TO create_adapter_pub;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: FND_MSG_PUB.Count_And_Get(
108: p_encoded => FND_API.G_FALSE,
109: p_count => x_msg_count,
110: p_data => x_msg_data);
111:

Line 117: FND_MSG_PUB.ADD;

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,
121: p_data => x_msg_data);

Line 118: FND_MSG_PUB.Count_And_Get(

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,
121: p_data => x_msg_data);
122: END create_adapter;

Line 136: FND_MSG_PUB.initialize;

132:
133: BEGIN
134:
135: savepoint create_adapter_terr_pub;
136: FND_MSG_PUB.initialize;
137:
138: --Initialize API return status to success.
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140:

Line 164: FND_MSG_PUB.Count_And_Get(

160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO create_adapter_terr_pub;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(
165: p_encoded => FND_API.G_FALSE,
166: p_count => x_msg_count,
167: p_data => x_msg_data);
168:

Line 172: FND_MSG_PUB.Count_And_Get(

168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: ROLLBACK TO create_adapter_terr_pub;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MSG_PUB.Count_And_Get(
173: p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:

Line 182: FND_MSG_PUB.ADD;

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,
186: p_data => x_msg_data);

Line 183: FND_MSG_PUB.Count_And_Get(

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,
186: p_data => x_msg_data);
187: END create_adapter_terr;

Line 204: FND_MSG_PUB.initialize;

200: l_adapter_id NUMBER;
201: BEGIN
202:
203: savepoint update_adapter_pub;
204: FND_MSG_PUB.initialize;
205:
206: --Initialize API return status to success.
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:

Line 228: FND_MSG_PUB.ADD;

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:
232: px_object_version_number := NVL(l_object_version_number,1)+1;

Line 239: FND_MSG_PUB.ADD;

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:
243: validate_adapter(

Line 274: FND_MSG_PUB.Count_And_Get(

270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO update_adapter_pub;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: FND_MSG_PUB.Count_And_Get(
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:

Line 282: FND_MSG_PUB.Count_And_Get(

278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO update_adapter_pub;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.Count_And_Get(
283: p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286:

Line 292: FND_MSG_PUB.ADD;

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,
296: p_data => x_msg_data);

Line 293: FND_MSG_PUB.Count_And_Get(

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,
296: p_data => x_msg_data);
297: END update_adapter;

Line 314: FND_MSG_PUB.initialize;

310: l_territory_code VARCHAR2(30);
311: BEGIN
312:
313: savepoint update_adapter_terr_pub;
314: FND_MSG_PUB.initialize;
315:
316: --Initialize API return status to success.
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:

Line 340: FND_MSG_PUB.ADD;

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:
344: px_object_version_number := NVL(l_object_version_number,1)+1;

Line 351: FND_MSG_PUB.ADD;

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:
355: validate_adapter_terr(

Line 379: FND_MSG_PUB.Count_And_Get(

375:
376: WHEN FND_API.G_EXC_ERROR THEN
377: ROLLBACK TO update_adapter_terr_pub;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:

Line 387: FND_MSG_PUB.Count_And_Get(

383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO update_adapter_terr_pub;
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: FND_MSG_PUB.Count_And_Get(
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data);
391:

Line 397: FND_MSG_PUB.ADD;

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,
401: p_data => x_msg_data);

Line 398: FND_MSG_PUB.Count_And_Get(

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,
401: p_data => x_msg_data);
402: END update_adapter_terr;

Line 426: FND_MSG_PUB.Reset;

422: FUNCTION logerror(SQLERRM VARCHAR2 DEFAULT NULL)
423: RETURN VARCHAR2 IS
424: l_msg_data VARCHAR2(2000);
425: BEGIN
426: FND_MSG_PUB.Reset;
427:
428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
429: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
430: END LOOP;

Line 428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

424: l_msg_data VARCHAR2(2000);
425: BEGIN
426: FND_MSG_PUB.Reset;
427:
428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
429: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
430: END LOOP;
431: IF (SQLERRM IS NOT NULL) THEN
432: l_msg_data := l_msg_data || SQLERRM;

Line 429: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

425: BEGIN
426: FND_MSG_PUB.Reset;
427:
428: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
429: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
430: END LOOP;
431: IF (SQLERRM IS NOT NULL) THEN
432: l_msg_data := l_msg_data || SQLERRM;
433: END IF;

Line 469: FND_MSG_PUB.ADD;

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:
473: IF(l_message_format_code IS NULL OR l_message_format_code = FND_API.G_MISS_CHAR) THEN

Line 476: FND_MSG_PUB.ADD;

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:
480: IF(l_invoke_method_code IS NULL OR l_invoke_method_code = FND_API.G_MISS_CHAR) THEN

Line 483: FND_MSG_PUB.ADD;

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:
487: IF(l_maximum_batch_size IS NULL OR l_maximum_batch_size = FND_API.G_MISS_NUM) THEN

Line 490: FND_MSG_PUB.ADD;

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:
494: IF(l_default_batch_size IS NULL OR l_default_batch_size = FND_API.G_MISS_NUM) THEN

Line 497: FND_MSG_PUB.ADD;

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:
501: -- check adapter_content_source

Line 509: FND_MSG_PUB.ADD;

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;
513: ELSIF(p_create_update_flag = 'U') THEN

Line 519: FND_MSG_PUB.ADD;

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;
523: END IF;

Line 532: FND_MSG_PUB.ADD;

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;
536:

Line 544: FND_MSG_PUB.ADD;

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;
548:

Line 552: FND_MSG_PUB.ADD;

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:
556: EXCEPTION

Line 567: FND_MSG_PUB.ADD;

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(
571: p_create_update_flag IN VARCHAR2,

Line 612: FND_MSG_PUB.ADD;

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:
616: IF(l_territory_code IS NULL OR l_territory_code = FND_API.G_MISS_CHAR) THEN

Line 619: FND_MSG_PUB.ADD;

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:
623: -- if create a loc adapter territory, it can't be disabled and set to default 'Y'

Line 628: FND_MSG_PUB.ADD;

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:
632: -- check adapter_content_source

Line 638: FND_MSG_PUB.ADD;

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;
642:

Line 649: FND_MSG_PUB.ADD;

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;
653:

Line 660: FND_MSG_PUB.ADD;

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;
664: END IF;

Line 677: FND_MSG_PUB.ADD;

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:
681: END HZ_ADAPTER_PUB;