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 202: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

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

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

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

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

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

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

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

Line 312: FND_MSG_PUB.initialize;

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

Line 368: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 462: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

489:
490: WHEN FND_API.G_EXC_ERROR THEN
491: ROLLBACK TO get_visit_task_materials;
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:
497: WHEN OTHERS THEN

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

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

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

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

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

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

Line 587: FND_MSG_PUB.initialize;

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

Line 627: Fnd_Msg_Pub.ADD;

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

Line 655: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 724: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 802: l_msg_count := FND_MSG_PUB.count_msg;

798:
799: ------------------------End of Body---------------------------------------
800: --Standard check to count messages
801: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
802: l_msg_count := FND_MSG_PUB.count_msg;
803: IF l_msg_count > 0 THEN
804: RAISE FND_API.G_EXC_ERROR;
805: END IF;
806: END IF;

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

821: EXCEPTION
822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
823: ROLLBACK TO check_materials_for_all;
824: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
826: p_count => x_msg_count,
827: p_data => x_msg_data);
828:
829: WHEN FND_API.G_EXC_ERROR THEN

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

828:
829: WHEN FND_API.G_EXC_ERROR THEN
830: ROLLBACK TO check_materials_for_all;
831: X_return_status := FND_API.G_RET_STS_ERROR;
832: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,
834: p_data => X_msg_data);
835:
836: WHEN OTHERS THEN

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

835:
836: WHEN OTHERS THEN
837: ROLLBACK TO check_materials_for_all;
838: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
842: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
843: p_error_text => SUBSTR(SQLERRM,1,240));

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

837: ROLLBACK TO check_materials_for_all;
838: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
840: THEN
841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
842: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
843: p_error_text => SUBSTR(SQLERRM,1,240));
844: END IF;
845: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

841: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
842: p_procedure_name => 'CHECK_MATERIALS_FOR_ALL',
843: p_error_text => SUBSTR(SQLERRM,1,240));
844: END IF;
845: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
846: p_count => x_msg_count,
847: p_data => X_msg_data);
848:
849: END Check_Materials_For_All;

Line 915: FND_MSG_PUB.initialize;

911: SAVEPOINT Schedule_Planned_Matrls;
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913: IF FND_API.to_boolean(p_init_msg_list)
914: THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917: -- Initialize API return status to success
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: -- Standard call to check for call compatibility.

Line 969: l_msg_count := FND_MSG_PUB.count_msg;

965: END IF;
966:
967: -- Check Error Message stack.
968: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
969: l_msg_count := FND_MSG_PUB.count_msg;
970: IF l_msg_count > 0 THEN
971: RAISE FND_API.G_EXC_ERROR;
972: END IF;
973: END IF;

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

1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: ROLLBACK TO Schedule_Planned_Matrls;
1038: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN

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

1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: ROLLBACK TO Schedule_Planned_Matrls;
1045: X_return_status := FND_API.G_RET_STS_ERROR;
1046: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1047: p_count => x_msg_count,
1048: p_data => X_msg_data);
1049:
1050: WHEN OTHERS THEN

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

1049:
1050: WHEN OTHERS THEN
1051: ROLLBACK TO Schedule_Planned_Matrls;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1056: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1057: p_error_text => SUBSTR(SQLERRM,1,240));

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

1051: ROLLBACK TO Schedule_Planned_Matrls;
1052: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1054: THEN
1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1056: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1055: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1056: p_procedure_name => 'SCHEDULE_PLANNED_MATRLS',
1057: p_error_text => SUBSTR(SQLERRM,1,240));
1058: END IF;
1059: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1060: p_count => x_msg_count,
1061: p_data => X_msg_data);
1062:
1063: END Schedule_Planned_Matrls;

Line 1137: FND_MSG_PUB.initialize;

1133: SAVEPOINT Schedule_All_Materials;
1134: -- Initialize message list if p_init_msg_list is set to TRUE.
1135: IF FND_API.to_boolean(p_init_msg_list)
1136: THEN
1137: FND_MSG_PUB.initialize;
1138: END IF;
1139: -- Initialize API return status to success
1140: x_return_status := FND_API.G_RET_STS_SUCCESS;
1141: -- Standard call to check for call compatibility.

Line 1174: Fnd_Msg_Pub.ADD;

1170: OPEN c_any_task_in_planning(p_visit_id);
1171: FETCH c_any_task_in_planning INTO l_dummy;
1172: IF c_any_task_in_planning%NOTFOUND THEN
1173: Fnd_Message.SET_NAME('AHL','AHL_LTP_SCHEDULE_ALL_NONE_PLAN');
1174: Fnd_Msg_Pub.ADD;
1175: CLOSE c_any_task_in_planning;
1176: RAISE Fnd_Api.G_EXC_ERROR;
1177: END IF;
1178: CLOSE c_any_task_in_planning;

Line 1205: l_msg_count := FND_MSG_PUB.count_msg;

1201: END IF;
1202:
1203: -- Check Error Message stack.
1204: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1205: l_msg_count := FND_MSG_PUB.count_msg;
1206: IF l_msg_count > 0 THEN
1207: RAISE FND_API.G_EXC_ERROR;
1208: END IF;
1209: END IF;

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

1276: EXCEPTION
1277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1278: ROLLBACK TO Schedule_All_Materials;
1279: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1280: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1281: p_count => x_msg_count,
1282: p_data => x_msg_data);
1283:
1284: WHEN FND_API.G_EXC_ERROR THEN

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

1283:
1284: WHEN FND_API.G_EXC_ERROR THEN
1285: ROLLBACK TO Schedule_All_Materials;
1286: X_return_status := FND_API.G_RET_STS_ERROR;
1287: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => X_msg_data);
1290:
1291: WHEN OTHERS THEN

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

1290:
1291: WHEN OTHERS THEN
1292: ROLLBACK TO Schedule_All_Materials;
1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1295: THEN
1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1297: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1298: p_error_text => SUBSTR(SQLERRM,1,240));

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

1292: ROLLBACK TO Schedule_All_Materials;
1293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1295: THEN
1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1297: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1298: p_error_text => SUBSTR(SQLERRM,1,240));
1299: END IF;
1300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1296: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_MATRL_AVAL_PUB',
1297: p_procedure_name => 'SCHEDULE_ALL_MATERIALS',
1298: p_error_text => SUBSTR(SQLERRM,1,240));
1299: END IF;
1300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1301: p_count => x_msg_count,
1302: p_data => X_msg_data);
1303:
1304: END Schedule_All_Materials;