APPS.CSM_HA_EVENT_PKG dependencies on FND_API

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: dbms_xmlgen.closeContext(qrycontext);
52:
53: x_XML_CONTEXT := l_xml;
54:
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56: x_error_message := 'XML Retrieving Successfully completed ';
57: CSM_UTIL_PKG.LOG
58: ( 'Leaving GET_XML_PAYLOAD after successfully Executing Query-> ' || l_QUERY_TEXT1 , 'CSM_HA_EVENT_PKG.GET_XML_PAYLOAD',
59: FND_LOG.LEVEL_PROCEDURE);

Line 67: x_return_status := FND_API.G_RET_STS_ERROR;

63: /*** catch and log exceptions ***/
64: CSM_UTIL_PKG.LOG
65: ( 'Exception occurred in GET_XML_PAYLOAD for Query : ' || l_QUERY_TEXT1 || SUBSTR(SQLERRM,1,3000), 'CSM_HA_EVENT_PKG.GET_XML_PAYLOAD',
66: FND_LOG.LEVEL_EXCEPTION);
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_error_message := 'XML Retrieve Failed With Message : ' || SUBSTR(SQLERRM,1,3000) ;
69: END GET_XML_PAYLOAD;
70:
71: FUNCTION get_stringfrom_list (pk_list IN CSM_VARCHAR_LIST)

Line 1057: x_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1053: IS
1054: l_module VARCHAR2(500) :='Init';
1055: BEGIN
1056:
1057: x_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1058: x_ERROR_MESSAGE := 'HA Recording Successfully Started';
1059:
1060: IF GET_HA_PROFILE_VALUE = 'HA_RECORD' THEN
1061: CSM_UTIL_PKG.LOG( 'Call End HA Tracking to end existing session.',

Line 1063: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1059:
1060: IF GET_HA_PROFILE_VALUE = 'HA_RECORD' THEN
1061: CSM_UTIL_PKG.LOG( 'Call End HA Tracking to end existing session.',
1062: 'CSM_HA_EVENT_PKG.BEGIN_HA_TRACKING', FND_LOG.LEVEL_PROCEDURE);
1063: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1064: x_ERROR_MESSAGE := 'Another Start HA Recording session is already in progress.';
1065: RETURN;
1066: END IF;
1067:

Line 1120: x_return_status := FND_API.G_RET_STS_ERROR;

1116: /*** catch and log exceptions ***/
1117: CSM_UTIL_PKG.LOG
1118: ( 'Exception occurred in BEGIN_HA_TRACKING while '||l_module||':'|| SUBSTR(SQLERRM,1,3000), 'CSM_HA_EVENT_PKG.BEGIN_HA_TRACKING',
1119: FND_LOG.LEVEL_EXCEPTION);
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121: x_error_message := 'BEGIN_HA_TRACKING failed while '||l_module||' with error:' || SUBSTR(SQLERRM,1,3000) ;
1122: ROLLBACK;
1123: SET_HA_PROFILE('HA_STOP');
1124: RAISE;

Line 1133: x_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1129: IS
1130: l_module VARCHAR2(500):='Init';
1131: BEGIN
1132:
1133: x_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1134: x_ERROR_MESSAGE := 'Stop HA Recording Successfully Completed';
1135: G_IS_END_TRACKING_CALL := TRUE;
1136:
1137: /*to limit concurrent requests: setting profile first */

Line 1141: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1137: /*to limit concurrent requests: setting profile first */
1138: IF GET_HA_PROFILE_VALUE = 'HA_STOP' THEN
1139: CSM_UTIL_PKG.LOG('Another End recording is already in progress..',
1140: 'CSM_HA_EVENT_PKG.END_HA_TRACKING', FND_LOG.LEVEL_PROCEDURE);
1141: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1142: x_ERROR_MESSAGE := 'Another Stop HA Recording is already in progress..';
1143: RETURN;
1144: END IF;
1145:

Line 1183: x_return_status := FND_API.G_RET_STS_ERROR;

1179: /*** catch and log exceptions ***/
1180: CSM_UTIL_PKG.LOG
1181: ( 'Exception occurred in END_HA_TRACKING while '||l_module||':'|| SUBSTR(SQLERRM,1,3000), 'CSM_HA_EVENT_PKG.END_HA_TRACKING',
1182: FND_LOG.LEVEL_EXCEPTION);
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: x_error_message := 'END_HA_TRACKING failed while '||l_module||' with error:' || SUBSTR(SQLERRM,1,3000) ;
1185: ROLLBACK;
1186: G_IS_END_TRACKING_CALL := FALSE;
1187: SET_HA_PROFILE('HA_RECORD');

Line 1397: IF(l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN

1393: END IF;
1394:
1395: GET_XML_PAYLOAD(p_TABLE_NAME,p_PK_NAME_LIST,p_PK_TYPE_LIST,p_PK_VALUE_LIST,l_XML_PAYLOAD,l_XML_CONTEXT,l_RETURN_STATUS,l_ERROR_MESSAGE);
1396:
1397: IF(l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS) THEN
1398: RAISE_APPLICATION_ERROR(-20222,'HA Tracking failed :'||l_ERROR_MESSAGE);
1399: ELSE
1400: IF (l_XML_PAYLOAD IS NULL) THEN
1401: CSM_UTIL_PKG.LOG('PAYLOAD IS NULL', 'CSM_HA_EVENT_PKG.TRACK_HA_RECORD',FND_LOG.LEVEL_PROCEDURE);