DBA Data[Home] [Help]

APPS.GHG_SIC_MAPPING_PKG dependencies on FND_MESSAGE

Line 74: FND_MESSAGE.SET_NAME('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');

70: CLOSE c;
71:
72: EXCEPTION
73: WHEN DUP_VAL_ON_INDEX THEN
74: FND_MESSAGE.SET_NAME('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
75: APP_EXCEPTION.RAISE_EXCEPTION;
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');

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

74: FND_MESSAGE.SET_NAME('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
75: APP_EXCEPTION.RAISE_EXCEPTION;
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
80: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
81: END IF;
82: APP_EXCEPTION.RAISE_EXCEPTION;

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

75: APP_EXCEPTION.RAISE_EXCEPTION;
76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
80: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
81: END IF;
82: APP_EXCEPTION.RAISE_EXCEPTION;
83:

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

76: WHEN OTHERS THEN
77: IF (SQLCODE <> -20001) THEN
78: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
79: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
80: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
81: END IF;
82: APP_EXCEPTION.RAISE_EXCEPTION;
83:
84: END insert_row;

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

126:
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF (SQLCODE <> -20001) THEN
130: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
131: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
132: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
133: END IF;
134: APP_EXCEPTION.RAISE_EXCEPTION;

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

127: EXCEPTION
128: WHEN OTHERS THEN
129: IF (SQLCODE <> -20001) THEN
130: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
131: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
132: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
133: END IF;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135:

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

128: WHEN OTHERS THEN
129: IF (SQLCODE <> -20001) THEN
130: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
131: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
132: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
133: END IF;
134: APP_EXCEPTION.RAISE_EXCEPTION;
135:
136: END update_row;

Line 222: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

218: AND ((recinfo.last_update_date = x_last_update_date) OR (recinfo.last_update_date IS NULL AND x_last_update_date IS NULL))
219: AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL)) ) THEN
220: NULL;
221: ELSE
222: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
223: APP_EXCEPTION.RAISE_EXCEPTION;
224: END IF;
225:
226: EXCEPTION

Line 230: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');

226: EXCEPTION
227: WHEN OTHERS THEN
228: IF (SQLCODE <> -20001) THEN
229: IF (SQLCODE = -54) THEN
230: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
231: ELSE
232: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
233: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);

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

228: IF (SQLCODE <> -20001) THEN
229: IF (SQLCODE = -54) THEN
230: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
231: ELSE
232: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
233: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
235: END IF;
236: END IF;

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

229: IF (SQLCODE = -54) THEN
230: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
231: ELSE
232: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
233: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
235: END IF;
236: END IF;
237: APP_EXCEPTION.RAISE_EXCEPTION;

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

230: FND_MESSAGE.SET_NAME('GHG', 'GHG_RESOURCE_BUSY');
231: ELSE
232: FND_MESSAGE.SET_NAME('GHG', 'GHG_DEBUG');
233: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', v_debug_info);
235: END IF;
236: END IF;
237: APP_EXCEPTION.RAISE_EXCEPTION;
238: