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 27: --| Procedure Name : get_fnd_message

23:
24: g_user_tab jtf_number_table;
25:
26: --| ----------------------------------------------------------------------+
27: --| Procedure Name : get_fnd_message
28: --| ----------------------------------------------------------------------+
29: PROCEDURE get_fnd_message( p_msg_count NUMBER,
30: p_msg_data VARCHAR2) IS
31:

Line 29: PROCEDURE get_fnd_message( p_msg_count NUMBER,

25:
26: --| ----------------------------------------------------------------------+
27: --| Procedure Name : get_fnd_message
28: --| ----------------------------------------------------------------------+
29: PROCEDURE get_fnd_message( p_msg_count NUMBER,
30: p_msg_data VARCHAR2) IS
31:
32: l_msg_count NUMBER;
33: l_msg_data VARCHAR2(2000);

Line 67: END get_fnd_message;

63: cn_message_pkg.flush;
64:
65: FND_MSG_PUB.initialize;
66:
67: END get_fnd_message;
68:
69: --| ----------------------------------------------------------------------+
70: --| Function Name : get_rate_table_name
71: --| ----------------------------------------------------------------------+

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

238: BEGIN
239: l_return_code := FND_API.G_FALSE;
240: x_loading_status := p_loading_status;
241: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
242: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
243: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
244: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
245: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
246: 'cn.plsql.cn_api.chk_miss_char_para.error',

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

239: l_return_code := FND_API.G_FALSE;
240: x_loading_status := p_loading_status;
241: IF (p_char_para = FND_API.G_MISS_CHAR) THEN
242: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
243: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
244: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
245: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
246: 'cn.plsql.cn_api.chk_miss_char_para.error',
247: true);

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

249:
250: -- Error, check the msg level and add an error message to the
251: -- API message list
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
254: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
255: FND_MSG_PUB.Add;
256: END IF;
257: x_loading_status := 'CN_MISS_PARAMETER';

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

250: -- Error, check the msg level and add an error message to the
251: -- API message list
252: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
253: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
254: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
255: FND_MSG_PUB.Add;
256: END IF;
257: x_loading_status := 'CN_MISS_PARAMETER';
258: l_return_code := FND_API.G_TRUE;

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

276: BEGIN
277: l_return_code := FND_API.G_FALSE;
278: x_loading_status := p_loading_status;
279: IF (p_num_para = FND_API.G_MISS_NUM) THEN
280: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
281: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
282: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
283: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
284: 'cn.plsql.cn_api.chk_miss_num_para.error',

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

277: l_return_code := FND_API.G_FALSE;
278: x_loading_status := p_loading_status;
279: IF (p_num_para = FND_API.G_MISS_NUM) THEN
280: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
281: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
282: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
283: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
284: 'cn.plsql.cn_api.chk_miss_num_para.error',
285: true);

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

287:
288: -- Error, check the msg level and add an error message to the
289: -- API message list
290: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
292: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
293: FND_MSG_PUB.Add;
294: END IF;
295: x_loading_status := 'CN_MISS_PARAMETER';

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

288: -- Error, check the msg level and add an error message to the
289: -- API message list
290: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
292: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
293: FND_MSG_PUB.Add;
294: END IF;
295: x_loading_status := 'CN_MISS_PARAMETER';
296: l_return_code := FND_API.G_TRUE;

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

314: BEGIN
315: l_return_code := FND_API.G_FALSE;
316: x_loading_status := p_loading_status;
317: IF (p_date_para = FND_API.G_MISS_DATE) THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
319: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
320: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
321: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
322: 'cn.plsql.cn_api.chk_miss_date_para.error',

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

315: l_return_code := FND_API.G_FALSE;
316: x_loading_status := p_loading_status;
317: IF (p_date_para = FND_API.G_MISS_DATE) THEN
318: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
319: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
320: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
321: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
322: 'cn.plsql.cn_api.chk_miss_date_para.error',
323: true);

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

