[Home] [Help]
250: OR l_trxapi_imp.employee_number IS NULL
251: OR l_trxapi_imp.revenue_type IS NULL THEN
252: l_failed_row := l_failed_row + 1;
253: l_error_code := 'CN_IMP_MISS_REQUIRED';
254: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
255: CN_IMPORT_PVT.update_imp_lines
256: (p_imp_line_id => l_trxapi_imp.imp_line_id,
257: p_status_code => 'FAIL',
258: p_error_code => l_error_code,
284: EXCEPTION
285: WHEN no_data_found THEN
286: l_failed_row := l_failed_row + 1;
287: l_error_code := 'CN_IMP_NF_RSRC_ID';
288: l_message := fnd_message.get_string('CN','CN_IMP_NF_RSRC_ID');
289: CN_IMPORT_PVT.update_imp_lines
290: (p_imp_line_id => l_trxapi_imp.imp_line_id,
291: p_status_code => 'FAIL',
292: p_error_code => l_error_code,
319: EXCEPTION
320: WHEN no_data_found THEN
321: l_failed_row := l_failed_row + 1;
322: l_error_code := 'NOT_WITHIN_OPEN_PERIODS';
323: l_message := fnd_message.get_string('CN','NOT_WITHIN_OPEN_PERIODS');
324: CN_IMPORT_PVT.update_imp_lines
325: (p_imp_line_id => l_trxapi_imp.imp_line_id,
326: p_status_code => 'FAIL',
327: p_error_code => l_error_code,
353: p_org_id => p_org_id);
354: IF l_rev_class_id IS NULL THEN
355: l_failed_row := l_failed_row + 1;
356: l_error_code := 'CN_IMP_NF_REVCLS_ID';
357: l_message := fnd_message.get_string('CN','CN_IMP_NF_REVCLS_ID');
358: CN_IMPORT_PVT.update_imp_lines
359: (p_imp_line_id => l_trxapi_imp.imp_line_id,
360: p_status_code => 'FAIL',
361: p_error_code => l_error_code,
390: WHEN no_data_found THEN
391: l_failed_row := l_failed_row + 1;
392: l_error_code := 'CN_IMP_NF_QUOTA';
393: l_message :=
394: fnd_message.get_string('CN','CN_IMP_NF_QUOTA');
395: CN_IMPORT_PVT.update_imp_lines
396: (p_imp_line_id => l_trxapi_imp.imp_line_id,
397: p_status_code => 'FAIL',
398: p_error_code => l_error_code,
428: WHEN no_data_found THEN
429: l_failed_row := l_failed_row + 1;
430: l_error_code := 'CN_IMP_NF_CG';
431: l_message :=
432: fnd_message.get_string('CN','CN_IMP_NF_CG');
433: CN_IMPORT_PVT.update_imp_lines
434: (p_imp_line_id => l_trxapi_imp.imp_line_id,
435: p_status_code => 'FAIL',
436: p_error_code => l_error_code,
460: (p_role_name => l_trxapi_imp.role_name);
461: IF l_role_id IS NULL THEN
462: l_failed_row := l_failed_row + 1;
463: l_error_code := 'CN_IMP_NF_ROLE';
464: l_message := fnd_message.get_string('CN','CN_IMP_NF_ROLE');
465: CN_IMPORT_PVT.update_imp_lines
466: (p_imp_line_id => l_trxapi_imp.imp_line_id,
467: p_status_code => 'FAIL',
468: p_error_code => l_error_code,
497: WHEN no_data_found THEN
498: l_failed_row := l_failed_row + 1;
499: l_error_code := 'CN_IMP_NF_ROLLUP_DATE';
500: l_message :=
501: fnd_message.get_string('CN','CN_IMP_NF_ROLLUP_DATE');
502: CN_IMPORT_PVT.update_imp_lines
503: (p_imp_line_id => l_trxapi_imp.imp_line_id,
504: p_status_code => 'FAIL',
505: p_error_code => l_error_code,
531: p_lkup_type => 'REVENUE_TYPE' );
532: IF l_meaning IS NULL THEN
533: l_failed_row := l_failed_row + 1;
534: l_error_code := 'CN_IMP_NF_REV_TYPE';
535: l_message := fnd_message.get_string('CN','CN_IMP_NF_REV_TYPE');
536: CN_IMPORT_PVT.update_imp_lines
537: (p_imp_line_id => l_trxapi_imp.imp_line_id,
538: p_status_code => 'FAIL',
539: p_error_code => l_error_code,
564: p_lkup_type => 'ADJUSTMENT_REASON' );
565: IF l_meaning IS NULL THEN
566: l_failed_row := l_failed_row + 1;
567: l_error_code := 'CN_IMP_NF_REASON_CODE';
568: l_message := fnd_message.get_string('CN','CN_IMP_NF_REASON_CODE');
569: CN_IMPORT_PVT.update_imp_lines
570: (p_imp_line_id => l_trxapi_imp.imp_line_id,
571: p_status_code => 'FAIL',
572: p_error_code => l_error_code,
597: p_lkup_type => 'PRE_PROCESSED_CODE' );
598: IF l_meaning IS NULL THEN
599: l_failed_row := l_failed_row + 1;
600: l_error_code := 'CN_IMP_NF_PRE_PROC_CODE';
601: l_message := fnd_message.get_string('CN','CN_IMP_NF_PRE_PRO_CODE');
602: CN_IMPORT_PVT.update_imp_lines
603: (p_imp_line_id => l_trxapi_imp.imp_line_id,
604: p_status_code => 'FAIL',
605: p_error_code => l_error_code,
634: WHEN no_data_found THEN
635: l_failed_row := l_failed_row + 1;
636: l_error_code := 'CN_IMP_NF_TRX_CURR_CODE';
637: l_message :=
638: fnd_message.get_string('CN','CN_IMP_NF_TRX_CURR_CODE');
639: CN_IMPORT_PVT.update_imp_lines
640: (p_imp_line_id => l_trxapi_imp.imp_line_id,
641: p_status_code => 'FAIL',
642: p_error_code => l_error_code,
680: WHEN others THEN
681:
682: l_failed_row := l_failed_row + 1;
683: l_error_code := 'CN_IMP_NOT_VALID_NUMBER';
684: l_message := fnd_message.get_string('CN','CN_IMP_NOT_VALID_NUMBER');
685:
686: CN_IMPORT_PVT.update_imp_lines
687: (p_imp_line_id => l_trxapi_imp.imp_line_id,
688: p_status_code => 'FAIL',
713: IF l_trxapi_imp.split_pct is not null AND l_trxapi_imp.split_pct <= 0 THEN
714:
715: l_failed_row := l_failed_row + 1;
716: l_error_code := 'CN_IMP_NOT_ZERO_NEG';
717: l_message := fnd_message.get_string('CN','CN_IMP_NOT_ZERO_NEG');
718:
719: CN_IMPORT_PVT.update_imp_lines
720: (p_imp_line_id => l_trxapi_imp.imp_line_id,
721: p_status_code => 'FAIL',
748: IF upper(l_trxapi_imp.revenue_type) = 'REVENUE' AND l_trxapi_imp.split_pct > 100 THEN
749:
750: l_failed_row := l_failed_row + 1;
751: l_error_code := 'CN_REVENUE_TYPE_SPLIT_PCT_100';
752: l_message := fnd_message.get_string('CN','CN_REVENUE_TYPE_SPLIT_PCT_100');
753:
754: CN_IMPORT_PVT.update_imp_lines
755: (p_imp_line_id => l_trxapi_imp.imp_line_id,
756: p_status_code => 'FAIL',