DBA Data[Home] [Help]

APPS.HZ_EXTENSIBILITY_PVT dependencies on FND_API

Line 28: G_TRUE CONSTANT VARCHAR2(1) := 'T'; -- FND_API.G_TRUE;

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: --

Line 29: G_FALSE CONSTANT VARCHAR2(1) := 'F'; -- FND_API.G_FALSE;

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';

Line 71: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 72: ,p_write_to_concurrent_log 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

Line 73: ,p_init_fnd_msg_list 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

Line 74: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 75: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 76: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 155: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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';

Line 172: WHEN FND_API.G_EXC_ERROR THEN

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();

Line 174: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 179: IF (FND_API.To_Boolean(p_log_errors)) 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'

Line 180: IF (FND_API.To_Boolean(p_write_to_concurrent_log)) THEN

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()

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);

Line 222: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN

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

Line 227: ,p_message_type => FND_API.G_RET_STS_ERROR

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(

Line 235: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 263: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

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

Line 264: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 265: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 266: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

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

Line 317: WHEN FND_API.G_EXC_ERROR THEN

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();

Line 319: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 358: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN

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

Line 363: ,p_message_type => FND_API.G_RET_STS_ERROR

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(

Line 371: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 400: * be FND_API.G_RET_STS_SUCCESS (success),

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

Line 401: * FND_API.G_RET_STS_ERROR (error),

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: *

Line 402: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

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

Line 662: * be FND_API.G_RET_STS_SUCCESS (success),

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

Line 663: * FND_API.G_RET_STS_ERROR (error),

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: *

Line 664: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

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