[Home] [Help]
391:
392: -- IF (period_info%notfound) THEN
393: -- CLOSE period_info;
394: IF l_org_id <> p_org_id THEN
395: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
396: fnd_msg_pub.add;
397: RAISE fnd_api.g_exc_unexpected_error;
398: END IF;
399: -- CLOSE period_info;
398: END IF;
399: -- CLOSE period_info;
400:
401: IF (l_object_version_number <> p_acc_period_tbl(i).object_version_number) THEN
402: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
403: fnd_msg_pub.add;
404: RAISE fnd_api.g_exc_unexpected_error;
405: END IF;
406:
476: END IF;
477:
478: /* commented out for bug 5035044
479: IF (l_quarter_num NOT IN (1, 2, 3, 4)) THEN
480: fnd_message.set_name('CN', 'CNSYPR_QUARTER_NUMBER');
481: fnd_msg_pub.add;
482: RAISE fnd_api.g_exc_error;
483: END IF;
484: */
484: */
485:
486: IF (l_closing_status = 'O' AND l_closing_status_old <> 'O' ) THEN
487: IF (l_closing_status_old = 'P') THEN
488: fnd_message.set_name('CN', 'CNSYPR_OPEN_PERIOD');
489: fnd_msg_pub.add;
490: RAISE fnd_api.g_exc_error;
491: END IF;
492:
491: END IF;
492:
493: -- can not open a period whose previous period is Never Opened
494: IF (l_pre_status = 'N') THEN
495: fnd_message.set_name('CN', 'CNSYPR_OPEN_PRE_NEVER');
496: fnd_msg_pub.add;
497: RAISE fnd_api.g_exc_error;
498: -- can not open a period whose previous period is Future Enterable
499: elsif (l_pre_status = 'F') then
496: fnd_msg_pub.add;
497: RAISE fnd_api.g_exc_error;
498: -- can not open a period whose previous period is Future Enterable
499: elsif (l_pre_status = 'F') then
500: fnd_message.set_name('CN', 'CNSYPR_OPEN_PRE_FUTURE');
501: fnd_msg_pub.add;
502: raise fnd_api.g_exc_error;
503:
504: -- can not open a period whose next period is Closed or Permanently Closed
502: raise fnd_api.g_exc_error;
503:
504: -- can not open a period whose next period is Closed or Permanently Closed
505: elsif (l_next_status IN ('P', 'C')) then
506: fnd_message.set_name('CN', 'CNSYPR_OPEN_NEXT_CLOSE');
507: fnd_msg_pub.add;
508: raise fnd_api.g_exc_error;
509: end if;
510: END IF;
510: END IF;
511:
512: IF ((l_closing_status = 'C' AND l_closing_status_old <> 'C') OR (l_closing_status = 'P' AND l_closing_status_old <> 'P')) THEN
513: --IF ((l_closing_status = 'C' AND l_closing_status_old <> 'O') OR (l_closing_status = 'P' AND l_closing_status_old NOT IN ('O', 'C'))) THEN
514: -- fnd_message.set_name('CN', 'CN_CLOSE_PERIOD');
515: -- fnd_msg_pub.add;
516: -- RAISE fnd_api.g_exc_error;
517: --END IF;
518:
518:
519: -- can not close/permanently close a period whose previous period is not closed
520: -- Note: when a period is open, it is impossible for its previous period to be Never Opened or Future Entry
521: if (l_pre_status = 'O') then
522: fnd_message.set_name('CN', 'CNSYPR_CLOSE_PRE_OPEN');
523: fnd_msg_pub.add;
524: raise fnd_api.g_exc_error;
525: END IF;
526: END IF;
526: END IF;
527:
528: IF (l_closing_status = 'F' AND l_closing_status_old <> 'F') THEN
529: IF (l_closing_status_old <> 'N') THEN
530: fnd_message.set_name('CN', 'CNSYPR_FUTURE_ENTERABLE');
531: fnd_msg_pub.add;
532: RAISE fnd_api.g_exc_error;
533: END IF;
534:
533: END IF;
534:
535: -- can not set a period to F whose previous period is Never Opened
536: if (l_pre_status = 'N') then
537: fnd_message.set_name('CN', 'CNSYPR_FUTURE_PRE_NEVER');
538: fnd_msg_pub.add;
539: raise fnd_api.g_exc_error;
540: END IF;
541: END IF;
577: --because the information was identical to what exists in the db.
578: --bug # 2471028
579:
580: IF (l_update_flag = 'N') THEN
581: fnd_message.set_name('CN', 'CN_NO_CHANGES');
582: fnd_msg_pub.add;
583: END IF;
584:
585: -- Call concurrent program