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_ORG_INFO_VALIDATE dependencies on FND_MSG_PUB

Line 31: FND_MSG_PUB.ADD;

27: if l_count = 0 then
28: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_LOOKUP');
29: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOCK_SYMBOL');
30: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', 'YES/NO');
31: FND_MSG_PUB.ADD;
32: end if;
33: END IF; */
34:
35: null;

Line 60: FND_MSG_PUB.ADD;

56: p_security_issued_rec.stock_exchange_id is NULL) THEN
57:
58: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
59: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
60: FND_MSG_PUB.ADD;
61: x_return_status := FND_API.G_RET_STS_ERROR;
62:
63:
64: END IF;

Line 81: FND_MSG_PUB.ADD;

77: if l_stock_exchange_id <> p_security_issued_rec.stock_exchange_id AND
78: p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM THEN
79: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
80: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
81: FND_MSG_PUB.ADD;
82: x_return_status := FND_API.G_RET_STS_ERROR;
83:
84: end if;
85:

Line 91: FND_MSG_PUB.ADD;

87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
89: FND_MESSAGE.SET_TOKEN('RECORD', 'security_issued');
90: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_security_issued_rec.stock_exchange_id));
91: FND_MSG_PUB.ADD;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93:
94: END;
95:

Line 115: FND_MSG_PUB.ADD;

111: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
112: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
113: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
114: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
115: FND_MSG_PUB.ADD;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117:
118: END IF;
119:

Line 134: FND_MSG_PUB.ADD;

130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
131: FND_MESSAGE.SET_TOKEN('FK', 'stock_exchange_id');
132: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');
133: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_stock_markets');
134: FND_MSG_PUB.ADD;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136:
137: END IF;
138:

Line 156: FND_MSG_PUB.ADD;

152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
153: FND_MESSAGE.SET_TOKEN('FK', 'security_currency_code');
154: FND_MESSAGE.SET_TOKEN('COLUMN', 'currency_code');
155: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');
156: FND_MSG_PUB.ADD;
157: x_return_status := FND_API.G_RET_STS_ERROR;
158:
159: end if;
160: END IF;

Line 171: FND_MSG_PUB.ADD;

167: if (p_security_issued_rec.end_date < p_security_issued_rec.begin_date OR
168: p_security_issued_rec.begin_date IS NULL OR
169: p_security_issued_rec.begin_date = FND_API.G_MISS_DATE) THEN
170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
171: FND_MSG_PUB.ADD;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: end if;
174: END IF;
175:

Line 184: FND_MSG_PUB.ADD;

180: if p_security_issued_rec.begin_date is NOT NULL AND
181: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE then
182: if p_security_issued_rec.end_date < p_security_issued_rec.begin_date then
183: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
184: FND_MSG_PUB.ADD;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186:
187: end if;
188: elsif (p_security_issued_rec.end_date < l_begin_date OR

Line 191: FND_MSG_PUB.ADD;

187: end if;
188: elsif (p_security_issued_rec.end_date < l_begin_date OR
189: l_begin_date is NULL ) then
190: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193:
194: end if;
195: elsif (p_security_issued_rec.begin_date is NOT NULL AND

Line 199: FND_MSG_PUB.ADD;

195: elsif (p_security_issued_rec.begin_date is NOT NULL AND
196: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE) THEN
197: if l_end_date < p_security_issued_rec.begin_date then
198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
199: FND_MSG_PUB.ADD;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201:
202: end if;
203: end if;

Line 235: FND_MSG_PUB.ADD;

231: p_financial_reports_rec.party_id is NULL) THEN
232:
233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
234: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
235: FND_MSG_PUB.ADD;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237:
238: END IF;
239:

Line 259: FND_MSG_PUB.ADD;

255: if l_party_id <> p_financial_reports_rec.party_id AND
256: p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM THEN
257: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
258: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
259: FND_MSG_PUB.ADD;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:
262: end if;
263: END IF;

Line 270: FND_MSG_PUB.ADD;

266: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
267: FND_MESSAGE.SET_TOKEN('RECORD', 'financial report');
268: FND_MESSAGE.SET_TOKEN('VALUE',
269: to_char(p_financial_reports_rec.financial_report_id));
270: FND_MSG_PUB.ADD;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: END;
274:

Line 291: FND_MSG_PUB.ADD;

287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
288: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
289: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
290: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
291: FND_MSG_PUB.ADD;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293:
294: END IF;
295:

Line 308: FND_MSG_PUB.ADD;

304: < p_financial_reports_rec.report_start_date OR
305: p_financial_reports_rec.report_start_date IS NULL OR
306: p_financial_reports_rec.report_start_date = FND_API.G_MISS_DATE) THEN
307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
308: FND_MSG_PUB.ADD;
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: end if;
312: END IF;

Line 323: FND_MSG_PUB.ADD;

319: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE then
320: if p_financial_reports_rec.report_end_date
321: < p_financial_reports_rec.report_start_date then
322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
323: FND_MSG_PUB.ADD;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325:
326: end if;
327: elsif ( p_financial_reports_rec.report_end_date < l_report_start_date OR

Line 330: FND_MSG_PUB.ADD;

326: end if;
327: elsif ( p_financial_reports_rec.report_end_date < l_report_start_date OR
328: l_report_start_date is NULL) then
329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
330: FND_MSG_PUB.ADD;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332:
333: end if;
334: elsif (p_financial_reports_rec.report_start_date is NOT NULL AND

Line 338: FND_MSG_PUB.ADD;

334: elsif (p_financial_reports_rec.report_start_date is NOT NULL AND
335: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE) THEN
336: if l_report_end_date < p_financial_reports_rec.report_start_date then
337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
338: FND_MSG_PUB.ADD;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340:
341: end if;
342: end if;

Line 358: FND_MSG_PUB.ADD;

354: IF l_content_source_type <> p_financial_reports_rec.content_source_type
355: OR p_financial_reports_rec.content_source_type IS NULL THEN
356: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
357: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
358: FND_MSG_PUB.ADD;
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361: END IF;
362:

Line 375: FND_MSG_PUB.ADD;

371: AND (p_financial_reports_rec.content_source_type IS NULL
372: OR p_financial_reports_rec.content_source_type = FND_API.G_MISS_CHAR) THEN
373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
374: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
375: FND_MSG_PUB.ADD;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: END IF;
378:
379: */

Line 428: FND_MSG_PUB.ADD;

424: p_financial_numbers_rec.financial_report_id is NULL) THEN
425:
426: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
427: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
428: FND_MSG_PUB.ADD;
429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431:
432: END IF;

Line 447: FND_MSG_PUB.ADD;

443: (l_financial_report_id <> p_financial_numbers_rec.financial_report_id)
444: THEN
445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
446: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
447: FND_MSG_PUB.ADD;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449:
450: END IF;
451:

Line 470: FND_MSG_PUB.ADD;

466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
467: FND_MESSAGE.SET_TOKEN('FK', 'financial_report_id');
468: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');
469: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_financial_reports');
470: FND_MSG_PUB.ADD;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472:
473: END;
474:

Line 491: FND_MSG_PUB.ADD;

487: IF l_content_source_type <> p_financial_numbers_rec.content_source_type
488: OR p_financial_numbers_rec.content_source_type IS NULL THEN
489: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
490: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
491: FND_MSG_PUB.ADD;
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: END IF;
494: END IF;
495:

Line 508: FND_MSG_PUB.ADD;

504: AND (p_financial_numbers_rec.content_source_type IS NULL
505: OR p_financial_numbers_rec.content_source_type = FND_API.G_MISS_CHAR) THEN
506: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
507: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
508: FND_MSG_PUB.ADD;
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: END IF;
511:
512: */

Line 554: FND_MSG_PUB.ADD;

550: p_certifications_rec.party_id is NULL) THEN
551:
552: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
553: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
554: FND_MSG_PUB.ADD;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556:
557: END IF;
558:

Line 567: FND_MSG_PUB.ADD;

563: p_certifications_rec.certification_name is NULL) THEN
564:
565: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
566: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_name');
567: FND_MSG_PUB.ADD;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569:
570: END IF;
571:

Line 585: FND_MSG_PUB.ADD;

581:
582: if l_party_id <> p_certifications_rec.party_id then
583: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
584: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_id');
585: FND_MSG_PUB.ADD;
586: x_return_status := FND_API.G_RET_STS_ERROR;
587:
588: end if;
589:

Line 607: FND_MSG_PUB.ADD;

603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
604: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
605: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
606: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
607: FND_MSG_PUB.ADD;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609:
610: END IF;
611:

Line 637: FND_MSG_PUB.ADD;

633: p_industrial_reference_rec.party_id is NULL) THEN
634:
635: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
636: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
637: FND_MSG_PUB.ADD;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639:
640:
641: END IF;

Line 651: FND_MSG_PUB.ADD;

647: p_industrial_reference_rec.industry_reference is NULL) THEN
648:
649: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
650: FND_MESSAGE.SET_TOKEN('COLUMN', 'industry_reference');
651: FND_MSG_PUB.ADD;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653:
654:
655: END IF;

Line 668: FND_MSG_PUB.ADD;

664: if l_party_id <> p_industrial_reference_rec.party_id AND
665: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM THEN
666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
667: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
668: FND_MSG_PUB.ADD;
669: x_return_status := FND_API.G_RET_STS_ERROR;
670:
671: end if;
672: END IF;

Line 689: FND_MSG_PUB.ADD;

685: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
686: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
687: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
688: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
689: FND_MSG_PUB.ADD;
690: x_return_status := FND_API.G_RET_STS_ERROR;
691:
692: END IF;
693:

Line 721: FND_MSG_PUB.ADD;

717: p_industrial_classes_rec.code_primary_segment is NULL) THEN
718:
719: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
720: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_primary_segment');
721: FND_MSG_PUB.ADD;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723:
724:
725: END IF;

Line 752: FND_MSG_PUB.ADD;

748: p_industrial_class_app_rec.party_id is NULL) THEN
749:
750: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
751: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
752: FND_MSG_PUB.ADD;
753: x_return_status := FND_API.G_RET_STS_ERROR;
754:
755: END IF;
756:

Line 765: FND_MSG_PUB.ADD;

761: p_industrial_class_app_rec.industrial_class_id is NULL) THEN
762:
763: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
764: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
765: FND_MSG_PUB.ADD;
766: x_return_status := FND_API.G_RET_STS_ERROR;
767:
768: END IF;
769:

Line 789: FND_MSG_PUB.ADD;

785: if l_party_id <> p_industrial_class_app_rec.party_id AND
786: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN
787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
788: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
789: FND_MSG_PUB.ADD;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791:
792: end if;
793:

Line 798: FND_MSG_PUB.ADD;

794: if l_industrial_class_id <> p_industrial_class_app_rec.industrial_class_id AND
795: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM THEN
796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
797: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
798: FND_MSG_PUB.ADD;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800:
801: end if;
802:

Line 808: FND_MSG_PUB.ADD;

804: EXCEPTION WHEN NO_DATA_FOUND THEN
805: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
806: FND_MESSAGE.SET_TOKEN('RECORD', 'industrial class applied');
807: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_industrial_class_app_rec.code_applied_id));
808: FND_MSG_PUB.ADD;
809: x_return_status := FND_API.G_RET_STS_ERROR;
810:
811: END;
812:

Line 833: FND_MSG_PUB.ADD;

829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
830: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
831: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
832: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
833: FND_MSG_PUB.ADD;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835:
836: END IF;
837:

Line 852: FND_MSG_PUB.ADD;

848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
849: FND_MESSAGE.SET_TOKEN('FK', 'industrial_class_id');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');
851: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_industrial_classes');
852: FND_MSG_PUB.ADD;
853: x_return_status := FND_API.G_RET_STS_ERROR;
854:
855: END IF;
856:

Line 870: FND_MSG_PUB.ADD;

866: < p_industrial_class_app_rec.begin_date OR
867: p_industrial_class_app_rec.begin_date IS NULL OR
868: p_industrial_class_app_rec.begin_date = FND_API.G_MISS_DATE) THEN
869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
870: FND_MSG_PUB.ADD;
871: x_return_status := FND_API.G_RET_STS_ERROR;
872:
873: end if;
874: END IF;

Line 886: FND_MSG_PUB.ADD;

882: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE then
883: if p_industrial_class_app_rec.end_date
884: 885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
886: FND_MSG_PUB.ADD;
887: x_return_status := FND_API.G_RET_STS_ERROR;
888:
889: end if;
890: elsif (p_industrial_class_app_rec.end_date < l_begin_date OR

Line 893: FND_MSG_PUB.ADD;

889: end if;
890: elsif (p_industrial_class_app_rec.end_date < l_begin_date OR
891: l_begin_date is NULL) then
892: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
893: FND_MSG_PUB.ADD;
894: x_return_status := FND_API.G_RET_STS_ERROR;
895:
896: end if;
897: elsif (p_industrial_class_app_rec.begin_date is NOT NULL AND

Line 901: FND_MSG_PUB.ADD;

897: elsif (p_industrial_class_app_rec.begin_date is NOT NULL AND
898: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE) THEN
899: if l_end_date < p_industrial_class_app_rec.begin_date then
900: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');
901: FND_MSG_PUB.ADD;
902: x_return_status := FND_API.G_RET_STS_ERROR;
903: end if;
904: end if;
905: END IF;