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.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on FND_API

Line 99: p_init_msg_list => FND_API.G_FALSE,

95: -- Populate temporary table for given PAC CostType and CostGroup
96: ------------------------------------------------------------------
97: l_stmt_num := 30;
98: Periodic_WIP_value_rpt_details(p_api_version => 1.0,
99: p_init_msg_list => FND_API.G_FALSE,
100: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
101: x_return_status => l_return_status,
102: x_msg_count => l_msg_count,
103: x_msg_data => l_msg_data,

Line 100: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

96: ------------------------------------------------------------------
97: l_stmt_num := 30;
98: Periodic_WIP_value_rpt_details(p_api_version => 1.0,
99: p_init_msg_list => FND_API.G_FALSE,
100: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
101: x_return_status => l_return_status,
102: x_msg_count => l_msg_count,
103: x_msg_data => l_msg_data,
104: p_report_type => p_report_type,

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

109:
110:
111:
112: -- If return status is not success, add message to the log
113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
114: l_msg_data := 'Failed generating Periodic WIP value details information';
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111:
112: -- If return status is not success, add message to the log
113: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
114: l_msg_data := 'Failed generating Periodic WIP value details information';
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: -----------------------------------------------------------------
119: -- Generate XML data for displaying the report parameters values

Line 123: p_init_msg_list => FND_API.G_FALSE,

119: -- Generate XML data for displaying the report parameters values
120: -----------------------------------------------------------------
121: l_stmt_num := 40;
122: Display_Parameters (p_api_version => 1.0,
123: p_init_msg_list => FND_API.G_FALSE,
124: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
125: x_return_status => l_return_status,
126: x_msg_count => l_msg_count,
127: x_msg_data => l_msg_data,

Line 124: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

120: -----------------------------------------------------------------
121: l_stmt_num := 40;
122: Display_Parameters (p_api_version => 1.0,
123: p_init_msg_list => FND_API.G_FALSE,
124: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
125: x_return_status => l_return_status,
126: x_msg_count => l_msg_count,
127: x_msg_data => l_msg_data,
128: p_report_type => p_report_type,

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

139: p_currency_code => p_currency_code,
140: x_xml_doc => l_xml_doc);
141:
142: -- If return status is not success, add message to the log
143: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
144: l_msg_data := 'Failed generating XML data for report parameter information';
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147:

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141:
142: -- If return status is not success, add message to the log
143: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
144: l_msg_data := 'Failed generating XML data for report parameter information';
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147:
148: -----------------------------------------------------------------
149: -- Generate XML data for displaying the report parameters values

Line 153: p_init_msg_list => FND_API.G_FALSE,

149: -- Generate XML data for displaying the report parameters values
150: -----------------------------------------------------------------
151: l_stmt_num := 50;
152: Get_XMLData(p_api_version => 1.0,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data,

Line 154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

150: -----------------------------------------------------------------
151: l_stmt_num := 50;
152: Get_XMLData(p_api_version => 1.0,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: x_return_status => l_return_status,
156: x_msg_count => l_msg_count,
157: x_msg_data => l_msg_data,
158: p_legal_entity_id => p_legal_entity_id,

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

168: p_currency_code => p_currency_code,
169: x_xml_doc => l_xml_doc);
170:
171: -- If return status is not success, add message to the log
172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
173: l_msg_data := 'Failed generating XML data of the report output';
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170:
171: -- If return status is not success, add message to the log
172: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
173: l_msg_data := 'Failed generating XML data of the report output';
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176:
177: DBMS_LOB.writeappend (l_xml_doc, 9, '');
178:

Line 208: WHEN fnd_api.g_exc_unexpected_error THEN

204: 'Exiting CST_PAC_WIP_Value_Report_PVT.Generate_XMLData >> ');
205: END IF;
206:
207: EXCEPTION
208: WHEN fnd_api.g_exc_unexpected_error THEN
209:
210: IF l_exceptionlog THEN
211: fnd_msg_pub.add_exc_msg(
212: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

Line 312: IF NOT FND_API.Compatible_API_Call (l_api_version,

308: );
309: END IF;
310:
311: l_stmt_num := 10;
312: IF NOT FND_API.Compatible_API_Call (l_api_version,
313: p_api_version,
314: l_api_name,
315: G_PKG_NAME )
316: THEN

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: p_api_version,
314: l_api_name,
315: G_PKG_NAME )
316: THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: -- Initialize API return status to success
321: l_stmt_num := 20;

Line 322: x_return_status := FND_API.G_RET_STS_SUCCESS;

318: END IF;
319:
320: -- Initialize API return status to success
321: l_stmt_num := 20;
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
325:
326: -------------------------------------------------------------------------------

Line 415: WHEN fnd_api.g_exc_unexpected_error THEN

411: 'Exiting CST_PAC_WIP_Value_Report_PVT.Display_Parameters >> ');
412: END IF;
413:
414: EXCEPTION
415: WHEN fnd_api.g_exc_unexpected_error THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417:
418: IF l_exceptionlog THEN
419: fnd_msg_pub.add_exc_msg(

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: END IF;
413:
414: EXCEPTION
415: WHEN fnd_api.g_exc_unexpected_error THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417:
418: IF l_exceptionlog THEN
419: fnd_msg_pub.add_exc_msg(
420: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: );
430: END IF;
431: END IF;
432: WHEN OTHERS THEN
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434:
435: IF l_uLog THEN
436: fnd_log.string(
437: FND_LOG.LEVEL_UNEXPECTED,

Line 536: x_return_status := FND_API.G_RET_STS_SUCCESS;

532:
533: BEGIN
534:
535: l_stmt_num := 0;
536: x_return_status := FND_API.G_RET_STS_SUCCESS;
537:
538: IF l_plog THEN
539: fnd_log.string(
540: fnd_log.level_procedure,

Line 738: WHEN fnd_api.g_exc_unexpected_error THEN

734: 'Exiting CST_PAC_WIP_Value_Report_PVT.Periodic_WIP_Value_Rpt_Details >> ');
735: END IF;
736:
737: EXCEPTION
738: WHEN fnd_api.g_exc_unexpected_error THEN
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740:
741: IF l_exceptionlog THEN
742: fnd_msg_pub.add_exc_msg(

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

735: END IF;
736:
737: EXCEPTION
738: WHEN fnd_api.g_exc_unexpected_error THEN
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740:
741: IF l_exceptionlog THEN
742: fnd_msg_pub.add_exc_msg(
743: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

Line 757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

753: END IF;
754: END IF;
755:
756: WHEN OTHERS THEN
757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
758:
759: IF l_uLog THEN
760: FND_LOG.STRING(
761: FND_LOG.LEVEL_UNEXPECTED,

Line 827: x_return_status := FND_API.G_RET_STS_SUCCESS;

823:
824: BEGIN
825:
826: l_stmt_num := 0;
827: x_return_status := FND_API.G_RET_STS_SUCCESS;
828:
829: IF l_plog THEN
830: fnd_log.string(
831: fnd_log.level_procedure,

Line 872: IF NOT FND_API.Compatible_API_Call ( l_api_version,

868: l_offset := 21;
869: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
870:
871: -- Standard call to check for call compatibility.
872: IF NOT FND_API.Compatible_API_Call ( l_api_version,
873: p_api_version,
874: l_api_name,
875: G_PKG_NAME )
876: THEN

Line 877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

873: p_api_version,
874: l_api_name,
875: G_PKG_NAME )
876: THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:
880:
881: -- Execute the Query

Line 1068: WHEN fnd_api.g_exc_unexpected_error THEN

1064: END IF;
1065:
1066:
1067: EXCEPTION
1068: WHEN fnd_api.g_exc_unexpected_error THEN
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: IF l_exceptionlog THEN
1072: fnd_msg_pub.add_exc_msg(

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065:
1066:
1067: EXCEPTION
1068: WHEN fnd_api.g_exc_unexpected_error THEN
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070:
1071: IF l_exceptionlog THEN
1072: fnd_msg_pub.add_exc_msg(
1073: p_pkg_name => 'CST_PAC_WIP_Value_Report_PVT',

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1083: END IF;
1084: END IF;
1085:
1086: WHEN OTHERS THEN
1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1088:
1089: IF l_uLog THEN
1090: FND_LOG.STRING(
1091: FND_LOG.LEVEL_UNEXPECTED,