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

Line 78: IF NOT FND_API.Compatible_API_Call( l_api_version,

74: -- Standard Start of API Savepoint
75: SAVEPOINT CSD_SPLIT_PKG ;
76:
77: -- Standard Call to check API compatibility
78: IF NOT FND_API.Compatible_API_Call( l_api_version,
79: p_api_version,
80: l_api_name,
81: G_PKG_NAME) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

78: IF NOT FND_API.Compatible_API_Call( l_api_version,
79: p_api_version,
80: l_api_name,
81: G_PKG_NAME) THEN
82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 86: IF FND_API.to_Boolean( p_init_msg_list ) THEN

82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list ) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Initialize API return status to success

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: --
94: -- API body
95: --

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

100: p_repair_line_id => p_original_repair_line_id,
101: x_Repln_Rec => l_rep_line_rec,
102: x_return_status => x_return_status
103: );
104: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
105: IF(l_statement_level >= l_debug_level) THEN
106: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','failed');
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;

Line 108: RAISE FND_API.G_EXC_ERROR;

104: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
105: IF(l_statement_level >= l_debug_level) THEN
106: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','failed');
107: END IF;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110:
111: l_total_original_quantity := l_rep_line_rec.quantity;
112: l_org_new_quantity := l_total_original_quantity - p_new_quantity;

Line 137: p_init_msg_list => FND_API.G_TRUE,

