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.

[Home] [Help]

APPS.MRP_CREATE_SCHEDULE_ISO dependencies on FND_API

Line 278: l_int_req_ret_sts := FND_API.G_RET_STS_SUCCESS;

274: BEGIN
275:
276: Savepoint Before_Requisition ;
277:
278: l_int_req_ret_sts := FND_API.G_RET_STS_SUCCESS;
279:
280: -- Get responsibility id
281: OPEN c_security(l_org_trans_rel_cur.to_operating_unit, l_user_id, l_appl_id);
282: FETCH c_security INTO l_level_id, l_level_value; -- resp_id

Line 345: RAISE FND_API.G_EXC_ERROR;

341:
342: Exception
343: When others then
344: LOG_MESSAGE('Unable to locate a good/bad subinventory in the organziation'||to_char(l_org_trans_rel_cur.src_organization_id));
345: RAISE FND_API.G_EXC_ERROR;
346: End;
347:
348: l_req_line_tbl(j).source_subinventory := lv_source_subinv;
349: l_req_line_tbl(j).destination_subinventory := lv_Dest_subinv;

Line 365: IF l_int_req_Ret_sts = FND_API.G_RET_STS_UNEXP_ERROR THEN

361: ,x_return_status => l_int_req_Ret_sts
362: ,x_msg_count => l_msg_count
363: ,x_msg_data => l_msg_data );
364: --Check return status of the Purchasing API
365: IF l_int_req_Ret_sts = FND_API.G_RET_STS_UNEXP_ERROR THEN
366: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_UNEXP_ERROR');
367: oe_debug_pub.add(' PO API call returned unexpected error '||l_msg_data,2);
368: log_message('Item ID :' || l_req_line_tbl(j).item_id );
369: log_message('Quantity :' || l_req_line_tbl(j).quantity);

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

362: ,x_msg_count => l_msg_count
363: ,x_msg_data => l_msg_data );
364: --Check return status of the Purchasing API
365: IF l_int_req_Ret_sts = FND_API.G_RET_STS_UNEXP_ERROR THEN
366: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_UNEXP_ERROR');
367: oe_debug_pub.add(' PO API call returned unexpected error '||l_msg_data,2);
368: log_message('Item ID :' || l_req_line_tbl(j).item_id );
369: log_message('Quantity :' || l_req_line_tbl(j).quantity);
370: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);

Line 371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

367: oe_debug_pub.add(' PO API call returned unexpected error '||l_msg_data,2);
368: log_message('Item ID :' || l_req_line_tbl(j).item_id );
369: log_message('Quantity :' || l_req_line_tbl(j).quantity);
370: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN
373: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');
374: oe_debug_pub.add(' PO API call returned error '||l_msg_data,2);
375: log_message('Error Msg from PO API: ' || l_msg_data );

Line 372: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN

368: log_message('Item ID :' || l_req_line_tbl(j).item_id );
369: log_message('Quantity :' || l_req_line_tbl(j).quantity);
370: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN
373: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');
374: oe_debug_pub.add(' PO API call returned error '||l_msg_data,2);
375: log_message('Error Msg from PO API: ' || l_msg_data );
376: log_message('Item ID :' || l_req_line_tbl(j).item_id );

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

369: log_message('Quantity :' || l_req_line_tbl(j).quantity);
370: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
372: ELSIF l_int_req_Ret_sts = FND_API.G_RET_STS_ERROR THEN
373: LOG_MESSAGE('Error in process_requisition : FND_API.G_RET_STS_ERROR');
374: oe_debug_pub.add(' PO API call returned error '||l_msg_data,2);
375: log_message('Error Msg from PO API: ' || l_msg_data );
376: log_message('Item ID :' || l_req_line_tbl(j).item_id );
377: log_message('Quantity :' || l_req_line_tbl(j).quantity);

Line 379: RAISE FND_API.G_EXC_ERROR;

375: log_message('Error Msg from PO API: ' || l_msg_data );
376: log_message('Item ID :' || l_req_line_tbl(j).item_id );
377: log_message('Quantity :' || l_req_line_tbl(j).quantity);
378: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
379: RAISE FND_API.G_EXC_ERROR;
380: ELSIF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
381: p_Ireq_header_id:= l_req_header_rec.requisition_header_id;
382: log_message('Successful in Creating requisition.');
383: log_message('Requisition Header ID :' ||l_req_header_rec.requisition_header_id);

Line 380: ELSIF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

376: log_message('Item ID :' || l_req_line_tbl(j).item_id );
377: log_message('Quantity :' || l_req_line_tbl(j).quantity);
378: log_message('Deliver To loc ID :' || l_req_line_tbl(j).deliver_to_location_id);
379: RAISE FND_API.G_EXC_ERROR;
380: ELSIF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
381: p_Ireq_header_id:= l_req_header_rec.requisition_header_id;
382: log_message('Successful in Creating requisition.');
383: log_message('Requisition Header ID :' ||l_req_header_rec.requisition_header_id);
384: log_message('Internal Requisition Number : ' || l_req_header_rec.segment1);

Line 396: IF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN

392: END IF; /* End of Creating new requisitions*/
393:
394: /* if it returns success Update the Internal Sales Order
395: with the Req header id and Req line Ids */
396: IF l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS THEN
397:
398: /* For Security */
399: IF l_prev_src_org_id <> l_org_trans_rel_cur.src_operating_unit THEN
400: l_prev_src_org_id := l_org_trans_rel_cur.src_operating_unit;

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

561: end loop;
562: end if;
563:
564:
565: if (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
566: p_ISO_header_id:= l_header_rec.header_id ;
567: log_message('Successful in loading Sales order.');
568: log_message('Header ID : ' ||l_header_rec.header_id);
569: log_message('Internal Sales Order Number : ' ||

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

651: OE_SCHEDULE_GRP.Update_Scheduling_Results(p_x_sch_tbl => l_sch_rec_tbl,
652: p_request_id => l_request_id,
653: x_return_status => l_return_status);
654:
655: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
656: log_message('Successful in update_scheduling_results.');
657: log_message('Header ID : ' || l_sch_rec_tbl(1).header_id );
658: log_message('Line ID : ' || l_sch_rec_tbl(1).line_id );
659: log_message('Org ID : ' || l_sch_rec_tbl(1).org_id );

Line 697: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

693: log_message('Org ID : ' || l_sch_rec_tbl(1).org_id );
694: log_message('Schedule Ship Date : ' || to_char(l_sch_rec_tbl(1).Schedule_ship_date,'DD-MON-YYYY HH24:MI:SS'));
695: log_message('Schedule Arrival Date : '|| to_char(l_sch_rec_tbl(1).Schedule_arrival_date, 'DD-MON-YYYY HH24:MI:SS'));
696:
697: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
698: log_message('FND_API.G_RET_STS_ERROR ');
699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
701: END IF;

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

694: log_message('Schedule Ship Date : ' || to_char(l_sch_rec_tbl(1).Schedule_ship_date,'DD-MON-YYYY HH24:MI:SS'));
695: log_message('Schedule Arrival Date : '|| to_char(l_sch_rec_tbl(1).Schedule_arrival_date, 'DD-MON-YYYY HH24:MI:SS'));
696:
697: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
698: log_message('FND_API.G_RET_STS_ERROR ');
699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
701: END IF;
702: RAISE e_update_rescheduling_err;

Line 699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

695: log_message('Schedule Arrival Date : '|| to_char(l_sch_rec_tbl(1).Schedule_arrival_date, 'DD-MON-YYYY HH24:MI:SS'));
696:
697: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
698: log_message('FND_API.G_RET_STS_ERROR ');
699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
701: END IF;
702: RAISE e_update_rescheduling_err;
703: END IF;

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

696:
697: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
698: log_message('FND_API.G_RET_STS_ERROR ');
699: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
700: log_message('FND_API.G_RET_STS_UNEXP_ERROR ');
701: END IF;
702: RAISE e_update_rescheduling_err;
703: END IF;
704:

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

702: RAISE e_update_rescheduling_err;
703: END IF;
704:
705:
706: END IF; /* End of l_int_req_ret_sts = FND_API.G_RET_STS_SUCCESS */
707:
708:
709:
710: /* Set the req line and req table to null so that

Line 725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

721:
722:
723:
724: EXCEPTION
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_UNEXPECTED_ERROR');
727: LOG_MESSAGE(SQLERRM);
728: retcode := 1;
729: b_has_error := TRUE;

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

722:
723:
724: EXCEPTION
725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
726: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_UNEXPECTED_ERROR');
727: LOG_MESSAGE(SQLERRM);
728: retcode := 1;
729: b_has_error := TRUE;
730: v_failure := v_failure + 1;

Line 736: WHEN FND_API.G_EXC_ERROR THEN

732: rollback to Savepoint Before_Requisition ;
733: log_message('Transaction rolled back');
734: log_message('----------------------------------------------------------');
735:
736: WHEN FND_API.G_EXC_ERROR THEN
737: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_ERROR');
738: LOG_MESSAGE(SQLERRM);
739: retcode := 1;
740: b_has_error := TRUE;

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

733: log_message('Transaction rolled back');
734: log_message('----------------------------------------------------------');
735:
736: WHEN FND_API.G_EXC_ERROR THEN
737: LOG_MESSAGE('Error in CREATE_AND_SCHEDULE_ISO : FND_API.G_EXC_ERROR');
738: LOG_MESSAGE(SQLERRM);
739: retcode := 1;
740: b_has_error := TRUE;
741: v_failure := v_failure + 1;