24: G_GE_VAL CONSTANT VARCHAR2(2) := 'GE';
25: G_LT_VAL CONSTANT VARCHAR2(2) := 'LT';
26: G_LE_VAL CONSTANT VARCHAR2(2) := 'LE';
27:
28: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
29: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;
30:
31: -- entity name used by conc programs.
32: --
25: G_LT_VAL CONSTANT VARCHAR2(2) := 'LT';
26: G_LE_VAL CONSTANT VARCHAR2(2) := 'LE';
27:
28: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;
29: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;
30:
31: -- entity name used by conc programs.
32: --
33: C_ORG CONSTANT VARCHAR2(30) := 'ORGANIZATION';
67: ,p_entity_id IN NUMBER DEFAULT NULL
68: ,p_entity_index IN NUMBER DEFAULT NULL
69: ,p_entity_code IN VARCHAR2 DEFAULT NULL
70: ,p_debug_level IN NUMBER DEFAULT 0
71: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
72: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
73: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
68: ,p_entity_index IN NUMBER DEFAULT NULL
69: ,p_entity_code IN VARCHAR2 DEFAULT NULL
70: ,p_debug_level IN NUMBER DEFAULT 0
71: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
72: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
73: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
69: ,p_entity_code IN VARCHAR2 DEFAULT NULL
70: ,p_debug_level IN NUMBER DEFAULT 0
71: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
72: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
73: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
77: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
70: ,p_debug_level IN NUMBER DEFAULT 0
71: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
72: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
73: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
77: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
78: ,x_return_status OUT NOCOPY VARCHAR2
71: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
72: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
73: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
77: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
78: ,x_return_status OUT NOCOPY VARCHAR2
79: ,x_errorcode OUT NOCOPY NUMBER
72: ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
73: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE
75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
76: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
77: ,x_failed_row_id_list OUT NOCOPY VARCHAR2
78: ,x_return_status OUT NOCOPY VARCHAR2
79: ,x_errorcode OUT NOCOPY NUMBER
80: ,x_msg_count OUT NOCOPY NUMBER
151: ,x_msg_count => x_msg_count
152: ,x_msg_data => x_msg_data
153: );
154:
155: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
156: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
157: IF(l_extension_id IS NOT NULL) THEN
158: IF(l_mode = 'CREATE') THEN
159: l_operation := 'I';
168: END IF;
169: END IF;
170:
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173:
174: x_return_status := FND_API.G_RET_STS_ERROR;
175:
176: x_msg_count := ERROR_HANDLER.Get_Message_Count();
170:
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173:
174: x_return_status := FND_API.G_RET_STS_ERROR;
175:
176: x_msg_count := ERROR_HANDLER.Get_Message_Count();
177:
178: IF (x_msg_count > 0) THEN
175:
176: x_msg_count := ERROR_HANDLER.Get_Message_Count();
177:
178: IF (x_msg_count > 0) THEN
179: IF (FND_API.To_Boolean(p_log_errors)) THEN
180: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
181: ERROR_HANDLER.Log_Error(
182: p_write_err_to_inttable => 'Y'
183: ,p_write_err_to_conclog => 'Y'
176: x_msg_count := ERROR_HANDLER.Get_Message_Count();
177:
178: IF (x_msg_count > 0) THEN
179: IF (FND_API.To_Boolean(p_log_errors)) THEN
180: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN
181: ERROR_HANDLER.Log_Error(
182: p_write_err_to_inttable => 'Y'
183: ,p_write_err_to_conclog => 'Y'
184: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()
204: END IF;
205:
206: WHEN OTHERS THEN
207:
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209:
210: DECLARE
211: l_dummy_entity_index NUMBER;
212: l_dummy_entity_id VARCHAR2(60);
218: l_token_table(2).TOKEN_VALUE := l_api_name;
219: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
220: l_token_table(3).TOKEN_VALUE := SQLERRM;
221:
222: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
223: ERROR_HANDLER.Add_Error_Message(
224: p_message_name => 'EGO_PLSQL_ERR'
225: ,p_application_id => 'EGO'
226: ,p_token_tbl => l_token_table
223: ERROR_HANDLER.Add_Error_Message(
224: p_message_name => 'EGO_PLSQL_ERR'
225: ,p_application_id => 'EGO'
226: ,p_token_tbl => l_token_table
227: ,p_message_type => FND_API.G_RET_STS_ERROR
228: ,p_addto_fnd_stack => 'Y'
229: );
230: ELSE
231: ERROR_HANDLER.Add_Error_Message(
231: ERROR_HANDLER.Add_Error_Message(
232: p_message_name => 'EGO_PLSQL_ERR'
233: ,p_application_id => 'EGO'
234: ,p_token_tbl => l_token_table
235: ,p_message_type => FND_API.G_RET_STS_ERROR
236: );
237: END IF;
238:
239: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
259: ,p_entity_id IN NUMBER DEFAULT NULL
260: ,p_entity_index IN NUMBER DEFAULT NULL
261: ,p_entity_code IN VARCHAR2 DEFAULT NULL
262: ,p_debug_level IN NUMBER DEFAULT 0
263: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
264: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
265: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
266: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
267: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
260: ,p_entity_index IN NUMBER DEFAULT NULL
261: ,p_entity_code IN VARCHAR2 DEFAULT NULL
262: ,p_debug_level IN NUMBER DEFAULT 0
263: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
264: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
265: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
266: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
267: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
268: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
261: ,p_entity_code IN VARCHAR2 DEFAULT NULL
262: ,p_debug_level IN NUMBER DEFAULT 0
263: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
264: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
265: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
266: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
267: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
268: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
269: ,x_return_status OUT NOCOPY VARCHAR2
262: ,p_debug_level IN NUMBER DEFAULT 0
263: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
264: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
265: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
266: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
267: ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
268: ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
269: ,x_return_status OUT NOCOPY VARCHAR2
270: ,x_errorcode OUT NOCOPY NUMBER
313: );
314:
315:
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318:
319: x_return_status := FND_API.G_RET_STS_ERROR;
320:
321: x_msg_count := ERROR_HANDLER.Get_Message_Count();
315:
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318:
319: x_return_status := FND_API.G_RET_STS_ERROR;
320:
321: x_msg_count := ERROR_HANDLER.Get_Message_Count();
322:
323: IF (x_msg_count > 0) THEN
339: END IF;
340:
341: WHEN OTHERS THEN
342:
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344:
345: DECLARE
346: l_token_table ERROR_HANDLER.Token_Tbl_Type;
347: l_dummy_entity_index NUMBER;
354: l_token_table(2).TOKEN_VALUE := l_api_name;
355: l_token_table(3).TOKEN_NAME := 'SQL_ERR_MSG';
356: l_token_table(3).TOKEN_VALUE := SQLERRM;
357:
358: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
359: ERROR_HANDLER.Add_Error_Message(
360: p_message_name => 'EGO_PLSQL_ERR'
361: ,p_application_id => 'EGO'
362: ,p_token_tbl => l_token_table
359: ERROR_HANDLER.Add_Error_Message(
360: p_message_name => 'EGO_PLSQL_ERR'
361: ,p_application_id => 'EGO'
362: ,p_token_tbl => l_token_table
363: ,p_message_type => FND_API.G_RET_STS_ERROR
364: ,p_addto_fnd_stack => 'Y'
365: );
366: ELSE
367: ERROR_HANDLER.Add_Error_Message(
367: ERROR_HANDLER.Add_Error_Message(
368: p_message_name => 'EGO_PLSQL_ERR'
369: ,p_application_id => 'EGO'
370: ,p_token_tbl => l_token_table
371: ,p_message_type => FND_API.G_RET_STS_ERROR
372: );
373: END IF;
374:
375: ERROR_HANDLER.Get_Message(x_message_text => x_msg_data
396: * p_new_profile_id New profile Id.
397: * IN/OUT:
398: * OUT:
399: * x_return_status Return status after the call. The status can
400: * be FND_API.G_RET_STS_SUCCESS (success),
401: * FND_API.G_RET_STS_ERROR (error),
402: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
403: *
404: * NOTES
397: * IN/OUT:
398: * OUT:
399: * x_return_status Return status after the call. The status can
400: * be FND_API.G_RET_STS_SUCCESS (success),
401: * FND_API.G_RET_STS_ERROR (error),
402: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
403: *
404: * NOTES
405: *
398: * OUT:
399: * x_return_status Return status after the call. The status can
400: * be FND_API.G_RET_STS_SUCCESS (success),
401: * FND_API.G_RET_STS_ERROR (error),
402: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
403: *
404: * NOTES
405: *
406: * MODIFICATION HISTORY
658: * p_new_profile_id New profile Id.
659: * IN/OUT:
660: * OUT:
661: * x_return_status Return status after the call. The status can
662: * be FND_API.G_RET_STS_SUCCESS (success),
663: * FND_API.G_RET_STS_ERROR (error),
664: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
665: *
666: * NOTES
659: * IN/OUT:
660: * OUT:
661: * x_return_status Return status after the call. The status can
662: * be FND_API.G_RET_STS_SUCCESS (success),
663: * FND_API.G_RET_STS_ERROR (error),
664: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
665: *
666: * NOTES
667: *
660: * OUT:
661: * x_return_status Return status after the call. The status can
662: * be FND_API.G_RET_STS_SUCCESS (success),
663: * FND_API.G_RET_STS_ERROR (error),
664: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
665: *
666: * NOTES
667: *
668: * MODIFICATION HISTORY