104: END IF;
105: fdebug('Out:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS');
106: EXCEPTION
107: WHEN OTHERS THEN
108: FND_MESSAGE.CLEAR;
109: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MP');
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
105: fdebug('Out:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS');
106: EXCEPTION
107: WHEN OTHERS THEN
108: FND_MESSAGE.CLEAR;
109: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MP');
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
113: err := FND_MESSAGE.GET;
106: EXCEPTION
107: WHEN OTHERS THEN
108: FND_MESSAGE.CLEAR;
109: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MP');
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
113: err := FND_MESSAGE.GET;
114: FND_MESSAGE.CLEAR;
107: WHEN OTHERS THEN
108: FND_MESSAGE.CLEAR;
109: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MP');
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
113: err := FND_MESSAGE.GET;
114: FND_MESSAGE.CLEAR;
115:
108: FND_MESSAGE.CLEAR;
109: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MP');
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
113: err := FND_MESSAGE.GET;
114: FND_MESSAGE.CLEAR;
115:
116: fdebug('Error:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS err msg='||err);
109: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MP');
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
113: err := FND_MESSAGE.GET;
114: FND_MESSAGE.CLEAR;
115:
116: fdebug('Error:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS err msg='||err);
117: --Don't raise;
110: FND_MESSAGE.SET_TOKEN(token=>'TRANSACTION_CONTEXT_ID', value=>trCtxId);
111: FND_MESSAGE.SET_TOKEN(token=>'ERR_NUM', value=>SQLCODE);
112: FND_MESSAGE.SET_TOKEN(token=>'ERR_MSG', value=>SQLERRM);
113: err := FND_MESSAGE.GET;
114: FND_MESSAGE.CLEAR;
115:
116: fdebug('Error:FND_BE_UTIL.METRIC_EVENT_PNDG_MTRCS err msg='||err);
117: --Don't raise;
118:
161: END LOOP; --subs_cur
162:
163: --- fdebug('errbuf:::'||errbuf);
164: IF (retcode = C_WARNING) THEN
165: FND_MESSAGE.CLEAR;
166: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MPS');
167: errbuf:=FND_MESSAGE.GET;
168: FND_MESSAGE.CLEAR;
169: END IF;
162:
163: --- fdebug('errbuf:::'||errbuf);
164: IF (retcode = C_WARNING) THEN
165: FND_MESSAGE.CLEAR;
166: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MPS');
167: errbuf:=FND_MESSAGE.GET;
168: FND_MESSAGE.CLEAR;
169: END IF;
170: fnd_file.put_line( fnd_file.log, 'Posted metrics for all completed transactions');
163: --- fdebug('errbuf:::'||errbuf);
164: IF (retcode = C_WARNING) THEN
165: FND_MESSAGE.CLEAR;
166: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MPS');
167: errbuf:=FND_MESSAGE.GET;
168: FND_MESSAGE.CLEAR;
169: END IF;
170: fnd_file.put_line( fnd_file.log, 'Posted metrics for all completed transactions');
171: fdebug('Out:FND_BE_UTIL.MTERIC_EVENT_PENDING_METRICS');
164: IF (retcode = C_WARNING) THEN
165: FND_MESSAGE.CLEAR;
166: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ERR_MPS');
167: errbuf:=FND_MESSAGE.GET;
168: FND_MESSAGE.CLEAR;
169: END IF;
170: fnd_file.put_line( fnd_file.log, 'Posted metrics for all completed transactions');
171: fdebug('Out:FND_BE_UTIL.MTERIC_EVENT_PENDING_METRICS');
172: EXCEPTION