874: Exception
875: When Others Then
876:
877: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Build_Exc_Msg(
879: p_pkg_name =>'Inv_Project',
880: p_procedure_name => 'Get_project_info_from_Req');
881:
882: End Get_project_info_from_Req;
914: Exception
915: When Others Then
916:
917: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FND_MSG_PUB.Build_Exc_Msg(
919: p_pkg_name =>'Inv_Project',
920: p_procedure_name => 'Get_project_info_for_RcvTrx');
921:
922: End Get_project_info_for_RcvTrx;
969: Exception
970: When Others Then
971:
972: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
973: FND_MSG_PUB.Build_Exc_Msg(
974: p_pkg_name =>'Inv_Project',
975: p_procedure_name => 'Get_project_loc_for_prj_Req');
976:
977: End Get_project_loc_for_prj_Req;
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029:
1030: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1031: FND_MSG_PUB.Build_Exc_Msg(
1032: p_pkg_name =>'Inv_Project',
1033: p_procedure_name => 'Set_Org_client_info');
1034:
1035: END Set_Org_client_info;
1056: -- with MO_GLOBAL.init
1057: MO_GLOBAL.init('INV');
1058: -- FND_CLIENT_INFO.SET_ORG_CONTEXT(L_OPERATING_UNIT);
1059:
1060: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1061:
1062: EXCEPTION
1063:
1064: WHEN FND_API.G_EXC_ERROR THEN
1063:
1064: WHEN FND_API.G_EXC_ERROR THEN
1065:
1066: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1067: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1068:
1069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1070:
1071: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1068:
1069: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1070:
1071: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1072: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1073:
1074: WHEN OTHERS THEN
1075:
1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1073:
1074: WHEN OTHERS THEN
1075:
1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1077: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1078: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'SET_SESSION_PARAMETERS');
1079: END IF;
1080: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1081:
1074: WHEN OTHERS THEN
1075:
1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1077: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1078: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'SET_SESSION_PARAMETERS');
1079: END IF;
1080: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1081:
1082: END SET_SESSION_PARAMETERS;
1076: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1077: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1078: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'SET_SESSION_PARAMETERS');
1079: END IF;
1080: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1081:
1082: END SET_SESSION_PARAMETERS;
1083:
1084: Procedure get_proj_task_from_lpn(
1127: WHEN OTHERS THEN
1128: x_project_id := NULL;
1129: x_task_id := NULL;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1131: FND_MSG_PUB.Count_And_Get
1132: (p_encoded => FND_API.G_FALSE,
1133: p_count => x_msg_count,
1134: p_data => x_msg_data);
1135: END;
1137: WHEN FND_API.G_EXC_ERROR THEN
1138: x_project_id := NULL;
1139: x_task_id := NULL;
1140: x_return_status := FND_API.G_RET_STS_ERROR ;
1141: FND_MSG_PUB.Count_And_Get
1142: (p_encoded => FND_API.G_FALSE,
1143: p_count => x_msg_count,
1144: p_data => x_msg_data);
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_project_id := NULL;
1147: x_task_id := NULL;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1149: FND_MSG_PUB.Count_And_Get
1150: (p_encoded => FND_API.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data);
1153: WHEN OTHERS THEN
1153: WHEN OTHERS THEN
1154: x_project_id := NULL;
1155: x_task_id := NULL;
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get
1158: (p_encoded => FND_API.G_FALSE,
1159: p_count => x_msg_count,
1160: p_data => x_msg_data);
1161: END get_proj_task_from_lpn;
1289:
1290: X_DISPLAY := 'ALL'||L_RETURN;
1291: X_CONCATENATED := L_CONCAT;
1292:
1293: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1294: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1295:
1296: EXCEPTION
1297: WHEN OTHERS THEN
1300: MYDEBUG('EXCEPTION RAISED IN GET_LOCATOR_METADATA '||SQLERRM);
1301: END IF;
1302:
1303: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1304: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1305: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'GET_LOCATOR_METADATA');
1306: END IF;
1307: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1308:
1301: END IF;
1302:
1303: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1304: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1305: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'GET_LOCATOR_METADATA');
1306: END IF;
1307: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1308:
1309: END GET_LOCATOR_METADATA;
1303: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1304: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1305: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'GET_LOCATOR_METADATA');
1306: END IF;
1307: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1308:
1309: END GET_LOCATOR_METADATA;
1310:
1311: /* Function to get the position of PROJECT column (SEGMENT19) */
1712: END IF;
1713: X_CONCATENATED := L_CONCAT;
1714:
1715:
1716: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1717: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN
1724: END IF;
1725: X_CONCATENATED := null;
1726:
1727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1729: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'conc_loc_qry');
1730: END IF;
1731: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1732:
1725: X_CONCATENATED := null;
1726:
1727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1729: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'conc_loc_qry');
1730: END IF;
1731: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1732:
1733: END CONC_LOC_QRY;
1727: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1729: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'conc_loc_qry');
1730: END IF;
1731: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
1732:
1733: END CONC_LOC_QRY;
1734:
1735: