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

Line 12: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

8: ------------------------------------------------------
9:
10: procedure add_exist_work_order(
11: p_api_version IN NUMBER := 1.0
12: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: ,p_record_version_number IN NUMBER := NULL
16: ,x_return_status OUT NOCOPY VARCHAR2

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

9:
10: procedure add_exist_work_order(
11: p_api_version IN NUMBER := 1.0
12: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: ,p_record_version_number IN NUMBER := NULL
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,x_msg_count OUT NOCOPY NUMBER

Line 14: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

10: procedure add_exist_work_order(
11: p_api_version IN NUMBER := 1.0
12: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
14: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
15: ,p_record_version_number IN NUMBER := NULL
16: ,x_return_status OUT NOCOPY VARCHAR2
17: ,x_msg_count OUT NOCOPY NUMBER
18: ,x_msg_data OUT NOCOPY VARCHAR2

Line 125: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

121: SAVEPOINT add_exist_work_order;
122:
123: eam_debug.init_err_stack('eam_workorders_jsp.add_exist_work_order');
124:
125: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
126: p_api_version,
127: l_api_name,
128: g_pkg_name)
129: THEN

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: p_api_version,
127: l_api_name,
128: g_pkg_name)
129: THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132:
133: IF FND_API.TO_BOOLEAN(p_init_msg_list)
134: THEN

Line 133: IF FND_API.TO_BOOLEAN(p_init_msg_list)

129: THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132:
133: IF FND_API.TO_BOOLEAN(p_init_msg_list)
134: THEN
135: FND_MSG_PUB.initialize;
136: END IF;
137:

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

137:
138: /* get output directory path from database */
139: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
140:
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:
143:
144: l_workorder_rec.header_id := p_wip_entity_id;
145: l_workorder_rec.batch_id := 1;

Line 234: RAISE FND_API.G_EXC_ERROR;

230: /*End of update wo ***********/
231:
232: if(x_return_status<>'S') then
233: ROLLBACK TO add_exist_work_order;
234: RAISE FND_API.G_EXC_ERROR;
235: end if;
236:
237:
238: EXCEPTION

Line 240: FND_API.G_EXC_UNEXPECTED_ERROR THEN

236:
237:
238: EXCEPTION
239: WHEN
240: FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: IF p_commit = FND_API.G_TRUE THEN
242: ROLLBACK TO add_exist_work_order;
243: END IF;
244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',

Line 241: IF p_commit = FND_API.G_TRUE THEN

237:
238: EXCEPTION
239: WHEN
240: FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: IF p_commit = FND_API.G_TRUE THEN
242: ROLLBACK TO add_exist_work_order;
243: END IF;
244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
245: p_procedure_name => EAM_DEBUG.G_err_stack);

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: ROLLBACK TO add_exist_work_order;
243: END IF;
244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
245: p_procedure_name => EAM_DEBUG.G_err_stack);
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: WHEN FND_API.G_EXC_ERROR THEN
248: IF p_commit = FND_API.G_TRUE THEN
249: ROLLBACK TO add_exist_work_order;
250: END IF;

Line 247: WHEN FND_API.G_EXC_ERROR THEN

243: END IF;
244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
245: p_procedure_name => EAM_DEBUG.G_err_stack);
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: WHEN FND_API.G_EXC_ERROR THEN
248: IF p_commit = FND_API.G_TRUE THEN
249: ROLLBACK TO add_exist_work_order;
250: END IF;
251:

Line 248: IF p_commit = FND_API.G_TRUE THEN

244: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
245: p_procedure_name => EAM_DEBUG.G_err_stack);
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: WHEN FND_API.G_EXC_ERROR THEN
248: IF p_commit = FND_API.G_TRUE THEN
249: ROLLBACK TO add_exist_work_order;
250: END IF;
251:
252: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: END IF;
251:
252: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',
253: p_procedure_name => EAM_DEBUG.G_err_stack);
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:
256: WHEN OTHERS THEN -- all dml excpetion
257: IF p_commit = FND_API.G_TRUE THEN
258: ROLLBACK TO add_exist_work_order;

Line 257: IF p_commit = FND_API.G_TRUE THEN

253: p_procedure_name => EAM_DEBUG.G_err_stack);
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255:
256: WHEN OTHERS THEN -- all dml excpetion
257: IF p_commit = FND_API.G_TRUE THEN
258: ROLLBACK TO add_exist_work_order;
259: END IF;
260:
261: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.ADD_EXIST_WORK_ORDER',

Line 350: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

346: -- so jsp pages can get them.
347: -------------------------------------------------------------------------
348: procedure Complete_Workorder
349: ( p_api_version IN NUMBER := 1.0
350: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
351: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
352: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
353: ,p_record_version_number IN NUMBER := NULL
354: ,x_return_status OUT NOCOPY VARCHAR2

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

347: -------------------------------------------------------------------------
348: procedure Complete_Workorder
349: ( p_api_version IN NUMBER := 1.0
350: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
351: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
352: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
353: ,p_record_version_number IN NUMBER := NULL
354: ,x_return_status OUT NOCOPY VARCHAR2
355: ,x_msg_count OUT NOCOPY NUMBER

Line 352: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

348: procedure Complete_Workorder
349: ( p_api_version IN NUMBER := 1.0
350: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
351: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
352: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
353: ,p_record_version_number IN NUMBER := NULL
354: ,x_return_status OUT NOCOPY VARCHAR2
355: ,x_msg_count OUT NOCOPY NUMBER
356: ,x_msg_data OUT NOCOPY VARCHAR2

Line 441: IF p_commit = FND_API.G_TRUE THEN

437:
438:
439: BEGIN
440:
441: IF p_commit = FND_API.G_TRUE THEN
442: SAVEPOINT complete_workorder;
443: END IF;
444:
445: eam_debug.init_err_stack('eam_workorders_jsp.complete_workorder');

Line 447: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

443: END IF;
444:
445: eam_debug.init_err_stack('eam_workorders_jsp.complete_workorder');
446:
447: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
448: p_api_version,
449: l_api_name,
450: g_pkg_name)
451: THEN

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448: p_api_version,
449: l_api_name,
450: g_pkg_name)
451: THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: IF FND_API.TO_BOOLEAN(p_init_msg_list)
456: THEN

Line 455: IF FND_API.TO_BOOLEAN(p_init_msg_list)

451: THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454:
455: IF FND_API.TO_BOOLEAN(p_init_msg_list)
456: THEN
457: FND_MSG_PUB.initialize;
458: END IF;
459:

Line 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456: THEN
457: FND_MSG_PUB.initialize;
458: END IF;
459:
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: -- check if data is stale or not
463: -- using last_update_date as indicator
464: BEGIN

Line 473: x_return_status := FND_API.G_RET_STS_ERROR;

469: FOR UPDATE;
470:
471: IF l_db_last_update_date <> p_stored_last_update_date THEN
472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: END IF;
475:
476: IF ( (p_transaction_type = 1 AND l_db_status <> 3) or
477: (p_transaction_type = 2 and (l_db_status <> 4 and l_db_status <> 5)) ) THEN -- 5??

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475:
476: IF ( (p_transaction_type = 1 AND l_db_status <> 3) or
477: (p_transaction_type = 2 and (l_db_status <> 4 and l_db_status <> 5)) ) THEN -- 5??
478: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_COMP_WRONG_STATUS');
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481:
482: EXCEPTION WHEN OTHERS THEN
483: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: END IF;
481:
482: EXCEPTION WHEN OTHERS THEN
483: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: END;
486:
487: --dgupta: default actual start and end dates from the last completion txn.
488: --Note: This is redundant as we are not using the actual start and end for

Line 546: x_return_status := FND_API.G_RET_STS_ERROR;

542: if ((p_actual_start_date is not null) and (p_actual_duration is not null)) then
543: -- Start Fix for Bug 2165293
544: if (p_actual_duration < 0) then
545: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NEGATIVE_DURATION');
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: end if;
548: -- End Fix for Bug 2165293
549:
550: if (p_actual_end_date > sysdate) then

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: -- End Fix for Bug 2165293
549:
550: if (p_actual_end_date > sysdate) then
551: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_END_LATER_THAN_TODAY');
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: end if;
554:
555:
556:

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564: )then
565: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_COMPL_DATES_INVALID',
566: p_token1=>'MIN_OP_DATE',p_value1=>TO_CHAR(l_min_compl_op_date,'dd-MON-yyyy HH24:MI:SS'),p_token2=>'MAX_OP_DATE'
567: ,p_value2=>TO_CHAR(l_max_compl_op_date,'dd-MON-yyyy HH24:MI:SS'));
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: end if;
570:
571: -- if p_actual_start_date is close to l_min_compl_op_date by a min or p_actual_end_date is close to l_max_compl_op_date
572: if (p_actual_end_date < l_max_compl_op_date) then

Line 598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

594: and mlu.meaning = p_reconciliation_code;
595: end if;
596: EXCEPTION WHEN OTHERS THEN
597: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RECONCILIATION_CODE_INV');
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: END;
600:
601: if( p_shutdown_start_date > p_shutdown_end_date) then
602: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUTDOWN_DATE_BAD');

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

599: END;
600:
601: if( p_shutdown_start_date > p_shutdown_end_date) then
602: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_SHUTDOWN_DATE_BAD');
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: end if;
605:
606: /* I. As part of IB changes, Completing to a subinventory is always optional
607: II. Even Asset WOs can be completed to subinventory

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625:
626: exception
627: when no_data_found then
628: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_ITEM_NOT_ASSIGNED');
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: end;
631:
632: else
633:

Line 642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

638: and msn.current_status = 4;
639: exception
640: when no_data_found then
641: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_OUT_OF_STORES');
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: end;
644:
645: end if;
646:

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

678: end if;
679: exception
680: when no_data_found then
681: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_SUBINV');
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: return;
684: end;
685: end if;
686:

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: when no_data_found then
712: -- x_error_flag := 1;
713: -- x_error_mssg := 'EAM_RET_MAT_INVALID_LOCATOR';
714: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_LOCATOR');
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: return;
717: end;
718: end if;
719:

Line 742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

738: if(l_locator_id IS NULL) then
739: /* l_error_flag := 1;
740: l_error_mssg := 'EAM_RET_MAT_LOCATOR_NEEDED'; */
741: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_NEEDED');
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: return;
744: end if;
745: elsif(l_locator_ctrl = 1) then -- If the locator control is NOControl
746: if(l_locator_id IS NOT NULL) then

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: if(l_locator_id IS NOT NULL) then
747: /* l_error_flag := 1;
748: l_error_mssg := 'EAM_RET_MAT_LOCATOR_RESTRICTED'; */
749: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_RESTRICTED');
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: return;
752: end if;
753: end if; -- end of locator_control checkif
754:

Line 769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

765: and organization_id = p_org_id;
766: exception
767: when NO_DATA_FOUND then
768: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: end;
771: else
772: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
770: end;
771: else
772: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: end if;
775: else
776: if(p_lot is not null) then
777: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

774: end if;
775: else
776: if(p_lot is not null) then
777: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
779: end if;
780: end if; -- end of lot entry check
781:
782: -- end if; -- end of completion_info check

Line 792: (p_encoded => FND_API.G_FALSE,

788: -- if validate not passed then raise error
789: l_msg_count := FND_MSG_PUB.count_msg;
790: IF l_msg_count = 1 THEN
791: eam_execution_jsp.Get_Messages
792: (p_encoded => FND_API.G_FALSE,
793: p_msg_index => 1,
794: p_msg_count => l_msg_count,
795: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
796: p_data => l_data,

Line 795: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),

791: eam_execution_jsp.Get_Messages
792: (p_encoded => FND_API.G_FALSE,
793: p_msg_index => 1,
794: p_msg_count => l_msg_count,
795: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
796: p_data => l_data,
797: p_msg_index_out => l_msg_index_out);
798: x_msg_count := l_msg_count;
799: x_msg_data := l_msg_data;

Line 805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

801: x_msg_count := l_msg_count;
802: END IF;
803:
804: IF l_msg_count > 0 THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808:
809: BEGIN

Line 806: RAISE FND_API.G_EXC_ERROR;

802: END IF;
803:
804: IF l_msg_count > 0 THEN
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808:
809: BEGIN
810: /* call processing logic */

Line 850: x_return_status := FND_API.G_RET_STS_ERROR;

846: );
847:
848: IF (l_err_number = 2) THEN
849: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: ELSIF (l_err_number > 0 ) THEN
852: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;

Line 853: x_return_status := FND_API.G_RET_STS_ERROR;

849: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: ELSIF (l_err_number > 0 ) THEN
852: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
853: x_return_status := FND_API.G_RET_STS_ERROR;
854: END IF;
855:
856: EXCEPTION WHEN OTHERS THEN
857: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855:
856: EXCEPTION WHEN OTHERS THEN
857: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',
858: p_token1 => 'TEXT', p_value1 => sqlerrm);
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: END;
861:
862:
863: -- if DML not passed then raise error

Line 867: (p_encoded => FND_API.G_FALSE,

863: -- if DML not passed then raise error
864: l_msg_count := FND_MSG_PUB.count_msg;
865: IF l_msg_count = 1 THEN
866: eam_execution_jsp.Get_Messages
867: (p_encoded => FND_API.G_FALSE,
868: p_msg_index => 1,
869: p_msg_count => l_msg_count,
870: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
871: p_data => l_data,

Line 870: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

866: eam_execution_jsp.Get_Messages
867: (p_encoded => FND_API.G_FALSE,
868: p_msg_index => 1,
869: p_msg_count => l_msg_count,
870: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
871: p_data => l_data,
872: p_msg_index_out => l_msg_index_out);
873: x_msg_count := l_msg_count;
874: x_msg_data := l_msg_data;

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

876: x_msg_count := l_msg_count;
877: END IF;
878:
879: IF l_msg_count > 0 THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883:
884:

Line 881: RAISE FND_API.G_EXC_ERROR;

877: END IF;
878:
879: IF l_msg_count > 0 THEN
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883:
884:
885: IF FND_API.TO_BOOLEAN(P_COMMIT)

Line 885: IF FND_API.TO_BOOLEAN(P_COMMIT)

881: RAISE FND_API.G_EXC_ERROR;
882: END IF;
883:
884:
885: IF FND_API.TO_BOOLEAN(P_COMMIT)
886: THEN
887: COMMIT WORK;
888: END IF;
889:

Line 890: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

886: THEN
887: COMMIT WORK;
888: END IF;
889:
890: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: IF p_commit = FND_API.G_TRUE THEN
892: ROLLBACK TO complete_workorder;
893: END IF;
894:

Line 891: IF p_commit = FND_API.G_TRUE THEN

887: COMMIT WORK;
888: END IF;
889:
890: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: IF p_commit = FND_API.G_TRUE THEN
892: ROLLBACK TO complete_workorder;
893: END IF;
894:
895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

Line 897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

893: END IF;
894:
895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
896: p_procedure_name => EAM_DEBUG.G_err_stack);
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF p_commit = FND_API.G_TRUE THEN
900: ROLLBACK TO complete_workorder;
901: END IF;

Line 898: WHEN FND_API.G_EXC_ERROR THEN

894:
895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
896: p_procedure_name => EAM_DEBUG.G_err_stack);
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF p_commit = FND_API.G_TRUE THEN
900: ROLLBACK TO complete_workorder;
901: END IF;
902:

Line 899: IF p_commit = FND_API.G_TRUE THEN

895: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
896: p_procedure_name => EAM_DEBUG.G_err_stack);
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF p_commit = FND_API.G_TRUE THEN
900: ROLLBACK TO complete_workorder;
901: END IF;
902:
903: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

Line 905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

901: END IF;
902:
903: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
904: p_procedure_name => EAM_DEBUG.G_err_stack);
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: WHEN OTHERS THEN
907: IF p_commit = FND_API.G_TRUE THEN
908: ROLLBACK TO complete_workorder;
909: END IF;

Line 907: IF p_commit = FND_API.G_TRUE THEN

903: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
904: p_procedure_name => EAM_DEBUG.G_err_stack);
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: WHEN OTHERS THEN
907: IF p_commit = FND_API.G_TRUE THEN
908: ROLLBACK TO complete_workorder;
909: END IF;
910:
911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

Line 913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

909: END IF;
910:
911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
912: p_procedure_name => EAM_DEBUG.G_err_stack);
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: END Complete_Workorder;
915:
916:
917:

Line 928: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

