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_EAM_JOB_PVT dependencies on FND_API

Line 206: RAISE FND_API.G_EXC_ERROR;

202: IF l_DEFAULT_WORKORDER_TYPE IS NULL
203: THEN
204: FND_MESSAGE.set_name('AHL','AHL_PRD_NO_WORKORDER_TYPE');
205: FND_MSG_PUB.add;
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208:
209: IF (p_visit_task_id IS NULL AND p_master_workorder_flag = 'Y' )
210: --************************Visit Master Workorder *******************--

Line 221: RAISE FND_API.G_EXC_ERROR;

217: IF (get_ue_id_csr%NOTFOUND) THEN
218: CLOSE get_ue_id_csr;
219: FND_MESSAGE.set_name('AHL','AHL_PRD_VISIT_TASK_NULL');
220: FND_MSG_PUB.add;
221: RAISE FND_API.G_EXC_ERROR;
222: END IF;
223: CLOSE get_ue_id_csr;
224:
225: IF (l_ue_id IS NULL) THEN

Line 789: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

785:
786: PROCEDURE create_eam_workorder
787: (
788: p_api_version IN NUMBER := 1.0,
789: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
792: p_default IN VARCHAR2 := FND_API.G_FALSE,
793: p_module_type IN VARCHAR2 := NULL,

Line 790: p_commit IN VARCHAR2 := FND_API.G_FALSE,

786: PROCEDURE create_eam_workorder
787: (
788: p_api_version IN NUMBER := 1.0,
789: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
792: p_default IN VARCHAR2 := FND_API.G_FALSE,
793: p_module_type IN VARCHAR2 := NULL,
794: x_return_status OUT NOCOPY VARCHAR2,

Line 791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

787: (
788: p_api_version IN NUMBER := 1.0,
789: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
792: p_default IN VARCHAR2 := FND_API.G_FALSE,
793: p_module_type IN VARCHAR2 := NULL,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,

Line 792: p_default IN VARCHAR2 := FND_API.G_FALSE,

788: p_api_version IN NUMBER := 1.0,
789: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
791: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
792: p_default IN VARCHAR2 := FND_API.G_FALSE,
793: p_module_type IN VARCHAR2 := NULL,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838: AHL_DEBUG_PUB.enable_debug;
839: END IF;
840:
841: -- Initialize API return status to success
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: -- Standard Start of API savepoint
845: SAVEPOINT create_eam_workorder_PVT;
846:

Line 953: p_commit => FND_API.G_FALSE,

949: (
950: p_bo_identifier => l_bo_identifier,
951: p_api_version_number => 1.0,
952: p_init_msg_list => l_init_msg_list,
953: p_commit => FND_API.G_FALSE,
954: p_eam_wo_rec => l_eam_wo_rec,
955: p_eam_op_tbl => l_eam_op_tbl,
956: p_eam_op_network_tbl => l_eam_op_network_tbl,
957: p_eam_res_tbl => l_eam_res_tbl,

Line 980: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

976: p_debug_filename => l_debug_filename,
977: p_debug_file_mode => l_debug_file_mode
978: );
979:
980: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
981: IF ( G_DEBUG = 'Y' ) THEN
982: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
983: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
984: END IF;

Line 986: RAISE FND_API.G_EXC_ERROR;

982: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
983: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
984: END IF;
985:
986: RAISE FND_API.G_EXC_ERROR;
987: ELSE
988: IF ( G_DEBUG = 'Y' ) THEN
989: AHL_DEBUG_PUB.debug( 'EAM process_wo API Successful' );
990: END IF;

Line 999: IF FND_API.to_boolean( p_commit ) THEN

995: AHL_DEBUG_PUB.debug( 'New wip_entity_id:' || TO_CHAR( p_x_workorder_rec.wip_entity_id ) );
996: END IF;
997:
998: -- Perform the Commit (if requested)
999: IF FND_API.to_boolean( p_commit ) THEN
1000: COMMIT WORK;
1001: END IF;
1002: END IF;
1003:

Line 1011: WHEN FND_API.G_EXC_ERROR THEN

1007: END IF;
1008:
1009: EXCEPTION
1010:
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: ROLLBACK TO create_eam_workorder_PVT;
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: FND_MSG_PUB.count_and_get
1015: (

Line 1013: x_return_status := FND_API.G_RET_STS_ERROR;

1009: EXCEPTION
1010:
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: ROLLBACK TO create_eam_workorder_PVT;
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: FND_MSG_PUB.count_and_get
1015: (
1016: p_encoded => FND_API.G_FALSE,
1017: p_count => x_msg_count,

Line 1016: p_encoded => FND_API.G_FALSE,

1012: ROLLBACK TO create_eam_workorder_PVT;
1013: x_return_status := FND_API.G_RET_STS_ERROR;
1014: FND_MSG_PUB.count_and_get
1015: (
1016: p_encoded => FND_API.G_FALSE,
1017: p_count => x_msg_count,
1018: p_data => x_msg_data
1019: );
1020:

Line 1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1021: IF ( G_DEBUG = 'Y' ) THEN
1022: AHL_DEBUG_PUB.disable_debug;
1023: END IF;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO create_eam_workorder_PVT;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028: FND_MSG_PUB.count_and_get
1029: (

Line 1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1023: END IF;
1024:
1025: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1026: ROLLBACK TO create_eam_workorder_PVT;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028: FND_MSG_PUB.count_and_get
1029: (
1030: p_encoded => FND_API.G_FALSE,
1031: p_count => x_msg_count,

Line 1030: p_encoded => FND_API.G_FALSE,

1026: ROLLBACK TO create_eam_workorder_PVT;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1028: FND_MSG_PUB.count_and_get
1029: (
1030: p_encoded => FND_API.G_FALSE,
1031: p_count => x_msg_count,
1032: p_data => x_msg_data
1033: );
1034:

Line 1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1037: END IF;
1038:
1039: WHEN OTHERS THEN
1040: ROLLBACK TO create_eam_workorder_PVT;
1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1042: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1043: THEN
1044: FND_MSG_PUB.add_exc_msg
1045: (

Line 1053: p_encoded => FND_API.G_FALSE,

1049: );
1050: END IF;
1051: FND_MSG_PUB.count_and_get
1052: (
1053: p_encoded => FND_API.G_FALSE,
1054: p_count => x_msg_count,
1055: p_data => x_msg_data
1056: );
1057:

Line 1066: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1062:
1063: PROCEDURE update_job_operations
1064: (
1065: p_api_version IN NUMBER := 1.0,
1066: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1067: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1068: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1069: p_default IN VARCHAR2 := FND_API.G_FALSE,
1070: p_module_type IN VARCHAR2 := NULL,

Line 1067: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1063: PROCEDURE update_job_operations
1064: (
1065: p_api_version IN NUMBER := 1.0,
1066: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1067: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1068: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1069: p_default IN VARCHAR2 := FND_API.G_FALSE,
1070: p_module_type IN VARCHAR2 := NULL,
1071: x_return_status OUT NOCOPY VARCHAR2,

Line 1068: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1064: (
1065: p_api_version IN NUMBER := 1.0,
1066: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1067: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1068: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1069: p_default IN VARCHAR2 := FND_API.G_FALSE,
1070: p_module_type IN VARCHAR2 := NULL,
1071: x_return_status OUT NOCOPY VARCHAR2,
1072: x_msg_count OUT NOCOPY NUMBER,

Line 1069: p_default IN VARCHAR2 := FND_API.G_FALSE,

1065: p_api_version IN NUMBER := 1.0,
1066: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1067: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1068: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1069: p_default IN VARCHAR2 := FND_API.G_FALSE,
1070: p_module_type IN VARCHAR2 := NULL,
1071: x_return_status OUT NOCOPY VARCHAR2,
1072: x_msg_count OUT NOCOPY NUMBER,
1073: x_msg_data OUT NOCOPY VARCHAR2,

Line 1119: x_return_status := FND_API.G_RET_STS_SUCCESS;

1115: AHL_DEBUG_PUB.enable_debug;
1116: END IF;
1117:
1118: -- Initialize API return status to success
1119: x_return_status := FND_API.G_RET_STS_SUCCESS;
1120:
1121: -- Standard Start of API savepoint
1122: SAVEPOINT update_job_operations_PVT;
1123:

Line 1219: p_commit => FND_API.G_FALSE,

1215: (
1216: p_bo_identifier => l_bo_identifier,
1217: p_api_version_number => 1.0,
1218: p_init_msg_list => l_init_msg_list,
1219: p_commit => FND_API.G_FALSE,
1220: p_eam_wo_rec => l_eam_wo_rec,
1221: p_eam_op_tbl => l_eam_op_tbl,
1222: p_eam_op_network_tbl => l_eam_op_network_tbl,
1223: p_eam_res_tbl => l_eam_res_tbl,

Line 1246: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1242: p_debug_filename => l_debug_filename,
1243: p_debug_file_mode => l_debug_file_mode
1244: );
1245:
1246: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1247: IF ( G_DEBUG = 'Y' ) THEN
1248: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1249: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1250: END IF;

Line 1252: RAISE FND_API.G_EXC_ERROR;

1248: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1249: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1250: END IF;
1251:
1252: RAISE FND_API.G_EXC_ERROR;
1253:
1254: ELSE
1255: -- Perform the Commit (if requested)
1256: IF FND_API.to_boolean( p_commit ) THEN

Line 1256: IF FND_API.to_boolean( p_commit ) THEN

1252: RAISE FND_API.G_EXC_ERROR;
1253:
1254: ELSE
1255: -- Perform the Commit (if requested)
1256: IF FND_API.to_boolean( p_commit ) THEN
1257: COMMIT WORK;
1258: END IF;
1259: END IF;
1260:

Line 1268: WHEN FND_API.G_EXC_ERROR THEN

1264: END IF;
1265:
1266: EXCEPTION
1267:
1268: WHEN FND_API.G_EXC_ERROR THEN
1269: ROLLBACK TO update_job_operations_PVT;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: FND_MSG_PUB.count_and_get
1272: (

Line 1270: x_return_status := FND_API.G_RET_STS_ERROR;

1266: EXCEPTION
1267:
1268: WHEN FND_API.G_EXC_ERROR THEN
1269: ROLLBACK TO update_job_operations_PVT;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: FND_MSG_PUB.count_and_get
1272: (
1273: p_encoded => FND_API.G_FALSE,
1274: p_count => x_msg_count,

Line 1273: p_encoded => FND_API.G_FALSE,

1269: ROLLBACK TO update_job_operations_PVT;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: FND_MSG_PUB.count_and_get
1272: (
1273: p_encoded => FND_API.G_FALSE,
1274: p_count => x_msg_count,
1275: p_data => x_msg_data
1276: );
1277:

Line 1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1278: IF ( G_DEBUG = 'Y' ) THEN
1279: AHL_DEBUG_PUB.disable_debug;
1280: END IF;
1281:
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: ROLLBACK TO update_job_operations_PVT;
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1285: FND_MSG_PUB.count_and_get
1286: (

Line 1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1280: END IF;
1281:
1282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1283: ROLLBACK TO update_job_operations_PVT;
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1285: FND_MSG_PUB.count_and_get
1286: (
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,

Line 1287: p_encoded => FND_API.G_FALSE,

1283: ROLLBACK TO update_job_operations_PVT;
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1285: FND_MSG_PUB.count_and_get
1286: (
1287: p_encoded => FND_API.G_FALSE,
1288: p_count => x_msg_count,
1289: p_data => x_msg_data
1290: );
1291:

Line 1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1294: END IF;
1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO update_job_operations_PVT;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1299: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1300: THEN
1301: FND_MSG_PUB.add_exc_msg
1302: (

Line 1310: p_encoded => FND_API.G_FALSE,

1306: );
1307: END IF;
1308: FND_MSG_PUB.count_and_get
1309: (
1310: p_encoded => FND_API.G_FALSE,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data
1313: );
1314:

Line 1324: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1320:
1321: PROCEDURE process_material_req
1322: (
1323: p_api_version IN NUMBER := 1.0,
1324: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1327: p_default IN VARCHAR2 := FND_API.G_FALSE,
1328: p_module_type IN VARCHAR2 := NULL,

Line 1325: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1321: PROCEDURE process_material_req
1322: (
1323: p_api_version IN NUMBER := 1.0,
1324: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1327: p_default IN VARCHAR2 := FND_API.G_FALSE,
1328: p_module_type IN VARCHAR2 := NULL,
1329: x_return_status OUT NOCOPY VARCHAR2,

Line 1326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1322: (
1323: p_api_version IN NUMBER := 1.0,
1324: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1327: p_default IN VARCHAR2 := FND_API.G_FALSE,
1328: p_module_type IN VARCHAR2 := NULL,
1329: x_return_status OUT NOCOPY VARCHAR2,
1330: x_msg_count OUT NOCOPY NUMBER,

Line 1327: p_default IN VARCHAR2 := FND_API.G_FALSE,

1323: p_api_version IN NUMBER := 1.0,
1324: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1325: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1326: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1327: p_default IN VARCHAR2 := FND_API.G_FALSE,
1328: p_module_type IN VARCHAR2 := NULL,
1329: x_return_status OUT NOCOPY VARCHAR2,
1330: x_msg_count OUT NOCOPY NUMBER,
1331: x_msg_data OUT NOCOPY VARCHAR2,

Line 1374: x_return_status := FND_API.G_RET_STS_SUCCESS;

1370: AHL_DEBUG_PUB.enable_debug;
1371: END IF;
1372:
1373: -- Initialize API return status to success
1374: x_return_status := FND_API.G_RET_STS_SUCCESS;
1375:
1376: -- Standard Start of API savepoint
1377: SAVEPOINT process_material_req_PVT;
1378:

Line 1417: p_commit => FND_API.G_FALSE,

1413: (
1414: p_bo_identifier => l_bo_identifier,
1415: p_api_version_number => 1.0,
1416: p_init_msg_list => l_init_msg_list,
1417: p_commit => FND_API.G_FALSE,
1418: p_eam_wo_rec => l_eam_wo_rec,
1419: p_eam_op_tbl => l_eam_op_tbl,
1420: p_eam_op_network_tbl => l_eam_op_network_tbl,
1421: p_eam_res_tbl => l_eam_res_tbl,

Line 1444: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1440: p_debug_filename => l_debug_filename,
1441: p_debug_file_mode => l_debug_file_mode
1442: );
1443:
1444: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1445: IF ( G_DEBUG = 'Y' ) THEN
1446: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1447: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1448: END IF;

Line 1450: RAISE FND_API.G_EXC_ERROR;

1446: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1447: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1448: END IF;
1449:
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1452:
1453: -- Perform the Commit (if requested)
1454: IF FND_API.to_boolean( p_commit ) THEN

Line 1454: IF FND_API.to_boolean( p_commit ) THEN

1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1452:
1453: -- Perform the Commit (if requested)
1454: IF FND_API.to_boolean( p_commit ) THEN
1455: COMMIT WORK;
1456: END IF;
1457:
1458: -- Disable debug (if enabled)

Line 1465: WHEN FND_API.G_EXC_ERROR THEN

1461: END IF;
1462:
1463: EXCEPTION
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: ROLLBACK TO process_material_req_PVT;
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: FND_MSG_PUB.count_and_get
1469: (

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR;

1463: EXCEPTION
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: ROLLBACK TO process_material_req_PVT;
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: FND_MSG_PUB.count_and_get
1469: (
1470: p_encoded => FND_API.G_FALSE,
1471: p_count => x_msg_count,

Line 1470: p_encoded => FND_API.G_FALSE,

1466: ROLLBACK TO process_material_req_PVT;
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: FND_MSG_PUB.count_and_get
1469: (
1470: p_encoded => FND_API.G_FALSE,
1471: p_count => x_msg_count,
1472: p_data => x_msg_data
1473: );
1474:

Line 1479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1475: IF ( G_DEBUG = 'Y' ) THEN
1476: AHL_DEBUG_PUB.disable_debug;
1477: END IF;
1478:
1479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1480: ROLLBACK TO process_material_req_PVT;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: FND_MSG_PUB.count_and_get
1483: (

Line 1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1477: END IF;
1478:
1479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1480: ROLLBACK TO process_material_req_PVT;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: FND_MSG_PUB.count_and_get
1483: (
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,

Line 1484: p_encoded => FND_API.G_FALSE,

1480: ROLLBACK TO process_material_req_PVT;
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1482: FND_MSG_PUB.count_and_get
1483: (
1484: p_encoded => FND_API.G_FALSE,
1485: p_count => x_msg_count,
1486: p_data => x_msg_data
1487: );
1488:

Line 1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1491: END IF;
1492:
1493: WHEN OTHERS THEN
1494: ROLLBACK TO process_material_req_PVT;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1496: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1497: THEN
1498: FND_MSG_PUB.add_exc_msg
1499: (

Line 1507: p_encoded => FND_API.G_FALSE,

1503: );
1504: END IF;
1505: FND_MSG_PUB.count_and_get
1506: (
1507: p_encoded => FND_API.G_FALSE,
1508: p_count => x_msg_count,
1509: p_data => x_msg_data
1510: );
1511:

Line 1521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1517:
1518: PROCEDURE process_resource_req
1519: (
1520: p_api_version IN NUMBER := 1.0,
1521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1524: p_default IN VARCHAR2 := FND_API.G_FALSE,
1525: p_module_type IN VARCHAR2 := NULL,

Line 1522: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1518: PROCEDURE process_resource_req
1519: (
1520: p_api_version IN NUMBER := 1.0,
1521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1524: p_default IN VARCHAR2 := FND_API.G_FALSE,
1525: p_module_type IN VARCHAR2 := NULL,
1526: x_return_status OUT NOCOPY VARCHAR2,

Line 1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1519: (
1520: p_api_version IN NUMBER := 1.0,
1521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1524: p_default IN VARCHAR2 := FND_API.G_FALSE,
1525: p_module_type IN VARCHAR2 := NULL,
1526: x_return_status OUT NOCOPY VARCHAR2,
1527: x_msg_count OUT NOCOPY NUMBER,

Line 1524: p_default IN VARCHAR2 := FND_API.G_FALSE,

1520: p_api_version IN NUMBER := 1.0,
1521: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1522: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1523: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1524: p_default IN VARCHAR2 := FND_API.G_FALSE,
1525: p_module_type IN VARCHAR2 := NULL,
1526: x_return_status OUT NOCOPY VARCHAR2,
1527: x_msg_count OUT NOCOPY NUMBER,
1528: x_msg_data OUT NOCOPY VARCHAR2,

Line 1580: x_return_status := FND_API.G_RET_STS_SUCCESS;

1576: AHL_DEBUG_PUB.enable_debug;
1577: END IF;
1578:
1579: -- Initialize API return status to success
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1581:
1582: -- Standard Start of API savepoint
1583: SAVEPOINT process_resource_req_PVT;
1584:

Line 1641: p_commit => FND_API.G_FALSE,

1637: (
1638: p_bo_identifier => l_bo_identifier,
1639: p_api_version_number => 1.0,
1640: p_init_msg_list => l_init_msg_list,
1641: p_commit => FND_API.G_FALSE,
1642: p_eam_wo_rec => l_eam_wo_rec,
1643: p_eam_op_tbl => l_eam_op_tbl,
1644: p_eam_op_network_tbl => l_eam_op_network_tbl,
1645: p_eam_res_tbl => l_eam_res_tbl,

Line 1668: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1664: p_debug_filename => l_debug_filename,
1665: p_debug_file_mode => l_debug_file_mode
1666: );
1667:
1668: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1669: IF ( G_DEBUG = 'Y' ) THEN
1670: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1671: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1672: END IF;

Line 1674: RAISE FND_API.G_EXC_ERROR;

1670: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1671: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1672: END IF;
1673:
1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1676:
1677: -- Perform the Commit (if requested)
1678: IF FND_API.to_boolean( p_commit ) THEN

Line 1678: IF FND_API.to_boolean( p_commit ) THEN

1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1676:
1677: -- Perform the Commit (if requested)
1678: IF FND_API.to_boolean( p_commit ) THEN
1679: COMMIT WORK;
1680: END IF;
1681:
1682: -- Disable debug (if enabled)

Line 1689: WHEN FND_API.G_EXC_ERROR THEN

1685: END IF;
1686:
1687: EXCEPTION
1688:
1689: WHEN FND_API.G_EXC_ERROR THEN
1690: ROLLBACK TO process_resource_req_PVT;
1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: FND_MSG_PUB.count_and_get
1693: (

Line 1691: x_return_status := FND_API.G_RET_STS_ERROR;

1687: EXCEPTION
1688:
1689: WHEN FND_API.G_EXC_ERROR THEN
1690: ROLLBACK TO process_resource_req_PVT;
1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: FND_MSG_PUB.count_and_get
1693: (
1694: p_encoded => FND_API.G_FALSE,
1695: p_count => x_msg_count,

Line 1694: p_encoded => FND_API.G_FALSE,

1690: ROLLBACK TO process_resource_req_PVT;
1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: FND_MSG_PUB.count_and_get
1693: (
1694: p_encoded => FND_API.G_FALSE,
1695: p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );
1698:

Line 1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1699: IF ( G_DEBUG = 'Y' ) THEN
1700: AHL_DEBUG_PUB.disable_debug;
1701: END IF;
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO process_resource_req_PVT;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1706: FND_MSG_PUB.count_and_get
1707: (

Line 1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1701: END IF;
1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: ROLLBACK TO process_resource_req_PVT;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1706: FND_MSG_PUB.count_and_get
1707: (
1708: p_encoded => FND_API.G_FALSE,
1709: p_count => x_msg_count,

Line 1708: p_encoded => FND_API.G_FALSE,

1704: ROLLBACK TO process_resource_req_PVT;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1706: FND_MSG_PUB.count_and_get
1707: (
1708: p_encoded => FND_API.G_FALSE,
1709: p_count => x_msg_count,
1710: p_data => x_msg_data
1711: );
1712:

Line 1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1715: END IF;
1716:
1717: WHEN OTHERS THEN
1718: ROLLBACK TO process_resource_req_PVT;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1720: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1721: THEN
1722: FND_MSG_PUB.add_exc_msg
1723: (

Line 1731: p_encoded => FND_API.G_FALSE,

1727: );
1728: END IF;
1729: FND_MSG_PUB.count_and_get
1730: (
1731: p_encoded => FND_API.G_FALSE,
1732: p_count => x_msg_count,
1733: p_data => x_msg_data
1734: );
1735:

Line 1745: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1741:
1742: PROCEDURE process_resource_assign
1743: (
1744: p_api_version IN NUMBER := 1.0,
1745: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1748: p_default IN VARCHAR2 := FND_API.G_FALSE,
1749: p_module_type IN VARCHAR2 := NULL,

Line 1746: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1742: PROCEDURE process_resource_assign
1743: (
1744: p_api_version IN NUMBER := 1.0,
1745: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1748: p_default IN VARCHAR2 := FND_API.G_FALSE,
1749: p_module_type IN VARCHAR2 := NULL,
1750: x_return_status OUT NOCOPY VARCHAR2,

Line 1747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1743: (
1744: p_api_version IN NUMBER := 1.0,
1745: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1748: p_default IN VARCHAR2 := FND_API.G_FALSE,
1749: p_module_type IN VARCHAR2 := NULL,
1750: x_return_status OUT NOCOPY VARCHAR2,
1751: x_msg_count OUT NOCOPY NUMBER,

Line 1748: p_default IN VARCHAR2 := FND_API.G_FALSE,

1744: p_api_version IN NUMBER := 1.0,
1745: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1746: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1747: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1748: p_default IN VARCHAR2 := FND_API.G_FALSE,
1749: p_module_type IN VARCHAR2 := NULL,
1750: x_return_status OUT NOCOPY VARCHAR2,
1751: x_msg_count OUT NOCOPY NUMBER,
1752: x_msg_data OUT NOCOPY VARCHAR2,

Line 1795: x_return_status := FND_API.G_RET_STS_SUCCESS;

1791: AHL_DEBUG_PUB.enable_debug;
1792: END IF;
1793:
1794: -- Initialize API return status to success
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: -- Standard Start of API savepoint
1798: SAVEPOINT process_resource_assign_PVT;
1799:

Line 1838: p_commit => FND_API.G_FALSE,

1834: (
1835: p_bo_identifier => l_bo_identifier,
1836: p_api_version_number => 1.0,
1837: p_init_msg_list => l_init_msg_list,
1838: p_commit => FND_API.G_FALSE,
1839: p_eam_wo_rec => l_eam_wo_rec,
1840: p_eam_op_tbl => l_eam_op_tbl,
1841: p_eam_op_network_tbl => l_eam_op_network_tbl,
1842: p_eam_res_tbl => l_eam_res_tbl,

Line 1865: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1861: p_debug_filename => l_debug_filename,
1862: p_debug_file_mode => l_debug_file_mode
1863: );
1864:
1865: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1866: IF ( G_DEBUG = 'Y' ) THEN
1867: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1868: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1869: END IF;

Line 1871: RAISE FND_API.G_EXC_ERROR;

1867: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
1868: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
1869: END IF;
1870:
1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;
1873:
1874: -- Perform the Commit (if requested)
1875: IF FND_API.to_boolean( p_commit ) THEN

Line 1875: IF FND_API.to_boolean( p_commit ) THEN

1871: RAISE FND_API.G_EXC_ERROR;
1872: END IF;
1873:
1874: -- Perform the Commit (if requested)
1875: IF FND_API.to_boolean( p_commit ) THEN
1876: COMMIT WORK;
1877: END IF;
1878:
1879: -- Disable debug (if enabled)

Line 1886: WHEN FND_API.G_EXC_ERROR THEN

1882: END IF;
1883:
1884: EXCEPTION
1885:
1886: WHEN FND_API.G_EXC_ERROR THEN
1887: ROLLBACK TO process_resource_assign_PVT;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: FND_MSG_PUB.count_and_get
1890: (

Line 1888: x_return_status := FND_API.G_RET_STS_ERROR;

1884: EXCEPTION
1885:
1886: WHEN FND_API.G_EXC_ERROR THEN
1887: ROLLBACK TO process_resource_assign_PVT;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: FND_MSG_PUB.count_and_get
1890: (
1891: p_encoded => FND_API.G_FALSE,
1892: p_count => x_msg_count,

Line 1891: p_encoded => FND_API.G_FALSE,

1887: ROLLBACK TO process_resource_assign_PVT;
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: FND_MSG_PUB.count_and_get
1890: (
1891: p_encoded => FND_API.G_FALSE,
1892: p_count => x_msg_count,
1893: p_data => x_msg_data
1894: );
1895:

Line 1900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1896: IF ( G_DEBUG = 'Y' ) THEN
1897: AHL_DEBUG_PUB.disable_debug;
1898: END IF;
1899:
1900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1901: ROLLBACK TO process_resource_assign_PVT;
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1903: FND_MSG_PUB.count_and_get
1904: (

Line 1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1898: END IF;
1899:
1900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1901: ROLLBACK TO process_resource_assign_PVT;
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1903: FND_MSG_PUB.count_and_get
1904: (
1905: p_encoded => FND_API.G_FALSE,
1906: p_count => x_msg_count,

Line 1905: p_encoded => FND_API.G_FALSE,

1901: ROLLBACK TO process_resource_assign_PVT;
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1903: FND_MSG_PUB.count_and_get
1904: (
1905: p_encoded => FND_API.G_FALSE,
1906: p_count => x_msg_count,
1907: p_data => x_msg_data
1908: );
1909:

Line 1916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1912: END IF;
1913:
1914: WHEN OTHERS THEN
1915: ROLLBACK TO process_resource_assign_PVT;
1916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1917: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1918: THEN
1919: FND_MSG_PUB.add_exc_msg
1920: (

Line 1928: p_encoded => FND_API.G_FALSE,

1924: );
1925: END IF;
1926: FND_MSG_PUB.count_and_get
1927: (
1928: p_encoded => FND_API.G_FALSE,
1929: p_count => x_msg_count,
1930: p_data => x_msg_data
1931: );
1932:

Line 1942: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1938:
1939: PROCEDURE process_eam_workorders
1940: (
1941: p_api_version IN NUMBER := 1.0,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: p_default IN VARCHAR2 := FND_API.G_FALSE,
1946: p_module_type IN VARCHAR2 := NULL,

Line 1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1939: PROCEDURE process_eam_workorders
1940: (
1941: p_api_version IN NUMBER := 1.0,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: p_default IN VARCHAR2 := FND_API.G_FALSE,
1946: p_module_type IN VARCHAR2 := NULL,
1947: x_return_status OUT NOCOPY VARCHAR2,

Line 1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1940: (
1941: p_api_version IN NUMBER := 1.0,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: p_default IN VARCHAR2 := FND_API.G_FALSE,
1946: p_module_type IN VARCHAR2 := NULL,
1947: x_return_status OUT NOCOPY VARCHAR2,
1948: x_msg_count OUT NOCOPY NUMBER,

Line 1945: p_default IN VARCHAR2 := FND_API.G_FALSE,

1941: p_api_version IN NUMBER := 1.0,
1942: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1943: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945: p_default IN VARCHAR2 := FND_API.G_FALSE,
1946: p_module_type IN VARCHAR2 := NULL,
1947: x_return_status OUT NOCOPY VARCHAR2,
1948: x_msg_count OUT NOCOPY NUMBER,
1949: x_msg_data OUT NOCOPY VARCHAR2,

Line 1991: x_return_status := FND_API.G_RET_STS_SUCCESS;

1987: AHL_DEBUG_PUB.enable_debug;
1988: END IF;
1989:
1990: -- Initialize API return status to success
1991: x_return_status := FND_API.G_RET_STS_SUCCESS;
1992:
1993: -- Standard Start of API savepoint
1994: SAVEPOINT process_eam_workorders_PVT;
1995:

Line 2065: p_commit => FND_API.G_FALSE,

2061: x_eam_mat_req_tbl => l_out_eam_mat_req_tbl,
2062: x_eam_direct_items_tbl => l_out_eam_direct_items_tbl,
2063: x_return_status => l_return_status,
2064: x_msg_count => l_msg_count,
2065: p_commit => FND_API.G_FALSE,
2066: p_debug => l_debug,
2067: p_output_dir => l_output_dir,
2068: p_debug_filename => l_debug_filename,
2069: p_debug_file_mode => l_debug_file_mode

Line 2072: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2068: p_debug_filename => l_debug_filename,
2069: p_debug_file_mode => l_debug_file_mode
2070: );
2071:
2072: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2073: IF ( G_DEBUG = 'Y' ) THEN
2074: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2075: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2076: END IF;

Line 2078: RAISE FND_API.G_EXC_ERROR;

2074: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2075: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2076: END IF;
2077:
2078: RAISE FND_API.G_EXC_ERROR;
2079:
2080: ELSE
2081: --Change made on Nov 17, 2005 by jeli due to bug 4742895.
2082: --Ignore messages in stack if return status is S after calls to EAM APIs.

Line 2113: RAISE FND_API.G_EXC_ERROR;

2109: END LOOP;
2110:
2111: l_msg_count := FND_MSG_PUB.count_msg;
2112: IF l_msg_count > 0 THEN
2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115:
2116: -- Perform the Commit (if requested)
2117: IF FND_API.to_boolean( p_commit ) THEN

Line 2117: IF FND_API.to_boolean( p_commit ) THEN

2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115:
2116: -- Perform the Commit (if requested)
2117: IF FND_API.to_boolean( p_commit ) THEN
2118: COMMIT WORK;
2119: END IF;
2120: END IF;
2121:

Line 2129: WHEN FND_API.G_EXC_ERROR THEN

2125: END IF;
2126:
2127: EXCEPTION
2128:
2129: WHEN FND_API.G_EXC_ERROR THEN
2130: ROLLBACK TO process_eam_workorders_PVT;
2131: x_return_status := FND_API.G_RET_STS_ERROR;
2132: FND_MSG_PUB.count_and_get
2133: (

Line 2131: x_return_status := FND_API.G_RET_STS_ERROR;

2127: EXCEPTION
2128:
2129: WHEN FND_API.G_EXC_ERROR THEN
2130: ROLLBACK TO process_eam_workorders_PVT;
2131: x_return_status := FND_API.G_RET_STS_ERROR;
2132: FND_MSG_PUB.count_and_get
2133: (
2134: p_encoded => FND_API.G_FALSE,
2135: p_count => x_msg_count,

Line 2134: p_encoded => FND_API.G_FALSE,

2130: ROLLBACK TO process_eam_workorders_PVT;
2131: x_return_status := FND_API.G_RET_STS_ERROR;
2132: FND_MSG_PUB.count_and_get
2133: (
2134: p_encoded => FND_API.G_FALSE,
2135: p_count => x_msg_count,
2136: p_data => x_msg_data
2137: );
2138:

Line 2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2139: IF ( G_DEBUG = 'Y' ) THEN
2140: AHL_DEBUG_PUB.disable_debug;
2141: END IF;
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2144: ROLLBACK TO process_eam_workorders_PVT;
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2146: FND_MSG_PUB.count_and_get
2147: (

Line 2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2141: END IF;
2142:
2143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2144: ROLLBACK TO process_eam_workorders_PVT;
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2146: FND_MSG_PUB.count_and_get
2147: (
2148: p_encoded => FND_API.G_FALSE,
2149: p_count => x_msg_count,

Line 2148: p_encoded => FND_API.G_FALSE,

2144: ROLLBACK TO process_eam_workorders_PVT;
2145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2146: FND_MSG_PUB.count_and_get
2147: (
2148: p_encoded => FND_API.G_FALSE,
2149: p_count => x_msg_count,
2150: p_data => x_msg_data
2151: );
2152:

Line 2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2155: END IF;
2156:
2157: WHEN OTHERS THEN
2158: ROLLBACK TO process_eam_workorders_PVT;
2159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2160: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2161: THEN
2162: FND_MSG_PUB.add_exc_msg
2163: (

Line 2171: p_encoded => FND_API.G_FALSE,

2167: );
2168: END IF;
2169: FND_MSG_PUB.count_and_get
2170: (
2171: p_encoded => FND_API.G_FALSE,
2172: p_count => x_msg_count,
2173: p_data => x_msg_data
2174: );
2175:

Line 2185: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2181: --pekambar added new procedure for ER # 9410221 -- start
2182: PROCEDURE move_workorder
2183: (
2184: p_api_version IN NUMBER := 1.0,
2185: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2188: p_default IN VARCHAR2 := FND_API.G_FALSE,
2189: p_module_type IN VARCHAR2 := NULL,

Line 2186: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2182: PROCEDURE move_workorder
2183: (
2184: p_api_version IN NUMBER := 1.0,
2185: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2188: p_default IN VARCHAR2 := FND_API.G_FALSE,
2189: p_module_type IN VARCHAR2 := NULL,
2190: x_return_status OUT NOCOPY VARCHAR2,

Line 2187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2183: (
2184: p_api_version IN NUMBER := 1.0,
2185: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2188: p_default IN VARCHAR2 := FND_API.G_FALSE,
2189: p_module_type IN VARCHAR2 := NULL,
2190: x_return_status OUT NOCOPY VARCHAR2,
2191: x_msg_count OUT NOCOPY NUMBER,

Line 2188: p_default IN VARCHAR2 := FND_API.G_FALSE,

2184: p_api_version IN NUMBER := 1.0,
2185: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2186: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2187: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2188: p_default IN VARCHAR2 := FND_API.G_FALSE,
2189: p_module_type IN VARCHAR2 := NULL,
2190: x_return_status OUT NOCOPY VARCHAR2,
2191: x_msg_count OUT NOCOPY NUMBER,
2192: x_msg_data OUT NOCOPY VARCHAR2,

Line 2225: x_return_status := FND_API.G_RET_STS_SUCCESS;

2221: AHL_DEBUG_PUB.enable_debug;
2222: END IF;
2223:
2224: -- Initialize API return status to success
2225: x_return_status := FND_API.G_RET_STS_SUCCESS;
2226:
2227: -- Standard Start of API savepoint
2228: SAVEPOINT move_workorder_PVT;
2229:

Line 2273: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

2269: IF ( G_DEBUG = 'Y' ) THEN
2270: AHL_DEBUG_PUB.debug('After call to EAM_WO_NETWORK_UTIL_PVT.Move_WO: ');
2271: END IF;
2272:
2273: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2274: IF ( G_DEBUG = 'Y' ) THEN
2275: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2276: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2277: END IF;

Line 2279: RAISE FND_API.G_EXC_ERROR;

2275: AHL_DEBUG_PUB.debug( 'Error Count from EAM API : ' || l_msg_count );
2276: AHL_DEBUG_PUB.debug( 'Error Count from Error Stack : ' || FND_MSG_PUB.count_msg );
2277: END IF;
2278:
2279: RAISE FND_API.G_EXC_ERROR;
2280:
2281: ELSE
2282: -- Perform the Commit (if requested)
2283: IF FND_API.to_boolean( p_commit ) THEN

Line 2283: IF FND_API.to_boolean( p_commit ) THEN

2279: RAISE FND_API.G_EXC_ERROR;
2280:
2281: ELSE
2282: -- Perform the Commit (if requested)
2283: IF FND_API.to_boolean( p_commit ) THEN
2284: COMMIT WORK;
2285: END IF;
2286: END IF;
2287:

Line 2295: WHEN FND_API.G_EXC_ERROR THEN

2291: END IF;
2292:
2293: EXCEPTION
2294:
2295: WHEN FND_API.G_EXC_ERROR THEN
2296: ROLLBACK TO move_workorder_PVT;
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: FND_MSG_PUB.count_and_get
2299: (

Line 2297: x_return_status := FND_API.G_RET_STS_ERROR;

2293: EXCEPTION
2294:
2295: WHEN FND_API.G_EXC_ERROR THEN
2296: ROLLBACK TO move_workorder_PVT;
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: FND_MSG_PUB.count_and_get
2299: (
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,

Line 2300: p_encoded => FND_API.G_FALSE,

2296: ROLLBACK TO move_workorder_PVT;
2297: x_return_status := FND_API.G_RET_STS_ERROR;
2298: FND_MSG_PUB.count_and_get
2299: (
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data
2303: );
2304:

Line 2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2305: IF ( G_DEBUG = 'Y' ) THEN
2306: AHL_DEBUG_PUB.disable_debug;
2307: END IF;
2308:
2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310: ROLLBACK TO move_workorder_PVT;
2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2312: FND_MSG_PUB.count_and_get
2313: (

Line 2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2307: END IF;
2308:
2309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2310: ROLLBACK TO move_workorder_PVT;
2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2312: FND_MSG_PUB.count_and_get
2313: (
2314: p_encoded => FND_API.G_FALSE,
2315: p_count => x_msg_count,

Line 2314: p_encoded => FND_API.G_FALSE,

2310: ROLLBACK TO move_workorder_PVT;
2311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2312: FND_MSG_PUB.count_and_get
2313: (
2314: p_encoded => FND_API.G_FALSE,
2315: p_count => x_msg_count,
2316: p_data => x_msg_data
2317: );
2318:

Line 2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2321: END IF;
2322:
2323: WHEN OTHERS THEN
2324: ROLLBACK TO move_workorder_PVT;
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2326: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2327: THEN
2328: FND_MSG_PUB.add_exc_msg
2329: (

Line 2337: p_encoded => FND_API.G_FALSE,

2333: );
2334: END IF;
2335: FND_MSG_PUB.count_and_get
2336: (
2337: p_encoded => FND_API.G_FALSE,
2338: p_count => x_msg_count,
2339: p_data => x_msg_data
2340: );
2341: