DBA Data[Home] [Help]

APPS.CST_EAM_WORKORDERS_PVT dependencies on FND_API

Line 71: p_init_msg_list => FND_API.G_FALSE,

67: -- Generate XML data for displaying the report parameters values
68: -----------------------------------------------------------------
69: l_stmt_num := 20;
70: Display_Parameters (p_api_version => 1.0,
71: p_init_msg_list => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
73: x_return_status => l_return_status,
74: x_msg_count => l_msg_count,
75: x_msg_data => l_msg_data,

Line 72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

68: -----------------------------------------------------------------
69: l_stmt_num := 20;
70: Display_Parameters (p_api_version => 1.0,
71: p_init_msg_list => FND_API.G_FALSE,
72: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
73: x_return_status => l_return_status,
74: x_msg_count => l_msg_count,
75: x_msg_data => l_msg_data,
76: p_legal_entity_id => p_legal_entity_id,

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

82: p_specific_workorder => p_specific_workorder,
83: x_xml_doc => l_xml_doc);
84:
85: -- If return status is not success, add message to the log
86: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
87: l_msg_data := 'Failed generating XML data for report parameter information';
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84:
85: -- If return status is not success, add message to the log
86: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
87: l_msg_data := 'Failed generating XML data for report parameter information';
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: ------------------------------------------------------------------------------------
92: -- Generate Estimation, Actuals data for workoder for given Cost Type and Cost Group

Line 96: p_init_msg_list => FND_API.G_FALSE,

92: -- Generate Estimation, Actuals data for workoder for given Cost Type and Cost Group
93: ------------------------------------------------------------------------------------
94: l_stmt_num := 30;
95: eAM_Est_Actual_details (p_api_version => 1.0,
96: p_init_msg_list => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: x_return_status => l_return_status,
99: x_msg_count => l_msg_count,
100: x_msg_data => l_msg_data,

Line 97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

93: ------------------------------------------------------------------------------------
94: l_stmt_num := 30;
95: eAM_Est_Actual_details (p_api_version => 1.0,
96: p_init_msg_list => FND_API.G_FALSE,
97: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
98: x_return_status => l_return_status,
99: x_msg_count => l_msg_count,
100: x_msg_data => l_msg_data,
101: p_legal_entity_id => p_legal_entity_id,

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

107: p_specific_workorder => p_specific_workorder,
108: x_xml_doc => l_xml_doc);
109:
110: -- If return status is not success, add message to the log
111: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
112: l_msg_data := 'Failed generating Workorder Estimation, Actuals details';
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109:
110: -- If return status is not success, add message to the log
111: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
112: l_msg_data := 'Failed generating Workorder Estimation, Actuals details';
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: -- Append the XML end tag
117: l_stmt_num := 40;

Line 153: WHEN fnd_api.g_exc_unexpected_error THEN

149: );
150: END IF;
151:
152: EXCEPTION
153: WHEN fnd_api.g_exc_unexpected_error THEN
154: -- Set return status to error
155: l_msg_data := SUBSTRB (SQLERRM,1,240);
156: l_success := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_msg_data);
157:

Line 247: IF NOT FND_API.Compatible_API_Call (l_api_version,

243: );
244: END IF;
245:
246: l_stmt_num := 0;
247: IF NOT FND_API.Compatible_API_Call (l_api_version,
248: p_api_version,
249: l_api_name,
250: G_PKG_NAME )
251: THEN

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248: p_api_version,
249: l_api_name,
250: G_PKG_NAME )
251: THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255: -- Initialize API return status to success
256: l_stmt_num := 10;

Line 257: x_return_status := FND_API.G_RET_STS_SUCCESS;

253: END IF;
254:
255: -- Initialize API return status to success
256: l_stmt_num := 10;
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258:
259: -- Create CLOB object to store the XML data
260: l_stmt_num := 20;
261: DBMS_LOB.createtemporary(l_xml_temp, TRUE);

Line 368: WHEN fnd_api.g_exc_unexpected_error THEN

364: 'x_msg_data = '||x_msg_data
365: );
366: END IF;
367: EXCEPTION
368: WHEN fnd_api.g_exc_unexpected_error THEN
369: IF l_exceptionlog THEN
370: fnd_msg_pub.add_exc_msg(
371: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
372: p_procedure_name => 'Display_Parameters',

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: END IF;
446:
447: -- Initialize API return status to success
448: l_stmt_num := 10;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: --Create the CLOB object to store XML data
452: l_stmt_num := 15;
453: l_offset := 21;

Line 458: IF NOT FND_API.Compatible_API_Call ( l_api_version,

454: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
455:
456: -- Standard call to check for call compatibility.
457: l_stmt_num := 20;
458: IF NOT FND_API.Compatible_API_Call ( l_api_version,
459: p_api_version,
460: l_api_name,
461: G_PKG_NAME )
462: THEN

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: p_api_version,
460: l_api_name,
461: G_PKG_NAME )
462: THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465:
466: /* 1 - ALL , 2 - Specific 3 - Range */
467: l_stmt_num := 30;

Line 644: WHEN fnd_api.g_exc_unexpected_error THEN

640: );
641: END IF;
642:
643: EXCEPTION
644: WHEN fnd_api.g_exc_unexpected_error THEN
645: IF l_exceptionlog THEN
646: fnd_msg_pub.add_exc_msg(
647: p_pkg_name => 'CST_eAM_WorkOrders_PVT',
648: p_procedure_name => 'eAM_Est_Actual_details',