924: --anjgupta Changes for IB and Transactable Assets Project in R12
925: -------------------------------------------------------------------------------
926: procedure create_ez_work_order
927: ( p_api_version IN NUMBER := 1.0
928: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
929: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
930: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
931: ,p_record_version_number IN NUMBER := NULL
932: ,x_return_status OUT NOCOPY VARCHAR2

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

925: -------------------------------------------------------------------------------
926: procedure create_ez_work_order
927: ( p_api_version IN NUMBER := 1.0
928: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
929: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
930: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
931: ,p_record_version_number IN NUMBER := NULL
932: ,x_return_status OUT NOCOPY VARCHAR2
933: ,x_msg_count OUT NOCOPY NUMBER

Line 930: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

926: procedure create_ez_work_order
927: ( p_api_version IN NUMBER := 1.0
928: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
929: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
930: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
931: ,p_record_version_number IN NUMBER := NULL
932: ,x_return_status OUT NOCOPY VARCHAR2
933: ,x_msg_count OUT NOCOPY NUMBER
934: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1215: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1211: SAVEPOINT create_easy_work_order;
1212:
1213: eam_debug.init_err_stack('eam_workorders_jsp.create_easy_work_order');
1214:
1215: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1216: p_api_version,
1217: l_api_name,
1218: g_pkg_name)
1219: THEN

Line 1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1216: p_api_version,
1217: l_api_name,
1218: g_pkg_name)
1219: THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:
1223: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1224: THEN

Line 1223: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1219: THEN
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:
1223: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1224: THEN
1225: FND_MSG_PUB.initialize;
1226: END IF;
1227:

Line 1231: x_return_status := FND_API.G_RET_STS_SUCCESS;

1227:
1228: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
1229:
1230:
1231: x_return_status := FND_API.G_RET_STS_SUCCESS;
1232:
1233: -- Assign user defined status passed to API to a local variable
1234: l_user_defined_status_type := p_status_type;
1235:

Line 1280: x_return_status := FND_API.G_RET_STS_ERROR;

1276:
1277: if((l_eam_item_type=1) and (l_orig_wo_status=7) and (l_status_type in (1,3,6,17)) and (asset_status<>3)) then
1278: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEACTIVATE_CANNOT_UNCANCEL',
1279: p_token1 => 'NAME', p_value1 => p_wip_entity_name);
1280: x_return_status := FND_API.G_RET_STS_ERROR;
1281: return;
1282: end if;
1283: end if;
1284: exception

Line 1329: x_return_status := FND_API.G_RET_STS_ERROR;

1325: l_maintenance_object_type:=2;
1326: exception
1327: when others then
1328: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: end;
1331: end if;
1332:
1333: l_maintenance_object_source:=1;

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333: l_maintenance_object_source:=1;
1334:
1335: EXCEPTION WHEN OTHERS THEN
1336: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: END;
1339:
1340: -- get owning department id
1341: --fix for 3396024.

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: and department_code = p_owning_department;
1350: END IF;
1351: EXCEPTION WHEN OTHERS THEN
1352: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_DEPT_BAD');
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: END;
1355:
1356: --if it is a work request
1357: if(p_request_type=1) then

Line 1375: x_return_status := FND_API.G_RET_STS_ERROR;

1371:
1372: -- unique
1373: if(l_count > 1) then
1374: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: elsif (l_count <1) then
1377: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: end if;

Line 1378: x_return_status := FND_API.G_RET_STS_ERROR;

1374: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1375: x_return_status := FND_API.G_RET_STS_ERROR;
1376: elsif (l_count <1) then
1377: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: end if;
1380: end if;
1381:
1382: -- check request status

Line 1383: if( x_return_status = FND_API.G_RET_STS_SUCCESS and l_work_request_id is not null) then

1379: end if;
1380: end if;
1381:
1382: -- check request status
1383: if( x_return_status = FND_API.G_RET_STS_SUCCESS and l_work_request_id is not null) then
1384: select r.work_request_number, r.wip_entity_id, r.work_request_status_id
1385: into l_work_request_number, l_work_request_wip_entity_id, l_work_request_status
1386: from wip_eam_work_requests r
1387: where r.work_request_id = l_work_request_id for update;

Line 1392: x_return_status := FND_API.G_RET_STS_ERROR;

1388:
1389: if(l_work_request_number <> p_work_request_number) then
1390: -- should not happen
1391: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_CONFLICT');
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: end if;
1394: if(l_work_request_wip_entity_id is not null) then
1395: -- has work order on work request
1396: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

1393: end if;
1394: if(l_work_request_wip_entity_id is not null) then
1395: -- has work order on work request
1396: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: end if;
1399: if(l_work_request_status <> 3) then
1400: -- has work order on work request
1401: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');

Line 1402: x_return_status := FND_API.G_RET_STS_ERROR;

1398: end if;
1399: if(l_work_request_status <> 3) then
1400: -- has work order on work request
1401: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: end if;
1404: end if;
1405: EXCEPTION WHEN OTHERS THEN
1406: -- only occur if work request not exist, should not happen

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

1404: end if;
1405: EXCEPTION WHEN OTHERS THEN
1406: -- only occur if work request not exist, should not happen
1407: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQID_NOTFOUND');
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: END;
1410: end if;
1411:
1412: --start of fix for 3396024. removed the validations and added code to fetch only the parent_wip_entity_id

Line 1423: x_return_status := FND_API.G_RET_STS_ERROR;

1419: AND organization_id=p_organization_id;
1420: exception
1421: when others then
1422: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PARENT_WO_BAD');
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: end;
1425: end if;
1426: --end of fix for 3396024
1427:

Line 1443: x_return_status := FND_API.G_RET_STS_ERROR;

1439:
1440: EXCEPTION WHEN OTHERS THEN
1441: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1442: p_token1 => 'EAM_ERROR', p_value1 => sqlerrm);
1443: x_return_status := FND_API.G_RET_STS_ERROR;
1444: END;
1445:
1446:
1447:

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR;

1463:
1464: end if;
1465: EXCEPTION WHEN OTHERS THEN
1466: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: END;
1469: end if;
1470:
1471: -- Project and task validation

Line 1476: x_return_status := FND_API.G_RET_STS_ERROR;

1472: BEGIN
1473:
1474: if p_project_number is null and p_task_number is not null then
1475: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PROJECT_REQUIRED');
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: end if;
1478:
1479: -- set profile values to be used by PJM Views. Bug#4384541
1480: fnd_profile.put('MFG_ORGANIZATION_ID',p_organization_id );

Line 1492: x_return_status := FND_API.G_RET_STS_ERROR;

1488: and ppv.project_number = p_project_number
1489: and rownum <= 1;
1490: if l_count <> 1 then
1491: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_PROJECT');
1492: x_return_status := FND_API.G_RET_STS_ERROR;
1493: else
1494: select ppv.project_id into l_project_id
1495: from pjm_projects_v ppv,
1496: pjm_project_parameters ppp

Line 1509: x_return_status := FND_API.G_RET_STS_ERROR;

1505:
1506: EXCEPTION WHEN OTHERS THEN
1507: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1508: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: END;
1511: -- Check Validation Errors
1512:
1513: -- if validate not passed then raise error

Line 1517: (p_encoded => FND_API.G_FALSE,

1513: -- if validate not passed then raise error
1514: l_msg_count := FND_MSG_PUB.count_msg;
1515: IF l_msg_count = 1 THEN
1516: eam_execution_jsp.Get_Messages
1517: (p_encoded => FND_API.G_FALSE,
1518: p_msg_index => 1,
1519: p_msg_count => l_msg_count,
1520: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
1521: p_data => l_data,

Line 1520: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

1516: eam_execution_jsp.Get_Messages
1517: (p_encoded => FND_API.G_FALSE,
1518: p_msg_index => 1,
1519: p_msg_count => l_msg_count,
1520: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
1521: p_data => l_data,
1522: p_msg_index_out => l_msg_index_out);
1523: x_msg_count := l_msg_count;
1524: x_msg_data := l_msg_data;

Line 1530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1526: x_msg_count := l_msg_count;
1527: END IF;
1528:
1529: IF l_msg_count > 0 THEN
1530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:
1534: -- End of check for Validation Errors

Line 1531: RAISE FND_API.G_EXC_ERROR;

1527: END IF;
1528:
1529: IF l_msg_count > 0 THEN
1530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:
1534: -- End of check for Validation Errors
1535:

Line 1582: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;

1578:
1579: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1580:
1581: IF (l_eam_failure_entry_record.failure_date IS NULL) THEN
1582: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
1583: END IF;
1584:
1585: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
1586: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

Line 1586: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

1582: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
1583: END IF;
1584:
1585: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
1586: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
1587: END IF;
1588:
1589: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
1590: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

Line 1590: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

1586: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
1587: END IF;
1588:
1589: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
1590: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
1591: END IF;
1592:
1593: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
1594: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

Line 1594: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;

1590: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;
1591: END IF;
1592:
1593: IF (l_eam_failure_codes_tbl(1).resolution_code IS NULL) THEN
1594: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
1595: END IF;
1596:
1597: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
1598: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

Line 1598: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;

1594: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
1595: END IF;
1596:
1597: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
1598: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
1599: END IF;
1600:
1601: IF (l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
1602: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

Line 1604: IF (l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN

1600:
1601: IF (l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
1602: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1603: ELSE
1604: IF (l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
1605: l_eam_failure_entry_record.transaction_type := NULL;
1606: ELSE
1607: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
1608: END IF;

Line 1615: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)

1611: IF (l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN
1612: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1613: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1614: ELSE
1615: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1616: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1617: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1618: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1619: ) ) THEN

Line 1616: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)

1612: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1613: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1614: ELSE
1615: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1616: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1617: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1618: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1619: ) ) THEN
1620: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

Line 1617: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)

1613: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1614: ELSE
1615: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1616: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1617: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1618: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1619: ) ) THEN
1620: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1621: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN

Line 1618: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)

1614: ELSE
1615: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1616: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1617: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1618: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1619: ) ) THEN
1620: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1621: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
1622: l_eam_failure_codes_tbl(1).failure_code := NULL;

Line 1621: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN

1617: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1618: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1619: ) ) THEN
1620: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1621: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
1622: l_eam_failure_codes_tbl(1).failure_code := NULL;
1623: END IF;
1624: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
1625: l_eam_failure_codes_tbl(1).cause_code := NULL;

Line 1624: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN

1620: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1621: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
1622: l_eam_failure_codes_tbl(1).failure_code := NULL;
1623: END IF;
1624: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
1625: l_eam_failure_codes_tbl(1).cause_code := NULL;
1626: END IF;
1627: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN
1628: l_eam_failure_codes_tbl(1).resolution_code := NULL;

Line 1627: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN

1623: END IF;
1624: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
1625: l_eam_failure_codes_tbl(1).cause_code := NULL;
1626: END IF;
1627: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN
1628: l_eam_failure_codes_tbl(1).resolution_code := NULL;
1629: END IF;
1630: IF (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) THEN
1631: l_eam_failure_codes_tbl(1).comments := NULL;

Line 1630: IF (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) THEN

1626: END IF;
1627: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN
1628: l_eam_failure_codes_tbl(1).resolution_code := NULL;
1629: END IF;
1630: IF (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) THEN
1631: l_eam_failure_codes_tbl(1).comments := NULL;
1632: END IF;
1633:
1634: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);

Line 1693: x_return_status := FND_API.G_RET_STS_ERROR;

1689:
1690: EXCEPTION WHEN OTHERS THEN
1691: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1692: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1693: x_return_status := FND_API.G_RET_STS_ERROR;
1694: end;
1695:
1696:
1697: BEGIN

Line 1772: l_workorder_rec.asset_activity_id := FND_API.G_MISS_NUM;

1768: null;
1769: end;
1770:
1771: IF l_prev_activity_id is not null and l_asset_activity_id is null THEN
1772: l_workorder_rec.asset_activity_id := FND_API.G_MISS_NUM;
1773: ELSE
1774: l_workorder_rec.asset_activity_id := l_asset_activity_id;
1775: END IF;
1776:

Line 1779: l_workorder_rec.project_id := FND_API.G_MISS_NUM;

1775: END IF;
1776:
1777: /* Added for bug#5346446 Start */
1778: IF l_prev_project_id is not null AND l_project_id is null THEN
1779: l_workorder_rec.project_id := FND_API.G_MISS_NUM;
1780: ELSE
1781: l_workorder_rec.project_id := l_project_id;
1782: END IF;
1783:

Line 1785: l_workorder_rec.task_id := FND_API.G_MISS_NUM;

1781: l_workorder_rec.project_id := l_project_id;
1782: END IF;
1783:
1784: IF l_prev_task_id is not null AND l_task_id is null THEN
1785: l_workorder_rec.task_id := FND_API.G_MISS_NUM;
1786: ELSE
1787: l_workorder_rec.task_id := l_task_id;
1788: END IF;
1789: /* Added for bug#5346446 End */

Line 1895: l_eam_wo_relations_rec3.adjust_parent := FND_API.G_FALSE;

1891: l_eam_wo_relations_rec3.child_object_type_id := 1;
1892: l_eam_wo_relations_rec3.child_header_id :=l_wip_entity_updt;
1893: l_eam_wo_relations_rec3.child_object_id :=l_wip_entity_updt;
1894: l_eam_wo_relations_rec3.parent_relationship_type := 1;
1895: l_eam_wo_relations_rec3.adjust_parent := FND_API.G_FALSE;
1896: l_eam_wo_relations_rec3.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1897:
1898: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec3;
1899: record_count := record_count+1;

Line 1912: l_eam_wo_relations_rec4.adjust_parent := FND_API.G_FALSE;

1908: l_eam_wo_relations_rec4.child_object_type_id := 1;
1909: l_eam_wo_relations_rec4.child_header_id :=l_wip_entity_updt;
1910: l_eam_wo_relations_rec4.child_object_id :=l_wip_entity_updt;
1911: l_eam_wo_relations_rec4.parent_relationship_type := 4;
1912: l_eam_wo_relations_rec4.adjust_parent := FND_API.G_FALSE;
1913: l_eam_wo_relations_rec4.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1914:
1915: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec4;
1916: record_count := record_count+1;

Line 1978: RAISE FND_API.G_EXC_ERROR;

1974:
1975: /*End of update wo ***********/
1976: if(x_return_status<>'S') then
1977: ROLLBACK TO create_easy_work_order;
1978: RAISE FND_API.G_EXC_ERROR;
1979: end if;
1980:
1981: EXCEPTION WHEN OTHERS THEN
1982: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

Line 1984: x_return_status := FND_API.G_RET_STS_ERROR;

1980:
1981: EXCEPTION WHEN OTHERS THEN
1982: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1983: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: END;
1986:
1987:
1988: BEGIN

Line 2047: x_return_status := FND_API.G_RET_STS_ERROR;

2043: and (enable_flag IS NULL OR enable_flag='Y'); -- Fix for Bug 3773450
2044:
2045: if(l_orig_service_request_id<>l_service_request_id) then
2046: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_SERVICE_REQUEST_EXISTS');
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: end if;
2049: end if;
2050:
2051: end if;

Line 2070: x_return_status := FND_API.G_RET_STS_ERROR;

2066: end if;
2067: EXCEPTION
2068: WHEN OTHERS THEN
2069: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071:
2072: END;
2073:
2074: IF FND_API.TO_BOOLEAN(P_COMMIT)

Line 2074: IF FND_API.TO_BOOLEAN(P_COMMIT)

2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071:
2072: END;
2073:
2074: IF FND_API.TO_BOOLEAN(P_COMMIT)
2075: THEN
2076: COMMIT WORK;
2077: END IF;
2078:

Line 2301: x_return_status := FND_API.G_RET_STS_ERROR;

2297:
2298: EXCEPTION WHEN OTHERS THEN
2299: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
2300: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
2301: x_return_status := FND_API.G_RET_STS_ERROR;
2302: END;
2303:
2304: x_return_status := l_return_status;
2305: x_msg_count := FND_MSG_PUB.count_msg;

Line 2309: RAISE FND_API.G_EXC_ERROR;

2305: x_msg_count := FND_MSG_PUB.count_msg;
2306:
2307: if(x_return_status<>'S') then
2308: ROLLBACK TO create_easy_work_order;
2309: RAISE FND_API.G_EXC_ERROR;
2310: end if;
2311:
2312: -- assign out parameters
2313: x_new_work_order_name := l_workorder_rec1.wip_entity_name;

Line 2371: x_return_status := FND_API.G_RET_STS_ERROR;

2367: end if;
2368: EXCEPTION
2369: WHEN OTHERS THEN
2370: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2371: x_return_status := FND_API.G_RET_STS_ERROR;
2372:
2373: END;
2374:
2375: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

Line 2375: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2371: x_return_status := FND_API.G_RET_STS_ERROR;
2372:
2373: END;
2374:
2375: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2376: COMMIT WORK;
2377: END IF;
2378:
2379:

Line 2455: RAISE FND_API.G_EXC_ERROR;

2451: x_msg_count := FND_MSG_PUB.count_msg;
2452:
2453: if(x_return_status<>'S') then
2454: ROLLBACK TO create_relationship;
2455: RAISE FND_API.G_EXC_ERROR;
2456: end if;
2457:
2458: end if;--End of creating relationship
2459:

Line 2460: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2456: end if;
2457:
2458: end if;--End of creating relationship
2459:
2460: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2461: COMMIT WORK;
2462: END IF;
2463:
2464:

Line 2467: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2463:
2464:
2465: end if; -- End of Create Work Order
2466:
2467: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2468: COMMIT WORK;
2469: END IF;
2470:
2471: EXCEPTION WHEN OTHERS THEN -- all dml excpetion

Line 2474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2470:
2471: EXCEPTION WHEN OTHERS THEN -- all dml excpetion
2472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2473: , p_token1 => 'TEXT', p_value1 => SQLERRM);
2474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2475:
2476: l_msg_count := FND_MSG_PUB.count_msg;
2477: IF l_msg_count = 1 THEN
2478: eam_execution_jsp.Get_Messages

Line 2479: (p_encoded => FND_API.G_FALSE,

2475:
2476: l_msg_count := FND_MSG_PUB.count_msg;
2477: IF l_msg_count = 1 THEN
2478: eam_execution_jsp.Get_Messages
2479: (p_encoded => FND_API.G_FALSE,
2480: p_msg_index => 1,
2481: p_msg_count => l_msg_count,
2482: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2483: p_data => l_data,

Line 2482: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

2478: eam_execution_jsp.Get_Messages
2479: (p_encoded => FND_API.G_FALSE,
2480: p_msg_index => 1,
2481: p_msg_count => l_msg_count,
2482: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2483: p_data => l_data,
2484: p_msg_index_out => l_msg_index_out);
2485: x_msg_count := l_msg_count;
2486: x_msg_data := l_msg_data;

Line 2495: FND_API.G_EXC_UNEXPECTED_ERROR THEN

2491:
2492:
2493: EXCEPTION
2494: WHEN
2495: FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: IF p_commit = FND_API.G_TRUE THEN
2497: ROLLBACK TO create_easy_work_order;
2498: END IF;
2499: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

Line 2496: IF p_commit = FND_API.G_TRUE THEN

2492:
2493: EXCEPTION
2494: WHEN
2495: FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: IF p_commit = FND_API.G_TRUE THEN
2497: ROLLBACK TO create_easy_work_order;
2498: END IF;
2499: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2500: p_procedure_name => EAM_DEBUG.G_err_stack);

Line 2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2497: ROLLBACK TO create_easy_work_order;
2498: END IF;
2499: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2500: p_procedure_name => EAM_DEBUG.G_err_stack);
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: IF p_commit = FND_API.G_TRUE THEN
2504: ROLLBACK TO create_easy_work_order;
2505: END IF;

Line 2502: WHEN FND_API.G_EXC_ERROR THEN

2498: END IF;
2499: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2500: p_procedure_name => EAM_DEBUG.G_err_stack);
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: IF p_commit = FND_API.G_TRUE THEN
2504: ROLLBACK TO create_easy_work_order;
2505: END IF;
2506:

Line 2503: IF p_commit = FND_API.G_TRUE THEN

2499: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2500: p_procedure_name => EAM_DEBUG.G_err_stack);
2501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: IF p_commit = FND_API.G_TRUE THEN
2504: ROLLBACK TO create_easy_work_order;
2505: END IF;
2506:
2507: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

Line 2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2505: END IF;
2506:
2507: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2508: p_procedure_name => EAM_DEBUG.G_err_stack);
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: WHEN OTHERS THEN -- all dml excpetion
2512: IF p_commit = FND_API.G_TRUE THEN
2513: ROLLBACK TO create_easy_work_order;

Line 2512: IF p_commit = FND_API.G_TRUE THEN

2508: p_procedure_name => EAM_DEBUG.G_err_stack);
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: WHEN OTHERS THEN -- all dml excpetion
2512: IF p_commit = FND_API.G_TRUE THEN
2513: ROLLBACK TO create_easy_work_order;
2514: END IF;
2515:
2516: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

Line 2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2514: END IF;
2515:
2516: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2517: p_procedure_name => EAM_DEBUG.G_err_stack);
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2519:
2520: end create_ez_work_order;
2521:
2522:

Line 2531: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2527: -- update work order, not involved in changes that could invoke transaction
2528: -----------------------------------------------------------------------------------
2529: procedure update_work_order
2530: ( p_api_version IN NUMBER := 1.0
2531: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2532: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2533: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2534: ,p_record_version_number IN NUMBER := NULL
2535: ,x_return_status OUT NOCOPY VARCHAR2

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

2528: -----------------------------------------------------------------------------------
2529: procedure update_work_order
2530: ( p_api_version IN NUMBER := 1.0
2531: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2532: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2533: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2534: ,p_record_version_number IN NUMBER := NULL
2535: ,x_return_status OUT NOCOPY VARCHAR2
2536: ,x_msg_count OUT NOCOPY NUMBER

Line 2533: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

2529: procedure update_work_order
2530: ( p_api_version IN NUMBER := 1.0
2531: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2532: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2533: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2534: ,p_record_version_number IN NUMBER := NULL
2535: ,x_return_status OUT NOCOPY VARCHAR2
2536: ,x_msg_count OUT NOCOPY NUMBER
2537: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2575: IF p_commit = FND_API.G_TRUE THEN

2571: l_duration NUMBER;
2572:
2573: BEGIN
2574:
2575: IF p_commit = FND_API.G_TRUE THEN
2576: SAVEPOINT complete_workorder;
2577: END IF;
2578:
2579: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');

Line 2581: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

2577: END IF;
2578:
2579: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');
2580:
2581: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2582: p_api_version,
2583: l_api_name,
2584: g_pkg_name)
2585: THEN

Line 2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2582: p_api_version,
2583: l_api_name,
2584: g_pkg_name)
2585: THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: END IF;
2588:
2589: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2590: THEN

Line 2589: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2585: THEN
2586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2587: END IF;
2588:
2589: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2590: THEN
2591: FND_MSG_PUB.initialize;
2592: END IF;
2593:

Line 2594: x_return_status := FND_API.G_RET_STS_SUCCESS;

2590: THEN
2591: FND_MSG_PUB.initialize;
2592: END IF;
2593:
2594: x_return_status := FND_API.G_RET_STS_SUCCESS;
2595:
2596: -- check if data is stale or not
2597: -- using last_update_date as indicator
2598: BEGIN

Line 2609: x_return_status := FND_API.G_RET_STS_ERROR;

2605: FOR UPDATE;
2606:
2607: IF l_db_last_update_date <> p_stored_last_update_date THEN
2608: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: END IF;
2611: EXCEPTION WHEN OTHERS THEN
2612: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
2613: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2613: x_return_status := FND_API.G_RET_STS_ERROR;

2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: END IF;
2611: EXCEPTION WHEN OTHERS THEN
2612: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: END;
2615:
2616: BEGIN
2617: select department_id

Line 2625: x_return_status := FND_API.G_RET_STS_ERROR;

2621: and department_code = p_owning_department;
2622:
2623: EXCEPTION WHEN OTHERS THEN
2624: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEPT_NOT_FOUND');
2625: x_return_status := FND_API.G_RET_STS_ERROR;
2626: END;
2627:
2628: if( p_firm_planned_flag = 1) then
2629: if(p_scheduled_start_date is null) then

Line 2631: x_return_status := FND_API.G_RET_STS_ERROR;

2627:
2628: if( p_firm_planned_flag = 1) then
2629: if(p_scheduled_start_date is null) then
2630: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_UPDATE_DATE_MISS');
2631: x_return_status := FND_API.G_RET_STS_ERROR;
2632: end if;
2633: end if;
2634:
2635: -- if validate not passed then raise error

Line 2639: (p_encoded => FND_API.G_FALSE,

2635: -- if validate not passed then raise error
2636: l_msg_count := FND_MSG_PUB.count_msg;
2637: IF l_msg_count = 1 THEN
2638: eam_execution_jsp.Get_Messages
2639: (p_encoded => FND_API.G_FALSE,
2640: p_msg_index => 1,
2641: p_msg_count => l_msg_count,
2642: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2643: p_data => l_data,

Line 2642: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

2638: eam_execution_jsp.Get_Messages
2639: (p_encoded => FND_API.G_FALSE,
2640: p_msg_index => 1,
2641: p_msg_count => l_msg_count,
2642: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2643: p_data => l_data,
2644: p_msg_index_out => l_msg_index_out);
2645: x_msg_count := l_msg_count;
2646: x_msg_data := l_msg_data;

Line 2652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2648: x_msg_count := l_msg_count;
2649: END IF;
2650:
2651: IF l_msg_count > 0 THEN
2652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655:
2656: -- call processing logic

Line 2653: RAISE FND_API.G_EXC_ERROR;

2649: END IF;
2650:
2651: IF l_msg_count > 0 THEN
2652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655:
2656: -- call processing logic
2657: BEGIN

Line 2703: x_return_status := FND_API.G_RET_STS_ERROR;

2699: end if;
2700: EXCEPTION WHEN OTHERS THEN
2701: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2702: ,p_token1 => 'TEXT', p_value1 => SQLERRM);
2703: x_return_status := FND_API.G_RET_STS_ERROR;
2704: END;
2705:
2706: -- if DML not passed then raise error
2707: l_msg_count := FND_MSG_PUB.count_msg;

Line 2710: (p_encoded => FND_API.G_FALSE,

2706: -- if DML not passed then raise error
2707: l_msg_count := FND_MSG_PUB.count_msg;
2708: IF l_msg_count = 1 THEN
2709: eam_execution_jsp.Get_Messages
2710: (p_encoded => FND_API.G_FALSE,
2711: p_msg_index => 1,
2712: p_msg_count => l_msg_count,
2713: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2714: p_data => l_data,

Line 2713: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,

2709: eam_execution_jsp.Get_Messages
2710: (p_encoded => FND_API.G_FALSE,
2711: p_msg_index => 1,
2712: p_msg_count => l_msg_count,
2713: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2714: p_data => l_data,
2715: p_msg_index_out => l_msg_index_out);
2716: x_msg_count := l_msg_count;
2717: x_msg_data := l_msg_data;

Line 2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2719: x_msg_count := l_msg_count;
2720: END IF;
2721:
2722: IF l_msg_count > 0 THEN
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2724: RAISE FND_API.G_EXC_ERROR;
2725: END IF;
2726:
2727:

Line 2724: RAISE FND_API.G_EXC_ERROR;

2720: END IF;
2721:
2722: IF l_msg_count > 0 THEN
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2724: RAISE FND_API.G_EXC_ERROR;
2725: END IF;
2726:
2727:
2728: IF FND_API.TO_BOOLEAN(P_COMMIT)

Line 2728: IF FND_API.TO_BOOLEAN(P_COMMIT)

2724: RAISE FND_API.G_EXC_ERROR;
2725: END IF;
2726:
2727:
2728: IF FND_API.TO_BOOLEAN(P_COMMIT)
2729: THEN
2730: COMMIT WORK;
2731: END IF;
2732:

Line 2733: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2729: THEN
2730: COMMIT WORK;
2731: END IF;
2732:
2733: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2734: IF p_commit = FND_API.G_TRUE THEN
2735: ROLLBACK TO complete_workorder;
2736: END IF;
2737:

Line 2734: IF p_commit = FND_API.G_TRUE THEN

2730: COMMIT WORK;
2731: END IF;
2732:
2733: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2734: IF p_commit = FND_API.G_TRUE THEN
2735: ROLLBACK TO complete_workorder;
2736: END IF;
2737:
2738: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

Line 2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2736: END IF;
2737:
2738: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2739: p_procedure_name => EAM_DEBUG.G_err_stack);
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: IF p_commit = FND_API.G_TRUE THEN
2743: ROLLBACK TO complete_workorder;
2744: END IF;

Line 2741: WHEN FND_API.G_EXC_ERROR THEN

2737:
2738: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2739: p_procedure_name => EAM_DEBUG.G_err_stack);
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: IF p_commit = FND_API.G_TRUE THEN
2743: ROLLBACK TO complete_workorder;
2744: END IF;
2745:

Line 2742: IF p_commit = FND_API.G_TRUE THEN

2738: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2739: p_procedure_name => EAM_DEBUG.G_err_stack);
2740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: IF p_commit = FND_API.G_TRUE THEN
2743: ROLLBACK TO complete_workorder;
2744: END IF;
2745:
2746: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

Line 2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2744: END IF;
2745:
2746: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2747: p_procedure_name => EAM_DEBUG.G_err_stack);
2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2749: WHEN OTHERS THEN
2750: IF p_commit = FND_API.G_TRUE THEN
2751: ROLLBACK TO complete_workorder;
2752: END IF;

Line 2750: IF p_commit = FND_API.G_TRUE THEN

2746: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2747: p_procedure_name => EAM_DEBUG.G_err_stack);
2748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2749: WHEN OTHERS THEN
2750: IF p_commit = FND_API.G_TRUE THEN
2751: ROLLBACK TO complete_workorder;
2752: END IF;
2753:
2754: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

Line 2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2752: END IF;
2753:
2754: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2755: p_procedure_name => EAM_DEBUG.G_err_stack);
2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757: END update_work_order;
2758:
2759: procedure get_completion_defaults (
2760: p_wip_entity_id in number

Line 2850: x_return_status := FND_API.G_RET_STS_SUCCESS;

2846: x_end_date := SYSDATE;
2847: END IF;
2848:
2849:
2850: x_return_status := FND_API.G_RET_STS_SUCCESS;
2851: x_msg_data := x_msg_data ||
2852: 'x_start_date = ' || to_char(x_start_date, 'MMM-DD-YYYY HH24:MI:SS')
2853: || ', x_end_date = ' || to_char(x_end_date, 'MMM-DD-YYYY HH24:MI:SS')
2854: || ', l_max_op_end_date=' || to_char(l_max_op_end_date, 'MMM-DD-YYYY HH24:MI:SS')

Line 2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2855: || ', l_sched_start_date=' || to_char(l_sched_start_date, 'MMM-DD-YYYY HH24:MI:SS')
2856: || ', l_sched_end_date=' || to_char(l_sched_end_date, 'MMM-DD-YYYY HH24:MI:SS');
2857: exception
2858: when others then
2859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2860: x_msg_data := x_msg_data || ' UNEXPECTED ERROR: ' || SQLERRM;
2861: eam_debug.init_err_stack('Exception has occured in ' || l_api_name);
2862: end get_completion_defaults;
2863:

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

2863:
2864:
2865: procedure Add_WorkOrder_Dependency (
2866: p_api_version IN NUMBER := 1.0
2867: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2868: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2869: ,p_organization_id IN NUMBER
2870: ,p_prior_object_id IN NUMBER
2871: ,p_prior_object_type_id IN NUMBER

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

2864:
2865: procedure Add_WorkOrder_Dependency (
2866: p_api_version IN NUMBER := 1.0
2867: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2868: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2869: ,p_organization_id IN NUMBER
2870: ,p_prior_object_id IN NUMBER
2871: ,p_prior_object_type_id IN NUMBER
2872: ,p_next_object_id IN NUMBER

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

2878:
2879: l_api_name constant varchar2(30) := 'Add_WorkOrder_Dependency';
2880: l_api_version CONSTANT NUMBER := 1.0;
2881: l_msg_data VARCHAR2(10000) ;
2882: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2883: l_msg_count NUMBER;
2884: l_message_text VARCHAR2(1000);
2885:
2886: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 2929: IF p_commit = FND_API.G_TRUE THEN

2925:
2926:
2927: begin
2928:
2929: IF p_commit = FND_API.G_TRUE THEN
2930: SAVEPOINT CREATE_DEPENDENT_WORK_ORDER;
2931: END IF;
2932:
2933: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 2933: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

2929: IF p_commit = FND_API.G_TRUE THEN
2930: SAVEPOINT CREATE_DEPENDENT_WORK_ORDER;
2931: END IF;
2932:
2933: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2934: p_api_version,
2935: l_api_name,
2936: g_pkg_name)
2937: THEN

Line 2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2934: p_api_version,
2935: l_api_name,
2936: g_pkg_name)
2937: THEN
2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2939: END IF;
2940:
2941: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2942: THEN

Line 2941: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2937: THEN
2938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2939: END IF;
2940:
2941: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2942: THEN
2943: FND_MSG_PUB.initialize;
2944: END IF;
2945:

Line 2947: x_return_status := FND_API.G_RET_STS_ERROR;

2943: FND_MSG_PUB.initialize;
2944: END IF;
2945:
2946: IF p_prior_object_id = 0000 OR p_next_object_id = 0000 THEN
2947: x_return_status := FND_API.G_RET_STS_ERROR;
2948: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_ENOUGH_VALUES');
2949: return;
2950: END IF;
2951:

Line 3021: , p_commit => FND_API.G_TRUE

3017: , x_eam_request_tbl => l_out_eam_request_tbl
3018: , x_return_status => l_return_status
3019: , x_msg_count => l_msg_count
3020: -- , x_error_msg_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.error_tbl_type
3021: , p_commit => FND_API.G_TRUE
3022: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
3023: , p_debug_filename => 'adddepen.log'
3024: , p_output_dir => l_output_dir
3025: , p_debug_file_mode => 'W'

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

3030: x_return_status := l_return_status;
3031: x_msg_count := l_msg_count;
3032:
3033:
3034: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3035: IF p_commit = FND_API.G_TRUE THEN
3036: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3037: END IF;
3038: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,

Line 3035: IF p_commit = FND_API.G_TRUE THEN

3031: x_msg_count := l_msg_count;
3032:
3033:
3034: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3035: IF p_commit = FND_API.G_TRUE THEN
3036: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3037: END IF;
3038: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,
3039: p_encoded => 'F',

Line 3051: IF p_commit = FND_API.G_TRUE THEN

3047: APP_EXCEPTION.RAISE_EXCEPTION;
3048:
3049: END IF;
3050:
3051: IF p_commit = FND_API.G_TRUE THEN
3052: COMMIT WORK;
3053: end if;
3054:
3055: EXCEPTION

Line 3058: IF p_commit = FND_API.G_TRUE THEN

3054:
3055: EXCEPTION
3056:
3057: when others then
3058: IF p_commit = FND_API.G_TRUE THEN
3059: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3060: END IF;
3061:
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3058: IF p_commit = FND_API.G_TRUE THEN
3059: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3060: END IF;
3061:
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063: return;
3064:
3065:
3066: end Add_WorkOrder_Dependency;

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

3067:
3068:
3069: procedure Delete_WorkOrder_Dependency (
3070: p_api_version IN NUMBER := 1.0
3071: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3072: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3073: ,p_organization_id IN NUMBER
3074: ,p_prior_object_id IN NUMBER
3075: ,p_prior_object_type_id IN NUMBER

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

3068:
3069: procedure Delete_WorkOrder_Dependency (
3070: p_api_version IN NUMBER := 1.0
3071: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3072: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3073: ,p_organization_id IN NUMBER
3074: ,p_prior_object_id IN NUMBER
3075: ,p_prior_object_type_id IN NUMBER
3076: ,p_next_object_id IN NUMBER

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

3107: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3108:
3109: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3110:
3111: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3112: l_msg_count NUMBER;
3113: l_message_text VARCHAR2(1000);
3114: l_output_dir VARCHAR2(512);
3115: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3135: IF p_commit = FND_API.G_TRUE THEN

3131: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3132:
3133: begin
3134:
3135: IF p_commit = FND_API.G_TRUE THEN
3136: SAVEPOINT DELETE_DEPENDEND_WORK_ORDER;
3137: END IF;
3138:
3139: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 3139: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

3135: IF p_commit = FND_API.G_TRUE THEN
3136: SAVEPOINT DELETE_DEPENDEND_WORK_ORDER;
3137: END IF;
3138:
3139: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
3140: p_api_version,
3141: l_api_name,
3142: g_pkg_name)
3143: THEN

Line 3144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3140: p_api_version,
3141: l_api_name,
3142: g_pkg_name)
3143: THEN
3144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3145: END IF;
3146:
3147: IF FND_API.TO_BOOLEAN(p_init_msg_list)
3148: THEN

Line 3147: IF FND_API.TO_BOOLEAN(p_init_msg_list)

3143: THEN
3144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3145: END IF;
3146:
3147: IF FND_API.TO_BOOLEAN(p_init_msg_list)
3148: THEN
3149: FND_MSG_PUB.initialize;
3150: END IF;
3151:

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

3224: l_msg_count := FND_MSG_PUB.count_msg;
3225: x_return_status := l_return_status;
3226: x_msg_count := l_msg_count;
3227:
3228: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3229: IF p_commit = FND_API.G_TRUE THEN
3230: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3231: END IF;
3232:

Line 3229: IF p_commit = FND_API.G_TRUE THEN

3225: x_return_status := l_return_status;
3226: x_msg_count := l_msg_count;
3227:
3228: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3229: IF p_commit = FND_API.G_TRUE THEN
3230: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3231: END IF;
3232:
3233: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,

Line 3245: IF FND_API.TO_BOOLEAN(p_commit)THEN

3241: translate => FALSE);
3242:
3243: APP_EXCEPTION.RAISE_EXCEPTION;
3244: ELSE
3245: IF FND_API.TO_BOOLEAN(p_commit)THEN
3246: COMMIT WORK;
3247: END IF;
3248: END IF;
3249:

Line 3254: IF p_commit = FND_API.G_TRUE THEN

3250:
3251: EXCEPTION
3252:
3253: when others then
3254: IF p_commit = FND_API.G_TRUE THEN
3255: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3256: END IF;
3257:
3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3254: IF p_commit = FND_API.G_TRUE THEN
3255: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3256: END IF;
3257:
3258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3259: return;
3260: end Delete_WorkOrder_Dependency;
3261:
3262: -- Start of comments

Line 3269: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE

3265: -- Function : Creates the costing hierarchy from the scheduling hierarchy.
3266: -- Pre-reqs : None.
3267: -- Parameters :
3268: -- IN p_api_version IN NUMBER
3269: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
3270: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3271: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3272: -- p_top_level_object_id IN VARCHAR2
3273: -- OUT x_return_status OUT NOCOPY NUMBER

Line 3270: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE

3266: -- Pre-reqs : None.
3267: -- Parameters :
3268: -- IN p_api_version IN NUMBER
3269: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
3270: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3271: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3272: -- p_top_level_object_id IN VARCHAR2
3273: -- OUT x_return_status OUT NOCOPY NUMBER
3274: -- x_msg_count OUT NOCOPY NUMBER

Line 3271: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL

3267: -- Parameters :
3268: -- IN p_api_version IN NUMBER
3269: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
3270: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3271: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3272: -- p_top_level_object_id IN VARCHAR2
3273: -- OUT x_return_status OUT NOCOPY NUMBER
3274: -- x_msg_count OUT NOCOPY NUMBER
3275: -- x_msg_data OUT NOCOPY VARCHAR2

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

3279: --
3280: -- End of comments
3281: procedure create_cost_hierarchy_pvt(
3282: p_api_version IN NUMBER :=1.0 ,
3283: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3284: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3285: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3286: p_wip_entity_id IN VARCHAR2,
3287: p_org_id IN VARCHAR2,

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

3280: -- End of comments
3281: procedure create_cost_hierarchy_pvt(
3282: p_api_version IN NUMBER :=1.0 ,
3283: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3284: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3285: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3286: p_wip_entity_id IN VARCHAR2,
3287: p_org_id IN VARCHAR2,
3288: x_return_status OUT NOCOPY VARCHAR2 ,

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

3281: procedure create_cost_hierarchy_pvt(
3282: p_api_version IN NUMBER :=1.0 ,
3283: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3284: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3285: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3286: p_wip_entity_id IN VARCHAR2,
3287: p_org_id IN VARCHAR2,
3288: x_return_status OUT NOCOPY VARCHAR2 ,
3289: x_msg_count OUT NOCOPY NUMBER ,

Line 3381: IF NOT FND_API.compatible_api_call(

3377:
3378: BEGIN
3379: SAVEPOINT create_cost_hierarchy;
3380:
3381: IF NOT FND_API.compatible_api_call(
3382: l_api_version
3383: ,p_api_version
3384: ,l_api_name
3385: ,g_pkg_name) THEN

Line 3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3382: l_api_version
3383: ,p_api_version
3384: ,l_api_name
3385: ,g_pkg_name) THEN
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: END IF;
3388:
3389: -- Initialize message list if p_init_msg_list is set to TRUE.
3390: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3390: IF FND_API.to_boolean(p_init_msg_list) THEN

3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: END IF;
3388:
3389: -- Initialize message list if p_init_msg_list is set to TRUE.
3390: IF FND_API.to_boolean(p_init_msg_list) THEN
3391: FND_MSG_PUB.initialize;
3392: END IF;
3393:
3394: -- Initialize API return status to success

Line 3395: x_return_status := FND_API.g_ret_sts_success;

3391: FND_MSG_PUB.initialize;
3392: END IF;
3393:
3394: -- Initialize API return status to success
3395: x_return_status := FND_API.g_ret_sts_success;
3396:
3397: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
3398:
3399: FOR c_hierarchy_row IN c_work_hierarchy

Line 3414: p_commit => FND_API.G_TRUE

3410:
3411:
3412: -- Delete the record if exists. The child WO cannot have more than 1 parent.
3413: EAM_WORKORDERS_JSP.Delete_WorkOrder_Dependency (
3414: p_commit => FND_API.G_TRUE
3415: ,p_prior_object_type_id => 1
3416: ,p_next_object_type_id => 1
3417: ,p_organization_id => p_org_id
3418: ,p_prior_object_id => l_parent_object_id

Line 3427: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

3423: ,x_msg_data => x_msg_data
3424: );
3425:
3426:
3427: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3428: /* Create a new relationship between the parent and the child workorder taken from the scheduling hierarchy. */
3429: l_parent_id := c_hierarchy_row.parent_object_id ;
3430: l_child_wip_id := c_hierarchy_row.child_object_id ;
3431: l_eam_wo_relations_rec.batch_id := 1;

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

3488: , p_commit => p_commit
3489: , p_debug_file_mode => 'A'
3490: );
3491:
3492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3496: ELSE

Line 3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3489: , p_debug_file_mode => 'A'
3490: );
3491:
3492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3496: ELSE
3497: -- if there is any exception then rollback and come out of the procedure.

Line 3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3490: );
3491:
3492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3496: ELSE
3497: -- if there is any exception then rollback and come out of the procedure.
3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3496: ELSE
3497: -- if there is any exception then rollback and come out of the procedure.
3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3500: END IF;
3501:
3502: EXCEPTION

Line 3499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3495: END IF;
3496: ELSE
3497: -- if there is any exception then rollback and come out of the procedure.
3498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3500: END IF;
3501:
3502: EXCEPTION
3503: -- If there is no parent with type '3' for the workorder, then simply create a new relationship.

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

3566: , p_commit => p_commit
3567: , p_debug_file_mode => 'A'
3568: );
3569:
3570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3573: END IF;
3574: WHEN OTHERS THEN

Line 3571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3567: , p_debug_file_mode => 'A'
3568: );
3569:
3570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3573: END IF;
3574: WHEN OTHERS THEN
3575:

Line 3572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3568: );
3569:
3570: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3573: END IF;
3574: WHEN OTHERS THEN
3575:
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3573: END IF;
3574: WHEN OTHERS THEN
3575:
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: END;
3579: END LOOP;
3580:

Line 3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3573: END IF;
3574: WHEN OTHERS THEN
3575:
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: END;
3579: END LOOP;
3580:
3581:

Line 3583: IF ((FND_API.TO_BOOLEAN(p_commit)) AND (x_return_status = FND_API.G_RET_STS_SUCCESS)) THEN

3579: END LOOP;
3580:
3581:
3582:
3583: IF ((FND_API.TO_BOOLEAN(p_commit)) AND (x_return_status = FND_API.G_RET_STS_SUCCESS)) THEN
3584: COMMIT WORK;
3585: END IF;
3586:
3587: EXCEPTION

Line 3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3584: COMMIT WORK;
3585: END IF;
3586:
3587: EXCEPTION
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3589: ROLLBACK TO create_cost_hierarchy;
3590: FND_MSG_PUB.add_exc_msg( p_pkg_name => l_full_name,
3591: p_procedure_name => l_api_name);
3592: WHEN OTHERS THEN

Line 3596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3592: WHEN OTHERS THEN
3593: ROLLBACK TO create_cost_hierarchy;
3594: FND_MSG_PUB.add_exc_msg( p_pkg_name => l_full_name,
3595: p_procedure_name => l_api_name);
3596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3597:
3598: END create_cost_hierarchy_pvt;
3599:
3600: -- Start of comments

Line 3607: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE

3603: -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
3604: -- Pre-reqs : None.
3605: -- Parameters :
3606: -- IN p_api_version IN NUMBER
3607: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
3608: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3609: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3610: -- p_object_id IN NUMBER
3611: -- p_object_type_id IN NUMBER

Line 3608: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE

3604: -- Pre-reqs : None.
3605: -- Parameters :
3606: -- IN p_api_version IN NUMBER
3607: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
3608: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3609: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3610: -- p_object_id IN NUMBER
3611: -- p_object_type_id IN NUMBER
3612: -- p_schedule_start_date IN DATE

Line 3609: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL

3605: -- Parameters :
3606: -- IN p_api_version IN NUMBER
3607: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
3608: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3609: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3610: -- p_object_id IN NUMBER
3611: -- p_object_type_id IN NUMBER
3612: -- p_schedule_start_date IN DATE
3613: -- p_schedule_end_date IN DATE

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

3627:
3628: /*Bug3521886: Pass requested start date and due date*/
3629: PROCEDURE resize_wo_hierarchy_pvt(
3630: p_api_version IN NUMBER ,
3631: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3632: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3633: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3634: p_object_id IN NUMBER,
3635: p_object_type_id IN NUMBER,

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

3628: /*Bug3521886: Pass requested start date and due date*/
3629: PROCEDURE resize_wo_hierarchy_pvt(
3630: p_api_version IN NUMBER ,
3631: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3632: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3633: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3634: p_object_id IN NUMBER,
3635: p_object_type_id IN NUMBER,
3636: p_schedule_start_date IN DATE,

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

3629: PROCEDURE resize_wo_hierarchy_pvt(
3630: p_api_version IN NUMBER ,
3631: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3632: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3633: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3634: p_object_id IN NUMBER,
3635: p_object_type_id IN NUMBER,
3636: p_schedule_start_date IN DATE,
3637: p_schedule_end_date IN DATE,

Line 3660: IF NOT FND_API.compatible_api_call(

3656: -- Standard Start of API savepoint
3657: SAVEPOINT resize_wo_hierarchy_pvt;
3658:
3659: -- Standard call to check for call compatibility.
3660: IF NOT FND_API.compatible_api_call(
3661: l_api_version
3662: ,p_api_version
3663: ,l_api_name
3664: ,g_pkg_name) THEN

Line 3665: RAISE fnd_api.g_exc_unexpected_error;

3661: l_api_version
3662: ,p_api_version
3663: ,l_api_name
3664: ,g_pkg_name) THEN
3665: RAISE fnd_api.g_exc_unexpected_error;
3666: END IF;
3667:
3668: -- Initialize message list if p_init_msg_list is set to TRUE.
3669: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3669: IF FND_API.to_boolean(p_init_msg_list) THEN

3665: RAISE fnd_api.g_exc_unexpected_error;
3666: END IF;
3667:
3668: -- Initialize message list if p_init_msg_list is set to TRUE.
3669: IF FND_API.to_boolean(p_init_msg_list) THEN
3670: FND_MSG_PUB.initialize;
3671: END IF;
3672:
3673: -- Initialize API return status to success

Line 3674: x_return_status := FND_API.g_ret_sts_success;

3670: FND_MSG_PUB.initialize;
3671: END IF;
3672:
3673: -- Initialize API return status to success
3674: x_return_status := FND_API.g_ret_sts_success;
3675:
3676: -- API body
3677: IF (p_schedule_end_date IS NULL) THEN
3678: l_schedule_end_date := p_schedule_start_date + (p_duration_for_shifting / 24);

Line 3699: IF (x_return_status = FND_API.g_ret_sts_success) THEN

3695: x_return_status => x_return_status,
3696: x_msg_count => x_msg_count,
3697: x_msg_data => x_msg_data);
3698: -- End of API body
3699: IF (x_return_status = FND_API.g_ret_sts_success) THEN
3700: IF FND_API.TO_BOOLEAN(p_commit)THEN
3701: COMMIT WORK;
3702: END IF;
3703: END IF;

Line 3700: IF FND_API.TO_BOOLEAN(p_commit)THEN

3696: x_msg_count => x_msg_count,
3697: x_msg_data => x_msg_data);
3698: -- End of API body
3699: IF (x_return_status = FND_API.g_ret_sts_success) THEN
3700: IF FND_API.TO_BOOLEAN(p_commit)THEN
3701: COMMIT WORK;
3702: END IF;
3703: END IF;
3704:

Line 3713: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);

3709: );
3710: IF x_msg_count > 0 THEN
3711: FOR indexCount IN 1 ..x_msg_count
3712: LOOP
3713: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
3714: -- DBMS_OUTPUT.PUT_LINE(indexCount ||'-'||l_msg_data);
3715: END LOOP;
3716: END IF;
3717:

Line 3721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3717:
3718: EXCEPTION
3719: WHEN OTHERS THEN
3720: ROLLBACK TO resize_wo_hierarchy_pvt;
3721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3722:
3723:
3724:
3725: END resize_wo_hierarchy_pvt;