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 68: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

64: -- Procedure to generate XML data for workorder(s).
65: ------------------------------------------------------------------------------------------------
66: PROCEDURE Gen_Wo_Xml(
67: p_api_version IN NUMBER :=1.0,
68: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
69: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
70: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
71: p_default IN VARCHAR2 :=FND_API.G_FALSE,
72: p_module_type IN VARCHAR2 :=NULL,

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

65: ------------------------------------------------------------------------------------------------
66: PROCEDURE Gen_Wo_Xml(
67: p_api_version IN NUMBER :=1.0,
68: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
69: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
70: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
71: p_default IN VARCHAR2 :=FND_API.G_FALSE,
72: p_module_type IN VARCHAR2 :=NULL,
73: x_return_status OUT NOCOPY VARCHAR2,

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

66: PROCEDURE Gen_Wo_Xml(
67: p_api_version IN NUMBER :=1.0,
68: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
69: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
70: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
71: p_default IN VARCHAR2 :=FND_API.G_FALSE,
72: p_module_type IN VARCHAR2 :=NULL,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,

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

67: p_api_version IN NUMBER :=1.0,
68: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
69: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
70: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
71: p_default IN VARCHAR2 :=FND_API.G_FALSE,
72: p_module_type IN VARCHAR2 :=NULL,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,

Line 449: x_return_status:= FND_API.G_RET_STS_SUCCESS;

445: );
446: END IF;
447:
448: -- Initialize return status to success initially
449: x_return_status:= FND_API.G_RET_STS_SUCCESS;
450:
451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
452: p_api_version,
453: l_api_name,G_PKG_NAME)

Line 451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

447:
448: -- Initialize return status to success initially
449: x_return_status:= FND_API.G_RET_STS_SUCCESS;
450:
451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
452: p_api_version,
453: l_api_name,G_PKG_NAME)
454: THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

451: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
452: p_api_version,
453: l_api_name,G_PKG_NAME)
454: THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 459: IF FND_API.to_boolean(p_init_msg_list) THEN

455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_boolean(p_init_msg_list) THEN
460: FND_MSG_PUB.initialize;
461: END IF;
462:
463: -- Open a temporary lob for merging the contents.

Line 858: P_init_msg_list => FND_API.G_FALSE,

854: --resource transaction details for the operation as follows.
855:
856: AHL_PRD_RESOURCE_TRANX_PVT.Get_Resource_Txn_Defaults(
857: P_api_version => 1.0,
858: P_init_msg_list => FND_API.G_FALSE,
859: p_module_type => null,
860: x_return_status => x_return_status,
861: x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data,

Line 1035: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034:
1035: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1036:
1037: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1038: fnd_log.string
1039: (

Line 1052: p_encoded => Fnd_Api.g_false,

1048: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
1049: END IF;
1050:
1051: Fnd_Msg_Pub.count_and_get (
1052: p_encoded => Fnd_Api.g_false,
1053: p_count => x_msg_count,
1054: p_data => x_msg_data
1055: );
1056:

Line 1124: l_item_found := FND_API.G_TRUE;

1120:
1121: l_dummy_query := l_dummy_query ||' ,XMLConcat(XMLELEMENT("LABEL", '''|| null ||''' )';
1122: l_dummy_query := l_dummy_query || ', XMLELEMENT("VALUE", '''|| null ||''' ) ) COLL_ELEMENT';
1123:
1124: l_item_found := FND_API.G_TRUE;
1125: l_item_hardcoded_column := qa_csr.hardcoded_column;
1126: --l_column_name_tbl(l_rec_count) := result_column;
1127: ELSIF qa_csr.char_id = G_LOCATOR_CHAR THEN
1128:

Line 1135: l_locator_found := FND_API.G_TRUE;

1131:
1132: l_dummy_query := l_dummy_query ||' ,XMLConcat(XMLELEMENT("LABEL", '''|| null ||''' )';
1133: l_dummy_query := l_dummy_query || ', XMLELEMENT("VALUE", '''|| null ||''' ) ) COLL_ELEMENT';
1134:
1135: l_locator_found := FND_API.G_TRUE;
1136: l_locator_hardcoded_column := qa_csr.hardcoded_column;
1137: --l_column_name_tbl(l_rec_count) := result_column;
1138: ELSE
1139: IF qa_csr.hardcoded_column IS NOT NULL

Line 1163: IF l_item_found = FND_API.G_TRUE THEN

1159: -- Results will all be included in the from clause
1160: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
1161:
1162: -- Append required FROM clauses for the API.
1163: IF l_item_found = FND_API.G_TRUE THEN
1164: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
1165: END IF;
1166:
1167: IF l_locator_found = FND_API.G_TRUE THEN

Line 1167: IF l_locator_found = FND_API.G_TRUE THEN

1163: IF l_item_found = FND_API.G_TRUE THEN
1164: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';
1165: END IF;
1166:
1167: IF l_locator_found = FND_API.G_TRUE THEN
1168: l_query_string := l_query_string || ' , MTL_ITEM_LOCATIONS_KFV LOCATOR ';
1169: END IF;
1170:
1171: -- Append collection id to the where clause

Line 1175: IF l_item_found = FND_API.G_TRUE THEN

1171: -- Append collection id to the where clause
1172: l_query_string := l_query_string || ' WHERE RESULTS.COLLECTION_ID = ' || p_collection_id;
1173:
1174: -- Append required FROM clauses for the API.
1175: IF l_item_found = FND_API.G_TRUE THEN
1176: l_query_string := l_query_string || ' AND ITEM.inventory_item_id (+) = RESULTS.' || l_item_hardcoded_column;
1177: l_query_string := l_query_string || ' AND ITEM.organization_id (+) = RESULTS.organization_id ';
1178: END IF;
1179:

Line 1180: IF l_locator_found = FND_API.G_TRUE THEN

1176: l_query_string := l_query_string || ' AND ITEM.inventory_item_id (+) = RESULTS.' || l_item_hardcoded_column;
1177: l_query_string := l_query_string || ' AND ITEM.organization_id (+) = RESULTS.organization_id ';
1178: END IF;
1179:
1180: IF l_locator_found = FND_API.G_TRUE THEN
1181: l_query_string := l_query_string || ' AND LOCATOR.inventory_location_id (+) = RESULTS.' || l_locator_hardcoded_column;
1182: l_query_string := l_query_string || ' AND LOCATOR.organization_id (+) = RESULTS.organization_id ';
1183: END IF;
1184:

Line 1329: p_init_msg_list => FND_API.G_TRUE,

1325: IF l_workorder_tbl.COUNT > 0
1326: THEN
1327: Gen_Wo_Xml(
1328: p_api_version => 1.0,
1329: p_init_msg_list => FND_API.G_TRUE,
1330: p_commit => FND_API.G_TRUE,
1331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1332: p_default => FND_API.G_TRUE,
1333: p_module_type => NULL,

Line 1330: p_commit => FND_API.G_TRUE,

1326: THEN
1327: Gen_Wo_Xml(
1328: p_api_version => 1.0,
1329: p_init_msg_list => FND_API.G_TRUE,
1330: p_commit => FND_API.G_TRUE,
1331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1332: p_default => FND_API.G_TRUE,
1333: p_module_type => NULL,
1334: x_return_status => l_return_status,

Line 1331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1327: Gen_Wo_Xml(
1328: p_api_version => 1.0,
1329: p_init_msg_list => FND_API.G_TRUE,
1330: p_commit => FND_API.G_TRUE,
1331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1332: p_default => FND_API.G_TRUE,
1333: p_module_type => NULL,
1334: x_return_status => l_return_status,
1335: x_msg_count => l_msg_count,

Line 1332: p_default => FND_API.G_TRUE,

1328: p_api_version => 1.0,
1329: p_init_msg_list => FND_API.G_TRUE,
1330: p_commit => FND_API.G_TRUE,
1331: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1332: p_default => FND_API.G_TRUE,
1333: p_module_type => NULL,
1334: x_return_status => l_return_status,
1335: x_msg_count => l_msg_count,
1336: x_msg_data => errbuf,

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

1352: l_offset := l_offset + l_chunk_size;
1353: END LOOP;
1354:
1355: l_msg_count := FND_MSG_PUB.Count_Msg;
1356: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1357: THEN
1358: retcode := 2; -- error based only on return status
1359: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)
1360: THEN

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

1355: l_msg_count := FND_MSG_PUB.Count_Msg;
1356: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1357: THEN
1358: retcode := 2; -- error based only on return status
1359: ELSIF (l_msg_count > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS)
1360: THEN
1361: retcode := 1; -- warning based on return status + msg count
1362: ELSE
1363: --fnd_file.put_line(fnd_file.output, dbms_lob.substr(l_clob, dbms_lob.getlength(l_clob), 1));