205: RETURN TRUE;
206:
207: ELSIF g_mode = C_UPDATE_MODE THEN
208:
209: fnd_message.set_name('XLA','XLA_TB_INVALID_DEF_CODE');
210: fnd_message.set_token('DEFINITION_CODE'
211: ,p_definition_rec.definition_code);
212:
213: fnd_msg_pub.add;
206:
207: ELSIF g_mode = C_UPDATE_MODE THEN
208:
209: fnd_message.set_name('XLA','XLA_TB_INVALID_DEF_CODE');
210: fnd_message.set_token('DEFINITION_CODE'
211: ,p_definition_rec.definition_code);
212:
213: fnd_msg_pub.add;
214: RETURN FALSE;
218: ELSIF l_db_cnt = 1 THEN
219:
220: IF g_mode = C_CREATE_MODE THEN
221:
222: fnd_message.set_name('XLA','XLA_TB_PARAM_DUP_DEF_CODE');
223: fnd_msg_pub.add;
224: RETURN FALSE;
225:
226: ELSIF g_mode = C_UPDATE_MODE THEN
297:
298: --
299: -- if p_ledger_id is invalid, then return false.
300: --
301: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
302: fnd_message.set_token('PARAMETER_VALUE',p_ledger_id);
303: fnd_message.set_token('PARAMETER','p_ledger_id');
304:
305: fnd_msg_pub.add;
298: --
299: -- if p_ledger_id is invalid, then return false.
300: --
301: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
302: fnd_message.set_token('PARAMETER_VALUE',p_ledger_id);
303: fnd_message.set_token('PARAMETER','p_ledger_id');
304:
305: fnd_msg_pub.add;
306: RETURN FALSE;
299: -- if p_ledger_id is invalid, then return false.
300: --
301: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
302: fnd_message.set_token('PARAMETER_VALUE',p_ledger_id);
303: fnd_message.set_token('PARAMETER','p_ledger_id');
304:
305: fnd_msg_pub.add;
306: RETURN FALSE;
307:
448: -- No ccid in the GT table
449: --
450: IF g_mode = C_CREATE_MODE THEN
451:
452: fnd_message.set_name('XLA','XLA_TB_NO_CCID_IN_GT');
453: fnd_msg_pub.add;
454:
455: RETURN FALSE;
456:
494: ELSE
495:
496: FOR i IN t_array_ccid.FIRST .. t_array_ccid.LAST LOOP
497:
498: fnd_message.set_name('XLA','XLA_TB_INVALID_CCID');
499: fnd_message.set_token('CCID',t_array_ccid(i));
500: fnd_msg_pub.add;
501:
502: END LOOP;
495:
496: FOR i IN t_array_ccid.FIRST .. t_array_ccid.LAST LOOP
497:
498: fnd_message.set_name('XLA','XLA_TB_INVALID_CCID');
499: fnd_message.set_token('CCID',t_array_ccid(i));
500: fnd_msg_pub.add;
501:
502: END LOOP;
503:
567: -- Mandatory parameters check
568: --
569: IF p_definition_rec.definition_code IS NULL THEN
570:
571: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
572: fnd_message.set_token('PARAMETER','p_definition_code');
573:
574: fnd_msg_pub.add;
575: l_err_found := TRUE;
568: --
569: IF p_definition_rec.definition_code IS NULL THEN
570:
571: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
572: fnd_message.set_token('PARAMETER','p_definition_code');
573:
574: fnd_msg_pub.add;
575: l_err_found := TRUE;
576:
577: END IF;
578:
579: IF p_definition_rec.name IS NULL THEN
580:
581: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
582: fnd_message.set_token('PARAMETER','p_definition_name');
583:
584: fnd_msg_pub.add;
585: l_err_found := TRUE;
578:
579: IF p_definition_rec.name IS NULL THEN
580:
581: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
582: fnd_message.set_token('PARAMETER','p_definition_name');
583:
584: fnd_msg_pub.add;
585: l_err_found := TRUE;
586:
587: END IF;
588:
589: IF p_definition_rec.ledger_id IS NULL THEN
590:
591: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
592: fnd_message.set_token('PARAMETER','p_ledger_id');
593:
594: fnd_msg_pub.add;
595: l_err_found := TRUE;
588:
589: IF p_definition_rec.ledger_id IS NULL THEN
590:
591: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
592: fnd_message.set_token('PARAMETER','p_ledger_id');
593:
594: fnd_msg_pub.add;
595: l_err_found := TRUE;
596:
597: END IF;
598:
599: IF p_je_source_name IS NULL THEN
600:
601: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
602: fnd_message.set_token('PARAMETER','p_je_source_name');
603:
604: fnd_msg_pub.add;
605: l_err_found := TRUE;
598:
599: IF p_je_source_name IS NULL THEN
600:
601: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
602: fnd_message.set_token('PARAMETER','p_je_source_name');
603:
604: fnd_msg_pub.add;
605: l_err_found := TRUE;
606:
609: IF g_mode = C_UPDATE_MODE THEN
610:
611: IF p_gl_date_from IS NULL THEN
612:
613: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
614: fnd_message.set_token('PARAMETER','p_gl_date_from');
615:
616: fnd_msg_pub.add;
617: l_err_found := TRUE;
610:
611: IF p_gl_date_from IS NULL THEN
612:
613: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
614: fnd_message.set_token('PARAMETER','p_gl_date_from');
615:
616: fnd_msg_pub.add;
617: l_err_found := TRUE;
618:
619: END IF;
620:
621: IF p_gl_date_to IS NULL THEN
622:
623: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
624: fnd_message.set_token('PARAMETER','p_gl_date_to');
625:
626: fnd_msg_pub.add;
627: l_err_found := TRUE;
620:
621: IF p_gl_date_to IS NULL THEN
622:
623: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
624: fnd_message.set_token('PARAMETER','p_gl_date_to');
625:
626: fnd_msg_pub.add;
627: l_err_found := TRUE;
628:
631: END IF;
632:
633: IF p_mode IS NULL THEN
634:
635: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
636: fnd_message.set_token('PARAMETER','p_mode');
637:
638: fnd_msg_pub.add;
639: l_err_found := TRUE;
632:
633: IF p_mode IS NULL THEN
634:
635: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
636: fnd_message.set_token('PARAMETER','p_mode');
637:
638: fnd_msg_pub.add;
639: l_err_found := TRUE;
640:
639: l_err_found := TRUE;
640:
641: ELSIF p_mode NOT IN (C_CREATE_MODE, C_UPDATE_MODE) THEN
642:
643: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
644: fnd_message.set_token('PARAMETER_VALUE',p_mode);
645: fnd_message.set_token('PARAMETER','p_mode');
646:
647: fnd_msg_pub.add;
640:
641: ELSIF p_mode NOT IN (C_CREATE_MODE, C_UPDATE_MODE) THEN
642:
643: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
644: fnd_message.set_token('PARAMETER_VALUE',p_mode);
645: fnd_message.set_token('PARAMETER','p_mode');
646:
647: fnd_msg_pub.add;
648: l_err_found := TRUE;
641: ELSIF p_mode NOT IN (C_CREATE_MODE, C_UPDATE_MODE) THEN
642:
643: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
644: fnd_message.set_token('PARAMETER_VALUE',p_mode);
645: fnd_message.set_token('PARAMETER','p_mode');
646:
647: fnd_msg_pub.add;
648: l_err_found := TRUE;
649: