eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EGO_USER_ATTRS_BULK_PVT dependencies on FND_API

Line 202: l_null_char_value := FND_API.G_MISS_CHAR;

198: IF NVL(p_entity_index,0) <> 0 THEN
199: RETURN p_entity_index;
200: ELSE
201: l_entity_index := NULL;
202: l_null_char_value := FND_API.G_MISS_CHAR;
203: l_pk_col_rec.pk_col_1 := NVL(p_instance_pk1_value, l_null_char_value);
204: l_pk_col_rec.pk_col_2 := NVL(p_instance_pk2_value, l_null_char_value);
205: l_pk_col_rec.pk_col_3 := NVL(p_instance_pk3_value, l_null_char_value);
206: l_pk_col_rec.pk_col_4 := NVL(p_instance_pk4_value, l_null_char_value);

Line 380: ,p_message_type => FND_API.G_RET_STS_ERROR

376: ERROR_HANDLER.Add_Error_Message
377: (p_message_name => l_err_msg_name
378: ,p_application_id =>'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
379: ,p_token_tbl => l_err_token_table
380: ,p_message_type => FND_API.G_RET_STS_ERROR
381: ,p_row_identifier => error_rec.TRANSACTION_ID
382: ,p_entity_id => G_ENTITY_ID
383: ,p_entity_index => l_entity_index
384: ,p_table_name => p_interface_table_name

Line 401: ,p_message_type => FND_API.G_RET_STS_ERROR

397: ERROR_HANDLER.Add_Error_Message
398: (p_message_name => l_err_msg_name
399: ,p_application_id =>'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
400: ,p_token_tbl => l_err_token_table
401: ,p_message_type => FND_API.G_RET_STS_ERROR
402: ,p_row_identifier => error_rec.TRANSACTION_ID
403: ,p_entity_id => G_ENTITY_ID
404: ,p_entity_index => l_entity_index
405: ,p_table_name => p_interface_table_name

Line 422: ,p_message_type => FND_API.G_RET_STS_ERROR

418: ERROR_HANDLER.Add_Error_Message
419: (p_message_name => l_err_msg_name
420: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
421: ,p_token_tbl => l_err_token_table
422: ,p_message_type => FND_API.G_RET_STS_ERROR
423: ,p_row_identifier => error_rec.TRANSACTION_ID
424: ,p_entity_id => G_ENTITY_ID
425: ,p_entity_index => l_entity_index
426: ,p_table_name => p_interface_table_name

Line 443: ,p_message_type => FND_API.G_RET_STS_ERROR

439: ERROR_HANDLER.Add_Error_Message
440: (p_message_name => l_err_msg_name
441: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
442: ,p_token_tbl => l_err_token_table
443: ,p_message_type => FND_API.G_RET_STS_ERROR
444: ,p_row_identifier => error_rec.TRANSACTION_ID
445: ,p_entity_id => G_ENTITY_ID
446: ,p_entity_index => l_entity_index
447: ,p_table_name => p_interface_table_name

Line 481: ,p_message_type => FND_API.G_RET_STS_ERROR

477: ERROR_HANDLER.Add_Error_Message
478: (p_message_name => l_err_msg_name
479: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
480: ,p_token_tbl => l_err_token_table
481: ,p_message_type => FND_API.G_RET_STS_ERROR
482: ,p_row_identifier => error_rec.TRANSACTION_ID
483: ,p_entity_id => G_ENTITY_ID
484: ,p_entity_index => l_entity_index
485: ,p_table_name => p_interface_table_name

Line 511: ,p_message_type => FND_API.G_RET_STS_ERROR

507: ERROR_HANDLER.Add_Error_Message
508: (p_message_name => l_err_msg_name
509: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
510: ,p_token_tbl => l_err_token_table
511: ,p_message_type => FND_API.G_RET_STS_ERROR
512: ,p_row_identifier => error_rec.TRANSACTION_ID
513: ,p_entity_id => G_ENTITY_ID
514: ,p_entity_index => l_entity_index
515: ,p_table_name => p_interface_table_name

Line 540: ,p_message_type => FND_API.G_RET_STS_ERROR

536: ERROR_HANDLER.Add_Error_Message
537: (p_message_name => l_err_msg_name
538: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
539: ,p_token_tbl => l_err_token_table
540: ,p_message_type => FND_API.G_RET_STS_ERROR
541: ,p_row_identifier => error_rec.TRANSACTION_ID
542: ,p_entity_id => G_ENTITY_ID
543: ,p_entity_index => l_entity_index
544: ,p_table_name => p_interface_table_name

Line 566: ,p_message_type => FND_API.G_RET_STS_ERROR

562: ERROR_HANDLER.Add_Error_Message
563: (p_message_name => l_err_msg_name
564: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
565: ,p_token_tbl => l_err_token_table
566: ,p_message_type => FND_API.G_RET_STS_ERROR
567: ,p_row_identifier => error_rec.TRANSACTION_ID
568: ,p_entity_id => G_ENTITY_ID
569: ,p_entity_index => l_entity_index
570: ,p_table_name => p_interface_table_name

Line 591: ,p_message_type => FND_API.G_RET_STS_ERROR

587: ERROR_HANDLER.Add_Error_Message
588: (p_message_name => l_err_msg_name
589: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
590: ,p_token_tbl => l_err_token_table
591: ,p_message_type => FND_API.G_RET_STS_ERROR
592: ,p_row_identifier => error_rec.TRANSACTION_ID
593: ,p_entity_id => G_ENTITY_ID
594: ,p_entity_index => l_entity_index
595: ,p_table_name => p_interface_table_name

Line 616: ,p_message_type => FND_API.G_RET_STS_ERROR

612: ERROR_HANDLER.Add_Error_Message
613: (p_message_name => l_err_msg_name
614: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
615: ,p_token_tbl => l_err_token_table
616: ,p_message_type => FND_API.G_RET_STS_ERROR
617: ,p_row_identifier => error_rec.TRANSACTION_ID
618: ,p_entity_id => G_ENTITY_ID
619: ,p_entity_index => l_entity_index
620: ,p_table_name => p_interface_table_name

Line 641: ,p_message_type => FND_API.G_RET_STS_ERROR

637: ERROR_HANDLER.Add_Error_Message
638: (p_message_name => l_err_msg_name
639: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
640: ,p_token_tbl => l_err_token_table
641: ,p_message_type => FND_API.G_RET_STS_ERROR
642: ,p_row_identifier => error_rec.TRANSACTION_ID
643: ,p_entity_id => G_ENTITY_ID
644: ,p_entity_index => l_entity_index
645: ,p_table_name => p_interface_table_name

Line 674: ,p_message_type => FND_API.G_RET_STS_ERROR

670: ERROR_HANDLER.Add_Error_Message
671: (p_message_name => l_err_msg_name
672: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
673: ,p_token_tbl => l_err_token_table
674: ,p_message_type => FND_API.G_RET_STS_ERROR
675: ,p_row_identifier => error_rec.TRANSACTION_ID
676: ,p_entity_id => G_ENTITY_ID
677: ,p_entity_index => l_entity_index
678: ,p_table_name => p_interface_table_name

Line 693: ,p_message_type => FND_API.G_RET_STS_ERROR

689: ERROR_HANDLER.Add_Error_Message
690: (p_message_name => l_err_msg_name
691: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
692: ,p_token_tbl => l_err_token_table
693: ,p_message_type => FND_API.G_RET_STS_ERROR
694: ,p_row_identifier => error_rec.TRANSACTION_ID
695: ,p_entity_id => G_ENTITY_ID
696: ,p_entity_index => l_entity_index
697: ,p_table_name => p_interface_table_name

Line 738: ,p_message_type => FND_API.G_RET_STS_ERROR

734: ERROR_HANDLER.Add_Error_Message
735: (p_message_name => l_err_msg_name
736: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
737: ,p_token_tbl => l_err_token_table
738: ,p_message_type => FND_API.G_RET_STS_ERROR
739: ,p_row_identifier => error_rec.TRANSACTION_ID
740: ,p_entity_id => G_ENTITY_ID
741: ,p_entity_index => l_entity_index
742: ,p_table_name => p_interface_table_name

Line 757: ,p_message_type => FND_API.G_RET_STS_ERROR

753: ERROR_HANDLER.Add_Error_Message
754: (p_message_name => l_err_msg_name
755: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
756: ,p_token_tbl => l_err_token_table
757: ,p_message_type => FND_API.G_RET_STS_ERROR
758: ,p_row_identifier => error_rec.TRANSACTION_ID
759: ,p_entity_id => G_ENTITY_ID
760: ,p_entity_index => l_entity_index
761: ,p_table_name => p_interface_table_name

Line 778: ,p_message_type => FND_API.G_RET_STS_ERROR

774: ERROR_HANDLER.Add_Error_Message
775: (p_message_name => l_err_msg_name
776: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
777: ,p_token_tbl => l_err_token_table
778: ,p_message_type => FND_API.G_RET_STS_ERROR
779: ,p_row_identifier => error_rec.TRANSACTION_ID
780: ,p_entity_id => G_ENTITY_ID
781: ,p_entity_index => l_entity_index
782: ,p_table_name => p_interface_table_name

Line 806: ,p_message_type => FND_API.G_RET_STS_ERROR

802: ERROR_HANDLER.Add_Error_Message
803: (p_message_name => l_err_msg_name
804: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
805: ,p_token_tbl => l_err_token_table
806: ,p_message_type => FND_API.G_RET_STS_ERROR
807: ,p_row_identifier => error_rec.TRANSACTION_ID
808: ,p_entity_id => G_ENTITY_ID
809: ,p_entity_index => l_entity_index
810: ,p_table_name => p_interface_table_name

Line 842: ,p_message_type => FND_API.G_RET_STS_ERROR

838: ERROR_HANDLER.Add_Error_Message
839: (p_message_name => l_err_msg_name
840: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
841: ,p_token_tbl => l_err_token_table
842: ,p_message_type => FND_API.G_RET_STS_ERROR
843: ,p_row_identifier => error_rec.TRANSACTION_ID
844: ,p_entity_id => G_ENTITY_ID
845: ,p_entity_index => l_entity_index
846: ,p_table_name => p_interface_table_name

Line 909: ,p_message_type => FND_API.G_RET_STS_ERROR

905: ERROR_HANDLER.Add_Error_Message
906: (p_message_name => l_err_msg_name
907: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
908: ,p_token_tbl => l_err_token_table
909: ,p_message_type => FND_API.G_RET_STS_ERROR
910: ,p_row_identifier => error_rec.TRANSACTION_ID
911: ,p_entity_id => G_ENTITY_ID
912: ,p_entity_index => l_entity_index
913: ,p_table_name => p_interface_table_name

Line 939: ,p_message_type => FND_API.G_RET_STS_ERROR

935: ERROR_HANDLER.Add_Error_Message
936: (p_message_name => l_err_msg_name
937: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
938: ,p_token_tbl => l_err_token_table
939: ,p_message_type => FND_API.G_RET_STS_ERROR
940: ,p_row_identifier => error_rec.TRANSACTION_ID
941: ,p_entity_id => G_ENTITY_ID
942: ,p_entity_index => l_entity_index
943: ,p_table_name => p_interface_table_name

Line 976: ,p_message_type => FND_API.G_RET_STS_ERROR

972: ERROR_HANDLER.Add_Error_Message
973: (p_message_name => l_err_msg_name
974: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
975: ,p_token_tbl => l_err_token_table
976: ,p_message_type => FND_API.G_RET_STS_ERROR
977: ,p_row_identifier => error_rec.TRANSACTION_ID
978: ,p_entity_id => G_ENTITY_ID
979: ,p_entity_index => l_entity_index
980: ,p_table_name => p_interface_table_name

Line 998: ,p_message_type => FND_API.G_RET_STS_ERROR

994: ERROR_HANDLER.Add_Error_Message
995: (p_message_name => l_err_msg_name
996: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
997: ,p_token_tbl => l_err_token_table
998: ,p_message_type => FND_API.G_RET_STS_ERROR
999: ,p_row_identifier => error_rec.TRANSACTION_ID
1000: ,p_entity_id => G_ENTITY_ID
1001: ,p_entity_index => l_entity_index
1002: ,p_table_name => p_interface_table_name

Line 1019: ,p_message_type => FND_API.G_RET_STS_ERROR

1015: ERROR_HANDLER.Add_Error_Message
1016: (p_message_name => l_err_msg_name
1017: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
1018: ,p_token_tbl => l_err_token_table
1019: ,p_message_type => FND_API.G_RET_STS_ERROR
1020: ,p_row_identifier => error_rec.TRANSACTION_ID
1021: ,p_entity_id => G_ENTITY_ID
1022: ,p_entity_index => l_entity_index
1023: ,p_table_name => p_interface_table_name

Line 1038: ,p_message_type => FND_API.G_RET_STS_ERROR

1034: ERROR_HANDLER.Add_Error_Message
1035: (p_message_name => l_err_msg_name
1036: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
1037: ,p_token_tbl => l_err_token_table
1038: ,p_message_type => FND_API.G_RET_STS_ERROR
1039: ,p_row_identifier => error_rec.TRANSACTION_ID
1040: ,p_entity_id => G_ENTITY_ID
1041: ,p_entity_index => l_entity_index
1042: ,p_table_name => p_interface_table_name

Line 1057: ,p_message_type => FND_API.G_RET_STS_ERROR

1053: ERROR_HANDLER.Add_Error_Message
1054: (p_message_name => l_err_msg_name
1055: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
1056: ,p_token_tbl => l_err_token_table
1057: ,p_message_type => FND_API.G_RET_STS_ERROR
1058: ,p_row_identifier => error_rec.TRANSACTION_ID
1059: ,p_entity_id => G_ENTITY_ID
1060: ,p_entity_index => l_entity_index
1061: ,p_table_name => p_interface_table_name

Line 1079: ,p_message_type => FND_API.G_RET_STS_ERROR

1075: ERROR_HANDLER.Add_Error_Message
1076: (p_message_name => l_err_msg_name
1077: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
1078: ,p_token_tbl => l_err_token_table
1079: ,p_message_type => FND_API.G_RET_STS_ERROR
1080: ,p_row_identifier => error_rec.TRANSACTION_ID
1081: ,p_entity_id => G_ENTITY_ID
1082: ,p_entity_index => l_entity_index
1083: ,p_table_name => p_interface_table_name

Line 1100: ,p_message_type => FND_API.G_RET_STS_ERROR

1096: ERROR_HANDLER.Add_Error_Message
1097: (p_message_name => l_err_msg_name
1098: ,p_application_id => 'EGO'--Bug 7507091 Orig value: G_APPLICATION_CONTEXT
1099: ,p_token_tbl => l_err_token_table
1100: ,p_message_type => FND_API.G_RET_STS_ERROR
1101: ,p_row_identifier => error_rec.TRANSACTION_ID
1102: ,p_entity_id => G_ENTITY_ID
1103: ,p_entity_index => l_entity_index
1104: ,p_table_name => p_interface_table_name

Line 1302: x_return_status := FND_API.G_RET_STS_SUCCESS;

1298: x_dynamic_sql_v_type := l_dynamic_sql_v_type;
1299:
1300: code_debug(' Preparing l_dynamic_sql_v_type is done ' ,3);
1301:
1302: x_return_status := FND_API.G_RET_STS_SUCCESS;
1303: code_debug(l_api_name||' Done ',0);
1304: EXCEPTION
1305: WHEN OTHERS THEN
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1302: x_return_status := FND_API.G_RET_STS_SUCCESS;
1303: code_debug(l_api_name||' Done ',0);
1304: EXCEPTION
1305: WHEN OTHERS THEN
1306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1307: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' - '||SQLERRM;
1308: code_debug(' When others block - '||x_msg_data ,3);
1309:
1310: l_dynamic_sql :=

Line 1323: ,p_message_type => FND_API.G_RET_STS_ERROR

1319: ERROR_HANDLER.Add_Error_Message(
1320: p_message_text => x_msg_data
1321: ,p_row_identifier => l_dummy
1322: ,p_application_id => 'EGO'
1323: ,p_message_type => FND_API.G_RET_STS_ERROR
1324: ,p_entity_id => G_ENTITY_ID
1325: ,p_table_name => p_interface_table_name
1326: ,p_entity_code => G_ENTITY_CODE
1327: );

Line 1354: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

1350: ,p_entity_id IN NUMBER DEFAULT NULL
1351: ,p_entity_index IN NUMBER DEFAULT NULL
1352: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1353: ,p_debug_level IN NUMBER DEFAULT 0
1354: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1356: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 1355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1351: ,p_entity_index IN NUMBER DEFAULT NULL
1352: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1353: ,p_debug_level IN NUMBER DEFAULT 0
1354: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1356: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1359: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 1356: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

1352: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1353: ,p_debug_level IN NUMBER DEFAULT 0
1354: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1356: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1359: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1360: ,p_default_dl_edit_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 1357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

1353: ,p_debug_level IN NUMBER DEFAULT 0
1354: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1356: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1359: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1360: ,p_default_dl_edit_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1361: ,p_default_view_privilege IN VARCHAR2 DEFAULT NULL

Line 1358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1354: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1355: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1356: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1357: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1358: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1359: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1360: ,p_default_dl_edit_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1361: ,p_default_view_privilege IN VARCHAR2 DEFAULT NULL
1362: ,p_default_edit_privilege IN VARCHAR2 DEFAULT NULL

Line 1760: IF FND_API.To_Boolean(p_commit) THEN

1756: BEGIN
1757: code_debug(l_api_name|| 'Starting ');
1758:
1759: -- Standard start of API savepoint
1760: IF FND_API.To_Boolean(p_commit) THEN
1761: SAVEPOINT Bulk_Load_User_Attrs_Data_PVT;
1762: END IF;
1763:
1764: -- Check for call compatibility

Line 1765: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1761: SAVEPOINT Bulk_Load_User_Attrs_Data_PVT;
1762: END IF;
1763:
1764: -- Check for call compatibility
1765: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1766: l_api_name, G_PKG_NAME)
1767: THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;

Line 1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1764: -- Check for call compatibility
1765: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1766: l_api_name, G_PKG_NAME)
1767: THEN
1768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1769: END IF;
1770:
1771: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1772: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

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

1784: AND DATA_LEVEL_NAME = 'ITEM_REVISION_LEVEL';
1785: ---------------------------------
1786: -- Error Handler Initialization --
1787: ---------------------------------
1788: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
1789: G_ADD_ERRORS_TO_FND_STACK := 'Y';
1790: ELSE
1791: G_ADD_ERRORS_TO_FND_STACK := 'N';
1792: END IF;

Line 1803: IF FND_API.To_Boolean(p_init_fnd_msg_list) THEN

1799: WHEN OTHERS THEN
1800: G_APPLICATION_CONTEXT := p_application_id;
1801: END;
1802: -- Initialize message list even though we don't currently use it
1803: IF FND_API.To_Boolean(p_init_fnd_msg_list) THEN
1804: FND_MSG_PUB.Initialize;
1805: END IF;
1806:
1807: G_ENTITY_ID := p_entity_id;

Line 1814: IF FND_API.To_Boolean(p_init_error_handler) THEN

1810: INTO G_ENTITY_CODE
1811: FROM DUAL;
1812:
1813: -- Initialize error handler
1814: IF FND_API.To_Boolean(p_init_error_handler) THEN
1815: ERROR_HANDLER.Initialize;
1816: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1817: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1818: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);

Line 1894: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(

1890: IF (l_ext_vl_name IS NULL) THEN
1891: l_ext_vl_name := l_ext_b_table_name;
1892: END IF;
1893:
1894: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
1895: p_table_name => p_interface_table_name,
1896: p_column_name => 'DATA_LEVEL_ID')) THEN
1897: -------------------------------------------------------
1898: -- Populating the the data_level_id in case there is --

Line 1957: l_data_level_col_exists := FND_API.TO_BOOLEAN(

1953: -- Checking weather the ext table has data_level_id --
1954: -- column or not. --
1955: -------------------------------------------------------
1956:
1957: l_data_level_col_exists := FND_API.TO_BOOLEAN(
1958: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
1959: p_table_name => l_ext_b_table_name,
1960: p_column_name => 'DATA_LEVEL_ID'));
1961:

Line 2016: l_ag_id_col_exists := FND_API.TO_BOOLEAN(

2012: -- Find out weather the ATTR_GROUP_ID column exists in the --
2013: -- table where attribute data is to be uploaded or not --
2014: -------------------------------------------------------------
2015:
2016: l_ag_id_col_exists := FND_API.TO_BOOLEAN(
2017: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
2018: p_table_name => l_ext_b_table_name,
2019: p_column_name => 'ATTR_GROUP_ID'));
2020:

Line 2266: IF (FND_API.To_Boolean(p_init_error_handler)) THEN

2262: --======================--
2263: -- ERROR_HANDLER SET-UP --
2264: --======================--
2265:
2266: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
2267:
2268: ERROR_HANDLER.Initialize();
2269: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
2270:

Line 5165: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_ID'; END IF;

5161:
5162: Removed this column from inner select query as it returns morethan one entry for single AG (Reason: this column holds different values for user enetered records and
5163: defaulting records).
5164: For more details about this issue refer to update *** GNOOKALA 10/29/12 02:11 am *** in bug 14672950 */
5165: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_ID'; END IF;
5166: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_LINE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_LINE_ID'; END IF;
5167: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2'; END IF;
5168: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_NUM4')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_NUM4'; END IF;
5169: l_extra_column_val := '';

Line 5166: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_LINE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_LINE_ID'; END IF;

5162: Removed this column from inner select query as it returns morethan one entry for single AG (Reason: this column holds different values for user enetered records and
5163: defaulting records).
5164: For more details about this issue refer to update *** GNOOKALA 10/29/12 02:11 am *** in bug 14672950 */
5165: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_ID'; END IF;
5166: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_LINE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_LINE_ID'; END IF;
5167: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2'; END IF;
5168: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_NUM4')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_NUM4'; END IF;
5169: l_extra_column_val := '';
5170: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN

Line 5167: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2'; END IF;

5163: defaulting records).
5164: For more details about this issue refer to update *** GNOOKALA 10/29/12 02:11 am *** in bug 14672950 */
5165: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_ID'; END IF;
5166: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_LINE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_LINE_ID'; END IF;
5167: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2'; END IF;
5168: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_NUM4')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_NUM4'; END IF;
5169: l_extra_column_val := '';
5170: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN
5171: l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2';

Line 5168: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_NUM4')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_NUM4'; END IF;

5164: For more details about this issue refer to update *** GNOOKALA 10/29/12 02:11 am *** in bug 14672950 */
5165: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_ID'; END IF;
5166: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_LINE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_LINE_ID'; END IF;
5167: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2'; END IF;
5168: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_NUM4')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_NUM4'; END IF;
5169: l_extra_column_val := '';
5170: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN
5171: l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2';
5172: l_extra_column_val := l_extra_column_val || ', ''N''';

Line 5170: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN

5166: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'CHANGE_LINE_ID')) THEN l_extra_column_str := l_extra_column_str || ', CHANGE_LINE_ID'; END IF;
5167: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2'; END IF;
5168: --IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_NUM4')) THEN l_extra_column_str := l_extra_column_str || ', PROG_INT_NUM4'; END IF;
5169: l_extra_column_val := '';
5170: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(p_interface_table_name, 'PROG_INT_CHAR2')) THEN
5171: l_extra_column_str := l_extra_column_str || ', PROG_INT_CHAR2';
5172: l_extra_column_val := l_extra_column_val || ', ''N''';
5173: END IF;
5174: /*end bug 14672950*/

Line 8198: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN

8194: -- The below function returns 'T' or 'F'
8195: l_column_exists:=EGO_USER_ATTRS_DATA_PVT.HAS_COLUMN_IN_TABLE_VIEW(l_ext_b_table_name,'UNIQUE_VALUE');
8196: END IF;
8197:
8198: IF (l_attr_group_metadata_obj.MULTI_ROW_CODE = 'Y' AND FND_API.TO_BOOLEAN(l_column_exists)) THEN
8199: l_unique_value_col := ', UNIQUE_VALUE ';
8200: l_unique_value := ', EGO_EXTFWK_S.CURRVAL '; -- inserting the ext id value in UNIQUE_VALUE column for MR UDAs
8201: ELSE
8202: l_unique_value_col := '';

Line 8556: x_return_status := FND_API.G_RET_STS_SUCCESS;

8552:
8553: IF (ERROR_HANDLER.Get_Message_Count > l_no_of_err_recs) THEN
8554: x_return_status := G_FND_RET_STS_WARNING;
8555: ELSE
8556: x_return_status := FND_API.G_RET_STS_SUCCESS;
8557: END IF;
8558:
8559: --
8560: -- let us write the error logs first

Line 8562: IF (FND_API.To_Boolean(p_init_error_handler)) THEN

8558:
8559: --
8560: -- let us write the error logs first
8561: --
8562: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
8563: ERROR_HANDLER.Log_Error
8564: (p_write_err_to_inttable => 'Y'
8565: ,p_write_err_to_conclog => 'Y'
8566: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()

Line 8702: IF FND_API.To_Boolean(p_commit) THEN

8698: ----------------------------------
8699: END IF; -- *p_do_dml-IF-3*
8700:
8701: -- Standard check of p_commit
8702: IF FND_API.To_Boolean(p_commit) THEN
8703: COMMIT WORK;
8704: END IF;
8705:
8706: code_debug(l_api_name|| 'Done ');

Line 8715: IF FND_API.To_Boolean(p_commit) THEN

8711: NULL;
8712:
8713: WHEN OTHERS THEN
8714: code_debug('######## Oops ... came into the when others block-'||SQLERRM ,2);
8715: IF FND_API.To_Boolean(p_commit) THEN
8716: ROLLBACK TO Bulk_Load_User_Attrs_Data_PVT;
8717: END IF;
8718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8719: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 8718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8714: code_debug('######## Oops ... came into the when others block-'||SQLERRM ,2);
8715: IF FND_API.To_Boolean(p_commit) THEN
8716: ROLLBACK TO Bulk_Load_User_Attrs_Data_PVT;
8717: END IF;
8718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8719: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
8720: -----------------------------------------------------
8721: -- MARKING ALL THE ROWS AS SINCE UN-EXPECTED ERROR --
8722: -- HAS OCCURED AND WE ARE ROLLING BACK --

Line 8751: ,p_message_type => FND_API.G_RET_STS_ERROR

8747: ERROR_HANDLER.Add_Error_Message(
8748: p_message_text => x_msg_data
8749: ,p_row_identifier => l_dummy
8750: ,p_application_id => 'EGO'
8751: ,p_message_type => FND_API.G_RET_STS_ERROR
8752: ,p_entity_id => G_ENTITY_ID
8753: ,p_table_name => p_interface_table_name
8754: ,p_entity_code => G_ENTITY_CODE
8755: );

Line 8961: x_return_status := FND_API.G_RET_STS_SUCCESS;

8957: EXECUTE IMMEDIATE l_dynamic_sql INTO l_dummy_number;
8958: code_debug (l_api_name ||' no records to be processed '||l_dummy_number);
8959: IF l_dummy_number = 0 THEN
8960: code_debug (l_api_name ||' returning as there are no records to process ');
8961: x_return_status := FND_API.G_RET_STS_SUCCESS;
8962: RETURN;
8963: END IF;
8964:
8965: l_dynamic_sql :=

Line 9133: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_ext_b_table_name, 'DATA_LEVEL_ID'));

9129: FROM FND_DESCRIPTIVE_FLEXS
9130: WHERE application_id = p_application_id
9131: AND descriptive_flexfield_name = p_attr_group_type;
9132:
9133: l_has_data_level_id := FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(l_ext_b_table_name, 'DATA_LEVEL_ID'));
9134:
9135: ------------------------------
9136: -- dl level column query part
9137: ------------------------------

Line 9705: x_return_status := FND_API.G_RET_STS_SUCCESS;

9701: l_attr_group_metadata_obj.ATTR_GROUP_NAME;
9702: END IF;
9703: END LOOP;
9704: END IF;
9705: x_return_status := FND_API.G_RET_STS_SUCCESS;
9706: code_debug(l_api_name||' Done ',0);
9707:
9708: EXCEPTION
9709: WHEN G_NO_ROWS_IN_INTF_TABLE THEN

Line 9712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9708: EXCEPTION
9709: WHEN G_NO_ROWS_IN_INTF_TABLE THEN
9710: code_debug(l_api_name||' Exception: '||SQLERRM,0);
9711: WHEN OTHERS THEN
9712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9713: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' - '||SQLERRM;
9714:
9715: END Apply_Template_On_Intf_Table;
9716:

Line 9961: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

9957: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
9958: ,p_additional_class_Code_query IN VARCHAR2 DEFAULT NULL
9959: ,p_extra_column_names IN VARCHAr2 DEFAULT NULL
9960: ,p_extra_column_values IN VARCHAR2 DEFAULT NULL
9961: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
9962: ,p_process_status IN NUMBER DEFAULT G_PS_IN_PROCESS
9963: /* Begin Bug 13729672 */
9964: ,p_comp_seq_id IN NUMBER DEFAULT NULL
9965: ,p_bill_seq_id IN NUMBER DEFAULT NULL

Line 10073: x_return_status := FND_API.G_RET_STS_SUCCESS;

10069:
10070: code_debug (l_api_name ||' no records to be processed '||l_dummy_number);
10071: IF l_dummy_number = 0 THEN
10072: code_debug (l_api_name ||' returning as there are no records to process ');
10073: x_return_status := FND_API.G_RET_STS_SUCCESS;
10074: RETURN;
10075: END IF;
10076:
10077: -----------------------------------------

Line 10100: l_has_data_level_id := FND_API.TO_BOOLEAN(

10096: FROM FND_DESCRIPTIVE_FLEXS
10097: WHERE application_id = p_application_id
10098: AND descriptive_flexfield_name = p_attr_group_type;
10099:
10100: l_has_data_level_id := FND_API.TO_BOOLEAN(
10101: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
10102: p_table_name => l_ext_b_table_name
10103: ,p_column_name => 'DATA_LEVEL_ID'
10104: )

Line 10565: IF FND_API.To_Boolean(p_commit) THEN

10561: END IF;
10562: --------------------------------
10563: -- Standard check of p_commit --
10564: --------------------------------
10565: IF FND_API.To_Boolean(p_commit) THEN
10566: COMMIT WORK;
10567: END IF;
10568:
10569: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10569: x_return_status := FND_API.G_RET_STS_SUCCESS;

10565: IF FND_API.To_Boolean(p_commit) THEN
10566: COMMIT WORK;
10567: END IF;
10568:
10569: x_return_status := FND_API.G_RET_STS_SUCCESS;
10570: code_debug(l_api_name ||' Returning with status '||x_return_status);
10571:
10572: EXCEPTION
10573: WHEN OTHERS THEN

Line 10575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

10571:
10572: EXCEPTION
10573: WHEN OTHERS THEN
10574: code_debug(l_api_name ||' Returning EXCEPTION '||SQLERRM);
10575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10576: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: '||SQLERRM;
10577:
10578: END Insert_Default_Val_Rows;
10579:

Line 10589: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

10585: ,p_object_name IN VARCHAR2
10586: ,p_interface_table_name IN VARCHAR2
10587: ,p_data_set_id IN NUMBER
10588: ,p_new_status IN NUMBER
10589: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
10590: ,x_return_status OUT NOCOPY VARCHAR2
10591: ,x_msg_data OUT NOCOPY VARCHAR2
10592: )
10593: IS

Line 10702: l_data_level_col_exists := FND_API.TO_BOOLEAN(

10698: ***********************/
10699: ------------------------------------------------------------
10700: -- Get data level information for the given object name --
10701: ------------------------------------------------------------
10702: l_data_level_col_exists := FND_API.TO_BOOLEAN(
10703: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
10704: p_table_name => l_ext_b_table_name,
10705: p_column_name => 'DATA_LEVEL_ID'));
10706:

Line 10887: l_ag_id_col_exists := FND_API.TO_BOOLEAN(

10883: -- table where attribute data is to be uploaded or not --
10884: -------------------------------------------------------------
10885: /* bug 9849770 we can't use this API since it is querying all_tables to find out if col exists or not, while l_ext_vl_table_name is actually a view
10886: it will always return false for this API. Change back to the code R12.0 used in determine if attrGroup id exists
10887: l_ag_id_col_exists := FND_API.TO_BOOLEAN(
10888: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
10889: p_table_name => l_ext_vl_table_name,
10890: p_column_name => 'ATTR_GROUP_ID')); */
10891: BEGIN

Line 11053: IF FND_API.To_Boolean(p_commit) THEN

11049:
11050: --------------------------------
11051: -- Standard check of p_commit --
11052: --------------------------------
11053: IF FND_API.To_Boolean(p_commit) THEN
11054: COMMIT WORK;
11055: END IF;
11056:
11057: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11057: x_return_status := FND_API.G_RET_STS_SUCCESS;

11053: IF FND_API.To_Boolean(p_commit) THEN
11054: COMMIT WORK;
11055: END IF;
11056:
11057: x_return_status := FND_API.G_RET_STS_SUCCESS;
11058:
11059: EXCEPTION
11060: WHEN OTHERS THEN
11061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

11057: x_return_status := FND_API.G_RET_STS_SUCCESS;
11058:
11059: EXCEPTION
11060: WHEN OTHERS THEN
11061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11062: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows: '||SQLERRM;
11063:
11064:
11065: END Mark_Unchanged_Attr_Rows;