1441: END;
1442: EXCEPTION WHEN WF_ERROR THEN
1443: BEGIN
1444: IF data_string = 'SQL_ERROR' THEN
1445: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_SQL_ERR');
1446: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_SQL_ERR');
1447: ELSIF data_string = 'MULTI_ROWS_ERROR' THEN
1448: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1449: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1442: EXCEPTION WHEN WF_ERROR THEN
1443: BEGIN
1444: IF data_string = 'SQL_ERROR' THEN
1445: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_SQL_ERR');
1446: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_SQL_ERR');
1447: ELSIF data_string = 'MULTI_ROWS_ERROR' THEN
1448: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1449: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1450: ELSIF data_string = 'PROFILE_ERROR' THEN
1444: IF data_string = 'SQL_ERROR' THEN
1445: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_SQL_ERR');
1446: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_SQL_ERR');
1447: ELSIF data_string = 'MULTI_ROWS_ERROR' THEN
1448: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1449: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1450: ELSIF data_string = 'PROFILE_ERROR' THEN
1451: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_PROF_ERR');
1452: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_PROF_ERR');
1445: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_SQL_ERR');
1446: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_SQL_ERR');
1447: ELSIF data_string = 'MULTI_ROWS_ERROR' THEN
1448: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1449: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1450: ELSIF data_string = 'PROFILE_ERROR' THEN
1451: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_PROF_ERR');
1452: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_PROF_ERR');
1453: END IF;
1447: ELSIF data_string = 'MULTI_ROWS_ERROR' THEN
1448: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1449: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1450: ELSIF data_string = 'PROFILE_ERROR' THEN
1451: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_PROF_ERR');
1452: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_PROF_ERR');
1453: END IF;
1454: END;
1455: WF_CORE.CONTEXT ('gma_wfstd_p','WF_GET_CONTORL_PARAMS',P_WF_ITEM_TYPE,P_PROCESS_NAME,P_ACTIVITY_NAME,error_message);
1448: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1449: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_MULTI_ROW_ERR');
1450: ELSIF data_string = 'PROFILE_ERROR' THEN
1451: error_message := FND_MESSAGE.GET_STRING('GMA','GMA_WF_CTRL_PROF_ERR');
1452: FND_MESSAGE.SET_NAME('GMA','GMA_WF_CTRL_PROF_ERR');
1453: END IF;
1454: END;
1455: WF_CORE.CONTEXT ('gma_wfstd_p','WF_GET_CONTORL_PARAMS',P_WF_ITEM_TYPE,P_PROCESS_NAME,P_ACTIVITY_NAME,error_message);
1456: app_exception.raise_exception;