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.OKE_DELIVERABLE_ACTIONS_PKG dependencies on OKE_API

Line 352: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

348: , X_Return_Status OUT NOCOPY VARCHAR2
349: , X_Msg_Count OUT NOCOPY NUMBER
350: , X_Msg_Data OUT NOCOPY VARCHAR2 ) IS
351:
352: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
353: L_API_Version CONSTANT NUMBER := 1;
354: L_API_Name CONSTANT VARCHAR2(30) := 'CREATE_DEMAND';
355: L_Quantity NUMBER;
356: L_ID NUMBER;

Line 371: L_Return_Status := OKE_API.Start_Activity (

367: WHERE mps_transaction_id = l_id;
368:
369: BEGIN
370:
371: L_Return_Status := OKE_API.Start_Activity (
372: L_API_Name
373: , P_Init_Msg_List
374: , '_PKG'
375: , X_Return_Status );

Line 376: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

372: L_API_Name
373: , P_Init_Msg_List
374: , '_PKG'
375: , X_Return_Status );
376: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
377: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
379: RAISE OKE_API.G_EXCEPTION_ERROR;
380: END IF;

Line 377: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

373: , P_Init_Msg_List
374: , '_PKG'
375: , X_Return_Status );
376: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
377: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
379: RAISE OKE_API.G_EXCEPTION_ERROR;
380: END IF;
381:

Line 378: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

374: , '_PKG'
375: , X_Return_Status );
376: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
377: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
379: RAISE OKE_API.G_EXCEPTION_ERROR;
380: END IF;
381:
382: OPEN c1;

Line 379: RAISE OKE_API.G_EXCEPTION_ERROR;

375: , X_Return_Status );
376: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
377: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
378: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
379: RAISE OKE_API.G_EXCEPTION_ERROR;
380: END IF;
381:
382: OPEN c1;
383: FETCH c1 INTO L_ID;

Line 412: OKE_API.End_Activity ( X_Msg_Count, X_Msg_Data );

408: END IF;
409:
410: X_Return_Status := L_Return_Status;
411: -- Commit;
412: OKE_API.End_Activity ( X_Msg_Count, X_Msg_Data );
413:
414: EXCEPTION
415: WHEN OKE_API.G_EXCEPTION_ERROR THEN
416:

Line 415: WHEN OKE_API.G_EXCEPTION_ERROR THEN

411: -- Commit;
412: OKE_API.End_Activity ( X_Msg_Count, X_Msg_Data );
413:
414: EXCEPTION
415: WHEN OKE_API.G_EXCEPTION_ERROR THEN
416:
417: x_return_status := OKE_API.HANDLE_EXCEPTIONS
418: (
419: l_api_name,

Line 417: x_return_status := OKE_API.HANDLE_EXCEPTIONS

413:
414: EXCEPTION
415: WHEN OKE_API.G_EXCEPTION_ERROR THEN
416:
417: x_return_status := OKE_API.HANDLE_EXCEPTIONS
418: (
419: l_api_name,
420: G_PKG_NAME,
421: 'OKE_API.G_RET_STS_ERROR',

Line 421: 'OKE_API.G_RET_STS_ERROR',

417: x_return_status := OKE_API.HANDLE_EXCEPTIONS
418: (
419: l_api_name,
420: G_PKG_NAME,
421: 'OKE_API.G_RET_STS_ERROR',
422: x_msg_count,
423: x_msg_data,
424: '_PKG');
425: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 425: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

421: 'OKE_API.G_RET_STS_ERROR',
422: x_msg_count,
423: x_msg_data,
424: '_PKG');
425: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
426: x_return_status := OKE_API.HANDLE_EXCEPTIONS
427: (
428: l_api_name,
429: G_PKG_NAME,

Line 426: x_return_status := OKE_API.HANDLE_EXCEPTIONS

422: x_msg_count,
423: x_msg_data,
424: '_PKG');
425: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
426: x_return_status := OKE_API.HANDLE_EXCEPTIONS
427: (
428: l_api_name,
429: G_PKG_NAME,
430: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 430: 'OKE_API.G_RET_STS_UNEXP_ERROR',

426: x_return_status := OKE_API.HANDLE_EXCEPTIONS
427: (
428: l_api_name,
429: G_PKG_NAME,
430: 'OKE_API.G_RET_STS_UNEXP_ERROR',
431: x_msg_count,
432: x_msg_data,
433: '_PKG');
434:

Line 436: x_return_status := OKE_API.HANDLE_EXCEPTIONS

432: x_msg_data,
433: '_PKG');
434:
435: WHEN OTHERS THEN
436: x_return_status := OKE_API.HANDLE_EXCEPTIONS
437: (
438: l_api_name,
439: G_PKG_NAME,
440: 'OTHERS',

Line 454: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

450: , X_ID OUT NOCOPY NUMBER
451: , X_Return_Status OUT NOCOPY VARCHAR2
452: , X_Msg_Count OUT NOCOPY NUMBER
453: , X_Msg_Data OUT NOCOPY VARCHAR2 ) IS
454: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
455: L_API_Version CONSTANT NUMBER := 1;
456: L_API_Name CONSTANT VARCHAR2(30) := 'CREATE_SHIPMENT';
457: L_Quantity NUMBER;
458: L_ID NUMBER;

Line 522: L_Return_Status := OKE_API.Start_Activity (

518: and inventory_item_id = p_item_id;
519:
520: BEGIN
521:
522: L_Return_Status := OKE_API.Start_Activity (
523: L_API_Name
524: , P_Init_Msg_List
525: , '_PKG'
526: , X_Return_Status );

Line 527: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

523: L_API_Name
524: , P_Init_Msg_List
525: , '_PKG'
526: , X_Return_Status );
527: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
530: RAISE OKE_API.G_EXCEPTION_ERROR;
531: END IF;

Line 528: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

524: , P_Init_Msg_List
525: , '_PKG'
526: , X_Return_Status );
527: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
530: RAISE OKE_API.G_EXCEPTION_ERROR;
531: END IF;
532:

