DBA Data[Home] [Help]

APPS.GCS_AD_ENGINE dependencies on FND_MESSAGE

Line 187: errBuf := substr( FND_MESSAGE.get, 1, 5000 );

183:
184: -- May be a message on the stack or
185: -- a string passed in via the arg
186: if logText IS NULL then
187: errBuf := substr( FND_MESSAGE.get, 1, 5000 );
188: else
189: errBuf := substr( logText, 1, 5000 );
190: end if;
191:

Line 351: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );

347: logString( statementLogLevel, procedureName, 'liaVers ', liaVers);
348: exception
349: when no_data_found then
350: logString( exceptionLogLevel, procedureName, 'exception', 'missing_key');
351: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );
352: FND_MESSAGE.set_token( 'HASH_KEY' , liaKey );
353: RAISE missing_key;
354: end;
355:

Line 352: FND_MESSAGE.set_token( 'HASH_KEY' , liaKey );

348: exception
349: when no_data_found then
350: logString( exceptionLogLevel, procedureName, 'exception', 'missing_key');
351: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );
352: FND_MESSAGE.set_token( 'HASH_KEY' , liaKey );
353: RAISE missing_key;
354: end;
355:
356: --Get the attribute_id and version_id for the EXT_ACCOUNT_TYPE_CODE

Line 367: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );

363: logString( statementLogLevel, procedureName, 'ataVers ', ataVers);
364: exception
365: when no_data_found then
366: logString( exceptionLogLevel, procedureName, 'exception', 'missing_key');
367: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );
368: FND_MESSAGE.set_token( 'HASH_KEY' , ataKey );
369: RAISE missing_key;
370: end;
371:

Line 368: FND_MESSAGE.set_token( 'HASH_KEY' , ataKey );

364: exception
365: when no_data_found then
366: logString( exceptionLogLevel, procedureName, 'exception', 'missing_key');
367: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );
368: FND_MESSAGE.set_token( 'HASH_KEY' , ataKey );
369: RAISE missing_key;
370: end;
371:
372: --Get the NAV

Line 601: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );

597: 'ccy => ' || ccy );
598: exception
599: when no_data_found then
600: logString( exceptionLogLevel, procedureName, 'exception', 'missing_key');
601: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );
602: FND_MESSAGE.set_token( 'HASH_KEY' , key );
603:
604: RAISE missing_key;
605: end;

Line 602: FND_MESSAGE.set_token( 'HASH_KEY' , key );

598: exception
599: when no_data_found then
600: logString( exceptionLogLevel, procedureName, 'exception', 'missing_key');
601: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_KEY' );
602: FND_MESSAGE.set_token( 'HASH_KEY' , key );
603:
604: RAISE missing_key;
605: end;
606:

Line 680: ruleErrorMsg := FND_MESSAGE.get;

676: END;
677:
678: If ruleRetcode > 0 then
679:
680: ruleErrorMsg := FND_MESSAGE.get;
681: FND_MESSAGE.set_name( 'GCS', 'GCS_RULE_FAILURE' );
682: FND_MESSAGE.set_token( 'PROCEDURE', packageName||'.'||procedureName );
683: FND_MESSAGE.set_token( 'RULE_NAME', xnsRules(x).rule_name );
684: logString( exceptionLogLevel, procedureName, 'exception', FND_MESSAGE.get);

Line 681: FND_MESSAGE.set_name( 'GCS', 'GCS_RULE_FAILURE' );

677:
678: If ruleRetcode > 0 then
679:
680: ruleErrorMsg := FND_MESSAGE.get;
681: FND_MESSAGE.set_name( 'GCS', 'GCS_RULE_FAILURE' );
682: FND_MESSAGE.set_token( 'PROCEDURE', packageName||'.'||procedureName );
683: FND_MESSAGE.set_token( 'RULE_NAME', xnsRules(x).rule_name );
684: logString( exceptionLogLevel, procedureName, 'exception', FND_MESSAGE.get);
685: if ruleErrorMsg IS NOT NULL then

Line 682: FND_MESSAGE.set_token( 'PROCEDURE', packageName||'.'||procedureName );

678: If ruleRetcode > 0 then
679:
680: ruleErrorMsg := FND_MESSAGE.get;
681: FND_MESSAGE.set_name( 'GCS', 'GCS_RULE_FAILURE' );
682: FND_MESSAGE.set_token( 'PROCEDURE', packageName||'.'||procedureName );
683: FND_MESSAGE.set_token( 'RULE_NAME', xnsRules(x).rule_name );
684: logString( exceptionLogLevel, procedureName, 'exception', FND_MESSAGE.get);
685: if ruleErrorMsg IS NOT NULL then
686: logString( exceptionLogLevel, procedureName, 'exception', ruleErrorMsg);

Line 683: FND_MESSAGE.set_token( 'RULE_NAME', xnsRules(x).rule_name );

679:
680: ruleErrorMsg := FND_MESSAGE.get;
681: FND_MESSAGE.set_name( 'GCS', 'GCS_RULE_FAILURE' );
682: FND_MESSAGE.set_token( 'PROCEDURE', packageName||'.'||procedureName );
683: FND_MESSAGE.set_token( 'RULE_NAME', xnsRules(x).rule_name );
684: logString( exceptionLogLevel, procedureName, 'exception', FND_MESSAGE.get);
685: if ruleErrorMsg IS NOT NULL then
686: logString( exceptionLogLevel, procedureName, 'exception', ruleErrorMsg);
687: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || ruleErrorMsg);

Line 684: logString( exceptionLogLevel, procedureName, 'exception', FND_MESSAGE.get);

680: ruleErrorMsg := FND_MESSAGE.get;
681: FND_MESSAGE.set_name( 'GCS', 'GCS_RULE_FAILURE' );
682: FND_MESSAGE.set_token( 'PROCEDURE', packageName||'.'||procedureName );
683: FND_MESSAGE.set_token( 'RULE_NAME', xnsRules(x).rule_name );
684: logString( exceptionLogLevel, procedureName, 'exception', FND_MESSAGE.get);
685: if ruleErrorMsg IS NOT NULL then
686: logString( exceptionLogLevel, procedureName, 'exception', ruleErrorMsg);
687: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || ruleErrorMsg);
688: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 693: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_WARNING' );

689:
690: end if;
691:
692: if ruleRetcode = 1 then
693: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_WARNING' );
694: errbuf := FND_MESSAGE.get;
695: retcode := 1;
696: elsif ruleRetcode = 2 then
697: retcode := 2;

Line 694: errbuf := FND_MESSAGE.get;

690: end if;
691:
692: if ruleRetcode = 1 then
693: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_WARNING' );
694: errbuf := FND_MESSAGE.get;
695: retcode := 1;
696: elsif ruleRetcode = 2 then
697: retcode := 2;
698: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

Line 698: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

694: errbuf := FND_MESSAGE.get;
695: retcode := 1;
696: elsif ruleRetcode = 2 then
697: retcode := 2;
698: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
699: errbuf := FND_MESSAGE.get;
700: RAISE rule_processor_failure;
701: elsif ruleRetCode = 3 then
702: --special case indicates out of balance entry

Line 699: errbuf := FND_MESSAGE.get;

695: retcode := 1;
696: elsif ruleRetcode = 2 then
697: retcode := 2;
698: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
699: errbuf := FND_MESSAGE.get;
700: RAISE rule_processor_failure;
701: elsif ruleRetCode = 3 then
702: --special case indicates out of balance entry
703: retcode := 2;

Line 704: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

700: RAISE rule_processor_failure;
701: elsif ruleRetCode = 3 then
702: --special case indicates out of balance entry
703: retcode := 2;
704: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
705: errbuf := FND_MESSAGE.get;
706: RAISE rule_processor_failure;
707: end if;
708:

Line 705: errbuf := FND_MESSAGE.get;

701: elsif ruleRetCode = 3 then
702: --special case indicates out of balance entry
703: retcode := 2;
704: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
705: errbuf := FND_MESSAGE.get;
706: RAISE rule_processor_failure;
707: end if;
708:
709: End If;

Line 735: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_SUCCESS' );

731:
732: -------------------------------------
733: -- Write log file footer and return
734: -------------------------------------
735: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_SUCCESS' );
736: errbuf := FND_MESSAGE.get;
737:
738: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' END');

Line 736: errbuf := FND_MESSAGE.get;

732: -------------------------------------
733: -- Write log file footer and return
734: -------------------------------------
735: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_SUCCESS' );
736: errbuf := FND_MESSAGE.get;
737:
738: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' END');
740: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 754: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_COMMAND_LINE' );

750: -- The only way this can raise is if the transaction_id is not valid
751: -- As such, no point to update the interface rows' status_code and
752: -- no need to commit (since no changes are made in the handler)
753: ROLLBACK;
754: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_COMMAND_LINE' );
755: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
756: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
757:
758: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

Line 755: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );

751: -- As such, no point to update the interface rows' status_code and
752: -- no need to commit (since no changes are made in the handler)
753: ROLLBACK;
754: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_COMMAND_LINE' );
755: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
756: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
757:
758: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
759: errbuf := FND_MESSAGE.get;

Line 756: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );

752: -- no need to commit (since no changes are made in the handler)
753: ROLLBACK;
754: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_COMMAND_LINE' );
755: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
756: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
757:
758: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
759: errbuf := FND_MESSAGE.get;
760: retcode := 2;

Line 758: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

754: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_COMMAND_LINE' );
755: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
756: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
757:
758: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
759: errbuf := FND_MESSAGE.get;
760: retcode := 2;
761:
762: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);

Line 759: errbuf := FND_MESSAGE.get;

755: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
756: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
757:
758: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
759: errbuf := FND_MESSAGE.get;
760: retcode := 2;
761:
762: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
763: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 769: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_XNS_TYPE' );

765: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
766:
767: WHEN invalid_xns_type THEN
768: ROLLBACK;
769: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_XNS_TYPE' );
770: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );
772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
773:

Line 770: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );

766:
767: WHEN invalid_xns_type THEN
768: ROLLBACK;
769: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_XNS_TYPE' );
770: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );
772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
773:
774: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

Line 771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );

767: WHEN invalid_xns_type THEN
768: ROLLBACK;
769: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_XNS_TYPE' );
770: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );
772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
773:
774: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
775: errbuf := FND_MESSAGE.get;

Line 772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );

768: ROLLBACK;
769: FND_MESSAGE.set_name( 'GCS', 'GCS_INVALID_XNS_TYPE' );
770: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );
772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
773:
774: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
775: errbuf := FND_MESSAGE.get;
776: retcode := 2;

Line 774: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

770: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );
772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
773:
774: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
775: errbuf := FND_MESSAGE.get;
776: retcode := 2;
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
778: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 775: errbuf := FND_MESSAGE.get;

771: FND_MESSAGE.set_token( 'TRANSACTION_TYPE', xnsData.transaction_type_code );
772: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
773:
774: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
775: errbuf := FND_MESSAGE.get;
776: retcode := 2;
777: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
778: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
779:

Line 784: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_RULE' );

780: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
781:
782: WHEN no_rule_found THEN
783: ROLLBACK;
784: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_RULE' );
785: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
786: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
787:
788: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

Line 785: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );

781:
782: WHEN no_rule_found THEN
783: ROLLBACK;
784: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_RULE' );
785: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
786: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
787:
788: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
789: errbuf := FND_MESSAGE.get;

Line 786: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );

782: WHEN no_rule_found THEN
783: ROLLBACK;
784: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_RULE' );
785: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
786: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
787:
788: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
789: errbuf := FND_MESSAGE.get;
790: retcode := 2;

Line 788: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

784: FND_MESSAGE.set_name( 'GCS', 'GCS_MISSING_RULE' );
785: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
786: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
787:
788: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
789: errbuf := FND_MESSAGE.get;
790: retcode := 2;
791: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
792: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 789: errbuf := FND_MESSAGE.get;

785: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
786: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
787:
788: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
789: errbuf := FND_MESSAGE.get;
790: retcode := 2;
791: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
792: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
793:

Line 800: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

796: WHEN missing_key THEN
797: --An error msg is placed on the stack at the exception raise point
798: --A logString call is made at the exception raise point
799: ROLLBACK;
800: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
801: errbuf := FND_MESSAGE.get;
802: retcode := 2;
803: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
804: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 801: errbuf := FND_MESSAGE.get;

797: --An error msg is placed on the stack at the exception raise point
798: --A logString call is made at the exception raise point
799: ROLLBACK;
800: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
801: errbuf := FND_MESSAGE.get;
802: retcode := 2;
803: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: ' || errbuf);
804: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
805:

Line 815: FND_MESSAGE.set_name( 'GCS', 'GCS_UNHANDLED_EXCEPTION' );

811: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
812:
813: WHEN OTHERS THEN
814: ROLLBACK;
815: FND_MESSAGE.set_name( 'GCS', 'GCS_UNHANDLED_EXCEPTION' );
816: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
817: FND_MESSAGE.set_token( 'EVENT', 'OTHERS' );
818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
819:

Line 816: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );

812:
813: WHEN OTHERS THEN
814: ROLLBACK;
815: FND_MESSAGE.set_name( 'GCS', 'GCS_UNHANDLED_EXCEPTION' );
816: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
817: FND_MESSAGE.set_token( 'EVENT', 'OTHERS' );
818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
819:
820: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

Line 817: FND_MESSAGE.set_token( 'EVENT', 'OTHERS' );

813: WHEN OTHERS THEN
814: ROLLBACK;
815: FND_MESSAGE.set_name( 'GCS', 'GCS_UNHANDLED_EXCEPTION' );
816: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
817: FND_MESSAGE.set_token( 'EVENT', 'OTHERS' );
818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
819:
820: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
821: retcode := 2;

Line 818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );

814: ROLLBACK;
815: FND_MESSAGE.set_name( 'GCS', 'GCS_UNHANDLED_EXCEPTION' );
816: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
817: FND_MESSAGE.set_token( 'EVENT', 'OTHERS' );
818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
819:
820: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
821: retcode := 2;
822: errbuf := FND_MESSAGE.get;

Line 820: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );

816: FND_MESSAGE.set_token( 'PROCEDURE' , packageName||'.'||procedureName );
817: FND_MESSAGE.set_token( 'EVENT', 'OTHERS' );
818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
819:
820: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
821: retcode := 2;
822: errbuf := FND_MESSAGE.get;
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: '|| errbuf);
824: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);

Line 822: errbuf := FND_MESSAGE.get;

818: logString( exceptionLogLevel, procedureName, 'GCS', FND_MESSAGE.get );
819:
820: FND_MESSAGE.set_name( 'GCS', 'GCS_CONCREQ_FAILURE' );
821: retcode := 2;
822: errbuf := FND_MESSAGE.get;
823: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, packageName || '.' || procedureName || ' ERROR: '|| errbuf);
824: FND_FILE.NEW_LINE(FND_FILE.OUTPUT);
825:
826: logString( procedureLogLevel, procedureName, 'end', to_char(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));