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

Line 96: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

92: -- Procedure to generate XML data for workorder(s).
93: ------------------------------------------------------------------------------------------------
94: PROCEDURE Gen_Wo_Xml(
95: p_api_version IN NUMBER :=1.0,
96: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
97: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
98: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
99: p_default IN VARCHAR2 :=FND_API.G_FALSE,
100: p_module_type IN VARCHAR2 :=NULL,

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

93: ------------------------------------------------------------------------------------------------
94: PROCEDURE Gen_Wo_Xml(
95: p_api_version IN NUMBER :=1.0,
96: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
97: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
98: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
99: p_default IN VARCHAR2 :=FND_API.G_FALSE,
100: p_module_type IN VARCHAR2 :=NULL,
101: x_return_status OUT NOCOPY VARCHAR2,

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

94: PROCEDURE Gen_Wo_Xml(
95: p_api_version IN NUMBER :=1.0,
96: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
97: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
98: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
99: p_default IN VARCHAR2 :=FND_API.G_FALSE,
100: p_module_type IN VARCHAR2 :=NULL,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,

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

95: p_api_version IN NUMBER :=1.0,
96: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
97: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
98: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
99: p_default IN VARCHAR2 :=FND_API.G_FALSE,
100: p_module_type IN VARCHAR2 :=NULL,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,

Line 477: x_return_status:= FND_API.G_RET_STS_SUCCESS;

473: );
474: END IF;
475:
476: -- Initialize return status to success initially
477: x_return_status:= FND_API.G_RET_STS_SUCCESS;
478:
479: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
480: p_api_version,
481: l_api_name,G_PKG_NAME)

Line 479: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

475:
476: -- Initialize return status to success initially
477: x_return_status:= FND_API.G_RET_STS_SUCCESS;
478:
479: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
480: p_api_version,
481: l_api_name,G_PKG_NAME)
482: THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
480: p_api_version,
481: l_api_name,G_PKG_NAME)
482: THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 487: IF FND_API.to_boolean(p_init_msg_list) THEN

483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_boolean(p_init_msg_list) THEN
488: FND_MSG_PUB.initialize;
489: END IF;
490:
491: -- Open a temporary lob for merging the contents.

Line 886: P_init_msg_list => FND_API.G_FALSE,

882: --resource transaction details for the operation as follows.
883:
884: AHL_PRD_RESOURCE_TRANX_PVT.Get_Resource_Txn_Defaults(
885: P_api_version => 1.0,
886: P_init_msg_list => FND_API.G_FALSE,
887: p_module_type => null,
888: x_return_status => x_return_status,
889: x_msg_count => x_msg_count,
890: x_msg_data => x_msg_data,

Line 1063: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

1059:
1060: EXCEPTION
1061: WHEN OTHERS THEN
1062:
1063: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1064:
1065: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1066: fnd_log.string
1067: (

Line 1080: p_encoded => Fnd_Api.g_false,

1076: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1077: END IF;
1078:
1079: Fnd_Msg_Pub.count_and_get (
1080: p_encoded => Fnd_Api.g_false,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1084:

Line 1152: l_item_found := FND_API.G_TRUE;

1148:
1149: l_dummy_query := l_dummy_query ||' ,XMLConcat(XMLELEMENT("LABEL", '''|| null ||''' )';
1150: l_dummy_query := l_dummy_query || ', XMLELEMENT("VALUE", '''|| null ||''' ) ) COLL_ELEMENT';
1151:
1152: l_item_found := FND_API.G_TRUE;
1153: l_item_hardcoded_column := qa_csr.hardcoded_column;
1154: --l_column_name_tbl(l_rec_count) := result_column;
1155: ELSIF qa_csr.char_id = G_LOCATOR_CHAR THEN
1156:

Line 1163: l_locator_found := FND_API.G_TRUE;

1159:
1160: l_dummy_query := l_dummy_query ||' ,XMLConcat(XMLELEMENT("LABEL", '''|| null ||''' )';
1161: l_dummy_query := l_dummy_query || ', XMLELEMENT("VALUE", '''|| null ||''' ) ) COLL_ELEMENT';
1162:
1163: l_locator_found := FND_API.G_TRUE;
1164: l_locator_hardcoded_column := qa_csr.hardcoded_column;
1165: --l_column_name_tbl(l_rec_count) := result_column;
1166: ELSE
1167: IF qa_csr.hardcoded_column IS NOT NULL

Line 1191: IF l_item_found = FND_API.G_TRUE THEN

1187: -- Results will all be included in the from clause
1188: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
1189:
1190: -- Append required FROM clauses for the API.
1191: IF l_item_found = FND_API.G_TRUE THEN
1192: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
1193: END IF;
1194:
1195: IF l_locator_found = FND_API.G_TRUE THEN

Line 1195: IF l_locator_found = FND_API.G_TRUE THEN

1191: IF l_item_found = FND_API.G_TRUE THEN
1192: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
1193: END IF;
1194:
1195: IF l_locator_found = FND_API.G_TRUE THEN
1196: l_query_string := l_query_string || ' , MTL_ITEM_LOCATIONS_KFV LOCATOR ';
1197: END IF;
1198:
1199: -- Append collection id to the where clause

Line 1203: IF l_item_found = FND_API.G_TRUE THEN

1199: -- Append collection id to the where clause
1200: l_query_string := l_query_string || ' WHERE RESULTS.COLLECTION_ID = ' || p_collection_id;
1201:
1202: -- Append required FROM clauses for the API.
1203: IF l_item_found = FND_API.G_TRUE THEN
1204: l_query_string := l_query_string || ' AND ITEM.inventory_item_id (+) = RESULTS.' || l_item_hardcoded_column;
1205: l_query_string := l_query_string || ' AND ITEM.organization_id (+) = RESULTS.organization_id ';
1206: END IF;
1207:

Line 1208: IF l_locator_found = FND_API.G_TRUE THEN

1204: l_query_string := l_query_string || ' AND ITEM.inventory_item_id (+) = RESULTS.' || l_item_hardcoded_column;
1205: l_query_string := l_query_string || ' AND ITEM.organization_id (+) = RESULTS.organization_id ';
1206: END IF;
1207:
1208: IF l_locator_found = FND_API.G_TRUE THEN
1209: l_query_string := l_query_string || ' AND LOCATOR.inventory_location_id (+) = RESULTS.' || l_locator_hardcoded_column;
1210: l_query_string := l_query_string || ' AND LOCATOR.organization_id (+) = RESULTS.organization_id ';
1211: END IF;
1212:

Line 1357: p_init_msg_list => FND_API.G_TRUE,

1353: IF l_workorder_tbl.COUNT > 0
1354: THEN
1355: Gen_Wo_Xml(
1356: p_api_version => 1.0,
1357: p_init_msg_list => FND_API.G_TRUE,
1358: p_commit => FND_API.G_TRUE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: p_default => FND_API.G_TRUE,
1361: p_module_type => NULL,

Line 1358: p_commit => FND_API.G_TRUE,

1354: THEN
1355: Gen_Wo_Xml(
1356: p_api_version => 1.0,
1357: p_init_msg_list => FND_API.G_TRUE,
1358: p_commit => FND_API.G_TRUE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: p_default => FND_API.G_TRUE,
1361: p_module_type => NULL,
1362: x_return_status => l_return_status,

Line 1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1355: Gen_Wo_Xml(
1356: p_api_version => 1.0,
1357: p_init_msg_list => FND_API.G_TRUE,
1358: p_commit => FND_API.G_TRUE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: p_default => FND_API.G_TRUE,
1361: p_module_type => NULL,
1362: x_return_status => l_return_status,
1363: x_msg_count => l_msg_count,

Line 1360: p_default => FND_API.G_TRUE,

1356: p_api_version => 1.0,
1357: p_init_msg_list => FND_API.G_TRUE,
1358: p_commit => FND_API.G_TRUE,
1359: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1360: p_default => FND_API.G_TRUE,
1361: p_module_type => NULL,
1362: x_return_status => l_return_status,
1363: x_msg_count => l_msg_count,
1364: x_msg_data => errbuf,

Line 1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

1380: l_offset := l_offset + l_chunk_size;
1381: END LOOP;
1382:
1383: l_msg_count := FND_MSG_PUB.Count_Msg;
1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1385: THEN
1386: retcode := 2; -- error based only on return status
1387: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)
1388: THEN

Line 1387: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)

1383: l_msg_count := FND_MSG_PUB.Count_Msg;
1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1385: THEN
1386: retcode := 2; -- error based only on return status
1387: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)
1388: THEN
1389: retcode := 1; -- warning based on return status + msg count
1390: ELSE
1391: --fnd_file.put_line(fnd_file.output, dbms_lob.substr(l_clob, dbms_lob.getlength(l_clob), 1));

Line 1410: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

1406: END Gen_Workcard_Xml;
1407:
1408: PROCEDURE Process_JCG_Request (
1409: p_api_version IN NUMBER :=1.0,
1410: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1412: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1413: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1414: p_module_type IN VARCHAR2 :=NULL,

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

1407:
1408: PROCEDURE Process_JCG_Request (
1409: p_api_version IN NUMBER :=1.0,
1410: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1412: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1413: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1414: p_module_type IN VARCHAR2 :=NULL,
1415: x_return_status OUT NOCOPY VARCHAR2,

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

1408: PROCEDURE Process_JCG_Request (
1409: p_api_version IN NUMBER :=1.0,
1410: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1412: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1413: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1414: p_module_type IN VARCHAR2 :=NULL,
1415: x_return_status OUT NOCOPY VARCHAR2,
1416: x_msg_count OUT NOCOPY NUMBER,

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

1409: p_api_version IN NUMBER :=1.0,
1410: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1411: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1412: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1413: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1414: p_module_type IN VARCHAR2 :=NULL,
1415: x_return_status OUT NOCOPY VARCHAR2,
1416: x_msg_count OUT NOCOPY NUMBER,
1417: x_msg_data OUT NOCOPY VARCHAR2,

Line 1487: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

1483:
1484: -- Standard start of API savepoint
1485: SAVEPOINT Process_JCG_Request_PVT;
1486:
1487: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1488:
1489: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1490: p_api_version,
1491: l_api_name,G_PKG_NAME)

Line 1489: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1485: SAVEPOINT Process_JCG_Request_PVT;
1486:
1487: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1488:
1489: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1490: p_api_version,
1491: l_api_name,G_PKG_NAME)
1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1489: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1490: p_api_version,
1491: l_api_name,G_PKG_NAME)
1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:
1496: -- Initialize message list if p_init_msg_list is set to TRUE.
1497: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1497: IF FND_API.to_boolean(p_init_msg_list) THEN

1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:
1496: -- Initialize message list if p_init_msg_list is set to TRUE.
1497: IF FND_API.to_boolean(p_init_msg_list) THEN
1498: FND_MSG_PUB.initialize;
1499: END IF;
1500:
1501: IF (l_log_statement >= l_log_current_level)THEN

Line 1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1509: -- Baisc Validation
1510: IF(p_operation_flag IS NULL) THEN
1511: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_DML_FLAG_NULL');
1512: FND_MSG_PUB.ADD;
1513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1514: END IF;
1515:
1516: IF (p_status_code IS NULL) THEN
1517:

Line 1528: RAISE FND_API.G_EXC_ERROR;

1524: END IF;
1525:
1526: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_STATUS_CODE_NULL');
1527: FND_MSG_PUB.ADD;
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;
1530:
1531: IF (p_operation_flag = 'C') THEN
1532:

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532:
1533: IF (p_object_type IS NULL) THEN
1534: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_OBJECT_TYPE_NULL');
1535: FND_MSG_PUB.ADD;
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;
1538: IF (p_object_id IS NULL) THEN
1539: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_OBJECT_ID_NULL');
1540: FND_MSG_PUB.ADD;

Line 1541: RAISE FND_API.G_EXC_ERROR;

1537: END IF;
1538: IF (p_object_id IS NULL) THEN
1539: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_OBJECT_ID_NULL');
1540: FND_MSG_PUB.ADD;
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543:
1544: ELSIF (p_operation_flag = 'U') THEN
1545:

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545:
1546: IF (p_x_jcg_id IS NULL) THEN
1547: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_ID_NULL');
1548: FND_MSG_PUB.ADD;
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551:
1552: IF (p_file_location IS NULL AND (p_status_code = 'S' OR p_status_code = 'Complete' )) THEN
1553: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_FILE_LOC_NULL');

Line 1555: RAISE FND_API.G_EXC_ERROR;

1551:
1552: IF (p_file_location IS NULL AND (p_status_code = 'S' OR p_status_code = 'Complete' )) THEN
1553: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_FILE_LOC_NULL');
1554: FND_MSG_PUB.ADD;
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: END IF;
1559:

Line 1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1650: /*
1651: FND_MESSAGE.Set_Name('AHL','AHL_PRD_JCG_ID_INVALID');
1652: FND_MSG_PUB.ADD;
1653: CLOSE get_jcg_req_rec_csr;
1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: */
1656: END IF;
1657:
1658:

Line 1716: WHEN FND_API.G_EXC_ERROR THEN

1712: );
1713: END IF;
1714:
1715: EXCEPTION
1716: WHEN FND_API.G_EXC_ERROR THEN
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: Rollback to Process_JCG_Request_PVT;
1719: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1720: p_data => x_msg_data,

Line 1717: x_return_status := FND_API.G_RET_STS_ERROR;

1713: END IF;
1714:
1715: EXCEPTION
1716: WHEN FND_API.G_EXC_ERROR THEN
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: Rollback to Process_JCG_Request_PVT;
1719: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1720: p_data => x_msg_data,
1721: p_encoded => fnd_api.g_false);

Line 1721: p_encoded => fnd_api.g_false);

1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: Rollback to Process_JCG_Request_PVT;
1719: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1720: p_data => x_msg_data,
1721: p_encoded => fnd_api.g_false);
1722:
1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1724: IF (l_log_statement >= l_log_current_level)THEN
1725: fnd_log.string(

Line 1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1719: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1720: p_data => x_msg_data,
1721: p_encoded => fnd_api.g_false);
1722:
1723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1724: IF (l_log_statement >= l_log_current_level)THEN
1725: fnd_log.string(
1726: l_log_statement,
1727: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1727: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
1728: 'unExpected Error-'
1729: );
1730: END IF;
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: Rollback to Process_JCG_Request_PVT;
1733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1734: p_data => x_msg_data,
1735: p_encoded => fnd_api.g_false);

Line 1735: p_encoded => fnd_api.g_false);

1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732: Rollback to Process_JCG_Request_PVT;
1733: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1734: p_data => x_msg_data,
1735: p_encoded => fnd_api.g_false);
1736:
1737: WHEN OTHERS THEN
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: Rollback to Process_JCG_Request_PVT;

Line 1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1734: p_data => x_msg_data,
1735: p_encoded => fnd_api.g_false);
1736:
1737: WHEN OTHERS THEN
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: Rollback to Process_JCG_Request_PVT;
1740: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1741: p_procedure_name => 'Process_JCG_Request',
1742: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1745: p_encoded => fnd_api.g_false);

1741: p_procedure_name => 'Process_JCG_Request',
1742: p_error_text => SUBSTR(SQLERRM,1,240));
1743: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1744: p_data => x_msg_data,
1745: p_encoded => fnd_api.g_false);
1746: IF (l_log_unexpected >= l_log_current_level)THEN
1747: fnd_log.string(
1748: l_log_unexpected,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 1903: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

1899: --apattark added for generating xml
1900:
1901: PROCEDURE Generate_JCG_XML
1902: (p_api_version IN NUMBER :=1.0,
1903: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1904: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1905: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1906: p_object_type IN VARCHAR2,
1907: p_object_id IN NUMBER,

Line 1904: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,

1900:
1901: PROCEDURE Generate_JCG_XML
1902: (p_api_version IN NUMBER :=1.0,
1903: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1904: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1905: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1906: p_object_type IN VARCHAR2,
1907: p_object_id IN NUMBER,
1908: p_split_flag IN VARCHAR2,

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

1901: PROCEDURE Generate_JCG_XML
1902: (p_api_version IN NUMBER :=1.0,
1903: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1904: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1905: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1906: p_object_type IN VARCHAR2,
1907: p_object_id IN NUMBER,
1908: p_split_flag IN VARCHAR2,
1909: x_return_status OUT NOCOPY VARCHAR2,

Line 3039: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

3035:
3036: Begin
3037:
3038: SAVEPOINT Generate_JCG_XML_PVT;
3039: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3040: -- initialize log levels
3041: l_log_unexpected := FND_LOG.level_unexpected;
3042: l_log_statement := FND_LOG.level_statement;
3043: l_log_current_level := FND_LOG.g_current_runtime_level;

Line 3064: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3060: p_split_flag => p_split_flag,
3061: x_msg_count => l_msg_count,
3062: x_msg_data => l_msg_data,
3063: x_return_status => l_return_status);
3064: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;

Line 3065: RAISE FND_API.G_EXC_ERROR;

3061: x_msg_count => l_msg_count,
3062: x_msg_data => l_msg_data,
3063: x_return_status => l_return_status);
3064: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069: END IF;

Line 3066: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3062: x_msg_data => l_msg_data,
3063: x_return_status => l_return_status);
3064: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069: END IF;
3070:

Line 3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3063: x_return_status => l_return_status);
3064: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3065: RAISE FND_API.G_EXC_ERROR;
3066: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069: END IF;
3070:
3071: p_dir := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH');

Line 3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3089: FROM ahl_workorders
3090: WHERE workorder_id = l_wo_id_tbl(1);
3091: EXCEPTION
3092: WHEN OTHERS THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: END;
3095:
3096: ELSIF (p_object_type = 'VST') THEN
3097: l_visit_id := p_object_id;

Line 3136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3132: END IF;
3133:
3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3137: END;
3138:
3139: END IF;
3140:

Line 3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3204: AND WO.workorder_id = l_wo_id_tbl(1);
3205:
3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: END;
3210: END IF;
3211:
3212: IF (l_ue_id_tbl.COUNT <> 0) THEN

Line 3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3673: AND VST.VISIT_ID = p_object_id;
3674:
3675: EXCEPTION
3676: WHEN OTHERS THEN
3677: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3678: END;
3679:
3680: ELSIF (p_object_type = 'WO') THEN
3681: l_wo_id := p_object_id;

Line 3883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3879: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3880: 'p_jcg_wrkpkg_location:x_jcg_wrkpkg_file:' || p_dir || ':' || x_file_name);
3881: END IF;
3882:
3883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3884: RAISE FND_API.G_EXC_ERROR;
3885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: END IF;

Line 3884: RAISE FND_API.G_EXC_ERROR;

3880: 'p_jcg_wrkpkg_location:x_jcg_wrkpkg_file:' || p_dir || ':' || x_file_name);
3881: END IF;
3882:
3883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3884: RAISE FND_API.G_EXC_ERROR;
3885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: END IF;
3888:

Line 3885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3881: END IF;
3882:
3883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3884: RAISE FND_API.G_EXC_ERROR;
3885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: END IF;
3888:
3889: IF (x_file_name IS NULL) THEN

Line 3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3882:
3883: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3884: RAISE FND_API.G_EXC_ERROR;
3885: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: END IF;
3888:
3889: IF (x_file_name IS NULL) THEN
3890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3887: END IF;
3888:
3889: IF (x_file_name IS NULL) THEN
3890: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3891: END IF;
3892:
3893: ELSE
3894: -- user hook is not enabled .. apply transformation and write file

Line 3917: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

3913: fnd_log.string (
3914: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3915: 'Applied transformation - l_msg_data : ' || l_msg_data);
3916: END IF;
3917: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: END IF;

Line 3918: RAISE FND_API.G_EXC_ERROR;

3914: l_log_statement, 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3915: 'Applied transformation - l_msg_data : ' || l_msg_data);
3916: END IF;
3917: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: END IF;
3922:

Line 3919: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3915: 'Applied transformation - l_msg_data : ' || l_msg_data);
3916: END IF;
3917: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: END IF;
3922:
3923: END IF;

Line 3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3916: END IF;
3917: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3918: RAISE FND_API.G_EXC_ERROR;
3919: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3921: END IF;
3922:
3923: END IF;
3924:

Line 3927: WHEN FND_API.G_EXC_ERROR THEN

3923: END IF;
3924:
3925: /*
3926: EXCEPTION
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: Rollback to Generate_JCG_XML_PVT;
3930: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3931: p_data => x_msg_data,

Line 3928: x_return_status := FND_API.G_RET_STS_ERROR;

3924:
3925: /*
3926: EXCEPTION
3927: WHEN FND_API.G_EXC_ERROR THEN
3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: Rollback to Generate_JCG_XML_PVT;
3930: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3931: p_data => x_msg_data,
3932: p_encoded => fnd_api.g_false);

Line 3932: p_encoded => fnd_api.g_false);

3928: x_return_status := FND_API.G_RET_STS_ERROR;
3929: Rollback to Generate_JCG_XML_PVT;
3930: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3931: p_data => x_msg_data,
3932: p_encoded => fnd_api.g_false);
3933: IF (l_log_unexpected >= l_log_current_level)THEN
3934: fnd_log.string(
3935: l_log_unexpected,
3936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3936: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
3937: 'Standard Error : x_msg_count : '|| x_msg_count || ': x_msg_data : ' || x_msg_data
3938: );
3939: END IF;
3940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3942: Rollback to Generate_JCG_XML_PVT;
3943: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3944: p_data => x_msg_data,

Line 3941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3937: 'Standard Error : x_msg_count : '|| x_msg_count || ': x_msg_data : ' || x_msg_data
3938: );
3939: END IF;
3940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3942: Rollback to Generate_JCG_XML_PVT;
3943: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3944: p_data => x_msg_data,
3945: p_encoded => fnd_api.g_false);

Line 3945: p_encoded => fnd_api.g_false);

3941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3942: Rollback to Generate_JCG_XML_PVT;
3943: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3944: p_data => x_msg_data,
3945: p_encoded => fnd_api.g_false);
3946: IF (l_log_unexpected >= l_log_current_level)THEN
3947: fnd_log.string(
3948: l_log_unexpected,
3949: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 3955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3951: );
3952: END IF;
3953:
3954: WHEN OTHERS THEN
3955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3956: Rollback to Generate_JCG_XML_PVT;
3957: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
3958: p_procedure_name => 'Generate_JCG_XML',
3959: p_error_text => SUBSTR(SQLERRM,1,240));

Line 3962: p_encoded => fnd_api.g_false);

3958: p_procedure_name => 'Generate_JCG_XML',
3959: p_error_text => SUBSTR(SQLERRM,1,240));
3960: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3961: p_data => x_msg_data,
3962: p_encoded => fnd_api.g_false);
3963: IF (l_log_unexpected >= l_log_current_level)THEN
3964: fnd_log.string(
3965: l_log_unexpected,
3966: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4034: l_return_status := FND_API.G_RET_STS_SUCCESS;

4030: fnd_file.put_line(FND_FILE.LOG,'Entered AHL_PRD_PRINT_PVT.Generate_JCG_Request: cc id : ' || l_conc_request_id );
4031: fnd_file.new_line(FND_FILE.LOG,1);
4032: -- initialize return status.
4033: retcode := 0;
4034: l_return_status := FND_API.G_RET_STS_SUCCESS;
4035: fnd_global.apps_initialize(p_user_id, p_resp_id , 867/*APPLICATION ID for AHL constant */);
4036: mo_global.init('AHL');
4037:
4038: OPEN get_jcg_details(p_jcg_id);

Line 4055: p_init_msg_list => FND_API.G_TRUE,

4051: fnd_file.put_line(FND_FILE.LOG,'Calling Generate_JCG_XML');
4052:
4053: Generate_JCG_XML
4054: (p_api_version => 1.0,
4055: p_init_msg_list => FND_API.G_TRUE,
4056: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,
4057: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4058: p_object_type => l_object_type_code,
4059: p_object_id => l_object_id,

Line 4056: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,

4052:
4053: Generate_JCG_XML
4054: (p_api_version => 1.0,
4055: p_init_msg_list => FND_API.G_TRUE,
4056: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,
4057: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4058: p_object_type => l_object_type_code,
4059: p_object_id => l_object_id,
4060: p_split_flag => l_split_flag,

Line 4057: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4053: Generate_JCG_XML
4054: (p_api_version => 1.0,
4055: p_init_msg_list => FND_API.G_TRUE,
4056: --p_commit IN VARCHAR2 :=FND_API.G_FALSE,
4057: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4058: p_object_type => l_object_type_code,
4059: p_object_id => l_object_id,
4060: p_split_flag => l_split_flag,
4061: x_return_status => l_return_status,

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

4064: x_file_name => l_xml_file_name
4065: -- l_merged_lob OUT NOCOPY CLOB -- for testing purpose only ,not required
4066: );
4067: l_msg_count := FND_MSG_PUB.Count_Msg;
4068: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4069: retcode := 2; -- error based only on return status
4070: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4071: retcode := 1; -- warning based on return status + msg count
4072: END IF;

Line 4070: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4066: );
4067: l_msg_count := FND_MSG_PUB.Count_Msg;
4068: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4069: retcode := 2; -- error based only on return status
4070: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4071: retcode := 1; -- warning based on return status + msg count
4072: END IF;
4073: fnd_file.put_line(FND_FILE.LOG,'Generate_JCG_XML l_msg_count : ' || l_msg_count);
4074: fnd_file.put_line(FND_FILE.LOG,'Generate_JCG_XML l_return_status : ' || l_return_status);

Line 4082: RAISE FND_API.G_EXC_ERROR;

4078: fnd_file.new_line(FND_FILE.LOG,1);
4079:
4080: IF( retcode = 2 ) THEN
4081: fnd_file.put_line(FND_FILE.LOG,'Generate_JCG_XML returned errors');
4082: RAISE FND_API.G_EXC_ERROR;
4083: END IF;
4084: fnd_file.put_line(fnd_file.log,'Calling Process_JCG_Request');
4085:
4086: OPEN get_jcg_details(p_jcg_id);

Line 4100: p_init_msg_list => FND_API.G_FALSE,

4096: CLOSE get_jcg_details;
4097:
4098: Process_JCG_Request(
4099: p_api_version => 1.0,
4100: p_init_msg_list => FND_API.G_FALSE,
4101: p_commit => FND_API.G_FALSE,
4102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4103: p_default => FND_API.G_FALSE,
4104: p_module_type => NULL,

Line 4101: p_commit => FND_API.G_FALSE,

4097:
4098: Process_JCG_Request(
4099: p_api_version => 1.0,
4100: p_init_msg_list => FND_API.G_FALSE,
4101: p_commit => FND_API.G_FALSE,
4102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4103: p_default => FND_API.G_FALSE,
4104: p_module_type => NULL,
4105: x_return_status => l_return_status,

Line 4102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4098: Process_JCG_Request(
4099: p_api_version => 1.0,
4100: p_init_msg_list => FND_API.G_FALSE,
4101: p_commit => FND_API.G_FALSE,
4102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4103: p_default => FND_API.G_FALSE,
4104: p_module_type => NULL,
4105: x_return_status => l_return_status,
4106: x_msg_data => l_msg_data,

Line 4103: p_default => FND_API.G_FALSE,

4099: p_api_version => 1.0,
4100: p_init_msg_list => FND_API.G_FALSE,
4101: p_commit => FND_API.G_FALSE,
4102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4103: p_default => FND_API.G_FALSE,
4104: p_module_type => NULL,
4105: x_return_status => l_return_status,
4106: x_msg_data => l_msg_data,
4107: x_msg_count => l_msg_count ,

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

4116: p_error_message => NULL,
4117: p_CONCURRENT_REQUEST_ID => l_conc_request_id --fnd_global.conc_request_id
4118: );
4119: l_msg_count := FND_MSG_PUB.Count_Msg;
4120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4121: retcode := 2; -- error based only on return status
4122: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4123: retcode := 1; -- warning based on return status + msg count
4124: END IF;

Line 4122: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4118: );
4119: l_msg_count := FND_MSG_PUB.Count_Msg;
4120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4121: retcode := 2; -- error based only on return status
4122: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4123: retcode := 1; -- warning based on return status + msg count
4124: END IF;
4125: fnd_file.put_line(FND_FILE.LOG,'Process_JCG_Request l_msg_count : ' || l_msg_count);
4126: fnd_file.put_line(FND_FILE.LOG,'Process_JCG_Request l_return_status : ' || l_return_status);

Line 4134: RAISE FND_API.G_EXC_ERROR;

4130: fnd_file.new_line(FND_FILE.LOG,1);
4131:
4132: IF( retcode =2 ) THEN
4133: fnd_file.put_line(FND_FILE.LOG,'Process_JCG_Request returned errors');
4134: RAISE FND_API.G_EXC_ERROR;
4135: END IF;
4136:
4137: fnd_file.put_line(FND_FILE.LOG,'Preparing to request Enigma to print');
4138: l_xml_file_name := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH') ||'/' ||l_xml_file_name;

Line 4196: WHEN FND_API.G_EXC_ERROR THEN

4192: commit;
4193: fnd_file.put_line(FND_FILE.LOG,'End time:CC:' || to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
4194:
4195: EXCEPTION
4196: WHEN FND_API.G_EXC_ERROR THEN
4197: retcode := 2;
4198: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4199: p_data => l_msg_data,
4200: p_encoded => fnd_api.g_false);

Line 4200: p_encoded => fnd_api.g_false);

4196: WHEN FND_API.G_EXC_ERROR THEN
4197: retcode := 2;
4198: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4199: p_data => l_msg_data,
4200: p_encoded => fnd_api.g_false);
4201: errbuf := l_msg_data;
4202: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);
4203: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_ERROR: Generate_JCG_Request returned errors ');
4204: fnd_file.put_line(FND_FILE.LOG,'Error Update Status :' || l_err_update_status);

Line 4203: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_ERROR: Generate_JCG_Request returned errors ');

4199: p_data => l_msg_data,
4200: p_encoded => fnd_api.g_false);
4201: errbuf := l_msg_data;
4202: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);
4203: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_ERROR: Generate_JCG_Request returned errors ');
4204: fnd_file.put_line(FND_FILE.LOG,'Error Update Status :' || l_err_update_status);
4205: fnd_file.new_line(FND_FILE.LOG,1);
4206:
4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4203: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_ERROR: Generate_JCG_Request returned errors ');
4204: fnd_file.put_line(FND_FILE.LOG,'Error Update Status :' || l_err_update_status);
4205: fnd_file.new_line(FND_FILE.LOG,1);
4206:
4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4208: retcode := 2;
4209: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4210: p_data => l_msg_data,
4211: p_encoded => fnd_api.g_false);

Line 4211: p_encoded => fnd_api.g_false);

4207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4208: retcode := 2;
4209: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4210: p_data => l_msg_data,
4211: p_encoded => fnd_api.g_false);
4212: errbuf := l_msg_data;
4213: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);
4214: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_UNEXPECTED_ERROR: Generate_JCG_Request returned errors ');
4215: fnd_file.put_line(FND_FILE.LOG,'Error Update Status :' || l_err_update_status);

Line 4214: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_UNEXPECTED_ERROR: Generate_JCG_Request returned errors ');

4210: p_data => l_msg_data,
4211: p_encoded => fnd_api.g_false);
4212: errbuf := l_msg_data;
4213: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);
4214: fnd_file.put_line(FND_FILE.LOG,'Exceptions FND_API.G_EXC_UNEXPECTED_ERROR: Generate_JCG_Request returned errors ');
4215: fnd_file.put_line(FND_FILE.LOG,'Error Update Status :' || l_err_update_status);
4216: fnd_file.new_line(FND_FILE.LOG,1);
4217:
4218: WHEN OTHERS THEN

Line 4225: p_encoded => fnd_api.g_false);

4221: p_procedure_name => 'generate_jcg_request',
4222: p_error_text => SUBSTR(SQLERRM,1,240));
4223: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4224: p_data => l_msg_data,
4225: p_encoded => fnd_api.g_false);
4226: errbuf := l_msg_data;
4227: l_err_update_status := HANDLE_JCG_ERRORS(l_enigma_request_id , to_char(l_conc_request_id) || ':' || l_msg_data);
4228: fnd_file.put_line(FND_FILE.LOG,'Exceptions OTHERS: Generate_JCG_Request returned errors ');
4229: fnd_file.put_line(FND_FILE.LOG,'Error Update Status :' || l_err_update_status);

Line 4242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

4238: -- Parameters :
4239: --
4240: -- Standard IN Parameters :
4241: -- p_api_version IN NUMBER Required
4242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
4246: -- Based on this flag, the API will set the default attributes.

Line 4243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

4239: --
4240: -- Standard IN Parameters :
4241: -- p_api_version IN NUMBER Required
4242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
4246: -- Based on this flag, the API will set the default attributes.
4247: -- p_module_type In VARCHAR2 Default NULL

Line 4244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

4240: -- Standard IN Parameters :
4241: -- p_api_version IN NUMBER Required
4242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
4246: -- Based on this flag, the API will set the default attributes.
4247: -- p_module_type In VARCHAR2 Default NULL
4248: -- This will be null.

Line 4245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

4241: -- p_api_version IN NUMBER Required
4242: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
4243: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
4244: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
4245: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
4246: -- Based on this flag, the API will set the default attributes.
4247: -- p_module_type In VARCHAR2 Default NULL
4248: -- This will be null.
4249: -- Standard OUT Parameters :

Line 4261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4257: -- p_user_id FND user id,
4258: -- p_resp_id Responsibility ID
4259: PROCEDURE print_workcard (
4260: p_api_version IN NUMBER :=1.0,
4261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4264: p_default IN VARCHAR2 := FND_API.G_TRUE,
4265: p_module_type IN VARCHAR2 := NULL,

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

4258: -- p_resp_id Responsibility ID
4259: PROCEDURE print_workcard (
4260: p_api_version IN NUMBER :=1.0,
4261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4264: p_default IN VARCHAR2 := FND_API.G_TRUE,
4265: p_module_type IN VARCHAR2 := NULL,
4266: x_return_status OUT NOCOPY VARCHAR2,

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

4259: PROCEDURE print_workcard (
4260: p_api_version IN NUMBER :=1.0,
4261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4264: p_default IN VARCHAR2 := FND_API.G_TRUE,
4265: p_module_type IN VARCHAR2 := NULL,
4266: x_return_status OUT NOCOPY VARCHAR2,
4267: x_msg_count OUT NOCOPY NUMBER,

Line 4264: p_default IN VARCHAR2 := FND_API.G_TRUE,

4260: p_api_version IN NUMBER :=1.0,
4261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4262: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4264: p_default IN VARCHAR2 := FND_API.G_TRUE,
4265: p_module_type IN VARCHAR2 := NULL,
4266: x_return_status OUT NOCOPY VARCHAR2,
4267: x_msg_count OUT NOCOPY NUMBER,
4268: x_msg_data OUT NOCOPY VARCHAR2,

Line 4297: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

4293: -- Standard start of API savepoint
4294: SAVEPOINT GENERATE_JCG_REQUEST_PVT;
4295:
4296: -- Standard call to check for call compatibility
4297: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
4298: G_PKG_NAME) THEN
4299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4300: END IF;
4301:

Line 4299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4295:
4296: -- Standard call to check for call compatibility
4297: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
4298: G_PKG_NAME) THEN
4299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4300: END IF;
4301:
4302: -- Initialize message list if p_init_msg_list is set to TRUE
4303: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 4303: IF FND_API.To_Boolean(p_init_msg_list) THEN

4299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4300: END IF;
4301:
4302: -- Initialize message list if p_init_msg_list is set to TRUE
4303: IF FND_API.To_Boolean(p_init_msg_list) THEN
4304: FND_MSG_PUB.Initialize;
4305: END IF;
4306:
4307: l_user_id := FND_GLOBAL.USER_ID;

Line 4329: x_return_status := FND_API.G_RET_STS_SUCCESS;

4325: );
4326: END IF;
4327:
4328: -- Initialize Procedure return status to success
4329: x_return_status := FND_API.G_RET_STS_SUCCESS;
4330:
4331: Process_JCG_Request(
4332: p_api_version => 1.0,
4333: p_init_msg_list => FND_API.G_FALSE,

Line 4333: p_init_msg_list => FND_API.G_FALSE,

4329: x_return_status := FND_API.G_RET_STS_SUCCESS;
4330:
4331: Process_JCG_Request(
4332: p_api_version => 1.0,
4333: p_init_msg_list => FND_API.G_FALSE,
4334: p_commit => FND_API.G_FALSE,
4335: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4336: p_default => FND_API.G_FALSE,
4337: p_module_type => NULL,

Line 4334: p_commit => FND_API.G_FALSE,

4330:
4331: Process_JCG_Request(
4332: p_api_version => 1.0,
4333: p_init_msg_list => FND_API.G_FALSE,
4334: p_commit => FND_API.G_FALSE,
4335: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4336: p_default => FND_API.G_FALSE,
4337: p_module_type => NULL,
4338: x_return_status => l_return_status,

Line 4335: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4331: Process_JCG_Request(
4332: p_api_version => 1.0,
4333: p_init_msg_list => FND_API.G_FALSE,
4334: p_commit => FND_API.G_FALSE,
4335: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4336: p_default => FND_API.G_FALSE,
4337: p_module_type => NULL,
4338: x_return_status => l_return_status,
4339: x_msg_data => l_msg_data,

Line 4336: p_default => FND_API.G_FALSE,

4332: p_api_version => 1.0,
4333: p_init_msg_list => FND_API.G_FALSE,
4334: p_commit => FND_API.G_FALSE,
4335: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4336: p_default => FND_API.G_FALSE,
4337: p_module_type => NULL,
4338: x_return_status => l_return_status,
4339: x_msg_data => l_msg_data,
4340: x_msg_count => l_msg_count ,

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

4349: p_error_message => NULL,
4350: p_CONCURRENT_REQUEST_ID => NULL
4351: );
4352:
4353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4355: END IF;
4356: l_req_id := fnd_request.submit_request('AHL','AHLJCGREQ',NULL,NULL,FALSE, l_jcg_id,l_user_id,l_resp_id);
4357: IF (l_req_id = 0 OR l_req_id IS NULL) THEN

Line 4354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4350: p_CONCURRENT_REQUEST_ID => NULL
4351: );
4352:
4353: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4355: END IF;
4356: l_req_id := fnd_request.submit_request('AHL','AHLJCGREQ',NULL,NULL,FALSE, l_jcg_id,l_user_id,l_resp_id);
4357: IF (l_req_id = 0 OR l_req_id IS NULL) THEN
4358: IF (l_log_unexpected >= l_log_current_level)THEN

Line 4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4359: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4360: 'Tried to submit concurrent request but failed'
4361: );
4362: END IF;
4363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4364: ELSE
4365: IF (l_log_statement >= l_log_current_level)THEN
4366: fnd_log.string( l_log_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4367: 'Concurrent request ID:' || l_req_id

Line 4373: IF FND_API.TO_BOOLEAN(p_commit) THEN

4369: END IF;
4370: END IF; -- l_req_id = 0 OR ..
4371:
4372: -- Standard check of p_commit
4373: IF FND_API.TO_BOOLEAN(p_commit) THEN
4374: COMMIT WORK;
4375: END IF;
4376:
4377: -- Standard call to get message count and if count is 1, get message info

Line 4381: p_encoded => fnd_api.g_false

4377: -- Standard call to get message count and if count is 1, get message info
4378: FND_MSG_PUB.Count_And_Get
4379: ( p_count => x_msg_count,
4380: p_data => x_msg_data,
4381: p_encoded => fnd_api.g_false
4382: );
4383:
4384: --
4385: EXCEPTION

Line 4386: WHEN FND_API.G_EXC_ERROR THEN

4382: );
4383:
4384: --
4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: x_return_status := FND_API.G_RET_STS_ERROR;
4388: Rollback to GENERATE_JCG_REQUEST_PVT;
4389: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4390: p_data => x_msg_data,

Line 4387: x_return_status := FND_API.G_RET_STS_ERROR;

4383:
4384: --
4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: x_return_status := FND_API.G_RET_STS_ERROR;
4388: Rollback to GENERATE_JCG_REQUEST_PVT;
4389: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4390: p_data => x_msg_data,
4391: p_encoded => fnd_api.g_false);

Line 4391: p_encoded => fnd_api.g_false);

4387: x_return_status := FND_API.G_RET_STS_ERROR;
4388: Rollback to GENERATE_JCG_REQUEST_PVT;
4389: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4390: p_data => x_msg_data,
4391: p_encoded => fnd_api.g_false);
4392:
4393:
4394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4390: p_data => x_msg_data,
4391: p_encoded => fnd_api.g_false);
4392:
4393:
4394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4396: Rollback to GENERATE_JCG_REQUEST_PVT;
4397: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4398: p_data => x_msg_data,

Line 4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4391: p_encoded => fnd_api.g_false);
4392:
4393:
4394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4396: Rollback to GENERATE_JCG_REQUEST_PVT;
4397: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4398: p_data => x_msg_data,
4399: p_encoded => fnd_api.g_false);

Line 4399: p_encoded => fnd_api.g_false);

4395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4396: Rollback to GENERATE_JCG_REQUEST_PVT;
4397: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4398: p_data => x_msg_data,
4399: p_encoded => fnd_api.g_false);
4400:
4401: WHEN OTHERS THEN
4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: Rollback to GENERATE_JCG_REQUEST_PVT;

Line 4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4398: p_data => x_msg_data,
4399: p_encoded => fnd_api.g_false);
4400:
4401: WHEN OTHERS THEN
4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: Rollback to GENERATE_JCG_REQUEST_PVT;
4404: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4405: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
4406: p_procedure_name => 'print_workcard',

Line 4411: p_encoded => fnd_api.g_false);

4407: p_error_text => SUBSTR(SQLERRM,1,240));
4408: END IF;
4409: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
4410: p_data => x_msg_data,
4411: p_encoded => fnd_api.g_false);
4412:
4413: END print_workcard;
4414:
4415: --- Function to handle Enigma JCG Web Service response

Line 4423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4419: l_ret_resp VARCHAR2(10);
4420: BEGIN
4421: l_ret_resp := HANDLE_JCG_RESPONSE(p_event.GetEventKey(), p_event.getEventData());
4422: IF(l_ret_resp <> 'SUCCESS')THEN
4423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4424: END IF;
4425: RETURN 'SUCCESS';
4426: EXCEPTION
4427: WHEN OTHERS THEN

Line 4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4439: l_ret_resp VARCHAR2(10);
4440: BEGIN
4441: l_ret_resp := HANDLE_JCG_ERRORS(p_event.GetEventKey(), p_event.getErrorMessage());
4442: IF(l_ret_resp <> 'SUCCESS')THEN
4443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4444: END IF;
4445: RETURN 'SUCCESS';
4446: EXCEPTION
4447: WHEN OTHERS THEN

Line 4600: p_init_msg_list => FND_API.G_FALSE,

4596: l_jcg_req_status := 'E';
4597: END IF;
4598: Process_JCG_Request(
4599: p_api_version => 1.0,
4600: p_init_msg_list => FND_API.G_FALSE,
4601: p_commit => FND_API.G_FALSE,
4602: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4603: p_default => FND_API.G_FALSE,
4604: p_module_type => NULL,

Line 4601: p_commit => FND_API.G_FALSE,

4597: END IF;
4598: Process_JCG_Request(
4599: p_api_version => 1.0,
4600: p_init_msg_list => FND_API.G_FALSE,
4601: p_commit => FND_API.G_FALSE,
4602: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4603: p_default => FND_API.G_FALSE,
4604: p_module_type => NULL,
4605: x_return_status => l_return_status,

Line 4602: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4598: Process_JCG_Request(
4599: p_api_version => 1.0,
4600: p_init_msg_list => FND_API.G_FALSE,
4601: p_commit => FND_API.G_FALSE,
4602: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4603: p_default => FND_API.G_FALSE,
4604: p_module_type => NULL,
4605: x_return_status => l_return_status,
4606: x_msg_data => l_msg_data,

Line 4603: p_default => FND_API.G_FALSE,

4599: p_api_version => 1.0,
4600: p_init_msg_list => FND_API.G_FALSE,
4601: p_commit => FND_API.G_FALSE,
4602: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4603: p_default => FND_API.G_FALSE,
4604: p_module_type => NULL,
4605: x_return_status => l_return_status,
4606: x_msg_data => l_msg_data,
4607: x_msg_count => l_msg_count ,

Line 4639: p_init_msg_list => FND_API.G_FALSE,

4635: l_jcg_req_status := 'E';
4636: end if;
4637: Process_JCG_Request(
4638: p_api_version => 1.0,
4639: p_init_msg_list => FND_API.G_FALSE,
4640: p_commit => FND_API.G_FALSE,
4641: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4642: p_default => FND_API.G_FALSE,
4643: p_module_type => NULL,

Line 4640: p_commit => FND_API.G_FALSE,

4636: end if;
4637: Process_JCG_Request(
4638: p_api_version => 1.0,
4639: p_init_msg_list => FND_API.G_FALSE,
4640: p_commit => FND_API.G_FALSE,
4641: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4642: p_default => FND_API.G_FALSE,
4643: p_module_type => NULL,
4644: x_return_status => l_return_status,

Line 4641: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4637: Process_JCG_Request(
4638: p_api_version => 1.0,
4639: p_init_msg_list => FND_API.G_FALSE,
4640: p_commit => FND_API.G_FALSE,
4641: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4642: p_default => FND_API.G_FALSE,
4643: p_module_type => NULL,
4644: x_return_status => l_return_status,
4645: x_msg_data => l_msg_data,

Line 4642: p_default => FND_API.G_FALSE,

4638: p_api_version => 1.0,
4639: p_init_msg_list => FND_API.G_FALSE,
4640: p_commit => FND_API.G_FALSE,
4641: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4642: p_default => FND_API.G_FALSE,
4643: p_module_type => NULL,
4644: x_return_status => l_return_status,
4645: x_msg_data => l_msg_data,
4646: x_msg_count => l_msg_count ,

Line 4670: p_init_msg_list => FND_API.G_FALSE,

4666: fetch does_more_recent_jcg_exist into l_junc;
4667: if(does_more_recent_jcg_exist%notfound)then
4668: Process_JCG_Request(
4669: p_api_version => 1.0,
4670: p_init_msg_list => FND_API.G_FALSE,
4671: p_commit => FND_API.G_FALSE,
4672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4673: p_default => FND_API.G_FALSE,
4674: p_module_type => NULL,

Line 4671: p_commit => FND_API.G_FALSE,

4667: if(does_more_recent_jcg_exist%notfound)then
4668: Process_JCG_Request(
4669: p_api_version => 1.0,
4670: p_init_msg_list => FND_API.G_FALSE,
4671: p_commit => FND_API.G_FALSE,
4672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4673: p_default => FND_API.G_FALSE,
4674: p_module_type => NULL,
4675: x_return_status => l_return_status,

Line 4672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4668: Process_JCG_Request(
4669: p_api_version => 1.0,
4670: p_init_msg_list => FND_API.G_FALSE,
4671: p_commit => FND_API.G_FALSE,
4672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4673: p_default => FND_API.G_FALSE,
4674: p_module_type => NULL,
4675: x_return_status => l_return_status,
4676: x_msg_data => l_msg_data,

Line 4673: p_default => FND_API.G_FALSE,

4669: p_api_version => 1.0,
4670: p_init_msg_list => FND_API.G_FALSE,
4671: p_commit => FND_API.G_FALSE,
4672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4673: p_default => FND_API.G_FALSE,
4674: p_module_type => NULL,
4675: x_return_status => l_return_status,
4676: x_msg_data => l_msg_data,
4677: x_msg_count => l_msg_count ,

Line 4696: p_init_msg_list => FND_API.G_FALSE,

4692: END LOOP;
4693: ELSE -- no meaningful response was returned by Enigma
4694: Process_JCG_Request(
4695: p_api_version => 1.0,
4696: p_init_msg_list => FND_API.G_FALSE,
4697: p_commit => FND_API.G_FALSE,
4698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4699: p_default => FND_API.G_FALSE,
4700: p_module_type => NULL,

Line 4697: p_commit => FND_API.G_FALSE,

4693: ELSE -- no meaningful response was returned by Enigma
4694: Process_JCG_Request(
4695: p_api_version => 1.0,
4696: p_init_msg_list => FND_API.G_FALSE,
4697: p_commit => FND_API.G_FALSE,
4698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4699: p_default => FND_API.G_FALSE,
4700: p_module_type => NULL,
4701: x_return_status => l_return_status,

Line 4698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4694: Process_JCG_Request(
4695: p_api_version => 1.0,
4696: p_init_msg_list => FND_API.G_FALSE,
4697: p_commit => FND_API.G_FALSE,
4698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4699: p_default => FND_API.G_FALSE,
4700: p_module_type => NULL,
4701: x_return_status => l_return_status,
4702: x_msg_data => l_msg_data,

Line 4699: p_default => FND_API.G_FALSE,

4695: p_api_version => 1.0,
4696: p_init_msg_list => FND_API.G_FALSE,
4697: p_commit => FND_API.G_FALSE,
4698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4699: p_default => FND_API.G_FALSE,
4700: p_module_type => NULL,
4701: x_return_status => l_return_status,
4702: x_msg_data => l_msg_data,
4703: x_msg_count => l_msg_count ,

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

4713: p_CONCURRENT_REQUEST_ID => l_jcg_details_rec.CONCURRENT_REQUEST_ID
4714: );
4715: END IF;
4716:
4717: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4718: RAISE FND_API.G_EXC_ERROR;
4719: END IF;
4720: IF (l_log_procedure >= l_log_current_level)THEN
4721: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4718: RAISE FND_API.G_EXC_ERROR;

4714: );
4715: END IF;
4716:
4717: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4718: RAISE FND_API.G_EXC_ERROR;
4719: END IF;
4720: IF (l_log_procedure >= l_log_current_level)THEN
4721: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4722: 'Finsihed processing response' );

Line 4732: WHEN FND_API.G_EXC_ERROR THEN

4728: RETURN 'SUCCESS';
4729:
4730:
4731: EXCEPTION
4732: WHEN FND_API.G_EXC_ERROR THEN
4733: Rollback to HANDLE_JCG_RESPONSE;
4734:
4735: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4736: p_data => l_msg_data,

Line 4737: p_encoded => fnd_api.g_false);

4733: Rollback to HANDLE_JCG_RESPONSE;
4734:
4735: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4736: p_data => l_msg_data,
4737: p_encoded => fnd_api.g_false);
4738: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4739:
4740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4741: Rollback to HANDLE_JCG_RESPONSE;

Line 4740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4736: p_data => l_msg_data,
4737: p_encoded => fnd_api.g_false);
4738: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4739:
4740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4741: Rollback to HANDLE_JCG_RESPONSE;
4742: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4743: p_data => l_msg_data,
4744: p_encoded => fnd_api.g_false);

Line 4744: p_encoded => fnd_api.g_false);

4740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4741: Rollback to HANDLE_JCG_RESPONSE;
4742: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4743: p_data => l_msg_data,
4744: p_encoded => fnd_api.g_false);
4745: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4746:
4747: WHEN OTHERS THEN
4748: Rollback to HANDLE_JCG_RESPONSE;

Line 4754: p_encoded => fnd_api.g_false);

4750: p_procedure_name => l_api_name,
4751: p_error_text => SUBSTR(SQLERRM,1,240));
4752: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4753: p_data => l_msg_data,
4754: p_encoded => fnd_api.g_false);
4755: RETURN HANDLE_JCG_ERRORS(p_request_id, l_msg_data );
4756: END HANDLE_JCG_RESPONSE;
4757:
4758:

Line 4847: p_init_msg_list => FND_API.G_FALSE,

4843:
4844:
4845: Process_JCG_Request(
4846: p_api_version => 1.0,
4847: p_init_msg_list => FND_API.G_FALSE,
4848: p_commit => FND_API.G_FALSE,
4849: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4850: p_default => FND_API.G_FALSE,
4851: p_module_type => NULL,

Line 4848: p_commit => FND_API.G_FALSE,

4844:
4845: Process_JCG_Request(
4846: p_api_version => 1.0,
4847: p_init_msg_list => FND_API.G_FALSE,
4848: p_commit => FND_API.G_FALSE,
4849: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4850: p_default => FND_API.G_FALSE,
4851: p_module_type => NULL,
4852: x_return_status => l_return_status,

Line 4849: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4845: Process_JCG_Request(
4846: p_api_version => 1.0,
4847: p_init_msg_list => FND_API.G_FALSE,
4848: p_commit => FND_API.G_FALSE,
4849: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4850: p_default => FND_API.G_FALSE,
4851: p_module_type => NULL,
4852: x_return_status => l_return_status,
4853: x_msg_data => l_msg_data,

Line 4850: p_default => FND_API.G_FALSE,

4846: p_api_version => 1.0,
4847: p_init_msg_list => FND_API.G_FALSE,
4848: p_commit => FND_API.G_FALSE,
4849: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4850: p_default => FND_API.G_FALSE,
4851: p_module_type => NULL,
4852: x_return_status => l_return_status,
4853: x_msg_data => l_msg_data,
4854: x_msg_count => l_msg_count ,

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

4863: p_error_message => l_error_msg,
4864: p_CONCURRENT_REQUEST_ID => l_jcg_details_rec.CONCURRENT_REQUEST_ID
4865: );
4866:
4867: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4868: RAISE FND_API.G_EXC_ERROR;
4869: END IF;
4870: IF (l_log_procedure >= l_log_current_level)THEN
4871: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4868: RAISE FND_API.G_EXC_ERROR;

4864: p_CONCURRENT_REQUEST_ID => l_jcg_details_rec.CONCURRENT_REQUEST_ID
4865: );
4866:
4867: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4868: RAISE FND_API.G_EXC_ERROR;
4869: END IF;
4870: IF (l_log_procedure >= l_log_current_level)THEN
4871: fnd_log.string( l_log_procedure,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4872: 'Finsihed processing errors' );

Line 4882: WHEN FND_API.G_EXC_ERROR THEN

4878: RETURN 'SUCCESS';
4879:
4880:
4881: EXCEPTION
4882: WHEN FND_API.G_EXC_ERROR THEN
4883: Rollback to HANDLE_JCG_ERRORS;
4884:
4885: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4886: p_data => l_msg_data,

Line 4887: p_encoded => fnd_api.g_false);

4883: Rollback to HANDLE_JCG_ERRORS;
4884:
4885: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4886: p_data => l_msg_data,
4887: p_encoded => fnd_api.g_false);
4888: IF (l_log_error >= l_log_current_level)THEN
4889: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4890: 'l_eventkey:' || p_request_id );
4891: fnd_log.string( l_log_error,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4892: 'l_msg_data:' || l_msg_data );
4893: END IF;
4894: RETURN 'ERROR';
4895:
4896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4897: Rollback to HANDLE_JCG_ERRORS;
4898: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4899: p_data => l_msg_data,
4900: p_encoded => fnd_api.g_false);

Line 4900: p_encoded => fnd_api.g_false);

4896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4897: Rollback to HANDLE_JCG_ERRORS;
4898: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4899: p_data => l_msg_data,
4900: p_encoded => fnd_api.g_false);
4901: IF (l_log_unexpected >= l_log_current_level)THEN
4902: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4903: 'p_request_id:' || p_request_id );
4904: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 4915: p_encoded => fnd_api.g_false);

4911: p_procedure_name => l_api_name,
4912: p_error_text => SUBSTR(SQLERRM,1,240));
4913: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
4914: p_data => l_msg_data,
4915: p_encoded => fnd_api.g_false);
4916: IF (l_log_unexpected >= l_log_current_level)THEN
4917: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,
4918: 'p_request_id:' || p_request_id );
4919: fnd_log.string( l_log_unexpected,'ahl.plsql.'||g_pkg_name||'.'||l_api_name ,

Line 5043: x_return_status := FND_API.G_RET_STS_SUCCESS;

5039: l_clob_file CLOB;
5040: l_vchar_header VARCHAR2(40);
5041: BEGIN
5042: -- Initialize Procedure return status to success
5043: x_return_status := FND_API.G_RET_STS_SUCCESS;
5044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5045: fnd_log.string (
5046: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5047: END IF;

Line 5087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5083: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'done transformation');
5084: END IF;
5085: EXCEPTION
5086: WHEN OTHERS THEN
5087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5088: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5089: p_procedure_name => 'APPLY_TRANSFORMATION',
5090: p_error_text => SUBSTR(SQLERRM,1,240));
5091: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 5093: p_encoded => fnd_api.g_false);

5089: p_procedure_name => 'APPLY_TRANSFORMATION',
5090: p_error_text => SUBSTR(SQLERRM,1,240));
5091: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5092: p_data => x_msg_data,
5093: p_encoded => fnd_api.g_false);
5094:
5095: END APPLY_TRANSFORMATION;
5096:
5097: PROCEDURE APPLY_TRANSFORMATION(

Line 5118: x_return_status := FND_API.G_RET_STS_SUCCESS;

5114: l_clob_file CLOB;
5115: l_vchar_header VARCHAR2(40);
5116: BEGIN
5117: -- Initialize Procedure return status to success
5118: x_return_status := FND_API.G_RET_STS_SUCCESS;
5119: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5120: fnd_log.string (
5121: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Starting transformation');
5122: END IF;

Line 5162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5158: fnd_log.level_statement, 'ahl.plsql.'||g_pkg_name||'.'||'APPLY_TRANSFORMATION' ,'Done transformation');
5159: END IF;
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5163: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
5164: p_procedure_name => 'APPLY_TRANSFORMATION',
5165: p_error_text => SUBSTR(SQLERRM,1,240));
5166: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 5168: p_encoded => fnd_api.g_false);

5164: p_procedure_name => 'APPLY_TRANSFORMATION',
5165: p_error_text => SUBSTR(SQLERRM,1,240));
5166: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
5167: p_data => x_msg_data,
5168: p_encoded => fnd_api.g_false);
5169:
5170: END APPLY_TRANSFORMATION;
5171:
5172: FUNCTION get_xsl_clob RETURN CLOB

Line 7564: l_item_found := FND_API.G_TRUE;

7560:
7561: l_dummy_query := l_dummy_query ||' ,XMLConcat(XMLELEMENT("LABEL", '''|| null ||''' )';
7562: l_dummy_query := l_dummy_query || ', XMLELEMENT("AttributeValue", '''|| null ||''' ) ) "QualityPlanAttribute"';
7563:
7564: l_item_found := FND_API.G_TRUE;
7565: l_item_hardcoded_column := qa_csr.hardcoded_column;
7566: --l_column_name_tbl(l_rec_count) := result_column;
7567: ELSIF qa_csr.char_id = G_LOCATOR_CHAR THEN
7568:

Line 7575: l_locator_found := FND_API.G_TRUE;

7571:
7572: l_dummy_query := l_dummy_query ||' ,XMLConcat(XMLELEMENT("LABEL", '''|| null ||''' )';
7573: l_dummy_query := l_dummy_query || ', XMLELEMENT("AttributeValue", '''|| null ||''' ) ) "QualityPlanAttribute"';
7574:
7575: l_locator_found := FND_API.G_TRUE;
7576: l_locator_hardcoded_column := qa_csr.hardcoded_column;
7577: --l_column_name_tbl(l_rec_count) := result_column;
7578: ELSE
7579: IF qa_csr.hardcoded_column IS NOT NULL

Line 7600: IF l_item_found = FND_API.G_TRUE THEN

7596: -- Results will all be included in the from clause
7597: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
7598:
7599: -- Append required FROM clauses for the API.
7600: IF l_item_found = FND_API.G_TRUE THEN
7601: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
7602: END IF;
7603:
7604: IF l_locator_found = FND_API.G_TRUE THEN

Line 7604: IF l_locator_found = FND_API.G_TRUE THEN

7600: IF l_item_found = FND_API.G_TRUE THEN
7601: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
7602: END IF;
7603:
7604: IF l_locator_found = FND_API.G_TRUE THEN
7605: l_query_string := l_query_string || ' , MTL_ITEM_LOCATIONS_KFV LOCATOR ';
7606: END IF;
7607:
7608: -- Append collection id to the where clause

Line 7612: IF l_item_found = FND_API.G_TRUE THEN

7608: -- Append collection id to the where clause
7609: l_query_string := l_query_string || ' WHERE RESULTS.COLLECTION_ID = :1' ;
7610:
7611: -- Append required FROM clauses for the API.
7612: IF l_item_found = FND_API.G_TRUE THEN
7613: l_query_string := l_query_string || ' AND ITEM.inventory_item_id (+) = RESULTS.' || l_item_hardcoded_column;
7614: l_query_string := l_query_string || ' AND ITEM.organization_id (+) = RESULTS.organization_id ';
7615: END IF;
7616:

Line 7617: IF l_locator_found = FND_API.G_TRUE THEN

7613: l_query_string := l_query_string || ' AND ITEM.inventory_item_id (+) = RESULTS.' || l_item_hardcoded_column;
7614: l_query_string := l_query_string || ' AND ITEM.organization_id (+) = RESULTS.organization_id ';
7615: END IF;
7616:
7617: IF l_locator_found = FND_API.G_TRUE THEN
7618: l_query_string := l_query_string || ' AND LOCATOR.inventory_location_id (+) = RESULTS.' || l_locator_hardcoded_column;
7619: l_query_string := l_query_string || ' AND LOCATOR.organization_id (+) = RESULTS.organization_id ';
7620: END IF;
7621: l_query_string := l_query_string || ' order by 1 ';

Line 7660: x_return_status := FND_API.G_RET_STS_SUCCESS;

7656:
7657: l_api_name CONSTANT VARCHAR2(50) := 'Get_Route_KFF_Desc';
7658: BEGIN
7659:
7660: x_return_status := FND_API.G_RET_STS_SUCCESS;
7661:
7662: -- initialize the KFF descriptions.
7663: FOR i IN 1..15 LOOP
7664: l_mti_seglist(i) := null;

Line 7697: x_return_status := FND_API.G_RET_STS_ERROR;

7693:
7694: IF NOT(l_valid_flag) THEN
7695: -- do not raise error.
7696: -- In this case populate KFF descriptions as null.
7697: x_return_status := FND_API.G_RET_STS_ERROR;
7698: /*
7699: FND_MESSAGE.Set_Name('AHL','AHL_INPUT_NUM_LOC_SEGS_INVALID');
7700: FND_MESSAGE.Set_Token('LOC_SEG',p_concat_segs);
7701: FND_MSG_PUB.ADD;

Line 8883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8879: from ahl_routes_b_kfv
8880: where route_id = l_route_id;
8881: EXCEPTION
8882: WHEN OTHERS THEN
8883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8884: END;
8885:
8886: IF (l_log_statement >= l_log_current_level)THEN
8887: fnd_log.string ( l_log_statement, 'ahl.plsql.'

Line 8904: IF (kff_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8900: ||l_api_name ,'Checkpoint 7.2 : l_route_id:kff_return_status:'
8901: || l_route_id || ':' || kff_return_status);
8902: END IF;
8903:
8904: IF (kff_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8905:
8906: IF (l_mti_seglist(1) IS NOT NULL) THEN
8907: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
8908: dummy := DBMS_XMLGEN.CONVERT(l_mti_seglist(1));