Line 529: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

525: , '_PKG'
526: , X_Return_Status );
527: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
530: RAISE OKE_API.G_EXCEPTION_ERROR;
531: END IF;
532:
533: OPEN c1;

Line 530: RAISE OKE_API.G_EXCEPTION_ERROR;

526: , X_Return_Status );
527: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
528: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
529: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
530: RAISE OKE_API.G_EXCEPTION_ERROR;
531: END IF;
532:
533: OPEN c1;
534: FETCH c1 INTO c1info;

Line 617: IF L_Return_Status = OKE_API.G_Ret_Sts_Success THEN

613: , L_ID
614: , L_Return_Status );
615:
616:
617: IF L_Return_Status = OKE_API.G_Ret_Sts_Success THEN
618: UPDATE oke_deliverable_actions
619: SET reference1 = l_id
620: , in_process_flag = 'Y'
621: , initiate_date = sysdate

Line 627: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

623:
624: X_Return_Status := L_Return_Status;
625: -- Commit;
626: ELSE
627: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
630: RAISE OKE_API.G_EXCEPTION_ERROR;
631: END IF;

Line 628: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

624: X_Return_Status := L_Return_Status;
625: -- Commit;
626: ELSE
627: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
630: RAISE OKE_API.G_EXCEPTION_ERROR;
631: END IF;
632: END IF;

Line 629: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

625: -- Commit;
626: ELSE
627: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
630: RAISE OKE_API.G_EXCEPTION_ERROR;
631: END IF;
632: END IF;
633:

Line 630: RAISE OKE_API.G_EXCEPTION_ERROR;

626: ELSE
627: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
628: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
629: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
630: RAISE OKE_API.G_EXCEPTION_ERROR;
631: END IF;
632: END IF;
633:
634: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 634: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

630: RAISE OKE_API.G_EXCEPTION_ERROR;
631: END IF;
632: END IF;
633:
634: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
635:
636: EXCEPTION
637: WHEN OKE_API.G_EXCEPTION_ERROR THEN
638:

Line 637: WHEN OKE_API.G_EXCEPTION_ERROR THEN

633:
634: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
635:
636: EXCEPTION
637: WHEN OKE_API.G_EXCEPTION_ERROR THEN
638:
639: x_return_status := OKE_API.HANDLE_EXCEPTIONS
640: (
641: l_api_name,

Line 639: x_return_status := OKE_API.HANDLE_EXCEPTIONS

635:
636: EXCEPTION
637: WHEN OKE_API.G_EXCEPTION_ERROR THEN
638:
639: x_return_status := OKE_API.HANDLE_EXCEPTIONS
640: (
641: l_api_name,
642: G_PKG_NAME,
643: 'OKE_API.G_RET_STS_ERROR',

Line 643: 'OKE_API.G_RET_STS_ERROR',

639: x_return_status := OKE_API.HANDLE_EXCEPTIONS
640: (
641: l_api_name,
642: G_PKG_NAME,
643: 'OKE_API.G_RET_STS_ERROR',
644: x_msg_count,
645: x_msg_data,
646: '_PKG');
647: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 647: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

643: 'OKE_API.G_RET_STS_ERROR',
644: x_msg_count,
645: x_msg_data,
646: '_PKG');
647: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
648: x_return_status := OKE_API.HANDLE_EXCEPTIONS
649: (
650: l_api_name,
651: G_PKG_NAME,

Line 648: x_return_status := OKE_API.HANDLE_EXCEPTIONS

644: x_msg_count,
645: x_msg_data,
646: '_PKG');
647: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
648: x_return_status := OKE_API.HANDLE_EXCEPTIONS
649: (
650: l_api_name,
651: G_PKG_NAME,
652: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 652: 'OKE_API.G_RET_STS_UNEXP_ERROR',

648: x_return_status := OKE_API.HANDLE_EXCEPTIONS
649: (
650: l_api_name,
651: G_PKG_NAME,
652: 'OKE_API.G_RET_STS_UNEXP_ERROR',
653: x_msg_count,
654: x_msg_data,
655: '_PKG');
656:

Line 658: x_return_status := OKE_API.HANDLE_EXCEPTIONS

654: x_msg_data,
655: '_PKG');
656:
657: WHEN OTHERS THEN
658: x_return_status := OKE_API.HANDLE_EXCEPTIONS
659: (
660: l_api_name,
661: G_PKG_NAME,
662: 'OTHERS',

Line 676: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;

672: , X_Return_Status OUT NOCOPY VARCHAR2
673: , X_Msg_Count OUT NOCOPY NUMBER
674: , X_Msg_Data OUT NOCOPY VARCHAR2 ) IS
675:
676: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
677: L_API_Version CONSTANT NUMBER := 1;
678: L_API_Name CONSTANT VARCHAR2(30) := 'CREATE_REQUISITION';
679: L_Quantity NUMBER;
680: L_ID NUMBER;

Line 731: L_Return_Status := OKE_API.Start_Activity (

727: c2info c2%rowtype;
728:
729:
730: BEGIN
731: L_Return_Status := OKE_API.Start_Activity (
732: L_API_Name
733: , P_Init_Msg_List
734: , '_PKG'
735: , X_Return_Status );

Line 736: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN

732: L_API_Name
733: , P_Init_Msg_List
734: , '_PKG'
735: , X_Return_Status );
736: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
737: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
739: RAISE OKE_API.G_EXCEPTION_ERROR;
740: END IF;

Line 737: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

733: , P_Init_Msg_List
734: , '_PKG'
735: , X_Return_Status );
736: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
737: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
739: RAISE OKE_API.G_EXCEPTION_ERROR;
740: END IF;
741:

Line 738: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN

734: , '_PKG'
735: , X_Return_Status );
736: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
737: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
739: RAISE OKE_API.G_EXCEPTION_ERROR;
740: END IF;
741:
742: OPEN c2;

Line 739: RAISE OKE_API.G_EXCEPTION_ERROR;

735: , X_Return_Status );
736: IF (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
737: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
738: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
739: RAISE OKE_API.G_EXCEPTION_ERROR;
740: END IF;
741:
742: OPEN c2;
743: FETCH c2 INTO c2info;

Line 866: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);

862: -- COMMIT;
863:
864: X_ID := P_Action_ID;
865: X_Return_Status := L_Return_Status;
866: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
867:
868: EXCEPTION
869: WHEN OKE_API.G_EXCEPTION_ERROR THEN
870:

Line 869: WHEN OKE_API.G_EXCEPTION_ERROR THEN

865: X_Return_Status := L_Return_Status;
866: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
867:
868: EXCEPTION
869: WHEN OKE_API.G_EXCEPTION_ERROR THEN
870:
871: x_return_status := OKE_API.HANDLE_EXCEPTIONS
872: (
873: l_api_name,

Line 871: x_return_status := OKE_API.HANDLE_EXCEPTIONS

867:
868: EXCEPTION
869: WHEN OKE_API.G_EXCEPTION_ERROR THEN
870:
871: x_return_status := OKE_API.HANDLE_EXCEPTIONS
872: (
873: l_api_name,
874: G_PKG_NAME,
875: 'OKE_API.G_RET_STS_ERROR',

Line 875: 'OKE_API.G_RET_STS_ERROR',

871: x_return_status := OKE_API.HANDLE_EXCEPTIONS
872: (
873: l_api_name,
874: G_PKG_NAME,
875: 'OKE_API.G_RET_STS_ERROR',
876: x_msg_count,
877: x_msg_data,
878: '_PKG');
879: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 879: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

875: 'OKE_API.G_RET_STS_ERROR',
876: x_msg_count,
877: x_msg_data,
878: '_PKG');
879: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
880: x_return_status := OKE_API.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,

Line 880: x_return_status := OKE_API.HANDLE_EXCEPTIONS

876: x_msg_count,
877: x_msg_data,
878: '_PKG');
879: WHEN OKE_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
880: x_return_status := OKE_API.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,
884: 'OKE_API.G_RET_STS_UNEXP_ERROR',

Line 884: 'OKE_API.G_RET_STS_UNEXP_ERROR',

880: x_return_status := OKE_API.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,
884: 'OKE_API.G_RET_STS_UNEXP_ERROR',
885: x_msg_count,
886: x_msg_data,
887: '_PKG');
888:

Line 890: x_return_status := OKE_API.HANDLE_EXCEPTIONS

886: x_msg_data,
887: '_PKG');
888:
889: WHEN OTHERS THEN
890: x_return_status := OKE_API.HANDLE_EXCEPTIONS
891: (
892: l_api_name,
893: G_PKG_NAME,
894: 'OTHERS',