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_REQUIREMENT_HEADERS_PKG dependencies on FND_API

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

102: x_return_status => l_return_status,
103: x_msg_count => l_msg_count,
104: x_msg_data => l_msg_data
105: ) ;
106: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
107: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
108: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
109: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
110: FND_MSG_PUB.Add;

Line 111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

107: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
108: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
109: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113: END IF;
114:
115:

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

124: x_msg_count => l_msg_count,
125: x_msg_data => l_msg_data
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_VERT_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_VERT_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: END IF;
136:
137: csp_requirement_headers_iuhk.Create_requirement_header_Pre

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

136:
137: csp_requirement_headers_iuhk.Create_requirement_header_Pre
138: ( x_return_status => l_return_status
139: ) ;
140: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
142: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
143: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
144: FND_MSG_PUB.Add;

Line 145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

141: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
142: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
143: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147: If (l_requirement_header.REQUIREMENT_HEADER_ID IS NULL) OR (l_requirement_header.REQUIREMENT_HEADER_ID = FND_API.G_MISS_NUM) then
148: OPEN C2;
149: FETCH C2 INTO px_REQUIREMENT_HEADER_ID;

Line 147: If (l_requirement_header.REQUIREMENT_HEADER_ID IS NULL) OR (l_requirement_header.REQUIREMENT_HEADER_ID = FND_API.G_MISS_NUM) then

143: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
144: FND_MSG_PUB.Add;
145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
146: END IF;
147: If (l_requirement_header.REQUIREMENT_HEADER_ID IS NULL) OR (l_requirement_header.REQUIREMENT_HEADER_ID = FND_API.G_MISS_NUM) then
148: OPEN C2;
149: FETCH C2 INTO px_REQUIREMENT_HEADER_ID;
150: CLOSE C2;
151: End If;

Line 193: decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.CREATED_BY),

189: --TIMEZONE_ID,
190: DESTINATION_SUBINVENTORY
191: ) VALUES (
192: px_REQUIREMENT_HEADER_ID,
193: decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.CREATED_BY),
194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),
195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),

Line 194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),

190: DESTINATION_SUBINVENTORY
191: ) VALUES (
192: px_REQUIREMENT_HEADER_ID,
193: decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.CREATED_BY),
194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),
195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),

Line 195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),

191: ) VALUES (
192: px_REQUIREMENT_HEADER_ID,
193: decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.CREATED_BY),
194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),
195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),

Line 196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),

192: px_REQUIREMENT_HEADER_ID,
193: decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.CREATED_BY),
194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),
195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),

Line 197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),

193: decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.CREATED_BY),
194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),
195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),

Line 198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),

194: decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.CREATION_DATE),
195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),

Line 199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),

195: decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATED_BY),
196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),

Line 200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),

196: decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.LAST_UPDATE_DATE),
197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),

Line 201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),

197: decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, l_requirement_header.LAST_UPDATE_LOGIN),
198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),

Line 202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),

198: decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, NULL, l_requirement_header.OPEN_REQUIREMENT),
199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),

Line 203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),

199: decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.SHIP_TO_LOCATION_ID),
200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),

Line 204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),

200: decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ID),
201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),

Line 205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),

201: decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TASK_ASSIGNMENT_ID),
202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),

Line 206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),

202: decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.SHIPPING_METHOD_CODE),
203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),

Line 207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),

203: decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), l_requirement_header.NEED_BY_DATE),
204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),

Line 208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),

204: decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.DESTINATION_ORGANIZATION_ID),
205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),

Line 209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),

205: decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, NULL, l_requirement_header.PARTS_DEFINED),
206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),

Line 210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),

206: decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE_CATEGORY),
207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),

Line 211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),

207: decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE1),
208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),

Line 212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),

208: decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE2),
209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),

Line 213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),

209: decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE3),
210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),

Line 214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),

210: decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE4),
211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),

Line 215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),

211: decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE5),
212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),

212: decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE6),
213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),

Line 217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),

213: decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE7),
214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),

Line 218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),

214: decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE8),
215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),

Line 219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

215: decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE9),
216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),

Line 220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),

216: decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE10),
217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),

Line 221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),

217: decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE11),
218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),

Line 222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),

218: decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE12),
219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),
226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),

Line 223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),

219: decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),
226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),
227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)

Line 224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),

220: decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE14),
221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),
226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),
227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)
228: );

Line 225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),

221: decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ATTRIBUTE15),
222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),
226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),
227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)
228: );
229:

Line 226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),

222: decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.ORDER_TYPE_ID),
223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),
226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),
227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)
228: );
229:
230: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',

Line 227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)

223: decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.ADDRESS_TYPE),
224: decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.RESOURCE_ID),
225: decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR, NULL, l_requirement_header.RESOURCE_TYPE),
226: --decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, l_requirement_header.TIMEZONE_ID),
227: decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, NULL, l_requirement_header.DESTINATION_SUBINVENTORY)
228: );
229:
230: IF jtf_usr_hks.Ok_To_Execute('CSP_REQUIREMENT_HEADERS_PKG',
231: 'Insert_Row',

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

238: x_msg_data => l_msg_data
239: ) ;
240:
241:
242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
244: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
246: FND_MSG_PUB.Add;

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Customer User Hook');
244: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
245: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
246: FND_MSG_PUB.Add;
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249: END IF;
250:
251:

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

260: x_return_status => l_return_status,
261: x_msg_count => l_msg_count,
262: x_msg_data => l_msg_data
263: ) ;
264: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
265: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
266: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
267: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
268: FND_MSG_PUB.Add;

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Post Vertical User Hook');
266: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
267: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
268: FND_MSG_PUB.Add;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: END IF;
272: csp_requirement_headers_iuhk.Create_requirement_header_post
273: ( x_return_status => l_return_status

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

271: END IF;
272: csp_requirement_headers_iuhk.Create_requirement_header_post
273: ( x_return_status => l_return_status
274: ) ;
275: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
276: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
277: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
278: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
279: FND_MSG_PUB.Add;

Line 280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

276: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
277: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
278: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
279: FND_MSG_PUB.Add;
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: End Insert_Row;
284:

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

372: x_return_status => l_return_status,
373: x_msg_count => l_msg_count,
374: x_msg_data => l_msg_data
375: ) ;
376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
378: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
379: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
380: FND_MSG_PUB.Add;

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

377: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
378: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
379: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383: END IF;
384:
385:

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

394: x_msg_count => l_msg_count,
395: x_msg_data => l_msg_data
396: ) ;
397:
398: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
399: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
400: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
401: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
402: FND_MSG_PUB.Add;

Line 403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

399: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
400: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
401: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
402: FND_MSG_PUB.Add;
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405: END IF;
406: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
407: csp_requirement_headers_iuhk.update_requirement_header_Pre

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

406: user_hooks_rec.REQUIREMENT_HEADER_ID := l_requirement_header.REQUIREMENT_HEADER_ID;
407: csp_requirement_headers_iuhk.update_requirement_header_Pre
408: ( x_return_status => l_return_status
409: ) ;
410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
412: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
413: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
414: FND_MSG_PUB.Add;

Line 415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

411: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
412: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_INT_USR_HK');
413: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
414: FND_MSG_PUB.Add;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: Update CSP_REQUIREMENT_HEADERS
418: SET
419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),

Line 419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: Update CSP_REQUIREMENT_HEADERS
418: SET
419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),

Line 420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),

416: END IF;
417: Update CSP_REQUIREMENT_HEADERS
418: SET
419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),

Line 421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),

417: Update CSP_REQUIREMENT_HEADERS
418: SET
419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),

Line 422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),

418: SET
419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),

Line 423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),

419: CREATED_BY = decode( l_requirement_header.CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, l_requirement_header.CREATED_BY),
420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),

Line 424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),

420: CREATION_DATE = decode( l_requirement_header.CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, l_requirement_header.CREATION_DATE),
421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),

Line 425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),

421: LAST_UPDATED_BY = decode( l_requirement_header.LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, l_requirement_header.LAST_UPDATED_BY),
422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),

Line 426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),

422: LAST_UPDATE_DATE = decode( l_requirement_header.LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, l_requirement_header.LAST_UPDATE_DATE),
423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),

Line 427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),

423: LAST_UPDATE_LOGIN = decode( l_requirement_header.LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, l_requirement_header.LAST_UPDATE_LOGIN),
424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),

Line 428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),

424: OPEN_REQUIREMENT = decode( l_requirement_header.OPEN_REQUIREMENT, FND_API.G_MISS_CHAR, OPEN_REQUIREMENT, l_requirement_header.OPEN_REQUIREMENT),
425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),

Line 429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),

425: SHIP_TO_LOCATION_ID = decode( l_requirement_header.SHIP_TO_LOCATION_ID, FND_API.G_MISS_NUM, SHIP_TO_LOCATION_ID, l_requirement_header.SHIP_TO_LOCATION_ID),
426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),

Line 430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),

426: TASK_ID = decode( l_requirement_header.TASK_ID, FND_API.G_MISS_NUM, TASK_ID, l_requirement_header.TASK_ID),
427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),

Line 431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),

427: TASK_ASSIGNMENT_ID = decode( l_requirement_header.TASK_ASSIGNMENT_ID, FND_API.G_MISS_NUM, TASK_ASSIGNMENT_ID, l_requirement_header.TASK_ASSIGNMENT_ID),
428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),

Line 432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),

428: SHIPPING_METHOD_CODE = decode( l_requirement_header.SHIPPING_METHOD_CODE, FND_API.G_MISS_CHAR, SHIPPING_METHOD_CODE, l_requirement_header.SHIPPING_METHOD_CODE),
429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),

Line 433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),

429: NEED_BY_DATE = decode( l_requirement_header.NEED_BY_DATE, FND_API.G_MISS_DATE, NEED_BY_DATE, l_requirement_header.NEED_BY_DATE),
430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),

Line 434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),

430: DESTINATION_ORGANIZATION_ID = decode( l_requirement_header.DESTINATION_ORGANIZATION_ID, FND_API.G_MISS_NUM, DESTINATION_ORGANIZATION_ID, l_requirement_header.DESTINATION_ORGANIZATION_ID),
431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),

Line 435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),

431: PARTS_DEFINED = decode( l_requirement_header.PARTS_DEFINED, FND_API.G_MISS_CHAR, PARTS_DEFINED, l_requirement_header.PARTS_DEFINED),
432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),

Line 436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),

432: ATTRIBUTE_CATEGORY = decode( l_requirement_header.ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, l_requirement_header.ATTRIBUTE_CATEGORY),
433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),

Line 437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),

433: ATTRIBUTE1 = decode( l_requirement_header.ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, l_requirement_header.ATTRIBUTE1),
434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),

Line 438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),

434: ATTRIBUTE2 = decode( l_requirement_header.ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, l_requirement_header.ATTRIBUTE2),
435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),

Line 439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),

435: ATTRIBUTE3 = decode( l_requirement_header.ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, l_requirement_header.ATTRIBUTE3),
436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),

Line 440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),

436: ATTRIBUTE4 = decode( l_requirement_header.ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, l_requirement_header.ATTRIBUTE4),
437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),

Line 441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),

437: ATTRIBUTE5 = decode( l_requirement_header.ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, l_requirement_header.ATTRIBUTE5),
438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),

Line 442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),

438: ATTRIBUTE6 = decode( l_requirement_header.ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, l_requirement_header.ATTRIBUTE6),
439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),

Line 443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),

439: ATTRIBUTE7 = decode( l_requirement_header.ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, l_requirement_header.ATTRIBUTE7),
440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),

Line 444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),

440: ATTRIBUTE8 = decode( l_requirement_header.ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, l_requirement_header.ATTRIBUTE8),
441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),

Line 445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),

441: ATTRIBUTE9 = decode( l_requirement_header.ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, l_requirement_header.ATTRIBUTE9),
442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),

Line 446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),

442: ATTRIBUTE10 = decode( l_requirement_header.ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, l_requirement_header.ATTRIBUTE10),
443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),

Line 447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),

443: ATTRIBUTE11 = decode( l_requirement_header.ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, l_requirement_header.ATTRIBUTE11),
444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),

Line 448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),

444: ATTRIBUTE12 = decode( l_requirement_header.ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, l_requirement_header.ATTRIBUTE12),
445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),
452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),

Line 449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),

445: ATTRIBUTE13 = decode( l_requirement_header.ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, l_requirement_header.ATTRIBUTE13),
446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),
452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),
453: DESTINATION_SUBINVENTORY = decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, DESTINATION_SUBINVENTORY, l_requirement_header.DESTINATION_SUBINVENTORY)

Line 450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),

446: ATTRIBUTE14 = decode( l_requirement_header.ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, l_requirement_header.ATTRIBUTE14),
447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),
452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),
453: DESTINATION_SUBINVENTORY = decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, DESTINATION_SUBINVENTORY, l_requirement_header.DESTINATION_SUBINVENTORY)
454: where REQUIREMENT_HEADER_ID = l_requirement_header.REQUIREMENT_HEADER_ID;

Line 451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),

447: ATTRIBUTE15 = decode( l_requirement_header.ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, l_requirement_header.ATTRIBUTE15),
448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),
452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),
453: DESTINATION_SUBINVENTORY = decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, DESTINATION_SUBINVENTORY, l_requirement_header.DESTINATION_SUBINVENTORY)
454: where REQUIREMENT_HEADER_ID = l_requirement_header.REQUIREMENT_HEADER_ID;
455:

Line 452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),

448: ORDER_TYPE_ID = decode( l_requirement_header.ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, l_requirement_header.ORDER_TYPE_ID),
449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),
452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),
453: DESTINATION_SUBINVENTORY = decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, DESTINATION_SUBINVENTORY, l_requirement_header.DESTINATION_SUBINVENTORY)
454: where REQUIREMENT_HEADER_ID = l_requirement_header.REQUIREMENT_HEADER_ID;
455:
456: If (SQL%NOTFOUND) then

Line 453: DESTINATION_SUBINVENTORY = decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, DESTINATION_SUBINVENTORY, l_requirement_header.DESTINATION_SUBINVENTORY)

449: ADDRESS_TYPE = decode( l_requirement_header.ADDRESS_TYPE, FND_API.G_MISS_CHAR, ADDRESS_TYPE, l_requirement_header.ADDRESS_TYPE),
450: RESOURCE_ID = decode( l_requirement_header.RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, l_requirement_header.RESOURCE_ID),
451: RESOURCE_TYPE = decode( l_requirement_header.RESOURCE_TYPE, FND_API.G_MISS_CHAR,RESOURCE_TYPE, l_requirement_header.RESOURCE_TYPE),
452: --TIMEZONE_ID = decode( l_requirement_header.TIMEZONE_ID, FND_API.G_MISS_NUM, TIMEZONE_ID, l_requirement_header.TIMEZONE_ID),
453: DESTINATION_SUBINVENTORY = decode( l_requirement_header.DESTINATION_SUBINVENTORY, FND_API.G_MISS_CHAR, DESTINATION_SUBINVENTORY, l_requirement_header.DESTINATION_SUBINVENTORY)
454: where REQUIREMENT_HEADER_ID = l_requirement_header.REQUIREMENT_HEADER_ID;
455:
456: If (SQL%NOTFOUND) then
457: RAISE NO_DATA_FOUND;

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

465: x_return_status => l_return_status,
466: x_msg_count => l_msg_count,
467: x_msg_data => l_msg_data
468: ) ;
469: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
470: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
471: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
472: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
473: FND_MSG_PUB.Add;

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
471: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
472: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
473: FND_MSG_PUB.Add;
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476: END IF;
477:
478:

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

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

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

492: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
493: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
494: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498: END IF;
499: csp_requirement_headers_iuhk.update_requirement_header_post
500: ( x_return_status => l_return_status

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

498: END IF;
499: csp_requirement_headers_iuhk.update_requirement_header_post
500: ( x_return_status => l_return_status
501: ) ;
502: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
503: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
504: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
505: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
506: FND_MSG_PUB.Add;

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

503: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
504: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
505: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
506: FND_MSG_PUB.Add;
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509: END Update_Row;
510:
511: PROCEDURE Delete_Row(

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

526: x_return_status => l_return_status,
527: x_msg_count => l_msg_count,
528: x_msg_data => l_msg_data
529: ) ;
530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
531: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
532: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
533: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
534: FND_MSG_PUB.Add;

Line 535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

531: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
532: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_CUST_USR_HK');
533: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536: END IF;
537: END IF;
538:
539:

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

549: x_msg_count => l_msg_count,
550: x_msg_data => l_msg_data
551: ) ;
552:
553: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
554: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
555: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
556: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
557: FND_MSG_PUB.Add;

Line 558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

554: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
555: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_PRE_VERT_USR_HK');
556: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
557: FND_MSG_PUB.Add;
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END IF;
560: END IF;
561: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
562: csp_requirement_headers_iuhk.delete_requirement_header_Pre

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

561: user_hooks_rec.REQUIREMENT_HEADER_ID := p_REQUIREMENT_HEADER_ID;
562: csp_requirement_headers_iuhk.delete_requirement_header_Pre
563: ( x_return_status => l_return_status
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_PRE_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_PRE_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: DELETE FROM CSP_REQUIREMENT_HEADERS
573: WHERE REQUIREMENT_HEADER_ID = p_REQUIREMENT_HEADER_ID;
574: If (SQL%NOTFOUND) then

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

584: x_return_status => l_return_status,
585: x_msg_count => l_msg_count,
586: x_msg_data => l_msg_data
587: ) ;
588: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
589: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
590: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
591: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
592: FND_MSG_PUB.Add;

Line 593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

589: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Customer User Hook');
590: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_CUST_USR_HK');
591: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
592: FND_MSG_PUB.Add;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595: END IF;
596:
597:

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

607: x_msg_count => l_msg_count,
608: x_msg_data => l_msg_data
609: ) ;
610:
611: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
612: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
613: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
614: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
615: FND_MSG_PUB.Add;

Line 616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

612: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
613: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_VERT_USR_HK');
614: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
617: END IF;
618: END IF;
619: csp_requirement_headers_iuhk.delete_requirement_header_post
620: ( x_return_status => l_return_status

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

618: END IF;
619: csp_requirement_headers_iuhk.delete_requirement_header_post
620: ( x_return_status => l_return_status
621: ) ;
622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
623: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
624: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
626: FND_MSG_PUB.Add;

Line 627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

623: --DBMS_OUTPUT.PUT_LINE('Returned Error Status from the Pre Vertical User Hook');
624: FND_MESSAGE.Set_Name('CSP', 'CSP_ERR_POST_INT_USR_HK');
625: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
626: FND_MSG_PUB.Add;
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: END IF;
629: END Delete_Row;
630:
631: PROCEDURE Lock_Row(