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.AHL_VWP_TASKS_LINKS_PVT dependencies on FND_MSG_PUB

Line 254: FND_MSG_PUB.ADD;

250: --End of change by amagrawa
251: CLOSE c_task_type_code;
252: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_SUMMARY');
253: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
254: FND_MSG_PUB.ADD;
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: CLOSE c_task_type_code;
258:

Line 270: FND_MSG_PUB.ADD;

266: --End of change by amagrawa
267: CLOSE c_task_status;
268: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_PARENT_REL');
269: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
270: FND_MSG_PUB.ADD;
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273: CLOSE c_task_status;
274:

Line 287: FND_MSG_PUB.ADD;

283: --End of change by amagrawa
284: CLOSE c_task_status;
285: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_CHILD_REL');
286: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_child_task_number);
287: FND_MSG_PUB.ADD;
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: CLOSE c_task_status;
291:

Line 303: FND_MSG_PUB.ADD;

299: CLOSE c_task_number;
300: --End of change by amagrawa
301: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TSK_PRECHILD_REL');
302: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
303: FND_MSG_PUB.ADD;
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306: CLOSE c_children_check_status;
307: */

Line 313: FND_MSG_PUB.ADD;

309: OPEN c_parent_or_child_task(l_parent_task_id);
310: FETCH c_parent_or_child_task INTO l_parent_stage_num;
311: /*IF c_parent_task%NOTFOUND THEN
312: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_PARENT_TASK_NULL');
313: FND_MSG_PUB.ADD;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: */
317: CLOSE c_parent_or_child_task;

Line 324: FND_MSG_PUB.ADD;

320: OPEN c_parent_or_child_task(l_child_task_id);
321: FETCH c_parent_or_child_task INTO l_child_stage_num;
322: /*IF c_child_task%NOTFOUND THEN
323: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TASK_NULL');
324: FND_MSG_PUB.ADD;
325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327: */
328: CLOSE c_parent_or_child_task;

Line 347: FND_MSG_PUB.ADD;

343:
344: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CHILD_STG_GT');
345: FND_MESSAGE.SET_TOKEN('CHILD_TASK_NUM',l_child_task_number);
346: FND_MESSAGE.SET_TOKEN('PARENT_TASK_NUM',l_parent_task_number);
347: FND_MSG_PUB.ADD;
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;
350:
351: -- End of Post 11.5.10 Changes.

Line 360: FND_MSG_PUB.ADD;

356:
357: IF (p_task_link_rec.task_link_id IS NULL OR p_task_link_rec.task_link_id=FND_API.G_MISS_NUM) AND p_task_link_rec.dml_operation<>'C'
358: THEN
359: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_LINK_ID_NULL');
360: FND_MSG_PUB.ADD;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'

Line 367: FND_MSG_PUB.ADD;

363:
364: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'
365: THEN
366: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
367: FND_MSG_PUB.ADD;
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371:

Line 400: FND_MSG_PUB.ADD;

396: IF l_counter2>0
397: THEN
398: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_LINK_DUP');
399: FND_MESSAGE.SET_TOKEN('RECORD',p_task_link_rec.visit_Task_number,false);
400: FND_MSG_PUB.ADD;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:
404: CLOSE check_UNIQ;

Line 411: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

407: END IF;
408: EXCEPTION
409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
410: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
412: p_count => x_msg_count,
413: p_data => x_msg_data);
414:
415: WHEN FND_API.G_EXC_ERROR THEN

Line 417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

413: p_data => x_msg_data);
414:
415: WHEN FND_API.G_EXC_ERROR THEN
416: X_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => X_msg_data);
420: WHEN OTHERS THEN
421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

418: p_count => x_msg_count,
419: p_data => X_msg_data);
420: WHEN OTHERS THEN
421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
423: THEN
424: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
425: p_procedure_name => L_API_NAME,
426: p_error_text => SUBSTR(SQLERRM,1,240));

Line 424: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

420: WHEN OTHERS THEN
421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
423: THEN
424: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
425: p_procedure_name => L_API_NAME,
426: p_error_text => SUBSTR(SQLERRM,1,240));
427: END IF;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

424: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
425: p_procedure_name => L_API_NAME,
426: p_error_text => SUBSTR(SQLERRM,1,240));
427: END IF;
428: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => X_msg_data);
431: END;
432:

Line 462: FND_MSG_PUB.ADD;

458:
459: IF p_x_task_link_rec.visit_task_number is null OR p_x_task_link_rec.visit_task_number=FND_API.G_MISS_CHAR
460: THEN
461: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_NUMBER_NULL');
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464:
465: ELSE
466: OPEN get_task_info(p_x_task_link_rec.VISIT_TASK_ID,p_x_task_link_rec.visit_task_number);

Line 473: FND_MSG_PUB.ADD;

469: IF get_task_info%NOTFOUND
470: THEN
471: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
472: FND_MESSAGE.SET_TOKEN('RECORD',p_x_task_link_rec.visit_Task_number,false);
473: FND_MSG_PUB.ADD;
474: RAISE FND_API.G_EXC_ERROR;
475: ELSE
476: p_x_task_link_rec.parent_task_id:=l_task_det.visit_task_id;
477: -- Commented by amagrawa based on review comments.

Line 487: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data);
490:
491: WHEN FND_API.G_EXC_ERROR THEN

Line 493: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

489: p_data => x_msg_data);
490:
491: WHEN FND_API.G_EXC_ERROR THEN
492: X_return_status := FND_API.G_RET_STS_ERROR;
493: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => X_msg_data);
496: WHEN OTHERS THEN
497: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

494: p_count => x_msg_count,
495: p_data => X_msg_data);
496: WHEN OTHERS THEN
497: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
501: p_procedure_name => 'TRANS_VALUE_ID',
502: p_error_text => SUBSTR(SQLERRM,1,240));

Line 500: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

496: WHEN OTHERS THEN
497: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: THEN
500: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
501: p_procedure_name => 'TRANS_VALUE_ID',
502: p_error_text => SUBSTR(SQLERRM,1,240));
503: END IF;
504: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 504: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

500: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
501: p_procedure_name => 'TRANS_VALUE_ID',
502: p_error_text => SUBSTR(SQLERRM,1,240));
503: END IF;
504: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => X_msg_data);
507: END;
508:

Line 533: FND_MSG_PUB.ADD;

529: EXCEPTION
530: WHEN l_cyclic_loop THEN
531: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_TASK_ID_CYC');
532: FND_MESSAGE.SET_TOKEN('RECORD',P_VISIT_TASK_NUMBER ,false);
533: FND_MSG_PUB.ADD;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
536: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 537: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

533: FND_MSG_PUB.ADD;
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
536: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data);
540:
541: WHEN FND_API.G_EXC_ERROR THEN

Line 543: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

539: p_data => x_msg_data);
540:
541: WHEN FND_API.G_EXC_ERROR THEN
542: X_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
544: p_count => x_msg_count,
545: p_data => X_msg_data);
546: WHEN OTHERS THEN
547: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

544: p_count => x_msg_count,
545: p_data => X_msg_data);
546: WHEN OTHERS THEN
547: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
551: p_procedure_name => 'NON_CYCLIC_ENF',
552: p_error_text => SUBSTR(SQLERRM,1,240));

Line 550: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

546: WHEN OTHERS THEN
547: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
549: THEN
550: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
551: p_procedure_name => 'NON_CYCLIC_ENF',
552: p_error_text => SUBSTR(SQLERRM,1,240));
553: END IF;
554: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 554: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

550: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
551: p_procedure_name => 'NON_CYCLIC_ENF',
552: p_error_text => SUBSTR(SQLERRM,1,240));
553: END IF;
554: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
555: p_count => x_msg_count,
556: p_data => X_msg_data);
557: END;
558:

Line 589: FND_MSG_PUB.ADD;

585:
586: IF(P_task_link_rec.visit_task_number is NULL or length(trim(P_task_link_rec.visit_task_number)) = 0 )
587: THEN
588: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TASK_NULL');
589: FND_MSG_PUB.ADD;
590: ELSE
591: OPEN CHECK_TASK_ID(P_task_link_rec.visit_task_number,P_task_link_rec.visit_task_id);
592: FETCH CHECK_TASK_ID INTO l_visit_task_id;
593: IF (CHECK_TASK_ID%FOUND) THEN

Line 598: FND_MSG_PUB.ADD;

594: P_task_link_rec.parent_task_id := l_visit_task_id;
595: ELSE
596: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
597: FND_MESSAGE.SET_TOKEN('RECORD',P_task_link_rec.visit_task_number,false);
598: FND_MSG_PUB.ADD;
599: END IF;
600: CLOSE Check_Task_ID;
601: END IF;
602:

Line 605: l_msg_count := FND_MSG_PUB.count_msg;

601: END IF;
602:
603:
604:
605: l_msg_count := FND_MSG_PUB.count_msg;
606: IF l_msg_count > 0
607: THEN
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;

Line 621: -- l_msg_count := FND_MSG_PUB.count_msg;

617: x_msg_data =>l_msg_data,
618: p_task_link_rec =>P_task_link_rec
619: );
620:
621: -- l_msg_count := FND_MSG_PUB.count_msg;
622: -- Added by amagrawa based on review comments.
623: IF l_return_Status <>'S'
624: THEN
625: IF l_return_Status = FND_API.G_RET_STS_ERROR

Line 744: l_msg_count := FND_MSG_PUB.count_msg;

740: END IF;
741:
742: END IF;
743:
744: l_msg_count := FND_MSG_PUB.count_msg;
745: IF l_msg_count > 0
746: THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;

Line 782: FND_MSG_PUB.ADD;

778: AND OBJECT_VERSION_NUMBER=p_object_version_number;
779: IF SQL%ROWCOUNT=0
780: THEN
781: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
782: FND_MSG_PUB.ADD;
783: RAISE FND_API.G_EXC_ERROR;
784: END IF;
785:
786:

Line 811: l_msg_count := FND_MSG_PUB.count_msg;

807: END IF;
808:
809: END IF;
810:
811: l_msg_count := FND_MSG_PUB.count_msg;
812: IF l_msg_count > 0
813: THEN
814: RAISE FND_API.G_EXC_ERROR;
815: END IF;

Line 890: FND_MSG_PUB.initialize;

886: END IF;
887:
888: -- Initialize message list if p_init_msg_list is set to TRUE.
889: IF FND_API.to_boolean(l_init_msg_list) THEN
890: FND_MSG_PUB.initialize;
891: END IF;
892:
893:
894: IF G_DEBUG='Y' THEN

Line 963: /* l_msg_count := FND_MSG_PUB.count_msg;

959: END LOOP;
960: end if;
961:
962: -- Commented by amagrawa based on review comments.
963: /* l_msg_count := FND_MSG_PUB.count_msg;
964: IF l_msg_count > 0 THEN
965: X_msg_count := l_msg_count;
966: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
967: RAISE FND_API.G_EXC_ERROR;

Line 1012: FND_MSG_PUB.ADD;

1008: IF l_status_code <>'PLANNING' THEN
1009:
1010: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_TASK_STATUS');
1011: FND_MESSAGE.SET_TOKEN('RECORD',l_TASK_LINK_tbl(i).visit_task_number ,false);
1012: FND_MSG_PUB.ADD;
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014:
1015: ELSE
1016: l_TASK_LINK_rec.object_version_number :=l_TASK_LINK_tbl(i).object_version_number;

Line 1057: FND_MSG_PUB.ADD;

1053: AND OBJECT_VERSION_NUMBER=l_task_link_tbl(i).OBJECT_VERSION_NUMBER;
1054: IF SQL%ROWCOUNT=0
1055: THEN
1056: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1057: FND_MSG_PUB.ADD;
1058: END IF;
1059: */
1060:
1061: -- End of Post 11.5.10 Changes by Senthil

Line 1122: l_msg_count := FND_MSG_PUB.count_msg;

1118: END IF;
1119: CLOSE C_VISIT;
1120:
1121: END IF;
1122: l_msg_count := FND_MSG_PUB.count_msg;
1123: IF l_msg_count > 0 THEN
1124: X_msg_count := l_msg_count;
1125: X_return_status := FND_API.G_RET_STS_ERROR;
1126: RAISE FND_API.G_EXC_ERROR;

Line 1149: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1145: EXCEPTION
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: ROLLBACK TO PROCESS_TASK_LINKS;
1148: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1150: p_count => x_msg_count,
1151: p_data => x_msg_data);
1152:
1153: WHEN FND_API.G_EXC_ERROR THEN

Line 1156: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1152:
1153: WHEN FND_API.G_EXC_ERROR THEN
1154: ROLLBACK TO PROCESS_TASK_LINKS;
1155: X_return_status := FND_API.G_RET_STS_ERROR;
1156: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1157: p_count => x_msg_count,
1158: p_data => X_msg_data);
1159: WHEN OTHERS THEN
1160: ROLLBACK TO PROCESS_TASK_LINKS;

Line 1162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1158: p_data => X_msg_data);
1159: WHEN OTHERS THEN
1160: ROLLBACK TO PROCESS_TASK_LINKS;
1161: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1163: THEN
1164: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1165: p_procedure_name => 'PROCESS_TASK_LINKS',
1166: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1164: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',

1160: ROLLBACK TO PROCESS_TASK_LINKS;
1161: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1163: THEN
1164: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1165: p_procedure_name => 'PROCESS_TASK_LINKS',
1166: p_error_text => SUBSTR(SQLERRM,1,240));
1167: END IF;
1168: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

Line 1168: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1164: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1165: p_procedure_name => 'PROCESS_TASK_LINKS',
1166: p_error_text => SUBSTR(SQLERRM,1,240));
1167: END IF;
1168: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1169: p_count => x_msg_count,
1170: p_data => X_msg_data);
1171: END;
1172: