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_WO_COMP_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 29: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

25: PROCEDURE Perform_Writes
26: (
27: p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
30: )
31: IS
32: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 32: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

28: , x_return_status OUT NOCOPY VARCHAR2
29: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
30: )
31: IS
32: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
34: BEGIN
35:
36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;

Line 36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;

32: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
33: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
34: BEGIN
35:
36: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Perform Writes'); END IF;
37:
38:
39: IF p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE OR
40: p_eam_wo_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE

Line 53: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed Perform Writes');

49: x_return_status := l_return_status;
50: x_mesg_token_tbl := l_mesg_token_tbl;
51:
52: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
53: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed Perform Writes');
54: END IF;
55:
56: END Perform_Writes;
57:

Line 62: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

58: PROCEDURE insert_row
59: (
60: p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
61: , x_return_status OUT NOCOPY VARCHAR2
62: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
63: )
64: IS
65: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
66: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

Line 65: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

61: , x_return_status OUT NOCOPY VARCHAR2
62: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
63: )
64: IS
65: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
66: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
67: BEGIN
68:
69: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing insert row'); END IF;

Line 69: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing insert row'); END IF;

65: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
66: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
67: BEGIN
68:
69: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing insert row'); END IF;
70:
71: begin
72: INSERT INTO EAM_JOB_COMPLETION_TXNS (
73: transaction_id,

Line 159: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed insert row');

155: p_eam_wo_comp_rec.attribute14,
156: p_eam_wo_comp_rec.attribute15
157: );
158: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
159: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed insert row');
160: END IF;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:

Line 169: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion : insert row : inside exception : ' || SQLERRM);

165: EXCEPTION
166: WHEN OTHERS THEN
167:
168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
169: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion : insert row : inside exception : ' || SQLERRM);
170: END IF;
171:
172: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
173: ( p_message_name => NULL

Line 172: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
169: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion : insert row : inside exception : ' || SQLERRM);
170: END IF;
171:
172: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
173: ( p_message_name => NULL
174: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
175: , x_mesg_token_Tbl => x_mesg_token_tbl
176: );

Line 177: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

173: ( p_message_name => NULL
174: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
175: , x_mesg_token_Tbl => x_mesg_token_tbl
176: );
177: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
178: END;
179: END insert_row;
180:
181: PROCEDURE process_shutdown(s_asset_group_id NUMBER,

Line 195: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Shutdown info ');

191: i_asset_status_id NUMBER;
192: BEGIN
193:
194: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
195: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing Shutdown info ');
196: END IF;
197:
198: -- get the asset_status_id from eam_asset_status_history_s sequence
199: SELECT eam_asset_status_history_s.nextval

Line 247: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed Shutdown info processing');

243: sysdate,
244: 'Y'); -- Enhancement Bug 3852846
245:
246: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
247: EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion completed Shutdown info processing');
248: END IF;
249:
250: END process_shutdown;
251:

Line 290: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : Start ');

286:
287: BEGIN
288:
289: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
290: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : Start ');
291: END IF;
292:
293: -- prepare the data to insert into MTL_MATERIAL_TRANSACTIONS_TEMP,
294: -- MTL_SERIAL_NUMBERS_TEMP, and MTL_TRANSACTION_LOTS_TEMP

Line 323: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before bom_revisions.get_revision ');

319:
320: if (l_revision_control_code = 2) then
321:
322: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
323: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before bom_revisions.get_revision ');
324: END IF;
325:
326: -- get bom_revision
327: bom_revisions.get_revision (examine_type => 'ALL',

Line 334: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after bom_revisions.get_revision ');

330: rev_date => sysdate,
331: itm_rev => i_revision);
332:
333: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
334: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after bom_revisions.get_revision ');
335: END IF;
336: end if;
337:
338: -- get transaction source type id

Line 377: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_line_trx');

373: return;
374: end if; -- end prepare data
375:
376: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
377: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_line_trx');
378: END IF;
379:
380:
381: -- call inventory API to insert data to mtl_material_transactions_temp

Line 404: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : inv_trx_util_pub.insert_line_trx : ' || errMsg);

400: x_proc_msg => errMsg);
401: if (errCode <> 0) then
402: return;
403: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
404: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : inv_trx_util_pub.insert_line_trx : ' || errMsg);
405: END IF;
406: end if;
407:
408: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

Line 409: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_line_trx');

405: END IF;
406: end if;
407:
408: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
409: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_line_trx');
410: END IF;
411:
412: FOR i IN 1..s_lot_serial_tbl.COUNT LOOP
413:

Line 425: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_lot_trx');

421: -- If it is, insert the data to coresponding tables
422: if(item.lotControlCode = WIP_CONSTANTS.LOT) then
423:
424: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
425: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_lot_trx');
426: END IF;
427:
428: -- the item is under lot control
429:

Line 446: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_lot_trx');

442: return;
443: end if;
444:
445: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
446: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_lot_trx');
447: END IF;
448:
449: else
450: null;

Line 468: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_ser_trx');

464: i_transaction_temp_id_s := i_transaction_temp_id;
465: end if; -- end lot control check
466:
467: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
468: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_trx_util_pub.insert_ser_trx');
469: END IF;
470:
471: -- call inventory API to insert data to mtl_serial_numbers_temp
472: -- the spec file is INVTRXUS.pls

Line 484: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_ser_trx');

480: return;
481: end if;
482:
483: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
484: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : after inv_trx_util_pub.insert_ser_trx');
485: END IF;
486:
487: else
488: null;

Line 496: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_lpn_trx_pub.process_lpn_trx');

492:
493: l_initial_msg_count := FND_MSG_PUB.count_msg;
494:
495: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
496: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : before inv_lpn_trx_pub.process_lpn_trx');
497: END IF;
498: -- Call Inventory API to process to item
499: -- the spec file is INVTRXWS.pls
500: errCode := inv_lpn_trx_pub.process_lpn_trx(

Line 521: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : End');

517: p_value1 => errMsg);
518: end if;
519: */
520: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
521: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_lot_serial : End');
522: END IF;
523: END process_lot_serial;
524:
525: PROCEDURE process_item(

Line 547: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_item : Start ');

543: l_lot_serial_tbl Lot_Serial_Tbl_Type;
544: BEGIN
545:
546: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
547: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_item : Start ');
548: END IF;
549:
550: IF s_inventory_item_tbl.COUNT = 0 THEN
551: RETURN;

Line 597: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_item : End ');

593: END IF;
594: END LOOP;
595:
596: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
597: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.process_item : End ');
598: END IF;
599:
600: END process_item;
601:

Line 605: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

601:
602: PROCEDURE update_row (
603: p_eam_wo_comp_rec IN EAM_PROCESS_WO_PUB.eam_wo_comp_rec_type
604: , x_return_status OUT NOCOPY VARCHAR2
605: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
606: )
607: IS
608: l_asset_group_id NUMBER;
609: l_asset_number VARCHAR2(30);

Line 638: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

634: x_commit VARCHAR2(1) := fnd_api.g_false;
635: errCode NUMBER;
636: errMsg VARCHAR2(2000);
637: l_statement NUMBER := 0;
638: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
639: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
640: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
641: l_txn_type NUMBER;
642:

Line 639: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

635: errCode NUMBER;
636: errMsg VARCHAR2(2000);
637: l_statement NUMBER := 0;
638: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
639: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
640: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
641: l_txn_type NUMBER;
642:
643: l_cmpl_sub VARCHAR2(10);

Line 640: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;

636: errMsg VARCHAR2(2000);
637: l_statement NUMBER := 0;
638: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
639: l_out_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
640: l_Token_Tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
641: l_txn_type NUMBER;
642:
643: l_cmpl_sub VARCHAR2(10);
644: l_locator NUMBER;

Line 647: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing update_row'); END IF;

643: l_cmpl_sub VARCHAR2(10);
644: l_locator NUMBER;
645: l_lot VARCHAR2(80);
646: BEGIN
647: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order Completeion processing update_row'); END IF;
648:
649: -- get some value from wip_discrete_jobs table
650: select parent_wip_entity_id,
651: asset_group_id,

Line 729: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

725: /* l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
726: l_token_tbl(1).token_value := p_eam_wo_comp_rec.wip_entity_id;
727:
728: l_out_mesg_token_tbl := l_mesg_token_tbl;
729: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
730: ( p_message_name => 'EAM_WO_COMPL_RETURN_ITEM'
731: , p_token_tbl => l_Token_tbl
732: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
733: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 738: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

734: );
735: l_mesg_token_tbl := l_out_mesg_token_tbl;
736: x_mesg_token_tbl := l_mesg_token_tbl ;
737:
738: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
739: return; */
740:
741: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
742: ( p_message_name => NULL

Line 741: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

737:
738: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
739: return; */
740:
741: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
742: ( p_message_name => NULL
743: , p_message_text => errMsg
744: , x_mesg_token_Tbl => x_mesg_token_tbl
745: );

Line 746: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

742: ( p_message_name => NULL
743: , p_message_text => errMsg
744: , x_mesg_token_Tbl => x_mesg_token_tbl
745: );
746: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
747: return;
748:
749: end if;
750:

Line 813: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

809: /* l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
810: l_token_tbl(1).token_value := p_eam_wo_comp_rec.wip_entity_id;
811:
812: l_out_mesg_token_tbl := l_mesg_token_tbl;
813: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
814: ( p_message_name => 'EAM_WO_COMPL_GET_ITEM'
815: , p_token_tbl => l_Token_tbl
816: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
817: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl

Line 822: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

818: );
819: l_mesg_token_tbl := l_out_mesg_token_tbl;
820: x_mesg_token_tbl := l_mesg_token_tbl ;
821:
822: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
823: return;
824: */
825: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
826: ( p_message_name => NULL

Line 825: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

821:
822: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
823: return;
824: */
825: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
826: ( p_message_name => NULL
827: , p_message_text => errMsg
828: , x_mesg_token_Tbl => x_mesg_token_tbl
829: );

Line 831: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

827: , p_message_text => errMsg
828: , x_mesg_token_Tbl => x_mesg_token_tbl
829: );
830:
831: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
832:
833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
834: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception1 : '|| errMsg);
835: END IF;

Line 834: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception1 : '|| errMsg);

830:
831: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
832:
833: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
834: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception1 : '|| errMsg);
835: END IF;
836: return;
837: end if;
838: end if;

Line 878: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

874: x_msg_count => l_msg_count,
875: x_msg_data => l_msg_data);
876:
877: if(x_return_status <> 'S') then
878: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
879: ( p_message_name => NULL
880: , p_message_text => l_msg_data
881: , x_mesg_token_Tbl => x_mesg_token_tbl
882: );

Line 883: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

879: ( p_message_name => NULL
880: , p_message_text => l_msg_data
881: , x_mesg_token_Tbl => x_mesg_token_tbl
882: );
883: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
884: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
885: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception2 : '|| l_msg_data);
886: END IF;
887: return;

Line 885: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception2 : '|| l_msg_data);

881: , x_mesg_token_Tbl => x_mesg_token_tbl
882: );
883: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
884: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
885: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception2 : '|| l_msg_data);
886: END IF;
887: return;
888: end if;
889:

Line 943: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

939:
940: x_return_status := FND_API.G_RET_STS_SUCCESS;
941: EXCEPTION
942: WHEN OTHERS THEN
943: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
944: ( p_message_name => NULL
945: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
946: , x_mesg_token_Tbl => x_mesg_token_tbl
947: );

Line 949: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;

945: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
946: , x_mesg_token_Tbl => x_mesg_token_tbl
947: );
948:
949: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
950: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
951: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception3 : '|| SQLERRM);
952: END IF;
953:

Line 951: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception3 : '|| SQLERRM);

947: );
948:
949: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
950: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
951: EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_WO_COMP_UTILITY_PVT.update_row : Exception3 : '|| SQLERRM);
952: END IF;
953:
954: END update_row;
955: