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.CSI_ITEM_INSTANCE_GRP dependencies on FND_MESSAGE

Line 70: fnd_message.set_name('CSI','CSI_NO_ORG_SET');

66: WHERE organization_id = p_instance_rec.vld_organization_id;
67: EXCEPTION
68: WHEN no_data_found THEN
69: l_return_value := FALSE;
70: fnd_message.set_name('CSI','CSI_NO_ORG_SET');
71: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
72: fnd_msg_pub.add;
73: RETURN l_return_value;
74: END;

Line 71: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);

67: EXCEPTION
68: WHEN no_data_found THEN
69: l_return_value := FALSE;
70: fnd_message.set_name('CSI','CSI_NO_ORG_SET');
71: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
72: fnd_msg_pub.add;
73: RETURN l_return_value;
74: END;
75: --

Line 94: fnd_message.set_name('CSI','CSI_LOT_CASE2');

90: END LOOP;
91: --
92: IF l_temp IS NOT NULL THEN
93: l_return_value := FALSE;
94: fnd_message.set_name('CSI','CSI_LOT_CASE2');
95: fnd_message.set_token('LOT_NUMBER',p_instance_rec.lot_number);
96: fnd_msg_pub.add;
97: RETURN l_return_value;
98: END IF;

Line 95: fnd_message.set_token('LOT_NUMBER',p_instance_rec.lot_number);

91: --
92: IF l_temp IS NOT NULL THEN
93: l_return_value := FALSE;
94: fnd_message.set_name('CSI','CSI_LOT_CASE2');
95: fnd_message.set_token('LOT_NUMBER',p_instance_rec.lot_number);
96: fnd_msg_pub.add;
97: RETURN l_return_value;
98: END IF;
99: END IF;

Line 126: fnd_message.set_name('CSI','CSI_NO_ORG_SET');

122: WHERE organization_id = p_instance_rec.vld_organization_id;
123: EXCEPTION
124: WHEN no_data_found THEN
125: l_return_value := FALSE;
126: fnd_message.set_name('CSI','CSI_NO_ORG_SET');
127: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
128: fnd_msg_pub.add;
129: RETURN l_return_value;
130: END;

Line 127: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);

123: EXCEPTION
124: WHEN no_data_found THEN
125: l_return_value := FALSE;
126: fnd_message.set_name('CSI','CSI_NO_ORG_SET');
127: fnd_message.set_token('ORGANIZATION_ID',p_instance_rec.vld_organization_id);
128: fnd_msg_pub.add;
129: RETURN l_return_value;
130: END;
131: --

Line 145: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');

141: and organization_id = p_instance_rec.vld_organization_id;
142: Exception
143: when no_data_found then
144: l_return_value := FALSE;
145: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
146: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
147: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
148: FND_MSG_PUB.Add;
149: RETURN l_return_value;

Line 146: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);

142: Exception
143: when no_data_found then
144: l_return_value := FALSE;
145: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
146: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
147: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
148: FND_MSG_PUB.Add;
149: RETURN l_return_value;
150: End;

Line 147: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);

143: when no_data_found then
144: l_return_value := FALSE;
145: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ITEM');
146: FND_MESSAGE.SET_TOKEN('INVENTORY_ITEM_ID',p_instance_rec.inventory_item_id);
147: FND_MESSAGE.SET_TOKEN('INVENTORY_ORGANIZATION_ID',p_instance_rec.vld_organization_id);
148: FND_MSG_PUB.Add;
149: RETURN l_return_value;
150: End;
151: --

Line 189: fnd_message.set_name('CSI','CSI_SER_CASE1');

185: END LOOP;
186: --
187: IF nvl(l_temp,'0') = '1' THEN
188: l_return_value := FALSE;
189: fnd_message.set_name('CSI','CSI_SER_CASE1');
190: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
191: fnd_msg_pub.add;
192: RETURN l_return_value;
193: ELSIF nvl(l_temp,'0') = '4' THEN

Line 190: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);

186: --
187: IF nvl(l_temp,'0') = '1' THEN
188: l_return_value := FALSE;
189: fnd_message.set_name('CSI','CSI_SER_CASE1');
190: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
191: fnd_msg_pub.add;
192: RETURN l_return_value;
193: ELSIF nvl(l_temp,'0') = '4' THEN
194: l_return_value := FALSE;

Line 195: fnd_message.set_name('CSI','CSI_SER_CASE4');

191: fnd_msg_pub.add;
192: RETURN l_return_value;
193: ELSIF nvl(l_temp,'0') = '4' THEN
194: l_return_value := FALSE;
195: fnd_message.set_name('CSI','CSI_SER_CASE4');
196: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
197: fnd_msg_pub.add;
198: RETURN l_return_value;
199: END IF;

Line 196: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);

192: RETURN l_return_value;
193: ELSIF nvl(l_temp,'0') = '4' THEN
194: l_return_value := FALSE;
195: fnd_message.set_name('CSI','CSI_SER_CASE4');
196: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
197: fnd_msg_pub.add;
198: RETURN l_return_value;
199: END IF;
200: END IF; -- Serial Type 1

Line 216: fnd_message.set_name('CSI','CSI_SER_CASE1');

212: END IF;
213: END LOOP;
214: IF l_temp IS NOT NULL THEN
215: l_return_value := FALSE;
216: fnd_message.set_name('CSI','CSI_SER_CASE1');
217: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
218: fnd_msg_pub.add;
219: RETURN l_return_value;
220: END IF;

Line 217: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);

213: END LOOP;
214: IF l_temp IS NOT NULL THEN
215: l_return_value := FALSE;
216: fnd_message.set_name('CSI','CSI_SER_CASE1');
217: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
218: fnd_msg_pub.add;
219: RETURN l_return_value;
220: END IF;
221: END IF; -- serial_type 4

Line 237: fnd_message.set_name('CSI','CSI_SER_CASE2');

233: END IF;
234: END LOOP;
235: IF l_temp IS NOT NULL THEN
236: l_return_value := FALSE;
237: fnd_message.set_name('CSI','CSI_SER_CASE2');
238: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
239: fnd_msg_pub.add;
240: RETURN l_return_value;
241: END IF;

Line 238: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);

234: END LOOP;
235: IF l_temp IS NOT NULL THEN
236: l_return_value := FALSE;
237: fnd_message.set_name('CSI','CSI_SER_CASE2');
238: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
239: fnd_msg_pub.add;
240: RETURN l_return_value;
241: END IF;
242: --

Line 256: fnd_message.set_name('CSI','CSI_SER_CASE21');

252: AND p.serial_number_type = 3
253: AND ROWNUM = 1;
254: IF l_temp IS NOT NULL THEN
255: l_return_value := FALSE;
256: fnd_message.set_name('CSI','CSI_SER_CASE21');
257: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
258: fnd_msg_pub.add;
259: RETURN l_return_value;
260: END IF;

Line 257: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);

253: AND ROWNUM = 1;
254: IF l_temp IS NOT NULL THEN
255: l_return_value := FALSE;
256: fnd_message.set_name('CSI','CSI_SER_CASE21');
257: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
258: fnd_msg_pub.add;
259: RETURN l_return_value;
260: END IF;
261: EXCEPTION

Line 280: fnd_message.set_name('CSI','CSI_SER_CASE3');

276: END IF;
277: END LOOP;
278: IF l_temp IS NOT NULL THEN
279: l_return_value := FALSE;
280: fnd_message.set_name('CSI','CSI_SER_CASE3');
281: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
282: fnd_msg_pub.add;
283: RETURN l_return_value;
284: END IF;

Line 281: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);

277: END LOOP;
278: IF l_temp IS NOT NULL THEN
279: l_return_value := FALSE;
280: fnd_message.set_name('CSI','CSI_SER_CASE3');
281: fnd_message.set_token('SERIAL_NUMBER',p_instance_rec.serial_number);
282: fnd_msg_pub.add;
283: RETURN l_return_value;
284: END IF;
285: END IF; -- serial_type 3

Line 311: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');

307: IF l_party_rec.active_end_date IS NOT NULL AND
308: l_party_rec.active_end_date <> FND_API.G_MISS_DATE THEN
309: IF l_party_rec.active_start_date > l_party_rec.active_end_date THEN
310: l_return_status := FALSE;
311: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
312: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',l_party_rec.active_start_date);
313: FND_MSG_PUB.ADD;
314: RETURN l_return_status;
315: END IF;

Line 312: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',l_party_rec.active_start_date);

308: l_party_rec.active_end_date <> FND_API.G_MISS_DATE THEN
309: IF l_party_rec.active_start_date > l_party_rec.active_end_date THEN
310: l_return_status := FALSE;
311: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
312: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',l_party_rec.active_start_date);
313: FND_MSG_PUB.ADD;
314: RETURN l_return_status;
315: END IF;
316: --

Line 320: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');

316: --
317: IF ( (l_party_rec.active_end_date < SYSDATE) OR
318: (p_end_date IS NOT NULL AND l_party_rec.active_end_date > p_end_date) ) THEN
319: l_return_status := FALSE;
320: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
321: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',l_party_rec.active_end_date);
322: FND_MSG_PUB.ADD;
323: RETURN l_return_status;
324: END IF;

Line 321: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',l_party_rec.active_end_date);

317: IF ( (l_party_rec.active_end_date < SYSDATE) OR
318: (p_end_date IS NOT NULL AND l_party_rec.active_end_date > p_end_date) ) THEN
319: l_return_status := FALSE;
320: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
321: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',l_party_rec.active_end_date);
322: FND_MSG_PUB.ADD;
323: RETURN l_return_status;
324: END IF;
325: END IF;

Line 330: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');

326: --
327: IF ( (l_party_rec.active_start_date < p_start_date) OR
328: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND l_party_rec.active_start_date > p_end_date) ) THEN
329: l_return_status := FALSE;
330: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
331: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',l_party_rec.active_start_date);
332: FND_MSG_PUB.ADD;
333: RETURN l_return_status;
334: END IF;

Line 331: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',l_party_rec.active_start_date);

327: IF ( (l_party_rec.active_start_date < p_start_date) OR
328: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND l_party_rec.active_start_date > p_end_date) ) THEN
329: l_return_status := FALSE;
330: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
331: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',l_party_rec.active_start_date);
332: FND_MSG_PUB.ADD;
333: RETURN l_return_status;
334: END IF;
335: IF l_party_tbl.count < 2 THEN

Line 354: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');

350: IF l_party_rec.PREFERRED_FLAG = 'Y' THEN
351: IF l_party_rec.CONTACT_FLAG <> 'Y' THEN
352: IF l_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
353: l_return_status := FALSE;
354: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
355: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);
356: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
357: FND_MSG_PUB.ADD;
358: RETURN l_return_status;

Line 355: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);

351: IF l_party_rec.CONTACT_FLAG <> 'Y' THEN
352: IF l_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
353: l_return_status := FALSE;
354: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
355: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);
356: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
357: FND_MSG_PUB.ADD;
358: RETURN l_return_status;
359: END IF;

Line 356: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);

352: IF l_party_rec.PARTY_SOURCE_TABLE NOT IN ('GROUP','TEAM') THEN
353: l_return_status := FALSE;
354: FND_MESSAGE.SET_NAME('CSI','CSI_PREFERRED_PTY_TYPE');
355: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);
356: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
357: FND_MSG_PUB.ADD;
358: RETURN l_return_status;
359: END IF;
360: END IF;

Line 386: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');

382: IF l_party_rec.primary_flag = 'Y' THEN
383: IF l_party_rec.contact_flag <> 'Y' THEN
384: IF l_party_rec.party_source_table NOT IN ('GROUP','TEAM') THEN
385: l_return_status := FALSE;
386: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
387: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);
388: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
389: FND_MSG_PUB.ADD;
390: exit;

Line 387: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);

383: IF l_party_rec.contact_flag <> 'Y' THEN
384: IF l_party_rec.party_source_table NOT IN ('GROUP','TEAM') THEN
385: l_return_status := FALSE;
386: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
387: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);
388: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
389: FND_MSG_PUB.ADD;
390: exit;
391: ELSE

Line 388: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);

384: IF l_party_rec.party_source_table NOT IN ('GROUP','TEAM') THEN
385: l_return_status := FALSE;
386: FND_MESSAGE.SET_NAME('CSI','CSI_PRIMARY_PTY_TYPE');
387: FND_MESSAGE.SET_TOKEN('PARTY_TYPE',l_party_rec.PARTY_SOURCE_TABLE);
388: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
389: FND_MSG_PUB.ADD;
390: exit;
391: ELSE
392: -- Check for Primary Party

Line 413: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');

409: END LOOP;
410: --
411: IF l_count > 1 THEN
412: l_return_status := FALSE;
413: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');
414: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_party_rec.INSTANCE_ID)||','||l_party_rec.PARTY_SOURCE_TABLE||','||to_char(l_party_rec.party_id)||','||l_party_rec.relationship_type_code);
415: FND_MSG_PUB.ADD;
416: RETURN l_return_status;
417: END IF;

Line 414: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_party_rec.INSTANCE_ID)||','||l_party_rec.PARTY_SOURCE_TABLE||','||to_char(l_party_rec.party_id)||','||l_party_rec.relationship_type_code);

410: --
411: IF l_count > 1 THEN
412: l_return_status := FALSE;
413: FND_MESSAGE.SET_NAME('CSI','CSI_API_MANY_PTY_REL_COM_EXIST');
414: FND_MESSAGE.SET_TOKEN('PARTY_REL_COMB',to_char(l_party_rec.INSTANCE_ID)||','||l_party_rec.PARTY_SOURCE_TABLE||','||to_char(l_party_rec.party_id)||','||l_party_rec.relationship_type_code);
415: FND_MSG_PUB.ADD;
416: RETURN l_return_status;
417: END IF;
418: --

Line 422: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');

418: --
419: IF l_primary_pty_count > 1 OR
420: l_primary_con_count > 1 THEN
421: l_return_status := FALSE;
422: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
423: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
424: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',l_party_rec.relationship_type_code);
425: FND_MSG_PUB.ADD;
426: RETURN l_return_status;

Line 423: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);

419: IF l_primary_pty_count > 1 OR
420: l_primary_con_count > 1 THEN
421: l_return_status := FALSE;
422: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
423: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
424: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',l_party_rec.relationship_type_code);
425: FND_MSG_PUB.ADD;
426: RETURN l_return_status;
427: END IF;

Line 424: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',l_party_rec.relationship_type_code);

420: l_primary_con_count > 1 THEN
421: l_return_status := FALSE;
422: FND_MESSAGE.SET_NAME('CSI','CSI_API_PRIMARY_PTY_EXISTS');
423: FND_MESSAGE.SET_TOKEN('INSTANCE_ID',l_party_rec.INSTANCE_ID);
424: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE',l_party_rec.relationship_type_code);
425: FND_MSG_PUB.ADD;
426: RETURN l_return_status;
427: END IF;
428: --

Line 457: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');

453: IF p_account_rec.active_end_date IS NOT NULL AND
454: p_account_rec.active_end_date <> FND_API.G_MISS_DATE THEN
455: IF p_account_rec.active_start_date > p_account_rec.active_end_date THEN
456: l_return_status := FALSE;
457: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
458: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_account_rec.active_start_date);
459: FND_MSG_PUB.ADD;
460: RETURN l_return_status;
461: END IF;

Line 458: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_account_rec.active_start_date);

454: p_account_rec.active_end_date <> FND_API.G_MISS_DATE THEN
455: IF p_account_rec.active_start_date > p_account_rec.active_end_date THEN
456: l_return_status := FALSE;
457: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
458: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_account_rec.active_start_date);
459: FND_MSG_PUB.ADD;
460: RETURN l_return_status;
461: END IF;
462: --

Line 466: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');

462: --
463: IF ( (p_account_rec.active_end_date < SYSDATE) OR
464: (p_end_date IS NOT NULL AND p_account_rec.active_end_date > p_end_date) ) THEN
465: l_return_status := FALSE;
466: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
467: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_account_rec.active_end_date);
468: FND_MSG_PUB.ADD;
469: RETURN l_return_status;
470: END IF;

Line 467: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_account_rec.active_end_date);

463: IF ( (p_account_rec.active_end_date < SYSDATE) OR
464: (p_end_date IS NOT NULL AND p_account_rec.active_end_date > p_end_date) ) THEN
465: l_return_status := FALSE;
466: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_END_DATE');
467: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_account_rec.active_end_date);
468: FND_MSG_PUB.ADD;
469: RETURN l_return_status;
470: END IF;
471: END IF;

Line 476: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');

472: --
473: IF ( (p_account_rec.active_start_date < p_start_date) OR
474: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_account_rec.active_start_date > p_end_date) ) THEN
475: l_return_status := FALSE;
476: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
477: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_account_rec.active_start_date);
478: FND_MSG_PUB.ADD;
479: RETURN l_return_status;
480: END IF;

Line 477: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_account_rec.active_start_date);

473: IF ( (p_account_rec.active_start_date < p_start_date) OR
474: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_account_rec.active_start_date > p_end_date) ) THEN
475: l_return_status := FALSE;
476: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');
477: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_account_rec.active_start_date);
478: FND_MSG_PUB.ADD;
479: RETURN l_return_status;
480: END IF;
481: --

Line 495: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');

491: and hzc.party_id = hzp.party_id;
492: Exception
493: when others then
494: l_return_status := FALSE;
495: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
496: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
497: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
498: RETURN l_return_status;
499: End;

Line 496: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);

492: Exception
493: when others then
494: l_return_status := FALSE;
495: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
496: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
497: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
498: RETURN l_return_status;
499: End;
500: ELSE

Line 497: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);

493: when others then
494: l_return_status := FALSE;
495: FND_MESSAGE.SET_NAME('CSI','CSI_API_PTY_ACCT_HZ_PTY');
496: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
497: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_id);
498: RETURN l_return_status;
499: End;
500: ELSE
501: Begin

Line 509: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');

505: where hzc.cust_account_id = p_account_rec.party_account_id;
506: Exception
507: when others then
508: l_return_status := FALSE;
509: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
510: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
511: RETURN l_return_status;
512: End;
513: END IF; ***/

Line 510: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);

506: Exception
507: when others then
508: l_return_status := FALSE;
509: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
510: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
511: RETURN l_return_status;
512: End;
513: END IF; ***/
514: --

Line 530: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');

526: END LOOP;
527: --
528: IF l_valid_flag <> 'Y' THEN
529: l_return_status := FALSE;
530: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
531: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
532: FND_MSG_PUB.ADD;
533: RETURN l_return_status;
534: END IF;

Line 531: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);

527: --
528: IF l_valid_flag <> 'Y' THEN
529: l_return_status := FALSE;
530: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
531: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
532: FND_MSG_PUB.ADD;
533: RETURN l_return_status;
534: END IF;
535: END IF;

Line 550: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');

546: Exception
547: when others then
548: p_acct_id_tbl(l_ctr).valid_flag := 'N';
549: l_return_status := FALSE;
550: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
551: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
552: FND_MSG_PUB.ADD;
553: RETURN l_return_status;
554: End;

Line 551: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);

547: when others then
548: p_acct_id_tbl(l_ctr).valid_flag := 'N';
549: l_return_status := FALSE;
550: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_ACCT_ID');
551: FND_MESSAGE.SET_TOKEN('PARTY_ACCOUNT_ID',p_account_rec.party_account_id);
552: FND_MSG_PUB.ADD;
553: RETURN l_return_status;
554: End;
555: END IF;

Line 576: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');

572: END LOOP;
573: --
574: IF l_count > 1 THEN
575: l_return_status := FALSE;
576: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');
577: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',to_char(p_account_rec.instance_party_id) ||', '
578: ||to_char(p_account_rec.party_account_id) ||','||p_account_rec.relationship_type_code);
579: FND_MSG_PUB.ADD;
580: RETURN l_return_status;

Line 577: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',to_char(p_account_rec.instance_party_id) ||', '

573: --
574: IF l_count > 1 THEN
575: l_return_status := FALSE;
576: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_ACCT_COM');
577: FND_MESSAGE.SET_TOKEN('ACCT_COMBINATION',to_char(p_account_rec.instance_party_id) ||', '
578: ||to_char(p_account_rec.party_account_id) ||','||p_account_rec.relationship_type_code);
579: FND_MSG_PUB.ADD;
580: RETURN l_return_status;
581: END IF;

Line 585: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');

581: END IF;
582: --
583: IF l_rel_count > 1 THEN
584: l_return_status := FALSE;
585: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');
586: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_account_rec.relationship_type_code);
587: FND_MSG_PUB.ADD;
588: RETURN l_return_status;
589: END IF;

Line 586: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_account_rec.relationship_type_code);

582: --
583: IF l_rel_count > 1 THEN
584: l_return_status := FALSE;
585: FND_MESSAGE.SET_NAME('CSI','CSI_API_DUP_ACCT_TYPE');
586: FND_MESSAGE.SET_TOKEN('RELATIONSHIP_TYPE_CODE',p_account_rec.relationship_type_code);
587: FND_MSG_PUB.ADD;
588: RETURN l_return_status;
589: END IF;
590: --

Line 610: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');

606: IF p_org_units_rec.active_end_date IS NOT NULL AND
607: p_org_units_rec.active_end_date <> FND_API.G_MISS_DATE THEN
608: IF p_org_units_rec.active_start_date > p_org_units_rec.active_end_date THEN
609: l_return_status := FALSE;
610: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
611: FND_MESSAGE.SET_TOKEN('START_DATE',p_org_units_rec.active_start_date);
612: FND_MSG_PUB.ADD;
613: RETURN l_return_status;
614: END IF;

Line 611: FND_MESSAGE.SET_TOKEN('START_DATE',p_org_units_rec.active_start_date);

607: p_org_units_rec.active_end_date <> FND_API.G_MISS_DATE THEN
608: IF p_org_units_rec.active_start_date > p_org_units_rec.active_end_date THEN
609: l_return_status := FALSE;
610: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
611: FND_MESSAGE.SET_TOKEN('START_DATE',p_org_units_rec.active_start_date);
612: FND_MSG_PUB.ADD;
613: RETURN l_return_status;
614: END IF;
615: --

Line 619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');

615: --
616: IF ( (p_org_units_rec.active_end_date < SYSDATE) OR
617: (p_end_date IS NOT NULL AND p_org_units_rec.active_end_date > p_end_date) ) THEN
618: l_return_status := FALSE;
619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
620: FND_MESSAGE.SET_TOKEN('END_DATE',p_org_units_rec.active_end_date);
621: FND_MSG_PUB.ADD;
622: RETURN l_return_status;
623: END IF;

Line 620: FND_MESSAGE.SET_TOKEN('END_DATE',p_org_units_rec.active_end_date);

616: IF ( (p_org_units_rec.active_end_date < SYSDATE) OR
617: (p_end_date IS NOT NULL AND p_org_units_rec.active_end_date > p_end_date) ) THEN
618: l_return_status := FALSE;
619: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_END_DATE');
620: FND_MESSAGE.SET_TOKEN('END_DATE',p_org_units_rec.active_end_date);
621: FND_MSG_PUB.ADD;
622: RETURN l_return_status;
623: END IF;
624: END IF;

Line 629: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');

625: --
626: IF ( (p_org_units_rec.active_start_date < p_start_date) OR
627: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_org_units_rec.active_start_date > p_end_date) ) THEN
628: l_return_status := FALSE;
629: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
630: FND_MESSAGE.SET_TOKEN('START_DATE',p_org_units_rec.active_start_date);
631: FND_MSG_PUB.ADD;
632: RETURN l_return_status;
633: END IF;

Line 630: FND_MESSAGE.SET_TOKEN('START_DATE',p_org_units_rec.active_start_date);

626: IF ( (p_org_units_rec.active_start_date < p_start_date) OR
627: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_org_units_rec.active_start_date > p_end_date) ) THEN
628: l_return_status := FALSE;
629: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_ORG_START_DATE');
630: FND_MESSAGE.SET_TOKEN('START_DATE',p_org_units_rec.active_start_date);
631: FND_MSG_PUB.ADD;
632: RETURN l_return_status;
633: END IF;
634: --

Line 648: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');

644: END LOOP;
645: --
646: IF l_count > 1 THEN
647: l_return_status := FALSE;
648: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');
649: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',to_char(p_org_units_rec.instance_id)||' '||p_org_units_rec.relationship_type_code);
650: FND_MSG_PUB.ADD;
651: RETURN l_return_status;
652: END IF;

Line 649: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',to_char(p_org_units_rec.instance_id)||' '||p_org_units_rec.relationship_type_code);

645: --
646: IF l_count > 1 THEN
647: l_return_status := FALSE;
648: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_ALTERNATE_PK');
649: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',to_char(p_org_units_rec.instance_id)||' '||p_org_units_rec.relationship_type_code);
650: FND_MSG_PUB.ADD;
651: RETURN l_return_status;
652: END IF;
653: --

Line 672: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');

668: IF p_pricing_rec.active_end_date IS NOT NULL AND
669: p_pricing_rec.active_end_date <> FND_API.G_MISS_DATE THEN
670: IF p_pricing_rec.active_start_date > p_pricing_rec.active_end_date THEN
671: l_return_status := FALSE;
672: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');
673: FND_MESSAGE.SET_TOKEN('START_DATE',p_pricing_rec.active_start_date);
674: FND_MSG_PUB.ADD;
675: RETURN l_return_status;
676: END IF;

Line 673: FND_MESSAGE.SET_TOKEN('START_DATE',p_pricing_rec.active_start_date);

669: p_pricing_rec.active_end_date <> FND_API.G_MISS_DATE THEN
670: IF p_pricing_rec.active_start_date > p_pricing_rec.active_end_date THEN
671: l_return_status := FALSE;
672: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');
673: FND_MESSAGE.SET_TOKEN('START_DATE',p_pricing_rec.active_start_date);
674: FND_MSG_PUB.ADD;
675: RETURN l_return_status;
676: END IF;
677: --

Line 681: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');

677: --
678: IF ( (p_pricing_rec.active_end_date < SYSDATE) OR
679: (p_end_date IS NOT NULL AND p_pricing_rec.active_end_date > p_end_date) ) THEN
680: l_return_status := FALSE;
681: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');
682: FND_MESSAGE.SET_TOKEN('END_DATE',p_pricing_rec.active_end_date);
683: FND_MSG_PUB.ADD;
684: RETURN l_return_status;
685: END IF;

Line 682: FND_MESSAGE.SET_TOKEN('END_DATE',p_pricing_rec.active_end_date);

678: IF ( (p_pricing_rec.active_end_date < SYSDATE) OR
679: (p_end_date IS NOT NULL AND p_pricing_rec.active_end_date > p_end_date) ) THEN
680: l_return_status := FALSE;
681: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_END_DATE');
682: FND_MESSAGE.SET_TOKEN('END_DATE',p_pricing_rec.active_end_date);
683: FND_MSG_PUB.ADD;
684: RETURN l_return_status;
685: END IF;
686: END IF;

Line 691: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');

687: --
688: IF ( (p_pricing_rec.active_start_date < p_start_date) OR
689: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_pricing_rec.active_start_date > p_end_date) ) THEN
690: l_return_status := FALSE;
691: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');
692: FND_MESSAGE.SET_TOKEN('START_DATE',p_pricing_rec.active_start_date);
693: FND_MSG_PUB.ADD;
694: RETURN l_return_status;
695: END IF;

Line 692: FND_MESSAGE.SET_TOKEN('START_DATE',p_pricing_rec.active_start_date);

688: IF ( (p_pricing_rec.active_start_date < p_start_date) OR
689: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_pricing_rec.active_start_date > p_end_date) ) THEN
690: l_return_status := FALSE;
691: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_PRI_START_DATE');
692: FND_MESSAGE.SET_TOKEN('START_DATE',p_pricing_rec.active_start_date);
693: FND_MSG_PUB.ADD;
694: RETURN l_return_status;
695: END IF;
696: --

Line 717: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');

713: IF p_ext_rec.active_end_date IS NOT NULL AND
714: p_ext_rec.active_end_date <> FND_API.G_MISS_DATE THEN
715: IF p_ext_rec.active_start_date > p_ext_rec.active_end_date THEN
716: l_return_status := FALSE;
717: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
718: FND_MESSAGE.SET_TOKEN('START_DATE',p_ext_rec.active_start_date);
719: FND_MSG_PUB.ADD;
720: RETURN l_return_status;
721: END IF;

Line 718: FND_MESSAGE.SET_TOKEN('START_DATE',p_ext_rec.active_start_date);

714: p_ext_rec.active_end_date <> FND_API.G_MISS_DATE THEN
715: IF p_ext_rec.active_start_date > p_ext_rec.active_end_date THEN
716: l_return_status := FALSE;
717: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
718: FND_MESSAGE.SET_TOKEN('START_DATE',p_ext_rec.active_start_date);
719: FND_MSG_PUB.ADD;
720: RETURN l_return_status;
721: END IF;
722: --

Line 726: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');

722: --
723: IF ( (p_ext_rec.active_end_date < SYSDATE) OR
724: (p_end_date IS NOT NULL AND p_ext_rec.active_end_date > p_end_date) ) THEN
725: l_return_status := FALSE;
726: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
727: FND_MESSAGE.SET_TOKEN('END_DATE',p_ext_rec.active_end_date);
728: FND_MSG_PUB.ADD;
729: RETURN l_return_status;
730: END IF;

Line 727: FND_MESSAGE.SET_TOKEN('END_DATE',p_ext_rec.active_end_date);

723: IF ( (p_ext_rec.active_end_date < SYSDATE) OR
724: (p_end_date IS NOT NULL AND p_ext_rec.active_end_date > p_end_date) ) THEN
725: l_return_status := FALSE;
726: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_END_DATE');
727: FND_MESSAGE.SET_TOKEN('END_DATE',p_ext_rec.active_end_date);
728: FND_MSG_PUB.ADD;
729: RETURN l_return_status;
730: END IF;
731: END IF;

Line 736: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');

732: --
733: IF ( (p_ext_rec.active_start_date < p_start_date) OR
734: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_ext_rec.active_start_date > p_end_date) ) THEN
735: l_return_status := FALSE;
736: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
737: FND_MESSAGE.SET_TOKEN('START_DATE',p_ext_rec.active_start_date);
738: FND_MSG_PUB.ADD;
739: RETURN l_return_status;
740: END IF;

Line 737: FND_MESSAGE.SET_TOKEN('START_DATE',p_ext_rec.active_start_date);

733: IF ( (p_ext_rec.active_start_date < p_start_date) OR
734: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_ext_rec.active_start_date > p_end_date) ) THEN
735: l_return_status := FALSE;
736: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_EXT_START_DATE');
737: FND_MESSAGE.SET_TOKEN('START_DATE',p_ext_rec.active_start_date);
738: FND_MSG_PUB.ADD;
739: RETURN l_return_status;
740: END IF;
741: --

Line 755: FND_MESSAGE.SET_NAME('CSI','CSI_EXT_INVALID_ALTERNATE_PK');

751: END LOOP;
752: --
753: IF l_count > 1 THEN
754: l_return_status := FALSE;
755: FND_MESSAGE.SET_NAME('CSI','CSI_EXT_INVALID_ALTERNATE_PK');
756: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',to_char(p_ext_rec.instance_id)||','||to_char(p_ext_rec.attribute_id));
757: FND_MSG_PUB.ADD;
758: RETURN l_return_status;
759: END IF;

Line 756: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',to_char(p_ext_rec.instance_id)||','||to_char(p_ext_rec.attribute_id));

752: --
753: IF l_count > 1 THEN
754: l_return_status := FALSE;
755: FND_MESSAGE.SET_NAME('CSI','CSI_EXT_INVALID_ALTERNATE_PK');
756: FND_MESSAGE.SET_TOKEN('ALTERNATE_PK',to_char(p_ext_rec.instance_id)||','||to_char(p_ext_rec.attribute_id));
757: FND_MSG_PUB.ADD;
758: RETURN l_return_status;
759: END IF;
760: --

Line 779: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');

775: IF p_asset_rec.active_end_date IS NOT NULL AND
776: p_asset_rec.active_end_date <> FND_API.G_MISS_DATE THEN
777: IF p_asset_rec.active_start_date > p_asset_rec.active_end_date THEN
778: l_return_status := FALSE;
779: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
780: FND_MESSAGE.SET_TOKEN('START_DATE',p_asset_rec.active_start_date);
781: FND_MSG_PUB.ADD;
782: RETURN l_return_status;
783: END IF;

Line 780: FND_MESSAGE.SET_TOKEN('START_DATE',p_asset_rec.active_start_date);

776: p_asset_rec.active_end_date <> FND_API.G_MISS_DATE THEN
777: IF p_asset_rec.active_start_date > p_asset_rec.active_end_date THEN
778: l_return_status := FALSE;
779: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
780: FND_MESSAGE.SET_TOKEN('START_DATE',p_asset_rec.active_start_date);
781: FND_MSG_PUB.ADD;
782: RETURN l_return_status;
783: END IF;
784: --

Line 788: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');

784: --
785: IF ( (p_asset_rec.active_end_date < SYSDATE) OR
786: (p_end_date IS NOT NULL AND p_asset_rec.active_end_date > p_end_date) ) THEN
787: l_return_status := FALSE;
788: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');
789: FND_MESSAGE.SET_TOKEN('END_DATE',p_asset_rec.active_end_date);
790: FND_MSG_PUB.ADD;
791: RETURN l_return_status;
792: END IF;

Line 789: FND_MESSAGE.SET_TOKEN('END_DATE',p_asset_rec.active_end_date);

785: IF ( (p_asset_rec.active_end_date < SYSDATE) OR
786: (p_end_date IS NOT NULL AND p_asset_rec.active_end_date > p_end_date) ) THEN
787: l_return_status := FALSE;
788: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_END_DATE');
789: FND_MESSAGE.SET_TOKEN('END_DATE',p_asset_rec.active_end_date);
790: FND_MSG_PUB.ADD;
791: RETURN l_return_status;
792: END IF;
793: END IF;

Line 798: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');

794: --
795: IF ( (p_asset_rec.active_start_date < p_start_date) OR
796: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_asset_rec.active_start_date > p_end_date) ) THEN
797: l_return_status := FALSE;
798: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
799: FND_MESSAGE.SET_TOKEN('START_DATE',p_asset_rec.active_start_date);
800: FND_MSG_PUB.ADD;
801: RETURN l_return_status;
802: END IF;

Line 799: FND_MESSAGE.SET_TOKEN('START_DATE',p_asset_rec.active_start_date);

795: IF ( (p_asset_rec.active_start_date < p_start_date) OR
796: (p_end_date IS NOT NULL AND p_end_date <> FND_API.G_MISS_DATE AND p_asset_rec.active_start_date > p_end_date) ) THEN
797: l_return_status := FALSE;
798: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVAL_AST_START_DATE');
799: FND_MESSAGE.SET_TOKEN('START_DATE',p_asset_rec.active_start_date);
800: FND_MSG_PUB.ADD;
801: RETURN l_return_status;
802: END IF;
803: --

Line 6039: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

6035: --
6036: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
6037: --
6038: IF l_internal_party_id IS NULL THEN
6039: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
6040: FND_MSG_PUB.ADD;
6041: RAISE OTHER_ERROR;
6042: END IF;
6043: --

Line 6052: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');

6048: WHERE name = l_instance_status;
6049: --
6050: EXCEPTION
6051: WHEN OTHERS THEN
6052: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
6053: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',l_instance_status);
6054: FND_MSG_PUB.Add;
6055: -- RAISE FND_API.G_EXC_ERROR;
6056: RAISE OTHER_ERROR; -- Added for bug 3579121 (rel 11.5.9)

Line 6053: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',l_instance_status);

6049: --
6050: EXCEPTION
6051: WHEN OTHERS THEN
6052: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_STATUS_ID');
6053: FND_MESSAGE.SET_TOKEN('INSTANCE_STATUS',l_instance_status);
6054: FND_MSG_PUB.Add;
6055: -- RAISE FND_API.G_EXC_ERROR;
6056: RAISE OTHER_ERROR; -- Added for bug 3579121 (rel 11.5.9)
6057: END;

Line 6198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');

6194: -- If version label is null, then we need read the the default value from the profile option
6195: IF ((p_instance_tbl(inst_tab_row).version_label IS NULL) OR
6196: (p_instance_tbl(inst_tab_row).version_label = FND_API.G_MISS_CHAR)) THEN
6197: IF l_version_label IS NULL THEN
6198: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VERSION_LABEL');
6199: FND_MSG_PUB.ADD;
6200: l_msg_index := 1;
6201: FND_MSG_PUB.Count_And_Get
6202: (p_count => x_msg_count,

Line 8022: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');

8018: --
8019: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8020: --
8021: IF l_internal_party_id IS NULL THEN
8022: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
8023: FND_MSG_PUB.ADD;
8024: RAISE FND_API.G_EXC_ERROR;
8025: END IF;
8026: --

Line 9519: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

9515: -- Initialize API return status to success
9516: x_return_status := FND_API.G_RET_STS_SUCCESS;
9517: --
9518: IF p_subject_id IS NULL OR p_subject_id = FND_API.G_MISS_NUM THEN
9519: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
9520: fnd_msg_pub.add;
9521: x_return_status := fnd_api.g_ret_sts_error;
9522: RAISE fnd_api.g_exc_error;
9523: END IF;

Line 10136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');

10132: -- Verify instance quantity
10133: IF ((p_source_instance_tbl(src_rec).QUANTITY IS NULL)
10134: OR (p_source_instance_tbl(src_rec).QUANTITY = FND_API.G_MISS_NUM )
10135: OR (p_source_instance_tbl(src_rec).QUANTITY <> 1)) THEN
10136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
10137: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_tbl(src_rec).QUANTITY);
10138: FND_MSG_PUB.Add;
10139: RAISE FND_API.G_EXC_ERROR;
10140: END IF;

Line 10137: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_tbl(src_rec).QUANTITY);

10133: IF ((p_source_instance_tbl(src_rec).QUANTITY IS NULL)
10134: OR (p_source_instance_tbl(src_rec).QUANTITY = FND_API.G_MISS_NUM )
10135: OR (p_source_instance_tbl(src_rec).QUANTITY <> 1)) THEN
10136: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_QUANTITY');
10137: FND_MESSAGE.SET_TOKEN('QUANTITY',p_source_instance_tbl(src_rec).QUANTITY);
10138: FND_MSG_PUB.Add;
10139: RAISE FND_API.G_EXC_ERROR;
10140: END IF;
10141: --

Line 10144: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');

10140: END IF;
10141: --
10142: IF (p_source_instance_tbl(src_rec).instance_id IS NULL) OR
10143: (p_source_instance_tbl(src_rec).instance_id = FND_API.G_MISS_NUM) THEN
10144: FND_MESSAGE.SET_NAME('CSI','CSI_API_INSTANCE_ID_NULL');
10145: FND_MSG_PUB.Add;
10146: RAISE FND_API.G_EXC_ERROR;
10147: END IF;
10148: --