eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_REQUIREMENT_HEADERS_PUB dependencies on FND_API

Line 49: If(p_rqh_rec.task_id is NOT NULL and p_rqh_rec.task_id <> FND_API.G_MISS_NUM)

45: l_task_id Number;
46: EXCP_USER_DEFINED EXCEPTION;
47: BEGIN
48:
49: If(p_rqh_rec.task_id is NOT NULL and p_rqh_rec.task_id <> FND_API.G_MISS_NUM)
50: THEN
51: x_pvt_rqh_rec.task_id := p_rqh_rec.task_id;
52: ELSIF(p_rqh_rec.task_number is NOT NULL and p_rqh_rec.task_number <> FND_API.G_MISS_CHAR)
53: THEN

Line 52: ELSIF(p_rqh_rec.task_number is NOT NULL and p_rqh_rec.task_number <> FND_API.G_MISS_CHAR)

48:
49: If(p_rqh_rec.task_id is NOT NULL and p_rqh_rec.task_id <> FND_API.G_MISS_NUM)
50: THEN
51: x_pvt_rqh_rec.task_id := p_rqh_rec.task_id;
52: ELSIF(p_rqh_rec.task_number is NOT NULL and p_rqh_rec.task_number <> FND_API.G_MISS_CHAR)
53: THEN
54: OPEN C_Get_Task_Id(P_RQH_Rec.task_number);
55: FETCH C_Get_Task_Id INTO l_task_id;
56:

Line 115: raise FND_API.G_EXC_ERROR;

111:
112: -- If there is an error in conversion precessing, raise an error.
113: IF l_any_errors
114: THEN
115: raise FND_API.G_EXC_ERROR;
116: END IF;
117:
118: END Convert_RQH_Values_To_Ids;
119:

Line 125: AND l_pvt_RQH_rec.address_type <> FND_API.G_MISS_CHAR

121: l_count NUMBER;
122: EXCP_USER_DEFINED EXCEPTION;
123: BEGIN
124: IF (l_pvt_RQH_rec.address_type IS NOT NULL
125: AND l_pvt_RQH_rec.address_type <> FND_API.G_MISS_CHAR
126: AND l_pvt_RQH_rec.address_type NOT IN ('R', 'T', 'C', 'S')) THEN
127: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_ADDRESS_TYPE');
128: FND_MSG_PUB.ADD;
129: RAISE EXCP_USER_DEFINED;

Line 132: AND l_pvt_RQH_rec.ship_to_location_id <> FND_API.G_MISS_NUM) THEN

128: FND_MSG_PUB.ADD;
129: RAISE EXCP_USER_DEFINED;
130: END IF;
131: IF (l_pvt_RQH_Rec.ship_to_location_id IS NOT NULL
132: AND l_pvt_RQH_rec.ship_to_location_id <> FND_API.G_MISS_NUM) THEN
133: BEGIN
134: SELECT count(location_id)
135: INTO l_count
136: FROM hr_locations

Line 149: AND l_pvt_RQH_rec.task_id <> FND_API.G_MISS_NUM) THEN

145: null;
146: END;
147: END IF;
148: IF (l_pvt_RQH_Rec.task_id IS NOT NULL
149: AND l_pvt_RQH_rec.task_id <> FND_API.G_MISS_NUM) THEN
150: BEGIN
151: SELECT count(task_id)
152: INTO l_count
153: FROM jtf_Tasks_b

Line 167: AND l_pvt_RQH_rec.task_assignment_id <> FND_API.G_MISS_NUM) THEN

163: null;
164: END;
165: END IF;
166: IF (l_pvt_RQH_Rec.task_assignment_id IS NOT NULL
167: AND l_pvt_RQH_rec.task_assignment_id <> FND_API.G_MISS_NUM) THEN
168: BEGIN
169: SELECT count(task_assignment_id)
170: INTO l_count
171: FROM jtf_Task_assignments

Line 185: AND l_pvt_RQH_rec.resource_type <> FND_API.G_MISS_CHAR) THEN

181: null;
182: END;
183: END IF;
184: IF (l_pvt_RQH_Rec.resource_type IS NOT NULL
185: AND l_pvt_RQH_rec.resource_type <> FND_API.G_MISS_CHAR) THEN
186: BEGIN
187: SELECT count(jov.object_code)
188: INTO l_count
189: FROM jtf_objects_vl jov,

