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

Line 5: --| Procedure Name : get_fnd_message

1: PACKAGE BODY CN_API as
2: /* $Header: cnputilb.pls 120.11.12010000.5 2008/12/19 11:44:06 ramchint ship $ */
3:
4: --| ----------------------------------------------------------------------+
5: --| Procedure Name : get_fnd_message
6: --| ----------------------------------------------------------------------+
7: PROCEDURE get_fnd_message( p_msg_count NUMBER,
8: p_msg_data VARCHAR2) IS
9:

Line 7: PROCEDURE get_fnd_message( p_msg_count NUMBER,

3:
4: --| ----------------------------------------------------------------------+
5: --| Procedure Name : get_fnd_message
6: --| ----------------------------------------------------------------------+
7: PROCEDURE get_fnd_message( p_msg_count NUMBER,
8: p_msg_data VARCHAR2) IS
9:
10: l_msg_count NUMBER;
11: l_msg_data VARCHAR2(2000);

Line 45: END get_fnd_message;

41: cn_message_pkg.flush;
42:
43: FND_MSG_PUB.initialize;
44:
45: END get_fnd_message;
46:
47: --| ----------------------------------------------------------------------+
48: --| Function Name : get_rate_table_name
49: --| ----------------------------------------------------------------------+

Line 220: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');

216: BEGIN
217: l_return_code := FND_API.G_FALSE;
218: x_loading_status := p_loading_status;
219: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
221: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
224: 'cn.plsql.cn_api.chk_miss_char_para.error',

Line 221: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

217: l_return_code := FND_API.G_FALSE;
218: x_loading_status := p_loading_status;
219: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
220: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
221: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
222: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
223: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
224: 'cn.plsql.cn_api.chk_miss_char_para.error',
225: true);

Line 231: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');

227:
228: -- Error, check the msg level and add an error message to the
229: -- API message list
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
232: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
233: FND_MSG_PUB.Add;
234: END IF;
235: x_loading_status := 'CN_MISS_PARAMETER';

Line 232: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

228: -- Error, check the msg level and add an error message to the
229: -- API message list
230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
232: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
233: FND_MSG_PUB.Add;
234: END IF;
235: x_loading_status := 'CN_MISS_PARAMETER';
236: l_return_code := FND_API.G_TRUE;

Line 258: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');

254: BEGIN
255: l_return_code := FND_API.G_FALSE;
256: x_loading_status := p_loading_status;
257: IF (p_num_para = FND_API.G_MISS_NUM) THEN
258: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
259: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
260: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
262: 'cn.plsql.cn_api.chk_miss_num_para.error',

Line 259: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

255: l_return_code := FND_API.G_FALSE;
256: x_loading_status := p_loading_status;
257: IF (p_num_para = FND_API.G_MISS_NUM) THEN
258: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
259: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
260: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
261: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
262: 'cn.plsql.cn_api.chk_miss_num_para.error',
263: true);

Line 269: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');

265:
266: -- Error, check the msg level and add an error message to the
267: -- API message list
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
269: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
270: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
271: FND_MSG_PUB.Add;
272: END IF;
273: x_loading_status := 'CN_MISS_PARAMETER';

Line 270: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

266: -- Error, check the msg level and add an error message to the
267: -- API message list
268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
269: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
270: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
271: FND_MSG_PUB.Add;
272: END IF;
273: x_loading_status := 'CN_MISS_PARAMETER';
274: l_return_code := FND_API.G_TRUE;

Line 296: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');

292: BEGIN
293: l_return_code := FND_API.G_FALSE;
294: x_loading_status := p_loading_status;
295: IF (p_date_para = FND_API.G_MISS_DATE) THEN
296: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
297: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
298: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
299: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
300: 'cn.plsql.cn_api.chk_miss_date_para.error',

Line 297: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

293: l_return_code := FND_API.G_FALSE;
294: x_loading_status := p_loading_status;
295: IF (p_date_para = FND_API.G_MISS_DATE) THEN
296: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
297: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
298: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
299: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
300: 'cn.plsql.cn_api.chk_miss_date_para.error',
301: true);

Line 307: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');

