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

Line 270: l_int_req_ret_sts := FND_API.G_RET_STS_SUCCESS;

266: BEGIN
267:
268: Savepoint Before_Requisition ;
269:
270: l_int_req_ret_sts := FND_API.G_RET_STS_SUCCESS;
271:
272: -- Get responsibility id
273: OPEN c_security(l_org_trans_rel_cur.to_operating_unit, l_user_id, l_appl_id);
274: FETCH c_security INTO l_level_id, l_level_value; -- resp_id

Line 334: RAISE FND_API.G_EXC_ERROR;

330:
331: Exception
332: When others then
333: LOG_MESSAGE('Unable to locate a good/bad subinventory in the organziation'||to_char(l_org_trans_rel_cur.src_organization_id));
334: RAISE FND_API.G_EXC_ERROR;
335: End;
336:
337: l_req_line_tbl(j).source_subinventory := lv_source_subinv;
338: l_req_line_tbl(j).destination_subinventory := lv_Dest_subinv;

Line 353: IF l_int_req_Ret_sts = FND_API.G_RET_STS_UNEXP_ERROR THEN

349: ,x_return_status => l_int_req_Ret_sts
350: ,x_msg_count => l_msg_count
351: ,x_msg_data => l_msg_data );
352: --Check return status of the Purchasing API
353: IF l_int_req_Ret_sts = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_UNEXP_ERROR');
355: oe_debug_pub.add(' PO API call returned unexpected error '||l_msg_data,2);
356: log_message('Item ID :' || l_req_line_tbl(j).item_id );
357: log_message('Quantity :' || l_req_line_tbl(j).quantity);

Line 354: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_UNEXP_ERROR');

350: ,x_msg_count => l_msg_count
351: ,x_msg_data => l_msg_data );
352: --Check return status of the Purchasing API
353: IF l_int_req_Ret_sts = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_UNEXP_ERROR');
355: oe_debug_pub.add(' PO API call returned unexpected error '||l_msg_data,2);
356: log_message('Item ID :' || l_req_line_tbl(j).item_id );
357: log_message('Quantity :' || l_req_line_tbl(j).quantity);
358: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);

Line 359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

355: oe_debug_pub.add(' PO API call returned unexpected error '||l_msg_data,2);
356: log_message('Item ID :' || l_req_line_tbl(j).item_id );
357: log_message('Quantity :' || l_req_line_tbl(j).quantity);
358: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN
361: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');
362: oe_debug_pub.add(' PO API call returned error '||l_msg_data,2);
363: log_message('Error Msg from PO API: ' || l_msg_data );

Line 360: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN

356: log_message('Item ID :' || l_req_line_tbl(j).item_id );
357: log_message('Quantity :' || l_req_line_tbl(j).quantity);
358: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN
361: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');
362: oe_debug_pub.add(' PO API call returned error '||l_msg_data,2);
363: log_message('Error Msg from PO API: ' || l_msg_data );
364: log_message('Item ID :' || l_req_line_tbl(j).item_id );

Line 361: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');

357: log_message('Quantity :' || l_req_line_tbl(j).quantity);
358: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN
361: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');
362: oe_debug_pub.add(' PO API call returned error '||l_msg_data,2);
363: log_message('Error Msg from PO API: ' || l_msg_data );
364: log_message('Item ID :' || l_req_line_tbl(j).item_id );
365: log_message('Quantity :' || l_req_line_tbl(j).quantity);

Line 367: RAISE FND_API.G_EXC_ERROR;

363: log_message('Error Msg from PO API: ' || l_msg_data );
364: log_message('Item ID :' || l_req_line_tbl(j).item_id );
365: log_message('Quantity :' || l_req_line_tbl(j).quantity);
366: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
367: RAISE FND_API.G_EXC_ERROR;
368: ELSIF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
369: p_Ireq_header_id:= l_req_header_rec.requisition_header_id;
370: log_message('Successful in Creating requisition.');
371: log_message('Requisition Header ID :' ||l_req_header_rec.requisition_header_id);

Line 368: ELSIF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

364: log_message('Item ID :' || l_req_line_tbl(j).item_id );
365: log_message('Quantity :' || l_req_line_tbl(j).quantity);
366: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
367: RAISE FND_API.G_EXC_ERROR;
368: ELSIF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
369: p_Ireq_header_id:= l_req_header_rec.requisition_header_id;
370: log_message('Successful in Creating requisition.');
371: log_message('Requisition Header ID :' ||l_req_header_rec.requisition_header_id);
372: log_message('Internal Requisition Number : ' || l_req_header_rec.segment1);

Line 384: IF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

380: END IF; /* End of Creating new requisitions*/
381:
382: /* if it returns success Update the Internal Sales Order
383: with the Req header id and Req line Ids */
384: IF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
385:
386: /* For Security */
387: IF l_prev_src_org_id <> l_org_trans_rel_cur.src_operating_unit THEN
388: l_prev_src_org_id := l_org_trans_rel_cur.src_operating_unit;

Line 545: if (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

541: end loop;
542: end if;
543:
544:
545: if (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
546: p_ISO_header_id:= l_header_rec.header_id ;
547: log_message('Successful in loading Sales order.');
548: log_message('Header ID : ' ||l_header_rec.header_id);
549: log_message('Internal Sales Order Number : ' ||

Line 635: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

631: OE_SCHEDULE_GRP.Update_Scheduling_Results(p_x_sch_tbl => l_sch_rec_tbl,
632: p_request_id => l_request_id,
633: x_return_status => l_return_status);
634:
635: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
636: log_message('Successful in update_scheduling_results.');
637: log_message('Header ID : ' || l_sch_rec_tbl(1).header_id );
638: log_message('Line ID : ' || l_sch_rec_tbl(1).line_id );
639: log_message('Org ID : ' || l_sch_rec_tbl(1).org_id );

Line 677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

673: log_message('Org ID : ' || l_sch_rec_tbl(1).org_id );
674: log_message('Schedule Ship Date : ' || to_char(l_sch_rec_tbl(1).Schedule_ship_date,'DD-MON-YYYY HH24:MI:SS'));
675: log_message('Schedule Arrival Date : '|| to_char(l_sch_rec_tbl(1).Schedule_arrival_date, 'DD-MON-YYYY HH24:MI:SS'));
676:
677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
678: log_message('FND_API.G_RET_STS_ERROR ');
679: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
680: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
681: END IF;

Line 678: log_message('FND_API.G_RET_STS_ERROR ');

674: log_message('Schedule Ship Date : ' || to_char(l_sch_rec_tbl(1).Schedule_ship_date,'DD-MON-YYYY HH24:MI:SS'));
675: log_message('Schedule Arrival Date : '|| to_char(l_sch_rec_tbl(1).Schedule_arrival_date, 'DD-MON-YYYY HH24:MI:SS'));
676:
677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
678: log_message('FND_API.G_RET_STS_ERROR ');
679: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
680: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
681: END IF;
682: RAISE e_update_rescheduling_err;

Line 679: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

675: log_message('Schedule Arrival Date : '|| to_char(l_sch_rec_tbl(1).Schedule_arrival_date, 'DD-MON-YYYY HH24:MI:SS'));
676:
677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
678: log_message('FND_API.G_RET_STS_ERROR ');
679: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
680: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
681: END IF;
682: RAISE e_update_rescheduling_err;
683: END IF;

Line 680: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');

676:
677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
678: log_message('FND_API.G_RET_STS_ERROR ');
679: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
680: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
681: END IF;
682: RAISE e_update_rescheduling_err;
683: END IF;
684:

Line 686: END IF; /* End of l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS */

682: RAISE e_update_rescheduling_err;
683: END IF;
684:
685:
686: END IF; /* End of l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS */
687:
688:
689:
690: /* Set the req line and req table to null so that

Line 705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

701:
702:
703:
704: EXCEPTION
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
706: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_UNEXPECTED_ERROR');
707: LOG_MESSAGE(SQLERRM);
708: retcode := 1;
709: b_has_error := TRUE;

Line 706: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_UNEXPECTED_ERROR');

702:
703:
704: EXCEPTION
705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
706: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_UNEXPECTED_ERROR');
707: LOG_MESSAGE(SQLERRM);
708: retcode := 1;
709: b_has_error := TRUE;
710: v_failure := v_failure + 1;

Line 716: WHEN FND_API.G_EXC_ERROR THEN

712: rollback to Savepoint Before_Requisition ;
713: log_message('Transaction rolled back');
714: log_message('----------------------------------------------------------');
715:
716: WHEN FND_API.G_EXC_ERROR THEN
717: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_ERROR');
718: LOG_MESSAGE(SQLERRM);
719: retcode := 1;
720: b_has_error := TRUE;

Line 717: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_ERROR');

713: log_message('Transaction rolled back');
714: log_message('----------------------------------------------------------');
715:
716: WHEN FND_API.G_EXC_ERROR THEN
717: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_ERROR');
718: LOG_MESSAGE(SQLERRM);
719: retcode := 1;
720: b_has_error := TRUE;
721: v_failure := v_failure + 1;