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.CSP_INV_LOC_ASSIGNMENTS_PKG dependencies on FND_API

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

91: x_msg_count => l_msg_count,
92: x_msg_data => l_msg_data
93: ) ;
94:
95: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
96: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
97: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
98: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
99: FND_MSG_PUB.Add;

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

96: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
97: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
98: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
99: FND_MSG_PUB.Add;
100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
101: END IF;
102: END IF;
103: -- Pre call to the Vertical Type User Hook
104: --

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

111: x_msg_count => l_msg_count,
112: x_msg_data => l_msg_data
113: ) ;
114:
115: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
116: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
117: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
118: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
119: FND_MSG_PUB.Add;

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
117: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
118: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
119: FND_MSG_PUB.Add;
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: END IF;
123:
124: csp_inv_loc_assignments_iuhk.create_inventory_location_Pre

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

124: csp_inv_loc_assignments_iuhk.create_inventory_location_Pre
125: ( x_return_status => l_return_status
126: ) ;
127:
128: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
129: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
130: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
131: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
132: FND_MSG_PUB.Add;

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
130: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
131: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
132: FND_MSG_PUB.Add;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135:
136:
137: If (l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID IS NULL) OR (l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID = FND_API.G_MISS_NUM) then

Line 137: If (l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID IS NULL) OR (l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID = FND_API.G_MISS_NUM) then

133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135:
136:
137: If (l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID IS NULL) OR (l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID = FND_API.G_MISS_NUM) then
138: OPEN C2;
139: FETCH C2 INTO px_CSP_INV_LOC_ASSIGNMENT_ID;
140: CLOSE C2;
141: End If;

Line 177: decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),

173: ATTRIBUTE14,
174: ATTRIBUTE15
175: ) VALUES (
176: px_CSP_INV_LOC_ASSIGNMENT_ID,
177: decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),
178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),

Line 178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),

174: ATTRIBUTE15
175: ) VALUES (
176: px_CSP_INV_LOC_ASSIGNMENT_ID,
177: decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),
178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),

Line 179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),

175: ) VALUES (
176: px_CSP_INV_LOC_ASSIGNMENT_ID,
177: decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),
178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),

Line 180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),

176: px_CSP_INV_LOC_ASSIGNMENT_ID,
177: decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),
178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),

Line 181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),

177: decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.CREATED_BY),
178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),

Line 182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),

178: decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.creation_date),
179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),

Line 183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),

179: decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATED_BY),
180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),

Line 184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),

180: decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,to_date(null),l_inv_loc_assignment.last_update_date),
181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),

Line 185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),

181: decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),

Line 186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),

182: decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.RESOURCE_ID),
183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),

Line 187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),

183: decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.ORGANIZATION_ID),
184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),

Line 188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),

184: decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.SUBINVENTORY_CODE),
185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),

Line 189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),

185: decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, NULL, l_inv_loc_assignment.LOCATOR_ID),
186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),

Line 190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),

186: decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.RESOURCE_TYPE),
187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),

Line 191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),

187: decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_START),
188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),

Line 192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),

188: decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, to_date(null), l_inv_loc_assignment.EFFECTIVE_DATE_END),
189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),

Line 193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),

189: decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.DEFAULT_CODE),
190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),

Line 194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),

190: decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),

Line 195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),

191: decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE1),
192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),

Line 196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),

192: decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE2),
193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),

Line 197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),

193: decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE3),
194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),

Line 198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),

194: decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE4),
195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),

Line 199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),

195: decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE5),
196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),

Line 200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),

196: decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE6),
197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),

Line 201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),

197: decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE7),
198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));

Line 202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),

198: decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE8),
199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));
206:

Line 203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),

199: decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE9),
200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));
206:
207: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',

Line 204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),

200: decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE10),
201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));
206:
207: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
208: 'Insert_Row',

Line 205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));

201: decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE11),
202: decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE12),
203: decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE13),
204: decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE14),
205: decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_inv_loc_assignment.ATTRIBUTE15));
206:
207: IF jtf_usr_hks.Ok_To_Execute('CSP_INV_LOC_ASSIGNMENTS_PKG',
208: 'Insert_Row',
209: 'A', 'C') THEN

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

213: x_msg_count => l_msg_count,
214: x_msg_data => l_msg_data
215: ) ;
216:
217: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
218: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
219: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
220: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
221: FND_MSG_PUB.Add;

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
219: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
220: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
221: FND_MSG_PUB.Add;
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: END IF;
225: -- Pre call to the Vertical Type User Hook
226: --

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

233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data
235: ) ;
236:
237: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
238: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
239: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
240: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
241: FND_MSG_PUB.Add;

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
239: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
240: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: END IF;
245: csp_inv_loc_assignments_iuhk.create_inventory_location_post
246: ( x_return_status => l_return_status

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

245: csp_inv_loc_assignments_iuhk.create_inventory_location_post
246: ( x_return_status => l_return_status
247: ) ;
248:
249: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
251: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
253: FND_MSG_PUB.Add;

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
251: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
252: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
253: FND_MSG_PUB.Add;
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: END IF;
256: End Insert_Row;
257:
258: PROCEDURE Update_Row(

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

336: x_msg_count => l_msg_count,
337: x_msg_data => l_msg_data
338: ) ;
339:
340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
341: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
342: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
343: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
344: FND_MSG_PUB.Add;

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

341: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
342: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
343: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
344: FND_MSG_PUB.Add;
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347: END IF;
348: -- Pre call to the Vertical Type User Hook
349: --

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

356: x_msg_count => l_msg_count,
357: x_msg_data => l_msg_data
358: ) ;
359:
360: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
361: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
362: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
363: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
364: FND_MSG_PUB.Add;

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

361: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
362: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
363: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
364: FND_MSG_PUB.Add;
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: END IF;
367: END IF;
368:
369: csp_inv_loc_assignments_iuhk.update_inventory_location_Pre

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

369: csp_inv_loc_assignments_iuhk.update_inventory_location_Pre
370: ( x_return_status => l_return_status
371: ) ;
372:
373: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
374: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
375: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
376: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
377: FND_MSG_PUB.Add;

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

374: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
375: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
376: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
377: FND_MSG_PUB.Add;
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
379: END IF;
380:
381: Update CSP_INV_LOC_ASSIGNMENTS
382: SET

Line 383: CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),

379: END IF;
380:
381: Update CSP_INV_LOC_ASSIGNMENTS
382: SET
383: CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),
384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),

Line 384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),

380:
381: Update CSP_INV_LOC_ASSIGNMENTS
382: SET
383: CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),
384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),

Line 385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),

381: Update CSP_INV_LOC_ASSIGNMENTS
382: SET
383: CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),
384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),

Line 386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),

382: SET
383: CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),
384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),

Line 387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),

383: CREATED_BY = decode( l_inv_loc_assignment.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_inv_loc_assignment.CREATED_BY),
384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),

Line 388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),

384: CREATION_DATE = decode(l_inv_loc_assignment.CREATION_DATE,fnd_api.g_miss_date,creation_date,l_inv_loc_assignment.creation_date),
385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),

Line 389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),

385: LAST_UPDATED_BY = decode( l_inv_loc_assignment.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_inv_loc_assignment.LAST_UPDATED_BY),
386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),

Line 390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),

386: LAST_UPDATE_DATE = decode(l_inv_loc_assignment.LAST_UPDATE_DATE,fnd_api.g_miss_date,last_update_date,l_inv_loc_assignment.last_update_date),
387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),

Line 391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),

387: LAST_UPDATE_LOGIN = decode( l_inv_loc_assignment.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_inv_loc_assignment.LAST_UPDATE_LOGIN),
388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),

Line 392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),

388: RESOURCE_ID = decode( l_inv_loc_assignment.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_inv_loc_assignment.RESOURCE_ID),
389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),

Line 393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),

389: ORGANIZATION_ID = decode( l_inv_loc_assignment.ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, l_inv_loc_assignment.ORGANIZATION_ID),
390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),

Line 394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),

390: SUBINVENTORY_CODE = decode( l_inv_loc_assignment.SUBINVENTORY_CODE, FND_API.G_MISS_CHAR, SUBINVENTORY_CODE, l_inv_loc_assignment.SUBINVENTORY_CODE),
391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),

Line 395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),

391: LOCATOR_ID = decode( l_inv_loc_assignment.LOCATOR_ID, FND_API.G_MISS_NUM, LOCATOR_ID, l_inv_loc_assignment.LOCATOR_ID),
392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),

Line 396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),

392: RESOURCE_TYPE = decode( l_inv_loc_assignment.RESOURCE_TYPE, FND_API.G_MISS_CHAR, RESOURCE_TYPE, l_inv_loc_assignment.RESOURCE_TYPE),
393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),

Line 397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),

393: EFFECTIVE_DATE_START = decode( l_inv_loc_assignment.EFFECTIVE_DATE_START, FND_API.G_MISS_DATE, EFFECTIVE_DATE_START, l_inv_loc_assignment.EFFECTIVE_DATE_START),
394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),

Line 398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),

394: EFFECTIVE_DATE_END = decode( l_inv_loc_assignment.EFFECTIVE_DATE_END, FND_API.G_MISS_DATE, EFFECTIVE_DATE_END, l_inv_loc_assignment.EFFECTIVE_DATE_END),
395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),

Line 399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),

395: DEFAULT_CODE = decode( l_inv_loc_assignment.DEFAULT_CODE, FND_API.G_MISS_CHAR, DEFAULT_CODE, l_inv_loc_assignment.DEFAULT_CODE),
396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),

Line 400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),

396: ATTRIBUTE_CATEGORY = decode( l_inv_loc_assignment.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_inv_loc_assignment.ATTRIBUTE_CATEGORY),
397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),

Line 401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),

397: ATTRIBUTE1 = decode( l_inv_loc_assignment.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_inv_loc_assignment.ATTRIBUTE1),
398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),

Line 402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),

398: ATTRIBUTE2 = decode( l_inv_loc_assignment.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_inv_loc_assignment.ATTRIBUTE2),
399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),

Line 403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),

399: ATTRIBUTE3 = decode( l_inv_loc_assignment.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_inv_loc_assignment.ATTRIBUTE3),
400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),

Line 404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),

400: ATTRIBUTE4 = decode( l_inv_loc_assignment.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_inv_loc_assignment.ATTRIBUTE4),
401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),

Line 405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),

401: ATTRIBUTE5 = decode( l_inv_loc_assignment.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_inv_loc_assignment.ATTRIBUTE5),
402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),

Line 406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),

402: ATTRIBUTE6 = decode( l_inv_loc_assignment.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_inv_loc_assignment.ATTRIBUTE6),
403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),

Line 407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),

403: ATTRIBUTE7 = decode( l_inv_loc_assignment.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_inv_loc_assignment.ATTRIBUTE7),
404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),
411: ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)

Line 408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),

404: ATTRIBUTE8 = decode( l_inv_loc_assignment.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_inv_loc_assignment.ATTRIBUTE8),
405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),
411: ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)
412: where CSP_INV_LOC_ASSIGNMENT_ID = l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID;

Line 409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),

405: ATTRIBUTE9 = decode( l_inv_loc_assignment.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_inv_loc_assignment.ATTRIBUTE9),
406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),
411: ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)
412: where CSP_INV_LOC_ASSIGNMENT_ID = l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID;
413:

Line 410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),

406: ATTRIBUTE10 = decode( l_inv_loc_assignment.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_inv_loc_assignment.ATTRIBUTE10),
407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),
411: ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)
412: where CSP_INV_LOC_ASSIGNMENT_ID = l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID;
413:
414: If (SQL%NOTFOUND) then

Line 411: ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)

407: ATTRIBUTE11 = decode( l_inv_loc_assignment.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_inv_loc_assignment.ATTRIBUTE11),
408: ATTRIBUTE12 = decode( l_inv_loc_assignment.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_inv_loc_assignment.ATTRIBUTE12),
409: ATTRIBUTE13 = decode( l_inv_loc_assignment.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_inv_loc_assignment.ATTRIBUTE13),
410: ATTRIBUTE14 = decode( l_inv_loc_assignment.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_inv_loc_assignment.ATTRIBUTE14),
411: ATTRIBUTE15 = decode( l_inv_loc_assignment.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_inv_loc_assignment.ATTRIBUTE15)
412: where CSP_INV_LOC_ASSIGNMENT_ID = l_inv_loc_assignment.CSP_INV_LOC_ASSIGNMENT_ID;
413:
414: If (SQL%NOTFOUND) then
415: RAISE NO_DATA_FOUND;

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

424: x_msg_count => l_msg_count,
425: x_msg_data => l_msg_data
426: ) ;
427:
428: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
429: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
430: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
431: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
432: FND_MSG_PUB.Add;

Line 433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

429: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
430: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
431: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
432: FND_MSG_PUB.Add;
433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
434: END IF;
435: END IF;
436: -- Pre call to the Vertical Type User Hook
437: --

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

444: x_msg_count => l_msg_count,
445: x_msg_data => l_msg_data
446: ) ;
447:
448: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
449: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
450: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
451: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
452: FND_MSG_PUB.Add;

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
450: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
451: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
452: FND_MSG_PUB.Add;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: END IF;
456: csp_inv_loc_assignments_iuhk.update_inventory_location_post
457: ( x_return_status => l_return_status

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

456: csp_inv_loc_assignments_iuhk.update_inventory_location_post
457: ( x_return_status => l_return_status
458: ) ;
459:
460: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
461: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
462: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
463: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
464: FND_MSG_PUB.Add;

Line 465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

461: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
462: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
463: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467: END Update_Row;
468:
469: PROCEDURE Delete_Row(

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

485: x_msg_count => l_msg_count,
486: x_msg_data => l_msg_data
487: ) ;
488:
489: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
490: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
491: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
492: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
493: FND_MSG_PUB.Add;

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
491: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
492: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496: END IF;
497: -- Pre call to the Vertical Type User Hook
498: --

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

505: x_msg_count => l_msg_count,
506: x_msg_data => l_msg_data
507: ) ;
508:
509: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
510: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
511: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
512: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
513: FND_MSG_PUB.Add;

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
511: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
512: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516: END IF;
517: csp_inv_loc_assignments_iuhk.delete_inventory_location_Pre
518: ( x_return_status => l_return_status

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

517: csp_inv_loc_assignments_iuhk.delete_inventory_location_Pre
518: ( x_return_status => l_return_status
519: ) ;
520:
521: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
522: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
523: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
524: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
525: FND_MSG_PUB.Add;

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
523: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
524: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
525: FND_MSG_PUB.Add;
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: DELETE FROM CSP_INV_LOC_ASSIGNMENTS
530: WHERE CSP_INV_LOC_ASSIGNMENT_ID = p_CSP_INV_LOC_ASSIGNMENT_ID;

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

541: x_msg_count => l_msg_count,
542: x_msg_data => l_msg_data
543: ) ;
544:
545: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
546: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
547: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
548: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
549: FND_MSG_PUB.Add;

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
547: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
548: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
549: FND_MSG_PUB.Add;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: END IF;
552: END IF;
553: -- Pre call to the Vertical Type User Hook
554: --

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

561: x_msg_count => l_msg_count,
562: x_msg_data => l_msg_data
563: ) ;
564:
565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
566: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
567: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
568: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
569: FND_MSG_PUB.Add;

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
567: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
568: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
569: FND_MSG_PUB.Add;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: END IF;
573:
574: csp_inv_loc_assignments_iuhk.delete_inventory_location_post

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

574: csp_inv_loc_assignments_iuhk.delete_inventory_location_post
575: ( x_return_status => l_return_status
576: ) ;
577:
578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
579: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
580: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
581: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
582: FND_MSG_PUB.Add;

Line 583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

579: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
580: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
581: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
582: FND_MSG_PUB.Add;
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584: END IF;
585:
586: END Delete_Row;
587: