eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OCM_GET_EXTRL_DECSN_PUB dependencies on FND_MESSAGE

Line 105: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_SCORE_MODEL_ID');

101: and site_use_id = l_site_use_id)
102: and DATA_POINT_ID = l_data_point_id;
103: EXCEPTION
104: WHEN NO_DATA_FOUND THEN
105: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_SCORE_MODEL_ID');
106: FND_MSG_PUB.Add;
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: WHEN OTHERS THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;

Line 110: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

106: FND_MSG_PUB.Add;
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: WHEN OTHERS THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
111: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
112: END ;
113:
114: ELSE

Line 111: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);

107: x_return_status := FND_API.G_RET_STS_ERROR;
108: WHEN OTHERS THEN
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
111: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
112: END ;
113:
114: ELSE
115: /*Message : Please provide a score model id which matches with the case folder's

Line 117: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_SCORE_MODEL_ID');

113:
114: ELSE
115: /*Message : Please provide a score model id which matches with the case folder's
116: score model id and conatin the External Score data points. */
117: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_SCORE_MODEL_ID');
118: FND_MSG_PUB.Add;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120:
121: END IF;

Line 125: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

121: END IF;
122: ELSE
123: /*Message : Please provide a case folder id of case folder type 'CASE' and
124: status as 'CREATED' or 'SAVED' */
125: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
126: FND_MSG_PUB.Add;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;
129: EXCEPTION

Line 131: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

127: x_return_status := FND_API.G_RET_STS_ERROR;
128: END IF;
129: EXCEPTION
130: WHEN NO_DATA_FOUND THEN
131: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
132: FND_MSG_PUB.Add;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: WHEN OTHERS THEN
135: x_return_status := FND_API.G_RET_STS_ERROR;

Line 136: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

132: FND_MSG_PUB.Add;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: WHEN OTHERS THEN
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
137: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
138:
139: END ;
140: ELSE

Line 137: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);

133: x_return_status := FND_API.G_RET_STS_ERROR;
134: WHEN OTHERS THEN
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
137: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
138:
139: END ;
140: ELSE
141: /*Messae : Please provide a case folder id of case folder type 'CASE' and

Line 143: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

139: END ;
140: ELSE
141: /*Messae : Please provide a case folder id of case folder type 'CASE' and
142: status as 'CREATED' or 'SAVED' */
143: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: END IF;
147:

Line 159: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

155: EXCEPTION
156: WHEN OTHERS THEN
157:
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
160: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
161: FND_MSG_PUB.Add;
162:
163: ROLLBACK TO CREDIT_SCORE_PVT;

Line 160: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);

156: WHEN OTHERS THEN
157:
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
160: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
161: FND_MSG_PUB.Add;
162:
163: ROLLBACK TO CREDIT_SCORE_PVT;
164:

Line 231: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_DATAPOINT_ID');

227: and data_point_id = l_data_point_id;
228:
229: EXCEPTION
230: WHEN NO_DATA_FOUND THEN
231: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_DATAPOINT_ID');
232: FND_MSG_PUB.Add;
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

232: FND_MSG_PUB.Add;
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
238: END ;
239: END LOOP;
240: ELSE

Line 237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);

233: x_return_status := FND_API.G_RET_STS_ERROR;
234: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
238: END ;
239: END LOOP;
240: ELSE
241: /*Message : Please provide a valid data point id */

Line 242: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_DATAPOINT_ID');

238: END ;
239: END LOOP;
240: ELSE
241: /*Message : Please provide a valid data point id */
242: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_DATAPOINT_ID');
243: FND_MSG_PUB.Add;
244: x_return_status := FND_API.G_RET_STS_ERROR;
245:
246: END IF;

Line 250: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

246: END IF;
247: ELSE
248: /*Message : Please provide a case folder id of case folder type 'CASE' and
249: status as 'CREATED' or 'SAVED' */
250: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
251: FND_MSG_PUB.Add;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: END IF;
254:

Line 257: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

253: END IF;
254:
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN
257: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
258: FND_MSG_PUB.Add;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;

Line 262: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

258: FND_MSG_PUB.Add;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
263: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
264:
265: END ;
266: ELSE

Line 263: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);

259: x_return_status := FND_API.G_RET_STS_ERROR;
260: WHEN OTHERS THEN
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
263: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
264:
265: END ;
266: ELSE
267: /*Message : Please provide a case folder id of case folder type 'CASE' and

Line 269: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

265: END ;
266: ELSE
267: /*Message : Please provide a case folder id of case folder type 'CASE' and
268: status as 'CREATED' or 'SAVED' */
269: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
270: FND_MSG_PUB.Add;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273:

Line 284: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

280: END IF;
281: EXCEPTION
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
285: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
286: FND_MSG_PUB.Add;
287:
288: ROLLBACK TO CREDIT_INCLUDE_DP_PVT;

Line 285: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);

281: EXCEPTION
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
285: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
286: FND_MSG_PUB.Add;
287:
288: ROLLBACK TO CREDIT_INCLUDE_DP_PVT;
289: END ;

Line 408: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_RECOMMENDATIONS');

404: );
405: END LOOP;
406: EXCEPTION
407: WHEN NO_DATA_FOUND THEN
408: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_RECOMMENDATIONS');
409: FND_MSG_PUB.Add;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;

Line 413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

409: FND_MSG_PUB.Add;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
415: END;
416: ELSE
417: /*Message : Please provide a valid data point id */

Line 414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);

410: x_return_status := FND_API.G_RET_STS_ERROR;
411: WHEN OTHERS THEN
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
415: END;
416: ELSE
417: /*Message : Please provide a valid data point id */
418: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_RECOMMENDATIONS');

Line 418: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_RECOMMENDATIONS');

414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
415: END;
416: ELSE
417: /*Message : Please provide a valid data point id */
418: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_RECOMMENDATIONS');
419: FND_MSG_PUB.Add;
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: ELSE

Line 425: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

421: END IF;
422: ELSE
423: /*Message : Please provide a case folder id of case folder type 'CASE' and
424: status as 'CREATED' or 'SAVED' */
425: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
426: FND_MSG_PUB.Add;
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: END IF;
429:

Line 432: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

428: END IF;
429:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN
432: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
433: FND_MSG_PUB.Add;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: WHEN OTHERS THEN
436: x_return_status := FND_API.G_RET_STS_ERROR;

Line 437: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

433: FND_MSG_PUB.Add;
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: WHEN OTHERS THEN
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
438: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
439:
440: END ;
441:

Line 438: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);

434: x_return_status := FND_API.G_RET_STS_ERROR;
435: WHEN OTHERS THEN
436: x_return_status := FND_API.G_RET_STS_ERROR;
437: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
438: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
439:
440: END ;
441:
442: ELSE

Line 445: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

441:
442: ELSE
443: /*Message : Please provide a case folder id of case folder type 'CASE' and
444: status as 'CREATED' or 'SAVED' */
445: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
446: FND_MSG_PUB.Add;
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: END IF;
449: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 459: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

455: END IF;
456: EXCEPTION
457: WHEN OTHERS THEN
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
460: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
461: FND_MSG_PUB.Add;
462: ROLLBACK TO CREDIT_GET_RECO_PVT;
463:

Line 460: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);

456: EXCEPTION
457: WHEN OTHERS THEN
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
460: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
461: FND_MSG_PUB.Add;
462: ROLLBACK TO CREDIT_GET_RECO_PVT;
463:
464: END ;

Line 525: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

521: (l_credit_request_id ,'SUBMIT');
522: ELSE
523: /*Message : Please provide a case folder id of case folder type 'CASE' and
524: status as 'CREATED' or 'SAVED' */
525: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
526: FND_MSG_PUB.Add;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: END IF;
529: EXCEPTION

Line 531: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

527: x_return_status := FND_API.G_RET_STS_ERROR;
528: END IF;
529: EXCEPTION
530: WHEN NO_DATA_FOUND THEN
531: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
532: FND_MSG_PUB.Add;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;

Line 536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

532: FND_MSG_PUB.Add;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);
538: END ;
539:
540: ELSE

Line 537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);

533: x_return_status := FND_API.G_RET_STS_ERROR;
534: WHEN OTHERS THEN
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);
538: END ;
539:
540: ELSE
541: /*Message : Please provide a case folder id of case folder type 'CASE' and

Line 543: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

539:
540: ELSE
541: /*Message : Please provide a case folder id of case folder type 'CASE' and
542: status as 'CREATED' or 'SAVED' */
543: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');
544: FND_MSG_PUB.Add;
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: END IF;
547: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 557: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

553: END IF;
554: EXCEPTION
555: WHEN OTHERS THEN
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
558: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);
559: FND_MSG_PUB.Add;
560: ROLLBACK TO CASE_FOLDER_SUBMIT_PVT;
561:

Line 558: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);

554: EXCEPTION
555: WHEN OTHERS THEN
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
557: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
558: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);
559: FND_MSG_PUB.Add;
560: ROLLBACK TO CASE_FOLDER_SUBMIT_PVT;
561:
562: END ;