Line 207: AND l_pvt_RQH_rec.resource_id <> FND_API.G_MISS_NUM) THEN

203: null;
204: END;
205: END IF;
206: IF (l_pvt_RQH_Rec.resource_id IS NOT NULL
207: AND l_pvt_RQH_rec.resource_id <> FND_API.G_MISS_NUM) THEN
208: BEGIN
209: SELECT count(resource_id)
210: INTO l_count
211: FROM jtf_rs_resource_extns

Line 227: AND l_pvt_RQH_rec.destination_organization_id <> FND_API.G_MISS_NUM) THEN

223: null;
224: END;
225: END IF;
226: IF (l_pvt_RQH_Rec.destination_organization_id IS NOT NULL
227: AND l_pvt_RQH_rec.destination_organization_id <> FND_API.G_MISS_NUM) THEN
228: BEGIN
229: SELECT count(organization_id)
230: INTO l_count
231: FROM mtl_parameters

Line 245: AND l_pvt_RQH_rec.destination_subinventory <> FND_API.G_MISS_CHAR) THEN

241: null;
242: END;
243: END IF;
244: IF (l_pvt_RQH_Rec.destination_subinventory IS NOT NULL
245: AND l_pvt_RQH_rec.destination_subinventory <> FND_API.G_MISS_CHAR) THEN
246: BEGIN
247: SELECT count(secondary_inventory_name)
248: INTO l_count
249: FROM mtl_secondary_inventories

Line 265: AND l_pvt_RQH_rec.need_by_date <> FND_API.G_MISS_DATE

261: null;
262: END;
263: END IF;
264: IF (l_pvt_RQH_Rec.need_by_date IS NOT NULL
265: AND l_pvt_RQH_rec.need_by_date <> FND_API.G_MISS_DATE
266: AND trunc(l_pvt_RQH_rec.need_By_date) < trunc(sysdate)) THEN
267: FND_MESSAGE.SET_NAME ('CSP', 'CSP_INVALID_NEED_BY_DATE');
268: FND_MSG_PUB.ADD;
269: RAISE EXCP_USER_DEFINED;

Line 275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

271: END;
272:
273: PROCEDURE Create_requirement_headers(
274: P_Api_Version_Number IN NUMBER,
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
277: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
278: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
279: X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,

Line 276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

272:
273: PROCEDURE Create_requirement_headers(
274: P_Api_Version_Number IN NUMBER,
275: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
276: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
277: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
278: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
279: X_REQUIREMENT_HEADER_ID OUT NOCOPY NUMBER,
280: X_Return_Status OUT NOCOPY VARCHAR2,

Line 295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

291: -- Standard Start of API savepoint
292: SAVEPOINT CREATE_Requirement_Headers_PUB;
293:
294: -- Standard call to check for call compatibility.
295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
299: THEN

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

296: p_api_version_number,
297: l_api_name,
298: G_PKG_NAME)
299: THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 305: IF FND_API.to_Boolean( p_init_msg_list )

301: END IF;
302:
303:
304: -- Initialize message list if p_init_msg_list is set to TRUE.
305: IF FND_API.to_Boolean( p_init_msg_list )
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
313:
314:
315: -- Initialize API return status to SUCCESS
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: --
319: -- API body
320: --

Line 338: P_Init_Msg_List => FND_API.G_FALSE,

334: -- Calling Private package: Create_Packlist_Headers
335: -- Hint: Primary key needs to be returned
336: CSP_requirement_headers_PVT.Create_requirement_headers(
337: P_Api_Version_Number => 1.0,
338: P_Init_Msg_List => FND_API.G_FALSE,
339: P_Commit => FND_API.G_FALSE,
340: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
341: P_REQUIREMENT_HEADER_Rec => l_pvt_RQH_Rec ,
342: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 339: P_Commit => FND_API.G_FALSE,

335: -- Hint: Primary key needs to be returned
336: CSP_requirement_headers_PVT.Create_requirement_headers(
337: P_Api_Version_Number => 1.0,
338: P_Init_Msg_List => FND_API.G_FALSE,
339: P_Commit => FND_API.G_FALSE,
340: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
341: P_REQUIREMENT_HEADER_Rec => l_pvt_RQH_Rec ,
342: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
343: X_REQUIREMENT_HEADER_ID => l_REQUIREMENT_HEADER_ID,

Line 340: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

336: CSP_requirement_headers_PVT.Create_requirement_headers(
337: P_Api_Version_Number => 1.0,
338: P_Init_Msg_List => FND_API.G_FALSE,
339: P_Commit => FND_API.G_FALSE,
340: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
341: P_REQUIREMENT_HEADER_Rec => l_pvt_RQH_Rec ,
342: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
343: X_REQUIREMENT_HEADER_ID => l_REQUIREMENT_HEADER_ID,
344: X_Return_Status => x_return_status,

Line 349: IF x_return_status = FND_API.G_RET_STS_ERROR then

345: X_Msg_Count => x_msg_count,
346: X_Msg_Data => x_msg_data);
347:
348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;

Line 350: raise FND_API.G_EXC_ERROR;

346: X_Msg_Data => x_msg_data);
347:
348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:

Line 351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

347:
348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: x_requirement_header_id := l_requirement_header_id;

Line 352: raise FND_API.G_EXC_UNEXPECTED_ERROR;

348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: x_requirement_header_id := l_requirement_header_id;
356: --

Line 360: IF FND_API.to_Boolean( p_commit )

356: --
357: -- End of API body.
358: --
359: -- Standard check for p_commit
360: IF FND_API.to_Boolean( p_commit )
361: THEN
362: COMMIT WORK;
363: END IF;
364:

Line 377: WHEN FND_API.G_EXC_ERROR THEN

373: p_data => x_msg_data
374: );
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

383: ,X_MSG_COUNT => X_MSG_COUNT
384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 412: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

408:
409: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
410: PROCEDURE Update_requirement_headers(
411: P_Api_Version_Number IN NUMBER,
412: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
413: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
414: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
415: X_Return_Status OUT NOCOPY VARCHAR2,
416: X_Msg_Count OUT NOCOPY NUMBER,

Line 413: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

409: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
410: PROCEDURE Update_requirement_headers(
411: P_Api_Version_Number IN NUMBER,
412: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
413: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
414: P_RQH_Rec IN RQH_Rec_Type := G_MISS_RQH_REC,
415: X_Return_Status OUT NOCOPY VARCHAR2,
416: X_Msg_Count OUT NOCOPY NUMBER,
417: X_Msg_Data OUT NOCOPY VARCHAR2

Line 429: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

425: -- Standard Start of API savepoint
426: SAVEPOINT UPDATE_Packlist_Headers_PUB;
427:
428: -- Standard call to check for call compatibility.
429: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
430: p_api_version_number,
431: l_api_name,
432: G_PKG_NAME)
433: THEN

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430: p_api_version_number,
431: l_api_name,
432: G_PKG_NAME)
433: THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:
437:
438: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 439: IF FND_API.to_Boolean( p_init_msg_list )

435: END IF;
436:
437:
438: -- Initialize message list if p_init_msg_list is set to TRUE.
439: IF FND_API.to_Boolean( p_init_msg_list )
440: THEN
441: FND_MSG_PUB.initialize;
442: END IF;
443:

Line 445: x_return_status := FND_API.G_RET_STS_SUCCESS;

441: FND_MSG_PUB.initialize;
442: END IF;
443:
444: -- Initialize API return status to SUCCESS
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446:
447: --
448: -- API body
449: --

Line 462: P_Init_Msg_List => FND_API.G_FALSE,

458: Validate_Requirement_Header(l_pvt_RQH_rec);
459:
460: CSP_requirement_headers_PVT.Update_requirement_headers(
461: P_Api_Version_Number => 1.0,
462: P_Init_Msg_List => FND_API.G_FALSE,
463: P_Commit => p_commit,
464: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
465: P_Requirement_Header_Rec => l_pvt_RQH_Rec ,
466: X_Return_Status => x_return_status,

Line 464: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

460: CSP_requirement_headers_PVT.Update_requirement_headers(
461: P_Api_Version_Number => 1.0,
462: P_Init_Msg_List => FND_API.G_FALSE,
463: P_Commit => p_commit,
464: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
465: P_Requirement_Header_Rec => l_pvt_RQH_Rec ,
466: X_Return_Status => x_return_status,
467: X_Msg_Count => x_msg_count,
468: X_Msg_Data => x_msg_data);

Line 473: IF x_return_status = FND_API.G_RET_STS_ERROR then

469:
470:
471:
472: -- Check return status from the above procedure call
473: IF x_return_status = FND_API.G_RET_STS_ERROR then
474: raise FND_API.G_EXC_ERROR;
475: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
476: raise FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;

Line 474: raise FND_API.G_EXC_ERROR;

470:
471:
472: -- Check return status from the above procedure call
473: IF x_return_status = FND_API.G_RET_STS_ERROR then
474: raise FND_API.G_EXC_ERROR;
475: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
476: raise FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:

Line 475: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

471:
472: -- Check return status from the above procedure call
473: IF x_return_status = FND_API.G_RET_STS_ERROR then
474: raise FND_API.G_EXC_ERROR;
475: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
476: raise FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: --

Line 476: raise FND_API.G_EXC_UNEXPECTED_ERROR;

472: -- Check return status from the above procedure call
473: IF x_return_status = FND_API.G_RET_STS_ERROR then
474: raise FND_API.G_EXC_ERROR;
475: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
476: raise FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: --
480: -- End of API body

Line 484: IF FND_API.to_Boolean( p_commit )

480: -- End of API body
481: --
482:
483: -- Standard check for p_commit
484: IF FND_API.to_Boolean( p_commit )
485: THEN
486: COMMIT WORK;
487: END IF;
488:

Line 501: WHEN FND_API.G_EXC_ERROR THEN

497: p_data => x_msg_data
498: );
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
503: P_API_NAME => L_API_NAME
504: ,P_PKG_NAME => G_PKG_NAME
505: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

507: ,X_MSG_COUNT => X_MSG_COUNT
508: ,X_MSG_DATA => X_MSG_DATA
509: ,X_RETURN_STATUS => X_RETURN_STATUS);
510:
511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
512: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
513: P_API_NAME => L_API_NAME
514: ,P_PKG_NAME => G_PKG_NAME
515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

533: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
534: -- The Master delete procedure may not be needed depends on different business requirements.
535: PROCEDURE Delete_requirement_headers(
536: P_Api_Version_Number IN NUMBER,
537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
538: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
539: P_RQH_Rec IN RQH_Rec_Type,
540: X_Return_Status OUT NOCOPY VARCHAR2,
541: X_Msg_Count OUT NOCOPY NUMBER,

Line 538: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

534: -- The Master delete procedure may not be needed depends on different business requirements.
535: PROCEDURE Delete_requirement_headers(
536: P_Api_Version_Number IN NUMBER,
537: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
538: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
539: P_RQH_Rec IN RQH_Rec_Type,
540: X_Return_Status OUT NOCOPY VARCHAR2,
541: X_Msg_Count OUT NOCOPY NUMBER,
542: X_Msg_Data OUT NOCOPY VARCHAR2

Line 602: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

598: -- Standard Start of API savepoint
599: SAVEPOINT DELETE_Requirement_Headers_PUB;
600:
601: -- Standard call to check for call compatibility.
602: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
603: p_api_version_number,
604: l_api_name,
605: G_PKG_NAME)
606: THEN

Line 607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

603: p_api_version_number,
604: l_api_name,
605: G_PKG_NAME)
606: THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609:
610:
611: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 612: IF FND_API.to_Boolean( p_init_msg_list )

608: END IF;
609:
610:
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN
614: FND_MSG_PUB.initialize;
615: END IF;
616:

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
620:
621:
622: -- Initialize API return status to SUCCESS
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624:
625: --
626: -- API body
627: --

Line 653: P_Init_Msg_List => FND_API.G_FALSE,

649:
650: IF (l_RQL_TBL.COUNT > 0) THEN
651: CSP_requirement_lines_pub.Delete_requirement_lines(
652: P_Api_Version_Number => 1.0,
653: P_Init_Msg_List => FND_API.G_FALSE,
654: P_Commit => p_commit,
655: P_RQL_TBL => l_RQL_TBL,
656: X_Return_Status => x_return_status,
657: X_Msg_Count => x_msg_count,

Line 661: IF x_return_status = FND_API.G_RET_STS_ERROR then

657: X_Msg_Count => x_msg_count,
658: X_Msg_Data => x_msg_data);
659:
660: -- Check return status from the above procedure call
661: IF x_return_status = FND_API.G_RET_STS_ERROR then
662: raise FND_API.G_EXC_ERROR;
663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;

Line 662: raise FND_API.G_EXC_ERROR;

658: X_Msg_Data => x_msg_data);
659:
660: -- Check return status from the above procedure call
661: IF x_return_status = FND_API.G_RET_STS_ERROR then
662: raise FND_API.G_EXC_ERROR;
663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666: END IF;

Line 663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

659:
660: -- Check return status from the above procedure call
661: IF x_return_status = FND_API.G_RET_STS_ERROR then
662: raise FND_API.G_EXC_ERROR;
663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666: END IF;
667:

Line 664: raise FND_API.G_EXC_UNEXPECTED_ERROR;

660: -- Check return status from the above procedure call
661: IF x_return_status = FND_API.G_RET_STS_ERROR then
662: raise FND_API.G_EXC_ERROR;
663: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
664: raise FND_API.G_EXC_UNEXPECTED_ERROR;
665: END IF;
666: END IF;
667:
668: CSP_requirement_headers_PVT.Delete_requirement_headers(

Line 670: P_Init_Msg_List => FND_API.G_FALSE,

666: END IF;
667:
668: CSP_requirement_headers_PVT.Delete_requirement_headers(
669: P_Api_Version_Number => 1.0,
670: P_Init_Msg_List => FND_API.G_FALSE,
671: P_Commit => p_commit,
672: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
673: P_Requirement_Header_Rec => l_pvt_RQH_Rec,
674: X_Return_Status => x_return_status,

Line 672: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

668: CSP_requirement_headers_PVT.Delete_requirement_headers(
669: P_Api_Version_Number => 1.0,
670: P_Init_Msg_List => FND_API.G_FALSE,
671: P_Commit => p_commit,
672: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
673: P_Requirement_Header_Rec => l_pvt_RQH_Rec,
674: X_Return_Status => x_return_status,
675: X_Msg_Count => x_msg_count,
676: X_Msg_Data => x_msg_data);

Line 679: IF x_return_status = FND_API.G_RET_STS_ERROR then

675: X_Msg_Count => x_msg_count,
676: X_Msg_Data => x_msg_data);
677:
678: -- Check return status from the above procedure call
679: IF x_return_status = FND_API.G_RET_STS_ERROR then
680: raise FND_API.G_EXC_ERROR;
681: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
682: raise FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;

Line 680: raise FND_API.G_EXC_ERROR;

676: X_Msg_Data => x_msg_data);
677:
678: -- Check return status from the above procedure call
679: IF x_return_status = FND_API.G_RET_STS_ERROR then
680: raise FND_API.G_EXC_ERROR;
681: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
682: raise FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:

Line 681: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

677:
678: -- Check return status from the above procedure call
679: IF x_return_status = FND_API.G_RET_STS_ERROR then
680: raise FND_API.G_EXC_ERROR;
681: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
682: raise FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: --

Line 682: raise FND_API.G_EXC_UNEXPECTED_ERROR;

678: -- Check return status from the above procedure call
679: IF x_return_status = FND_API.G_RET_STS_ERROR then
680: raise FND_API.G_EXC_ERROR;
681: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
682: raise FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: --
686: -- End of API body

Line 690: IF FND_API.to_Boolean( p_commit )

686: -- End of API body
687: --
688:
689: -- Standard check for p_commit
690: IF FND_API.to_Boolean( p_commit )
691: THEN
692: COMMIT WORK;
693: END IF;
694:

Line 705: WHEN FND_API.G_EXC_ERROR THEN

701: p_data => x_msg_data
702: );
703:
704: EXCEPTION
705: WHEN FND_API.G_EXC_ERROR THEN
706: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
707: P_API_NAME => L_API_NAME
708: ,P_PKG_NAME => G_PKG_NAME
709: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

711: ,X_MSG_COUNT => X_MSG_COUNT
712: ,X_MSG_DATA => X_MSG_DATA
713: ,X_RETURN_STATUS => X_RETURN_STATUS);
714:
715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
716: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
717: P_API_NAME => L_API_NAME
718: ,P_PKG_NAME => G_PKG_NAME
719: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR