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

Line 54: FND_MSG_PUB.initialize;

50: END IF;
51:
52: -- Initialize message list if p_init_msg_list is set to TRUE.
53: IF FND_API.to_boolean( p_init_msg_list ) THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
58: fnd_log.string

Line 96: x_msg_count := FND_MSG_PUB.count_msg;

92: p_x_operation_rec => p_x_oper_rec
93: );
94:
95: -- to raise errors from AHL_RM_OPERATION_PVT.process_operation
96: x_msg_count := FND_MSG_PUB.count_msg;
97:
98: IF x_msg_count > 0 THEN
99: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: RAISE FND_API.G_EXC_ERROR;

Line 112: FND_MSG_PUB.ADD;

108:
109: ElSE
110: -- If the DML operation is not Cretae then its invalid
111: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
112: FND_MSG_PUB.ADD;
113: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
114: fnd_log.string
115: (
116: fnd_log.level_error,

Line 178: x_msg_count := FND_MSG_PUB.count_msg;

174: p_x_association_tbl => p_x_oper_doc_tbl
175: );
176:
177: -- to raise errors from AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION
178: x_msg_count := FND_MSG_PUB.count_msg;
179:
180: IF x_msg_count > 0 THEN
181: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: RAISE FND_API.G_EXC_ERROR;

Line 214: x_msg_count := FND_MSG_PUB.count_msg;

210: p_object_id => p_x_oper_rec.OPERATION_ID
211: );
212:
213: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
214: x_msg_count := FND_MSG_PUB.count_msg;
215:
216: IF x_msg_count > 0 THEN
217: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: RAISE FND_API.G_EXC_ERROR;

Line 252: x_msg_count := FND_MSG_PUB.count_msg;

248: x_msg_data => x_msg_data,
249: p_x_rt_oper_cost_rec => l_x_rt_oper_cost_rec
250: );
251:
252: x_msg_count := FND_MSG_PUB.count_msg;
253:
254: IF x_msg_count > 0 THEN
255: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: RAISE FND_API.G_EXC_ERROR;

Line 289: x_msg_count := FND_MSG_PUB.count_msg;

285: p_object_id => p_x_oper_rec.OPERATION_ID,
286: p_association_type => 'OPERATION'
287: );
288: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
289: x_msg_count := FND_MSG_PUB.count_msg;
290:
291: IF x_msg_count > 0 THEN
292: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
293: RAISE FND_API.G_EXC_ERROR;

Line 323: x_msg_count := FND_MSG_PUB.count_msg;

319: p_association_type_code => 'OPERATION',
320: p_object_id => p_x_oper_rec.OPERATION_ID
321: );
322: -- to raise errors from AHL_RM_RT_OPER_PANEL_PVT.process_rt_oper_panel
323: x_msg_count := FND_MSG_PUB.count_msg;
324:
325: IF x_msg_count > 0 THEN
326: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: RAISE FND_API.G_EXC_ERROR;

Line 374: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: Rollback to create_operation_pub;
374: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
375: p_data => x_msg_data,
376: p_encoded => fnd_api.g_false);
377:
378:

Line 382: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: Rollback to create_operation_pub;
382: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
383: p_data => x_msg_data,
384: p_encoded => fnd_api.g_false);
385:
386: WHEN OTHERS THEN

Line 389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

385:
386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: Rollback to create_operation_pub;
389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
390: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
391: p_procedure_name => 'CREATE_OPERATION',
392: p_error_text => SQLERRM);
393: END IF;

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

386: WHEN OTHERS THEN
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388: Rollback to create_operation_pub;
389: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
390: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
391: p_procedure_name => 'CREATE_OPERATION',
392: p_error_text => SQLERRM);
393: END IF;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

390: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
391: p_procedure_name => 'CREATE_OPERATION',
392: p_error_text => SQLERRM);
393: END IF;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false);
397:
398: END Create_Operation;

Line 469: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

465: --
466: EXCEPTION
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
470: p_data => x_msg_data,
471: p_encoded => fnd_api.g_false);
472:
473: WHEN OTHERS THEN

Line 475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

471: p_encoded => fnd_api.g_false);
472:
473: WHEN OTHERS THEN
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
476: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
477: p_procedure_name => 'CREATE_OPERATION',
478: p_error_text => SQLERRM);
479: END IF;

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

472:
473: WHEN OTHERS THEN
474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
475: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
476: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
477: p_procedure_name => 'CREATE_OPERATION',
478: p_error_text => SQLERRM);
479: END IF;
480: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 480: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

476: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
477: p_procedure_name => 'CREATE_OPERATION',
478: p_error_text => SQLERRM);
479: END IF;
480: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
481: p_data => x_msg_data,
482: p_encoded => fnd_api.g_false);
483:
484: END Create_Operation;

Line 538: FND_MSG_PUB.initialize;

534: END IF;
535:
536: -- Initialize message list if p_init_msg_list is set to TRUE.
537: IF FND_API.to_boolean( p_init_msg_list ) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
542: fnd_log.string

Line 623: x_msg_count := FND_MSG_PUB.count_msg;

619: x_msg_data => x_msg_data,
620: p_x_operation_rec => l_oper_rec
621: );
622: -- to raise errors from AHL_RM_OPERATION_PVT.process_operation
623: x_msg_count := FND_MSG_PUB.count_msg;
624:
625:
626: IF x_msg_count > 0 THEN
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 634: FND_MSG_PUB.ADD;

630:
631: ElSIF p_oper_rec.DML_OPERATION IS NOT NULL THEN
632: -- If the DML operation is not 'U' and is also not NULL, then throw an error
633: FND_MESSAGE.SET_NAME('AHL','AHL_COM_INVALID_DML_FLAG');
634: FND_MSG_PUB.ADD;
635: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
636: fnd_log.string
637: (
638: fnd_log.level_error,

Line 691: x_msg_count := FND_MSG_PUB.count_msg;

687: p_x_association_tbl => p_x_oper_doc_tbl
688: );
689:
690: -- to raise errors from AHL_RM_ASSO_DOCASO_PVT.PROCESS_ASSOCIATION
691: x_msg_count := FND_MSG_PUB.count_msg;
692:
693: IF x_msg_count > 0 THEN
694: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: RAISE FND_API.G_EXC_ERROR;

Line 720: x_msg_count := FND_MSG_PUB.count_msg;

716: p_object_id => l_oper_id
717: );
718:
719: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
720: x_msg_count := FND_MSG_PUB.count_msg;
721:
722: IF x_msg_count > 0 THEN
723: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: RAISE FND_API.G_EXC_ERROR;

Line 867: x_msg_count := FND_MSG_PUB.count_msg;

863: p_association_type => 'OPERATION'
864: );
865:
866: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
867: x_msg_count := FND_MSG_PUB.count_msg;
868:
869: IF x_msg_count > 0 THEN
870: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: RAISE FND_API.G_EXC_ERROR;

Line 898: x_msg_count := FND_MSG_PUB.count_msg;

894: p_object_id => l_oper_id
895: );
896:
897: -- to raise errors from AHL_RM_RT_OPER_PANEL_PVT.process_rt_oper_panel
898: x_msg_count := FND_MSG_PUB.count_msg;
899:
900: IF x_msg_count > 0 THEN
901: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
902: RAISE FND_API.G_EXC_ERROR;

Line 949: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

945: EXCEPTION
946: WHEN FND_API.G_EXC_ERROR THEN
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: Rollback to modify_operation_pub;
949: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
950: p_data => x_msg_data,
951: p_encoded => fnd_api.g_false);
952:
953:

Line 957: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: Rollback to modify_operation_pub;
957: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
958: p_data => x_msg_data,
959: p_encoded => fnd_api.g_false);
960:
961: WHEN OTHERS THEN

Line 964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

960:
961: WHEN OTHERS THEN
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: Rollback to modify_operation_pub;
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
965: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
966: p_procedure_name => 'MODIFY_OPERATION',
967: p_error_text => SQLERRM);
968: END IF;

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

961: WHEN OTHERS THEN
962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963: Rollback to modify_operation_pub;
964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
965: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
966: p_procedure_name => 'MODIFY_OPERATION',
967: p_error_text => SQLERRM);
968: END IF;
969: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 969: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

965: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
966: p_procedure_name => 'MODIFY_OPERATION',
967: p_error_text => SQLERRM);
968: END IF;
969: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => fnd_api.g_false);
972:
973: END Modify_Operation;

Line 1046: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1042: --
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1047: p_data => x_msg_data,
1048: p_encoded => fnd_api.g_false);
1049:
1050: WHEN OTHERS THEN

Line 1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1048: p_encoded => fnd_api.g_false);
1049:
1050: WHEN OTHERS THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1053: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1054: p_procedure_name => 'MODIFY_OPERATION',
1055: p_error_text => SQLERRM);
1056: END IF;

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

1049:
1050: WHEN OTHERS THEN
1051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1053: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1054: p_procedure_name => 'MODIFY_OPERATION',
1055: p_error_text => SQLERRM);
1056: END IF;
1057: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1057: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1053: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1054: p_procedure_name => 'MODIFY_OPERATION',
1055: p_error_text => SQLERRM);
1056: END IF;
1057: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1058: p_data => x_msg_data,
1059: p_encoded => fnd_api.g_false);
1060:
1061: END Modify_Operation;

Line 1111: FND_MSG_PUB.initialize;

1107: END IF;
1108:
1109: -- Initialize message list if p_init_msg_list is set to TRUE.
1110: IF FND_API.to_boolean( p_init_msg_list ) THEN
1111: FND_MSG_PUB.initialize;
1112: END IF;
1113:
1114: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1115: fnd_log.string

Line 1188: x_msg_count := FND_MSG_PUB.count_msg;

1184: p_operation_id => l_oper_id ,
1185: p_object_version_number => p_oper_object_version
1186: );
1187: -- to raise errors from AHL_RM_OPERATION_PVT.process_operation
1188: x_msg_count := FND_MSG_PUB.count_msg;
1189:
1190: IF x_msg_count > 0 THEN
1191: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: RAISE FND_API.G_EXC_ERROR;

Line 1237: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1233: EXCEPTION
1234: WHEN FND_API.G_EXC_ERROR THEN
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236: Rollback to delete_operation_pub;
1237: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1238: p_data => x_msg_data,
1239: p_encoded => fnd_api.g_false);
1240:
1241:

Line 1245: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1241:
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: Rollback to delete_operation_pub;
1245: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1246: p_data => x_msg_data,
1247: p_encoded => fnd_api.g_false);
1248:
1249: WHEN OTHERS THEN

Line 1252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1248:
1249: WHEN OTHERS THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: Rollback to delete_operation_pub;
1252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1253: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1254: p_procedure_name => 'DELETE_OPERATION',
1255: p_error_text => SQLERRM);
1256: END IF;

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

1249: WHEN OTHERS THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: Rollback to delete_operation_pub;
1252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1253: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1254: p_procedure_name => 'DELETE_OPERATION',
1255: p_error_text => SQLERRM);
1256: END IF;
1257: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1257: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1253: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1254: p_procedure_name => 'DELETE_OPERATION',
1255: p_error_text => SQLERRM);
1256: END IF;
1257: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1258: p_data => x_msg_data,
1259: p_encoded => fnd_api.g_false);
1260:
1261: END Delete_Operation;

Line 1335: FND_MSG_PUB.initialize;

1331: END IF;
1332:
1333: -- Initialize message list if p_init_msg_list is set to TRUE.
1334: IF FND_API.to_boolean( p_init_msg_list ) THEN
1335: FND_MSG_PUB.initialize;
1336: END IF;
1337:
1338: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1339: fnd_log.string

Line 1394: FND_MSG_PUB.add;

1390: IF get_res_id%NOTFOUND THEN
1391: -- PRITHWI : please run this message and check what it displays.
1392: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ASO_RES_ID' );
1393: FND_MESSAGE.set_token( 'RECORD', p_resource_name );
1394: FND_MSG_PUB.add;
1395: RAISE FND_API.G_EXC_ERROR;
1396: END IF;
1397:
1398: CLOSE get_res_id;

Line 1408: FND_MSG_PUB.add;

1404: FETCH get_rt_oper_resource INTO l_rt_oper_resource_id;
1405: IF get_rt_oper_resource%NOTFOUND THEN
1406: -- PRITHWI : please run this message and check what it displays.
1407: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OBJECT' );
1408: FND_MSG_PUB.add;
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411:
1412: CLOSE get_rt_oper_resource;

Line 1492: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1488: EXCEPTION
1489: WHEN FND_API.G_EXC_ERROR THEN
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491: Rollback to Process_Alt_Resources;
1492: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1493: p_data => x_msg_data,
1494: p_encoded => fnd_api.g_false);
1495:
1496:

Line 1500: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1496:
1497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499: Rollback to Process_Alt_Resources;
1500: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1501: p_data => x_msg_data,
1502: p_encoded => fnd_api.g_false);
1503:
1504: WHEN OTHERS THEN

Line 1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1503:
1504: WHEN OTHERS THEN
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: Rollback to Process_Alt_Resources;
1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1508: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1509: p_procedure_name => 'Process_Oper_Alt_Resources',
1510: p_error_text => SQLERRM);
1511: END IF;

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

1504: WHEN OTHERS THEN
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: Rollback to Process_Alt_Resources;
1507: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1508: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1509: p_procedure_name => 'Process_Oper_Alt_Resources',
1510: p_error_text => SQLERRM);
1511: END IF;
1512: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1512: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1508: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1509: p_procedure_name => 'Process_Oper_Alt_Resources',
1510: p_error_text => SQLERRM);
1511: END IF;
1512: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1513: p_data => x_msg_data,
1514: p_encoded => fnd_api.g_false);
1515:
1516: END Process_Oper_Alt_Resources;

Line 1569: FND_MSG_PUB.initialize;

1565: END IF;
1566:
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_boolean( p_init_msg_list ) THEN
1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1573: fnd_log.string

Line 1678: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1674: EXCEPTION
1675: WHEN FND_API.G_EXC_ERROR THEN
1676: x_return_status := FND_API.G_RET_STS_ERROR;
1677: Rollback to create_oper_revision_pub;
1678: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1679: p_data => x_msg_data,
1680: p_encoded => fnd_api.g_false);
1681:
1682:

Line 1686: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1682:
1683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1685: Rollback to create_oper_revision_pub;
1686: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1687: p_data => x_msg_data,
1688: p_encoded => fnd_api.g_false);
1689:
1690: WHEN OTHERS THEN

Line 1693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1689:
1690: WHEN OTHERS THEN
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: Rollback to create_oper_revision_pub;
1693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1694: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1695: p_procedure_name => 'create_oper_revision',
1696: p_error_text => SQLERRM);
1697: END IF;

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

1690: WHEN OTHERS THEN
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1692: Rollback to create_oper_revision_pub;
1693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1694: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1695: p_procedure_name => 'create_oper_revision',
1696: p_error_text => SQLERRM);
1697: END IF;
1698: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1698: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1694: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1695: p_procedure_name => 'create_oper_revision',
1696: p_error_text => SQLERRM);
1697: END IF;
1698: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1699: p_data => x_msg_data,
1700: p_encoded => fnd_api.g_false);
1701:
1702: END Create_Oper_Revision;

Line 1753: FND_MSG_PUB.initialize;

1749: END IF;
1750:
1751: -- Initialize message list if p_init_msg_list is set to TRUE.
1752: IF FND_API.to_boolean( p_init_msg_list ) THEN
1753: FND_MSG_PUB.initialize;
1754: END IF;
1755:
1756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1757: fnd_log.string

Line 1856: FND_MSG_PUB.Count_And_Get

1852: COMMIT WORK;
1853: END IF;
1854:
1855: -- Standard call to get message count and if count is 1, get message
1856: FND_MSG_PUB.Count_And_Get
1857: ( p_count => x_msg_count,
1858: p_data => x_msg_data,
1859: p_encoded => fnd_api.g_false);
1860:

Line 1866: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1862: EXCEPTION
1863: WHEN FND_API.G_EXC_ERROR THEN
1864: x_return_status := FND_API.G_RET_STS_ERROR;
1865: Rollback to initiate_oper_approval_pub;
1866: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1867: p_data => x_msg_data,
1868: p_encoded => fnd_api.g_false);
1869:
1870:

Line 1874: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1870:
1871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1873: Rollback to initiate_oper_approval_pub;
1874: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1875: p_data => x_msg_data,
1876: p_encoded => fnd_api.g_false);
1877:
1878: WHEN OTHERS THEN

Line 1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1877:
1878: WHEN OTHERS THEN
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: Rollback to initiate_oper_approval_pub;
1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1882: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1883: p_procedure_name => 'INITIATE_OPER_APPROVAL',
1884: p_error_text => SQLERRM);
1885: END IF;

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

1878: WHEN OTHERS THEN
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: Rollback to initiate_oper_approval_pub;
1881: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1882: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1883: p_procedure_name => 'INITIATE_OPER_APPROVAL',
1884: p_error_text => SQLERRM);
1885: END IF;
1886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 1886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

1882: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1883: p_procedure_name => 'INITIATE_OPER_APPROVAL',
1884: p_error_text => SQLERRM);
1885: END IF;
1886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1887: p_data => x_msg_data,
1888: p_encoded => fnd_api.g_false);
1889:
1890: END Initiate_Oper_Approval;