325:
326: -- Error, check the msg level and add an error message to the
327: -- API message list
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
329: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
330: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
331: FND_MSG_PUB.Add;
332: END IF;
333: x_loading_status := 'CN_MISS_PARAMETER';

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

326: -- Error, check the msg level and add an error message to the
327: -- API message list
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
329: FND_MESSAGE.SET_NAME ('CN' , 'CN_MISS_PARAMETER');
330: FND_MESSAGE.SET_TOKEN('PARA_NAME',p_para_name);
331: FND_MSG_PUB.Add;
332: END IF;
333: x_loading_status := 'CN_MISS_PARAMETER';
334: l_return_code := FND_API.G_TRUE;

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

352: BEGIN
353: l_return_code := FND_API.G_FALSE;
354: x_loading_status := p_loading_status;
355: IF (p_num_para IS NULL ) THEN
356: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
357: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
358: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
359: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
360: 'cn.plsql.cn_api.chk_null_num_para.error',

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

353: l_return_code := FND_API.G_FALSE;
354: x_loading_status := p_loading_status;
355: IF (p_num_para IS NULL ) THEN
356: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
357: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
358: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
359: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
360: 'cn.plsql.cn_api.chk_null_num_para.error',
361: true);

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

363:
364: -- Error, check the msg level and add an error message to the
365: -- API message list
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
368: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
369: FND_MSG_PUB.Add;
370: END IF;
371: x_loading_status := 'CN_CANNOT_NULL';

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

364: -- Error, check the msg level and add an error message to the
365: -- API message list
366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
368: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
369: FND_MSG_PUB.Add;
370: END IF;
371: x_loading_status := 'CN_CANNOT_NULL';
372: l_return_code := FND_API.G_TRUE;

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

388: BEGIN
389: l_return_code := FND_API.G_FALSE;
390: x_loading_status := p_loading_status;
391: IF (p_char_para IS NULL ) THEN
392: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
393: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
394: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
395: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
396: 'cn.plsql.cn_api.chk_null_char_para.error',

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

389: l_return_code := FND_API.G_FALSE;
390: x_loading_status := p_loading_status;
391: IF (p_char_para IS NULL ) THEN
392: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
393: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
394: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
395: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
396: 'cn.plsql.cn_api.chk_null_char_para.error',
397: true);

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

399:
400: -- Error, check the msg level and add an error message to the
401: -- API message list
402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
403: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
404: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
405: FND_MSG_PUB.Add;
406: END IF;
407: x_loading_status := 'CN_CANNOT_NULL';

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

400: -- Error, check the msg level and add an error message to the
401: -- API message list
402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
403: Fnd_message.SET_NAME ('CN' , 'CN_CANNOT_NULL');
404: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
405: FND_MSG_PUB.Add;
406: END IF;
407: x_loading_status := 'CN_CANNOT_NULL';
408: l_return_code := FND_API.G_TRUE;

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

424: BEGIN
425: l_return_code := FND_API.G_FALSE;
426: x_loading_status := p_loading_status;
427: IF (p_date_para IS NULL ) THEN
428: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
429: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
430: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
431: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
432: 'cn.plsql.cn_api.chk_null_date_para.error',

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

425: l_return_code := FND_API.G_FALSE;
426: x_loading_status := p_loading_status;
427: IF (p_date_para IS NULL ) THEN
428: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
429: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
430: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
431: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
432: 'cn.plsql.cn_api.chk_null_date_para.error',
433: true);

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

435:
436: -- Error, check the msg level and add an error message to the
437: -- API message list
438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
440: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
441: FND_MSG_PUB.Add;
442: END IF;
443: x_loading_status := 'CN_CANNOT_NULL';

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

436: -- Error, check the msg level and add an error message to the
437: -- API message list
438: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
439: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_NULL');
440: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
441: FND_MSG_PUB.Add;
442: END IF;
443: x_loading_status := 'CN_CANNOT_NULL';
444: l_return_code := FND_API.G_TRUE;

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

460: BEGIN
461: l_return_code := FND_API.G_FALSE;
462: x_loading_status := p_loading_status;
463: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
464: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
466: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
467: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
468: 'cn.plsql.cn_api.chk_miss_null_num_para.error',

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

461: l_return_code := FND_API.G_FALSE;
462: x_loading_status := p_loading_status;
463: IF ((p_num_para IS NULL) OR (p_num_para = FND_API.G_MISS_NUM)) THEN
464: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
465: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
466: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
467: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
468: 'cn.plsql.cn_api.chk_miss_null_num_para.error',
469: true);

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

471:
472: -- Error, check the msg level and add an error message to the
473: -- API message list
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
475: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
476: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
477: FND_MSG_PUB.Add;
478: END IF;
479: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';

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

472: -- Error, check the msg level and add an error message to the
473: -- API message list
474: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
475: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
476: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
477: FND_MSG_PUB.Add;
478: END IF;
479: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
480: l_return_code := FND_API.G_TRUE;

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

496: BEGIN
497: l_return_code := FND_API.G_FALSE;
498: x_loading_status := p_loading_status;
499: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
500: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
501: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
502: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
503: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
504: 'cn.plsql.cn_api.chk_miss_null_char_para.error',

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

497: l_return_code := FND_API.G_FALSE;
498: x_loading_status := p_loading_status;
499: IF ((p_char_para IS NULL ) OR (p_char_para = FND_API.G_MISS_CHAR)) THEN
500: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
501: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
502: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
503: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
504: 'cn.plsql.cn_api.chk_miss_null_char_para.error',
505: true);

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

507:
508: -- Error, check the msg level and add an error message to the
509: -- API message list
510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
511: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
512: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
513: FND_MSG_PUB.Add;
514: END IF;
515: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';

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

508: -- Error, check the msg level and add an error message to the
509: -- API message list
510: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
511: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
512: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
513: FND_MSG_PUB.Add;
514: END IF;
515: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
516: l_return_code := FND_API.G_TRUE;

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

532: BEGIN
533: l_return_code := FND_API.G_FALSE;
534: x_loading_status := p_loading_status;
535: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
536: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
537: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
538: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
539: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
540: 'cn.plsql.cn_api.chk_miss_null_date_para.error',

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

533: l_return_code := FND_API.G_FALSE;
534: x_loading_status := p_loading_status;
535: IF ((p_date_para IS NULL ) OR (p_date_para = FND_API.G_MISS_DATE)) THEN
536: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
537: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
538: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
539: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
540: 'cn.plsql.cn_api.chk_miss_null_date_para.error',
541: true);

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

544: -- Error, check the msg level and add an error message to the
545: -- API message list
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN
548: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
549: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
550: FND_MSG_PUB.Add;
551: END IF;
552: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';

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

545: -- API message list
546: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
547: THEN
548: FND_MESSAGE.SET_NAME ('CN' , 'CN_CANNOT_MISS_OR_NULL');
549: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
550: FND_MSG_PUB.Add;
551: END IF;
552: x_loading_status := 'CN_CANNOT_MISS_OR_NULL';
553: l_return_code := FND_API.G_TRUE;

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

573: BEGIN
574: l_return_code := FND_API.G_TRUE;
575: x_loading_status := p_loading_status;
576: IF (p_num_field IS NOT NULL ) THEN
577: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
578: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
580: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
581: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

574: l_return_code := FND_API.G_TRUE;
575: x_loading_status := p_loading_status;
576: IF (p_num_field IS NOT NULL ) THEN
577: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
578: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
580: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
581: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
582: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

575: x_loading_status := p_loading_status;
576: IF (p_num_field IS NOT NULL ) THEN
577: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
578: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
580: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
581: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
582: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
583: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

