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_API

Line 13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

9: END;
10:
11: PROCEDURE Get_Score
12: ( p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
14: p_commit IN VARCHAR2,
15: p_validation_level IN VARCHAR2,
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,

Line 51: IF FND_API.to_Boolean( p_init_msg_list )

47: END IF;
48:
49: SAVEPOINT CREDIT_SCORE_PVT;
50:
51: IF FND_API.to_Boolean( p_init_msg_list )
52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: IF p_case_folder_id IS NOT NULL THEN
59: BEGIN
60: select type,

Line 107: x_return_status := FND_API.G_RET_STS_ERROR;

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;
110: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
111: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

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;
110: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
111: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
112: END ;
113:

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

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;
122: ELSE
123: /*Message : Please provide a case folder id of case folder type 'CASE' and

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

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
130: WHEN NO_DATA_FOUND THEN
131: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

Line 133: x_return_status := FND_API.G_RET_STS_ERROR;

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;
136: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
137: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);

Line 135: x_return_status := FND_API.G_RET_STS_ERROR;

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;
136: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
137: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_SCORE : '||SQLERRM);
138:
139: END ;

Line 145: x_return_status := FND_API.G_RET_STS_ERROR;

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:
148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
149: ROLLBACK TO CREDIT_SCORE_PVT;

Line 148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

144: FND_MSG_PUB.Add;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: END IF;
147:
148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
149: ROLLBACK TO CREDIT_SCORE_PVT;
150: END IF;
151: IF pg_debug = 'Y'
152: THEN

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

154: END IF;
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:

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

165: END Get_Score;
166:
167: PROCEDURE Include_Data_Points
168: ( p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
170: p_commit IN VARCHAR2,
171: p_validation_level IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,

Line 196: IF FND_API.to_Boolean( p_init_msg_list )

192: END IF;
193:
194: SAVEPOINT CREDIT_INCLUDE_DP_PVT;
195:
196: IF FND_API.to_Boolean( p_init_msg_list )
197: THEN
198: FND_MSG_PUB.initialize;
199: END IF;
200:

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: THEN
198: FND_MSG_PUB.initialize;
199: END IF;
200:
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: IF p_case_folder_id IS NOT NULL THEN
203: BEGIN
204: select type,
205: status

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

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;
236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

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;
236: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
237: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
238: END ;
239: END LOOP;

Line 244: x_return_status := FND_API.G_RET_STS_ERROR;

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;
247: ELSE
248: /*Message : Please provide a case folder id of case folder type 'CASE' and

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

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:
255: EXCEPTION
256: WHEN NO_DATA_FOUND THEN

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

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;
262: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
263: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

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;
262: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
263: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Include_Data_Points : '||SQLERRM);
264:
265: END ;

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

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:
274: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
275: ROLLBACK TO CREDIT_INCLUDE_DP_PVT;

Line 274: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

270: FND_MSG_PUB.Add;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273:
274: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
275: ROLLBACK TO CREDIT_INCLUDE_DP_PVT;
276: END IF;
277: IF pg_debug = 'Y'
278: THEN

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

279: debug ( 'OCM_GET_EXTRL_DECSN_PUB.Include_Data_Points(-)');
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:

Line 293: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

289: END ;
290:
291: PROCEDURE Get_Recommendations
292: ( p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
294: p_commit IN VARCHAR2,
295: p_validation_level IN VARCHAR2,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,

Line 326: IF FND_API.to_Boolean( p_init_msg_list )

322: END IF;
323:
324: SAVEPOINT CREDIT_GET_RECO_PVT;
325:
326: IF FND_API.to_Boolean( p_init_msg_list )
327: THEN
328: FND_MSG_PUB.initialize;
329: END IF;
330:

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327: THEN
328: FND_MSG_PUB.initialize;
329: END IF;
330:
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332: IF p_case_folder_id IS NOT NULL THEN
333: BEGIN
334: select ar_cmgt_case_folders.type,
335: ar_cmgt_case_folders.status,

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

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;
413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);

Line 412: x_return_status := FND_API.G_RET_STS_ERROR;

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;
413: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
414: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
415: END;
416: ELSE

Line 420: x_return_status := FND_API.G_RET_STS_ERROR;

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
423: /*Message : Please provide a case folder id of case folder type 'CASE' and
424: status as 'CREATED' or 'SAVED' */

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

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:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN

Line 434: x_return_status := FND_API.G_RET_STS_ERROR;

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;
437: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
438: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);

Line 436: x_return_status := FND_API.G_RET_STS_ERROR;

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;
437: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
438: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Get_Recommendations : '||SQLERRM);
439:
440: END ;

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

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
450: ROLLBACK TO CREDIT_GET_RECO_PVT;
451: END IF;

Line 449: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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
450: ROLLBACK TO CREDIT_GET_RECO_PVT;
451: END IF;
452: IF pg_debug = 'Y'
453: THEN

Line 458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

454: debug ( 'OCM_GET_EXTRL_DECSN_PUB.Get_Recommendations(-)');
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;

Line 468: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,

464: END ;
465:
466: PROCEDURE Submit_Case_Folder
467: ( p_api_version IN NUMBER,
468: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_TRUE,
469: p_commit IN VARCHAR2,
470: p_validation_level IN VARCHAR2,
471: x_return_status OUT NOCOPY VARCHAR2,
472: x_msg_count OUT NOCOPY NUMBER,

Line 494: IF FND_API.to_Boolean( p_init_msg_list )

490: END IF;
491:
492: SAVEPOINT CASE_FOLDER_SUBMIT_PVT;
493:
494: IF FND_API.to_Boolean( p_init_msg_list )
495: THEN
496: FND_MSG_PUB.initialize;
497: END IF;
498:

Line 499: x_return_status := FND_API.G_RET_STS_SUCCESS;

495: THEN
496: FND_MSG_PUB.initialize;
497: END IF;
498:
499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500:
501: IF p_case_folder_id IS NOT NULL THEN
502: BEGIN
503: select type,

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

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
530: WHEN NO_DATA_FOUND THEN
531: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_CASE_FOLDER');

Line 533: x_return_status := FND_API.G_RET_STS_ERROR;

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;
536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

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;
536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Submit_Case_Folder : '||SQLERRM);
538: END ;
539:

Line 545: x_return_status := FND_API.G_RET_STS_ERROR;

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
548: ROLLBACK TO CASE_FOLDER_SUBMIT_PVT;
549: END IF;

Line 547: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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
548: ROLLBACK TO CASE_FOLDER_SUBMIT_PVT;
549: END IF;
550: IF pg_debug = 'Y'
551: THEN

Line 556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

552: debug ( 'OCM_GET_EXTRL_DECSN_PUB.Submit_Case_Folder(-)');
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;