DBA Data[Home] [Help]

APPS.PJM_PROJECT_LOCATOR dependencies on FND_MESSAGE

Line 513: fnd_message.set_name('PJM', 'LOC-DUPLICATE PHY LOC');

509: return(L_locator_id);
510:
511: exception
512: when subinv_mismatch then
513: fnd_message.set_name('PJM', 'LOC-DUPLICATE PHY LOC');
514: fnd_message.set_token('SUBINV', L_subinv);
515: return(-1);
516: when others then
517: raise;

Line 514: fnd_message.set_token('SUBINV', L_subinv);

510:
511: exception
512: when subinv_mismatch then
513: fnd_message.set_name('PJM', 'LOC-DUPLICATE PHY LOC');
514: fnd_message.set_token('SUBINV', L_subinv);
515: return(-1);
516: when others then
517: raise;
518: end Map_Locator;

Line 716: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');

712: */
713: if ( L_txn_plan_grp is null or L_loc_plan_grp is null ) then
714: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
715: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
716: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
717: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
718: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
719: return FALSE;
720: end if;

Line 717: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);

713: if ( L_txn_plan_grp is null or L_loc_plan_grp is null ) then
714: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
715: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
716: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
717: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
718: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
719: return FALSE;
720: end if;
721:

Line 718: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);

714: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
715: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
716: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
717: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
718: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
719: return FALSE;
720: end if;
721:
722: /*

Line 728: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');

724: */
725: if ( L_txn_plan_grp <> L_loc_plan_grp ) then
726: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
727: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
728: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
729: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
730: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
731: return FALSE;
732: end if;

Line 729: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);

725: if ( L_txn_plan_grp <> L_loc_plan_grp ) then
726: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
727: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
728: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
729: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
730: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
731: return FALSE;
732: end if;
733:

Line 730: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);

726: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
727: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
728: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
729: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
730: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
731: return FALSE;
732: end if;
733:
734: /*

Line 747: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');

743: if ( L_cost_method <> 1 ) then
744: if ( L_txn_cost_grp <> L_loc_cost_grp ) then
745: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
746: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
747: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');
748: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
749: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
750: return FALSE;
751: end if;

Line 748: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);

744: if ( L_txn_cost_grp <> L_loc_cost_grp ) then
745: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
746: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
747: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');
748: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
749: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
750: return FALSE;
751: end if;
752: end if;

Line 749: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);

745: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
746: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
747: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');
748: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
749: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
750: return FALSE;
751: end if;
752: end if;
753: */

Line 760: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');

756: else /* L_allow_xprj_issue = 'N' */
757:
758: l_txn_prj_ref := Get_Project_References(X_txn_project, X_txn_task);
759: l_loc_prj_ref := Get_Project_References(X_loc_project, X_loc_task);
760: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
761: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
762: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
763: return FALSE;
764: end if;

Line 761: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);

757:
758: l_txn_prj_ref := Get_Project_References(X_txn_project, X_txn_task);
759: l_loc_prj_ref := Get_Project_References(X_loc_project, X_loc_task);
760: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
761: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
762: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
763: return FALSE;
764: end if;
765:

Line 762: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);

758: l_txn_prj_ref := Get_Project_References(X_txn_project, X_txn_task);
759: l_loc_prj_ref := Get_Project_References(X_loc_project, X_loc_task);
760: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
761: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
762: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
763: return FALSE;
764: end if;
765:
766: END match_proj_by_plan_grp;

Line 898: FND_MESSAGE.SET_NAME('PJM', 'LOC-PROJ NOT CHARGEABLE');

894: FETCH C_Proj INTO l_dummy;
895:
896: if ( C_Proj%NOTFOUND ) then
897: CLOSE C_Proj;
898: FND_MESSAGE.SET_NAME('PJM', 'LOC-PROJ NOT CHARGEABLE');
899: FND_MESSAGE.SET_TOKEN('PROJ' , Get_Project_References( l_loc_project_id , null ));
900: return(FALSE);
901: end if;
902:

Line 899: FND_MESSAGE.SET_TOKEN('PROJ' , Get_Project_References( l_loc_project_id , null ));

895:
896: if ( C_Proj%NOTFOUND ) then
897: CLOSE C_Proj;
898: FND_MESSAGE.SET_NAME('PJM', 'LOC-PROJ NOT CHARGEABLE');
899: FND_MESSAGE.SET_TOKEN('PROJ' , Get_Project_References( l_loc_project_id , null ));
900: return(FALSE);
901: end if;
902:
903: CLOSE C_Proj;

Line 910: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');

906:
907: if ( pjm_project.val_proj_idtonum( l_loc_project_id
908: , p_organization_id ) is null ) then
909:
910: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
911: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));
912: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);
913: return(FALSE);
914:

Line 911: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));

907: if ( pjm_project.val_proj_idtonum( l_loc_project_id
908: , p_organization_id ) is null ) then
909:
910: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
911: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));
912: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);
913: return(FALSE);
914:
915: end if;

Line 912: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);

908: , p_organization_id ) is null ) then
909:
910: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
911: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));
912: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);
913: return(FALSE);
914:
915: end if;
916:

Line 928: FND_MESSAGE.SET_NAME('PJM', 'LOC-TASK NOT CHARGEABLE');

924: FETCH C_Task INTO l_dummy;
925:
926: if ( C_Task%NOTFOUND ) then
927: CLOSE C_Task;
928: FND_MESSAGE.SET_NAME('PJM', 'LOC-TASK NOT CHARGEABLE');
929: FND_MESSAGE.SET_TOKEN('TASK' , Get_Project_References( l_loc_project_id , l_loc_task_id ));
930: return(FALSE);
931: end if;
932:

Line 929: FND_MESSAGE.SET_TOKEN('TASK' , Get_Project_References( l_loc_project_id , l_loc_task_id ));

925:
926: if ( C_Task%NOTFOUND ) then
927: CLOSE C_Task;
928: FND_MESSAGE.SET_NAME('PJM', 'LOC-TASK NOT CHARGEABLE');
929: FND_MESSAGE.SET_TOKEN('TASK' , Get_Project_References( l_loc_project_id , l_loc_task_id ));
930: return(FALSE);
931: end if;
932:
933: CLOSE C_Task;

Line 950: FND_MESSAGE.SET_NAME('PJM', 'LOC-ORG NOT PRJ ENABLED');

946:
947: if (l_proj_ref_enabled <> 1) then
948: if ((l_loc_project_id is not null) or
949: (l_loc_task_id is not null)) then
950: FND_MESSAGE.SET_NAME('PJM', 'LOC-ORG NOT PRJ ENABLED');
951: return (FALSE);
952: end if;
953: else
954: /* If the project_id argument is NULL, then the locator

Line 961: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF NOT ALLOWED');

957: if ((p_project_id is null) and (p_validation_mode = 'SPECIFIC')) then
958: if (l_loc_project_id is null) then
959: return (TRUE);
960: else
961: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF NOT ALLOWED');
962: return (FALSE);
963: end if;
964: end if;
965:

Line 976: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED');

972: if (l_proj_control_level = 1) then
973:
974: if (p_required_flag = 'Y') then
975: if (l_loc_project_id is null) then
976: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED');
977: return (FALSE);
978: end if;
979: end if;
980:

Line 992: FND_MESSAGE.SET_NAME('PJM', 'LOC-INVALID PRJ REF');

988:
989: if (((l_loc_project_id is not null) and (l_loc_task_id is null)) or
990: ((l_loc_project_id is null) and (l_loc_task_id is not null))) then
991:
992: FND_MESSAGE.SET_NAME('PJM', 'LOC-INVALID PRJ REF');
993: return FALSE;
994: end if;
995:
996: if (p_required_flag = 'Y') then

Line 998: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED');

994: end if;
995:
996: if (p_required_flag = 'Y') then
997: if ((l_loc_project_id is NULL) or (l_loc_task_id is NULL)) then
998: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED');
999: return (FALSE);
1000: end if;
1001: end if;
1002: end if; /* l_proj_control_level = 2 */

Line 1029: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');

1025: (l_proj_control_level = 2))
1026: ) then
1027: l_txn_prj_ref := Get_Project_References(p_project_id, p_task_id);
1028: l_loc_prj_ref := Get_Project_References(l_loc_project_id, l_loc_task_id);
1029: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
1030: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
1031: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
1032: return (FALSE);
1033: end if;

Line 1030: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);

1026: ) then
1027: l_txn_prj_ref := Get_Project_References(p_project_id, p_task_id);
1028: l_loc_prj_ref := Get_Project_References(l_loc_project_id, l_loc_task_id);
1029: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
1030: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
1031: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
1032: return (FALSE);
1033: end if;
1034:

Line 1031: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);

1027: l_txn_prj_ref := Get_Project_References(p_project_id, p_task_id);
1028: l_loc_prj_ref := Get_Project_References(l_loc_project_id, l_loc_task_id);
1029: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
1030: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
1031: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
1032: return (FALSE);
1033: end if;
1034:
1035: elsif (p_required_flag = 'N') then

Line 1303: fnd_message.set_name('INV','INV_INT_LOCCODE');

1299: ** Check whether the locator itself is a valid locator.
1300: ** If yes proceed to other checks, if no error out.
1301: */
1302: if (not get_physical_location(p_organization_id, p_locator_id)) then
1303: fnd_message.set_name('INV','INV_INT_LOCCODE');
1304: raise_application_error(-20001, fnd_message.get);
1305: end if;
1306:
1307: OPEN C4(p_locator_id, p_organization_id);

Line 1304: raise_application_error(-20001, fnd_message.get);

1300: ** If yes proceed to other checks, if no error out.
1301: */
1302: if (not get_physical_location(p_organization_id, p_locator_id)) then
1303: fnd_message.set_name('INV','INV_INT_LOCCODE');
1304: raise_application_error(-20001, fnd_message.get);
1305: end if;
1306:
1307: OPEN C4(p_locator_id, p_organization_id);
1308: FETCH C4 INTO l_phy_loc_id;