577: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
578: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
580: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
581: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
582: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
583: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
584: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
585: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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

578: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
580: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
581: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
582: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
583: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
584: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
585: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
586: 'cn.plsql.cn_api.pe_num_field_must_null.error',

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

579: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
580: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
581: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
582: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
583: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
584: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
585: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
586: 'cn.plsql.cn_api.pe_num_field_must_null.error',
587: true);

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

590: -- Error, check the msg level and add an error message to the
591: -- API message list
592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
595: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
597: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
598: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

591: -- API message list
592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
595: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
597: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
598: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
599: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
593: THEN
594: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
595: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
597: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
598: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
599: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
600: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

594: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
595: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
597: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
598: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
599: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
600: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
601: FND_MSG_PUB.Add;
602: END IF;

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

595: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
597: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
598: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
599: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
600: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
601: FND_MSG_PUB.Add;
602: END IF;
603: x_loading_status := 'CN_PE_FIELD_MUST_NULL';

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

596: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
597: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
598: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
599: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
600: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
601: FND_MSG_PUB.Add;
602: END IF;
603: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
604: l_return_code := FND_API.G_FALSE;

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

624: BEGIN
625: l_return_code := FND_API.G_TRUE;
626: x_loading_status := p_loading_status;
627: IF (p_char_field IS NOT NULL ) THEN
628: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
629: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
631: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
632: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

625: l_return_code := FND_API.G_TRUE;
626: x_loading_status := p_loading_status;
627: IF (p_char_field IS NOT NULL ) THEN
628: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
629: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
631: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
632: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
633: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

626: x_loading_status := p_loading_status;
627: IF (p_char_field IS NOT NULL ) THEN
628: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
629: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
631: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
632: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
633: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
634: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

628: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
629: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
631: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
632: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
633: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
634: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
635:
636: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

629: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
631: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
632: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
633: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
634: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
635:
636: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
637: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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

630: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
631: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
632: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
633: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
634: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
635:
636: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
637: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
638: 'cn.plsql.cn_api.pe_char_field_must_null.error',

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

642: -- Error, check the msg level and add an error message to the
643: -- API message list
644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
645: THEN
646: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
647: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
649: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
650: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

643: -- API message list
644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
645: THEN
646: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
647: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
649: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
650: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
651: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
645: THEN
646: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
647: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
649: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
650: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
651: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
652: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

646: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_MUST_NULL');
647: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
649: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
650: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
651: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
652: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
653: FND_MSG_PUB.Add;
654: END IF;

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

647: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
649: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
650: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
651: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
652: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
653: FND_MSG_PUB.Add;
654: END IF;
655: x_loading_status := 'CN_PE_FIELD_MUST_NULL';

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

648: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
649: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
650: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
651: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
652: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
653: FND_MSG_PUB.Add;
654: END IF;
655: x_loading_status := 'CN_PE_FIELD_MUST_NULL';
656: l_return_code := FND_API.G_FALSE;

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

676: BEGIN
677: l_return_code := FND_API.G_TRUE;
678: x_loading_status := p_loading_status;
679: IF (p_num_field IS NULL ) THEN
680: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
681: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
683: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
684: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

677: l_return_code := FND_API.G_TRUE;
678: x_loading_status := p_loading_status;
679: IF (p_num_field IS NULL ) THEN
680: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
681: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
683: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
684: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
685: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

678: x_loading_status := p_loading_status;
679: IF (p_num_field IS NULL ) THEN
680: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
681: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
683: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
684: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
685: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
686: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

680: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
681: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
683: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
684: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
685: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
686: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
687:
688: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

681: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
683: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
684: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
685: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
686: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
687:
688: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
689: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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

682: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
683: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
684: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
685: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
686: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
687:
688: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
689: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
690: 'cn.plsql.cn_api.pe_num_field_cannot_null.error',

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

694: -- Error, check the msg level and add an error message to the
695: -- API message list
696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
697: THEN
698: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
699: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
701: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
702: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

695: -- API message list
696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
697: THEN
698: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
699: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
701: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
702: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
703: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

696: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
697: THEN
698: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
699: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
701: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
702: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
703: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
704: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

698: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
699: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
701: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
702: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
703: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
704: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
705: FND_MSG_PUB.Add;
706: END IF;

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

699: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
701: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
702: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
703: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
704: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
705: FND_MSG_PUB.Add;
706: END IF;
707: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';

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

700: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
701: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
702: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
703: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
704: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
705: FND_MSG_PUB.Add;
706: END IF;
707: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
708: l_return_code := FND_API.G_FALSE;

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

728: BEGIN
729: l_return_code := FND_API.G_TRUE;
730: x_loading_status := p_loading_status;
731: IF (p_char_field IS NULL ) THEN
732: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
733: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
735: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
736: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

729: l_return_code := FND_API.G_TRUE;
730: x_loading_status := p_loading_status;
731: IF (p_char_field IS NULL ) THEN
732: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
733: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
735: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
736: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
737: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

730: x_loading_status := p_loading_status;
731: IF (p_char_field IS NULL ) THEN
732: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
733: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
735: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
736: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
737: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
738: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

732: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
733: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
735: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
736: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
737: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
738: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
739:
740: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

733: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
735: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
736: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
737: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
738: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
739:
740: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

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

734: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
735: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
736: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
737: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
738: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
739:
740: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
741: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
742: 'cn.plsql.cn_api.pe_char_field_cannot_null.error',

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

746: -- Error, check the msg level and add an error message to the
747: -- API message list
748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
749: THEN
750: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
751: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
753: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
754: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);

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

747: -- API message list
748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
749: THEN
750: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
751: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
753: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
754: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
755: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);

Line 752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',

748: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
749: THEN
750: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
751: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
753: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
754: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
755: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
756: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);

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

750: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_FIELD_CANNOT_NULL');
751: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
753: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
754: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
755: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
756: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
757: FND_MSG_PUB.Add;
758: END IF;

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

751: FND_MESSAGE.SET_TOKEN('OBJ_NAME',p_obj_name);
752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
753: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
754: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
755: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
756: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
757: FND_MSG_PUB.Add;
758: END IF;
759: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';

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

752: FND_MESSAGE.SET_TOKEN('PLAN_TYPE',
753: get_lkup_meaning(p_pe_type,'QUOTA_TYPE'));
754: FND_MESSAGE.SET_TOKEN('TOKEN1',p_token1);
755: FND_MESSAGE.SET_TOKEN('TOKEN2',p_token2);
756: FND_MESSAGE.SET_TOKEN('TOKEN3',p_token3);
757: FND_MSG_PUB.Add;
758: END IF;
759: x_loading_status := 'CN_PE_FIELD_CANNOT_NULL';
760: l_return_code := FND_API.G_FALSE;

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

929: -- Error, check the msg level and add an error message to the
930: -- API message list
931: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
932: THEN
933: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
934: FND_MSG_PUB.Add;
935: END IF;
936: END IF;
937: WHEN too_many_rows THEN

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

942: -- Error, check the msg level and add an error message to the
943: -- API message list
944: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
945: THEN
946: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
947: FND_MSG_PUB.Add;
948: END IF;
949: END IF;
950: END chk_and_get_salesrep_id;

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

1198: -- Error, check the msg level and add an error message to the
1199: -- API message list
1200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1201: THEN
1202: FND_MESSAGE.SET_NAME ('CN',x_loading_status);
1203: FND_MSG_PUB.Add;
1204: END IF;
1205: END IF;
1206:

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

1905: WHERE comp_plan_id = p_comp_plan_id;
1906: EXCEPTION
1907: WHEN NO_DATA_FOUND THEN
1908: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1909: FND_MESSAGE.SET_NAME ('CN' , 'CN_INVALID_COMP_PLAN');
1910: FND_MSG_PUB.Add;
1911: END IF;
1912: x_loading_status := 'CN_INVALID_COMP_PLAN';
1913: x_return_status := FND_API.G_RET_STS_ERROR;

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

2181: RETURN l_repcurr_amount;
2182:
2183: EXCEPTION
2184: WHEN NO_DATA_FOUND THEN
2185: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2186: FND_MSG_PUB.Add;
2187: APP_EXCEPTION.raise_exception;
2188: END convert_to_repcurr;
2189:

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

2295:
2296: EXCEPTION
2297: WHEN NO_DATA_FOUND THEN
2298: -- dbms_output.put_line('no data found --2 ');
2299: FND_MESSAGE.SET_NAME('CN','CN_CRCVFT_NOT_EXIST');
2300: FND_MSG_PUB.Add;
2301: x_return_status := 'E';
2302: END convert_to_repcurr_report;
2303:

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

2722: -- check payrun status, No operation can be done for PAID
2723: IF l_status <> 'UNPAID' THEN
2724: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2725: THEN
2726: fnd_message.set_name('CN', 'CN_CANNOT_UPD_PAID_F_PAYRUN');
2727: fnd_msg_pub.add;
2728: END IF;
2729: x_loading_status := 'CN_CANNOT_UPD_PAID_F_PAYRUN';
2730: RETURN fnd_api.g_true;

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

2733: -- check payrun exists
2734: IF l_payrun_id IS NULL THEN
2735: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2736: THEN
2737: fnd_message.set_name('CN', 'CN_PAYRUN_DOES_NOT_EXIST');
2738: fnd_msg_pub.add;
2739: END IF;
2740: x_loading_status := 'CN_PAYRUN_DOES_NOT_EXIST';
2741: RETURN fnd_api.g_true;

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

2776:
2777: IF l_status = 'Y' THEN
2778: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2779: THEN
2780: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2781: fnd_msg_pub.add;
2782: END IF;
2783: x_loading_status := 'CN_SRP_ON_HOLD';
2784: RETURN fnd_api.g_true;

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

2787: IF l_salesrep_id IS NULL THEN
2788: x_loading_status := 'CN_SRP_NOT_EXISTS';
2789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2790: THEN
2791: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2792: fnd_msg_pub.add;
2793: END IF;
2794: x_loading_status := 'CN_SRP_NOT_EXISTS';
2795: RETURN fnd_api.g_true;

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

2830:
2831: IF l_status = 'Y' THEN
2832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2833: THEN
2834: fnd_message.set_name('CN', 'CN_SRP_ON_HOLD');
2835: fnd_msg_pub.add;
2836: END IF;
2837: x_loading_status := 'CN_SRP_ON_HOLD';
2838: RETURN fnd_api.g_true;

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

2841: IF l_salesrep_id IS NULL THEN
2842: x_loading_status := 'CN_SRP_NOT_EXISTS';
2843: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2844: THEN
2845: fnd_message.set_name('CN', 'CN_SRP_NOT_EXISTS');
2846: fnd_msg_pub.add;
2847: END IF;
2848: x_loading_status := 'CN_SRP_NOT_EXISTS';
2849: RETURN fnd_api.g_true;

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

2923: THEN
2924: --Error condition
2925: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2926: THEN
2927: fnd_message.set_name('CN', 'CN_DUPLICATE_WORKSHEET');
2928: fnd_msg_pub.add;
2929: END IF;
2930: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
2931: RAISE FND_API.G_EXC_ERROR;

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

2970: THEN
2971: --Error condition
2972: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
2973: THEN
2974: fnd_message.set_name('CN', 'CN_WKSHT_CANNOT_BE_MODIFIED');
2975: fnd_msg_pub.add;
2976: END IF;
2977: x_loading_status := 'CN_WKSHT_CANNOT_BE_MODIFIED';
2978: RAISE FND_API.G_EXC_ERROR;