217: RETURN TRUE;
218:
219: ELSIF g_mode = C_UPDATE_MODE THEN
220:
221: fnd_message.set_name('XLA','XLA_TB_INVALID_DEF_CODE');
222: fnd_message.set_token('DEFINITION_CODE'
223: ,p_definition_rec.definition_code);
224:
225: fnd_msg_pub.add;
218:
219: ELSIF g_mode = C_UPDATE_MODE THEN
220:
221: fnd_message.set_name('XLA','XLA_TB_INVALID_DEF_CODE');
222: fnd_message.set_token('DEFINITION_CODE'
223: ,p_definition_rec.definition_code);
224:
225: fnd_msg_pub.add;
226: RETURN FALSE;
230: ELSIF l_db_cnt = 1 THEN
231:
232: IF g_mode = C_CREATE_MODE THEN
233:
234: fnd_message.set_name('XLA','XLA_TB_PARAM_DUP_DEF_CODE');
235: fnd_msg_pub.add;
236: RETURN FALSE;
237:
238: ELSIF g_mode = C_UPDATE_MODE THEN
309:
310: --
311: -- if p_ledger_id is invalid, then return false.
312: --
313: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
314: fnd_message.set_token('PARAMETER_VALUE',p_ledger_id);
315: fnd_message.set_token('PARAMETER','p_ledger_id');
316:
317: fnd_msg_pub.add;
310: --
311: -- if p_ledger_id is invalid, then return false.
312: --
313: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
314: fnd_message.set_token('PARAMETER_VALUE',p_ledger_id);
315: fnd_message.set_token('PARAMETER','p_ledger_id');
316:
317: fnd_msg_pub.add;
318: RETURN FALSE;
311: -- if p_ledger_id is invalid, then return false.
312: --
313: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
314: fnd_message.set_token('PARAMETER_VALUE',p_ledger_id);
315: fnd_message.set_token('PARAMETER','p_ledger_id');
316:
317: fnd_msg_pub.add;
318: RETURN FALSE;
319:
460: -- No ccid in the GT table
461: --
462: IF g_mode = C_CREATE_MODE THEN
463:
464: fnd_message.set_name('XLA','XLA_TB_NO_CCID_IN_GT');
465: fnd_msg_pub.add;
466:
467: RETURN FALSE;
468:
506: ELSE
507:
508: FOR i IN t_array_ccid.FIRST .. t_array_ccid.LAST LOOP
509:
510: fnd_message.set_name('XLA','XLA_TB_INVALID_CCID');
511: fnd_message.set_token('CCID',t_array_ccid(i));
512: fnd_msg_pub.add;
513:
514: END LOOP;
507:
508: FOR i IN t_array_ccid.FIRST .. t_array_ccid.LAST LOOP
509:
510: fnd_message.set_name('XLA','XLA_TB_INVALID_CCID');
511: fnd_message.set_token('CCID',t_array_ccid(i));
512: fnd_msg_pub.add;
513:
514: END LOOP;
515:
579: -- Mandatory parameters check
580: --
581: IF p_definition_rec.definition_code IS NULL THEN
582:
583: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
584: fnd_message.set_token('PARAMETER','p_definition_code');
585:
586: fnd_msg_pub.add;
587: l_err_found := TRUE;
580: --
581: IF p_definition_rec.definition_code IS NULL THEN
582:
583: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
584: fnd_message.set_token('PARAMETER','p_definition_code');
585:
586: fnd_msg_pub.add;
587: l_err_found := TRUE;
588:
589: END IF;
590:
591: IF p_definition_rec.name IS NULL THEN
592:
593: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
594: fnd_message.set_token('PARAMETER','p_definition_name');
595:
596: fnd_msg_pub.add;
597: l_err_found := TRUE;
590:
591: IF p_definition_rec.name IS NULL THEN
592:
593: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
594: fnd_message.set_token('PARAMETER','p_definition_name');
595:
596: fnd_msg_pub.add;
597: l_err_found := TRUE;
598:
599: END IF;
600:
601: IF p_definition_rec.ledger_id IS NULL THEN
602:
603: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
604: fnd_message.set_token('PARAMETER','p_ledger_id');
605:
606: fnd_msg_pub.add;
607: l_err_found := TRUE;
600:
601: IF p_definition_rec.ledger_id IS NULL THEN
602:
603: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
604: fnd_message.set_token('PARAMETER','p_ledger_id');
605:
606: fnd_msg_pub.add;
607: l_err_found := TRUE;
608:
609: END IF;
610:
611: IF p_je_source_name IS NULL THEN
612:
613: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
614: fnd_message.set_token('PARAMETER','p_je_source_name');
615:
616: fnd_msg_pub.add;
617: l_err_found := TRUE;
610:
611: IF p_je_source_name IS NULL THEN
612:
613: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
614: fnd_message.set_token('PARAMETER','p_je_source_name');
615:
616: fnd_msg_pub.add;
617: l_err_found := TRUE;
618:
621: IF g_mode = C_UPDATE_MODE THEN
622:
623: IF p_gl_date_from IS NULL THEN
624:
625: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
626: fnd_message.set_token('PARAMETER','p_gl_date_from');
627:
628: fnd_msg_pub.add;
629: l_err_found := TRUE;
622:
623: IF p_gl_date_from IS NULL THEN
624:
625: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
626: fnd_message.set_token('PARAMETER','p_gl_date_from');
627:
628: fnd_msg_pub.add;
629: l_err_found := TRUE;
630:
631: END IF;
632:
633: IF p_gl_date_to IS NULL THEN
634:
635: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
636: fnd_message.set_token('PARAMETER','p_gl_date_to');
637:
638: fnd_msg_pub.add;
639: l_err_found := TRUE;
632:
633: IF p_gl_date_to IS NULL THEN
634:
635: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
636: fnd_message.set_token('PARAMETER','p_gl_date_to');
637:
638: fnd_msg_pub.add;
639: l_err_found := TRUE;
640:
643: END IF;
644:
645: IF p_mode IS NULL THEN
646:
647: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
648: fnd_message.set_token('PARAMETER','p_mode');
649:
650: fnd_msg_pub.add;
651: l_err_found := TRUE;
644:
645: IF p_mode IS NULL THEN
646:
647: fnd_message.set_name('XLA','XLA_COMMON_NULL_PARAM');
648: fnd_message.set_token('PARAMETER','p_mode');
649:
650: fnd_msg_pub.add;
651: l_err_found := TRUE;
652:
651: l_err_found := TRUE;
652:
653: ELSIF p_mode NOT IN (C_CREATE_MODE, C_UPDATE_MODE) THEN
654:
655: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
656: fnd_message.set_token('PARAMETER_VALUE',p_mode);
657: fnd_message.set_token('PARAMETER','p_mode');
658:
659: fnd_msg_pub.add;
652:
653: ELSIF p_mode NOT IN (C_CREATE_MODE, C_UPDATE_MODE) THEN
654:
655: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
656: fnd_message.set_token('PARAMETER_VALUE',p_mode);
657: fnd_message.set_token('PARAMETER','p_mode');
658:
659: fnd_msg_pub.add;
660: l_err_found := TRUE;
653: ELSIF p_mode NOT IN (C_CREATE_MODE, C_UPDATE_MODE) THEN
654:
655: fnd_message.set_name('XLA','XLA_COMMON_INVALID_PARAM2');
656: fnd_message.set_token('PARAMETER_VALUE',p_mode);
657: fnd_message.set_token('PARAMETER','p_mode');
658:
659: fnd_msg_pub.add;
660: l_err_found := TRUE;
661: