APPS.HZ_ORG_INFO_VALIDATE dependencies on FND_MESSAGE

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

24: WHERE lookup_type = 'STOCK_SYMBOL'
25: AND lookup_code = p_stock_markets_rec.stock_exchange_code;
26:
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;

Line 29: FND_MESSAGE.SET_TOKEN('COLUMN', 'STOCK_SYMBOL');

25: AND lookup_code = p_stock_markets_rec.stock_exchange_code;
26:
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; */

Line 30: FND_MESSAGE.SET_TOKEN('LOOKUP_TYPE', 'YES/NO');

26:
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:

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

54: p_security_issued_rec.stock_exchange_id = FND_API.G_MISS_NUM)) OR
55: (p_create_update_flag = 'U' AND
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:

Line 59: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');

55: (p_create_update_flag = 'U' AND
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:

Line 79: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

75: WHERE security_issued_id = p_security_issued_rec.security_issued_id;
76:
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:

Line 80: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

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

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

84: end if;
85:
86:
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;

Line 89: FND_MESSAGE.SET_TOKEN('RECORD', 'security_issued');

85:
86:
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:

Line 90: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_security_issued_rec.stock_exchange_id));

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

Line 111: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

107: FROM hz_parties
108: where party_id = p_security_issued_rec.party_id;
109:
110: IF l_count = 0 THEN
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;

Line 112: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

108: where party_id = p_security_issued_rec.party_id;
109:
110: IF l_count = 0 THEN
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;

Line 113: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

109:
110: IF l_count = 0 THEN
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:

Line 114: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

110: IF l_count = 0 THEN
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;

Line 130: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

126: FROM hz_stock_markets
127: where stock_exchange_id = p_security_issued_rec.stock_exchange_id;
128:
129: IF l_count = 0 THEN
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;

Line 131: FND_MESSAGE.SET_TOKEN('FK', 'stock_exchange_id');

127: where stock_exchange_id = p_security_issued_rec.stock_exchange_id;
128:
129: IF l_count = 0 THEN
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;

Line 132: FND_MESSAGE.SET_TOKEN('COLUMN', 'stock_exchange_id');

128:
129: IF l_count = 0 THEN
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:

Line 133: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_stock_markets');

129: IF l_count = 0 THEN
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;

Line 152: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

148: AND currency_flag = 'Y'
149: AND enabled_flag in ('Y', 'N');
150:
151: if l_count = 0 then
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;

Line 153: FND_MESSAGE.SET_TOKEN('FK', 'security_currency_code');

149: AND enabled_flag in ('Y', 'N');
150:
151: if l_count = 0 then
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;

Line 154: FND_MESSAGE.SET_TOKEN('COLUMN', 'currency_code');

150:
151: if l_count = 0 then
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:

Line 155: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');

151: if l_count = 0 then
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;

Line 170: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

166: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE THEN
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;

Line 183: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

179: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE) THEN
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;

Line 190: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

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

Line 198: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

194: end if;
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;

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

229: p_financial_reports_rec.party_id = FND_API.G_MISS_NUM)) OR
230: (p_create_update_flag = 'U' AND
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:

Line 234: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

230: (p_create_update_flag = 'U' AND
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;

Line 257: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

253: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE THEN
254:
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:

Line 258: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

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

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

262: end if;
263: END IF;
264:
265: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 267: FND_MESSAGE.SET_TOKEN('RECORD', 'financial report');

263: END IF;
264:
265: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 268: FND_MESSAGE.SET_TOKEN('VALUE',

264:
265: EXCEPTION WHEN NO_DATA_FOUND THEN
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:

Line 287: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

283: FROM hz_parties
284: where party_id = p_financial_reports_rec.party_id;
285:
286: IF l_count = 0 THEN
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;

Line 288: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

284: where party_id = p_financial_reports_rec.party_id;
285:
286: IF l_count = 0 THEN
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;

Line 289: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

285:
286: IF l_count = 0 THEN
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:

Line 290: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

286: IF l_count = 0 THEN
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;

Line 307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

303: if (p_financial_reports_rec.report_end_date
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;

Line 322: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

318: if p_financial_reports_rec.report_start_date is NOT NULL AND
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;

Line 329: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

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

Line 337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

333: end if;
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;

Line 356: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

352:
353: IF p_create_update_flag = 'U' THEN
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;

Line 357: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');

353: IF p_create_update_flag = 'U' THEN
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;

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

369:
370: IF p_create_update_flag = 'C'
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;

Line 374: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');

370: IF p_create_update_flag = 'C'
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:

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

422: p_financial_numbers_rec.financial_report_id = FND_API.G_MISS_NUM)) OR
423: (p_create_update_flag = 'U' AND
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:

Line 427: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');

423: (p_create_update_flag = 'U' AND
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:

Line 445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

441:
442: if (p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM) AND
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:

Line 446: FND_MESSAGE.SET_TOKEN('COLUMN', 'financial_report_id');

442: if (p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM) AND
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;

Line 466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

462: FROM HZ_FINANCIAL_REPORTS
463: where financial_report_id = p_financial_numbers_rec.financial_report_id;
464:
465: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 467: FND_MESSAGE.SET_TOKEN('FK', 'financial_report_id');

463: where financial_report_id = p_financial_numbers_rec.financial_report_id;
464:
465: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

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

464:
465: EXCEPTION WHEN NO_DATA_FOUND THEN
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:

Line 469: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_financial_reports');

465: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 489: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

485:
486: IF p_create_update_flag = 'U' THEN
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;

Line 490: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');

486: IF p_create_update_flag = 'U' THEN
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;

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

502:
503: IF p_create_update_flag = 'C'
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;

Line 507: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');

503: IF p_create_update_flag = 'C'
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:

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

548: p_certifications_rec.party_id = FND_API.G_MISS_NUM)) OR
549: (p_create_update_flag = 'U' AND
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:

Line 553: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

549: (p_create_update_flag = 'U' AND
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;

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

561: p_certifications_rec.certification_name = FND_API.G_MISS_CHAR)) OR
562: (p_create_update_flag = 'U' AND
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:

Line 566: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_name');

562: (p_create_update_flag = 'U' AND
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;

Line 583: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

579: FROM HZ_CERTIFICATIONS
580: WHERE certification_id = p_certifications_rec.certification_id;
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:

Line 584: FND_MESSAGE.SET_TOKEN('COLUMN', 'certification_id');

580: WHERE certification_id = p_certifications_rec.certification_id;
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;

Line 603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

599: FROM HZ_PARTIES
600: WHERE party_id = p_certifications_rec.party_id;
601:
602: if l_count = 0 then
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;

Line 604: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

600: WHERE party_id = p_certifications_rec.party_id;
601:
602: if l_count = 0 then
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;

Line 605: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

601:
602: if l_count = 0 then
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:

Line 606: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

602: if l_count = 0 then
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;

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

631: p_industrial_reference_rec.party_id = FND_API.G_MISS_NUM)) OR
632: (p_create_update_flag = 'U' AND
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:

Line 636: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

632: (p_create_update_flag = 'U' AND
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:

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

645: p_industrial_reference_rec.industry_reference = FND_API.G_MISS_CHAR)) OR
646: (p_create_update_flag = 'U' AND
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:

Line 650: FND_MESSAGE.SET_TOKEN('COLUMN', 'industry_reference');

646: (p_create_update_flag = 'U' AND
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:

Line 666: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

662: WHERE INDUSTRY_REFERENCE_ID = p_industrial_reference_rec.INDUSTRY_REFERENCE_ID;
663:
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:

Line 667: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

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

Line 685: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

681: FROM HZ_PARTIES
682: WHERE party_id = p_industrial_reference_rec.party_id;
683:
684: if l_count = 0 then
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;

Line 686: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

682: WHERE party_id = p_industrial_reference_rec.party_id;
683:
684: if l_count = 0 then
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;

Line 687: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

683:
684: if l_count = 0 then
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:

Line 688: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

684: if l_count = 0 then
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;

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

715: p_industrial_classes_rec.code_primary_segment = FND_API.G_MISS_CHAR)) OR
716: (p_create_update_flag = 'U' AND
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:

Line 720: FND_MESSAGE.SET_TOKEN('COLUMN', 'code_primary_segment');

716: (p_create_update_flag = 'U' AND
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:

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

746: p_industrial_class_app_rec.party_id = FND_API.G_MISS_NUM)) OR
747: (p_create_update_flag = 'U' AND
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:

Line 751: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

747: (p_create_update_flag = 'U' AND
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;

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

759: p_industrial_class_app_rec.industrial_class_id = FND_API.G_MISS_NUM)) OR
760: (p_create_update_flag = 'U' AND
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:

Line 764: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');

760: (p_create_update_flag = 'U' AND
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;

Line 787: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

783: WHERE code_applied_id= p_industrial_class_app_rec.code_applied_id;
784:
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:

Line 788: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

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

Line 796: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');

792: end if;
793:
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:

Line 797: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');

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

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

801: end if;
802:
803:
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;

Line 806: FND_MESSAGE.SET_TOKEN('RECORD', 'industrial class applied');

802:
803:
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:

Line 807: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_industrial_class_app_rec.code_applied_id));

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

Line 829: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

825: FROM hz_parties
826: where party_id = p_industrial_class_app_rec.party_id;
827:
828: IF l_count = 0 THEN
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;

Line 830: FND_MESSAGE.SET_TOKEN('FK', 'party_id');

826: where party_id = p_industrial_class_app_rec.party_id;
827:
828: IF l_count = 0 THEN
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;

Line 831: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

827:
828: IF l_count = 0 THEN
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:

Line 832: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

828: IF l_count = 0 THEN
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;

Line 848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

844: FROM hz_industrial_classes
845: where industrial_class_id = p_industrial_class_app_rec.industrial_class_id;
846:
847: IF l_count = 0 THEN
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;

Line 849: FND_MESSAGE.SET_TOKEN('FK', 'industrial_class_id');

845: where industrial_class_id = p_industrial_class_app_rec.industrial_class_id;
846:
847: IF l_count = 0 THEN
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;

Line 850: FND_MESSAGE.SET_TOKEN('COLUMN', 'industrial_class_id');

846:
847: IF l_count = 0 THEN
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:

Line 851: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_industrial_classes');

847: IF l_count = 0 THEN
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;

Line 869: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

865: if (p_industrial_class_app_rec.end_date
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;

Line 885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

881: if p_industrial_class_app_rec.begin_date is NOT NULL AND
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;

Line 892: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

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

Line 900: FND_MESSAGE.SET_NAME('AR', 'HZ_API_START_DATE_GREATER');

896: end if;
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;