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);
248: end if;
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);
248: end if;
249:
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);
286: end if;
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);
286: end if;
287:
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);
324: end if;
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);
324: end if;
325:
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);
362: end if;
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);
362: end if;
363:
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);
398: end if;
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);
398: end if;
399:
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);
434: end if;
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);
434: end if;
435:
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);
470: end if;
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);
470: end if;
471:
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);
506: end if;
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);
506: end if;
507:
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);
542: end if;
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);
542: end if;
543:
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);
588: end if;
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);
588: end if;
589:
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',
639: true);
640: end if;
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',
639: true);
640: end if;
641:
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',
691: true);
692: end if;
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',
691: true);
692: end if;
693:
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',
743: true);
744: end if;
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',
743: true);
744: end if;
745: