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

Line 125: l_source_org_rec.source_organization_id := FND_API.G_MISS_NUM;

121: EXCEPTION
122: WHEN OTHERS THEN
123: l_sqlcode := SQLCODE;
124: l_sqlerrm := SQLERRM;
125: l_source_org_rec.source_organization_id := FND_API.G_MISS_NUM;
126:
127: End Get_source_organization;
128:
129:

Line 132: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

128:
129:
130: PROCEDURE process_requirement
131: ( p_api_version IN NUMBER
132: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
135: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
136: ,p_create_order_flag IN VARCHAR2

Line 133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

129:
130: PROCEDURE process_requirement
131: ( p_api_version IN NUMBER
132: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
133: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
134: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
135: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
136: ,p_create_order_flag IN VARCHAR2
137: ,x_return_status OUT NOCOPY VARCHAR2

Line 143: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

139: ,x_msg_data OUT NOCOPY VARCHAR2
140: ) IS
141: l_api_version_number CONSTANT NUMBER := 1.0;
142: l_api_name CONSTANT VARCHAR2(30) := 'process_requirement';
143: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
144: l_msg_count NUMBER;
145: l_msg_data VARCHAR2(2000);
146: l_msg_dummy VARCHAR2(2000);
147: l_order_msg VARCHAR2(8000);

Line 148: l_commit VARCHAR2(1) := FND_API.G_FALSE;

144: l_msg_count NUMBER;
145: l_msg_data VARCHAR2(2000);
146: l_msg_dummy VARCHAR2(2000);
147: l_order_msg VARCHAR2(8000);
148: l_commit VARCHAR2(1) := FND_API.G_FALSE;
149: l_user_id NUMBER;
150: l_login_id NUMBER;
151: l_today DATE;
152: EXCP_USER_DEFINED EXCEPTION;

Line 223: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

219:
220: BEGIN
221: SAVEPOINT Process_Requirement_PUB;
222:
223: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
224: -- initialize message list
225: FND_MSG_PUB.initialize;
226: END IF;
227:

Line 229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

225: FND_MSG_PUB.initialize;
226: END IF;
227:
228: -- Standard call to check for call compatibility.
229: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
230: p_api_version,
231: l_api_name,
232: G_PKG_NAME)
233: THEN

Line 234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

230: p_api_version,
231: l_api_name,
232: G_PKG_NAME)
233: THEN
234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: END IF;
236:
237: -- initialize return status
238: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 238: x_return_status := FND_API.G_RET_STS_SUCCESS;

234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
235: END IF;
236:
237: -- initialize return status
238: x_return_status := FND_API.G_RET_STS_SUCCESS;
239:
240: l_header_Rec := px_header_rec;
241: l_line_tbl := px_line_table;
242:

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

281: FND_MESSAGE.Set_Name('CSP', 'CSP_NEED_PASSED');
282: l_order_msg := FND_MESSAGE.GET;
283: END IF;
284: END IF;
285: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: null; --RAISE FND_API.G_EXC_ERROR;
287: END IF;
288: if l_msg_count > 0 THEN
289: for j in 1..fnd_msg_pub.count_msg loop

Line 286: null; --RAISE FND_API.G_EXC_ERROR;

282: l_order_msg := FND_MESSAGE.GET;
283: END IF;
284: END IF;
285: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: null; --RAISE FND_API.G_EXC_ERROR;
287: END IF;
288: if l_msg_count > 0 THEN
289: for j in 1..fnd_msg_pub.count_msg loop
290: fnd_msg_pub.get(

Line 292: FND_API.G_FALSE,

288: if l_msg_count > 0 THEN
289: for j in 1..fnd_msg_pub.count_msg loop
290: fnd_msg_pub.get(
291: j,
292: FND_API.G_FALSE,
293: l_msg_data,
294: l_msg_dummy);
295: l_order_msg := l_order_msg || l_msg_data;
296: end loop;

Line 323: (l_line_Tbl(I).source_organization_id = FND_API.G_MISS_NUM)) THEN

319: P_Organization_Id => l_header_Rec.dest_organization_id,
320: P_Secondary_Inventory => l_header_rec.dest_subinventory,
321: x_source_org_id => l_line_Tbl(I).source_organization_id);
322: IF ((l_line_Tbl(I).source_organization_id IS NULL) OR
323: (l_line_Tbl(I).source_organization_id = FND_API.G_MISS_NUM)) THEN
324: -- no source organization defined, create requirement with error status
325: l_rqmt_header_rec.open_requirement := 'E';
326: END IF;
327: END If;

Line 381: ,p_commit => FND_API.G_false

377: -- call csp_process_order API
378: csp_parts_order.process_order(
379: p_api_version => l_api_version_number
380: ,p_Init_Msg_List => p_init_msg_list
381: ,p_commit => FND_API.G_false
382: ,px_header_rec => l_header_rec
383: ,px_line_table => l_line_tbl
384: ,x_return_status => l_return_status
385: ,x_msg_count => l_msg_count

Line 390: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

386: ,x_msg_data => l_msg_data
387: );
388:
389: -- set parts_defined to 'Y' if order has been created for this requirement
390: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
391: l_parts_defined := 'Y';
392: l_rqmt_header_rec.open_requirement := 'Y';
393: px_header_rec.order_header_id := l_header_Rec.order_header_id;
394: l_order_msg := null;

Line 400: FND_API.G_FALSE,

396: l_rqmt_header_rec.open_requirement := 'E';
397: for j in 1..fnd_msg_pub.count_msg loop
398: fnd_msg_pub.get(
399: j,
400: FND_API.G_FALSE,
401: l_msg_data,
402: l_msg_dummy);
403: l_order_msg := l_order_msg || l_msg_data;
404: end loop;

Line 413: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

409: IF (l_header_rec.operation = G_OPR_CREATE) THEN
410: l_rqmt_header_Rec.created_by := nvl(l_user_id, -1);
411: l_rqmt_header_Rec.creation_date := l_today;
412: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
413: IF nvl(l_header_rec.requirement_header_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
414: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
415: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_header_rec.requirement_header_id', FALSE);
416: FND_MSG_PUB.ADD;
417: RAISE EXCP_USER_DEFINED;

Line 442: l_rqmt_header_Rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM); --l_requirement_header_id;

438: END;
439: END IF;
440: END IF;
441:
442: l_rqmt_header_Rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM); --l_requirement_header_id;
443: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
444: l_rqmt_header_Rec.last_update_date := l_today;
445: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);

Line 446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);

442: l_rqmt_header_Rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM); --l_requirement_header_id;
443: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
444: l_rqmt_header_Rec.last_update_date := l_today;
445: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);

Line 447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);

443: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
444: l_rqmt_header_Rec.last_update_date := l_today;
445: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);

Line 449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);

445: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);

Line 450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);

446: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);

Line 451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);

447: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);

Line 452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);

448: l_rqmt_header_Rec.address_type := l_header_rec.address_type;-- csp_parts_Requirement.G_ADDR_RESOURCE;
449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';

Line 453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);

449: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);

Line 454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);

450: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);

Line 455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);

451: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
452: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);

Line 457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);

453: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);

Line 458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);

454: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);

Line 459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);

455: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);

Line 460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);

456: -- l_rqmt_header_Rec.open_requirement := 'Y';
457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);

Line 461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);

457: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_API.G_MISS_NUM);
458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);

Line 462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);

458: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);

Line 463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);

459: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);

Line 464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);

460: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);

Line 465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);

461: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);

Line 466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);

462: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);

Line 467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);

463: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);

Line 468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);

464: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);

Line 469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);

465: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);

Line 470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);

466: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
474: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);

Line 471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);

467: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
474: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
475:

Line 472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);

468: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
474: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
475:
476: if (l_header_Rec.task_assignment_id IS NULL)

Line 473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);

469: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
474: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
475:
476: if (l_header_Rec.task_assignment_id IS NULL)
477: and (l_header_Rec.resource_id is null

Line 474: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);

470: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
471: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
472: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
473: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
474: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
475:
476: if (l_header_Rec.task_assignment_id IS NULL)
477: and (l_header_Rec.resource_id is null
478: or l_header_rec.resource_type is null) then

Line 498: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

494: IF (l_header_rec.operation = G_OPR_CREATE) THEN
495: l_rqmt_line_Rec.created_by := nvl(l_user_id, -1);
496: l_rqmt_line_Rec.creation_date := l_today;
497: ELSIF (l_header_rec.operation IN (G_OPR_UPDATE, G_OPR_DELETE)) THEN
498: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
499:
500: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
501: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
502: FND_MSG_PUB.ADD;

Line 532: --l_rqmt_line_rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM);

528: l_rqmt_line_Rec.requirement_line_id := l_line_rec.requirement_line_id;
529: l_rqmt_line_rec.last_updated_by := nvl(l_user_id, 1);
530: l_rqmt_line_rec.last_update_date := l_today;
531: l_rqmt_line_rec.last_update_login := nvl(l_login_id, -1);
532: --l_rqmt_line_rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM);
533:
534: l_rqmt_line_rec.inventory_item_id := l_line_rec.inventory_item_id;
535: l_rqmt_line_rec.uom_code := l_line_rec.unit_of_measure;
536: l_rqmt_line_rec.required_quantity := l_line_rec.quantity;

Line 548: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);

544:
545: l_rqmt_line_rec.reservation_id := l_line_rec.reservation_id;
546: l_rqmt_line_rec.order_by_date := l_line_rec.order_by_date;*/
547:
548: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);

Line 549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);

545: l_rqmt_line_rec.reservation_id := l_line_rec.reservation_id;
546: l_rqmt_line_rec.order_by_date := l_line_rec.order_by_date;*/
547:
548: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);

Line 550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);

546: l_rqmt_line_rec.order_by_date := l_line_rec.order_by_date;*/
547:
548: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);

Line 551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);

547:
548: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);

Line 552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);

548: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);

Line 553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);

549: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);

Line 554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);

550: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);

Line 555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);

551: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);

Line 556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);

552: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);

Line 557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);

553: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);

Line 558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);

554: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);

Line 559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);

555: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
563: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);

Line 560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);

556: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
563: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
564:

Line 561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);

557: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
563: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
564:
565: l_rqmt_line_rec.order_line_id := l_line_Rec.order_line_id;

Line 562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);

558: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
563: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
564:
565: l_rqmt_line_rec.order_line_id := l_line_Rec.order_line_id;
566: px_line_table(I).order_line_id := l_line_Rec.order_line_id;

Line 563: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);

559: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
560: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
561: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
562: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
563: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
564:
565: l_rqmt_line_rec.order_line_id := l_line_Rec.order_line_id;
566: px_line_table(I).order_line_id := l_line_Rec.order_line_id;
567: l_rqmt_line_Tbl(I) := l_rqmt_line_rec;

Line 587: P_Commit => FND_API.G_FALSE,

