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_API

Line 20: p_stock_markets_rec.stock_exchange_code <> FND_API.G_MISS_CHAR THEN

16: -- validate stock_exchange_code, lookup_type with ?
17: -- comment out the validation below
18: -- because the lookup has not been creasted yet.
19: /* IF p_stock_markets_rec.stock_exchange_code is NOT NULL and
20: p_stock_markets_rec.stock_exchange_code <> FND_API.G_MISS_CHAR THEN
21: SELECT count(*)
22: INTO l_count
23: FROM AR_LOOKUPS
24: WHERE lookup_type = 'STOCK_SYMBOL'

Line 54: p_security_issued_rec.stock_exchange_id = FND_API.G_MISS_NUM)) OR

50: BEGIN
51: -- check required field:
52: IF (p_create_update_flag = 'C' AND
53: (p_security_issued_rec.stock_exchange_id is NULL OR
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');

Line 61: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 68: (p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM OR

64: END IF;
65:
66: -- check non-updateable field: stock_exchange_id
67: if (p_create_update_flag = 'U' AND
68: (p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM OR
69: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE OR
70: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE )) THEN
71: BEGIN
72: SELECT stock_exchange_id, begin_date, end_date

Line 69: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE OR

65:
66: -- check non-updateable field: stock_exchange_id
67: if (p_create_update_flag = 'U' AND
68: (p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM OR
69: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE OR
70: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE )) THEN
71: BEGIN
72: SELECT stock_exchange_id, begin_date, end_date
73: INTO l_stock_exchange_id, l_begin_date, l_end_date

Line 70: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE )) THEN

66: -- check non-updateable field: stock_exchange_id
67: if (p_create_update_flag = 'U' AND
68: (p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM OR
69: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE OR
70: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE )) THEN
71: BEGIN
72: SELECT stock_exchange_id, begin_date, end_date
73: INTO l_stock_exchange_id, l_begin_date, l_end_date
74: FROM HZ_SECURITY_ISSUED

Line 78: p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM THEN

74: FROM HZ_SECURITY_ISSUED
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;

Line 82: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 92: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 104: p_security_issued_rec.party_id <> FND_API.G_MISS_NUM THEN

100: -- security_currency_code to fnd_currencies.
101:
102:
103: IF p_security_issued_rec.party_id is NOT NULL AND
104: p_security_issued_rec.party_id <> FND_API.G_MISS_NUM THEN
105:
106: SELECT COUNT(*) INTO l_count
107: FROM hz_parties
108: where party_id = p_security_issued_rec.party_id;

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 123: p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM THEN

119:
120: END IF;
121:
122: IF p_security_issued_rec.stock_exchange_id is NOT NULL AND
123: p_security_issued_rec.stock_exchange_id <> FND_API.G_MISS_NUM THEN
124:
125: SELECT COUNT(*) INTO l_count
126: FROM hz_stock_markets
127: where stock_exchange_id = p_security_issued_rec.stock_exchange_id;

Line 135: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 142: p_security_issued_rec.security_currency_code <> FND_API.G_MISS_CHAR THEN

138:
139: END IF;
140:
141: IF p_security_issued_rec.security_currency_code is NOT NULL AND
142: p_security_issued_rec.security_currency_code <> FND_API.G_MISS_CHAR THEN
143:
144: SELECT count(*)
145: INTO l_count
146: FROM fnd_currencies

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 166: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE THEN

162: -- end_date should be greater than begin_date
163:
164: IF p_create_update_flag = 'C' THEN
165: IF p_security_issued_rec.end_date is NOT NULL AND
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');

Line 169: p_security_issued_rec.begin_date = FND_API.G_MISS_DATE) THEN

165: IF p_security_issued_rec.end_date is NOT NULL AND
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;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

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:
176: -- compare end_date with database data and user passed data.

Line 179: p_security_issued_rec.end_date <> FND_API.G_MISS_DATE) THEN

175:
176: -- compare end_date with database data and user passed data.
177: ELSIF p_create_update_flag = 'U' THEN
178: if (p_security_issued_rec.end_date is NOT NULL AND
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');

Line 181: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE then

177: ELSIF p_create_update_flag = 'U' THEN
178: if (p_security_issued_rec.end_date is NOT NULL AND
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;

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

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
189: l_begin_date is NULL ) then

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

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
196: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE) THEN

Line 196: p_security_issued_rec.begin_date <> FND_API.G_MISS_DATE) THEN

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

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 229: p_financial_reports_rec.party_id = FND_API.G_MISS_NUM)) OR

225:
226: -- mandatory fields
227: IF (p_create_update_flag = 'C' AND
228: (p_financial_reports_rec.party_id is NULL OR
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');

Line 236: x_return_status := FND_API.G_RET_STS_ERROR;

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:
240: -- non updateable field

Line 251: IF p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM OR

247: l_report_end_date, l_content_source_type, db_actual_content_source
248: FROM HZ_FINANCIAL_REPORTS
249: WHERE financial_report_id= p_financial_reports_rec.financial_report_id;
250:
251: IF p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM OR
252: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE OR
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

Line 252: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE OR

248: FROM HZ_FINANCIAL_REPORTS
249: WHERE financial_report_id= p_financial_reports_rec.financial_report_id;
250:
251: IF p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM OR
252: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE OR
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

Line 253: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE THEN

249: WHERE financial_report_id= p_financial_reports_rec.financial_report_id;
250:
251: IF p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM OR
252: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE OR
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');

Line 256: p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM THEN

252: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE OR
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;

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 280: p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM THEN

276:
277: -- foreign keys: party_id to HZ_PARTIES table
278:
279: IF p_financial_reports_rec.party_id is NOT NULL AND
280: p_financial_reports_rec.party_id <> FND_API.G_MISS_NUM THEN
281:
282: SELECT COUNT(*) INTO l_count
283: FROM hz_parties
284: where party_id = p_financial_reports_rec.party_id;

Line 292: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 302: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE THEN

298: -- report_end_date should be greater than report_start_date
299:
300: IF p_create_update_flag = 'C' THEN
301: IF p_financial_reports_rec.report_end_date is NOT NULL AND
302: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE THEN
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

Line 306: p_financial_reports_rec.report_start_date = FND_API.G_MISS_DATE) THEN

302: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE THEN
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:

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 317: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE) THEN

313:
314: -- compare end_date with database data and user passed data.
315: ELSIF p_create_update_flag = 'U' THEN
316: if (p_financial_reports_rec.report_end_date is NOT NULL AND
317: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE) THEN
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

Line 319: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE then

315: ELSIF p_create_update_flag = 'U' THEN
316: if (p_financial_reports_rec.report_end_date is NOT NULL AND
317: p_financial_reports_rec.report_end_date <> FND_API.G_MISS_DATE) THEN
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;

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

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
328: l_report_start_date is NULL) then

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

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
335: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE) THEN

Line 335: p_financial_reports_rec.report_start_date <> FND_API.G_MISS_DATE) THEN

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

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 359: x_return_status := FND_API.G_RET_STS_ERROR;

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:
363: hz_common_pub.validate_lookup(

Line 372: OR p_financial_reports_rec.content_source_type = FND_API.G_MISS_CHAR) THEN

368: );
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;

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

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: */
380:

Line 422: p_financial_numbers_rec.financial_report_id = FND_API.G_MISS_NUM)) OR

418: -- mandatory field: financial_report_id
419:
420: IF (p_create_update_flag = 'C' AND
421: (p_financial_numbers_rec.financial_report_id is NULL OR
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');

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 442: if (p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM) AND

438: INTO l_financial_report_id, db_content_source_type
439: FROM HZ_FINANCIAL_NUMBERS
440: WHERE financial_number_id = p_financial_numbers_rec.financial_number_id;
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');

Line 448: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 457: p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM THEN

453:
454: -- foreign keys: financial_report_id to HZ_FINANCIAL_REPORTS table
455:
456: IF p_financial_numbers_rec.financial_report_id is NOT NULL AND
457: p_financial_numbers_rec.financial_report_id <> FND_API.G_MISS_NUM THEN
458:
459: BEGIN
460: SELECT content_source_type, actual_content_source
461: INTO x_rep_content_source_type, x_rep_actual_content_source

Line 471: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

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:
496: hz_common_pub.validate_lookup(

Line 505: OR p_financial_numbers_rec.content_source_type = FND_API.G_MISS_CHAR) THEN

501: );
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;

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

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: */
513:

Line 548: p_certifications_rec.party_id = FND_API.G_MISS_NUM)) OR

