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.INV_ITEM_ATTRIBUTES_PKG dependencies on INV_ITEM_ATTRIBUTES_PKG

Line 1: PACKAGE BODY INV_ITEM_ATTRIBUTES_PKG AS

1: PACKAGE BODY INV_ITEM_ATTRIBUTES_PKG AS
2: /* $Header: INVGIAPB.pls 120.2 2006/02/22 22:39:45 myerrams noship $ */
3: --/*==========================================================================+
4: --| Copyright (c) 2000 Oracle Corporation Belmont, California, USA |
5: --| All rights reserved. |

Line 71: G_INV_ITEM_ATTRIBUTES_PKG VARCHAR2(30) := 'INV_ITEM_ATTRIBUTES_PKG';

67: --=================
68: -- CONSTANTS
69: --=================
70:
71: G_INV_ITEM_ATTRIBUTES_PKG VARCHAR2(30) := 'INV_ITEM_ATTRIBUTES_PKG';
72:
73: --==================
74: -- GLOBAL VARIABLES
75: --==================

Line 134: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

130: EXCEPTION
131: WHEN OTHERS THEN
132: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
133: THEN
134: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
135: , 'get_type_struct'
136: );
137: END IF;
138: RAISE;

Line 171: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

167: EXCEPTION
168: WHEN OTHERS THEN
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
170: THEN
171: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
172: , 'set_type_struct'
173: );
174: END IF;
175: RAISE;

Line 319: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

315: EXCEPTION
316: WHEN OTHERS THEN
317: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
320: , 'populate_type_struct'
321: );
322: END IF;
323: RAISE;

Line 347: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

343: EXCEPTION
344: WHEN OTHERS THEN
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
346: THEN
347: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
348: , 'clear_type_struct'
349: );
350: END IF;
351: RAISE;

Line 1157: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1156: THEN
1157: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1158: , 'populate_temp_table'
1159: );
1160: END IF;
1161: RAISE;

Line 1193: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1192: THEN
1193: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1194: , 'clear_temp_table'
1195: );
1196: END IF;
1197: RAISE;

Line 1256: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1255: THEN
1256: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1257: , 'find_org_list'
1258: );
1259: END IF;
1260: END find_org_list;

Line 1272: ( p_att_tab IN INV_ITEM_ATTRIBUTES_PKG.att_tbl_type

1268: -- : functionality should be written here
1269: -- PRE-COND : This procedure will be called from the form
1270: --=========================================================================
1271: PROCEDURE call_item_update
1272: ( p_att_tab IN INV_ITEM_ATTRIBUTES_PKG.att_tbl_type
1273: ,p_sel_tab IN INV_ITEM_ATTRIBUTES_PKG.sel_tbl_type
1274: ,p_inventory_item_id OUT NOCOPY NUMBER
1275: ,p_organization_id OUT NOCOPY NUMBER
1276: ,p_return_status OUT NOCOPY VARCHAR2

Line 1273: ,p_sel_tab IN INV_ITEM_ATTRIBUTES_PKG.sel_tbl_type

1269: -- PRE-COND : This procedure will be called from the form
1270: --=========================================================================
1271: PROCEDURE call_item_update
1272: ( p_att_tab IN INV_ITEM_ATTRIBUTES_PKG.att_tbl_type
1273: ,p_sel_tab IN INV_ITEM_ATTRIBUTES_PKG.sel_tbl_type
1274: ,p_inventory_item_id OUT NOCOPY NUMBER
1275: ,p_organization_id OUT NOCOPY NUMBER
1276: ,p_return_status OUT NOCOPY VARCHAR2
1277: ,p_error_tab OUT NOCOPY INV_Item_GRP.Error_tbl_type

Line 1293: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
1294: , 'call_item_update'
1295: );
1296: END IF;
1297: x_retcode := 2;

Line 1771: -- to ensure the INV_ITEM_ATTRIBUTES_PKG is compiled

1767: );
1768: END IF;
1769:
1770: -- the following select and if statement are included
1771: -- to ensure the INV_ITEM_ATTRIBUTES_PKG is compiled
1772: -- system tests found that the dependancy on package
1773: --
1774: SELECT status
1775: INTO l_status

Line 1777: WHERE object_name = 'INV_ITEM_ATTRIBUTES_PKG'

1773: --
1774: SELECT status
1775: INTO l_status
1776: FROM user_objects
1777: WHERE object_name = 'INV_ITEM_ATTRIBUTES_PKG'
1778: AND object_type = 'PACKAGE BODY';
1779:
1780: IF l_status = 'INVALID' THEN
1781: DBMS_DDL.ALTER_COMPILE('package','apps','INV_ITEM_ATTRIBUTES_PKG');

Line 1781: DBMS_DDL.ALTER_COMPILE('package','apps','INV_ITEM_ATTRIBUTES_PKG');

1777: WHERE object_name = 'INV_ITEM_ATTRIBUTES_PKG'
1778: AND object_type = 'PACKAGE BODY';
1779:
1780: IF l_status = 'INVALID' THEN
1781: DBMS_DDL.ALTER_COMPILE('package','apps','INV_ITEM_ATTRIBUTES_PKG');
1782: END IF;
1783:
1784: -- open item attribute cursor
1785:

Line 2057: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

2053: x_retcode := RETCODE_ERROR;
2054: WHEN OTHERS THEN
2055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2056: THEN
2057: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2058: , 'batch_item_update'
2059: );
2060: x_retcode := RETCODE_ERROR;
2061: x_errbuff := FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE);

Line 2076: (p_att_tab IN INV_ITEM_ATTRIBUTES_PKG.att_tbl_type

2072: --
2073: -- PRE-COND : This procedure will be called from the form
2074: --=========================================================================
2075: PROCEDURE populate_temp_tables
2076: (p_att_tab IN INV_ITEM_ATTRIBUTES_PKG.att_tbl_type
2077: ,x_seq_id OUT NOCOPY NUMBER
2078: )
2079: IS
2080:

Line 2147: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG

2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2146: THEN
2147: FND_MSG_PUB.Add_Exc_Msg( G_INV_ITEM_ATTRIBUTES_PKG
2148: , 'populate_temp_tables'
2149: );
2150: END IF;
2151: RAISE;

Line 2154: END INV_ITEM_ATTRIBUTES_PKG;

2150: END IF;
2151: RAISE;
2152: END populate_temp_tables;
2153:
2154: END INV_ITEM_ATTRIBUTES_PKG;