64: 'Entered Get_Start_Flow_Status');
65: END IF;
66:
67: -- Initialize API return status to success
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: -- Api body starts
71:
72: -- Check the required parameters
98: -- For the repair type, either the start status has
99: -- not been defined or is not active.
100: FND_MESSAGE.Set_Name('CSD', 'CSD_RT_START_STATUS_NOT_FOUND');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: -- Api body ends here
106:
114: 'Leaving Get_Start_Flow_Status');
115: END IF;
116:
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: ROLLBACK TO Get_Start_Flow_Status;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121:
122: FND_MSG_PUB.Count_And_Get
116:
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: ROLLBACK TO Get_Start_Flow_Status;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121:
122: FND_MSG_PUB.Count_And_Get
123: (p_count => x_msg_count,
124: p_data => x_msg_data );
128: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, lc_mod_name,
129: 'EXC_ERROR['||x_msg_data||']');
130: END IF;
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO Get_Start_Flow_Status;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135:
136: -- save message in fnd stack
130: END IF;
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO Get_Start_Flow_Status;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135:
136: -- save message in fnd stack
137: IF FND_MSG_PUB.Check_Msg_Level
138: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
157: END IF;
158:
159: WHEN OTHERS THEN
160: ROLLBACK TO Get_Start_Flow_Status;
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162:
163: -- save message in fnd stack
164: IF FND_MSG_PUB.Check_Msg_Level
165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)