583: -- call private api for inserting into csp_Requirement_headers
584: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
585: P_Api_Version_Number => l_api_Version_number,
586: P_Init_Msg_List => p_init_msg_list,
587: P_Commit => FND_API.G_FALSE,
588: p_validation_level => null,
589: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
590: X_REQUIREMENT_HEADER_ID => l_requirement_header_id,
591: X_Return_Status => l_Return_status,

Line 595: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

591: X_Return_Status => l_Return_status,
592: X_Msg_Count => l_msg_count,
593: X_Msg_Data => l_msg_data
594: );
595: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSE
598: IF l_order_msg IS NOT null THEN
599: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');

Line 596: RAISE FND_API.G_EXC_ERROR;

592: X_Msg_Count => l_msg_count,
593: X_Msg_Data => l_msg_data
594: );
595: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: RAISE FND_API.G_EXC_ERROR;
597: ELSE
598: IF l_order_msg IS NOT null THEN
599: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
600: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

Line 619: P_Commit => FND_API.G_FALSE,

615: -- call private api for inserting into csp_Requirement_headers
616: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
617: P_Api_Version_Number => l_api_Version_number,
618: P_Init_Msg_List => p_init_msg_list,
619: P_Commit => FND_API.G_FALSE,
620: p_validation_level => null,
621: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
622: X_REQUIREMENT_HEADER_ID => l_requirement_header_id,
623: X_Return_Status => l_Return_status,

Line 627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

623: X_Return_Status => l_Return_status,
624: X_Msg_Count => l_msg_count,
625: X_Msg_Data => l_msg_data
626: );
627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSE
630: IF l_order_msg IS NOT null THEN
631: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');

Line 628: RAISE FND_API.G_EXC_ERROR;

624: X_Msg_Count => l_msg_count,
625: X_Msg_Data => l_msg_data
626: );
627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
628: RAISE FND_API.G_EXC_ERROR;
629: ELSE
630: IF l_order_msg IS NOT null THEN
631: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
632: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

Line 642: P_Commit => FND_API.G_FALSE,

638: -- call private api for inserting into csp_Requirement_headers
639: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
640: P_Api_Version_Number => l_api_Version_number,
641: P_Init_Msg_List => p_init_msg_list,
642: P_Commit => FND_API.G_FALSE,
643: p_validation_level => null,
644: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
645: X_REQUIREMENT_HEADER_ID => l_requirement_header_id,
646: X_Return_Status => l_Return_status,

Line 650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

646: X_Return_Status => l_Return_status,
647: X_Msg_Count => l_msg_count,
648: X_Msg_Data => l_msg_data
649: );
650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSE
653: IF l_order_msg IS NOT null THEN
654: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');

Line 651: RAISE FND_API.G_EXC_ERROR;

647: X_Msg_Count => l_msg_count,
648: X_Msg_Data => l_msg_data
649: );
650: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE FND_API.G_EXC_ERROR;
652: ELSE
653: IF l_order_msg IS NOT null THEN
654: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_CREATED');
655: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

Line 673: P_Commit => FND_API.G_FALSE,

669: -- call private api for inserting into csp_requirement_lines
670: CSP_Requirement_Lines_PVT.Create_requirement_lines(
671: P_Api_Version_Number => l_api_version_number,
672: P_Init_Msg_List => p_Init_Msg_List,
673: P_Commit => FND_API.G_FALSE,
674: p_validation_level => null,
675: P_Requirement_Line_Tbl => l_rqmt_line_tbl,
676: x_Requirement_Line_tbl => x_rqmt_line_tbl,
677: X_Return_Status => l_return_status,

Line 682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

678: X_Msg_Count => l_msg_count,
679: X_Msg_Data => l_msg_data
680: );
681:
682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_ERROR;
684: ELSE
685: IF x_msg_data IS null and l_order_msg is not null THEN
686: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');

Line 683: RAISE FND_API.G_EXC_ERROR;

679: X_Msg_Data => l_msg_data
680: );
681:
682: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
683: RAISE FND_API.G_EXC_ERROR;
684: ELSE
685: IF x_msg_data IS null and l_order_msg is not null THEN
686: FND_MESSAGE.Set_Name('CSP', 'CSP_REQ_UPDATED');
687: FND_MESSAGE.Set_Token('REQ_NUMBER',to_char(l_requirement_header_id));

Line 715: P_Commit => FND_API.G_FALSE,

711: -- call private api for updating requirement headers
712: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
713: P_Api_Version_Number => l_api_Version_number,
714: P_Init_Msg_List => p_init_msg_list,
715: P_Commit => FND_API.G_FALSE,
716: p_validation_level => null,
717: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
718: X_Return_Status => l_Return_status,
719: X_Msg_Count => l_msg_count,

Line 723: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

719: X_Msg_Count => l_msg_count,
720: X_Msg_Data => l_msg_data
721: );
722:
723: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726:
727: -- call private api for updating requirement lines

Line 724: RAISE FND_API.G_EXC_ERROR;

720: X_Msg_Data => l_msg_data
721: );
722:
723: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726:
727: -- call private api for updating requirement lines
728: --FOR I in 1..l_rqmt_line_tbl.COUNT LOOP

Line 732: P_Commit => FND_API.G_FALSE,

728: --FOR I in 1..l_rqmt_line_tbl.COUNT LOOP
729: CSP_Requirement_Lines_PVT.Update_requirement_lines(
730: P_Api_Version_Number => l_api_version_number,
731: P_Init_Msg_List => p_Init_Msg_List,
732: P_Commit => FND_API.G_FALSE,
733: p_validation_level => null,
734: P_Requirement_Line_Tbl => l_rqmt_line_tbl,
735: X_Return_Status => l_return_status,
736: X_Msg_Count => l_msg_count,

Line 740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

736: X_Msg_Count => l_msg_count,
737: X_Msg_Data => l_msg_data
738: );
739:
740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: --END LOOP;

Line 741: RAISE FND_API.G_EXC_ERROR;

737: X_Msg_Data => l_msg_data
738: );
739:
740: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: --END LOOP;
745: If p_commit = FND_API.G_TRUE then

Line 745: If p_commit = FND_API.G_TRUE then

741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743:
744: --END LOOP;
745: If p_commit = FND_API.G_TRUE then
746: commit work;
747: end if;
748: END IF;
749: IF x_msg_data is not null or l_order_msg is not null THEN

Line 753: WHEN FND_API.G_EXC_ERROR THEN

749: IF x_msg_data is not null or l_order_msg is not null THEN
750: x_msg_data := x_msg_data || ' ' || l_order_msg;
751: END IF;
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
755: P_API_NAME => L_API_NAME
756: ,P_PKG_NAME => G_PKG_NAME
757: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

758: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
759: ,X_MSG_COUNT => X_MSG_COUNT
760: ,X_MSG_DATA => X_MSG_DATA
761: ,X_RETURN_STATUS => X_RETURN_STATUS);
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
764: P_API_NAME => L_API_NAME
765: ,P_PKG_NAME => G_PKG_NAME
766: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: FND_MSG_PUB.ADD;
777: fnd_msg_pub.count_and_get
778: ( p_count => x_msg_count
779: , p_data => x_msg_data);
780: x_return_status := FND_API.G_RET_STS_ERROR;
781:
782: END;
783:
784:

Line 788: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

784:
785:
786: PROCEDURE csptrreq_fm_order(
787: p_api_version IN NUMBER
788: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
791: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
792: ,x_return_status OUT NOCOPY VARCHAR2

Line 789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

785:
786: PROCEDURE csptrreq_fm_order(
787: p_api_version IN NUMBER
788: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
789: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
790: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
791: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
792: ,x_return_status OUT NOCOPY VARCHAR2
793: ,x_msg_count OUT NOCOPY NUMBER

Line 798: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

794: ,x_msg_data OUT NOCOPY VARCHAR2
795: ) IS
796: l_api_version_number CONSTANT NUMBER := 1.0;
797: l_api_name CONSTANT VARCHAR2(30) := 'csptrreq_fm_order';
798: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
799: l_msg_count NUMBER;
800: l_msg_data VARCHAR2(4000);
801: l_commit VARCHAR2(1) := FND_API.G_FALSE;
802: l_user_id NUMBER;

Line 801: l_commit VARCHAR2(1) := FND_API.G_FALSE;

797: l_api_name CONSTANT VARCHAR2(30) := 'csptrreq_fm_order';
798: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
799: l_msg_count NUMBER;
800: l_msg_data VARCHAR2(4000);
801: l_commit VARCHAR2(1) := FND_API.G_FALSE;
802: l_user_id NUMBER;
803: l_login_id NUMBER;
804: l_today DATE;
805: EXCP_USER_DEFINED EXCEPTION;

Line 847: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

843: BEGIN
844:
845: SAVEPOINT csptrreq_fm_order_PUB;
846:
847: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
848: -- initialize message list
849: FND_MSG_PUB.initialize;
850: END IF;
851:

Line 853: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: -- Standard call to check for call compatibility.
853: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
854: p_api_version,
855: l_api_name,
856: G_PKG_NAME)
857: THEN

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: p_api_version,
855: l_api_name,
856: G_PKG_NAME)
857: THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860:
861: -- initialize return status
862: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 862: x_return_status := FND_API.G_RET_STS_SUCCESS;

858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860:
861: -- initialize return status
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863:
864: l_header_Rec := px_header_rec;
865: l_old_line_tbl := px_line_table;
866:

Line 896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

892: x_return_status => l_return_status,
893: x_msg_count => l_msg_count,
894: x_msg_Data => l_msg_data
895: );
896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
897: RAISE FND_API.G_EXC_ERROR;
898: END If;
899: END IF;
900:

Line 897: RAISE FND_API.G_EXC_ERROR;

893: x_msg_count => l_msg_count,
894: x_msg_Data => l_msg_data
895: );
896: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
897: RAISE FND_API.G_EXC_ERROR;
898: END If;
899: END IF;
900:
901: IF (l_qty_to_Reserve < l_resource_att and l_qty_to_reserve > 0) THEN

Line 918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

914: --x_msg_count => l_msg_Count,
915: x_msg_data => l_msg_data
916:
917: );
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END If;
921:
922: update csp_Requirement_lines

Line 919: RAISE FND_API.G_EXC_ERROR;

915: x_msg_data => l_msg_data
916:
917: );
918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END If;
921:
922: update csp_Requirement_lines
923: set local_Reservation_id = l_local_Reservation_id

Line 952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

948: ,x_msg_count => l_msg_count
949: ,x_msg_data => l_msg_data
950: );
951:
952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
953: RAISE FND_API.G_EXC_ERROR;
954: ELSE
955: -- update csp_requirement_line table with order information
956: FOR I IN 1..l_line_tbl.COUNT LOOP

Line 953: RAISE FND_API.G_EXC_ERROR;

949: ,x_msg_data => l_msg_data
950: );
951:
952: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
953: RAISE FND_API.G_EXC_ERROR;
954: ELSE
955: -- update csp_requirement_line table with order information
956: FOR I IN 1..l_line_tbl.COUNT LOOP
957: l_line_rec := l_line_tbl(I);

Line 959: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

955: -- update csp_requirement_line table with order information
956: FOR I IN 1..l_line_tbl.COUNT LOOP
957: l_line_rec := l_line_tbl(I);
958:
959: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
960:
961: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
962: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
963:

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

1013: ,x_msg_count => l_msg_count
1014: ,x_msg_data => l_msg_data
1015: );
1016:
1017: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1018: RAISE FND_API.G_EXC_ERROR;
1019: ELSE
1020: -- now update csp_requirement_line table with purchase req information
1021: J := l_line_tbl.count + 1;

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: ,x_msg_data => l_msg_data
1015: );
1016:
1017: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1018: RAISE FND_API.G_EXC_ERROR;
1019: ELSE
1020: -- now update csp_requirement_line table with purchase req information
1021: J := l_line_tbl.count + 1;
1022: FOR I IN 1..l_po_line_tbl.COUNT LOOP

Line 1025: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

1021: J := l_line_tbl.count + 1;
1022: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1023: l_line_rec := l_po_line_tbl(I);
1024:
1025: IF nvl(l_line_rec.requirement_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
1026:
1027: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
1028: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requirement_line_id', FALSE);
1029:

Line 1083: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1079: X_Msg_Count => l_msg_count,
1080: X_Msg_Data => l_msg_data
1081: );
1082:
1083: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086:
1087: -- assign output variables

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: X_Msg_Data => l_msg_data
1081: );
1082:
1083: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086:
1087: -- assign output variables
1088: px_header_rec := l_header_rec;

Line 1094: WHEN FND_API.G_EXC_ERROR THEN

1090:
1091: END IF;
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1096: P_API_NAME => L_API_NAME
1097: ,P_PKG_NAME => G_PKG_NAME
1098: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1099: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1100: ,X_MSG_COUNT => X_MSG_COUNT
1101: ,X_MSG_DATA => X_MSG_DATA
1102: ,X_RETURN_STATUS => X_RETURN_STATUS);
1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1104: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1105: P_API_NAME => L_API_NAME
1106: ,P_PKG_NAME => G_PKG_NAME
1107: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1121: x_return_status := FND_API.G_RET_STS_ERROR;

1117: FND_MSG_PUB.ADD;
1118: fnd_msg_pub.count_and_get
1119: ( p_count => x_msg_count
1120: , p_data => x_msg_data);
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122:
1123: END csptrreq_fm_order;
1124:
1125: PROCEDURE csptrreq_order_res(

Line 1127: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

1123: END csptrreq_fm_order;
1124:
1125: PROCEDURE csptrreq_order_res(
1126: p_api_version IN NUMBER
1127: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1129: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1130: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1131: ,x_return_status OUT NOCOPY VARCHAR2

Line 1128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1124:
1125: PROCEDURE csptrreq_order_res(
1126: p_api_version IN NUMBER
1127: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1128: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1129: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1130: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1131: ,x_return_status OUT NOCOPY VARCHAR2
1132: ,x_msg_count OUT NOCOPY NUMBER

Line 1137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1133: ,x_msg_data OUT NOCOPY VARCHAR2
1134: ) IS
1135: l_api_version_number CONSTANT NUMBER := 1.0;
1136: l_api_name CONSTANT VARCHAR2(30) := 'csptrreq_fm_order';
1137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1138: l_msg_count NUMBER;
1139: l_msg_data VARCHAR2(4000);
1140: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1141: l_user_id NUMBER;

Line 1140: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1136: l_api_name CONSTANT VARCHAR2(30) := 'csptrreq_fm_order';
1137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1138: l_msg_count NUMBER;
1139: l_msg_data VARCHAR2(4000);
1140: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1141: l_user_id NUMBER;
1142: l_login_id NUMBER;
1143: l_today DATE;
1144: EXCP_USER_DEFINED EXCEPTION;

Line 1182: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1178: BEGIN
1179:
1180: SAVEPOINT csptrreq_fm_order_PUB;
1181:
1182: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1183: -- initialize message list
1184: FND_MSG_PUB.initialize;
1185: END IF;
1186:

Line 1188: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1184: FND_MSG_PUB.initialize;
1185: END IF;
1186:
1187: -- Standard call to check for call compatibility.
1188: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1189: p_api_version,
1190: l_api_name,
1191: G_PKG_NAME)
1192: THEN

Line 1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1189: p_api_version,
1190: l_api_name,
1191: G_PKG_NAME)
1192: THEN
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: -- initialize return status
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1197: x_return_status := FND_API.G_RET_STS_SUCCESS;

1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195:
1196: -- initialize return status
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1199: l_header_Rec := px_header_rec;
1200: l_line_tbl := px_line_table;
1201:

Line 1244: ,p_Init_Msg_List => FND_API.G_FALSE

1240: end if;
1241:
1242: csp_ship_to_address_pvt.cust_inv_loc_link
1243: ( p_api_version => 1.0
1244: ,p_Init_Msg_List => FND_API.G_FALSE
1245: ,p_commit => FND_API.G_FALSE
1246: ,px_location_id => l_header_Rec.ship_to_location_id
1247: ,p_party_site_id => l_party_site_id
1248: ,p_cust_account_id => l_cust_account_id

Line 1245: ,p_commit => FND_API.G_FALSE

1241:
1242: csp_ship_to_address_pvt.cust_inv_loc_link
1243: ( p_api_version => 1.0
1244: ,p_Init_Msg_List => FND_API.G_FALSE
1245: ,p_commit => FND_API.G_FALSE
1246: ,px_location_id => l_header_Rec.ship_to_location_id
1247: ,p_party_site_id => l_party_site_id
1248: ,p_cust_account_id => l_cust_account_id
1249: ,p_customer_id => l_customer_id

Line 1282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1278: 'csp.plsql.csp_parts_requirement.csptrreq_order_res',
1279: 'l_return_status = ' || l_return_status);
1280: end if;
1281:
1282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1283: RAISE FND_API.G_EXC_ERROR;
1284: END IF;
1285: END IF;
1286:

Line 1283: RAISE FND_API.G_EXC_ERROR;

1279: 'l_return_status = ' || l_return_status);
1280: end if;
1281:
1282: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1283: RAISE FND_API.G_EXC_ERROR;
1284: END IF;
1285: END IF;
1286:
1287: -- create reservations and create line table which qualify for creating order

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

1302: p_reservation_parts => l_reservation_rec,
1303: x_return_status => l_return_status,
1304: x_msg_data => l_msg_data
1305: );
1306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSE
1309: -- code for inserting into req line dtls
1310: SELECT csp_req_line_Details_s1.nextval

Line 1307: RAISE FND_API.G_EXC_ERROR;

1303: x_return_status => l_return_status,
1304: x_msg_data => l_msg_data
1305: );
1306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSE
1309: -- code for inserting into req line dtls
1310: SELECT csp_req_line_Details_s1.nextval
1311: INTO l_req_line_Dtl_id

Line 1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1345: ,x_msg_count => l_msg_count
1346: ,x_msg_data => l_msg_data
1347: );
1348:
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: ELSE
1352: -- insert record in csp_req_line_details table with order information
1353: FOR I IN 1..l_oe_line_tbl.COUNT LOOP

Line 1350: RAISE FND_API.G_EXC_ERROR;

1346: ,x_msg_data => l_msg_data
1347: );
1348:
1349: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1350: RAISE FND_API.G_EXC_ERROR;
1351: ELSE
1352: -- insert record in csp_req_line_details table with order information
1353: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1354: l_line_rec := l_oe_line_tbl(I);

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

1383: ,x_msg_count => l_msg_count
1384: ,x_msg_data => l_msg_data
1385: );
1386:
1387: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSE
1390: -- insert into csp_req_line_Details table with purchase req information
1391: FOR I IN 1..l_po_line_tbl.COUNT LOOP

Line 1388: RAISE FND_API.G_EXC_ERROR;

1384: ,x_msg_data => l_msg_data
1385: );
1386:
1387: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1388: RAISE FND_API.G_EXC_ERROR;
1389: ELSE
1390: -- insert into csp_req_line_Details table with purchase req information
1391: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1392: l_line_rec := l_po_line_tbl(I);

Line 1416: WHEN FND_API.G_EXC_ERROR THEN

1412: px_header_rec := l_header_rec;
1413: px_line_table := l_line_tbl;
1414:
1415: EXCEPTION
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1418: P_API_NAME => L_API_NAME
1419: ,P_PKG_NAME => G_PKG_NAME
1420: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1421: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1422: ,X_MSG_COUNT => X_MSG_COUNT
1423: ,X_MSG_DATA => X_MSG_DATA
1424: ,X_RETURN_STATUS => X_RETURN_STATUS);
1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1426: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1427: P_API_NAME => L_API_NAME
1428: ,P_PKG_NAME => G_PKG_NAME
1429: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1443: x_return_status := FND_API.G_RET_STS_ERROR;

1439: FND_MSG_PUB.ADD;
1440: fnd_msg_pub.count_and_get
1441: ( p_count => x_msg_count
1442: , p_data => x_msg_data);
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END;
1445:
1446: PROCEDURE delete_rqmt_header(
1447: p_api_version IN NUMBER

Line 1448: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

1444: END;
1445:
1446: PROCEDURE delete_rqmt_header(
1447: p_api_version IN NUMBER
1448: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1449: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1450: ,p_header_id IN NUMBER
1451: ,x_return_status OUT NOCOPY VARCHAR2
1452: ,x_msg_count OUT NOCOPY NUMBER

Line 1449: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1445:
1446: PROCEDURE delete_rqmt_header(
1447: p_api_version IN NUMBER
1448: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1449: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1450: ,p_header_id IN NUMBER
1451: ,x_return_status OUT NOCOPY VARCHAR2
1452: ,x_msg_count OUT NOCOPY NUMBER
1453: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1462: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1458: l_count NUMBER;
1459: BEGIN
1460: SAVEPOINT delete_rqmt_header_PUB;
1461:
1462: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1463: -- initialize message list
1464: FND_MSG_PUB.initialize;
1465: END IF;
1466:

Line 1468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1464: FND_MSG_PUB.initialize;
1465: END IF;
1466:
1467: -- Standard call to check for call compatibility.
1468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1469: p_api_version,
1470: l_api_name,
1471: G_PKG_NAME)
1472: THEN

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469: p_api_version,
1470: l_api_name,
1471: G_PKG_NAME)
1472: THEN
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END IF;
1475:
1476: -- initialize return status
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END IF;
1475:
1476: -- initialize return status
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478:
1479: IF (p_header_id IS NOT NULL) THEN
1480: SELECT count(*)
1481: INTO l_count

Line 1499: IF fnd_api.to_boolean(p_commit) THEN

1495: DELETE FROM csp_requirement_headers
1496: WHERE requirement_header_id = p_header_id;
1497: END IF;
1498:
1499: IF fnd_api.to_boolean(p_commit) THEN
1500: commit work;
1501: END IF;
1502: x_return_status := FND_API.G_RET_STS_SUCCESS;
1503: END IF;

Line 1502: x_return_status := FND_API.G_RET_STS_SUCCESS;

1498:
1499: IF fnd_api.to_boolean(p_commit) THEN
1500: commit work;
1501: END IF;
1502: x_return_status := FND_API.G_RET_STS_SUCCESS;
1503: END IF;
1504: EXCEPTION
1505: WHEN EXCP_USER_DEFINED THEN
1506: Rollback to delete_rqmt_header_PUB;

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

1503: END IF;
1504: EXCEPTION
1505: WHEN EXCP_USER_DEFINED THEN
1506: Rollback to delete_rqmt_header_PUB;
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: fnd_msg_pub.count_and_get
1509: ( p_count => x_msg_count
1510: , p_data => x_msg_data);
1511:

Line 1512: WHEN FND_API.G_EXC_ERROR THEN

1508: fnd_msg_pub.count_and_get
1509: ( p_count => x_msg_count
1510: , p_data => x_msg_data);
1511:
1512: WHEN FND_API.G_EXC_ERROR THEN
1513: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1514: P_API_NAME => L_API_NAME
1515: ,P_PKG_NAME => G_PKG_NAME
1516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1517: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1518: ,X_MSG_COUNT => X_MSG_COUNT
1519: ,X_MSG_DATA => X_MSG_DATA
1520: ,X_RETURN_STATUS => X_RETURN_STATUS);
1521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1522: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1523: P_API_NAME => L_API_NAME
1524: ,P_PKG_NAME => G_PKG_NAME
1525: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: FND_MSG_PUB.ADD;
1536: fnd_msg_pub.count_and_get
1537: ( p_count => x_msg_count
1538: , p_data => x_msg_data);
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: END;
1541:
1542: PROCEDURE save_rqmt_line(
1543: p_api_version IN NUMBER

Line 1544: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

1540: END;
1541:
1542: PROCEDURE save_rqmt_line(
1543: p_api_version IN NUMBER
1544: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1545: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1546: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1547: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
1548: ,x_return_status OUT NOCOPY VARCHAR2

Line 1545: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

1541:
1542: PROCEDURE save_rqmt_line(
1543: p_api_version IN NUMBER
1544: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1545: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1546: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1547: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
1548: ,x_return_status OUT NOCOPY VARCHAR2
1549: ,x_msg_count OUT NOCOPY NUMBER

Line 1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;
1567: l_msg_data VARCHAR2(2000);
1568: l_requirement_header_id NUMBER;
1569: l_resource_name VARCHAR2(240);

Line 1610: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

1606: */
1607: BEGIN
1608: SAVEPOINT save_rqmt_line_PUB;
1609:
1610: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
1611: -- initialize message list
1612: FND_MSG_PUB.initialize;
1613: END IF;
1614:

Line 1616: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1612: FND_MSG_PUB.initialize;
1613: END IF;
1614:
1615: -- Standard call to check for call compatibility.
1616: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1617: p_api_version,
1618: l_api_name,
1619: G_PKG_NAME)
1620: THEN

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1618: l_api_name,
1619: G_PKG_NAME)
1620: THEN
1621:
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624:
1625: -- initialize return status
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1626: x_return_status := FND_API.G_RET_STS_SUCCESS;

1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624:
1625: -- initialize return status
1626: x_return_status := FND_API.G_RET_STS_SUCCESS;
1627: l_header_Rec := px_header_rec;
1628: l_line_tbl := px_line_tbl;
1629:
1630: -- user and login information

Line 1711: ,p_Init_Msg_List => FND_API.G_FALSE

1707: CLOSE get_party_details;
1708:
1709: csp_ship_to_address_pvt.cust_inv_loc_link
1710: ( p_api_version => 1.0
1711: ,p_Init_Msg_List => FND_API.G_FALSE
1712: ,p_commit => FND_API.G_FALSE
1713: ,px_location_id => l_header_Rec.ship_to_location_id
1714: ,p_party_site_id => l_party_site_id
1715: ,p_cust_account_id => l_cust_account_id

Line 1712: ,p_commit => FND_API.G_FALSE

1708:
1709: csp_ship_to_address_pvt.cust_inv_loc_link
1710: ( p_api_version => 1.0
1711: ,p_Init_Msg_List => FND_API.G_FALSE
1712: ,p_commit => FND_API.G_FALSE
1713: ,px_location_id => l_header_Rec.ship_to_location_id
1714: ,p_party_site_id => l_party_site_id
1715: ,p_cust_account_id => l_cust_account_id
1716: ,p_customer_id => l_customer_id

Line 1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1738: ,p_attribute20 => null
1739: ,x_return_status => l_return_status
1740: ,x_msg_count => l_msg_count
1741: ,x_msg_data => l_msg_data);
1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745: END IF;
1746:

Line 1743: RAISE FND_API.G_EXC_ERROR;

1739: ,x_return_status => l_return_status
1740: ,x_msg_count => l_msg_count
1741: ,x_msg_data => l_msg_data);
1742: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745: END IF;
1746:
1747: l_rqmt_header_Rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM);

Line 1747: l_rqmt_header_Rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM);

1743: RAISE FND_API.G_EXC_ERROR;
1744: END IF;
1745: END IF;
1746:
1747: l_rqmt_header_Rec.requirement_header_id := nvl(l_header_rec.requirement_header_id, FND_API.G_MISS_NUM);
1748: l_rqmt_header_Rec.created_by := nvl(l_user_id, -1);
1749: l_rqmt_header_Rec.creation_date := l_today;
1750: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
1751: l_rqmt_header_Rec.last_update_date := l_today;

Line 1753: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);

1749: l_rqmt_header_Rec.creation_date := l_today;
1750: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
1751: l_rqmt_header_Rec.last_update_date := l_today;
1752: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
1753: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1754: l_rqmt_header_Rec.address_type := l_header_Rec.address_type;
1755: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1756: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
1757: IF(l_header_rec.task_id IS NULL) THEN

Line 1755: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);

1751: l_rqmt_header_Rec.last_update_date := l_today;
1752: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
1753: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1754: l_rqmt_header_Rec.address_type := l_header_Rec.address_type;
1755: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1756: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
1757: IF(l_header_rec.task_id IS NULL) THEN
1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);
1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);

Line 1756: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);

1752: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
1753: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1754: l_rqmt_header_Rec.address_type := l_header_Rec.address_type;
1755: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1756: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
1757: IF(l_header_rec.task_id IS NULL) THEN
1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);
1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);
1760: END IF;

Line 1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);

1754: l_rqmt_header_Rec.address_type := l_header_Rec.address_type;
1755: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1756: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
1757: IF(l_header_rec.task_id IS NULL) THEN
1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);
1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);
1760: END IF;
1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);

Line 1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);

1755: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1756: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
1757: IF(l_header_rec.task_id IS NULL) THEN
1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);
1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);
1760: END IF;
1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);

Line 1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);

1757: IF(l_header_rec.task_id IS NULL) THEN
1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);
1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);
1760: END IF;
1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);

Line 1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);

1758: l_rqmt_header_Rec.resource_id := nvl(l_header_rec.resource_id, FND_API.G_MISS_NUM);
1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);
1760: END IF;
1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';

Line 1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);

1759: l_rqmt_header_Rec.resource_type := nvl(l_header_rec.resource_type, FND_API.G_MISS_CHAR);
1760: END IF;
1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));

Line 1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;

1760: END IF;
1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);

Line 1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);

1761: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1762: l_rqmt_header_Rec.destination_organization_id := nvl(l_header_rec.dest_organization_id, FND_API.G_MISS_NUM);
1763: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);

Line 1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);

1764: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);

Line 1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);

1765: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);

Line 1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);

1766: l_rqmt_header_Rec.open_requirement := 'W';
1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);

Line 1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);

1767: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);

Line 1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);

1768: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);

Line 1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);

1769: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);

Line 1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);

1770: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);

Line 1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);

1771: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);
1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);

Line 1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);

1772: l_rqmt_header_rec.attribute4 := nvl(l_header_rec.attribute4, FND_API.G_MISS_CHAR);
1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);

Line 1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);

1773: l_rqmt_header_rec.attribute5 := nvl(l_header_rec.attribute5, FND_API.G_MISS_CHAR);
1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);

Line 1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);

1774: l_rqmt_header_rec.attribute6 := nvl(l_header_rec.attribute6, FND_API.G_MISS_CHAR);
1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);

Line 1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);

1775: l_rqmt_header_rec.attribute7 := nvl(l_header_rec.attribute7, FND_API.G_MISS_CHAR);
1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);

Line 1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);

1776: l_rqmt_header_rec.attribute8 := nvl(l_header_rec.attribute8, FND_API.G_MISS_CHAR);
1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
1784: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);

Line 1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);

1777: l_rqmt_header_rec.attribute9 := nvl(l_header_rec.attribute9, FND_API.G_MISS_CHAR);
1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
1784: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
1785:

Line 1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);

1778: l_rqmt_header_rec.attribute10 := nvl(l_header_rec.attribute10, FND_API.G_MISS_CHAR);
1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
1784: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
1785:
1786: -- check to see if requirements exist for a given task

Line 1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);

1779: l_rqmt_header_rec.attribute11 := nvl(l_header_rec.attribute11, FND_API.G_MISS_CHAR);
1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
1784: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
1785:
1786: -- check to see if requirements exist for a given task
1787: /*commenting for 11.5.10 since multiple rqmt headers can exist for a task

Line 1784: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);

1780: l_rqmt_header_rec.attribute12 := nvl(l_header_rec.attribute12, FND_API.G_MISS_CHAR);
1781: l_rqmt_header_rec.attribute13 := nvl(l_header_rec.attribute13, FND_API.G_MISS_CHAR);
1782: l_rqmt_header_rec.attribute14 := nvl(l_header_rec.attribute14, FND_API.G_MISS_CHAR);
1783: l_rqmt_header_rec.attribute15 := nvl(l_header_rec.attribute15, FND_API.G_MISS_CHAR);
1784: l_rqmt_header_rec.ship_to_contact_id := nvl(l_header_rec.ship_to_contact_id, FND_API.G_MISS_NUM);
1785:
1786: -- check to see if requirements exist for a given task
1787: /*commenting for 11.5.10 since multiple rqmt headers can exist for a task
1788: IF (l_header_rec.task_id IS NOT NULL) THEN

Line 1812: P_Commit => FND_API.G_FALSE,

1808: -- call private api for inserting into csp_Requirement_headers
1809: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
1810: P_Api_Version_Number => l_api_Version_number,
1811: P_Init_Msg_List => p_init_msg_list,
1812: P_Commit => FND_API.G_FALSE,
1813: p_validation_level => null,
1814: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
1815: X_REQUIREMENT_HEADER_ID => l_requirement_header_id,
1816: X_Return_Status => l_Return_status,

Line 1821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1817: X_Msg_Count => l_msg_count,
1818: X_Msg_Data => l_msg_data
1819: );
1820:
1821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822: fnd_msg_pub.count_and_get
1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data);
1825: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1825: x_return_status := FND_API.G_RET_STS_ERROR;

1821: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1822: fnd_msg_pub.count_and_get
1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data);
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: return;
1827: --RAISE FND_API.G_EXC_ERROR;
1828: END IF;
1829: l_header_rec.requirement_header_id := l_requirement_header_id;

Line 1827: --RAISE FND_API.G_EXC_ERROR;

1823: ( p_count => x_msg_count
1824: , p_data => x_msg_data);
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: return;
1827: --RAISE FND_API.G_EXC_ERROR;
1828: END IF;
1829: l_header_rec.requirement_header_id := l_requirement_header_id;
1830: WHEN OTHERS THEN
1831: NULL;

Line 1838: P_Commit => FND_API.G_FALSE,

1834: -- call private api for inserting into csp_Requirement_headers
1835: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
1836: P_Api_Version_Number => l_api_Version_number,
1837: P_Init_Msg_List => p_init_msg_list,
1838: P_Commit => FND_API.G_FALSE,
1839: p_validation_level => null,
1840: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
1841: X_REQUIREMENT_HEADER_ID => l_requirement_header_id,
1842: X_Return_Status => l_Return_status,

Line 1847: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1843: X_Msg_Count => l_msg_count,
1844: X_Msg_Data => l_msg_data
1845: );
1846:
1847: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;
1850: l_header_rec.requirement_header_id := l_requirement_header_id;
1851: -- END IF;

Line 1848: RAISE FND_API.G_EXC_ERROR;

1844: X_Msg_Data => l_msg_data
1845: );
1846:
1847: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1848: RAISE FND_API.G_EXC_ERROR;
1849: END IF;
1850: l_header_rec.requirement_header_id := l_requirement_header_id;
1851: -- END IF;
1852:

Line 1880: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);

1876: l_rqmt_header_Rec.requirement_header_id := l_header_rec.requirement_header_id;
1877: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
1878: l_rqmt_header_Rec.last_update_date := l_today;
1879: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
1880: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1881: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1882: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1883:
1884: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

Line 1881: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);

1877: l_rqmt_header_Rec.last_updated_by := nvl(l_user_id, -1);
1878: l_rqmt_header_Rec.last_update_date := l_today;
1879: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
1880: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1881: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1882: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1883:
1884: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
1885: P_Api_Version_Number => l_api_Version_number,

Line 1882: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);

1878: l_rqmt_header_Rec.last_update_date := l_today;
1879: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
1880: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1881: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1882: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1883:
1884: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
1885: P_Api_Version_Number => l_api_Version_number,
1886: P_Init_Msg_List => p_init_msg_list,

Line 1887: P_Commit => FND_API.G_FALSE,

1883:
1884: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
1885: P_Api_Version_Number => l_api_Version_number,
1886: P_Init_Msg_List => p_init_msg_list,
1887: P_Commit => FND_API.G_FALSE,
1888: p_validation_level => null,
1889: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
1890: X_Return_Status => l_Return_status,
1891: X_Msg_Count => l_msg_count,

Line 1895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1891: X_Msg_Count => l_msg_count,
1892: X_Msg_Data => l_msg_data
1893: );
1894:
1895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1896: RAISE FND_API.G_EXC_ERROR;
1897: END IF;
1898: END IF;
1899:

Line 1896: RAISE FND_API.G_EXC_ERROR;

1892: X_Msg_Data => l_msg_data
1893: );
1894:
1895: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1896: RAISE FND_API.G_EXC_ERROR;
1897: END IF;
1898: END IF;
1899:
1900: -- create rqmt line

Line 1939: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);

1935: l_rqmt_line_rec.ship_complete_flag := l_line_rec.ship_complete;
1936: l_rqmt_line_rec.likelihood := l_line_rec.likelihood;
1937: l_rqmt_line_rec.revision := l_line_rec.revision;
1938: l_rqmt_line_rec.ordered_quantity := l_line_Rec.quantity;
1939: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);

Line 1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);

1936: l_rqmt_line_rec.likelihood := l_line_rec.likelihood;
1937: l_rqmt_line_rec.revision := l_line_rec.revision;
1938: l_rqmt_line_rec.ordered_quantity := l_line_Rec.quantity;
1939: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);

Line 1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);

1937: l_rqmt_line_rec.revision := l_line_rec.revision;
1938: l_rqmt_line_rec.ordered_quantity := l_line_Rec.quantity;
1939: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);

Line 1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);

1938: l_rqmt_line_rec.ordered_quantity := l_line_Rec.quantity;
1939: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);

Line 1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);

1939: l_rqmt_line_rec.attribute_Category := nvl(l_line_rec.attribute_category, FND_API.G_MISS_CHAR);
1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);

Line 1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);

1940: l_rqmt_line_rec.attribute1 := nvl(l_line_rec.attribute1, FND_API.G_MISS_CHAR);
1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);

Line 1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);

1941: l_rqmt_line_rec.attribute2 := nvl(l_line_rec.attribute2, FND_API.G_MISS_CHAR);
1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);

Line 1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);

1942: l_rqmt_line_rec.attribute3 := nvl(l_line_rec.attribute3, FND_API.G_MISS_CHAR);
1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);

Line 1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);

1943: l_rqmt_line_rec.attribute4 := nvl(l_line_rec.attribute4, FND_API.G_MISS_CHAR);
1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);

Line 1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);

1944: l_rqmt_line_rec.attribute5 := nvl(l_line_rec.attribute5, FND_API.G_MISS_CHAR);
1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);

Line 1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);

1945: l_rqmt_line_rec.attribute6 := nvl(l_line_rec.attribute6, FND_API.G_MISS_CHAR);
1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);

Line 1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);

1946: l_rqmt_line_rec.attribute7 := nvl(l_line_rec.attribute7, FND_API.G_MISS_CHAR);
1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
1954: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);

Line 1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);

1947: l_rqmt_line_rec.attribute8 := nvl(l_line_rec.attribute8, FND_API.G_MISS_CHAR);
1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
1954: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
1955:

Line 1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);

1948: l_rqmt_line_rec.attribute9 := nvl(l_line_rec.attribute9, FND_API.G_MISS_CHAR);
1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
1954: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
1955:
1956: l_rqmt_line_tbl(I) := l_rqmt_line_rec;

Line 1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);

1949: l_rqmt_line_rec.attribute10 := nvl(l_line_rec.attribute10, FND_API.G_MISS_CHAR);
1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
1954: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
1955:
1956: l_rqmt_line_tbl(I) := l_rqmt_line_rec;
1957: END LOOP;

Line 1954: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);

1950: l_rqmt_line_rec.attribute11 := nvl(l_line_rec.attribute11, FND_API.G_MISS_CHAR);
1951: l_rqmt_line_rec.attribute12 := nvl(l_line_rec.attribute12, FND_API.G_MISS_CHAR);
1952: l_rqmt_line_rec.attribute13 := nvl(l_line_rec.attribute13, FND_API.G_MISS_CHAR);
1953: l_rqmt_line_rec.attribute14 := nvl(l_line_rec.attribute14, FND_API.G_MISS_CHAR);
1954: l_rqmt_line_rec.attribute15 := nvl(l_line_rec.attribute15, FND_API.G_MISS_CHAR);
1955:
1956: l_rqmt_line_tbl(I) := l_rqmt_line_rec;
1957: END LOOP;
1958:

Line 1962: P_Commit => FND_API.G_FALSE,

1958:
1959: CSP_Requirement_Lines_PVT.Create_requirement_lines(
1960: P_Api_Version_Number => l_api_version_number,
1961: P_Init_Msg_List => p_Init_Msg_List,
1962: P_Commit => FND_API.G_FALSE,
1963: p_validation_level => null,
1964: P_Requirement_Line_Tbl => l_rqmt_line_tbl,
1965: x_Requirement_Line_tbl => l_rqmt_line_tbl_out,
1966: X_Return_Status => l_return_status,

Line 1971: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1967: X_Msg_Count => l_msg_count,
1968: X_Msg_Data => l_msg_data
1969: );
1970:
1971: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1972: RAISE FND_API.G_EXC_ERROR;
1973: END IF;
1974:
1975: -- Return header rec and line table.

Line 1972: RAISE FND_API.G_EXC_ERROR;

1968: X_Msg_Data => l_msg_data
1969: );
1970:
1971: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1972: RAISE FND_API.G_EXC_ERROR;
1973: END IF;
1974:
1975: -- Return header rec and line table.
1976: px_header_rec := l_header_rec;

Line 1990: IF fnd_api.to_boolean(p_commit) THEN

1986: px_line_tbl(I).unit_of_measure := rqmt_line.uom_code;
1987: I := I + 1;
1988: END LOOP;
1989:
1990: IF fnd_api.to_boolean(p_commit) THEN
1991: commit work;
1992: END IF;
1993:
1994: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1994: x_return_status := FND_API.G_RET_STS_SUCCESS;

1990: IF fnd_api.to_boolean(p_commit) THEN
1991: commit work;
1992: END IF;
1993:
1994: x_return_status := FND_API.G_RET_STS_SUCCESS;
1995: EXCEPTION
1996: WHEN EXCP_USER_DEFINED THEN
1997: Rollback to save_rqmt_line_PUB;
1998: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1998: x_return_status := FND_API.G_RET_STS_ERROR;

1994: x_return_status := FND_API.G_RET_STS_SUCCESS;
1995: EXCEPTION
1996: WHEN EXCP_USER_DEFINED THEN
1997: Rollback to save_rqmt_line_PUB;
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: fnd_msg_pub.count_and_get
2000: ( p_count => x_msg_count
2001: , p_data => x_msg_data);
2002:

Line 2003: WHEN FND_API.G_EXC_ERROR THEN

1999: fnd_msg_pub.count_and_get
2000: ( p_count => x_msg_count
2001: , p_data => x_msg_data);
2002:
2003: WHEN FND_API.G_EXC_ERROR THEN
2004: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2005: P_API_NAME => L_API_NAME
2006: ,P_PKG_NAME => G_PKG_NAME
2007: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2009: ,X_MSG_COUNT => X_MSG_COUNT
2010: ,X_MSG_DATA => X_MSG_DATA
2011: ,X_RETURN_STATUS => X_RETURN_STATUS);
2012:
2013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2014: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2015: P_API_NAME => L_API_NAME
2016: ,P_PKG_NAME => G_PKG_NAME
2017: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2031: x_return_status := FND_API.G_RET_STS_ERROR;

2027: FND_MSG_PUB.ADD;
2028: fnd_msg_pub.count_and_get
2029: ( p_count => x_msg_count
2030: , p_data => x_msg_data);
2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032: END;
2033:
2034:
2035: PROCEDURE delete_rqmt_line(

Line 2037: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

2033:
2034:
2035: PROCEDURE delete_rqmt_line(
2036: p_api_version IN NUMBER
2037: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2038: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2039: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type
2040: ,x_return_status OUT NOCOPY VARCHAR2
2041: ,x_msg_count OUT NOCOPY NUMBER

Line 2038: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2034:
2035: PROCEDURE delete_rqmt_line(
2036: p_api_version IN NUMBER
2037: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2038: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2039: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type
2040: ,x_return_status OUT NOCOPY VARCHAR2
2041: ,x_msg_count OUT NOCOPY NUMBER
2042: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2049: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

2045: l_api_name CONSTANT VARCHAR2(30) := 'delete_rqmt_line';
2046: BEGIN
2047: SAVEPOINT delete_rqmt_line_PUB;
2048:
2049: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2050: -- initialize message list
2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:

Line 2055: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Standard call to check for call compatibility.
2055: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2056: p_api_version,
2057: l_api_name,
2058: G_PKG_NAME)
2059: THEN

Line 2060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2056: p_api_version,
2057: l_api_name,
2058: G_PKG_NAME)
2059: THEN
2060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2061: END IF;
2062:
2063: -- initialize return status
2064: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2064: x_return_status := FND_API.G_RET_STS_SUCCESS;

2060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2061: END IF;
2062:
2063: -- initialize return status
2064: x_return_status := FND_API.G_RET_STS_SUCCESS;
2065:
2066: IF (p_line_tbl.count > 0) THEN
2067: FOR I IN 1..p_line_Tbl.count LOOP
2068: DELETE FROM csp_Requirement_lines

Line 2073: IF fnd_api.to_boolean(p_commit) THEN

2069: WHERE requirement_line_id = p_line_tbl(I).requirement_line_id;
2070: END LOOP;
2071: END IF;
2072:
2073: IF fnd_api.to_boolean(p_commit) THEN
2074: commit work;
2075: END IF;
2076: x_return_status := FND_API.G_RET_STS_SUCCESS;
2077:

Line 2076: x_return_status := FND_API.G_RET_STS_SUCCESS;

2072:
2073: IF fnd_api.to_boolean(p_commit) THEN
2074: commit work;
2075: END IF;
2076: x_return_status := FND_API.G_RET_STS_SUCCESS;
2077:
2078: EXCEPTION
2079:
2080: WHEN FND_API.G_EXC_ERROR THEN

Line 2080: WHEN FND_API.G_EXC_ERROR THEN

2076: x_return_status := FND_API.G_RET_STS_SUCCESS;
2077:
2078: EXCEPTION
2079:
2080: WHEN FND_API.G_EXC_ERROR THEN
2081: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2082: P_API_NAME => L_API_NAME
2083: ,P_PKG_NAME => G_PKG_NAME
2084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2085: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2086: ,X_MSG_COUNT => X_MSG_COUNT
2087: ,X_MSG_DATA => X_MSG_DATA
2088: ,X_RETURN_STATUS => X_RETURN_STATUS);
2089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2090: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2091: P_API_NAME => L_API_NAME
2092: ,P_PKG_NAME => G_PKG_NAME
2093: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2107: x_return_status := FND_API.G_RET_STS_ERROR;

2103: FND_MSG_PUB.ADD;
2104: fnd_msg_pub.count_and_get
2105: ( p_count => x_msg_count
2106: , p_data => x_msg_data);
2107: x_return_status := FND_API.G_RET_STS_ERROR;
2108: END;
2109:
2110: PROCEDURE check_Availability(
2111: p_api_version IN NUMBER

Line 2112: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

2108: END;
2109:
2110: PROCEDURE check_Availability(
2111: p_api_version IN NUMBER
2112: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2114: ,p_header_id IN NUMBER
2115: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type
2116: ,x_avail_flag OUT NOCOPY VARCHAR2

Line 2113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2109:
2110: PROCEDURE check_Availability(
2111: p_api_version IN NUMBER
2112: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2114: ,p_header_id IN NUMBER
2115: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type
2116: ,x_avail_flag OUT NOCOPY VARCHAR2
2117: ,x_return_status OUT NOCOPY VARCHAR2

Line 2134: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2130: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
2131: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
2132: I NUMBER;
2133: J NUMBER;
2134: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2135: l_msg_count NUMBER;
2136: l_msg_data VARCHAR2(4000);
2137:
2138: CURSOR rqmt_line_cur IS

Line 2152: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

2148:
2149: BEGIN
2150: SAVEPOINT check_Availability_PUB;
2151:
2152: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2153: -- initialize message list
2154: FND_MSG_PUB.initialize;
2155: END IF;
2156:

Line 2158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2154: FND_MSG_PUB.initialize;
2155: END IF;
2156:
2157: -- Standard call to check for call compatibility.
2158: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2159: p_api_version,
2160: l_api_name,
2161: G_PKG_NAME)
2162: THEN

Line 2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2159: p_api_version,
2160: l_api_name,
2161: G_PKG_NAME)
2162: THEN
2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165:
2166: -- initialize return status
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2167: x_return_status := FND_API.G_RET_STS_SUCCESS;

2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165:
2166: -- initialize return status
2167: x_return_status := FND_API.G_RET_STS_SUCCESS;
2168:
2169: IF (p_header_id IS NOT NULL) THEN
2170: select count(*)
2171: into l_count

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

2232: p_Called_From => 'MOBILE',
2233: p_location_id => l_header_rec.ship_to_location_id
2234: );
2235:
2236: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2237: null;
2238: --RAISE FND_API.G_EXC_ERROR;
2239: END IF;
2240:

Line 2238: --RAISE FND_API.G_EXC_ERROR;

2234: );
2235:
2236: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2237: null;
2238: --RAISE FND_API.G_EXC_ERROR;
2239: END IF;
2240:
2241: J := 1;
2242: I := 1;

Line 2284: (l_line_Tbl(I).source_organization_id = FND_API.G_MISS_NUM)) THEN

2280: P_Secondary_Inventory => l_header_rec.dest_subinventory,
2281: x_source_org_id => l_line_Tbl(I).source_organization_id);
2282: */
2283: IF ((l_line_Tbl(I).source_organization_id IS NULL) OR
2284: (l_line_Tbl(I).source_organization_id = FND_API.G_MISS_NUM)) THEN
2285: -- no source organization defined, create requirement with error status
2286: x_avail_flag := 'N';
2287: END IF;
2288: END If;

Line 2296: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);

2292: l_rqmt_line_tbl(I).last_update_date := sysdate;
2293: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);
2294: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2295: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;
2296: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);
2297: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);
2298: l_rqmt_line_tbl(I).shipping_method_code := nvl(l_line_Tbl(I).shipping_method_code, FND_API.G_MISS_CHAR);
2299: l_rqmt_line_tbl(I).order_by_date := nvl(l_line_tbl(I).order_by_date, FND_API.G_MISS_DATE);
2300: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);

Line 2297: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);

2293: l_rqmt_line_tbl(I).last_update_login := nvl(FND_GLOBAL.login_id , -1);
2294: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2295: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;
2296: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);
2297: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);
2298: l_rqmt_line_tbl(I).shipping_method_code := nvl(l_line_Tbl(I).shipping_method_code, FND_API.G_MISS_CHAR);
2299: l_rqmt_line_tbl(I).order_by_date := nvl(l_line_tbl(I).order_by_date, FND_API.G_MISS_DATE);
2300: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);
2301: END LOOP;

Line 2298: l_rqmt_line_tbl(I).shipping_method_code := nvl(l_line_Tbl(I).shipping_method_code, FND_API.G_MISS_CHAR);

2294: l_rqmt_line_tbl(I).inventory_item_id := l_line_tbl(I).inventory_item_id;
2295: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;
2296: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);
2297: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);
2298: l_rqmt_line_tbl(I).shipping_method_code := nvl(l_line_Tbl(I).shipping_method_code, FND_API.G_MISS_CHAR);
2299: l_rqmt_line_tbl(I).order_by_date := nvl(l_line_tbl(I).order_by_date, FND_API.G_MISS_DATE);
2300: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);
2301: END LOOP;
2302:

Line 2299: l_rqmt_line_tbl(I).order_by_date := nvl(l_line_tbl(I).order_by_date, FND_API.G_MISS_DATE);

2295: l_rqmt_line_tbl(I).sourced_From := l_line_tbl(I).sourced_From;
2296: l_rqmt_line_tbl(I).source_organization_id := nvl(l_line_tbl(I).source_organization_id, FND_API.G_MISS_NUM);
2297: l_rqmt_line_tbl(I).arrival_Date := nvl(l_line_tbl(I).arrival_Date, FND_API.G_MISS_DATE);
2298: l_rqmt_line_tbl(I).shipping_method_code := nvl(l_line_Tbl(I).shipping_method_code, FND_API.G_MISS_CHAR);
2299: l_rqmt_line_tbl(I).order_by_date := nvl(l_line_tbl(I).order_by_date, FND_API.G_MISS_DATE);
2300: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);
2301: END LOOP;
2302:
2303: IF l_rqmt_line_tbl.COUNT > 0 THEN

Line 2307: P_Commit => FND_API.G_FALSE,

2303: IF l_rqmt_line_tbl.COUNT > 0 THEN
2304: CSP_Requirement_Lines_PVT.Update_requirement_lines(
2305: P_Api_Version_Number => l_api_version_number,
2306: P_Init_Msg_List => p_Init_Msg_List,
2307: P_Commit => FND_API.G_FALSE,
2308: p_validation_level => null,
2309: P_Requirement_Line_Tbl => l_rqmt_line_tbl,
2310: X_Return_Status => l_return_status,
2311: X_Msg_Count => l_msg_count,

Line 2315: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2311: X_Msg_Count => l_msg_count,
2312: X_Msg_Data => l_msg_data
2313: );
2314:
2315: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: END IF;
2319: END If;

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: X_Msg_Data => l_msg_data
2313: );
2314:
2315: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: END IF;
2319: END If;
2320: x_line_tbl := l_line_tbl;

Line 2324: IF fnd_api.to_boolean(p_commit) THEN

2320: x_line_tbl := l_line_tbl;
2321: x_avail_flag := nvl(x_avail_flag, 'Y');
2322: END IF;
2323:
2324: IF fnd_api.to_boolean(p_commit) THEN
2325: commit work;
2326: END IF;
2327: END IF;
2328: EXCEPTION

Line 2331: x_return_status := FND_API.G_RET_STS_ERROR;

2327: END IF;
2328: EXCEPTION
2329: WHEN EXCP_USER_DEFINED THEN
2330: Rollback to check_Availability_PUB;
2331: x_return_status := FND_API.G_RET_STS_ERROR;
2332: fnd_msg_pub.count_and_get
2333: ( p_count => x_msg_count
2334: , p_data => x_msg_data);
2335:

Line 2336: WHEN FND_API.G_EXC_ERROR THEN

2332: fnd_msg_pub.count_and_get
2333: ( p_count => x_msg_count
2334: , p_data => x_msg_data);
2335:
2336: WHEN FND_API.G_EXC_ERROR THEN
2337: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2338: P_API_NAME => L_API_NAME
2339: ,P_PKG_NAME => G_PKG_NAME
2340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2341: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2342: ,X_MSG_COUNT => X_MSG_COUNT
2343: ,X_MSG_DATA => X_MSG_DATA
2344: ,X_RETURN_STATUS => X_RETURN_STATUS);
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2347: P_API_NAME => L_API_NAME
2348: ,P_PKG_NAME => G_PKG_NAME
2349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2363: x_return_status := FND_API.G_RET_STS_ERROR;

2359: FND_MSG_PUB.ADD;
2360: fnd_msg_pub.count_and_get
2361: ( p_count => x_msg_count
2362: , p_data => x_msg_data);
2363: x_return_status := FND_API.G_RET_STS_ERROR;
2364: END;
2365:
2366: PROCEDURE create_order(
2367: p_api_version IN NUMBER

Line 2368: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

2364: END;
2365:
2366: PROCEDURE create_order(
2367: p_api_version IN NUMBER
2368: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2369: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2370: ,p_header_id IN NUMBER
2371: ,x_order_tbl OUT NOCOPY Order_Tbl_Type
2372: ,x_return_status OUT NOCOPY VARCHAR2

Line 2369: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2365:
2366: PROCEDURE create_order(
2367: p_api_version IN NUMBER
2368: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
2369: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2370: ,p_header_id IN NUMBER
2371: ,x_order_tbl OUT NOCOPY Order_Tbl_Type
2372: ,x_return_status OUT NOCOPY VARCHAR2
2373: ,x_msg_count OUT NOCOPY NUMBER

Line 2388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2385: EXCP_USER_DEFINED EXCEPTION;
2386: I NUMBER;
2387: J NUMBER;
2388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2389: l_msg_count NUMBER;
2390: l_msg_data VARCHAR2(2000);
2391: l_order_number NUMBER;
2392: l_open_requirement VARCHAr2(30);

Line 2424: IF fnd_api.to_boolean(P_Init_Msg_List) THEN

2420: end if;
2421:
2422: SAVEPOINT create_order_PUB;
2423:
2424: IF fnd_api.to_boolean(P_Init_Msg_List) THEN
2425: -- initialize message list
2426: FND_MSG_PUB.initialize;
2427: END IF;
2428:

Line 2430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2426: FND_MSG_PUB.initialize;
2427: END IF;
2428:
2429: -- Standard call to check for call compatibility.
2430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2431: p_api_version,
2432: l_api_name,
2433: G_PKG_NAME)
2434: THEN

Line 2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2431: p_api_version,
2432: l_api_name,
2433: G_PKG_NAME)
2434: THEN
2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: END IF;
2437:
2438: -- initialize return status
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2439: x_return_status := FND_API.G_RET_STS_SUCCESS;

2435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2436: END IF;
2437:
2438: -- initialize return status
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;
2440:
2441: -- user and login information
2442: SELECT Sysdate INTO l_today FROM dual;
2443: l_user_id := fnd_global.user_id;

Line 2569: ,p_commit => FND_API.G_FALSE

2565: end if;
2566: csp_parts_order.process_order(
2567: p_api_version => l_api_version_number
2568: ,p_Init_Msg_List => p_init_msg_list
2569: ,p_commit => FND_API.G_FALSE
2570: ,px_header_rec => l_header_rec
2571: ,px_line_table => l_oe_line_tbl
2572: ,x_return_status => l_return_status
2573: ,x_msg_count => l_msg_count

Line 2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2578: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2579: 'csp_parts_order.process_order return status = ' || l_return_status);
2580: end if;
2581:
2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2583: RAISE FND_API.G_EXC_ERROR;
2584: ELSE
2585: -- update open_requirement_flag on requirement header
2586: BEGIN

Line 2583: RAISE FND_API.G_EXC_ERROR;

2579: 'csp_parts_order.process_order return status = ' || l_return_status);
2580: end if;
2581:
2582: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2583: RAISE FND_API.G_EXC_ERROR;
2584: ELSE
2585: -- update open_requirement_flag on requirement header
2586: BEGIN
2587: l_open_requirement := 'S';

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

2658: ,x_msg_count => l_msg_count
2659: ,x_msg_data => l_msg_data
2660: );
2661:
2662: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSE
2665: IF (nvl(l_open_requirement, 'W') <> 'S') THEN
2666: update csp_requirement_headers

Line 2663: RAISE FND_API.G_EXC_ERROR;

2659: ,x_msg_data => l_msg_data
2660: );
2661:
2662: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSE
2665: IF (nvl(l_open_requirement, 'W') <> 'S') THEN
2666: update csp_requirement_headers
2667: set open_requirement = 'S'

Line 2698: x_return_status := FND_API.G_RET_STS_SUCCESS;

2694: END IF;
2695: END IF;
2696: END IF;
2697:
2698: x_return_status := FND_API.G_RET_STS_SUCCESS;
2699: IF fnd_api.to_boolean(p_commit) THEN
2700: commit work;
2701: END IF;
2702: END If;

Line 2699: IF fnd_api.to_boolean(p_commit) THEN

2695: END IF;
2696: END IF;
2697:
2698: x_return_status := FND_API.G_RET_STS_SUCCESS;
2699: IF fnd_api.to_boolean(p_commit) THEN
2700: commit work;
2701: END IF;
2702: END If;
2703: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2712: x_return_status := FND_API.G_RET_STS_ERROR;

2708: end if;
2709: EXCEPTION
2710: WHEN EXCP_USER_DEFINED THEN
2711: Rollback to create_order_PUB;
2712: x_return_status := FND_API.G_RET_STS_ERROR;
2713: fnd_msg_pub.count_and_get
2714: ( p_count => x_msg_count
2715: , p_data => x_msg_data);
2716:

Line 2717: WHEN FND_API.G_EXC_ERROR THEN

2713: fnd_msg_pub.count_and_get
2714: ( p_count => x_msg_count
2715: , p_data => x_msg_data);
2716:
2717: WHEN FND_API.G_EXC_ERROR THEN
2718: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2719: P_API_NAME => L_API_NAME
2720: ,P_PKG_NAME => G_PKG_NAME
2721: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2722: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2723: ,X_MSG_COUNT => X_MSG_COUNT
2724: ,X_MSG_DATA => X_MSG_DATA
2725: ,X_RETURN_STATUS => X_RETURN_STATUS);
2726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2727: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2728: P_API_NAME => L_API_NAME
2729: ,P_PKG_NAME => G_PKG_NAME
2730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2744: x_return_status := FND_API.G_RET_STS_ERROR;

2740: FND_MSG_PUB.ADD;
2741: fnd_msg_pub.count_and_get
2742: ( p_count => x_msg_count
2743: , p_data => x_msg_data);
2744: x_return_status := FND_API.G_RET_STS_ERROR;
2745: END;
2746:
2747: PROCEDURE TASK_ASSIGNMENT_POST_UPDATE(x_return_status out nocopy varchar2)IS
2748: l_task_assignment_id NUMBER;

Line 2919: x_return_status := FND_API.G_RET_STS_SUCCESS;

2915: || ', l_organization_id = ' || l_organization_id
2916: || ', l_subinventory_code = ' || l_subinventory_code);
2917: end if;
2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

Line 3081: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3077: AND subinventory_code = l_dest_subinv;
3078:
3079: if l_res_same_org > 0 then
3080: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_source_id, x_return_status, x_msg_data, x_msg_count);
3081: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3082: rollback to csp_correct_req_record;
3083: FND_MESSAGE.SET_NAME('CSP', 'CSP_MAN_NOT_CANCEL_RESERV');
3084: FND_MESSAGE.SET_TOKEN('REQ_NUM', l_rqmt_header_id, TRUE);
3085: FND_MSG_PUB.ADD;

Line 3121: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3117: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3118: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3119: end if;
3120:
3121: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3122: -- now try to find the part in warehouse
3123: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3124: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3125: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',

Line 3146: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3143: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3144: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3145: end if;
3146: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3147: rollback to csp_correct_req_record;
3148: raise EXCP_USER_DEFINED;
3149: else
3150: return; -- early exit

Line 3199: x_return_status := FND_API.G_RET_STS_ERROR;

3195:
3196: -- check if we need to source the item and schedule dates are already in past
3197: -- then stop reassignment
3198: if l_booking_start_date is null or l_booking_start_date <= sysdate then
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DATE_PST_ASSGN');
3201: FND_MSG_PUB.ADD;
3202: fnd_msg_pub.count_and_get
3203: ( p_count => x_msg_count

Line 3231: x_return_status := FND_API.G_RET_STS_ERROR;

3227: 'l_partial_line = ' || l_partial_line);
3228: end if;
3229:
3230: if l_partial_line > 0 then
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3233: FND_MSG_PUB.ADD;
3234: fnd_msg_pub.count_and_get
3235: ( p_count => x_msg_count

Line 3289: x_return_status := FND_API.G_RET_STS_ERROR;

3285: and dio.source_id = oola.line_id
3286: and oola.header_id = ooha.header_id
3287: AND rownum = 1;
3288:
3289: x_return_status := FND_API.G_RET_STS_ERROR;
3290: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3291: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3292: FND_MSG_PUB.ADD;
3293: fnd_msg_pub.count_and_get

Line 3364: x_return_status := FND_API.G_RET_STS_ERROR;

3360: 'l_fl_rcvd_multi_source = ' || l_fl_rcvd_multi_source);
3361: end if;
3362:
3363: if l_fl_rcvd_multi_source > 0 then
3364: x_return_status := FND_API.G_RET_STS_ERROR;
3365: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3366: FND_MSG_PUB.ADD;
3367: fnd_msg_pub.count_and_get
3368: ( p_count => x_msg_count

Line 3416: x_return_status := FND_API.G_RET_STS_ERROR;

3412: 'l_oth_req_line = ' || l_oth_req_line);
3413: end if;
3414:
3415: if l_oth_req_line > 0 then
3416: x_return_status := FND_API.G_RET_STS_ERROR;
3417: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3418: FND_MSG_PUB.ADD;
3419: fnd_msg_pub.count_and_get
3420: ( p_count => x_msg_count

Line 3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3486: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3488: 'after calling move_parts_on_reassign...x_return_status=' || x_return_status);
3489: end if;
3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3493: FND_MSG_PUB.ADD;
3494: fnd_msg_pub.count_and_get

Line 3491: x_return_status := FND_API.G_RET_STS_ERROR;

