DBA Data[Home] [Help]

APPS.PJM_BORROW_PAYBACK dependencies on FND_MESSAGE

Line 240: fnd_message.set_name('PJM', X_Error_Code);

236: AND outstanding_quantity > 0;
237:
238: if ( L_outstanding_qty < L_trx_quantity ) then
239: X_error_code := 'BWPY-Payback Quantity Exceeded';
240: fnd_message.set_name('PJM', X_Error_Code);
241: return ( FALSE );
242: end if;
243:
244: OPEN c ( L_proj_id

Line 310: fnd_message.set_name('PJM', X_Error_Code);

306: END LOOP;
307:
308: if L_trx_quantity > 0 then
309: X_error_code := 'BWPY-Payback Quantity Exceeded';
310: fnd_message.set_name('PJM', X_Error_Code);
311: return ( FALSE );
312: end if;
313:
314: end if;

Line 427: fnd_message.set_name('PJM', X_Error_Code);

423: and inventory_item_id = X_Inventory_Item_Id;
424:
425: if (l_asset_item_flag = 'N') then
426: X_Error_Code := 'BWPY-Non Asset Item Transfer';
427: fnd_message.set_name('PJM', X_Error_Code);
428: return(l_failure);
429: end if;
430:
431:

Line 446: fnd_message.set_name('PJM', X_Error_Code);

442: and asset_inventory = 2;
443:
444: if SQL%FOUND then
445: X_Error_Code := 'BWPY-Non Asset Inventory Trans';
446: fnd_message.set_name('PJM', X_Error_Code);
447: return(l_failure);
448: end if;
449:
450: exception

Line 455: fnd_message.set_name('PJM', X_Error_Code);

451: when NO_DATA_FOUND then
452: null;
453: when TOO_MANY_ROWS then
454: X_Error_Code := 'BWPY-Non Asset Inventory Trans';
455: fnd_message.set_name('PJM', X_Error_Code);
456: return(l_failure);
457: end;
458:
459: end if;

Line 523: fnd_message.set_name('PJM', X_Error_Code);

519: if (X_Transaction_Type_Id not in (66, 68, 67)) then
520: if( ( nvl(l_from_project_id,0) <> nvl(l_to_project_id,0) ) OR
521: ( nvl(l_from_task_id,0) <> nvl(l_to_task_id,0) ) ) then
522: X_Error_Code := 'BWPY-Project Transfer';
523: fnd_message.set_name('PJM', X_Error_Code);
524: return(l_failure);
525: else
526: return(l_success);
527: end if;

Line 536: fnd_message.set_name('PJM', X_Error_Code);

532: -----------------------------------------------------------
533: if ( l_from_project_id is null
534: and l_to_project_id is null ) then
535: X_Error_Code := 'BWPY-Common Transfer';
536: fnd_message.set_name('PJM', X_Error_Code);
537: return(l_failure);
538: end if;
539:
540: -----------------------------------------------------------

Line 552: fnd_message.set_name('PJM', X_Error_Code);

548: if (X_Transaction_Type_Id in (66, 68)) then
549: if (l_project_control_lev = 1) then
550: if (nvl(l_from_project_id,0) = nvl(l_to_project_id,0)) then
551: X_Error_Code := 'BWPY-Same Project';
552: fnd_message.set_name('PJM', X_Error_Code);
553: return(l_failure);
554: end if;
555: elsif (l_project_control_lev = 2) then
556: if (nvl(l_from_task_id,0) = nvl(l_to_task_id,0)) then

Line 558: fnd_message.set_name('PJM', X_Error_Code);

554: end if;
555: elsif (l_project_control_lev = 2) then
556: if (nvl(l_from_task_id,0) = nvl(l_to_task_id,0)) then
557: X_Error_Code := 'BWPY-Same Task';
558: fnd_message.set_name('PJM', X_Error_Code);
559: return(l_failure);
560: end if;
561: end if;
562: end if;

Line 579: fnd_message.set_name('PJM', X_Error_Code);

575: --------------------------------------------------------------
576:
577: if (l_from_project_id is null or l_to_project_id is null) then
578: X_Error_Code := 'BWPY-Borrow Against Common';
579: fnd_message.set_name('PJM', X_Error_Code);
580: return (l_failure);
581: end if;
582:
583: BEGIN

Line 604: fnd_message.set_name('PJM', X_Error_Code);

600: --------------------------------------------------------------------
601:
602: if (l_outstanding_qty > 0) then
603: X_Error_Code := 'BWPY-Loan Loop Detected';
604: fnd_message.set_name('PJM', X_Error_Code);
605: return( l_failure);
606: end if;
607:
608: EXCEPTION

Line 633: fnd_message.set_name('PJM', X_Error_Code);

629: ------------------------------------------------------------------
630:
631: if (l_onhand_qty < X_Primary_Quantity) then
632: X_Error_Code := 'BWPY-Insufficient Onhand';
633: fnd_message.set_name('PJM', X_Error_Code);
634: return (l_failure);
635: end if;
636:
637: EXCEPTION

Line 640: fnd_message.set_name('PJM', X_Error_Code);

636:
637: EXCEPTION
638: when NO_DATA_FOUND then
639: X_Error_Code := 'BWPY-Insufficient Onhand';
640: fnd_message.set_name('PJM', X_Error_Code);
641: return (l_failure);
642: END;
643:
644: --------------------------------------------------------------

Line 650: fnd_message.set_name('PJM', X_Error_Code);

646: --------------------------------------------------------------
647:
648: if ( X_payback_date is null ) then
649: X_Error_Code := 'BWPY-Payback Date Required';
650: fnd_message.set_name('PJM', X_Error_Code);
651: return (l_failure);
652: end if;
653:
654: if ( X_payback_date < sysdate OR

Line 657: fnd_message.set_name('PJM', X_Error_Code);

653:
654: if ( X_payback_date < sysdate OR
655: X_payback_date < X_transaction_date ) then
656: X_Error_Code := 'BWPY-Payback Date Invalid';
657: fnd_message.set_name('PJM', X_Error_Code);
658: return (l_failure);
659: end if;
660:
661: --------------------------------------------------

Line 672: fnd_message.set_name('PJM', X_Error_Code);

668: --------------------------------------------------------------------
669:
670: if (l_from_project_id is null or l_to_project_id is null) then
671: X_Error_Code := 'BWPY-Payback to Common';
672: fnd_message.set_name('PJM', X_Error_Code);
673: return (l_failure);
674: end if;
675:
676: BEGIN

Line 696: fnd_message.set_name('PJM', X_Error_Code);

692: --------------------------------------------------------------------
693:
694: if (l_outstanding_qty = 0) then
695: X_Error_Code := 'BWPY-No Loan Balance';
696: fnd_message.set_name('PJM', X_Error_Code);
697: return(l_failure);
698: end if;
699:
700: ---------------------------------------------------------------------

Line 707: fnd_message.set_name('PJM', X_Error_Code);

703: ---------------------------------------------------------------------
704:
705: if (l_outstanding_qty < X_Primary_Quantity) then
706: X_Error_Code := 'BWPY-Payback Quantity Exceeded';
707: fnd_message.set_name('PJM', X_Error_Code);
708: return(l_failure);
709: end if;
710:
711: EXCEPTION

Line 714: fnd_message.set_name('PJM', X_Error_Code);

710:
711: EXCEPTION
712: when NO_DATA_FOUND then
713: X_Error_Code := 'BWPY-Payback Quantity Exceeded';
714: fnd_message.set_name('PJM', X_Error_Code);
715: return(l_failure);
716: END;
717:
718: end if;

Line 728: fnd_message.set_name('PJM', X_Error_Code);

724: if ((X_From_Subinventory <> X_To_Subinventory) OR
725: (l_From_physical_loc <> l_To_physical_loc)) then
726:
727: X_Error_Code := 'BWPY-Physical Transfer';
728: fnd_message.set_name('PJM', X_Error_Code);
729: return(l_warning);
730: end if;
731:
732: return(l_success);