DBA Data[Home] [Help]

APPS.OCM_GET_EXTRL_DECSN_PUB dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

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:
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:

Line 106: FND_MSG_PUB.Add;

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

Line 118: FND_MSG_PUB.Add;

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;
122: ELSE

Line 126: FND_MSG_PUB.Add;

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
130: WHEN NO_DATA_FOUND THEN

Line 132: FND_MSG_PUB.Add;

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

Line 144: FND_MSG_PUB.Add;

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:
148: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 161: FND_MSG_PUB.Add;

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:
165: END Get_Score;

Line 198: FND_MSG_PUB.initialize;

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:
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202: IF p_case_folder_id IS NOT NULL THEN

Line 232: FND_MSG_PUB.Add;

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

Line 243: FND_MSG_PUB.Add;

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;
247: ELSE

Line 251: FND_MSG_PUB.Add;

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:
255: EXCEPTION

Line 258: FND_MSG_PUB.Add;

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

Line 270: FND_MSG_PUB.Add;

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:
274: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 286: FND_MSG_PUB.Add;

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 ;
290:

Line 328: FND_MSG_PUB.initialize;

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:
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332: IF p_case_folder_id IS NOT NULL THEN

Line 409: FND_MSG_PUB.Add;

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

Line 419: FND_MSG_PUB.Add;

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

Line 426: FND_MSG_PUB.Add;

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:
430: EXCEPTION

Line 433: FND_MSG_PUB.Add;

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

Line 446: FND_MSG_PUB.Add;

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

Line 461: FND_MSG_PUB.Add;

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 ;
465:

Line 496: FND_MSG_PUB.initialize;

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:
499: x_return_status := FND_API.G_RET_STS_SUCCESS;
500:

Line 526: FND_MSG_PUB.Add;

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
530: WHEN NO_DATA_FOUND THEN

Line 532: FND_MSG_PUB.Add;

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

Line 544: FND_MSG_PUB.Add;

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

Line 559: FND_MSG_PUB.Add;

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 ;
563: