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

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87:
88:
89: BEGIN
90: --Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF (l_log_procedure >= l_log_current_level) THEN
94: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin',
95: 'At the start of the procedure. p_instance_id = ' || p_instance_id ||

Line 116: RAISE FND_API.G_EXC_ERROR;

112: END IF;
113: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_DATE');
114: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:
119: IF (l_log_statement >= l_log_current_level) THEN
120: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Validating MR status.');

Line 130: RAISE FND_API.G_EXC_ERROR;

126: END IF;
127: FND_MESSAGE.set_name('AHL','AHL_OSP_ACC_INV_STATUS');
128: FND_MESSAGE.set_token('TITLE',l_mr_dtls.title);
129: FND_MSG_PUB.add;
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132: --Modification by JROTICH for bug#13798727 END
133:
134:

Line 152: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN

148: IF (l_log_statement >= l_log_current_level) THEN
149: fnd_log.string(l_log_statement, L_FULL_NAME, 'Returned from call to AHL_UMP_UNPLANNED_PVT.CREATE_UNIT_EFFECTIVITY. x_return_status = ' || l_return_status || ' and x_orig_ue_id = ' || l_ue_id);
150: END IF;
151:
152: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
153: x_msg_count := l_msg_count;
154: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: x_return_status := l_return_status;
156: ELSE

Line 154: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

150: END IF;
151:
152: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
153: x_msg_count := l_msg_count;
154: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: x_return_status := l_return_status;
156: ELSE
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: END IF;

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153: x_msg_count := l_msg_count;
154: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
155: x_return_status := l_return_status;
156: ELSE
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: END IF;
159: -- Unable to create UMP successfully. Return early
160: RETURN;
161: END IF;

Line 177: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN

173: IF (l_log_statement >= l_log_current_level) THEN
174: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Accomplish_UMP. x_return_status = ' || l_return_status);
175: END IF;
176:
177: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
178: x_msg_count := l_msg_count;
179: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: x_return_status := l_return_status;
181: ELSE

Line 179: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

175: END IF;
176:
177: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
178: x_msg_count := l_msg_count;
179: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: x_return_status := l_return_status;
181: ELSE
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: END IF;

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

178: x_msg_count := l_msg_count;
179: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: x_return_status := l_return_status;
181: ELSE
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: END IF;
184: ELSE
185: x_return_status := l_return_status; -- Success
186: END IF;

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: WHERE UNIT_EFFECTIVITY_ID = c_unit_effectivity_id;
242:
243: BEGIN
244: --Initialize API return status to success
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: IF (l_log_procedure >= l_log_current_level) THEN
248: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.begin',
249: 'At the start of the procedure. p_unit_effectivity_id = ' || p_unit_effectivity_id ||

Line 283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

279: p_actual_date => p_accomplishment_date,
280: x_counter_tbl => l_reset_counter_tbl);
281: END IF;
282:
283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;

Line 284: RAISE FND_API.G_EXC_ERROR;

280: x_counter_tbl => l_reset_counter_tbl);
281: END IF;
282:
283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:

Line 285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

281: END IF;
282:
283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: IF (l_reset_counter_tbl IS NOT NULL AND l_reset_counter_tbl.COUNT > 0) THEN

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282:
283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
284: RAISE FND_API.G_EXC_ERROR;
285: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: IF (l_reset_counter_tbl IS NOT NULL AND l_reset_counter_tbl.COUNT > 0) THEN
290: IF (l_log_statement >= l_log_current_level) THEN

Line 302: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

298: p_actual_end_date => p_accomplishment_date,
299: x_msg_count => l_msg_count,
300: x_msg_data => l_msg_data);
301:
302: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
303: IF (l_msg_data IS NOT NULL) THEN
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: x_msg_count := l_msg_count;
306: x_msg_data := l_msg_data;

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300: x_msg_data => l_msg_data);
301:
302: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
303: IF (l_msg_data IS NOT NULL) THEN
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: x_msg_count := l_msg_count;
306: x_msg_data := l_msg_data;
307: END IF;
308: RAISE FND_API.G_EXC_ERROR;

Line 308: RAISE FND_API.G_EXC_ERROR;

304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: x_msg_count := l_msg_count;
306: x_msg_data := l_msg_data;
307: END IF;
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF; -- There are reset counters

Line 309: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

305: x_msg_count := l_msg_count;
306: x_msg_data := l_msg_data;
307: END IF;
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF; -- There are reset counters
313: l_reset_counter_tbl.DELETE;

Line 310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

306: x_msg_data := l_msg_data;
307: END IF;
308: RAISE FND_API.G_EXC_ERROR;
309: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
311: END IF;
312: END IF; -- There are reset counters
313: l_reset_counter_tbl.DELETE;
314:

Line 323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

319: l_return_status := AHL_COMPLETIONS_PVT.get_cp_counters(p_item_instance_id => l_instance_id,
320: p_wip_entity_id => null,
321: p_actual_date => p_accomplishment_date,
322: x_counter_tbl => l_counter_tbl);
323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;

Line 324: RAISE FND_API.G_EXC_ERROR;

320: p_wip_entity_id => null,
321: p_actual_date => p_accomplishment_date,
322: x_counter_tbl => l_counter_tbl);
323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:

Line 325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

321: p_actual_date => p_accomplishment_date,
322: x_counter_tbl => l_counter_tbl);
323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: IF (l_log_statement >= l_log_current_level) THEN

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322: x_counter_tbl => l_counter_tbl);
323: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
324: RAISE FND_API.G_EXC_ERROR;
325: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: IF (l_log_statement >= l_log_current_level) THEN
330: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Updating UMP...');

Line 341: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

337: p_dml_flag => 'C',
338: x_msg_count => l_msg_count,
339: x_msg_data => l_msg_data);
340:
341: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
342: IF (l_msg_data IS NOT NULL) THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := l_msg_count;
345: x_msg_data := l_msg_data;

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: x_msg_data => l_msg_data);
340:
341: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
342: IF (l_msg_data IS NOT NULL) THEN
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := l_msg_count;
345: x_msg_data := l_msg_data;
346: END IF;
347: RAISE FND_API.G_EXC_ERROR;

Line 347: RAISE FND_API.G_EXC_ERROR;

343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: x_msg_count := l_msg_count;
345: x_msg_data := l_msg_data;
346: END IF;
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351: l_counter_tbl.DELETE;

Line 348: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

344: x_msg_count := l_msg_count;
345: x_msg_data := l_msg_data;
346: END IF;
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351: l_counter_tbl.DELETE;
352:

Line 349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

345: x_msg_data := l_msg_data;
346: END IF;
347: RAISE FND_API.G_EXC_ERROR;
348: ELSIF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: END IF;
351: l_counter_tbl.DELETE;
352:
353: i := l_child_ue_ids_tbl.NEXT(i);

Line 375: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE

371: -- Parameters :
372: --
373: -- Standard IN Parameters :
374: -- p_api_version IN NUMBER Default 1.0
375: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
376: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
377: -- Standard OUT Parameters :
378: -- x_return_status OUT VARCHAR2 Required
379: -- x_msg_count OUT NUMBER Required

Line 376: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

372: --
373: -- Standard IN Parameters :
374: -- p_api_version IN NUMBER Default 1.0
375: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
376: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
377: -- Standard OUT Parameters :
378: -- x_return_status OUT VARCHAR2 Required
379: -- x_msg_count OUT NUMBER Required
380: -- x_msg_data OUT VARCHAR2 Required

Line 397: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

393: -- End of Comments.
394: ----------------------------------------------------------------------------------------
395: PROCEDURE accomplish_osp_mrs(
396: p_api_version IN NUMBER := 1.0,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: p_accomplishment_id IN NUMBER,
400: p_osp_order_line_id IN NUMBER,
401: x_return_status OUT NOCOPY VARCHAR2,

Line 398: p_commit IN VARCHAR2 := FND_API.G_FALSE,

394: ----------------------------------------------------------------------------------------
395: PROCEDURE accomplish_osp_mrs(
396: p_api_version IN NUMBER := 1.0,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
398: p_commit IN VARCHAR2 := FND_API.G_FALSE,
399: p_accomplishment_id IN NUMBER,
400: p_osp_order_line_id IN NUMBER,
401: x_return_status OUT NOCOPY VARCHAR2,
402: x_msg_count OUT NOCOPY NUMBER,

Line 409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

405:
406: L_API_NAME CONSTANT VARCHAR2(30) := 'Accomplish_Osp_Mrs';
407: L_API_VERSION CONSTANT NUMBER := 1.0;
408: L_FULL_NAME CONSTANT VARCHAR2(100) := G_LOG_PREFIX || '.' || L_API_NAME;
409: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
410: l_dummy VARCHAR2(1);
411: l_osp_order_line_id NUMBER;
412: i NUMBER;
413: j NUMBER;

Line 487: IF NOT FND_API.Compatible_API_Call(L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN

483: ', p_osp_order_line_id = ' || p_osp_order_line_id);
484: END IF;
485:
486: -- Standard call to check for call compatibility
487: IF NOT FND_API.Compatible_API_Call(L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: END IF;
485:
486: -- Standard call to check for call compatibility
487: IF NOT FND_API.Compatible_API_Call(L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE
492: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 492: IF FND_API.To_Boolean(p_init_msg_list) THEN

488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE
492: IF FND_API.To_Boolean(p_init_msg_list) THEN
493: FND_MSG_PUB.Initialize;
494: END IF;
495:
496: -- Initialize API return status to success

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: FND_MSG_PUB.Initialize;
494: END IF;
495:
496: -- Initialize API return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: -- Begin Processing
500:
501: IF (p_accomplishment_id IS NOT NULL) THEN

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: CLOSE chk_accomplishment_csr;
507: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_ACCOM_ID');
508: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512: CLOSE chk_accomplishment_csr;
513:
514: -- If OSP Order Line Id is also passed, validate it to ensure that it matches the Accomplishment Id

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_ACCOM_ID_MISMATCH');
517: FND_MESSAGE.set_token('ACCOM_ID', p_accomplishment_id);
518: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END IF;
522:
523: -- Validate that the part has been received against the OSP Line
524: OPEN get_received_quantity_csr(l_osp_order_line_id);

Line 531: RAISE FND_API.G_EXC_ERROR;

527:
528: IF (l_received_quantity IS NULL OR l_received_quantity < 1) THEN
529: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NOT_RECEIVED');
530: FND_MSG_PUB.ADD;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533:
534: -- Populate a table of Numbers with the single Accomplishment Id (will have only one record)
535: l_accomplishment_ids_tbl(1) := p_accomplishment_id;

Line 541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

537: -- Ensure that p_osp_order_line_id is not null.
538: IF (p_osp_order_line_id IS NULL) THEN
539: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_MISSING_PARAMS');
540: FND_MSG_PUB.ADD;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END IF;
543:
544: -- Validate that the OSP Order Line Id is valid
545: OPEN chk_osp_line_csr(c_osp_order_line_id => p_osp_order_line_id);

Line 552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

548: CLOSE chk_osp_line_csr;
549: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_INV_OSP_LINE_ID');
550: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
551: FND_MSG_PUB.ADD;
552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
553: END IF;
554: CLOSE chk_osp_line_csr;
555:
556: -- Validate that the part has been received against the OSP Line

Line 564: RAISE FND_API.G_EXC_ERROR;

560:
561: IF (l_received_quantity IS NULL OR l_received_quantity < 1) THEN
562: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NOT_RECIEVED');
563: FND_MSG_PUB.ADD;
564: RAISE FND_API.G_EXC_ERROR;
565: END IF;
566:
567: -- Populate a table of Numbers with the Id of the Open Accomplishments assigned to this OSP Line
568: OPEN get_accomplishments_csr(c_osp_order_line_id => p_osp_order_line_id);

Line 577: RAISE FND_API.G_EXC_ERROR;

573: IF (l_accomplishment_ids_tbl.COUNT = 0) THEN
574: FND_MESSAGE.set_name(G_APP_NAME, 'AHL_OSP_NO_ACCOMS');
575: FND_MESSAGE.set_token('OSP_LINE_ID', p_osp_order_line_id);
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579: END IF; -- Else (p_accomplishment_id is null)
580:
581: i := l_accomplishment_ids_tbl.FIRST;

Line 603: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN

599: IF (l_log_statement >= l_log_current_level) THEN
600: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Create_And_Accomplish_Mr. x_return_status = ' || l_return_status);
601: END IF;
602:
603: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: ELSE
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

600: FND_LOG.STRING(l_log_statement, L_FULL_NAME, 'Returned from call to Create_And_Accomplish_Mr. x_return_status = ' || l_return_status);
601: END IF;
602:
603: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: ELSE
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;

Line 605: RAISE FND_API.G_EXC_ERROR;

601: END IF;
602:
603: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: ELSE
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: END IF;

Line 607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

603: IF l_msg_count > 0 OR NVL(l_return_status,'X') <> Fnd_Api.G_RET_STS_SUCCESS THEN
604: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
605: RAISE FND_API.G_EXC_ERROR;
606: ELSE
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: END IF;
610:
611: IF (l_log_statement >= l_log_current_level) THEN

Line 676: IF FND_API.TO_BOOLEAN(p_commit) THEN

672:
673: END LOOP; -- For all Open Accomplishments
674:
675: -- Standard check of p_commit
676: IF FND_API.TO_BOOLEAN(p_commit) THEN
677: COMMIT WORK;
678: END IF;
679:
680: -- Standard call to get message count and if count is 1, get message info

Line 684: p_encoded => fnd_api.g_false

680: -- Standard call to get message count and if count is 1, get message info
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count,
683: p_data => x_msg_data,
684: p_encoded => fnd_api.g_false
685: );
686:
687: IF (l_log_procedure >= l_log_current_level) THEN
688: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.end', 'End Procedure');

Line 692: WHEN FND_API.G_EXC_ERROR THEN

688: FND_LOG.STRING(l_log_procedure, L_FULL_NAME || '.end', 'End Procedure');
689: END IF;
690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: Rollback to accomplish_osp_mrs_pvt;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
696: p_data => x_msg_data,

Line 694: x_return_status := FND_API.G_RET_STS_ERROR;

690:
691: EXCEPTION
692: WHEN FND_API.G_EXC_ERROR THEN
693: Rollback to accomplish_osp_mrs_pvt;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
696: p_data => x_msg_data,
697: p_encoded => fnd_api.g_false);
698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN

Line 697: p_encoded => fnd_api.g_false);

693: Rollback to accomplish_osp_mrs_pvt;
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
696: p_data => x_msg_data,
697: p_encoded => fnd_api.g_false);
698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_FULL_NAME, 'Execution Exception: ' || x_msg_data);
700: END IF;
701:

Line 702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

698: IF (FND_LOG.LEVEL_EXCEPTION >= l_log_current_level) THEN
699: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, L_FULL_NAME, 'Execution Exception: ' || x_msg_data);
700: END IF;
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: Rollback to accomplish_osp_mrs_pvt;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

700: END IF;
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: Rollback to accomplish_osp_mrs_pvt;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:

Line 707: p_encoded => fnd_api.g_false);

703: Rollback to accomplish_osp_mrs_pvt;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708:
709: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Unexpected Exception: ' || x_msg_data);
711: END IF;

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: END IF;
712:
713: WHEN OTHERS THEN
714: Rollback to accomplish_osp_mrs_pvt;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
717: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
718: p_procedure_name => l_api_name,
719: p_error_text => SUBSTR(SQLERRM,1,500));

Line 723: p_encoded => fnd_api.g_false);

719: p_error_text => SUBSTR(SQLERRM,1,500));
720: END IF;
721: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
722: p_data => x_msg_data,
723: p_encoded => fnd_api.g_false);
724:
725: IF (FND_LOG.LEVEL_UNEXPECTED >= l_log_current_level) THEN
726: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_FULL_NAME, 'Other Exception: ' || x_msg_data);
727: END IF;

Line 736: -- It returns FND_API.G_TRUE if same and FND_API.G_FALSE if different.

732: -- Start of Comments --
733: -- Function name : Is_Received_Inst_Same
734: -- Type : Public
735: -- Functionality : Function to determine if the received instance is same as the recorded accomplishment instance.
736: -- It returns FND_API.G_TRUE if same and FND_API.G_FALSE if different.
737: -- It returns FND_API.G_TRUE if there has been no receipt also.
738: -- Pre-reqs :
739: --
740: -- Parameters:

Line 737: -- It returns FND_API.G_TRUE if there has been no receipt also.

733: -- Function name : Is_Received_Inst_Same
734: -- Type : Public
735: -- Functionality : Function to determine if the received instance is same as the recorded accomplishment instance.
736: -- It returns FND_API.G_TRUE if same and FND_API.G_FALSE if different.
737: -- It returns FND_API.G_TRUE if there has been no receipt also.
738: -- Pre-reqs :
739: --
740: -- Parameters:
741: --

Line 827: RETURN FND_API.G_TRUE;

823: IF (l_log_statement >= l_log_current_level) THEN
824: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Returned quantity for OSP Order Line is ' || l_received_quantity);
825: END IF;
826: -- Return True if there is no receipt
827: RETURN FND_API.G_TRUE;
828: END IF;
829:
830: OPEN get_recorded_instances_csr;
831: FETCH get_recorded_instances_csr BULK COLLECT INTO l_instance_ids_tbl;

Line 842: RETURN FND_API.G_TRUE;

838: IF (l_log_statement >= l_log_current_level) THEN
839: FND_LOG.string(l_log_statement, L_FULL_NAME, 'No recorded accomplishments for the OSP Order Line.');
840: END IF;
841: -- Return True if there is no recorded accomplishments
842: RETURN FND_API.G_TRUE;
843: END IF;
844:
845: -- Get the received instance
846: OPEN get_received_instance_csr;

Line 854: RETURN FND_API.G_TRUE;

850: FND_LOG.string(l_log_statement, L_FULL_NAME, 'Received instance for OSP Order Line is ' || l_received_instance_id);
851: END IF;
852: IF (l_received_instance_id IS NULL) THEN
853: -- Return True if there is no receipt
854: RETURN FND_API.G_TRUE;
855: END IF;
856:
857: -- Get the tree of the received instance
858: OPEN get_instance_descendants_csr(l_received_instance_id);

Line 867: RETURN FND_API.G_TRUE;

863: END IF;
864:
865: IF (l_rcv_instance_ids_tbl.COUNT = 1) THEN
866: IF ((l_instance_ids_tbl.COUNT = 1) AND (l_instance_ids_tbl(l_instance_ids_tbl.FIRST)) = l_received_instance_id) THEN
867: RETURN FND_API.G_TRUE;
868: ELSE
869: RETURN FND_API.G_FALSE;
870: END IF;
871: END IF;

Line 869: RETURN FND_API.G_FALSE;

865: IF (l_rcv_instance_ids_tbl.COUNT = 1) THEN
866: IF ((l_instance_ids_tbl.COUNT = 1) AND (l_instance_ids_tbl(l_instance_ids_tbl.FIRST)) = l_received_instance_id) THEN
867: RETURN FND_API.G_TRUE;
868: ELSE
869: RETURN FND_API.G_FALSE;
870: END IF;
871: END IF;
872:
873: -- Received instance is an IB Tree

Line 890: RETURN FND_API.G_FALSE;

886: IF (l_found_flag = false) THEN
887: IF (l_log_statement >= l_log_current_level) THEN
888: FND_LOG.string(l_log_statement, L_FULL_NAME, 'The instance ' || l_curr_inst_id || ' was not received.');
889: END IF;
890: RETURN FND_API.G_FALSE;
891: END IF;
892:
893: i := l_instance_ids_tbl.NEXT(i);
894:

Line 898: RETURN FND_API.G_TRUE;

894:
895: END LOOP; -- For all recorded instances
896:
897: -- All recorded instances were matched
898: RETURN FND_API.G_TRUE;
899:
900: END Is_Received_Inst_Same;
901:
902: