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 1551: ,p_commit => FND_API.G_TRUE

1547: ,p_entity_id => G_ENTITY_ID
1548: ,p_entity_index => l_entity_index_counter
1549: ,p_entity_code => G_ENTITY_CODE
1550: ,p_debug_level => p_debug_level
1551: ,p_commit => FND_API.G_TRUE
1552: ,x_failed_row_id_list => l_failed_row_id_buffer
1553: ,x_return_status => l_return_status
1554: ,x_errorcode => l_errorcode
1555: ,x_msg_count => l_msg_count

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

1572: ,p_application_id IN NUMBER
1573: ,p_attr_group_type IN VARCHAR2
1574: ,p_attr_group_name IN VARCHAR2
1575: ,p_enabled_code IN VARCHAR2
1576: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_FALSE
1577: ,x_ok_to_delete OUT NOCOPY VARCHAR2
1578: ,x_return_status OUT NOCOPY VARCHAR2
1579: ,x_errorcode OUT NOCOPY NUMBER
1580: ,x_msg_count OUT NOCOPY NUMBER

Line 1600: IF FND_API.To_Boolean(p_init_msg_list) THEN

1596:
1597:
1598:
1599: -- Initialize message list if p_init_msg_list is set to TRUE
1600: IF FND_API.To_Boolean(p_init_msg_list) THEN
1601: FND_MSG_PUB.Initialize;
1602: END IF;
1603:
1604: SELECT

Line 1620: x_ok_to_delete := FND_API.G_FALSE;

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

Line 1625: x_return_status := FND_API.G_RET_STS_ERROR;

1621: l_message := 'EGO_ASSOCIATED_AG_IN_USE';
1622: FND_MESSAGE.Set_Name(g_app_name, l_message);
1623: FND_MESSAGE.Set_Token('ATTR_GROUP_NAME', l_attr_display_name);
1624: FND_MSG_PUB.Add;
1625: x_return_status := FND_API.G_RET_STS_ERROR;
1626:
1627: END IF;
1628:
1629: IF (l_count = 0) THEN

Line 1644: x_ok_to_delete := FND_API.G_FALSE;

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

Line 1649: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1666: x_ok_to_delete := FND_API.G_FALSE;

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

Line 1671: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1676: p_encoded => FND_API.G_FALSE,

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

Line 1682: x_return_status := FND_API.G_RET_STS_SUCCESS;

1678: p_data => x_msg_data
1679: );
1680:
1681: IF (l_message IS NULL) THEN
1682: x_return_status := FND_API.G_RET_STS_SUCCESS;
1683: x_ok_to_delete := FND_API.G_TRUE;
1684: END IF;
1685: EXCEPTION
1686: WHEN OTHERS THEN

Line 1683: x_ok_to_delete := FND_API.G_TRUE;

1679: );
1680:
1681: IF (l_message IS NULL) THEN
1682: x_return_status := FND_API.G_RET_STS_SUCCESS;
1683: x_ok_to_delete := FND_API.G_TRUE;
1684: END IF;
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: x_ok_to_delete := FND_API.G_FALSE;

Line 1687: x_ok_to_delete := FND_API.G_FALSE;

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

Line 1688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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