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 379: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 400: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 421: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 442: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 480: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 510: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 539: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 565: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 590: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 615: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 640: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 673: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 692: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 737: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 756: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 777: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 805: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 841: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 908: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 938: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 975: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 997: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 1018: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 1037: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 1056: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 1078: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 1099: ,p_message_type => FND_API.G_RET_STS_ERROR

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

Line 1138: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE

1134: ,p_entity_id IN NUMBER DEFAULT NULL
1135: ,p_entity_index IN NUMBER DEFAULT NULL
1136: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1137: ,p_debug_level IN NUMBER DEFAULT 0
1138: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1139: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1140: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1141: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1142: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

Line 1139: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1135: ,p_entity_index IN NUMBER DEFAULT NULL
1136: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1137: ,p_debug_level IN NUMBER DEFAULT 0
1138: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1139: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1140: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1141: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1142: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1143: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 1140: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE

1136: ,p_entity_code IN VARCHAR2 DEFAULT NULL
1137: ,p_debug_level IN NUMBER DEFAULT 0
1138: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1139: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1140: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1141: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1142: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1143: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1144: ,p_default_dl_edit_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL

Line 1141: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE

1137: ,p_debug_level IN NUMBER DEFAULT 0
1138: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1139: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1140: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1141: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1142: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1143: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1144: ,p_default_dl_edit_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1145: ,p_default_view_privilege IN VARCHAR2 DEFAULT NULL

Line 1142: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1138: ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_TRUE
1139: ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1140: ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
1141: ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
1142: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1143: ,p_default_dl_view_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1144: ,p_default_dl_edit_priv_list IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
1145: ,p_default_view_privilege IN VARCHAR2 DEFAULT NULL
1146: ,p_default_edit_privilege IN VARCHAR2 DEFAULT NULL

Line 1456: IF FND_API.To_Boolean(p_commit) THEN

1452: BEGIN
1453: code_debug(l_api_name|| 'Starting ');
1454:
1455: -- Standard start of API savepoint
1456: IF FND_API.To_Boolean(p_commit) THEN
1457: SAVEPOINT Bulk_Load_User_Attrs_Data_PVT;
1458: END IF;
1459:
1460: -- Check for call compatibility

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

1457: SAVEPOINT Bulk_Load_User_Attrs_Data_PVT;
1458: END IF;
1459:
1460: -- Check for call compatibility
1461: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1462: l_api_name, G_PKG_NAME)
1463: THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;

Line 1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1460: -- Check for call compatibility
1461: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1462: l_api_name, G_PKG_NAME)
1463: THEN
1464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1465: END IF;
1466:
1467: G_CURRENT_USER_ID := FND_GLOBAL.User_Id;
1468: G_CURRENT_LOGIN_ID := FND_GLOBAL.Login_Id;

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

1470:
1471: ---------------------------------
1472: -- Error Handler Initialization --
1473: ---------------------------------
1474: IF (FND_API.To_Boolean(p_add_errors_to_fnd_stack)) THEN
1475: G_ADD_ERRORS_TO_FND_STACK := 'Y';
1476: ELSE
1477: G_ADD_ERRORS_TO_FND_STACK := 'N';
1478: END IF;

Line 1489: IF FND_API.To_Boolean(p_init_fnd_msg_list) THEN

1485: WHEN OTHERS THEN
1486: G_APPLICATION_CONTEXT := p_application_id;
1487: END;
1488: -- Initialize message list even though we don't currently use it
1489: IF FND_API.To_Boolean(p_init_fnd_msg_list) THEN
1490: FND_MSG_PUB.Initialize;
1491: END IF;
1492:
1493: G_ENTITY_ID := p_entity_id;

Line 1500: IF FND_API.To_Boolean(p_init_error_handler) THEN

1496: INTO G_ENTITY_CODE
1497: FROM DUAL;
1498:
1499: -- Initialize error handler
1500: IF FND_API.To_Boolean(p_init_error_handler) THEN
1501: ERROR_HANDLER.Initialize;
1502: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1503: IF (p_debug_level > 0 AND ERROR_HANDLER.Get_Debug() = 'N') THEN
1504: EGO_USER_ATTRS_DATA_PVT.Set_Up_Debug_Session(G_ENTITY_ID, G_ENTITY_CODE, p_debug_level);

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

1575: IF (l_ext_vl_name IS NULL) THEN
1576: l_ext_vl_name := l_ext_b_table_name;
1577: END IF;
1578:
1579: IF FND_API.TO_BOOLEAN(EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
1580: p_table_name => p_interface_table_name,
1581: p_column_name => 'DATA_LEVEL_ID')) THEN
1582: -------------------------------------------------------
1583: -- Populating the the data_level_id in case there is --

Line 1642: l_data_level_col_exists := FND_API.TO_BOOLEAN(

1638: -- Checking weather the ext table has data_level_id --
1639: -- column or not. --
1640: -------------------------------------------------------
1641:
1642: l_data_level_col_exists := FND_API.TO_BOOLEAN(
1643: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
1644: p_table_name => l_ext_b_table_name,
1645: p_column_name => 'DATA_LEVEL_ID'));
1646:

Line 1701: l_ag_id_col_exists := FND_API.TO_BOOLEAN(

1697: -- Find out weather the ATTR_GROUP_ID column exists in the --
1698: -- table where attribute data is to be uploaded or not --
1699: -------------------------------------------------------------
1700:
1701: l_ag_id_col_exists := FND_API.TO_BOOLEAN(
1702: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
1703: p_table_name => l_ext_b_table_name,
1704: p_column_name => 'ATTR_GROUP_ID'));
1705:

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

1947: --======================--
1948: -- ERROR_HANDLER SET-UP --
1949: --======================--
1950:
1951: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
1952:
1953: ERROR_HANDLER.Initialize();
1954: ERROR_HANDLER.Set_Bo_Identifier(EGO_USER_ATTRS_DATA_PVT.G_BO_IDENTIFIER);
1955:

Line 6910: x_return_status := FND_API.G_RET_STS_SUCCESS;

6906:
6907: IF (ERROR_HANDLER.Get_Message_Count > l_no_of_err_recs) THEN
6908: x_return_status := G_FND_RET_STS_WARNING;
6909: ELSE
6910: x_return_status := FND_API.G_RET_STS_SUCCESS;
6911: END IF;
6912:
6913: --
6914: -- let us write the error logs first

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

6912:
6913: --
6914: -- let us write the error logs first
6915: --
6916: IF (FND_API.To_Boolean(p_init_error_handler)) THEN
6917: ERROR_HANDLER.Log_Error
6918: (p_write_err_to_inttable => 'Y'
6919: ,p_write_err_to_conclog => 'Y'
6920: ,p_write_err_to_debugfile => ERROR_HANDLER.Get_Debug()

Line 7044: IF FND_API.To_Boolean(p_commit) THEN

7040: ----------------------------------
7041: END IF; -- *p_do_dml-IF-3*
7042:
7043: -- Standard check of p_commit
7044: IF FND_API.To_Boolean(p_commit) THEN
7045: COMMIT WORK;
7046: END IF;
7047:
7048: code_debug(l_api_name|| 'Done ');

Line 7057: IF FND_API.To_Boolean(p_commit) THEN

7053: NULL;
7054:
7055: WHEN OTHERS THEN
7056: code_debug('######## Oops ... came into the when others block-'||SQLERRM ,2);
7057: IF FND_API.To_Boolean(p_commit) THEN
7058: ROLLBACK TO Bulk_Load_User_Attrs_Data_PVT;
7059: END IF;
7060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7061: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;

Line 7060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7056: code_debug('######## Oops ... came into the when others block-'||SQLERRM ,2);
7057: IF FND_API.To_Boolean(p_commit) THEN
7058: ROLLBACK TO Bulk_Load_User_Attrs_Data_PVT;
7059: END IF;
7060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7061: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' '||SQLERRM;
7062: -----------------------------------------------------
7063: -- MARKING ALL THE ROWS AS SINCE UN-EXPECTED ERROR --
7064: -- HAS OCCURED AND WE ARE ROLLING BACK --

Line 7093: ,p_message_type => FND_API.G_RET_STS_ERROR

7089: ERROR_HANDLER.Add_Error_Message(
7090: p_message_text => x_msg_data
7091: ,p_row_identifier => l_dummy
7092: ,p_application_id => 'EGO'
7093: ,p_message_type => FND_API.G_RET_STS_ERROR
7094: ,p_entity_id => G_ENTITY_ID
7095: ,p_table_name => p_interface_table_name
7096: ,p_entity_code => G_ENTITY_CODE
7097: );

Line 7303: x_return_status := FND_API.G_RET_STS_SUCCESS;

7299: EXECUTE IMMEDIATE l_dynamic_sql INTO l_dummy_number;
7300: code_debug (l_api_name ||' no records to be processed '||l_dummy_number);
7301: IF l_dummy_number = 0 THEN
7302: code_debug (l_api_name ||' returning as there are no records to process ');
7303: x_return_status := FND_API.G_RET_STS_SUCCESS;
7304: RETURN;
7305: END IF;
7306:
7307: l_dynamic_sql :=

Line 7463: 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'));

7459: FROM FND_DESCRIPTIVE_FLEXS
7460: WHERE application_id = p_application_id
7461: AND descriptive_flexfield_name = p_attr_group_type;
7462:
7463: 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'));
7464:
7465: ------------------------------
7466: -- dl level column query part
7467: ------------------------------

Line 7995: x_return_status := FND_API.G_RET_STS_SUCCESS;

7991: l_attr_group_metadata_obj.ATTR_GROUP_NAME;
7992: END IF;
7993: END LOOP;
7994: END IF;
7995: x_return_status := FND_API.G_RET_STS_SUCCESS;
7996: code_debug(l_api_name||' Done ',0);
7997:
7998: EXCEPTION
7999: WHEN G_NO_ROWS_IN_INTF_TABLE THEN

Line 8002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7998: EXCEPTION
7999: WHEN G_NO_ROWS_IN_INTF_TABLE THEN
8000: code_debug(l_api_name||' Exception: '||SQLERRM,0);
8001: WHEN OTHERS THEN
8002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8003: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' - '||SQLERRM;
8004:
8005: END Apply_Template_On_Intf_Table;
8006:

Line 8251: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

8247: ,p_attr_groups_to_exclude IN VARCHAR2 DEFAULT NULL
8248: ,p_additional_class_Code_query IN VARCHAR2 DEFAULT NULL
8249: ,p_extra_column_names IN VARCHAr2 DEFAULT NULL
8250: ,p_extra_column_values IN VARCHAR2 DEFAULT NULL
8251: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
8252: ,p_process_status IN NUMBER DEFAULT G_PS_IN_PROCESS
8253: ,x_return_status OUT NOCOPY VARCHAR2
8254: ,x_msg_data OUT NOCOPY VARCHAR2
8255: )

Line 8336: x_return_status := FND_API.G_RET_STS_SUCCESS;

8332: EXECUTE IMMEDIATE l_dynamic_sql INTO l_dummy_number;
8333: code_debug (l_api_name ||' no records to be processed '||l_dummy_number);
8334: IF l_dummy_number = 0 THEN
8335: code_debug (l_api_name ||' returning as there are no records to process ');
8336: x_return_status := FND_API.G_RET_STS_SUCCESS;
8337: RETURN;
8338: END IF;
8339:
8340: -----------------------------------------

Line 8363: l_has_data_level_id := FND_API.TO_BOOLEAN(

8359: FROM FND_DESCRIPTIVE_FLEXS
8360: WHERE application_id = p_application_id
8361: AND descriptive_flexfield_name = p_attr_group_type;
8362:
8363: l_has_data_level_id := FND_API.TO_BOOLEAN(
8364: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
8365: p_table_name => l_ext_b_table_name
8366: ,p_column_name => 'DATA_LEVEL_ID'
8367: )

Line 8788: IF FND_API.To_Boolean(p_commit) THEN

8784: p_attr_group_type;
8785: --------------------------------
8786: -- Standard check of p_commit --
8787: --------------------------------
8788: IF FND_API.To_Boolean(p_commit) THEN
8789: COMMIT WORK;
8790: END IF;
8791:
8792: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8792: x_return_status := FND_API.G_RET_STS_SUCCESS;

8788: IF FND_API.To_Boolean(p_commit) THEN
8789: COMMIT WORK;
8790: END IF;
8791:
8792: x_return_status := FND_API.G_RET_STS_SUCCESS;
8793: code_debug(l_api_name ||' Returning with status '||x_return_status);
8794:
8795: EXCEPTION
8796: WHEN OTHERS THEN

Line 8798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8794:
8795: EXCEPTION
8796: WHEN OTHERS THEN
8797: code_debug(l_api_name ||' Returning EXCEPTION '||SQLERRM);
8798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8799: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: '||SQLERRM;
8800:
8801: END Insert_Default_Val_Rows;
8802:

Line 8812: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

8808: ,p_object_name IN VARCHAR2
8809: ,p_interface_table_name IN VARCHAR2
8810: ,p_data_set_id IN NUMBER
8811: ,p_new_status IN NUMBER
8812: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
8813: ,x_return_status OUT NOCOPY VARCHAR2
8814: ,x_msg_data OUT NOCOPY VARCHAR2
8815: )
8816: IS

Line 8925: l_data_level_col_exists := FND_API.TO_BOOLEAN(

8921: ***********************/
8922: ------------------------------------------------------------
8923: -- Get data level information for the given object name --
8924: ------------------------------------------------------------
8925: l_data_level_col_exists := FND_API.TO_BOOLEAN(
8926: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
8927: p_table_name => l_ext_b_table_name,
8928: p_column_name => 'DATA_LEVEL_ID'));
8929:

Line 9109: l_ag_id_col_exists := FND_API.TO_BOOLEAN(

9105: -- Find out weather the ATTR_GROUP_ID column exists in the --
9106: -- table where attribute data is to be uploaded or not --
9107: -------------------------------------------------------------
9108:
9109: l_ag_id_col_exists := FND_API.TO_BOOLEAN(
9110: EGO_USER_ATTRS_COMMON_PVT.has_column_in_table(
9111: p_table_name => l_ext_vl_table_name,
9112: p_column_name => 'ATTR_GROUP_ID'));
9113:

Line 9262: IF FND_API.To_Boolean(p_commit) THEN

9258:
9259: --------------------------------
9260: -- Standard check of p_commit --
9261: --------------------------------
9262: IF FND_API.To_Boolean(p_commit) THEN
9263: COMMIT WORK;
9264: END IF;
9265:
9266: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9266: x_return_status := FND_API.G_RET_STS_SUCCESS;

9262: IF FND_API.To_Boolean(p_commit) THEN
9263: COMMIT WORK;
9264: END IF;
9265:
9266: x_return_status := FND_API.G_RET_STS_SUCCESS;
9267:
9268: EXCEPTION
9269: WHEN OTHERS THEN
9270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9266: x_return_status := FND_API.G_RET_STS_SUCCESS;
9267:
9268: EXCEPTION
9269: WHEN OTHERS THEN
9270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9271: x_msg_data := 'Executing - EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows: '||SQLERRM;
9272:
9273:
9274: END Mark_Unchanged_Attr_Rows;