DBA Data[Home] [Help]

APPS.GHG_ORGANIZATION_MAPPINGS_PKG dependencies on FND_MESSAGE

Line 202: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_FLEX_MAPPING');

198: WHEN NO_DATA_FOUND THEN
199: IF x_calling_mode = 'BATCH' THEN
200: RETURN -1;
201: ELSE
202: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_FLEX_MAPPING');
203:
204: FND_MESSAGE.SET_TOKEN('DETAILS', v_flexfield);
205: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
206: APP_EXCEPTION.RAISE_EXCEPTION;

Line 204: FND_MESSAGE.SET_TOKEN('DETAILS', v_flexfield);

200: RETURN -1;
201: ELSE
202: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_FLEX_MAPPING');
203:
204: FND_MESSAGE.SET_TOKEN('DETAILS', v_flexfield);
205: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
206: APP_EXCEPTION.RAISE_EXCEPTION;
207: END IF;
208: WHEN OTHERS THEN

Line 205: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);

201: ELSE
202: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_FLEX_MAPPING');
203:
204: FND_MESSAGE.SET_TOKEN('DETAILS', v_flexfield);
205: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
206: APP_EXCEPTION.RAISE_EXCEPTION;
207: END IF;
208: WHEN OTHERS THEN
209: IF x_calling_mode = 'BATCH' THEN

Line 213: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');

209: IF x_calling_mode = 'BATCH' THEN
210: RETURN -1;
211: ELSE
212: IF (SQLCODE <> -20001) THEN
213: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
214: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
215: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
216: END IF;
217: APP_EXCEPTION.RAISE_EXCEPTION;

Line 214: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

210: RETURN -1;
211: ELSE
212: IF (SQLCODE <> -20001) THEN
213: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
214: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
215: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
216: END IF;
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: END IF;

Line 215: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);

211: ELSE
212: IF (SQLCODE <> -20001) THEN
213: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
214: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
215: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
216: END IF;
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: END IF;
219:

Line 246: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_PRJ_MAPPING');

242: RETURN v_ghg_organization_id;
243:
244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_PRJ_MAPPING');
247:
248: FND_MESSAGE.SET_TOKEN('DETAILS', x_project_number || '/' || x_task_number);
249: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
250: APP_EXCEPTION.RAISE_EXCEPTION;

Line 248: FND_MESSAGE.SET_TOKEN('DETAILS', x_project_number || '/' || x_task_number);

244: EXCEPTION
245: WHEN NO_DATA_FOUND THEN
246: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_PRJ_MAPPING');
247:
248: FND_MESSAGE.SET_TOKEN('DETAILS', x_project_number || '/' || x_task_number);
249: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
250: APP_EXCEPTION.RAISE_EXCEPTION;
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN

Line 249: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);

245: WHEN NO_DATA_FOUND THEN
246: FND_MESSAGE.SET_NAME('GHG', 'GHG_CANNOT_FIND_PRJ_MAPPING');
247:
248: FND_MESSAGE.SET_TOKEN('DETAILS', x_project_number || '/' || x_task_number);
249: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
250: APP_EXCEPTION.RAISE_EXCEPTION;
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');

Line 253: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');

249: FND_MESSAGE.SET_TOKEN('DIST_LINE_NUM', x_distribution_line_number);
250: APP_EXCEPTION.RAISE_EXCEPTION;
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
256: END IF;
257: APP_EXCEPTION.RAISE_EXCEPTION;

Line 254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);

250: APP_EXCEPTION.RAISE_EXCEPTION;
251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
256: END IF;
257: APP_EXCEPTION.RAISE_EXCEPTION;
258:

Line 255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);

251: WHEN OTHERS THEN
252: IF (SQLCODE <> -20001) THEN
253: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
254: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
255: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
256: END IF;
257: APP_EXCEPTION.RAISE_EXCEPTION;
258:
259: END;