[Home] [Help]
251: OR l_trxapi_imp.employee_number IS NULL
252: OR l_trxapi_imp.revenue_type IS NULL THEN
253: l_failed_row := l_failed_row + 1;
254: l_error_code := 'CN_IMP_MISS_REQUIRED';
255: l_message := fnd_message.get_string('CN','CN_IMP_MISS_REQUIRED');
256: CN_IMPORT_PVT.update_imp_lines
257: (p_imp_line_id => l_trxapi_imp.imp_line_id,
258: p_status_code => 'FAIL',
259: p_error_code => l_error_code,
285: EXCEPTION
286: WHEN no_data_found THEN
287: l_failed_row := l_failed_row + 1;
288: l_error_code := 'CN_IMP_NF_RSRC_ID';
289: l_message := fnd_message.get_string('CN','CN_IMP_NF_RSRC_ID');
290: CN_IMPORT_PVT.update_imp_lines
291: (p_imp_line_id => l_trxapi_imp.imp_line_id,
292: p_status_code => 'FAIL',
293: p_error_code => l_error_code,
320: EXCEPTION
321: WHEN no_data_found THEN
322: l_failed_row := l_failed_row + 1;
323: l_error_code := 'NOT_WITHIN_OPEN_PERIODS';
324: l_message := fnd_message.get_string('CN','NOT_WITHIN_OPEN_PERIODS');
325: CN_IMPORT_PVT.update_imp_lines
326: (p_imp_line_id => l_trxapi_imp.imp_line_id,
327: p_status_code => 'FAIL',
328: p_error_code => l_error_code,
354: p_org_id => p_org_id);
355: IF l_rev_class_id IS NULL THEN
356: l_failed_row := l_failed_row + 1;
357: l_error_code := 'CN_IMP_NF_REVCLS_ID';
358: l_message := fnd_message.get_string('CN','CN_IMP_NF_REVCLS_ID');
359: CN_IMPORT_PVT.update_imp_lines
360: (p_imp_line_id => l_trxapi_imp.imp_line_id,
361: p_status_code => 'FAIL',
362: p_error_code => l_error_code,
391: WHEN no_data_found THEN
392: l_failed_row := l_failed_row + 1;
393: l_error_code := 'CN_IMP_NF_QUOTA';
394: l_message :=
395: fnd_message.get_string('CN','CN_IMP_NF_QUOTA');
396: CN_IMPORT_PVT.update_imp_lines
397: (p_imp_line_id => l_trxapi_imp.imp_line_id,
398: p_status_code => 'FAIL',
399: p_error_code => l_error_code,
429: WHEN no_data_found THEN
430: l_failed_row := l_failed_row + 1;
431: l_error_code := 'CN_IMP_NF_CG';
432: l_message :=
433: fnd_message.get_string('CN','CN_IMP_NF_CG');
434: CN_IMPORT_PVT.update_imp_lines
435: (p_imp_line_id => l_trxapi_imp.imp_line_id,
436: p_status_code => 'FAIL',
437: p_error_code => l_error_code,
461: (p_role_name => l_trxapi_imp.role_name);
462: IF l_role_id IS NULL THEN
463: l_failed_row := l_failed_row + 1;
464: l_error_code := 'CN_IMP_NF_ROLE';
465: l_message := fnd_message.get_string('CN','CN_IMP_NF_ROLE');
466: CN_IMPORT_PVT.update_imp_lines
467: (p_imp_line_id => l_trxapi_imp.imp_line_id,
468: p_status_code => 'FAIL',
469: p_error_code => l_error_code,
498: WHEN no_data_found THEN
499: l_failed_row := l_failed_row + 1;
500: l_error_code := 'CN_IMP_NF_ROLLUP_DATE';
501: l_message :=
502: fnd_message.get_string('CN','CN_IMP_NF_ROLLUP_DATE');
503: CN_IMPORT_PVT.update_imp_lines
504: (p_imp_line_id => l_trxapi_imp.imp_line_id,
505: p_status_code => 'FAIL',
506: p_error_code => l_error_code,
532: p_lkup_type => 'REVENUE_TYPE' );
533: IF l_meaning IS NULL THEN
534: l_failed_row := l_failed_row + 1;
535: l_error_code := 'CN_IMP_NF_REV_TYPE';
536: l_message := fnd_message.get_string('CN','CN_IMP_NF_REV_TYPE');
537: CN_IMPORT_PVT.update_imp_lines
538: (p_imp_line_id => l_trxapi_imp.imp_line_id,
539: p_status_code => 'FAIL',
540: p_error_code => l_error_code,
565: p_lkup_type => 'ADJUSTMENT_REASON' );
566: IF l_meaning IS NULL THEN
567: l_failed_row := l_failed_row + 1;
568: l_error_code := 'CN_IMP_NF_REASON_CODE';
569: l_message := fnd_message.get_string('CN','CN_IMP_NF_REASON_CODE');
570: CN_IMPORT_PVT.update_imp_lines
571: (p_imp_line_id => l_trxapi_imp.imp_line_id,
572: p_status_code => 'FAIL',
573: p_error_code => l_error_code,
598: p_lkup_type => 'PRE_PROCESSED_CODE' );
599: IF l_meaning IS NULL THEN
600: l_failed_row := l_failed_row + 1;
601: l_error_code := 'CN_IMP_NF_PRE_PROC_CODE';
602: l_message := fnd_message.get_string('CN','CN_IMP_NF_PRE_PRO_CODE');
603: CN_IMPORT_PVT.update_imp_lines
604: (p_imp_line_id => l_trxapi_imp.imp_line_id,
605: p_status_code => 'FAIL',
606: p_error_code => l_error_code,
635: WHEN no_data_found THEN
636: l_failed_row := l_failed_row + 1;
637: l_error_code := 'CN_IMP_NF_TRX_CURR_CODE';
638: l_message :=
639: fnd_message.get_string('CN','CN_IMP_NF_TRX_CURR_CODE');
640: CN_IMPORT_PVT.update_imp_lines
641: (p_imp_line_id => l_trxapi_imp.imp_line_id,
642: p_status_code => 'FAIL',
643: 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',
803: IF l_err_flag = 'Y'
804: THEN
805: l_failed_row := l_failed_row + 1;
806: l_error_code := 'CN_ORDER_NUMBER_ALPHANUM';
807: l_message := fnd_message.get_string('CN','CN_ORDER_NUMBER_ALPHANUM');
808:
809: CN_IMPORT_PVT.update_imp_lines
810: (p_imp_line_id => l_trxapi_imp.imp_line_id,
811: p_status_code => 'FAIL',