622: end loop;
623: END IF;
624: ELSE
625:
626: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
627: FND_MESSAGE.set_token( 'GENERIC_TEXT', p_message_text );
628:
629: END IF;
630: END put_message_on_stack;
623: END IF;
624: ELSE
625:
626: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
627: FND_MESSAGE.set_token( 'GENERIC_TEXT', p_message_text );
628:
629: END IF;
630: END put_message_on_stack;
631:
640:
641: print_fcn_label( 'arp_auto_accounting.get_error_message_text()+' );
642:
643: l_msg_name := '1360';
644: fnd_message.set_name('AR', l_msg_name);
645: MSG_COMPLETE_REV_ACCOUNT := fnd_message.get;
646:
647: ----
648: l_msg_name := '1350';
641: print_fcn_label( 'arp_auto_accounting.get_error_message_text()+' );
642:
643: l_msg_name := '1360';
644: fnd_message.set_name('AR', l_msg_name);
645: MSG_COMPLETE_REV_ACCOUNT := fnd_message.get;
646:
647: ----
648: l_msg_name := '1350';
649: fnd_message.set_name('AR', l_msg_name);
645: MSG_COMPLETE_REV_ACCOUNT := fnd_message.get;
646:
647: ----
648: l_msg_name := '1350';
649: fnd_message.set_name('AR', l_msg_name);
650: MSG_COMPLETE_REC_ACCOUNT := fnd_message.get;
651:
652: ----
653: l_msg_name := '1370';
646:
647: ----
648: l_msg_name := '1350';
649: fnd_message.set_name('AR', l_msg_name);
650: MSG_COMPLETE_REC_ACCOUNT := fnd_message.get;
651:
652: ----
653: l_msg_name := '1370';
654: fnd_message.set_name('AR', l_msg_name);
650: MSG_COMPLETE_REC_ACCOUNT := fnd_message.get;
651:
652: ----
653: l_msg_name := '1370';
654: fnd_message.set_name('AR', l_msg_name);
655: MSG_COMPLETE_FRT_ACCOUNT := fnd_message.get;
656:
657: ----
658: l_msg_name := 'I-120';
651:
652: ----
653: l_msg_name := '1370';
654: fnd_message.set_name('AR', l_msg_name);
655: MSG_COMPLETE_FRT_ACCOUNT := fnd_message.get;
656:
657: ----
658: l_msg_name := 'I-120';
659: fnd_message.set_name('AR', l_msg_name);
655: MSG_COMPLETE_FRT_ACCOUNT := fnd_message.get;
656:
657: ----
658: l_msg_name := 'I-120';
659: fnd_message.set_name('AR', l_msg_name);
660: MSG_COMPLETE_TAX_ACCOUNT := fnd_message.get;
661:
662: ----
663: l_msg_name := '1365';
656:
657: ----
658: l_msg_name := 'I-120';
659: fnd_message.set_name('AR', l_msg_name);
660: MSG_COMPLETE_TAX_ACCOUNT := fnd_message.get;
661:
662: ----
663: l_msg_name := '1365';
664: fnd_message.set_name('AR', l_msg_name);
660: MSG_COMPLETE_TAX_ACCOUNT := fnd_message.get;
661:
662: ----
663: l_msg_name := '1365';
664: fnd_message.set_name('AR', l_msg_name);
665: MSG_COMPLETE_CHARGES_ACCOUNT := fnd_message.get;
666:
667: ----
668: l_msg_name := 'AR_AUTOACC_COMPLETE_OFFSET';
661:
662: ----
663: l_msg_name := '1365';
664: fnd_message.set_name('AR', l_msg_name);
665: MSG_COMPLETE_CHARGES_ACCOUNT := fnd_message.get;
666:
667: ----
668: l_msg_name := 'AR_AUTOACC_COMPLETE_OFFSET';
669: fnd_message.set_name('AR', l_msg_name);
665: MSG_COMPLETE_CHARGES_ACCOUNT := fnd_message.get;
666:
667: ----
668: l_msg_name := 'AR_AUTOACC_COMPLETE_OFFSET';
669: fnd_message.set_name('AR', l_msg_name);
670: MSG_COMPLETE_OFFSET_ACCOUNT := fnd_message.get;
671:
672: ----
673: l_msg_name := 'RA_POSTING_NOT_ALLOWED';
666:
667: ----
668: l_msg_name := 'AR_AUTOACC_COMPLETE_OFFSET';
669: fnd_message.set_name('AR', l_msg_name);
670: MSG_COMPLETE_OFFSET_ACCOUNT := fnd_message.get;
671:
672: ----
673: l_msg_name := 'RA_POSTING_NOT_ALLOWED';
674: fnd_message.set_name('AR', l_msg_name);
670: MSG_COMPLETE_OFFSET_ACCOUNT := fnd_message.get;
671:
672: ----
673: l_msg_name := 'RA_POSTING_NOT_ALLOWED';
674: fnd_message.set_name('AR', l_msg_name);
675: MSG_FLEX_POSTING_NOT_ALLOWED := fnd_message.get;
676:
677: ----
678: l_msg_name := 'FLEX-No Parent';
671:
672: ----
673: l_msg_name := 'RA_POSTING_NOT_ALLOWED';
674: fnd_message.set_name('AR', l_msg_name);
675: MSG_FLEX_POSTING_NOT_ALLOWED := fnd_message.get;
676:
677: ----
678: l_msg_name := 'FLEX-No Parent';
679: fnd_message.set_name('AR', l_msg_name);
675: MSG_FLEX_POSTING_NOT_ALLOWED := fnd_message.get;
676:
677: ----
678: l_msg_name := 'FLEX-No Parent';
679: fnd_message.set_name('AR', l_msg_name);
680: MSG_FLEX_NO_PARENT_ALLOWED := fnd_message.get;
681:
682: ----
683: l_msg_name := 'AR_COMPLETE_INT_TAX_ACCOUNT';
676:
677: ----
678: l_msg_name := 'FLEX-No Parent';
679: fnd_message.set_name('AR', l_msg_name);
680: MSG_FLEX_NO_PARENT_ALLOWED := fnd_message.get;
681:
682: ----
683: l_msg_name := 'AR_COMPLETE_INT_TAX_ACCOUNT';
684: fnd_message.set_name('AR', l_msg_name);
680: MSG_FLEX_NO_PARENT_ALLOWED := fnd_message.get;
681:
682: ----
683: l_msg_name := 'AR_COMPLETE_INT_TAX_ACCOUNT';
684: fnd_message.set_name('AR', l_msg_name);
685: MSG_COMPLETE_INT_TAX_ACCOUNT := fnd_message.get;
686:
687: -- print
688: debug( ' MSG_COMPLETE_REV_ACCOUNT='||MSG_COMPLETE_REV_ACCOUNT,
681:
682: ----
683: l_msg_name := 'AR_COMPLETE_INT_TAX_ACCOUNT';
684: fnd_message.set_name('AR', l_msg_name);
685: MSG_COMPLETE_INT_TAX_ACCOUNT := fnd_message.get;
686:
687: -- print
688: debug( ' MSG_COMPLETE_REV_ACCOUNT='||MSG_COMPLETE_REV_ACCOUNT,
689: MSG_LEVEL_DEBUG );
1681: /* ------------------------------------------------------------------------ */
1682: /* Finds combination_id for given segment values. */
1683: /* If validation date is NULL checks all cross-validation rules. */
1684: /* Returns TRUE if combination valid, or FALSE and sets error message */
1685: /* on server using FND_MESSAGE if invalid. */
1686: /* ------------------------------------------------------------------------ */
1687: FUNCTION get_combination_id(application_short_name IN VARCHAR2,
1688: key_flex_code IN VARCHAR2,
1689: structure_number IN NUMBER,
1711: return(r_value);
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1716: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'get_combination_id() exception: '||SQLERRM );
1717: return(FALSE);
1718:
1719: END get_combination_id;
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1716: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'get_combination_id() exception: '||SQLERRM );
1717: return(FALSE);
1718:
1719: END get_combination_id;
1720:
1750: return(FALSE);
1751:
1752: EXCEPTION
1753: WHEN OTHERS THEN
1754: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1755: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'get_combination_id() exception: '||SQLERRM );
1756: return(FALSE);
1757:
1758: END get_combination_id;
1751:
1752: EXCEPTION
1753: WHEN OTHERS THEN
1754: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1755: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'get_combination_id() exception: '||SQLERRM );
1756: return(FALSE);
1757:
1758: END get_combination_id;
1759:
3413: ------------------------------------------------------------------
3414: -- Failed to retrieve a valid ccid or
3415: -- unable to dynamically create a ccid
3416: ------------------------------------------------------------------
3417: g_error_buffer := fnd_message.get;
3418: debug( g_error_buffer, MSG_LEVEL_BASIC );
3419:
3420: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3421: RETURN -1;
6949: IF( sqlcode = 1 ) THEN
6950: --
6951: -- User-defined exception
6952: --
6953: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
6954: FND_MESSAGE.set_token( 'GENERIC_TEXT', g_error_buffer );
6955: APP_EXCEPTION.raise_exception;
6956:
6957: ELSE
6950: --
6951: -- User-defined exception
6952: --
6953: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
6954: FND_MESSAGE.set_token( 'GENERIC_TEXT', g_error_buffer );
6955: APP_EXCEPTION.raise_exception;
6956:
6957: ELSE
6958: --
7167: IF( sqlcode = 1 ) THEN
7168: --
7169: -- User-defined exception
7170: --
7171: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
7172: FND_MESSAGE.set_token( 'GENERIC_TEXT', g_error_buffer );
7173: APP_EXCEPTION.raise_exception;
7174:
7175: ELSE
7168: --
7169: -- User-defined exception
7170: --
7171: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
7172: FND_MESSAGE.set_token( 'GENERIC_TEXT', g_error_buffer );
7173: APP_EXCEPTION.raise_exception;
7174:
7175: ELSE
7176: --