544: BEGIN
545: -- check required field: party_id, certification_name
546: IF (p_create_update_flag = 'C' AND
547: (p_certifications_rec.party_id is NULL OR
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');

Line 555: x_return_status := FND_API.G_RET_STS_ERROR;

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:
559: IF (p_create_update_flag = 'C' AND

Line 561: p_certifications_rec.certification_name = FND_API.G_MISS_CHAR)) OR

557: END IF;
558:
559: IF (p_create_update_flag = 'C' AND
560: (p_certifications_rec.certification_name is NULL OR
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');

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

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:
572: -- non-updateable field: party_id

Line 575: p_certifications_rec.party_id <> FND_API.G_MISS_NUM) THEN

571:
572: -- non-updateable field: party_id
573:
574: IF (p_create_update_flag = 'U' AND
575: p_certifications_rec.party_id <> FND_API.G_MISS_NUM) THEN
576:
577: SELECT party_id
578: INTO l_party_id
579: FROM HZ_CERTIFICATIONS

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 595: p_certifications_rec.party_id <> FND_API.G_MISS_NUM THEN

591:
592: -- check foreign key : party_id to hz_parties.
593:
594: IF p_certifications_rec.party_id is NOT NULL AND
595: p_certifications_rec.party_id <> FND_API.G_MISS_NUM THEN
596:
597: SELECT count(*)
598: INTO l_count
599: FROM HZ_PARTIES

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 631: p_industrial_reference_rec.party_id = FND_API.G_MISS_NUM)) OR

627: BEGIN
628: -- mandatory fields : party_id, industrial_reference
629: IF (p_create_update_flag = 'C' AND
630: (p_industrial_reference_rec.party_id is NULL OR
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');

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 645: p_industrial_reference_rec.industry_reference = FND_API.G_MISS_CHAR)) OR

641: END IF;
642:
643: IF (p_create_update_flag = 'C' AND
644: (p_industrial_reference_rec.industry_reference is NULL OR
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');

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 658: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM) THEN

654:
655: END IF;
656:
657: IF (p_create_update_flag = 'U' AND
658: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM) THEN
659: SELECT party_id
660: INTO l_party_id
661: FROM HZ_INDUSTRIAL_REFERENCE
662: WHERE INDUSTRY_REFERENCE_ID = p_industrial_reference_rec.INDUSTRY_REFERENCE_ID;

Line 665: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM THEN

661: FROM HZ_INDUSTRIAL_REFERENCE
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;

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 677: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM THEN

673:
674: -- check foreign key : party_id to hz_parties.
675:
676: IF p_industrial_reference_rec.party_id is NOT NULL AND
677: p_industrial_reference_rec.party_id <> FND_API.G_MISS_NUM THEN
678:
679: SELECT count(*)
680: INTO l_count
681: FROM HZ_PARTIES

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 715: p_industrial_classes_rec.code_primary_segment = FND_API.G_MISS_CHAR)) OR

711: -- check required field: code_primary_segment
712:
713: IF (p_create_update_flag = 'C' AND
714: (p_industrial_classes_rec.code_primary_segment is NULL OR
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');

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 746: p_industrial_class_app_rec.party_id = FND_API.G_MISS_NUM)) OR

