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

Line 20: return Fnd_Api.G_RET_STS_SUCCESS;

16: select responsibility_id from fnd_responsibility_vl where responsibility_key = G_BPEL_USER_ROLE_KEY;
17:
18: BEGIN
19: IF p_user_id IS NULL THEN
20: return Fnd_Api.G_RET_STS_SUCCESS;
21: END IF;
22: OPEN get_user_id_csr(p_user_id);
23: FETCH get_user_id_csr INTO l_user_id;
24: IF get_user_id_csr%NOTFOUND THEN

Line 28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

24: IF get_user_id_csr%NOTFOUND THEN
25: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
26: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
27: FND_MSG_PUB.ADD;
28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30: CLOSE get_user_id_csr;
31:
32: OPEN get_resp_id_csr;

Line 38: return Fnd_Api.G_RET_STS_SUCCESS;

34: CLOSE get_resp_id_csr;
35:
36: FND_GLOBAL.apps_initialize(l_user_id,l_resp_id,867);
37: mo_global.init('AHL');
38: return Fnd_Api.G_RET_STS_SUCCESS;
39:
40: END init_user_and_role;
41:
42: FUNCTION get_workorder_id(p_WorkorderNumber IN VARCHAR2) RETURN NUMBER;

Line 57: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

53:
54: PROCEDURE get_workorder_details
55: (
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_default IN VARCHAR2 := FND_API.G_FALSE,
61: p_module_type IN VARCHAR2,

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

54: PROCEDURE get_workorder_details
55: (
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_default IN VARCHAR2 := FND_API.G_FALSE,
61: p_module_type IN VARCHAR2,
62: p_userid IN VARCHAR2 := NULL,

Line 59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

55: (
56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_default IN VARCHAR2 := FND_API.G_FALSE,
61: p_module_type IN VARCHAR2,
62: p_userid IN VARCHAR2 := NULL,
63: p_WorkorderId IN NUMBER,

Line 60: p_default IN VARCHAR2 := FND_API.G_FALSE,

56: p_api_version IN NUMBER := 1.0,
57: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_default IN VARCHAR2 := FND_API.G_FALSE,
61: p_module_type IN VARCHAR2,
62: p_userid IN VARCHAR2 := NULL,
63: p_WorkorderId IN NUMBER,
64: p_WorkorderNumber IN VARCHAR2,

Line 143: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

139: BEGIN
140: --FND_GLOBAL.apps_initialize(1003259,67336,867);
141: --mo_global.init('AHL');
142: -- Standard call to check for call compatibility
143: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: --FND_GLOBAL.apps_initialize(1003259,67336,867);
141: --mo_global.init('AHL');
142: -- Standard call to check for call compatibility
143: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: IF FND_API.To_Boolean(p_init_msg_list) THEN
148: FND_MSG_PUB.Initialize;

Line 147: IF FND_API.To_Boolean(p_init_msg_list) THEN

143: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END IF;
146:
147: IF FND_API.To_Boolean(p_init_msg_list) THEN
148: FND_MSG_PUB.Initialize;
149: END IF;
150:
151: -- Initialize API return status to success

Line 152: --x_return_status := FND_API.G_RET_STS_SUCCESS;

148: FND_MSG_PUB.Initialize;
149: END IF;
150:
151: -- Initialize API return status to success
152: --x_return_status := FND_API.G_RET_STS_SUCCESS;
153: x_return_status := init_user_and_role(p_userid);
154:
155: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
156: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

Line 158: RAISE FND_API.G_EXC_ERROR;

154:
155: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
156: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;
159: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
160: l_workorder_id := get_workorder_id(p_WorkorderNumber);
161: ELSE
162: l_workorder_id := p_WorkorderId;

Line 172: RAISE FND_API.G_EXC_ERROR;

168: IF(get_wo_details_csr%NOTFOUND)THEN
169: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
170: FND_MSG_PUB.ADD;
171: CLOSE get_wo_details_csr;
172: RAISE FND_API.G_EXC_ERROR;
173: ELSE
174: x_WO_DETAILS_REC.WorkorderId := l_wo_details.WORKORDER_ID;
175: x_WO_DETAILS_REC.ObjectVersionNumber := l_wo_details.OBJECT_VERSION_NUMBER;
176: x_WO_DETAILS_REC.WorkorderNumber := l_wo_details.JOB_NUMBER;

Line 258: WHEN FND_API.G_EXC_ERROR THEN

254: END IF;
255: CLOSE get_wo_details_csr;
256:
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: x_msg_count := FND_MSG_PUB.count_msg;
261:
262:

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: CLOSE get_wo_details_csr;
256:
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: x_msg_count := FND_MSG_PUB.count_msg;
261:
262:
263: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

260: x_msg_count := FND_MSG_PUB.count_msg;
261:
262:
263: x_msg_data := GET_MSG_DATA(x_msg_count);
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: x_msg_count := FND_MSG_PUB.count_msg;
267: x_msg_data := GET_MSG_DATA(x_msg_count);
268: WHEN OTHERS THEN

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261:
262:
263: x_msg_data := GET_MSG_DATA(x_msg_count);
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: x_msg_count := FND_MSG_PUB.count_msg;
267: x_msg_data := GET_MSG_DATA(x_msg_count);
268: WHEN OTHERS THEN
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: x_msg_count := FND_MSG_PUB.count_msg;
267: x_msg_data := GET_MSG_DATA(x_msg_count);
268: WHEN OTHERS THEN
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270:
271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
272: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
273: p_procedure_name => l_api_name,

Line 283: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

279:
280: PROCEDURE get_wo_operations_details
281: (
282: p_api_version IN NUMBER := 1.0,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_default IN VARCHAR2 := FND_API.G_FALSE,
287: p_module_type IN VARCHAR2,

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

280: PROCEDURE get_wo_operations_details
281: (
282: p_api_version IN NUMBER := 1.0,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_default IN VARCHAR2 := FND_API.G_FALSE,
287: p_module_type IN VARCHAR2,
288: p_userid IN VARCHAR2 := NULL,

Line 285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

281: (
282: p_api_version IN NUMBER := 1.0,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_default IN VARCHAR2 := FND_API.G_FALSE,
287: p_module_type IN VARCHAR2,
288: p_userid IN VARCHAR2 := NULL,
289: p_WorkorderId IN NUMBER,

Line 286: p_default IN VARCHAR2 := FND_API.G_FALSE,

282: p_api_version IN NUMBER := 1.0,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_default IN VARCHAR2 := FND_API.G_FALSE,
287: p_module_type IN VARCHAR2,
288: p_userid IN VARCHAR2 := NULL,
289: p_WorkorderId IN NUMBER,
290: p_WorkorderNumber IN VARCHAR2,

Line 322: --x_return_status := FND_API.G_RET_STS_SUCCESS;

318: BEGIN
319: --FND_GLOBAL.apps_initialize(1003259,67336,867);
320: --mo_global.init('AHL');
321: -- Initialize API return status to success
322: --x_return_status := FND_API.G_RET_STS_SUCCESS;
323: x_return_status := init_user_and_role(p_userid);
324: x_Operations(0) := NULL;
325: -- Standard call to check for call compatibility
326: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

Line 326: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

322: --x_return_status := FND_API.G_RET_STS_SUCCESS;
323: x_return_status := init_user_and_role(p_userid);
324: x_Operations(0) := NULL;
325: -- Standard call to check for call compatibility
326: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

323: x_return_status := init_user_and_role(p_userid);
324: x_Operations(0) := NULL;
325: -- Standard call to check for call compatibility
326: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: IF FND_API.To_Boolean(p_init_msg_list) THEN
331: FND_MSG_PUB.Initialize;

Line 330: IF FND_API.To_Boolean(p_init_msg_list) THEN

326: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: IF FND_API.To_Boolean(p_init_msg_list) THEN
331: FND_MSG_PUB.Initialize;
332: END IF;
333: -- Check Error Message stack.
334: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN

Line 337: RAISE FND_API.G_EXC_ERROR;

333: -- Check Error Message stack.
334: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
335: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
339: l_workorder_id := get_workorder_id(p_WorkorderNumber);
340: ELSE
341: l_workorder_id := p_WorkorderId;

Line 346: RAISE FND_API.G_EXC_ERROR;

342: END IF;
343:
344: x_msg_count := FND_MSG_PUB.count_msg;
345: IF x_msg_count > 0 THEN
346: RAISE FND_API.G_EXC_ERROR;
347: END IF;
348:
349: IF(p_WoOperationId IS NULL AND p_OperationSequence IS NULL)THEN
350: NULL;

Line 359: RAISE FND_API.G_EXC_ERROR;

355: END IF;
356:
357: x_msg_count := FND_MSG_PUB.count_msg;
358: IF x_msg_count > 0 THEN
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;
361:
362: l_op_index :=0;
363: FOR op_details IN get_operations_details_csr(l_workorder_id,l_workorder_operation_id) LOOP

Line 395: RAISE FND_API.G_EXC_ERROR;

391: END LOOP;
392:
393: x_msg_count := FND_MSG_PUB.count_msg;
394: IF x_msg_count > 0 THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN

Line 399: WHEN FND_API.G_EXC_ERROR THEN

395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: x_msg_count := FND_MSG_PUB.count_msg;
402:
403:

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: END IF;
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: x_msg_count := FND_MSG_PUB.count_msg;
402:
403:
404: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

401: x_msg_count := FND_MSG_PUB.count_msg;
402:
403:
404: x_msg_data := GET_MSG_DATA(x_msg_count);
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: x_msg_count := FND_MSG_PUB.count_msg;
408: x_msg_data := GET_MSG_DATA(x_msg_count);
409: WHEN OTHERS THEN

Line 406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

402:
403:
404: x_msg_data := GET_MSG_DATA(x_msg_count);
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: x_msg_count := FND_MSG_PUB.count_msg;
408: x_msg_data := GET_MSG_DATA(x_msg_count);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: x_msg_count := FND_MSG_PUB.count_msg;
408: x_msg_data := GET_MSG_DATA(x_msg_count);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411:
412: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
413: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
414: p_procedure_name => l_api_name,

Line 424: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

420:
421: PROCEDURE get_wo_mtl_reqmts
422: (
423: p_api_version IN NUMBER := 1.0,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: p_default IN VARCHAR2 := FND_API.G_FALSE,
428: p_module_type IN VARCHAR2,

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

421: PROCEDURE get_wo_mtl_reqmts
422: (
423: p_api_version IN NUMBER := 1.0,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: p_default IN VARCHAR2 := FND_API.G_FALSE,
428: p_module_type IN VARCHAR2,
429: p_userid IN VARCHAR2 := NULL,

Line 426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

422: (
423: p_api_version IN NUMBER := 1.0,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: p_default IN VARCHAR2 := FND_API.G_FALSE,
428: p_module_type IN VARCHAR2,
429: p_userid IN VARCHAR2 := NULL,
430: p_WorkorderId IN NUMBER,

Line 427: p_default IN VARCHAR2 := FND_API.G_FALSE,

423: p_api_version IN NUMBER := 1.0,
424: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
425: p_commit IN VARCHAR2 := FND_API.G_FALSE,
426: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
427: p_default IN VARCHAR2 := FND_API.G_FALSE,
428: p_module_type IN VARCHAR2,
429: p_userid IN VARCHAR2 := NULL,
430: p_WorkorderId IN NUMBER,
431: p_WorkorderNumber IN VARCHAR2,

Line 469: --x_return_status := FND_API.G_RET_STS_SUCCESS;

465: l_mtl_index NUMBER;
466:
467: BEGIN
468: -- Initialize API return status to success
469: --x_return_status := FND_API.G_RET_STS_SUCCESS;
470: x_return_status := init_user_and_role(p_userid);
471: x_MaterialRequirementDetails(0) := NULL;
472: --FND_GLOBAL.apps_initialize(1003259,67336,867);
473: --mo_global.init('AHL');

Line 475: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

471: x_MaterialRequirementDetails(0) := NULL;
472: --FND_GLOBAL.apps_initialize(1003259,67336,867);
473: --mo_global.init('AHL');
474: -- Standard call to check for call compatibility
475: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

472: --FND_GLOBAL.apps_initialize(1003259,67336,867);
473: --mo_global.init('AHL');
474: -- Standard call to check for call compatibility
475: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: IF FND_API.To_Boolean(p_init_msg_list) THEN
480: FND_MSG_PUB.Initialize;

Line 479: IF FND_API.To_Boolean(p_init_msg_list) THEN

475: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
477: END IF;
478:
479: IF FND_API.To_Boolean(p_init_msg_list) THEN
480: FND_MSG_PUB.Initialize;
481: END IF;
482:
483: -- Check Error Message stack.

Line 487: RAISE FND_API.G_EXC_ERROR;

483: -- Check Error Message stack.
484: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
485: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
486: FND_MSG_PUB.ADD;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
489: l_workorder_id := get_workorder_id(p_WorkorderNumber);
490: ELSE
491: l_workorder_id := p_WorkorderId;

Line 504: RAISE FND_API.G_EXC_ERROR;

500: END IF;
501:
502: x_msg_count := FND_MSG_PUB.count_msg;
503: IF x_msg_count > 0 THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: l_mtl_index :=0;
508: FOR mtl_details IN get_wo_mtl_reqmts_csr(l_workorder_id,l_workorder_operation_id) LOOP

Line 527: RAISE FND_API.G_EXC_ERROR;

523:
524: -- Check Error Message stack.
525: x_msg_count := FND_MSG_PUB.count_msg;
526: IF x_msg_count > 0 THEN
527: RAISE FND_API.G_EXC_ERROR;
528: END IF;
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN

Line 531: WHEN FND_API.G_EXC_ERROR THEN

527: RAISE FND_API.G_EXC_ERROR;
528: END IF;
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: x_msg_count := FND_MSG_PUB.count_msg;
534:
535:

Line 532: x_return_status := FND_API.G_RET_STS_ERROR;

528: END IF;
529:
530: EXCEPTION
531: WHEN FND_API.G_EXC_ERROR THEN
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: x_msg_count := FND_MSG_PUB.count_msg;
534:
535:
536: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

533: x_msg_count := FND_MSG_PUB.count_msg;
534:
535:
536: x_msg_data := GET_MSG_DATA(x_msg_count);
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: x_msg_count := FND_MSG_PUB.count_msg;
540: x_msg_data := GET_MSG_DATA(x_msg_count);
541: WHEN OTHERS THEN

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

534:
535:
536: x_msg_data := GET_MSG_DATA(x_msg_count);
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: x_msg_count := FND_MSG_PUB.count_msg;
540: x_msg_data := GET_MSG_DATA(x_msg_count);
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: x_msg_count := FND_MSG_PUB.count_msg;
540: x_msg_data := GET_MSG_DATA(x_msg_count);
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543:
544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
545: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
546: p_procedure_name => l_api_name,

Line 556: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

552:
553: PROCEDURE get_wo_assoc_documents
554: (
555: p_api_version IN NUMBER := 1.0,
556: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
557: p_commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: p_default IN VARCHAR2 := FND_API.G_FALSE,
560: p_module_type IN VARCHAR2,

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

553: PROCEDURE get_wo_assoc_documents
554: (
555: p_api_version IN NUMBER := 1.0,
556: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
557: p_commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: p_default IN VARCHAR2 := FND_API.G_FALSE,
560: p_module_type IN VARCHAR2,
561: p_userid IN VARCHAR2 := NULL,

Line 558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

554: (
555: p_api_version IN NUMBER := 1.0,
556: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
557: p_commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: p_default IN VARCHAR2 := FND_API.G_FALSE,
560: p_module_type IN VARCHAR2,
561: p_userid IN VARCHAR2 := NULL,
562: p_WorkorderId IN NUMBER,

Line 559: p_default IN VARCHAR2 := FND_API.G_FALSE,

555: p_api_version IN NUMBER := 1.0,
556: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
557: p_commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
559: p_default IN VARCHAR2 := FND_API.G_FALSE,
560: p_module_type IN VARCHAR2,
561: p_userid IN VARCHAR2 := NULL,
562: p_WorkorderId IN NUMBER,
563: p_WorkorderNumber IN VARCHAR2,

Line 651: --x_return_status := FND_API.G_RET_STS_SUCCESS;

647: AND TRUNC(NVL(REV.OBSOLETE_DATE, SYSDATE + 1)) > TRUNC(SYSDATE);
648:
649: BEGIN
650: -- Initialize API return status to success
651: --x_return_status := FND_API.G_RET_STS_SUCCESS;
652: x_return_status := init_user_and_role(p_userid);
653: x_AssociatedDocuments(0) := NULL;
654: --FND_GLOBAL.apps_initialize(1003259,67336,867);
655: --mo_global.init('AHL');

Line 657: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

653: x_AssociatedDocuments(0) := NULL;
654: --FND_GLOBAL.apps_initialize(1003259,67336,867);
655: --mo_global.init('AHL');
656: -- Standard call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654: --FND_GLOBAL.apps_initialize(1003259,67336,867);
655: --mo_global.init('AHL');
656: -- Standard call to check for call compatibility
657: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: IF FND_API.To_Boolean(p_init_msg_list) THEN
662: FND_MSG_PUB.Initialize;

Line 661: IF FND_API.To_Boolean(p_init_msg_list) THEN

657: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661: IF FND_API.To_Boolean(p_init_msg_list) THEN
662: FND_MSG_PUB.Initialize;
663: END IF;
664:
665: -- Check Error Message stack.

Line 669: RAISE FND_API.G_EXC_ERROR;

665: -- Check Error Message stack.
666: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
667: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
668: FND_MSG_PUB.ADD;
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
671: l_workorder_id := get_workorder_id(p_WorkorderNumber);
672: ELSE
673: l_workorder_id := p_WorkorderId;

Line 678: RAISE FND_API.G_EXC_ERROR;

674: END IF;
675:
676: x_msg_count := FND_MSG_PUB.count_msg;
677: IF x_msg_count > 0 THEN
678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680:
681: l_doc_index := 0;
682: FOR assoc_docs IN get_wo_assoc_documents_csr(l_workorder_id ) LOOP

Line 699: RAISE FND_API.G_EXC_ERROR;

695:
696: -- Check Error Message stack.
697: x_msg_count := FND_MSG_PUB.count_msg;
698: IF x_msg_count > 0 THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701:
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN

Line 703: WHEN FND_API.G_EXC_ERROR THEN

699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701:
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: x_msg_count := FND_MSG_PUB.count_msg;
706:
707:

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: END IF;
701:
702: EXCEPTION
703: WHEN FND_API.G_EXC_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: x_msg_count := FND_MSG_PUB.count_msg;
706:
707:
708: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

705: x_msg_count := FND_MSG_PUB.count_msg;
706:
707:
708: x_msg_data := GET_MSG_DATA(x_msg_count);
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_msg_count := FND_MSG_PUB.count_msg;
712: x_msg_data := GET_MSG_DATA(x_msg_count);
713: WHEN OTHERS THEN

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706:
707:
708: x_msg_data := GET_MSG_DATA(x_msg_count);
709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_msg_count := FND_MSG_PUB.count_msg;
712: x_msg_data := GET_MSG_DATA(x_msg_count);
713: WHEN OTHERS THEN
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_msg_count := FND_MSG_PUB.count_msg;
712: x_msg_data := GET_MSG_DATA(x_msg_count);
713: WHEN OTHERS THEN
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715:
716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
717: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
718: p_procedure_name => l_api_name,

Line 728: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

724:
725: PROCEDURE get_wo_turnover_notes
726: (
727: p_api_version IN NUMBER := 1.0,
728: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
731: p_default IN VARCHAR2 := FND_API.G_FALSE,
732: p_module_type IN VARCHAR2,

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

725: PROCEDURE get_wo_turnover_notes
726: (
727: p_api_version IN NUMBER := 1.0,
728: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
731: p_default IN VARCHAR2 := FND_API.G_FALSE,
732: p_module_type IN VARCHAR2,
733: p_userid IN VARCHAR2 := NULL,

Line 730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

726: (
727: p_api_version IN NUMBER := 1.0,
728: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
731: p_default IN VARCHAR2 := FND_API.G_FALSE,
732: p_module_type IN VARCHAR2,
733: p_userid IN VARCHAR2 := NULL,
734: p_WorkorderId IN NUMBER,

Line 731: p_default IN VARCHAR2 := FND_API.G_FALSE,

727: p_api_version IN NUMBER := 1.0,
728: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
730: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
731: p_default IN VARCHAR2 := FND_API.G_FALSE,
732: p_module_type IN VARCHAR2,
733: p_userid IN VARCHAR2 := NULL,
734: p_WorkorderId IN NUMBER,
735: p_WorkorderNumber IN VARCHAR2,

Line 762: --x_return_status := FND_API.G_RET_STS_SUCCESS;

758: and source_object_id = p_WorkorderId ORDER BY entered_date DESC;
759:
760: BEGIN
761: -- Initialize API return status to success
762: --x_return_status := FND_API.G_RET_STS_SUCCESS;
763: x_return_status := init_user_and_role(p_userid);
764: x_TurnoverNotes(0) := NULL;
765: --FND_GLOBAL.apps_initialize(1003259,67336,867);
766: --mo_global.init('AHL');

Line 768: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

764: x_TurnoverNotes(0) := NULL;
765: --FND_GLOBAL.apps_initialize(1003259,67336,867);
766: --mo_global.init('AHL');
767: -- Standard call to check for call compatibility
768: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:
772: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: --FND_GLOBAL.apps_initialize(1003259,67336,867);
766: --mo_global.init('AHL');
767: -- Standard call to check for call compatibility
768: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:
772: IF FND_API.To_Boolean(p_init_msg_list) THEN
773: FND_MSG_PUB.Initialize;

Line 772: IF FND_API.To_Boolean(p_init_msg_list) THEN

768: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:
772: IF FND_API.To_Boolean(p_init_msg_list) THEN
773: FND_MSG_PUB.Initialize;
774: END IF;
775:
776: -- Check Error Message stack.

Line 780: RAISE FND_API.G_EXC_ERROR;

776: -- Check Error Message stack.
777: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
778: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
779: FND_MSG_PUB.ADD;
780: RAISE FND_API.G_EXC_ERROR;
781: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
782: l_workorder_id := get_workorder_id(p_WorkorderNumber);
783: ELSE
784: l_workorder_id := p_WorkorderId;

Line 789: RAISE FND_API.G_EXC_ERROR;

785: END IF;
786:
787: x_msg_count := FND_MSG_PUB.count_msg;
788: IF x_msg_count > 0 THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791:
792: l_notes_index := 0;
793: FOR notes IN get_wo_turnover_notes_csr(l_workorder_id ) LOOP

Line 807: RAISE FND_API.G_EXC_ERROR;

803:
804: -- Check Error Message stack.
805: x_msg_count := FND_MSG_PUB.count_msg;
806: IF x_msg_count > 0 THEN
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: EXCEPTION
810: WHEN FND_API.G_EXC_ERROR THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;

Line 810: WHEN FND_API.G_EXC_ERROR THEN

806: IF x_msg_count > 0 THEN
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: EXCEPTION
810: WHEN FND_API.G_EXC_ERROR THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: x_msg_count := FND_MSG_PUB.count_msg;
813:
814:

Line 811: x_return_status := FND_API.G_RET_STS_ERROR;

807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: EXCEPTION
810: WHEN FND_API.G_EXC_ERROR THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: x_msg_count := FND_MSG_PUB.count_msg;
813:
814:
815: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

812: x_msg_count := FND_MSG_PUB.count_msg;
813:
814:
815: x_msg_data := GET_MSG_DATA(x_msg_count);
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: x_msg_count := FND_MSG_PUB.count_msg;
819: x_msg_data := GET_MSG_DATA(x_msg_count);
820: WHEN OTHERS THEN

Line 817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

813:
814:
815: x_msg_data := GET_MSG_DATA(x_msg_count);
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: x_msg_count := FND_MSG_PUB.count_msg;
819: x_msg_data := GET_MSG_DATA(x_msg_count);
820: WHEN OTHERS THEN
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: x_msg_count := FND_MSG_PUB.count_msg;
819: x_msg_data := GET_MSG_DATA(x_msg_count);
820: WHEN OTHERS THEN
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822:
823: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
824: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
825: p_procedure_name => l_api_name,

Line 835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

831:
832: PROCEDURE get_wo_res_txns
833: (
834: p_api_version IN NUMBER := 1.0,
835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: p_default IN VARCHAR2 := FND_API.G_FALSE,
839: p_module_type IN VARCHAR2,

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

832: PROCEDURE get_wo_res_txns
833: (
834: p_api_version IN NUMBER := 1.0,
835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: p_default IN VARCHAR2 := FND_API.G_FALSE,
839: p_module_type IN VARCHAR2,
840: p_userid IN VARCHAR2 := NULL,

Line 837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

833: (
834: p_api_version IN NUMBER := 1.0,
835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: p_default IN VARCHAR2 := FND_API.G_FALSE,
839: p_module_type IN VARCHAR2,
840: p_userid IN VARCHAR2 := NULL,
841: p_WorkorderId IN NUMBER,

Line 838: p_default IN VARCHAR2 := FND_API.G_FALSE,

834: p_api_version IN NUMBER := 1.0,
835: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
836: p_commit IN VARCHAR2 := FND_API.G_FALSE,
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838: p_default IN VARCHAR2 := FND_API.G_FALSE,
839: p_module_type IN VARCHAR2,
840: p_userid IN VARCHAR2 := NULL,
841: p_WorkorderId IN NUMBER,
842: p_WorkorderNumber IN VARCHAR2,

Line 892: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

888:
889: --FND_GLOBAL.apps_initialize(1003259,67336,867);
890: --mo_global.init('AHL');
891: -- Standard call to check for call compatibility
892: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895:
896: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

889: --FND_GLOBAL.apps_initialize(1003259,67336,867);
890: --mo_global.init('AHL');
891: -- Standard call to check for call compatibility
892: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895:
896: IF FND_API.To_Boolean(p_init_msg_list) THEN
897: FND_MSG_PUB.Initialize;

Line 896: IF FND_API.To_Boolean(p_init_msg_list) THEN

892: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
894: END IF;
895:
896: IF FND_API.To_Boolean(p_init_msg_list) THEN
897: FND_MSG_PUB.Initialize;
898: END IF;
899:
900: -- Check Error Message stack.

Line 904: RAISE FND_API.G_EXC_ERROR;

900: -- Check Error Message stack.
901: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
902: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
903: FND_MSG_PUB.ADD;
904: RAISE FND_API.G_EXC_ERROR;
905: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
906: l_workorder_id := get_workorder_id(p_WorkorderNumber);
907: ELSE
908: l_workorder_id := p_WorkorderId;

Line 913: RAISE FND_API.G_EXC_ERROR;

909: END IF;
910:
911: x_msg_count := FND_MSG_PUB.count_msg;
912: IF x_msg_count > 0 THEN
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915:
916: IF(p_WoOperationId IS NOT NULL)THEN
917: OPEN get_operation_sequence_csr(p_WoOperationId);

Line 922: RAISE FND_API.G_EXC_ERROR;

918: FETCH get_operation_sequence_csr INTO l_operation_sequence;
919: IF(get_operation_sequence_csr%NOTFOUND)THEN
920: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
921: FND_MSG_PUB.ADD;
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924: CLOSE get_operation_sequence_csr;
925: ELSIF (p_WoOperationId IS NULL AND p_OperationSequence IS NOT NULL)THEN
926: l_operation_sequence := p_OperationSequence;

Line 931: RAISE FND_API.G_EXC_ERROR;

927: END IF;
928: -- Check Error Message stack.
929: x_msg_count := FND_MSG_PUB.count_msg;
930: IF x_msg_count > 0 THEN
931: RAISE FND_API.G_EXC_ERROR;
932: END IF;
933:
934:
935: l_restxns_index := 0;

Line 977: p_init_msg_list => FND_API.G_TRUE,

973: FOR res_txns_defaults IN get_operation_sequences_csr(l_workorder_id, l_operation_sequence)LOOP
974: AHL_PRD_RESOURCE_TRANX_PVT.Get_Resource_Txn_Defaults
975: (
976: p_api_version => 1.0,
977: p_init_msg_list => FND_API.G_TRUE,
978: p_module_type => NULL,
979: x_return_status => x_return_status,
980: x_msg_count => x_msg_count,
981: x_msg_data => x_msg_data,

Line 1012: RAISE FND_API.G_EXC_ERROR;

1008:
1009: -- Check Error Message stack.
1010: x_msg_count := FND_MSG_PUB.count_msg;
1011: IF x_msg_count > 0 THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015:
1016: EXCEPTION

Line 1014: x_return_status := FND_API.G_RET_STS_SUCCESS;

1010: x_msg_count := FND_MSG_PUB.count_msg;
1011: IF x_msg_count > 0 THEN
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015:
1016: EXCEPTION
1017: WHEN FND_API.G_EXC_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1017: WHEN FND_API.G_EXC_ERROR THEN

1013: END IF;
1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015:
1016: EXCEPTION
1017: WHEN FND_API.G_EXC_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: x_msg_count := FND_MSG_PUB.count_msg;
1020:
1021:

Line 1018: x_return_status := FND_API.G_RET_STS_ERROR;

1014: x_return_status := FND_API.G_RET_STS_SUCCESS;
1015:
1016: EXCEPTION
1017: WHEN FND_API.G_EXC_ERROR THEN
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: x_msg_count := FND_MSG_PUB.count_msg;
1020:
1021:
1022: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 1023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1019: x_msg_count := FND_MSG_PUB.count_msg;
1020:
1021:
1022: x_msg_data := GET_MSG_DATA(x_msg_count);
1023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: x_msg_count := FND_MSG_PUB.count_msg;
1026: x_msg_data := GET_MSG_DATA(x_msg_count);
1027: WHEN OTHERS THEN

Line 1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1020:
1021:
1022: x_msg_data := GET_MSG_DATA(x_msg_count);
1023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: x_msg_count := FND_MSG_PUB.count_msg;
1026: x_msg_data := GET_MSG_DATA(x_msg_count);
1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: x_msg_count := FND_MSG_PUB.count_msg;
1026: x_msg_data := GET_MSG_DATA(x_msg_count);
1027: WHEN OTHERS THEN
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029:
1030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1031: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1032: p_procedure_name => l_api_name,

Line 1042: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1038:
1039: PROCEDURE get_qa_plan_results
1040: (
1041: p_api_version IN NUMBER := 1.0,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1045: p_default IN VARCHAR2 := FND_API.G_FALSE,
1046: p_module_type IN VARCHAR2,

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

1039: PROCEDURE get_qa_plan_results
1040: (
1041: p_api_version IN NUMBER := 1.0,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1045: p_default IN VARCHAR2 := FND_API.G_FALSE,
1046: p_module_type IN VARCHAR2,
1047: p_userid IN VARCHAR2 := NULL,

Line 1044: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1040: (
1041: p_api_version IN NUMBER := 1.0,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1045: p_default IN VARCHAR2 := FND_API.G_FALSE,
1046: p_module_type IN VARCHAR2,
1047: p_userid IN VARCHAR2 := NULL,
1048: p_WorkorderId IN NUMBER,

Line 1045: p_default IN VARCHAR2 := FND_API.G_FALSE,

1041: p_api_version IN NUMBER := 1.0,
1042: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1043: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1044: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1045: p_default IN VARCHAR2 := FND_API.G_FALSE,
1046: p_module_type IN VARCHAR2,
1047: p_userid IN VARCHAR2 := NULL,
1048: p_WorkorderId IN NUMBER,
1049: p_WorkorderNumber IN VARCHAR2,

Line 1144: --x_return_status := FND_API.G_RET_STS_SUCCESS;

1140:
1141:
1142: BEGIN
1143: -- Initialize API return status to success
1144: --x_return_status := FND_API.G_RET_STS_SUCCESS;
1145: x_return_status := init_user_and_role(p_userid);
1146: x_QaPlan.QA_PLAN_ATR_TBL(0) := NULL;
1147: x_QaResults.QA_RESULT_TBL(0).QA_PLAN_ATRVAL_TBL(0) := NULL;
1148:

Line 1152: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

1148:
1149: --FND_GLOBAL.apps_initialize(1003259,67336,867);
1150: --mo_global.init('AHL');
1151: -- Standard call to check for call compatibility
1152: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:
1156: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1149: --FND_GLOBAL.apps_initialize(1003259,67336,867);
1150: --mo_global.init('AHL');
1151: -- Standard call to check for call compatibility
1152: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:
1156: IF FND_API.To_Boolean(p_init_msg_list) THEN
1157: FND_MSG_PUB.Initialize;

Line 1156: IF FND_API.To_Boolean(p_init_msg_list) THEN

1152: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
1153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1154: END IF;
1155:
1156: IF FND_API.To_Boolean(p_init_msg_list) THEN
1157: FND_MSG_PUB.Initialize;
1158: END IF;
1159:
1160: -- Check Error Message stack.

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: -- Check Error Message stack.
1161: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
1162: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
1166: l_workorder_id := get_workorder_id(p_WorkorderNumber);
1167: ELSE
1168: l_workorder_id := p_WorkorderId;

Line 1173: RAISE FND_API.G_EXC_ERROR;

1169: END IF;
1170:
1171: x_msg_count := FND_MSG_PUB.count_msg;
1172: IF x_msg_count > 0 THEN
1173: RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176: IF(p_WoOperationId IS NULL AND p_OperationSequence IS NULL)THEN
1177: l_workorder_operation_id := NULL;

Line 1186: RAISE FND_API.G_EXC_ERROR;

1182: END IF;
1183: --l_workorder_operation_id := NULL;
1184: x_msg_count := FND_MSG_PUB.count_msg;
1185: IF x_msg_count > 0 THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188:
1189: IF(l_workorder_operation_id IS NOT NULL)THEN
1190: OPEN get_op_plan_csr(l_workorder_operation_id);

Line 1328: WHEN FND_API.G_EXC_ERROR THEN

1324: -- Check Error Message stack.
1325: x_msg_count := FND_MSG_PUB.count_msg;
1326:
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: x_msg_count := FND_MSG_PUB.count_msg;
1331:
1332:

Line 1329: x_return_status := FND_API.G_RET_STS_ERROR;

1325: x_msg_count := FND_MSG_PUB.count_msg;
1326:
1327: EXCEPTION
1328: WHEN FND_API.G_EXC_ERROR THEN
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: x_msg_count := FND_MSG_PUB.count_msg;
1331:
1332:
1333: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1330: x_msg_count := FND_MSG_PUB.count_msg;
1331:
1332:
1333: x_msg_data := GET_MSG_DATA(x_msg_count);
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: x_msg_count := FND_MSG_PUB.count_msg;
1337: x_msg_data := GET_MSG_DATA(x_msg_count);
1338: WHEN OTHERS THEN

Line 1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1331:
1332:
1333: x_msg_data := GET_MSG_DATA(x_msg_count);
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: x_msg_count := FND_MSG_PUB.count_msg;
1337: x_msg_data := GET_MSG_DATA(x_msg_count);
1338: WHEN OTHERS THEN
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1336: x_msg_count := FND_MSG_PUB.count_msg;
1337: x_msg_data := GET_MSG_DATA(x_msg_count);
1338: WHEN OTHERS THEN
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1340:
1341: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1342: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
1343: p_procedure_name => l_api_name,

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: IF(get_workorder_id_csr%NOTFOUND)THEN
1363: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1364: FND_MSG_PUB.ADD;
1365: CLOSE get_workorder_id_csr;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: CLOSE get_workorder_id_csr;
1369: RETURN l_workorder_id;
1370: END get_workorder_id;

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385: IF(get_workorder_operation_id_csr%NOTFOUND)THEN
1386: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1387: FND_MSG_PUB.ADD;
1388: CLOSE get_workorder_operation_id_csr;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;
1391: CLOSE get_workorder_operation_id_csr;
1392: RETURN l_workorder_operation_id;
1393: END get_workorder_operation_id;

Line 1467: x_return_status := FND_API.G_RET_STS_SUCCESS;

1463: )IS
1464: l_trunover_notes_tbl AHL_PRD_WORKORDER_PVT.turnover_notes_tbl_type;
1465: j INTEGER;
1466: BEGIN
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468: IF(p_TurnoverNotes IS NULL OR p_TurnoverNotes.COUNT < 1)THEN
1469: RETURN;
1470: END IF;
1471: j :=0;

Line 1489: RAISE FND_API.G_EXC_ERROR;

1485: IF(l_trunover_notes_tbl IS NOT NULL AND l_trunover_notes_tbl.COUNT > 0)THEN
1486: IF(p_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
1487: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TRNNTREC_NALWD');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES
1493: (

Line 1495: p_init_msg_list => FND_API.G_TRUE,

1491:
1492: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES
1493: (
1494: p_api_version => 1.0 ,
1495: p_init_msg_list => FND_API.G_TRUE,
1496: p_commit => FND_API.G_FALSE,
1497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1498: p_default => FND_API.G_TRUE,
1499: p_module_type => 'OAF',

Line 1496: p_commit => FND_API.G_FALSE,

1492: AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES
1493: (
1494: p_api_version => 1.0 ,
1495: p_init_msg_list => FND_API.G_TRUE,
1496: p_commit => FND_API.G_FALSE,
1497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1498: p_default => FND_API.G_TRUE,
1499: p_module_type => 'OAF',
1500: x_return_status => x_return_status,

Line 1497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1493: (
1494: p_api_version => 1.0 ,
1495: p_init_msg_list => FND_API.G_TRUE,
1496: p_commit => FND_API.G_FALSE,
1497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1498: p_default => FND_API.G_TRUE,
1499: p_module_type => 'OAF',
1500: x_return_status => x_return_status,
1501: x_msg_count => x_msg_count,

Line 1498: p_default => FND_API.G_TRUE,

1494: p_api_version => 1.0 ,
1495: p_init_msg_list => FND_API.G_TRUE,
1496: p_commit => FND_API.G_FALSE,
1497: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1498: p_default => FND_API.G_TRUE,
1499: p_module_type => 'OAF',
1500: x_return_status => x_return_status,
1501: x_msg_count => x_msg_count,
1502: x_msg_data => x_msg_data,

Line 1523: x_return_status := FND_API.G_RET_STS_SUCCESS;

1519:
1520: l_prd_workorder_rec AHL_PRD_WORKORDER_PVT.prd_workorder_rec;
1521: l_prd_workoper_tbl AHL_PRD_WORKORDER_PVT.prd_workoper_tbl;
1522: BEGIN
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: IF(p_WO_DETAILS_REC.StatusCode IS NULL OR p_WO_DETAILS_REC.StatusCode = p_CURR_WO_DETAILS_REC.StatusCode)THEN
1525: RETURN;--Nothing to do
1526: END IF;
1527: IF(p_CURR_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN

Line 1530: RAISE FND_API.G_EXC_ERROR;

1526: END IF;
1527: IF(p_CURR_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
1528: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_UPD_NALWD');
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: IF(p_WO_DETAILS_REC.StatusCode = '3' AND p_CURR_WO_DETAILS_REC.StatusCode = '1')THEN
1533: --release Job
1534: AHL_PRD_WORKORDER_PVT.release_visit_jobs

Line 1537: p_init_msg_list => FND_API.G_TRUE,

1533: --release Job
1534: AHL_PRD_WORKORDER_PVT.release_visit_jobs
1535: (
1536: p_api_version => 1.0 ,
1537: p_init_msg_list => FND_API.G_TRUE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_default => FND_API.G_TRUE,
1541: p_module_type => 'OAF',

Line 1538: p_commit => FND_API.G_FALSE,

1534: AHL_PRD_WORKORDER_PVT.release_visit_jobs
1535: (
1536: p_api_version => 1.0 ,
1537: p_init_msg_list => FND_API.G_TRUE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_default => FND_API.G_TRUE,
1541: p_module_type => 'OAF',
1542: x_return_status => x_return_status,

Line 1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1535: (
1536: p_api_version => 1.0 ,
1537: p_init_msg_list => FND_API.G_TRUE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_default => FND_API.G_TRUE,
1541: p_module_type => 'OAF',
1542: x_return_status => x_return_status,
1543: x_msg_count => x_msg_count,

Line 1540: p_default => FND_API.G_TRUE,

1536: p_api_version => 1.0 ,
1537: p_init_msg_list => FND_API.G_TRUE,
1538: p_commit => FND_API.G_FALSE,
1539: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1540: p_default => FND_API.G_TRUE,
1541: p_module_type => 'OAF',
1542: x_return_status => x_return_status,
1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data,

Line 1554: p_init_msg_list => FND_API.G_TRUE,

1550: --cancel job
1551: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
1552: (
1553: p_api_version => 1.0 ,
1554: p_init_msg_list => FND_API.G_TRUE,
1555: p_commit => FND_API.G_FALSE,
1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1557: p_default => FND_API.G_TRUE,
1558: p_module_type => 'OAF',

Line 1555: p_commit => FND_API.G_FALSE,

1551: AHL_PRD_WORKORDER_PVT.cancel_visit_jobs
1552: (
1553: p_api_version => 1.0 ,
1554: p_init_msg_list => FND_API.G_TRUE,
1555: p_commit => FND_API.G_FALSE,
1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1557: p_default => FND_API.G_TRUE,
1558: p_module_type => 'OAF',
1559: x_return_status => x_return_status,

Line 1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1552: (
1553: p_api_version => 1.0 ,
1554: p_init_msg_list => FND_API.G_TRUE,
1555: p_commit => FND_API.G_FALSE,
1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1557: p_default => FND_API.G_TRUE,
1558: p_module_type => 'OAF',
1559: x_return_status => x_return_status,
1560: x_msg_count => x_msg_count,

Line 1557: p_default => FND_API.G_TRUE,

1553: p_api_version => 1.0 ,
1554: p_init_msg_list => FND_API.G_TRUE,
1555: p_commit => FND_API.G_FALSE,
1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1557: p_default => FND_API.G_TRUE,
1558: p_module_type => 'OAF',
1559: x_return_status => x_return_status,
1560: x_msg_count => x_msg_count,
1561: x_msg_data => x_msg_data,

Line 1570: RAISE FND_API.G_EXC_ERROR;

1566: ELSIF(p_WO_DETAILS_REC.StatusCode = '4')THEN
1567: IF(p_CURR_WO_DETAILS_REC.IsCompleteEnabled <> 'T')THEN
1568: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_COMP_NALWD');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: -- complete job
1573: AHL_COMPLETIONS_PVT.complete_workorder
1574: (

Line 1576: p_init_msg_list => FND_API.G_TRUE,

1572: -- complete job
1573: AHL_COMPLETIONS_PVT.complete_workorder
1574: (
1575: p_api_version => 1.0 ,
1576: p_init_msg_list => FND_API.G_TRUE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579: p_default => FND_API.G_TRUE,
1580: p_module_type => 'OAF',

Line 1577: p_commit => FND_API.G_FALSE,

1573: AHL_COMPLETIONS_PVT.complete_workorder
1574: (
1575: p_api_version => 1.0 ,
1576: p_init_msg_list => FND_API.G_TRUE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579: p_default => FND_API.G_TRUE,
1580: p_module_type => 'OAF',
1581: x_return_status => x_return_status,

Line 1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1574: (
1575: p_api_version => 1.0 ,
1576: p_init_msg_list => FND_API.G_TRUE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579: p_default => FND_API.G_TRUE,
1580: p_module_type => 'OAF',
1581: x_return_status => x_return_status,
1582: x_msg_count => x_msg_count,

Line 1579: p_default => FND_API.G_TRUE,

1575: p_api_version => 1.0 ,
1576: p_init_msg_list => FND_API.G_TRUE,
1577: p_commit => FND_API.G_FALSE,
1578: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1579: p_default => FND_API.G_TRUE,
1580: p_module_type => 'OAF',
1581: x_return_status => x_return_status,
1582: x_msg_count => x_msg_count,
1583: x_msg_data => x_msg_data,

Line 1597: p_init_msg_list => FND_API.G_TRUE,

1593: l_prd_workorder_rec.STATUS_MEANING := p_WO_DETAILS_REC.Status;
1594: AHL_PRD_WORKORDER_PVT.update_job
1595: (
1596: p_api_version => 1.0 ,
1597: p_init_msg_list => FND_API.G_TRUE,
1598: p_commit => FND_API.G_FALSE,
1599: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1600: p_default => FND_API.G_TRUE,
1601: p_module_type => 'OAF',

Line 1598: p_commit => FND_API.G_FALSE,

1594: AHL_PRD_WORKORDER_PVT.update_job
1595: (
1596: p_api_version => 1.0 ,
1597: p_init_msg_list => FND_API.G_TRUE,
1598: p_commit => FND_API.G_FALSE,
1599: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1600: p_default => FND_API.G_TRUE,
1601: p_module_type => 'OAF',
1602: x_return_status => x_return_status,

Line 1599: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1595: (
1596: p_api_version => 1.0 ,
1597: p_init_msg_list => FND_API.G_TRUE,
1598: p_commit => FND_API.G_FALSE,
1599: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1600: p_default => FND_API.G_TRUE,
1601: p_module_type => 'OAF',
1602: x_return_status => x_return_status,
1603: x_msg_count => x_msg_count,

Line 1600: p_default => FND_API.G_TRUE,

1596: p_api_version => 1.0 ,
1597: p_init_msg_list => FND_API.G_TRUE,
1598: p_commit => FND_API.G_FALSE,
1599: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1600: p_default => FND_API.G_TRUE,
1601: p_module_type => 'OAF',
1602: x_return_status => x_return_status,
1603: x_msg_count => x_msg_count,
1604: x_msg_data => x_msg_data,

Line 1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

1633: occurrence_tbl_index integer;
1634: l_rowElementCount integer;
1635:
1636: BEGIN
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638: IF(p_OP_QaResults.QA_RESULT_TBL IS NULL OR p_OP_QaResults.QA_RESULT_TBL.COUNT < 1)THEN
1639: RETURN;
1640: END IF;
1641:

Line 1645: RAISE FND_API.G_EXC_ERROR;

1641:
1642: IF(p_OP_DETAILS_REC.IsQualityEnabled <> 'T')THEN
1643: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPQASUB_NALWD');
1644: FND_MSG_PUB.ADD;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647:
1648: get_qa_plan_results
1649: (

Line 1696: p_init_msg_list => FND_API.G_TRUE,

1692:
1693: AHL_QA_RESULTS_PVT.submit_qa_results
1694: (
1695: p_api_version => 1.0,
1696: p_init_msg_list => FND_API.G_TRUE,
1697: p_commit => FND_API.G_FALSE,
1698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1699: p_default => FND_API.G_FALSE,
1700: p_module_type => 'OAF',

Line 1697: p_commit => FND_API.G_FALSE,

1693: AHL_QA_RESULTS_PVT.submit_qa_results
1694: (
1695: p_api_version => 1.0,
1696: p_init_msg_list => FND_API.G_TRUE,
1697: p_commit => FND_API.G_FALSE,
1698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1699: p_default => FND_API.G_FALSE,
1700: p_module_type => 'OAF',
1701: x_return_status => x_return_status,

Line 1698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1694: (
1695: p_api_version => 1.0,
1696: p_init_msg_list => FND_API.G_TRUE,
1697: p_commit => FND_API.G_FALSE,
1698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1699: p_default => FND_API.G_FALSE,
1700: p_module_type => 'OAF',
1701: x_return_status => x_return_status,
1702: x_msg_count => x_msg_count,

Line 1699: p_default => FND_API.G_FALSE,

1695: p_api_version => 1.0,
1696: p_init_msg_list => FND_API.G_TRUE,
1697: p_commit => FND_API.G_FALSE,
1698: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1699: p_default => FND_API.G_FALSE,
1700: p_module_type => 'OAF',
1701: x_return_status => x_return_status,
1702: x_msg_count => x_msg_count,
1703: x_msg_data => x_msg_data,

Line 1740: x_return_status := FND_API.G_RET_STS_SUCCESS;

1736: l_prd_comp_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
1737:
1738:
1739: BEGIN
1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741: IF(p_Operations IS NULL OR p_Operations.COUNT < 1)THEN
1742: RETURN;
1743: END IF;
1744: j :=1;--keep this as 1 as thats how called package recognize things..

Line 1768: RAISE FND_API.G_EXC_ERROR;

1764: IF(p_Operations(i).ObjectVersionNumber IS NULL OR
1765: p_Operations(i).ObjectVersionNumber <> l_Operations(0).ObjectVersionNumber)THEN
1766: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: IF(l_Operations(0).IsUpdateEnabled <> 'T')THEN
1771: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1772: FND_MSG_PUB.ADD;

Line 1773: RAISE FND_API.G_EXC_ERROR;

1769: END IF;
1770: IF(l_Operations(0).IsUpdateEnabled <> 'T')THEN
1771: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1772: FND_MSG_PUB.ADD;
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775: process_op_quality
1776: (
1777: p_OP_DETAILS_REC => l_Operations(0),

Line 1784: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

1780: x_msg_count => x_msg_count,
1781: x_msg_data => x_msg_data
1782: );
1783: --DBMS_OUTPUT.put_line('x_return_status :i: ' || x_return_status);
1784: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSE
1787: OPEN get_current_obj_ver_csr(l_Operations(0).WorkorderOperationId);
1788: FETCH get_current_obj_ver_csr INTO l_Operations(0).ObjectVersionNumber;

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781: x_msg_data => x_msg_data
1782: );
1783: --DBMS_OUTPUT.put_line('x_return_status :i: ' || x_return_status);
1784: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSE
1787: OPEN get_current_obj_ver_csr(l_Operations(0).WorkorderOperationId);
1788: FETCH get_current_obj_ver_csr INTO l_Operations(0).ObjectVersionNumber;
1789: CLOSE get_current_obj_ver_csr;

Line 1798: RAISE FND_API.G_EXC_ERROR;

1794: OR p_Operations(i).ActualEndDate IS NOT NULL)THEN
1795: IF(p_Operations(i).StatusCode NOT IN ('1','2'))THEN
1796: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800: ----DBMS_OUTPUT.put_line('op :i:statusCode: ' || p_Operations(i).StatusCode);
1801: l_prd_operation_tbl(j).operation_sequence_num := l_Operations(0).OperationSequenceNumber;
1802: l_prd_operation_tbl(j).workorder_id := l_Operations(0).WorkorderId;

Line 1828: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

1824: x_msg_count => x_msg_count,
1825: x_msg_data => x_msg_data,
1826: P_x_operation_tbl => l_prd_comp_operation_tbl
1827: );
1828: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831: l_prd_operation_tbl(j).actual_start_date := l_prd_comp_operation_tbl(0).Actual_Start_Date;
1832: l_prd_operation_tbl(j).actual_end_date := l_prd_comp_operation_tbl(0).Actual_End_Date;

Line 1829: RAISE FND_API.G_EXC_ERROR;

1825: x_msg_data => x_msg_data,
1826: P_x_operation_tbl => l_prd_comp_operation_tbl
1827: );
1828: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;
1831: l_prd_operation_tbl(j).actual_start_date := l_prd_comp_operation_tbl(0).Actual_Start_Date;
1832: l_prd_operation_tbl(j).actual_end_date := l_prd_comp_operation_tbl(0).Actual_End_Date;
1833: END IF;

Line 1844: p_init_msg_list => FND_API.G_TRUE,

1840: ----DBMS_OUTPUT.put_line('op :i:statusCode: processing operations : ' || l_prd_operation_tbl.COUNT);
1841: AHL_PRD_OPERATIONS_PVT.PROCESS_OPERATIONS
1842: (
1843: p_api_version => 1.0 ,
1844: p_init_msg_list => FND_API.G_TRUE,
1845: p_commit => FND_API.G_FALSE,
1846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1847: p_default => FND_API.G_TRUE,
1848: p_module_type => 'OAF',

Line 1845: p_commit => FND_API.G_FALSE,

1841: AHL_PRD_OPERATIONS_PVT.PROCESS_OPERATIONS
1842: (
1843: p_api_version => 1.0 ,
1844: p_init_msg_list => FND_API.G_TRUE,
1845: p_commit => FND_API.G_FALSE,
1846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1847: p_default => FND_API.G_TRUE,
1848: p_module_type => 'OAF',
1849: p_wip_mass_load_flag => 'Y',

Line 1846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1842: (
1843: p_api_version => 1.0 ,
1844: p_init_msg_list => FND_API.G_TRUE,
1845: p_commit => FND_API.G_FALSE,
1846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1847: p_default => FND_API.G_TRUE,
1848: p_module_type => 'OAF',
1849: p_wip_mass_load_flag => 'Y',
1850: x_return_status => x_return_status,

Line 1847: p_default => FND_API.G_TRUE,

1843: p_api_version => 1.0 ,
1844: p_init_msg_list => FND_API.G_TRUE,
1845: p_commit => FND_API.G_FALSE,
1846: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1847: p_default => FND_API.G_TRUE,
1848: p_module_type => 'OAF',
1849: p_wip_mass_load_flag => 'Y',
1850: x_return_status => x_return_status,
1851: x_msg_count => x_msg_count,

Line 1868: x_return_status := FND_API.G_RET_STS_SUCCESS;

1864: x_msg_count OUT NOCOPY NUMBER,
1865: x_msg_data OUT NOCOPY VARCHAR2
1866: ) IS
1867: BEGIN
1868: x_return_status := FND_API.G_RET_STS_SUCCESS;
1869: IF(p_MaterialRequirementDetails IS NULL OR p_MaterialRequirementDetails.COUNT < 1)THEN
1870: RETURN;
1871: END IF;
1872: END process_mtl_requirements;

Line 1896: x_return_status := FND_API.G_RET_STS_SUCCESS;

1892: l_rowElementCount integer;
1893:
1894:
1895: BEGIN
1896: x_return_status := FND_API.G_RET_STS_SUCCESS;
1897: IF(p_WO_QaResults.QA_RESULT_TBL IS NULL OR p_WO_QaResults.QA_RESULT_TBL.COUNT < 1)THEN
1898: RETURN;
1899: END IF;
1900: IF(p_WO_DETAILS_REC.IsQualityEnabled <> 'T')THEN

Line 1903: RAISE FND_API.G_EXC_ERROR;

1899: END IF;
1900: IF(p_WO_DETAILS_REC.IsQualityEnabled <> 'T')THEN
1901: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WOQASUB_NALWD');
1902: FND_MSG_PUB.ADD;
1903: RAISE FND_API.G_EXC_ERROR;
1904: END IF;
1905:
1906: get_qa_plan_results
1907: (

Line 1952: p_init_msg_list => FND_API.G_TRUE,

1948:
1949: AHL_QA_RESULTS_PVT.submit_qa_results
1950: (
1951: p_api_version => 1.0,
1952: p_init_msg_list => FND_API.G_TRUE,
1953: p_commit => FND_API.G_FALSE,
1954: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1955: p_default => FND_API.G_FALSE,
1956: p_module_type => 'OAF',

Line 1953: p_commit => FND_API.G_FALSE,

1949: AHL_QA_RESULTS_PVT.submit_qa_results
1950: (
1951: p_api_version => 1.0,
1952: p_init_msg_list => FND_API.G_TRUE,
1953: p_commit => FND_API.G_FALSE,
1954: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1955: p_default => FND_API.G_FALSE,
1956: p_module_type => 'OAF',
1957: x_return_status => x_return_status,

Line 1954: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1950: (
1951: p_api_version => 1.0,
1952: p_init_msg_list => FND_API.G_TRUE,
1953: p_commit => FND_API.G_FALSE,
1954: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1955: p_default => FND_API.G_FALSE,
1956: p_module_type => 'OAF',
1957: x_return_status => x_return_status,
1958: x_msg_count => x_msg_count,

Line 1955: p_default => FND_API.G_FALSE,

1951: p_api_version => 1.0,
1952: p_init_msg_list => FND_API.G_TRUE,
1953: p_commit => FND_API.G_FALSE,
1954: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1955: p_default => FND_API.G_FALSE,
1956: p_module_type => 'OAF',
1957: x_return_status => x_return_status,
1958: x_msg_count => x_msg_count,
1959: x_msg_data => x_msg_data,

Line 1987: x_return_status := FND_API.G_RET_STS_SUCCESS;

1983: ) IS
1984: l_res_txns_tbl AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;
1985: j INTEGER;
1986: BEGIN
1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988: IF(p_ResourceTransactions IS NULL OR p_ResourceTransactions.COUNT < 1)THEN
1989: RETURN;
1990: END IF;
1991: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1991: x_return_status := FND_API.G_RET_STS_SUCCESS;

1987: x_return_status := FND_API.G_RET_STS_SUCCESS;
1988: IF(p_ResourceTransactions IS NULL OR p_ResourceTransactions.COUNT < 1)THEN
1989: RETURN;
1990: END IF;
1991: x_return_status := FND_API.G_RET_STS_SUCCESS;
1992: j :=0;
1993: FOR i IN p_ResourceTransactions.FIRST..p_ResourceTransactions.LAST LOOP
1994: IF((p_ResourceTransactions(i).StartTime IS NOT NULL OR
1995: p_ResourceTransactions(i).EndTime IS NOT NULL OR

Line 2024: RAISE FND_API.G_EXC_ERROR;

2020: IF(l_res_txns_tbl IS NOT NULL AND l_res_txns_tbl.COUNT > 0)THEN
2021: IF(p_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
2022: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_NALWD');
2023: FND_MSG_PUB.ADD;
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;
2026: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns
2027: (
2028: p_api_version => 1.0 ,

Line 2029: p_init_msg_list => FND_API.G_TRUE,

2025: END IF;
2026: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns
2027: (
2028: p_api_version => 1.0 ,
2029: p_init_msg_list => FND_API.G_TRUE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: p_default => FND_API.G_TRUE,
2033: p_module_type => 'BPEL',

Line 2030: p_commit => FND_API.G_FALSE,

2026: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns
2027: (
2028: p_api_version => 1.0 ,
2029: p_init_msg_list => FND_API.G_TRUE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: p_default => FND_API.G_TRUE,
2033: p_module_type => 'BPEL',
2034: x_return_status => x_return_status,

Line 2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2027: (
2028: p_api_version => 1.0 ,
2029: p_init_msg_list => FND_API.G_TRUE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: p_default => FND_API.G_TRUE,
2033: p_module_type => 'BPEL',
2034: x_return_status => x_return_status,
2035: x_msg_count => x_msg_count,

Line 2032: p_default => FND_API.G_TRUE,

2028: p_api_version => 1.0 ,
2029: p_init_msg_list => FND_API.G_TRUE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: p_default => FND_API.G_TRUE,
2033: p_module_type => 'BPEL',
2034: x_return_status => x_return_status,
2035: x_msg_count => x_msg_count,
2036: x_msg_data => x_msg_data,

Line 2045: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

2041:
2042: PROCEDURE process_workorder
2043: (
2044: p_api_version IN NUMBER := 1.0,
2045: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2046: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2047: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2048: p_default IN VARCHAR2 := FND_API.G_FALSE,
2049: p_module_type IN VARCHAR2,

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

2042: PROCEDURE process_workorder
2043: (
2044: p_api_version IN NUMBER := 1.0,
2045: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2046: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2047: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2048: p_default IN VARCHAR2 := FND_API.G_FALSE,
2049: p_module_type IN VARCHAR2,
2050: p_userid IN VARCHAR2 := NULL,

Line 2047: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2043: (
2044: p_api_version IN NUMBER := 1.0,
2045: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2046: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2047: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2048: p_default IN VARCHAR2 := FND_API.G_FALSE,
2049: p_module_type IN VARCHAR2,
2050: p_userid IN VARCHAR2 := NULL,
2051: p_WO_DETAILS_REC IN WO_DETAILS_REC_TYPE,

Line 2048: p_default IN VARCHAR2 := FND_API.G_FALSE,

2044: p_api_version IN NUMBER := 1.0,
2045: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2046: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2047: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2048: p_default IN VARCHAR2 := FND_API.G_FALSE,
2049: p_module_type IN VARCHAR2,
2050: p_userid IN VARCHAR2 := NULL,
2051: p_WO_DETAILS_REC IN WO_DETAILS_REC_TYPE,
2052: p_Operations IN OP_ALL_DETAILS_TBL,

Line 2071: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN

2067: WHERE WORKORDER_ID = p_WotkorderId;
2068:
2069: BEGIN
2070: -- Standard call to check for call compatibility
2071: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2073: END IF;
2074:
2075: SAVEPOINT PROCESS_WORKORDER;

Line 2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2068:
2069: BEGIN
2070: -- Standard call to check for call compatibility
2071: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
2072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2073: END IF;
2074:
2075: SAVEPOINT PROCESS_WORKORDER;
2076:

Line 2077: IF FND_API.To_Boolean(p_init_msg_list) THEN

2073: END IF;
2074:
2075: SAVEPOINT PROCESS_WORKORDER;
2076:
2077: IF FND_API.To_Boolean(p_init_msg_list) THEN
2078: FND_MSG_PUB.Initialize;
2079: END IF;
2080: -- Initialize API return status to success
2081: x_return_status := init_user_and_role(p_userid);

Line 2096: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2092: x_WO_DETAILS_REC => l_WO_DETAILS_REC
2093: );
2094: --AHL_DEBUG_PUB.debug( 'l_WO_DETAILS_REC.ObjectVersionNumber : '||l_WO_DETAILS_REC.ObjectVersionNumber);
2095: --AHL_DEBUG_PUB.debug( 'p_WO_DETAILS_REC.ObjectVersionNumber : '||p_WO_DETAILS_REC.ObjectVersionNumber);
2096: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2097: RAISE FND_API.G_EXC_ERROR;
2098: END IF;
2099: IF(p_WO_DETAILS_REC.ObjectVersionNumber IS NULL OR
2100: p_WO_DETAILS_REC.ObjectVersionNumber <> l_WO_DETAILS_REC.ObjectVersionNumber)THEN

Line 2097: RAISE FND_API.G_EXC_ERROR;

2093: );
2094: --AHL_DEBUG_PUB.debug( 'l_WO_DETAILS_REC.ObjectVersionNumber : '||l_WO_DETAILS_REC.ObjectVersionNumber);
2095: --AHL_DEBUG_PUB.debug( 'p_WO_DETAILS_REC.ObjectVersionNumber : '||p_WO_DETAILS_REC.ObjectVersionNumber);
2096: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2097: RAISE FND_API.G_EXC_ERROR;
2098: END IF;
2099: IF(p_WO_DETAILS_REC.ObjectVersionNumber IS NULL OR
2100: p_WO_DETAILS_REC.ObjectVersionNumber <> l_WO_DETAILS_REC.ObjectVersionNumber)THEN
2101: --AHL_DEBUG_PUB.debug( 'Object Version Numbers are not same');

Line 2104: RAISE FND_API.G_EXC_ERROR;

2100: p_WO_DETAILS_REC.ObjectVersionNumber <> l_WO_DETAILS_REC.ObjectVersionNumber)THEN
2101: --AHL_DEBUG_PUB.debug( 'Object Version Numbers are not same');
2102: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2103: FND_MSG_PUB.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;
2106: process_turnover_notes(
2107: p_WO_DETAILS_REC => l_WO_DETAILS_REC,
2108: p_TurnoverNotes => p_TurnoverNotes,

Line 2114: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2110: x_msg_count => x_msg_count,
2111: x_msg_data => x_msg_data
2112: );
2113:
2114: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117:
2118: process_res_txns(

Line 2115: RAISE FND_API.G_EXC_ERROR;

2111: x_msg_data => x_msg_data
2112: );
2113:
2114: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2115: RAISE FND_API.G_EXC_ERROR;
2116: END IF;
2117:
2118: process_res_txns(
2119: p_WO_DETAILS_REC => l_WO_DETAILS_REC,

Line 2125: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2121: x_return_status => x_return_status,
2122: x_msg_count => x_msg_count,
2123: x_msg_data => x_msg_data
2124: );
2125: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2126: RAISE FND_API.G_EXC_ERROR;
2127: END IF;
2128:
2129: process_op_details(

Line 2126: RAISE FND_API.G_EXC_ERROR;

2122: x_msg_count => x_msg_count,
2123: x_msg_data => x_msg_data
2124: );
2125: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2126: RAISE FND_API.G_EXC_ERROR;
2127: END IF;
2128:
2129: process_op_details(
2130: p_WO_DETAILS_REC => l_WO_DETAILS_REC,

Line 2136: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2132: x_return_status => x_return_status,
2133: x_msg_count => x_msg_count,
2134: x_msg_data => x_msg_data
2135: );
2136: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2137: RAISE FND_API.G_EXC_ERROR;
2138: END IF;
2139:
2140: process_wo_quality(

Line 2137: RAISE FND_API.G_EXC_ERROR;

2133: x_msg_count => x_msg_count,
2134: x_msg_data => x_msg_data
2135: );
2136: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2137: RAISE FND_API.G_EXC_ERROR;
2138: END IF;
2139:
2140: process_wo_quality(
2141: p_WO_DETAILS_REC => l_WO_DETAILS_REC,

Line 2147: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2143: x_return_status => x_return_status,
2144: x_msg_count => x_msg_count,
2145: x_msg_data => x_msg_data
2146: );
2147: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2148: RAISE FND_API.G_EXC_ERROR;
2149: ELSE
2150: OPEN get_current_obj_ver_csr(l_WO_DETAILS_REC.WorkorderId);
2151: FETCH get_current_obj_ver_csr INTO l_WO_DETAILS_REC.ObjectVersionNumber;

Line 2148: RAISE FND_API.G_EXC_ERROR;

2144: x_msg_count => x_msg_count,
2145: x_msg_data => x_msg_data
2146: );
2147: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2148: RAISE FND_API.G_EXC_ERROR;
2149: ELSE
2150: OPEN get_current_obj_ver_csr(l_WO_DETAILS_REC.WorkorderId);
2151: FETCH get_current_obj_ver_csr INTO l_WO_DETAILS_REC.ObjectVersionNumber;
2152: CLOSE get_current_obj_ver_csr;

Line 2164: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

2160: x_return_status => x_return_status,
2161: x_msg_count => x_msg_count,
2162: x_msg_data => x_msg_data
2163: );
2164: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167:
2168: IF FND_API.to_boolean(p_commit) THEN

Line 2165: RAISE FND_API.G_EXC_ERROR;

2161: x_msg_count => x_msg_count,
2162: x_msg_data => x_msg_data
2163: );
2164: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167:
2168: IF FND_API.to_boolean(p_commit) THEN
2169: COMMIT;

Line 2168: IF FND_API.to_boolean(p_commit) THEN

2164: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167:
2168: IF FND_API.to_boolean(p_commit) THEN
2169: COMMIT;
2170: END IF;
2171:
2172: EXCEPTION

Line 2173: WHEN FND_API.G_EXC_ERROR THEN

2169: COMMIT;
2170: END IF;
2171:
2172: EXCEPTION
2173: WHEN FND_API.G_EXC_ERROR THEN
2174: ROLLBACK TO PROCESS_WORKORDER;
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: x_msg_count := FND_MSG_PUB.count_msg;
2177:

Line 2175: x_return_status := FND_API.G_RET_STS_ERROR;

2171:
2172: EXCEPTION
2173: WHEN FND_API.G_EXC_ERROR THEN
2174: ROLLBACK TO PROCESS_WORKORDER;
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: x_msg_count := FND_MSG_PUB.count_msg;
2177:
2178:
2179: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2176: x_msg_count := FND_MSG_PUB.count_msg;
2177:
2178:
2179: x_msg_data := GET_MSG_DATA(x_msg_count);
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO PROCESS_WORKORDER;
2182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2183: x_msg_count := FND_MSG_PUB.count_msg;
2184: x_msg_data := GET_MSG_DATA(x_msg_count);

Line 2182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2178:
2179: x_msg_data := GET_MSG_DATA(x_msg_count);
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO PROCESS_WORKORDER;
2182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2183: x_msg_count := FND_MSG_PUB.count_msg;
2184: x_msg_data := GET_MSG_DATA(x_msg_count);
2185: WHEN OTHERS THEN
2186: ROLLBACK TO PROCESS_WORKORDER;

Line 2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2183: x_msg_count := FND_MSG_PUB.count_msg;
2184: x_msg_data := GET_MSG_DATA(x_msg_count);
2185: WHEN OTHERS THEN
2186: ROLLBACK TO PROCESS_WORKORDER;
2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2188:
2189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2190: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
2191: p_procedure_name => l_api_name,

Line 2212: p_encoded => fnd_api.g_false);

2208: END IF;
2209: IF (p_msg_count = 1) then
2210: FND_MSG_PUB.count_and_get( p_count => l_msg_count,
2211: p_data => l_temp_msg_data,
2212: p_encoded => fnd_api.g_false);
2213: l_msg_data := '(' || 1 || ')' || l_temp_msg_data;
2214: ELSE
2215: IF (l_msg_count > 0) THEN
2216: FOR i IN 1..l_msg_count LOOP