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.

APPS.EGO_CHANGE_USER_ATTRS_PUB dependencies on FND_API

Line 53: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE

49: ERRBUF OUT NOCOPY VARCHAR2
50: ,RETCODE OUT NOCOPY VARCHAR2
51: ,p_data_set_id IN NUMBER
52: ,p_debug_level IN NUMBER DEFAULT 0
53: ,p_purge_successful_lines IN VARCHAR2 DEFAULT FND_API.G_FALSE
54: ) IS
55:
56: l_error_message_name VARCHAR2(30);
57: l_entity_index_counter NUMBER := 0;

Line 519: ,p_message_type => FND_API.G_RET_STS_ERROR

515: ERROR_HANDLER.Add_Error_Message(
516: p_message_name => l_error_message_name
517: ,p_application_id => 'ENG'
518: ,p_token_tbl => l_token_table
519: ,p_message_type => FND_API.G_RET_STS_ERROR
520: ,p_row_identifier => error_rec.ROW_IDENTIFIER
521: ,p_entity_id => G_ENTITY_ID
522: ,p_entity_code => G_ENTITY_CODE
523: );

Line 643: ,p_message_type => FND_API.G_RET_STS_ERROR

639: ERROR_HANDLER.Add_Error_Message(
640: p_message_name => l_error_message_name
641: ,p_application_id => 'ENG'
642: ,p_token_tbl => l_token_table
643: ,p_message_type => FND_API.G_RET_STS_ERROR
644: ,p_entity_id => G_ENTITY_ID
645: ,p_entity_index => l_entity_index_counter
646: ,p_entity_code => G_ENTITY_CODE
647: );

Line 695: ,p_commit => FND_API.G_TRUE

691: ,p_entity_id => G_ENTITY_ID
692: ,p_entity_index => l_entity_index_counter
693: ,p_entity_code => G_ENTITY_CODE
694: ,p_debug_level => p_debug_level
695: ,p_commit => FND_API.G_TRUE
696: ,x_failed_row_id_list => l_failed_row_id_buffer
697: ,x_return_status => l_return_status
698: ,x_errorcode => l_errorcode
699: ,x_msg_count => l_msg_count

Line 708: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

704: -- If any rows for this instance failed, we add their ROW_IDENTIFIERs --
705: -- to a master list that we will eventually use to mark as errors all --
706: -- rows whose ROW_IDENTIFIERs appear in the list --
707: ------------------------------------------------------------------------
708: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
709:
710: l_failed_row_id_list := l_failed_row_id_list || l_failed_row_id_buffer || ',';
711:
712: END IF;

Line 807: ,p_commit => FND_API.G_TRUE

803: ,p_entity_id => G_ENTITY_ID
804: ,p_entity_index => l_entity_index_counter
805: ,p_entity_code => G_ENTITY_CODE
806: ,p_debug_level => p_debug_level
807: ,p_commit => FND_API.G_TRUE
808: ,x_failed_row_id_list => l_failed_row_id_buffer
809: ,x_return_status => l_return_status
810: ,x_errorcode => l_errorcode
811: ,x_msg_count => l_msg_count

Line 828: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

824: -- If any rows for this instance failed, we add their ROW_IDENTIFIERs --
825: -- to our master list, which we will then use to mark as errors all --
826: -- rows whose ROW_IDENTIFIERs appear in the list --
827: ------------------------------------------------------------------------
828: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
829:
830: l_failed_row_id_list := l_failed_row_id_list || l_failed_row_id_buffer || ',';
831:
832: END IF;

Line 940: ,p_message_type => FND_API.G_RET_STS_ERROR

936: ERROR_HANDLER.Add_Error_Message(
937: p_message_name => l_error_message_name
938: ,p_application_id => 'ENG'
939: ,p_token_tbl => l_token_table
940: ,p_message_type => FND_API.G_RET_STS_ERROR
941: ,p_entity_id => G_ENTITY_ID
942: ,p_entity_index => l_entity_index_counter
943: ,p_entity_code => G_ENTITY_CODE
944: );

Line 997: ,p_commit => FND_API.G_TRUE

993: ,p_entity_id => G_ENTITY_ID
994: ,p_entity_index => l_entity_index_counter
995: ,p_entity_code => G_ENTITY_CODE
996: ,p_debug_level => p_debug_level
997: ,p_commit => FND_API.G_TRUE
998: ,x_failed_row_id_list => l_failed_row_id_buffer
999: ,x_return_status => l_return_status
1000: ,x_errorcode => l_errorcode
1001: ,x_msg_count => l_msg_count

Line 1010: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1006: -- If any rows for this instance failed, we add their ROW_IDENTIFIERs --
1007: -- to a master list that we will eventually use to mark as errors all --
1008: -- rows whose ROW_IDENTIFIERs appear in the list --
1009: ------------------------------------------------------------------------
1010: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011:
1012: l_failed_row_id_list := l_failed_row_id_list || l_failed_row_id_buffer || ',';
1013:
1014: END IF;

Line 1123: ,p_commit => FND_API.G_TRUE

1119: ,p_entity_id => G_ENTITY_ID
1120: ,p_entity_index => l_entity_index_counter
1121: ,p_entity_code => G_ENTITY_CODE
1122: ,p_debug_level => p_debug_level
1123: ,p_commit => FND_API.G_TRUE
1124: ,x_failed_row_id_list => l_failed_row_id_buffer
1125: ,x_return_status => l_return_status
1126: ,x_errorcode => l_errorcode
1127: ,x_msg_count => l_msg_count

Line 1145: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1141: -- If any rows for this instance failed, we add their ROW_IDENTIFIERs --
1142: -- to our master list, which we will then use to mark as errors all --
1143: -- rows whose ROW_IDENTIFIERs appear in the list --
1144: ------------------------------------------------------------------------
1145: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1146:
1147: l_failed_row_id_list := l_failed_row_id_list || l_failed_row_id_buffer || ',';
1148:
1149: END IF;

Line 1181: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN

1177: EXECUTE IMMEDIATE l_dynamic_sql USING p_data_set_id;
1178:
1179: END IF;
1180:
1181: IF (FND_API.To_Boolean(p_purge_successful_lines)) THEN
1182: -----------------------------------------------
1183: -- Delete all successful rows from the table --
1184: -- (they're the only rows still in process) --
1185: -----------------------------------------------

Line 1221: ,p_message_type => FND_API.G_RET_STS_ERROR

1217:
1218: ERROR_HANDLER.Add_Error_Message(
1219: p_message_name => 'EGO_EF_NO_NAME_TO_VALIDATE'
1220: ,p_application_id => 'EGO'
1221: ,p_message_type => FND_API.G_RET_STS_ERROR
1222: ,p_entity_id => G_ENTITY_ID
1223: ,p_entity_code => G_ENTITY_CODE
1224: );
1225:

Line 1241: ,p_message_type => FND_API.G_RET_STS_ERROR

1237:
1238: ERROR_HANDLER.Add_Error_Message(
1239: p_message_text => 'Unexpected error in '||G_PKG_NAME||'.Process_Change_User_Attrs_Data: '||SQLERRM
1240: ,p_application_id => 'EGO'
1241: ,p_message_type => FND_API.G_RET_STS_ERROR
1242: ,p_entity_id => G_ENTITY_ID
1243: ,p_entity_code => G_ENTITY_CODE);
1244:
1245: ---------------------------------------------------------------

Line 1409: ,p_commit => FND_API.G_TRUE

1405: ,p_entity_id => G_ENTITY_ID
1406: ,p_entity_index => l_entity_index_counter
1407: ,p_entity_code => G_ENTITY_CODE
1408: ,p_debug_level => p_debug_level
1409: ,p_commit => FND_API.G_TRUE
1410: ,x_failed_row_id_list => l_failed_row_id_buffer
1411: ,x_return_status => l_return_status
1412: ,x_errorcode => l_errorcode
1413: ,x_msg_count => l_msg_count

Line 1555: ,p_commit => FND_API.G_TRUE

1551: ,p_entity_id => G_ENTITY_ID
1552: ,p_entity_index => l_entity_index_counter
1553: ,p_entity_code => G_ENTITY_CODE
1554: ,p_debug_level => p_debug_level
1555: ,p_commit => FND_API.G_TRUE
1556: ,x_failed_row_id_list => l_failed_row_id_buffer
1557: ,x_return_status => l_return_status
1558: ,x_errorcode => l_errorcode
1559: ,x_msg_count => l_msg_count

Line 1580: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE

1576: ,p_application_id IN NUMBER
1577: ,p_attr_group_type IN VARCHAR2
1578: ,p_attr_group_name IN VARCHAR2
1579: ,p_enabled_code IN VARCHAR2
1580: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1581: ,x_ok_to_delete OUT NOCOPY VARCHAR2
1582: ,x_return_status OUT NOCOPY VARCHAR2
1583: ,x_errorcode OUT NOCOPY NUMBER
1584: ,x_msg_count OUT NOCOPY NUMBER

Line 1604: IF FND_API.To_Boolean(p_init_msg_list) THEN

1600:
1601:
1602:
1603: -- Initialize message list if p_init_msg_list is set to TRUE
1604: IF FND_API.To_Boolean(p_init_msg_list) THEN
1605: FND_MSG_PUB.Initialize;
1606: END IF;
1607:
1608: SELECT

Line 1624: x_ok_to_delete := FND_API.G_FALSE;

1620: ASSOCIATION_ID = p_association_id;
1621:
1622: IF (l_count > 0)
1623: THEN
1624: x_ok_to_delete := FND_API.G_FALSE;
1625: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1626: FND_MESSAGE.Set_Name(g_app_name, l_message);
1627: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1628: FND_MSG_PUB.Add;

Line 1629: x_return_status := FND_API.G_RET_STS_ERROR;

1625: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1626: FND_MESSAGE.Set_Name(g_app_name, l_message);
1627: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1628: FND_MSG_PUB.Add;
1629: x_return_status := FND_API.G_RET_STS_ERROR;
1630:
1631: END IF;
1632:
1633: IF (l_count = 0) THEN

Line 1648: x_ok_to_delete := FND_API.G_FALSE;

1644: -- BUG 5097794 Replaced LITERALS with BINDS
1645: EXECUTE IMMEDIATE l_dynamic_sql INTO l_count USING p_classification_code , l_attr_group_id||'%' ;
1646: IF (l_count > 0)
1647: THEN
1648: x_ok_to_delete := FND_API.G_FALSE;
1649: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1650: FND_MESSAGE.Set_Name(g_app_name, l_message);
1651: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1652: FND_MSG_PUB.Add;

Line 1653: x_return_status := FND_API.G_RET_STS_ERROR;

1649: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1650: FND_MESSAGE.Set_Name(g_app_name, l_message);
1651: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1652: FND_MSG_PUB.Add;
1653: x_return_status := FND_API.G_RET_STS_ERROR;
1654: END IF;
1655: IF (l_count = 0) THEN
1656: -- check if this ag is used to create any result formats
1657: l_dynamic_sql := ' SELECT COUNT(*) ' ||

Line 1670: x_ok_to_delete := FND_API.G_FALSE;

1666: EXECUTE IMMEDIATE l_dynamic_sql INTO l_count USING p_classification_code , l_attr_group_id||'%' ;
1667:
1668: IF (l_count > 0)
1669: THEN
1670: x_ok_to_delete := FND_API.G_FALSE;
1671: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1672: FND_MESSAGE.Set_Name(g_app_name, l_message);
1673: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1674: FND_MSG_PUB.Add;

Line 1675: x_return_status := FND_API.G_RET_STS_ERROR;

1671: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1672: FND_MESSAGE.Set_Name(g_app_name, l_message);
1673: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1674: FND_MSG_PUB.Add;
1675: x_return_status := FND_API.G_RET_STS_ERROR;
1676: END IF;
1677: END IF; --if no search criteria exist
1678: END IF; -- no page entry exist
1679: FND_MSG_PUB.Count_And_Get(

Line 1680: p_encoded => FND_API.G_FALSE,

1676: END IF;
1677: END IF; --if no search criteria exist
1678: END IF; -- no page entry exist
1679: FND_MSG_PUB.Count_And_Get(
1680: p_encoded => FND_API.G_FALSE,
1681: p_count => x_msg_count,
1682: p_data => x_msg_data
1683: );
1684:

Line 1686: x_return_status := FND_API.G_RET_STS_SUCCESS;

1682: p_data => x_msg_data
1683: );
1684:
1685: IF (l_message IS NULL) THEN
1686: x_return_status := FND_API.G_RET_STS_SUCCESS;
1687: x_ok_to_delete := FND_API.G_TRUE;
1688: END IF;
1689: EXCEPTION
1690: WHEN OTHERS THEN

Line 1687: x_ok_to_delete := FND_API.G_TRUE;

1683: );
1684:
1685: IF (l_message IS NULL) THEN
1686: x_return_status := FND_API.G_RET_STS_SUCCESS;
1687: x_ok_to_delete := FND_API.G_TRUE;
1688: END IF;
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: x_ok_to_delete := FND_API.G_FALSE;

Line 1691: x_ok_to_delete := FND_API.G_FALSE;

1687: x_ok_to_delete := FND_API.G_TRUE;
1688: END IF;
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: x_ok_to_delete := FND_API.G_FALSE;
1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1693: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1694: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1695: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

Line 1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1688: END IF;
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: x_ok_to_delete := FND_API.G_FALSE;
1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1693: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1694: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1695: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1696: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);