DBA Data[Home] [Help]

APPS.PJM_PROJECT_LOCATOR dependencies on FND_MESSAGE

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

524: return(L_locator_id);
525:
526: exception
527: when subinv_mismatch then
528: fnd_message.set_name('PJM', 'LOC-DUPLICATE PHY LOC');
529: fnd_message.set_token('SUBINV', L_subinv);
530: return(-1);
531: when others then
532: raise;

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

525:
526: exception
527: when subinv_mismatch then
528: fnd_message.set_name('PJM', 'LOC-DUPLICATE PHY LOC');
529: fnd_message.set_token('SUBINV', L_subinv);
530: return(-1);
531: when others then
532: raise;
533: end Map_Locator;

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

710:
711: IF ((L_allow_xprj_issue = 'N') AND
712: (L_peg_flag IN ('I', 'X')) AND
713: (X_loc_project IS NULL)) THEN
714: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED HARDPEG');
715: RETURN FALSE;
716: END IF;
717:
718: END IF;

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

765: if ( (L_txn_plan_grp is null or L_loc_plan_grp is null)
766: AND (L_txn_plan_grp is not null OR L_loc_plan_grp is not null) ) then
767: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
768: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
769: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
770: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
771: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
772: return FALSE;
773: end if;

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

766: AND (L_txn_plan_grp is not null OR L_loc_plan_grp is not null) ) then
767: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
768: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
769: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
770: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
771: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
772: return FALSE;
773: end if;
774:

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

767: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
768: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
769: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
770: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
771: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
772: return FALSE;
773: end if;
774:
775: /*

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

777: */
778: if ( L_txn_plan_grp <> L_loc_plan_grp ) then
779: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
780: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
781: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
782: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
783: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
784: return FALSE;
785: end if;

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

778: if ( L_txn_plan_grp <> L_loc_plan_grp ) then
779: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
780: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
781: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
782: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
783: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
784: return FALSE;
785: end if;
786:

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

779: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
780: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
781: FND_MESSAGE.SET_NAME('PJM', 'LOC-PLAN GROUP MISMATCH');
782: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
783: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
784: return FALSE;
785: end if;
786:
787: /*

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

796: if ( L_cost_method <> 1 ) then
797: if ( L_txn_cost_grp <> L_loc_cost_grp ) then
798: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
799: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
800: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');
801: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
802: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
803: return FALSE;
804: end if;

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

797: if ( L_txn_cost_grp <> L_loc_cost_grp ) then
798: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
799: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
800: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');
801: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
802: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
803: return FALSE;
804: end if;
805: end if;

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

798: l_txn_prj_ref := Get_Project_References(X_txn_project, NULL);
799: l_loc_prj_ref := Get_Project_References(X_loc_project, NULL);
800: FND_MESSAGE.SET_NAME('PJM', 'LOC-COST GROUP MISMATCH');
801: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
802: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
803: return FALSE;
804: end if;
805: end if;
806: */

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

809: else /* L_allow_xprj_issue = 'N' */
810:
811: l_txn_prj_ref := Get_Project_References(X_txn_project, X_txn_task);
812: l_loc_prj_ref := Get_Project_References(X_loc_project, X_loc_task);
813: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
814: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
815: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
816: return FALSE;
817: end if;

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

810:
811: l_txn_prj_ref := Get_Project_References(X_txn_project, X_txn_task);
812: l_loc_prj_ref := Get_Project_References(X_loc_project, X_loc_task);
813: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
814: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
815: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
816: return FALSE;
817: end if;
818:

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

811: l_txn_prj_ref := Get_Project_References(X_txn_project, X_txn_task);
812: l_loc_prj_ref := Get_Project_References(X_loc_project, X_loc_task);
813: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
814: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
815: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
816: return FALSE;
817: end if;
818:
819: END match_proj_by_plan_grp;

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

948: FETCH C_Proj INTO l_dummy;
949:
950: if ( C_Proj%NOTFOUND ) then
951: CLOSE C_Proj;
952: FND_MESSAGE.SET_NAME('PJM', 'LOC-PROJ NOT CHARGEABLE');
953: FND_MESSAGE.SET_TOKEN('PROJ' , Get_Project_References( l_loc_project_id , null ));
954: return(FALSE);
955: end if;
956:

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

949:
950: if ( C_Proj%NOTFOUND ) then
951: CLOSE C_Proj;
952: FND_MESSAGE.SET_NAME('PJM', 'LOC-PROJ NOT CHARGEABLE');
953: FND_MESSAGE.SET_TOKEN('PROJ' , Get_Project_References( l_loc_project_id , null ));
954: return(FALSE);
955: end if;
956:
957: CLOSE C_Proj;

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

960:
961: if ( pjm_project.val_proj_idtonum( l_loc_project_id
962: , p_organization_id ) is null ) then
963:
964: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
965: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));
966: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);
967: return(FALSE);
968:

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

961: if ( pjm_project.val_proj_idtonum( l_loc_project_id
962: , p_organization_id ) is null ) then
963:
964: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
965: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));
966: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);
967: return(FALSE);
968:
969: end if;

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

962: , p_organization_id ) is null ) then
963:
964: FND_MESSAGE.SET_NAME('PJM' , 'GEN-INVALID PROJ FOR ORG');
965: FND_MESSAGE.SET_TOKEN('PROJECT' , Get_Project_References( l_loc_project_id , null ));
966: FND_MESSAGE.SET_TOKEN('ORG' , l_org_code);
967: return(FALSE);
968:
969: end if;
970:

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

978: FETCH C_Task INTO l_dummy;
979:
980: if ( C_Task%NOTFOUND ) then
981: CLOSE C_Task;
982: FND_MESSAGE.SET_NAME('PJM', 'LOC-TASK NOT CHARGEABLE');
983: FND_MESSAGE.SET_TOKEN('TASK' , Get_Project_References( l_loc_project_id , l_loc_task_id ));
984: return(FALSE);
985: end if;
986:

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

979:
980: if ( C_Task%NOTFOUND ) then
981: CLOSE C_Task;
982: FND_MESSAGE.SET_NAME('PJM', 'LOC-TASK NOT CHARGEABLE');
983: FND_MESSAGE.SET_TOKEN('TASK' , Get_Project_References( l_loc_project_id , l_loc_task_id ));
984: return(FALSE);
985: end if;
986:
987: CLOSE C_Task;

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

1000:
1001: if (l_proj_ref_enabled <> 1) then
1002: if ((l_loc_project_id is not null) or
1003: (l_loc_task_id is not null)) then
1004: FND_MESSAGE.SET_NAME('PJM', 'LOC-ORG NOT PRJ ENABLED');
1005: return (FALSE);
1006: end if;
1007: else
1008: /* If the project_id argument is NULL, then the locator

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

1011: if ((p_project_id is null) and (p_validation_mode = 'SPECIFIC')) then
1012: if (l_loc_project_id is null) then
1013: return (TRUE);
1014: else
1015: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF NOT ALLOWED');
1016: return (FALSE);
1017: end if;
1018: end if;
1019:

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

1026: if (l_proj_control_level = 1) then
1027:
1028: if (p_required_flag = 'Y') then
1029: if (l_loc_project_id is null) then
1030: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED');
1031: return (FALSE);
1032: end if;
1033: end if;
1034:

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

1042:
1043: if (((l_loc_project_id is not null) and (l_loc_task_id is null)) or
1044: ((l_loc_project_id is null) and (l_loc_task_id is not null))) then
1045:
1046: FND_MESSAGE.SET_NAME('PJM', 'LOC-INVALID PRJ REF');
1047: return FALSE;
1048: end if;
1049:
1050: if (p_required_flag = 'Y') then

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

1048: end if;
1049:
1050: if (p_required_flag = 'Y') then
1051: if ((l_loc_project_id is NULL) or (l_loc_task_id is NULL)) then
1052: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF REQUIRED');
1053: return (FALSE);
1054: end if;
1055: end if;
1056: end if; /* l_proj_control_level = 2 */

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

1079: (l_proj_control_level = 2))
1080: ) then
1081: l_txn_prj_ref := Get_Project_References(p_project_id, p_task_id);
1082: l_loc_prj_ref := Get_Project_References(l_loc_project_id, l_loc_task_id);
1083: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
1084: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
1085: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
1086: return (FALSE);
1087: end if;

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

1080: ) then
1081: l_txn_prj_ref := Get_Project_References(p_project_id, p_task_id);
1082: l_loc_prj_ref := Get_Project_References(l_loc_project_id, l_loc_task_id);
1083: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
1084: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
1085: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
1086: return (FALSE);
1087: end if;
1088:

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

1081: l_txn_prj_ref := Get_Project_References(p_project_id, p_task_id);
1082: l_loc_prj_ref := Get_Project_References(l_loc_project_id, l_loc_task_id);
1083: FND_MESSAGE.SET_NAME('PJM', 'LOC-PRJ REF MISMATCH');
1084: FND_MESSAGE.SET_TOKEN('TXN_PRJ_REF',l_txn_prj_ref,FALSE);
1085: FND_MESSAGE.SET_TOKEN('LOC_PRJ_REF',l_loc_prj_ref,FALSE);
1086: return (FALSE);
1087: end if;
1088:
1089: elsif (p_required_flag = 'N') then

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

1358: ** Check whether the locator itself is a valid locator.
1359: ** If yes proceed to other checks, if no error out.
1360: */
1361: if (not get_physical_location(p_organization_id, p_locator_id)) then
1362: fnd_message.set_name('INV','INV_INT_LOCCODE');
1363: raise_application_error(-20001, fnd_message.get);
1364: end if;
1365:
1366: OPEN C4(p_locator_id, p_organization_id);

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

1359: ** If yes proceed to other checks, if no error out.
1360: */
1361: if (not get_physical_location(p_organization_id, p_locator_id)) then
1362: fnd_message.set_name('INV','INV_INT_LOCCODE');
1363: raise_application_error(-20001, fnd_message.get);
1364: end if;
1365:
1366: OPEN C4(p_locator_id, p_organization_id);
1367: FETCH C4 INTO l_phy_loc_id;