742:
743: -- mandatory fields : party_id, industrial_class_id
744: IF (p_create_update_flag = 'C' AND
745: (p_industrial_class_app_rec.party_id is NULL OR
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');

Line 753: x_return_status := FND_API.G_RET_STS_ERROR;

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:
757: IF (p_create_update_flag = 'C' AND

Line 759: p_industrial_class_app_rec.industrial_class_id = FND_API.G_MISS_NUM)) OR

755: END IF;
756:
757: IF (p_create_update_flag = 'C' AND
758: (p_industrial_class_app_rec.industrial_class_id is NULL OR
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');

Line 766: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 775: (p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM OR

771:
772: -- non updateable field
773:
774: IF (p_create_update_flag = 'U' AND
775: (p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM OR
776: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM OR
777: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE OR
778: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE )) THEN
779: BEGIN

Line 776: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM OR

772: -- non updateable field
773:
774: IF (p_create_update_flag = 'U' AND
775: (p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM OR
776: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM OR
777: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE OR
778: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE )) THEN
779: BEGIN
780: SELECT party_id, industrial_class_id, begin_date, end_date

Line 777: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE OR

773:
774: IF (p_create_update_flag = 'U' AND
775: (p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM OR
776: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM OR
777: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE OR
778: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE )) THEN
779: BEGIN
780: SELECT party_id, industrial_class_id, begin_date, end_date
781: INTO l_party_id, l_industrial_class_id, l_begin_date, l_end_date

Line 778: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE )) THEN

774: IF (p_create_update_flag = 'U' AND
775: (p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM OR
776: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM OR
777: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE OR
778: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE )) THEN
779: BEGIN
780: SELECT party_id, industrial_class_id, begin_date, end_date
781: INTO l_party_id, l_industrial_class_id, l_begin_date, l_end_date
782: FROM HZ_INDUSTRIAL_CLASS_APP

Line 786: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN

782: FROM HZ_INDUSTRIAL_CLASS_APP
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;

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

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:
794: if l_industrial_class_id <> p_industrial_class_app_rec.industrial_class_id AND

Line 795: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM THEN

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

Line 799: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 809: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 822: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN

818: -- foreign keys: party_id to HZ_PARTIES table.
819: -- industrial_class_id to hz_industrial_class_app
820:
821: IF p_industrial_class_app_rec.party_id is NOT NULL AND
822: p_industrial_class_app_rec.party_id <> FND_API.G_MISS_NUM THEN
823:
824: SELECT COUNT(*) INTO l_count
825: FROM hz_parties
826: where party_id = p_industrial_class_app_rec.party_id;

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 841: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM THEN

837:
838: END IF;
839:
840: IF p_industrial_class_app_rec.industrial_class_id is NOT NULL AND
841: p_industrial_class_app_rec.industrial_class_id <> FND_API.G_MISS_NUM THEN
842:
843: SELECT COUNT(*) INTO l_count
844: FROM hz_industrial_classes
845: where industrial_class_id = p_industrial_class_app_rec.industrial_class_id;

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 864: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE THEN

860: -- end_date should be greater than begin_date
861:
862: IF p_create_update_flag = 'C' THEN
863: IF p_industrial_class_app_rec.end_date is NOT NULL AND
864: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE THEN
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

Line 868: p_industrial_class_app_rec.begin_date = FND_API.G_MISS_DATE) THEN

864: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE THEN
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:

Line 871: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 880: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE) THEN

876:
877: -- compare end_date with database data and user passed data.
878: ELSIF p_create_update_flag = 'U' THEN
879: if (p_industrial_class_app_rec.end_date is NOT NULL AND
880: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE) THEN
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:

Line 882: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE then

878: ELSIF p_create_update_flag = 'U' THEN
879: if (p_industrial_class_app_rec.end_date is NOT NULL AND
880: p_industrial_class_app_rec.end_date <> FND_API.G_MISS_DATE) THEN
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;

Line 887: x_return_status := FND_API.G_RET_STS_ERROR;

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
891: l_begin_date is NULL) then

Line 894: x_return_status := FND_API.G_RET_STS_ERROR;

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
898: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE) THEN

Line 898: p_industrial_class_app_rec.begin_date <> FND_API.G_MISS_DATE) THEN

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

Line 902: x_return_status := FND_API.G_RET_STS_ERROR;

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;
906: END validate_industrial_class_app;