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_RES_INST_VALIDATE_PVT dependencies on EAM_PROCESS_WO_PVT

Line 59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Resource Instance'); END IF;

55: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
56: l_return_status VARCHAR2(1);
57: BEGIN
58:
59: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Quering Resource Instance'); END IF;
60:
61: EAM_RES_INST_UTILITY_PVT.Query_Row
62: ( p_wip_entity_id => p_eam_res_inst_rec.wip_entity_id
63: , p_organization_id => p_eam_res_inst_rec.organization_id

Line 72: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;

68: , x_eam_res_inst_rec => x_old_eam_res_inst_rec
69: , x_Return_status => l_return_status
70: );
71:
72: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
73:
74: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
75: p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
76: THEN

Line 74: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND

70: );
71:
72: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
73:
74: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
75: p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
76: THEN
77: l_token_tbl(1).token_name := 'INSTANCE_NAME';
78:

Line 75: p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

71:
72: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Query Row Returned with : ' || l_return_status); END IF;
73:
74: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND AND
75: p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
76: THEN
77: l_token_tbl(1).token_name := 'INSTANCE_NAME';
78:
79: if p_eam_res_inst_rec.SERIAL_NUMBER is null then

Line 104: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND

100: l_mesg_token_tbl := l_out_mesg_token_tbl;
101:
102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
105: p_eam_res_inst_rec.transaction_type IN
106: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
107: THEN
108: l_token_tbl(1).token_name := 'INSTANCE_NAME';

Line 106: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

102: l_return_status := FND_API.G_RET_STS_ERROR;
103:
104: ELSIF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND AND
105: p_eam_res_inst_rec.transaction_type IN
106: (EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
107: THEN
108: l_token_tbl(1).token_name := 'INSTANCE_NAME';
109: -- l_token_tbl(1).token_value := p_eam_res_inst_rec.instance_id;
110:

Line 148: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN

144: l_mesg_token_tbl := l_out_mesg_token_tbl;
145: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: ELSE /* Assign the relevant transaction type for SYNC operations */
148: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
149: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
150: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
151: ELSE
152: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

Line 149: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN

145: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146:
147: ELSE /* Assign the relevant transaction type for SYNC operations */
148: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
149: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
150: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
151: ELSE
152: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
153: END IF;

Line 150: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;

146:
147: ELSE /* Assign the relevant transaction type for SYNC operations */
148: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
149: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
150: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
151: ELSE
152: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
153: END IF;
154: END IF;

Line 152: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

148: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_SYNC THEN
149: IF l_return_status = EAM_PROCESS_WO_PVT.G_RECORD_FOUND THEN
150: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_UPDATE;
151: ELSE
152: x_old_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
153: END IF;
154: END IF;
155: l_return_status := FND_API.G_RET_STS_SUCCESS;
156:

Line 192: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;

188:
189:
190: -- operation_seq_num
191:
192: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
193:
194: begin
195:
196: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 196: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

192: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating operation_seq_num . . . '); END IF;
193:
194: begin
195:
196: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
197:
198: select 1
199: into g_dummy
200: from wip_operations wo

Line 233: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_seq_num . . . '); END IF;

229:
230:
231: -- resource_seq_num
232:
233: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_seq_num . . . '); END IF;
234:
235: begin
236:
237: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 237: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

233: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating resource_seq_num . . . '); END IF;
234:
235: begin
236:
237: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
238:
239: select 1
240: into g_dummy
241: from wip_operation_resources wor

Line 274: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating instance_id . . . '); END IF;

270: end;
271:
272:
273: -- instance_id
274: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating instance_id . . . '); END IF;
275:
276: declare
277: l_resource_type NUMBER;
278: l_resource_id NUMBER;

Line 281: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

277: l_resource_type NUMBER;
278: l_resource_id NUMBER;
279: begin
280:
281: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
282:
283: select 1 into g_dummy from
284: bom_dept_res_instances bdri,
285: bom_department_resources bdr,

Line 346: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating serial_number . . . '); END IF;

342:
343:
344:
345: -- serial_number
346: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating serial_number . . . '); END IF;
347:
348: begin
349:
350: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 350: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

346: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating serial_number . . . '); END IF;
347:
348: begin
349:
350: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
351:
352: if (p_eam_res_inst_rec.serial_number is not NULL) then
353:
354: select 1

Line 391: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;

387: end;
388:
389:
390: -- start_date
391: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;
392:
393: begin
394:
395: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

Line 395: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then

391: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating start_date . . . '); END IF;
392:
393: begin
394:
395: if (p_eam_res_inst_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
396:
397: if p_eam_res_inst_rec.start_date > p_eam_res_inst_rec.completion_date then
398: raise fnd_api.g_exc_unexpected_error;
399: end if;

Line 427: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating delete instance . . . '); END IF;

423:
424: end;
425:
426: -- delete instance
427: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating delete instance . . . '); END IF;
428:
429: declare
430: l_count_wt NUMBER :=0;
431: l_count_wcti NUMBER :=0;

Line 441: if (p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then

437: and operation_seq_num = p_eam_res_inst_rec.operation_seq_num
438: and resource_seq_num = p_eam_res_inst_rec.resource_seq_num;
439: begin
440:
441: if (p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
442:
443: open res_inst;
444: fetch res_inst into l_resource_id;
445: close res_inst;

Line 514: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Instance Check Attributes . . . '); END IF;

510:
511:
512: x_return_status := FND_API.G_RET_STS_SUCCESS;
513:
514: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Within Resource Instance Check Attributes . . . '); END IF;
515:
516: END Check_Attributes;
517:
518: /*********************************************************************