DBA Data[Home] [Help]

APPS.EAM_WO_QUA_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_request_rec IN EAM_PROCESS_WO_PUB.eam_wo_quality_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: )IS
31: BEGIN
32: null;
33: END Perform_Writes;

Line 39: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT get_error_code'); END IF;

35: FUNCTION get_error_code(code IN NUMBER) RETURN VARCHAR2 IS
36: BEGIN
37:
38:
39: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT get_error_code'); END IF;
40:
41: --
42: -- Should figure out the error message from dictionary.
43: --

Line 57: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT get_error_message'); END IF;

53: name qa_chars.prompt%TYPE;
54: code VARCHAR2(2000);
55: BEGIN
56: messages := '';
57: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT get_error_message'); END IF;
58:
59: --
60: -- This bug is discovered during bug fix for 3402251.
61: -- In some rare situation, this proc can be called when

Line 83: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT get_error_message completed ...'); END IF;

79: IF i < errors.LAST THEN
80: messages := messages || separator;
81: END IF;
82: END LOOP;
83: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT get_error_message completed ...'); END IF;
84: END get_error_messages;
85:
86: PROCEDURE insert_row
87: (

Line 92: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

88: p_collection_id IN NUMBER
89: , p_eam_wo_quality_tbl IN EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
90: , x_eam_wo_quality_tbl OUT NOCOPY EAM_PROCESS_WO_PUB.eam_wo_quality_tbl_type
91: , x_return_status OUT NOCOPY VARCHAR2
92: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
93: )IS
94:
95: Type header_plan_id_tbl_type is table of NUMBER INDEX BY BINARY_INTEGER;
96: header_plan_id_tbl header_plan_id_tbl_type;

Line 111: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

107: message_array qa_validation_api.MessageArray;
108: return_status VARCHAR2(1);
109: action_result VARCHAR2(1);
110: x_messages varchar2(2000);
111: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
112: l_txn_number NUMBER;
113:
114: BEGIN
115: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT insert_row ...'); END IF;

Line 115: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT insert_row ...'); END IF;

111: l_Mesg_Token_Tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
112: l_txn_number NUMBER;
113:
114: BEGIN
115: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inside EAM_WO_QUA_UTILITY_PVT insert_row ...'); END IF;
116:
117: IF (p_eam_wo_quality_tbl.count >0) THEN
118: l_org_id := p_eam_wo_quality_tbl(p_eam_wo_quality_tbl.FIRST).organization_id;
119: IF p_eam_wo_quality_tbl(p_eam_wo_quality_tbl.FIRST).OPERATION_SEQ_NUMBER IS NOT NULL THEN

Line 127: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Get the plan ids ...'); END IF;

123: END IF;
124:
125: END IF;
126:
127: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Get the plan ids ...'); END IF;
128:
129: l_collection_id := p_collection_id;
130: -- following loops gets the different plan ids that are in the data
131: -- for 3 collection plans there will be 3 differnet plan ids

Line 167: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling qa_results_pub.insert_row ...'); END IF;

163: END LOOP;
164:
165: -- set_validation_flag (elements, 31);
166:
167: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling qa_results_pub.insert_row ...'); END IF;
168: qa_results_pub.insert_row(
169: p_api_version => 1.0,
170: p_init_msg_list => fnd_api.g_true,
171: p_org_id => l_org_id,

Line 193: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

189:
190: IF error_array.count <>0 THEN
191: get_error_messages(error_array, header_plan_id_tbl(xx), x_messages);
192:
193: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
194: ( p_message_name => NULL
195: , p_message_text => x_messages
196: , x_mesg_token_Tbl => x_mesg_token_tbl
197: );

Line 199: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

195: , p_message_text => x_messages
196: , x_mesg_token_Tbl => x_mesg_token_tbl
197: );
198:
199: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
200: END IF;
201:
202: IF return_status <> 'S' THEN
203: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

Line 203: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

199: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
200: END IF;
201:
202: IF return_status <> 'S' THEN
203: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
204: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
205: ( p_message_name => NULL
206: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
207: , x_mesg_token_Tbl => x_mesg_token_tbl

Line 204: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

200: END IF;
201:
202: IF return_status <> 'S' THEN
203: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
204: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
205: ( p_message_name => NULL
206: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
207: , x_mesg_token_Tbl => x_mesg_token_tbl
208: );

Line 213: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('completed the insert_row procedure ...'); END IF;

209: return;
210: END IF;
211:
212: END LOOP;
213: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('completed the insert_row procedure ...'); END IF;
214:
215: EXCEPTION WHEN OTHERS THEN
216: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
217: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 216: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;

212: END LOOP;
213: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('completed the insert_row procedure ...'); END IF;
214:
215: EXCEPTION WHEN OTHERS THEN
216: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
217: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
218: ( p_message_name => NULL
219: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
220: , x_mesg_token_Tbl => x_mesg_token_tbl

Line 217: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

213: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('completed the insert_row procedure ...'); END IF;
214:
215: EXCEPTION WHEN OTHERS THEN
216: return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
217: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
218: ( p_message_name => NULL
219: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
220: , x_mesg_token_Tbl => x_mesg_token_tbl
221: );