3487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3488: 'after calling move_parts_on_reassign...x_return_status=' || x_return_status);
3489: end if;
3490: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3491: x_return_status := FND_API.G_RET_STS_ERROR;
3492: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3493: FND_MSG_PUB.ADD;
3494: fnd_msg_pub.count_and_get
3495: ( p_count => x_msg_count

Line 3555: x_return_status := FND_API.G_RET_STS_ERROR;

3551: AND csp_pick_utils.get_order_status(oola.line_id,oola.flow_status_code) IN ('SHIPPED', 'EXPECTED')
3552: AND oola.header_id = ooha.header_id
3553: AND rownum = 1;
3554:
3555: x_return_status := FND_API.G_RET_STS_ERROR;
3556: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_IO_CAN');
3557: FND_MESSAGE.SET_TOKEN('ORDER_NUMBER',l_order_number, FALSE);
3558: FND_MSG_PUB.ADD;
3559: fnd_msg_pub.count_and_get

Line 3590: x_return_status := FND_API.G_RET_STS_ERROR;

3586: 'l_ship_multi_src = ' || l_ship_multi_src);
3587: end if;
3588:
3589: if l_ship_multi_src > 0 then
3590: x_return_status := FND_API.G_RET_STS_ERROR;
3591: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3592: FND_MSG_PUB.ADD;
3593: fnd_msg_pub.count_and_get
3594: ( p_count => x_msg_count

Line 3633: x_return_status := FND_API.G_RET_STS_ERROR;

3629: 'l_oth_req_line = ' || l_oth_req_line);
3630: end if;
3631:
3632: if l_oth_req_line > 0 then
3633: x_return_status := FND_API.G_RET_STS_ERROR;
3634: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3635: FND_MSG_PUB.ADD;
3636: fnd_msg_pub.count_and_get
3637: ( p_count => x_msg_count

Line 3707: P_Init_Msg_List => FND_API.G_FALSE,

3703: 'before calling Update_requirement_headers...');
3704: end if;
3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3706: P_Api_Version_Number => 1.0,
3707: P_Init_Msg_List => FND_API.G_FALSE,
3708: P_Commit => FND_API.G_FALSE,
3709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3710: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
3711: X_Return_Status => x_return_status,

Line 3708: P_Commit => FND_API.G_FALSE,

3704: end if;
3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3706: P_Api_Version_Number => 1.0,
3707: P_Init_Msg_List => FND_API.G_FALSE,
3708: P_Commit => FND_API.G_FALSE,
3709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3710: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
3711: X_Return_Status => x_return_status,
3712: X_Msg_Count => x_msg_count,

Line 3709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3706: P_Api_Version_Number => 1.0,
3707: P_Init_Msg_List => FND_API.G_FALSE,
3708: P_Commit => FND_API.G_FALSE,
3709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3710: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
3711: X_Return_Status => x_return_status,
3712: X_Msg_Count => x_msg_count,
3713: x_msg_data => x_msg_data

Line 3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3716: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3717: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3718: end if;
3719:
3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3721: x_return_status := FND_API.G_RET_STS_ERROR;
3722: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3723: FND_MSG_PUB.ADD;
3724: fnd_msg_pub.count_and_get

Line 3721: x_return_status := FND_API.G_RET_STS_ERROR;

3717: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3718: end if;
3719:
3720: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3721: x_return_status := FND_API.G_RET_STS_ERROR;
3722: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3723: FND_MSG_PUB.ADD;
3724: fnd_msg_pub.count_and_get
3725: ( p_count => x_msg_count

Line 3731: x_return_status := FND_API.G_RET_STS_ERROR;

3727: return;
3728: end if;
3729: end loop;
3730: else
3731: x_return_status := FND_API.G_RET_STS_ERROR;
3732: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3733: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3734: FND_MSG_PUB.ADD;
3735: fnd_msg_pub.count_and_get

Line 3763: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

3759: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3760: 'after making call to CLEAN_REQUIREMENT... x_return_status = ' || x_return_status);
3761: end if;
3762:
3763: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3764: -- we need to source the part for the new tech
3765: l_sch_option.resource_id := l_resource_id;
3766: l_sch_option.resource_type := l_resource_type_code;
3767: l_sch_option.start_time := l_booking_start_date;

Line 3792: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3788: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3789: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3790: end if;
3791:
3792: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3793: -- now try to find the part in warehouse
3794: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3795: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3796: 'before calling CSP_SCH_INT_PVT.CHOOSE_OPTION...');

Line 3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3811: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3813: 'after calling CSP_SCH_INT_PVT.CHOOSE_OPTION...x_return_status=' || x_return_status);
3814: end if;
3815: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3816: FND_MSG_PUB.initialize;
3817: l_resource_name := csp_pick_utils.get_object_name(l_resource_type_code, l_resource_id);
3818: FND_MESSAGE.SET_NAME('CSP', 'CSP_TSK_ASSGN_NO_SRC');
3819: FND_MESSAGE.SET_TOKEN('RESOURCE_NAME',l_resource_name, FALSE);

Line 3857: P_Init_Msg_List => FND_API.G_FALSE,

3853: 'before calling Update_requirement_headers...');
3854: end if;
3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3856: P_Api_Version_Number => 1.0,
3857: P_Init_Msg_List => FND_API.G_FALSE,
3858: P_Commit => FND_API.G_FALSE,
3859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3860: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
3861: X_Return_Status => x_return_status,

Line 3858: P_Commit => FND_API.G_FALSE,

3854: end if;
3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3856: P_Api_Version_Number => 1.0,
3857: P_Init_Msg_List => FND_API.G_FALSE,
3858: P_Commit => FND_API.G_FALSE,
3859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3860: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
3861: X_Return_Status => x_return_status,
3862: X_Msg_Count => x_msg_count,

Line 3859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3856: P_Api_Version_Number => 1.0,
3857: P_Init_Msg_List => FND_API.G_FALSE,
3858: P_Commit => FND_API.G_FALSE,
3859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3860: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
3861: X_Return_Status => x_return_status,
3862: X_Msg_Count => x_msg_count,
3863: x_msg_data => x_msg_data

Line 3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3866: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3867: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3868: end if;
3869:
3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3871: x_return_status := FND_API.G_RET_STS_ERROR;
3872: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3873: FND_MSG_PUB.ADD;
3874: fnd_msg_pub.count_and_get

Line 3871: x_return_status := FND_API.G_RET_STS_ERROR;

3867: 'after calling Update_requirement_headers...x_return_status=' || x_return_status);
3868: end if;
3869:
3870: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3871: x_return_status := FND_API.G_RET_STS_ERROR;
3872: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3873: FND_MSG_PUB.ADD;
3874: fnd_msg_pub.count_and_get
3875: ( p_count => x_msg_count

Line 3881: x_return_status := FND_API.G_RET_STS_ERROR;

3877: return;
3878: end if;
3879: end loop;
3880: else
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: FND_MESSAGE.SET_NAME('CSP', 'CSP_RASG_IO_UPD_OU_ERR');
3883: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_dest_org_name, TRUE);
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get

Line 3892: x_return_status := FND_API.G_RET_STS_ERROR;

3888: return;
3889: end if;
3890: return;
3891: else
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
3894: FND_MSG_PUB.ADD;
3895: fnd_msg_pub.count_and_get
3896: ( p_count => x_msg_count

Line 3957: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

3953: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
3954: 'after calling TASK_ASSIGNMENT_POST_INSERT.... x_return_status = ' || x_return_status);
3955: end if;
3956:
3957: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
3958: return;
3959: end if;
3960:
3961: end if;

Line 4026: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

4022: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE',
4023: 'x_return_status = ' || x_return_status);
4024: end if;
4025:
4026: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4027: rollback to csp_book_order;
4028:
4029: select order_number into l_oe_order_num
4030: from oe_order_headers_all where header_id = l_oe_header_id;

Line 4085: x_return_status := FND_API.G_RET_STS_SUCCESS;

4081: if x_return_status = 'C' then
4082: -- bug # 16028705
4083: if(nvl(CSF_TASKS_PUB.g_reschedule, 'N') = 'Y') then
4084: -- ignore it
4085: x_return_status := FND_API.G_RET_STS_SUCCESS;
4086: else
4087: x_return_status := 'E';
4088: end if;
4089: end if;

Line 4114: x_return_status := FND_API.G_RET_STS_SUCCESS;

4110: l_task_assignment_id NUMBER;
4111: l_assignee_role VARCHAR2(10);
4112:
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4117:
4118: if l_assignee_role = 'ASSIGNEE' then

Line 4260: x_return_status := FND_API.G_RET_STS_SUCCESS;

4256: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4257: 'Begin');
4258: end if;
4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

Line 4417: ,p_Init_Msg_List => FND_API.G_FALSE

4413: end if;
4414:
4415: csp_ship_to_address_pvt.cust_inv_loc_link
4416: (p_api_version => 1.0
4417: ,p_Init_Msg_List => FND_API.G_FALSE
4418: ,p_commit => FND_API.G_FALSE
4419: ,px_location_id => l_ship_hz_loc_id
4420: ,p_party_site_id => l_party_site_id
4421: ,p_cust_account_id => l_cust_act_id

Line 4418: ,p_commit => FND_API.G_FALSE

4414:
4415: csp_ship_to_address_pvt.cust_inv_loc_link
4416: (p_api_version => 1.0
4417: ,p_Init_Msg_List => FND_API.G_FALSE
4418: ,p_commit => FND_API.G_FALSE
4419: ,px_location_id => l_ship_hz_loc_id
4420: ,p_party_site_id => l_party_site_id
4421: ,p_cust_account_id => l_cust_act_id
4422: ,p_customer_id => l_cust_id

Line 4462: if nvl(x_return_status, 'S') = FND_API.G_RET_STS_SUCCESS then

4458: || ', x_msg_data = ' || x_msg_data
4459: || ', l_ship_hz_loc_id = ' || l_ship_hz_loc_id);
4460: end if;
4461:
4462: if nvl(x_return_status, 'S') = FND_API.G_RET_STS_SUCCESS then
4463: l_ship_to_location_id := l_ship_hz_loc_id;
4464: x_return_status := 'S';
4465: end if;
4466:

Line 4526: x_return_status := FND_API.G_RET_STS_SUCCESS;

4522: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4523: 'begin ...');
4524: end if;
4525:
4526: x_return_status := FND_API.G_RET_STS_SUCCESS;
4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 4565: x_return_status := FND_API.G_RET_STS_ERROR;

4561: 'l_dtl_count=' || l_dtl_count);
4562: end if;
4563:
4564: if l_dtl_count > 0 then
4565: x_return_status := FND_API.G_RET_STS_ERROR;
4566: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
4567: FND_MSG_PUB.ADD;
4568: fnd_msg_pub.count_and_get
4569: ( p_count => x_msg_count

Line 4617: p_init_msg_list => fnd_api.g_false,

4613: x_shift_end_datetime := l_start_date;
4614:
4615: csf_resource_pub.get_resource_shifts(
4616: p_api_version => 1.0,
4617: p_init_msg_list => fnd_api.g_false,
4618: x_return_status => x_return_status,
4619: x_msg_count => x_msg_count,
4620: x_msg_data => x_msg_data,
4621: p_resource_id => p_resource_id,