303:
304: -- Error, check the msg level and add an error message to the
305: -- API message list
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
307: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
308: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
309: FND_MSG_PUB.Add;
310: END IF;
311: x_loading_status := 'CN_MISS_PARAMETER';

Line 308: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);

304: -- Error, check the msg level and add an error message to the
305: -- API message list
306: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
307: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
308: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
309: FND_MSG_PUB.Add;
310: END IF;
311: x_loading_status := 'CN_MISS_PARAMETER';
312: l_return_code := FND_API.G_TRUE;

Line 334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');

330: BEGIN
331: l_return_code := FND_API.G_FALSE;
332: x_loading_status := p_loading_status;
333: IF (p_num_para IS NULL ) THEN
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
335: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
336: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
337: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
338: 'cn.plsql.cn_api.chk_null_num_para.error',

Line 335: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

331: l_return_code := FND_API.G_FALSE;
332: x_loading_status := p_loading_status;
333: IF (p_num_para IS NULL ) THEN
334: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
335: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
336: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
337: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
338: 'cn.plsql.cn_api.chk_null_num_para.error',
339: true);

Line 345: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');

341:
342: -- Error, check the msg level and add an error message to the
343: -- API message list
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
346: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
347: FND_MSG_PUB.Add;
348: END IF;
349: x_loading_status := 'CN_CANNOT_NULL';

Line 346: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

342: -- Error, check the msg level and add an error message to the
343: -- API message list
344: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
346: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
347: FND_MSG_PUB.Add;
348: END IF;
349: x_loading_status := 'CN_CANNOT_NULL';
350: l_return_code := FND_API.G_TRUE;

Line 370: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');

366: BEGIN
367: l_return_code := FND_API.G_FALSE;
368: x_loading_status := p_loading_status;
369: IF (p_char_para IS NULL ) THEN
370: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
371: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
372: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
373: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
374: 'cn.plsql.cn_api.chk_null_char_para.error',

Line 371: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

367: l_return_code := FND_API.G_FALSE;
368: x_loading_status := p_loading_status;
369: IF (p_char_para IS NULL ) THEN
370: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
371: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
372: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
373: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
374: 'cn.plsql.cn_api.chk_null_char_para.error',
375: true);

Line 381: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');

377:
378: -- Error, check the msg level and add an error message to the
379: -- API message list
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
382: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
383: FND_MSG_PUB.Add;
384: END IF;
385: x_loading_status := 'CN_CANNOT_NULL';

Line 382: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

378: -- Error, check the msg level and add an error message to the
379: -- API message list
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
381: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
382: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
383: FND_MSG_PUB.Add;
384: END IF;
385: x_loading_status := 'CN_CANNOT_NULL';
386: l_return_code := FND_API.G_TRUE;

Line 406: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');

402: BEGIN
403: l_return_code := FND_API.G_FALSE;
404: x_loading_status := p_loading_status;
405: IF (p_date_para IS NULL ) THEN
406: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
407: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
408: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
409: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
410: 'cn.plsql.cn_api.chk_null_date_para.error',

Line 407: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

403: l_return_code := FND_API.G_FALSE;
404: x_loading_status := p_loading_status;
405: IF (p_date_para IS NULL ) THEN
406: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
407: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
408: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
409: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
410: 'cn.plsql.cn_api.chk_null_date_para.error',
411: true);

Line 417: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');

413:
414: -- Error, check the msg level and add an error message to the
415: -- API message list
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
418: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
419: FND_MSG_PUB.Add;
420: END IF;
421: x_loading_status := 'CN_CANNOT_NULL';

Line 418: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

414: -- Error, check the msg level and add an error message to the
415: -- API message list
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
418: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
419: FND_MSG_PUB.Add;
420: END IF;
421: x_loading_status := 'CN_CANNOT_NULL';
422: l_return_code := FND_API.G_TRUE;

Line 442: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');

438: BEGIN
439: l_return_code := FND_API.G_FALSE;
440: x_loading_status := p_loading_status;
441: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
442: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
443: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
444: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
445: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
446: 'cn.plsql.cn_api.chk_miss_null_num_para.error',

Line 443: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

439: l_return_code := FND_API.G_FALSE;
440: x_loading_status := p_loading_status;
441: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
442: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
443: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
444: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
445: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
446: 'cn.plsql.cn_api.chk_miss_null_num_para.error',
447: true);

Line 453: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');

449:
450: -- Error, check the msg level and add an error message to the
451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
453: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
454: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
455: FND_MSG_PUB.Add;
456: END IF;
457: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';

Line 454: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

450: -- Error, check the msg level and add an error message to the
451: -- API message list
452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
453: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
454: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
455: FND_MSG_PUB.Add;
456: END IF;
457: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
458: l_return_code := FND_API.G_TRUE;

Line 478: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');

474: BEGIN
475: l_return_code := FND_API.G_FALSE;
476: x_loading_status := p_loading_status;
477: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
478: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
479: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
480: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
481: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
482: 'cn.plsql.cn_api.chk_miss_null_char_para.error',

Line 479: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

475: l_return_code := FND_API.G_FALSE;
476: x_loading_status := p_loading_status;
477: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
478: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
479: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
480: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
481: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
482: 'cn.plsql.cn_api.chk_miss_null_char_para.error',
483: true);

Line 489: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');

485:
486: -- Error, check the msg level and add an error message to the
487: -- API message list
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
489: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
490: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
491: FND_MSG_PUB.Add;
492: END IF;
493: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';

Line 490: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

486: -- Error, check the msg level and add an error message to the
487: -- API message list
488: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
489: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
490: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
491: FND_MSG_PUB.Add;
492: END IF;
493: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
494: l_return_code := FND_API.G_TRUE;

Line 514: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');

510: BEGIN
511: l_return_code := FND_API.G_FALSE;
512: x_loading_status := p_loading_status;
513: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
514: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
515: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
516: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
517: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
518: 'cn.plsql.cn_api.chk_miss_null_date_para.error',

Line 515: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

511: l_return_code := FND_API.G_FALSE;
512: x_loading_status := p_loading_status;
513: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
514: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
515: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
516: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
517: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
518: 'cn.plsql.cn_api.chk_miss_null_date_para.error',
519: true);

Line 526: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');

522: -- Error, check the msg level and add an error message to the
523: -- API message list
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
525: THEN
526: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
527: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
528: FND_MSG_PUB.Add;
529: END IF;
530: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';

Line 527: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

523: -- API message list
524: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
525: THEN
526: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
527: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
528: FND_MSG_PUB.Add;
529: END IF;
530: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
531: l_return_code := FND_API.G_TRUE;

Line 555: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');

551: BEGIN
552: l_return_code := FND_API.G_TRUE;
553: x_loading_status := p_loading_status;
554: IF (p_num_field IS NOT NULL ) THEN
555: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
558: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

552: l_return_code := FND_API.G_TRUE;
553: x_loading_status := p_loading_status;
554: IF (p_num_field IS NOT NULL ) THEN
555: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
558: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

553: x_loading_status := p_loading_status;
554: IF (p_num_field IS NOT NULL ) THEN
555: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
558: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
561: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

555: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
558: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
561: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
562: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

556: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
558: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
561: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
562: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
564: 'cn.plsql.cn_api.pe_num_field_must_null.error',

Line 561: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

557: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
558: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
559: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
560: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
561: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
562: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
564: 'cn.plsql.cn_api.pe_num_field_must_null.error',
565: true);

Line 572: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');

568: -- Error, check the msg level and add an error message to the
569: -- API message list
570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
571: THEN
572: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

569: -- API message list
570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
571: THEN
572: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

570: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
571: THEN
572: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
578: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

572: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
578: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
579: FND_MSG_PUB.Add;
580: END IF;

Line 577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

573: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
578: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
579: FND_MSG_PUB.Add;
580: END IF;
581: x_loading_status := 'CN_PE_FIELD_MUST_NULL';

Line 578: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

574: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
575: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
576: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
577: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
578: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
579: FND_MSG_PUB.Add;
580: END IF;
581: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
582: l_return_code := FND_API.G_FALSE;

Line 606: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');

602: BEGIN
603: l_return_code := FND_API.G_TRUE;
604: x_loading_status := p_loading_status;
605: IF (p_char_field IS NOT NULL ) THEN
606: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
609: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

603: l_return_code := FND_API.G_TRUE;
604: x_loading_status := p_loading_status;
605: IF (p_char_field IS NOT NULL ) THEN
606: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
609: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
611: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

604: x_loading_status := p_loading_status;
605: IF (p_char_field IS NOT NULL ) THEN
606: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
609: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
611: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
612: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

606: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
609: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
611: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
612: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
613:
614: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 611: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

607: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
609: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
611: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
612: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
613:
614: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 612: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

608: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
609: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
610: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
611: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
612: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
613:
614: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
615: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
616: 'cn.plsql.cn_api.pe_char_field_must_null.error',

Line 624: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');

620: -- Error, check the msg level and add an error message to the
621: -- API message list
622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
623: THEN
624: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

621: -- API message list
622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
623: THEN
624: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

622: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
623: THEN
624: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
630: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

624: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
630: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
631: FND_MSG_PUB.Add;
632: END IF;

Line 629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

625: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
630: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
631: FND_MSG_PUB.Add;
632: END IF;
633: x_loading_status := 'CN_PE_FIELD_MUST_NULL';

Line 630: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

626: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
627: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
628: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
629: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
630: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
631: FND_MSG_PUB.Add;
632: END IF;
633: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
634: l_return_code := FND_API.G_FALSE;

Line 658: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');

654: BEGIN
655: l_return_code := FND_API.G_TRUE;
656: x_loading_status := p_loading_status;
657: IF (p_num_field IS NULL ) THEN
658: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
661: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

655: l_return_code := FND_API.G_TRUE;
656: x_loading_status := p_loading_status;
657: IF (p_num_field IS NULL ) THEN
658: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
661: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
663: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

656: x_loading_status := p_loading_status;
657: IF (p_num_field IS NULL ) THEN
658: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
661: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
663: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
664: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

658: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
661: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
663: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
664: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
665:
666: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 663: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

659: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
661: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
663: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
664: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
665:
666: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 664: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

660: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
661: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
662: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
663: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
664: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
665:
666: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
668: 'cn.plsql.cn_api.pe_num_field_cannot_null.error',

Line 676: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');

672: -- Error, check the msg level and add an error message to the
673: -- API message list
674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
675: THEN
676: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

673: -- API message list
674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
675: THEN
676: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
675: THEN
676: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
682: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

676: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
682: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
683: FND_MSG_PUB.Add;
684: END IF;

Line 681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

677: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
682: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
683: FND_MSG_PUB.Add;
684: END IF;
685: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';

Line 682: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

678: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
679: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
680: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
681: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
682: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
683: FND_MSG_PUB.Add;
684: END IF;
685: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
686: l_return_code := FND_API.G_FALSE;

Line 710: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');

706: BEGIN
707: l_return_code := FND_API.G_TRUE;
708: x_loading_status := p_loading_status;
709: IF (p_char_field IS NULL ) THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
713: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

707: l_return_code := FND_API.G_TRUE;
708: x_loading_status := p_loading_status;
709: IF (p_char_field IS NULL ) THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
713: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
715: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

708: x_loading_status := p_loading_status;
709: IF (p_char_field IS NULL ) THEN
710: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
713: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
715: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
716: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

710: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
713: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
715: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
716: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
717:
718: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 715: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

711: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
713: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
715: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
716: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
717:
718: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
719: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

Line 716: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

712: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
713: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
714: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
715: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
716: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
717:
718: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
719: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
720: 'cn.plsql.cn_api.pe_char_field_cannot_null.error',

Line 728: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');

724: -- Error, check the msg level and add an error message to the
725: -- API message list
726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
727: THEN
728: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

Line 729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);

725: -- API message list
726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
727: THEN
728: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

726: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
727: THEN
728: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
734: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

Line 732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

728: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
734: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
735: FND_MSG_PUB.Add;
736: END IF;

Line 733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

729: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
734: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
735: FND_MSG_PUB.Add;
736: END IF;
737: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';

Line 734: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

730: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
731: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
732: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
733: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
734: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
735: FND_MSG_PUB.Add;
736: END IF;
737: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
738: l_return_code := FND_API.G_FALSE;

Line 911: FND_MESSAGE.SET_NAME ('CN',x_loading_status);

907: -- Error, check the msg level and add an error message to the
908: -- API message list
909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
910: THEN
911: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
912: FND_MSG_PUB.Add;
913: END IF;
914: END IF;
915: WHEN too_many_rows THEN

Line 924: FND_MESSAGE.SET_NAME ('CN',x_loading_status);

920: -- Error, check the msg level and add an error message to the
921: -- API message list
922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
923: THEN
924: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
925: FND_MSG_PUB.Add;
926: END IF;
927: END IF;
928: END chk_and_get_salesrep_id;

Line 1180: FND_MESSAGE.SET_NAME ('CN',x_loading_status);

1176: -- Error, check the msg level and add an error message to the
1177: -- API message list
1178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1179: THEN
1180: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
1181: FND_MSG_PUB.Add;
1182: END IF;
1183: END IF;
1184:

Line 1887: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_COMP_PLAN');

1883: WHERE comp_plan_id = p_comp_plan_id;
1884: EXCEPTION
1885: WHEN NO_DATA_FOUND THEN
1886: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1887: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_COMP_PLAN');
1888: FND_MSG_PUB.Add;
1889: END IF;
1890: x_loading_status := 'CN_INVALID_COMP_PLAN';
1891: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2163: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');

2159: RETURN l_repcurr_amount;
2160:
2161: EXCEPTION
2162: WHEN NO_DATA_FOUND THEN
2163: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2164: FND_MSG_PUB.Add;
2165: APP_EXCEPTION.raise_exception;
2166: END convert_to_repcurr;
2167:

Line 2277: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');

2273:
2274: EXCEPTION
2275: WHEN NO_DATA_FOUND THEN
2276: -- dbms_output.put_line('no data found --2 ');
2277: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2278: FND_MSG_PUB.Add;
2279: x_return_status := 'E';
2280: END convert_to_repcurr_report;
2281:

Line 2704: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');

2700: -- check payrun status, No operation can be done for PAID
2701: IF l_status <> 'UNPAID' THEN
2702: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2703: THEN
2704: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');
2705: fnd_msg_pub.add;
2706: END IF;
2707: x_loading_status := 'CN_CANNOT_UPD_PAID_F_PAYRUN';
2708: RETURN fnd_api.g_true;

Line 2715: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');

2711: -- check payrun exists
2712: IF l_payrun_id IS NULL THEN
2713: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2714: THEN
2715: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2716: fnd_msg_pub.add;
2717: END IF;
2718: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
2719: RETURN fnd_api.g_true;

Line 2758: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');

2754:
2755: IF l_status = 'Y' THEN
2756: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2757: THEN
2758: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2759: fnd_msg_pub.add;
2760: END IF;
2761: x_loading_status := 'CN_SRP_ON_HOLD';
2762: RETURN fnd_api.g_true;

Line 2769: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');

2765: IF l_salesrep_id IS NULL THEN
2766: x_loading_status := 'CN_SRP_NOT_EXISTS';
2767: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2768: THEN
2769: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2770: fnd_msg_pub.add;
2771: END IF;
2772: x_loading_status := 'CN_SRP_NOT_EXISTS';
2773: RETURN fnd_api.g_true;

Line 2812: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');

2808:
2809: IF l_status = 'Y' THEN
2810: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2811: THEN
2812: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2813: fnd_msg_pub.add;
2814: END IF;
2815: x_loading_status := 'CN_SRP_ON_HOLD';
2816: RETURN fnd_api.g_true;

Line 2823: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');

2819: IF l_salesrep_id IS NULL THEN
2820: x_loading_status := 'CN_SRP_NOT_EXISTS';
2821: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2822: THEN
2823: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2824: fnd_msg_pub.add;
2825: END IF;
2826: x_loading_status := 'CN_SRP_NOT_EXISTS';
2827: RETURN fnd_api.g_true;

Line 2905: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');

2901: THEN
2902: --Error condition
2903: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2904: THEN
2905: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
2906: fnd_msg_pub.add;
2907: END IF;
2908: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
2909: RAISE FND_API.G_EXC_ERROR;

Line 2952: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');

2948: THEN
2949: --Error condition
2950: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2951: THEN
2952: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');
2953: fnd_msg_pub.add;
2954: END IF;
2955: x_loading_status := 'CN_WKSHT_CANNOT_BE_MODIFIED';
2956: RAISE FND_API.G_EXC_ERROR;