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 735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

731: when no_data_found then
732: -- x_error_flag := 1;
733: -- x_error_mssg := 'EAM_RET_MAT_INVALID_LOCATOR';
734: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_INVALID_LOCATOR');
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: return;
737: end;
738: end if;
739:

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

758: if(l_locator_id IS NULL) then
759: /* l_error_flag := 1;
760: l_error_mssg := 'EAM_RET_MAT_LOCATOR_NEEDED'; */
761: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_NEEDED');
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: return;
764: end if;
765: elsif(l_locator_ctrl = 1) then -- If the locator control is NOControl
766: if(l_locator_id IS NOT NULL) then

Line 770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

766: if(l_locator_id IS NOT NULL) then
767: /* l_error_flag := 1;
768: l_error_mssg := 'EAM_RET_MAT_LOCATOR_RESTRICTED'; */
769: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_RET_MAT_LOCATOR_RESTRICTED');
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: return;
772: end if;
773: end if; -- end of locator_control checkif
774:

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

785: and organization_id = p_org_id;
786: exception
787: when NO_DATA_FOUND then
788: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NO_LOT_NUMBER');
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: end;
791: else
792: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: end;
791: else
792: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NEEDED');
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: end if;
795: else
796: if(p_lot is not null) then
797: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

794: end if;
795: else
796: if(p_lot is not null) then
797: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_LOT_NOT_NEEDED');
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: end if;
800: end if; -- end of lot entry check
801:
802: -- end if; -- end of completion_info check

Line 812: (p_encoded => FND_API.G_FALSE,

808: -- if validate not passed then raise error
809: l_msg_count := FND_MSG_PUB.count_msg;
810: IF l_msg_count = 1 THEN
811: eam_execution_jsp.Get_Messages
812: (p_encoded => FND_API.G_FALSE,
813: p_msg_index => 1,
814: p_msg_count => l_msg_count,
815: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
816: p_data => l_data,

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

811: eam_execution_jsp.Get_Messages
812: (p_encoded => FND_API.G_FALSE,
813: p_msg_index => 1,
814: p_msg_count => l_msg_count,
815: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
816: p_data => l_data,
817: p_msg_index_out => l_msg_index_out);
818: x_msg_count := l_msg_count;
819: x_msg_data := l_msg_data;

Line 825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

821: x_msg_count := l_msg_count;
822: END IF;
823:
824: IF l_msg_count > 0 THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: BEGIN

Line 826: RAISE FND_API.G_EXC_ERROR;

822: END IF;
823:
824: IF l_msg_count > 0 THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: BEGIN
830: /* call processing logic */

Line 870: x_return_status := FND_API.G_RET_STS_ERROR;

866: );
867:
868: IF (l_err_number = 2) THEN
869: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: ELSIF (l_err_number > 0 ) THEN
872: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;

Line 873: x_return_status := FND_API.G_RET_STS_ERROR;

869: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>'EAM_WO_NO_UNCOMPLETE' );
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: ELSIF (l_err_number > 0 ) THEN
872: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name =>l_err_code);
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875:
876: EXCEPTION WHEN OTHERS THEN
877: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',

Line 879: x_return_status := FND_API.G_RET_STS_ERROR;

875:
876: EXCEPTION WHEN OTHERS THEN
877: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION',
878: p_token1 => 'TEXT', p_value1 => sqlerrm);
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END;
881:
882:
883: -- if DML not passed then raise error

Line 887: (p_encoded => FND_API.G_FALSE,

883: -- if DML not passed then raise error
884: l_msg_count := FND_MSG_PUB.count_msg;
885: IF l_msg_count = 1 THEN
886: eam_execution_jsp.Get_Messages
887: (p_encoded => FND_API.G_FALSE,
888: p_msg_index => 1,
889: p_msg_count => l_msg_count,
890: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
891: p_data => l_data,

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

886: eam_execution_jsp.Get_Messages
887: (p_encoded => FND_API.G_FALSE,
888: p_msg_index => 1,
889: p_msg_count => l_msg_count,
890: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
891: p_data => l_data,
892: p_msg_index_out => l_msg_index_out);
893: x_msg_count := l_msg_count;
894: x_msg_data := l_msg_data;

Line 900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

896: x_msg_count := l_msg_count;
897: END IF;
898:
899: IF l_msg_count > 0 THEN
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903:
904:

Line 901: RAISE FND_API.G_EXC_ERROR;

897: END IF;
898:
899: IF l_msg_count > 0 THEN
900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903:
904:
905: IF FND_API.TO_BOOLEAN(P_COMMIT)

Line 905: IF FND_API.TO_BOOLEAN(P_COMMIT)

901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903:
904:
905: IF FND_API.TO_BOOLEAN(P_COMMIT)
906: THEN
907: COMMIT WORK;
908: END IF;
909:

Line 910: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

906: THEN
907: COMMIT WORK;
908: END IF;
909:
910: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: IF p_commit = FND_API.G_TRUE THEN
912: ROLLBACK TO complete_workorder;
913: END IF;
914:

Line 911: IF p_commit = FND_API.G_TRUE THEN

907: COMMIT WORK;
908: END IF;
909:
910: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: IF p_commit = FND_API.G_TRUE THEN
912: ROLLBACK TO complete_workorder;
913: END IF;
914:
915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: END IF;
914:
915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
916: p_procedure_name => EAM_DEBUG.G_err_stack);
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN FND_API.G_EXC_ERROR THEN
919: IF p_commit = FND_API.G_TRUE THEN
920: ROLLBACK TO complete_workorder;
921: END IF;

Line 918: WHEN FND_API.G_EXC_ERROR THEN

914:
915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
916: p_procedure_name => EAM_DEBUG.G_err_stack);
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN FND_API.G_EXC_ERROR THEN
919: IF p_commit = FND_API.G_TRUE THEN
920: ROLLBACK TO complete_workorder;
921: END IF;
922:

Line 919: IF p_commit = FND_API.G_TRUE THEN

915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
916: p_procedure_name => EAM_DEBUG.G_err_stack);
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN FND_API.G_EXC_ERROR THEN
919: IF p_commit = FND_API.G_TRUE THEN
920: ROLLBACK TO complete_workorder;
921: END IF;
922:
923: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

921: END IF;
922:
923: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
924: p_procedure_name => EAM_DEBUG.G_err_stack);
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: WHEN OTHERS THEN
927: IF p_commit = FND_API.G_TRUE THEN
928: ROLLBACK TO complete_workorder;
929: END IF;

Line 927: IF p_commit = FND_API.G_TRUE THEN

923: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
924: p_procedure_name => EAM_DEBUG.G_err_stack);
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
926: WHEN OTHERS THEN
927: IF p_commit = FND_API.G_TRUE THEN
928: ROLLBACK TO complete_workorder;
929: END IF;
930:
931: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',

Line 933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

929: END IF;
930:
931: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.COMPLETE_WORKORDER',
932: p_procedure_name => EAM_DEBUG.G_err_stack);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: END Complete_Workorder;
935:
936:
937:

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

944: --anjgupta Changes for IB and Transactable Assets Project in R12
945: -------------------------------------------------------------------------------
946: procedure create_ez_work_order
947: ( p_api_version IN NUMBER := 1.0
948: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
949: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
950: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
951: ,p_record_version_number IN NUMBER := NULL
952: ,x_return_status OUT NOCOPY VARCHAR2

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

945: -------------------------------------------------------------------------------
946: procedure create_ez_work_order
947: ( p_api_version IN NUMBER := 1.0
948: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
949: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
950: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
951: ,p_record_version_number IN NUMBER := NULL
952: ,x_return_status OUT NOCOPY VARCHAR2
953: ,x_msg_count OUT NOCOPY NUMBER

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

946: procedure create_ez_work_order
947: ( p_api_version IN NUMBER := 1.0
948: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
949: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
950: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
951: ,p_record_version_number IN NUMBER := NULL
952: ,x_return_status OUT NOCOPY VARCHAR2
953: ,x_msg_count OUT NOCOPY NUMBER
954: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1246: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1242: SAVEPOINT create_easy_work_order;
1243:
1244: eam_debug.init_err_stack('eam_workorders_jsp.create_easy_work_order');
1245:
1246: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1247: p_api_version,
1248: l_api_name,
1249: g_pkg_name)
1250: THEN

Line 1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1247: p_api_version,
1248: l_api_name,
1249: g_pkg_name)
1250: THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1255: THEN

Line 1254: IF FND_API.TO_BOOLEAN(p_init_msg_list)

1250: THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: END IF;
1253:
1254: IF FND_API.TO_BOOLEAN(p_init_msg_list)
1255: THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:

Line 1262: x_return_status := FND_API.G_RET_STS_SUCCESS;

1258:
1259: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
1260:
1261:
1262: x_return_status := FND_API.G_RET_STS_SUCCESS;
1263:
1264: -- Assign user defined status passed to API to a local variable
1265: l_user_defined_status_type := p_status_type;
1266:

Line 1311: x_return_status := FND_API.G_RET_STS_ERROR;

1307:
1308: 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
1309: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEACTIVATE_CANNOT_UNCANCEL',
1310: p_token1 => 'NAME', p_value1 => p_wip_entity_name);
1311: x_return_status := FND_API.G_RET_STS_ERROR;
1312: return;
1313: end if;
1314: end if;
1315: exception

Line 1360: x_return_status := FND_API.G_RET_STS_ERROR;

1356: l_maintenance_object_type:=2;
1357: exception
1358: when others then
1359: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361: end;
1362: end if;
1363:
1364: l_maintenance_object_source:=1;

Line 1368: x_return_status := FND_API.G_RET_STS_ERROR;

1364: l_maintenance_object_source:=1;
1365:
1366: EXCEPTION WHEN OTHERS THEN
1367: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_ASSET_BAD');
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: END;
1370:
1371: -- get owning department id
1372: --fix for 3396024.

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR;

1380: and department_code = p_owning_department;
1381: END IF;
1382: EXCEPTION WHEN OTHERS THEN
1383: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_DEPT_BAD');
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385: END;
1386:
1387: --if it is a work request
1388: if(p_request_type=1) then

Line 1406: x_return_status := FND_API.G_RET_STS_ERROR;

1402:
1403: -- unique
1404: if(l_count > 1) then
1405: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: elsif (l_count <1) then
1408: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: end if;

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTUNIQUE');
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: elsif (l_count <1) then
1408: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_NOTFOUND');
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: end if;
1411: end if;
1412:
1413: -- check request status

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

1410: end if;
1411: end if;
1412:
1413: -- check request status
1414: if( x_return_status = FND_API.G_RET_STS_SUCCESS and l_work_request_id is not null) then
1415: select r.work_request_number, r.wip_entity_id, r.work_request_status_id
1416: into l_work_request_number, l_work_request_wip_entity_id, l_work_request_status
1417: from wip_eam_work_requests r
1418: where r.work_request_id = l_work_request_id for update;

Line 1423: x_return_status := FND_API.G_RET_STS_ERROR;

1419:
1420: if(l_work_request_number <> p_work_request_number) then
1421: -- should not happen
1422: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_CONFLICT');
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: end if;
1425: if(l_work_request_wip_entity_id is not null) then
1426: -- has work order on work request
1427: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');

Line 1428: x_return_status := FND_API.G_RET_STS_ERROR;

1424: end if;
1425: if(l_work_request_wip_entity_id is not null) then
1426: -- has work order on work request
1427: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_WO_EXIST');
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: end if;
1430: if(l_work_request_status <> 3) then
1431: -- has work order on work request
1432: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR;

1429: end if;
1430: if(l_work_request_status <> 3) then
1431: -- has work order on work request
1432: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQ_STATUS_WRONG');
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: end if;
1435: end if;
1436: EXCEPTION WHEN OTHERS THEN
1437: -- only occur if work request not exist, should not happen

Line 1439: x_return_status := FND_API.G_RET_STS_ERROR;

1435: end if;
1436: EXCEPTION WHEN OTHERS THEN
1437: -- only occur if work request not exist, should not happen
1438: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_WQID_NOTFOUND');
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440: END;
1441: end if;
1442:
1443: --start of fix for 3396024. removed the validations and added code to fetch only the parent_wip_entity_id

Line 1454: x_return_status := FND_API.G_RET_STS_ERROR;

1450: AND organization_id=p_organization_id;
1451: exception
1452: when others then
1453: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PARENT_WO_BAD');
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: end;
1456: end if;
1457: --end of fix for 3396024
1458:

Line 1474: x_return_status := FND_API.G_RET_STS_ERROR;

1470:
1471: EXCEPTION WHEN OTHERS THEN
1472: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1473: p_token1 => 'EAM_ERROR', p_value1 => sqlerrm);
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: END;
1476:
1477:
1478:

Line 1498: x_return_status := FND_API.G_RET_STS_ERROR;

1494:
1495: end if;
1496: EXCEPTION WHEN OTHERS THEN
1497: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: END;
1500: end if;
1501:
1502: -- Project and task validation

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

1503: BEGIN
1504:
1505: if p_project_number is null and p_task_number is not null then
1506: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_PROJECT_REQUIRED');
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508: end if;
1509:
1510: -- set profile values to be used by PJM Views. Bug#4384541
1511: fnd_profile.put('MFG_ORGANIZATION_ID',p_organization_id );

Line 1523: x_return_status := FND_API.G_RET_STS_ERROR;

1519: and ppv.project_number = p_project_number
1520: and rownum <= 1;
1521: if l_count <> 1 then
1522: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_PROJECT');
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: else
1525: select ppv.project_id into l_project_id
1526: from pjm_projects_v ppv,
1527: pjm_project_parameters ppp

Line 1540: x_return_status := FND_API.G_RET_STS_ERROR;

1536:
1537: EXCEPTION WHEN OTHERS THEN
1538: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1539: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1540: x_return_status := FND_API.G_RET_STS_ERROR;
1541: END;
1542: -- Check Validation Errors
1543:
1544: -- if validate not passed then raise error

Line 1548: (p_encoded => FND_API.G_FALSE,

1544: -- if validate not passed then raise error
1545: l_msg_count := FND_MSG_PUB.count_msg;
1546: IF l_msg_count = 1 THEN
1547: eam_execution_jsp.Get_Messages
1548: (p_encoded => FND_API.G_FALSE,
1549: p_msg_index => 1,
1550: p_msg_count => l_msg_count,
1551: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
1552: p_data => l_data,

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

1547: eam_execution_jsp.Get_Messages
1548: (p_encoded => FND_API.G_FALSE,
1549: p_msg_index => 1,
1550: p_msg_count => l_msg_count,
1551: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
1552: p_data => l_data,
1553: p_msg_index_out => l_msg_index_out);
1554: x_msg_count := l_msg_count;
1555: x_msg_data := l_msg_data;

Line 1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1557: x_msg_count := l_msg_count;
1558: END IF;
1559:
1560: IF l_msg_count > 0 THEN
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;
1564:
1565: -- End of check for Validation Errors

Line 1562: RAISE FND_API.G_EXC_ERROR;

1558: END IF;
1559:
1560: IF l_msg_count > 0 THEN
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: RAISE FND_API.G_EXC_ERROR;
1563: END IF;
1564:
1565: -- End of check for Validation Errors
1566:

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

1609:
1610: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1611:
1612: IF (l_eam_failure_entry_record.failure_date IS NULL) THEN
1613: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
1614: END IF;
1615:
1616: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
1617: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;

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

1613: l_eam_failure_entry_record.failure_date := FND_API.G_MISS_DATE;
1614: END IF;
1615:
1616: IF (l_eam_failure_codes_tbl(1).failure_code IS NULL) THEN
1617: l_eam_failure_codes_tbl(1).failure_code := FND_API.G_MISS_CHAR;
1618: END IF;
1619:
1620: IF (l_eam_failure_codes_tbl(1).cause_code IS NULL) THEN
1621: l_eam_failure_codes_tbl(1).cause_code := FND_API.G_MISS_CHAR;

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

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

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

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

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

1625: l_eam_failure_codes_tbl(1).resolution_code := FND_API.G_MISS_CHAR;
1626: END IF;
1627:
1628: IF (l_eam_failure_codes_tbl(1).comments IS NULL) THEN
1629: l_eam_failure_codes_tbl(1).comments := FND_API.G_MISS_CHAR;
1630: END IF;
1631:
1632: IF (l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
1633: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;

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

1631:
1632: IF (l_eam_failure_entry_record.failure_id IS NOT NULL ) THEN
1633: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1634: ELSE
1635: IF (l_eam_failure_entry_record.failure_date = FND_API.G_MISS_DATE) THEN
1636: l_eam_failure_entry_record.transaction_type := NULL;
1637: ELSE
1638: l_eam_failure_entry_record.transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE ;
1639: END IF;

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

1642: IF (l_eam_failure_codes_tbl(1).failure_entry_id IS NOT NULL) THEN
1643: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1644: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1645: ELSE
1646: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1647: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1648: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1649: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1650: ) ) THEN

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

1643: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_UPDATE;
1644: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1645: ELSE
1646: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1647: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1648: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1649: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1650: ) ) THEN
1651: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;

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

1644: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);
1645: ELSE
1646: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1647: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1648: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1649: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1650: ) ) THEN
1651: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1652: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN

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

1645: ELSE
1646: IF ( NOT ( (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR)
1647: AND (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR)
1648: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1649: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1650: ) ) THEN
1651: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1652: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
1653: l_eam_failure_codes_tbl(1).failure_code := NULL;

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

1648: AND (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR)
1649: AND (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR)
1650: ) ) THEN
1651: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1652: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
1653: l_eam_failure_codes_tbl(1).failure_code := NULL;
1654: END IF;
1655: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
1656: l_eam_failure_codes_tbl(1).cause_code := NULL;

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

1651: l_eam_failure_codes_tbl(1).transaction_type := EAM_Process_Failure_Entry_PUB.G_FE_CREATE;
1652: IF (l_eam_failure_codes_tbl(1).failure_code = FND_API.G_MISS_CHAR) THEN
1653: l_eam_failure_codes_tbl(1).failure_code := NULL;
1654: END IF;
1655: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
1656: l_eam_failure_codes_tbl(1).cause_code := NULL;
1657: END IF;
1658: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN
1659: l_eam_failure_codes_tbl(1).resolution_code := NULL;

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

1654: END IF;
1655: IF (l_eam_failure_codes_tbl(1).cause_code = FND_API.G_MISS_CHAR) THEN
1656: l_eam_failure_codes_tbl(1).cause_code := NULL;
1657: END IF;
1658: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN
1659: l_eam_failure_codes_tbl(1).resolution_code := NULL;
1660: END IF;
1661: IF (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) THEN
1662: l_eam_failure_codes_tbl(1).comments := NULL;

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

1657: END IF;
1658: IF (l_eam_failure_codes_tbl(1).resolution_code = FND_API.G_MISS_CHAR) THEN
1659: l_eam_failure_codes_tbl(1).resolution_code := NULL;
1660: END IF;
1661: IF (l_eam_failure_codes_tbl(1).comments = FND_API.G_MISS_CHAR) THEN
1662: l_eam_failure_codes_tbl(1).comments := NULL;
1663: END IF;
1664:
1665: l_workorder_rec.eam_failure_codes_tbl(1) := l_eam_failure_codes_tbl(1);

Line 1724: x_return_status := FND_API.G_RET_STS_ERROR;

1720:
1721: EXCEPTION WHEN OTHERS THEN
1722: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
1723: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
1724: x_return_status := FND_API.G_RET_STS_ERROR;
1725: end;
1726:
1727:
1728: BEGIN

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

1799: null;
1800: end;
1801:
1802: IF l_prev_activity_id is not null and l_asset_activity_id is null THEN
1803: l_workorder_rec.asset_activity_id := FND_API.G_MISS_NUM;
1804: ELSE
1805: l_workorder_rec.asset_activity_id := l_asset_activity_id;
1806: END IF;
1807:

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

1806: END IF;
1807:
1808: /* Added for bug#5346446 Start */
1809: IF l_prev_project_id is not null AND l_project_id is null THEN
1810: l_workorder_rec.project_id := FND_API.G_MISS_NUM;
1811: ELSE
1812: l_workorder_rec.project_id := l_project_id;
1813: END IF;
1814:

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

1812: l_workorder_rec.project_id := l_project_id;
1813: END IF;
1814:
1815: IF l_prev_task_id is not null AND l_task_id is null THEN
1816: l_workorder_rec.task_id := FND_API.G_MISS_NUM;
1817: ELSE
1818: l_workorder_rec.task_id := l_task_id;
1819: END IF;
1820: /* Added for bug#5346446 End */

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

1922: l_eam_wo_relations_rec3.child_object_type_id := 1;
1923: l_eam_wo_relations_rec3.child_header_id :=l_wip_entity_updt;
1924: l_eam_wo_relations_rec3.child_object_id :=l_wip_entity_updt;
1925: l_eam_wo_relations_rec3.parent_relationship_type := 1;
1926: l_eam_wo_relations_rec3.adjust_parent := FND_API.G_FALSE;
1927: l_eam_wo_relations_rec3.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1928:
1929: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec3;
1930: record_count := record_count+1;

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

1939: l_eam_wo_relations_rec4.child_object_type_id := 1;
1940: l_eam_wo_relations_rec4.child_header_id :=l_wip_entity_updt;
1941: l_eam_wo_relations_rec4.child_object_id :=l_wip_entity_updt;
1942: l_eam_wo_relations_rec4.parent_relationship_type := 4;
1943: l_eam_wo_relations_rec4.adjust_parent := FND_API.G_FALSE;
1944: l_eam_wo_relations_rec4.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_CREATE;
1945:
1946: l_eam_wo_relations_tbl(record_count) := l_eam_wo_relations_rec4;
1947: record_count := record_count+1;

Line 2009: RAISE FND_API.G_EXC_ERROR;

2005:
2006: /*End of update wo ***********/
2007: if(x_return_status<>'S') then
2008: ROLLBACK TO create_easy_work_order;
2009: RAISE FND_API.G_EXC_ERROR;
2010: end if;
2011:
2012: EXCEPTION WHEN OTHERS THEN
2013: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',

Line 2015: x_return_status := FND_API.G_RET_STS_ERROR;

2011:
2012: EXCEPTION WHEN OTHERS THEN
2013: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
2014: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
2015: x_return_status := FND_API.G_RET_STS_ERROR;
2016: END;
2017:
2018:
2019: BEGIN

Line 2078: x_return_status := FND_API.G_RET_STS_ERROR;

2074: and (enable_flag IS NULL OR enable_flag='Y'); -- Fix for Bug 3773450
2075:
2076: if(l_orig_service_request_id<>l_service_request_id) then
2077: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_SERVICE_REQUEST_EXISTS');
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: end if;
2080: end if;
2081:
2082: end if;

Line 2101: x_return_status := FND_API.G_RET_STS_ERROR;

2097: end if;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102:
2103: END;
2104:
2105: IF FND_API.TO_BOOLEAN(P_COMMIT)

Line 2105: IF FND_API.TO_BOOLEAN(P_COMMIT)

2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102:
2103: END;
2104:
2105: IF FND_API.TO_BOOLEAN(P_COMMIT)
2106: THEN
2107: COMMIT WORK;
2108: END IF;
2109:

Line 2332: x_return_status := FND_API.G_RET_STS_ERROR;

2328:
2329: EXCEPTION WHEN OTHERS THEN
2330: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_GENERIC_ERROR',
2331: p_token1 => 'EAM_ERROR', p_value1 => SQLERRM);
2332: x_return_status := FND_API.G_RET_STS_ERROR;
2333: END;
2334:
2335: x_return_status := l_return_status;
2336: x_msg_count := FND_MSG_PUB.count_msg;

Line 2340: RAISE FND_API.G_EXC_ERROR;

2336: x_msg_count := FND_MSG_PUB.count_msg;
2337:
2338: if(x_return_status<>'S') then
2339: ROLLBACK TO create_easy_work_order;
2340: RAISE FND_API.G_EXC_ERROR;
2341: end if;
2342:
2343: -- assign out parameters
2344: x_new_work_order_name := l_workorder_rec1.wip_entity_name;

Line 2402: x_return_status := FND_API.G_RET_STS_ERROR;

2398: end if;
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_EZWO_BAD_SERVICE_REQUEST');
2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403:
2404: END;
2405:
2406: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

Line 2406: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2402: x_return_status := FND_API.G_RET_STS_ERROR;
2403:
2404: END;
2405:
2406: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2407: COMMIT WORK;
2408: END IF;
2409:
2410:

Line 2486: RAISE FND_API.G_EXC_ERROR;

2482: x_msg_count := FND_MSG_PUB.count_msg;
2483:
2484: if(x_return_status<>'S') then
2485: ROLLBACK TO create_relationship;
2486: RAISE FND_API.G_EXC_ERROR;
2487: end if;
2488:
2489: end if;--End of creating relationship
2490:

Line 2491: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2487: end if;
2488:
2489: end if;--End of creating relationship
2490:
2491: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2492: COMMIT WORK;
2493: END IF;
2494:
2495:

Line 2498: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN

2494:
2495:
2496: end if; -- End of Create Work Order
2497:
2498: IF FND_API.TO_BOOLEAN(P_COMMIT) THEN
2499: COMMIT WORK;
2500: END IF;
2501:
2502: EXCEPTION WHEN OTHERS THEN -- all dml excpetion

Line 2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2501:
2502: EXCEPTION WHEN OTHERS THEN -- all dml excpetion
2503: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2504: , p_token1 => 'TEXT', p_value1 => SQLERRM);
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506:
2507: l_msg_count := FND_MSG_PUB.count_msg;
2508: IF l_msg_count = 1 THEN
2509: eam_execution_jsp.Get_Messages

Line 2510: (p_encoded => FND_API.G_FALSE,

2506:
2507: l_msg_count := FND_MSG_PUB.count_msg;
2508: IF l_msg_count = 1 THEN
2509: eam_execution_jsp.Get_Messages
2510: (p_encoded => FND_API.G_FALSE,
2511: p_msg_index => 1,
2512: p_msg_count => l_msg_count,
2513: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2514: p_data => l_data,

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

2509: eam_execution_jsp.Get_Messages
2510: (p_encoded => FND_API.G_FALSE,
2511: p_msg_index => 1,
2512: p_msg_count => l_msg_count,
2513: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2514: p_data => l_data,
2515: p_msg_index_out => l_msg_index_out);
2516: x_msg_count := l_msg_count;
2517: x_msg_data := l_msg_data;

Line 2526: FND_API.G_EXC_UNEXPECTED_ERROR THEN

2522:
2523:
2524: EXCEPTION
2525: WHEN
2526: FND_API.G_EXC_UNEXPECTED_ERROR THEN
2527: IF p_commit = FND_API.G_TRUE THEN
2528: ROLLBACK TO create_easy_work_order;
2529: END IF;
2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

Line 2527: IF p_commit = FND_API.G_TRUE THEN

2523:
2524: EXCEPTION
2525: WHEN
2526: FND_API.G_EXC_UNEXPECTED_ERROR THEN
2527: IF p_commit = FND_API.G_TRUE THEN
2528: ROLLBACK TO create_easy_work_order;
2529: END IF;
2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2531: p_procedure_name => EAM_DEBUG.G_err_stack);

Line 2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2528: ROLLBACK TO create_easy_work_order;
2529: END IF;
2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2531: p_procedure_name => EAM_DEBUG.G_err_stack);
2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: IF p_commit = FND_API.G_TRUE THEN
2535: ROLLBACK TO create_easy_work_order;
2536: END IF;

Line 2533: WHEN FND_API.G_EXC_ERROR THEN

2529: END IF;
2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2531: p_procedure_name => EAM_DEBUG.G_err_stack);
2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: IF p_commit = FND_API.G_TRUE THEN
2535: ROLLBACK TO create_easy_work_order;
2536: END IF;
2537:

Line 2534: IF p_commit = FND_API.G_TRUE THEN

2530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2531: p_procedure_name => EAM_DEBUG.G_err_stack);
2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2533: WHEN FND_API.G_EXC_ERROR THEN
2534: IF p_commit = FND_API.G_TRUE THEN
2535: ROLLBACK TO create_easy_work_order;
2536: END IF;
2537:
2538: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

Line 2540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2536: END IF;
2537:
2538: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2539: p_procedure_name => EAM_DEBUG.G_err_stack);
2540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2541:
2542: WHEN OTHERS THEN -- all dml excpetion
2543: IF p_commit = FND_API.G_TRUE THEN
2544: ROLLBACK TO create_easy_work_order;

Line 2543: IF p_commit = FND_API.G_TRUE THEN

2539: p_procedure_name => EAM_DEBUG.G_err_stack);
2540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2541:
2542: WHEN OTHERS THEN -- all dml excpetion
2543: IF p_commit = FND_API.G_TRUE THEN
2544: ROLLBACK TO create_easy_work_order;
2545: END IF;
2546:
2547: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',

Line 2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2545: END IF;
2546:
2547: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'eam_workorders_jsp.CREATE_EASY_WORK_ORDER',
2548: p_procedure_name => EAM_DEBUG.G_err_stack);
2549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2550:
2551: end create_ez_work_order;
2552:
2553:

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

2558: -- update work order, not involved in changes that could invoke transaction
2559: -----------------------------------------------------------------------------------
2560: procedure update_work_order
2561: ( p_api_version IN NUMBER := 1.0
2562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2565: ,p_record_version_number IN NUMBER := NULL
2566: ,x_return_status OUT NOCOPY VARCHAR2

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

2559: -----------------------------------------------------------------------------------
2560: procedure update_work_order
2561: ( p_api_version IN NUMBER := 1.0
2562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2565: ,p_record_version_number IN NUMBER := NULL
2566: ,x_return_status OUT NOCOPY VARCHAR2
2567: ,x_msg_count OUT NOCOPY NUMBER

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

2560: procedure update_work_order
2561: ( p_api_version IN NUMBER := 1.0
2562: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2563: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2564: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2565: ,p_record_version_number IN NUMBER := NULL
2566: ,x_return_status OUT NOCOPY VARCHAR2
2567: ,x_msg_count OUT NOCOPY NUMBER
2568: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2606: IF p_commit = FND_API.G_TRUE THEN

2602: l_duration NUMBER;
2603:
2604: BEGIN
2605:
2606: IF p_commit = FND_API.G_TRUE THEN
2607: SAVEPOINT complete_workorder;
2608: END IF;
2609:
2610: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');

Line 2612: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

2608: END IF;
2609:
2610: eam_debug.init_err_stack('eam_workorders_jsp.update_work_order');
2611:
2612: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2613: p_api_version,
2614: l_api_name,
2615: g_pkg_name)
2616: THEN

Line 2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2613: p_api_version,
2614: l_api_name,
2615: g_pkg_name)
2616: THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2618: END IF;
2619:
2620: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2621: THEN

Line 2620: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2616: THEN
2617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2618: END IF;
2619:
2620: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2621: THEN
2622: FND_MSG_PUB.initialize;
2623: END IF;
2624:

Line 2625: x_return_status := FND_API.G_RET_STS_SUCCESS;

2621: THEN
2622: FND_MSG_PUB.initialize;
2623: END IF;
2624:
2625: x_return_status := FND_API.G_RET_STS_SUCCESS;
2626:
2627: -- check if data is stale or not
2628: -- using last_update_date as indicator
2629: BEGIN

Line 2640: x_return_status := FND_API.G_RET_STS_ERROR;

2636: FOR UPDATE;
2637:
2638: IF l_db_last_update_date <> p_stored_last_update_date THEN
2639: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_STALED_DATA');
2640: x_return_status := FND_API.G_RET_STS_ERROR;
2641: END IF;
2642: EXCEPTION WHEN OTHERS THEN
2643: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
2644: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2644: x_return_status := FND_API.G_RET_STS_ERROR;

2640: x_return_status := FND_API.G_RET_STS_ERROR;
2641: END IF;
2642: EXCEPTION WHEN OTHERS THEN
2643: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_NOT_FOUND');
2644: x_return_status := FND_API.G_RET_STS_ERROR;
2645: END;
2646:
2647: BEGIN
2648: select department_id

Line 2656: x_return_status := FND_API.G_RET_STS_ERROR;

2652: and department_code = p_owning_department;
2653:
2654: EXCEPTION WHEN OTHERS THEN
2655: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_DEPT_NOT_FOUND');
2656: x_return_status := FND_API.G_RET_STS_ERROR;
2657: END;
2658:
2659: if( p_firm_planned_flag = 1) then
2660: if(p_scheduled_start_date is null) then

Line 2662: x_return_status := FND_API.G_RET_STS_ERROR;

2658:
2659: if( p_firm_planned_flag = 1) then
2660: if(p_scheduled_start_date is null) then
2661: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_UPDATE_DATE_MISS');
2662: x_return_status := FND_API.G_RET_STS_ERROR;
2663: end if;
2664: end if;
2665:
2666: -- if validate not passed then raise error

Line 2670: (p_encoded => FND_API.G_FALSE,

2666: -- if validate not passed then raise error
2667: l_msg_count := FND_MSG_PUB.count_msg;
2668: IF l_msg_count = 1 THEN
2669: eam_execution_jsp.Get_Messages
2670: (p_encoded => FND_API.G_FALSE,
2671: p_msg_index => 1,
2672: p_msg_count => l_msg_count,
2673: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2674: p_data => l_data,

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

2669: eam_execution_jsp.Get_Messages
2670: (p_encoded => FND_API.G_FALSE,
2671: p_msg_index => 1,
2672: p_msg_count => l_msg_count,
2673: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2674: p_data => l_data,
2675: p_msg_index_out => l_msg_index_out);
2676: x_msg_count := l_msg_count;
2677: x_msg_data := l_msg_data;

Line 2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2679: x_msg_count := l_msg_count;
2680: END IF;
2681:
2682: IF l_msg_count > 0 THEN
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2684: RAISE FND_API.G_EXC_ERROR;
2685: END IF;
2686:
2687: -- call processing logic

Line 2684: RAISE FND_API.G_EXC_ERROR;

2680: END IF;
2681:
2682: IF l_msg_count > 0 THEN
2683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2684: RAISE FND_API.G_EXC_ERROR;
2685: END IF;
2686:
2687: -- call processing logic
2688: BEGIN

Line 2734: x_return_status := FND_API.G_RET_STS_ERROR;

2730: end if;
2731: EXCEPTION WHEN OTHERS THEN
2732: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_WO_EXCEPTION'
2733: ,p_token1 => 'TEXT', p_value1 => SQLERRM);
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: END;
2736:
2737: -- if DML not passed then raise error
2738: l_msg_count := FND_MSG_PUB.count_msg;

Line 2741: (p_encoded => FND_API.G_FALSE,

2737: -- if DML not passed then raise error
2738: l_msg_count := FND_MSG_PUB.count_msg;
2739: IF l_msg_count = 1 THEN
2740: eam_execution_jsp.Get_Messages
2741: (p_encoded => FND_API.G_FALSE,
2742: p_msg_index => 1,
2743: p_msg_count => l_msg_count,
2744: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2745: p_data => l_data,

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

2740: eam_execution_jsp.Get_Messages
2741: (p_encoded => FND_API.G_FALSE,
2742: p_msg_index => 1,
2743: p_msg_count => l_msg_count,
2744: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR) ,
2745: p_data => l_data,
2746: p_msg_index_out => l_msg_index_out);
2747: x_msg_count := l_msg_count;
2748: x_msg_data := l_msg_data;

Line 2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2750: x_msg_count := l_msg_count;
2751: END IF;
2752:
2753: IF l_msg_count > 0 THEN
2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758:

Line 2755: RAISE FND_API.G_EXC_ERROR;

2751: END IF;
2752:
2753: IF l_msg_count > 0 THEN
2754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758:
2759: IF FND_API.TO_BOOLEAN(P_COMMIT)

Line 2759: IF FND_API.TO_BOOLEAN(P_COMMIT)

2755: RAISE FND_API.G_EXC_ERROR;
2756: END IF;
2757:
2758:
2759: IF FND_API.TO_BOOLEAN(P_COMMIT)
2760: THEN
2761: COMMIT WORK;
2762: END IF;
2763:

Line 2764: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2760: THEN
2761: COMMIT WORK;
2762: END IF;
2763:
2764: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2765: IF p_commit = FND_API.G_TRUE THEN
2766: ROLLBACK TO complete_workorder;
2767: END IF;
2768:

Line 2765: IF p_commit = FND_API.G_TRUE THEN

2761: COMMIT WORK;
2762: END IF;
2763:
2764: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2765: IF p_commit = FND_API.G_TRUE THEN
2766: ROLLBACK TO complete_workorder;
2767: END IF;
2768:
2769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

Line 2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2767: END IF;
2768:
2769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2770: p_procedure_name => EAM_DEBUG.G_err_stack);
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: IF p_commit = FND_API.G_TRUE THEN
2774: ROLLBACK TO complete_workorder;
2775: END IF;

Line 2772: WHEN FND_API.G_EXC_ERROR THEN

2768:
2769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2770: p_procedure_name => EAM_DEBUG.G_err_stack);
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: IF p_commit = FND_API.G_TRUE THEN
2774: ROLLBACK TO complete_workorder;
2775: END IF;
2776:

Line 2773: IF p_commit = FND_API.G_TRUE THEN

2769: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2770: p_procedure_name => EAM_DEBUG.G_err_stack);
2771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2772: WHEN FND_API.G_EXC_ERROR THEN
2773: IF p_commit = FND_API.G_TRUE THEN
2774: ROLLBACK TO complete_workorder;
2775: END IF;
2776:
2777: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

Line 2779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2775: END IF;
2776:
2777: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2778: p_procedure_name => EAM_DEBUG.G_err_stack);
2779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2780: WHEN OTHERS THEN
2781: IF p_commit = FND_API.G_TRUE THEN
2782: ROLLBACK TO complete_workorder;
2783: END IF;

Line 2781: IF p_commit = FND_API.G_TRUE THEN

2777: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2778: p_procedure_name => EAM_DEBUG.G_err_stack);
2779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2780: WHEN OTHERS THEN
2781: IF p_commit = FND_API.G_TRUE THEN
2782: ROLLBACK TO complete_workorder;
2783: END IF;
2784:
2785: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',

Line 2787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2783: END IF;
2784:
2785: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'EAM_WORKORDERS_JSP.update_work_order',
2786: p_procedure_name => EAM_DEBUG.G_err_stack);
2787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2788: END update_work_order;
2789:
2790: procedure get_completion_defaults (
2791: p_wip_entity_id in number

Line 2889: x_return_status := FND_API.G_RET_STS_SUCCESS;

2885: x_end_date := SYSDATE;
2886: END IF;
2887:
2888:
2889: x_return_status := FND_API.G_RET_STS_SUCCESS;
2890: x_msg_data := x_msg_data ||
2891: 'x_start_date = ' || to_char(x_start_date, 'MMM-DD-YYYY HH24:MI:SS')
2892: || ', x_end_date = ' || to_char(x_end_date, 'MMM-DD-YYYY HH24:MI:SS')
2893: || ', l_max_op_end_date=' || to_char(l_max_op_end_date, 'MMM-DD-YYYY HH24:MI:SS')

Line 2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2894: || ', l_sched_start_date=' || to_char(l_sched_start_date, 'MMM-DD-YYYY HH24:MI:SS')
2895: || ', l_sched_end_date=' || to_char(l_sched_end_date, 'MMM-DD-YYYY HH24:MI:SS');
2896: exception
2897: when others then
2898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2899: x_msg_data := x_msg_data || ' UNEXPECTED ERROR: ' || SQLERRM;
2900: eam_debug.init_err_stack('Exception has occured in ' || l_api_name);
2901: end get_completion_defaults;
2902:

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

2902:
2903:
2904: procedure Add_WorkOrder_Dependency (
2905: p_api_version IN NUMBER := 1.0
2906: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2907: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2908: ,p_organization_id IN NUMBER
2909: ,p_prior_object_id IN NUMBER
2910: ,p_prior_object_type_id IN NUMBER

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

2903:
2904: procedure Add_WorkOrder_Dependency (
2905: p_api_version IN NUMBER := 1.0
2906: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
2907: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2908: ,p_organization_id IN NUMBER
2909: ,p_prior_object_id IN NUMBER
2910: ,p_prior_object_type_id IN NUMBER
2911: ,p_next_object_id IN NUMBER

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

2917:
2918: l_api_name constant varchar2(30) := 'Add_WorkOrder_Dependency';
2919: l_api_version CONSTANT NUMBER := 1.0;
2920: l_msg_data VARCHAR2(10000) ;
2921: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2922: l_msg_count NUMBER;
2923: l_message_text VARCHAR2(1000);
2924:
2925: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;

Line 2968: IF p_commit = FND_API.G_TRUE THEN

2964:
2965:
2966: begin
2967:
2968: IF p_commit = FND_API.G_TRUE THEN
2969: SAVEPOINT CREATE_DEPENDENT_WORK_ORDER;
2970: END IF;
2971:
2972: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 2972: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

2968: IF p_commit = FND_API.G_TRUE THEN
2969: SAVEPOINT CREATE_DEPENDENT_WORK_ORDER;
2970: END IF;
2971:
2972: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
2973: p_api_version,
2974: l_api_name,
2975: g_pkg_name)
2976: THEN

Line 2977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2973: p_api_version,
2974: l_api_name,
2975: g_pkg_name)
2976: THEN
2977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2978: END IF;
2979:
2980: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2981: THEN

Line 2980: IF FND_API.TO_BOOLEAN(p_init_msg_list)

2976: THEN
2977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2978: END IF;
2979:
2980: IF FND_API.TO_BOOLEAN(p_init_msg_list)
2981: THEN
2982: FND_MSG_PUB.initialize;
2983: END IF;
2984:

Line 2986: x_return_status := FND_API.G_RET_STS_ERROR;

2982: FND_MSG_PUB.initialize;
2983: END IF;
2984:
2985: IF p_prior_object_id = 0000 OR p_next_object_id = 0000 THEN
2986: x_return_status := FND_API.G_RET_STS_ERROR;
2987: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_NOT_ENOUGH_VALUES');
2988: return;
2989: END IF;
2990:

Line 3060: , p_commit => FND_API.G_TRUE

3056: , x_eam_request_tbl => l_out_eam_request_tbl
3057: , x_return_status => l_return_status
3058: , x_msg_count => l_msg_count
3059: -- , x_error_msg_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.error_tbl_type
3060: , p_commit => FND_API.G_TRUE
3061: , p_debug => NVL(fnd_profile.value('EAM_DEBUG'), 'N')
3062: , p_debug_filename => 'adddepen.log'
3063: , p_output_dir => l_output_dir
3064: , p_debug_file_mode => 'W'

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

3069: x_return_status := l_return_status;
3070: x_msg_count := l_msg_count;
3071:
3072:
3073: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3074: IF p_commit = FND_API.G_TRUE THEN
3075: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3076: END IF;
3077: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,

Line 3074: IF p_commit = FND_API.G_TRUE THEN

3070: x_msg_count := l_msg_count;
3071:
3072:
3073: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3074: IF p_commit = FND_API.G_TRUE THEN
3075: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3076: END IF;
3077: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,
3078: p_encoded => 'F',

Line 3090: IF p_commit = FND_API.G_TRUE THEN

3086: APP_EXCEPTION.RAISE_EXCEPTION;
3087:
3088: END IF;
3089:
3090: IF p_commit = FND_API.G_TRUE THEN
3091: COMMIT WORK;
3092: end if;
3093:
3094: EXCEPTION

Line 3097: IF p_commit = FND_API.G_TRUE THEN

3093:
3094: EXCEPTION
3095:
3096: when others then
3097: IF p_commit = FND_API.G_TRUE THEN
3098: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3099: END IF;
3100:
3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3097: IF p_commit = FND_API.G_TRUE THEN
3098: ROLLBACK TO CREATE_DEPENDENT_WORK_ORDER;
3099: END IF;
3100:
3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3102: return;
3103:
3104:
3105: end Add_WorkOrder_Dependency;

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

3106:
3107:
3108: procedure Delete_WorkOrder_Dependency (
3109: p_api_version IN NUMBER := 1.0
3110: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3111: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3112: ,p_organization_id IN NUMBER
3113: ,p_prior_object_id IN NUMBER
3114: ,p_prior_object_type_id IN NUMBER

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

3107:
3108: procedure Delete_WorkOrder_Dependency (
3109: p_api_version IN NUMBER := 1.0
3110: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
3111: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
3112: ,p_organization_id IN NUMBER
3113: ,p_prior_object_id IN NUMBER
3114: ,p_prior_object_type_id IN NUMBER
3115: ,p_next_object_id IN NUMBER

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

3146: l_eam_direct_items_tbl_1 EAM_PROCESS_WO_PUB.eam_direct_items_tbl_type;
3147:
3148: l_eam_wo_relations_rec EAM_PROCESS_WO_PUB.eam_wo_relations_rec_type;
3149:
3150: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3151: l_msg_count NUMBER;
3152: l_message_text VARCHAR2(1000);
3153: l_output_dir VARCHAR2(512);
3154: l_eam_wo_comp_tbl EAM_PROCESS_WO_PUB.eam_wo_comp_tbl_type;

Line 3174: IF p_commit = FND_API.G_TRUE THEN

3170: l_eam_res_usage_tbl EAM_PROCESS_WO_PUB.eam_res_usage_tbl_type;
3171:
3172: begin
3173:
3174: IF p_commit = FND_API.G_TRUE THEN
3175: SAVEPOINT DELETE_DEPENDEND_WORK_ORDER;
3176: END IF;
3177:
3178: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

Line 3178: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

3174: IF p_commit = FND_API.G_TRUE THEN
3175: SAVEPOINT DELETE_DEPENDEND_WORK_ORDER;
3176: END IF;
3177:
3178: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
3179: p_api_version,
3180: l_api_name,
3181: g_pkg_name)
3182: THEN

Line 3183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3179: p_api_version,
3180: l_api_name,
3181: g_pkg_name)
3182: THEN
3183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3184: END IF;
3185:
3186: IF FND_API.TO_BOOLEAN(p_init_msg_list)
3187: THEN

Line 3186: IF FND_API.TO_BOOLEAN(p_init_msg_list)

3182: THEN
3183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3184: END IF;
3185:
3186: IF FND_API.TO_BOOLEAN(p_init_msg_list)
3187: THEN
3188: FND_MSG_PUB.initialize;
3189: END IF;
3190:

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

3263: l_msg_count := FND_MSG_PUB.count_msg;
3264: x_return_status := l_return_status;
3265: x_msg_count := l_msg_count;
3266:
3267: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3268: IF p_commit = FND_API.G_TRUE THEN
3269: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3270: END IF;
3271:

Line 3268: IF p_commit = FND_API.G_TRUE THEN

3264: x_return_status := l_return_status;
3265: x_msg_count := l_msg_count;
3266:
3267: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3268: IF p_commit = FND_API.G_TRUE THEN
3269: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3270: END IF;
3271:
3272: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,

Line 3284: IF FND_API.TO_BOOLEAN(p_commit)THEN

3280: translate => FALSE);
3281:
3282: APP_EXCEPTION.RAISE_EXCEPTION;
3283: ELSE
3284: IF FND_API.TO_BOOLEAN(p_commit)THEN
3285: COMMIT WORK;
3286: END IF;
3287: END IF;
3288:

Line 3293: IF p_commit = FND_API.G_TRUE THEN

3289:
3290: EXCEPTION
3291:
3292: when others then
3293: IF p_commit = FND_API.G_TRUE THEN
3294: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3295: END IF;
3296:
3297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3293: IF p_commit = FND_API.G_TRUE THEN
3294: ROLLBACK TO DELETE_DEPENDEND_WORK_ORDER;
3295: END IF;
3296:
3297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3298: return;
3299: end Delete_WorkOrder_Dependency;
3300:
3301: -- Start of comments

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

3304: -- Function : Creates the costing hierarchy from the scheduling hierarchy.
3305: -- Pre-reqs : None.
3306: -- Parameters :
3307: -- IN p_api_version IN NUMBER
3308: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
3309: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3310: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3311: -- p_top_level_object_id IN VARCHAR2
3312: -- OUT x_return_status OUT NOCOPY NUMBER

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

3305: -- Pre-reqs : None.
3306: -- Parameters :
3307: -- IN p_api_version IN NUMBER
3308: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
3309: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3310: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3311: -- p_top_level_object_id IN VARCHAR2
3312: -- OUT x_return_status OUT NOCOPY NUMBER
3313: -- x_msg_count OUT NOCOPY NUMBER

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

3306: -- Parameters :
3307: -- IN p_api_version IN NUMBER
3308: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_TRUE
3309: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3310: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3311: -- p_top_level_object_id IN VARCHAR2
3312: -- OUT x_return_status OUT NOCOPY NUMBER
3313: -- x_msg_count OUT NOCOPY NUMBER
3314: -- x_msg_data OUT NOCOPY VARCHAR2

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

3318: --
3319: -- End of comments
3320: procedure create_cost_hierarchy_pvt(
3321: p_api_version IN NUMBER :=1.0 ,
3322: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3323: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3324: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3325: p_wip_entity_id IN VARCHAR2,
3326: p_org_id IN VARCHAR2,

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

3319: -- End of comments
3320: procedure create_cost_hierarchy_pvt(
3321: p_api_version IN NUMBER :=1.0 ,
3322: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3323: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3324: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3325: p_wip_entity_id IN VARCHAR2,
3326: p_org_id IN VARCHAR2,
3327: x_return_status OUT NOCOPY VARCHAR2 ,

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

3320: procedure create_cost_hierarchy_pvt(
3321: p_api_version IN NUMBER :=1.0 ,
3322: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3323: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3324: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3325: p_wip_entity_id IN VARCHAR2,
3326: p_org_id IN VARCHAR2,
3327: x_return_status OUT NOCOPY VARCHAR2 ,
3328: x_msg_count OUT NOCOPY NUMBER ,

Line 3420: IF NOT FND_API.compatible_api_call(

3416:
3417: BEGIN
3418: SAVEPOINT create_cost_hierarchy;
3419:
3420: IF NOT FND_API.compatible_api_call(
3421: l_api_version
3422: ,p_api_version
3423: ,l_api_name
3424: ,g_pkg_name) THEN

Line 3425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3421: l_api_version
3422: ,p_api_version
3423: ,l_api_name
3424: ,g_pkg_name) THEN
3425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3426: END IF;
3427:
3428: -- Initialize message list if p_init_msg_list is set to TRUE.
3429: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3429: IF FND_API.to_boolean(p_init_msg_list) THEN

3425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3426: END IF;
3427:
3428: -- Initialize message list if p_init_msg_list is set to TRUE.
3429: IF FND_API.to_boolean(p_init_msg_list) THEN
3430: FND_MSG_PUB.initialize;
3431: END IF;
3432:
3433: -- Initialize API return status to success

Line 3434: x_return_status := FND_API.g_ret_sts_success;

3430: FND_MSG_PUB.initialize;
3431: END IF;
3432:
3433: -- Initialize API return status to success
3434: x_return_status := FND_API.g_ret_sts_success;
3435:
3436: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
3437:
3438: FOR c_hierarchy_row IN c_work_hierarchy

Line 3453: p_commit => FND_API.G_TRUE

3449:
3450:
3451: -- Delete the record if exists. The child WO cannot have more than 1 parent.
3452: EAM_WORKORDERS_JSP.Delete_WorkOrder_Dependency (
3453: p_commit => FND_API.G_TRUE
3454: ,p_prior_object_type_id => 1
3455: ,p_next_object_type_id => 1
3456: ,p_organization_id => p_org_id
3457: ,p_prior_object_id => l_parent_object_id

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

3462: ,x_msg_data => x_msg_data
3463: );
3464:
3465:
3466: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3467: /* Create a new relationship between the parent and the child workorder taken from the scheduling hierarchy. */
3468: l_parent_id := c_hierarchy_row.parent_object_id ;
3469: l_child_wip_id := c_hierarchy_row.child_object_id ;
3470: l_eam_wo_relations_rec.batch_id := 1;

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

3527: , p_commit => p_commit
3528: , p_debug_file_mode => 'A'
3529: );
3530:
3531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3534: END IF;
3535: ELSE

Line 3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3528: , p_debug_file_mode => 'A'
3529: );
3530:
3531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3534: END IF;
3535: ELSE
3536: -- if there is any exception then rollback and come out of the procedure.

Line 3533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3529: );
3530:
3531: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3534: END IF;
3535: ELSE
3536: -- if there is any exception then rollback and come out of the procedure.
3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3534: END IF;
3535: ELSE
3536: -- if there is any exception then rollback and come out of the procedure.
3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3539: END IF;
3540:
3541: EXCEPTION

Line 3538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3534: END IF;
3535: ELSE
3536: -- if there is any exception then rollback and come out of the procedure.
3537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3539: END IF;
3540:
3541: EXCEPTION
3542: -- If there is no parent with type '3' for the workorder, then simply create a new relationship.

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

3605: , p_commit => p_commit
3606: , p_debug_file_mode => 'A'
3607: );
3608:
3609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: WHEN OTHERS THEN

Line 3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3606: , p_debug_file_mode => 'A'
3607: );
3608:
3609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: WHEN OTHERS THEN
3614:

Line 3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3607: );
3608:
3609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: WHEN OTHERS THEN
3614:
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3612: END IF;
3613: WHEN OTHERS THEN
3614:
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3617: END;
3618: END LOOP;
3619:

Line 3616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3612: END IF;
3613: WHEN OTHERS THEN
3614:
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3617: END;
3618: END LOOP;
3619:
3620:

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

3618: END LOOP;
3619:
3620:
3621:
3622: IF ((FND_API.TO_BOOLEAN(p_commit)) AND (x_return_status = FND_API.G_RET_STS_SUCCESS)) THEN
3623: COMMIT WORK;
3624: END IF;
3625:
3626: EXCEPTION

Line 3627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3623: COMMIT WORK;
3624: END IF;
3625:
3626: EXCEPTION
3627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3628: ROLLBACK TO create_cost_hierarchy;
3629: FND_MSG_PUB.add_exc_msg( p_pkg_name => l_full_name,
3630: p_procedure_name => l_api_name);
3631: WHEN OTHERS THEN

Line 3635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3631: WHEN OTHERS THEN
3632: ROLLBACK TO create_cost_hierarchy;
3633: FND_MSG_PUB.add_exc_msg( p_pkg_name => l_full_name,
3634: p_procedure_name => l_api_name);
3635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3636:
3637: END create_cost_hierarchy_pvt;
3638:
3639: -- Start of comments

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

3642: -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
3643: -- Pre-reqs : None.
3644: -- Parameters :
3645: -- IN p_api_version IN NUMBER
3646: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
3647: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3648: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3649: -- p_object_id IN NUMBER
3650: -- p_object_type_id IN NUMBER

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

3643: -- Pre-reqs : None.
3644: -- Parameters :
3645: -- IN p_api_version IN NUMBER
3646: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
3647: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3648: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3649: -- p_object_id IN NUMBER
3650: -- p_object_type_id IN NUMBER
3651: -- p_schedule_start_date IN DATE

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

3644: -- Parameters :
3645: -- IN p_api_version IN NUMBER
3646: -- p_init_msg_list IN VARCHAR2 Default = FND_API.G_FALSE
3647: -- p_commit IN VARCHAR2 Default = FND_API.G_FALSE
3648: -- p_validation_level IN NUMBER Default = FND_API.G_VALID_LEVEL_FULL
3649: -- p_object_id IN NUMBER
3650: -- p_object_type_id IN NUMBER
3651: -- p_schedule_start_date IN DATE
3652: -- p_schedule_end_date IN DATE

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

3666:
3667: /*Bug3521886: Pass requested start date and due date*/
3668: PROCEDURE resize_wo_hierarchy_pvt(
3669: p_api_version IN NUMBER ,
3670: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3671: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3672: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3673: p_object_id IN NUMBER,
3674: p_object_type_id IN NUMBER,

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

3667: /*Bug3521886: Pass requested start date and due date*/
3668: PROCEDURE resize_wo_hierarchy_pvt(
3669: p_api_version IN NUMBER ,
3670: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3671: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3672: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3673: p_object_id IN NUMBER,
3674: p_object_type_id IN NUMBER,
3675: p_schedule_start_date IN DATE,

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

3668: PROCEDURE resize_wo_hierarchy_pvt(
3669: p_api_version IN NUMBER ,
3670: p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE,
3671: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
3672: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
3673: p_object_id IN NUMBER,
3674: p_object_type_id IN NUMBER,
3675: p_schedule_start_date IN DATE,
3676: p_schedule_end_date IN DATE,

Line 3699: IF NOT FND_API.compatible_api_call(

3695: -- Standard Start of API savepoint
3696: SAVEPOINT resize_wo_hierarchy_pvt;
3697:
3698: -- Standard call to check for call compatibility.
3699: IF NOT FND_API.compatible_api_call(
3700: l_api_version
3701: ,p_api_version
3702: ,l_api_name
3703: ,g_pkg_name) THEN

Line 3704: RAISE fnd_api.g_exc_unexpected_error;

3700: l_api_version
3701: ,p_api_version
3702: ,l_api_name
3703: ,g_pkg_name) THEN
3704: RAISE fnd_api.g_exc_unexpected_error;
3705: END IF;
3706:
3707: -- Initialize message list if p_init_msg_list is set to TRUE.
3708: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 3708: IF FND_API.to_boolean(p_init_msg_list) THEN

3704: RAISE fnd_api.g_exc_unexpected_error;
3705: END IF;
3706:
3707: -- Initialize message list if p_init_msg_list is set to TRUE.
3708: IF FND_API.to_boolean(p_init_msg_list) THEN
3709: FND_MSG_PUB.initialize;
3710: END IF;
3711:
3712: -- Initialize API return status to success

Line 3713: x_return_status := FND_API.g_ret_sts_success;

3709: FND_MSG_PUB.initialize;
3710: END IF;
3711:
3712: -- Initialize API return status to success
3713: x_return_status := FND_API.g_ret_sts_success;
3714:
3715: -- API body
3716: IF (p_schedule_end_date IS NULL) THEN
3717: l_schedule_end_date := p_schedule_start_date + (p_duration_for_shifting / 24);

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

3734: x_return_status => x_return_status,
3735: x_msg_count => x_msg_count,
3736: x_msg_data => x_msg_data);
3737: -- End of API body
3738: IF (x_return_status = FND_API.g_ret_sts_success) THEN
3739: IF FND_API.TO_BOOLEAN(p_commit)THEN
3740: COMMIT WORK;
3741: END IF;
3742: END IF;

Line 3739: IF FND_API.TO_BOOLEAN(p_commit)THEN

3735: x_msg_count => x_msg_count,
3736: x_msg_data => x_msg_data);
3737: -- End of API body
3738: IF (x_return_status = FND_API.g_ret_sts_success) THEN
3739: IF FND_API.TO_BOOLEAN(p_commit)THEN
3740: COMMIT WORK;
3741: END IF;
3742: END IF;
3743:

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

3748: );
3749: IF x_msg_count > 0 THEN
3750: FOR indexCount IN 1 ..x_msg_count
3751: LOOP
3752: l_msg_data := FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
3753: -- DBMS_OUTPUT.PUT_LINE(indexCount ||'-'||l_msg_data);
3754: END LOOP;
3755: END IF;
3756:

Line 3760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3756:
3757: EXCEPTION
3758: WHEN OTHERS THEN
3759: ROLLBACK TO resize_wo_hierarchy_pvt;
3760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3761:
3762:
3763:
3764: END resize_wo_hierarchy_pvt;