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_REPAIRS_PUB dependencies on FND_API

Line 56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

52: * @rep:lifecycle active
53: * @rep:displayname Create Repair Order
54: */
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,

Line 57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

53: * @rep:displayname Create Repair Order
54: */
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
61: p_create_default_logistics IN VARCHAR2 := 'N',

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

54: */
55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
61: p_create_default_logistics IN VARCHAR2 := 'N',
62: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,

Line 59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,

55: PROCEDURE Create_Repair_Order(P_Api_Version_Number IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
57: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: P_REPAIR_LINE_ID IN NUMBER := FND_API.G_MISS_NUM,
60: P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type,
61: p_create_default_logistics IN VARCHAR2 := 'N',
62: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
63: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,

Line 82: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

78: --
79: -- Standard Start of API savepoint
80: SAVEPOINT CREATE_REPAIR_ORDER_PUB;
81: -- Standard call to check for call compatibility.
82: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
86: THEN

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: p_api_version_number,
84: l_api_name,
85: G_PKG_NAME)
86: THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: END IF;
89: -- Initialize message list if p_init_msg_list is set to TRUE.
90: IF FND_API.to_Boolean(p_init_msg_list)
91: THEN

Line 90: IF FND_API.to_Boolean(p_init_msg_list)

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

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96: --
97: -- API body
98: --
99: CSD_REPAIRS_PVT.Create_Repair_Order(P_Api_Version_Number => 1.0,

Line 112: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)

108: X_Msg_Count => x_msg_count,
109: X_Msg_Data => x_msg_data);
110: --
111: -- Check return status from the above procedure call
112: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
113: then
114: ROLLBACK TO CREATE_REPAIR_ORDER_PUB;
115: return;
116: END IF;

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

127: x_msg_count => X_Msg_Count,
128: x_msg_data => X_Msg_Data
129: );
130:
131: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: END IF;

Line 132: RAISE FND_API.G_EXC_ERROR;

128: x_msg_data => X_Msg_Data
129: );
130:
131: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: END IF;
136:

Line 141: p_init_msg_list => Fnd_Api.G_FALSE,

137: -- swai: 12.1.1 bug 7176940 - check service bulletins after RO creation
138: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
139: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
140: p_api_version_number => 1.0,
141: p_init_msg_list => Fnd_Api.G_FALSE,
142: p_commit => Fnd_Api.G_FALSE,
143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
144: p_repair_line_id => x_repair_line_id,
145: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,

Line 142: p_commit => Fnd_Api.G_FALSE,

138: IF (nvl(fnd_profile.value('CSD_AUTO_CHECK_BULLETINS'),'N') = 'Y') THEN
139: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
140: p_api_version_number => 1.0,
141: p_init_msg_list => Fnd_Api.G_FALSE,
142: p_commit => Fnd_Api.G_FALSE,
143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
144: p_repair_line_id => x_repair_line_id,
145: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
146: x_return_status => l_return_status,

Line 143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

139: CSD_RO_BULLETINS_PVT.LINK_BULLETINS_TO_RO(
140: p_api_version_number => 1.0,
141: p_init_msg_list => Fnd_Api.G_FALSE,
142: p_commit => Fnd_Api.G_FALSE,
143: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
144: p_repair_line_id => x_repair_line_id,
145: px_ro_sc_ids_tbl => l_ro_sc_ids_tbl,
146: x_return_status => l_return_status,
147: x_msg_count => l_msg_count,

Line 157: IF FND_API.to_Boolean(p_commit)

153: --
154: -- End of API body.
155: --
156: -- Standard check for p_commit
157: IF FND_API.to_Boolean(p_commit)
158: THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard call to get message count and if count is 1, get message info.

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
163: p_data => x_msg_data);
164: --
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
168: P_PKG_NAME => G_PKG_NAME,
169: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
170: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,

Line 176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

172: X_MSG_DATA => X_MSG_DATA,
173: X_RETURN_STATUS => X_RETURN_STATUS);
174: -- RAISE;
175: --
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
178: P_PKG_NAME => G_PKG_NAME,
179: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
180: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,

Line 199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

195: --
196: End Create_Repair_Order;
197:
198: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_REPAIR_LINE_ID IN NUMBER,
203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,

Line 200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

196: End Create_Repair_Order;
197:
198: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_REPAIR_LINE_ID IN NUMBER,
203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,

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

197:
198: PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
199: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
200: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: p_REPAIR_LINE_ID IN NUMBER,
203: P_REPLN_Rec IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
204: X_Return_Status OUT NOCOPY VARCHAR2,
205: X_Msg_Count OUT NOCOPY NUMBER,

Line 216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

212: --
213: -- Standard Start of API savepoint
214: SAVEPOINT UPDATE_REPAIR_ORDER_PUB;
215: -- Standard call to check for call compatibility.
216: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: p_api_version_number,
218: l_api_name,
219: G_PKG_NAME)
220: THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: -- Initialize message list if p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean(p_init_msg_list)
225: THEN

Line 224: IF FND_API.to_Boolean(p_init_msg_list)

220: THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: -- Initialize message list if p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean(p_init_msg_list)
225: THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to SUCCESS

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

225: THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to SUCCESS
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230: --
231: -- API body
232: --
233: CSD_repairs_PVT.Update_Repair_Order(P_Api_Version_Number => 1.0,

Line 244: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)

240: X_Msg_Count => x_msg_count,
241: X_Msg_Data => x_msg_data);
242: --
243: -- Check return status from the above procedure call
244: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
245: then
246: ROLLBACK TO UPDATE_REPAIR_ORDER_PUB;
247: return;
248: END IF;

Line 253: IF FND_API.to_Boolean(p_commit)

249: --
250: -- End of API body.
251: --
252: -- Standard check for p_commit
253: IF FND_API.to_Boolean(p_commit)
254: THEN
255: COMMIT WORK;
256: END IF;
257: -- Standard call to get message count and if count is 1, get message info.

Line 262: WHEN FND_API.G_EXC_ERROR THEN

258: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
259: p_data => x_msg_data);
260: --
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
264: P_PKG_NAME => G_PKG_NAME,
265: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
266: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,

Line 272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

268: X_MSG_DATA => X_MSG_DATA,
269: X_RETURN_STATUS => X_RETURN_STATUS);
270: -- RAISE;
271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
274: P_PKG_NAME => G_PKG_NAME,
275: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
276: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,

Line 327: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

323: --
324: -- Standard Start of API savepoint
325: SAVEPOINT UPDATE_RO_STATUS_PUB;
326: -- Standard call to check for call compatibility.
327: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
328: p_api_version,
329: l_api_name,
330: G_PKG_NAME)
331: THEN

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328: p_api_version,
329: l_api_name,
330: G_PKG_NAME)
331: THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334: -- Initialize message list if p_init_msg_list is set to TRUE.
335: IF FND_API.to_Boolean(p_init_msg_list)
336: THEN

Line 335: IF FND_API.to_Boolean(p_init_msg_list)

331: THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334: -- Initialize message list if p_init_msg_list is set to TRUE.
335: IF FND_API.to_Boolean(p_init_msg_list)
336: THEN
337: FND_MSG_PUB.initialize;
338: END IF;
339: -- Initialize API return status to success

Line 340: x_return_status := FND_API.G_RET_STS_SUCCESS;

336: THEN
337: FND_MSG_PUB.initialize;
338: END IF;
339: -- Initialize API return status to success
340: x_return_status := FND_API.G_RET_STS_SUCCESS;
341: --
342: -- API body
343: --
344: CSD_REPAIRS_PVT.UPDATE_RO_STATUS(P_Api_Version => p_api_version,

Line 347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

343: --
344: CSD_REPAIRS_PVT.UPDATE_RO_STATUS(P_Api_Version => p_api_version,
345: P_Commit => p_commit,
346: P_Init_Msg_List => p_init_msg_list,
347: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
348: X_Return_Status => x_return_status,
349: X_Msg_Count => x_msg_count,
350: X_Msg_Data => x_msg_data,
351: P_REPAIR_STATUS_REC => p_repair_status_rec,

Line 356: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)

352: P_STATUS_CONTROL_REC => p_status_upd_control_rec,
353: X_OBJECT_VERSION_NUMBER => x_object_Version_number);
354: --
355: -- Check return status from the above procedure call
356: IF not (x_return_status = FND_API.G_RET_STS_SUCCESS)
357: then
358: ROLLBACK TO UPDATE_RO_STATUS_PUB;
359: return;
360: END IF;

Line 365: IF FND_API.to_Boolean(p_commit)

361: --
362: -- End of API body.
363: --
364: -- Standard check for p_commit
365: IF FND_API.to_Boolean(p_commit)
366: THEN
367: COMMIT WORK;
368: END IF;
369: -- Standard call to get message count and if count is 1, get message info.

Line 374: WHEN Fnd_Api.G_EXC_ERROR THEN

370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
371: p_data => x_msg_data);
372: --
373: EXCEPTION
374: WHEN Fnd_Api.G_EXC_ERROR THEN
375: x_return_status := Fnd_Api.G_RET_STS_ERROR;
376: ROLLBACK TO UPDATE_RO_STATUS_PUB;
377: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
378: p_data => x_msg_data);

Line 375: x_return_status := Fnd_Api.G_RET_STS_ERROR;

371: p_data => x_msg_data);
372: --
373: EXCEPTION
374: WHEN Fnd_Api.G_EXC_ERROR THEN
375: x_return_status := Fnd_Api.G_RET_STS_ERROR;
376: ROLLBACK TO UPDATE_RO_STATUS_PUB;
377: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
378: p_data => x_msg_data);
379: IF (Fnd_Log.level_error >= Fnd_Log.g_current_runtime_level)

Line 386: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

382: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
383: 'EXC_ERROR[' || x_msg_data || ']');
384: END IF;
385:
386: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
388: ROLLBACK TO UPDATE_RO_STATUS_PUB;
389: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
390: p_data => x_msg_data);

Line 387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

383: 'EXC_ERROR[' || x_msg_data || ']');
384: END IF;
385:
386: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
388: ROLLBACK TO UPDATE_RO_STATUS_PUB;
389: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
390: p_data => x_msg_data);
391: IF (Fnd_Log.level_exception >= Fnd_Log.g_current_runtime_level)

Line 398: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

394: 'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
395: 'EXC_UNEXP_ERROR[' || x_msg_data || ']');
396: END IF;
397: WHEN OTHERS THEN
398: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
399: Rollback TO UPDATE_RO_STATUS_PUB;
400: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
401: THEN
402: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);