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_LTP_MATRL_AVAL_PUB dependencies on FND_MSG_PUB

Line 86: FND_MSG_PUB.initialize;

82: SAVEPOINT check_material_aval;
83: -- Standard call to check for call compatibility.
84: IF FND_API.to_boolean(p_init_msg_list)
85: THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 139: l_msg_count := FND_MSG_PUB.count_msg;

135: END IF;
136:
137: -- Check Error Message stack.
138: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
139: l_msg_count := FND_MSG_PUB.count_msg;
140: IF l_msg_count > 0 THEN
141: RAISE FND_API.G_EXC_ERROR;
142: END IF;
143: END IF;

Line 199: l_msg_count := FND_MSG_PUB.count_msg;

195: END IF;
196: ------------------------End of Body---------------------------------------
197: --Standard check to count messages
198: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
199: l_msg_count := FND_MSG_PUB.count_msg;
200: IF l_msg_count > 0 THEN
201: RAISE FND_API.G_EXC_ERROR;
202: END IF;
203: END IF;

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

219: EXCEPTION
220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221: ROLLBACK TO check_material_aval;
222: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
224: p_count => x_msg_count,
225: p_data => x_msg_data);
226:
227: WHEN FND_API.G_EXC_ERROR THEN

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

226:
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO check_material_aval;
229: X_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
231: p_count => x_msg_count,
232: p_data => X_msg_data);
233:
234: WHEN OTHERS THEN

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

233:
234: WHEN OTHERS THEN
235: ROLLBACK TO check_material_aval;
236: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: THEN
239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
240: p_procedure_name => 'CHECK_MATERIAL_AVAL',
241: p_error_text => SUBSTR(SQLERRM,1,240));

Line 239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

235: ROLLBACK TO check_material_aval;
236: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
238: THEN
239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
240: p_procedure_name => 'CHECK_MATERIAL_AVAL',
241: p_error_text => SUBSTR(SQLERRM,1,240));
242: END IF;
243: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
240: p_procedure_name => 'CHECK_MATERIAL_AVAL',
241: p_error_text => SUBSTR(SQLERRM,1,240));
242: END IF;
243: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
244: p_count => x_msg_count,
245: p_data => X_msg_data);
246:
247: END Check_Material_Aval;

Line 309: FND_MSG_PUB.initialize;

305: SAVEPOINT get_visit_task_materials;
306: -- Initialize message list if p_init_msg_list is set to TRUE.
307: IF FND_API.to_boolean(p_init_msg_list)
308: THEN
309: FND_MSG_PUB.initialize;
310: END IF;
311: -- Initialize API return status to success
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313: -- Standard call to check for call compatibility.

Line 365: l_msg_count := FND_MSG_PUB.count_msg;

361: END IF;
362:
363: -- Check Error Message stack.
364: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
365: l_msg_count := FND_MSG_PUB.count_msg;
366: IF l_msg_count > 0 THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369: END IF;

Line 459: l_msg_count := FND_MSG_PUB.count_msg;

455: END IF;
456:
457: -- Check Error Message stack.
458: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
459: l_msg_count := FND_MSG_PUB.count_msg;
460: IF l_msg_count > 0 THEN
461: RAISE FND_API.G_EXC_ERROR;
462: END IF;
463: END IF;

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

479: EXCEPTION
480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
481: ROLLBACK TO get_visit_task_materials;
482: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
484: p_count => x_msg_count,
485: p_data => x_msg_data);
486:
487: WHEN FND_API.G_EXC_ERROR THEN

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

486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO get_visit_task_materials;
489: X_return_status := FND_API.G_RET_STS_ERROR;
490: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
491: p_count => x_msg_count,
492: p_data => X_msg_data);
493:
494: WHEN OTHERS THEN

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

493:
494: WHEN OTHERS THEN
495: ROLLBACK TO get_visit_task_materials;
496: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
498: THEN
499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
500: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
501: p_error_text => SUBSTR(SQLERRM,1,240));

Line 499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

495: ROLLBACK TO get_visit_task_materials;
496: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
498: THEN
499: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
500: p_procedure_name => 'GET_VISIT_TASK_MATERIALS',
501: p_error_text => SUBSTR(SQLERRM,1,240));
502: END IF;
503: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

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

Line 584: FND_MSG_PUB.initialize;

580: SAVEPOINT check_materials_for_all;
581: -- Standard call to check for call compatibility.
582: IF FND_API.to_boolean(p_init_msg_list)
583: THEN
584: FND_MSG_PUB.initialize;
585: END IF;
586: -- Initialize API return status to success
587: x_return_status := FND_API.G_RET_STS_SUCCESS;
588: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 624: Fnd_Msg_Pub.ADD;

620: OPEN c_any_task_in_planning(p_visit_id);
621: FETCH c_any_task_in_planning INTO l_dummy;
622: IF c_any_task_in_planning%NOTFOUND THEN
623: Fnd_Message.SET_NAME('AHL','AHL_LTP_CHK_AVL_ALL_NONE_PLAN');
624: Fnd_Msg_Pub.ADD;
625: CLOSE c_any_task_in_planning;
626: RAISE Fnd_Api.G_EXC_ERROR;
627: END IF;
628: CLOSE c_any_task_in_planning;

Line 652: l_msg_count := FND_MSG_PUB.count_msg;

648: END IF;
649:
650: -- Check Error Message stack.
651: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
652: l_msg_count := FND_MSG_PUB.count_msg;
653: IF l_msg_count > 0 THEN
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656: END IF;

Line 721: l_msg_count := FND_MSG_PUB.count_msg;

717: END IF;
718:
719: -- Check Error Message stack.
720: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
721: l_msg_count := FND_MSG_PUB.count_msg;
722: IF l_msg_count > 0 THEN
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: END IF;

Line 790: l_msg_count := FND_MSG_PUB.count_msg;

786:
787: ------------------------End of Body---------------------------------------
788: --Standard check to count messages
789: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
790: l_msg_count := FND_MSG_PUB.count_msg;
791: IF l_msg_count > 0 THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: END IF;

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

809: EXCEPTION
810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
811: ROLLBACK TO check_materials_for_all;
812: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
814: p_count => x_msg_count,
815: p_data => x_msg_data);
816:
817: WHEN FND_API.G_EXC_ERROR THEN

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

816:
817: WHEN FND_API.G_EXC_ERROR THEN
818: ROLLBACK TO check_materials_for_all;
819: X_return_status := FND_API.G_RET_STS_ERROR;
820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => X_msg_data);
823:
824: WHEN OTHERS THEN

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

823:
824: WHEN OTHERS THEN
825: ROLLBACK TO check_materials_for_all;
826: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
830: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
831: p_error_text => SUBSTR(SQLERRM,1,240));

Line 829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

825: ROLLBACK TO check_materials_for_all;
826: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
830: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
831: p_error_text => SUBSTR(SQLERRM,1,240));
832: END IF;
833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
830: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
831: p_error_text => SUBSTR(SQLERRM,1,240));
832: END IF;
833: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
834: p_count => x_msg_count,
835: p_data => X_msg_data);
836:
837: END Check_Materials_For_All;

Line 903: FND_MSG_PUB.initialize;

899: SAVEPOINT Schedule_Planned_Matrls;
900: -- Initialize message list if p_init_msg_list is set to TRUE.
901: IF FND_API.to_boolean(p_init_msg_list)
902: THEN
903: FND_MSG_PUB.initialize;
904: END IF;
905: -- Initialize API return status to success
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907: -- Standard call to check for call compatibility.

Line 957: l_msg_count := FND_MSG_PUB.count_msg;

953: END IF;
954:
955: -- Check Error Message stack.
956: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
957: l_msg_count := FND_MSG_PUB.count_msg;
958: IF l_msg_count > 0 THEN
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: END IF;

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

1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: ROLLBACK TO Schedule_Planned_Matrls;
1017: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1019: p_count => x_msg_count,
1020: p_data => x_msg_data);
1021:
1022: WHEN FND_API.G_EXC_ERROR THEN

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

1021:
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: ROLLBACK TO Schedule_Planned_Matrls;
1024: X_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => X_msg_data);
1028:
1029: WHEN OTHERS THEN

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

1028:
1029: WHEN OTHERS THEN
1030: ROLLBACK TO Schedule_Planned_Matrls;
1031: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1035: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1036: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

1030: ROLLBACK TO Schedule_Planned_Matrls;
1031: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1033: THEN
1034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1035: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1036: p_error_text => SUBSTR(SQLERRM,1,240));
1037: END IF;
1038: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1034: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1035: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1036: p_error_text => SUBSTR(SQLERRM,1,240));
1037: END IF;
1038: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1039: p_count => x_msg_count,
1040: p_data => X_msg_data);
1041:
1042: END Schedule_Planned_Matrls;

Line 1116: FND_MSG_PUB.initialize;

1112: SAVEPOINT Schedule_All_Materials;
1113: -- Initialize message list if p_init_msg_list is set to TRUE.
1114: IF FND_API.to_boolean(p_init_msg_list)
1115: THEN
1116: FND_MSG_PUB.initialize;
1117: END IF;
1118: -- Initialize API return status to success
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120: -- Standard call to check for call compatibility.

Line 1153: Fnd_Msg_Pub.ADD;

1149: OPEN c_any_task_in_planning(p_visit_id);
1150: FETCH c_any_task_in_planning INTO l_dummy;
1151: IF c_any_task_in_planning%NOTFOUND THEN
1152: Fnd_Message.SET_NAME('AHL','AHL_LTP_SCHEDULE_ALL_NONE_PLAN');
1153: Fnd_Msg_Pub.ADD;
1154: CLOSE c_any_task_in_planning;
1155: RAISE Fnd_Api.G_EXC_ERROR;
1156: END IF;
1157: CLOSE c_any_task_in_planning;

Line 1184: l_msg_count := FND_MSG_PUB.count_msg;

1180: END IF;
1181:
1182: -- Check Error Message stack.
1183: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1184: l_msg_count := FND_MSG_PUB.count_msg;
1185: IF l_msg_count > 0 THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: END IF;

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

1246: EXCEPTION
1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1248: ROLLBACK TO Schedule_All_Materials;
1249: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1250: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data);
1253:
1254: WHEN FND_API.G_EXC_ERROR THEN

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

1253:
1254: WHEN FND_API.G_EXC_ERROR THEN
1255: ROLLBACK TO Schedule_All_Materials;
1256: X_return_status := FND_API.G_RET_STS_ERROR;
1257: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1258: p_count => x_msg_count,
1259: p_data => X_msg_data);
1260:
1261: WHEN OTHERS THEN

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

1260:
1261: WHEN OTHERS THEN
1262: ROLLBACK TO Schedule_All_Materials;
1263: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1267: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1268: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',

1262: ROLLBACK TO Schedule_All_Materials;
1263: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1265: THEN
1266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1267: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1268: p_error_text => SUBSTR(SQLERRM,1,240));
1269: END IF;
1270: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1266: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1267: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1268: p_error_text => SUBSTR(SQLERRM,1,240));
1269: END IF;
1270: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1271: p_count => x_msg_count,
1272: p_data => X_msg_data);
1273:
1274: END Schedule_All_Materials;