133: end if;
134:
135: CSD_REPAIRS_PVT.Update_Repair_Order
136: (p_API_version_number => 1.0,
137: p_init_msg_list => FND_API.G_TRUE,
138: p_commit => FND_API.G_FALSE,
139: p_validation_level => null,
140: p_repair_line_id => p_original_repair_line_id,
141: p_Repln_Rec => l_original_rep_line_rec,

Line 138: p_commit => FND_API.G_FALSE,

134:
135: CSD_REPAIRS_PVT.Update_Repair_Order
136: (p_API_version_number => 1.0,
137: p_init_msg_list => FND_API.G_TRUE,
138: p_commit => FND_API.G_FALSE,
139: p_validation_level => null,
140: p_repair_line_id => p_original_repair_line_id,
141: p_Repln_Rec => l_original_rep_line_rec,
142: x_return_status => x_return_status,

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

142: x_return_status => x_return_status,
143: x_msg_count => x_msg_count,
144: x_msg_data => x_msg_data
145: );
146: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: IF(l_statement_level >= l_debug_level) THEN
148: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
149: END IF;
150: RAISE FND_API.G_EXC_ERROR;

Line 150: RAISE FND_API.G_EXC_ERROR;

146: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
147: IF(l_statement_level >= l_debug_level) THEN
148: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
149: END IF;
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: l_rep_line_rec.repair_number := null;
154: l_rep_line_rec.object_version_number := FND_API.G_MISS_NUM;

Line 154: l_rep_line_rec.object_version_number := FND_API.G_MISS_NUM;

150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153: l_rep_line_rec.repair_number := null;
154: l_rep_line_rec.object_version_number := FND_API.G_MISS_NUM;
155: l_rep_line_rec.quantity := p_new_quantity;
156: l_rep_line_rec.repair_type_id := p_repair_type_id;
157:
158: Create_New_Repair_Order (

Line 161: p_commit => FND_API.G_FALSE,

157:
158: Create_New_Repair_Order (
159: p_api_version => 1.0,
160: p_init_msg_list => p_init_msg_list,
161: p_commit => FND_API.G_FALSE,
162: p_validation_level => null,
163: x_return_status => x_return_status,
164: x_msg_count => x_msg_count,
165: x_msg_data => x_msg_data,

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

167: p_copy_attachment => p_copy_attachment,
168: p_original_repair_line_id => p_original_repair_line_id,
169: p_rep_line_rec => l_rep_line_rec
170: );
171: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
172: IF(l_statement_level >= l_debug_level) THEN
173: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
174: END IF;
175: RAISE FND_API.G_EXC_ERROR;

Line 175: RAISE FND_API.G_EXC_ERROR;

171: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
172: IF(l_statement_level >= l_debug_level) THEN
173: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
174: END IF;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178: l_repair_history_Rec.repair_line_id := p_original_repair_line_id;
179: l_repair_history_Rec.EVENT_CODE := 'SLT';

Line 186: P_Commit => FND_API.G_FALSE,

182:
183: CSD_REPAIR_HISTORY_PVT.Create_repair_history(
184: P_Api_Version_Number => p_api_version,
185: P_Init_Msg_List => p_init_msg_list,
186: P_Commit => FND_API.G_FALSE,
187: p_validation_level => p_validation_level,
188: P_REPH_REC => l_repair_history_Rec,
189: X_REPAIR_HISTORY_ID => l_repair_history_id,
190: X_Return_Status => x_return_status,

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

190: X_Return_Status => x_return_status,
191: X_Msg_Count => x_msg_count,
192: X_Msg_Data => x_msg_data
193: );
194: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
195: IF(l_statement_level >= l_debug_level) THEN
196: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;

Line 198: RAISE FND_API.G_EXC_ERROR;

194: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
195: IF(l_statement_level >= l_debug_level) THEN
196: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201:
202: l_repair_history_Rec.repair_line_id := x_repair_line_id;

Line 228: P_Commit => FND_API.G_FALSE,

224:
225: CSD_REPAIR_HISTORY_PVT.Create_repair_history(
226: P_Api_Version_Number => p_api_version,
227: P_Init_Msg_List => p_init_msg_list,
228: P_Commit => FND_API.G_FALSE,
229: p_validation_level => p_validation_level,
230: P_REPH_REC => l_repair_history_Rec,
231: X_REPAIR_HISTORY_ID => l_repair_history_id,
232: X_Return_Status => x_return_status,

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

232: X_Return_Status => x_return_status,
233: X_Msg_Count => x_msg_count,
234: X_Msg_Data => x_msg_data
235: );
236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
237: IF(l_statement_level >= l_debug_level) THEN
238: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
239: END IF;
240: RAISE FND_API.G_EXC_ERROR;

Line 240: RAISE FND_API.G_EXC_ERROR;

236: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
237: IF(l_statement_level >= l_debug_level) THEN
238: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
239: END IF;
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242:
243: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
244: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN

Line 247: p_init_msg_list => Fnd_Api.G_FALSE,

243: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
244: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
245: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
246: p_api_version_number => 1.0,
247: p_init_msg_list => Fnd_Api.G_FALSE,
248: p_commit => Fnd_Api.G_FALSE,
249: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
250: p_repair_line_id => x_repair_line_id,
251: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 248: p_commit => Fnd_Api.G_FALSE,

244: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
245: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
246: p_api_version_number => 1.0,
247: p_init_msg_list => Fnd_Api.G_FALSE,
248: p_commit => Fnd_Api.G_FALSE,
249: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
250: p_repair_line_id => x_repair_line_id,
251: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
252: x_return_status => l_return_status,

Line 249: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

245: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
246: p_api_version_number => 1.0,
247: p_init_msg_list => Fnd_Api.G_FALSE,
248: p_commit => Fnd_Api.G_FALSE,
249: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
250: p_repair_line_id => x_repair_line_id,
251: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
252: x_return_status => l_return_status,
253: x_msg_count => l_msg_count,

Line 276: p_init_msg_list => FND_API.G_TRUE,

272: );
273:
274: CSD_REPAIRS_PVT.Update_Repair_Order
275: (p_API_version_number => 1.0,
276: p_init_msg_list => FND_API.G_TRUE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => null,
279: p_repair_line_id => p_original_repair_line_id,
280: p_Repln_Rec => l_original_rep_line_rec,

Line 277: p_commit => FND_API.G_FALSE,

273:
274: CSD_REPAIRS_PVT.Update_Repair_Order
275: (p_API_version_number => 1.0,
276: p_init_msg_list => FND_API.G_TRUE,
277: p_commit => FND_API.G_FALSE,
278: p_validation_level => null,
279: p_repair_line_id => p_original_repair_line_id,
280: p_Repln_Rec => l_original_rep_line_rec,
281: x_return_status => x_return_status,

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

281: x_return_status => x_return_status,
282: x_msg_count => x_msg_count,
283: x_msg_data => x_msg_data
284: );
285: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: IF(l_statement_level >= l_debug_level) THEN
287: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
288: END IF;
289: RAISE FND_API.G_EXC_ERROR;

Line 289: RAISE FND_API.G_EXC_ERROR;

285: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
286: IF(l_statement_level >= l_debug_level) THEN
287: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Update_Repair_Order','failed');
288: END IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: l_rep_line_rec.repair_number := null;
293: l_rep_line_rec.object_version_number := FND_API.G_MISS_NUM;

Line 293: l_rep_line_rec.object_version_number := FND_API.G_MISS_NUM;

289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: l_rep_line_rec.repair_number := null;
293: l_rep_line_rec.object_version_number := FND_API.G_MISS_NUM;
294: for i in 1..(l_total_original_quantity-1) loop
295: l_rep_line_rec.quantity := 1;
296:
297: Create_New_Repair_Order (

Line 300: p_commit => FND_API.G_FALSE,

296:
297: Create_New_Repair_Order (
298: p_api_version => 1.0,
299: p_init_msg_list => p_init_msg_list,
300: p_commit => FND_API.G_FALSE,
301: p_validation_level => null,
302: x_return_status => x_return_status,
303: x_msg_count => x_msg_count,
304: x_msg_data => x_msg_data,

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

306: p_copy_attachment => p_copy_attachment,
307: p_original_repair_line_id => p_original_repair_line_id,
308: p_rep_line_rec => l_rep_line_rec
309: );
310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
311: IF(l_statement_level >= l_debug_level) THEN
312: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;

Line 314: RAISE FND_API.G_EXC_ERROR;

310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
311: IF(l_statement_level >= l_debug_level) THEN
312: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order','failed');
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:
317: l_repair_history_Rec.repair_line_id := x_repair_line_id;
318: l_repair_history_Rec.EVENT_CODE := 'SLT';

Line 328: P_Commit => FND_API.G_FALSE,

324: l_repair_history_Rec.paramc1 := l_original_repair_number;
325: CSD_REPAIR_HISTORY_PVT.Create_repair_history(
326: P_Api_Version_Number => p_api_version,
327: P_Init_Msg_List => p_init_msg_list,
328: P_Commit => FND_API.G_FALSE,
329: p_validation_level => p_validation_level,
330: P_REPH_REC => l_repair_history_Rec,
331: X_REPAIR_HISTORY_ID => l_repair_history_id,
332: X_Return_Status => x_return_status,

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

332: X_Return_Status => x_return_status,
333: X_Msg_Count => x_msg_count,
334: X_Msg_Data => x_msg_data
335: );
336: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
337: IF(l_statement_level >= l_debug_level) THEN
338: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
339: END IF;
340: RAISE FND_API.G_EXC_ERROR;

Line 340: RAISE FND_API.G_EXC_ERROR;

336: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
337: IF(l_statement_level >= l_debug_level) THEN
338: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
339: END IF;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343:
344: end loop;

Line 356: P_Commit => FND_API.G_FALSE,

352:
353: CSD_REPAIR_HISTORY_PVT.Create_repair_history(
354: P_Api_Version_Number => p_api_version,
355: P_Init_Msg_List => p_init_msg_list,
356: P_Commit => FND_API.G_FALSE,
357: p_validation_level => p_validation_level,
358: P_REPH_REC => l_repair_history_Rec,
359: X_REPAIR_HISTORY_ID => l_repair_history_id,
360: X_Return_Status => x_return_status,

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

360: X_Return_Status => x_return_status,
361: X_Msg_Count => x_msg_count,
362: X_Msg_Data => x_msg_data
363: );
364: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
365: IF(l_statement_level >= l_debug_level) THEN
366: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
367: END IF;
368: RAISE FND_API.G_EXC_ERROR;

Line 368: RAISE FND_API.G_EXC_ERROR;

364: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
365: IF(l_statement_level >= l_debug_level) THEN
366: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
367: END IF;
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370:
371: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
372: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN

Line 375: p_init_msg_list => Fnd_Api.G_FALSE,

371: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
372: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
373: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
374: p_api_version_number => 1.0,
375: p_init_msg_list => Fnd_Api.G_FALSE,
376: p_commit => Fnd_Api.G_FALSE,
377: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
378: p_repair_line_id => x_repair_line_id,
379: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 376: p_commit => Fnd_Api.G_FALSE,

372: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
373: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
374: p_api_version_number => 1.0,
375: p_init_msg_list => Fnd_Api.G_FALSE,
376: p_commit => Fnd_Api.G_FALSE,
377: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
378: p_repair_line_id => x_repair_line_id,
379: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
380: x_return_status => l_return_status,

Line 377: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

373: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
374: p_api_version_number => 1.0,
375: p_init_msg_list => Fnd_Api.G_FALSE,
376: p_commit => Fnd_Api.G_FALSE,
377: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
378: p_repair_line_id => x_repair_line_id,
379: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
380: x_return_status => l_return_status,
381: x_msg_count => l_msg_count,

Line 391: IF FND_API.To_Boolean( p_commit ) THEN

387:
388: -- End of API body
389: --
390: -- Standard check of p_commit.
391: IF FND_API.To_Boolean( p_commit ) THEN
392: COMMIT WORK;
393: END IF;
394:
395: -- Standard call to get message count and if count is 1, get message info.

Line 401: WHEN FND_API.G_EXC_ERROR THEN

397: ( p_count => x_msg_count,
398: p_data => x_msg_data
399: );
400: EXCEPTION
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO CSD_SPLIT_PKG;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,

Line 403: x_return_status := FND_API.G_RET_STS_ERROR;

399: );
400: EXCEPTION
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO CSD_SPLIT_PKG;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: FND_MSG_PUB.Count_And_Get
405: ( p_count => x_msg_count,
406: p_data => x_msg_data
407: );

Line 413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

409: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
410: 'CSD.PLSQL.CSD_SPLIT_PKG.Split_Repair_Order',
411: 'EXC_ERROR ['||x_msg_data||']');
412: END IF;
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO CSD_SPLIT_PKG;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

411: 'EXC_ERROR ['||x_msg_data||']');
412: END IF;
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO CSD_SPLIT_PKG;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
416: FND_MSG_PUB.Count_And_Get
417: ( p_count => x_msg_count,
418: p_data => x_msg_data
419: );

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

423: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
424: END IF;
425: WHEN OTHERS THEN
426: ROLLBACK TO CSD_SPLIT_PKG;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
428: IF FND_MSG_PUB.Check_Msg_Level
429: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535:
536: begin
537:
538: -- Initialize API return status to success
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: IF(l_statement_level >= l_debug_level) THEN
542: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','At the Begin in Build_Repln_Record');
543: END IF;

Line 545: IF NVL(p_repair_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

541: IF(l_statement_level >= l_debug_level) THEN
542: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repln_Record','At the Begin in Build_Repln_Record');
543: END IF;
544:
545: IF NVL(p_repair_line_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
546:
547: OPEN c_repair_line_dtls(p_repair_line_id);
548: FETCH c_repair_line_dtls INTO
549: x_Repln_Rec.REPAIR_NUMBER

Line 626: RAISE FND_API.G_EXC_ERROR;

622: IF c_repair_line_dtls%notfound then
623: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
624: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
625: FND_MSG_PUB.ADD;
626: RAISE FND_API.G_EXC_ERROR;
627: END IF;
628:
629: IF c_repair_line_dtls%isopen then
630: CLOSE c_repair_line_dtls;

Line 636: WHEN FND_API.G_EXC_ERROR THEN

632:
633: END IF;
634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: ROLLBACK TO CSD_SPLIT_PKG;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO CSD_SPLIT_PKG;

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: ROLLBACK TO CSD_SPLIT_PKG;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO CSD_SPLIT_PKG;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642: WHEN OTHERS THEN

Line 639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: ROLLBACK TO CSD_SPLIT_PKG;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO CSD_SPLIT_PKG;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642: WHEN OTHERS THEN
643: ROLLBACK TO CSD_SPLIT_PKG;

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

637: ROLLBACK TO CSD_SPLIT_PKG;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO CSD_SPLIT_PKG;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642: WHEN OTHERS THEN
643: ROLLBACK TO CSD_SPLIT_PKG;
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
645: End Build_Repln_Record;

Line 644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

640: ROLLBACK TO CSD_SPLIT_PKG;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
642: WHEN OTHERS THEN
643: ROLLBACK TO CSD_SPLIT_PKG;
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
645: End Build_Repln_Record;
646:
647:
648: PROCEDURE Build_Product_TXN_Record (

Line 715: x_return_status := FND_API.G_RET_STS_SUCCESS;

711:
712: begin
713:
714: -- Initialize API return status to success
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717: IF NVL(p_product_txn_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
718: OPEN c_product_txn_line_dtls(p_product_txn_id);
719: FETCH c_product_txn_line_dtls INTO

Line 717: IF NVL(p_product_txn_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

713:
714: -- Initialize API return status to success
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717: IF NVL(p_product_txn_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
718: OPEN c_product_txn_line_dtls(p_product_txn_id);
719: FETCH c_product_txn_line_dtls INTO
720: x_product_txn_Rec.estimate_detail_id
721: ,x_product_txn_Rec.action_type

Line 773: RAISE FND_API.G_EXC_ERROR;

769: IF c_product_txn_line_dtls%notfound then
770: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
771: FND_MESSAGE.SET_TOKEN('p_product_txn_id',p_product_txn_id);
772: FND_MSG_PUB.ADD;
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775:
776: IF c_product_txn_line_dtls%isopen then
777: CLOSE c_product_txn_line_dtls;

Line 784: WHEN FND_API.G_EXC_ERROR THEN

780: END IF;
781:
782: -- Standard call to get message count and if count is 1, get message info.
783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: ROLLBACK TO CSD_SPLIT_PKG;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO CSD_SPLIT_PKG;

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782: -- Standard call to get message count and if count is 1, get message info.
783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: ROLLBACK TO CSD_SPLIT_PKG;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO CSD_SPLIT_PKG;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: WHEN OTHERS THEN

Line 787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: ROLLBACK TO CSD_SPLIT_PKG;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO CSD_SPLIT_PKG;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: WHEN OTHERS THEN
791: ROLLBACK TO CSD_SPLIT_PKG;

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

785: ROLLBACK TO CSD_SPLIT_PKG;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
788: ROLLBACK TO CSD_SPLIT_PKG;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: WHEN OTHERS THEN
791: ROLLBACK TO CSD_SPLIT_PKG;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
793: End Build_Product_TXN_Record;

Line 792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

788: ROLLBACK TO CSD_SPLIT_PKG;
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790: WHEN OTHERS THEN
791: ROLLBACK TO CSD_SPLIT_PKG;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
793: End Build_Product_TXN_Record;
794:
795:
796: PROCEDURE Set_Error_Message (

Line 807: x_return_status := FND_API.G_RET_STS_SUCCESS;

803: IS
804:
805: begin
806: -- Initialize API return status to success
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808:
809: -- Initialize message list if p_init_msg_list is set to TRUE.
810: IF FND_API.to_Boolean( fnd_api.g_true ) THEN
811: FND_MSG_PUB.initialize;

Line 810: IF FND_API.to_Boolean( fnd_api.g_true ) THEN

806: -- Initialize API return status to success
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808:
809: -- Initialize message list if p_init_msg_list is set to TRUE.
810: IF FND_API.to_Boolean( fnd_api.g_true ) THEN
811: FND_MSG_PUB.initialize;
812: END IF;
813:
814: IF (p_msg_code is not null) ThEN

Line 815: x_return_status := FND_API.G_RET_STS_ERROR;

811: FND_MSG_PUB.initialize;
812: END IF;
813:
814: IF (p_msg_code is not null) ThEN
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: FND_MESSAGE.SET_NAME('CSD',p_msg_code);
817: FND_MSG_PUB.ADD;
818: END IF;
819:

Line 877: x_return_status := FND_API.G_RET_STS_SUCCESS;

873:
874:
875: begin
876: -- Initialize API return status to success
877: x_return_status := FND_API.G_RET_STS_SUCCESS;
878: l_number_product_txn_lines := 0;
879: l_total_quantity_rcvd := 0;
880: l_total_quantity_in_wip := 0;
881: l_repair_mode := null;

Line 884: IF FND_API.to_Boolean( fnd_api.g_true ) THEN

880: l_total_quantity_in_wip := 0;
881: l_repair_mode := null;
882:
883: -- Initialize message list if p_init_msg_list is set to TRUE.
884: IF FND_API.to_Boolean( fnd_api.g_true ) THEN
885: FND_MSG_PUB.initialize;
886: END IF;
887:
888: IF (p_repair_line_id is null) THEN

Line 889: x_return_status := FND_API.G_RET_STS_ERROR;

885: FND_MSG_PUB.initialize;
886: END IF;
887:
888: IF (p_repair_line_id is null) THEN
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_WITHOUT_RO_NUM');
891: FND_MSG_PUB.ADD;
892: FND_MSG_PUB.Count_And_Get
893: ( p_count => x_msg_count,

Line 908: x_return_status := FND_API.G_RET_STS_ERROR;

904: CLOSE c_repair_type_ref;
905: END IF;
906:
907: IF l_repair_type_ref not in ('SR', 'RR') then
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
910: FND_MSG_PUB.ADD;
911: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
912: FND_MSG_PUB.Count_And_Get

Line 911: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

907: IF l_repair_type_ref not in ('SR', 'RR') then
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
910: FND_MSG_PUB.ADD;
911: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
912: FND_MSG_PUB.Count_And_Get
913: ( p_count => x_msg_count,
914: p_data => x_msg_data
915: );

Line 934: x_return_status := FND_API.G_RET_STS_ERROR;

930: l_repair_quantity := P.repair_quantity;
931: l_total_quantity_rcvd := l_total_quantity_rcvd + P.quantity_rcvd;
932: l_total_quantity_in_wip := l_total_quantity_in_wip + P.quantity_in_wip;
933: if P.status <> 'O' then
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_WRONG_STATUS');
936: FND_MSG_PUB.ADD;
937: elsif P.serial_number_control_code <> 1 then
938: x_return_status := FND_API.G_RET_STS_ERROR;

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: x_return_status := FND_API.G_RET_STS_ERROR;
935: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_WRONG_STATUS');
936: FND_MSG_PUB.ADD;
937: elsif P.serial_number_control_code <> 1 then
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_SERIALIZED');
940: FND_MSG_PUB.ADD;
941: elsif P.repair_type_ref not in ('SR', 'RR') then
942: x_return_status := FND_API.G_RET_STS_ERROR;

Line 942: x_return_status := FND_API.G_RET_STS_ERROR;

938: x_return_status := FND_API.G_RET_STS_ERROR;
939: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_SERIALIZED');
940: FND_MSG_PUB.ADD;
941: elsif P.repair_type_ref not in ('SR', 'RR') then
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
944: FND_MSG_PUB.ADD;
945: elsif P.comms_nl_trackable_flag = 'Y' then
946: x_return_status := FND_API.G_RET_STS_ERROR;

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: x_return_status := FND_API.G_RET_STS_ERROR;
943: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_INCORRECT_REF');
944: FND_MSG_PUB.ADD;
945: elsif P.comms_nl_trackable_flag = 'Y' then
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_IB_TRBLE');
948: FND_MSG_PUB.ADD;
949: end if;
950: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 950: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_PROD_IB_TRBLE');
948: FND_MSG_PUB.ADD;
949: end if;
950: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
951: FND_MSG_PUB.Count_And_Get
952: ( p_count => x_msg_count,
953: p_data => x_msg_data
954: );

Line 964: x_return_status := FND_API.G_RET_STS_ERROR;

960: CLOSE c_rma_product_txn_line_info;
961: END IF;
962:
963: if (l_number_product_txn_lines < 1) then
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_NO_LOGISTIC_LINE');
966: FND_MSG_PUB.ADD;
967: elsif (l_repair_quantity > l_total_quantity_rcvd) then
968: x_return_status := FND_API.G_RET_STS_ERROR;

Line 968: x_return_status := FND_API.G_RET_STS_ERROR;

964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_NO_LOGISTIC_LINE');
966: FND_MSG_PUB.ADD;
967: elsif (l_repair_quantity > l_total_quantity_rcvd) then
968: x_return_status := FND_API.G_RET_STS_ERROR;
969: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_ALL_QTYS_NOT_REC');
970: FND_MSG_PUB.ADD;
971: elsif ((l_repair_quantity > l_total_quantity_in_wip) and (l_repair_mode = 'WIP') and (l_wip_job_count > 0)) then
972: x_return_status := FND_API.G_RET_STS_ERROR;

Line 972: x_return_status := FND_API.G_RET_STS_ERROR;

968: x_return_status := FND_API.G_RET_STS_ERROR;
969: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_ALL_QTYS_NOT_REC');
970: FND_MSG_PUB.ADD;
971: elsif ((l_repair_quantity > l_total_quantity_in_wip) and (l_repair_mode = 'WIP') and (l_wip_job_count > 0)) then
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_JOB_INCOMPLETED');
974: FND_MSG_PUB.ADD;
975: end if;
976:

Line 977: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

973: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_JOB_INCOMPLETED');
974: FND_MSG_PUB.ADD;
975: end if;
976:
977: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
978: FND_MSG_PUB.Count_And_Get
979: ( p_count => x_msg_count,
980: p_data => x_msg_data
981: );

Line 988: x_return_status := FND_API.G_RET_STS_ERROR;

984:
985: FOR S in c_ship_product_txn_line_info(p_repair_line_id)
986: loop
987: if S.interface_to_om_flag = 'Y' then
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: FND_MESSAGE.SET_NAME('CSD','CSD_NOT_SPLIT_LINE_INTERFACED');
990: FND_MSG_PUB.ADD;
991: end if;
992: end loop;

Line 1003: WHEN FND_API.G_EXC_ERROR THEN

999: p_data => x_msg_data
1000: );
1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_ERROR THEN
1004: ROLLBACK TO CSD_SPLIT_PKG;
1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006: FND_MSG_PUB.Count_And_Get
1007: ( p_count => x_msg_count,

Line 1005: x_return_status := FND_API.G_RET_STS_ERROR;

1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_ERROR THEN
1004: ROLLBACK TO CSD_SPLIT_PKG;
1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006: FND_MSG_PUB.Count_And_Get
1007: ( p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );

Line 1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1011: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1012: 'CSD.PLSQL.CSD_SPLIT_PKG.Is_Split_Repair_Order_Allow',
1013: 'EXC_ERROR ['||x_msg_data||']');
1014: END IF;
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: ROLLBACK TO CSD_SPLIT_PKG;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018: FND_MSG_PUB.Count_And_Get
1019: ( p_count => x_msg_count,

Line 1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1013: 'EXC_ERROR ['||x_msg_data||']');
1014: END IF;
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: ROLLBACK TO CSD_SPLIT_PKG;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018: FND_MSG_PUB.Count_And_Get
1019: ( p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1025: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1026: END IF;
1027: WHEN OTHERS THEN
1028: ROLLBACK TO CSD_SPLIT_PKG;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030: IF FND_MSG_PUB.Check_Msg_Level
1031: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: FND_MSG_PUB.Add_Exc_Msg

Line 1085: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1081: Begin
1082:
1083:
1084: -- Initialize message list if p_init_msg_list is set to TRUE.
1085: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1086: FND_MSG_PUB.initialize;
1087: END IF;
1088:
1089: -- Initialize API return status to success

Line 1090: x_return_status := FND_API.G_RET_STS_SUCCESS;

1086: FND_MSG_PUB.initialize;
1087: END IF;
1088:
1089: -- Initialize API return status to success
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091:
1092: --
1093: -- API body
1094: --

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

1106: x_return_status => x_return_status,
1107: x_msg_count => x_msg_count,
1108: x_msg_data => x_msg_data
1109: );
1110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1111: IF(l_statement_level >= l_debug_level) THEN
1112: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Create_Repair_Order','failed');
1113: END IF;
1114: RAISE FND_API.G_EXC_ERROR;

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1111: IF(l_statement_level >= l_debug_level) THEN
1112: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Create_Repair_Order','failed');
1113: END IF;
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117: x_repair_line_id := l_repair_line_id;
1118:

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

1124: p_product_txn_id => P.product_transaction_id,
1125: x_product_txn_Rec => l_original_product_txn_rec,
1126: x_return_status => x_return_status
1127: );
1128: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1129: IF(l_statement_level >= l_debug_level) THEN
1130: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Product_TXN_Record','failed');
1131: END IF;
1132: RAISE FND_API.G_EXC_ERROR;

Line 1132: RAISE FND_API.G_EXC_ERROR;

1128: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1129: IF(l_statement_level >= l_debug_level) THEN
1130: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Product_TXN_Record','failed');
1131: END IF;
1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134:
1135:
1136: l_original_product_txn_rec.PRODUCT_TRANSACTION_ID := FND_API.G_MISS_NUM;

Line 1136: l_original_product_txn_rec.PRODUCT_TRANSACTION_ID := FND_API.G_MISS_NUM;

1132: RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134:
1135:
1136: l_original_product_txn_rec.PRODUCT_TRANSACTION_ID := FND_API.G_MISS_NUM;
1137: CSD_PRODUCT_TRANSACTIONS_PKG.INSERT_ROW
1138: ( px_PRODUCT_TRANSACTION_ID => l_original_product_txn_rec.PRODUCT_TRANSACTION_ID,
1139: p_REPAIR_LINE_ID => l_repair_line_id,
1140: p_ESTIMATE_DETAIL_ID => l_original_product_txn_rec.estimate_detail_id,

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

1201: ( p_repair_line_id => l_repair_line_id,
1202: x_prod_txn_tbl => x_ship_prod_txn_tbl,
1203: x_return_status => x_return_status );
1204:
1205: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1206: IF(l_statement_level >= l_debug_level) THEN
1207: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Ship_Prod_Txn_Tbl','failed');
1208: END IF;
1209: RAISE FND_API.G_EXC_ERROR;

Line 1209: RAISE FND_API.G_EXC_ERROR;

1205: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1206: IF(l_statement_level >= l_debug_level) THEN
1207: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Ship_Prod_Txn_Tbl','failed');
1208: END IF;
1209: RAISE FND_API.G_EXC_ERROR;
1210: END IF;
1211:
1212:
1213: IF x_ship_prod_txn_tbl.COUNT > 0 THEN

Line 1219: p_commit => fnd_api.g_false,

1215: LOOP
1216:
1217: CSD_PROCESS_PVT.CREATE_PRODUCT_TXN
1218: (p_api_version => 1.0 ,
1219: p_commit => fnd_api.g_false,
1220: p_init_msg_list => 'F',
1221: p_validation_level => fnd_api.g_valid_level_full,
1222: x_product_txn_rec => x_ship_prod_txn_tbl(i),
1223: x_return_status => x_return_status,

Line 1221: p_validation_level => fnd_api.g_valid_level_full,

1217: CSD_PROCESS_PVT.CREATE_PRODUCT_TXN
1218: (p_api_version => 1.0 ,
1219: p_commit => fnd_api.g_false,
1220: p_init_msg_list => 'F',
1221: p_validation_level => fnd_api.g_valid_level_full,
1222: x_product_txn_rec => x_ship_prod_txn_tbl(i),
1223: x_return_status => x_return_status,
1224: x_msg_count => x_msg_count,
1225: x_msg_data => x_msg_data );

Line 1227: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1223: x_return_status => x_return_status,
1224: x_msg_count => x_msg_count,
1225: x_msg_data => x_msg_data );
1226:
1227: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1228: IF(l_statement_level >= l_debug_level) THEN
1229: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_PROCESS_UTIL.CREATE_PRODUCT_TXN','failed');
1230: END IF;
1231: RAISE FND_API.G_EXC_ERROR;

Line 1231: RAISE FND_API.G_EXC_ERROR;

1227: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1228: IF(l_statement_level >= l_debug_level) THEN
1229: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_PROCESS_UTIL.CREATE_PRODUCT_TXN','failed');
1230: END IF;
1231: RAISE FND_API.G_EXC_ERROR;
1232: END IF;
1233: END LOOP;
1234: END IF;
1235:

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

1243: x_msg_data => x_msg_data,
1244: p_original_repair_line_id => p_original_repair_line_id,
1245: p_new_repair_line_id => l_repair_line_id);
1246:
1247: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1248: IF(l_statement_level >= l_debug_level) THEN
1249: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History','failed');
1250: END IF;
1251: RAISE FND_API.G_EXC_ERROR;

Line 1251: RAISE FND_API.G_EXC_ERROR;

1247: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1248: IF(l_statement_level >= l_debug_level) THEN
1249: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History','failed');
1250: END IF;
1251: RAISE FND_API.G_EXC_ERROR;
1252: END IF;
1253:
1254: Copy_JTF_Notes (
1255: p_api_version => 1.0,

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

1261: x_msg_data => x_msg_data,
1262: p_original_repair_line_id => p_original_repair_line_id,
1263: p_new_repair_line_id => l_repair_line_id);
1264:
1265: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1266: IF(l_statement_level >= l_debug_level) THEN
1267: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes','failed');
1268: END IF;
1269: RAISE FND_API.G_EXC_ERROR;

Line 1269: RAISE FND_API.G_EXC_ERROR;

1265: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1266: IF(l_statement_level >= l_debug_level) THEN
1267: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes','failed');
1268: END IF;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;
1271:
1272: If (p_copy_attachment = 'Y') THEN
1273: CSD_REPAIRS_PVT.Copy_Attachments

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

1280: x_return_status => x_return_status,
1281: x_msg_count => x_msg_count,
1282: x_msg_data => x_msg_data);
1283:
1284: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1285: IF(l_statement_level >= l_debug_level) THEN
1286: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Copy_Attachments','failed');
1287: END IF;
1288: RAISE FND_API.G_EXC_ERROR;

Line 1288: RAISE FND_API.G_EXC_ERROR;

1284: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1285: IF(l_statement_level >= l_debug_level) THEN
1286: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIRS_PVT.Copy_Attachments','failed');
1287: END IF;
1288: RAISE FND_API.G_EXC_ERROR;
1289: END IF;
1290: END if;
1291:
1292: -- End of API body

Line 1295: IF FND_API.To_Boolean( p_commit ) THEN

1291:
1292: -- End of API body
1293: --
1294: -- Standard check of p_commit.
1295: IF FND_API.To_Boolean( p_commit ) THEN
1296: COMMIT WORK;
1297: END IF;
1298:
1299: -- Standard call to get message count and if count is 1, get message info.

Line 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: p_data => x_msg_data
1303: );
1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: ROLLBACK TO CSD_SPLIT_PKG;
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MSG_PUB.Count_And_Get
1310: ( p_count => x_msg_count,

Line 1308: x_return_status := FND_API.G_RET_STS_ERROR;

1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: ROLLBACK TO CSD_SPLIT_PKG;
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MSG_PUB.Count_And_Get
1310: ( p_count => x_msg_count,
1311: p_data => x_msg_data
1312: );

Line 1318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1314: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1315: 'CSD.PLSQL.CSD_SPLIT_PKG.Create_New_Repair_Order',
1316: 'EXC_ERROR ['||x_msg_data||']');
1317: END IF;
1318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1319: ROLLBACK TO CSD_SPLIT_PKG;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count,

Line 1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1316: 'EXC_ERROR ['||x_msg_data||']');
1317: END IF;
1318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1319: ROLLBACK TO CSD_SPLIT_PKG;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count,
1323: p_data => x_msg_data
1324: );

Line 1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1328: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1329: END IF;
1330: WHEN OTHERS THEN
1331: ROLLBACK TO CSD_SPLIT_PKG;
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1333: IF FND_MSG_PUB.Check_Msg_Level
1334: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1335: THEN
1336: FND_MSG_PUB.Add_Exc_Msg

Line 1384: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1380: Begin
1381:
1382:
1383: -- Initialize message list if p_init_msg_list is set to TRUE.
1384: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1385: FND_MSG_PUB.initialize;
1386: END IF;
1387:
1388: -- Initialize API return status to success

Line 1389: x_return_status := FND_API.G_RET_STS_SUCCESS;

1385: FND_MSG_PUB.initialize;
1386: END IF;
1387:
1388: -- Initialize API return status to success
1389: x_return_status := FND_API.G_RET_STS_SUCCESS;
1390:
1391: --
1392: -- API body
1393: --

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

1401: p_original_repair_history_id => C.repair_history_id,
1402: x_repair_history_Rec => l_repair_history_rec,
1403: x_return_status => x_return_status
1404: );
1405: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1406: IF(l_statement_level >= l_debug_level) THEN
1407: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repair_History_Record','failed');
1408: END IF;
1409: RAISE FND_API.G_EXC_ERROR;

Line 1409: RAISE FND_API.G_EXC_ERROR;

1405: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1406: IF(l_statement_level >= l_debug_level) THEN
1407: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_SPLIT_PKG.Build_Repair_History_Record','failed');
1408: END IF;
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;
1411:
1412:
1413: l_repair_history_rec.repair_line_id := p_new_repair_line_id;

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

1422: X_Return_Status => x_return_status,
1423: X_Msg_Count => x_msg_count,
1424: X_Msg_Data => x_msg_data
1425: );
1426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1427: IF(l_statement_level >= l_debug_level) THEN
1428: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
1429: END IF;
1430: RAISE FND_API.G_EXC_ERROR;

Line 1430: RAISE FND_API.G_EXC_ERROR;

1426: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1427: IF(l_statement_level >= l_debug_level) THEN
1428: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.CSD_REPAIR_HISTORY_PVT.Create_repair_history','failed');
1429: END IF;
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: end loop;
1434: IF c_repair_history_id%isopen then

Line 1442: IF FND_API.To_Boolean( p_commit ) THEN

1438:
1439: -- End of API body
1440: --
1441: -- Standard check of p_commit.
1442: IF FND_API.To_Boolean( p_commit ) THEN
1443: COMMIT WORK;
1444: END IF;
1445:
1446: -- Standard call to get message count and if count is 1, get message info.

Line 1452: WHEN FND_API.G_EXC_ERROR THEN

1448: ( p_count => x_msg_count,
1449: p_data => x_msg_data
1450: );
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: ROLLBACK TO CSD_SPLIT_PKG;
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: FND_MSG_PUB.Count_And_Get
1456: ( p_count => x_msg_count,

Line 1454: x_return_status := FND_API.G_RET_STS_ERROR;

1450: );
1451: EXCEPTION
1452: WHEN FND_API.G_EXC_ERROR THEN
1453: ROLLBACK TO CSD_SPLIT_PKG;
1454: x_return_status := FND_API.G_RET_STS_ERROR;
1455: FND_MSG_PUB.Count_And_Get
1456: ( p_count => x_msg_count,
1457: p_data => x_msg_data
1458: );

Line 1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1460: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1461: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_Repair_History',
1462: 'EXC_ERROR ['||x_msg_data||']');
1463: END IF;
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: ROLLBACK TO CSD_SPLIT_PKG;
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count,

Line 1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1462: 'EXC_ERROR ['||x_msg_data||']');
1463: END IF;
1464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1465: ROLLBACK TO CSD_SPLIT_PKG;
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1467: FND_MSG_PUB.Count_And_Get
1468: ( p_count => x_msg_count,
1469: p_data => x_msg_data
1470: );

Line 1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1474: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1475: END IF;
1476: WHEN OTHERS THEN
1477: ROLLBACK TO CSD_SPLIT_PKG;
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1479: IF FND_MSG_PUB.Check_Msg_Level
1480: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1481: THEN
1482: FND_MSG_PUB.Add_Exc_Msg

Line 1524: x_return_status := FND_API.G_RET_STS_SUCCESS;

1520:
1521: begin
1522:
1523: -- Initialize API return status to success
1524: x_return_status := FND_API.G_RET_STS_SUCCESS;
1525:
1526: OPEN c_repair_history_record(p_original_repair_history_id);
1527: FETCH c_repair_history_record INTO
1528: x_repair_history_Rec.request_id, x_repair_history_Rec.program_id, x_repair_history_Rec.program_application_id,

Line 1547: RAISE FND_API.G_EXC_ERROR;

1543: IF c_repair_history_record%notfound then
1544: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1545: FND_MESSAGE.SET_TOKEN('p_original_repair_history_id',p_original_repair_history_id);
1546: FND_MSG_PUB.ADD;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END IF;
1549:
1550: IF c_repair_history_record%isopen then
1551: CLOSE c_repair_history_record;

Line 1597: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1593: Begin
1594:
1595:
1596: -- Initialize message list if p_init_msg_list is set to TRUE.
1597: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1598: FND_MSG_PUB.initialize;
1599: END IF;
1600:
1601: -- Initialize API return status to success

Line 1602: x_return_status := FND_API.G_RET_STS_SUCCESS;

1598: FND_MSG_PUB.initialize;
1599: END IF;
1600:
1601: -- Initialize API return status to success
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1603:
1604: --
1605: -- API body
1606: --

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

1648: , p_context => C.CONTEXT
1649: , p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
1650: );
1651:
1652: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1653: IF(l_statement_level >= l_debug_level) THEN
1654: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.JTF_NOTES_PUB.create_note','failed');
1655: END IF;
1656: RAISE FND_API.G_EXC_ERROR;

Line 1656: RAISE FND_API.G_EXC_ERROR;

1652: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1653: IF(l_statement_level >= l_debug_level) THEN
1654: FND_LOG.STRING(l_statement_level,'CSD.PLSQL.JTF_NOTES_PUB.create_note','failed');
1655: END IF;
1656: RAISE FND_API.G_EXC_ERROR;
1657: END IF;
1658:
1659: end loop;
1660: IF c_jtf_note_id%isopen then

Line 1668: IF FND_API.To_Boolean( p_commit ) THEN

1664:
1665: -- End of API body
1666: --
1667: -- Standard check of p_commit.
1668: IF FND_API.To_Boolean( p_commit ) THEN
1669: COMMIT WORK;
1670: END IF;
1671:
1672: -- Standard call to get message count and if count is 1, get message info.

Line 1679: WHEN FND_API.G_EXC_ERROR THEN

1675: p_data => x_msg_data
1676: );
1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: ROLLBACK TO CSD_SPLIT_PKG;
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: FND_MSG_PUB.Count_And_Get
1683: ( p_count => x_msg_count,

Line 1681: x_return_status := FND_API.G_RET_STS_ERROR;

1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: ROLLBACK TO CSD_SPLIT_PKG;
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: FND_MSG_PUB.Count_And_Get
1683: ( p_count => x_msg_count,
1684: p_data => x_msg_data
1685: );

Line 1691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1687: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
1688: 'CSD.PLSQL.CSD_SPLIT_PKG.Copy_JTF_Notes',
1689: 'EXC_ERROR ['||x_msg_data||']');
1690: END IF;
1691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1692: ROLLBACK TO CSD_SPLIT_PKG;
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1694: FND_MSG_PUB.Count_And_Get
1695: ( p_count => x_msg_count,

Line 1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1689: 'EXC_ERROR ['||x_msg_data||']');
1690: END IF;
1691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1692: ROLLBACK TO CSD_SPLIT_PKG;
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1694: FND_MSG_PUB.Count_And_Get
1695: ( p_count => x_msg_count,
1696: p_data => x_msg_data
1697: );

Line 1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1701: 'EXC_UNEXPECTED_ERROR ['||x_msg_data||']');
1702: END IF;
1703: WHEN OTHERS THEN
1704: ROLLBACK TO CSD_SPLIT_PKG;
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1706: IF FND_MSG_PUB.Check_Msg_Level
1707: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1708: THEN
1709: FND_MSG_PUB.Add_Exc_Msg

Line 1801: x_return_status := FND_API.G_RET_STS_SUCCESS;

1797: and organization_id = p_org_id;
1798:
1799: BEGIN
1800:
1801: x_return_status := FND_API.G_RET_STS_SUCCESS;
1802:
1803: --taklam
1804: -- return;
1805:

Line 1839: RAISE FND_API.G_EXC_ERROR;

1835: IF repair_line_dtls%notfound then
1836: FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_REP_LINE_ID');
1837: FND_MESSAGE.SET_TOKEN('REPAIR_LINE_ID',p_repair_line_id);
1838: FND_MSG_PUB.ADD;
1839: RAISE FND_API.G_EXC_ERROR;
1840: END IF;
1841:
1842: IF repair_line_dtls%isopen then
1843: CLOSE repair_line_dtls;

Line 1869: x_prod_txn_tbl(1).lot_number := FND_API.G_MISS_CHAR;

1865: x_prod_txn_tbl(1).business_process_id := l_bus_process_id ;
1866: x_prod_txn_tbl(1).inventory_item_id := l_inv_item_id ;
1867: x_prod_txn_tbl(1).unit_of_measure_code := l_unit_of_measure ;
1868: x_prod_txn_tbl(1).quantity := l_quantity ;
1869: x_prod_txn_tbl(1).lot_number := FND_API.G_MISS_CHAR;
1870: x_prod_txn_tbl(1).price_list_id := l_price_list_id ;
1871: -- x_prod_txn_tbl(1).contract_id := l_contract_id ;
1872: x_prod_txn_tbl(1).sub_inventory := FND_API.G_MISS_CHAR;
1873: x_prod_txn_tbl(1).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);

Line 1872: x_prod_txn_tbl(1).sub_inventory := FND_API.G_MISS_CHAR;

1868: x_prod_txn_tbl(1).quantity := l_quantity ;
1869: x_prod_txn_tbl(1).lot_number := FND_API.G_MISS_CHAR;
1870: x_prod_txn_tbl(1).price_list_id := l_price_list_id ;
1871: -- x_prod_txn_tbl(1).contract_id := l_contract_id ;
1872: x_prod_txn_tbl(1).sub_inventory := FND_API.G_MISS_CHAR;
1873: x_prod_txn_tbl(1).no_charge_flag := csd_process_util.get_no_chg_flag(l_cps_txn_billing_type_id);
1874: x_prod_txn_tbl(1).interface_to_om_flag := 'N' ;
1875: x_prod_txn_tbl(1).book_sales_order_flag := 'N' ;
1876: x_prod_txn_tbl(1).release_sales_order_flag := 'N' ;

Line 1895: WHEN FND_API.G_EXC_ERROR THEN

1891: x_prod_txn_tbl(1).po_number := l_po_number; -- swai bug fix 4535829
1892:
1893: END IF;
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: x_return_status := FND_API.G_RET_STS_ERROR ;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: WHEN OTHERS THEN

Line 1896: x_return_status := FND_API.G_RET_STS_ERROR ;

1892:
1893: END IF;
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: x_return_status := FND_API.G_RET_STS_ERROR ;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1893: END IF;
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: x_return_status := FND_API.G_RET_STS_ERROR ;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1901: END build_ship_prod_txn_tbl;

Line 1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: x_return_status := FND_API.G_RET_STS_ERROR ;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1901: END build_ship_prod_txn_tbl;
1902:

Line 1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1896: x_return_status := FND_API.G_RET_STS_ERROR ;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1899: WHEN OTHERS THEN
1900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1901: END build_ship_prod_txn_tbl;
1902:
1903:
1904: End CSD_SPLIT_PKG;