DBA Data[Home] [Help]

APPS.CE_TRANSACTION_CODES_PKG dependencies on FND_MESSAGE

Line 238: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

234: OPEN C;
235: FETCH C INTO Recinfo;
236: if (C%NOTFOUND) then
237: CLOSE C;
238: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
239: APP_EXCEPTION.Raise_Exception;
240: end if;
241: CLOSE C;
242: if (

Line 335: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

331: AND (X_reconciliation_sequence IS NULL)))
332: ) then
333: return;
334: else
335: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
336: APP_EXCEPTION.Raise_Exception;
337: end if;
338: END Lock_Row;
339: --

Line 543: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );

539: FETCH chk_duplicates INTO dummy;
540: --
541: IF chk_duplicates%FOUND THEN
542: CLOSE chk_duplicates;
543: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );
544: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE' );
545: app_exception.raise_exception;
546: END IF;
547: --

Line 544: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE' );

540: --
541: IF chk_duplicates%FOUND THEN
542: CLOSE chk_duplicates;
543: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );
544: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE' );
545: app_exception.raise_exception;
546: END IF;
547: --
548: CLOSE chk_duplicates;

Line 555: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );

551: FETCH chk_duplicates2 INTO dummy;
552: --
553: IF chk_duplicates2%FOUND THEN
554: CLOSE chk_duplicates2;
555: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );
556: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB2' );
557: app_exception.raise_exception;
558: END IF;
559: --

Line 556: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB2' );

552: --
553: IF chk_duplicates2%FOUND THEN
554: CLOSE chk_duplicates2;
555: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );
556: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB2' );
557: app_exception.raise_exception;
558: END IF;
559: --
560: CLOSE chk_duplicates2;

Line 568: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );

564: FETCH chk_duplicates3 INTO dummy;
565: --
566: IF chk_duplicates3%FOUND THEN
567: CLOSE chk_duplicates3;
568: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );
569: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB1' );
570: app_exception.raise_exception;
571: END IF;
572: --

Line 569: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB1' );

565: --
566: IF chk_duplicates3%FOUND THEN
567: CLOSE chk_duplicates3;
568: -- FND_MESSAGE.set_string( 'Duplicate Transaction code for this bank code' );
569: fnd_message.set_name( 'CE', 'CE_DUP_BANK_TRX_CODE_COMB1' );
570: app_exception.raise_exception;
571: END IF;
572: --
573: CLOSE chk_duplicates3;

Line 587: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');

583: CLOSE chk_duplicates3;
584: END IF;
585: RAISE;
586: WHEN OTHERS THEN
587: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');
588: fnd_message.set_token( 'PROCEDURE',
589: 'CE_TRANSACTION_CODES_pkg.check_unique_txn_code');
590: IF ( chk_duplicates%ISOPEN ) THEN
591: CLOSE chk_duplicates;

Line 588: fnd_message.set_token( 'PROCEDURE',

584: END IF;
585: RAISE;
586: WHEN OTHERS THEN
587: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');
588: fnd_message.set_token( 'PROCEDURE',
589: 'CE_TRANSACTION_CODES_pkg.check_unique_txn_code');
590: IF ( chk_duplicates%ISOPEN ) THEN
591: CLOSE chk_duplicates;
592: END IF;

Line 665: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');

661: CLOSE chk_arch_stmt_line;
662: END IF;
663: RAISE;
664: WHEN OTHERS THEN
665: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');
666: fnd_message.set_token( 'FUNCTION',
667: 'CE_TRANSACTION_CODES_pkg.Is_In_Use');
668: IF ( chk_stmt_line%ISOPEN ) THEN
669: CLOSE chk_stmt_line;

Line 666: fnd_message.set_token( 'FUNCTION',

662: END IF;
663: RAISE;
664: WHEN OTHERS THEN
665: fnd_message.set_name( 'SQLCE', 'CE_UNHANDLED_EXCEPTION');
666: fnd_message.set_token( 'FUNCTION',
667: 'CE_TRANSACTION_CODES_pkg.Is_In_Use');
668: IF ( chk_stmt_line%ISOPEN ) THEN
669: CLOSE chk_stmt_line;
670: END IF;